Improved data management: State water project

<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>Improved data management: State water project</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= 99 WIDTH="537"><div> For more than 20 years, the California Dept. of Water Resources (DWR) has used DWRSIM, a complex model of reservoir operating, diverting, and pumping throughout the State Water Project (SWP). Data management for the model had become a significant problem with DWR staff and other DWRSIM users. They asked us to help solve the data management problem and to develop a strategy for overhauling the model.</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= 319 WIDTH="537"><div> In 1994, we analyzed DWR's needs and concluded that the HEC-DSS was an appropriate solution. We ported the HEC-DSS libraries to DWR's HP UNIX system, integrated HEC-DSS with DWRSIM, and helped DWR staff learn to use the HEC-DSS tools. We also ported the HEC-DSS-enabled version of DWRSIM back to the PC, so users outside of DWR would have access to the improvements.</div> <div> In 1999, we expanded the capabilities of  a suite of three programs that "feed" DWRSIM. These programs track water availability and use upstream of the SWP, thus predicting the inflow volumes to the system reservoirs and channels. Historically, the programs were run as a carefully ordered sequence of batch oriented programs, and output from one program was input to another via cut-copy-paste.  This led to errors and frustrated users. DWR asked for help resolving this. </div> <div> We disassembled the programs and added routines to file and retrieve data in an HEC-DSS database, consistent with that used by DWRSIM. </div> <div> In addition, we provided to DWR a Microsoft Excel Add-in that permits DWR users to manipulate HEC-DSS data directly from Excel. This flattens the learning curve for new users, as many are familiar with Excel and few are familiar with the HEC-DSS utilities.</div> </tD> </tR> </TABLE></B></div> <bR> </td> </tr></table></body>