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/Biscar-WA"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13134 | 13134 | 13133 | {"type": "MultiPolygon", "coordinates": [[[[-120.24728, 40.54136], [-120.24253, 40.54135], [-120.24248, 40.53404], [-120.24723, 40.53404], [-120.24728, 40.54136]]], [[[-120.3123, 40.54134], [-120.30921, 40.5413], [-120.30917, 40.534], [-120.3103, 40.53399], [-120.31145, 40.53815], [-120.3123, 40.54134]]], [[[-120.32825, 40.5447], [-120.32733, 40.54475], [-120.32705, 40.54483], [-120.3267, 40.545], [-120.32351, 40.54499], [-120.3235, 40.5461], [-120.32317, 40.54631], [-120.32225, 40.54713], [-120.32193, 40.54748], [-120.32178, 40.54769], [-120.32164, 40.54809], [-120.32147, 40.54847], [-120.32131, 40.5486], [-120.31482, 40.54858], [-120.31444, 40.54721], [-120.31409, 40.54622], [-120.31394, 40.54563], [-120.31397, 40.54136], [-120.31285, 40.54132], [-120.312, 40.53818], [-120.3111, 40.53515], [-120.31085, 40.534], [-120.32348, 40.53401], [-120.32347, 40.53764], [-120.32563, 40.53765], [-120.32682, 40.5377], [-120.32822, 40.53766], [-120.32825, 40.5447]]], [[[-120.32352, 40.54861], [-120.32159, 40.5486], [-120.32166, 40.54853], [-120.32185, 40.54814], [-120.32199, 40.54774], [-120.32211, 40.54757], [-120.32242, 40.54723], [-120.32333, 40.54642], [-120.3235, 40.54632], [-120.32352, 40.54861]]], [[[-120.32825, 40.545], [-120.32795, 40.545], [-120.32709, 40.545], [-120.32739, 40.54491], [-120.32825, 40.54487], [-120.32825, 40.545]]]]} | Open Access 1 | Biscar Wildlife Area | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Biscar-WA | 30417 | 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 | 552.259 | Biscar Wildlife Area | 1973 |
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]);