Hurricane Sandy

Instance setup to manage Hospitals data.

Request from White House via Crisis Commons:

• ​http://wiki.crisiscommons.org/wiki/Hurricane_Sandy_2012#A.4_NY_Hospital_Evacuation_and_Availability

Instance:

• ​http://sandy.sahanafoundation.org
  • Please only register if you are actively working on the project
• 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

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

• Boundaries and hierarchy:
  • L0, L1 & L2 are in GADM (done)
  • L3
    • Tiger: ​http://www.census.gov/cgi-bin/geo/shapefiles2010/layers.cgi
      • No use for NYC as it puts 1 L3 Borough in each L2 County
    • Brooklyn: ​http://geocommons.com/overlays/6090
    • NY State civil boundaries: ​http://gis.ny.gov/gisdata/inventories/details.cfm?DSID=927
      "boundaries of incorporated places in New York State (state, counties, cities, towns, villages, and Indian reservations)"
      (Note ocpyrighted.)
  • L4 (Zip codes)
    • NYS ​http://gis.ny.gov/gisdata/inventories/details.cfm?DSID=934
      • needs parenting to L3s via ​http://www.health.ny.gov/statistics/cancer/registry/appendix/neighborhoods.htm (done but this is only for NYC)
    • NJ: ​http://geocommons.com/overlays/22081
    • Full hierarchy w/o shapefiles is available from ​http://www.zip-codes.com/zip-code-database.asp for US$40. They allow looking up data in batches, but would need to copy & paste the table part of the page into a file (not the html, just select the rows in the rendered page). Suggest looking up each county in NY in turn here: ​http://www.zip-codes.com/search.asp

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

• Notes on uploading from csv files (incomplete)
  • For hospital data: Upload from spreadsheet:
    ​http://sandy.sahanafoundation.org/eden/hms/hospital/import
    Click the 'Download template' link to get a blank sample
  • Location hierarchy & wkt
    Fran's CLI process to import location CSVs:

    auth.override = True
    resource = s3db.resource("gis_location")
    stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
    import_file = os.path.join("/", "home", "data", "US_L2.csv")
    File = open(import_file, "r")
    resource.import_xml(File, format="csv", stylesheet=stylesheet)
    db.commit()
    

  • http://eden.sahanafoundation.org/wiki/UserGuidelinesGISData
  • http://eden.sahanafoundation.org/wiki/GIS/OpenStreetMap#Import