units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where AGNCY_NAME = 1 and DES_TP = 13
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 |
| 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 | |
| 17015 | 17015 | 17014 | {"type": "MultiPolygon", "coordinates": [[[[-116.48381, 32.96218], [-116.46708, 32.96157], [-116.45862, 32.96147], [-116.45983, 32.97277], [-116.4557, 32.97273], [-116.4561, 32.97629], [-116.44754, 32.97614], [-116.44738, 32.98004], [-116.4387, 32.97977], [-116.43911, 32.97615], [-116.42886, 32.97602], [-116.42886, 32.97595], [-116.41453, 32.97592], [-116.41186, 32.97465], [-116.41187, 32.97222], [-116.42271, 32.97232], [-116.42189, 32.96497], [-116.41691, 32.9649], [-116.41671, 32.96121], [-116.39822, 32.96131], [-116.38099, 32.96109], [-116.38143, 32.94679], [-116.36206, 32.94652], [-116.36205, 32.94653], [-116.36298, 32.95401], [-116.36393, 32.96156], [-116.35884, 32.96111], [-116.35886, 32.96935], [-116.34707, 32.9697], [-116.34728, 32.97328], [-116.34552, 32.97326], [-116.3431, 32.97327], [-116.3422, 32.97269], [-116.34153, 32.96955], [-116.33717, 32.96942], [-116.33502, 32.95939], [-116.32758, 32.96131], [-116.32757, 32.94544], [-116.32877, 32.9297], [-116.32681, 32.91591], [-116.30079, 32.9181], [-116.29276, 32.91723], [-116.27701, 32.91733], [-116.26046, 32.91766], [-116.24985, 32.91791], [-116.24846, 32.91396], [-116.2496, 32.91395], [-116.2503, 32.9159], [-116.25132, 32.91591], [-116.25133, 32.9159], [-116.25003, 32.91204], [-116.24896, 32.9088], [-116.24874, 32.90811], [-116.25098, 32.90812], [-116.25034, 32.90614], [-116.25142, 32.90613], [-116.25082, 32.90417], [-116.25192, 32.90417], [-116.25164, 32.90321], [-116.25392, 32.9032], [-116.25361, 32.90223], [-116.25386, 32.90135], [-116.25576, 32.90135], [-116.2564, 32.89865], [-116.25624, 32.89865], [-116.25241, 32.89876], [-116.25186, 32.90049], [-116.25072, 32.90048], [-116.2502, 32.90222], [-116.24565, 32.90219], [-116.24631, 32.90054], [-116.24631, 32.90053], [-116.24431, 32.90053], [-116.24332, 32.90055], [-116.24432, 32.89903], [-116.24326, 32.89904], [-116.24258, 32.89906], [-116.2432, 32.89834], [-116.24319, 32.89832], [-116.24145, 32.8984], [-116.24364, 32.89624], [-116.24307, 32.88895], [-116.25937, 32.88771], [-116.26766, 32.88771], [-116.26769, 32.88035], [-116.27647, 32.88034], [-116.27662, 32.87291], [-116.28467, 32.87296], [-116.2849, 32.86581], [-116.29333, 32.86583], [-116.29345, 32.85844], [-116.3098, 32.85835], [-116.30973, 32.87302], [-116.31816, 32.87309], [-116.31817, 32.867], [-116.31815, 32.8585], [-116.32221, 32.85857], [-116.32221, 32.85492], [-116.32649, 32.855], [-116.32647, 32.85145], [-116.32647, 32.85134], [-116.32648, 32.85133], [-116.33485, 32.85122], [-116.33475, 32.84395], [-116.33475, 32.83514], [-116.33478, 32.82959], [-116.32643, 32.82955], [-116.32638, 32.82191], [-116.32638, 32.82083], [-116.32624, 32.81499], [-116.32632, 32.81498], [-116.32632, 32.81133], [-116.33045, 32.81132], [-116.33045, 32.80785], [-116.33048, 32.80459], [-116.33048, 32.80011], [-116.33465, 32.80012], [-116.33477, 32.79654], [-116.3305, 32.79647], [-116.32634, 32.79643], [-116.31786, 32.79652], [-116.31781, 32.80012], [-116.30945, 32.80013], [-116.30906, 32.78484], [-116.309, 32.78189], [-116.29596, 32.78184], [-116.29604, 32.78534], [-116.29173, 32.7853], [-116.29173, 32.79643], [-116.29602, 32.79642], [-116.29602, 32.80007], [-116.30504, 32.80012], [-116.30509, 32.8068], [-116.30512, 32.80759], [-116.30959, 32.80762], [-116.30952, 32.80388], [-116.3142, 32.80388], [-116.31787, 32.80387], [-116.31792, 32.80767], [-116.31804, 32.81498], [-116.31805, 32.81501], [-116.31119, 32.81504], [-116.31117, 32.81503], [-116.30975, 32.81504], [-116.30984, 32.82205], [-116.30995, 32.82949], [-116.29178, 32.82945], [-116.27388, 32.82934], [-116.26512, 32.82922], [-116.25591, 32.8292], [-116.23785, 32.82939], [-116.21986, 32.82994], [-116.21963, 32.81437], [-116.21996, 32.80879], [-116.22002, 32.80739], [-116.22047, 32.79961], [-116.22098, 32.78493], [-116.22101, 32.78367], [-116.22143, 32.77193], [-116.22218, 32.75548], [-116.22271, 32.74096], [-116.2228, 32.72635], [-116.22279, 32.72634], [-116.20879, 32.72661], [-116.20818, 32.71903], [-116.20772, 32.71218], [-116.20914, 32.69754], [-116.20816, 32.68279], [-116.20837, 32.66849], [-116.22577, 32.66803], [-116.22572, 32.6643], [-116.23619, 32.66435], [-116.2427, 32.6644], [-116.24274, 32.66648], [-116.24269, 32.66816], [-116.23847, 32.66812], [-116.23842, 32.67171], [-116.2297, 32.67166], [-116.22961, 32.67522], [-116.23837, 32.6753], [-116.23834, 32.67891], [-116.24236, 32.67887], [-116.24223, 32.68251], [-116.2428, 32.68893], [-116.24759, 32.68892], [-116.24761, 32.68987], [-116.25117, 32.68988], [-116.25564, 32.68994], [-116.2557, 32.69353], [-116.2596, 32.69355], [-116.25959, 32.69716], [-116.25975, 32.69717], [-116.25973, 32.70118], [-116.25972, 32.7117], [-116.26004, 32.72231], [-116.26404, 32.72234], [-116.26372, 32.712], [-116.2638, 32.70148], [-116.26787, 32.7015], [-116.26779, 32.71231], [-116.27583, 32.7129], [-116.2845, 32.71346], [-116.28447, 32.70619], [-116.28892, 32.70644], [-116.28902, 32.72087], [-116.29304, 32.72127], [-116.29372, 32.72392], [-116.28948, 32.72369], [-116.29001, 32.72632], [-116.28772, 32.72628], [-116.28753, 32.74113], [-116.28323, 32.74111], [-116.28319, 32.74482], [-116.28746, 32.74486], [-116.28748, 32.74858], [-116.29181, 32.74862], [-116.29176, 32.7524], [-116.28735, 32.75239], [-116.28726, 32.75969], [-116.28294, 32.75966], [-116.28289, 32.76331], [-116.28719, 32.76337], [-116.28715, 32.76705], [-116.29146, 32.76707], [-116.29577, 32.76712], [-116.29602, 32.75234], [-116.30028, 32.75239], [-116.30037, 32.74871], [-116.30468, 32.74874], [-116.3046, 32.75237], [-116.309, 32.75241], [-116.30886, 32.75608], [-116.30888, 32.7598], [-116.30448, 32.7598], [-116.30445, 32.76346], [-116.30889, 32.76351], [-116.30888, 32.76388], [-116.30882, 32.77045], [-116.31762, 32.77043], [-116.31764, 32.77081], [-116.32646, 32.77077], [-116.34367, 32.77083], [-116.34519, 32.77085], [-116.36094, 32.77096], [-116.36111, 32.78557], [-116.37719, 32.78545], [-116.37713, 32.80027], [-116.37719, 32.80388], [-116.37731, 32.80389], [-116.37731, 32.80393], [-116.3774, 32.81499], [-116.35951, 32.81488], [-116.35965, 32.82361], [-116.35966, 32.82567], [-116.35973, 32.8296], [-116.35965, 32.84386], [-116.35996, 32.85259], [-116.36009, 32.85588], [-116.36018, 32.85848], [-116.3638, 32.85848], [-116.37737, 32.85851], [-116.37761, 32.86577], [-116.38628, 32.86576], [-116.40816, 32.86569], [-116.40837, 32.88016], [-116.40847, 32.88017], [-116.40849, 32.8804], [-116.41275, 32.88044], [-116.41288, 32.88743], [-116.41289, 32.89068], [-116.41305, 32.90203], [-116.41254, 32.91668], [-116.43015, 32.91675], [-116.43099, 32.90197], [-116.448, 32.90176], [-116.44737, 32.91795], [-116.44708, 32.92354], [-116.44681, 32.93173], [-116.44683, 32.93183], [-116.46435, 32.93191], [-116.46564, 32.94673], [-116.48246, 32.94679], [-116.48381, 32.96218]], [[-116.26998, 32.75208], [-116.27009, 32.74863], [-116.27023, 32.74098], [-116.26592, 32.74092], [-116.26637, 32.72597], [-116.26013, 32.72587], [-116.24232, 32.72634], [-116.24226, 32.72267], [-116.23362, 32.7227], [-116.23364, 32.72636], [-116.23996, 32.7264], [-116.23994, 32.72997], [-116.24932, 32.72986], [-116.25764, 32.72966], [-116.26192, 32.7297], [-116.2615, 32.74087], [-116.26143, 32.74462], [-116.26577, 32.74471], [-116.26563, 32.75202], [-116.26998, 32.75208]], [[-116.25858, 32.78321], [-116.25857, 32.7832], [-116.25759, 32.78319], [-116.25636, 32.7832], [-116.25631, 32.78499], [-116.25842, 32.785], [-116.25849, 32.78499], [-116.25858, 32.78321]], [[-116.25862, 32.78138], [-116.25869, 32.77955], [-116.25647, 32.77955], [-116.25641, 32.78137], [-116.25862, 32.78138]], [[-116.27229, 32.89313], [-116.27759, 32.89311], [-116.27813, 32.88959], [-116.26988, 32.88961], [-116.26982, 32.88997], [-116.26938, 32.89313], [-116.25782, 32.89313], [-116.25679, 32.89314], [-116.25689, 32.8951], [-116.25699, 32.89623], [-116.25786, 32.89625], [-116.26532, 32.89625], [-116.27181, 32.89624], [-116.27229, 32.89313]], [[-116.27173, 32.77782], [-116.26871, 32.77778], [-116.2609, 32.77773], [-116.26084, 32.77892], [-116.26068, 32.78319], [-116.26152, 32.7832], [-116.26285, 32.78319], [-116.26297, 32.77954], [-116.27165, 32.77957], [-116.27173, 32.77782]], [[-116.26758, 32.77231], [-116.26763, 32.77053], [-116.26547, 32.77051], [-116.26539, 32.77232], [-116.26756, 32.77235], [-116.26758, 32.77231]], [[-116.2693, 32.78496], [-116.26931, 32.78498], [-116.27147, 32.78495], [-116.2715, 32.78442], [-116.27153, 32.78319], [-116.26936, 32.78319], [-116.2693, 32.78496]], [[-116.27407, 32.77243], [-116.27413, 32.7706], [-116.26981, 32.77055], [-116.26968, 32.77416], [-116.27184, 32.77419], [-116.27191, 32.7724], [-116.27407, 32.77243]], [[-116.27173, 32.7778], [-116.27174, 32.77781], [-116.27389, 32.77782], [-116.27396, 32.77636], [-116.27396, 32.77602], [-116.27179, 32.776], [-116.27173, 32.7778]], [[-116.30961, 32.80762], [-116.3096, 32.80763], [-116.30961, 32.80847], [-116.30968, 32.81136], [-116.31385, 32.81136], [-116.31377, 32.80764], [-116.30961, 32.80762]], [[-116.34805, 32.77823], [-116.35256, 32.77828], [-116.35249, 32.7746], [-116.34372, 32.77443], [-116.34386, 32.78559], [-116.34829, 32.78571], [-116.34805, 32.77823]], [[-116.44707, 32.93406], [-116.4468, 32.93174], [-116.43823, 32.93171], [-116.43839, 32.92768], [-116.43852, 32.92422], [-116.43429, 32.92421], [-116.43418, 32.928], [-116.42981, 32.92795], [-116.43004, 32.92049], [-116.42563, 32.92047], [-116.42549, 32.92796], [-116.42112, 32.92792], [-116.42108, 32.93167], [-116.4297, 32.93169], [-116.42999, 32.939], [-116.43878, 32.93907], [-116.43852, 32.93531], [-116.44721, 32.93536], [-116.44707, 32.93406]]], [[[-116.26229, 32.6829], [-116.25995, 32.68265], [-116.25998, 32.68037], [-116.2618, 32.68229], [-116.26204, 32.68256], [-116.26229, 32.6829]]], [[[-116.27244, 32.68032], [-116.27221, 32.68399], [-116.26253, 32.68292], [-116.26228, 32.68258], [-116.26199, 32.68222], [-116.25997, 32.6801], [-116.26, 32.67533], [-116.26843, 32.6761], [-116.26827, 32.67985], [-116.27244, 32.68032]]], [[[-116.28465, 32.69528], [-116.28446, 32.69894], [-116.28446, 32.70247], [-116.27996, 32.70243], [-116.28006, 32.69879], [-116.2803, 32.69523], [-116.28465, 32.69528]]], [[[-116.30488, 32.79272], [-116.29605, 32.7927], [-116.29605, 32.78908], [-116.30038, 32.78907], [-116.3004, 32.7854], [-116.30475, 32.78546], [-116.30488, 32.79272]]], [[[-116.32631, 32.80758], [-116.32208, 32.80759], [-116.32206, 32.80386], [-116.32631, 32.80387], [-116.32631, 32.80758]]]]} | Open Access 1 | 12485 | McCain Valley National Cooperative Land and Wildlife Management Area | 32363 | 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 | 75811.419 | McCain Valley Nat. Cooperative Land and WMA | 1961 | 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]);