ExperimentalWe used data and feedback to make a user-friendly site. We’d love your feedback.
Back to data.ca.gov.

Surface and bottom hourly water temperature from the San Francisco Estuary, 2012-2019

Projected temperature increases due to global climate change are likely to have localized impacts on the San Francisco Estuary (SFE). 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 (https://doi.org/10.6073/pasta/7385985f68b02c0deb2a9e425a9f3ad8). This dataset included data downloaded from the California Data Exchange Center (CDEC; https://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: https://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.

Data files

No files available

Supporting files

Data title and descriptionAccess dataFile detailsLast updated

EDI_SourceBottomData

Source Hourly Bottom Data from all four stations

CSV (EXTERNAL DOWNLOAD)
09/25/26

EDI_SourceSurfaceData

Surface Hourly Bottom Data from all four stations

CSV (EXTERNAL DOWNLOAD)
09/25/26

RelativeTempSurfaceBottom

Surface and Bottom Temperatures from all 4 water quality stations

CSV (EXTERNAL DOWNLOAD)
09/25/26

StationMetadata

List of Stations included in dataset with accompanying information regarding start, station and sensor location.

CSV (EXTERNAL DOWNLOAD)
09/25/26

StationsSensorMetadata

Metadata regarding water temperature sensors from stations. Table lists contacts from each monitoring group, and information provided by contacts regarding current and historical sensors used for water temperature monitoring.

CSV (EXTERNAL DOWNLOAD)
09/25/26

Provenance Metadata

This method step describes provenance-based metadata as specified in the LTER EML Best Practices. This provenance metadata does not contain entity specific information.

HTML
09/25/26

Full Metadata

A link to the original metadata web page on the EDI Portal

HTML
09/25/26

Dataset Quality Report

A link to the EDI Quality Metadata Page

HTML
09/25/26

API endpoint

Dataset Name

Use the query web API to retrieve data with a set of basic parameters. Copy the API endpoint you need to start.

Usage documentation