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 = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Peninsular-Ranges-ER"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14503 | 14503 | 14502 | {"type": "MultiPolygon", "coordinates": [[[[-116.16464, 33.46969], [-116.16461, 33.46969], [-116.1646, 33.46967], [-116.16446, 33.46967], [-116.14733, 33.46963], [-116.14719, 33.46282], [-116.14716, 33.45529], [-116.1471, 33.45527], [-116.1471, 33.45511], [-116.13852, 33.45509], [-116.13848, 33.44775], [-116.12986, 33.44772], [-116.12993, 33.44058], [-116.12982, 33.44056], [-116.12998, 33.42615], [-116.14723, 33.42682], [-116.14736, 33.44027], [-116.16461, 33.44055], [-116.16464, 33.46969]]], [[[-116.18199, 33.49889], [-116.16482, 33.49886], [-116.1648, 33.48437], [-116.18199, 33.48432], [-116.18199, 33.49889]]], [[[-116.19815, 33.49864], [-116.18219, 33.49866], [-116.18219, 33.49149], [-116.19814, 33.49145], [-116.19815, 33.49864]]]]} | Open Access 1 | Peninsular Ranges Ecological Reserve | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Peninsular-Ranges-ER | 32258 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 3328.862 | Peninsular Ranges ER | 2007 |
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]);