Barbara Seitz de Martinez, PhD, MLS, CPP

1
The Potential of Geographic Information Systems
(GIS) to Facilitate Data-Driven Prevention
Partnerships to Facilitate Prevention and
Recovery Transformation Where It Counts!

• Barbara Seitz de Martinez, PhD, MLS, CPP
• Desiree Goetze, MPH, CHES, CPP
• Kaigang Li
• www.drugs.indiana.edu

2
What You Will Learn

• Components of GIS system
• How GIS Helps with Strategic Planning
• How GIS Can Help You with Program Evaluation
• Surveillance System
• Track Change over Time and Space
• How GIS Plays a Role in Research
• Example Impact of Smoking and Coalitions
• Morbidity and Mortality
• Making Sense of the Data

3
Data What is it?

• Its up to you!

http//skywalker.cochise.edu/wellerr/rocks/sdrx/li
mestoneL.htm
www.breitbart.com/article.php?id070312165704.qtgd
3817show_article 1catusimagelarge
4
Use it to enhance quality of life

• Its what you make of it!

Limestone detail, IU
http//www.indexstock.com/content/ artists/Rich20
Remsberg.asp
House of Parliament, London, England
http//www.bluffton.edu/sullivanm/england/london/
parliament/frmriver.jpg
5
Data-driven preventionbut you drive

• Its up to you!

Little 500 Bike Race, IU
http//newsinfo.iu.edu/asset/ page/normal/1450.htm
l
6
Components of a GIS System

• Minimal Equipment and
• Personnel Skill Requirements

7
GIS System Levels of Complexity
8
Level 1 Extract Data

• Equipment Hardware and Software
• Data Purchased Databases
• www.tetrad.com
• Kinds of Skills (Capacity Building)

MapInfo, PCensus, Maploader (1)
Basic Computer And Printer (1)
Purchased GIS data (1)
Basic Computer Skills (1)
9
Level 1 Extract Data
MapInfo, PCensus, Maploader (1)
Purchased GIS data (1)
Basic Computer Skills (1)
10
Alcohol Spending per Household
11
Adults without a High School Diploma
12
Data can seem overwhelming

• Too much data can seem overwhelming.

http//entertainment.webshots.com/photo/1041702010
015901341YseGEP
13
Lake County Less Than High School Diploma
Source AGS, 2007 estimates
14
Lake County Less Than High School Diploma
Source AGS, 2007 estimates
15
Lake County Less Than High School Diploma
Source AGS, 2007 estimates
Census Tracts 30300 30100 30200 31000 20400
20600 10202 10700 10500 11300 41200
16
Lake County Less Than High School Diploma
17
Family Conflict Divorce
18
Lake County Divorce Rate
Source AGS, 2007 estimates
19
Lake County Divorce Rate
Source AGS, 2007 estimates
Census Tracts 20600 10203 10202 10201
10900 11300 11700 1160011900 41600 12600
20
(No Transcript)
21
Level 2 Your Data / Maps

• Equipment
• Geocoding Software
• Color Printer
• Data
• Local data
• Addresses
• Skills (Capacity Building)
• Patience, precision
• Microsoft Excel, Microsoft Access

22
Software Required
MapInfo, PCensus, Maploader (1)
Mapmarker Geocoding software, Excel Access (2)
23
Data Complexity
Purchased GIS data (1)
Imported data (free or purchased) (2)
24
Examples of Data
AGS, Claritas, Map files (1)
Program Data, Address Data, Health Data (public
or purchased) (2)
25
Skills Required
Basic Computer (1)
Geocoding, Excel and Access (2)
26
Afternoons R.O.C.K. in Indiana
Afternoons R.O.C.K. Programs, 2005-2006 School
Year
Indiana Prevention Resource Center
Afternoons R.O.C.K. in Indiana, 2006
27
Places of Worship
Places of Worship, 2005
Indiana Prevention Resource Center
Info USA, American Church List, 2005
28
Youth Serving Agencies
Youth Serving Agencies, 2005
Indiana Prevention Resource Center
Info USA, American Church List, 2005
29
Public Libraries and Branches
Main Library, 2006 Branch Library, 2006
Indiana Prevention Resource Center
Indiana State Library, 2006
30
Schools
School
Indiana Prevention Resource Center
Indiana Department of Education, 2005
31
Marion County Schools, Alcohol Retail Outlets by
School District
Marion County Alcohol Retail Outlets by Census
Tract
Public School Other School Alcohol Retail
Outlet
32
Marion County Schools, Alcohol Retail Outlets by
School District
Marion County Alcohol Retail Outlets by School
District
Public School Other School Alcohol Retail
Outlet
33
Marion County Schools, Alcohol Retail Outlets by
School District
Marion County Alcohol Retail Outlets by School
District
Public School Other School Alcohol Retail
Outlet
34
Franklin Township School District
Public School Other School Alcohol Retail
Outlet
35
M S D Perry Township School District
Public School Other School Alcohol Retail
Outlet
36
MSD Washington Township Schools
Public School Other School Alcohol Retail
Outlet
37
Indianapolis Public Schools
Public School Other School Alcohol Retail
Outlet
38
Marion County Universities and Alcohol Retail
Outlets
University Alcohol Retail Outlet
Butler
Marion College
Indianapolis Downtown Campus of Ivy Tech
IUPUI
U of Indy
39
1 Mile Radius around Butler University
40
1 Mile around University of Indianapolis
41
1 Mile around Downtown Campus of IVY TECH
42
1 Mile around Marion College
43
1 Mile around IUPUI
44
1 and 2 Miles around IUPUI
45
Jefferson County Profile, 6.9
46
Schools in Proximity to Failed Trip Inspections
Close-up

• Jefferson County

47
Schools in Proximity to Failed Trip Inspections
Close-up
Source ISP, Excise Police, 2007
Grace Baptist School
Shawe Memorial High School
Pope John XXIII School

• Madison, Indiana

48
Vigo County Profile, 6.5
49
Map Meth Lab Busts
Indiana Prevention Resource Center
Source IN State Police, 2007
Total lab busts in 2006, 993
50
Map Meth Lab Busts (prism)
Source IN State Police, 2007
Total lab busts in 2006, 993
Indiana Prevention Resource Center
51
Level 3 Data import analyze

• Equipment
• Geocoding Software
• SPSS
• Data
• Local data
• Public
• Purchased
• Skills (Capacity Building)
• Higher level computer skills
• Higher level statistical skills

52
Software Required
MapInfo, PCensus, Maploader (1)
Mapmarker Geocoding software, Excel Access (2)
SPSS (3)
53
Levels of Data Complexity
Purchased GIS data (1)
Imported data (free or purchased) (2)
More complex imported data (free or purchased) (3)
54
Examples of Data
AGS, Claritas (1)
Program Data, Address Data, Health Data (public
or purchased) (2)
Mortality Report Data Morbidity Data (public or
purchased) (3)
55
Skill Complexity
Basic Computer (1)
Geocoding, Excel and Access (2)
Excel, Access, SPSS (3)
56
Alcohol Retail Outlets Density/Map
Indiana Prevention Resource Center
Indiana Alcohol Tobacco Commission, 2006
57
Property Crime Indices
Bottom Quarter, Mid Range, Top Quarter (includes
over IN over US)
Above US (9), 101.55-194 Above IN (12),
95.55-194 Top Quarter (23), 64-194 Mid Range
(46), 19-64 Lowest Quarter (23), 4-19
AGS, Crime Indices 2004 (2005)
Indiana Prevention Resource Center
58
Using local data and GIS to analyzecounty level
comprehensive tobacco prevention in Indiana
59
Environmental Strategies

• Theoretical bases for environmental approaches to
  prevention
• Describe the elements of a comprehensive tobacco
  prevention program
• Discuss how local data and GIS software can be
  used to evaluate the effectiveness of public
  health efforts
• Analyze morbidity and mortality to determine
  public health impact within the community

60
Indiana Map
Source http//www.in.gov/itpc/Research2.asp?CatID
8
61
Smoking Rates by Region
Source http//www.in.gov/itpc/Research2.asp?CatID
8
62
NC CW Regional Smoking Rates
http//www.in.gov/itpc/Research2.asp?CatID8
63
Smoking Rates by Region
Source http//www.in.gov/itpc/Research2.asp?CatID
8
64
Demographics Education (Source AGS, 2006 est.,
2007)
65
Data frustrates there will be obstacles
http//entertainment.webshots.com/photo/1040516534
015901341MFYhbt
66
Map Education Any College Degree (prism map)
CW
NC
AGS, Core Demographics, 2005 estimates (2006)
67
Demographics Race/Ethnicity (AGS, 2005
est.,2006)
68
Map Race/Ethnicity by County (prism)
AGS, Core Demographics, 2005 estimates (2006)
69
Demographics Income (Source AGS, 2006 est.,
2007)
Text
Text
70
Demographics Income (Source AGS, 2006 est.,
2007)
Text
Text
71
Map Median Family Income (contour map)
NC
CW
AGS, Core Demographics, 2005 estimates (2006)
72
Adult Cigarette Smokers
AGS, Core Demographics, 2003 estimates (2004)
73
Indiana Adult Smoking Rates
http//www.in.gov/itpc/Research2.asp?CatID8
74
Smoking Rates by Region
Source http//www.in.gov/itpc/Research2.asp?CatID
8
75
NC CW Regional Smoking Rates
http//www.in.gov/itpc/Research2.asp?CatID8
76
Bronchitis
CW and CE regions Top 2 counties (CW) 3
of the top 5 counties
Only 20 counties reported deaths from bronchitis.
All reported less than 5 deaths, making the
rates unstable. But by using 2 regions, CWCE
compared to the rest of the state, the results
are more reliable.
Source Indiana State Department of Health,
October 19, 2007
77
Chronic Airway Obstruction
Age-adjusted chronic airway obstruction mortality
rate, 2005
CW and CE regions 3 of the top 4 counties
4 of the top 6 counties 5 of the top 9 (10
of IN counties) 2 more of these 9 border
these regions 7 of the top 9 counties in or
border
Source Indiana State Department of Health,
October 19, 2007
78
Emphysema
Age-adjusted emphysema mortality rate, 2005
CW region Top county by more than 8 points
Source Indiana State Department of Health,
October 19, 2007
79
Malignant Neoplasm of the Trachea, Lung, Bronchus
Age-adjusted lung cancer mortality rate, 2005
CW and CE regions 4 of the top 10 of
counties (9) 4 of the top 6 counties
33.8
31.8
Source Indiana State Department of Health,
October 19, 2007
80
Ischemic Heart Disease
Age-adjusted Ischemic Heart Disease mortality
rate, 2005
33.8
31.8
CW and CE regions Top county in CW 3 of
the top 4 counties in CW 5 of the top 10 in
CW or CE 8 of the top 16 in CW or CE 12
of the top 16 either in or bordering the CW or CE
regions.
Source Indiana State Department of Health,
October 19, 2007
81
Malignant Neoplasm of the Esophagus
Age-adjusted malignant neoplasm of the esophagus
mortality rate, 2005
Malignant Neoplasm of the Esophagus Does not SEEM
REMARKABLE.
Source Indiana State Department of Health,
October 19, 2007
82
CVD
Age-adjusted CVD mortality rate, 2005
33.8
CVD SEEMS NOT REMARKABLE.
Source Indiana State Department of Health,
October 19, 2007
83
Morbidity Data

• Cancer of Trachea, Lung, Bronchus
• Chronic Airway Obstruction
• Bronchitis/Emphysema
• Cancer of the Lip
• Cancer of the Esophagus
• Cancer of the Larynx
• Aortic Aneurysm
• SIDS

Source Indiana State Department of Health,
October 19, 2007
84
Lung Cancer Incidence
25.1
Rank for rate of lung cancer incidence, 2003
25.1
33.8
31.8
CW region rate of lung cancer incidence top
county 2 of the top 5 counties 3 of the
top 7counties NE and NC region 2 lowest
counties (NE) 3 of the 4 lowest counties
4 of the 6 lowest counties
Source Health Service Demand Estimates 2005. 
 Franking, TN  Planning 2.0, 2006. 
85
Lung Cancer Incidence
Perhaps tobacco production is associated with
heavier smoking?
IN State Department of Health, published in
Indiana Cancer Facts Figures, 2006.  American
Cancer Society, Great Lakes Division, Inc., 2006.
86
Cancer of the Trachea, Lung, Bronchus
Rate/100,000 of DRG082 (C33), Cancer, 2005
CW and CE regions 2 of top 3 (CW) 4 of
top 9 counties (CW or CE) 6 of top 11
counties (CW or CE) 8 of top 11 counties (in
or bordering CW or CE)
33.8
31.8
Source Health Service Demand Estimates 2005. 
 Franking, TN  Planning 2.0, 2006. 
87
DRG088 Bronchitis, Emphysema and Chronic Airway
Obstruction
Rate/100,000 of DRG088, 2005
CW and CE regions 3 of top 9 (top 10 of IN
counties) (3 additional counties border CW
or CE) 6 of the top 9 are in or border CW
or CE 11 of top 18 counties (top 20) in CW
or CE
33.8
31.8
Source Health Service Demand Estimates 2005. 
 Franking, TN  Planning 2.0, 2006. 
88
DRG172 Malignant Neoplasm of the Esophagus
Rate/100,000 of DRG172, 2005
33.8
31.8
CW and CE regions 3 of top 9 (top 10 of IN
counties) (3 additional counties border CW
or CE) 6 of the top 9 are in or border CW
or CE 10 of top 18 counties (top 20) in CW
or CE 55.5 of the top 18 counties are in
CW/CE. These 2 regions constitute 26 of IN
counties.
Source Health Service Demand Estimates 2005. 
 Franking, TN  Planning 2.0, 2006. 
89
Elements Used for this Study

• Community Coalition
• Public Education / Marketing
• Cessation Programs
• School Based Programs
• Indoor Air Policies
• Youth Use Law Enforcement
• High Risk Population
• Funding Level

90
Guiding Principles

• Is it comprehensive?
• Is it well funded?
• Is it sustainable over time?
• Does it operate free of the tobacco industry?
• Does it address high risk populations?

91
Regional Findings
http//www.in.gov/itpc/Research2.asp?CatID8
92
Tobacco Coalition Strength
http//www.in.gov/itpc/Research2.asp?CatID8
93
What You Have Learned

• Components of GIS system
• How GIS Helps with Strategic Planning
• Demographics
• Assessment Needs and Resources
• Relationship Identification (where/who)
• Decision-Making
• Cultural Competency
• Obtain Funding
• How GIS Can Help You with Program Evaluation
• Surveillance System
• Track Change over Time and Space

94
Dont let the task get you down.
http//entertainment.webshots.com/photo/1041702014
015901341TIYRAl
95
Without data you wont get far.
http//entertainment.webshots.com/photo/1040516516
015901341VzRwAP
96
Thank You !

• Indiana Prevention Resource Center
• 501 N. Morton, Suite110
• Bloomington, IN 47404
• Phone [phone]
• Fax [phone]
• E-mail drugprc_at_indiana.edu
• WWW http//www.drugs.indiana.edu
• A special thanks to Jennifer Kelley, MPH,
  Mikyung Jun, PhD, Aaron Jones, MPH, and Erika
  Pitcher for their assistance.