the potential of geographic information systems gis to facilitate data driven prevention
Download
Skip this Video
Download Presentation
The Potential of Geographic Information Systems (GIS) to Facilitate Data-Driven Prevention

Loading in 2 Seconds...

play fullscreen
1 / 96

The Potential of Geographic Information Systems (GIS) to Facilitate Data-Driven Prevention - PowerPoint PPT Presentation


  • 64 Views
  • Uploaded on

The Potential of Geographic Information Systems (GIS) to Facilitate Data-Driven Prevention. Barbara Seitz de Martinez, PhD, MLS, CPP Desiree Goetze, MPH, CHES, CPP Kaigang Li www.drugs.indiana.edu. Partnerships to Facilitate Prevention and Recovery: Transformation Where It Counts!.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'The Potential of Geographic Information Systems (GIS) to Facilitate Data-Driven Prevention' - yachi


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
the potential of geographic information systems gis to facilitate data driven prevention

The Potential of Geographic Information Systems (GIS) to Facilitate Data-Driven Prevention

Barbara Seitz de Martinez, PhD, MLS, CPP

Desiree Goetze, MPH, CHES, CPP

Kaigang Li

www.drugs.indiana.edu

Partnerships to Facilitate

Prevention and Recovery:

Transformation Where

It Counts!

what you will learn
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

www.drugs.indiana.edu

data what is it
Data… What is it?

It’s up to you!

http://skywalker.cochise.edu/wellerr/rocks/sdrx/limestoneL.htm

www.breitbart.com/article.php?id=070312165704.qtgd3817&show_article

=1&cat=us&image=large

www.drugs.indiana.edu

use it to enhance quality of life
Use it to enhance quality of life

It’s what you make of it!

Limestone detail, IU

http://www.indexstock.com/content/

artists/Rich%20Remsberg.asp

House of Parliament, London, England

http://www.bluffton.edu/~sullivanm/england/london/parliament/frmriver.jpg

www.drugs.indiana.edu

data driven prevention but you drive
Data-driven prevention…but you drive

It’s up to you!

Little 500 Bike Race, IU

http://newsinfo.iu.edu/asset/

page/normal/1450.html

www.drugs.indiana.edu

components of a gis system

Components of a GIS System

Minimal Equipment and

Personnel Skill Requirements

level 1 extract data
Level 1 – Extract Data

Equipment: Hardware and Software

Data: Purchased Databases

www.tetrad.com

Kinds of Skills (Capacity Building)

Basic Computer

And Printer

(1)

MapInfo,

PCensus,

Maploader

(1)

Purchased

GIS data

(1)

Basic Computer

Skills

(1)

www.drugs.indiana.edu

level 1 extract data1
Level 1 – Extract Data

MapInfo,

PCensus,

Maploader

(1)

Purchased

GIS data

(1)

Basic Computer

Skills

(1)

www.drugs.indiana.edu

alcohol spending per household
Alcohol Spending per Household

www.drugs.indiana.edu

data can seem overwhelming
Data can seem overwhelming
  • Too much data can seem overwhelming.

http://entertainment.webshots.com/photo/1041702010015901341YseGEP

www.drugs.indiana.edu

slide15
Lake County – Less Than High School Diploma

Source: AGS, 2007 estimates

Census Tracts: 30300; 30100; 30200; 31000; 20400; 20600; 10202; 10700; 10500; 11300; 41200

slide18
Lake County – Divorce Rate

Source: AGS, 2007 estimates

slide19
Lake County – Divorce Rate

Source: AGS, 2007 estimates

Census Tracts: 20600; 10203; 10202; 10201; 10900; 11300; 11700; 11600;11900; 41600; 12600

level 2 your data maps
Level 2 – Your Data / Maps

Equipment:

  • Geocoding Software
  • Color Printer

Data:

  • Local data
  • Addresses

Skills (Capacity Building)

  • Patience, precision
  • Microsoft Excel, Microsoft Access

www.drugs.indiana.edu

software required

Software Required

MapInfo,

PCensus,

Maploader

(1)

Mapmarker Geocoding software, Excel & Access

(2)

data complexity

Data Complexity

Purchased

GIS data

(1)

Imported data (free or

purchased)

(2)

examples of data

Examples of Data

AGS, Claritas™,

Map files

(1)

Program Data, Address Data, Health Data (public or purchased)

(2)

skills required

Skills Required

Basic Computer

(1)

Geocoding, Excel and Access

(2)

afternoons r o c k in indiana
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

www.drugs.indiana.edu

places of worship
Places of Worship

Places of Worship, 2005

Indiana Prevention Resource Center

Info USA, American Church List, 2005

www.drugs.indiana.edu

youth serving agencies
Youth Serving Agencies

Youth Serving Agencies, 2005

Indiana Prevention Resource Center

Info USA, American Church List, 2005

www.drugs.indiana.edu

public libraries and branches
Public Libraries and Branches

Main Library, 2006

Branch Library, 2006

Indiana Prevention Resource Center

Indiana State Library, 2006

www.drugs.indiana.edu

schools
Schools

School

Indiana Prevention Resource Center

Indiana Department of Education, 2005

www.drugs.indiana.edu

marion county schools alcohol retail outlets by school district
Marion County Schools, Alcohol Retail Outlets by School District

Marion County Alcohol Retail Outlets by Census Tract

Public School

Other School

Alcohol Retail

Outlet

www.drugs.indiana.edu

marion county schools alcohol retail outlets by school district1
Marion County Schools, Alcohol Retail Outlets by School District

Marion County Alcohol Retail Outlets by School District

Public School

Other School

Alcohol Retail

Outlet

www.drugs.indiana.edu

marion county schools alcohol retail outlets by school district2
Marion County Schools, Alcohol Retail Outlets by School District

Marion County Alcohol Retail Outlets by School District

Public School

Other School

Alcohol Retail

Outlet

www.drugs.indiana.edu

franklin township school district
Public School

Other School

Alcohol Retail

Outlet

Franklin Township School District

m s d perry township school district
Public School

Other School

Alcohol Retail

Outlet

M S D Perry Township School District

msd washington township schools
Public School

Other School

Alcohol Retail

Outlet

MSD Washington Township Schools

indianapolis public schools
Public School

Other School

Alcohol Retail

Outlet

Indianapolis Public Schools

marion county universities and alcohol retail outlets
Marion County Universities and Alcohol Retail Outlets

University

Alcohol Retail

Outlet

Butler

Marion College

Indianapolis Downtown Campus of Ivy Tech

IUPUI

U of Indy

www.drugs.indiana.edu

1 mile around marion college
1 Mile around Marion College

www.drugs.indiana.edu

1 mile around iupui
1 Mile around IUPUI

www.drugs.indiana.edu

1 and 2 miles around iupui
1 and 2 Miles around IUPUI

www.drugs.indiana.edu

jefferson county profile 6 9
Jefferson County Profile, 6.9

www.drugs.indiana.edu

schools in proximity to failed trip inspections close up1
Tobacco Outlets That Failed TRIP Inspections in 2006

Children at School

Schools in Proximity to Failed Trip Inspections – Close-up

Madison, Indiana

Source: ISP, Excise Police, 2007

Grace Baptist School

Shawe Memorial High School

Pope John XXIII School

vigo county profile 6 5
Vigo County Profile, 6.5

www.drugs.indiana.edu

map meth lab busts

Map: Meth Lab Busts

Indiana Prevention Resource Center

Source: IN State Police, 2007

Total lab busts in 2006, 993

map meth lab busts prism

Map: Meth Lab Busts (prism)

Source: IN State Police, 2007

Total lab busts in 2006, 993

Indiana Prevention Resource Center

level 3 data import analyze
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

www.drugs.indiana.edu

software required1

Software Required

MapInfo,

PCensus,

Maploader

(1)

Mapmarker Geocoding software, Excel & Access

(2)

SPSS (3)

levels of data complexity

Levels of Data Complexity

Purchased

GIS data

(1)

Imported data (free or

purchased)

(2)

More compleximported data

(free or purchased)

(3)

examples of data1

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)

skill complexity

Skill Complexity

Basic Computer

(1)

Geocoding, Excel and Access

(2)

Excel, Access, SPSS

(3)

alcohol retail outlets density map
Alcohol Retail Outlets – Density/Map

Indiana Prevention Resource Center

Indiana Alcohol Tobacco Commission, 2006

www.drugs.indiana.edu

property crime indices
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

www.drugs.indiana.edu

using local data and gis to analyze county level comprehensive tobacco prevention in indiana

Using local data and GIS to analyzecounty level comprehensive tobacco prevention in Indiana

environmental strategies
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

www.drugs.indiana.edu

indiana map
Indiana Map

Source: http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

smoking rates by region
Smoking Rates by Region

Source: http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

nc cw regional smoking rates
NC & CW Regional Smoking Rates

http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

smoking rates by region1
Smoking Rates by Region

Source: http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

data frustrates there will be obstacles
Data frustrates …there will be obstacles

http://entertainment.webshots.com/photo/1040516534015901341MFYhbt

www.drugs.indiana.edu

map education any college degree prism map
Map: Education: Any College Degree (prism map)

CW

NC

AGS, Core Demographics,

2005 estimates (2006)

www.drugs.indiana.edu

map race ethnicity by county prism
Map: Race/Ethnicity by County (prism)

AGS, Core Demographics,

2005 estimates (2006)

www.drugs.indiana.edu

map median family income contour map
Map: Median Family Income (contour map)

NC

CW

AGS, Core Demographics,

2005 estimates (2006)

www.drugs.indiana.edu

adult cigarette smokers
Adult Cigarette Smokers

AGS, Core Demographics,

2003 estimates (2004)

www.drugs.indiana.edu

indiana adult smoking rates
Indiana Adult Smoking Rates

http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

smoking rates by region2
Smoking Rates by Region

Source: http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

nc cw regional smoking rates1
NC & CW Regional Smoking Rates

http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

bronchitis
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, CW+CE compared to the rest of the state, the results are more reliable.

Source: Indiana State Department of Health, October 19, 2007

www.drugs.indiana.edu

chronic airway obstruction
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

www.drugs.indiana.edu

emphysema
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

www.drugs.indiana.edu

malignant neoplasm of the trachea lung bronchus
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

www.drugs.indiana.edu

ischemic heart disease
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

www.drugs.indiana.edu

malignant neoplasm of the esophagus
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

www.drugs.indiana.edu

slide82
CVD

Age-adjusted CVD mortality rate, 2005

33.8%

CVD SEEMS NOT REMARKABLE.

Source: Indiana State Department of Health, October 19, 2007

www.drugs.indiana.edu

morbidity data
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

www.drugs.indiana.edu

lung cancer incidence
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.

www.drugs.indiana.edu

lung cancer incidence1
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.

www.drugs.indiana.edu

cancer of the trachea lung bronchus
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. 

www.drugs.indiana.edu

drg088 bronchitis emphysema and chronic airway obstruction
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. 

www.drugs.indiana.edu

drg172 malignant neoplasm of the esophagus
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.

www.drugs.indiana.edu

elements used for this study
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

www.drugs.indiana.edu

guiding principles
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?

www.drugs.indiana.edu

regional findings
Regional Findings

http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

tobacco coalition strength
Tobacco Coalition Strength

http://www.in.gov/itpc/Research2.asp?CatID=8

www.drugs.indiana.edu

what you have learned
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

www.drugs.indiana.edu

don t let the task get you down
Don’t let the task get you down.

www.drugs.indiana.edu

http://entertainment.webshots.com/photo/1041702014015901341TIYRAl

without data you won t get far
Without data you won’t get far.

www.drugs.indiana.edu

http://entertainment.webshots.com/photo/1040516516015901341VzRwAP

slide96
Thank You !

Indiana Prevention Resource Center

501 N. Morton, Suite110

Bloomington, IN 47404

Phone: (800) 346-3077

Fax: (812) 855-4940

E-mail: [email protected]

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.

ad