Laserfiche WebLink
<br />space layout used for the CRDSS database will be used as a starting point and guide for <br />this process, <br /> <br />R Ii will create and run the scripts necessary to create the database spaces, the database <br />itself and the tables within HydroBase, The tables created under this task are presented in <br />Exhibit I, The table creation scripts contain the table and attribute definitions as well as <br />the constraints and indexing strategy for each table, The SQL scripts available from <br />ERWIN in the development of Exhibit 1 will be used as a starting point, but will need to <br />be modified to include any indexing strategy necessary for the current CRDSS utility <br />programs, The SQL scripts used to create the CRDSS specific tables (station data, cu <br />model, etc.) may be modified and used to build HB - CRDSS <br /> <br />RTi will document the results ofthis task for inclusion as a new section in the Developers <br />Manual. <br /> <br />Deliverable <br />RTi will: <br />I, Provide a draft section of the Developers Manual which describes the HB - CRDSS <br />database construction, This section, which may be called Database Creation, is <br />expected to be approximately 1-2 pages in length, <br />2, Incorporate State comments, <br />3, 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 R4 - Populate HB - CRDSS with DWR data. <br /> <br />Approach <br />In this Task, RTi will populate all the HB - CRDSS database tables (Exhibit I) with data <br />available from the DWR. These files are expected to contain information up to irrigation <br />year 1995 (10/31/1995). <br /> <br />Goals, RTi will design the database population to run as automatically as possible so that <br />once the database is built, deleting and re-building the database can be performed easily <br />with revised or new data sets, This approach is defined herein as a 'delete and re-build', <br /> <br />Procedures, RTi will develop scripts and/or utilities to prepare the data to be load into HB <br />- CRDSS, These scripts and/or utilities may include data manipulation using Dbase, <br />operating system routines and temporary/working tables within the database, Changes to <br />the relationships, constraints, and keys may be made during the conversion, to ease the <br />population of tables, However the final production database schema must reflect the <br />relationships presented in Exhibit L Note, reference tables such as which water districts <br />are in which division or which county is associated with a county ID are included in the <br />HB-CRDSS database design, Exhibit 1, <br /> <br />Scope of Work, HB . CRDSS, 1/30/97 <br /> <br />0874 <br /> <br />5 <br />