units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 4 and UNIT_NAME = "St Joseph's Hill Open Space Preserve"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6078 | 6078 | 6077 | {"type": "Polygon", "coordinates": [[[-121.98918, 37.21064], [-121.98875, 37.21109], [-121.98816, 37.21138], [-121.98764, 37.21182], [-121.98721, 37.21242], [-121.98703, 37.21306], [-121.98705, 37.21331], [-121.98614, 37.21319], [-121.98566, 37.21378], [-121.98535, 37.21407], [-121.98523, 37.21416], [-121.98514, 37.21437], [-121.98491, 37.21453], [-121.98453, 37.21487], [-121.98442, 37.21509], [-121.9844, 37.21517], [-121.98429, 37.21517], [-121.98431, 37.21507], [-121.98442, 37.21484], [-121.98484, 37.21446], [-121.98502, 37.21435], [-121.9851, 37.21419], [-121.98511, 37.21411], [-121.98527, 37.21401], [-121.98547, 37.2138], [-121.98558, 37.21352], [-121.98561, 37.21324], [-121.9857, 37.21281], [-121.98564, 37.21265], [-121.98567, 37.21258], [-121.98593, 37.2124], [-121.98602, 37.21208], [-121.98587, 37.20766], [-121.98632, 37.20703], [-121.98682, 37.20687], [-121.98692, 37.20682], [-121.98705, 37.20669], [-121.98707, 37.20661], [-121.98707, 37.20655], [-121.98702, 37.20644], [-121.98691, 37.2063], [-121.98689, 37.20621], [-121.98691, 37.20605], [-121.9869, 37.20598], [-121.98688, 37.20598], [-121.98675, 37.20617], [-121.98663, 37.20646], [-121.98652, 37.2065], [-121.98624, 37.20646], [-121.98583, 37.20628], [-121.98581, 37.20579], [-121.98567, 37.20578], [-121.9854, 37.20582], [-121.98492, 37.20603], [-121.98482, 37.20608], [-121.98462, 37.20629], [-121.98423, 37.20659], [-121.98412, 37.20663], [-121.98335, 37.20671], [-121.98304, 37.20685], [-121.98284, 37.20656], [-121.98266, 37.20626], [-121.98253, 37.20617], [-121.98237, 37.20616], [-121.98189, 37.20626], [-121.98172, 37.20626], [-121.98077, 37.20587], [-121.98059, 37.20581], [-121.98059, 37.20668], [-121.9807, 37.20708], [-121.9807, 37.20722], [-121.98065, 37.20736], [-121.98055, 37.20751], [-121.9801, 37.20784], [-121.98, 37.20834], [-121.97978, 37.20855], [-121.97948, 37.20861], [-121.97921, 37.20858], [-121.97857, 37.20831], [-121.97835, 37.20829], [-121.97815, 37.20837], [-121.97672, 37.20945], [-121.97631, 37.20956], [-121.97627, 37.20183], [-121.98585, 37.20139], [-121.9858, 37.20531], [-121.98861, 37.20532], [-121.98853, 37.20541], [-121.98853, 37.20558], [-121.98861, 37.20576], [-121.98856, 37.20601], [-121.9884, 37.2062], [-121.98844, 37.20655], [-121.98857, 37.20666], [-121.98876, 37.20686], [-121.98872, 37.20694], [-121.9885, 37.20699], [-121.98906, 37.207], [-121.9891, 37.20728], [-121.98854, 37.2083], [-121.98872, 37.20877], [-121.98908, 37.20953], [-121.98922, 37.21011], [-121.98918, 37.21064]]]} | Open Access 1 | 1095 | St Joseph's Hill Open Space Preserve | 31673 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 181.465 | St Joseph's Hill OSP | 0 | Local Conservation Area 4 | 2 |
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]);