superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_LEV = 3, MNG_AG_TYP = 3 and PARK_URL = "http://www.co.tehama.ca.us/cone-grove-park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11732 | 11732 | 11731 | {"type": "Polygon", "coordinates": [[[-122.13624, 40.16726], [-122.13608, 40.16756], [-122.13608, 40.16789], [-122.13579, 40.16833], [-122.13525, 40.16893], [-122.13502, 40.16922], [-122.13467, 40.1694], [-122.13392, 40.1697], [-122.13353, 40.16995], [-122.13318, 40.17051], [-122.13307, 40.17111], [-122.13021, 40.17111], [-122.13094, 40.17091], [-122.13251, 40.17066], [-122.13277, 40.17057], [-122.13318, 40.17011], [-122.13339, 40.16963], [-122.13448, 40.16788], [-122.13496, 40.16758], [-122.13539, 40.16737], [-122.13586, 40.16728], [-122.13624, 40.16726]]]} | Open Access 1 | Cone Grove Park | http://www.co.tehama.ca.us/cone-grove-park | 28336 | 367 | Tehama, County of 574 | County 3 | County Agency 3 | http://www.co.tehama.ca.us/dep-parks | County 3 | 10.282 | Cone Grove Park |
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]);