units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
79 rows where ACCESS_TYP = 3 and MNG_AGENCY = 25 sorted by COUNTY
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- State Agency 59
MNG_AGENCY 1
- California Department of Fish and Wildlife · 59 ✖
ACCESS_TYP 1
- No Public Access · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296 | 3296 | 3295 | {"type": "Polygon", "coordinates": [[[-121.61412, 37.7845], [-121.61412, 37.78579], [-121.61407, 37.78736], [-121.60506, 37.78748], [-121.605, 37.78452], [-121.6051, 37.78452], [-121.60511, 37.78451], [-121.61412, 37.7845]]]} | No Public Access 3 | 23599 | Christensen Road Burrowing Owl Site | 32113 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 63.899 | Christensen Road Burrowing Owl Site | 0 | State Resource Management Area 55 | 3 | |
7843 | 7843 | 7842 | {"type": "Polygon", "coordinates": [[[-121.614, 37.79798], [-121.61399, 37.79871], [-121.61178, 37.80234], [-121.60506, 37.80232], [-121.60511, 37.79512], [-121.60597, 37.79516], [-121.60635, 37.79514], [-121.60669, 37.7951], [-121.60709, 37.79511], [-121.6071, 37.79502], [-121.61204, 37.79505], [-121.614, 37.79798]]]} | No Public Access 3 | 9433 | Byron Conservation Bank | 32076 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 139.979 | Byron Conservation Bank | 0 | State Resource Management Area 55 | 3 | |
11550 | 11550 | 11549 | {"type": "Polygon", "coordinates": [[[-122.15107, 37.66265], [-122.14971, 37.66346], [-122.14945, 37.66398], [-122.1474, 37.66495], [-122.14554, 37.66547], [-122.14345, 37.66316], [-122.139, 37.65856], [-122.13938, 37.65851], [-122.13948, 37.6586], [-122.13969, 37.65847], [-122.14042, 37.65838], [-122.14166, 37.65981], [-122.14167, 37.65974], [-122.14402, 37.65974], [-122.14683, 37.65976], [-122.15107, 37.66265]]]} | No Public Access 3 | 23596 | San Francisco Bay | 32293 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Alameda 17 | 87.824 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
2481 | 2481 | 2480 | {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} | No Public Access 3 | 17478 | Bend Ferry Road | 32047 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tehama 18 | 45.388 | Bend Ferry Road | 0 | State Resource Management Area 55 | 3 | |
3489 | 3489 | 3488 | {"type": "Polygon", "coordinates": [[[-121.97758, 37.42901], [-121.97746, 37.43245], [-121.97438, 37.4325], [-121.97433, 37.42904], [-121.97758, 37.42901]]]} | No Public Access 3 | 25900 | San Francisco Bay | 32293 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Santa Clara 19 | 26.519 | San Francisco Bay | 1980 | State Resource Management Area 55 | 3 | |
3490 | 3490 | 3489 | {"type": "MultiPolygon", "coordinates": [[[[-115.13976, 33.41494], [-115.13975, 33.4189], [-115.13539, 33.41889], [-115.13545, 33.41469], [-115.13976, 33.41494]]], [[[-115.19698, 33.413], [-115.18761, 33.41303], [-115.18762, 33.40954], [-115.1968, 33.40952], [-115.19681, 33.40939], [-115.19685, 33.40941], [-115.19698, 33.413]]], [[[-115.21504, 33.39466], [-115.20553, 33.39498], [-115.20542, 33.3912], [-115.21496, 33.39121], [-115.21504, 33.39466]]]]} | No Public Access 3 | 25902 | Tabaseca | 32324 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Imperial 20 | 215.634 | Tabaseca | 0 | State Resource Management Area 55 | 3 | |
16574 | 16574 | 16573 | {"type": "MultiPolygon", "coordinates": [[[[-114.95504, 33.26685], [-114.93776, 33.26689], [-114.93775, 33.26702], [-114.93746, 33.26702], [-114.93746, 33.26668], [-114.93718, 33.26668], [-114.93713, 33.2594], [-114.93712, 33.25216], [-114.95448, 33.25207], [-114.95504, 33.26685]]], [[[-114.98888, 33.26647], [-114.98008, 33.26656], [-114.97992, 33.25954], [-114.97989, 33.25216], [-114.98884, 33.25215], [-114.98888, 33.26647]]]]} | No Public Access 3 | 44921 | Smoketree Valley - Chocolate Mountains | 32312 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Imperial 20 | 990.532 | Smoketree Valley - Chocolate Mtns. | 0 | State Resource Management Area 55 | 3 | |
3167 | 3167 | 3166 | {"type": "MultiPolygon", "coordinates": [[[[-116.68524, 34.06247], [-116.6852, 34.07681], [-116.66784, 34.07682], [-116.66779, 34.06235], [-116.65036, 34.06223], [-116.65034, 34.04784], [-116.66779, 34.04785], [-116.6678, 34.06235], [-116.68524, 34.06247]]], [[[-116.6938, 34.10576], [-116.69375, 34.11974], [-116.68527, 34.11965], [-116.6851, 34.10573], [-116.66771, 34.1057], [-116.66798, 34.09129], [-116.68529, 34.09155], [-116.6851, 34.10573], [-116.6938, 34.10576]]]]} | No Public Access 3 | 21980 | Mission Creek | 32221 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 2202.531 | Mission Creek | 0 | State Resource Management Area 55 | 3 | |
3439 | 3439 | 3438 | {"type": "Polygon", "coordinates": [[[-116.69795, 34.67637], [-116.68049, 34.67634], [-116.68049, 34.67369], [-116.69794, 34.67376], [-116.69795, 34.67637]]]} | No Public Access 3 | 25252 | Ord Rodman | 32252 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 115.534 | Ord Rodman | 0 | State Resource Management Area 55 | 3 | |
7211 | 7211 | 7210 | {"type": "MultiPolygon", "coordinates": [[[[-115.10424, 34.50144], [-115.10424, 34.51594], [-115.08672, 34.51599], [-115.08674, 34.50147], [-115.10424, 34.50144]]], [[[-115.22675, 34.55713], [-115.21271, 34.55713], [-115.20947, 34.55717], [-115.20945, 34.54492], [-115.21819, 34.54493], [-115.22674, 34.54496], [-115.22675, 34.55713]]], [[[-115.22005, 34.58613], [-115.21566, 34.58613], [-115.21566, 34.58265], [-115.22005, 34.58265], [-115.22005, 34.58613]]]]} | No Public Access 3 | 6386 | Old Woman Mountains Bighorn Sheep Range | 32250 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 1209.01 | Old Woman Mtns. Bighorn Sheep Range | 0 | State Resource Management Area 55 | 3 | |
8054 | 8054 | 8053 | {"type": "Polygon", "coordinates": [[[-117.24639, 34.2514], [-117.24262, 34.25146], [-117.2426, 34.25152], [-117.24249, 34.25502], [-117.23823, 34.25519], [-117.23846, 34.24793], [-117.24636, 34.24797], [-117.24639, 34.2514]]]} | No Public Access 3 | 11821 | San Bernardino Mountains Wildlife Corridor | 32288 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 109.636 | San Bernardino Mtns. Wildlife Corridor | 0 | State Conservation Area 8 | 2 | |
8126 | 8126 | 8125 | {"type": "MultiPolygon", "coordinates": [[[[-114.68296, 34.3398], [-114.6829, 34.35425], [-114.66553, 34.35431], [-114.66563, 34.33982], [-114.68296, 34.3398]]], [[[-114.68326, 34.51393], [-114.68325, 34.52852], [-114.66592, 34.52856], [-114.66591, 34.51398], [-114.68326, 34.51393]]], [[[-114.7991, 34.61705], [-114.7905, 34.61714], [-114.78964, 34.60968], [-114.79824, 34.60959], [-114.7991, 34.61705]]], [[[-114.88529, 35.17127], [-114.86761, 35.17123], [-114.86761, 35.15694], [-114.88528, 35.15695], [-114.88529, 35.17127]]], [[[-114.89428, 35.13283], [-114.87683, 35.13283], [-114.87681, 35.11849], [-114.88106, 35.11848], [-114.88548, 35.1185], [-114.89428, 35.11847], [-114.89425, 35.12797], [-114.89428, 35.13283]]], [[[-114.90745, 34.70247], [-114.89003, 34.70345], [-114.89002, 34.70331], [-114.88985, 34.70332], [-114.88985, 34.68886], [-114.90723, 34.68779], [-114.90724, 34.68794], [-114.90742, 34.68793], [-114.90745, 34.70247]]], [[[-114.90784, 34.96717], [-114.90772, 34.96717], [-114.90772, 34.96727], [-114.89044, 34.96737], [-114.89047, 34.95306], [-114.90783, 34.95295], [-114.90784, 34.96717]]], [[[-114.95009, 34.7308], [-114.95002, 34.7454], [-114.93246, 34.74534], [-114.93246, 34.74521], [-114.93228, 34.7452], [-114.93231, 34.73056], [-114.94991, 34.73067], [-114.94991, 34.7308], [-114.95009, 34.7308]]], [[[-114.95011, 34.64364], [-114.95011, 34.65819], [-114.93256, 34.65819], [-114.93254, 34.64359], [-114.95011, 34.64364]]], [[[-114.95123, 34.55668], [-114.95122, 34.57118], [-114.93355, 34.57114], [-114.9337, 34.55663], [-114.95123, 34.55668]]], [[[-114.99959, 34.51577], [-114.99957, 34.53029], [-114.98195, 34.53015], [-114.98202, 34.51566], [-114.99959, 34.51577]]], [[[-115.05707, 34.57155], [-115.03971, 34.57147], [-115.03971, 34.5571], [-115.05707, 34.55719], [-115.05707, 34.57155]]], [[[-115.26678, 34.83271], [-115.24935, 34.8326], [-115.24934, 34.83047], [-115.24988, 34.81813], [-115.26674, 34.81823], [-115.2668, 34.82226], [-115.26678, 34.83271]]]]} | No Public Access 3 | 12300 | East Mojave Desert | 32154 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 7795.792 | East Mojave Desert | 0 | State Resource Management Area 55 | 3 | |
11553 | 11553 | 11552 | {"type": "MultiPolygon", "coordinates": [[[[-116.27983, 35.49216], [-116.27707, 35.49572], [-116.27495, 35.49496], [-116.2776, 35.49119], [-116.27983, 35.49216]]], [[[-116.28733, 35.48445], [-116.28702, 35.48523], [-116.28511, 35.48486], [-116.28546, 35.48401], [-116.28733, 35.48445]]]]} | No Public Access 3 | 23604 | Mountain Sheep Watering Area | 32241 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 29.9 | Mtn. Sheep Watering Area | 0 | State Resource Management Area 55 | 3 | |
12567 | 12567 | 12566 | {"type": "Polygon", "coordinates": [[[-116.80776, 34.25506], [-116.80546, 34.25503], [-116.80552, 34.25267], [-116.80555, 34.25223], [-116.80581, 34.25222], [-116.80587, 34.25399], [-116.8077, 34.25401], [-116.80776, 34.25506]]]} | No Public Access 3 | 29074 | Shay Meadow | 32307 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 7.409 | Shay Meadow | 0 | State Resource Management Area 55 | 3 | |
14660 | 14660 | 14659 | {"type": "Polygon", "coordinates": [[[-116.10145, 34.19582], [-116.10145, 34.19703], [-116.09814, 34.19705], [-116.09814, 34.19584], [-116.10145, 34.19582]]]} | No Public Access 3 | 44923 | Twentynine Palms - Valle Vista Road | 32334 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Bernardino 22 | 10.115 | Twentynine Palms - Valle Vista Road | 0 | State Resource Management Area 55 | 3 | |
6173 | 6173 | 6172 | {"type": "Polygon", "coordinates": [[[-122.64262, 37.8994], [-122.64213, 37.8998], [-122.64167, 37.8996], [-122.64213, 37.89912], [-122.64242, 37.8992], [-122.64262, 37.8994]]]} | No Public Access 3 | 1204 | Stinson Beach | 32319 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 0.833 | Stinson Beach | 0 | State Resource Management Area 55 | 3 | |
13181 | 13181 | 13180 | {"type": "Polygon", "coordinates": [[[-122.92622, 38.21025], [-122.92607, 38.2121], [-122.9261, 38.21451], [-122.92537, 38.21453], [-122.92543, 38.21398], [-122.9252, 38.21396], [-122.92534, 38.21304], [-122.92489, 38.21275], [-122.92481, 38.21267], [-122.92468, 38.21246], [-122.92464, 38.21237], [-122.92459, 38.21217], [-122.92434, 38.21196], [-122.92414, 38.21165], [-122.92392, 38.21134], [-122.92379, 38.21121], [-122.92373, 38.21108], [-122.92373, 38.21095], [-122.92376, 38.21086], [-122.92383, 38.21078], [-122.92388, 38.21074], [-122.924, 38.21071], [-122.92413, 38.2107], [-122.92483, 38.21075], [-122.92503, 38.21072], [-122.92521, 38.21068], [-122.92534, 38.21057], [-122.9254, 38.2105], [-122.92561, 38.21012], [-122.92562, 38.21043], [-122.92581, 38.21043], [-122.92581, 38.21025], [-122.92622, 38.21025]]]} | No Public Access 3 | 35164 | Walker Creek Marsh | 32346 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Marin 23 | 13.468 | Walker Creek Marsh | 0 | State Resource Management Area 55 | 3 | |
4050 | 4050 | 4049 | {"type": "Polygon", "coordinates": [[[-121.2962, 39.21942], [-121.29618, 39.2203], [-121.29437, 39.22303], [-121.29491, 39.22306], [-121.29612, 39.22304], [-121.29618, 39.22871], [-121.28779, 39.22877], [-121.283, 39.23055], [-121.28206, 39.23057], [-121.2796, 39.2303], [-121.27958, 39.22694], [-121.27961, 39.22337], [-121.27959, 39.22084], [-121.28264, 39.21905], [-121.28214, 39.21734], [-121.28476, 39.21721], [-121.28485, 39.21747], [-121.28646, 39.21812], [-121.28688, 39.21794], [-121.28712, 39.21789], [-121.28681, 39.21716], [-121.28717, 39.21709], [-121.28742, 39.2167], [-121.28746, 39.21639], [-121.28755, 39.2162], [-121.28766, 39.21607], [-121.2878, 39.21598], [-121.28795, 39.21593], [-121.28814, 39.21573], [-121.28824, 39.21558], [-121.28836, 39.21545], [-121.28864, 39.21524], [-121.28879, 39.21504], [-121.28892, 39.21504], [-121.2889, 39.2138], [-121.29403, 39.21379], [-121.29394, 39.21941], [-121.2962, 39.21942]]]} | No Public Access 3 | 44338 | Lower Yuba River | 32209 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Yuba 25 | 484.28 | Lower Yuba River | 0 | State Resource Management Area 55 | 3 | |
6562 | 6562 | 6561 | {"type": "MultiPolygon", "coordinates": [[[[-122.36595, 40.50811], [-122.36457, 40.50963], [-122.36317, 40.51062], [-122.36286, 40.51141], [-122.36171, 40.51207], [-122.36145, 40.5119], [-122.36142, 40.51191], [-122.36049, 40.5114], [-122.35933, 40.51101], [-122.35937, 40.5084], [-122.36377, 40.50797], [-122.3654, 40.50806], [-122.36595, 40.50811]]], [[[-122.37348, 40.55551], [-122.3734, 40.55564], [-122.37337, 40.55586], [-122.37338, 40.55617], [-122.37197, 40.55594], [-122.37218, 40.55527], [-122.37348, 40.55551]]]]} | No Public Access 3 | 3435 | Sacramento River -- Redding | 32284 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 40.985 | Sacramento River -- Redding | 0 | State Resource Management Area 55 | 3 | |
10548 | 10548 | 10547 | {"type": "MultiPolygon", "coordinates": [[[[-122.47683, 40.49506], [-122.47594, 40.49555], [-122.47571, 40.49565], [-122.47441, 40.49567], [-122.47422, 40.49559], [-122.47405, 40.49549], [-122.47386, 40.49535], [-122.47371, 40.49518], [-122.47358, 40.49495], [-122.47348, 40.4946], [-122.4734, 40.49439], [-122.47327, 40.49419], [-122.47305, 40.49395], [-122.47277, 40.49375], [-122.47245, 40.49359], [-122.47209, 40.49348], [-122.4718, 40.49343], [-122.47119, 40.49339], [-122.47118, 40.49348], [-122.46964, 40.49349], [-122.46915, 40.49352], [-122.46848, 40.49362], [-122.46765, 40.49385], [-122.46753, 40.4911], [-122.47213, 40.49108], [-122.47219, 40.49201], [-122.47675, 40.49194], [-122.4768, 40.49321], [-122.47683, 40.49506]]], [[[-122.47345, 40.49569], [-122.4723, 40.49571], [-122.47228, 40.49481], [-122.4677, 40.49481], [-122.46767, 40.49414], [-122.46885, 40.49383], [-122.46916, 40.49378], [-122.46951, 40.49375], [-122.47117, 40.49375], [-122.47118, 40.49387], [-122.47173, 40.4939], [-122.47199, 40.49395], [-122.47224, 40.49403], [-122.47241, 40.49412], [-122.4726, 40.49426], [-122.47273, 40.49438], [-122.47283, 40.49452], [-122.4729, 40.49466], [-122.473, 40.49504], [-122.4731, 40.49526], [-122.47324, 40.49547], [-122.47345, 40.49569]]], [[[-122.47683, 40.49563], [-122.47679, 40.49564], [-122.47655, 40.49564], [-122.47683, 40.49548], [-122.47683, 40.49563]]]]} | No Public Access 3 | 18763 | Clear Creek | 32118 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 71.599 | Clear Creek | 0 | State Resource Management Area 55 | 3 |
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]);