units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where ACCESS_TYP = 1 and LABEL_NAME = "Heritage Park"
This data as json, copyable, CSV (advanced)
MNG_AGENCY 27
- Irvine, City of 2
- Santa Ana, City of 1
- Corona, City of 1
- Oceanside, City of 1
- Redlands, City of 1
- San Diego, County of 1
- Chula Vista, City of 1
- Dana Point, City of 1
- Pleasant Valley Recreation and Park District 1
- Valley-Wide Recreation and Park District 1
- Palo Alto, City of 1
- Loma Linda, City of 1
- Santa Fe Springs, City of 1
- Cerritos, City of 1
- Kingsburg, City of 1
- San Fernando, City of 1
- Chino, City of 1
- Fountain Valley, City of 1
- Tustin, City of 1
- La Verne, City of 1
- Diamond Bar, City of 1
- West Covina, City of 1
- Lemoore, City of 1
- Kern, County of 1
- Sunnyvale, City of 1
- Mountain View, City of 1
- Suisun City, City of 1
MNG_AG_TYP 3
DES_TP 1
- Local Park 28
ACCESS_TYP 1
- Open Access · 28 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1013 | 1013 | 1012 | {"type": "Polygon", "coordinates": [[[-117.77666, 34.12771], [-117.77648, 34.12776], [-117.77611, 34.1278], [-117.7758, 34.12781], [-117.77566, 34.12789], [-117.77553, 34.128], [-117.77517, 34.12848], [-117.77516, 34.12873], [-117.77513, 34.12876], [-117.77504, 34.12875], [-117.77491, 34.12831], [-117.77483, 34.12796], [-117.77483, 34.12784], [-117.77492, 34.12751], [-117.77553, 34.12759], [-117.77594, 34.12763], [-117.77604, 34.12765], [-117.77661, 34.12766], [-117.77665, 34.12768], [-117.77666, 34.12771]]]} | Open Access 1 | 6795 | Heritage Park | 19851 | 1162 | La Verne, City of 305 | City 2 | City Agency 2 | http://www.ci.la-verne.ca.us/index.php/residents/parks | City 2 | 1162 | La Verne, City of 301 | City 2 | City Agency 2 | Los Angeles 6 | 1.913 | Heritage Park | 0 | Local Park 2 | 4 | |
1074 | 1074 | 1073 | {"type": "Polygon", "coordinates": [[[-118.06361, 33.86403], [-118.06242, 33.86403], [-118.0624, 33.86397], [-118.06237, 33.86394], [-118.06227, 33.8639], [-118.06219, 33.86391], [-118.0621, 33.86397], [-118.06202, 33.86399], [-118.05989, 33.864], [-118.05986, 33.86224], [-118.06149, 33.86223], [-118.0615, 33.8625], [-118.06309, 33.86249], [-118.0631, 33.86291], [-118.06351, 33.8629], [-118.06351, 33.86249], [-118.06359, 33.86248], [-118.06361, 33.86403]]]} | Open Access 1 | 5660 | Heritage Park | 19843 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 14.909 | Heritage Park | 0 | Local Park 2 | 4 | |
1075 | 1075 | 1074 | {"type": "Polygon", "coordinates": [[[-117.71322, 34.01347], [-117.71112, 34.01349], [-117.7111, 34.01176], [-117.7132, 34.01175], [-117.71322, 34.01347]]]} | Open Access 1 | 5661 | Heritage Park | 19844 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | http://www.cityofchino.org/government-services/community-services/parks/heritage-park | San Bernardino 22 | 9.153 | Heritage Park | 0 | Local Park 2 | 4 |
1076 | 1076 | 1075 | {"type": "Polygon", "coordinates": [[[-117.93514, 33.73981], [-117.93478, 33.74004], [-117.93455, 33.74022], [-117.93426, 33.74049], [-117.93398, 33.7408], [-117.93383, 33.74101], [-117.93354, 33.74148], [-117.93336, 33.74182], [-117.9331, 33.74245], [-117.93308, 33.74147], [-117.93261, 33.74146], [-117.93261, 33.73985], [-117.93299, 33.73995], [-117.93393, 33.73994], [-117.93402, 33.73984], [-117.93402, 33.73981], [-117.93514, 33.73981]]]} | Open Access 1 | 5664 | Heritage Park | 19854 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 6.795 | Heritage Park | 0 | Local Park 2 | 4 | |
1077 | 1077 | 1076 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.7034], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.77721, 33.70186], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.7791, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78058, 33.70006], [-117.78086, 33.70027]], [[-117.77835, 33.70067], [-117.7784, 33.70062], [-117.77849, 33.70056], [-117.77867, 33.70047], [-117.77872, 33.7004], [-117.77873, 33.70033], [-117.77872, 33.70027], [-117.77867, 33.70022], [-117.7786, 33.70018], [-117.77853, 33.70018], [-117.77843, 33.7002], [-117.77835, 33.70024], [-117.77829, 33.7003], [-117.77818, 33.70055], [-117.77812, 33.70062], [-117.77795, 33.70075], [-117.77791, 33.7008], [-117.7779, 33.70088], [-117.77797, 33.70102], [-117.77798, 33.70109], [-117.77795, 33.70119], [-117.77797, 33.70127], [-117.77801, 33.7013], [-117.77813, 33.70132], [-117.7783, 33.70128], [-117.77836, 33.70125], [-117.77847, 33.70114], [-117.77852, 33.70104], [-117.77853, 33.70097], [-117.7785, 33.7009], [-117.77834, 33.70074], [-117.77835, 33.70067]]]} | Open Access 1 | 5665 | Heritage Park | 19850 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 29.375 | Heritage Park | 0 | Local Park 2 | 4 | |
1078 | 1078 | 1077 | {"type": "Polygon", "coordinates": [[[-117.57751, 33.84415], [-117.57745, 33.84458], [-117.57741, 33.84466], [-117.57731, 33.84478], [-117.57728, 33.84484], [-117.57731, 33.84492], [-117.57738, 33.84498], [-117.57734, 33.8453], [-117.57585, 33.84516], [-117.57613, 33.84334], [-117.57618, 33.84334], [-117.57617, 33.84345], [-117.57612, 33.84363], [-117.57612, 33.84368], [-117.57618, 33.84379], [-117.57626, 33.84383], [-117.57623, 33.84413], [-117.57666, 33.84413], [-117.5769, 33.8441], [-117.57751, 33.84415]]]} | Open Access 1 | 5668 | Heritage Park | 19846 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 4.401 | Heritage Park | 0 | Local Park 2 | 4 | |
1096 | 1096 | 1095 | {"type": "Polygon", "coordinates": [[[-117.84397, 33.97359], [-117.84302, 33.97478], [-117.84226, 33.97435], [-117.84321, 33.97317], [-117.84397, 33.97359]]]} | Open Access 1 | 7051 | Heritage Park | 19848 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | Los Angeles 6 | 3.321 | Heritage Park | 0 | Local Park 2 | 4 | |
1241 | 1241 | 1240 | {"type": "Polygon", "coordinates": [[[-117.8726, 34.05496], [-117.87256, 34.05763], [-117.87241, 34.05747], [-117.8721, 34.05723], [-117.87146, 34.05685], [-117.87082, 34.05667], [-117.87053, 34.0566], [-117.87027, 34.05658], [-117.87028, 34.05562], [-117.87025, 34.05561], [-117.87026, 34.05429], [-117.87106, 34.05432], [-117.87173, 34.05453], [-117.8726, 34.05496]]]} | Open Access 1 | 7076 | Heritage Park | 19859 | 1374 | West Covina, City of 318 | City 2 | City Agency 2 | http://www.westcovina.org/departments/community-recreation-services/park-facility-rentals | City 2 | 1374 | West Covina, City of 315 | City 2 | City Agency 2 | Los Angeles 6 | 14.33 | Heritage Park | 0 | Local Park 2 | 4 | |
1732 | 1732 | 1731 | {"type": "Polygon", "coordinates": [[[-117.79607, 33.73433], [-117.79549, 33.73543], [-117.79537, 33.73547], [-117.79461, 33.73512], [-117.79448, 33.73498], [-117.79435, 33.73497], [-117.79427, 33.735], [-117.79401, 33.73485], [-117.79493, 33.7337], [-117.79524, 33.73394], [-117.79553, 33.73407], [-117.79601, 33.73423], [-117.79607, 33.73433]]]} | Open Access 1 | 12932 | Heritage Park | 19858 | 1360 | Tustin, City of 278 | City 2 | City Agency 2 | http://www.tustinca.org/departments/parksrec/index.html | City 2 | 1360 | Tustin, City of 274 | City 2 | City Agency 2 | Orange 3 | 4.987 | Heritage Park | 0 | Local Park 2 | 4 | |
1989 | 1989 | 1988 | {"type": "Polygon", "coordinates": [[[-118.98667, 34.23418], [-118.98622, 34.2343], [-118.98466, 34.23476], [-118.98468, 34.23491], [-118.98432, 34.23495], [-118.98426, 34.23462], [-118.98353, 34.2344], [-118.98368, 34.23412], [-118.98373, 34.23392], [-118.98373, 34.23378], [-118.98365, 34.23333], [-118.9844, 34.23329], [-118.98445, 34.2335], [-118.98665, 34.23325], [-118.98664, 34.23381], [-118.98667, 34.23418]]]} | Open Access 1 | 16841 | Heritage Park | 19861 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 8.889 | Heritage Park | 0 | Local Park 2 | 4 | |
2193 | 2193 | 2192 | {"type": "Polygon", "coordinates": [[[-118.97016, 35.38673], [-118.97014, 35.38783], [-118.96981, 35.38881], [-118.96979, 35.38931], [-118.96948, 35.39011], [-118.96765, 35.39012], [-118.96763, 35.38674], [-118.97016, 35.38673]]]} | Open Access 1 | 16430 | Heritage Park | 19841 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 19.25 | Heritage Park | 0 | Local Park 2 | 4 | |
2361 | 2361 | 2360 | {"type": "Polygon", "coordinates": [[[-119.77414, 36.31345], [-119.77177, 36.31346], [-119.77177, 36.31099], [-119.77181, 36.30926], [-119.77414, 36.30927], [-119.77414, 36.31345]]]} | Open Access 1 | 11477 | Heritage Park | 19852 | 1174 | Lemoore, City of 380 | City 2 | City Agency 2 | http://www.lemoore.com/parks/default.html | City 2 | 1174 | Lemoore, City of 375 | City 2 | City Agency 2 | Kings 44 | 24.417 | Heritage Park | 0 | Local Park 2 | 4 | |
3607 | 3607 | 3606 | {"type": "MultiPolygon", "coordinates": [[[[-118.07484, 33.94086], [-118.07444, 33.94154], [-118.07459, 33.94162], [-118.07441, 33.94237], [-118.07292, 33.94176], [-118.07286, 33.94168], [-118.07286, 33.94086], [-118.07484, 33.94086]]], [[[-118.07801, 33.93894], [-118.07672, 33.94086], [-118.07657, 33.94091], [-118.07636, 33.94094], [-118.0762, 33.94095], [-118.07598, 33.94093], [-118.07577, 33.94087], [-118.07561, 33.9408], [-118.07547, 33.94071], [-118.0753, 33.94057], [-118.07529, 33.94053], [-118.07531, 33.9405], [-118.07547, 33.94036], [-118.07559, 33.94022], [-118.07585, 33.93981], [-118.07611, 33.93909], [-118.07615, 33.93904], [-118.0762, 33.93903], [-118.07745, 33.93902], [-118.07772, 33.93906], [-118.07784, 33.93902], [-118.07792, 33.93894], [-118.07801, 33.93894]]]]} | Open Access 1 | 29328 | Heritage Park | 19855 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 12.825 | Heritage Park | 0 | Local Park 2 | 4 | |
4106 | 4106 | 4105 | {"type": "Polygon", "coordinates": [[[-122.15743, 37.44385], [-122.15664, 37.44464], [-122.15607, 37.44428], [-122.15714, 37.4432], [-122.15737, 37.44334], [-122.15709, 37.44364], [-122.15743, 37.44385]]]} | Open Access 1 | 47047 | Heritage Park | 30697 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 2.057 | Heritage Park | 0 | Local Park 2 | 4 | |
4143 | 4143 | 4142 | {"type": "Polygon", "coordinates": [[[-119.5557, 36.50519], [-119.55541, 36.50518], [-119.55492, 36.50512], [-119.55464, 36.50511], [-119.55464, 36.50444], [-119.55569, 36.50444], [-119.5557, 36.50519]]]} | Open Access 1 | 47293 | Heritage Park | 31002 | 1153 | Kingsburg, City of 234 | City 2 | City Agency 2 | http://www.cityofkingsburg-ca.gov/ | City 2 | 1153 | Kingsburg, City of 230 | City 2 | City Agency 2 | Fresno 9 | 1.831 | Heritage Park | 0 | Local Park 2 | 4 | |
5793 | 5793 | 5792 | {"type": "MultiPolygon", "coordinates": [[[[-117.19381, 32.75393], [-117.19314, 32.75468], [-117.19139, 32.75359], [-117.19142, 32.75354], [-117.19096, 32.75325], [-117.19099, 32.75319], [-117.1896, 32.75233], [-117.18989, 32.752], [-117.19175, 32.75315], [-117.19204, 32.75283], [-117.19381, 32.75393]]], [[[-117.19427, 32.7534], [-117.19392, 32.7538], [-117.19353, 32.75356], [-117.19387, 32.75316], [-117.19427, 32.7534]]]]} | Open Access 1 | 45 | Heritage Park | 19842 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Heritage.html | San Diego 4 | 8.454 | Heritage Park | 0 | Local Park 2 | 4 |
6020 | 6020 | 6019 | {"type": "Polygon", "coordinates": [[[-117.21726, 34.05192], [-117.21318, 34.05191], [-117.21316, 34.05054], [-117.21367, 34.05028], [-117.21518, 34.04982], [-117.21637, 34.04984], [-117.21636, 34.05052], [-117.21725, 34.05053], [-117.21726, 34.05192]]]} | Open Access 1 | 47341 | Heritage Park | 31056 | 1269 | Redlands, City of 101 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | San Bernardino 22 | 18.414 | Heritage Park | 0 | Local Park 2 | 4 | |
7664 | 7664 | 7663 | {"type": "Polygon", "coordinates": [[[-116.99884, 32.62363], [-116.99893, 32.62395], [-116.99896, 32.6242], [-116.99893, 32.62444], [-116.99889, 32.62456], [-116.99876, 32.62483], [-116.99857, 32.62508], [-116.9983, 32.62529], [-116.99806, 32.62543], [-116.99773, 32.62553], [-116.99742, 32.62558], [-116.99708, 32.62557], [-116.99674, 32.6255], [-116.9964, 32.62536], [-116.99622, 32.62524], [-116.99603, 32.62508], [-116.99588, 32.62491], [-116.99578, 32.62474], [-116.9963, 32.62462], [-116.9964, 32.62463], [-116.99639, 32.62456], [-116.9965, 32.62453], [-116.99644, 32.62432], [-116.9964, 32.62432], [-116.99635, 32.62419], [-116.99578, 32.62431], [-116.99574, 32.62435], [-116.99572, 32.62443], [-116.99567, 32.62443], [-116.99563, 32.62432], [-116.99567, 32.62426], [-116.99612, 32.62416], [-116.99878, 32.6236], [-116.99884, 32.62363]]]} | Open Access 1 | 7565 | Heritage Park | 19845 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.chulavistaca.gov/departments/public-works/parks/locations-features-amenities-photos/heritage-park | San Diego 4 | 10.742 | Heritage Park | 0 | Local Park 2 | 4 |
7715 | 7715 | 7714 | {"type": "Polygon", "coordinates": [[[-117.23841, 34.05966], [-117.23764, 34.05966], [-117.23763, 34.0559], [-117.2384, 34.05635], [-117.23841, 34.05966]]]} | Open Access 1 | 48459 | Heritage Park | 33163 | 1181 | Loma Linda, City of 185 | City 2 | City Agency 2 | http://www.lomalinda-ca.gov/ | City 2 | 1181 | Loma Linda, City of 181 | City 2 | City Agency 2 | San Bernardino 22 | 6.884 | Heritage Park | 0 | Local Park 2 | 4 | |
8057 | 8057 | 8056 | {"type": "MultiPolygon", "coordinates": [[[[-122.02706, 37.35718], [-122.02573, 37.35689], [-122.02573, 37.35683], [-122.02594, 37.35668], [-122.02591, 37.3566], [-122.02541, 37.35623], [-122.02527, 37.3563], [-122.02507, 37.35626], [-122.02488, 37.35607], [-122.02463, 37.35617], [-122.02461, 37.35623], [-122.02459, 37.3566], [-122.02424, 37.35662], [-122.02413, 37.3567], [-122.02403, 37.35669], [-122.0246, 37.35502], [-122.02464, 37.355], [-122.02469, 37.355], [-122.0275, 37.3556], [-122.02755, 37.35563], [-122.02756, 37.35569], [-122.02706, 37.35718]]], [[[-122.02713, 37.35787], [-122.02745, 37.35832], [-122.02753, 37.35849], [-122.02761, 37.35875], [-122.02762, 37.35884], [-122.0276, 37.35888], [-122.02754, 37.35892], [-122.02722, 37.35899], [-122.02692, 37.35907], [-122.02664, 37.35918], [-122.02638, 37.35931], [-122.02602, 37.35955], [-122.02581, 37.35973], [-122.02559, 37.35996], [-122.02551, 37.35997], [-122.02544, 37.35995], [-122.02431, 37.35901], [-122.02454, 37.35876], [-122.02474, 37.35877], [-122.02487, 37.35867], [-122.02505, 37.35883], [-122.02502, 37.35889], [-122.0251, 37.35896], [-122.02528, 37.35883], [-122.02521, 37.35875], [-122.02532, 37.35868], [-122.02527, 37.35861], [-122.02542, 37.35851], [-122.02551, 37.35857], [-122.0256, 37.35853], [-122.02567, 37.35855], [-122.02582, 37.3584], [-122.02573, 37.35831], [-122.02653, 37.35777], [-122.02687, 37.35806], [-122.02713, 37.35787]]]]} | Open Access 1 | 11831 | Heritage Park | 19857 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 18.818 | Heritage 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]);