WikiProject Uganda/Import Uganda Bureau Of Statistics Education Facilities

From OpenStreetMap Wiki
Jump to navigation Jump to search

Goals

The goal is to import 24,587 education facilities of Uganda released by the UBOS (Uganda Bureau Of Statistics). This facilities go from kindergartens up to university colleges.

Schedule

  1. Preparation, discussion: To be started on Wednesday 2nd of December 2015.
  2. Import: Expected to start as soon as community has solved any issues.

Data

Data description

Acording to the Uganda Bureau of Statistics: "These data was collected between 2010 and 2014, based on Arc1960 UTM 36S, for the sole purpose of census enumeration, management and administration, and it could include minor naming mistakes, small measurement errors and be out of date for some new service facility developments in health and education. Therefore, it should be used cautiously within its limitations."

The original dataset consists of 24,587 education facilities nodes, in shapefile format.

The dataset contains several field attributes, some of them being useful for import.

Background

ODbL Compliance verified: YES

The Uganda Bureau Of Statistics has given full authorization for the use of their data in OpenStreetMap under the ODbL license. A scan of the document can be found here.

Import Type

The import will be done manually through one project in the HOT Tasking Manager (TM), having for each task of the project only the education facilities nodes that lie within the task tile, in a similar way as it was done for the Central African Republic UNICEF import and other similar imports. For each task, we will first check the education facilities nodes to be imported, and second we will assess the data already in the OSM database against the UBOS data, for the merging of the UBOS data into the OSM database. The OSM mappers who will contribute to this import project will follow a detailed workflow to accomplish this.

Note: Each facility node is a very good source of place=* data. Many of the places where these facilities are located aren't yet in OSM, so we can use that information to produce place nodes. But that info will better be incorporated in a different and independent import project.

Data Preparation

Data Reduction & Simplification

The data is originally in shapefile format. You can download the original data from here.

Tagging Plans

Each education facility node will have the following tags:

UBOS key OSM tag Comments
All objects source=www.ubos.org
All objects source:date=2010..2014
FCode=0 or not present amenity=school + note:code=Please, check if amenity school is ok Type of facility not collected.
FCode=1 amenity=kindergarten Nursery school.
FCode=2 amenity=school + note:code=Primary School Primary school.
FCode=3 amenity=school + note:code=Secondary School Secondary school.
FCode=4 amenity=school + note:code=Vocational School Vocational school.
FCode=5 amenity=school + note:code=Technical school/Institute Technical school/Institute.
FCode=6 amenity=school + note:code=College (same level as secondary) College (same level as secondary).
FCode=7 amenity=school + note:code=Institute Institute.
FCode=8 amenity=university University.
FCode=99 amenity=school + note:code=Please, check if amenity school is ok Other training center (community, etc).
FName=* name=* Name of the facility.
Remarks=* note:remarks=* 1,187 different values, and not present for 13,804 nodes (56.1%). This key has comments about the facility. The information it gives are hints about its location, number of buildings of the facility, type of education, levels of education offered, the operator and/or type of operator of the facility, status of the school (abandoned, under construction...), alternative name, week tuition days, what other services it provides, if it has electricity or not, etc. Some of this info can be used to help correcting the location of the facility; some other info can be used to add tags to the node, like operator=*, operator:type=*, opening_hours=*, power_supply=*, isced:level=*, etc. Those added tags should be documented in the import workflow wiki, to help mappers to make the best possible choice.
VillageNam=* addr:city=* Village where the facility is located.
ParishName=* addr:parish=* Parish where the facility is located.
SubCountyN=* addr:subcounty=* Subcounty where the facility is located.
CountyName=* addr:county=* County where the facility is located.
DistrictNa=* addr:district=* District where the facility is located.
Altitude=* Ignored. Not relevant.
Easting=* Ignored. Not relevant.
Northing=* Ignored. Not relevant.

Changeset Tags

We will use the following changeset tags:

To the comment=* tag, you may need to add particular comments to the changeset.

Data Transformation

Data is in shapefile format. We opened the file in JOSM with the OpenData plugin, and then processed the osm file and convert it to a new osm file with a script. This script puts in lowercase the texts that are all uppercase (except first letter of each word), and adds tags according to the tagging schema. It also converts strings like for example P/SCH to Primary School.

Data Merge Workflow

Team Approach

Import will be undertaken by experienced OSM mappers, using an import specific OSM user account, following a workflow and working through a HOT Task Manager project similar to the ones set for the import of UNICEF health facilities, schools and water resources in Central African Republic, and many others that followed that approach.

References

The import will be discussed first in the Talk-Ug list, and then in the Imports list.

Workflow

You can see the workflow here.

Reverse plan

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

Conflation

The location of the education facilities nodes is generally never more than 150-200 m of the real location, but following the already mentioned workflow, we will place the nodes in the exact position. In case we can't be sure about the location (quite rare), we will leave them in the original position and add a fixme=Please, check the position of the node tag to the node.

If other education facilities are encountered, they will be compared with the UBOS ones and merged, keeping all info that the old nodes have. In case of doubt, a fixme tag will be placed, the issue will be reported in the comment of the task (tile) of the TM project for later validation, and the user that uploaded the old education facility node would eventually be contacted if needed.