The University of Southampton
University of Southampton Institutional Repository

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
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
1438-4639
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
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), 888-899. (doi:10.1016/j.ijheh.2017.04.006).

Record type: Article

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
Download (2MB)
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
ORCID for James Wright: ORCID iD orcid.org/0000-0002-8842-2181

Catalogue record

Date deposited: 09 Jun 2017 09:16
Last modified: 16 Mar 2024 05:19

Export record

Altmetrics

Contributors

Author: Weiyu Yu
Author: Nicola Wardrop
Author: Robert Bain
Author: James Wright ORCID iD

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

Atom RSS 1.0 RSS 2.0

Contact ePrints Soton: eprints@soton.ac.uk

ePrints Soton supports OAI 2.0 with a base URL of http://eprints.soton.ac.uk/cgi/oai2

This repository has been built using EPrints software, developed at the University of Southampton, but available to everyone to use.

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×