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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1811 | 1811 | 1810 | {"type": "Polygon", "coordinates": [[[-121.41952, 38.50592], [-121.41951, 38.5072], [-121.41886, 38.5072], [-121.41886, 38.50592], [-121.41952, 38.50592]]]} | Open Access 1 | Camellia Park | 16757 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.007 | Camellia Park | ||
1924 | 1924 | 1923 | {"type": "Polygon", "coordinates": [[[-121.51491, 38.5236], [-121.51465, 38.5244], [-121.51462, 38.52444], [-121.51421, 38.52441], [-121.513, 38.5244], [-121.51288, 38.52318], [-121.51325, 38.52319], [-121.51337, 38.52321], [-121.51389, 38.5234], [-121.51491, 38.5236]]]} | Open Access 1 | Bell Cooledge Park (south) | 15972 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.6 | Bell Cooledge Park (south) | ||
1975 | 1975 | 1974 | {"type": "Polygon", "coordinates": [[[-121.44418, 38.57641], [-121.44386, 38.57722], [-121.44264, 38.57692], [-121.44285, 38.57644], [-121.44297, 38.57628], [-121.44312, 38.57613], [-121.44418, 38.57641]]]} | Open Access 1 | Bertha Henschel Park | 16039 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.544 | Bertha Henschel Park | ||
2012 | 2012 | 2011 | {"type": "Polygon", "coordinates": [[[-121.41842, 38.53594], [-121.41841, 38.53668], [-121.4181, 38.53669], [-121.41811, 38.53715], [-121.41717, 38.53715], [-121.41717, 38.53667], [-121.41657, 38.53666], [-121.41657, 38.53593], [-121.41842, 38.53594]]]} | Open Access 1 | Bill Bean Jr. Memorial Park | 16101 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.34 | Bill Bean Jr. Memorial Park | ||
2039 | 2039 | 2038 | {"type": "Polygon", "coordinates": [[[-121.54805, 38.65366], [-121.54371, 38.65373], [-121.54371, 38.65373], [-121.54373, 38.65347], [-121.54381, 38.6532], [-121.5441, 38.65269], [-121.54414, 38.65266], [-121.54417, 38.65266], [-121.54447, 38.65269], [-121.54786, 38.65266], [-121.54803, 38.65268], [-121.54805, 38.65366]]]} | Open Access 1 | Blackbird Park Site | 16141 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 10.175 | Blackbird Park Site | ||
2077 | 2077 | 2076 | {"type": "Polygon", "coordinates": [[[-121.5211, 38.67146], [-121.52034, 38.6716], [-121.52019, 38.6711], [-121.52096, 38.67095], [-121.5211, 38.67146]]]} | Open Access 1 | Blue Oak Park | 16180 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.981 | Blue Oak Park | ||
2271 | 2271 | 2270 | {"type": "MultiPolygon", "coordinates": [[[[-121.4915, 38.54409], [-121.49131, 38.54436], [-121.49116, 38.54469], [-121.49106, 38.54476], [-121.49097, 38.54478], [-121.49093, 38.54475], [-121.49092, 38.54471], [-121.49115, 38.54402], [-121.4912, 38.54398], [-121.49145, 38.54403], [-121.49149, 38.54405], [-121.4915, 38.54409]]], [[[-121.49155, 38.54385], [-121.49153, 38.54389], [-121.49148, 38.5439], [-121.49126, 38.54386], [-121.49122, 38.54381], [-121.49141, 38.54321], [-121.49146, 38.54318], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49158, 38.54335], [-121.49154, 38.54364], [-121.49155, 38.54385]]]]} | Open Access 1 | Brockway Park | 16413 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.923 | Brockway Park | ||
2360 | 2360 | 2359 | {"type": "Polygon", "coordinates": [[[-121.51929, 38.67551], [-121.51923, 38.67555], [-121.51859, 38.67566], [-121.51808, 38.6758], [-121.51802, 38.67579], [-121.51799, 38.67577], [-121.51793, 38.67564], [-121.51786, 38.67546], [-121.51772, 38.67469], [-121.51768, 38.67457], [-121.51756, 38.67438], [-121.51739, 38.67423], [-121.51718, 38.67412], [-121.51691, 38.67406], [-121.51659, 38.67406], [-121.51653, 38.67403], [-121.51653, 38.67391], [-121.51658, 38.67379], [-121.51691, 38.67323], [-121.51705, 38.67309], [-121.51706, 38.67302], [-121.51701, 38.67294], [-121.51708, 38.67287], [-121.51713, 38.67286], [-121.51715, 38.67284], [-121.51715, 38.67283], [-121.51711, 38.6728], [-121.51729, 38.67262], [-121.51766, 38.67279], [-121.51799, 38.67289], [-121.51843, 38.67298], [-121.51893, 38.67301], [-121.51897, 38.67304], [-121.51896, 38.67377], [-121.51898, 38.67406], [-121.51905, 38.67455], [-121.51929, 38.67547], [-121.51929, 38.67551]]]} | Open Access 1 | Burberry Community Park | 16512 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.799 | Burberry Community Park | ||
2449 | 2449 | 2448 | {"type": "Polygon", "coordinates": [[[-121.47119, 38.54916], [-121.46908, 38.54859], [-121.46921, 38.54825], [-121.4674, 38.54775], [-121.46783, 38.54674], [-121.47117, 38.54673], [-121.47119, 38.54916]]]} | Open Access 1 | C.K. McClatchy Park | 16629 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 15.193 | C.K. McClatchy Park | ||
2464 | 2464 | 2463 | {"type": "Polygon", "coordinates": [[[-121.51769, 38.52549], [-121.51733, 38.52654], [-121.51561, 38.52607], [-121.51615, 38.52487], [-121.51653, 38.52496], [-121.51707, 38.52504], [-121.51708, 38.52545], [-121.51769, 38.52549]]]} | Restricted Access 2 | Cabrillo School Park | 16644 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.006 | Cabrillo School Park | ||
2519 | 2519 | 2518 | {"type": "Polygon", "coordinates": [[[-121.49698, 38.67214], [-121.49581, 38.67215], [-121.49575, 38.6712], [-121.49575, 38.67097], [-121.49576, 38.67093], [-121.49582, 38.67091], [-121.49682, 38.67091], [-121.49682, 38.67126], [-121.49686, 38.6716], [-121.49692, 38.67192], [-121.49698, 38.67214]]]} | Open Access 1 | California Lilac Park | 16718 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.244 | California Lilac Park | ||
2813 | 2813 | 2812 | {"type": "Polygon", "coordinates": [[[-121.49463, 38.58074], [-121.49425, 38.58162], [-121.49317, 38.58133], [-121.49355, 38.58045], [-121.49463, 38.58074]]]} | Open Access 1 | Cesar E. Chavez Plaza | 17105 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.536 | Cesar E. Chavez Plaza | ||
2851 | 2851 | 2850 | {"type": "Polygon", "coordinates": [[[-121.45969, 38.63169], [-121.45705, 38.63166], [-121.45705, 38.63023], [-121.45968, 38.63026], [-121.45969, 38.63169]]]} | Open Access 1 | Charles Robertson Park | 17142 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.052 | Charles Robertson Park | ||
2855 | 2855 | 2854 | {"type": "Polygon", "coordinates": [[[-121.50622, 38.50363], [-121.50617, 38.50614], [-121.50582, 38.50614], [-121.50585, 38.50608], [-121.50596, 38.50602], [-121.50599, 38.50597], [-121.50598, 38.50588], [-121.50591, 38.50584], [-121.50581, 38.50584], [-121.50575, 38.50587], [-121.50572, 38.50591], [-121.50558, 38.50591], [-121.50563, 38.50416], [-121.50568, 38.50412], [-121.50591, 38.50363], [-121.50622, 38.50363]]]} | Open Access 1 | Charlie Jensen Park | 17146 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.128 | Charlie Jensen Park | ||
2860 | 2860 | 2859 | {"type": "Polygon", "coordinates": [[[-121.54287, 38.48454], [-121.54187, 38.48493], [-121.54142, 38.48517], [-121.54135, 38.48511], [-121.54076, 38.48491], [-121.54058, 38.48492], [-121.54054, 38.48497], [-121.54054, 38.48505], [-121.54053, 38.48508], [-121.54043, 38.48514], [-121.54036, 38.48515], [-121.54031, 38.4851], [-121.54038, 38.48394], [-121.54034, 38.48386], [-121.54044, 38.48383], [-121.54282, 38.4844], [-121.54287, 38.48454]]]} | Open Access 1 | Charter Pointe Park | 17152 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.869 | Charter Pointe Park | ||
2899 | 2899 | 2898 | {"type": "Polygon", "coordinates": [[[-121.53019, 38.52879], [-121.53015, 38.52925], [-121.52935, 38.53048], [-121.52854, 38.53097], [-121.52849, 38.53092], [-121.52904, 38.53014], [-121.52869, 38.52987], [-121.52878, 38.52961], [-121.52873, 38.52846], [-121.52867, 38.52796], [-121.52852, 38.52757], [-121.52833, 38.52725], [-121.52782, 38.52648], [-121.52739, 38.52607], [-121.52728, 38.52599], [-121.52778, 38.52564], [-121.52884, 38.52658], [-121.52956, 38.52731], [-121.53, 38.52791], [-121.52998, 38.5285], [-121.53019, 38.52879]]]} | Open Access 1 | Chicory Bend Park | 17193 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 12.718 | Chicory Bend Park | ||
2913 | 2913 | 2912 | {"type": "Polygon", "coordinates": [[[-121.44839, 38.60939], [-121.44839, 38.60953], [-121.44794, 38.60953], [-121.44795, 38.60939], [-121.44839, 38.60939]]]} | Open Access 1 | Dixieanne Tot Lot | 18171 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.152 | Dixieanne Tot Lot | ||
2928 | 2928 | 2927 | {"type": "Polygon", "coordinates": [[[-121.4893, 38.63101], [-121.48854, 38.63146], [-121.48832, 38.63121], [-121.48812, 38.63094], [-121.4879, 38.63059], [-121.48776, 38.63033], [-121.4876, 38.62998], [-121.48751, 38.62973], [-121.4874, 38.62935], [-121.48738, 38.62926], [-121.4874, 38.62922], [-121.48744, 38.6292], [-121.4876, 38.62918], [-121.48856, 38.62911], [-121.48898, 38.63034], [-121.48917, 38.63085], [-121.48921, 38.63092], [-121.4893, 38.63101]]]} | Open Access 1 | Chuckwagon Park | 17237 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.955 | Chuckwagon Park | ||
3106 | 3106 | 3105 | {"type": "Polygon", "coordinates": [[[-121.45137, 38.55665], [-121.45077, 38.55797], [-121.44992, 38.55774], [-121.45051, 38.55641], [-121.45137, 38.55665]]]} | Open Access 1 | Coloma Park | 17525 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.043 | Coloma Park | ||
3156 | 3156 | 3155 | {"type": "Polygon", "coordinates": [[[-121.54229, 38.48581], [-121.54226, 38.48585], [-121.54184, 38.48591], [-121.5417, 38.48591], [-121.54162, 38.48595], [-121.54159, 38.486], [-121.54102, 38.48588], [-121.54172, 38.48551], [-121.54172, 38.48543], [-121.54229, 38.48517], [-121.54225, 38.48521], [-121.54223, 38.48526], [-121.54226, 38.48535], [-121.54225, 38.48555], [-121.54229, 38.48581]]]} | Open Access 1 | Cool Wind Way Park | 17618 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.159 | Cool Wind Way 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]);