units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 3, AGNCY_NAME = 282, AGNCY_WEB = "http://www.ladwp.com/" and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
907 | 907 | 906 | {"type": "Polygon", "coordinates": [[[-118.57306, 34.07116], [-118.57275, 34.07156], [-118.57161, 34.07199], [-118.57078, 34.07438], [-118.56939, 34.07481], [-118.56849, 34.07435], [-118.56719, 34.07493], [-118.56601, 34.07456], [-118.56562, 34.0739], [-118.56573, 34.07186], [-118.56463, 34.07084], [-118.56607, 34.0706], [-118.5687, 34.07091], [-118.56976, 34.07088], [-118.57133, 34.0713], [-118.57211, 34.07034], [-118.57306, 34.07116]]]} | No Public Access 3 | 6358 | Santa Ynez Reservoir | 29145 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | https://www.ladwp.com | Los Angeles 6 | 58.139 | Santa Ynez Reservoir | 0 | Local Recreation Area 3 | 4 |
4749 | 4749 | 4748 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | 46441 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 0.248 | 0 | Local Other or Unknown 14 | 4 | ||
4780 | 4780 | 4779 | {"type": "Polygon", "coordinates": [[[-118.47366, 34.29783], [-118.47355, 34.29793], [-118.47333, 34.2977], [-118.47324, 34.29763], [-118.47288, 34.29749], [-118.47272, 34.29746], [-118.47223, 34.29752], [-118.47187, 34.29753], [-118.47171, 34.2975], [-118.47156, 34.29743], [-118.47049, 34.29842], [-118.47038, 34.29838], [-118.47028, 34.29842], [-118.47025, 34.29846], [-118.47024, 34.29851], [-118.47025, 34.29856], [-118.47029, 34.2986], [-118.46993, 34.29891], [-118.469, 34.29819], [-118.46832, 34.29879], [-118.46779, 34.29838], [-118.46751, 34.29861], [-118.46695, 34.29818], [-118.4664, 34.29866], [-118.46584, 34.29823], [-118.4659, 34.29817], [-118.4659, 34.29816], [-118.46567, 34.29798], [-118.4656, 34.29804], [-118.46529, 34.2978], [-118.46558, 34.29754], [-118.46494, 34.29704], [-118.46518, 34.29675], [-118.466, 34.29475], [-118.46893, 34.29378], [-118.46908, 34.29382], [-118.46937, 34.29407], [-118.47092, 34.29532], [-118.47113, 34.29569], [-118.47219, 34.29665], [-118.47274, 34.2972], [-118.47291, 34.29709], [-118.47366, 34.29783]]]} | No Public Access 3 | 47096 | Unnamed site - Los Angeles - Department of Water and Power, City of | 30755 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 61.962 | 0 | Local Other or Unknown 14 | 4 | ||
7206 | 7206 | 7205 | {"type": "Polygon", "coordinates": [[[-118.53199, 34.13086], [-118.53157, 34.13089], [-118.53158, 34.1414], [-118.52971, 34.14142], [-118.53159, 34.14423], [-118.53159, 34.1448], [-118.52693, 34.13786], [-118.52623, 34.13835], [-118.52655, 34.13883], [-118.52671, 34.13941], [-118.52619, 34.13982], [-118.52654, 34.14024], [-118.5265, 34.14086], [-118.52508, 34.14129], [-118.52458, 34.14171], [-118.52427, 34.14153], [-118.52349, 34.14199], [-118.52345, 34.14202], [-118.52345, 34.14204], [-118.52433, 34.14267], [-118.52403, 34.14305], [-118.52334, 34.1435], [-118.52256, 34.14376], [-118.52178, 34.14386], [-118.52154, 34.14426], [-118.52253, 34.14524], [-118.52254, 34.14572], [-118.52281, 34.14589], [-118.52257, 34.14623], [-118.52179, 34.14638], [-118.52054, 34.14697], [-118.52014, 34.14699], [-118.51985, 34.1475], [-118.52, 34.14761], [-118.51946, 34.14793], [-118.51925, 34.14844], [-118.51851, 34.14889], [-118.51851, 34.15098], [-118.51473, 34.15097], [-118.51472, 34.15098], [-118.51473, 34.15121], [-118.51406, 34.15122], [-118.51404, 34.15097], [-118.51033, 34.15096], [-118.51024, 34.15054], [-118.51042, 34.14991], [-118.51042, 34.14967], [-118.5096, 34.14966], [-118.50959, 34.14804], [-118.50867, 34.1481], [-118.50754, 34.14781], [-118.50751, 34.14775], [-118.50722, 34.14734], [-118.50677, 34.14726], [-118.50691, 34.14561], [-118.50723, 34.14542], [-118.50723, 34.14394], [-118.50676, 34.1431], [-118.50643, 34.1429], [-118.50519, 34.14065], [-118.50614, 34.13863], [-118.50663, 34.13797], [-118.50663, 34.1314], [-118.50849, 34.13136], [-118.50849, 34.13135], [-118.50847, 34.13131], [-118.50877, 34.13129], [-118.50899, 34.13123], [-118.50921, 34.13113], [-118.50935, 34.13104], [-118.50947, 34.13098], [-118.50959, 34.13095], [-118.50978, 34.13094], [-118.51001, 34.13098], [-118.5102, 34.13099], [-118.51051, 34.13093], [-118.51074, 34.13083], [-118.5109, 34.1307], [-118.51103, 34.13053], [-118.51115, 34.13027], [-118.51124, 34.13019], [-118.51196, 34.12982], [-118.51228, 34.1298], [-118.51255, 34.12974], [-118.5128, 34.12964], [-118.51299, 34.12951], [-118.51412, 34.13011], [-118.51425, 34.13013], [-118.51437, 34.13008], [-118.51442, 34.13003], [-118.51445, 34.12995], [-118.51444, 34.12988], [-118.51441, 34.12983], [-118.51381, 34.12933], [-118.51619, 34.12912], [-118.51656, 34.12927], [-118.51677, 34.1293], [-118.51699, 34.1293], [-118.51787, 34.12917], [-118.51799, 34.12917], [-118.5181, 34.12921], [-118.51829, 34.12931], [-118.51845, 34.12936], [-118.51873, 34.1294], [-118.51888, 34.12939], [-118.51915, 34.12932], [-118.52149, 34.12833], [-118.52164, 34.12829], [-118.52184, 34.12829], [-118.52199, 34.12832], [-118.5221, 34.12836], [-118.52226, 34.12846], [-118.52246, 34.12852], [-118.52422, 34.12882], [-118.52447, 34.12893], [-118.52472, 34.12899], [-118.52502, 34.12899], [-118.52537, 34.12891], [-118.52595, 34.12893], [-118.5261, 34.12895], [-118.52617, 34.129], [-118.52632, 34.12919], [-118.52655, 34.12934], [-118.52676, 34.12941], [-118.52736, 34.12952], [-118.52756, 34.12954], [-118.52777, 34.12952], [-118.52801, 34.12945], [-118.52815, 34.12944], [-118.52821, 34.12946], [-118.52831, 34.12951], [-118.52869, 34.12984], [-118.52874, 34.12996], [-118.52874, 34.13004], [-118.52866, 34.13022], [-118.52863, 34.13034], [-118.52863, 34.13044], [-118.52866, 34.13053], [-118.52872, 34.13066], [-118.52883, 34.13077], [-118.52896, 34.13086], [-118.52911, 34.13091], [-118.52921, 34.13093], [-118.52941, 34.13092], [-118.52958, 34.13088], [-118.52975, 34.13078], [-118.52984, 34.13069], [-118.52992, 34.13056], [-118.52996, 34.13045], [-118.52994, 34.13027], [-118.52997, 34.13022], [-118.53001, 34.13021], [-118.53005, 34.13021], [-118.53088, 34.13043], [-118.53108, 34.13044], [-118.5313, 34.1304], [-118.53143, 34.13036], [-118.53151, 34.13032], [-118.53167, 34.13019], [-118.53182, 34.13029], [-118.53186, 34.13034], [-118.53196, 34.13078], [-118.53199, 34.13086]]]} | No Public Access 3 | 6366 | Encino Reservoir | 29102 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 1058.843 | Encino Reservoir | 0 | Local Recreation Area 3 | 4 | |
7435 | 7435 | 7434 | {"type": "Polygon", "coordinates": [[[-118.33685, 34.12715], [-118.33681, 34.12722], [-118.33673, 34.12727], [-118.3365, 34.1273], [-118.33642, 34.12733], [-118.33636, 34.12739], [-118.33632, 34.12746], [-118.33619, 34.12796], [-118.3362, 34.12822], [-118.33632, 34.12856], [-118.33632, 34.12869], [-118.33627, 34.12879], [-118.33615, 34.12887], [-118.33598, 34.1289], [-118.33582, 34.12885], [-118.33573, 34.12878], [-118.33565, 34.12874], [-118.33554, 34.12873], [-118.33543, 34.12878], [-118.33529, 34.12892], [-118.3352, 34.12897], [-118.33502, 34.12898], [-118.33493, 34.12895], [-118.33483, 34.12886], [-118.33479, 34.12879], [-118.33478, 34.12871], [-118.33471, 34.12861], [-118.33462, 34.12855], [-118.33448, 34.12851], [-118.33442, 34.12845], [-118.33437, 34.12836], [-118.33437, 34.12829], [-118.33441, 34.1282], [-118.33446, 34.12817], [-118.33469, 34.12804], [-118.33479, 34.12794], [-118.33494, 34.12767], [-118.33495, 34.12761], [-118.33492, 34.12752], [-118.33489, 34.12746], [-118.33477, 34.12734], [-118.33476, 34.12724], [-118.33479, 34.12717], [-118.33484, 34.12713], [-118.33502, 34.12703], [-118.33507, 34.12698], [-118.33512, 34.12689], [-118.33512, 34.1268], [-118.335, 34.12634], [-118.33494, 34.12627], [-118.33483, 34.12622], [-118.33438, 34.12627], [-118.33431, 34.12625], [-118.33424, 34.12619], [-118.33421, 34.12613], [-118.33421, 34.12606], [-118.33437, 34.1256], [-118.33434, 34.1255], [-118.33425, 34.12544], [-118.33414, 34.12543], [-118.33387, 34.12545], [-118.33378, 34.12548], [-118.33352, 34.1256], [-118.3334, 34.1256], [-118.33331, 34.12556], [-118.33324, 34.1255], [-118.33321, 34.12541], [-118.33328, 34.12505], [-118.33327, 34.12498], [-118.33321, 34.12493], [-118.33317, 34.12493], [-118.33301, 34.12494], [-118.33293, 34.12491], [-118.33288, 34.12486], [-118.33281, 34.12475], [-118.33274, 34.12471], [-118.33269, 34.1247], [-118.3326, 34.12472], [-118.33251, 34.12482], [-118.33247, 34.12491], [-118.33246, 34.12506], [-118.33236, 34.12517], [-118.33226, 34.1252], [-118.33205, 34.1252], [-118.33199, 34.12521], [-118.33189, 34.12528], [-118.33185, 34.12534], [-118.33186, 34.12556], [-118.33189, 34.12567], [-118.33232, 34.12631], [-118.33233, 34.12641], [-118.33229, 34.12647], [-118.33224, 34.12651], [-118.33216, 34.12654], [-118.33202, 34.12653], [-118.3315, 34.12623], [-118.3314, 34.12622], [-118.33127, 34.12623], [-118.33126, 34.12633], [-118.33109, 34.12637], [-118.33082, 34.12663], [-118.33067, 34.1267], [-118.33047, 34.12674], [-118.33029, 34.12674], [-118.33018, 34.12671], [-118.33008, 34.12671], [-118.32999, 34.12675], [-118.32949, 34.12735], [-118.32932, 34.12747], [-118.32911, 34.12754], [-118.32897, 34.12755], [-118.32817, 34.12752], [-118.32797, 34.12746], [-118.32782, 34.12736], [-118.32776, 34.12731], [-118.32766, 34.12715], [-118.32763, 34.12702], [-118.32763, 34.12692], [-118.32765, 34.12682], [-118.32774, 34.12664], [-118.32787, 34.12652], [-118.32882, 34.12593], [-118.32887, 34.12589], [-118.32891, 34.12582], [-118.3289, 34.12572], [-118.3288, 34.12551], [-118.32879, 34.12538], [-118.32884, 34.12524], [-118.32901, 34.12507], [-118.32904, 34.12502], [-118.32904, 34.12497], [-118.32903, 34.1249], [-118.32892, 34.12479], [-118.32887, 34.1247], [-118.32886, 34.12456], [-118.32888, 34.12448], [-118.32892, 34.12441], [-118.32904, 34.12431], [-118.32933, 34.12417], [-118.3294, 34.12411], [-118.32946, 34.12404], [-118.32958, 34.12382], [-118.32988, 34.12342], [-118.32747, 34.12342], [-118.32736, 34.1235], [-118.32718, 34.12356], [-118.32702, 34.12356], [-118.32687, 34.12351], [-118.32683, 34.11981], [-118.32677, 34.1198], [-118.32676, 34.11936], [-118.32675, 34.1161], [-118.33067, 34.1161], [-118.33084, 34.116], [-118.33091, 34.11605], [-118.33098, 34.11606], [-118.33105, 34.11603], [-118.33108, 34.11599], [-118.33114, 34.11597], [-118.33117, 34.11603], [-118.33112, 34.11605], [-118.33114, 34.1161], [-118.33128, 34.11611], [-118.33546, 34.11609], [-118.33548, 34.11975], [-118.33554, 34.11976], [-118.33558, 34.12222], [-118.33572, 34.12232], [-118.33576, 34.1224], [-118.33576, 34.12249], [-118.33573, 34.12254], [-118.33562, 34.12269], [-118.3356, 34.12275], [-118.33562, 34.12282], [-118.33596, 34.12331], [-118.336, 34.12354], [-118.33615, 34.12369], [-118.33619, 34.12375], [-118.33624, 34.12385], [-118.33625, 34.12396], [-118.33621, 34.12402], [-118.33616, 34.12406], [-118.33594, 34.12415], [-118.33579, 34.12417], [-118.33536, 34.12408], [-118.33529, 34.12408], [-118.33521, 34.12414], [-118.3352, 34.1242], [-118.33534, 34.1245], [-118.33542, 34.12457], [-118.3355, 34.12461], [-118.33567, 34.12462], [-118.33574, 34.12464], [-118.33586, 34.12472], [-118.33589, 34.12479], [-118.3359, 34.12485], [-118.33586, 34.12501], [-118.33588, 34.12526], [-118.3359, 34.12534], [-118.33596, 34.12543], [-118.33599, 34.12546], [-118.33608, 34.12549], [-118.33627, 34.12549], [-118.33637, 34.12555], [-118.3364, 34.1256], [-118.3364, 34.12571], [-118.33629, 34.12585], [-118.33626, 34.12594], [-118.33626, 34.126], [-118.33631, 34.12625], [-118.33631, 34.12634], [-118.33629, 34.1264], [-118.33621, 34.12649], [-118.33621, 34.12656], [-118.33636, 34.12672], [-118.33682, 34.12701], [-118.33685, 34.12706], [-118.33685, 34.12715]]]} | No Public Access 3 | 6908 | Lake Hollywood Reservoir | 29134 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | https://www.ladwp.com | Los Angeles 6 | 223.475 | Lake Hollywood Reservoir | 0 | Local Recreation Area 3 | 4 |
7462 | 7462 | 7461 | {"type": "Polygon", "coordinates": [[[-118.19211, 34.14613], [-118.19138, 34.14696], [-118.19207, 34.14739], [-118.19157, 34.14838], [-118.19026, 34.14823], [-118.19008, 34.14844], [-118.19024, 34.14854], [-118.1903, 34.14862], [-118.19036, 34.14873], [-118.19037, 34.14893], [-118.19032, 34.14906], [-118.18468, 34.14908], [-118.18495, 34.14737], [-118.18442, 34.1472], [-118.18446, 34.1471], [-118.18447, 34.14696], [-118.18444, 34.14685], [-118.18436, 34.1467], [-118.18433, 34.14657], [-118.18433, 34.14641], [-118.18436, 34.14628], [-118.18437, 34.14626], [-118.18505, 34.14668], [-118.1852, 34.14587], [-118.18606, 34.14645], [-118.1871, 34.14403], [-118.18722, 34.14399], [-118.18756, 34.14414], [-118.1876, 34.14458], [-118.18769, 34.14468], [-118.18774, 34.14477], [-118.18786, 34.1448], [-118.1884, 34.14461], [-118.18859, 34.14499], [-118.18898, 34.14517], [-118.18958, 34.1451], [-118.18969, 34.145], [-118.19211, 34.14613]]]} | No Public Access 3 | 6959 | Eagle Rock Reservoir | 29100 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | https://www.ladwp.com | Los Angeles 6 | 64.16 | Eagle Rock Reservoir | 0 | Local Recreation Area 3 | 4 |
7565 | 7565 | 7564 | {"type": "Polygon", "coordinates": [[[-118.7446, 34.03731], [-118.74394, 34.03908], [-118.74396, 34.04136], [-118.74377, 34.04151], [-118.74354, 34.04162], [-118.74338, 34.04174], [-118.74317, 34.04179], [-118.74335, 34.04274], [-118.73985, 34.04279], [-118.7399, 34.04259], [-118.73989, 34.04238], [-118.73986, 34.04228], [-118.73976, 34.04219], [-118.73961, 34.04215], [-118.7395, 34.04216], [-118.73896, 34.04246], [-118.73888, 34.04245], [-118.73886, 34.04243], [-118.73886, 34.04238], [-118.7389, 34.04235], [-118.73918, 34.04227], [-118.73925, 34.04222], [-118.73929, 34.04217], [-118.73933, 34.04208], [-118.73935, 34.04183], [-118.73939, 34.04178], [-118.73952, 34.04165], [-118.73961, 34.04153], [-118.73975, 34.04118], [-118.73979, 34.04113], [-118.73988, 34.04107], [-118.74012, 34.04098], [-118.74032, 34.04086], [-118.74046, 34.04076], [-118.74063, 34.04059], [-118.74071, 34.04049], [-118.74073, 34.04042], [-118.74073, 34.04033], [-118.74057, 34.03973], [-118.74056, 34.03957], [-118.74058, 34.03946], [-118.74073, 34.03909], [-118.74071, 34.03892], [-118.74067, 34.03885], [-118.7406, 34.03878], [-118.7393, 34.0379], [-118.73919, 34.03786], [-118.73859, 34.03787], [-118.73843, 34.03783], [-118.73833, 34.03777], [-118.73809, 34.0376], [-118.73769, 34.03724], [-118.73731, 34.03704], [-118.73724, 34.03699], [-118.73702, 34.03649], [-118.73694, 34.0364], [-118.73683, 34.03634], [-118.73676, 34.03633], [-118.73625, 34.03631], [-118.73614, 34.03602], [-118.73617, 34.03595], [-118.73623, 34.0359], [-118.73666, 34.03581], [-118.7373, 34.03556], [-118.73796, 34.0354], [-118.73879, 34.0353], [-118.73896, 34.03525], [-118.73923, 34.03507], [-118.73952, 34.03465], [-118.73957, 34.03463], [-118.73985, 34.03455], [-118.73999, 34.03449], [-118.74025, 34.03432], [-118.74163, 34.0341], [-118.74215, 34.03426], [-118.74268, 34.03421], [-118.74239, 34.03585], [-118.74363, 34.03578], [-118.7446, 34.03731]]]} | No Public Access 3 | 7242 | LADWP Santa Monica Mountains Open Space | 29132 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 97.29 | LADWP Santa Monica Mtns. OS | 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]);