= Hurricane Sandy =
[[TOC]]

We have setup 3 instances:
* [Deployments/Sandy/Hospitals Hospitals Status Tracking].
* American Red Cross: Volunteer Management for Shelter Staffing
* [Deployments/Sandy/Occupy OccupySandy] managing Requests for Supplies & Volunteers

== Requirements ==
These should be written as User Stories: BluePrint/Guidelines
== 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 one of these:
    * http://www.brainyzip.com/state/zip_newjersey.html
    * 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