places

Table actions

1 row where variance_ft = 10

✎ 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
laguna-point 2017-11-26T04:25:04.000Z recodhH8otfeREzP1 Mendocino   us 39.4903913 -123.8026179 Laguna Point us_pacific_coast America/Los_Angeles http://www.parks.ca.gov/?page_id=436 MacKerricher State Park is three miles north of Fort Bragg on Highway 1, near the town of Cleone. Enter the park and drive west to the Seal Watching Station and tidepools at Laguna Point.               ["California State Park"] Yes (707) 964-9112             Yes       There is a wheelchair accessible boardwalk at the point. 1   Dogs on a 6 ft leash     9417426     10   Leguna Point     1    

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
);