units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,989 rows where DES_TP = 3 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, PARK_URL, COUNTY, YR_EST
MNG_AGENCY 443
- San Diego, City of 211
- Los Angeles, City of 116
- San Francisco, City and County of 80
- Mountains Recreation and Conservation Authority 58
- Los Angeles, County of 31
- Conejo Open Space Conservation Agency 29
- East Bay Regional Park District 28
- Las Virgenes Municipal Water District 28
- San Luis Obispo, City of 26
- Long Beach, City of 25
- 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
- Fullerton, City of 15
- Los Angeles - Department of Parks and Recreation, County of 15
- Santa Cruz, City of 14
- Conejo Recreation and Park District 14
- San Bernardino, City of 14
- San Marcos, City of 14
- East Bay Municipal Utility District 13
- Tiburon, Town of 13
- Carlsbad, City of 12
- Poway, City of 12
- Sunrise Recreation and Park District 12
- Littlerock Creek Irrigation District 12
- Rancho Simi Recreation and Park District 11
- Mission Viejo, City of 11
- Fresno, City of 10
- Oceanside, City of 10
- Santa Clara County Parks and Recreation Dept., County of 10
- Valley-Wide Recreation and Park District 9
- Riverside, City of 9
- Irvine, City of 9
- Roseville, City of 9
- Sacramento, County of 9
- Santa Barbara, City of 8
- South San Francisco, City of 8
- Escondido, City of 8
- Chico, City of 8
- Newport Beach, City of 7
- San Ramon, City of 7
- San Diego, County of 7
- Chula Vista, City of 7
- Walnut Creek, City of 7
- Fairfield, City of 7
- Hayward Area Recreation and Park District 7
- Whittier, City of 7
- Novato, City of 7
- Eureka, City of 7
- Moreno Valley, City of 6
- Santa Ana, City of 6
- Richmond, City of 6
- Encinitas, City of 6
- Isla Vista Recreation and Park District 6
- Redondo Beach, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Desert Recreation District 6
- Los Angeles County Flood Control District 6
- Calabasas, City of 6
- Rohnert Park, City of 6
- Concord, City of 6
- Redding, City of 6
- Daly City, City of 6
- Santa Cruz, County of 5
- San Luis Obispo, County of 5
- Monterey, County of 5
- Salinas, City of 5
- Ventura, City of 5
- Burbank, City of 5
- Orange, County of 5
- Petaluma, City of 5
- Marin County Parks Department, County of 5
- Riverside, County of 5
- Rancho Palos Verdes, City of 5
- La Verne, City of 5
- West Covina, City of 5
- Kinneloa Irrigation District 5
- Murrieta, City of 5
- Fremont, City of 5
- Stockton, City of 5
- Gilroy, City of 5
- Gonzales, City of 5
- Southgate Recreation and Park District 5
- Marysville, City of 5
- Galt, City of 5
- South Lake Tahoe, City of 5
- Seal Beach, City of 4
- Monterey, City of 4
- Monterey Peninsula Regional Park District 4
- Yorba Linda, City of 4
- El Cajon, City of 4
- Chino Hills, City of 4
- Visalia, City of 4
- San Leandro, City of 4
- Belmont, City of 4
- Ventura, County of 4
- Lake Forest, City of 4
- Oakley, City of 4
- El Segundo, City of 4
- Benicia, City of 4
- Napa, City of 4
- Bellflower, City of 4
- Los Gatos, Town of 4
- Clovis, City of 4
- Manhattan Beach, City of 4
- Modesto, City of 4
- Los Banos, City of 4
- Ripon, City of 4
- Calexico, City of 4
- San Gabriel, City of 4
- Tuolumne Park and Recreation District 4
- Miraleste Recreation and Park District 4
- Culver City, City of 3
- San Mateo County Parks and Recreation Dept., County of 3
- Santa Rosa, City of 3
- Pleasanton, City of 3
- Turlock, City of 3
- Anaheim, City of 3
- Glendora, City of 3
- Yucaipa, City of 3
- San Juan Capistrano, City of 3
- El Centro, City of 3
- San Mateo, City of 3
- Norco, City of 3
- Ontario, City of 3
- Pomona, City of 3
- Exeter, City of 3
- Porterville, City of 3
- Azusa, City of 3
- Pleasant Valley Recreation and Park District 3
- Tulare, City of 3
- Fontana, City of 3
- Alameda, City of 3
- Sonoma County Regional Parks Dept., County of 3
- Palmdale, City of 3
- El Monte, City of 3
- Marin Municipal Water District 3
- Livermore, City of 3
- Apple Valley Recreation and Park District 3
- Needles, City of 3
- Torrance, City of 3
- Fresno, County of 3
- South Pasadena, City of 3
- La Mirada, City of 3
- Rio Vista, City of 3
- Duarte, City of 3
- San Clemente, City of 3
- Temecula, City of 3
- Healdsburg, City of 3
- Kern, County of 3
- Saint Helena, City of 3
- San Bruno, City of 3
- Pleasant Hill Recreation and Park District 3
- Vallejo, City of 3
- Woodland, City of 3
- Piedmont, City of 3
- El Dorado Hills Community Service District 3
- Arcata, City of 3
- Yreka, City of 3
- Monterey County Water Resources Agency 3
- Nevada Irrigation District 3
- Durham Recreation and Park District 3
- Oakdale, City of 2
- Claremont, City of 2
- Patterson, City of 2
- Victorville, City of 2
- Riverbank, City of 2
- Santa Barbara Flood Control and Water Conserv. District 2
- Garden Grove, City of 2
- Corona, City of 2
- Barstow Recreation and Park District 2
- Downey, City of 2
- Oxnard, City of 2
- Redlands, City of 2
- Coronado, City of 2
- Scotts Valley, City of 2
- Capitola, City of 2
- Seaside, City of 2
- Costa Mesa, City of 2
- Paso Robles, City of 2
- Rosemead, City of 2
- Dana Point, City of 2
- Alhambra, City of 2
- Brawley, City of 2
- Dublin, City of 2
- Goleta, City of 2
- Loma Linda, City of 2
- Cupertino, City of 2
- Hollister, City of 2
- Placer, County of 2
- Santa Fe Springs, City of 2
- Barstow, City of 2
- Cerritos, City of 2
- Sanger, City of 2
- Brea, City of 2
- San Dimas, City of 2
- Reedley, City of 2
- Montebello, City of 2
- Rolling Hills Estates, City of 2
- Albany, City of 2
- Port of Los Angeles 2
- Gardena, City of 2
- Pasadena, City of 2
- Arcadia, City of 2
- Sierra Madre, City of 2
- Monrovia, City of 2
- Agoura Hills, City of 2
- Shasta Lake, City of 2
- La Canada Flintridge, City of 2
- Berkeley, City of 2
- Hanford, City of 2
- Antioch, City of 2
- Brentwood, City of 2
- Pinole, City of 2
- Jurupa Area Recreation and Park District 2
- Union City, City of 2
- San Bernardino, County of 2
- Lemoore, City of 2
- North of the River Recreation and Park District 2
- Orinda, City of 2
- Tracy, City of 2
- Millbrae, City of 2
- Rose Hills Memorial Park Association 2
- Sunnyvale, City of 2
- Pismo Beach, City of 2
- Contra Costa County Public Works Dept., County of 2
- Live Oak, City of 2
- Yuba City, City of 2
- Delano, City of 2
- Auburn Area Recreation and Park District 2
- West Side Recreation and Park District 2
- San Joaquin, County of 2
- King City, City of 2
- Manteca, City of 2
- Red Bluff, City of 2
- Sanitation Districts of Los Angeles County 2
- Stanislaus, County of 2
- Port San Luis Harbor District 2
- Lathrop, City of 2
- Laguna Niguel, City of 2
- Yolo, County of 2
- West Sacramento, City of 2
- Folsom, City of 2
- Consumnes Community Services District 2
- Wheatland, City of 2
- Truckee-Donner Recreation and Park District 2
- Rocklin, City of 2
- Willits, City of 2
- Sacramento Area Flood Control Agency 2
- South El Monte, City of 2
- Hesperia Recreation and Park District 2
- La Quinta, City of 2
- Valley Center Water District 2
- Los Angeles Department of Public Works, County of 2
- Yountville, Town of 2
- Stanton, City of 2
- Culver City Unified School District 2
- Ukiah, City of 2
- Sweetwater Authority 2
- Native Habitat Preservation Authority 2
- Olivenhain Municipal Water District 2
- Aromona Community Services District 2
- Orangevale Recreation and Park District 2
- Weed Recreation and Parks District 2
- Lancaster, City of 1
- Santa Maria, City of 1
- Lompoc, City of 1
- National City, City of 1
- Solvang, City of 1
- Huntington Park, City of 1
- Buellton, City of 1
- Sonoma County Water Agency 1
- Ojai, City of 1
- Huntington Beach, City of 1
- Monterey Park, City of 1
- Lindsay, City of 1
- Hemet, City of 1
- Vista, City of 1
- Palo Alto, City of 1
- Colton, City of 1
- Moorpark, City of 1
- Pacific Grove, City of 1
- Santa Monica, City of 1
- San Diego Unified Port District 1
- Lake Elsinore, City of 1
- San Pablo, City of 1
- Rancho Cucamonga, City of 1
- Beverly Hills, City of 1
- Palm Desert, City of 1
- Marina, City of 1
- Livingston, City of 1
- Indio, City of 1
- Menlo Park, City of 1
- Rim of the World Recreation and Park District 1
- Bell Gardens, City of 1
- Mill Valley, City of 1
- Placentia, City of 1
- Highland, City of 1
- Lakewood, City of 1
- Yucca Valley, Town of 1
- Fountain Valley, City of 1
- Compton, City of 1
- Inglewood, City of 1
- Tustin, City of 1
- Lake, County of 1
- Paramount, City of 1
- Hermosa Beach, City of 1
- Carson, City of 1
- Orange, City of 1
- Feather River Recreation and Park District 1
- Walnut, City of 1
- Avalon, City of 1
- Windsor, Town of 1
- Bell, City of 1
- Greater Vallejo Recreation and Park District 1
- Blythe, City of 1
- Rancho Simi Open Space Conservation Agency 1
- San Rafael, City of 1
- Cotati, City of 1
- La Canada Irrigation District 1
- Pico Rivera, City of 1
- Newark, City of 1
- Pittsburg, City of 1
- El Cerrito, City of 1
- Santa Clara, City of 1
- Pacifica, City of 1
- Cloverdale, City of 1
- Metropolitan Water District of Southern California 1
- Loomis, Town of 1
- Morgan Hill, City of 1
- Milpitas, City of 1
- Brooktrails Community Services District 1
- Corte Madera, Town of 1
- American Canyon, City of 1
- Shafter Recreation and Park District 1
- San Anselmo, City of 1
- Half Moon Bay, City of 1
- Belvedere, City of 1
- Sausalito, City of 1
- Campbell, City of 1
- Larkspur, City of 1
- Mountain View, City of 1
- Madera, City of 1
- Wasco Recreation and Park District 1
- Atwater, City of 1
- Merced, City of 1
- Lawndale, City of 1
- Lodi, City of 1
- Colusa, City of 1
- Yuba County Water Agency 1
- Chico Area Recreation and Park District 1
- Oroville, City of 1
- Ceres, City of 1
- Monterey Peninsula Recreational Trail Joint Powers 1
- Rio Linda Elverta Recreation and Park District 1
- Humboldt, County of 1
- Olivehurst Public Utility District 1
- Monte Rio Recreation and Park District 1
- Twain Harte Community Services District 1
- Groveland Community Services District 1
- Paradise Recreation and Park District 1
- Sacramento Regional County Sanitation District 1
- Sacramento Municipal Utility District 1
- Port Hueneme, City of 1
- Cathedral City, City of 1
- Siskiyou, County of 1
- Lincoln, City of 1
- Arroyo Grande, City of 1
- Los Angeles Unified School District 1
- Manila Community Services District 1
- Clayton, City of 1
- McKinleyville Community Services District 1
- North Tahoe Public Utilities District 1
- Joshua Tree Park and Recreation District 1
- Mt. Shasta Recreation and Park District 1
- Natomas Basin Conservancy 1
- Desert Hot Springs, City of 1
- Rio Dell, City of 1
- Corning, City of 1
- Grover Beach, City of 1
- Los Angeles Department of Recreation and Parks, City of 1
- Carmichael Recreation and Park District 1
- Del Norte County Parks, County of 1
- Rancho Cordova, City of 1
- Yuima Municipal Water District 1
- Blue Lake, City of 1
- North County Recreation and Park District 1
- Crescent City, City of 1
- Williams, City of 1
- Amador, County of 1
- Ridgecrest, City of 1
- Calistoga, City of 1
- Helix Water District 1
- Point Arena, City of 1
- Georgetown Divide Recreation District 1
- Emeryville, City of 1
- Suisun City, City of 1
- La Puente, City of 1
- Beaumont, City of 1
- Santa Clara Valley Water District 1
- South Sutter Water District 1
- Almanor Recreation and Park District 1
- Calleguas Municipal Water District 1
- Watershed Conservation Authority 1
- Hughson, City of 1
- Santa Clara Unified School District 1
- San Diego County Water Authority 1
- Vallecitos Water District 1
- San Bernardino County Flood Control District 1
- Fairfax, Town of 1
- Marinwood Community Service District 1
- Atherton, Town of 1
- Malibu, City of 1
- Elk Grove, City of 1
- Colma, City of 1
- Fair Oaks Recreation and Park District 1
- Vista Unified School District 1
- North Highland Recreation and Park District 1
- Casitas Municipal Water District 1
- Santa Margarita Water District 1
- Russian River Recreation and Park District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Georgetown Divide Public Utility District 1
- Colusa, County of 1
- Sonoma-Marin Area Rail Transit 1
- Rainbow Municipal Water District 1
- Sutter, County of 1
- Fort Jones, City of 1
- Bradbury, City of 1
- San Dimas-La Verne Recreational Facilities Authority 1
- Ridgecrest Ranchos Recreation and Park District 1
- Otay Water District 1
- Madera Irrigation District 1
- Browns Valley Irrigation District 1
- Highlands Recreation District 1
- Ladera Recreation District 1
- Rancho Rinconada Recreation and Park District 1
MNG_AG_TYP 17
- City Agency 1,440
- Recreation/Parks District 164
- County Agency 117
- Open Space District 88
- Water District 69
- County Agency - Parks 37
- Irrigation District 23
- Community Services District 14
- Flood District 12
- Port/Harbor District 5
- School District 5
- County Agency - Other 4
- Special District - Other 4
- Sanitation District 3
- Cemetery District 2
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 1,640
- Restricted Access 220
- No Public Access 113
- Unknown Access 16
DES_TP 1
- Local Recreation Area · 1,989 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12095 | 12095 | 12094 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.2692, 38.03185], [-122.26868, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | 24918 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.708 | Lefty Gomez Ballfield Complex | 0 | Local Recreation Area 3 | 4 | |
15875 | 15875 | 15874 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | 15091 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.396 | Montara Bay Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
12322 | 12322 | 12321 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | 25985 | Kings river Access Park | 20661 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 7.286 | Kings river Access Park | 0 | Local Recreation Area 3 | 4 | |
15708 | 15708 | 15707 | {"type": "Polygon", "coordinates": [[[-119.91096, 36.84512], [-119.90786, 36.84617], [-119.90717, 36.84638], [-119.90647, 36.84658], [-119.90541, 36.84683], [-119.90469, 36.84697], [-119.90396, 36.8471], [-119.90287, 36.84725], [-119.90247, 36.84764], [-119.89722, 36.84425], [-119.90643, 36.84421], [-119.90626, 36.84057], [-119.90871, 36.84057], [-119.91065, 36.84027], [-119.91086, 36.84418], [-119.91096, 36.84418], [-119.91096, 36.84512]]]} | Restricted Access 2 | 25955 | Riverside Municipal Golf Course | 33087 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 107.589 | Riverside Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16711 | 16711 | 16710 | {"type": "Polygon", "coordinates": [[[-119.74048, 36.9629], [-119.74046, 36.96322], [-119.74044, 36.96339], [-119.73993, 36.96544], [-119.73943, 36.96697], [-119.73768, 36.97137], [-119.73595, 36.97372], [-119.73239, 36.97692], [-119.73129, 36.97793], [-119.73031, 36.97791], [-119.72304, 36.97794], [-119.72301, 36.97562], [-119.72458, 36.9743], [-119.72577, 36.9743], [-119.72576, 36.97335], [-119.72618, 36.97296], [-119.72661, 36.9725], [-119.727, 36.97202], [-119.72727, 36.97165], [-119.72758, 36.97113], [-119.72785, 36.9706], [-119.72803, 36.97019], [-119.72821, 36.96964], [-119.72832, 36.96922], [-119.72846, 36.96849], [-119.72876, 36.96559], [-119.72882, 36.96514], [-119.72884, 36.96481], [-119.72883, 36.96447], [-119.72878, 36.96392], [-119.72872, 36.96359], [-119.72864, 36.96326], [-119.72779, 36.96087], [-119.73636, 36.96082], [-119.73638, 36.96293], [-119.74048, 36.9629]]]} | Open Access 1 | 25929 | Lost Lake Recreation Area | 21541 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 425.466 | Lost Lake Rec. Area | 0 | Local Recreation Area 3 | 4 | |
9685 | 9685 | 9684 | {"type": "MultiPolygon", "coordinates": [[[[-119.30563, 35.2353], [-119.30545, 35.23513], [-119.30517, 35.23486], [-119.3056, 35.23496], [-119.30563, 35.2353]]], [[[-119.3058, 35.23952], [-119.30548, 35.23941], [-119.30568, 35.23894], [-119.30579, 35.23899], [-119.3058, 35.23952]]], [[[-119.30565, 35.23862], [-119.30561, 35.23877], [-119.30536, 35.23934], [-119.30517, 35.23932], [-119.30488, 35.23973], [-119.30337, 35.24084], [-119.30262, 35.24121], [-119.30201, 35.2405], [-119.3035, 35.2389], [-119.30306, 35.23859], [-119.30383, 35.23859], [-119.3029, 35.23803], [-119.30249, 35.23804], [-119.30177, 35.23774], [-119.30056, 35.2374], [-119.28883, 35.23473], [-119.28882, 35.23474], [-119.2889, 35.23849], [-119.28635, 35.23847], [-119.28635, 35.23529], [-119.28021, 35.23526], [-119.27987, 35.23525], [-119.2792, 35.23519], [-119.27852, 35.2351], [-119.27819, 35.23503], [-119.2777, 35.23492], [-119.27722, 35.23479], [-119.27629, 35.23446], [-119.27199, 35.2325], [-119.27135, 35.23225], [-119.27025, 35.23194], [-119.26938, 35.2318], [-119.26879, 35.23174], [-119.26835, 35.23173], [-119.26019, 35.23176], [-119.25927, 35.23169], [-119.25813, 35.23154], [-119.257, 35.2313], [-119.25592, 35.23098], [-119.25528, 35.23076], [-119.25486, 35.23059], [-119.25388, 35.23015], [-119.2537, 35.23003], [-119.2535, 35.22995], [-119.25269, 35.22947], [-119.25204, 35.22903], [-119.25138, 35.2285], [-119.25061, 35.22779], [-119.2495, 35.22664], [-119.23717, 35.23667], [-119.23704, 35.23659], [-119.23632, 35.2372], [-119.23611, 35.23751], [-119.23597, 35.23791], [-119.23597, 35.23797], [-119.23549, 35.23797], [-119.23557, 35.23767], [-119.23566, 35.23745], [-119.23581, 35.23719], [-119.23595, 35.23701], [-119.23616, 35.23679], [-119.23674, 35.23633], [-119.23669, 35.23625], [-119.24905, 35.22618], [-119.24654, 35.22363], [-119.23598, 35.21269], [-119.23589, 35.20903], [-119.23857, 35.20905], [-119.2527, 35.21503], [-119.27023, 35.22232], [-119.27027, 35.22295], [-119.27246, 35.22385], [-119.28807, 35.23043], [-119.28888, 35.23064], [-119.28925, 35.23044], [-119.28946, 35.23015], [-119.28949, 35.22964], [-119.28958, 35.22945], [-119.28968, 35.22936], [-119.28988, 35.22932], [-119.29037, 35.22933], [-119.29072, 35.22943], [-119.30292, 35.23352], [-119.30535, 35.23718], [-119.30536, 35.23732], [-119.30536, 35.23752], [-119.30533, 35.23775], [-119.30526, 35.23804], [-119.30512, 35.23836], [-119.30498, 35.23858], [-119.30538, 35.23862], [-119.30565, 35.23862]]]]} | Open Access 1 | 16326 | Buena Vista Aquatic Recreation Area | 4788 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/buena-vista.asp | Kern 36 | 1578.796 | Buena Vista Aquatic Rec. Area | 0 | Local Recreation Area 3 | 4 |
15718 | 15718 | 15717 | {"type": "Polygon", "coordinates": [[[-118.86048, 35.43724], [-118.86016, 35.4381], [-118.86002, 35.43895], [-118.85983, 35.4394], [-118.8594, 35.44002], [-118.85729, 35.4433], [-118.85404, 35.44375], [-118.85191, 35.44323], [-118.85136, 35.44191], [-118.85208, 35.44189], [-118.85209, 35.44188], [-118.85187, 35.44165], [-118.85179, 35.44152], [-118.8517, 35.44143], [-118.85151, 35.44114], [-118.85136, 35.4408], [-118.85127, 35.44037], [-118.85124, 35.4397], [-118.85125, 35.43952], [-118.85142, 35.43847], [-118.85168, 35.4376], [-118.85179, 35.43699], [-118.85188, 35.43672], [-118.85194, 35.43629], [-118.85201, 35.43606], [-118.85205, 35.43585], [-118.85218, 35.43553], [-118.85249, 35.43501], [-118.85257, 35.43462], [-118.85274, 35.43427], [-118.85284, 35.43411], [-118.85288, 35.4338], [-118.85293, 35.43364], [-118.85293, 35.4334], [-118.853, 35.43324], [-118.85845, 35.4332], [-118.85874, 35.43316], [-118.85964, 35.43288], [-118.86022, 35.43526], [-118.86031, 35.43629], [-118.86048, 35.43724]]]} | Restricted Access 2 | 44512 | Kern River Golf Course | 33105 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 196.033 | Kern River GC | 0 | Local Recreation Area 3 | 4 | |
16925 | 16925 | 16924 | {"type": "Polygon", "coordinates": [[[-119.02667, 35.39563], [-119.02663, 35.3959], [-119.02664, 35.39629], [-119.02662, 35.39646], [-119.02651, 35.39681], [-119.02638, 35.39701], [-119.02618, 35.39724], [-119.02598, 35.3974], [-119.02582, 35.39749], [-119.02557, 35.39761], [-119.02484, 35.39761], [-119.02316, 35.39817], [-119.02118, 35.39851], [-119.02117, 35.39894], [-119.01888, 35.39893], [-119.01891, 35.39267], [-119.01979, 35.39267], [-119.01979, 35.39195], [-119.02098, 35.39198], [-119.02096, 35.3976], [-119.02119, 35.39758], [-119.02118, 35.39217], [-119.02214, 35.39216], [-119.02667, 35.39563]]]} | Open Access 1 | 16493 | Metropolitan Recreation Center | 22188 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 93.734 | Metropolitan Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
930 | 930 | 929 | {"type": "Polygon", "coordinates": [[[-118.35399, 33.79067], [-118.35035, 33.79268], [-118.35001, 33.7929], [-118.34972, 33.79315], [-118.34952, 33.79335], [-118.34927, 33.7937], [-118.34853, 33.79307], [-118.34875, 33.79282], [-118.34783, 33.79205], [-118.34783, 33.79015], [-118.34362, 33.78659], [-118.34517, 33.78551], [-118.34559, 33.7853], [-118.34583, 33.7852], [-118.34609, 33.78513], [-118.34641, 33.78506], [-118.34996, 33.78455], [-118.35025, 33.78449], [-118.35084, 33.78427], [-118.35136, 33.78464], [-118.35157, 33.78445], [-118.3532, 33.7856], [-118.35399, 33.79067]]]} | No Public Access 3 | 5917 | South Coast Park/Peter Weber Equestrian Center | 29016 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 141.298 | South Coast Park/Peter Weber Equestrian Ctr. | 0 | Local Recreation Area 3 | 4 | |
1070 | 1070 | 1069 | {"type": "Polygon", "coordinates": [[[-118.12169, 34.18412], [-118.12169, 34.18484], [-118.12109, 34.18492], [-118.12098, 34.18506], [-118.12057, 34.18506], [-118.12058, 34.18579], [-118.11862, 34.1858], [-118.11862, 34.18574], [-118.11762, 34.1841], [-118.11755, 34.18393], [-118.1175, 34.18371], [-118.11747, 34.18334], [-118.11742, 34.18334], [-118.11734, 34.18092], [-118.11782, 34.18092], [-118.11781, 34.18075], [-118.11767, 34.18048], [-118.11767, 34.18009], [-118.11806, 34.18009], [-118.1181, 34.1796], [-118.12141, 34.17957], [-118.12144, 34.18233], [-118.12147, 34.18248], [-118.12158, 34.18276], [-118.12162, 34.18294], [-118.12162, 34.18319], [-118.12154, 34.18358], [-118.12153, 34.18373], [-118.12155, 34.18386], [-118.12159, 34.18403], [-118.12162, 34.18407], [-118.12169, 34.18412]]]} | Restricted Access 2 | 6971 | Altadena Golf Course | 33022 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 57.739 | Altadena GC | 0 | Local Recreation Area 3 | 4 | |
1632 | 1632 | 1631 | {"type": "Polygon", "coordinates": [[[-118.00413, 33.90582], [-118.00266, 33.9058], [-118.00229, 33.90591], [-118.0005, 33.9071], [-118.00033, 33.90729], [-118.00022, 33.90737], [-118.00018, 33.90743], [-117.99885, 33.90986], [-117.99444, 33.90988], [-117.99438, 33.90984], [-117.99434, 33.90424], [-117.99435, 33.90374], [-117.99441, 33.90318], [-117.99449, 33.90284], [-117.99455, 33.9028], [-118.00302, 33.90275], [-118.00303, 33.9028], [-118.00324, 33.90281], [-118.00329, 33.90286], [-118.0033, 33.90333], [-118.00333, 33.90358], [-118.00337, 33.90378], [-118.00343, 33.90396], [-118.00405, 33.90551], [-118.00413, 33.90582]]]} | Restricted Access 2 | 45404 | La Mirada Golf Course | 33111 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/La_Mirada_Golf_Course | Los Angeles 6 | 131.179 | La Mirada GC | 0 | Local Recreation Area 3 | 4 |
2202 | 2202 | 2201 | {"type": "Polygon", "coordinates": [[[-118.27588, 33.85284], [-118.2733, 33.85587], [-118.27289, 33.855], [-118.27131, 33.85628], [-118.27096, 33.85622], [-118.27087, 33.85665], [-118.26832, 33.85666], [-118.26831, 33.85663], [-118.26621, 33.85662], [-118.26616, 33.85657], [-118.26515, 33.84858], [-118.26738, 33.84759], [-118.26891, 33.84731], [-118.26947, 33.84787], [-118.26991, 33.84825], [-118.26994, 33.84841], [-118.27012, 33.84858], [-118.2705, 33.84889], [-118.27057, 33.84885], [-118.2725, 33.85028], [-118.2731, 33.85068], [-118.27588, 33.85284]]]} | Restricted Access 2 | 6243 | Victoria Golf Course | 33008 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 167.229 | Victoria GC | 0 | Local Recreation Area 3 | 4 | |
4892 | 4892 | 4891 | {"type": "MultiPolygon", "coordinates": [[[[-118.15498, 33.83254], [-118.15491, 33.83579], [-118.15381, 33.83579], [-118.15367, 33.83568], [-118.15367, 33.83541], [-118.15336, 33.8354], [-118.15335, 33.83567], [-118.15358, 33.83568], [-118.15378, 33.83584], [-118.15123, 33.83584], [-118.15123, 33.83648], [-118.15303, 33.83854], [-118.15303, 33.83964], [-118.14813, 33.83963], [-118.14827, 33.83948], [-118.14837, 33.83933], [-118.14842, 33.83919], [-118.1485, 33.83886], [-118.15013, 33.83865], [-118.15122, 33.83875], [-118.15122, 33.8381], [-118.1496, 33.83658], [-118.14871, 33.83658], [-118.14676, 33.83715], [-118.14799, 33.83893], [-118.14829, 33.83889], [-118.14823, 33.83915], [-118.14819, 33.83926], [-118.14811, 33.83939], [-118.14799, 33.83951], [-118.14782, 33.83963], [-118.14742, 33.83963], [-118.14397, 33.83644], [-118.14405, 33.83636], [-118.14424, 33.83639], [-118.14429, 33.83617], [-118.14441, 33.83597], [-118.1462, 33.83409], [-118.14639, 33.83392], [-118.14756, 33.833], [-118.14768, 33.83283], [-118.14773, 33.8327], [-118.14775, 33.83255], [-118.14781, 33.83251], [-118.15469, 33.83253], [-118.1547, 33.83254], [-118.15498, 33.83254]]], [[[-118.15984, 33.8286], [-118.15959, 33.8286], [-118.15661, 33.83004], [-118.15469, 33.83035], [-118.15293, 33.83225], [-118.15, 33.83223], [-118.15104, 33.82949], [-118.15192, 33.82897], [-118.1541, 33.82898], [-118.15411, 33.82768], [-118.15982, 33.82769], [-118.15984, 33.8286]]]]} | Restricted Access 2 | 45718 | Lakewood Golf Course | 33113 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/ThingsToDo/Golf/Lakewood_Golf_Course | Los Angeles 6 | 176.286 | Lakewood GC | 0 | Local Recreation Area 3 | 4 |
4969 | 4969 | 4968 | {"type": "Polygon", "coordinates": [[[-118.52638, 34.34108], [-118.52584, 34.34096], [-118.52536, 34.34088], [-118.52304, 34.34055], [-118.52197, 34.34042], [-118.52208, 34.33992], [-118.523, 34.33996], [-118.5235, 34.33945], [-118.52521, 34.3407], [-118.52551, 34.34042], [-118.52602, 34.34081], [-118.5261, 34.34068], [-118.52638, 34.34073], [-118.52638, 34.34108]]]} | Open Access 1 | 7304 | Michael D Antonovich Open Space | 6049 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.lamountains.com/parks.asp?parkid=8 | Los Angeles 6 | 6.265 | Michael D Antonovich OS | 0 | Local Recreation Area 3 | 4 |
7180 | 7180 | 7179 | {"type": "MultiPolygon", "coordinates": [[[[-118.4334, 33.97487], [-118.43334, 33.97494], [-118.43267, 33.97532], [-118.43253, 33.97541], [-118.4325, 33.97537], [-118.43335, 33.97488], [-118.43335, 33.97486], [-118.4334, 33.97487]]], [[[-118.4549, 33.9631], [-118.45487, 33.96311], [-118.45486, 33.96309], [-118.45459, 33.96321], [-118.45466, 33.96334], [-118.45351, 33.96386], [-118.45343, 33.96376], [-118.45281, 33.96407], [-118.45287, 33.96416], [-118.45163, 33.96472], [-118.45097, 33.96374], [-118.45201, 33.96315], [-118.45278, 33.96275], [-118.45277, 33.96271], [-118.45305, 33.96258], [-118.45376, 33.96368], [-118.45391, 33.96362], [-118.45391, 33.9636], [-118.45319, 33.96251], [-118.45385, 33.96218], [-118.45391, 33.96225], [-118.45421, 33.96211], [-118.4549, 33.9631]]]]} | Open Access 1 | 6316 | Ballona Creek Trail and Bike Path | 30329 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 11.277 | Ballona Creek Trail and Bike Path | 0 | Local Recreation Area 3 | 4 | |
7496 | 7496 | 7495 | {"type": "Polygon", "coordinates": [[[-118.04347, 34.13092], [-118.04339, 34.13133], [-118.0426, 34.13196], [-118.04287, 34.13232], [-118.04246, 34.13254], [-118.04197, 34.13285], [-118.0416, 34.13314], [-118.04112, 34.13356], [-118.04211, 34.13249], [-118.04222, 34.13228], [-118.04225, 34.13218], [-118.04224, 34.13217], [-118.04223, 34.13217], [-118.03927, 34.13536], [-118.03909, 34.13561], [-118.03898, 34.13586], [-118.0383, 34.1366], [-118.03775, 34.13635], [-118.03681, 34.13613], [-118.03624, 34.13619], [-118.03571, 34.13614], [-118.0349, 34.13614], [-118.03405, 34.13627], [-118.03343, 34.13635], [-118.03292, 34.13634], [-118.03259, 34.13625], [-118.03227, 34.13601], [-118.03198, 34.13576], [-118.03151, 34.13565], [-118.03143, 34.1309], [-118.03583, 34.13086], [-118.04244, 34.13075], [-118.04347, 34.13092]], [[-118.04259, 34.13197], [-118.04251, 34.13188], [-118.04241, 34.13199], [-118.04249, 34.13208], [-118.04259, 34.13197]]]} | Restricted Access 2 | 7018 | Santa Anita Golf Course | 33023 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 130.957 | Santa Anita GC | 0 | Local Recreation Area 3 | 4 | |
7776 | 7776 | 7775 | {"type": "Polygon", "coordinates": [[[-118.60408, 34.12532], [-118.60355, 34.12532], [-118.60343, 34.12511], [-118.60322, 34.12504], [-118.60322, 34.12533], [-118.60305, 34.12533], [-118.60305, 34.12497], [-118.60288, 34.12491], [-118.6019, 34.12492], [-118.6019, 34.12487], [-118.60222, 34.12486], [-118.60221, 34.12436], [-118.60228, 34.12438], [-118.60229, 34.12486], [-118.60291, 34.12486], [-118.60349, 34.12507], [-118.6036, 34.12527], [-118.60408, 34.12526], [-118.60408, 34.12532]]]} | Open Access 1 | 6423 | Canyon Oaks Open Space Access | 16820 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.571 | Canyon Oaks OS Access | 0 | Local Recreation Area 3 | 4 | |
8309 | 8309 | 8308 | {"type": "Polygon", "coordinates": [[[-118.60165, 34.05301], [-118.60165, 34.05347], [-118.60118, 34.05348], [-118.60118, 34.05301], [-118.60165, 34.05301]]]} | No Public Access 3 | 12776 | Los Angeles County Open Space | 21480 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.548 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
8322 | 8322 | 8321 | {"type": "Polygon", "coordinates": [[[-118.60332, 34.08036], [-118.60312, 34.08066], [-118.60292, 34.08071], [-118.60319, 34.08034], [-118.60332, 34.08036]]]} | Open Access 1 | 12773 | Los Angeles County Open Space | 21481 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.131 | Los Angeles County OS | 0 | Local Recreation Area 3 | 4 | |
9780 | 9780 | 9779 | {"type": "Polygon", "coordinates": [[[-118.63702, 34.45237], [-118.63703, 34.45246], [-118.63701, 34.45251], [-118.63659, 34.45296], [-118.63652, 34.45292], [-118.63652, 34.45288], [-118.63643, 34.45278], [-118.63616, 34.45261], [-118.63605, 34.45258], [-118.63601, 34.45258], [-118.63597, 34.45263], [-118.63589, 34.4526], [-118.63582, 34.45248], [-118.63576, 34.45241], [-118.63541, 34.45209], [-118.63522, 34.45196], [-118.63509, 34.45188], [-118.63491, 34.45173], [-118.63482, 34.45162], [-118.63482, 34.45156], [-118.63492, 34.45143], [-118.63508, 34.45129], [-118.63542, 34.45113], [-118.63578, 34.45131], [-118.63605, 34.45148], [-118.63627, 34.45166], [-118.63652, 34.45162], [-118.63658, 34.45164], [-118.63659, 34.45166], [-118.63663, 34.45196], [-118.63675, 34.45213], [-118.63683, 34.45227], [-118.63697, 34.45233], [-118.63702, 34.45237]]]} | Open Access 1 | 47885 | Hasley Canyon Equestrian Park | 31829 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/hasley-canyon-equestrian-park/ | Los Angeles 6 | 4.746 | Hasley Canyon Equestrian Park | 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]);