Water preprocessor

Series pulled into water preprocessor

Table	Definition	Source	Notes	Last IFs Update
SeriesWaterFossilWithdrawal	Water withdrawal from fossil water aquifers	UNESCO Non-Renewable Groundwater Report 2006	SGH	2014/08/29
SeriesWaterResFossil	Water withdrawal from fossil water aquifers	UNESCO Non-Renewable Groundwater Report 2006; Aquastat country profiles	SGH	2014/08/29
SeriesWaterResGroundAfrica	Water withdrawal from fossil water aquifers for African countries	Quantitative maps of groundwater resources in Africa	SGH	2014/08/29
SeriesWasterwaterTreated	Wastewater: treated volume (10^9 m3/yr)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWastewaterProduced	Wastewater: produced volume (10^9 m3/yr)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWastewaterTreatedReused	Treated wastewater reused (10^9 m3/yr)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterDesalinated	Desalinated Water Produced	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterGroundWithD	Ground Water Withdrawal	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResExploitGround	Exploitable: regular renewable groundwater (10^9 m3/yr)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResExploitSurface	Exploitable: total renewable surface water (10^9 m3/yr)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResOverlap	Overlap between surface and groundwater	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResTotalExploit	Water resources: total exploitable	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResTotalRenew	Water resources: total renewable (actual)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResTotalRenewGround	Total renewable groundwater (actual) (10^9 m3/yr)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterResTotalRenewSurface	Total renewable suface water (actual)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterSurfaceWithD	Surface Water Withdrawal	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterTotalWithdSources	Total water withdrawal (summed by sources)	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterWithdAgriculture	Agricultural water withdrawal	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterWithdIndustrial	Industrial water withdrawal	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesWaterWithdMunicipal	Municipal water withdrawal	AQU  BATCH PULL	KK,JM	2016/05/21
SeriesLandIrActual%Equip	Area equipped for irrigation: actually irrigated, %	AQU  BATCH PULL	KK;JM	2016/06/06

Initializations 

Municipal water demand

Use SeriesWaterWithdMunicipal to initialize municipal water demand (WatWithdMun).

If null, then calculate urban population:

$UrbanPercent=POPURBAN_{r}/POP_{r}$

Then estimate municipal water demand using the equation: "MunDemandPC (Linear) versus GDP2011PCPPP(MOSTRECENT) (Log) AND Connections" which is in AnalFunc.

$Prediction=(x_{1}*ln(GDPPCP_{r}))+(x_{2}*ln(UrbanPercent))+(x_{3}*ln(WATSAFE_{r,3}))$

Multiply municipal water demand per capita by the size of the urban population.

$WatWithdMun_{r}=Prediction*POPURBAN_{r}$