places
1 row where managment = "["University of California", "UC Santa Barbra"]" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| campus-point | 2020-08-31T04:31:11.000Z | recSrjNs2YhZElex8 | Santa Barbara | The study site is a rocky point, approximately 500 meters past the marine lab buildings and the public restroom. The site is the first large rocky outcrop you come to as you walk west along Campus Point Beach. The three rocks are surrounded by sand, which varies in height seasonally. | us | 34.4045437 | -119.8441133 | Campus Point | us_pacific_coast | America/Los_Angeles | The study site is a rocky point, approximately 500 meters past the marine lab buildings and the public restroom. The site is the first large rocky outcrop you come to as you walk west along Campus Point Beach. The three rocks are surrounded by sand, which varies in height more or less seasonally. It consists of three parts, a shoreward portion, a middle rock and an oceanward portion, separated by sand and then a narrow channel. | Santa Barbra, CA | There are public restrooms located at the edge of Campus Point Beach. | Yes | Campus Point is located on the University of California, Santa Barbara (map of the University of California Santa Barbara campus). Take Highway 217 to the East Campus entrance of UCSB. Go left through the roundabout onto Lagoon Road. Follow Lagoon Road until you can take a left into parking lot #6 Lot #6 has twenty metered spots that can be purchased at the Pay Station. Pay Stations take $1 and $5 bills and do not give change. Prices range from $2 to $8 per space, depending on the length of time you plan to stay | ["University of California", "UC Santa Barbra"] | No | Prices range from $2 to $8 per space, depending on the length of time you plan to stay. | 34.4085776 | -119.8427913 | Yes | You can schedule a REEF Tour by contacting outreach@msi.ucsb.edu |
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 );