Point Flow Analysis Software for the Lower South Platte River

Home Browse Search

Historical Data Tables. Each of the Historical Data Tables are derived from unique information sources. The three sources utilized for the Lower South Platte River are: 1) the Commissioner's Daily Worksheets, 2) the State's (Colorado) River Diversion Records, and 3) the USGS's Stream (River) Gauging Records. The respective database file names are cntrltbl.dbf, comm_dly.dbf, histdiv.dbf, and histgaug.dbf. The structural format of each of the tables is individually delineated below. Moreover, it is important to bear in mind that in the following discussions the file names cntrltbl.dbf, comm_dly.dbf, histdiv.dbf, and histgaug.dbf stem from the development of tables associated with the Lower South Platte River and in utilizing the PFM and Q &CM for other river segments the naming of such files is user dependent. Control Table (cntrltbl.dbh. The Control Table contains information which describes the makeup of each of the fields in each of the Historical Data Tables. The inclusion of a 'controlling' table allows user's to easily select which structures to include in the point flow analysis, and furthermore, enhances the efficiency of which structural information is stored. Such advantages in using a 'controlling' table will become more evident as the structural format of each table is defined. The field, or column names and corresponding field formats associated with cntrltbl.dbf are presented in Table 2 in an order identical to that found in cntrltbl.dbf. The Control Table (cntrltbl.dbf) associated with the Lower South Platte River is relatively small and contains pertinent information for each river structure. For these reasons a hard copy of cntrltbl.dbf can be found in the Appendix II of this User's Guide. The second column in Table 2 denotes the type of each of the fields in cntrltbl.dbf. A 'C' in the Field Type column denotes a Character type, while an 'L' denotes a Logical field type. Other field types that will appear in following tables include 'D' and 'N' which symbolize a Date type and a Numeric type, respectively. The Field Width column specifies the maximum number of characters that can be placed in each field. If the field type is defined as numeric, the number of decimal places allowed within the field is specified in the fourth column of Table 2. Since no fields listed in Table 2 are defined as numeric type, 'N /A' (not applicable) appears. The last column in Table 2 briefly defines each of the fields. - Only a portion of the information stored in cntrltbl.dbf is utilized in the Point Flow Software, with the balance being stored only for the benefit of the user. The fields existing in cntrltbl.dbf which are directly used include FIELDNAME, STRUCTNAME, RIVERMILE, FLDLOCAL, and UTILIZE. River mile values are necessary to determine distances between structures so that gains can be converted to a per river mile basis, while FLDLOCAL specifies to the Point Flow Software the name of the database table containing FIELDNAME. 14 ptflguid.wpd