Transcript APHO HES e
data visualisation tools for public health analysts SEPHIG – 8th June 2009 APHO – HES e-Atlas for Common Diagnosis and Procedures Why Bother ? – Standardise the methods used to calculate DSR and CI’s – Batch process multiple indicators across many years in one go – Output directly (well almost - ) from ‘flat file’ to interactive map – Reduce the burden of standard HES outputs for PHO’s – Does not require complex routines or specialist programming skills Group ICD-10 Codes into disease clusters Link look-up tables SQL views groups up the comparative geographies HES2 Online Database CSV extract file SQL Server – Import counts and population data Run SQL script to calculate DSR and CI ODBC link - Access exports the SQL table file into MS Excel that generate s the .xml file Load .xml into the Instant Atlas template Future Interactive atlases – – – – – – – Mental health (MHMDS) Common cancers CIP Spells (UHCE work) Potential for monthly HES data feeds Mortality Outpatient and A&E Data (currently experimental) HRG groups CASA Map Tube and the GMap creator tool CASA/University College London – Website for sharing maps created by G-map creator tools – Maps can be shared and overlayed to compare visually – Users can upload their own maps or .kml placemarks – Additional metadata details can be added – Works on raster images and NOT vector points – Works in any web browser and does not require complex plug-ins - Does require GIS application to create shape file *Image source – CASA working paper – ‘The renaissance of Geographic Information: Neogeography, Gaming and Second life (2008) Google Motion Charts – An analysts friend * See Also Bazian Swine Flue Tracker Tool IBM – Many Eyes Visualisation Useful data visualisation applications for public health analysts worthwhile blogs