units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "2547.98", DES_TP = 55 and MNG_AGENCY = 25
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Fish and Wildlife · 1 ✖
DES_TP 1
- State Resource Management Area · 1 ✖
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9067 | 9067 | 9066 | {"type": "MultiPolygon", "coordinates": [[[[-117.82662, 35.23575], [-117.81509, 35.23582], [-117.81509, 35.23107], [-117.8151, 35.23091], [-117.81518, 35.23054], [-117.81528, 35.23023], [-117.81543, 35.22993], [-117.81562, 35.22965], [-117.8157, 35.2295], [-117.81591, 35.22901], [-117.81599, 35.22876], [-117.81598, 35.22847], [-117.82661, 35.22835], [-117.82662, 35.23575]]], [[[-117.87993, 35.22116], [-117.87991, 35.22825], [-117.86265, 35.22824], [-117.86238, 35.21375], [-117.87118, 35.21361], [-117.8714, 35.22089], [-117.87589, 35.22102], [-117.87993, 35.22116]]], [[[-117.93302, 35.23571], [-117.91518, 35.23571], [-117.91515, 35.23206], [-117.91515, 35.22838], [-117.93289, 35.2284], [-117.93302, 35.23571]]], [[[-117.93339, 35.26495], [-117.93335, 35.2724], [-117.91564, 35.27255], [-117.91564, 35.26502], [-117.93339, 35.26495]]], [[[-117.9422, 35.25764], [-117.93338, 35.25766], [-117.93313, 35.24303], [-117.942, 35.24297], [-117.9422, 35.25764]]], [[[-117.9505, 35.22952], [-117.95058, 35.23373], [-117.95048, 35.23562], [-117.94188, 35.23572], [-117.94185, 35.22833], [-117.94604, 35.22832], [-117.9461, 35.22101], [-117.95042, 35.22093], [-117.9505, 35.22565], [-117.95045, 35.22831], [-117.94855, 35.22833], [-117.94854, 35.22954], [-117.94855, 35.22955], [-117.9505, 35.22952]]], [[[-117.96803, 35.18428], [-117.95909, 35.18426], [-117.95025, 35.1843], [-117.95019, 35.17697], [-117.95022, 35.16971], [-117.96347, 35.16954], [-117.96794, 35.16951], [-117.96794, 35.17677], [-117.96803, 35.18428]]]]} | No Public Access 3 | 16644 | Desert Tortoise Habitat | 32149 | 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 | Kern 36 | 2547.98 | Desert Tortoise Habitat | 0 | State Resource Management Area 55 | 3 |
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]);