|
|
|
Drillhole Databases In Microsoft Access GR-FX has developed drillhole database systems in Access that allow its clients to utilise the power of the database whilst still continuing to operate the mining tools that they are used to. Systems have been setup to work closely with Surpac, Micromine and Datamine. The most common attributes of these systems are good database design, a selection of queries to test the integrity of the data, a full drillhole report, merging facilities for assay labs and exporting to the mining product. The standard data management includes sample number and depth incrementing. The users then either build their own functionality or special features are developed such as high grade intersection calculations and loading from data loggers. It is important to note that every system is developed after the database has been designed. This is the best way to get the most out of the Access environment. These drillholes systems have been deployed in the Gobi Desert for Ivanhoe, Henty Gold Mine, Renison in Tasmania, Broken Hill for Perilya, Selwyn near Mt. Isa, RGC Thalanga, The Granites, Queensland Magnesia, South Bulga, Furtei SGM in Italy, Triarco Minerals in Sydney, Gympie Gold in Queensland, Cadia Mine and Menzies Gold (Indonesia). Drillhole and geochem database support has been provided at Peak in Cobar, Kundana in Kalgoorlie, Norths and AMDAD in Brisbane. We have also developed time based environmental management software for RGC sites in Tasmania.
Whilst all jobs are different, we generally charge a small
rental fee for use of the libraries and techniques that we have already developed plus the
time that it takes to design/develop the database and software. Our
development is very interactive ensuring that you have good cost control of the project.
In addition to that we can assist you to implementation of Combo Boxes for lookup tables in the database design and help you setup Surpac ready databases with ddb files ready to go.
Download an Access 2000/2002/2003 drillhole database sample
Reporting - Using special functions, we can translate the codes from Surpac lookup tables and output better descriptions of geological data in a readable sentence. This can be applied to other forms of lookup tables. This example is from a coal project In Western Australia.
The following example shows coordinates being calculated on the fly in a Access query for straight holes. This would allow your access data to be utilised immediately in a Desktop Mapping Product such as Map Info.
The following form will calculate weighted averages on any field in the assay results table. The results shown are for Copper
Following is an example of the overlaps query that can be setup for any hole in a database. Queries like this help ensure the integrity of the database and reduce time wasted in mining packages.
Importing and Exporting is especially critical in mining packages. The following example shows a customised exporting and reporting form that allows you to select what collars you want through the access query design interface and which tables you want to export. Because datamine uses special custom formats for its direct table loads, these are generated using Access Basic code. This saves the extra step to convert fixed width text files into datamine tables. This client now runs a number of users on an Access database and this frees up the datamine workstations to run specific geological applications.
GR-FX Pty Limited is a consulting firm that has many years experience setting up drillhole systems in Relational Databases. Our final custom Access software generally becomes a simple system that requires less than an hours training if you are experienced in using Windows Applications. We set up our software to complement mining packages rather than compete with them. Our systems are automatically multi user on Windows file shares and do not have any cumbersome security devices.
|
|
Contact GR-FX here |