units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where ACCESS_TYP = 3, DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY 15
- Los Angeles, City of 12
- San Diego, City of 3
- San Marcos, City of 2
- Rolling Hills, City of 2
- Napa, City of 2
- Rocklin, City of 2
- Santee, City of 1
- Rosemead, City of 1
- Palmdale, City of 1
- Norwalk, City of 1
- Bakersfield, City of 1
- Long Beach, City of 1
- Agoura Hills, City of 1
- Roseville, City of 1
- South El Monte, City of 1
MNG_AG_TYP 1
- City Agency · 32 ✖
DES_TP 1
- Local Park · 32 ✖
ACCESS_TYP 1
- No Public Access · 32 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3303 | 3303 | 3302 | {"type": "MultiPolygon", "coordinates": [[[[-121.29299, 38.78675], [-121.29281, 38.78695], [-121.29151, 38.78601], [-121.29153, 38.7857], [-121.29165, 38.78561], [-121.29166, 38.78556], [-121.29165, 38.78546], [-121.29178, 38.78527], [-121.29243, 38.78543], [-121.29257, 38.78589], [-121.29299, 38.78675]]], [[[-121.32257, 38.76796], [-121.32255, 38.76799], [-121.32252, 38.76801], [-121.32191, 38.76817], [-121.32101, 38.76854], [-121.32076, 38.76804], [-121.32034, 38.76803], [-121.32019, 38.76737], [-121.32083, 38.76704], [-121.32074, 38.76639], [-121.31577, 38.76639], [-121.31578, 38.76596], [-121.31577, 38.76578], [-121.31572, 38.76558], [-121.31564, 38.76537], [-121.31596, 38.76536], [-121.31607, 38.76549], [-121.31619, 38.76559], [-121.31638, 38.76567], [-121.31656, 38.76571], [-121.3173, 38.76572], [-121.31743, 38.76571], [-121.31756, 38.76568], [-121.31769, 38.76562], [-121.31793, 38.76545], [-121.31798, 38.76544], [-121.31832, 38.7656], [-121.3186, 38.76569], [-121.31891, 38.76575], [-121.31922, 38.76576], [-121.31959, 38.76571], [-121.3198, 38.76566], [-121.31999, 38.76559], [-121.32028, 38.76544], [-121.32042, 38.76534], [-121.32056, 38.76522], [-121.32175, 38.76518], [-121.32181, 38.76503], [-121.32197, 38.76507], [-121.322, 38.76509], [-121.32201, 38.76513], [-121.32185, 38.76559], [-121.32182, 38.76576], [-121.32181, 38.76597], [-121.32183, 38.76617], [-121.3219, 38.76638], [-121.32224, 38.76714], [-121.32257, 38.76796]]]]} | No Public Access 3 | 29576 | Proposed Park | 24017 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 23.324 | Proposed Park | 0 | Local Park 2 | 4 | |
3421 | 3421 | 3420 | {"type": "Polygon", "coordinates": [[[-116.96658, 32.84974], [-116.96647, 32.85215], [-116.96564, 32.85215], [-116.965, 32.85221], [-116.96414, 32.85224], [-116.96351, 32.8521], [-116.96347, 32.85208], [-116.96345, 32.85204], [-116.96339, 32.85204], [-116.9634, 32.85153], [-116.96338, 32.85152], [-116.9634, 32.85046], [-116.96343, 32.85045], [-116.96343, 32.84995], [-116.96658, 32.84974]]]} | No Public Access 3 | 25131 | Radio Towers Park | 24070 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 18.699 | Radio Towers Park | 0 | Local Park 2 | 4 | |
3640 | 3640 | 3639 | {"type": "Polygon", "coordinates": [[[-121.25516, 38.82911], [-121.25484, 38.82931], [-121.25459, 38.82956], [-121.25447, 38.82976], [-121.25421, 38.8303], [-121.25411, 38.83044], [-121.25317, 38.82964], [-121.25338, 38.82941], [-121.25345, 38.82929], [-121.2535, 38.82917], [-121.25354, 38.82903], [-121.25355, 38.82889], [-121.25354, 38.82875], [-121.25351, 38.8286], [-121.25392, 38.82844], [-121.25515, 38.82835], [-121.25517, 38.82877], [-121.25511, 38.82902], [-121.25516, 38.82911]]]} | No Public Access 3 | 29498 | Mansion Oaks Park | 21761 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 5.751 | Mansion Oaks Park | 0 | Local Park 2 | 4 | |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 19.773 | Neighborhood 8 Neighborhood Park | 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 | |
6608 | 6608 | 6607 | {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} | No Public Access 3 | 4168 | Beyer Community Park | 30224 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 43.828 | Beyer Community Park | 0 | Local Park 2 | 4 | |
6999 | 6999 | 6998 | {"type": "Polygon", "coordinates": [[[-118.35627, 33.76696], [-118.35581, 33.76818], [-118.35516, 33.7689], [-118.35493, 33.76928], [-118.35465, 33.76912], [-118.35469, 33.76907], [-118.35503, 33.76841], [-118.35508, 33.76827], [-118.35509, 33.7682], [-118.3552, 33.76791], [-118.35547, 33.7675], [-118.3558, 33.76678], [-118.35627, 33.76696]]]} | No Public Access 3 | 5938 | Rolling Hills City Parkland | 24574 | 1282 | Rolling Hills, City of 288 | City 2 | City Agency 2 | http://www.rolling-hills.org/ | City 2 | 1282 | Rolling Hills, City of 285 | City 2 | City Agency 2 | Los Angeles 6 | 3.334 | Rolling Hills City Parkland | 0 | Local Park 2 | 4 | |
7000 | 7000 | 6999 | {"type": "Polygon", "coordinates": [[[-118.34321, 33.7627], [-118.34301, 33.76401], [-118.34289, 33.76533], [-118.34181, 33.76568], [-118.34103, 33.766], [-118.34091, 33.76615], [-118.34084, 33.76592], [-118.34013, 33.76572], [-118.33993, 33.76592], [-118.34015, 33.76629], [-118.34015, 33.76661], [-118.33955, 33.76629], [-118.33896, 33.76581], [-118.33863, 33.76543], [-118.33917, 33.76497], [-118.34028, 33.76519], [-118.34115, 33.76476], [-118.34115, 33.76475], [-118.34091, 33.7645], [-118.34081, 33.76415], [-118.34098, 33.76406], [-118.34132, 33.76401], [-118.34177, 33.76412], [-118.34181, 33.76404], [-118.34321, 33.7627]]]} | No Public Access 3 | 5939 | Rolling Hills City Parkland | 24574 | 1282 | Rolling Hills, City of 288 | City 2 | City Agency 2 | http://www.rolling-hills.org/ | City 2 | 1282 | Rolling Hills, City of 285 | City 2 | City Agency 2 | Los Angeles 6 | 15.507 | Rolling Hills City Parkland | 0 | Local Park 2 | 4 | |
7534 | 7534 | 7533 | {"type": "Polygon", "coordinates": [[[-118.78014, 34.14754], [-118.78008, 34.14761], [-118.78006, 34.14768], [-118.77994, 34.14767], [-118.77967, 34.14771], [-118.77895, 34.14786], [-118.77864, 34.1479], [-118.77715, 34.14789], [-118.77638, 34.14778], [-118.77611, 34.14778], [-118.77413, 34.14793], [-118.77413, 34.14783], [-118.77432, 34.14788], [-118.77524, 34.14781], [-118.77589, 34.14763], [-118.77771, 34.1475], [-118.77817, 34.14749], [-118.77833, 34.14745], [-118.77934, 34.14745], [-118.78014, 34.14754]]]} | No Public Access 3 | 7112 | Agoura Hills City Parkland | 15288 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 1000 | Agoura Hills, City of 316 | City 2 | City Agency 2 | Los Angeles 6 | 3.654 | Agoura Hills City 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 | |
7628 | 7628 | 7627 | {"type": "Polygon", "coordinates": [[[-117.15123, 33.13075], [-117.14933, 33.13075], [-117.14897, 33.13165], [-117.14916, 33.13197], [-117.15033, 33.13376], [-117.14836, 33.13491], [-117.14827, 33.13106], [-117.14832, 33.12938], [-117.14827, 33.12783], [-117.14921, 33.12832], [-117.14932, 33.12837], [-117.14963, 33.12845], [-117.15012, 33.12851], [-117.15039, 33.12859], [-117.15064, 33.12873], [-117.15083, 33.12889], [-117.15099, 33.12911], [-117.15109, 33.12937], [-117.15123, 33.13075]]]} | No Public Access 3 | 47623 | La Moree Park | 31359 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 28.883 | La Moree Park | 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 | |
8217 | 8217 | 8216 | {"type": "Polygon", "coordinates": [[[-117.17097, 33.11374], [-117.17037, 33.11403], [-117.16936, 33.1144], [-117.16869, 33.11525], [-117.16869, 33.11589], [-117.1677, 33.11649], [-117.16752, 33.11688], [-117.16683, 33.11688], [-117.16714, 33.11618], [-117.16679, 33.11598], [-117.16555, 33.11598], [-117.16559, 33.11623], [-117.16539, 33.11626], [-117.16533, 33.11598], [-117.16473, 33.11597], [-117.16472, 33.11457], [-117.16443, 33.11428], [-117.16415, 33.11412], [-117.16436, 33.11387], [-117.16443, 33.1135], [-117.16443, 33.11338], [-117.16416, 33.11309], [-117.16432, 33.11292], [-117.16492, 33.11313], [-117.16499, 33.11327], [-117.16616, 33.11328], [-117.16617, 33.11297], [-117.1667, 33.11245], [-117.16671, 33.11222], [-117.16609, 33.1121], [-117.16543, 33.11143], [-117.16572, 33.11127], [-117.16596, 33.11142], [-117.16637, 33.11155], [-117.16697, 33.1115], [-117.16709, 33.11132], [-117.16748, 33.11138], [-117.16788, 33.11159], [-117.16805, 33.11267], [-117.16799, 33.11329], [-117.16876, 33.11329], [-117.16878, 33.11319], [-117.16924, 33.11279], [-117.17009, 33.11237], [-117.16996, 33.11267], [-117.16958, 33.1131], [-117.16954, 33.11329], [-117.16947, 33.1133], [-117.16942, 33.11355], [-117.16966, 33.11366], [-117.17097, 33.11374]], [[-117.16912, 33.11452], [-117.16939, 33.11424], [-117.16972, 33.11406], [-117.16972, 33.11395], [-117.16945, 33.11372], [-117.16928, 33.11338], [-117.16907, 33.11344], [-117.16868, 33.11397], [-117.1683, 33.11424], [-117.16779, 33.11418], [-117.16765, 33.11374], [-117.16769, 33.11329], [-117.16666, 33.11328], [-117.16658, 33.11343], [-117.16583, 33.11369], [-117.1652, 33.11353], [-117.1649, 33.11361], [-117.16487, 33.11397], [-117.16536, 33.11482], [-117.16555, 33.11498], [-117.16593, 33.11491], [-117.16683, 33.11496], [-117.16743, 33.1153], [-117.16849, 33.11523], [-117.16906, 33.11473], [-117.16912, 33.11452]]]} | No Public Access 3 | 47786 | South Lake Park | 31662 | 2170 | Vallecitos Water District 879 | Special District 4 | Water District 13 | http://www.vwd.org/ | Special District 4 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 29.916 | South Lake Park | 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]);