places
2 rows where area = "Pescadero" and managment contains "California State Park"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pebble-beach | 2017-11-26T05:33:32.000Z | recrVKdoD7nkSOr5i | Pescadero | Pebble Beach is the northern beach in Bean Hollow State Beach in San Mateo County. This is a small cove with a pebbly coarse brown sand. A stair leads down from the small circular parking area to the rocky south end of the cove. Excellent tide pools can be found in the rocks at the south end. Be careful on these rocks as sneaker waves (waves that are larger than normal) can come crashing ashore.This location is also known for tafoni rocks which are uniquely textured sandstone with holes and honeycomb-like structures that have been created through a weathering process. A self-guided nature trail can be found at the circular end of the Pebble Beach access road. This hiking trail continues along the bluff between Highway 1 and the rocky shoreline for about a mile to Arroyo de los Frijoles Beach, the southern beach in Bean Hollow State Beach. | us | 36.561669 | -121.936278 | Pebble beach | us_pacific_coast | America/Los_Angeles | Yes | Natalie Downe | [{"filename": "2020-09-01 10.26.02.jpg", "height": 2630, "id": "attqrwclUbGsvXBfH", "size": 6988001, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/NQKlUcSkbrD2A1ExTqEldA/OweU1ogpCykjV4zhPnK4kbNURDrDQAKqzrqKg2pJOcYEaH9zOm-e5GpNJmF-U71uqiMmgXF0ZUbosjf5JFs_TA/b3ArsCdmSqZbqiPMrL_j8KTfKsgiYUZW_UNrg0_gt5o", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/2zgQFF8JdNIrCJea-Oiw8w/yYAWsg0gf8ro5Fe0nfLmO-MCt9NvWkew4WQc29FtnZUq7DhdU5lzi2kfR8-0K7HZR5uOwfOVNdtF9lclRi6dvg/7M5Q6vNJHYD8-7OIsgK1Jb1tpxK3Y3n0ApW3yx-m90g", "width": 785}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ZdeGN0UVY6kU0Qz45L0PwA/epLYfA8sgJ66z6dqGG_5NEKEfKemnSkSrGUE0V8HQCGjn2R1aMS3rXsGNkwFkqNZiBerrWM8ArjFQv254eFuHQ/4fnhuEN0Kycggxx8s4MzgvDI60UF9edKiYIcfF-wMh8", "width": 55}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/nhvPsau24NoRg90PkB_QsA/WLJZ5bnTV7STAmmCiK37yK6QmoNwmnAr1vOgoq7Z5xdCGvu-Ci6gqf5DlRl59pm52SG09Ht8GeKVqH-rX-6SlkeS_aj5HX-xCFiRsKzm4oc/jAcoe4OBuxv8Kbnptcn51sQhLlc2JUaNPS8ADGaFo4s", "width": 4032}] | No fee for parking | ["California State Park"] | Yes | 1 | Dogs allowed on leash | checked | http://blog.natbat.net/ | |||||||||||||||||||||||||||||
| pigeon-point | 2017-11-26T04:40:25.000Z | recSP3TQE6YpK3UnF | Pescadero | Pigeon Point’s original name, Whale Point, was inspired by the gray whales that migrate past the point This site is located along the San Mateo County coastline between Half Moon Bay and Santa Cruz. From Highway 1, turn west onto Pigeon Point Road towards the lighthouse. From the lighthouse, drive north on the service road and park at the 5th telephone pole. The site is accessed by traversing down a sea bluff to a boulder field. | us | 37.1838276 | -122.3959914 | Pigeon Point Light Station State Historic park | us_pacific_coast | America/Los_Angeles | http://www.parks.ca.gov/?page_id=533%20 | The site is accessed by traversing down a sea bluff to a boulder field. Pigeon Point Lighthouse is located on Highway 1, 20 miles south of Half Moon Bay. From the north, take Highway 280 south from San Francisco, then go west on Highway 92 to Highway 1, and take Highway 1 south to the Pigeon Point Lighthouse. The tidepools are located 100 yards north of the hostel building. The rocky ledges and tidepools are easily accessible but are exposed and visible only during low tides. | Portable toilets are located at the Pigeon Point Lighthouse, approximately ¼ mile south | Nearby | Park at the 5th telephone pole on the service road. | ["California State Park"] | (650) 879-2120 | r collecting is illegal without a scientific collecting permit or, for select species, a fishing license. | Whale point, pigeon point lighthouse |
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 );