units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
54 rows where DES_TP = 39 and MNG_AGENCY = 25 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency 47
MNG_AGENCY 1
- California Department of Fish and Wildlife · 47 ✖
DES_TP 1
- State Recreation Area · 47 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10251 | 10251 | 10250 | {"type": "Polygon", "coordinates": [[[-122.3605, 40.5364], [-122.35803, 40.5383], [-122.3578, 40.53844], [-122.35758, 40.53825], [-122.35701, 40.53737], [-122.36041, 40.53623], [-122.3605, 40.5364]]]} | Open Access 1 | 17970 | Bonnyview Road Fishing Access | 32064 | 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 | 6.224 | Bonnyview Road FA | 0 | State Recreation Area 39 | 4 | |
15595 | 15595 | 15594 | {"type": "MultiPolygon", "coordinates": [[[[-121.68867, 38.1275], [-121.68824, 38.12823], [-121.68816, 38.12841], [-121.68798, 38.1287], [-121.68785, 38.12897], [-121.68754, 38.12941], [-121.68728, 38.1298], [-121.68701, 38.13033], [-121.68702, 38.13034], [-121.68706, 38.13035], [-121.68718, 38.13022], [-121.68731, 38.13013], [-121.68731, 38.13025], [-121.68714, 38.13082], [-121.68674, 38.13287], [-121.68666, 38.13305], [-121.68649, 38.13315], [-121.68632, 38.13314], [-121.68623, 38.1332], [-121.68621, 38.13383], [-121.686, 38.13383], [-121.68599, 38.13345], [-121.686, 38.13318], [-121.68608, 38.13262], [-121.68618, 38.13226], [-121.68662, 38.13085], [-121.68679, 38.13039], [-121.68701, 38.12992], [-121.68765, 38.12883], [-121.6877, 38.12882], [-121.68848, 38.12743], [-121.68867, 38.1275]]], [[[-121.69005, 38.12496], [-121.69001, 38.1252], [-121.68961, 38.12519], [-121.68986, 38.12492], [-121.69005, 38.12496]]]]} | Open Access 1 | 18062 | Brannan Island Fishing Access | 32066 | 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 | Sacramento 41 | 6.245 | Brannan Island FA | 0 | State Recreation Area 39 | 4 | |
9810 | 9810 | 9809 | {"type": "Polygon", "coordinates": [[[-122.91431, 39.14814], [-122.91237, 39.1479], [-122.91249, 39.14739], [-122.91343, 39.14744], [-122.91384, 39.14771], [-122.91431, 39.14814]]]} | Open Access 1 | 18106 | Bridge Arbor Fishing Access | 32067 | 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 | 1.998 | Bridge Arbor FA | 0 | State Recreation Area 39 | 4 | |
3286 | 3286 | 3285 | {"type": "Polygon", "coordinates": [[[-122.31276, 38.91619], [-122.30056, 38.91633], [-122.30018, 38.91044], [-122.30064, 38.91037], [-122.30093, 38.9103], [-122.30254, 38.90997], [-122.30296, 38.90992], [-122.30356, 38.90991], [-122.30391, 38.90996], [-122.30423, 38.91005], [-122.30598, 38.91071], [-122.30669, 38.91102], [-122.30716, 38.91107], [-122.30751, 38.91104], [-122.30761, 38.91103], [-122.30833, 38.91081], [-122.30868, 38.91064], [-122.30877, 38.91057], [-122.3089, 38.91042], [-122.30904, 38.9103], [-122.30907, 38.91024], [-122.30929, 38.90996], [-122.30929, 38.90988], [-122.3096, 38.90939], [-122.30981, 38.9092], [-122.31013, 38.90898], [-122.31036, 38.90884], [-122.31044, 38.90882], [-122.31061, 38.90873], [-122.31088, 38.90866], [-122.31144, 38.9086], [-122.312, 38.90866], [-122.31239, 38.90877], [-122.31264, 38.90888], [-122.31273, 38.90893], [-122.31276, 38.91619]]]} | Open Access 1 | 23563 | Cache Creek Public Access | 32077 | 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 | Yolo 33 | 184.731 | Cache Creek PA | 0 | State Recreation Area 39 | 4 | |
11264 | 11264 | 11263 | {"type": "Polygon", "coordinates": [[[-121.52329, 38.38223], [-121.51986, 38.38421], [-121.51959, 38.38389], [-121.52311, 38.38198], [-121.52329, 38.38223]]]} | Open Access 1 | 25906 | Clarksburg Fishing Access | 32116 | 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 | Yolo 33 | 3.405 | Clarksburg FA | 0 | State Recreation Area 39 | 4 | |
4862 | 4862 | 4861 | {"type": "Polygon", "coordinates": [[[-121.66948, 38.16979], [-121.66941, 38.16983], [-121.66936, 38.16994], [-121.66935, 38.17035], [-121.66932, 38.17042], [-121.66873, 38.17075], [-121.66858, 38.17088], [-121.66823, 38.17112], [-121.66788, 38.17132], [-121.66746, 38.17165], [-121.66698, 38.17205], [-121.66674, 38.17196], [-121.66754, 38.1713], [-121.66837, 38.17043], [-121.66914, 38.16955], [-121.66948, 38.16979]]]} | Open Access 1 | 22113 | Cliff House Fishing Access | 32119 | 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 | Sacramento 41 | 3.203 | Cliff House FA | 0 | State Recreation Area 39 | 4 | |
7436 | 7436 | 7435 | {"type": "Polygon", "coordinates": [[[-120.55936, 36.14655], [-120.55484, 36.14658], [-120.55048, 36.14653], [-120.54144, 36.14651], [-120.54142, 36.13932], [-120.55041, 36.13938], [-120.55925, 36.13938], [-120.55932, 36.14295], [-120.55936, 36.14655]]]} | Open Access 1 | 6994 | Coalinga Mineral Springs Public Access | 32124 | 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 | Fresno 9 | 316.828 | Coalinga Mineral Springs PA | 0 | State Recreation Area 39 | 4 | |
3284 | 3284 | 3283 | {"type": "Polygon", "coordinates": [[[-114.722, 33.08954], [-114.70844, 33.08952], [-114.70802, 33.08874], [-114.70769, 33.08819], [-114.70696, 33.08728], [-114.70612, 33.08661], [-114.70461, 33.08633], [-114.7046, 33.08105], [-114.71315, 33.08099], [-114.71309, 33.075], [-114.72176, 33.07503], [-114.722, 33.08954]]]} | Open Access 1 | 23367 | Colorado River Access | 32132 | 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 | 488.822 | Colorado River Access | 0 | State Recreation Area 39 | 4 | |
7536 | 7536 | 7535 | {"type": "MultiPolygon", "coordinates": [[[[-120.4594, 36.09525], [-120.45884, 36.09971], [-120.45356, 36.09967], [-120.454, 36.096], [-120.45465, 36.09599], [-120.45495, 36.09613], [-120.45535, 36.09628], [-120.4556, 36.09628], [-120.45586, 36.09634], [-120.45597, 36.09635], [-120.45623, 36.09634], [-120.45653, 36.09626], [-120.45684, 36.09612], [-120.45705, 36.096], [-120.45847, 36.09601], [-120.45855, 36.09539], [-120.4594, 36.09525]]], [[[-120.4602, 36.08884], [-120.45943, 36.09501], [-120.45866, 36.09511], [-120.45891, 36.09249], [-120.45453, 36.09211], [-120.45494, 36.08881], [-120.4602, 36.08884]]]]} | Open Access 1 | 7116 | Curry Mountain Public Access | 32142 | 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 | Fresno 9 | 98.979 | Curry Mtn. PA | 0 | State Recreation Area 39 | 4 | |
11467 | 11467 | 11466 | {"type": "Polygon", "coordinates": [[[-122.80585, 40.71739], [-122.80501, 40.71749], [-122.80433, 40.7175], [-122.80228, 40.7173], [-122.80209, 40.71687], [-122.80259, 40.71646], [-122.80453, 40.71712], [-122.80523, 40.71718], [-122.80585, 40.71739]]]} | Open Access 1 | 29196 | Deadwood Hole Fishing Access | 32145 | 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 | Trinity 46 | 4.23 | Deadwood Hole FA | 0 | State Recreation Area 39 | 4 | |
12280 | 12280 | 12279 | {"type": "Polygon", "coordinates": [[[-122.01675, 39.96925], [-122.01628, 39.96961], [-122.0158, 39.96979], [-122.01445, 39.96984], [-122.01447, 39.9697], [-122.01532, 39.96964], [-122.01591, 39.96951], [-122.0165, 39.96916], [-122.01675, 39.96925]]]} | Open Access 1 | 25907 | Deer Creek Fishing Access | 32147 | 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 | 1.1 | Deer Creek FA | 0 | State Recreation Area 39 | 4 | |
11239 | 11239 | 11238 | {"type": "Polygon", "coordinates": [[[-120.22739, 39.32315], [-120.22725, 39.32342], [-120.22684, 39.32341], [-120.22659, 39.32344], [-120.22637, 39.32349], [-120.22597, 39.32363], [-120.22562, 39.32382], [-120.22154, 39.32332], [-120.2212, 39.32323], [-120.21896, 39.32296], [-120.21834, 39.323], [-120.21841, 39.32218], [-120.2203, 39.32236], [-120.22218, 39.3226], [-120.22366, 39.32287], [-120.22397, 39.32289], [-120.22465, 39.3229], [-120.22461, 39.32306], [-120.22416, 39.32346], [-120.22528, 39.3236], [-120.22543, 39.32361], [-120.22561, 39.32358], [-120.22616, 39.32339], [-120.22657, 39.32331], [-120.22655, 39.32317], [-120.22696, 39.32313], [-120.22739, 39.32315]]]} | Open Access 1 | 21595 | Donner Creek Public Access | 32150 | 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 | 12.262 | Donner Creek PA | 0 | State Recreation Area 39 | 4 | |
15605 | 15605 | 15604 | {"type": "Polygon", "coordinates": [[[-119.72836, 38.76932], [-119.72373, 38.76933], [-119.7237, 38.76577], [-119.72821, 38.76567], [-119.72836, 38.76932]]]} | Open Access 1 | 20782 | East Fork Carson River Fishing Access | 32153 | 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 | Alpine 51 | 39.271 | East Fork Carson River FA | 0 | State Recreation Area 39 | 4 | |
3144 | 3144 | 3143 | {"type": "Polygon", "coordinates": [[[-124.10173, 40.49177], [-124.09991, 40.49269], [-124.09979, 40.49248], [-124.1004, 40.49204], [-124.10081, 40.4918], [-124.1015, 40.49158], [-124.10173, 40.49177]]]} | Open Access 1 | 21596 | Eel River -- Rio Dell Fishing Access | 32156 | 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 | Humboldt 45 | 1.525 | Eel River -- Rio Dell FA | 0 | State Recreation Area 39 | 4 | |
7996 | 7996 | 7995 | {"type": "MultiPolygon", "coordinates": [[[[-120.84563, 37.61895], [-120.84545, 37.61903], [-120.84473, 37.62007], [-120.84403, 37.62084], [-120.84261, 37.62181], [-120.84163, 37.62226], [-120.84153, 37.62225], [-120.84196, 37.62189], [-120.84148, 37.62063], [-120.84163, 37.61955], [-120.84195, 37.61932], [-120.84163, 37.61895], [-120.8422, 37.61857], [-120.84301, 37.61756], [-120.84275, 37.61605], [-120.84369, 37.61618], [-120.84406, 37.61629], [-120.84379, 37.61775], [-120.8443, 37.61762], [-120.84492, 37.61786], [-120.84529, 37.61767], [-120.84563, 37.61895]]], [[[-120.85093, 37.61827], [-120.84939, 37.61906], [-120.84879, 37.61899], [-120.84793, 37.6187], [-120.84729, 37.61865], [-120.84609, 37.61872], [-120.84574, 37.61743], [-120.84684, 37.61692], [-120.84745, 37.61661], [-120.84873, 37.61675], [-120.84972, 37.6172], [-120.85027, 37.61796], [-120.85068, 37.6181], [-120.85055, 37.61819], [-120.85055, 37.61821], [-120.85093, 37.61827]]]]} | Open Access 1 | 468 | Fox Grove Fishing Access | 32167 | 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 | Stanislaus 2 | 51.641 | Fox Grove FA | 0 | State Recreation Area 39 | 4 | |
9817 | 9817 | 9816 | {"type": "Polygon", "coordinates": [[[-122.27189, 37.08629], [-122.27082, 37.08655], [-122.26904, 37.08506], [-122.2671, 37.08305], [-122.2636, 37.07903], [-122.2613, 37.07462], [-122.25781, 37.0704], [-122.2592, 37.0701], [-122.25927, 37.07039], [-122.25953, 37.07063], [-122.25925, 37.07061], [-122.25921, 37.07079], [-122.25898, 37.07083], [-122.25897, 37.07084], [-122.25928, 37.07133], [-122.25954, 37.07104], [-122.25993, 37.07115], [-122.25989, 37.07215], [-122.26018, 37.07244], [-122.2602, 37.07267], [-122.26029, 37.07277], [-122.26057, 37.07276], [-122.26087, 37.07295], [-122.26099, 37.07276], [-122.26135, 37.07274], [-122.26128, 37.07243], [-122.26164, 37.07233], [-122.26169, 37.07276], [-122.26166, 37.07326], [-122.262, 37.07327], [-122.26193, 37.0733], [-122.2623, 37.07348], [-122.26261, 37.07354], [-122.26268, 37.07375], [-122.26226, 37.07488], [-122.26225, 37.075], [-122.26231, 37.07498], [-122.26231, 37.075], [-122.26265, 37.07494], [-122.26263, 37.07499], [-122.26334, 37.07595], [-122.26366, 37.07647], [-122.26405, 37.0774], [-122.2655, 37.07818], [-122.26634, 37.07843], [-122.26636, 37.07848], [-122.26655, 37.07849], [-122.26726, 37.07833], [-122.26739, 37.07814], [-122.26752, 37.07747], [-122.26771, 37.07736], [-122.26794, 37.07741], [-122.26791, 37.07792], [-122.26778, 37.07828], [-122.26697, 37.07885], [-122.26698, 37.07897], [-122.26728, 37.07915], [-122.26764, 37.08005], [-122.26758, 37.08033], [-122.26758, 37.08056], [-122.26829, 37.0822], [-122.26862, 37.08277], [-122.26868, 37.0833], [-122.26903, 37.08387], [-122.26968, 37.08488], [-122.27002, 37.08526], [-122.27084, 37.08552], [-122.27146, 37.0858], [-122.27189, 37.08629]]]} | Open Access 1 | 25173 | Greyhound Rock Fishing Access | 32179 | 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 | 68.635 | Greyhound Rock FA | 0 | State Recreation Area 39 | 4 | |
8374 | 8374 | 8373 | {"type": "Polygon", "coordinates": [[[-121.08882, 40.26942], [-121.08854, 40.26983], [-121.08846, 40.27002], [-121.08842, 40.27082], [-121.08795, 40.27058], [-121.08782, 40.27074], [-121.08679, 40.27021], [-121.08692, 40.26987], [-121.08882, 40.26942]]]} | Open Access 1 | 7222 | Hamilton Branch Fishing Access | 32181 | 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 | Plumas 57 | 3.469 | Hamilton Branch FA | 0 | State Recreation Area 39 | 4 | |
1224 | 1224 | 1223 | {"type": "Polygon", "coordinates": [[[-122.86042, 38.59925], [-122.86034, 38.59981], [-122.86039, 38.60018], [-122.86041, 38.60169], [-122.85992, 38.60156], [-122.85954, 38.60002], [-122.85952, 38.60002], [-122.85941, 38.60012], [-122.85928, 38.59999], [-122.85995, 38.5991], [-122.86042, 38.59925]]]} | Open Access 1 | 8807 | Healdsburg Fishing Access | 32183 | 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.182 | Healdsburg FA | 0 | State Recreation Area 39 | 4 | |
2024 | 2024 | 2023 | {"type": "Polygon", "coordinates": [[[-122.37678, 38.2076], [-122.3765, 38.20788], [-122.37427, 38.20626], [-122.37478, 38.2058], [-122.37528, 38.20615], [-122.37569, 38.20667], [-122.37625, 38.20725], [-122.3765, 38.20744], [-122.37678, 38.2076]]]} | Open Access 1 | 17014 | Hudeman Slough Fishing Access | 32186 | 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 | 3.392 | Hudeman Slough FA | 1962 | State Recreation Area 39 | 4 | |
3951 | 3951 | 3950 | {"type": "MultiPolygon", "coordinates": [[[[-122.92088, 40.65941], [-122.90654, 40.65933], [-122.90652, 40.65755], [-122.90653, 40.65578], [-122.90892, 40.6558], [-122.90893, 40.65758], [-122.91198, 40.65759], [-122.91302, 40.65654], [-122.9133, 40.65678], [-122.91445, 40.6576], [-122.92086, 40.65764], [-122.92088, 40.65941]]], [[[-122.93008, 40.65443], [-122.93007, 40.65583], [-122.92977, 40.65583], [-122.92978, 40.65452], [-122.93008, 40.65443]]]]} | Open Access 1 | 1124 | Indian Creek Public Access | 32188 | 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 | Trinity 46 | 72.715 | Indian Creek PA | 0 | State Recreation Area 39 | 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]);