home / data

Menu
  • GraphQL API

places

Table actions
  • GraphQL API for places

1 row where address = "Highway 1 and Linda Mar Blvd. Pacifica, Ca"

✎ 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
linda-mar-beach 2017-11-26T03:34:05.000Z recq6s1dAcjjZLHUA Bay area Linda Mar Beach (Pacifica State Beach) This surfers’ destination is in a protected cove with a great beach for the kids. There is a small creek that empties into the ocean in the middle of the beach—perfect for little ones who want to get wet but aren’t interested in the waves. If you are there during low tide, head to the southernmost point on the beach and you’ll come across some great tide pools full of all sorts of crabs and sea anemones. Parking is $5 for 4 hours of fun, and if you get hungry there’s even a Taco Bell right on the beach. Cost: $5 for up to 4 hours of parking, or $9 for the whole day Online: us 37.60809 -122.50023 Linda Mar beach us_pacific_coast America/Los_Angeles cityofpacifica.org   Highway 1 and Linda Mar Blvd. Pacifica, Ca         Parking is $5 for 4 hours or $9 for the whole day   ["California State Park"]                   Taco Bell on the beach, Peruvian eatery across the road                                      

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