Water preprocessor: Difference between revisions
No edit summary |
No edit summary |
||
Line 274: | Line 274: | ||
Initialize produced wastewater (WastewaterProduced) using '''SeriesWastewaterProduced''' | Initialize produced wastewater (WastewaterProduced) using '''SeriesWastewaterProduced''' | ||
Initialize treated wastewater (WastewaterTreated) using '''SeriesWasterwaterTreated''' | |||
Initialize treated and reused wastewater (WastewaterTreatedReused) using '''SeriesWastewaterTreatedReused''' | Initialize treated and reused wastewater (WastewaterTreatedReused) using '''SeriesWastewaterTreatedReused''' | ||
Line 283: | Line 283: | ||
<math>WastewaterTreated_c=0.95*WastewaterProduced_c</math> | <math>WastewaterTreated_c=0.95*WastewaterProduced_c</math> | ||
The same logic that applies to the relationship between treated wastewater and produced wastewater applies to the relationship between treated wastewater and treated-and-reused wastewater i.e. if we have data for both and treated and reused exceeds treated then we know there is a problem with the data and assume that the country reused 95% of treated wastewater. | |||
If WastewaterTreatedReused > WastewaterTreated then | |||
<math>WastewaterTreatedReused_c=0.95*WastewaterTreated_c</math> | |||
If we do not have data for wastewater produced then we estimate using municipal water demand. | |||
<math>WastewaterProduced_c=x*WatWithDMun_c+b</math> | |||
If treated wastewater is still greater than produced wastewater then that means that there was data for treated wastewater but not produced wastewater and that the equation we used to estimate produced wastewater (using Mun demand) was an underestimation. We correct for this by assuming these countries treat 80% of their produced wastewater. | |||
If WastewaterTreated > WastewaterProduced then | |||
<math>WastewaterProduced_c=WastewaterTreated_c*1.2</math> | |||
If WastewaterTreated is still 0 then use GDP per capita (2011) to estimate the portion of produced wastewater that's treated. | |||
<math>TreatedPortionProduced_c=x*GDPPCP_c+b</math> | |||
== == | == == |
Revision as of 23:08, 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.
[make sure this is OK, feel like we're missing the third piece in this branch of the logic]
Wastewater
Initialize produced wastewater (WastewaterProduced) using SeriesWastewaterProduced
Initialize treated wastewater (WastewaterTreated) using SeriesWasterwaterTreated
Initialize treated and reused wastewater (WastewaterTreatedReused) using SeriesWastewaterTreatedReused
If we have data for both wastewater produced and wastewater treated and the data says that treated > produced we change volume treated to a portion of produced. This is because a country cannot treat more wastewater than is produced and is probably from a problem in taking the most recent data i.e. we are taking different years for treated v. produced.
If WastewaterTreated > WasteWaterProduced then
The same logic that applies to the relationship between treated wastewater and produced wastewater applies to the relationship between treated wastewater and treated-and-reused wastewater i.e. if we have data for both and treated and reused exceeds treated then we know there is a problem with the data and assume that the country reused 95% of treated wastewater.
If WastewaterTreatedReused > WastewaterTreated then
If we do not have data for wastewater produced then we estimate using municipal water demand.
If treated wastewater is still greater than produced wastewater then that means that there was data for treated wastewater but not produced wastewater and that the equation we used to estimate produced wastewater (using Mun demand) was an underestimation. We correct for this by assuming these countries treat 80% of their produced wastewater.
If WastewaterTreated > WastewaterProduced then
If WastewaterTreated is still 0 then use GDP per capita (2011) to estimate the portion of produced wastewater that's treated.