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_ID
This data as json, copyable, CSV (advanced)
DES_TP 20
- Local Park 85
- Local Recreation Area 24
- Local Historic or Cultural 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
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 128
MNG_AGENCY 1
- Long Beach, City of · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1125 | 1125 | 1124 | {"type": "Polygon", "coordinates": [[[-118.19523, 33.85437], [-118.19505, 33.85468], [-118.19468, 33.85468], [-118.19486, 33.85437], [-118.19523, 33.85437]]]} | Open Access 1 | 6599 | Burton W. Chace Park | 28711 | 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.287 | Burton W. Chace Park | 0 | Local Park 2 | 4 | |
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86063], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | 6600 | DeForest Park | 18015 | 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 | 34.12 | DeForest Park | 2018 | Local Park 2 | 4 | |
1126 | 1126 | 1125 | {"type": "MultiPolygon", "coordinates": [[[[-118.19262, 33.86033], [-118.1925, 33.86059], [-118.19247, 33.86057], [-118.19244, 33.8605], [-118.1922, 33.86042], [-118.19216, 33.86047], [-118.19211, 33.86043], [-118.19206, 33.86043], [-118.19206, 33.86014], [-118.19229, 33.86016], [-118.19238, 33.86019], [-118.19262, 33.86033]]], [[[-118.19495, 33.86197], [-118.1949, 33.86207], [-118.19487, 33.86207], [-118.19485, 33.86197], [-118.1935, 33.86102], [-118.19314, 33.86081], [-118.19274, 33.86062], [-118.19263, 33.86064], [-118.19277, 33.86047], [-118.19278, 33.86047], [-118.19475, 33.86186], [-118.19494, 33.86194], [-118.19494, 33.86196], [-118.19495, 33.86197]]], [[[-118.19511, 33.86172], [-118.19507, 33.86179], [-118.195, 33.86182], [-118.19478, 33.86171], [-118.19288, 33.86037], [-118.19326, 33.86055], [-118.19364, 33.86077], [-118.195, 33.86172], [-118.19508, 33.86171], [-118.19511, 33.86172]]]]} | Open Access 1 | 6601 | South Street Parkway | 25680 | 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.42 | South Street Parkway | 0 | Local Recreation Area 3 | 4 | |
1127 | 1127 | 1126 | {"type": "Polygon", "coordinates": [[[-118.15552, 33.87377], [-118.15359, 33.87378], [-118.15358, 33.87208], [-118.15446, 33.87208], [-118.15457, 33.87214], [-118.15466, 33.87229], [-118.15471, 33.87236], [-118.15487, 33.87246], [-118.15506, 33.8725], [-118.15552, 33.8725], [-118.15552, 33.87377]]]} | Open Access 1 | 6602 | Ramona Park | 24119 | 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.46 | Ramona Park | 0 | Local Park 2 | 4 | |
967 | 967 | 966 | {"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]} | Open Access 1 | 6603 | Houghton Park | 20109 | 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 | 26.14 | Houghton Park | 0 | Local Park 2 | 4 | |
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14804, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | 6605 | Unknown park - Long Beach, City of | 29921 | 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.432 | 0 | Local Other or Unknown 14 | 4 | ||
16323 | 16323 | 16322 | {"type": "MultiPolygon", "coordinates": [[[[-118.0908, 33.81768], [-118.09047, 33.81769], [-118.0906, 33.81868], [-118.08945, 33.81869], [-118.0885, 33.81861], [-118.0879, 33.81852], [-118.08434, 33.81774], [-118.08378, 33.81764], [-118.08341, 33.81758], [-118.08287, 33.81754], [-118.08224, 33.81751], [-118.08174, 33.81752], [-118.08176, 33.81394], [-118.08195, 33.81393], [-118.08196, 33.81266], [-118.0827, 33.81114], [-118.08279, 33.811], [-118.08295, 33.81085], [-118.08305, 33.81079], [-118.08332, 33.81069], [-118.08445, 33.81057], [-118.08673, 33.81058], [-118.08732, 33.81055], [-118.09009, 33.81055], [-118.09014, 33.8117], [-118.0905, 33.81171], [-118.09051, 33.81179], [-118.0906, 33.81391], [-118.0908, 33.81768]]], [[[-118.09232, 33.82822], [-118.09099, 33.82783], [-118.09091, 33.82687], [-118.09069, 33.82686], [-118.09069, 33.82486], [-118.08925, 33.82485], [-118.08923, 33.8273], [-118.08223, 33.82523], [-118.08214, 33.82485], [-118.0819, 33.82348], [-118.08181, 33.82263], [-118.08175, 33.82191], [-118.08173, 33.8205], [-118.08174, 33.82047], [-118.08175, 33.81779], [-118.08278, 33.81781], [-118.08335, 33.81786], [-118.08389, 33.81793], [-118.08736, 33.81869], [-118.08744, 33.81869], [-118.08787, 33.81882], [-118.08834, 33.81889], [-118.08886, 33.81894], [-118.08923, 33.81896], [-118.09064, 33.81895], [-118.09076, 33.81978], [-118.09109, 33.81978], [-118.09232, 33.82822]]]]} | Open Access 1 | 6606 | El Dorado East Regional Park | 5426 | 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/parks_and_open_spaces/parks/el_dorado_regional_park.asp | Los Angeles 6 | 354.173 | El Dorado East RP | 0 | Local Park 2 | 4 |
968 | 968 | 967 | {"type": "Polygon", "coordinates": [[[-118.10763, 33.83029], [-118.10763, 33.83204], [-118.10759, 33.8321], [-118.09924, 33.83206], [-118.09919, 33.83205], [-118.09916, 33.83201], [-118.09956, 33.8307], [-118.09974, 33.83027], [-118.10362, 33.83028], [-118.10363, 33.83055], [-118.10507, 33.83056], [-118.10508, 33.83028], [-118.10763, 33.83029]]]} | Restricted Access 2 | 6607 | Heartwell Golf Course | 33019 | 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 | 36.514 | Heartwell GC | 0 | Local Recreation Area 3 | 4 | |
969 | 969 | 968 | {"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19542, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19734, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19821, 33.7671], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76709], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]} | Open Access 1 | 6608 | Santa Cruz Park | 25082 | 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.096 | Santa Cruz Park | 0 | Local Park 2 | 4 | |
970 | 970 | 969 | {"type": "Polygon", "coordinates": [[[-118.19511, 33.76865], [-118.19493, 33.76865], [-118.19494, 33.76918], [-118.19389, 33.76918], [-118.19389, 33.76817], [-118.1949, 33.76817], [-118.19491, 33.76828], [-118.19494, 33.76834], [-118.19502, 33.76837], [-118.19511, 33.76837], [-118.19511, 33.76865]]]} | Open Access 1 | 6609 | Lincoln Park | 21264 | 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.816 | Lincoln Park | 0 | Local Park 2 | 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 | |
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 | |
973 | 973 | 972 | {"type": "Polygon", "coordinates": [[[-118.15882, 33.78532], [-118.15882, 33.78581], [-118.15806, 33.78532], [-118.15684, 33.78532], [-118.15684, 33.78449], [-118.15846, 33.78449], [-118.15846, 33.78475], [-118.15833, 33.78476], [-118.15833, 33.78497], [-118.15846, 33.78497], [-118.15846, 33.7853], [-118.15849, 33.78532], [-118.15882, 33.78532]]]} | Open Access 1 | 6614 | Orizaba Park | 23204 | 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 | 3.776 | Orizaba Park | 0 | Local Park 2 | 4 | |
7315 | 7315 | 7314 | {"type": "Polygon", "coordinates": [[[-118.16917, 33.76286], [-118.16902, 33.7637], [-118.16866, 33.76365], [-118.1687, 33.76342], [-118.16848, 33.7634], [-118.16848, 33.76328], [-118.16805, 33.76321], [-118.1681, 33.76292], [-118.16333, 33.76211], [-118.16329, 33.76239], [-118.16467, 33.76266], [-118.16452, 33.76307], [-118.16439, 33.76304], [-118.16446, 33.76281], [-118.16445, 33.76279], [-118.16349, 33.76263], [-118.15995, 33.76196], [-118.1582, 33.76158], [-118.15644, 33.76123], [-118.15284, 33.76035], [-118.15092, 33.75983], [-118.15086, 33.76], [-118.14821, 33.75924], [-118.14824, 33.75912], [-118.14834, 33.75913], [-118.14838, 33.75898], [-118.14791, 33.75888], [-118.1482, 33.75782], [-118.15107, 33.7587], [-118.15116, 33.7588], [-118.15507, 33.75983], [-118.15767, 33.76048], [-118.16043, 33.76106], [-118.16264, 33.76158], [-118.16496, 33.76209], [-118.16842, 33.76269], [-118.16917, 33.76286]]]} | Open Access 1 | 6629 | Junipero Beach | 20529 | 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 | 48.486 | Junipero Beach | 0 | Local Park 2 | 4 | |
7321 | 7321 | 7320 | {"type": "Polygon", "coordinates": [[[-118.19583, 33.75484], [-118.1958, 33.7549], [-118.19566, 33.75492], [-118.19552, 33.75499], [-118.19539, 33.75504], [-118.19534, 33.75504], [-118.19526, 33.75502], [-118.19505, 33.75519], [-118.19498, 33.75519], [-118.19489, 33.75516], [-118.19473, 33.75496], [-118.19454, 33.7548], [-118.19449, 33.75476], [-118.19437, 33.75471], [-118.19433, 33.75467], [-118.19427, 33.75456], [-118.19424, 33.75444], [-118.19423, 33.75426], [-118.19419, 33.75416], [-118.19416, 33.75412], [-118.19408, 33.75409], [-118.19398, 33.75407], [-118.19373, 33.75397], [-118.19404, 33.75334], [-118.19536, 33.75382], [-118.19536, 33.75457], [-118.19537, 33.75465], [-118.19547, 33.75475], [-118.19583, 33.75484]]]} | Open Access 1 | 6630 | Queen Mary Events Park | 24061 | 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.722 | Queen Mary Events Park | 0 | Local Park 2 | 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 | |
1134 | 1134 | 1133 | {"type": "Polygon", "coordinates": [[[-118.22322, 33.79713], [-118.2227, 33.79832], [-118.22143, 33.79833], [-118.22142, 33.79884], [-118.21988, 33.79884], [-118.21988, 33.7972], [-118.22031, 33.7972], [-118.22032, 33.79714], [-118.22322, 33.79713]]]} | Open Access 1 | 6632 | Hudson Park | 20134 | 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 | 11.236 | Hudson Park | 0 | Local Park 2 | 4 | |
7323 | 7323 | 7322 | {"type": "Polygon", "coordinates": [[[-118.19536, 33.87403], [-118.19508, 33.874], [-118.19483, 33.87391], [-118.19479, 33.87373], [-118.19471, 33.87356], [-118.19449, 33.87322], [-118.19443, 33.87308], [-118.19439, 33.87291], [-118.19437, 33.87267], [-118.19437, 33.8726], [-118.19457, 33.87162], [-118.19472, 33.87105], [-118.19496, 33.8704], [-118.19529, 33.86975], [-118.19535, 33.86975], [-118.19534, 33.87241], [-118.19536, 33.87403]]]} | Open Access 1 | 6633 | Coolidge Park | 17621 | 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.124 | Coolidge Park | 0 | Local Park 2 | 4 | |
7324 | 7324 | 7323 | {"type": "Polygon", "coordinates": [[[-118.18924, 33.76079], [-118.18923, 33.76161], [-118.1892, 33.76167], [-118.1889, 33.76173], [-118.18823, 33.76179], [-118.18785, 33.76188], [-118.18762, 33.76195], [-118.18723, 33.76212], [-118.18697, 33.76226], [-118.18545, 33.76317], [-118.18538, 33.76318], [-118.18534, 33.76316], [-118.18518, 33.76325], [-118.1852, 33.76332], [-118.18516, 33.76336], [-118.18447, 33.76377], [-118.18422, 33.76395], [-118.18368, 33.7645], [-118.18357, 33.7645], [-118.18361, 33.76438], [-118.18333, 33.76403], [-118.18347, 33.76392], [-118.18498, 33.76301], [-118.18513, 33.7629], [-118.18688, 33.76188], [-118.18819, 33.76118], [-118.18924, 33.76079]]]} | Open Access 1 | 6634 | Marina Green | 21822 | 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.806 | Marina Green | 0 | Local Park 2 | 4 | |
7325 | 7325 | 7324 | {"type": "Polygon", "coordinates": [[[-118.18561, 33.78421], [-118.18515, 33.78421], [-118.18515, 33.78386], [-118.18561, 33.78387], [-118.18561, 33.78421]]]} | Open Access 1 | 6636 | Peace Park | 23539 | 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.401 | Peace 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]);