units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where DES_TP = 2 and MNG_AGENCY = 16 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, PARK_URL, YR_EST
AGNCY_TYP 5 ✖
ACCESS_TYP 4
MNG_AG_TYP 1
MNG_AGENCY 1
- Los Angeles, County of · 95 ✖
DES_TP 1
- Local Park · 95 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6180 | 6180 | 6179 | {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03776, 33.94222], [-118.03777, 33.94223]]]} | Open Access 1 | 1282 | Adventure Park | 15277 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 14.559 | Adventure Park | 0 | Local Park 2 | 4 | |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 0 | Local Park 2 | 4 | |
2194 | 2194 | 2193 | {"type": "Polygon", "coordinates": [[[-117.96354, 34.0398], [-117.96255, 34.04072], [-117.96092, 34.03957], [-117.96193, 34.03862], [-117.96354, 34.0398]]]} | Open Access 1 | 16435 | Allen J Martin Park | 15378 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.797 | Allen J Martin Park | 0 | Local Park 2 | 4 | |
14402 | 14402 | 14401 | {"type": "Polygon", "coordinates": [[[-118.34366, 33.88725], [-118.34029, 33.88725], [-118.34013, 33.88558], [-118.34366, 33.88545], [-118.34366, 33.88725]]]} | Open Access 1 | 44524 | Alondra Community Regional Park | 15402 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 15.215 | Alondra Community RP | 0 | Local Park 2 | 4 | |
6847 | 6847 | 6846 | {"type": "Polygon", "coordinates": [[[-118.70661, 34.02967], [-118.70628, 34.02966], [-118.70561, 34.02975], [-118.70525, 34.02983], [-118.70503, 34.03003], [-118.70481, 34.03012], [-118.70419, 34.03031], [-118.70382, 34.03037], [-118.70373, 34.03036], [-118.70346, 34.03042], [-118.70316, 34.03054], [-118.70299, 34.0305], [-118.70275, 34.03058], [-118.70225, 34.03072], [-118.70199, 34.03075], [-118.70161, 34.03085], [-118.70144, 34.03079], [-118.70127, 34.03077], [-118.70101, 34.0309], [-118.7003, 34.03111], [-118.70019, 34.03118], [-118.69989, 34.03128], [-118.69943, 34.03147], [-118.69944, 34.03155], [-118.69921, 34.0316], [-118.69917, 34.03149], [-118.69885, 34.03153], [-118.69884, 34.03154], [-118.69891, 34.03167], [-118.69846, 34.03179], [-118.69838, 34.03173], [-118.69825, 34.03179], [-118.69825, 34.03188], [-118.69792, 34.03201], [-118.69769, 34.03212], [-118.69763, 34.03207], [-118.69732, 34.03223], [-118.69721, 34.03217], [-118.69697, 34.03227], [-118.69681, 34.03228], [-118.69627, 34.0325], [-118.69582, 34.03263], [-118.69571, 34.03238], [-118.69614, 34.03228], [-118.69686, 34.03216], [-118.69835, 34.0316], [-118.69939, 34.03133], [-118.69992, 34.0311], [-118.70058, 34.03087], [-118.70138, 34.03063], [-118.70161, 34.0306], [-118.70178, 34.03062], [-118.70228, 34.03055], [-118.70288, 34.03032], [-118.70426, 34.03001], [-118.70525, 34.02965], [-118.70588, 34.0295], [-118.70651, 34.02923], [-118.70661, 34.02967]]]} | Open Access 1 | 5475 | Amarillo Beach | 15438 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.778 | Amarillo Beach | 0 | Local Park 2 | 4 | |
9948 | 9948 | 9947 | {"type": "Polygon", "coordinates": [[[-118.05172, 33.93163], [-118.05126, 33.93164], [-118.05124, 33.93161], [-118.0496, 33.93161], [-118.04959, 33.92815], [-118.05097, 33.92917], [-118.05171, 33.92968], [-118.05172, 33.93163]]]} | Open Access 1 | 17115 | Amelia Mayberry Park | 15446 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 14.437 | Amelia Mayberry Park | 0 | Local Park 2 | 4 | |
14411 | 14411 | 14410 | {"type": "MultiPolygon", "coordinates": [[[[-118.0383, 34.1366], [-118.03704, 34.13795], [-118.03693, 34.1379], [-118.03673, 34.1381], [-118.03674, 34.13812], [-118.03683, 34.13817], [-118.03527, 34.13986], [-118.0351, 34.13987], [-118.03504, 34.13992], [-118.0316, 34.13997], [-118.03151, 34.13565], [-118.03198, 34.13576], [-118.03227, 34.13601], [-118.03259, 34.13624], [-118.03292, 34.13634], [-118.03343, 34.13635], [-118.03405, 34.13627], [-118.0349, 34.13614], [-118.03571, 34.13614], [-118.03624, 34.13619], [-118.03681, 34.13613], [-118.03775, 34.13635], [-118.0383, 34.1366]]], [[[-118.04112, 34.13356], [-118.04112, 34.13356], [-118.04099, 34.1337], [-118.04109, 34.13358], [-118.04112, 34.13356]]]]} | Open Access 1 | 44522 | Arcadia Community Regional Park | 15565 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 50.673 | Arcadia Community RP | 0 | Local Park 2 | 4 | |
996 | 996 | 995 | {"type": "Polygon", "coordinates": [[[-118.28068, 33.91874], [-118.2806, 33.91875], [-118.2806, 33.91994], [-118.27843, 33.91994], [-118.27849, 33.9166], [-118.27855, 33.91656], [-118.2806, 33.91655], [-118.28067, 33.91661], [-118.28068, 33.91874]]]} | Open Access 1 | 6206 | Athens Park | 15666 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 18.724 | Athens Park | 0 | Local Park 2 | 4 | |
24 | 24 | 23 | {"type": "Polygon", "coordinates": [[[-118.15573, 34.02499], [-118.1555, 34.02576], [-118.15546, 34.0258], [-118.15538, 34.02582], [-118.15475, 34.02568], [-118.15469, 34.02564], [-118.15468, 34.02558], [-118.1549, 34.02485], [-118.15494, 34.02481], [-118.15501, 34.02479], [-118.15565, 34.02492], [-118.1557, 34.02495], [-118.15573, 34.02499]]]} | Open Access 1 | 62 | Atlantic Avenue Park | 15674 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.951 | Atlantic Avenue Park | 0 | Local Park 2 | 4 | |
13498 | 13498 | 13497 | {"type": "Polygon", "coordinates": [[[-117.99482, 34.0355], [-117.99427, 34.03605], [-117.99393, 34.03583], [-117.99375, 34.036], [-117.99242, 34.03508], [-117.99314, 34.03435], [-117.99482, 34.0355]]]} | Open Access 1 | 45698 | Avenue Park | 28597 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Avenue_Park | Los Angeles 6 | 4.957 | Avenue Park | 0 | Local Park 2 | 4 |
518 | 518 | 517 | {"type": "Polygon", "coordinates": [[[-117.98854, 34.05187], [-117.98765, 34.05279], [-117.98644, 34.05198], [-117.98629, 34.05211], [-117.98513, 34.05133], [-117.98614, 34.05027], [-117.98854, 34.05187]]]} | Open Access 1 | 2142 | Bassett Park | 15856 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 9.789 | Bassett Park | 0 | Local Park 2 | 4 | |
6842 | 6842 | 6841 | {"type": "Polygon", "coordinates": [[[-118.62491, 34.03758], [-118.6246, 34.03769], [-118.62402, 34.03776], [-118.62328, 34.0378], [-118.62269, 34.0378], [-118.62242, 34.03779], [-118.62218, 34.0377], [-118.62193, 34.03765], [-118.62107, 34.03764], [-118.62025, 34.03753], [-118.61966, 34.0375], [-118.61937, 34.03744], [-118.61881, 34.03741], [-118.61666, 34.03722], [-118.61634, 34.03716], [-118.61595, 34.03704], [-118.61566, 34.03701], [-118.61535, 34.03694], [-118.61516, 34.03692], [-118.6148, 34.03692], [-118.61451, 34.03695], [-118.61391, 34.03695], [-118.61311, 34.03689], [-118.61289, 34.03691], [-118.61253, 34.03691], [-118.61234, 34.03688], [-118.61197, 34.03679], [-118.6119, 34.03683], [-118.61168, 34.03679], [-118.61022, 34.03651], [-118.60983, 34.03648], [-118.60949, 34.03654], [-118.60912, 34.03666], [-118.60906, 34.03649], [-118.60955, 34.03616], [-118.60993, 34.03612], [-118.61164, 34.03655], [-118.61233, 34.03669], [-118.61421, 34.03668], [-118.61548, 34.03682], [-118.61679, 34.03701], [-118.61735, 34.03698], [-118.61856, 34.03714], [-118.61901, 34.03728], [-118.61992, 34.03734], [-118.62085, 34.03746], [-118.62219, 34.03757], [-118.62289, 34.03761], [-118.62384, 34.0376], [-118.62484, 34.03749], [-118.62491, 34.03758]]]} | Open Access 1 | 5472 | Big Rock Beach | 16086 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 8.357 | Big Rock Beach | 0 | Local Park 2 | 4 | |
11927 | 11927 | 11926 | {"type": "Polygon", "coordinates": [[[-118.3351, 33.89621], [-118.33509, 33.89639], [-118.33509, 33.89752], [-118.33391, 33.89739], [-118.33393, 33.89724], [-118.33319, 33.89717], [-118.33315, 33.89718], [-118.33305, 33.89734], [-118.33158, 33.89734], [-118.33197, 33.89699], [-118.33221, 33.89672], [-118.33335, 33.89514], [-118.33409, 33.89545], [-118.33411, 33.89592], [-118.33482, 33.89592], [-118.33483, 33.8962], [-118.3351, 33.89621]]]} | Open Access 1 | 24532 | Bodger Park | 16222 | 1130 | Hawthorne, City of 299 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.866 | Bodger Park | 0 | Local Park 2 | 4 | |
896 | 896 | 895 | {"type": "Polygon", "coordinates": [[[-118.44648, 33.97594], [-118.44644, 33.97736], [-118.44573, 33.9777], [-118.4455, 33.97733], [-118.44394, 33.97806], [-118.44347, 33.97739], [-118.44648, 33.97594]]]} | Open Access 1 | 6331 | Burton W. Chace Park | 16535 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.chacepark.com/index.htm | Los Angeles 6 | 7.375 | Burton W. Chace Park | 0 | Local Park 2 | 4 |
6846 | 6846 | 6845 | {"type": "Polygon", "coordinates": [[[-118.67635, 34.03704], [-118.67555, 34.03741], [-118.67475, 34.03766], [-118.67481, 34.0378], [-118.67421, 34.03796], [-118.6731, 34.03833], [-118.67205, 34.03848], [-118.67185, 34.03853], [-118.67144, 34.03857], [-118.67137, 34.03871], [-118.67127, 34.03874], [-118.67122, 34.03872], [-118.67085, 34.03876], [-118.67075, 34.03884], [-118.67039, 34.03885], [-118.67036, 34.03875], [-118.67001, 34.03876], [-118.66988, 34.0388], [-118.66945, 34.03884], [-118.66921, 34.03881], [-118.6684, 34.03883], [-118.6682, 34.03886], [-118.66739, 34.03893], [-118.66734, 34.03909], [-118.66661, 34.03908], [-118.66655, 34.03896], [-118.66626, 34.03895], [-118.66409, 34.03909], [-118.66362, 34.03906], [-118.66324, 34.03906], [-118.66221, 34.03901], [-118.66136, 34.0389], [-118.66047, 34.03885], [-118.65996, 34.03878], [-118.65982, 34.03885], [-118.65873, 34.03879], [-118.65846, 34.03872], [-118.65774, 34.03872], [-118.6576, 34.03868], [-118.65617, 34.03852], [-118.65475, 34.03841], [-118.65425, 34.03831], [-118.65375, 34.03826], [-118.65313, 34.03815], [-118.65102, 34.03789], [-118.65109, 34.03761], [-118.65227, 34.03777], [-118.65334, 34.03795], [-118.65496, 34.03819], [-118.65582, 34.03828], [-118.65647, 34.03833], [-118.6568, 34.03837], [-118.65812, 34.03841], [-118.66, 34.03853], [-118.66038, 34.03854], [-118.66107, 34.0386], [-118.66209, 34.03864], [-118.66379, 34.03879], [-118.66522, 34.03882], [-118.66588, 34.0388], [-118.66629, 34.03876], [-118.6677, 34.03876], [-118.66784, 34.03874], [-118.66832, 34.03874], [-118.66862, 34.03868], [-118.66976, 34.03857], [-118.67077, 34.03849], [-118.671, 34.03853], [-118.67124, 34.0385], [-118.67166, 34.03846], [-118.67249, 34.03825], [-118.67327, 34.03808], [-118.67344, 34.03795], [-118.6741, 34.03774], [-118.67483, 34.03754], [-118.67571, 34.03725], [-118.67629, 34.03695], [-118.67635, 34.03704]]]} | Open Access 1 | 5474 | Carbon Beach | 16843 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.coastal.ca.gov/access/Carbon_Beach_Access.pdf | Los Angeles 6 | 15.407 | Carbon Beach | 0 | Local Park 2 | 4 |
1068 | 1068 | 1067 | {"type": "Polygon", "coordinates": [[[-118.1536, 34.18804], [-118.1534, 34.18862], [-118.15355, 34.18868], [-118.15335, 34.18924], [-118.15158, 34.18867], [-118.15198, 34.18752], [-118.1536, 34.18804]]]} | Open Access 1 | 6964 | Charles White Park | 17143 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.474 | Charles White Park | 0 | Local Park 2 | 4 | |
9281 | 9281 | 9280 | {"type": "Polygon", "coordinates": [[[-117.85944, 34.10168], [-117.85727, 34.10168], [-117.85726, 34.09953], [-117.85944, 34.09953], [-117.85944, 34.10168]]]} | Open Access 1 | 15462 | Charter Oak Park | 17151 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.815 | Charter Oak Park | 0 | Local Park 2 | 4 | |
10176 | 10176 | 10175 | {"type": "Polygon", "coordinates": [[[-118.17981, 34.04781], [-118.1799, 34.04804], [-118.17993, 34.04818], [-118.17993, 34.04836], [-118.17989, 34.04857], [-118.17979, 34.0488], [-118.17912, 34.0497], [-118.17896, 34.05001], [-118.17886, 34.05039], [-118.17888, 34.05063], [-118.17892, 34.05082], [-118.17896, 34.05097], [-118.17895, 34.05099], [-118.17799, 34.05084], [-118.17797, 34.05082], [-118.17797, 34.05075], [-118.1774, 34.05068], [-118.17742, 34.05053], [-118.1771, 34.05045], [-118.17716, 34.05027], [-118.17718, 34.05026], [-118.17724, 34.05003], [-118.17736, 34.04927], [-118.17741, 34.0491], [-118.17757, 34.04802], [-118.17755, 34.0479], [-118.17755, 34.04782], [-118.17981, 34.04781]]]} | Open Access 1 | 17756 | City Terrace Park | 17347 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 15.436 | City Terrace Park | 0 | Local Park 2 | 4 | |
1004 | 1004 | 1003 | {"type": "Polygon", "coordinates": [[[-118.24421, 33.95332], [-118.24419, 33.9549], [-118.24417, 33.96001], [-118.24345, 33.96001], [-118.24343, 33.95332], [-118.24421, 33.95332]]]} | Open Access 1 | 6224 | Colonel Leon H. Washington Park | 17527 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 12.642 | Colonel Leon H. Washington Park | 0 | Local Park 2 | 4 | |
10328 | 10328 | 10327 | {"type": "Polygon", "coordinates": [[[-117.94269, 33.98979], [-117.94266, 33.98982], [-117.94246, 33.98992], [-117.94188, 33.99014], [-117.94156, 33.99032], [-117.94153, 33.99032], [-117.94034, 33.98943], [-117.94033, 33.9894], [-117.94086, 33.9888], [-117.94096, 33.98871], [-117.94106, 33.98865], [-117.94124, 33.98858], [-117.94141, 33.98854], [-117.94195, 33.98854], [-117.94201, 33.98858], [-117.94205, 33.98887], [-117.94209, 33.98901], [-117.94217, 33.98917], [-117.94231, 33.98937], [-117.94267, 33.98974], [-117.94269, 33.98979]]]} | Open Access 1 | 18190 | Countrywood Park | 17710 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 6.208 | Countrywood 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]);