Hospital Status Tracking

Request from White House via Crisis Commons:

• ​http://wiki.crisiscommons.org/wiki/Hurricane_Sandy_2012#A.4_NY_Hospital_Evacuation_and_Availability
• Sahana instances:
  • Production: ​http://sandy.sahanafoundation.org
  • Test: ​http://sandytest.sahanafoundation.org
    • Can be used to test data imports
    • Can be used to test new code
    • Database refreshed from Production to test database migration during upgrades
  • Please only register if you are actively working on the project
• Code: Trunk with Sandy template: ​https://github.com/flavour/eden/tree/master/private/templates/Sandy
• HMS User Guide

Requirements

These should be written as User Stories: BluePrint/Guidelines

• White House to be able to get an overview of the Hospital Statuses across the affected region
  • Style Map markers (Feature Query)
  • breakdown by region
    • Search widgets
  • breakdown by services
    • Search widget (although we don't have data yet)
  • reopening time
  • damage sustained
  • power
• Requests?
• Contacts?
• Security Policy? (currently Simple: http://eden.sahanafoundation.org/wiki/UserGuidelines/Admin/Permissions)
• Stick to HAVE: ​http://docs.oasis-open.org/emergency/edxl-have/emergency_edxl_have-1.0-spec-pr02.xhtml
• xml2csv nice to be able to export CSV in the same format that we can import for updates

Issues

• Map not showing locations until gis.update_location_tree() run manually via CLI
• Reports not defaulting the fields in the options except for the component one (fixed)
• Importer no longer having errors appear in 1st rows (fixed)
  • also not searchable (fixed)
  • also have some records show up in XML (fixed)
  • also would be nice not to have apostrophes quoted (fixed)
• Need to explain delay in Lx getting populated via gis.update_location_tree()

Data

Hospitals

• ​http://dev.docnpi.com/
  • ​http://codelists.wpc-edi.com/mambo_taxonomy_2_pre_production.asp

Notes on uploading from csv files

• Upload from spreadsheet:
  ​http://sandy.sahanafoundation.org/eden/hms/hospital/import
  Click the 'Download template' link to get a blank sample