Skip to main content

Use of Geospatial Queries for Optimum Drilling and Blasting Practices in Surface Mining

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.

Keywords

  • Drill and blast integration
  • Data warehousing
  • Data integration
  • Geospatial query

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-3-319-99220-4_5
  • Chapter length: 11 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   169.00
Price excludes VAT (USA)
  • ISBN: 978-3-319-99220-4
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Hardcover Book
USD   219.99
Price excludes VAT (USA)
Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5

References

  1. 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)

    Google Scholar 

  2. Durrant-Whyte, H., Geraghty, R., Pujol F., Sellschop, R.: How digital innovation can improve mining productivity, A. MacKenzie (2015)

    Google Scholar 

  3. Gokhale, B.V.: Rotary Drilling and Blasting in Large Surface Mines. CRC Press, Boca Raton (2011)

    Google Scholar 

  4. 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)

    Google Scholar 

  5. 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)

    Google Scholar 

  6. 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)

    Google Scholar 

  7. McKee, D.J.: Fragmentation and its impact on downstream processing. In: AusIMM Annual Conference—Resourcing the 21st Century (1997)

    Google Scholar 

  8. Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377–387 (1970)

    CrossRef  Google Scholar 

  9. Kahraman, M.M., Dessureault, S.: Increasing adherence to mine plan through data integration and process change. Int. J. Min. Reclam. Environ. 1–14 (2017)

    Google Scholar 

  10. Kemeny, J., et al.: Analysis of rock fragmentation using digital image processing. J. Geotech. Eng. 119(7), 1144–1160 (1993)

    CrossRef  Google Scholar 

  11. Albrecht, J.: Geospatial information standards. A comparative study of approaches in the standardisation of geospatial information. Comput. Geosci. 25(1), 9–24 (1999)

    CrossRef  Google Scholar 

  12. Aitichson, A.: Beginning Spatial with SQL Server 2008, pp. 3–12 (2009)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to M. Erkayaoglu .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and Permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Verify currency and authenticity via CrossMark

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