units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
109 rows where ACCESS_TYP = 2 and DES_TP = 8 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, LAYER, MNG_AG_ID, MNG_AG_LEV, YR_EST
MNG_AGENCY 7
MNG_AG_TYP 2
DES_TP 1
- State Conservation Area · 109 ✖
ACCESS_TYP 1
- Restricted Access · 109 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7537 | 7537 | 7536 | {"type": "Polygon", "coordinates": [[[-122.76295, 38.34753], [-122.76209, 38.34714], [-122.76092, 38.34616], [-122.76059, 38.34615], [-122.76022, 38.34574], [-122.76118, 38.34575], [-122.76295, 38.34753]]]} | Restricted Access 2 | 9392 | Theiller Sebastopol Meadowfoam Ecological Reserve | 26298 | 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 | 2.51 | Theiller Sebastopol Meadowfoam ER | 0 | State Conservation Area 8 | 2 | |
402 | 402 | 401 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | 1556 | Springville Ecological Reserve | 25751 | 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 | Tulare 29 | 4.947 | Springville ER | 0 | State Conservation Area 8 | 2 | |
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 |
10777 | 10777 | 10776 | {"type": "Polygon", "coordinates": [[[-121.86483, 36.60512], [-121.86235, 36.60664], [-121.86185, 36.60613], [-121.86192, 36.60536], [-121.86232, 36.60488], [-121.86287, 36.60459], [-121.86434, 36.60427], [-121.86483, 36.60512]]]} | Restricted Access 2 | 23364 | Del Monte Dunes Ecological Reserve | 18040 | 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 | Monterey 14 | 9.592 | Del Monte Dunes ER | 0 | State Conservation Area 8 | 2 | |
15628 | 15628 | 15627 | {"type": "Polygon", "coordinates": [[[-119.87533, 36.85429], [-119.87123, 36.85253], [-119.87062, 36.85148], [-119.87396, 36.85227], [-119.87533, 36.85429]]]} | Restricted Access 2 | 28125 | San Joaquin River Ecological Reserve | 24913 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Joaquin-River-ER | Fresno 9 | 10.874 | San Joaquin River ER | 1990 | State Conservation Area 8 | 2 |
15631 | 15631 | 15630 | {"type": "MultiPolygon", "coordinates": [[[[-118.42515, 33.98022], [-118.42488, 33.98042], [-118.42427, 33.98031], [-118.42454, 33.98011], [-118.42515, 33.98022]]], [[[-118.42921, 33.98035], [-118.42898, 33.98059], [-118.42873, 33.9809], [-118.42783, 33.98073], [-118.42828, 33.9807], [-118.42866, 33.98064], [-118.42887, 33.98056], [-118.42921, 33.98035]]], [[[-118.42901, 33.97746], [-118.42859, 33.97776], [-118.42826, 33.97724], [-118.42875, 33.97693], [-118.42887, 33.97722], [-118.42901, 33.97746]]], [[[-118.43285, 33.97662], [-118.43006, 33.98007], [-118.43, 33.9803], [-118.43002, 33.9806], [-118.4301, 33.98081], [-118.43018, 33.98095], [-118.43027, 33.98105], [-118.43049, 33.98123], [-118.43191, 33.9815], [-118.43208, 33.98162], [-118.43187, 33.98175], [-118.42892, 33.98119], [-118.43269, 33.97653], [-118.43285, 33.97662]], [[-118.43028, 33.98119], [-118.43029, 33.98117], [-118.43018, 33.98107], [-118.43009, 33.98096], [-118.42999, 33.98077], [-118.42993, 33.98058], [-118.42991, 33.98041], [-118.42992, 33.98028], [-118.42991, 33.98027], [-118.42941, 33.98086], [-118.42931, 33.981], [-118.43028, 33.98119]]], [[[-118.4323, 33.97539], [-118.42949, 33.97712], [-118.42928, 33.97727], [-118.42915, 33.97702], [-118.42904, 33.97676], [-118.42915, 33.97666], [-118.43197, 33.97484], [-118.4323, 33.97539]]]]} | Restricted Access 2 | 44627 | Ballona Wetlands Ecological Reserve | 15789 | 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 | Los Angeles 6 | 11.92 | Ballona Wetlands ER | 0 | State Conservation Area 8 | 2 | |
3672 | 3672 | 3671 | {"type": "MultiPolygon", "coordinates": [[[[-120.44871, 34.6888], [-120.44792, 34.69026], [-120.4478, 34.69035], [-120.44763, 34.69033], [-120.44725, 34.69018], [-120.44662, 34.68998], [-120.44669, 34.6899], [-120.44679, 34.6897], [-120.44724, 34.68935], [-120.44815, 34.68888], [-120.44871, 34.6888]]], [[[-120.4499, 34.69128], [-120.44987, 34.69127], [-120.44986, 34.69126], [-120.44856, 34.69068], [-120.44826, 34.69059], [-120.44812, 34.69043], [-120.44817, 34.69018], [-120.44916, 34.6887], [-120.44971, 34.68869], [-120.44982, 34.68905], [-120.45004, 34.69], [-120.45006, 34.69067], [-120.4499, 34.69128]]]]} | Restricted Access 2 | 29691 | Burton Mesa Ecological Reserve | 16533 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 11.989 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
16757 | 16757 | 16756 | {"type": "Polygon", "coordinates": [[[-121.80689, 38.88866], [-121.8054, 38.89105], [-121.80515, 38.89074], [-121.80516, 38.89056], [-121.8047, 38.88988], [-121.80428, 38.88934], [-121.80363, 38.88908], [-121.80241, 38.88865], [-121.80166, 38.88837], [-121.8014, 38.88823], [-121.80146, 38.88809], [-121.80169, 38.88805], [-121.80187, 38.888], [-121.80312, 38.88824], [-121.80392, 38.88848], [-121.80462, 38.88863], [-121.80528, 38.88858], [-121.80616, 38.88858], [-121.80689, 38.88866]]]} | Restricted Access 2 | 25313 | Collins Eddy Wildlife Area | 17521 | 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 | Sutter 47 | 12.4 | Collins Eddy Wildlife Area | 0 | State Conservation Area 8 | 2 | |
16787 | 16787 | 16786 | {"type": "Polygon", "coordinates": [[[-121.58877, 39.1692], [-121.58617, 39.16924], [-121.5864, 39.16725], [-121.58707, 39.16749], [-121.58709, 39.16749], [-121.58741, 39.16502], [-121.58877, 39.1692]]]} | Restricted Access 2 | 47980 | Feather River Wildlife Area | 18861 | 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 | 12.64 | Feather River Wildlife Area | 1991 | State Conservation Area 8 | 2 | |
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 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 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
8346 | 8346 | 8345 | {"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23079, 32.7932], [-117.23029, 32.79353], [-117.2303, 32.79356], [-117.23015, 32.79366], [-117.23009, 32.79379], [-117.23005, 32.79383], [-117.23004, 32.79417], [-117.23009, 32.79439], [-117.2301, 32.79484], [-117.23047, 32.79495], [-117.23076, 32.79592], [-117.23007, 32.79609], [-117.2299, 32.79556], [-117.22808, 32.79595], [-117.22756, 32.79426], [-117.22918, 32.79378], [-117.2293, 32.79327], [-117.23017, 32.79269], [-117.23073, 32.79196], [-117.23111, 32.79319]]]} | Restricted Access 2 | 48475 | Kendall Frost Mission Bay Marsh Reserve | 33187 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/kendall-frost-mission-bay-marsh-reserve/ | San Diego 4 | 16.556 | Kendall Frost Mission Bay Marsh Reserve | 0 | State Conservation Area 8 | 2 |
15547 | 15547 | 15546 | {"type": "Polygon", "coordinates": [[[-121.27537, 37.70038], [-121.27531, 37.70044], [-121.27489, 37.70053], [-121.27446, 37.70105], [-121.27439, 37.70129], [-121.27435, 37.70153], [-121.2743, 37.70169], [-121.273, 37.70334], [-121.27198, 37.7052], [-121.27185, 37.7052], [-121.27169, 37.70515], [-121.27161, 37.70499], [-121.27158, 37.70481], [-121.27177, 37.70237], [-121.27183, 37.70201], [-121.27198, 37.70166], [-121.2722, 37.70141], [-121.27359, 37.70014], [-121.27383, 37.69976], [-121.27395, 37.69929], [-121.27448, 37.69948], [-121.27471, 37.6995], [-121.27537, 37.70038]]]} | Restricted Access 2 | 47089 | Vernalis Ecological Reserve | 30745 | 219 | Central Valley Flood Protection Board 1027 | State 5 | State Agency 5 | http://www.cvfpb.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 20.58 | Vernalis ER | 0 | State Conservation Area 8 | 2 | |
15618 | 15618 | 15617 | {"type": "Polygon", "coordinates": [[[-117.10664, 33.07422], [-117.10657, 33.07428], [-117.10628, 33.07556], [-117.10504, 33.07516], [-117.1052, 33.07405], [-117.10423, 33.07384], [-117.10423, 33.07312], [-117.10319, 33.072], [-117.10339, 33.07187], [-117.10339, 33.07186], [-117.10243, 33.0711], [-117.10269, 33.07041], [-117.10371, 33.07007], [-117.10564, 33.07143], [-117.10596, 33.07398], [-117.10664, 33.07422]]]} | Restricted Access 2 | 23594 | Lake Hodges Ecological Reserve | 20894 | 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 | 24.606 | Lake Hodges ER | 0 | State Conservation Area 8 | 2 | |
15608 | 15608 | 15607 | {"type": "Polygon", "coordinates": [[[-121.73917, 36.77633], [-121.73883, 36.77674], [-121.73879, 36.7767], [-121.73768, 36.77747], [-121.73567, 36.77625], [-121.7328, 36.77533], [-121.73114, 36.774], [-121.73155, 36.77394], [-121.73199, 36.77418], [-121.73246, 36.77422], [-121.73301, 36.77408], [-121.73332, 36.77373], [-121.73363, 36.7736], [-121.73394, 36.77357], [-121.73432, 36.77363], [-121.73454, 36.77375], [-121.73491, 36.77431], [-121.73498, 36.77446], [-121.73489, 36.77465], [-121.73521, 36.77482], [-121.73553, 36.77494], [-121.73565, 36.775], [-121.73578, 36.77509], [-121.73598, 36.77528], [-121.73613, 36.77533], [-121.7363, 36.77531], [-121.73711, 36.77488], [-121.73721, 36.77486], [-121.73732, 36.77487], [-121.7374, 36.77491], [-121.73745, 36.77496], [-121.73808, 36.77615], [-121.73816, 36.77625], [-121.73825, 36.77634], [-121.73838, 36.77641], [-121.73853, 36.77647], [-121.73865, 36.77654], [-121.73867, 36.77653], [-121.73805, 36.77568], [-121.7391, 36.77612], [-121.73917, 36.77633]]]} | Restricted Access 2 | 17998 | Moro Cojo Ecological Reserve | 22492 | 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 | Monterey 14 | 26.613 | Moro Cojo ER | 0 | State Conservation Area 8 | 2 | |
15634 | 15634 | 15633 | {"type": "Polygon", "coordinates": [[[-118.41528, 37.50655], [-118.41424, 37.51016], [-118.41131, 37.5101], [-118.41137, 37.5067], [-118.41305, 37.50674], [-118.41305, 37.5065], [-118.41528, 37.50655]]]} | Restricted Access 2 | 29431 | Fish Slough Ecological Reserve | 18918 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fish-Slough-ER | Mono 32 | 29.181 | Fish Slough ER | 1970 | State Conservation Area 8 | 2 |
11552 | 11552 | 11551 | {"type": "Polygon", "coordinates": [[[-116.66912, 32.98862], [-116.65988, 32.98873], [-116.65991, 32.98773], [-116.66058, 32.98745], [-116.66904, 32.98739], [-116.66912, 32.98862]]]} | Restricted Access 2 | 23593 | Boulder Creek Ecological Reserve | 16294 | 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.218 | Boulder Creek ER | 0 | State Conservation Area 8 | 2 | |
15575 | 15575 | 15574 | {"type": "Polygon", "coordinates": [[[-121.74412, 36.87571], [-121.74366, 36.87559], [-121.74329, 36.87545], [-121.74227, 36.87498], [-121.74082, 36.8726], [-121.74226, 36.87023], [-121.7427, 36.87029], [-121.74329, 36.87006], [-121.74404, 36.87042], [-121.74411, 36.87185], [-121.74417, 36.87201], [-121.74408, 36.87317], [-121.74393, 36.87357], [-121.74369, 36.87428], [-121.74359, 36.87435], [-121.74351, 36.87447], [-121.74349, 36.87456], [-121.7435, 36.87468], [-121.74363, 36.87499], [-121.74412, 36.87566], [-121.74412, 36.87571]]]} | Restricted Access 2 | 44940 | Elkhorn Slough Ecological Reserve | 18581 | 3019 | Elkhorn Slough Foundation 464 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.elkhornslough.org | Non Governmental Organization 10 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Elkhorn-Slough-ER | Monterey 14 | 29.594 | Elkhorn Slough ER | 1980 | State Conservation Area 8 | 2 |
10233 | 10233 | 10232 | {"type": "MultiPolygon", "coordinates": [[[[-117.11031, 32.77957], [-117.11031, 32.77985], [-117.11022, 32.77985], [-117.10974, 32.77983], [-117.1093, 32.77979], [-117.10739, 32.77953], [-117.10841, 32.77919], [-117.10972, 32.77926], [-117.11031, 32.77957]]], [[[-117.11031, 32.78139], [-117.10939, 32.78129], [-117.10874, 32.78124], [-117.1081, 32.78124], [-117.10775, 32.78126], [-117.10736, 32.78131], [-117.10694, 32.78141], [-117.10659, 32.78152], [-117.10623, 32.78166], [-117.1059, 32.78182], [-117.10555, 32.78203], [-117.10524, 32.78226], [-117.10493, 32.78253], [-117.10466, 32.78283], [-117.10441, 32.78318], [-117.10419, 32.78357], [-117.10401, 32.78361], [-117.10399, 32.78228], [-117.104, 32.78071], [-117.10652, 32.77982], [-117.10701, 32.77966], [-117.10938, 32.77999], [-117.10979, 32.78019], [-117.11029, 32.78049], [-117.11027, 32.78101], [-117.11031, 32.78139]]]]} | Restricted Access 2 | 12831 | San Diego River Ecological Reserve | 24863 | 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 | 30.386 | San Diego River ER | 0 | State Conservation Area 8 | 2 | |
8349 | 8349 | 8348 | {"type": "Polygon", "coordinates": [[[-116.77797, 33.80726], [-116.77791, 33.81103], [-116.77358, 33.81102], [-116.77357, 33.80908], [-116.77583, 33.80892], [-116.77583, 33.80728], [-116.77797, 33.80726]]]} | Restricted Access 2 | 48473 | James San Jacinto Mountains Reserve | 33184 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | https://ucnrs.org/reserves/james-san-jacinto-mountains-reserve/ | Riverside 10 | 31.718 | James San Jacinto Mtns. Reserve | 0 | State Conservation Area 8 | 2 |
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 3289 | Harrison Grade Ecological Reserve | 19698 | 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 | 31.802 | Harrison Grade ER | 0 | State Conservation Area 8 | 2 |
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]);