Haiti Hospitals and Medical Needs Management System
Summary of Project: Based on a demand-driven request for information from US Southcom, a system is needed to monitor the status and needs of all medical facilities in Haiti. This is a huge effort integrating lots of different projects, and Sahana has a role in it. A couple of conference calls have taken place on 19, 20 and 21 January involving the following key contacts and persons involved in the effort:
- Noel Dickover (DOD)
- John Crowley (NDU/StarTides)
- Kate Chapman (FortiusOne / Geocommons)
- Mark Prutsalis (Sahana)
- David Bitner (Sahana)
- Patrick Meier & Fletcher Situation Room (Ushahidi)
- Ricardo Arias (US Southcom)
- Luke Beckman (InSTEDD)
- EIS/FrontlineSMS
- Carl Taylor (AIMS)
Integration Vision:
- AIMS serves as the resource management transactional tool for both USSOUTHCOM to use to track and fulfill requests on the APAN network.
- EIS/FrontlineSMS is used for AIMS to send requests for information from USSOUTHCOM to hospitals
- Sahana serves as a repository of hospital location information and status reported into AIMS.
- Either Sahana or Geocommons can serve as front-end for dynamic situational awareness maps - viewable via APAN or outside.
Sahana Hospitals and Medical Facilities: Sahana currently has a decent registry of hospitals and medical facilities in pre-quake Haiti culled from a RELIEFWEB map and manually plotted. There is also available a PAHO list of 157 hospitals and medical facilities in Haiti that has somewhat been updated with some damage and operating information. 57 of these hospitals have geolocation information (lat/long) - the other hundred do not. Many of these are on the Sahana list - but the names may not match as Sahana often is just listed as "Medical Facility near rue...". (In the following "hospitals" refers to all hospitals, medical facilities, temporary clinics, assets such as USNS Comfort, etc.)
Immediate Sahana tasks (today):
- review the PAHO list and reconcile with Sahana sites (updating Sahana with correct names)
- For PAHO list see | PAHO list
- For Sahana list see csv or xls format
- add list of additional geolocated hospitals from PAHO list to Sahana
- scrape crisismappers list for additional sources of geolocation of hospitals and medical facilities (including assets like offshore USNS Comfort)
- research remaining 100 hospitals from PAHO list to geolocate them and add them to Sahana (use google earth, googling, internet research - whatever you can to find the coordinates of the hospital based on the name and address provided in the PAHO list)
- continue to serve up KML, georss, and other feeds of this location data such that it can be utilized by geocommons and AIMS
Future tasks (tomorrow):
- manage hospitals within Sahana as "offices"
- add contacts from PAHO and other lists to Sahana - linked to the hospitals
- add following fields to Sahana hospital data:
- Status field (active operating at 100%, operating at 75% capacity, 50%, 25%, not operating)
- Number of Doctors
- Number of Nurses
- Number of Non-Medical Staff
- Total Beds
- Available Beds
- Patients (and by extension, being able to dynamically report available beds)
- Services Available (open field for now, drop down later)
- Needs (open field, alt urgent flag probably needed)
- Damage (open entry field for now)
- Address
- Contact Number
Long-term tasks (the next day):
- build sync with geocommons and AIMS to get status updates of hospitals into Sahana
A proof of concept will be demonstrated to US SOUTHCOM for possible inclusion in their APAN system (secure system set up for HA/DR civ/mil coordination - [HA/DR = Humanitarian Assistance/Disaster Response" in military-speak]. If they want this deployed, there will be funding for a team to deploy to Avon Park, FL for 5 weeks to support SOUTHCOM on this mission. Sahana will have one of these seats.
Solution
- A new Hospital Management System module: hms
- This will have a single resource initially: hospital
Work being led by nursix in #sahana-py
Demo for testing:
Live version:
Features:
- Data Exchange in EDXL-HAVE through REST interface
- Implements all components for hospital status as named in HAVE specification
- UserGuidelinesHMS
ToDo
- Data model enhancement: EMS Operations Status (=>Triage Count)
- EDXL-HAVE Import template (Problems: import/match locations, no hospital UUID in HAVE)
- Reports/Indicators
- Capacity Utilisation (per hospital/bed type/region)
- Tools
- Patients Routing ("Find a bed")
- Link to Mapping
- Next Set of Requirements for HMS/RMS
- Update Hospital Records with PAHO UUID