Interagency Ecological Program: Data for Synthesis for Ecological Impacts of Drought in the Upper San Francisco Estuary, 1975-2021
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, residence time, and daily values of various continuous water quality stations located in the Delta. ## About This Federated Record This CNRA Open Data Platform record is based on metadata federated from the Environmental Data Initiative (EDI) Data Portal. Its purpose is to improve the discoverability of the data package through the CNRA Open Data Platform. The EDI Data Portal is the repository of record for this data package. Metadata, resource links, and supporting information displayed here may not reflect the latest updates available in EDI. Resources shown here—including Full Metadata, Provenance, and Data Quality Report—are provided to help users understand and evaluate the data package and the supporting information available from EDI. For the current data package, citation, DOI, data files, metadata, provenance, data quality documentation, revision history, and other supporting information, refer to the EDI data package landing page: https://portal.edirepository.org/nis/metadataviewer?packageid=edi.1653.1&key=vqSpNwnbe91Bi8trB5RY25CoPD4 Access requirements, permissions, and authorization policies for resources hosted by EDI are established and managed independently of the CNRA Open Data Platform.
Data files
Supporting files
| Data title and description | Access data | File details | Last updated |
|---|---|---|---|
WQ_1975_2021 This dataset contains raw values of three water quality parameters - water temperature, salinity, and Secchi depth - collected in the upper San Francisco Estuary (Delta) from 1975-2021. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
Nutrients_1975_2021 This dataset contains raw values of three nutrient parameters - dissolved ammonia, dissolved nitrate plus nitrite, and dissolved ortho-phosphate - collected in the upper San Francisco Estuary (Delta) from 1975-2021. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
Chlorophyll_1975_2021 This dataset contains raw concentration values of chlorophyll-a in water samples collected in the upper San Francisco Estuary (Delta) from 1975-2021. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
Dayflow_1975_2021 A data set containing daily values of total Delta inflow and net Delta outflow for water years 1975-2021 from the Dayflow model. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
velocity Water velocity at several USGS continuous monitoring stations in the Delta | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
Dayflow_Residencetime Monthly average hydrologic parameters for the Sacramento San Joaquin Delta. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
Integrated_dataset Annual averages of various ecological metrics used to quantify the effect of drought on the ecosystem. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
ContWaterQualityDaily Daily mean, min, and maximum for parameters collected at water quality sondes in the south Delta. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
EMP Clam data Biomass, density, and grazing rates of the clams Potamocorbula amurensis and Corbicula fluminea collected by the Environmental Monitoring Program (EMP). | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
GRTS_clams Clam density, biomass, filtration rate, turnover rate, and sampling locations for the Department of Water Resources GRTS survey. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
ClamRegressions Length-weight regressions used to calculate clam clearance rates in Hartman, Twarduchleb, Burdi, and Wells 2024. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
AllJellyfish 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. | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
Drought_Zooplankton EMP zooplankton biomass per unit effort data from 1993-2021 used for Barros et al. 2024 - "Years of Drought and Salt". | CSV (EXTERNAL DOWNLOAD) | 09/25/26 | |
barros et al zooplankton drought Journal article with more information about zooplankton data. | PDF | 09/25/26 | |
bosworth et al 2024 drought Journal article with more information about water quality analysis. | PDF | 09/25/26 | |
Hartman et al 2024 dry me a river Journal article with more information about integrated drought dataset. | PDF | 09/25/26 | |
Hartman et al 2024 amazing graze Journal article with more information about clam and jellyfish data. | PDF | 09/25/26 | |
boumagregson 2024 microcystis drought Journal article with information about the continuous water quality data. | PDF | 09/25/26 | |
Provenance Metadata This method step describes provenance-based metadata as specified in the LTER EML Best Practices. This provenance metadata does not contain entity specific information. | HTML | 09/25/26 | |
Full Metadata A link to the original metadata web page on the EDI Portal | HTML | 09/25/26 | |
Dataset Quality Report A link to the EDI Quality Metadata Page | HTML | 09/25/26 |