units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
151 rows where MNG_AGENCY = 110 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 12
- Local Other or Unknown 106
- Local Park 31
- Local Recreation Area 5
- Local Conservation Area 1
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 149
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 151
MNG_AGENCY 1
- Ventura, City of · 151 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6399 | 6399 | 6398 | {"type": "Polygon", "coordinates": [[[-119.30632, 34.28842], [-119.30581, 34.28848], [-119.30579, 34.28839], [-119.30544, 34.28832], [-119.30545, 34.28825], [-119.30517, 34.28819], [-119.30526, 34.28788], [-119.30528, 34.28788], [-119.30548, 34.28723], [-119.3048, 34.28708], [-119.30488, 34.28682], [-119.30484, 34.2868], [-119.30508, 34.286], [-119.30511, 34.28599], [-119.30523, 34.28552], [-119.30545, 34.28556], [-119.30573, 34.28597], [-119.30591, 34.28634], [-119.30599, 34.2866], [-119.30604, 34.28684], [-119.30632, 34.28842]]]} | Open Access 1 | 1843 | Westpark Community Center | 27416 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 6.235 | Westpark Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
10582 | 10582 | 10581 | {"type": "Polygon", "coordinates": [[[-119.29759, 34.27487], [-119.29711, 34.2751], [-119.29675, 34.27523], [-119.29406, 34.276], [-119.29353, 34.27611], [-119.29296, 34.27615], [-119.29296, 34.27585], [-119.29317, 34.27581], [-119.29354, 34.2757], [-119.29388, 34.27557], [-119.294, 34.27551], [-119.29421, 34.27545], [-119.29488, 34.27522], [-119.29675, 34.27469], [-119.29758, 34.27441], [-119.29759, 34.27487]]]} | Open Access 1 | 18842 | Waterfront Promenade | 30392 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 5.853 | Waterfront Promenade | 0 | None 931 | ||
13251 | 13251 | 13250 | {"type": "Polygon", "coordinates": [[[-119.19394, 34.28125], [-119.19393, 34.28125], [-119.1939, 34.28121], [-119.19385, 34.2812], [-119.19316, 34.28133], [-119.19299, 34.28152], [-119.19315, 34.28186], [-119.19341, 34.28221], [-119.1934, 34.28222], [-119.19324, 34.28201], [-119.19311, 34.28181], [-119.19297, 34.28152], [-119.19293, 34.28142], [-119.19294, 34.28138], [-119.193, 34.28134], [-119.19385, 34.28119], [-119.19391, 34.2812], [-119.19394, 34.28125]]]} | Open Access 1 | 35296 | Ventura holding 99 | 26983 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.127 | Ventura holding 99 | 0 | Local Other or Unknown 14 | 4 | |
13253 | 13253 | 13252 | {"type": "Polygon", "coordinates": [[[-119.18424, 34.28252], [-119.18342, 34.28264], [-119.18296, 34.28272], [-119.18242, 34.28286], [-119.18238, 34.2829], [-119.18239, 34.28295], [-119.18238, 34.28296], [-119.18236, 34.28293], [-119.18237, 34.28288], [-119.18241, 34.28285], [-119.18296, 34.28271], [-119.18351, 34.28261], [-119.18423, 34.28251], [-119.18424, 34.28252]]]} | Open Access 1 | 35298 | Ventura holding 98 | 26982 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.069 | Ventura holding 98 | 0 | Local Other or Unknown 14 | 4 | |
13254 | 13254 | 13253 | {"type": "Polygon", "coordinates": [[[-119.16704, 34.29601], [-119.16663, 34.29625], [-119.16528, 34.29542], [-119.16408, 34.29455], [-119.1635, 34.29388], [-119.16364, 34.2938], [-119.16372, 34.29381], [-119.16398, 34.29415], [-119.16414, 34.2943], [-119.1646, 34.29464], [-119.16496, 34.2948], [-119.1651, 34.29489], [-119.16566, 34.29542], [-119.16603, 34.29569], [-119.1662, 34.29578], [-119.16643, 34.29587], [-119.16704, 34.29601]]]} | Open Access 1 | 35299 | Ventura holding 97 | 26981 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.39 | Ventura holding 97 | 0 | Local Other or Unknown 14 | 4 | |
13242 | 13242 | 13241 | {"type": "Polygon", "coordinates": [[[-119.16635, 34.26389], [-119.16519, 34.26459], [-119.16502, 34.26471], [-119.16483, 34.26489], [-119.16434, 34.26543], [-119.16427, 34.26549], [-119.16421, 34.26561], [-119.16421, 34.26569], [-119.16426, 34.26578], [-119.16434, 34.26585], [-119.16477, 34.26636], [-119.16504, 34.2666], [-119.16527, 34.26674], [-119.16561, 34.2669], [-119.1657, 34.26691], [-119.16578, 34.2669], [-119.16591, 34.26683], [-119.16615, 34.26702], [-119.16593, 34.26727], [-119.16504, 34.26697], [-119.16402, 34.26581], [-119.16411, 34.2656], [-119.16436, 34.26534], [-119.16444, 34.26513], [-119.16455, 34.26502], [-119.16479, 34.26487], [-119.16484, 34.26469], [-119.16556, 34.26419], [-119.1657, 34.26396], [-119.16584, 34.2639], [-119.16613, 34.26396], [-119.1662, 34.26389], [-119.16635, 34.26389]]]} | Open Access 1 | 35286 | Ventura holding 96 | 26980 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.502 | Ventura holding 96 | 0 | Local Other or Unknown 14 | 4 | |
13246 | 13246 | 13245 | {"type": "Polygon", "coordinates": [[[-119.17722, 34.26059], [-119.17718, 34.26059], [-119.1769, 34.26038], [-119.17675, 34.26011], [-119.17642, 34.26014], [-119.17633, 34.26019], [-119.17607, 34.26025], [-119.17606, 34.26031], [-119.17581, 34.26047], [-119.17576, 34.26057], [-119.17563, 34.26054], [-119.17562, 34.26057], [-119.17457, 34.26054], [-119.17433, 34.26059], [-119.17373, 34.26086], [-119.17364, 34.26092], [-119.17348, 34.26107], [-119.1734, 34.26125], [-119.17333, 34.26123], [-119.1731, 34.26128], [-119.17327, 34.26119], [-119.17314, 34.26103], [-119.1732, 34.26095], [-119.17334, 34.26091], [-119.17346, 34.26078], [-119.17379, 34.26074], [-119.17388, 34.26062], [-119.17398, 34.26054], [-119.17407, 34.26054], [-119.17415, 34.26045], [-119.17425, 34.26039], [-119.17435, 34.26037], [-119.17453, 34.26046], [-119.17481, 34.26044], [-119.17483, 34.26029], [-119.17491, 34.26023], [-119.17511, 34.26028], [-119.17528, 34.26021], [-119.17545, 34.26027], [-119.17545, 34.26046], [-119.17563, 34.26049], [-119.17587, 34.26021], [-119.17616, 34.26002], [-119.17644, 34.25999], [-119.17658, 34.26003], [-119.17678, 34.25991], [-119.17703, 34.26039], [-119.1772, 34.26049], [-119.17722, 34.26059]]]} | Open Access 1 | 35291 | Ventura holding 95 | 26979 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.007 | Ventura holding 95 | 0 | Local Other or Unknown 14 | 4 | |
13247 | 13247 | 13246 | {"type": "Polygon", "coordinates": [[[-119.19609, 34.25545], [-119.19601, 34.2557], [-119.19558, 34.25596], [-119.19573, 34.25634], [-119.19517, 34.25684], [-119.195, 34.25825], [-119.19511, 34.25833], [-119.19501, 34.2584], [-119.19502, 34.25842], [-119.19529, 34.25841], [-119.19556, 34.25848], [-119.19553, 34.25863], [-119.19561, 34.25882], [-119.19558, 34.25897], [-119.19561, 34.25909], [-119.19556, 34.25911], [-119.19527, 34.25939], [-119.19534, 34.25961], [-119.19546, 34.25977], [-119.19544, 34.25994], [-119.19549, 34.26001], [-119.19557, 34.26002], [-119.19566, 34.26014], [-119.19585, 34.26029], [-119.19558, 34.2604], [-119.19544, 34.26052], [-119.19538, 34.26068], [-119.19541, 34.26096], [-119.19572, 34.2614], [-119.19513, 34.26146], [-119.19508, 34.26144], [-119.19506, 34.2614], [-119.19504, 34.2614], [-119.19477, 34.26015], [-119.19476, 34.26005], [-119.19472, 34.25997], [-119.19466, 34.25991], [-119.19483, 34.2597], [-119.19479, 34.25953], [-119.19479, 34.2591], [-119.19482, 34.25885], [-119.19471, 34.25886], [-119.19449, 34.25865], [-119.19439, 34.2585], [-119.19435, 34.25834], [-119.19436, 34.25822], [-119.19472, 34.2571], [-119.19477, 34.25669], [-119.19474, 34.25649], [-119.19497, 34.25635], [-119.19493, 34.25607], [-119.19484, 34.25574], [-119.19535, 34.25561], [-119.19581, 34.25515], [-119.19587, 34.25511], [-119.19609, 34.25545]]]} | Open Access 1 | 35292 | Ventura holding 94 | 26978 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 10.393 | Ventura holding 94 | 0 | Local Other or Unknown 14 | 4 | |
13249 | 13249 | 13248 | {"type": "Polygon", "coordinates": [[[-119.19871, 34.28098], [-119.19821, 34.2821], [-119.19765, 34.28218], [-119.19803, 34.28189], [-119.19846, 34.28084], [-119.19839, 34.28049], [-119.19865, 34.28045], [-119.19871, 34.28098]]]} | Open Access 1 | 35294 | Ventura holding 93 | 26977 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.228 | Ventura holding 93 | 0 | Local Other or Unknown 14 | 4 | |
13250 | 13250 | 13249 | {"type": "Polygon", "coordinates": [[[-119.20753, 34.27207], [-119.20215, 34.27284], [-119.20212, 34.27268], [-119.2061, 34.27211], [-119.20613, 34.272], [-119.20633, 34.27201], [-119.20648, 34.272], [-119.20749, 34.27186], [-119.20753, 34.27207]]]} | Open Access 1 | 35295 | Ventura holding 92 | 26976 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.462 | Ventura holding 92 | 0 | Local Other or Unknown 14 | 4 | |
13243 | 13243 | 13242 | {"type": "Polygon", "coordinates": [[[-119.16877, 34.27064], [-119.16876, 34.27067], [-119.16858, 34.27045], [-119.16824, 34.27065], [-119.16814, 34.27064], [-119.16805, 34.2704], [-119.16835, 34.2703], [-119.16825, 34.27004], [-119.1683, 34.27007], [-119.16877, 34.27064]]]} | Open Access 1 | 35287 | Ventura holding 91 | 26975 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.372 | Ventura holding 91 | 0 | Local Other or Unknown 14 | 4 | |
13244 | 13244 | 13243 | {"type": "Polygon", "coordinates": [[[-119.17644, 34.27619], [-119.17638, 34.27618], [-119.17631, 34.27613], [-119.17498, 34.27458], [-119.17492, 34.27461], [-119.17453, 34.27415], [-119.17424, 34.27389], [-119.17402, 34.27356], [-119.17305, 34.27243], [-119.17267, 34.27214], [-119.17256, 34.2719], [-119.17264, 34.27187], [-119.17365, 34.27303], [-119.1737, 34.27301], [-119.17644, 34.27619]]]} | Open Access 1 | 35288 | Ventura holding 90 | 26974 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.325 | Ventura holding 90 | 0 | Local Other or Unknown 14 | 4 | |
13293 | 13293 | 13292 | {"type": "Polygon", "coordinates": [[[-119.16634, 34.29607], [-119.16607, 34.29624], [-119.16596, 34.29619], [-119.16577, 34.29615], [-119.16539, 34.29594], [-119.16519, 34.29578], [-119.16492, 34.29544], [-119.16475, 34.29542], [-119.16458, 34.2953], [-119.16488, 34.29512], [-119.16528, 34.29542], [-119.16634, 34.29607]]]} | Open Access 1 | 35347 | Ventura holding 9 | 26973 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.437 | Ventura holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13358 | 13358 | 13357 | {"type": "Polygon", "coordinates": [[[-119.19275, 34.28192], [-119.19271, 34.28193], [-119.1926, 34.28171], [-119.19254, 34.28155], [-119.19235, 34.28146], [-119.19161, 34.28157], [-119.19154, 34.28157], [-119.19154, 34.28155], [-119.19249, 34.28142], [-119.19255, 34.28146], [-119.19264, 34.28171], [-119.19275, 34.28192]]]} | Open Access 1 | 35442 | Ventura holding 89 | 26972 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.134 | Ventura holding 89 | 0 | Local Other or Unknown 14 | 4 | |
13221 | 13221 | 13220 | {"type": "Polygon", "coordinates": [[[-119.21697, 34.27068], [-119.21561, 34.27081], [-119.21516, 34.27077], [-119.21415, 34.27013], [-119.21391, 34.26989], [-119.21431, 34.27002], [-119.21524, 34.27061], [-119.21561, 34.27064], [-119.21683, 34.27053], [-119.21625, 34.26775], [-119.21635, 34.26774], [-119.21697, 34.27068]]]} | Open Access 1 | 35265 | Ventura holding 88 | 26971 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 2.072 | Ventura holding 88 | 0 | Local Other or Unknown 14 | 4 | |
13241 | 13241 | 13240 | {"type": "Polygon", "coordinates": [[[-119.16534, 34.2838], [-119.16455, 34.28426], [-119.16452, 34.28422], [-119.1653, 34.28375], [-119.16534, 34.2838]]]} | Open Access 1 | 35285 | Ventura holding 87 | 26970 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.134 | Ventura holding 87 | 0 | Local Other or Unknown 14 | 4 | |
13255 | 13255 | 13254 | {"type": "Polygon", "coordinates": [[[-119.19505, 34.28555], [-119.19504, 34.28555], [-119.19479, 34.28417], [-119.1948, 34.28417], [-119.19481, 34.28421], [-119.19505, 34.28555]]]} | Open Access 1 | 35300 | Ventura holding 86 | 26969 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.062 | Ventura holding 86 | 0 | Local Other or Unknown 14 | 4 | |
13319 | 13319 | 13318 | {"type": "Polygon", "coordinates": [[[-119.18668, 34.27476], [-119.18653, 34.27485], [-119.18635, 34.27494], [-119.18614, 34.27501], [-119.18595, 34.27505], [-119.18591, 34.27489], [-119.18668, 34.27476]]]} | Open Access 1 | 35386 | Ventura holding 85 | 26968 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.223 | Ventura holding 85 | 0 | Local Other or Unknown 14 | 4 | |
13364 | 13364 | 13363 | {"type": "Polygon", "coordinates": [[[-119.16402, 34.26635], [-119.16385, 34.26637], [-119.16372, 34.26644], [-119.16282, 34.26747], [-119.16251, 34.2678], [-119.16206, 34.26825], [-119.16157, 34.2687], [-119.16099, 34.26909], [-119.16055, 34.26934], [-119.16056, 34.2694], [-119.16043, 34.26944], [-119.16041, 34.26935], [-119.16045, 34.26929], [-119.16078, 34.26907], [-119.16111, 34.26888], [-119.16175, 34.26841], [-119.16204, 34.26813], [-119.16259, 34.26754], [-119.1629, 34.26729], [-119.163, 34.26716], [-119.16328, 34.26671], [-119.1636, 34.26628], [-119.16368, 34.26625], [-119.16375, 34.26624], [-119.16402, 34.26635]]]} | Open Access 1 | 35448 | Ventura holding 84 | 26967 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.391 | Ventura holding 84 | 0 | Local Other or Unknown 14 | 4 | |
13366 | 13366 | 13365 | {"type": "Polygon", "coordinates": [[[-119.23078, 34.26794], [-119.23067, 34.26801], [-119.23012, 34.26824], [-119.22828, 34.26888], [-119.22827, 34.26888], [-119.22763, 34.26905], [-119.22708, 34.26919], [-119.22632, 34.26934], [-119.22629, 34.26922], [-119.22652, 34.26918], [-119.22658, 34.26907], [-119.22667, 34.26907], [-119.22675, 34.26904], [-119.22688, 34.26911], [-119.2273, 34.26901], [-119.22734, 34.26895], [-119.22745, 34.26896], [-119.22751, 34.26894], [-119.22755, 34.2689], [-119.22764, 34.26892], [-119.22785, 34.26888], [-119.22807, 34.26881], [-119.2281, 34.26874], [-119.2282, 34.26874], [-119.2283, 34.26866], [-119.22831, 34.2686], [-119.22844, 34.26854], [-119.22876, 34.26844], [-119.22962, 34.26828], [-119.22984, 34.26822], [-119.23014, 34.26806], [-119.23028, 34.26803], [-119.23073, 34.26776], [-119.23078, 34.26794]]]} | Open Access 1 | 35450 | Ventura holding 83 | 26966 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 1.931 | Ventura holding 83 | 0 | Local Other or Unknown 14 | 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]);