|
<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 />
<br />
<br />/ jJv-L t-
<br />, (' ./fA. ".tI1
<br />Task RS - Populate and Refresh Non DWR Data. If1 t I ...,/.II-
<br />t 1/</
<br />Approach '
<br />In this Task, RTi will populate all the HB - C S datab~ xhibit I) with data
<br />not obtained from the DWR, Time series files 0 be populated in this task are expected to
<br />contain information up to water year 1995 The goals, procedures, testing and error
<br />handling procedures described in Task 4 wi , be duplicated in this T!lsk.
<br />
<br />RTi will populate Non DWR ~lL.an>Lp~rameter data from the ~ C~) ?
<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 se~.s_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 radiatio?, 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 />time series data to present (approximately 1995), will be identified by Rti, If
<br />discrepancies are caused by the loading process, they will be resolved by Rti. If
<br />discrepancies are not related to the loading process, Rti will document why they occur.
<br />-------
<br />
<br />RTi will document the results of this task for inclusion as a new section in the Developers
<br />Manual.
<br />
<br />De/iverables
<br />RTi will provide:
<br />l. 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 of HB -
<br />CROSS database with Non - DWR data, This section, which may be called NON -
<br />
<br />Scope of Work, HB - CRDSS, 12/20/96
<br />
<br />09 \.'1
<br />
<br />7
<br />
|