superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where PARK_URL = "http://www.gvrd.org/?page=Glen_Cove_Nature_Area"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13827 | 13827 | 13826 | {"type": "Polygon", "coordinates": [[[-122.20957, 38.06758], [-122.20956, 38.06787], [-122.2084, 38.06804], [-122.20788, 38.06822], [-122.20785, 38.06852], [-122.20778, 38.06848], [-122.2077, 38.06847], [-122.20762, 38.0685], [-122.20758, 38.06855], [-122.20759, 38.06864], [-122.2077, 38.06874], [-122.20771, 38.06882], [-122.20641, 38.06881], [-122.20508, 38.06877], [-122.2051, 38.06835], [-122.2051, 38.06699], [-122.20529, 38.06729], [-122.20608, 38.06766], [-122.20684, 38.06774], [-122.20738, 38.0674], [-122.20741, 38.06735], [-122.20741, 38.06694], [-122.20762, 38.06695], [-122.20766, 38.06688], [-122.20789, 38.06689], [-122.20799, 38.06681], [-122.20802, 38.06687], [-122.20812, 38.06691], [-122.20868, 38.06703], [-122.20899, 38.06696], [-122.20924, 38.06686], [-122.20938, 38.06689], [-122.20936, 38.06708], [-122.20948, 38.0671], [-122.20946, 38.06756], [-122.20957, 38.06758]]]} | Open Access 1 | Glen Cove Nature Area | http://www.gvrd.org/?page=Glen_Cove_Nature_Area | 31382 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 13.075 | Glen Cove Nature Area |
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]);