|
<br />jurisdictional dams), diversions (daily, monthly, annual time series), diversion
<br />comments, and derived water rights (transactions, net amounts, aug_ wr),
<br />2, All routines, programs, and/or scripts used to perform the population, These routines
<br />should be sufficient for an experienced database administrator to redo the conversion,
<br />beginning with source (typically Dbase) files and ending with a populated Informix
<br />database, The objective is to allow the conversion to be reproduced in a "delete and
<br />re-build" fashion,
<br />3, An error log of all records that could not be loaded. A summary of the cost
<br />associated with repopulating bad data provided by the State in monthly progress
<br />reports, Confirmation through Email or progress reports that revised records provided
<br />to R Ti by the State up to 4 weeks prior to the end of this contract have been loaded,
<br />4, Afixed log of all records that were fixed,
<br />5, A draft section of the Developers Manual which describes the population of HB -
<br />CRDSS database with DWR data, This section, which may be called DWR Data
<br />Population, is expected to contain approximately 10 pages of text and will include the
<br />results of the relationship and constraint checking, the population verification, the
<br />accounting of records, and the spot-checks,
<br />6, Incorporate State comments,
<br />7, Provide a final section of the Developers Manual in the following formats: one hard
<br />copy, one version in Microsoft Word, one version included in the existing on line
<br />(HTML) Developers Manual.
<br />
<br />Task RS - Populate and Refresh Non DWR Data.
<br />
<br />Approach
<br />In this Task, RTi will populate all the HB - CRDSS database tables (Exhibit I) with data
<br />not obtained from the DWR, Time series files to be populated in this task are expected to
<br />contain information up to and including water year 1995, although data for water year
<br />1996 will be obtained if readily available, The goals, procedures, testing and error
<br />handling procedures described in Task 4 will be duplicated in this Task.
<br />
<br />RTi will populate Non DWR station and parameter data from the existing CRDSS
<br />database using a 'delete and rebuild' approach, RTi will insure that all station and
<br />parameter data that is available in a digitized form from the source is populated, RTi will
<br />not be responsible to populate station and parameter data that are not available in a
<br />digitized form from the source, Non DWR station and parameter data presented in
<br />Exhibit I includes station, consumptive use, etc,
<br />
<br />RTi will populate Non - DWR time series data using a 'delete and rebuild' approach, RTi
<br />will obtain Non DWR time series from the data sources (USGS, NOAA, NCDC,
<br />COAGMET, etc,), Non DWR time series data presented in Exhibit I includes
<br />streamflow, precipitation, snow, minimax temperatures, wind, vapor pressure,
<br />evaporation, solar radiation, etc,
<br />
<br />Scope of Work, HB - CRDSS, 1/30/97
<br />
<br />087'2.
<br />
<br />7
<br />
|