places
1 row where address = "26198 Scenic Road, Carmel, CA" and managment contains "California State Marine Conservation Area"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
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 );