units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
647 rows where COUNTY = 17
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, ACRES, LABEL_NAME, YR_EST, GAP_STS
UNIT_NAME 595 ✖
- Hayward Regional Shoreline 5
- Quarry Lakes Regional Recreation Area 4
- Brushy Peak Regional Preserve 3
- Centennial Park 3
- Cesar Chavez Park 3
- Coyote Hills Regional Park 3
- Del Valle Regional Park 3
- Dublin Hills Regional Park 3
- MLK Regional Shoreline 3
- Marina Park 3
- McLaughlin Eastshore State Park 3
- Mission Peak Regional Preserve 3
- Sunol Regional Wilderness 3
- Adobe Park 2
- Bethany Reservoir State Recreation Area 2
- Chabot - Garin Trail Corridor 2
- Civic Center Park 2
- Contra Costa Rock Park 2
- Crown Memorial Regional Shoreline 2
- Cull Canyon Regional Recreation Area 2
- Don Edwards National Wildlife Refuge 2
- Estuary Park 2
- Franklin Park 2
- Garin Regional Park 2
- Hayward Shoreline 2
- Lakeshore Park 2
- Las Trampas Wilderness Regional Preserve 2
- McKinley Park 2
- Oak Park 2
- Oakport Field 2
- Ohlone Regional Wilderness 2
- Pleasanton Ridge Regional Park 2
- Rancho Arroyo Park 2
- Redwood Regional Park 2
- Sibley Volcanic Regional Preserve 2
- Sycamore Grove Park 2
- 25th St. Mini Park 1
- 35th Avenue Plaza 1
- 61st Street Mini Park 1
- 63rd Street Mini-Park 1
- 85th Avenue Mini Park 1
- 88th Avenue Mini Park 1
- Accinelli Park 1
- Adams Park 1
- Adventure Playground 1
- Al Caffodio Park 1
- Alameda Creek Regional Trail 1
- Alamo Creek Park 1
- Albany Hill Park 1
- Albany Memorial Park 1
- Albany State Marine Reserve 1
- Alden E. Oliver Sports Park 1
- Allendale Park 1
- Almond Park 1
- Altamont Creek Park 1
- Amador Valley Community Park 1
- Amaral Park 1
- Anthony Chabot Regional Park 1
- Aquatic Park 1
- Ardenwood Historic Farm 1
- Arroyo Agua Caliente Park 1
- Arroyo Mocho 1
- Arroyo Park 1
- Arroyo Viejo Park 1
- Ash Street Park 1
- Ashland Park 1
- Athol Plaza Park 1
- Augustin Bernal Park 1
- Avenue Terrance Park 1
- Azevada Park 1
- BMX Facility 1
- BROOKDALE PARK 1
- Bateman Mall Park 1
- Bateman Park 1
- Bay Trees Park 1
- Bayport Park 1
- Beach Play Field 1
- Beaconsfield Canyon 1
- Beaumont Park 1
- Bechtel Mini Park 1
- Becky Temko Tot Park 1
- Begin Plaza Park 1
- Bella Vista Park 1
- Berkeley Rose Garden 1
- Berkeley Way Mini-Park 1
- Bertha Port Park 1
- Bicentennial Park 1
- Bidwell Park 1
- Big Trees Park 1
- Bill Ball Civic Park 1
- Bill Clark Park 1
- Birch Grove Park 1
- Birchfield Park 1
- Blacow Park 1
- Bonaire Park 1
- Booster Park 1
- Bothwell Recreation Center 1
- Bray Commons Park 1
- Brenkwitz School Park 1
- Bridgepointe Park 1
- Brookvale Park 1
- Brookvale Trail 1
- Bruno Canziani Park 1
- Brushy Peak 1
- Buena Vista Park 1
- Burckhalter Recreation Area 1
- Bushrod Recreation Center 1
- Byington Park 1
- Byron Conservation Bank 1
- Cabrillo Park 1
- Cabrillo Trail 1
- California Nursery Historic Park 1
- California Terrace Park 1
- Callippe Preserve Golf Course 1
- Cannery Park 1
- Canyon View Park 1
- Carlos Bee Park 1
- Carnegie Park 1
- Carnegie State Vehicular Recreation Area 1
- Carney Park 1
- Casa Verde Park 1
- Castro Valley Creek Park 1
- Castro Valley Park and Community Center 1
- Cedar-Rose Park 1
- Centerville Community Park 1
- Central Reservoir Park 1
- Cerruti Park 1
- Chabot Park 1
- Channel Park 1
- Charles F. Kennedy Park 1
- Charlie Dorr Mini-Park 1
- Cherry Grove Park 1
- Cherryland Park 1
- Cherrywood Park 1
- Chinese Garden Park 1
- Christensen Park 1
- Christensen Road Burrowing Owl Site 1
- Christian Penke Park 1
- Christie Park 1
- City Hall Plaza 1
- City View Skate Park 1
- Civic Park 1
- Claremont Canyon Regional Preserve 1
- Claremont Canyon Regional Reserve 1
- Cleveland Park 1
- Clifton Court Forebay 1
- Clinton Park 1
- Coaches Field 1
- Codornices Park 1
- Colby Park 1
- Coliseum Gardens Park 1
- College Heights Park 1
- Colonial Acres School Park 1
- Columbian Gardens Park 1
- Concordia Park 1
- Contempo Park 1
- Courthouse Landing Park 1
- Courtland Creek Park 1
- Coyote Hills 1
- Cragmont Rock Park 1
- Crandall Creek Park 1
- Creekside Park 1
- Cresent Park 1
- Crocker Park 1
- Curt Flood Field 1
- Cypress Freeway Memorial Park 1
- Davenport Park 1
- David Jones Park 1
- Dayton Playground 1
- De Anza Park 1
- DeFremery Park 1
- Decoto Plaza Park 1
- Deep Creek Park 1
- Deerview Park 1
- Del Prado Park 1
- Del Rey Park 1
- Delucchi Park 1
- Devany Square 1
- Dimond Canyon Park 1
- Doc Harrington Park 1
- Dolan Park 1
- Dolphin Mini Park 1
- Don Castro Regional Recreation Area 1
- Doolan Canyon Regional Preserve 1
- Dorothy Bolte Park 1
- Dougherty Hills Dog Park 1
- Dougherty Hills Open Space 1
- Dover Street Park 1
- Doyle Hollis Park 1
- Dracena Park 1
- Drigon Dog Park 1
- Dry Creek Pioneer Regional Park 1
- Dublin Heritage Park & Museums 1
- Dublin Sports Grounds 1
- Dunsmuir Estate Park 1
- Durant Mini Park 1
- EBMUD 1
- Earl Warren Park 1
- East Avenue Park 1
- East Avenue School Park 1
- East Bay Gateway Shoreline 1
- East Bay Greenway Trail Corridor 1
- Eden Greenway 1
- Eden Landing Ecological Reserve 1
- Edendale Park 1
- El Padro Park 1
- El Rancho Verde School Park 1
- Eldridge Park 1
- Elmhurst Plaza 1
- Emerald Glen Park 1
- Emeryville Crescent State Marine Reserve 1
- Eucalyptus Grove Park (North) 1
- Eucalyptus Grove Park (South) 1
- F. M. SMITH PARK 1
- Fairlands Park 1
- Fairmont Linear Park 1
- Fairmont Terrace Park 1
- Fairview Park 1
- Fairway Greens Park 1
- Fallon Sports Park 1
- Fawn Hills Park 1
- Fitzgerald Park 1
- Five Canyons Park 1
- Five Canyons trail corridor 1
- Florest Park 1
- Frank Fischer Park 1
- Fred Castro Park 1
- Frederick Mini-Park 1
- Fremont Central Park 1
- Fremont Park Golf Club 1
- Fruitvale Bridge Park 1
- Gansberger Park 1
- Garaventa Wetlands Preserve 1
- Garber Park 1
- Garfield Park 1
- Gateway Gardens 1
- George Florence Park 1
- Glen Echo Park 1
- Glendale-La Loma Park 1
- Godfrey Park 1
- Golden Gate Recreation Center 1
- Gomes Park 1
- Gordon E. Oliver Eden Shores Park 1
- Great Stoneface Park 1
- Greenbelt Hiking & Riding Trail 1
- Greenman Field 1
- Greenridge Park 1
- Greenwood Park 1
- Greg Brown Mini-Park 1
- Grizzly Peak Park 1
- Grotto Rock Park 1
- Grove Park 1
- Grove Shafter 1
- HOA Community Park 1
- Hagemann 1
- Halcyon Commons 1
- Halcyon Park 1
- Hall Ranch Park 1
- Hansen Park 1
- Hardy Dog Park 1
- Harrison Park 1
- Harvest Park 1
- Haskell-Mabel Mini-Park 1
- Haymont Mini Park 1
- Hayward Memorial Park 1
- Heath Park Tennis Courts 1
- Heatherlark Park 1
- Helen McGregor Plaza Park 1
- Hellman Recreation Area 1
- Heritage Oak Park 1
- Hesperian Park 1
- Hill Face Open Space City of Fremont 1
- Hillcrest Knolls Park 1
- Holly Community Center 1
- Hooly Mini Park 1
- Horseshoe Park 1
- Ida Holm 1
- Independence Park 1
- Indian Rock Park 1
- Ira Jenkins Park 1
- Irvington Park 1
- Irvington Plaza 1
- Isherwood Park 1
- J.A. Lewis Park 1
- Jack Holland Sr. Park 1
- Jack Williams 1
- Jackson Park 1
- Jalquin Vista Park 1
- James Kenney Park 1
- Japanese Gardens 1
- Jefferson Square 1
- Joaquin Miller Park 1
- John Hinkel Park 1
- Jordan Ranch Park 1
- Karl Wente Park 1
- Kennedy Park 1
- Kennedy Tract Park 1
- Kings Estate 1
- Knowland Park/Oakland Zoo 1
- Kolb Park 1
- Kottinger Park 1
- Krusi Park 1
- La Placita Mini Park 1
- Lafayette Square 1
- Lake Del Valle SRA 1
- Lake Del Valle State Recreation Area 1
- Lake Merritt 1
- Lakeridge Park 1
- Lakeside Park 1
- Las Positas Golf Course 1
- Lasear Park 1
- Laurel Creek Park and Staging Area 1
- Leona Heights 1
- Leona Heights Regional Open Space 1
- Lester J. Knott Park 1
- Leydecker Park 1
- Liberty Park 1
- Library Park 1
- Lincoln Park 1
- Lincoln Square 1
- Linda Park 1
- Linden Park 1
- Linear Park 1
- Lions Wayside Park 1
- Littlejohn Park 1
- Live Oak Memorial Pool 1
- Live Oak Park 1
- Livermore Downs 1
- Livermore Monitoring Station 1
- Livermore holding 1 1
- Lone Tree Creek Park 1
- Longfellow Park 1
- Longwood Park 1
- Los Cerritos Community Park 1
- Los Vaqueros Watershed 1
- Lowell Park 1
- Lowry Park 1
- Lyons Field Park 1
- MLK Memorial Park (Civic Center) 1
- MacGregor Playfields 1
- Madeira Park 1
- Madeiros Parkway 1
- Madison Square 1
- Main Street Dog Park 1
- Main Street Soccer Field 1
- Maitland R. Heary 1
- Mandana Plaza Park 1
- Mandela Parkway 1
- Manzanita Recreation Center 1
- Mape Memorial Park 1
- Marina Cove Waterfront Park 1
- Marina Mall 1
- Mariner Park 1
- Marlin A. Pound Park 1
- Marshall Park 1
- Marston Campbell Park 1
- Martin Luther King Field 1
- Max Baer Park 1
- Maxwell Park 1
- Mayhews Landing Park 1
- Mc Conaghy Park 1
- Mc Crea Park 1
- McCartney Park 1
- McClymonds Mini Park 1
- McKinley Playground 1
- Meadowlark Park 1
- Meadows Park 1
- Meek Park 1
- Memorial Park 1
- Mervin Morris Park 1
- Middle Harbor Shoreline Park 1
- Mirabeau Park 1
- Mission Hills Golf Course 1
- Mission Hills Park 1
- Mission San Jose Community Park 1
- Mocho Park 1
- Moller Park 1
- Monkey Island Park 1
- Montclair Park 1
- Morcom Rose Garden 1
- Morgan Plaza 1
- Mortar Rock Park 1
- Mosswood Park 1
- Mt. Eden Park 1
- Muirwood Park 1
- Mulford Park 1
- Multipurpose Field 1
- Musick Park 1
- Neptune Park 1
- Newark Community Park 1
- Newark Sportsfield Park 1
- Nicol Park 1
- Nielsen Park 1
- Niles Community Park 1
- Niles Town Plaza 1
- Noll Park 1
- Nordvik Park 1
- North Oakland Sports Center 1
- Northfront Park 1
- Northgate Park 1
- Northgate Trail 1
- Nuestro Parquecito 1
- Oak Glen Park 1
- Oak Grove Park 1
- Oakhill Park 1
- Ocean View Park 1
- Ohlone Greenway 1
- Ohlone Park 1
- Old Alvarado Park 1
- Old Highlands Park 1
- Old Mission Park 1
- Oliver Property 1
- Opal Staniek Tot Lot 1
- Orloff Park 1
- Ostrander Park 1
- Owens Plaza Park 1
- Oyster Bay Regional Shoreline 1
- Pacific Commons Sports Park 1
- Pacific Point Park 1
- Pacific Recreation Complex 1
- Palma Ceia Park 1
- Palomares Hills Park 1
- Palomares Ridge 1
- Park Boulevard Plaza Park 1
- Park Ridge Park 1
- Parsons Park 1
- Passatempo Park 1
- Patterson Park 1
- Peladeau Park and Greenway 1
- Peoples Park 1
- Peralta Hacienda Park 1
- Peralta Park 1
- Peralta/Dusterberry Park 1
- Peregrine Park 1
- Piazza Sorrento 1
- Piedmont Park 1
- Piedmont Sports Fields 1
- Pine Knoll Park 1
- Pinto Park 1
- Pioneer Park 1
- Plaza Park 1
- Pleasanton holding 1 1
- Pleasanton holding 3 1
- Pleasanton holding 4 1
- Pleasure Island 1
- Plomosa Park 1
- Poaks Headquarters 1
- Point Emery Park 1
- Ponderosa Park 1
- Poplar Park 1
- Port View Park 1
- Portola Park 1
- Positano Hills Park 1
- Presentation Mini-Park 1
- Pride Rock Park 1
- Prince Street Mini-Park 1
- Raimondi Park 1
- Rainbow Recreation Center 1
- Ralph T. Wattenburger Park 1
- Ralph and Mary Ruggieri Senior Center 1
- Rancho Higuera Park 1
- Ravenswood Historic Site 1
- Redondo Park 1
- Redwoods Heights Recreation Center 1
- Remillard Park 1
- Rittler Park 1
- Rix Park 1
- Robert Livermore Park 1
- Robertson Park 1
- Rockridge Park 1
- Root Park 1
- Rowell Ranch Rodeo Park 1
- Ruus Park 1
- SFPUC Alameda Watershed 1
- Sabercat Historic Park 1
- San Andreas Park 1
- San Antonio Park 1
- San Felipe Park 1
- San Francisco Bay 1
- San Francisco Watershed Lands 1
- San Leandro holding 1 1
- San Lorenzo Community Park 1
- San Pablo Park 1
- Sanborn Park 1
- Schaefer Ranch Park 1
- Schafer Park 1
- Sea Breeze Park 1
- Sean Diamond Park 1
- Seven Hills Park 1
- Shadow Cliffs Regional Recreation Area 1
- Shannon Park 1
- Sheffield Village Park 1
- Shepherd Canyon Park 1
- Shin Historic Park 1
- Shorebird Park 1
- Shoreline Park 1
- Shorty Garcia Park 1
- Siempre Verde Park 1
- Silver Star Veterans Park 1
- Skywest Golf Course 1
- Snow Park 1
- Sobrante Park 1
- Soccer Field 1
- Solano-Peralta Park 1
- Sorensdale Park 1
- South Prescott Park 1
- Southgate Park 1
- Splash Pad Park 1
- Sports and Recreation Park 1
- Spring Grove Park 1
- St Andrews Plaza 1
- Stagecoach Park 1
- Stanford Park 1
- Stenzel Park 1
- Stonehurst Park 1
- Stonybrook Park 1
- Stratford Village Park 1
- Strawberry Creek Park 1
- Sugar Mill Landing Park 1
- Sulfur Springs Park 1
- Sulphur Creek Nature Center 1
- Summit Park 1
- Sunken Gardens 1
- Sunset Park 1
- Surry Park 1
- Sutter Creek Gate Park 1
- Sylvester Harvey Park 1
- Taper Park Property 1
- Tassafaronga Park 1
- Tassajara Creek Regional Park 1
- Tawny Park 1
- Ted Fairfield Park 1
- Temescal Creek Park 1
- Temescal Regional Recreation Area 1
- Tennis & Community Park 1
- Tennyson Park 1
- Terrace Park 1
- Terrace View Park 1
- Tex Spruiell Park 1
- Thrasher Park 1
- Tidewater Park 1
- Tilden Regional Park 1
- Tillman Park 1
- Tom Bates Regional Sports Complex 1
- Tomas Melero-Smith Park 1
- Towata Park 1
- Town Estates Park 1
- Toyon Park 1
- Twin Bridges Park 1
- Union Landing Park 1
- Union Plaza 1
- Union Point Park 1
- University Park 1
- University of California Botanical Garden at Berkeley 1
- Unknown park - Livermore, City of 1
- Unnamed Site - Fremont, City of 1
- Unnamed site - Alameda County Flood Control and Water Conservation District 1
- Upper Pleasanton Field 1
- Val Vista Park 1
- Valle Vista Park 1
- Vallejo Mill Historical Park 1
- Vallejo Mill Park 1
- Valley Trails Park 1
- Valley View Park 1
- Vantage Point Park 1
- Vargas Plateau Regional Park 1
- Verdese Carter Park 1
- Veterans Park 1
- Veterans Plaza 1
- Victoria Park 1
- Vintage Hills Park 1
- Virginia-McGee Totland 1
- Vista Meadows Park 1
- Wade Johnson Park 1
- Walnut Grove Park 1
- Warbler Park 1
- Warden Park 1
- Warm Springs Park 1
- Washington Manor 1
- Washington Park 1
- Weekes Park 1
- Weibel Historic Park 1
- West Oakland Park and Urban Farm 1
- Westridge Park 1
- Willard Park 1
- William Cann Civic Center Park 1
- William Cann Memorial Park 1
- William J. (Bill) Payne 1
- Williams Historical Park 1
- Willow Mini Park 1
- Willow Park 1
- Windflower Park 1
- Wood Park 1
- Woodstock Park 1
- Woodthrush Park 1
DES_TP 57
- Local Park 478
- Local Recreation Area 67
- Local Conservation Area 22
- Local Other or Unknown 10
- Local Historic or Cultural Area 8
- Private Recreation or Education 5
- State Recreation Area 3
- State Resource Management Area 3
- Local Resource Management Area 2
- National Wildlife Refuge 2
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Private Agricultural 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 31
- Oakland, City of 122
- Hayward Area Recreation and Park District 84
- East Bay Regional Park District 77
- Fremont, City of 58
- Berkeley, City of 49
- Pleasanton, City of 44
- Livermore, City of 35
- Union City, City of 34
- Alameda, City of 28
- San Leandro, City of 23
- Dublin, City of 21
- Newark, City of 14
- Livermore Area Recreation and Park District 13
- Emeryville, City of 8
- Albany, City of 7
- Piedmont, City of 7
- California Department of Fish and Wildlife 4
- San Francisco - Public Utilities Commission, City and County of 2
- United States Fish and Wildlife Service 2
- California Department of Parks and Recreation 2
- University of California 2
- California Department of Water Resources 2
- Liberty Park Homeowners Association 1
- East Bay Municipal Utility District 1
- Tri-Valley Conservancy 1
- Alameda County Flood Control and Water Conservation District 1
- Private Landowner 1
- Marcella Renaissance Owners Association 1
- Lakeshore Homes Association 1
- Contra Costa Water District 1
- City Slicker Farms 1
MNG_AG_TYP 11
ACCESS_TYP 3
- Open Access 591
- Restricted Access 31
- No Public Access 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-121.91483, 37.63509], [-121.91478, 37.64364], [-121.9097, 37.64611], [-121.90561, 37.63248], [-121.90568, 37.63243], [-121.91279, 37.63249], [-121.9128, 37.63255], [-121.91326, 37.63289], [-121.91409, 37.63322], [-121.91427, 37.63348], [-121.91481, 37.63393], [-121.91472, 37.63444], [-121.91458, 37.63451], [-121.91479, 37.63476], [-121.9147, 37.63482], [-121.91478, 37.63509], [-121.91483, 37.63509]]]} | Open Access 1 | 185 | Augustin Bernal Park | 8732 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/services/recreation/rec-augustinpark.html | Alameda 17 | 217.388 | Augustin Bernal Park | 0 | Local Park 2 | 4 |
146 | 146 | 145 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.79003], [-122.24099, 37.79152], [-122.23911, 37.7904], [-122.24053, 37.78891], [-122.24241, 37.79003]]]} | Open Access 1 | 366 | San Antonio Park | 24832 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 10.619 | San Antonio Park | 0 | Local Park 2 | 4 | |
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
394 | 394 | 393 | {"type": "Polygon", "coordinates": [[[-121.90274, 37.6751], [-121.89877, 37.67675], [-121.89728, 37.6759], [-121.89877, 37.67439], [-121.89993, 37.67487], [-121.90048, 37.67498], [-121.90108, 37.67494], [-121.90163, 37.67477], [-121.90224, 37.67434], [-121.90254, 37.67469], [-121.90274, 37.6751]]]} | Open Access 1 | 1438 | Tennis & Community Park | 26243 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 15.595 | Tennis & Community Park | 0 | Local Park 2 | 4 | |
409 | 409 | 408 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | 48353 | Sean Diamond Park | 32917 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | Alameda 17 | 4.986 | Sean Diamond Park | 2018 | Local Park 2 | 4 |
480 | 480 | 479 | {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} | Open Access 1 | 1631 | Tillman Park | 26365 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.586 | Tillman Park | 0 | Local Park 2 | 4 | |
490 | 490 | 489 | {"type": "Polygon", "coordinates": [[[-122.14785, 37.69505], [-122.1456, 37.69512], [-122.14527, 37.69542], [-122.14472, 37.69503], [-122.1447, 37.69334], [-122.14783, 37.69326], [-122.14785, 37.69505]]]} | Open Access 1 | 1962 | Washington Manor | 27270 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 13.829 | Washington Manor | None 51 | |||
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 3.419 | Poaks Headquarters | None 57 | |||
681 | 681 | 680 | {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19031, 37.73606], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} | Open Access 1 | 3504 | Ira Jenkins Park | 20226 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 15.161 | Ira Jenkins Park | 0 | Local Park 2 | 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 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
813 | 813 | 812 | {"type": "Polygon", "coordinates": [[[-121.78193, 37.67297], [-121.78197, 37.67334], [-121.78197, 37.67383], [-121.78189, 37.67423], [-121.78035, 37.67389], [-121.78048, 37.67298], [-121.78193, 37.67297]]]} | Open Access 1 | 5241 | Mocho Park | 22336 | 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 | 4.098 | Mocho Park | 0 | Local Park 2 | 4 | |
816 | 816 | 815 | {"type": "Polygon", "coordinates": [[[-121.80478, 37.67824], [-121.80306, 37.67892], [-121.80129, 37.67953], [-121.80062, 37.67969], [-121.79957, 37.67975], [-121.79748, 37.67946], [-121.79627, 37.67965], [-121.7953, 37.67994], [-121.79396, 37.67982], [-121.79254, 37.67974], [-121.7915, 37.67976], [-121.79158, 37.67946], [-121.79158, 37.67939], [-121.79205, 37.6795], [-121.79326, 37.67955], [-121.79464, 37.67963], [-121.79547, 37.6796], [-121.79602, 37.67934], [-121.7967, 37.67905], [-121.79774, 37.6791], [-121.79887, 37.67934], [-121.79991, 37.67942], [-121.80079, 37.67936], [-121.80188, 37.67901], [-121.80281, 37.67855], [-121.80429, 37.6779], [-121.80478, 37.67824]]]} | Open Access 1 | 5263 | Arroyo Mocho | 15613 | 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 | 10.963 | Arroyo Mocho | None 75 | |||
855 | 855 | 854 | {"type": "Polygon", "coordinates": [[[-122.18754, 37.70419], [-122.18658, 37.70459], [-122.18625, 37.70409], [-122.18721, 37.70369], [-122.18754, 37.70419]]]} | Open Access 1 | 24933 | Mulford Park | 22589 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 1.495 | Mulford Park | 0 | Local Park 2 | 4 | |
864 | 864 | 863 | {"type": "Polygon", "coordinates": [[[-122.29161, 37.89499], [-122.29154, 37.89662], [-122.28999, 37.89658], [-122.29007, 37.89494], [-122.29161, 37.89499]]]} | Open Access 1 | 5579 | Albany Memorial Park | 15328 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | Alameda 17 | 6.13 | Albany Memorial Park | 1920 | Local Park 2 | 4 | |
1101 | 1101 | 1100 | {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} | Open Access 1 | 15630 | Haymont Mini Park | 19758 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.431 | Haymont MP | 0 | Local Park 2 | 4 | |
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
1226 | 1226 | 1225 | {"type": "Polygon", "coordinates": [[[-122.2621, 37.81037], [-122.26187, 37.81046], [-122.26141, 37.8104], [-122.26121, 37.81003], [-122.26124, 37.80951], [-122.26139, 37.80882], [-122.26145, 37.80722], [-122.26125, 37.80701], [-122.26115, 37.80678], [-122.26059, 37.80677], [-122.26018, 37.80656], [-122.26, 37.80604], [-122.25945, 37.80556], [-122.25897, 37.80479], [-122.25862, 37.80467], [-122.25787, 37.80485], [-122.2566, 37.80538], [-122.25631, 37.8057], [-122.25625, 37.80655], [-122.25573, 37.80703], [-122.25541, 37.80719], [-122.25475, 37.80716], [-122.254, 37.80703], [-122.25305, 37.80712], [-122.25224, 37.80751], [-122.25146, 37.8081], [-122.25109, 37.80815], [-122.24995, 37.80847], [-122.24972, 37.80838], [-122.24972, 37.80785], [-122.24999, 37.80721], [-122.2503, 37.80668], [-122.25074, 37.80566], [-122.2511, 37.80499], [-122.25117, 37.80494], [-122.2534, 37.80418], [-122.25372, 37.80369], [-122.2539, 37.80321], [-122.25472, 37.80211], [-122.25473, 37.80206], [-122.25483, 37.80191], [-122.25473, 37.80158], [-122.25473, 37.80085], [-122.25507, 37.80057], [-122.25551, 37.80043], [-122.25654, 37.80053], [-122.25712, 37.80039], [-122.25836, 37.79968], [-122.25882, 37.7992], [-122.25917, 37.79895], [-122.26125, 37.79996], [-122.26139, 37.80021], [-122.26151, 37.80087], [-122.2613, 37.80222], [-122.26104, 37.80261], [-122.26049, 37.80382], [-122.26049, 37.80451], [-122.26147, 37.80527], [-122.26245, 37.80641], [-122.2628, 37.80726], [-122.2628, 37.80815], [-122.2626, 37.8087], [-122.26228, 37.81014], [-122.2621, 37.81037]]]} | Open Access 1 | 8847 | Lake Merritt | 20953 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 141.432 | Lake Merritt | 1957 | None 107 | ||
1246 | 1246 | 1245 | {"type": "Polygon", "coordinates": [[[-122.27628, 37.89224], [-122.2759, 37.8923], [-122.27586, 37.89215], [-122.2762, 37.89203], [-122.27628, 37.89224]]]} | Open Access 1 | 44896 | Contra Costa Rock Park | 17607 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.169 | Contra Costa Rock Park | 0 | Local Park 2 | 4 | |
1390 | 1390 | 1389 | {"type": "Polygon", "coordinates": [[[-121.79075, 37.65873], [-121.78962, 37.65876], [-121.78926, 37.6589], [-121.78862, 37.65791], [-121.79066, 37.65786], [-121.79072, 37.65809], [-121.79075, 37.65873]]]} | Open Access 1 | 12195 | Jack Williams | 20314 | 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 | 3.928 | Jack Williams | None 118 |
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]);