units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where DES_TP = 2 and MNG_AGENCY = 266 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
MNG_AG_TYP 1
- City Agency 59
MNG_AGENCY 1
- Irvine, City of · 59 ✖
DES_TP 1
- Local Park · 59 ✖
ACCESS_TYP 1
- Open Access 59
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6312 | 6312 | 6311 | {"type": "Polygon", "coordinates": [[[-117.79635, 33.70627], [-117.79619, 33.70614], [-117.79467, 33.70508], [-117.79443, 33.70532], [-117.79308, 33.7044], [-117.79319, 33.70427], [-117.79187, 33.70334], [-117.79207, 33.70313], [-117.79214, 33.70311], [-117.79243, 33.70331], [-117.79264, 33.70349], [-117.79273, 33.70352], [-117.79281, 33.70351], [-117.79285, 33.70349], [-117.79292, 33.70342], [-117.79295, 33.70343], [-117.79348, 33.70381], [-117.79351, 33.70381], [-117.79358, 33.7039], [-117.7937, 33.70395], [-117.79381, 33.70402], [-117.79392, 33.7041], [-117.79402, 33.70421], [-117.79409, 33.70424], [-117.79418, 33.70425], [-117.79419, 33.70428], [-117.79472, 33.70465], [-117.79486, 33.70463], [-117.79492, 33.7047], [-117.79514, 33.70481], [-117.79662, 33.70585], [-117.79666, 33.70592], [-117.79664, 33.70598], [-117.79635, 33.70627]]]} | Open Access 1 | 1481 | College Park | 17508 | 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 | 7.415 | College Park | 0 | Local Park 2 | 4 | |
826 | 826 | 825 | {"type": "Polygon", "coordinates": [[[-117.76214, 33.70303], [-117.76191, 33.70324], [-117.76187, 33.7033], [-117.76186, 33.70337], [-117.76172, 33.70337], [-117.76123, 33.70387], [-117.76122, 33.70391], [-117.76115, 33.70398], [-117.76079, 33.70376], [-117.7608, 33.70374], [-117.76049, 33.70352], [-117.76146, 33.70258], [-117.76214, 33.70303]]]} | Open Access 1 | 5451 | Blue Gum Park | 16176 | 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 | 2.69 | Blue Gum 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 | |
6253 | 6253 | 6252 | {"type": "Polygon", "coordinates": [[[-117.76966, 33.71137], [-117.76791, 33.7131], [-117.76493, 33.71103], [-117.76786, 33.71016], [-117.76789, 33.71016], [-117.76966, 33.71137]]]} | Open Access 1 | 5992 | Northwood Community Park | 22899 | 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 | 17.728 | Northwood Community Park | 0 | Local Park 2 | 4 | |
7751 | 7751 | 7750 | {"type": "Polygon", "coordinates": [[[-117.7672, 33.70657], [-117.76702, 33.70679], [-117.76688, 33.70675], [-117.76679, 33.70675], [-117.76672, 33.70678], [-117.76664, 33.70687], [-117.76658, 33.70705], [-117.76652, 33.70706], [-117.76539, 33.70628], [-117.76536, 33.70625], [-117.76535, 33.70622], [-117.76558, 33.70597], [-117.76559, 33.70591], [-117.76558, 33.70584], [-117.76581, 33.70561], [-117.7672, 33.70657]]]} | Open Access 1 | 8318 | Pepperwood Park | 23600 | 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 | 3.11 | Pepperwood Park | 0 | Local Park 2 | 4 | |
1233 | 1233 | 1232 | {"type": "Polygon", "coordinates": [[[-117.7808, 33.69515], [-117.78058, 33.69552], [-117.78043, 33.69574], [-117.78018, 33.69602], [-117.77968, 33.69653], [-117.77962, 33.69653], [-117.77956, 33.6965], [-117.77908, 33.69618], [-117.78028, 33.69497], [-117.7808, 33.69515]]]} | Open Access 1 | 8919 | Presley Park | 23995 | 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 | 2.887 | Presley Park | 0 | Local Park 2 | 4 | |
1587 | 1587 | 1586 | {"type": "Polygon", "coordinates": [[[-117.77409, 33.71255], [-117.7732, 33.71343], [-117.77171, 33.71241], [-117.77169, 33.71233], [-117.77257, 33.71147], [-117.77409, 33.71255]]]} | Open Access 1 | 12163 | Brywood Park | 16463 | 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 | 5.92 | Brywood Park | 0 | Local Park 2 | 4 | |
1596 | 1596 | 1595 | {"type": "Polygon", "coordinates": [[[-117.80729, 33.64338], [-117.80672, 33.64397], [-117.80653, 33.6441], [-117.80609, 33.64423], [-117.8057, 33.64424], [-117.8056, 33.64404], [-117.80559, 33.6439], [-117.80564, 33.64372], [-117.80575, 33.64351], [-117.80584, 33.6434], [-117.8064, 33.6429], [-117.80645, 33.6429], [-117.80729, 33.64338]]]} | Open Access 1 | 12168 | Canyon Park | 16824 | 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 | 3.434 | Canyon Park | 0 | Local Park 2 | 4 | |
2446 | 2446 | 2445 | {"type": "Polygon", "coordinates": [[[-117.76119, 33.70774], [-117.76076, 33.70816], [-117.76051, 33.70835], [-117.76025, 33.70817], [-117.76017, 33.70825], [-117.75947, 33.70777], [-117.75971, 33.70754], [-117.75967, 33.7074], [-117.75973, 33.70737], [-117.75987, 33.70726], [-117.76013, 33.70701], [-117.76119, 33.70774]]]} | Open Access 1 | 12173 | Carrotwood Park | 16920 | 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 | 3.091 | Carrotwood Park | 0 | Local Park 2 | 4 | |
2448 | 2448 | 2447 | {"type": "Polygon", "coordinates": [[[-117.817, 33.6335], [-117.81679, 33.63419], [-117.81524, 33.63392], [-117.81415, 33.63424], [-117.81405, 33.63482], [-117.8138, 33.63483], [-117.81329, 33.6346], [-117.81344, 33.63358], [-117.81313, 33.63353], [-117.81317, 33.63287], [-117.81436, 33.633], [-117.81478, 33.63303], [-117.81598, 33.63317], [-117.81644, 33.63328], [-117.817, 33.6335]]]} | Open Access 1 | 12179 | Chaparral Park | 17129 | 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 | 10.442 | Chaparral Park | 0 | Local Park 2 | 4 | |
2450 | 2450 | 2449 | {"type": "Polygon", "coordinates": [[[-117.75119, 33.72167], [-117.75027, 33.7226], [-117.75014, 33.72251], [-117.75, 33.72252], [-117.7486, 33.72155], [-117.75011, 33.72153], [-117.75056, 33.72156], [-117.75119, 33.72167]]]} | Open Access 1 | 12181 | Citrusglen Park | 17289 | 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 | 3.72 | Citrusglen Park | 0 | Local Park 2 | 4 | |
1606 | 1606 | 1605 | {"type": "Polygon", "coordinates": [[[-117.82591, 33.68843], [-117.82569, 33.68864], [-117.82544, 33.68883], [-117.82511, 33.68905], [-117.8249, 33.68915], [-117.82441, 33.68932], [-117.82382, 33.68946], [-117.82354, 33.6895], [-117.82297, 33.68955], [-117.82261, 33.68955], [-117.82202, 33.6895], [-117.82163, 33.68944], [-117.82136, 33.68937], [-117.821, 33.68924], [-117.82057, 33.68903], [-117.81908, 33.68801], [-117.81952, 33.68765], [-117.81976, 33.68748], [-117.82, 33.68734], [-117.82025, 33.6872], [-117.82072, 33.687], [-117.82085, 33.68701], [-117.82102, 33.68695], [-117.82109, 33.68686], [-117.8216, 33.68672], [-117.82327, 33.68646], [-117.82406, 33.68627], [-117.82456, 33.68608], [-117.82461, 33.68609], [-117.82498, 33.6867], [-117.82516, 33.68692], [-117.82537, 33.68713], [-117.82483, 33.68764], [-117.82591, 33.68843]]]} | Open Access 1 | 12277 | Colonel Bill Barber Marine Corps Memorial Park | 17526 | 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 | 37.944 | Colonel Bill Barber Marine Corps Memorial Park | 0 | Local Park 2 | 4 | |
7834 | 7834 | 7833 | {"type": "Polygon", "coordinates": [[[-117.77094, 33.74041], [-117.77055, 33.74081], [-117.77019, 33.74055], [-117.77005, 33.74048], [-117.77001, 33.74041], [-117.77015, 33.7402], [-117.77037, 33.73998], [-117.77093, 33.74037], [-117.77094, 33.74041]]]} | Open Access 1 | 12279 | Comstock Park | 17573 | 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 | 1.03 | Comstock Park | 0 | Local Park 2 | 4 | |
8123 | 8123 | 8122 | {"type": "Polygon", "coordinates": [[[-117.78277, 33.6636], [-117.78242, 33.66392], [-117.78272, 33.66416], [-117.7826, 33.66428], [-117.78273, 33.66438], [-117.78253, 33.66457], [-117.78248, 33.66455], [-117.78175, 33.66524], [-117.78151, 33.66504], [-117.78119, 33.66474], [-117.781, 33.66452], [-117.78071, 33.66412], [-117.78148, 33.66335], [-117.78185, 33.66295], [-117.78277, 33.6636]]]} | Open Access 1 | 12295 | Dovecreek Park | 18250 | 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 | 6.676 | Dovecreek Park | 0 | Local Park 2 | 4 | |
1611 | 1611 | 1610 | {"type": "Polygon", "coordinates": [[[-117.79664, 33.7004], [-117.79645, 33.70059], [-117.79646, 33.70063], [-117.79639, 33.70077], [-117.79622, 33.70094], [-117.79604, 33.70079], [-117.7955, 33.70028], [-117.79537, 33.70008], [-117.79535, 33.69985], [-117.79537, 33.69985], [-117.79556, 33.69966], [-117.79612, 33.70005], [-117.7964, 33.70021], [-117.79664, 33.7004]]]} | Open Access 1 | 12310 | Flagstone Park | 18936 | 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 | 1.963 | Flagstone Park | 0 | Local Park 2 | 4 | |
1613 | 1613 | 1612 | {"type": "Polygon", "coordinates": [[[-117.77216, 33.72465], [-117.77188, 33.72493], [-117.77189, 33.72518], [-117.77188, 33.7253], [-117.77184, 33.72545], [-117.77215, 33.72568], [-117.77145, 33.72639], [-117.77131, 33.72639], [-117.77106, 33.72619], [-117.77081, 33.72577], [-117.77063, 33.72553], [-117.77048, 33.72538], [-117.77025, 33.72522], [-117.7701, 33.72513], [-117.76989, 33.72504], [-117.76961, 33.72496], [-117.76876, 33.72484], [-117.76849, 33.72476], [-117.76815, 33.72458], [-117.76814, 33.72448], [-117.76855, 33.7241], [-117.76874, 33.72388], [-117.76968, 33.72299], [-117.76979, 33.72298], [-117.77216, 33.72465]]]} | Open Access 1 | 12329 | Hicks Canyon Community Park | 19899 | 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 | 15.997 | Hicks Canyon Community Park | 0 | Local Park 2 | 4 | |
8150 | 8150 | 8149 | {"type": "Polygon", "coordinates": [[[-117.77725, 33.68548], [-117.77669, 33.68604], [-117.77658, 33.68597], [-117.77641, 33.68596], [-117.77634, 33.68598], [-117.77629, 33.68606], [-117.77634, 33.68613], [-117.77641, 33.68616], [-117.77655, 33.68618], [-117.77583, 33.6869], [-117.77339, 33.68522], [-117.77379, 33.68482], [-117.77524, 33.68582], [-117.77619, 33.68487], [-117.77644, 33.68504], [-117.77653, 33.68497], [-117.77725, 33.68548]]]} | Open Access 1 | 12331 | Hoeptner Park | 20020 | 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 | 8.29 | Hoeptner Park | 0 | Local Park 2 | 4 | |
1615 | 1615 | 1614 | {"type": "Polygon", "coordinates": [[[-117.77406, 33.6503], [-117.77364, 33.64968], [-117.77292, 33.64894], [-117.7726, 33.64871], [-117.77183, 33.64826], [-117.77182, 33.64821], [-117.77206, 33.64793], [-117.77233, 33.64766], [-117.77285, 33.64718], [-117.773, 33.64708], [-117.77304, 33.64713], [-117.7733, 33.64819], [-117.77335, 33.6483], [-117.77342, 33.64837], [-117.77354, 33.64844], [-117.77391, 33.64855], [-117.77403, 33.64857], [-117.77396, 33.64895], [-117.77385, 33.64918], [-117.77383, 33.64927], [-117.77388, 33.64943], [-117.77407, 33.64989], [-117.7741, 33.65009], [-117.7741, 33.65019], [-117.77406, 33.6503]]]} | Open Access 1 | 12345 | Knollcrest Park | 20699 | 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 | 6.395 | Knollcrest Park | 0 | Local Park 2 | 4 | |
1639 | 1639 | 1638 | {"type": "Polygon", "coordinates": [[[-117.75592, 33.72636], [-117.75321, 33.72576], [-117.75327, 33.72558], [-117.75337, 33.72544], [-117.75337, 33.72535], [-117.75331, 33.72529], [-117.75322, 33.72526], [-117.75313, 33.72528], [-117.75307, 33.72533], [-117.75303, 33.7253], [-117.75335, 33.72435], [-117.75588, 33.72459], [-117.75592, 33.72463], [-117.75587, 33.72478], [-117.75591, 33.72487], [-117.75592, 33.72497], [-117.75592, 33.72636]]]} | Open Access 1 | 12489 | Meadowood Park | 22092 | 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 | 10.895 | Meadowood Park | 0 | Local Park 2 | 4 | |
8224 | 8224 | 8223 | {"type": "Polygon", "coordinates": [[[-117.77483, 33.7005], [-117.77383, 33.70109], [-117.77349, 33.70135], [-117.77324, 33.70159], [-117.77313, 33.70161], [-117.77247, 33.70114], [-117.77246, 33.70105], [-117.77341, 33.70011], [-117.77363, 33.70005], [-117.77372, 33.7], [-117.77381, 33.69988], [-117.77382, 33.6998], [-117.7738, 33.69968], [-117.7741, 33.69938], [-117.77483, 33.7005]]]} | Open Access 1 | 12533 | Orchard Park | 23190 | 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 | 5.831 | Orchard 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]);