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.
| 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)
Document Actions
Share with others