units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AGENCY = 25 and SUID_NMA = 17793
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
- Restricted 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16753 | 16753 | 16752 | {"type": "MultiPolygon", "coordinates": [[[[-124.17131, 41.7438], [-124.16617, 41.74381], [-124.16615, 41.74983], [-124.16631, 41.75097], [-124.15664, 41.75099], [-124.15667, 41.75053], [-124.15818, 41.75017], [-124.1592, 41.75033], [-124.16153, 41.75019], [-124.16288, 41.7488], [-124.16333, 41.74744], [-124.16565, 41.74595], [-124.16583, 41.74523], [-124.16571, 41.74471], [-124.16535, 41.74428], [-124.16451, 41.74408], [-124.16367, 41.74399], [-124.16312, 41.74475], [-124.15897, 41.74541], [-124.15657, 41.74544], [-124.15663, 41.74393], [-124.15676, 41.74367], [-124.15664, 41.73974], [-124.15635, 41.73952], [-124.15616, 41.73932], [-124.1557, 41.73854], [-124.15524, 41.73784], [-124.1561, 41.73777], [-124.15651, 41.73718], [-124.1481, 41.73308], [-124.14776, 41.73285], [-124.14746, 41.73269], [-124.1472, 41.73249], [-124.1472, 41.7297], [-124.15032, 41.72968], [-124.15148, 41.7317], [-124.1528, 41.73384], [-124.15706, 41.73225], [-124.15715, 41.73218], [-124.15745, 41.73267], [-124.15762, 41.73289], [-124.15829, 41.73359], [-124.159, 41.7346], [-124.15945, 41.73507], [-124.15962, 41.73534], [-124.15969, 41.73551], [-124.15996, 41.73571], [-124.16026, 41.73603], [-124.16034, 41.73618], [-124.16051, 41.73641], [-124.16081, 41.73677], [-124.16103, 41.73711], [-124.16135, 41.73743], [-124.16156, 41.73762], [-124.16225, 41.73814], [-124.16255, 41.73839], [-124.16344, 41.73898], [-124.16235, 41.74], [-124.16504, 41.74138], [-124.16461, 41.74192], [-124.16461, 41.74193], [-124.16567, 41.74243], [-124.1662, 41.74201], [-124.16747, 41.74256], [-124.16781, 41.74226], [-124.16824, 41.74252], [-124.16937, 41.74304], [-124.17051, 41.74351], [-124.17131, 41.7438]]], [[[-124.17914, 41.74981], [-124.17838, 41.75029], [-124.17804, 41.74979], [-124.17875, 41.74939], [-124.17914, 41.74981]]], [[[-124.17995, 41.75028], [-124.17942, 41.75093], [-124.1786, 41.75041], [-124.17915, 41.74993], [-124.17995, 41.75028]]], [[[-124.18108, 41.75083], [-124.18061, 41.75135], [-124.18022, 41.75142], [-124.17968, 41.75109], [-124.18028, 41.75042], [-124.18108, 41.75083]]]]} | Restricted Access 2 | 21583 | Crescent City Marsh Wildlife Area | 17793 | 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 | Del Norte 50 | 297.328 | Crescent City Marsh Wildlife Area | 0 | 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]);