places
8 rows where bathrooms = "No"
This data as json, CSV (advanced)
Suggested facets: area, managment, dogs, station_id, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| carmet-beach | 2020-08-31T04:40:10.000Z | recafS4y83k3N9lwZ | Bodega bay | us | 38.3714635 | -123.0760829 | Carmet Beach | us_pacific_coast | America/Los_Angeles | A steep trail from the parking lot leads down to the beach and tide pools. Walk down the steep path (at the south end of the parking lot) towards the water. | No | Carmet Beach is located between Jenner and Bodega Bay on Highway One. The site is just north of Carmet Drive and the parking lot across the street from 4790 Highway 1, Bodega Bay, CA 94923. | ["California State Park"] | Carmet Beach is part of the Sonoma Coast State Park. All natural resources here are protected by Federal, State and Park laws. Disturbance or destruction of these resources is strictly forbidden. | |||||||||||||||||||||||||||||||||||
| deer-creek | 2020-08-31T04:30:17.000Z | receyIlJkaz1ScELI | LA | Deer Creek consists of two rocky benches; the larger of the two to the east, the smaller bench to the west. You can reach the site by climbing down the path on the bluffs. In order to get to the larger bench, low tide needs to be below minus 0.8. Above minus 0.8, it's not uncommon for the occasional large wave to wash over the outer end of the rock, creating a safety hazard, or at the very least a drenching hazard. | us | 34.0607009 | -118.9820831 | Deer Creek | us_pacific_coast | America/Los_Angeles | Look for two small bluffs on the ocean side of the Pacific Coast Highway about 1/4 mile south of Deer Creek Road. If you scramble down the west side of the west bluff, you will be at the correct location. Be sure to use caution near the road and going down the steep, rocky path to the beach. | Malibu, CA | The closest restrooms are next to the Neptune’s Net Restaurant, | No | The Deer Creek site is located along the Pacific Coast Highway, .25 mile east of Deer Creek Road and 1.2 miles west of the Neptune’s Net Seafood Restaurant. There are pullouts for parking on the mountain side of the freeway. Be very careful parking on the side of highway. | 34.0610117 | -118.9817794 | In order to get to the larger bench, low tide needs to be below minus 0.8. Above minus 0.8, it's not uncommon for the occasional large wave to wash over the outer end of the rock, creating a safety hazard, or at the very least a drenching hazard. | -0.8 | ||||||||||||||||||||||||||||||
| 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/ | |||||||||||||||||
| frenchys-cove | 2020-08-31T04:23:35.000Z | rec9KANo9J4mnl6in | Anacapa Island | This site is a solid rocky bench located on the south side of West Anacapa Island, within the Channel Islands National Park. Human disturbances include trampling from light visitor use. Travel to and from Anacapa Island offers the opportunity for marine mammal sightings aboard the Island Packers boats. | us | 34.0064594 | -119.4113714 | Frenchy’s Cove | us_pacific_coast | America/Los_Angeles | Frenchy’s Cove is located on West Anacapa Island. Boat transportation to this site from Ventura Harbor is provided through Island Packers. To make reservations call (805) 642-1393. The site is accessed by a five-minute hike from one side of the island to the other, past a site monitored by the Channel Islands National Park. Boat transportation to Frenchy’s Cove, Anacapa Island, is provided through Island Packers. From the beach, take the five-minute hike from the north side of the island through the gap to the south side. There is a trail located at Frenchy’s Cove. Head west across the sandy beach to the second rocky bench. | West Anacapa Island, CA | There are no restrooms at Frenchy’s Cove. Use restrooms on the boat before going ashore. | No | ["National park"] | No | 34.2441623 | -119.2651822 | No | No | There is no food available on the island, you’ll need to bring food with you. | Collecting is not permitted in the National Park.No permit is required for monitoring, but it is important that groups do not disturb the National Park monitoring site. | |||||||||||||||||||||||||||
| 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 | |||||
| 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 | |||||||||||||||||||||||||||||||||
| shark-fin-cove | 2020-09-01T17:34:17.000Z | recbzrTCPYnWVhpAd | Santa Cruz | <p>This is a really pretty beach with shallow pools on algae covered rock benches.</p> <p>The large Shark fin shaped rock used to be part of the mudstone cliff and got its shape from erosion by the wind and waves</p> <p>There are also a small cave on the south east of the beach to explore.</p> | us | 37.003824 | -122.1855372 | Shark Fin Cove | us_pacific_coast | America/Los_Angeles | <p>From the parking lot walk south (left if you face the ocean) down a wide path over railroad tracks to a rather scrambley steep poison-oak lined path that takes you to the beach. You’ll be able to see the shark fin rock from the path. There are three rocky outcrops on the left hand side that have some small tidepools and kelp. </p> | No | Natalie Downe | [{"filename": "2020-09-01 11.23.24.jpg", "height": 2508, "id": "attZW4523qQbUtDKy", "size": 7264655, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/TcDaf6XDlQIEhpBjWd_ERQ/FtCj7WOkHFP_Sek_eHiQ--wGqOFVlL_aCD-W78UVbqYsvf9kHyV1R0U3UsYafpzX-Vpxwg7oEg_MzT0wDUnhaw/ekx-ZyEWTTxjqfy0du5xCtVu2LlS41-UzyYNJXCVZZ8", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/i3b2pFKdYOQUO-ugafbhSQ/6y9co7PVNJl3boT8jgEKE8llBp4HEUmg4dwmJVcs1_sGfXnomRJfnp0EgnQUKDfOQSH-uuQbhH-AissmQy3EgQ/AETIJK04MF6F55_rku2k37mQ3V_2sorNfmneja6zBo0", "width": 747}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/f2D29e1wz2wb2SA6ew1g6w/yw-_hfSL9c0lwYcslkZLKvyYvX_N8sq9l_x8Nsbffn0Q6gsnpstcxGEQbB2cX1z_ZoVKcgZsWNxfVVW-XygwnQ/MscbxvRDftFKCsbgBQS62RrHuLUej6S1KBn8fcIiXJU", "width": 53}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/sjnVyHIAA-BUq7sv3WtDnQ/1XFHNfLtWZG3MxcUVo9kH27CO2kOz_rC9GVmzOD_CMCniOjtpujGW1w5AtbfgGC5wuIrgoCB-tFWbZNZTiJ2l5EuqhXg9q_h--ZM_NyKGf8/HrEyVnlulh-aW71vmlqBxNHHfhScIflrRDXS3LPGA9c", "width": 3660}] | <p>Parking is available in a small dirt lot on the ocean side of highway 1</p> | ["California State Park"] | Yes | No | Free | Sunrise to sunset | 37.005745 | -122.1856066 | No | No | <p>There are some restaurants north in Davenport </p> | This beach forms part of Coast Dairies State Park. No collecting unless you have permission from the state park | Groups are allowed | <p>The path to the beach is quite steep, if you have difficulty walking you will appreciate the use of a stick to get down. Be careful of the prolific poison oak that lines this trail. Once you are on the beach the rocky outcrops are flat but slippery.</p> <p>If you go exploring in the caves be careful of the tide because the sea stacks create dangerous currents and you could be swept away.</p> | 1 | 1 | <p<As a state park unfortunately there are no dogs allowed.</p> | 9413450 | Flat rock outcrops with small tide ‘puddles’ and lots of algae | 1.5 | https://en.m.wikipedia.org/wiki/Coast_Dairies_State_Park | Shark Tooth Beach, Davenport Cove, Jah beach | <p>There is a lovely sandy beach here, great for a picnic! 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 );