units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by ACCESS_TYP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, 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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 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.181 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
11512 | 11512 | 11511 | {"type": "Polygon", "coordinates": [[[-118.0907, 33.82486], [-118.09069, 33.82685], [-118.09002, 33.82684], [-118.09001, 33.82754], [-118.08923, 33.8273], [-118.08925, 33.82484], [-118.0907, 33.82486]]]} | No Public Access 3 | 48217 | El Dorado East Regional Park | 32766 | 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 | 8.523 | El Dorado East RP | 0 | Local Park 2 | 4 | |
15401 | 15401 | 15400 | {"type": "MultiPolygon", "coordinates": [[[[-118.1485, 33.77888], [-118.14796, 33.77888], [-118.14599, 33.77761], [-118.14599, 33.77723], [-118.14605, 33.77723], [-118.14796, 33.77847], [-118.14797, 33.77854], [-118.1485, 33.77888]]], [[[-118.15014, 33.78025], [-118.14868, 33.77931], [-118.14828, 33.77905], [-118.1488, 33.77905], [-118.15013, 33.7799], [-118.15014, 33.78025]]]]} | No Public Access 3 | 46622 | Pacific Electric Greenbelt | 29943 | 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.703 | Pacific Electric Greenbelt | 0 | Local Recreation Area 3 | 4 | |
15407 | 15407 | 15406 | {"type": "MultiPolygon", "coordinates": [[[[-118.19258, 33.84372], [-118.18742, 33.84551], [-118.1873, 33.84546], [-118.18731, 33.84541], [-118.18836, 33.84504], [-118.18837, 33.84497], [-118.18857, 33.84497], [-118.18981, 33.84454], [-118.18982, 33.84458], [-118.19067, 33.84429], [-118.19068, 33.84423], [-118.19254, 33.8436], [-118.19258, 33.84372]]], [[[-118.19442, 33.8431], [-118.19291, 33.84361], [-118.19283, 33.84363], [-118.19279, 33.84352], [-118.194, 33.8431], [-118.19442, 33.8431]]]]} | No Public Access 3 | 46631 | Sleepy Hollow Greenbelt | 29956 | 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.297 | Sleepy Hollow Greenbelt | 0 | Local Recreation Area 3 | 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 | |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 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 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
5091 | 5091 | 5090 | {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13518, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13696, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} | Restricted Access 2 | 45923 | Recreation Park 18 Hole Golf Course | 33116 | 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 | 119.647 | Rec. Park 18 Hole GC | 0 | Local Recreation Area 3 | 4 | |
7283 | 7283 | 7282 | {"type": "MultiPolygon", "coordinates": [[[[-118.14175, 33.82338], [-118.13512, 33.82334], [-118.13509, 33.82283], [-118.13466, 33.82244], [-118.13408, 33.82244], [-118.13409, 33.81902], [-118.13416, 33.81896], [-118.13886, 33.81895], [-118.139, 33.81906], [-118.1391, 33.81948], [-118.13924, 33.81986], [-118.13935, 33.82009], [-118.13975, 33.82078], [-118.13995, 33.82107], [-118.14019, 33.82136], [-118.14125, 33.82253], [-118.14146, 33.82291], [-118.14163, 33.82315], [-118.14164, 33.82326], [-118.14169, 33.82326], [-118.14175, 33.82338]]], [[[-118.13891, 33.81857], [-118.13879, 33.81867], [-118.13416, 33.81868], [-118.1341, 33.81863], [-118.13413, 33.81186], [-118.13414, 33.81143], [-118.13419, 33.81124], [-118.1342, 33.81077], [-118.13422, 33.81074], [-118.13428, 33.81072], [-118.13441, 33.81072], [-118.13496, 33.81078], [-118.13539, 33.81088], [-118.13582, 33.81105], [-118.13625, 33.81129], [-118.13757, 33.81228], [-118.13794, 33.81248], [-118.13814, 33.81256], [-118.13848, 33.81267], [-118.1388, 33.81275], [-118.1389, 33.81284], [-118.1389, 33.81374], [-118.13894, 33.81402], [-118.13894, 33.81428], [-118.13895, 33.81713], [-118.13889, 33.81799], [-118.13889, 33.81832], [-118.13891, 33.81857]]]]} | Restricted Access 2 | 6575 | Skylinks Golf Course | 33018 | 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 | 152.018 | Skylinks GC | 0 | Local Recreation Area 3 | 4 | |
7308 | 7308 | 7307 | {"type": "Polygon", "coordinates": [[[-118.19678, 33.8389], [-118.19592, 33.84035], [-118.19458, 33.8398], [-118.1951, 33.83894], [-118.19568, 33.83917], [-118.19613, 33.8388], [-118.19607, 33.83861], [-118.19622, 33.83874], [-118.19634, 33.8388], [-118.19678, 33.8389]]]} | Restricted Access 2 | 6595 | Rancho Los Cerritos Historic Site | 32776 | 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.786 | Rancho Los Cerritos Historic Site | 0 | Local Historic or Cultural Area 19 | 4 | |
11515 | 11515 | 11514 | {"type": "Polygon", "coordinates": [[[-118.17797, 33.79308], [-118.17745, 33.79307], [-118.17745, 33.79266], [-118.17796, 33.79266], [-118.17797, 33.79275], [-118.17797, 33.79308]]]} | Restricted Access 2 | 48221 | Martin Luther King Jr. Park | 32772 | 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.547 | Martin Luther King Jr. Park | 0 | Local Park 2 | 4 | |
15096 | 15096 | 15095 | {"type": "MultiPolygon", "coordinates": [[[[-118.09888, 33.79874], [-118.09877, 33.79897], [-118.09852, 33.7992], [-118.09829, 33.79944], [-118.09804, 33.79961], [-118.0977, 33.79975], [-118.09743, 33.7998], [-118.09713, 33.7998], [-118.09686, 33.79988], [-118.09656, 33.80001], [-118.09637, 33.80014], [-118.09597, 33.80071], [-118.09587, 33.80097], [-118.0958, 33.80124], [-118.09568, 33.80195], [-118.09561, 33.80217], [-118.09551, 33.80237], [-118.09538, 33.80256], [-118.09473, 33.80327], [-118.09458, 33.80348], [-118.09451, 33.80361], [-118.09362, 33.80386], [-118.09289, 33.804], [-118.0921, 33.80403], [-118.09141, 33.804], [-118.09101, 33.79591], [-118.09679, 33.79593], [-118.09701, 33.7961], [-118.09718, 33.79627], [-118.09735, 33.79656], [-118.09753, 33.79691], [-118.09762, 33.79721], [-118.09817, 33.79721], [-118.09858, 33.79781], [-118.09869, 33.79802], [-118.09879, 33.7984], [-118.09886, 33.7985], [-118.09888, 33.79874]]], [[[-118.09543, 33.80984], [-118.09439, 33.81005], [-118.09343, 33.81003], [-118.0925, 33.81009], [-118.09177, 33.80986], [-118.0917, 33.80987], [-118.09143, 33.80443], [-118.0916, 33.80443], [-118.09162, 33.80455], [-118.09184, 33.80467], [-118.09209, 33.80476], [-118.09211, 33.8049], [-118.09249, 33.80501], [-118.09295, 33.8052], [-118.09376, 33.80564], [-118.09427, 33.80609], [-118.0948, 33.80682], [-118.09547, 33.8085], [-118.09543, 33.80984]]]]} | Restricted Access 2 | 45888 | El Dorado Park Golf Course | 33114 | 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.eldoradoparkgc.com/ | Los Angeles 6 | 154.986 | El Dorado Park GC | 0 | Local Recreation Area 3 | 4 |
15106 | 15106 | 15105 | {"type": "Polygon", "coordinates": [[[-118.19716, 33.76369], [-118.19705, 33.76402], [-118.19697, 33.76419], [-118.19684, 33.7644], [-118.19667, 33.76459], [-118.19658, 33.76458], [-118.19607, 33.76429], [-118.19559, 33.76406], [-118.19599, 33.76352], [-118.19603, 33.76342], [-118.19603, 33.76328], [-118.19614, 33.76327], [-118.19626, 33.76322], [-118.19631, 33.76322], [-118.19716, 33.76369]]]} | Restricted Access 2 | 45903 | Long Beach Aquarium of the Pacific | 28978 | 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.167 | Long Beach Aquarium of the Pacific | None 1314 | |||
15116 | 15116 | 15115 | {"type": "MultiPolygon", "coordinates": [[[[-118.13464, 33.77502], [-118.13454, 33.77499], [-118.1345, 33.77494], [-118.13435, 33.77491], [-118.13433, 33.77494], [-118.13425, 33.77511], [-118.13425, 33.77522], [-118.12861, 33.77521], [-118.12861, 33.77359], [-118.13185, 33.77359], [-118.13186, 33.77356], [-118.13486, 33.77356], [-118.13498, 33.77362], [-118.13501, 33.77369], [-118.13477, 33.7743], [-118.13469, 33.77462], [-118.13464, 33.77502]]], [[[-118.13709, 33.77258], [-118.13709, 33.77342], [-118.13548, 33.77344], [-118.13554, 33.77351], [-118.13295, 33.77351], [-118.13295, 33.77343], [-118.13291, 33.77343], [-118.13288, 33.77266], [-118.13278, 33.77231], [-118.13275, 33.77212], [-118.13276, 33.7719], [-118.1328, 33.7718], [-118.13288, 33.77168], [-118.13298, 33.77163], [-118.13306, 33.77162], [-118.13502, 33.77188], [-118.13513, 33.77204], [-118.13533, 33.77205], [-118.13573, 33.7722], [-118.1358, 33.77229], [-118.13586, 33.77253], [-118.13593, 33.77262], [-118.13602, 33.7727], [-118.13612, 33.77274], [-118.13623, 33.77276], [-118.13634, 33.77276], [-118.13644, 33.77273], [-118.13657, 33.77265], [-118.13666, 33.77253], [-118.13709, 33.77258]]]]} | Restricted Access 2 | 45922 | Recreation 9 Hole Golf Course | 33115 | 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.recpark9.com/ | Los Angeles 6 | 40.591 | Rec. 9 Hole GC | 0 | Local Recreation Area 3 | 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 | |
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 |
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]);