Laserfiche WebLink
<br />I'll '&-, <br /> <br />o !1i)(J 5 3 <br /> <br />South Platte Water Rights Management System <br /> <br />Streamflow Near-real-time gauged data are sent via salellite to a VAX at SEa and then transmitted to <br />SPWRMS database and stored in the streamflow table. Historical data will be maintained <br />on line as'disk space allows and may undergo aggregation in the future. <br /> <br />Column Description <br />station ** State 8-character abbreviation for gauge <br />date_time ** Date and time of flow reading <br />flow _cfs Flow reading in cfs <br /> <br />** indicates primary key <br /> <br />Database Table 18: streamflow <br /> <br />Laglloss The SPWRMS application allows the user 10 save a daily set of lag/Joss values to the dara- <br />base. While the default lag/loss data are stored in a static table. the daily, or current, set of <br />lagnoss data is stored in a dynamic table. <br /> <br />Column Description <br />date_saved ** Date for which current set is active <br />reach- id * * Unique ID ofreach <br />lag Lag over entire reach, in hours <br />loss Loss over reach, in #% <br /> <br />** indicates primary key <br /> <br />Database Table 19: lag_loss_current <br /> <br />Data Sources <br /> <br />There are a number of sources of data for the relational database component of SPWRMS. <br />The following list describes the data source for each of the tables of SPWRMS database: <br /> <br />Table Source <br />adjud_type_codes Generaled at CADSWES <br />calls Input by user <br />checksheet_data Input by user <br />diversions Input by user <br />exchanges Input by user <br />gagingstations Generated at CADSWES <br />lag_loss_current Input by user <br />la8--loss_default SEa provided data <br />phS_rights SEa water rights tabulation <br />phS_structures SEO structures tabulation <br />spotcheck Generated at CADSWES. <br />streamflow Near real-time satellite telemetry <br /> <br />Table 2: Data Sources <br /> <br />Database Manual <br /> <br />11 <br />