Security Incidents vs AID Development programmes

Discussion created by jonathan2709 on Jan 1, 2014
Latest reply on Jan 2, 2014 by bsriramak
Hi Folks,

I am working on some analysis to see if there are any trends between AID projects and Security Incidents within Afghanistan.

I have 2 datasets,

1. 2013 AID projects with GPS coordinates with start dates.
2. 2012 & 2013 Incidents at villages level with dates.

I am trying to do the following queries in ArcGIS

1. Count of violent events prior to the aid being disbursed (say, 90 days before, at 2km2 radius around village)
2. Count of violent events after aid disbursed (say, 90 days after, at 2km2 radius)

Looking at specific projects this isn't a problem, however i have over 900 aid locations with 207 unique dates there identifying the count for all incidents before and after is time consuming.  Also some of the security incidents may actually be within the 2km buffer of 2 or more aid locations.

I don't really want to do this manually but does anyone have any suggestions or tools that i should be using?

Many thanks