RFUK health facility import cameroon

From OpenStreetMap Wiki
Jump to navigation Jump to search

Goal

The goal is to import community health provision data from Cameroon.

Schedule

Planning:

  1. Share the data - DONE
  2. Sign the the OpenStreetMap Foundation authorisation letter  - DONE
  3. Data preparation
    • Group call to review and discuss data as is - DONE
    • Move data to OSM aligned spreadsheet - DONE
    • Clean the data - TODO
  4. Community buy in
    • Discuss the tagging plan and answer questions from the community - In progress
  5. Import review

Import: April 2021

QA: Post-import.

Announce Import : https://lists.openstreetmap.org/pipermail/talk-cm/2020-October/000311.html

Import Data

  • Data source site: rainforestuk.org
  • ODbL Compliance verified:Yes

Background

The data has been collected by mapping facilitators from local organisations (Brainforest, CADEM, CED, DGPA, Foder, GASHE, MEFP, OCDH, RRN) in collaboration with local communities and the support of the Rainforest Foundation UK (RFUK).

Data files

Import type

Method of import: All the imports will be done using JOSM with the import specific OSM accounts.

Data Preparation

Tagging plans

Here we list all the original tags with their corresponding translation into the OSM tagging schema, plus additional tags for all segments:

RFUK key RFUK values meaning OSM tag Comments
VIL_NAME Name of the village the feature belongs to addr:place addr is the prefix for several addr:* keys to describe addresses
YEAR Year of data collection source:date For indicating the date when the source of information of anything added to the OSM database was taken.
NAME Name of the health facility name The primary tag used for naming an element
TYPE Type of health facitility amenity For describing useful and important facilities for visitors and residents
ASS_VILLGS List of associated village(s) / Ignored for this import
A_PATIENTS Number of patients received per year / Ignored for this import
BEDS Number of beds in the facility beds Indicates the number of beds in a hotel or hospital
BUILD_TYPE Building material type (earth construction, timber construction, cement brick construction, corrugated iron roof etc.) building:material used to describe the outer surface material of building walls, also know as the facade or façade.
GP_COUNT Number of doctors in the facility staff_count:doctors Indicates the number of doctors in a health facility
NURSES Number of medical staff (nurse, midwife etc.) in the facility staff_count:nurses Indicates the number of nurses in a health facility
ADMIS_REAS List of main reasons for admission / Ignored for this import
HEALTH_DIF Difficulties encountered by the health facility / Ignored for this import
DATE_SURVD Date of survey (automatic from collection app) / Ignored for this import as it is a duplicate of the information stored in YEAR

Data transformation

  1. Select OSM supported health attributes from raw data Cameroon health facility list (in csv format)

Data transformation results


Changeset tags

We will use the following changeset tags:

  • comment=Rainforest Foundation health facility import 2020' and source 'Rainforest Foundation
  • source=rainforestuk.org
  • source:date=YYYY[-MM[-DD]]..YYYY[-MM[-DD]],
  • import=yes
  • url=https://wiki.openstreetmap.org/wiki/RFUK_health_facility_import_cameroon

Data merge workflow

Workflow / Conflation

Healthsites-datamerge-process-cameroon (3).png

The cleaned up data sets will be divided into sections and assigned to the each user based on region.

Every individual user will follow the below instructions:

  1. Install the ToDo list and the OpenData plugins in JOSM
  2. Load the cleaned csv file into JOSM.
  3. Convert/save the csv file as .geojson/.json or .osm (To be confirmed).
  4. Select all the elements and add to ToDo list.
  5. Go to the first element, download OMS data and check all the attributes of the same - the address, position of the feature and check for another similar feature in the area.
    1. If the feature is already existing in OSM then add the missing attributes.
    2. If there isn't a feature and the address of the element is correct then copy the same into the OSM layer.
  6. Repeat with all the elements on ToDo list, verify with JOSM validator and upload the changes with the import changeset tags.


QA

See also