places
1 row where managment contains "Private" and open_to_public = "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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 );