superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=444"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
94 | 94 | 93 | {"type": "MultiPolygon", "coordinates": [[[[-123.82187, 39.36052], [-123.82181, 39.36061], [-123.82169, 39.36065], [-123.82162, 39.36078], [-123.82155, 39.36082], [-123.82145, 39.36074], [-123.82141, 39.36068], [-123.82133, 39.36064], [-123.82131, 39.36057], [-123.82132, 39.36051], [-123.82158, 39.36028], [-123.82186, 39.36045], [-123.8218, 39.36046], [-123.82178, 39.36047], [-123.82187, 39.36052]]], [[[-123.8228, 39.36144], [-123.82276, 39.36146], [-123.82269, 39.36143], [-123.82259, 39.36148], [-123.82258, 39.36155], [-123.82252, 39.36153], [-123.82241, 39.36153], [-123.8221, 39.3613], [-123.82218, 39.36104], [-123.82217, 39.36096], [-123.82219, 39.36093], [-123.82217, 39.36088], [-123.82209, 39.36082], [-123.82276, 39.36083], [-123.8228, 39.36144]]], [[[-123.8239, 39.36142], [-123.82385, 39.36148], [-123.82388, 39.36153], [-123.82388, 39.36156], [-123.82384, 39.36163], [-123.82363, 39.3617], [-123.82356, 39.36169], [-123.82352, 39.36163], [-123.82328, 39.36152], [-123.82324, 39.36141], [-123.82319, 39.36134], [-123.8234, 39.36118], [-123.82373, 39.36127], [-123.82371, 39.36132], [-123.8239, 39.36142]]], [[[-123.8251, 39.36086], [-123.82509, 39.36092], [-123.825, 39.36097], [-123.82499, 39.36102], [-123.82492, 39.36101], [-123.82473, 39.36109], [-123.82458, 39.36104], [-123.8245, 39.36097], [-123.82444, 39.36087], [-123.82438, 39.36085], [-123.82435, 39.36087], [-123.82436, 39.36092], [-123.82433, 39.36095], [-123.82424, 39.36095], [-123.82419, 39.36096], [-123.82414, 39.3609], [-123.8241, 39.36079], [-123.8241, 39.36073], [-123.82405, 39.36071], [-123.82401, 39.36072], [-123.82397, 39.36082], [-123.82387, 39.36069], [-123.82396, 39.36045], [-123.824, 39.36044], [-123.82406, 39.36037], [-123.82415, 39.36036], [-123.82422, 39.36032], [-123.82435, 39.36035], [-123.82449, 39.36041], [-123.82471, 39.36049], [-123.82476, 39.36056], [-123.8249, 39.3606], [-123.82495, 39.36063], [-123.8251, 39.36086]]]]} | Open Access 1 | Caspar Headlands State Natural Reserve | http://www.parks.ca.gov/?page_id=444 | 1468 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 3.222 | Caspar Headlands SNR | 1972 |
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]);