units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
90 rows where ACCESS_TYP = 2 and AGNCY_TYP = 1 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, GAP_STS
DES_TP 22
- National Wildlife Refuge 34
- National Public Lands 9
- Recreation Management Area 9
- State Conservation Area 6
- Federal Other or Unknown 6
- Conservation Area 5
- National Park 4
- National Recreation Area 2
- Resource Management Area 2
- Local Recreation Area 1
- None 1
- Wilderness Area 1
- National Monument or Landmark 1
- Research or Educational Area 1
- None 1
- None 1
- None 1
- Area of Critical Environmental Concern 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 15
- United States Fish and Wildlife Service 39
- United States Bureau of Land Management 12
- United States National Park Service 8
- United States Army Corps of Engineers 6
- United States Bureau of Reclamation 6
- California Department of Fish and Wildlife 3
- University of California 3
- United States Coast Guard 3
- Other Federal 2
- San Diego State University 2
- United States Department of Defense 2
- Los Angeles, County of 1
- United States Forest Service 1
- Needles, City of 1
- Palos Verdes Peninsula Land Conservancy 1
MNG_AG_TYP 5
ACCESS_TYP 1
- Restricted Access · 90 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6056 | 6056 | 6055 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.6582, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65786, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | 12780 | Santa Monica Mountains National Recreation Area | 29657 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 2.045 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
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 | |
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 | |
3589 | 3589 | 3588 | {"type": "Polygon", "coordinates": [[[-121.4409, 38.26568], [-121.4405, 38.26654], [-121.43893, 38.26623], [-121.43872, 38.26566], [-121.43905, 38.26515], [-121.43899, 38.26457], [-121.44061, 38.26555], [-121.4409, 38.26568]]]} | Restricted Access 2 | 29176 | Cosumnes River Ecological Reserve | 17675 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Cosumnes-River-ER | Sacramento 41 | 5.742 | Cosumnes River ER | 2003 | State Conservation Area 8 | 2 |
4765 | 4765 | 4764 | {"type": "Polygon", "coordinates": [[[-118.64125, 34.08303], [-118.64124, 34.08543], [-118.6369, 34.08542], [-118.6382, 34.08423], [-118.63902, 34.08386], [-118.63915, 34.08375], [-118.6392, 34.08385], [-118.63947, 34.08386], [-118.63997, 34.08356], [-118.64125, 34.08303]]]} | Restricted Access 2 | 46840 | Unnamed site - National Park Service | 31224 | 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 | Los Angeles 6 | 15.693 | 0 | Federal Other or Unknown 87 | 4 | ||
7269 | 7269 | 7268 | {"type": "Polygon", "coordinates": [[[-118.70012, 34.09988], [-118.69791, 34.09987], [-118.69791, 34.09626], [-118.69892, 34.09625], [-118.7001, 34.0973], [-118.70012, 34.09988]]]} | Restricted Access 2 | 6493 | Diamond X Ranch | 29655 | 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 | Los Angeles 6 | 18.578 | Diamond X Ranch | 0 | Recreation Management Area 49 | 4 | |
6977 | 6977 | 6976 | {"type": "Polygon", "coordinates": [[[-118.41157, 33.74115], [-118.41151, 33.74127], [-118.41156, 33.74174], [-118.41107, 33.74267], [-118.411, 33.74311], [-118.41042, 33.74286], [-118.40949, 33.74479], [-118.40945, 33.74479], [-118.40949, 33.74466], [-118.40952, 33.74448], [-118.40953, 33.74416], [-118.40949, 33.74392], [-118.40945, 33.74375], [-118.40938, 33.74359], [-118.40928, 33.74339], [-118.40898, 33.74301], [-118.4087, 33.74277], [-118.40857, 33.74268], [-118.40821, 33.74249], [-118.40792, 33.74239], [-118.40764, 33.7423], [-118.40706, 33.74218], [-118.40653, 33.74213], [-118.40563, 33.74215], [-118.4052, 33.74214], [-118.4052, 33.74212], [-118.40655, 33.74204], [-118.40774, 33.74166], [-118.40774, 33.74164], [-118.40704, 33.74132], [-118.40726, 33.74131], [-118.40832, 33.74109], [-118.40952, 33.74099], [-118.41079, 33.74097], [-118.41157, 33.74115]]]} | Restricted Access 2 | 5900 | Point Vicente Lighthouse | 23867 | 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 | 20.729 | Point Vicente Lighthouse | None 570 | |||
7058 | 7058 | 7057 | {"type": "Polygon", "coordinates": [[[-118.06181, 34.02017], [-118.06089, 34.02054], [-118.06107, 34.02082], [-118.06117, 34.02082], [-118.06121, 34.02141], [-118.05671, 34.02154], [-118.0577, 34.02122], [-118.05703, 34.01992], [-118.05747, 34.01907], [-118.05897, 34.01802], [-118.06078, 34.01739], [-118.06033, 34.01796], [-118.05961, 34.01857], [-118.0607, 34.02026], [-118.06181, 34.02017]]]} | Restricted Access 2 | 6569 | Pico Rivera Golf Course | 33017 | 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 | 26.31 | Pico Rivera GC | 0 | Recreation Management Area 49 | 4 | |
16397 | 16397 | 16396 | {"type": "Polygon", "coordinates": [[[-121.84941, 36.95765], [-121.84932, 36.95782], [-121.84903, 36.95804], [-121.84861, 36.95819], [-121.84853, 36.95827], [-121.84855, 36.95846], [-121.84801, 36.95847], [-121.84779, 36.95855], [-121.84752, 36.95899], [-121.84755, 36.9599], [-121.84699, 36.96071], [-121.84698, 36.96089], [-121.84729, 36.9623], [-121.84754, 36.96307], [-121.84617, 36.96314], [-121.84616, 36.96255], [-121.84619, 36.96183], [-121.84626, 36.96086], [-121.84627, 36.96017], [-121.84642, 36.95971], [-121.84642, 36.95919], [-121.84636, 36.95864], [-121.8462, 36.95828], [-121.84591, 36.95775], [-121.84515, 36.95702], [-121.84454, 36.9566], [-121.8446, 36.95623], [-121.8467, 36.95564], [-121.84709, 36.95597], [-121.84741, 36.9562], [-121.84775, 36.95682], [-121.8479, 36.95696], [-121.84802, 36.95701], [-121.84854, 36.95701], [-121.84879, 36.95719], [-121.84941, 36.95751], [-121.84941, 36.95765]]]} | Restricted Access 2 | 1387 | Ellicott Slough National Wildlife Area | 18587 | 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 | Santa Cruz 5 | 31.059 | Ellicott Slough Nat. Wildlife Area | 0 | Conservation Area 13 | 2 | |
15834 | 15834 | 15833 | {"type": "Polygon", "coordinates": [[[-122.33934, 38.15573], [-122.33919, 38.15592], [-122.33894, 38.15637], [-122.33875, 38.15679], [-122.33872, 38.15693], [-122.33861, 38.15714], [-122.33856, 38.15758], [-122.33841, 38.15832], [-122.33829, 38.15856], [-122.33809, 38.15884], [-122.33779, 38.1591], [-122.33759, 38.15913], [-122.33741, 38.15909], [-122.33694, 38.15895], [-122.33503, 38.15824], [-122.33482, 38.15813], [-122.33419, 38.15741], [-122.33391, 38.15692], [-122.33396, 38.15657], [-122.33421, 38.15609], [-122.33447, 38.15581], [-122.33474, 38.15559], [-122.33545, 38.15565], [-122.33538, 38.15569], [-122.33539, 38.15571], [-122.33934, 38.15573]]]} | Restricted Access 2 | 35998 | San Pablo Bay National Wildlife Refuge | 24964 | 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 | Napa 11 | 31.587 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
13054 | 13054 | 13053 | {"type": "Polygon", "coordinates": [[[-122.17843, 39.75789], [-122.17369, 39.75785], [-122.17368, 39.75452], [-122.17834, 39.75457], [-122.17843, 39.75789]]]} | Restricted Access 2 | 34910 | BLM | 16163 | 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 | Glenn 55 | 36.703 | BLM | 1963 | National Public Lands 1 | 3 | |
2605 | 2605 | 2604 | {"type": "Polygon", "coordinates": [[[-121.15097, 37.72216], [-121.15092, 37.72224], [-121.15022, 37.72251], [-121.14996, 37.72257], [-121.14906, 37.72258], [-121.14871, 37.72256], [-121.14713, 37.72287], [-121.14715, 37.71763], [-121.14757, 37.71777], [-121.14796, 37.71805], [-121.14839, 37.71831], [-121.14897, 37.71837], [-121.14937, 37.71847], [-121.14966, 37.71865], [-121.15025, 37.71934], [-121.15054, 37.71945], [-121.15091, 37.71949], [-121.15098, 37.72192], [-121.15097, 37.72216]]]} | Restricted Access 2 | 17440 | San Joaquin National Wildlife Refuge | 24912 | 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 | San Joaquin 39 | 37.381 | San Joaquin NWR | 0 | National Wildlife Refuge 105 | 2 | |
356 | 356 | 355 | {"type": "Polygon", "coordinates": [[[-122.49396, 38.11519], [-122.49396, 38.11668], [-122.49389, 38.11699], [-122.49376, 38.11735], [-122.49339, 38.11788], [-122.49311, 38.11825], [-122.49275, 38.11856], [-122.49241, 38.1189], [-122.49231, 38.1192], [-122.49228, 38.11936], [-122.49071, 38.12038], [-122.48879, 38.12141], [-122.48651, 38.12238], [-122.47257, 38.12807], [-122.47183, 38.12772], [-122.48389, 38.1232], [-122.49205, 38.11836], [-122.49375, 38.11703], [-122.49245, 38.11561], [-122.4906, 38.11561], [-122.49396, 38.11519]]]} | Restricted Access 2 | 982 | Sonoma Baylands | 25608 | 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 | Sonoma 16 | 37.517 | Sonoma Baylands | None 36 | |||
5580 | 5580 | 5579 | {"type": "Polygon", "coordinates": [[[-121.95567, 37.92322], [-121.95099, 37.92324], [-121.9509, 37.91961], [-121.95562, 37.91959], [-121.95567, 37.92322]]]} | Restricted Access 2 | 29557 | BLM | 16163 | 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 | Contra Costa 12 | 41.201 | BLM | 1963 | National Public Lands 1 | 3 | |
4297 | 4297 | 4296 | {"type": "Polygon", "coordinates": [[[-118.29942, 33.77494], [-118.29942, 33.77696], [-118.29939, 33.77872], [-118.29927, 33.77873], [-118.2993, 33.77912], [-118.29933, 33.77926], [-118.29899, 33.77937], [-118.29847, 33.77958], [-118.29817, 33.77974], [-118.29789, 33.77991], [-118.29756, 33.78016], [-118.29733, 33.78036], [-118.29719, 33.7805], [-118.29689, 33.78086], [-118.29653, 33.78039], [-118.29642, 33.78022], [-118.29629, 33.77995], [-118.2962, 33.77972], [-118.29612, 33.77939], [-118.29609, 33.77919], [-118.29609, 33.77886], [-118.29607, 33.77885], [-118.2962, 33.77664], [-118.29621, 33.77606], [-118.29618, 33.77577], [-118.29613, 33.77548], [-118.29607, 33.77519], [-118.296, 33.77494], [-118.29942, 33.77494]]]} | Restricted Access 2 | 45339 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18014 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 3052 | Palos Verdes Peninsula Land Conservancy 727 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 41.501 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | None 377 | ||||
4144 | 4144 | 4143 | {"type": "Polygon", "coordinates": [[[-122.46384, 39.38383], [-122.45881, 39.38384], [-122.4585, 39.38043], [-122.46379, 39.38038], [-122.46384, 39.38383]]]} | Restricted Access 2 | 47499 | BLM | 16163 | 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 | Colusa 49 | 41.777 | BLM | 1963 | National Public Lands 1 | 3 | |
6676 | 6676 | 6675 | {"type": "Polygon", "coordinates": [[[-117.1779, 33.42839], [-117.1779, 33.43232], [-117.17339, 33.43239], [-117.17327, 33.42847], [-117.1779, 33.42839]]]} | Restricted Access 2 | 5517 | Santa Margarita Ecological Reserve | 33342 | 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 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 45.762 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
15831 | 15831 | 15830 | {"type": "MultiPolygon", "coordinates": [[[[-121.78465, 38.0124], [-121.78465, 38.01497], [-121.78434, 38.01488], [-121.78288, 38.01481], [-121.7822, 38.01481], [-121.78221, 38.01241], [-121.78465, 38.0124]]], [[[-121.80036, 38.01588], [-121.80029, 38.01594], [-121.80028, 38.01682], [-121.80004, 38.01692], [-121.79962, 38.01682], [-121.79902, 38.01709], [-121.7979, 38.01721], [-121.79723, 38.01706], [-121.79517, 38.01682], [-121.79356, 38.01646], [-121.79153, 38.01579], [-121.79155, 38.0136], [-121.79168, 38.0136], [-121.79179, 38.01355], [-121.79182, 38.01351], [-121.79184, 38.01342], [-121.7918, 38.01335], [-121.79172, 38.01329], [-121.79172, 38.01326], [-121.79496, 38.01395], [-121.79495, 38.01546], [-121.79509, 38.0155], [-121.79588, 38.01559], [-121.79633, 38.01558], [-121.79678, 38.0155], [-121.79682, 38.01544], [-121.7977, 38.01563], [-121.79804, 38.01569], [-121.79848, 38.01573], [-121.79876, 38.01573], [-121.79903, 38.0157], [-121.79905, 38.01511], [-121.79926, 38.01495], [-121.80036, 38.01588]]]]} | Restricted Access 2 | 17082 | Antioch Dunes National Wildlife Refuge | 15523 | 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 | Contra Costa 12 | 55.567 | Antioch Dunes NWR | 1980 | National Wildlife Refuge 105 | 2 | |
2309 | 2309 | 2308 | {"type": "Polygon", "coordinates": [[[-121.93508, 36.63686], [-121.9352, 36.63631], [-121.93434, 36.63622], [-121.93403, 36.63597], [-121.93388, 36.63682], [-121.93373, 36.6367], [-121.93358, 36.63661], [-121.93345, 36.63655], [-121.93323, 36.63651], [-121.93265, 36.63645], [-121.93242, 36.63646], [-121.93198, 36.63652], [-121.93186, 36.63652], [-121.93169, 36.63648], [-121.93134, 36.63634], [-121.93112, 36.63628], [-121.93293, 36.63126], [-121.93296, 36.63122], [-121.93303, 36.63118], [-121.93313, 36.63118], [-121.93652, 36.63197], [-121.93658, 36.63201], [-121.93667, 36.63215], [-121.93684, 36.63233], [-121.93807, 36.63346], [-121.93815, 36.63355], [-121.9382, 36.63364], [-121.93822, 36.63377], [-121.93822, 36.63386], [-121.9382, 36.63394], [-121.93815, 36.63403], [-121.93806, 36.63412], [-121.93782, 36.63431], [-121.93772, 36.63442], [-121.93748, 36.63485], [-121.93724, 36.63514], [-121.93701, 36.63548], [-121.93691, 36.63556], [-121.93657, 36.63575], [-121.93643, 36.63587], [-121.93631, 36.63603], [-121.93599, 36.63655], [-121.93587, 36.63669], [-121.93578, 36.63676], [-121.93565, 36.63681], [-121.93508, 36.63686]]]} | Restricted Access 2 | 18342 | Pacific Grove Golf Links / Lighthouse Reservation | 33065 | 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 | Monterey 14 | 63.831 | Pacific Grove Golf Links / Lighthouse Reservation | None 192 | |||
14324 | 14324 | 14323 | {"type": "Polygon", "coordinates": [[[-122.35854, 38.67935], [-122.35842, 38.68289], [-122.35467, 38.68299], [-122.35479, 38.68008], [-122.3509, 38.68006], [-122.35088, 38.6765], [-122.3509, 38.67651], [-122.35493, 38.67653], [-122.35481, 38.67945], [-122.35854, 38.67935]]]} | Restricted Access 2 | 44307 | United States Bureau of Reclamation | 26666 | 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 | Napa 11 | 65.157 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 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]);