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!

European data

Waterbase-Groundwater: Bodies

The Bodies table contains the physical characteristics of the Eionet-Water groundwater bodies. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Bodies with their respective Quality and Pressures data.

[+] Show table definition (records: 2450)

GwHorizon	Groundwater horizon	groundwater horizon in which the groundwater body is mainly situated: 1=top horizon, etc.	int(4)	0
GwBodyThickness	Groundwater body thickness	mean thickness of the groundwater body in m.	numeric(5)	0
GwDepthTo	Depth to groundwater	mean depth to groundwater from the surface to the top of the groundwater body in m.	numeric(5)	0
GwBodyArea	Groundwater body area	Groundwater body area in km²	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
DataSource	Data source	source of data: Eionet-Water, ICES.	nvarchar(50)	0
WaterDataSet	Water data set	RV=rivers, LK=lakes, GW=groundwater, TCM=transitional, coastal or marine waters, QA=water quantity.	nvarchar(5)	0
WaterbaseName	Waterbase name	name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or name of the groundwater body.	nvarchar(255)	0
AquiferType	Aquifer type	predominant aquifer type (Porous media, Fractured media, Karstic media).	nvarchar(20)	0
Country	Country name (ISO 3166-1)	official short name in English	nvarchar(100)	0
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

waterbase_groundwater_bodies_v7.csv (text/comma-separated-values)
223.95 KB Download file
waterbase_groundwater_bodies_v7.xls (Microsoft Excel spreadsheet)
410.00 KB Download file

Waterbase-Groundwater: Microsoft Access database (3 tables)

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

waterbase_groundwater_v7.zip (ZIP archive)
526.02 KB Download file

Waterbase-Groundwater: Pressures

The Pressure table contains proxy pressure data within the area of the groundwater body. Each groundwater body has been assigned a unique Waterbase identifier (WaterbaseID) which can be used to link the Pressure data with their respective Bodies and Quality data.

[+] Show table definition (records: 1877)

LanduseArableLand	Arable land use	arable land use as a percentage of the upstream catchment of the river monitoring station or lake, within the area of the groundwater body, the upstream catchment or drainage basin of the transitional water (TCM data set), or the area within the River Basin District to which the coastal water has been assigned (TCM data set). Land use based on Corine Land Cover category 2.1.	numeric(5)	0
AnnualPrecipitation	Annual precipitation	mean long term average annual precipitation over the groundwater body in mm/year.	numeric(5)	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
Remarks	Remarks	remarks, comments or explanatory notes.	nvarchar(255)	0

waterbase_groundwater_pressures_v7.csv (text/comma-separated-values)
54.20 KB Download file
waterbase_groundwater_pressures_v7.xls (Microsoft Excel spreadsheet)
165.00 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 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.

[+] Show table definition (records: 24260)

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

waterbase_groundwater_quality_v7_csv.zip (ZIP archive)
234.63 KB Download file
waterbase_groundwater_quality_v7_xls.zip (ZIP archive)
1.16 MB Download file

Additional information

Country codes and abbreviations (33 records)

Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-Groundwater version 7.

iso3166_alpha2_codes_groundwater.csv (text/comma-separated-values)
536 Bytes Download file

QA documentation

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

qadocument_waterbase-groundwater_v7.pdf (PDF document)
61.69 KB Download file

Tables metadata

File contains metadata definitions of all data tables.

waterbase_groundwater_v7_metadata.csv (text/comma-separated-values)
7.13 KB Download file

Metadata

Reporting obligations (ROD)

Groundwater quality (EWN-3)

Temporal coverage:: 1960-2005
Last upload:: 30 Mar 2007
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 7, date of delivery (date sent to the Data Service): 20/12/2006.
Owners:: European Environment Agency (EEA)
Processors:: European Topic Centre on Inland, Coastal and Marine waters (ICM)

Permalink to this version: 365DE4A4-24CC-4743-A5D7-C8A1DF11265E
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 Eionet-Water (formerly known as Eurowaternet) process. Eionet-Water 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 Eionet-Water 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.