A database for nutrients and chlorophyll ‘a’ in the Nielba River (Poland)

The database contains results of the modeling study implemented for the agricultural catchment of the Nielba River (Poland) on total nitrogen and phosphorus loads, and chlorophyll ‘a’ concentrations. The study resulted from the research performed by the Interdisciplinary Research Group - Pollutant Transport in a Catchment (http://ochrsrod.agh.edu.pl/index.html). Using the calibrated and verified basin model created in the Macromodel DNS/SWAT [1-6] as a baseline scenario, subsequently the climate change scenarios were superimposed. The future climate conditions analysis covered moderate (RCP4.5) and extrapolative (RCP8.5) scenarios and two time horizons: short-term (2026-2035) and long-time (2046-2055) perspectives from the UAP project [7]. Four climate variant scenarios, with a monthly time step, were prepared to combine the RCP predictions and adopted time horizons: VS1 (RCP4.5 - 2026–2035); VS2 (RCP4.5 - 2046–2055), VS3 (RCP8.5 - 2026–2035), VS4 (RCP8.5 - 2046–2055). To track the total nitrogen loads, phosphorus loads and chlorophyll ‘a’ concentrations on the sub-basin level the Nielba River basin was divided into 7 units. Impacts of climate change scenarios (VS1-4) on TN (kg/m), TP (kg/m) and CHLA (µg/l) for each of these units (sub-basins) are displayed through the selection of database filters. The database consists of three Excel sheets: Sheet 1: Map – location of the Nielba River basin area along with the division into sub-basins including flow-through lakes and sub basins features: elevation, land use and soils classes share in the sub-basin area Sheet 2: Plot – pivot result plot - results of the individual scenarios impact on the nitrogen and phosphorus loads, and chlorophyll ‘a’ concentrations presented in the form of a pivot column chart. By using the "SUB”, “season” and “MON" select buttons user can filter results for the chosen sub-basin, season and month Sheet 3: Output – result values for the all sub-basins and adopted scenarios: average flows, total nitrogen and phosphorus loads, chlorophyll ‘a’ concentrations. Orlińska-Woźniak, P., Szalińska, E.,Wilk, P., 2020a. https://doi.org/10.3390/w12051499 Orlińska-Woźniak, P., Wilk, P., Szalińska, E., 2020b. https://doi.org/10.1016/j.agsy.2020.102858 Szalińska, E., Wilk, P., 2018. Economics and Environment 3 (66), 25–37. Wilk, P., Orlińska-Woźniak, P., Gębala, J., Ostojski,M., 2017. Technical Transactions (11), 137–159. Wilk, P., Orlińska-Woźniak, P., Gębala, J., 2018a. https://doi.org/10.5194/hess-22-1033-2018 Wilk, P., Orlińska-Woźniak, P., Gębala, J., 2018b. https://doi.org/10.5277/epe18040 MPA Project – Urban Adaptation Plans http://klimada.mos.gov.pl/en/mpa-project-urban-adaptation-plans/

该数据库包含针对波兰尼尔巴河农业流域开展的总氮、总磷负荷及叶绿素a浓度模拟研究的结果。此项研究由跨学科研究小组——流域污染物迁移（http://ochrsrod.agh.edu.pl/index.html）开展。

研究以Macromodel DNS/SWAT模型[1-6]构建并经校准验证的流域模型作为基准情景，随后叠加了气候变化情景。未来气候条件分析涵盖中等情景（RCP4.5）与外延情景（RCP8.5），以及UAP项目[7]提出的两个时间尺度：短期（2026-2035）与长期（2046-2055）。结合RCP预测与选定时间尺度，研究构建了四个月时间步长的气候变异情景：VS1（RCP4.5 - 2026–2035）、VS2（RCP4.5 - 2046–2055）、VS3（RCP8.5 - 2026–2035）、VS4（RCP8.5 - 2046–2055）。

为在子流域尺度上追踪总氮、总磷负荷及叶绿素a浓度，尼尔巴河流域被划分为7个单元。各单元（子流域）在气候变化情景（VS1-4）下的总氮（kg/m）、总磷（kg/m）及叶绿素a（µg/l）响应可通过数据库筛选功能查看。

该数据库包含三个Excel工作表：
Sheet1：地图——尼尔巴河流域位置及子流域划分（含通湖），并包含子流域特征：海拔、土地利用类型及土壤类型占比；
Sheet2：图表——枢纽结果图，即以枢纽柱状图形式呈现各情景对氮、磷负荷及叶绿素a浓度的影响结果。用户可通过“SUB”“season”“MON”选择按钮筛选特定子流域、季节及月份的结果；
Sheet3：输出——所有子流域及选定情景下的结果值，包括平均流量、总氮负荷、总磷负荷及叶绿素a浓度。

Orlińska-Woźniak, P., Szalińska, E., Wilk, P., 2020a. https://doi.org/10.3390/w12051499
Orlińska-Woźniak, P., Wilk, P., Szalińska, E., 2020b. https://doi.org/10.1016/j.agsy.2020.102858
Szalińska, E., Wilk, P., 2018. Economics and Environment 3 (66), 25–37.
Wilk, P., Orlińska-Woźniak, P., Gębala, J., Ostojski, M., 2017. Technical Transactions (11), 137–159.
Wilk, P., Orlińska-Woźniak, P., Gębala, J., 2018a. https://doi.org/10.5194/hess-22-1033-2018
Wilk, P., Orlińska-Woźniak, P., Gębala, J., 2018b. https://doi.org/10.5277/epe18040
MPA Project – Urban Adaptation Plans http://klimada.mos.gov.pl/en/mpa-project-urban-adaptation-plans/