Geoenvironmental data of the Cesar River, Colombia
Description
The database includes climatic, hydrological, physicochemical, and erosion information for 2005–2019. Climatic and hydrological data were provided by IDEAM stations. . Modeled monthly mean flow data for stations 3 and 4 were also incorporated, obtained using the HydroBID hydrological model. Water quality information comes from official sources for stations 1, 3, and 4. It was also supplemented with gray literature from water resource management plans, watershed management plans, utility reports, and scientific research describing the river's water quality conditions (Gutiérrez et al., 2011; Núñez & Reyes, 2012; Madera et al., 2016). Modeled data from the dynamic water quality model (DynQual) were also included. This model simulates five variables with a monthly temporal resolution and a spatial resolution of 10 km: water temperature (T), total dissolved solids (TDS), biological oxygen demand (BOD), and fecal coliforms (FC). Due to the scarcity of sediment concentration data from official stations, the database includes 10-year projections (2010-2020) calculated by the RUSLE erosion model. These projections allow the analysis of erosion levels in the area influenced by stations 3, 4, and 19. Regarding its structure, the database was designed using a hierarchical metadata system with a relational database (RDBMS) based on the international standard SQL/MED (SQL Management of External Data) to ensure interoperability between database systems and the management of external data using SQL (ISO, 2016). The normalization process achieved the third normal form (3NF), ensuring that each primary element is accessible by a unique key (Skavantzos & Link, 2023). Additionally, the criteria for the second normal form (2NF) were met, eliminating transitive dependencies between non-key attributes. Due to the scarcity of sediment concentration data from official stations, the database includes 10-year projections (2010-2020) calculated by the RUSLE erosion model. These projections allow for the analysis of erosion levels in the area influenced by stations 3, 4, and 19. Regarding its structure, the database was designed using a hierarchical metadata system with a relational database (RDBMS) based on the international standard SQL/MED (SQL Management of External Data) to ensure interoperability between database systems and the management of external data using SQL (ISO, 2016). The normalization process achieved the third normal form (3NF), ensuring that each primary element is accessible by a unique key (Skavantzos & Link, 2023). Furthermore, the criteria for the second normal form (2NF) were met, eliminating transitive dependencies between non-key attributes.
Files
Steps to reproduce
Cesar_river.tar: Comprises a backup of the database developed in the PostgreSQL open-source object-oriented relational database management system. ADG_1.txt;ADG_2.txt;ADG_3.txt;Data.txt;DocID.txt;HDG.txt;RepID.txt;RepSHP.txt;RepTY.txt;SDG.txt: Raw data from the tables relationships comprising the database in PostgreSQL. Database_Diagram.png: Database diagram on water quality of the Cesar River. The primary attributes are the unique elements per table, in this case, they are represented by the black key; secondary information is identified by green keys; and the rest of the information is derived
Institutions
- Universidad del Norte