places
3 rows where docents = "checked", managment = "["California State Park"]" and managment contains "California State Park"
This data as json, CSV (advanced)
Suggested facets: area, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| crab-cove | 2017-11-26T02:45:23.000Z | recjSJZI4O2uJ0td6 | Bay area | For those of you that love to have the full backstory on every echinoderm you encounter, Crab Cove may be the perfect place for you. The visitor center has an impressively large aquarium where you can get a preview of what you might see when you visit the tide pools. There’s also equipment that allows you to view tiny animals that are invisible to the naked eye. The interactive, educational experience at the visitor center is bound to get you pumped to experience tide pools in a whole new way. When you’re done, head outside to the tide pools, which are located just behind the visitor center. | us | 37.768163 | -122.278199 | Crab Cove | us_pacific_coast | America/Los_Angeles | http://www.ebparks.org/parks/vc/crab_cove#gsc.tab=0 | Turn off Central Ave. at McKay Ave and you’ll find the visitors center. Head down to the shore for the tide pools | 1252 McKay Ave. Alameda, Ca | ["California State Park"] | (510) 544-3187 | checked | $5 parking fee | Visitors Center hours: Wed – Sat 10 a.m. – 4 p.m. (Oct – Feb) and until 5 p.m. the rest of the year | checked | In the summer months, Crab Cove also hosts a free evening concert series on the second Friday of the month. | |||||||||||||||||||||||||||||
| 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 );