superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where MNG_AG_TYP = 2 and YR_EST = 2008
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6308 | 6308 | 6307 | {"type": "MultiPolygon", "coordinates": [[[[-118.13513, 33.76319], [-118.13494, 33.76348], [-118.13464, 33.76355], [-118.13433, 33.76341], [-118.13513, 33.76319]]], [[[-118.13617, 33.76292], [-118.13599, 33.7632], [-118.13525, 33.7634], [-118.13521, 33.7634], [-118.13518, 33.76337], [-118.13519, 33.76334], [-118.13531, 33.76315], [-118.13617, 33.76292]]], [[[-118.1372, 33.76265], [-118.13714, 33.7629], [-118.13629, 33.76312], [-118.13625, 33.76312], [-118.13623, 33.76309], [-118.13623, 33.76306], [-118.13636, 33.76287], [-118.1372, 33.76265]]], [[[-118.13839, 33.76234], [-118.13834, 33.76258], [-118.13735, 33.76284], [-118.13743, 33.76259], [-118.13839, 33.76234]]]]} | Open Access 1 | Livingston Drive Greenbelt and Playground | 21383 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.922 | Livingston Drive Greenbelt and Playground | 2008 | |
9586 | 9586 | 9585 | {"type": "Polygon", "coordinates": [[[-122.24673, 38.1727], [-122.24652, 38.17245], [-122.24632, 38.17212], [-122.24572, 38.17099], [-122.24564, 38.171], [-122.24564, 38.17094], [-122.24508, 38.1698], [-122.24504, 38.16965], [-122.24502, 38.16951], [-122.24501, 38.16921], [-122.24495, 38.16856], [-122.24502, 38.16856], [-122.24511, 38.16849], [-122.24562, 38.1685], [-122.24562, 38.16866], [-122.24567, 38.16893], [-122.24569, 38.16921], [-122.24593, 38.16921], [-122.24605, 38.16925], [-122.24617, 38.16922], [-122.24652, 38.16923], [-122.24659, 38.16931], [-122.24659, 38.17035], [-122.2467, 38.17036], [-122.2467, 38.1719], [-122.24663, 38.17193], [-122.24673, 38.1727]]]} | Open Access 1 | Shenandoah Park | 25389 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 9.052 | Shenandoah Park | 2008 | |
10809 | 10809 | 10808 | {"type": "Polygon", "coordinates": [[[-122.25278, 38.15531], [-122.2528, 38.15702], [-122.25268, 38.15846], [-122.25237, 38.163], [-122.25231, 38.16505], [-122.25224, 38.16546], [-122.25214, 38.16545], [-122.25221, 38.16497], [-122.2521, 38.16423], [-122.25216, 38.16415], [-122.2522, 38.16406], [-122.25221, 38.16397], [-122.25221, 38.16386], [-122.25211, 38.16342], [-122.25154, 38.15991], [-122.25208, 38.15779], [-122.25215, 38.15755], [-122.25227, 38.15533], [-122.25278, 38.15531]]]} | Open Access 1 | Veterans Memorial Park | 27024 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 13.899 | Veterans Memorial Park | 2008 | |
11282 | 11282 | 11281 | {"type": "Polygon", "coordinates": [[[-122.01104, 37.59599], [-122.01091, 37.59608], [-122.01086, 37.59604], [-122.01077, 37.59603], [-122.01072, 37.59597], [-122.01065, 37.59594], [-122.01057, 37.59593], [-122.01049, 37.59595], [-122.01006, 37.59558], [-122.0101, 37.59553], [-122.01011, 37.59548], [-122.01043, 37.59526], [-122.01068, 37.59549], [-122.0107, 37.59555], [-122.01068, 37.59564], [-122.01072, 37.59571], [-122.01082, 37.59575], [-122.01093, 37.59572], [-122.01084, 37.59581], [-122.01104, 37.59599]]]} | Open Access 1 | Willow Park | 27585 | 1362 | Union City, City of 361 | City 2 | City Agency 2 | http://www.ci.union-city.ca.us/ | City 2 | 0.845 | Willow Park | 2008 | |
12362 | 12362 | 12361 | {"type": "Polygon", "coordinates": [[[-118.34615, 34.09177], [-118.34615, 34.09186], [-118.34569, 34.09186], [-118.3457, 34.09177], [-118.34615, 34.09177]]]} | Open Access 1 | Formosa Park | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 | 32414 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | http://www.weho.org/residents/recreation-services/parks-and-facilities | City 2 | 0.105 | Formosa Park | 2008 |
12733 | 12733 | 12732 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84874], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 51st St Greenbelt | 29907 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1.012 | 51st St Greenbelt | 2008 | |
13129 | 13129 | 13128 | {"type": "Polygon", "coordinates": [[[-122.82178, 38.40555], [-122.82143, 38.40621], [-122.82146, 38.40636], [-122.82112, 38.40641], [-122.82081, 38.40517], [-122.82117, 38.40516], [-122.82125, 38.40548], [-122.82174, 38.40541], [-122.82178, 38.40555]]]} | Open Access 1 | Skategarden Park | http://ci.sebastopol.ca.us/Our-Community/Parks-Open-Space/Skategarden-Park | 31785 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 1.58 | Skategarden Park | 2008 |
13467 | 13467 | 13466 | {"type": "Polygon", "coordinates": [[[-122.39603, 37.59378], [-122.3959, 37.59385], [-122.39574, 37.59368], [-122.39528, 37.59394], [-122.39494, 37.59351], [-122.39511, 37.59343], [-122.39538, 37.59333], [-122.39562, 37.59327], [-122.39586, 37.59324], [-122.3959, 37.59343], [-122.39603, 37.59378]]]} | Open Access 1 | Mosta Grove / Sister City | https://www.ci.millbrae.ca.us/departments-services/public-works/parks-division/mosta-grove-sister-city | 32593 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1.063 | Mosta Grove / Sister City | 2008 |
13971 | 13971 | 13970 | {"type": "Polygon", "coordinates": [[[-120.87765, 37.51347], [-120.87639, 37.51347], [-120.87637, 37.51177], [-120.87638, 37.51173], [-120.87641, 37.51168], [-120.87642, 37.51164], [-120.87639, 37.51156], [-120.8763, 37.5115], [-120.87639, 37.51151], [-120.87652, 37.51182], [-120.87665, 37.51203], [-120.87689, 37.51238], [-120.87736, 37.51296], [-120.87753, 37.51319], [-120.87765, 37.51347]]]} | Open Access 1 | Swanson Centennial Park | 32563 | 1358 | Turlock, City of 41 | City 2 | City Agency 2 | http://www.ci.turlock.ca.us/ | City 2 | 2.964 | Swanson Centennial Park | 2008 |
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]);