In collaboration with Iranian Watershed Management Association

Document Type : Research Paper

Authors

Associate Professor, Soil Conservation and Watershed Management Research Institute, Agricultural Research, Education and Extension Organization (AREEO), Tehran, Iran

Abstract

Introduction
Rapid population growth and economic development, especially in sensitive areas like watersheds, have increased the demand for water resources, leading to significant challenges. In watershed management, monitoring erosion and sedimentation processes is of paramount importance, as these processes directly influence the quality and quantity of water resources. Awareness of suspended sediment loads in these basins can facilitate a deeper understanding of ecological processes and assist in the assessment of the environmental status of watersheds, which in turn improves the management and conservation of water resources. The word “transform” in your sentence means to change or significantly improve something. In this context, it suggests that the design and implementation of advanced systems will lead to a significant enhancement or alteration in the way research is conducted regarding watershed management, sediment, and erosion. By aggregating and analyzing hydrologic data, this system provides accurate and up-to-date information on the amount of suspended sediment in rivers, enabling continuous and comprehensive monitoring and evaluation of watersheds. This, in turn, facilitates the adoption of necessary measures for the optimal management of these resources..
 
Materials and methods
In this research, a specialized spatial system for the management and analysis of hydrological data has been developed using the C# programming language and open-source spatial libraries. This system utilizes the SQLite database as its underlying data storage platform and employs Entity Framework 6 (EF6) and LINQ for facilitating data extraction and management. In the database design, sedimentation and flow discharge data have been comprehensively collected and stored. The system is capable of executing a variety of spatial and descriptive queries and analyses on this data. Furthermore, it provides the capability to perform statistical analyses and extract statistical summaries from the sedimentation data. These features enable researchers to process and analyze the data with ease, allowing for a more precise examination of results related to erosion and sedimentation processes. The designed system serves as an efficient tool, facilitating the monitoring and assessment of watershed conditions.
 
Results and discussion
The results of this research can be summarized into two main sections: system design and construction, and statistical analysis of sedimentation data in the Aras watershed. In the first section, which focuses on the design and development of the spatial system, appropriate graphical interfaces for data storage, user interaction with the database, and data management were designed and coded with the help of modern techniques and advanced methods. By utilizing these tools, the data extraction and management process was streamlined, and the possibility of performing statistical analyses was enabled. As a result, users can process and analyze the data with greater accuracy and ease. In the second section, the statistical results obtained from the analysis of the sedimentation data of the Aras Basin (with 26,156 data points recorded up to 2017) indicate that, at the basin scale, the average daily suspended sediment discharge is 11,814.95 tons per day, the average concentration of suspended sediment is 4,185.68 milligrams per liter, and the average instantaneous flow discharge is 13.16 cubic meters per second. At the level of study units, the highest and lowest average suspended sediment discharge values were found in the study units of Jolfā-Dūzāl (code 1105) with a value of 10,312.33 tons per day, and Qara Ziyaldin (code 1108) with a value of 991.96 tons per day, respectively. Moreover, at the hydrometric station scale, the highest and lowest average daily suspended sediment discharge were observed at the Jolfā hydrometric station (code 807-19) with 571,697.82 tons per day, and Nāvar-Khrouji Neor (code 0195-19) with 2.82 tons per day, respectively. The extreme values of suspended sediment recorded at the Jolfā hydrometric station are significantly high (over 3 million tons per day), so these figures should be used with caution. According to the findings, the land in this area is located in marly zones that are highly susceptible to erosion, and the contribution of lateral erosion in producing sediment is significant in river sections that have developed meandering patterns. However, further studies on land-use changes and other factors influencing sediment generation in this area are required.
 
Conclusion
This research was conducted with the aim of developing a national software infrastructure for managing suspended sediment data and flow discharge from hydrometric stations. The developed system possesses the capability to store, retrieve, and analyze spatial and temporal data, and it is specifically utilized for simulating suspended sediment in rivers. Additionally, advanced graphical interfaces have been created to significantly facilitate user interaction with the data. One of the notable features of this system is its use of open-source technologies in its design and development. This ensures that there are no legal restrictions or dependencies on foreign licenses for its use and development. This characteristic significantly enhances the commercialization potential of the system both domestically and in international markets. In addition to the design and development of this software system, the results obtained from its application in rapid and accurate statistical analysis of sediment data from the Aras watershed clearly demonstrate its unique capabilities in data management and analysis. Given the importance of accurately understanding erosion and sedimentation processes in the watersheds of the country, this system serves as an efficient and effective tool for obtaining precise and reliable information.

Keywords

Alomari, M.A., Aris, H., Ghaleb, M., Almurtadha, Y., Alkawsi, G.A., Al-Hadi, I.A.A.Q., Baashar, Y., Samsudin, K., 2023. Embedded devices security: Design and implementation of a light RDBMS encryption utilizing multi-core processors. IEEE Access 11, 19836-19848.
Bollen, E., Pagán, B.R., Kuijpers, B., Van Hoey, S., Desmet, N., Hendrix, R., Dams, J., Seuntjens, P., 2022. A database system for querying of river networks: facilitating monitoring and prediction applications. Water Supply 22(3), 2832-2846.
Brown, J.E., Matherne, A.M., Reale, J.K., Miltenberger, K.E., 2022. Suspended-sediment transport and water management, Jemez Canyon Dam, New Mexico, 1948–2018 (No. 2022-5081). US Geological Survey.
Cohen, S., Syvitski, J., Ashley, T., Lammers, R., Fekete, B., Li, H.Y., 2022. Spatial trends and drivers of bedload and suspended sediment fluxes in global rivers. Water Resou. Res. 58(6), e2021WR031583.
Gaffney, K.P., Prammer, M., Brasfield, L., Hipp, D.R., Kennedy, D., Patel, J.M., 2022. Sqlite: past, present, and future. Proceed. VLDB Endowment 15(12), 3535-3547.
Giadrossich, F., Murgia, I., Guastini, E., 2025. FAIR-Compliant Database for Soil Erosion Studies: The Marganai Forest Experiment. Sci Data 12, 561.
Horsburgh, J.S., Tarboton, D.G., Maidment, D.R., 2008. CUAHSI Community Observations Data Model (ODM) Version 1.1: Design specifications. [online] Available at: <http://his.cuahsi.org/odmdatabases.html>
Kadlec, J., StClair, B., Ames, D.P., Gill, R.A., 2015. WaterML R package for managing ecological experiment data on a CUAHSI HydroServer. Ecolo. Inform. 28, 19-28.
Kreibich, J., 2010. Using SQLite. O'Reilly Media, Inc. Sebastopol, CA, USA, pp. 1-528..
Lyronis, A., Varouchakis, E.A., Anyfanti, I., 2025. A Unified Open-Source Metabase Design for Hydro-meteorological Data Descriptive Analysis. Environ. Process. 12, 18. https://doi.org/10.1007/s40710-025-00758-2
Lerman, J., Miller, R., 2012. Programming Entity Framework: DbContext: Querying, Changing, and Validating Your Data with Entity Framework 1st Edition. O'Reilly Media, Inc. Sebastopol, CA, USA. pp. 1-237.
Lee, S.H., Kwon, K.R., 2013. Vector watermarking scheme for GIS vector map management. Multimedia Tool. Applica. 63, 757-790.
Li, Y., Gao, R., Kang, X., Chen, C., Zhou, Q., 2017. A watershed data management and visualization system using code-first approach. Multimedia Tool. Applica. 76, 18221-18235.
Marggraf, J., Dramais, G., Le Coz, J., Calmel, B., Camenen, B., Topping, D. J., Santini, W., Pierrefeu, G., Lauters, F., 2024. River suspended-sand flux computation with uncertainty estimation using water samples and high-resolution ADCP measurements, Earth Surf. Dynam. 12, 1243–1266, https://doi.org/10.5194/esurf-12-1243-2024, 2024.
Peres, R., 2016. Entity Framework Core Cookbook. Packt Publishing Ltd.
Saravani, M.J., Saadatpour, M., Shahvaran, A.R., 2024. A web GIS based integrated water resources assessment tool for Javeh Reservoir. Expert Sys. Applic. 252, 124198.
Schwichtenberg, H., 2018. Modern Data Access with Entity Framework Core, Apress, Essen, Germany
Shin, J.H., Grabowski, R.C., Holman, I., 2023. Indicators of suspended sediment transport dynamics in rivers. Hydrol. Res. 54(8), 978-994.
Ministry of Energy, Iran Water Resources Management Company, Office of Basic Water Resources Studies. 2024. https://stu.wrm.ir/login.asp (in Persian).
Silberschatz, A., Korth, H. F., Sudarshan, S., 2020. Database System Concepts (7th ed.). McGraw-Hill Book Company. ISBN 9780078022159. Pp. 1-1299
Su, Q., Srinivasan, R., Karthikeyan, R., 2024. SC.HAWQS: A User-Friendly Web-Based Decision Support System for Regional Water Resources Management Under a Changing Climate. Water Resour. Manage. 38, 1261–1278. https://doi.org/10.1007/s11269-023-03719-2
Tangi, M., Bizzi, S., Fryirs, K., Castelletti, A., 2022. A dynamic, network scale sediment (dis) connectivity model to reconstruct historical sediment transfer and river reach sediment budgets. Water Resour. Res. 58(2), e2021WR030784.
Wilk, P., 2022. Expanding the sediment transport tracking possibilities in a River Basin through the development of a digital platform-DNS/SWAT. Applied Sci. 12(8), 3848.
Zehra, R., Singh, M., Verma, J., 2021. WebGIS Concept of River Pollution Monitoring System—A Case Study of Yamuna River. In Proceedings of Second International Conference on Smart Energy and Communication: ICSEC 2020 (pp. 91-95). Springer Singapore.