units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where ACCESS_TYP = 3 and DES_TP = 55
This data as json, copyable, CSV (advanced)
MNG_AGENCY 2
MNG_AG_TYP 1
- State Agency 52
DES_TP 1
- State Resource Management Area · 52 ✖
ACCESS_TYP 1
- No Public Access · 52 ✖
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 | |
3427 | 3427 | 3426 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | 25174 | South Branciforte | 32313 | 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 Cruz 5 | 0.251 | South Branciforte | 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 | |
3442 | 3442 | 3441 | {"type": "Polygon", "coordinates": [[[-123.96676, 41.87177], [-123.95707, 41.87178], [-123.95706, 41.86815], [-123.96193, 41.86808], [-123.96197, 41.86444], [-123.96673, 41.86439], [-123.96667, 41.86953], [-123.96676, 41.87177]]]} | No Public Access 3 | 25256 | Stoney Creek | 32321 | 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 | Del Norte 50 | 120.393 | Stoney Creek | 0 | State Resource Management Area 55 | 3 | |
3485 | 3485 | 3484 | {"type": "Polygon", "coordinates": [[[-123.05209, 38.33746], [-123.05198, 38.33754], [-123.05179, 38.33741], [-123.05131, 38.33782], [-123.05136, 38.33837], [-123.04991, 38.33944], [-123.04926, 38.33873], [-123.05025, 38.33836], [-123.05118, 38.33786], [-123.05131, 38.33741], [-123.05145, 38.33698], [-123.05209, 38.33746]]]} | No Public Access 3 | 25904 | Bodega Bay Monarch Butterfly | 32057 | 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 | Sonoma 16 | 4.076 | Bodega Bay Monarch Butterfly | 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 | |
3491 | 3491 | 3490 | {"type": "MultiPolygon", "coordinates": [[[[-119.50998, 35.36521], [-119.50076, 35.36536], [-119.50076, 35.36145], [-119.50129, 35.36134], [-119.50218, 35.36122], [-119.50274, 35.36122], [-119.50324, 35.36126], [-119.50374, 35.36134], [-119.50422, 35.36146], [-119.50467, 35.36161], [-119.50529, 35.36191], [-119.50667, 35.36283], [-119.50706, 35.36313], [-119.50998, 35.36521]]], [[[-119.63933, 35.48483], [-119.63646, 35.48481], [-119.63652, 35.47193], [-119.63789, 35.47208], [-119.63786, 35.47474], [-119.63778, 35.47861], [-119.63933, 35.48483]]]]} | No Public Access 3 | 25905 | California Aqueduct, Region 4 | 32081 | 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 | Kern 36 | 118.425 | California Aqueduct, Region 4 | 0 | State Resource Management Area 55 | 3 | |
3675 | 3675 | 3674 | {"type": "Polygon", "coordinates": [[[-117.5972, 33.67495], [-117.59564, 33.67532], [-117.59561, 33.6788], [-117.59438, 33.67879], [-117.59174, 33.67873], [-117.59136, 33.67839], [-117.59108, 33.67825], [-117.58996, 33.67822], [-117.58984, 33.67353], [-117.58986, 33.67178], [-117.59522, 33.6718], [-117.59706, 33.67178], [-117.59708, 33.6737], [-117.59716, 33.67436], [-117.5972, 33.67495]]]} | No Public Access 3 | 44353 | Trabuco Canyon | 32328 | 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 | Orange 3 | 112.275 | Trabuco Canyon | 0 | State Resource Management Area 55 | 3 | |
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | 44356 | Escondido Creek | 32162 | 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 Diego 4 | 29.504 | Escondido Creek | 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 | |
4051 | 4051 | 4050 | {"type": "Polygon", "coordinates": [[[-121.27961, 39.22337], [-121.27958, 39.22694], [-121.2796, 39.22999], [-121.27914, 39.22898], [-121.27879, 39.22844], [-121.27823, 39.22799], [-121.27781, 39.22703], [-121.27639, 39.22608], [-121.27591, 39.22485], [-121.27507, 39.22354], [-121.27479, 39.22338], [-121.27342, 39.224], [-121.27329, 39.22399], [-121.27173, 39.22401], [-121.2705, 39.22417], [-121.27039, 39.22416], [-121.27084, 39.22377], [-121.27139, 39.22335], [-121.27327, 39.22335], [-121.27325, 39.2197], [-121.27353, 39.2197], [-121.2746, 39.21575], [-121.27954, 39.21525], [-121.27961, 39.22337]]]} | No Public Access 3 | 44339 | 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 | Nevada 30 | 150.794 | Lower Yuba River | 0 | State Resource Management Area 55 | 3 | |
4842 | 4842 | 4841 | {"type": "Polygon", "coordinates": [[[-122.70265, 38.97554], [-122.70213, 38.97651], [-122.7016, 38.97676], [-122.7006, 38.97679], [-122.70085, 38.97617], [-122.70146, 38.9756], [-122.70265, 38.97554]]]} | No Public Access 3 | 2140 | Monitor Island | 32231 | 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 | Lake 40 | 3.761 | Monitor Island | 0 | State Resource Management Area 55 | 3 | |
5105 | 5105 | 5104 | {"type": "Polygon", "coordinates": [[[-123.68414, 40.48042], [-123.67906, 40.48126], [-123.66993, 40.48271], [-123.67004, 40.47815], [-123.6746, 40.47741], [-123.67492, 40.47444], [-123.67959, 40.47359], [-123.67921, 40.47671], [-123.68403, 40.47602], [-123.68414, 40.48042]]]} | No Public Access 3 | 48240 | McClellan Mountain Peatland | 32798 | 212 | California Wildlife Conservation Board 766 | State 5 | State Agency 5 | http://www.wcb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 180.409 | McClellan Mtn. Peatland | 2017 | State Resource Management Area 55 | 3 | |
5245 | 5245 | 5244 | {"type": "Polygon", "coordinates": [[[-122.52297, 41.8958], [-122.52259, 41.89608], [-122.52198, 41.89642], [-122.5213, 41.89687], [-122.52065, 41.89629], [-122.52078, 41.89611], [-122.52229, 41.89521], [-122.52297, 41.8958]]]} | No Public Access 3 | 1341 | Klamathon Station | 32197 | 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 | Siskiyou 28 | 4.018 | Klamathon Station | 0 | State Resource Management Area 55 | 3 | |
5300 | 5300 | 5299 | {"type": "MultiPolygon", "coordinates": [[[[-121.18376, 38.65361], [-121.18399, 38.65391], [-121.18416, 38.6543], [-121.18413, 38.65478], [-121.1838, 38.65551], [-121.18292, 38.65658], [-121.18294, 38.65671], [-121.18263, 38.65677], [-121.18258, 38.65676], [-121.18253, 38.65672], [-121.18241, 38.65632], [-121.18252, 38.6563], [-121.18297, 38.65581], [-121.18297, 38.65579], [-121.18327, 38.65543], [-121.18339, 38.65523], [-121.18347, 38.65505], [-121.18351, 38.65489], [-121.18353, 38.65459], [-121.18351, 38.65442], [-121.18347, 38.65426], [-121.18341, 38.65411], [-121.18332, 38.65395], [-121.18376, 38.65361]]], [[[-121.1775, 38.65766], [-121.17724, 38.65766], [-121.17681, 38.65767], [-121.17695, 38.6573], [-121.17699, 38.65723], [-121.17727, 38.6573], [-121.1775, 38.65766]]], [[[-121.18181, 38.6564], [-121.18133, 38.65641], [-121.18118, 38.65638], [-121.18154, 38.65764], [-121.17965, 38.65765], [-121.17951, 38.65699], [-121.17964, 38.65691], [-121.17978, 38.6568], [-121.17998, 38.65658], [-121.18023, 38.6566], [-121.18049, 38.65647], [-121.18085, 38.65634], [-121.18106, 38.65628], [-121.18174, 38.65614], [-121.18181, 38.6564]]], [[[-121.16883, 38.65782], [-121.16836, 38.65788], [-121.16795, 38.65796], [-121.1624, 38.65959], [-121.16182, 38.65971], [-121.16065, 38.65986], [-121.16031, 38.65992], [-121.15986, 38.66003], [-121.1592, 38.66024], [-121.15812, 38.66065], [-121.15819, 38.66028], [-121.15832, 38.65994], [-121.15854, 38.65957], [-121.15879, 38.65927], [-121.1591, 38.659], [-121.15945, 38.65877], [-121.15984, 38.65858], [-121.16031, 38.65842], [-121.1607, 38.65833], [-121.16104, 38.65829], [-121.16214, 38.65827], [-121.16277, 38.65822], [-121.1634, 38.65812], [-121.16389, 38.65802], [-121.16461, 38.65781], [-121.16519, 38.65759], [-121.16574, 38.65734], [-121.16634, 38.657], [-121.16673, 38.65683], [-121.1672, 38.6567], [-121.16753, 38.65664], [-121.1678, 38.65661], [-121.16833, 38.65659], [-121.1684, 38.65662], [-121.16854, 38.65713], [-121.16883, 38.65782]]], [[[-121.17581, 38.6616], [-121.17428, 38.66147], [-121.17177, 38.65885], [-121.17157, 38.65867], [-121.1714, 38.65854], [-121.17118, 38.65839], [-121.17093, 38.65825], [-121.17067, 38.65813], [-121.1704, 38.65803], [-121.16989, 38.6579], [-121.16954, 38.65784], [-121.16927, 38.65782], [-121.16894, 38.65702], [-121.16886, 38.65674], [-121.16884, 38.65663], [-121.16885, 38.65659], [-121.16892, 38.65655], [-121.1708, 38.65644], [-121.17123, 38.65639], [-121.17176, 38.65628], [-121.17197, 38.65661], [-121.17204, 38.65701], [-121.17178, 38.65703], [-121.17187, 38.65762], [-121.17193, 38.6577], [-121.17199, 38.65773], [-121.17206, 38.65774], [-121.17272, 38.65767], [-121.17294, 38.65768], [-121.1731, 38.65773], [-121.17393, 38.65813], [-121.17408, 38.65817], [-121.1742, 38.65817], [-121.17433, 38.65815], [-121.17525, 38.65775], [-121.17525, 38.65774], [-121.17491, 38.65778], [-121.17502, 38.65771], [-121.17522, 38.65753], [-121.17547, 38.65753], [-121.17523, 38.65863], [-121.17581, 38.6616]]]]} | No Public Access 3 | 5033 | Willow Creek | 32350 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Willow-Creek-WA | Sacramento 41 | 78.145 | Willow Creek | 0 | State Resource Management Area 55 | 3 |
5461 | 5461 | 5460 | {"type": "Polygon", "coordinates": [[[-121.92008, 41.91622], [-121.91521, 41.91623], [-121.91508, 41.91209], [-121.91028, 41.91215], [-121.91043, 41.91631], [-121.9057, 41.91629], [-121.90546, 41.90908], [-121.91976, 41.90901], [-121.92008, 41.91622]]]} | No Public Access 3 | 6269 | Cedar Point | 32109 | 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 | Siskiyou 28 | 190.648 | Cedar Point | 0 | State Resource Management Area 55 | 3 | |
5484 | 5484 | 5483 | {"type": "Polygon", "coordinates": [[[-121.45171, 37.99673], [-121.45157, 37.99753], [-121.45125, 37.99803], [-121.44772, 37.99697], [-121.449, 37.99516], [-121.45045, 37.99469], [-121.45112, 37.99482], [-121.4517, 37.99592], [-121.45175, 37.99649], [-121.45171, 37.99673]]]} | No Public Access 3 | 18030 | Acker Island | 32009 | 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 Joaquin 39 | 20.966 | Acker Island | 0 | State Resource Management Area 55 | 3 | |
5734 | 5734 | 5733 | {"type": "Polygon", "coordinates": [[[-121.70367, 39.80488], [-121.70358, 39.8067], [-121.69866, 39.8105], [-121.69855, 39.81401], [-121.69396, 39.81401], [-121.69395, 39.81215], [-121.69416, 39.80653], [-121.69368, 39.80652], [-121.68461, 39.80657], [-121.68726, 39.80502], [-121.70367, 39.80488]]]} | No Public Access 3 | 1651 | Little Chico Canyon | 32204 | 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 | Butte 42 | 170.568 | Little Chico Canyon | 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 |
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]);