Multimedia Tools and Applications

, Volume 78, Issue 1, pp 1201–1218 | Cite as

Automatic drawing technique for horizontal projection diagrams of exploration borehole deviations

  • Zhigen ZhaoEmail author
  • Xiaofei Zhu


The objective of this paper is to propose an automatic drawing technique for horizontal projection diagrams of exploration borehole deviation. In this study, a computer program was developed so as to achieve AutoCAD automatic creation of horizontal projection diagrams with low computational complexity. The main procedures include: the original borehole deviation data are used, the coordinates of the measuring points are calculated by using the average zenith angle and azimuth angle, the coordinates of the middle points are determined using the average borehole section length, and the final coordinates and the respective AutoCAD drawing exchange files are outputted. The conclusions are: the drawing exchange files can be called directly by the AutoCAD software, thereby achieving the automatic drawing of the horizontal projection diagrams of the borehole deviations. An example is provided to demonstrate that the proposed automatic drawing method is correct, concise, and efficient. And this automatic drawing technology provides significant advantages, avoiding the shortcomings of inefficient and error-prone method in the past.


Exploration borehole Deviation Horizontal projection diagram Automatic drawing technique Drawing exchange file AutoCAD software 



The research was financially supported by the National Natural Science Foundation of China (No. 41172138) and by Anhui University of Science and Technology’s core course of graduate students in 2017 (Theory of Coal Geology). The authors wish to thank Professor Jiaping YAN, Associate Professor Liuhua TONG, and Dr. Zheng ZHANG from Anhui University of Science and Technology for their constructive advice. The authors also express their gratitude to the technical personnel from Exploration and Research Institute, Anhui Bureau of Coal Geology for their kind help and discussion.


  1. 1.
    Bai Y (2013) Design of motion control system based on DXF graphic file. Inf Technol J 12(15):3096–3102CrossRefGoogle Scholar
  2. 2.
    Bernadete MMN, Gustavo HDA, Frederico GG, Renato CM, Petr YE (2012) A fuzzy genetic algorithm for automatic orthogonal graph drawing. Appl Soft Comput 12(4):1379–1389CrossRefGoogle Scholar
  3. 3.
    Cai XJ (2013) The application of excel VBA in the calculation of borehole deviation. Mine Surv 41(5):58–60Google Scholar
  4. 4.
    Chen JH, Zhou ZY, Chen G, Gu DS (2005) Automatic formation method of prospecting line profile map based on drill hole database. J Central South Univ (Sci Technol) 36(3):486–490Google Scholar
  5. 5.
    China National Standards (2016) Specification for exploration of solid mineral resources (GB/T 33444–2016)Google Scholar
  6. 6.
    Groff DD, Arockiasamy M (2013) Solving graphic-statics problems using autocad. Comput Educ J 23(2):74–81Google Scholar
  7. 7.
    Hao XZ, Yang YH, Li YP, Wang QY, Wang YP (2012) Drilling correction based on GIS technology. Prog Geophys 27(5):2233–2239Google Scholar
  8. 8.
    Hu WL, Wang P (2008) A new approach to the calculation of borehole deviation. Shaanxi Coal 27(6):31–32Google Scholar
  9. 9.
    Jiang DS (2011) Anti slanting construction technology for test hole of shaft. West-Chin Explor Eng 23(7):168–170Google Scholar
  10. 10.
    Kalashnikov AO, Ivanyuk GY, Mikhailova JA, Sokharev VA (2017) Approach of automatic 3D geological mapping: the case of the Kovdor phoscorite-carbonatite complex. NW Russia, Sci Rep 7:1–13Google Scholar
  11. 11.
    Liang WT, Zou WP, Han K, Gu ZJ (2009) Analysis of reasons for declination of drillhole. Min Eng 7(2):65–67Google Scholar
  12. 12.
    Liang YQ, Wu WQ, Wang P (2015) Path optimization in CNC automatic programming based on DXF files. Comput Syst Appl 24(6):173–176Google Scholar
  13. 13.
    Liu BG (2013) Projection and drawing of inclined boreholes in section of exploration line. Zhongzhou Coal 35(12):62–64Google Scholar
  14. 14.
    Liu GW (2016) Analysis of anti slanting technology in drilling construction of coal bed gas in large dip angle stratum. Low Carbon World 6(20):94–95Google Scholar
  15. 15.
    Liu X (2016) Research on NC lathe turning automatic programming graphic input system based on DXF shaft parts feature. J Graph 37(5):731–739Google Scholar
  16. 16.
    Liu YW (2017) Research on directional drilling technology of borehole. Coal Sci Technol Mag 38(3):52–54CrossRefGoogle Scholar
  17. 17.
    Luo XX, Zhang XX (2012) A method of borehole histogram automatic mapping based on MapGIS. Comput Eng Sci 34(1):98–102Google Scholar
  18. 18.
    Mondini AC, Chang KT, Chiang SH, Schlögel R, Notarnicola C, Saito H (2017) Automatic mapping of event landslides at basin scale in Taiwan using a Montecarlo approach and synthetic land cover fingerprints. Int J Appl Earth Obs Geoinf 63:112–121CrossRefGoogle Scholar
  19. 19.
    Ozkaya SI (2018) FRACOR-software toolbox for deterministic mapping of fracture corridors in oil fields on AutoCAD platform. Comput Geosci 112:9–22CrossRefGoogle Scholar
  20. 20.
    Qu ZG, Gong MM, Wang GZ (2017) Development of MEMS-based gyroscope sensor inclinometer. Coal Geol Explor 45(2):143–146Google Scholar
  21. 21.
    Rincón M, García-Herranz S, Díaz-Mardomingo MC, Martínez-Tomás R, Peraita H (2015) Automatic drawing analysis of figures included in neuropsychological tests for the assessment and diagnosis of mild cognitive impairment. Lect Notes Comput Sci 9107:508–515CrossRefGoogle Scholar
  22. 22.
    Su HP, Wang X, Liang X, Wang DX (2015) Thinking about correcting the hole deviation in the process of geological drilling. Non-ferrous Mining Metall 31(4):7–9Google Scholar
  23. 23.
    Wang YL, Wang JM, Cheng XX (2016) Automatic generation method of cross-platform drill hole histogram. Geotech Eng Tech 30(1):28–32Google Scholar
  24. 24.
    Wang J, Cheng WM, Zhou CH, Zheng XQ (2017) Automatic mapping of lunar landforms using DEM-derived geomorphometric parameters. J Geogr Sci 27(11):1413–1427CrossRefGoogle Scholar
  25. 25.
    Wang Q, Wan DJ, Zhang B, Chen L, Shi LH (2017) Application of excel VBA in compiling batch processing program for borehole deviation in coalfield. Coal Geol Explor 45(1):41–44Google Scholar
  26. 26.
    Yang LJ, Wu QH (2014) Method of automatic borehole logging mapping based on ArcGIS engine programme. Min Explor 5(4):639–644Google Scholar
  27. 27.
    Yang H, Zhang H (2017) Automatic 3D reconstruction of a polyhedral object from a single line drawing under perspective projection. Comput Graph (Pergamon) 65:45–59CrossRefGoogle Scholar
  28. 28.
    Zhang H, Li XQ (2014) Data extraction from DXF file and visual display. Commun Comput Inform Sci 434:286–291CrossRefGoogle Scholar
  29. 29.
    Zhang YX, Sun MX (2013) The application of excel in calculation and analysis of borehole. Jilin Water Resour 33(9):44–46Google Scholar
  30. 30.
    Zhao GF, Lu XQ (2015) Study on borehole deviation rules in Kaihua Huangshan mining area and the control measures. Explor Eng (Rock Soil Drill Tunn) 42(2):48–52Google Scholar
  31. 31.
    Zuo YJ (2005) Application of the combination of excel and ACAD in data processing of borehole deviation. Mine Const Technol 26(5):23–27MathSciNetGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.School of Surveying and MappingAnhui University of Science and TechnologyHuainan CityChina
  2. 2.School of Earth and EnvironmentAnhui University of Science and TechnologyHuainan CityChina

Personalised recommendations