units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, MNG_AGENCY = 217 and YR_EST = 1961
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2668 | 2668 | 2667 | {"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 | 18188 | Nealon Park | 22679 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 7.884 | Nealon Park | 1961 | Local Park 2 | 4 | |
5331 | 5331 | 5330 | {"type": "Polygon", "coordinates": [[[-122.19589, 37.44038], [-122.19554, 37.4408], [-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 | 15566 | Tinkers Park | 26373 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 3.227 | Tinkers Park | 1961 | Local Park 2 | 4 | |
6018 | 6018 | 6017 | {"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 | 700 | Sharon Park | 25363 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 9.023 | Sharon Park | 1961 | Local Park 2 | 4 | |
8786 | 8786 | 8785 | {"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.47849], [-122.16996, 37.47845], [-122.16996, 37.4784], [-122.16991, 37.47833], [-122.16983, 37.47831], [-122.16808, 37.47843], [-122.16791, 37.47842], [-122.16772, 37.47838], [-122.16789, 37.47815], [-122.16789, 37.47811], [-122.16977, 37.47798], [-122.16976, 37.47779], [-122.17165, 37.4789]]]} | Open Access 1 | 14290 | Kelly Park | 20588 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 6.931 | Kelly Park | 1961 | Local Park 2 | 4 | |
9329 | 9329 | 9328 | {"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 | 15558 | Jack W. Lyle Park | 20313 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 2.626 | Jack W. Lyle Park | 1961 | Local Park 2 | 4 | |
9330 | 9330 | 9329 | {"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.16598, 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 | 15560 | Marketplace Park | 21872 | 1202 | Menlo Park, City of 221 | City 2 | City Agency 2 | http://www.menlopark.org/ | City 2 | 1202 | Menlo Park, City of 217 | City 2 | City Agency 2 | San Mateo 15 | 0.67 | Marketplace Park | 1961 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);