units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7,486 rows where DES_TP = 2 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY 456
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Fresno, City of 83
- Modesto, City of 76
- Huntington Beach, City of 74
- Tracy, City of 69
- Santa Rosa, City of 68
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- Napa, City of 46
- San Ramon, City of 45
- Fremont, City of 44
- Berkeley, City of 43
- Fullerton, City of 41
- Murrieta, City of 41
- Redding, City of 41
- Corona, City of 40
- Folsom, City of 40
- Santa Barbara, City of 39
- Santa Ana, City of 38
- Chino Hills, City of 38
- Visalia, City of 38
- Whittier, City of 38
- Davis, City of 37
- Temecula, City of 37
- Pleasanton, City of 36
- Oxnard, City of 36
- Rocklin, City of 36
- Richmond, City of 35
- Mission Viejo, City of 35
- Torrance, City of 35
- Santa Cruz, City of 34
- Vacaville, City of 34
- Salinas, City of 33
- Merced, City of 33
- Palo Alto, City of 32
- Chino, City of 32
- Santa Clarita, City of 32
- Antioch, City of 32
- Union City, City of 32
- Santa Clara, City of 32
- Moreno Valley, City of 31
- Ventura, City of 31
- San Bernardino, City of 31
- Redwood City, City of 31
- Mountain View, City of 31
- Glendale, City of 30
- Costa Mesa, City of 30
- Petaluma, City of 30
- Fontana, City of 30
- Rancho Cucamonga, City of 30
- Watsonville, City of 29
- San Jacinto, City of 29
- Redondo Beach, City of 29
- Pasadena, City of 29
- Oceanside, City of 28
- Patterson, City of 27
- Pomona, City of 27
- Santa Monica, City of 27
- West Sacramento, City of 27
- Santa Maria, City of 26
- Turlock, City of 26
- Redlands, City of 26
- Laguna Niguel, City of 26
- Alameda, City of 25
- Lake Forest, City of 25
- Oakley, City of 25
- Arcata, City of 25
- Yorba Linda, City of 24
- Westminster, City of 24
- Chico, City of 24
- Carlsbad, City of 23
- Fairfield, City of 23
- Livermore, City of 23
- Lodi, City of 23
- Los Banos, City of 23
- La Habra, City of 22
- San Luis Obispo, City of 21
- Azusa, City of 21
- San Marcos, City of 21
- Palmdale, City of 21
- San Rafael, City of 21
- Woodland, City of 21
- Monterey, City of 20
- San Juan Capistrano, City of 20
- Ontario, City of 20
- Burbank, City of 20
- Cupertino, City of 20
- Beverly Hills, City of 20
- Cerritos, City of 20
- Arcadia, City of 20
- Concord, City of 20
- Foster City, City of 20
- Yuba City, City of 20
- Claremont, City of 19
- Encinitas, City of 19
- Greenfield, City of 19
- Cypress, City of 19
- Hermosa Beach, City of 19
- San Clemente, City of 19
- Milpitas, City of 19
- Oakdale, City of 18
- Dana Point, City of 18
- Lake Elsinore, City of 18
- Hollister, City of 18
- Fountain Valley, City of 18
- Benicia, City of 18
- Sunnyvale, City of 18
- Novato, City of 18
- Victorville, City of 17
- Coronado, City of 17
- Seaside, City of 17
- San Leandro, City of 17
- Mill Valley, City of 17
- La Verne, City of 17
- Orange, City of 17
- Diamond Bar, City of 17
- Morgan Hill, City of 17
- Daly City, City of 17
- San Bruno, City of 17
- Calexico, City of 17
- Lincoln, City of 17
- Aliso Viejo, City of 17
- Garden Grove, City of 16
- Escondido, City of 16
- Dublin, City of 16
- Laguna Beach, City of 16
- Rohnert Park, City of 16
- Pittsburg, City of 16
- Sausalito, City of 16
- Bellflower, City of 16
- Culver City, City of 15
- South San Francisco, City of 15
- Moorpark, City of 15
- Loma Linda, City of 15
- Sanger, City of 15
- Rancho Palos Verdes, City of 15
- Carson, City of 15
- Sierra Madre, City of 15
- Windsor, Town of 15
- Manhattan Beach, City of 15
- La Mesa, City of 14
- Walnut Creek, City of 14
- Belmont, City of 14
- Tustin, City of 14
- El Segundo, City of 14
- South Pasadena, City of 14
- West Covina, City of 14
- Pacifica, City of 14
- San Carlos, City of 14
- Atwater, City of 14
- Ripon, City of 14
- Perris, City of 14
- Galt, City of 14
- Beaumont, City of 14
- Riverbank, City of 13
- El Centro, City of 13
- Poway, City of 13
- Monterey Park, City of 13
- Upland, City of 13
- Vista, City of 13
- Brawley, City of 13
- Tulare, City of 13
- Pacific Grove, City of 13
- Menlo Park, City of 13
- Laguna Hills, City of 13
- Norwalk, City of 13
- Sonoma, City of 13
- Pismo Beach, City of 13
- American Canyon, City of 13
- Ceres, City of 13
- Saratoga, City of 13
- Canyon Lake, City of 13
- Eureka, City of 13
- Lancaster, City of 12
- El Cajon, City of 12
- Placentia, City of 12
- Lakewood, City of 12
- Compton, City of 12
- Hawthorne, City of 12
- Martinez, City of 12
- Millbrae, City of 12
- Gilroy, City of 12
- Larkspur, City of 12
- Lompoc, City of 11
- Glendora, City of 11
- San Mateo, City of 11
- Norco, City of 11
- Rosemead, City of 11
- Buena Park, City of 11
- Colton, City of 11
- Brea, City of 11
- San Dimas, City of 11
- Montebello, City of 11
- Inglewood, City of 11
- Walnut, City of 11
- Newark, City of 11
- El Cerrito, City of 11
- Madera, City of 11
- Marysville, City of 11
- La Quinta, City of 11
- Morro Bay, City of 11
- Santee, City of 10
- Imperial, City of 10
- Downey, City of 10
- Yucaipa, City of 10
- Paso Robles, City of 10
- Dinuba, City of 10
- Hemet, City of 10
- Escalon, City of 10
- Santa Fe Springs, City of 10
- Indio, City of 10
- Bell Gardens, City of 10
- Paramount, City of 10
- Palos Verdes Estates, City of 10
- La Mirada, City of 10
- Duarte, City of 10
- Hanford, City of 10
- Los Gatos, Town of 10
- Suisun City, City of 10
- Coachella, City of 9
- Rialto, City of 9
- Santa Paula, City of 9
- Covina, City of 9
- Kerman, City of 9
- El Monte, City of 9
- Rolling Hills Estates, City of 9
- Los Alamitos, City of 9
- Pinole, City of 9
- Signal Hill, City of 9
- Soledad, City of 9
- Tiburon, Town of 9
- Palm Springs, City of 9
- South Gate, City of 9
- Seal Beach, City of 8
- Ojai, City of 8
- Capitola, City of 8
- Exeter, City of 8
- Alhambra, City of 8
- Kingsburg, City of 8
- Lynwood, City of 8
- Yucca Valley, Town of 8
- Agoura Hills, City of 8
- Pico Rivera, City of 8
- Saint Helena, City of 8
- San Anselmo, City of 8
- Colusa, City of 8
- Newman, City of 8
- Lathrop, City of 8
- Fillmore, City of 8
- Montclair, City of 7
- Porterville, City of 7
- Grand Terrace, City of 7
- Barstow, City of 7
- Palm Desert, City of 7
- Livingston, City of 7
- Reedley, City of 7
- Gardena, City of 7
- Monrovia, City of 7
- Calabasas, City of 7
- West Hollywood, City of 7
- Hercules, City of 7
- Healdsburg, City of 7
- Burlingame, City of 7
- Delano, City of 7
- Los Altos, City of 7
- Danville, Town of 7
- California City, City of 7
- Lawndale, City of 7
- Cathedral City, City of 7
- Arroyo Grande, City of 7
- Grover Beach, City of 7
- Menifee, City of 7
- Stanton, City of 7
- Emeryville, City of 7
- Ukiah, City of 7
- National City, City of 6
- Carpinteria, City of 6
- Huntington Park, City of 6
- San Fernando, City of 6
- Selma, City of 6
- Needles, City of 6
- Westlake Village, City of 6
- Blythe, City of 6
- Cotati, City of 6
- Banning, City of 6
- Half Moon Bay, City of 6
- Lomita, City of 6
- King City, City of 6
- Lemon Grove, City of 6
- Sebastopol, City of 6
- Clayton, City of 6
- East Palo Alto, City of 6
- Desert Hot Springs, City of 6
- Los Angeles Department of Recreation and Parks, City of 6
- Yountville, Town of 6
- Waterford, City of 5
- Del Mar, City of 5
- Farmersville, City of 5
- Woodlake, City of 5
- San Pablo, City of 5
- Marina, City of 5
- Highland, City of 5
- Adelanto, City of 5
- Maywood, City of 5
- Albany, City of 5
- Shasta Lake, City of 5
- Avalon, City of 5
- La Canada Flintridge, City of 5
- Bell, City of 5
- Cloverdale, City of 5
- Dixon, City of 5
- Commerce, City of 5
- Campbell, City of 5
- Red Bluff, City of 5
- Gustine, City of 5
- Placerville, City of 5
- Carmel-by-the-Sea, City of 5
- Orland, City of 5
- South El Monte, City of 5
- Imperial Beach, City of 5
- Yreka, City of 5
- Grass Valley, City of 5
- San Gabriel, City of 5
- Scotts Valley, City of 4
- Goleta, City of 4
- Holtville, City of 4
- Lafayette, City of 4
- Baldwin Park, City of 4
- Rio Vista, City of 4
- Corcoran, City of 4
- Corte Madera, Town of 4
- Arvin, City of 4
- Gonzales, City of 4
- Cudahy, City of 4
- Vallejo, City of 4
- Atascadero, City of 4
- Piedmont, City of 4
- Wheatland, City of 4
- Winters, City of 4
- Port Hueneme, City of 4
- Ione, City of 4
- Corning, City of 4
- Calipatria, City of 4
- Tulelake, City of 4
- Fort Bragg, City of 4
- Malibu, City of 4
- South Lake Tahoe, City of 4
- Susanville, City of 4
- Buellton, City of 3
- Lindsay, City of 3
- Solana Beach, City of 3
- Mendota, City of 3
- Rolling Hills, City of 3
- Lemoore, City of 3
- Shafter, City of 3
- Parlier, City of 3
- Live Oak, City of 3
- Firebaugh, City of 3
- Wildomar, City of 3
- Artesia, City of 3
- Rancho Mirage, City of 3
- Anderson, City of 3
- Weed, City of 3
- Lakeport, City of 3
- Irwindale, City of 3
- Crescent City, City of 3
- Williams, City of 3
- Ridgecrest, City of 3
- Orange Cove, City of 3
- Hughson, City of 3
- Hawaiian Gardens, City of 3
- Willows, City of 3
- Angels Camp, City of 3
- Solvang, City of 2
- Dos Palos, City of 2
- Los Angeles - Department of Water and Power, City of 2
- Tehachapi, City of 2
- Pleasant Hill, City of 2
- Loomis, Town of 2
- Temple City, City of 2
- Guadalupe, City of 2
- Oroville, City of 2
- Fowler, City of 2
- Mammoth Lakes, Town of 2
- Willits, City of 2
- La Palma, City of 2
- Sutter Creek, City of 2
- Sonora, City of 2
- Calimesa, City of 2
- Moraga, Town of 2
- Avenal, City of 2
- Alturas, City of 2
- Point Arena, City of 2
- Chowchilla, City of 2
- Del Rey Oaks, City of 2
- San Juan Bautista, City of 2
- Fairfax, Town of 2
- Ross, Town of 2
- Big Bear Lake, City of 2
- Isleton, City of 2
- Colma, City of 2
- McFarland, City of 2
- Nevada City, City of 2
- Clearlake, City of 2
- Jackson, City of 2
- Fortuna, City of 2
- Hesperia, City of 2
- San Joaquin, City of 1
- San Marino, City of 1
- Orinda, City of 1
- Belvedere, City of 1
- Maricopa, City of 1
- Gridley, City of 1
- Sand City, City of 1
- Plymouth, City of 1
- Brisbane, City of 1
- Biggs, City of 1
- Paradise, City of 1
- Blue Lake, City of 1
- Hidden Hills, City of 1
- Amador City, City of 1
- Calistoga, City of 1
- Wasco, City of 1
- Coalinga, City of 1
- La Puente, City of 1
- Mount Shasta, City of 1
- San Francisco, City and County of, Redevelopment Agency 1
- Dorris, City of 1
- La Habra Heights, City of 1
- Los Angeles - Community Redevelopment Agency, City of 1
- Hillsborough, Town of 1
- Laguna Woods, City of 1
- Etna, City of 1
- Ferndale, City of 1
- Tehama, City of 1
- Colfax, City of 1
- Portola, City of 1
- Bishop, City of 1
- Loyalton, City of 1
- Dunsmuir, City of 1
- Bradbury, City of 1
YR_EST 93 ✖
- 0 6,883
- 1973 57
- 1961 47
- 2000 30
- 2004 26
- 1984 24
- 1940 20
- 1960 19
- 1962 18
- 2017 15
- 2018 14
- 1972 11
- 1974 10
- 1991 10
- 1966 9
- 1977 9
- 1978 9
- 1954 8
- 1988 8
- 2015 8
- 2016 8
- 1965 7
- 1969 7
- 1976 7
- 1985 7
- 1989 7
- 2019 7
- 1968 6
- 1970 6
- 1979 6
- 1980 6
- 1999 6
- 2002 6
- 2003 6
- 2007 6
- 2008 6
- 1956 5
- 1971 5
- 1975 5
- 1982 5
- 1983 5
- 1986 5
- 1987 5
- 1990 5
- 1997 5
- 2014 5
- 1955 4
- 1963 4
- 1964 4
- 1981 4
- 1992 4
- 1994 4
- 1996 4
- 1998 4
- 2005 4
- 2012 4
- 1925 3
- 1958 3
- 2001 3
- 2006 3
- 2013 3
- 1920 2
- 1926 2
- 1935 2
- 1939 2
- 1952 2
- 1957 2
- 1967 2
- 1993 2
- 2009 2
- 2011 2
- 1904 1
- 1905 1
- 1907 1
- 1910 1
- 1912 1
- 1914 1
- 1917 1
- 1919 1
- 1922 1
- 1924 1
- 1931 1
- 1933 1
- 1934 1
- 1936 1
- 1941 1
- 1945 1
- 1946 1
- 1947 1
- 1948 1
- 1951 1
- 1995 1
- 2010 1
ACCESS_TYP 3
- Open Access 7,297
- Restricted Access 151
- No Public Access 38
MNG_AG_TYP 1
- City Agency · 7,486 ✖
DES_TP 1
- Local Park · 7,486 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 1 | {"type": "Polygon", "coordinates": [[[-120.84977, 37.77283], [-120.84915, 37.77309], [-120.84786, 37.77119], [-120.84847, 37.77095], [-120.84977, 37.77283]]]} | Open Access 1 | 14 | Oaklawn Memorial Park | 23029 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.595 | Oaklawn Memorial Park | 0 | Local Park 2 | 4 | |
5 | 5 | 4 | {"type": "MultiPolygon", "coordinates": [[[[-118.10598, 33.73945], [-118.10581, 33.73968], [-118.1051, 33.73933], [-118.10527, 33.73909], [-118.10598, 33.73945]]], [[[-118.10701, 33.73996], [-118.10683, 33.7402], [-118.10615, 33.73985], [-118.10632, 33.73962], [-118.10701, 33.73996]]], [[[-118.10746, 33.7402], [-118.10729, 33.74044], [-118.10691, 33.74024], [-118.10708, 33.74], [-118.10746, 33.7402]]]]} | Open Access 1 | 25 | Eisenhower Park | 18475 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | http://www.sealbeachca.gov/living/community/facilities/ | City 2 | 1329 | Seal Beach, City of 3 | City 2 | City Agency 2 | Orange 3 | 1.46 | Eisenhower Park | 0 | Local Park 2 | 4 | |
6 | 6 | 5 | {"type": "MultiPolygon", "coordinates": [[[[-117.11089, 32.73295], [-117.11088, 32.73298], [-117.11086, 32.73286], [-117.1107, 32.73261], [-117.11037, 32.73248], [-117.10993, 32.73245], [-117.10979, 32.73242], [-117.10919, 32.73273], [-117.10874, 32.73272], [-117.10872, 32.73247], [-117.10818, 32.73272], [-117.10811, 32.73272], [-117.10788, 32.73308], [-117.10775, 32.73295], [-117.10773, 32.73295], [-117.1074, 32.73315], [-117.10734, 32.73317], [-117.10705, 32.7334], [-117.10683, 32.73321], [-117.10705, 32.73283], [-117.10727, 32.73261], [-117.10691, 32.73234], [-117.10697, 32.73229], [-117.10703, 32.73226], [-117.10776, 32.73211], [-117.10766, 32.73176], [-117.10765, 32.73157], [-117.10769, 32.73139], [-117.10774, 32.73124], [-117.10782, 32.73111], [-117.10802, 32.73089], [-117.10797, 32.73062], [-117.10803, 32.73067], [-117.10847, 32.7309], [-117.10876, 32.73109], [-117.10866, 32.73109], [-117.10858, 32.73107], [-117.10849, 32.73117], [-117.10866, 32.73138], [-117.10875, 32.73158], [-117.10881, 32.73182], [-117.10883, 32.73208], [-117.10939, 32.73195], [-117.10985, 32.73194], [-117.10996, 32.73191], [-117.11035, 32.73217], [-117.11072, 32.73258], [-117.11089, 32.73286], [-117.11089, 32.73295]]], [[[-117.10995, 32.73399], [-117.10989, 32.73404], [-117.10985, 32.734], [-117.10991, 32.73395], [-117.10995, 32.73399]]]]} | Open Access 1 | 26 | Azalea Neighborhood Park | 30115 | 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 | 9.138 | Azalea Neighborhood Park | 0 | Local Park 2 | 4 | |
8 | 8 | 7 | {"type": "Polygon", "coordinates": [[[-117.70487, 34.09777], [-117.70457, 34.09776], [-117.7046, 34.09775], [-117.70462, 34.09772], [-117.70461, 34.09748], [-117.70381, 34.09747], [-117.7042, 34.09652], [-117.7048, 34.09652], [-117.70482, 34.09772], [-117.70483, 34.09775], [-117.70487, 34.09777]]]} | Open Access 1 | 30 | El Barrio Park | 18477 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 2.099 | El Barrio Park | 0 | Local Park 2 | 4 | |
11 | 11 | 10 | {"type": "Polygon", "coordinates": [[[-117.08431, 32.9339], [-117.08421, 32.93398], [-117.08411, 32.93375], [-117.08393, 32.93344], [-117.08356, 32.93329], [-117.08306, 32.93325], [-117.08297, 32.9331], [-117.08313, 32.93271], [-117.08313, 32.93246], [-117.08292, 32.93223], [-117.08257, 32.9321], [-117.08257, 32.93151], [-117.08386, 32.93278], [-117.08402, 32.93297], [-117.08415, 32.93318], [-117.08425, 32.93342], [-117.0843, 32.93368], [-117.08431, 32.9339]]]} | Open Access 1 | 46738 | Butterfly Mini-Park | 30187 | 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.079 | Butterfly Mini-Park | 0 | Local Park 2 | 4 | |
13 | 13 | 12 | {"type": "Polygon", "coordinates": [[[-120.84861, 37.76492], [-120.8483, 37.76505], [-120.84814, 37.76482], [-120.84845, 37.76468], [-120.84861, 37.76492]]]} | Open Access 1 | 49 | William Meyer Park | 27553 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 0.233 | William Meyer Park | 0 | Local Park 2 | 4 | |
14 | 14 | 13 | {"type": "Polygon", "coordinates": [[[-122.03122, 36.97381], [-122.03122, 36.97381], [-122.03111, 36.97409], [-122.03105, 36.97384], [-122.03122, 36.97381]]]} | Open Access 1 | 42 | Rincon Park | 24369 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.055 | Rincon Park | 0 | Local Park 2 | 4 | |
15 | 15 | 14 | {"type": "Polygon", "coordinates": [[[-120.87737, 37.76176], [-120.87616, 37.76176], [-120.87611, 37.76172], [-120.8761, 37.76055], [-120.87615, 37.76051], [-120.87682, 37.76051], [-120.87688, 37.76054], [-120.87736, 37.76051], [-120.87737, 37.76176]]]} | Open Access 1 | 43 | William A. Fish Veterans Memorial Park | 27537 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.803 | William A. Fish Veterans Memorial Park | 0 | Local Park 2 | 4 | |
16 | 16 | 15 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | 66 | Ambercot Park | 15443 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 4.088 | Ambercot Park | 0 | Local Park 2 | 4 | |
17 | 17 | 16 | {"type": "Polygon", "coordinates": [[[-118.12258, 34.69275], [-118.12251, 34.69275], [-118.1225, 34.69267], [-118.1217, 34.69267], [-118.12164, 34.69261], [-118.12164, 34.69054], [-118.12169, 34.69048], [-118.12257, 34.69049], [-118.12258, 34.69275]]]} | Open Access 1 | 56 | El Dorado Park | 18505 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | http://www.cityoflancasterca.org/index.aspx?page=23 | City 2 | 1169 | Lancaster, City of 11 | City 2 | City Agency 2 | Los Angeles 6 | 5.137 | El Dorado Park | 0 | Local Park 2 | 4 | |
19 | 19 | 18 | {"type": "Polygon", "coordinates": [[[-117.08916, 32.92533], [-117.08917, 32.92536], [-117.08915, 32.92627], [-117.08884, 32.92626], [-117.08902, 32.92612], [-117.08902, 32.926], [-117.08877, 32.92601], [-117.08855, 32.92613], [-117.08872, 32.92567], [-117.0877, 32.92529], [-117.08912, 32.92531], [-117.08916, 32.92533]]]} | Open Access 1 | 46740 | Dry Creek Mini-Park | 30190 | 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 | 1.479 | Dry Creek Mini-Park | 0 | Local Park 2 | 4 | |
20 | 20 | 19 | {"type": "Polygon", "coordinates": [[[-121.7511, 36.90667], [-121.74954, 36.9078], [-121.74933, 36.90761], [-121.75087, 36.90647], [-121.7511, 36.90667]]]} | Open Access 1 | 76 | River Park | 24419 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.349 | River Park | 0 | Local Park 2 | 4 | |
21 | 21 | 20 | {"type": "Polygon", "coordinates": [[[-121.14743, 37.47816], [-121.14709, 37.47823], [-121.14693, 37.47771], [-121.14719, 37.47764], [-121.14726, 37.47767], [-121.14743, 37.47816]]]} | Open Access 1 | 77 | Aurora Park | 15710 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.447 | Aurora Park | 0 | Local Park 2 | 4 | |
22 | 22 | 21 | {"type": "Polygon", "coordinates": [[[-119.79976, 36.71887], [-119.79974, 36.71947], [-119.79972, 36.71963], [-119.7977, 36.7196], [-119.79769, 36.71907], [-119.79807, 36.71906], [-119.79808, 36.71894], [-119.7991, 36.71892], [-119.79911, 36.71887], [-119.79976, 36.71887]]]} | Open Access 1 | 60 | Bigby VIlla Park | 16097 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 3.426 | Bigby VIlla Park | 0 | Local Park 2 | 4 | |
26 | 26 | 25 | {"type": "Polygon", "coordinates": [[[-117.08357, 32.75155], [-117.08352, 32.75156], [-117.08352, 32.75251], [-117.08356, 32.75252], [-117.08356, 32.75298], [-117.08332, 32.75306], [-117.08317, 32.75308], [-117.08165, 32.75308], [-117.08164, 32.75303], [-117.08042, 32.75302], [-117.0804, 32.75307], [-117.07989, 32.75305], [-117.07986, 32.753], [-117.07987, 32.75272], [-117.0797, 32.7518], [-117.07969, 32.75051], [-117.07966, 32.7505], [-117.07967, 32.74994], [-117.08202, 32.74993], [-117.08203, 32.75], [-117.08346, 32.75002], [-117.08348, 32.75006], [-117.08343, 32.75131], [-117.08356, 32.75132], [-117.08357, 32.75155]]]} | Open Access 1 | 89 | Colina Del Sol Community Park | 17497 | 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 | 29.899 | Colina Del Sol Community Park | 0 | Local Park 2 | 4 | |
27 | 27 | 26 | {"type": "Polygon", "coordinates": [[[-118.40012, 33.99275], [-118.39867, 33.9928], [-118.39865, 33.99222], [-118.39914, 33.99221], [-118.39922, 33.99218], [-118.39931, 33.99211], [-118.40012, 33.99275]]]} | Open Access 1 | 78 | El Marino Park | 18512 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | http://www.culvercity.org/Home/Government/PRCS | City 2 | 1075 | Culver City, City of 18 | City 2 | City Agency 2 | Los Angeles 6 | 1.645 | El Marino Park | 0 | Local Park 2 | 4 | |
28 | 28 | 27 | {"type": "Polygon", "coordinates": [[[-117.89558, 33.75242], [-117.89529, 33.75244], [-117.89531, 33.75329], [-117.8936, 33.75333], [-117.89359, 33.75197], [-117.89397, 33.75194], [-117.89398, 33.75162], [-117.89558, 33.75161], [-117.89558, 33.75242]]]} | Open Access 1 | 154 | El Salvador Park | 18538 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | Orange 3 | 7.57 | El Salvador Park | 0 | Local Park 2 | 4 | |
29 | 29 | 28 | {"type": "Polygon", "coordinates": [[[-117.08212, 32.83605], [-117.08201, 32.83608], [-117.08196, 32.83613], [-117.08194, 32.83618], [-117.08196, 32.83628], [-117.08204, 32.83636], [-117.08165, 32.83637], [-117.08171, 32.83615], [-117.08175, 32.8361], [-117.08182, 32.83613], [-117.08206, 32.83602], [-117.08212, 32.83605]]]} | Open Access 1 | 46752 | Corte Playa San Juan Mini-Park | 30203 | 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 | 0.206 | Corte Playa San Juan Mini-Park | 0 | Local Park 2 | 4 | |
30 | 30 | 29 | {"type": "Polygon", "coordinates": [[[-117.28087, 32.84301], [-117.28083, 32.8432], [-117.28076, 32.84327], [-117.28045, 32.84348], [-117.2802, 32.84361], [-117.27997, 32.8438], [-117.27941, 32.8441], [-117.27929, 32.84422], [-117.27922, 32.84424], [-117.27904, 32.84421], [-117.27907, 32.84411], [-117.27939, 32.84394], [-117.27965, 32.84375], [-117.28006, 32.84357], [-117.28036, 32.84341], [-117.28049, 32.84331], [-117.28065, 32.84315], [-117.28083, 32.8429], [-117.28087, 32.84301]]]} | Open Access 1 | 46753 | Cuvier Park | 30204 | 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 | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/cuvier | San Diego 4 | 0.83 | Cuvier Park | 0 | Local Park 2 | 4 |
32 | 32 | 31 | {"type": "Polygon", "coordinates": [[[-121.1459, 37.47051], [-121.14458, 37.47106], [-121.14385, 37.46995], [-121.14391, 37.4699], [-121.1459, 37.47051]]]} | Open Access 1 | 81 | Autumn Royal Park | 15718 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.417 | Autumn Royal Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);