units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
81 rows where MNG_AGENCY = 441 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST, GAP_STS
DES_TP 13
- Local Park 46
- Local Other or Unknown 21
- Local Recreation Area 4
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 81
MNG_AGENCY 1
- Napa, City of · 81 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15662 | 15662 | 15661 | {"type": "Polygon", "coordinates": [[[-122.28084, 38.26895], [-122.2782, 38.26902], [-122.27678, 38.2671], [-122.2763, 38.26736], [-122.27697, 38.26817], [-122.27675, 38.26949], [-122.27213, 38.27026], [-122.2719, 38.2693], [-122.27173, 38.26867], [-122.27151, 38.26765], [-122.27138, 38.26693], [-122.27119, 38.26559], [-122.27113, 38.26497], [-122.27106, 38.26416], [-122.27105, 38.26351], [-122.27168, 38.26331], [-122.27332, 38.2629], [-122.27458, 38.26299], [-122.2765, 38.26337], [-122.27675, 38.2632], [-122.27694, 38.26317], [-122.27776, 38.26348], [-122.27804, 38.26325], [-122.27815, 38.26282], [-122.27845, 38.26244], [-122.27855, 38.26202], [-122.2785, 38.26124], [-122.2787, 38.26096], [-122.27943, 38.26047], [-122.28056, 38.25989], [-122.28082, 38.2597], [-122.28084, 38.26895]]]} | Restricted Access 2 | 48419 | Napa Golf Course | 33054 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | https://www.playnapa.com/ | Napa 11 | 155.995 | Napa GC | 1958 | Local Recreation Area 3 | 4 |
15460 | 15460 | 15459 | {"type": "Polygon", "coordinates": [[[-122.28949, 38.30081], [-122.28933, 38.30084], [-122.28919, 38.30061], [-122.28941, 38.3005], [-122.28949, 38.30081]]]} | Open Access 1 | 36613 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.14 | 0 | Local Other or Unknown 14 | 4 | ||
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 4 | ||
15425 | 15425 | 15424 | {"type": "Polygon", "coordinates": [[[-122.28551, 38.30003], [-122.28537, 38.30004], [-122.2851, 38.30002], [-122.28483, 38.29997], [-122.28474, 38.29994], [-122.28466, 38.29988], [-122.28464, 38.29978], [-122.28466, 38.29969], [-122.28491, 38.29957], [-122.28493, 38.29958], [-122.2851, 38.2995], [-122.28551, 38.30003]]]} | Open Access 1 | 46688 | Opera House Plaza | 30024 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.667 | Opera House Plaza | 0 | Local Park 2 | 4 | |
14187 | 14187 | 14186 | {"type": "Polygon", "coordinates": [[[-122.34889, 38.32547], [-122.33942, 38.3285], [-122.33807, 38.32891], [-122.33607, 38.32689], [-122.3329, 38.32359], [-122.33245, 38.32311], [-122.33246, 38.32308], [-122.33217, 38.32281], [-122.33124, 38.32185], [-122.33674, 38.31863], [-122.33733, 38.31927], [-122.33932, 38.3214], [-122.33705, 38.32272], [-122.33922, 38.32563], [-122.34192, 38.32412], [-122.34274, 38.32412], [-122.34351, 38.32445], [-122.34406, 38.32413], [-122.34472, 38.32498], [-122.34857, 38.32273], [-122.34863, 38.32283], [-122.3486, 38.32316], [-122.34858, 38.32325], [-122.34819, 38.32387], [-122.34809, 38.32428], [-122.34811, 38.32446], [-122.34822, 38.32468], [-122.34857, 38.32514], [-122.3488, 38.32536], [-122.34889, 38.32547]]]} | Open Access 1 | 44005 | Alston Park | 15410 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 160.322 | Alston Park | 0 | Local Park 2 | 4 | |
13993 | 13993 | 13992 | {"type": "Polygon", "coordinates": [[[-122.31937, 38.32331], [-122.31916, 38.32342], [-122.31896, 38.32319], [-122.31911, 38.3231], [-122.31917, 38.3231], [-122.3192, 38.32312], [-122.31937, 38.32331]]]} | Open Access 1 | 36675 | Norfolk Park | 28719 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.163 | Norfolk Park | 0 | Local Park 2 | 4 | |
13963 | 13963 | 13962 | {"type": "MultiPolygon", "coordinates": [[[[-122.28468, 38.29955], [-122.28458, 38.2996], [-122.28455, 38.29959], [-122.28358, 38.30006], [-122.2835, 38.30004], [-122.28335, 38.29981], [-122.28331, 38.29978], [-122.28324, 38.29967], [-122.28328, 38.29968], [-122.28359, 38.29964], [-122.28379, 38.29958], [-122.28401, 38.29956], [-122.28408, 38.29952], [-122.28422, 38.2994], [-122.28428, 38.29931], [-122.28441, 38.29899], [-122.28446, 38.29901], [-122.2845, 38.29909], [-122.2845, 38.29919], [-122.28455, 38.29928], [-122.28456, 38.29935], [-122.28468, 38.29955]]], [[[-122.28501, 38.30032], [-122.28431, 38.30067], [-122.28388, 38.30011], [-122.28435, 38.29987], [-122.28445, 38.29987], [-122.28462, 38.30008], [-122.2847, 38.30016], [-122.28481, 38.30023], [-122.28501, 38.30032]]], [[[-122.28411, 38.30078], [-122.28403, 38.30082], [-122.28367, 38.30027], [-122.28367, 38.30022], [-122.28411, 38.30078]]], [[[-122.28538, 38.30072], [-122.28464, 38.30109], [-122.28441, 38.30081], [-122.28516, 38.30044], [-122.28538, 38.30072]]], [[[-122.28469, 38.30147], [-122.28457, 38.30153], [-122.28453, 38.30153], [-122.28449, 38.30151], [-122.28413, 38.30097], [-122.28425, 38.30091], [-122.28469, 38.30147]]], [[[-122.28469, 38.30262], [-122.28466, 38.30264], [-122.28454, 38.30251], [-122.28341, 38.30111], [-122.2837, 38.30098], [-122.28448, 38.30217], [-122.28469, 38.30262]]]]} | Open Access 1 | 36610 | Oxbow Commons | 30025 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 4.265 | Oxbow Commons | 0 | None 1194 | ||
13962 | 13962 | 13961 | {"type": "Polygon", "coordinates": [[[-122.26703, 38.29781], [-122.26696, 38.29802], [-122.26676, 38.29798], [-122.26667, 38.29805], [-122.26653, 38.29802], [-122.26644, 38.29812], [-122.26642, 38.29821], [-122.26621, 38.29835], [-122.26576, 38.29831], [-122.26553, 38.29825], [-122.26592, 38.29724], [-122.26623, 38.29734], [-122.26628, 38.2974], [-122.26631, 38.29747], [-122.26637, 38.29753], [-122.26643, 38.29755], [-122.2665, 38.29754], [-122.26673, 38.29762], [-122.26681, 38.29777], [-122.26703, 38.29781]]]} | No Public Access 3 | 36606 | Hidden Glen Park | 30022 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.182 | Hidden Glen Park | 0 | Local Park 2 | 4 | |
13961 | 13961 | 13960 | {"type": "Polygon", "coordinates": [[[-122.29798, 38.33067], [-122.2977, 38.3306], [-122.29733, 38.3304], [-122.29739, 38.33037], [-122.29739, 38.33035], [-122.2971, 38.33019], [-122.29687, 38.33011], [-122.29654, 38.33007], [-122.29575, 38.33011], [-122.29559, 38.33009], [-122.29548, 38.33006], [-122.29536, 38.33], [-122.29524, 38.32991], [-122.29512, 38.32975], [-122.29513, 38.32973], [-122.29505, 38.32962], [-122.29489, 38.32949], [-122.29512, 38.32911], [-122.29524, 38.3297], [-122.29541, 38.32982], [-122.29557, 38.3298], [-122.29556, 38.32988], [-122.29561, 38.32994], [-122.29571, 38.32996], [-122.29584, 38.32991], [-122.29655, 38.32983], [-122.29684, 38.32984], [-122.29713, 38.32989], [-122.29742, 38.33002], [-122.29773, 38.33028], [-122.29771, 38.33032], [-122.29798, 38.33067]]]} | Open Access 1 | 36604 | Silverado Creek Maintenance District | 30031 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.919 | Silverado Creek Maintenance District | None 1193 | |||
13960 | 13960 | 13959 | {"type": "Polygon", "coordinates": [[[-122.29905, 38.32779], [-122.29848, 38.32836], [-122.29839, 38.32842], [-122.29828, 38.32846], [-122.29818, 38.32846], [-122.29777, 38.32842], [-122.29754, 38.32853], [-122.29772, 38.32878], [-122.29763, 38.32882], [-122.29773, 38.32895], [-122.29741, 38.32886], [-122.29693, 38.32878], [-122.29676, 38.32872], [-122.29662, 38.32864], [-122.2972, 38.3285], [-122.2977, 38.32826], [-122.29767, 38.3282], [-122.29787, 38.32817], [-122.29791, 38.32814], [-122.29796, 38.32817], [-122.29801, 38.32814], [-122.29814, 38.32821], [-122.29825, 38.3282], [-122.29829, 38.32816], [-122.29829, 38.32811], [-122.29869, 38.32773], [-122.29876, 38.32764], [-122.29889, 38.32758], [-122.29905, 38.32779]]]} | No Public Access 3 | 36602 | Silverado Creek Maintenance District | 30030 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1.843 | Silverado Creek Maintenance District | None 1192 | |||
13958 | 13958 | 13957 | {"type": "Polygon", "coordinates": [[[-122.31222, 38.32659], [-122.31188, 38.32665], [-122.31184, 38.32664], [-122.31177, 38.32656], [-122.31206, 38.32641], [-122.31222, 38.32659]]]} | Open Access 1 | 36600 | Tallac Park | 30019 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.144 | Tallac Park | 0 | Local Park 2 | 4 | |
13957 | 13957 | 13956 | {"type": "Polygon", "coordinates": [[[-122.31129, 38.33053], [-122.31128, 38.33057], [-122.31125, 38.3306], [-122.3111, 38.33063], [-122.31102, 38.33039], [-122.31124, 38.33035], [-122.31129, 38.33053]]]} | Open Access 1 | 36599 | Sequoia Tot Lot | 30029 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.125 | Sequoia Tot Lot | 0 | Local Recreation Area 3 | 4 | |
13956 | 13956 | 13955 | {"type": "Polygon", "coordinates": [[[-122.29666, 38.32881], [-122.29641, 38.32889], [-122.29616, 38.32894], [-122.29588, 38.32897], [-122.29553, 38.32898], [-122.29532, 38.32901], [-122.29516, 38.32904], [-122.29489, 38.32949], [-122.29377, 38.32872], [-122.29434, 38.32843], [-122.29473, 38.32871], [-122.29487, 38.32875], [-122.29508, 38.32873], [-122.29512, 38.32886], [-122.29533, 38.3288], [-122.29577, 38.32878], [-122.29645, 38.32868], [-122.29666, 38.32881]]]} | Open Access 1 | 36598 | Silverado Creek Maintenance District | 30031 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.383 | Silverado Creek Maintenance District | None 1191 | |||
13800 | 13800 | 13799 | {"type": "Polygon", "coordinates": [[[-122.28559, 38.30298], [-122.28546, 38.30304], [-122.28532, 38.30306], [-122.28526, 38.3031], [-122.28524, 38.30316], [-122.28527, 38.30322], [-122.28533, 38.30325], [-122.28542, 38.30325], [-122.2853, 38.30331], [-122.28527, 38.30341], [-122.28522, 38.30308], [-122.28511, 38.3027], [-122.28509, 38.30244], [-122.28536, 38.30231], [-122.28542, 38.30233], [-122.28556, 38.30244], [-122.2855, 38.30244], [-122.28546, 38.30246], [-122.28538, 38.30275], [-122.28537, 38.30289], [-122.28539, 38.30299], [-122.28543, 38.30302], [-122.28548, 38.30302], [-122.28559, 38.30298]]]} | Open Access 1 | 36368 | Solomon Grove | 30032 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.52 | Solomon Grove | 0 | Local Park 2 | 4 | |
13798 | 13798 | 13797 | {"type": "Polygon", "coordinates": [[[-122.315, 38.30559], [-122.31509, 38.3059], [-122.31495, 38.30683], [-122.31487, 38.30684], [-122.31498, 38.3062], [-122.31491, 38.30619], [-122.315, 38.30559]]]} | Open Access 1 | 36366 | Linda Vista Connection | 30023 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.27 | Linda Vista Connection | None 1187 | |||
13794 | 13794 | 13793 | {"type": "Polygon", "coordinates": [[[-122.28173, 38.30282], [-122.28177, 38.30281], [-122.28187, 38.30284], [-122.28199, 38.30295], [-122.28213, 38.30313], [-122.2823, 38.30365], [-122.28241, 38.30419], [-122.2824, 38.30431], [-122.28236, 38.30442], [-122.28231, 38.3047], [-122.28223, 38.305], [-122.28213, 38.30518], [-122.28199, 38.30533], [-122.28194, 38.30541], [-122.2816, 38.30576], [-122.2815, 38.30588], [-122.28044, 38.3068], [-122.28003, 38.30667], [-122.2801, 38.3057], [-122.28032, 38.30569], [-122.28044, 38.30503], [-122.28063, 38.30497], [-122.28081, 38.30483], [-122.28096, 38.30459], [-122.28097, 38.30452], [-122.28111, 38.30437], [-122.28133, 38.30392], [-122.28154, 38.30356], [-122.28157, 38.30317], [-122.28173, 38.30282]]]} | Open Access 1 | 36362 | Oxbow Preserve | 28577 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 10.376 | Oxbow Preserve | 0 | Local Conservation Area 4 | 2 | |
13774 | 13774 | 13773 | {"type": "Polygon", "coordinates": [[[-122.28658, 38.29983], [-122.28636, 38.29994], [-122.28629, 38.29985], [-122.28651, 38.29973], [-122.28658, 38.29983]]]} | Open Access 1 | 36318 | 9/11 Memorial Garden | 30016 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.071 | 9/11 Memorial Garden | 0 | Local Park 2 | 4 | |
13773 | 13773 | 13772 | {"type": "Polygon", "coordinates": [[[-122.33177, 38.34428], [-122.33175, 38.34431], [-122.33172, 38.34433], [-122.33079, 38.34464], [-122.33074, 38.34464], [-122.33068, 38.34461], [-122.33044, 38.34416], [-122.33035, 38.34408], [-122.33024, 38.34405], [-122.33013, 38.34405], [-122.32963, 38.34421], [-122.32949, 38.34396], [-122.3313, 38.34335], [-122.33133, 38.34341], [-122.33126, 38.34417], [-122.33131, 38.3444], [-122.33176, 38.34425], [-122.33177, 38.34428]]]} | Open Access 1 | 36314 | Abruzzini Park | 28575 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 2.854 | Abruzzini Park | 0 | Local Park 2 | 4 | |
13761 | 13761 | 13760 | {"type": "Polygon", "coordinates": [[[-122.29458, 38.30493], [-122.29454, 38.30498], [-122.29445, 38.305], [-122.29438, 38.30471], [-122.29435, 38.3047], [-122.29436, 38.30468], [-122.29451, 38.30474], [-122.29458, 38.30493]]]} | Open Access 1 | 36281 | Jefferson Park | 28694 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.087 | Jefferson Park | 0 | Local Park 2 | 4 | |
13611 | 13611 | 13610 | {"type": "Polygon", "coordinates": [[[-122.30454, 38.32522], [-122.30452, 38.32526], [-122.30436, 38.32541], [-122.30419, 38.32528], [-122.3044, 38.3251], [-122.30452, 38.32519], [-122.30454, 38.32522]]]} | Open Access 1 | 36296 | Beckworth Tot Lot | 28574 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.134 | Beckworth Tot Lot | 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]);