data: places: 3 rows where "airtable_createdTime" is on date 2020-08-31, managment = "["California State Park"]" and managment contains "California State Park"

3 rows where "airtable_createdTime" is on date 2020-08-31, managment = "["California State Park"]" and managment contains "California State Park"

descending

slug ▼	airtable_createdTime	airtable_id	area	body	country_slug	latitude	longitude	name	region	time_zone	directions_to_tidepools	address	bathroom_info	bathrooms	parking	managment	directions_latitude	directions_longitude	docents	rules_and_collecting	groups
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.
carpinteria-state-beach	2020-08-31T04:30:59.000Z	recAVPHG8YFCNXy2o	LA	The site is straight offshore, about 40 meters from the staircase and centered on the outermost and largest mussel-covered rock outcrop. The outcrop is surrounded by sand. It consists of a oceanward portion and a shoreward portion, separated by a narrow connection (“neck”) that bridges over two small tunnels Contact Carpinteria State Park well in advance of your scheduled rocky intertidal trip. The Park has a policy about the number of people who can go on the reef in a day Contact is Marie Lindsey at (805) 684-7487 or mlindsey@parks.ca.gov. You might also consider scheduling a tidepool walk with a ranger, guided walks last approximately one hour.	us	34.3872536	-119.516589	Carpinteria State Beach	us_pacific_coast	America/Los_Angeles	A staircase, just southeast from the parking lot, leads to the beach.	Carpinteria, CA	There are a few public restrooms inside the park.	Yes	This site is located at the east end of Carpinteria State Park in Carpinteria, Santa Barbara County. Take Highway 101 to Carpinteria (east of Santa Barbara). Get off at the Casitas Pass Rd exit and turn toward the ocean. Take a right on Carpinteria Drive, then take the first left on Palm Avenue. Go all the way to the end of Palm Avenue and enter Carpinteria State Park. After going through the kiosk, take a sharp left and proceed down the coast to the very end where there is a little cul-de-sac where you can park.	["California State Park"]	34.388201	-119.5147189	Yes		The Park waives parking fees for school groups, but you must first submit a school group reservation form that the park will send you when you call to schedule a field trip. Contact is Marie Lindsey at (805) 684-7487 or mlindsey@parks.ca.gov.
wilder-ranch	2020-08-31T04:34:29.000Z	recWZGrZVAnl1r9ss	Santa Cruz	This is a flat area that can be difficult to get to, however it is an incredible site to monitor. Little to no foot traffic occurs here, other than the occasional surfer or beachcomber.	us	36.9539906	-122.089546	Wilder Ranch	us_pacific_coast	America/Los_Angeles	It’s a 20-30 min walk to the tidepools. Walk toward the ocean on the dirt road, crossing the railroad tracts and the fields until you reach the edge of the cliff. DO NOT drive on the dirt road; it is used by the farmers and is often muddy and easy to get mired down in. Once the edge of the cliff is reached, go to the right (west) along the dirt road until you come to the top of Strawberry Cove. Walk down a well-worn trail to Strawberry Cove Beach. Turn right, cross a large sand-scoured rock and a small sandy cove, and climb up on the narrow, sloping platform that is bare at the top. The platform has a large mussel bed in the middle and a small surfgrass bed near the bottom.		There are no public restrooms near the site; the closest are at the Wilder Ranch State Park’s entrance gate.	Nearby	This site, north of Santa Cruz, is just north of Wilder Ranch State Park’s main entrance. Park along Highway 1 at 2101 Coast Road, which is between the entrance to the Wilder Ranch State Park and Dimeo Lane. There is a small frontage road where you can park off the highway on the coast side. Be certain to park with enough room for any farm vehicles to still get by.	["California State Park"]				The Wilder Ranch site is on the eastern side of Strawberry Cove in Wilder Ranch State Park. Before going to the site, be sure to contact the park rangers at (831) 423-9703.

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
);