====== Surface water for drinking with minor or no treatments - Flow ======

==== General description: ====

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.

==== Input Data ====

  * Water use by supply category, by sector and by industrial activities in million m³ per year
  * National Census data
  * Occupancy rates of tourist accommodation

==== Calculation processes: ====

<font 14px/inherit;;inherit;;inherit>**(1) Extract relevant data**</font>

<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;;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>**(2) Disaggregate data 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 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:20181701drinking_water_flow_new.jpg?nolink&466x500}}

{{:en:test_legens.jpg?nolink&500x297}}