places
3 rows where area = "Pescadero" and bathrooms = "Yes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| arroyo-de-los-frijoles | 2017-11-26T05:36:39.000Z | recDbQJmfGBK4ra5S | Pescadero | Arroyo de los Frijoles Beach is the southern beach at Bean Hollow State Beach. The parking lot is right off Highway 1 about three miles north of the Pigeon Point Lighthouse. At the parking lot above the beach there are picnic tables with barbeques and restrooms nearby. Arroyo del los Frijoles cove has a sandy beach with some rocks near the center and two rocky points closing off the cove a bit from the ocean. This shape of the cove creates a strong rip current so swimming is dangerous here. The creek in Arroyo de los Frijoles flows down to Lake Lucerne Reservoir next to Highway 1 and then hits the beach south of the parking lot entrance. There is a self-guided nature trail that begins at the north part of the beach and follows the bluff between the highway and the ocean all the way to Pebble Beach which is the northern beach of Bean Hollow State Beach. This trail is about one-mile each way making it an easy round-trip from either beach | us | 37.2271268 | -122.4111093 | Arroyo de los Frijoles Beach | us_pacific_coast | America/Los_Angeles | Yes | Yes | Duarte's Tavern Mercado & Taqueria de Amigos | 1 | Dogs allowed on leish | Bean Hollow | checked | ||||||||||||||||||||||||||||||||
| pebble-beach | 2017-11-26T05:33:32.000Z | recrVKdoD7nkSOr5i | Pescadero | Pebble Beach is the northern beach in Bean Hollow State Beach in San Mateo County. This is a small cove with a pebbly coarse brown sand. A stair leads down from the small circular parking area to the rocky south end of the cove. Excellent tide pools can be found in the rocks at the south end. Be careful on these rocks as sneaker waves (waves that are larger than normal) can come crashing ashore.This location is also known for tafoni rocks which are uniquely textured sandstone with holes and honeycomb-like structures that have been created through a weathering process. A self-guided nature trail can be found at the circular end of the Pebble Beach access road. This hiking trail continues along the bluff between Highway 1 and the rocky shoreline for about a mile to Arroyo de los Frijoles Beach, the southern beach in Bean Hollow State Beach. | us | 36.561669 | -121.936278 | Pebble beach | us_pacific_coast | America/Los_Angeles | Yes | Natalie Downe | [{"filename": "2020-09-01 10.26.02.jpg", "height": 2630, "id": "attqrwclUbGsvXBfH", "size": 6988001, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/NQKlUcSkbrD2A1ExTqEldA/OweU1ogpCykjV4zhPnK4kbNURDrDQAKqzrqKg2pJOcYEaH9zOm-e5GpNJmF-U71uqiMmgXF0ZUbosjf5JFs_TA/b3ArsCdmSqZbqiPMrL_j8KTfKsgiYUZW_UNrg0_gt5o", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/2zgQFF8JdNIrCJea-Oiw8w/yYAWsg0gf8ro5Fe0nfLmO-MCt9NvWkew4WQc29FtnZUq7DhdU5lzi2kfR8-0K7HZR5uOwfOVNdtF9lclRi6dvg/7M5Q6vNJHYD8-7OIsgK1Jb1tpxK3Y3n0ApW3yx-m90g", "width": 785}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ZdeGN0UVY6kU0Qz45L0PwA/epLYfA8sgJ66z6dqGG_5NEKEfKemnSkSrGUE0V8HQCGjn2R1aMS3rXsGNkwFkqNZiBerrWM8ArjFQv254eFuHQ/4fnhuEN0Kycggxx8s4MzgvDI60UF9edKiYIcfF-wMh8", "width": 55}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/nhvPsau24NoRg90PkB_QsA/WLJZ5bnTV7STAmmCiK37yK6QmoNwmnAr1vOgoq7Z5xdCGvu-Ci6gqf5DlRl59pm52SG09Ht8GeKVqH-rX-6SlkeS_aj5HX-xCFiRsKzm4oc/jAcoe4OBuxv8Kbnptcn51sQhLlc2JUaNPS8ADGaFo4s", "width": 4032}] | No fee for parking | ["California State Park"] | Yes | 1 | Dogs allowed on leash | checked | http://blog.natbat.net/ | |||||||||||||||||||||||||||||
| pescadero-state-beach | 2017-11-26T02:38:06.000Z | recPeqGeNXsAgzaOk | Pescadero | Traveling south from Half Moon Bay, you arrive at Pescadero Rd going towards Pescadero. There is a parking area there off Highway 1. where you can spot sea stars and sea anemones a-plenty. | us | 37.2646157 | -122.4138891 | Pescadero State beach | us_pacific_coast | America/Los_Angeles | http://www.parks.ca.gov/?page_id=522 | Highway 1, Pescadero | Yes | Natalie Downe | [{"filename": "2020-09-01 10.21.09.jpg", "height": 2446, "id": "attk5XKj6t0Xj9j02", "size": 6451666, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/_bfjWdCPmykrbfJj13yyWA/vbcbMLYqgrgXw_rNTWbyaOYfLFnxXW1jjPEd7x3jq-aM-ZdJkjEiuJT6jiBOI0zk9dfB5nyIZsH9MMf9TZnjEg/Tryeh00UIzzioGhoaHLVkGSgO2VvB4QQX9mwutMiL88", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/O7JoadLaUy7hYohayJo3Lg/h_rC4he8n-NNXZ-9msM7cNIE_dfzkfO4ZAz1OyON7FuuOOQEibPe_nEgZZRcSjJJoS8RU2KXH_utooiER_pgHw/anGo7WcUm-wF_tf8DBnI5IJfDqFV4B557c3cYVvy8Zg", "width": 795}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/0tdiQIWRvaNqjHnp0c2rJg/mSUHxUdPA5l_BZ7gMM5ncU-sv5Y8TbLuANMCKCFUMkR8wqMe0rW-46FgB18exlD2EQG6wMm3DDqxRYTV7m-dww/4riAjJQ7WIRke6r13UvE_bO_nNiz13_1qLkTh6q5nfI", "width": 56}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/E_9dAeZLZ_jy1Au5BvloIw/HFBCexMtvZHHCapQL1BmfKvpOD6D9IWpjE-EHxGc9zH1Pe434Yn5ZuItHHDs04F2D-hXHcWLkIoXfS3uNjNyHV_YID6MyJLnh8S56OcFvmo/_yEXMRBcWIrbo6LPqDwMkZBcTsiy-V-1aB6-KxUgldA", "width": 3798}] | Between Half Moon Bay and Santa Cruz is Pescadero State Beach that includes three separate parking lots. The middle lot gives you access to the rocky shore and tide pools. | free guided tours of the marshland on the first Sunday of the month at 10 a.m. | 1 | http://blog.natbat.net/ |
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 );