superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACRES = "0.215"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1851 | 1851 | 1850 | {"type": "Polygon", "coordinates": [[[-122.01725, 36.96579], [-122.01685, 36.96565], [-122.0168, 36.9655], [-122.01713, 36.96543], [-122.01725, 36.96579]]]} | Open Access 1 | Beach Flats Park | 15906 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 0.215 | Beach Flats Park | ||
2396 | 2396 | 2395 | {"type": "Polygon", "coordinates": [[[-121.80054, 39.64365], [-121.8001, 39.64376], [-121.80003, 39.64358], [-121.80048, 39.64347], [-121.80054, 39.64365]]]} | Open Access 1 | Butte holding 11 | 16554 | 342 | Butte, County of 692 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 0.215 | Butte holding 11 | ||
2854 | 2854 | 2853 | {"type": "Polygon", "coordinates": [[[-122.28448, 37.86652], [-122.28395, 37.86659], [-122.28393, 37.86645], [-122.28427, 37.86641], [-122.28428, 37.86631], [-122.28444, 37.86629], [-122.28448, 37.86652]]]} | Open Access 1 | Charlie Dorr Mini-Park | 17145 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 0.215 | Charlie Dorr Mini-Park | ||
4564 | 4564 | 4563 | {"type": "Polygon", "coordinates": [[[-121.96308, 37.29872], [-121.96265, 37.29819], [-121.96239, 37.29789], [-121.96265, 37.2979], [-121.96266, 37.29797], [-121.9628, 37.29824], [-121.96308, 37.29872]]]} | Open Access 1 | Gleason Park | 19311 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.215 | Gleason Park | ||
11429 | 11429 | 11428 | {"type": "Polygon", "coordinates": [[[-121.27862, 39.49732], [-121.27862, 39.49732], [-121.27803, 39.49771], [-121.27838, 39.49725], [-121.27858, 39.49713], [-121.27862, 39.49732]]]} | Unknown Access 4 | Yuba County Water Agency 15 | 27803 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 0.215 | Yuba County Water Agency 15 | ||
12185 | 12185 | 12184 | {"type": "Polygon", "coordinates": [[[-118.36777, 33.81735], [-118.36765, 33.8174], [-118.36727, 33.81683], [-118.36739, 33.81678], [-118.36777, 33.81735]]]} | Open Access 1 | Greenbelt near Bindewald St | 29165 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.215 | Greenbelt near Bindewald St | ||
12696 | 12696 | 12695 | {"type": "Polygon", "coordinates": [[[-117.00188, 32.95969], [-117.0015, 32.95981], [-117.00141, 32.95964], [-117.00186, 32.95949], [-117.00188, 32.95969]]]} | Open Access 1 | Sycamore Creek Neighborhood Park - West | 31379 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 0.215 | Sycamore Creek Neighborhood Park - West | ||
13230 | 13230 | 13229 | {"type": "Polygon", "coordinates": [[[-116.18604, 33.66406], [-116.18552, 33.66406], [-116.18552, 33.66389], [-116.18599, 33.66389], [-116.18603, 33.66393], [-116.18604, 33.66406]]]} | Open Access 1 | Tot Lot Park | https://www.coachella.org/residents/parks-and-recreation/tot-lot | 33405 | 1061 | Coachella, City of 85 | City 2 | City Agency 2 | http://www.coachella.org/departments/public-works-department/parks-maintenance | City 2 | 0.215 | Tot Lot Park | |
13960 | 13960 | 13959 | {"type": "Polygon", "coordinates": [[[-120.23679, 37.96123], [-120.23635, 37.96123], [-120.23635, 37.96102], [-120.23679, 37.96102], [-120.23679, 37.96123]]]} | Open Access 1 | Reid Park | https://www.tuolumnerecreation.com/TPRD_facilities.html | 32551 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 0.215 | Reid Park | 1997 |
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]);