units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
116 rows where DES_TP = 3 and MNG_AGENCY = 24 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL
ACCESS_TYP 3
- Open Access 105
- Restricted Access 10
- No Public Access 1
MNG_AG_TYP 1
- City Agency 116
MNG_AGENCY 1
- Los Angeles, City of · 116 ✖
DES_TP 1
- Local Recreation Area · 116 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9190 | 9190 | 9189 | {"type": "Polygon", "coordinates": [[[-118.65865, 34.19869], [-118.65863, 34.19874], [-118.6586, 34.19985], [-118.65857, 34.20027], [-118.65854, 34.20034], [-118.65848, 34.20039], [-118.6584, 34.20041], [-118.65724, 34.2004], [-118.6572, 34.20039], [-118.65718, 34.20033], [-118.65721, 34.20009], [-118.65719, 34.19995], [-118.65714, 34.1998], [-118.65703, 34.19962], [-118.65699, 34.19959], [-118.65703, 34.19953], [-118.65687, 34.1993], [-118.65676, 34.19918], [-118.65661, 34.19907], [-118.6565, 34.19905], [-118.65678, 34.19675], [-118.65847, 34.19676], [-118.65848, 34.19859], [-118.65865, 34.19869]]]} | Open Access 1 | 15245 | West Hills Recreation Center | 27360 | 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 | 16.146 | West Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
6674 | 6674 | 6673 | {"type": "Polygon", "coordinates": [[[-118.64797, 34.19522], [-118.64792, 34.19556], [-118.64772, 34.19554], [-118.64752, 34.19555], [-118.64721, 34.19561], [-118.64698, 34.19569], [-118.6464, 34.19595], [-118.64635, 34.19593], [-118.64625, 34.19573], [-118.64624, 34.19563], [-118.64627, 34.19542], [-118.64631, 34.19537], [-118.6464, 34.1953], [-118.64642, 34.19522], [-118.6464, 34.19518], [-118.64636, 34.19513], [-118.64629, 34.19511], [-118.64623, 34.19511], [-118.64624, 34.19507], [-118.64797, 34.19522]]]} | Open Access 1 | 4956 | Mae Boyar Recreation Center | 21665 | 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.247 | Mae Boyar Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16808 | 16808 | 16807 | {"type": "Polygon", "coordinates": [[[-118.61446, 34.17738], [-118.61023, 34.17739], [-118.61032, 34.17679], [-118.61033, 34.17586], [-118.61035, 34.17575], [-118.61046, 34.17557], [-118.61346, 34.17557], [-118.61355, 34.17563], [-118.61364, 34.17565], [-118.61441, 34.17565], [-118.61445, 34.1757], [-118.61446, 34.17738]]]} | Open Access 1 | 15474 | Woodland Hills Recreation Center | 30898 | 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 | http://www.laparks.org/dos/reccenter/facility/woodlandhillsrc.htm | Los Angeles 6 | 18.776 | Woodland Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
15672 | 15672 | 15671 | {"type": "Polygon", "coordinates": [[[-118.60581, 34.21744], [-118.60579, 34.21747], [-118.60575, 34.21749], [-118.60178, 34.21749], [-118.60174, 34.21744], [-118.60174, 34.21566], [-118.60179, 34.21562], [-118.60577, 34.21562], [-118.60581, 34.21566], [-118.60581, 34.21744]]]} | Open Access 1 | 3551 | Lanark Recreation Center | 28623 | 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 | http://www.laparks.org/dos/reccenter/facility/lanarkRC.htm | Los Angeles 6 | 19.128 | Lanark Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
7923 | 7923 | 7922 | {"type": "Polygon", "coordinates": [[[-118.57353, 34.20583], [-118.57249, 34.20583], [-118.57249, 34.20358], [-118.57353, 34.20357], [-118.57353, 34.20583]]]} | Open Access 1 | 10568 | Runnymede Recreation Center | 24730 | 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 | 5.932 | Runnymede Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
9283 | 9283 | 9282 | {"type": "Polygon", "coordinates": [[[-118.57323, 34.22459], [-118.57149, 34.22459], [-118.57148, 34.22451], [-118.57127, 34.22451], [-118.57122, 34.22448], [-118.5712, 34.22139], [-118.57323, 34.22139], [-118.57323, 34.22459]]]} | Open Access 1 | 15442 | Winnetka Recreation Center | 27649 | 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 | 16.272 | Winnetka Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
16377 | 16377 | 16376 | {"type": "Polygon", "coordinates": [[[-118.55137, 34.17571], [-118.55133, 34.17574], [-118.55025, 34.17574], [-118.55021, 34.17572], [-118.5502, 34.17561], [-118.5502, 34.17379], [-118.55129, 34.17388], [-118.55129, 34.17406], [-118.55137, 34.17418], [-118.55137, 34.17571]]]} | Open Access 1 | 14671 | Tarzana Recreation Center | 26192 | 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 | 5.57 | Tarzana Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
7017 | 7017 | 7016 | {"type": "Polygon", "coordinates": [[[-118.53593, 34.2532], [-118.53593, 34.25409], [-118.53391, 34.25409], [-118.53391, 34.25537], [-118.53112, 34.25537], [-118.53086, 34.25535], [-118.53057, 34.25529], [-118.53059, 34.25521], [-118.53164, 34.25372], [-118.53391, 34.25187], [-118.53391, 34.25274], [-118.53593, 34.25274], [-118.53593, 34.2532]]]} | Open Access 1 | 5968 | Northridge Recreation Center | 22889 | 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 | 24.037 | Northridge Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17060 | 17060 | 17059 | {"type": "Polygon", "coordinates": [[[-118.52603, 34.04074], [-118.52584, 34.04176], [-118.52566, 34.04209], [-118.52555, 34.04307], [-118.52552, 34.04343], [-118.52529, 34.04459], [-118.5251, 34.0447], [-118.52499, 34.04446], [-118.52465, 34.04399], [-118.52427, 34.04367], [-118.52438, 34.04357], [-118.52439, 34.04346], [-118.52438, 34.04335], [-118.52369, 34.04267], [-118.52353, 34.04227], [-118.52351, 34.04195], [-118.52352, 34.04162], [-118.52354, 34.04145], [-118.52382, 34.041], [-118.52333, 34.04086], [-118.52344, 34.04061], [-118.52411, 34.04083], [-118.52413, 34.04044], [-118.52444, 34.04055], [-118.52447, 34.03997], [-118.52501, 34.04047], [-118.52589, 34.04059], [-118.52603, 34.04074]]]} | Open Access 1 | 6339 | Palisades Park & Recreation Center | 28791 | 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 | http://www.laparks.org/dos/reccenter/facility/palisadesRC.htm | Los Angeles 6 | 17.543 | Palisades Park & Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
7197 | 7197 | 7196 | {"type": "Polygon", "coordinates": [[[-118.51623, 34.03753], [-118.51599, 34.03803], [-118.51574, 34.03794], [-118.51528, 34.03916], [-118.51467, 34.03952], [-118.5139, 34.03936], [-118.51386, 34.03879], [-118.51389, 34.03855], [-118.51395, 34.03841], [-118.51435, 34.03786], [-118.51479, 34.03721], [-118.51486, 34.03714], [-118.5149, 34.03715], [-118.51517, 34.03683], [-118.51521, 34.03683], [-118.51578, 34.0371], [-118.51591, 34.03714], [-118.51599, 34.03714], [-118.51578, 34.0374], [-118.51623, 34.03753]]]} | Open Access 1 | 6347 | Rustic Canyon Recreation Center | 24751 | 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 | 8.965 | Rustic Canyon Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1025 | 1025 | 1024 | {"type": "Polygon", "coordinates": [[[-118.51578, 34.0842], [-118.51146, 34.08421], [-118.51147, 34.09085], [-118.50449, 34.09085], [-118.50453, 34.09008], [-118.50471, 34.08963], [-118.50405, 34.08964], [-118.50409, 34.08955], [-118.50412, 34.08939], [-118.50407, 34.08868], [-118.50472, 34.08863], [-118.50465, 34.08784], [-118.50547, 34.08805], [-118.50717, 34.08751], [-118.50657, 34.08622], [-118.50536, 34.08626], [-118.50463, 34.08654], [-118.50437, 34.0852], [-118.5038, 34.08523], [-118.50381, 34.08485], [-118.50392, 34.08441], [-118.50394, 34.08426], [-118.50393, 34.08408], [-118.5039, 34.08389], [-118.50385, 34.08375], [-118.50376, 34.08357], [-118.50357, 34.08329], [-118.50339, 34.08277], [-118.50376, 34.08268], [-118.50477, 34.08284], [-118.50554, 34.08262], [-118.50551, 34.08319], [-118.50592, 34.0834], [-118.50612, 34.08372], [-118.50557, 34.08415], [-118.50566, 34.08513], [-118.50677, 34.08538], [-118.50793, 34.08535], [-118.50818, 34.08553], [-118.50951, 34.08542], [-118.50992, 34.08369], [-118.5094, 34.08289], [-118.51053, 34.08238], [-118.51101, 34.08205], [-118.51101, 34.08203], [-118.51067, 34.08178], [-118.51099, 34.08132], [-118.51205, 34.08078], [-118.51257, 34.08155], [-118.5157, 34.08409], [-118.51578, 34.0842]]]} | Open Access 1 | 6376 | Mandeville Open Space | 21742 | 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 | 134.869 | Mandeville OS | 0 | Local Recreation Area 3 | 4 | |
7169 | 7169 | 7168 | {"type": "Polygon", "coordinates": [[[-118.50409, 34.09527], [-118.5041, 34.09539], [-118.50408, 34.09553], [-118.50389, 34.09616], [-118.50387, 34.0965], [-118.50376, 34.0969], [-118.50375, 34.09712], [-118.50371, 34.09712], [-118.5037, 34.09707], [-118.50362, 34.09707], [-118.50363, 34.09692], [-118.50374, 34.09653], [-118.50377, 34.09614], [-118.50396, 34.09549], [-118.50397, 34.09527], [-118.50389, 34.09486], [-118.50364, 34.09423], [-118.50374, 34.09421], [-118.50392, 34.0946], [-118.50404, 34.09495], [-118.50409, 34.09527]]]} | Open Access 1 | 6383 | Mandeville Canyon Open Space | 21739 | 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.925 | Mandeville Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15051 | 15051 | 15050 | {"type": "Polygon", "coordinates": [[[-118.4995, 34.30582], [-118.49819, 34.30855], [-118.49804, 34.30878], [-118.49759, 34.30968], [-118.49608, 34.30917], [-118.49773, 34.30545], [-118.49787, 34.30539], [-118.49814, 34.30541], [-118.49852, 34.30548], [-118.4995, 34.30582]]]} | Restricted Access 2 | 45713 | Granada Hills Youth Recreation Center | 28880 | 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 | 18.213 | Granada Hills Youth Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15701 | 15701 | 15700 | {"type": "Polygon", "coordinates": [[[-118.4901, 34.19376], [-118.49007, 34.19379], [-118.48693, 34.19379], [-118.48692, 34.19036], [-118.48707, 34.19038], [-118.48713, 34.19038], [-118.4872, 34.19034], [-118.48722, 34.19027], [-118.48719, 34.19021], [-118.48713, 34.19017], [-118.48706, 34.19016], [-118.48692, 34.19019], [-118.48692, 34.18927], [-118.48706, 34.1893], [-118.48713, 34.18929], [-118.48719, 34.18925], [-118.48722, 34.18919], [-118.48719, 34.18912], [-118.48712, 34.18908], [-118.48683, 34.1891], [-118.48683, 34.18847], [-118.48697, 34.18851], [-118.48703, 34.18851], [-118.4871, 34.18846], [-118.48713, 34.18839], [-118.48709, 34.18832], [-118.48703, 34.18829], [-118.48696, 34.18829], [-118.48683, 34.18832], [-118.48683, 34.18769], [-118.48697, 34.18773], [-118.48704, 34.18772], [-118.4871, 34.18768], [-118.48713, 34.18761], [-118.4871, 34.18755], [-118.48702, 34.18751], [-118.48697, 34.18751], [-118.48683, 34.18754], [-118.48683, 34.18723], [-118.48687, 34.18724], [-118.4869, 34.18728], [-118.48696, 34.18728], [-118.48696, 34.18713], [-118.4869, 34.18712], [-118.48685, 34.18717], [-118.48675, 34.18717], [-118.48675, 34.18678], [-118.49004, 34.18677], [-118.49009, 34.1868], [-118.4901, 34.19376]]]} | Restricted Access 2 | 22010 | Van Nuys Golf Course | 33076 | 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 | http://lacity.org/ | Los Angeles 6 | 56.262 | Van Nuys GC | 0 | Local Recreation Area 3 | 4 |
14974 | 14974 | 14973 | {"type": "Polygon", "coordinates": [[[-118.48379, 34.2793], [-118.48373, 34.27953], [-118.48329, 34.27968], [-118.48303, 34.27981], [-118.48283, 34.27999], [-118.48249, 34.28041], [-118.48093, 34.28106], [-118.4807, 34.28096], [-118.48058, 34.28093], [-118.48006, 34.28092], [-118.47941, 34.28035], [-118.47984, 34.27954], [-118.48148, 34.27981], [-118.48148, 34.27956], [-118.48158, 34.27955], [-118.48157, 34.27929], [-118.48379, 34.2793]]]} | Open Access 1 | 45593 | Van Norman Lakes Reservoir | 28419 | 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 | http://www.laparks.org/dos/parks/facility/vanNorman.htm | Los Angeles 6 | 10.907 | Van Norman Lakes Reservoir | 0 | Local Recreation Area 3 | 4 |
2504 | 2504 | 2503 | {"type": "Polygon", "coordinates": [[[-118.4665, 34.00437], [-118.46104, 34.00726], [-118.46085, 34.00737], [-118.46087, 34.00741], [-118.45724, 34.00933], [-118.45601, 34.00775], [-118.4616, 34.00479], [-118.46148, 34.00472], [-118.46244, 34.00421], [-118.46252, 34.00428], [-118.46267, 34.00422], [-118.46531, 34.00282], [-118.4665, 34.00437]]]} | Restricted Access 2 | 6334 | Penmar Golf Course | 33009 | 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 | 52.132 | Penmar GC | 0 | Local Recreation Area 3 | 4 | |
3966 | 3966 | 3965 | {"type": "Polygon", "coordinates": [[[-118.46539, 33.99607], [-118.46473, 33.99643], [-118.46421, 33.99576], [-118.46399, 33.99551], [-118.46423, 33.99539], [-118.46427, 33.9954], [-118.4644, 33.99553], [-118.46442, 33.99553], [-118.46442, 33.99551], [-118.46429, 33.99538], [-118.46428, 33.99531], [-118.46421, 33.99531], [-118.46418, 33.99533], [-118.4642, 33.99537], [-118.46398, 33.99548], [-118.46333, 33.99472], [-118.46333, 33.99468], [-118.4636, 33.99429], [-118.46539, 33.99607]]]} | Open Access 1 | 6332 | Oakwood Recreation Center | 23039 | 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.555 | Oakwood Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
2505 | 2505 | 2504 | {"type": "Polygon", "coordinates": [[[-118.45939, 34.0057], [-118.45587, 34.00756], [-118.4551, 34.00656], [-118.45684, 34.00566], [-118.45688, 34.00569], [-118.45867, 34.00476], [-118.45939, 34.0057]]]} | Open Access 1 | 6335 | Penmar Recreation Center | 23586 | 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 | 12.17 | Penmar Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
15763 | 15763 | 15762 | {"type": "Polygon", "coordinates": [[[-118.45921, 34.22838], [-118.4592, 34.22853], [-118.45899, 34.22896], [-118.45897, 34.22905], [-118.45887, 34.22925], [-118.45887, 34.22928], [-118.45873, 34.2296], [-118.45864, 34.22988], [-118.45863, 34.23013], [-118.45886, 34.23125], [-118.45904, 34.23176], [-118.45757, 34.23175], [-118.45757, 34.22837], [-118.45921, 34.22838]]]} | Open Access 1 | 12262 | Sepulveda Recreation Center | 25307 | 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 | 10.944 | Sepulveda Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
17016 | 17016 | 17015 | {"type": "Polygon", "coordinates": [[[-118.4555, 34.03825], [-118.45376, 34.03929], [-118.45264, 34.03799], [-118.45438, 34.03695], [-118.4555, 34.03825]]]} | Open Access 1 | 14508 | Stoner Recreation Center | 25894 | 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 | 8.655 | Stoner Rec. Ctr. | 0 | Local Recreation Area 3 | 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]);