Import CAR UNICEF Education

From OpenStreetMap Wiki
Jump to: navigation, search

Goals

This is the second import for Central African Republic done as a part of the EUROSHA project. Its goal is to include the UNICEF data for education for half of Central African Republic into OSM.

Schedule

  1. Preparation, discussion - April 2013
  2. Import - expected start in April 2013

Import Data

Data description

The data has been collected on the field by UNICEF during various surveys. The dataset consists of 934 nodes for 6 regions (prefectures) of CAR: Mambere-Kadei (98 nodes), Nana-Gribizi (70 nodes), Nana-Mambere (115 nodes), Ouaka (151 nodes), Ouham (247 nodes) and Ouham-Pende (253 nodes).

The dataset contains following field attributes: ID, WPT, CODE, TYPE, LAT_DD, LONG_DD, ALT_M, PAYS, PREF, S_PREF, COMM, VILLE_VILL, QUARTIER, POP_VILLE_, STATUT_ECO, CYCLE, NOM_ECOLE, NB_ELEVES, NB_FILLES, NB_SALLES_, NB_INSTITU, NB_MA_TE_P, APE, TYPE_CONST, LTA, VIP, NB_VIP_PLE, LATRINES_S, NB_LAVE_MA, CLUB_HYGIE .

Background

ODbL Compliance verified: YES
The authorization given by UNICEF CAR was approved by the OSMF License Working Group as ODbL compatible.

Import Type

This is a import done manually in JOSM, through a specific Tasking Manager job, according to a worflow document.

Data Preparation

Data Reduction & Simplification

The data will be reduced only to the keys listed below.

Tagging Plans

Considering the accuracy of the location is sometimes coarse and the objects have to be moved, a fixme will be created with the UNICEF pair of coordinates as values so that the contributors can have a track of the original location.

In the spreadsheet below, No values are not counted within the number of objects. The other fields are considered as not relevant and so will not be tagged.

Unicef Key Unicef value (number) OSM tag
all objects amenity=school
all objects source=UNICEF
ID not tagged because not relevant
WPT not tagged because not relevant
CODE not tagged because not relevant
TYPE not tagged because not relevant
LAT_DD not tagged because not relevant
LONG_DD not tagged because not relevant
PAYS not tagged because not relevant
PREF, SOUS_PREF, COMM, VILLE_VILL, QUARTIER addrːfull=*
VILLE_VILL addr:city=*
STATUT_ECO Public (826) operator:type=public
STATUT_ECO Prive (103) operator:type=private
CYCLE Complet (683) school:cycle=complete
CYCLE Incomplet (246) school:cycle=incomplete
NOM name=*
NB_ELEVES capacity:pupils=*
NB_SALLES_ capacity:classrooms=*
NB_INSTITU + NB_MA_TE_P Addition of the two fields capacity:teachers=*
TYPE_CONST Dur (314) building:material=hard
TYPE_CONST Semi-dur (142) building:material=semi-hard
TYPE_CONST Traditionnel (378) building:material=traditional
LATRINES_S Oui (318) toilets=yes
LATRINES_S Non (444) toilets=no
LATRINES_S empty (86) toilets=unknown

Changeset Tags

We will use the following changeset tags.

Data Transformation

Data were received as a XLS sheet. Reduction, simplification, manual cleaning and tag transformation will be done directly in a copy of the XLS file. The two fields of coordinates will be renamed X and Y. Then the file will be converted into CSV and divided into 6 files based on the region. The 6 CSV files will be opened with JOSM as CSV files with the opendata plugin. Finally the files will be saved in the OSM format and ready for distribution/import.

Data Merge Workflow

Team Approach

The importation team consists of 5 EUROSHA volunteers: FRosenkranc, LenkaP, fedebasa, Jorieke V and MorganeG. The preparation is done by sev_hotosm from the Humanitarian OSM Team.

References

The import will be discussed in the import list.

Workflow

Please refer to the workflow page.

Reverse plan

In case of any trouble, JOSM reverter will be used.

Conflation

Unicef dataset has 934 nodes out of which all should be imported. In the 6 regions of CAR where import will be happening, the only education facilities mapped are those already mapped by Eurosha volunteers in Bangui and cities taken by the rebels in December 2012. These cities are: Mbrès (region Nana-Grěbizi), Kaga-Bandoro(region Nana-Grěbizi), Batangafo (region Ouham) and Kabo (region Ouham). Only data in these cities will be manually merged.