My WebLink
|
Help
|
About
|
Sign Out
Home
Browse
Search
CRDSS_Task1_08-2_HistoricalDatabaseYear1Summary
CWCB
>
Decision Support Systems
>
DayForward
>
CRDSS_Task1_08-2_HistoricalDatabaseYear1Summary
Metadata
Thumbnails
Annotations
Entry Properties
Last modified
9/25/2011 10:18:51 AM
Creation date
6/2/2008 9:19:47 AM
Metadata
Fields
Template:
Decision Support Systems
Title
CRDSS Task 1.08-2 - Historical Database - Year 1 Summary
Description
The purpose of this task memorandum is to document the historical database task activities performed during Year 1.
Decision Support - Doc Type
Task Memorandum
Date
1/9/1995
DSS Category
HydroBase
DSS
Colorado River
Basin
Colorado Mainstem
Contract/PO #
C153658, C153727, C153752
Grant Type
Non-Reimbursable
Bill Number
SB92-87, HB93-1273, SB94-029, HB95-1155, SB96-153, HB97-008
Prepared By
Riverside Technology inc.
There are no annotations on this page.
Document management portal powered by Laserfiche WebLink 9 © 1998-2015
Laserfiche.
All rights reserved.
/
6
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
for Division 7); therefore, work was done on the environmental data time series during this <br />Phase so that time could be spent during Phase IIb populating data not available during Phase <br />IIa. <br /> <br />Wind, solar radiation, vapor pressure (relative humidity) data types are shown to be 100 <br />? ? <br />percent populated in the tables, yet there are fewer than the number that were originally <br />estimated. When the tapes were received from the National Climatic Data Center (NCDC), <br />there was no data available for these data types. All the data in the database for these data <br />types are from the Colorado Agricultural Meteorological Network (COAGMET). As Phase <br />IIb proceeds and if additional data are found, those data will be populated into the database. <br /> <br />Instream flow/nonconsumptive demands can be quantified, but there are no historical records <br />? ? <br />available. <br /> <br />Diversion records supplied by the State were stored three ways. The first is the original dBase <br />? ? <br />organization of the records in an INFORMIX table. All the original information was retained <br />here. The second set of records is a subset of the first. These records were migrated into a <br />subset of the HydroBase structure as appropriate for the CRDSS. During the migration <br />process, some of the records were pulled out because of ID conflicts, duplicate IDs, etc. <br />These records were returned to the State for further study and will be included in the database <br />when the record inconsistencies are resolved. The third set of records is a subset of <br />approximately 60 structures that have been filled according to specific instructions from the <br />State's management team. <br />2.Form-based interfaces for data entry, editing, and display using software such as INFORMIX- <br />4GL. <br />Form-based interfaces were built for most of the historical data types. These interfaces, or displays, were <br />built with INFORMIX-ISQL. These displays had the capability of data downloading, data entering and <br />data editing, plus the most powerful query capability of any of the displays built for the prototype. There <br />were three reasons that these displays were developed: (1) to fulfill the prototype display requirement of <br />this task; (2) to debug and test the database structure, and (3) to show that there are data in the database <br />and that the data are accessible. The work done to develop these displays was built so that the other <br />displays that are part of the prototype could be developed. These displays were demonstrated along with <br />other more graphical displays developed as part of the user involvement process. Potential users were <br />generally confused by the format of these displays and unsatisfied because they were less intuitive than <br />some commercial data products like Hydrodata . Note that the input collected from the user involvement <br />process on the prototype will be used to improve the displays during Phase IIb. <br />3.A database containing water rights information necessary to support the water rights <br />planning model as part of the prototype. <br />Most of the water rights information necessary for the prototype came from the Hydrosphere <br />implementation of the Gunnison River basin. However, water rights information was loaded for <br />Division 4, and this information was used as part of the water rights planning model effort. <br />The State's management team supplied water rights data for Division 4. These data were loaded into the <br />database in an INFORMIX table organized in the manner the data were received. Work was done to <br />refine the HydroBase table structure and additional work was done to begin to populate these tables. <br />3 <br />A275 01.09.95 1.08-2 Greer <br />
The URL can be used to link to this page
Your browser does not support the video tag.