units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
105 rows where ACCESS_TYP = 1 and MNG_AGENCY = 1 sorted by map descending
This data as json, copyable, CSV (advanced)
DES_TP 12
MNG_AG_TYP 1
- Federal Agency 105
MNG_AGENCY 1
- United States Bureau of Land Management · 105 ✖
ACCESS_TYP 1
- Open Access · 105 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17003 | 17003 | 17002 | {"type": "Polygon", "coordinates": [[[-124.07864, 40.04562], [-124.07862, 40.04581], [-124.07864, 40.04624], [-124.07861, 40.04664], [-124.07799, 40.04665], [-124.07798, 40.04646], [-124.07763, 40.04638], [-124.07767, 40.04611], [-124.07732, 40.04585], [-124.07662, 40.04552], [-124.07668, 40.04548], [-124.07683, 40.0453], [-124.07689, 40.04525], [-124.07694, 40.04522], [-124.07711, 40.0453], [-124.07735, 40.04533], [-124.07791, 40.04538], [-124.07818, 40.04533], [-124.07837, 40.04536], [-124.07855, 40.04545], [-124.07864, 40.04562]]]} | Open Access 1 | 46939 | King Range National Conservation Area | 30563 | 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 | http://www.blm.gov/ca/st/en/prog/nlcs/King_Range_NCA/recreation/trails.html | Humboldt 45 | 3.788 | King Range Nat. Conservation Area | 0 | Conservation Area 13 | 2 |
7854 | 7854 | 7853 | {"type": "Polygon", "coordinates": [[[-123.86497, 41.05718], [-123.86496, 41.06079], [-123.85043, 41.06091], [-123.84555, 41.06099], [-123.84551, 41.05693], [-123.84064, 41.057], [-123.83562, 41.05704], [-123.8356, 41.05603], [-123.83463, 41.05611], [-123.83394, 41.0561], [-123.83264, 41.05595], [-123.83201, 41.05596], [-123.83041, 41.05607], [-123.83005, 41.05636], [-123.82979, 41.05672], [-123.82963, 41.05689], [-123.82917, 41.0573], [-123.82875, 41.05849], [-123.82805, 41.05907], [-123.82821, 41.05966], [-123.82829, 41.06055], [-123.83077, 41.06086], [-123.83089, 41.06465], [-123.82466, 41.06458], [-123.82451, 41.07152], [-123.81036, 41.07124], [-123.81036, 41.0677], [-123.80385, 41.0676], [-123.80369, 41.05917], [-123.80565, 41.04561], [-123.79632, 41.04547], [-123.79448, 41.05323], [-123.78965, 41.0529], [-123.79153, 41.04536], [-123.79157, 41.03057], [-123.78671, 41.03054], [-123.7869, 41.02643], [-123.78689, 41.02266], [-123.78751, 41.01573], [-123.78766, 41.01198], [-123.78769, 41.00798], [-123.78798, 41.00067], [-123.78808, 40.98603], [-123.78851, 40.97831], [-123.79345, 40.97835], [-123.79337, 40.98615], [-123.81205, 40.9866], [-123.81136, 41.00036], [-123.81136, 41.00111], [-123.81616, 41.00121], [-123.81607, 41.00833], [-123.8259, 41.00841], [-123.82585, 41.01211], [-123.83075, 41.01215], [-123.84538, 41.01247], [-123.84554, 41.00881], [-123.85059, 41.00893], [-123.85048, 41.01259], [-123.855, 41.01225], [-123.85491, 41.01604], [-123.84985, 41.01593], [-123.84023, 41.01589], [-123.84009, 41.01997], [-123.83979, 41.02678], [-123.83976, 41.03104], [-123.83992, 41.03451], [-123.84496, 41.03461], [-123.8496, 41.03462], [-123.84982, 41.03833], [-123.84024, 41.03835], [-123.84056, 41.04614], [-123.8505, 41.04599], [-123.85049, 41.04947], [-123.8553, 41.04957], [-123.85518, 41.0533], [-123.86008, 41.05347], [-123.86008, 41.05708], [-123.86497, 41.05718]]]} | Open Access 1 | 47710 | Lacks Creek Area of Critical Environmental Concern | 31484 | 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 | Humboldt 45 | 8163.003 | Lacks Creek Area of Critical Environmental Concern | 0 | Area of Critical Environmental Concern 509 | 3 | |
14344 | 14344 | 14343 | {"type": "Polygon", "coordinates": [[[-123.72102, 38.91865], [-123.70595, 38.91848], [-123.70459, 38.91852], [-123.69999, 38.9185], [-123.69997, 38.91669], [-123.70161, 38.91669], [-123.70162, 38.91736], [-123.70391, 38.91735], [-123.70391, 38.91734], [-123.70284, 38.91669], [-123.70178, 38.91608], [-123.70136, 38.91561], [-123.70111, 38.91496], [-123.70128, 38.91495], [-123.70153, 38.91556], [-123.70192, 38.916], [-123.7032, 38.91673], [-123.70412, 38.91672], [-123.70413, 38.91622], [-123.70457, 38.91616], [-123.70457, 38.91443], [-123.7045, 38.9121], [-123.70513, 38.91276], [-123.70537, 38.91298], [-123.70553, 38.91306], [-123.70629, 38.91334], [-123.70633, 38.91517], [-123.71051, 38.91513], [-123.71085, 38.91549], [-123.71104, 38.91556], [-123.71274, 38.91638], [-123.71333, 38.91654], [-123.71443, 38.91658], [-123.7151, 38.91669], [-123.71624, 38.91671], [-123.71677, 38.91676], [-123.71715, 38.91676], [-123.7176, 38.91688], [-123.71844, 38.91728], [-123.72102, 38.91865]]]} | Open Access 1 | 44402 | BLM | 16162 | 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 | Mendocino 24 | 119.366 | BLM | 1899 | National Public Lands 1 | 3 | |
6672 | 6672 | 6671 | {"type": "Polygon", "coordinates": [[[-122.32818, 38.60949], [-122.31832, 38.6092], [-122.31808, 38.60102], [-122.31799, 38.59676], [-122.31288, 38.59664], [-122.31259, 38.59249], [-122.30198, 38.59228], [-122.29559, 38.59208], [-122.29558, 38.59069], [-122.2955, 38.58738], [-122.29054, 38.58723], [-122.29066, 38.58418], [-122.28169, 38.58368], [-122.28203, 38.58072], [-122.27728, 38.58042], [-122.27703, 38.58372], [-122.2725, 38.58361], [-122.27258, 38.5801], [-122.26808, 38.5798], [-122.26822, 38.57673], [-122.26488, 38.57654], [-122.26488, 38.56972], [-122.25998, 38.56918], [-122.25994, 38.56577], [-122.25527, 38.5656], [-122.25519, 38.569], [-122.25034, 38.56881], [-122.2507, 38.56202], [-122.25998, 38.56235], [-122.25994, 38.55008], [-122.26024, 38.54659], [-122.27501, 38.54697], [-122.27515, 38.54366], [-122.27998, 38.54382], [-122.28505, 38.54391], [-122.28477, 38.55039], [-122.28963, 38.55043], [-122.28955, 38.55407], [-122.28956, 38.55408], [-122.2993, 38.55416], [-122.29942, 38.55049], [-122.31314, 38.55046], [-122.31316, 38.55421], [-122.31322, 38.55792], [-122.31326, 38.56538], [-122.323, 38.56552], [-122.323, 38.56938], [-122.328, 38.56947], [-122.32799, 38.58023], [-122.32797, 38.58024], [-122.32792, 38.58364], [-122.32781, 38.58738], [-122.32772, 38.59647], [-122.32778, 38.59778], [-122.32818, 38.60949]], [[-122.26488, 38.56971], [-122.26979, 38.57023], [-122.27465, 38.57107], [-122.2747, 38.5643], [-122.26489, 38.563], [-122.26488, 38.56971]], [[-122.29351, 38.58517], [-122.2935, 38.58516], [-122.29251, 38.5851], [-122.29246, 38.58551], [-122.29341, 38.58554], [-122.29351, 38.58517]]]} | Open Access 1 | 47526 | Cedar Roughs Area of Critical Environmental Concern | 31231 | 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 | Napa 11 | 5857.354 | Cedar Roughs Area of Critical Environmental Concern | 0 | Area of Critical Environmental Concern 509 | 3 | |
1449 | 1449 | 1448 | {"type": "Polygon", "coordinates": [[[-122.0, 38.01821], [-122.0, 38.01915], [-121.99675, 38.01907], [-121.99669, 38.01818], [-122.0, 38.01821]]]} | Open Access 1 | 9654 | BLM | 16162 | 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 | Contra Costa 12 | 7.245 | BLM | 1899 | National Public Lands 1 | 3 | |
13996 | 13996 | 13995 | {"type": "Polygon", "coordinates": [[[-121.25323, 38.55936], [-121.2475, 38.55947], [-121.24737, 38.55661], [-121.24799, 38.55691], [-121.24868, 38.55735], [-121.24949, 38.55796], [-121.24999, 38.55811], [-121.25026, 38.55828], [-121.2505, 38.5584], [-121.25086, 38.55851], [-121.25148, 38.55861], [-121.2527, 38.55892], [-121.25299, 38.55896], [-121.25311, 38.559], [-121.25319, 38.55919], [-121.25323, 38.55936]]]} | Open Access 1 | 37011 | BLM | 16162 | 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 | Sacramento 41 | 18.301 | BLM | 1899 | National Public Lands 1 | 3 | |
14548 | 14548 | 14547 | {"type": "Polygon", "coordinates": [[[-121.02582, 38.9373], [-121.02254, 38.93856], [-121.02232, 38.93981], [-121.02046, 38.94222], [-121.01715, 38.94306], [-121.01682, 38.93948], [-121.01802, 38.9396], [-121.01942, 38.93915], [-121.02, 38.93743], [-121.02141, 38.93616], [-121.02233, 38.93553], [-121.02281, 38.93501], [-121.0258, 38.93502], [-121.02575, 38.93638], [-121.02582, 38.9373]]]} | Open Access 1 | 47511 | Auburn State Recreation Area | 15701 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.parks.ca.gov/?page_id=502 | Placer 35 | 76.191 | Auburn SRA | 1966 | Recreation Management Area 49 | 4 |
6286 | 6286 | 6285 | {"type": "Polygon", "coordinates": [[[-120.99489, 35.76641], [-120.9948, 35.77005], [-120.99019, 35.76999], [-120.9901, 35.77362], [-120.98088, 35.77351], [-120.98096, 35.76988], [-120.98095, 35.76987], [-120.97635, 35.76981], [-120.97626, 35.77345], [-120.96703, 35.77333], [-120.96712, 35.76969], [-120.97634, 35.76981], [-120.97643, 35.76621], [-120.99027, 35.76638], [-120.99489, 35.76641]]]} | Open Access 1 | 1372 | Tierra Redonda Mountain Natural Area | 26354 | 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 Luis Obispo 1 | 331.67 | Tierra Redonda Mtn. Natural Area | 0 | Area of Critical Environmental Concern 509 | 3 | |
4041 | 4041 | 4040 | {"type": "Polygon", "coordinates": [[[-120.57185, 36.45758], [-120.57174, 36.47206], [-120.55388, 36.47215], [-120.55384, 36.45769], [-120.57185, 36.45758]]]} | Open Access 1 | 44314 | BLM | 16162 | 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 | Fresno 9 | 637.773 | BLM | 1899 | National Public Lands 1 | 3 | |
4043 | 4043 | 4042 | {"type": "Polygon", "coordinates": [[[-120.55391, 36.48829], [-120.55087, 36.48823], [-120.54155, 36.48821], [-120.53628, 36.48817], [-120.53614, 36.47209], [-120.55387, 36.47215], [-120.55394, 36.48302], [-120.55391, 36.48829]]]} | Open Access 1 | 44316 | BLM | 16162 | 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 | Fresno 9 | 700.283 | BLM | 1899 | National Public Lands 1 | 3 | |
4042 | 4042 | 4041 | {"type": "Polygon", "coordinates": [[[-120.53613, 36.47209], [-120.51795, 36.47204], [-120.5181, 36.46482], [-120.51814, 36.45778], [-120.53574, 36.45772], [-120.53613, 36.47209]]]} | Open Access 1 | 44315 | BLM | 16162 | 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 | Fresno 9 | 628.513 | BLM | 1899 | National Public Lands 1 | 3 | |
4044 | 4044 | 4043 | {"type": "Polygon", "coordinates": [[[-120.49644, 36.45785], [-120.49198, 36.45784], [-120.49191, 36.45059], [-120.48744, 36.45054], [-120.48737, 36.44678], [-120.4963, 36.44686], [-120.49644, 36.45785]]]} | Open Access 1 | 44317 | BLM | 16162 | 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 | Fresno 9 | 161.844 | BLM | 1899 | National Public Lands 1 | 3 | |
7592 | 7592 | 7591 | {"type": "Polygon", "coordinates": [[[-118.64305, 34.55924], [-118.6334, 34.55921], [-118.63325, 34.55904], [-118.63313, 34.55895], [-118.63308, 34.55888], [-118.63312, 34.55878], [-118.63332, 34.55862], [-118.63334, 34.55856], [-118.63328, 34.55848], [-118.63326, 34.55836], [-118.63331, 34.55816], [-118.63324, 34.55812], [-118.63319, 34.55806], [-118.63306, 34.55804], [-118.63288, 34.55811], [-118.63224, 34.55808], [-118.63175, 34.558], [-118.6316, 34.5579], [-118.63143, 34.5577], [-118.6314, 34.55755], [-118.63145, 34.55735], [-118.63154, 34.55717], [-118.63148, 34.55709], [-118.63126, 34.55701], [-118.63101, 34.55689], [-118.63087, 34.55674], [-118.63086, 34.55667], [-118.63091, 34.55658], [-118.63111, 34.55639], [-118.63166, 34.55604], [-118.63181, 34.55598], [-118.6319, 34.55591], [-118.63195, 34.55586], [-118.63196, 34.55582], [-118.63192, 34.55578], [-118.63184, 34.55575], [-118.63143, 34.5557], [-118.63118, 34.55562], [-118.63107, 34.55556], [-118.63094, 34.55543], [-118.63085, 34.55538], [-118.63068, 34.55546], [-118.63061, 34.55546], [-118.63055, 34.55543], [-118.63052, 34.55538], [-118.63052, 34.55517], [-118.63047, 34.55502], [-118.63047, 34.55488], [-118.63044, 34.5548], [-118.63038, 34.55472], [-118.63016, 34.55454], [-118.63014, 34.55452], [-118.63013, 34.55448], [-118.63015, 34.55445], [-118.63026, 34.55439], [-118.63031, 34.55427], [-118.63031, 34.554], [-118.63035, 34.5539], [-118.63085, 34.55351], [-118.63089, 34.55344], [-118.63088, 34.55341], [-118.63085, 34.55339], [-118.63063, 34.55335], [-118.63048, 34.5533], [-118.63025, 34.55342], [-118.62999, 34.55347], [-118.62998, 34.54746], [-118.63434, 34.54747], [-118.6345, 34.55842], [-118.64304, 34.55841], [-118.64305, 34.55924]]]} | Open Access 1 | 7301 | Castaic Lake State Recreation Area | 16945 | 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 | Los Angeles 6 | 127.866 | Castaic Lake SRA | 1965 | Recreation Management Area 49 | 4 | |
7571 | 7571 | 7570 | {"type": "Polygon", "coordinates": [[[-118.44001, 34.69513], [-118.43401, 34.69519], [-118.43401, 34.697], [-118.43071, 34.69703], [-118.43068, 34.69522], [-118.41969, 34.69531], [-118.41968, 34.6935], [-118.42187, 34.69347], [-118.42182, 34.68796], [-118.43061, 34.68796], [-118.43062, 34.68828], [-118.43925, 34.6883], [-118.44001, 34.69513]]]} | Open Access 1 | 7265 | California Desert National Conservation Area | 16716 | 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 | Los Angeles 6 | 341.603 | California Desert Nat. Conservation Area | 0 | Conservation Area 13 | 2 | |
6506 | 6506 | 6505 | {"type": "Polygon", "coordinates": [[[-117.3335, 35.30333], [-117.33291, 35.30939], [-117.32491, 35.31041], [-117.32488, 35.30386], [-117.3335, 35.30333]]]} | Open Access 1 | 2426 | US Dept of Interior | 26742 | 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 | 130.198 | US Dept of Interior | None 525 | |||
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 | |
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 | |
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 | |
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 | |
11485 | 11485 | 11484 | {"type": "Polygon", "coordinates": [[[-116.5984, 34.03271], [-116.59234, 34.03268], [-116.5902, 34.03278], [-116.5124, 34.03294], [-116.51134, 34.0331], [-116.51134, 34.03285], [-116.5104, 34.03285], [-116.50153, 34.03287], [-116.50152, 34.03285], [-116.49272, 34.03282], [-116.4927, 34.03289], [-116.49258, 34.03289], [-116.47522, 34.03278], [-116.45702, 34.03291], [-116.45772, 34.01817], [-116.45778, 34.01446], [-116.45803, 34.00359], [-116.45803, 34.00345], [-116.45798, 34.00344], [-116.45801, 34.00112], [-116.45839, 33.98969], [-116.45767, 33.96133], [-116.47297, 33.96141], [-116.47175, 33.96231], [-116.47324, 33.96232], [-116.47323, 33.9632], [-116.47432, 33.96321], [-116.47429, 33.96409], [-116.4751, 33.96408], [-116.47513, 33.9756], [-116.48787, 33.97591], [-116.4878, 33.9827], [-116.49015, 33.98276], [-116.49012, 33.98814], [-116.49273, 33.98804], [-116.49273, 33.99036], [-116.49276, 33.99373], [-116.49666, 33.99362], [-116.49677, 33.99043], [-116.5102, 33.99039], [-116.51029, 34.00493], [-116.51472, 34.00497], [-116.5145, 34.00902], [-116.51872, 34.00908], [-116.5186, 34.00499], [-116.52808, 34.00506], [-116.56268, 34.0054], [-116.56296, 34.0134], [-116.56305, 34.01633], [-116.56318, 34.02001], [-116.57423, 34.02002], [-116.58056, 34.02007], [-116.58051, 34.0128], [-116.59786, 34.0114], [-116.59794, 34.01826], [-116.5984, 34.03271]], [[-116.46219, 33.9897], [-116.46218, 33.98971], [-116.46227, 33.99671], [-116.46659, 33.99683], [-116.46652, 33.98978], [-116.46219, 33.9897]]]} | Open Access 1 | 23131 | Big Morongo Canyon Preserve | 16082 | 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 | Riverside 10 | 12448.862 | Big Morongo Canyon Preserve | None 1020 |
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]);