units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
102 rows where ACCESS_TYP = 2 and COUNTY = 4 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, MNG_AG_LEV, PARK_URL, YR_EST, GAP_STS
MNG_AGENCY >30
- Home Owners Association - Unknown Name 27
- San Diego, City of 10
- California Department of Fish and Wildlife 10
- Carlsbad, City of 6
- University of California 4
- San Diego River Park Foundation 4
- United States Fish and Wildlife Service 3
- Oceanside, City of 3
- San Diego, County of 3
- San Diego State University 3
- Encinitas, City of 2
- Coronado, City of 2
- Fallbrook Land Conservancy 2
- Nonprofit Organization - Unknown 2
- Private Landowner 2
- United States Bureau of Land Management 1
- California Department of Parks and Recreation 1
- National City, City of 1
- The Nature Conservancy 1
- El Cajon, City of 1
- Escondido, City of 1
- Chula Vista, City of 1
- Poway, City of 1
- Petco Park Owner 1
- United States Department of Defense 1
- The Conservation Fund - California 1
- Borrego Water District 1
- San Diego Audubon Society 1
- Anza-Borrego Foundation 1
- Bay Club 1
- …
DES_TP 17
- Private Recreation or Education 27
- State Conservation Area 17
- Local Recreation Area 16
- Local Park 11
- Private Conservation 11
- Local Conservation Area 5
- National Wildlife Refuge 3
- Private Other or Unknown 3
- Local Other or Unknown 1
- State Park 1
- Recreation Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 12
ACCESS_TYP 1
- Restricted Access · 102 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
15551 | 15551 | 15550 | {"type": "Polygon", "coordinates": [[[-117.19604, 33.42917], [-117.19589, 33.43216], [-117.18882, 33.43217], [-117.18246, 33.43226], [-117.18253, 33.4283], [-117.19167, 33.42815], [-117.19556, 33.42806], [-117.19537, 33.42845], [-117.19525, 33.42932], [-117.19604, 33.42917]]]} | Restricted Access 2 | 48641 | Santa Margarita Ecological Reserve | 33342 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 135.503 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
11517 | 11517 | 11516 | {"type": "Polygon", "coordinates": [[[-117.24714, 33.20982], [-117.24712, 33.21018], [-117.2451, 33.21017], [-117.2451, 33.20897], [-117.24589, 33.20902], [-117.24596, 33.20884], [-117.24679, 33.20904], [-117.24684, 33.20979], [-117.24714, 33.20982]]]} | Restricted Access 2 | 48224 | Linda Rhoades Recreation Center | 32840 | 3385 | Educational Enrichment Systems Incorporated 983 | Non Profit 6 | Non Profit - Other 22 | http://www.educ-enrichment.org/ | Non Governmental Organization 10 | 2426 | Vista Unified School District 946 | Special District 4 | School District 21 | San Diego 4 | 5.644 | Linda Rhoades Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
10049 | 10049 | 10048 | {"type": "MultiPolygon", "coordinates": [[[[-117.26914, 33.02902], [-117.26913, 33.0296], [-117.26899, 33.02991], [-117.26909, 33.03022], [-117.26885, 33.03029], [-117.26858, 33.03041], [-117.26855, 33.0298], [-117.26856, 33.02948], [-117.26853, 33.02912], [-117.26808, 33.02913], [-117.26785, 33.02908], [-117.26768, 33.02914], [-117.26749, 33.02914], [-117.26738, 33.02924], [-117.26729, 33.02924], [-117.26718, 33.02911], [-117.26658, 33.02911], [-117.26658, 33.02901], [-117.26914, 33.02902]]], [[[-117.27508, 33.02965], [-117.27472, 33.03002], [-117.27367, 33.0309], [-117.27329, 33.03127], [-117.27321, 33.03137], [-117.27294, 33.03116], [-117.2722, 33.03112], [-117.27168, 33.03165], [-117.27127, 33.03162], [-117.271, 33.03162], [-117.27071, 33.03162], [-117.27045, 33.03165], [-117.27047, 33.03186], [-117.27026, 33.03188], [-117.26999, 33.03194], [-117.26886, 33.0323], [-117.26868, 33.03235], [-117.26842, 33.03169], [-117.26847, 33.03152], [-117.26853, 33.03152], [-117.26857, 33.03149], [-117.26863, 33.03154], [-117.26886, 33.03151], [-117.26888, 33.0314], [-117.26876, 33.03097], [-117.26869, 33.03054], [-117.26905, 33.0304], [-117.26924, 33.03035], [-117.26949, 33.03033], [-117.26952, 33.03055], [-117.27029, 33.03053], [-117.2716, 33.03039], [-117.27158, 33.03018], [-117.27179, 33.03015], [-117.27186, 33.03036], [-117.27204, 33.03032], [-117.27231, 33.03016], [-117.2725, 33.02996], [-117.27266, 33.02969], [-117.27314, 33.02973], [-117.27368, 33.02972], [-117.27382, 33.02962], [-117.2738, 33.02902], [-117.27506, 33.02901], [-117.27508, 33.02965]]]]} | Restricted Access 2 | 17378 | Park Place Open Space Preserve | 31476 | 7019 | Park Place Homeowners Association 942 | Private 7 | Home Owners Association 16 | http://parkplace.ebmcportals.net/ | Private 14 | 7019 | Park Place Homeowners Association 914 | Private 7 | Home Owners Association 15 | San Diego 4 | 24.41 | Park Place OSP | None 866 | |||
7621 | 7621 | 7620 | {"type": "Polygon", "coordinates": [[[-117.28518, 33.02562], [-117.28529, 33.02578], [-117.28529, 33.02582], [-117.28512, 33.0259], [-117.28506, 33.02592], [-117.28492, 33.02592], [-117.28455, 33.02589], [-117.28394, 33.02578], [-117.28407, 33.02539], [-117.28421, 33.02491], [-117.28411, 33.02487], [-117.28368, 33.02416], [-117.2841, 33.02397], [-117.28416, 33.02397], [-117.28518, 33.02562]]]} | Restricted Access 2 | 47635 | George Berkich Park | 31614 | 2412 | Cardiff School District 875 | Special District 4 | School District 14 | http://cardiffschools.com/ | Special District 4 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.697 | George Berkich Park | 0 | Local Park 2 | 4 | |
6677 | 6677 | 6676 | {"type": "Polygon", "coordinates": [[[-116.5326, 32.93414], [-116.53245, 32.94818], [-116.51564, 32.94847], [-116.51595, 32.93405], [-116.5326, 32.93414]]]} | Restricted Access 2 | 47524 | Anza-Borrego Desert State Park | 31229 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | San Diego 4 | 609.836 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
15529 | 15529 | 15528 | {"type": "MultiPolygon", "coordinates": [[[[-116.37339, 33.20669], [-116.37126, 33.20669], [-116.3712, 33.20314], [-116.369, 33.20315], [-116.36895, 33.19964], [-116.37329, 33.19965], [-116.37339, 33.20669]]], [[[-116.36684, 33.20585], [-116.36473, 33.20589], [-116.36486, 33.21146], [-116.36444, 33.2114], [-116.364, 33.21137], [-116.36273, 33.21136], [-116.36269, 33.21043], [-116.36051, 33.21041], [-116.36039, 33.20494], [-116.3647, 33.20498], [-116.36682, 33.20495], [-116.36684, 33.20585]]]]} | Restricted Access 2 | 49075 | Unnamed site - Anza-Borrego Foundation | 33775 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | https://theabf.org/ | San Diego 4 | 128.692 | 2019 | Private Other or Unknown 399 | 4 | |
6275 | 6275 | 6274 | {"type": "Polygon", "coordinates": [[[-116.88449, 32.9177], [-116.88442, 32.91819], [-116.88434, 32.91843], [-116.88422, 32.91866], [-116.88382, 32.91883], [-116.88374, 32.91886], [-116.88364, 32.91887], [-116.88353, 32.91892], [-116.88342, 32.919], [-116.88329, 32.91915], [-116.88323, 32.91919], [-116.88322, 32.91923], [-116.88261, 32.91942], [-116.88176, 32.91965], [-116.88175, 32.91967], [-116.88048, 32.92002], [-116.87996, 32.92023], [-116.87923, 32.92062], [-116.87894, 32.92081], [-116.87862, 32.92107], [-116.8761, 32.92338], [-116.87568, 32.92378], [-116.87552, 32.92398], [-116.87355, 32.92403], [-116.87354, 32.92387], [-116.87288, 32.92386], [-116.8671, 32.92734], [-116.86707, 32.92253], [-116.86293, 32.92261], [-116.8629, 32.91899], [-116.85859, 32.91904], [-116.84121, 32.91914], [-116.84119, 32.9155], [-116.85857, 32.91537], [-116.85906, 32.91535], [-116.86072, 32.91536], [-116.86073, 32.91535], [-116.86072, 32.91264], [-116.86927, 32.9126], [-116.87363, 32.91259], [-116.87362, 32.91458], [-116.88181, 32.91446], [-116.88184, 32.91632], [-116.88279, 32.91634], [-116.88275, 32.91768], [-116.88449, 32.9177]]]} | Restricted Access 2 | 1366 | Silverwood Wildlife Sanctuary | 25502 | 3064 | San Diego Audubon Society 831 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sandiegoaudubon.org/ | Non Governmental Organization 10 | 3064 | San Diego Audubon Society 811 | Non Profit 6 | Non Profit - Conservation 12 | http://www.sandiegoaudubon.org/our-work/sanctuaries/silverwood-wildlife-sanctuary | San Diego 4 | 709.224 | Silverwood Wildlife Sanctuary | 0 | Private Conservation 16 | 2 |
5896 | 5896 | 5895 | {"type": "Polygon", "coordinates": [[[-117.06009, 32.76351], [-117.05994, 32.76363], [-117.05895, 32.76366], [-117.05892, 32.76238], [-117.06004, 32.76235], [-117.06009, 32.76351]]]} | Restricted Access 2 | 46816 | Clay Elementary School Park | 31950 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.701 | Clay Elementary School Park | 0 | Local Park 2 | 4 | |
14205 | 14205 | 14204 | {"type": "Polygon", "coordinates": [[[-117.0489, 32.67824], [-117.04772, 32.67864], [-117.04697, 32.67911], [-117.04638, 32.67955], [-117.04603, 32.67827], [-117.04596, 32.67806], [-117.04688, 32.67781], [-117.04697, 32.6778], [-117.04699, 32.67778], [-117.04668, 32.67615], [-117.04831, 32.67614], [-117.04833, 32.67636], [-117.04857, 32.67756], [-117.0487, 32.67789], [-117.0489, 32.67824]]]} | Restricted Access 2 | 44066 | Penn Athletic Field | 31636 | 2310 | San Diego Unified School District 820 | Special District 4 | School District 14 | http://www.sandi.net/sandi | Special District 4 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 13.867 | Penn Athletic Field | 0 | Local Recreation Area 3 | 4 | |
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 | |
5394 | 5394 | 5393 | {"type": "Polygon", "coordinates": [[[-116.66647, 32.96362], [-116.66615, 32.96362], [-116.66613, 32.96401], [-116.66421, 32.96406], [-116.66329, 32.96512], [-116.66112, 32.96511], [-116.6611, 32.96361], [-116.66364, 32.96362], [-116.66451, 32.96339], [-116.66476, 32.96328], [-116.66507, 32.96309], [-116.66533, 32.96298], [-116.66555, 32.963], [-116.66584, 32.96322], [-116.66599, 32.96323], [-116.66612, 32.96329], [-116.66623, 32.96337], [-116.6663, 32.96347], [-116.66644, 32.96353], [-116.66647, 32.96362]]]} | Restricted Access 2 | 47899 | Boulder Creek Preserve | 31862 | 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 | 15.037 | Boulder Creek Preserve | 0 | Private Conservation 16 | 2 | |
5395 | 5395 | 5394 | {"type": "Polygon", "coordinates": [[[-116.66092, 33.0459], [-116.66084, 33.04923], [-116.6651, 33.04926], [-116.66506, 33.05292], [-116.65653, 33.05293], [-116.65227, 33.05291], [-116.65232, 33.04918], [-116.65233, 33.04202], [-116.64727, 33.04204], [-116.64767, 33.04131], [-116.64771, 33.04121], [-116.64771, 33.0411], [-116.64766, 33.04089], [-116.64766, 33.04078], [-116.6477, 33.04058], [-116.64766, 33.04037], [-116.64769, 33.04027], [-116.64776, 33.04019], [-116.64805, 33.03994], [-116.64812, 33.03986], [-116.64816, 33.03976], [-116.64815, 33.03965], [-116.64798, 33.03931], [-116.64799, 33.03924], [-116.64802, 33.03918], [-116.64825, 33.03902], [-116.6483, 33.03894], [-116.65227, 33.03896], [-116.65257, 33.03929], [-116.65264, 33.03932], [-116.65433, 33.03932], [-116.65434, 33.04021], [-116.65646, 33.04022], [-116.65648, 33.04229], [-116.66092, 33.04229], [-116.66092, 33.0459]]]} | Restricted Access 2 | 47900 | Eagle Peak Ranch | 31863 | 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 | 335.398 | Eagle Peak Ranch | 0 | Private Conservation 16 | 2 | |
5890 | 5890 | 5889 | {"type": "Polygon", "coordinates": [[[-116.83991, 32.9052], [-116.83982, 32.91649], [-116.8236, 32.91642], [-116.82363, 32.90747], [-116.82362, 32.90223], [-116.83778, 32.90156], [-116.83777, 32.90524], [-116.83991, 32.9052]]]} | Restricted Access 2 | 46780 | El Cajon Mountain Preserve | 31859 | 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 | 588.392 | El Cajon Mtn. Preserve | 0 | Private Conservation 16 | 2 | |
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} | Restricted Access 2 | 1208 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 638.799 | 0 | Private Other or Unknown 399 | 4 | |||
4470 | 4470 | 4469 | {"type": "Polygon", "coordinates": [[[-116.37329, 33.19965], [-116.36458, 33.19964], [-116.36453, 33.19257], [-116.37324, 33.19257], [-116.37329, 33.19965]]]} | Restricted Access 2 | 1194 | Unnamed site - Borrego Water District | 28622 | 2008 | Borrego Water District 764 | Special District 4 | Water District 13 | http://www.borregowd.org/ | Special District 4 | 2008 | Borrego Water District 745 | Special District 4 | Water District 13 | San Diego 4 | 157.534 | 0 | Local Other or Unknown 14 | 4 | ||
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside School Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);