Authors: Dean Smith
Working with Shiny more than 1 year
Abstract: This shiny app can be used as a first pass spatial validation of drill holes in a database before being exposed or extracted for other applications.
Full Description: Any company that maintains and manages a drill hole database such as mining, mineral exploration, and oil exploration companies will require that every drill hole in the database is spatially valid. Drill hole databases are an essential component for geological and economic modeling of the earth’s natural resources. Each drill hole in a database is defined by attributes in 3D space. They will have a beginning point with X, Y and Z coordinates and a direction recorded from downhole survey measurements that measure the direction (azimuth) and angle from the surface (dip). All drill holes in a database should be subjected to a quality control process to ensure spatial validity. Failure to implement this process could result in spatially inaccurate drill hole locations, drill directions, and a risk of losing time and money to fix issues. The easiest and quickest spatial validation method is visual, viewing drill hole traces through various sectional directions or in 3D. This shiny app can be used as a first pass spatial validation of drill holes in a database before being exposed or extracted for other applications. The app connects to one type of drill hole database hosted in Azure. Several spatial transformations are applied, and minimum curvature calculation is used to de-survey (calculate X, Y and Z coordinates) each drill hole “on the fly” to produce a plottable drill hole traces. Among others the app makes use of the libraries:
leaflet - to view drill hole locations on a map and filter selections
ggplot2 - to view drill hole traces in plan and sectional views
plotly - to view drill hole traces in a 3D plot.
Although the app is specifically designed for one type of drill hole database, it can be easily customized for any drill hole database or other sources such as file input.
Keywords: GIS, mining, mineral exploration, geology, geoscience, desurvey, 3D
Shiny app: https://atamaianalytics.shinyapps.io/DrillholeSpaitalValidation/
RStudio Cloud: https://rstudio.cloud/project/1034534