Development of an online monitoring information system based on yandex datalens

An integrated approach to safety monitoring is implemented at open-pit mining sites. Taking into account the need for systematic tracking of the current situation and prompt response, there is a reason to create a unified analytical system that combines the results of different-level instrumental observations and calculations obtained during deformation, geodetic, hydrogeological, geomechanical and satellite monitoring. The study suggests the use of one of the business intelligence services as a base for the development of a custom online monitoring system. Based on the comparison of different categories of BI-services, it has been decided to build a custom system using the open-source version of Yandex DataLens. The article describes the process of system development, including the stages of determining data sources, setting up connections, forming datasets, creating various charts (diagrams, geomaps, pivot tables, etc.), as well as building an interactive analytical panel. The parts of the developed online system, its functionality and capabilities are described in detail. The conclusion summarizes the results of the work and outlines promising directions of research development.

Grishchenkova E. N., Kutepov Yu I., Kutepova N. A. Development of an online monitoring information system based on yandex datalens. MIAB. Mining Inf. Anal. Bull. 2024;(11−1):5—24. [In Russ]. DOI: 10.25018/0236_1493_2024_111_0_5.

Grishchenkova E. N.¹, Cand. Sci. (Eng.), http://orcid.org/0000−0001−5377−7639, e-mail: grischenkova_en@pers.spmi.ru;
Kutepov Yu I.¹, Dr. Sci. (Eng.), Professor, http://orcid.org/0009−0004−3333−5699, Russia, e-mail: Kutepov_YuI@pers.spmi.ru;
Kutepova N. A.¹, Dr. Sci. (Eng.), Senior Researcher, http://orcid.org/0009−0006−3803−7222, e-mail: Kutepova_NA@pers.spmi.ru;
¹ Empress Catherine II Saint Petersburg Mining University, 199106, St. Petersburg, Vasilievsky Island, 21 Line, 2, Russia.

Grishchenkova E. N., e-mail: grischenkova_en@pers.spmi.ru.

1. Shabarov A. N., Noskov V. A., Pavlovich A. A., Cherepov A. A. The concept of geomechanical risk in open-pit mining. Mining Journal. 2022, no. 9, pp. 22–28. [In Russ]. DOI: 10.17580/gzh.2022.09.04.

2. Tsyglianu P. P., Romasheva N. V., Fadeeva M. L., Petrov I. V. Engineering projects in the fuel and energy complex of Russia: current problems, factors and recommendations for development. Ugol. 2023, no. 3, pp. 45–51. [In Russ]. DOI: 10.18796/0041−5790−2023−345−51.

3. Rybak Y., Khairutdinov M. M., Kuziev D. A., Kongar-Syuryun C. B., Babyr N. V. Prediction of the geomechanical state of the massif during mining of salt deposits with laying. Journal of Mining Institute. 2022, vol. 253, pp. 61–70. [In Russ]. DOI: 10.31897/ PMI.2022.2.

4. Melnikov N. N., Kalashnik A. I., Kalashnik N. A., Zaporozhets D. V. Complex multilevel system of geomonitoring of natural and technical objects of mining complexes. Physical and Technical Problems of Mineral Resources Development. 2018, no. 4, pp. 3–10. [In Russ]. DOI: 10.15372/FTPRPI20180401.

5. Sergina E. V. Integrated monitoring of the state of natural-technical systems of opencast coal deposits development: abstract of the dissertation. candidate of technical sciences. St. Petersburg, 2015, 22 p. [In Russ].

6. Rybin V. V., Konstantinov K. N., Nagovitsyn O. V. Structure of the complex system for monitoring the stability of surface mining facilities using digital technologies. Physical and Technical Problems of Mineral Resources Development. 2021, no. 4, pp. 70–77. [In Russ]. DOI: 10.15372/FTPRPI20210407.

7. Ponomarenko M. R., Kutepov Yu. I. Estimation of the degree of complexity of the conditions of open pit mining of mineral deposits to justify deformation monitoring of the quarry. Fiziko-Tekhnicheskie Problemy Razrabotki Polieznykh Iskopaemykh. 2021, no. 6, pp. 119–130. [In Russ]. DOI: 10.15372/FTPRPI20210611.

8. Mustafin M. G., Vasiliev B. Y., Kologrivko A. A. Analysis of the accuracy of digital elevation models construction based on the data of periodic airborne laser scanning of the mining object. Mining journal. 2023, no. 2, pp. 56–62. [In Russ]. DOI: 10.17580/ gzh.2023.02.09.

9. Usanov S. V., Konovalova Y. P., Nogin S. A., Panzhina N. A. On the problem of interrelations between deformation processes of the earth surface of natural and anthropogenic genesis. Proceedings of the TSU. Earth Sciences. 2023, no. 4, pp. 286–295. [In Russ].

10. Panzhin A. A., Mazurov B. T., Panzhina N. A. Geodynamic monitoring and modeling of the deformation field at the Korkinskoye coal deposit. Proceedings of the TSU. Earth Sciences. 2021, no. 2, pp. 94–109. [In Russ].

11. Zenkov I. V., Chinh Le Hung, Karacheva G. I., et al. Results of works on restoration ecology and environmental protection during surface mining operations at coal deposits in Australia according to satellite imagery. Ugol. 2023, no. 9, pp. 125–128. [In Russ]. DOI: 10.18796/0041−5790−2023−9-125−128.

12. Kalashnik A. I. Multilevel complex research and monitoring of natural and technical objects of the Kola region. Pskov Regionology Journal. 2023, vol. 19, no. 2, pp. 65–77. [In Russ]. DOI: 10.37490/S221979310025285−6.

13. Belyaev E. N., Burdonov A. E., Murzin N. V. Forecasting and estimation of stability of sides, slopes of cuts and dump slopes at coal deposit using Geostudio and Plaxis 3D. Proceedings of the TSU. Earth Sciences. 2023, no. 1, pp. 138–158. [In Russ]. DOI: 10.46689/2218−5194−2023−1-1−138−158.

14. Sashurin A. D., Panzhin A. A. Role of geomechanics in ensuring safe and efficient subsoil use. Modern Problems of Mechanics. 2018, no. 33, pp. 92–101. [In Russ].

15. Besimbayeva O. G., Khmyrova E. N., Tutanova M. S., Flindt N., Sharafutdinov R. R. Modern Data Analysis Technologies Used for Geomechanical Monitoring. Review. Complex use of mineral raw materials. 2023, no. 3, pp. 5–15. DOI: 10.31643/2023/6445.23.

16. Sokolov I. V., Kornilkov S. V., Panzhin A. A. Geoinformation technologies of support of mining production processes. Mining industry. 2023, no. S5, pp. 41–46. [In Russ]. DOI: 10.30686/1609−9192−2023−5S-41−46.

17. Gospodarikov A. P., Revin I. E., Morozov K. V. Composite model for analyzing seismic monitoring data during mining operations on the example of the Kukisvumchorrskoe deposit of Apatit. Journal of Mining Institute. 2023, vol. 262, pp. 571–580. [In Russ]. DOI: 10.31897/PMI.2023.9.

18. Mulev S. N., Rukavishnikov G. D., Moroz D. I., Pashkova V. I., & Moroz N. E. Monitoring of the stress state by seismic and numerical methods at the mines of JSC «Vorkutaugol». Ugol. 2022, no. 12, pp. 88–93. [In Russ]. DOI: 10.18796/0041−5790−202 2−12−88−93.

19. Gusev V. N., Blishchenko A. A., Sannikova A. P. Research of the complex of factors influencing the error of realization of the surveyor survey of mountain objects with the use of geodetic quadrocopter. Journal of Mining Institute. 2022, vol. 254, pp. 173–179. [In Russ]. DOI: 10.31897/PMI.2022.35.

20. Valkov V. A., Vinogradov K. P., Valkova E. O., Mustafin M. G. Creation of high informativity rasters from laser scanning and aerial photography data. Geodeziya i Kartografiya. 2022, vol. 83, no. 11, pp. 40–49. [In Russ]. DOI: 10.22389/0016−7126−2022−989−11−40−49.

21. Vystrchil M. G., Baltyzhakova T. I., Romanchikov A. Yu., Bogolyubova A. A. Algorithm of the Earth surface points extraction from the airborne laser scanning data. Geodeziya i Kartografiya. 2024, vol. 85, no. 2, pp. 2–11. [In Russ]. DOI: 10.22389/0016−7126−2024−1004−2-2−11.

22. Mustafin M. G., Nguyen V. H. Estimation of vertical displacements of the foundations of buildings and structures based on the analysis of deformation network elements. Geodeziya i Kartografiya. 2019, no. 3, pp. 11–19. [In Russ]. DOI: 10.22389/0016−7126−2019−945−3-11−19.

23. Cheskidov V. V., Manevich A. I., Lipina A. V. Obtaining and analyzing big data in the practice of monitoring the state of mining structures. Mining Industry. 2019, no. 2, pp. 86–88. [In Russ]. DOI: 10.30686/1609−9192−2019−2-144−86−88.

24. Cheskidov V. V. Hydrogeomechanical monitoring of the condition of slope structures. Mining Industry. 2017, no. 4, p. 78. [In Russ].

25. Choi Y., Baek J., Park S. Review of GIS-Based Applications for Mining: Planning, Operation, and Environmental Management. Applied Sciences. 2020, vol. 10(7), 2266. DOI: 10.3390/app10072266.

26. Lacroix P., Moser F., Benvenuti A., Piller T., Jensen D., Petersen I., Planque M., Ray N. MapX: an Open Geospatial Platform to Manage, Analyze and Visualize Data on Natural Resources and the Environment. SoftwareX. 2019, vol. 9, pp. 77–84. DOI: DOI:10.1016/j. softx.2019.01.002.

27. Rybin V. V., Konstantinov K. N., Kagan M. M., Panasenko I. G. Principles of organization of a complex system for monitoring the stability of objects of a mining enterprise. Mining Journal. 2020, no. 1, pp. 53–57. [In Russ]. DOI: 10.17580/gzh.2020.01.10.

28. Boikanyo H., Lotriet R., Buys P. Investigating the Use of Business, Competitive and Marketing Intelligence as Management Tools in the Mining Industry. Problems and Perspectives in Management. 2016, vol. 14(2), pp. 27–35. DOI: 10.21511/ppm.14(2).2016.03.

29. Pragnyono Seto F. C., Daryanto Y., Astanti R. D. Business Intelligence for Decision Support System for Replenishment Policy in Mining Industry. International Journal of Industrial Engineering and Engineering Management. 2023, vol. 5(1), pp. 51–60. DOI: 10.24002/ijieem.v5i1.7245.

30. Choi L. K., Panjaitan A. S., Apriliasari D. The Effectiveness of Business Intelligence Management Implementation in Industry 4.0. Startupreneur Business Digital (SABDA Journal). 2022, vol. 1(2), pp. 115–125. DOI: 10.33050/sabda.v1i2.106.

31. Antal R., Marasova D., Hajicek R., Klapko P., Mitrik V. Implementation of Business Intelligence System to Analyze the Data for Mining Mechanization — Case Study. Acta Montanistica Slovaca. 2022, no. 27, pp. 744–753. DOI: 10.46544/ams.v27i3.14.