Healthcare Workforce Forums and Mapping Initiative

1
Healthcare Workforce Forums and Mapping Initiative

• Sonya McNamara and Kristin Juliar
• Minnesota Healthcare Education Industry
  Partnership
• Sally Buck
• Rural Health Resource Center
• Ann Peton
• RUPRIs Community Information Resources Center,
  (CIRC)

Minnesota Rural Summit July, 2005
2
Healthcare Workforce Mapping Initiative

• Goals
• Workforce data visualization
• Support planning for educational programs
• Real and potential economic impact upon region
  and county
• Assessment for new or enhancing health care
  services
• Support for grant program development
• Facilitate dialogue among healthcare industry,
  education, business, and elected officials
• Support policy/legislative decision making

3
Minnesota Healthcare Workforce Mapping Partners
4
Minnesota Healthcare Education Industry
Partnership

• Mission
• Working in partnership to provide innovative
  leadership to guide the education and training of
  a high quality workforce in a rapidly changing
  industry

5
  Healthcare Workforce Mapping Initiative CIRC
National Data

• 1990 2000 Census Income, housing, race,
  education, workforce, labor force
• 2010 2020 Projected Demographics
• Administrative CBSA, RUCA, MSA/non-MSA
• Poverty Data
• Economic/Employment Political congressional,
  state districts
• Education elementary/high school districts
• Health data 2002 2004 Medicare/Medicaid
  points of service, HPSA, MUA , mental health and
  community health centers, ORHP grantees,
  Ambulance Service Areas, PCSA
• Transportation

6
Older population in northern and western
Minnesota.
7
  
Minnesota Healthcare Workforce Database

• Survey data collected for 10 years by the MDH
  Office of Rural Health Primary Care (ORHPC)
• In cooperation with a number of Minnesotas
  health professional licensing boards
• Voluntary. Survey response varies.

8
4,261 Primary Care Physicians 30 in rural areas
9
Healthcare Workforce Mapping Initiative The Data
The Foundation for Success

• CIRC national data sets
• Regional boundaries McKnight Foundation
• Health care facilities
• Health care workforce
• Health care education graduation data

10
2.7
110 hospitals in rural areas.
11
Minnesota Healthcare Workforce Database

• Physicians
• Registered Nurses
• Licensed Practical Nurses
• Dentists
• Dental Hygienists

• Dental Assistants
• Pharmacists
• Physician Assistants
• Respiratory Care Practitioners
• Physical Therapists

12
18.6 increase in rural population.
2.7
13
IPEDSIntegrated Post-secondary Education Systems

• Graduate data from National Center for Education
  Statistics, U.S. Department of Education, and the
  Minnesota State College and University System
• Includes all two- and four-year degree programs
  in Minnesota, both public and private
• Available in other states check with Higher
  Education Coordinating Board

14
Internet-based Healthcare Workforce - Mapping
Application

• Utilizing Map Room framework
• Provided to partners geospatial data standards,
  content for display, format, metadata/quality
  issues
• Spatially Enabling the data and partitioning
  into SDE
• Customizing the mapping template with State
  specific data

15
Components of GIS

• Database

16
Types of GIS Data

• Point - healthcare facility, house
• Line - stream, road, healthcare service route
• Polygon/Area lake, census block group, number
  of nurses in zip code

17
Geographic Features
Geographic features are represented by two types
of data.
Street Name Address range on left Address range
on right Length to travel Directions to travel
ATTRIBUTE DATA
SPATIAL DATA
18
Creating Data Layers. . . linking digital data
to geography
Street Addresses Streets/Rivers/Land
Features Hospital/Medical Center/ Clinics Zip
Codes/Counties Spatial Analysis (i.e.travel
times) Service Demand/Provider Density
19
Hospital Site Location
20
Epidemiology Outbreak Analysis
21
Types of Mapping

• Internet (IM)
• Desktop Arcview, ArcMap, ArcExplorer
• Differences
• IM access all data at one time
• IM Unique set of analytical tools
• IM provide public access to mapping
• Desktop makes higher quality maps
• Spatial enabling capability and more
• Ability to blend two datasets and map

22
Desktop Maps of MN Healthcare Workforce Data
23
Internet Mapping Map Output
24
Internet Mapping

• Takes GIS mapping online
• Provides easier access to information
• Built upon common Internet browsers
• Ability to visualize multiple data layers
  interactively
• Share maps with others or download data as a
  spreadsheet for further use

25
Community Information Resources Center (CIRC)
circ.rupri.org
26
CIRCs Infrastructure of Services

• Internet Mapping
• Interactive Internet Mapping Tutorial
• Unique Data Download
• Animated Time Series Maps
• National Data Archive
• Map Archive
• Customized Map Output
• Analytical Tools

27
CIRCs UniqueMap Room Process Step 1
28
CIRCs Unique Map Room Process Step 2
29
CIRCs Unique Map Room Process Step 3
30
Internet Mapping Session
31
Base Data
32
2010 2020 Projected Demographics
33
Census Demographic
34
Education by Institution Type and Change over 4
years
35
Licensed Health Facilities
36
Health Professionals
37
Health Professionals - Physicians
38
Health Professional Shortage Areas and Medically
Underserved Areas
39
HPSA and MUA
40
Questions that can be answered through Internet
Mapping

• Where are the healthcare facilities within a
  congressional district?
• Where are the healthcare workforce relative to
  healthcare facilities?
• Where are Healthcare workforce relative to
  underserved
• Where are the aging physicians relative to
  population increases workforce shortage
• Where are the schools relative to rural?

41
Where are the healthcare facilities within
Congressional district 4?
42
Where are the Nursing Homes in Congressional
District 4?
43
Next Steps

• Identify data that will add value to MN
  healthcare workforce issues
• Timing and audience
• Any CIRC additional services wanted beyond
  internet mapping application time series
  mapping, map archive, analysis
• Who else should be engaged?
• Funding

44
Contact Information

• Sally Buck 218-727-9390, ext 225
• sbuck_at_ruralcenter.org
• Kristin Juliar 507-389-2707
• kristin.juliar_at_mnsu.edu
• Ann Peton 573-268-8416
• petona_at_missouri.edu
• http//circ.rupri.org