= Hurricane Sandy =
[[TOC]]

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
* [wiki:UserGuidelinesHMS 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 (Zipcodes) -- polygons and parents
  * 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
   * Could extract hierarchy from here: http://newjersey.hometownlocator.com/zip-codes/counties.cfm
  * Important zipcode facts: http://www.maponics.com/products/gis-map-data/maps-reports/zip-code-maps/faqs/
   * Zipcodes can cross administrative region boundaries. They don't cross state boundaries, but do cross county boundaries. (For the population centers project, when we found a zipcode that spanned admin regions, we partitioned the zipcode -- made one location record for each partition. Names were qualified with the parent region.)
   * Zipcode regions are not technically polygons but rather groups of addresses.
   * USPS neither needs nor maintains boundary polygons.
   * Each zipcode is assigned by USPS to a city, but not by boundary inclusion -- rather, this is by which post office delivers mail to that zipcode. Thus lists of USPS-designated cities cannot be used for the location hierarchy.
   * Zipcodes have a prefix hierarchy.
    * http://stevemorse.org/jcal/zip.html
    * Three-digit zipcode prefixes by state: http://en.wikipedia.org/wiki/List_of_ZIP_code_prefixes
 * 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 here http://www.zip-codes.com/search.asp, 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). Caution: We do not want to use copyrighted or proprietary material w/o the requisite payment or attribution. Could contact them and inquire about temporary use of the information.

* 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