Skip to content. Skip to navigation
Information in your language:
European Topic Centres:

EEA

Home Data and maps Datasets Waterbase - Groundwater

Waterbase - Groundwater

Document Actions

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

This is the latest version published. See previous versions
Themes
Water Water

Additional information

Tables metadata

File contains metadata definitions of all data tables.

Country codes and abbreviations (37 records)

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

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.

European data set

Waterbase-Groundwater: Microsoft Access database (2 tables)

Database contains all data tables. Detailed table definitions are displayed in the section with individual tables.

Waterbase-Groundwater: Bodies

The Bodies table contains physical characteristics and proxy pressure data of the WISE-SoE 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 data. Each record has a quality assurance field. Its meaning is explained in the QA documentation which can be found in the "Additional information" section.

[-] Show table definition (records:   5920)

Reference_Year Reference year Last year of revision of update of characteristics. int(4) 0
No_of_Horizon Number of Horizon Vertical position of a groundwater horizon in which a groundwater body is situated. int(4) 0
Area Surface area of the lake in square kilometers float(8) 0
Depth_to_GW_Min Minimum Depth to Groundwater Body Minimum depth from the surface to the top of the groundwater body in m. float(8) 0
Depth_to_GW_Mean Mean Depth to Groundwater Body Mean depth from the surface to the top of the groundwater body in m. float(8) 0
Depth_to_GW_Max Maximum Depth to Groundwater Body Maximum depth from the surface to the top of the groundwater body in m. float(8) 0
Thickness_Min Minimum Thickness Minimum thickness of the groundwater body in m. float(8) 0
Thickness_Mean Mean Thickness Mean thickness of the groundwater body in m. float(8) 0
Urban_Areas Urban Areas Urban land use as a percentage of the groundwater body area. float(8) 0
Forest_and_Woodland Forest and Woodland Forest and woodland land use as a percentage of the groundwater body area. float(8) 0
Permanent_Pasture Permanent Pasture Permanent pastoral land use as a percentage of the groundwater body area. float(8) 0
Arable_Land Arable land Arable land use as a percentage of the groundwater body area. float(8) 0
Permanent_Crops Permanent Crops Permanent crops land use as a percentage of the groundwater body area. float(8) 0
Other Other Land Use Other land use as a percentage of the groundwater body area. float(8) 0
Annual_GW_Level_Amplitude_Min Minimum Annual Groundwater Level Amplitude Minimum of the range between the lowest and highest groundwater level within a year in m. float(8) 0
Annual_GW_Level_Amplitude_Mean Mean Annual Groundwater Level Amplitude Mean of the range between the lowest and highest groundwater level within a year in m. float(8) 0
Annual_GW_Level_Amplitude_Max Maximum Annual Groundwater Level Amplitude Maximum of the range between the lowest and highest groundwater level within a year in m. float(8) 0
Annual_Precipitation_Min Minimum Annual Precipitation Minimum long term annual precipitation over the groundwater body area in mm. float(8) 0
Annual_Precipitation_Mean Mean Annual Precipitation Mean long term annual precipitation over the groundwater body area in mm. float(8) 0
Annual_Precipitation_Max Maximum Annual Precipitation Maximum long term annual precipitation over the groundwater body area in mm. float(8) 0
Thickness_Max Maximum Thickness Maximum thickness of the groundwater body in m. float(8) 0
Max_Width Maximum Width Maximum width of the groundwater body in km. float(8) 0
Max_Length Maximum Length Maximum length of the groundwater body in km. float(8) 0
Hydraulic_Conductivity_Min Minimum Hydraulic Conductivity Minimum hydraulic conductivity of the groundwater as a kf-value. float(8) 0
Hydraulic_Conductivity_Mean Mean Hydraulic Conductivity Mean hydraulic conductivity of the groundwater as a kf-value. float(8) 0
Hydraulic_Conductivity_Max Maximum Hydraulic Conductivity Maximum hydraulic conductivity of the groundwater as a kf-value. float(8) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) -1
WaterbaseID Waterbase ID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(60) -1
GW_Body_Code Internally produced, unique identifier of the groundwater body which was delineated for the use within the EIONET. nvarchar(50) 0
WFD_GW_Body_Code Groundwater Body 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. nvarchar(20) 0
WFD_GW_Body_Confirmed WFD groundwater body code confirmed by country nvarchar(3) 0
GW_Body_Name Name of the groundwater body nvarchar(255) 0
Artificial_Recharge Artificial Recharge nvarchar(3) 0
Artificial_Recharge_Purpose Purpose for Artificial Recharge nvarchar(255) 0
Main_Recharge_Source Main source recharging the groundwater body nvarchar(30) 0
QA_datatype_errors Quality assurance field - data type and data definition errors list of field names and their values where values do not follow official specifications. Details are explained in the QA documentation nvarchar(255) 0
Associated_Aquatic_Ecosystems Associated Aquatic Ecosystems nvarchar(3) 0
Associated_Aquatic_Ecosystems_Purpose Description of the Associated Aquatic Ecosystems nvarchar(255) 0
Main_Infrastructures Main infrastructures affecting the dynamics of the groundwater body nvarchar(3) 0
Main_Infrastructures_Purpose Description of the Main Infrastructures nvarchar(255) 0
Water_Abstractions Water Abstractions nvarchar(3) 0
Water_Abstractions_Purpose Purpose for the Water Abstractions nvarchar(255) 0
National_Code National Code Nationally assigned identifier of groundwater body. nvarchar(50) 0
Location Location Location of the lake monitoring site (e.g. main outlet of lake, centre of lake, etc.) nvarchar(50) 0
Petrographic_Description Petrographic Description Short petrographic description of the dominant components of the stratigraphy of the groundwater body. nvarchar(100) 0
Stratigraphy Stratigraphy Description of the stratigraphy (geological period) of the groundwater body, as defined in the codelist. nvarchar(50) 0
Main_Aquifer_Type Main Aquifer Type nvarchar(60) 0
Overlying_Strata Overlying Strata Description of the groundwater body's overlying strata. nvarchar(100) 0
Waterbase-Groundwater: Quality

The Quality 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. Each record has three special quality assurance fields. They are explained in QA documentation which can be found in "Additional information" section.

[-] Show table definition (records:   66550)

Year Year year of aggregation period (aggregated data sets), or year in which sample taken (disaggregated data sets), in format YYYY. Year should be no later than that requested in the last Eionet-Water data request. int(4) 0
Determinant_code Determinand code Identification number of the determinand monitored, as defined in the codelist. int(4) 0
NoOfSites Number of sites number of sampling sites investigated in aggregation period. int(4) 0
DrinkingWaterSites Drinking water sites Number of sampling sites used for drinking water purposes. int(4) 0
IndustrialSites Industrial sites Number of sampling sites used for industrial purposes. int(4) 0
Surveillancesites Surveillance sites Number of sampling sites used for surveillance purposes. int(4) 0
Pesticides_Class_le_01 Pesticides class < 0.1 µg/l the number of sampling sites with at least one value above LOQ and bellow the concentration of 0.1 µg/l, within the aggregation period int(4) 0
Pesticides_Class_gt_01 Pesticides class > 0.1 µg/l the number of sampling sites with at least one value exceeding concentration of 0.1 µg/l, within the aggregation period int(4) 0
Pesticides_Class_lt_(LOD) Pesticides class bellow LOQ the number of sampling sites with all individual values below the limit of quantification (LOQ), within the aggregation period. int(4) 0
QA_Outlier Quality assurance field - outlier flag mean value is an outlier for current station and determinand time series: 1=yes, 0=no. int(4) 0
Nitrates_Class_50 Nitrate class > 50 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate &amp;gt; 50 mg/l, within the aggregation period. int(4) 0
Nitrites_Class_001 Nitrite class <= 0.01 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite &amp;lt;= 0.01 mg/l, within the aggregation period. int(4) 0
Nitrites_Class_001_003 Nitrite class > 0.01 to <= 0.03 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite between &amp;gt; 0.01 and &amp;lt;= 0.03 mg/l, within the aggregation period. int(4) 0
Nitrites_Class_003_006 Nitrite class > 0.03 to <= 0.06 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite between &amp;gt; 0.03 and &amp;lt;= 0.06 mg/l, within the aggregation period. int(4) 0
Nitrites_Class_006_01 Nitrite class > 0.06 to <= 0.1 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite between &amp;gt; 0.06 and &amp;lt;= 0.1 mg/l, within the aggregation period. int(4) 0
Nitrites_Class_01 Nitrite class > 0.1 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrite &amp;gt; 0.1 mg/l, within the aggregation period. int(4) 0
DissolvedOxygen_Class_2 Dissolved Oxygen class <= 2 mg/l The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen &amp;lt;= 2 mg/l, within the aggregation period. int(4) 0
DissolvedOxygen_Class_2_5 Dissolved Oxygen class > 2 to <= 5 mg/l The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen between &amp;gt; 2 and &amp;lt;= 5 mg/l, within the aggregation period. int(4) 0
DissolvedOxygen_Class_5 Dissolved Oxygen class > 5 mg/l The number of sampling sites with average concentration of disaggregated values of Dissolved Oxygen &amp;gt; 5 mg/l, within the aggregation period. int(4) 0
Nitrates_Class_10 Nitrate class <= 10 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate &amp;lt;= 10 mg/l, within the aggregation period. int(4) 0
Nitrates_Class_10_25 Nitrate class > 10 to <= 25 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate between &amp;gt; 10 and &amp;lt;= 25 mg/l, within the aggregation period. int(4) 0
Nitrates_Class_25_50 Nitrate class > 25 to <= 50 mg/l The number of sampling sites with average concentration of disaggregated values of Nitrate between &amp;gt; 25 and &amp;lt;= 50 mg/l, within the aggregation period. int(4) 0
OtherSites Other sites Number of sampling sites used for other purposes. int(4) 0
NoOfSamples Number of samples Number of samples included in aggregated data. int(4) 0
Ammonium_Class_01 Ammonium class <=0.1 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium &amp;lt;= 0.1 mg/l, within the aggregation period. int(4) 0
Ammonium_Class_01_03 Ammonium class > 0.1 to <= 0.3 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium between &amp;gt; 0.1 and &amp;lt;= 0.3 mg/l, within the aggregation period. int(4) 0
Ammonium_Class_03_05 Ammonium class > 0.3 to <= 0.5 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium between &amp;gt; 0.3 and &amp;lt;= 0.5 mg/l, within the aggregation period. int(4) 0
Ammonium_Class_05 Ammonium class > 0.5 mg/l The number of sampling sites with average concentration of disaggregated values of Ammonium &amp;gt; 0.5 mg/l, within the aggregation period. int(4) 0
Samplingfrequency Average sampling frequency Average frequency that the sampling sites were monitored during the aggregation period. numeric(5) 0
Minimum Minimum minimum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Mean Mean mean concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Maximum Maximum maximum concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
Median Median median concentration value of aggregated data. On aggregation, sample concentration values recorded as below the limit of detection or determination have been replaced with a value equivalent to half the limit of detection or determination. numeric(9) 0
CountryCode Country code abbreviation of EEA Member or Collaborating country. ISO 3166-alpha-2 code elements. nvarchar(2) -1
WaterbaseID Waterbase ID internally produced, unique identifier used to represent the monitoring station for rivers, lakes, transitional, coastal and marine waters, and water quantity, in the format CountryCode_WaterDataSet_NationalStationID (e.g. AT_RV_001), or the groundwater body, in the format CountryCode_WaterDataSet_EWN-Code (e.g. AT_GW_AT001). nvarchar(60) -1
Determinand Determinand determinand name. nvarchar(20) 0
Unit Unit unit of measurement. nvarchar(5) 0
AggregationPeriod Period of aggregation period of aggregation: Annual=aggregated over whole year, Summer=aggregated over summer months, Winter=aggregated over winter months, MMYYYY-MMYYYY or YYYY-YYYY=aggregated between two periods (TCM only). nvarchar(10) 0
AggregatedBy Data aggregated by provides the information, whether the data were reported by country as aggregated (AggregatedBy = country) or as disaggregated (AggregatedBy = ETC/W) nvarchar(10) 0
Remarks Remarks remarks, comments or explanatory notes. nvarchar(255) 0
QA_LRviolations Quality assurance field - numerical list of logical rules violated in record tested logical rules are explanained in QA documentation. nvarchar(20) 0
QA_GWbody_problems Quality assurance field - groundwater body data quality issues flag the highlighted GWbody data quality issues are explained in the QA documentation nvarchar(20) 0

Reporting obligations (ROD)

Metadata

Permalink:
421FD224-22A4-48BD-A50C-0D02B21D2ABA
Link to latest version:
5E846079-4FF3-49B4-95F7-6E010F83D9B2
Geographical coverage:

EFTA4, EU15, EU25, EU27, Albania, Bosnia and Herzegovina, Macedonia, the former Yugoslavian Republic of, Montenegro, Serbia, Serbia and Montenegro, Turkey

 
Publish date:
2009/05/06 09:35:40.217 GMT+0
Tags:
determinand, EEA owned data sets, eionet-water, ETC/WTR, Eurowaternet, geospatial data, groundwater, point data, waterbase, WISE
Last upload:
2009/04/29
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.

Disclaimer:
Data in 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.
Source:

The European Topic Centre on Water. Version 9, date of delivery (date sent to the Data Service): 24/04/2009.

Methodology:
Used tools: Microsoft SQL Server 2005, Microsoft Access, Microsoft Excel Applied procedures: QA checks have been performed on original delivery. Results have been stored in special QA fields. Some erroneous values have been cleaned. Detail are described in QA documentation. MDB database was created by export from SQL Server. Text fields were cleared of trailing spaces. Simple relation structure was added. Whole database was compacted. XLS, CSV files was created from MDB database tables. special features: CSV files - text qualifier is ' &quot; ' character, field separator is ',' character, line breaks were changed to &lt;br /&gt; string.
Units:

Simazine, Lindane, Atrazine: µg/l
Dissolved Oxygen, Ammonium, Nitrite, Nitrate: mg/l

Temporal coverage:
1960-2006
Owners:
European Environment Agency
Processors:
The European Topic Centre on Water
 

European Environment Agency, Kongens Nytorv 6, DK - 1050 Copenhagen K, Denmark - Phone: +45 3336 7100
EU flagThe European Environment Agency (EEA) is an agency of the European Union.
Comments to EEA Web Team.

Legal notice, Disclaimer, Privacy policy

 

This site conforms to the following standards:

CMS login