Water quality data from the Cesar River, Colombia

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.

本研究使用的塞萨尔河（Cesar River）水质数据，由2004年至2020年间记录的历史资料构成。第一组数据来自官方渠道（1-6号监测站），对应由水文、气象与环境研究学院（Institute of Hydrology, Meteorology, and Environmental Studies，IDEAM）实测得到的理化参数。第二组数据（PM 7-30）则来源于灰色文献，涵盖水资源管理规划、流域治理、公共服务及科学研究类文档，用于描述该河流水质状况（Nuñez & Reyes, 2012; Gutierrez et al., 2014; Madera et al., 2016）。本数据库的架构基于分层元数据系统，采用经过第三范式（Third Normal Form, 3NF）规范化的关系型模式，依托关系型数据库管理系统（Relational Database Management System, RDBMS）构建；即该模式需满足第二范式（Second Normal Form, 2NF）的要求，且非键属性之间不存在传递依赖关系。数据库共包含9个关系表，用于描述数据类型、主属性以及衍生/二级信息。原始数据以层级化方式组织，涵盖理化参数、采样点位、所属市政辖区、地表径流、区域与水文分区、报告年份及数据来源等信息。元数据基于PostgreSQL平台创建，并在QGIS地理信息系统环境中完成可视化展示。此外，为满足目标参数或监测站的查询需求，本研究开发了一段开源代码，用于编码对应参数或监测站的元数据。