Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Groundwater / Waterbase-Groundwater: Quality

Waterbase-Groundwater: Quality

The Quality table contains data on nutrients, organic matter and selected pesticides in groundwater bodies. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the QualityWater data with their respective Bodies. Each record has two special quality assurance fields. They are explained in QA documentation which can be found in "Additional information" part.
Category
European data
Records
34031
Table definition
QA_Outlier Quality assurance field - outlier flag mean value is an outlier for current station and determinand time series: 1=yes, 0=no. tinyint(1) 0
Year Year year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. int(4) 0
Determinant_code Determinand code Identification number of the determinand monitored, as defined in the codelist. int(4) 0
NoOfSites Number of sites number of sampling sites investigated in aggregation period. int(4) 0
Drinkingwatersites Drinking water sites Number of sampling sites used for drinking water purposes. int(4) 0
Industrialsites Industrial sites Number of sampling sites used for industrial purposes. int(4) 0
Surveillancesites Surveillance sites Number of sampling sites used for surveillance purposes. int(4) 0
Pesticides_class_le_01 Pesticides class < 0.1 µg/l the number of sampling sites with at least one value above LOQ and bellow the concentration of 0.1 µg/l, within the aggregation period int(4) 0
Pesticides_class_gt_01 Pesticides class > 0.1 µg/l the number of sampling sites with at least one value exceeding concentration of 0.1 µg/l, within the aggregation period int(4) 0
Pesticides_class_lt_(lod) Pesticides class bellow LOQ the number of sampling sites with all individual values below the limit of quantification (LOQ), within the aggregation period. int(4) 0
Nitrate_class_50 Nitrate class > 50 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate &gt; 50 mg/l, within the aggregation period. int(4) 0
Nitrite_class_001 Nitrite class <= 0.01 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite &lt;= 0.01 mg/l, within the aggregation period. int(4) 0
Nitrite_class_001_003 Nitrite class > 0.01 to <= 0.03 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite between &gt; 0.01 and &lt;= 0.03 mg/l, within the aggregation period. int(4) 0
Nitrite_class_003_006 Nitrite class > 0.03 to <= 0.06 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite between &gt; 0.03 and &lt;= 0.06 mg/l, within the aggregation period. int(4) 0
Nitrite_class_006_01 Nitrite class > 0.06 to <= 0.1 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite between &gt; 0.06 and &lt;= 0.1 mg/l, within the aggregation period. int(4) 0
Nitrite_class_01 Nitrite class > 0.1 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite &gt; 0.1 mg/l, within the aggregation period. int(4) 0
Dissolvedoxygen_class_2 Dissolved Oxygen class <= 2 mg/l The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen &lt;= 2 mg/l, within the aggregation period. int(4) 0
Dissolvedoxygen_class_2_5 Dissolved Oxygen class > 2 to <= 5 mg/l The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen between &gt; 2 and &lt;= 5 mg/l, within the aggregation period. int(4) 0
Dissolvedoxygen_class_5 Dissolved Oxygen class > 5 mg/l The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen &gt; 5 mg/l, within the aggregation period. int(4) 0
Nitrate_class_10 Nitrate class <= 10 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate &lt;= 10 mg/l, within the aggregation period. int(4) 0
Nitrate_class_10_25 Nitrate class > 10 to <= 25 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate between &gt; 10 and &lt;= 25 mg/l, within the aggregation period. int(4) 0
Nitrate_class_25_50 Nitrate class > 25 to <= 50 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate between &gt; 25 and &lt;= 50 mg/l, within the aggregation period. int(4) 0
Othersites Other sites Number of sampling sites used for other purposes. int(4) 0
NoOfSamples Number of samples Number of samples included in aggregated data. int(4) 0
Ammonium_Cass_01 Ammonium class <=0.1 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium &lt;= 0.1 mg/l, within the aggregation period. int(4) 0
Ammonium_class_01_03 Ammonium class > 0.1 to <= 0.3 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium between &gt; 0.1 and &lt;= 0.3 mg/l, within the aggregation period. int(4) 0
Ammonium_class_03_05 Ammonium class > 0.3 to <= 0.5 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium between &gt; 0.3 and &lt;= 0.5 mg/l, within the aggregation period. int(4) 0
Ammonium_class_05 Ammonium class > 0.5 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium &gt; 0.5 mg/l, within the aggregation period. int(4) 0
Samplingfrequency Average sampling frequency Average frequency that the sampling sites were monitored during the aggregation period. numeric(5) 0
Minimum Minimum minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Mean Mean mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Maximum Maximum maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Median Median median concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) -1
WaterbaseID Waterbase ID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(50) -1
Determinand Determinand determinand name. nvarchar(50) 0
Unit Unit unit of measurement. nvarchar(5) 0
AggregationPeriod Period of aggregation period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only). nvarchar(10) 0
AggregatedBy Data aggregated by provides the information, whether the data were reported by country as aggregated (AggregatedBy = country) or as disaggregated (AggregatedBy = ETC/W) nvarchar(10) 0
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
QA_LRviolations Quality assurance field - numerical list of logical rules violated in record tested logical rules are explanained in QA documentation. nvarchar(20) 0
Files

Geographical coverage

[+] Show Map

Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100