units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 25 and UNIT_NAME = "Cantara-Ney Springs Wildlife Area"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Fish and Wildlife · 1 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 1 ✖
| Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16717 | 16717 | 16716 | {"type": "MultiPolygon", "coordinates": [[[[-122.30003, 41.2693], [-122.29759, 41.26926], [-122.29768, 41.26761], [-122.29786, 41.26772], [-122.29802, 41.26784], [-122.29812, 41.26795], [-122.29825, 41.26816], [-122.29837, 41.2683], [-122.29864, 41.26854], [-122.29879, 41.26864], [-122.30003, 41.2693]]], [[[-122.29871, 41.26763], [-122.29853, 41.26745], [-122.29833, 41.26729], [-122.29811, 41.26715], [-122.29772, 41.26695], [-122.29776, 41.26639], [-122.29876, 41.26717], [-122.2991, 41.26735], [-122.29952, 41.26749], [-122.29984, 41.26756], [-122.30013, 41.26758], [-122.30038, 41.26759], [-122.30072, 41.26756], [-122.30105, 41.26749], [-122.30136, 41.2674], [-122.30162, 41.26729], [-122.30184, 41.26717], [-122.30201, 41.26711], [-122.30224, 41.26706], [-122.30256, 41.26705], [-122.30277, 41.26708], [-122.30295, 41.26714], [-122.30312, 41.26721], [-122.30328, 41.26732], [-122.30341, 41.26745], [-122.30351, 41.26761], [-122.30355, 41.26774], [-122.30356, 41.26789], [-122.30355, 41.268], [-122.3035, 41.26813], [-122.30337, 41.26834], [-122.30315, 41.26852], [-122.3029, 41.26865], [-122.30267, 41.26871], [-122.30118, 41.26892], [-122.30087, 41.26893], [-122.30059, 41.26888], [-122.30033, 41.26879], [-122.29925, 41.26822], [-122.2991, 41.26812], [-122.29898, 41.268], [-122.29871, 41.26763]]], [[[-122.32181, 41.26644], [-122.32165, 41.26925], [-122.30716, 41.26918], [-122.30257, 41.26932], [-122.30322, 41.26911], [-122.30356, 41.26895], [-122.30374, 41.26883], [-122.30393, 41.26866], [-122.30406, 41.26851], [-122.30417, 41.26833], [-122.30425, 41.26815], [-122.30429, 41.26793], [-122.30429, 41.26774], [-122.30426, 41.26757], [-122.3042, 41.26741], [-122.30409, 41.26723], [-122.30396, 41.26707], [-122.30379, 41.26692], [-122.3035, 41.26674], [-122.30318, 41.26661], [-122.30278, 41.26652], [-122.3024, 41.2665], [-122.30204, 41.26653], [-122.30173, 41.2666], [-122.30148, 41.26669], [-122.3013, 41.2668], [-122.30112, 41.26688], [-122.3009, 41.26695], [-122.3007, 41.267], [-122.30028, 41.26703], [-122.30004, 41.26701], [-122.29984, 41.26698], [-122.29949, 41.26686], [-122.29923, 41.26672], [-122.29811, 41.26587], [-122.29778, 41.26559], [-122.30722, 41.26566], [-122.30721, 41.26578], [-122.30723, 41.26578], [-122.3096, 41.26505], [-122.31331, 41.26659], [-122.31632, 41.26676], [-122.31678, 41.26725], [-122.31779, 41.26726], [-122.31819, 41.26752], [-122.31898, 41.26742], [-122.32095, 41.26625], [-122.32181, 41.26644]]]]} | Open Access 1 | 18381 | Cantara-Ney Springs Wildlife Area | 30422 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cantara-Ney-Springs-WA | Siskiyou 28 | 155.358 | Cantara-Ney Springs Wildlife Area | 1996 | State Conservation Area 8 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps(
id INT,
map,
ACCESS_TYP INT,
UNIT_ID INT,
UNIT_NAME TEXT,
SUID_NMA INT,
AGNCY_ID INT,
AGNCY_NAME INT,
AGNCY_LEV INT,
AGNCY_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
PARK_URL TEXT,
COUNTY INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
DES_TP INT,
GAP_STS TEXT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
ON [units_with_maps] ([ACCESS_TYP]);