units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_TYP = 1, MNG_AGENCY = 47 and PARK_URL = "http://ohv.parks.ca.gov/?page_id=1217"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16691 | 16691 | 16690 | {"type": "MultiPolygon", "coordinates": [[[[-116.08108, 33.1619], [-116.06393, 33.16219], [-116.06388, 33.14767], [-116.06387, 33.14766], [-116.04723, 33.14833], [-116.04741, 33.16296], [-116.03073, 33.16383], [-116.03051, 33.15603], [-116.03035, 33.14894], [-116.01284, 33.14906], [-116.01278, 33.16004], [-116.01285, 33.16376], [-115.99557, 33.16383], [-115.99558, 33.16013], [-115.99555, 33.15639], [-115.99553, 33.14907], [-115.97819, 33.14877], [-115.97818, 33.15611], [-115.97823, 33.16375], [-115.96076, 33.16359], [-115.96086, 33.17826], [-115.97835, 33.17836], [-115.97833, 33.19276], [-115.99588, 33.19266], [-115.99572, 33.17821], [-116.01309, 33.17804], [-116.01331, 33.19248], [-116.03067, 33.19222], [-116.03092, 33.20692], [-116.01353, 33.20711], [-116.01376, 33.22175], [-116.03122, 33.22166], [-116.03154, 33.2364], [-116.04907, 33.23638], [-116.04924, 33.25104], [-116.03165, 33.25104], [-116.03153, 33.2364], [-116.01399, 33.23642], [-116.01407, 33.25103], [-115.99648, 33.25103], [-115.99646, 33.23642], [-116.01399, 33.23642], [-116.01375, 33.22176], [-115.99631, 33.22186], [-115.99638, 33.22914], [-115.97906, 33.22909], [-115.97896, 33.22196], [-115.96124, 33.22192], [-115.96145, 33.23615], [-115.97914, 33.23636], [-115.9789, 33.25103], [-115.96162, 33.25101], [-115.96144, 33.23616], [-115.94403, 33.23583], [-115.94364, 33.22077], [-115.96123, 33.22192], [-115.96112, 33.20734], [-115.94365, 33.20704], [-115.94362, 33.19249], [-115.92648, 33.19229], [-115.9265, 33.2068], [-115.91362, 33.20664], [-115.91318, 33.20568], [-115.91185, 33.20256], [-115.90916, 33.1966], [-115.90916, 33.19208], [-115.90709, 33.19205], [-115.90672, 33.19125], [-115.90609, 33.1902], [-115.90536, 33.1892], [-115.90453, 33.18825], [-115.9036, 33.18737], [-115.90258, 33.18655], [-115.90039, 33.18501], [-115.89163, 33.17875], [-115.89163, 33.17735], [-115.90919, 33.17757], [-115.90924, 33.1631], [-115.89163, 33.16305], [-115.89161, 33.14856], [-115.87415, 33.1476], [-115.87473, 33.13431], [-115.85911, 33.13419], [-115.85667, 33.12863], [-115.85661, 33.11935], [-115.87428, 33.11939], [-115.87474, 33.1343], [-115.892, 33.13427], [-115.89201, 33.11967], [-115.90082, 33.11964], [-115.90952, 33.11991], [-115.90929, 33.12707], [-115.9093, 33.13434], [-115.92662, 33.13434], [-115.9263, 33.14874], [-115.92631, 33.14875], [-115.93061, 33.14878], [-115.93068, 33.14517], [-115.93283, 33.14517], [-115.93278, 33.14879], [-115.94349, 33.14886], [-115.9438, 33.1343], [-115.95242, 33.13429], [-115.96148, 33.13461], [-115.96071, 33.14903], [-115.97818, 33.14877], [-115.97822, 33.1341], [-115.99542, 33.13419], [-115.99537, 33.12712], [-116.01257, 33.127], [-116.01266, 33.13412], [-116.02099, 33.13388], [-116.02992, 33.13391], [-116.03036, 33.14893], [-116.04722, 33.14833], [-116.04692, 33.13353], [-116.06377, 33.13307], [-116.06375, 33.12737], [-116.06433, 33.12774], [-116.06695, 33.12842], [-116.08038, 33.13209], [-116.08106, 33.13235], [-116.08106, 33.13287], [-116.06378, 33.13308], [-116.06388, 33.14766], [-116.08097, 33.14739], [-116.08108, 33.1555], [-116.08108, 33.1619]], [[-115.90901, 33.14864], [-115.90929, 33.13434], [-115.90064, 33.13434], [-115.892, 33.13427], [-115.89162, 33.14856], [-115.90901, 33.14864]], [[-115.9264, 33.16326], [-115.92641, 33.16325], [-115.9263, 33.14875], [-115.90902, 33.14864], [-115.90925, 33.16309], [-115.9264, 33.16326]], [[-115.92644, 33.17781], [-115.9092, 33.17758], [-115.90916, 33.19207], [-115.92647, 33.19228], [-115.92644, 33.17781]], [[-115.9436, 33.17803], [-115.94361, 33.17802], [-115.94358, 33.16342], [-115.92642, 33.16326], [-115.92644, 33.1778], [-115.9436, 33.17803]], [[-115.96071, 33.14904], [-115.9435, 33.14887], [-115.94359, 33.16342], [-115.96075, 33.16358], [-115.96071, 33.14904]], [[-115.96086, 33.17827], [-115.94361, 33.17803], [-115.94364, 33.19249], [-115.96096, 33.19269], [-115.96086, 33.17827]], [[-115.96098, 33.19269], [-115.96097, 33.1927], [-115.96112, 33.20733], [-115.97892, 33.20744], [-115.97832, 33.19277], [-115.96098, 33.19269]], [[-115.9963, 33.22186], [-115.99631, 33.22185], [-115.99613, 33.20728], [-115.97893, 33.20745], [-115.97897, 33.22196], [-115.9963, 33.22186]], [[-116.01265, 33.13413], [-115.99544, 33.1342], [-115.99554, 33.14906], [-116.01283, 33.14906], [-116.01265, 33.13413]], [[-116.0011, 33.19261], [-115.99588, 33.19267], [-115.99613, 33.20727], [-116.01353, 33.2071], [-116.0133, 33.19249], [-116.0011, 33.19261]]], [[[-116.08441, 33.25104], [-116.06683, 33.25104], [-116.06662, 33.23638], [-116.08416, 33.23639], [-116.08441, 33.25104]]]]} | Open Access 1 | 29203 | Ocotillo Wells State Vehicular Recreation Area | 13771 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://ohv.parks.ca.gov/?page_id=1217 | Imperial 20 | 21169.376 | Ocotillo Wells SVRA | 1976 | State Recreation Area 39 | 4 |
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]);