Data Package Metadata View Summary

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

General Information

Data Package:

Local Identifier:

edi.591.5

Title:

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

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

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.

Publication Date:

2021-12-22

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

2012-07-16

End:

2019-12-27

People and Organizations
Contact:	Nelson, Michelle M (California Department of Water Resources, Environmental Scientist) [ email ]
Creator:	Nelson, Michelle M (California Department of Water Resources, Environmental Scientist)
Creator:	Pien, Catarina (California Department of Water Resources, Environmental Scientist)
Associate:	Hartman, Rosemary (DWR, Associate)
Associate:	Davis, Brittany (DWR, Associate)

Data Entities
Data Table Name:	EDI_SourceBottomData
Description:	Source Hourly Bottom Data from all four stations
Data Table Name:	EDI_SourceSurfaceData
Description:	Surface Hourly Bottom Data from all four stations
Data Table Name:	RelativeTempSurfaceBottom
Description:	Surface and Bottom Temperatures from all 4 water quality stations
Data Table Name:	StationMetadata
Description:	List of Stations included in dataset with accompanying information regarding start, station and sensor location.
Data Table Name:	StationsSensorMetadata
Description:	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.

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/591/5/79bb1314023056a21b38335e2a2e4a55
Name:	EDI_SourceBottomData
Description:	Source Hourly Bottom Data from all four stations
Number of Records:	258458
Number of Columns:	11

Table Structure

Object Name:

EDI_SourceBottomData.csv

Size:

15841404 byte

Authentication:

f59209498cd7d8de6724a3166cd3b810 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Station

Datetime

Temp

QAQC Flag

WaterCol

Date

Year

Month

Day

Hour

Minute

Column Name:

Station

Datetime

Temp

QAQC Flag

WaterCol

Date

Year

Month

Day

Hour

Minute

Definition:

Name of the water quality station

year-month-day hour:minute

temperature in Celsius

QAQC Flags

bottom position of water temperature collection

year-month-day

year

numerical month of the year

day of the month

hour of the day

minutes at the quarter hour

Storage Type:

string

dateTime

float

string

dateTime

float

string

Measurement Type:

nominal

dateTime

ratio

nominal

dateTime

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	ANH
Definition	San Joaquin River at Antioch Water Quality Station
Source

Code Definition

Code	MAL
Definition	Sacramento River at Mallard Island Water Quality Station
Source

Code Definition

Code	MRZ
Definition	Martinez Water Quality Station
Source

Code Definition

Code	RRI
Definition	Rough and Ready Island Water Quality Station at the Port of Stockton
Source

Format	YYYY-MM-DD hh:mm
Precision

Unit	celsius
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	G
Definition	Good Data
Source

Code Definition

Code	U
Definition	Unchecked data
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Bottom
Definition	Bottom temperature in celsius
Source

Format	YYYY-MM-DD
Precision

Unit	year
Type	integer

Unit	month
Type	integer

Unit	day
Type	integer

Unit	hour
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	0 minute of the hour
Source

Code Definition

Code	15
Definition	15th minute of the hour
Source

Code Definition

Code	30
Definition	30th minute of the hour
Source

Code Definition

Code	45
Definition	45th minute of the hour
Source

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/591/5/663ce089941cfcc633e721dd1a30c448
Name:	EDI_SourceSurfaceData
Description:	Surface Hourly Bottom Data from all four stations
Number of Records:	260160
Number of Columns:	11

Table Structure

Object Name:

EDI_SourceSurfaceData.csv

Size:

16203687 byte

Authentication:

4934a47c9e02f2bccaf5a41865fb3171 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Station

Datetime

Temp

QAQC Flag

WaterCol

Date

Year

Month

Day

Hour

Minute

Column Name:

Station

Datetime

Temp

QAQC Flag

WaterCol

Date

Year

Month

Day

Hour

Minute

Definition:

Name of the water quality station

year-month-day hour:minute

temperature in Celsius

QAQC Flags

surface position of water temperature collection point

year-month-day

year

numerical month of the year

day of the month

hour of the day

minutes at the quarter hour

Storage Type:

string

dateTime

float

string

dateTime

float

string

Measurement Type:

nominal

dateTime

ratio

nominal

dateTime

ratio

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	ANH
Definition	San Joaquin River at Antioch Water Quality Station
Source

Code Definition

Code	MAL
Definition	Sacramento River at Mallard Island Water Quality Station
Source

Code Definition

Code	MRZ
Definition	Martinez Water Quality Station
Source

Code Definition

Code	RRI
Definition	Rough and Ready Island Water Quality Station at the Port of Stockton
Source

Format	YYYY-MM-DD hh:mm
Precision

Unit	celsius
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	G
Definition	Good Data
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Surface
Definition	position in water column of data collection
Source

Format	YYYY-MM-DD
Precision

Unit	year
Type	integer

Unit	month
Type	integer

Unit	day
Type	integer

Unit	hour
Type	integer

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	0 minute of the hour
Source

Code Definition

Code	15
Definition	15th minute of the hour
Source

Code Definition

Code	30
Definition	30th minute of the hour
Source

Code Definition

Code	45
Definition	45th minute of the hour
Source

Missing Value Code:

Code	NA
Expl	missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/591/5/4c2c2ea2f32223ea42fb9ca4d8b5dea3
Name:	RelativeTempSurfaceBottom
Description:	Surface and Bottom Temperatures from all 4 water quality stations
Number of Records:	252711
Number of Columns:	12

Table Structure

Object Name:

RelativeTempSurfaceBottom.csv

Size:

18831944 byte

Authentication:

d59a358e98ad4931b6464501069e572e Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Station

Datetime

Date

Surface

Bottom

Month

Year

RelTempDiff

TOD

julian

Column Name:

Station

Datetime

Date

Surface

Bottom

Hour

Month

Year

RelTempDiff

TOD

julian

Definition:

Name of the water quality station

year-month-day hour:minute

year-month-day

numerical temperature readings Celsius from the surface sensor of the water column

numerical temperature readings Celsius from the bottom sensor of the water column

hour of day

numerical month of the year

year

temperature differences between bottom and surface readings (Bottom- Surface=RelTempDiff)

time of day categories used for analysis

The Julian day is the continuous count of days since the beginning of the Julian period (new years day).

Water Year is defined as the 12-month period beginning October 1st of any given year through September 30 of the following year.

Storage Type:

string

dateTime

float

string

float

Measurement Type:

nominal

dateTime

ratio

nominal

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	ANH
Definition	San Joaquin River at Antioch Water Quality Station
Source

Code Definition

Code	MAL
Definition	Sacramento River at Mallard Island Water Quality Station
Source

Code Definition

Code	MRZ
Definition	Martinez Water Quality Station
Source

Code Definition

Code	RRI
Definition	Rough and Ready Island Water Quality Station at the Port of Stockton
Source

Format	YYYY-MM-DD hh:mm
Precision

Format	YYYY-MM-DD
Precision

Unit	celsius
Type	real

Unit	celsius
Type	real

Unit	hour
Type	integer

Unit	month
Type	integer

Unit	year
Type	integer

Unit	celsius
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	nan
Definition	not a number
Source

Code Definition

Code	Early:0-7
Definition	12:00 to 07:00 (Pacific Standard Time)
Source

Code Definition

Code	Late:16-23
Definition	16:00 to 23:59 (Pacific Standard Time)
Source

Code Definition

Code	Mid:7-15
Definition	07:01 to 15:59 (Pacific Standard Time)
Source

Unit	julian day
Type	integer

Unit	Water year
Type	integer

Missing Value Code:

Code	NA
Expl	time of day could be missing

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/591/5/b302c30652f21b15dc1615ab3eeecbda
Name:	StationMetadata
Description:	List of Stations included in dataset with accompanying information regarding start, station and sensor location.
Number of Records:	4
Number of Columns:	10

Table Structure

Object Name:

StationMetadata.csv

Size:

667 byte

Authentication:

6a0a6056c0f212d9b4fef17072b19c8a Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Station

StationName

StartDateDataset

Agency

Latitude

Longitude

HydrologicArea

Basin

County

HabitatType

Column Name:

Station

StationName

StartDateDataset

Agency

Latitude

Longitude

HydrologicArea

Basin

County

HabitatType

Definition:

CDEC station code

CDEC station full name

Start date of data collection at each specific site

Agency responsible for managing sensor

decimalDegree

Hydrologic area, specified by CDEC

Basin, specified by CDEC

County in which station is located

Habitat type, standardized and assigned by water quality team, see code defintions.

Storage Type:

string

Measurement Type:

nominal

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	ANH
Definition	San Joaquin River at Antioch Water Quality Station
Source

Code Definition

Code	MAL
Definition	Sacramento River at Mallard Island Water Quality Station
Source

Code Definition

Code	MRZ
Definition	Martinez Water Quality Station
Source

Code Definition

Code	RRI
Definition	Rough and Ready Island Water Quality Station at the Port of Stockton
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	MARTINEZ
Definition	Martinez Water Quality Station
Source

Code Definition

Code	ROUGH AND READY ISLAND
Definition	Rough and Ready Island Water Quality Station at the Port of Stockton
Source

Code Definition

Code	SACRAMENTO RIVER AT MALLARD ISLAND
Definition	Sacramento River at Mallard Island Water Quality Station
Source

Code Definition

Code	SAN JOAQUIN RIVER AT ANTIOCH
Definition	San Joaquin River at Antioch Water Quality Station
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1987-02-02
Definition	start date
Source

Code Definition

Code	1994-07-01
Definition	start date
Source

Code Definition

Code	1994-12-31
Definition	start date
Source

Code Definition

Code	2000-08-28
Definition	start date
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	DWR
Definition	California Department of Water Resources
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	37.963
Definition	decimalDegrees
Source

Code Definition

Code	38.0178299
Definition	decimalDegrees
Source

Code Definition

Code	38.02763748
Definition	decimalDegrees
Source

Code Definition

Code	38.04280472
Definition	decimalDegrees
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	-122.14048770000001
Definition	decimalDegrees
Source

Code Definition

Code	-121.9200897
Definition	decimalDegrees
Source

Code Definition

Code	-121.80296329999999
Definition	decimalDegrees
Source

Code Definition

Code	-121.365
Definition	decimalDegrees
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Sacramento River
Definition	name of river
Source

Code Definition

Code	San Francisco Bay
Definition	name of bay
Source

Code Definition

Code	San Joaquin River
Definition	name of river
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	East Bay
Definition	name of region defined by CDEC
Source

Code Definition

Code	Sacramento R
Definition	name of region defined by CDEC
Source

Code Definition

Code	San Joaquin R
Definition	name of region defined by CDEC
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Contra Costa
Definition	name of country station is in
Source

Code Definition

Code	San Joaquin
Definition	name of country station is in
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Tidal River Channel (brackish)
Definition	A natural brackish river (higher salinity than freshwater, resulting from a mixture of estuarine river and seawater) whose flow and level are influenced by tides.
Source

Code Definition

Code	Tidal River Channel (freshwater)
Definition	A natural river, mainly freshwater, whose flow and level are influenced by tides.
Source

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/591/5/0e36b1d72c053d412f645899d73f011d
Name:	StationsSensorMetadata
Description:	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.
Number of Records:	8
Number of Columns:	20

Table Structure

Object Name:

StationsSensorMetadata.csv

Size:

4044 byte

Authentication:

7686fdd68395dc678ee28355523e83dc Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Station

StationName

Contact

Program

SensorStatus

PositionOfSensorMeasurement

PositionOfSensorAttachment

DistanceFromSensorAttachmentPoint

SensorDepth

InstrumentManufacturer

InstrumentModel

CDECUnits

CDECPrecision

SensorAccuracy

DistanceFromShore

Comments

AdditionalDataSource

StartDateAdditionalData

EndDateAdditionalData

Column Name:

Station

StationName

Contact

Program

SensorStatus

PositionOfSensorMeasurement

PositionOfSensorAttachment

DistanceFromSensorAttachmentPoint

SensorDepth

InstrumentManufacturer

InstrumentModel

CDECUnits

CDECPrecision

SensorAccuracy

DistanceFromShore

Comments

AdditionalDataSource

StartDateAdditionalData

EndDateAdditionalData

Definition:

CDEC station code

Station long name

Station contact names

Program managing station

Station contact email address(es)

is sensor currently active or discontinued?

Is sensor measuring surface or bottom temperature?

t Is sensor attached to the surface or bottom?

What is the fixed distance of the sensor from attachment point?

Physical depth of the sensor in the water column

Instrument Manufacturer

Instrument Model

CDEC water temperature units reported

Precision of water temperature reported; Units depend on CDEC reporting units

Accuracy of sensor in degrees Celsius

Distance of sensor from shore

Additional comments

Is there an additional temperature source other than CDEC? If so, list.

Start date of data not on CDEC

End date of data not on CDEC; note for the purposes of this dataset the latest end date is 2019-12-31, though data may still be collected on CDEC after this date.

Storage Type:

string

dateTime

string

Measurement Type:

nominal

dateTime

Measurement Values Domain:

Definition

CDEC station code

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	MARTINEZ
Definition	name of station
Source

Code Definition

Code	ROUGH AND READY ISLAND
Definition	name of station
Source

Code Definition

Code	SACRAMENTO RIVER AT MALLARD ISLAND
Definition	name of station
Source

Code Definition

Code	SAN JOAQUIN RIVER AT ANTIOCH
Definition	name of station
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Michelle Nelson & Scott Waller
Definition	personnel names
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	DES-Continuous Environmental Monitoring Program
Definition	Division of Environmental Services (renamed Division of Integrated Science and Engineering in 2021)- Continuous Environmental Monitoring Program
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Michelle.Nelson@water.ca.gov; Scott.Waller@water.ca.gov
Definition	email addresses for contacts
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Active
Definition	Active station
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Bottom
Definition	Fixed from Surface: Bottom
Source

Code Definition

Code	Surface
Definition	Surface: Floating at Surface
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Bottom
Definition	Bottom
Source

Code Definition

Code	Floating at Surface
Definition	Surface
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	1 meter
Source

Code Definition

Code	2
Definition	2 meters
Source

Code Definition

Code	6
Definition	6 meters
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1.0
Definition	1 meter
Source

Code Definition

Code	6.5
Definition	6.5 meters
Source

Code Definition

Code	7.0
Definition	7 meters
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	YSI
Definition	YSI instruments
Source

Code Definition

Code	YSI(2008-Present); Schneider Instruments (Prior to 2008)
Definition	YSI instruments, Schneider Instruments
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	EXO
Definition	model of instrument
Source

Code Definition

Code	EXO (07 DEC 2016-Present), 6600 (16 OCT 2008-07 DEC 2016), RM25 (Prior to 2008)
Definition	model of instrument
Source

Code Definition

Code	EXO (14 JUL 2015-Present), 6600 ( 06 NOV 2008-14 JUL 2015), RM25 (Prior to 2008)
Definition	model of instrument
Source

Code Definition

Code	EXO (16 MAR 2016-Present), 6600 (06 FEB 2008-16 MAR 2016), RM25 (Prior to 2008)
Definition	model of instrument
Source

Code Definition

Code	EXO (28 JUL 2014-Present), 6600 (06 FEB 2008-28 JUL 2014), RM25 (Prior to 2008)
Definition	model of instrument
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	nan
Definition	not a number
Source

Code Definition

Code	F
Definition	Fahrenheit
Source

Code Definition

Code	F, C
Definition	F= Fahrenheit, C= Celsius
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0.1
Definition	0.1%
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0.2 (2014-Present), 0.15 (2008-2014), 0.5 (Prior to 2008)
Definition	% accuracy (time sensor was used)
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	25
Definition	25 meters
Source

Code Definition

Code	60
Definition	60 meters
Source

Code Definition

Code	275
Definition	275 meters
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	nan
Definition	no comment
Source

Code Definition

Code	Data not reported to CDEC, Sensor depths varies between 5.8 meters to 7.2 meters deep
Definition	Additional comments
Source

Code Definition

Code	Data not reported to CDEC; Sensor depths vary between 6 and 7 feet
Definition	Additional comments
Source

Code Definition

Code	Data not reported to CDEC; Sensor depths vary between 6.1 and 7.6 feet
Definition	Additional comments
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Water Quality Portal (Internal DES)
Definition	internal DES database
Source

Format	YYYY-MM-DD
Precision

Format	YYYY-MM-DD
Precision

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	no extra comment was necessary

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Package Usage Rights

This information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
(No thesaurus)	California Data Exchange Center, CDEC, San Francisco Estuary, Sacramento-San Joaquin Delta, California Department of Water Resources, Continuous Environmental Monitoring
LTER Controlled Vocabulary	estuaries, water, water quality, long term monitoring, climate change

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

Methods and protocols used in the collection of this data package

Description:

Continuous Environmental Monitoring

The Continuous Environmental Monitoring Program (CEMP) monitors real-time water quality conditions throughout the Sacramento-San Joaquin River Delta and Suisun Bay. Data is transmitted to the California Data Exchange Center (CDEC) via wireless telemetry in real-time to provide information on Delta conditions. Real- time data is collected every 15 minutes, 365 days a year. These systems include standalone water quality instruments YSI EXO sondes. The water quality components are mandated by Water Right Decision 1641 and provide necessary information for compliance with flow-related water quality standards associated with the operations of the California water projects. CEMP Stations included in the datasets are: Antioch (ANH) in the San Joaquin River, Mallard Island (MAL) in the confluence area of the Sacramento and San Joaquin Rivers, Martinez (MRZ) at Carquinez Strait, and Rough and Ready Island (RRI) in the San Joaquin River at the Port of Stockton.

==================== Data Sources =========================

DWR's Continuous Environmental Monitoring at the Division of Integrated Science and Engineering

===========================================================

Description:

Data Sources and Cleaning

This data package includes two datasets: a source dataset, and a cleaned dataset.

The raw datasets (EDI_SourceBottomData.csv and EDI_SourceSurfaceData.csv) contains surface and bottom water temperature data provided by CEMP. For these data, CEMP does a preliminary visual inspection of the temperature data daily and does a monthly visual inspection of outliers, removing and flagging data as needed. CEMP uses an internal database system (Water Quality Portal) to edit data based on guidance from The Quality Assurance Program at DWR which uses a modified Wagner Method (Wagner, R.J., Boulger, R.W., Jr., Oblinger, C.J., and Smith, B.A., 2006, Guidelines and standard procedures for continuous water-quality monitors—Station operation, record computation, and data reporting: U.S. Geological Survey Techniques and Methods 1–D3, 51 p http://pubs.water.usgs.gov/tm1d3) to rate and flag data. The flags the CEMP uses are as follows:

G = Good Data

X = Bad Data

M = Missing Data

A = Added Data Point

U = Unchecked Data

We filtered out flags of “X”, “M”, and “A”, leaving only good and unchecked data in the raw dataset. Please use the contact for this dataset for any further QA/QC inquiries. Data were downloaded and processed in R version 3.6.2.

The cleaned dataset (RelativeTempSurfaceBottom.csv) contains data from two sources: surface data from the integrated hourly water temperature dataset (integrated dataset) (https://doi.org/10.6073/pasta/7385985f68b02c0deb2a9e425a9f3ad8), and bottom data from WQP, as described above. Creators of the integrated dataset downloaded raw data from the California Data Exchange Center (CDEC) to ensure they could treat all data consistently. This raw dataset was treated with several Quality Control (QC) checks, including checks for overall range, missing values, repeating values, anomalies, spikes, and rate of change (see metadata from integrated dataset for more details). We subsetted the integrated dataset to match stations with corresponding bottom water temperature sensor data. Bottom water temperature data were obtained from CEMP. QC checks applied in the integrated dataset were also applied to bottom water temperature data from WQP for consistency.

==================== Data Sources =========================

https://doi.org/10.6073/pasta/7385985f68b02c0deb2a9e425a9f3ad8

===========================================================

Description:

Data Manipulation and Integration

We converted raw and cleaned datasets to hourly data (if not already), and subsetted data to a timeframe where all surface-bottom temperature contained data. For the cleaned datasets, we combined surface and bottom temperature data into an integrated dataset, matched up bottom and surface water temperature data by date and time, and further filtered data to remove any data points missing a matching surface or bottom temperature value. We calculated the surface-bottom temperature difference (surface water temperature-bottom water temperature) at each time point and station. We classified samples into categories of time of day (insert details), and generated julian day (day of calendar year) and water year in the dataset, which were used for analyses.

Integrated Dataset:

1. Surface temperature data was taken from [Interagency Ecological Program, C. Pien, J. Hamilton, R. Hartman, M. Nelson, J. Saraceno, B.M. Schreier, and B. Davis. 2020. Hourly water temperature from the San Francisco Estuary, 1986 - 2019 ver 2. Environmental Data Initiative. https://doi.org/10.6073/pasta/7385985f68b02c0deb2a9e425a9f3ad8 (Accessed 2021-11-29)].

2. Bottom temperature data was requested from DWR’s CEMP Program.

3. Bottom temperature data was processed with the same QC quality filters as “Interagency Ecological Program C. Pien et. al.”

4. Surface and bottom temperature data were combined, subset to a timeframe where all surface bottom temperature matched up by date and time.

5. The combined dataset was further filtered, removing any missing datapoints from either surface or bottom temperature data.

6. Final dataset saved as RelativeTempSurfaceBottom.csv:

7. This dataset was used for analysis.

Source Surface and Bottom Datasets:

1. Data from the same timeframe as “RelativeTempSurfaceBottom.csv” data were requested directly from CEMP at DWR.

2. Bottom and Surface Temperature were downloaded from the WQP individually by station and sensor location because their system does not allow them to combine multiple parameters for download.

3. All bottom temperature data and surface temperature data was combined into one file each, respectively.

4. All data was filtered out for the “Flags” used by CEMP, the only flags used in the final dataset were:

- “G” for Good

- “U” for unchecked

5. Data was given in 15- minute intervals, to convert to hourly data, the data were grouped and organized by station, date, hour. The first value for each grouping was kept, while the rest of the data for each station was removed. This resulted in one temperature value for each station-date-hour.

6. Final datasets saved as EDI_SourceBottomData.csv and EDI_SourceSurfaceData.csv.

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@environmentaldatainitiative.org

Web Address:

https://environmentaldatainitiative.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Michelle M Nelson

Organization:

California Department of Water Resources

Position:

Environmental Scientist

Address:

Sacramento, CA United States

Phone:

8058680895 (voice)

Email Address:

Michelle.Nelson@water.ca.gov

Id:

https://orcid.org/0000-0002-8505-2090

Individual:

Catarina Pien

Organization:

California Department of Water Resources

Position:

Environmental Scientist

Email Address:

Catarina.Pien@water.ca.gov

Id:

https://orcid.org/0000-0003-4427-6300

Contacts:

Individual:

Michelle M Nelson

Organization:

California Department of Water Resources

Position:

Environmental Scientist

Address:

Sacramento, CA United States

Phone:

8058680895 (voice)

Email Address:

Michelle.Nelson@water.ca.gov

Id:

https://orcid.org/0000-0002-8505-2090

Associated Parties:

Individual:

Rosemary Hartman

Organization:

DWR

Email Address:

Rosemary.Hartman@water.ca.gov

Id:

https://orcid.org/0000-0002-0642-183X

Role:

Associate

Individual:

Brittany Davis

Organization:

DWR

Email Address:

Brittany.Davis@water.ca.gov

Id:

https://orcid.org/0000-0003-3752-1830

Role:

Associate

Metadata Providers:

Individual:

Michelle M Nelson

Organization:

Department of Water Resources

Address:

Sacramento, CA 95817 United States

Phone:

8058680895 (voice)

Email Address:

Michelle.Nelson@water.ca.gov

Id:

https://orcid.org/0000-0002-8505-2090

Temporal, Geographic and Taxonomic Coverage

Temporal, Geographic and/or Taxonomic information that applies to all data in this dataset:

Time Period

Begin:

2012-07-16

End:

2019-12-27

Sampling Site:

Description:

SAN JOAQUIN RIVER AT ANTIOCH

Site Coordinates:

Longitude (degree):

-121.8029633

Latitude (degree):

38.0178299

Sampling Site:

Description:

SACRAMENTO RIVER AT MALLARD ISLAND

Site Coordinates:

Longitude (degree):

-121.9200897

Latitude (degree):

38.04280472

Sampling Site:

Description:

MARTINEZ

Site Coordinates:

Longitude (degree):

-122.1404877

Latitude (degree):

38.02763748

Sampling Site:

Description:

ROUGH AND READY ISLAND

Site Coordinates:

Longitude (degree):

-121.365

Latitude (degree):

37.963

Project

Parent Project Information:

Title:

Hourly Surface and Bottom Temperatures

Personnel:

Individual:

Michelle M Nelson

Organization:

Department of Water Resources

Position:

Environmental Scientist

Address:

Sacramento, CA 95817 United States

Phone:

8058680895 (voice)

Email Address:

Michelle.Nelson@water.ca.gov

Id:

https://orcid.org/0000-0002-8505-2090

Role:

Lead

Maintenance

Maintenance:

Description:	Data at all four of the water quality stations continues to be collected every 15 minutes, 365 days a year. this dataset is a subsets and was integrated for a specific analysis.
Frequency:	unknown

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n        '
        |___element 'metadata'
        |     |___text '\n            '
        |     |___element 'unitList'
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'year'
        |     |     |     |  \___attribute 'name' = 'year'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'month'
        |     |     |     |  \___attribute 'name' = 'month'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'day'
        |     |     |     |  \___attribute 'name' = 'day'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'julian day'
        |     |     |     |  \___attribute 'name' = 'julian day'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n                '
        |     |     |___text '\n                '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'Water year'
        |     |     |     |  \___attribute 'name' = 'Water year'
        |     |     |     |___text '\n                    '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n                '
        |     |     |___text '\n            '
        |     |___text '\n        '
        |___text '\n    '

Additional Metadata

additionalMetadata
        |___text '\n        '
        |___element 'metadata'
        |     |___text '\n            '
        |     |___element 'emlEditor'
        |     |        \___attribute 'app' = 'ezEML'
        |     |        \___attribute 'release' = '2021.12.15'
        |     |___text '\n        '
        |___text '\n    '

Copyright 2024 Environmental Data Initiative. This material is based upon work supported by the National Science Foundation under grants #2223103 and #2223104. Any opinions, findings, conclusions, or recommendations expressed in the material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation. Please contact us with questions, comments, or for technical assistance regarding this web site or the Environmental Data Initiative. Please read our privacy policy to know what information we collect about you and to understand your privacy rights.

EDI is a collaboration between the University of New Mexico and the University of Wisconsin – Madison, Center for Limnology:

Data Package Metadata View Summary

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

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Package Usage Rights

Keywords

Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Parent Project Information:

Maintenance

Additional Metadata

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

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

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

+/- Data Package Usage Rights

+/- Keywords

+/- Methods and Protocols

These methods, instrumentation and/or protocols apply to all data in this dataset:

+/- People and Organizations

+/- Temporal, Geographic and Taxonomic Coverage

+/- Project

Parent Project Information:

+/- Maintenance

+/- Additional Metadata

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance

Additional Metadata

Additional Metadata