Laserfiche WebLink
CRDSS <br />TASK MEMORANDUM 2.07 -1 <br />Water Rights Database <br />Year 2 Summary <br />1.0 ISSUE <br />The purpose of this task memorandum is to document the water rights database <br />task activities performed during Year 2. <br />2.0 DISCUSSION /ANALYSIS <br />The primary focus of the database effort was to create a populated database to <br />support the modeling efforts. During Phase I, the database design was <br />formulated, and construction of the database began. Beginning in Phase II, the <br />database design was refined, and database construction and population <br />continued. Some work was done as part of the Year 1 effort to prototype a water <br />rights table structure and to try to anticipate problems which would occur during <br />Year 2. Little in the way of a water rights database was required as part of the <br />Year 1 effort because the water rights work necessary to set up an initial water <br />resources planning model in the Gunnison basin had already been completed. <br />The majority of the database work with the State's water rights occurred in Year <br />2. <br />The progress on the water rights database task is summarized first by a brief <br />discussion of the scope of work. Then, important parts of the work plan will be <br />discussed, particularly where products were produced that were not discussed in <br />the work products section. <br />Subtask 1. Populate all the water rights information into temporary tables. <br />All the State's water rights information was populated into a set of temporary <br />INFORMIX tables that were similar in structure to the original dBase structure. <br />The purpose of this activity was to supply active access to the water resources <br />planning group so that the modeling activities could continue while the <br />permanent table structure was built and populated. The product of this effort was <br />the temporary populated water rights tables. <br />Subtask 2. Create a Hydrobase water rights table structure and populate the <br />structure in the CRDSS database. <br />The current database design is found in Section 2.0 of the CRDSS Developers' <br />Manual. The entity relationship diagram and schema found in Section 5.2 of the <br />CRDSS Developers' Manual were used as the starting points for the database <br />development in Year 2. <br />The CRDSS database design was derived directly from the Hydrobase design. <br />The consultant was directed to build a database that supported the CRDSS effort <br />and followed the Hydrobase design as closely as possible in the context of the <br />CRDSS effort. However, the consultant was not directed to build Hydrobase. The <br />