Data Package Metadata View Summary

Interagency Ecological Program: Drift invertebrate and ichthyoplankton catch and water quality from the Sacramento River channel, and Sacramento River floodplain and tidal slough, collected by the Yolo Bypass Fish Monitoring Program, 1998-2022

General Information

Data Package:

Local Identifier:

edi.818.5

Title:

Interagency Ecological Program: Drift invertebrate and ichthyoplankton catch and water quality from the Sacramento River channel, and Sacramento River floodplain and tidal slough, collected by the Yolo Bypass Fish Monitoring Program, 1998-2022

Alternate Identifier:

DOI PLACE HOLDER

Abstract:

Largely supported by the Interagency Ecological Program (IEP), California Department of Water Resources (DWR) has operated a fish monitoring program in the Yolo Bypass, a seasonal floodplain and tidal slough, since 1998.

The objectives of the Yolo Bypass Fish Monitoring Program (YBFMP) are to:

1. Collect baseline data on water quality, chlorophyll, lower trophic level biota, and fish in the Yolo Bypass to monitor spatial and temporal changes in trends and abundance.

2. Analyze and communicate Yolo Bypass data with interested parties and the scientific and management communities to address pertinent management-related questions.

3. Provide technical expertise on Yolo Bypass aquatic ecology and monitoring and sampling methods.

Aquatic and terrestrial insects are an important component in the diet of juvenile and adult fishes within the San Francisco Estuary, including two important native fishes: juvenile Chinook Salmon and Sacramento Splittail. The YBFMP collects drift invertebrates year-round from two sites. Currently, samples are collected biweekly (every other week) to weekly (during floodplain inundation) using a rectangular aquatic drift net that sits at the surface of the water. Invertebrates are identified and enumerated by contractors (currently EcoAnalysts, Inc.). The goals of the monitoring program are to compare the seasonal variations in densities and species trends of aquatic and terrestrial insects/non-insects within the Sacramento River channel and the Yolo Bypass, the river’s seasonal floodplain.

Drift invertebrate Key findings to date include: (1) Chinook Salmon sampled in the floodplain had diets comprised of 90% Dipterans and zooplankton, with Chironomidae being the dominant Diptera family (Sommer et al., 2001), (2) The floodplain of the Yolo Bypass contains significantly higher densities of Diptera (Diptera densities being positively associated with flow) and terrestrial invertebrates than the adjacent Sacramento River (Sommer et al. 2001b: Sommer et al. 2004: Sommer et al. 2007), (3) A major portion of the diet of juvenile Sacramento Splittail are chironomid larvae (Kurth and Nobriga 2001, Moyle et al. 2004, Sommer et al. 2007), and (4) The Yolo Bypass was the site of the discovery of a new aestivating and winter emerging chironomid; Hydrobaenus saetheri (Cranston et al. 2007).

The collection of ichthyoplankton is one of multiple elements of the YBFMP. Currently, the YBFMP collects ichthyoplankton in the Yolo Bypass from January to July. Historically, ichthyoplankton were also sampled in the Sacramento River, but due to low catch, this was stopped in 2019. Sampling is conducted with a 500-micron mesh conical plankton net. Fish are identified and enumerated by contractors (currently EcoAnalysts, Inc). The initial goal of ichthyoplankton monitoring was to compare the seasonal variations in densities and species trends within the Sacramento River channel and the Yolo Bypass, the river’s seasonal floodplain (Sommer et al. 2003). The collection of ichthyoplankton samples is an important element in determining the annual presence, timing, and recruitment success of fishes utilizing the Yolo Bypass. Data on ichthyoplankton and associated water quality parameters are presented in this dataset.

Key findings to date include: (1) 26 species of fish larvae were observed in the Yolo Bypass during the 20-years of monitoring (Mollie Ogaz and J. Frantzich, DWR, unpublished data), including Delta Smelt, Hypomesus transpacificus (Sommer et al 2004); (2) The native Prickly Sculpin and non-native Threadfin Shad dominated samples, contributing to over 60% of the total larval catch (Mollie Ogaz and J. Frantzich, DWR, unpublished data); (3) Native species made up a higher percent of total catch in the Yolo Bypass (22.43%) in comparison to in the Sacramento River (10.2%), and appeared earlier in the year than many non-natives (Mollie Ogaz and J. Frantzich, DWR, unpublished data); (4) Similar to other seasonal floodplains in the San Francisco Estuary, alien fishes made up a large portion of the assemblage of early life stages in the Yolo Bypass (Sommer et al 2004); (5) Water temperature and stage are the best explanatory

environmental variables for larval fish abundance in the Yolo Bypass (p=0.001). Flow was not statistically significant (Mollie Ogaz and J. Frantzich, DWR, unpublished data); (6) Species richness and diversity are higher in the Yolo bypass in comparison to in the Sacramento River (Sommer et al. 2004).

Publication Date:

2024-12-11

For more information:
Visit:	DOI PLACE HOLDER

Time Period

Begin:

1998-02-03

End:

2022-12-31

People and Organizations
Contact:	Kwan, Nicole (California Department of Water Resources) [ email ]
Contact:	Vance, Lisa (California Department of Water Resources, Environmental Scientist) [ email ]
Creator:	Interagency Ecological Program
Creator:	Vance, Lisa (California Department of Water Resources, Environmental Scientist)
Associate:	Kwan, Nicole (California Department of Water Resources, PI, Field Crew)
Associate:	Casby, JT (California Department of Water Resources, Field crew, Data Entry)
Associate:	Adams, Jesse (California Department of Water Resources, Field Crew)
Associate:	Miner, Mackenzie (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Olson, Luke (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Ikemiyagi, Naoaki (California Department of Water Resources, Field Crew)
Associate:	Brady, Allison (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Bedwell, Mallory (California Department of Water Resources, Field Crew)
Associate:	Casby, Amanda (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Hudson, Haley (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Olinger, Mitch (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Hubbard, Emily (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Hurley, Parisa (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Stuart, Craig (California Department of Water Resources, Field Crew, Data Entry)
Associate:	Pien, Catarina (California Department of Water Resources/US Bureau of Reclamation, Field Crew)
Associate:	Schreier, Brian M (California Department of Water Resources, Associate)
Associate:	Frantzich, Jared (California Department of Water Resources, Associate)
Associate:	Sommer, Ted (California Department of Water Resources, Associate)
Associate:	Conrad, Louise (California Department of Water Resources, Associate)

Data Entities
Data Table Name:	Drift Invertebrate Data
Description:	Full drift invertebrate data file
Data Table Name:	Drift Invertebrate Taxonomy
Description:	Drift invertebrate taxonomic tree
Data Table Name:	Ichthyoplankton Catch Data
Description:	full data of ichthyoplankton catch
Data Table Name:	Ichthyoplankton Fish Code and Species
Description:	Table of definition of fish code to scientific name and common name, along with how YBFMP code matches with IEP fish codes.
Data Table Name:	Stations
Description:	Drift invertebrate sampling station locations
Other Name:	Drift Metadata
Description:	Drift Invertebrate Metadata
Other Name:	Ichthyoplankton Metadata
Description:	metadata file for ichthyoplankton data
Other Name:	Drift QA/QC Workflow
Description:	Drift Invertebrate QA/QC Workflow Description
Other Name:	Drift QA/QC Code
Description:	Drift Invertebrate QA/QC Script
Other Name:	Ichthyo QAQC Code
Description:	code for qa/qc process of ichthyoplankton data
Other Name:	Physical Data QA/QC Code
Description:	Physical Water Quality QAQC Script

Detailed Metadata

Data Entities

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/818/5/4b89f0cd6b82fc3c68ff27c5b05b47de
Name:	Drift Invertebrate Data
Description:	Full drift invertebrate data file
Number of Records:	13452
Number of Columns:	48

Table Structure

Object Name:

Drift_data_20241209.csv

Size:

4222545 byte

Authentication:

3e6c1fed89daffaf0de3d9fdfab743fa Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

event_id

CommonName

Column Name:

event_id

Datetime

Station

WYClass

Inundation

WeatherCode

Tide

MicrocystisVisualRank

WaterTemperature

Secchi

Conductivity

SpCnd

Turbidity

SetTime

FlowMeterSpeed

FlowMeterStart

FlowMeterEnd

Flowdiff

FlowdiffAdj

Volume

VolumeAdj

ConditionCode

FieldComments

LabComments

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/818/5/793364a600f9725af3f6b4ef333a79f3
Name:	Drift Invertebrate Taxonomy
Description:	Drift invertebrate taxonomic tree
Number of Records:	179
Number of Columns:	18

Table Structure

Object Name:

DriftTaxonomy.csv

Size:

20957 byte

Authentication:

05ee6da70b41494eabbe26016b50802e Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

Kingdom

Phylum

Subphylum

Class

Subclass

Infraclass

Superorder

Order

Suborder

Infraorder

Superfamily

Family

Genus

Species

CommonName

OrganismID

TaxonName

TaxonRank

Definition:

Taxonomic Kingdom

Taxonomic Phylum

Taxonomic Subphylum

Taxonomic Class

Taxonomic Subclass

Taxonomic Infraclass

Taxonomic Superorder

Taxonomic Order

Taxonomic Suborder

Taxonomic Infraorder

Taxonomic Superfamily

Taxonomic Family

Taxonomic Genus

Species designation

Common name of taxa

Organism Code, used to connect to taxonomic table

Lowest taxon determined

Rank of lowest taxon determined

Storage Type:

string

Measurement Type:

nominal

Measurement Values Domain:

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Definition

text

Missing Value Code:

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Code	NA
Expl	Not relevant for organism

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/818/5/3fa53404ef4eac300238f80f52f37909
Name:	Ichthyoplankton Catch Data
Description:	full data of ichthyoplankton catch
Number of Records:	6169
Number of Columns:	46

Table Structure

Object Name:

Ichthyo_data_20241209.csv

Size:

1798071 byte

Authentication:

4b9b5192ea0b9554121250a0b870ed49 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

event_id

SpeciesCode

CommonName

ScientificName

Column Name:

event_id

Datetime

Station

WYClass

Inundation

WeatherCode

Tide

MicrocystisVisualRank

WaterTemperature

Secchi

Conductivity

SpCnd

Turbidity

ConditionCode

FieldComments

MeterSetTime

FlowMeterSpeed

FlowMeterStart

FlowMeterEnd

Flowdiff

FlowdiffAdj

Volume

VolumeAdj

LabComments

SpeciesCode

CommonName

ScientificName

LifeStage

Count

CPUE

CPUEAdj

FlagPhys

CommentPhys

FlagSamp

CommentSamp

FlagLab

CommentLab

FlagFM

CommentFM

FlagCPUE

CommentCPUE

QCFlags

QCComments

Definition:

unique identifier based on sampling date, time and station

Date and time of sample

Sample Site

Water Year

Water Year Class

Was the floodplain inundated?

Weather at time of water quality sample

Tidal stage

Visual rating of Microcystis in sampled body

Temperature of water

Secchi depth sample collected

Electrical conductivity of water

Specific conductivity of water

Total pH of water

Dissolved oxygen concentration

Turbidity of water

Condition of gear during sample such as high debris

Field comments

Amount of time zooplankton net was set

Flowmeter speed (2 types of flowmeters)

Starting flowmeter value

End flowmeter value

Original calculated flowmeter difference

Replaced flowmeter difference values, accounting for QC as described above

Total volume of water sampled in net

Adjusted volume of water based on adjusted Flowdiff values

Comments from contractor

Internal YBFMP species code for fish caught

common name for species

scientific name of species caught

Life stage determined

Number of zooplankton enumerated

Catch per unit effort

Re-calculated CPUE, accounting for QC as described above

Flag for Physical data QC

Comment for Physical data QC (described above)

Flag for Field Sampling QC (described above)

Comment for Field Sampling QC

Flag for Lab Comments QC (described above)

Comment for Lab Comments QC

Flag for Flowmeter QC (described above)

Comment for Flowmeter QC

Flag for CPUE QC (described above)

Comment for CPUE QC

Combined Flags

Combined Comments

Storage Type:

string

date

string

float

string

float

string

float

string

float

string

float

string

Measurement Type:

nominal

dateTime

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

ratio

nominal

Measurement Values Domain:

Definition

text

Format	YYYY-MM-DD hh:mm:ss
Precision

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	SHR
Definition	Sherwood
Source

Code Definition

Code	STTD
Definition	Rotary Screw Trap at Toe Drain
Source

Unit	dimensionless
Type	natural
Min	1998
Max	2020

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	A
Definition	Average
Source

Code Definition

Code	D
Definition	Dry
Source

Code Definition

Code	W
Definition	Wet
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	FALSE
Definition	No inundation
Source

Code Definition

Code	TRUE
Definition	Inundation
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	CLD
Definition	CLD
Source

Code Definition

Code	CLR
Definition	CLR
Source

Code Definition

Code	FOG
Definition	FOG
Source

Code Definition

Code	RAN
Definition	RAN
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Ebb
Definition	Ebb
Source

Code Definition

Code	Flood
Definition	Flood
Source

Code Definition

Code	High
Definition	High
Source

Code Definition

Code	Overtopping
Definition	Overtopping
Source

Code Definition

Code	EBB
Definition	ebb tide
Source

Code Definition

Code	FLD
Definition	flood tide
Source

Code Definition

Code	OB
Definition	Overbank/overtopping
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Microcystis absent
Source

Code Definition

Code	2
Definition	Low-widely scattered colonies
Source

Unit	celsius
Type	real
Min	5.4
Max	25.87

Unit	meter
Type	real
Min	0.04
Max	5.33

Unit	microSeimensPerCentimeter
Type	real
Min	45
Max	948

Unit	microSeimensPerCentimeter
Type	real
Min	63.8
Max	899

Unit	dimensionless
Type	real
Min	5.98
Max	9.36

Unit	milligramPerMilliliter
Type	real
Min	4.82
Max	13.55

Unit	nephelometricTurbidityUnit
Type	real
Min	0.6
Max	404

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	1
Definition	Good or normal sample
Source

Code Definition

Code	2
Definition	Fair sample
Source

Code Definition

Code	3
Definition	Poor sample
Source

Code Definition

Code	4
Definition	No sample taken
Source

Definition

text

Unit	minute
Type	natural
Min	1
Max	31

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Low
Definition	Low flowmeter used
Source

Code Definition

Code	Regular
Definition	Regular flowmeter used
Source

Unit	number
Type	whole
Min	0
Max	994227

Unit	number
Type	natural
Min	910
Max	996000

Unit	number
Type	natural
Min	1
Max	149134

Unit	number
Type	real
Min	206
Max	68946

Unit	meterCubed
Type	real
Min	0.00307158697158697
Max	731.012

Unit	meterCubed
Type	real
Min	0.632746916146916
Max	211.773635343035

Definition

text

Definition

text

Definition

text

Definition

text

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	Adults
Definition	Adults
Source

Code Definition

Code	Larvae
Definition	Larvae
Source

Code Definition

Code	L
Definition	larval
Source

Code Definition

Code	YSL
Definition	yolk sac larvae
Source

Code Definition

Code	J
Definition	juvenile
Source

Unit	number
Type	natural
Min	1
Max	6217

Unit	numberPerMeterCubed
Type	real
Min	0.001
Max	8464.68

Unit	numberPerMeterCubed
Type	real
Min	0.005
Max	126.558

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	2
Definition	Suspicious
Source

Code Definition

Code	3
Definition	Highly Suspicious
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	COND
Definition	Flagging related to Conductivity
Source

Code Definition

Code	SECCHI
Definition	Flagging related to Secchi Depth
Source

Code Definition

Code	TURB
Definition	Flagging related to Turbidity
Source

Code Definition

Code	DO
Definition	Flagging related to DO
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	no comment or acceptable
Source

Code Definition

Code	1
Definition	Questioned but accepted
Source

Code Definition

Code	2
Definition	Suspicious
Source

Code Definition

Code	3
Definition	Highly Suspicious
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	FM
Definition	Flagging related to Flowmeter
Source

Code Definition

Code	SAMP
Definition	Flagging related to sampling
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	0
Definition	no comment or acceptable
Source

Code Definition

Code	1
Definition	questioned but accepted
Source

Code Definition

Code	2
Definition	supsicious
Source

Code Definition

Code	3
Definition	Highly Suspicious
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	LAB
Definition	Flagging related to Lab
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	2
Definition	Suspicious
Source

Code Definition

Code	3
Definition	Highly Suspicious
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	FM
Definition	Flagging related to Flowmeter
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	2
Definition	Suspicious
Source

Allowed Values and Definitions

Enumerated Domain

Code Definition

Code	CPUE
Definition	Flagging related to CPUE
Source

Definition

text

Definition

text

Missing Value Code:

Code	NA
Expl	Unable to be calculated

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	not able to calculate

Code	NA
Expl	not able to calculate

Code	NA
Expl	no code

Code	NA
Expl	no common name listed

Code	NA
Expl	no scientific name listed

Code	NA
Expl	Life stage not determined

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	Not measured or recorded

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Code	NA
Expl	No flag

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/818/5/953732ed3930508764e59d2f3ed25a6b
Name:	Ichthyoplankton Fish Code and Species
Description:	Table of definition of fish code to scientific name and common name, along with how YBFMP code matches with IEP fish codes.
Number of Records:	96
Number of Columns:	4

Table Structure

Object Name:

Crosswalk_fishcode.csv

Size:

4489 byte

Authentication:

524963b344944672e5d1b056f76f7558 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

SpeciesCode

IEPFishCode

CommonName

ScientificName

Column Name:

SpeciesCode

IEPFishCode

CommonName

ScientificName

Definition:

YBFMP fish code identifier

Fish code standardized across all IEP programs

common name for species

scientific name of species caught

Storage Type:

string

Measurement Type:

nominal

Measurement Values Domain:

Definition

text

Definition

text

Definition

text

Definition

text

Missing Value Code:

Code	NAN
Expl	no code

Code	NA
Expl	no code

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Data Table


Data:	https://pasta-s.lternet.edu/package/data/eml/edi/818/5/89146f1382d7dfa3bbf3e4b1554eb5cc
Name:	Stations
Description:	Drift invertebrate sampling station locations
Number of Records:	2
Number of Columns:	4

Table Structure

Object Name:

Stations.csv

Size:

151 byte

Authentication:

06fa2fbd38c5b98a1fafbb5d0b4cc0c0 Calculated By MD5

Text Format:

Number of Header Lines:

Record Delimiter:

\r\n

Orientation:

column

Simple Delimited:

Field Delimiter:	,
Quote Character:	"

Table Column Descriptions

Column Name:

StationCode

StationName

Latitude

Longitude

Definition:

Station Code

Station name

Latitude of sample location

Longitude of sample location

Storage Type:

string

float

Measurement Type:

nominal

ratio

Measurement Values Domain:

Definition

text

Definition

text

Unit	degree
Type	real
Min	38.35338
Max	38.53188

Unit	degree
Type	real
Min	-121.643
Max	-121.528

Missing Value Code:

Accuracy Report:

Accuracy Assessment:

Coverage:

Methods:

Non-Categorized Data Resource

Name:

Drift Metadata

Entity Type:

application/pdf

Description:

Drift Invertebrate Metadata

Physical Structure Description:

Object Name:

DWR-6-MET-005_DriftInvertebrate_v1.2.pdf

Size:

1615771 byte

Authentication:

9e60dc3a8391229d24adf57598527d3b Calculated By MD5

Externally Defined Format:

Format Name:

application/pdf

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/818/5/5e79bf06b9e0011174fa22fff2848cc1

Non-Categorized Data Resource

Name:

Ichthyoplankton Metadata

Entity Type:

application/pdf

Description:

metadata file for ichthyoplankton data

Physical Structure Description:

Object Name:

DWR-6-MET-006_Ichthyoplankton_v1.3.pdf

Size:

1586943 byte

Authentication:

26ff3ea607bc7a9230f5d576597001dc Calculated By MD5

Externally Defined Format:

Format Name:

application/pdf

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/818/5/e4919941bc66cb971f33abafcbdc2e13

Non-Categorized Data Resource

Name:

Drift QA/QC Workflow

Entity Type:

application/pdf

Description:

Drift Invertebrate QA/QC Workflow Description

Physical Structure Description:

Object Name:

Drift_QAQC_Workflow_20210422.pdf

Size:

179045 byte

Authentication:

ca141184462858f1c2dd58e0b3fc0914 Calculated By MD5

Externally Defined Format:

Format Name:

application/pdf

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/818/5/fb1582451f35a8e31da278897151797b

Non-Categorized Data Resource

Name:

Drift QA/QC Code

Entity Type:

.Rmd

Description:

Drift Invertebrate QA/QC Script

Physical Structure Description:

Object Name:

Drift_QAQC.Rmd

Size:

62079 byte

Authentication:

c61c412d5d355799c42f558f1bf5fbf0 Calculated By MD5

Externally Defined Format:

Format Name:

.Rmd

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/818/5/fa528ad46138dee40f0800c58dcccb78

Non-Categorized Data Resource

Name:

Ichthyo QAQC Code

Entity Type:

.Rmd

Description:

code for qa/qc process of ichthyoplankton data

Physical Structure Description:

Object Name:

Ichthyo_QAQC.Rmd

Size:

55853 byte

Authentication:

74463a2e31c773e65969abf5a82ceae1 Calculated By MD5

Externally Defined Format:

Format Name:

.Rmd

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/818/5/20f665e94e1e3ad32a149753a22934c7

Non-Categorized Data Resource

Name:

Physical Data QA/QC Code

Entity Type:

.Rmd

Description:

Physical Water Quality QAQC Script

Physical Structure Description:

Object Name:

LTPhysicalData_QAQC.Rmd

Size:

30167 byte

Authentication:

2291083d15c34f8de441fdb1356774ab Calculated By MD5

Externally Defined Format:

Format Name:

.Rmd

Data:

https://pasta-s.lternet.edu/package/data/eml/edi/818/5/fbaa72e130fecfbdf0d1c2eb4eed7dc8

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)	Yolo Bypass, San Francisco Estuary, Sacramento-San Joaquin Delta, Yolo Bypass Fish Monitoring Program, California Department of Water Resources, Interagency Ecological Program, fish, lower trophic monitoring
LTER Controlled Vocabulary	aquatic ecosystems, freshwater, ecology, estuaries, rivers, floodplain, seasonality, long term, communities, food webs, surveys, weather, turbidity, ph, electrical conductivity, water temperature, water quality, macroinvertebrates, aquatic invertebrates, crustaceans, plankton, larvae, fishes

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:

I. Field Collection Methods

Water Quality Water quality parameters are recorded at the start of each sampling event. Water temperature (degrees Celsius), electrical conductivity (microSiemens/cm), specific conductance (microSiemens/cm), pH, dissolved oxygen (mg/L), and turbidity (FNU) are sampled with a YSI ProDSS handheld meter. Turbidity values are averaged over three readings. Secchi depth is measured in the shade. Tide, condition of sampling (condition code), Microcystis level, vegetation rank, and weather are also recorded with water quality parameters.

Drift Invertebrate Collection

A fixed aquatic drift net is used to collect drift invertebrate samples from the Yolo Bypass at the base of the Toe Drain and the Sacramento River at Sherwood Harbor. The net is held at the surface of the water, with approximately two-thirds of the net submerged and one-third of the net above water. Buoys on each side of the net frame hold the net in position (see photos below), and a pole attached to the net is used to help keep the net in place.

Samples are collected on an ebb tide, either on a biweekly or weekly basis (during floodplain inundation). In the Yolo Bypass, samples are collected year-round from or adjacent to the YBFMP rotary screw trap, which is anchored in the middle of the Toe Drain channel. At the Sacramento River site, nets are deployed dockside during periods of higher flows (typically January-June), and from a boat at 2-3 mph when

downstream flows are insufficient (e.g. <2 fps, typically July-December). The net is fished for 10 minutes, though sampling times may be shortened when high levels of debris interfere with sample collection. Tow times are recorded with each sampling event. Samples are washed down with deionized water and preserved in 5% Formalin with Rose Bengal dye to aid in separating organisms from detritus and algae.

Dimensions of the net: 500 micron net, 0.46m x 0.3m rectangular mouth, 0.91m in length, tapering to 0.076m at the cod-end, which is screened with 500 micron mesh. Buoys are attached to the rectangular frame on each side, and are 5.25 inches (13.3cm) long, 3 inches (7.52cm) in diameter, with approximately a 14 inch (35.6cm) circumference. General Oceanics flow meters (Model 2030R) are used to measure water volume. However, due to the drift net being only partially in the water, the flow meter was instead attached to a 500 micron egg & larval net that is deployed at the same time as the drift net until 2021. In 2021, the drift net received its own flowmeter that is attached external to the submerged portion of the net.

II. Sample Processing and Tracking

Sample Tracking Samples are tracked on an excel spreadsheet. A chain of custody (COC) listing sample number, date, time, location, type, and study/project is sent to contractors, who check that all samples are accounted for. Signatures are required of both the person responsible for sending the sample package, and the person receiving it. Once the sample is sent, the contractor is notified of approximate date of delivery.

Sample transfer After being stored for a minimum of two weeks in 5% formalin, invertebrate samples are rinsed through a 250 micron sieve. Large debris (leaves, sticks, etc.) are carefully rinsed and removed. The remaining sample is retained for identification and transferred to 70% ethanol. Samples are securely packaged to prevent leakage and breakage. Samples are then shipped to contractors for taxonomic identification. The contractors return the samples to DWR after completing analyses.

Identification and Enumeration Drift invertebrate samples are rinsed and passed through a 500micron sieve and processed under a lighted, stereoscopic microscope with a minimum magnification of 10X. Material remaining on the sieve is processed by removing all organisms from the sample for identification. All aquatic insects and non-insects are identified to the family level and counted, and all terrestrial insects and non-insects are identified to the order level and counted. All organisms are identified to life-history stage (nymph, larvae, pupae, emergent, or adult), sorted for counts per life-stage, and both wet and dry weights (to 0.0001g) are quantified for each life-stage group.

Sample Archive

Samples are stored by the contractor for up to 90 days, then returned to DWR for storage.

Ichthyoplankton Collection

A fixed net is used to collect ichthyoplankton samples from the Yolo Bypass at the base of the Toe Drain and the Sacramento River at Sherwood Harbor. Samples are collected on an ebb tide, either on a biweekly or weekly basis (during floodplain inundation). In the Yolo Bypass, samples are collected from January to the end of June from or adjacent to the YBFMP rotary screw trap, which is anchored in the middle of the Toe Drain channel. Sampling is no longer conducted in the Sacramento River due to low historical catch. See historical changes for more information. The net is fished just below the surface for 10 minutes, though sampling times may be shortened when high levels of debris interfere with sample collection. Tow times are recorded with each sampling event. Samples are washed down with deionized water and preserved in 5% Formalin with Rose Bengal dye to aid in separating organisms from detritus and algae. Dimensions of the plankton net are as follows: 500-micron conical net, 2.5 m long with a 0.75 m diameter opening, equipped polyethylene cod-end jar screened with 500-micron mesh. General Oceanics flow meters (Model 2030R) are used to measure water volume.

II. Sample Processing and Tracking

Sample transfer After being stored for a minimum of two weeks in 5% formalin, ichthyoplankton samples are rinsed through a 250-micron sieve. Large debris (leaves, sticks, etc.) are carefully rinsed and removed. The remaining sample is retained for identification and transferred to 70% ethanol. Samples are securely packaged to prevent leakage and breakage. Samples are then shipped to contractors for taxonomic identification. The contractors return the samples to DWR after completing analyses.

Identification and Enumeration The contractor filters samples through a 500-micron sieve. Samples are processed under a lighted, stereoscopic microscope with a minimum magnification of 5X. The ichthyoplankton (including their eggs) samples are enumerated and identified to the lowest taxonomic level possible (species preferred). The life stage for all enumerated ichthyoplankton samples is identified and recorded as either eggs, yolk-sac larvae, preflexion larvae, flexion larvae, post flexion larvae, or juveniles. All eggs are counted and identified to Family (species preferred). Up to 30 individuals of each ichthyoplankton species are measured in millimeters and recorded as both total length and fork length for each sample.

Sample Archive

Samples are stored by the contractor for up to 90 days, then returned to DWR for storage.

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:

Interagency Ecological Program

Individual:

Lisa Vance

Organization:

California Department of Water Resources

Position:

Environmental Scientist

Email Address:

lisa.vance@water.ca.gov

Id:

https://orcid.org/0009-0007-6954-1103

Contacts:

Individual:

Nicole Kwan

Organization:

California Department of Water Resources

Email Address:

Nicole.Kwan@water.ca.gov

Id:

https://orcid.org/0000-0003-1178-7788

Individual:

Lisa Vance

Organization:

California Department of Water Resources

Position:

Environmental Scientist

Email Address:

lisa.vance@water.ca.gov

Id:

https://orcid.org/0009-0007-6954-1103

Associated Parties:

Individual:

Nicole Kwan

Organization:

California Department of Water Resources

Email Address:

Nicole.Kwan@water.ca.gov

Id:

https://orcid.org/0000-0003-1178-7788

Role:

PI, Field Crew

Individual:

JT Casby

Organization:

California Department of Water Resources

Email Address:

James.Casby@water.ca.gov

Role:

Field crew, Data Entry

Individual:

Jesse Adams

Organization:

California Department of Water Resources

Email Address:

Jesse.Adams@water.ca.gov

Id:

https://orcid.org/0000-0002-0739-8782

Role:

Field Crew

Individual:

Mackenzie Miner

Organization:

California Department of Water Resources

Email Address:

mackenzie.miner@water.ca.gov

Role:

Field Crew, Data Entry

Individual:

Luke Olson

Organization:

California Department of Water Resources

Email Address:

luke.olson@water.ca.gov

Role:

Field Crew, Data Entry

Individual:

Naoaki Ikemiyagi

Organization:

California Department of Water Resources

Email Address:

Naoaki.Ikemiyagi@water.ca.gov

Role:

Field Crew

Individual:	Allison Brady
Organization:	California Department of Water Resources
Role:	Field Crew, Data Entry

Individual:

Mallory Bedwell

Organization:

California Department of Water Resources

Email Address:

Mallory.Bedwell@water.ca.gov

Id:

https://orcid.org/0000-0001-9553-6032

Role:

Field Crew

Individual:	Amanda Casby
Organization:	California Department of Water Resources
Role:	Field Crew, Data Entry

Individual:	Haley Hudson
Organization:	California Department of Water Resources
Role:	Field Crew, Data Entry

Individual:

Mitch Olinger

Organization:

California Department of Water Resources

Email Address:

mitchell.olinger@water.ca.gov

Role:

Field Crew, Data Entry

Individual:

Emily Hubbard

Organization:

California Department of Water Resources

Email Address:

emily.hubbard@water.ca.gov

Role:

Field Crew, Data Entry

Individual:

Parisa Hurley

Organization:

California Department of Water Resources

Email Address:

parisa.hurley@water.ca.gov

Role:

Field Crew, Data Entry

Individual:

Craig Stuart

Organization:

California Department of Water Resources

Email Address:

craig.stuart@water.ca.gov

Role:

Field Crew, Data Entry

Individual:

Catarina Pien

Organization:

California Department of Water Resources/US Bureau of Reclamation

Email Address:

cpien@usbr.gov

Id:

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

Role:

Field Crew

Individual:

Brian M Schreier

Organization:

California Department of Water Resources

Email Address:

Brian.Schreier@water.ca.gov

Id:

https://orcid.org/0000-0002-5075-3946

Role:

Associate

Individual:

Jared Frantzich

Organization:

California Department of Water Resources

Email Address:

Jared.Frantzich@water.ca.gov

Role:

Associate

Individual:

Ted Sommer

Organization:

California Department of Water Resources

Email Address:

Ted.Sommer@water.ca.gov

Role:

Associate

Individual:

Louise Conrad

Organization:

California Department of Water Resources

Email Address:

Louise.Conrad@deltacouncil.ca.gov

Role:

Associate

Temporal, Geographic and Taxonomic Coverage

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

Time Period

Begin:

1998-02-03

End:

2022-12-31

Sampling Site:

Description:

Sacramento River at Sherwood Harbor

Site Coordinates:

Longitude (degree):

-121.528

Latitude (degree):

38.53188

Sampling Site:

Description:

Screw Trap in Toe Drain

Site Coordinates:

Longitude (degree):

-121.643

Latitude (degree):

38.35338

Project

Parent Project Information:

Title:

YBFMP

Personnel:

Individual:

Brian M Schreier

Organization:

California Department of Water Resources

Email Address:

Brian.Schreier@water.ca.gov

Id:

https://orcid.org/0000-0002-5075-3946

Role:

Principal Investigator

Funding:

State Water Project Not applicable

Maintenance

Maintenance:

Description:	Collection is ongoing; updates expected approximately biennially
Frequency:

Additional Info


Additional Information:
	Version number Date created Description of changes Justification for change Version editor Contact info 1.1 4/9/2021 First version for publication. Includes through 2019. First version for publication. Catarina Pien Catarina.Pien@water.ca.gov

Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'fetchedFromEDI'
        |     |        \___attribute 'dateFetched' = '2024-12-06'
        |     |        \___attribute 'packageID' = 'edi.818.3'
        |     |___text '\n      '
        |___text '\n   '

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'importedFromXML'
        |     |        \___attribute 'dateImported' = '2024-12-06'
        |     |        \___attribute 'filename' = 'edi.818.3.xml'
        |     |        \___attribute 'taxonomicCoverageExempt' = 'True'
        |     |___text '\n      '
        |___text '\n   '

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'unitList' in ns 'http://www.xml-cml.org/schema/stmml-1.2' ('stmml:unitList')
        |     |     |___text '\n            '
        |     |     |___element 'unit' in ns 'http://www.xml-cml.org/schema/stmml-1.2' ('stmml:unit')
        |     |     |     |  \___attribute 'id' = 'microSeimensPerCentimeter'
        |     |     |     |  \___attribute 'multiplierToSI' = '1.00E-03'
        |     |     |     |  \___attribute 'name' = 'microSeimensPerCentimeter'
        |     |     |     |  \___attribute 'parentSI' = 'siemensPerMeter'
        |     |     |     |  \___attribute 'unitType' = 'conductance'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description' in ns 'http://www.xml-cml.org/schema/stmml-1.2' ('stmml:description')
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit' in ns 'http://www.xml-cml.org/schema/stmml-1.2' ('stmml:unit')
        |     |     |     |  \___attribute 'id' = 'nephelometricTurbidityUnit'
        |     |     |     |  \___attribute 'multiplierToSI' = ''
        |     |     |     |  \___attribute 'name' = 'nephelometricTurbidityUnit'
        |     |     |     |  \___attribute 'parentSI' = ''
        |     |     |     |  \___attribute 'unitType' = 'turbidity'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description' in ns 'http://www.xml-cml.org/schema/stmml-1.2' ('stmml: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.10.30'
        |     |___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: Drift invertebrate and ichthyoplankton catch and water quality from the Sacramento River channel, and Sacramento River floodplain and tidal slough, collected by the Yolo Bypass Fish Monitoring Program, 1998-2022

Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

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

Additional Metadata

Additional Metadata

Additional Metadata

Recently Added

Recently Updated

Data Package Metadata View Summary

Interagency Ecological Program: Drift invertebrate and ichthyoplankton catch and water quality from the Sacramento River channel, and Sacramento River floodplain and tidal slough, collected by the Yolo Bypass Fish Monitoring Program, 1998-2022

+/- Data Entities

Data Table

Data Table

Data Table

Data Table

Data Table

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

Non-Categorized Data Resource

+/- 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

+/- Additional Metadata

+/- 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 Info

Additional Metadata

Additional Metadata

Additional Metadata

Additional Metadata