Paper No. JAWRA-08-0019-P of the Journal of the American Water Resources Association (JAWRA).Discussions are open until December 1, 2009.
A Tool for Automated Load Duration Curve Creation1
Version of Record online: 10 APR 2009
© 2009 American Water Resources Association
JAWRA Journal of the American Water Resources Association
Volume 45, Issue 3, pages 654–663, June 2009
How to Cite
Johnson, S. L., Whiteaker, T. and Maidment, D. R. (2009), A Tool for Automated Load Duration Curve Creation. JAWRA Journal of the American Water Resources Association, 45: 654–663. doi: 10.1111/j.1752-1688.2009.00313.x
- Issue online: 26 MAY 2009
- Version of Record online: 10 APR 2009
- Received January 23, 2008; accepted October 27, 2008.
- load duration curves;
- total maximum daily loads;
- bacterial impairments;
- web-based data mining;
- watershed management;
Abstract: A recent study by the Texas Bacteria Total Maximum Daily Load (TMDL) Task Force has recommended the use of load duration curves as a primary tool in calculating bacterial TMDLs. This method is attractive because it effectively integrates flow regimes into TMDL analyses, clearly communicates data through a method that is understandable to the general public, and has been successfully applied in TMDL studies in other states. To ease the creation of load duration curves, an automated load duration curve creation tool called LDCurve has been created within a Microsoft Excel framework. Web services and a webscraper are used to retrieve U.S. Geological Survey streamflow data and Texas Commission on Environmental Quality water quality data. Data are imported to the spreadsheet, combined to create flow and load duration curves, and plotted. Final steps result in a preliminary estimate of the overall load reductions needed to meet water quality standards in the modeled segment. LDCurve is currently only applicable in the state of Texas, but may be updated to model water quality throughout the nation using analogous web services from the EPA STORET database. By using automated data retrievals and computations, the LDCurve tool reduces the amount of time required to create curves and calculate load reductions to a matter of minutes. LDCurve and all supporting materials are available online for free download at: http://tools.crwr.utexas.edu/LDCurve/.