units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
491 rows where MNG_AGENCY = 24 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, YR_EST, GAP_STS
DES_TP >30
- Local Park 314
- Local Recreation Area 116
- Local Other or Unknown 26
- Local Conservation Area 4
- National Forest 1
- Local Historic or Cultural Area 1
- None 1
- Local Resource Management Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 432
- No Public Access 36
- Restricted Access 20
- Unknown Access 3
LAYER 3 ✖
MNG_AG_TYP 1
- City Agency 491
MNG_AGENCY 1
- Los Angeles, City of · 491 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5803 | 5803 | 5802 | {"type": "Polygon", "coordinates": [[[-118.66808, 34.19517], [-118.66804, 34.19881], [-118.66712, 34.1988], [-118.66711, 34.1986], [-118.66187, 34.19858], [-118.66196, 34.19793], [-118.6607, 34.19748], [-118.66049, 34.1971], [-118.66026, 34.19647], [-118.65986, 34.19603], [-118.65932, 34.19588], [-118.65877, 34.19529], [-118.65896, 34.19514], [-118.66089, 34.19511], [-118.66808, 34.19517]]]} | Open Access 1 | 72 | El Escorpion Park | 29037 | 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 | 66.947 | El Escorpion Park | 0 | Local Park 2 | 4 | |
4916 | 4916 | 4915 | {"type": "Polygon", "coordinates": [[[-118.66738, 34.18769], [-118.66733, 34.19134], [-118.66148, 34.18951], [-118.6613, 34.18942], [-118.66109, 34.18936], [-118.65975, 34.1892], [-118.65953, 34.18919], [-118.65927, 34.1892], [-118.65868, 34.18927], [-118.65841, 34.18933], [-118.65818, 34.18941], [-118.65747, 34.18971], [-118.65772, 34.18768], [-118.66364, 34.18769], [-118.66365, 34.18691], [-118.66382, 34.1869], [-118.66509, 34.18549], [-118.66548, 34.18553], [-118.6657, 34.1858], [-118.66637, 34.18602], [-118.66659, 34.18616], [-118.66669, 34.18769], [-118.66738, 34.18769]]]} | Open Access 1 | 2928 | Knapp Ranch Park | 20692 | 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 | 69.281 | Knapp Ranch Park | 0 | Local Park 2 | 4 | |
9190 | 9190 | 9189 | {"type": "Polygon", "coordinates": [[[-118.65865, 34.19869], [-118.65863, 34.19874], [-118.6586, 34.19985], [-118.65857, 34.20027], [-118.65854, 34.20034], [-118.65848, 34.20039], [-118.6584, 34.20041], [-118.65724, 34.2004], [-118.6572, 34.20039], [-118.65718, 34.20033], [-118.65721, 34.20009], [-118.65719, 34.19995], [-118.65714, 34.1998], [-118.65703, 34.19962], [-118.65699, 34.19959], [-118.65703, 34.19953], [-118.65687, 34.1993], [-118.65676, 34.19918], [-118.65661, 34.19907], [-118.6565, 34.19905], [-118.65678, 34.19675], [-118.65847, 34.19676], [-118.65848, 34.19859], [-118.65865, 34.19869]]]} | Open Access 1 | 15245 | West Hills Recreation Center | 27360 | 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 | 16.146 | West Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
8958 | 8958 | 8957 | {"type": "Polygon", "coordinates": [[[-118.65406, 34.20676], [-118.65402, 34.20707], [-118.65383, 34.20781], [-118.65381, 34.20784], [-118.65377, 34.20785], [-118.65337, 34.20778], [-118.65319, 34.20777], [-118.65295, 34.2078], [-118.65273, 34.20785], [-118.65253, 34.20746], [-118.65282, 34.20727], [-118.65308, 34.20706], [-118.65331, 34.20683], [-118.65352, 34.20659], [-118.65359, 34.20658], [-118.65381, 34.20667], [-118.65403, 34.20673], [-118.65406, 34.20676]]]} | Open Access 1 | 14757 | Castle Peak Park | 16953 | 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.037 | Castle Peak Park | 0 | Local Park 2 | 4 | |
4378 | 4378 | 4377 | {"type": "Polygon", "coordinates": [[[-118.65346, 34.21206], [-118.65173, 34.219], [-118.64897, 34.21904], [-118.64896, 34.21858], [-118.64916, 34.21842], [-118.64976, 34.2184], [-118.64975, 34.21784], [-118.64905, 34.21741], [-118.64856, 34.21792], [-118.64784, 34.21837], [-118.64645, 34.21837], [-118.64623, 34.21795], [-118.6464, 34.21788], [-118.64656, 34.21756], [-118.64663, 34.21755], [-118.64706, 34.21707], [-118.64738, 34.21705], [-118.64738, 34.21682], [-118.64756, 34.21681], [-118.64773, 34.2169], [-118.64804, 34.21662], [-118.64808, 34.2164], [-118.64825, 34.21624], [-118.64878, 34.21602], [-118.64887, 34.21596], [-118.6492, 34.21589], [-118.64935, 34.2158], [-118.64992, 34.21557], [-118.65014, 34.21553], [-118.65056, 34.21603], [-118.65076, 34.21602], [-118.65077, 34.21559], [-118.65114, 34.21515], [-118.65132, 34.21516], [-118.65164, 34.21498], [-118.65158, 34.21475], [-118.65164, 34.21473], [-118.65172, 34.21499], [-118.65221, 34.21499], [-118.65213, 34.2146], [-118.6521, 34.21422], [-118.65196, 34.21423], [-118.65201, 34.21395], [-118.65194, 34.21388], [-118.65168, 34.21378], [-118.65179, 34.21318], [-118.65268, 34.21278], [-118.65296, 34.21211], [-118.6527, 34.21155], [-118.65243, 34.2114], [-118.65196, 34.21078], [-118.65202, 34.21078], [-118.65346, 34.21206]]]} | Open Access 1 | 10379 | Roscoe-Valley Circle Park | 24603 | 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 | 44.379 | Roscoe-Valley Circle Park | 0 | Local Park 2 | 4 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-118.64797, 34.19522], [-118.64792, 34.19556], [-118.64772, 34.19554], [-118.64752, 34.19555], [-118.64721, 34.19561], [-118.64698, 34.19569], [-118.6464, 34.19595], [-118.64635, 34.19593], [-118.64625, 34.19573], [-118.64624, 34.19563], [-118.64627, 34.19542], [-118.64631, 34.19537], [-118.6464, 34.1953], [-118.64642, 34.19522], [-118.6464, 34.19518], [-118.64636, 34.19513], [-118.64629, 34.19511], [-118.64623, 34.19511], [-118.64624, 34.19507], [-118.64797, 34.19522]]]} | Open Access 1 | 4956 | Mae Boyar Recreation Center | 21665 | 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.247 | Mae Boyar Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
696 | 696 | 695 | {"type": "Polygon", "coordinates": [[[-118.6462, 34.21201], [-118.64612, 34.21245], [-118.64599, 34.21284], [-118.64584, 34.21312], [-118.6452, 34.21418], [-118.64505, 34.21455], [-118.64495, 34.21491], [-118.64489, 34.21494], [-118.6445, 34.21492], [-118.64449, 34.21195], [-118.64612, 34.21195], [-118.64617, 34.21197], [-118.6462, 34.21201]]]} | Open Access 1 | 3832 | Lazy J Ranch Park | 21122 | 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 | 8.44 | Lazy J Ranch Park | 0 | Local Park 2 | 4 | |
7609 | 7609 | 7608 | {"type": "Polygon", "coordinates": [[[-118.64349, 34.21894], [-118.64349, 34.21898], [-118.64346, 34.219], [-118.64336, 34.21902], [-118.63746, 34.21911], [-118.63782, 34.21883], [-118.63812, 34.21849], [-118.63838, 34.21802], [-118.63851, 34.21751], [-118.63864, 34.21738], [-118.63855, 34.21658], [-118.6387, 34.21672], [-118.63891, 34.21685], [-118.63909, 34.21692], [-118.63935, 34.21697], [-118.63961, 34.21698], [-118.63974, 34.21693], [-118.63988, 34.21692], [-118.63999, 34.21694], [-118.64016, 34.217], [-118.64026, 34.21702], [-118.64078, 34.21695], [-118.64225, 34.21702], [-118.64228, 34.21704], [-118.64296, 34.21848], [-118.64349, 34.21891], [-118.64349, 34.21894]]]} | Open Access 1 | 7333 | Orcutt Ranch Horticultural Center Park | 23198 | 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 | 24.106 | Orcutt Ranch Horticultural Ctr. Park | 0 | Local Park 2 | 4 | |
8930 | 8930 | 8929 | {"type": "Polygon", "coordinates": [[[-118.63871, 34.21307], [-118.63869, 34.21311], [-118.63866, 34.21313], [-118.63789, 34.21313], [-118.63786, 34.2131], [-118.63785, 34.21263], [-118.63787, 34.21258], [-118.63794, 34.21251], [-118.63796, 34.21245], [-118.63794, 34.21239], [-118.63788, 34.21235], [-118.63788, 34.21192], [-118.63813, 34.21192], [-118.63863, 34.21197], [-118.63868, 34.21199], [-118.63871, 34.21307]]]} | Open Access 1 | 14674 | Taxco Trails Park | 26200 | 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.46 | Taxco Trails Park | 0 | Local Park 2 | 4 | |
10225 | 10225 | 10224 | {"type": "Polygon", "coordinates": [[[-118.63562, 34.20587], [-118.63458, 34.20588], [-118.63453, 34.20586], [-118.6345, 34.20581], [-118.63451, 34.2052], [-118.63453, 34.20518], [-118.63458, 34.20516], [-118.63488, 34.20516], [-118.63503, 34.20521], [-118.6351, 34.20519], [-118.63514, 34.20515], [-118.63562, 34.20515], [-118.63562, 34.20587]]]} | Open Access 1 | 17884 | Cohasset Melba Park | 17478 | 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.993 | Cohasset Melba Park | 0 | Local Park 2 | 4 | |
9326 | 9326 | 9325 | {"type": "Polygon", "coordinates": [[[-118.63032, 34.2401], [-118.62961, 34.24045], [-118.6291, 34.24082], [-118.62822, 34.24015], [-118.62858, 34.24003], [-118.62851, 34.23987], [-118.62939, 34.2397], [-118.62948, 34.2399], [-118.62968, 34.23989], [-118.62987, 34.23992], [-118.63032, 34.2401]]]} | Open Access 1 | 15549 | Chatsworth Oaks Park | 17158 | 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.912 | Chatsworth Oaks Park | 0 | Local Park 2 | 4 | |
2048 | 2048 | 2047 | {"type": "Polygon", "coordinates": [[[-118.62354, 34.26184], [-118.6234, 34.26183], [-118.62333, 34.26212], [-118.62316, 34.26219], [-118.62319, 34.26224], [-118.62331, 34.26223], [-118.62354, 34.26226], [-118.62353, 34.26325], [-118.62191, 34.26307], [-118.62194, 34.26279], [-118.62132, 34.26277], [-118.62077, 34.2628], [-118.62031, 34.26287], [-118.61946, 34.26308], [-118.61951, 34.26282], [-118.6192, 34.26278], [-118.61918, 34.2628], [-118.61915, 34.26305], [-118.6192, 34.26311], [-118.61928, 34.26312], [-118.61918, 34.26315], [-118.61917, 34.26344], [-118.61693, 34.26401], [-118.61694, 34.26081], [-118.61515, 34.2603], [-118.61481, 34.26029], [-118.61484, 34.25721], [-118.61543, 34.25721], [-118.61706, 34.25972], [-118.61812, 34.25972], [-118.62027, 34.25826], [-118.62354, 34.2616], [-118.62354, 34.26184]]]} | Open Access 1 | 15596 | Chatsworth Park South | 17160 | 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 | 73.586 | Chatsworth Park South | 0 | Local Park 2 | 4 | |
1624 | 1624 | 1623 | {"type": "Polygon", "coordinates": [[[-118.62116, 34.19554], [-118.62038, 34.19554], [-118.62038, 34.19646], [-118.61902, 34.19646], [-118.61901, 34.19385], [-118.62116, 34.19384], [-118.62116, 34.19554]]]} | Open Access 1 | 12394 | Shadow Ranch Park | 25341 | 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 | 12.338 | Shadow Ranch Park | 0 | Local Park 2 | 4 | |
9312 | 9312 | 9311 | {"type": "Polygon", "coordinates": [[[-118.61866, 34.22438], [-118.61702, 34.22438], [-118.61702, 34.22381], [-118.61712, 34.2234], [-118.61717, 34.22331], [-118.61734, 34.22315], [-118.61739, 34.22305], [-118.61738, 34.22293], [-118.61725, 34.22276], [-118.61762, 34.22275], [-118.61781, 34.22277], [-118.61799, 34.2228], [-118.61865, 34.22298], [-118.61866, 34.22438]]]} | Open Access 1 | 15526 | Chase Park | 17156 | 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 | 5.969 | Chase Park | 0 | Local Park 2 | 4 | |
16808 | 16808 | 16807 | {"type": "Polygon", "coordinates": [[[-118.61446, 34.17738], [-118.61023, 34.17739], [-118.61032, 34.17679], [-118.61033, 34.17586], [-118.61035, 34.17575], [-118.61046, 34.17557], [-118.61346, 34.17557], [-118.61355, 34.17563], [-118.61364, 34.17565], [-118.61441, 34.17565], [-118.61445, 34.1757], [-118.61446, 34.17738]]]} | Open Access 1 | 15474 | Woodland Hills Recreation Center | 30898 | 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://www.laparks.org/dos/reccenter/facility/woodlandhillsrc.htm | Los Angeles 6 | 18.776 | Woodland Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
8882 | 8882 | 8881 | {"type": "Polygon", "coordinates": [[[-118.60611, 34.26878], [-118.60611, 34.26934], [-118.60608, 34.26959], [-118.60594, 34.27024], [-118.60589, 34.2704], [-118.60577, 34.27068], [-118.60558, 34.27109], [-118.60541, 34.27132], [-118.60497, 34.27197], [-118.60492, 34.27207], [-118.60295, 34.27218], [-118.60241, 34.27215], [-118.60187, 34.27206], [-118.60196, 34.27125], [-118.60202, 34.27092], [-118.60211, 34.2706], [-118.60224, 34.27028], [-118.60244, 34.26991], [-118.60264, 34.26961], [-118.60297, 34.2692], [-118.60317, 34.26902], [-118.60357, 34.26878], [-118.60611, 34.26878]]]} | Open Access 1 | 14510 | Stoney Point Park | 25899 | 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 | 28.627 | Stoney Point Park | 0 | Local Park 2 | 4 | |
15672 | 15672 | 15671 | {"type": "Polygon", "coordinates": [[[-118.60581, 34.21744], [-118.60579, 34.21747], [-118.60575, 34.21749], [-118.60178, 34.21749], [-118.60174, 34.21744], [-118.60174, 34.21566], [-118.60179, 34.21562], [-118.60577, 34.21562], [-118.60581, 34.21566], [-118.60581, 34.21744]]]} | Open Access 1 | 3551 | Lanark Recreation Center | 28623 | 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://www.laparks.org/dos/reccenter/facility/lanarkRC.htm | Los Angeles 6 | 19.128 | Lanark Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
1355 | 1355 | 1354 | {"type": "Polygon", "coordinates": [[[-118.59935, 34.22803], [-118.59933, 34.22806], [-118.59929, 34.22807], [-118.59851, 34.22806], [-118.59851, 34.2274], [-118.59935, 34.2274], [-118.59935, 34.22803]]]} | Open Access 1 | 8041 | Parthenia Park | 23485 | 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.413 | Parthenia Park | 0 | Local Park 2 | 4 | |
15063 | 15063 | 15062 | {"type": "Polygon", "coordinates": [[[-118.59735, 34.1673], [-118.59689, 34.16721], [-118.59699, 34.16688], [-118.59728, 34.16693], [-118.59732, 34.16696], [-118.59735, 34.1671], [-118.59735, 34.1673]]]} | Open Access 1 | 45820 | Old Fire Station 84 Pocket Park | 28839 | 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://www.laparks.org/environmental/oldFire.htm | Los Angeles 6 | 0.359 | Old Fire Station 84 PP | 0 | Local Park 2 | 4 |
1060 | 1060 | 1059 | {"type": "Polygon", "coordinates": [[[-118.58835, 34.1574], [-118.58606, 34.1574], [-118.58649, 34.15597], [-118.58652, 34.15583], [-118.58671, 34.15424], [-118.58674, 34.15421], [-118.58675, 34.15418], [-118.58671, 34.15411], [-118.58664, 34.15409], [-118.58656, 34.15414], [-118.58655, 34.15418], [-118.58658, 34.15424], [-118.58638, 34.15586], [-118.58592, 34.1574], [-118.58588, 34.15747], [-118.58579, 34.15753], [-118.58572, 34.15755], [-118.58551, 34.15757], [-118.58506, 34.1552], [-118.58531, 34.15463], [-118.58518, 34.15359], [-118.58603, 34.1525], [-118.58688, 34.15235], [-118.58834, 34.15325], [-118.58835, 34.1574]]]} | Open Access 1 | 6414 | Serrania Avenue Park | 25316 | 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 | 35.478 | Serrania Avenue 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]);