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

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.
27th International Symposium on Mine Planning and Equipment Selection


Comparative Evaluation of CO2 Emissions in Europe and Turkey Using GIS
Demirel, Nuray (2018-11-30)
Sustainable development requires extraction and utilization of energy resources on a viable basis for the welfare of human beings and global growth. An increased focus on sustainable development and global warming imposes policy-makers and decision-makers to prioritize environmental responsibility while maximizing economic benefits to the industry. Therefore, evaluating environmental aspects and potential impacts associated with energy resources is essential. Turkey, as a signatory of Kyoto protocol, needs ...
Optimization of the lubricating oil inventory policy applied in a mining company
Şenses, Sena; Gölbaşı, Onur; Bakal, İsmail Serdar (2021-02-01)
The mining industry should sustain mass and continuous production with an essential contribution of high-capacity machinery. Therefore, spare parts inventory management is vital in ensuring the intended mining production rate as an integral part of maintenance policies. In this paper, a mixed-integer model is presented to solve a multi-item and multi-supplier spare parts inventory model. This model is addressed to a lubricating oil inventory problem in one of the biggest multi-process mining companies in Tu...
Using integrated process data of longwall shearers in data warehouses for performance measurement
Erkayaoğlu, Mustafa (2017-01-01)
Coal, still considered as one of the primary energy resources worldwide, is mined by utilising large scale equipment both on surface operations and underground mines. Technology has become a fundamental piece of modern mining operations that have to track performance of mining equipment in detail for efficient production. Data generated by mining equipment reached a level where data warehousing could be used for collecting, integrating and analysing data for a data-driven management perspective. The potenti...
Tuna, Melek; Önal, Ahmet Muhtar; Mustafa, Karaman; Department of Polymer Science and Technology (2022-1)
Significant activities have been carried out by the global research community to develop alternative sustainable building materials and energy efficient production methods, that result in more economical and sustainable building material production adhering to the comfort and aesthetic standards needed today. With the improvement of material science, polymer materials display application possibilities credited to their excellent properties compared with the inorganic materials, such as antibacterial, non-f...
Preventing claims in green construction projects through investigating the components of contractual and legal risks
Mohammadi, Sahra; Birgönül, Mustafa Talat (2016-12-15)
Construction sector has a great potential to reduce total energy consumption through the techniques applied in sustainable projects. All over the world, policy makers have already realized the potential and begun setting some governmental goals. Since new regulations for achieving sustainability have been recently set to change the conventionally practiced administrative patterns in construction sector, the number of claims related to sustainability features of the construction projects has been growing eve...
Citation Formats
M. Erkayaoğlu, “Use of Geospatial Queries for Optimum Drilling and Blasting Practices in Surface Mining,” Santiago, Şili, 2018, p. 57, Accessed: 00, 2021. [Online]. Available: