The article discusses the advantages of using geographic information systems (GIS) and the PostgreSQL database management system (DBMS) in karst hazard monitoring. Using the example of the territory located within the Vyaznikovsky district of the Vladimir region (Pivovarovsky karst site and its surroundings), a digital method for monitoring the karst process is demonstrated. To create, process, and store data in a database, the SQL programming language and database management system (DBMS) were chosen. A free object-relational database management system, PostgreSQL, with the postgis extension (for storing the geometry of spatial objects). The database contains information about karst formations, engineering and geological data on wells drilled at the site, as well as positional information describing the location of the object, and attributive information. The article describes the principle of a system approach to creating a database based on studying the karst massif as a whole, and not just the karst forms. The advantages of storing information in a database, the method of integrating a database with a GIS, and examples of spatial data analysis for the purposes of assessing karst hazard are described.

Marina A. Kitaeva
Student
Perm State National Research University
15, Bukireva Str., Perm, 614068, Russia
Geological Engineer
LLC «Karst-Control and Bank Protection»
4, ofc. 43, Sergey Danshсhin Str., Perm, 614068, Russia
e-mail: kitaeva0822@yandex.ru
ORCID: 0009-0001-5405-0578
SPIN-code: 9652-6080
AuthorID: 1238331

Elena V. Drobinina
Candidate of Geological and Mineralogical Sciences
Associate Professor, Researcher
Perm State National Research University
15, Bukireva Str., Perm, 614068, Russia
e-mail: alenadrobinina@yandex.ru
ORCID: 0000-0002-6756-7947
ResearcherID: GQY-6222-2022
Scopus AuthorID: 56416422000
SPIN-code: 4500-3517
AuthorID: 879933

Elizaveta R. Romanova
Researcher
Sergeev Institute of Environmental Geoscience
Russian Academy of Sciences
13, bld. 2, Ulanskiy lane, Moscow, 101000, Russia
Lecturer
Moscow State University of Civil Engineering
(National Research University)
26, Yaroslavskoye Shosse, Moscow, 129337, Russia
e-mail: romanova.elizaveta.r@yandex.ru
ORCID: 0000-0002-4102-7766
SPIN-code: 3420-8443
AuthorID: 1143907

1. Herrera G., Mateos R.M., García-Davalillo J.C. et al. Landslide databases in the Geological Surveys of Europe. Landslides. 2018;15:359–379.
DOI: 10.1007/s10346-017-0902-z.
2. Wang C., Wang T., Ding Y., van Staal C.R., Hou Z., Tonh Y., Lin S. A database for igneous rocks of the Newfoundland Appalachians. Scientific Data. 2025;12:767. DOI: 10.1038/s41597-025-05090-w.
3. Brodyagin V.V. Sozdanie i soprovozhdenie baz dannykh v geologii [Creation and maintenance of databases in geology]. Vestnik Permskogo gosudarstvennogo tekhnicheskogo universiteta. Neft’ i gaz. 2000;2(3):35–41.
4. Mamaev S.A., Ibaev Zh.G., Guseinova A.Sh., Kurbanismailova A.S., Mamaev A.S. Geoinformational databases of the data of hydrogeological parameters of artisian wells of the Terry-Kum artisian basin. Geology and geophysics of Russian South. 2018;(3):51–63. DOI: 10.23671/VNC.2018.3.16545.
5. Kanukov A.S. Integration of the geological information database in the system of geoinformation modeling. Geology and geophysics of Russian South. 2017;(3):57–66. DOI: 10.23671/VNC.2017.3.9505.
6. Krasilnikov P.A. Principles of creation and modelling engineering geology database of mineral deposits. Uchenye zapiski Krymskogo federal’nogo universiteta imeni V. I. Vernadskogo. Geografiya. Geologiya. 2019;5(3):345–357.
7. Gizatullin R.Z., Anishchik V.V. Geological databases, as the basis for operation in geological direction. PRONEFT. Professionals about oil. 2017;(3):76–79. (In Russ).
8. Savinykh V.P., Tsvetkov V.Y. Geodata as a systemic information resource. Herald of the Russian Academy of Sciences. 2014;84(5):365–368.
DOI: 10.1134/S1019331614050049.
9. Razhapova S.S., Negmatov N.N. Capabilities and components of databases of geoinformation systems. Ehkonomika i sotsium. 2022;(10-1):491–498.
10. Kitaeva M.A., Drobinina E.V. Study of geotechnical processes in karst areas using Earth remote sensing data. In: Karst and caves. 2024. Collection of scientific papers based on materials of the All-Russian scientific and practical conference with international participation (Perm – Kungur,
28 May – 1 June 2024). Perm : PGNIU; 2024. pp. 64–69.
11. Kovaleva T.G., Kamenskikh K.S. K otsenke karstoopasnosti Pivovarovskogo karstovogo uchastka [Assessment of the karst hazard of the Pivovarovsky karst area]. In: Regional’nye problemy geologii, geografii, tekhnosfernoi i ehkologicheskoi bezopasnosti: sbornik statei Vserossiiskoi nauchno-prakticheskoi konferentsii (Orenburg, 18–20 November 2019). Orenburg : Poliart; 2019. pp. 17–19.
12. Drobinina E.V., Kitaeva M.A., Romanova E.R., Ermolovich I.G. On the issue of optimizing the adoption of design schemas in karst areas using remote sensing and GIS. Sovremennye problemy distantsionnogo zondirovaniya Zemli iz kosmosa. 2024;21(5):149–157. DOI: 10.21046/2070-7401-2024-21-5-149-157.
13. Kataev V.N. Basis of monitoring system arrangement in karst-prone territories (by the example of Perm region). Geoekologiya. Inzheneraya geologiya, gidrogeologiya,geokriologiya. 2013;(1):25–41.
14. Drobinina E.V., Kitaeva M.A., Romanova E.R. Monitoring of hazardous geotechnical processes using the geoinformation systems and Earth remote sensing data. Bulletin of Perm University. Geology. 2025;24(1):23–31. DOI: 10.17072/psu.geol. 24.1.23.
15. Kitaeva M.A., Drobinina E.V. Experience in karstological zoning of linear structure design area. Speleology and spelestology. 2023;(2):21–25.
16. Kovaleva T.G., Kivileva Z.V., Balakhnin D.A., Yurkina A.R. Assessment of stability of the area near sinkholes in the village of Berezniki, Gaginskiy district. Bulletin of the Perm University. Geology. 2021;20(3):229–238. DOI: 10.17072/psu.geol. 20.3.229.