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 and Pressure data. Each record has two special quality assurance fields. They are explained in QA documentation which can be found in &quot;Additional information&quot; part.

Category

European data set

Records

24260

Table definition

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)	-1
NoOfSites	Number of sites	number of sampling sites investigated in aggregation period.	int(4)	0
QA_Outlier	Quality assurance field - outlier flag	mean value is an outlier for current station and determinand time series: 1=yes, 0=no.	bit(1)	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
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
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
25Percentile	25th percentile	25th percentile 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
75Percentile	75th percentile	75th percentile 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)	0
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)	-1
Unit	Unit	unit of measurement.	nvarchar(20)	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(20)	-1
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(100)	0