|
<br />..
<br />.,
<br />
<br />contain information up to water year 1995, 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 CROSS
<br />database using a 'delete and rebuild' approach, Non DWR station and parameter data
<br />presented in 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 />RTi will check the number of stations and period of record populated in this task to that
<br />in the existing CROSS database, Discrepancies, other than-the-anticipated extension of
<br />// ~
<br />time series data to present (approximately 1995), will\Qe resolved by i or presented to
<br />
<br />the State for approval. ----- ^.l. 'Z
<br />~c.
<br />
<br />RTi will document the results of this task for inclusion as a new section in the Developers
<br />Manual.
<br />
<br />Deliverables
<br />RTi will provide:
<br />I, A populated HB - CROSS database with all the Non DWR data currently in the
<br />CROSS database,
<br />2, All routines, programs, and/or scripts used to perform the data population, These
<br />routines should be sufficient for an experienced database administrator to replicate the
<br />conversion, beginning with source 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,
<br />4, Afixed log of all records that were fixed,
<br />5, A draft section of the Developers Manual which describes the population ofHB-
<br />CROSS database with Non - DWR data, This section, which may be called NON -
<br />DWR Data Population, is expected to contain approximately 10 pages of text and will
<br />include the results of the relationship and constraint checking, the population
<br />verification, the 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 />0<3 '2. 9
<br />
<br />Scope of Work, HB - CRDSS, 12/11/96
<br />
<br />/J;
<br />)}
<br />('" .'
<br />f L
<br />\~ ~~
<br />~ ~1
<br />~~
<br />
<br />
<br />7
<br />
|