units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
115 rows where AGNCY_ID = 1188 and DES_TP = 3
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
- Open Access 104
- Restricted Access 10
- No Public Access 1
MNG_AG_TYP 1
- City Agency 115
MNG_AGENCY 1
DES_TP 1
- Local Recreation Area · 115 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
294 | 294 | 293 | {"type": "Polygon", "coordinates": [[[-118.36564, 34.02332], [-118.36557, 34.02447], [-118.36551, 34.02475], [-118.36542, 34.02503], [-118.36317, 34.02482], [-118.36308, 34.02548], [-118.3629, 34.02546], [-118.36318, 34.02338], [-118.36465, 34.02338], [-118.36466, 34.02331], [-118.36564, 34.02332]]]} | Open Access 1 | 788 | Baldwin Hills Recreation Center | 15776 | 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.253 | Baldwin Hills Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
917 | 917 | 916 | {"type": "Polygon", "coordinates": [[[-118.446, 34.13918], [-118.44599, 34.13919], [-118.44597, 34.13919], [-118.44542, 34.13894], [-118.44542, 34.13891], [-118.446, 34.13918]]]} | Open Access 1 | 6396 | Oak Forest West Access | 22965 | 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.044 | Oak Forest West Access | 0 | Local Recreation Area 3 | 4 | |
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | Open Access 1 | 6218 | 109th Street Recreation Center | 15168 | 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.184 | 109th Street Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1000 | 1000 | 999 | {"type": "Polygon", "coordinates": [[[-118.24176, 33.93869], [-118.24175, 33.93903], [-118.24158, 33.93902], [-118.24126, 33.93886], [-118.24127, 33.93867], [-118.24176, 33.93869]]]} | Open Access 1 | 6220 | Watts Towers Art Center | 27314 | 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.366 | Watts Towers Art 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 | |
1248 | 1248 | 1247 | {"type": "Polygon", "coordinates": [[[-118.33325, 34.04972], [-118.33236, 34.05184], [-118.33135, 34.05158], [-118.33231, 34.04955], [-118.33325, 34.04972]]]} | Open Access 1 | 9240 | Queen Anne Recreation Center | 24060 | 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.637 | Queen Anne Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
1306 | 1306 | 1305 | {"type": "Polygon", "coordinates": [[[-118.36933, 34.27138], [-118.36934, 34.27154], [-118.36933, 34.27158], [-118.36927, 34.27162], [-118.36916, 34.27167], [-118.36887, 34.27172], [-118.36875, 34.27177], [-118.36856, 34.2719], [-118.36845, 34.27199], [-118.36839, 34.27207], [-118.36834, 34.27218], [-118.36828, 34.2722], [-118.36823, 34.27225], [-118.3682, 34.27247], [-118.3682, 34.27267], [-118.36779, 34.27246], [-118.36555, 34.26923], [-118.36819, 34.269], [-118.36821, 34.26921], [-118.36828, 34.26945], [-118.36837, 34.2695], [-118.36848, 34.26953], [-118.36848, 34.26958], [-118.36851, 34.26964], [-118.36861, 34.26974], [-118.36871, 34.26981], [-118.36876, 34.26986], [-118.36881, 34.26999], [-118.36881, 34.2701], [-118.36878, 34.27038], [-118.36874, 34.27046], [-118.36868, 34.27055], [-118.36862, 34.27071], [-118.36862, 34.27081], [-118.36865, 34.27091], [-118.36873, 34.27105], [-118.3688, 34.27111], [-118.36919, 34.27127], [-118.36933, 34.27138]]]} | Open Access 1 | 7323 | Orcas Gabrieleno Equestrian Park | 30958 | 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 | 17.356 | Orcas Gabrieleno Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
1741 | 1741 | 1740 | {"type": "Polygon", "coordinates": [[[-118.31914, 33.98922], [-118.31914, 33.99022], [-118.31861, 33.9902], [-118.31861, 33.99043], [-118.31791, 33.99045], [-118.31788, 33.991], [-118.31761, 33.991], [-118.31761, 33.99029], [-118.31728, 33.99029], [-118.31736, 33.99], [-118.31754, 33.9896], [-118.31757, 33.98958], [-118.31756, 33.98956], [-118.31762, 33.98945], [-118.31762, 33.98921], [-118.31912, 33.9892], [-118.31914, 33.98922]]]} | Open Access 1 | 14970 | Van Ness Recreation Center | 26828 | 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.284 | Van Ness Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
2405 | 2405 | 2404 | {"type": "Polygon", "coordinates": [[[-118.40176, 34.26476], [-118.40163, 34.26535], [-118.40154, 34.26562], [-118.40143, 34.26588], [-118.40129, 34.26614], [-118.40113, 34.26638], [-118.40076, 34.26685], [-118.39988, 34.26605], [-118.39946, 34.26558], [-118.39897, 34.26483], [-118.39843, 34.26433], [-118.39782, 34.26399], [-118.39746, 34.26329], [-118.39631, 34.26249], [-118.3954, 34.26242], [-118.39351, 34.26158], [-118.39344, 34.2618], [-118.39335, 34.2618], [-118.39148, 34.26078], [-118.39103, 34.26066], [-118.39073, 34.26044], [-118.39031, 34.26113], [-118.38941, 34.26086], [-118.38925, 34.26121], [-118.38666, 34.26042], [-118.3866, 34.26035], [-118.38665, 34.259], [-118.38713, 34.25817], [-118.3865, 34.2579], [-118.38587, 34.25895], [-118.38448, 34.25843], [-118.38394, 34.2583], [-118.38325, 34.25843], [-118.38262, 34.25846], [-118.38042, 34.25817], [-118.37936, 34.25812], [-118.37816, 34.25822], [-118.37725, 34.25823], [-118.37614, 34.2584], [-118.37506, 34.25861], [-118.37403, 34.25861], [-118.37343, 34.25859], [-118.37384, 34.2578], [-118.37427, 34.25756], [-118.37765, 34.25587], [-118.37789, 34.25571], [-118.3781, 34.25552], [-118.37827, 34.25531], [-118.3784, 34.2551], [-118.38172, 34.25574], [-118.38181, 34.25558], [-118.38262, 34.25451], [-118.38266, 34.25435], [-118.38485, 34.25642], [-118.38492, 34.25637], [-118.39338, 34.25803], [-118.39555, 34.25899], [-118.39564, 34.25907], [-118.39587, 34.25891], [-118.39595, 34.25904], [-118.3961, 34.2592], [-118.39638, 34.25958], [-118.39669, 34.25992], [-118.40172, 34.26468], [-118.40173, 34.26475], [-118.40176, 34.26476]]]} | Restricted Access 2 | 45520 | Hansen Dam Golf Course | 28354 | 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://golf.lacity.org/cdp_hansen.htm | Los Angeles 6 | 201.493 | Hansen Dam GC | 0 | Local Recreation Area 3 | 4 |
2463 | 2463 | 2462 | {"type": "MultiPolygon", "coordinates": [[[[-118.22819, 34.08925], [-118.22809, 34.08934], [-118.22793, 34.08887], [-118.22784, 34.08827], [-118.22819, 34.08925]]], [[[-118.23294, 34.09403], [-118.23247, 34.09386], [-118.23207, 34.09369], [-118.23119, 34.09323], [-118.23099, 34.09309], [-118.23256, 34.09357], [-118.23294, 34.09403]]], [[[-118.23553, 34.09333], [-118.23444, 34.09357], [-118.23378, 34.09352], [-118.23237, 34.09303], [-118.23231, 34.09299], [-118.23267, 34.09268], [-118.23271, 34.09267], [-118.23301, 34.09306], [-118.23426, 34.09341], [-118.2343, 34.09339], [-118.23457, 34.09343], [-118.23478, 34.09325], [-118.23553, 34.09333]]], [[[-118.24204, 34.09967], [-118.24187, 34.10088], [-118.24184, 34.10257], [-118.24166, 34.1027], [-118.24174, 34.10063], [-118.24174, 34.10039], [-118.24168, 34.09999], [-118.24155, 34.09962], [-118.24136, 34.09925], [-118.23945, 34.09646], [-118.23918, 34.09615], [-118.23901, 34.09597], [-118.23888, 34.09585], [-118.2385, 34.09554], [-118.239, 34.09556], [-118.23905, 34.09571], [-118.23951, 34.0965], [-118.23984, 34.0964], [-118.24204, 34.09967]]], [[[-118.25126, 34.10836], [-118.25118, 34.10852], [-118.25082, 34.10839], [-118.25099, 34.10839], [-118.25126, 34.10836]]]]} | Open Access 1 | 12468 | Los Angeles River & Trail | 21499 | 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.217 | Los Angeles River & Trail | 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 | |
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 | |
2907 | 2907 | 2906 | {"type": "Polygon", "coordinates": [[[-118.2343, 34.11538], [-118.23311, 34.11682], [-118.23255, 34.1176], [-118.23164, 34.11715], [-118.23068, 34.11666], [-118.2302, 34.11658], [-118.23129, 34.11609], [-118.2325, 34.11535], [-118.23326, 34.1146], [-118.23381, 34.11501], [-118.23351, 34.11525], [-118.23351, 34.11526], [-118.23352, 34.11527], [-118.23383, 34.11503], [-118.2343, 34.11538]]]} | Open Access 1 | 1011 | Glassell Park and Recreation Center | 19309 | 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/glassellParkRC.htm | Los Angeles 6 | 12.663 | Glassell Park and Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
3181 | 3181 | 3180 | {"type": "Polygon", "coordinates": [[[-118.32975, 34.09132], [-118.32975, 34.09151], [-118.32899, 34.09152], [-118.32899, 34.09084], [-118.32975, 34.09084], [-118.32975, 34.09132]]]} | Open Access 1 | 1902 | Hollywood Recreation Center | 20054 | 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 | 1.295 | Hollywood Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3572 | 3572 | 3571 | {"type": "Polygon", "coordinates": [[[-118.4037, 34.2292], [-118.40363, 34.22925], [-118.40364, 34.22929], [-118.40362, 34.22931], [-118.40221, 34.23034], [-118.40077, 34.22897], [-118.40228, 34.22787], [-118.4037, 34.2292]]]} | Open Access 1 | 519 | Fernangeles Recreation Center | 18880 | 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 | 9.262 | Fernangeles Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
3865 | 3865 | 3864 | {"type": "Polygon", "coordinates": [[[-118.21168, 34.02172], [-118.21009, 34.02095], [-118.21048, 34.02035], [-118.21052, 34.02033], [-118.21056, 34.02033], [-118.21206, 34.02102], [-118.21206, 34.02108], [-118.21168, 34.02172]]]} | Open Access 1 | 45552 | Lou Costello Recreation Center | 28382 | 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/louCostelloRC.htm | Los Angeles 6 | 3.426 | Lou Costello Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
3902 | 3902 | 3901 | {"type": "MultiPolygon", "coordinates": [[[[-118.28275, 34.03276], [-118.28253, 34.0331], [-118.28239, 34.03304], [-118.28261, 34.03269], [-118.28275, 34.03276]]], [[[-118.28381, 34.033], [-118.28378, 34.03302], [-118.2827, 34.03255], [-118.28329, 34.0316], [-118.28337, 34.03159], [-118.28376, 34.03176], [-118.2838, 34.03182], [-118.28381, 34.033]]], [[[-118.2838, 34.03365], [-118.28341, 34.03348], [-118.28363, 34.03314], [-118.28377, 34.0332], [-118.2838, 34.03324], [-118.2838, 34.03365]]]]} | Open Access 1 | 1924 | Hoover Recreation Center | 20083 | 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.988 | Hoover Rec. Ctr. | 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 | |
4082 | 4082 | 4081 | {"type": "Polygon", "coordinates": [[[-118.30667, 33.98334], [-118.30667, 33.98455], [-118.30249, 33.98455], [-118.30251, 33.98333], [-118.30667, 33.98334]]]} | Open Access 1 | 1485 | Jackie Tatum/Harvard Recreation Center | 28621 | 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/jackieTatumRC.htm | Los Angeles 6 | 12.849 | Jackie Tatum/Harvard Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
4881 | 4881 | 4880 | {"type": "Polygon", "coordinates": [[[-118.37325, 34.18678], [-118.3732, 34.18941], [-118.37221, 34.18939], [-118.37225, 34.18676], [-118.37325, 34.18678]]]} | Open Access 1 | 15049 | Victory-Vineland Recreation Center | 27088 | 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 | 6.601 | Victory-Vineland 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]);