home / data

Menu
  • GraphQL API

places

Table actions
  • GraphQL API for places

1 row where "airtable_createdTime" is on date 2017-11-26 and pet_policy = "Dogs allowed on leish"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: airtable_createdTime (date)

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        

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 89.735ms