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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7387 | 7387 | 7386 | {"type": "Polygon", "coordinates": [[[-121.48198, 38.61066], [-121.48122, 38.61086], [-121.48, 38.61066], [-121.47978, 38.61008], [-121.48129, 38.60973], [-121.48148, 38.60972], [-121.48156, 38.60967], [-121.48157, 38.60959], [-121.48198, 38.61066]]]} | Open Access 1 | Ninos Park | 22763 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.203 | Ninos Park | ||
7388 | 7388 | 7387 | {"type": "Polygon", "coordinates": [[[-121.48467, 38.63479], [-121.48396, 38.63479], [-121.48395, 38.63064], [-121.4839, 38.62766], [-121.48398, 38.62738], [-121.48398, 38.62447], [-121.48392, 38.6202], [-121.48391, 38.61572], [-121.48158, 38.60961], [-121.48066, 38.60731], [-121.48155, 38.60756], [-121.48223, 38.60933], [-121.48292, 38.60918], [-121.48295, 38.61127], [-121.48461, 38.61565], [-121.4846, 38.62039], [-121.48463, 38.62196], [-121.48465, 38.63205], [-121.48467, 38.63479]]]} | Open Access 1 | Ninos Parkway | 22764 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 47.824 | Ninos Parkway | ||
7444 | 7444 | 7443 | {"type": "Polygon", "coordinates": [[[-121.43065, 38.44173], [-121.43038, 38.44183], [-121.43018, 38.44193], [-121.42995, 38.44208], [-121.42974, 38.44226], [-121.42779, 38.44444], [-121.42753, 38.44467], [-121.42719, 38.44487], [-121.4268, 38.44501], [-121.42653, 38.44506], [-121.42632, 38.44508], [-121.42605, 38.44509], [-121.42598, 38.44506], [-121.42597, 38.44502], [-121.42595, 38.44305], [-121.42592, 38.44275], [-121.42584, 38.44245], [-121.42573, 38.4422], [-121.42562, 38.44203], [-121.42536, 38.44167], [-121.42713, 38.44181], [-121.42869, 38.44197], [-121.42893, 38.44195], [-121.43014, 38.44175], [-121.43048, 38.44172], [-121.43065, 38.44173]]]} | Open Access 1 | North Laguna Creek Park | 22827 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 21.438 | North Laguna Creek Park | ||
7457 | 7457 | 7456 | {"type": "Polygon", "coordinates": [[[-121.50408, 38.66559], [-121.5041, 38.66563], [-121.50412, 38.66683], [-121.50411, 38.66706], [-121.50407, 38.66733], [-121.50398, 38.66759], [-121.50383, 38.66788], [-121.50364, 38.66814], [-121.50349, 38.66829], [-121.50346, 38.66831], [-121.50341, 38.66831], [-121.50332, 38.66827], [-121.49851, 38.66569], [-121.49885, 38.66508], [-121.49883, 38.66503], [-121.4989, 38.665], [-121.4992, 38.66445], [-121.49919, 38.66438], [-121.49925, 38.66436], [-121.49955, 38.66382], [-121.49952, 38.66375], [-121.49959, 38.66372], [-121.49964, 38.66367], [-121.50021, 38.66263], [-121.50023, 38.66256], [-121.50021, 38.66249], [-121.50032, 38.66243], [-121.50046, 38.66217], [-121.50046, 38.66182], [-121.50055, 38.66182], [-121.50061, 38.66181], [-121.50066, 38.66178], [-121.50071, 38.66172], [-121.50067, 38.65979], [-121.50067, 38.65973], [-121.50069, 38.6597], [-121.50074, 38.65968], [-121.50198, 38.65967], [-121.50201, 38.662], [-121.50189, 38.662], [-121.50175, 38.66197], [-121.50167, 38.66199], [-121.50162, 38.66203], [-121.5016, 38.66208], [-121.50159, 38.66218], [-121.50089, 38.66306], [-121.50086, 38.66311], [-121.50086, 38.66319], [-121.50079, 38.6632], [-121.50039, 38.6637], [-121.50032, 38.6637], [-121.50025, 38.66375], [-121.50023, 38.66382], [-121.50027, 38.66388], [-121.49935, 38.66504], [-121.49959, 38.66517], [-121.49966, 38.66517], [-121.49968, 38.66521], [-121.49972, 38.66526], [-121.49997, 38.6654], [-121.50027, 38.66551], [-121.50056, 38.66557], [-121.50093, 38.66558], [-121.50402, 38.66557], [-121.50408, 38.66559]]]} | Open Access 1 | North Natomas Community Park | 22832 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 35.356 | North Natomas Community Park | ||
7461 | 7461 | 7460 | {"type": "Polygon", "coordinates": [[[-121.54627, 38.51423], [-121.54497, 38.5146], [-121.54474, 38.51413], [-121.54556, 38.51393], [-121.54592, 38.51391], [-121.54607, 38.51387], [-121.54627, 38.51423]]]} | Open Access 1 | North Point Way River Access | 22847 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.531 | North Point Way River Access | ||
7462 | 7462 | 7461 | {"type": "Polygon", "coordinates": [[[-121.45979, 38.65635], [-121.45981, 38.65646], [-121.45983, 38.65691], [-121.4598, 38.65703], [-121.45975, 38.65714], [-121.45968, 38.65724], [-121.45959, 38.65733], [-121.45949, 38.65741], [-121.45936, 38.65748], [-121.4591, 38.65757], [-121.45889, 38.65759], [-121.45847, 38.65759], [-121.45842, 38.65756], [-121.4584, 38.65753], [-121.4584, 38.65736], [-121.45844, 38.65721], [-121.4585, 38.65709], [-121.45866, 38.65689], [-121.45871, 38.65689], [-121.45907, 38.65697], [-121.45946, 38.65698], [-121.4596, 38.65704], [-121.45966, 38.65703], [-121.45972, 38.657], [-121.45974, 38.65697], [-121.45975, 38.65692], [-121.45979, 38.65692], [-121.4598, 38.65685], [-121.45978, 38.6565], [-121.45975, 38.65632], [-121.45979, 38.65635]]]} | Open Access 1 | North Pointe Park | 22848 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.723 | North Pointe Park | ||
7475 | 7475 | 7474 | {"type": "Polygon", "coordinates": [[[-121.5177, 38.66983], [-121.5169, 38.67021], [-121.51642, 38.67058], [-121.51606, 38.6706], [-121.51578, 38.67086], [-121.51571, 38.67089], [-121.51567, 38.67096], [-121.51565, 38.67096], [-121.5154, 38.6712], [-121.51514, 38.67108], [-121.51483, 38.67095], [-121.51503, 38.66995], [-121.5151, 38.66999], [-121.51521, 38.66999], [-121.51528, 38.67012], [-121.51605, 38.6701], [-121.5161, 38.67013], [-121.51617, 38.67013], [-121.51626, 38.67008], [-121.51669, 38.66998], [-121.51698, 38.6698], [-121.51699, 38.66974], [-121.51708, 38.66972], [-121.51714, 38.66967], [-121.51748, 38.66951], [-121.5177, 38.66983]]]} | Open Access 1 | Northborough Park | 22866 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.036 | Northborough Park | ||
7482 | 7482 | 7481 | {"type": "Polygon", "coordinates": [[[-121.49168, 38.61834], [-121.49131, 38.61829], [-121.49096, 38.61831], [-121.48973, 38.6183], [-121.48946, 38.61826], [-121.48916, 38.61813], [-121.48866, 38.61801], [-121.48843, 38.618], [-121.48843, 38.61703], [-121.48846, 38.61687], [-121.4885, 38.61676], [-121.48859, 38.61662], [-121.48887, 38.61628], [-121.4891, 38.61594], [-121.48914, 38.61592], [-121.48951, 38.61597], [-121.49132, 38.61599], [-121.49168, 38.61834]]]} | Open Access 1 | Northgate Park | 22874 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 15.863 | Northgate Park | ||
7509 | 7509 | 7508 | {"type": "Polygon", "coordinates": [[[-121.45478, 38.629], [-121.45478, 38.62935], [-121.45482, 38.62944], [-121.4549, 38.62949], [-121.45515, 38.62952], [-121.45534, 38.62959], [-121.45551, 38.62971], [-121.45563, 38.62985], [-121.45568, 38.62995], [-121.45571, 38.63009], [-121.4557, 38.63023], [-121.45566, 38.63035], [-121.45556, 38.63049], [-121.45544, 38.6306], [-121.45528, 38.63069], [-121.45511, 38.63074], [-121.45498, 38.63076], [-121.45386, 38.63075], [-121.45385, 38.62985], [-121.45392, 38.62982], [-121.45397, 38.62978], [-121.454, 38.62967], [-121.45398, 38.6296], [-121.45385, 38.62944], [-121.45385, 38.62894], [-121.45473, 38.62895], [-121.45476, 38.62896], [-121.45478, 38.629]]]} | Open Access 1 | Nuevo Park | 22936 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.193 | Nuevo Park | ||
7539 | 7539 | 7538 | {"type": "Polygon", "coordinates": [[[-121.50573, 38.5653], [-121.50536, 38.56616], [-121.50299, 38.56552], [-121.50337, 38.56466], [-121.50573, 38.5653]]]} | Open Access 1 | O'Neil Field | 22952 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.437 | O'Neil Field | ||
7582 | 7582 | 7581 | {"type": "Polygon", "coordinates": [[[-121.46394, 38.5431], [-121.46359, 38.54311], [-121.46358, 38.54387], [-121.46331, 38.54389], [-121.46331, 38.54451], [-121.46245, 38.54451], [-121.46245, 38.54312], [-121.46189, 38.5431], [-121.46189, 38.54231], [-121.46295, 38.54232], [-121.46394, 38.5431]]]} | Open Access 1 | Oak Park | 22999 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.353 | Oak Park | ||
7587 | 7587 | 7586 | {"type": "Polygon", "coordinates": [[[-121.46189, 38.5431], [-121.46127, 38.5431], [-121.46126, 38.54227], [-121.46073, 38.54226], [-121.46073, 38.54214], [-121.46126, 38.54214], [-121.46127, 38.5419], [-121.46189, 38.54189], [-121.46189, 38.5431]]]} | Open Access 1 | Oak Park Open Space | 23005 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.966 | Oak Park OS | ||
7596 | 7596 | 7595 | {"type": "Polygon", "coordinates": [[[-121.50317, 38.6276], [-121.50316, 38.62873], [-121.50246, 38.62873], [-121.50246, 38.6276], [-121.50317, 38.6276]]]} | Open Access 1 | Oakbrook Park Site | 23019 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.904 | Oakbrook Park Site | ||
7688 | 7688 | 7687 | {"type": "Polygon", "coordinates": [[[-121.49775, 38.58034], [-121.4976, 38.5807], [-121.49713, 38.58058], [-121.49729, 38.58021], [-121.49775, 38.58034]]]} | Open Access 1 | Saint Rose Of Lima Park | 24792 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.455 | Saint Rose Of Lima Park | ||
7743 | 7743 | 7742 | {"type": "Polygon", "coordinates": [[[-121.52671, 38.61133], [-121.52667, 38.61142], [-121.52669, 38.61151], [-121.5267, 38.61269], [-121.52262, 38.61268], [-121.52303, 38.61248], [-121.52357, 38.61233], [-121.52398, 38.612], [-121.52473, 38.61069], [-121.52476, 38.61042], [-121.52671, 38.61133]]]} | Open Access 1 | Orchard Park | 23193 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.918 | Orchard Park | ||
7890 | 7890 | 7889 | {"type": "Polygon", "coordinates": [[[-121.50062, 38.61252], [-121.49992, 38.61253], [-121.49991, 38.61187], [-121.49961, 38.61162], [-121.5006, 38.6116], [-121.50062, 38.61252]]]} | Open Access 1 | Park Plaza | 23435 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.62 | Park Plaza | ||
7903 | 7903 | 7902 | {"type": "Polygon", "coordinates": [[[-121.4802, 38.47983], [-121.48019, 38.48034], [-121.48016, 38.48081], [-121.48016, 38.48122], [-121.48014, 38.48126], [-121.48008, 38.48127], [-121.48008, 38.48132], [-121.47963, 38.48133], [-121.47961, 38.48127], [-121.47842, 38.48128], [-121.4784, 38.48134], [-121.47683, 38.48135], [-121.47683, 38.47983], [-121.4802, 38.47983]]]} | Open Access 1 | Pannell / Meadowview Community Center Park | 23388 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.905 | Pannell / Meadowview Community Ctr. Park | ||
7945 | 7945 | 7944 | {"type": "Polygon", "coordinates": [[[-121.50991, 38.65206], [-121.50993, 38.65214], [-121.50991, 38.65222], [-121.50988, 38.6523], [-121.50982, 38.65237], [-121.50966, 38.65248], [-121.50906, 38.65269], [-121.50882, 38.65279], [-121.50858, 38.65286], [-121.50834, 38.65289], [-121.50809, 38.6529], [-121.50777, 38.65294], [-121.50727, 38.65294], [-121.50727, 38.65162], [-121.50807, 38.65162], [-121.50807, 38.65056], [-121.5089, 38.65056], [-121.50903, 38.6506], [-121.50914, 38.65069], [-121.50921, 38.6508], [-121.50932, 38.6511], [-121.50937, 38.65132], [-121.50943, 38.65145], [-121.5095, 38.65157], [-121.50991, 38.65206]]]} | Open Access 1 | Park 5-A | 23422 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 10.148 | Park 5-A | ||
7973 | 7973 | 7972 | {"type": "Polygon", "coordinates": [[[-121.52618, 38.48758], [-121.5244, 38.48819], [-121.52403, 38.48805], [-121.52361, 38.48795], [-121.52368, 38.48777], [-121.52371, 38.48759], [-121.52372, 38.48649], [-121.5237, 38.48637], [-121.52417, 38.48631], [-121.52549, 38.48631], [-121.52555, 38.48636], [-121.52563, 38.48637], [-121.5257, 38.48635], [-121.52574, 38.48631], [-121.52613, 38.48631], [-121.52618, 38.48758]]]} | Open Access 1 | Parkway Oaks Park | 23461 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 9.522 | Parkway Oaks Park | ||
7996 | 7996 | 7995 | {"type": "Polygon", "coordinates": [[[-121.51473, 38.52293], [-121.51454, 38.52353], [-121.51389, 38.5234], [-121.51408, 38.5228], [-121.51473, 38.52293]]]} | Open Access 1 | Partnere Off Leash Dog Park | 23486 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.001 | Partnere Off Leash Dog 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]);