Import/Catalogue/Harare Water Wells
The project will import community water points or wells in Harare, Zimbabwe. Médecins Sans Frontières (MSF) have been monitoring and maintaining water points in Harare in response to cholera and typhoid outbreaks in recent years. They have collected data on the locations, infrastructure and operational arrangements for 458 water points in Harare.
The goal of this project is to: Import all 458 water points and conflate them with the existing water points in Harare. Update all water points on a regular basis in future.
- 4 February 2019 - Explicit permission obtained from MSF
- 5 April 2019 - Import plan submitted for review on the Import list
- 5 May 2019 - Planned start of import
Water point locations and attributes have been collected by MSF in their water and sanitation activities in Harare. The data is curated by MSF which they use for mapping and modeling. The database was made available for importing into OSM in March 2019.
- Data source: Médecins Sans Frontières (MSF)
- OSM attribution (if required): Contributors#MSF
- Data License: Public Domain. Explicit permission granted by email - link
Data was shared a comma separated values (csv) file with latitude, longitude and other attributes which can be opened in JOSM using the Open Data plugin. The data is available here.
The MSF dataset is the most up-to-date data available for water points in Harare. It is also likely to be the most accurate as it is actively used for water and sanitation activities by MSF and other organizations. Therefore, it is proposed to let the coordinates of the MSF dataset override the coordinates in OSM for conflation during the initial import.
The initial import and conflation is a one-time import.
Data reduction and simplification
The MSF data contains a lot more information than needed for OSM import.
Each water point will be tagged as man_made=water_well.
|MSF data attribute
|Unique reference number/ID for each water point
|Infrastructure in place
|E.g. hand pump or electrical/submersible pump
|Working status of borehole
|If the pump is working or not working
|Type of water usage
|If drinking water is available from a well
The changesets will be uploaded using the account XXX and will be tagged with:
- description=Water Point/Well import
- source= Médecins Sans Frontières (MSF)
Data merge workflow
The import will be done by one person using the JOSM Conflation plugin.
- Download OSM data for Harare in JOSM using the Overpass API with a query that includes man_made=water_well and amenity=drinking_water in Harare in the wizard.
- Open the csv file containing water point/well data from MSF
- Configure the conflation plugin to generate matches:
- The existing wells/OSM layer is the Subject
- The new well data is the Reference
- The distance is set to 50 meters
- Select matching wells and check them manually before conflation
- Conflate all other wells
Water point data will be maintained and updated with the help of the OSM community in Zimbabwe and the MSF team.