places
2 rows where area = "Jenner"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| gerstle-cove-marine-reserve | 2017-11-26T02:41:00.000Z | recCjuA1Lj1TmJV5z | Jenner | If you’re in the mood for a bit of a road trip, Salt Point State Park offers a chance to see tide pools away from the Bay Area crowds. The park is located about twenty miles north of Jenner, CA and almost one hundred miles north of San Francisco. At low tide, you can see many marine animals exposed on the rocks in the intertidal zone. If the tide is too high for tide pool viewing, Salt Point also features a protected underwater area where you can scuba dive. This is one of the first protected underwater locations in California. No matter what time of day you arrive at Salt Point, you’re sure to spot some of your favorite creatures. | us | 38.5666615 | -123.3298816 | Gerstle Cove Marine Reserve | us_pacific_coast | America/Los_Angeles | http://www.parks.ca.gov/?page_id=453 | Salt Point State Park is 18 miles north of Jenner on Highway 1. There are many tidepools along the park’s coastline, including Gerstle Cove Marine Reserve. | ["California State Park"] | (707) 847-3221 | checked | The visitor center is open on weekends from April through October | checked | ||||||||||||||||||||||||||||||||
| shell-beach | 2017-11-26T04:32:16.000Z | recLZdp2L50siXrtP | Jenner | us | 38.4177676 | -123.1081004 | Shell beach | us_pacific_coast | America/Los_Angeles | Shell Beach is located on Highway 1 three miles south of Jenner. The tidepools are rich and easily accessible A steep trail from the parking lot leads down to the beach and tide pools. The site is located at the northern tip of the cove at Shell Beach. Locate the tallest and largest boulder at the north end of the cove. At low tide, you can carefully walk around the seaward edge of this boulder to reach the dense mussel bed | There is an outhouse located at the west end of the parking lot | Yes | The signed parking lot is 3 miles south of Jenner and 7.7 miles north of Bodega Bay along Highway One. Parking is free. Note: The parking lot can be full on weekends. | ["California State Park"] | (707) 875-3483 | During spring and summer low tides, volunteer naturalists are available to help interpret the tidepools for visitors. | checked | Shell 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. LiMPETS maintains a permit with State Parks for monitoring activities conducted at this site; therefore all groups must contact your local LiMPETS coordinator to plan your trip. Learn more about the geology of Shell Beach: http://terrywrightgeology.com/shellbeach.html |
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 );