2023

Geoenvironmental data Cesar

Stefany Paola Vega Torres

Description

The water quality data of the Cesar River for this study are constituted by historical information recorded between 2004 and 2020. The first group of data comes from official sources (stations 1-6) and corresponds to physicochemical parameters measured by the Institute of Hydrology, Meteorology, and Environmental Studies (IDEAM). The second group (PM 7-30) corresponds to grey literature from documents of water resource management plans, watershed management, public services, and scientific research that describe the water quality conditions of the river (Nuñez & Reyes, 2012; Gutierrez et al., 2014; Madera et al., 2016). The structure of the database was designed under a hierarchical metadata system with a relational schema (RDBMS) which is normalized to the 3NF form, that is, in addition to being of the 2NF form, there is no transitive dependence between the attributes that are not key. The database obeys nine relational tables describing the type, primary attribute, and derived or secondary information. Raw data are included with information on physicochemical parameters, location, municipalities, surface current, region and hydro region, years reported and the source of the information, organized hierarchically. The metadata was created on the PostgreSQL platform and visualized in the QGIS environment. Also, for the queries of prop data, an open-source code was developed that encodes the meta-of the parameters or stations of interest.

Citations (0)

Mentions (0)

Metrics

Dataset Index

0.3

FAIR Score

65%

Citations

0

Mentions

0

Metrics Over Time

Publication Details

DOI

Publisher

Mendeley

License

Creative Commons Attribution 4.0 International

Assigned Domain

Subfield

Water Science and Technology

Field

Environmental Science

Domain

Physical Sciences

Confidence Score

50%

Source

Scholar Data Model

Normalization Factors

FT

73.08

CTw

1.00

MTw

1.00