superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 217 and YR_EST = 1961
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5446 | 5446 | 5445 | {"type": "Polygon", "coordinates": [[[-122.18424, 37.44468], [-122.18381, 37.44519], [-122.18236, 37.44442], [-122.18279, 37.44391], [-122.18424, 37.44468]]]} | Open Access 1 | Jack W. Lyle Park | 20313 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 2.625 | Jack W. Lyle Park | 1961 | |
5696 | 5696 | 5695 | {"type": "Polygon", "coordinates": [[[-122.17165, 37.4789], [-122.16783, 37.47916], [-122.16777, 37.47856], [-122.16808, 37.47859], [-122.16966, 37.47849], [-122.16984, 37.47853], [-122.16994, 37.47848], [-122.16996, 37.47845], [-122.16996, 37.4784], [-122.16991, 37.47833], [-122.16983, 37.47831], [-122.16808, 37.47843], [-122.1679, 37.47842], [-122.16772, 37.47838], [-122.16789, 37.47815], [-122.16789, 37.47811], [-122.16976, 37.47798], [-122.16976, 37.47779], [-122.17165, 37.4789]]]} | Open Access 1 | Kelly Park | 20588 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 6.934 | Kelly Park | 1961 | |
6234 | 6234 | 6233 | {"type": "Polygon", "coordinates": [[[-122.18195, 37.44777], [-122.18079, 37.44915], [-122.17918, 37.44823], [-122.18028, 37.44688], [-122.18195, 37.44777]]]} | Open Access 1 | Nealon Park | 22679 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 7.883 | Nealon Park | 1961 | |
6693 | 6693 | 6692 | {"type": "MultiPolygon", "coordinates": [[[[-122.16628, 37.47667], [-122.16608, 37.47688], [-122.16602, 37.47689], [-122.1655, 37.47659], [-122.16567, 37.47641], [-122.16575, 37.4764], [-122.16597, 37.47653], [-122.166, 37.47651], [-122.16628, 37.47667]]], [[[-122.16607, 37.47699], [-122.16585, 37.47723], [-122.16582, 37.47712], [-122.16563, 37.47701], [-122.16576, 37.47686], [-122.16583, 37.47685], [-122.16607, 37.47699]]]]} | Open Access 1 | Marketplace Park | 21872 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 0.67 | Marketplace Park | 1961 | |
8884 | 8884 | 8883 | {"type": "Polygon", "coordinates": [[[-122.19589, 37.44038], [-122.19555, 37.44079], [-122.19566, 37.44089], [-122.19538, 37.44122], [-122.19395, 37.44046], [-122.19438, 37.43994], [-122.19478, 37.44014], [-122.19494, 37.43998], [-122.19508, 37.44008], [-122.1953, 37.44011], [-122.19589, 37.44038]]]} | Open Access 1 | Tinkers Park | 26373 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 3.23 | Tinkers Park | 1961 | |
9559 | 9559 | 9558 | {"type": "Polygon", "coordinates": [[[-122.21204, 37.42373], [-122.21157, 37.42448], [-122.2106, 37.4243], [-122.20834, 37.42439], [-122.20823, 37.4236], [-122.20844, 37.42337], [-122.20979, 37.42308], [-122.21204, 37.42373]]]} | Open Access 1 | Sharon Park | 25363 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 9.022 | Sharon Park | 1961 |
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]);