Expulsion measurement network to areas contaminated with nitrate pursuant to § 13a DüV (12/2022) and § 4 AVV GEA

The Excel table lists all groundwater quality points of the WFD and EUA/Nitrate Measuring Network NRW, which have been used for the designation of the “red” areas contaminated with nitrate and for the immission-based demarcation of polluted/unloaded sub-areas within the affected groundwater bodies (status: 12/2022). Non-agricultural monitoring sites with nitrate or nitrate input concentrations above the groundwater threshold or an increasing trend of nitrate are not included in the table as they are not included in the area identification according to AVV GEA. The table sheet contains the following information: — 9-digit official measuring point number and name of the measuring station — Municipality and district in which the measuring point is located — Groundwater body (ID and name) to which the measuring station is assigned during monitoring — Location coordinates (for reasons of data protection do not the last two points) — Dominant land use influence in the inflow area of the measuring point — Information whether a persistently increasing nitrate trend is currently present in the period 2009-2018 according to GrwV at the measuring point (yes/no) and whether there is a nitrate value > 37.5 mg/l — mean of the maximum values MWMxJW1619 (nitrate; mg/l) of the years 2016-2019 to the measuring point — nitrate input concentration (mg/l) in the period 2016-2019, where available (the mean value is used for several measurements). The basis is measurements of the parameter “Excess-N2 (converted to nitrate in mg/L)” and the “nitrate concentration” as the sum of the same groundwater sample. The data is available in ELWAS-web. The nitrate input concentration corresponds to the nitrate concentration before denitrification in groundwater. The excess N2 (N2 formed by nitrate degradation in excess) is determined by the N2/Ar method. — Decisive value from which the information is to be deduced whether the delimitation of contaminated/unloaded subareas MWMxJW1619 or nitrate input concentration is decisive. — Information whether the measuring point is relevant for the designation of “red field blocks” or not. This is the case for agriculturally influenced measuring points where the nitrate value (MWMxJW1619) or the nitrate input concentration is greater than 50 mg/l, as well as for agriculturally influenced measuring sites where there is a rising nitrate trend and the nitrate value (MWMxJW1619) is 37.5 mg/l or greater. The Excel file contains, in addition to the data table (table sheet “AWMN_2022_11”), a table sheet explaining the attributes (table sheet “Data Information”) as well as a table sheet containing information on the groundwater bodies (table sheet “GWK table”).本Excel表格收录了欧盟水框架指令（Water Framework Directive, WFD）以及EUA/Nitrate Measuring Network NRW的全部地下水水质监测点位，上述点位曾用于划定受硝酸盐污染的“红色区域”，以及基于污染负荷划分受影响地下水体内部的污染/未受污染子区域（数据状态：2022年12月）。依据AVV GEA的区域划定规范，未将硝酸盐浓度或硝酸盐输入浓度超过地下水阈值、或硝酸盐浓度呈上升趋势的非农业监测点位纳入本表。 本表包含以下信息： — 9位官方监测点编号及监测站名称 — 监测点位所属的市及行政区 — 监测期间归属的地下水体（编号及名称） — 位置坐标（出于数据保护原因，隐去最后两位坐标信息） — 监测点入渗区域的主导土地利用影响类型 — 依据GrwV，2009-2018年期间该监测点是否存在持续上升的硝酸盐浓度趋势（是/否），以及是否存在硝酸盐浓度＞37.5 mg/L的情况 — 2016-2019年各年最大硝酸盐浓度（单位：mg/L）的平均值MWMxJW1619，对应至该监测点 — 2016-2019年的硝酸盐输入浓度（单位：mg/L，可获取时提供；多次监测时取平均值）。该数据基于“过剩N₂（换算为硝酸盐，单位mg/L）”与“硝酸盐浓度”（为同一份地下水样品的总浓度）的参数测定结果。相关数据可通过ELWAS-web获取。此处的硝酸盐输入浓度对应地下水反硝化作用发生前的硝酸盐浓度；过剩N₂（由硝酸盐降解产生的过量N₂）通过N₂/Ar法测定。 — 用于推断划定污染/未受污染子区域时应采用MWMxJW1619还是硝酸盐输入浓度的决定性指标 — 监测点位是否用于划定“红色区域块”的说明：当农业影响型监测点的硝酸盐浓度（MWMxJW1619）或硝酸盐输入浓度＞50 mg/L时，或农业影响型监测点存在硝酸盐浓度上升趋势且硝酸盐浓度（MWMxJW1619）≥37.5 mg/L时，该点位即符合划定要求。 本Excel文件除包含数据表（工作表"AWMN_2022_11"）外，还附带用于说明属性的工作表"Data Information"，以及包含地下水体相关信息的工作表"GWK table"。