Abstract
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.








Similar content being viewed by others
References
Bai Y (2013) Design of motion control system based on DXF graphic file. Inf Technol J 12(15):3096–3102
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–1389
Cai XJ (2013) The application of excel VBA in the calculation of borehole deviation. Mine Surv 41(5):58–60
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–490
China National Standards (2016) Specification for exploration of solid mineral resources (GB/T 33444–2016)
Groff DD, Arockiasamy M (2013) Solving graphic-statics problems using autocad. Comput Educ J 23(2):74–81
Hao XZ, Yang YH, Li YP, Wang QY, Wang YP (2012) Drilling correction based on GIS technology. Prog Geophys 27(5):2233–2239
Hu WL, Wang P (2008) A new approach to the calculation of borehole deviation. Shaanxi Coal 27(6):31–32
Jiang DS (2011) Anti slanting construction technology for test hole of shaft. West-Chin Explor Eng 23(7):168–170
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–13
Liang WT, Zou WP, Han K, Gu ZJ (2009) Analysis of reasons for declination of drillhole. Min Eng 7(2):65–67
Liang YQ, Wu WQ, Wang P (2015) Path optimization in CNC automatic programming based on DXF files. Comput Syst Appl 24(6):173–176
Liu BG (2013) Projection and drawing of inclined boreholes in section of exploration line. Zhongzhou Coal 35(12):62–64
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–95
Liu X (2016) Research on NC lathe turning automatic programming graphic input system based on DXF shaft parts feature. J Graph 37(5):731–739
Liu YW (2017) Research on directional drilling technology of borehole. Coal Sci Technol Mag 38(3):52–54
Luo XX, Zhang XX (2012) A method of borehole histogram automatic mapping based on MapGIS. Comput Eng Sci 34(1):98–102
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–121
Ozkaya SI (2018) FRACOR-software toolbox for deterministic mapping of fracture corridors in oil fields on AutoCAD platform. Comput Geosci 112:9–22
Qu ZG, Gong MM, Wang GZ (2017) Development of MEMS-based gyroscope sensor inclinometer. Coal Geol Explor 45(2):143–146
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–515
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–9
Wang YL, Wang JM, Cheng XX (2016) Automatic generation method of cross-platform drill hole histogram. Geotech Eng Tech 30(1):28–32
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–1427
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–44
Yang LJ, Wu QH (2014) Method of automatic borehole logging mapping based on ArcGIS engine programme. Min Explor 5(4):639–644
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–59
Zhang H, Li XQ (2014) Data extraction from DXF file and visual display. Commun Comput Inform Sci 434:286–291
Zhang YX, Sun MX (2013) The application of excel in calculation and analysis of borehole. Jilin Water Resour 33(9):44–46
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–52
Zuo YJ (2005) Application of the combination of excel and ACAD in data processing of borehole deviation. Mine Const Technol 26(5):23–27
Acknowledgements
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.
Author information
Authors and Affiliations
Corresponding author
Additional information
Publisher’s Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
About this article
Cite this article
Zhao, Z., Zhu, X. Automatic drawing technique for horizontal projection diagrams of exploration borehole deviations. Multimed Tools Appl 78, 1201–1218 (2019). https://doi.org/10.1007/s11042-018-6659-0
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s11042-018-6659-0