places
2 rows where managment = "["California State Park"]", managment contains "California State Park" and picnic_options = "checked"
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/ | |||||||||||||||||||||||||||||
| point-montara | 2017-11-26T05:13:20.000Z | reciYr6NHZBuIkMgJ | Bay area | us | 37.537422 | -122.519616 | Point Montara light station | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/hotel/point-montara-lighthouse-hostel/ | A footpath leads north from the lighthouse through a picket fence to the edge of the bluff. It quickly splits and the left trail goes out to a point and down to the rocks. The right trail leads back to a creek drainage and down to the beach. | 16th St and Cabrillo Hwy Montara, CA 94037 | No fee for day-use parking | ["California State Park"] | checked | Gray whales migrate by Point Montara between November and April. | Dogs allowed on leash on the property but not allowed in the hostel | Gray whales migrate by Point Montara between November and April. You can also stay in the hostel here. Really close to the Fitzgerald marine reserve. | checked |
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 );