Version 30 (modified by 12 years ago) ( diff ) | ,
---|
Hurricane Sandy
Table of Contents
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.)
- Tiger: http://www.census.gov/cgi-bin/geo/shapefiles2010/layers.cgi
- 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
- NYS
- 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.
- 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
- For hospital data: Upload from spreadsheet:
Attachments (1)
-
Hurricane Hackers - Sahana Eden.pdf
(1.7 MB
) - added by 12 years ago.
Hurricane Hackers presentation
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.