Laserfiche WebLink
<br />.............. ....... "'0#"_''''''' ...._. ....oJ <br /> <br />--'JV ,,,n'L-I' ,......-_.U.oJ.......L-...,J <br /> <br />....Jl:.l_. U'_'U _......_._. " .......... ... . <br /> <br />Task R5 - Populate aDd Refresh non DWR Data. <br /> <br />Approach <br />In this Task, RTi will populate all the HB - CRDSS database tables (Exhibit 1) with data <br />not obtained from the DWR. Time series files to be populated in this task are expected to <br />contain infonnation 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 ",ill 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 srntion, 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 D\'iR time series data presented in Exhibit I includes <br />streamflow, precipitation, snow, minitllilX 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 eJ\.-tension of <br />time series data to present (approximately 1995), "ill be resolved by RTi or presented to <br />the State for approyal. <br /> <br />RTi ",ill document the results of this task far inclusion as a new section in the Developers <br />Manual. <br /> <br />~~ <br />r; ..,.J l..,. <br /> <br />Deliverables <br />RTi will provide: <br />I. A populated HB - CROSS database with all the non DWR data currently in the <br />CRDSS database, <br />2. All routines, programs, and/or scripts used to perform the data population. 1bese <br />routines should be sUl"ficient fur an experienced database administrator to replicate the <br />conversion, beginning ",ith source files and ending with a populated Intarmix <br />database. The objective is ~o allow the conversion to be reproduced in a "delete and <br />7' re-build" fashion. <br />3. Provide a draft section of the Developers.Manual which describes the HB - CRDSS <br />population of NOR - DWR data. This section, which may be called Population ofNen <br />- DWR data, is expected to be approximately 15 pages in length. It will include the <br />results of the relationship and constraint checking, the population verification, the <br />accounting of records, and the spot-checks. <br />4. Incorporate State comments. 3 <br />5. Provide a final section of the Developers :Manual in the following formats: one hard Q <br />copy, one version in Microsoft Word, one version included in the existing on line <br />(HTML) Developers Manual. <br /> <br />S<opc DrWoll<.HB'CRDSS.I2/1~6 <br /> <br />o\jl\J <br /> <br />7 <br />