topic Advanced Accident Hot Spot Identification In 9.3 in Transportation Questions https://community.esri.com/t5/transportation-questions/advanced-accident-hot-spot-identification-in-9-3/m-p/577697#M1906 <HTML><HEAD></HEAD><BODY><SPAN>Hi.</SPAN><BR /><BR /><SPAN>Firs time post on here.</SPAN><BR /><BR /><SPAN>I am having trouble working out a way to identify accident hot spots on our network that meet the specifications of my company.</SPAN><BR /><BR /><SPAN>The calculation that my company uses to work out hot spots is as follows:</SPAN><BR /><BR /><STRONG>&gt;=9 accidents within a 100m radius over 3 years</STRONG><BR /><BR /><SPAN>Is there a way that I can achieve this, using standard tools found in the ArcToolbox?</SPAN><BR /><BR /><SPAN>My initial thoughts are using one (or a combination) of the below:</SPAN><BR /><BR /><UL><BR /><LI>Buffer</LI><BR /><LI>Dissolve</LI><BR /><LI>Collect Events</LI><BR /><LI>Integrate</LI><BR /></UL><BR /><SPAN>Can someone point me in the right direction?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /><SPAN>Dan.</SPAN></BODY></HTML> Mon, 08 Aug 2011 11:26:21 GMT DanielHitchcock 2011-08-08T11:26:21Z Advanced Accident Hot Spot Identification In 9.3 https://community.esri.com/t5/transportation-questions/advanced-accident-hot-spot-identification-in-9-3/m-p/577697#M1906 <HTML><HEAD></HEAD><BODY><SPAN>Hi.</SPAN><BR /><BR /><SPAN>Firs time post on here.</SPAN><BR /><BR /><SPAN>I am having trouble working out a way to identify accident hot spots on our network that meet the specifications of my company.</SPAN><BR /><BR /><SPAN>The calculation that my company uses to work out hot spots is as follows:</SPAN><BR /><BR /><STRONG>&gt;=9 accidents within a 100m radius over 3 years</STRONG><BR /><BR /><SPAN>Is there a way that I can achieve this, using standard tools found in the ArcToolbox?</SPAN><BR /><BR /><SPAN>My initial thoughts are using one (or a combination) of the below:</SPAN><BR /><BR /><UL><BR /><LI>Buffer</LI><BR /><LI>Dissolve</LI><BR /><LI>Collect Events</LI><BR /><LI>Integrate</LI><BR /></UL><BR /><SPAN>Can someone point me in the right direction?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /><SPAN>Dan.</SPAN></BODY></HTML> Mon, 08 Aug 2011 11:26:21 GMT https://community.esri.com/t5/transportation-questions/advanced-accident-hot-spot-identification-in-9-3/m-p/577697#M1906 DanielHitchcock 2011-08-08T11:26:21Z Re: Advanced Accident Hot Spot Identification In 9.3 https://community.esri.com/t5/transportation-questions/advanced-accident-hot-spot-identification-in-9-3/m-p/577698#M1907 <HTML><HEAD></HEAD><BODY><SPAN>You can use the Network Analyst solver OD Cost matrix to load all you accidents as origins and destinations. Then bring up the properties of the OD layer and set a cutoff of 100 meters (assuming you have a length impedance attribute in meters) and turn off hierarchy if it is on. Then solve.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>The output lines table will have a list of distances between each accident. There is a DestinationRank field that shows how many destinations were found for each Origin. You can select rows based on DestinationRank &gt; 8 and then use this to further qualify if they happen to be within your time frame.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Hint: Add a date field to the Origins/Destination attribute tables and then at LoadLocations time map the date/time to this date field so that you have access to this information after your solve.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Jay Sandhu</SPAN></BODY></HTML> Wed, 10 Aug 2011 15:34:41 GMT https://community.esri.com/t5/transportation-questions/advanced-accident-hot-spot-identification-in-9-3/m-p/577698#M1907 JaySandhu 2011-08-10T15:34:41Z