places
2 rows where area = "LA" and managment contains "California State Park"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| carpinteria-state-beach | 2020-08-31T04:30:59.000Z | recAVPHG8YFCNXy2o | LA | The site is straight offshore, about 40 meters from the staircase and centered on the outermost and largest mussel-covered rock outcrop. The outcrop is surrounded by sand. It consists of a oceanward portion and a shoreward portion, separated by a narrow connection (“neck”) that bridges over two small tunnels Contact Carpinteria State Park well in advance of your scheduled rocky intertidal trip. The Park has a policy about the number of people who can go on the reef in a day Contact is Marie Lindsey at (805) 684-7487 or mlindsey@parks.ca.gov. You might also consider scheduling a tidepool walk with a ranger, guided walks last approximately one hour. | us | 34.3872536 | -119.516589 | Carpinteria State Beach | us_pacific_coast | America/Los_Angeles | A staircase, just southeast from the parking lot, leads to the beach. | Carpinteria, CA | There are a few public restrooms inside the park. | Yes | This site is located at the east end of Carpinteria State Park in Carpinteria, Santa Barbara County. Take Highway 101 to Carpinteria (east of Santa Barbara). Get off at the Casitas Pass Rd exit and turn toward the ocean. Take a right on Carpinteria Drive, then take the first left on Palm Avenue. Go all the way to the end of Palm Avenue and enter Carpinteria State Park. After going through the kiosk, take a sharp left and proceed down the coast to the very end where there is a little cul-de-sac where you can park. | ["California State Park"] | 34.388201 | -119.5147189 | Yes | The Park waives parking fees for school groups, but you must first submit a school group reservation form that the park will send you when you call to schedule a field trip. Contact is Marie Lindsey at (805) 684-7487 or mlindsey@parks.ca.gov. | |||||||||||||||||||||||||||||
| lee-carrillo-state-park | 2017-11-26T01:51:05.000Z | recgQuH2RAJVEXjyb | LA | The tide pools at Leo Carrillo State Park are located below Sequit Point between North Beach and South Beach. In addition to abundant marine life, this area of the shoreline has caves and rock arches to duck into. It’s a fun place for kids. | us | 34.0436707 | -118.9392402 | Lee Carrillo State Park | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/map/leo-carrillo-state-park/ | sykospark | [{"filename": "2020-09-02 12.04.19.jpg", "height": 631, "id": "attu4Eft5m5szKbSd", "size": 479916, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/1Nv7y5jj7qFkGUEMddFOQg/20YUx4FaRASqO9bjWILArA8qP41k24184doq90E0NcYNTZNwxshNnI_tpFFGP740pRXJWmTA84WMBRsgr8wGCQ/HXbcChOGzspd56A0NijC_ljIh6g_ObY4d4GwHB64f5s", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/TkxKZSR2hvCRZAUknD2ZJg/LVitcX42V1BR5pihZOqAKUI1FNAN0GPBhxZO3b_9KHSWLxn7dcbeCjDFYx4uaNYG-z5W2TmBnqLXcAW0ihPedQ/5apvmJ8GC8mPAEVZ20ko-HcRl1RkaTSW4RDuPRA98bA", "width": 744}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/z_OoG3R4u0rKJgIjes32-w/hr9_DRqrNdPDkcz45O8rAZ-_ZuHhzpx3fBcZNslGL2KJFE2-q3JdByRUHq6DS5Cv-O6oFHXmfjoI8qvQtq5JAw/XRBWRztcrbLisElDf_mSY5ONfbHcW97_h3cLMrf_VfQ", "width": 52}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ogQe-ipR4x19U_IZUpTFyw/caQ5DUqkMo_cSEkxngv_wRD9tnWFESeLpzRU0Yra9-LYBmunTw4q2Kp7E5BOPDEwU8RjD0GGiwXEJxTvsLo-dpPI82f5-ewPceU0D5wKeHc/YG9qzGh_HTdP8YgKF3tgihgnzSKPlGzToGGyO8G0ku4", "width": 917}] | https://www.facebook.com/media/set/?set=a.10221385355002877&type=3 | ["California State Park"] |
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 );