Data Package Metadata   View Summary

Interagency Ecological Program: Data for Synthesis for Ecological Impacts of Drought in the Upper San Francisco Estuary, 1975-2021

General Information
Data Package:
Local Identifier:edi.1653.1
Title:Interagency Ecological Program: Data for Synthesis for Ecological Impacts of Drought in the Upper San Francisco Estuary, 1975-2021
Alternate Identifier:DOI PLACE HOLDER
Abstract:

These data were collected for the special issue on Drought in the Sacramento-San Joaquin Delta published in San Francisco Estuary and Watershed Sciences, Volume 22, Issue 1, March of 2024. Multi-year droughts are important and impactful features of California’s Mediterranean climate and can fundamentally affect the water quality and the ecosystem response of the San Francisco Estuary and the Sacramento-San Joaquin Delta. This data set was assembled from data collected by long-term monitoring programs over the past 46 years (1975-2021) to evaluate how the estuary changed during multi-year droughts. Data include fish, zooplankton, jellyfish, clams, temperature, Secchi depth, and salinity as measured by fish and water quality surveys, as well as nutrients and chlorophyll measured by water quality surveys. These data are accompanied by hydrologic metrics including Delta Inflow, Delta Outflow, the position of the 2-PSU isohaline, and residence time, and daily values of various continuous water quality stations located in the Delta.

Publication Date:2024-06-03
For more information:
Visit: DOI PLACE HOLDER

Time Period
Begin:
1975
End:
2021

People and Organizations
Contact:Bosworth, David (California Department of Water Resources, Senior Environmental Scientist (Specialist)) [  email ]
Contact:Hartman, Rosemary (California Department of Water Resources, Environmental Program Manager) [  email ]
Creator:Bosworth, David (California Department of Water Resources, Senior Environmental Scientist (Specialist))
Creator:Hartman, Rosemary (California Department of Water Resources, Environmental Program Manager)
Creator:Twardochelb, Laura (California State Water Resources Control Board, Environmental Program Manager)
Creator:Wells, Elizabeth (California Department of Water Resources, Environmental Scientist)
Creator:Bashevkin, Samuel (California State Water Resources Control Board, Environmental Program Manager)
Creator:Sawyer, Evan (NOAA Fisheries)
Creator:Burdi, Christina E. (California Department of Water Resources, Senior Environmental Scientist (Specialist))
Creator:Maguire, Amanda M (California Department of Water Resources, Environmental Scientist)
Creator:Stumpner, Elizabeth B. (California Department of Water Resources, Senior Environmental Scientist (Specialist))
Creator:Barros, Arthur (California Department of Fish and Wildlife, Environmental Scientist)
Creator:Nelson, Peter (California Department of Water Resources, Senior Environmental Scientist (Specialist))
Creator:Flynn, Theodore (California Department of Water Resources, Senior Environmental Scientist (Supervisor))
Associate:Rinde, Jenna (California Department of Water Resources, assisted in data interpretation)
Associate:Bouma-Gregson, Keith (US Geological Survey, assisted in data interpretation)
Associate:Flynn, Theodore (California Department of Water Resources, assisted in data organization and interpretation)
Associate:Perry, Sarah (California Department of Water Resources, assisted in data organization and interpretation)
Associate:Keller, Elizabeth (NOAA Fisheries, assisted in data interpretation)
Associate:Salman, Tyler (California Department of Water Resources, assisted in data organization)

Data Entities
Data Table Name:
WQ_1975_2021
Description:
A data set containing raw values of three water quality parameters (water temperature, salinity, and secchi depth) for 1975-2021 within the upper San Francisco Estuary (Delta). All data are from the discretewq data package. This data set contains only one data point per Station and Date and excludes any data points that are more than 15 standard deviations away from the mean of each SubRegion.
Data Table Name:
Nutrients_1975_2021
Description:
A long-term data set containing raw values of three nutrient parameters (Dissolved Ammonia, Dissolved Nitrate + Nitrite, and Dissolved Ortho-phosphate) for 1975-2021 within the upper San Francisco Estuary (Delta). All data are from the discretewq data package. This data set contains only one data point per Station and Date and excludes any data points that have modified z-scores greater than 15 grouped by SubRegion with the exception of Dissolved Ammonia. The flagged outliers in the Dissolved Ammonia data set appeared to be accurate based upon best professional judgement.
Data Table Name:
Chlorophyll_1975_2021
Description:
A long-term data set containing raw concentration values of chlorophyll-a in water samples collected within the upper San Francisco Estuary (Delta) from 1975-2021. All data are from the discretewq data package. This data set contains only one data point per Station and Date.
Data Table Name:
Dayflow_1975_2021
Description:
A data set containing daily values of total Delta inflow and net Delta outflow for water years 1975-2021 from the Dayflow model.
Data Table Name:
velocity
Description:
Water velocity at several USGS continuous monitoring stations in the Delta
Data Table Name:
Dayflow_Residencetime
Description:
Monthly average hydrologic parameters for the Sacramento San Joaquin Delta.
Data Table Name:
Integrated_dataset
Description:
Annual averages of various ecological metrics used to quantify the effect of drought on the ecosystem.
Data Table Name:
ContWaterQualityDaily
Description:
Daily mean, min, and maximum for parameters collected at water quality sondes in the south Delta.
Data Table Name:
EMP Clam data
Description:
Biomass, density, and grazing rates of the clams Potamocorbula amurensis and Corbicula fluminea collected by the Environmental Monitoring Program (EMP).
Data Table Name:
GRTS_clams
Description:
Clam density, biomass, filtration rate, turnover rate, and sampling locations for the Department of Water Resources GRTS survey.
Data Table Name:
ClamRegressions
Description:
Length-weight regressions used to calculate clam clearance rates in Hartman, Twarduchleb, Burdi, and Wells 2024.
Data Table Name:
ClamStations
Description:
Latitude and longitude of all stations used for GRTS benthic sampling.
Data Table Name:
AllJellyfish
Description:
All jellyfish caught by the Fall Midwater Trawl, Summer Townet Survey, 20mm Survey, Suisun Marsh Survey, and Bay Study. A subset of these data were used for Hartman, Twardochleb, Burdi, and Wells, 2024.
Data Table Name:
Drought_Zooplankton
Description:
EMP zooplankton biomass per unit effort data from 1993-2021 used for Barros et al. 2024 - "Years of Drought and Salt".
Other Name:
barros et al zooplankton drought
Description:
Journal article with more information about zooplankton data.
Other Name:
bosworth et al 2024 drought
Description:
Journal article with more information about water quality analysis.
Other Name:
Hartman et al 2024 dry me a river
Description:
Journal article with more information about integrated drought dataset.
Other Name:
Hartman et al 2024 amazing graze
Description:
Journal article with more information about clam and jellyfish data.
Other Name:
boumagregson 2024 microcystis drought
Description:
Journal article with information about the continuous water quality data.
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/6adeb586468744df22408810888b40dc
Name:WQ_1975_2021
Description:A data set containing raw values of three water quality parameters (water temperature, salinity, and secchi depth) for 1975-2021 within the upper San Francisco Estuary (Delta). All data are from the discretewq data package. This data set contains only one data point per Station and Date and excludes any data points that are more than 15 standard deviations away from the mean of each SubRegion.
Number of Records:92062
Number of Columns:14

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

Table Column Descriptions
 SourceStationLatitudeLongitudeRegionSubRegionYearAdjSeasonMonthDateDatetimeTemperatureSalinitySecchi
Column Name:Source  
Station  
Latitude  
Longitude  
Region  
SubRegion  
YearAdj  
Season  
Month  
Date  
Datetime  
Temperature  
Salinity  
Secchi  
Definition:Name of the source datasetName of location where sample was collectedLatitude of Station in Decimal Degrees (WGS 84 Datum)Longitude of Station in Decimal Degrees (WGS 84 Datum)Region designation of Station within the larger Delta and Suisun BaySubregion designation of Station as defined by the R_EDSM_Subregions_Mahardja_FLOAT shapefile from the deltamapr package.Adjusted calendar year - December-November, with December of the previous calendar year included with the following year. For example, December of 2020 is assigned year "2021" in this data set.Season designation of the sampleMonth of sample collectionDate of sample collectionDate and time of sample collection in Pacific Standard Time (PST)Water temperature in Celsius measured at the surface using either YSI 6600 or YSI EXO sonde.Salinity value on the practical salinity scale, as calculated from electrical conductivity measured by a YSI. Measured at the surface.Secchi depth in centimeters
Storage Type:string  
string  
float  
float  
string  
string  
float  
string  
float  
dateTime  
dateTime  
float  
float  
float  
Measurement Type:nominalnominalratiorationominalnominalrationominalratiodateTimedateTimeratioratioratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code20mm
DefinitionCDFW - 20-mm survey
Source
Code Definition
CodeBaystudy
DefinitionCDFW - San Francisco Bay Study
Source
Code Definition
CodeDJFMP
DefinitionUSFWS - Delta Juvenile Fish Monitoring Program
Source
Code Definition
CodeEMP
DefinitionDWR - Environmental Monitoring Program
Source
Code Definition
CodeFMWT
DefinitionCDFW - Fall Midwater Trawl
Source
Code Definition
CodeNCRO
DefinitionDWR - North Central Region Office monitoring
Source
Code Definition
CodeSDO
DefinitionDWR - Stockton Dissolved Oxygen survey
Source
Code Definition
CodeSKT
DefinitionCDFW - Spring Kodiak Trawl
Source
Code Definition
CodeSTN
DefinitionCDFW - Summer Tow Net
Source
Code Definition
CodeSuisun
DefinitionUC Davis - Suisun Marsh Fish Survey
Source
Code Definition
CodeUSGS_CAWSC
DefinitionUS Geological Survey - California Water Science Center
Source
Code Definition
CodeUSGS_SFBS
DefinitionUS Geological Survey - San Francisco Bay Survey
Source
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeConfluence
DefinitionConfluence of Sacramento and San Joaquin Rivers
Source
Code Definition
CodeNorth
DefinitionNorth Delta, including Sacramento River and Cache Slough Complex
Source
Code Definition
CodeSouthCentral
DefinitionSouthern and Central Delta, including the San Joaquin River and Old/Middle River corridor
Source
Code Definition
CodeSuisun Bay
DefinitionSuisun, Grizzly, and Honker Bays
Source
Code Definition
CodeSuisun Marsh
DefinitionSuisun Marsh
Source
Definitiontext
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeWinter
DefinitionDec-Feb
Source
Code Definition
CodeSpring
DefinitionMar-May
Source
Code Definition
CodeSummer
DefinitionJun-Aug
Source
Code Definition
CodeFall
DefinitionSept-Nov
Source
Unitdimensionless
Typeinteger
FormatYYYY-MM-DD
Precision
FormatYYYY-MM-DD hh:mm:ss
Precision
Unitcelsius
Typereal
Unitdimensionless
Typereal
Unitcentimeter
Typereal
Missing Value Code:                    
CodeNA
Expltime not collected
CodeNA
Expldata not collected
CodeNA
Expldata not collected
CodeNA
Expldata not collected
Accuracy Report:                            
Accuracy Assessment:                            
Coverage:                            
Methods:                            

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/d38dd15b80ac822c73f1c8c6ef75ec94
Name:Nutrients_1975_2021
Description:A long-term data set containing raw values of three nutrient parameters (Dissolved Ammonia, Dissolved Nitrate + Nitrite, and Dissolved Ortho-phosphate) for 1975-2021 within the upper San Francisco Estuary (Delta). All data are from the discretewq data package. This data set contains only one data point per Station and Date and excludes any data points that have modified z-scores greater than 15 grouped by SubRegion with the exception of Dissolved Ammonia. The flagged outliers in the Dissolved Ammonia data set appeared to be accurate based upon best professional judgement.
Number of Records:10707
Number of Columns:17

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

Table Column Descriptions
 SourceStationLatitudeLongitudeRegionSubRegionYearAdjSeasonMonthDateDatetimeDissAmmonia_SignDissAmmoniaDissNitrateNitrite_SignDissNitrateNitriteDissOrthophos_SignDissOrthophos
Column Name:Source  
Station  
Latitude  
Longitude  
Region  
SubRegion  
YearAdj  
Season  
Month  
Date  
Datetime  
DissAmmonia_Sign  
DissAmmonia  
DissNitrateNitrite_Sign  
DissNitrateNitrite  
DissOrthophos_Sign  
DissOrthophos  
Definition:Name of the source datasetName of location where sample was collectedLatitude of Station in Decimal Degrees (WGS 84 Datum)Longitude of Station in Decimal Degrees (WGS 84 Datum)Region designation of Station within the larger Delta and Suisun BaySubregion designation of Station as defined by the R_EDSM_Subregions_Mahardja_FLOAT shapefile from the deltamapr package.Adjusted calendar year - December-November, with December of the previous calendar year included with the following year. For example, December of 2020 is assigned year "2021" in this data set.Season designation of the sampleMonth of sample collectionDate of sample collectionDate and time of sample collection in Pacific Standard Time (PST)A symbol representing whether the Dissolved Ammonia value is below or above the reporting limit or an estimated value.Dissolved Ammonia value in mg/L as NA symbol representing whether the Dissolved Nitrate + Nitrite value is below or above the reporting limit or an estimated value.Dissolved Nitrate + Nitrite value in mg/L as NA symbol representing whether the Dissolved Ortho-phosphate value is below or above the reporting limit or an estimated value.Dissolved Ortho-phosphate value in mg/L as P
Storage Type:string  
string  
float  
float  
string  
string  
float  
string  
float  
dateTime  
dateTime  
string  
float  
string  
float  
string  
float  
Measurement Type:nominalnominalratiorationominalnominalrationominalratiodateTimedateTimenominalrationominalrationominalratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeEMP
DefinitionDWR - Environmental Monitoring Program
Source
Code Definition
CodeNCRO
DefinitionDWR - North Central Region Office monitoring
Source
Code Definition
CodeUSGS_CAWSC
DefinitionUS Geological Survey - California Water Science Center
Source
Code Definition
CodeUSGS_SFBS
DefinitionUS Geological Survey - San Francisco Bay Survey
Source
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeConfluence
DefinitionConfluence of Sacramento and San Joaquin Rivers
Source
Code Definition
CodeNorth
DefinitionNorth Delta, including Sacramento River and Cache Slough Complex
Source
Code Definition
CodeSouthCentral
DefinitionSouthern and Central Delta, including the San Joaquin River and Old/Middle River corridor
Source
Code Definition
CodeSuisun Bay
DefinitionSuisun, Grizzly, and Honker Bays
Source
Definitiontext
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeWinter
DefinitionDec-Feb
Source
Code Definition
CodeSpring
DefinitionMar-May
Source
Code Definition
CodeSummer
DefinitionJun-Aug
Source
Code Definition
CodeFall
DefinitionSept-Nov
Source
Unitdimensionless
Typeinteger
FormatYYYY-MM-DD
Precision
FormatYYYY-MM-DD hh:mm:ss
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code<
DefinitionThe value is below the Reporting Limit (RL) with the value in the corresponding result variable equal to the RL.
Source
Code Definition
Code=
DefinitionThe value is above the RL with the value in the corresponding result variable equal to the actual value measured by the laboratory. An NA value in the corresponding result variable indicates that the value is missing or wasn't collected.
Source
Code Definition
Code~
DefinitionThe value in the corresponding result variable was estimated
Source
UnitmilligramPerLiter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code<
DefinitionThe value is below the Reporting Limit (RL) with the value in the corresponding result variable equal to the RL.
Source
Code Definition
Code=
DefinitionThe value is above the RL with the value in the corresponding result variable equal to the actual value measured by the laboratory. An NA value in the corresponding result variable indicates that the value is missing or wasn't collected.
Source
Code Definition
Code~
DefinitionThe value in the corresponding result variable was estimated
Source
UnitmilligramPerLiter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code<
DefinitionThe value is below the Reporting Limit (RL) with the value in the corresponding result variable equal to the RL.
Source
Code Definition
Code=
DefinitionThe value is above the RL with the value in the corresponding result variable equal to the actual value measured by the laboratory. An NA value in the corresponding result variable indicates that the value is missing or wasn't collected.
Source
Code Definition
Code~
DefinitionThe value in the corresponding result variable was estimated
Source
UnitmilligramPerLiter
Typereal
Missing Value Code:                        
CodeNA
Expldata not available
 
CodeNA
Expldata not available
 
CodeNA
Expldata not collected
Accuracy Report:                                  
Accuracy Assessment:                                  
Coverage:                                  
Methods:                                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/9dc508274ed76648a2698c3ec55c5c5f
Name:Chlorophyll_1975_2021
Description:A long-term data set containing raw concentration values of chlorophyll-a in water samples collected within the upper San Francisco Estuary (Delta) from 1975-2021. All data are from the discretewq data package. This data set contains only one data point per Station and Date.
Number of Records:21021
Number of Columns:13

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

Table Column Descriptions
 SourceStationLatitudeLongitudeRegionSubRegionYearAdjSeasonMonthDateDatetimeChlorophyll_SignChlorophyll
Column Name:Source  
Station  
Latitude  
Longitude  
Region  
SubRegion  
YearAdj  
Season  
Month  
Date  
Datetime  
Chlorophyll_Sign  
Chlorophyll  
Definition:Name of the source datasetName of location where sample was collectedLatitude of Station in Decimal Degrees (WGS 84 Datum)Longitude of Station in Decimal Degrees (WGS 84 Datum)Region designation of Station within the larger Delta and Suisun BaySubregion designation of Station as defined by the R_EDSM_Subregions_Mahardja_FLOAT shapefile from the deltamapr package.Adjusted calendar year - December-November, with December of the previous calendar year included with the following year. For example, December of 2020 is assigned year "2021" in this data set.Season designation of the sampleMonth of sample collectionDate of sample collectionDate and time of sample collection in Pacific Standard Time (PST)A symbol representing whether the chlorophyll-a value is below the reporting limit or above itChlorophyll-a concentration in micrograms per liter
Storage Type:string  
string  
float  
float  
string  
string  
float  
string  
float  
dateTime  
dateTime  
string  
float  
Measurement Type:nominalnominalratiorationominalnominalrationominalratiodateTimedateTimenominalratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeEMP
DefinitionDWR - Environmental Monitoring Program
Source
Code Definition
CodeNCRO
DefinitionDWR - North Central Region Office monitoring
Source
Code Definition
CodeUSGS_SFBS
DefinitionUS Geological Survey San Francisco Bay Survey
Source
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeConfluence
DefinitionConfluence of Sacramento and San Joaquin Rivers
Source
Code Definition
CodeNorth
DefinitionNorth Delta, including Sacramento River and Cache Slough Complex
Source
Code Definition
CodeSouthCentral
DefinitionSouthern and Central Delta, including the San Joaquin River and Old/Middle River corridor
Source
Code Definition
CodeSuisun Bay
DefinitionSuisun, Grizzly, and Honker Bays
Source
Definitiontext
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeWinter
DefinitionDec-Feb
Source
Code Definition
CodeSpring
DefinitionMar-May
Source
Code Definition
CodeSummer
DefinitionJun-Aug
Source
Code Definition
CodeFall
DefinitionSept-Nov
Source
Unitdimensionless
Typeinteger
FormatYYYY-MM-DD
Precision
FormatYYYY-MM-DD hh:mm:ss
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code<
DefinitionThe value is below the Reporting Limit (RL) with the value in Chlorophyll equal to the RL
Source
Code Definition
Code=
DefinitionThe value was detected by the laboratory with the value in Chlorophyll equal to the actual value measured by the laboratory
Source
UnitmicrogramPerLiter
Typereal
Missing Value Code:                          
Accuracy Report:                          
Accuracy Assessment:                          
Coverage:                          
Methods:                          

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/74ad6e31a00afc9199bac2aba7711834
Name:Dayflow_1975_2021
Description:A data set containing daily values of total Delta inflow and net Delta outflow for water years 1975-2021 from the Dayflow model.
Number of Records:17167
Number of Columns:4

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

Table Column Descriptions
 WaterYearDateInflowTotalOutflow
Column Name:WaterYear  
Date  
InflowTotal  
Outflow  
Definition:Water Year (October of preceding year through September)Date of flow estimateTotal Delta inflow in cubic feet per second (cfs) from the Dayflow modelNet Delta outflow in cubic feet per second (cfs) at Chipps Island from the Dayflow model
Storage Type:float  
dateTime  
float  
float  
Measurement Type:ratiodateTimeratioratio
Measurement Values Domain:
UnitnominalYear
Typeinteger
FormatYYYY-MM-DD
Precision
UnitfootCubedPerSecond
Typeinteger
UnitfootCubedPerSecond
Typeinteger
Missing Value Code:        
Accuracy Report:        
Accuracy Assessment:        
Coverage:        
Methods:        

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/ac1a453d0cdc1f19d9479ccfaa8b082c
Name:velocity
Description:Water velocity at several USGS continuous monitoring stations in the Delta
Number of Records:2774
Number of Columns:10

Table Structure
Object Name:velocity.csv
Size:285047 byte
Authentication:79a197cd2de4367aeb05122390e6a184 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
 StationWaterYearYearTypeDroughtWeekWYdayMaxAbsTidalVelTideSignMeanNetVelOutflow
Column Name:Station  
WaterYear  
YearType  
Drought  
Week  
WYday  
MaxAbsTidalVel  
TideSign  
MeanNetVel  
Outflow  
Definition:Identifier of water quality monitoring stationWater year (October of preceding year through September)Sacramento Valley Hydrologic Water Year classificationWhether the Water Year was classified as part of a drought period, wet period, or neutral period.First day of week over which velocities were summarizedDay of Water YearWeekly maximum water velocity expressed as absolute valueWhether maximum velocity was positive or negativeWeekly mean net velocity after tidal signal had been removedWeekly mean net Delta outflow from the Dayflow model
Storage Type:string  
float  
string  
string  
dateTime  
float  
float  
string  
float  
float  
Measurement Type:nominalrationominalnominaldateTimeratiorationominalratioratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCache
DefinitionCache Slough, USGS stations 11455350 and 11455385
Source
Code Definition
CodeMDM
DefinitionMiddle River, USGS station 11312676
Source
Code Definition
CodeOLD
DefinitionOld River at Bacon Island, USGS station 11313405
Source
Code Definition
CodeSJJ
DefinitionSan Joaquin River at Jersey Point, USGS station 11337190
Source
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeBelow Normal
DefinitionWater year index >6.5, < 7.8
Source
Code Definition
CodeCritical
DefinitionWater year index <5.4
Source
Code Definition
CodeDry
DefinitionWater year index >5.4, <6.5
Source
Code Definition
CodeWet
DefinitionWater year index > 9.2
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeD
DefinitionDrought - two or more Dry, Critical, or Below Normal years in a row
Source
Code Definition
CodeN
DefinitionNeutral - not part of drought or wet period
Source
FormatYYYY-MM-DD
Precision
UnitnominalDay
Typeinteger
UnitmeterPerSecond
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Codenegative
DefinitionMaximum tidal velocity occurred with water flowing inland
Source
Code Definition
Codepositive
DefinitionMaximum tidal velocity occurred with water flowing towards the ocean
Source
UnitmeterPerSecond
Typereal
UnitmeterCubedPerSecond
Typereal
Missing Value Code:                    
Accuracy Report:                    
Accuracy Assessment:                    
Coverage:                    
Methods:                    

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/520af99b1a9869c1dc002c9269a0f801
Name:Dayflow_Residencetime
Description:Monthly average hydrologic parameters for the Sacramento San Joaquin Delta.
Number of Records:625
Number of Columns:13

Table Structure
Object Name:Dayflow_Residencetime.csv
Size:68886 byte
Authentication:e20a005edf820571237da5284ffff9c1 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
 MonthYearWaterYearSACCVP_SWPdatetimeAgDiversionsSACRTSJRTIndexYr_typeDroughtSJR
Column Name:Month  
Year  
WaterYear  
SAC  
CVP_SWP  
datetime  
AgDiversions  
SACRT  
SJRT  
Index  
Yr_type  
Drought  
SJR  
Definition:Month of flow estimateCalendar yearWater year (October of preceding year through September)Monthly Average Sacramento River flow at FreeportMonthly average combined Central Valley Project and State Water Project exportsLast day of the month for the monthly averageMonthly average water diversion rate for agriculture within the DeltaMonthly average time it takes particles inserted at Freeport to exit the system, either through Martinez or export pumpsMonthly average time it takes particles inserted at Stockton to exit the system, either through Martinez or export pumpsAnnual Sacramento Valley Hydrologic Water Year Index, from: https://cdec.water.ca.gov/reportapp/javareports?name=WSIHISTSacramento Valley Hydrologic Water Year classificationWhether the year was classified as part of a drought period, wet period, or neutral period.Monthly Average San Joaquin River flow at Vernalis
Storage Type:float  
float  
float  
float  
float  
dateTime  
float  
float  
float  
float  
string  
string  
float  
Measurement Type:ratioratioratioratioratiodateTimeratioratioratiorationominalnominalratio
Measurement Values Domain:
Unitdimensionless
Typeinteger
UnitnominalYear
Typeinteger
UnitnominalYear
Typeinteger
UnitmeterCubedPerSecond
Typereal
UnitmeterCubedPerSecond
Typereal
FormatYYYY-MM-DD
Precision
UnitmeterCubedPerSecond
Typereal
Unitdays
Typereal
Unitdays
Typereal
Unitdimensionless
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeAbove Normal
DefinitionWater Year index > 7.8, < 9.2
Source
Code Definition
CodeBelow Normal
DefinitionWater year index >6.5, <7.8
Source
Code Definition
CodeCritical
DefinitionWater year index < 5.4
Source
Code Definition
CodeDry
DefinitionWater year index >5.4, <6.5
Source
Code Definition
CodeWet
DefinitionWater year index > 9.2
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeD
DefinitionDrought - two or more Dry, Critical, or Below Normal years in a row
Source
Code Definition
CodeN
DefinitionNeutral - not part of drought or wet period
Source
Code Definition
CodeW
DefinitionWet - two or more Wet or Above Normal years in a row
Source
UnitmeterCubedPerSecond
Typereal
Missing Value Code:      
CodeNA
Expldata not available
 
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
   
CodeNA
Expldata not available
Accuracy Report:                          
Accuracy Assessment:                          
Coverage:                          
Methods:                          

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/73232591ce307a75a1678c7fa5b28524
Name:Integrated_dataset
Description:Annual averages of various ecological metrics used to quantify the effect of drought on the ecosystem.
Number of Records:53
Number of Columns:31

Table Structure
Object Name:Integrated_dataset.csv
Size:16883 byte
Authentication:95f08656338fd6b6e3b2c9aa1680068d 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
 WaterYearIndexYr_typeDroughtDroughtYearlogDSlogShadlogSBlogLFSlogTFSConfluence_logChlNorth_logChlSouthCentral_logChlSuisun Bay_logChlConfluence_logZoopBPUESouthCentral_logZoopBPUESuisun Bay_logZoopBPUESuisun Marsh_logZoopBPUESACRTSJRTExportOutflowX2logNatlogAmlogPhosSalinitySecchiTemperatureCV_SR_CRRCV_FR_CRR
Column Name:WaterYear  
Index  
Yr_type  
Drought  
DroughtYear  
logDS  
logShad  
logSB  
logLFS  
logTFS  
Confluence_logChl  
North_logChl  
SouthCentral_logChl  
Suisun Bay_logChl  
Confluence_logZoopBPUE  
SouthCentral_logZoopBPUE  
Suisun Bay_logZoopBPUE  
Suisun Marsh_logZoopBPUE  
SACRT  
SJRT  
Export  
Outflow  
X2  
logNat  
logAm  
logPhos  
Salinity  
Secchi  
Temperature  
CV_SR_CRR  
CV_FR_CRR  
Definition:Adjusted water year - December-November, with December of the previous calendar year included with the following year.Annual Sacramento Valley Hydrologic Water Year Index, from: https://cdec.water.ca.gov/reportapp/javareports?name=WSIHISTSacramento Valley Hydrologic Water Year classificationWhether the year was classified as part of a drought period, wet period, or neutral period.Whether it is the first/only dry year, second year of drought, or three or more years of droughtNatural-Log-transformed Fall Midwater Trawl index for Delta SmeltNatural-Log-transformed Fall Midwater Trawl index for American ShadNatural-Log-transformed Fall Midwater Trawl index for age-1 Striped BassNatural-Log-transformed Fall Midwater Trawl index for Longfin SmeltNatural-Log-transformed Fall Midwater Trawl index for Threadfin ShadAnnual average natural-log-transformed concentration of chlorophyll-a in the Confluence regionAnnual average natural-log-transformed concentration of chlorophyll-a in the North regionAnnual average natural-log-transformed concentration of chlorophyll-a in the SouthCentral regionAnnual average natural-log-transformed concentration of chlorophyll-a in the Suisun regionAnnual average natural-log-transformed biomass per cubic meter of zooplankton in the Confluence regionAnnual average natural-log-transformed biomass per cubic meter of zooplankton in the SouthCentral regionAnnual average natural-log-transformed biomass per cubic meter of zooplankton in the Suisun Bay regionAnnual average natural-log-transformed biomass per cubic meter of zooplankton in the Suisun Marsh regionAnnual average number of days it takes particles inserted at Freeport to exit the system, either through Martinez or export pumpsAnnual average number of days it takes particles inserted at Stockton to exit the system, either through Martinez or export pumpsAnnual average combined Central Valley Project and State Water Project ExportsAnnual average net Delta Outflow, as calculated by DayflowAnnual average distance from the Golden Gate to the point where the bottom salinity is 2 PSUAnnual average natural-log-transformed concentration of Dissolved Nitrate + Nitrite in mg/L as NAnnual average natural-log-transformed concentration of Dissolved Ammonia in mg/L as NAnnual average natural-log-transformed concentration of Dissolved Ortho-phosphate in mg/L as PAnnual Average salinity on the practical salinity scale measured at the surfaceAnnual Average secchi depth in centimetersAnnual Average water temperature in Celsius measured at the surfaceSpring-run Chinook salmon cohort replacement rate, which is the number of spawners returning per spawner.Fall-run Chinook salmon cohort replacement rate, which is the number of spawners returning per spawner.
Storage Type:float  
float  
string  
string  
string  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
float  
Measurement Type:ratiorationominalnominalnominalratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratioratio
Measurement Values Domain:
UnitnominalYear
Typeinteger
Unitdimensionless
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeAbove Normal
DefinitionWater year index >7.8, <9.2
Source
Code Definition
CodeBelow Normal
DefinitionWater year index >6.5, < 7.8
Source
Code Definition
CodeCritical
DefinitionWater year index <5.4
Source
Code Definition
CodeDry
DefinitionWater year index >5.4, <6.5
Source
Code Definition
CodeWet
DefinitionWater year index > 9.2
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeD
DefinitionDrought - two or more Dry, Critical, or Below Normal years in a row
Source
Code Definition
CodeN
DefinitionNeutral - not part of drought or wet period
Source
Code Definition
CodeW
DefinitionWet - two or more Wet or Above Normal years in a row
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code0
DefinitionWet or Above Normal year
Source
Code Definition
Code1
DefinitionFirst or only Dry, Critical, or Below Normal year
Source
Code Definition
Code2
DefinitionSecond drought year
Source
Code Definition
Code3+
DefinitionThird or more drought year
Source
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Unitdimensionless
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmilligramPerMeterCubed
Typereal
UnitmilligramPerMeterCubed
Typereal
UnitmilligramPerMeterCubed
Typereal
UnitmilligramPerMeterCubed
Typereal
Unitdays
Typereal
Unitdays
Typereal
UnitfootCubedPerSecond
Typereal
UnitfootCubedPerSecond
Typereal
Unitkilometer
Typereal
UnitmilligramPerLiter
Typereal
UnitmilligramPerLiter
Typereal
UnitmilligramPerLiter
Typereal
Unitdimensionless
Typereal
Unitcentimeter
Typereal
Unitcelsius
Typereal
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Missing Value Code:          
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
Accuracy Report:                                                              
Accuracy Assessment:                                                              
Coverage:                                                              
Methods:                                                              

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/702380584ed003317903740338af3c0d
Name:ContWaterQualityDaily
Description:Daily mean, min, and maximum for parameters collected at water quality sondes in the south Delta.
Number of Records:72872
Number of Columns:10

Table Structure
Object Name:ContWaterQualityDaily.csv
Size:5520882 byte
Authentication:cdc03ee4d775f6c279284e0aa23e1cc7 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
 SiteDateAnalyteUnitDaily.MeanDaily.MaxDaily.MinYearDayOfYearMonth
Column Name:Site  
Date  
Analyte  
Unit  
Daily.Mean  
Daily.Max  
Daily.Min  
Year  
Julian  
Month  
Definition:Three-letter abbreviation for water quality station in the Delta.Date of sample collectionWater quality parameterReported unit for the water quality parameterDaily mean value of the water quality parameterDaily maximum value of the water quality parameterDaily minimum value of the water quality parameterCalendar yearDay of year of sample collectionMonth of sample collection
Storage Type:string  
dateTime  
string  
string  
float  
float  
float  
float  
float  
string  
Measurement Type:nominaldateTimenominalnominalratioratioratioratiorationominal
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeFAL
DefinitionFALSE RIVER NEAR OAKLEY: -121.666900, 38.055800
Source
Code Definition
CodeFRK
DefinitionFRANK'S TRACT MID TRACT: -121.598100, 38.046417
Source
Code Definition
CodeHLT
DefinitionMIDDLE RIVER NEAR HOLT: -121.510800, 38.003100
Source
Code Definition
CodeHOL
DefinitionHOLLAND CUT NEAR BETHEL ISLAND: -121.581900, 38.016400
Source
Code Definition
CodeMDM
DefinitionMIDDLE RIVER AT MIDDLE RIVER: -121.534000, 37.943000
Source
Code Definition
CodeORQ
DefinitionOLD RIVER AT QUIMBLY IS NEAR BETHEL IS: -121.564500, 38.027200
Source
Code Definition
CodeOSJ
DefinitionOLD RIVER AT FRANKS TRACT NEAR TERMINOUS: -121.578900, 38.071100
Source
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeChl.a
DefinitionChlorophyll-a florescence
Source
Code Definition
CodeDO.Conc
DefinitionDissolved Oxygen Concentration
Source
Code Definition
CodepH
DefinitionpH
Source
Code Definition
CodeSpCond
DefinitionSpecific Conductance
Source
Code Definition
CodeTemp
DefinitionWater temperature
Source
Code Definition
CodeTurb
DefinitionTurbidity
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDegrees C
Definitiondegrees celcius
Source
Code Definition
CodeDimentionless
Definitionno units used for pH
Source
Code Definition
CodeFNU
DefinitionFormazin Nephelometric Unit
Source
Code Definition
Codemg/L
DefinitionMilligram per Liter
Source
Code Definition
CodemicroSiemens per cm
Definitionmicro siemens per centimeter
Source
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Unitdimensionless
Typereal
UnitnominalYear
Typeinteger
UnitnominalDay
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeJan
DefinitionJanuary
Source
Code Definition
CodeFeb
DefinitionFebuary
Source
Code Definition
CodeMar
DefinitionMarch
Source
Code Definition
CodeApr
DefinitionApril
Source
Code Definition
CodeMay
DefinitionMay
Source
Code Definition
CodeJun
DefinitionJune
Source
Code Definition
CodeJul
DefinitionJuly
Source
Code Definition
CodeAug
DefinitionAugust
Source
Code Definition
CodeSep
DefinitionSeptember
Source
Code Definition
CodeOct
DefinitionOctober
Source
Code Definition
CodeNov
DefinitionNovember
Source
Code Definition
CodeDec
DefinitionDecember
Source
Missing Value Code:      
CodeNA
ExplNo units needed for pH
           
Accuracy Report:                    
Accuracy Assessment:                    
Coverage:                    
Methods:                    

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/407336fbf9a2005780935acc5f223e34
Name:EMP Clam data
Description:Biomass, density, and grazing rates of the clams Potamocorbula amurensis and Corbicula fluminea collected by the Environmental Monitoring Program (EMP).
Number of Records:4959
Number of Columns:11

Table Structure
Object Name:clams.csv
Size:302754 byte
Authentication:7e1e116fa97f1db5acd3408147c18c8a 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
 DateStationLatitudeLongitudeClam _DensityBiomassTurnover_RateFiltration_RateAverage_lengthRecruitsClam
Column Name:Date  
Station  
Latitude  
Longitude  
ClamDensity  
Biomass  
Turnover_Rate  
Filtration_Rate  
Average_length  
Recruits  
Clam  
Definition:Date of sample collectionStation where sample was collectedLatitude of Station in Decimal Degrees (WGS 84 Datum)Longitude of Station in Decimal Degrees (WGS 84 Datum)Number of individuals per meter squaredAsh free dry weight of clam tissue (not shell)Defined as the velocity of particles to the bottom, turnover rate measures how quickly clams can consume particles from the water column. Turnover rate estimates were calculated by the USGS using the standard techniques described in Thompson and others (2008). Confidence of data is at two decimal places.The volume of water a bivalve can pump through its system per day. Filtration rate estimates were calculated by the USGS using the standard techniques described in Thompson and others (2008). Confidence of data is at two decimal places.Average length of clams in sample in millimetersNumber of young-of-the-year clams in sampleSpecies of clam
Storage Type:dateTime  
string  
float  
float  
float  
float  
float  
float  
float  
float  
string  
Measurement Type:dateTimenominalratioratioratioratioratioratioratiorationominal
Measurement Values Domain:
FormatYYYY-MM-DD
Precision
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
UnitnumberPerMeterSquared
Typereal
UnitmilligramPerMeterSquared
Typereal
UnitmeterCubedPerMeterSquaredPerDay
Typereal
UnitmeterCubedPerMeterSquaredPerDay
Typereal
Unitmillimeter
Typereal
Unitnumber
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCF
DefinitionCorbicula fluminea
Source
Code Definition
CodePA
DefinitionPotamocorbula amurensis
Source
Missing Value Code:        
CodeNA
Explno catch
CodeNA
Explno catch
CodeNA
Explno clams present
CodeNA
Explno catch
CodeNA
Explno catch
CodeNA
Explno catch
 
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/8a1292d209f5ed2a7f1de1f140b0b837
Name:GRTS_clams
Description:Clam density, biomass, filtration rate, turnover rate, and sampling locations for the Department of Water Resources GRTS survey.
Number of Records:6950
Number of Columns:14

Table Structure
Object Name:GRTS_clams.csv
Size:585213 byte
Authentication:37c222363808582384f0f44313e5ac51 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
 SiteIDYearMonthLatitudeLongitudeStrataPanelLocationDepthClamDensityBiomassTurnover_RateRecruitsClam
Column Name:SiteID  
Year  
Month  
Latitude  
Longitude  
Strata  
Panel  
Location  
Depth  
ClamDensity  
Biomass  
Turnover_Rate  
Recruits  
Clam  
Definition:Designation of randomly-selected siteCalendar yearMonth of sample collectionLatitude of site in Decimal Degrees (WGS 84 Datum)Longitude of site in Decimal Degrees (WGS 84 Datum)Type of site used for stratifying random samplingWhether the station was sampled every year or randomly selected for the given year.Description of sampling locationWater depth in meters at siteNumber of individuals per meter squaredAsh free dry weight of clams per meter squaredDefined as the velocity of particles to the bottom, grazing rate measures how quickly clams can consume particles from the water column. Grazing rate estimates were calculated by the USGS using the standard techniques described in Thompson and others (2008). Confidence of data is at two decimal places.Number of young-of-year clams less than 2.5 mm in lengthSpecies of clam
Storage Type:string  
float  
string  
float  
float  
string  
string  
string  
float  
float  
float  
float  
float  
string  
Measurement Type:nominalrationominalratiorationominalnominalnominalratioratioratioratiorationominal
Measurement Values Domain:
Definitiontext
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeMay
DefinitionMay
Source
Code Definition
CodeOct
DefinitionOctober
Source
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeBay
DefinitionOpen water bay
Source
Code Definition
CodeBay-large
DefinitionLarge open water bay
Source
Code Definition
CodeLake
DefinitionTidal lake formed by flooded island
Source
Code Definition
CodeRiver
DefinitionRiver
Source
Code Definition
CodeRiver-large
DefinitionLarge River
Source
Code Definition
CodeSlough
DefinitionSmall distributary channel
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeAnnual
DefinitionSampled every year
Source
Code Definition
CodeGRTS
DefinitionRandomly selected site sampled once
Source
Definitiontext
Unitmeter
Typereal
UnitnumberPerMeterSquared
Typeinteger
UnitmilligramPerMeterSquared
Typereal
UnitmeterCubedPerMeterSquaredPerDay
Typereal
Unitnumber
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCF
DefinitionCorbicula fluminea
Source
Code Definition
CodePA
DefinitionPotamocorbula amurensis
Source
Missing Value Code:                
CodeNA
Expldata not collected
         
Accuracy Report:                            
Accuracy Assessment:                            
Coverage:                            
Methods:                            

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/0f11bd41ec1b41be92e502a9fa47209e
Name:ClamRegressions
Description:Length-weight regressions used to calculate clam clearance rates in Hartman, Twarduchleb, Burdi, and Wells 2024.
Number of Records:2762
Number of Columns:9

Table Structure
Object Name:ClamRegressions.csv
Size:184089 byte
Authentication:457846ed84dfd8720de1706fbbe4e3f3 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
 YearMonthReferenceStationSpeciesNumber_of_clamsslopeInterceptRsquaredStation
Column Name:Year  
Month  
ReferenceStation  
Species  
Number_of_clams  
slope  
Intercept  
Rsquared  
Station  
Definition:Calendar yearMonth of sample collectionStation where samples were used to calculate the regression used on neighboring stationsSpecies of clamNumber of clams in sample used to calculate regressionSlope of linear regressionIntercept of length-weight regression equation - Log-transformed ash free dry weight, in gramsGoodness of fit of the regression equationStation where regression was applied
Storage Type:float  
string  
string  
string  
float  
float  
float  
float  
string  
Measurement Type:rationominalnominalnominalratioratioratiorationominal
Measurement Values Domain:
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code10
DefinitionOctober
Source
Code Definition
Code5
DefinitionMay
Source
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCorbicula
DefinitionCorbicula fluminea
Source
Code Definition
CodePotamocorbula
DefinitionPotamocorbula amurensis
Source
Unitnumber
Typeinteger
UnitgramsPerMillimeter
Typereal
Unitgram
Typereal
Unitdimensionless
Typereal
Definitiontext
Missing Value Code:                  
Accuracy Report:                  
Accuracy Assessment:                  
Coverage:                  
Methods:                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/6abd1a1350dd566c09920535ae37460a
Name:ClamStations
Description:Latitude and longitude of all stations used for GRTS benthic sampling.
Number of Records:1237
Number of Columns:8

Table Structure
Object Name:ClamStations.csv
Size:75834 byte
Authentication:1be2dbfa476664e0181a96e5ba524c9e 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
 PanelStationLocationLatitude_GPSLongitude_GPSPeriod_of_record_startPeriod_of_record_endComments
Column Name:Panel  
Station  
Location  
Latitude_GPS  
Longitude_GPS  
Period_of_record_start  
Period_of_record_end  
Comments  
Definition:Whether station was sampled as part of the monthly EMP survey or the twice-per-year GRTS survey.Designation of stationDescription of geographic areaLatitude of Station in Decimal Degrees (WGS 84 Datum)Longitude of Station in Decimal Degrees (WGS 84 Datum)First year sampling occurredLast year sampling occuredChanges made to sampling
Storage Type:string  
string  
string  
float  
float  
float  
float  
string  
Measurement Type:nominalnominalnominalratioratioratiorationominal
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeGRTS
DefinitionStation randomly selected, sampled in May or October.
Source
Code Definition
CodeMonthly
DefinitionFixed station, sampled monthly as part of EMP's regular sampling.
Source
Definitiontext
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
UnitnominalYear
Typeinteger
UnitnominalYear
Typeinteger
Definitiontext
Missing Value Code:                
Accuracy Report:                
Accuracy Assessment:                
Coverage:                
Methods:                

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/a3788ca6f42faf7d674a3234c6b8b8d6
Name:AllJellyfish
Description:All jellyfish caught by the Fall Midwater Trawl, Summer Townet Survey, 20mm Survey, Suisun Marsh Survey, and Bay Study. A subset of these data were used for Hartman, Twardochleb, Burdi, and Wells, 2024.
Number of Records:169957
Number of Columns:23

Table Structure
Object Name:AllJellyfish.csv
Size:28437048 byte
Authentication:789a2ad4fe3e09f37baeed972b673e04 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
 StationIDSourceRegionSampleDateMonthLatitudeLongitudeVolumeYearCPUEOrganismCodeSurveySal_surfTempSecchiTowNumberConductivityTopTurbidityTopSeasonWaterYearIndexYr_typeDrought
Column Name:StationID  
Source  
Region  
SampleDate  
Month  
Latitude  
Longitude  
Volume  
Year  
CPUE  
OrganismCode  
Survey  
Sal_surf  
Temp  
Secchi  
TowNumber  
ConductivityTop  
TurbidityTop  
Season  
WaterYear  
Index  
Yr_type  
Drought  
Definition:Name of station where sample was collectedMonitoring program collecting the dataRegion of the estuary used for analysisDate of sample collection. For Bay Study, exact date was not avaialble so all were standardized to the first day of the month.Month of Calendar YearLatitude at start of trawl in decimal degrees, WGS 84Logitude at start of trawl in decimal degrees, WGS 84Volume of water sampled as measured with a flowmeterCalendar yearCatch per unit effort in number of organisms per 10000 cubic metersName of organismNumber of the survey for the year, usually corresponding to monthSurface salinity as measured with a YSI sondeWater temperatureSecchi depthNumber of tow taken at the station - usually three tows per station for Summer Townet and 20mmSurface specific conductanceTurbidity in NTU measured with a Hach turbidimeterSeason of yearWater Year (Oct-Sept)Annual Sacramento Valley Hydrologic water year indexWater Year Type based on the Sacramento Valley IndexWhether the water year is classified as a drought, neutral, or wet period
Storage Type:string  
string  
string  
dateTime  
float  
float  
float  
float  
float  
float  
string  
float  
float  
float  
float  
string  
float  
float  
string  
float  
float  
string  
string  
Measurement Type:nominalnominalnominaldateTimeratioratioratioratioratiorationominalratioratioratiorationominalratiorationominalratiorationominalnominal
Measurement Values Domain:
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code20mm
DefinitionCDFW's 20mm Survey
Source
Code Definition
CodeBay Study
DefinitionCDFW's San Francisco Bay Study
Source
Code Definition
CodeFMWT
DefinitionCDFW's Fall Midwater Trawl
Source
Code Definition
CodeSTN
DefinitionCDFW's Summer Townet Survey
Source
Code Definition
CodeSuisun
DefinitionUC Davis Suisun Marsh Fish Survey
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeConfluence
DefinitionRegion at the confluence of the Sacramento and San Joaquin Rives
Source
Code Definition
CodeNorth
DefinitionSacramento River and Cache Slough Complex
Source
Code Definition
CodeSouthCentral
DefinitionSouth and Central Delta, Old and Middle Rivers
Source
Code Definition
CodeSuisun Bay
DefinitionSuisun Bay, Honker Bay, and Grizzly Bay
Source
Code Definition
CodeSuisun Marsh
DefinitionSuisun Marsh.
Source
FormatYYYY-MM-DD
Precision
Unitdimensionless
Typeinteger
Unitdegree
Typereal
Unitdegree
Typereal
UnitmeterCubed
Typereal
UnitnominalYear
Typeinteger
UnitNumberPer10000CubicMeters
Typereal
Definitiontext
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Unitcelsius
Typereal
Unitcentimeter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
DefinitionFirst tow
Source
Code Definition
Code2
Definitionsecond tow
Source
Code Definition
Code3
Definitionthird tow
Source
Unitmicrosiemenspercentimeter
Typereal
UnitNTU
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeFall
DefinitionSeptember through November
Source
Code Definition
CodeSpring
DefinitionMarch through May
Source
Code Definition
CodeSummer
DefinitionJune through August
Source
Code Definition
CodeWinter
DefinitionDecember through February
Source
UnitnominalYear
Typeinteger
Unitdimensionless
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeAbove Normal
DefinitionWater year index >7.8, <9.2
Source
Code Definition
CodeBelow Normal
DefinitionWater year index >6.5, < 7.8
Source
Code Definition
CodeCritical
DefinitionWater year index <5.4
Source
Code Definition
CodeDry
DefinitionWater year index >5.4, <6.5
Source
Code Definition
CodeWet
DefinitionWater year index > 9.2
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeD
DefinitionDrought, Two or more dry, critical, or below normal years in a row
Source
Code Definition
CodeN
DefinitionNeutral, Not part of a drought or wet period.
Source
Code Definition
CodeW
DefinitionWet period, two or more wet or above normal years in a row.
Source
Missing Value Code:    
CodeNA
ExplData collected outside regions used for drought analysis
       
CodeNA
Expldata not available
     
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
Expldata not available
CodeNA
ExplNot applicable
CodeNA
Expldata not available
CodeNA
Expldata not available
         
Accuracy Report:                                              
Accuracy Assessment:                                              
Coverage:                                              
Methods:                                              

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/c336550c72bfb6f87f027fa021f01102
Name:Drought_Zooplankton
Description:EMP zooplankton biomass per unit effort data from 1993-2021 used for Barros et al. 2024 - "Years of Drought and Salt".
Number of Records:28224
Number of Columns:12

Table Structure
Object Name:Drought_Zooplankton.csv
Size:2947344 byte
Authentication:2f73c87ee1e5194134a40b69d372c29b 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
 DateStationLatitudeLongitudeMonthYearsecchiTempSpCTaxlifestageBPUEWaterYear
Column Name:Date  
Station  
Latitude  
Longitude  
Month  
Year  
secchi  
Temp  
SpC  
Taxlifestage  
BPUE  
WaterYear  
Definition:Date of sample collectionStation designation from the Environmental Monitoring ProgramLatitude at start of trawl in decimal degrees, WGS 84Logitude at start of trawl in decimal degrees, WGS 84Month of calendar yearCalendar yearSecchi depthWater temperature in Celsius measured at the surfaceSpecific Conductance measured at the surfaceSpecies and life stageBiomass per unit volume sampledWater year (October of preceding year through September)
Storage Type:dateTime  
string  
float  
float  
float  
float  
float  
float  
float  
string  
float  
float  
Measurement Type:dateTimenominalratioratioratioratioratioratiorationominalratioratio
Measurement Values Domain:
FormatYYYY-MM-DD
Precision
Definitiontext
Unitdegree
Typereal
UnitnominalYear
Typeinteger
Unitdimensionless
Typeinteger
UnitnominalYear
Typeinteger
Unitcentimeter
Typereal
Unitcelsius
Typereal
Unitmicrosiemenspercentimeter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDaphnia Adult
DefinitionDaphnia Adult
Source
Code Definition
CodeHyperacanthomysis longirostris Adult
DefinitionHyperacanthomysis longirostris Adult
Source
Code Definition
CodeLimnoithona tetraspina Adult
DefinitionLimnoithona tetraspina Adult
Source
Code Definition
CodePseudodiaptomus forbesi Adult
DefinitionPseudodiaptomus forbesi Adult
Source
UnitmilligramPerMeterCubed
Typereal
UnitnominalYear
Typereal
Missing Value Code:    
CodeNA
ExplNot available
CodeNA
ExplNot available
   
CodeNA
ExplNot available
CodeNA
ExplNot available
CodeNA
ExplNot available
     
Accuracy Report:                        
Accuracy Assessment:                        
Coverage:                        
Methods:                        

Non-Categorized Data Resource

Name:barros et al zooplankton drought
Entity Type:application/pdf
Description:Journal article with more information about zooplankton data.
Physical Structure Description:
Object Name:barros et al zooplankton drought.pdf
Size:5361983 byte
Authentication:72ecf13b22e8533f25baf43f8fda7fe1 Calculated By MD5
Externally Defined Format:
Format Name:application/pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/e1348c7530bb66756687e57ff574db07

Non-Categorized Data Resource

Name:bosworth et al 2024 drought
Entity Type:application/pdf
Description:Journal article with more information about water quality analysis.
Physical Structure Description:
Object Name:bosworth et al 2024 drought.pdf
Size:11635190 byte
Authentication:8ff5af4ec12a95b07b62f87e2907e6e1 Calculated By MD5
Externally Defined Format:
Format Name:application/pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/5ce4ac23563b94cfd50aae5e9bb5f604

Non-Categorized Data Resource

Name:Hartman et al 2024 dry me a river
Entity Type:application/pdf
Description:Journal article with more information about integrated drought dataset.
Physical Structure Description:
Object Name:Hartman et al 2024 dry me a river.pdf
Size:7664492 byte
Authentication:a76e6bd44725bfdc135ddd945b516767 Calculated By MD5
Externally Defined Format:
Format Name:application/pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/c629de6392c449f746d4da1f27167cde

Non-Categorized Data Resource

Name:Hartman et al 2024 amazing graze
Entity Type:application/pdf
Description:Journal article with more information about clam and jellyfish data.
Physical Structure Description:
Object Name:Hartman et al 2024 amazing graze.pdf
Size:4782015 byte
Authentication:c8d278174f5ac39bd7505b542885dbf2 Calculated By MD5
Externally Defined Format:
Format Name:application/pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/31cc44d4bb8aa1d0b0711b61b1d5decc

Non-Categorized Data Resource

Name:boumagregson 2024 microcystis drought
Entity Type:application/pdf
Description:Journal article with information about the continuous water quality data.
Physical Structure Description:
Object Name:boumagregson 2024 microcystis drought.pdf
Size:7677445 byte
Authentication:97c48e9b7ec48fa95806dc4a99ed8ab8 Calculated By MD5
Externally Defined Format:
Format Name:application/pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1653/1/0c40d6c7ce886d238a761e660ad96b32

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)Interagency Ecological Program, IEP
LTER Controlled Vocabularydroughts, nutrients, chlorophyll, hydrology, temperature, estuaries

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:

Hydrology Data

We acquired hydrology (Delta inflow, Delta outflow, and water velocity) data from two sources. Delta inflow and outflow data from 1975-2021 are from the Dayflow model developed by the California Department of Water Resources (DWR) (CDWR 2022b). This model uses measured instantaneous flow and export data from stations throughout the Delta to calculate daily average Delta inflow and uses assumptions about within-Delta use to calculate a daily average net Delta Outflow index. Water velocity data collected from 2007-2021 at five stations in the Delta were obtained from the United States Geological Survey (USGS) National Water Information System using the dataRetrieval R package (De Cicco et al. 2022). The five water velocity stations operated by the USGS and used in this study are: Cache Slough at Ryer Island (11455350), Cache Slough above Ryer Island Ferry near Rio Vista CA (11455385), San Joaquin River at Jersey Point CA (11337190), Middle River at Middle River CA (11312676), and Old River at Bacon Island CA (11313405). The Cache Slough at Ryer Island station was discontinued in April 2019 and was replaced by the Ryer Island near Ryer Island Ferry station. Data for these two stations located on Cache Slough were combined to represent Cache Slough above its confluence with the Sacramento River.

The instantaneous water velocity data, collected at 15-minute intervals, were processed through a low-pass filter to remove tidal-period variation and calculate net velocity (Godin 1972). Before applying the filter, we imputed values for gaps up to 2 hours in the instantaneous data using linear interpolation with the 'imputeTS' R package (Moritz and Bartz-Beielstein 2017). The difference of the instantaneous velocity and net velocity resulted in the tidal velocity. We aggregated the net velocity data into weekly means, whereas tidal velocity was grouped into weekly minimum, maximum, and maximum absolute values.

Data Source
Dayflow Model
Data Source
National Water Information System
Description:

Water Quality, Nutrient, and Chlorophyll Data

We acquired the water quality (water temperature, salinity, and Secchi depth), nutrient (dissolved ammonium, dissolved nitrate + nitrite, and dissolved ortho-phosphate), and chlorophyll-a (or chlorophyll) data from the IEP integrated discrete water quality dataset available on EDI (Bashevkin et al. 2023). This dataset contains water quality, nutrient, and chlorophyll data collected by 16 long-term monitoring surveys that sample approximately monthly at locations throughout the estuary. We obtained data collected by 12 surveys that have at least 20 years of data between 1975-2021 within our study area in the estuary. All water temperature and salinity measurements were typically collected at a depth of one meter, and the nutrient and chlorophyll samples were collected at various depths less than five meters from the surface. For more information on data collection methods, refer to the integrated discrete water data publication on the Environmental Data Initiative repository (Bashevkin et al. 2022b).

Since some surveys collected more than one sample per day at a station, we filtered the water quality, nutrient, and chlorophyll samples keeping only one sample per station and day to ensure each sample had equal weight. Data were additionally restricted spatially and temporally by only including subregions that contained data for at least 35 of the 46 years (75%) between 1975-2021 for all four seasons. We used the deltamapr R package (Bashevkin 2021) to divide data into 34 subregions, and seasons were defined as follows: winter (December of the previous year, and January-February), spring (March-May), summer (June-August), and fall (September-November). The 34 Delta subregions were categorized into one of five broader regions including North, Confluence, South-Central, Suisun Marsh, and Suisun Bay. The Suisun Marsh region was excluded from the nutrient and chlorophyll analyses because of inconsistent long-term sampling.

A few anomalous water quality and nutrient values were removed before analysis. We removed values if they had a Z-score or modified Z-score greater than 15, grouped by each subregion for the water quality and nutrient parameters, respectively. Using the modified Z-score was more appropriate for the nutrient data set since it contains some values below the reporting limit (RL) for the laboratory method and the modified Z-score is more robust to this type of data since it is based on medians. No dissolved ammonium or chlorophyll values with modified Z-scores greater than 15 were removed as we determined they were within their expected ranges. Additionally, we excluded nutrient values that were below the RL with relatively high RL values defined as greater than the 75th percentile of the data set.

The laboratory RLs for the nutrient parameters were not always provided by the data sources. Therefore, we needed to impute RL values when the result was reported less than the RL and its RL was unknown. For the EMP data, we used the most common historical RL value for all three nutrient parameters, 0.01 mg/L, for the records without reporting limits. In the SFBWQS data set, values below the RL were not explicitly documented; however, through personal communication with USGS investigators, we confirmed that if at least one of the three nutrient parameters had a value reported for a station and day, we could assume that the other parameters were sampled but below the RL (Erica Nejad, USGS, Dec. 16, 2021). We used 0.0007 mg/L, 0.0007 mg/L, and 0.0015 mg/L as the reporting limits for dissolved ammonium, dissolved nitrate nitrite, and dissolved ortho-phosphate, respectively, for the SFBWQS data (Erica Nejad, USGS, personal comm.).

To prepare the discrete water quality, nutrient, and chlorophyll data for analysis, we aggregated the data set for each parameter as seasonal-regional averages. To aggregate the data, we calculated monthly averages for each region, which we then used to calculate seasonal-regional averages for each year. We used an adjusted water year, December through November with the December of the previous calendar year included with the following year, to allow the entire “fall” season to be included in the same water year. Before aggregating the nutrient and chlorophyll data, we substituted the values below the laboratory reporting limit (RL) with simulated values between zero and the RL based on a uniform distribution. We ran one simulation for each parameter and set a seed prior to running the simulation to ensure reproducibility. Overall, 7% of the ammonium, 1% of the nitrate + nitrite, 0.7% of the ortho-phosphate, and 0.2% of the chlorophyll values were below the RL and required replacement with simulated values. R code used for the preparation of the data can be found in the WQ-LT-Publication GitHub repository archived on Zenodo (Bosworth et al. 2024).

Data Source
Six decades (1959-2022) of water quality in the upper San Francisco Estuary: an integrated database of 16 discrete monitoring surveys in the Sacramento San Joaquin Delta, Suisun Bay, Suisun Marsh, and San Francisco Bay
Description:

These methods were used to create the 'clams.csv' and 'GRTS_clams.csv' data.

Clams

Clams were sampled by two different surveys, both conducted by the California Department of Water Resources (CDWR). The first survey is the long-running benthic invertebrate survey of the Environmental Monitoring Program (EMP) (Wells and IEP 2022), which has sampled monthly at ten sites from San Pablo Bay upstream to endpoints at Clifton Court Forebay, near Stockton, and up the Sacramento River as far as Rio Vista. This survey has occurred at these ten sites from 1996 to present, and from 1975 to 1996 at a smaller subset of those sites along with others since discontinued. The ten EMP sites sampled since 1996 are hereafter referred to as “EMP core sites”, and the dataset encompassing sites sampled since 1975 as “EMP long-term data”. See Wells and IEP 2022 for full metadata (Wells and IEP 2022).

The second survey is a spatially extensive survey performed twice a year in May and October from 2007 through 2019 except for 2013 and 2016, designed to augment EMP data. CDWR staff who designed the survey chose sites in the same geographic range as the EMP survey, using a Generalized Random Tessellation Stratified (GRTS) sampling design (Stevens and Olsen 2004) which stratified site selection by water body type, ensuring adequate sampling effort in habitats with smaller total areas. Staff sampled 175 sites each year from 2007 through 2017 (sampling did not occur in 2013 and 2016), 100 sites in 2018, and only 50 core sites in 2019. Fifty of the sites sampled were the same year to year (core sites), and additional sites were newly selected each year using the same GRTS design. This survey is hereafter referred to as “GRTS”.

The two surveys are complementary in that the EMP survey is temporally intensive but spatially limited (up to ten sites chosen to be representative of main rivers and bays, done every month), while the GRTS survey was temporally limited but spatially intensive (sampling twice a year, at a minimum of 50 and at most 175 randomly chosen sites that extended into smaller water bodies, such as sloughs and canals). Data from these surveys were subset to include only stations within the area defined above for the jellyfish data, within the following regions: North Delta, Confluence, Suisun Marsh, Suisun Bay, and South-Central (Figure 2).

For each survey, staff used a Ponar dredge to collect 0.052 m2 of benthic area to a maximum sediment depth of 10 cm at each site. The sample was rinsed over 0.595 mm sieve and all P. amurensis and C. fluminea individuals were identified, enumerated, and binned by size (e.g., 0-1 mm, 1-2 mm). Clam densities were converted to individuals/m2.

Clam counts and sizes were converted into ash-free dry mass using length:biomass regression equations (see ClamRegressions.csv). These equations are constructed monthly from an additional separate sample taken at nearby EMP sites that contained large numbers of the relevant species of clam. The regressions from these ‘reference sites’ were used for all sites within a region for that year and month. Unique regressions were used for each region, year, and month, to account for differences in condition due to temperature, food availability, and other factors.

We combined data from GRTS and the EMP core sites sampled during May and October due to GTRS only sampling during these months, and from 2007-2019 (excluding 2013 and 2016, when GRTS data were not available) to assess effects of water year type on P. amurensis and C. fluminea population densities and their combined filtration rates across regions. We used combined filtration rates to test the hypothesis that total clam filtration increased during drought conditions.

Data Source
Interagency Ecological Program: Benthic invertebrate monitoring in the Sacramento-San Joaquin Bay-Delta, collected by the Environmental Monitoring Program, 1975-2023.
Description:

These methods were used to create the "Alljellyfish" dataset.

Sampling information

For an interactive map of sampling sites, see: https://deltascience.shinyapps.io/monitoring/

The CDFW Fall Midwater Trawl (FMWT) survey samples at fixed locations from eastern San Pablo Bay to the Cache Slough complex and Sacramento Deep Water Ship Channel, on the Sacramento River, and to Stockton on the San Joaquin River. This survey runs once per month during September, October, November, and December at 122 stations with a trawling net pulled obliquely through the water with one, 12-minute tow per station. The net has a mouth area of 13 m2 when stretched taut and mesh that graduates from 203.2mm (8-inch) stretch mesh at the mouth to 0.5 inch stretch mesh at the cod end. The FMWT survey primarily monitors young-of-the-year fishes, but it has recorded catch of gelatinous zooplankton in its net since 2000. Catch of gelatinous in the net is converted to catch-per-unit-effort (CPUE) by dividing by the volume of water sampled, as measured with a General Oceanics Flowmeter.

The CDFW Summer Townet (STN) Survey samples fixed locations from eastern San Pablo Bay to Rio Vista on the Sacramento River, and to Stockton on the San Joaquin River and a single station in the lower Napa River. The STN survey runs twice per month during June, July, and August and samples at 40 stations with a D-frame net which is pulled 2-3 times, obliquely, through the water for 10 minutes at each sampling station. The net is 4.6 long, has a mouth area of 1.5 m2, and 1.27 cm mesh tapering down to 0.32 cm mesh at the cod end. The survey primarily monitors young-of-the-year fishes, but has recorded catch of gelatinous zooplankton since 2007. Catch of gelatinous zooplankton in the net is converted to catch-per-unit-effort (CPUE) by dividing by the volume of water sampled, as measured with a General Oceanics Flowmeter.

The CDFW San Francisco Bay Study (Bay Study) samples fixed locations throughout the San Francisco Bay, Suisun Bay, the lower Sacramento River, and Lower San Joaquin River once per month year-round. The survey uses midwater trawls to target fish, shrimp, and crabs, and has recorded catch of gelatinous zooplankton in their midwater trawls since 2000. The midwater trawl net has the same specifications as the FMWT net, described above. Catch of gelatinous zooplankton in the net is converted to catch-per-unit-effort (CPUE) by dividing volume of water sampled, as measured with a General Oceanics Flowmeter.

The University of California, Davis, Suisun Marsh Fish Survey (Suisun) samples fixed locations within Suisun Marsh. The survey runs once per month year-round at 25 stations using otter trawls. The otter trawl has a mouth area of 6.45 m2, a length of 5.3 m, and body net mesh from 35 mm stretch at the mouth to 6 mm stretch at the cod end. The survey primarily monitors fishes but has recorded catches of gelatinous zooplankton since the survey began in 1980. Catch of Maeotias in the net is converted to catch-per-unit-effort (CPUE) by dividing by the volume of water sampled, which is calculated based on tow area (distance traveled times width of net, multiplied by the height of the net. Maeotias is the only jellyfish recorded by this survey, but other species do occur in the area occasionally, so they may be mis-identifying some.

Data Source
Fall Midwater Trawl
Data Source
Summer Townet Survey
Data Source
San Francisco Bay Study
Description:

This methods were used to create the "Drought Zooplankton" dataset

Zooplankton abundance (organisms/m3) data for the CDFW EMP Zooplankton study were downloaded using the zooper package (https://github.com/InteragencyEcologicalProgram/zooper), an R package that synthesizes zooplankton data from multiple monitoring surveys (Bashevkin et al. 2022). We used abundance data from either the macro (500-505 μm mesh net tow), meso (150-160 μm mesh net tow), or micro (pumped into a 43 μm mesh net) gears, depending on which gear sampled each taxon most efficiently (Kayfetz et al. 2020). We then calculated adult biomass (carbon weight, μg/m3) utilizing the conversions in Bashevkin et al (2022) for meso (P. forbesi and Daphnia spp.) and microzooplankton (L. tetraspina) and the biomass for macro zooplankton (H. longirostris) using length to weight equations (Burdi et al. 2022). We focused on data from 1994-2021 since that is when all the examined taxa were present in the estuary and excluded winter months (December – February) due to inconsistent historical winter sampling. Sampling stations were assigned to regions (Suisun Marsh, Suisun Bay, the Confluence, the North Delta, and the South Central Delta using the deltamapr package (Bashevkin 2021). Data from the North Delta were subsequently excluded due to lack of consistent long-term zooplankton sampling in the region.

Data Source
Interagency Ecological Program: Zooplankton abundance in the Upper San Francisco Estuary from 1972-2021, an integration of 7 long-term monitoring programs
Description:

These methods were used to create the "Dayflow_ResidenceTime" dataset.

To estimate residence time (the length of time a particle of water remains in the upper estuary), we replicated the methods used by Hammock et al. (2019). In brief, we obtained monthly residence times for the Sacramento and San Joaquin river corridors from Hammock et al. for 1991, 1996, 1998, 2005, and 2009 and then fit statistical models of residence time versus inflow, project exports, and in-delta agricultural diversions, then used the best model to predicted residence time for all years not modeled by Hammock et al.

Hammock et al. (2019) ran the Delta Simulation Model 2’s (DSM2 version 8.1(CDWR 2013)) particle tracking module to calculate monthly residence time for 1000 particles inserted near Sacramento on the Sacramento River (DSM2 node 331) or near Stockton on the San Joaquin River (DSM node 21). Residence time was measured as the number of days it took for 90% of particles to exit the estuary, either by passing Martinez or by being diverted into the Central Valley Project (CVP) or State Water Project (SWP). Monthly residence time for water years 1991, 1996, 1998, 2005, and 2009 was obtained from Bruce Hammock (pers. comm.) per the original paper. These years were chosen by Hammock et al. (2019) to encompass a range of hydrological conditions. We then fit statistical models using the flow parameters below to reconstruct residence time on the Sacramento River and San Joaquin River for 1975-2021.

Flow parameters:

1. Sac - Sacramento River Inflow, at Freeport, as included in the Dayflow model, log-ten transformed. This data is derived from USGS flow station 11447650 (Latitude 38.45601, Longitude -121.50134).

2. SJR - San Joaquin River Inflow at Vernalis, as included in the Dayflow model, log-ten transformed. This data is derived from USGS flow station 11303500 (Latitude 37.67611, Longitude -121.26528).

3. Exports - Combined Central Valley Project and State Water Project daily pumping rates as included in the Dayflow model (CDWR 2022b). This data is derived from DWR’s and the US Bureau of Reclamation’s operational records.

4. Ag - In-Delta agricultural diversions, as modeled by the Delta Evapotranspiration of Applied Water model aligned with the Delta Channel Depletion Model (CDWR 2021). This model is considered significantly more accurate than the estimate of in-Delta use provided by the Dayflow model.

We modeled the residence time on the Sacramento River (RTSAC) and San Joaquin River (RTSJR) as calculated by DSM2 in Hammock et al 2019 as:

RTSAC ~ Sac + Exports + Ag + Sac*Exports

RTSJR ~ SJR+ Exports + Ag + SJR*Exports

For each residence time parameter (RTSJR or RTSAC), we evaluated all possible combinations of the variables in the global model and ranked them using Akaike’s Information Criterion, adjusted for small sample size (AICc). Statistical models were run using the ‘lm’ function in R (R Core Team 2023).

Once we determined the best possible model of Sacramento and San Joaquin residence time, we used these models to predict residence time for all years not modeled by DSM2 (1975-1990, 1994-1995, 1997, 1999-2004, 2006-2008, and 2010-2021).

Description:

These are the steps we used to create the integrated dataset.

We developed an integrated dataset of environmental parameters derived from Interagency Ecological Program (IEP) long-term monitoring datasets from 1975-2021. Data from these surveys were averaged by region (Figure 3), and season (with Winter including December, January, February, Spring including March, April, May, Summer including June, July, August, and Fall including September, October, November). This seasonal definition meant that the ‘Fall’ season straddled two water years. Because ecological conditions in the fall are usually more dependent on conditions from the previous winter-spring than any early fall rain, we adjusted the water year to run from December 1st of the previous year to November 30th, instead of October-September. However, we still used the water year index assigned to the water year from October through September. We then took the regional average across seasons for chlorophyll and zooplankton biomass to get a single data point for each region and year. For other variables, we averaged across both season and region to get a single data point for the entire year. Some variables (such as Delta outflow) did not have a regional component, and some variables (such as the fish indices) used established summary methods instead of regional averages.

Delta Outflow, and Project Exports –

Net Delta outflow Index, and project exports (combined exports from the State Water Project and Central Valley Project) were from DWR’s Dayflow model (CDWR 2002). See supplemental info for data sources and how outflow is calculated. All data are published annually after input data have undergone quality control procedures on the California Natural Resources Agency Open Data Portal .

Water Quality, Nutrients and Chlorophyll

Water temperature, salinity, Secchi depth, dissolved ammonium, dissolved nitrate + nitrite, dissolved orthophosphate and chlorophyll-a were assembled as for Bosworth et al. (This Issue). In brief, data from 16 monitoring surveys were integrated into a discrete water quality dataset available on the Environmental Data Initiative repository (Bashevkin et al. 2023). This dataset contains water quality, nutrient, and chlorophyll data collected by long-term monitoring surveys that sample approximately monthly at locations throughout the upper estuary. We obtained data collected by 12 surveys that have at least 20 years of data between 1975-2021 within our study area in the upper estuary (Figure 3). All water temperature and salinity measurements were typically collected at a depth of one meter, and the nutrient and chlorophyll samples were collected at various depths less than five meters from the surface. For more information on data collection methods, refer to the metadata in Bashevkin et al. (2023).

We selected only one sample per station per day and restricted the dataset to include subregions that had data for at least 35 out of the 47 years for all four seasons to ensure spatial and temporal balance across the dataset. Subregions were defined by polygons from the deltamapr R package (Bashevkin 2021). Before aggregating the nutrient and chlorophyll data, we substituted the values below the reporting limit with simulated values between zero and the reporting limit based on a uniform distribution. We ran one simulation for each parameter and set a seed prior to running the simulation to ensure reproducibility. For more information on data cleaning and aggregation, see Bosworth et al. 2024.

Zooplankton

Zooplankton data were collated as for Barros et al. 2024. In brief, zooplankton Catch Per Unit Effort (CPUE, organisms/m3) for the Environmental Monitoring Program was downloaded using the zooper package, an R package that synthesizes zooplankton data from multiple IEP studies (Bashevkin et al. 2022a). We used CPUE data from either the macro (500-505 μm mesh), meso (150-160 μm mesh), or micro (43 μm mesh) nets, depending on which net sampled each taxon most efficiently. We focused on dominant taxa that are most frequently found in the diets of Delta Smelt and Longfin Smelt – the cladocerans Bosmina longirostris, Daphnia sp., Diaphanosoma sp.; the copepods Acartia sp., Acartiella sinensis, Eurytemora affinis (adults and copepodites), Limnoithona tetraspina (adults), Pseudodiaptomus forbesi (adults and copepodites), Tortanus sp.(adults), and the mysids Hyperacanthomysis longirostris, Neomysis kadiakensis, and Neomysis mercedis. We then calculated biomass per unit effort (BPUE, mgC/m3) utilizing the conversions in Bashevkin et al. (2022) for meso and micro zooplankton (copepods and cladocerans) and the BPUE for macro zooplankton (mysids) using length to weight equations (Burdi et al. 2021) for the years of 1975-2021. BPUE converts the zooplankton data into a ‘common currency’ relevant to estuarine productivity and food availability for fish consumers. We excluded winter months (December – February) due to inconsistent historical winter sampling and excluded data from the North Delta region due to lack of consistent long-term zooplankton sampling in the region.

Fall Midwater Trawl Indices

Data on population abundance of pelagic fishes (age-0 Striped Bass (Morone saxatilis), Threadfin Shad (Dorosoma petenense), American Shad (Alosa sapidissima), Longfin Smelt (Spirinchus thaleichthys), and Delta Smelt (Hypomesus transpacificus) came from the Fall Midwater Trawl Survey (FMWT) conducted by CDFW (White 2021). Annual abundance indices were obtained from the California Department of Fish and Wildlife (CDFW) website, (https://filelib.wildlife.ca.gov/Public/TownetFallMidwaterTrawl/, date: 10/11/2022). The FMWT conducts stepped-oblique trawls at 100 index stations throughout the upper estuary once per month in September, October, November, and December of each year. The annual index for each species is calculated based on weighted catches from each of 17 areas over the four-month sampling period (September-December). Details for the calculations, as well as the complete catch data from this program, are available from the CDFW website.

Salmon Cohort Replacement Rate

The combined cohort replacement rates for fall-run Central Valley Chinook Salmon and spring-run Central Valley Chinook Salmon (Oncorhynchus tshawytscha) were calculated as per Nelson et al. (This Issue). In brief, CDFW calculates annual escapement data based on watershed-wide surveys for salmon throughout their life cycle (Grandtab; Azat 2021). This dataset can be used to estimate a particular returning year class’s contribution to the population’s overall abundance. Year-over-year escapement can be used to calculate a population’s “cohort replacement rate” (CRR), which is the measure of the number of spawners produced by the parental generation of spawners three years prior (see supplemental information for details). We calculated the CRR for spring-run and fall-run Chinook Salmon and looked for effects of drought or water year index on CRR for the year that the cohort out-migrated.

Data Source
Fall Midwater Trawl data
Data Source
Interagency Ecological Program Zooplankton Study
Data Source
Six decades (1959-2022) of water quality in the upper San Francisco Estuary: an integrated database of 16 discrete monitoring surveys in the Sacramento San Joaquin Delta, Suisun Bay, Suisun Marsh, and San Francisco Bay
Data Source
GrandTab Salmon Data
Description:

These are the methods used to create the "ContWaterQualityDaily" dataset used for Bouma-Gregson et al, 2024.

CDWR and USGS maintain a network of water-quality sondes and streamgages that collect data continuously (i.e., every 15 minutes) across the Delta. These stations collect data on water temperature, specific conductance, flow, DO, chlorophyll fluorescence (fCHL), turbidity, and pH using Yellow Springs Instruments (YSI) EXO2 sondes . Quality-control data were requested from CDWR personnel when available, and provisional data were queried from the California Data Exchange Center (CDEC) if finalized data were not available. To assess how cyanoHABs affect water-quality parameters, we plotted the daily mean of data collected at stations in the South and Central Delta that experienced cyanobacteria blooms in 2021 versus day of the year for the past seven years (2015–2021). 2014 was not included in this analysis because the water quality station at Frank’s Tract (FRK) was not installed until 2015.

Data Source
California Data Exchange Center
Description:

References

Azat J. 2021. GrandTab 2021.06.30 California Central Valley Chinook Population Database Report. California Department of Fish and Wildlife. [accessed 2023 Jan 4], https://nrm.dfg.ca.gov/FileHandler.ashx?DocumentID=84381.

Barros, A., R. Hartman, S. Bashevkin, and C. Burdi. 2024. Years of drought and salt; decreasing flows determine the distribution of zooplankton resources in the estuary. San Francisco Estuary and Watershed Science. [accessed 2024 Mar 29]. 22 (1). https://doi.org/10.15447/sfews.2024v22iss1art3

Bashevkin, S. M., R. Hartman, M. Thomas, A. Barros, C. E. Burdi, A. Hennessy, T. Tempel, and K. Kayfetz. 2022. Five decades (1972–2020) of zooplankton monitoring in the upper San Francisco Estuary. Plos ONE. [accessed 2022 May 17]. 17 (3):e0265402. https://doi.org/10.1371/journal.pone.0265402

Bashevkin, S. M., S. E. Perry, E. B. Stumpner, and R. Hartman. 2023. Six decades (1959-2022) of water quality in the upper San Francisco Estuary: an integrated database of 16 discrete monitoring surveys in the Sacramento San Joaquin Delta, Suisun Bay, Suisun Marsh, and San Francisco Bay ver 7. Environmental Data Initiative. [accessed 2023 Sep 7]. https://doi.org/10.6073/pasta/8dbd29c8c22f3295bbc5d3819fb51d00

Bashevkin, S. M., S. E. Perry, E. B. Stumpner, and R. Hartman. 2023. Six decades (1959-2022) of water quality in the upper San Francisco Estuary: an integrated database of 16 discrete monitoring surveys in the Sacramento San Joaquin Delta, Suisun Bay, Suisun Marsh, and San Francisco Bay ver 7. Environmental Data Initiative. [accessed 2023 Sep 7]. https://doi.org/10.6073/pasta/8dbd29c8c22f3295bbc5d3819fb51d00

Bosworth DH, Hartman R, Bashevkin SM, Stumpner EB, Bouma-Gregson K. 2024. InteragencyEcologicalProgram/WQ-LTPublication: Manuscript-Resubmittal 1, v2.0.0. Zenodo. [accessed 2024 Jan 11]. https://doi.org/10.5281/zenodo.10493268

Bosworth, D. H., S. M. Bashevkin, K. Bouma-Gregson, R. Hartman, and E. B. Stumpner. 2024. The anatomy of a drought in the upper San Francisco estuary: water quality and lower-trophic responses to multi-year droughts over a long-term record (1975-2021) San Francisco Estuary and Watershed Science. [accessed 2024 Mar 29]. 22 (1). https://doi.org/10.15447/sfews.2024v22iss1art1

Bouma-Gregson, K., D. Bosworth, T. Flynn, A. Maguire, J. Rinde, and R. Hartman. 2024. Delta Blue(green)s: The Impact of Drought and Drought Management Actions on Microcystis in the Sacramento–San Joaquin Delta. San Francisco Estuary and Watershed Science. [accessed 2024 Mar 29]. 22 (1). https://doi.org/10.15447/sfews.2024v22iss1art2

Burdi, C. E., S. B. Slater, T. L. Bippus, and J. A. Jimenez. 2022. Mysid and Amphipod Length-Weight Relationships in the San Francisco Estuary. IEP Newsletter. [accessed 2024 Mar 11]. 40 (1):15-25. https://cadwr.app.box.com/v/InteragencyEcologicalProgram/file/860495889310

California Department of Water Resources (CDWR). 2002. Dayflow: and estimate of daily average Delta Outflow. Dayflow documentation 1997 through present., California Natural Resources Agency Open Data. [accessed 2023 Jan 4]. 25. https://data.cnra.ca.gov/dataset/dayflow/resource/776b90ca-673e-4b56-8cf3-ec26792708c3

California Department of Water Resources (CDWR). 2022. Dayflow: and estimate of daily average Delta Outflow. California Natural Resources Agency Open Data. [accessed 2023 Feb 6]. https://data.cnra.ca.gov/dataset/dayflow/resource/776b90ca-673e-4b56-8cf3-ec26792708c3

De Cicco, L. A., R. M. Hirsch, D. Lorenz, and W. D. Watkins. 2022. dataRetrieval: R packages for discovering and retrieving water data available from Federal hydrologic web services. v. 2.7.11. [accessed 2023 Jan 6]. https://doi.org/10.5066/P9X4L3GE

Godin, G. 1972. The Analysis of Tides. University of Toronto Press, Toronto.

Hammock, B. G., S. P. Moose, S. S. Solis, E. Goharian, and S. J. Teh. 2019. Hydrodynamic Modeling Coupled with Long-term Field Data Provide Evidence for Suppression of Phytoplankton by Invasive Clams and Freshwater Exports in the San Francisco Estuary. Environmental Management. [accessed 2023 Jan 4]. 63:703-717. https://doi.org/10.1007/s00267-019-01159-6

Hartman, R., E. Stumpner, C. Burdi, D. Bosworth, A. Maguire, and IEP Drought Synthesis Team. 2024. Dry me a river: Ecological effects of drought in the upper San Francisco Estuary. San Francisco Estuary and Watershed Science. [accessed 2024 Mar 21]. 22 (1). https://doi.org/10.15447/sfews.2024v22iss1art5

Hartman, R., L. Twardochleb, C. Burdi, and E. Wells. 2024. Amazing graze: Shifts in distribution of Maeotias and Potamocorbula during droughts. San Francisco Estuary and Watershed Science. [accessed 2024 Mar 29]. 22 (1). https://doi.org/10.15447/sfews.2024v22iss1art4

Moritz, S., and T. Bartz-Beielstein. 2017. imputeTS: Time Series Missing Value Imputation in R. R Journal. [accessed 2023 Jan 6]. 9.1. https://doi.org/10.32614/RJ-2017-009

Data Source
Harmful algal bloom and aquatic weeds data from the Sacramento-San Joaquin Delta, collected to evaluate the impact of the 2021 Temporary Urgency Change Order and Emergency Drought Barrier

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: David Bosworth
Organization:California Department of Water Resources
Position:Senior Environmental Scientist (Specialist)
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
David.Bosworth@water.ca.gov
Id:https://orcid.org/0000-0003-0740-3390
Individual: Rosemary Hartman
Organization:California Department of Water Resources
Position:Environmental Program Manager
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Rosemary.Hartman@water.ca.gov
Id:https://orcid.org/0000-0002-0642-183X
Individual: Laura Twardochelb
Organization:California State Water Resources Control Board
Position:Environmental Program Manager
Email Address:
Laura.Twardochleb@waterboards.ca.gov
Id:https://orcid.org/0000-0002-8804-9399
Individual: Elizabeth Wells
Organization:California Department of Water Resources
Position:Environmental Scientist
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Elizabeth.Wells@water.ca.gov
Individual: Samuel Bashevkin
Organization:California State Water Resources Control Board
Position:Environmental Program Manager
Email Address:
Sam.Bashevkin@waterboards.ca.gov
Id:https://orcid.org/0000-0001-7406-7089
Individual: Evan Sawyer
Organization:NOAA Fisheries
Email Address:
evan.sawyer@noaa.gov
Id:https://orcid.org/0009-0006-4278-6111
Individual: Christina E. Burdi
Organization:California Department of Water Resources
Position:Senior Environmental Scientist (Specialist)
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Christina.Burdi@water.ca.gov
Id:https://orcid.org/0000-0002-1565-4475
Individual: Amanda M Maguire
Organization:California Department of Water Resources
Position:Environmental Scientist
Id:https://orcid.org/0009-0005-4243-4194
Individual: Elizabeth B. Stumpner
Organization:California Department of Water Resources
Position:Senior Environmental Scientist (Specialist)
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Elizabeth.Stumpner@water.ca.gov
Id:https://orcid.org/0000-0003-2356-2244
Individual: Arthur Barros
Organization:California Department of Fish and Wildlife
Position:Environmental Scientist
Email Address:
Arthur.Barros@wildlife.ca.gov
Individual: Peter Nelson
Organization:California Department of Water Resources
Position:Senior Environmental Scientist (Specialist)
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Peter.Nelson@water.ca.gov
Id:https://orcid.org/0000-0002-6953-4006
Individual: Theodore Flynn
Organization:California Department of Water Resources
Position:Senior Environmental Scientist (Supervisor)
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Theodore.Flynn@water.ca.gov
Id:https://orcid.org/0000-0002-1838-8942
Contacts:
Individual: David Bosworth
Organization:California Department of Water Resources
Position:Senior Environmental Scientist (Specialist)
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
David.Bosworth@water.ca.gov
Id:https://orcid.org/0000-0003-0740-3390
Individual: Rosemary Hartman
Organization:California Department of Water Resources
Position:Environmental Program Manager
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Rosemary.Hartman@water.ca.gov
Id:https://orcid.org/0000-0002-0642-183X
Associated Parties:
Individual: Jenna Rinde
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Role:assisted in data interpretation
Individual: Keith Bouma-Gregson
Organization:US Geological Survey
Role:assisted in data interpretation
Individual: Theodore Flynn
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Role:assisted in data organization and interpretation
Individual: Sarah Perry
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Role:assisted in data organization and interpretation
Individual: Elizabeth Keller
Organization:NOAA Fisheries
Role:assisted in data interpretation
Individual: Tyler Salman
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Role:assisted in data organization

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
1975
End:
2021
Geographic Region:
Description:The upper San Francisco Estuary, including the Sacramento San Joaquin Delta, Suisun Bay, and Suisun Marsh
Bounding Coordinates:
Northern:  38.42938Southern:  37.78607
Western:  -122.129Eastern:  -121.3077

Project

Parent Project Information:

Title:Interagency Ecological Program Drought Synthesis
Personnel:
Individual: Rosemary Hartman
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Rosemary.Hartman@water.ca.gov
Role:Project Manager

Maintenance

Maintenance:
Description:

This dataset is associated with the 2021-2023 Drought Synthesis project, so will not be updated after all associated manuscripts are published. It may be updated if any major issues with the data are discovered necessitating changes to the manuscripts.

Frequency:notPlanned
Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'unitList'
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'days'
        |     |     |     |  \___attribute 'name' = 'days'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text '24 hours'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microsiemenspercentimeter'
        |     |     |     |  \___attribute 'name' = 'microsiemenspercentimeter'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'meterCubedPerMeterSquaredPerDay'
        |     |     |     |  \___attribute 'name' = 'meterCubedPerMeterSquaredPerDay'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Volume of water clams can pump in cubic meters of water for square meter of benthos per day.'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'gramsPerMillimeter'
        |     |     |     |  \___attribute 'name' = 'gramsPerMillimeter'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Log-transformed change in ash free dry weight per log-transformed change in length'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'NumberPer10000CubicMeters'
        |     |     |     |  \___attribute 'name' = 'NumberPer10000CubicMeters'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Number of jellyfish per 10000 cubic meters of water sampled'
        |     |     |     |___text '\n            '
        |     |     |___text '\n            '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'NTU'
        |     |     |     |  \___attribute 'name' = 'NTU'
        |     |     |     |___text '\n               '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Nephrelometric Turbidity Units'
        |     |     |     |___text '\n            '
        |     |     |___text '\n         '
        |     |___text '\n      '
        |___text '\n   '

Additional Metadata

additionalMetadata
        |___text '\n      '
        |___element 'metadata'
        |     |___text '\n         '
        |     |___element 'emlEditor'
        |     |        \___attribute 'app' = 'ezEML'
        |     |        \___attribute 'release' = '2024.05.22'
        |     |___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