Organic micropollutants and heavy metals in stormwater runoff of five different catchment types in Berlin (Germany)

This dataset includes concentrations of micropollutants (67), heavy metals (8) and standard parameters (9) for stormwater runoff taken from separated sewers of five catchments between 3 and 37 ha in Berlin (Germany). It also includes rain data of analyzed events as separate file. Samples were taken as part of the OgRe research project of Kompetenzzentrum Wasser Berlin (www.kompetenz-wasser.de/en/project/ogre/) in 2014 and 2015. Sampling and analytical methods are detailed in "Concentrations of micropollutants in urban stormwater runoff of different land uses" (https://doi.org/10.3390/w13091312). A dataset with concentrations of the urban stream Panke in Berlin during dry and wet weather (samples were taken as part of the same project) is available separately (https://zenodo.org/record/4633779).

Description of fields (concentrations):

SampleID: unique sample identifier

SiteID: unique site identifier (catchment type)

 1 - OLD: area with typical five-storey perimeter blocks built between 1870 and 1930 (31 ha)

 2 - NEW: newer area of 4-8-storey concrete slab buildings built between 1960 and 1980 (16 ha)

 3 - STR: 1.3 km of a busy streeat with intersection with traffic lights and bus stops (3 ha)

 4 - OFH: a residential area characterized by one-family houses and villas with gardens (17 ha)

 5 - COM: a commercial and industrial area of high imperviousness with large flat-roof buildings and yards (37 ha)

 6 - PNK: urban stream Panke (characterized by strong stormwater inputs from separate sewer discharges - available in separate dataset)

LocalDateTime: start time of sampling (local)

DateTimeUTC: start time of sampling (UTC)

UTCOffset: UTC offset to local time in h

SampleType: either "composite" for volume proportional composite sample (all samples from storm sewers) or "single" for grab sample (all stream samples, separate dataset)

VariableName: name of analysed substance/parameter

UnitsAbbreviation: either "ug/L" (microgram per litre) or "mg/L" (milligram per litre)

CensorCode: either "lt" (less than) for concentration below detection limit (value is detection limit) or "nc" (not censored) for concentration above detection limit

DataValue: measured value (if censor code is lt, value indicates detection limit)

Description of fields (rain data):

SampleID: sample identifier of matching sample (see above)

SiteID and SiteName: unique site identifier and name (catchment type) (see above)

tBeg_rain, tEnd_rain: begin and end of rain event in local time

depth.mm: rain depth of rain event in mm

duration_rain.h: duration of rain event in h

intensity_max_10min.mm_h: maximum rain intensitity of rain event in 10-min interval in mm/h

intensity_mean_event.mm_h: mean rain intensitity of rain event in mm/h

ADD.d: number of antecedent dry days in days

Rain data was collected by rain gauge network of Berlin waterworks (>40 gauges) — gauge with best correlation between rain depth and event volume in storm sewer was chosen (distances to monitoring sites: 2–6 km).

Two data files are provided in comma separated format:

"OgRe_drain.csv" contains concentrations of all stormwater runoff samples taken in separate storm sewers

"OgRe_rain.csv" contains rain data for all stormwater runoff samples

本数据集涵盖取自德国柏林5个面积3~37公顷的分流制排水管网汇水流域的雨水径流中的微污染物（micropollutants，共67种）、重金属（heavy metals，共8种）及标准参数（共9项）的浓度数据。此外还包含对应分析降雨事件的降雨数据，以独立文件形式提供。

本次采样工作于2014至2015年开展，作为柏林水能力学中心（Kompetenzzentrum Wasser Berlin，https://www.kompetenz-wasser.de/en/project/ogre/）OgRe研究项目的组成部分。采样与分析方法详见论文《Concentrations of micropollutants in urban stormwater runoff of different land uses》（DOI:10.3390/w13091312）。另有一份独立数据集记录了柏林城市河流潘克河（Panke）在干湿天气条件下的浓度数据，该样本同样取自本项目，可通过https://zenodo.org/record/4633779单独获取。

---
### 浓度数据字段说明
1. **SampleID**：唯一样本标识符
2. **SiteID**：唯一站点标识符（对应流域类型），各编码含义如下：
- 1 - OLD：1870年至1930年间建造的典型五层合围式街区（面积31公顷）
- 2 - NEW：1960年至1980年间建造的4~8层混凝土板楼新区（面积16公顷）
- 3 - STR：全长1.3km的繁忙街道，包含交通信号灯交叉口与公交站点（面积3公顷）
- 4 - OFH：以独栋住宅与带花园别墅为特征的居住区（面积17公顷）
- 5 - COM：高不透水性的工商业混合区域，配有大型平顶建筑与室外场地（面积37公顷）
- 6 - PNK：城市河流潘克河（受分流制排水管网雨水排放的强输入影响，对应独立数据集）
3. **LocalDateTime**：采样起始本地时间
4. **DateTimeUTC**：采样起始协调世界时（UTC）时间
5. **UTCOffset**：本地时间相对于UTC的时间偏移量，单位为小时
6. **SampleType**：样本类型，"composite"代表体积比例混合样（所有雨水管网采样样本），"single"代表瞬时水样（所有河道采样样本，对应独立数据集）
7. **VariableName**：被测物质/参数名称
8. **UnitsAbbreviation**：浓度单位缩写，仅支持"ug/L"（微克每升）或"mg/L"（毫克每升）
9. **CensorCode**：截尾编码，"lt"代表浓度低于检测限（此时DataValue为检测限值），"nc"代表浓度高于检测限
10. **DataValue**：实测浓度值（若CensorCode为"lt"，则该值为检测限值）

---
### 降雨数据字段说明
1. **SampleID**：对应匹配样本的标识符（详见上文）
2. **SiteID**与**SiteName**：唯一站点标识符与名称（对应流域类型，详见上文）
3. **tBeg_rain**、**tEnd_rain**：降雨事件的本地起始与结束时间
4. **depth.mm**：降雨事件总降雨量，单位为毫米
5. **duration_rain.h**：降雨事件持续时长，单位为小时
6. **intensity_max_10min.mm_h**：降雨事件10分钟间隔内的最大降雨强度，单位为mm/h
7. **intensity_mean_event.mm_h**：降雨事件的平均降雨强度，单位为mm/h
8. **ADD.d**：降雨事件发生前的连续干旱天数，单位为天

本数据集的降雨数据由柏林水务公司的雨量计网络（共40余个雨量计）采集，选取与雨水管网降雨深度及事件径流量相关性最优的雨量计数据（监测站点与雨量计的距离为2~6km）。

本次提供两个逗号分隔格式的数据文件：
1. "OgRe_drain.csv"：包含所有分流制雨水管网采集的雨水径流浓度样本
2. "OgRe_rain.csv"：包含所有雨水径流样本对应的降雨数据