places
3 rows where area = "San Diego"
This data as json, CSV (advanced)
Suggested facets: airtable_createdTime (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| dyke-rock | 2020-08-31T04:22:19.000Z | recefZRfMakgL2HnE | San Diego | Dike Rock is located in La Jolla, California, within the Scripps Coastal Reserve just north of the Scripps Pier. Dike Rock is a small rocky intertidal area bordered on either side by sandy beach. This site is characterized by many large boulders in the high intertidal, broad mud and sandstone benches covered with coralline algal turf in the mid-intertidal, and a mixture of larger boulders and algae-covered flats in the lower intertidal area | us | 32.8715947 | -117.2531818 | Dyke Rock | us_pacific_coast | America/Los_Angeles | http://scripps.ucnrs.org/ | Dike Rock is located North of the Scripps Pier. If you park near Scripps Institute of Oceanography there are two staircases just south of the pier leading down to the beach. | La Jolla, CA | Restrooms are not available near Dike Rock. The nearest restroom is located at La Jolla Shores. | From Interstate 5, exit La Jolla Village Drive. Turn left onto La Jolla Shores Drive. Continue down the hill and park anywhere along the street near the beach, or in the La Jolla Shores beach parking lot. | ||||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||||
| point-loma | 2017-11-26T01:40:33.000Z | recPhjqUswwfmzE6W | San Diego | These tide pools can be found below the sandstone cliffs of Point Loma on the ocean side of the park. Ask for directions when you stop at the entrance booth. Look for fossils in the rocks while you are exploring the shoreline. | us | 32.668331 | -117.2445294 | Point Loma | us_pacific_coast | America/Los_Angeles | http://www.californiabeaches.com/attraction/point-loma-tide-pools/ |
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 );