A Scenario Database and Analysis Interface for Mass Balance Solutions at the Reach Scale on the Logan River

Karst aquifers are important water resources all over the globe. Due to the fractured and dissolved geology in karst aquifers, the exchange between stream and groundwater is difficult to quantify. One method for estimating stream and groundwater exchange is solving a mass balance at the reach scale (Neilson et al. 2018). Primarily, a mass balance requires discharge and concentration data for a conservative constituent such as sodium or chloride. Secondarily, a mass balance requires several assumptions to limit the unknowns. Variations in which concentration data and assumptions are used in the mass balance produce numerous estimations of exchange rates between stream and groundwater for many scenarios. The purpose of this resource was to effectively store exchange rate estimates for various scenarios and provide an accessible interface to analyze the scenario estimates for 26 reaches in Logan Canyon. This resource includes an SQLite database that stores the estimate and scenario data. Then, the database was populated by linking it to the mass balance model. Additionally, GIS was used to obtain geologic layer data, a portion of this data was also added to the database. The Jupyter Notebook included in this resource analyzes the model output and examines the sensitivity of the model to parameters such as assumptions and data input.

喀斯特含水层（Karst aquifers）是全球范围内极为重要的水资源。由于喀斯特含水层内赋存裂隙溶蚀型地质结构，河道水流与地下水之间的交换过程难以量化。估算河道水流与地下水交换量的一种常用方法，是在河段尺度上求解质量平衡方程（Neilson等，2018）。首要而言，质量平衡计算需获取钠、氯化物等保守组分的流量与浓度数据；其次，为约束未知变量，质量平衡计算需引入若干假设条件。在质量平衡计算中，所采用的浓度数据与假设条件的差异，会针对多种情景生成大量河道水流与地下水交换速率的估算结果。本数据集的核心目标是高效存储不同情景下的交换速率估算结果，并提供便捷的交互界面，以针对洛根峡谷（Logan Canyon）内的26个河段开展情景估算结果分析。本数据集包含一个SQLite数据库，用于存储交换速率估算结果与情景相关数据；随后通过将该数据库与质量平衡模型关联，完成了数据库的数据填充。此外，本数据集借助地理信息系统（GIS）获取了地质图层数据，并将其中部分数据录入数据库。本数据集附带的Jupyter Notebook可对模型输出结果进行分析，并检验模型在假设条件、数据输入等参数下的敏感性。