Freshwater Abstraction and hydropower (2 tables, 10 queries)

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.

Population data (population, 216 records)

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

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)