= 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 * 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