1 / 11

California Healthcare Atlas Integrating Geography & the Data Warehouse

California Healthcare Atlas Integrating Geography & the Data Warehouse. Presenter: Michael O’Neill. March 2009. Overview. Brief High-level System Architecture Data Warehouse Summary History of our Atlas Live Demonstration Summary of Atlas’ Content & Capability Future ?.

paloma
Download Presentation

California Healthcare Atlas Integrating Geography & the Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. California Healthcare AtlasIntegrating Geography& the Data Warehouse Presenter: Michael O’Neill March 2009

  2. Overview • Brief High-level System Architecture • Data Warehouse Summary • History of our Atlas • Live Demonstration • Summary of Atlas’ Content & Capability • Future ? http://www.oshpd.ca.gov/atlas

  3. Web Server Other Website Other Website Other Website Atlas System Architecture Atlas Web Server User Map Engine PDF .NET Source Data ETL Data Warehouse ETL ArcSDE Layers Internet Locators

  4. About our Data Warehouse 6 yrs old • Facility • 6350 total facility • Financial * • 5 years in data mart(in progress) • 33 yrs in mainframe • 1741 data elements • 17 yrs in hospital pivot tables • 254 attributes • Utilization * • 5 years in data mart(in progress) • 4200-2600 reports annually • 131 to 615 data elements each report • Inpatient • 12 years • 48M encounters • 400+ attributes • Emergency Dept. • 3 years • 26M encounters • 500+ attributes • Ambulatory Surgery • 3 years • 11M encounters • 500+ attributes

  5. ? Atlas: Evolving Data Delivery v2 v1 2007 PDF & Pivot 2005 Delivering healthcare data in increasingly more meaningful & contemporary ways. 1995

  6. Live Demonstration – v2.3 • Locate • Find “things” on the map • Select • Discover hospital info & compare • Create • Create specific types of thematic maps • Other tabs • Results, Map, Help http://www.oshpd.ca.gov/atlas http://www.oshpd.ca.gov/atlas

  7. Feature: LOCATE • Locate facilities by a wide variety of selection criteria • Find… • address, • ZIP code • city, • county, • medical service study area (MSSA) • census tract • assembly district • senate district

  8. Feature: SELECT • Select hospitals OR groups of hospitals • Retrieve… • Patient Summaries by Facility • Financial Reports • Utilization Reports • Top 25 Diagnosis Related Group Reports • Facility Reports • Demographics • Birth & Death Vital Statistics (from CDPH) • Fair Pricing Policies

  9. Feature: CREATE • Create a variety of maps… • Patient Origin & Patient Destination • Filtered by year, MDC/DRG, payer, gender, age, race, ethnicity • Vital Record Statistics • Critical Access Hospitals • Disproportionate Share Hospitals • Mental Health Professional Shortage Areas • Dental Health Professional Shortage Areas • Primary Care Health Professional Shortage Areas • Medically Underserved Populations • Medically Underserved Areas • Urban Rural and Frontier MSSAs

  10. Vision for the Future ? • More data integration • More visualization • More giving data a voice • More effective, easier, & faster investigations Conceptual design

  11. Questions ? Michael O’Neill gisWebmaster@oshpd.ca.gov http://www.oshpd.ca.gov/atlas

More Related