units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 8 and PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/Coachella-Valley-ER"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15606 | 15606 | 15605 | {"type": "MultiPolygon", "coordinates": [[[[-116.31968, 33.77655], [-116.31962, 33.77838], [-116.31852, 33.77844], [-116.31858, 33.78018], [-116.31656, 33.7802], [-116.31649, 33.782], [-116.31435, 33.78198], [-116.31431, 33.78384], [-116.31435, 33.78739], [-116.30115, 33.78748], [-116.30141, 33.77557], [-116.30388, 33.77354], [-116.30392, 33.77298], [-116.30987, 33.77295], [-116.30981, 33.77653], [-116.31428, 33.77649], [-116.31431, 33.77469], [-116.31643, 33.77464], [-116.31648, 33.77647], [-116.31859, 33.77655], [-116.31968, 33.77655]], [[-116.31425, 33.77841], [-116.31207, 33.77844], [-116.31215, 33.78003], [-116.31432, 33.7801], [-116.31425, 33.77841]]], [[[-116.35343, 33.80923], [-116.35561, 33.80926], [-116.35773, 33.80925], [-116.3577, 33.81287], [-116.35332, 33.81285], [-116.35331, 33.81277], [-116.34812, 33.81267], [-116.34518, 33.81269], [-116.34451, 33.81279], [-116.34449, 33.81285], [-116.33554, 33.81297], [-116.33574, 33.80931], [-116.35343, 33.80923]]], [[[-116.37077, 33.81644], [-116.36681, 33.81649], [-116.36674, 33.81289], [-116.37068, 33.81289], [-116.37077, 33.81644]]], [[[-116.35999, 33.81651], [-116.35778, 33.81653], [-116.35775, 33.81268], [-116.35786, 33.80936], [-116.35999, 33.80935], [-116.35999, 33.81651]]], [[[-116.35322, 33.81294], [-116.35316, 33.8165], [-116.34878, 33.81653], [-116.34882, 33.81472], [-116.34833, 33.81472], [-116.34826, 33.8129], [-116.34885, 33.81289], [-116.34886, 33.81297], [-116.35322, 33.81294]]], [[[-116.3755, 33.84104], [-116.37549, 33.84193], [-116.37339, 33.84194], [-116.37339, 33.84106], [-116.3755, 33.84104]]], [[[-116.38078, 33.8428], [-116.37974, 33.84281], [-116.37974, 33.84191], [-116.37868, 33.84191], [-116.37868, 33.84102], [-116.37974, 33.84101], [-116.37974, 33.8419], [-116.38078, 33.84189], [-116.38078, 33.8428]]], [[[-116.38606, 33.84093], [-116.38394, 33.84096], [-116.38394, 33.84368], [-116.38287, 33.84369], [-116.38287, 33.8446], [-116.38183, 33.84461], [-116.38183, 33.8437], [-116.38287, 33.84368], [-116.38287, 33.84188], [-116.38182, 33.84188], [-116.38183, 33.84098], [-116.38287, 33.84096], [-116.38286, 33.84007], [-116.38182, 33.84008], [-116.38182, 33.83917], [-116.38287, 33.83916], [-116.38287, 33.84007], [-116.38606, 33.84003], [-116.38606, 33.84093]]], [[[-116.38078, 33.84462], [-116.37973, 33.84463], [-116.37973, 33.84372], [-116.38078, 33.84371], [-116.38078, 33.84462]]], [[[-116.3947, 33.83882], [-116.39469, 33.84183], [-116.39253, 33.84183], [-116.39252, 33.84364], [-116.39145, 33.84365], [-116.39145, 33.84545], [-116.38927, 33.84545], [-116.38927, 33.84273], [-116.39036, 33.84272], [-116.39036, 33.84183], [-116.38819, 33.84182], [-116.38818, 33.83819], [-116.39362, 33.8382], [-116.3947, 33.83882]]], [[[-116.37763, 33.84191], [-116.37763, 33.84372], [-116.37656, 33.84373], [-116.37656, 33.84556], [-116.3755, 33.84555], [-116.37549, 33.84372], [-116.37656, 33.84371], [-116.37656, 33.84192], [-116.37763, 33.84191]]], [[[-116.3734, 33.84015], [-116.37133, 33.84017], [-116.37136, 33.84555], [-116.36887, 33.84555], [-116.36903, 33.83172], [-116.3713, 33.8324], [-116.37132, 33.83836], [-116.37339, 33.83835], [-116.3734, 33.84015]]], [[[-116.37046, 33.82381], [-116.37047, 33.82702], [-116.36881, 33.83109], [-116.36686, 33.8311], [-116.3667, 33.84555], [-116.36113, 33.84559], [-116.35576, 33.84558], [-116.35593, 33.83109], [-116.35374, 33.83108], [-116.35339, 33.82016], [-116.34902, 33.8202], [-116.34887, 33.81676], [-116.35325, 33.81673], [-116.35326, 33.8167], [-116.36113, 33.81667], [-116.36119, 33.82024], [-116.36008, 33.82027], [-116.36014, 33.82384], [-116.35899, 33.82384], [-116.35898, 33.82386], [-116.36065, 33.82389], [-116.37046, 33.82381]]], [[[-116.37973, 33.84552], [-116.37972, 33.84733], [-116.37903, 33.84732], [-116.37899, 33.84553], [-116.37973, 33.84552]]]]} | Open Access 1 | 17825 | Coachella Valley Ecological Reserve | 32120 | 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/Coachella-Valley-ER | Riverside 10 | 1892.601 | Coachella Valley ER | 1983 | 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]);