Water preprocessor: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 261: Line 261:


<math>WatWithDGround_c=WatWithDTotalSources_c-WatWithDSurface_c</math>
<math>WatWithDGround_c=WatWithDTotalSources_c-WatWithDSurface_c</math>
If we have total water withdrawal, but not for surface and ground then we estimate using global averages:
<math>WatWithDSurface_c=0.67*WatWithDTotalSources_c</math>
<math>WatWithDGround_c=0.33*WatWithDTotalSources_c</math>
If we do not have data for total withdrawals, or surface, or ground, then estimate total using demand and then global averages for surface and ground.
<math>WatWithDSurface_c=0.67*TotalDemand_c</math>
<math>WatWithDGround_c=0.33*TotalDemand_c</math>


==  ==
==  ==

Revision as of 22:42, 11 January 2017

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:

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

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

Industrial water demand

Use SeriesWaterWithdIndustrial to initialize industrial water demand (WatWithdInd).

If null, then estimate using manufacturing value added. The equation is, "WaterWithdIndustrial(MOSTRECENT minus elec) (Linear) versus Man (Linear)" and is in TablFunc.

Agricultural water demand

Initialize agriculture water demand using SeriesWatWithdAg.

If null, then set to 0.

Land irrigated

Initialize land irrigated (LANDIRAREAACTUAL) using SeriesLandIrActual%Equip.

If null, set to 90 (percent).

Multiply by land equipped for irrigation:

If LANDIRAREAACTUAL is still null, then set to 0.001.

Water withdrawal growth rates

Initialize water withdrawal growth rates (WaterWithdrawalSurfaceGR, WaterWithdrawalGroundGR, WaterWithdrawalFossilGroundGR) using the "getAnnualGrowthRate" function and the tables: SeriesWatWithdSurface, SeriesWatWithDGround, and SeriesWatWithDFossilGround.

Total and exploitable renewable resources

Initialize total renewable surface water resources (WatResTotalRenewSurface) using SeriesWaterResTotalRenewSurface. 

If null, set to 0.

Initialize total renewable groundwater resources (WatResTotalRenewGround) using SeriesWaterResTotalRenewGround.

If null, set to 0.

Initialize total renewable water resources (WatResTotalRenew) using SeriesWaterResTotalRenew.

If null set to 0.

Fill holes

If WatResTotalRenewGround is 0 but WatResTotalRenewSurface and WaterResTotalRenew do not equal 0, then:

If WatResTotalRenewSurface is 0, but WatResTotalRenewGround and WaterResTotalRenew do not equal 0, then:

If WaterResTotalRenew is 0, but WatResTotalRenewGround and WatResTotalRenewSurface do not equal 0, then:

If we still do not have any value for WaterResTotalRenew, then estimate using land area:

Subtract overlap between surface and groundwater out. Initialize overlap with SeriesWaterResOverlap.

If we have data for total renewable water resources (TRWR) but not TRWR surface and ground then we estimate based on the total using global averages. If we do not have data for exploitable surface and ground water resources we estimate using TRWR surface and ground resources.

If WatResTotalRenewGround is still 0 then:

If WatResTotalRenewSurface is still 0 then:

If WatResExploitRenewGround is 0 then:

If WatResExploitRenewSurface is 0 then:

WatResExploitRenewSurface was initialized using SeriesWaterResExploitSurface and WatResExploitRenewGround was initialized using SeriesWaterResExploitGround.

If total exploitable is 0 then use sum of surface and ground:

If total renewable is still 0 then use sum of surface and ground:

Withdrawals (by source)

AQUASTAT includes fossil water withdrawals in their groundwater withdrawal data so we must subtract it out.

The fossil water reserve data we have (WaterResGroundAfrica) also includes both renewable and fossil, so we must subtract out renewable.

If we do not have fossil water data resources (WATERRESFOSSIL) but we do have fossil water withdrawals (WatWithDFossilGround) then we estimate that withdrawals are 10 percent of reserves.

If we have no data for either fossil water reserves or withdrawals, then assume they are 0.

If we have data for both total renewable withdrawals and groundwater withdrawals, we estimate surface water withdrawals:

[check this]

If we have data for both total renewable withdrawals and surface water withdrawals, we estimate groundwater withdrawals:

If we have total water withdrawal, but not for surface and ground then we estimate using global averages:

If we do not have data for total withdrawals, or surface, or ground, then estimate total using demand and then global averages for surface and ground.

sss

sdsd


sdsd