|
Loading Dynamic Drillhole Data Loading drillhole data tables to generate dynamic drillholes |
Loading Data and Defining Holes
Absent Data, Weighting and Composites
Introduction
Your application supports two mechanisms for creating and displaying drillholes. The first is the static method which uses the HOLES3D process and the second is the dynamic method which creates drillholes from data 'on-the-fly'. This topic discusses the requirements and options for creating dynamic drillholes.
The principal difference between static and dynamic drillholes is that static drillholes are created as a desurveyed drillhole file, using a process, from Datamine format files; whereas dynamic drillholes use data in memory (from any data source) to create drillholes in memory.
You can load many drillhole data tables into memory and combine
them intelligently into a single Dynamic Drillholes object in memory,
without altering the component data. It can calculate composite values
"on-the-fly" and make changes to sample values automatically,
immediately reflecting them in all composite values.
|
Use Dynamic Drillholes for the following:
|
Required Data
The format of the source data is not important provided there is a driver available to load the data into memory. The desurveying algorithm requires certain data as a minimum before it can create drillhole trace and sample composites. The following drillhole tables are used to generate holes:
-
collars - required; contains drillhole XYZ collar coordinate, coordinate system, coordination and drilled date data
-
surveys - required; contains drillhole survey depth, survey bearing and dip data
-
assays - required; sample interval start and end depth, mineral grade or quality data; rock density data
-
lithology - required; sample interval start and end depth, lithology codes, short and long descriptions; rock density data
-
interval log(s) - interval start and end depth; interval data e.g. mineralized zone identifiers, rock mass rating values
-
depth log(s) - depth; point measurement data e.g. geophysical survey data, other download log data.
If there is no survey table and there is no Azimuth and Inclination in the collars table, the desurvey algorithm will create vertical hole traces. |
Typical data table descriptions are:
Collars
Field |
Description |
BHID |
Hole name |
Easting |
X co-ordinate of the collar |
Northing |
Y co-ordinate of the collar |
Z co-ordinate of the collar |
|
Length |
Length of the hole |
Azimuth |
Azimuth at the collar |
Inclination |
Dip at the collar |
Surveys
Field |
Description |
BHID |
Hole name |
Depth At |
Depth of survey point down hole |
Azimuth |
Azimuth at survey point |
Inclination |
Dip at survey point |
Assays
Field |
Description |
BHID |
Hole name |
Distance down the hole of start of sample |
|
Distance down the hole of end of sample |
|
Density |
Rock density |
Sample 1 |
First grade or quality data column |
Sample 2 |
Second ... |
Sample 3 |
Third ... |
Sample 4 |
Fourth ... |
Lithology
Field |
Description |
BHID |
Hole name |
Depth From |
Distance down the hole of start of sample |
Depth To |
Distance down the hole of end of sample |
Density |
Rock density |
Sample 1 |
First rock description data column |
Sample 2 |
Second ... |
Sample 3 |
Third ... |
Sample 4 |
Fourth ... |
Loading Data and Defining Holes
The easiest way to create dynamic drillholes is to use the wizard to load the component tables into memory. This will load each table, allocate table types (e.g. collars, surveys etc) map the fields appropriately and then desurvey the drillholes. The tables are loaded by means of the Data Load Wizard or independently using one of the following methods:
-
Using theDataribbon, selectLoad | Hole Wizard
-
Using theDataribbon, selectLoad | External | Collars..., Surveys... etc.
Alternatively, undefined tables in memory can be defined as collars, surveys, assays etc. using the Define Hole Tables dialog accessible by selecting theSample Analysisribbon andDefine Holes.
There are two desurvey methods: straight line segments and radius of curvature; which can be selected by clicking the Desurvey Method button on the Define Hole Tables dialog. Radius of curvature is the default method as most holes are curved. There is an option for subdividing samples to smooth the trace. All drillhole traces are made up of straight lines so, for presentation purposes, it can be advantageous to divide the samples.
Dynamic drillholes require a collars and survey table to be specified, as a minimum, in order for Studio 3 to construct the base drillhole objects in memory. Additional tables, such as assays information, can be included in the process, but is not essential. |
Gaps, Overlaps and Duplicates
Your application is tolerant of sampling gaps, overlapping samples and duplicated samples, which may be unintentional data errors. These are all detected and reported to the appropriate sheet in the Reports window.
Gaps
Where there are gaps between samples, the values of all data fields within the gap interval will be treated as absent data when calculating composite values.
Overlapping and duplicated samples
Studio's compositing algorithms handle overlaps and duplicate samples correctly without calculating biased results.
-
For duplicate records Studio uses the arithmetic average for grade values.
-
For overlapping records, it uses a length weighted average value. There is no limit on the number of overlaps or duplicates for an interval.
Absent Data, Weighting and Composites
Absent Data
Studio deals with absent data values encountered in a composite by ignoring them when calculating the weighted or dominant text value of the composite. If all samples in the composite have absent values, the composite value will be absent. If the Specific Gravity Weighting method is being used but there is no S.G. value then the weighting method will revert to standard length weighting.
Weighting Method
The weighting of composite sample values may be by either Length or by weight (Length x Specific Gravity, assuming a uniform sample cross-section).
Compositing Text Values
The dominant text value in a composite is determined by calculating the total length of each text value e.g. lithology codes, and assigning the value with the maximum length to the composite.
Related Topics | |
|
Define
Holes Dialog Build Holes Dialog |