places
1 row where bathroom_info = "Restrooms are located at the Asilomar Conference Grounds across the street" and managment contains "California State Park"
This data as json, CSV (advanced)
Suggested facets: airtable_createdTime (date), managment (array)
| slug ▼ | airtable_createdTime | airtable_id | area | body | country_slug | latitude | longitude | name | region | time_zone | website_url | directions_to_tidepools | address | bathroom_info | bathrooms | header_credit | header_image | parking | temp_reference | managment | open_to_public | phone | visitor_center | cost | hours | directions_latitude | directions_longitude | docents | dogs | food_options | rules_and_collecting | groups | accessibility_and_safety | live_on_site | natalie_visited | pet_policy | radius_km | rules_and_collecting_url | station_id | tagline | tidepool_height | variance_ft | wikipedia | other_names | picnic_options | header_credit_url | official_open | docent_info | webcam_url |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| asilomar-state-beach | 2017-11-26T01:58:20.000Z | recQU4NFdOztao9sg | Carmel/Monterey | Asilomar State Beach is within the boundary of Asilomar Marine Reserve. It was established as a state beach in 1956 and as a Marine Reserve in 2006. This site is a granite outcrop with a good amount of relief. Be prepared to climb over steep rocks. Make certain that anyone coming out to the site has suitable shoes. The entire Monterey Peninsula has fabulous tide pools at low tides. The many small coves of Asilomar State Beach are a good place to focus. A trail meanders along the bluff with easy access to most of the coves. Although the beach is only about a mile long, the amount of life packed into that small space makes Asilomar State Beach one of the richest marine areas in the world. An easily accessible hiking trail wanders along the cliffs and leads down to the coves where the tide pools are found. Couple the trail accessibility and lush seascape with delicious local restaurants like Passionfish and you can easily make a whole day out of your Asilomar tide-pooling adventure. Rocky terrain, crystal clear blue water and tons of sea life inhabit this beach in Monterey Bay. There is ample parking and the beach is even handicap accessible for beach wheelchairs. Watch where you step so that you don’t crush the small creatures that reside there. The Point Pinos Lighthouse is a short walk along the coast but the bathrooms are not close by so plan accordingly. | us | 36.6217613 | -121.9423269 | Asilomar State Beach | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/beach/asilomar-state-beach/ | To reach the tidepools, look for the State Parks marker #10 and continue down that trail straight to the tidepools. | 1950 Sunset Dr. Pacific Grove, | Restrooms are located at the Asilomar Conference Grounds across the street | Nearby | There is ample parking and the beach is even handicap accessible for beach wheelchairs. This site is located at the end of the Monterey Peninsula in Pacific Grove. From Highway 1, take the Highway 68 west exit. Continue on Highway 68 until you reach the light at Sunset Ave and make a left. Continue on Sunset until you see Asilomar beach on your left-hand side. The site will be about a quarter mile past the main beach entrance. If you have reached Pico Ave you have gone too far. Park on the left hand side of sunset ave | ["California State Park", "California State Marine Conservation Area"] | Yes | (831) 646-6440 | 36.6215044 | -121.9412265 | Asilomar State Beach is in a no-take marine protected area,; no collecting of organisms, shells, rocks, driftwood, etc. is permitted. | Accessible parking and tidepools |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [places] ( [airtable_createdTime] TEXT, [airtable_id] TEXT, [area] TEXT, [body] TEXT, [country_slug] TEXT, [latitude] FLOAT, [longitude] FLOAT, [name] TEXT, [region] TEXT, [slug] TEXT PRIMARY KEY, [time_zone] TEXT, [website_url] TEXT, [directions_to_tidepools] TEXT, [address] TEXT, [bathroom_info] TEXT, [bathrooms] TEXT, [header_credit] TEXT, [header_image] TEXT, [parking] TEXT, [temp_reference] TEXT, [managment] TEXT, [open_to_public] TEXT, [phone] TEXT, [visitor_center] TEXT, [cost] TEXT, [hours] TEXT, [directions_latitude] FLOAT, [directions_longitude] FLOAT, [docents] TEXT, [dogs] TEXT, [food_options] TEXT, [rules_and_collecting] TEXT, [groups] TEXT, [accessibility_and_safety] TEXT, [live_on_site] INTEGER, [natalie_visited] INTEGER, [pet_policy] TEXT, [radius_km] FLOAT, [rules_and_collecting_url] TEXT, [station_id] INTEGER, [tagline] TEXT, [tidepool_height] FLOAT, [variance_ft] INTEGER, [wikipedia] TEXT, [other_names] TEXT, [picnic_options] TEXT, [header_credit_url] TEXT, [official_open] INTEGER, [docent_info] TEXT, [webcam_url] TEXT );