<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=utf-8"><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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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;}
/* 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:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Times New Roman",serif;
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:930702838;
mso-list-type:hybrid;
mso-list-template-ids:-1173950548 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:2033267253;
mso-list-template-ids:-1398345604;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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>I see some great material for presentations at next year’s SHRUG GIS Workshop!!! Just saying. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><b><i><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'>Tripp Corbin, MCP, GISP</span></i></b><b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'> </span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'>| Chief Executive Officer</span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D'><br></span><b><span style='font-size:18.0pt;font-family:"Times New Roman",serif;color:#2F5496'><a href="http://www.egisassociates.com/"><span style='font-family:"Calibri",sans-serif;color:#2F5496'>eGIS Associates, Inc.</span></a></span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#4472C4'><a href="mailto:tcorbin@egisassociates.com"><span style='font-family:"Calibri",sans-serif;color:#4472C4'>tcorbin@egisassociates.com</span></a></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'> | </span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#4472C4'><a href="www.egisassociates.com"><span style='font-family:"Calibri",sans-serif;color:#4472C4'>www.egisassociates.com</span></a></span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'>678-710-9710 ext 0021 | </span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'>678-672-8970 Direct Dial</span><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'>Esri Certified Desktop Professional | Esri Certified Enterprise System Design Associate<o:p></o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0><tr><td style='padding:3.75pt 3.75pt 3.75pt 3.75pt'><p class=MsoNormal><o:p> </o:p></p></td><td style='padding:3.75pt 3.75pt 3.75pt 3.75pt'><p class=MsoNormal><o:p> </o:p></p></td><td style='padding:3.75pt 3.75pt 3.75pt 3.75pt'><p class=MsoNormal><o:p> </o:p></p></td><td style='padding:3.75pt 3.75pt 3.75pt 3.75pt'><p class=MsoNormal><o:p> </o:p></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'>Order my new </span><b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#4472C4'><a href="https://www.packtpub.com/application-development/arcgis-pro-2x-cookbook"><span style='font-family:"Calibri",sans-serif;color:#4472C4'>ArcGIS Pro Cookbook</span></a></span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'> now & don’t forget about </span><b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:#4472C4'><a href="https://www.packtpub.com/application-development/learning-arcgis-pro"><span style='font-family:"Calibri",sans-serif;color:#4472C4'>Learning ArcGIS Pro</span></a></span></b><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'><o:p> </o:p></span></p><table class=MsoTableGrid border=0 cellspacing=0 cellpadding=0 style='border-collapse:collapse;border:none'><tr><td width=187 valign=top style='width:1.95in;padding:0in 5.4pt 0in 5.4pt'><p class=MsoNormal><a href="https://https/www.packtpub.com/application-development/arcgis-pro-2x-cookbook"><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black;text-decoration:none'><img border=0 width=160 height=197 style='width:1.6666in;height:2.052in' id="Picture_x0020_1" src="cid:image003.jpg@01D4865A.1CC506C0"></span></a><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'><o:p></o:p></span></p></td><td width=162 valign=top style='width:121.5pt;padding:0in 5.4pt 0in 5.4pt'><p class=MsoNormal><a href="https://www.packtpub.com/application-development/learning-arcgis-pro"><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black;text-decoration:none'><img border=0 width=161 height=198 style='width:1.677in;height:2.0625in' id="Picture_x0020_2" src="cid:image004.jpg@01D4865A.1CC506C0"></span></a><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'><o:p></o:p></span></p></td></tr></table><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman",serif;color:black'><o:p> </o:p></span></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 <shrug-l-bounces@lists.dep.state.fl.us> <b>On Behalf Of </b>Christopher Smith<br><b>Sent:</b> Tuesday, November 27, 2018 1:50 PM<br><b>To:</b> 'Duane Treadon' <duanet@thomasville.org>; 'SHRUG-L@lists.dep.state.fl.us' <SHRUG-L@lists.dep.state.fl.us><br><b>Subject:</b> Re: 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><p class=MsoNormal>My approach for the street lighting would be to:<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><ul style='margin-top:0in' type=disc><li class=MsoNormal style='text-align:justify;mso-list:l0 level1 lfo3'>Determine the radius of light that would define lighted vs. non-lighted (ask the electric department how they calculate optimal light pole distribution).<o:p></o:p></li><li class=MsoNormal style='text-align:justify;mso-list:l0 level1 lfo3'>Generate buffer polygons for the streetlight points based on that radius value.<o:p></o:p></li><li class=MsoNormal style='text-align:justify;mso-list:l0 level1 lfo3'>Merge all of your buffers into one polygon layer.<o:p></o:p></li><li class=MsoNormal style='text-align:justify;mso-list:l0 level1 lfo3'>Overlay crime data points (hopefully they’re not block level.)<o:p></o:p></li><li class=MsoNormal style='text-align:justify;mso-list:l0 level1 lfo3'>Select points “Within” the buffer layer.<o:p></o:p></li><li class=MsoNormal style='text-align:justify;mso-list:l0 level1 lfo3'>Do the math:<o:p></o:p></li></ul><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal style='text-indent:.25in'># Within + # Outside = Total Points<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal style='text-indent:.25in'># Within/Total Points = % Within<o:p></o:p></p><p class=MsoNormal style='text-indent:.25in'># Outside/Total Points = % Outside<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>The difference in % Within vs. % Outside should imply a straight-forward factor in the presence of streetlights related to crime occurrences. However, this contains a lot of subjective factors and there is also a component as to what type of crime is being committed. DUI vs. Drug solicitation vs. Domestic Violence could result in a very different breakdown and have little or no correlation with street lights.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>Housing: I would determine a threshold distance for dilapidated housing similarly to the lighting scenario. The Florida Housing Finance Corporation uses 10<sup>th</sup> mile radius values for favorability scoring with respect to walking distance. The threshold (highest favorability) is 0.20 Mi. or less so you might want to start with that. I would set up the analysis the same as above and buffer the footprints if you have them or parcels if you’re working in an area that has good lot-block uniformity.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>For the fire calls: I’d generate heat maps for each point dataset and calculate the difference between the two rasters (where less difference would equal more correlation). There’ll probably be a lot parameter tweaking though.<o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal>I think the first two can be performed with just a basic ArcGIS license and then Spatial Analyst Difference tool for the last.<o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal><span style='color:#1F497D'> </span><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 <<a href="mailto:shrug-l-bounces@lists.dep.state.fl.us">shrug-l-bounces@lists.dep.state.fl.us</a>> <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' <<a href="mailto:SHRUG-L@lists.dep.state.fl.us">SHRUG-L@lists.dep.state.fl.us</a>><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><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'>Hi all,</span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></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.</span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></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. </span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></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? </span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></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. </span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'>Thanks for any info you can provide. </span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></p><p class=MsoNormal><u><span style='font-size:16.0pt;font-family:"Times New Roman",serif;color:black'>Duane 'JT' Treadon, GISP</span></u><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'>Director of Geographic Information Systems | City of Thomasville | Information Technology</span><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'>Office: (229) 227-4023 | Cell: (229) 221-5991 </span><o:p></o:p></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 </span><o:p></o:p></p><p class=MsoNormal><i><span style='font-family:"Times New Roman",serif;color:black'>The Power of Community. The Power of Service. </span></i><o:p></o:p></p><p class=MsoNormal><span style='font-family:"Times New Roman",serif;color:black'> </span><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" align=center></div><p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial",sans-serif;color:gray'>CONFIDENTIALITY NOTICE: The information contained in this E-mail message is attorney privileged and confidential information intended only for the use of the individual(s) named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copy of this communication is strictly prohibited. If you have received this communication in error, please contact the sender by reply E-mail and destroy all copies of the original message. Thank you.</span><o:p></o:p></p></div></body></html>