next
previous
items

Data

Reference Waterbase - Groundwater

Data
Prod-ID: DAT-11-en
Created 01 Jan 2002 Published 01 Jan 2002 Last modified 15 Dec 2022
6 min read
This page was archived on 16 Jun 2014 with reason: Other (Access to earlier versions of Waterbase-Groundwater data files have been restricted to authorised users only.)
Reference Waterbase is the EEA's database on the status and quality of Europe's rivers, lakes and groundwater bodies

European data

Reference WATERBASE - Groundwater: bodies characteristic data

The Bodies table contains data on the EUROWATERNET groundwater bodies physical characteristics. Each body has been assigned a unique WATERBASE identifier (WaterbaseID) which can be used to link the groundwater bodies with their respective Quality and Pressure data.

[+] Show table definition (records:   760)

GwBodyThickness The approx. thickness of the groundwater body in m float(8) 0
GwDepthTo Depth to groundwater is the distance from the land surface to the top of the GW-body in m float(8) 0
GwBodyArea Groundwater body area in km2 float(8) 0
GwHorizon Groundwater horizon in which the groundwater body is situated. 1 = top horizon etc. int(2) 0
WaterbaseName Name of the groundwater body nvarchar(200) 0
AquiferType Aquifer type porous media, fractured media, karstic media nvarchar(20) 0
CountryCode Country code ISO 3166-alpha-2 code elements nvarchar(2) 0
Country Country name (ISO 3166-1) Official short name in English nvarchar(100) 0
WaterbaseID Unique Waterbase Identifier internally produced, unique identifier used to represent the EWN groundwater body code nvarchar(20) -1
Reference WATERBASE - Groundwater: chemical quality data

The Quality table contains data on chemicals, nutrients and organic matter measured at the EUROWATERNET groundwater bodies. Each body has been assigned a unique WATERBASE identifier (WaterbaseID) which can be used to link the Quality data with their respective Bodies and Pressure data.

[+] Show table definition (records:   12683)

25Percentile 25Percentile 25th Percentile concentration during aggregation period float(8) 0
Median Median Median concentration during aggregation period float(8) 0
75Percentile 75Percentile 75th Percentile concentration during aggregation period float(8) 0
Minimum Minimum concentration over 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 of measurements range of years available: 1960 - 2001 int(4) 0
NoOfSites Number of sampling sites investigated in the aggregation period int(4) 0
Unit Unit of measurement As defined in meta data section "Unit" nvarchar(8) 0
WaterbaseID Unique Waterbase Identifier Internally produced, unique identifier used to represent the EWN groundwater body code nvarchar(20) -1
AggregationPeriod AggregationPeriod Period of aggregation: Annual = aggregated over whole year, Summer = aggregated over summer months, Winter = aggregated over winter months nvarchar(10) 0
Determinand Determinand Determinand name as defined in meta data section "Unit" nvarchar(60) 0
Reference WATERBASE - Groundwater: bodies' pressures characteristic data

The Pressure table contains proxy pressure data within the area of the EUROWATERNET groundwater bodies. Each 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:   760)

LanduseArableLand Arable land use as % within the area of the GW body float(8) 0
AnnualPrecipitation Long term average annual precipitation over the GW body in mm/year float(8) 0
WaterbaseID Waterbase ID Internally produced, unique identifier used to represent the monitoring stations for rivers or lakes or the groundwater bodies nvarchar(20) 0

Metadata

Additional information

The data contained in this database can be accessed through a series of web pages which form part of the EEA Data Service's public web site. Pre-defined applications have been designed to assist the user to extract and analyse the data in a format that is both helpful and meaningful. Reference Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the Eurowaternet (EWN) process. EWN selects validated, mostly aggregated, 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. Although many countries make their highly aggregated data available over the Internet, the level and form of aggregation often varies from country to country making detailed quantitative comparisons difficult. The added value of Reference Waterbase is that data collected through the EWN process are from statistically stratified monitoring stations and groundwater bodies and are comparable at European level. These data are primarily used in the production of the EEA's indicator-based factsheets. Data disclaimer: The data in Reference 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.