units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 1963
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2044 | 2044 | 2043 | {"type": "Polygon", "coordinates": [[[-122.42983, 37.70536], [-122.42971, 37.70543], [-122.42944, 37.70564], [-122.42915, 37.70553], [-122.42926, 37.70533], [-122.42983, 37.70536]]]} | Open Access 1 | 15588 | Arden Court | 15576 | 1078 | Daly City, City of 427 | City 2 | City Agency 2 | http://www.dalycity.org/ | City 2 | 1078 | Daly City, City of 421 | City 2 | City Agency 2 | San Mateo 15 | 0.282 | Arden Court | 1963 | Local Park 2 | 4 | |
6798 | 6798 | 6797 | {"type": "Polygon", "coordinates": [[[-122.1208, 37.44259], [-122.11901, 37.44439], [-122.11896, 37.44441], [-122.1189, 37.44441], [-122.11862, 37.44417], [-122.11799, 37.44357], [-122.11805, 37.4426], [-122.11636, 37.44099], [-122.11573, 37.44141], [-122.11564, 37.44127], [-122.1153, 37.44058], [-122.11656, 37.43987], [-122.11739, 37.44054], [-122.11754, 37.44057], [-122.11798, 37.44033], [-122.11805, 37.44037], [-122.11773, 37.44055], [-122.11772, 37.44057], [-122.1182, 37.44095], [-122.1208, 37.44259]]]} | Open Access 1 | 5308 | John Lucas Greer Park | 20452 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 21.478 | John Lucas Greer Park | 1963 | Local Park 2 | 4 | |
8552 | 8552 | 8551 | {"type": "Polygon", "coordinates": [[[-122.39766, 37.57859], [-122.3979, 37.57884], [-122.39871, 37.57947], [-122.39875, 37.57952], [-122.39874, 37.57956], [-122.3985, 37.57974], [-122.39826, 37.57983], [-122.39678, 37.58002], [-122.39652, 37.58003], [-122.39638, 37.57939], [-122.39766, 37.57859]]]} | Open Access 1 | 13506 | Cuernavaca Park | 17848 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 4.905 | Cuernavaca Park | 1963 | Local Park 2 | 4 | |
8655 | 8655 | 8654 | {"type": "Polygon", "coordinates": [[[-122.25411, 37.47894], [-122.25351, 37.47941], [-122.25343, 37.47934], [-122.25337, 37.47924], [-122.25335, 37.4791], [-122.25338, 37.47896], [-122.25347, 37.47885], [-122.25363, 37.47875], [-122.25376, 37.47872], [-122.25392, 37.47871], [-122.2539, 37.47884], [-122.25402, 37.47888], [-122.25411, 37.47894]]]} | Open Access 1 | 13881 | Dove Beeger Park | 18249 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 0.721 | Dove Beeger Park | 1963 | 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]);