units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 1, GAP_STS = 3 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, LABEL_NAME
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3953 | 3953 | 3952 | {"type": "MultiPolygon", "coordinates": [[[[-116.47118, 32.59401], [-116.46743, 32.59405], [-116.46637, 32.58975], [-116.47118, 32.58936], [-116.47118, 32.59401]]], [[[-116.47979, 32.60086], [-116.47118, 32.60103], [-116.47117, 32.5978], [-116.47972, 32.59759], [-116.47979, 32.60086]]], [[[-116.5103, 32.59017], [-116.50594, 32.59062], [-116.50592, 32.59305], [-116.49297, 32.59321], [-116.49297, 32.59689], [-116.48856, 32.59695], [-116.48863, 32.58793], [-116.51028, 32.58616], [-116.5103, 32.59017]]], [[[-116.49064, 32.60436], [-116.49064, 32.60436], [-116.48873, 32.60707], [-116.48865, 32.60441], [-116.49064, 32.60436]]], [[[-116.49751, 32.60263], [-116.49747, 32.6116], [-116.48887, 32.61176], [-116.48875, 32.60808], [-116.49141, 32.60434], [-116.49307, 32.60431], [-116.493, 32.60158], [-116.49318, 32.60137], [-116.49339, 32.60119], [-116.49365, 32.60103], [-116.49394, 32.60093], [-116.49423, 32.60086], [-116.49454, 32.60084], [-116.49469, 32.60085], [-116.49488, 32.60087], [-116.49524, 32.60094], [-116.49561, 32.60105], [-116.496, 32.6012], [-116.49629, 32.60136], [-116.49662, 32.60159], [-116.49689, 32.6018], [-116.49712, 32.60205], [-116.49726, 32.60222], [-116.49751, 32.60263]]], [[[-116.49333, 32.60061], [-116.49315, 32.60071], [-116.49301, 32.6008], [-116.49301, 32.60062], [-116.49333, 32.60061]]], [[[-116.4974, 32.60139], [-116.49709, 32.60114], [-116.49675, 32.6009], [-116.49643, 32.60073], [-116.49605, 32.60057], [-116.49738, 32.60054], [-116.4974, 32.60139]]], [[[-116.58117, 32.64521], [-116.57464, 32.6452], [-116.57476, 32.64702], [-116.57257, 32.64701], [-116.57279, 32.65062], [-116.56851, 32.65068], [-116.56859, 32.65237], [-116.5687, 32.65434], [-116.57301, 32.65433], [-116.57316, 32.65813], [-116.55772, 32.65807], [-116.54056, 32.6581], [-116.54055, 32.65443], [-116.52332, 32.6546], [-116.5227, 32.65459], [-116.5227, 32.65442], [-116.52278, 32.65337], [-116.52278, 32.65304], [-116.51831, 32.65304], [-116.51832, 32.64577], [-116.51397, 32.64575], [-116.51396, 32.64381], [-116.51008, 32.64387], [-116.51011, 32.64021], [-116.51441, 32.64015], [-116.51445, 32.6438], [-116.5234, 32.64366], [-116.52337, 32.62532], [-116.52056, 32.62532], [-116.51892, 32.62534], [-116.519, 32.62925], [-116.51926, 32.63647], [-116.50706, 32.63658], [-116.50154, 32.6366], [-116.50153, 32.63292], [-116.50503, 32.63292], [-116.50598, 32.63291], [-116.50611, 32.615], [-116.50605, 32.61147], [-116.50197, 32.61151], [-116.50192, 32.60762], [-116.51036, 32.60751], [-116.51019, 32.60038], [-116.51464, 32.60033], [-116.51466, 32.59691], [-116.52344, 32.59675], [-116.52345, 32.60024], [-116.5319, 32.6003], [-116.53193, 32.59657], [-116.54074, 32.59661], [-116.54488, 32.59658], [-116.54492, 32.60035], [-116.55451, 32.60034], [-116.55449, 32.6011], [-116.5545, 32.60118], [-116.55883, 32.60118], [-116.55877, 32.59773], [-116.56059, 32.59801], [-116.56064, 32.60093], [-116.56496, 32.60092], [-116.56493, 32.6077], [-116.56493, 32.60828], [-116.5692, 32.60829], [-116.5692, 32.61189], [-116.56491, 32.6119], [-116.5649, 32.61443], [-116.56495, 32.61919], [-116.56216, 32.61915], [-116.56215, 32.6184], [-116.55787, 32.61839], [-116.55769, 32.64017], [-116.56185, 32.64021], [-116.56185, 32.64104], [-116.56351, 32.64083], [-116.56349, 32.64328], [-116.5727, 32.64331], [-116.58108, 32.64337], [-116.58117, 32.64521]]], [[[-116.53535, 32.5841], [-116.53522, 32.58585], [-116.52775, 32.58584], [-116.52774, 32.58917], [-116.53206, 32.58919], [-116.53205, 32.58971], [-116.52346, 32.5897], [-116.52346, 32.58583], [-116.513, 32.58594], [-116.53535, 32.5841]]], [[[-116.54059, 32.58367], [-116.54057, 32.58585], [-116.54058, 32.5892], [-116.53627, 32.5892], [-116.53628, 32.58585], [-116.53587, 32.58584], [-116.536, 32.58405], [-116.54059, 32.58367]]], [[[-116.57937, 32.62549], [-116.57497, 32.62547], [-116.57493, 32.62914], [-116.57396, 32.62914], [-116.57344, 32.62857], [-116.57333, 32.6282], [-116.57325, 32.6281], [-116.57313, 32.628], [-116.57304, 32.62776], [-116.573, 32.62771], [-116.57293, 32.62766], [-116.57282, 32.62763], [-116.57217, 32.62759], [-116.57203, 32.62761], [-116.5714, 32.62776], [-116.57097, 32.62772], [-116.57092, 32.62787], [-116.57128, 32.62792], [-116.57142, 32.62793], [-116.57219, 32.62776], [-116.57283, 32.6278], [-116.57287, 32.62784], [-116.57296, 32.62808], [-116.57311, 32.62821], [-116.57316, 32.62829], [-116.57321, 32.62854], [-116.57326, 32.62863], [-116.57371, 32.62914], [-116.56863, 32.62915], [-116.56863, 32.62638], [-116.56923, 32.61918], [-116.57369, 32.61912], [-116.57504, 32.61912], [-116.57501, 32.62178], [-116.57534, 32.6218], [-116.57539, 32.62533], [-116.57936, 32.62537], [-116.57937, 32.62549]]], [[[-116.59644, 32.58582], [-116.59215, 32.58582], [-116.59213, 32.58939], [-116.59214, 32.58948], [-116.57507, 32.58953], [-116.57506, 32.59292], [-116.57507, 32.59944], [-116.57448, 32.59946], [-116.57376, 32.59939], [-116.57321, 32.59931], [-116.57247, 32.59915], [-116.57093, 32.59874], [-116.57068, 32.59866], [-116.57068, 32.59732], [-116.57167, 32.59731], [-116.57165, 32.59033], [-116.57066, 32.59032], [-116.57065, 32.58955], [-116.57506, 32.58952], [-116.57505, 32.58656], [-116.57501, 32.58084], [-116.59209, 32.57943], [-116.59212, 32.58216], [-116.59643, 32.58216], [-116.59644, 32.58582]]], [[[-116.57507, 32.60384], [-116.57069, 32.60384], [-116.57068, 32.59901], [-116.57244, 32.59949], [-116.5732, 32.59965], [-116.57373, 32.59972], [-116.57423, 32.59977], [-116.57507, 32.59978], [-116.57507, 32.60384]]], [[[-116.60247, 32.64361], [-116.594, 32.64348], [-116.59431, 32.65061], [-116.59854, 32.65064], [-116.59867, 32.65421], [-116.59018, 32.65411], [-116.58954, 32.64342], [-116.59399, 32.64347], [-116.59383, 32.63985], [-116.60225, 32.63993], [-116.60233, 32.63994], [-116.60247, 32.64361]]], [[[-116.61145, 32.65429], [-116.61128, 32.66857], [-116.60696, 32.66858], [-116.60721, 32.65432], [-116.60285, 32.65426], [-116.60273, 32.65065], [-116.60705, 32.65068], [-116.60722, 32.65431], [-116.61145, 32.65429]]], [[[-116.61889, 32.63298], [-116.61011, 32.63281], [-116.60976, 32.62939], [-116.61619, 32.62929], [-116.61864, 32.62927], [-116.61889, 32.63298]]], [[[-116.69059, 32.6158], [-116.69053, 32.61934], [-116.68648, 32.61934], [-116.68649, 32.62294], [-116.68226, 32.6229], [-116.67779, 32.6224], [-116.6778, 32.62591], [-116.67331, 32.62531], [-116.67321, 32.6288], [-116.66953, 32.62888], [-116.66967, 32.63253], [-116.66974, 32.63375], [-116.6699, 32.63589], [-116.68193, 32.63587], [-116.68186, 32.63754], [-116.68003, 32.63754], [-116.68008, 32.6393], [-116.68032, 32.64287], [-116.67842, 32.64293], [-116.67866, 32.64651], [-116.67506, 32.64654], [-116.66692, 32.64678], [-116.66212, 32.6469], [-116.66217, 32.64747], [-116.66248, 32.6506], [-116.65834, 32.65078], [-116.65879, 32.65453], [-116.65695, 32.65448], [-116.65553, 32.65448], [-116.65534, 32.65822], [-116.65822, 32.65808], [-116.66648, 32.65776], [-116.66692, 32.65413], [-116.6751, 32.65373], [-116.67912, 32.65372], [-116.67836, 32.66471], [-116.67419, 32.66477], [-116.67387, 32.66853], [-116.65651, 32.66894], [-116.63942, 32.66885], [-116.62414, 32.66854], [-116.61989, 32.66855], [-116.61987, 32.6578], [-116.62407, 32.65781], [-116.62404, 32.6542], [-116.62841, 32.65423], [-116.62839, 32.65067], [-116.63173, 32.65071], [-116.63259, 32.6507], [-116.63243, 32.6471], [-116.6239, 32.64716], [-116.61531, 32.64712], [-116.6152, 32.64357], [-116.61955, 32.6435], [-116.61941, 32.64011], [-116.62374, 32.64016], [-116.62336, 32.63658], [-116.62758, 32.6365], [-116.62774, 32.64011], [-116.63215, 32.64004], [-116.63237, 32.64541], [-116.63657, 32.64541], [-116.6369, 32.65071], [-116.64116, 32.65068], [-116.64541, 32.65072], [-116.64536, 32.65009], [-116.6451, 32.6471], [-116.64932, 32.64707], [-116.64971, 32.65082], [-116.65405, 32.65081], [-116.65834, 32.65078], [-116.65701, 32.63963], [-116.6589, 32.63961], [-116.65891, 32.63959], [-116.65723, 32.63284], [-116.66171, 32.63263], [-116.66147, 32.62631], [-116.66142, 32.62543], [-116.66159, 32.61863], [-116.66133, 32.61171], [-116.6693, 32.61178], [-116.66931, 32.61519], [-116.66959, 32.6152], [-116.6696, 32.61531], [-116.67335, 32.61539], [-116.6822, 32.61539], [-116.69059, 32.6158]], [[-116.63705, 32.65431], [-116.63704, 32.6543], [-116.62842, 32.65423], [-116.62845, 32.65967], [-116.63233, 32.65971], [-116.63245, 32.6579], [-116.63666, 32.65793], [-116.63705, 32.65431]]], [[[-116.6445, 32.61846], [-116.64041, 32.61844], [-116.6404, 32.61842], [-116.63593, 32.61847], [-116.63595, 32.61898], [-116.6361, 32.62211], [-116.63165, 32.62213], [-116.6317, 32.62278], [-116.63194, 32.62553], [-116.62776, 32.62562], [-116.62735, 32.62215], [-116.62283, 32.62218], [-116.6223, 32.61872], [-116.6223, 32.61855], [-116.62233, 32.61855], [-116.62689, 32.61853], [-116.62671, 32.61485], [-116.63104, 32.61479], [-116.63071, 32.61104], [-116.63521, 32.6109], [-116.63556, 32.61471], [-116.64012, 32.61465], [-116.64412, 32.61466], [-116.6445, 32.61846]]], [[[-116.67822, 32.59757], [-116.6781, 32.60103], [-116.67378, 32.60091], [-116.67376, 32.60146], [-116.67347, 32.60464], [-116.67255, 32.60463], [-116.66534, 32.60442], [-116.66532, 32.59733], [-116.67822, 32.59757]]], [[[-116.69934, 32.66102], [-116.69927, 32.66345], [-116.69928, 32.66393], [-116.69927, 32.66459], [-116.69916, 32.6682], [-116.69093, 32.66811], [-116.68232, 32.66832], [-116.68275, 32.66096], [-116.68691, 32.66092], [-116.68713, 32.65371], [-116.69107, 32.65369], [-116.69177, 32.64642], [-116.69112, 32.64285], [-116.69518, 32.64286], [-116.69556, 32.64647], [-116.69549, 32.64735], [-116.69527, 32.65373], [-116.69525, 32.65374], [-116.6952, 32.66097], [-116.69934, 32.66102]]], [[[-116.73739, 32.62831], [-116.72055, 32.62796], [-116.72053, 32.62583], [-116.7115, 32.62647], [-116.71168, 32.63287], [-116.72047, 32.63266], [-116.72047, 32.63431], [-116.72039, 32.63528], [-116.72451, 32.63535], [-116.72441, 32.63902], [-116.72012, 32.63899], [-116.72033, 32.63611], [-116.71595, 32.6361], [-116.71589, 32.63941], [-116.71608, 32.63943], [-116.71637, 32.63943], [-116.71639, 32.64297], [-116.71992, 32.64299], [-116.72003, 32.65024], [-116.71637, 32.65028], [-116.71632, 32.65507], [-116.71627, 32.66515], [-116.71214, 32.66486], [-116.71203, 32.65031], [-116.71636, 32.65027], [-116.71641, 32.64663], [-116.70775, 32.64656], [-116.70745, 32.63607], [-116.69483, 32.6362], [-116.69485, 32.633], [-116.70736, 32.63295], [-116.7072, 32.62679], [-116.71149, 32.62647], [-116.7117, 32.62354], [-116.72052, 32.62295], [-116.72052, 32.62112], [-116.73738, 32.62108], [-116.73739, 32.62831]]], [[[-116.71657, 32.68417], [-116.70816, 32.68296], [-116.70811, 32.6793], [-116.71052, 32.67928], [-116.71327, 32.6793], [-116.71653, 32.67929], [-116.71657, 32.68417]]], [[[-116.73314, 32.61707], [-116.73102, 32.61755], [-116.72773, 32.61758], [-116.72798, 32.61723], [-116.72798, 32.61706], [-116.72791, 32.61668], [-116.72783, 32.61648], [-116.72774, 32.61631], [-116.7276, 32.61596], [-116.72731, 32.61585], [-116.72692, 32.61591], [-116.72672, 32.61579], [-116.72641, 32.61564], [-116.72619, 32.61556], [-116.72587, 32.61548], [-116.72539, 32.61527], [-116.72481, 32.61526], [-116.72461, 32.61524], [-116.72462, 32.61421], [-116.72454, 32.61034], [-116.7296, 32.61029], [-116.72971, 32.61412], [-116.73303, 32.61407], [-116.73314, 32.61707]]], [[[-116.72749, 32.61713], [-116.72727, 32.61738], [-116.72724, 32.61758], [-116.72469, 32.6176], [-116.72464, 32.61575], [-116.72503, 32.61577], [-116.7256, 32.61589], [-116.72607, 32.61612], [-116.72661, 32.61627], [-116.72695, 32.61639], [-116.72734, 32.61647], [-116.72749, 32.61713]]], [[[-116.76245, 32.63553], [-116.76236, 32.6392], [-116.75822, 32.63925], [-116.75355, 32.63928], [-116.74551, 32.63921], [-116.7455, 32.63921], [-116.74549, 32.63194], [-116.74147, 32.63195], [-116.74142, 32.62106], [-116.74363, 32.62102], [-116.74451, 32.62098], [-116.74475, 32.62106], [-116.74477, 32.62104], [-116.7455, 32.62127], [-116.74548, 32.62201], [-116.7455, 32.62462], [-116.74955, 32.6246], [-116.74957, 32.62828], [-116.74955, 32.63193], [-116.75102, 32.63194], [-116.75361, 32.63191], [-116.75359, 32.63559], [-116.76245, 32.63553]]]]} | Open Access 1 | 1354 | 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 | 17098.666 | Potrero/Hauser Mtn. Management Area | 0 | National Public Lands 1 | 3 | |
| 6192 | 6192 | 6191 | {"type": "MultiPolygon", "coordinates": [[[[-116.24333, 32.62806], [-116.24326, 32.63187], [-116.23893, 32.63197], [-116.23882, 32.63916], [-116.23868, 32.63919], [-116.23864, 32.63923], [-116.23859, 32.63929], [-116.23866, 32.63934], [-116.23863, 32.63938], [-116.23456, 32.63939], [-116.23461, 32.63584], [-116.23233, 32.6359], [-116.23235, 32.63502], [-116.23459, 32.63495], [-116.23461, 32.63405], [-116.23236, 32.63409], [-116.23238, 32.6332], [-116.23029, 32.63329], [-116.2303, 32.63219], [-116.23406, 32.63209], [-116.23465, 32.63206], [-116.23473, 32.62842], [-116.23475, 32.62521], [-116.23906, 32.62483], [-116.23901, 32.62825], [-116.24333, 32.62806]]], [[[-116.25126, 32.62118], [-116.25119, 32.62478], [-116.25122, 32.62843], [-116.24737, 32.62824], [-116.24733, 32.62459], [-116.24733, 32.62104], [-116.25126, 32.62118]]], [[[-116.264, 32.64655], [-116.25971, 32.64654], [-116.25599, 32.64659], [-116.25599, 32.6429], [-116.26398, 32.64296], [-116.264, 32.64655]]], [[[-116.26077, 32.61059], [-116.25656, 32.6106], [-116.25646, 32.60668], [-116.26064, 32.60631], [-116.26077, 32.61059]]], [[[-116.26927, 32.62176], [-116.2692, 32.6254], [-116.26479, 32.62531], [-116.26471, 32.62166], [-116.26927, 32.62176]]], [[[-116.3854, 32.7172], [-116.38542, 32.71826], [-116.38539, 32.71971], [-116.37279, 32.71974], [-116.37279, 32.71827], [-116.37668, 32.71827], [-116.37676, 32.71822], [-116.37676, 32.711], [-116.38104, 32.711], [-116.38104, 32.71358], [-116.38137, 32.71381], [-116.38138, 32.7146], [-116.38532, 32.7146], [-116.38537, 32.71717], [-116.3854, 32.7172]]], [[[-116.4495, 32.60128], [-116.4366, 32.60155], [-116.43686, 32.61615], [-116.42796, 32.61623], [-116.42795, 32.61974], [-116.42351, 32.61974], [-116.42346, 32.61627], [-116.41911, 32.61631], [-116.41471, 32.61628], [-116.41473, 32.62], [-116.41528, 32.62001], [-116.41527, 32.62049], [-116.411, 32.62052], [-116.41099, 32.62412], [-116.40671, 32.62413], [-116.40671, 32.62452], [-116.4054, 32.62395], [-116.40527, 32.62386], [-116.40522, 32.62378], [-116.4052, 32.62369], [-116.40525, 32.62337], [-116.40523, 32.62324], [-116.40517, 32.62313], [-116.40493, 32.62284], [-116.40486, 32.62273], [-116.40482, 32.62258], [-116.40482, 32.6223], [-116.40477, 32.62214], [-116.40461, 32.62197], [-116.40433, 32.62185], [-116.40418, 32.62175], [-116.40408, 32.62165], [-116.40401, 32.6215], [-116.40399, 32.62141], [-116.40399, 32.6213], [-116.40408, 32.621], [-116.40409, 32.62092], [-116.40408, 32.62081], [-116.40407, 32.62074], [-116.40368, 32.61957], [-116.40367, 32.61949], [-116.40368, 32.61938], [-116.40377, 32.61908], [-116.40378, 32.61896], [-116.40375, 32.6188], [-116.4037, 32.61866], [-116.40275, 32.61692], [-116.40267, 32.61681], [-116.40249, 32.61661], [-116.39966, 32.61188], [-116.39939, 32.61136], [-116.39938, 32.61123], [-116.39942, 32.61102], [-116.39923, 32.61099], [-116.39917, 32.61126], [-116.39918, 32.61134], [-116.39923, 32.61147], [-116.39945, 32.61188], [-116.40218, 32.6164], [-116.40243, 32.6168], [-116.40249, 32.61681], [-116.40249, 32.61689], [-116.40258, 32.617], [-116.40352, 32.61872], [-116.40356, 32.61882], [-116.40358, 32.61901], [-116.40357, 32.61911], [-116.40348, 32.61938], [-116.40348, 32.61956], [-116.40387, 32.6208], [-116.40388, 32.62087], [-116.40388, 32.62098], [-116.40382, 32.62121], [-116.4038, 32.62145], [-116.40388, 32.62168], [-116.40395, 32.62178], [-116.40403, 32.62186], [-116.40415, 32.62196], [-116.40447, 32.62209], [-116.40455, 32.62215], [-116.40459, 32.62221], [-116.40463, 32.62231], [-116.40463, 32.62258], [-116.40468, 32.62278], [-116.40479, 32.62297], [-116.40502, 32.62324], [-116.40504, 32.62329], [-116.40505, 32.62334], [-116.40501, 32.62367], [-116.40502, 32.62377], [-116.40506, 32.62386], [-116.40514, 32.62398], [-116.40527, 32.62407], [-116.4067, 32.6247], [-116.4067, 32.63139], [-116.4025, 32.63141], [-116.39815, 32.63141], [-116.39819, 32.63863], [-116.39385, 32.63862], [-116.39386, 32.63142], [-116.39391, 32.61682], [-116.39403, 32.60232], [-116.40246, 32.60225], [-116.40245, 32.59495], [-116.44947, 32.59112], [-116.4495, 32.60128]]], [[[-116.4316, 32.68532], [-116.43157, 32.68881], [-116.43157, 32.69649], [-116.42802, 32.6965], [-116.42804, 32.70379], [-116.41621, 32.70382], [-116.4067, 32.70383], [-116.40674, 32.71503], [-116.40364, 32.71504], [-116.40364, 32.71465], [-116.40248, 32.71466], [-116.40246, 32.71832], [-116.3939, 32.71829], [-116.39388, 32.71467], [-116.39819, 32.71465], [-116.39816, 32.70741], [-116.4025, 32.70739], [-116.40244, 32.70383], [-116.40669, 32.70382], [-116.40671, 32.69904], [-116.4067, 32.69304], [-116.41099, 32.69304], [-116.411, 32.68936], [-116.41527, 32.68934], [-116.41527, 32.69673], [-116.41941, 32.69673], [-116.41942, 32.69652], [-116.42371, 32.6965], [-116.42371, 32.69285], [-116.41942, 32.69287], [-116.41942, 32.68915], [-116.41939, 32.68635], [-116.4194, 32.68534], [-116.42315, 32.68531], [-116.42314, 32.68166], [-116.42533, 32.68166], [-116.4273, 32.68166], [-116.42727, 32.68533], [-116.4316, 32.68532]]], [[[-116.41533, 32.63855], [-116.40675, 32.63859], [-116.4067, 32.63516], [-116.41037, 32.63515], [-116.41529, 32.63511], [-116.41533, 32.63855]]], [[[-116.41954, 32.65852], [-116.41952, 32.65853], [-116.4195, 32.66029], [-116.41525, 32.66029], [-116.41524, 32.65661], [-116.41204, 32.6566], [-116.41188, 32.65626], [-116.41175, 32.65584], [-116.41167, 32.65547], [-116.41163, 32.65506], [-116.41164, 32.65466], [-116.41188, 32.65296], [-116.41188, 32.65263], [-116.41185, 32.65232], [-116.41178, 32.65198], [-116.4116, 32.65153], [-116.41103, 32.65045], [-116.41102, 32.64583], [-116.41845, 32.6458], [-116.41911, 32.64604], [-116.41954, 32.64615], [-116.41954, 32.65852]]], [[[-116.42811, 32.6603], [-116.42809, 32.678], [-116.4195, 32.678], [-116.41953, 32.6748], [-116.41952, 32.6603], [-116.42811, 32.6603]]], [[[-116.48816, 32.68019], [-116.48815, 32.68203], [-116.4753, 32.68203], [-116.4753, 32.67865], [-116.47529, 32.67842], [-116.47102, 32.67843], [-116.47101, 32.68202], [-116.46671, 32.68201], [-116.46672, 32.68931], [-116.4625, 32.68933], [-116.46246, 32.69291], [-116.45398, 32.6929], [-116.45394, 32.69656], [-116.45819, 32.69657], [-116.45814, 32.70016], [-116.45391, 32.70018], [-116.45386, 32.70378], [-116.44525, 32.70377], [-116.44538, 32.68933], [-116.43665, 32.6893], [-116.43666, 32.69649], [-116.436, 32.69649], [-116.43599, 32.6893], [-116.43665, 32.68929], [-116.43667, 32.68205], [-116.44953, 32.68204], [-116.44955, 32.6784], [-116.44997, 32.67842], [-116.44997, 32.68157], [-116.4543, 32.6815], [-116.45435, 32.67058], [-116.45857, 32.67051], [-116.45856, 32.6712], [-116.45823, 32.67121], [-116.45824, 32.67482], [-116.46677, 32.67482], [-116.46683, 32.66022], [-116.46257, 32.66025], [-116.46257, 32.65951], [-116.46284, 32.65949], [-116.46285, 32.65656], [-116.47524, 32.65663], [-116.47524, 32.6589], [-116.47526, 32.66019], [-116.47958, 32.66021], [-116.47959, 32.6675], [-116.47619, 32.6675], [-116.47533, 32.66751], [-116.4753, 32.67481], [-116.47531, 32.67795], [-116.4753, 32.67798], [-116.4753, 32.67841], [-116.48596, 32.67838], [-116.48597, 32.67928], [-116.48388, 32.67929], [-116.48385, 32.67981], [-116.48385, 32.68018], [-116.48816, 32.68019]]], [[[-116.45863, 32.65304], [-116.45402, 32.65305], [-116.45408, 32.65649], [-116.44541, 32.65653], [-116.44538, 32.6603], [-116.43673, 32.66028], [-116.43699, 32.64556], [-116.43695, 32.6419], [-116.44099, 32.64182], [-116.441, 32.64545], [-116.44971, 32.64521], [-116.44968, 32.64933], [-116.45556, 32.64938], [-116.45862, 32.64937], [-116.45863, 32.65304]]]]} | Open Access 1 | 1209 | La Posta/Jewell Valley Management Area | 20797 | 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 | 8512.763 | La Posta/Jewell Valley Management Area | 0 | National Public Lands 1 | 3 | |
| 11190 | 11190 | 11189 | {"type": "MultiPolygon", "coordinates": [[[[-121.40216, 38.2541], [-121.40126, 38.25502], [-121.40116, 38.25575], [-121.40069, 38.25609], [-121.3998, 38.25771], [-121.39915, 38.25819], [-121.39865, 38.25957], [-121.39866, 38.26069], [-121.39827, 38.26167], [-121.39776, 38.2621], [-121.38884, 38.26208], [-121.38883, 38.26162], [-121.38448, 38.26161], [-121.38449, 38.25917], [-121.38527, 38.25893], [-121.38612, 38.25886], [-121.38745, 38.25829], [-121.38815, 38.25765], [-121.38989, 38.25736], [-121.39053, 38.25736], [-121.3912, 38.25765], [-121.39282, 38.25793], [-121.39308, 38.25788], [-121.39308, 38.25765], [-121.39282, 38.25733], [-121.3905, 38.25651], [-121.38971, 38.25633], [-121.3894, 38.25639], [-121.3889, 38.25681], [-121.38841, 38.25699], [-121.38765, 38.25708], [-121.38738, 38.25722], [-121.38739, 38.25646], [-121.38958, 38.25602], [-121.38959, 38.25578], [-121.38863, 38.2534], [-121.38868, 38.2534], [-121.38887, 38.25353], [-121.38971, 38.25353], [-121.39006, 38.2536], [-121.3905, 38.25363], [-121.39077, 38.25374], [-121.39143, 38.25395], [-121.39239, 38.25411], [-121.39325, 38.25386], [-121.39395, 38.25371], [-121.39523, 38.25349], [-121.39524, 38.25348], [-121.39464, 38.2514], [-121.39716, 38.25142], [-121.40076, 38.25368], [-121.40216, 38.2541]]], [[[-121.43885, 38.2758], [-121.42582, 38.27583], [-121.42579, 38.26864], [-121.42183, 38.26861], [-121.4211, 38.26875], [-121.42111, 38.26869], [-121.4208, 38.26844], [-121.42068, 38.26794], [-121.42065, 38.26748], [-121.42074, 38.26732], [-121.42117, 38.26716], [-121.42123, 38.267], [-121.41981, 38.2667], [-121.4197, 38.26661], [-121.41978, 38.26629], [-121.4199, 38.26618], [-121.42053, 38.26606], [-121.42059, 38.26595], [-121.42039, 38.26572], [-121.41993, 38.2656], [-121.41975, 38.26549], [-121.41973, 38.26515], [-121.41984, 38.26491], [-121.41981, 38.26391], [-121.42016, 38.2632], [-121.42022, 38.26286], [-121.42002, 38.2626], [-121.42004, 38.26219], [-121.42199, 38.26167], [-121.4221, 38.26176], [-121.42217, 38.26217], [-121.42237, 38.26226], [-121.42263, 38.2622], [-121.42286, 38.26178], [-121.42286, 38.26155], [-121.42228, 38.26121], [-121.42245, 38.26103], [-121.42356, 38.2608], [-121.4242, 38.26048], [-121.4244, 38.26068], [-121.42446, 38.26133], [-121.42491, 38.26134], [-121.42481, 38.26014], [-121.42471, 38.26004], [-121.42541, 38.26004], [-121.42533, 38.26134], [-121.42415, 38.26368], [-121.42502, 38.26479], [-121.42578, 38.2663], [-121.42579, 38.26863], [-121.42926, 38.26865], [-121.42942, 38.27299], [-121.43357, 38.27302], [-121.43363, 38.26943], [-121.43453, 38.26943], [-121.43437, 38.26969], [-121.43427, 38.27002], [-121.43427, 38.27018], [-121.43428, 38.27024], [-121.43435, 38.27034], [-121.4344, 38.27039], [-121.43453, 38.27047], [-121.43466, 38.27052], [-121.4349, 38.27054], [-121.43511, 38.27053], [-121.43528, 38.27049], [-121.43552, 38.27038], [-121.43581, 38.27022], [-121.43605, 38.27006], [-121.43619, 38.26994], [-121.43667, 38.26944], [-121.43707, 38.26944], [-121.4382, 38.27258], [-121.4384, 38.27321], [-121.43856, 38.27385], [-121.43865, 38.27427], [-121.43874, 38.27489], [-121.43885, 38.2758]]], [[[-121.43942, 38.28138], [-121.43684, 38.28205], [-121.43527, 38.28275], [-121.43333, 38.28271], [-121.43176, 38.28299], [-121.42897, 38.2828], [-121.41985, 38.28275], [-121.4198, 38.27601], [-121.43887, 38.27596], [-121.43905, 38.27755], [-121.43898, 38.27757], [-121.43917, 38.27919], [-121.43925, 38.27919], [-121.4394, 38.28055], [-121.43933, 38.28057], [-121.43942, 38.28138]]], [[[-121.45645, 38.2843], [-121.44742, 38.28424], [-121.4474, 38.28046], [-121.4453, 38.27972], [-121.44396, 38.28036], [-121.44049, 38.28156], [-121.44005, 38.28144], [-121.43987, 38.27976], [-121.43927, 38.27464], [-121.43916, 38.27399], [-121.43906, 38.27355], [-121.43894, 38.27309], [-121.43867, 38.27217], [-121.43862, 38.2719], [-121.43861, 38.27152], [-121.43867, 38.27108], [-121.43873, 38.27087], [-121.43883, 38.2706], [-121.44011, 38.26786], [-121.44049, 38.26766], [-121.44058, 38.26759], [-121.44081, 38.26731], [-121.44106, 38.26695], [-121.44118, 38.26672], [-121.4413, 38.26638], [-121.4416, 38.2654], [-121.44165, 38.2651], [-121.44166, 38.26494], [-121.44163, 38.26463], [-121.44155, 38.26425], [-121.44145, 38.26394], [-121.44129, 38.26355], [-121.44349, 38.26372], [-121.44468, 38.26306], [-121.44976, 38.2654], [-121.45098, 38.26503], [-121.45122, 38.26501], [-121.45539, 38.27586], [-121.45569, 38.27669], [-121.45589, 38.27735], [-121.45613, 38.27834], [-121.457, 38.28251], [-121.457, 38.2827], [-121.45699, 38.28298], [-121.45694, 38.28325], [-121.45688, 38.28347], [-121.45671, 38.28389], [-121.45659, 38.28409], [-121.45645, 38.2843]], [[-121.45258, 38.27746], [-121.45242, 38.27745], [-121.45201, 38.27789], [-121.45167, 38.27799], [-121.45129, 38.27815], [-121.45102, 38.27824], [-121.45068, 38.27824], [-121.45022, 38.2782], [-121.45007, 38.27822], [-121.45009, 38.27839], [-121.45002, 38.27852], [-121.44972, 38.27859], [-121.44958, 38.27858], [-121.44936, 38.27865], [-121.44874, 38.27878], [-121.44845, 38.27896], [-121.4483, 38.27916], [-121.44812, 38.27937], [-121.44786, 38.27945], [-121.44776, 38.27968], [-121.44763, 38.27985], [-121.44746, 38.27994], [-121.4474, 38.27996], [-121.44741, 38.28045], [-121.44747, 38.28046], [-121.44785, 38.28038], [-121.44812, 38.28022], [-121.44822, 38.28005], [-121.44839, 38.27991], [-121.44898, 38.27929], [-121.44935, 38.27898], [-121.44969, 38.27885], [-121.45014, 38.27879], [-121.4508, 38.27876], [-121.45162, 38.27865], [-121.45234, 38.27846], [-121.45327, 38.27806], [-121.45351, 38.27786], [-121.45371, 38.27763], [-121.45381, 38.27725], [-121.4539, 38.27703], [-121.45316, 38.27701], [-121.45307, 38.27714], [-121.45273, 38.27734], [-121.45258, 38.27746]]]]} | No Public Access 3 | 21461 | 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 | 1450.517 | BLM | 0 | 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 | |
| 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]);