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 LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY, YR_EST, GAP_STS
MNG_AGENCY >30
- Consumnes Community Services District 94
- El Dorado Hills Community Service District 25
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Marinwood Community Service District 3
- Rossmore Community Services District 2
- Twain Harte Community Services District 2
- Groveland Community Services District 2
- Manila Community Services District 2
- 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
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Bear Valley Springs Community Services District 1
- Morongo Valley 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
- …
PARK_URL 26 ✖
- 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://scotiacsd.com/parks-recreation/ 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.friendsofthedunes.org/resources/ 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.btcsd.org/brooktrails-redwood-park 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 173
- Local Recreation Area 14
- 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 194
- Restricted Access 4
MNG_AG_TYP 1
- Community Services District · 198 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11559 | 11559 | 11558 | {"type": "Polygon", "coordinates": [[[-121.06116, 38.66599], [-121.06067, 38.66612], [-121.06058, 38.66604], [-121.06042, 38.66597], [-121.06024, 38.66593], [-121.06012, 38.66593], [-121.05911, 38.66617], [-121.05881, 38.6654], [-121.06076, 38.66458], [-121.06093, 38.66507], [-121.06106, 38.6657], [-121.06116, 38.66599]]]} | Open Access 1 | 46839 | Alan Lindsey Park | 30317 | 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 | http://www.eldoradohillscsd.org/images/park_detail_popups/allan-lindsey/ | El Dorado 34 | 5.429 | Alan Lindsey Park | 0 | Local Park 2 | 4 |
13698 | 13698 | 13697 | {"type": "Polygon", "coordinates": [[[-121.54891, 37.78322], [-121.54785, 37.78323], [-121.54781, 37.78321], [-121.54778, 37.78141], [-121.5478, 37.78137], [-121.54888, 37.78136], [-121.54891, 37.78322]]]} | Open Access 1 | 36073 | Altamont Park | 15425 | 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 | 4.979 | Altamont Park | 0 | Local Park 2 | 4 | |
6455 | 6455 | 6454 | {"type": "Polygon", "coordinates": [[[-117.61081, 33.96804], [-117.60946, 33.96804], [-117.60945, 33.96786], [-117.60921, 33.96786], [-117.60921, 33.96804], [-117.60387, 33.96805], [-117.6108, 33.96589], [-117.61081, 33.96804]]]} | Open Access 1 | 48900 | American Heroes Park | 33617 | 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/Home/Components/FacilityDirectory/FacilityDirectory/2/82 | Riverside 10 | 18.815 | American Heroes Park | 0 | Local Park 2 | 4 |
12541 | 12541 | 12540 | {"type": "Polygon", "coordinates": [[[-121.36943, 38.44722], [-121.36911, 38.4473], [-121.36882, 38.44745], [-121.36862, 38.44752], [-121.36844, 38.44754], [-121.36794, 38.44755], [-121.36772, 38.44758], [-121.3677, 38.44537], [-121.36942, 38.44537], [-121.36943, 38.44722]]]} | Open Access 1 | 29045 | Amundson Park | 15463 | 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 | 8.564 | Amundson Park | 0 | Local Park 2 | 4 | |
7820 | 7820 | 7819 | {"type": "Polygon", "coordinates": [[[-119.70761, 36.31119], [-119.70698, 36.31119], [-119.70698, 36.31202], [-119.70615, 36.31201], [-119.70613, 36.3117], [-119.70512, 36.31171], [-119.70511, 36.31068], [-119.70548, 36.31064], [-119.70565, 36.31049], [-119.70587, 36.31042], [-119.7061, 36.31041], [-119.70699, 36.31031], [-119.7076, 36.31031], [-119.70761, 36.31119]]]} | Open Access 1 | 9049 | Armona Recreation Park | 15593 | 2279 | Aromona Community Services District 880 | Special District 4 | Community Services District 19 | Special District 4 | 2279 | Aromona Community Services District 856 | Special District 4 | Community Services District 17 | Kings 44 | 7.734 | Armona Rec. Park | 0 | Local Recreation Area 3 | 4 | ||
7828 | 7828 | 7827 | {"type": "Polygon", "coordinates": [[[-119.71474, 36.32481], [-119.71447, 36.32482], [-119.71291, 36.32308], [-119.7091, 36.3231], [-119.70911, 36.3207], [-119.71061, 36.3207], [-119.71062, 36.32069], [-119.70911, 36.31921], [-119.70919, 36.31883], [-119.7097, 36.31935], [-119.71109, 36.31934], [-119.7111, 36.31884], [-119.71159, 36.31884], [-119.71156, 36.32113], [-119.71151, 36.32118], [-119.71408, 36.32382], [-119.7146, 36.32439], [-119.71435, 36.3244], [-119.71474, 36.32481]]]} | Open Access 1 | 9397 | Armona Recreation Park | 15593 | 2279 | Aromona Community Services District 880 | Special District 4 | Community Services District 19 | Special District 4 | 2279 | Aromona Community Services District 856 | Special District 4 | Community Services District 17 | Kings 44 | 26.885 | Armona Rec. Park | 0 | Local Recreation Area 3 | 4 | ||
12569 | 12569 | 12568 | {"type": "Polygon", "coordinates": [[[-121.43142, 38.3814], [-121.43141, 38.38145], [-121.42914, 38.38144], [-121.42914, 38.38116], [-121.42912, 38.38115], [-121.42916, 38.38111], [-121.42917, 38.38105], [-121.42914, 38.38095], [-121.42914, 38.38006], [-121.42917, 38.37995], [-121.42916, 38.3799], [-121.42912, 38.37986], [-121.42914, 38.37985], [-121.42914, 38.37947], [-121.43132, 38.37946], [-121.43138, 38.37948], [-121.4314, 38.37952], [-121.43142, 38.3814]]]} | Open Access 1 | 29078 | Backer Park | 15752 | 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.773 | Backer Park | 0 | Local Park 2 | 4 | |
12506 | 12506 | 12505 | {"type": "Polygon", "coordinates": [[[-121.37654, 38.40796], [-121.37501, 38.40797], [-121.37499, 38.40782], [-121.37335, 38.40783], [-121.37335, 38.40729], [-121.37456, 38.40729], [-121.37505, 38.40699], [-121.37573, 38.407], [-121.37574, 38.40698], [-121.37585, 38.40696], [-121.37625, 38.40696], [-121.37626, 38.40753], [-121.37654, 38.40774], [-121.37654, 38.40796]]]} | Open Access 1 | 28338 | Baker Park | 15767 | 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 | 5.454 | Baker Park | 0 | Local Park 2 | 4 | |
12542 | 12542 | 12541 | {"type": "Polygon", "coordinates": [[[-121.47122, 38.42207], [-121.47055, 38.42258], [-121.4703, 38.42258], [-121.4702, 38.42264], [-121.47006, 38.42265], [-121.46996, 38.42263], [-121.46986, 38.42258], [-121.46961, 38.42257], [-121.46898, 38.42208], [-121.46899, 38.42179], [-121.46917, 38.42177], [-121.46916, 38.42082], [-121.469, 38.42082], [-121.469, 38.42054], [-121.46908, 38.42052], [-121.46914, 38.42049], [-121.47034, 38.42048], [-121.47105, 38.4199], [-121.47111, 38.41993], [-121.47118, 38.41994], [-121.47118, 38.4208], [-121.47102, 38.42081], [-121.47103, 38.42176], [-121.47121, 38.42177], [-121.47122, 38.42207]]]} | Open Access 1 | 29046 | Bartholomew Park | 15841 | 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.241 | Bartholomew Park | 0 | Local Park 2 | 4 | |
14480 | 14480 | 14479 | {"type": "Polygon", "coordinates": [[[-121.42687, 38.39388], [-121.42259, 38.39408], [-121.42253, 38.39406], [-121.42251, 38.39403], [-121.42245, 38.39353], [-121.4222, 38.39047], [-121.42254, 38.39046], [-121.4225, 38.38985], [-121.42686, 38.38968], [-121.42687, 38.39388]]]} | Open Access 1 | 47135 | Bartholomew Sports Park | 30812 | 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/584/Bartholomew-Sports-Park | Sacramento 41 | 45.36 | Bartholomew Sports Park | 0 | Local Recreation Area 3 | 4 |
11773 | 11773 | 11772 | {"type": "Polygon", "coordinates": [[[-121.42449, 38.41889], [-121.42368, 38.41943], [-121.42327, 38.41898], [-121.42324, 38.41869], [-121.42353, 38.41864], [-121.42368, 38.41859], [-121.42398, 38.41845], [-121.42415, 38.4184], [-121.42426, 38.41839], [-121.4243, 38.41842], [-121.42445, 38.41877], [-121.4245, 38.41885], [-121.42449, 38.41889]]]} | Open Access 1 | 24067 | Batey Park | 15861 | 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.845 | Batey Park | 0 | Local Park 2 | 4 | |
2153 | 2153 | 2152 | {"type": "Polygon", "coordinates": [[[-118.65798, 35.17081], [-118.6578, 35.1709], [-118.65757, 35.17099], [-118.65739, 35.17104], [-118.6569, 35.17114], [-118.65657, 35.17115], [-118.65646, 35.17117], [-118.65636, 35.17116], [-118.65616, 35.17116], [-118.6558, 35.17111], [-118.65549, 35.17103], [-118.65508, 35.17088], [-118.65347, 35.17007], [-118.65369, 35.16978], [-118.65381, 35.16954], [-118.65384, 35.16946], [-118.65404, 35.16856], [-118.65412, 35.16843], [-118.65421, 35.16832], [-118.65439, 35.16818], [-118.65448, 35.16813], [-118.65466, 35.16806], [-118.65572, 35.16787], [-118.65615, 35.16773], [-118.65652, 35.16844], [-118.65688, 35.16867], [-118.65791, 35.16929], [-118.65732, 35.16993], [-118.65798, 35.17081]]]} | Open Access 1 | 16088 | Bear Valley Park | 15932 | 2007 | Bear Valley Springs Community Services District 487 | Special District 4 | Community Services District 19 | http://www.bvcsd.com/ | Special District 4 | 2007 | Bear Valley Springs Community Services District 478 | Special District 4 | Community Services District 17 | Kern 36 | 25.291 | Bear Valley Park | 0 | Local Park 2 | 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 | |
11796 | 11796 | 11795 | {"type": "Polygon", "coordinates": [[[-121.34845, 38.39049], [-121.3479, 38.39027], [-121.34783, 38.39028], [-121.34779, 38.39023], [-121.34774, 38.39021], [-121.34763, 38.39021], [-121.3476, 38.39016], [-121.34705, 38.38994], [-121.34715, 38.38984], [-121.34735, 38.38953], [-121.34739, 38.38951], [-121.34747, 38.38951], [-121.34868, 38.39], [-121.3487, 38.39004], [-121.3487, 38.39008], [-121.34845, 38.39049]]]} | Open Access 1 | 24092 | Berens Park | 16019 | 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.922 | Berens Park | 0 | Local Park 2 | 4 | |
12150 | 12150 | 12149 | {"type": "Polygon", "coordinates": [[[-121.07921, 38.65705], [-121.07904, 38.65739], [-121.07856, 38.65783], [-121.07787, 38.65792], [-121.0772, 38.65713], [-121.07625, 38.65717], [-121.07578, 38.65647], [-121.07682, 38.65604], [-121.07701, 38.65557], [-121.07742, 38.65583], [-121.07787, 38.65593], [-121.07837, 38.65595], [-121.07885, 38.65623], [-121.07921, 38.65705]]]} | Open Access 1 | 25183 | Bertelsen Park | 16038 | 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 | 10.705 | Bertelsen Park | 0 | Local Park 2 | 4 | |
14160 | 14160 | 14159 | {"type": "Polygon", "coordinates": [[[-121.55037, 37.77462], [-121.55012, 37.77487], [-121.54992, 37.77499], [-121.54977, 37.77504], [-121.54919, 37.77515], [-121.54891, 37.77485], [-121.54863, 37.77459], [-121.54832, 37.77436], [-121.54794, 37.77413], [-121.54792, 37.7741], [-121.54832, 37.77332], [-121.55037, 37.77462]]]} | Open Access 1 | 43054 | Bethany Park | 16046 | 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 | 4.975 | Bethany Park | 0 | Local Park 2 | 4 | |
11759 | 11759 | 11758 | {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} | Open Access 1 | 24052 | Betschart Park | 16049 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.634 | Betschart Park | 0 | Local Park 2 | 4 | |
12543 | 12543 | 12542 | {"type": "Polygon", "coordinates": [[[-121.44049, 38.4306], [-121.44003, 38.4306], [-121.43918, 38.43156], [-121.43899, 38.43148], [-121.43873, 38.43143], [-121.43846, 38.43139], [-121.43708, 38.43138], [-121.43685, 38.43139], [-121.43668, 38.43144], [-121.43645, 38.43151], [-121.43619, 38.43155], [-121.43418, 38.43163], [-121.43414, 38.43161], [-121.43412, 38.43158], [-121.43412, 38.43063], [-121.43409, 38.43062], [-121.43409, 38.43039], [-121.4341, 38.43035], [-121.43413, 38.43034], [-121.43492, 38.43033], [-121.43493, 38.43062], [-121.43972, 38.4306], [-121.43973, 38.43003], [-121.43984, 38.43003], [-121.44029, 38.43008], [-121.44049, 38.43016], [-121.44049, 38.4306]]]} | Open Access 1 | 29047 | Betschart Park | 16049 | 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 | 13.204 | Betschart 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 | |||
12544 | 12544 | 12543 | {"type": "Polygon", "coordinates": [[[-121.44595, 38.39725], [-121.44596, 38.39751], [-121.44588, 38.39779], [-121.44581, 38.39779], [-121.44572, 38.39782], [-121.44567, 38.39788], [-121.44566, 38.39795], [-121.44533, 38.39799], [-121.445, 38.39799], [-121.44499, 38.39769], [-121.44494, 38.39755], [-121.44486, 38.39741], [-121.44485, 38.39738], [-121.44487, 38.39736], [-121.44495, 38.39732], [-121.44509, 38.39729], [-121.44595, 38.39725]]]} | Open Access 1 | 29048 | Bradford Park | 16325 | 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.547 | Bradford 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]);