Import MALI UNICEF Education

Goals

Add Schools of Mali with metadata.

• 10,156 schools with GPS location.
• Proper metadata (operator, type, academy, cap, latrines, nb of pupils, etc)
• Data is relatively recent (2013)
• Data is almost inexistent in OSM
• We have a group of people ready to enhance it directly in OSM for Bamako area.
• We have a couple NGOs in need for this and willing to contribute to.
• There's apparently no Mali community besides HOT but it's not related to HOT.

Schedule

• Data is very simple: only GPS coordinates with metadata.
• No shapes, no relations, only points.
• Data is ready.
• Need to validate some of the data with author.
• Tested successfuly on Dev Server.

---

Imported on September 16^th.

One changeset per Académie :

• https://www.openstreetmap.org/changeset/25474515 (Tombouctou)
• https://www.openstreetmap.org/changeset/25474463 (Sikasso)
• https://www.openstreetmap.org/changeset/25474402 (Ségou)
• https://www.openstreetmap.org/changeset/25474356 (San)
• https://www.openstreetmap.org/changeset/25474348 (Nioro du Sahel)
• https://www.openstreetmap.org/changeset/25474327 (Mopti)
• https://www.openstreetmap.org/changeset/25474303 (Koutiala)
• https://www.openstreetmap.org/changeset/25474284 (Koulikoro)
• https://www.openstreetmap.org/changeset/25474254 (Kita)
• https://www.openstreetmap.org/changeset/25474250 (Kidal)
• https://www.openstreetmap.org/changeset/25474220 (Kayes)
• https://www.openstreetmap.org/changeset/25474159 (Kati)
• https://www.openstreetmap.org/changeset/25474128 (Gao)
• https://www.openstreetmap.org/changeset/25474080 (Douentza)
• https://www.openstreetmap.org/changeset/25474028 (Bougouni)
• https://www.openstreetmap.org/changeset/25474020 (Bamako Rive Gauche)
• https://www.openstreetmap.org/changeset/25474005 (Bamako Rive Droite)

Import Data

Background

Data source site: https://github.com/jokkolabs/mali_schools/raw/master/MLI_schools.csv
Data license: https://raw.githubusercontent.com/jokkolabs/mali_schools/master/LICENSE
Type of license: Public Domain (CC0)
ODbL Compliance verified: yes

OSM Data Files

https://github.com/jokkolabs/mali_schools/tree/master/changesets

Import Type

• one-time import
• using ./upload-python2.py (tested on master.apis.dev successfuly)
• using dedicated account Open Data Mali

Data Preparation

Data Reduction & Simplification

• OSM XML files only contains nodes and selected metadata.
• All files represent ~ 10K nodes for about 10M.
• Data looks OK in jOSM

Tagging Plans

Revamped the tags follwing comments from imports@ and Import_CAR_UNICEF_Education

• amenity=school
• name=*
• source=UNICEF
• operator:type=community operator:type=religious operator:type:private=* operator:type=public
• isced:level=1 isced:level=2-3
• is_in:cercle=*
• is_in:commune=*
• is_in:village=*
• school:ML:academie=*
• school:ML:cap=*
• capacity:pupils=*
• capacity:teachers=*
• restaurant=yes restaurant=no
• toilets=yes toilets=no
• toilets:number=*
• drinking_water=yes drinking_water=no
• drinking_water:seasonal=yes drinking_water:seasonal=no

Changeset Tags

• One changeset file per academy (17)
• Largest file is 1.2M, 1214 nodes.

Data Transformation

Transformation of CSV data to OSM XML is done through a very simple Python script https://github.com/jokkolabs/mali_schools/blob/master/csv2osm.py

Team Approach

Solo effort.

Workflow

• Generate changeset files (OSM XML) : 17
• Loop through changeset files
  • upload using bulk_upload.py
  • check for failed uploads
  • manualy delete/retry erroneous changesets

See Also

• discussion about this import at Import mailing list in September 2014