Laserfiche WebLink
i <br />I TABLE STRUCTURE AS RELATED TO THE LOWER SOUTH PLATTE <br />RIVER <br />Proper structural formatting of all input and output tables affiliated with the PFM is essential for <br />accurate results. For example, imbedded within field names corresponding to particular structures <br />on the river are code letters. One such code letter signifies the structure 'type' as being either an <br />inflowing stream, a diverting canal, or a gauging station. If code letter placement is incorrect or <br />misread, improper water balances may result, leading to erroneous subreach gain and river flow <br />values. This section examines the structure and format of databases utilized and generated by the <br />PFM for the Lower South Platte River. The following section describes, in detail, database <br />modifications and alterations necessary to utilize the PFM on river segments other then the Lower <br />South Platte River. If it is desired to employ the PFM on other river segments, it may be helpful <br />to first review this section to better understand the makeup of each included database. <br />The first portion of this section will discuss the format and makeup of the input tables associated <br />with the Lower South Platte River. The remainder of the section will then consider the format <br />and makeup of the tables generated by the PFM (output tables). Figure 4 is a re- creation of the <br />PFM as shown in Figure 3. Figure 4, however, specifies the file names with respect to the Lower <br />South Platte River. The input files entail the Control Table (cntrltbl.dbf) and three Historical Data <br />Tables (comm_dly.dbf, histdiv.dbf, and histgaug.dbf). The output tables (from the PFM) are gainout.dbf <br />and flowout.dbf, and contain the calculated subreach gain values and flow values, respectively. <br />Control Table <br />(cntrltbl.dbfl <br />Uses Interface Point Flow Software Comm Worksheets <br />* Point Flow information aAicrogoft FoxPro) (comm dly dbf) <br />- - - - - - - - - - - l Diversion Records <br />(histdiv.dbfl <br />U.S.G.S. Records <br />(histgaug.dbt) <br />'Gains' Table <br />(gainout.dbfl <br />'Flows' Table <br />(flowout.dbfl <br />Figure 4 Tables associated with the Lower South Platte River. <br />INPUT DATA TABLES FOR THE LOWER SOUTH PLATTE RIVER <br />Four database tables are used as input sources for the PFM in the case of the Lower South Platte <br />River. The input tables consist of the Control Table (mandatory for utilizing the PFM) and three <br />13 ptflguid.wpd <br />