View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier NiD_SW_AnnConc
Short name SW_NO3_AvgAnnualConcentrations
Dataset NiD_water
Reference URL http://dd.eionet.europa.eu/datasets/latest/NiD/tables/NiD_SW_AnnConc
Name NO3 average annual concentrations in surface water
Short Description NO3 average annual values for each surface water monitoring station
Definition NO3 average annual concentrations measured in each surface water monitoring station.
Methodology for obtaining data Data on surface water monitoring stations are collected for each reporting period (4 year period). For each station the average (mean) annual concentration for NO3 over one year have to be reported. This table should be used for all surface water monitoring stations. Discrimination between the surface water entities (river, lake, etc.) can be made by indicating the "Station type"
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 (2016 - 2019), 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.

Elements

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
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)