places
1 row where address = "Redondo Beach Road, Half Moon Bay,", cost = "Free" and variance_ft = 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| redondo-beach | 2017-11-26T02:36:14.000Z | recWYDFaFuyJIR9BC | Half moon bay | <p>Beautiful sandstone erosion creates gullies in the cliff face. The tidepool area is quite high and accessible even when the tide isn’t all that low. This makes it a great place for summer Tidepooling.</p> <p>Often one of the less popular beaches in half moon bay, it offers stunning cliff views and exciting wildlife in the tidepools.</p> | us | 37.4365721 | -122.4447811 | Redondo beach | us_pacific_coast | America/Los_Angeles | https://www.californiabeaches.com/beach/redondo-beach-half-moon-bay/ | <p>The smoothest way down to the tidepools is to walk along the scenic bluff trail to Poplar beach (or park there) and take the steps down. It’s a bit of a scrabble but it’s also possible to get closer access from the Redondo parking down one of the many steep ravines that the rain has carved out of the cliff. Wear sturdy shoes and bring a walking stick if you have one.</p> | Redondo Beach Road, Half Moon Bay, | <p>You might be able to find bathrooms nearby with Half Moon Bay being so close.</p> | No | Natalie Downe | [{"filename": "2020-09-08 17.04.50.jpg", "height": 2268, "id": "attxoPAMVDM9pHsYH", "size": 5533607, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/KReFoEg3XVetgqAEKMvHvQ/zLvJYqHVv7DVdbgfe6h8dRbo7M0yc5_83jIyWbkqufsXt_YEZcjkyYw8prfeU18csP0HNwMu1dB34sC7VLsOCQ/sa2U3PsL3yeWaeCgoAToVr_HCy2FIwfUKRbJJ9f1s4Y", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ThbnizTZk_PTzbx4szM5yg/4bnMSHc6TOh2xtpR5MFVlHnINQhd8rZABzwCGlX85DVRM3CNABwAfoLCOs1lGSM4Ri_bU00NARP2xFA4APrIBg/2sKVJ6z4Lhb5NgtVqbFfd1rWuQFXlM2Ef3I7TKh-OSo", "width": 910}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/zZk5ZvCKo44KqZPFxOKhSA/zzH1h54hh7sOxzKmoq3IBuEXwa3IWENOOOSI9-GZpQa0uv53teOlgU0DQgw1Eg61_FGqFYB2HVYNJchgCj1wSA/vjAxqeCGC64NOo8J12WFmQUnTGbXgPnSY7qd2xQ2COw", "width": 64}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/_KZm3fKpy0qP2Qf5RkQ_jQ/9NNSByLM2zzYzFpIXIjStq1kZ6pIV1pNT0MAha_cPeRfOmhtizG5exUsssR3EZo3h3c82T545yCPvQxKr3f7rZNKOp9OqIKIyFuHDwR0ve4/sl1VYE_I-FncSwU9ldgbqKygsnwAy-Rz_eNKtTyOsb0", "width": 4032}] | <p>There is a larger paid parking spot at the Poplar State beach parking on Poplar st but if you are lucky you will be able to get a spot in the small, free, unpaved (and rather bumpy) parking at the end of Redondo Beach Road. Careful how you drive if your car has a low chassis. People park on the side of the road leading up to the carpark also.</p> | ["Coastside Land Trust"] | Yes | No | Free | 37.4392236 | -122.4430648 | No | Yes | <p>Close to Cameron’s Inn but also only about a 10 min drive from lots of dining options in Half Moon Bay.</p> | <p>Please be respectful of the reef, don’t pry any shellfish or creatures off their homes. You’ll need a Fishing license if you want to fish and bear in mind that depending on the time of year shellfish may be poisonous and you could get Paralytic Shellfish poisoning.</p> <p>Watch where you step and don’t step on living things if you can possibly avoid it.</p> | <p>Buses and groups may want to park in the more official car park at the end of Poplar beach road, head down the steps and walk a mile along the beach.</p> | <p>Depending on the route you take down to the beach it can be quite treacherous. Be careful especially if you are going down or back when it is dark. Always watch your step and never turn your back on the tide.</p> | 1 | 1 | Dogs must be on leash | 0.5 | https://en.m.wikipedia.org/wiki/Redondo_Beach,_California | 9414131 | Quiet Tidepooling spot with lots of little pools on a rocky ledge with some stretching out further | 2.0 | 2 | https://en.m.wikipedia.org/wiki/Redondo_Beach,_California | Poplar beach, Half moon bay | <p>Definitely take a picnic here! Sit on the cliff and soak up the incredible views or navigate down to the beach and eat there. 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 );