Document Actions

Waterbase - Groundwater

Versions
	V1	V2	V3	V4	V5	V6	V7	V8
English							S
A newer version of this dataset is available

Warning: A newer version of this dataset is available. Click here to go to the most recent version.

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. 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.

European data set (language: English, version 7)

European data set

Table definition
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_mdb Microsoft Access format (zip) Zip-file

Table definition
Waterbase-Groundwater: Bodies (2450 records ) 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.	Waterbase_groundwater_bodies_v7 Ascii delimited Microsoft Excel format
Waterbase-Groundwater: Pressures (1877 records ) 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.	Waterbase_groundwater_pressures_v7 Ascii delimited Microsoft Excel format
Waterbase-Groundwater: Quality (24260 records ) 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 "Additional information" part.	Waterbase_groundwater_quality_v7 Ascii delimited (zip) Zip-file Microsoft Excel format (zip) Zip-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 Ascii delimited
Tables metadata File contains metadata definitions of all data tables.	Waterbase_groundwater_v7_metadata Ascii delimited
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 Adobe acrobat reader

Reporting obligation(s) (ROD)

Groundwater quality (EWN-3)

Meta data

Unit :

DO (Dissolved Oxygen), Ammonium, Nitrite, Nitrate: mg/l

Simazine, Lindane, Atrazine: µg/l

Geographical coverage :

Albania, Austria, Belgium, Bosnia and Herzegovina, Bulgaria, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Italy, Latvia, Liechtenstein, Lithuania, Luxembourg, former Yugoslav Republic of Macedonia, Malta, Netherlands, Norway, Poland, Portugal, Serbia and Montenegro, Slovakia, Slovenia, Spain, Sweden, United Kingdom

Temporal coverage:

1960 - 2005

Source:

The European Topic Centre on Water. Version 7, date of delivery (date sent to the Data Service): 20/12/2006.

Last upload:

30 Mar 2007

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.

Keyword(s) :

determinand, eionet-water, ETC/WTR, Eurowaternet, geographic, groundwater, waterbase

EEA owned data sets

Processor:

The European Topic Centre on Water
http://water.eionet.europa.eu/

Theme :

water

Publish date:

20 Jun 2008

Owner:: European Environment Agency
http://www.eea.europa.eu/

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.