units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
212 rows where ACCESS_TYP = 1 and DES_TP = 16 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Wildlands Conservancy 20
- Truckee Donner Land Trust 19
- Center for Natural Lands Management 9
- Fallbrook Land Conservancy 9
- Coastside Land Trust 8
- Mojave Desert Land Trust 7
- Land Trust of Santa Cruz County 6
- Ojai Valley Land Conservancy 6
- The Nature Conservancy 5
- Sonoma Land Trust 5
- Friends of the Desert Mountains 5
- Tuleyome 5
- Del Monte Forest Foundation 5
- Bear Yuba Land Trust 4
- Sierra Foothill Conservancy 4
- Mendocino Land Trust 4
- Wilderness Land Trust 4
- Feather River Land Trust 4
- Big Sur Land Trust 3
- Eastern Sierra Land Trust 3
- Trinidad Coastal Land Trust 3
- San Diego River Park Foundation 3
- Save the Redwoods League 2
- John Muir Land Trust 2
- Land Trust of Napa County 2
- Marin Audubon Society 2
- Land Trust for Santa Barbara County 2
- The Habitat Trust 2
- Morro Coast Audubon Society 2
- San Joaquin River Parkway and Conservation Trust 2
- …
MNG_AG_TYP 3
DES_TP 1
- Private Conservation · 204 ✖
ACCESS_TYP 1
- Open Access · 204 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
642 | 642 | 641 | {"type": "Polygon", "coordinates": [[[-116.71987, 34.0913], [-116.71976, 34.10633], [-116.71018, 34.10612], [-116.70251, 34.10579], [-116.70264, 34.09125], [-116.71987, 34.0913]]]} | Open Access 1 | 2751 | San Gorgonio Wilderness | 13189 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 646.722 | San Gorgonio Wilderness | 0 | Private Conservation 16 | 2 | |
658 | 658 | 657 | {"type": "Polygon", "coordinates": [[[-122.1718, 37.99251], [-122.16269, 37.99253], [-122.16267, 37.98898], [-122.16654, 37.98899], [-122.16655, 37.98895], [-122.17178, 37.98893], [-122.1718, 37.99251]]]} | Open Access 1 | 3251 | Gustin | 19572 | 3045 | John Muir Land Trust 108 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 78.179 | Gustin | 2000 | Private Conservation 16 | 2 | |
707 | 707 | 706 | {"type": "Polygon", "coordinates": [[[-122.48085, 38.56982], [-122.46762, 38.57004], [-122.46756, 38.56696], [-122.48078, 38.56638], [-122.48085, 38.56982]]]} | Open Access 1 | 3979 | Bruchman Cheyney Preserve | 16448 | 3035 | Land Trust of Napa County 140 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | Napa 11 | 103.06 | Bruchman Cheyney Preserve | 0 | Private Conservation 16 | 2 | |
1024 | 1024 | 1023 | {"type": "Polygon", "coordinates": [[[-116.97112, 34.21832], [-116.97109, 34.22243], [-116.96235, 34.22226], [-116.96241, 34.21858], [-116.96742, 34.21867], [-116.96848, 34.21898], [-116.9687, 34.219], [-116.96904, 34.21869], [-116.96981, 34.21871], [-116.97112, 34.21832]], [[-116.96651, 34.222], [-116.96714, 34.22186], [-116.96698, 34.22134], [-116.96634, 34.22148], [-116.96651, 34.222]]]} | Open Access 1 | 47578 | Bluff Lake Reserve | 31304 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_blufflake.html | San Bernardino 22 | 80.37 | Bluff Lake Reserve | 0 | Private Conservation 16 | 2 |
1132 | 1132 | 1131 | {"type": "MultiPolygon", "coordinates": [[[[-119.60987, 37.02875], [-119.60983, 37.03609], [-119.60539, 37.036], [-119.60535, 37.04334], [-119.60094, 37.04317], [-119.60084, 37.03959], [-119.59636, 37.03951], [-119.58765, 37.03928], [-119.58772, 37.03206], [-119.58351, 37.03196], [-119.58349, 37.02828], [-119.60987, 37.02875]]], [[[-119.62016, 36.98167], [-119.62, 36.99254], [-119.61087, 36.99257], [-119.6108, 36.99615], [-119.60629, 36.99622], [-119.60626, 36.99977], [-119.60708, 37.01077], [-119.6112, 37.01077], [-119.61269, 37.0108], [-119.61253, 37.018], [-119.61704, 37.01804], [-119.61691, 37.02165], [-119.61244, 37.0217], [-119.61235, 37.02519], [-119.58355, 37.02477], [-119.58357, 37.01186], [-119.58414, 37.01169], [-119.58501, 37.01105], [-119.58616, 37.01006], [-119.58661, 37.00935], [-119.58687, 37.00859], [-119.58662, 37.00759], [-119.58576, 37.00655], [-119.58532, 37.00552], [-119.58473, 37.00419], [-119.58457, 37.00356], [-119.58521, 37.00227], [-119.58589, 37.00131], [-119.59153, 36.99748], [-119.59335, 36.99641], [-119.59451, 36.99569], [-119.59582, 36.99434], [-119.59686, 36.99207], [-119.5976, 36.98957], [-119.59804, 36.98885], [-119.59803, 36.98884], [-119.59273, 36.98882], [-119.59281, 36.98514], [-119.60182, 36.9852], [-119.60183, 36.98873], [-119.61064, 36.98882], [-119.61075, 36.98167], [-119.61096, 36.97803], [-119.61546, 36.97798], [-119.61544, 36.98162], [-119.62016, 36.98167]]], [[[-119.63971, 37.01813], [-119.62608, 37.01809], [-119.62622, 37.02171], [-119.62287, 37.02174], [-119.62251, 37.01075], [-119.6396, 37.01079], [-119.63971, 37.01813]]]]} | Open Access 1 | 6621 | Ruth McKenzie Table Mountain Preserve | 29279 | 3077 | Sierra Foothill Conservancy 323 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sierrafoothill.org/ | Non Governmental Organization 10 | 3077 | Sierra Foothill Conservancy 320 | Non Profit 6 | Non Profit - Land Trust 10 | http://awww.sierrafoothill.org/index.php/land/preserves/mckenzie-preser/ | Fresno 9 | 3330.9 | Ruth McKenzie Table Mtn. Preserve | 0 | Private Conservation 16 | 2 |
1180 | 1180 | 1179 | {"type": "Polygon", "coordinates": [[[-116.65884, 33.99782], [-116.65448, 33.99783], [-116.65444, 33.99061], [-116.65008, 33.99061], [-116.65011, 33.97985], [-116.65224, 33.97985], [-116.65226, 33.98164], [-116.65655, 33.98163], [-116.65655, 33.97984], [-116.65881, 33.97983], [-116.65881, 33.9906], [-116.65884, 33.99782]]]} | Open Access 1 | 47599 | Whitewater Preserve | 31277 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_whitewater.html | Riverside 10 | 297.799 | Whitewater Preserve | 0 | 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 |
1281 | 1281 | 1280 | {"type": "Polygon", "coordinates": [[[-117.5581, 34.18262], [-117.55072, 34.18265], [-117.5507, 34.17938], [-117.55806, 34.1794], [-117.5581, 34.18262]]]} | Open Access 1 | 9910 | Richland Mitigation | 24337 | 3089 | The Habitat Trust 340 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3089 | The Habitat Trust 337 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 60.516 | Richland Mitigation | 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 |
2003 | 2003 | 2002 | {"type": "Polygon", "coordinates": [[[-116.65655, 33.97984], [-116.65486, 33.97985], [-116.65485, 33.97777], [-116.65654, 33.97777], [-116.65655, 33.97984]]]} | Open Access 1 | 15336 | Whitewater Canyon | 4022 | 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 | http://www.wildlandsconservancy.org/preserve_whitewater.html | Riverside 10 | 8.883 | Whitewater Canyon | 0 | Private Conservation 16 | 2 |
2004 | 2004 | 2003 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | 16907 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 468 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | San Luis Obispo 1 | 0.256 | Audubon Overlook | 0 | Private Conservation 16 | 2 | |
2240 | 2240 | 2239 | {"type": "Polygon", "coordinates": [[[-123.69334, 38.89646], [-123.69092, 38.89742], [-123.68781, 38.89884], [-123.68619, 38.8973], [-123.6853, 38.89648], [-123.68339, 38.89464], [-123.68665, 38.89209], [-123.68674, 38.89243], [-123.687, 38.89272], [-123.68732, 38.89305], [-123.6881, 38.8935], [-123.68935, 38.89412], [-123.68975, 38.89423], [-123.69062, 38.89436], [-123.69119, 38.89451], [-123.69155, 38.89485], [-123.69225, 38.89544], [-123.69266, 38.89574], [-123.69321, 38.89625], [-123.69334, 38.89646]]]} | Open Access 1 | 47883 | Pelican Bluffs Reserve | 31827 | 3128 | Mendocino Land Trust 500 | Non Profit 6 | Non Profit - Land Trust 10 | http://mendocinolandtrust.org/ | Non Governmental Organization 10 | 3128 | Mendocino Land Trust 492 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.mendocinolandtrust.org/explore/explore-our-lands/pelican-bluffs/ | Mendocino 24 | 76.551 | Pelican Bluffs Reserve | 2013 | Private Conservation 16 | 2 |
2300 | 2300 | 2299 | {"type": "Polygon", "coordinates": [[[-119.71423, 34.41147], [-119.71286, 34.41261], [-119.71211, 34.41205], [-119.71252, 34.41167], [-119.71232, 34.41149], [-119.71267, 34.41116], [-119.7132, 34.41071], [-119.71401, 34.41104], [-119.71423, 34.41147]]]} | Open Access 1 | 16932 | Honda Valley Park - Community Environmental Council | 20066 | 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 | 5.43 | Honda Valley Park - Community Environmental Council | 0 | Private Conservation 16 | 2 | |
2818 | 2818 | 2817 | {"type": "Polygon", "coordinates": [[[-122.11574, 38.47849], [-122.11574, 38.47849], [-122.11078, 38.47847], [-122.1109, 38.47791], [-122.11112, 38.47745], [-122.11138, 38.47716], [-122.11159, 38.47699], [-122.11178, 38.47681], [-122.11211, 38.47637], [-122.11245, 38.47602], [-122.11269, 38.47575], [-122.11301, 38.4753], [-122.1131, 38.47522], [-122.11313, 38.47502], [-122.11317, 38.47487], [-122.1155, 38.47489], [-122.11574, 38.47849]]]} | Open Access 1 | 48612 | Huber Ranch | 33327 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Napa 11 | 32.139 | Huber Ranch | 2018 | Private Conservation 16 | 2 |
2819 | 2819 | 2818 | {"type": "Polygon", "coordinates": [[[-122.113, 38.47524], [-122.1129, 38.47543], [-122.11277, 38.47564], [-122.11254, 38.47593], [-122.11209, 38.4764], [-122.11176, 38.47685], [-122.11121, 38.47734], [-122.11105, 38.47756], [-122.11094, 38.47777], [-122.11086, 38.47808], [-122.11081, 38.4784], [-122.11074, 38.47867], [-122.09694, 38.47855], [-122.09695, 38.47505], [-122.113, 38.47524]]]} | Open Access 1 | 48613 | Huber Ranch | 33327 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Solano 26 | 122.632 | Huber Ranch | 2018 | Private Conservation 16 | 2 |
2820 | 2820 | 2819 | {"type": "Polygon", "coordinates": [[[-122.5547, 39.07288], [-122.54077, 39.07244], [-122.52192, 39.07296], [-122.51717, 39.07356], [-122.51634, 39.05553], [-122.52099, 39.05524], [-122.52083, 39.05168], [-122.53935, 39.05086], [-122.54017, 39.06525], [-122.54047, 39.06885], [-122.55439, 39.06917], [-122.5547, 39.07288]]]} | Open Access 1 | 48614 | Silver Spur Ranch | 33328 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Lake 40 | 1270.865 | Silver Spur Ranch | 2016 | Private Conservation 16 | 2 |
2888 | 2888 | 2887 | {"type": "Polygon", "coordinates": [[[-119.79781, 38.30883], [-119.79777, 38.30983], [-119.79674, 38.30981], [-119.79629, 38.30945], [-119.79631, 38.30886], [-119.79781, 38.30883]]]} | Open Access 1 | 48635 | Stanislaus National Forest | 33338 | 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 | 3.299 | Stanislaus NF | 0 | Private Conservation 16 | 2 |
3113 | 3113 | 3112 | {"type": "Polygon", "coordinates": [[[-122.87912, 39.02968], [-122.87717, 39.0297], [-122.87715, 39.02211], [-122.87898, 39.02212], [-122.87912, 39.02968]]]} | Open Access 1 | 48007 | Melo Property | 32436 | 3264 | Lake County Land Trust 586 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lakecountylandtrust.org/index.htm | Non Governmental Organization 10 | 3264 | Lake County Land Trust 576 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lakecountylandtrust.org/melo-property.html | Lake 40 | 34.018 | Melo Property | 0 | Private Conservation 16 | 2 |
3238 | 3238 | 3237 | {"type": "Polygon", "coordinates": [[[-117.38418, 35.31678], [-117.38418, 35.33147], [-117.36716, 35.33147], [-117.36717, 35.31677], [-117.38418, 35.31678]]]} | Open Access 1 | 29084 | The Wildlands Conservancy | 13191 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 623.3 | The Wildlands Conservancy | 0 | Private Conservation 16 | 2 | |
3239 | 3239 | 3238 | {"type": "MultiPolygon", "coordinates": [[[[-118.07831, 35.73372], [-118.07746, 35.73373], [-118.07736, 35.73199], [-118.07729, 35.73024], [-118.07772, 35.73024], [-118.07792, 35.73066], [-118.07842, 35.7317], [-118.0786, 35.73222], [-118.07864, 35.73276], [-118.07855, 35.73326], [-118.07831, 35.73372]]], [[[-118.08187, 35.73369], [-118.07852, 35.73372], [-118.07873, 35.73331], [-118.07883, 35.73277], [-118.07879, 35.7322], [-118.07861, 35.73165], [-118.0781, 35.73061], [-118.07794, 35.73024], [-118.08182, 35.73018], [-118.08187, 35.73369]]]]} | Open Access 1 | 29086 | Wilderness Land Trust | 27509 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | Kern 36 | 37.142 | Wilderness Land Trust | 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]);