units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where ACCESS_TYP = 3 and MNG_AGENCY = 24 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME
DES_TP 10
- Local Park 16
- Local Other or Unknown 12
- Local Recreation Area 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 36
MNG_AGENCY 1
- Los Angeles, City of · 36 ✖
ACCESS_TYP 1
- No Public Access · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11528 | 11528 | 11527 | {"type": "MultiPolygon", "coordinates": [[[[-118.20612, 34.09335], [-118.20612, 34.09367], [-118.20609, 34.09391], [-118.20603, 34.09414], [-118.20585, 34.09457], [-118.20574, 34.09476], [-118.20539, 34.09529], [-118.20514, 34.09529], [-118.20525, 34.09514], [-118.20561, 34.09453], [-118.20574, 34.09423], [-118.20589, 34.09374], [-118.20591, 34.09362], [-118.20585, 34.09312], [-118.20611, 34.09327], [-118.20612, 34.09335]]], [[[-118.21437, 34.0859], [-118.21414, 34.08614], [-118.21334, 34.08653], [-118.21306, 34.08656], [-118.21308, 34.08615], [-118.21331, 34.08615], [-118.21354, 34.08612], [-118.21437, 34.0859]]], [[[-118.21725, 34.08529], [-118.21666, 34.08551], [-118.21583, 34.08575], [-118.21493, 34.08606], [-118.21453, 34.08616], [-118.21514, 34.08556], [-118.21705, 34.08507], [-118.21725, 34.08529]]], [[[-118.21928, 34.08401], [-118.21881, 34.08457], [-118.21873, 34.08448], [-118.21867, 34.08452], [-118.21875, 34.08463], [-118.21872, 34.08466], [-118.21851, 34.08482], [-118.21827, 34.08496], [-118.21744, 34.08522], [-118.21725, 34.08502], [-118.21735, 34.08499], [-118.21739, 34.085], [-118.21866, 34.08447], [-118.21794, 34.08379], [-118.21823, 34.08357], [-118.21895, 34.08425], [-118.21928, 34.08401]]], [[[-118.21932, 34.08461], [-118.21932, 34.08461], [-118.21922, 34.08464], [-118.21929, 34.08457], [-118.21932, 34.08461]]], [[[-118.22153, 34.0833], [-118.22011, 34.0842], [-118.22009, 34.0842], [-118.21967, 34.08445], [-118.21941, 34.08457], [-118.21934, 34.0845], [-118.21976, 34.08399], [-118.22099, 34.0832], [-118.22118, 34.08291], [-118.22153, 34.0833]]], [[[-118.22322, 34.08205], [-118.22301, 34.08223], [-118.22284, 34.08234], [-118.2219, 34.08307], [-118.2217, 34.0832], [-118.22143, 34.08291], [-118.22155, 34.0828], [-118.22226, 34.08224], [-118.22263, 34.08208], [-118.223, 34.08203], [-118.22322, 34.08205]]], [[[-118.22504, 34.08065], [-118.22417, 34.08133], [-118.2239, 34.08122], [-118.22364, 34.08107], [-118.22349, 34.0808], [-118.22324, 34.08066], [-118.22291, 34.08042], [-118.22401, 34.07994], [-118.22406, 34.08001], [-118.22451, 34.07981], [-118.22504, 34.08065]]], [[[-118.22587, 34.08011], [-118.2253, 34.08058], [-118.22499, 34.08008], [-118.22561, 34.07945], [-118.22587, 34.08011]]], [[[-118.226, 34.08102], [-118.22572, 34.08124], [-118.22553, 34.08095], [-118.22581, 34.08073], [-118.226, 34.08102]]], [[[-118.22621, 34.08087], [-118.22604, 34.081], [-118.22584, 34.08069], [-118.22603, 34.08052], [-118.22621, 34.08087]]], [[[-118.22632, 34.08108], [-118.22625, 34.0811], [-118.22606, 34.08118], [-118.22628, 34.081], [-118.22632, 34.08108]]]]} | No Public Access 3 | 29604 | Arroyo Seco | 15626 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | Los Angeles 6 | 16.466 | Arroyo Seco | None 1029 | ||
4092 | 4092 | 4091 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | 47493 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.053 | Chautauqua Blvd Access to Will Rogers SHPr | None 355 | |||
7024 | 7024 | 7023 | {"type": "MultiPolygon", "coordinates": [[[[-118.29936, 33.76462], [-118.29901, 33.76463], [-118.2977, 33.76459], [-118.29684, 33.76458], [-118.29636, 33.76464], [-118.29634, 33.7645], [-118.29695, 33.76443], [-118.29897, 33.76449], [-118.29936, 33.76447], [-118.29936, 33.76462]]], [[[-118.30254, 33.76446], [-118.30187, 33.76451], [-118.29974, 33.76461], [-118.29957, 33.76461], [-118.29955, 33.76452], [-118.29957, 33.76448], [-118.30224, 33.76435], [-118.30244, 33.7643], [-118.3025, 33.76432], [-118.30254, 33.76446]]], [[[-118.30313, 33.76447], [-118.30304, 33.76446], [-118.30276, 33.76452], [-118.30271, 33.76437], [-118.3028, 33.76437], [-118.30307, 33.76431], [-118.30313, 33.76447]]]]} | No Public Access 3 | 5974 | City of Los Angeles Flood Control | 17320 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.225 | City of Los Angeles Flood Control | 0 | Local Other or Unknown 14 | 4 | |
12271 | 12271 | 12270 | {"type": "Polygon", "coordinates": [[[-118.2914, 33.95801], [-118.2914, 33.95822], [-118.291, 33.95822], [-118.29101, 33.95801], [-118.2914, 33.95801]]]} | No Public Access 3 | 46878 | Community Build Youth Center Expansion | 30356 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.207 | Community Build Youth Ctr. Expansion | None 1070 | |||
9403 | 9403 | 9402 | {"type": "Polygon", "coordinates": [[[-118.24174, 34.10059], [-118.24079, 34.10067], [-118.24073, 34.10141], [-118.24026, 34.10153], [-118.24008, 34.10105], [-118.23989, 34.10064], [-118.23963, 34.10019], [-118.2394, 34.09986], [-118.23909, 34.09947], [-118.23674, 34.09668], [-118.23649, 34.09643], [-118.23621, 34.09616], [-118.23573, 34.09577], [-118.2354, 34.09553], [-118.23528, 34.09552], [-118.2349, 34.09526], [-118.23451, 34.09501], [-118.23528, 34.09444], [-118.23594, 34.09452], [-118.23634, 34.09459], [-118.23672, 34.09469], [-118.2371, 34.09481], [-118.23747, 34.09495], [-118.238, 34.09522], [-118.23834, 34.09543], [-118.23864, 34.09566], [-118.23904, 34.09601], [-118.23927, 34.09626], [-118.23949, 34.09652], [-118.24137, 34.09927], [-118.24154, 34.0996], [-118.24166, 34.09996], [-118.24173, 34.10033], [-118.24174, 34.10059]]]} | No Public Access 3 | 47812 | G2 Parcel | 31694 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 41.839 | G2 Parcel | 0 | None 775 | ||
7194 | 7194 | 7193 | {"type": "Polygon", "coordinates": [[[-118.34172, 34.25537], [-118.34043, 34.2563], [-118.34044, 34.25641], [-118.34035, 34.25673], [-118.34035, 34.25683], [-118.34042, 34.25704], [-118.34042, 34.25714], [-118.34039, 34.2572], [-118.34031, 34.25726], [-118.34008, 34.25733], [-118.34003, 34.25738], [-118.3399, 34.25768], [-118.33994, 34.25797], [-118.33988, 34.25807], [-118.33974, 34.25819], [-118.3397, 34.25824], [-118.33977, 34.25865], [-118.33975, 34.25872], [-118.33969, 34.2588], [-118.33959, 34.25885], [-118.33944, 34.25885], [-118.33898, 34.25859], [-118.3389, 34.25857], [-118.33883, 34.25857], [-118.3382, 34.2587], [-118.3377, 34.25897], [-118.3376, 34.25898], [-118.33701, 34.2589], [-118.3369, 34.25892], [-118.3367, 34.25901], [-118.33652, 34.25903], [-118.33522, 34.25891], [-118.33481, 34.25879], [-118.3345, 34.25867], [-118.33443, 34.25863], [-118.33438, 34.25854], [-118.33438, 34.25848], [-118.33441, 34.25841], [-118.33441, 34.25829], [-118.33439, 34.25817], [-118.33437, 34.25814], [-118.3343, 34.2581], [-118.33423, 34.25811], [-118.33402, 34.25796], [-118.33282, 34.25776], [-118.33176, 34.25745], [-118.33175, 34.25642], [-118.33162, 34.25606], [-118.33187, 34.2553], [-118.33131, 34.25461], [-118.33174, 34.2526], [-118.33464, 34.25337], [-118.34172, 34.25537]]]} | No Public Access 3 | 6842 | Green Verdugo Reservoir | 19469 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 105.007 | Green Verdugo Reservoir | 0 | Local Recreation Area 3 | 4 | |
1270 | 1270 | 1269 | {"type": "Polygon", "coordinates": [[[-118.56523, 34.13034], [-118.56473, 34.13106], [-118.56429, 34.13106], [-118.56418, 34.13093], [-118.56397, 34.13076], [-118.56397, 34.13019], [-118.56387, 34.13018], [-118.56387, 34.12948], [-118.5652, 34.12947], [-118.56479, 34.13017], [-118.56523, 34.13034]]]} | No Public Access 3 | 7159 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.129 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1271 | 1271 | 1270 | {"type": "Polygon", "coordinates": [[[-118.44484, 34.1151], [-118.44483, 34.11604], [-118.44451, 34.11604], [-118.44418, 34.11581], [-118.44418, 34.11543], [-118.4445, 34.11515], [-118.44451, 34.1151], [-118.44484, 34.1151]]]} | No Public Access 3 | 7160 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.317 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1340 | 1340 | 1339 | {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} | No Public Access 3 | 12809 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.163 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
1489 | 1489 | 1488 | {"type": "Polygon", "coordinates": [[[-118.46789, 34.09611], [-118.46633, 34.09612], [-118.46623, 34.09617], [-118.46611, 34.09595], [-118.46593, 34.09571], [-118.46592, 34.09565], [-118.46593, 34.09559], [-118.46595, 34.09555], [-118.46601, 34.09548], [-118.46614, 34.09544], [-118.4678, 34.09543], [-118.46792, 34.09583], [-118.46789, 34.09611]]]} | No Public Access 3 | 12701 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.182 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-118.37097, 34.13187], [-118.37053, 34.13214], [-118.36993, 34.13183], [-118.37013, 34.13145], [-118.37097, 34.13187]]]} | No Public Access 3 | 12817 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.89 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5168 | 5168 | 5167 | {"type": "Polygon", "coordinates": [[[-118.37164, 34.13145], [-118.37153, 34.13213], [-118.37007, 34.13142], [-118.37071, 34.1309], [-118.37084, 34.13153], [-118.37164, 34.13145]]]} | No Public Access 3 | 12818 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.768 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5411 | 5411 | 5410 | {"type": "Polygon", "coordinates": [[[-118.58708, 34.13904], [-118.58568, 34.13904], [-118.58568, 34.13813], [-118.58707, 34.13866], [-118.58708, 34.13904]]]} | No Public Access 3 | 7166 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.267 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5495 | 5495 | 5494 | {"type": "Polygon", "coordinates": [[[-118.38093, 34.1267], [-118.38083, 34.12681], [-118.38083, 34.12701], [-118.38061, 34.12707], [-118.38043, 34.12717], [-118.38031, 34.12721], [-118.3802, 34.12721], [-118.38011, 34.12718], [-118.38003, 34.12714], [-118.37992, 34.12701], [-118.3798, 34.12694], [-118.37975, 34.12694], [-118.37974, 34.12695], [-118.37963, 34.12692], [-118.37943, 34.1269], [-118.37939, 34.12686], [-118.37941, 34.12663], [-118.38093, 34.1267]]]} | No Public Access 3 | 12819 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 1.441 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5496 | 5496 | 5495 | {"type": "Polygon", "coordinates": [[[-118.39301, 34.11863], [-118.39283, 34.11899], [-118.39267, 34.11881], [-118.39276, 34.11874], [-118.39271, 34.11868], [-118.3926, 34.11875], [-118.39249, 34.11863], [-118.39234, 34.11881], [-118.39226, 34.11887], [-118.39219, 34.11889], [-118.39201, 34.11889], [-118.39183, 34.11881], [-118.39175, 34.11874], [-118.39223, 34.11873], [-118.39222, 34.11808], [-118.39228, 34.11821], [-118.39284, 34.11848], [-118.39299, 34.11857], [-118.39297, 34.1186], [-118.39301, 34.11863]]]} | No Public Access 3 | 12820 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.964 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
5497 | 5497 | 5496 | {"type": "Polygon", "coordinates": [[[-118.39276, 34.11874], [-118.39267, 34.11881], [-118.3926, 34.11875], [-118.39271, 34.11867], [-118.39276, 34.11874]]]} | No Public Access 3 | 12821 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.028 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7551 | 7551 | 7550 | {"type": "Polygon", "coordinates": [[[-118.44367, 34.1295], [-118.4417, 34.12943], [-118.4417, 34.12935], [-118.44173, 34.12926], [-118.44203, 34.12886], [-118.44206, 34.12877], [-118.44212, 34.12843], [-118.4427, 34.12846], [-118.44271, 34.12848], [-118.44294, 34.12848], [-118.44294, 34.12861], [-118.4431, 34.12855], [-118.44318, 34.12855], [-118.44328, 34.12859], [-118.44334, 34.12867], [-118.44367, 34.1295]]]} | No Public Access 3 | 7161 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 3.797 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7936 | 7936 | 7935 | {"type": "Polygon", "coordinates": [[[-118.36765, 34.12534], [-118.36714, 34.12607], [-118.36565, 34.126], [-118.3668, 34.12438], [-118.3669, 34.12456], [-118.36735, 34.12491], [-118.36715, 34.12508], [-118.36715, 34.1251], [-118.36765, 34.12534]]]} | No Public Access 3 | 12815 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 4.385 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
7948 | 7948 | 7947 | {"type": "Polygon", "coordinates": [[[-118.37369, 34.12306], [-118.3737, 34.12323], [-118.37362, 34.12338], [-118.37328, 34.12338], [-118.37328, 34.12313], [-118.3733, 34.12309], [-118.37349, 34.12293], [-118.37369, 34.12306]]]} | No Public Access 3 | 12814 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.377 | Los Angeles City Water Resource Parkland | 0 | Local Park 2 | 4 | |
8264 | 8264 | 8263 | {"type": "Polygon", "coordinates": [[[-118.38077, 34.1079], [-118.38075, 34.10838], [-118.38056, 34.10851], [-118.3804, 34.10844], [-118.38058, 34.10801], [-118.38077, 34.1079]]]} | No Public Access 3 | 12810 | Los Angeles City Water Resource Parkland | 21477 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.337 | Los Angeles City Water Resource Parkland | 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]);