units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where LAYER = 14 and MNG_AG_TYP = 2 sorted by MNG_AGENCY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, PARK_URL, COUNTY, YR_EST, GAP_STS
MNG_AGENCY 21
- Bellflower, City of 6
- San Clemente, City of 4
- Irvine, City of 3
- San Jacinto, City of 2
- Chino, City of 2
- Paramount, City of 2
- West Hollywood, City of 2
- King City, City of 2
- San Diego, City of 1
- Downey, City of 1
- El Centro, City of 1
- Carlsbad, City of 1
- Rosemead, City of 1
- Monterey Park, City of 1
- Long Beach, City of 1
- Westlake Village, City of 1
- Santa Clarita, City of 1
- La Mirada, City of 1
- Avalon, City of 1
- South Gate, City of 1
- Menifee, City of 1
DES_TP 5
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16223 | 16223 | 16222 | {"type": "Polygon", "coordinates": [[[-117.02305, 32.58558], [-117.01876, 32.58555], [-117.01875, 32.58376], [-117.0148, 32.58373], [-117.01465, 32.58363], [-117.01447, 32.58354], [-117.01433, 32.57606], [-117.02242, 32.57628], [-117.0226, 32.57717], [-117.02239, 32.57718], [-117.02228, 32.57717], [-117.02221, 32.57699], [-117.02213, 32.57694], [-117.02176, 32.5769], [-117.02167, 32.57671], [-117.02153, 32.5766], [-117.02143, 32.57654], [-117.02118, 32.57659], [-117.02096, 32.57669], [-117.02085, 32.57684], [-117.02075, 32.57687], [-117.02063, 32.57685], [-117.02049, 32.57678], [-117.02041, 32.57685], [-117.02001, 32.57685], [-117.01955, 32.57696], [-117.01934, 32.57699], [-117.01923, 32.57693], [-117.01911, 32.57693], [-117.01877, 32.57699], [-117.01863, 32.57698], [-117.01838, 32.57678], [-117.01823, 32.57676], [-117.01815, 32.57677], [-117.01807, 32.57664], [-117.01786, 32.57655], [-117.01771, 32.57645], [-117.01764, 32.57652], [-117.01738, 32.57666], [-117.01729, 32.57688], [-117.01729, 32.57695], [-117.01734, 32.57704], [-117.01734, 32.57712], [-117.01724, 32.57724], [-117.01741, 32.57755], [-117.01742, 32.57766], [-117.01757, 32.57781], [-117.01759, 32.5779], [-117.01753, 32.57802], [-117.01754, 32.57808], [-117.01758, 32.57815], [-117.01753, 32.5783], [-117.01751, 32.57859], [-117.01752, 32.57881], [-117.01758, 32.579], [-117.01765, 32.57912], [-117.01759, 32.57929], [-117.0176, 32.57938], [-117.01768, 32.57961], [-117.01774, 32.57987], [-117.01776, 32.58027], [-117.01773, 32.58054], [-117.01774, 32.5806], [-117.01785, 32.58072], [-117.01788, 32.58097], [-117.01792, 32.58102], [-117.01836, 32.58133], [-117.01845, 32.58134], [-117.01871, 32.58129], [-117.01878, 32.58128], [-117.01886, 32.58129], [-117.01895, 32.58138], [-117.019, 32.58147], [-117.01903, 32.58159], [-117.01898, 32.58167], [-117.01891, 32.58169], [-117.01868, 32.58167], [-117.01861, 32.5817], [-117.01852, 32.58188], [-117.01845, 32.58196], [-117.0184, 32.58238], [-117.01849, 32.58265], [-117.01846, 32.58281], [-117.0184, 32.58286], [-117.01873, 32.58324], [-117.0189, 32.58348], [-117.01924, 32.58413], [-117.01932, 32.58433], [-117.01953, 32.58434], [-117.01997, 32.58424], [-117.02013, 32.58427], [-117.02021, 32.58425], [-117.02029, 32.58418], [-117.02055, 32.58382], [-117.02049, 32.58355], [-117.02039, 32.58323], [-117.02075, 32.58311], [-117.02081, 32.58306], [-117.02092, 32.58288], [-117.02094, 32.58281], [-117.02117, 32.58292], [-117.02149, 32.58274], [-117.0214, 32.58198], [-117.0211, 32.58161], [-117.02126, 32.58163], [-117.02136, 32.58158], [-117.02176, 32.58159], [-117.02191, 32.58155], [-117.0221, 32.58145], [-117.02217, 32.58145], [-117.02223, 32.58147], [-117.02224, 32.58151], [-117.0222, 32.58163], [-117.02222, 32.58164], [-117.02267, 32.5816], [-117.023, 32.58154], [-117.02305, 32.58379], [-117.02305, 32.58558]]]} | Open Access 1 | 44861 | Hidden Trails Open Space | 31665 | 6075 | Western Pacific Housing 1167 | Private 7 | Commercial 20 | Private 14 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 106.609 | Hidden Trails OS | 0 | Local Recreation Area 3 | 4 | ||
6938 | 6938 | 6937 | {"type": "Polygon", "coordinates": [[[-118.10543, 33.93264], [-118.10487, 33.93319], [-118.10081, 33.93783], [-118.10047, 33.93824], [-118.10017, 33.93865], [-118.09971, 33.93843], [-118.10032, 33.93761], [-118.10032, 33.93724], [-118.10116, 33.93525], [-118.10125, 33.93525], [-118.10344, 33.93344], [-118.10398, 33.93344], [-118.10463, 33.93269], [-118.105, 33.93223], [-118.10543, 33.93264]]]} | Open Access 1 | 5834 | Wilderness Park | 27512 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1088 | Downey, City of 80 | City 2 | City Agency 2 | Los Angeles 6 | 18.456 | Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
11408 | 11408 | 11407 | {"type": "Polygon", "coordinates": [[[-115.54531, 32.76157], [-115.5453, 32.76193], [-115.54472, 32.76194], [-115.54451, 32.76195], [-115.54426, 32.76202], [-115.54411, 32.76204], [-115.54368, 32.76207], [-115.54357, 32.76207], [-115.54356, 32.76168], [-115.54359, 32.76168], [-115.5436, 32.76165], [-115.54404, 32.76165], [-115.54459, 32.76156], [-115.54531, 32.76157]]]} | Open Access 1 | 48092 | Countryside Park | 32595 | 6122 | Pulte Home Corporation 976 | Private 7 | Commercial 20 | https://www.pulte.com/ | Private 14 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | Imperial 20 | 1.727 | Countryside Park | 2007 | Local Park 2 | 4 | |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 4 |
14346 | 14346 | 14345 | {"type": "Polygon", "coordinates": [[[-118.08266, 34.08809], [-118.08266, 34.08809], [-118.08238, 34.08853], [-118.08229, 34.08817], [-118.08227, 34.08805], [-118.08228, 34.08802], [-118.08232, 34.08799], [-118.08238, 34.08799], [-118.08266, 34.08809]]]} | Open Access 1 | 45594 | Guess Park | 29851 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.28 | Guess Park | 0 | Local Park 2 | 4 | |
10847 | 10847 | 10846 | {"type": "Polygon", "coordinates": [[[-118.12837, 34.0455], [-118.12829, 34.04553], [-118.12817, 34.04553], [-118.12743, 34.04535], [-118.1272, 34.04532], [-118.11801, 34.04309], [-118.11799, 34.04277], [-118.11801, 34.04266], [-118.12629, 34.04467], [-118.12828, 34.0447], [-118.12838, 34.04547], [-118.12837, 34.0455]]]} | Open Access 1 | 20633 | Edison Trails Park | 18447 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1213 | Monterey Park, City of 130 | City 2 | City Agency 2 | Los Angeles 6 | 12.372 | Edison Trails Park | 0 | Local Park 2 | 4 | |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 0 | Local Park 2 | 4 |
10515 | 10515 | 10514 | {"type": "Polygon", "coordinates": [[[-117.63201, 33.95915], [-117.632, 33.95932], [-117.632, 33.95991], [-117.63149, 33.96007], [-117.6312, 33.95941], [-117.63201, 33.95915]]]} | Open Access 1 | 48706 | West Meridian Park | 33436 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 1.242 | West Meridian Park | 0 | Local Park 2 | 4 | |
10628 | 10628 | 10627 | {"type": "Polygon", "coordinates": [[[-117.62852, 33.961], [-117.62791, 33.96119], [-117.6279, 33.96039], [-117.62795, 33.96033], [-117.62821, 33.96032], [-117.62852, 33.961]]]} | Open Access 1 | 48707 | North Meridian Park | 33434 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | San Bernardino 22 | 0.926 | North Meridian Park | 0 | Local Park 2 | 4 | |
10887 | 10887 | 10886 | {"type": "Polygon", "coordinates": [[[-117.7503, 33.71658], [-117.74985, 33.71697], [-117.74946, 33.71734], [-117.74941, 33.71732], [-117.74938, 33.71735], [-117.74772, 33.71619], [-117.74855, 33.71536], [-117.7503, 33.71658]]]} | Open Access 1 | 48663 | Eastwood Neighborhood Park | 33410 | 6129 | Irvine Community Development Company LLC 961 | Private 7 | Commercial 20 | https://www.irvinecompany.com/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 6.129 | Eastwood Neighborhood Park | 0 | Local Park 2 | 4 | |
11154 | 11154 | 11153 | {"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]} | Open Access 1 | 48692 | Flagstone Park | 18936 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.248 | Flagstone Park | 0 | Local Park 2 | 4 | ||
11155 | 11155 | 11154 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | 48695 | Orchard Trail Park | 33407 | 6128 | Portola Springs Community Association 967 | Private 7 | Home Owners Association 16 | https://portolasprings.org/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.227 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
4756 | 4756 | 4755 | {"type": "Polygon", "coordinates": [[[-118.1743, 33.90349], [-118.17321, 33.9035], [-118.17318, 33.89977], [-118.17427, 33.89978], [-118.1743, 33.90349]]]} | No Public Access 3 | 46526 | Unnamed site - Paramount, City of | 29815 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | Los Angeles 6 | 10.254 | 0 | Local Other or Unknown 14 | 4 | ||
13127 | 13127 | 13126 | {"type": "Polygon", "coordinates": [[[-118.17428, 33.89646], [-118.17425, 33.89715], [-118.17427, 33.89978], [-118.17318, 33.89977], [-118.17316, 33.89651], [-118.17318, 33.89648], [-118.17322, 33.89647], [-118.17428, 33.89646]]]} | Open Access 1 | 45069 | Salud Park | 29814 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1245 | Paramount, City of 281 | City 2 | City Agency 2 | http://www.paramountcity.com/parks.cfm?task=detail&ID=10 | Los Angeles 6 | 9.17 | Salud Park | 0 | Local Park 2 | 4 |
15399 | 15399 | 15398 | {"type": "Polygon", "coordinates": [[[-118.18285, 33.87975], [-118.18285, 33.88002], [-118.18185, 33.88002], [-118.18185, 33.87975], [-118.18285, 33.87975]]]} | Open Access 1 | 46616 | North Community Gardens | 29930 | 6073 | Southern California Edison 655 | Private 7 | Utility 21 | https://www.sce.com | Private 14 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.68 | North Community Gardens | 0 | Local Park 2 | 4 | |
15241 | 15241 | 15240 | {"type": "Polygon", "coordinates": [[[-118.80402, 34.15821], [-118.80393, 34.1583], [-118.80387, 34.15842], [-118.80381, 34.15871], [-118.80377, 34.15881], [-118.80366, 34.15893], [-118.8035, 34.15902], [-118.80338, 34.15904], [-118.80325, 34.15905], [-118.80295, 34.15896], [-118.80283, 34.15895], [-118.80265, 34.15898], [-118.80239, 34.1591], [-118.80168, 34.15911], [-118.80137, 34.15909], [-118.7998, 34.1592], [-118.79979, 34.15928], [-118.79974, 34.15937], [-118.79964, 34.15932], [-118.79925, 34.15923], [-118.79916, 34.15926], [-118.79903, 34.15945], [-118.79877, 34.15969], [-118.79873, 34.15978], [-118.79858, 34.15987], [-118.79858, 34.15971], [-118.79856, 34.15966], [-118.79855, 34.15954], [-118.7986, 34.15944], [-118.79863, 34.15932], [-118.79853, 34.15919], [-118.79848, 34.15905], [-118.79692, 34.15895], [-118.79668, 34.15897], [-118.79662, 34.15895], [-118.79661, 34.15783], [-118.79666, 34.15777], [-118.79677, 34.15778], [-118.79707, 34.15702], [-118.7976, 34.15723], [-118.79816, 34.1574], [-118.79873, 34.15752], [-118.79932, 34.15758], [-118.79972, 34.15759], [-118.80012, 34.15757], [-118.80379, 34.15729], [-118.80389, 34.15823], [-118.80402, 34.15821]]]} | Open Access 1 | 46239 | Westlake Village Community Park and YMCA | 29517 | 6100 | Westlake Canyon Oaks Homeowners Association 1143 | Private 7 | Home Owners Association 16 | http://westlakecanyonoakshoa.com/ | Private 14 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?NID=378 | Los Angeles 6 | 30.797 | Westlake Village Community Park and YMCA | None 1338 | ||
10862 | 10862 | 10861 | {"type": "Polygon", "coordinates": [[[-118.52166, 34.37788], [-118.52155, 34.37794], [-118.5216, 34.37802], [-118.52101, 34.37832], [-118.51896, 34.37592], [-118.51945, 34.37515], [-118.52016, 34.37582], [-118.52058, 34.37646], [-118.52104, 34.37623], [-118.52134, 34.37749], [-118.52166, 34.37788]]]} | Open Access 1 | 20660 | Creekview Park | 17788 | 6102 | The Master's College 959 | Private 7 | Education 35 | http://www.masters.edu/ | Private 14 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=411 | Los Angeles 6 | 8.223 | Creekview Park | 0 | Local Park 2 | 4 |
15317 | 15317 | 15316 | {"type": "Polygon", "coordinates": [[[-118.01167, 33.9126], [-118.01104, 33.91346], [-118.01104, 33.91426], [-118.01127, 33.91427], [-118.01118, 33.91432], [-118.01101, 33.91431], [-118.01083, 33.91482], [-118.00994, 33.91503], [-118.01023, 33.91471], [-118.01004, 33.91464], [-118.01004, 33.91461], [-118.01024, 33.91467], [-118.01043, 33.9143], [-118.0105, 33.91395], [-118.01056, 33.9133], [-118.01061, 33.91317], [-118.01081, 33.91298], [-118.01102, 33.91265], [-118.01073, 33.91253], [-118.01074, 33.9125], [-118.01102, 33.9126], [-118.01116, 33.91239], [-118.01149, 33.91179], [-118.01152, 33.91167], [-118.01166, 33.91167], [-118.01166, 33.912], [-118.01157, 33.9121], [-118.01157, 33.91245], [-118.01167, 33.91246], [-118.01167, 33.9126]]]} | Open Access 1 | 46499 | Oak Creek Park | 22960 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1158 | La Mirada, City of 323 | City 2 | City Agency 2 | Los Angeles 6 | 4.296 | Oak Creek Park | 0 | Local Park 2 | 4 | ||
15168 | 15168 | 15167 | {"type": "Polygon", "coordinates": [[[-118.32353, 33.34225], [-118.32381, 33.34224], [-118.32377, 33.34263], [-118.32321, 33.34256], [-118.32326, 33.34241], [-118.32332, 33.34234], [-118.32339, 33.34229], [-118.32353, 33.34225]]]} | Open Access 1 | 46018 | Avalon City Park | 29343 | 6013 | Northwood II Community Association 1139 | Private 7 | Home Owners Association 16 | Private 14 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | Los Angeles 6 | 0.445 | Avalon City 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]);