Laserfiche WebLink
<br />Software <br /> <br />In recent years, the Division of Water Resources has relied on a PC based data <br />management system maintained in a dBase ill file format. While dBase ill was the historic <br />standard, it is becoming obsolete. After a review of the needs, the Division Engineer's <br />Office selected Foxpro for Windows as the current mechanism for maintaining and <br />manipulating data. Software needs will be continually examined to ensure ease of use and <br />quality data management capabilities. <br /> <br />Data Acquisition and Quality Control <br /> <br />The 1994 Measurement Rules and the 1996 Use Rules require user supplied <br />information to be provided by individuals or associations. Thus, quality control becomes a <br />key factor. To have data sufficiently accurate for administrative purposes, data must be tied <br />to each well. Field recoMaissance efforts and individual field inspection to assign structure <br />identification numbers became a necessity as the basic reference point for all data. The <br />assignment of the structure identification number linking of the data collected from several <br />sources through the structure identification number has become the core of the Division <br />Office's data acquisition program. <br /> <br />There are several elements to the data quality control program. Field inventory <br />begins with a review of the A WELS database followed by an on-site inspection focused on <br />locating and gathering information about each well in a section, and then a re-examination <br />of data. The program includes further efforts to identifY wells subject to the roles, <br />comparison of data to eliminate redundancy, and conununication with ground water users <br />associations. <br /> <br />Database Linkage <br /> <br />The well database structure for Division 2 is portrayed graphically in Figure I, <br />Appendix A. The circles represent the various databases and the rectangles show the various <br />sources of information of those databases. Each database includes the structure identification <br />number for record identification. The lines between circles in Figure I indicate how <br />conunon fields are link..:d between databases. In the diagram, the database labeled WS2 <br />(structure) contains the information from the field inventory. A brief description of each <br />database portrayed in Figure 1 follows. <br /> <br />WS2 <br /> <br />WS2 is the current name of the database defining the structure identification numbers <br />and containing the information obtained in the field inventory. WS2 includes information <br />on ownership, location of the well, power source and account numbers, and other relevant <br /> <br />10 <br />