High-Frequency Spatial and Temporal Water Quality Dataset for Inferring Human Fecal Contamination in Urban Drainage Systems (Sylhet, Bangladesh)

This dataset contains high-frequency spatial and temporal water quality measurements collected from two urban natural drainage networks (Malnichara and Goali Chara) and the receiving Surma River in Sylhet, Bangladesh. The data was collected over a four-week dry-weather monitoring campaign to validate an inference-based microbial source tracking (IMST) framework.
The dataset includes:
Spatial Baseline Data: Geolocations (Latitude/Longitude), urban land-use classifications (e.g., Slum, Residential, Commercial), and baseline Fecal Coliform (FC) concentrations for 62 monitoring stations.
High-Frequency Temporal Data: Hourly and daily measurements of FC (10^5 CFU/100 mL), Turbidity (NTU), and pH from targeted outfall nodes to capture diurnal and weekly "Anthropogenic Pulses."
Biochemical Oxygen Demand (BOD₅): 7-day organic loading data (mg/L) from strategic channel outfalls and river transects to quantify the "Organic Stress Gradient" and "Shoreline Plume" effects.
Hydraulic Mass-Balance Data: Channel dimensions and flow velocity measurements used to validate the relative contribution of household drain inputs.
File name: Sylhet_Urban_Drainage_WaterQuality_Dataset.xlsx
Tab Names:
01_Spatial_62_Stations (Contains: Channel, Date, Time, Mean FC, pH, Turbidity)
02_Hourly_FC_Turbidity_pH (Contains: Day, Time, Date, FC, pH, Turbidity)
03_Daily_FC_Turbidity_pH (Contains: Day, Date, FC, pH, Turbidity)
04_River_BOD5_Profile (Contains: Date, BOD)
05_Mass_Balance_Hydraulics (Contains: Channel, Sampling point, Q_drain, C_Drain, Q_u/s_C_u/s, Q_d/s, C_d/s)

本数据集收录了孟加拉国锡尔赫特市两处城市天然排水管网（Malnichara与Goali Chara）及其受纳水体苏尔玛河（Surma River）的高频时空水质监测数据。本次监测于枯水期开展，为期四周，旨在验证基于推理的微生物源追踪（Inference-based Microbial Source Tracking, IMST）框架。

数据集包含以下内容：
1. 空间基线数据：涵盖62个监测站点的地理坐标（纬度/经度）、城市土地利用分类（如贫民窟、居住区、商业区），以及基线粪大肠菌群（Fecal Coliform, FC）浓度。
2. 高频时序数据：针对特定排污口节点开展小时级与日级监测，监测指标包括FC（10^5 CFU/100 mL）、浊度（NTU）与pH值，用于捕捉昼夜与周度的“人为活动脉冲”。
3. 五日生化需氧量（Biochemical Oxygen Demand, BOD₅）数据：来自关键河道排污口与河道断面的7日有机负荷数据（mg/L），用于量化“有机应力梯度”与“岸线羽流”效应。
4. 水力质量平衡数据：包含河道尺寸与流速测量结果，用于验证家庭排水输入的相对贡献占比。

数据集文件名为：Sylhet_Urban_Drainage_WaterQuality_Dataset.xlsx
各工作表名称及对应内容如下：
01_Spatial_62_Stations：包含字段为河道、日期、时间、平均FC、pH、浊度
02_Hourly_FC_Turbidity_pH：包含字段为天数、时间、日期、FC、pH、浊度
03_Daily_FC_Turbidity_pH：包含字段为天数、日期、FC、pH、浊度
04_River_BOD5_Profile：包含字段为日期、BOD
05_Mass_Balance_Hydraulics：包含字段为河道、采样点、Q_drain、C_Drain、Q_u/s_C_u/s、Q_d/s、C_d/s