Laserfiche WebLink
CRDSS <br />TASK MEMORANDUM 2.07-0 <br />Water Rights Database <br />Water Rights Verification <br />1.0 ISSUE <br />This task memorandum describes the verification process used to satisfy the quality assurance/ <br />quality control (QA/QC) requirements of the water rights port from the current dBASE structure to <br />the CRDSS database structure. <br />2.0 DISCUSSION/ANALYSIS <br />The purpose of this task was to (1) verify that all of the water rights data available from the State is <br />populated in the CRDSS database, (2) verify that the logic of the State?s migration program is valid, <br />and (3) verify the logic of the stream alpha listing function within the CRDSS watright utility <br />program. <br />The State provided ASCII data files of the most recent stream alpha listings (produced from data sets <br />dated ???) to be compared against the report listing produced by the watright utility from data <br />currently in the CRDSS database. To accomplish the comparison it was necessary to first complete <br />the stream alpha listing procedure within the watright utility to exactly match the format of the <br />current State report. Originally it was preferred that the report files from the two sources would be <br />compared using a diff tool, such as the SGI UNIX tool gdiff. However, this was determined to be <br />infeasible because of the line lengths in the report files. The next option was to use the INFORMIX <br />database engine to compare the report files. Each of the report files was loaded into a temporary <br />working table in the CRDSS database and sorted in the same order. Once this was complete, a <br />record count was performed for each water district from the temporary working tables. The results <br />from this record count are shown below: <br />Water Distric t State Reportwatright Repor t <br />2815241573 <br />29913990 <br />3024382622 <br />318281125 <br />32651810 <br />33486637 <br />34370581 <br />3618861966 <br />3728574183 <br />3850625079 <br />3923952461 <br />1 <br />a320/taskmems/ 2-07-0.doc 01/03/97 <br />