Data · dataset · 2026
Surface and bottom hourly water temperature from the San Francisco Estuary, 2012-2019
Listed in California Open Data
Projected temperature increases due to global climate change are likely to have localized impacts on the San Francisco Estuary (SFE).
Description
Increased water temperature in the SFE will lead to challenges for managing water resources. Many native species, such as salmon and smelt, rely on cooler water, and will be further stressed by increased water temperature, which may cause them to seek microrefugia.
While several state and federal agencies in the SFE collect real-time water temperature data, most of the water temperature collection sites are at a fixed location or floating near the surface of the water column. This dataset includes four real-time water quality stations that provide water temperature data for both the surface and bottom positions in the water column. We obtained surface water temperature data from an integrated hourly water temperature dataset (doi.org/10.6073/pasta/7385985f68b02c0deb2a9e425a9f3ad8).
Read the rest (5 more)
This dataset included data downloaded from the California Data Exchange Center (CDEC; cdec.water.ca.gov/) and cleaned with a series of quality control (QC) checks (see integrated dataset metadata). We obtained bottom temperature data from the California Department of Water Resources (DWR) internal database Water Quality Portal (WQP). Data were integrated and standardized to hourly water temperature data in degrees Celsius, and the same series of quality control (QC) checks from the surface dataset were applied in a consistent manner to all stations.
Bottom temperatures were selected from surface temperatures to provide measures of temperature difference. Datasets included in this package include source hourly surface and bottom data, both obtained from DWR’s WQP, as well as an integrated dataset of cleaned hourly surface and bottom data, with calculated surface-bottom temperature differences. Both datasets are filtered to the timeframe used in an analysis of surface-bottom temperature differences.
Additionally, information regarding current and historical sensors used for water temperature data collection was obtained from station managers for each station and compiled in a metadata table. ## About This Federated Record This CNRA Open Data Platform record is based on metadata federated from the Environmental Data Initiative (EDI) Data Portal. Its purpose is to improve the discoverability of the data package through the CNRA Open Data Platform.
The EDI Data Portal is the repository of record for this data package. Metadata, resource links, and supporting information displayed here may not reflect the latest updates available in EDI. Resources shown here—including Full Metadata, Provenance, and Data Quality Report—are provided to help users understand and evaluate the data package and the supporting information available from EDI.
For the current data package, citation, DOI, data files, metadata, provenance, data quality documentation, revision history, and other supporting information, refer to the EDI data package landing page: portal.edirepository.org/nis/metadataviewer?packageid=edi.1057.1&key=vqSpNwnbe91Bi8trB5RY25CoPD4 Access requirements, permissions, and authorization policies for resources hosted by EDI are established and managed independently of the CNRA Open Data Platform.
Links
Get the data
- Publisher page portal.edirepository.org/nis/metadataviewer?packageid=edi.1057.1&key=vqSpNwnbe91Bi8trB5… ↗
documentation · download · from data ca gov
- EDI_SourceBottomData pasta.lternet.edu/package/data/eml/edi/1057/1/79bb1314023056a21b38335e2a2e4a55 ↗
download · from data ca gov
- EDI_SourceSurfaceData pasta.lternet.edu/package/data/eml/edi/1057/1/663ce089941cfcc633e721dd1a30c448 ↗
download · from data ca gov
- RelativeTempSurfaceBottom pasta.lternet.edu/package/data/eml/edi/1057/1/4c2c2ea2f32223ea42fb9ca4d8b5dea3 ↗
download · from data ca gov
- StationMetadata pasta.lternet.edu/package/data/eml/edi/1057/1/b302c30652f21b15dc1615ab3eeecbda ↗
download · from data ca gov
- StationsSensorMetadata pasta.lternet.edu/package/data/eml/edi/1057/1/0e36b1d72c053d412f645899d73f011d ↗
download · from data ca gov
- Provenance Metadata portal.edirepository.org/nis/provenanceGenerator?packageid=edi.1057.1&key=vqSpNwnbe91Bi… ↗
download · from data ca gov
- Dataset Quality Report portal.edirepository.org/nis/reportviewer?packageid=edi.1057.1&key=vqSpNwnbe91Bi8trB5RY… ↗
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/surface-and-bottom-hourly-water-temperature-from-the-s… ↗
landing page · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=fb6aa96f-c80c-46f4-aa35-30dbbed13… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Natural Resources · Water
- From keywords
- Climate · Earth & Environmental Science
- Inferred from text
- Tabular 65%
Provenance · 1 source records, 12 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | fb6aa96f-c80c-46f4-aa35-30dbbed13a6a | 10 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:earth-environmental | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[modality].local:modality:tabular | enrichment · data ca gov | keyword-concept-rules@1.0.0 | title+description (65%) |
| concepts[subject].local:topic:climate | mapping · data ca gov | vocabulary-mapper@1.0.0 | keywords['climate change'] |
| concepts[topic].ckan_group:data_ca_gov:natural-resources | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[topic].ckan_group:data_ca_gov:water | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| license_text | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |