places
1 row where pet_policy = "<p>Dogs are allowed on-leash on the beach here.</p>"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pillar-point | 2017-11-26T01:40:59.000Z | recTsm3KeweNFb8eW | Half moon bay | <p>Pillar Point is awesome! there is a lot of variety in the types of pool left by the tide. The left hand side (looking out to sea) has some small pocket pools and a wide flat seagrass bed. there are lots of accessible little pools near the beach and there's a small cut parallel to the beach which is a good place to spot fish.</p> <p>The pools along the deeper ravine at a 90% angle to the beach have giant green anemones, acorn barnacles and is where you'll want to head to find nudibranchs. There are some sea palms and varied fauna on the rocks next to this ravine also.</p> <p>This area is a popular surfing spot, also known as Mavericks when the tide is high and the waves can come in fast and strong so you'll need to watch your back and don't underestimate the tide. The smaller cut parallel to the beach fills in first so do wear water shoes!</p> | us | 37.49542392 | -122.49865193 | Pillar Point | us_pacific_coast | America/Los_Angeles | www.smharbor.com/pillarpoint | <p>Park in the parking lot at the bottom of the radar station if possible, follow the trail at the sea-end of the carpark straight out and along as the path swings to the right around the bluff. The tide pools, shallow-water sea grass beds and a secluded beach are about half a mile or so from the carpark after you pass the jetty on the left.</p> <p>Keep an eye out for shorebirds in the marsh to the left, harbor seals in the secluded harbor before the jetty and nesting great blue herons in the trees on the walk to the tide pools.</p> | Pillar Point Harbor CA | Two porta potties are available in the carpark which is about half a mile from the site. | Yes | <p>Parking available at the radar station and in the overflow carpark. Parking is often full, best to arrive at least an hour before low tide to leave enough time to park and also walk the half mile to the tide pools.</p> | Yes | (650) 726-5727 | No | Free | 37.501768 | -122.496765 | No | Yes | <p>There are lots of restaurants in the nearby town of Granada or in Half Moon Bay.</p> | <p>Please be respectful of the reef and leave anything that is alive or could have alive things in it where they are. Don't move animals between pools, put them back where you found them, it's their home. If you want to fish or collect seaweed or shellfish you need a fishing license.</p> | <p>Groups are allowed, buses must park at the corner of Harvard and West Point.</p> | <p>As tide pools go, this is pretty accessible. It's a bit of a walk on the flat path and there is a bit of beach to navigate to get to the pools, but the pools also have a reasonably flat section. That said, there are some fast flowing cut-throughs to get over if you want to go further out and seasonally some quite slippery seaweed, so a walking stick makes a good companion.</p> <p>The edge of the tide pools nearest to the open ocean on the furthest right hand side (if you are facing out to sea) can be heavily affected by wind and swell, so as always, keep an eye out on the ocean, particularly so if it looks choppy.</p> <p>If you go far out, make sure to watch your exit route to ensure that you don't get cut off by the incoming tide.</p> <p>If you are setting up a picnic don't sit too near to the base of the cliff because erosion can cause dangerous falling rocks.</p> | 1 | 1 | <p>Dogs are allowed on-leash on the beach here.</p> | 0.5 | https://wildlife.ca.gov/Fishing/Ocean | 9414131 | Really varied tidepools with great Nudibranch potential! | 0.5 | 2 | https://en.m.wikipedia.org/wiki/Pillar_Point_Harbor | <p>Lots of space on the beach for picnics, no fires allowed though. Be careful not to sit too close to the cliffs because rock fall is common.</p> | 1 | https://www.surf-forecast.com/breaks/Pillar-Point/webcams/latest |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );