Data Package Metadata   View Summary

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

General Information
Data Package:
Local Identifier:edi.1337.3
Title: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
Alternate Identifier:DOI PLACE HOLDER
Abstract:

Condition 8 of the June 2021 Temporary Urgency Change Order for the Central Valley Project (CVP) and State Water Project (SWP) requires a special study of harmful algal blooms (HABs) in the Sacramento–San Joaquin Delta (Delta) and the spread of submersed aquatic vegetation (SAV), and floating aquatic vegetation (FAV), also referred to as “aquatic weeds”. A report on the study was submitted to the State Water Resources Control Board on June 1, 2022. This data package contains all publicly available data used in the report, including visual cyanobacteria reports, cyanotoxin data, water quality, nutrients, flow/hydrodynamics, chlorophyll-a concentrations, temperature, coverage of SAV and FAV, use of herbicides, and human populations. Many of these data were derived from other datasets, though some were collected specifically for this study

Publication Date:2023-05-03
For more information:
Visit: DOI PLACE HOLDER

Time Period
Begin:
2014-01-01
End:
2021-12-31

People and Organizations
Contact:Hartman, Rosemary (California Department of Water Resources) [  email ]
Creator:Hartman, Rosemary (California Department of Water Resources)
Creator:Bosworth, David (California Department of Water Resources)
Creator:Rasmussen, Nicholas (California Department of Water Resources)
Creator:Flynn, Theodore (California Department of Water Resources)
Creator:Bouma-Gregson, Keith (US Geological Survey)
Creator:Khanna, Shruti (California Department of Fish and Wildlife)
Creator:Frantzich, Jared (California Department of Water Resources)
Associate:Jones, Ajay (Sepro Corporation, Field data collection)
Associate:Gilbert, Patricia (California Department of Parks and Recreation, Field data collection)
Associate:Heilman, Mark (Sepro Corporation, Field data collection)
Associate:Sealock, Andrea (Sepro Corporation, Field data collection)
Associate:Shuler, Scott (Sepro Corporation, Field data collection)
Associate:Hyde, Shaun (Sepro Corporation, Field data collection)
Associate:Martinez, Jose (California Department of Parks and Recreation, Field data collection)
Associate:Thomas, Madison (California Department of Parks and Recreation, Field data collection)

Data Entities
Data Table Name:
Daily Air Temperature
Description:
A data set containing daily average air temperatures and degree days above 19 degrees Celsius for the region near the upper San Francisco Estuary (Delta) from 2015-2021. Values are based on averages of three continuous weather observation stations located near the Delta: San Joaquin River McCune station (SJR), Harvey O' Banks Pumping Plant (HBP), and San Joaquin River at Mossdale (MSD).
Data Table Name:
Discrete Nutrients and Chlorophyll
Description:
A data set containing concentrations of chlorophyll-a and three nutrient parameters (Dissolved Ammonia, Dissolved Nitrate + Nitrite, and Dissolved Ortho-phosphate) in water samples collected at various locations in the San Francisco Estuary (Delta) east of Chipps Island for 2014-2021.
Data Table Name:
Continuous Water Quality
Description:
A data set containing daily averages of various continuous water quality parameters measured in the water in-situ at the stations near Franks Tract located in the upper San Francisco Estuary (Delta). Water quality parameters include Dissolved Oxygen, pH, and Chlorophyll Fluorescence. Data was collected by DWR and USGS from 2015-2021.
Data Table Name:
Daily water tempertaure
Description:
A data set containing daily average water temperatures and degree days above 19 degrees Celsius for the upper San Francisco Estuary (Delta) from 2015-2021. Values are based on averages of six continuous water quality stations located in the Central and Southern Delta: False River near Oakley (FAL), Middle River near Holt (HLT), Holland Cut near Bethel Island (HOL), Middle River at Middle River (MDM), Old River at Quimbly (ORQ), and Old River at Franks Tract near Terminous (OSJ).
Data Table Name:
Cyanobacteria Satellite data
Description:
A data set containing counts of pixel values derived from HAB satellite data within 4 Cyano Index categories for four open water regions in the upper San Francisco Estuary (Delta): Franks Tract, Mildred Island, Clifton Court Forebay, and Liberty Island. Summary statistics cover the summer through fall (June-Oct) in 2019-2021. The Cyano Index categories (Low, Moderate, High, and Very High) were based on WHO recreational guidance level thresholds. The data set also includes counts of pixels that were below the detection limit for the imagery processing method and counts of pixels that were either invalid or missing.
Data Table Name:
HAB Incident Reports
Description:
A data set containing CyanoHAB incident reports in the upper San Francisco Estuary (Delta) in 2021. Most of this data is from the State Water Board's HAB Incident Report Map. This is combined with the maximum advisory levels for Microcystins that occurred at each station in 2021 from the cyanotoxin concentration data in the Cyanotoxins table. The advisory levels were developed by the California Cyanobacteria and Harmful Algal Bloom Network (CCHAB).
Data Table Name:
Cyanotoxins
Description:
A data set containing Cyanotoxin concentrations in whole-water grab samples collected at various locations in the upper San Francisco Estuary (Delta). The majority of the available cyanotoxin data was collected in 2021, so this data set only includes data from 2021 for all stations except for Big Break Regional Shoreline. Big Break has a longer monitoring history, so all data collected at this location from 2015–2021 are included in this data set.
Data Table Name:
Microcystis visual index and water quality
Description:
A data set containing Microcystis visual index, secchi depth, and water temperature data collected at various locations in the upper San Francisco Estuary (Delta) from 2007-2021.
Data Table Name:
Potentially Toxic Cyanobacteria cell counts
Description:
A data set containing phytoplankton community data of potentially toxic Cyanobacteria collected by DWR's Environmental Monitoring Program at various locations in the upper San Francisco Estuary (Delta) from 2014-2021.
Data Table Name:
Dayflow2014_2021
Description:
Daily flow parameters modeled by DWR's Dayflow program
Data Table Name:
Fluoroprobe mapping data
Description:
Fluorescence of various algal taxa measured by USGS and DWR during mapping surveys of the Delta. Data were collected with a Fluoroprobe.
Data Table Name:
Vegetation regional area estimates
Description:
UC Davis CSTARS analysis of hyperspectral imagery giving area covered by aquatic vegetation by region and year.
Data Table Name:
Franks Tract Fluridone_2006-2021
Description:
Fluridone (herbicide) treatments at Franks Tract
Data Table Name:
discrete_wq&outflow_data_summary
Description:
Suite of environmental variables hypothesized to affect or be affected by aquatic vegetation. Variables were generally collected in or near focal sites. Values are means of monthly measurements taken during the period each year expected to foster the most vegetation growth, March-October.
Data Table Name:
CSTARS_2021_FT&BB_Formatted_EDI
Description:
Field sampling of submersed aquatic vegetation in Franks Tract and Big Break by the UC-Davis CSTARS lab. Sampling was conducted using a weighted thatch rake head attached to a rope.
Data Table Name:
FranksTractManagement_2014-2021_formatted_edi
Description:
Submersed aquatic vegetation monitoring data produced by SePRO and Division of Boating and Waterways. Available data are from surveys conducted annually in October of 2014-2021. Samples collected using a thatch rake head attached to a rope.
Data Table Name:
Water Year Assignments
Description:
Sacramento Valley Hydrologic index and water year classification by water year.
Other Name:
Supplemental figures for HABsWeeds
Description:
Maps, figures, and tables with additional information.
Other Name:
HAB-Weed_Report_2022_10_14
Description:
Report on the impact of the 2021 TUCP and Emergency Drought Barrier on Harmful Algal Blooms and Aquatic Weeds in the Sacramento San Joaquin Delta
Other Name:
HABRegions
Description:
Zipped file containing regions of the Delta used for analysis as an ESRI shapefile and as an sf object in an RData file
Detailed Metadata

Data Entities


Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/f8863c200074ecbd507df6bf51807333
Name:Daily Air Temperature
Description:A data set containing daily average air temperatures and degree days above 19 degrees Celsius for the region near the upper San Francisco Estuary (Delta) from 2015-2021. Values are based on averages of three continuous weather observation stations located near the Delta: San Joaquin River McCune station (SJR), Harvey O' Banks Pumping Plant (HBP), and San Joaquin River at Mossdale (MSD).
Number of Records:2556
Number of Columns:4

Table Structure
Object Name:air_temp_daily_dd.csv
Size:133072 byte
Authentication:a5f36e27651ed91305274eab10f0810d 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
 YearDateAirTemp_AvgAirTemp_DD
Column Name:Year  
Date  
AirTemp_Avg  
AirTemp_DD  
Definition:Year of samplingDate of daily average temperatureMean air temperature for all three stations for the given dayCumulative number of degree days over 19C experienced in the current year
Storage Type:dateTime  
dateTime  
float  
float  
Measurement Type:dateTimedateTimeratioratio
Measurement Values Domain:
FormatYYYY
Precision
FormatYYYY-MM-DD
Precision
Unitcelsius
Typereal
UnitdegreeDay
Typereal
Missing Value Code:        
Accuracy Report:        
Accuracy Assessment:        
Coverage:        
Methods:        

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/a39bebb12c8bdfbd67be99c05675ce72
Name:Discrete Nutrients and Chlorophyll
Description:A data set containing concentrations of chlorophyll-a and three nutrient parameters (Dissolved Ammonia, Dissolved Nitrate + Nitrite, and Dissolved Ortho-phosphate) in water samples collected at various locations in the San Francisco Estuary (Delta) east of Chipps Island for 2014-2021.
Number of Records:3133
Number of Columns:15

Table Structure
Object Name:disc_nutr_chla.csv
Size:350190 byte
Authentication:ffcf5e75407531b811c2b2387565b9d9 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
 SourceStationLatitudeLongitudeRegionDateDatetimeDissAmmonia_SignDissAmmoniaDissNitrateNitrite_SignDissNitrateNitriteDissOrthophos_SignDissOrthophosChlorophyll_SignChlorophyll
Column Name:Source  
Station  
Latitude  
Longitude  
Region  
Date  
Datetime  
DissAmmonia_Sign  
DissAmmonia  
DissNitrateNitrite_Sign  
DissNitrateNitrite  
DissOrthophos_Sign  
DissOrthophos  
Chlorophyll_Sign  
Chlorophyll  
Definition:Name of the source dataset.Name 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 for the Emergency Drought Barrier analysis. (see supplemental map)Date of sample collectionDate and time of sample collectionA symbol representing whether the Dissolved Ammonia value is below the reporting limit or above it.Dissolved Ammonia concentration measured in the water sample in milligrams per liter as NA symbol representing whether the Dissolved Nitrate + Nitrite value is below the reporting limit or above it.Dissolved Nitrate + Nitrite concentration measured in the water sample in milligrams per liter as NA symbol representing whether the Dissolved Ortho-phosphate value is below the reporting limit or above it. Dissolved Ortho-phosphate concentration measured in the water sample in milligrams per liter as PA symbol representing whether the chlorophyll-a value is below the reporting limit or above it.Chlorophyll-a concentration in micrograms per liter
Storage Type:string  
string  
float  
float  
string  
dateTime  
dateTime  
string  
float  
string  
float  
string  
float  
string  
float  
Measurement Type:nominalnominalratiorationominaldateTimedateTimenominalrationominalrationominalrationominalratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDWR_EMP
DefinitionDWR's Environmental Monitoring Program
Source
Code Definition
CodeDWR_NCRO
DefinitionDWR's North Central Region Office
Source
Code Definition
CodeUSGS_CAWSC
DefinitionUSGS's California Water Science Center
Source
Code Definition
CodeUSGS_SFBS
DefinitionUSGS's San Francisco Bay Water Quality Survey
Source
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCache/Liberty
DefinitionCache Slough and Liberty Island
Source
Code Definition
CodeEast Delta
DefinitionEastern Delta
Source
Code Definition
CodeFranks
DefinitionFranks Tract
Source
Code Definition
CodeLower Sac
DefinitionLower Sacramento River downstream of intersection with Cache Slough
Source
Code Definition
CodeLower SJ
DefinitionLower San Joaquin River
Source
Code Definition
CodeOMR
DefinitionOld River and Middle River
Source
Code Definition
CodeSouth Delta
DefinitionSouth Delta
Source
Code Definition
CodeUpper Sac
DefinitionUpper Sacramento River between Cache Slough and the city of Sacramento
Source
FormatYYYY-MM-DD
Precision
FormatYYYY-MM-DD hh:mm:ss
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code<
Definition"<" - The value is below the Reporting Limit (RL) with the value in the corresponding result column equal to the RL.
Source
Code Definition
Code< (estimated)
Definition"< (estimated)" - The value is below the RL, but the RL is unknown. The value in the corresponding result column is the estimated RL value.
Source
Code Definition
Code=
Definition"=" - The value is above the RL with the value in the corresponding result column equal to the actual value measured by the laboratory. An NA value in the corresponding result column indicates that the value is missing or wasn't collected.
Source
Code Definition
Code= (unreliable)
Definition"= (unreliable)" - The value in the corresponding result column was determined to be an outlier and is excluded from the data set.
Source
UnitmilligramPerLiter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code<
Definition"<" - The value is below the Reporting Limit (RL) with the value in the corresponding result column equal to the RL.
Source
Code Definition
Code< (estimated)
Definition"< (estimated)" - The value is below the RL, but the RL is unknown. The value in the corresponding result column is the estimated RL value.
Source
Code Definition
Code=
Definition"=" - The value is above the RL with the value in the corresponding result column equal to the actual value measured by the laboratory. An NA value in the corresponding result column indicates that the value is missing or wasn't collected.
Source
Code Definition
Code= (unreliable)
Definition"= (unreliable)" - The value in the corresponding result column was determined to be an outlier and is excluded from the data set.
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 column equal to the RL.
Source
Code Definition
Code< (estimated)
DefinitionThe value is below the RL, but the RL is unknown. The value in the corresponding result column is the estimated RL value.
Source
Code Definition
Code=
DefinitionThe value is above the RL with the value in the corresponding result column equal to the actual value measured by the laboratory. An NA value in the corresponding result column indicates that the value is missing or wasn't collected.
Source
Code Definition
Code= (unreliable)
Definition The value in the corresponding result column was determined to be an outlier and is excluded from the data set.
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 column equal to the RL.
Source
Code Definition
Code=
DefinitionThe value is above the RL with the value in the corresponding result column equal to the actual value measured by the laboratory. An NA value in the corresponding result column indicates that the value is missing or wasn't collected.
Source
Code Definition
Code= (estimated)
DefinitionThe value is below the RL, but the RL is unknown. The value in the corresponding result column is estimated (extrapolated at the low end).
Source
UnitmicrogramPerLiter
Typereal
Missing Value Code:                
CodeNA
ExplData 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/1337/3/640462a710748f133ba680ee760fbc6a
Name:Continuous Water Quality
Description:A data set containing daily averages of various continuous water quality parameters measured in the water in-situ at the stations near Franks Tract located in the upper San Francisco Estuary (Delta). Water quality parameters include Dissolved Oxygen, pH, and Chlorophyll Fluorescence. Data was collected by DWR and USGS from 2015-2021.
Number of Records:13273
Number of Columns:6

Table Structure
Object Name:cont_wq_daily_avg.csv
Size:736242 byte
Authentication:d83a9f4061605cacea3b1229c7e34b50 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
 SourceStationDateDOpHChla
Column Name:Source  
Station  
Date  
DO  
pH  
Chla  
Definition:Name of the source dataset.Location of water quality sondeDate of sample collectionDissolved oxygen in water; measured using either YSI 6600 or YSI EXO sonde.pHDaily average chlorophyll fluorescence in micrograms per liter
Storage Type:string  
string  
dateTime  
float  
float  
float  
Measurement Type:nominalnominaldateTimeratioratioratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDWR_CEMP
DefinitionDWR's Continuous Environmental Monitoring Program
Source
Code Definition
CodeDWR_NCRO
DefinitionDWR's North Central Region Office
Source
Code Definition
CodeUSGS
DefinitionUS Geological Survey California Water Science Center
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeFAL
DefinitionFalse River station
Source
Code Definition
CodeFRK
DefinitionFranks Tract Station
Source
Code Definition
CodeHLT
DefinitionMiddle River at Holt
Source
Code Definition
CodeHOL
DefinitionHolland Cut near Bethel Island
Source
Code Definition
CodeMDM
DefinitionMiddle River
Source
Code Definition
CodeOSJ
DefinitionOLD RIVER AT FRANKS TRACT NEAR TERMINOUS
Source
FormatYYYY-MM-DD
Precision
UnitmilligramPerLiter
Typereal
Unitdimensionless
Typereal
UnitmicrogramPerLiter
Typereal
Missing Value Code:      
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/1337/3/d0efea3283984c56603f52810aebbcb1
Name:Daily water tempertaure
Description:A data set containing daily average water temperatures and degree days above 19 degrees Celsius for the upper San Francisco Estuary (Delta) from 2015-2021. Values are based on averages of six continuous water quality stations located in the Central and Southern Delta: False River near Oakley (FAL), Middle River near Holt (HLT), Holland Cut near Bethel Island (HOL), Middle River at Middle River (MDM), Old River at Quimbly (ORQ), and Old River at Franks Tract near Terminous (OSJ).
Number of Records:2557
Number of Columns:4

Table Structure
Object Name:wtr_temp_daily_dd.csv
Size:120829 byte
Authentication:fbc7239db73baa0d22a02c20786dff26 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
 YearDateWaterTemp_AvgWaterTemp_DD
Column Name:Year  
Date  
WaterTemp_Avg  
WaterTemp_DD  
Definition:Year sampling occuredDate of daily average temperatureMean water temperature for all three stations for the given dayCumulative number of degree days over 19C experienced in the current year
Storage Type:dateTime  
dateTime  
float  
float  
Measurement Type:dateTimedateTimeratioratio
Measurement Values Domain:
FormatYYYY
Precision
FormatYYYY-MM-DD
Precision
Unitcelsius
Typereal
UnitdegreeDay
Typereal
Missing Value Code:        
Accuracy Report:        
Accuracy Assessment:        
Coverage:        
Methods:        

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/b01bc008ac1a0fe6be945939f297a5c2
Name:Cyanobacteria Satellite data
Description:A data set containing counts of pixel values derived from HAB satellite data within 4 Cyano Index categories for four open water regions in the upper San Francisco Estuary (Delta): Franks Tract, Mildred Island, Clifton Court Forebay, and Liberty Island. Summary statistics cover the summer through fall (June-Oct) in 2019-2021. The Cyano Index categories (Low, Moderate, High, and Very High) were based on WHO recreational guidance level thresholds. The data set also includes counts of pixels that were below the detection limit for the imagery processing method and counts of pixels that were either invalid or missing.
Number of Records:800
Number of Columns:8

Table Structure
Object Name:hab_sat_ow_delta.csv
Size:34267 byte
Authentication:e7eaeea4f9707dcb25aacb4816f86157 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
 DateRegionNonDetectLowModerateHighVeryHighInvalidOrMissing
Column Name:Date  
Region  
NonDetect  
Low  
Moderate  
High  
VeryHigh  
InvalidOrMissing  
Definition:Date of satellite imagery Name of the polygon region, corresponding to major open water areas in the DeltaCount of the number of pixels below the detection limit for the method which is less than or equal to a Cyano Index of 0.0000631Count of the number of pixels in the Low Cyano Index category defined as having a Cyano Index of greater than 0.00006310 but less than 0.0002Count of the number of pixels in the Moderate Cyano Index category defined as having a Cyano Index greater than or equal to 0.0002 but less than 0.001Count of the number of pixels in the High Cyano Index category defined as having a Cyano Index greater than or equal to 0.001 but less than 0.01Count of the number of pixels in the Very High Cyano Index category defined as having a Cyano Index greater than or equal to 0.01. The maximum detectable level for the Cyano Index is 0.06327.Count of the number of pixels that were either invalid (land, adjacency) or missing (clouds, no data, or some other reason)
Storage Type:dateTime  
string  
float  
float  
float  
float  
float  
float  
Measurement Type:dateTimenominalratioratioratioratioratioratio
Measurement Values Domain:
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeClifton Court Forebay
DefinitionClifton Court Forebay
Source
Code Definition
CodeFranks Tract
DefinitionFranks Tract
Source
Code Definition
CodeLiberty Island
DefinitionLiberty Island
Source
Code Definition
CodeMildred Island
DefinitionMildred Island
Source
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Unitnumber
Typeinteger
Missing Value Code:                
Accuracy Report:                
Accuracy Assessment:                
Coverage:                
Methods:                

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/f7b1d1fcc5638c9cf6fd39719a85f3c7
Name:HAB Incident Reports
Description:A data set containing CyanoHAB incident reports in the upper San Francisco Estuary (Delta) in 2021. Most of this data is from the State Water Board's HAB Incident Report Map. This is combined with the maximum advisory levels for Microcystins that occurred at each station in 2021 from the cyanotoxin concentration data in the Cyanotoxins table. The advisory levels were developed by the California Cyanobacteria and Harmful Algal Bloom Network (CCHAB).
Number of Records:50
Number of Columns:4

Table Structure
Object Name:hab_incidents.csv
Size:2043 byte
Authentication:bf7302b70c8640ea17e3307629a7fdbf 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
 DateLatitudeLongitudeAdvisory
Column Name:Date  
Latitude  
Longitude  
Advisory  
Definition:Date of HAB advisoryLatitude of incident location in Decimal Degrees (WGS 84 Datum)Longitude of incident location in Decimal Degrees (WGS 84 Datum)CyanoHAB advisory level for the incident as defined by CCHAB. Is one of the following: Caution, Warning, or Danger.
Storage Type:dateTime  
float  
float  
string  
Measurement Type:dateTimeratiorationominal
Measurement Values Domain:
FormatYYYY-MM-DD
Precision
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCaution
DefinitionPotential HAB detected visually, but toxicity is unknown or Microcystin concentration is less than 0.8 ug/L
Source
Code Definition
CodeDanger
DefinitionMicrocystin concentration greater than 20 ug/L
Source
Missing Value Code:        
Accuracy Report:        
Accuracy Assessment:        
Coverage:        
Methods:        

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/c91ba16fa61f8e62cd7ca62a5a6cf269
Name:Cyanotoxins
Description:A data set containing Cyanotoxin concentrations in whole-water grab samples collected at various locations in the upper San Francisco Estuary (Delta). The majority of the available cyanotoxin data was collected in 2021, so this data set only includes data from 2021 for all stations except for Big Break Regional Shoreline. Big Break has a longer monitoring history, so all data collected at this location from 2015–2021 are included in this data set.
Number of Records:719
Number of Columns:11

Table Structure
Object Name:hab_toxins.csv
Size:64915 byte
Authentication:068694088cc14436e026621e58c398d5 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
 SourceStationLatitudeLongitudeRegionYearMonthDateAnalyteResultResult_Sign
Column Name:Source  
Station  
Latitude  
Longitude  
Region  
Year  
Month  
Date  
Analyte  
Result  
Result_Sign  
Definition:Name of the source dataset.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 for the Emergency Drought Barrier analysis.(see supplemental map)Year sampling occuredMonth of the yearDate of sample collectionName of Cyanotoxin measured in the water sampleConcentration of Analyte measured in the water sample in micrograms per literA symbol representing whether the Cyanotoxin value in Result is below a lower detection limit, equal to the reported value, or above an upper detection limit.
Storage Type:string  
string  
float  
float  
string  
float  
float  
dateTime  
string  
float  
string  
Measurement Type:nominalnominalratiorationominalratioratiodateTimenominalrationominal
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCVRWQCB
DefinitionCentral Valley Regional Water Quality Control Board
Source
Code Definition
CodeDWR
DefinitionDWR's State Water Project
Source
Code Definition
CodeEastBay
DefinitionEast Bay Regional Park District
Source
Code Definition
CodeNautilus
DefinitionNautilus Data Technologies
Source
Code Definition
CodePreece
DefinitionPreliminary data from a Proposition 1 funded study by Ellen Preece, Timothy Otten, Janis Cooke, and David Senn
Source
Code Definition
CodeUSGS
DefinitionUSGS California water Science Center, in collaboration with DWR
Source
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCache Slough/Liberty Island
DefinitionCache Slough/Liberty Island
Source
Code Definition
CodeClifton Court
DefinitionClifton Court Forbay
Source
Code Definition
CodeLower Sacramento
DefinitionLower Sacramento River downstream of intersection with Cache Slough
Source
Code Definition
CodeLower San Joaquin
DefinitionLower San Joaquin River
Source
Code Definition
CodeSan Joaquin
DefinitionSan Joaquin River near Stockton
Source
Code Definition
CodeSDWSC
DefinitionSacramento Deep Water Ship Channel
Source
Code Definition
CodeSouth Delta
DefinitionSouth Delta
Source
Code Definition
CodeUpper Sacramento
DefinitionUpper Sacramento River between Cache Slough and the city of Sacramento
Source
Code Definition
CodeVernalis
DefinitionVernalis
Source
UnitnominalYear
Typeinteger
Unitdimensionless
Typeinteger
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeAnabaenopeptins
DefinitionSum of all anabaenopeptins (USGS data only)
Source
Code Definition
CodeAnatoxins
DefinitionSum of all anatoxins
Source
Code Definition
CodeMicrocystins
DefinitionSome of all microcystins and nodularians
Source
Code Definition
CodeSaxitoxins
DefinitionSum of all saxitoxins
Source
UnitmicrogramPerLiter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code=
Definitionindicates that the value was detected by the laboratory with the value in the corresponding Result column equal to the actual value measured by the laboratory.
Source
Code Definition
Code>
Definitionindicates that the value was above an upper detection limit with the with the value in the corresponding Result column equal to the upper detection limit.
Source
Code Definition
CodeND
Definitionindicates that the value was below a lower detection limit. All values below a lower detection limit in this data set were replaced with zeros
Source
Missing Value Code:                      
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/10c5229a3942e631d747c9486d809aea
Name:Microcystis visual index and water quality
Description:A data set containing Microcystis visual index, secchi depth, and water temperature data collected at various locations in the upper San Francisco Estuary (Delta) from 2007-2021.
Number of Records:7339
Number of Columns:11

Table Structure
Object Name:mc_vis_index_wq.csv
Size:551222 byte
Authentication:e8a5ea01cfa3876a649ccc4b2801f2c6 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
 SourceStationLatitudeLongitudeRegionYearMonthDateMicrocystisSecchiTemperature
Column Name:Source  
Station  
Latitude  
Longitude  
Region  
Year  
Month  
Date  
Microcystis  
Secchi  
Temperature  
Definition:Name of the source datasetLocation 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 for the Emergency Drought Barrier analysis. (see supplemental map)Year sampling occuredMonth of the yearDate of sample collection Microcystis visual index value on a qualitative scale from 1 to 5,Secchi depthWater temperature
Storage Type:string  
string  
float  
float  
string  
float  
float  
dateTime  
string  
float  
float  
Measurement Type:nominalnominalratiorationominalratioratiodateTimenominalratioratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDWR_EMP
DefinitionDWR's Environmental Monitoring Program
Source
Code Definition
CodeDWR_NCRO
DefinitionDWR's North Central Region Office
Source
Code Definition
CodeFMWT
DefinitionCDFW's Fall Midwater Trawl survey
Source
Code Definition
CodeSTN
DefinitionCDFW's Summer Townet survey
Source
Definitiontext
Unitdegree
Typereal
Unitdegree
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCache/Liberty
DefinitionCache Slough and Liberty Island
Source
Code Definition
CodeEast Delta
DefinitionEastern Delta
Source
Code Definition
CodeFranks
DefinitionFranks Tract
Source
Code Definition
CodeLower Sac
DefinitionLower Sacramento River downstream of intersection with Cache Slough
Source
Code Definition
CodeLower SJ
DefinitionLower San Joaquin River
Source
Code Definition
CodeOMR
DefinitionOld River and Middle River
Source
Code Definition
CodeSouth Delta
DefinitionSouth Delta
Source
Code Definition
CodeUpper Sac
DefinitionUpper Sacramento River between Cache Slough and the city of Sacramento
Source
UnitnominalYear
Typeinteger
Unitdimensionless
Typeinteger
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code1
DefinitionNo visual Microcystis
Source
Code Definition
Code2
DefinitionLow - visible, but widely spaced colonies of Microcystis
Source
Code Definition
Code3
DefinitionModerate - Adjacent colonies of Microcystis
Source
Code Definition
Code4
DefinitionHigh - Contiguous colonies of Microcystis
Source
Code Definition
Code5
DefinitionVery High - Concentrated, contiguous colonies of Microcystis forming scum
Source
Unitcentimeter
Typereal
Unitcelsius
Typereal
Missing Value Code:                  
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/1337/3/391568ac3ba723a96d9442ebfdb6379d
Name:Potentially Toxic Cyanobacteria cell counts
Description:A data set containing phytoplankton community data of potentially toxic Cyanobacteria collected by DWR's Environmental Monitoring Program at various locations in the upper San Francisco Estuary (Delta) from 2014-2021.
Number of Records:228
Number of Columns:11

Table Structure
Object Name:phyto_hab.csv
Size:26089 byte
Authentication:a1dcc60e61a8561f29ea7741b0dae10a 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
 StationRegionYearDateDatetimeTaxonGenusSpeciesAlgalTypeCountOrganismsPerMl
Column Name:Station  
Region  
Year  
Date  
Datetime  
Taxon  
Genus  
Species  
AlgalType  
Count  
OrganismsPerMl  
Definition:Location where sample was collectedRegion designation of Station for the Emergency Drought Barrier analysis. Year sampling occuredDate of sample collectionDate and time of sample collectionLowest possible taxonomic identificationGenus nameSpecies nameBroad category of phytoplanktonNumber of natural units counted (cells/colonies/filiments)Concentration of organisms
Storage Type:string  
string  
float  
dateTime  
dateTime  
string  
string  
string  
string  
float  
float  
Measurement Type:nominalnominalratiodateTimedateTimenominalnominalnominalnominalratioratio
Measurement Values Domain:
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeEast Delta
DefinitionEast Delta
Source
Code Definition
CodeFranks
DefinitionFranks Tract
Source
Code Definition
CodeLower Sac
DefinitionLower Sacramento River downstream of intersection with Cache Slough
Source
Code Definition
CodeLower SJ
DefinitionLower San Joaquin River
Source
Code Definition
CodeOMR
DefinitionOld River and Middle River
Source
Code Definition
CodeSouth Delta
DefinitionSouth Delta
Source
Code Definition
CodeUpper Sac
DefinitionUpper Sacramento River between Cache Slough and the city of Sacramento
Source
UnitnominalYear
Typeinteger
FormatYYYY-MM-DD
Precision
FormatYYYY-MM-DD hh:mm:ss
Precision
Definitiontext
Definitiontext
Definitiontext
Definitiontext
Unitnumber
Typeinteger
UnitnumberPerMilliliter
Typereal
Missing Value Code:              
CodeNA
ExplTaxon not ID'd to species
     
Accuracy Report:                      
Accuracy Assessment:                      
Coverage:                      
Methods:                      

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/2368c56990d185597323dba8d859897b
Name:Dayflow2014_2021
Description:Daily flow parameters modeled by DWR's Dayflow program
Number of Records:27388
Number of Columns:6

Table Structure
Object Name:Dayflow2014_2021.csv
Size:1556873 byte
Authentication:353d9905b54b42fffefe74120a85f53d 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
 DateMetricCFSSevendayDOYYear
Column Name:Date  
Metric  
CFS  
Sevenday  
DOY  
Year  
Definition:DateFlow metric modeled or measuredDaily average flowSeven day rolling average flowDay of yearYear
Storage Type:dateTime  
string  
float  
float  
float  
float  
Measurement Type:dateTimenominalratioratioratioratio
Measurement Values Domain:
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeOutflow
DefinitionModeled daily net outflow index
Source
Code Definition
CodeProject Exports
DefinitionMeasured Central Valley Project and State Water Project Export rates
Source
Code Definition
CodeSan Joaquin Flow
DefinitionMeasured San Joaquin River flow at Vernalis
Source
UnitfootCubedPerSecond
Typeinteger
UnitfootCubedPerSecond
Typereal
UnitnominalDay
Typeinteger
UnitnominalYear
Typeinteger
Missing Value Code:      
CodeNA
Explless than seven days from the start of the data set
   
Accuracy Report:            
Accuracy Assessment:            
Coverage:            
Methods:            

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/7615758efc9ae650389f25a314d7cee1
Name:Fluoroprobe mapping data
Description:Fluorescence of various algal taxa measured by USGS and DWR during mapping surveys of the Delta. Data were collected with a Fluoroprobe.
Number of Records:226531
Number of Columns:11

Table Structure
Object Name:Fluoroprobe2.csv
Size:19518476 byte
Authentication:0e7bbe5a6b60aaf4b0423f73688c0d1d 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
 DateTimeLatitudeLongitudeTemperatureGreenAlgaeCyanobacteriaDiatomsCryptophytaYellowSubstancesTotalChlorophyllAgency
Column Name:DateTime  
Latitude  
Longitude  
Temperature  
GreenAlgae  
Cyanobacteria  
Diatoms  
Cryptophyta  
YellowSubstances  
TotalChlorophyll  
Agency  
Definition:Date and time of sample collectionLatitude decimal degrees of site sampled, WGS84Longitude of Station in Decimal Degrees (WGS 84 Datum)Water temperatureConcentration of green algae chlorophyll fluorescence in the water as measured by the FluoroProbe instrument.Concentration of cyanobacterial chlorophyll fluorescence in the water as measured by the FluoroProbe instrument.Total concentration of diatom fluorescence in the water as measured by the FluoroProbe instrument.Total concentration of cryptophyte fluorescence in the water as measured by the FluoroProbe instrument.Total concentration of yellow pigemented substance fluorescence in the water as measured by the FluoroProbe instrument.Total concentration of chlorophyll fluorescence in the water as measured by the FluoroProbe instrument.Group collecting the data
Storage Type:dateTime  
float  
float  
float  
float  
float  
float  
float  
float  
float  
string  
Measurement Type:dateTimeratioratioratioratioratioratioratioratiorationominal
Measurement Values Domain:
FormatYYYY-MM-DD hh:mm:ss
Precision
Unitdegree
Typereal
Unitdegree
Typereal
Unitcelsius
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
UnitmicrogramPerLiter
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeDWR
DefinitionCalifornia Department of Water Resource's Environmental Monitoring Program
Source
Code Definition
CodeUSGS
DefinitionUS Geological Survey California Water Science Center
Source
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/1337/3/0d49aa2012e93b42ee8d9ccdd3fc7950
Name:Vegetation regional area estimates
Description:UC Davis CSTARS analysis of hyperspectral imagery giving area covered by aquatic vegetation by region and year.
Number of Records:98
Number of Columns:7

Table Structure
Object Name:ucd_imagery_regional_area_estimates.csv
Size:6983 byte
Authentication:9ef703f056a5f636610750e0d87c041c 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
 siteyearmonthveg_typearea_haarea_prop_harea_prop_w
Column Name:site  
year  
month  
veg_type  
area_ha  
area_prop_h  
area_prop_w  
Definition:Open water region of the Delta (see supplemental maps)Calendar yearMonth of the year when imagery was collectedGrowth form of vegetation (floating or submersed)Area of vegetationProportion of total area covered by vegetation. Total area of sites based on UC-Davis CSTARS polygonsProportion of total area covered by vegetation. Total area of sites based on Division of Boating & Waterways polygons
Storage Type:string  
float  
string  
string  
float  
float  
float  
Measurement Type:nominalrationominalnominalratioratioratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeBig Break
DefinitionBig Break
Source
Code Definition
CodeClifton Court
DefinitionClifton Court Forebay
Source
Code Definition
CodeDelta Common Area
DefinitionAll areas of the Delta surveyed in all years (North and Central Delta only, not full legal Delta)
Source
Code Definition
CodeFranks Tract
DefinitionFranks Tract
Source
UnitnominalYear
Typeinteger
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code6
DefinitionJune
Source
Code Definition
Code7
DefinitionJuly
Source
Code Definition
Code9
DefinitionSeptember
Source
Code Definition
Code10
DefinitionOctober
Source
Code Definition
Code11
DefinitionNovember
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Codefav
DefinitionFloating aquatic vegetation
Source
Code Definition
Codesav
DefinitionSubmersed aquatic vegetation
Source
Unithectare
Typereal
Unitdimensionless
Typereal
Unitdimensionless
Typereal
Missing Value Code:              
Accuracy Report:              
Accuracy Assessment:              
Coverage:              
Methods:              

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/2e5cdb780f00d927e90a28f5c2ef8180
Name:Franks Tract Fluridone_2006-2021
Description:Fluridone (herbicide) treatments at Franks Tract
Number of Records:16
Number of Columns:4

Table Structure
Object Name:franks_tract_fluridone_2006-2021_summary.csv
Size:466 byte
Authentication:42ca1d03ff37065c771f77c7a47a379f Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 yearfl_rate_ppbfl_area_hafl_quantity_kg
Column Name:year  
fl_rate_ppb  
fl_area_ha  
fl_quantity_kg  
Definition:Year of treatmentEstimated field concentration of fluridone based on amount of fluridone added and mean volume of water of siteArea treated with Fluridonetotal amount of Fluridone used
Storage Type:float  
float  
float  
float  
Measurement Type:ratioratioratioratio
Measurement Values Domain:
UnitnominalYear
Typeinteger
Unitppb
Typereal
Unithectare
Typereal
Unitkilogram
Typereal
Missing Value Code:  
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/1337/3/da6f3b260261e36c098a95618918674b
Name:discrete_wq&outflow_data_summary
Description:Suite of environmental variables hypothesized to affect or be affected by aquatic vegetation. Variables were generally collected in or near focal sites. Values are means of monthly measurements taken during the period each year expected to foster the most vegetation growth, March-October.
Number of Records:42
Number of Columns:9

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

Table Column Descriptions
 StationyearTemperatureConductivitySalinitySecchiDissolvedOxygenpHout_mean
Column Name:Station  
year  
Temperature  
Conductivity  
Salinity  
Secchi  
DissolvedOxygen  
pH  
out_mean  
Definition:Name of the locality where data were collectedCalendar yearMean water temperatureMean water conductivityMean salinitymean Secchi depthmean dissolved oxygenmean water pHmean outflow of the Sacramento-San Joaquin Delta
Storage Type:string  
float  
float  
float  
float  
float  
float  
float  
float  
Measurement Type:nominalratioratioratioratioratioratioratioratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code853
DefinitionCalifornia Department of Fish and Wildlife Bay Study Station 853 (near Big Break)
Source
Code Definition
CodeC9
DefinitionCalifornia Department of Water Resources Environmental Monitoring Program station C9 (Clifton Court)
Source
Code Definition
CodeD19
DefinitionCalifornia Department of Water Resources Environmental Monitoring Program station D19 (in Franks Tract)
Source
UnitnominalYear
Typeinteger
Unitcelsius
Typereal
UnitmicroSiemensPerCentimeter
Typereal
Unitdimensionless
Typereal
Unitcentimeter
Typereal
UnitmilligramPerLiter
Typereal
Unitdimensionless
Typereal
UnitfootCubedPerSecond
Typereal
Missing Value Code:        
CodeNA
Expldata was not yet available
CodeNA
Explgenerally because data for this variable not collected at a station
CodeNA
Expldata for this variable not collected at a station
CodeNA
Expldata for this variable not collected at a station
 
Accuracy Report:                  
Accuracy Assessment:                  
Coverage:                  
Methods:                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/dfab3c259c1bd7b6325604d9a0a475a3
Name:CSTARS_2021_FT&BB_Formatted_EDI
Description:Field sampling of submersed aquatic vegetation in Franks Tract and Big Break by the UC-Davis CSTARS lab. Sampling was conducted using a weighted thatch rake head attached to a rope.
Number of Records:160
Number of Columns:8

Table Structure
Object Name:CSTARS_2021_FT&BB_Formatted_EDI.csv
Size:14299 byte
Authentication:33b34bc82d5b0631bec0cde541313681 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 sitesample_idlatitude_wgs84longitude_wgs84daterake_teeth_corrspeciesrake_prop
Column Name:site  
sample_id  
latitude_wgs84  
longitude_wgs84  
date  
rake_teeth_corr  
species  
rake_prop  
Definition:open water area where sampling was conductedunique identifier for each samplelatitude of sample location in WGS84longitude of sample location in WGS84sampling datePercent of the rake head covered in submersed aquatic vegetation, estimated to the nearest 10%type of submersed aquatic vegetation in the sample. Typically species (format = Genus_specific epithet)Percentage of the vegetation comprised of a given vegetation type, estimated to nearest 10%
Storage Type:string  
float  
float  
float  
dateTime  
float  
string  
float  
Measurement Type:nominalratioratioratiodateTimerationominalratio
Measurement Values Domain:
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeBig Break
DefinitionBig Break
Source
Code Definition
CodeFranks Tract
DefinitionFranks Tract
Source
Unitdimensionless
Typeinteger
Unitdimensionless
Typereal
Unitdimensionless
Typereal
FormatYYYY-MM-DD
Precision
Unitpercent
Typeinteger
Definitiontext
Unitpercent
Typereal
Missing Value Code:            
CodeNA
Explempty rake with no vegetation
CodeNA
Explempty rake with no vegetation
Accuracy Report:                
Accuracy Assessment:                
Coverage:                
Methods:                

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/29aa82b792a1972386673df985b4dd25
Name:FranksTractManagement_2014-2021_formatted_edi
Description:Submersed aquatic vegetation monitoring data produced by SePRO and Division of Boating and Waterways. Available data are from surveys conducted annually in October of 2014-2021. Samples collected using a thatch rake head attached to a rope.
Number of Records:12675
Number of Columns:9

Table Structure
Object Name:FranksTractManagement_2014-2021_formatted_edi.csv
Size:860411 byte
Authentication:4ad6346f62f6b54ac6fd4f2606bc55a5 Calculated By MD5
Text Format:
Number of Header Lines:1
Record Delimiter:\n
Orientation:column
Simple Delimited:
Field Delimiter:,
Quote Character:"

Table Column Descriptions
 stationsample_idlatitude_wgs84longitude_wgs84datesav_incidencespeciesspecies_incidencerake_coverage_ordinal
Column Name:station  
sample_id  
latitude_wgs84  
longitude_wgs84  
date  
sav_incidence  
species  
species_incidence  
rake_coverage_ordinal  
Definition:Name of station where sample collectedunique identifier for each samplelatitude of sample location in WGS84longitude of sample location in WGS84sampling dateindicates whether submersed aquatic vegetation was present in samplename of species found in sample (format = Genus_specific epithet)indicates whether a species was present in a sampleOrdinal score for the abundance of each species in the sample. During 2014-2018, scores ranged 0-4 and from 2019 onward, scores ranged 0-5
Storage Type:string  
float  
float  
float  
dateTime  
string  
string  
string  
string  
Measurement Type:nominalratioratioratiodateTimenominalnominalnominalnominal
Measurement Values Domain:
Definitiontext
Unitdimensionless
Typeinteger
Unitdimensionless
Typereal
Unitdimensionless
Typereal
FormatYYYY-MM-DD
Precision
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code0
DefinitionSAV absent
Source
Code Definition
Code1
DefinitionSAV present
Source
Definitiontext
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code0
Definitionspecies absent
Source
Code Definition
Code1
Definitionspecies present
Source
Allowed Values and Definitions
Enumerated Domain 
Code Definition
Code0
Definition0% of rake covered
Source
Code Definition
Code1
Definition1-19% of rake covered
Source
Code Definition
Code2
Definition20-39% of rake covered
Source
Code Definition
Code3
Definition40-59% of rake covered
Source
Code Definition
Code4
Definition60-79% of rake covered
Source
Code Definition
Code5
Definition80-100% of rake covered
Source
Missing Value Code:    
CodeNA
Explmissing data
CodeNA
Explmissing data
         
Accuracy Report:                  
Accuracy Assessment:                  
Coverage:                  
Methods:                  

Data Table

Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/d0b670b8cad6e27ff149815d2f46e0f0
Name:Water Year Assignments
Description:Sacramento Valley Hydrologic index and water year classification by water year.
Number of Records:52
Number of Columns:3

Table Structure
Object Name:WaterYearAssignments.csv
Size:986 byte
Authentication:1e73893b731733255ccd21dab3f73682 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
 YearIndexYr_type
Column Name:Year  
Index  
Yr_type  
Definition:Water Year (Oct 1 of previous calendar year through Sep 30 of current year)Sacramento Valley Hydrologic Index, from: https://cdec.water.ca.gov/reportapp/javareports?name=WSIHIST Sacramento Valley water year type
Storage Type:float  
float  
string  
Measurement Type:ratiorationominal
Measurement Values Domain:
UnitnominalYear
Typeinteger
Unitdimensionless
Typereal
Allowed Values and Definitions
Enumerated Domain 
Code Definition
CodeCritical
DefinitionSacramento Valley Index equal or less than 5.4
Source
Code Definition
CodeDry
DefinitionSacramento Valley Index greater than 5.4, less than or equal to 6.5
Source
Code Definition
CodeBelow Normal
DefinitionSacramento Valley Index greater than 6.5, and equal to or less than 7.8
Source
Code Definition
CodeAbove Normal
DefinitionSacramento Valley Index Greater than 7.8, and less than 9.2
Source
Code Definition
CodeWet
DefinitionSacramento Valley Index Equal to or greater than 9.2
Source
Missing Value Code:      
Accuracy Report:      
Accuracy Assessment:      
Coverage:      
Methods:      

Non-Categorized Data Resource

Name:Supplemental figures for HABsWeeds
Entity Type:pdf
Description:Maps, figures, and tables with additional information.
Physical Structure Description:
Object Name:Supplemental figures for HABsWeeds.pdf
Size:2309202 byte
Authentication:7a20c0ec5c6e6d2ccbffc7b209c1c417 Calculated By MD5
Externally Defined Format:
Format Name:pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/b2332bd61edf1bf08bc1135987022238

Non-Categorized Data Resource

Name:HAB-Weed_Report_2022_10_14
Entity Type:pdf
Description:Report on the impact of the 2021 TUCP and Emergency Drought Barrier on Harmful Algal Blooms and Aquatic Weeds in the Sacramento San Joaquin Delta
Physical Structure Description:
Object Name:HAB-Weed_Report_2022_10_14.pdf
Size:18325518 byte
Authentication:002643fd10700a8a597dd29c0d5a67fe Calculated By MD5
Externally Defined Format:
Format Name:pdf
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/b75e1454978c3d04498a8335990223c9

Non-Categorized Data Resource

Name:HABRegions
Entity Type:zip
Description:Zipped file containing regions of the Delta used for analysis as an ESRI shapefile and as an sf object in an RData file
Physical Structure Description:
Object Name:HABRegions.zip
Size:6331 byte
Authentication:9a4d78daa63c4132a8484a65723f5cb2 Calculated By MD5
Externally Defined Format:
Format Name:zip
Data:https://pasta-s.lternet.edu/package/data/eml/edi/1337/3/cc82abf9c9fa192e06492a9d9bd69da7

Data Package Usage Rights

This information is released under the Creative Commons license - Attribution - CC BY (https://creativecommons.org/licenses/by/4.0/). The consumer of these data ("Data User" herein) is required to cite it appropriately in any publication that results from its use. The Data User should realize that these data may be actively used by others for ongoing research and that coordination may be necessary to prevent duplicate publication. The Data User is urged to contact the authors of these data if any questions about methodology or results occur. Where appropriate, the Data User is encouraged to consider collaboration or co-authorship with the authors. The Data User should realize that misinterpretation of data may occur if used out of context of the original study. While substantial efforts are made to ensure the accuracy of data and associated documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is." The Data User should be aware, however, that data are updated periodically and it is the responsibility of the Data User to check for new versions of the data. The data authors and the repository where these data were obtained shall not be liable for damages resulting from any use or misinterpretation of the data. Thank you.

Keywords

By Thesaurus:
LTER Controlled Vocabularywater quality, phytoplankton, bacteria, vegetation, aquatic ecosystems, dissolved nutrients, estuaries, invasive species
(No thesaurus)cyanobacteria, Interagency Ecological Program, toxin

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:

Visual Index Data

These are the methods used for mc_vis_index_wq.csv.

Most monitoring surveys that collect data on water quality and fisheries in the Delta also collect visual observations of Microcystis and other visually detectable algal blooms. Because Microcystis colonies are relatively easy to identify visually in the field, this visual ranking gives a general idea of when and where the most common harmful cyanobacteria in the Delta occur

A surface water sample is brought on board a research vessel in a bucket and the Microcystis concentration is ranked on a scale of 1–5, 1 meaning “absent” and 5 meaning “very high” (Flynn et al. 2022) (supplemental PDF figure 1). Although this method is imprecise, it is generally reliable on the whole for detecting Microcystis and giving a rough estimate of magnitude

Visual assessment data for this report come from five surveys. Data sets were also subset to only include observations in the Legal Delta, categorized into regions shown in the supplemental PDF (Figure 2).

Data sources:

• The Environmental Monitoring Program (EMP) is conducted jointly by DWR, the California Department of Fish and Wildlife (CDFW), and Reclamation and collects water quality, phytoplankton, zooplankton, and benthic invertebrate data throughout the Delta, Suisun Bay, and San Pablo Bay. The EMP has recorded Microcystis observations at each of its discrete stations since fall 2015, using the scale shown in Figure 2 2. The EMP also collects data on phytoplankton community composition via microscopic enumeration of grab samples, allowing an evaluation of which species are contributing to phytoplankton blooms. These data are collected at 24 fixed stations and up to four floating stations each month throughout the year (IEP 2020). These data are published annually on the Environmental Data Initiative repository.

• 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 (Figure 2 2). The survey primarily monitors young-of-the-year fishes, but also measures zooplankton and environmental variables including water temperature (°C), water clarity (Secchi depth and nephelometric turbidity units [NTU]), and specific conductance (microSiemens per centimeter [µS/cm]). Visual observations of Microcystis have been collected since 2007. STN data are available via the CDFW website.

https://filelib.wildlife.ca.gov/Public/TownetFallMidwaterTrawl/TNS%20MS%20Access%20Data/TNS%20data/

• 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, and November at 122 stations (Figure 2 2). The FMWT survey primarily monitors young-of-the-year fishes, but also measures zooplankton and environmental variables including water temperature (°C), water clarity (Secchi depth and NTU), and specific conductance (µS/cm). Visual observations of Microcystis have been collected since 2007. FMWT data are available via the CDFW website. https://filelib.wildlife.ca.gov/Public/TownetFallMidwaterTrawl/FMWT%20Data/

• DWR’s North Central Region Office (NCRO) conducts water quality and cyanoHAB sampling at stations throughout the South Delta (Figure 2 2). These samples include chlorophyll, nutrients, bromide, and organic carbon. When water samples are collected, the study also measures environmental variables including water temperature (°C), water clarity (Secchi depth and NTU), specific conductance (µS/cm), and a visual Microcystis index. NCRO data are available from DWR’s Water Data Library platform. https://wdl.water.ca.gov/waterdatalibrary/Map.aspx

Data Source
DWR's Water Data Library
Data Source
Fall Midwater Trawl Data
Data Source
Summer Townet Survey
Data Source
Environmental Monitoring Program
Description:

Nutrient Data

These are the methods used to create the disc_nutr_chla.csv file.

Discrete nutrient (ammonium, nitrate + nitrite, and orthophosphate) and chlorophyll-a data were collected from four sources:

• The EMP collects discrete water quality grab samples at all stations where samples for phytoplankton community composition are collected. Water is collected using a flow-through system in which it is pumped into the shipboard laboratory either from a fixed intake 1 meter below the water’s surface, or from a Van Dorn water sampler, or via a submersible pump (IEP 2020). DWR’s Bryte Laboratory performed analyses for dissolved ammonium, dissolved nitrate + nitrite (hereafter referred to as “nitrate”), total Kjeldahl nitrogen, total phosphorus, dissolved orthophosphate, and chlorophyll-a, using EPA methods, American Public Health Association Standard Methods, or DWR-approved modifications of these methods (IEP 2020).

• The DWR NCRO collects discrete nutrient and chlorophyll-a data at six locations in the Central Delta surrounding Franks Tract. Chlorophyll-a samples were collected routinely from 2014 through 2021, while nutrient samples were collected only in 2014–2016 and 2021. Water is collected from a Van Dorn water sampler at a depth of 1 meter (DWR 2022). DWR’s Bryte Laboratory analyzed the samples using EPA methods or DWR-approved modifications of these methods (IEP 2020).

• The U.S. Geological Survey (USGS) has two programs that routinely collect discrete nutrient and chlorophyll-a data in the Delta: the California Water Science Center (CAWSC) and the San Francisco Bay Water Quality Survey (SFBS). The CAWSC collects samples at numerous locations throughout the Delta; the SFBS collects most of its samples downstream of the Delta, with a few locations extending into the Delta. The SFBS has been collecting discrete water quality samples from 1969 to present, while the CAWSC began collecting samples more recently.

• Data collected in 2014–2021 from the four surveys listed above were acquired through direct data requests or downloaded from either the discretewq data package (Bashevkin 2022), DWR’s Water Data Library, or the National Water Quality Monitoring Council’s Water Quality Portal. Data were integrated into one data set, limiting the stations to only those where all three nutrient parameters (ammonium, nitrate, and orthophosphate) and chlorophyll-a were collected. Some of the data collected in 2021 were considered provisional at the time of acquisition.

Outliers were identified as any value with a modified Z-score greater than 15 when the data were grouped by region. All identified nitrate and orthophosphate outliers were excluded from the data set. The detected ammonia and chlorophyll-a outliers were not removed because they appeared to be representative based on best professional judgment. Nutrient values that were below the reporting limit but had high reporting limits compared to the range of the overall data (greater than the 75th quantile) were excluded from the data set. In addition, the most common reporting limit for the laboratory method was used to estimate the reporting limit values for the nutrient data with missing reporting limit values. Additional details on data integration and processing can be found in the EDBdata GitHub package: https://github.com/mountaindboz/EDBdata.

Data Source
Interagency Ecological Program: Discrete water quality monitoring in the Sacramento-San Joaquin Bay-Delta, collected by the Environmental Monitoring Program, 1975-2021.
Data Source
Water Quality Portal
Data Source
Six decades (1959-2021) of water quality in the upper San Francisco Estuary: an integrated database of 15 discrete monitoring surveys in the Sacramento San Joaquin Delta, Suisun Bay, Suisun Marsh, and San Francisco Bay
Description:

Community Composition

These are the methods used to create the phyto_hab.csv file

Phytoplankton community composition data was obtained by microscopy from samples collected by EMP. These data were collected at 24 fixed stations and two stations that track the location of the salinity field each month throughout the year (see supplemental map, figure 2). Phytoplankton samples were collected with a submersible pump from a water depth of 1 meter below the water surface. Samples were stored in 50-milliliter (mL) glass bottles with 2 mL of Lugol’s iodine solution to act as a stain and preservative. Samples were analyzed by BSA Environmental Services, Inc. (Beachwood, Ohio). Phytoplankton were identified to the lowest taxonomic level possible, using the Utermöhl method and American Public Health Association Standard Method 10200 F (Utermöhl 1958, APHA 2017).

These data were subset to show only cyanoHABs species, defined as species in the genera Anabaeopsis, Aphanizomenon, Cylindrospermopsis, Dolichospermum, Oscillatoria, Planktothrix, and Microcystis. Although Microcystis is occasionally collected by these grab samples at a depth of 1 meter, particularly when the water column is well-mixed, it is better assessed by surface tows. These data are included to provide an idea of which taxa were present in the community, but the data should not be taken as a quantitative assessment of Microcystis abundance.

Data Source
Interagency Ecological Program: Phytoplankton monitoring in the Sacramento-San Joaquin Bay-Delta, collected by the Environmental Monitoring Program, 2008-2021
Description:

Satellite Imagery

This was used to create the hab_sat_ow_delta.csv file.

Satellite data, available from the San Francisco Estuary Institute’s HAB Satellite Analysis Tool (San Francisco Estuary Institute 2021), provides estimates of cyanobacterial. Satellite imagery is collected by the Ocean Land Color Instrument on the Copernicus Sentinel-3 mission. The cyanobacterial index algorithm (Wynne et al. 2018) is applied to the Ocean Land Color Instrument data to estimate cyanobacterial abundance in the upper portion of the water column by analyzing wavelengths of light that interact strongly with chlorophyll-a and phycocyanin, an accessory pigment in photosynthesis specific to cyanobacteria. Estimates of cyanobacteria abundance are reported in an exponential, satellite-specific, unitless metric called the Cyanobacteria Index (CI) for pixels with dimensions of 300 meters by 300 meters, each an area of approximately 22 acres.

Satellite mosaics of rasterized CI data across the Central Delta for June–October in 2020 and 2021 were downloaded from the San Francisco Estuary Institute’s HAB Satellite Analysis Tool (San Francisco Estuary Institute 2021). Raster pixels for four open-water regions in the Delta (Franks Tract, Clifton Court Forebay, Liberty Island, and Mildred Island) were extracted from each file using the ‘exact_extract’ function in the ‘exactextractr’ R package, version 0.7.1 (Baston 2021). The four open-water regions were defined using polygons derived from CDFW’s shapefile of Delta waterways and expanded by 200 meters around their perimeters to account for the large raster pixels.

Pixels were categorized into four CI categories (Low, Moderate, High, and Very High) based on WHO’s recreational guidance level thresholds (WHO 2021). Additionally, pixels that were below the detection limit for the imagery processing method (CI ≤ 6.310 x 10-05) were categorized as “Non Detect,” and pixels that were either invalid or missing were categorized as such. Including only pixels that were completely within one of the polygons of the four regions, the numbers of pixels within the “Non Detect,” “Invalid,” and four CI categories were counted for each region and raster image. Using only days when there were greater than 25 percent valid pixels within a region, the time series of pixel counts were visualized using area plots for each region and year.

Description:

Cyanotoxin data

This was used to create 'hab_toxins.csv'

The cyanotoxin data collected in 2021 and presented here came from six different sources (Figure 3, Table 1 in supplemental figures). Some of these sources had data available from previous years, but the majority of the data was from 2021, so only 2021 data are presented here, with the exception of Big Break, which contains data from 2015-2021. These studies all used either enzyme-linked immunosorbent assay (ELISA), liquid chromatography–mass spectrometry (LC-MS), liquid chromatography with tandem mass spectrometry (LC-MS/MS), or Abraxis test strips to analyze toxin concentrations. There is generally very high agreement between these two methods, although ELISA may produce higher concentration values than LC-MS/MS (Preece et al. 2021). Across most of the national harmful algal bloom (HAB) research community, data from either method are compared to thresholds, and no conversion factor is applied, nor is one method disregarded. Locations of samples are shown in supplemental pdf Figure 3 and Table 1.

• DWR collects cyanotoxin samples at Clifton Court Forebay and the Harvey O. Banks Pumping Plant (Banks Pumping Plant) to ensure that the water exported from the Delta is safe for use. Samples are collected every two weeks in April–October and analyzed by GreenWater Laboratories (Palatka, Florida), using a tiered approach. Samples are first assessed via microscopy to identify whether potentially toxic algae or cyanobacteria are present. If potentially toxic algae are detected, cells are lysed and samples are then tested for probable toxins using either ADDA-ELISA or LC-MS/MS, as appropriate (Foss and Aubel 2015).

• A special study was conducted collaboratively by USGS and DWR with funding from the Delta Regional Monitoring Program. Samples were collected at several stations throughout the Delta: Jersey Point (JPT), Decker (DEC), Middle River (MDM), Liberty Island (LIB), Rough and Ready Island (P8, DWR-EMP), and Vernalis (C10, DWR-EMP). For these efforts, cyanotoxins were measured in whole water discrete samples and using Solid Phase Adsorption Toxin Tracking (SPATT) samplers every two to four weeks. SPATTs are synthetic resin plates deployed in the water for an extended time to determine whether toxins are present over the entire time period. All (100 percent) of these cyanotoxin samples were to be analyzed using LC-MS/MS, and—upon review of LC-MS/MS data—a subset (approximately 20 percent) would be selected for analysis using ELISA. All laboratory analyses were conducted by Lumigen Instruments, Wayne State University, Detroit, Michigan. Data from this study have not been approved by USGS and are considered preliminary.

• The California State Water Resources Control Board’s freshwater HAB program collects samples for cyanotoxins when large blooms are reported (CCHAB Network 2022a). A special study conducted Ellen Preece, (Robertson Bryan Inc), Tim Otten (Bend Genetics LLC) and Janis Cooke (Central Valley Regional Water Quality Control Board; CVRWQCB) included collection of water samples for cyanotoxin analyses. This project was supported by the Delta Regional Monitoring Program and the State Water Resources Control Board Freshwater Harmful Algal Bloom Program. The Central Valley RWQCB collected cyanotoxin samples A single subsurface water grab sample was collected from the eastern side of Franks Tract on July 2 and again on August 6, 2021 (Preece et al, in preparation). Samples were lysed and analyzed by Bend Genetics, LLC (Sacramento, California) for total microcystins/nodularins, using the ADDA ELISA method.

• A special study of bioaccumulation of cyanotoxins in invertebrates in the Delta was conducted by David Senn (San Francisco Estuary Institute), Janis Cooke (Central Valley Regional Water Quality Control BoardRWQCB), Ellen Preece (Robertson-Bryan, Inc.), and Timothy Otten (Bend Genetics) (Preece et al, in preparation). This work was funded by a State of California Proposition 1 grant administered by the Department of Fish and Wildlife Ecosystem Restoration Program. Whole-water samples were collected monthly in the winter and every two weeks during the summer and analyzed for microcystins by Bend Genetics using ADDA ELISA.

• The East Bay Regional Park District (East Bay Regional Parks) conducts sampling at Big Break Regional Shoreline, visually inspecting the water for signs of cyanobacteria twice per month. If signs of cyanobacteria are detected, microscopy and toxin analysis are conducted at Bend Genetics using ADDA ELISA. Staff at East Bay Regional Parks requested data. Because Big Break has a longer monitoring history than most of these programs, all data for 2015–2021 were requested to get a better sense of how droughts and drought actions affect this cyanoHAB “hot spot.”

• Nautilus Data Technologies is required to monitor for cyanotoxins near its data center at the Port of Stockton. Nautilus Data Technologies monitors at six sites on the San Joaquin River and in the Stockton Deep Water Ship channel twice per month. All water samples are sent to Bend Genetics, where the samples are analyzed for microcystins, anatoxins and saxitoxins using ADDA ELISA as appropriate. Data were requested from staff at the State Water Board’s cyanoHABs portal.

None of the sources of cyanotoxin data presented here are part of a comprehensive monitoring program.

• The USGS/DWR SPATT study and the Proposition 1 Senn/Preece/ Cooke/Otten studies were designed as special studies to better understand toxin dynamics, rather than to establish a baseline. The RWQCB data are designed as a response to severe blooms, not a comprehensive monitoring program.

• The DWR Banks Pumping Plant/Clifton Court Forebay monitoring is designed specifically to assess water quality for water export, so it is not necessarily applicable to the rest of the Delta.

• Nautilus data are limited to the San Joaquin River, so they are unlikely to be influenced by the TUCP.

Combining these data sets does provide a relatively wide spatial and temporal scope of cyanotoxin monitoring, although it may miss small-scale or short-lived toxin events, particularly in smaller, backwater sloughs in the Delta. Different labs and field collection crews may result in slight biases in the resulting data sets, but all these data can be compared to the health advisory levels in the same way.

Description:

Fluoroprobe Data

This was used to create the Fluoroprobe.csv file

The EMP and USGS both employ vessels equipped with high-resolution sensors that collect data continuously on both water quality and phytoplankton community composition while underway. Both surveys monitor the phytoplankton community’s composition using a FluoroProbe instrument (bbe moldaenke GmbH, Schwentinental, Germany) that differentiates between cyanobacteria, diatoms, green algae, and cryptophytes, based on the wavelength of the fluorescence given off by each taxonomic group’s characteristic photopigments. USGS conducted mapping surveys in May, July, and October 2021, while EMP surveys are collected monthly throughout the year. Each month, these agencies covered approximately 350 miles of channels in the Delta over three to four consecutive days. USGS boat-based survey data can be visualized using USGS’s online data portal (https://tableau.usgs.gov/views/SFBD_Data_Portal/Mapping2018and2020?%3Aembed=y&%3AisGuestRedirectFromVizportal=y). FluoroProbe data collected by both the EMP and USGS were processed following the methodology described in the Methods PDF of the USGS data (Bergamaschi et al. 2020).

Description:

Continuous Water Quality

This was used to create 'cont_wq_daily_avg.csv', 'air_temp_daily_dd.csv' and 'water_temp_daily_dd.csv'

DWR and USGS maintain a network of water quality sondes and flow stations that collect data continuously (i.e., every 15 minutes) across the Delta (locations in supplemental pdf Figure 4). These stations collect data on water temperature, specific conductance, flow, DO, chlorophyll fluorescence, turbidity, and pH (although not all stations contain all sensors; see Table 2 in supplemental metadata file). Quality-controlled data were requested from DWR personnel when available, and provisional data were queried from the California Data Exchange Center (CDEC) if no finalized data were available.

To see how extended periods of high temperatures may drive Microcystis blooms, the number of degree-days over 19°C was calculated by averaging the daily maximum and minimum water temperature at seven stations in the South Delta. Degree-days are frequently used as a way to characterize total ambient thermal energy over the course of the year, and degree-days is considered a better measure of temperature regime than average temperature when predicting cyanobacterial abundance (Dupuis and Hann 2009, Pick 2016, Larson et al. 2018). This was converted to degree-days using the formula:

Degree-days = (Daily Max Temp – Daily Min Temp)/2 – 19

The same analysis was then conducted on air temperature, to see whether air temperature patterns were similar to water temperature patterns. Air temperature was not available for most stations in the Delta, but the nearest stations to the study region were chosen (Figure 4, Table 2 in supplemental information).

Description:

Hyperspectral Imagery Ground-Truthing

Around the time that hyperspectral imagery is collected each year, the CSTARS staff collects ground-truthing field data on the community composition of aquatic vegetation across the Delta, including areas in and around Franks Tract and Big Break. They have not sampled at Clifton Court Forebay because access to that area is restricted. Efforts are ongoing to clean and integrate the SAV data from this time series, but the authors of this report were able to acquire and present the data for 2021.

In 2021, this field survey took place from late July to mid-August. In Franks Tract (supplemental pdf Figure 6) and Big Break (Figure 7), the CSTARS staff sampled for SAV at 47 sites and 30 sites, respectively. A thatch rake with 34 teeth tethered with a long rope was used to collect rake samples. The rake was thrown off the side of the boat into the patch and allowed to sink to the bottom of the water column and then dragged in and pulled up. They recorded all species collected on the rake, as well as the percentage of the sample volume each species represented, to the nearest 10 percent.

Data Source
Submersed Aquatic Vegetation community multi-year data from the Sacramento - San Joaquin Delta in California
Description:

Hyperspectral Imagery

Since 2004, hyperspectral airborne imagery has been collected by fixed-wing aircraft over the Delta in many years, although the time of year and spatial extent of these surveys have varied. Franks Tract has been included in all surveyed years (2004–2008, 2014–2021, see Figure 5 in Supplemental Figures file).

Survey methods for the hyperspectral imagery have varied somewhat among years, but the approach generally proceeds as described here for the 2018 survey. During this survey, HyVista Corporation (Sydney, Australia) used the HyMap sensor (126 bands: 450–2,500 nanometers, bandwidth: 10–15 nanometers) to collect imagery at a resolution of 1.7 meters by 1.7 meters. A diverse suite of inputs was derived from these images to capture reflectance properties across different regions of the electromagnetic spectrum, which track biophysiological characteristics useful for distinguishing types of plants. These intermediate inputs were generated using IDL scripts (IDL 8.01, ITT Visual Information Solutions) in ENVI (ENVI 4.8, ITT Visual Information Solutions).

Concurrent with imagery collection, ground-truthing surveys were conducted to determine species composition at points across the Delta region (e.g., 2018: 950 points; see the “Hyperspectral Imagery Ground-Truthing ” section for details). Field data were divided into training and validation subsets for image classification and independent validation of class maps. Training and validation polygons were overlaid on the raster images with generated inputs, and corresponding pixels within the raster images were extracted using the R statistical computing language (Version 4.0.2; R Core Team 2021) and packages ‘sp’ (Version 1.4.5) (Pebesma and Bivand 2021), ‘rgdal’ (version 0.5.5) (Bivand et al. 2021), and ‘rgeos’ (Version 1.5.23).

Training data were fed into a Random Forests classifier (packages ‘raster’: Version 3.4.5 (Hijmans 2021) and ‘randomforest’: Version 4.6.14 (Breiman 2001). The best-fit class type (e.g., open water, SAV, water hyacinth, water primrose) for each pixel was chosen based on consistency across tree predictions. The accuracy of the final maps was assessed using confusion matrices and Kappa coefficients. The area of SAV was calculated per year, per site, as the number of pixels classified as SAV multiplied by the area of a single pixel. FAV area was calculated in the same way, except that it is a combined category that includes water hyacinth, water primrose, and a mixed class composed of water primrose and emergent vegetation.

Data Source
The Sacramento-San Joaquin Delta genus and community level classification maps derived from airborne spectroscopy data.
Description:

SePRO Vegetation Survey

DBW collaborates with SePRO Corporation to manage SAV in Franks Tract using the herbicide fluridone (Caudill et al. 2019). SePRO monitors changes in SAV community composition using point-intercept surveys (Madsen and Wersal 2018) that are conducted on one date annually in the fall.

Sampling points are chosen by generating a grid of evenly spaced points projected over the full area of Franks Tract (Figure 8, supplemental figures). The number of sampling points varies among years but is usually 100 (range: 50–200 samples). Most surveys have been conducted in mid October (range: October 1–October 13).

To sample each point, SePRO uses a weighted, double-headed, 0.33-meter-wide thatch rake attached to a rope, which is dragged for approximately 3 meters along the bottom and then pulled up to the boat for analysis. All SAV present on the rake is identified to species, and species-specific abundances are estimated based on the percentage of the rake each covers. Abundances are recorded using ordinal scores. During 2014-2018, scores ranged 1-4 (1 = 1–24 percent, 2 = 25–49 percent, 3 = 50–74 percent, 4 = 75–100 percent) and from 2019 onward, scores ranged 1-5 (1 = 1–19 percent, 2 = 20–39 percent, 3 = 40–59 percent, 4 = 60–79 percent, 5 = 80–100 percent).

Description:

Environmental drivers for weed data

Aquatic weed data were compared with water quality, flow, velocity, and herbicide application data to determine the drivers of variation in the abundance and composition of aquatic weeds. Variables hypothesized to affect aquatic weeds included measures of flow, turbidity, salinity, temperature, and herbicide applications (Figure 3-1). The analyses also included DO and pH, variables that are hypothesized to be affected by aquatic weeds.

Net Delta outflow data were obtained from DWR’s Dayflow model (DWR 2002). For water quality, monthly data were obtained from DWR’s EMP Station D19 (Franks Tract) and DFW’s Bay Study Station 853 (San Joaquin River just west of Big Break). The data for EMP Station C9 (Clifton Court) did not begin until recently (2016), so environmental drivers for this reference site were not considered. Discrete water quality stations were chosen over continuous stations for Franks Tract and Big Break because the discrete stations covered most parameters of interest for all years of aquatic vegetation monitoring (hyperspectral imagery started in 2004), whereas most continuous stations did not. As an exception, Bay Study Station 853 does not include DO or pH. For flow and water quality variables, annual means based on the main growing season for aquatic weeds (March–October) were used. Herbicide application data for Franks Tract (Table 3-1) and Clifton Court Forebay (Table 3-2) were obtained from DBW and DWR, respectively. The authors of this report are not aware of site-wide herbicide treatments in Big Break.

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

References cited in methods

American Public Health Association (APHA). 2017. Standard methods for the examination of water and wastewater. 23 edition. American Public Health Association, American Water Works Association, and Water Environment Federation,

Bashevkin, S. M. 2022. Six decades (1959-2020) of water quality in the upper San Francisco Estuary: an integrated database of 11 discrete monitoring surveys in the Sacramento San Joaquin Delta, Suisun Bay, and Suisun Marsh ver 2. Environmental Data Initiative. . https://doi.org/10.6073/pasta/dc199c9fd9c452337f01bcd9f0a89f50

Baston, D. 2021. exactextractr: Fast Extraction from Raster Datasets using Polygons. Comprehensive R Archive Network (CRAN), https://cran.r-project.org/web/packages/exactextractr/index.html

Bergamaschi, B. A., T. E. Kraus, B. D. Downing, J. Soto Perez, K. O'Donnell, J. A. Hansen, A. M. Hansen, A. D. Gelber, and E. B. Stumpner. 2020. Assessing spatial variability of nutrients and related water quality constituents in the California Sacramento-San Joaquin Delta at the landscape scale: High resolution mapping surveys: U.S. Geological Survey data release, . https://doi.org/10.5066/P9FQEUAL

Bivand, R., T. Keitt, and B. Rowlingson. 2021. Package 'rgdal': Bindings for the 'Geospatial' Data Abstraction Library. Comprehensive R Archive Network (CRAN), http://rgdal.r-forge.r-project.org/

Breiman, L. 2001. Random Forests. Machine Learning 45:5-32. 10.1023/A:1010933404324

Caudill, J., A. R. Jones, L. Anderson, J. D. Madsen, P. Gilbert, S. Shuler, and M. A. Heilman. 2019. Aquatic plant community restoration following the long-term management of invasive Egeria densa with fluridone treatments. Management of Biological Invasions 10:473-485. https://doi.org/10.3391/mbi.2019.10.3.05

DWR. 2022. Quality Assurance Project Plan: Central Delta and Emergency Drought Barrier Water Quality Monitoring Program. California Department of Water Resources, West Sacramento, CA,

Flynn, T., P. Lehman, S. Lesmeister, and S. Waller. 2022. A Visual Scale for Microcystis Bloom Severity. figshare Figure. https://doi.org/10.6084/m9.figshare.19239882.v1

Foss, A. J., and M. T. Aubel. 2015. Using the MMPB technique to confirm microcystin concentrations in water measured by ELISA and HPLC (UV, MS, MS/MS). Toxicon 104:91-101. https://doi.org/10.1016/j.toxicon.2015.07.332

Hijmans, R. J. 2021. Package 'raster': Geographic Data Analysis and Modeling. Comprehensive R Archive Network (CRAN), https://rspatial.org/raster

Interagency Ecological Program (IEP), S. Lesmeister, and M. Martinez. 2020. Interagency Ecological Program: Discrete water quality monitoring in the Sacramento-San Joaquin Bay-Delta, collected by the Environmental Monitoring Program, 2000-2018. ver 2. . Environmental Data Initiative. https://doi.org/10.6073/pasta/a215752cb9ac47f9ed9bb0fdb7fc7c19

Khanna, S., S. L. Ustin, E. L. Hestir, M. J. Santos, and M. Andrew. 2022. The Sacramento-San Joaquin Delta genus and community level classification maps derived from airborne spectroscopy data. Knowledge Network for Biocomplexity. http://doi.org/10.5063/F1K9360F

Madsen, J. D., and R. M. Wersal. 2018. Proper survey methods for research of aquatic plant ecology and management. Journal of aquatic plant management 56:90-96,

Pebesma, E., and R. Bivand. 2021. Package 'sp': Classes and Methods for Spatial Data. Version 1.4-6. Comprehensive R Archive Network (CRAN), https://github.com/edzer/sp/ https://edzer.github.io/sp/

Preece, E. P., W. Hobbs, F. J. Hardy, L. O’Garro, E. Frame, and F. Sweeney. 2021. Prevalence and persistence of microcystin in shoreline lake sediments and porewater, and associated potential for human health risk. Chemosphere 272:129581. https://doi.org/10.1016/j.chemosphere.2021.129581

Utermöhl, H. 1958. Methods of collecting plankton for various purposes are discussed. SIL Communications, 1953-1996 9:1-38. 10.1080/05384680.1958.11904091

World Health, O. 2021. WHO guidelines on recreational water quality: volume 1: coastal and fresh waters. World Health Organization, Geneva, https://apps.who.int/iris/handle/10665/342625

Wynne, T., A. Meredith, T. Briggs, W. Litaker, and M. p. d. R. Stumpf 2018. Silver Spring. 2018. Harmful Algal Bloom Forecasting Branch Ocean Color Satellite Imagery Processing Guidelines. NOAA Technical Memorandum NOS NCCOS 252. National Oceanic and Atmospheric Administration, Silver Spring, MD. 10.25923/twc0-f025

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: 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
Id:https://orcid.org/0000-0002-0642-183X
Individual: David Bosworth
Organization:California Department of Water Resources
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: Nicholas Rasmussen
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Nicholas.Rasmussen@water.ca.gov
Id:https://orcid.org/0000-0002-5106-9038
Individual: Theodore Flynn
Organization:California Department of Water Resources
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
Individual: Keith Bouma-Gregson
Organization:US Geological Survey
Email Address:
kbouma-gregson@usgs.gov
Id:https://orcid.org/0000-0002-0304-6034
Individual: Shruti Khanna
Organization:California Department of Fish and Wildlife
Email Address:
Shruti.Khanna@wildlife.ca.gov
Id:https://orcid.org/0000-0003-1724-248X
Individual: Jared Frantzich
Organization:California Department of Water Resources
Address:
3500 Industrial Blvd,
West Sacramento, California 95691-6521 United States
Email Address:
Jared.Frantzich@water.ca.gov
Contacts:
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
Id:https://orcid.org/0000-0002-0642-183X
Associated Parties:
Individual: Ajay Jones
Organization:Sepro Corporation
Role:Field data collection
Individual: Patricia Gilbert
Organization:California Department of Parks and Recreation
Role:Field data collection
Individual: Mark Heilman
Organization:Sepro Corporation
Role:Field data collection
Individual: Andrea Sealock
Organization:Sepro Corporation
Role:Field data collection
Individual: Scott Shuler
Organization:Sepro Corporation
Role:Field data collection
Individual: Shaun Hyde
Organization:Sepro Corporation
Role:Field data collection
Individual: Jose Martinez
Organization:California Department of Parks and Recreation
Role:Field data collection
Individual: Madison Thomas
Organization:California Department of Parks and Recreation
Role:Field data collection

Temporal, Geographic and Taxonomic Coverage

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

Time Period
Begin:
2014-01-01
End:
2021-12-31
Geographic Region:
Description:The Sacramento-San Joaquin Delta of California, United States of America
Bounding Coordinates:
Northern:  38.56Southern:  37.68
Western:  -121.869Eastern:  -121.3

Project

Parent Project Information:

Title:2021-2022 Emergency Drought Salinity Barrier
Personnel:
Individual:Dr. 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
Id:https://orcid.org/0000-0002-0642-183X
Role:Monitoring Lead
Other Metadata

Additional Metadata

additionalMetadata
        |___text '\n    '
        |___element 'metadata'
        |     |___text '\n      '
        |     |___element 'unitList'
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'degreeDay'
        |     |     |     |  \___attribute 'name' = 'degreeDay'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text '19 subtracted from sum of daily maximum temperatures minus daily minimum temperatures divided by 2, cumulative across the year. '
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'microSiemensPerCentimeter'
        |     |     |     |  \___attribute 'name' = 'microSiemensPerCentimeter'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |___text '\n        '
        |     |     |___text '\n        '
        |     |     |___element 'unit'
        |     |     |     |  \___attribute 'id' = 'ppb'
        |     |     |     |  \___attribute 'name' = 'ppb'
        |     |     |     |___text '\n          '
        |     |     |     |___element 'description'
        |     |     |     |     |___text 'Parts per billion'
        |     |     |     |___text '\n        '
        |     |     |___text '\n      '
        |     |___text '\n    '
        |___text '\n  '

Additional Metadata

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