README file for data presented in

Journal: ACS ES&T Water
Title: Fluorescence-based indicators of Escherichia coli and untreated wastewater: Turbidity correction and comparison of in situ and benchtop fluorometers in a sewage-polluted urban river
Author(s): Biggs, Trent; Mladenov, Natalie; Garcia, Stephany; Yuan, Yongping; Sousa, Dan; Grant, Alexandra; Piazza, Elise; Magdalena-Weary, Trinity; Summerlin, Callie; Liden, Doug
DOI:  https://doi.org/10.1021/acsestwater.4c01092

Please see the article for details on the equipment, installation, and analysis.

Location of field measurements:
Tijuana River, San Diego California at the International Boundary and Water Commission (IBWC) stream gage.
32° 32′ 36″ N, 117° 3′ 1″ W
Discharge data for the IBWC gage is available at https://waterdata.ibwc.gov/AQWebportal/Data/Dashboard/8

A.  Results of wastewater addition experiments.
File names:
A1_WW_addition_Seawater1_2022_11_17.csv
A2_WW_addition_Streamwater_2023_04_18.csv
A3_WW_addition_Seawater2_2023_10_26.csv

Data Field Descriptions:
Sample.  Sample ID
pctWW.  Percent wastewater in the sample.
AqualogTRP RU.  Tryptophan value in Raman Units, measured on Horiba Aqualog
AqualogCDOM RU. CDOM value in Raman Units, measured on Horiba Aqualog
Manta.COND uScm:  Conductivity from the Manta sonde, units microSiemens per cm.
Manta.TURB.FNU:  Turbidity from the Manta sonde, units FNU.
Manta.CDOM ppb:  CDOM reading from Manta sonde, raw value from the sensor, in ppb
Manta.TRP.ppb:  Tryptophan reading from Manta sonde, raw value from the sensor, in ppb
Manta.TRYPrecal.ppb:  Tryptophan from Manta sonde in the laboratory, back-calibrated, assumes no drift or variability in sensor readings on the 100ppb standard over time.  For Seawater1 and Streamwater, baselines of 40ppb (Seawater1) and 120ppb (Streamwater) were substracted from the raw value for intercomparison of all experiments.



B.  Lab measurements of field samples

File names:
B1_12.12.2022_bacteria_w_field_Manta.csv

B2_2.23.23_and_2.25.23_bacteria_w_field_Manta.csv

B3_2023.05.Aqualog_bacteria_w_field_and_lab_Manta.csv

Data Field Descriptions:
AqualogTRP RU.  Tryptophan value in Raman Units, measured on Horiba Aqualog
AqualogCDOM RU. CDOM value in Raman Units, measured on Horiba Aqualog
Ecoli.MPN100mL.  E. coli concentration from IDEXX, units MPN/100mL
Manta.TRYP.field ppb:  Tryptophan reading from Manta sonde installed in the field at the IBWC gage, raw value from the sensor, in ppb
Manta.TRYPrecal.field ppb: Tryptophan from Manta sonde installed in the field at the IBWC gage, back-calibrated, assumes no drift or variability in sensor readings on the 100ppb standard over time.
Manta.CDOM.field ppb:  CDOM reading from Manta sonde installed in the field at the IBWC gage, raw value from the sensor, in ppb
Manta.CDOM.field recal ppb:  CDOM from Manta sonde installed in the field at the IBWC gage, back-calibrated, assumes no drift or variability in sensor readings on the 100ppb standard over time.
Manta.TURB.field.FNU:  Turbidity from the Manta sonde installed in the field at the IBWC gage, units FNU.
Manta.COND.field.uScm:  Conductivity from the Manta sonde installed in the field at the IBWC gage, units microSiemens per cm.
Manta.TRYP.lab ppb:  Tryptophan reading from Manta sonde in the laboratory, raw value from the sensor, in ppb
Manta.TRYPrecal.lab ppb: Tryptophan from Manta sonde in the laboratory, back-calibrated, assumes no drift or variability in sensor readings on the 100ppb standard over time.
Manta.CDOM.lab ppb:  CDOM reading from Manta sonde in the laboratory, raw value from the sensor, in ppb
Manta.CDOM.lab recal ppb:  CDOM from Manta sonde in the laboratory, back-calibrated, assumes no drift or variability in sensor readings on the 100ppb standard over time.
Manta.TURB.lab.FNU:  Turbidity from the Manta sonde in the laboratory, units FNU.
Manta.COND.lab.uScm:  Conductivity from the Manta sonde  in the laboratory, units microSiemens per cm.
Qcms:  Discharge of the Tijuana River at the time of sampling, as recorded at the IBWC gage.
SSC.mgL:  Suspended sediment concentration, in mg/L



C.  Time series from the Manta sensor installed at IBWC.
All parameters follow naming conventions above. All are field-measured values for the Manta installed at the IBWC gage (Manta.xx.field, where xx is the parameter).

Two files are included, for two time periods:
C1_Manta_time_series_2022.12_02_to_2023_01_24.csv
C2_Manta_time_series_2023.01.20_2023_03.08.csv