Laserfiche WebLink
i Members of the geological team have data entry and edit rights. Only the database <br />Manager has delete rights. <br />a Responsibility for collecting and validating geological data would remain with <br />individual geologists. However, they must have sufficient training in Access to be <br />able to input and extract information competently from the database. <br />The database is stored on a central server at CCC and is backed up nightly. <br />e Production data are stored separately in Excel spreadsheets and managed by the <br />CCC Plant Co- ordinator and the surveyors. <br />4 DRILL HOLE DATABASE <br />The Access drill hole database currently includes data from 702 drill holes (including Grace <br />and Utah series holes) stored in three main tables: Header, Lithology and Sample definitions <br />(Figure 3.1). <br />TS checked the database for inconsistencies using validation techniques Excel. Details of <br />apparently anomalous drill holes are listed in Appendix 1. Potential problem areas are <br />indicated. An electronic version of Appendix 1 was left with the geologists at CCC for further <br />investigation and remediation where necessary. <br />The database manager has built in automatic validation functions, including total depth <br />• consistency and duplicate names, co- ordinates or ranges (Figure 4.1), lithology validation <br />(Figure 4.2) and sample validation (Figure 4.3). Overlapping intervals are not yet validated. <br />Figure 4.1: The Main Validation Menu <br />• <br />Drill Hole Database m <br />J Update Tate] Oepths wdh Null value <br />J Check for Duplicate Hour Names in Header Table <br />J Check for Duplicate Drill Hole Locations <br />J LIMOlopy validation (menu) <br />J Sample validation (menu) <br />J DuakW COmpotlb Functions <br />J Main Menu <br />Curre2 Proles Agee: Colwrra <br />lilt) <br />IlNll) <br />8R3273: FINAL version: 1 <br />