units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
629 rows where DES_TP = 16 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Nature Conservancy 48
- Sonoma Land Trust 24
- The Wildlands Conservancy 23
- Peninsula Open Space Trust 23
- Truckee Donner Land Trust 22
- Center for Natural Lands Management 21
- Big Sur Land Trust 21
- The Environmental Trust 21
- Land Trust of Napa County 18
- Sempervirens Fund 18
- American River Conservancy 18
- Save Mount Diablo 17
- National Audubon Society 16
- Endangered Habitats Conservancy 14
- Land Trust of Santa Cruz County 14
- Fallbrook Land Conservancy 13
- Wilderness Land Trust 13
- Save the Redwoods League 10
- Bear Yuba Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- Mojave Desert Land Trust 8
- Coastside Land Trust 8
- Ojai Valley Land Conservancy 8
- Solano Land Trust 7
- San Diego River Park Foundation 7
- John Muir Land Trust 6
- Sequoia Riverlands Trust 6
- Friends of the Desert Mountains 6
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- No Public Access 210
- Open Access 206
- Restricted Access 152
- Unknown Access 41
MNG_AG_LEV 2 ✖
- Non Profit 593
- Private 16
DES_TP 1
- Private Conservation · 609 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15947 | 15947 | 15946 | {"type": "Polygon", "coordinates": [[[-122.49954, 37.89424], [-122.49884, 37.89498], [-122.49752, 37.89514], [-122.49729, 37.89525], [-122.49639, 37.89483], [-122.49647, 37.89479], [-122.49673, 37.89397], [-122.49747, 37.89359], [-122.49821, 37.89349], [-122.49911, 37.89369], [-122.49954, 37.89424]]]} | No Public Access 3 | 5202 | Audubon Society Lyford House Open Space Area | 15705 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 9.091 | Audubon Society Lyford House OS Area | 0 | Private Conservation 16 | 2 | |
15786 | 15786 | 15785 | {"type": "Polygon", "coordinates": [[[-116.37096, 33.93276], [-116.37035, 33.93275], [-116.35362, 33.92614], [-116.35356, 33.91828], [-116.34448, 33.91828], [-116.33625, 33.91831], [-116.33345, 33.91828], [-116.32746, 33.91604], [-116.32749, 33.91102], [-116.32661, 33.91101], [-116.32938, 33.90564], [-116.33015, 33.90377], [-116.33626, 33.90377], [-116.33628, 33.91108], [-116.35359, 33.91104], [-116.35357, 33.91828], [-116.37095, 33.91825], [-116.37096, 33.93276]]]} | Open Access 1 | 3716 | Joshua Tree National Park Linkage | 3979 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 1102.783 | Joshua Tree NP Linkage | 0 | Private Conservation 16 | 2 | |
15642 | 15642 | 15641 | {"type": "Polygon", "coordinates": [[[-122.7593, 38.69993], [-122.75919, 38.70741], [-122.75872, 38.7141], [-122.7511, 38.71424], [-122.7511, 38.72102], [-122.74372, 38.72095], [-122.73443, 38.72113], [-122.73435, 38.72474], [-122.72489, 38.72494], [-122.72492, 38.72128], [-122.72038, 38.72127], [-122.72039, 38.71391], [-122.72507, 38.71387], [-122.72506, 38.71074], [-122.72548, 38.7106], [-122.72596, 38.71055], [-122.72626, 38.71048], [-122.72695, 38.71021], [-122.72733, 38.71014], [-122.72789, 38.70998], [-122.7289, 38.70972], [-122.72889, 38.70667], [-122.73433, 38.70664], [-122.73433, 38.69959], [-122.74354, 38.69953], [-122.7593, 38.69993]]]} | No Public Access 3 | 38036 | Modini Ingalls Ecological Preserve | 22341 | 3005 | Audubon Canyon Ranch 837 | Non Profit 6 | Non Profit - Conservation 12 | http://www.egret.org | Non Governmental Organization 10 | 3005 | Audubon Canyon Ranch 814 | Non Profit 6 | Non Profit - Conservation 12 | Sonoma 16 | 1585.152 | Modini Ingalls EP | 0 | Private Conservation 16 | 2 | |
15641 | 15641 | 15640 | {"type": "Polygon", "coordinates": [[[-122.9909, 38.45117], [-122.99089, 38.45304], [-122.9819, 38.45306], [-122.98189, 38.45486], [-122.97297, 38.45495], [-122.97294, 38.45853], [-122.95472, 38.45866], [-122.95449, 38.45151], [-122.96373, 38.45139], [-122.96376, 38.45585], [-122.96898, 38.4551], [-122.97121, 38.4514], [-122.97193, 38.45139], [-122.972, 38.45122], [-122.97256, 38.45114], [-122.97315, 38.45133], [-122.97373, 38.45061], [-122.97378, 38.45005], [-122.97438, 38.44935], [-122.97382, 38.44864], [-122.97289, 38.4453], [-122.97252, 38.44412], [-122.97114, 38.43987], [-122.97136, 38.43953], [-122.97142, 38.43948], [-122.97176, 38.43934], [-122.97187, 38.43927], [-122.97198, 38.43918], [-122.9721, 38.43904], [-122.97216, 38.43899], [-122.97266, 38.43888], [-122.9728, 38.43886], [-122.97308, 38.4388], [-122.9732, 38.43874], [-122.97423, 38.43809], [-122.97446, 38.43846], [-122.97407, 38.43836], [-122.97391, 38.43853], [-122.97358, 38.43857], [-122.97339, 38.43874], [-122.9731, 38.43891], [-122.97545, 38.44272], [-122.97561, 38.44268], [-122.97572, 38.44292], [-122.9759, 38.44312], [-122.97601, 38.44321], [-122.97613, 38.44329], [-122.97696, 38.44369], [-122.97706, 38.44361], [-122.9784, 38.44416], [-122.97943, 38.4446], [-122.97956, 38.44468], [-122.97979, 38.44487], [-122.97991, 38.44503], [-122.98, 38.44521], [-122.98014, 38.44558], [-122.9802, 38.44568], [-122.98029, 38.44578], [-122.98039, 38.44587], [-122.98058, 38.44598], [-122.98091, 38.44608], [-122.98094, 38.44877], [-122.9819, 38.44878], [-122.9819, 38.45122], [-122.9909, 38.45117]]]} | Restricted Access 2 | 35146 | Bohemia Ecological Preserve | 16232 | 3117 | LandPaths 206 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landpaths.org/ | Non Governmental Organization 10 | 3117 | LandPaths 202 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 540.325 | Bohemia EP | 0 | Private Conservation 16 | 2 | |
15609 | 15609 | 15608 | {"type": "MultiPolygon", "coordinates": [[[[-121.78359, 36.79222], [-121.78326, 36.79622], [-121.78302, 36.79601], [-121.78108, 36.79508], [-121.78006, 36.79377], [-121.77871, 36.79362], [-121.77778, 36.79379], [-121.77715, 36.79465], [-121.77611, 36.79759], [-121.77347, 36.79741], [-121.77074, 36.80089], [-121.76969, 36.80064], [-121.77114, 36.79879], [-121.77119, 36.79813], [-121.77089, 36.79822], [-121.76871, 36.79647], [-121.76651, 36.79642], [-121.7655, 36.79692], [-121.76423, 36.79698], [-121.76325, 36.79659], [-121.76193, 36.79479], [-121.76068, 36.79423], [-121.75845, 36.79408], [-121.75783, 36.79366], [-121.75654, 36.79066], [-121.75543, 36.78962], [-121.75569, 36.78941], [-121.75549, 36.78854], [-121.75483, 36.78811], [-121.75412, 36.78662], [-121.75444, 36.78549], [-121.7563, 36.7845], [-121.75889, 36.78556], [-121.75972, 36.78735], [-121.76063, 36.78784], [-121.76121, 36.78822], [-121.76217, 36.79089], [-121.76383, 36.79066], [-121.76419, 36.79147], [-121.76793, 36.79058], [-121.768, 36.79365], [-121.76889, 36.79331], [-121.76932, 36.79271], [-121.76897, 36.79215], [-121.76881, 36.79208], [-121.76851, 36.79139], [-121.76888, 36.79055], [-121.7696, 36.79054], [-121.77227, 36.78915], [-121.77315, 36.78923], [-121.77315, 36.78957], [-121.77332, 36.78975], [-121.77452, 36.78987], [-121.77511, 36.7897], [-121.77536, 36.79163], [-121.77596, 36.79172], [-121.77844, 36.79145], [-121.78044, 36.79104], [-121.78068, 36.79169], [-121.78261, 36.79172], [-121.78266, 36.79204], [-121.78359, 36.79222]]], [[[-121.78611, 36.79726], [-121.78519, 36.79723], [-121.7851, 36.79786], [-121.78471, 36.79831], [-121.7847, 36.79778], [-121.78368, 36.79641], [-121.78354, 36.79634], [-121.78373, 36.79406], [-121.78472, 36.79377], [-121.7856, 36.79584], [-121.78601, 36.7966], [-121.7858, 36.79667], [-121.78584, 36.79679], [-121.78609, 36.79674], [-121.78611, 36.79678], [-121.78615, 36.79696], [-121.78611, 36.79726]]]]} | No Public Access 3 | 18002 | Moro Cojo Ecological Reserve | 22493 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 3019 | Elkhorn Slough Foundation 457 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 422.1 | Moro Cojo ER | 0 | Private Conservation 16 | 2 | |
15558 | 15558 | 15557 | {"type": "MultiPolygon", "coordinates": [[[[-117.23623, 33.03472], [-117.23609, 33.03514], [-117.23477, 33.03601], [-117.23459, 33.03653], [-117.23385, 33.03634], [-117.23455, 33.03424], [-117.23623, 33.03472]]], [[[-117.23374, 33.03631], [-117.23309, 33.03834], [-117.23296, 33.03831], [-117.23292, 33.03841], [-117.23201, 33.03818], [-117.23209, 33.03792], [-117.23191, 33.03787], [-117.23251, 33.03599], [-117.23374, 33.03631]]]]} | Open Access 1 | 1247 | San Elijo Lagoon Ecological Reserve | 24880 | 3058 | Rancho Santa Fe Community Foundation 1159 | Non Profit 6 | Non Profit - Other 22 | http://www.rsffoundation.org/ | Non Governmental Organization 10 | 3058 | Rancho Santa Fe Community Foundation 1101 | Non Profit 6 | Non Profit - Other 20 | https://www.sanelijo.org/home | San Diego 4 | 14.074 | San Elijo Lagoon ER | 1983 | Private Conservation 16 | 2 |
15537 | 15537 | 15536 | {"type": "MultiPolygon", "coordinates": [[[[-117.98592, 35.64413], [-117.98574, 35.64583], [-117.9766, 35.64559], [-117.97682, 35.64382], [-117.98592, 35.64413]]], [[[-118.03645, 35.5791], [-118.03201, 35.57914], [-118.032, 35.56461], [-118.03642, 35.56458], [-118.03645, 35.5791]]]]} | Open Access 1 | 48504 | Mojave Desert Land Trust | 6762 | 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/discover-learn/resources/ | Kern 36 | 199.344 | Mojave Desert Land Trust | 0 | Private Conservation 16 | 2 |
15536 | 15536 | 15535 | {"type": "MultiPolygon", "coordinates": [[[[-114.77302, 33.90916], [-114.77301, 33.91008], [-114.77085, 33.91008], [-114.77086, 33.90916], [-114.77302, 33.90916]]], [[[-115.15274, 33.61312], [-115.15165, 33.61311], [-115.15164, 33.61224], [-115.15274, 33.61224], [-115.15274, 33.61312]]], [[[-115.20131, 33.99267], [-115.19693, 33.99264], [-115.1969, 33.9899], [-115.20129, 33.98991], [-115.20131, 33.99267]]], [[[-115.30171, 33.90962], [-115.30171, 33.91299], [-115.30166, 33.91303], [-115.29755, 33.91304], [-115.2975, 33.913], [-115.2975, 33.90963], [-115.29755, 33.90959], [-115.30166, 33.90958], [-115.30171, 33.90962]]], [[[-115.35687, 33.60349], [-115.35447, 33.60741], [-115.35254, 33.60648], [-115.35493, 33.60258], [-115.35687, 33.60349]]], [[[-115.68288, 33.86961], [-115.68288, 33.87052], [-115.68176, 33.87052], [-115.68176, 33.8696], [-115.68288, 33.86961]]], [[[-115.70995, 33.84741], [-115.70995, 33.84923], [-115.70777, 33.84923], [-115.70778, 33.84742], [-115.70995, 33.84741]]], [[[-115.73557, 33.88834], [-115.73555, 33.88924], [-115.73447, 33.88923], [-115.73448, 33.88833], [-115.73557, 33.88834]]], [[[-115.74261, 33.84734], [-115.74261, 33.84915], [-115.73825, 33.84916], [-115.73826, 33.84735], [-115.74261, 33.84734]]], [[[-115.74432, 33.91186], [-115.7443, 33.91366], [-115.74198, 33.91365], [-115.742, 33.91185], [-115.73969, 33.91183], [-115.73976, 33.90642], [-115.74206, 33.90643], [-115.74201, 33.91184], [-115.74432, 33.91186]]], [[[-115.75567, 33.84414], [-115.75567, 33.84459], [-115.7535, 33.8446], [-115.7535, 33.84415], [-115.75567, 33.84414]]], [[[-115.76073, 33.68225], [-115.76071, 33.68588], [-115.75854, 33.68587], [-115.75855, 33.68224], [-115.76073, 33.68225]]], [[[-115.77812, 33.90403], [-115.77382, 33.90396], [-115.77381, 33.90305], [-115.77812, 33.90313], [-115.77812, 33.90403]]], [[[-115.78899, 33.91321], [-115.78683, 33.91317], [-115.78683, 33.91227], [-115.78899, 33.91231], [-115.78899, 33.91321]]], [[[-115.79544, 33.89806], [-115.79111, 33.89802], [-115.7911, 33.89711], [-115.79543, 33.89715], [-115.79544, 33.89806]]], [[[-115.80189, 33.89538], [-115.79973, 33.89536], [-115.79972, 33.89445], [-115.80188, 33.89447], [-115.80189, 33.89538]]], [[[-115.82997, 33.89854], [-115.82997, 33.89946], [-115.82783, 33.89943], [-115.82783, 33.89851], [-115.82997, 33.89854]]], [[[-115.83653, 33.89957], [-115.83439, 33.89954], [-115.83437, 33.89862], [-115.83651, 33.89865], [-115.83653, 33.89957]]], [[[-115.95303, 33.81649], [-115.94433, 33.81652], [-115.94433, 33.81289], [-115.94867, 33.81287], [-115.94867, 33.80925], [-115.95303, 33.80924], [-115.95303, 33.81649]]], [[[-115.96169, 33.79474], [-115.95735, 33.79474], [-115.95734, 33.78749], [-115.96168, 33.78749], [-115.96169, 33.79474]]], [[[-115.98768, 33.80562], [-115.98767, 33.80914], [-115.98341, 33.80918], [-115.98341, 33.80562], [-115.98768, 33.80562]]], [[[-116.00077, 33.79477], [-116.00077, 33.79835], [-115.99643, 33.79835], [-115.99643, 33.79472], [-116.00077, 33.79477]]], [[[-116.00411, 33.75851], [-116.00409, 33.76562], [-115.99964, 33.76563], [-115.99966, 33.75853], [-116.00411, 33.75851]]], [[[-116.01726, 33.75117], [-116.0086, 33.7512], [-116.0086, 33.74398], [-116.0172, 33.744], [-116.01726, 33.75117]]], [[[-116.03677, 33.73666], [-116.03466, 33.73666], [-116.03466, 33.73422], [-116.03466, 33.73422], [-116.03677, 33.73666]]], [[[-116.08326, 33.802], [-116.08326, 33.80924], [-116.07459, 33.80921], [-116.07459, 33.80201], [-116.08326, 33.802]]], [[[-116.10468, 33.80203], [-116.09194, 33.802], [-116.09194, 33.7916], [-116.09194, 33.7916], [-116.10468, 33.80203]]], [[[-116.10828, 33.85427], [-116.10827, 33.85445], [-116.10772, 33.85445], [-116.10772, 33.85427], [-116.10828, 33.85427]]], [[[-116.12335, 33.81658], [-116.10939, 33.81656], [-116.1094, 33.80532], [-116.1094, 33.80532], [-116.12335, 33.81658]]], [[[-116.11696, 33.84468], [-116.11641, 33.84468], [-116.11641, 33.8445], [-116.11696, 33.8445], [-116.11696, 33.84468]]], [[[-116.11751, 33.83778], [-116.11696, 33.83778], [-116.11696, 33.8376], [-116.11751, 33.8376], [-116.11751, 33.83778]]], [[[-116.12238, 33.83906], [-116.12238, 33.83924], [-116.12184, 33.83924], [-116.12184, 33.83906], [-116.12238, 33.83906]]], [[[-116.13213, 33.85573], [-116.13213, 33.85591], [-116.13159, 33.85591], [-116.13159, 33.85573], [-116.13213, 33.85573]]], [[[-116.1474, 33.83113], [-116.14739, 33.83148], [-116.14686, 33.83148], [-116.14684, 33.8324], [-116.14631, 33.8324], [-116.1463, 33.83329], [-116.14577, 33.8333], [-116.14576, 33.83345], [-116.14522, 33.83345], [-116.14521, 33.83312], [-116.14468, 33.83312], [-116.14468, 33.83256], [-116.14413, 33.83255], [-116.14413, 33.83112], [-116.1474, 33.83113]]], [[[-116.1616, 33.84166], [-116.16105, 33.84165], [-116.16105, 33.84149], [-116.16052, 33.84148], [-116.16051, 33.84113], [-116.15997, 33.84113], [-116.15995, 33.84095], [-116.15944, 33.84094], [-116.15942, 33.84058], [-116.15887, 33.84058], [-116.15886, 33.84039], [-116.15834, 33.84039], [-116.15833, 33.84003], [-116.15778, 33.84002], [-116.15777, 33.83984], [-116.15723, 33.83984], [-116.15722, 33.8395], [-116.15668, 33.83949], [-116.15667, 33.8393], [-116.15615, 33.83929], [-116.15615, 33.83894], [-116.15561, 33.83894], [-116.1556, 33.83875], [-116.15506, 33.83875], [-116.15504, 33.83838], [-116.15448, 33.83838], [-116.15446, 33.8382], [-116.15394, 33.8382], [-116.15394, 33.83785], [-116.1534, 33.83785], [-116.15339, 33.83767], [-116.15288, 33.83766], [-116.15287, 33.83732], [-116.15234, 33.83731], [-116.15233, 33.83693], [-116.15181, 33.83693], [-116.1518, 33.83673], [-116.15122, 33.83673], [-116.15122, 33.83638], [-116.15069, 33.83637], [-116.15068, 33.83618], [-116.15013, 33.83618], [-116.15012, 33.83583], [-116.14958, 33.83584], [-116.14958, 33.83566], [-116.14901, 33.83566], [-116.14902, 33.83528], [-116.14848, 33.83527], [-116.14847, 33.83511], [-116.14797, 33.83512], [-116.14797, 33.83476], [-116.14742, 33.83475], [-116.14742, 33.83419], [-116.14796, 33.8342], [-116.14796, 33.8333], [-116.14846, 33.8333], [-116.14848, 33.83256], [-116.14902, 33.83254], [-116.14903, 33.83165], [-116.14956, 33.83164], [-116.14958, 33.83114], [-116.1616, 33.83118], [-116.1616, 33.84166]], [[-116.15446, 33.83672], [-116.15446, 33.83655], [-116.15393, 33.83655], [-116.15393, 33.83672], [-116.15446, 33.83672]], [[-116.15556, 33.83548], [-116.15557, 33.83528], [-116.15505, 33.83528], [-116.15505, 33.83548], [-116.15556, 33.83548]], [[-116.15834, 33.8384], [-116.15778, 33.83839], [-116.15778, 33.83857], [-116.15833, 33.83858], [-116.15834, 33.8384]]], [[[-116.16596, 33.85561], [-116.16596, 33.85579], [-116.16542, 33.85579], [-116.16542, 33.85561], [-116.16596, 33.85561]]], [[[-116.16813, 33.84801], [-116.16813, 33.84819], [-116.16757, 33.84819], [-116.16756, 33.84801], [-116.16813, 33.84801]]], [[[-116.17033, 33.84728], [-116.17033, 33.84747], [-116.16977, 33.84747], [-116.16977, 33.84728], [-116.17033, 33.84728]]], [[[-116.17907, 33.85038], [-116.17852, 33.85038], [-116.17851, 33.8502], [-116.17795, 33.8502], [-116.17794, 33.84985], [-116.1774, 33.84985], [-116.17739, 33.84967], [-116.17686, 33.84966], [-116.17686, 33.8493], [-116.17632, 33.8493], [-116.17632, 33.84912], [-116.17577, 33.84912], [-116.17576, 33.84875], [-116.17523, 33.84875], [-116.17522, 33.84857], [-116.17468, 33.84857], [-116.17468, 33.8482], [-116.17413, 33.8482], [-116.17412, 33.84802], [-116.17358, 33.84802], [-116.17357, 33.84764], [-116.17303, 33.84764], [-116.17303, 33.84747], [-116.1725, 33.84747], [-116.1725, 33.84711], [-116.17195, 33.84711], [-116.17194, 33.84693], [-116.1714, 33.84693], [-116.1714, 33.84658], [-116.17088, 33.84658], [-116.17087, 33.8464], [-116.17033, 33.84639], [-116.17033, 33.84603], [-116.16978, 33.84603], [-116.16978, 33.84566], [-116.17906, 33.84568], [-116.17907, 33.85038]]], [[[-116.17688, 33.85292], [-116.17633, 33.85292], [-116.17634, 33.85273], [-116.17687, 33.85274], [-116.17688, 33.85292]]]]} | Open Access 1 | 48499 | Mojave Desert Land Trust | 6762 | 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/discover-learn/resources/ | Riverside 10 | 1610.252 | Mojave Desert Land Trust | 0 | Private Conservation 16 | 2 |
15416 | 15416 | 15415 | {"type": "Polygon", "coordinates": [[[-122.37853, 37.32895], [-122.37805, 37.32924], [-122.37762, 37.3292], [-122.3777, 37.32951], [-122.37792, 37.32985], [-122.37781, 37.33039], [-122.37842, 37.33132], [-122.37838, 37.33141], [-122.37455, 37.33007], [-122.37418, 37.3299], [-122.37247, 37.32936], [-122.37202, 37.32924], [-122.37168, 37.32917], [-122.37127, 37.32912], [-122.37086, 37.32908], [-122.37044, 37.32908], [-122.37003, 37.32909], [-122.36962, 37.32914], [-122.36922, 37.3292], [-122.36884, 37.32929], [-122.36907, 37.32827], [-122.36935, 37.32808], [-122.36969, 37.32792], [-122.3697, 37.32776], [-122.37017, 37.32769], [-122.37057, 37.3273], [-122.37075, 37.32726], [-122.37125, 37.32748], [-122.37164, 37.32756], [-122.37214, 37.32794], [-122.37264, 37.32808], [-122.37287, 37.32826], [-122.37326, 37.3284], [-122.37343, 37.32875], [-122.37367, 37.32896], [-122.37409, 37.32913], [-122.37495, 37.32931], [-122.37536, 37.3291], [-122.37556, 37.32903], [-122.3762, 37.32891], [-122.3773, 37.32889], [-122.37756, 37.32883], [-122.37813, 37.32896], [-122.37853, 37.32895]]]} | No Public Access 3 | 49048 | Rising Acres | 33757 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 31.341 | Rising Acres | 2020 | Private Conservation 16 | 2 | |
15336 | 15336 | 15335 | {"type": "Polygon", "coordinates": [[[-118.30015, 33.94065], [-118.30015, 33.94116], [-118.29968, 33.94116], [-118.29969, 33.94065], [-118.30015, 33.94065]]]} | Restricted Access 2 | 46515 | West Athens Victory Garden | 29801 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://littlegreenfingersla.org/garden/west-athens-victory-garden/ | Los Angeles 6 | 0.591 | West Athens Victory Garden | 2013 | Private Conservation 16 | 2 |
15293 | 15293 | 15292 | {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} | No Public Access 3 | 46424 | El Segundo Blue Butterfly Preserve | 29696 | 6107 | Chevron Corporation 1149 | Private 7 | Commercial 20 | http://www.chevron.com/ | Private 14 | 6107 | Chevron Corporation 1096 | Private 7 | Commercial 18 | Los Angeles 6 | 1.358 | El Segundo Blue Butterfly Preserve | 0 | Private Conservation 16 | 2 | |
15281 | 15281 | 15280 | {"type": "MultiPolygon", "coordinates": [[[[-120.86261, 38.53701], [-120.86257, 38.53794], [-120.86264, 38.5384], [-120.86251, 38.53943], [-120.86255, 38.53979], [-120.86253, 38.54056], [-120.86247, 38.54133], [-120.86227, 38.54212], [-120.86232, 38.54264], [-120.86183, 38.54323], [-120.86116, 38.54345], [-120.86029, 38.54304], [-120.85959, 38.54261], [-120.8578, 38.54218], [-120.85666, 38.54224], [-120.85572, 38.54279], [-120.8553, 38.54346], [-120.8552, 38.54393], [-120.85244, 38.54392], [-120.8524, 38.54218], [-120.85217, 38.54078], [-120.86208, 38.54056], [-120.86202, 38.53698], [-120.86261, 38.53701]]], [[[-120.85667, 38.54735], [-120.85662, 38.54767], [-120.85595, 38.54814], [-120.85555, 38.54854], [-120.8547, 38.54903], [-120.8538, 38.54953], [-120.85255, 38.55006], [-120.8525, 38.54733], [-120.85667, 38.54735]]]]} | Restricted Access 2 | 47297 | El Dorado Ranch | 31004 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | Amador 52 | 78.399 | El Dorado Ranch | 0 | Private Conservation 16 | 2 | |
15224 | 15224 | 15223 | {"type": "Polygon", "coordinates": [[[-118.23503, 34.23759], [-118.23503, 34.23806], [-118.23462, 34.23806], [-118.23461, 34.23986], [-118.23209, 34.23854], [-118.23386, 34.23773], [-118.23387, 34.2376], [-118.2342, 34.2376], [-118.2341, 34.23765], [-118.23431, 34.23783], [-118.23426, 34.23792], [-118.23429, 34.23804], [-118.23448, 34.23798], [-118.2346, 34.23798], [-118.23482, 34.23792], [-118.23494, 34.23772], [-118.23497, 34.23759], [-118.23503, 34.23759]]]} | Open Access 1 | 46183 | Rosemont Preserve | 29488 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/rosemont/ | Los Angeles 6 | 7.668 | Rosemont Preserve | 0 | Private Conservation 16 | 2 |
15167 | 15167 | 15166 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09512], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09465], [-117.27011, 33.09307], [-117.2703, 33.09301], [-117.27048, 33.09283], [-117.27071, 33.09282], [-117.27099, 33.09295], [-117.27164, 33.09308], [-117.2715, 33.09331], [-117.27151, 33.09332], [-117.27233, 33.09353], [-117.27312, 33.09348], [-117.27325, 33.09329], [-117.27351, 33.09329], [-117.27355, 33.09311], [-117.27415, 33.09307], [-117.27413, 33.09316], [-117.27439, 33.09325], [-117.27448, 33.09326], [-117.27449, 33.09512]]]} | Open Access 1 | 47291 | Cholla Point | 30996 | 3220 | Batiquitos Lagoon Foundation 1138 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/category/visit/ | San Diego 4 | 20.824 | Cholla Point | 2011 | Private Conservation 16 | 2 |
15148 | 15148 | 15147 | {"type": "MultiPolygon", "coordinates": [[[[-120.41957, 39.20187], [-120.4169, 39.21534], [-120.4075, 39.2155], [-120.39824, 39.21551], [-120.40113, 39.22913], [-120.38195, 39.22954], [-120.37973, 39.21554], [-120.36287, 39.21575], [-120.36267, 39.22994], [-120.3575, 39.22992], [-120.34426, 39.22975], [-120.34426, 39.22825], [-120.34441, 39.21377], [-120.32839, 39.21429], [-120.32899, 39.20107], [-120.34482, 39.20103], [-120.34478, 39.20247], [-120.35234, 39.20247], [-120.35053, 39.18017], [-120.35009, 39.17281], [-120.34973, 39.16545], [-120.34941, 39.15824], [-120.34919, 39.15288], [-120.349, 39.14735], [-120.34886, 39.14376], [-120.36876, 39.14361], [-120.36801, 39.1291], [-120.35794, 39.12885], [-120.34815, 39.12868], [-120.34857, 39.13618], [-120.34878, 39.14199], [-120.33091, 39.14182], [-120.33022, 39.12723], [-120.34808, 39.12751], [-120.34775, 39.12113], [-120.34739, 39.1135], [-120.36773, 39.11396], [-120.36793, 39.10676], [-120.3676, 39.09886], [-120.38773, 39.09918], [-120.38759, 39.11378], [-120.37751, 39.11395], [-120.36774, 39.11397], [-120.36773, 39.11398], [-120.3679, 39.12173], [-120.36801, 39.12909], [-120.37794, 39.12928], [-120.38774, 39.12921], [-120.38806, 39.13639], [-120.38842, 39.14358], [-120.36876, 39.14362], [-120.36957, 39.15815], [-120.35927, 39.15824], [-120.35956, 39.16914], [-120.37014, 39.16917], [-120.37033, 39.17276], [-120.37065, 39.18017], [-120.3719, 39.20244], [-120.37657, 39.20243], [-120.37625, 39.19484], [-120.38104, 39.19484], [-120.38084, 39.18746], [-120.38574, 39.18741], [-120.3857, 39.18373], [-120.39066, 39.18369], [-120.39065, 39.18737], [-120.39989, 39.18729], [-120.40931, 39.18725], [-120.40928, 39.20208], [-120.41957, 39.20187]], [[-120.40087, 39.2021], [-120.40086, 39.20209], [-120.39789, 39.20215], [-120.3906, 39.20226], [-120.39063, 39.19106], [-120.38579, 39.1911], [-120.38583, 39.19479], [-120.38104, 39.19485], [-120.38125, 39.20242], [-120.38208, 39.20242], [-120.38091, 39.20906], [-120.37974, 39.21554], [-120.38901, 39.21574], [-120.39823, 39.2155], [-120.40087, 39.2021]]], [[[-120.45621, 39.20083], [-120.45598, 39.21519], [-120.44679, 39.21526], [-120.44217, 39.21531], [-120.43751, 39.21546], [-120.43762, 39.20166], [-120.44631, 39.20136], [-120.45621, 39.20083]]]]} | Open Access 1 | 45990 | American River Headwaters | 29161 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | http://northernsierrapartnership.org/american-river-headwaters/ | Placer 35 | 10210.918 | American River Headwaters | 0 | Private Conservation 16 | 2 |
15133 | 15133 | 15132 | {"type": "Polygon", "coordinates": [[[-117.98619, 34.17245], [-117.98605, 34.1798], [-117.9775, 34.17979], [-117.97751, 34.17245], [-117.98619, 34.17245]]]} | Open Access 1 | 45953 | Canyon Park, Boy Scouts of America | 29062 | 3360 | Boy Scouts of America 1137 | Non Profit 6 | Non Profit - Other 22 | http://www.scouting.org/ | Non Governmental Organization 10 | 3360 | Boy Scouts of America 1092 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 159.848 | Canyon Park, Boy Scouts of America | 0 | Private Conservation 16 | 2 | |
14911 | 14911 | 14910 | {"type": "Polygon", "coordinates": [[[-122.30297, 37.29664], [-122.30295, 37.29671], [-122.30267, 37.29704], [-122.30281, 37.2978], [-122.29738, 37.29781], [-122.29481, 37.29558], [-122.2951, 37.29432], [-122.29511, 37.29408], [-122.29507, 37.29385], [-122.29496, 37.2936], [-122.2948, 37.29337], [-122.29382, 37.29246], [-122.29373, 37.29235], [-122.2929, 37.29083], [-122.29276, 37.28996], [-122.29269, 37.28996], [-122.29269, 37.28969], [-122.29228, 37.28866], [-122.29228, 37.28856], [-122.29229, 37.28847], [-122.29243, 37.28816], [-122.29246, 37.28799], [-122.29246, 37.28782], [-122.2924, 37.28751], [-122.28755, 37.28742], [-122.28757, 37.28477], [-122.28646, 37.28328], [-122.28659, 37.28114], [-122.28663, 37.28115], [-122.28691, 37.28169], [-122.28695, 37.28179], [-122.28697, 37.28195], [-122.28703, 37.28206], [-122.2876, 37.28249], [-122.28813, 37.28301], [-122.28826, 37.28309], [-122.28843, 37.28316], [-122.2889, 37.28325], [-122.28914, 37.28332], [-122.28981, 37.28363], [-122.28998, 37.28374], [-122.29009, 37.28388], [-122.29028, 37.28434], [-122.29049, 37.28469], [-122.29079, 37.28504], [-122.29117, 37.2854], [-122.29125, 37.28552], [-122.29132, 37.28567], [-122.29139, 37.28574], [-122.29152, 37.28579], [-122.29179, 37.28581], [-122.29186, 37.28585], [-122.29192, 37.28591], [-122.29201, 37.28581], [-122.29211, 37.2858], [-122.29237, 37.28581], [-122.29262, 37.28588], [-122.29287, 37.286], [-122.29334, 37.28637], [-122.29359, 37.28652], [-122.29392, 37.28664], [-122.29411, 37.28667], [-122.29432, 37.28669], [-122.29447, 37.28676], [-122.29462, 37.28686], [-122.2947, 37.2869], [-122.2962, 37.28699], [-122.29958, 37.28635], [-122.30011, 37.28489], [-122.30214, 37.28543], [-122.30189, 37.28583], [-122.30182, 37.28617], [-122.30184, 37.28642], [-122.30198, 37.28672], [-122.30272, 37.28733], [-122.30287, 37.28749], [-122.30298, 37.28775], [-122.30304, 37.28825], [-122.30298, 37.28862], [-122.303, 37.28903], [-122.30281, 37.29024], [-122.30271, 37.29038], [-122.30232, 37.29072], [-122.30216, 37.29094], [-122.30178, 37.29188], [-122.30174, 37.2922], [-122.30207, 37.29344], [-122.30215, 37.29437], [-122.30224, 37.29437], [-122.30233, 37.29604], [-122.30238, 37.29628], [-122.30247, 37.29634], [-122.30292, 37.29655], [-122.30297, 37.29664]]]} | No Public Access 3 | 45467 | Burns Valley | 28293 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 281.018 | Burns Valley | 0 | Private Conservation 16 | 2 | |
14900 | 14900 | 14899 | {"type": "Polygon", "coordinates": [[[-123.42084, 39.55003], [-123.41214, 39.55007], [-123.40741, 39.55012], [-123.4072, 39.54657], [-123.40255, 39.54663], [-123.40249, 39.54308], [-123.40014, 39.54311], [-123.39904, 39.5431], [-123.39773, 39.54311], [-123.39545, 39.54318], [-123.39303, 39.5432], [-123.39288, 39.53964], [-123.39278, 39.5361], [-123.38808, 39.53613], [-123.38803, 39.53072], [-123.3831, 39.53083], [-123.38306, 39.53065], [-123.38307, 39.53028], [-123.38305, 39.53019], [-123.38263, 39.52977], [-123.38253, 39.5296], [-123.38253, 39.5295], [-123.38256, 39.52938], [-123.38261, 39.52933], [-123.38274, 39.52931], [-123.38293, 39.52934], [-123.38329, 39.52947], [-123.3837, 39.52959], [-123.3839, 39.5296], [-123.38399, 39.52959], [-123.3841, 39.52952], [-123.3848, 39.52891], [-123.38806, 39.52882], [-123.3927, 39.52893], [-123.39278, 39.53609], [-123.39738, 39.53607], [-123.39761, 39.53959], [-123.40701, 39.53956], [-123.40711, 39.543], [-123.41162, 39.54284], [-123.41603, 39.54293], [-123.41927, 39.54301], [-123.41988, 39.54296], [-123.42054, 39.54333], [-123.42084, 39.55003]]]} | No Public Access 3 | 45452 | Outlet Creek Ranch | 28254 | 3051 | Pacific Forest Trust 601 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.pacificforest.org/ | Non Governmental Organization 10 | 3051 | Pacific Forest Trust 591 | Non Profit 6 | Non Profit - Land Trust 10 | https://pacificforest.org/origins-outlet-creek-ranch.html | Mendocino 24 | 522.006 | Outlet Creek Ranch | 0 | Private Conservation 16 | 2 |
14880 | 14880 | 14879 | {"type": "Polygon", "coordinates": [[[-121.65082, 36.93893], [-121.65074, 36.93899], [-121.65013, 36.93931], [-121.64972, 36.93948], [-121.64959, 36.93956], [-121.64915, 36.94008], [-121.64901, 36.9403], [-121.64895, 36.94043], [-121.64908, 36.94046], [-121.64913, 36.94067], [-121.64911, 36.94075], [-121.64895, 36.94122], [-121.64869, 36.94149], [-121.64819, 36.94181], [-121.6478, 36.94195], [-121.64696, 36.94253], [-121.64675, 36.94246], [-121.64666, 36.94258], [-121.64615, 36.94303], [-121.64598, 36.94328], [-121.64615, 36.9443], [-121.64636, 36.94445], [-121.6463, 36.94468], [-121.64597, 36.94506], [-121.64561, 36.94531], [-121.64542, 36.94528], [-121.64511, 36.94532], [-121.64484, 36.9454], [-121.64429, 36.94577], [-121.64369, 36.94589], [-121.64274, 36.94653], [-121.64255, 36.94661], [-121.64201, 36.94667], [-121.64156, 36.94676], [-121.64127, 36.94675], [-121.64121, 36.94687], [-121.64119, 36.94695], [-121.64052, 36.947], [-121.63823, 36.94697], [-121.63793, 36.94702], [-121.63764, 36.94711], [-121.63622, 36.94719], [-121.63535, 36.94721], [-121.63495, 36.94726], [-121.63339, 36.94802], [-121.63372, 36.94846], [-121.63381, 36.94863], [-121.63362, 36.94871], [-121.63354, 36.94862], [-121.63361, 36.94848], [-121.63315, 36.94785], [-121.63308, 36.94786], [-121.63303, 36.94833], [-121.63297, 36.94783], [-121.63358, 36.94777], [-121.63365, 36.94733], [-121.63384, 36.94717], [-121.63383, 36.94679], [-121.63409, 36.94661], [-121.63419, 36.94632], [-121.63414, 36.94575], [-121.63338, 36.94548], [-121.63291, 36.94549], [-121.63265, 36.94534], [-121.63249, 36.94475], [-121.63236, 36.94473], [-121.63225, 36.9443], [-121.63216, 36.94421], [-121.63139, 36.94396], [-121.63072, 36.94383], [-121.63052, 36.94371], [-121.63033, 36.94371], [-121.63028, 36.9436], [-121.63017, 36.94343], [-121.62995, 36.94329], [-121.62947, 36.94307], [-121.62915, 36.94265], [-121.62766, 36.94204], [-121.62739, 36.94197], [-121.62692, 36.94129], [-121.62692, 36.94111], [-121.62672, 36.94098], [-121.62616, 36.94082], [-121.6259, 36.94069], [-121.62525, 36.94025], [-121.62459, 36.9401], [-121.62441, 36.93996], [-121.62424, 36.93987], [-121.62377, 36.93952], [-121.6235, 36.93873], [-121.62319, 36.93731], [-121.62337, 36.93654], [-121.62324, 36.9362], [-121.62345, 36.93606], [-121.62359, 36.93642], [-121.62374, 36.93765], [-121.62392, 36.93804], [-121.62552, 36.93901], [-121.62633, 36.93924], [-121.62716, 36.93918], [-121.628, 36.93918], [-121.62857, 36.93896], [-121.62877, 36.93864], [-121.62918, 36.93774], [-121.62937, 36.93763], [-121.62976, 36.93699], [-121.63005, 36.93676], [-121.63091, 36.93616], [-121.63176, 36.93582], [-121.63257, 36.93555], [-121.63302, 36.93529], [-121.63326, 36.93508], [-121.63367, 36.93477], [-121.63406, 36.93468], [-121.63471, 36.93467], [-121.63535, 36.93435], [-121.63561, 36.93389], [-121.63609, 36.93318], [-121.63517, 36.93023], [-121.63936, 36.93044], [-121.65082, 36.93893]]]} | Restricted Access 2 | 45401 | Star Creek Ranch | 25798 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Clara 19 | 599.708 | Star Creek Ranch | 0 | Private Conservation 16 | 2 | |
14870 | 14870 | 14869 | {"type": "MultiPolygon", "coordinates": [[[[-120.15267, 34.49122], [-120.15228, 34.4922], [-120.15217, 34.49282], [-120.15255, 34.4938], [-120.15248, 34.49449], [-120.14278, 34.49419], [-120.13893, 34.49416], [-120.13889, 34.49768], [-120.1342, 34.49771], [-120.1342, 34.505], [-120.12975, 34.50509], [-120.12979, 34.50135], [-120.12982, 34.4941], [-120.13523, 34.49413], [-120.13464, 34.48442], [-120.13497, 34.48341], [-120.13513, 34.48146], [-120.13613, 34.48063], [-120.13633, 34.47938], [-120.13667, 34.47869], [-120.13669, 34.47768], [-120.13666, 34.47701], [-120.13692, 34.47668], [-120.13726, 34.47647], [-120.13835, 34.47593], [-120.13874, 34.47578], [-120.139, 34.47533], [-120.14014, 34.47557], [-120.14157, 34.47568], [-120.14223, 34.47526], [-120.14337, 34.47519], [-120.14408, 34.47756], [-120.14393, 34.4779], [-120.14424, 34.47831], [-120.14464, 34.47879], [-120.14491, 34.47972], [-120.14537, 34.48035], [-120.14569, 34.48113], [-120.14516, 34.48206], [-120.14711, 34.48265], [-120.14848, 34.48295], [-120.14862, 34.48324], [-120.14901, 34.48353], [-120.14987, 34.48409], [-120.15038, 34.4878], [-120.15106, 34.48938], [-120.15124, 34.49027], [-120.15267, 34.49122]]], [[[-120.1429, 34.47385], [-120.1429, 34.47385], [-120.13965, 34.47375], [-120.13973, 34.47355], [-120.14096, 34.47354], [-120.14157, 34.47337], [-120.14276, 34.47341], [-120.1429, 34.47385]]]]} | Restricted Access 2 | 45419 | Arroyo Hondo Preserve | 28193 | 3033 | Land Trust for Santa Barbara County 269 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org | Non Governmental Organization 10 | 3033 | Land Trust for Santa Barbara County 264 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sblandtrust.org/arroyo-hondo-preserve-2/ | Santa Barbara 7 | 781.322 | Arroyo Hondo Preserve | 0 | Private Conservation 16 | 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]);