units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST, GAP_STS
DES_TP 21
- Local Park 101
- Local Recreation Area 25
- Local Historic or Cultural Area 3
- Local Conservation Area 2
- Local Other or Unknown 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
AGNCY_NAME 4 ✖
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 148
MNG_AGENCY 1
- Long Beach, City of · 148 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7327 | 7327 | 7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 6641 | 14th Street Park and Playground | 15173 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.661 | 14th Street Park and Playground | 0 | Local Recreation Area 3 | 4 | |
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 4 |
15381 | 15381 | 15380 | {"type": "Polygon", "coordinates": [[[-118.20463, 33.81903], [-118.20462, 33.81984], [-118.20458, 33.82011], [-118.20441, 33.82001], [-118.20429, 33.81989], [-118.20428, 33.81985], [-118.20429, 33.81892], [-118.20458, 33.81893], [-118.20463, 33.81903]]]} | Open Access 1 | 46593 | 34th St Greenbelt | 29894 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.928 | 34th St Greenbelt | 2007 | Local Recreation Area 3 | 4 | |
971 | 971 | 970 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84873], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 6612 | 51st St Greenbelt | 29907 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.011 | 51st St Greenbelt | 2008 | Local Recreation Area 3 | 4 | |
7322 | 7322 | 7321 | {"type": "Polygon", "coordinates": [[[-118.21763, 33.79448], [-118.21763, 33.79704], [-118.21597, 33.79703], [-118.21597, 33.79622], [-118.21554, 33.79621], [-118.21554, 33.7953], [-118.21586, 33.79531], [-118.21587, 33.79525], [-118.21586, 33.79524], [-118.21561, 33.79524], [-118.21561, 33.79448], [-118.21763, 33.79448]]]} | Open Access 1 | 6631 | Admiral Issac C. Kidd Park | 29925 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 12.494 | Admiral Issac C. Kidd Park | 0 | Local Park 2 | 4 | |
7304 | 7304 | 7303 | {"type": "Polygon", "coordinates": [[[-118.1834, 33.76411], [-118.18316, 33.76539], [-118.18309, 33.76538], [-118.18307, 33.76547], [-118.18236, 33.76542], [-118.18238, 33.76532], [-118.18186, 33.76524], [-118.18183, 33.76536], [-118.18164, 33.76534], [-118.18145, 33.76534], [-118.17698, 33.76475], [-118.1768, 33.76474], [-118.17179, 33.76407], [-118.1716, 33.76411], [-118.17089, 33.76396], [-118.16946, 33.76377], [-118.16946, 33.76376], [-118.16902, 33.7637], [-118.16918, 33.76281], [-118.16993, 33.76293], [-118.17053, 33.76303], [-118.17088, 33.76311], [-118.17134, 33.76324], [-118.17264, 33.76338], [-118.17411, 33.76338], [-118.17465, 33.76332], [-118.17525, 33.7633], [-118.17654, 33.76338], [-118.17721, 33.76338], [-118.17812, 33.76333], [-118.17907, 33.7632], [-118.17996, 33.76298], [-118.18051, 33.76266], [-118.181, 33.76231], [-118.18149, 33.76159], [-118.18316, 33.76335], [-118.18317, 33.76386], [-118.1834, 33.76411]]]} | Open Access 1 | 6587 | Alamitos Beach | 15314 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 56.546 | Alamitos Beach | 0 | Local Park 2 | 4 | |
982 | 982 | 981 | {"type": "Polygon", "coordinates": [[[-118.1171, 33.74531], [-118.11692, 33.74554], [-118.11665, 33.7454], [-118.11684, 33.74516], [-118.1171, 33.74531]]]} | Open Access 1 | 6681 | Alamitos Park | 15315 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.225 | Alamitos Park | 0 | Local Park 2 | 4 | |
15089 | 15089 | 15088 | {"type": "Polygon", "coordinates": [[[-118.19096, 33.844], [-118.1907, 33.84409], [-118.19069, 33.84339], [-118.19096, 33.84339], [-118.19096, 33.844]]]} | Open Access 1 | 45871 | Arbor Street Park | 28932 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.43 | Arbor Street Park | 0 | Local Park 2 | 4 | |
3647 | 3647 | 3646 | {"type": "Polygon", "coordinates": [[[-118.18416, 33.84964], [-118.18416, 33.84977], [-118.1839, 33.84978], [-118.18368, 33.84995], [-118.18366, 33.85], [-118.18366, 33.85103], [-118.18368, 33.85107], [-118.1839, 33.85124], [-118.18415, 33.85125], [-118.18412, 33.8514], [-118.18406, 33.85154], [-118.18391, 33.85147], [-118.18377, 33.85139], [-118.18366, 33.85128], [-118.18358, 33.85119], [-118.18348, 33.85098], [-118.18344, 33.85061], [-118.18338, 33.85051], [-118.18271, 33.85006], [-118.18216, 33.84996], [-118.18039, 33.85003], [-118.18036, 33.85027], [-118.18017, 33.85029], [-118.18011, 33.85019], [-118.18008, 33.84977], [-118.17983, 33.84976], [-118.17975, 33.84957], [-118.17968, 33.84949], [-118.17974, 33.84942], [-118.17984, 33.84936], [-118.18021, 33.84922], [-118.18033, 33.84962], [-118.18037, 33.84983], [-118.18193, 33.84976], [-118.18192, 33.84935], [-118.18226, 33.84923], [-118.18204, 33.84878], [-118.18212, 33.84873], [-118.18233, 33.84879], [-118.18248, 33.84853], [-118.18292, 33.84865], [-118.18288, 33.84873], [-118.18271, 33.84886], [-118.18251, 33.84906], [-118.18305, 33.84956], [-118.18339, 33.84983], [-118.18349, 33.84986], [-118.18356, 33.84986], [-118.18363, 33.84983], [-118.18379, 33.8497], [-118.18388, 33.84966], [-118.18397, 33.84964], [-118.18416, 33.84964]]]} | Open Access 1 | 29559 | Atlantic Plaza Park | 15675 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 6.585 | Atlantic Plaza Park | 0 | Local Park 2 | 4 | |
15091 | 15091 | 15090 | {"type": "Polygon", "coordinates": [[[-118.20273, 33.82355], [-118.20253, 33.8243], [-118.2024, 33.82419], [-118.20128, 33.82355], [-118.20273, 33.82355]]]} | Open Access 1 | 45874 | Baker Street Park | 28945 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.332 | Baker Street Park | 0 | Local Park 2 | 4 | |
1120 | 1120 | 1119 | {"type": "MultiPolygon", "coordinates": [[[[-118.13088, 33.75291], [-118.13072, 33.75313], [-118.12914, 33.75219], [-118.12927, 33.75199], [-118.13088, 33.75291]]], [[[-118.13211, 33.75514], [-118.13039, 33.75789], [-118.13018, 33.75781], [-118.1303, 33.75771], [-118.13125, 33.75618], [-118.13149, 33.75596], [-118.13175, 33.7552], [-118.13179, 33.75507], [-118.1318, 33.7548], [-118.13162, 33.75434], [-118.13155, 33.75402], [-118.13074, 33.7533], [-118.13079, 33.75324], [-118.13095, 33.75332], [-118.13107, 33.7532], [-118.13126, 33.75329], [-118.13114, 33.75345], [-118.13128, 33.75352], [-118.13152, 33.75325], [-118.13174, 33.75337], [-118.1315, 33.75376], [-118.13193, 33.75398], [-118.13176, 33.75425], [-118.13211, 33.75514]]]]} | Open Access 1 | 6585 | Bayshore Beach | 29929 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.159 | Bayshore Beach | 0 | Local Park 2 | 4 | |
15398 | 15398 | 15397 | {"type": "Polygon", "coordinates": [[[-118.13217, 33.7536], [-118.13193, 33.75398], [-118.13149, 33.75376], [-118.13174, 33.75337], [-118.13217, 33.7536]]]} | Open Access 1 | 46614 | Bayshore Park | 29912 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.568 | Bayshore Park | 1934 | Local Park 2 | 4 | |
4457 | 4457 | 4456 | {"type": "Polygon", "coordinates": [[[-118.14809, 33.75779], [-118.14772, 33.75908], [-118.14638, 33.7588], [-118.14642, 33.75866], [-118.14626, 33.75863], [-118.14649, 33.75785], [-118.14496, 33.75754], [-118.14525, 33.75697], [-118.14662, 33.75743], [-118.14809, 33.75779]]]} | Open Access 1 | 46629 | Belmont Plaza Beach | 29954 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 7.27 | Belmont Plaza Beach | 0 | Local Park 2 | 4 | |
7334 | 7334 | 7333 | {"type": "Polygon", "coordinates": [[[-118.14525, 33.75697], [-118.14496, 33.75754], [-118.14479, 33.75793], [-118.14365, 33.75749], [-118.14336, 33.75801], [-118.13788, 33.7558], [-118.13804, 33.75551], [-118.13804, 33.75549], [-118.1379, 33.75544], [-118.13773, 33.75574], [-118.13625, 33.75515], [-118.13492, 33.75459], [-118.13352, 33.75392], [-118.13251, 33.75341], [-118.13275, 33.75309], [-118.13268, 33.75304], [-118.1339, 33.75143], [-118.13532, 33.75207], [-118.13542, 33.75215], [-118.13585, 33.75238], [-118.13652, 33.75266], [-118.13693, 33.75286], [-118.13741, 33.75314], [-118.13762, 33.75323], [-118.13934, 33.75415], [-118.1409, 33.75501], [-118.14093, 33.75504], [-118.14132, 33.75525], [-118.14136, 33.75528], [-118.14147, 33.75533], [-118.1415, 33.75538], [-118.14141, 33.75556], [-118.14525, 33.75697]]]} | Open Access 1 | 6647 | Belmont Shore Beach | 15995 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 64.1 | Belmont Shore Beach | 0 | Local Park 2 | 4 | |
4458 | 4458 | 4457 | {"type": "Polygon", "coordinates": [[[-118.14947, 33.75539], [-118.14946, 33.75548], [-118.14907, 33.75548], [-118.14906, 33.75553], [-118.14897, 33.75553], [-118.14897, 33.75556], [-118.14888, 33.75557], [-118.14861, 33.75645], [-118.14864, 33.75647], [-118.14864, 33.75653], [-118.1486, 33.75667], [-118.14856, 33.75674], [-118.14852, 33.75674], [-118.14791, 33.75887], [-118.14838, 33.75898], [-118.14834, 33.75914], [-118.14824, 33.75913], [-118.14821, 33.75924], [-118.14797, 33.75913], [-118.14772, 33.75908], [-118.14809, 33.75779], [-118.14842, 33.75671], [-118.1484, 33.7567], [-118.1484, 33.75656], [-118.14847, 33.75645], [-118.14851, 33.75645], [-118.14865, 33.75594], [-118.14863, 33.75593], [-118.1487, 33.75568], [-118.1486, 33.75555], [-118.14853, 33.75562], [-118.14856, 33.75566], [-118.14836, 33.75576], [-118.14831, 33.75569], [-118.14849, 33.75561], [-118.1485, 33.75559], [-118.14846, 33.75556], [-118.14829, 33.75563], [-118.14823, 33.75556], [-118.14841, 33.75547], [-118.14847, 33.75552], [-118.14856, 33.75549], [-118.14859, 33.75548], [-118.14862, 33.75539], [-118.1483, 33.75524], [-118.14835, 33.75515], [-118.14869, 33.75531], [-118.14871, 33.75528], [-118.14891, 33.75528], [-118.14907, 33.75535], [-118.14908, 33.75539], [-118.14947, 33.75539]]]} | Open Access 1 | 46630 | Belmont Veterans Memorial Pier | 29955 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.094 | Belmont Veterans Memorial Pier | None 398 | |||
15094 | 15094 | 15093 | {"type": "Polygon", "coordinates": [[[-118.10508, 33.83028], [-118.10508, 33.83056], [-118.10362, 33.83055], [-118.10362, 33.83028], [-118.10508, 33.83028]]]} | Open Access 1 | 45881 | Birdcage Park | 28957 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/Park/Park-and-Facilities/Directory/Birdcage-Park/ | Los Angeles 6 | 1.034 | Birdcage Park | 0 | Local Park 2 | 4 |
972 | 972 | 971 | {"type": "Polygon", "coordinates": [[[-118.18037, 33.84032], [-118.18037, 33.84033], [-118.17814, 33.84152], [-118.17816, 33.84104], [-118.17814, 33.8409], [-118.17808, 33.84071], [-118.17988, 33.83974], [-118.18009, 33.84001], [-118.18012, 33.84], [-118.18037, 33.84032]]]} | Open Access 1 | 6613 | Bixby Knolls Park | 16130 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.268 | Bixby Knolls Park | 0 | Local Park 2 | 4 | |
7329 | 7329 | 7328 | {"type": "MultiPolygon", "coordinates": [[[[-118.16786, 33.76675], [-118.16779, 33.76716], [-118.16686, 33.76704], [-118.16596, 33.76685], [-118.16609, 33.76645], [-118.16696, 33.76664], [-118.16786, 33.76675]]], [[[-118.16806, 33.76568], [-118.1679, 33.76655], [-118.16701, 33.76644], [-118.16614, 33.76625], [-118.1664, 33.7654], [-118.16722, 33.76558], [-118.16806, 33.76568]]], [[[-118.16849, 33.76328], [-118.16831, 33.76434], [-118.16756, 33.76424], [-118.16632, 33.76398], [-118.16646, 33.76351], [-118.16629, 33.76346], [-118.16642, 33.76296], [-118.16849, 33.76328]]], [[[-118.16827, 33.76461], [-118.1681, 33.76548], [-118.16727, 33.76538], [-118.16646, 33.7652], [-118.16671, 33.76434], [-118.16748, 33.76452], [-118.16827, 33.76461]]]]} | Open Access 1 | 6642 | Bixby Park | 16131 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 15.024 | Bixby Park | 0 | Local Park 2 | 4 | |
1135 | 1135 | 1134 | {"type": "Polygon", "coordinates": [[[-118.16446, 33.76279], [-118.1643, 33.76333], [-118.15256, 33.76088], [-118.15255, 33.76085], [-118.15103, 33.76079], [-118.15064, 33.7607], [-118.15091, 33.75983], [-118.15284, 33.76035], [-118.15644, 33.76123], [-118.1582, 33.76158], [-118.15995, 33.76196], [-118.16349, 33.76263], [-118.16446, 33.76279]]]} | Open Access 1 | 6644 | Bluff Park | 16198 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 18.611 | Bluff Park | 0 | Local Park 2 | 4 | |
7333 | 7333 | 7332 | {"type": "MultiPolygon", "coordinates": [[[[-118.12869, 33.78809], [-118.12813, 33.78802], [-118.12762, 33.788], [-118.12762, 33.78783], [-118.12856, 33.78792], [-118.12866, 33.78798], [-118.12869, 33.78809]]], [[[-118.12949, 33.78801], [-118.12946, 33.78827], [-118.12881, 33.78811], [-118.12876, 33.78794], [-118.12949, 33.78801]]]]} | Open Access 1 | 6664 | Bouton Creek Park | 16303 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.77 | Bouton Creek 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]);