places
6 rows where header_credit = "sykospark"
This data as json, CSV (advanced)
Suggested facets: area, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| la-jolla | 2017-11-26T01:47:35.000Z | recA4FMNsoo8HwtYI | San Diego | There are so many different areas for tidepooling in La Jolla that we created a map to show them all. | us | 32.8409038 | -117.2821229 | La Jolla tidepools | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/map/la-jolla-tide-pools/ | sykospark | [{"filename": "2020-09-02 11.56.11.jpg", "height": 263, "id": "attp73U4olJoOydNJ", "size": 97316, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/HzkSeSZt2IW6-hMPJ82DUA/hHkHJt9i0JknMNJ_7w53oMshCqodwQP6jCzm2p_rIBsuoe6Zqc6zXkq_hTvkcyiyBJ5xvMfSwEcSrrJ1bhz32w/unI7L1hB18LmnmqRvG7wIrRK_cVwqibSoGRls8w8hMA", "width": 3000}, "large": {"height": 263, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/qhr0chILwnWX4ta2qXA6cA/WUZ5On10xU0VF9N9IrgPnUzrPBBZyGl-Kc919WRacH2xJm_5zIUsZApEFfhOZ90lgH3hlO1FPiJQZLQq8PZOdg/_FfY6LuVHVUlAxiUC0PFuj7sfcVxCVENW_n-0cSUh0g", "width": 720}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/wdKXJgKMOa5qC_eO2AHOiA/J7LbNcRi7qTjIzj5LIp_nYa4ZWJWv_DFChLhFn-UHa6JVO_GdUrRLcqoOCWzCrBb7K65PeNgR9ElRosv3b0gSw/Bzf6JkVFfaGocIic0JgVzP6UgLcCSSdJBXWSq0_2eus", "width": 99}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/pBYpqEFiN-WbQB84RYaCig/IS1gYd1e9ob44nOHv85ZotIN33UWcH9U2B4c0uLPK5HNQ3JISdVLr2M812LzpoX3QrhJD3ZcjC4NPKw18Bz5Ypgx71QCHtOj4ZwFZbobo-4/13YBDZc8JA1li2JGqSxCpJEyQ1JEgTLJzvrrMLOq3f8", "width": 720}] | https://www.facebook.com/media/set/?set=a.10218412392520673&type=3 | |||||||||||||||||||||||||||||||||||
| 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"] | ||||||||||||||||||||||||||||||||||
| leguna-beach | 2020-09-02T19:13:46.000Z | recEokgDcPtjzNXeK | us | Leguna Beach | us_pacific_coast | America/Los_Angeles | sykospark | [{"filename": "2020-09-02 12.14.17.jpg", "height": 660, "id": "att6SADUeRg5WBYt5", "size": 340814, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ob8yAQbdIzh-11eHAQpteg/puoC5Beq0MhalJYKwU3arUtl0tCg7wWAOe6YqqpE4PUM2msA3wbk92BLgnkjqTeW2LlkiREeJy7gKt0lGwldsg/lsprtu2BFefQucGHs_nyrIouS7UBgMtztl2F1Rr7kG4", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/EQaeqLDpqWZSSZoNrLuDXQ/BrLUjHdEuRWJYO65fUyevNolO8A6jejcm7No4sYyXj1LqLrXjmMVozB6jfMC3l4GVWPBWCJgBURGw8AXZIFyZg/-mbsL0sjL2DSfWhffKi6TYvZefv96zxTS8SiFUYsIxM", "width": 696}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/I_B6pN4aTQW6ff0En8v7-g/zPj_O_aApm-hJkJFLlhPQQVaBW97KCyjVKSt_F-g5EnAtFRHNGz6hPidtmbF4jv-2BEkJG3uO_51N9NiPs92aw/uXy873idkowPGuq7c3i58-YfrgwdwCI_VAoFlP18Nxg", "width": 49}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/SSe__O3Wh6EiDb8iwD64mA/Li2KIS9ct19VYrsUdA1ocgxsy3ExUkhmqOZCmj-vgoNg7gJr-gDUwlf8Qv-VIiYX7pJT9RIwAhkd0clDoP0wTIfRjkwew5UUrgnq52Uefo4/of218R50jaJ2ktnlVgYZcSGkJUudFYCMxCH3CTcjut4", "width": 897}] | https://www.facebook.com/media/set/?set=a.10215474186587361&type=3 | ||||||||||||||||||||||||||||||||||||||||
| little-corona-del-mar | 2017-11-26T01:44:24.000Z | recBaMt0FYFfJwYhx | LA | South of Little Corona Beach there is a rock arch standing tall in the surf. Walk toward that arch at low tide and you’ll be rewarded with some top notch tide pools. | us | 33.5902452 | -117.8705083 | Little Corona Del Mar | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/beach/little-corona-del-mar-beach/ | sykospark | [{"filename": "2020-09-02 11.40.57.jpg", "height": 624, "id": "attEejTgyIepzz1Va", "size": 535452, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/eqCjCFnwUWYFm7G3U5OevA/ukJs-pT3sXXOh-iRz0jZ6MxfMCersLgNE5rkeMsKPuLLoXdEJBdecj2WI5_KELIL25g6GLB7BZzlGueH7n0VRw/Sbrka77kxYdg3AbWJy2fATuQUpSDlTQ1rB5cKp3UNqc", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/eCgqaJf4nyg8qpkQTE61AA/3Rz6INYAVfN_9417urtHRgMyW5wMQ7ej30TTZV9gnyKhQIYw0IXNZ5OiSl3z5OdTFYGllsh9XlSF3OexiaPzbg/qTn79NAOR_zXyocMeXKBZn9zoBQWrDp7QyCe8YLljrg", "width": 734}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/TZqWdnnpsV9W2TrGx8jcWQ/fR8UelPITCQRDavaSIxkvI-vmFL6csY3IJ5bdpuPecDgf6MA6XbkbT5iZVGLTbQ_AtO4m1tvWwDYV4F5tsKwHw/Z5JfOTGEcJCJrsIq1mKr7NkUDggxSrjKkDx2E3uXfLI", "width": 52}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/z_zoOJ53gqzraoA_KTWTMw/bdweu-_llNVr3U-qsewopu2UnNS2Vy0YSf5JYOGGDQRblVFz2ejdzv36-q8OnqO5e-wgwJ5MWSEDwk0txYnPBI9bQJB9fYIRoS5QR-P_5UU/Vmm_5J0u54oHx0Frz1nW_l_gW1GVys-UkOBOIMUrn0k", "width": 895}] | https://www.facebook.com/media/set/?set=a.10215966897304821&type=3 | |||||||||||||||||||||||||||||||||||
| point-fermin | 2020-08-31T04:22:20.000Z | rec6M7M58d1Op5755 | LA | Point Fermin is an expansive intertidal area with sloping reefs and uplifted benches. This site is located on the eastern portion of Cabrillo Beach Park in San Pedro, Los Angeles County. The site is accessed from the Beach Park and Cabrillo Marine Aquarium parking lot. You will have to either pay for parking or park outside the gates on the street. The study site is ahead and to the right about 300 m below the cliffs as you are standing in the parking lot facing south toward the ocean. Walk along the path across the grass until you access the boardwalk at the base of the cliffs. When the board walk ends, proceed along the intertidal to the concrete bunker foundations. | us | 33.7067878 | -118.2858259 | Point Fermin | us_pacific_coast | America/Los_Angeles | San Pedro, CA | There are public restrooms at Cabrillo Beach Park | Nearby | sykospark | [{"filename": "2020-09-02 11.37.02.jpg", "height": 627, "id": "attP4D6QEXxgPxT56", "size": 368970, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/DoOIpWrc8AyEQmFFUXtnGw/pCBOE8Cqsn85VS64jbR7KOsP-1uM5uWxHKZCPHo8c7hoqlHyZ9UFg8K4jeTJ6YMkak4xNOCQ-swg55SvFko_7g/tqAYduJmtZy9CJnbidgO1n-ryM0MA-RTdrc7xgBAjYo", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/URzcYWg7nM_eYEfJM1XIuQ/9Nf0v3bkpithTMiBdRPEEKhcD1i06OZu9gTgv4A8f9FOA3YRS7wjY_HOZVYouvRkTlcXeIUNKzRsrT8LUdFyNw/BlzoL00CKPUUh9EB5jjtu0UDjc6eS0uDIjzp00szvgE", "width": 719}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/hFZxGKKVzTWKcXy6PMq_Mg/kZRAwOmlDivouNregoIy1ozrlTntxHLfK32l7oFFeF795L257TMfhYp2kj72_t6st6NpZYfQhYTOwNDcPGZ8aw/qh-SXxQiXBu162H9Cye-FmzgWxEYmlQZwD6xOzNYAWg", "width": 51}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/ooYCFBAUfB24EN3ZzmmOKg/5QdkslS4rMGQifEuk7uYd8FrX7VIhFMUORwa0zD_3oJDuH384_ADEbMMBUd4AOHM4NzDlhAp6zaG1QzEKkgRSxpg7rfst8LsdSNIcMQqOzg/X_o7mbT3clKMLkAetMjADmQRjbhrY3zNYhwwxir3XKI", "width": 880}] | This site is located on the eastern portion of Cabrillo Beach Park in San Pedro, Los Angeles County. The site is accessed from the Beach Park and Cabrillo Marine Aquarium parking lot. You will have to either pay for parking or park outside the gates on the street. The study site is ahead and to the right about 300 m below the cliffs as you are standing in the parking lot facing south toward the ocean. Walk along the path across the grass until you access the boardwalk at the base of the cliffs. When the board walk ends, proceed along the intertidal to the concrete bunker foundations. Be sure to check the photos and GPS coordinates to be sure you are on the correct bench. Other researchers have permanent study sites here, too, and you may find their markers. | https://www.facebook.com/media/set/?set=a.10216165395187144&type=3 | ||||||||||||||||||||||||||||||||
| white-point | 2020-08-31T04:22:34.000Z | rec8FUt0g1SRPw8Rl | LA | The site is next to the remains of a hot-spring resort that prospered during the first part of the 20th century. | us | 33.7109034 | -118.3039992 | White Point | us_pacific_coast | America/Los_Angeles | San Pedro, CA | Portable toilets and restrooms are located near the base of the cliff. | sykospark | [{"filename": "2020-09-02 12.00.02.jpg", "height": 690, "id": "att36NiOqaDHLExRU", "size": 423947, "thumbnails": {"full": {"height": 3000, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/8SsGbOsOy2hg3J_Cq-9Hsw/Taxx0I7pxxLFr22ymMxehWJDubf8_2cphy2iCVvtnbjqTO0SfB_9Wiw0HijbxHxRREyHvWnI_dlwhmPAGK1ugw/aaQ3jvpGZlqzYh7bHa0A63dWkBW5t40xe9vwGOVSdpg", "width": 3000}, "large": {"height": 512, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/pSMOTvLbWSMdYJ5rQbXxIQ/er4pAG0aWdB0Nr8Q7xFQQYCqmzQflntF5sJWJhQYOt9uGiaWK00UZ8mgr7yT5nLtdf0EEfyb_k38CFXcTXaOHA/RzF5jWLVet_n4LrI5iVGUDQxd3Sau8GjJqJuoK5t1uk", "width": 683}, "small": {"height": 36, "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/xgD0q1ALsicPcrLUtnyVVA/MTwsSDbRV9Woq6rsIPEdhR-SsKWLVefzw_SIX8q0GxtcGNEtzivShv48DX59N5j9SQ2B_Wi5sPFc0o1tuMP1gw/Ixz4awWaaWAR76qLCRyKOx1w0wkHsqgl9pRFqqBJc-w", "width": 48}}, "type": "image/jpeg", "url": "https://v5.airtableusercontent.com/v1/13/13/1672632000000/UZc1F3H40TyZHifFIDiZrg/U6Oz1io-z26wxqRf_TzLMlxJMkCOrrrL42WT_gHe5dsJNAhMzyq63JRn3XcjxJBvQBvxyN_-9j1kit-D4YaI3KdHL17WMlFJqnekaTYAV1k/zyqlxK9IcQ8ODr1ANCeJssHtZ2qSmPM73GrkDjg7Unw", "width": 920}] | This site is located on the eastern portion of Royal Palms State Park/White Point County Beach in San Pedro, Los Angeles County. To reach the site, take Highway 110 (the Harbor Freeway) south until it ends at the Gaffey Street exit. Continue south on Gaffey Street to 25th Street. Turn right on 25th Street, then left on Western. At the end of Western, turn left on Paseo del Mar, then right into the Park. The road goes down to the beach where you should turn left and go to the end of the pavement to park. | https://www.facebook.com/media/set/?set=a.10218532959814780&type=3 | Yes | The park day use fee is $6 per vehicle | The park gate closes at 4:30 pm; the park closes at 5 pm. |
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 );