units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where ACCESS_TYP = 2, GAP_STS = 3 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_NAME, AGNCY_TYP, LAYER, MNG_AG_ID, MNG_AG_LEV, COUNTY
MNG_AGENCY 8
- California Department of Fish and Wildlife 4
- California State Lands Commission 3
- East Bay Regional Park District 2
- Los Angeles, County of 1
- San Francisco - Public Utilities Commission, City and County of 1
- United States National Park Service 1
- United States Army Corps of Engineers 1
- United States Bureau of Reclamation 1
MNG_AG_TYP 5
DES_TP 5
ACCESS_TYP 1
- Restricted Access · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2179 | 2179 | 2178 | {"type": "MultiPolygon", "coordinates": [[[[-120.31591, 36.61029], [-120.31586, 36.61748], [-120.30679, 36.61751], [-120.30685, 36.61383], [-120.30671, 36.6103], [-120.31591, 36.61029]]], [[[-120.3341, 36.59922], [-120.3341, 36.60278], [-120.33176, 36.60272], [-120.32724, 36.60271], [-120.32502, 36.60268], [-120.32502, 36.59918], [-120.32724, 36.59925], [-120.3295, 36.59918], [-120.33176, 36.59918], [-120.3341, 36.59922]]], [[[-120.36989, 36.6905], [-120.36959, 36.70536], [-120.36101, 36.70528], [-120.36105, 36.70455], [-120.3532, 36.69044], [-120.36989, 36.6905]]]]} | Restricted Access 2 | 16330 | Tranquillity Land Retirement Demonstration Site | 26514 | 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 | Fresno 9 | 690.07 | Tranquillity Land Retirement Demonstration Site | 0 | Research or Educational Area 180 | 3 | |
3285 | 3285 | 3284 | {"type": "Polygon", "coordinates": [[[-120.0828, 38.3461], [-120.08263, 38.35322], [-120.08006, 38.35324], [-120.0736, 38.35313], [-120.07364, 38.35139], [-120.07808, 38.35147], [-120.07829, 38.34769], [-120.07828, 38.34768], [-120.07372, 38.34762], [-120.07376, 38.346], [-120.0828, 38.3461]]]} | Restricted Access 2 | 23368 | Sands Meadow | 25024 | 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 | Tuolumne 21 | 114.054 | Sands Meadow | 0 | State Resource Management Area 55 | 3 | |
3690 | 3690 | 3689 | {"type": "MultiPolygon", "coordinates": [[[[-118.78035, 34.10396], [-118.77186, 34.10401], [-118.77183, 34.10033], [-118.77606, 34.10036], [-118.77603, 34.09674], [-118.78033, 34.09684], [-118.78035, 34.10396]]], [[[-118.85677, 34.05632], [-118.85451, 34.05633], [-118.8545, 34.05498], [-118.85676, 34.05494], [-118.85677, 34.05632]]], [[[-118.85887, 34.05446], [-118.85783, 34.05448], [-118.85782, 34.05273], [-118.85886, 34.05271], [-118.85887, 34.05446]]]]} | Restricted Access 2 | 44435 | Santa Monica Mountains National Recreation Area | 29658 | 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/samo/index.htm | Los Angeles 6 | 129.308 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
4840 | 4840 | 4839 | {"type": "Polygon", "coordinates": [[[-121.86466, 37.49523], [-121.86362, 37.49944], [-121.86365, 37.50092], [-121.8629, 37.50172], [-121.86226, 37.50343], [-121.86265, 37.50433], [-121.86196, 37.50649], [-121.85999, 37.50648], [-121.8428, 37.5063], [-121.84273, 37.49844], [-121.84258, 37.49107], [-121.84714, 37.49119], [-121.84729, 37.48771], [-121.85157, 37.48778], [-121.85164, 37.48476], [-121.85601, 37.48478], [-121.85594, 37.48769], [-121.85582, 37.49136], [-121.85565, 37.49892], [-121.86005, 37.49904], [-121.8601, 37.49519], [-121.86466, 37.49523]]]} | Restricted Access 2 | 48975 | SFPUC Alameda Watershed | 33672 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | Alameda 17 | 750.711 | SFPUC Alameda Watershed | 0 | Local Resource Management Area 83 | 3 | |
5599 | 5599 | 5598 | {"type": "Polygon", "coordinates": [[[-121.47811, 37.34772], [-121.47387, 37.3477], [-121.46884, 37.34757], [-121.46895, 37.33318], [-121.46053, 37.33314], [-121.46052, 37.33308], [-121.4511, 37.33303], [-121.4422, 37.33311], [-121.44212, 37.3367], [-121.43286, 37.33679], [-121.43288, 37.33629], [-121.43285, 37.33628], [-121.43278, 37.33294], [-121.4237, 37.33291], [-121.42378, 37.32944], [-121.44188, 37.3294], [-121.44189, 37.32584], [-121.43282, 37.32592], [-121.43304, 37.31848], [-121.43306, 37.30399], [-121.44215, 37.30401], [-121.45398, 37.30406], [-121.46945, 37.3042], [-121.46948, 37.31146], [-121.47544, 37.3115], [-121.47528, 37.327], [-121.47514, 37.32718], [-121.4748, 37.3277], [-121.47471, 37.3279], [-121.4747, 37.32801], [-121.47473, 37.32924], [-121.47478, 37.3295], [-121.47473, 37.32951], [-121.47529, 37.33069], [-121.47621, 37.33255], [-121.47625, 37.33392], [-121.47643, 37.33555], [-121.47612, 37.3369], [-121.47647, 37.33844], [-121.477, 37.33945], [-121.47769, 37.3407], [-121.47786, 37.34295], [-121.47808, 37.34527], [-121.47767, 37.34679], [-121.47766, 37.34708], [-121.47811, 37.34772]]]} | Restricted Access 2 | 20680 | San Antonio Valley | 24836 | 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 | 3259.009 | San Antonio Valley | 0 | State Resource Management Area 55 | 3 | |
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 |
7289 | 7289 | 7288 | {"type": "MultiPolygon", "coordinates": [[[[-118.06004, 34.01551], [-118.05873, 34.0164], [-118.05805, 34.01692], [-118.0576, 34.0173], [-118.05827, 34.01767], [-118.05897, 34.01802], [-118.05747, 34.01907], [-118.05703, 34.01992], [-118.05593, 34.02051], [-118.0549, 34.02084], [-118.05395, 34.02158], [-118.05387, 34.02199], [-118.05295, 34.02135], [-118.05295, 34.02132], [-118.05137, 34.02026], [-118.05138, 34.02024], [-118.05053, 34.01967], [-118.0522, 34.01846], [-118.05317, 34.01829], [-118.05338, 34.01842], [-118.054, 34.01837], [-118.05434, 34.01784], [-118.0559, 34.01773], [-118.0575, 34.01641], [-118.05641, 34.01534], [-118.05752, 34.01455], [-118.05859, 34.01559], [-118.05927, 34.01514], [-118.06004, 34.01551]]], [[[-118.07861, 34.01711], [-118.07843, 34.01748], [-118.07832, 34.01765], [-118.07816, 34.01788], [-118.07791, 34.01819], [-118.07766, 34.01848], [-118.07744, 34.01869], [-118.0769, 34.01914], [-118.07637, 34.01948], [-118.07315, 34.02126], [-118.07286, 34.02143], [-118.07234, 34.02179], [-118.07178, 34.02229], [-118.0715, 34.02259], [-118.07118, 34.023], [-118.07101, 34.02324], [-118.06794, 34.02829], [-118.06785, 34.02831], [-118.06734, 34.02812], [-118.06696, 34.02802], [-118.06645, 34.02795], [-118.05777, 34.02462], [-118.05458, 34.02336], [-118.05406, 34.02414], [-118.0539, 34.02251], [-118.05402, 34.02209], [-118.05438, 34.02235], [-118.05503, 34.02278], [-118.05571, 34.02199], [-118.05622, 34.0217], [-118.05671, 34.02154], [-118.0612, 34.02141], [-118.06117, 34.02082], [-118.06902, 34.02046], [-118.06905, 34.02101], [-118.07253, 34.02084], [-118.07409, 34.02003], [-118.07431, 34.02006], [-118.07583, 34.01928], [-118.07629, 34.01901], [-118.07663, 34.01877], [-118.07688, 34.01858], [-118.07712, 34.01838], [-118.07748, 34.01803], [-118.0779, 34.01751], [-118.07825, 34.01698], [-118.07858, 34.01705], [-118.07861, 34.01711]]], [[[-118.061, 34.01708], [-118.06078, 34.01739], [-118.06049, 34.01666], [-118.06078, 34.01689], [-118.061, 34.01708]]], [[[-118.08765, 34.02294], [-118.08759, 34.02301], [-118.08732, 34.02322], [-118.08691, 34.02347], [-118.086, 34.02381], [-118.08518, 34.02419], [-118.08318, 34.02537], [-118.08275, 34.02555], [-118.08236, 34.02565], [-118.08211, 34.02568], [-118.08176, 34.02568], [-118.08063, 34.02561], [-118.07954, 34.02604], [-118.07683, 34.02666], [-118.0758, 34.02683], [-118.07506, 34.02709], [-118.07491, 34.02727], [-118.07484, 34.02752], [-118.07463, 34.02807], [-118.07407, 34.02903], [-118.07397, 34.02927], [-118.07388, 34.02937], [-118.07209, 34.02923], [-118.07201, 34.02963], [-118.07129, 34.02955], [-118.07151, 34.02914], [-118.07279, 34.02772], [-118.07565, 34.0256], [-118.07771, 34.02455], [-118.07809, 34.02411], [-118.07806, 34.02411], [-118.07769, 34.02454], [-118.07562, 34.02558], [-118.07277, 34.0277], [-118.07148, 34.02913], [-118.07125, 34.02954], [-118.07048, 34.02946], [-118.06906, 34.02892], [-118.06911, 34.02881], [-118.06831, 34.0285], [-118.06828, 34.02844], [-118.07138, 34.02337], [-118.07188, 34.02273], [-118.07241, 34.02222], [-118.07283, 34.02189], [-118.07328, 34.02159], [-118.07651, 34.0198], [-118.0769, 34.01956], [-118.07735, 34.01924], [-118.07785, 34.0188], [-118.07822, 34.0184], [-118.07842, 34.01815], [-118.07872, 34.01772], [-118.07888, 34.01744], [-118.07908, 34.01704], [-118.08031, 34.01676], [-118.07951, 34.017], [-118.07938, 34.01705], [-118.07918, 34.01749], [-118.07892, 34.01793], [-118.07893, 34.01794], [-118.07958, 34.01783], [-118.08009, 34.01779], [-118.08078, 34.0178], [-118.08127, 34.01786], [-118.08179, 34.01797], [-118.08204, 34.01804], [-118.08267, 34.01828], [-118.08318, 34.01854], [-118.08365, 34.01886], [-118.08493, 34.01795], [-118.08599, 34.019], [-118.08475, 34.01988], [-118.08504, 34.0202], [-118.08531, 34.02055], [-118.08551, 34.02088], [-118.08549, 34.0209], [-118.08553, 34.02092], [-118.08567, 34.02118], [-118.08582, 34.02151], [-118.08594, 34.02187], [-118.08602, 34.02218], [-118.08572, 34.02214], [-118.0858, 34.02267], [-118.08609, 34.02274], [-118.08612, 34.02311], [-118.08728, 34.02311], [-118.08744, 34.02298], [-118.08754, 34.02288], [-118.08765, 34.02294]]], [[[-118.07973, 34.01611], [-118.07954, 34.01674], [-118.07924, 34.01681], [-118.07921, 34.0168], [-118.0792, 34.01676], [-118.07931, 34.01638], [-118.07934, 34.01637], [-118.07936, 34.01633], [-118.07933, 34.01631], [-118.07936, 34.01624], [-118.07946, 34.01618], [-118.07973, 34.01611]]], [[[-118.08786, 34.02308], [-118.08756, 34.02334], [-118.08718, 34.02359], [-118.08683, 34.02375], [-118.08612, 34.02401], [-118.08548, 34.02438], [-118.08553, 34.02444], [-118.08495, 34.02492], [-118.0853, 34.02531], [-118.08535, 34.02563], [-118.08466, 34.02594], [-118.08411, 34.02502], [-118.08516, 34.0244], [-118.08556, 34.02419], [-118.08598, 34.02401], [-118.08684, 34.02369], [-118.08711, 34.02357], [-118.08748, 34.02334], [-118.08781, 34.02305], [-118.08786, 34.02308]]]]} | Restricted Access 2 | 6568 | Whittier Narrows Dam | 27479 | 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 | 568.969 | Whittier Narrows Dam | 0 | Resource Management Area 82 | 3 | |
7544 | 7544 | 7543 | {"type": "Polygon", "coordinates": [[[-122.26096, 37.96074], [-122.26068, 37.96086], [-122.2605, 37.96097], [-122.26032, 37.96109], [-122.26017, 37.96122], [-122.26003, 37.96137], [-122.25992, 37.96152], [-122.25947, 37.96216], [-122.25935, 37.96227], [-122.25923, 37.96234], [-122.25911, 37.96238], [-122.25547, 37.96311], [-122.25517, 37.9632], [-122.25478, 37.96335], [-122.25275, 37.95999], [-122.25186, 37.96017], [-122.24908, 37.95619], [-122.24757, 37.95482], [-122.25188, 37.95185], [-122.26096, 37.96074]]]} | Restricted Access 2 | 47610 | Bay Area Ridge Trail Land Bank | 31342 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 166.102 | Bay Area Ridge Trail Land Bank | 0 | Local Resource Management Area 83 | 3 | |
10369 | 10369 | 10368 | {"type": "Polygon", "coordinates": [[[-121.73098, 38.00441], [-121.73064, 38.0048], [-121.73007, 38.00476], [-121.73001, 38.00463], [-121.72957, 38.00478], [-121.72957, 38.00463], [-121.72949, 38.00435], [-121.72888, 38.00407], [-121.72775, 38.00355], [-121.72714, 38.00337], [-121.72646, 38.00321], [-121.72603, 38.00306], [-121.72553, 38.00283], [-121.72515, 38.00269], [-121.72473, 38.00262], [-121.72411, 38.00265], [-121.7237, 38.00275], [-121.72337, 38.00287], [-121.72318, 38.0029], [-121.7232, 38.00179], [-121.73098, 38.00441]]]} | Restricted Access 2 | 18303 | Oakley (Legless Lizard) Land Bank | 23030 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 7.851 | Oakley (Legless Lizard) Land Bank | 0 | Local Resource Management Area 83 | 3 | |
12572 | 12572 | 12571 | {"type": "Polygon", "coordinates": [[[-117.69973, 33.97316], [-117.6997, 33.97405], [-117.6991, 33.97403], [-117.6991, 33.97333], [-117.69894, 33.97306], [-117.69971, 33.97306], [-117.69971, 33.97316], [-117.69973, 33.97316]]]} | Restricted Access 2 | 29090 | Chino Fish & Wildlife Base | 17207 | 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 | 1.585 | Chino Fish & Wildlife Base | 0 | State Resource Management Area 55 | 3 | |
14330 | 14330 | 14329 | {"type": "Polygon", "coordinates": [[[-121.35088, 40.9054], [-121.35078, 40.90893], [-121.34677, 40.90892], [-121.34658, 40.91981], [-121.34648, 40.91985], [-121.33442, 40.91971], [-121.33131, 40.91966], [-121.33175, 40.90581], [-121.33418, 40.90581], [-121.33418, 40.90513], [-121.35088, 40.9054]]]} | Restricted Access 2 | 44318 | California State Lands Commission | 16725 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Shasta 27 | 539.61 | SLC | 0 | State Resource Management Area 55 | 3 | |
14618 | 14618 | 14617 | {"type": "Polygon", "coordinates": [[[-115.71453, 35.03003], [-115.71447, 35.04386], [-115.69802, 35.04386], [-115.69803, 35.03], [-115.71453, 35.03003]]]} | Restricted Access 2 | 44845 | California State Lands Commission | 16725 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | San Bernardino 22 | 570.632 | SLC | 0 | State Resource Management Area 55 | 3 | |
14659 | 14659 | 14658 | {"type": "MultiPolygon", "coordinates": [[[[-118.941, 35.42402], [-118.94048, 35.42386], [-118.94016, 35.42372], [-118.9391, 35.42317], [-118.93871, 35.42304], [-118.93844, 35.423], [-118.93803, 35.42298], [-118.93734, 35.42304], [-118.93692, 35.42306], [-118.9365, 35.42306], [-118.93576, 35.42302], [-118.93528, 35.42301], [-118.9348, 35.42302], [-118.93432, 35.42305], [-118.93431, 35.4198], [-118.94097, 35.41976], [-118.941, 35.42402]]], [[[-118.941, 35.42419], [-118.941, 35.42531], [-118.93974, 35.42582], [-118.93948, 35.4254], [-118.93905, 35.42554], [-118.93874, 35.42561], [-118.937, 35.42582], [-118.93641, 35.42595], [-118.93585, 35.42613], [-118.93532, 35.42637], [-118.93499, 35.42656], [-118.93433, 35.42702], [-118.93432, 35.42322], [-118.9348, 35.42319], [-118.93527, 35.42317], [-118.93575, 35.42318], [-118.93649, 35.42323], [-118.93692, 35.42323], [-118.93736, 35.42321], [-118.93804, 35.42314], [-118.93829, 35.42315], [-118.93854, 35.42318], [-118.93878, 35.42323], [-118.93901, 35.42331], [-118.9399, 35.42379], [-118.94025, 35.42395], [-118.94062, 35.42408], [-118.941, 35.42419]]]]} | Restricted Access 2 | 44922 | Bakersfield | 15768 | 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 | 98.585 | Bakersfield | 0 | State Resource Management Area 55 | 3 | |
16881 | 16881 | 16880 | {"type": "MultiPolygon", "coordinates": [[[[-115.79985, 33.6134], [-115.78249, 33.61336], [-115.7825, 33.59883], [-115.79899, 33.59889], [-115.79984, 33.59912], [-115.79985, 33.6134]]], [[[-115.83435, 33.4331], [-115.83435, 33.43422], [-115.83008, 33.43422], [-115.82992, 33.42706], [-115.83034, 33.42706], [-115.83435, 33.4331]]]]} | Restricted Access 2 | 44324 | California State Lands Commission | 16725 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Riverside 10 | 688.953 | SLC | 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]);