Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data
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) |
Table contains list of ISO 3166 alpha 2 code elements used in Waterbase-Groundwater version 10
Country codes and abbreviations (37 records)
(text/comma-separated-values)
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.
QA documentation
(PDF document)
Definition and field description of all data tables.
Tables metadata (XLS file)
(Microsoft Excel spreadsheet)
Tables metadata (CSV files)
(ZIP archive)
Reporting obligations (ROD)
Rights:
Disclaimer:
Units:
Simazine, Lindane, Atrazine: µg/l
Dissolved Oxygen, Ammonium, Nitrite, Nitrate: mg/l
Data sources
The European Topic Centre on Water. Version 10, date of delivery (date sent to the Data Service): 12/04/2010.
Owners:
Processors:
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.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/waterbase-groundwater-6 or scan the QR code.
PDF generated on 27 Mar 2023, 11:26 PM
Engineered by: EEA Web Team
Software updated on 12 March 2023 21:56 from version 23.1.28
Software version: EEA Plone KGS 23.3.11
Document Actions
Share with others