shrug-l: Been a while since I've done this...

[Teaf, Daniel]

Duane,

You need to go to your "observed" vs "expected" and r2 values etc.  Excel actually has a pretty good stats module that can help.
Thank you

Daniel Teaf, GISP, Technical GIS Project Mgr
Florida Department of Transportation
Office of Information Technology
Office: (850) 410-5468
DotNet Number: 880-5468
*Please be aware e-mails to and from FL DOT are subject to public records requests

[SNAGHTML5d37f6a]

How am I doing? Please contact my supervisor, John Mallette, at John.Mallette at dot.state.fl.us with any feedback

From: SHRUG-L [mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Duane Treadon
Sent: Tuesday, November 27, 2018 9:49 AM
To: 'SHRUG-L at lists.dep.state.fl.us' <SHRUG-L at lists.dep.state.fl.us>
Subject: shrug-l: Been a while since I've done this...


EXTERNAL SENDER: Use caution with links and attachments.

Hi all,

I need a little help shaking the cob webs out of my brain on how to set up an analysis process to look at correlation.  My Chief has asked me to look at crime and see if there is any relationship between it and dilapidated housing and also look at street lighting.  I am lucky in that I have access to all the data needed and it is easy to extract, geocode, and add to our geodatabase for use in ArcMap or ArcPro .  We have crime data for the past several years, our Building Dept. keeps a good record on housing conditions throughout the city, and the Electric Dept. has all street lights mapped out in our GIS already.  I have ArcAdvance and access to all the spatial analysis extensions and tools available as well as ArcPro and its tools/workflows.

What I need help on is deciding what tools to use and how to interpret the results.  My thought is to look at each element as it relates to crime.  Look at crime and dilapidated housing and how it falls on the map. Then crime and street lights in the same way.  Then bring it all together to see if there is a stronger pattern with all three elements.

So what tools should I use?  Any publications or exercises out there that explain the processing of data to determine if there is a correlation.  Any pdfs you can share that explain the tools in ArcMap that I should use.  Are ESRI products not the way to go?  Is there an easier solution for looking at the data?

p.s. as a follow up my Fire Chief would like me to look and see if there is an increase in fire calls that follows the crime.

Thanks for any info you can provide.


Duane 'JT' Treadon, GISP
Director of Geographic Information Systems | City of Thomasville | Information Technology
Office: (229) 227-4023 | Cell: (229) 221-5991
111 Victoria Place | P.O. Box 1540 | Thomasville, GA | 31799
The Power of Community. The Power of Service.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20181127/35801856/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10593 bytes
Desc: image001.png
URL: <http://lists.dep.state.fl.us/pipermail/shrug-l/attachments/20181127/35801856/attachment.png>