The potential of geographic information systems gis to facilitate data driven prevention
This presentation is the property of its rightful owner.
Sponsored Links
1 / 96

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


  • 40 Views
  • Uploaded on
  • Presentation posted in: General

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!.

Download Presentation

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

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


Gis system levels of complexity

GIS System: Levels of Complexity

www.drugs.indiana.edu


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


Adults without a high school diploma

Adults without a High School Diploma

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


Lake county less than high school diploma

Lake County – Less Than High School Diploma

Source: AGS, 2007 estimates


The potential of geographic information systems gis to facilitate data driven prevention

Lake County – Less Than High School Diploma

Source: AGS, 2007 estimates


The potential of geographic information systems gis to facilitate data driven prevention

Lake County – Less Than High School Diploma

Source: AGS, 2007 estimates

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


The potential of geographic information systems gis to facilitate data driven prevention

Lake County – Less Than High School Diploma


Family conflict divorce

Family Conflict: Divorce


The potential of geographic information systems gis to facilitate data driven prevention

Lake County – Divorce Rate

Source: AGS, 2007 estimates


The potential of geographic information systems gis to facilitate data driven prevention

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 radius around butler university

1 Mile Radius around Butler University

www.drugs.indiana.edu


1 mile around university of indianapolis

1 Mile around University of Indianapolis

www.drugs.indiana.edu


1 mile around downtown campus of ivy tech

1 Mile around Downtown Campus of IVY TECH

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 up

Tobacco Outlets That Failed TRIP Inspections in 2006

Children at School

Schools in Proximity to Failed Trip Inspections – Close-up

Jefferson County


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


Demographics education source ags 2006 est 2007

Demographics: Education (Source: AGS, 2006 est., 2007)

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


Demographics race ethnicity ags 2005 est 2006

Demographics: Race/Ethnicity (AGS, 2005 est.,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


Demographics income source ags 2006 est 2007

Demographics: Income (Source: AGS, 2006 est., 2007)

Text

Text

www.drugs.indiana.edu


Demographics income source ags 2006 est 20071

Demographics: Income (Source: AGS, 2006 est., 2007)

Text

Text

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


The potential of geographic information systems gis to facilitate data driven prevention

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


The potential of geographic information systems gis to facilitate data driven prevention

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.


  • Login