Abstract
Increasing demand of the modern society for energy and raw material strengthens the role of mining in sustainable development. The basic production cycle of surface mining is initiated by drilling and blasting the material that will be loaded, hauled, and dumped by various mobile equipment. Performance measurement and analysis of all these production stages by the utilization of available technology is of crucial importance for continuous improvement of modern mine operations. Today, most of the mobile equipment used in open-pit mining have the capability to provide data related to production, positioning and machine health. Drilling equipment can be tracked by high-precision GPS systems to guide operators for the accuracy of the drill hole locations and also for comparing the drill plans and the actual drilled hole locations. Similarly, the blasting process can be managed by utilizing the data related to the amount and type of explosive charged into each blast hole. Typically, these are recorded on different environments, and each hole is named differently in each environment. As a final outcome, fragmentation of the blasted material can be investigated at multiple stages of production, such as loading, dumping, crushing, conveying, or others by using particle sizing software. However, it is challenging to derive knowledge from all of this data generated by various equipment and systems unless it is integrated for decision-making or analysis. Geospatial queries are quite effective and fast in handling geo-coordinate data and are ideal for integrating drilling and blasting data. This study introduces a systematic approach to integrate drilling and blasting related operational data collected either manually or automatically by using geospatial queries as part of integration in a data warehouse of an open-pit copper mine.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Rogers, W.P., Kahraman, M.M., Dessureault, S.: Exploring the value of using data: a case study of continuous improvement through data warehousing. Int. J. Min. Reclam. Environ. 1–11 (2017)
Durrant-Whyte, H., Geraghty, R., Pujol F., Sellschop, R.: How digital innovation can improve mining productivity, A. MacKenzie (2015)
Gokhale, B.V.: Rotary Drilling and Blasting in Large Surface Mines. CRC Press, Boca Raton (2011)
Dance, A., Mwansa S., Valery, W., Amonoo, G., Bisiaux, B.: Improvements in sag mill throughput from finer feed size at the Newmont Ahafo operation. CIM J. (2011)
Hawkes, P.: Using simulation to assess the impact of improvements in drill and blast on down stream processes. In: Mine to Mill, Brisbane, Australia (1998)
Kanchibotla, S.S., et al.: Exploring the effect of blast design on SAG mill throughput at KCGM. In: Mine to Mill Conference, Australasian Institute of Mining and Metallurgy, Brisbane, Australia (1998)
McKee, D.J.: Fragmentation and its impact on downstream processing. In: AusIMM Annual Conference—Resourcing the 21st Century (1997)
Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)
Kahraman, M.M., Dessureault, S.: Increasing adherence to mine plan through data integration and process change. Int. J. Min. Reclam. Environ. 1–14 (2017)
Kemeny, J., et al.: Analysis of rock fragmentation using digital image processing. J. Geotech. Eng. 119(7), 1144–1160 (1993)
Albrecht, J.: Geospatial information standards. A comparative study of approaches in the standardisation of geospatial information. Comput. Geosci. 25(1), 9–24 (1999)
Aitichson, A.: Beginning Spatial with SQL Server 2008, pp. 3–12 (2009)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2019 Springer Nature Switzerland AG
About this paper
Cite this paper
Erkayaoglu, M. (2019). Use of Geospatial Queries for Optimum Drilling and Blasting Practices in Surface Mining. In: Widzyk-Capehart, E., Hekmat, A., Singhal, R. (eds) Proceedings of the 27th International Symposium on Mine Planning and Equipment Selection - MPES 2018. Springer, Cham. https://doi.org/10.1007/978-3-319-99220-4_5
Download citation
DOI: https://doi.org/10.1007/978-3-319-99220-4_5
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-99219-8
Online ISBN: 978-3-319-99220-4
eBook Packages: Earth and Environmental ScienceEarth and Environmental Science (R0)