960 likes | 1.06k Views
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!.
E N D
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: • 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? 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 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 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 Minimal Equipment and Personnel Skill Requirements
GIS System: Levels of Complexity www.drugs.indiana.edu
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 Data MapInfo, PCensus, Maploader (1) Purchased GIS data (1) Basic Computer Skills (1) www.drugs.indiana.edu
Alcohol Spending per Household www.drugs.indiana.edu
Adults without a High School Diploma www.drugs.indiana.edu
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 Source: AGS, 2007 estimates
Lake County – Less Than High School Diploma Source: AGS, 2007 estimates
Lake County – Less Than High School Diploma Source: AGS, 2007 estimates Census Tracts: 30300; 30100; 30200; 31000; 20400; 20600; 10202; 10700; 10500; 11300; 41200
Lake County – Divorce Rate Source: AGS, 2007 estimates
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 Equipment: • Geocoding Software • Color Printer Data: • Local data • Addresses Skills (Capacity Building) • Patience, precision • Microsoft Excel, Microsoft Access www.drugs.indiana.edu
Software Required MapInfo, PCensus, Maploader (1) Mapmarker Geocoding software, Excel & Access (2)
Data Complexity Purchased GIS data (1) Imported data (free or purchased) (2)
Examples of Data AGS, Claritas™, Map files (1) Program Data, Address Data, Health Data (public or purchased) (2)
Skills Required Basic Computer (1) Geocoding, Excel and Access (2)
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, 2005 Indiana Prevention Resource Center Info USA, American Church List, 2005 www.drugs.indiana.edu
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 Main Library, 2006 Branch Library, 2006 Indiana Prevention Resource Center Indiana State Library, 2006 www.drugs.indiana.edu
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 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 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 District Marion County Alcohol Retail Outlets by School District Public School Other School Alcohol Retail Outlet www.drugs.indiana.edu
Public School Other School Alcohol Retail Outlet Franklin Township School District
Public School Other School Alcohol Retail Outlet M S D Perry Township School District
Public School Other School Alcohol Retail Outlet MSD Washington Township Schools
Public School Other School Alcohol Retail Outlet Indianapolis Public Schools
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 www.drugs.indiana.edu
1 Mile around University of Indianapolis www.drugs.indiana.edu
1 Mile around Downtown Campus of IVY TECH www.drugs.indiana.edu
1 Mile around Marion College www.drugs.indiana.edu
1 Mile around IUPUI www.drugs.indiana.edu
1 and 2 Miles around IUPUI www.drugs.indiana.edu
Jefferson County Profile, 6.9 www.drugs.indiana.edu
Tobacco Outlets That Failed TRIP Inspections in 2006 Children at School Schools in Proximity to Failed Trip Inspections – Close-up Jefferson County
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 www.drugs.indiana.edu
Map: Meth Lab Busts Indiana Prevention Resource Center Source: IN State Police, 2007 Total lab busts in 2006, 993
Map: Meth Lab Busts (prism) Source: IN State Police, 2007 Total lab busts in 2006, 993 Indiana Prevention Resource Center