units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
198 rows where MNG_AG_TYP = 17 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 91
- El Dorado Hills Community Service District 22
- Jurupa Community Services District 10
- Cameron Park Community Services District 7
- Mountain House Community Services District 7
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Marinwood Community Service District 3
- Truckee Tahoe Airport District 2
- Indian Valley Community Services District 2
- Aromona Community Services District 2
- Helendale Community Services District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Brooktrails Community Services District 1
- Groveland Community Services District 1
- Manila Community Services District 1
- Cambria Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Lake Shastina Community Services District 1
- Tomales Village Community Services District 1
- Bolinas Community Public Utility District 1
- Bel Marin Keys Community Services District 1
- Mountain Gate Community Special District 1
- Willow Creek Community Services District 1
- …
PARK_URL 23 ✖
- https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities 3
- http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf 2
- http://www.eldoradohillscsd.org/images/park_detail_popups/new-york-creek/index.html 2
- http://ffrpcambria.org/ranch.html 1
- http://mckinleyvillecsd.com/pierson-park 1
- http://www.eldoradohillscsd.org/images/park_detail_popups/allan-lindsey/ 1
- http://www.eldoradohillscsd.org/images/park_detail_popups/governors/index.html 1
- http://www.yourcsd.com/566/Buscher-Park 1
- http://www.yourcsd.com/569/Camden-Park 1
- http://www.yourcsd.com/584/Bartholomew-Sports-Park 1
- http://www.yourcsd.com/586/Constellation-Park 1
- http://www.yourcsd.com/590/Derr-Okamoto-Park 1
- http://www.yourcsd.com/595/Bridgeview-Park 1
- http://www.yourcsd.com/604/Jordan-Family-Park 1
- http://www.yourcsd.com/621/Promenade-Park 1
- http://www.yourcsd.com/624/Rose-Garden-Park 1
- http://www.yourcsd.com/631/Island-Park 1
- http://www.yourcsd.com/639/Storybook-Woods-Park 1
- http://www.yourcsd.com/646/Underwood-Park 1
- https://ghcsd.com/wp-content/uploads/eastside-kiosk-map.pdf 1
- https://helendalecsd.recdesk.com/Community/Page?pageId=18185 1
- https://www.helendalecsd.org/parks_facilities.html 1
- https://www.jcsd.us/Home/Components/FacilityDirectory/FacilityDirectory/2/82 1
DES_TP 12
- Local Park 156
- Local Recreation Area 11
- Local Other or Unknown 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 174
- Restricted Access 4
MNG_AG_TYP 1
- Community Services District · 178 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3321 | 3321 | 3320 | {"type": "Polygon", "coordinates": [[[-124.16247, 40.85177], [-124.16166, 40.85293], [-124.16151, 40.85317], [-124.15946, 40.85236], [-124.15859, 40.852], [-124.15866, 40.85177], [-124.15859, 40.8514], [-124.15856, 40.85106], [-124.15866, 40.85071], [-124.15889, 40.85049], [-124.15943, 40.85029], [-124.16022, 40.85014], [-124.16032, 40.85011], [-124.16004, 40.85044], [-124.16002, 40.85068], [-124.16191, 40.85144], [-124.162, 40.85158], [-124.16247, 40.85177]]]} | Open Access 1 | 29679 | Manila Community Park | 21749 | 2319 | Manila Community Services District 618 | Special District 4 | Community Services District 19 | http://www.manilacsd.com/ | Special District 4 | 2319 | Manila Community Services District 607 | Special District 4 | Community Services District 17 | Humboldt 45 | 15.038 | Manila Community Park | 0 | Local Park 2 | 4 | |
3345 | 3345 | 3344 | {"type": "Polygon", "coordinates": [[[-121.10145, 38.69128], [-121.10119, 38.69131], [-121.10095, 38.69131], [-121.1009, 38.6913], [-121.10073, 38.69131], [-121.1003, 38.69125], [-121.09981, 38.6911], [-121.0995, 38.69094], [-121.09923, 38.69073], [-121.09909, 38.69062], [-121.09902, 38.69053], [-121.09887, 38.69061], [-121.09794, 38.69096], [-121.09783, 38.69073], [-121.09782, 38.69058], [-121.09788, 38.69043], [-121.09815, 38.69016], [-121.09851, 38.68988], [-121.0986, 38.68968], [-121.10131, 38.68916], [-121.10149, 38.68991], [-121.10145, 38.69128]]]} | Open Access 1 | 24122 | Promontory Community Park | 24016 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 12.49 | Promontory Community Park | 0 | Local Park 2 | 4 | |
3346 | 3346 | 3345 | {"type": "Polygon", "coordinates": [[[-120.98121, 38.68838], [-120.9796, 38.68963], [-120.97944, 38.6898], [-120.97775, 38.68919], [-120.98018, 38.68729], [-120.98102, 38.6879], [-120.98092, 38.68806], [-120.9809, 38.68811], [-120.98121, 38.68838]]]} | Open Access 1 | 24123 | Rasmussen Park | 24190 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 9.847 | Rasmussen Park | 0 | Local Park 2 | 4 | |
3352 | 3352 | 3351 | {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} | Open Access 1 | 24241 | Larissa Park | 21027 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 0.324 | Larissa Park | 0 | Local Park 2 | 4 | |
3368 | 3368 | 3367 | {"type": "Polygon", "coordinates": [[[-120.22752, 37.84921], [-120.22678, 37.84949], [-120.22674, 37.84968], [-120.22664, 37.85002], [-120.22645, 37.85003], [-120.22647, 37.84962], [-120.22639, 37.84956], [-120.22598, 37.84877], [-120.22683, 37.84863], [-120.22716, 37.84872], [-120.22752, 37.84921]]]} | Open Access 1 | 24325 | Leon Rose Ball Park | 21170 | 2225 | Groveland Community Services District 575 | Special District 4 | Community Services District 19 | http://gcsd.org/ | Special District 4 | 2225 | Groveland Community Services District 567 | Special District 4 | Community Services District 17 | Tuolumne 21 | 2.504 | Leon Rose Ball Park | 0 | Local Recreation Area 3 | 4 | |
3559 | 3559 | 3558 | {"type": "Polygon", "coordinates": [[[-121.37535, 38.41303], [-121.37525, 38.41306], [-121.37525, 38.41445], [-121.37472, 38.41457], [-121.37452, 38.41458], [-121.37452, 38.41431], [-121.37455, 38.4143], [-121.37454, 38.41261], [-121.37525, 38.41261], [-121.37525, 38.41292], [-121.37535, 38.41296], [-121.37535, 38.41303]]]} | Open Access 1 | 28336 | Beeman Park | 15953 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 3.279 | Beeman Park | 0 | Local Park 2 | 4 | |
3573 | 3573 | 3572 | {"type": "Polygon", "coordinates": [[[-121.47927, 38.41104], [-121.47989, 38.41113], [-121.48031, 38.41123], [-121.48033, 38.41127], [-121.48024, 38.4115], [-121.48019, 38.41184], [-121.48013, 38.41186], [-121.47927, 38.41181], [-121.4793, 38.41153], [-121.47923, 38.41133], [-121.47927, 38.41104]]]} | Open Access 1 | 29068 | Perez Park | 23609 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.695 | Perez Park | 0 | Local Park 2 | 4 | |
3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} | Restricted Access 2 | 37007 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Nevada 30 | 851.88 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
3746 | 3746 | 3745 | {"type": "Polygon", "coordinates": [[[-117.57139, 33.96796], [-117.57095, 33.96793], [-117.57034, 33.96782], [-117.56983, 33.96767], [-117.56909, 33.96739], [-117.56852, 33.96724], [-117.56786, 33.96714], [-117.56726, 33.96712], [-117.56721, 33.96707], [-117.5672, 33.9647], [-117.57139, 33.9647], [-117.57139, 33.96796]]]} | Open Access 1 | 44902 | Harada Heritage Park | 19658 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 29.71 | Harada Heritage Park | 0 | Local Park 2 | 4 | |
3852 | 3852 | 3851 | {"type": "Polygon", "coordinates": [[[-121.07724, 38.67812], [-121.07489, 38.67813], [-121.07469, 38.67778], [-121.07467, 38.67748], [-121.07485, 38.67705], [-121.07491, 38.67655], [-121.07482, 38.67601], [-121.07428, 38.67385], [-121.07403, 38.67278], [-121.07374, 38.67223], [-121.07365, 38.67182], [-121.07684, 38.67147], [-121.07743, 38.67407], [-121.07748, 38.67435], [-121.07751, 38.67472], [-121.07752, 38.675], [-121.07745, 38.67711], [-121.07738, 38.67757], [-121.07724, 38.67812]]]} | Open Access 1 | 35575 | Bowmen's Archery Range | 16312 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 44.97 | Bowmen's Archery Range | None 325 | |||
3935 | 3935 | 3934 | {"type": "Polygon", "coordinates": [[[-121.55275, 37.77019], [-121.55274, 37.77025], [-121.55235, 37.77066], [-121.55227, 37.77066], [-121.55182, 37.77042], [-121.55178, 37.77039], [-121.55175, 37.77033], [-121.55176, 37.77027], [-121.55198, 37.76992], [-121.55207, 37.76988], [-121.55216, 37.76989], [-121.55236, 37.76998], [-121.55275, 37.77019]]]} | Open Access 1 | 36264 | Mountain House Community Services District 1 | 22541 | 2288 | Mountain House Community Services District 703 | Special District 4 | Community Services District 19 | http://www.mhcsd.com/ | Special District 4 | 2288 | Mountain House Community Services District 690 | Special District 4 | Community Services District 17 | San Joaquin 39 | 1.157 | Mtn. House Community Services District 1 | None 340 | |||
4113 | 4113 | 4112 | {"type": "Polygon", "coordinates": [[[-121.35944, 38.41534], [-121.35944, 38.41627], [-121.35395, 38.4163], [-121.35405, 38.41543], [-121.35476, 38.41527], [-121.35481, 38.41533], [-121.35488, 38.41536], [-121.35506, 38.41534], [-121.35521, 38.41534], [-121.35561, 38.41539], [-121.35677, 38.41575], [-121.35699, 38.4158], [-121.35723, 38.41581], [-121.35761, 38.41578], [-121.35793, 38.41569], [-121.35821, 38.41554], [-121.35845, 38.41534], [-121.35944, 38.41534]]]} | Open Access 1 | 47113 | Hill Park | 30784 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 10.163 | Hill Park | 0 | Local Park 2 | 4 | |
4119 | 4119 | 4118 | {"type": "Polygon", "coordinates": [[[-121.44987, 38.38318], [-121.44957, 38.38321], [-121.44957, 38.38325], [-121.44874, 38.38344], [-121.44865, 38.38316], [-121.44852, 38.38313], [-121.44851, 38.38306], [-121.44844, 38.38301], [-121.44847, 38.38295], [-121.44837, 38.38269], [-121.44834, 38.38265], [-121.44897, 38.38231], [-121.44906, 38.38231], [-121.44938, 38.38266], [-121.44936, 38.38267], [-121.44938, 38.3827], [-121.44941, 38.38269], [-121.44987, 38.38318]]]} | Open Access 1 | 47127 | Buscher Park | 30804 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/566/Buscher-Park | Sacramento 41 | 2.298 | Buscher Park | 0 | Local Park 2 | 4 |
4120 | 4120 | 4119 | {"type": "Polygon", "coordinates": [[[-121.34852, 38.45076], [-121.34777, 38.45075], [-121.34771, 38.45079], [-121.34766, 38.45076], [-121.34759, 38.45076], [-121.3475, 38.4508], [-121.34748, 38.45083], [-121.34747, 38.45088], [-121.34728, 38.45088], [-121.34721, 38.45087], [-121.3474, 38.45018], [-121.34742, 38.45018], [-121.34742, 38.45023], [-121.34746, 38.45028], [-121.34757, 38.45031], [-121.34765, 38.45028], [-121.34774, 38.4502], [-121.34787, 38.45017], [-121.34809, 38.45015], [-121.34854, 38.45016], [-121.34857, 38.4502], [-121.34854, 38.45042], [-121.34852, 38.45076]]]} | Open Access 1 | 47128 | Jordan Family Park | 30805 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/604/Jordan-Family-Park | Sacramento 41 | 1.741 | Jordan Family Park | 0 | Local Park 2 | 4 |
4121 | 4121 | 4120 | {"type": "Polygon", "coordinates": [[[-121.41262, 38.4028], [-121.41282, 38.40283], [-121.41295, 38.40288], [-121.41306, 38.40295], [-121.41315, 38.40303], [-121.41321, 38.40313], [-121.41324, 38.4033], [-121.41322, 38.40341], [-121.41318, 38.40351], [-121.41305, 38.40365], [-121.41294, 38.40371], [-121.41282, 38.40376], [-121.41261, 38.40379], [-121.4124, 38.40376], [-121.41228, 38.40371], [-121.41217, 38.40364], [-121.41208, 38.40355], [-121.41202, 38.40345], [-121.41199, 38.40329], [-121.412, 38.40318], [-121.41205, 38.40308], [-121.41217, 38.40294], [-121.41228, 38.40287], [-121.41241, 38.40283], [-121.41262, 38.4028]]]} | Open Access 1 | 47129 | Constellation Park | 30806 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/586/Constellation-Park | Sacramento 41 | 2.307 | Constellation Park | 0 | Local Park 2 | 4 |
4122 | 4122 | 4121 | {"type": "Polygon", "coordinates": [[[-121.45166, 38.42828], [-121.45123, 38.42827], [-121.45104, 38.42799], [-121.45153, 38.428], [-121.45166, 38.42828]]]} | Open Access 1 | 47130 | Harris Ranch Park | 30807 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.311 | Harris Ranch Park | 0 | Local Park 2 | 4 | |
4136 | 4136 | 4135 | {"type": "Polygon", "coordinates": [[[-122.5342, 37.88202], [-122.53409, 37.88227], [-122.53409, 37.88227], [-122.53403, 37.88222], [-122.53403, 37.882], [-122.5342, 37.88202]]]} | Open Access 1 | 47184 | Kott Park | 30876 | 2261 | Tamalpais Community Services District 723 | Special District 4 | Community Services District 19 | http://www.tcsd.us/ | Special District 4 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | Marin 23 | 0.068 | Kott Park | 0 | Local Park 2 | 4 | |
4199 | 4199 | 4198 | {"type": "Polygon", "coordinates": [[[-121.0866, 38.7185], [-121.08687, 38.71847], [-121.08692, 38.71849], [-121.08695, 38.71853], [-121.08696, 38.71876], [-121.08689, 38.71901], [-121.08671, 38.71933], [-121.08654, 38.71952], [-121.08646, 38.71954], [-121.08591, 38.71931], [-121.08598, 38.7192], [-121.08625, 38.71901], [-121.0866, 38.7185]]]} | Open Access 1 | 44915 | Windsor Point Park | 27639 | 2197 | El Dorado Hills Community Service District 568 | Special District 4 | Community Services District 19 | http://www.edhcsd.org/ | Special District 4 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | El Dorado 34 | 1.408 | Windsor Point Park | 0 | Local Park 2 | 4 | |
4331 | 4331 | 4330 | {"type": "Polygon", "coordinates": [[[-120.97333, 38.67984], [-120.97344, 38.67985], [-120.97355, 38.67989], [-120.97363, 38.67997], [-120.97367, 38.68004], [-120.97367, 38.68086], [-120.97365, 38.68088], [-120.97361, 38.68089], [-120.97303, 38.68087], [-120.97276, 38.68084], [-120.97273, 38.68079], [-120.97279, 38.68048], [-120.9728, 38.67987], [-120.97286, 38.67984], [-120.97333, 38.67984]]]} | Open Access 1 | 45512 | Eastwood Park | 28346 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 2.155 | Eastwood Park | 0 | Local Park 2 | 4 | |
5310 | 5310 | 5309 | {"type": "Polygon", "coordinates": [[[-117.60325, 33.93325], [-117.60036, 33.93326], [-117.60037, 33.93321], [-117.60032, 33.933], [-117.60022, 33.93275], [-117.60012, 33.93259], [-117.59983, 33.93223], [-117.59978, 33.93214], [-117.59975, 33.93201], [-117.59976, 33.93153], [-117.5999, 33.93138], [-117.60052, 33.93174], [-117.60097, 33.93195], [-117.60157, 33.93215], [-117.60186, 33.93223], [-117.60232, 33.93232], [-117.60276, 33.93237], [-117.60324, 33.93239], [-117.60332, 33.93241], [-117.60335, 33.93244], [-117.60337, 33.93248], [-117.60337, 33.93316], [-117.60334, 33.93323], [-117.6033, 33.93325], [-117.60325, 33.93325]]]} | Open Access 1 | 48902 | Dairyland Park | 33619 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | Riverside 10 | 9.932 | Dairyland Park | 0 | Local Park 2 | 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]);