Development of a geospatial database for planning land protection measures against wind erosion

Authors

DOI:

https://doi.org/10.31548/zemleustriy2024.04.010

Keywords:

geospatial database, wind erosion, geoimages

Abstract

This study describes the development of a structure that provides an opportunity to systematize and accumulate geospatial and attributive data. In the course of the research, a geospatial data base model was developed, which ensures the accumulation of data to solve the problem of spatio-temporal analysis and support the justification of land protection measures against wind erosion. The geospatial database model is developed using a UML class diagram that illustrates not only the main design components, but also details the attributes and their data types.

The article structured an algorithm for analyzing geospatial data, structured and accumulated in a geospatial data base, to determine lands that may be threatened by wind erosion. The algorithm is presented through a functional model.

The research developed a model of the knowledge base as a component of the geospatial database, which contains both standards and additional influencing factors that affect the increase or decrease of the risk of wind erosion.

The work presents a geoimage of the studied territory with the selection of territories that may be subject to wind erosion in different seasons.

The results of the work can be used in the process of planning land protection measures to protect against wind erosion.

Key words: geospatial database, wind erosion, geoimages.

Author Biographies

  • A. Moskalenko, National University of Life and Environmental Sciences of Ukraine
    Acting head of the Department of Geoinformatics and Aerospace research of the Earth
  • V. Andriianov, National University of Life and Environmental Sciences of Ukraine
    Student

References

Borrelli, P. et al (2021). Soil erosion modelling: A global review and statistical analysis. Science of The Total Environment. 2021. Vol. 780. P. 146494. DOI: https://doi.org/10.1016/j.scitotenv.2021.146494

Kuznichenko, S., Ivanov, D., & Kuznichenko, D. (2024). Using the geospatial multi-criteria decision analysis model and methods for soil degradation risk mapping. Bulletin of National Technical University "KhPI". Series: System Analysis, Control and Information Technologies, (1 (11), 18–25. https://doi.org/10.20998/2079-0023.2024.01.03

Moskalenko, A., Geryn, A. (2022). Геоінформаційне моделювання вітрової ерозії [Geoinformation modeling of wind erosion] Zemleustrii, kadastr i monitorynh zemel, no. 4. URL: https://doi.org/10.31548/zemleustriy2022.04.11 (in Ukrainian).

Lyashchenko, A., Zakharchenko, Ye. (2019). Kontseptualʹne modelyuvannya ta pryntsypy realizatsiyi bazy heoprostorovykh danykh kadastru pryrodnykh likuvalʹnykh resursiv [Conceptual modeling and implementation principles of the database of geospatial data of the cadastre of natural medicinal resources] Naukovi zapysky Ternopilʹsʹkoho natsionalʹnoho pedahohichnoho universytetu imeni Volodymyra Hnatyuka. Ser. Heohrafiya. Ternopilʹ: TNPU im. V. Hnatyuka, 2019. № 1 (Vyp. 46). P. 232-239. (in Ukrainian).

Mykhailyk, K. O. (2023). Rozrobka struktury bazy heoprostorovykh danykh yak peredumova stvorennya HIS monitorynhu poshkodzhenykh dilyanok [Development of the structure of the geospatial database as a prerequisite for the creation of GIS monitoring of damaged area] Land structure and topographic activity in war and post-war conditions, p 77. URL: https://dglib.nubip.edu.ua/server/api/core/bitstreams/bc02c8d8-8fdd-4279-b0a6-27fa238eb876/content# page=77 (in Ukrainian).

Kokhan, S. S., Moskalenko, A. A. (2015). Development of knowledge base structure of geoinformation monitoring system for evaluation of quality status of agricultural lands. Eastern-European Journal of Enterprise Technologies. Vol. 5, Issue 2 (77). – P. 32–37. URL: https://doi.org/10.15587/1729-4061.2015.51050

Sovakov, O. V. (2014). Konstruktyvni osoblyvosti i melioratyvna efektyvnistʹ polezakhysnykh lisovykh smuh [Design features and remedial effectiveness of field protection forest strips] Naukovi dopovidi Natsionalʹnoho universytetu bioresursiv i pryrodokorystuvannya Ukrayiny, (3). (in Ukrainian).

Pismennyi, O. V. (2008). Vplyv vlastyvostey chornozemnykh ta kashtanovykh gruntiv Stepu Ukrayiny na yikh protydeflyatsiynu stiykistʹ. Visnyk ahrarnoyi nauky Prychornomorʺya [The influence of the properties of chernozem and chestnut soils of the Steppe of Ukraine on their anti-deflation resistance] Herald of Agrarian Science of the Black Sea Region. Issue 3 (46), Vol. 2. - P. 179–184. URL: https://dspace.mnau.edu.ua/jspui/handle/123456789/386 (in Ukrainian).

Vysotska, N. Yu., Tarnopilskyi, P. B., Sydorenko, S. V., Solomakha, N. G., Korotkova, T. M. Fomin, V. I., Zubov, O. R., Zubova, L. G., Yelisavenko, Yu. A., Yurchenko, V. A. (2019). Otsinka suchasnoho stanu zakhysnykh lisovykh smuh riznoho tsilʹovoho pryznachennya ta ob'yektiv lisovoyi rekulʹtyvatsiyi [Assessment of the current state of protective forest strips for various purposes and objects of forest reclamation] – 21 p. URL: https://forest.gov.ua/storage/app/sites/8/perelik-dokumentiv-shcho-shvaleni-naukovo-tehnichnoyu-radoyu/t11-state-protective-forest-belts.pdf (in Ukrainian).

Downloads

Additional Files

Published

2025-02-17

Issue

No. 4 (2024): Land management, cadastre and land monitoring

Section

Geoinformation technologies for modeling the state of geosystems

License

Relationship between right holders and users shall be governed by the terms of the license Creative Commons  Attribution – non-commercial – Distribution On Same Conditions 4.0 international (CC BY-NC-SA 4.0):https://creativecommons.org/licenses/by-nc-sa/4.0/deed.uk

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).