Data for Total Maximum Daily Loads and Escherichia coli trends in Texas freshwater streams

Description: This dataset includes E. coli bacteria measurements and associated flow data for 778 water quality monitoring stations in Texas. The data was used to evaluate trends in E. coli bacteria concentration and the effectiveness of TMDLs at reducing E. coli concentrations.

Bibliographic

Published 2022-07-28
Keywords
  • water quality
  • total maximum daily load
  • watershed
  • E. coli
  • fecal indicator bacteria
Funder
License

Coverage

Temporal

Begin NA
End NA

Spatial

Attributes

Name Description Unit
ActivityStartDate Recorded date of monitoring activity
MonitoringLocationIdentifier Location of monitoring activity (TCEQ SWQM station)
CharacteristicName Monitoring characteristic name
ResultMeasureValue Reported E. coli lab result (MPN/100 mL)
AU Assessment Unit identifier for Monitoring Location
Impaired Indicates impairement status of the monitoring location
TMDL TMDL status for Monitoring Location (1 = TMDL, 0 = No TMDL)
Completion_Date Date that TMDL was adopted (YYYY-MM-DD, or NA for No TMDL)
geometry Lon, Lat
USGSSite_No Associated USGS Stream Gage
Flow Mean daily streamflow value of ActivityStartDate (cfs)
tmdl_status Coding for TMDL category used to calculate odds-ratio (Pre-TMDL, Post-TMDL, No-TMDL)
fa_pvalue p-value from the flow-adjusted Mann-Kendall trend test
fa_kendallsTau Kendall's Tau from the flow-adjusted Mann-Kendall trend test
fa_slope Sen Slope from the flow-adjusted Mann-Kendall trend test
fa_n number of samples used in the flow-adjusted Mann-Kendall trend test
pvalue p-value from the unadjusted Mann-Kendall trend test
kendallsTau Kendall's Tau from the unadjusted Mann-Kendall trend test
slope Sen Slope from the unadjusted Mann-Kendall trend test
n number of samples used in the unadjusted Mann-Kendall trend test

Distribution

File Format  
cleaned_data csv Download
flow_adjusted_mk_results csv Download
unadjusted_mk_results csv Download