places
3 rows where bathrooms = "Yes" and picnic_options = "checked"
This data as json, CSV (advanced)
Suggested facets: area, pet_policy, 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 | ||||||||||||||||||||||||||||||||
| dyllon-beach | 2017-11-26T04:55:13.000Z | recxL6HtYD4mOWRId | Bodega bay | Dillon Beach on Bodega Bay is privately-owned by the Dillon Beach Resort, but for a small fee anyone can enjoy this beautiful beach. The beach is located in the small town of Dillon Beach at the northern Marin County coastal border. Dillon Beach gets bigger waves rolling on shore than nearby Lawson’s Landing which has some protection from Tomales Point on Point Reyes Peninsula. For this reason surfers come here when conditions are right. When the tide is low and the surf is too, tide pool exploration is fun. | us | 38.2672745 | -122.9779365 | Dillon Beach | us_pacific_coast | America/Los_Angeles | https://www.californiabeaches.com/beach/dillon-beach/ | The beach is located in the small town of Dillon Beach at the northern Marin County coastal border. Head west on Dillon Beach Road from the town of Tomales on Highway 1 west of Petaluma. Stay left as you head into town and the road leads right to the beach. | 1 Beach Avenue Dillon Beach, CA 94929 | Yes | ["Private"] | Yes | The resort has a quaint little cafe and a general store | Surfing, Bodyboarding, Tidepooling, Bonfires Amenities Restrooms, Picnic Tables, Fire Pits, Cabins / Cottages, Cafe, Store, Tide Pools | Dogs allowed on leash | Privately owned but publicly accessible beach at a resort which has a quaint little cafe, a general store and surf shop, and cabins to rent. | 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/ |
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 );