units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_TYP = 1 and DES_TP = 61
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16982 | 16982 | 16981 | {"type": "MultiPolygon", "coordinates": [[[[-115.65666, 33.54041], [-115.65238, 33.54042], [-115.65236, 33.52955], [-115.65662, 33.52953], [-115.65666, 33.54041]]], [[[-115.85287, 33.5254], [-115.87016, 33.5254], [-115.87101, 33.55466], [-115.88694, 33.55427], [-115.88971, 33.59858], [-115.8782, 33.59859], [-115.87815, 33.60593], [-115.86934, 33.60599], [-115.86927, 33.61336], [-115.86928, 33.61337], [-115.88964, 33.61314], [-115.88957, 33.6277], [-115.86938, 33.62794], [-115.86927, 33.61338], [-115.85208, 33.61315], [-115.85207, 33.61316], [-115.85188, 33.6281], [-115.83452, 33.62803], [-115.83465, 33.61319], [-115.81723, 33.6132], [-115.81725, 33.59866], [-115.7825, 33.59868], [-115.76688, 33.59864], [-115.76529, 33.58347], [-115.74795, 33.58357], [-115.74923, 33.5986], [-115.73912, 33.59858], [-115.7391, 33.6004], [-115.73477, 33.60039], [-115.73475, 33.60222], [-115.73041, 33.60222], [-115.73039, 33.60585], [-115.74775, 33.6059], [-115.74765, 33.62778], [-115.7129, 33.62766], [-115.71291, 33.64216], [-115.73028, 33.64224], [-115.73026, 33.65674], [-115.7216, 33.6567], [-115.6956, 33.65662], [-115.69563, 33.66361], [-115.69426, 33.66382], [-115.6782, 33.66383], [-115.6782, 33.65658], [-115.66008, 33.65648], [-115.6601, 33.64196], [-115.64276, 33.64196], [-115.64276, 33.64014], [-115.64059, 33.64014], [-115.6406, 33.63833], [-115.64276, 33.63832], [-115.64277, 33.6347], [-115.63844, 33.6347], [-115.63844, 33.63107], [-115.63412, 33.63108], [-115.63411, 33.6347], [-115.62545, 33.6347], [-115.62549, 33.61294], [-115.64281, 33.61292], [-115.64289, 33.5984], [-115.66024, 33.59841], [-115.66023, 33.60022], [-115.66249, 33.60022], [-115.6625, 33.59842], [-115.6613, 33.59841], [-115.6612, 33.58393], [-115.6437, 33.58391], [-115.64374, 33.56943], [-115.66112, 33.5694], [-115.66085, 33.52588], [-115.69562, 33.52576], [-115.73028, 33.52562], [-115.74758, 33.52558], [-115.74765, 33.53646], [-115.75195, 33.53644], [-115.75194, 33.53463], [-115.7541, 33.53462], [-115.75407, 33.531], [-115.75623, 33.53099], [-115.75625, 33.5328], [-115.76055, 33.53278], [-115.7605, 33.52554], [-115.7648, 33.52553], [-115.78242, 33.52561], [-115.79992, 33.52556], [-115.81741, 33.52547], [-115.83502, 33.52542], [-115.85287, 33.5254]], [[-115.66012, 33.63833], [-115.66011, 33.63834], [-115.66011, 33.64196], [-115.66464, 33.64198], [-115.66464, 33.63835], [-115.66012, 33.63833]], [[-115.67828, 33.62751], [-115.67148, 33.62748], [-115.67147, 33.62929], [-115.66466, 33.62927], [-115.66466, 33.63108], [-115.66919, 33.6311], [-115.66918, 33.642], [-115.67824, 33.64204], [-115.67828, 33.62751]], [[-115.63411, 33.63107], [-115.63412, 33.62745], [-115.6298, 33.62745], [-115.62979, 33.63107], [-115.63411, 33.63107]], [[-115.64279, 33.62745], [-115.64278, 33.62744], [-115.63846, 33.62744], [-115.63845, 33.62925], [-115.64278, 33.62925], [-115.64279, 33.62745]], [[-115.66466, 33.63109], [-115.66012, 33.63107], [-115.66011, 33.63469], [-115.66464, 33.63471], [-115.66466, 33.63109]], [[-115.66011, 33.62744], [-115.66013, 33.61291], [-115.65148, 33.61292], [-115.65147, 33.61473], [-115.64281, 33.61475], [-115.64281, 33.62018], [-115.65146, 33.62018], [-115.65147, 33.61836], [-115.65363, 33.61836], [-115.65363, 33.62018], [-115.65146, 33.62019], [-115.65146, 33.62744], [-115.66011, 33.62744]], [[-115.69566, 33.61302], [-115.69567, 33.61301], [-115.69571, 33.59847], [-115.67836, 33.59842], [-115.66704, 33.59841], [-115.66702, 33.60204], [-115.67155, 33.60205], [-115.67154, 33.60386], [-115.6738, 33.60387], [-115.67381, 33.60205], [-115.67608, 33.60205], [-115.67608, 33.60387], [-115.67381, 33.60387], [-115.6738, 33.60568], [-115.66699, 33.60567], [-115.66701, 33.60205], [-115.66475, 33.60204], [-115.66472, 33.60567], [-115.66246, 33.60567], [-115.66243, 33.60929], [-115.66016, 33.6093], [-115.66015, 33.61291], [-115.66922, 33.61293], [-115.66925, 33.60931], [-115.67378, 33.60932], [-115.67379, 33.6075], [-115.67606, 33.6075], [-115.67606, 33.60932], [-115.67379, 33.60932], [-115.67378, 33.61295], [-115.69566, 33.61302]], [[-115.74336, 33.61318], [-115.74339, 33.60953], [-115.73905, 33.60952], [-115.73903, 33.61316], [-115.74336, 33.61318]], [[-115.73036, 33.61132], [-115.73035, 33.61314], [-115.73251, 33.61315], [-115.73252, 33.61133], [-115.73036, 33.61132]], [[-115.74793, 33.58357], [-115.74775, 33.5546], [-115.74131, 33.5546], [-115.74127, 33.54917], [-115.74556, 33.54916], [-115.74555, 33.54735], [-115.73911, 33.54736], [-115.73917, 33.55461], [-115.73058, 33.55463], [-115.73046, 33.56922], [-115.73064, 33.58369], [-115.74793, 33.58357]], [[-115.76516, 33.56898], [-115.76517, 33.56897], [-115.76504, 33.5545], [-115.75207, 33.55457], [-115.75212, 33.56181], [-115.75645, 33.56179], [-115.75649, 33.56723], [-115.75432, 33.56724], [-115.7543, 33.56543], [-115.75215, 33.56544], [-115.75217, 33.56906], [-115.76516, 33.56898]], [[-115.78335, 33.56946], [-115.77881, 33.56933], [-115.77894, 33.57662], [-115.77437, 33.57649], [-115.77443, 33.58012], [-115.78358, 33.58041], [-115.78335, 33.56946]], [[-115.77447, 33.58376], [-115.77448, 33.58375], [-115.77442, 33.58013], [-115.76984, 33.57999], [-115.76989, 33.58361], [-115.77447, 33.58376]], [[-115.73908, 33.54554], [-115.73909, 33.54553], [-115.73904, 33.54011], [-115.73043, 33.54013], [-115.73047, 33.54375], [-115.73477, 33.54374], [-115.7348, 33.54555], [-115.73908, 33.54554]], [[-115.75844, 33.54004], [-115.75844, 33.53913], [-115.75629, 33.53915], [-115.7563, 33.54005], [-115.75844, 33.54004]], [[-115.76491, 33.54001], [-115.76492, 33.54], [-115.76489, 33.53639], [-115.76058, 33.53641], [-115.76061, 33.54003], [-115.76491, 33.54001]], [[-115.75842, 33.53643], [-115.75412, 33.53643], [-115.75412, 33.53824], [-115.75843, 33.53823], [-115.75842, 33.53643]]], [[[-115.74355, 33.57636], [-115.73488, 33.57643], [-115.7348, 33.56919], [-115.74349, 33.56913], [-115.74355, 33.57636]]]]} | Restricted Access 2 | 48542 | Orocopia Mountains Wilderness Area | 33261 | 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 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | https://www.blm.gov/visit/orocopia-mountains-wilderness | Riverside 10 | 54130.453 | Orocopia Mtns. Wilderness Area | 1994 | Wilderness Area 61 | 1 |
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]);