places
5 rows where dogs = "Yes"
This data as json, CSV (advanced)
Suggested facets: area, bathrooms, station_id, variance_ft, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
arroyo-de-los-frijoles | 2017-11-26T05:36:39.000Z | recDbQJmfGBK4ra5S | Pescadero | Arroyo de los Frijoles Beach is the southern beach at Bean Hollow State Beach. The parking lot is right off Highway 1 about three miles north of the Pigeon Point Lighthouse. At the parking lot above the beach there are picnic tables with barbeques and restrooms nearby. Arroyo del los Frijoles cove has a sandy beach with some rocks near the center and two rocky points closing off the cove a bit from the ocean. This shape of the cove creates a strong rip current so swimming is dangerous here. The creek in Arroyo de los Frijoles flows down to Lake Lucerne Reservoir next to Highway 1 and then hits the beach south of the parking lot entrance. There is a self-guided nature trail that begins at the north part of the beach and follows the bluff between the highway and the ocean all the way to Pebble Beach which is the northern beach of Bean Hollow State Beach. This trail is about one-mile each way making it an easy round-trip from either beach | us | 37.2271268 | -122.4111093 | Arroyo de los Frijoles Beach | us_pacific_coast | America/Los_Angeles | Yes | Yes | Duarte's Tavern Mercado & Taqueria de Amigos | 1 | Dogs allowed on leish | Bean Hollow | checked | ||||||||||||||||||||||||||||||||
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/ | |||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | ||||||||
redondo-beach | 2017-11-26T02:36:14.000Z | recWYDFaFuyJIR9BC | Half moon bay | <p>Beautiful sandstone erosion creates gullies in the cliff face. The tidepool area is quite high and accessible even when the tide isn’t all that low. This makes it a great place for summer Tidepooling.</p> <p>Often one of the less popular beaches in half moon bay, it offers stunning cliff views and exciting wildlife in the tidepools.</p> | us | 37.4365721 | -122.4447811 | Redondo beach | us_pacific_coast | America/Los_Angeles | https://www.californiabeaches.com/beach/redondo-beach-half-moon-bay/ | <p>The smoothest way down to the tidepools is to walk along the scenic bluff trail to Poplar beach (or park there) and take the steps down. It’s a bit of a scrabble but it’s also possible to get closer access from the Redondo parking down one of the many steep ravines that the rain has carved out of the cliff. Wear sturdy shoes and bring a walking stick if you have one.</p> | Redondo Beach Road, Half Moon Bay, | <p>You might be able to find bathrooms nearby with Half Moon Bay being so close.</p> | No | Natalie Downe | [{"filename": "2020-09-08 17.04.50.jpg", "height": 2268, "id": "attxoPAMVDM9pHsYH", "size": 5533607, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/KReFoEg3XVetgqAEKMvHvQ/zLvJYqHVv7DVdbgfe6h8dRbo7M0yc5_83jIyWbkqufsXt_YEZcjkyYw8prfeU18csP0HNwMu1dB34sC7VLsOCQ/sa2U3PsL3yeWaeCgoAToVr_HCy2FIwfUKRbJJ9f1s4Y", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ThbnizTZk_PTzbx4szM5yg/4bnMSHc6TOh2xtpR5MFVlHnINQhd8rZABzwCGlX85DVRM3CNABwAfoLCOs1lGSM4Ri_bU00NARP2xFA4APrIBg/2sKVJ6z4Lhb5NgtVqbFfd1rWuQFXlM2Ef3I7TKh-OSo", "width": 910}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/zZk5ZvCKo44KqZPFxOKhSA/zzH1h54hh7sOxzKmoq3IBuEXwa3IWENOOOSI9-GZpQa0uv53teOlgU0DQgw1Eg61_FGqFYB2HVYNJchgCj1wSA/vjAxqeCGC64NOo8J12WFmQUnTGbXgPnSY7qd2xQ2COw", "width": 64}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/_KZm3fKpy0qP2Qf5RkQ_jQ/9NNSByLM2zzYzFpIXIjStq1kZ6pIV1pNT0MAha_cPeRfOmhtizG5exUsssR3EZo3h3c82T545yCPvQxKr3f7rZNKOp9OqIKIyFuHDwR0ve4/sl1VYE_I-FncSwU9ldgbqKygsnwAy-Rz_eNKtTyOsb0", "width": 4032}] | <p>There is a larger paid parking spot at the Poplar State beach parking on Poplar st but if you are lucky you will be able to get a spot in the small, free, unpaved (and rather bumpy) parking at the end of Redondo Beach Road. Careful how you drive if your car has a low chassis. People park on the side of the road leading up to the carpark also.</p> | ["Coastside Land Trust"] | Yes | No | Free | 37.4392236 | -122.4430648 | No | Yes | <p>Close to Cameron’s Inn but also only about a 10 min drive from lots of dining options in Half Moon Bay.</p> | <p>Please be respectful of the reef, don’t pry any shellfish or creatures off their homes. You’ll need a Fishing license if you want to fish and bear in mind that depending on the time of year shellfish may be poisonous and you could get Paralytic Shellfish poisoning.</p> <p>Watch where you step and don’t step on living things if you can possibly avoid it.</p> | <p>Buses and groups may want to park in the more official car park at the end of Poplar beach road, head down the steps and walk a mile along the beach.</p> | <p>Depending on the route you take down to the beach it can be quite treacherous. Be careful especially if you are going down or back when it is dark. Always watch your step and never turn your back on the tide.</p> | 1 | 1 | Dogs must be on leash | 0.5 | https://en.m.wikipedia.org/wiki/Redondo_Beach,_California | 9414131 | Quiet Tidepooling spot with lots of little pools on a rocky ledge with some stretching out further | 2.0 | 2 | https://en.m.wikipedia.org/wiki/Redondo_Beach,_California | Poplar beach, Half moon bay | <p>Definitely take a picnic here! Sit on the cliff and soak up the incredible views or navigate down to the beach and eat there. No fires allowed.</p> | http://blog.natbat.net/ | 1 |
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 );