Get access

A Tool for Automated Load Duration Curve Creation1

Authors

  • Stephanie L. Johnson,

    1. Respectively, Graduate Research Assistant, Research Associate, and Director, Center for Research in Water Resources, University of Texas at Austin, Pickle Research Campus, Building 119, MC R8000, Austin, Texas 78712.
    Search for more papers by this author
  • Timothy Whiteaker,

    1. Respectively, Graduate Research Assistant, Research Associate, and Director, Center for Research in Water Resources, University of Texas at Austin, Pickle Research Campus, Building 119, MC R8000, Austin, Texas 78712.
    Search for more papers by this author
  • David R. Maidment

    1. Respectively, Graduate Research Assistant, Research Associate, and Director, Center for Research in Water Resources, University of Texas at Austin, Pickle Research Campus, Building 119, MC R8000, Austin, Texas 78712.
    Search for more papers by this author

  • 1

    Paper No. JAWRA-08-0019-P of the Journal of the American Water Resources Association (JAWRA).Discussions are open until December 1, 2009.

(E-Mail/Johnson:sljohnson@mail.utexas.edu)

Abstract

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/.

Get access to the full text of this article

Ancillary