units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
121 rows where MNG_AGENCY = 1 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST, GAP_STS
DES_TP 14
ACCESS_TYP 3
- Open Access 105
- Restricted Access 12
- No Public Access 4
MNG_AG_TYP 1
- Federal Agency 121
MNG_AGENCY 1
- United States Bureau of Land Management · 121 ✖
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 | |
3760 | 3760 | 3759 | {"type": "Polygon", "coordinates": [[[-122.95962, 40.7165], [-122.95894, 40.72369], [-122.9584, 40.7272], [-122.95072, 40.72738], [-122.95056, 40.72704], [-122.94975, 40.72649], [-122.94961, 40.72632], [-122.94959, 40.72551], [-122.94491, 40.7255], [-122.94491, 40.72367], [-122.94258, 40.72366], [-122.94259, 40.72273], [-122.94025, 40.72272], [-122.94025, 40.72217], [-122.93902, 40.7227], [-122.939, 40.72267], [-122.93668, 40.72369], [-122.93688, 40.71878], [-122.93878, 40.71586], [-122.93907, 40.71613], [-122.94039, 40.71613], [-122.94432, 40.7162], [-122.95236, 40.71632], [-122.95962, 40.7165]]]} | Restricted Access 2 | 34904 | BLM | 16163 | 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 | Trinity 46 | 463.82 | BLM | 1963 | National Public Lands 1 | 3 | |
4144 | 4144 | 4143 | {"type": "Polygon", "coordinates": [[[-122.46384, 39.38383], [-122.45881, 39.38384], [-122.4585, 39.38043], [-122.46379, 39.38038], [-122.46384, 39.38383]]]} | Restricted Access 2 | 47499 | BLM | 16163 | 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 | Colusa 49 | 41.777 | BLM | 1963 | 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 | |
13054 | 13054 | 13053 | {"type": "Polygon", "coordinates": [[[-122.17843, 39.75789], [-122.17369, 39.75785], [-122.17368, 39.75452], [-122.17834, 39.75457], [-122.17843, 39.75789]]]} | Restricted Access 2 | 34910 | BLM | 16163 | 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 | Glenn 55 | 36.703 | BLM | 1963 | National Public Lands 1 | 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 | |
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-121.95567, 37.92322], [-121.95099, 37.92324], [-121.9509, 37.91961], [-121.95562, 37.91959], [-121.95567, 37.92322]]]} | Restricted Access 2 | 29557 | BLM | 16163 | 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 | 41.201 | BLM | 1963 | National Public Lands 1 | 3 | |
13966 | 13966 | 13965 | {"type": "Polygon", "coordinates": [[[-121.48188, 38.33873], [-121.47585, 38.33896], [-121.47579, 38.33592], [-121.48187, 38.33587], [-121.48188, 38.33873]]]} | No Public Access 3 | 37013 | BLM | 16161 | 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 | 42.907 | BLM | 0 | 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 | |
3763 | 3763 | 3762 | {"type": "Polygon", "coordinates": [[[-117.39664, 35.73738], [-117.39548, 35.74101], [-117.39454, 35.74102], [-117.39455, 35.74394], [-117.39429, 35.74463], [-117.39234, 35.74464], [-117.39228, 35.74751], [-117.39124, 35.74826], [-117.39002, 35.74841], [-117.38789, 35.74939], [-117.38787, 35.74825], [-117.38344, 35.74826], [-117.38344, 35.75187], [-117.37899, 35.75187], [-117.37899, 35.74464], [-117.38353, 35.74464], [-117.38353, 35.74102], [-117.38788, 35.74101], [-117.38788, 35.73739], [-117.39664, 35.73738]]]} | Restricted Access 2 | 34925 | BLM | 16163 | 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 | 334.438 | BLM | 1963 | National Public Lands 1 | 3 |
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]);