Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Waterbase - Groundwater

Waterbase - Groundwater

Note: new version is available!
Topics: ,
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

European data

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

Additional information

Groundwater: metadata of the Bodies table
Groundwater: metadata of the QualityWater table
Groundwater: metadata of the Pressures table

Metadata

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.

 

Related content

Document Actions

Comments

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100