units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
100 rows where COUNTY = 4 and MNG_AG_LEV = 6
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY 22
- The Environmental Trust 21
- Fallbrook Land Conservancy 15
- Endangered Habitats Conservancy 14
- Center for Natural Lands Management 13
- San Diego River Park Foundation 7
- San Dieguito River Valley Land Conservancy 6
- Back Country Land Trust 4
- The Nature Conservancy 3
- Escondido Creek Conservancy 2
- Nonprofit Organization - Unknown 2
- Anza-Borrego Foundation 2
- San Elijo Lagoon Conservancy 1
- National Audubon Society 1
- Boys and Girls Clubs of South County 1
- The Conservation Fund - California 1
- San Diego Humane Society and SPCA 1
- San Diego Audubon Society 1
- Foundation for Preservation of Mt. Helix Nature Theatre 1
- San Diego Zoo Global 1
- Batiquitos Lagoon Foundation 1
- Rancho Santa Fe Community Foundation 1
- Volcan Mountain Preserve Foundation 1
DES_TP 6
ACCESS_TYP 4
MNG_AG_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
1523 | 1523 | 1522 | {"type": "Polygon", "coordinates": [[[-116.78494, 33.12411], [-116.78019, 33.12414], [-116.7802, 33.12031], [-116.7849, 33.12029], [-116.78494, 33.12411]]]} | Open Access 1 | 12843 | Corral Mountain Open Space | 17655 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 46.202 | Corral Mtn. OS | 0 | Private Recreation or Education 65 | 4 | |
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 | ||
3140 | 3140 | 3139 | {"type": "MultiPolygon", "coordinates": [[[[-116.60256, 33.11613], [-116.59824, 33.115], [-116.59824, 33.11394], [-116.60131, 33.11356], [-116.60184, 33.11283], [-116.60185, 33.1129], [-116.6019, 33.11298], [-116.60231, 33.11337], [-116.6024, 33.11349], [-116.60246, 33.1136], [-116.60259, 33.11401], [-116.60286, 33.1151], [-116.60287, 33.11531], [-116.60283, 33.11554], [-116.60272, 33.11583], [-116.60256, 33.11613]]], [[[-116.60241, 33.11223], [-116.60228, 33.11229], [-116.6022, 33.11232], [-116.60227, 33.11223], [-116.60241, 33.11223]]]]} | No Public Access 3 | 25800 | San Dieguito River Park | 24870 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 22.717 | San Dieguito River Park | 0 | Private Recreation or Education 65 | 4 | |
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 | |
3568 | 3568 | 3567 | {"type": "Polygon", "coordinates": [[[-117.12444, 32.57552], [-117.12422, 32.57552], [-117.12425, 32.57652], [-117.12305, 32.57652], [-117.12307, 32.5737], [-117.12357, 32.57366], [-117.12388, 32.57374], [-117.12399, 32.57387], [-117.12401, 32.57408], [-117.12442, 32.57408], [-117.12444, 32.57552]]]} | Open Access 1 | 439 | Imperial Beach Sports Park | 31474 | 1143 | Imperial Beach, City of 630 | City 2 | City Agency 2 | http://www.imperialbeachca.gov/index.asp?Type=B_BASIC&SEC={9F232DF8-5366-4BA2-A4B8-8795196F6D81} | City 2 | 7018 | Boys and Girls Clubs of South County 649 | Non Profit 6 | Non Profit - Other 20 | http://www.bgcscounty.org/portal/home | San Diego 4 | 8.985 | Imperial Beach Sports Park | None 298 | ||
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 |
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]);