Differences

This shows you the differences between two versions of the page.

--- wiki:water_abstraction [2018/07/11 11:15] – created sebastian
+++ wiki:water_abstraction [2018/07/16 15:46] (current) – sebastian
@@ Line 1: / Line 1: @@
-==== Surface water for drinking with minor or no treatments - Flow ====
+====== Surface water for drinking with minor or no treatments - Demand ======
-====    General description:   ====
+==== General description ====
-<font 14px/inherit;;inherit;;inherit>The drinking water flow is visualizing the water used at a tap connected to the public water supply system. Water use is understood as water utilization at the point of delivery. The Alpine wide map is based on water statistics from Eurostat, the statistical office of the European Union. These datasets are collected by National Statistical Institutes, then validated and merged by Eurostat. They come on a regional scale and are further downscaled by us to municipality level based on touristic and demographic data.</font>
+The drinking water demand is displaying the abstractions from water resources for the public water supply. Water abstraction is understood as water removed from its source. We use collected data from Eurostat at regional scale, which is disaggregated to municipality level to map the drinking water demand.
-====      Input Data     ====
+==== Input Data ====
-  * <font 14px/inherit;;inherit;;inherit>Water use by supply category, by sector and by industrial activities in million m³ per year</font>  * <font 14px/inherit;;inherit;;inherit>National Census data</font>  * <font 14px/inherit;;inherit;;inherit>Occupancy rates of tourist accommodation</font>
+  * <font 14px/inherit;;inherit;;inherit>Annual fresh water abstraction by source and by sector in million m³ per year</font>
-====      Calculation processes:     ====
+  * <font 14px/inherit;;inherit;;inherit>National Census data</font>
+  * <font 14px/inherit;;inherit;;inherit>Occupancy rates of tourist accommodation</font>
-  - <font 14px/inherit;;inherit;;inherit>**Extract relevant data**</font>
+==== Calculation processes ====
-<font 14px/inherit;;inherit;;inherit>In a first step, after having downloaded the necessary table on water usage from EUROSTAT homepage, we need to filter the datasets by extracting only the necessary information.</font>
+<font 14px/inherit;;inherit;;inherit>**(1) Extract relevant data**</font>
-<font 14px/inherit;;black;;white>After opening the database “**Water use by NUTS 2 regions</font>**<font inherit/inherit;;black;;white>”, it needs to be filtered for country, water process and classification of economic activities. Here, these are the Alpine Space Countries, public water supply and households.</font>
+<font 14px/inherit;;inherit;;inherit>Similar to the flow indicator, we are here also working with EUROSTAT data which needs to be downloaded from the Homepage (water abstractions). In a next step, the necessary table needs to be filtered as we want to extract only the necessary information.</font>
-  - <font 14px/inherit;;inherit;;inherit>**Disaggregate data to municipality level**</font>
+<font 14px/inherit;;inherit;;inherit>Thus after opening the table “**Water abstractions by NUT 2 regions**”, it needs to be filtered for the country, the source and the water process. Here: Alpine Space Countries, fresh surface water and total gross abstraction.</font>
-<font 14px/inherit;;inherit;;inherit>As the smallest scale here is the NUTS-2 level, we need to disaggregate the datasets to municipal level. This is done by allocating the water abstraction according to the overnight stays in hotels and population data at municipal level.</font>
+<font 14px/inherit;;inherit;;inherit>**(2) Disaggregation to municipality level**</font>
+<font 14px/inherit;;inherit;;inherit>As the smallest scale here is the NUTS-2 level, we need to disaggregate the datasets again to municipal level. This is done by allocating the water abstraction according to the overnight stays in hotels and population data at municipal level.</font>
+{{:en:drinking_water_demand_new.jpg?nolink&500x585}}
+{{:en:test_legens.jpg?nolink&500x297}}