Joint Monitoring Programme, WHO/UNICEF - Revision history

Norah.Shamin: /* Data Pulling Instructions: Downloading Data */

2025-08-19T15:41:58Z

Data Pulling Instructions: Downloading Data

← Older revision		Revision as of 15:41, 19 August 2025
Line 775:		Line 775:
	= Data Pulling Instructions: Downloading Data =		= Data Pulling Instructions: Downloading Data =
	# Go to https://washdata.org/data/downloads#WLD		# Go to https://washdata.org/data/downloads#WLD
			## Detailed instructions on how to find the "Household" [[Joint Monitoring Programme\|here]]
	#Click "World file" under "Household" to download all the data.[[File:Imagellsjfewa.png\|none\|thumb\|679x679px]]		#Click "World file" under "Household" to download all the data.[[File:Imagellsjfewa.png\|none\|thumb\|679x679px]]
	#Open the downloaded file. "Enable Editing". Hover the mouse to the tab and right-click. The file will show several options:[[File:ImagefheqFNLIA.png\|none\|thumb]]		#Open the downloaded file. "Enable Editing". Hover the mouse to the tab and right-click. The file will show several options:[[File:ImagefheqFNLIA.png\|none\|thumb]]

Norah.Shamin: /* Data Pulling Instructions: Importing Sanitation Data into IFs */

2025-08-15T17:25:09Z

Data Pulling Instructions: Importing Sanitation Data into IFs

← Older revision		Revision as of 17:25, 15 August 2025
Line 939:		Line 939:
	\|}		\|}
	Hence, the table SeriesWSSJMPSanitationTotal%SafelyManaged from IFsHistSeries is the equivalent to the variable san_sm_t from WSS JMP.		Hence, the table SeriesWSSJMPSanitationTotal%SafelyManaged from IFsHistSeries is the equivalent to the variable san_sm_t from WSS JMP.

			= Data Notes =

Norah.Shamin at 15:12, 7 July 2025

2025-07-07T15:12:49Z

Show changes

Yutang.Xiong: /* Instructions on Importing Sanitation Data into IFs */

2025-03-04T19:46:39Z

Instructions on Importing Sanitation Data into IFs

← Older revision		Revision as of 19:46, 4 March 2025
Line 128:		Line 128:
	\|Basic		\|Basic
	\|basal - sm		\|basal - sm
	\|-
	~~\|san~~
	~~\|'''Improved'''~~
	~~\|basal + lim~~
	\|-		\|-
	\|san		\|san
Line 179:		Line 175:
	\|ns		\|ns
	\|}		\|}
			Hence, the table SeriesWSSJMPSanitationTotal%SafelyManaged from IFsHistSeries is the equivalent to the variable san_sm_t from WSS JMP.

Yutang.Xiong: /* Instructions on Importing Sanitation Data into IFs */

2025-03-04T19:44:14Z

Instructions on Importing Sanitation Data into IFs

← Older revision		Revision as of 19:44, 4 March 2025
Line 64:		Line 64:
	* SMNotContam = imp_qual; used to be quality		* SMNotContam = imp_qual; used to be quality

	You can also observe that unimp + imp + ns = 100%, where imp = basal + lim = pip + imp_npip'''Old system-'''		You can also observe that unimp + imp + ns = 100%, where imp = basal + lim = pip + imp_npip

			'''Old system-'''
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-
Line 143:		Line 145:
	\|unimp		\|unimp
	\|}		\|}
			In which, SafelyManaged is the union of following 3 categories (normally adding three together)

			* SMDisposedInsitu = sdo_sm; Disposed in situ
			* SMEmpTreated = fst_sm; Emptied and treated
			* SMWastewaterTreated = sew_sm; Wastewater treated

			You can also find that imp + unimp + ns = 100, where imp = basal + lim; Additionally, Improved (imp) is the union of following 3 categories (normally adding three together, if all 3 exist)

			* Latrines and other = othimp; used to be lat
			* Septic tanks = sep
			* Sewer connections = sew

	'''Old system-'''		'''Old system-'''
	{\| class="wikitable"		{\| class="wikitable"

Yutang.Xiong: /* Instructions on Importing Sanitation Data into IFs */

2025-03-04T19:40:28Z

Instructions on Importing Sanitation Data into IFs

← Older revision		Revision as of 19:40, 4 March 2025
Line 112:		Line 112:

	IFs include both old and new sanitation systems from WSS JMP. The new system is developed based on the old system, thus, you can find some overlapping variable labels between two systems. Below we listed a mapping between the ladders used in IFs and those being used in WSS JMP.		IFs include both old and new sanitation systems from WSS JMP. The new system is developed based on the old system, thus, you can find some overlapping variable labels between two systems. Below we listed a mapping between the ladders used in IFs and those being used in WSS JMP.

			'''New system-'''
	{\| class="wikitable"		{\| class="wikitable"
	\|TAB		\|TAB
	\|Ladder		\|Ladder in IFs
	\|~~Ladder(Code)~~		\|WSS JMP Variable
	\|-		\|-
	\|san		\|san
Line 140:		Line 142:
	\|OtherUnimproved		\|OtherUnimproved
	\|unimp		\|unimp
			\|}
			'''Old system-'''
			{\| class="wikitable"
			\|TAB
			\|Ladder in IFs
			\|WSS JMP Variable
	\|-		\|-
	\|san		\|san
	\|~~SafelyManaged~~		\|Improved
	\|sm		\|basal
	\|-		\|-
	\|san		\|san
Line 150:		Line 158:
	\|-		\|-
	\|san		\|san
	\|~~SMDisposedInsitu~~		\|OtherUnimproved
	\|~~sdo_sm~~		\|unimp
	\|-		\|-
	\|san		\|san
	\|~~SMEmpTreated~~		\|OpenDefecation
	\|~~fst_sm~~		\|ns
	\|-
	~~\|san~~
	~~\|SMWastewaterTreated~~
	~~\|sew_sm~~
	\|-
	~~\|san~~
	~~\|Unimproved~~
	~~\|100 - '''Improved''' -~~ ns
	\|}		\|}

Yutang.Xiong: /* Instructions on Importing Sanitation Data into IFs */

2025-03-04T19:37:06Z

Instructions on Importing Sanitation Data into IFs

← Older revision		Revision as of 19:37, 4 March 2025
Line 165:		Line 165:
	\|100 - '''Improved''' - ns		\|100 - '''Improved''' - ns
	\|}		\|}
	##

Yutang.Xiong: /* Instructions on Importing Sanitation Data into IFs */

2025-03-04T19:36:50Z

Instructions on Importing Sanitation Data into IFs

@@ Line 110: / Line 110: @@
 '''<u>Ladder and Related code in downloaded data:</u>'''
 {| class="wikitable"
 |TAB
@@ Line 162: / Line 164: @@
 |Unimproved
 |100 - '''Improved''' - ns
-|}- Can be directly found
+|}
 ##

Yutang.Xiong: /* Instructions on Importing Water Data into IFs */

2025-03-04T19:35:40Z

Instructions on Importing Water Data into IFs

← Older revision		Revision as of 19:35, 4 March 2025
Line 99:		Line 99:
	* The rest of data are in percentages		* The rest of data are in percentages

	Thus, under the raw data (the Excel file downloaded following the instruction above), the TAB column in the mapping above represents the name of the spreadsheet, while the other two columns represent the one-to-one mapping between IFs data table name and WSS JMP variable name. For example, table SeriesWSSJMPWaterTotal%SafelyManaged from IFsHistSeries equals to the variable wat_sm_t.		Thus, under the raw data (the Excel file downloaded following the instruction above), the TAB column in the mapping above represents the name of the spreadsheet, while the other two columns represent the one-to-one mapping between IFs data table name and WSS JMP variable name. For example, table SeriesWSSJMPWaterTotal%SafelyManaged from IFsHistSeries equals to the variable wat_sm_t. Same rules apply to the sanitation data introduced below.

	== '''Instructions on Importing Sanitation Data into IFs''' ==		== '''Instructions on Importing Sanitation Data into IFs''' ==

Yutang.Xiong: /* Instructions on Importing Water Data into IFs */

2025-03-04T19:35:09Z

Instructions on Importing Water Data into IFs

← Older revision		Revision as of 19:35, 4 March 2025
Line 64:		Line 64:
	* SMNotContam = imp_qual; used to be quality		* SMNotContam = imp_qual; used to be quality

	You can also observe that unimp + imp + ns = 100%, where imp = basal + lim = pip + imp_npip		You can also observe that unimp + imp + ns = 100%, where imp = basal + lim = pip + imp_npip'''Old system-'''


	'''Old system-'''
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-
Line 90:		Line 87:
	\|ns		\|ns
	\|}		\|}

	~~'''<u>Types of Data</u>: '''The following categories of data need to be imported into IFs:~~

	~~- Can be directly found~~

	* Units is "Percent" - 30 in total

	* Units is "Thousands" - 12 in total
	~~- Need Calculation~~

	* Units is 'Percent" - 9 in total

	*Units is "Thousands" - 6 in total

	<u>'''Notes:'''</u>		<u>'''Notes:'''</u>

	~~# Any Pop series cannot be directly found in the excel. Thus~~, ~~we need~~ to ~~manually calculated.~~		* All indicators use suffices to indicate regional levels, with
	~~# pop_t is total population~~ in ~~thousands.~~		** _t means national indicators (Total%); used to be _n being national
	# prop_u is the percentage of urban population in total population.		** _r means Rural%
	# 100 - prop_u is the percentage of rural population in total population.		** _u means Urban%
	~~# Except pop_t, the~~ rest of data ~~we will use is~~ in ~~"Percent". To do the calculation for "Pop" series, we need to /100 first to convert the percent to decimal.~~		* Prefix pop_ means Population in Thousands
	~~# wat_bas changed to wat_basal.~~		* prop_u is the percentage of urban population in total population.
	~~# wat_sur changed to wat_ns.~~		* 100 - prop_u is the percentage of rural population in total population.
	~~# Calculated Ladders:~~		* The rest of data are in percentages
	~~## Basic = At least basic + Safely managed~~
	~~## Improved = At least basic + Limited = Piped + Non-piped~~
	~~## Unimproved = 100 - Improved - Surface~~


	~~Under~~ the raw data (the Excel file downloaded following the instruction above), the TAB column in the mapping ~~below~~ represents the name of the spreadsheet, while the other two columns represent the one-to-one mapping between IFs data table name and WSS JMP variable name. For example, table ~~SeriesWSSJMPWaterSafelyManagedTotal~~ from IFsHistSeries equals to the ~~wsm~~		Thus, under the raw data (the Excel file downloaded following the instruction above), the TAB column in the mapping above represents the name of the spreadsheet, while the other two columns represent the one-to-one mapping between IFs data table name and WSS JMP variable name. For example, table SeriesWSSJMPWaterTotal%SafelyManaged from IFsHistSeries equals to the variable wat_sm_t.

	== '''Instructions on Importing Sanitation Data into IFs''' ==		== '''Instructions on Importing Sanitation Data into IFs''' ==