Dynamic Drillhole Data
Your application supports two processes 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 stored as a desurveyed drillhole file, typically generated using a process. Dynamic drillholes use component data tables in memory (from any data source) to create drillholes in memory. Your choice will ultimately depend on how your exploration or production data is presented to you.
Tip: Use MineTrust to ensure you always have the latest field data available for your modelling, estimation and blast layout projects.
Data for Desurveying
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 can be 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.
Note: 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.
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.
Data Table Attributes
Typical data table attributes for dynamic drillhole component files and objects are:
Collars
Field |
Description |
BHID |
Hole name |
Easting |
X co-ordinate of the collar |
Northing |
Y co-ordinate of the collar |
Elevation |
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 |
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 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
Use Drillhole Importer to load dynamic table data, validate and desurvey to create a static drillhole file.
One way to create dynamic drillholes is to use the Data Load Wizard.
Related topics and activities
-
Define Holes