home / data

Menu
  • GraphQL API

places

Table actions
  • GraphQL API for places

8 rows where area = "San Simeon"

✎ 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
cayucos-beach 2020-09-02T01:47:55.000Z recoKPGrSfBynJ3gx San Simeon   us 35.4499004 -120.9153318 Cayucos Beach us_pacific_coast America/Los_Angeles     Cayucos Beach, north of pier, free parking, bathrooms, food, crowded, but good cobble tide pools (,)                                                                        
coralina-cove 2020-09-02T01:48:45.000Z recd1gCmgZekQU4pw San Simeon   us 35.260293 -120.8945889 Coralina Cove us_pacific_coast America/Los_Angeles     Montana de Oro Coralina Cove in Montana de Oro, free Parking, bathrooms, 1/2 mile walk to tide pools. (,)p                                                                        
fiscalini-ranch 2020-09-02T01:09:42.000Z recvGJIlcGjvteV4p San Simeon   us 35.5484032 -121.1008331 Fiscalini Ranch us_pacific_coast America/Los_Angeles   <p>Take the Bluff trail north for about half a mile. The entrance to get to the tidepools is hard to find and quite scrabbly to get to the beach level. You can also park at the other trailhead to the north:</p> Cambria, CA   No Natalie Downe [{"filename": "2020-09-01 19.21.40.jpg", "height": 2271, "id": "attOknot9g84icbyc", "size": 5029213, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/y4cuuxnAa9lefTI_sxrbzg/WmloqmBKUTQQQ-p65OHKGslBPpPYQGiMEJGvG8Ne4VpZQT3LDDbokcx3XWchYiX-bNJ9rBbvmNy6ncSoKy2btQ/d5J50REtx_N3SdEE0ejWDX-fbK_Bbo5iAG9AeX1Ten8", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/Cev6hJW4Bwbh7C1zmooPrA/OFnYjEN9QbYAndBY2CWb9qYBUat_JY66xYAE1bIu1-2qTJwLQIJLLRb3rOJAsEp6sotXFGjMTjXviBDVuNzeqA/uEal7qTft3RFdW7395_yTGPHHEKnsl0OUgo4hliIQDY", "width": 883}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/t85hORjrvjh1PBVGwdjaUg/StEO8rg7b2IjBNIEog2wNxgJ0hIHaiACz6QAC7OcYesd4M3rhipU5vTEIUqAs-8f-KOsb8YTx9t3F8aWSaDMcw/Jp-sR6kkF5dZUOq932HEBTNDLvcApRD9O5WSGK1HxPU", "width": 62}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/UhkRdi5KYMvCdJUfhCuM3w/MghnzN7CL2j4cgrGopwJO4OlGWcjicgPobXqVP0lClggXhPt26Xx7AYVjJtLJY-xaNzVUC11F-DqUl1YweOvT4zZAnG1JJ3F8SWBA2bhjmw/r-8GxZsYSy4oq7KhAsipcqfjgK2MdSLaQkE3sZwn940", "width": 3918}] <p>Park on Windsor Blvd</p>   ["Marine reserve"] Yes   No Free   35.547832 -121.097269 No Yes <p>Lots of great food options in nearby Cambria</p> This site forms part of the Monterey bay National Marine Reserve. Absolutely no collecting animals or organic objects of any sort.   <p>The bluff trail is wheelchair accessible but the tidepools are not. Careful on the way down to the beach level as it is quite precarious. Always watch your back with the tide and be careful where you step.</p> 1 1       9412110 Lots of great varied tidepools and all the biodiversity and richness of the central coast.       Otter cove   http://blog.natbat.net/      
harmony-headlands 2020-09-02T01:46:02.000Z recdYhqCho3ng0d0K San Simeon   us 35.4787053 -121.0205771 Harmony headlands us_pacific_coast America/Los_Angeles     Natalie, Harmony Headlands, (,), free parking, no bathrooms, 1 mile walk to shore                                                                        
lampton-cliffs 2020-09-02T01:46:28.000Z recRa5VtLnA3XwkJ5 San Simeon   us 35.5419009 -121.0924447 Lampton Cliffs us_pacific_coast America/Los_Angeles     Natalie, Lampton Cliffs, (,), free parking, no bathrooms, stair access                                                                        
leffingwell 2020-09-02T01:47:18.000Z recmlNf6L3HrIOwOS San Simeon   us 35.58149 -121.1196817 Leffingwell us_pacific_coast America/Los_Angeles     Leffingwell (,), free parking, bathroom                                                                        
san-simeon 2020-08-31T04:32:35.000Z recsMdvJYtGcDhzg1 San Simeon This is a gently undulating rocky area with some high and low areas. The amount of relief to the rocks is fairly minimal to low. As with any site with deep channels, watch the water level as the tide comes in so no one gets stranded! us 35.6041315 -121.1420191 San Simeon us_pacific_coast America/Los_Angeles   There is a public access trail from the intersection of Vista del Mar and Balboa, walk across a vacant lot to the beach. Once on the sandy beach, walk south until you reach a sloping rock platform that rises above the sand.   There are no public restrooms at or near this site. No Natalie Downe [{"filename": "2020-09-01 17.32.01.jpg", "height": 1195, "id": "attZStboyr9Hcu7n6", "size": 2097003, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/w4-5-dSTdjOQ0vP8RtPBBQ/RtBzRI9_ZaG4CysUYTMr69XqEujCDdJK0x-EWYnigFMruTbgLGS3a4WDBV5R9ZnfJ-rxL-JCrs5D2V7VK-z6tw/LiaE2SWfFxtnx-pc5SXrgBmrDkmOmr4YKLYkBu_-4OU", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/uwF1zmIFmiye7q3-ymNylg/lJmglq8kjxsSOEsxNSuxGEqxGrQLj4FnNddBHeRZ2d9VTJqMQuU3raDDxb6UZfngl3oyd9tlirPys5eesyykkQ/o_eyVdN6zG7zq4UXJ_DhWIsRptZdB9qxYVf01S7aXlg", "width": 1425}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/Y2r8GN3hpAMOghk-1Aa6fA/dG_SVR0r0btsNgUoWQnI5lmtLl8I5FxQwjAxCOUOzrkBE_Uxqx6ug9RTBEP9zM6_sm0Mjl8fBH3MZMQJBfBJOw/szUKvjnq_bxM8IY_JNbhQlP5IYOI4Xaq07YkAoSsEqE", "width": 100}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/6MgzSfwgEYwABYjT9e7d-g/xg9YIR5AsKJkzEpSE4qLrw5IUFMcb4rg3dqgcTL7Npe6B5mlJ-Q1gKpWLQ2ydbSbYPQ3TxLf_wj5RxLAr1UEKS1MBXKCOO6k6CARNJ-VzU4/mPdWLyOsm40n_72LJNFdeYyVyeIwAle57tF1qyaJmqw", "width": 3325}] This site is about a quarter of a mile south of the town of San Simeon. From Highway 1 at the Sea Breeze Inn, turn onto on Vista del Mar, the southernmost road in town. Drive to the end of Vista del Mar and park where it meets Balboa.   ["California State Marine Conservation Area"]           35.6096026 -121.1435476       This San Simeon intertidal site is located within the Cambria State Marine Conservation Area. It is part of a network of marine protected areas recently established by the state of Calfornia. Recreational take of living resources is allowed with a valid fishing license; however, all commercial fishing is prohibited       1                     http://blog.natbat.net/      
san-simeon-south 2020-09-02T01:45:58.000Z recy7d9rAGVE0PunR San Simeon   us 35.6043411 -121.1420392 San Simeon south us_pacific_coast America/Los_Angeles   1/2 mile walk from the parking to the tidepools     No     free parking     Yes     Free                     1       9412110                    

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