My WebLink
|
Help
|
About
|
Sign Out
Home
Browse
Search
WSPC04507
CWCB
>
Water Supply Protection
>
Backfile
>
16000-16999
>
WSPC04507
Metadata
Thumbnails
Annotations
Entry Properties
Last modified
1/26/2010 11:39:47 AM
Creation date
10/9/2006 4:38:50 AM
Metadata
Fields
Template:
Water Supply Protection
File Number
8283.200
Description
Colorado River Basin-Colorado River Computer Models-Colorado River Decision Support System
State
CO
Basin
Colorado Mainstem
Water Division
5
Date
12/12/1996
Title
RTi HydroBase-CRDSS Scope of Services 2
Water Supply Pro - Doc Type
Operating Principles/Plan
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
Laserfiche.
All rights reserved.
/
11
PDF
Print
Pages to print
Enter page numbers and/or page ranges separated by commas. For example, 1,3,5-12.
After downloading, print the document using a PDF reader (e.g. Adobe Reader).
Show annotations
View images
View plain text
<br />:1 <br /> <br />the constraints and indexing strategy for each table, The SQL scripts available from <br />ERWIN in the development of Exhibit I 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 of this 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, <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 />UNIX level routines and temporary/working tables within the database, Changes to the <br />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 Ex.'1ibit I, <br /> <br />Integrating Derived Water Rights, RTi will integrate the data for the three Derived Water <br />Rights tables called Transactions, Net Amounts, and Aug_ wr. The State will provide <br />these tables to the RTi in a stand-alone fashion, (Meaning that they are not directly <br />related to any other table in the HB - CRDSS database,) It is RTi's responsibility to use <br />the Alternate Keys defined in Exhibit I (WD+ID), to build a relationship between the <br />main Structure table by back filling the foreign key (structure_num), <br /> <br />Testing, As tables are populated, RTi will verify the integrity of the relationships among <br />the tables, and the conversion of data into the tables, The results of the table population <br /> <br />Scope of Work, HB - CRDSS, 12/11196 <br /> <br />0931 <br /> <br />5 <br />
The URL can be used to link to this page
Your browser does not support the video tag.