places
2 rows where visitor_center = "Yes"
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 | ||||||||||
| natural-bridges | 2017-11-26T01:56:21.000Z | recYrDpVivWe2GDoJ | Santa Cruz | This flat site is a sloping, nicely zoned mussel bed with lots of species hidden in the nooks and crannies. This site can get lots of foot traffic so be prepared if monitoring on a weekend. If you visit in the late-fall or winter, don’t forget to check out the Monarch Preserve for the yearly migration of up to 100,000 monarch butterflies! This is a busy place. It has a picturesque rock arch in the surf and an excellent sandy beach. Come here at low tide and you’ll get an added bonus with tide pools that are exposed on the western shoreline. Docents are available throughout the year to give you guided tours of Natural Bridges tide pools. These pools are only visible at low tide so check out the tide forecast before you go. While you’re there, snap some iconic photos of the famous “natural bridge” that gives the park its name. These photos can be especially beautiful at sunset, and the “bridge” can make an excellent background for portraits too. To ensure the best tide pool viewing, check the tide charts before you go. If you’re timing is off, the Visitor Center also has an aquarium that displays tidepool critters. Either way, you’ll return home with a renewed appreciation for life forms both squishy and spiny. This Santa Cruz beach is great for viewing all sorts of sea life as well as the amazing, naturally formed rock bridge out in the water. you head north along the beach you can climb the rocks to access the tide pools. Also nearby is the Seymour Marine Discovery Center, another great place to learn about Bay Area marine life. | us | 36.9491477 | -122.0610663 | Natural Bridges State Beach | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/beach/natural-bridges-state-beach/ | Natural Bridges is located at the north end of the town of Santa Cruz. Take Swift Street west from Highway 1, then West Cliff Drive north until it ends at the state beach. The tide pools are located on the side of the beach opposite the “natural bridges.” Head north from the state beach parking lot and scramble over a rocky shelf and you will find yourself surrounded by pools of many shapes and sizes. There is also a more accessible route through the mobile home park. Natural Bridges tide pools are on the western edge of Santa Cruz. The best way to reach the site is through the De Anza mobile home community. From the Deleware Avenue entrance, walk down Cascade Drive and follow the path past the pond to the small beach. Once at the beach, head to the right and cross the first two rocky platforms to the site on the third platform. The site is past the area directly under the gazebo. The walk takes about 10 minutes. Please respect the privacy of the De Anza residents and keep noise to a minimum. | 2531 West Cliff Dr. Santa Cruz, | There is a porta potty at the end of Delaware Avenue and several buildings have public restrooms at the main entrance to the State Beach. | Yes | State beach parking is $10, or park just before the beach entrance on Swanton Blvd. for free if there’s a spot Park at the end of Delaware Avenue, by the entrance to the De Anza mobile home community. | ["California State Park", "California State Marine Conservation Area"] | Yes | (831) 423-4609 | Yes | 36.9517807 | -122.0574584 | checked | Removal of any living thing is illegal. | Contact the State Beach before taking a group to the intertidal platforms so that the rangers are kept informed and your group does not conflict with any docent-led tours. If there is room, you can arrange to park in the State Beach parking lot without charge. For more information, call 831-423-4609. | The route down can be tricky, so ask at the Visitor Center for directions to get to the pools through the neighboring mobile home park. | This spot has a picturesque rock arch and in addition to tidepools, has a sandy beach. In the park there is a Monarch butterfly Preserve which is a great place to see these beautiful creatures in an overwintering spot. |
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 );