Personal tools

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!
This content has been archived on 16 Jun 2014, reason: Other (Access to earlier versions of Waterbase-Groundwater data files have been restricted to authorised users only.)
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 (5 tables)

Dataset contains data selected from reporting of member and collaborating countries on chemical quality of groundwater, characteristics of groundwater bodies and sampling sites. Reported data have been assessed and processed by the ETC-Water and the EEA. Disaggregated records were annually aggregated and statistic value calculated. Results of quality assessment have been incorporated into the individual data tables.

[+] Show table definition

Groundwater Body Characteristics and Pressures (groundwater_v10_bodies, 6421 records)

Detailed information on the physical characteristics and proxy pressures relating to groundwater bodies.

Field name Field Definition Note Data type Primary key
CountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
GWB_Code International code of gw body (not regarding whether the gw body was delineated for the use wihin EIONET or according to the WFD Art.5) text(50) yes
Waterbase_GWB_Code Modified international code of gw body [CountryCode] + "_GW_" + [GWB_Code] text(50) yes
WFDbody_confirmed by_country Information, whether gw body was confirmed by country as WFD Art.5 gw. body Yes/No text(3)
LastDelivery Last year, when the gw body was reported (starting from the year 2008) integer
GW_body_name Name of the groundwater body. text(255)
Reference_year Last year of revision of update of characteristics. integer
No_of_Horizon Vertical position of a groundwater horizon in which a groundwater body is situated. integer
National_GWB_Code Nationally assigned identifier of groundwater body. text(50)
RBDcode River Basin District Code, as defined in the codelist. text(50)
RBDname Name of the River Basin District. text(255)
Area Area of the groundwater body in km2. double
Depth_to_GW_Min Minimum depth from the surface to the top of the groundwater body in m. double
Depth_to_GW_Mean Mean depth from the surface to the top of the groundwater body in m. double
Depth_to_GW_Max Maximum depth from the surface to the top of the groundwater body in m. double
Thickness_Min Minimum thickness of the groundwater body in m. double
Thickness_Mean Mean thickness of the groundwater body in m. double
Thickness_Max Maximum thickness of the groundwater body in m. double
Max_Width Maximum width of the groundwater body perpendicular to groundwater flow direction in km. double
Max_Length Maximum length of flow path within the groundwater body in km. double
Petrographic_Description Short petrographic description of the dominant components of the stratigraphy of the groundwater body. text(255)
Stratigraphy Description of the stratigraphy (geological period) of the groundwater body, as defined in the codelist. text(255)
Main_Aquifer_Type Predominant aquifer type, as defined in codelist. text(255)
Overlying_Strata Description of the groundwater body's overlying strata. text(255)
Confined A confined aquifer is a aquifer that is confined or overlain by a layer that does not transmit water in any appreciable amount or that is impermeable. An unconfined aquifer is a aquifer with water table open to the atmosphere through permeable overlying material. text(3)
Associated_Aquatic_Ecosystems Aquatic ecosystems associated with the groundwater body, as defined in the codelist. text(3)
Associated_Aquatic_Ecosystems_Purpose Description of the aquatic ecosystems associated with the groundwater body. text(255)
Main_Infrastructures Main infrastructures affecting the dynamics of the groundwater body, as defined in the codelist. text(255)
Main_Infrastructures_Purpose Description of the main infrastructures affecting the dynamics of the groundwater body. text(255)
Hydraulic_Conductivity_Min Minimum hydraulic conductivity of the groundwater as a kf-value. double
Hydraulic_Conductivity_Mean Mean hydraulic conductivity of the groundwater as a kf-value. double
Hydraulic_Conductivity_Max Maximum hydraulic conductivity of the groundwater as a kf-value. double
Annual_GW_Level_Amplitude_Min Minimum of the range between the lowest and highest groundwater level within a year in m. double
Annual_GW_Level_Amplitude_Mean Mean of the range between the lowest and highest groundwater level within a year in m. double
Annual_GW_Level_Amplitude_Max Maximum of the range between the lowest and highest groundwater level within a year in m. double
Annual_Precipitation_Min Minimum long term annual precipitation over the groundwater body area in mm. double
Annual_Precipitation_Mean Mean long term annual precipitation over the groundwater body area in mm. double
Annual_Precipitation_Max Maximum long term annual precipitation over the groundwater body area in mm. double
Water_Abstractions Water abstracted from the groundwater body, as defined in the codelist. text(255)
Water_Abstractions_Purpose Purpose for which water is abstracted from the groundwater body. text(255)
Artificial_Recharge Artifical recharge of the groundwater body, as defined in the codelist. text(3)
Artificial_Recharge_Purpose Purpose for the artificial recharge of the groundwater body. text(255)
Main_Recharge_Source Main source recharging the groundwater body, as defined in the codelist. text(255)
QA_datatype_error Quality assurance field - data type and data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation text(255)

Groundwater Body mapping (groundwater_v10_bodies_mapping, 748 records)

List of gw bodies with identical spatial delineation for the use within the EIONET and according to the WFD Art.5.

Field name Field Definition Note Data type Primary key
CountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
Waterbase_GWB_Code_EIONET Modified GWEWN-Code - internally produced, unique identifier of the groundwater body which was delineated for the use within the EIONET. [CountryCode] + "_GW_" + [GWEWN-Code] text(50) yes
Waterbase_GWB_Code_WFD Modified GWB-Code-WFD - internally produced, unique identifier of the groundwater body, which was delineated according to the Water Framework Directive, Article 5 and under which it was reported to the European Commission. [CountryCode] + "_GW_" + [GWB-Code-WFD] text(50) yes

Chemical quality of Groundwater - aggregated data (groundwater_v10_quality, 80275 records)

Annualy aggregated data on selected chemical substances in groundwater bodies, including information on the number and type of sampling sites, the monitoring frequency, the number of sampling sites for each range of concentration values and statistics.

Field name Field Definition Note Data type Primary key
CountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
Waterbase_GWB_Code_EIONET Modified GWEWN-Code - internally produced, unique identifier of the groundwater body which was delineated for the use within the EIONET. [CountryCode] + "_GW_" + [GWEWN-Code] text(50) yes
Waterbase_GWB_Code_WFD Modified GWB-Code-WFD - internally produced, unique identifier of the groundwater body, which was delineated according to the Water Framework Directive, Article 5 and under which it was reported to the European Commission. [CountryCode] + "_GW_" + [GWB-Code-WFD] text(50) yes
Determinand_code Identification number of the determinand monitored, as defined in the codelist. long yes
Determinand Name of the determinand text(50)
Year Year of aggregation period. long yes
Unit Unit of measurement text(10)
AggregationPeriod Period of aggregation annual text(10)
NoOfSites Total number of sampling sites within aggregation period. long
DrinkingWaterSites Number of sampling sites used for drinking water purposes. long
IndustrialSites Number of sampling sites used for industrial purposes. long
SurveillanceSites Number of sampling sites used for surveillance purposes. long
OtherSites Number of sampling sites used for other purposes. long
SamplingFrequency Average frequency that the sampling sites were monitored during the aggregation period. decimal
NoOfSamples Number of samples included in aggregated data. long
LimitOfDetection Concentration for which there is a desirably small probability (around 5%) that the determinand will not be detected i.e. there is a 95% probability that the determinand will be detected. decimal
LimitOfQuantification The smallest concentration that can be distinguished from the analytical blank at a chosen level of statistical confidence (usually 95%). decimal
Minimum Minimum concentration of aggregated data. decimal
Mean Mean concentration of aggregated data. decimal
Maximum Maximum concentration of aggregated data. decimal
Median Median concentration value of aggregated data. decimal
Class_1 The number of sampling sites with average concentration of disaggregated values of: Ammonium <= 0.1 mg/l, Dissolved Oxygen <= 2 mg/l, Nitrate <= 10 mg/l, Nitrite <= 0.01 mg/l, Pesticides <= 0.1 μg/l and at least one sample above  LOD or LOQ within the aggregation period. long
Class_2 The number of sampling sites with average concentration of disaggregated values of: Ammonium between > 0.1 and <= 0.3 mg/l, Dissolved Oxygen between > 2 and <= 5 mg/l, Nitrate between > 10 and <= 25 mg/l, Nitrite between > 0.01 and <= 0.03 mg/l, Pesticides > 0.1 μg/l within the aggregation period. long
Class_3 The number of sampling sites with average concentration of disaggregated values of: Ammonium between > 0.3 and <= 0.5 mg/l, Dissolved Oxygen > 5 mg/l, Nitrate between > 25 and <= 50 mg/l, Nitrite between > 0.03 and <= 0.06 mg/l, Pesticides <= LOD or LOQ within the aggregation period. long
Class_4 The number of sampling sites with average concentration of disaggregated values of: Ammonium > 0.5 mg/l, Nitrate > 50 mg/l, Nitrite between > 0.06 and <= 0.1 mg/l within the aggregation period. long
Class_5 The number of sampling sites with average concentration of disaggregated values of: Nitrite > 0.1 mg/l within the aggregation period. long
AggregatedBy Specification, by whom the data were aggregated [country / ETC Water] text(10)
QA_LRviolations Quality assurance field - list of logical rules violations List of codes of logical rules violated by record. Details are explained in the QA documentation. text(10)
QA_outlier Quality assurance field - outlier flag List of codes of outlier rules violated by record. Details are explained in the QA documentation. text(20)
QA_error_status Quality assurance field - record violating rules can be confirmed by country / judged by expert as correct [blank / country / expert] text(10)
Remarks Additional information text(255)

Groundwater sampling sites and their characteristics (groundwater_v10_stations, 16441 records)

Detailed information on the physical characteristics of the sampling sites of the groundwater bodies.

Field name Field Definition Note Data type Primary key
CountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
WISE-SoE_station_ID Internally produced, unique identifier of the groundwater monitoring station. Based on ISO 3166-alpha-2 country code elements, concatenated with the nationally assigned unique identifier of the groundwater monitoring station (e.g. AT10000123). text(50) yes
Waterbase_GWB_Code_EIONET Modified GWEWN-Code - internally produced, unique identifier of the groundwater body which was delineated for the use within the EIONET. [CountryCode] + "_GW_" + [GWEWN-Code] text(50) yes
Waterbase_GWB_Code_WFD Modified GWB-Code-WFD - internally produced, unique identifier of the groundwater body, which was delineated according to the Water Framework Directive, Article 5 and under which it was reported to the European Commission. [CountryCode] + "_GW_" + [GWB-Code-WFD] text(50) yes
National_Station_Code Nationally assigned, unique identifier of the groundwater monitoring station. text(50)
Name National name of the monitoring station. text(255)
Longitude (X) International geographical co-ordinates in decimal degrees format. double
Latitude (Y) International geographical co-ordinates in decimal degrees format. double
WFD_EU_CD Internally produced, unique international identifier of the monitoring station under which the station was reported as WFD Art.8 monitoring station. text(50)
WFD_MS_CD National WFD Art.8 station code text(50)
WFD_station_confirmed_by_country Information [yes/no], whether the monitoring station was reported to European Commission as Water Framework Directive, Article 8 monitoring station. text(3)
WFD_station_mapped_by_ETC/W Information, whether the station was mapped by ETC Water as WFD Art.8 station [yes / no] text(3)
Well_or_Spring Sampling site is a Well or Spring, as defined in codelist. text(1)
Type_of_Use Type of use of groundwater, as defined in codelist. text(3)
LastDelivery Last year, when the monitoring station was reported (starting from the year 2008) integer
FirstUsage Date, when the "oldest" disaggregated data record stored in the working database was sampled date/time
LastUsage Date, when the "youngest" disaggregated data record stored in the working database was sampled date/time
QA_station_problem Quality assurance field - stations data quality issues flag List of codes of rules violated by record. Details are explained in the QA documentation text(255)
QA_datatype_error Quality assurance field - data type and data definition errors List of field names and their values where values that do not follow the official specifications. Details are explained in the QA documentation text(255)

Saltwater Intrusion (groundwater_v10_saltwater_intrusions, 13 records)

Data on occurrences of saltwater intrusion caused by groundwater over-exploitation.

Field name Field Definition Note Data type Primary key
CountryCode Abbreviation of EEA Member or Collaborating Country ISO3166 two digit code text(2) yes
SALT_Code Internally produced, unique identifier of the area indicating the occurrence of saltwater intrusion. Based on ISO-3166-alpha-2 country code elements, concatenated with 'SW' for Saltwater, and an identification number or alphanumeric code (e.g. ITSW123). text(50) yes
Waterbase_GWB_Code_EIONET Modified GWEWN-Code - internally produced, unique identifier of the groundwater body which was delineated for the use within the EIONET. [CountryCode] + "_GW_" + [GWEWN-Code] text(50) yes
Waterbase_GWB_Code_WFD Modified GWB-Code-WFD - internally produced, unique identifier of the groundwater body, which was delineated according to the Water Framework Directive, Article 5 and under which it was reported to the European Commission. [CountryCode] + "_GW_" + [GWB-Code-WFD] text(50) yes
Reference_year Last year of revision of update of characteristics. integer
Longitude (X) International geographical co-ordinates in decimal degrees format. double
Latitude (Y) International geographical co-ordinates in decimal degrees format. double
Name Name of the area, spot or groundwater body which indicates the occurence of saltwater intrusion. text(255)
Area Area affected by saltwater intrusion in km2. double
Cause The primary reason for the saltwater intrusion in the groundwater body. text(255)
Since Year when saltwater intrusion started. integer
LastDelivery Last year, when the monitoring station was reported (starting from the year 2007) integer
Remarks Additional information text(255)

Additional information

Country codes and abbreviations (37 records)

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

QA documentation

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

Tables metadata

Definition and field description of all data tables.

Metadata

Additional information

Waterbase contains timely, reliable and policy-relevant data collected from EEA member countries through the WISE-SoE data collection (formerly known as Eionet-Water and Eurowaternet) process. WISE-SoE data collection 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 WISE-SoE data collection 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.

 

Comments

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