Laserfiche WebLink
CRDSS <br />TASK MEMORANDUM 2.04-1 <br />Physical Characteristics Database <br />Physical Characteristics Database Year 2 Efforts <br />1.0 ISSUE <br />This task memorandum describes the physical characteristics database efforts for Year 2 of the CRDSS. <br />2.0 DISCUSSION/ANALYSIS <br />The physical characteristics database contains relatively stable data that are not necessarily tied to a <br />location. Time series data are contained in the historical database, water rights information are contained <br />in the water rights database, and spatial data are contained in the spatial database. <br />The data in the physical characteristics database are contained in INFORMIX tables. Tables are <br />?locations? for data within the INFORMIX database. <br />The year two effort was broken into several tasks. The effort for each task will be summarized below. <br />Subtask 1. Review data and database design. <br />The CRDSS database design was derived directly from the Hydrobase design. The consultant was <br />directed to build a database that supported the CRDSS effort and followed the Hydrobase design as <br />closely as possible in the context of the CRDSS effort. However, the consultant was not directed to build <br />Hydrobase. The CRDSS database contains many data types not found in the Hydrobase design, and the <br />Hydrobase design also contains many data types not needed for CRDSS, which were not included in the <br />CRDSS database. The State does plan at some point to build the Hydrobase design, so the consultant <br />tried to make the CRDSS database compatible with the Hydrobase design as much as practical. The <br />compatibility was limited by the schedule and funding available to the consultant to resolve design and <br />data issues. <br />To help maintain consistency with the State's Hydrobase design and to make migration to the design <br />easier, the consultant was asked to include all the State's data found in the original dBase files directly <br />associated with the data included in the CRDSS database. When the Phase 2 scope was written, the <br />consultant was aware of five data types that had not been included in the Phase 1 database design. These <br />were structure owner name, structure owner tittle, structure owner address, structure recorder type, and <br />structure measurement device. These data were included in the table in the CRDSS design. <br />structure <br />The table in the Hydrobase structure was not constructed. <br /> rolodex <br />As the Year 2 project proceeded, a memorandum was written (to Ross Bethel and Will Burt from Doug <br />Greer and Larry Brazil, March 29, 1996) describing differences in the designs at the entity level for both <br />Hydrobase and the CRDSS database. The design used in the Phase 2 project is essentially the design <br />delivered to the State at the end of Phase 1 with minor changes, some of which are mentioned above. <br />1 <br />a320/taskmems/ 2-04-01.doc 01/03/97 <br />