places
1 row where bathroom_info = "There is a public restroom in the parking lot at the intersection of 41st Avenue and East Cliff Drive"
This data as json, CSV (advanced)
Suggested facets: airtable_createdTime (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
opal-cliffs | 2020-08-31T04:39:20.000Z | recyyclyRwDDg0OGp | Santa Cruz | This is a very flat intertidal area. Because the platforms are so flat, only a small rise in the water level floods them. Watch the rising tide, as that will determine the amount of time you will have to work the site. Also, the soft rocks of Opal Cliffs contain numerous fossils, including whale bones. These can become exposed and eroded free, then scattered about in the intertidal. If you are lucky, you might see some! However, unlike Soquel Avenue, the Opal Cliffs site did not appear to be affected by the county’s sewage discharge in the early 1970s. Therefore it could be used as a comparison site to the recovery of the soquel Avenue site once the discharge was stopped in 1976. | us | 36.9599223 | -121.9638587 | Opal Cliffs | us_pacific_coast | America/Los_Angeles | To reach the site, walk down the stairs at the intersection of 41st Avenue and East Cliff Drive and straight out to the seaward edge of the outcrop. It is the northwest section of the outer platform, just beyond the channel that parallels the shore and 49 meters from the outcrop. | There is a public restroom in the parking lot at the intersection of 41st Avenue and East Cliff Drive | Nearby | Park near the intersection of 41st Avenue and East Cliff Drive. | collecting of any sort is illegal without a CA DFW scientific collecting permit. |
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 );