Data Package Metadata View Summary

Sacramento-San Joaquin Bay-Delta Continuous (15 Minute) water quality monitoring data collected by the Continuous Environmental Monitoring Program, DWR, 2005- ongoing.

General Information

Data Package:

Local Identifier:

edi.1177.6

Title:

Sacramento-San Joaquin Bay-Delta Continuous (15 Minute) water quality monitoring data collected by the Continuous Environmental Monitoring Program, DWR, 2005- ongoing.

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

The Continuous Environmental Monitoring Program (CEMP) plays an instrumental role in overseeing real-time water quality in the Sacramento-San Joaquin Delta (the Delta) and Suisun Bay. The program harnesses wireless telemetry to transmit crucial data to the California Data Exchange Center (CDEC), making high-resolution environmental data pertaining to the Delta and Suisun Bay publicly accessible. The extensive dataset captures information at 15-minute intervals from 15 monitoring stations, utilizing YSI 6600 and YSI EXO sondes to obtain standalone water quality measurements.

This extensive dataset informs the operations of the California State Water Project, ensuring it adheres to mandated water quality standards set by Water Right Decision 1641. This data compilation incorporates all information since the transition to YSI multiparameter sondes in 2005. It is important to note that the commencement dates and subsequent upgrades vary between stations, leading to slight discrepancies in the dataset's date ranges.

Since its inception in the mid-1980s, CEMP has progressively expanded its monitoring capabilities, consistently augmenting the number of monitoring locations and the array of water quality parameters assessed. Its commitment to utilizing the most advanced water quality monitoring technology reaffirms its position as an environmental monitoring leader in the Delta and Suisun Bay. Today, the program oversees 15 water quality stations that reliably capture data every 15 minutes, each day of the year, transmitting this data in real-time.

The core tenents of CEMP:

• to obtain consistent and accurate data in real-time at established monitoring stations

• to provide data necessary to achieve compliance with salinity, flow, and dissolved oxygen standards

• to perform data analyses for further understanding of estuarine ecology

• to report information to other government agencies, as well as the public, for the purpose of management

and conservation of the upper San Francisco Estuary (SFE).

• to provide continuous water quality monitoring expertise for other groups within DWR and sister agencies

for the benefit of ecological studies throughout the San Francisco- Sacramento Estuary

Publication Date:

2024-05-21

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

2005-07-27

End:

2023-12-31

People and Organizations
Contact:	Nelson, Michelle M (Department of Water Resources, Environmental Scientist) [ email ]
Contact:	Tran, Andrew H (Department of Water Resources, Environmental Scientist) [ email ]
Creator:	Nelson, Michelle M (Department of Water Resources, Environmental Scientist)
Creator:	Tran, Andrew H (Department of Water Resources, Environmental Scientist)
Associate:	Waller, Scott (DWR, Senior Environmental Scientist- Supervisor, Environmental Scientist Specialist Supervisor)
Associate:	Aldrich, Jay (DWR, Control Systems Technician II, Station Manager, Field Crew)

Data Entities
Data Table Name:	Stations Metadata
Description:	Station names, locations, and habitat type
Data Table Name:	Dataset dates
Description:	the date ranges for the overall dataset
Data Table Name:	Instrument Type Date Ranges
Description:	This table shows the date and times of instrument types used for data collection. YSI 6600 sondes and YSI EXO2 sondes.
Data Table Name:	Instrument Specifications
Description:	a written descriptions of the instrument's performance in quantifiable terms as described by the manufacturer
Data Table Name:	ANH
Description:	Antioch Water Quality Station
Data Table Name:	FRK
Description:	Franks Tract Water Quality Station
Data Table Name:	GZL
Description:	Grizzly Bay Water Quality Station
Data Table Name:	HON
Description:	Honker Bay Water Quality Station
Data Table Name:	MAL
Description:	Mallard Island Water Quality Station
Data Table Name:	MRZ
Description:	Martinez Water Quality Station
Data Table Name:	MSD
Description:	Mossdale Water Quality Station
Data Table Name:	PPT
Description:	Prisoner's Point Water Quality Station
Data Table Name:	RRI
Description:	Rough and Ready Island Water Quality Station
Data Table Name:	RVB
Description:	Rio Vista Bridge Water Quality Station
Data Table Name:	RYC
Description:	Ryer Cut Water Quality Station
Data Table Name:	SJR
Description:	Vernalis Water Quality Station
Data Table Name:	SRH
Description:	Sacramento River at Hood Water Quality Station
Data Table Name:	SSI
Description:	Sherman Island Water Quality Station
Data Table Name:	TWI
Description:	Twitchell Island Water Quality Station

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/a059f5eea4f8500fe1a43566451ec593
Name:	Stations Metadata
Description:	Station names, locations, and habitat type
Number of Records:	15
Number of Columns:	9

Table Structure

Object Name:

StationsMetadata.csv

Size:

2024 byte

Authentication:

7c642f8bc739543ce0c6776e79a945a8 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 Acronym

StationName

Latitude

Longitude

HydrologicArea

Basin

County

HabitatType

Station Access Type

Column Name:

Station Acronym

StationName

Latitude

Longitude

HydrologicArea

Basin

County

HabitatType

Station Access Type

Definition:

an abbreviation formed from the full water quality station names

full name of the water quality station

the station's angular distance of a place north or south of the earth's equator.

the station's angular distance of a place east or west of the meridian at Greenwich, England

Hydrologic Basin, specified by CDEC

Water basin as defined by CDEC

County in which station is located

Standardized and assigned by water quality team

How the station is accessed and its location type.

Storage Type:

string

float

string

Measurement Type:

nominal

ratio

nominal

Measurement Values Domain:

Definition

text

Definition

text

Unit	degree
Type	real

Unit	degree
Type	real

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Sacramento River
Definition	Sacramento River
Source

Code Definition

Code	San Francisco Bay
Definition	San Francisco Bay
Source

Code Definition

Code	San Joaquin River
Definition	San Joaquin River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Delta
Definition	within the legal limits of the Sacramento- San Joaquin Delta
Source

Code Definition

Code	East Bay
Definition	Eastern bay on the Western side of the Sacramento- San Joaquin Delta legal boundary
Source

Code Definition

Code	Sacramento R
Definition	Sacramento River
Source

Code Definition

Code	San Joaquin R
Definition	San Joaquin River
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Contra Costa
Definition	Contra Costa County
Source

Code Definition

Code	Sacramento
Definition	Sacramento County
Source

Code Definition

Code	San Joaquin
Definition	San Joaquin County
Source

Code Definition

Code	Solano
Definition	Solano County
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Tidal Embayment (brackish)
Definition	A recess in a waterway or coastline forming a bay with brackish water.
Source

Code Definition

Code	Tidal Flooded Island (freshwater)
Definition	A man-made flooded island that contains freshwater.
Source

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

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Land
Definition	Land sites are accessed by vehicle and are located on the banks of river channels.
Source

Code Definition

Code	Pile
Definition	Pile sites are accessed by boats and are in the middle of river channels.
Source

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/0b8b7a57b404d18778c30b5615d84e49
Name:	Dataset dates
Description:	the date ranges for the overall dataset
Number of Records:	15
Number of Columns:	4

Table Structure

Object Name:

Datasetdates.csv

Size:

871 byte

Authentication:

8a5ff3b8d436dba5aa4c3f7c77ccc8a6 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 Acronym

StationName

Dataset Begin Date

Dataset End Date

Column Name:

Station Acronym

Station Name

Dataset Begin Date

Dataset End Date

Definition:

an abbreviation formed from the full water quality station names

full name of the water quality station

the start date for the data provided in this publication

the end date for the data provided in this publication

Storage Type:

string

dateTime

Measurement Type:

nominal

dateTime

Measurement Values Domain:

Definition

text

Definition

text

Format	YYYY-MM-DD
Precision

Format	YYYY-MM-DD
Precision

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/e17dad699f88336b8292998747907088
Name:	Instrument Type Date Ranges
Description:	This table shows the date and times of instrument types used for data collection. YSI 6600 sondes and YSI EXO2 sondes.
Number of Records:	15
Number of Columns:	6

Table Structure

Object Name:

EXO upgrade dates_final.csv

Size:

854 byte

Authentication:

b6bb74bbfc2b06a72b9be5315fa19e57 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Site

Start date of YSI 6600

YSI 6600 start time

Start date of YSI EXO2 date

YSI EXO2 start time

Notes

Column Name:

Site

Start date of YSI 6600

YSI 6600 start time

Start date of YSI EXO2 date

YSI EXO2 start time

Notes

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

the start date of YSI 6600 measurements.

time of first YSI 6600 measurement

start date of YSI EXO2 measurements.

start time of YSI EXO2 measurements.

any relevant notes on data collection

Storage Type:

string

dateTime

string

Measurement Type:

nominal

dateTime

nominal

Measurement Values Domain:

Definition

text

Format	YYYY-MM-DD
Precision

Format	hh:mm
Precision

Format	YYYY-MM-DD
Precision

Format	hh:mm
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	nan
Definition	not a number
Source

Code Definition

Code	Primary was upgraded to EXO2 on 12/12/2013, while backup remained 6600 from which data was used occasionally. Backup was upgraded to EXO2 on 10/7/2015.
Definition	specific note on station
Source

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/fdd78a720d73647b800de97732cc8d09
Name:	Instrument Specifications
Description:	a written descriptions of the instrument's performance in quantifiable terms as described by the manufacturer
Number of Records:	8
Number of Columns:	5

Table Structure

Object Name:

Sonde Ranges Final.csv

Size:

1051 byte

Authentication:

dddbe3baf38a4f245b3704e762530c88 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Sensor

EXO Accuracy

EXO Range

6-Series Accuracy

6-Series Range

Column Name:

Constituent

EXO Accuracy

EXO Range

6-Series Accuracy

6-Series Range

Definition:

water quality sensor type

Accuracy of sensor

sensor range

sensor accuracy

sensor range

Storage Type:

string

Measurement Type:

nominal

Measurement Values Domain:

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/e7c35c12cd774b2146e596f2303872f7
Name:	ANH
Description:	Antioch Water Quality Station
Number of Records:	561024
Number of Columns:	9

Table Structure

Object Name:

ANH_all.csv

Size:

30812197 byte

Authentication:

0556e45d415a4fcee6b24b3bc8d34960 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	ANH
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/58d307abf57963292b59d8046cb77f65
Name:	FRK
Description:	Franks Tract Water Quality Station
Number of Records:	300625
Number of Columns:	9

Table Structure

Object Name:

FRK_all.csv

Size:

16174547 byte

Authentication:

81956cd3a21ad694ec7981c64bccf96d 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	FRK
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/bb661e9298f4c3c1aa3a875338c7c6a1
Name:	GZL
Description:	Grizzly Bay Water Quality Station
Number of Records:	295432
Number of Columns:	9

Table Structure

Object Name:

GZL_all.csv

Size:

16457899 byte

Authentication:

a9051886d79a2053fbd72c9f765dfd75 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	GZL
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/b586a6a4876a934eca5d322e18a9cb87
Name:	HON
Description:	Honker Bay Water Quality Station
Number of Records:	295544
Number of Columns:	9

Table Structure

Object Name:

HON_all.csv

Size:

16312636 byte

Authentication:

9ba00c051b3f44951479909e9a38c19c 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	HON
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/aac477583e3dabc030891d2562352dac
Name:	MAL
Description:	Mallard Island Water Quality Station
Number of Records:	550806
Number of Columns:	9

Table Structure

Object Name:

MAL_all.csv

Size:

30698364 byte

Authentication:

345012028e7c32690e7c49a9d1dfaadf 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	MAL
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/466014277f2a7719af2a0228b0d10776
Name:	MRZ
Description:	Martinez Water Quality Station
Number of Records:	563753
Number of Columns:	9

Table Structure

Object Name:

MRZ_all.csv

Size:

31563230 byte

Authentication:

21ecda4292a06d7faf9de64911887091 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	MRZ
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/62171ff3b6fe5eda941078665bf2a277
Name:	MSD
Description:	Mossdale Water Quality Station
Number of Records:	561559
Number of Columns:	9

Table Structure

Object Name:

MSD_all.csv

Size:

30623876 byte

Authentication:

8d691caf062638078d60da953a92972b 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	MSD
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/5be8fca867cdc28890b877c74efb06fc
Name:	PPT
Description:	Prisoner's Point Water Quality Station
Number of Records:	539473
Number of Columns:	9

Table Structure

Object Name:

PPT_all.csv

Size:

28768561 byte

Authentication:

5e6a112675b5ff9e0f0269f35139d383 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	PPT
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/c3c1d1ce1ed08cca1a1301cef1ef91d9
Name:	RRI
Description:	Rough and Ready Island Water Quality Station
Number of Records:	566441
Number of Columns:	9

Table Structure

Object Name:

RRI_all.csv

Size:

30404772 byte

Authentication:

d63af171295696a2de46f4df0b329eb6 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	RRI
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/9b6fbe82c12410604ec310048223ccbb
Name:	RVB
Description:	Rio Vista Bridge Water Quality Station
Number of Records:	554927
Number of Columns:	9

Table Structure

Object Name:

RVB_all.csv

Size:

29870307 byte

Authentication:

7029f913c30acfddb57228b06ce0bd98 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	RVB
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/97a2f884280cd5667c8e8f30b33d5bd8
Name:	RYC
Description:	Ryer Cut Water Quality Station
Number of Records:	295538
Number of Columns:	9

Table Structure

Object Name:

RYC_all.csv

Size:

16399547 byte

Authentication:

a1467c08f2743ad219bd1b71986b3484 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	RYC
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/7747d1f7b4cd7d4ffc47417bbb73aa0e
Name:	SJR
Description:	Vernalis Water Quality Station
Number of Records:	646224
Number of Columns:	9

Table Structure

Object Name:

SJR_all.csv

Size:

35198517 byte

Authentication:

9e417ee2b36163b4c9a6524df58a8ce4 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	SJR
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/958c5c9af8d95a5b37910994853673b1
Name:	SRH
Description:	Sacramento River at Hood Water Quality Station
Number of Records:	557998
Number of Columns:	9

Table Structure

Object Name:

SRH_all.csv

Size:

30332860 byte

Authentication:

17c2d273907ee667e0350b79845f8605 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	SRH
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/24d51605899fc94c021ddc25d19a2982
Name:	SSI
Description:	Sherman Island Water Quality Station
Number of Records:	295432
Number of Columns:	9

Table Structure

Object Name:

SSI_all.csv

Size:

15899499 byte

Authentication:

bea19b7238634b3b50a27fbfcef12b78 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	SSI
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/1177/6/fe3f59b29b6cf2a79f6130e80a09da26
Name:	TWI
Description:	Twitchell Island Water Quality Station
Number of Records:	300614
Number of Columns:	9

Table Structure

Object Name:

TWI_all.csv

Size:

16127663 byte

Authentication:

4a6edffaf8caa2ec599616be662e031e 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

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Column Name:

station

date

time

dissolvedoxygen

fluorescence

spc

turbidity

watertemperature

Definition:

Acronym of the water quality station name. See Station metadata for station name and location.

date of water quality measurement

time of measurement in PST

Dissolved Oxygen Measurement in milligrams per liter

fluorescence measurement

pH measurements in pH units are a measurement which describes the degree of acidity or alkalinity

specific conductivity measurement of river water in micrograms per liter

turbidity measurement of water

temperature of the water in degrees celsius

Storage Type:

string

dateTime

float

Measurement Type:

nominal

dateTime

ratio

Measurement Values Domain:

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	TWI
Definition	Station Abbreviation
Source

Format	YYYY-MM-DD
Precision

Format	hh:mm:ss
Precision

Unit	milligramPerLiter
Precision	.01
Type	real

Unit	microgramPerLiter
Precision	.01
Type	real

Unit	pH
Precision	.01
Type	real

Unit	microsiemens per centimeter
Type	real

Unit	FNU
Precision	.01
Type	real

Unit	celsius
Precision	.01
Type	real

Missing Value Code:

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

Code	NA
Expl	missing values could have occurred for many reasons

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)	CDEC- California Data Exchange Center, DWR- California Department of Water Resources, Sacramento-San Joaquin Delta, San Francisco Estuary, real-time monitoring, Suisun Bay, CEMP- Continuous Environmental Monitoring Program
LTER Controlled Vocabulary	water, water quality, water temperature, dissolved oxygen, chlorophyll, fluorescence, specific conductivity, turbidity, estuaries, long term monitoring

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:

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.

Description:

For this dataset water quality parameters were collected using YSI EXO2 multiparameter water quality sondes from Xylem (https://www.ysi.com/exo2) or YSI 6600 Series multiparameter water quality sondes (https://www.ysi.com/file%20library/documents/manuals/069300-ysi-6-series-manual-revj.pdf). Water quality parameters included in this dataset are: water temperature, specific conductivity, dissolved oxygen, fluorescence (chlorophyll), pH, and turbidity. The CEMP is the data manager and performs a daily preliminary visual inspection of the data as well as a monthly visual inspection for anomalous data or other non-representative outliers. CEMP adheres to strict calibration standard operating procedures which are performed before a sonde is deploy, CEMP does a field drift calculation, and performs a final post-deployment accuracy verification test in laboratory settings. The field drift calculation and post-deployment accuracy test are combined to calculate total drift error (environmental drift + calibration drift = total drift error). Data that is determined to be non-representative is either removed or flagged as not available. This dataset is filtered for data which have passed CEMP’s data validation procedures. Data that did not pass validation or data not collected due to equipment malfunction are reported as “NA” in this dataset. Data was downloaded from CEMP’s internal database and processed and complied in R version 4.1.0. Please use the contact for this dataset for any further QA/QC inquiries.

Instrument(s):

YSI EXO2 and 6600 series multiparameter water quality sondes from Xylem

Description:

Reporting Turbidity in FNU

Historically, CEMP collected and reported turbidity in Nephelometric Turbidity Units (NTU). However, in 2021, CEMP began collecting and reporting turbidity in Formazin Nephelometric Units (FNU) to better reflect the methodology used by its turbidity sensors. NTU measurements are based on EPA method 180.1 while FNU is based on ISO 7027. Both NTU and FNU measure scattered light at 90 degrees from the incident light beam, but NTU is measured with a white light, whereas the FNU is measured with an infrared light source. The turbidity sensors manufactured by YSI that CEMP has used since 2008 follow the ISO 7027 method and thus reporting in FNU is more appropriate. According to the sensor manufacturer, NTU and FNU are comparable and no conversion of data values are required. (https://www.ysi.com/file%20library/documents/technical%20notes/t627_turbidity_units_and_calibration_solutions.pdf) Therefore, to better reflect the methodology of turbidity collection, and to be consistent with future CEMP datasets, CEMP has decided to report all turbidity measurements collected with YSI sensors in FNU.

Description:

Additional QAQC checks on the calendar year 2023 data were conducted and will continue on from 2023 to all current data.

The three additional data checks include:

- Spike testing. Set criteria to flag any point that is double the preceding and following data points (excluding turbidity).

- Water temperature and dissolved oxygen correlation. Dissolved oxygen readings depend on water temperature, if any water temperature was flagged NA, then dissolved oxygen was flagged NA as well.

- Repeated data string check. Automatically flag NA for any data that matches the exact same string as the previous measurement.

People and Organizations

Publishers:

Organization:

Environmental Data Initiative

Email Address:

info@edirepository.org

Web Address:

https://edirepository.org

Id:

https://ror.org/0330j0z60

Creators:

Individual:

Michelle M Nelson

Organization:

Department of Water Resources

Position:

Environmental Scientist

Email Address:

Michelle.Nelson@water.ca.gov

Id:

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

Individual:

Andrew H Tran

Organization:

Department of Water Resources

Position:

Environmental Scientist

Email Address:

Andrew.Tran@water.ca.gov

Id:

https://orcid.org/0000-0002-6763-5655

Contacts:

Individual:

Michelle M Nelson

Organization:

Department of Water Resources

Position:

Environmental Scientist

Email Address:

Michelle.Nelson@water.ca.gov

Id:

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

Individual:

Andrew H Tran

Organization:

Department of Water Resources

Position:

Environmental Scientist

Email Address:

Andrew.Tran@water.ca.gov

Id:

https://orcid.org/0000-0002-6763-5655

Associated Parties:

Individual:

Scott Waller

Organization:

DWR

Position:

Senior Environmental Scientist- Supervisor

Email Address:

scott.waller@water.ca.gov

Role:

Environmental Scientist Specialist Supervisor

Individual:

Jay Aldrich

Organization:

DWR

Position:

Control Systems Technician II

Email Address:

Jay.Aldrich@water.ca.gov

Role:

Station Manager, Field Crew

Metadata Providers:

Individual:

Michelle M Nelson

Organization:

Department of Water Resources

Position:

Environmental Scientist

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:

2005-07-27

End:

2023-12-31

Sampling Site:

Description:

ANH

Site Coordinates:

Longitude (degree):

-121.802939

Latitude (degree):

38.017854

Sampling Site:

Description:

FRK

Site Coordinates:

Longitude (degree):

-121.5981

Latitude (degree):

38.046417

Sampling Site:

Description:

GZL

Site Coordinates:

Longitude (degree):

-122.037962

Latitude (degree):

38.124281

Sampling Site:

Description:

HON

Site Coordinates:

Longitude (degree):

-121.937133

Latitude (degree):

38.072217

Sampling Site:

Description:

MAL

Site Coordinates:

Longitude (degree):

-121.92013

Latitude (degree):

38.042799

Sampling Site:

Description:

MRZ

Site Coordinates:

Longitude (degree):

-122.140542

Latitude (degree):

38.027651

Sampling Site:

Description:

MSD

Site Coordinates:

Longitude (degree):

-121.306474

Latitude (degree):

37.786144

Sampling Site:

Description:

PPT

Site Coordinates:

Longitude (degree):

-121.549973

Latitude (degree):

38.056296

Sampling Site:

Description:

RRI

Site Coordinates:

Longitude (degree):

-121.365603

Latitude (degree):

37.962726

Sampling Site:

Description:

RVB

Site Coordinates:

Longitude (degree):

-121.68635

Latitude (degree):

38.159667

Sampling Site:

Description:

RYC

Site Coordinates:

Longitude (degree):

-121.995639

Latitude (degree):

38.083967

Sampling Site:

Description:

SJR

Site Coordinates:

Longitude (degree):

-121.265

Latitude (degree):

37.679346

Sampling Site:

Description:

SRH

Site Coordinates:

Longitude (degree):

-121.520473

Latitude (degree):

38.367691

Sampling Site:

Description:

SSI

Site Coordinates:

Longitude (degree):

-121.761736

Latitude (degree):

38.074097

Sampling Site:

Description:

TWI

Site Coordinates:

Longitude (degree):

-121.668718

Latitude (degree):

38.097455

Sampling Site:

Description:

ANH

Site Coordinates:

Longitude (degree):

-121.802939

Latitude (degree):

38.017854

Sampling Site:

Description:

FRK

Site Coordinates:

Longitude (degree):

-121.5981

Latitude (degree):

38.046417

Sampling Site:

Description:

GZL

Site Coordinates:

Longitude (degree):

-122.037962

Latitude (degree):

38.124281

Sampling Site:

Description:

HON

Site Coordinates:

Longitude (degree):

-121.937133

Latitude (degree):

38.072217

Sampling Site:

Description:

MAL

Site Coordinates:

Longitude (degree):

-121.92013

Latitude (degree):

38.042799

Sampling Site:

Description:

MRZ

Site Coordinates:

Longitude (degree):

-122.140542

Latitude (degree):

38.027651

Sampling Site:

Description:

MSD

Site Coordinates:

Longitude (degree):

-121.306474

Latitude (degree):

37.786144

Sampling Site:

Description:

PPT

Site Coordinates:

Longitude (degree):

-121.549973

Latitude (degree):

38.056296

Sampling Site:

Description:

RRI

Site Coordinates:

Longitude (degree):

-121.365603

Latitude (degree):

37.962726

Sampling Site:

Description:

RVB

Site Coordinates:

Longitude (degree):

-121.68635

Latitude (degree):

38.159667

Sampling Site:

Description:

RYC

Site Coordinates:

Longitude (degree):

-121.995639

Latitude (degree):

38.083967

Sampling Site:

Description:

SJR

Site Coordinates:

Longitude (degree):

-121.265

Latitude (degree):

37.679346

Sampling Site:

Description:

SRH

Site Coordinates:

Longitude (degree):

-121.520473

Latitude (degree):

38.367691

Sampling Site:

Description:

SSI

Site Coordinates:

Longitude (degree):

-121.761736

Latitude (degree):

38.074097

Sampling Site:

Description:

TWI

Site Coordinates:

Longitude (degree):

-121.668718

Latitude (degree):

38.097455

Sampling Site:

Description:

ANH

Site Coordinates:

Longitude (degree):

-121.802939

Latitude (degree):

38.017854

Sampling Site:

Description:

FRK

Site Coordinates:

Longitude (degree):

-121.5981

Latitude (degree):

38.046417

Sampling Site:

Description:

GZL

Site Coordinates:

Longitude (degree):

-122.037962

Latitude (degree):

38.124281

Sampling Site:

Description:

HON

Site Coordinates:

Longitude (degree):

-121.937133

Latitude (degree):

38.072217

Sampling Site:

Description:

MAL

Site Coordinates:

Longitude (degree):

-121.92013

Latitude (degree):

38.042799

Sampling Site:

Description:

MRZ

Site Coordinates:

Longitude (degree):

-122.140542

Latitude (degree):

38.027651

Sampling Site:

Description:

MSD

Site Coordinates:

Longitude (degree):

-121.306474

Latitude (degree):

37.786144

Sampling Site:

Description:

PPT

Site Coordinates:

Longitude (degree):

-121.549973

Latitude (degree):

38.056296

Sampling Site:

Description:

RRI

Site Coordinates:

Longitude (degree):

-121.365603

Latitude (degree):

37.962726

Sampling Site:

Description:

RVB

Site Coordinates:

Longitude (degree):

-121.68635

Latitude (degree):

38.159667

Sampling Site:

Description:

RYC

Site Coordinates:

Longitude (degree):

-121.995639

Latitude (degree):

38.083967

Sampling Site:

Description:

SJR

Site Coordinates:

Longitude (degree):

-121.265

Latitude (degree):

37.679346

Sampling Site:

Description:

SRH

Site Coordinates:

Longitude (degree):

-121.520473

Latitude (degree):

38.367691

Sampling Site:

Description:

SSI

Site Coordinates:

Longitude (degree):

-121.761736

Latitude (degree):

38.074097

Sampling Site:

Description:

TWI

Site Coordinates:

Longitude (degree):

-121.668718

Latitude (degree):

38.097455

Project

Parent Project Information:

Title:

Continuous Environmental Monitoring Program at the Division of Integrated Science and Engineering in the California Department of Water Resources

Personnel:

Individual:

Michelle M Nelson

Organization:

Department of Water Resources

Address:

3962 1st Avenue,

Sacramento, CA 95817 United States

Phone:

8058680895 (voice)

Email Address:

Michelle.Nelson@water.ca.gov

Id:

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

Role:

Author

Maintenance

Maintenance:

Description:	Data collection is ongoing and this publication will be updated at the end of each calendar year, to add the previous year's QAQC'd data.
Frequency:	annually

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'unitList'
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'pH'
        |     |     |     |  \___attribute 'name' = 'pH'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'pH is reported in "logarithmic units". Each number represents a 10-fold change in the acidity/ basicness of the water.'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'FNU'
        |     |     |     |  \___attribute 'name' = 'FNU'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Formazin Nephelometric Unit'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microsiemens per centimeter'
        |     |     |     |  \___attribute 'name' = 'microsiemens per centimeter'
        |     |     |     |___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' = '2024.05.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

Sacramento-San Joaquin Bay-Delta Continuous (15 Minute) water quality monitoring data collected by the Continuous Environmental Monitoring Program, DWR, 2005- ongoing.

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

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

Sacramento-San Joaquin Bay-Delta Continuous (15 Minute) water quality monitoring data collected by the Continuous Environmental Monitoring Program, DWR, 2005- ongoing.

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

Data Table

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