superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3208 | 3208 | 3207 | {"type": "MultiPolygon", "coordinates": [[[[-121.54638, 38.60138], [-121.54637, 38.60333], [-121.54595, 38.60333], [-121.54563, 38.60336], [-121.54532, 38.60343], [-121.54502, 38.60353], [-121.54564, 38.60269], [-121.54556, 38.60254], [-121.54638, 38.60138]]], [[[-121.54666, 38.59963], [-121.54579, 38.60083], [-121.54517, 38.60174], [-121.54517, 38.59971], [-121.54559, 38.59963], [-121.54591, 38.5996], [-121.54632, 38.5996], [-121.54666, 38.59963]]]]} | Open Access 1 | Costa Park Site | 17672 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.741 | Costa Park Site | ||
3210 | 3210 | 3209 | {"type": "Polygon", "coordinates": [[[-121.42814, 38.45798], [-121.42812, 38.45801], [-121.42806, 38.45802], [-121.42748, 38.45801], [-121.42639, 38.45801], [-121.42559, 38.45798], [-121.42546, 38.45681], [-121.42785, 38.45651], [-121.42814, 38.45798]]]} | Open Access 1 | Cosumnes River College Park | 17674 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.069 | Cosumnes River College Park | ||
3230 | 3230 | 3229 | {"type": "Polygon", "coordinates": [[[-121.49696, 38.65967], [-121.49671, 38.65975], [-121.49648, 38.65985], [-121.49626, 38.65998], [-121.49606, 38.66013], [-121.496, 38.66013], [-121.4959, 38.66007], [-121.49574, 38.65996], [-121.49561, 38.65983], [-121.49545, 38.65962], [-121.49537, 38.65947], [-121.49531, 38.65928], [-121.49528, 38.65912], [-121.49528, 38.65855], [-121.49533, 38.65852], [-121.49581, 38.65851], [-121.49618, 38.65848], [-121.49656, 38.65842], [-121.49671, 38.65837], [-121.49673, 38.65902], [-121.49685, 38.65933], [-121.49696, 38.65967]]]} | Open Access 1 | Cottonwood Park | 17691 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.986 | Cottonwood Park | ||
3313 | 3313 | 3312 | {"type": "Polygon", "coordinates": [[[-121.46115, 38.56625], [-121.46113, 38.56629], [-121.46094, 38.5663], [-121.46078, 38.56628], [-121.46062, 38.56624], [-121.46046, 38.56617], [-121.46033, 38.56608], [-121.46035, 38.56603], [-121.46115, 38.56625]]]} | Open Access 1 | Crescent Park | 17796 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.208 | Crescent Park | ||
3336 | 3336 | 3335 | {"type": "MultiPolygon", "coordinates": [[[[-121.50611, 38.57814], [-121.50593, 38.57856], [-121.50485, 38.57827], [-121.50503, 38.57785], [-121.50611, 38.57814]]], [[[-121.50632, 38.57767], [-121.50614, 38.57809], [-121.50505, 38.5778], [-121.50523, 38.57738], [-121.50632, 38.57767]]]]} | Open Access 1 | Crocker Park | 17825 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.428 | Crocker Park | ||
3436 | 3436 | 3435 | {"type": "Polygon", "coordinates": [[[-121.41239, 38.50369], [-121.4122, 38.50367], [-121.41191, 38.5036], [-121.41174, 38.50359], [-121.40933, 38.5036], [-121.40928, 38.50358], [-121.40925, 38.50354], [-121.4092, 38.50164], [-121.41003, 38.50165], [-121.41005, 38.50189], [-121.41194, 38.50188], [-121.41194, 38.50279], [-121.41193, 38.50288], [-121.41195, 38.50295], [-121.41196, 38.5033], [-121.41239, 38.50331], [-121.41239, 38.50369]]]} | Open Access 1 | Danny Nunn Park | 17922 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.956 | Danny Nunn Park | ||
3639 | 3639 | 3638 | {"type": "Polygon", "coordinates": [[[-121.53015, 38.68079], [-121.53013, 38.68082], [-121.52984, 38.68094], [-121.52942, 38.68102], [-121.52882, 38.68103], [-121.52866, 38.68106], [-121.52849, 38.68076], [-121.52848, 38.6801], [-121.52975, 38.6801], [-121.52978, 38.68015], [-121.52975, 38.68021], [-121.52977, 38.6803], [-121.52982, 38.68045], [-121.52996, 38.68063], [-121.53006, 38.68072], [-121.53014, 38.68075], [-121.53015, 38.68079]]]} | Open Access 1 | Dogwood Park Site | 18186 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.016 | Dogwood Park Site | ||
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-121.53484, 38.68257], [-121.53481, 38.68262], [-121.53481, 38.68311], [-121.53416, 38.68311], [-121.53411, 38.68309], [-121.53409, 38.68305], [-121.53409, 38.68196], [-121.5341, 38.68193], [-121.53416, 38.68191], [-121.53472, 38.68191], [-121.53477, 38.68193], [-121.53479, 38.68197], [-121.53479, 38.68236], [-121.53476, 38.68247], [-121.53479, 38.68253], [-121.53484, 38.68257]]]} | Open Access 1 | Golden Poppy Park Site | 19370 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.034 | Golden Poppy Park Site | ||
3779 | 3779 | 3778 | {"type": "Polygon", "coordinates": [[[-121.41887, 38.52701], [-121.41887, 38.52784], [-121.41639, 38.52784], [-121.4164, 38.52697], [-121.41887, 38.52701]]]} | Open Access 1 | Earl Warren Park | 18354 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.007 | Earl Warren Park | ||
3782 | 3782 | 3781 | {"type": "Polygon", "coordinates": [[[-121.43954, 38.54796], [-121.43925, 38.54796], [-121.43924, 38.54707], [-121.43947, 38.54706], [-121.43948, 38.5472], [-121.43953, 38.54721], [-121.43954, 38.54796]]]} | Open Access 1 | Greenfair Park | 19476 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.599 | Greenfair Park | ||
3797 | 3797 | 3796 | {"type": "Polygon", "coordinates": [[[-121.45286, 38.56331], [-121.45268, 38.56368], [-121.45263, 38.56369], [-121.45236, 38.56362], [-121.45254, 38.56322], [-121.45286, 38.56331]]]} | Open Access 1 | East Lawn Childrens Park | 18376 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.33 | East Lawn Childrens Park | ||
3799 | 3799 | 3798 | {"type": "Polygon", "coordinates": [[[-121.44274, 38.56401], [-121.44259, 38.56436], [-121.4422, 38.56426], [-121.44203, 38.56461], [-121.44198, 38.56461], [-121.44189, 38.56482], [-121.4414, 38.56469], [-121.44111, 38.56537], [-121.44019, 38.56513], [-121.44106, 38.56312], [-121.44249, 38.56349], [-121.44248, 38.56354], [-121.44274, 38.56401]]]} | Open Access 1 | East Portal Park | 18379 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 7.36 | East Portal Park | ||
3868 | 3868 | 3867 | {"type": "Polygon", "coordinates": [[[-121.47357, 38.4861], [-121.47167, 38.48617], [-121.47167, 38.48616], [-121.47171, 38.48611], [-121.47223, 38.48592], [-121.47289, 38.48556], [-121.47313, 38.48548], [-121.47341, 38.48542], [-121.47357, 38.4861]]]} | Open Access 1 | Edward Kemble Park | 18457 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.745 | Edward Kemble Park | ||
3870 | 3870 | 3869 | {"type": "Polygon", "coordinates": [[[-121.50809, 38.48685], [-121.50809, 38.4869], [-121.50806, 38.48692], [-121.50752, 38.48709], [-121.5074, 38.48708], [-121.50731, 38.48712], [-121.50725, 38.48706], [-121.50686, 38.48709], [-121.50671, 38.48606], [-121.50754, 38.48607], [-121.50755, 38.48609], [-121.50757, 38.4861], [-121.5076, 38.48624], [-121.50767, 38.48638], [-121.50773, 38.48646], [-121.508, 38.48671], [-121.50809, 38.48685]]]} | Open Access 1 | Edwin Z'berg Park | 18461 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.479 | Edwin Z'berg Park | ||
3873 | 3873 | 3872 | {"type": "Polygon", "coordinates": [[[-121.54694, 38.6659], [-121.54415, 38.66702], [-121.54415, 38.66693], [-121.54408, 38.66682], [-121.54401, 38.66683], [-121.5437, 38.66634], [-121.54462, 38.66597], [-121.54509, 38.66576], [-121.54527, 38.66602], [-121.54537, 38.66599], [-121.54548, 38.66591], [-121.54555, 38.66582], [-121.54559, 38.66571], [-121.54565, 38.66571], [-121.54566, 38.66579], [-121.54573, 38.66585], [-121.5458, 38.66587], [-121.54588, 38.66586], [-121.54632, 38.66568], [-121.54635, 38.66565], [-121.54637, 38.6656], [-121.54635, 38.66552], [-121.54673, 38.66552], [-121.54681, 38.66549], [-121.54683, 38.66554], [-121.5468, 38.66557], [-121.54685, 38.66564], [-121.54688, 38.66578], [-121.54694, 38.6659]]]} | Open Access 1 | Egret Park | 18467 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.721 | Egret Park | ||
3931 | 3931 | 3930 | {"type": "Polygon", "coordinates": [[[-121.52527, 38.67891], [-121.52528, 38.67894], [-121.52528, 38.67945], [-121.52525, 38.67979], [-121.52524, 38.67981], [-121.52518, 38.67983], [-121.5248, 38.67981], [-121.52421, 38.67972], [-121.52433, 38.67886], [-121.52475, 38.67888], [-121.52521, 38.67888], [-121.52527, 38.67891]]]} | Open Access 1 | Elderberry Park | 18550 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.183 | Elderberry Park | ||
3990 | 3990 | 3989 | {"type": "Polygon", "coordinates": [[[-121.52639, 38.5281], [-121.52638, 38.52814], [-121.52552, 38.5284], [-121.52531, 38.52841], [-121.52508, 38.52837], [-121.52473, 38.52821], [-121.52433, 38.52795], [-121.52403, 38.52767], [-121.52377, 38.52737], [-121.52377, 38.52733], [-121.52417, 38.5271], [-121.52436, 38.52702], [-121.5247, 38.52694], [-121.52501, 38.52691], [-121.52529, 38.52692], [-121.52548, 38.52696], [-121.5257, 38.52706], [-121.52588, 38.52718], [-121.52598, 38.52728], [-121.52606, 38.52741], [-121.52639, 38.5281]]]} | Open Access 1 | Emil Bahnfleth Park | 18627 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.273 | Emil Bahnfleth Park | ||
3992 | 3992 | 3991 | {"type": "Polygon", "coordinates": [[[-121.49238, 38.58624], [-121.492, 38.58712], [-121.4916, 38.58701], [-121.49198, 38.58613], [-121.49238, 38.58624]]]} | Open Access 1 | Emiliano Zapata Park | 18629 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.955 | Emiliano Zapata Park | ||
4099 | 4099 | 4098 | {"type": "Polygon", "coordinates": [[[-121.54328, 38.50023], [-121.54324, 38.50055], [-121.54269, 38.50051], [-121.54277, 38.50022], [-121.54289, 38.50019], [-121.54328, 38.50023]]]} | Open Access 1 | Evelyn Dutra Park | 18759 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.413 | Evelyn Dutra Park | ||
4167 | 4167 | 4166 | {"type": "MultiPolygon", "coordinates": [[[[-121.40358, 38.44966], [-121.40323, 38.44988], [-121.40321, 38.44992], [-121.40314, 38.44992], [-121.40308, 38.44995], [-121.40304, 38.45003], [-121.40298, 38.45003], [-121.40187, 38.45092], [-121.40186, 38.45097], [-121.40177, 38.45101], [-121.40172, 38.45108], [-121.40166, 38.45109], [-121.40142, 38.45128], [-121.4011, 38.45103], [-121.40134, 38.45084], [-121.40134, 38.45079], [-121.40144, 38.45076], [-121.40147, 38.45072], [-121.40148, 38.45068], [-121.40154, 38.45067], [-121.40271, 38.44975], [-121.40272, 38.4497], [-121.40282, 38.44966], [-121.40286, 38.44959], [-121.40291, 38.44958], [-121.40325, 38.44934], [-121.40358, 38.44966]]], [[[-121.40435, 38.44886], [-121.4041, 38.44916], [-121.40398, 38.44968], [-121.40393, 38.4497], [-121.4036, 38.44935], [-121.40317, 38.44901], [-121.40321, 38.44897], [-121.4038, 38.44891], [-121.40417, 38.44871], [-121.40435, 38.44886]]]]} | Open Access 1 | Fales Park | 18829 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.802 | Fales Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);