Skip to content

Drill Hole Planner

Jump to bottom
bsomps edited this page Jan 8, 2025 · 12 revisions

The drill hole planner operator is designed to both export and import planned drill holes from a collar table (CSV file). Please ensure your CSV has columns for the following input data;

Input Data

  • Hole ID: The unique identifier for each planned hole (e.g. DDH-01)
  • X: The easting coordinate of the collar location. Ensure projected coordinate system (meters or feet). Ensure it matches the CRS that your blender scene is set to.
  • Y: The northing coordinate of the collar location.
  • Z: The elevation of the collar location (meters or feet).
  • Total Depth: Planned total depth for each hole, meters or feet - which ever your coordinate system corresponds to.
  • Azimth: The planned azimuth (0-360) for each hole.
  • Dip: The planned dip (0-90) for each hole. Ensure dips are negative values. (e.g. -45)

Importing Planned Drill Holes

1. Under Drilling click the drop down arrow for Drill Hole Planner

2. Select Load Planned Drill Holes (CSV). This will bring up your file browser, select your planned drill hole CSV file.

3. Fill in the populated columns as appropriate.

4 Select Render Planned Drill Holes

  • This will render the planned drill holes as single curve objects into your scene. Each hole will be titled as the Hole ID assigned in your CSV file within the outliner.

Exporting Planned Drill Holes (Manual Creation)

In addition to adding planned drill holes via a collar table, you can also manually create drill holes as curve objects (lines) and then export these objects back into collar table format (CSV).

1. In Object Mode, create a curve object by going to Add → Curve → Path.

2. In Edit Mode, simplify the curve object by deleting all vertices except the two end points.

3. In edit mode, you can now move these two vertices around (select them, hit G to grab and move around) until you've achieved the correct location and orientation of your planned drill hole. In Object Mode, you can select the entire object and move/rotate as well.

4. Ensure each object is named what you would like the Hole ID to be.

4. Put all of your manually created planned drill holes into a single collection. This can be done by selecting them all at once, right click on the viewport, and select Move to Collection. Here, you can create a new collection to put them into.

5. Under the Drill Hole Planner drop down menu, find the option for Export Planned Drill Holes, and choose the collection which holds the objects.

6. Click Export Planned Drill Holes. This will bring up your file browser, where you can save as CSV to your files.

The export will automatically create columns for;

  • Hole ID: The name you've assigned each object in the outliner
  • X: Generates the easting coordinate in your assigned CRS.
  • Y: Generates the northing coordinate in your assigned CRS.
  • Z: Generates the elevation value in your assigned CRS
  • Total Depth: Calculates the total depth based on scene CRS
  • Azimth: Calculates the azimuth (0-360) for each hole.
  • Dip: Calculates the dip (0-90) for each hole.
Clone this wiki locally