Water preprocessor - Revision history

Wikiadmin at 00:14, 19 January 2017

2017-01-19T00:14:00Z

Wikiadmin at 00:12, 19 January 2017

2017-01-19T00:12:08Z

← Older revision		Revision as of 00:12, 19 January 2017
Line 227:		Line 227:

	<math>WaterResTotalRenew_c=WatResTotalRenewGround_c+WatResTotalRenewSurface_c</math>		<math>WaterResTotalRenew_c=WatResTotalRenewGround_c+WatResTotalRenewSurface_c</math>


	If we do not have data for any of them, estimate total using land area:		If we do not have data for any of them, estimate total using land area:
Line 234:		Line 235:
	and then assume surface water is 71 percent of total and ground water is 29 percent.		and then assume surface water is 71 percent of total and ground water is 29 percent.

	<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>

	<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>

	If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent. If we only have surface then assume surface is 71 percent of total: <math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>
			If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent.


			If we only have surface then assume surface is 71 percent of total:

			<math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>

	and that groundwater is 29 percent of total.		and that groundwater is 29 percent of total.

	If we only have data for groundwater then assume groundwater is 29 percent of total: <math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math> and that surface is 71 percent of total.
			If we only have data for groundwater then assume groundwater is 29 percent of total:

			<math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>

			and that surface is 71 percent of total.

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

Wikiadmin at 00:10, 19 January 2017

2017-01-19T00:10:39Z

← Older revision		Revision as of 00:10, 19 January 2017
Line 234:		Line 234:
	and then assume surface water is 71 percent of total and ground water is 29 percent.		and then assume surface water is 71 percent of total and ground water is 29 percent.

	<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>

	<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>

	If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent. If we only have surface then assume surface is 71 percent of total: <math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math> and that groundwater is 29 percent of total.		If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent. If we only have surface then assume surface is 71 percent of total: <math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>

			and that groundwater is 29 percent of total.

	If we only have data for groundwater then assume groundwater is 29 percent of total: <math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>		If we only have data for groundwater then assume groundwater is 29 percent of total: <math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math> and that surface is 71 percent of total.
	and that surface is 71 percent of total.

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

Wikiadmin at 00:10, 19 January 2017

2017-01-19T00:10:13Z

← Older revision		Revision as of 00:10, 19 January 2017
Line 234:		Line 234:
	and then assume surface water is 71 percent of total and ground water is 29 percent.		and then assume surface water is 71 percent of total and ground water is 29 percent.

	<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math> <math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>
			<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>

	If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent. If we only have surface then assume surface is 71 percent of total: <math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math> and that groundwater is 29 percent of total.		If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent. If we only have surface then assume surface is 71 percent of total: <math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math> and that groundwater is 29 percent of total.

	If we only have data for groundwater then assume groundwater is 29 percent of total: <math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math> and that surface is 71 percent of total.		If we only have data for groundwater then assume groundwater is 29 percent of total: <math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>
			and that surface is 71 percent of total.

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

Wikiadmin at 00:06, 19 January 2017

2017-01-19T00:06:52Z

← Older revision		Revision as of 00:06, 19 January 2017
Line 220:		Line 220:
	<math>WatResTotalRenewGround_c=WaterResTotalRenew_c-WatResTotalRenewSurface_c</math>		<math>WatResTotalRenewGround_c=WaterResTotalRenew_c-WatResTotalRenewSurface_c</math>

	If WatResTotalRenewSurface is ~~nuss~~, but WatResTotalRenewGround and WaterResTotalRenew are not null, then:		If WatResTotalRenewSurface is null, but WatResTotalRenewGround and WaterResTotalRenew are not null, then:

	<math>WatResTotalRenewSurface_c=WaterResTotalRenew_c-WatResTotalRenewGround_c</math>		<math>WatResTotalRenewSurface_c=WaterResTotalRenew_c-WatResTotalRenewGround_c</math>
Line 234:		Line 234:
	and then assume surface water is 71 percent of total and ground water is 29 percent.		and then assume surface water is 71 percent of total and ground water is 29 percent.

	<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math> <math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>
	<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>

	If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent.		If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent. If we only have surface then assume surface is 71 percent of total: <math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math> and that groundwater is 29 percent of total.
	If we only have surface then assume surface is 71 percent of total:
	<math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>
	and that groundwater is 29 percent of total.

	If we only have data for groundwater then assume groundwater is 29 percent of total:		If we only have data for groundwater then assume groundwater is 29 percent of total: <math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math> and that surface is 71 percent of total.
	<math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>
	and that surface is 71 percent of total.

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

Wikiadmin at 00:06, 19 January 2017

2017-01-19T00:06:32Z

← Older revision		Revision as of 00:06, 19 January 2017
Line 209:		Line 209:

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

	~~If null, set to 0.~~

	Initialize total renewable groundwater resources (WatResTotalRenewGround) using SeriesWaterResTotalRenewGround.		Initialize total renewable groundwater resources (WatResTotalRenewGround) using SeriesWaterResTotalRenewGround.

	~~If null, set to 0.~~

	Initialize total renewable water resources (WatResTotalRenew) using SeriesWaterResTotalRenew.		Initialize total renewable water resources (WatResTotalRenew) using SeriesWaterResTotalRenew.

	~~If null set to 0.~~

	=== Fill holes ===		=== Fill holes ===

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

	<math>WatResTotalRenewGround_c=WaterResTotalRenew_c-WatResTotalRenewSurface_c</math>		<math>WatResTotalRenewGround_c=WaterResTotalRenew_c-WatResTotalRenewSurface_c</math>

	If WatResTotalRenewSurface is 0, but WatResTotalRenewGround and WaterResTotalRenew do not ~~equal 0~~, then:		If WatResTotalRenewSurface is nuss, but WatResTotalRenewGround and WaterResTotalRenew are not null, then:

	<math>WatResTotalRenewSurface_c=WaterResTotalRenew_c-WatResTotalRenewGround_c</math>		<math>WatResTotalRenewSurface_c=WaterResTotalRenew_c-WatResTotalRenewGround_c</math>

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

	<math>WaterResTotalRenew_c=WatResTotalRenewGround_c+WatResTotalRenewSurface_c</math>		<math>WaterResTotalRenew_c=WatResTotalRenewGround_c+WatResTotalRenewSurface_c</math>

	If we ~~still~~ do not have any ~~value for WaterResTotalRenew~~, ~~then~~ estimate using land area:		If we do not have data for any of them, estimate total using land area:

	<math>WaterResTotalRenew_c=x*LANDAREA_c</math>		<math>WaterResTotalRenew_c=x*LANDAREA_c</math>

			and then assume surface water is 71 percent of total and ground water is 29 percent.

			<math>WatResTotalRenewGround_c = 0.29 * WaterResTotalRenew_c</math>
			<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>

			If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent.
			If we only have surface then assume surface is 71 percent of total:
			<math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>
			and that groundwater is 29 percent of total.

			If we only have data for groundwater then assume groundwater is 29 percent of total:
			<math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>
			and that surface is 71 percent of total.

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

Wikiadmin at 23:35, 18 January 2017

2017-01-18T23:35:45Z

← Older revision		Revision as of 23:35, 18 January 2017
Line 206:		Line 206:
	Initialize water withdrawal growth rates (WaterWithdrawalSurfaceGR, WaterWithdrawalGroundGR, WaterWithdrawalFossilGroundGR) using the "getAnnualGrowthRate" function and the tables: SeriesWatWithdSurface, SeriesWatWithDGround, and SeriesWatWithDFossilGround.		Initialize water withdrawal growth rates (WaterWithdrawalSurfaceGR, WaterWithdrawalGroundGR, WaterWithdrawalFossilGroundGR) using the "getAnnualGrowthRate" function and the tables: SeriesWatWithdSurface, SeriesWatWithDGround, and SeriesWatWithDFossilGround.

	== Total and exploitable renewable resources ==		= Total and exploitable renewable resources =

	Initialize total renewable surface water resources (WatResTotalRenewSurface) using SeriesWaterResTotalRenewSurface.		Initialize total renewable surface water resources (WatResTotalRenewSurface) using SeriesWaterResTotalRenewSurface.
Line 260:		Line 260:
	If total renewable is still 0 then use sum of surface and ground: <math>WaterResTotalRenew_c=WatResTotalRenewSurface_c+WatResTotalRenewGround_c</math>		If total renewable is still 0 then use sum of surface and ground: <math>WaterResTotalRenew_c=WatResTotalRenewSurface_c+WatResTotalRenewGround_c</math>

	== Withdrawals (by source) ==		= Withdrawals (by source) =

	AQUASTAT includes fossil water withdrawals in their groundwater withdrawal data so we must subtract it out.		AQUASTAT includes fossil water withdrawals in their groundwater withdrawal data so we must subtract it out.
Line 292:		Line 292:
	<math>WatWithDSurface_c=0.67TotalDemand_c</math> <math>WatWithDGround_c=0.33TotalDemand_c</math> [make sure this is OK, feel like we're missing the third piece in this branch of the logic]		<math>WatWithDSurface_c=0.67TotalDemand_c</math> <math>WatWithDGround_c=0.33TotalDemand_c</math> [make sure this is OK, feel like we're missing the third piece in this branch of the logic]

	== Wastewater ==		= Wastewater =

	Initialize produced wastewater (WastewaterProduced) using '''SeriesWastewaterProduced'''		Initialize produced wastewater (WastewaterProduced) using '''SeriesWastewaterProduced'''

Wikiadmin at 23:28, 18 January 2017

2017-01-18T23:28:15Z

← Older revision		Revision as of 23:28, 18 January 2017
Line 136:		Line 136:
	\|}		\|}

	= ~~Initializations ~~ =		= Water demand =

	Start with demand. Read in water demand data by sector (municipal, industrial, agriculture, and total) and fill holes if we have 3 of those 4. Then fill holes for each sector using the same equations we would use to forecast those variables. Then normalize with total water demand (by sector) if there are data.		Start with demand. Read in water demand data by sector (municipal, industrial, agriculture, and total) and fill holes if we have 3 of those 4. Then fill holes for each sector using the same equations we would use to forecast those variables. Then normalize with total water demand (by sector) if there are data.
Line 194:		Line 194:
	== Normalize with total demand ==		== Normalize with total demand ==

	If we have data for total water demand (WatWithdTotalSector) but it does not match with the sum of our sectors, we normalize the sectors to match the total data. For example,		If we have data for total water demand (WatWithdTotalSector) but it does not match with the sum of our sectors, we normalize the sectors to match the total data. For example,

	<math>WatWithdMun_c=(WatWithdMun_c/WatTotalDemand)*WatWithdTotalSector_c</math>		<math>WatWithdMun_c=(WatWithdMun_c/WatTotalDemand)*WatWithdTotalSector_c</math>

	where		where

	<math>WatTotalDemand = \sum_{sector}^3 WaterDemand_{c,sector}</math>		<math>WatTotalDemand = \sum_{sector}^3 WaterDemand_{c,sector}</math>

Wikiadmin at 19:40, 16 January 2017

2017-01-16T19:40:21Z

← Older revision		Revision as of 19:40, 16 January 2017
Line 192:		Line 192:
	<math>WatWithdAg_c=x*LANDIRAREAACTUAL_c+b</math>		<math>WatWithdAg_c=x*LANDIRAREAACTUAL_c+b</math>

	Normalize with total demand		== Normalize with total demand ==

	If we have data for total water demand (WatWithdTotalSector) but it does not match with the sum of our sectors, we normalize the sectors to match the total data.		If we have data for total water demand (WatWithdTotalSector) but it does not match with the sum of our sectors, we normalize the sectors to match the total data. For example,
	For example,
	<math>WatWithdMun_c=(WatWithdMun_c/WatTotalDemand)*WatWithdTotalSector_c</math>		<math>WatWithdMun_c=(WatWithdMun_c/WatTotalDemand)*WatWithdTotalSector_c</math>
	where
	<math>WatTotalDemand = \sum_{sector}^~~3WaterDemand_~~{c,sector}</math>		where

			<math>WatTotalDemand = \sum_{sector}^3 WaterDemand_{c,sector}</math>

	== Water withdrawal growth rates ==		== Water withdrawal growth rates ==

Wikiadmin at 19:37, 16 January 2017

2017-01-16T19:37:35Z

← Older revision		Revision as of 19:37, 16 January 2017
Line 176:		Line 176:
	== Agricultural water demand ==		== Agricultural water demand ==

	Initialize agriculture water demand using SeriesWatWithdAg.		Initialize agriculture water demand using SeriesWatWithdAg. If null, estimate using land irrigated.
	If null, estimate using land irrigated.

	Initialize land irrigated (LANDIRAREAACTUAL) using SeriesLandIrActual%Equip.		Initialize land irrigated (LANDIRAREAACTUAL) using SeriesLandIrActual%Equip.
Line 192:		Line 191:

	<math>WatWithdAg_c=x*LANDIRAREAACTUAL_c+b</math>		<math>WatWithdAg_c=x*LANDIRAREAACTUAL_c+b</math>

			Normalize with total demand

			If we have data for total water demand (WatWithdTotalSector) but it does not match with the sum of our sectors, we normalize the sectors to match the total data.
			For example,
			<math>WatWithdMun_c=(WatWithdMun_c/WatTotalDemand)*WatWithdTotalSector_c</math>
			where
			<math>WatTotalDemand = \sum_{sector}^3WaterDemand_{c,sector}</math>

	== Water withdrawal growth rates ==		== Water withdrawal growth rates ==

← Older revision		Revision as of 00:14, 19 January 2017
Line 227:		Line 227:

	<math>WaterResTotalRenew_c=WatResTotalRenewGround_c+WatResTotalRenewSurface_c</math>		<math>WaterResTotalRenew_c=WatResTotalRenewGround_c+WatResTotalRenewSurface_c</math>


	If we do not have data for any of them, estimate total using land area:		If we do not have data for any of them, estimate total using land area:
Line 239:		Line 238:
	<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>		<math>WatResTotalRenewSurface_c = 0.71 * WaterResTotalRenew_c</math>

			If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent.

	~~If we only have data for total, then assume surface is 71 percent and groundwater is 29 percent.~~		If we only have surface then assume surface is 71 percent of total:


	If we only have surface then assume surface is 71 percent of total:

	<math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>		<math>WaterResTotalRenew_c = WatResTotalRenewSurface_c / 0.71</math>

	and that groundwater is 29 percent of total.		and that groundwater is 29 percent of total.


	If we only have data for groundwater then assume groundwater is 29 percent of total:		If we only have data for groundwater then assume groundwater is 29 percent of total:

	<math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>		<math>WaterResTotalRenew_c=WatResTotalRenewGround_c / 0.29</math>

	and that surface is 71 percent of total.		and that surface is 71 percent of total.


	Subtract overlap between surface and groundwater out. Initialize overlap with SeriesWaterResOverlap.		Subtract overlap between surface and groundwater out. Initialize overlap with SeriesWaterResOverlap.
Line 261:		Line 258:

	<math>WatResTotalRenewGround_c=\dfrac{WatResTotalRenewGround_c}{WaterResTotalSurfaceGround_c}*(WaterResTotalSurfaceGround_c-Overlap_c)</math>		<math>WatResTotalRenewGround_c=\dfrac{WatResTotalRenewGround_c}{WaterResTotalSurfaceGround_c}*(WaterResTotalSurfaceGround_c-Overlap_c)</math>


	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 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.