units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where MNG_AGENCY = 147 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 6
- Local Park 34
- Local Recreation Area 17
- Local Other or Unknown 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 55
MNG_AGENCY 1
- Vacaville, City of · 55 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8907 | 8907 | 8906 | {"type": "Polygon", "coordinates": [[[-121.93771, 38.33788], [-121.93742, 38.33801], [-121.93737, 38.33801], [-121.93735, 38.33792], [-121.93726, 38.33783], [-121.93714, 38.33766], [-121.93745, 38.33754], [-121.93746, 38.33756], [-121.93748, 38.33755], [-121.93771, 38.33788]]]} | Open Access 1 | 14608 | Normandy Meadows Park | 22802 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 0.348 | Normandy Meadows Park | 0 | Local Park 2 | 4 | |
5533 | 5533 | 5532 | {"type": "Polygon", "coordinates": [[[-121.99558, 38.35148], [-121.99557, 38.35246], [-121.99455, 38.35242], [-121.99456, 38.35201], [-121.99463, 38.35204], [-121.99477, 38.35189], [-121.99494, 38.35198], [-121.9955, 38.35142], [-121.99558, 38.35148]]]} | Open Access 1 | 28308 | City Hall Park | 17297 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 1.604 | City Hall Park | 0 | Local Park 2 | 4 | |
609 | 609 | 608 | {"type": "Polygon", "coordinates": [[[-121.99599, 38.34541], [-121.996, 38.34585], [-121.99597, 38.34627], [-121.99595, 38.3463], [-121.99545, 38.34591], [-121.99482, 38.34547], [-121.99467, 38.34534], [-121.99471, 38.34529], [-121.99483, 38.34527], [-121.99493, 38.34517], [-121.99495, 38.34513], [-121.99517, 38.345], [-121.99541, 38.34498], [-121.99553, 38.34509], [-121.99599, 38.34541]]]} | Open Access 1 | 2135 | Willows Park | 27595 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 2.146 | Willows Park | 0 | Local Park 2 | 4 | |
8909 | 8909 | 8908 | {"type": "Polygon", "coordinates": [[[-121.93802, 38.34747], [-121.93781, 38.34767], [-121.93757, 38.34785], [-121.93717, 38.34808], [-121.93699, 38.3479], [-121.9367, 38.34778], [-121.93632, 38.34772], [-121.93654, 38.3474], [-121.93659, 38.34724], [-121.93655, 38.3469], [-121.93738, 38.34715], [-121.93774, 38.34731], [-121.93802, 38.34747]]]} | Open Access 1 | 14616 | Arbor Oaks Park | 15557 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 2.503 | Arbor Oaks Park | 0 | Local Park 2 | 4 | |
427 | 427 | 426 | {"type": "Polygon", "coordinates": [[[-121.98272, 38.36571], [-121.98118, 38.36563], [-121.9812, 38.36528], [-121.98124, 38.36513], [-121.98126, 38.36473], [-121.98231, 38.36477], [-121.98241, 38.3648], [-121.98251, 38.36487], [-121.98263, 38.36502], [-121.9827, 38.36517], [-121.98273, 38.36528], [-121.98274, 38.36538], [-121.98272, 38.36571]]]} | Open Access 1 | 1707 | Trower Park | 26551 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 3.156 | Trower Park | 0 | Local Park 2 | 4 | |
3185 | 3185 | 3184 | {"type": "Polygon", "coordinates": [[[-121.95731, 38.35578], [-121.95713, 38.3558], [-121.95691, 38.35576], [-121.9559, 38.35575], [-121.95516, 38.35589], [-121.95513, 38.35581], [-121.95508, 38.35509], [-121.95524, 38.35507], [-121.95571, 38.35509], [-121.95729, 38.35512], [-121.95731, 38.35578]]]} | Open Access 1 | 22098 | Hawkins Park | 19747 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 3.62 | Hawkins Park | 0 | Local Park 2 | 4 | |
12476 | 12476 | 12475 | {"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]} | Restricted Access 2 | 28306 | Alamo School Park | 31601 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.025 | Alamo School Park | 0 | Local Park 2 | 4 | |
12486 | 12486 | 12485 | {"type": "Polygon", "coordinates": [[[-121.96822, 38.34465], [-121.96747, 38.34465], [-121.96746, 38.34486], [-121.96708, 38.34487], [-121.96685, 38.34508], [-121.96639, 38.34508], [-121.96634, 38.34513], [-121.96604, 38.34513], [-121.96601, 38.34426], [-121.96746, 38.34388], [-121.96798, 38.34383], [-121.96822, 38.3444], [-121.96822, 38.34465]]]} | Open Access 1 | 28310 | Fairmont Park | 18807 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.578 | Fairmont Park | 0 | Local Park 2 | 4 | |
8906 | 8906 | 8905 | {"type": "Polygon", "coordinates": [[[-121.97746, 38.33536], [-121.97613, 38.33537], [-121.97493, 38.33531], [-121.97494, 38.33448], [-121.97594, 38.3345], [-121.97638, 38.3345], [-121.97697, 38.33447], [-121.97703, 38.33448], [-121.97746, 38.33536]]]} | Open Access 1 | 14606 | Irene Larsen Park | 20230 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.766 | Irene Larsen Park | 0 | Local Park 2 | 4 | |
2503 | 2503 | 2502 | {"type": "Polygon", "coordinates": [[[-121.99456, 38.36909], [-121.99411, 38.3691], [-121.99408, 38.36876], [-121.99398, 38.36861], [-121.99375, 38.36861], [-121.99349, 38.36854], [-121.99343, 38.36841], [-121.9933, 38.36817], [-121.99323, 38.36786], [-121.99312, 38.36768], [-121.99282, 38.36767], [-121.99271, 38.3675], [-121.99255, 38.36745], [-121.99243, 38.36729], [-121.99246, 38.36718], [-121.99266, 38.3671], [-121.9927, 38.36702], [-121.99259, 38.36691], [-121.99254, 38.3668], [-121.99247, 38.36628], [-121.99303, 38.36629], [-121.99302, 38.36652], [-121.99312, 38.36671], [-121.99354, 38.36721], [-121.99358, 38.36746], [-121.9938, 38.36762], [-121.99395, 38.36809], [-121.99404, 38.36819], [-121.99432, 38.36844], [-121.99453, 38.36879], [-121.99455, 38.36887], [-121.99456, 38.36909]]]} | Open Access 1 | 22094 | Burton Estates Open Space | 16531 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.783 | Burton Estates OS | 0 | Local Recreation Area 3 | 4 | |
10486 | 10486 | 10485 | {"type": "Polygon", "coordinates": [[[-121.96102, 38.34372], [-121.96098, 38.34418], [-121.95996, 38.34417], [-121.95962, 38.34419], [-121.95942, 38.34426], [-121.95929, 38.34436], [-121.95911, 38.34456], [-121.9591, 38.34461], [-121.95905, 38.34472], [-121.95863, 38.34452], [-121.95828, 38.34438], [-121.96021, 38.34292], [-121.96031, 38.34294], [-121.96038, 38.34319], [-121.96045, 38.34331], [-121.96072, 38.34351], [-121.96097, 38.34362], [-121.96102, 38.34372]]]} | Open Access 1 | 18577 | Beelard Park | 15952 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.892 | Beelard Park | 0 | Local Park 2 | 4 | |
5259 | 5259 | 5258 | {"type": "Polygon", "coordinates": [[[-121.98321, 38.3821], [-121.98298, 38.38215], [-121.98292, 38.38219], [-121.98281, 38.3822], [-121.9828, 38.38225], [-121.98239, 38.38227], [-121.98219, 38.38216], [-121.9817, 38.38258], [-121.98166, 38.38269], [-121.98169, 38.38312], [-121.98133, 38.383], [-121.98129, 38.38281], [-121.98136, 38.38255], [-121.98145, 38.38239], [-121.98151, 38.38207], [-121.98162, 38.38199], [-121.98163, 38.38159], [-121.98169, 38.38144], [-121.98176, 38.3813], [-121.98175, 38.38118], [-121.98177, 38.38108], [-121.9817, 38.38091], [-121.98231, 38.38064], [-121.98292, 38.38144], [-121.98307, 38.38174], [-121.98321, 38.3821]]]} | Open Access 1 | 1945 | Boulder Valley Park | 16298 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.077 | Boulder Valley Park | 0 | Local Park 2 | 4 | |
10484 | 10484 | 10483 | {"type": "Polygon", "coordinates": [[[-121.93713, 38.35011], [-121.9371, 38.35129], [-121.93419, 38.35123], [-121.93413, 38.35121], [-121.93412, 38.35071], [-121.93458, 38.35072], [-121.93493, 38.35078], [-121.93534, 38.35094], [-121.93547, 38.35091], [-121.9358, 38.35049], [-121.93598, 38.35031], [-121.93639, 38.35036], [-121.93664, 38.35006], [-121.93713, 38.35011]]]} | Open Access 1 | 18568 | Patwin Park | 23525 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.201 | Patwin Park | 0 | Local Park 2 | 4 | |
367 | 367 | 366 | {"type": "Polygon", "coordinates": [[[-121.97916, 38.3386], [-121.97897, 38.3387], [-121.97854, 38.33903], [-121.97832, 38.33915], [-121.9779, 38.33933], [-121.97754, 38.33938], [-121.97698, 38.33931], [-121.97687, 38.33916], [-121.97685, 38.33905], [-121.97684, 38.33888], [-121.97677, 38.33872], [-121.97662, 38.33863], [-121.97638, 38.3386], [-121.97607, 38.33854], [-121.97557, 38.33841], [-121.97526, 38.33838], [-121.97427, 38.33859], [-121.97412, 38.33833], [-121.97479, 38.33815], [-121.97508, 38.3381], [-121.97549, 38.3381], [-121.97579, 38.33815], [-121.9764, 38.33833], [-121.97679, 38.3385], [-121.97683, 38.33855], [-121.97688, 38.33857], [-121.97694, 38.33858], [-121.97702, 38.33855], [-121.97708, 38.33849], [-121.97733, 38.33851], [-121.97744, 38.33855], [-121.97823, 38.33856], [-121.97833, 38.33858], [-121.9785, 38.33859], [-121.9787, 38.33856], [-121.97909, 38.33843], [-121.97916, 38.3386]]]} | Open Access 1 | 1048 | Southwood Park | 25704 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.256 | Southwood Park | 0 | Local Park 2 | 4 | |
12497 | 12497 | 12496 | {"type": "Polygon", "coordinates": [[[-122.0039, 38.3646], [-122.00387, 38.36624], [-122.00154, 38.3662], [-122.00153, 38.36566], [-122.00163, 38.36566], [-122.00165, 38.36592], [-122.00216, 38.36593], [-122.00217, 38.36567], [-122.00267, 38.36566], [-122.00267, 38.36535], [-122.00318, 38.36535], [-122.00318, 38.36517], [-122.00274, 38.36462], [-122.00284, 38.36458], [-122.0039, 38.3646]]]} | Restricted Access 2 | 28311 | Hemlock School Park | 31596 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.323 | Hemlock School Park | 0 | Local Park 2 | 4 | |
400 | 400 | 399 | {"type": "Polygon", "coordinates": [[[-121.93951, 38.36208], [-121.9394, 38.3621], [-121.93921, 38.36218], [-121.93907, 38.36221], [-121.93876, 38.36222], [-121.93861, 38.36224], [-121.93817, 38.36246], [-121.938, 38.36247], [-121.93788, 38.36242], [-121.93768, 38.36205], [-121.93759, 38.36196], [-121.93748, 38.36181], [-121.93743, 38.36171], [-121.93741, 38.36157], [-121.93736, 38.36147], [-121.93732, 38.36111], [-121.93771, 38.36102], [-121.93861, 38.36076], [-121.93867, 38.36075], [-121.93871, 38.36078], [-121.93918, 38.36149], [-121.93951, 38.36208]]]} | Open Access 1 | 1215 | Stonegate Park | 25888 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.702 | Stonegate Park | 0 | Local Park 2 | 4 | |
16172 | 16172 | 16171 | {"type": "Polygon", "coordinates": [[[-121.99711, 38.33597], [-121.99696, 38.33658], [-121.99624, 38.33724], [-121.99624, 38.33727], [-121.99622, 38.33729], [-121.99618, 38.33722], [-121.99598, 38.33713], [-121.99592, 38.33707], [-121.9959, 38.33707], [-121.99558, 38.3369], [-121.9953, 38.3368], [-121.99497, 38.33653], [-121.9947, 38.33614], [-121.99455, 38.3357], [-121.99448, 38.33566], [-121.99442, 38.33555], [-121.99457, 38.33541], [-121.99466, 38.33526], [-121.99474, 38.33509], [-121.99478, 38.33493], [-121.99488, 38.33482], [-121.99491, 38.33477], [-121.9949, 38.3347], [-121.99482, 38.33466], [-121.99468, 38.33465], [-121.99458, 38.33456], [-121.99437, 38.33453], [-121.99421, 38.33453], [-121.99402, 38.33444], [-121.99364, 38.33418], [-121.99354, 38.33409], [-121.99357, 38.33405], [-121.9936, 38.33403], [-121.9937, 38.3342], [-121.99393, 38.33436], [-121.99423, 38.33447], [-121.9947, 38.33448], [-121.99521, 38.3346], [-121.99522, 38.33477], [-121.99501, 38.33517], [-121.99493, 38.33561], [-121.99504, 38.33593], [-121.99519, 38.33606], [-121.99598, 38.33629], [-121.99698, 38.33581], [-121.99711, 38.33597]]]} | Open Access 1 | 22095 | California Drive Open Space | 16717 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.805 | California Drive OS | 0 | Local Recreation Area 3 | 4 | |
2815 | 2815 | 2814 | {"type": "Polygon", "coordinates": [[[-121.96614, 38.32851], [-121.96612, 38.3291], [-121.96613, 38.3305], [-121.96517, 38.33049], [-121.96492, 38.33057], [-121.96477, 38.33058], [-121.96476, 38.32979], [-121.96478, 38.32969], [-121.96485, 38.32961], [-121.96498, 38.32955], [-121.96519, 38.32935], [-121.96521, 38.32926], [-121.96471, 38.32864], [-121.96508, 38.32834], [-121.96614, 38.32851]]]} | Open Access 1 | 18669 | Pheasant Country Park | 23639 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 6.213 | Pheasant Country Park | 0 | Local Park 2 | 4 | |
1314 | 1314 | 1313 | {"type": "Polygon", "coordinates": [[[-121.95495, 38.3235], [-121.95351, 38.3235], [-121.95349, 38.32364], [-121.9532, 38.32352], [-121.95304, 38.32352], [-121.95289, 38.32347], [-121.95235, 38.32348], [-121.95234, 38.32251], [-121.95241, 38.32246], [-121.95487, 38.32245], [-121.95491, 38.32249], [-121.95492, 38.32321], [-121.95495, 38.3235]]]} | Open Access 1 | 7375 | Cannon Station Park | 16805 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 6.485 | Cannon Station Park | 0 | Local Park 2 | 4 | |
10299 | 10299 | 10298 | {"type": "Polygon", "coordinates": [[[-121.98466, 38.34086], [-121.98464, 38.34235], [-121.98409, 38.34235], [-121.98391, 38.34241], [-121.98377, 38.3425], [-121.9837, 38.3425], [-121.98344, 38.34239], [-121.98326, 38.34234], [-121.98295, 38.34233], [-121.98292, 38.34226], [-121.98292, 38.34209], [-121.98289, 38.34198], [-121.98282, 38.34182], [-121.98276, 38.34172], [-121.98274, 38.34156], [-121.98275, 38.34126], [-121.98279, 38.34108], [-121.98296, 38.34101], [-121.98302, 38.34093], [-121.98312, 38.34087], [-121.98466, 38.34086]]]} | Open Access 1 | 18448 | Padan Park | 23313 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 6.609 | Padan 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]);