Data

Freshwater Abstraction and hydropower – Dataset for WISE Map Layer

Data

Prod-ID: DAT-121-en

Created 17 Jul 2012 Published 19 Jul 2012 Last modified 20 Mar 2023

7 min read

Topics: Water and marine environment

This page was archived on 20 Mar 2023 with reason: Content is outdated

This dataset includes the data used for production of WISE map layers for annual freshwater abstraction, use for hydropower and cooling water as well as data on population per country or river basin district (RBD) used for the normalisation.

Data and maps

Menu

European data

Freshwater Abstraction and hydropower (2 tables, 10 queries)

This database includes the most recent available information regarding the total annual freshwater abstraction (excluding hydropower), abstraction for hydropower generation and cooling water across Europe. The information comes from various sources, such as reports from member states through the WISE-SoE process between 2009 and 2011, the responses from the OECD/ESTAT Joint Questionnaire on Inland Waters from 2001 to 2009 and reports under the WFD for the years 2004 to 2008. Data on the population per country and realistic estimated calculations on the population of the river basin districts (RBD) are included in the database, as well as various queries used to normalize data and filter out important information.

[+] Show table definition

TABLES

Water abstraction and hydropower data (wa_total_abstraction, 109 records)

Table contains most recent available information needed for the calculation of water abstraction, water use for hydropower and cooling water across Europe. The data come from various sources such as reports from member states through the WISE-SoE process between 2009 and 2011, the responses from the OECD/ESTAT Joint Questionnaire on Inland Waters from 2001 to 2009 and reports under the WFD for the years 2004 to 2008.

Field name	Definition
Country	The name of the country
Region_code	The code of the region (Country, RBD or SU code)
Region	The name of the region
Spatial_scale	The spatial scale: “Country”, “RBD” or “SU”
Area	The area in km2 (if known)
Year	The year which the data refer to
DataSource	The source where the data have been reported
Total_abstraction	Total annual freshwater abstraction (in hm3), excluding freshwater abstraction for hydropower generation
Cooling_water	Total annual volume of freshwater abstracted for cooling purposes in electricity production (in hm3). Cooling purposes refer to the use of water for absorption and removal of heat in the generation of electricity in power stations.
Hydropower	Total annual volume of freshwater abstracted for hydropower generation(in hm3)
Abstraction_NoCooling	Total annual freshwater abstraction excluding water abstracted for cooling purposes (in hm3)

Population data (population, 216 records)

Table contains the most recent available information on the population of countries and estimations on the population of RBDs.

Field name	Definition
RegionCode	The code of the region (Country or RBD code)
Population	The number of inhabitants

QUERIES

qry_total_annual_abstraction_per_capita_RBD

This query calculates at the RBD level the total annual abstraction per capita (in m3/cap)

qry_total_annual_abstraction_per_capita_country

This query calculates at the country level the total annual abstraction per capita (in m3/cap)

qry_annual_abstraction_cooling_water_per_capita_RBD

This query calculates at the RBD level the annual abstraction for cooling water per capita (in m3/cap)

qry_annual_abstraction_cooling_water_per_capita_country

This query calculates at the country level the annual abstraction for cooling water per capita (in m3/cap)

qry_annual_abstraction_hydropower_per_capita_RBD

This query calculates at the RBD level the annual abstraction for hydropower per capita (in m3/cap)

qry_annual_abstraction_hydropower_per_capita_country

This query calculates at the country level the annual abstraction for hydropower per capita (in m3/cap)

qry_annual_abstr_cooling_water_per_total_abstr_RBD

This query calculates at the RBD level the annual abstraction for cooling water per total abstraction

qry_annual_abstr_cooling_water_per_total_abstr_country

This query calculates at the country level the annual abstraction for cooling water per total abstraction

qry_total_annual_abstraction_nocooling_per_capita_RBD

This query calculates at the RBD level the total annual abstraction excluding cooling water per capita (in m3/cap)

qry_annual_abstraction_nocooling_per_capita_country

This query calculates at the country level the total annual abstraction excluding cooling water per capita (in m3/cap)

Freshwater Abstraction and hydropower (Microsoft Access database) (application/msaccess)
404.00 KB Download file

Metadata

Rights:

EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).

Disclaimer:

All data displayed in the Water Information System for Europe (WISE) are reported by Member States or other countries reporting to the European Commission (EC) or the European Environment Agency (EEA). The data are reported in the context of the official reporting on the basis of EU legislation, in particular the Water Framework Directive (2000/60/EC), the Urban Waste Water Directive (91/271/EEC) or the Bathing Water Directive (76/160/EEC, 2006/7/EC) or the data are submitted on a voluntary basis in the context of the EIONET agreements of the EEA.

The data are displayed in the way they were reported and only for some of the data, quality control and quality assurance has taken place. In particular for data that were only recently submitted, errors or misrepresentations may occur. It is the intention of the EEA and the cooperating services of the EC to ask the Member State to correct data whenever an error is identified and to update the data accordingly. Furthermore, a systematic and comprehensive quality control and quality assurance is developing process and will be put in place in order to ensure the highest possible quality and accuracy of the data.

Until then, the data are not officially published and are not necessarily authorised by the European Commission or other Commission Services or the European Environment Agency. Official published data and maps related to EU water legislation can be found at the web pages of EC-DG Environment: http://ec.europa.eu/environment/water/index.html.

The data also do not necessarily represent the official position of the Member States concerned. Official data and more information on implementation of water policy can be found at the web pages of the responsible institutions in the Member States. An indicative list of some relevant web pages can be found at: http://ec.europa.eu/atoz_en.htm.

Methodology:

To derive the volume per capita, data on water abstraction are divided by population per country or RBD. The RBD population dataset is not a product of reporting, but estimated calculations based on population density proxies (population data from NUTSIII level have been disaggregated per km² and aggregated back at RBD scale based on the RBD area).

Data sources

The following sources of data on freshwater abstraction have been used:

Data extracted from the Waterbase - Water Quantity collected from the MSs through the WISE-SoE process between 2009 and 2011. The URL to the dataset is: http://www.eea.europa.eu/data-and-maps/data/waterbase-water-quantity-6
Data extracted from the OECD/ESTAT Joint Questionnaire on Inland Waters (most recent year) collected from national statistical agencies through Eurostat. The period that the data was extracted ranges from 2001 to 2009. 2001 data is an exception for Turkey that does not have any later year data availability with the rest of the Eurostat data ranging from 2005 to 2009. Water Abstraction Eurostat data was available at country and RBD level at http://epp.eurostat.ec.europa.eu/portal/page/portal/statistics/search_database
Data extracted from the WISE electronic summary reported under the WFD for the years 2004 to 2008 with the exception of Italy that has not reported the year of the provided water abstraction data.
Data has been retrieved by the MS reply to the DG ENV "Questionnaire on the scope of WSD" distributed for the purposes of the 2007 EU Communication on WSD. This data was only used in the case of Portugal.
Population: RBD level: This information is not a product of reporting, but estimated calculations based on population density proxies (population data from NUTSIII level have been disaggregated per km2 and aggregated back at RBD scale based on the RBD area). Data was extracted from http://appsso.eurostat.ec.europa.eu/nui/show.do?dataset=demo_r_d2jan&lang=en
Population: Country level: This data was taken directly from Eurostat’s website for the latest year available (2011) from http://appsso.eurostat.ec.europa.eu/nui/show.do?dataset=demo_pjan&lang=en
The River Basin District layer was derived from the WFD River Basin Districts f1v4 shapefile (published 1st July 2011).
The Country layer was derived by the CNTR_RG_100K_2004_ETRS_LAEA_Europe_clip_v2” shapefile (published 12/07/2011).

Owners:

European Environment Agency (EEA)

Processors:

European Topic Centre on Inland, Coastal and Marine waters (ETC/ICM)

Permalinks

Permalink to this version: 60066e0e48534a6a869e644c3c28bb50
Permalink to latest version: DAT-121-en

Geographic coverage

Austria Belgium Bosnia and Herzegovina Bulgaria Cyprus Czechia Denmark Estonia Finland France Germany Greece Hungary Iceland Ireland Italy Latvia Lithuania Luxembourg Malta Netherlands North Macedonia Poland Portugal Romania Serbia Slovakia Slovenia Spain Sweden Switzerland Turkey United Kingdom