units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where DES_TP = 2 and MNG_AGENCY = 294 sorted by YR_EST descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 101
MNG_AGENCY 1
- Long Beach, City of · 101 ✖
DES_TP 1
- Local Park · 101 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
15400 | 15400 | 15399 | {"type": "Polygon", "coordinates": [[[-118.20264, 33.82045], [-118.20248, 33.82045], [-118.20153, 33.81926], [-118.20157, 33.81922], [-118.2021, 33.81932], [-118.20229, 33.81937], [-118.2023, 33.81941], [-118.20247, 33.81946], [-118.20248, 33.81943], [-118.20264, 33.81948], [-118.20264, 33.82045]]]} | Open Access 1 | 46617 | Wrigley Heights Dog Park | 29932 | 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.703 | Wrigley Heights Dog Park | 2014 | Local Park 2 | 4 | |
15125 | 15125 | 15124 | {"type": "Polygon", "coordinates": [[[-118.18058, 33.80621], [-118.18059, 33.80984], [-118.18057, 33.81046], [-118.18041, 33.81046], [-118.17969, 33.81087], [-118.17885, 33.81087], [-118.17885, 33.81152], [-118.1774, 33.81152], [-118.1774, 33.81136], [-118.17753, 33.81135], [-118.17753, 33.81108], [-118.17786, 33.8108], [-118.17854, 33.8108], [-118.17874, 33.81064], [-118.17874, 33.81009], [-118.17754, 33.81009], [-118.17753, 33.80951], [-118.17641, 33.8095], [-118.17642, 33.80662], [-118.1766, 33.80662], [-118.17681, 33.80621], [-118.18058, 33.80621]]]} | Open Access 1 | 45937 | Willow Springs Park | 29012 | 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 | 44.552 | Willow Springs Park | 2012 | Local Park 2 | 4 | |
14942 | 14942 | 14941 | {"type": "Polygon", "coordinates": [[[-118.11811, 33.76285], [-118.11631, 33.76422], [-118.11624, 33.76415], [-118.11618, 33.76418], [-118.11611, 33.76416], [-118.11597, 33.76427], [-118.11571, 33.76358], [-118.11587, 33.76352], [-118.1161, 33.76331], [-118.11638, 33.76318], [-118.11666, 33.76312], [-118.1168, 33.76307], [-118.11682, 33.76311], [-118.11628, 33.7633], [-118.11636, 33.76346], [-118.11659, 33.76339], [-118.11663, 33.76345], [-118.11677, 33.76341], [-118.11675, 33.76333], [-118.11691, 33.76328], [-118.1169, 33.76324], [-118.117, 33.7632], [-118.11694, 33.76308], [-118.11685, 33.76311], [-118.11683, 33.76306], [-118.11754, 33.76277], [-118.11791, 33.76267], [-118.11811, 33.76285]]]} | Open Access 1 | 45541 | Jack Nichol Park | 28370 | 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.508 | Jack Nichol Park | 2007 | Local Park 2 | 4 | |
16815 | 16815 | 16814 | {"type": "Polygon", "coordinates": [[[-118.09007, 33.81023], [-118.0898, 33.81023], [-118.08979, 33.81025], [-118.08952, 33.81025], [-118.08951, 33.81028], [-118.08938, 33.81028], [-118.08938, 33.81031], [-118.089, 33.81031], [-118.08899, 33.81032], [-118.087, 33.81031], [-118.08681, 33.8103], [-118.08646, 33.81026], [-118.08528, 33.81025], [-118.08526, 33.80869], [-118.08528, 33.80858], [-118.08528, 33.80779], [-118.0838, 33.8078], [-118.08379, 33.8066], [-118.08225, 33.8066], [-118.0825, 33.80624], [-118.08262, 33.8061], [-118.08326, 33.80558], [-118.08379, 33.80511], [-118.08429, 33.80462], [-118.0848, 33.80407], [-118.08488, 33.80402], [-118.085, 33.80397], [-118.08519, 33.80394], [-118.08609, 33.80401], [-118.0878, 33.80432], [-118.08845, 33.8044], [-118.08879, 33.80441], [-118.08879, 33.80434], [-118.08978, 33.80435], [-118.09007, 33.81023]]]} | Open Access 1 | 6665 | El Dorado Nature Center | 18502 | 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 | 87.546 | El Dorado Nature Ctr. | 1998 | Local Park 2 | 4 | |
15397 | 15397 | 15396 | {"type": "MultiPolygon", "coordinates": [[[[-118.16911, 33.76371], [-118.16907, 33.76395], [-118.16889, 33.76393], [-118.16893, 33.76369], [-118.16911, 33.76371]]], [[[-118.17, 33.76384], [-118.16997, 33.76404], [-118.16979, 33.76401], [-118.16982, 33.76382], [-118.17, 33.76384]]], [[[-118.17089, 33.76396], [-118.17086, 33.76416], [-118.17068, 33.76414], [-118.17072, 33.76393], [-118.17089, 33.76396]]], [[[-118.17176, 33.76423], [-118.17175, 33.7643], [-118.17157, 33.76428], [-118.17158, 33.76412], [-118.17159, 33.76412], [-118.17167, 33.76419], [-118.17176, 33.76423]]], [[[-118.17268, 33.76419], [-118.17265, 33.76435], [-118.17248, 33.76433], [-118.1725, 33.76417], [-118.17268, 33.76419]]], [[[-118.17358, 33.76431], [-118.17354, 33.76452], [-118.17346, 33.76449], [-118.17336, 33.7645], [-118.1734, 33.76428], [-118.17358, 33.76431]]], [[[-118.17447, 33.76442], [-118.17443, 33.76465], [-118.17439, 33.76464], [-118.17435, 33.76461], [-118.17425, 33.76462], [-118.17429, 33.7644], [-118.17447, 33.76442]]], [[[-118.17536, 33.76454], [-118.17533, 33.76475], [-118.17515, 33.76473], [-118.17519, 33.76452], [-118.17536, 33.76454]]], [[[-118.17626, 33.76466], [-118.17623, 33.76484], [-118.17605, 33.76482], [-118.17608, 33.76464], [-118.17626, 33.76466]]], [[[-118.17716, 33.76478], [-118.17711, 33.76501], [-118.17694, 33.76498], [-118.17698, 33.76475], [-118.17716, 33.76478]]], [[[-118.17805, 33.76489], [-118.17801, 33.76512], [-118.17783, 33.7651], [-118.17787, 33.76487], [-118.17805, 33.76489]]], [[[-118.17895, 33.76501], [-118.17891, 33.76521], [-118.17873, 33.76519], [-118.17877, 33.76499], [-118.17895, 33.76501]]], [[[-118.17984, 33.76513], [-118.1798, 33.76535], [-118.17962, 33.76533], [-118.17966, 33.7651], [-118.17984, 33.76513]]], [[[-118.18074, 33.76524], [-118.18068, 33.76554], [-118.18063, 33.76552], [-118.1805, 33.76551], [-118.18056, 33.76522], [-118.18074, 33.76524]]], [[[-118.18164, 33.76534], [-118.18157, 33.76571], [-118.18151, 33.76569], [-118.18139, 33.76569], [-118.18145, 33.76534], [-118.18164, 33.76534]]]]} | Open Access 1 | 46613 | Mini-Parks at 1st Place through 15th Place | 29924 | 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.511 | Mini-Parks at 1st Place through 15th Place | 1980 | Local Park 2 | 4 | |
7355 | 7355 | 7354 | {"type": "Polygon", "coordinates": [[[-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77172], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10417, 33.77181], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788]]]} | Open Access 1 | 6680 | Channel View Park | 17123 | 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 | 5.302 | Channel View Park | 1968 | 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 | |
963 | 963 | 962 | {"type": "Polygon", "coordinates": [[[-118.13204, 33.83966], [-118.13203, 33.84296], [-118.1306, 33.84295], [-118.13062, 33.83966], [-118.13204, 33.83966]]]} | Open Access 1 | 6576 | Pan American Park | 23383 | 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.97 | Pan American Park | 0 | Local Park 2 | 4 | |
965 | 965 | 964 | {"type": "Polygon", "coordinates": [[[-118.17515, 33.78271], [-118.17514, 33.78433], [-118.17425, 33.78433], [-118.17426, 33.78271], [-118.17515, 33.78271]]]} | Open Access 1 | 6588 | Douglas MacArthur Park | 18245 | 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.648 | Douglas MacArthur 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 | |
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 | |
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 | |
977 | 977 | 976 | {"type": "Polygon", "coordinates": [[[-118.1256, 33.75282], [-118.12556, 33.75298], [-118.12512, 33.75279], [-118.1256, 33.75282], [-118.1256, 33.75282]]]} | Open Access 1 | 6656 | Treasure Island Park | 26519 | 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.102 | Treasure Island Park | 0 | Local Park 2 | 4 | |
981 | 981 | 980 | {"type": "Polygon", "coordinates": [[[-118.15763, 33.85724], [-118.15761, 33.85725], [-118.15761, 33.85746], [-118.15552, 33.85747], [-118.15552, 33.85685], [-118.1555, 33.85684], [-118.15551, 33.85637], [-118.15762, 33.85637], [-118.15763, 33.85724]]]} | Open Access 1 | 6678 | Davenport Park | 28713 | 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 | 5.858 | Davenport Park | 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 | |
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 | |
1124 | 1124 | 1123 | {"type": "Polygon", "coordinates": [[[-118.17408, 33.83155], [-118.17408, 33.83229], [-118.1721, 33.83229], [-118.1721, 33.83155], [-118.17408, 33.83155]]]} | Open Access 1 | 6590 | Somerset Park | 25602 | 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.726 | Somerset 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]);