units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, AGNCY_TYP = 2, DES_TP = 3 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 3
ACCESS_TYP 1
- Open Access · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
915 | 915 | 914 | {"type": "Polygon", "coordinates": [[[-118.40367, 33.76579], [-118.40172, 33.76579], [-118.40068, 33.76532], [-118.39944, 33.76548], [-118.39872, 33.76598], [-118.39851, 33.76599], [-118.39825, 33.76503], [-118.39697, 33.76527], [-118.39672, 33.76521], [-118.39662, 33.76442], [-118.39672, 33.7636], [-118.39634, 33.76316], [-118.39614, 33.76316], [-118.39577, 33.763], [-118.39552, 33.76295], [-118.39505, 33.76295], [-118.39475, 33.76286], [-118.39404, 33.76306], [-118.39345, 33.76309], [-118.39242, 33.76276], [-118.39324, 33.76159], [-118.39353, 33.76173], [-118.39386, 33.76157], [-118.394, 33.76132], [-118.39421, 33.76139], [-118.39443, 33.76143], [-118.39466, 33.76145], [-118.39504, 33.76145], [-118.3948, 33.76184], [-118.39634, 33.76183], [-118.3969, 33.7623], [-118.40024, 33.76452], [-118.40197, 33.76451], [-118.40218, 33.76489], [-118.40367, 33.76508], [-118.40367, 33.76579]]]} | Open Access 1 | 5862 | Agua Armaga Canyon Open Space | 29504 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 40.343 | Agua Armaga Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7235 | 7235 | 7234 | {"type": "MultiPolygon", "coordinates": [[[[-117.9711, 33.97414], [-117.97033, 33.97501], [-117.96902, 33.97501], [-117.96879, 33.97516], [-117.96856, 33.97495], [-117.96849, 33.97498], [-117.96757, 33.9742], [-117.96722, 33.9738], [-117.96704, 33.97344], [-117.96865, 33.97343], [-117.9711, 33.97414]]], [[[-118.00131, 33.96455], [-118.00116, 33.96476], [-118.00086, 33.96505], [-118.00056, 33.96529], [-118.00022, 33.9656], [-117.99995, 33.96573], [-117.99909, 33.96585], [-117.99817, 33.96629], [-117.99774, 33.96624], [-117.99667, 33.96659], [-117.99639, 33.96663], [-117.99593, 33.96712], [-117.99495, 33.96767], [-117.9948, 33.96769], [-117.99422, 33.96798], [-117.99409, 33.96831], [-117.99383, 33.96841], [-117.99382, 33.96849], [-117.99213, 33.96952], [-117.99173, 33.9698], [-117.99137, 33.97011], [-117.98983, 33.97173], [-117.9895, 33.97202], [-117.98906, 33.97235], [-117.98858, 33.97265], [-117.98818, 33.97286], [-117.98643, 33.97368], [-117.98598, 33.9739], [-117.9854, 33.97424], [-117.98516, 33.9744], [-117.98477, 33.97468], [-117.98422, 33.97511], [-117.97765, 33.97509], [-117.97666, 33.97483], [-117.97664, 33.97254], [-117.97665, 33.96784], [-117.98953, 33.96796], [-117.98955, 33.96635], [-117.98955, 33.96502], [-117.98981, 33.96474], [-117.98999, 33.96459], [-117.99016, 33.96448], [-117.99378, 33.96454], [-118.00131, 33.96455]]]]} | Open Access 1 | 6520 | Arroyo San Miguel Open Space | 29672 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 320.047 | Arroyo San Miguel OS | 0 | Local Recreation Area 3 | 4 | |
10033 | 10033 | 10032 | {"type": "Polygon", "coordinates": [[[-118.99143, 34.15817], [-118.99103, 34.15857], [-118.99079, 34.15858], [-118.99057, 34.15855], [-118.99035, 34.15849], [-118.99016, 34.1584], [-118.98998, 34.15826], [-118.98983, 34.1581], [-118.98903, 34.15682], [-118.98894, 34.1567], [-118.98881, 34.15658], [-118.98867, 34.15647], [-118.98851, 34.15638], [-118.98833, 34.15631], [-118.98984, 34.15631], [-118.99122, 34.15735], [-118.99143, 34.15817]]]} | Open Access 1 | 49022 | Vista Del Mar Open Space | 33722 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/vista-del-mar.html | Ventura 8 | 8.702 | Vista Del Mar OS | 2008 | Local Recreation Area 3 | 4 |
11508 | 11508 | 11507 | {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} | Open Access 1 | 29555 | Quarry Lakes Regional Recreation Area | 30594 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 2.872 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
12698 | 12698 | 12697 | {"type": "Polygon", "coordinates": [[[-121.95077, 37.95279], [-121.95007, 37.95273], [-121.9498, 37.95293], [-121.94968, 37.95299], [-121.94964, 37.95296], [-121.94957, 37.95296], [-121.94953, 37.95299], [-121.94952, 37.95304], [-121.94946, 37.95305], [-121.94918, 37.95318], [-121.94896, 37.95334], [-121.94901, 37.9534], [-121.94851, 37.95368], [-121.94848, 37.95373], [-121.94844, 37.95374], [-121.94839, 37.95377], [-121.94838, 37.95381], [-121.94839, 37.95384], [-121.94847, 37.95388], [-121.94822, 37.95409], [-121.948, 37.95424], [-121.94764, 37.9547], [-121.94764, 37.95473], [-121.94759, 37.95474], [-121.94756, 37.95476], [-121.94755, 37.9548], [-121.94756, 37.95484], [-121.94751, 37.95485], [-121.94721, 37.95529], [-121.94707, 37.9552], [-121.94823, 37.95368], [-121.94871, 37.95332], [-121.94946, 37.95288], [-121.94984, 37.9527], [-121.95057, 37.95249], [-121.95071, 37.95267], [-121.95077, 37.95279]]]} | Open Access 1 | 46903 | Kirkwood Greenbelt | 30406 | 1066 | Concord, City of 391 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 2402 | Concord Landscaping and Lighting Maintenance District No. 3 994 | Special District 4 | Community Services District 17 | Contra Costa 12 | 1.931 | Kirkwood Greenbelt | 0 | Local Recreation Area 3 | 4 | |
14606 | 14606 | 14605 | {"type": "Polygon", "coordinates": [[[-116.24428, 33.71605], [-116.2439, 33.71605], [-116.24391, 33.71662], [-116.24374, 33.71699], [-116.24345, 33.71694], [-116.24285, 33.71694], [-116.24281, 33.7169], [-116.2428, 33.71491], [-116.24287, 33.71485], [-116.24418, 33.71485], [-116.24428, 33.71493], [-116.24428, 33.71605]]]} | Open Access 1 | 44817 | Indio Community Center & Park | 20215 | 1145 | Indio, City of 220 | City 2 | City Agency 2 | http://www.indio.org/index.aspx?page=90 | City 2 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 6.918 | Indio Community Ctr. & Park | 0 | Local Recreation Area 3 | 4 | |
15391 | 15391 | 15390 | {"type": "Polygon", "coordinates": [[[-118.96432, 34.19047], [-118.96431, 34.19886], [-118.95984, 34.19957], [-118.95976, 34.19948], [-118.95916, 34.19971], [-118.95836, 34.19959], [-118.95836, 34.19945], [-118.95848, 34.19888], [-118.95918, 34.19877], [-118.95999, 34.19653], [-118.96333, 34.19652], [-118.96333, 34.19525], [-118.96347, 34.19524], [-118.96347, 34.19389], [-118.96193, 34.19396], [-118.96116, 34.19173], [-118.96135, 34.19081], [-118.96021, 34.1908], [-118.96029, 34.19047], [-118.96432, 34.19047]]]} | Open Access 1 | 49021 | Vallecito Open Space | 33721 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/vallecito.html | Ventura 8 | 66.788 | Vallecito OS | 0 | Local Recreation Area 3 | 4 |
16057 | 16057 | 16056 | {"type": "Polygon", "coordinates": [[[-118.03735, 34.00383], [-118.02861, 34.00378], [-118.02862, 34.00033], [-118.03732, 34.00021], [-118.03737, 34.00312], [-118.03735, 34.00383]]]} | Open Access 1 | 6637 | Sycamore Canyon Open Space | 26116 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 78.242 | Sycamore Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16074 | 16074 | 16073 | {"type": "MultiPolygon", "coordinates": [[[[-118.7612, 34.15938], [-118.76095, 34.15967], [-118.76079, 34.15964], [-118.76019, 34.15956], [-118.76026, 34.15926], [-118.7602, 34.15894], [-118.75993, 34.15859], [-118.75947, 34.15828], [-118.7594, 34.1581], [-118.75933, 34.15771], [-118.75928, 34.15754], [-118.75913, 34.15724], [-118.7587, 34.1572], [-118.75815, 34.1572], [-118.75822, 34.15701], [-118.75818, 34.15698], [-118.75808, 34.15683], [-118.75806, 34.15666], [-118.75818, 34.15629], [-118.75888, 34.1563], [-118.75976, 34.15687], [-118.76107, 34.15873], [-118.7612, 34.15938]]], [[[-118.76954, 34.16551], [-118.76926, 34.16565], [-118.76899, 34.16554], [-118.76889, 34.16553], [-118.76868, 34.16556], [-118.76863, 34.16555], [-118.76848, 34.16557], [-118.76841, 34.16556], [-118.76817, 34.16586], [-118.76799, 34.16599], [-118.76781, 34.166], [-118.76685, 34.16618], [-118.76644, 34.16634], [-118.76606, 34.16631], [-118.76585, 34.1662], [-118.76521, 34.16592], [-118.76502, 34.16579], [-118.76443, 34.1657], [-118.76439, 34.16573], [-118.76408, 34.16558], [-118.76362, 34.16544], [-118.76321, 34.16525], [-118.76316, 34.16528], [-118.76309, 34.16546], [-118.76269, 34.16613], [-118.76236, 34.1664], [-118.76182, 34.16606], [-118.76212, 34.1658], [-118.76224, 34.16563], [-118.76245, 34.16527], [-118.76213, 34.16503], [-118.7621, 34.16502], [-118.7621, 34.16483], [-118.76209, 34.16468], [-118.76203, 34.16451], [-118.76189, 34.16429], [-118.7618, 34.16419], [-118.7613, 34.16381], [-118.76117, 34.16368], [-118.76108, 34.16358], [-118.76096, 34.16339], [-118.76085, 34.16318], [-118.7608, 34.16301], [-118.76076, 34.16283], [-118.76075, 34.16253], [-118.76082, 34.16216], [-118.76084, 34.16194], [-118.76082, 34.1617], [-118.76075, 34.16127], [-118.76061, 34.16085], [-118.76039, 34.16045], [-118.76026, 34.16029], [-118.7602, 34.16015], [-118.76017, 34.16006], [-118.76017, 34.15992], [-118.76019, 34.15978], [-118.76026, 34.15975], [-118.76079, 34.15982], [-118.76089, 34.15984], [-118.76091, 34.16037], [-118.76164, 34.16078], [-118.76173, 34.16089], [-118.76171, 34.16096], [-118.76177, 34.16102], [-118.76175, 34.16138], [-118.76183, 34.16158], [-118.7618, 34.16167], [-118.76162, 34.16197], [-118.76155, 34.16235], [-118.762, 34.16281], [-118.76257, 34.16261], [-118.76264, 34.16269], [-118.7627, 34.16271], [-118.7627, 34.16275], [-118.76321, 34.16279], [-118.76362, 34.16247], [-118.76366, 34.16279], [-118.76312, 34.16302], [-118.76311, 34.1631], [-118.76282, 34.16307], [-118.76254, 34.16309], [-118.76234, 34.16317], [-118.76219, 34.16331], [-118.76217, 34.16347], [-118.76232, 34.16356], [-118.76289, 34.1642], [-118.76304, 34.16427], [-118.76319, 34.16427], [-118.76332, 34.16425], [-118.76346, 34.16436], [-118.76389, 34.16474], [-118.76401, 34.16478], [-118.76428, 34.16508], [-118.76446, 34.16516], [-118.76463, 34.1652], [-118.76483, 34.1652], [-118.76513, 34.16517], [-118.76531, 34.16522], [-118.76542, 34.1653], [-118.7657, 34.16522], [-118.76613, 34.16548], [-118.76666, 34.16553], [-118.76692, 34.16544], [-118.76727, 34.16553], [-118.76754, 34.16553], [-118.76782, 34.16535], [-118.76801, 34.1651], [-118.76808, 34.16483], [-118.76809, 34.16455], [-118.76838, 34.16452], [-118.7687, 34.16432], [-118.7687, 34.16437], [-118.7688, 34.1644], [-118.76873, 34.16468], [-118.76869, 34.16477], [-118.76876, 34.16491], [-118.76893, 34.16506], [-118.7692, 34.16504], [-118.76954, 34.16551]]], [[[-118.76255, 34.1681], [-118.76176, 34.16809], [-118.76187, 34.16771], [-118.76174, 34.16744], [-118.7613, 34.16689], [-118.76124, 34.16679], [-118.76124, 34.16673], [-118.76128, 34.16655], [-118.76166, 34.16619], [-118.76187, 34.1663], [-118.76221, 34.16652], [-118.76196, 34.16673], [-118.76251, 34.16755], [-118.76248, 34.16781], [-118.76255, 34.1681]]]]} | Open Access 1 | 7085 | Medea Creek Open Space | 32643 | 1000 | Agoura Hills, City of 319 | City 2 | City Agency 2 | http://www.ci.agoura-hills.ca.us/government/departments/community-services-parks-recreation/parks-facilities | City 2 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 42.16 | Medea Creek OS | 0 | Local Recreation Area 3 | 4 | |
16107 | 16107 | 16106 | {"type": "Polygon", "coordinates": [[[-118.94813, 34.15608], [-118.94801, 34.15654], [-118.94796, 34.15651], [-118.94753, 34.15644], [-118.94739, 34.15666], [-118.94763, 34.15685], [-118.94757, 34.15709], [-118.94744, 34.15715], [-118.94721, 34.15691], [-118.94702, 34.15681], [-118.94667, 34.15716], [-118.9465, 34.15711], [-118.9464, 34.15718], [-118.94593, 34.15673], [-118.94618, 34.15659], [-118.94637, 34.15653], [-118.94677, 34.15651], [-118.94722, 34.15658], [-118.94733, 34.15638], [-118.94737, 34.15598], [-118.94755, 34.15596], [-118.94774, 34.15596], [-118.94792, 34.156], [-118.94813, 34.15608]]]} | Open Access 1 | 49018 | Deer Ridge Open Space | 33719 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/deer-ridge.html | Ventura 8 | 2.769 | Deer Ridge OS | 0 | Local Recreation Area 3 | 4 |
16114 | 16114 | 16113 | {"type": "Polygon", "coordinates": [[[-118.95456, 34.20563], [-118.947, 34.21744], [-118.94068, 34.21679], [-118.93523, 34.2145], [-118.93489, 34.21376], [-118.93554, 34.21268], [-118.93715, 34.21253], [-118.93816, 34.21187], [-118.93877, 34.21239], [-118.93943, 34.21233], [-118.93948, 34.21228], [-118.9399, 34.21229], [-118.94125, 34.21217], [-118.9419, 34.21156], [-118.9411, 34.21014], [-118.94059, 34.21007], [-118.9409, 34.2098], [-118.94046, 34.20903], [-118.93946, 34.20762], [-118.93858, 34.20769], [-118.93875, 34.20633], [-118.93701, 34.20526], [-118.93646, 34.2055], [-118.93639, 34.20488], [-118.93566, 34.205], [-118.93474, 34.20443], [-118.93467, 34.20405], [-118.93546, 34.20316], [-118.93678, 34.2034], [-118.93787, 34.20255], [-118.93816, 34.20153], [-118.93787, 34.20107], [-118.93714, 34.20139], [-118.93629, 34.20005], [-118.93492, 34.20012], [-118.93491, 34.19935], [-118.93556, 34.19889], [-118.93535, 34.19856], [-118.93347, 34.19823], [-118.93221, 34.19836], [-118.93293, 34.19684], [-118.93433, 34.19687], [-118.93434, 34.19708], [-118.9364, 34.19708], [-118.93639, 34.1979], [-118.93674, 34.1979], [-118.93696, 34.19814], [-118.93738, 34.19813], [-118.93739, 34.19708], [-118.93855, 34.19708], [-118.9387, 34.19763], [-118.93891, 34.19795], [-118.93868, 34.19814], [-118.93855, 34.19829], [-118.93854, 34.20564], [-118.95456, 34.20563]]]} | Open Access 1 | 49002 | Conejo Canyons Open Space | 30794 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/open-space.html | Ventura 8 | 410.746 | Conejo Canyons OS | 0 | Local Recreation Area 3 | 4 |
16250 | 16250 | 16249 | {"type": "MultiPolygon", "coordinates": [[[[-118.02166, 33.98258], [-118.02164, 33.98472], [-118.02155, 33.98495], [-118.02146, 33.98528], [-118.02144, 33.98551], [-118.02144, 33.9862], [-118.01986, 33.9862], [-118.01985, 33.98611], [-118.01979, 33.98612], [-118.01101, 33.98603], [-118.00665, 33.98603], [-118.00675, 33.9824], [-118.01005, 33.9824], [-118.01012, 33.9828], [-118.01098, 33.98353], [-118.01159, 33.98351], [-118.01238, 33.98365], [-118.0129, 33.98389], [-118.01333, 33.98402], [-118.01405, 33.98404], [-118.01558, 33.98377], [-118.01617, 33.98355], [-118.01673, 33.98326], [-118.01675, 33.98248], [-118.01995, 33.98253], [-118.02166, 33.98258]]], [[[-118.01715, 33.9762], [-118.01564, 33.97619], [-118.01564, 33.97895], [-118.01485, 33.97894], [-118.01267, 33.98045], [-118.01257, 33.98077], [-118.01258, 33.98078], [-118.0136, 33.98041], [-118.01366, 33.98041], [-118.01372, 33.98043], [-118.01376, 33.98046], [-118.01378, 33.98051], [-118.01378, 33.98057], [-118.01374, 33.98062], [-118.01311, 33.98104], [-118.01286, 33.98141], [-118.01115, 33.98075], [-118.01129, 33.97521], [-118.01714, 33.97529], [-118.01715, 33.9762]]]]} | Open Access 1 | 46387 | Worsham Canyon Open Space | 29670 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 173.721 | Worsham Canyon OS | 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]);