Ensuring the safety of coal mining operations involves calculating ventilation tasks and emergency response plans. These calculations are performed using models of the mine workings network. The models represent a set of working objects for which their spatial coordinates are known, as well as other properties depending on the type of object. The main objects are branches – extended sections of the mined-out space. During mining operations, the structure of the mined-out space changes. These changes must be reflected in new models. However, when compiling an updated version of the model, random or unintentional inaccuracies may occur. In order to ensure the quality of the model and track the changes that have occurred, the method of geometric comparison of two sequentially created models is used. It allows you to track which sections have undergone changes in order to draw a conclusion about how the new version of the model has changed compared to the previous one, as well as to analyze what changes need to be made to the calculations made and emergency response plans. In order to automate the comparison process, this article proposes the development of a geographic information system. As part of the design process of the geographic information system, an information model was proposed that considers aspects of data import into the system, their processing and export. The structure of the system’s databases was developed, intended to represent a clear distribution of data necessary for the effective execution of queries. A visualization option was presented that allows the user to clearly present the results of model comparison.

Danila E Shabanov
Graduate Student
Kemerovo State University
6, Krasnaya Str., Kemerovo, Kemerovo region, 650000, Russia
е-mail: alvarsondar@gmail.com
ORCID: 0009-0003-5878-1751
SPIN-code: 4223-1782
AuthorID: 1217432

1. Ob utverzhdenii Federal’nykh norm i pravil v oblasti promyshlennoi bezopasnosti «Pravila bezopasnosti v ugol’nykh shakhtakh» [On approval of Federal norms and rules in the field of industrial safety ‘Safety rules in coal mines]: order of Rostechnadzor dated 08.12.2020 No. 507. Available at: https://docs.cntd.ru/document/573140209 (accessed 14.10.2025).
2. Nasibullina T.V., Lukashov O.Yu. Underground mine navigation solutions for emergency. Ugol’. 2020;(4):29–32. DOI: 10.18796/0041-5790-2020-4-29-32.
3. Kaledina N.O., Romanchenko S.B., Trofimov V.A., Gorbatov V.A. Komp’yuternoe modelirovanie zadach protivoavariinoi zashchity shakht [Computer modeling of tasks of emergency protection of mines]. Pt. 1. Moscow: MGGU, 2004. 45 p.
4. Burmin L.N., Stepanov Y.A. Specialized GIS for the simulation of a mining enterprise. Geoinformatika. 2015;(1):3–8.
5. Burmin L.N., Stepanov Y.A. Forming of spatial and attributive data for objects of mining technical systems. Geoinformatika. 2016;(4):36-40.
6. Kutsenko I.L. Optimization of query in relational databases. Eurasian Union of Scientists. 2018;(11-2):52–58. DOI: 10.31618/ESU.2413-9335.2018.2.56.52-58.
7. Tekhnicheskaya dokumentatsiya. Programma dlya EHVM «Ventilyatsiya». Versiya 2: rukovodstvo pol’zovatelya [Technical documentation. Program for computer “Ventilation”. Version 2: user manual. Available at: https://minesoft.ru/userfiles/documentation/cooling2usermanual.pdf (accessed 08.01.2025).
8. Paleev D.Y., Aksenov V.V., Lukashov O.Y., Vasenin I.M., Kraynov A.Y., Schrager E.R. Simulation of aerogasodynamic processes in ventilation systems of modern mining companies. Mining informational and analytical bulletin. 2015;(S7):224–230.
9. Galiguzova E.V., Illarionova Yu.E. Sravnenie relyatsionnykh i nerelyatsionnykh SUBD [Comparison of relational and non-relational DBMS]. Symbol of Science. 2023;(1-2):14–17.
10. Buchatskiy R.A., Sharygin E.Y., Skvortsov L.V., Zhuykov R.A., Melnik D.M., Baev R.V. Dynamic compilation of SQL queries for PostgreSQL. Proceedings of the Institute for System Programming of the RAS. 2016;28(6):37–48. DOI: 10.15514/ISPRAS-2016-28(6)-3.
11. PostGIS 3.5.2dev Manual. 29.08.2025. Available at: https://postgis.net/docs/manual-3.5/ (accessed 08.01.2025).
12. Kazakova I.A., Frolov K.M. Data access optimization based on an index. Mir sovremennoi nauki. 2014;(3):32–34.
13. Kadyrkulova N.K., Gapyrova E.O. Visualization of cartographic data in GIS environment. In: Sovremennye nauchnye znaniya: sbornik statei Mezhdunarodnoi nauchno-prakticheskoi konferentsii (Penza, 17 April 2023). Penza: Nauka i prosveshchenie, 2023. pp. 52–55.