places
3 rows where "airtable_createdTime" is on date 2020-08-31 and managment contains "California State Marine Conservation Area"
This data as json, CSV (advanced)
Suggested facets: managment, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| carmel-point | 2020-08-31T04:33:12.000Z | recj6qWTG3XMoGZRZ | Carmel/Monterey | This whole area is a granite outcrop with a good amount of relief. Be prepared to climb over the rocks and around pools. The rocks and alga-covered boulders are difficult to traverse. Be careful! Make certain that anyone visiting the site has suitable shoes and an extra change of clothes. | us | 36.5438817 | -121.9339618 | Carmel Point | us_pacific_coast | America/Los_Angeles | The site is in a small cove between the north point of Carmel Point and a large white house on the seaward side of the road called the Seaburst House, 26198 Scenic Road. Park on Ocean View across from the Seaburst House. This is a small quiet residential area so be careful to keep noise to a minimum. | 26198 Scenic Road, Carmel, CA | A public restroom is maintained at the mouth of the Carmel River and can be reached by driving south on Scenic Road around Carmel Point to the Carmel River Beach State Beach | Nearby | Google Street View | [{"filename": "2020-08-31 17.33.09.jpg", "height": 697, "id": "attLYYmQzMMHLkkX6", "size": 973529, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/8aP7tZR6318RBtq11gl9pA/SmKL6DYT536PX_wYVfSpJPJi4s4b-z_LuEsajo_ZgZI1gSrATrYS7bQZQnKajuDldZEBJo1P1GjaPQL_fD1kFA/EFgVS7BZa8Tr8y0vGsMENlKZzoI-VRcYyNf2sIvSBaE", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/VaOgSgXN_-OAXkrirTdc9Q/V6LR5OG9MkmujG_EHXXpGmiZnaAuGFyh47VI3X2uWHt_mcjlR5Waob7S_ecHFB7fxRKEWNmT5y4UP2qJSyjBLw/e4MJPsSQviXUlv8y_EEpCF_zrUFx8ZyYMAKhQthcyIY", "width": 1532}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/NsxhEpu9CMKoN4NgHXbLsA/yTpj931KCMGhtc-66u8POCpiowckr9Q614DR0lHbB3g9gffN19L1v1Ny_OEzFGI4xgpTF9hfbh3pKvD6IED24A/e4VosE25amfg3vL9w3u1l0qNhHeKcBOMRCghVy0O-oo", "width": 108}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/A2479l-mb0mJHMbeZChCFw/GdST6P9gLjVO-4hoEbFzOa2xVIKQhTq6cMaj8hcJuSeDyfykM4NY6IGXeHCCuMt0m72gcA0d-TcCGuEAmN2sUCJs26EsCTsoQdlfvmJRFP8/2Lal5TnKhcVa-VIBouxz3n9WavNJoD8S-w7aGTXEnc0", "width": 2085}] | The Carmel Point tidepools is in the center of Carmel Bay on Scenic Road at Ocean View Road. Park on ocean view opposite sea burst house. Scenic Road runs parallel to the shore along Carmel Beach then, at the south end of Carmel Beach, turns westward and goes around Carmel Point to Carmel River Beach State Park. | ["California State Marine Conservation Area"] | 36.5438451 | -121.9333204 | Carmel Point is located within the Carmel Bay State Marine Conservation Area. Recreational take of invertebrates and marine aquatic plants is illegal. | Busses may find the small windy roads difficult. | https://goo.gl/maps/L9jcMig6eQDKVnMs5 | ||||||||||||||||||||||||||
| coal-oil-point | 2020-08-31T04:31:39.000Z | recX4H63f8kUQqBbF | Santa Barbara | Coal Oil Point is a low-lying flat rocky reef with scattered boulders and surge channels. The reef is often partially buried in sand in spring and summer months. Mussel beds can only be found on larger boulders and raised areas. Be careful of old pier piling remains as this area was once an active oil field. This is also a pop | us | 34.406672 | -119.8779161 | Coal Oil Point | us_pacific_coast | America/Los_Angeles | <p>Follow the trail west along the coast from the line of trees car parking. There is a slope down to beach level and close to there is the reef</p> | Santa Barbara, CA | There is a portable restroom available on the bluff top, near the entrance to the western beach trail. Other facilities are available in the Isla Vista business district. | Yes | If you do not have a UC Santa Barbara West Campus parking pass, you will need to park in the western end of the community of Isla Vista and walk aproximately 0.5 miles to the point either on the blufftop trail or along the beach To reach the parking area, turn left at the junction with El Colegio from Storke and then take your next right, at Camino Corto. Drive 5 blocks to Del Playa. Turn right and drive for two blocks, and park along the row of trees. A trail leads out to the point and COPR. | ["University of California", "UC Santa Barbra", "California State Marine Conservation Area"] | 34.4100387 | -119.8696294 | Recreational or commercial take of marine life is prohibited. | <p>Groups must make a <a href=“http://coaloilpoint.ucnrs.org/“>reservation prior to visiting</p> | http://www.dfg.ca.gov/marine/mpa/scmpas_list.asp | ||||||||||||||||||||||||||||
| san-simeon | 2020-08-31T04:32:35.000Z | recsMdvJYtGcDhzg1 | San Simeon | This is a gently undulating rocky area with some high and low areas. The amount of relief to the rocks is fairly minimal to low. As with any site with deep channels, watch the water level as the tide comes in so no one gets stranded! | us | 35.6041315 | -121.1420191 | San Simeon | us_pacific_coast | America/Los_Angeles | There is a public access trail from the intersection of Vista del Mar and Balboa, walk across a vacant lot to the beach. Once on the sandy beach, walk south until you reach a sloping rock platform that rises above the sand. | There are no public restrooms at or near this site. | No | Natalie Downe | [{"filename": "2020-09-01 17.32.01.jpg", "height": 1195, "id": "attZStboyr9Hcu7n6", "size": 2097003, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/w4-5-dSTdjOQ0vP8RtPBBQ/RtBzRI9_ZaG4CysUYTMr69XqEujCDdJK0x-EWYnigFMruTbgLGS3a4WDBV5R9ZnfJ-rxL-JCrs5D2V7VK-z6tw/LiaE2SWfFxtnx-pc5SXrgBmrDkmOmr4YKLYkBu_-4OU", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/uwF1zmIFmiye7q3-ymNylg/lJmglq8kjxsSOEsxNSuxGEqxGrQLj4FnNddBHeRZ2d9VTJqMQuU3raDDxb6UZfngl3oyd9tlirPys5eesyykkQ/o_eyVdN6zG7zq4UXJ_DhWIsRptZdB9qxYVf01S7aXlg", "width": 1425}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/Y2r8GN3hpAMOghk-1Aa6fA/dG_SVR0r0btsNgUoWQnI5lmtLl8I5FxQwjAxCOUOzrkBE_Uxqx6ug9RTBEP9zM6_sm0Mjl8fBH3MZMQJBfBJOw/szUKvjnq_bxM8IY_JNbhQlP5IYOI4Xaq07YkAoSsEqE", "width": 100}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/6MgzSfwgEYwABYjT9e7d-g/xg9YIR5AsKJkzEpSE4qLrw5IUFMcb4rg3dqgcTL7Npe6B5mlJ-Q1gKpWLQ2ydbSbYPQ3TxLf_wj5RxLAr1UEKS1MBXKCOO6k6CARNJ-VzU4/mPdWLyOsm40n_72LJNFdeYyVyeIwAle57tF1qyaJmqw", "width": 3325}] | This site is about a quarter of a mile south of the town of San Simeon. From Highway 1 at the Sea Breeze Inn, turn onto on Vista del Mar, the southernmost road in town. Drive to the end of Vista del Mar and park where it meets Balboa. | ["California State Marine Conservation Area"] | 35.6096026 | -121.1435476 | This San Simeon intertidal site is located within the Cambria State Marine Conservation Area. It is part of a network of marine protected areas recently established by the state of Calfornia. Recreational take of living resources is allowed with a valid fishing license; however, all commercial fishing is prohibited | 1 | http://blog.natbat.net/ |
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 );