units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
33 rows where COUNTY = 34 and MNG_AG_TYP = 17 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL
DES_TP 5
- Local Park 27
- Local Recreation Area 3
- None 1
- None 1
- None 1
MNG_AGENCY 2
MNG_AG_TYP 1
- Community Services District · 33 ✖
ACCESS_TYP 1
- Open Access 33
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
11827 | 11827 | 11826 | {"type": "Polygon", "coordinates": [[[-120.97689, 38.66644], [-120.97663, 38.66629], [-120.97415, 38.66658], [-120.9732, 38.66697], [-120.97297, 38.66712], [-120.97286, 38.6669], [-120.97405, 38.6665], [-120.97542, 38.66632], [-120.97556, 38.66598], [-120.97435, 38.66468], [-120.9748, 38.6645], [-120.97485, 38.66452], [-120.9763, 38.66567], [-120.97663, 38.66601], [-120.97682, 38.66628], [-120.97689, 38.66644]]]} | Open Access 1 | 24132 | Hacienda Park | 19590 | 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 | 4.93 | Hacienda Park | 0 | Local Park 2 | 4 | |
14985 | 14985 | 14984 | {"type": "Polygon", "coordinates": [[[-120.97926, 38.68508], [-120.97912, 38.68513], [-120.97897, 38.68516], [-120.97813, 38.68517], [-120.97813, 38.68492], [-120.97806, 38.68492], [-120.97796, 38.68484], [-120.97754, 38.68479], [-120.97738, 38.6848], [-120.97726, 38.6845], [-120.97699, 38.68426], [-120.97654, 38.68405], [-120.97598, 38.68382], [-120.97568, 38.68381], [-120.97569, 38.68295], [-120.97575, 38.68292], [-120.97606, 38.68291], [-120.97631, 38.68288], [-120.97652, 38.6832], [-120.97729, 38.684], [-120.97865, 38.68477], [-120.97926, 38.68508]]]} | Open Access 1 | 45619 | Northview Park | 28447 | 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 | 5.218 | Northview 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 | |
11818 | 11818 | 11817 | {"type": "Polygon", "coordinates": [[[-120.99851, 38.687], [-120.99798, 38.68699], [-120.99664, 38.68697], [-120.99692, 38.68616], [-120.99728, 38.68594], [-120.9979, 38.68595], [-120.99791, 38.68554], [-120.99829, 38.6853], [-120.99851, 38.68553], [-120.99851, 38.687]]]} | Open Access 1 | 24124 | Cameron Park Lake | 16763 | 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 | 4.891 | Cameron Park Lake | None 1040 | |||
3311 | 3311 | 3310 | {"type": "Polygon", "coordinates": [[[-121.00447, 38.69485], [-121.00424, 38.69495], [-121.00409, 38.6946], [-121.00391, 38.69442], [-121.0036, 38.69429], [-121.00345, 38.69439], [-121.00337, 38.69431], [-121.00353, 38.69419], [-121.00327, 38.69372], [-121.00274, 38.6933], [-121.00269, 38.693], [-121.00275, 38.69254], [-121.00265, 38.6919], [-121.0022, 38.69097], [-121.00192, 38.6906], [-121.0019, 38.69021], [-121.00147, 38.69024], [-121.00115, 38.68933], [-121.00361, 38.68935], [-121.00284, 38.6901], [-121.00321, 38.69093], [-121.00333, 38.69132], [-121.00341, 38.69159], [-121.00351, 38.6923], [-121.00395, 38.6938], [-121.00443, 38.69404], [-121.00427, 38.6946], [-121.00447, 38.69485]]]} | Open Access 1 | 29639 | Gateway Park | 19240 | 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 | 13.424 | Gateway Park | 0 | Local Park 2 | 4 | |
11828 | 11828 | 11827 | {"type": "Polygon", "coordinates": [[[-121.00637, 38.65611], [-121.00636, 38.65719], [-121.00382, 38.6572], [-121.00381, 38.65631], [-121.00418, 38.65622], [-121.00637, 38.65611]]]} | Open Access 1 | 24135 | Christa McAuliffe Park | 17223 | 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 | 6.17 | Christa McAuliffe Park | 0 | Local Park 2 | 4 | |
11829 | 11829 | 11828 | {"type": "Polygon", "coordinates": [[[-121.00711, 38.65544], [-121.00546, 38.65556], [-121.00537, 38.65489], [-121.0066, 38.65449], [-121.00711, 38.65544]]]} | Open Access 1 | 24136 | Dave West Park | 17937 | 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.985 | Dave West Park | 0 | Local Park 2 | 4 | |
11822 | 11822 | 11821 | {"type": "Polygon", "coordinates": [[[-121.01135, 38.68107], [-121.0111, 38.68112], [-121.01067, 38.68124], [-121.00999, 38.68139], [-121.00996, 38.68138], [-121.00993, 38.68134], [-121.00968, 38.68065], [-121.01065, 38.68045], [-121.01076, 38.6805], [-121.01089, 38.68053], [-121.01103, 38.68053], [-121.01121, 38.6805], [-121.01135, 38.68107]]]} | Open Access 1 | 24128 | Oak Knoll Park | 22984 | 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 | 2.585 | Oak Knoll Park | 0 | Local Park 2 | 4 | |
14653 | 14653 | 14652 | {"type": "Polygon", "coordinates": [[[-121.01514, 38.66851], [-121.01406, 38.66856], [-121.01397, 38.6684], [-121.01397, 38.66777], [-121.01416, 38.66778], [-121.01435, 38.66781], [-121.01455, 38.66787], [-121.01474, 38.66797], [-121.01488, 38.66808], [-121.015, 38.66821], [-121.01509, 38.66836], [-121.01514, 38.66851]]]} | Open Access 1 | 44913 | Laurel Oaks Park | 21097 | 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.627 | Laurel Oaks Park | 0 | Local Park 2 | 4 | |
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 |
12151 | 12151 | 12150 | {"type": "Polygon", "coordinates": [[[-121.06525, 38.64755], [-121.06521, 38.64759], [-121.06334, 38.64831], [-121.06334, 38.64702], [-121.06368, 38.64696], [-121.06368, 38.64703], [-121.06373, 38.64709], [-121.06385, 38.64714], [-121.06401, 38.64713], [-121.06507, 38.64717], [-121.06511, 38.6472], [-121.06515, 38.64733], [-121.06525, 38.64751], [-121.06525, 38.64755]]]} | Open Access 1 | 25186 | Creekside Greens Park | 17768 | 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 | 3.69 | Creekside Greens Park | 0 | Local Park 2 | 4 | |
11814 | 11814 | 11813 | {"type": "Polygon", "coordinates": [[[-121.06721, 38.70733], [-121.06473, 38.70733], [-121.06458, 38.70688], [-121.06461, 38.70684], [-121.06463, 38.70684], [-121.06503, 38.70678], [-121.06551, 38.70666], [-121.06595, 38.7065], [-121.06639, 38.70628], [-121.06644, 38.70628], [-121.06649, 38.70632], [-121.06656, 38.70644], [-121.06665, 38.70677], [-121.06671, 38.70682], [-121.06678, 38.70685], [-121.06693, 38.70684], [-121.06721, 38.70733]]]} | Open Access 1 | 24118 | Murray Homestead Park | 22611 | 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 | 4.025 | Murray Homestead Park | 0 | Local Park 2 | 4 | |
17035 | 17035 | 17034 | {"type": "Polygon", "coordinates": [[[-121.076, 38.68331], [-121.07338, 38.68435], [-121.07326, 38.68359], [-121.07237, 38.68276], [-121.072, 38.68255], [-121.07182, 38.68187], [-121.07311, 38.68189], [-121.07452, 38.68212], [-121.075, 38.68217], [-121.07565, 38.68221], [-121.0757, 38.68245], [-121.07588, 38.68303], [-121.07583, 38.68311], [-121.07589, 38.68329], [-121.076, 38.68331]]]} | Open Access 1 | 24126 | Teen Center & Skate Park | 26216 | 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 | 14.338 | Teen Ctr. & Skate Park | 0 | Local Recreation Area 3 | 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 | |||
11815 | 11815 | 11814 | {"type": "Polygon", "coordinates": [[[-121.07765, 38.70194], [-121.07763, 38.70294], [-121.07756, 38.70315], [-121.07742, 38.70337], [-121.07664, 38.70416], [-121.07655, 38.70403], [-121.07645, 38.70406], [-121.0764, 38.70397], [-121.07654, 38.70354], [-121.07666, 38.70356], [-121.07671, 38.7034], [-121.07675, 38.70231], [-121.07662, 38.70208], [-121.07721, 38.70193], [-121.07765, 38.70194]]]} | Open Access 1 | 24119 | Fairchild Park | 18792 | 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 | 3.892 | Fairchild Park | 0 | Local Park 2 | 4 | |
8335 | 8335 | 8334 | {"type": "Polygon", "coordinates": [[[-121.07801, 38.69279], [-121.07777, 38.69282], [-121.07777, 38.69263], [-121.07784, 38.69262], [-121.07786, 38.69264], [-121.07792, 38.69263], [-121.07799, 38.69273], [-121.07801, 38.69279]]]} | Open Access 1 | 47800 | New York Creek Nature Trail | 30318 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.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/new-york-creek/index.html | El Dorado 34 | 0.089 | New York Creek Nature Trail | 0 | Local Recreation Area 3 | 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 | |
11819 | 11819 | 11818 | {"type": "Polygon", "coordinates": [[[-121.07928, 38.68615], [-121.07845, 38.68653], [-121.07831, 38.68668], [-121.07853, 38.68683], [-121.07853, 38.68689], [-121.07838, 38.68697], [-121.07784, 38.68651], [-121.07652, 38.68617], [-121.07596, 38.68613], [-121.07538, 38.68614], [-121.0746, 38.68624], [-121.07391, 38.68547], [-121.07383, 38.68545], [-121.07385, 38.68538], [-121.07381, 38.68531], [-121.07378, 38.68528], [-121.07385, 38.6852], [-121.07372, 38.68482], [-121.07338, 38.68436], [-121.076, 38.68331], [-121.07627, 38.6837], [-121.07675, 38.68419], [-121.07723, 38.68452], [-121.07795, 38.68496], [-121.07845, 38.68531], [-121.07902, 38.68582], [-121.07928, 38.68615]]]} | Open Access 1 | 24125 | EDH Community Park | 18443 | 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 | 25.016 | EDH Community Park | 0 | Local Park 2 | 4 | |
13467 | 13467 | 13466 | {"type": "Polygon", "coordinates": [[[-121.07953, 38.68811], [-121.07909, 38.6882], [-121.07904, 38.6885], [-121.07869, 38.68879], [-121.07832, 38.68887], [-121.07826, 38.68905], [-121.07834, 38.68935], [-121.07793, 38.68994], [-121.07799, 38.69066], [-121.07777, 38.69085], [-121.07746, 38.6909], [-121.07712, 38.69108], [-121.07721, 38.69165], [-121.0772, 38.69199], [-121.07814, 38.69273], [-121.07869, 38.69273], [-121.0788, 38.69271], [-121.07884, 38.69283], [-121.07884, 38.69295], [-121.0788, 38.69307], [-121.0785, 38.6935], [-121.07779, 38.69365], [-121.07836, 38.69593], [-121.07843, 38.69651], [-121.07866, 38.69728], [-121.07862, 38.69804], [-121.07885, 38.69865], [-121.07924, 38.69897], [-121.07935, 38.69929], [-121.07932, 38.69947], [-121.07891, 38.69978], [-121.07892, 38.70018], [-121.07913, 38.70176], [-121.07907, 38.70225], [-121.07912, 38.70276], [-121.07913, 38.70344], [-121.07875, 38.70311], [-121.0788, 38.70301], [-121.07862, 38.70242], [-121.07865, 38.70194], [-121.07876, 38.70166], [-121.07862, 38.70022], [-121.0785, 38.69986], [-121.07867, 38.69928], [-121.07824, 38.69806], [-121.07815, 38.69752], [-121.07808, 38.69677], [-121.07773, 38.69675], [-121.07784, 38.69591], [-121.07786, 38.69549], [-121.0779, 38.69542], [-121.0779, 38.69535], [-121.07786, 38.69529], [-121.07779, 38.69524], [-121.07771, 38.69522], [-121.07758, 38.69522], [-121.07767, 38.69467], [-121.07743, 38.69373], [-121.07723, 38.69376], [-121.07634, 38.69311], [-121.07638, 38.69309], [-121.07664, 38.69245], [-121.07632, 38.69109], [-121.07654, 38.69066], [-121.07729, 38.69024], [-121.07748, 38.68999], [-121.07742, 38.68926], [-121.07735, 38.68867], [-121.07734, 38.68845], [-121.07766, 38.68854], [-121.07808, 38.68848], [-121.0784, 38.68806], [-121.07832, 38.68785], [-121.07864, 38.68747], [-121.07843, 38.68716], [-121.07864, 38.68701], [-121.07871, 38.687], [-121.07876, 38.68702], [-121.07879, 38.68707], [-121.07885, 38.68729], [-121.07892, 38.68739], [-121.07953, 38.68811]], [[-121.07799, 38.69273], [-121.07792, 38.69263], [-121.07785, 38.69264], [-121.07784, 38.69262], [-121.07777, 38.69263], [-121.07777, 38.69282], [-121.078, 38.69279], [-121.07799, 38.69273]]]} | Open Access 1 | 35705 | New York Creek Nature Trail | 30318 | 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/new-york-creek/index.html | El Dorado 34 | 26.567 | New York Creek Nature Trail | 0 | Local Recreation Area 3 | 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]);