Data Package Metadata   View Summary

Interagency Ecological Program: San Francisco Bay Study Survey for Fish and Mobile Crustaceans 1980-2022

General Information
Data Package:
Local Identifier:edi.1567.1
Title:Interagency Ecological Program: San Francisco Bay Study Survey for Fish and Mobile Crustaceans 1980-2022
Alternate Identifier:DOI PLACE HOLDER
Abstract:

The San Francisco Bay Study was established in 1980 to determine the effects of freshwater outflow on the abundance and distribution of fish and mobile crustaceans in the San Francisco Estuary, mainly downstream of the Sacramento-San Joaquin Delta. The Bay Study survey currently samples open-water stations from a research vessel with two types of trawl gear: a midwater trawl to sample the pelagic community, and an otter trawl to sample demersal organisms. Historically, the study also included plankton sampling (1980-1989). In both otter and midwater trawl samples, fish, crabs, and gelatinous zooplankton are identified to species, and length/size data are collected on a representative subsample. Shrimp species are collected from each otter trawl sample and biometric data are collected in the lab (counts, sex, gravid-status, length). Several physical and water quality parameters (temperature, salinity, conductivity, water clarity and depth) are collected at each station to describe estuarine environmental conditions that relate to abundance and distribution trends. This publication will include fish and water quality data. Some metadata are included for crab, shrimp, and gelatinous zooplankton and publication of this data will follow.

Publication Date:2024-02-01
For more information:
Visit: DOI PLACE HOLDER

Time Period
Begin:
1980
End:
2022

People and Organizations
Contact:Hieb, Kathy A (California Department of Fish and Wildlife, Primary Investigator) [  email ]
Contact:Burns, Jillian M (California Department of Fish and Wildlife, Environmental Scientist) [  email ]
Contact:Soto, Kenji (California Department of Fish and Wildlife, Environmental Scientist) [  email ]
Creator:Hieb, Kathy A (California Department of Fish and Wildlife, Principal Investigator)
Creator:Burns, Jillian M (California Department of Fish and Wildlife, Environmental Scientist)
Creator:Soto, Kenji (California Department of Fish and Wildlife)
Associate:Ngo, Aaron (California Department of Fish and Wildlife, Senior Lab Assistant, Senior Lab Assistant)

Data Entities
Data Table Name:
boatstation
Description:
metrics recorded at each station
Data Table Name:
boattow
Description:
metrics recorded at each tow
Data Table Name:
fishcatch
Description:
fish catch data from the San Francisco Bay Study
Data Table Name:
fishlength
Description:
data for the length or width of measured taxon collected in each tow
Data Table Name:
speciescodes
Description:
lookup table with alpha code, common name, species name, and other information for each taxa in the database
Data Table Name:
substratecodes
Description:
lookup table for descriptions of substrate types
Data Table Name:
stationconstants
Description:
information related to theoretical station locations
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/7bb120165e608ea894786796b6324cf4
Name:boatstation
Description:metrics recorded at each station
Number of Records:22460
Number of Columns:19

Table Structure
Object Name:boatstation.csv
Size:1956771 byte
Authentication:f6da4b4af728ade8b86262353e2e2200 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 YearSurveyStationDateDepthSecchiSubstrateCodeWavesCloudCoverTideECSurfECAvgECBottSalinSurfSalinAvgSalinBottTempSurfTempAvgTempBott
Column Name:Year  
Survey  
Station  
Date  
Depth  
Secchi  
SubstrateCode  
Waves  
CloudCover  
Tide  
ECSurf  
ECAvg  
ECBott  
SalinSurf  
SalinAvg  
SalinBott  
TempSurf  
TempAvg  
TempBott  
Definition:year when sampling occurredusually the month when sampling occurred, but not alwaysproject station numberdate sampling occurredwater depth of stationwater transparencylikely substrate based on what came up in the otter trawl samplestatus of wavesstatus of cloud covercurrentsurface electro-conductivityaverage electro-conductivitybottom electro-conductivitysurface salinityaverage salinitybottom salinitysurface temperatureaverage temperaturebottom temperature
Storage Type:dateTime  
float  
float  
dateTime  
float  
float  
string  
string  
string  
string  
float  
float  
float  
float  
float  
float  
float  
float  
float  
Measurement Type:dateTimeratioratiodateTimeratiorationominalnominalnominalnominalratioratioratioratioratioratioratioratioratio
Measurement Values Domain:
FormatYYYY
Precision
Unitcorresponds with month, but not always
Typeinteger
Min
Max12 
Unitnumber
Typeinteger
FormatYYYY-MM-DD
Precision
Unitmeter
Typereal
Unitcentimeter
Typeinteger
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitioncalm
Source
Code Definition
Code2
Definitionchoppy
Source
Code Definition
Code3
Definitionwhite caps
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionclear
Source
Code Definition
Code2
Definitionpartial cloudy
Source
Code Definition
Code3
Definitioncloudy or foggy
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionflooding
Source
Code Definition
Code2
Definitionebbing
Source
Code Definition
Code3
Definitionlow slack
Source
Code Definition
Code4
Definitionhigh slack
Source
UnitmicrosiemensPerCentimeter
Typereal
UnitmicrosiemensPerCentimeter
Typereal
UnitmicrosiemensPerCentimeter
Typereal
UnitpracticalSalinityUnit
Typereal
UnitpracticalSalinityUnit
Typereal
UnitpracticalSalinityUnit
Typereal
Unitcelsius
Typereal
Unitcelsius
Typereal
Unitcelsius
Typereal
Missing Value Code:        
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
Accuracy Report:                                      
Accuracy Assessment:                                      
Coverage:                                      
Methods:                                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/7c75e0b5a589f9fae1b8b6a3c8ca30b9
Name:boattow
Description:metrics recorded at each tow
Number of Records:47318
Number of Columns:18

Table Structure
Object Name:boattow.csv
Size:4054973 byte
Authentication:2a072a62e6569d35908bac0e191d7007 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\r\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 YearSurveyStationNetTowCodeTime, 24-hour clockBearingTideDirectionDurationStartLatStartLongEndLatEngLongTotalMeterTow_volumeDistanceTow_area
Column Name:Year  
Survey  
Station  
Net  
Tow  
Time  
Bearing  
Tide  
Direction  
Duration  
StartLat  
StartLong  
EndLat  
EndLong  
TotalMeter  
TowVolume  
Distance  
TowArea  
Definition:year when sampling occurredusually the month when sampling occurred, but not alwaysproject station numbertype of net employedcode indicating whether tow is valid or nottime when sampling occurredbearing for tow directioncurrent directiondirection towed in relation to the currentduration of towlatitude when the tow startslongitude when the tow startslatitude when the tow endslongitude when the tow endsdifference between the end and start net flowmeter numbersvolume of water sampleddistance over ground travelled during the towarea sampled
Storage Type:dateTime  
float  
float  
string  
string  
dateTime  
float  
string  
string  
float  
float  
float  
float  
float  
float  
float  
float  
float  
Measurement Type:dateTimeratiorationominalnominaldateTimerationominalnominalratioratioratioratioratioratioratioratioratio
Measurement Values Domain:
FormatYYYY
Precision
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionmidwater trawl
Source
Code Definition
Code2
Definitionotter trawl
Source
Code Definition
Code3
Definitionplankton net
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionvalid tow
Source
Code Definition
Code52
Definitiontow not quantifiable (occasionally used after 1981)
Source
Code Definition
Code53
Definitionnet snagged, twisted, or tangled during tow. Data collected, but not quantifiable (not used after 1982)
Source
Code Definition
Code54
Definitiontow was complete, but backwards (valid tow, rarely used after 1988). Do not use these tows when calculating average distance towed for estimating distance.
Source
Code Definition
Code55
Definitiondistance towed was adjusted due to the start or end latitude/longitude taken at the wrong time (valid tow). Do not use these tows when calculating average distance towed.
Source
Code Definition
Code56
Definitiontow completed, but sample lost (shrimp or plankton sample lost, valid for fish).
Source
Code Definition
Code57
Definitionotter trawl more or less than 5 minutes, or mid-water trawl more or less than 12 minutes (valid tows, used when calculating CPUE as number per standard tow or to exclude non-standard tows when calculating average distance or meter reading).
Source
Code Definition
Code58
Definitionfish lost, tow valid for shrimp (used once in 1993)
Source
Formathh:mm
Precision
Unitdegree
Typereal
Min
Max360 
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionflooding
Source
Code Definition
Code2
Definitionedding
Source
Code Definition
Code3
Definitionlow slack
Source
Code Definition
Code4
Definitionhigh slack
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionwith the current
Source
Code Definition
Code2
Definitionagainst the current
Source
Code Definition
Code3
Definitionneither with or against the current (slack or cross-current tow)
Source
Unitminute
Typereal
Unitdecimal degrees
Typereal
Unitdecimal degrees
Typereal
Unitdecimal degrees
Typereal
Unitdecimal degrees
Typereal
Unitmeter
Typereal
UnitmeterCubed
Typereal
UnitnauticalMile
Typereal
UnitmeterSquared
Typereal
Missing Value Code:            
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
Accuracy Report:                                    
Accuracy Assessment:                                    
Coverage:                                    
Methods:                                    

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/4b33d03333491192efe35bdf6b5b5bcf
Name:fishcatch
Description:fish catch data from the San Francisco Bay Study
Number of Records:155282
Number of Columns:6

Table Structure
Object Name:fishcatch.csv
Size:3497081 byte
Authentication:aaf763a80f5ad7bfc090baf62492bcd9 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 YearSurveyStationNetAlphaCodeTotalCatch
Column Name:Year  
Survey  
Station  
Net  
AlphaCode  
TotalCatch  
Definition:year when sampling occurredusually the month when sampling occurred, but not alwaysproject station numbertype of net employedtext code assigned to each taxonnumber of fish taxon collected per tow
Storage Type:integer  
float  
float  
string  
string  
float  
Measurement Type:ratioratiorationominalnominalratio
Measurement Values Domain:
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionmidwater trawl
Source
Code Definition
Code2
Definitionotter trawl
Source
Code Definition
Code3
Definitionplankton net
Source
Definitiontext
Unitnumber
Typereal
Missing Value Code:            
Accuracy Report:            
Accuracy Assessment:            
Coverage:            
Methods:            

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/2f195796029ac1b9cd23040dfae878fd
Name:fishlength
Description:data for the length or width of measured taxon collected in each tow
Number of Records:882844
Number of Columns:9

Table Structure
Object Name:fishlength.csv
Size:28649940 byte
Authentication:096ba9765c736c2ae110c2c5711976dc Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 YearSurveyStationNetAlphaCodeLengthWidthFrequencyAdjustedFreq
Column Name:Year  
Survey  
Station  
Net  
AlphaCode  
Length  
Width  
Frequency  
AdjustedFreq  
Definition:year when sampling occurredusually the month when sampling occurred, but not alwaysproject station numbertype of net employedtext code assigned to each taxonFork length; if no fork, total length.wing widthnumber of individuals measured at lengthNumber at length measured adjusted to incorporate plus counts.
Storage Type:dateTime  
float  
float  
string  
string  
float  
float  
float  
float  
Measurement Type:dateTimeratiorationominalnominalratioratioratioratio
Measurement Values Domain:
FormatYYYY
Precision
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionmidwater trawl
Source
Code Definition
Code2
Definitionotter trawl
Source
Code Definition
Code3
Definitionplankton net
Source
Definitiontext
Unitmillimeter
Typereal
Unitmillimeter
Typereal
Unitnumber
Typeinteger
Unitnumber
Typereal
Missing Value Code:          
CodeNA
ExplNot Applicable
CodeNA
Explnot available
 
CodeNA
Explnot available
Accuracy Report:                  
Accuracy Assessment:                  
Coverage:                  
Methods:                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/0b358a3fe3eab8f8a6d70d2c6a9ca3dd
Name:speciescodes
Description:lookup table with alpha code, common name, species name, and other information for each taxa in the database
Number of Records:176
Number of Columns:11

Table Structure
Object Name:speciescodes_clean.csv
Size:18570 byte
Authentication:998c65da593766013809f78a6ed94f31 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 AlphaCodeDFGCodeCommonNameScientificNamePhylumFamilyNativeOrIntroducedMidwaterTrawlOtterTrawlLarvalNetComments
Column Name:AlphaCode  
DFGCode  
CommonName  
ScientificName  
Phylum  
Family  
NativeOrIntroduced  
MidwaterTrawl  
OtterTrawl  
LarvalNet  
Comments  
Definition:text code assigned to each taxonnumeric code assigned to each taxon; used by other CDFW surveyscommon name of taxongenus and species of taxonphylum of taxonfamily of taxonindicates whether taxon is native or introduced to the study areayear when taxon was first collected in the midwater trawlyear when taxon was first collected in the otter trawlyear when taxon was first collected in the plankton netcomments related to changes in species names
Storage Type:string  
float  
string  
string  
string  
string  
string  
float  
float  
float  
string  
Measurement Type:nominalrationominalnominalnominalnominalnominalratioratiorationominal
Measurement Values Domain:
Definitiontext
Unitnumber
Typereal
Definitiontext
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeChordata
Definitionorganisms with a flexible rod supporting their dorsal or back sides
Source
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeI
Definitionintroduced
Source
Code Definition
CodeN
Definitionnative
Source
Unitnumber
Typereal
Unitnumber
Typereal
Unitnumber
Typereal
Definitiontext
Missing Value Code:  
CodeNA
Explnot available
 
CodeNA
Explnot available
 
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
CodeNA
Explnot available
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/80306c322ac6ae70bb3c8120ee96fd1d
Name:substratecodes
Description:lookup table for descriptions of substrate types
Number of Records:37
Number of Columns:3

Table Structure
Object Name:substratecodes_lookup.csv
Size:1872 byte
Authentication:68bbdcd37269b514a691a5e75103fffb Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 SubstrateCodeDescriptionComments
Column Name:SubstrateCode  
Description  
Comments  
Definition:text code assigned to each substratedescription of substrateextra information related to the substrate
Storage Type:string  
string  
string  
Measurement Type:nominalnominalnominal
Measurement Values Domain:
Definitiontext
Definitiontext
Definitiontext
Missing Value Code:  
CodeNA
Explnot available
CodeNA
Explnot available
Accuracy Report:      
Accuracy Assessment:      
Coverage:      
Methods:      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1567/1/a4869ab20578884fd9e41be0743dc8a2
Name:stationconstants
Description:information related to theoretical station locations
Number of Records:55
Number of Columns:8

Table Structure
Object Name:stationconstants.csv
Size:6302 byte
Authentication:ad11f7ddaafcadda7e34aee43d11a4b6 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 StationSeriesBayChanShoalLatitudeLongitudeDescriptionComments
Column Name:Station  
Series  
Bay  
ChanShoal  
Latitude  
Longitude  
Description  
Comments  
Definition:project station numbercode assigned depending on when station was added to surveyregion of the estuary where station is locatedchannel or shoaltheoretical station latitude in WGS 1984 CoordinateTheoretical station longitude in WGS 1984 Coordinatelocation of the stationcomments related to the station
Storage Type:float  
string  
string  
string  
float  
float  
string  
string  
Measurement Type:rationominalnominalnominalratiorationominalnominal
Measurement Values Domain:
Unitnumber
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionoriginal stations
Source
Code Definition
Code2
Definitionstations added in December 1987
Source
Code Definition
Code3
Definitionstations added in February 1991
Source
Code Definition
Code4
Definitionstations added in May 1994
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
DefinitionSouth Bay
Source
Code Definition
Code2
DefinitionCentral Bay
Source
Code Definition
Code3
DefinitionSan Pablo Bay
Source
Code Definition
Code4
DefinitionSuisun Bay
Source
Code Definition
Code5
DefinitionWestern Delta (confluence)
Source
Code Definition
Code6
DefinitionLower Sacramento River
Source
Code Definition
Code7
DefinitionLower San Joaquin River
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
Definitionchannel
Source
Code Definition
Code2
Definitionshoal
Source
Unitdecimal degrees
Typereal
Unitdecimal degrees
Typereal
Definitiontext
Definitiontext
Missing Value Code:              
CodeNA
Explnot available
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)trawl, Interagency Ecological Program for the San Francisco Bay Delta Estuary
LTER Controlled Vocabularyaquatic ecosystems, long term monitoring, organisms, nekton, fishes, invertebrates, crustaceans, water quality

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.) Field Data Collection methods:

The San Francisco Bay Study (Bay Study) was established in 1980 and the initial sampling design included 35 stations; 7 stations were added in 1988, 4 stations were added in 1990, and 6 stations were added in 1994. The current protocol is to sample all 52 stations (25 channel and 27 shoal stations) 12 times per year (approximately once per month; see Figure 1 for a map of stations). See sampling frequency figures in the metadata pdf for deviations from sampling effort. Every effort is made to sample within 0.5 nautical mile of the actual station location. Extenuating circumstances such as vessel traffic or inaccessibility due to tides may force a station to be sampled slightly out of geographic range. A midwater trawl (MWT) and otter trawl (OT) are conducted at each station and the crew leader records the data on a paper datasheet. A plankton net was used from 1980 to 1989 to sample larval fish and crustaceans. These methods are described separately at the end of this section.

Station and Tow Data: At each station, the crew leader records the status of waves and cloud cover. Substrate type is recorded based on the majority substrate of the OT sample. The depth is recorded during the first tow at a station and monitored throughout both tows. Sometimes an average depth is used when the depth varies. At the start of each tow when the net is actively fishing, the crew leader records the tow parameters including: net type, tide (direction of the current) , tow direction relative to the current, time of day, start latitude, start longitude, and bearing (using a GPS unit) , as well as the start flow meter reading (which is usually the end meter from the previous tow). As soon as the tow ends, the crew leader records the end latitude and end longitude (from a GPS unit), tow distance (from a GPS unit) , tow duration , and the end reading from the flow meter. Once sampling processing is complete, a catch code is recorded for each tow.

Midwater Trawl: The midwater trawl is generally towed in the direction of the current for 12 minutes, except for during periods of slack tide (when there is no movement either way in the tidal stream). Tow direction during slack tide is with the direction that the current will be turning, as established by the mate. The length of tow cable deployed varies relative to water depth; cable length is verified by the mate. The lead deckhand retrieves the net at approximately 25 feet per minute during the tow to sample the water column obliquely. Depending on the amount of cable deployed, there are scheduled stops when the deckhand pauses retrieval.

Otter Trawl: The otter trawl is generally towed against the current for 5 minutes, except for periods of slack tide in which the tow is generally against the direction that the tide will be turning. The crew lead or mate may reduce tow time to 3 minutes if a station has a history of excessively large samples or snags. The length of tow cable deployed depends on the water depth and cable length is verified by the mate. In general, the ratio of length of tow cable to depth follows the 5:1 scope ratio where the length includes the 100’ bridle.

Water Quality: Water quality measurements are taken at every station, including a salinity, conductivity, and temperature depth profile, and the Secchi depth. The boat position relative to station is verified prior to collecting the water quality measurements. An electronic CTD meter from Seabird Electronics (Seabird) is used to collect a salinity, conductivity, and temperature profile of the water column. The Seabird is hydraulically deployed from a davit on the boat’s port side. The unit is first pre-soaked by running submerged at the surface for one minute; the unit is then lowered continuously collecting 4 scans per second. When the Seabird reaches the bottom, the unit is drawn back up. A Secchi depth reading is taken on the shaded side of the boat when the boat is in neutral, and the reader has removed their sunglasses. The Secchi depth is determined to the nearest five centimeters (cm) .

Re-tows: When a tow cannot be completed or the sample is not acceptable, a re-tow can be conducted. Reasons for a re-tow include a shortened tow due to vessel traffic, an untied cod end, large holes in the net, evidence that the net did not open or fish properly, or other evidence of an incomplete sample. When a re-tow is conducted, the original sample and net must be checked for listed species and their catch is include in the regular ESA reporting. If the net was snagged or contained very large/heavy objects, the net is closely checked for any damage and is repaired or replaced as needed.

Sample Processing: The sample is emptied into a tub and any large fish are measured and released right away (e.g., bat rays, sharks, sturgeon). The sample is placed on the sorting board and crew members remove any debris and sort the remaining fish and crabs into buckets of water and gelatinous zooplankton (jellies) are placed a pile on the sorting board. Shrimp are sorted into a separate bucket. When sorting is complete, the remaining organisms are processed. Jellies and Northern Anchovies are only processed from the midwater trawl. Crabs and shrimp are only processed from the otter trawl . For fish, up to 50 randomly selected fish of each species are measured to the nearest millimeter for length (fork length or total length for fish without forked tails) and the rest are counted (referred to as “plus count”). Wing width is measured for Bat Rays. Sharks are measured from the tip of the snout to the tip of the tail (i.e., total length). The minimum fish cutoff length is 20 mm , with the following exceptions: Northern Anchovy = 40 mm, Longfin Smelt = 40 mm, Delta Smelt = 30 mm, Pacific Herring = 30 mm, Catfish = 30 mm, Striped Bass = 25 mm . Fish below these cutoff lengths are too small to be sampled consistently by the mesh size used. Some cutoff lengths were established since 1980 and therefore some prior fish length data are in the database below these thresholds. As Longfin Smelt and Delta Smelt are listed species, any lengths less than the minimum cutoff and greater the 20 mm are also recorded. These fish are not entered into the Bay Study database but are reported as ESA take. Crabs are identified to species. For all Cancer crabs, Portunus xantusii, and Eriocheir sinensis up to 30 randomly selected individuals of each species are sexed and the carapace width (CW) is measured to the nearest millimeter with calipers; the remaining crabs are plus counted. CW for Cancer magister is measured inside the 10th anterolateral teeth while CW for all other Cancer species is measured at the widest point of the carapace. Cancer magister with CW >29 mm are sexed; all other crabs having CW >19 mm are sexed. Crabs below this threshold are labelled “juvenile”. Any unidentified fish or crabs are preserved or frozen for later identification in the lab. Shrimp are preserved in 10% formalin and no more than 1 liter is brought back to the lab for processing. Shrimp are subsampled when the sample is more than 1 liter. A graduated pitcher is used to measure the total volume and enough shrimp are randomly removed until 1 liter remains. The total volume caught and volume kept are recorded on the datasheet, in addition to the size bag used (Whirl Pak or cotton bag). The shrimp sample is returned to the lab for processing. Details on shrimp processing will be provided when the data is published. Subsampling is used to minimize processing time when a very large number of fish are collected or when an otter trawl sample is excessively large or full of mud/tubes or other substrate. Subsampling data is used to calculate the total catch (see below) but is not currently published. A detailed description of the subsampling protocol is available upon request.

Plankton Net: The plankton net was towed for 5 minutes on the bottom and then retrieved obliquely at a constant rate. In general, the ratio of length of tow cable to depth follows the 5:1 scope ratio. A General Oceanics flowmeter suspended in the mouth of the net was used to estimate water flow through the net. Plankton samples were preserved in 10% formalin and returned to the laboratory for processing. Depending on the number of larval fish and detritus in the sample, all or a portion of the sample was sorted for larval and juvenile fish. Larval fish were identified to the lowest taxon possible, then 30 randomly selected fish of each species were measured to the nearest 0.1 mm (total length) and the remainder counted. Fish greater than 15 mm total length were measured to the nearest 0.5 mm and any fish >50 mm were not included. Larvae were categorized as yolk-sac larvae, post yolk-sac larvae, or juveniles. Only flatfish were measured from 1987 to 1989 while all other species were enumerated by life stage. Northern anchovy eggs were sorted and counted from 1980 through 1987.

2.) Instrument and Equipment Specifications, including QAQC methods and frequency:

Midwater Trawl: The MWT net has a mouth opening of 12’ by 12’ (3.7m by 3.7m), is approximately 58’ (17.7m) in length and is constructed from 9 stretch mesh panels, with mesh sizes decreasing from 8” at the mouth opening to ½” at the cod end. The panels are made with single knot, bonded nylon thread dyed green. Bay Study uses 2 top and 2 bottom doors to keep the MWT mouth open while under tow. A Willapa marine shrimp buoy is attached to each top door to help with flotation and the bottom doors have extra weight to help them sink. All 4 doors are made from 1/8” thick steel plate.

Otter Trawl: The OT net has a 16’ (4.9m) wide headrope and weighted lead line and is 35’ (10.7m) in length. The net body is constructed from 1” stretch mesh (2.5 cm) and the coded is 3/16” delta nylon knotless mesh. A lazy line is attached to the net once the cod end is tied and consists of a red (~12-16”) buoy on a 100’ piece of nylon dock line. The otter trawl doors are made from oak wood, are approximately 30” x 15”, and weigh 28.5 pounds each.

Tow Cable: Tow cables are made from threaded 3/16” stainless steel wire aircraft cable inside of ¼” AmSteel Blue (threaded Amsteel cable). Bay Study recently switched tow cable type due to safety concerns. From January 1980 through May 2022, the tow cables were made from #316 stainless steel aircraft cable, 3/16” diameter, 7x19 strand (steel cable). To replace the steel cable, a new cable was made “in house” at the CDFW Stockton lab by threading the original steel cable inside of AmSteel Blue. This allows for the weight of the steel cable with the safety benefits of AmSteel Blue (e.g., less risk of cable snapping, getting snagged, or burrs causing injury to cable handlers). The threaded Amsteel cable was first used during survey in June 2022. Each tow cable has a 100’ bridle and at least 250’ of backing cable. The bridles are attached to the main tow cable with shackles and a large bullet-nose Miller swivel (size BB-414, 0.75 ton). The main tow cable is at minimum 250’ in length and is marked at 25’ increments. Small Miller swivels (size A-414, 0.45 ton) and shackles are attached to each trawl door on the tow cable end. The carabineers at the end of each bridle are attached to the shackles.

Flowmeter: A General Oceanics Flowmeter (model 2030R) is used to measure the volume of water sampled by the net and is deployed for the entire tow duration. For the MWT and OT, it is connected to a short cable that is attached to the end of a davit on the starboard side of the boat. For the plankton net, the flowmeter is suspended in the mouth of the net. Propeller revolutions are checked in between each survey.

Seabird CTD Meter: An electronic CTD meter from Seabird Electronics is used to collect water quality data at every station. Currently, Bay Study uses an SBE 19plusV2 model to measure conductivity, temperature, and depth. The Seabird is mounted in a stainless-steel cage to protect the unit. At the beginning of each sampling day, the Seabird is fastened to stainless steel deployment cable using a shackle, and the plastic tubing and metal switch stabilizer are removed. At the end of the day, the Seabird is rinsed with freshwater, and the plastic tubing and switch stabilizer are attached. The Seabird is calibrated by the manufacturer periodically, but not more frequently than annually.

Secchi Disk: The disk has a diameter of 20 cm, and the dorsal surface is divided into quadrants of alternating black and white color. The Secchi disk is commercially made and designed specifically for evaluating water clarity. The ventral surface has an attached lead weight (13cm diameter anode) to maintain vertical tension on the rope. The Secchi rope is marked with colored twine at 10 cm increments, from 10 to 250, with a different color twine marking the 50 cm increments (ex. 50, 100, 150 and 200 cm).

Crew Leader’s GPS: A Furuno GP-32 is mounted at the biologist’s station and is used to record start and end GPS coordinates, compass bearing and distance travelled for each tow.

Plankton Net: The plankton net was made of 505 micrometer mesh with a mouth area of 0.38 m2, and was mounted on a steel sled with the net bottom 12 cm above the skids.

3.) Analysis Methods and SOPs:

The columns TowVolume and TowArea from the “BoatTow.csv” table are calculated as follows:

Midwater Trawl: Water volume sampled (TowVolume) is calculated for the MWT and is calculated using data collected by a flowmeter towed from a davit alongside the boat. First, the difference in start and end flowmeter counts (number of propeller revolutions) is calculated. This value is then multiplied by a factory calibration factor to convert the reading into meters of water flow through the net. This is finally multiplied by the area of the net to estimate the volume of water sampled in each tow (m3):

Vt = M * K * Ft ,

where: Vt = volume of water (m3) filtered through the net per tow (t); M = mouth opening of the net (10.7 m2); K = calibration factor for the flow meter (0.02687); Ft = difference in flow meter counts from start to end of tow.

Otter Trawl: Area sampled (TowArea) is calculated for the OT and is calculated using data collected by the crew leader’s GPS unit. First, the difference in distance traveled is calculated from start coordinates when the net is set and the end coordinates when the tow duration runs out. This value is collected in nautical miles and converted to meters. This is multiplied by the area of the net opening to estimate the area sampled in each tow (m2):

At = S * Dt ,

where: At = area (m2) covered by the net per tow (t); S = distance between doors when fully spread (3.42 m); Dt = distance (m) between the start and end coordinates of the tow.

Plankton Net: Water volume sampled (TowVolume) is calculated for the plankton net and is calculated using data collected by a flowmeter towed from a davit alongside the boat. First, the difference in start and end flowmeter counts (number of propeller revolutions) is calculated. This value is then multiplied by a factory calibration factor to convert the reading into meters of flow (m). This is finally multiplied by the area of the net to estimate the volume of water sampled in each tow (m3):

Vt = M * K * Ft ,

where: Vt = volume of water (m3) filtered through the net per tow (t); M = mouth opening of the net (0.383 m2); K = calibration factor for the flow meter (0.02687); Ft = difference in flow meter counts from start to finish of tow.

4.) QA/QC Methods

Field QC: Bay Study implemented a field quality control (QC) program in March 1996 to check the accuracy and completion of field procedures, including emptying the net, removing organisms from the debris, and identifying and enumerating species. For each survey, 10% of the trawls were randomly selected for QC checks (3 OTs and 3 MWTs), with one QC for each region sampled. Samples identified for QC, were rechecked for missed organisms. All crabs and fish were re-counted by species. Lengths were not re-measure unless a length was in question.

Data QC:

Data Entry and Outliers: Immediately after each survey, station and tow data is entered into an Access database and first checked through “line-by-line”. Then, two proofs of the entered data are conducted by Environmental Scientists to evaluate queries that flag entry and calculation errors, data out of range, outliers and the agreement between net, tide, direction, and bearing, and the datasheets are also reviewed for legibility, completeness, and reasonable species ranges and lengths.

End of Year Proofing: The station and tow data and fish, crab, and jelly catch and length data are double entered at the end of year. The two entries are compared to flag entry errors and the working database is corrected. The final data are checked for measurement errors and range outliers using a full year of survey data in the evaluation. A specific set of queries are used to highlight questionable data, and these are checked against field data sheets. Details on shrimp QC protocols will be provided when the data is published.

5.) Historic Protocol Changes and Exceptions

Long-term monitoring surveys are subject to variety of influences that lead to inadvertent divergences from the establish sampling procedures defined in the methods sections above. Additionally, protocols have changed throughout the survey history. In effort to provide full transparency and facilitate the most appropriate uses of the survey data, known sampling changes and exceptions are defined in footnotes that are included in the PDF version of the metadata provided with the data.

6.) Source of Available Datasets

These tables are exported from Access and manipulated as follows.

“StationConstants.csv”

The table is a combination of station info from the Access database and an excel file with theoretical coordinates for the station location and comments about station location changes.

“SubstrateCodes.csv”

This table is directly from the Access database with no modification.

“SpeciesCodes.csv”

This table is from the fish Access database and some columns were renamed for clarity and irrelevant columns removed.

“BoatStation.csv”

This table is a combination of two tables from the Access database with station information joined with station surface, average, and bottom water quality readings. Irrelevant columns were removed.

“BoatTow.csv”

This table is from the Access fish database and manipulated to convert all coordinates to decimal degrees and calculate the water volume and area sampled, for each gear type as described above in Section 4. Irrelevant columns were removed.

“FishCatch.csv”

This table in the Access database originally stores subsampling information and plus count for each species per tow. Catch from net 3 is originally stored separately from nets 1 and 2, but combined in the published table. The total catch for each species collected from nets 1 and 2 is calculated using the subsample (if applicable) and adding the plus count to the number of fish measured stored in the “FishLength.csv” using the following equation:

Tt,s =((Mt,s + Pt,s))/((Cs + Ss) ),

where Tt,s = the total number of fish of a species caught per tow; Mt,s = the total number of fish of a species measured per tow; Pt,s = the plus count for the species; Cs = the total size of the sample caught; Ss = the proportional subsample processed for that species.

“FishLength.csv”

In the Access database, this table stored the length frequency of fish measured per species per tow. An additional column, AdjustedFreq, is calculated using the following equation:

At,s,l = (Ft,s,l/Mt,s)* Tt,s ,

where At,s,l = the adjusted length frequency of a species in the tow; Ft,s,l = the frequency of that species and length; Mt,s = the total of that species measured in the tow; Tt,s = the total number of fish of a species caught per tow. Additionally, there is an added column for Width because from 1980-1991 Bat Ray total length was measured and the measurement is in the Length column and after 1992 the protocol changed to measure Bat Ray wing width, which is stored in the Width column.

Users interested in using these base tables should be aware of the units of these recorded values. Users should also be aware that zero catches of each species per tow are not recorded in the base “FishCatch.csv” table, but the data associated with that tow is recorded in the base “BoatTow.csv” table.

7.) Sampling Frequency

Throughout survey history, there are multiple gaps in sample frequency. Refer to the metadata PDF for visuals of sampling frequency by net type and reasons for missed surveys and partial survey.

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: Kathy A Hieb
Organization:California Department of Fish and Wildlife
Position:Principal Investigator
Address:
2109 Arch Airport Road,
Stockton, California 25206 United States
Phone:
2096404642 (voice)
Email Address:
Kathy.Hieb@wildlife.ca.gov
Individual: Jillian M Burns
Organization:California Department of Fish and Wildlife
Position:Environmental Scientist
Address:
2109 Arch Airport Road,
Stockton, CA 95206 United States
Phone:
2092343429 (voice)
Email Address:
Jillian.Burns@wildlife.ca.gov
Individual: Kenji Soto
Organization:California Department of Fish and Wildlife
Address:
2109 Arch Airport Road,
Stockton, California 25206 United States
Phone:
2092343662 (voice)
Email Address:
Kenji.Soto@wildlife.ca.gov
Contacts:
Individual: Kathy A Hieb
Organization:California Department of Fish and Wildlife
Position:Primary Investigator
Email Address:
kathy.hieb@wildlife.ca.gov
Individual: Jillian M Burns
Organization:California Department of Fish and Wildlife
Position:Environmental Scientist
Email Address:
jillian.burns@wildlife.ca.gov
Individual: Kenji Soto
Organization:California Department of Fish and Wildlife
Position:Environmental Scientist
Email Address:
kenji.soto@wildlife.ca.gov
Associated Parties:
Individual: Aaron Ngo
Organization:California Department of Fish and Wildlife
Position:Senior Lab Assistant
Email Address:
aaron.ngo@wildlife.ca.gov
Role:Senior Lab Assistant

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
1980
End:
2022
Geographic Region:
Description:South of the Dumbarton Bridge in South San Francisco Bay, to just west of Alcatraz Island in Central San Francisco Bay, throughout San Pablo and Suisun bays, north to the confluence Steamboat and Cache sloughs on the Sacramento River, and east to Old River Flats on the San Joaquin River.
Bounding Coordinates:
Northern:  38.2952Southern:  37.3143
Western:  -122.6142Eastern:  -121.2289

Project

Parent Project Information:

Title:Abundance and distribution of fish and mobile crustaceans in shoals and channels of the San Francisco Estuary
Personnel:
Individual: Kathy Hieb
Organization:CDFW
Position:Principal Investigator
Email Address:
kathy.hieb@wildlife.ca.gov
Role:Principal Investigator
Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'unitList'
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microsiemensPerCentimeter'
        |     |     |     |  \___attribute 'name' = 'microsiemensPerCentimeter'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'decimal degrees'
        |     |     |     |  \___attribute 'name' = 'decimal degrees'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'corresponds with month, but not always'
        |     |     |     |  \___attribute 'name' = 'corresponds with month, but not always'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'practicalSalinityUnit'
        |     |     |     |  \___attribute 'name' = 'practicalSalinityUnit'
        |     |     |     |___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.01.24'
        |     |___text '\n      '
        |___text '\n   '

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

UNM logo UW-M logo