superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 196
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 198
MNG_AGENCY 1
- Sacramento, City of · 198 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11200 | 11200 | 11199 | {"type": "Polygon", "coordinates": [[[-121.52709, 38.6697], [-121.52707, 38.66974], [-121.52471, 38.66974], [-121.52471, 38.66822], [-121.52709, 38.66822], [-121.52709, 38.6697]]]} | Open Access 1 | Wild Rose Park Site | 27498 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 8.62 | Wild Rose Park Site | ||
11135 | 11135 | 11134 | {"type": "Polygon", "coordinates": [[[-121.54712, 38.65619], [-121.5467, 38.65619], [-121.5466, 38.65618], [-121.54594, 38.65752], [-121.5455, 38.65742], [-121.5451, 38.65737], [-121.54468, 38.65737], [-121.54412, 38.65744], [-121.54408, 38.65743], [-121.54405, 38.65739], [-121.54394, 38.65712], [-121.54385, 38.6568], [-121.54377, 38.65637], [-121.54375, 38.65586], [-121.54377, 38.65583], [-121.54383, 38.6558], [-121.5468, 38.65578], [-121.54678, 38.65585], [-121.54678, 38.65586], [-121.54711, 38.65586], [-121.54712, 38.65619]]]} | Open Access 1 | Westlake Community Park | 27401 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 10.227 | Westlake Community Park | ||
11131 | 11131 | 11130 | {"type": "Polygon", "coordinates": [[[-121.5361, 38.67582], [-121.53603, 38.67614], [-121.53603, 38.67671], [-121.53601, 38.6768], [-121.53598, 38.67683], [-121.53431, 38.67655], [-121.53417, 38.67651], [-121.53405, 38.67645], [-121.53405, 38.67643], [-121.5343, 38.67605], [-121.5345, 38.67571], [-121.53461, 38.67554], [-121.53465, 38.67552], [-121.53478, 38.67558], [-121.53493, 38.67563], [-121.53602, 38.67579], [-121.5361, 38.6758], [-121.5361, 38.67582]]]} | Open Access 1 | Westhampton Park | 27398 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.317 | Westhampton Park | ||
11039 | 11039 | 11038 | {"type": "Polygon", "coordinates": [[[-121.48248, 38.58238], [-121.4821, 38.58326], [-121.48143, 38.58308], [-121.48181, 38.5822], [-121.48248, 38.58238]]]} | Open Access 1 | Washington Park | 27279 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.582 | Washington Park | ||
11019 | 11019 | 11018 | {"type": "Polygon", "coordinates": [[[-121.54774, 38.6485], [-121.5477, 38.64854], [-121.54769, 38.64858], [-121.5477, 38.64918], [-121.54773, 38.64925], [-121.54759, 38.64935], [-121.5476, 38.6497], [-121.54756, 38.64976], [-121.54748, 38.64975], [-121.54687, 38.64977], [-121.54666, 38.64982], [-121.54646, 38.64992], [-121.54643, 38.64804], [-121.54763, 38.64803], [-121.54764, 38.64837], [-121.54774, 38.6485]]]} | Open Access 1 | Warbler Park Site | 27253 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.086 | Warbler Park Site | ||
10779 | 10779 | 10778 | {"type": "Polygon", "coordinates": [[[-121.42536, 38.6435], [-121.42493, 38.64382], [-121.42471, 38.64363], [-121.42514, 38.64332], [-121.42536, 38.6435]]]} | Open Access 1 | Verano Creek Park | 26984 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.355 | Verano Creek Park | ||
10620 | 10620 | 10619 | {"type": "Polygon", "coordinates": [[[-121.53014, 38.67319], [-121.53005, 38.6734], [-121.52989, 38.67369], [-121.5297, 38.67394], [-121.5295, 38.67417], [-121.5292, 38.67444], [-121.52894, 38.67464], [-121.5276, 38.67551], [-121.52658, 38.67386], [-121.52689, 38.67393], [-121.5271, 38.67397], [-121.52771, 38.67398], [-121.52773, 38.67372], [-121.52779, 38.67344], [-121.52787, 38.67331], [-121.52799, 38.67317], [-121.52817, 38.67307], [-121.52869, 38.67285], [-121.52894, 38.67281], [-121.5292, 38.67281], [-121.5295, 38.67289], [-121.52986, 38.67308], [-121.53012, 38.67317], [-121.53014, 38.67319]]]} | Open Access 1 | Valley Oak Park Site | 26795 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.187 | Valley Oak Park Site | ||
10614 | 10614 | 10613 | {"type": "Polygon", "coordinates": [[[-121.42972, 38.46125], [-121.429, 38.46148], [-121.42897, 38.46155], [-121.42882, 38.46155], [-121.42821, 38.46176], [-121.42814, 38.4618], [-121.4281, 38.46184], [-121.42799, 38.46182], [-121.42733, 38.46204], [-121.42728, 38.46212], [-121.42713, 38.46212], [-121.42651, 38.46232], [-121.42642, 38.4624], [-121.42631, 38.46237], [-121.42595, 38.46248], [-121.42563, 38.46283], [-121.4255, 38.46284], [-121.42487, 38.46305], [-121.4248, 38.46312], [-121.42467, 38.4631], [-121.42399, 38.46332], [-121.42392, 38.46318], [-121.42373, 38.46293], [-121.42349, 38.4627], [-121.42382, 38.46247], [-121.4247, 38.46205], [-121.4258, 38.46165], [-121.4262, 38.46143], [-121.42657, 38.46119], [-121.42721, 38.46063], [-121.42734, 38.46039], [-121.42763, 38.46043], [-121.42792, 38.46044], [-121.42807, 38.46043], [-121.42836, 38.46037], [-121.42904, 38.46015], [-121.42911, 38.46015], [-121.42913, 38.46017], [-121.42972, 38.46125]]]} | Open Access 1 | Valley Hi Park | 26790 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 16.238 | Valley Hi Park | ||
10548 | 10548 | 10547 | {"type": "Polygon", "coordinates": [[[-121.47503, 38.58406], [-121.47465, 38.58494], [-121.47365, 38.58467], [-121.47404, 38.58379], [-121.47503, 38.58406]]]} | Open Access 1 | Ulysses S. Grant Park | 26649 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.344 | Ulysses S. Grant Park | ||
10542 | 10542 | 10541 | {"type": "MultiPolygon", "coordinates": [[[[-121.47396, 38.59528], [-121.47304, 38.59734], [-121.47239, 38.5976], [-121.47263, 38.59799], [-121.4714, 38.59854], [-121.47312, 38.59458], [-121.47347, 38.59486], [-121.47374, 38.59514], [-121.47396, 38.59528]]], [[[-121.4752, 38.59647], [-121.4752, 38.59647], [-121.4733, 38.59725], [-121.47409, 38.59542], [-121.47462, 38.59588], [-121.47501, 38.59633], [-121.4752, 38.59647]]]]} | Open Access 1 | Ueda Park Site | 26643 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.816 | Ueda Park Site | ||
10532 | 10532 | 10531 | {"type": "Polygon", "coordinates": [[[-121.53312, 38.61094], [-121.53312, 38.61172], [-121.53237, 38.61172], [-121.5321, 38.61168], [-121.53194, 38.61161], [-121.53182, 38.61154], [-121.53172, 38.61145], [-121.53161, 38.6113], [-121.53161, 38.61127], [-121.53163, 38.61124], [-121.53189, 38.61107], [-121.53206, 38.61091], [-121.5322, 38.61071], [-121.53231, 38.61046], [-121.53312, 38.61094]]]} | Open Access 1 | Two Rivers Park | 26626 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.026 | Two Rivers Park | ||
10387 | 10387 | 10386 | {"type": "Polygon", "coordinates": [[[-121.53648, 38.49043], [-121.53648, 38.49047], [-121.53642, 38.49052], [-121.53616, 38.49063], [-121.53595, 38.49067], [-121.53544, 38.49069], [-121.53535, 38.49071], [-121.53529, 38.49075], [-121.53583, 38.49001], [-121.53582, 38.49007], [-121.53587, 38.49013], [-121.53592, 38.49015], [-121.53603, 38.49016], [-121.53648, 38.49043]]]} | Open Access 1 | Tony Court Park | 26399 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.961 | Tony Court Park | ||
10371 | 10371 | 10370 | {"type": "MultiPolygon", "coordinates": [[[[-121.50733, 38.59675], [-121.50729, 38.59682], [-121.50738, 38.5972], [-121.5074, 38.59761], [-121.50734, 38.59781], [-121.50723, 38.59811], [-121.50701, 38.59849], [-121.50643, 38.59867], [-121.50581, 38.59925], [-121.50554, 38.59901], [-121.50555, 38.59897], [-121.50513, 38.59848], [-121.5052, 38.59849], [-121.50526, 38.59847], [-121.50562, 38.59814], [-121.50573, 38.59807], [-121.50586, 38.59795], [-121.50595, 38.59773], [-121.50603, 38.59761], [-121.50614, 38.59752], [-121.50621, 38.5974], [-121.50633, 38.59728], [-121.50649, 38.59703], [-121.5066, 38.59676], [-121.50669, 38.59664], [-121.5069, 38.59658], [-121.50695, 38.59655], [-121.50697, 38.59646], [-121.50718, 38.59646], [-121.50733, 38.59675]]], [[[-121.50573, 38.59935], [-121.50523, 38.5996], [-121.50524, 38.59896], [-121.50539, 38.59909], [-121.50543, 38.59908], [-121.50573, 38.59935]]]]} | Open Access 1 | Tiscornia Park | 26374 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 7.431 | Tiscornia Park | ||
10324 | 10324 | 10323 | {"type": "Polygon", "coordinates": [[[-121.50778, 38.62205], [-121.5078, 38.62238], [-121.50777, 38.62292], [-121.50767, 38.62361], [-121.50758, 38.62385], [-121.50754, 38.62387], [-121.5075, 38.62387], [-121.50729, 38.6238], [-121.5071, 38.62377], [-121.50636, 38.62377], [-121.50618, 38.62372], [-121.50612, 38.62373], [-121.50607, 38.62377], [-121.50604, 38.62381], [-121.50604, 38.62386], [-121.50593, 38.62389], [-121.50592, 38.6229], [-121.50778, 38.62205]]]} | Open Access 1 | Thomas Jefferson Park | 26307 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.661 | Thomas Jefferson Park | ||
10223 | 10223 | 10222 | {"type": "Polygon", "coordinates": [[[-121.51392, 38.63205], [-121.51336, 38.63205], [-121.51335, 38.63264], [-121.5129, 38.63264], [-121.51247, 38.63303], [-121.51246, 38.63319], [-121.50842, 38.63319], [-121.50831, 38.63318], [-121.50821, 38.63312], [-121.50813, 38.6331], [-121.50805, 38.63313], [-121.508, 38.63319], [-121.50812, 38.63272], [-121.5082, 38.63249], [-121.50841, 38.63205], [-121.50864, 38.63169], [-121.50884, 38.63142], [-121.50919, 38.63103], [-121.5096, 38.63068], [-121.50997, 38.6304], [-121.51355, 38.63043], [-121.51356, 38.63051], [-121.5139, 38.63052], [-121.51392, 38.63205]]]} | Open Access 1 | Tanzanite Community Park (basin 6A) | 26182 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 31.883 | Tanzanite Community Park (basin 6A) | ||
10212 | 10212 | 10211 | {"type": "MultiPolygon", "coordinates": [[[[-121.43402, 38.54235], [-121.43402, 38.54243], [-121.434, 38.5425], [-121.43394, 38.54259], [-121.43371, 38.54281], [-121.43363, 38.54292], [-121.43359, 38.54305], [-121.43357, 38.54317], [-121.43358, 38.5443], [-121.43362, 38.54439], [-121.43377, 38.54461], [-121.43379, 38.54469], [-121.43375, 38.54471], [-121.43354, 38.54472], [-121.43351, 38.54233], [-121.43398, 38.54232], [-121.43402, 38.54235]]], [[[-121.43685, 38.54466], [-121.43681, 38.54469], [-121.43402, 38.54471], [-121.43393, 38.54468], [-121.43387, 38.54451], [-121.43381, 38.54442], [-121.43385, 38.54438], [-121.4338, 38.54423], [-121.4338, 38.54332], [-121.43369, 38.5433], [-121.4337, 38.54312], [-121.43374, 38.54299], [-121.4338, 38.54287], [-121.43387, 38.54278], [-121.43403, 38.54264], [-121.43409, 38.54257], [-121.43418, 38.54232], [-121.4368, 38.54229], [-121.43685, 38.54231], [-121.43685, 38.54466]]]]} | Open Access 1 | Tahoe Park | 26167 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 18.005 | Tahoe Park | ||
10187 | 10187 | 10186 | {"type": "Polygon", "coordinates": [[[-121.51064, 38.67132], [-121.51064, 38.67156], [-121.51061, 38.67177], [-121.51045, 38.67217], [-121.5104, 38.67237], [-121.51039, 38.67252], [-121.51039, 38.67298], [-121.50967, 38.67298], [-121.50959, 38.67305], [-121.50953, 38.67303], [-121.50944, 38.67305], [-121.50936, 38.67298], [-121.50866, 38.67298], [-121.50858, 38.67305], [-121.50851, 38.67303], [-121.50843, 38.67305], [-121.50836, 38.67297], [-121.50796, 38.67298], [-121.50796, 38.67234], [-121.50922, 38.67233], [-121.50934, 38.67231], [-121.50949, 38.67226], [-121.5096, 38.67221], [-121.50973, 38.67212], [-121.50982, 38.67201], [-121.50988, 38.6719], [-121.50992, 38.67174], [-121.50991, 38.67116], [-121.5104, 38.67115], [-121.51041, 38.67122], [-121.51047, 38.67128], [-121.51055, 38.67131], [-121.51064, 38.67132]]]} | Open Access 1 | Sycamore Park | 26138 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.838 | Sycamore Park | ||
10168 | 10168 | 10167 | {"type": "Polygon", "coordinates": [[[-121.41932, 38.54467], [-121.41929, 38.54649], [-121.41847, 38.54648], [-121.41702, 38.54466], [-121.41932, 38.54467]]]} | Open Access 1 | Tahoe Tallac Park | 26168 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.773 | Tahoe Tallac Park | ||
10154 | 10154 | 10153 | {"type": "Polygon", "coordinates": [[[-121.55006, 38.64762], [-121.5497, 38.64762], [-121.5496, 38.64772], [-121.54954, 38.6477], [-121.54901, 38.64771], [-121.54896, 38.64772], [-121.54885, 38.64763], [-121.54849, 38.64763], [-121.54847, 38.6466], [-121.5485, 38.64646], [-121.54858, 38.64634], [-121.54874, 38.6462], [-121.54891, 38.64608], [-121.54904, 38.64602], [-121.54922, 38.646], [-121.54938, 38.646], [-121.54954, 38.64605], [-121.54965, 38.6461], [-121.54987, 38.64625], [-121.54998, 38.64638], [-121.55002, 38.64645], [-121.55005, 38.64655], [-121.55006, 38.64762]]]} | Open Access 1 | Swainson's Hawk Park Site | 26091 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.696 | Swainson's Hawk Park Site | ||
10132 | 10132 | 10131 | {"type": "Polygon", "coordinates": [[[-121.45555, 38.55759], [-121.45548, 38.55775], [-121.45419, 38.55739], [-121.45387, 38.55726], [-121.45385, 38.55722], [-121.45386, 38.55719], [-121.4539, 38.55718], [-121.4543, 38.55725], [-121.45555, 38.55759]]]} | Open Access 1 | Sunset Park | 26059 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.632 | Sunset 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]);