places
1 row where "airtable_createdTime" is on date 2020-08-31, managment = "["University of California", "UC Santa Barbra", "California State Marine Conservation Area"]" and managment contains "UC Santa Barbra"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| coal-oil-point | 2020-08-31T04:31:39.000Z | recX4H63f8kUQqBbF | Santa Barbara | Coal Oil Point is a low-lying flat rocky reef with scattered boulders and surge channels. The reef is often partially buried in sand in spring and summer months. Mussel beds can only be found on larger boulders and raised areas. Be careful of old pier piling remains as this area was once an active oil field. This is also a pop | us | 34.406672 | -119.8779161 | Coal Oil Point | us_pacific_coast | America/Los_Angeles | <p>Follow the trail west along the coast from the line of trees car parking. There is a slope down to beach level and close to there is the reef</p> | Santa Barbara, CA | There is a portable restroom available on the bluff top, near the entrance to the western beach trail. Other facilities are available in the Isla Vista business district. | Yes | If you do not have a UC Santa Barbara West Campus parking pass, you will need to park in the western end of the community of Isla Vista and walk aproximately 0.5 miles to the point either on the blufftop trail or along the beach To reach the parking area, turn left at the junction with El Colegio from Storke and then take your next right, at Camino Corto. Drive 5 blocks to Del Playa. Turn right and drive for two blocks, and park along the row of trees. A trail leads out to the point and COPR. | ["University of California", "UC Santa Barbra", "California State Marine Conservation Area"] | 34.4100387 | -119.8696294 | Recreational or commercial take of marine life is prohibited. | <p>Groups must make a <a href=“http://coaloilpoint.ucnrs.org/“>reservation prior to visiting</p> | http://www.dfg.ca.gov/marine/mpa/scmpas_list.asp |
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 );