superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where MNG_AGENCY = 29 sorted by PARK_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2843 | 2843 | 2842 | {"type": "Polygon", "coordinates": [[[-122.72736, 38.43806], [-122.72694, 38.43821], [-122.72682, 38.43805], [-122.7265, 38.43817], [-122.72622, 38.43778], [-122.72694, 38.43746], [-122.72736, 38.43806]]]} | Open Access 1 | DeMeo Park | 18080 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.141 | DeMeo Park | ||
3590 | 3590 | 3589 | {"type": "Polygon", "coordinates": [[[-122.72547, 38.44105], [-122.72507, 38.44108], [-122.72464, 38.44045], [-122.72539, 38.44038], [-122.72547, 38.44105]]]} | Open Access 1 | DeTurk Park | 18123 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.923 | DeTurk Park | ||
3697 | 3697 | 3696 | {"type": "Polygon", "coordinates": [[[-122.69985, 38.43896], [-122.69973, 38.43922], [-122.69957, 38.43929], [-122.69935, 38.43966], [-122.69914, 38.43967], [-122.69902, 38.43988], [-122.69885, 38.43999], [-122.69873, 38.43998], [-122.69789, 38.44012], [-122.69763, 38.44002], [-122.69723, 38.44004], [-122.69707, 38.44015], [-122.69663, 38.44035], [-122.69639, 38.44033], [-122.69625, 38.44048], [-122.69587, 38.44045], [-122.69574, 38.44049], [-122.69535, 38.44019], [-122.69525, 38.44048], [-122.69476, 38.44073], [-122.69456, 38.44078], [-122.6943, 38.44094], [-122.69388, 38.44108], [-122.69412, 38.4409], [-122.69326, 38.44], [-122.69282, 38.43949], [-122.69287, 38.43943], [-122.69297, 38.43927], [-122.69313, 38.43917], [-122.69333, 38.43912], [-122.69332, 38.43909], [-122.69351, 38.43888], [-122.69374, 38.43867], [-122.69372, 38.43861], [-122.6941, 38.43834], [-122.69447, 38.43846], [-122.69494, 38.43873], [-122.69546, 38.43892], [-122.69586, 38.43913], [-122.69611, 38.43929], [-122.6965, 38.43937], [-122.69668, 38.43929], [-122.6971, 38.43881], [-122.69765, 38.43904], [-122.69809, 38.43902], [-122.69859, 38.43876], [-122.69924, 38.43896], [-122.69985, 38.43896]]]} | Open Access 1 | Doyle Park | 18260 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 21.6 | Doyle Park | ||
3745 | 3745 | 3744 | {"type": "Polygon", "coordinates": [[[-122.75772, 38.44893], [-122.7573, 38.44893], [-122.75729, 38.44902], [-122.75694, 38.44937], [-122.75684, 38.44945], [-122.75679, 38.44945], [-122.75677, 38.44898], [-122.75653, 38.44897], [-122.75653, 38.44894], [-122.75665, 38.44883], [-122.75672, 38.44873], [-122.75676, 38.44856], [-122.75672, 38.44824], [-122.75672, 38.44809], [-122.75668, 38.44793], [-122.75733, 38.44794], [-122.75737, 38.44818], [-122.75768, 38.44868], [-122.75771, 38.44882], [-122.75772, 38.44893]]]} | Open Access 1 | Dutch Flohr Park | 18318 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.392 | Dutch Flohr Park | ||
2990 | 2990 | 2989 | {"type": "Polygon", "coordinates": [[[-122.69702, 38.44707], [-122.69667, 38.44712], [-122.69664, 38.44728], [-122.69643, 38.44733], [-122.69631, 38.4472], [-122.69599, 38.44727], [-122.69594, 38.44715], [-122.69636, 38.44706], [-122.69699, 38.44694], [-122.69702, 38.44707]]]} | Open Access 1 | Eastside Park | 18400 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.421 | Eastside Park | ||
13579 | 13579 | 13578 | {"type": "Polygon", "coordinates": [[[-122.73156, 38.45287], [-122.73152, 38.45293], [-122.7309, 38.45305], [-122.73084, 38.45292], [-122.73075, 38.45281], [-122.73039, 38.4517], [-122.73106, 38.45137], [-122.73117, 38.4516], [-122.73156, 38.45287]]]} | Open Access 1 | Finali Park | https://srcity.org/Facilities/Facility/Details/Finali-Park-66 | 31030 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 2.767 | Finali Park | 2016 |
4229 | 4229 | 4228 | {"type": "Polygon", "coordinates": [[[-122.71034, 38.49485], [-122.71017, 38.49538], [-122.70934, 38.49527], [-122.70927, 38.49498], [-122.70966, 38.49491], [-122.71034, 38.49485]]]} | Open Access 1 | Fir Ridge Park | 18907 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.974 | Fir Ridge Park | ||
4246 | 4246 | 4245 | {"type": "Polygon", "coordinates": [[[-122.67816, 38.4529], [-122.67762, 38.45386], [-122.67755, 38.45412], [-122.67671, 38.4539], [-122.67688, 38.45341], [-122.67693, 38.45318], [-122.6772, 38.45246], [-122.67816, 38.4529]]]} | Open Access 1 | Flat Rock Park | 18940 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 3.264 | Flat Rock Park | ||
4341 | 4341 | 4340 | {"type": "Polygon", "coordinates": [[[-122.71874, 38.48454], [-122.71869, 38.48464], [-122.71849, 38.48473], [-122.71825, 38.48472], [-122.71701, 38.48418], [-122.71617, 38.48412], [-122.71608, 38.48403], [-122.71597, 38.48385], [-122.71598, 38.48356], [-122.71586, 38.48337], [-122.71585, 38.48324], [-122.71575, 38.48311], [-122.71563, 38.48271], [-122.71578, 38.48242], [-122.71645, 38.48208], [-122.71813, 38.48189], [-122.71837, 38.48227], [-122.71839, 38.48241], [-122.71821, 38.48312], [-122.7183, 38.48367], [-122.71853, 38.48395], [-122.71869, 38.48423], [-122.71869, 38.4844], [-122.71874, 38.48454]]]} | Open Access 1 | Fountain Grove Park | 19021 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 14.017 | Fountain Grove Park | ||
1246 | 1246 | 1245 | {"type": "Polygon", "coordinates": [[[-122.71532, 38.47393], [-122.71504, 38.47426], [-122.71504, 38.47458], [-122.71331, 38.4746], [-122.7133, 38.47473], [-122.71345, 38.47478], [-122.71349, 38.47484], [-122.7135, 38.47491], [-122.71339, 38.47498], [-122.713, 38.47508], [-122.71274, 38.47512], [-122.71267, 38.47507], [-122.71267, 38.47483], [-122.7126, 38.4746], [-122.71301, 38.4746], [-122.71302, 38.47458], [-122.71279, 38.4741], [-122.71246, 38.47385], [-122.71229, 38.47366], [-122.7126, 38.47363], [-122.71325, 38.47374], [-122.71388, 38.47367], [-122.71416, 38.47368], [-122.71463, 38.47373], [-122.71487, 38.47378], [-122.71507, 38.47383], [-122.71532, 38.47393]]]} | Open Access 1 | Frances Nielsen Ranch Park | 32919 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 5.88 | Frances Nielsen Ranch Park | ||
3496 | 3496 | 3495 | {"type": "Polygon", "coordinates": [[[-122.71291, 38.46188], [-122.71241, 38.46199], [-122.71216, 38.46156], [-122.7115, 38.46172], [-122.70972, 38.46007], [-122.70965, 38.45995], [-122.71273, 38.45904], [-122.71291, 38.46188]]]} | Open Access 1 | Franklin Park | 19066 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 13.315 | Franklin Park | ||
4412 | 4412 | 4411 | {"type": "Polygon", "coordinates": [[[-122.70955, 38.4434], [-122.70874, 38.44377], [-122.70831, 38.44322], [-122.70831, 38.44319], [-122.70912, 38.4428], [-122.70955, 38.4434]]]} | Open Access 1 | Fremont Park | 19102 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1.548 | Fremont Park | 2000 | |
4473 | 4473 | 4472 | {"type": "Polygon", "coordinates": [[[-122.66368, 38.41889], [-122.66292, 38.41936], [-122.66115, 38.4199], [-122.65968, 38.41989], [-122.65968, 38.41787], [-122.65839, 38.41785], [-122.65799, 38.41691], [-122.6615, 38.41693], [-122.66368, 38.41889]]]} | Open Access 1 | Galvin Park | 19183 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 24.146 | Galvin Park | ||
14009 | 14009 | 14008 | {"type": "Polygon", "coordinates": [[[-122.70989, 38.41101], [-122.70989, 38.41114], [-122.70987, 38.41123], [-122.70975, 38.41126], [-122.70879, 38.41127], [-122.70869, 38.41121], [-122.7087, 38.41106], [-122.70867, 38.41101], [-122.70861, 38.41098], [-122.70854, 38.41096], [-122.70844, 38.41098], [-122.70797, 38.41098], [-122.70789, 38.41091], [-122.70789, 38.41085], [-122.70785, 38.41077], [-122.70765, 38.41056], [-122.70764, 38.41052], [-122.70767, 38.41046], [-122.70773, 38.41044], [-122.70775, 38.41046], [-122.70896, 38.41046], [-122.70917, 38.41045], [-122.70938, 38.41041], [-122.70948, 38.41044], [-122.70962, 38.41064], [-122.70979, 38.4108], [-122.70986, 38.41091], [-122.70989, 38.41101]]]} | Open Access 1 | Harvest Park | https://srcity.org/facilities/facility/details/Harvest-Park-72 | 32579 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 3.197 | Harvest Park | |
4977 | 4977 | 4976 | {"type": "Polygon", "coordinates": [[[-122.73678, 38.44783], [-122.73649, 38.44785], [-122.73648, 38.44771], [-122.73672, 38.44771], [-122.73677, 38.44775], [-122.73678, 38.44783]]]} | Open Access 1 | Haydn Village Park | 19753 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.09 | Haydn Village Park | ||
5121 | 5121 | 5120 | {"type": "Polygon", "coordinates": [[[-122.70256, 38.47544], [-122.70255, 38.47547], [-122.70224, 38.47542], [-122.70162, 38.47624], [-122.70157, 38.47671], [-122.7013, 38.47657], [-122.70121, 38.4765], [-122.70093, 38.47617], [-122.70076, 38.47599], [-122.70056, 38.47583], [-122.69975, 38.47539], [-122.69979, 38.47531], [-122.69915, 38.47498], [-122.69895, 38.47484], [-122.69885, 38.47467], [-122.70244, 38.47464], [-122.7023, 38.47517], [-122.70221, 38.47536], [-122.70256, 38.47544]]]} | Open Access 1 | Hidden Valley Park | 19920 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 8.8 | Hidden Valley Park | ||
5274 | 5274 | 5273 | {"type": "Polygon", "coordinates": [[[-122.6718, 38.45488], [-122.6715, 38.45491], [-122.67052, 38.45514], [-122.66999, 38.45567], [-122.66937, 38.45577], [-122.664, 38.4564], [-122.66196, 38.4572], [-122.66201, 38.45754], [-122.66181, 38.45757], [-122.66059, 38.45805], [-122.66056, 38.45805], [-122.65974, 38.45828], [-122.65973, 38.45625], [-122.6609, 38.4552], [-122.6609, 38.45518], [-122.66088, 38.45517], [-122.66193, 38.4541], [-122.66192, 38.45408], [-122.66197, 38.45406], [-122.66737, 38.45035], [-122.66768, 38.44951], [-122.66805, 38.44909], [-122.6682, 38.44925], [-122.66856, 38.44969], [-122.66934, 38.45101], [-122.6718, 38.45488]]]} | Open Access 1 | Howarth Park | 20122 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 111.55 | Howarth Park | 1970 | |
5294 | 5294 | 5293 | {"type": "Polygon", "coordinates": [[[-122.71433, 38.45338], [-122.7143, 38.4539], [-122.71426, 38.45392], [-122.71394, 38.45391], [-122.71397, 38.45335], [-122.7143, 38.45336], [-122.71433, 38.45338]]]} | Open Access 1 | Humboldt Park | 20146 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 0.481 | Humboldt Park | ||
12698 | 12698 | 12697 | {"type": "Polygon", "coordinates": [[[-122.75048, 38.43421], [-122.74811, 38.43393], [-122.74801, 38.43312], [-122.75043, 38.43316], [-122.75037, 38.43323], [-122.75048, 38.43421]]]} | Restricted Access 2 | J.X. Wilson Park | 31385 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 5.235 | J.X. Wilson Park | ||
5460 | 5460 | 5459 | {"type": "Polygon", "coordinates": [[[-122.73719, 38.44047], [-122.73597, 38.44051], [-122.73603, 38.44154], [-122.7343, 38.4416], [-122.7342, 38.43999], [-122.73707, 38.43986], [-122.73708, 38.43996], [-122.73716, 38.43995], [-122.73719, 38.44047]]]} | Open Access 1 | Jacobs Park | 20329 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 8.514 | Jacobs 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]);