units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2, MNG_AG_TYP = 2 and UNIT_NAME = "Timothy Hopkins Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6796 | 6796 | 6795 | {"type": "Polygon", "coordinates": [[[-122.168, 37.44966], [-122.1679, 37.45019], [-122.16792, 37.45081], [-122.16731, 37.45104], [-122.16636, 37.4508], [-122.16592, 37.45103], [-122.16577, 37.45165], [-122.16545, 37.45228], [-122.16541, 37.45294], [-122.16474, 37.453], [-122.16422, 37.45261], [-122.16385, 37.45288], [-122.16347, 37.45324], [-122.16297, 37.45348], [-122.16226, 37.45406], [-122.16154, 37.45412], [-122.16082, 37.45422], [-122.16066, 37.45458], [-122.15943, 37.45465], [-122.15886, 37.45421], [-122.15834, 37.4536], [-122.15739, 37.45358], [-122.15695, 37.45407], [-122.15629, 37.45426], [-122.15563, 37.4545], [-122.1557, 37.45494], [-122.15599, 37.45547], [-122.15528, 37.45588], [-122.15456, 37.45616], [-122.15335, 37.45693], [-122.15259, 37.45766], [-122.15214, 37.45766], [-122.15168, 37.45714], [-122.15034, 37.45721], [-122.15106, 37.45697], [-122.15184, 37.45683], [-122.15246, 37.45695], [-122.15328, 37.45627], [-122.15437, 37.45554], [-122.15536, 37.45512], [-122.15507, 37.45446], [-122.15588, 37.45378], [-122.15644, 37.45373], [-122.15705, 37.45336], [-122.15777, 37.45335], [-122.15911, 37.45337], [-122.1597, 37.4542], [-122.16008, 37.45415], [-122.16063, 37.45383], [-122.16124, 37.45351], [-122.16258, 37.45357], [-122.16274, 37.45335], [-122.16312, 37.45294], [-122.16378, 37.45248], [-122.16439, 37.45238], [-122.16494, 37.45215], [-122.16557, 37.45081], [-122.1665, 37.45017], [-122.16691, 37.45061], [-122.16741, 37.45055], [-122.16756, 37.45006], [-122.1676, 37.44958], [-122.16726, 37.44914], [-122.16736, 37.44891], [-122.16773, 37.44828], [-122.16781, 37.44895], [-122.16782, 37.44926], [-122.168, 37.44966]]]} | Open Access 1 | 5305 | Timothy Hopkins Park | 26372 | 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 | 27.327 | Timothy Hopkins Park | 1907 | 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]);