Refresh Drillhole Imports

Summary

Re-imports the drillhole data from the original data source, to the current drillhole dataset. All of the settings and parameters from the last import will be re-used.

Usage

When data is initially imported using an import wizard, an import template file is created which stores all the necessary information about the source of data and the format and selection of the data fields which are to be imported. The template produced during the import is stored inside the database into which the data is imported. Subsequent imports from the same source can be done using the template directly, without needing to go through the wizard again.

The Refresh Drillhole Imports tool basically re-imports (with an overwrite or append) from the original data source, by extracting the saved import templates. If you run the tool on drillholes imported from an existing Target project, it will go through each constituent database in the original drillhole project, extract the stored import template, and run an import using that template to refresh each database in turn..

Parameters

Technical Notes

Desurveying Drillholes using Collar and Survey data

The drillholes are always "desurveyed" on import, which means a 3D spatial object (a drillhole "trace") is calculated for each drillhole. The output trace for any given hole can vary depending on what type of data is available during import (collars only, vs. collar and survey data) and which method is selected to do the desurvey calculations, as well as the resolution value selected. The various ways to calculate the traces, depending on which types of data are available, are described below:

With collar locations only, no survey data present:

• If collar data includes dip and azimuth, these values are used to create straight segment traces for the entire hole, to the final depth.
• If collar data does not include dip and azimuth, the holes are assumed to be vertical.

With collar locations and dip-azimuth survey data:

• The survey data is "discretized" at the desurvey resolution interval value and a smooth curve is generated using the selected desurveying method (the default is the "Radius of curvature" method). See Drillhole Settings for more details.
• Holes are 'desurveyed' and the new trace geometries are stored in the Traces, Depth Ticks, From/To and Point datasets.
• The top-of-hole dip and azimuth values (at depth = 0) will use the values from the Survey feature class, if present.
• If top-of-hole survey values are not present, the collar dip and azimuth values will be used instead (with the collar values taking precedence).

Append New Data to Existing Dataset

When drillhole data is imported into an existing drillhole feature dataset:

• If the import data contains a hole which did not previously exist in the dataset, the new hole is added.
• If data is imported for a hole which already exists in the dataset, and the depths in the input data are greater than those in the original data, then the new data is appended to the original data.

Related Topics

• Import Drillholes from Excel or Access Files

• Import Drillholes from an ODBC Connection

• Import Drillholes from Text Files

• Import Drillholes from acQuire GIM Suite

• Import Drillholes from MX Deposit

• Import Drillholes from Target Project

• Drillhole Settings

• Resurvey Holes