places
7 rows where visitor_center = "No"
This data as json, CSV (advanced)
Suggested facets: area, bathrooms, header_credit, managment, cost, docents, dogs, station_id, header_credit_url, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| campus-point | 2020-08-31T04:31:11.000Z | recSrjNs2YhZElex8 | Santa Barbara | The study site is a rocky point, approximately 500 meters past the marine lab buildings and the public restroom. The site is the first large rocky outcrop you come to as you walk west along Campus Point Beach. The three rocks are surrounded by sand, which varies in height seasonally. | us | 34.4045437 | -119.8441133 | Campus Point | us_pacific_coast | America/Los_Angeles | The study site is a rocky point, approximately 500 meters past the marine lab buildings and the public restroom. The site is the first large rocky outcrop you come to as you walk west along Campus Point Beach. The three rocks are surrounded by sand, which varies in height more or less seasonally. It consists of three parts, a shoreward portion, a middle rock and an oceanward portion, separated by sand and then a narrow channel. | Santa Barbra, CA | There are public restrooms located at the edge of Campus Point Beach. | Yes | Campus Point is located on the University of California, Santa Barbara (map of the University of California Santa Barbara campus). Take Highway 217 to the East Campus entrance of UCSB. Go left through the roundabout onto Lagoon Road. Follow Lagoon Road until you can take a left into parking lot #6 Lot #6 has twenty metered spots that can be purchased at the Pay Station. Pay Stations take $1 and $5 bills and do not give change. Prices range from $2 to $8 per space, depending on the length of time you plan to stay | ["University of California", "UC Santa Barbra"] | No | Prices range from $2 to $8 per space, depending on the length of time you plan to stay. | 34.4085776 | -119.8427913 | Yes | You can schedule a REEF Tour by contacting outreach@msi.ucsb.edu | |||||||||||||||||||||||||||
| china-beach | 2017-11-26T03:05:15.000Z | recN7luusZmaXjtOj | Bay area | <p>Tucked between Lands End and Baker Beach, down a paved drive or stairway from the parking lot, China Beach in San Francisco is a national park site. Well loved for its beach access, tide pools and picnic area it has spectacular views of the Marin Headlands and Golden Gate Bridge. At low tide take a walk north to Baker beach to see anemones and sea stars clinging to the rocks.<p> <p>The area used to be a campsite for the Chinese fishermen, during and after the 1849 gold rush. You can see a monument to these early residents at the trailhead near the parking area at the end of Sea Cliff Avenue. The monument reads “Their efforts to supply the needs of a young city helped establish one of the area's most important industries and traditions” </p> | us | 37.7893246 | -122.4898912 | China beach | us_pacific_coast | America/Los_Angeles | https://www.parksconservancy.org/parks/china-beach | <p>Access to the beach is via a paved drive or stairway down from the parking lot to water level. There are some tidepools to the south or you can take a low tide walk north (right) to Baker beach.</p> | Sea Cliff Ave., San Francisco, Ca | Unknown | Ed Schipul | [{"filename": "2020-08-30 17.16.27.jpg", "height": 481, "id": "att2KorehRBfzeESL", "size": 304819, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/97PmIQyHcQK1znLfGosGWA/pagyrcVrav5B1vbJSiORGsjmzXfLjvnUY8EvdXR9f7qtWl2aPBttfOr5ip_MgEcpyHZz90VQlmJOaWLwTjCShw/EI0eyxqm6e74yU9S_b_aPOUP-5wWgoxY-xWijukTqRo", "width": 3000}, "large": {"height": 481, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/fOAuoJODnpxSfAP9k0QaTw/LorOrelG7wz0av17vaZE3-IuVISNA5PVfIhplMTMvNdYvZcH1XSVjGVeUawLQcbmxd6s5XoLLbQYZws-jNYCdw/baotbeaLdbh2_UjxlfNyXoC9SZY074oMjoLWbrHt7xc", "width": 855}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/owXYutAz9I2b0_8B-R3Dqg/tcoBpy9JH1za3xMnQg6QgBaOKPl4w2TJn-dp2oO9z2rgwgUQPjsMwm5VyqZBZ8C57mPgOzZ37gGCYLomYPA1rg/nm2pRXGrS4v0Jt3xPtgE8EfmqppI7maiBP-Myd64vyM", "width": 64}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/LsOa0LyDehJDyKXM0kNiEQ/CfoslpDeeAIK0V4X1ehUjJfS_yMyzF9581ZncCI2w8wSK0fEtwGmbMkWZmDD8bqxYQrcwj--TKbkxL0XReqPJejH4j7Dvfn2PqZFdtIsbYw/ilGejEWtajw7fw6eMqqVxJB50Av0NQmJufvx3-vJS6Q", "width": 855}] | Parking can be tricky so arrive early in the day for the best chance of grabbing a spot in the small parking lot. | ["National park"] | Yes | No | Free | 37.7873692 | -122.4905996 | No | No | <p>This site is nestled between lands end and the Presidio so there are some excellent cheap lunch spots on Clement or Geary street just a few blocks south<p> | <p>No fires or glass containers are allowed.</p> <p>As this is a National Park, there is no collecting of any sort allowed here and you are also not allowed to fly a drone or unmanned vehicle without a special use permit<p> | <p>There are no restrictions on visiting with groups, but be aware access to picnic areas and grills are first-come first-served and no reservations are allowed. If you want to host a wedding, meeting, commercial photography or organised group activities you will likely need a permit.</p> | <p>There are no lifeguards are on duty And there are really unpredictable surf conditions so swimming is not recommended.</p> <p>There is a paved path to the beach from the car park but the tidepools themselves may not be wheelchair accessible.</p> | 1 | No pets allowed. | 0.5 | 9414290 | Descend the stairs and take a low tide walk from the tiny cove of China beach through to Bakers beach. | 1.0 | 2 | https://en.m.wikipedia.org/wiki/China_Beach,_San_Francisco | James D. Phelan State Beach Park | <p>Picnic tables are on a first-come first-served above beach level, there’s a sheltered sandy cove for picnics too. </p> <p>To sunbathe out of the wind, there is a small deck on top of the lifeguard equipment pick-up station.</p> <p>There’s no fires allowed on the beach but there are prepared grills and available if you get there early, no reservations are possible.</p> <p>Restrooms and cold water showers may be open sunrise to sunset but the official website has listed that the bathhouse is not open to the public. Work is undergoing from by the National Park Service to improve facilities.</p> | https://www.flickr.com/photos/eschipul/5987162386/ | 1 | ||||||||
| fiscalini-ranch | 2020-09-02T01:09:42.000Z | recvGJIlcGjvteV4p | San Simeon | us | 35.5484032 | -121.1008331 | Fiscalini Ranch | us_pacific_coast | America/Los_Angeles | <p>Take the Bluff trail north for about half a mile. The entrance to get to the tidepools is hard to find and quite scrabbly to get to the beach level. You can also park at the other trailhead to the north:</p> | Cambria, CA | No | Natalie Downe | [{"filename": "2020-09-01 19.21.40.jpg", "height": 2271, "id": "attOknot9g84icbyc", "size": 5029213, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/y4cuuxnAa9lefTI_sxrbzg/WmloqmBKUTQQQ-p65OHKGslBPpPYQGiMEJGvG8Ne4VpZQT3LDDbokcx3XWchYiX-bNJ9rBbvmNy6ncSoKy2btQ/d5J50REtx_N3SdEE0ejWDX-fbK_Bbo5iAG9AeX1Ten8", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/Cev6hJW4Bwbh7C1zmooPrA/OFnYjEN9QbYAndBY2CWb9qYBUat_JY66xYAE1bIu1-2qTJwLQIJLLRb3rOJAsEp6sotXFGjMTjXviBDVuNzeqA/uEal7qTft3RFdW7395_yTGPHHEKnsl0OUgo4hliIQDY", "width": 883}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/t85hORjrvjh1PBVGwdjaUg/StEO8rg7b2IjBNIEog2wNxgJ0hIHaiACz6QAC7OcYesd4M3rhipU5vTEIUqAs-8f-KOsb8YTx9t3F8aWSaDMcw/Jp-sR6kkF5dZUOq932HEBTNDLvcApRD9O5WSGK1HxPU", "width": 62}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/UhkRdi5KYMvCdJUfhCuM3w/MghnzN7CL2j4cgrGopwJO4OlGWcjicgPobXqVP0lClggXhPt26Xx7AYVjJtLJY-xaNzVUC11F-DqUl1YweOvT4zZAnG1JJ3F8SWBA2bhjmw/r-8GxZsYSy4oq7KhAsipcqfjgK2MdSLaQkE3sZwn940", "width": 3918}] | <p>Park on Windsor Blvd</p> | ["Marine reserve"] | Yes | No | Free | 35.547832 | -121.097269 | No | Yes | <p>Lots of great food options in nearby Cambria</p> | This site forms part of the Monterey bay National Marine Reserve. Absolutely no collecting animals or organic objects of any sort. | <p>The bluff trail is wheelchair accessible but the tidepools are not. Careful on the way down to the beach level as it is quite precarious. Always watch your back with the tide and be careful where you step.</p> | 1 | 1 | 9412110 | Lots of great varied tidepools and all the biodiversity and richness of the central coast. | Otter cove | http://blog.natbat.net/ | |||||||||||||||||
| frenchys-cove | 2020-08-31T04:23:35.000Z | rec9KANo9J4mnl6in | Anacapa Island | This site is a solid rocky bench located on the south side of West Anacapa Island, within the Channel Islands National Park. Human disturbances include trampling from light visitor use. Travel to and from Anacapa Island offers the opportunity for marine mammal sightings aboard the Island Packers boats. | us | 34.0064594 | -119.4113714 | Frenchy’s Cove | us_pacific_coast | America/Los_Angeles | Frenchy’s Cove is located on West Anacapa Island. Boat transportation to this site from Ventura Harbor is provided through Island Packers. To make reservations call (805) 642-1393. The site is accessed by a five-minute hike from one side of the island to the other, past a site monitored by the Channel Islands National Park. Boat transportation to Frenchy’s Cove, Anacapa Island, is provided through Island Packers. From the beach, take the five-minute hike from the north side of the island through the gap to the south side. There is a trail located at Frenchy’s Cove. Head west across the sandy beach to the second rocky bench. | West Anacapa Island, CA | There are no restrooms at Frenchy’s Cove. Use restrooms on the boat before going ashore. | No | ["National park"] | No | 34.2441623 | -119.2651822 | No | No | There is no food available on the island, you’ll need to bring food with you. | Collecting is not permitted in the National Park.No permit is required for monitoring, but it is important that groups do not disturb the National Park monitoring site. | |||||||||||||||||||||||||||
| 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 | ||||||||
| 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 | |||||
| shark-fin-cove | 2020-09-01T17:34:17.000Z | recbzrTCPYnWVhpAd | Santa Cruz | <p>This is a really pretty beach with shallow pools on algae covered rock benches.</p> <p>The large Shark fin shaped rock used to be part of the mudstone cliff and got its shape from erosion by the wind and waves</p> <p>There are also a small cave on the south east of the beach to explore.</p> | us | 37.003824 | -122.1855372 | Shark Fin Cove | us_pacific_coast | America/Los_Angeles | <p>From the parking lot walk south (left if you face the ocean) down a wide path over railroad tracks to a rather scrambley steep poison-oak lined path that takes you to the beach. You’ll be able to see the shark fin rock from the path. There are three rocky outcrops on the left hand side that have some small tidepools and kelp. </p> | No | Natalie Downe | [{"filename": "2020-09-01 11.23.24.jpg", "height": 2508, "id": "attZW4523qQbUtDKy", "size": 7264655, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/TcDaf6XDlQIEhpBjWd_ERQ/FtCj7WOkHFP_Sek_eHiQ--wGqOFVlL_aCD-W78UVbqYsvf9kHyV1R0U3UsYafpzX-Vpxwg7oEg_MzT0wDUnhaw/ekx-ZyEWTTxjqfy0du5xCtVu2LlS41-UzyYNJXCVZZ8", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/i3b2pFKdYOQUO-ugafbhSQ/6y9co7PVNJl3boT8jgEKE8llBp4HEUmg4dwmJVcs1_sGfXnomRJfnp0EgnQUKDfOQSH-uuQbhH-AissmQy3EgQ/AETIJK04MF6F55_rku2k37mQ3V_2sorNfmneja6zBo0", "width": 747}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/f2D29e1wz2wb2SA6ew1g6w/yw-_hfSL9c0lwYcslkZLKvyYvX_N8sq9l_x8Nsbffn0Q6gsnpstcxGEQbB2cX1z_ZoVKcgZsWNxfVVW-XygwnQ/MscbxvRDftFKCsbgBQS62RrHuLUej6S1KBn8fcIiXJU", "width": 53}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/sjnVyHIAA-BUq7sv3WtDnQ/1XFHNfLtWZG3MxcUVo9kH27CO2kOz_rC9GVmzOD_CMCniOjtpujGW1w5AtbfgGC5wuIrgoCB-tFWbZNZTiJ2l5EuqhXg9q_h--ZM_NyKGf8/HrEyVnlulh-aW71vmlqBxNHHfhScIflrRDXS3LPGA9c", "width": 3660}] | <p>Parking is available in a small dirt lot on the ocean side of highway 1</p> | ["California State Park"] | Yes | No | Free | Sunrise to sunset | 37.005745 | -122.1856066 | No | No | <p>There are some restaurants north in Davenport </p> | This beach forms part of Coast Dairies State Park. No collecting unless you have permission from the state park | Groups are allowed | <p>The path to the beach is quite steep, if you have difficulty walking you will appreciate the use of a stick to get down. Be careful of the prolific poison oak that lines this trail. Once you are on the beach the rocky outcrops are flat but slippery.</p> <p>If you go exploring in the caves be careful of the tide because the sea stacks create dangerous currents and you could be swept away.</p> | 1 | 1 | <p<As a state park unfortunately there are no dogs allowed.</p> | 9413450 | Flat rock outcrops with small tide ‘puddles’ and lots of algae | 1.5 | https://en.m.wikipedia.org/wiki/Coast_Dairies_State_Park | Shark Tooth Beach, Davenport Cove, Jah beach | <p>There is a lovely sandy beach here, great for a picnic! 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 );