Waterbase - Groundwater

This website has limited functionality with javascript off. Please make sure javascript is enabled in your browser.

Created : Nov 13, 2009 Published : Jun 20, 2008 Last modified : Nov 29, 2012 11:56 AM

Topics: Water ,

Waterbase is the generic name given to the EEA's databases on the status and quality of Europe's rivers, lakes, groundwater bodies and transitional, coastal and marine waters, and on the quantity of Europe's water resources

Note: new version is available!

Mar 30, 2012 - Waterbase - Groundwater

European data

Waterbase-Groundwater: Bodies

The Bodies table contains the list of all WISE-SoE groundwater bodies reported for both the WISE-SoE data collection process and the Water Framework Directive. Detailed information about physical characteristics of the bodies and proxy pressure data within the area of the groundwater body are not provided. The data were not reported by all countries yet. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Bodies with their respective Quality data.

[+] Show table definition (records: -1)

WFDbody	WFD body	Groundwater body is a Water framework directive body. 1=yes.	tinyint(1)	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
EWNCode	EWN-Code	Internally produced, unique identifier of the groundwater body.	nvarchar(50)	0
BodyName	Groundwater body name		nvarchar(255)	0

waterbase_groundwater_v8_bodies.csv (text/comma-separated-values)
218.93 KB Download file
waterbase_groundwater_v8_bodies.dbf (dBASE document)
1.39 MB Download file
waterbase_groundwater_v8_bodies.xls (Microsoft Excel spreadsheet)
497.50 KB Download file

Waterbase-Groundwater: Microsoft Access database (2 tables)

Database contains all data tables. Includes also simple relation structure. Detailed table definitions are displayed in the section with individual tables.

waterbase_groundwater_v8_mdb.zip (ZIP archive)
863.80 KB Download file

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.

[+] Show table definition (records: 34031)

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 > 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 <= 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 > 0.01 and <= 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 > 0.03 and <= 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 > 0.06 and <= 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 > 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 <= 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 > 2 and <= 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 > 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 <= 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 > 10 and <= 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 > 25 and <= 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 <= 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 > 0.1 and <= 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 > 0.3 and <= 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 > 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

waterbase_groundwater_v8_quality_csv.zip (ZIP archive)
485.53 KB Download file
waterbase_groundwater_v8_quality_dbf.zip (ZIP archive)
866.49 KB Download file
waterbase_groundwater_v8_quality_xls.zip (ZIP archive)
1.90 MB Download file

Additional information

Country codes and abbreviations (35 records)

Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-Rivers version 8

iso3166_alpha2_codes.csv (text/comma-separated-values)
549 Bytes Download file

QA documentation

Quality control documentation briefly presents ETC/Water and EEA activities focused on quality of Waterbase-Groundwater dataset and results of these activities. In addition warning is given on the use of certain records for analytical purposes.

qadocument_waterbase-groundwater_v8.pdf (PDF document)
68.90 KB Download file

Tables metadata

File contains metadata definitions of all data tables.

waterbase_groundwater_v8_metadata.csv (text/comma-separated-values)
9.34 KB Download file

Metadata

Reporting obligations (ROD)

Groundwater quality (EWN-3)

Temporal coverage:: 1960-2005
Last upload:: 19 Jun 2008
Geographical coverage:
Rights:: EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (http://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).
Disclaimer:: Data in Waterbase are sub-samples of national data assembled for the purpose of providing comparable indicators of pressures, state and impact of waters on a Europe-wide scale and the data sets are not intended for assessing compliance with any European Directive or any other legal instrument. Information on the national and sub-national scales should be sought from other sources.
Methodology:: Used tools: Microsoft SQL Server 2005, Microsoft Access, Microsoft Excel Applied procedures: QA checks have been performed on original delivery. Results have been stored in special QA fields. Some erroneous values have been cleaned. Detail are described in QA documentation. MDB database was created by export from SQL Server. Text fields were cleared of trailing spaces. Simple relation structure was added. Whole database was compacted. XLS, CSV files was created from MDB database tables. special features: CSV files - text qualifier is ' " ' character, field separator is ',' character, line breaks were changed to <br /> string.
Units:: Simazine, Lindane, Atrazine: µg/l
DO (Dissolved Oxygen), Ammonium, Nitrite, Nitrate: mg/l
Data sources: The European Topic Centre on Water. Version 8, date of delivery (date sent to the Data Service): 21/04/2008.
Owners:: European Environment Agency (EEA)
Processors:: European Topic Centre on Inland, Coastal and Marine waters (ICM)

Permalink to this version: 9BF17528-3E95-45A9-8665-0CDB60D080D1
Permalink to latest version: 5E846079-4FF3-49B4-95F7-6E010F83D9B2

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the WISE-SoE data collection (formerly known as Eionet-Water and Eurowaternet) process. WISE-SoE data collection selects validated monitoring data from national databases and adds information on the physical characteristics of the water bodies being monitored and on the pressures potentially affecting water quality. The added value of Waterbase is that data collected through the WISE-SoE data collection process are from statistically stratified monitoring stations and groundwater bodies and are comparable at the European level. Waterbase data are primarily used in the production of the EEA's indicator-based factsheets.