superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_WEB = "http://www.cdva.ca.gov/" and MNG_AG_LEV = 5
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310 | 310 | 309 | {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34564, 38.44615], [-122.3358, 38.44548], [-122.33141, 38.44558], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.3182, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44193], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32229, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} | Open Access 1 | Silverado Trail Rector Dam Watershed | 1818 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 959.891 | Silverado Trail Rector Dam Watershed | ||
385 | 385 | 384 | {"type": "Polygon", "coordinates": [[[-122.38699, 38.39466], [-122.37714, 38.39469], [-122.37938, 38.38742], [-122.3798, 38.38598], [-122.37717, 38.39444], [-122.37409, 38.39566], [-122.37334, 38.39398], [-122.37121, 38.39263], [-122.3693, 38.39221], [-122.36874, 38.39053], [-122.36846, 38.38913], [-122.36754, 38.38821], [-122.366, 38.38782], [-122.37008, 38.38595], [-122.37392, 38.39097], [-122.37515, 38.39047], [-122.37727, 38.38728], [-122.37763, 38.38706], [-122.37758, 38.38599], [-122.37775, 38.3841], [-122.37721, 38.38217], [-122.37717, 38.38217], [-122.37531, 38.38163], [-122.37518, 38.38087], [-122.37591, 38.37813], [-122.3817, 38.37932], [-122.38186, 38.37922], [-122.38154, 38.38026], [-122.38184, 38.38028], [-122.38222, 38.39105], [-122.38683, 38.39105], [-122.38699, 38.39466]]]} | Open Access 1 | Veterans Home Open Space | 1819 | 206 | California Department of Veterans Affairs 166 | State 5 | State Agency 5 | http://www.cdva.ca.gov/ | Other State 5 | 347.869 | Veterans Home OS |
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]);