Reservoir operation DSS: LCRA

<body topmargin=0 leftmargin=0 marginheight=0 marginwidth=0> <table cellpadding=0 cellspacing=0 border=0><tr> <td valign="top" rowspan="2" width=185 BGCOLOR="#FFFFFF" TEXT="#080000"> <div> <A HREF="index.htm" TARGET="_top" TITLE="David Ford Consulting Engineers"><U><B><IMG SRC="0d058960.png" border=0 width="88" height="150" ALIGN="BOTTOM" HSPACE="0" VSPACE="0"></B></U></A></div> <bR> <div>    <FONT SIZE="1" COLOR="#000000" FACE="Verdana" > </FONT></div> <div> <B> <TABLE BORDER="0" CELLPADDING="4" CELLSPACING="1" WIDTH="156" BORDERCOLORLIGHT="#FFFFFF" BORDERCOLORDARK="#FFFFFF" FRAME="VOID" RULES="NONE" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP HEIGHT= 27 WIDTH="146"><div> David Ford Consulting Engineers, Inc.</div> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 27 ><NOBR><div> 2015 J Street, Suite 200</div> <div> Sacramento, CA 95811</div> </NOBR></tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 27 WIDTH="146"><div> tel: 916.447.8779</div> <div> fax: 916.447.8780</div> </tD> </tR> <tR> <tD VALIGN=TOP HEIGHT= 27 WIDTH="146"><div> <A HREF="mailto:support@ford-consulting.com" TARGET="_top" TITLE="mailto:support@ford-consulting.com"><U>support@ford-consulting.com</U></A></div> </tD> </tR> </TABLE></B></div> <div>    </div> <bR> <div> <A HREF="index.htm" TARGET="_top" TITLE="David Ford Consulting Engineers"><U>Home</U></A></div> <div> <A HREF="id461.htm" TARGET="_top" TITLE="About us"><U>About us</U></A></div> <div> <A HREF="news.htm" TARGET="_top" TITLE="News"><U>News</U></A></div> <div> <A HREF="hydrologic_engineering.htm" TARGET="_top" TITLE="Hydrologic engineering"><U>Hydrologic engineering</U></A></div> <div> <A HREF="water_resource_planning.htm" TARGET="_top" TITLE="Water resource planning"><U>Water resource planning</U></A></div> <div> <A HREF="flood_economic_and_risk_analyses.htm" TARGET="_top" TITLE="Flood economic and risk analyses"><U>Flood economic/risk analyses</U></A></div> <div> <A HREF="flood_warning.htm" TARGET="_top" TITLE="Flood warning"><U>Flood warning</U></A></div> <div> <A HREF="decision_support_system_development.htm" TARGET="_top" TITLE="Decision support system development"><U>Decision support systems</U></A></div> <bR> </td> <td valign="top" colspan=2 height=40 BGCOLOR="#3366CC" TEXT="#080000" bgproperties="fixed" background="14400980ezthpx.png"> <div> <B>Reservoir operation DSS: LCRA </B></div> <div> </div> </td> </tr><tr> <td valign="top" height=440 colspan=2 BGCOLOR="#FFFFFF" TEXT="#080000" bgproperties="fixed" background="06c00962egerdp.png"> <div> <B> <TABLE BORDER="0" CELLPADDING="2" CELLSPACING="1" WIDTH="547" BORDERCOLORLIGHT="#C0C0C0" BORDERCOLORDARK="#808080" FRAME="BOX" RULES="ALL" HSPACE="0" VSPACE="0" > <tR> <tD VALIGN=TOP COLSPAN=3 BGCOLOR=#CC0000 HEIGHT= 16 WIDTH="537"><div> <B>Situation</B></div> </tD> </tR> <tR> <tD VALIGN=TOP COLSPAN=3 HEIGHT= 67 WIDTH="537"><div> The Lower Colorado River Authority (LCRA) operates six reservoirs on the main stem of the Lower Colorado River in central Texas. Significant floods occurred in the watershed in the late 1990's. To operate the system better, LCRA staff wanted better tools with which to forecast inflows and evaluate release decisions.</div> </tD> </tR> <tR> <tD VALIGN=TOP COLSPAN=3 BGCOLOR=#339933 HEIGHT= 16 WIDTH="537"><div> <B>Action</B></div> </tD> </tR> <tR> <tD VALIGN=TOP COLSPAN=3 HEIGHT= 254 WIDTH="537"><div> We designed, developed, and implemented a DSS that (1) retrieves hydrometeorological data from LCRA's Microsoft SQL Server database; (2) forecasts runoff due to current precipitation; (3) forecasts runoff due to a quantitative precipitation forecast provided by a meteorologist; (4) routes the forecasted runoff throughout the hydrologic system using an unsteady flow model; and (5) simulates operation of the six LCRA reservoirs, given releases specified by the LCRA operators. The DSS uses our catchment forecasting tool, <A HREF="aviso_fs.htm" TARGET="_top" TITLE="Aviso FSour site specific forecasting sy"><U>Aviso FS</U></A>.</div> <div> We included flexible database connectivity. At the start of this project, LCRA was in the process of switching to a new Microsoft SQL Server database. Final design of the database was not complete when we started our work. Although not required by our scope of work, we provided LCRA staff with a straw-man design of a relational database and worked with them to implement the design. In the meantime, to avoid project delays, we implemented our forecasting system using HEC-DSS as an internal database. Subsequently, we developed converters to retrieve data from the SQL Server and post those to HEC-DSS. </div> </tD> </tR> </TABLE></B></div> <bR> </td> </tr></table></body>