places
2 rows where bathrooms = "No", dogs = "No" and visitor_center = "No"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| frenchys-cove | 2020-08-31T04:23:35.000Z | rec9KANo9J4mnl6in | Anacapa Island | This site is a solid rocky bench located on the south side of West Anacapa Island, within the Channel Islands National Park. Human disturbances include trampling from light visitor use. Travel to and from Anacapa Island offers the opportunity for marine mammal sightings aboard the Island Packers boats. | us | 34.0064594 | -119.4113714 | Frenchy’s Cove | us_pacific_coast | America/Los_Angeles | Frenchy’s Cove is located on West Anacapa Island. Boat transportation to this site from Ventura Harbor is provided through Island Packers. To make reservations call (805) 642-1393. The site is accessed by a five-minute hike from one side of the island to the other, past a site monitored by the Channel Islands National Park. Boat transportation to Frenchy’s Cove, Anacapa Island, is provided through Island Packers. From the beach, take the five-minute hike from the north side of the island through the gap to the south side. There is a trail located at Frenchy’s Cove. Head west across the sandy beach to the second rocky bench. | West Anacapa Island, CA | There are no restrooms at Frenchy’s Cove. Use restrooms on the boat before going ashore. | No | ["National park"] | No | 34.2441623 | -119.2651822 | No | No | There is no food available on the island, you’ll need to bring food with you. | Collecting is not permitted in the National Park.No permit is required for monitoring, but it is important that groups do not disturb the National Park monitoring site. | |||||||||||||||||||||||||||
| 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 );