units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
629 rows where DES_TP = 16 sorted by COUNTY
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Nature Conservancy 46
- National Audubon Society 26
- Sonoma Land Trust 24
- Peninsula Open Space Trust 23
- Center for Natural Lands Management 22
- Truckee Donner Land Trust 22
- Big Sur Land Trust 21
- The Wildlands Conservancy 21
- The Environmental Trust 21
- Land Trust of Napa County 18
- Sempervirens Fund 18
- American River Conservancy 18
- Save Mount Diablo 17
- Endangered Habitats Conservancy 14
- Land Trust of Santa Cruz County 14
- Fallbrook Land Conservancy 14
- Wilderness Land Trust 13
- Save the Redwoods League 10
- Bear Yuba Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- Mojave Desert Land Trust 8
- The Conservation Fund - California 8
- Coastside Land Trust 8
- Ojai Valley Land Conservancy 8
- Friends of the Desert Mountains 7
- Sierra Foothill Conservancy 7
- Solano Land Trust 7
- San Diego River Park Foundation 7
- John Muir Land Trust 6
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- No Public Access 206
- Open Access 205
- Restricted Access 146
- Unknown Access 52
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13959 | 13959 | 13958 | {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} | Restricted Access 2 | 36667 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 0.596 | Woodspring Pool | 0 | Private Conservation 16 | 2 | |
14157 | 14157 | 14156 | {"type": "Polygon", "coordinates": [[[-117.67909, 33.649], [-117.67893, 33.64913], [-117.67899, 33.64929], [-117.67864, 33.64938], [-117.67843, 33.64889], [-117.67844, 33.64887], [-117.67849, 33.64885], [-117.67865, 33.6488], [-117.67888, 33.64875], [-117.67905, 33.64874], [-117.67909, 33.64874], [-117.67911, 33.64877], [-117.67904, 33.64889], [-117.67905, 33.64895], [-117.67909, 33.649]]]} | Restricted Access 2 | 43052 | Sterling Heights park | 32391 | 6044 | Lake Forest Drive Association 1088 | Private 7 | Home Owners Association 16 | http://lakeforestdrivehoa.org/ | Private 14 | 6044 | Lake Forest Drive Association 1044 | Private 7 | Home Owners Association 15 | Orange 3 | 0.718 | Sterling Heights park | 0 | Private Conservation 16 | 2 | |
154 | 154 | 153 | {"type": "Polygon", "coordinates": [[[-116.74026, 33.1805], [-116.73988, 33.18051], [-116.73975, 33.18053], [-116.73967, 33.18056], [-116.7395, 33.18056], [-116.73938, 33.18052], [-116.73921, 33.18041], [-116.73814, 33.18041], [-116.73818, 33.18262], [-116.73708, 33.18261], [-116.73375, 33.18275], [-116.73377, 33.17923], [-116.74025, 33.17921], [-116.74026, 33.1805]]]} | No Public Access 3 | 416 | Ewing Oak Preserve | 18771 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 45.451 | Ewing Oak Preserve | 0 | Private Conservation 16 | 2 | |
196 | 196 | 195 | {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} | No Public Access 3 | 46830 | Palmer Property | 30298 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 2.548 | Palmer Property | 0 | Private Conservation 16 | 2 | |
373 | 373 | 372 | {"type": "Polygon", "coordinates": [[[-116.60471, 32.647], [-116.60365, 32.64701], [-116.60374, 32.65066], [-116.60273, 32.65066], [-116.60285, 32.65426], [-116.59867, 32.65421], [-116.59854, 32.65064], [-116.59431, 32.65062], [-116.594, 32.64348], [-116.60462, 32.64364], [-116.60471, 32.647]], [[-116.60259, 32.64699], [-116.6026, 32.64698], [-116.60254, 32.64525], [-116.60039, 32.64526], [-116.60045, 32.64697], [-116.60259, 32.64699]]]} | Open Access 1 | 1332 | Hauser Mountain Wilderness Area | 19739 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 211.322 | Hauser Mtn. Wilderness Area | 0 | Private Conservation 16 | 2 | |
506 | 506 | 505 | {"type": "MultiPolygon", "coordinates": [[[[-117.27627, 33.00739], [-117.27504, 33.00739], [-117.2747, 33.00609], [-117.27585, 33.00585], [-117.27627, 33.00739]]], [[[-117.27872, 33.01019], [-117.27851, 33.01023], [-117.27848, 33.01015], [-117.27776, 33.01024], [-117.27717, 33.00818], [-117.27719, 33.00739], [-117.27811, 33.00739], [-117.27872, 33.01019]]], [[[-117.28062, 33.01586], [-117.27959, 33.01462], [-117.27965, 33.0146], [-117.27881, 33.01309], [-117.27849, 33.01246], [-117.27863, 33.01249], [-117.27881, 33.01257], [-117.279, 33.01271], [-117.27907, 33.0128], [-117.27911, 33.01304], [-117.27918, 33.01328], [-117.27925, 33.01345], [-117.27927, 33.01347], [-117.27929, 33.01354], [-117.27938, 33.01371], [-117.27941, 33.01373], [-117.27972, 33.01373], [-117.28062, 33.01586]]], [[[-117.24209, 33.02688], [-117.24209, 33.0269], [-117.24209, 33.0269], [-117.24209, 33.02689], [-117.24209, 33.02688]]], [[[-117.24208, 33.02693], [-117.24068, 33.03133], [-117.24057, 33.03144], [-117.24046, 33.03161], [-117.24027, 33.03221], [-117.23803, 33.03162], [-117.23733, 33.03373], [-117.23611, 33.03341], [-117.23597, 33.03384], [-117.23569, 33.03369], [-117.23553, 33.03368], [-117.23531, 33.03354], [-117.23555, 33.03272], [-117.23608, 33.03226], [-117.23857, 33.03003], [-117.24113, 33.02779], [-117.24194, 33.02703], [-117.24208, 33.02693]]]]} | Open Access 1 | 1697 | San Elijo Lagoon Ecological Reserve | 24881 | 3067 | San Elijo Lagoon Conservancy 191 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sanelijo.org/ | Non Governmental Organization 10 | 3067 | San Elijo Lagoon Conservancy 187 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdparks.org/content/sdparks/en/park-pages/SanElijo.html | San Diego 4 | 48.843 | San Elijo Lagoon ER | 1983 | Private Conservation 16 | 2 |
1276 | 1276 | 1275 | {"type": "Polygon", "coordinates": [[[-117.15714, 33.37086], [-117.15594, 33.37098], [-117.15595, 33.37274], [-117.15594, 33.37275], [-117.15292, 33.37263], [-117.15238, 33.37503], [-117.1519, 33.37517], [-117.15148, 33.37559], [-117.15192, 33.37642], [-117.14826, 33.37642], [-117.14851, 33.37245], [-117.14388, 33.37276], [-117.14406, 33.36574], [-117.14184, 33.36576], [-117.142, 33.36267], [-117.13987, 33.36258], [-117.13989, 33.36211], [-117.14228, 33.36219], [-117.14343, 33.36081], [-117.14362, 33.36082], [-117.14372, 33.36086], [-117.14383, 33.36092], [-117.14391, 33.36092], [-117.14397, 33.36089], [-117.14399, 33.36086], [-117.144, 33.36079], [-117.14387, 33.36051], [-117.14387, 33.36046], [-117.14393, 33.36042], [-117.14395, 33.36042], [-117.14418, 33.36063], [-117.14429, 33.36068], [-117.14507, 33.36085], [-117.14543, 33.36098], [-117.14557, 33.36105], [-117.14562, 33.3611], [-117.14568, 33.36117], [-117.1457, 33.36123], [-117.14575, 33.36128], [-117.14586, 33.36132], [-117.14606, 33.36131], [-117.14618, 33.36127], [-117.1463, 33.36119], [-117.14635, 33.36112], [-117.14643, 33.36104], [-117.14678, 33.36089], [-117.14689, 33.36082], [-117.14693, 33.36077], [-117.14715, 33.36066], [-117.14712, 33.3608], [-117.14712, 33.36089], [-117.14702, 33.36109], [-117.14701, 33.36122], [-117.14703, 33.36124], [-117.14804, 33.36138], [-117.14831, 33.36177], [-117.14855, 33.3618], [-117.14855, 33.36571], [-117.15713, 33.36567], [-117.15714, 33.37086]], [[-117.14362, 33.36422], [-117.14363, 33.36407], [-117.1436, 33.364], [-117.14349, 33.3639], [-117.14336, 33.36384], [-117.14323, 33.36383], [-117.14307, 33.36388], [-117.14295, 33.36397], [-117.1429, 33.36408], [-117.1429, 33.36419], [-117.14295, 33.3643], [-117.14304, 33.36438], [-117.14316, 33.36444], [-117.14334, 33.36445], [-117.14345, 33.36441], [-117.1435, 33.36438], [-117.14358, 33.36431], [-117.14362, 33.36422]], [[-117.15178, 33.3673], [-117.15181, 33.36725], [-117.15157, 33.36726], [-117.15158, 33.36751], [-117.1516, 33.3675], [-117.15178, 33.3673]]]} | Open Access 1 | 7246 | Monserate Mountain Preserve | 3664 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/monserate-mountain.html | San Diego 4 | 343.819 | Monserate Mtn. Preserve | 0 | Private Conservation 16 | 2 |
1282 | 1282 | 1281 | {"type": "Polygon", "coordinates": [[[-117.23197, 33.35767], [-117.23195, 33.35817], [-117.23163, 33.35818], [-117.2314, 33.35817], [-117.23119, 33.35811], [-117.23111, 33.35808], [-117.23108, 33.35804], [-117.2311, 33.358], [-117.23133, 33.35781], [-117.23146, 33.35767], [-117.2318, 33.35723], [-117.2319, 33.35729], [-117.23197, 33.35767]]]} | Open Access 1 | 7247 | Palomares House | 23367 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/palomares-house-and-park.html | San Diego 4 | 1.248 | Palomares House | 0 | Private Conservation 16 | 2 |
1301 | 1301 | 1300 | {"type": "MultiPolygon", "coordinates": [[[[-117.13039, 33.09966], [-117.12847, 33.0991], [-117.12813, 33.09906], [-117.12781, 33.09906], [-117.12747, 33.0991], [-117.12747, 33.09743], [-117.12941, 33.09743], [-117.1294, 33.09846], [-117.13038, 33.09848], [-117.13039, 33.09966]]], [[[-117.13063, 33.0997], [-117.13052, 33.09975], [-117.13053, 33.0991], [-117.13063, 33.09923], [-117.13063, 33.0997]]]]} | No Public Access 3 | 10457 | Quarry Property | 24058 | 3021 | Escondido Creek Conservancy 344 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.escondidocreek.org/ | Non Governmental Organization 10 | 3021 | Escondido Creek Conservancy 341 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 11.308 | Quarry Property | 0 | Private Conservation 16 | 2 | |
1578 | 1578 | 1577 | {"type": "Polygon", "coordinates": [[[-117.18285, 33.40983], [-117.18281, 33.41292], [-117.17805, 33.4133], [-117.17813, 33.40996], [-117.18285, 33.40983]]]} | Restricted Access 2 | 47760 | Rainbow Preserve | 31565 | 7024 | Land to Sea Conservancy 388 | Non Profit 6 | Non Profit - Conservation 12 | http://www.landtosea.org/index.html | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 38.788 | Rainbow Preserve | 0 | Private Conservation 16 | 2 | |
1625 | 1625 | 1624 | {"type": "Polygon", "coordinates": [[[-117.03443, 32.57835], [-117.03338, 32.57837], [-117.03339, 32.57655], [-117.03443, 32.57653], [-117.03443, 32.57835]]]} | No Public Access 3 | 12395 | Newport 5 Preserve | 22731 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 4.919 | Newport 5 Preserve | 0 | Private Conservation 16 | 2 | ||
3308 | 3308 | 3307 | {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} | No Public Access 3 | 46828 | La Cresta Hills Property | 30296 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 12.874 | La Cresta Hills Property | 0 | Private Conservation 16 | 2 | |
3309 | 3309 | 3308 | {"type": "Polygon", "coordinates": [[[-116.86574, 32.79365], [-116.86293, 32.79371], [-116.86299, 32.79622], [-116.86104, 32.79623], [-116.861, 32.79604], [-116.85956, 32.79629], [-116.85947, 32.79387], [-116.85842, 32.79388], [-116.85828, 32.78993], [-116.86564, 32.79012], [-116.86574, 32.79365]]]} | No Public Access 3 | 46829 | Michelson Property | 30297 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 91.593 | Michelson Property | 0 | Private Conservation 16 | 2 | |
3313 | 3313 | 3312 | {"type": "Polygon", "coordinates": [[[-116.86309, 32.80074], [-116.86305, 32.80446], [-116.86307, 32.8054], [-116.85868, 32.80542], [-116.85866, 32.80438], [-116.85442, 32.80443], [-116.85445, 32.80069], [-116.85863, 32.80069], [-116.86309, 32.80074]]]} | No Public Access 3 | 46834 | Ulrich Property | 30302 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 93.312 | Ulrich Property | 0 | Private Conservation 16 | 2 | |
3784 | 3784 | 3783 | {"type": "Polygon", "coordinates": [[[-117.20473, 33.05108], [-117.20464, 33.05469], [-117.20246, 33.0547], [-117.20247, 33.0538], [-117.20029, 33.0538], [-117.20031, 33.05284], [-117.20145, 33.05291], [-117.20206, 33.05299], [-117.20261, 33.05309], [-117.20314, 33.05324], [-117.20356, 33.05338], [-117.20345, 33.05243], [-117.20262, 33.05107], [-117.20473, 33.05108]]]} | No Public Access 3 | 10456 | Bumann Property | 16502 | 3021 | Escondido Creek Conservancy 344 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.escondidocreek.org/ | Non Governmental Organization 10 | 3021 | Escondido Creek Conservancy 341 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 21.404 | Bumann Property | 0 | Private Conservation 16 | 2 | |
4033 | 4033 | 4032 | {"type": "MultiPolygon", "coordinates": [[[[-116.43699, 32.64546], [-116.43674, 32.66028], [-116.42828, 32.6603], [-116.42816, 32.64566], [-116.43699, 32.64546]]], [[[-116.45411, 32.66395], [-116.4541, 32.66484], [-116.44972, 32.66482], [-116.44972, 32.66394], [-116.45411, 32.66395]]]]} | No Public Access 3 | 46971 | La Posta - Cameron Preserve | 30601 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 337.313 | La Posta - Cameron Preserve | 0 | Private Conservation 16 | 2 | |
4191 | 4191 | 4190 | {"type": "Polygon", "coordinates": [[[-117.31392, 33.12069], [-117.31373, 33.12084], [-117.31366, 33.12093], [-117.31361, 33.12104], [-117.31358, 33.12116], [-117.31353, 33.12176], [-117.31334, 33.12176], [-117.31333, 33.12179], [-117.31224, 33.12177], [-117.31177, 33.12178], [-117.3113, 33.12182], [-117.31084, 33.12189], [-117.31038, 33.12197], [-117.30993, 33.12208], [-117.30813, 33.12265], [-117.30811, 33.12068], [-117.31392, 33.12069]]]} | No Public Access 3 | 44875 | Encinas Creek Preserve | 18642 | 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 | San Diego 4 | 18.717 | Encinas Creek Preserve | 0 | Private Conservation 16 | 2 | |
4216 | 4216 | 4215 | {"type": "Polygon", "coordinates": [[[-117.39755, 33.44539], [-117.38308, 33.44537], [-117.36359, 33.44529], [-117.36342, 33.43052], [-117.38823, 33.43027], [-117.389, 33.43025], [-117.38944, 33.43083], [-117.39484, 33.43788], [-117.39755, 33.44539]]]} | Restricted Access 2 | 47758 | Margarita Peak Preserve | 31564 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1165.479 | Margarita Peak Preserve | 0 | Private Conservation 16 | 2 | |
4278 | 4278 | 4277 | {"type": "MultiPolygon", "coordinates": [[[[-116.584, 32.62899], [-116.58381, 32.62893], [-116.58043, 32.62894], [-116.58043, 32.62888], [-116.58398, 32.62886], [-116.584, 32.62899]]], [[[-116.60233, 32.63994], [-116.59384, 32.63985], [-116.59345, 32.63629], [-116.58904, 32.6363], [-116.58933, 32.63975], [-116.585, 32.63974], [-116.58464, 32.63618], [-116.58059, 32.63617], [-116.58043, 32.6291], [-116.58377, 32.62909], [-116.58401, 32.62918], [-116.58433, 32.63245], [-116.58868, 32.6325], [-116.58869, 32.63248], [-116.58834, 32.62897], [-116.59286, 32.62901], [-116.59317, 32.62899], [-116.60121, 32.62905], [-116.6016, 32.63273], [-116.60233, 32.63994]]]]} | Unknown Access 4 | 45247 | San Diego Mountain Ranch | 24856 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 471.918 | San Diego Mtn. Ranch | 0 | Private Conservation 16 | 2 | |
5393 | 5393 | 5392 | {"type": "Polygon", "coordinates": [[[-116.80676, 32.87373], [-116.80265, 32.87367], [-116.8023, 32.85874], [-116.80627, 32.85879], [-116.80663, 32.86644], [-116.80676, 32.87373]]]} | Restricted Access 2 | 47898 | Peutz Creek Preserve | 31861 | 3206 | San Diego River Park Foundation 804 | Non Profit 6 | Non Profit - Conservation 12 | http://sandiegoriver.org/ | Non Governmental Organization 10 | 3206 | San Diego River Park Foundation 784 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 156.957 | Peutz Creek 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]);