units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 204
- Los Angeles, City of 115
- San Francisco, City and County of 79
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- Las Virgenes Municipal Water District 28
- East Bay Regional Park District 27
- Long Beach, City of 25
- San Luis Obispo, City of 24
- Glendale, City of 24
- Davis, City of 23
- Santa Barbara, County of 19
- Santa Clarita, City of 18
- Sacramento, City of 18
- San Jose, City of 17
- Vacaville, City of 17
- Oakland, City of 16
- Thousand Oaks, City of 16
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Fullerton, City of 14
- Conejo Recreation and Park District 13
- San Bernardino, City of 13
- San Marcos, City of 13
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- …
MNG_AG_TYP 17
- City Agency 1,407
- Recreation/Parks District 159
- County Agency 116
- Open Space District 88
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 12
- School District 5
- County Agency - Other 4
- Port/Harbor District 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,603
- Restricted Access 218
- No Public Access 113
- Unknown Access 15
DES_TP 1
- Local Recreation Area · 1,949 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
567 | 567 | 566 | {"type": "Polygon", "coordinates": [[[-116.28545, 33.64926], [-116.27605, 33.6493], [-116.27598, 33.64886], [-116.27585, 33.64695], [-116.27557, 33.64484], [-116.27553, 33.64464], [-116.2754, 33.64431], [-116.27531, 33.64417], [-116.27517, 33.64399], [-116.2749, 33.64373], [-116.27445, 33.64342], [-116.27439, 33.64335], [-116.27436, 33.64326], [-116.27435, 33.64317], [-116.27438, 33.64308], [-116.27467, 33.64262], [-116.27478, 33.64236], [-116.27486, 33.64209], [-116.27489, 33.64208], [-116.27489, 33.64181], [-116.27485, 33.64155], [-116.27478, 33.64134], [-116.27444, 33.6407], [-116.27435, 33.64045], [-116.2741, 33.63907], [-116.27415, 33.63896], [-116.27423, 33.6389], [-116.27463, 33.63883], [-116.27495, 33.63873], [-116.27516, 33.63865], [-116.2755, 33.63848], [-116.2757, 33.63841], [-116.27604, 33.63834], [-116.27679, 33.6383], [-116.27679, 33.63793], [-116.27606, 33.63794], [-116.27575, 33.63799], [-116.27547, 33.63807], [-116.27523, 33.63815], [-116.27487, 33.63832], [-116.27471, 33.63838], [-116.27451, 33.63844], [-116.27408, 33.63852], [-116.27397, 33.63856], [-116.27385, 33.63862], [-116.27376, 33.6387], [-116.27369, 33.6388], [-116.27365, 33.63888], [-116.27322, 33.63867], [-116.273, 33.63852], [-116.27277, 33.63831], [-116.27259, 33.63807], [-116.27246, 33.63778], [-116.27241, 33.63747], [-116.27242, 33.63233], [-116.27236, 33.63209], [-116.27227, 33.63189], [-116.27213, 33.6317], [-116.27194, 33.63152], [-116.27176, 33.6314], [-116.27151, 33.63128], [-116.27134, 33.63123], [-116.27114, 33.6312], [-116.26991, 33.63119], [-116.26969, 33.63117], [-116.26945, 33.63112], [-116.2691, 33.63099], [-116.26892, 33.63089], [-116.26877, 33.63079], [-116.26854, 33.63057], [-116.26836, 33.63031], [-116.26811, 33.63031], [-116.26811, 33.62777], [-116.26796, 33.62763], [-116.26793, 33.62282], [-116.26835, 33.62284], [-116.26846, 33.62308], [-116.26867, 33.62343], [-116.26903, 33.62371], [-116.26946, 33.62391], [-116.27001, 33.62436], [-116.27227, 33.62528], [-116.27348, 33.62589], [-116.27578, 33.62758], [-116.28097, 33.62756], [-116.28101, 33.63121], [-116.28107, 33.64207], [-116.28542, 33.64205], [-116.28545, 33.64926]]]} | Open Access 1 | 3338 | Lake Cahuilla Recreation Area | 9500 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/parks/lake-cahuilla/lake-cahuilla-recreation-area-home/ | Riverside 10 | 566.48 | Lake Cahuilla Rec. Area | 0 | Local Recreation Area 3 | 4 |
568 | 568 | 567 | {"type": "Polygon", "coordinates": [[[-118.08621, 33.93879], [-118.08597, 33.93885], [-118.08499, 33.93885], [-118.08498, 33.93814], [-118.08454, 33.938], [-118.08408, 33.93774], [-118.08394, 33.93726], [-118.08284, 33.93741], [-118.08267, 33.93673], [-118.08267, 33.93658], [-118.08466, 33.93659], [-118.08465, 33.93544], [-118.08619, 33.93545], [-118.08621, 33.93879]]]} | Open Access 1 | 3354 | Lake Center Athletic Park | 20879 | 1321 | Santa Fe Springs, City of 211 | City 2 | City Agency 2 | http://www.santafesprings.org/cityhall/community_serv/parks/default.asp | City 2 | 1321 | Santa Fe Springs, City of 207 | City 2 | City Agency 2 | Los Angeles 6 | 17.226 | Lake Ctr. Athletic Park | 0 | Local Recreation Area 3 | 4 | |
574 | 574 | 573 | {"type": "Polygon", "coordinates": [[[-117.03531, 32.69994], [-117.03497, 32.70006], [-117.03488, 32.70023], [-117.03519, 32.70101], [-117.03496, 32.70097], [-117.03328, 32.701], [-117.03352, 32.70069], [-117.03386, 32.70047], [-117.03445, 32.70026], [-117.03443, 32.69981], [-117.03449, 32.69954], [-117.03449, 32.69929], [-117.03457, 32.69943], [-117.03467, 32.69969], [-117.03485, 32.69976], [-117.03517, 32.69966], [-117.03531, 32.69994]]]} | Open Access 1 | 1914 | South Bay Terraces Open Space | 25638 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.533 | South Bay Terraces OS | 0 | Local Recreation Area 3 | 4 | |
604 | 604 | 603 | {"type": "Polygon", "coordinates": [[[-117.28533, 33.07516], [-117.2853, 33.07521], [-117.28527, 33.07522], [-117.28497, 33.07519], [-117.28477, 33.07514], [-117.28457, 33.07503], [-117.28437, 33.07495], [-117.28396, 33.07485], [-117.28367, 33.07484], [-117.28329, 33.07488], [-117.28306, 33.07494], [-117.28302, 33.07497], [-117.28297, 33.07497], [-117.2828, 33.07505], [-117.28249, 33.07525], [-117.28238, 33.07536], [-117.28222, 33.07554], [-117.28212, 33.07569], [-117.28206, 33.07584], [-117.28172, 33.07682], [-117.28167, 33.07691], [-117.28158, 33.07705], [-117.28148, 33.07716], [-117.2814, 33.07724], [-117.28127, 33.07733], [-117.2805, 33.07234], [-117.28049, 33.07122], [-117.2805, 33.07054], [-117.28494, 33.07056], [-117.28494, 33.07238], [-117.28533, 33.07516]]]} | Open Access 1 | 2084 | Indian Head Canyon | 20201 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 55.677 | Indian Head Canyon | 0 | Local Recreation Area 3 | 4 | |
619 | 619 | 618 | {"type": "Polygon", "coordinates": [[[-117.07879, 34.21133], [-117.0785, 34.21198], [-117.07792, 34.2117], [-117.07815, 34.21121], [-117.07845, 34.2113], [-117.07848, 34.21124], [-117.07879, 34.21133]]]} | Open Access 1 | 2291 | Arrowbear Park Ball Field | 15606 | 2121 | Rim of the World Recreation and Park District 224 | Special District 4 | Recreation/Parks District 4 | http://www.rim-rec.org/ | Special District 4 | 2121 | Rim of the World Recreation and Park District 220 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.019 | Arrowbear Park Ball Field | 0 | Local Recreation Area 3 | 4 | |
627 | 627 | 626 | {"type": "Polygon", "coordinates": [[[-118.08436, 34.05755], [-118.08246, 34.05754], [-118.08245, 34.0555], [-118.08435, 34.05549], [-118.08436, 34.05755]]]} | Open Access 1 | 2445 | Jess Gonzales Sports Park | 20403 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 9.869 | Jess Gonzales Sports Park | 0 | Local Recreation Area 3 | 4 | |
671 | 671 | 670 | {"type": "Polygon", "coordinates": [[[-117.24681, 33.89806], [-117.24567, 33.89807], [-117.24568, 33.89692], [-117.24567, 33.89565], [-117.24678, 33.89563], [-117.24681, 33.89806]]]} | Open Access 1 | 5102 | March Field Park | 21792 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 6.91 | March Field Park | 0 | Local Recreation Area 3 | 4 | |
676 | 676 | 675 | {"type": "MultiPolygon", "coordinates": [[[[-117.13268, 33.04382], [-117.13241, 33.04442], [-117.1322, 33.04434], [-117.13203, 33.04454], [-117.13199, 33.04452], [-117.13148, 33.04487], [-117.13139, 33.04475], [-117.13113, 33.04487], [-117.13102, 33.0449], [-117.13102, 33.04538], [-117.13079, 33.0455], [-117.13057, 33.04567], [-117.13041, 33.04581], [-117.13026, 33.04601], [-117.13021, 33.04599], [-117.13013, 33.04604], [-117.13005, 33.04602], [-117.1299, 33.04621], [-117.12978, 33.04623], [-117.12952, 33.04635], [-117.12936, 33.04655], [-117.12901, 33.04663], [-117.12856, 33.0467], [-117.12837, 33.04678], [-117.12828, 33.04679], [-117.12773, 33.04681], [-117.12756, 33.04683], [-117.12736, 33.0469], [-117.12718, 33.04698], [-117.12704, 33.04706], [-117.12696, 33.04713], [-117.12684, 33.04728], [-117.12645, 33.04762], [-117.12639, 33.04764], [-117.12634, 33.04764], [-117.12597, 33.04752], [-117.12568, 33.04746], [-117.12558, 33.04746], [-117.12538, 33.0475], [-117.12518, 33.04761], [-117.12485, 33.04797], [-117.12454, 33.04839], [-117.1245, 33.04849], [-117.12447, 33.04865], [-117.12443, 33.0487], [-117.12437, 33.0487], [-117.12435, 33.04868], [-117.12419, 33.0485], [-117.12408, 33.04833], [-117.12402, 33.04827], [-117.12393, 33.04823], [-117.1238, 33.04818], [-117.12366, 33.04817], [-117.12357, 33.04819], [-117.12343, 33.04826], [-117.12329, 33.04842], [-117.12326, 33.04856], [-117.12326, 33.0487], [-117.12329, 33.04886], [-117.12339, 33.04911], [-117.12337, 33.04917], [-117.12326, 33.04929], [-117.12315, 33.04935], [-117.12271, 33.04954], [-117.12235, 33.04972], [-117.12217, 33.04988], [-117.12209, 33.05002], [-117.12195, 33.0504], [-117.1219, 33.05063], [-117.12186, 33.05083], [-117.12182, 33.05126], [-117.12175, 33.05139], [-117.12153, 33.0517], [-117.12146, 33.05184], [-117.12142, 33.05215], [-117.12134, 33.0524], [-117.12125, 33.05278], [-117.12118, 33.05304], [-117.12108, 33.05326], [-117.12065, 33.05398], [-117.12053, 33.05409], [-117.1204, 33.05414], [-117.11975, 33.05407], [-117.1194, 33.05406], [-117.1184, 33.05417], [-117.11837, 33.05417], [-117.11817, 33.05423], [-117.11807, 33.05428], [-117.11799, 33.05435], [-117.11791, 33.05444], [-117.11787, 33.05462], [-117.1179, 33.05482], [-117.11827, 33.05534], [-117.11834, 33.05549], [-117.11836, 33.05561], [-117.11834, 33.05566], [-117.11826, 33.05576], [-117.11781, 33.05594], [-117.11764, 33.05604], [-117.11754, 33.05624], [-117.11756, 33.05634], [-117.11762, 33.05647], [-117.11786, 33.05667], [-117.11794, 33.05677], [-117.11807, 33.05715], [-117.11813, 33.05727], [-117.11824, 33.0574], [-117.11837, 33.05752], [-117.11881, 33.05778], [-117.11891, 33.05789], [-117.11895, 33.05796], [-117.11899, 33.05803], [-117.119, 33.05812], [-117.11898, 33.05825], [-117.1189, 33.05837], [-117.11884, 33.05843], [-117.11859, 33.05859], [-117.11853, 33.05866], [-117.11845, 33.05878], [-117.11838, 33.05898], [-117.11838, 33.05904], [-117.11832, 33.05913], [-117.118, 33.06002], [-117.11799, 33.06014], [-117.11801, 33.06028], [-117.11805, 33.06045], [-117.1182, 33.06067], [-117.11837, 33.06081], [-117.11871, 33.061], [-117.11878, 33.06108], [-117.11881, 33.06116], [-117.11883, 33.06125], [-117.11883, 33.06134], [-117.11869, 33.06167], [-117.11867, 33.06188], [-117.11871, 33.06201], [-117.11882, 33.06216], [-117.11891, 33.06223], [-117.11911, 33.06235], [-117.11935, 33.06239], [-117.1199, 33.0624], [-117.11999, 33.06244], [-117.12004, 33.06252], [-117.12004, 33.06262], [-117.11926, 33.06391], [-117.1192, 33.06407], [-117.11919, 33.06422], [-117.11924, 33.06446], [-117.1193, 33.06457], [-117.11938, 33.06468], [-117.11952, 33.06478], [-117.11995, 33.06496], [-117.12007, 33.06506], [-117.12011, 33.06514], [-117.12013, 33.06521], [-117.12014, 33.06628], [-117.12013, 33.06637], [-117.12007, 33.06651], [-117.11954, 33.06723], [-117.11943, 33.06743], [-117.11854, 33.06991], [-117.11842, 33.07012], [-117.11822, 33.07043], [-117.11814, 33.07061], [-117.11809, 33.07075], [-117.11797, 33.07224], [-117.118, 33.07242], [-117.11816, 33.07275], [-117.11819, 33.07285], [-117.11816, 33.073], [-117.11798, 33.07342], [-117.11794, 33.07365], [-117.11795, 33.07379], [-117.1182, 33.07508], [-117.11822, 33.07535], [-117.11814, 33.07659], [-117.11811, 33.07674], [-117.11807, 33.07684], [-117.11788, 33.07718], [-117.11778, 33.07729], [-117.11762, 33.07741], [-117.11748, 33.07748], [-117.11626, 33.07787], [-117.11606, 33.07798], [-117.11591, 33.0781], [-117.11581, 33.07821], [-117.11545, 33.07875], [-117.11539, 33.07886], [-117.11536, 33.07904], [-117.1153, 33.07922], [-117.11519, 33.07944], [-117.11507, 33.07961], [-117.11497, 33.07955], [-117.11471, 33.07969], [-117.11457, 33.08006], [-117.11469, 33.08017], [-117.11465, 33.0803], [-117.11464, 33.08177], [-117.11467, 33.08201], [-117.11477, 33.08224], [-117.11479, 33.08226], [-117.1148, 33.08236], [-117.11475, 33.08252], [-117.11461, 33.08275], [-117.11456, 33.08291], [-117.11455, 33.083], [-117.11457, 33.08306], [-117.11463, 33.08393], [-117.11457, 33.08393], [-117.11457, 33.08403], [-117.11451, 33.08421], [-117.11449, 33.08434], [-117.11434, 33.08484], [-117.11431, 33.08503], [-117.11429, 33.08531], [-117.11434, 33.08556], [-117.11432, 33.08564], [-117.11432, 33.08579], [-117.1143, 33.08598], [-117.11417, 33.08671], [-117.11307, 33.08687], [-117.113, 33.0875], [-117.11051, 33.08748], [-117.11048, 33.08636], [-117.11047, 33.08471], [-117.11048, 33.08458], [-117.11046, 33.08388], [-117.10658, 33.08385], [-117.10621, 33.08339], [-117.10612, 33.08331], [-117.10518, 33.08224], [-117.10512, 33.08227], [-117.10479, 33.08185], [-117.10536, 33.07954], [-117.10657, 33.07427], [-117.10663, 33.07423], [-117.10596, 33.07399], [-117.10564, 33.07142], [-117.10372, 33.07008], [-117.1036, 33.07008], [-117.10341, 33.06992], [-117.10324, 33.06971], [-117.10304, 33.06959], [-117.10271, 33.06959], [-117.10205, 33.06942], [-117.10143, 33.06894], [-117.10116, 33.06895], [-117.10126, 33.06885], [-117.1013, 33.06878], [-117.10108, 33.06857], [-117.10089, 33.06855], [-117.1008, 33.06849], [-117.10073, 33.06823], [-117.10036, 33.06808], [-117.10014, 33.06824], [-117.10006, 33.06813], [-117.10007, 33.0681], [-117.10003, 33.06789], [-117.09995, 33.06782], [-117.09978, 33.06779], [-117.0997, 33.06775], [-117.09966, 33.06771], [-117.09942, 33.06765], [-117.09911, 33.0676], [-117.09888, 33.0676], [-117.09871, 33.06763], [-117.09868, 33.06761], [-117.0987, 33.06753], [-117.09869, 33.06746], [-117.09867, 33.06742], [-117.09859, 33.06734], [-117.09863, 33.06733], [-117.09872, 33.06737], [-117.09881, 33.06738], [-117.09894, 33.06734], [-117.09902, 33.0673], [-117.09906, 33.06724], [-117.09908, 33.06717], [-117.09908, 33.06711], [-117.09881, 33.06652], [-117.0988, 33.06612], [-117.09888, 33.06592], [-117.09887, 33.06566], [-117.0988, 33.06542], [-117.09876, 33.06536], [-117.09873, 33.06524], [-117.09869, 33.0652], [-117.09863, 33.06508], [-117.09863, 33.06495], [-117.09861, 33.06482], [-117.09858, 33.06472], [-117.0985, 33.06459], [-117.09842, 33.0645], [-117.0982, 33.06433], [-117.09805, 33.06426], [-117.09787, 33.06421], [-117.09758, 33.06421], [-117.09738, 33.06428], [-117.09726, 33.06436], [-117.09721, 33.06435], [-117.09731, 33.06392], [-117.09732, 33.06385], [-117.0973, 33.06383], [-117.09731, 33.0638], [-117.0973, 33.06374], [-117.09728, 33.06367], [-117.09721, 33.06357], [-117.09697, 33.06341], [-117.09651, 33.06334], [-117.09621, 33.06337], [-117.09593, 33.06338], [-117.09559, 33.06346], [-117.09516, 33.06349], [-117.09494, 33.06356], [-117.09478, 33.06366], [-117.09474, 33.06366], [-117.09472, 33.06364], [-117.09478, 33.06355], [-117.09479, 33.0635], [-117.09476, 33.06346], [-117.09467, 33.06342], [-117.09466, 33.06339], [-117.09469, 33.06337], [-117.09488, 33.06337], [-117.09503, 33.06331], [-117.09522, 33.06312], [-117.09531, 33.06299], [-117.09535, 33.06283], [-117.09535, 33.06269], [-117.09547, 33.06251], [-117.09549, 33.06242], [-117.09548, 33.06228], [-117.09538, 33.06216], [-117.09537, 33.0621], [-117.09538, 33.06199], [-117.09542, 33.06191], [-117.09547, 33.06184], [-117.09563, 33.06174], [-117.09572, 33.06163], [-117.09574, 33.06156], [-117.09575, 33.06149], [-117.09569, 33.06139], [-117.09559, 33.06127], [-117.09544, 33.06116], [-117.09532, 33.06111], [-117.09508, 33.06103], [-117.09456, 33.06074], [-117.09428, 33.06063], [-117.09379, 33.06047], [-117.09288, 33.06008], [-117.09286, 33.06009], [-117.09286, 33.06032], [-117.09274, 33.06028], [-117.0926, 33.06017], [-117.09239, 33.06006], [-117.09228, 33.05987], [-117.09213, 33.05976], [-117.09201, 33.05974], [-117.09184, 33.05974], [-117.09164, 33.05978], [-117.09168, 33.05958], [-117.09174, 33.05947], [-117.09172, 33.05933], [-117.09166, 33.0592], [-117.09135, 33.05904], [-117.09121, 33.05888], [-117.09103, 33.05874], [-117.09084, 33.05853], [-117.09061, 33.05832], [-117.09039, 33.058], [-117.09025, 33.05791], [-117.08988, 33.05787], [-117.08965, 33.0578], [-117.08852, 33.05762], [-117.0884, 33.05745], [-117.08825, 33.05736], [-117.08816, 33.05731], [-117.08804, 33.05729], [-117.08783, 33.05729], [-117.08773, 33.05731], [-117.08767, 33.05738], [-117.0876, 33.05758], [-117.08761, 33.0577], [-117.08767, 33.05785], [-117.08713, 33.058], [-117.08569, 33.05861], [-117.08499, 33.05989], [-117.08444, 33.06032], [-117.08432, 33.06043], [-117.08427, 33.06051], [-117.08387, 33.06082], [-117.08379, 33.06096], [-117.08378, 33.06105], [-117.08385, 33.06118], [-117.08376, 33.06128], [-117.08367, 33.0615], [-117.08335, 33.0619], [-117.08304, 33.06214], [-117.08256, 33.06263], [-117.08251, 33.06298], [-117.08242, 33.06312], [-117.0824, 33.06322], [-117.08246, 33.06348], [-117.08265, 33.06372], [-117.08265, 33.06402], [-117.08259, 33.06429], [-117.0825, 33.06439], [-117.08257, 33.06486], [-117.08253, 33.06494], [-117.08234, 33.0666], [-117.08234, 33.06622], [-117.08219, 33.06598], [-117.08207, 33.06589], [-117.08202, 33.06553], [-117.0816, 33.06539], [-117.08203, 33.06463], [-117.08189, 33.06454], [-117.08154, 33.06449], [-117.08149, 33.0644], [-117.08135, 33.06431], [-117.08112, 33.06425], [-117.08088, 33.06427], [-117.08064, 33.06414], [-117.08056, 33.06417], [-117.08056, 33.06409], [-117.08037, 33.06399], [-117.08016, 33.06407], [-117.07998, 33.06409], [-117.07985, 33.06416], [-117.0796, 33.06394], [-117.0795, 33.06388], [-117.07932, 33.06388], [-117.07931, 33.06362], [-117.07874, 33.06369], [-117.07909, 33.06342], [-117.07924, 33.06317], [-117.07915, 33.06298], [-117.0789, 33.06258], [-117.07886, 33.06228], [-117.07835, 33.06191], [-117.07819, 33.06184], [-117.07778, 33.06191], [-117.07804, 33.0616], [-117.07805, 33.06126], [-117.07803, 33.06081], [-117.07798, 33.06069], [-117.07766, 33.06059], [-117.0771, 33.06083], [-117.07684, 33.061], [-117.07674, 33.061], [-117.07665, 33.06106], [-117.07663, 33.06091], [-117.0765, 33.06083], [-117.07639, 33.06082], [-117.07631, 33.06075], [-117.07599, 33.06071], [-117.07576, 33.06059], [-117.07556, 33.06063], [-117.07549, 33.06056], [-117.07508, 33.06044], [-117.07485, 33.06045], [-117.07452, 33.06041], [-117.07416, 33.06044], [-117.0739, 33.06049], [-117.07371, 33.06057], [-117.07356, 33.06059], [-117.07326, 33.06068], [-117.07297, 33.06106], [-117.07294, 33.06119], [-117.07293, 33.06133], [-117.07282, 33.06136], [-117.0727, 33.06156], [-117.07276, 33.06197], [-117.07263, 33.06189], [-117.0722, 33.06186], [-117.07201, 33.0619], [-117.07145, 33.06184], [-117.07124, 33.06186], [-117.071, 33.06195], [-117.07073, 33.06224], [-117.07058, 33.06236], [-117.07053, 33.06247], [-117.07045, 33.06248], [-117.06984, 33.06278], [-117.06962, 33.06201], [-117.06976, 33.06174], [-117.07007, 33.06157], [-117.06989, 33.06123], [-117.07161, 33.05693], [-117.07174, 33.05675], [-117.07189, 33.05658], [-117.07198, 33.05651], [-117.07229, 33.05634], [-117.07244, 33.05628], [-117.07286, 33.05618], [-117.07316, 33.05609], [-117.07378, 33.05585], [-117.07431, 33.05562], [-117.07428, 33.05548], [-117.07454, 33.05531], [-117.07469, 33.05518], [-117.07497, 33.05489], [-117.0751, 33.05473], [-117.07609, 33.05336], [-117.07628, 33.05301], [-117.07637, 33.0528], [-117.07642, 33.05262], [-117.07648, 33.05227], [-117.07649, 33.05201], [-117.07644, 33.05164], [-117.07638, 33.05141], [-117.07623, 33.05103], [-117.07602, 33.05071], [-117.07575, 33.05041], [-117.07613, 33.04995], [-117.07686, 33.04884], [-117.07733, 33.04853], [-117.07744, 33.04827], [-117.0777, 33.04805], [-117.07778, 33.0469], [-117.07765, 33.04667], [-117.07681, 33.04619], [-117.07646, 33.04577], [-117.07581, 33.04506], [-117.07512, 33.04473], [-117.07454, 33.04485], [-117.07742, 33.04195], [-117.07767, 33.04165], [-117.07786, 33.04135], [-117.07859, 33.04164], [-117.07894, 33.04181], [-117.07964, 33.04197], [-117.07989, 33.04198], [-117.08023, 33.04196], [-117.08024, 33.04211], [-117.08027, 33.04224], [-117.08016, 33.04246], [-117.07979, 33.04262], [-117.07963, 33.04286], [-117.07966, 33.04329], [-117.07974, 33.04342], [-117.08846, 33.0445], [-117.09088, 33.04481], [-117.091, 33.04484], [-117.09044, 33.04709], [-117.09043, 33.04721], [-117.0904, 33.04726], [-117.08991, 33.04926], [-117.09485, 33.05503], [-117.1018, 33.05914], [-117.11033, 33.05917], [-117.11402, 33.04382], [-117.12244, 33.04384], [-117.13268, 33.04382]], [[-117.10946, 33.08122], [-117.10947, 33.08171], [-117.11043, 33.08171], [-117.11043, 33.08038], [-117.10945, 33.0804], [-117.10947, 33.08118], [-117.10946, 33.08122]]], [[[-117.12306, 33.04975], [-117.12293, 33.04986], [-117.12272, 33.05008], [-117.12257, 33.0503], [-117.12241, 33.05064], [-117.12235, 33.05083], [-117.12223, 33.05083], [-117.12208, 33.05144], [-117.122, 33.05185], [-117.12211, 33.05188], [-117.12205, 33.05215], [-117.12184, 33.05312], [-117.12173, 33.05311], [-117.12164, 33.05351], [-117.12168, 33.05352], [-117.12166, 33.05366], [-117.12166, 33.05397], [-117.12173, 33.05398], [-117.12179, 33.05436], [-117.12168, 33.05439], [-117.12175, 33.0546], [-117.12183, 33.05481], [-117.11808, 33.05481], [-117.11805, 33.05475], [-117.11804, 33.05468], [-117.11804, 33.05457], [-117.11806, 33.05452], [-117.11809, 33.05446], [-117.11815, 33.0544], [-117.11827, 33.05434], [-117.11882, 33.05425], [-117.11941, 33.05419], [-117.1197, 33.0542], [-117.12044, 33.05427], [-117.1206, 33.05422], [-117.1208, 33.05405], [-117.12124, 33.0533], [-117.12135, 33.05305], [-117.12147, 33.05256], [-117.12148, 33.05249], [-117.12157, 33.05221], [-117.12161, 33.05189], [-117.12168, 33.05175], [-117.12181, 33.0516], [-117.12187, 33.0515], [-117.12198, 33.05128], [-117.122, 33.0512], [-117.12203, 33.05083], [-117.1221, 33.05043], [-117.12225, 33.05005], [-117.12231, 33.04995], [-117.12244, 33.04984], [-117.12291, 33.04962], [-117.12306, 33.04975]]], [[[-117.12652, 33.04775], [-117.12629, 33.04798], [-117.12642, 33.04812], [-117.1259, 33.04856], [-117.12571, 33.04868], [-117.12557, 33.04854], [-117.12516, 33.04876], [-117.12468, 33.04887], [-117.12472, 33.04911], [-117.12407, 33.04926], [-117.124, 33.04904], [-117.1236, 33.04915], [-117.12352, 33.04901], [-117.12343, 33.04875], [-117.12342, 33.04859], [-117.12346, 33.04845], [-117.12352, 33.04838], [-117.12359, 33.04833], [-117.12366, 33.04832], [-117.12376, 33.04832], [-117.12388, 33.04835], [-117.12393, 33.0484], [-117.12411, 33.04863], [-117.12429, 33.04882], [-117.12435, 33.04884], [-117.12447, 33.04884], [-117.12454, 33.04879], [-117.12461, 33.04872], [-117.12464, 33.04865], [-117.12469, 33.04843], [-117.12492, 33.04813], [-117.12526, 33.04775], [-117.12538, 33.04766], [-117.12552, 33.04761], [-117.12568, 33.0476], [-117.12595, 33.04766], [-117.12631, 33.04777], [-117.12642, 33.04778], [-117.12652, 33.04775]]], [[[-117.12933, 33.04672], [-117.12906, 33.04683], [-117.1279, 33.04711], [-117.12762, 33.04723], [-117.12739, 33.04735], [-117.12721, 33.04748], [-117.12681, 33.0475], [-117.12695, 33.04739], [-117.12717, 33.04715], [-117.12727, 33.04708], [-117.12756, 33.04698], [-117.12781, 33.04693], [-117.12815, 33.04695], [-117.12826, 33.04694], [-117.12842, 33.0469], [-117.12857, 33.04684], [-117.12933, 33.04672]]], [[[-117.12985, 33.04642], [-117.12977, 33.04649], [-117.12959, 33.04659], [-117.12959, 33.04653], [-117.12967, 33.04644], [-117.12978, 33.04642], [-117.12985, 33.04642]]]]} | Open Access 1 | 3408 | Hodges Reservoir | 29224 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/water/recreation/reservoirs/hodges.shtml | San Diego 4 | 2271.486 | Hodges Reservoir | 0 | Local Recreation Area 3 | 4 |
717 | 717 | 716 | {"type": "Polygon", "coordinates": [[[-117.92419, 33.88391], [-117.92408, 33.88412], [-117.92397, 33.88429], [-117.92354, 33.88397], [-117.92333, 33.88404], [-117.92297, 33.88442], [-117.92231, 33.88498], [-117.92231, 33.88499], [-117.92279, 33.88538], [-117.92229, 33.8858], [-117.92197, 33.88601], [-117.92171, 33.88614], [-117.92123, 33.88634], [-117.92078, 33.8865], [-117.92073, 33.8865], [-117.92066, 33.88644], [-117.9205, 33.88616], [-117.92054, 33.88613], [-117.92028, 33.88566], [-117.92023, 33.88566], [-117.92021, 33.88554], [-117.92022, 33.88548], [-117.92027, 33.88542], [-117.9204, 33.88533], [-117.92058, 33.88525], [-117.92067, 33.88517], [-117.92073, 33.88504], [-117.92073, 33.88495], [-117.92071, 33.88487], [-117.92063, 33.88477], [-117.91997, 33.88433], [-117.91994, 33.8843], [-117.91993, 33.88424], [-117.92209, 33.88471], [-117.92255, 33.88401], [-117.9228, 33.8839], [-117.92419, 33.88391]]]} | Open Access 1 | 4247 | Lions Field | 21314 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 10.364 | Lions Field | 0 | Local Recreation Area 3 | 4 | |
747 | 747 | 746 | {"type": "MultiPolygon", "coordinates": [[[[-119.44573, 36.58961], [-119.44537, 36.58963], [-119.44447, 36.58892], [-119.4438, 36.58849], [-119.44338, 36.58829], [-119.43086, 36.58296], [-119.43083, 36.58271], [-119.44402, 36.58835], [-119.44453, 36.58867], [-119.44573, 36.58961]]], [[[-119.44987, 36.59354], [-119.44964, 36.59365], [-119.44551, 36.58977], [-119.44593, 36.58981], [-119.44987, 36.59354]]], [[[-119.45189, 36.59557], [-119.45174, 36.5957], [-119.45083, 36.59481], [-119.45091, 36.59472], [-119.45079, 36.59461], [-119.45068, 36.59466], [-119.44981, 36.59379], [-119.45002, 36.59366], [-119.45189, 36.59557]]], [[[-119.453, 36.59657], [-119.45277, 36.59669], [-119.45188, 36.59581], [-119.45205, 36.59566], [-119.453, 36.59657]]], [[[-119.45512, 36.59856], [-119.45491, 36.59872], [-119.45297, 36.59683], [-119.45318, 36.59667], [-119.45512, 36.59856]]], [[[-119.45728, 36.60049], [-119.4568, 36.6005], [-119.45508, 36.59886], [-119.45525, 36.59868], [-119.45728, 36.60049]]], [[[-119.45763, 36.60105], [-119.45763, 36.60105], [-119.45699, 36.60059], [-119.45759, 36.60064], [-119.45763, 36.60105]]], [[[-119.46088, 36.60239], [-119.46072, 36.60259], [-119.45776, 36.60116], [-119.45774, 36.60077], [-119.45891, 36.60144], [-119.46088, 36.60239]]]]} | Open Access 1 | 4869 | Reedley Community Parkway | 24261 | 1272 | Reedley, City of 250 | City 2 | City Agency 2 | http://www.reedley.com/ | City 2 | 1272 | Reedley, City of 246 | City 2 | City Agency 2 | Fresno 9 | 20.099 | Reedley Community Parkway | 0 | Local Recreation Area 3 | 4 | |
768 | 768 | 767 | {"type": "Polygon", "coordinates": [[[-122.42281, 37.75993], [-122.42246, 37.75995], [-122.42232, 37.75965], [-122.42215, 37.75966], [-122.42211, 37.75927], [-122.42205, 37.75923], [-122.42183, 37.75925], [-122.4218, 37.75887], [-122.4227, 37.75882], [-122.42281, 37.75993]]]} | Open Access 1 | 5666 | Mission Playground | 22307 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.793 | Mission Playground | 0 | Local Recreation Area 3 | 4 | |
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} | Restricted Access 2 | 5062 | Las Positas Golf Course | 33002 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 216.12 | Las Positas GC | 0 | Local Recreation Area 3 | 4 | |
785 | 785 | 784 | {"type": "Polygon", "coordinates": [[[-122.40049, 37.76481], [-122.39883, 37.76491], [-122.39873, 37.76382], [-122.40038, 37.76372], [-122.40049, 37.76481]]]} | Open Access 1 | 5773 | Jackson Playground | 20324 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 4.406 | Jackson Playground | 0 | Local Recreation Area 3 | 4 | |
808 | 808 | 807 | {"type": "Polygon", "coordinates": [[[-117.45571, 34.13934], [-117.4557, 34.14315], [-117.45377, 34.14315], [-117.45377, 34.14305], [-117.4537, 34.14299], [-117.4537, 34.14225], [-117.45372, 34.14224], [-117.45372, 34.14186], [-117.45381, 34.14178], [-117.4538, 34.14168], [-117.4537, 34.1416], [-117.4537, 34.14095], [-117.45372, 34.14094], [-117.45372, 34.14057], [-117.45381, 34.14048], [-117.45381, 34.14038], [-117.45371, 34.1403], [-117.45375, 34.13931], [-117.45387, 34.1392], [-117.45406, 34.1392], [-117.4542, 34.13923], [-117.45443, 34.13923], [-117.45456, 34.1392], [-117.45477, 34.1392], [-117.45531, 34.13925], [-117.45539, 34.13934], [-117.45554, 34.13937], [-117.45566, 34.13933], [-117.45571, 34.13934]]]} | Open Access 1 | 5872 | Ralph M Lewis Sports Complex | 24101 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 19.548 | Ralph M Lewis Sports Complex | 0 | Local Recreation Area 3 | 4 | |
838 | 838 | 837 | {"type": "Polygon", "coordinates": [[[-122.44984, 37.73813], [-122.44957, 37.73918], [-122.44952, 37.73922], [-122.44945, 37.73923], [-122.44886, 37.73921], [-122.44882, 37.7392], [-122.4488, 37.73916], [-122.44882, 37.73902], [-122.44896, 37.73851], [-122.44902, 37.7381], [-122.44907, 37.73808], [-122.44945, 37.73809], [-122.44971, 37.73804], [-122.44978, 37.73805], [-122.44983, 37.73809], [-122.44984, 37.73813]]]} | Open Access 1 | 5466 | Miraloma Playground | 22285 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 2.208 | Miraloma Playground | 0 | Local Recreation Area 3 | 4 | |
846 | 846 | 845 | {"type": "Polygon", "coordinates": [[[-118.3727, 33.86126], [-118.37269, 33.86142], [-118.37262, 33.86173], [-118.3726, 33.86177], [-118.37254, 33.86182], [-118.37209, 33.86205], [-118.37203, 33.86204], [-118.37195, 33.86189], [-118.37193, 33.86179], [-118.37193, 33.86126], [-118.3727, 33.86126]]]} | Open Access 1 | 6073 | Fulton Playfield | 19148 | 1270 | Redondo Beach, City of 246 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | Los Angeles 6 | 1.216 | Fulton Playfield | 0 | Local Recreation Area 3 | 4 | |
863 | 863 | 862 | {"type": "Polygon", "coordinates": [[[-122.46596, 37.74109], [-122.46493, 37.74236], [-122.4645, 37.74212], [-122.46556, 37.74086], [-122.46583, 37.74099], [-122.46595, 37.74107], [-122.46596, 37.74109]]]} | Open Access 1 | 5574 | West Portal Playground | 27374 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 1.893 | West Portal Playground | 0 | Local Recreation Area 3 | 4 | |
907 | 907 | 906 | {"type": "Polygon", "coordinates": [[[-118.57306, 34.07116], [-118.57275, 34.07156], [-118.57161, 34.07199], [-118.57078, 34.07438], [-118.56939, 34.07481], [-118.56849, 34.07435], [-118.56719, 34.07493], [-118.56601, 34.07456], [-118.56562, 34.0739], [-118.56573, 34.07186], [-118.56463, 34.07084], [-118.56607, 34.0706], [-118.5687, 34.07091], [-118.56976, 34.07088], [-118.57133, 34.0713], [-118.57211, 34.07034], [-118.57306, 34.07116]]]} | No Public Access 3 | 6358 | Santa Ynez Reservoir | 29145 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | https://www.ladwp.com | Los Angeles 6 | 58.139 | Santa Ynez Reservoir | 0 | Local Recreation Area 3 | 4 |
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 | |
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 |
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]);