Waterbase - Groundwater

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

Created : Nov 13, 2009 Published : Jul 01, 2004 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 Eurowaternet 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 Pressure data.

[+] Show table definition (records: 730)

GwBodyThickness	Groundwater body thickness	approximate thickness of the groundwater body in m.	float(8)	0
GwDepthTo	Depth to groundwater	depth to groundwater from the land surface to the top of the GW-body in m.	float(8)	0
GwBodyArea	Groundwater body area	groundwater body area in km2.	float(8)	0
GwHorizon	Groundwater horizon	groundwater horizon in which the groundwater body is situated: 1 = top horizon etc...	int(4)	0
WaterDataSet	Water data set	RV = river, LK = lake, GW = groundwater, TCM = transitional, coastal or marine water, QA = water quantity.	varchar(3)	0
WaterbaseName	Waterbase name	name of the monitoring station for rivers, lakes, transitional, coastal and marine waters and water quantity, or the name of the groundwater body.	nvarchar(200)	0
AquiferType	Aquifer type	porous media, fractured media, karst.	nvarchar(20)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements.	varchar(2)	0
Country	Country	official short name in English.	nvarchar(100)	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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1
DataSource	Data source	source of data: Eurowaternet, ICES, OSPAR, HELCOM, UNEP/MAP or BSC.	varchar(50)	0

bodies_groundwater_en_v4.csv (text/comma-separated-values)
61.11 KB Download file
bodies_groundwater_en_v4.dbf (dBASE document)
468.03 KB Download file
bodies_groundwater_en_v4.mdb (application/msaccess)
228.00 KB Download file
bodies_groundwater_en_v4.xls (Microsoft Excel spreadsheet)
139.00 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: 730)

LanduseArableLand	Arable land use	arable land use as % of the upstream catchment area of the river or lake monitoring station, within the area of the groundwater body, in the catchment or drainage basin upstream of the transitional water, or within the River Basin District to which the coastal water has been assigned.	float(8)	0
AnnualPrecipitation	Annual precipitation	long term average annual precipitation over the groundwater body in mm/year.	float(8)	0
CountryCode	Country code	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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1

pressures_groundwater_en_v4.csv (text/comma-separated-values)
17.29 KB Download file
pressures_groundwater_en_v4.dbf (dBASE document)
173.39 KB Download file
pressures_groundwater_en_v4.mdb (application/msaccess)
148.00 KB Download file
pressures_groundwater_en_v4.xls (Microsoft Excel spreadsheet)
65.50 KB Download file

Waterbase-Groundwater: QualityWater

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

[+] Show table definition (records: 10554)

25Percentile	25th Percentile	25th Percentile concentration during aggregation period.	float(8)	0
Median	Median	median concentration during aggregation period.	float(8)	0
75Percentile	75th percentile	75th Percentile concentration during aggregation period.	float(8)	0
Minimum	Minimum	Minimum concentration during aggregation period.	float(8)	0
Maximum	Maximum	maximum concentration during aggregation period.	float(8)	0
Mean	Mean	average concentration during aggregation period.	float(8)	0
Year	Year	year of aggregation period, or year in which sample taken, in format YYYY.	int(4)	0
NoOfSites	Number of sites	number of sampling sites investigated in aggregation period.	int(4)	0
Unit	Unit	unit of measurement as specified in the metadata section.	nvarchar(30)	0
CountryCode	Country code	ISO 3166-alpha-2 code elements.	nvarchar(2)	0
AggregationPeriod	Aggregation Period	period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months, YYYY-YYYY = aggregated data over a time period.	nvarchar(20)	0
Determinand	Determinand	as defined in the metadata section.	nvarchar(20)	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, and groundwater body, in the format CountryCode_WaterDataSet_NationalStationID (e.g. GB_RV_12345).	varchar(200)	-1

quality_groundwater_en_v4.csv (text/comma-separated-values)
1.13 MB Download file
quality_groundwater_en_v4.dbf (dBASE document)
4.36 MB Download file
quality_groundwater_en_v4.mdb (application/msaccess)
2.91 MB Download file
quality_groundwater_en_v4.xls (Microsoft Excel spreadsheet)
1.79 MB Download file

Additional information

Groundwater: metadata of the Bodies table

bodies_groundwater_en_v4_metadata.csv (text/comma-separated-values)
1.72 KB Download file

Groundwater: metadata of the Pressures table

pressures_groundwater_en_v4_metadata.csv (text/comma-separated-values)
1.17 KB Download file

Groundwater: metadata of the QualityWater table

quality_groundwater_en_v4_metadata.csv (text/comma-separated-values)
1.82 KB Download file

Metadata

Reporting obligations (ROD)

Groundwater quality (EWN-3)

Temporal coverage:: 1960-2002
Last upload:: 05 Apr 2004
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).
Units:: DO (Dissolved Oxygen), Ammonium, Nitrite, Nitrate: mg/l Simazine, Lindane, Atrazine: µg/l
Data sources: The European Topic Centre on Water. Version 3, date of delivery (date sent to the Data Service): 31/03/2004
Owners:: European Environment Agency (EEA)
Processors:: European Topic Centre on Inland, Coastal and Marine waters (ICM)

Permalink to this version: FF4C156D-5BE0-4E25-89A6-00973F0D9997
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 Eurowaternet (EWN) process. EWN 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 EWN 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.