I am working with GPS data and so I have UTM's with DATE/Time information. I have 2 groups of species (moose and wolves). I want to join the information from moose to wolves that match in time. So, location 1 from moose 1 was at 2007-03-26 14:33:49 to all wolves that were recorded at approximately the same time. Approximately is key - it means I will have to have a time window or buffer to look for all wolf locations that were within 30 minute buffer around that time.
I'm looking for a script or tool that will set a window buffer +/-X min and will be able to "batch" process. Ive at least 30 moose and 30 wolves - so doing the matching one pair at a time is not helpful. Once Ive got the date/time matched, I then want to calculate the distance between the XY locations of moose and wolf and the difference in time. I would like an output like:
individualmooseID | mooseDate | mooseX | mooseY | individualwolfID | wolfDate | wolfX | wolfY | Distance(m) | TimeDiff (min)
The mooseID may match up to several DIFFERENT wolfIDs for the same time period. Any suggestions would be appreciated. I have written a code for R but it is not working see my question: https://stackoverflow.com/q/15646365/675742 and I will have to bring the data into ArcGIS at some point so if I can skip R and do it all in ArcGIS then GREAT!