units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, COUNTY = 4, MNG_AGENCY = 1 and YR_EST = 0
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 2
ACCESS_TYP 1
- Open Access · 4 ✖
| 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 | |
| 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 | |
| 17012 | 17012 | 17011 | {"type": "MultiPolygon", "coordinates": [[[[-116.66952, 32.58545], [-116.65644, 32.58549], [-116.65659, 32.59351], [-116.66097, 32.5936], [-116.66099, 32.59518], [-116.65976, 32.596], [-116.65962, 32.59606], [-116.65932, 32.59614], [-116.659, 32.5962], [-116.65874, 32.5962], [-116.65852, 32.59618], [-116.65794, 32.59608], [-116.65752, 32.59605], [-116.65731, 32.59606], [-116.65708, 32.59608], [-116.65665, 32.59617], [-116.65633, 32.59628], [-116.65579, 32.5965], [-116.65554, 32.59654], [-116.65527, 32.59653], [-116.65503, 32.59647], [-116.65229, 32.59549], [-116.65207, 32.59546], [-116.65179, 32.59546], [-116.65154, 32.59548], [-116.65116, 32.59558], [-116.6496, 32.5962], [-116.64944, 32.59628], [-116.64926, 32.59641], [-116.64905, 32.59666], [-116.64899, 32.59678], [-116.64893, 32.59702], [-116.64791, 32.597], [-116.64765, 32.58584], [-116.6366, 32.586], [-116.63657, 32.58513], [-116.63891, 32.58512], [-116.63889, 32.58424], [-116.63884, 32.58331], [-116.63649, 32.58333], [-116.63647, 32.58252], [-116.63882, 32.58251], [-116.63885, 32.57888], [-116.65193, 32.5786], [-116.65193, 32.57798], [-116.65189, 32.57602], [-116.65622, 32.57558], [-116.65629, 32.57851], [-116.66497, 32.57824], [-116.66509, 32.58175], [-116.66941, 32.58167], [-116.66952, 32.58545]]], [[[-116.6533, 32.5971], [-116.65119, 32.59706], [-116.65063, 32.59705], [-116.65175, 32.59664], [-116.65189, 32.59662], [-116.65199, 32.59664], [-116.6533, 32.5971]]], [[[-116.65667, 32.59717], [-116.65666, 32.59717], [-116.6561, 32.59716], [-116.65666, 32.59698], [-116.65667, 32.59717]]], [[[-116.66099, 32.59726], [-116.66062, 32.59725], [-116.65974, 32.59724], [-116.66042, 32.59697], [-116.66097, 32.59664], [-116.66099, 32.59726]]], [[[-116.69094, 32.5893], [-116.68244, 32.58943], [-116.68242, 32.58634], [-116.68241, 32.58132], [-116.68236, 32.57768], [-116.67392, 32.57797], [-116.67387, 32.57265], [-116.69077, 32.57124], [-116.69082, 32.58084], [-116.69094, 32.5893]]], [[[-116.70334, 32.59791], [-116.69922, 32.59788], [-116.69922, 32.6015], [-116.69093, 32.60139], [-116.69102, 32.59781], [-116.69512, 32.59784], [-116.69508, 32.59357], [-116.69923, 32.59356], [-116.69922, 32.58934], [-116.70332, 32.58937], [-116.70334, 32.59791]]], [[[-116.92353, 32.60446], [-116.92352, 32.60821], [-116.91928, 32.60821], [-116.91928, 32.60447], [-116.91927, 32.60446], [-116.89341, 32.60454], [-116.89345, 32.60825], [-116.88905, 32.60819], [-116.88903, 32.60446], [-116.88467, 32.60441], [-116.88463, 32.60063], [-116.88031, 32.60065], [-116.88021, 32.60807], [-116.88465, 32.60815], [-116.88462, 32.61186], [-116.88014, 32.61181], [-116.88012, 32.62274], [-116.87571, 32.62268], [-116.87572, 32.62635], [-116.87565, 32.63036], [-116.87073, 32.63034], [-116.8707, 32.63761], [-116.8663, 32.63756], [-116.86631, 32.63397], [-116.85686, 32.6339], [-116.84002, 32.63453], [-116.84011, 32.64195], [-116.83128, 32.64233], [-116.83109, 32.63121], [-116.8269, 32.63126], [-116.8268, 32.62758], [-116.8224, 32.62777], [-116.82127, 32.62783], [-116.82124, 32.62216], [-116.81805, 32.62245], [-116.81804, 32.62054], [-116.80539, 32.62125], [-116.79698, 32.62129], [-116.79693, 32.62499], [-116.7885, 32.62501], [-116.78411, 32.62491], [-116.78408, 32.62873], [-116.77983, 32.62853], [-116.7797, 32.63196], [-116.78828, 32.63215], [-116.80511, 32.63227], [-116.80468, 32.64311], [-116.81289, 32.6536], [-116.81324, 32.65404], [-116.81333, 32.65404], [-116.81331, 32.65413], [-116.81759, 32.65945], [-116.83284, 32.65961], [-116.83514, 32.65762], [-116.8352, 32.66305], [-116.82206, 32.66298], [-116.82204, 32.6671], [-116.82195, 32.66699], [-116.82184, 32.66682], [-116.82169, 32.66621], [-116.82162, 32.66621], [-116.82142, 32.66542], [-116.82134, 32.66523], [-116.82128, 32.66513], [-116.82116, 32.66497], [-116.82093, 32.66475], [-116.82034, 32.66432], [-116.82015, 32.66426], [-116.82018, 32.66419], [-116.82014, 32.66416], [-116.8197, 32.66402], [-116.81945, 32.66396], [-116.81903, 32.66392], [-116.81871, 32.66392], [-116.81835, 32.66395], [-116.81802, 32.66402], [-116.81665, 32.66416], [-116.8147, 32.6638], [-116.81353, 32.66304], [-116.81349, 32.66308], [-116.81299, 32.66274], [-116.81283, 32.66259], [-116.81198, 32.6612], [-116.81165, 32.66077], [-116.81131, 32.66042], [-116.80906, 32.65835], [-116.80887, 32.65814], [-116.80867, 32.65783], [-116.80746, 32.6553], [-116.80737, 32.65515], [-116.8073, 32.65504], [-116.80714, 32.65487], [-116.80688, 32.65466], [-116.80668, 32.65455], [-116.80645, 32.65446], [-116.80409, 32.65372], [-116.80368, 32.65363], [-116.80332, 32.65358], [-116.80301, 32.65352], [-116.801, 32.65292], [-116.80067, 32.65286], [-116.8003, 32.65285], [-116.80014, 32.65286], [-116.79985, 32.65293], [-116.79958, 32.65303], [-116.79887, 32.65339], [-116.79871, 32.6535], [-116.79802, 32.65409], [-116.79784, 32.6542], [-116.79764, 32.65429], [-116.79732, 32.65436], [-116.79621, 32.65445], [-116.79602, 32.65445], [-116.7948, 32.65428], [-116.79453, 32.65427], [-116.79449, 32.65412], [-116.79417, 32.65404], [-116.7939, 32.65403], [-116.79283, 32.65379], [-116.79267, 32.65372], [-116.79255, 32.65363], [-116.79244, 32.65353], [-116.79235, 32.65341], [-116.79233, 32.65335], [-116.79219, 32.65325], [-116.79204, 32.65328], [-116.79194, 32.65292], [-116.7919, 32.65287], [-116.79178, 32.65274], [-116.7916, 32.65265], [-116.79117, 32.65251], [-116.79093, 32.65247], [-116.79069, 32.65249], [-116.79051, 32.65254], [-116.79006, 32.65274], [-116.78987, 32.65278], [-116.78972, 32.65279], [-116.78965, 32.65288], [-116.78957, 32.65291], [-116.78945, 32.65291], [-116.78941, 32.65289], [-116.78933, 32.6528], [-116.78912, 32.65273], [-116.78903, 32.65266], [-116.78887, 32.65226], [-116.78885, 32.65212], [-116.78887, 32.65181], [-116.78886, 32.65164], [-116.78865, 32.65075], [-116.78856, 32.6506], [-116.78839, 32.65045], [-116.78821, 32.65038], [-116.78747, 32.65031], [-116.7873, 32.65026], [-116.78715, 32.65018], [-116.787, 32.65004], [-116.78651, 32.6492], [-116.7865, 32.64914], [-116.78655, 32.64872], [-116.78653, 32.64858], [-116.78648, 32.64846], [-116.78623, 32.64814], [-116.78618, 32.64804], [-116.78615, 32.64793], [-116.78614, 32.6467], [-116.7861, 32.64652], [-116.78601, 32.64637], [-116.78592, 32.64627], [-116.78582, 32.6462], [-116.78557, 32.64607], [-116.78533, 32.646], [-116.78514, 32.64597], [-116.78457, 32.64596], [-116.78441, 32.64594], [-116.78412, 32.64588], [-116.78382, 32.64575], [-116.78375, 32.6392], [-116.77518, 32.63919], [-116.77519, 32.63866], [-116.77518, 32.63865], [-116.76751, 32.63863], [-116.7673, 32.6385], [-116.76705, 32.63826], [-116.76623, 32.63782], [-116.7661, 32.63774], [-116.76592, 32.63759], [-116.76573, 32.63736], [-116.76529, 32.63658], [-116.76522, 32.63642], [-116.76511, 32.63606], [-116.76508, 32.63582], [-116.76508, 32.6355], [-116.77113, 32.6355], [-116.77119, 32.63178], [-116.76852, 32.63181], [-116.76851, 32.62902], [-116.7679, 32.62896], [-116.76886, 32.62859], [-116.76916, 32.62817], [-116.7696, 32.62758], [-116.77073, 32.62554], [-116.77121, 32.6245], [-116.77117, 32.62368], [-116.77114, 32.6207], [-116.77108, 32.61813], [-116.77104, 32.61797], [-116.771, 32.61696], [-116.77526, 32.6171], [-116.77528, 32.6134], [-116.77974, 32.61354], [-116.77974, 32.61082], [-116.78416, 32.61093], [-116.78415, 32.61368], [-116.78862, 32.61382], [-116.78869, 32.59913], [-116.77784, 32.59902], [-116.77453, 32.59558], [-116.77103, 32.59288], [-116.76957, 32.59388], [-116.77283, 32.59643], [-116.77527, 32.599], [-116.77069, 32.59896], [-116.76627, 32.59901], [-116.7663, 32.5999], [-116.76641, 32.60612], [-116.75414, 32.60618], [-116.7452, 32.6064], [-116.74503, 32.59923], [-116.74289, 32.59925], [-116.74288, 32.59926], [-116.7429, 32.6], [-116.74309, 32.60645], [-116.74105, 32.60651], [-116.74092, 32.6029], [-116.73263, 32.603], [-116.73261, 32.60297], [-116.72833, 32.60298], [-116.72821, 32.5994], [-116.72845, 32.59121], [-116.74514, 32.59151], [-116.74509, 32.59534], [-116.75351, 32.59539], [-116.75366, 32.59538], [-116.75374, 32.58427], [-116.76212, 32.58426], [-116.76217, 32.58046], [-116.77099, 32.58015], [-116.78401, 32.57978], [-116.78396, 32.56787], [-116.78817, 32.56748], [-116.79696, 32.56738], [-116.79686, 32.56361], [-116.80118, 32.56352], [-116.80114, 32.56182], [-116.82267, 32.56], [-116.82268, 32.56003], [-116.84085, 32.55849], [-116.84086, 32.55846], [-116.87505, 32.55557], [-116.87525, 32.56395], [-116.8841, 32.564], [-116.88412, 32.56637], [-116.88413, 32.57126], [-116.8929, 32.57127], [-116.89287, 32.57483], [-116.90172, 32.57481], [-116.9016, 32.58217], [-116.89281, 32.58218], [-116.89306, 32.58965], [-116.90622, 32.5896], [-116.90627, 32.59144], [-116.91066, 32.59141], [-116.9108, 32.59701], [-116.91929, 32.59695], [-116.91927, 32.59916], [-116.91928, 32.60446], [-116.92353, 32.60446]], [[-116.78863, 32.61382], [-116.78858, 32.61755], [-116.79276, 32.61755], [-116.79282, 32.61385], [-116.78863, 32.61382]], [[-116.86647, 32.62263], [-116.86654, 32.61903], [-116.86228, 32.61896], [-116.86235, 32.61529], [-116.85767, 32.61522], [-116.85766, 32.61523], [-116.85341, 32.61531], [-116.85328, 32.61895], [-116.85751, 32.61887], [-116.85736, 32.62253], [-116.86647, 32.62263]]], [[[-116.74547, 32.62115], [-116.74547, 32.62115], [-116.74495, 32.62098], [-116.74547, 32.62097], [-116.74547, 32.62115]]], [[[-116.77107, 32.62441], [-116.77107, 32.62448], [-116.77062, 32.6255], [-116.76948, 32.62752], [-116.76877, 32.62851], [-116.76764, 32.62894], [-116.76762, 32.62896], [-116.76737, 32.62893], [-116.76691, 32.62931], [-116.76692, 32.62916], [-116.76716, 32.62894], [-116.76692, 32.62889], [-116.76693, 32.62815], [-116.76761, 32.62815], [-116.76782, 32.62772], [-116.76781, 32.62771], [-116.76691, 32.62772], [-116.76682, 32.62455], [-116.76866, 32.62452], [-116.76866, 32.62443], [-116.77107, 32.62441]]]]} | Open Access 1 | 5515 | Otay National Co-op Land & Wildlife Management Area | 23244 | 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 | 25221.302 | Otay Nat. Co-op Land & WMA | 0 | Conservation Area 13 | 2 |
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]);