places
2 rows where hours = "Sunrise to sunset"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
duxbury-reef | 2017-11-26T01:38:54.000Z | recFNm7Z8NsVjH3jk | Bolinas | Duxbury Reef is a large rock bench platform composed of Monterey Shale, a substrate that is fragile and prone to erosion. Try to hit a low low tide when you plan your trip out to Duxbury Reef. More of the reef will be exposed and it’s quite a sight to see from the trails on the bluff. After you get down to the water level, you’ll see why this is considered one of the top tide pools in the state. Agate Beach is another one of the more secluded tide pool spots located near Bolinas, CA. The beach is the access point to Duxbury Reef, which is the largest reef of its kind in North America. At low tide, you can walk way out on the reef, but be careful not to crunch any barnacles under your toes. What looks like just a plain stretch of rocky shale from far away is actually full of life! You can see mussels, abalones, limpets, sea cucumbers, and an impressive variety of kelp and sea plants. The vivid colors and the amazing diversity of species will keep you curiously hopping from pool to pool until the next high tide kicks you out. This 2-mile ocean shoreline boasts a fantastic tide pool in addition to frequent visitors such as whales, sea lions and many different types of shorebirds. Agate Beach is part of the Duxbury Reef State Marine Sanctuary—the largest soft shale reef in California—which creates an incredibly biodiverse coastal area. A lucky kid exploring the rocky tide pools may come across a giant green anemone which is rumored to measure up to six inches across! <p>Keep a lookout for spiny red starfish that are often seen around these intertidal zones, also the occasional two-spotted octopus which you may be lucky enough to see lurking in a coral burrow.</p> | us | 37.9008566 | -122.7194038 | Duxbury Reef | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/attraction/duxbury-reef-tide-pools/ | Agate Beach is located in Bolinas. On Highway 1, proceed 4.5 miles north of Stinson Beach, then take Olema-Bolinas Road west to Bolinas. Turn left on Elm Road and follow until it to the end. Walk south along the shore at low tide to the adjacent Duxbury Reef. | Ocean Pkwy and Elm Rd, Bolinas, CA 94924 | Portable toilets are located at the north end of the Agate Beach parking lot. | Yes | Parking is $2 or free? | ["California State Marine Conservation Area"] | Yes | (415) 868-1224 | Sunrise to sunset | Duxbury Reef is a State Marine Conservation Area that is part of a new network of marine protected areas established by the state of California. It is illegal to collect anything at Duxbury, with few exceptions for select species such as red abalone and fish (from shore only). | It’s possible to explore in this direction for a long way, but don’t let your route back get cut off by the rising tide. Stay far away from the cliff edges as erosion has undercut them in many places. | Dogs on-leash are permitted. | This is the largest shale reef in North America. It stretches 1000ft from shore to a depth of 13ft. | |||||||||||||||||||||||||
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 );