units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1 and DES_TP = 61
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 | 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 | 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 | 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 | 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 | 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 | 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 |
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]);