units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

7 rows where DES_TP = 61

View and edit SQL

Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, LABEL_NAME, YR_EST

MNG_AG_TYP

DES_TP

  • Wilderness Area · 7
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
641 640 {"type": "Polygon", "coordinates": [[[-116.7198, 34.11981], [-116.70246, 34.11977], [-116.70251, 34.10579], [-116.71018, 34.10612], [-116.71976, 34.10633], [-116.71977, 34.11761], [-116.7198, 34.11981]]]} Open Access 1 2745 San Gorgonio Wilderness 24903 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   San Bernardino 22 598.093 San Gorgonio Wilderness 0 Wilderness Area 61 1
1739 1738 {"type": "Polygon", "coordinates": [[[-116.58089, 34.11817], [-116.58086, 34.13271], [-116.56346, 34.1327], [-116.56345, 34.1182], [-116.56997, 34.11821], [-116.58089, 34.11817]]]} Open Access 1 12948 San Gorgonio Wilderness 24903 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   San Bernardino 22 639.291 San Gorgonio Wilderness 0 Wilderness Area 61 1
5280 5279 {"type": "Polygon", "coordinates": [[[-116.65041, 34.07675], [-116.63292, 34.07673], [-116.63292, 34.06229], [-116.65036, 34.06223], [-116.65041, 34.07675]]]} Open Access 1 2739 San Gorgonio Wilderness 24903 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   San Bernardino 22 639.84 San Gorgonio Wilderness 0 Wilderness Area 61 1
6520 6519 {"type": "Polygon", "coordinates": [[[-116.72005, 34.06233], [-116.71996, 34.06301], [-116.71996, 34.07689], [-116.70265, 34.07679], [-116.70266, 34.06231], [-116.72005, 34.06233]]]} Open Access 1 2765 San Gorgonio Wilderness 24903 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   San Bernardino 22 635.831 San Gorgonio Wilderness 0 Wilderness Area 61 1
6547 6546 {"type": "Polygon", "coordinates": [[[-116.64768, 34.26478], [-116.64761, 34.27934], [-116.6302, 34.27921], [-116.63013, 34.28917], [-116.63014, 34.29368], [-116.62398, 34.29372], [-116.61282, 34.29369], [-116.61286, 34.28368], [-116.61285, 34.27918], [-116.63019, 34.2792], [-116.63023, 34.27349], [-116.63023, 34.26472], [-116.64768, 34.26478]]]} Open Access 1 3228 Bighorn Mountains Wilderness 16099 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   San Bernardino 22 1272.489 Bighorn Mtns. Wilderness 0 Wilderness Area 61 1
10418 10417 {"type": "MultiPolygon", "coordinates": [[[[-115.99141, 33.57168], [-115.9914, 33.57946], [-115.98421, 33.58268], [-115.97834, 33.58744], [-115.97875, 33.58836], [-115.9805, 33.58927], [-115.98075, 33.58975], [-115.98079, 33.59074], [-115.97993, 33.59186], [-115.97644, 33.59084], [-115.97413, 33.59067], [-115.97109, 33.59108], [-115.96863, 33.59243], [-115.96664, 33.59231], [-115.9603, 33.58853], [-115.95399, 33.58621], [-115.95164, 33.58503], [-115.94742, 33.58502], [-115.94265, 33.5838], [-115.93993, 33.58381], [-115.93606, 33.58446], [-115.93598, 33.58449], [-115.93274, 33.58727], [-115.92716, 33.59059], [-115.92711, 33.59066], [-115.92671, 33.59191], [-115.92671, 33.59199], [-115.92692, 33.59248], [-115.92685, 33.59342], [-115.92425, 33.59869], [-115.88971, 33.59858], [-115.88786, 33.56905], [-115.90513, 33.56911], [-115.90441, 33.55438], [-115.91741, 33.55439], [-115.92175, 33.55441], [-115.92202, 33.56175], [-115.92956, 33.56179], [-115.92985, 33.56917], [-115.93306, 33.56919], [-115.93278, 33.5618], [-115.9344, 33.56181], [-115.93468, 33.56921], [-115.9438, 33.56927], [-115.94371, 33.56559], [-115.9394, 33.56556], [-115.93913, 33.55817], [-115.94373, 33.55819], [-115.9441, 33.55925], [-115.94792, 33.56184], [-115.94813, 33.56931], [-115.95675, 33.56937], [-115.97402, 33.56943], [-115.98728, 33.56954], [-115.99141, 33.57168]]], [[[-116.07804, 33.64241], [-116.06069, 33.64238], [-116.0607, 33.64509], [-116.06286, 33.6451], [-116.06287, 33.64601], [-116.06503, 33.64601], [-116.06503, 33.64783], [-116.0607, 33.64783], [-116.06074, 33.66415], [-116.05094, 33.66413], [-116.05093, 33.6605], [-116.04768, 33.66049], [-116.04768, 33.66412], [-116.04332, 33.66412], [-116.04332, 33.67138], [-116.02597, 33.67144], [-116.02598, 33.66056], [-116.02165, 33.66056], [-116.02164, 33.65875], [-116.01732, 33.65875], [-116.0173, 33.66419], [-116.01296, 33.6642], [-116.01296, 33.66601], [-116.01513, 33.66601], [-116.01513, 33.66782], [-116.00862, 33.66783], [-116.00861, 33.67146], [-115.99119, 33.67144], [-115.99126, 33.64242], [-115.97635, 33.6424], [-115.97629, 33.65691], [-115.95887, 33.65693], [-115.9589, 33.64242], [-115.9416, 33.64241], [-115.9242, 33.64238], [-115.92426, 33.62781], [-115.90692, 33.62777], [-115.90694, 33.62507], [-115.91, 33.62534], [-115.91153, 33.62228], [-115.91302, 33.62108], [-115.91434, 33.62018], [-115.91551, 33.61978], [-115.91827, 33.61832], [-115.91857, 33.6165], [-115.91715, 33.61496], [-115.91727, 33.61328], [-115.92434, 33.61329], [-115.9244, 33.5987], [-115.92453, 33.59869], [-115.9271, 33.59349], [-115.92718, 33.59245], [-115.92696, 33.59195], [-115.92734, 33.59076], [-115.93291, 33.58744], [-115.93614, 33.58467], [-115.93993, 33.58404], [-115.94261, 33.58402], [-115.94742, 33.58524], [-115.95157, 33.58525], [-115.95389, 33.58642], [-115.96017, 33.58873], [-115.96652, 33.5925], [-115.9666, 33.59252], [-115.96864, 33.59265], [-115.96873, 33.59263], [-115.97118, 33.59129], [-115.97413, 33.59089], [-115.97639, 33.59106], [-115.97993, 33.59208], [-115.98009, 33.59203], [-115.98102, 33.59083], [-115.98104, 33.59076], [-115.98101, 33.58973], [-115.98099, 33.58968], [-115.98072, 33.58916], [-115.98066, 33.5891], [-115.97895, 33.58821], [-115.97863, 33.5875], [-115.98436, 33.58286], [-115.9914, 33.57971], [-115.99139, 33.59889], [-116.01735, 33.59886], [-116.02605, 33.59888], [-116.04332, 33.59869], [-116.04332, 33.61322], [-116.06063, 33.61333], [-116.06066, 33.62785], [-116.07201, 33.62789], [-116.07218, 33.62819], [-116.07232, 33.6285], [-116.07243, 33.62881], [-116.07251, 33.62914], [-116.07258, 33.62956], [-116.07289, 33.63298], [-116.07297, 33.63335], [-116.07307, 33.63365], [-116.07321, 33.63394], [-116.07337, 33.63422], [-116.07361, 33.63454], [-116.07388, 33.63484], [-116.07424, 33.63515], [-116.07459, 33.63539], [-116.0749, 33.63556], [-116.07741, 33.63681], [-116.0777, 33.63693], [-116.07801, 33.63704], [-116.07804, 33.64241]], [[-115.99173, 33.65666], [-115.99157, 33.65665], [-115.99156, 33.65678], [-115.99172, 33.65679], [-115.99173, 33.65666]], [[-116.02382, 33.65875], [-116.02598, 33.65874], [-116.02599, 33.65693], [-116.02165, 33.65694], [-116.02165, 33.65874], [-116.02382, 33.65875]], [[-116.06066, 33.62786], [-116.04332, 33.62777], [-116.04332, 33.64231], [-116.03467, 33.64236], [-116.03466, 33.64963], [-116.03033, 33.64965], [-116.03033, 33.65328], [-116.03466, 33.65326], [-116.03466, 33.65689], [-116.04332, 33.65684], [-116.04332, 33.64594], [-116.05634, 33.64599], [-116.05634, 33.64417], [-116.05201, 33.64416], [-116.05201, 33.64234], [-116.06069, 33.64237], [-116.06066, 33.62786]], [[-116.05418, 33.64961], [-116.05419, 33.6496], [-116.05418, 33.6478], [-116.05201, 33.64779], [-116.05202, 33.6496], [-116.05418, 33.64961]]], [[[-116.00865, 33.59879], [-115.99148, 33.59881], [-115.99149, 33.58432], [-116.00855, 33.58428], [-116.00865, 33.59879]]]]} Open Access 1 48541 Mecca Hills Wilderness Area 33260 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/mecca-hills-wilderness Riverside 10 28615.465 Mecca Hills Wilderness Area 1994 Wilderness Area 61 1
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

CSV options:

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]);
Powered by Datasette · Query took 59.795ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette