places
1 row where address = "1252 McKay Ave. Alameda, Ca"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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. |
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 );