places
2 rows where "airtable_createdTime" is on date 2017-11-26, bathrooms = "Yes" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fitzgerald-marine-reserve | 2017-11-26T01:40:01.000Z | recCsWfQfsPqjpShK | Half moon bay | <p>Great selection of tide-pools with an excellent visitors center. Fitzgerald Marine Reserve is a 3-mile stretch of protected beach, tide pools, marshes and bluffs.</p> <p>The volunteer docents are super knowledgeable and on weekends and holidays you’ll find them on hand about the reef to answer any questions and point out the really cool critters that live in the tidepools!</p> <p>Adjacent to and possibly within the reserve is an endangered species of butterfly, the San Bruno elfin butterfly.</p> <p>From the Fitzgerald website: at the sheltered sandy cove at the south end of the Reserve, take the trail to the bluff tops to return to the parking lot. Walk through the tangled garden of an old estate and through a century-old forest of wind-sculpted Monterey cypress trees. In the spring, California gray whales migrate north offshore. In the summer and fall, brown pelicans skim wave tops.<p> | us | 37.510556 | -122.509722 | James Fitzgerald Marine Reserve | us_pacific_coast | America/Los_Angeles | http://fitzgeraldreserve.org/ | 200 Nevada Ave. Moss Beach, Ca | <p>Bathrooms are at the ranger station near the parking lot</p> | Yes | Anlace | [{"filename": "2020-08-28 21.59.14.jpg", "height": 960, "id": "attrjkoiKpEvxvSzg", "size": 781759, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/btCUBw4SjPVgnEqnp1HwYw/gsBh-UfqmDn6Vg6ST9YoCJFVsBbCmKPplMOd_neyeQx3Fufiwmip29rxRbnblIxB4OXFu4HbNWWcleCMASoc6Q/aUnj6PN4dA_7DiYmriYazpwpAW9MxEzMmf8VAnbBAiI", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/7t8GmkEBrtcWxpDZzGwTqQ/KanPLmnLz1KDXqX9Ad5lCyg_8JlBZRFurHsxq7qYic0CBq9_PsEpKRES3Su97W4_g1MR_1SfAm95E_l9NSHF4w/Q1PQ4Ku5LHl4TGGLHfZdsMmfGj6atzTnyBMAge5YgYE", "width": 683}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/hAK1JF1NqQwORQ04nGkSUw/V6MsHnqqRzyoY4gUzPyfIZGeiqnG3VubWbtn_NWsemYH6-LpwvB2b3PDm8TLCSOZ5GBbImqSUAVPsmTL_HYXcw/MWWeJilI4GC-LF-DskgZsdMYwLuuEXBjs9llfqSgMGs", "width": 48}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/SW5Eh9imew-P5Cho1a339g/mVqtp93MPSTF7GpnqDXdc9cg63RvJNBX5bJKfWD7dBKJF0RLIQy0QLxwngGm5C9RQOf1slwf4jTKyBylPTG06413_vmuUBG4xGUPye-t6_M/ZronWBu_E521gAVMsMOc-VaQ6hcAptGS3B9iDpiUwIw", "width": 1280}] | <p>From Highway 1 at Moss Beach, turn west on California Avenue and proceed to the parking lot at the end of the street. The reserve’s main entrance is at the end of California Avenue.</p> <p>Allow 45 minutes to reach the reserve from the intersection of Highways 280 and 92. (Buses with students can use either Highway 1 or Highway 92).</p> <p>Buses will be directed where to park upon arrival.</p> <p>Parking is extremely limited. If your group is traveling by car, carpooling is required.</p> | ["San Mateo County Parks"] | Yes | (650) 728-3584 | Yes | Free | Opens at 8am. Closing time varies seasonally, check the reserve website for specific openings. | Yes | No | <p>There are lots of restaurants in the nearby town of Granada or in Half Moon Bay. The historic cliff-top restaurant Moss Beach Distillery is just South of the reserve and has been operating since 1927. </p> | <p>Fitzgerald Marine Reserve is in a no-take Marine Protected Area. You are not allowed to collect any sort of organisms, shells, rocks, driftwood, etc. Please do not bring buckets to the reef.</p> <p>Don’t turn over rocks or put any animals in containers, don’t feed animals or pick them up.</p> <p>Do not disturb the Harbor seals, Stay a safe 50ft distance away from them. If there are orange cones present on the beach or reef, stay on the side of the cones farthest away from the seals.</p> <p>USE SPECIAL CAUTION during the March-to-June harbour seal pupping season, because if a mother seal is scared away from her baby, she is very likely to abandon the pup, which will die. If you see a pup that looks abandoned, STAY AWAY and call the reserve staff. They will monitor the pup and contact the Marine Mammal Center for a rescue if necessary.</p> | <p>If you’re bringing a group of 15 or more, you must reserve a time and date for a docent-led tour. Consult <a href="http://www.fitzgeraldreserve.org/newffmrsite/lowtides/group-tour-times">their website for tour dates and reservations</a>.</p> | <p>The beach and reef are not accessible to walkers and wheelchairs. However, a paved trail through part of the reserve is accessible.</p> <p>Don’t run on beach or reef as you could easily slip. There are often landslides so please stay away from the bottom of the fragile cliffs, don’t dig at the cliffs.</p> <p>Always watch the ocean and be aware of the rising tide. Stay with your group and your volunteer naturalist guide.</p> <p>The creek is polluted. Please cross the creek, but do not play in it. </p> | 1 | 1 | No dogs at all, do not bring dogs with you. | 0.5 | http://www.fitzgeraldreserve.org/newffmrsite/good-tidepooler-rules-of-conduct/ | 9414131 | Magnificent reef to visit for first-time tidepoolers and experienced naturalists alike. | 1.0 | 2 | https://en.m.wikipedia.org/wiki/Fitzgerald_Marine_Reserve | ||||||||||
| pillar-point | 2017-11-26T01:40:59.000Z | recTsm3KeweNFb8eW | Half moon bay | <p>Pillar Point is awesome! there is a lot of variety in the types of pool left by the tide. The left hand side (looking out to sea) has some small pocket pools and a wide flat seagrass bed. there are lots of accessible little pools near the beach and there's a small cut parallel to the beach which is a good place to spot fish.</p> <p>The pools along the deeper ravine at a 90% angle to the beach have giant green anemones, acorn barnacles and is where you'll want to head to find nudibranchs. There are some sea palms and varied fauna on the rocks next to this ravine also.</p> <p>This area is a popular surfing spot, also known as Mavericks when the tide is high and the waves can come in fast and strong so you'll need to watch your back and don't underestimate the tide. The smaller cut parallel to the beach fills in first so do wear water shoes!</p> | us | 37.49542392 | -122.49865193 | Pillar Point | us_pacific_coast | America/Los_Angeles | www.smharbor.com/pillarpoint | <p>Park in the parking lot at the bottom of the radar station if possible, follow the trail at the sea-end of the carpark straight out and along as the path swings to the right around the bluff. The tide pools, shallow-water sea grass beds and a secluded beach are about half a mile or so from the carpark after you pass the jetty on the left.</p> <p>Keep an eye out for shorebirds in the marsh to the left, harbor seals in the secluded harbor before the jetty and nesting great blue herons in the trees on the walk to the tide pools.</p> | Pillar Point Harbor CA | Two porta potties are available in the carpark which is about half a mile from the site. | Yes | <p>Parking available at the radar station and in the overflow carpark. Parking is often full, best to arrive at least an hour before low tide to leave enough time to park and also walk the half mile to the tide pools.</p> | Yes | (650) 726-5727 | No | Free | 37.501768 | -122.496765 | No | Yes | <p>There are lots of restaurants in the nearby town of Granada or in Half Moon Bay.</p> | <p>Please be respectful of the reef and leave anything that is alive or could have alive things in it where they are. Don't move animals between pools, put them back where you found them, it's their home. If you want to fish or collect seaweed or shellfish you need a fishing license.</p> | <p>Groups are allowed, buses must park at the corner of Harvard and West Point.</p> | <p>As tide pools go, this is pretty accessible. It's a bit of a walk on the flat path and there is a bit of beach to navigate to get to the pools, but the pools also have a reasonably flat section. That said, there are some fast flowing cut-throughs to get over if you want to go further out and seasonally some quite slippery seaweed, so a walking stick makes a good companion.</p> <p>The edge of the tide pools nearest to the open ocean on the furthest right hand side (if you are facing out to sea) can be heavily affected by wind and swell, so as always, keep an eye out on the ocean, particularly so if it looks choppy.</p> <p>If you go far out, make sure to watch your exit route to ensure that you don't get cut off by the incoming tide.</p> <p>If you are setting up a picnic don't sit too near to the base of the cliff because erosion can cause dangerous falling rocks.</p> | 1 | 1 | <p>Dogs are allowed on-leash on the beach here.</p> | 0.5 | https://wildlife.ca.gov/Fishing/Ocean | 9414131 | Really varied tidepools with great Nudibranch potential! | 0.5 | 2 | https://en.m.wikipedia.org/wiki/Pillar_Point_Harbor | <p>Lots of space on the beach for picnics, no fires allowed though. Be careful not to sit too close to the cliffs because rock fall is common.</p> | 1 | https://www.surf-forecast.com/breaks/Pillar-Point/webcams/latest |
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 );