View table

Identifier NiD_GW_Conc
Short name GW_NO3_concentrations
Dataset NiD_water
Reference URL http://dd-test.01dev.eea.europa.eu/datasets/latest/NiD/tables/NiD_GW_Conc
Name 2. NO3 concentrations in groundwater
Short Description NO3 values for each groundwater monitoring station
Definition NO3 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 over one or more years and the maximum value for NO3 have to be reported. If the same station (at same depth) has been used for monitoring in the previous period, a trend value (average current reporting period - average previous (3rd) reporting period) has to be indicated.
The combination of the elements CountryCode, NationalStationCode and StationType must create a unique record in the table. No duplicate records should exist with this combination.

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
* Beginning date (ND_BeginDate) C date Quantitative
* End date (ND_EndDate) C date Quantitative
* Unit of measurement (ND_MeasUnit) C string Fixed values
* Number of samples (ND_NoOfSamples) C integer Quantitative
* Average annual value (ND_AvgAnnValue) C float Quantitative
* Maximum value (ND_MaxValue) C float Quantitative
* Trend annual value (ND_TrendAnnValue) 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)