<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Calibri Light";
panose-1:2 15 3 2 2 2 4 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Times New Roman",serif;
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Duane,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">You need to go to your “observed” vs “expected” and r<sup>2</sup> values etc. Excel actually has a pretty good stats module that can help.<o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Calibri Light",sans-serif">Thank you<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b>Daniel Teaf, GISP, Technical GIS Project Mgr<o:p></o:p></b></p>
<p class="MsoNormal">Florida Department of Transportation<o:p></o:p></p>
<p class="MsoNormal">Office of Information Technology<o:p></o:p></p>
<p class="MsoNormal">Office: (850) 410-5468 <o:p></o:p></p>
<p class="MsoNormal">DotNet Number: 880-5468<o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.0pt">*Please be aware e-mails to and from FL DOT are subject to public records requests<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D"><img width="117" height="62" style="width:1.2187in;height:.6458in" id="Picture_x0020_1" src="cid:image001.png@01D48639.53C2F310" alt="SNAGHTML5d37f6a"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">How am I doing? Please contact my supervisor, John Mallette, at<span style="color:#1F497D">
</span><span style="color:#2E74B5">John.Mallette@dot.state.fl.us</span> with any feedback<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> SHRUG-L [mailto:shrug-l-bounces@lists.dep.state.fl.us]
<b>On Behalf Of </b>Duane Treadon<br>
<b>Sent:</b> Tuesday, November 27, 2018 9:49 AM<br>
<b>To:</b> 'SHRUG-L@lists.dep.state.fl.us' <SHRUG-L@lists.dep.state.fl.us><br>
<b>Subject:</b> shrug-l: Been a while since I've done this...<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid windowtext 1.0pt;padding:0in 0in 0in 0in">
<p align="center" style="text-align:center;line-height:12.0pt;background:#E0E53F">
<b><span style="font-family:"Cambria",serif;color:black">EXTERNAL SENDER:</span></b><span style="font-family:"Cambria",serif;color:black"> Use caution with links and attachments.<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">Hi all,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">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.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">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? <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">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.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">Thanks for any info you can provide.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><u><span style="font-size:16.0pt;font-family:"Times New Roman",serif;color:black">Duane 'JT' Treadon, GISP<o:p></o:p></span></u></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">Director of Geographic Information Systems | City of Thomasville | Information Technology<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black">Office: (229) 227-4023 | Cell: (229) 221-5991
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-family:"Times New Roman",serif;color:black">111 Victoria Place | P.O. Box 1540 | Thomasville, GA | 31799
<o:p></o:p></span></p>
<p class="MsoNormal"><i><span style="font-family:"Times New Roman",serif;color:black">The Power of Community. The Power of Service.
<o:p></o:p></span></i></p>
<p class="MsoNormal"><span style="font-family:"Times New Roman",serif;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>