dh2loop is a python library that provides the functionality to extract and standardize geologic drill hole data and export it into readily importable interval tables (collar, survey, lithology) to feed into 3D modelling packages. It addresses the subjective nature and variability of nomenclature of lithological descriptions within and across different drilling campaigns by integrating published dictionaries, glossaries and/or thesauri that were built to improve resolution of poorly defined or highly subjective use of terminology and idiosyncratic logging methods. It also classifies lithological data into multi-level groupings that can be used to systematically upscale and downscale drill hole data inputs in multiscale 3D geological model. It also provides drill hole desurveying (computes the geometry of a drillhole in three-dimensional space) and log correlation functions so that the results can be plotted in 3D and analysed against each other. The workflow behind the string matching is illustrated here.

Upscaling Drillhole Data

Mark Jessell contributed the original idea, which was further developed by Ranee Joshi ([email protected]). The code development is led by Kavitha Madaiah ([email protected]). Mark Lindsay and Guillaume Pirot have made significant contributions to the direction of the research.

1. Install the dependencies:

• fuzzywuzzy (https://github.com/seatgeek/fuzzywuzzy)
  pip install fuzzywuzzy
  
• pandas (https://pandas.pydata.org/)
  pip install pandas
  
• psycopg2 (https://pypi.org/project/psycopg2/)
  pip install psycopg2
  
• numpy (https://github.com/numpy/numpy)
  pip install numpy
  
• nltk (https://github.com/nltk/nltk )
  pip install nltk
  
• pyproj (https://github.com/pyproj4/pyproj)
  pip install vtk
  
• vtk (https://vtk.org/download/)
  pip install vtk
  
• ipyleaflet (https://ipyleaflet.readthedocs.io/en/latest/installation.html)
  pip install ipyleaflet
  

2. Clone the repository:
   $ git clone https://github.com/Loop3D/dh2loop.git

3. Install from your local drive
   cd \local_drive\
python setup.py install --user --force

4.Run the file Lithology_With_Comments_IDLE.py in IDLE environment , if lithology with comments need to be generated efficiently in less time. start->search->IDLE->open the file Lithology_With_Comments_IDLE.py -> run ->check csv file having lithology with comments along with score.

5. Try out the demo jupyter notebook: https://github.com/Loop3D/dh2loop/blob/master/notebooks/2_Exporting_and_Text_Parsing_of_Drillhole_Data_Demo.ipynb

Please refer to the preprint currently under review.

For any bugs/feature requests/comments, please create a new issue.

This research was carried out while in receipt of the Scholarship for International Research Fees (Australian Government Research Training Program Scholarship) and Automated 3D Geology Modelling PhD Scholarship (University Postgraduate Award) at the University of Western Australia. The work has been supported by the Mineral Exploration Cooperative Research Centre (MinEx CRC; https://minexcrc.com.au/) whose activities are funded by the Australian Government's Cooperative Research Centre Program. This work was also done with the Loop Consortium (http://loop3d.org) as part of an international effort to found a new open-source platform to build the next generation of 3D geological modelling tools.