Spatial Database Designing for Environmental Monitoring and Decision Making in Mitrovica Region, The Republic of Kosovo
Abstract
The integration of spatial data analysis methods and thematic map models is an approach to reduce the negative impact of anthropogenic pressure on the environment due to mining and waste generation. The large amounts of industrial waste from mining in the Mitrovica region in northern Kosovo lead to serious environmental problems with organic and inorganic water and soil pollution. This study aims to design and establish a geospatial database for long-term environmental monitoring, provide analytical tools, and support appropriate management decisions by local authorities and agencies. The database contains topographical elements and ecological parameters collected from different national and open access international sources. All collected data have been analyzed, standardized and harmonized within the open-source QGIS ver.3 software. The results showed that in developed datasets were organized in different GIS layers and compiled several thematic maps. The designed database is unique by its architecture, providing an opportunity for periodical monitoring of the environment near the mining areas.
Keywords: Environmental monitoring; Spatial database; Open source software; QGIS; Kosovo.
Copyright (c) 2021 Geosfera Indonesia and Department of Geography Education, University of Jember
This work is licensed under a Creative Commons Attribution-Share A like 4.0 International License
References
Arctur, D., & Zeiler, M. (2004). Designing Geodatabases: case studies in GIS data modeling. California : ESRI, Inc.
BOWDOIN (2008). Spatial Data Srtucture. https://web.bowdoin.edu/~ltoma/teaching/cs340/spring08/.
Copernicus (2020). Land Monitoring Service . Retrieved from https://land.copernicus.eu/.
Dekonta, (2009). Consulting services for environmental assessment and remedial action plan for Mitrovica Industrial Park, Kosovo. Pristina : UNDP.
Duong, N. D., Nierynck, E., Van, T., & Hens, L. (1999). Land Use Changes and GIS-Database Development for Strategic Environmental Assessment in Ha Long Bay, QuangNinh province, Vietnam. In Proceedings of Application of Resource Information Technologies (GIS/GPS/RS) in Forest Land and Resources Management Conference, Hanoi, Vietnam (pp. 92-110).
ESRI (2010). GIS est Practices: Environmental Management. Redlands California. Retrieved from: https://www.esri.com/content.
Heinrich, C., & Neubauer, F. (2002). Cu – Au – Pb – Zn – Ag metallogeny of the Alpine – Balkan – Carpathian – Dinaride geodynamic province. Mineralium Deposita 37 (6): 533–40. https://doi.org/10.1007/s00126-002-0271-x.
Food and Agriculture Organization (2021). Regional and National Soil Maps and Datasets. http://www.fao.org/soils-portal/en/.
Hendricks, D. M. (2014). Maps in environmental monitoring. San Diego : Elsevier Academic Press, San Diego.
Idrizi, B., & Zhaku, S. (2013). Developing of GIS dataset for conservation of the Ohrid lake watershed area. In Proceedings of international conference “Effects of global risk in transition countries”, Peja, Kosovo.
Idrizi B.,Sulejmani, V., & Zimeri Z. (2018). Multi-scale map for three levels of spatial planning data sets for the Municipality of Vitia in Kosovo. In Proceedings of 7th International conference on cartography and GIS, Sozopol, Bulgaria.
Idrizi, B. (2020). International EPSG coding of the state coordinate reference system of the Republic of Kosovo. In Proceedings of 8th International conference on cartography and GIS, Nessebar, Bulgaria.
Ilyushchenko, & M.,Kamberov, R. (2004). Mercury Pollution. Retreived from at Pavlodar. hgpavlodar.narod.ru.
ISO (2021). Geography Information-Metadata. Retreived from https://www.iso.org/standard/26020.html.
Janecka, L., Cerba, O., Jedlicka, K., & Jezek, J. (2013). Towards interoperability of spatial planning data: 5 - steps harmonization framework. Paper Presented at 13th International Multidisciplinary Scientific GeoConference SGEM 2013, Albena, Bulgaria.
Japan Aerospace Exploration Agency (2020). The Advanced Land Observing Satellite (ALOS). Retrieved from https://global.jaxa.jp/projects/sat/alos/index.html.
Kamara, S. (2020). Development of a geographic information systems baseline spatial geodatabase template for evaluating potential and predicted environmental impacts for sustainable environmental impact assessment of mining in Sierra Leone. Journal of Geoscience and Environment Protection, 8(10), 262-284. https://doi.org/10.4236/gep.2020.810018.
Khalil, A., Hanich, L., Hakkou, R., & Lepage, M. (2014). GIS-based environmental database for assessing the mine pollution: A case study of an abandoned mine site in Morocco. Journal of Geochemical Exploration, 144(SI), 468–477. https://doi.org/10.1016/j.gexplo.2014.03.023.
Kaplan, G. (2020). Mapping three decades water changes in North Macedonia using remote sensing data. Micro, Macro & Mezzo Geoinformation, 15, 45–53.
Kolios, S.,Vorobev, A.V.,Vorobeva, G.R.,Stylios, C. (2017). GIS and environmental monitoring. Cham, Switzerland: Springer International Publishing AG.
Kosovo Cadastral Agency. (2020). Reconstruction of Cadastral Information. Retrieved from http://www.kca-ks.org.
Kranjčić, N., Đurin, B., Dogančić, D., & Plantak, L. (2018). Improving Management of Spatial Data through Spatial Database. In Environmental Sciences Proceedings (Vol. 5, No. 1, p. 5). Multidisciplinary Digital Publishing Institute. https://doi.org/10.3390/IECG2020-08865.
Krasniqi N., Krasniqi V., Fejza I. (2018). Technology of treatment and disposal of animal by-product waste and environmental protection. Micro Macro and Mezzo Geo Information. 11, 31-40.
Lein, J. K. (2006). Integrated environmental planning, 2nd ed., USA: Blackwell Science Ltd.
Lo, Y. L., Hua, K. A., & Young, H. C. (2001). GeMDA: A multidimensional data partitioning technique for multiprocessor database systems. Distributed and Parallel Databases, 9(3), 211-236.
Lubishtani, & M.,Idrizi B. (2016). Developing of the Albanian Global Map dataset; Case study: vector layers. Micro Macro and Mezzo Geo Information, 7, 61-75.
Maliqi, E., & Singh S. (2019). Quantitative estimation of soil erosion using open-access earth observation data sets and erosion potential mode. Water Conservation Science and Engineering, 4(4), 187–200. https://doi.org/10.1007/s41101-019-00078-1.
Maliqi, E. (2020). Environmental Monitoring in Mitrovica (Kosovo) by using Geospatial Technologies; Developing Spatial Database and Serial Compilation of Thematic Maps, Ph.D. Thesis, UACG, Sofia, Bulgaria.
Maryati, S., Shimada, H., Sasaoka, T., Hamanaka, A., Matsui, K., & Nagawa, H. (2012). GIS Database Template for Environmental Management of Mining in Indonesia. J. Geogr. Inf. Syst., 4 (1), 62-70. https://doi.org/10.4236/jgis.2012.41009.
Ministry of Environmental and Spatial Planning (2011). Report Environmental Hotspot in Kosovo. Retrieved from http://www.ammk-rks.net/.
Ochelebe, I., Nkebem, G. E., & Kudamnya, E. A. (2020). Assessment of heavy metals concentration and enrichment levels in soils around quarries and barite mine sites in Part of Akamkpa and Biase Area, Southeastern Nigeria. Journal of Geoscience and Environment Protection, 8 (8), 107-128. https://doi.org/10.4236/gep.2020.88009.
Open Street Map (2021). The Transportation and Hydrology Data Retrieved from https://www.openstreetmap.org.
Orimoloye, I.R., & Ololade, O.O. (2020). Spatial evaluation of land-use dynamics in gold mining area using remote sensing and GIS technology. International Journal of Environmental Science and Technology, 17(11), 4465–4480. https://doi.org/10.1007/s13762-020-02789-8.
Plassin, S., Koch, J., Paladino, S. Fiedman, J., Spencer, K., & Vache, K. (2020). A socio-environmental geodatabase for integrative research in the transboundary Rio Grande/Río Bravo basin. Scientific Data, 7(1), 1–14. https://doi.org/10.1038/s41597-020-0410-1.
QGIS (2021). QGIS Geographic Information System. Retrieved from: http://qgis.osgeo.org.
Qi, Y.Q., Xu, T. & Huang, J.S. (2017) Analysis of risk management for the coal mine operations. Energy and Power Engineering, 9(4), 12-18. https://doi.org/10.4236/epe.2017.94B002.
Retscher, G., & Kabashi, I. (2014). Possibilities of using radio frequency identification (RFID) for disaster mangement. Micro Macro and Mezzo Geo Information. 5, 1-5.
Roumenina, E., Filchev, L.,Naydenova, V., & Kanev, G. (2007). A model for geodatabase organization for purposes of largescale mapping of land-use conflicts. In INTERGEO EAST 4th International Conference, RecentProblems in Geodesy and Related Fields with Inter-national Importance. Inter Expo Centre, Sofia, Bulgaria.
Sadeghi-Niaraki, A., Jelokhani-Niaraki, M., & Choi, S.M. (2020). A volunteered geographic information-based environmental decision support system for waste management and decision making. Sustainability, 12(15), 1–21. https://doi.org/10.3390/su12156012.
Sanka, O. (2015). Use of Geographical Information System in Environmental Science. Ph.D. Thesis. Masaryk University.
Sepehr, S. (2013). Development of a geospatial reference framework. Doctoral dissertation, University of New Brunswick.
Shrestha, F., Uddin, K., Maharjan,S.B., & Bajracharya, S.R. (2016). Application of remote sensing and GIS in environmental monitoring in the Hindu Kush Himalayan region. AIMS Environmental Science, 3(4), 646–662. https://doi.org/10.3934/environsci.2016.4.646.
Thakur, J. K., Singh, S. K., Ramanathan, A., Prasad, M.B.K., & Gossel, W. (2011). Geospatial Techniques for Managing Environmental Resources. Netherlands : Springer.
USGS (2020). Landsat 8 Imagery. Retrieved from https://www.usgs.gov/.
World Climate (2021). Climate Data for 42°N 21°E .http://www.worldclimate.com/.
BOWDOIN (2008). Spatial Data Srtucture. https://web.bowdoin.edu/~ltoma/teaching/cs340/spring08/.
Copernicus (2020). Land Monitoring Service . Retrieved from https://land.copernicus.eu/.
Dekonta, (2009). Consulting services for environmental assessment and remedial action plan for Mitrovica Industrial Park, Kosovo. Pristina : UNDP.
Duong, N. D., Nierynck, E., Van, T., & Hens, L. (1999). Land Use Changes and GIS-Database Development for Strategic Environmental Assessment in Ha Long Bay, QuangNinh province, Vietnam. In Proceedings of Application of Resource Information Technologies (GIS/GPS/RS) in Forest Land and Resources Management Conference, Hanoi, Vietnam (pp. 92-110).
ESRI (2010). GIS est Practices: Environmental Management. Redlands California. Retrieved from: https://www.esri.com/content.
Heinrich, C., & Neubauer, F. (2002). Cu – Au – Pb – Zn – Ag metallogeny of the Alpine – Balkan – Carpathian – Dinaride geodynamic province. Mineralium Deposita 37 (6): 533–40. https://doi.org/10.1007/s00126-002-0271-x.
Food and Agriculture Organization (2021). Regional and National Soil Maps and Datasets. http://www.fao.org/soils-portal/en/.
Hendricks, D. M. (2014). Maps in environmental monitoring. San Diego : Elsevier Academic Press, San Diego.
Idrizi, B., & Zhaku, S. (2013). Developing of GIS dataset for conservation of the Ohrid lake watershed area. In Proceedings of international conference “Effects of global risk in transition countries”, Peja, Kosovo.
Idrizi B.,Sulejmani, V., & Zimeri Z. (2018). Multi-scale map for three levels of spatial planning data sets for the Municipality of Vitia in Kosovo. In Proceedings of 7th International conference on cartography and GIS, Sozopol, Bulgaria.
Idrizi, B. (2020). International EPSG coding of the state coordinate reference system of the Republic of Kosovo. In Proceedings of 8th International conference on cartography and GIS, Nessebar, Bulgaria.
Ilyushchenko, & M.,Kamberov, R. (2004). Mercury Pollution. Retreived from at Pavlodar. hgpavlodar.narod.ru.
ISO (2021). Geography Information-Metadata. Retreived from https://www.iso.org/standard/26020.html.
Janecka, L., Cerba, O., Jedlicka, K., & Jezek, J. (2013). Towards interoperability of spatial planning data: 5 - steps harmonization framework. Paper Presented at 13th International Multidisciplinary Scientific GeoConference SGEM 2013, Albena, Bulgaria.
Japan Aerospace Exploration Agency (2020). The Advanced Land Observing Satellite (ALOS). Retrieved from https://global.jaxa.jp/projects/sat/alos/index.html.
Kamara, S. (2020). Development of a geographic information systems baseline spatial geodatabase template for evaluating potential and predicted environmental impacts for sustainable environmental impact assessment of mining in Sierra Leone. Journal of Geoscience and Environment Protection, 8(10), 262-284. https://doi.org/10.4236/gep.2020.810018.
Khalil, A., Hanich, L., Hakkou, R., & Lepage, M. (2014). GIS-based environmental database for assessing the mine pollution: A case study of an abandoned mine site in Morocco. Journal of Geochemical Exploration, 144(SI), 468–477. https://doi.org/10.1016/j.gexplo.2014.03.023.
Kaplan, G. (2020). Mapping three decades water changes in North Macedonia using remote sensing data. Micro, Macro & Mezzo Geoinformation, 15, 45–53.
Kolios, S.,Vorobev, A.V.,Vorobeva, G.R.,Stylios, C. (2017). GIS and environmental monitoring. Cham, Switzerland: Springer International Publishing AG.
Kosovo Cadastral Agency. (2020). Reconstruction of Cadastral Information. Retrieved from http://www.kca-ks.org.
Kranjčić, N., Đurin, B., Dogančić, D., & Plantak, L. (2018). Improving Management of Spatial Data through Spatial Database. In Environmental Sciences Proceedings (Vol. 5, No. 1, p. 5). Multidisciplinary Digital Publishing Institute. https://doi.org/10.3390/IECG2020-08865.
Krasniqi N., Krasniqi V., Fejza I. (2018). Technology of treatment and disposal of animal by-product waste and environmental protection. Micro Macro and Mezzo Geo Information. 11, 31-40.
Lein, J. K. (2006). Integrated environmental planning, 2nd ed., USA: Blackwell Science Ltd.
Lo, Y. L., Hua, K. A., & Young, H. C. (2001). GeMDA: A multidimensional data partitioning technique for multiprocessor database systems. Distributed and Parallel Databases, 9(3), 211-236.
Lubishtani, & M.,Idrizi B. (2016). Developing of the Albanian Global Map dataset; Case study: vector layers. Micro Macro and Mezzo Geo Information, 7, 61-75.
Maliqi, E., & Singh S. (2019). Quantitative estimation of soil erosion using open-access earth observation data sets and erosion potential mode. Water Conservation Science and Engineering, 4(4), 187–200. https://doi.org/10.1007/s41101-019-00078-1.
Maliqi, E. (2020). Environmental Monitoring in Mitrovica (Kosovo) by using Geospatial Technologies; Developing Spatial Database and Serial Compilation of Thematic Maps, Ph.D. Thesis, UACG, Sofia, Bulgaria.
Maryati, S., Shimada, H., Sasaoka, T., Hamanaka, A., Matsui, K., & Nagawa, H. (2012). GIS Database Template for Environmental Management of Mining in Indonesia. J. Geogr. Inf. Syst., 4 (1), 62-70. https://doi.org/10.4236/jgis.2012.41009.
Ministry of Environmental and Spatial Planning (2011). Report Environmental Hotspot in Kosovo. Retrieved from http://www.ammk-rks.net/.
Ochelebe, I., Nkebem, G. E., & Kudamnya, E. A. (2020). Assessment of heavy metals concentration and enrichment levels in soils around quarries and barite mine sites in Part of Akamkpa and Biase Area, Southeastern Nigeria. Journal of Geoscience and Environment Protection, 8 (8), 107-128. https://doi.org/10.4236/gep.2020.88009.
Open Street Map (2021). The Transportation and Hydrology Data Retrieved from https://www.openstreetmap.org.
Orimoloye, I.R., & Ololade, O.O. (2020). Spatial evaluation of land-use dynamics in gold mining area using remote sensing and GIS technology. International Journal of Environmental Science and Technology, 17(11), 4465–4480. https://doi.org/10.1007/s13762-020-02789-8.
Plassin, S., Koch, J., Paladino, S. Fiedman, J., Spencer, K., & Vache, K. (2020). A socio-environmental geodatabase for integrative research in the transboundary Rio Grande/Río Bravo basin. Scientific Data, 7(1), 1–14. https://doi.org/10.1038/s41597-020-0410-1.
QGIS (2021). QGIS Geographic Information System. Retrieved from: http://qgis.osgeo.org.
Qi, Y.Q., Xu, T. & Huang, J.S. (2017) Analysis of risk management for the coal mine operations. Energy and Power Engineering, 9(4), 12-18. https://doi.org/10.4236/epe.2017.94B002.
Retscher, G., & Kabashi, I. (2014). Possibilities of using radio frequency identification (RFID) for disaster mangement. Micro Macro and Mezzo Geo Information. 5, 1-5.
Roumenina, E., Filchev, L.,Naydenova, V., & Kanev, G. (2007). A model for geodatabase organization for purposes of largescale mapping of land-use conflicts. In INTERGEO EAST 4th International Conference, RecentProblems in Geodesy and Related Fields with Inter-national Importance. Inter Expo Centre, Sofia, Bulgaria.
Sadeghi-Niaraki, A., Jelokhani-Niaraki, M., & Choi, S.M. (2020). A volunteered geographic information-based environmental decision support system for waste management and decision making. Sustainability, 12(15), 1–21. https://doi.org/10.3390/su12156012.
Sanka, O. (2015). Use of Geographical Information System in Environmental Science. Ph.D. Thesis. Masaryk University.
Sepehr, S. (2013). Development of a geospatial reference framework. Doctoral dissertation, University of New Brunswick.
Shrestha, F., Uddin, K., Maharjan,S.B., & Bajracharya, S.R. (2016). Application of remote sensing and GIS in environmental monitoring in the Hindu Kush Himalayan region. AIMS Environmental Science, 3(4), 646–662. https://doi.org/10.3934/environsci.2016.4.646.
Thakur, J. K., Singh, S. K., Ramanathan, A., Prasad, M.B.K., & Gossel, W. (2011). Geospatial Techniques for Managing Environmental Resources. Netherlands : Springer.
USGS (2020). Landsat 8 Imagery. Retrieved from https://www.usgs.gov/.
World Climate (2021). Climate Data for 42°N 21°E .http://www.worldclimate.com/.
Published
2021-08-17
How to Cite
IDRIZI, Bashkim; MALIQI, Edon; PASHOVA, Lyubka.
Spatial Database Designing for Environmental Monitoring and Decision Making in Mitrovica Region, The Republic of Kosovo.
Geosfera Indonesia, [S.l.], v. 6, n. 2, p. 189-204, aug. 2021.
ISSN 2614-8528.
Available at: <https://jurnal.unej.ac.id/index.php/GEOSI/article/view/23934>. Date accessed: 25 apr. 2024.
doi: https://doi.org/10.19184/geosi.v6i2.23934.
Section
Original Research Articles
