Integration of population census and water point mapping data–A case study of Cambodia, Liberia and Tanzania
Integration of population census and water point mapping data–A case study of Cambodia, Liberia and Tanzania
Sustainable Development Goal (SDG) 6 has expanded the Millennium Development Goals’ focus from improved drinking-water to safely managed water services. This expanded focus to include issues such as water quality requires richer monitoring data and potentially integration of datasets from different sources. Relevant data sets include water point mapping (WPM), the survey of boreholes, wells and other water points, census and household survey data. This study examined inconsistencies between population census and WPM datasets for Cambodia, Liberia and Tanzania, and identified potential barriers to integrating the two datasets to meet monitoring needs. Literatures on numbers of people served per water point were used to convert WPM data to population served by water source type per area and compared with census reports. For Cambodia and Tanzania, discrepancies with census data suggested incomplete WPM coverage. In Liberia, where the data sets were consistent, WPM-derived data on functionality, quantity and quality of drinking water were further combined with census area statistics to generate an enhanced drinking-water access measure for protected wells and springs. The process revealed barriers to integrating census and WPM data, including exclusion of water points not used for drinking by households, matching of census and WPM source types; temporal mismatches between data sources; data quality issues such as missing or implausible data values, and underlying assumptions about population served by different water point technologies. However, integration of these two data sets could be used to identify and rectify gaps in WPM coverage. If WPM databases become more complete and the above barriers are addressed, it could also be used to develop more realistic measures of household drinking-water access for monitoring.
Data Integration, Water Point Mapping, Census, WASH
888-899
Yu, Weiyu
4cca6f0a-badb-4f1c-8b38-da29ba0b9e09
Wardrop, Nicola
8f3a8171-0727-4375-bc68-10e7d616e176
Bain, Robert
88a0ae39-a83b-4cf4-b5a9-cf23be3688ce
Wright, James
94990ecf-f8dd-4649-84f2-b28bf272e464
July 2017
Yu, Weiyu
4cca6f0a-badb-4f1c-8b38-da29ba0b9e09
Wardrop, Nicola
8f3a8171-0727-4375-bc68-10e7d616e176
Bain, Robert
88a0ae39-a83b-4cf4-b5a9-cf23be3688ce
Wright, James
94990ecf-f8dd-4649-84f2-b28bf272e464
Yu, Weiyu, Wardrop, Nicola, Bain, Robert and Wright, James
(2017)
Integration of population census and water point mapping data–A case study of Cambodia, Liberia and Tanzania.
International Journal of Hygiene and Environmental Health, 220 (5), .
(doi:10.1016/j.ijheh.2017.04.006).
Abstract
Sustainable Development Goal (SDG) 6 has expanded the Millennium Development Goals’ focus from improved drinking-water to safely managed water services. This expanded focus to include issues such as water quality requires richer monitoring data and potentially integration of datasets from different sources. Relevant data sets include water point mapping (WPM), the survey of boreholes, wells and other water points, census and household survey data. This study examined inconsistencies between population census and WPM datasets for Cambodia, Liberia and Tanzania, and identified potential barriers to integrating the two datasets to meet monitoring needs. Literatures on numbers of people served per water point were used to convert WPM data to population served by water source type per area and compared with census reports. For Cambodia and Tanzania, discrepancies with census data suggested incomplete WPM coverage. In Liberia, where the data sets were consistent, WPM-derived data on functionality, quantity and quality of drinking water were further combined with census area statistics to generate an enhanced drinking-water access measure for protected wells and springs. The process revealed barriers to integrating census and WPM data, including exclusion of water points not used for drinking by households, matching of census and WPM source types; temporal mismatches between data sources; data quality issues such as missing or implausible data values, and underlying assumptions about population served by different water point technologies. However, integration of these two data sets could be used to identify and rectify gaps in WPM coverage. If WPM databases become more complete and the above barriers are addressed, it could also be used to develop more realistic measures of household drinking-water access for monitoring.
Text
Accepted Manuscript
- Accepted Manuscript
Text
Supplementary Information A
Restricted to Repository staff only
Request a copy
Text
Supplementary Information B
Restricted to Repository staff only
Request a copy
Text
Supplementary Information C
Restricted to Repository staff only
Request a copy
More information
Submitted date: 21 November 2016
Accepted/In Press date: 14 April 2017
e-pub ahead of print date: 4 May 2017
Published date: July 2017
Additional Information:
Embargo period: 12 months (4 May 2017 - 4 May 2018)
Keywords:
Data Integration, Water Point Mapping, Census, WASH
Organisations:
Geography & Environment, Population, Health & Wellbeing (PHeW)
Identifiers
Local EPrints ID: 410631
URI: http://eprints.soton.ac.uk/id/eprint/410631
ISSN: 1438-4639
PURE UUID: 12b4bf6c-8588-4679-a8de-bbba821126cb
Catalogue record
Date deposited: 09 Jun 2017 09:16
Last modified: 16 Mar 2024 05:19
Export record
Altmetrics
Contributors
Author:
Robert Bain
Download statistics
Downloads from ePrints over the past year. Other digital versions may also be available to download e.g. from the publisher's website.
View more statistics
