places
1 row where dogs = "No" and tidepool_height = "1.5"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| shark-fin-cove | 2020-09-01T17:34:17.000Z | recbzrTCPYnWVhpAd | Santa Cruz | <p>This is a really pretty beach with shallow pools on algae covered rock benches.</p> <p>The large Shark fin shaped rock used to be part of the mudstone cliff and got its shape from erosion by the wind and waves</p> <p>There are also a small cave on the south east of the beach to explore.</p> | us | 37.003824 | -122.1855372 | Shark Fin Cove | us_pacific_coast | America/Los_Angeles | <p>From the parking lot walk south (left if you face the ocean) down a wide path over railroad tracks to a rather scrambley steep poison-oak lined path that takes you to the beach. You’ll be able to see the shark fin rock from the path. There are three rocky outcrops on the left hand side that have some small tidepools and kelp. </p> | No | Natalie Downe | [{"filename": "2020-09-01 11.23.24.jpg", "height": 2508, "id": "attZW4523qQbUtDKy", "size": 7264655, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/TcDaf6XDlQIEhpBjWd_ERQ/FtCj7WOkHFP_Sek_eHiQ--wGqOFVlL_aCD-W78UVbqYsvf9kHyV1R0U3UsYafpzX-Vpxwg7oEg_MzT0wDUnhaw/ekx-ZyEWTTxjqfy0du5xCtVu2LlS41-UzyYNJXCVZZ8", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/i3b2pFKdYOQUO-ugafbhSQ/6y9co7PVNJl3boT8jgEKE8llBp4HEUmg4dwmJVcs1_sGfXnomRJfnp0EgnQUKDfOQSH-uuQbhH-AissmQy3EgQ/AETIJK04MF6F55_rku2k37mQ3V_2sorNfmneja6zBo0", "width": 747}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/f2D29e1wz2wb2SA6ew1g6w/yw-_hfSL9c0lwYcslkZLKvyYvX_N8sq9l_x8Nsbffn0Q6gsnpstcxGEQbB2cX1z_ZoVKcgZsWNxfVVW-XygwnQ/MscbxvRDftFKCsbgBQS62RrHuLUej6S1KBn8fcIiXJU", "width": 53}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/sjnVyHIAA-BUq7sv3WtDnQ/1XFHNfLtWZG3MxcUVo9kH27CO2kOz_rC9GVmzOD_CMCniOjtpujGW1w5AtbfgGC5wuIrgoCB-tFWbZNZTiJ2l5EuqhXg9q_h--ZM_NyKGf8/HrEyVnlulh-aW71vmlqBxNHHfhScIflrRDXS3LPGA9c", "width": 3660}] | <p>Parking is available in a small dirt lot on the ocean side of highway 1</p> | ["California State Park"] | Yes | No | Free | Sunrise to sunset | 37.005745 | -122.1856066 | No | No | <p>There are some restaurants north in Davenport </p> | This beach forms part of Coast Dairies State Park. No collecting unless you have permission from the state park | Groups are allowed | <p>The path to the beach is quite steep, if you have difficulty walking you will appreciate the use of a stick to get down. Be careful of the prolific poison oak that lines this trail. Once you are on the beach the rocky outcrops are flat but slippery.</p> <p>If you go exploring in the caves be careful of the tide because the sea stacks create dangerous currents and you could be swept away.</p> | 1 | 1 | <p<As a state park unfortunately there are no dogs allowed.</p> | 9413450 | Flat rock outcrops with small tide ‘puddles’ and lots of algae | 1.5 | https://en.m.wikipedia.org/wiki/Coast_Dairies_State_Park | Shark Tooth Beach, Davenport Cove, Jah beach | <p>There is a lovely sandy beach here, great for a picnic! No fires allowed.</p> | http://blog.natbat.net/ | 1 |
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 );