units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
517 rows where MNG_AG_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
DES_TP >30
- National Forest 96
- National Public Lands 75
- National Wildlife Refuge 70
- Recreation Management Area 61
- National Recreation Area 34
- National Park 26
- Resource Management Area 26
- National Monument or Landmark 24
- Federal Other or Unknown 24
- Conservation Area 14
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Research or Educational Area 3
- None 1
- None 1
- None 1
- None 1
- National Lakeshore or Seashore 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
LAYER 10 ✖
MNG_AGENCY 9
- United States Bureau of Land Management 121
- United States Forest Service 111
- United States National Park Service 89
- United States Fish and Wildlife Service 82
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- Other Federal 19
- United States Coast Guard 8
- United States Department of Defense 6
ACCESS_TYP 4
- Open Access 397
- Restricted Access 81
- No Public Access 33
- Unknown Access 6
MNG_AG_TYP 1
- Federal Agency · 517 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3755 | 3755 | 3754 | {"type": "Polygon", "coordinates": [[[-122.43372, 38.14591], [-122.43337, 38.1458], [-122.43311, 38.14563], [-122.4322, 38.14524], [-122.43246, 38.1453], [-122.43352, 38.14575], [-122.43372, 38.14591]]]} | Open Access 1 | 461 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 0.21 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
16806 | 16806 | 16805 | {"type": "Polygon", "coordinates": [[[-119.29135, 36.90366], [-119.29138, 36.90381], [-119.29133, 36.904], [-119.29126, 36.90411], [-119.29101, 36.904], [-119.29089, 36.90383], [-119.29093, 36.90363], [-119.29103, 36.90354], [-119.29125, 36.90356], [-119.29135, 36.90366]]]} | Open Access 1 | 15864 | Trimmer Recreation Area | 26537 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Fresno 9 | 0.497 | Trimmer Rec. Area | 0 | Recreation Management Area 49 | 4 | |
10429 | 10429 | 10428 | {"type": "MultiPolygon", "coordinates": [[[[-122.50952, 37.78622], [-122.50946, 37.78624], [-122.50942, 37.78624], [-122.5094, 37.78621], [-122.5094, 37.78617], [-122.50943, 37.78614], [-122.50947, 37.78613], [-122.50952, 37.78618], [-122.50952, 37.78622]]], [[[-122.50967, 37.78577], [-122.50964, 37.78591], [-122.50955, 37.78593], [-122.5095, 37.78587], [-122.50949, 37.78581], [-122.50952, 37.78571], [-122.50956, 37.78569], [-122.50967, 37.78577]]], [[[-122.51005, 37.79251], [-122.50996, 37.79259], [-122.50989, 37.79258], [-122.50985, 37.79254], [-122.50986, 37.79246], [-122.50996, 37.79242], [-122.51003, 37.79245], [-122.51005, 37.79251]]], [[[-122.51015, 37.78577], [-122.51015, 37.78581], [-122.51012, 37.78585], [-122.51007, 37.78584], [-122.51004, 37.78581], [-122.51006, 37.78574], [-122.51009, 37.78573], [-122.51015, 37.78577]]], [[[-122.51065, 37.7927], [-122.51064, 37.79277], [-122.51057, 37.79283], [-122.51043, 37.79288], [-122.51032, 37.79285], [-122.51026, 37.79282], [-122.51022, 37.79277], [-122.51022, 37.79266], [-122.51024, 37.79261], [-122.51029, 37.79258], [-122.51043, 37.79253], [-122.51051, 37.79255], [-122.51058, 37.7926], [-122.51065, 37.7927]]], [[[-122.51076, 37.78721], [-122.51058, 37.78729], [-122.51047, 37.78729], [-122.51042, 37.78724], [-122.51067, 37.78714], [-122.51074, 37.78716], [-122.51076, 37.78721]]], [[[-122.51366, 37.78341], [-122.51355, 37.7835], [-122.51351, 37.78345], [-122.5135, 37.78334], [-122.51351, 37.78328], [-122.51358, 37.78326], [-122.51362, 37.78328], [-122.51366, 37.78335], [-122.51366, 37.78341]]], [[[-122.5141, 37.78274], [-122.514, 37.78273], [-122.51389, 37.78266], [-122.51387, 37.78262], [-122.51392, 37.78256], [-122.51398, 37.78256], [-122.51409, 37.78265], [-122.5141, 37.78274]]], [[[-122.514, 37.78294], [-122.514, 37.78296], [-122.51395, 37.78297], [-122.51389, 37.78295], [-122.51387, 37.7829], [-122.51388, 37.78288], [-122.51394, 37.78287], [-122.514, 37.78294]]], [[[-122.51433, 37.78268], [-122.51431, 37.78272], [-122.51425, 37.78272], [-122.51421, 37.78267], [-122.51425, 37.7826], [-122.51429, 37.78261], [-122.51433, 37.78268]]]]} | Open Access 1 | 21478 | California Coastal National Monument | 16715 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Francisco 13 | 0.695 | California Coastal NM | 2000 | National Monument or Landmark 80 | 3 | |
5413 | 5413 | 5412 | {"type": "MultiPolygon", "coordinates": [[[[-118.22858, 33.88759], [-118.22857, 33.88759], [-118.22835, 33.88727], [-118.22846, 33.88739], [-118.22858, 33.88759]]], [[[-118.24226, 33.90419], [-118.24209, 33.90423], [-118.24193, 33.90397], [-118.24191, 33.9036], [-118.24216, 33.90405], [-118.24226, 33.90419]]], [[[-118.24858, 33.91176], [-118.24841, 33.91176], [-118.24735, 33.91049], [-118.24755, 33.9105], [-118.24857, 33.91171], [-118.24858, 33.91176]]]]} | Open Access 1 | 7202 | Compton Creek & Bike Path | 17571 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 0.849 | Compton Creek & Bike Path | 0 | Recreation Management Area 49 | 4 | |
5184 | 5184 | 5183 | {"type": "Polygon", "coordinates": [[[-122.00444, 36.96745], [-122.00387, 36.96749], [-122.00391, 36.96788], [-122.00368, 36.96786], [-122.00366, 36.96704], [-122.004, 36.96702], [-122.00401, 36.96714], [-122.00434, 36.96712], [-122.00444, 36.96745]]]} | Open Access 1 | 1479 | Twin Lakes - USA | 26615 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Cruz 5 | 0.895 | Twin Lakes - USA | 0 | Federal Other or Unknown 87 | 4 | ||
9904 | 9904 | 9903 | {"type": "Polygon", "coordinates": [[[-120.98125, 37.06945], [-120.98076, 37.06939], [-120.98053, 37.06916], [-120.9804, 37.069], [-120.98041, 37.06827], [-120.9806, 37.06846], [-120.98083, 37.06901], [-120.98125, 37.06945]]]} | Open Access 1 | 16996 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Merced 37 | 0.907 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
6000 | 6000 | 5999 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00764], [-119.90417, 37.99681], [-119.89503, 37.99692], [-119.90419, 37.9968], [-119.9043, 38.00737], [-119.90427, 38.00765]]], [[[-119.89967, 38.00773], [-119.89967, 38.00761], [-119.89962, 38.00049], [-119.89963, 38.00049], [-119.89967, 38.00773]]], [[[-119.91335, 38.00029], [-119.90878, 38.00036], [-119.90882, 38.00455], [-119.90877, 38.00035], [-119.91335, 38.00029]]], [[[-119.91747, 38.00745], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91747, 38.00745]]], [[[-119.91643, 38.00385], [-119.91643, 38.00385], [-119.91388, 38.00389], [-119.91641, 38.00384], [-119.91643, 38.00385]]]]} | Open Access 1 | 647 | Hetch Hetchy Water and Power | 19887 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Tuolumne 21 | 1.045 | Hetch Hetchy Water and Power | None 483 | |||
2811 | 2811 | 2810 | {"type": "Polygon", "coordinates": [[[-119.14865, 35.67453], [-119.1475, 35.67452], [-119.1475, 35.67402], [-119.14865, 35.67402], [-119.14865, 35.67453]]]} | Open Access 1 | 14786 | United States Bureau of Reclamation | 13858 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Kern 36 | 1.453 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
911 | 911 | 910 | {"type": "Polygon", "coordinates": [[[-118.51445, 34.12995], [-118.51442, 34.13004], [-118.51434, 34.1301], [-118.51426, 34.13013], [-118.51414, 34.13012], [-118.51299, 34.12951], [-118.51312, 34.12943], [-118.5133, 34.12937], [-118.51381, 34.12933], [-118.51442, 34.12983], [-118.51445, 34.12991], [-118.51445, 34.12995]]]} | No Public Access 3 | 6367 | Encino Reservoir - Federal | 18670 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 1.48 | Encino Reservoir - Federal | 0 | Resource Management Area 82 | 3 | ||
10394 | 10394 | 10393 | {"type": "MultiPolygon", "coordinates": [[[[-117.53635, 34.18242], [-117.53635, 34.18254], [-117.53248, 34.18227], [-117.53248, 34.18202], [-117.53635, 34.18242]]], [[[-117.54058, 34.18647], [-117.53731, 34.18614], [-117.53731, 34.18611], [-117.54058, 34.18645], [-117.54058, 34.18647]]]]} | Open Access 1 | 18373 | Day Canyon Preserve | 17959 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 1.963 | Day Canyon Preserve | None 909 | |||
10040 | 10040 | 10039 | {"type": "Polygon", "coordinates": [[[-119.49172, 34.40088], [-119.49129, 34.40263], [-119.49129, 34.40263], [-119.49072, 34.40237], [-119.49092, 34.40127], [-119.49172, 34.40088]]]} | Open Access 1 | 17367 | Lions Park | 21316 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Santa Barbara 7 | 2.41 | Lions Park | 0 | Recreation Management Area 49 | 4 | ||
2892 | 2892 | 2891 | {"type": "Polygon", "coordinates": [[[-122.3644, 38.14004], [-122.36438, 38.1412], [-122.36339, 38.14077], [-122.36341, 38.13972], [-122.36362, 38.13981], [-122.3644, 38.14004]]]} | Open Access 1 | 23003 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 2.6 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
7012 | 7012 | 7011 | {"type": "Polygon", "coordinates": [[[-118.29494, 33.706], [-118.29474, 33.70626], [-118.29296, 33.7054], [-118.29347, 33.70526], [-118.2937, 33.70507], [-118.29383, 33.7049], [-118.29412, 33.70493], [-118.29436, 33.70513], [-118.29437, 33.70542], [-118.29462, 33.70546], [-118.29464, 33.70561], [-118.29494, 33.706]]]} | Open Access 1 | 5950 | Point Fermin Lighthouse | 23849 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 2.92 | Point Fermin Lighthouse | None 572 | |||
4135 | 4135 | 4134 | {"type": "Polygon", "coordinates": [[[-122.52305, 38.05524], [-122.52194, 38.05549], [-122.52181, 38.05532], [-122.52157, 38.05523], [-122.52156, 38.0552], [-122.52157, 38.05504], [-122.52156, 38.05494], [-122.52152, 38.05472], [-122.52145, 38.05448], [-122.52158, 38.05436], [-122.52177, 38.05425], [-122.52233, 38.05409], [-122.52305, 38.05524]]]} | Restricted Access 2 | 47183 | United States Coast Guard Park | 30875 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Marin 23 | 3.383 | United States Coast Guard Park | 0 | Recreation Management Area 49 | 4 | |
537 | 537 | 536 | {"type": "Polygon", "coordinates": [[[-118.93025, 34.14501], [-118.92997, 34.14499], [-118.92993, 34.14464], [-118.92975, 34.14379], [-118.92957, 34.14348], [-118.92948, 34.14328], [-118.92886, 34.14266], [-118.92864, 34.14235], [-118.92848, 34.14201], [-118.9283, 34.14173], [-118.92811, 34.14159], [-118.92784, 34.14148], [-118.9272, 34.14139], [-118.92693, 34.14128], [-118.92682, 34.1412], [-118.92674, 34.14104], [-118.9261, 34.14091], [-118.92611, 34.14077], [-118.92675, 34.14087], [-118.92687, 34.14075], [-118.92704, 34.14075], [-118.92725, 34.14084], [-118.92746, 34.14096], [-118.92768, 34.14103], [-118.92786, 34.14092], [-118.92801, 34.14071], [-118.92812, 34.14063], [-118.92829, 34.14063], [-118.92846, 34.14068], [-118.92868, 34.14092], [-118.92874, 34.14116], [-118.92841, 34.14085], [-118.92825, 34.14077], [-118.92811, 34.1408], [-118.92804, 34.14095], [-118.92794, 34.14107], [-118.92778, 34.14115], [-118.92765, 34.14115], [-118.92743, 34.14108], [-118.92726, 34.141], [-118.92709, 34.1409], [-118.92693, 34.14089], [-118.92688, 34.14102], [-118.92701, 34.14117], [-118.92717, 34.14123], [-118.92802, 34.14142], [-118.92829, 34.14151], [-118.92846, 34.14169], [-118.92862, 34.14194], [-118.92882, 34.14232], [-118.92903, 34.14264], [-118.92965, 34.14322], [-118.92974, 34.14342], [-118.92986, 34.14361], [-118.9301, 34.14436], [-118.93025, 34.14501]]]} | Open Access 1 | 2651 | Canilla Corp. | 14196 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Ventura 8 | 3.474 | Canilla Corp. | 0 | National Recreation Area 54 | 3 | |
17003 | 17003 | 17002 | {"type": "Polygon", "coordinates": [[[-124.07864, 40.04562], [-124.07862, 40.04581], [-124.07864, 40.04624], [-124.07861, 40.04664], [-124.07799, 40.04665], [-124.07798, 40.04646], [-124.07763, 40.04638], [-124.07767, 40.04611], [-124.07732, 40.04585], [-124.07662, 40.04552], [-124.07668, 40.04548], [-124.07683, 40.0453], [-124.07689, 40.04525], [-124.07694, 40.04522], [-124.07711, 40.0453], [-124.07735, 40.04533], [-124.07791, 40.04538], [-124.07818, 40.04533], [-124.07837, 40.04536], [-124.07855, 40.04545], [-124.07864, 40.04562]]]} | Open Access 1 | 46939 | King Range National Conservation Area | 30563 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/ca/st/en/prog/nlcs/King_Range_NCA/recreation/trails.html | Humboldt 45 | 3.788 | King Range Nat. Conservation Area | 0 | Conservation Area 13 | 2 |
12084 | 12084 | 12083 | {"type": "Polygon", "coordinates": [[[-117.24699, 34.22787], [-117.24641, 34.2278], [-117.24625, 34.22776], [-117.24604, 34.22767], [-117.24588, 34.22753], [-117.24579, 34.22741], [-117.24574, 34.2273], [-117.24558, 34.22653], [-117.24552, 34.22637], [-117.24544, 34.22621], [-117.24695, 34.22622], [-117.24699, 34.22787]]]} | Open Access 1 | 24892 | Baylis Park Picnic Area | 15888 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 5.039 | Baylis Park Picnic Area | 0 | Recreation Management Area 49 | 4 | |
8555 | 8555 | 8554 | {"type": "Polygon", "coordinates": [[[-121.48002, 41.95003], [-121.47898, 41.95093], [-121.47693, 41.95089], [-121.47853, 41.9496], [-121.47944, 41.94972], [-121.48002, 41.95003]]]} | Restricted Access 2 | 48508 | Tule Lake National Monument | 33219 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | Siskiyou 28 | 5.363 | Tule Lake NM | 1942 | National Monument or Landmark 80 | 3 | |
13143 | 13143 | 13142 | {"type": "Polygon", "coordinates": [[[-122.4927, 37.78799], [-122.49205, 37.78796], [-122.49139, 37.78826], [-122.49086, 37.78861], [-122.48984, 37.78946], [-122.48986, 37.78902], [-122.48996, 37.7886], [-122.49008, 37.78858], [-122.49004, 37.78851], [-122.49001, 37.78837], [-122.49005, 37.78836], [-122.49001, 37.78804], [-122.48986, 37.78796], [-122.49, 37.78777], [-122.49017, 37.78759], [-122.49038, 37.78742], [-122.49062, 37.78728], [-122.49091, 37.78716], [-122.49101, 37.78714], [-122.49113, 37.78714], [-122.4912, 37.78709], [-122.49154, 37.78723], [-122.49157, 37.78742], [-122.49166, 37.78741], [-122.49165, 37.78728], [-122.49175, 37.78732], [-122.49177, 37.7878], [-122.49222, 37.78752], [-122.49224, 37.78776], [-122.4927, 37.78799]]]} | Open Access 1 | 35094 | China Beach | 14203 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/goga/planyourvisit/chinabeach.htm | San Francisco 13 | 6.413 | China Beach | 1972 | National Recreation Area 54 | 3 |
4822 | 4822 | 4821 | {"type": "Polygon", "coordinates": [[[-121.83228, 36.63102], [-121.83235, 36.63119], [-121.83237, 36.63144], [-121.83233, 36.63172], [-121.83214, 36.63209], [-121.83126, 36.63335], [-121.83034, 36.63271], [-121.82997, 36.63238], [-121.83091, 36.63158], [-121.83117, 36.63142], [-121.83217, 36.63099], [-121.83228, 36.63102]]]} | Open Access 1 | 48913 | Unknown park - United States Department of Defense | 33634 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 7.047 | None 404 |
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]);