units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
51 rows where DES_TP = 399 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, YR_EST
UNIT_NAME 16 ✖
- Unnamed site - Riverside Land Conservancy 25
- Unnamed site - Save the Redwoods League 6
- Unnamed site - Del Monte Forest Foundation 4
- Unnamed site - Center for Natural Lands Management 2
- Unnamed site - Mojave Desert Land Trust 2
- Unnamed site - Nonprofit Organization - Unknown 2
- Unnamed site - Anza-Borrego Foundation 1
- Unnamed site - Community Environmental Council 1
- Unnamed site - Friends of Palm Springs Mountains 1
- Unnamed site - Friends of the Desert Mountains 1
- Unnamed site - Jacoby Creek Land Trust 1
- Unnamed site - National Audubon Society 1
- Unnamed site - Sequoia Riverlands Trust 1
- Unnamed site - The Habitat Trust 1
- Unnamed site - The Wildlands Conservancy 1
- Unnamed site - Wilderness Land Trust 1
MNG_AGENCY 16
- Rivers and Lands Conservancy 25
- Save the Redwoods League 6
- Del Monte Forest Foundation 4
- Center for Natural Lands Management 2
- Mojave Desert Land Trust 2
- Nonprofit Organization - Unknown 2
- Sequoia Riverlands Trust 1
- The Wildlands Conservancy 1
- Friends of the Desert Mountains 1
- The Habitat Trust 1
- Community Environmental Council 1
- Wilderness Land Trust 1
- National Audubon Society 1
- Friends of Palm Springs Mountains 1
- Anza-Borrego Foundation 1
- Jacoby Creek Land Trust 1
ACCESS_TYP 4
MNG_AG_TYP 3
DES_TP 1
- Private Other or Unknown · 51 ✖
AGNCY_LEV 1 ✖
- Non Profit 51
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15531 | 15531 | 15530 | {"type": "MultiPolygon", "coordinates": [[[[-114.68869, 34.96203], [-114.68869, 34.96294], [-114.68648, 34.96293], [-114.68648, 34.96203], [-114.68869, 34.96203]]], [[[-114.69837, 34.57743], [-114.6896, 34.57743], [-114.68921, 34.57359], [-114.69799, 34.57359], [-114.69837, 34.57743]]], [[[-114.69675, 34.58319], [-114.69018, 34.58318], [-114.68979, 34.57934], [-114.69637, 34.57935], [-114.69675, 34.58319]]], [[[-114.74114, 34.56431], [-114.73232, 34.56424], [-114.73171, 34.55673], [-114.74049, 34.55676], [-114.74114, 34.56431]]], [[[-114.77923, 34.5208], [-114.77051, 34.5208], [-114.77051, 34.51356], [-114.77923, 34.51356], [-114.77923, 34.5208]]], [[[-114.78334, 34.59172], [-114.78115, 34.59174], [-114.78105, 34.59079], [-114.77886, 34.59081], [-114.77847, 34.58702], [-114.78067, 34.587], [-114.78105, 34.59079], [-114.78324, 34.59077], [-114.78334, 34.59172]]], [[[-114.78621, 34.59832], [-114.78402, 34.59834], [-114.78383, 34.59645], [-114.78602, 34.59643], [-114.78621, 34.59832]]], [[[-114.78801, 34.59451], [-114.78692, 34.59453], [-114.78682, 34.59358], [-114.78792, 34.59357], [-114.78801, 34.59451]]], [[[-114.78853, 34.58883], [-114.78744, 34.58884], [-114.78724, 34.58694], [-114.78834, 34.58693], [-114.78853, 34.58883]]], [[[-114.7885, 34.59925], [-114.7874, 34.59926], [-114.78731, 34.59831], [-114.7884, 34.5983], [-114.7885, 34.59925]]], [[[-114.79169, 34.59827], [-114.7895, 34.59829], [-114.7894, 34.59734], [-114.79049, 34.59733], [-114.7904, 34.59639], [-114.79149, 34.59638], [-114.79169, 34.59827]]], [[[-114.79449, 34.59351], [-114.7934, 34.59352], [-114.79349, 34.59446], [-114.79239, 34.59447], [-114.7923, 34.59353], [-114.79339, 34.59351], [-114.7933, 34.59257], [-114.7944, 34.59256], [-114.79449, 34.59351]]], [[[-114.79531, 34.59066], [-114.79421, 34.59067], [-114.79411, 34.58973], [-114.79521, 34.58972], [-114.79531, 34.59066]]], [[[-114.81627, 34.90399], [-114.81407, 34.90399], [-114.81406, 34.90218], [-114.81627, 34.90218], [-114.81627, 34.90399]]], [[[-114.98641, 34.43251], [-114.98422, 34.43251], [-114.9842, 34.42889], [-114.98639, 34.42888], [-114.98641, 34.43251]]], [[[-115.09561, 34.87178], [-115.09557, 34.8754], [-115.0912, 34.87537], [-115.09124, 34.87175], [-115.09561, 34.87178]]], [[[-115.10877, 34.86826], [-115.10872, 34.87187], [-115.09998, 34.87181], [-115.09998, 34.87091], [-115.09125, 34.87085], [-115.09127, 34.86813], [-115.10877, 34.86826]]], [[[-115.11865, 34.58626], [-115.10989, 34.58627], [-115.10988, 34.57902], [-115.11865, 34.579], [-115.11865, 34.58626]]], [[[-115.12744, 34.60213], [-115.12471, 34.60491], [-115.12449, 34.60478], [-115.1233, 34.60415], [-115.12656, 34.60073], [-115.12743, 34.60073], [-115.12744, 34.60213]]], [[[-115.20069, 34.51592], [-115.19197, 34.51592], [-115.19193, 34.50142], [-115.20066, 34.50142], [-115.20069, 34.51592]]], [[[-115.20132, 34.62619], [-115.20131, 34.62982], [-115.20021, 34.62982], [-115.20022, 34.62619], [-115.20132, 34.62619]]], [[[-115.22687, 34.50145], [-115.20939, 34.50143], [-115.2094, 34.48693], [-115.21813, 34.48694], [-115.21814, 34.49419], [-115.22249, 34.49418], [-115.2225, 34.48694], [-115.22685, 34.48695], [-115.22687, 34.50145]]], [[[-115.31086, 34.70265], [-115.30644, 34.70261], [-115.30098, 34.70269], [-115.30082, 34.69885], [-115.30644, 34.69564], [-115.30645, 34.69897], [-115.31086, 34.69901], [-115.31086, 34.70265]]], [[[-115.30588, 34.69533], [-115.30084, 34.69812], [-115.30084, 34.69812], [-115.30118, 34.6953], [-115.30588, 34.69533]]], [[[-115.35645, 34.39138], [-115.35207, 34.39144], [-115.35207, 34.3878], [-115.35644, 34.38773], [-115.35645, 34.39138]]], [[[-115.55452, 34.59906], [-115.55451, 34.60236], [-115.55426, 34.604], [-115.54927, 34.604], [-115.54952, 34.60235], [-115.54454, 34.60236], [-115.54454, 34.59906], [-115.55452, 34.59906]]], [[[-115.54984, 34.56414], [-115.54763, 34.56412], [-115.54761, 34.5632], [-115.54981, 34.56322], [-115.54984, 34.56414]]], [[[-115.58015, 34.21289], [-115.57139, 34.21284], [-115.57139, 34.20922], [-115.58014, 34.20927], [-115.58015, 34.21289]]], [[[-115.58015, 34.22012], [-115.57576, 34.2201], [-115.57576, 34.21648], [-115.58015, 34.2165], [-115.58015, 34.22012]]], [[[-116.09724, 34.74069], [-116.09614, 34.74067], [-116.09613, 34.73886], [-116.09723, 34.73887], [-116.09724, 34.74069]]], [[[-116.12985, 35.00253], [-116.12969, 35.00617], [-116.11212, 35.00673], [-116.11234, 35.00329], [-116.12985, 35.00253]]], [[[-116.13809, 35.03906], [-116.13809, 35.04271], [-116.12921, 35.0426], [-116.12923, 35.03895], [-116.13809, 35.03906]]], [[[-116.14696, 35.03917], [-116.14112, 35.0391], [-116.14113, 35.03182], [-116.14695, 35.03189], [-116.14696, 35.03917]]], [[[-116.15734, 34.64686], [-116.15689, 34.6541], [-116.14881, 34.65411], [-116.14942, 34.64688], [-116.15238, 34.64687], [-116.1519, 34.6477], [-116.15619, 34.64948], [-116.15708, 34.64802], [-116.15432, 34.64687], [-116.15734, 34.64686]]], [[[-116.18242, 35.04608], [-116.17799, 35.0462], [-116.17797, 35.03592], [-116.17738, 35.0359], [-116.18118, 35.03231], [-116.18241, 35.03232], [-116.18242, 35.04608]]], [[[-116.1803, 35.0323], [-116.1803, 35.0323], [-116.17797, 35.03451], [-116.17796, 35.03228], [-116.1803, 35.0323]]], [[[-116.18242, 35.04685], [-116.17799, 35.04681], [-116.17799, 35.04675], [-116.18242, 35.04663], [-116.18242, 35.04685]]], [[[-116.20251, 34.82641], [-116.20247, 34.82821], [-116.20136, 34.8282], [-116.20139, 34.8264], [-116.20251, 34.82641]]], [[[-116.21805, 35.04509], [-116.2136, 35.04521], [-116.21356, 35.04029], [-116.21801, 35.04038], [-116.21805, 35.04509]]], [[[-116.21808, 35.04764], [-116.21362, 35.04755], [-116.21361, 35.04576], [-116.21806, 35.04563], [-116.21808, 35.04764]]], [[[-116.24474, 35.0408], [-116.24029, 35.04073], [-116.24034, 35.04449], [-116.23588, 35.04458], [-116.23573, 35.0334], [-116.24462, 35.03352], [-116.24474, 35.0408]]], [[[-116.24039, 35.04801], [-116.23592, 35.04793], [-116.23589, 35.04513], [-116.24035, 35.04504], [-116.24039, 35.04801]]], [[[-116.35568, 34.78247], [-116.35238, 34.78251], [-116.35238, 34.7819], [-116.35568, 34.78187], [-116.35568, 34.78247]]], [[[-116.49842, 34.09795], [-116.49757, 34.09837], [-116.49271, 34.09176], [-116.4927, 34.09028], [-116.49834, 34.09028], [-116.49842, 34.09795]]]]} | No Public Access 3 | 49067 | Unnamed site - Mojave Desert Land Trust | 33770 | 3124 | Mojave Desert Land Trust 669 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.mojavedesertlandtrust.org/ | Non Governmental Organization 10 | 3124 | Mojave Desert Land Trust 657 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.mdlt.org/ | San Bernardino 22 | 3237.077 | 0 | Private Other or Unknown 399 | 4 | |
15529 | 15529 | 15528 | {"type": "MultiPolygon", "coordinates": [[[[-116.37339, 33.20669], [-116.37126, 33.20669], [-116.3712, 33.20314], [-116.369, 33.20315], [-116.36895, 33.19964], [-116.37329, 33.19965], [-116.37339, 33.20669]]], [[[-116.36684, 33.20585], [-116.36473, 33.20589], [-116.36486, 33.21146], [-116.36444, 33.2114], [-116.364, 33.21137], [-116.36273, 33.21136], [-116.36269, 33.21043], [-116.36051, 33.21041], [-116.36039, 33.20494], [-116.3647, 33.20498], [-116.36682, 33.20495], [-116.36684, 33.20585]]]]} | Restricted Access 2 | 49075 | Unnamed site - Anza-Borrego Foundation | 33775 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | https://theabf.org/ | San Diego 4 | 128.692 | 2019 | Private Other or Unknown 399 | 4 | |
15527 | 15527 | 15526 | {"type": "MultiPolygon", "coordinates": [[[[-119.61418, 35.01952], [-119.61408, 35.02358], [-119.61081, 35.0236], [-119.61082, 35.02714], [-119.60676, 35.02715], [-119.60679, 35.01594], [-119.61076, 35.01594], [-119.61078, 35.01952], [-119.61418, 35.01952]]], [[[-119.59622, 35.03402], [-119.58291, 35.03401], [-119.58292, 35.02938], [-119.58202, 35.02937], [-119.58202, 35.03031], [-119.57855, 35.03029], [-119.57855, 35.02661], [-119.57871, 35.01939], [-119.58747, 35.01945], [-119.58746, 35.03015], [-119.59621, 35.03015], [-119.59622, 35.03402]]], [[[-119.6161, 35.03944], [-119.6138, 35.03944], [-119.61381, 35.03767], [-119.61606, 35.0377], [-119.6161, 35.03944]]], [[[-119.65933, 35.0526], [-119.65498, 35.05258], [-119.65497, 35.04877], [-119.65933, 35.0488], [-119.65933, 35.0526]]], [[[-119.54298, 35.0484], [-119.54297, 35.05512], [-119.53455, 35.05508], [-119.53456, 35.04839], [-119.54298, 35.0484]]], [[[-119.67241, 35.04885], [-119.67241, 35.05626], [-119.668, 35.05625], [-119.668, 35.04883], [-119.67241, 35.04885]]], [[[-119.65499, 35.06265], [-119.65056, 35.06268], [-119.65056, 35.05721], [-119.65498, 35.0572], [-119.65499, 35.06265]]], [[[-119.61562, 35.07044], [-119.61371, 35.07042], [-119.61372, 35.06928], [-119.61537, 35.0703], [-119.61562, 35.07044]]], [[[-119.62277, 35.06694], [-119.62277, 35.07049], [-119.61597, 35.07045], [-119.61373, 35.06908], [-119.61375, 35.06688], [-119.62277, 35.06694]]], [[[-119.66386, 35.07437], [-119.65938, 35.07435], [-119.65937, 35.07068], [-119.66385, 35.07071], [-119.66386, 35.07437]]], [[[-119.65055, 35.07064], [-119.65054, 35.07801], [-119.63159, 35.07808], [-119.63162, 35.07054], [-119.65055, 35.07064]]], [[[-119.70254, 35.17498], [-119.70247, 35.18236], [-119.69363, 35.18233], [-119.6937, 35.17492], [-119.70254, 35.17498]]], [[[-119.71549, 35.15299], [-119.71517, 35.18598], [-119.71296, 35.18599], [-119.71328, 35.15301], [-119.71549, 35.15299]]], [[[-119.80914, 35.21218], [-119.79117, 35.21217], [-119.79123, 35.20472], [-119.79938, 35.20456], [-119.80907, 35.20453], [-119.80914, 35.21218]]], [[[-119.93407, 35.27851], [-119.93405, 35.2821], [-119.92948, 35.28209], [-119.92955, 35.27848], [-119.93407, 35.27851]]], [[[-119.88065, 35.2857], [-119.87618, 35.28571], [-119.87619, 35.27826], [-119.88063, 35.27825], [-119.88065, 35.2857]]], [[[-119.89832, 35.30027], [-119.8805, 35.30024], [-119.88048, 35.29994], [-119.88049, 35.29948], [-119.88046, 35.29481], [-119.88052, 35.29387], [-119.88052, 35.29277], [-119.89829, 35.29287], [-119.89832, 35.30027]]], [[[-119.90275, 35.30571], [-119.89831, 35.30574], [-119.89832, 35.30212], [-119.90273, 35.30208], [-119.90275, 35.30571]]], [[[-119.98726, 35.30787], [-119.98677, 35.31869], [-119.98248, 35.31867], [-119.98256, 35.30773], [-119.98569, 35.30776], [-119.98611, 35.30812], [-119.9869, 35.30748], [-119.98726, 35.30787]]], [[[-120.02291, 35.3223], [-120.00554, 35.32245], [-120.00532, 35.30776], [-120.02289, 35.3077], [-120.02291, 35.3223]]], [[[-119.96473, 35.32586], [-119.96472, 35.32949], [-119.96029, 35.32947], [-119.96032, 35.32582], [-119.96473, 35.32586]]], [[[-120.00405, 35.32975], [-120.00468, 35.33424], [-120.00493, 35.33592], [-120.00511, 35.33693], [-120.00513, 35.33749], [-120.00511, 35.34444], [-120.00516, 35.34697], [-120.00514, 35.35124], [-120.00504, 35.35138], [-120.00211, 35.35135], [-119.99779, 35.35134], [-119.99777, 35.35009], [-119.9962, 35.35008], [-119.99616, 35.34417], [-119.9874, 35.34411], [-119.98732, 35.33683], [-119.98673, 35.33683], [-119.98673, 35.33672], [-119.98679, 35.33669], [-119.98681, 35.33665], [-119.98686, 35.32225], [-119.98967, 35.32224], [-119.99417, 35.3223], [-120.00276, 35.32223], [-120.00312, 35.32431], [-120.00186, 35.32442], [-120.00185, 35.32444], [-120.00209, 35.32578], [-120.00334, 35.3256], [-120.00405, 35.32975]]], [[[-120.02293, 35.33708], [-120.02287, 35.34435], [-120.01414, 35.34429], [-120.01402, 35.35143], [-120.00541, 35.35138], [-120.00529, 35.35125], [-120.00525, 35.34697], [-120.00531, 35.34444], [-120.00532, 35.34331], [-120.00533, 35.33749], [-120.00531, 35.33693], [-120.01458, 35.33701], [-120.01725, 35.33701], [-120.02293, 35.33708]]], [[[-119.95138, 35.35507], [-119.94698, 35.35498], [-119.93368, 35.35493], [-119.93368, 35.3513], [-119.95136, 35.35136], [-119.95138, 35.35507]]], [[[-119.93368, 35.35854], [-119.93369, 35.36591], [-119.93359, 35.3697], [-119.92971, 35.36969], [-119.9298, 35.3585], [-119.93368, 35.35854]]]]} | No Public Access 3 | 48608 | Unnamed site - Sequoia Riverlands Trust | 33321 | 3076 | Sequoia Riverlands Trust 109 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sequoiariverlands.org | Non Governmental Organization 10 | 3076 | Sequoia Riverlands Trust 106 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 5142.858 | 0 | Private Other or Unknown 399 | 4 | ||
15484 | 15484 | 15483 | {"type": "Polygon", "coordinates": [[[-121.96137, 36.58829], [-121.96126, 36.5894], [-121.96019, 36.58938], [-121.9593, 36.58896], [-121.95808, 36.58933], [-121.95723, 36.58925], [-121.95638, 36.58921], [-121.95543, 36.58899], [-121.95365, 36.58957], [-121.95329, 36.58964], [-121.953, 36.58949], [-121.95272, 36.58928], [-121.95237, 36.58925], [-121.9525, 36.58896], [-121.95323, 36.58923], [-121.95342, 36.58928], [-121.95368, 36.58932], [-121.95394, 36.58932], [-121.9542, 36.58931], [-121.95445, 36.58926], [-121.95475, 36.58916], [-121.95495, 36.58906], [-121.95511, 36.58897], [-121.95577, 36.58843], [-121.95587, 36.58828], [-121.95593, 36.58806], [-121.956, 36.58793], [-121.9561, 36.58779], [-121.95621, 36.58768], [-121.95638, 36.58758], [-121.95672, 36.58744], [-121.95702, 36.58735], [-121.95723, 36.58732], [-121.95762, 36.5873], [-121.95783, 36.58732], [-121.95808, 36.58736], [-121.96137, 36.58829]]]} | Open Access 1 | 43084 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 22.917 | 0 | Private Other or Unknown 399 | 4 | ||
15456 | 15456 | 15455 | {"type": "Polygon", "coordinates": [[[-121.93147, 36.56365], [-121.93048, 36.56454], [-121.93017, 36.56492], [-121.92926, 36.56425], [-121.93065, 36.56304], [-121.93147, 36.56365]]]} | Open Access 1 | 35193 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 4.643 | 0 | Private Other or Unknown 399 | 4 | ||
15455 | 15455 | 15454 | {"type": "Polygon", "coordinates": [[[-121.92654, 36.55993], [-121.92639, 36.56001], [-121.92627, 36.56009], [-121.92593, 36.5604], [-121.92586, 36.56052], [-121.92584, 36.56072], [-121.9258, 36.56082], [-121.92535, 36.56122], [-121.92524, 36.56139], [-121.92521, 36.56155], [-121.92522, 36.56169], [-121.92527, 36.56181], [-121.92548, 36.56213], [-121.9255, 36.56223], [-121.9255, 36.5623], [-121.92531, 36.56285], [-121.9253, 36.56346], [-121.92527, 36.56357], [-121.92521, 36.56369], [-121.92503, 36.56395], [-121.92494, 36.56423], [-121.92488, 36.56435], [-121.92364, 36.56601], [-121.92339, 36.5663], [-121.92263, 36.56706], [-121.92253, 36.56721], [-121.92229, 36.56781], [-121.9215, 36.56899], [-121.92037, 36.57038], [-121.91973, 36.57135], [-121.9174, 36.57047], [-121.91788, 36.57038], [-121.91798, 36.57033], [-121.91806, 36.57027], [-121.91812, 36.57016], [-121.91814, 36.57004], [-121.91814, 36.56987], [-121.9181, 36.56969], [-121.91852, 36.56965], [-121.91856, 36.5695], [-121.91863, 36.5694], [-121.91908, 36.56966], [-121.91949, 36.5694], [-121.91981, 36.56917], [-121.92027, 36.56865], [-121.92032, 36.56821], [-121.91981, 36.56826], [-121.91938, 36.56839], [-121.91933, 36.56832], [-121.91974, 36.56816], [-121.9197, 36.56792], [-121.92011, 36.56765], [-121.92071, 36.56744], [-121.92063, 36.56718], [-121.92068, 36.56711], [-121.9207, 36.56705], [-121.92069, 36.56697], [-121.92066, 36.56691], [-121.92055, 36.56682], [-121.92021, 36.56676], [-121.92018, 36.56674], [-121.92018, 36.56671], [-121.92025, 36.56654], [-121.9203, 36.56634], [-121.92033, 36.5663], [-121.92052, 36.56619], [-121.92061, 36.56608], [-121.92064, 36.56598], [-121.92065, 36.56577], [-121.92069, 36.56566], [-121.92074, 36.5656], [-121.92079, 36.56558], [-121.92083, 36.56559], [-121.92123, 36.56582], [-121.92138, 36.56588], [-121.92156, 36.5659], [-121.92174, 36.56589], [-121.92193, 36.56583], [-121.9225, 36.56551], [-121.92266, 36.5653], [-121.92316, 36.56553], [-121.92356, 36.56515], [-121.92407, 36.56498], [-121.92359, 36.56459], [-121.92364, 36.56458], [-121.92411, 36.56494], [-121.9244, 36.5646], [-121.92459, 36.56419], [-121.92475, 36.56316], [-121.92474, 36.56315], [-121.92413, 36.5632], [-121.92413, 36.56317], [-121.92476, 36.56311], [-121.92476, 36.56234], [-121.92442, 36.56176], [-121.92466, 36.56167], [-121.92466, 36.56142], [-121.92486, 36.56142], [-121.92486, 36.56128], [-121.92498, 36.56112], [-121.92508, 36.56103], [-121.92507, 36.56041], [-121.92531, 36.56034], [-121.92639, 36.55982], [-121.92654, 36.55993]]]} | Open Access 1 | 35191 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 38.319 | 0 | Private Other or Unknown 399 | 4 | ||
15454 | 15454 | 15453 | {"type": "Polygon", "coordinates": [[[-116.36903, 33.83109], [-116.36896, 33.83837], [-116.36677, 33.83836], [-116.36686, 33.83109], [-116.36903, 33.83109]]]} | Unknown Access 4 | 3769 | Unnamed site - Center for Natural Lands Management | 28629 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.197 | 0 | Private Other or Unknown 399 | 4 | ||
14118 | 14118 | 14117 | {"type": "MultiPolygon", "coordinates": [[[[-124.03502, 40.80993], [-124.03498, 40.81172], [-124.03246, 40.81177], [-124.03248, 40.81705], [-124.02927, 40.8171], [-124.02926, 40.81711], [-124.02992, 40.8179], [-124.03317, 40.82081], [-124.03489, 40.822], [-124.03491, 40.82314], [-124.0345, 40.82247], [-124.03312, 40.82178], [-124.03296, 40.82168], [-124.02823, 40.82176], [-124.02824, 40.82087], [-124.02836, 40.81711], [-124.02895, 40.8171], [-124.02881, 40.81654], [-124.02839, 40.81594], [-124.02798, 40.81568], [-124.02707, 40.8152], [-124.02645, 40.81468], [-124.02631, 40.81455], [-124.0261, 40.8141], [-124.0262, 40.81377], [-124.02613, 40.81335], [-124.02589, 40.81297], [-124.02556, 40.81266], [-124.02527, 40.81232], [-124.02447, 40.81117], [-124.02409, 40.81086], [-124.02396, 40.81062], [-124.0239, 40.81002], [-124.02352, 40.80855], [-124.02346, 40.80814], [-124.02564, 40.80819], [-124.02561, 40.81005], [-124.03502, 40.80993]]], [[[-124.04434, 40.82678], [-124.04426, 40.82918], [-124.04221, 40.82917], [-124.04219, 40.82908], [-124.04223, 40.82879], [-124.04169, 40.82846], [-124.04067, 40.82843], [-124.0405, 40.82846], [-124.04036, 40.82856], [-124.03973, 40.82756], [-124.03983, 40.82704], [-124.03977, 40.8268], [-124.04013, 40.82673], [-124.04434, 40.82678]]], [[[-124.05768, 40.8335], [-124.05768, 40.83357], [-124.05758, 40.83375], [-124.05737, 40.83393], [-124.05725, 40.8342], [-124.05728, 40.83437], [-124.05736, 40.83451], [-124.0574, 40.83454], [-124.05702, 40.83465], [-124.05688, 40.83687], [-124.05618, 40.83864], [-124.05609, 40.83871], [-124.05475, 40.83809], [-124.05509, 40.83359], [-124.05526, 40.83358], [-124.05592, 40.83345], [-124.05625, 40.83344], [-124.05636, 40.8335], [-124.0566, 40.83349], [-124.05699, 40.83336], [-124.05719, 40.83333], [-124.0574, 40.83333], [-124.05753, 40.83335], [-124.05766, 40.83344], [-124.05768, 40.8335]]], [[[-124.07009, 40.83765], [-124.0679, 40.83919], [-124.06747, 40.83885], [-124.06692, 40.83922], [-124.06663, 40.83902], [-124.06593, 40.83952], [-124.06344, 40.83745], [-124.06343, 40.83657], [-124.05867, 40.83659], [-124.05867, 40.8347], [-124.06281, 40.83472], [-124.06288, 40.83478], [-124.06298, 40.83472], [-124.06301, 40.83472], [-124.06303, 40.83523], [-124.06343, 40.83522], [-124.06343, 40.83497], [-124.06488, 40.83499], [-124.06557, 40.83532], [-124.06597, 40.83578], [-124.06597, 40.83587], [-124.06601, 40.83598], [-124.06608, 40.83605], [-124.06619, 40.83612], [-124.06629, 40.83616], [-124.0664, 40.83618], [-124.06718, 40.83656], [-124.06763, 40.83681], [-124.06893, 40.83725], [-124.06923, 40.83733], [-124.06978, 40.83708], [-124.07009, 40.83765]]]]} | Unknown Access 4 | 46794 | Unnamed site - Jacoby Creek Land Trust | 30249 | 6085 | Jacoby Creek Land Trust 1072 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jclandtrust.org/ | Non Governmental Organization 10 | 6085 | Jacoby Creek Land Trust 1028 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 262.805 | 0 | Private Other or Unknown 399 | 4 | ||
12217 | 12217 | 12216 | {"type": "Polygon", "coordinates": [[[-115.28714, 35.38373], [-115.28272, 35.3837], [-115.28272, 35.38188], [-115.28714, 35.38193], [-115.28714, 35.38373]]]} | No Public Access 3 | 35701 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 19.95 | 0 | Private Other or Unknown 399 | 4 | ||
5692 | 5692 | 5691 | {"type": "MultiPolygon", "coordinates": [[[[-122.5494, 38.53711], [-122.54933, 38.53827], [-122.54861, 38.53827], [-122.54859, 38.53851], [-122.54148, 38.53854], [-122.54152, 38.53795], [-122.5415, 38.53598], [-122.54414, 38.53611], [-122.54439, 38.53632], [-122.5455, 38.53638], [-122.54663, 38.53714], [-122.5494, 38.53711]]], [[[-122.5552, 38.53847], [-122.55433, 38.53848], [-122.55446, 38.53722], [-122.55391, 38.5372], [-122.55388, 38.53772], [-122.5521, 38.5377], [-122.55166, 38.53732], [-122.55183, 38.53662], [-122.55238, 38.53655], [-122.55327, 38.5359], [-122.5533, 38.53502], [-122.55517, 38.53502], [-122.5552, 38.53847]]]]} | Unknown Access 4 | 48630 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Napa 11 | 54.128 | 0 | Private Other or Unknown 399 | 4 | |
5691 | 5691 | 5690 | {"type": "Polygon", "coordinates": [[[-122.21155, 37.27037], [-122.21143, 37.27072], [-122.21079, 37.27112], [-122.21082, 37.27244], [-122.20618, 37.27239], [-122.20221, 37.27237], [-122.20204, 37.27208], [-122.20204, 37.27183], [-122.19978, 37.27115], [-122.19977, 37.27116], [-122.19974, 37.27236], [-122.19714, 37.27235], [-122.19736, 37.2656], [-122.19736, 37.26339], [-122.19843, 37.26406], [-122.1996, 37.26318], [-122.19988, 37.26323], [-122.20027, 37.2634], [-122.20036, 37.26404], [-122.20052, 37.26424], [-122.20052, 37.26558], [-122.20336, 37.26556], [-122.20337, 37.26593], [-122.20335, 37.266], [-122.20293, 37.26597], [-122.20265, 37.26609], [-122.20254, 37.26627], [-122.20254, 37.26674], [-122.20277, 37.26701], [-122.20283, 37.26721], [-122.20311, 37.26748], [-122.20353, 37.26795], [-122.20362, 37.26846], [-122.20321, 37.26895], [-122.20312, 37.26973], [-122.20306, 37.26996], [-122.20294, 37.27009], [-122.20269, 37.27021], [-122.20268, 37.27039], [-122.20314, 37.27053], [-122.20359, 37.27038], [-122.20381, 37.27013], [-122.20373, 37.26987], [-122.20385, 37.26986], [-122.20406, 37.26993], [-122.20409, 37.27008], [-122.20398, 37.27025], [-122.20399, 37.27045], [-122.20403, 37.27046], [-122.20435, 37.26999], [-122.20439, 37.26963], [-122.20453, 37.26933], [-122.20493, 37.26902], [-122.20462, 37.26868], [-122.20503, 37.26852], [-122.20551, 37.26869], [-122.20565, 37.26819], [-122.20618, 37.26795], [-122.20641, 37.26766], [-122.20651, 37.2675], [-122.20681, 37.26714], [-122.20745, 37.26724], [-122.20766, 37.267], [-122.20743, 37.2665], [-122.20741, 37.26624], [-122.20755, 37.26597], [-122.20754, 37.26592], [-122.20771, 37.26591], [-122.20771, 37.2658], [-122.20781, 37.2658], [-122.20799, 37.26599], [-122.2082, 37.26605], [-122.2084, 37.26603], [-122.20896, 37.26581], [-122.20925, 37.26555], [-122.2093, 37.26559], [-122.209, 37.26586], [-122.20842, 37.26609], [-122.20852, 37.26662], [-122.20882, 37.26768], [-122.20894, 37.26769], [-122.2089, 37.26823], [-122.20972, 37.26827], [-122.2097, 37.26883], [-122.21007, 37.26885], [-122.21001, 37.26984], [-122.20988, 37.26996], [-122.20941, 37.27007], [-122.20888, 37.27049], [-122.20885, 37.27054], [-122.20886, 37.2706], [-122.20891, 37.27065], [-122.20965, 37.27097], [-122.20986, 37.27105], [-122.21022, 37.2711], [-122.211, 37.27058], [-122.21115, 37.27058], [-122.21131, 37.27025], [-122.21155, 37.27037]]]} | Unknown Access 4 | 48625 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | San Mateo 15 | 179.263 | 0 | Private Other or Unknown 399 | 4 | |
5687 | 5687 | 5686 | {"type": "MultiPolygon", "coordinates": [[[[-124.06439, 41.78643], [-124.0617, 41.78643], [-124.06168, 41.78487], [-124.06429, 41.78484], [-124.06439, 41.78643]]], [[[-124.13806, 41.79306], [-124.13754, 41.79306], [-124.13754, 41.79243], [-124.13784, 41.79246], [-124.13791, 41.79248], [-124.13798, 41.79253], [-124.13801, 41.79259], [-124.13801, 41.79266], [-124.13793, 41.79282], [-124.13793, 41.7929], [-124.13796, 41.79298], [-124.13806, 41.79306]]]]} | Unknown Access 4 | 48623 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Del Norte 50 | 10.154 | 0 | Private Other or Unknown 399 | 4 | |
5650 | 5650 | 5649 | {"type": "Polygon", "coordinates": [[[-121.91973, 36.57135], [-121.91927, 36.57204], [-121.91913, 36.57218], [-121.91899, 36.57228], [-121.9188, 36.57237], [-121.91865, 36.57242], [-121.91734, 36.57272], [-121.91712, 36.57281], [-121.91691, 36.57295], [-121.91673, 36.57312], [-121.91662, 36.57329], [-121.91656, 36.57344], [-121.91651, 36.57366], [-121.91641, 36.57382], [-121.91592, 36.57423], [-121.91582, 36.57434], [-121.91426, 36.57282], [-121.91371, 36.572], [-121.91315, 36.57044], [-121.91344, 36.5697], [-121.91321, 36.569], [-121.91335, 36.56903], [-121.91351, 36.56904], [-121.91351, 36.56926], [-121.9144, 36.57029], [-121.91474, 36.57044], [-121.91522, 36.57083], [-121.91546, 36.57079], [-121.91582, 36.57063], [-121.91625, 36.57039], [-121.91654, 36.57045], [-121.91675, 36.57035], [-121.91716, 36.57037], [-121.91973, 36.57135]]]} | Open Access 1 | 35182 | Unnamed site - Del Monte Forest Foundation | 28634 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 37.011 | 0 | Private Other or Unknown 399 | 4 | ||
4831 | 4831 | 4830 | {"type": "MultiPolygon", "coordinates": [[[[-116.06156, 33.79473], [-116.05721, 33.79473], [-116.05721, 33.79292], [-116.06156, 33.79291], [-116.06156, 33.79473]]], [[[-116.07024, 33.79109], [-116.0659, 33.7911], [-116.0659, 33.78747], [-116.07024, 33.78747], [-116.07024, 33.79109]]]]} | No Public Access 3 | 49076 | Unnamed site - Mojave Desert Land Trust | 33770 | 3124 | Mojave Desert Land Trust 669 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.mojavedesertlandtrust.org/ | Non Governmental Organization 10 | 3124 | Mojave Desert Land Trust 657 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.mdlt.org/ | Riverside 10 | 59.967 | 0 | Private Other or Unknown 399 | 4 | |
4810 | 4810 | 4809 | {"type": "Polygon", "coordinates": [[[-120.26268, 38.26203], [-120.26258, 38.26565], [-120.24415, 38.26629], [-120.2352, 38.26616], [-120.23518, 38.25849], [-120.23727, 38.25839], [-120.24324, 38.25829], [-120.2438, 38.2583], [-120.24408, 38.26232], [-120.26268, 38.26203]]]} | Unknown Access 4 | 48626 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Tuolumne 21 | 335.393 | 0 | Private Other or Unknown 399 | 4 | |
4809 | 4809 | 4808 | {"type": "MultiPolygon", "coordinates": [[[[-123.77085, 40.18643], [-123.77076, 40.18671], [-123.76986, 40.18652], [-123.77005, 40.18631], [-123.77085, 40.18643]]], [[[-123.99131, 40.44672], [-123.99065, 40.44671], [-123.99064, 40.44675], [-123.9901, 40.44673], [-123.9901, 40.44654], [-123.99131, 40.44654], [-123.99131, 40.44672]]], [[[-124.08532, 41.27009], [-124.08526, 41.27384], [-124.08271, 41.27382], [-124.08208, 41.27252], [-124.0817, 41.27221], [-124.08163, 41.27204], [-124.08201, 41.27202], [-124.08195, 41.27003], [-124.08318, 41.27001], [-124.08532, 41.27009]]], [[[-124.15032, 40.69913], [-124.14997, 40.69952], [-124.14997, 40.70003], [-124.14924, 40.69999], [-124.14952, 40.69933], [-124.14954, 40.69895], [-124.14945, 40.6986], [-124.14928, 40.69831], [-124.14911, 40.69816], [-124.14881, 40.69805], [-124.14854, 40.69803], [-124.14835, 40.69813], [-124.14831, 40.69825], [-124.14838, 40.69837], [-124.14872, 40.69865], [-124.14878, 40.6988], [-124.14872, 40.69891], [-124.14794, 40.6995], [-124.14724, 40.6999], [-124.14689, 40.69987], [-124.14654, 40.69979], [-124.14621, 40.69967], [-124.14599, 40.69956], [-124.14546, 40.69987], [-124.14507, 40.6996], [-124.14487, 40.69937], [-124.14463, 40.69916], [-124.14441, 40.69888], [-124.144, 40.69806], [-124.14386, 40.69787], [-124.14326, 40.69743], [-124.14259, 40.69713], [-124.14213, 40.69682], [-124.14194, 40.69666], [-124.14184, 40.69655], [-124.14164, 40.69593], [-124.14149, 40.69555], [-124.14148, 40.69537], [-124.14151, 40.69528], [-124.14171, 40.69508], [-124.14203, 40.69494], [-124.14223, 40.69481], [-124.14229, 40.6947], [-124.14225, 40.69455], [-124.14214, 40.69442], [-124.14207, 40.69439], [-124.14264, 40.69415], [-124.14295, 40.69454], [-124.14296, 40.69454], [-124.14329, 40.69379], [-124.14376, 40.6938], [-124.14398, 40.6937], [-124.14425, 40.69348], [-124.14427, 40.69345], [-124.14588, 40.69346], [-124.14592, 40.69353], [-124.14604, 40.69421], [-124.14639, 40.69519], [-124.14669, 40.69543], [-124.14707, 40.69543], [-124.14771, 40.69497], [-124.14832, 40.69488], [-124.14849, 40.69515], [-124.14897, 40.69675], [-124.14938, 40.69708], [-124.14997, 40.69735], [-124.14997, 40.69815], [-124.15032, 40.69913]]]]} | Unknown Access 4 | 48621 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Humboldt 45 | 106.296 | 0 | Private Other or Unknown 399 | 4 | |
4806 | 4806 | 4805 | {"type": "MultiPolygon", "coordinates": [[[[-116.57588, 33.86683], [-116.57583, 33.86863], [-116.57481, 33.86799], [-116.57389, 33.86748], [-116.57281, 33.86696], [-116.56836, 33.86466], [-116.5693, 33.86342], [-116.57588, 33.86683]]], [[[-116.58857, 33.87432], [-116.58641, 33.8765], [-116.5835, 33.8743], [-116.57999, 33.8743], [-116.58009, 33.87175], [-116.57794, 33.87017], [-116.57805, 33.867], [-116.58853, 33.86709], [-116.5885, 33.86893], [-116.58848, 33.87431], [-116.58857, 33.87432]], [[-116.58424, 33.87431], [-116.58425, 33.8743], [-116.5842, 33.87071], [-116.58126, 33.87068], [-116.58129, 33.86975], [-116.58018, 33.86974], [-116.58011, 33.87138], [-116.58399, 33.8743], [-116.58424, 33.87431]]], [[[-116.59703, 33.84893], [-116.59628, 33.84774], [-116.59315, 33.84624], [-116.59266, 33.84624], [-116.59266, 33.84775], [-116.59182, 33.85041], [-116.59013, 33.8521], [-116.58881, 33.8521], [-116.58694, 33.85056], [-116.58252, 33.85498], [-116.58043, 33.85497], [-116.58041, 33.85259], [-116.5842, 33.84764], [-116.58807, 33.84439], [-116.58805, 33.84438], [-116.58749, 33.84448], [-116.58576, 33.84492], [-116.58525, 33.84492], [-116.58542, 33.84468], [-116.58523, 33.84457], [-116.59005, 33.8418], [-116.59181, 33.84035], [-116.59466, 33.83871], [-116.59548, 33.83871], [-116.597, 33.84], [-116.59703, 33.84893]]]]} | Open Access 1 | 48582 | Unnamed site - Friends of Palm Springs Mountains | 33292 | 3378 | Friends of Palm Springs Mountains 787 | Non Profit 6 | Non Profit - Conservation 12 | http://friendsofpalmspringsmountains.org/ | Non Governmental Organization 10 | 3378 | Friends of Palm Springs Mountains 766 | Non Profit 6 | Non Profit - Conservation 12 | http://friendsofpalmspringsmountains.org | Riverside 10 | 501.078 | 0 | Private Other or Unknown 399 | 4 | |
4685 | 4685 | 4684 | {"type": "Polygon", "coordinates": [[[-119.72173, 34.41045], [-119.72161, 34.41166], [-119.72134, 34.41164], [-119.72147, 34.41038], [-119.72173, 34.41045]]]} | Open Access 1 | 43089 | Unnamed site - Community Environmental Council | 28696 | 3015 | Community Environmental Council 508 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | Santa Barbara 7 | 0.838 | 0 | Private Other or Unknown 399 | 4 | ||
4677 | 4677 | 4676 | {"type": "Polygon", "coordinates": [[[-115.25785, 33.94904], [-115.25784, 33.9527], [-115.25345, 33.95266], [-115.25346, 33.94901], [-115.25785, 33.94904]]]} | No Public Access 3 | 36662 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.688 | 0 | Private Other or Unknown 399 | 4 | ||
4674 | 4674 | 4673 | {"type": "Polygon", "coordinates": [[[-115.23841, 35.10623], [-115.2384, 35.11349], [-115.23579, 35.11348], [-115.2358, 35.10623], [-115.23841, 35.10623]]]} | No Public Access 3 | 36647 | Unnamed site - Riverside Land Conservancy | 28658 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 47.37 | 0 | Private Other or Unknown 399 | 4 |
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]);