units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 356 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 37
- Local Recreation Area 3
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 42
MNG_AGENCY 1
- Temecula, City of · 42 ✖
ACCESS_TYP 1
- Open Access 42
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12000 | 12000 | 11999 | {"type": "Polygon", "coordinates": [[[-117.11583, 33.50748], [-117.11567, 33.50773], [-117.11554, 33.50786], [-117.11541, 33.50795], [-117.11516, 33.50761], [-117.11542, 33.50749], [-117.11557, 33.50746], [-117.11583, 33.50748]]]} | Open Access 1 | 24660 | Bahia Vista Park | 15757 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.448 | Bahia Vista Park | 0 | Local Park 2 | 4 | |
12001 | 12001 | 12000 | {"type": "Polygon", "coordinates": [[[-117.07232, 33.49361], [-117.07254, 33.49376], [-117.07268, 33.49391], [-117.0728, 33.49405], [-117.07282, 33.49416], [-117.07282, 33.49428], [-117.0727, 33.49468], [-117.07266, 33.49507], [-117.07261, 33.49514], [-117.0725, 33.49519], [-117.07242, 33.49519], [-117.07234, 33.49515], [-117.07199, 33.49485], [-117.07171, 33.49426], [-117.07232, 33.49361]]]} | Open Access 1 | 24661 | Butterfield Stage Park | 16610 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.798 | Butterfield Stage Park | 0 | Local Park 2 | 4 | |
12127 | 12127 | 12126 | {"type": "Polygon", "coordinates": [[[-117.1166, 33.50629], [-117.11631, 33.50635], [-117.11602, 33.50645], [-117.11596, 33.50643], [-117.11587, 33.50631], [-117.11612, 33.50616], [-117.11647, 33.50585], [-117.1166, 33.50629]]]} | Open Access 1 | 25091 | Calle Aragon Park | 16734 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 0.518 | Calle Aragon Park | 0 | Local Park 2 | 4 | |
12002 | 12002 | 12001 | {"type": "Polygon", "coordinates": [[[-117.07528, 33.4991], [-117.07508, 33.49922], [-117.07485, 33.49926], [-117.07477, 33.49928], [-117.07472, 33.49934], [-117.07471, 33.49943], [-117.07466, 33.49937], [-117.07456, 33.4991], [-117.07455, 33.49897], [-117.07444, 33.49883], [-117.07437, 33.49867], [-117.07419, 33.49838], [-117.0741, 33.49817], [-117.07404, 33.49763], [-117.07405, 33.49747], [-117.07413, 33.49735], [-117.07447, 33.49703], [-117.07482, 33.49778], [-117.07483, 33.4979], [-117.07478, 33.49807], [-117.07479, 33.49817], [-117.07528, 33.4991]]]} | Open Access 1 | 24663 | Crown Hill Park | 17836 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 3.554 | Crown Hill Park | 0 | Local Park 2 | 4 | |
12003 | 12003 | 12002 | {"type": "Polygon", "coordinates": [[[-117.16228, 33.53348], [-117.16196, 33.53361], [-117.16192, 33.53368], [-117.16186, 33.53367], [-117.16178, 33.53369], [-117.16159, 33.5339], [-117.16119, 33.53413], [-117.16087, 33.53437], [-117.16082, 33.53437], [-117.16047, 33.5341], [-117.1602, 33.53392], [-117.15983, 33.53373], [-117.15956, 33.53364], [-117.15923, 33.53355], [-117.15881, 33.53349], [-117.15846, 33.53347], [-117.1581, 33.53348], [-117.15805, 33.53342], [-117.158, 33.53308], [-117.15795, 33.53289], [-117.15786, 33.53272], [-117.1577, 33.53248], [-117.15764, 33.53236], [-117.1576, 33.53218], [-117.15761, 33.53199], [-117.15771, 33.53184], [-117.15772, 33.53173], [-117.15782, 33.53171], [-117.15803, 33.53138], [-117.15884, 33.53175], [-117.15922, 33.53188], [-117.15974, 33.53197], [-117.1604, 33.53201], [-117.16064, 33.53206], [-117.16088, 33.53213], [-117.16125, 33.53228], [-117.16128, 33.53237], [-117.16155, 33.53251], [-117.1616, 33.53245], [-117.16184, 33.53253], [-117.16207, 33.53258], [-117.16212, 33.53263], [-117.16213, 33.53284], [-117.16217, 33.53307], [-117.16228, 33.53348]]]} | Open Access 1 | 24664 | Harveston Community Park | 19726 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 19.649 | Harveston Community Park | 0 | Local Park 2 | 4 | |
12004 | 12004 | 12003 | {"type": "Polygon", "coordinates": [[[-117.15937, 33.53929], [-117.15932, 33.53932], [-117.1593, 33.53935], [-117.15819, 33.53992], [-117.15794, 33.53946], [-117.15772, 33.53921], [-117.15759, 33.53887], [-117.15708, 33.53847], [-117.15689, 33.53833], [-117.15648, 33.53811], [-117.15602, 33.53795], [-117.15587, 33.5379], [-117.1558, 33.5379], [-117.15572, 33.53792], [-117.15564, 33.538], [-117.15525, 33.53789], [-117.15524, 33.5379], [-117.15454, 33.53771], [-117.15448, 33.53764], [-117.15436, 33.5376], [-117.1543, 33.53752], [-117.1542, 33.53748], [-117.15423, 33.53727], [-117.1543, 33.53703], [-117.15446, 33.53677], [-117.15463, 33.53658], [-117.1547, 33.53663], [-117.15474, 33.53672], [-117.15484, 33.53674], [-117.15487, 33.53677], [-117.15489, 33.53684], [-117.15551, 33.53701], [-117.15566, 33.53702], [-117.15589, 33.537], [-117.15603, 33.53702], [-117.15646, 33.53717], [-117.15658, 33.53694], [-117.15667, 33.53699], [-117.15724, 33.53718], [-117.15745, 33.53717], [-117.15765, 33.53705], [-117.15795, 33.53675], [-117.15823, 33.53691], [-117.15816, 33.53716], [-117.15813, 33.53742], [-117.15817, 33.53769], [-117.15825, 33.53792], [-117.15831, 33.53804], [-117.15898, 33.53897], [-117.15905, 33.53899], [-117.15913, 33.539], [-117.15932, 33.53925], [-117.15934, 33.53925], [-117.15937, 33.53929]]]} | Open Access 1 | 24665 | Harveston Lake Park | 19727 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 15.933 | Harveston Lake Park | 0 | Local Park 2 | 4 | |
10707 | 10707 | 10706 | {"type": "Polygon", "coordinates": [[[-117.11049, 33.47644], [-117.11016, 33.47649], [-117.10983, 33.47658], [-117.10978, 33.47649], [-117.10973, 33.47622], [-117.10966, 33.47605], [-117.11027, 33.47583], [-117.11049, 33.47644]]]} | Open Access 1 | 19945 | John Magee Park | 20454 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 1.004 | John Magee Park | 0 | Local Park 2 | 4 | |
11351 | 11351 | 11350 | {"type": "Polygon", "coordinates": [[[-117.10801, 33.46849], [-117.10772, 33.46877], [-117.10777, 33.46892], [-117.10753, 33.4688], [-117.10734, 33.46872], [-117.10704, 33.46862], [-117.10696, 33.4686], [-117.10693, 33.46872], [-117.10732, 33.46885], [-117.10764, 33.469], [-117.10757, 33.46905], [-117.10746, 33.46925], [-117.10715, 33.46966], [-117.10693, 33.46989], [-117.1067, 33.4697], [-117.1064, 33.46989], [-117.10623, 33.46997], [-117.10552, 33.47017], [-117.10529, 33.47014], [-117.10436, 33.46922], [-117.10495, 33.46856], [-117.10552, 33.46853], [-117.1059, 33.46854], [-117.10626, 33.46858], [-117.10662, 33.46864], [-117.10662, 33.46862], [-117.10627, 33.46816], [-117.10631, 33.4681], [-117.10696, 33.46824], [-117.1073, 33.46834], [-117.10762, 33.46841], [-117.1078, 33.46848], [-117.10801, 33.46849]]]} | Open Access 1 | 22133 | Kent Hintergardt Park | 20618 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 10.603 | Kent Hintergardt Park | 0 | Local Park 2 | 4 | |
11354 | 11354 | 11353 | {"type": "MultiPolygon", "coordinates": [[[[-117.11599, 33.46106], [-117.11574, 33.46129], [-117.11556, 33.46115], [-117.11541, 33.46097], [-117.11535, 33.46094], [-117.11528, 33.46094], [-117.11525, 33.46092], [-117.11581, 33.4604], [-117.11594, 33.4605], [-117.1159, 33.46055], [-117.1159, 33.46061], [-117.11593, 33.46067], [-117.11597, 33.46071], [-117.11577, 33.4609], [-117.11599, 33.46106]]], [[[-117.11583, 33.46164], [-117.11582, 33.4617], [-117.11559, 33.46182], [-117.1155, 33.46171], [-117.11575, 33.46154], [-117.11583, 33.46164]]], [[[-117.1169, 33.46281], [-117.11663, 33.46291], [-117.1164, 33.46307], [-117.11633, 33.46307], [-117.11625, 33.46301], [-117.11649, 33.46273], [-117.11645, 33.46267], [-117.11623, 33.46263], [-117.11609, 33.46256], [-117.1159, 33.46244], [-117.1157, 33.46211], [-117.11561, 33.46201], [-117.11591, 33.46184], [-117.11597, 33.46186], [-117.11624, 33.4623], [-117.1163, 33.46233], [-117.11636, 33.46234], [-117.11647, 33.4623], [-117.11674, 33.46255], [-117.11681, 33.46253], [-117.1169, 33.46281]]], [[[-117.1174, 33.46295], [-117.11732, 33.46333], [-117.11706, 33.46324], [-117.11694, 33.46328], [-117.11684, 33.46334], [-117.11662, 33.46312], [-117.11679, 33.46302], [-117.11699, 33.46296], [-117.1172, 33.46294], [-117.1174, 33.46295]]]]} | Open Access 1 | 22135 | Loma Linda Park | 21404 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.824 | Loma Linda Park | 0 | Local Park 2 | 4 | |
14508 | 14508 | 14507 | {"type": "Polygon", "coordinates": [[[-117.14566, 33.52561], [-117.14522, 33.52578], [-117.14436, 33.52614], [-117.14366, 33.52501], [-117.14504, 33.52448], [-117.14566, 33.52561]]]} | Open Access 1 | 47166 | Long Canyon Creek Park | 30851 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/LongCanyonCreekPark.htm | Riverside 10 | 4.714 | Long Canyon Creek Park | 0 | Local Park 2 | 4 |
11337 | 11337 | 11336 | {"type": "Polygon", "coordinates": [[[-117.14724, 33.50857], [-117.14673, 33.50922], [-117.14464, 33.51176], [-117.14419, 33.51166], [-117.14335, 33.51155], [-117.14327, 33.5087], [-117.14724, 33.50857]]]} | Open Access 1 | 22138 | Margarita Community Park | 21804 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 20.371 | Margarita Community Park | 0 | Local Park 2 | 4 | |
14514 | 14514 | 14513 | {"type": "Polygon", "coordinates": [[[-117.09537, 33.50221], [-117.09525, 33.50278], [-117.09519, 33.50314], [-117.09517, 33.5035], [-117.09519, 33.50386], [-117.09465, 33.50394], [-117.09457, 33.504], [-117.09443, 33.50388], [-117.09427, 33.50379], [-117.09409, 33.50372], [-117.0939, 33.50368], [-117.09377, 33.50334], [-117.09357, 33.50308], [-117.09344, 33.50296], [-117.09326, 33.50272], [-117.09343, 33.50273], [-117.09355, 33.50272], [-117.09404, 33.50255], [-117.09418, 33.50253], [-117.09435, 33.50256], [-117.09462, 33.50269], [-117.09471, 33.5027], [-117.0948, 33.50269], [-117.09489, 33.50266], [-117.095, 33.50259], [-117.09524, 33.50231], [-117.09537, 33.50221]]]} | Open Access 1 | 47178 | Meadows Park | 30869 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/MeadowsPark.htm | Riverside 10 | 5.02 | Meadows Park | 0 | Local Park 2 | 4 |
14503 | 14503 | 14502 | {"type": "Polygon", "coordinates": [[[-117.07142, 33.46775], [-117.07017, 33.46885], [-117.0688, 33.46777], [-117.06886, 33.46752], [-117.06918, 33.46734], [-117.06988, 33.46678], [-117.07124, 33.4677], [-117.07141, 33.4677], [-117.07142, 33.46775]]]} | Open Access 1 | 47159 | Morgan Hill Park | 30839 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 6.985 | Morgan Hill Park | 0 | Local Park 2 | 4 | |
14504 | 14504 | 14503 | {"type": "Polygon", "coordinates": [[[-117.12483, 33.54045], [-117.12482, 33.5405], [-117.12439, 33.5407], [-117.1243, 33.54083], [-117.1236, 33.54113], [-117.12349, 33.54113], [-117.12349, 33.5408], [-117.12355, 33.54074], [-117.12483, 33.54045]]]} | Open Access 1 | 47161 | Nakayama Park | 30841 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/NakayamaPark.htm | Riverside 10 | 0.85 | Nakayama Park | 0 | Local Park 2 | 4 |
2850 | 2850 | 2849 | {"type": "Polygon", "coordinates": [[[-117.13628, 33.53783], [-117.1363, 33.53802], [-117.13629, 33.53814], [-117.13615, 33.53855], [-117.13606, 33.53872], [-117.13577, 33.53862], [-117.13556, 33.53846], [-117.13547, 33.53844], [-117.13542, 33.53845], [-117.13535, 33.53849], [-117.13532, 33.53853], [-117.13532, 33.53858], [-117.13521, 33.53864], [-117.13517, 33.53863], [-117.1351, 33.53885], [-117.13473, 33.53879], [-117.13436, 33.53867], [-117.13439, 33.5383], [-117.13445, 33.53824], [-117.13628, 33.53783]]]} | Open Access 1 | 22139 | Nicholas Road Park | 22746 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.913 | Nicholas Road Park | 0 | Local Park 2 | 4 | |
1402 | 1402 | 1401 | {"type": "Polygon", "coordinates": [[[-117.08454, 33.47208], [-117.0844, 33.47245], [-117.0842, 33.47242], [-117.08399, 33.47242], [-117.08296, 33.47253], [-117.08286, 33.47192], [-117.0832, 33.47194], [-117.08362, 33.47192], [-117.084, 33.47187], [-117.08447, 33.47176], [-117.08454, 33.47208]]]} | Open Access 1 | 24672 | Pablo Apis Park | 23288 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 2.311 | Pablo Apis Park | 0 | Local Park 2 | 4 | |
10730 | 10730 | 10729 | {"type": "Polygon", "coordinates": [[[-117.11883, 33.47183], [-117.11881, 33.47215], [-117.11854, 33.47215], [-117.11859, 33.47236], [-117.11831, 33.47245], [-117.11803, 33.47263], [-117.11786, 33.47257], [-117.11659, 33.47255], [-117.11712, 33.4707], [-117.11736, 33.47089], [-117.11786, 33.4712], [-117.11811, 33.47138], [-117.11835, 33.47165], [-117.11847, 33.47191], [-117.11877, 33.47183], [-117.11883, 33.47183]]]} | Open Access 1 | 19947 | Pala Community Park | 23324 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 6.204 | Pala Community Park | 0 | Local Park 2 | 4 | |
10728 | 10728 | 10727 | {"type": "Polygon", "coordinates": [[[-117.10272, 33.48405], [-117.10188, 33.48425], [-117.10114, 33.4824], [-117.10199, 33.48216], [-117.10272, 33.48405]]]} | Open Access 1 | 19944 | Paloma Del Sol | 23362 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 4.482 | Paloma Del Sol | None 939 | |||
14507 | 14507 | 14506 | {"type": "Polygon", "coordinates": [[[-117.10065, 33.4847], [-117.10063, 33.48478], [-117.1002, 33.4851], [-117.09986, 33.48541], [-117.09965, 33.48565], [-117.0992, 33.48624], [-117.09869, 33.4859], [-117.09778, 33.48523], [-117.09929, 33.48366], [-117.09955, 33.48378], [-117.09979, 33.48391], [-117.10001, 33.48406], [-117.10022, 33.48422], [-117.10041, 33.4844], [-117.10065, 33.4847]]]} | Open Access 1 | 47165 | Paloma del Sol Park | 30850 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/Parks/PalomaDelSolPark.htm | Riverside 10 | 9.513 | Paloma del Sol Park | 0 | Local Park 2 | 4 |
3398 | 3398 | 3397 | {"type": "Polygon", "coordinates": [[[-117.09041, 33.45956], [-117.08996, 33.45999], [-117.08989, 33.46], [-117.08897, 33.45931], [-117.08964, 33.45898], [-117.09041, 33.45956]]]} | Open Access 1 | 24673 | Paseo Gallante Park | 23497 | 1392 | Temecula, City of 359 | City 2 | City Agency 2 | http://www.cityoftemecula.org/ | City 2 | 1392 | Temecula, City of 356 | City 2 | City Agency 2 | Riverside 10 | 1.822 | Paseo Gallante 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]);