Data Package Metadata View Summary

Interagency Ecological Program: Discrete dissolved oxygen monitoring in the Stockton Deep Water Ship Channel, collected by the Environmental Monitoring Program, 1997-2018

General Information

Data Package:
Local Identifier:	edi.7.7
Title:	Interagency Ecological Program: Discrete dissolved oxygen monitoring in the Stockton Deep Water Ship Channel, collected by the Environmental Monitoring Program, 1997-2018
Alternate Identifier:	DOI PLACE HOLDER
Abstract:	Dissolved oxygen levels in the Stockton Deep Water Ship Chanel (SDWSC) have been monitored since 1968 by the Interagency Ecological Program's (IEP) Environmental Monitoring Program (EMP). The SDWSC is located on the San Joaquin River near Stockton, California. Beginning in 1997, 14 stations were routinely monitored typically in summer and fall. Dissolved oxygen impairment can occur in the SDWSC; therefore, two water quality objectives were established. The objectives of the dissolved oxygen monitoring study in the SDWSC are to: (1) determine if dissolved oxygen levels comply with the water quality objectives, (2) monitor long term trends, and (3) detect and document changes along the SDWSC. The EMP collects discrete dissolved oxygen readings near the surface and bottom of the water column during ebb slack tide. The 14 stations are located between Prisoner's Point on the San Joaquin River and ends at the terminus of the channel called Turning Basin. The site locations were selected at the channel markers on the San Joaquin River; therefore, may be referred as station number or channel marker they are located at. Dissolved oxygen and water temperature were recorded 1-meter below surface and 1-meter above the bottom of the channel. Over the period of record the following water quality parameters have been added: water temperature, specific conductance, pH, fluorescence, turbidity, secchi disk and a rating score for the blue-green algae, Microcystis aeruginosa.
Publication Date:	2019-01-25

Time Period

Begin:

1997-08-04

End:

2018-11-08

People and Organizations
Contact:	Lesmeister, Sarah (California Department of Water Resources) [ email ]
Contact:	Rinde, Jenna (California Department of Water Resources) [ email ]
Creator:	Interagency Ecological Program (IEP)
Creator:	Lesmeister, Sarah (California Department of Water Resources)
Creator:	Rinde, Jenna (California Department of Water Resources)
Associate:	Lesmeister, Sarah (California Department of Water Resources, Supervisor)
Associate:	Rinde, Jenna (California Department of Water Resources, Lead)
Associate:	Gehrts, Karen (California Department of Water Resources, Supervisor)
Associate:	Philippart, Shaun (California Department of Water Resources, Supervisor)
Associate:	Waller, Scott (California Department of Water Resources, Supervisor)
Associate:	Noble Sakata, Brianne (California Department of Water Resources, Lead)
Associate:	Mike, Dempsey (California Department of Water Resources, Associate)
Associate:	Sakata, Nick (United States Bureau of Reclamation, Associate)

Data Entities
Data Table Name:	IEP_DOSDWSC_1997_2018.csv
Description:	Water quality data from the Stockton Deep Water Ship Channel
Data Table Name:	IEP_DOSDWSC_site_locations_latitude_and_longitude.csv
Description:	Geospatial data

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/7/7/e91e91c52a24d61002c8287ab30de3fc
Name:	IEP_DOSDWSC_1997_2018.csv
Description:	Water quality data from the Stockton Deep Water Ship Channel
Number of Records:	3108
Number of Columns:	19

Table Structure

Object Name:

IEP_DOSDWSC_1997_2018.csv

Size:

249846 byte

Authentication:

a047fcdf90688a0ac98db9ac45109649 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Column Name:

Date

Time

Station

StationID

WTSurface

WTBottom

DOSurface

DOBottom

Objective

SpCndSurface

SpCndBottom

pHSurface

pHBottom

Flourescence_Turner

Flourescence_YSI

Nephelometry_Turner

Turbidity_YSI

Secchi

Microcystis

Definition:

Date of sample

Time of sample in pacific standard time

Station number

Light channel marker number or reference area

Water temperature 1-meter below water surface

Water temperature 1-meter above bottom of channel

Dissolved oxygen concentration 1-meter below water surface

Dissolved oxygen concentration 1-meter above bottom of channel

Water quality objective for dissolved oxygen along San Joaquin River

Specific conductivity of water 1-below water surface

Specific conductivity 1-meter above bottom of channel

Total pH 1-meter below water surface

Total pH 1-meter above bottom of channel

Absorbed light in water, related to chlorophyll a concentrations

Turbidity of water

Secchi depth

Visual observation rating of Microcystis

Storage Type:

date

string

float

string

Measurement Type:

dateTime

nominal

ratio

nominal

Measurement Values Domain:

Format	MM/DD/YYYY
Precision

Format	hhmm
Precision

Definition

Station number

Definition

Light channel marker number or reference area

Unit	celsius
Type	real
Min	9.6
Max	29.7

Unit	celsius
Type	real
Min	9.6
Max	27.7

Unit	milligramsPerLiter
Type	real
Min	1.43
Max	18.5

Unit	milligramsPerLiter
Type	real
Min	0.2
Max	11.2

Unit	milligramsPerLiter
Type	real
Min	5
Max	6

Unit	microSeimenPerCentimeter
Type	real
Min	98
Max	1711

Unit	microSeimenPerCentimeter
Type	real
Min	98
Max	5194

Unit	dimensionless
Type	real
Min	6.85
Max	9.63

Unit	dimensionless
Type	real
Min	6.84
Max	8.75

Unit	microgramsPerLiter
Type	real
Min	0.71
Max	31.6

Unit	microgramsPerLiter
Type	real
Min	0.5
Max	37.7

Unit	nephelometricTurbidityUnit
Type	real
Min	0.2
Max	44.69

Unit	nephelometricTurbidityUnit
Type	real
Min	0.1
Max	42.6

Unit	centimeter
Type	real
Min	20
Max	378

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	NA
Definition	Missing value
Source

Code Definition

Code	present
Definition	Microcystis present
Source

Code Definition

Code	absent
Definition	Microcystis absent
Source

Code Definition

Code	3
Definition	Medium
Source

Code Definition

Code	4
Definition	High
Source

Code Definition

Code	2
Definition	Low
Source

Code Definition

Code	3.5
Definition	Medium-high
Source

Code Definition

Code	2.5
Definition	Low-medium
Source

Code Definition

Code	1
Definition	absent
Source

Code Definition

Code	4.5
Definition	High-very high
Source

Missing Value Code:

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Code	NA
Expl	Missing value

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/7/7/172a4b6e794eb14e8e5ccb97fef435a1
Name:	IEP_DOSDWSC_site_locations_latitude_and_longitude.csv
Description:	Geospatial data
Number of Records:	14
Number of Columns:	4

Table Structure

Object Name:

IEP_DOSDWSC_site_locations_latitude_and_longitude.csv

Size:

398 byte

Authentication:

70ea5fd50c41f6c1046cd921d2ec6c38 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:

Table Column Descriptions

Column Name:

Station

StationID

Latitude

Longitude

Definition:

Station number

Light channel marker number or reference area

Latitude

Storage Type:

string

float

Measurement Type:

nominal

ratio

Measurement Values Domain:

Definition

Station number

Definition

Light channel marker number or reference area

Unit	degree
Type	real
Min	37.95
Max	38.06

Unit	degree
Type	real
Min	-121.56
Max	-121.32

Missing Value Code:

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:
LTER Controlled Vocabulary	dissolved oxygen, water quality, transects, monitoring, rivers
(No thesaurus)	Interagency Ecological Program for the San Francisco Bay Delta Estuary, California Department of Water Resources

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:

(1.) Data collection methods:

Fourteen water quality stations are sampled by research vessel, near the surface and bottom of the water column during ebb slack tide along the San Joaquin River. The transect begins at Prisoner's Point in the central Delta and ends at the Stockton Turning Basin at the terminus of the channel. Sampling typically occurs during summer and fall when seasonal dissolved oxygen impairment may occur due to warmer temperatures, eutrophication, and less water mixing. Surface dissolved oxygen concentrations were reported from Winkler titrations until 2016. A multiparameter instrument is used to determine water quality data from near surface (one meter below surface) and bottom (one meter above bottom) of the water column. The multiparameter instrument is deployed alongside the research vessel by a winch crane with a 100-foot cable that is connected to a computer. Once the sonde is equilibrated to the local conditions, the water quality data is recorded onto data sheets, then the instrument is returned on board the vessel. A secchi disk is also used to determine light penetrations below water surface. When the blue-green cyanobacteria Microcystis aeruginosa was observed then it was documented.

(2.) Datasheet: available upon request (email data contact)

(3.) Instruments and equipment:

Dissolved Oxygen: Modified Winkler titrations with full-bottle technique was used in 1997, and 1999 to 2015. In 1998, dissolved oxygen levels were recorded from a Hydrolab Multiparameter Surveyor, Model DS-3. As of 2016, a 6150 ROX dissolved oxygen sensor was used on Yellow Springs (YSI) 6600 V2 multi-parameter water quality instrument.

Water temperature: A Hydrolab Multiparameter Surveyor, Model DS-3 was used during 1997 to 1998. From 1999 to 2011, a thermistor from Seabird Scientific was used to determine water temperature. Beginning in 2012 to 2017, a YSI 6560 probe recorded water temperature on YSI 6660 multiparameter water quality instrument.

Fluorescence: During August 2003 to September 2011, a Turner Designs Fluorometer 10-AU recorded fluorescence with a blue lamp and narrow filter kit with optical kit 10-096R. As of October 2011, a YSI 6025 probe on a YSI 6600 V2 instrument is used.

Nephelometer/Turbidity: From September 1999 - September 2011, a Turner Designs Nephelometer was used to determine nephelometry. As of October 2011, a YSI 6136 turbidity probe is used to determine turbidity.

Specific Conductance: August 2003 - September 2011, a Beckman RC-19 Conductivity Bridge was used. From October 2011 to 2017, a YSI 6560 conductivity probe on a YSI 6600 V2 instrument has been operated.

pH: From October 2011 to 2017, a YSI 6589 fast response pH sensor has been utilized.

Secchi disc: 20 cm in diameter plastic disc with alternate black and white quadrants August 2001 to present.

Microcystis aeruginosa: a visual observation ranging from (1) meaning absent, (2) low-widely scattered colonies, (3) Medium-adjacent colonies, (4) High-contiguous and (5) Very High- concentration of contiguous colonies forming mats/scum.

(4.) Analysis and methods (standard operating procedures): Data is in its original form and no calculations have been made. SOP's for methods and quality checks are available upon request.

(5.) Project history (change in methods and locations):

The sampling methods and locations have been consistent over the years. However, changes in instrumentation or research vessels (RV) used have been changed throughout sampling period. Sampling typically occurred on research vessels from the Department of Water Resources (DWR) or United States Bureau of Reclamation. From DWR, RV San Carlos (1997-2016) and RV Sentinel (2017) were commonly used. From USBR, RV Compliance (1997-2003) and RV Endeavor (2004-2017).

(6.) QA/QC: The data sheets are error checked twice at each sampling location and at the end of each sampling day by the field lead. Data for each year is then entered in a spreadsheet in Microsoft Excel and is plotted for each parameter. After completion of each year, the data is compiled into a single spreadsheet in Excel and is verified with the field sheets by a separate person. The instrumentation follows the manufacture's guidelines. The multiparameter instruments are calibrated prior to field runs, verified with another instrument during sampling, and are checked with calibration standards after use.

(7.) Contractor Information: All water quality sampling was conducted by staff from IEP's Environmental Monitoring Program (EMP) primarily from the California Department of Water Resources and the United States Bureau of Reclamation.

(8.) External review process: An IEP Project Work Team reviewed the EMP's sampling procedures during 2001-2002 and a summary report and recommendations was created in 2003.

(9.) Methods references:

[EPA] Method 120.1: Conductance (Specific Conductance, μmhos at 25 C) by Conductivity Meter

[EPA] Method 150.1: pH (Electrometric) by pH Meter

[EPA] Method 180.1: Determination of Turbidity by Nephelometry

[EPA] Method 360.2: Dissolved Oxygen by Modified Winkler Titration or Probe

People and Organizations

Creators:

Individual:

Interagency Ecological Program (IEP)

Individual:

Sarah Lesmeister

Organization:

California Department of Water Resources

Email Address:

sarah.lesmeister@water.ca.gov

Id:

https://orcid.org/0000-0001-5492-1188

Individual:

Jenna Rinde

Organization:

California Department of Water Resources

Email Address:

jenna.rinde@water.ca.gov

Id:

https://orcid.org/0000-0001-6677-4701

Contacts:

Individual:

Sarah Lesmeister

Organization:

California Department of Water Resources

Email Address:

sarah.lesmeister@water.ca.gov

Id:

https://orcid.org/0000-0001-5492-1188

Individual:

Jenna Rinde

Organization:

California Department of Water Resources

Email Address:

jenna.rinde@water.ca.gov

Id:

https://orcid.org/0000-0001-6677-4701

Associated Parties:

Individual:

Sarah Lesmeister

Organization:

California Department of Water Resources

Email Address:

sarah.lesmeister@water.ca.gov

Id:

https://orcid.org/0000-0001-5492-1188

Role:

Supervisor

Individual:

Jenna Rinde

Organization:

California Department of Water Resources

Email Address:

jenna.rinde@water.ca.gov

Id:

https://orcid.org/0000-0001-6677-4701

Role:

Lead

Individual:	Karen Gehrts
Organization:	California Department of Water Resources
Role:	Supervisor

Individual:	Shaun Philippart
Organization:	California Department of Water Resources
Role:	Supervisor

Individual:	Scott Waller
Organization:	California Department of Water Resources
Role:	Supervisor

Individual:	Brianne Noble Sakata
Organization:	California Department of Water Resources
Role:	Lead

Individual:	Dempsey Mike
Organization:	California Department of Water Resources
Role:	Associate

Individual:	Nick Sakata
Organization:	United States Bureau of Reclamation
Role:	Associate

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

1997-08-04

End:

2018-11-08

Sampling Site:

Description:

Station 1

Site Coordinates:

Longitude (degree):

-121.556

Latitude (degree):

38.0597

Sampling Site:

Description:

Station 2

Site Coordinates:

Longitude (degree):

-121.5295

Latitude (degree):

38.0555

Sampling Site:

Description:

Station 3

Site Coordinates:

Longitude (degree):

-121.5152

Latitude (degree):

38.0538

Sampling Site:

Description:

Station 4

Site Coordinates:

Longitude (degree):

-121.4988

Latitude (degree):

38.0427

Sampling Site:

Description:

Station 5

Site Coordinates:

Longitude (degree):

-121.4837

Latitude (degree):

38.034

Sampling Site:

Description:

Station 6

Site Coordinates:

Longitude (degree):

-121.4657

Latitude (degree):

38.0218

Sampling Site:

Description:

Station 7

Site Coordinates:

Longitude (degree):

-121.4567

Latitude (degree):

38.0107

Sampling Site:

Description:

Station 8

Site Coordinates:

Longitude (degree):

-121.4325

Latitude (degree):

37.9938

Sampling Site:

Description:

Station 9

Site Coordinates:

Longitude (degree):

-121.4137

Latitude (degree):

37.994

Sampling Site:

Description:

Station 10

Site Coordinates:

Longitude (degree):

-121.3825

Latitude (degree):

37.9782

Sampling Site:

Description:

Station 11

Site Coordinates:

Longitude (degree):

-121.3715

Latitude (degree):

37.9687

Sampling Site:

Description:

Station 12

Site Coordinates:

Longitude (degree):

-121.3593

Latitude (degree):

37.9587

Sampling Site:

Description:

Station 13

Site Coordinates:

Longitude (degree):

-121.3378

Latitude (degree):

37.9522

Sampling Site:

Description:

Station 14

Site Coordinates:

Longitude (degree):

-121.3173

Latitude (degree):

37.9523

Taxonomic Range:

Classification:

Rank Name:

kingdom

Rank Value:

Bacteria

Classification:

Rank Name:

subkingdom

Rank Value:

Negibacteria

Classification:

Rank Name:

phylum

Rank Value:

Cyanobacteria

Classification:

Rank Name:

class

Rank Value:

Cyanophyceae

Classification:

Rank Name:

order

Rank Value:

Chroococcales

Classification:

Rank Name:

family

Rank Value:

Chroococcaceae

Classification:

Rank Name:

genus

Rank Value:

Microcystis

Classification:

Rank Name:	species
Rank Value:	Microcystis aeruginosa

Project

Parent Project Information:

Title:

No project title to report

Personnel:

Individual:	Interagency Ecological Program
Role:	Principal Investigator

Funding:

No funding to report

Maintenance

Maintenance:

Description:	Ongoing
Frequency:

Additional Info


Additional Information:
	NOTE: Station 10 (stationid lt40) is the same as station p8 from IEP's Environmental Monitoring Program. Fluorescence data is available by request from September 1999 to April 2004 that was from a Turner Designs fluorometer model 10AU with a white lamp and wide filter with an optical kit 10-037R. This period of fluorescence data is still undergoing data evaluation.

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microSeimenPerCentimeter'
        |     |     |     |  \___attribute 'multiplierToSI' = '0.00001'
        |     |     |     |  \___attribute 'name' = 'microSeimenPerCentimeter'
        |     |     |     |  \___attribute 'parentSI' = 'seimenPerMeter'
        |     |     |     |  \___attribute 'unitType' = 'conductance'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'conductivity unit'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'nephelometricTurbidityUnit'
        |     |     |     |  \___attribute 'multiplierToSI' = 'dimensionless'
        |     |     |     |  \___attribute 'name' = 'nephelometricTurbidityUnit'
        |     |     |     |  \___attribute 'parentSI' = 'dimensionless'
        |     |     |     |  \___attribute 'unitType' = 'dimensionless'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'NTU- ratio of the amount of light transmitted through a water sample with the amount scattered at an angle of 90 degrees to one side'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___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

Interagency Ecological Program: Discrete dissolved oxygen monitoring in the Stockton Deep Water Ship Channel, collected by the Environmental Monitoring Program, 1997-2018

Data Entities

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 Info

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Interagency Ecological Program: Discrete dissolved oxygen monitoring in the Stockton Deep Water Ship Channel, collected by the Environmental Monitoring Program, 1997-2018

+/- Data Entities

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 Info

+/- Additional Metadata

Data Entities

Data Package Usage Rights

Keywords

Methods and Protocols

People and Organizations

Temporal, Geographic and Taxonomic Coverage

Project

Maintenance

Additional Info

Additional Metadata