Healthsite attributes

Mark Herringer edited this page Aug 7, 2017 · 96 revisions

Healthsites attribute development

Please reference links on https://github.com/healthsites/healthsites/wiki/Healthsites-data-model when developing the tables below

Healthsites data import validation rules

  • mandatory - don't import data unless data present
  • core - optional but import if available
  • other - don't import

Mandatory

No. Validation Healthsite Attribute value Data Type Max Length Name in OSM
1. mandatory upstream_id upstream ID char 32 osm_id
2. mandatory date-modified date time stamp of data modification timestamp
3. mandatory name Name of the facility local name and in English text - name=* + name:en=*
4. mandatory geom lon,lat geom - lat=" " , lon=""
5. mandatory source Name and or website of the organisation supplying the data text - source=* (maybe also source:date=* too...)

Core

All of core attributes use "Text" Data Type

No. Validation Healthsite Attribute value Data Type Max Length Name in OSM
5. core type Hospital, Medical and Orthopaedic clinics char 32 health_facility:type
6. core physical-address (1) address char 32 addr:full=* .
7. core contact-number number including international dialing code (+250 252 588888) char 32 contact:phone*
8. core nature-of-facility clinic without beds, clinic with beds, first referral hospital, second referral hospital or General hospital, tertiary level including University hospital char 32 nature_of_facility: "Must to cement with zinc",
9. core scope-of-service all type of services, specialized care, general acute care, rehabilitation care, old age/hospice care. char 32 facility:
10. core operation (2) 24/24 &7/7 ; open only during business hours ; other (specify) char 32 opening_hours=*
11. core inpatient-service (3) Number of full time beds, number of part time beds char 32 bed_count: "5",
12. core ancillary-services Operating theater, laboratory, imaging equipment, intensive care unit, Emergency department char 32 -----------------
13. core activities medicine and medical specialties, surgery and surgical specialties, Maternal and women health, pediatric care, mental health, geriatric care, social care char 32 -----------------
14. core staff (4) X full time equivalent doctors and Y full time equivalent Nurse, Level of competency of the Health workers char 32 nurses_num: "7",doctors_num: "0",
15. core ownership public, private not for profit, private commercial char 32 operator:type=*
16. core raw-data-archive-URL (5) a link to the raw data file (.csv ect) char 32 -----------------

Suggested attributes to include

No. Validation Healthsite Attribute value Data Type Max Length Name in OSM
1. core ....... unique id char 32 medical_system:*=yes/no
2. core ....... unique id char 32 water_source: "tubewell"
3. core ....... unique id char 32 operator: "ngo",
4. core ....... unique id char 32 electricity: "solar",
5. core ....... unique id char 32 tags: {
6. core ....... unique id char 32 dispensing: "yes",
6. core ....... unique id char 32 healthcare:speciality: "OIC",
6. core ....... unique id char 32 healthcare=midwife
6. core ....... unique id char 32 amenity=
6. core ....... unique id char 32 toilets:*
6. core operational status (yes/no) unique id char 32 ...?
6. core ....... unique id char 32 healthcare=midwife
6. core ....... unique id char 32 healthcare=midwife

Spreadsheet template

To consider: ownership of the facility.

  1. operation
  2. inpatient service
  3. staff
  4. This should be the original data source link

040817 - Attribute session at MSF

  1. medical_system:western=yes
  2. amenity
  3. healthcare
  4. name=
  5. addr:*
  6. phone
  7. amenity=doctors + health_facility:type
  8. amenity=clinic + health_facility:type
  9. amenity=hospital + health_facility:type
  10. health_specialty:emergency_medicine
  11. health_specialty:obstetrics:antenatal
  12. health_specialty:obstetrics:caesarean_section
  13. health_specialty:paediatrics
  14. health_service:prevention:vaccination=
  15. capacity:beds=
  16. capacity:women=
  17. capacity:disability=
  18. opening_hours
  19. doctors_num
  20. nurses_num
  21. staff
  22. operator
  23. operator_name
  24. source=
  25. operator:type=
  26. source:date
  27. power_supply=
  28. Note

Updated attribute list based on IHF recommendations

This list was shared by the International Hospital Federation

  1. Geo localization of the facility (GPS coordinate)
  2. Name of the facility local name and in English
  3. Nature of facility: clinic without beds, clinic with beds, first referral hospital, second referral hospital or General hospital, tertiary level including University hospital
  4. Scope of service : all type of services, specialized care, general acute care, rehabilitation care, old age/hospice care.
  5. Operation : 24/24 &7/7 ; open only during business hours ; other (specify)
  6. Inpatient service: Number of full time beds, number of part time beds
  7. Ancillary services : Operating theater, laboratory, imaging equipment, intensive care unit, Emergency department
  8. Activities : medicine and medical specialties, surgery and surgical specialties, Maternal and women health, pediatric care, mental health, geriatric care, social care
  9. Staff: X full time equivalent doctors and Y full time equivalent Nurse
  10. Ownership: public, private not for profit, private commercial
  11. raw-data-archive-URL: a link to the raw data file (.csv ect)
  12. Source: name of the organisation supplying the data

Other

All of Other attributes use "Text" Data Type

validation Healthsite Attribute
other contact_person
other phone
other mobile
other email
other url
other country
other Status
other Verified
other Date entered
other Centre ID
other Org
other Capacity (N)
other Equipment (R.A.G)
other Staff (N)
other Doctors
other Nurses
other Isolation Facility
other PPE
other Burial Site
other Water
other Power
other Comm.
other Date open
other Date closed
other Province
other Adm1 ID
other District
other Adm2 ID
other Place
other Adm3
other Location in OSM
other Notes
Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.