View table

There are 1 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier NiD_GW_AnnConc
Short name GW_NO3_AvgAnnualConcentrations
Dataset NiD_water
Reference URL
Name NO3 average annual concentrations in groundwater
Short Description NO3 average annual values for each groundwater monitoring station
Definition NO3 average annual concentrations measured in each groundwater monitoring station.
Methodology for obtaining data Data on groundwater monitoring stations are collected for each reporting period (4 year period). For each station the average (mean) annual concentration for NO3 have to be reported.
The combination of the elements CountryCode, NationalStationCode, StationType and ND_Year must create a unique record in the table. No duplicate records should exist with this combination.
Please consider the following when compiling your data delivery:
1. Submit data for each sample site (no aggregation of stations).
2. Submit NO3 concentrations sampled in one station during a period of one year in one record.
3. Individual records should be provided for each year within reporting period (2008 - 2011), i.e. four records for one station with different ND_Year value are allowed.
4. mg/l NO3 is the mandatory measurement unit for Average annual concentration values
Filling out the tables:
All elements are required to be filled out unless “optional” or "voluntary" has been indicated or unless the element is not
applicable (e.g. if a monitoring station is not used for reporting for WFD, the element EU_CD cannot be filled out.)
If “mandatory” or "required" is indicated, the element shall always be filled in. After submitting the table in Reportnet, the QA in Reportnet will give an error message if the content of the cell will be empty.


Element name Datatype Element type
Country Code (CountryCode) C string Fixed values
National station code (ND_NatStatCode) C string Quantitative
Station type (ND_StationType) C string Fixed values
Year (ND_Year) C integer Quantitative
Number of samples in year (ND_NoOfSamples_Year) C integer Quantitative
Average annual value (ND_AvgAnnValue) C float Quantitative
(the C sign marks a common element)