units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 8, LABEL_NAME = "West Mojave Desert ER" and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15590 | 15590 | 15589 | {"type": "MultiPolygon", "coordinates": [[[[-117.10047, 35.19979], [-117.08245, 35.19981], [-117.08237, 35.18524], [-117.10045, 35.18528], [-117.10047, 35.19979]]], [[[-117.11756, 35.11125], [-117.10433, 35.11125], [-117.09887, 35.11115], [-117.09991, 35.09674], [-117.11755, 35.09674], [-117.11756, 35.11125]]], [[[-117.11793, 35.18528], [-117.10082, 35.18528], [-117.10004, 35.17076], [-117.1, 35.17069], [-117.09981, 35.17069], [-117.10013, 35.16921], [-117.1175, 35.16919], [-117.11776, 35.16937], [-117.11793, 35.18528]]], [[[-117.11757, 35.15475], [-117.10022, 35.15476], [-117.10013, 35.14025], [-117.11757, 35.14026], [-117.11757, 35.15475]]], [[[-117.10934, 35.22153], [-117.1005, 35.22155], [-117.1005, 35.21793], [-117.10933, 35.21791], [-117.10934, 35.22153]]], [[[-117.13584, 35.2215], [-117.11818, 35.22151], [-117.11817, 35.21427], [-117.13583, 35.21426], [-117.13584, 35.2215]]], [[[-117.15333, 35.03859], [-117.15334, 35.04549], [-117.15326, 35.05308], [-117.13591, 35.0528], [-117.13592, 35.03844], [-117.15333, 35.03859]]], [[[-117.17064, 35.14026], [-117.1705, 35.14391], [-117.17051, 35.15479], [-117.15283, 35.15477], [-117.15283, 35.1439], [-117.15295, 35.14009], [-117.17051, 35.1401], [-117.17051, 35.14026], [-117.17064, 35.14026]]], [[[-117.17121, 35.24323], [-117.15356, 35.24325], [-117.15353, 35.22873], [-117.17118, 35.2287], [-117.17121, 35.24323]]], [[[-117.26057, 35.22809], [-117.26051, 35.22995], [-117.26001, 35.24249], [-117.24286, 35.24247], [-117.24279, 35.22794], [-117.22503, 35.228], [-117.225, 35.23525], [-117.225, 35.2425], [-117.22058, 35.24254], [-117.21175, 35.24257], [-117.20715, 35.24273], [-117.20715, 35.22873], [-117.20709, 35.22872], [-117.20751, 35.22822], [-117.21184, 35.22804], [-117.22502, 35.22799], [-117.22499, 35.21363], [-117.21175, 35.21365], [-117.20716, 35.21373], [-117.20715, 35.19922], [-117.21182, 35.19902], [-117.22506, 35.19898], [-117.22492, 35.18471], [-117.24251, 35.18469], [-117.24247, 35.16948], [-117.26027, 35.16948], [-117.2602, 35.18457], [-117.24283, 35.18469], [-117.24271, 35.1847], [-117.24275, 35.19913], [-117.2602, 35.19923], [-117.26022, 35.21374], [-117.25095, 35.21367], [-117.24278, 35.21357], [-117.2428, 35.22793], [-117.26057, 35.22809]], [[-117.24274, 35.19915], [-117.22507, 35.19898], [-117.225, 35.21362], [-117.24277, 35.21356], [-117.24274, 35.19915]]], [[[-117.28229, 35.19925], [-117.28229, 35.20288], [-117.27788, 35.20288], [-117.27787, 35.19925], [-117.27014, 35.19924], [-117.27014, 35.19199], [-117.27786, 35.192], [-117.27788, 35.19925], [-117.28229, 35.19925]]], [[[-117.33198, 35.27303], [-117.33197, 35.28744], [-117.31465, 35.28724], [-117.31454, 35.27265], [-117.33198, 35.27303]]], [[[-117.3392, 35.10428], [-117.33479, 35.10428], [-117.33472, 35.10064], [-117.33911, 35.10066], [-117.3392, 35.10428]]], [[[-117.35984, 35.06566], [-117.35979, 35.06952], [-117.35753, 35.06944], [-117.35755, 35.06562], [-117.35984, 35.06566]]], [[[-117.36424, 35.05854], [-117.36423, 35.06223], [-117.35766, 35.06219], [-117.35767, 35.0585], [-117.36424, 35.05854]]], [[[-117.37635, 35.19986], [-117.37196, 35.19987], [-117.37195, 35.18509], [-117.37635, 35.18518], [-117.37635, 35.19986]]], [[[-117.37994, 35.02379], [-117.37581, 35.02368], [-117.37578, 35.02181], [-117.37991, 35.02192], [-117.37994, 35.02379]]], [[[-117.38, 35.02002], [-117.37581, 35.01992], [-117.37579, 35.0187], [-117.37994, 35.01873], [-117.38, 35.02002]]], [[[-117.40119, 35.15505], [-117.39342, 35.15501], [-117.39307, 35.15163], [-117.40114, 35.15165], [-117.40119, 35.15505]]], [[[-117.40514, 35.10072], [-117.40082, 35.10071], [-117.40081, 35.09705], [-117.40152, 35.09705], [-117.40183, 35.09709], [-117.40505, 35.09708], [-117.40514, 35.10072]]], [[[-117.5084, 35.07107], [-117.50834, 35.08581], [-117.49098, 35.08573], [-117.49086, 35.07116], [-117.47303, 35.0709], [-117.47311, 35.08571], [-117.46851, 35.08567], [-117.46835, 35.09007], [-117.46394, 35.09004], [-117.46385, 35.08564], [-117.45525, 35.0856], [-117.45515, 35.07091], [-117.43748, 35.07057], [-117.43747, 35.07058], [-117.43725, 35.08517], [-117.41965, 35.08501], [-117.4197, 35.07037], [-117.43747, 35.07057], [-117.43747, 35.05597], [-117.41961, 35.05572], [-117.41955, 35.07032], [-117.40653, 35.07015], [-117.40185, 35.07007], [-117.40192, 35.05538], [-117.4196, 35.05572], [-117.41949, 35.04085], [-117.43804, 35.04146], [-117.43747, 35.05596], [-117.45516, 35.05627], [-117.45516, 35.07091], [-117.47302, 35.0709], [-117.47308, 35.05625], [-117.49098, 35.05636], [-117.49088, 35.07116], [-117.5084, 35.07107]]], [[[-117.41291, 35.25218], [-117.41285, 35.25929], [-117.40846, 35.25929], [-117.40846, 35.25214], [-117.41291, 35.25218]]], [[[-117.41916, 35.10079], [-117.41448, 35.10065], [-117.41445, 35.10435], [-117.41011, 35.10425], [-117.41021, 35.09712], [-117.419, 35.09702], [-117.41916, 35.10079]]], [[[-117.45401, 35.1698], [-117.454, 35.1699], [-117.45367, 35.1699], [-117.45367, 35.16979], [-117.44549, 35.16969], [-117.44561, 35.16245], [-117.45383, 35.16247], [-117.45368, 35.16978], [-117.45401, 35.1698]]], [[[-117.4645, 35.05251], [-117.46014, 35.05252], [-117.46002, 35.04876], [-117.46435, 35.04875], [-117.4645, 35.05251]]], [[[-117.48934, 35.14029], [-117.47148, 35.1405], [-117.47157, 35.12595], [-117.48901, 35.12571], [-117.48934, 35.14029]]], [[[-117.48044, 35.22419], [-117.48039, 35.22592], [-117.47344, 35.22579], [-117.47347, 35.22413], [-117.48044, 35.22419]]], [[[-117.50642, 35.21482], [-117.49785, 35.2148], [-117.49794, 35.20771], [-117.50638, 35.20754], [-117.50642, 35.21482]]], [[[-117.51559, 35.22587], [-117.50672, 35.22583], [-117.5067, 35.22229], [-117.51554, 35.2223], [-117.51559, 35.22587]]], [[[-117.52022, 35.13898], [-117.51541, 35.13888], [-117.5155, 35.13378], [-117.52015, 35.13382], [-117.52022, 35.13898]]], [[[-117.54404, 35.05696], [-117.52603, 35.05717], [-117.52625, 35.04222], [-117.54393, 35.04221], [-117.54404, 35.05696]]], [[[-117.54396, 35.07157], [-117.54387, 35.08618], [-117.52611, 35.086], [-117.52611, 35.07134], [-117.54396, 35.07157]]], [[[-117.54203, 35.18597], [-117.54183, 35.19328], [-117.5332, 35.19324], [-117.53322, 35.18593], [-117.54203, 35.18597]]], [[[-117.54726, 35.01285], [-117.53497, 35.01277], [-117.53501, 35.01093], [-117.5372, 35.01095], [-117.53724, 35.00911], [-117.53835, 35.00912], [-117.53832, 35.01096], [-117.54676, 35.01102], [-117.54726, 35.01285]]], [[[-117.55057, 35.03676], [-117.55057, 35.0386], [-117.54837, 35.03857], [-117.54836, 35.03674], [-117.55057, 35.03676]]], [[[-117.55977, 35.05855], [-117.55301, 35.05855], [-117.55301, 35.05713], [-117.55304, 35.0571], [-117.55307, 35.05709], [-117.55936, 35.0572], [-117.55941, 35.05724], [-117.55977, 35.05855]]], [[[-117.56002, 35.06294], [-117.55974, 35.06424], [-117.55969, 35.06429], [-117.55309, 35.06429], [-117.55305, 35.06428], [-117.55303, 35.06424], [-117.55302, 35.06294], [-117.56002, 35.06294]]], [[[-117.66729, 34.78571], [-117.66722, 34.79316], [-117.66302, 34.79308], [-117.66297, 34.78972], [-117.66295, 34.78564], [-117.66729, 34.78571]]]]} | Open Access 1 | 12744 | West Mojave Desert Ecological Reserve | 32348 | 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/West-Mojave-Desert-ER | San Bernardino 22 | 18340.276 | West Mojave Desert ER | 1988 | 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]);