home / data

Menu
  • GraphQL API

places

Table actions
  • GraphQL API for places

3 rows where area = "Bodega bay"

✎ View and edit SQL

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
carmet-beach 2020-08-31T04:40:10.000Z recafS4y83k3N9lwZ Bodega bay   us 38.3714635 -123.0760829 Carmet Beach us_pacific_coast America/Los_Angeles   A steep trail from the parking lot leads down to the beach and tide pools. Walk down the steep path (at the south end of the parking lot) towards the water.     No     Carmet Beach is located between Jenner and Bodega Bay on Highway One. The site is just north of Carmet Drive and the parking lot across the street from 4790 Highway 1, Bodega Bay, CA 94923.   ["California State Park"]                     Carmet Beach is part of the Sonoma Coast State Park. All natural resources here are protected by Federal, State and Park laws. Disturbance or destruction of these resources is strictly forbidden.                                    
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        
horseshoe-cove 2017-11-26T03:21:15.000Z rec89KiWlMvJxQLhE Bodega bay . The laboratory facilities are located adjacent to Horseshoe Cove and the outer coast. An almost continuous shoreline bench of dioritic granite, most of it exposed to the pounding waves characteristic of the Sonoma coast, supports a diverse community of marine algae and invertebrates. Numerous tidepools and adjacent waters harbor a rich array of fish species, and shorebirds forage on the rocks and in extensive mussel beds during low tides. Bodega marine lab visitor Center is open to public us 38.3155287 -123.0717508 Horseshoe Cove us_pacific_coast America/Los_Angeles http://bml.ucdavis.edu/bmr/location.html   2099 WESTSHORE RD, bodega bay             ["UC Davis"] No (707) 875-2211 checked                                                    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);
Powered by Datasette · Queries took 85.332ms