superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where MNG_AGENCY = 29 and MNG_AG_TYP = 2 sorted by SUID_NMA
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
5514 | 5514 | 5513 | {"type": "Polygon", "coordinates": [[[-122.74343, 38.44794], [-122.74343, 38.44831], [-122.74298, 38.44833], [-122.743, 38.44868], [-122.74102, 38.44879], [-122.74092, 38.44747], [-122.74293, 38.44734], [-122.74299, 38.44795], [-122.74343, 38.44794]]]} | Open Access 1 | Jennings Park | 20390 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 6.811 | Jennings Park | ||
5694 | 5694 | 5693 | {"type": "Polygon", "coordinates": [[[-122.81259, 38.40564], [-122.81258, 38.40688], [-122.81096, 38.40685], [-122.81095, 38.40686], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.41961], [-122.81123, 38.42122], [-122.81049, 38.42125], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.4206], [-122.80889, 38.42267], [-122.80642, 38.42269], [-122.80108, 38.42268], [-122.79501, 38.42272], [-122.79499, 38.41973], [-122.80359, 38.4197], [-122.80349, 38.41056], [-122.80349, 38.4086], [-122.80676, 38.40743], [-122.80677, 38.40815], [-122.80679, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81022, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564]]]} | No Public Access 3 | Kelly Farm | 20586 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 369.086 | Kelly Farm | ||
6296 | 6296 | 6295 | {"type": "Polygon", "coordinates": [[[-122.76936, 38.43528], [-122.7686, 38.43533], [-122.76804, 38.43541], [-122.76769, 38.43551], [-122.76768, 38.4354], [-122.76753, 38.43421], [-122.76921, 38.43412], [-122.76936, 38.43528]]]} | Open Access 1 | Live Oak Park | 21370 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 4.841 | Live Oak Park | ||
6731 | 6731 | 6730 | {"type": "Polygon", "coordinates": [[[-122.70489, 38.42844], [-122.70386, 38.4288], [-122.7029, 38.42713], [-122.70284, 38.42692], [-122.70304, 38.4268], [-122.70316, 38.42678], [-122.7032, 38.42675], [-122.70329, 38.42672], [-122.70344, 38.42671], [-122.70354, 38.42665], [-122.70377, 38.42657], [-122.70384, 38.42664], [-122.70385, 38.42669], [-122.70397, 38.42686], [-122.70489, 38.42844]]]} | Open Access 1 | Martin Luther King Park | 21919 | 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.524 | Martin Luther King Park | ||
6753 | 6753 | 6752 | {"type": "Polygon", "coordinates": [[[-122.67198, 38.43672], [-122.67163, 38.43671], [-122.67165, 38.43646], [-122.67173, 38.43598], [-122.67152, 38.43563], [-122.67188, 38.43551], [-122.67205, 38.4358], [-122.67208, 38.43593], [-122.67208, 38.43604], [-122.67204, 38.43622], [-122.67198, 38.43672]]]} | Open Access 1 | Matanzas Park | 21948 | 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.031 | Matanzas Park | ||
6960 | 6960 | 6959 | {"type": "Polygon", "coordinates": [[[-122.67335, 38.42801], [-122.67288, 38.42828], [-122.67285, 38.42825], [-122.67287, 38.42816], [-122.67285, 38.42811], [-122.67279, 38.42807], [-122.67269, 38.42808], [-122.67264, 38.42812], [-122.67263, 38.42817], [-122.67267, 38.42825], [-122.67275, 38.42834], [-122.67152, 38.42905], [-122.6715, 38.42775], [-122.67151, 38.42747], [-122.6724, 38.42746], [-122.67242, 38.42735], [-122.67303, 38.42735], [-122.67304, 38.42768], [-122.67335, 38.42801]]]} | Open Access 1 | Mesquite Park | 22186 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 4.468 | Mesquite Park | ||
7450 | 7450 | 7449 | {"type": "Polygon", "coordinates": [[[-122.70898, 38.449], [-122.70895, 38.44953], [-122.70824, 38.44951], [-122.70826, 38.44898], [-122.70898, 38.449]]]} | Open Access 1 | North Park | 22842 | 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.916 | North Park | ||
7490 | 7490 | 7489 | {"type": "Polygon", "coordinates": [[[-122.75088, 38.45585], [-122.75084, 38.45588], [-122.75076, 38.45647], [-122.75075, 38.45755], [-122.74783, 38.45898], [-122.74765, 38.45912], [-122.74747, 38.45933], [-122.74741, 38.45951], [-122.74739, 38.45969], [-122.74536, 38.45968], [-122.74536, 38.45837], [-122.74552, 38.45829], [-122.74565, 38.45773], [-122.74604, 38.45735], [-122.74659, 38.45735], [-122.74655, 38.45765], [-122.7475, 38.45765], [-122.74779, 38.45762], [-122.74779, 38.45737], [-122.74839, 38.45732], [-122.74838, 38.45653], [-122.74829, 38.45649], [-122.74831, 38.45648], [-122.74831, 38.45585], [-122.74823, 38.45583], [-122.74823, 38.45502], [-122.75085, 38.45501], [-122.75088, 38.45585]]]} | Open Access 1 | Northwest Community Park | 22896 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 32.079 | Northwest Community Park | ||
7567 | 7567 | 7566 | {"type": "Polygon", "coordinates": [[[-122.65695, 38.47237], [-122.65661, 38.47241], [-122.65663, 38.4726], [-122.65583, 38.47267], [-122.65577, 38.47231], [-122.65546, 38.47228], [-122.65536, 38.47187], [-122.65566, 38.47179], [-122.65568, 38.47108], [-122.6564, 38.47113], [-122.65656, 38.47214], [-122.65693, 38.47223], [-122.65695, 38.47237]]]} | Open Access 1 | Oak Lake Green Park | 22985 | 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.471 | Oak Lake Green 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]);