home / data

Menu
  • GraphQL API

places

Table actions
  • GraphQL API for places

2 rows where area = "Morro bay"

✎ 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
hazard-reef 2017-11-26T01:52:02.000Z rec2RkBTtBAslU0PK Morro bay This hidden reef is a hidden gem of the central coast. It’s just a short hike down Hazard Canyon to this point south of Morro Bay. us 35.289479 -120.883857 Hazard reef us_pacific_coast America/Los_Angeles http://www.californiabeaches.com/beach/montana-de-oro-state-park-hazard-canyon-reef/                                                                            
north-point-beach 2017-11-26T01:54:47.000Z rec0kmRncBsXrJBSe Morro bay North Point Natural Area has some great tide pools at low tide. They are located north of Morro Strand State Beach between the towns of Morro Bay and Cayucos. us 35.4197918 -120.8820232 North Point Beach us_pacific_coast America/Los_Angeles http://www.californiabeaches.com/beach/north-point-beach/                                                                            

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