units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
75 rows where DES_TP = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11549 | 11549 | 11548 | {"type": "MultiPolygon", "coordinates": [[[[-121.29712, 37.14253], [-121.2971, 37.14615], [-121.28838, 37.14614], [-121.28844, 37.14253], [-121.29712, 37.14253]]], [[[-121.46858, 37.40598], [-121.46698, 37.41181], [-121.46632, 37.41195], [-121.46777, 37.40803], [-121.46562, 37.40803], [-121.46635, 37.40611], [-121.46431, 37.40547], [-121.46786, 37.4055], [-121.46783, 37.40568], [-121.46858, 37.40598]]], [[[-121.47286, 37.40907], [-121.46994, 37.41053], [-121.46781, 37.41159], [-121.46786, 37.4091], [-121.47286, 37.40907]]], [[[-121.48258, 37.41862], [-121.48023, 37.41798], [-121.47953, 37.41952], [-121.48202, 37.42021], [-121.47043, 37.42032], [-121.47051, 37.4198], [-121.4705, 37.4197], [-121.47046, 37.4196], [-121.47028, 37.41929], [-121.47014, 37.41903], [-121.47235, 37.41869], [-121.47403, 37.41785], [-121.47373, 37.4174], [-121.47819, 37.41521], [-121.47719, 37.41362], [-121.47899, 37.41326], [-121.47845, 37.41462], [-121.47935, 37.41604], [-121.4825, 37.41601], [-121.48258, 37.41862]]], [[[-121.4827, 37.40568], [-121.4827, 37.40911], [-121.47831, 37.40899], [-121.47843, 37.41187], [-121.47682, 37.4093], [-121.4747, 37.40968], [-121.4741, 37.40895], [-121.4783, 37.40899], [-121.47816, 37.40564], [-121.4827, 37.40568]]], [[[-121.50674, 37.22769], [-121.49806, 37.22767], [-121.49804, 37.22146], [-121.50672, 37.22122], [-121.50674, 37.22769]]], [[[-121.55854, 37.26361], [-121.55397, 37.2636], [-121.55395, 37.25973], [-121.54939, 37.25972], [-121.54936, 37.25199], [-121.54117, 37.25233], [-121.54116, 37.24874], [-121.53703, 37.24891], [-121.53702, 37.24552], [-121.54934, 37.24504], [-121.54937, 37.25198], [-121.55849, 37.25201], [-121.55854, 37.26361]]], [[[-121.58695, 37.27141], [-121.58209, 37.2714], [-121.58203, 37.26753], [-121.57225, 37.26751], [-121.57223, 37.26364], [-121.56311, 37.26362], [-121.56308, 37.25589], [-121.57219, 37.25591], [-121.57216, 37.24845], [-121.57671, 37.24846], [-121.57675, 37.25591], [-121.57767, 37.25592], [-121.57774, 37.26073], [-121.58195, 37.26075], [-121.58204, 37.26753], [-121.5869, 37.26754], [-121.58695, 37.27141]]], [[[-121.56775, 37.2785], [-121.56318, 37.27851], [-121.56317, 37.27529], [-121.56774, 37.2753], [-121.56775, 37.2785]]], [[[-121.5742, 37.15901], [-121.56967, 37.15903], [-121.56966, 37.15543], [-121.57418, 37.15542], [-121.5742, 37.15901]]], [[[-121.77458, 37.09927], [-121.77003, 37.09933], [-121.76998, 37.09717], [-121.77454, 37.09738], [-121.77458, 37.09927]]]]} | Open Access 1 | 23590 | 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 | Santa Clara 19 | 1397.348 | BLM | 1899 | National Public Lands 1 | 3 | |
12401 | 12401 | 12400 | {"type": "MultiPolygon", "coordinates": [[[[-118.21458, 35.49494], [-118.2101, 35.49494], [-118.21009, 35.48221], [-118.21103, 35.4826], [-118.21127, 35.48267], [-118.21147, 35.48269], [-118.21161, 35.48267], [-118.21179, 35.48261], [-118.21194, 35.48253], [-118.21214, 35.48237], [-118.21232, 35.48218], [-118.21246, 35.4819], [-118.2125, 35.48175], [-118.21253, 35.48159], [-118.21251, 35.48077], [-118.21265, 35.48043], [-118.21457, 35.48043], [-118.21458, 35.49494]]], [[[-118.21216, 35.48044], [-118.21231, 35.48084], [-118.21233, 35.4816], [-118.21227, 35.48185], [-118.21217, 35.48206], [-118.21205, 35.4822], [-118.2119, 35.48233], [-118.21177, 35.48243], [-118.21162, 35.48249], [-118.2115, 35.48252], [-118.21131, 35.48251], [-118.21111, 35.48245], [-118.21009, 35.48202], [-118.2101, 35.48043], [-118.21216, 35.48044]]]]} | Open Access 1 | 27002 | 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 | Kern 36 | 159.677 | BLM | 1899 | National Public Lands 1 | 3 | |
13010 | 13010 | 13009 | {"type": "MultiPolygon", "coordinates": [[[[-119.57776, 37.08324], [-119.57335, 37.08293], [-119.57341, 37.09006], [-119.56427, 37.08996], [-119.56419, 37.09714], [-119.5693, 37.09728], [-119.57331, 37.09731], [-119.5733, 37.1009], [-119.56937, 37.10089], [-119.56935, 37.10261], [-119.56943, 37.11188], [-119.55581, 37.11186], [-119.55575, 37.11541], [-119.55576, 37.11542], [-119.56478, 37.11541], [-119.56478, 37.1157], [-119.56399, 37.11562], [-119.5632, 37.11559], [-119.56255, 37.11563], [-119.56109, 37.11566], [-119.56028, 37.11575], [-119.55989, 37.11574], [-119.5586, 37.11557], [-119.55677, 37.1155], [-119.55635, 37.1155], [-119.55536, 37.11557], [-119.55483, 37.11568], [-119.55385, 37.11593], [-119.55345, 37.1161], [-119.55303, 37.1163], [-119.55264, 37.11659], [-119.55231, 37.11679], [-119.55196, 37.11695], [-119.55162, 37.11707], [-119.5513, 37.11714], [-119.55097, 37.1172], [-119.55049, 37.11718], [-119.54985, 37.11708], [-119.54927, 37.11696], [-119.54868, 37.11682], [-119.5482, 37.11665], [-119.54724, 37.11608], [-119.54673, 37.11567], [-119.54635, 37.1153], [-119.5456, 37.11445], [-119.54524, 37.11409], [-119.54491, 37.11365], [-119.54437, 37.11266], [-119.54375, 37.11185], [-119.54345, 37.1116], [-119.54304, 37.11121], [-119.54226, 37.11074], [-119.54226, 37.10789], [-119.538, 37.10783], [-119.53793, 37.10385], [-119.53868, 37.10183], [-119.53887, 37.10142], [-119.53897, 37.101], [-119.53902, 37.10075], [-119.53948, 37.09929], [-119.54106, 37.09641], [-119.54269, 37.09534], [-119.54609, 37.09512], [-119.54727, 37.09488], [-119.5482, 37.09452], [-119.54868, 37.09438], [-119.54962, 37.09404], [-119.54991, 37.09394], [-119.55182, 37.09316], [-119.55301, 37.09265], [-119.55452, 37.0919], [-119.5557, 37.09082], [-119.55776, 37.08927], [-119.55894, 37.08817], [-119.5595, 37.08662], [-119.55976, 37.08463], [-119.55981, 37.08323], [-119.56055, 37.08156], [-119.56118, 37.07955], [-119.56182, 37.07765], [-119.5627, 37.07654], [-119.56334, 37.07505], [-119.56334, 37.07405], [-119.5628, 37.07323], [-119.56124, 37.07194], [-119.56133, 37.07164], [-119.56119, 37.07128], [-119.56096, 37.07107], [-119.56099, 37.07034], [-119.56201, 37.06942], [-119.56236, 37.06896], [-119.56241, 37.0686], [-119.56216, 37.06684], [-119.5619, 37.06617], [-119.56182, 37.06572], [-119.56193, 37.06544], [-119.5623, 37.06503], [-119.56404, 37.06452], [-119.56887, 37.06425], [-119.57075, 37.06448], [-119.5709, 37.06436], [-119.57135, 37.06437], [-119.57375, 37.06514], [-119.57546, 37.06537], [-119.57581, 37.06569], [-119.57774, 37.07953], [-119.57776, 37.08324]], [[-119.55108, 37.11543], [-119.55109, 37.11542], [-119.55092, 37.11185], [-119.54678, 37.11184], [-119.54674, 37.11538], [-119.55108, 37.11543]]], [[[-119.60095, 37.08506], [-119.59645, 37.08506], [-119.59645, 37.08329], [-119.60094, 37.08328], [-119.60095, 37.08506]]], [[[-119.60835, 37.07603], [-119.60546, 37.07857], [-119.60401, 37.0777], [-119.60599, 37.07603], [-119.60835, 37.07603]]]]} | Open Access 1 | 31044 | 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 | Madera 48 | 2388.269 | BLM | 1899 | National Public Lands 1 | 3 | |
13036 | 13036 | 13035 | {"type": "MultiPolygon", "coordinates": [[[[-120.89266, 38.89126], [-120.89257, 38.89479], [-120.89056, 38.89479], [-120.89053, 38.89645], [-120.89055, 38.8965], [-120.89052, 38.89651], [-120.89051, 38.89665], [-120.89026, 38.89606], [-120.88994, 38.89557], [-120.8897, 38.89539], [-120.8902, 38.89507], [-120.8902, 38.89505], [-120.88701, 38.89192], [-120.8863, 38.89232], [-120.88538, 38.89288], [-120.88669, 38.89416], [-120.88634, 38.89408], [-120.88574, 38.89398], [-120.88504, 38.89384], [-120.88368, 38.89339], [-120.88316, 38.89325], [-120.88272, 38.89324], [-120.88239, 38.89325], [-120.88173, 38.89342], [-120.88175, 38.89109], [-120.88161, 38.88749], [-120.88598, 38.88758], [-120.88601, 38.88811], [-120.88448, 38.8884], [-120.88543, 38.89022], [-120.88525, 38.89116], [-120.88723, 38.89118], [-120.8875, 38.89026], [-120.89055, 38.89032], [-120.89056, 38.89124], [-120.89266, 38.89126]]], [[[-120.89052, 38.89708], [-120.8905, 38.89832], [-120.88629, 38.89826], [-120.88628, 38.8948], [-120.88172, 38.89471], [-120.88173, 38.89359], [-120.88261, 38.89353], [-120.88289, 38.89353], [-120.88321, 38.89357], [-120.88468, 38.89404], [-120.88557, 38.89425], [-120.88708, 38.89452], [-120.88862, 38.89603], [-120.88939, 38.89557], [-120.88966, 38.89576], [-120.89001, 38.89629], [-120.89025, 38.8967], [-120.89052, 38.89708]]], [[[-120.90802, 38.89769], [-120.90801, 38.8995], [-120.90421, 38.90102], [-120.90182, 38.89809], [-120.89949, 38.89818], [-120.89948, 38.89819], [-120.90211, 38.9014], [-120.90057, 38.90137], [-120.89993, 38.90132], [-120.89957, 38.90128], [-120.8991, 38.90119], [-120.89758, 38.90074], [-120.89596, 38.90018], [-120.89767, 38.90006], [-120.89943, 38.89996], [-120.89948, 38.89911], [-120.89947, 38.89808], [-120.90172, 38.89795], [-120.90373, 38.89788], [-120.90802, 38.89769]]], [[[-120.908, 38.89979], [-120.90797, 38.90135], [-120.90794, 38.90478], [-120.90656, 38.90475], [-120.90316, 38.90188], [-120.90172, 38.90292], [-120.90342, 38.90439], [-120.90344, 38.90474], [-120.90345, 38.90756], [-120.90024, 38.90617], [-120.89942, 38.90698], [-120.89945, 38.90553], [-120.89607, 38.90576], [-120.89515, 38.90581], [-120.89522, 38.90208], [-120.89524, 38.90015], [-120.89592, 38.90046], [-120.89747, 38.90106], [-120.89842, 38.90136], [-120.89937, 38.90157], [-120.90043, 38.90171], [-120.90143, 38.90177], [-120.90226, 38.90178], [-120.90291, 38.90174], [-120.90321, 38.90174], [-120.90373, 38.90161], [-120.90439, 38.90138], [-120.90532, 38.90099], [-120.90561, 38.90082], [-120.908, 38.89979]]]]} | Restricted Access 2 | 34872 | 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 | El Dorado 34 | 313.299 | BLM | 1963 | National Public Lands 1 | 3 | |
13037 | 13037 | 13036 | {"type": "MultiPolygon", "coordinates": [[[[-120.91216, 38.91541], [-120.91209, 38.91725], [-120.90299, 38.9179], [-120.90314, 38.91614], [-120.91216, 38.91541]]], [[[-120.91554, 38.91278], [-120.91489, 38.9134], [-120.91489, 38.91518], [-120.91293, 38.91536], [-120.9126, 38.91537], [-120.91264, 38.91385], [-120.91256, 38.91389], [-120.90898, 38.91085], [-120.908, 38.91025], [-120.90805, 38.90805], [-120.91228, 38.90808], [-120.9148, 38.90807], [-120.91488, 38.91165], [-120.91488, 38.91253], [-120.9149, 38.91254], [-120.91511, 38.91239], [-120.91554, 38.91278]]]]} | Restricted Access 2 | 34873 | 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 | El Dorado 34 | 121.211 | BLM | 1963 | National Public Lands 1 | 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 | |
13056 | 13056 | 13055 | {"type": "Polygon", "coordinates": [[[-116.45767, 33.96133], [-116.44054, 33.96104], [-116.44043, 33.94685], [-116.44884, 33.94684], [-116.44926, 33.95001], [-116.45349, 33.95007], [-116.45355, 33.94677], [-116.45738, 33.94676], [-116.45767, 33.96133]]]} | Restricted Access 2 | 34913 | 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 | Riverside 10 | 583.754 | 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 | |
14010 | 14010 | 14009 | {"type": "MultiPolygon", "coordinates": [[[[-121.16971, 38.68968], [-121.16956, 38.68978], [-121.16947, 38.69003], [-121.16953, 38.69019], [-121.16953, 38.69051], [-121.16963, 38.69076], [-121.16946, 38.69103], [-121.16939, 38.69126], [-121.16939, 38.69191], [-121.16934, 38.69192], [-121.16934, 38.69204], [-121.16816, 38.692], [-121.16732, 38.69206], [-121.16968, 38.68799], [-121.16971, 38.68968]]], [[[-121.17481, 38.68485], [-121.17481, 38.68485], [-121.17297, 38.68484], [-121.17407, 38.68395], [-121.17479, 38.68369], [-121.17481, 38.68485]]]]} | Open Access 1 | 37012 | 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 | 13.162 | BLM | 1899 | National Public Lands 1 | 3 | |
14011 | 14011 | 14010 | {"type": "MultiPolygon", "coordinates": [[[[-121.39308, 38.25788], [-121.39282, 38.25793], [-121.3912, 38.25765], [-121.39053, 38.25736], [-121.38989, 38.25736], [-121.38815, 38.25765], [-121.38745, 38.25829], [-121.38611, 38.25886], [-121.38527, 38.25893], [-121.38449, 38.25916], [-121.38449, 38.25883], [-121.38479, 38.25866], [-121.38562, 38.25835], [-121.38586, 38.25835], [-121.38673, 38.25793], [-121.38738, 38.25729], [-121.38738, 38.25722], [-121.38765, 38.25708], [-121.38841, 38.25699], [-121.3889, 38.25681], [-121.3894, 38.25639], [-121.38971, 38.25633], [-121.3905, 38.25651], [-121.39282, 38.25733], [-121.39308, 38.25765], [-121.39308, 38.25788]]], [[[-121.42286, 38.26178], [-121.42263, 38.26219], [-121.42237, 38.26226], [-121.42216, 38.26217], [-121.42211, 38.26176], [-121.42199, 38.26167], [-121.42004, 38.2622], [-121.42002, 38.2626], [-121.42022, 38.26286], [-121.42016, 38.2632], [-121.41981, 38.26391], [-121.41984, 38.26491], [-121.41973, 38.26515], [-121.41975, 38.26549], [-121.41993, 38.2656], [-121.42039, 38.26572], [-121.42059, 38.26595], [-121.42054, 38.26606], [-121.4199, 38.26618], [-121.41978, 38.26629], [-121.4197, 38.26661], [-121.41981, 38.2667], [-121.42123, 38.267], [-121.42117, 38.26716], [-121.42074, 38.26732], [-121.42065, 38.26748], [-121.42068, 38.26794], [-121.4208, 38.26844], [-121.42112, 38.26869], [-121.4211, 38.26875], [-121.42063, 38.26884], [-121.4222, 38.27507], [-121.42168, 38.27584], [-121.41959, 38.27586], [-121.41964, 38.28201], [-121.41166, 38.28198], [-121.4117, 38.27587], [-121.41178, 38.27586], [-121.41179, 38.2744], [-121.41042, 38.27372], [-121.40891, 38.27284], [-121.40773, 38.27283], [-121.40611, 38.27164], [-121.40584, 38.27084], [-121.40484, 38.26957], [-121.41045, 38.2696], [-121.41053, 38.26001], [-121.41761, 38.26002], [-121.41768, 38.26083], [-121.41767, 38.26132], [-121.42249, 38.26133], [-121.42286, 38.26155], [-121.42286, 38.26178]]]]} | Open Access 1 | 37014 | 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 | 549.812 | BLM | 1899 | National Public Lands 1 | 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 | |
16281 | 16281 | 16280 | {"type": "MultiPolygon", "coordinates": [[[[-116.63705, 32.6543], [-116.63666, 32.65793], [-116.63246, 32.6579], [-116.63234, 32.65971], [-116.62844, 32.65967], [-116.62841, 32.65423], [-116.63705, 32.6543]]], [[[-116.6751, 32.65373], [-116.66692, 32.65413], [-116.66649, 32.65776], [-116.65822, 32.65808], [-116.65532, 32.65822], [-116.65553, 32.65447], [-116.65695, 32.65448], [-116.65879, 32.65453], [-116.65834, 32.65078], [-116.66248, 32.6506], [-116.66212, 32.6469], [-116.66692, 32.64678], [-116.67506, 32.64654], [-116.67505, 32.65015], [-116.6751, 32.65373]]]]} | Open Access 1 | 5188 | Potrero/Hauser Mountain Management Area | 23927 | 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 Diego 4 | 477.586 | Potrero/Hauser Mtn. Management Area | 0 | 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]);