Geoenvironmental data of the Cesar River, Colombia

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.