I have two sets of data. One comprises all home sales in a given area, where each data 'point' is actually a polygon representing the lot that was sold. The other set comprises arrests made in the same area, where each point also has a date associated with it.
I want to use the IDW tool to tell me roughly how much arrest activity occurred around a given home in the 12 months preceding the sale. I essentially want to go row by row in the house sale data and tell the spatial analyst tool to consider only points from the second dataset from date n to n-365, then interpolate all points within 1000 feet that satisfy this condition. Any ideas?
I believe I can select all the points that meet my date criteria, but I am not sure how to feed that to the IDW tool interactively (iteratively - i.e. a different selection criteria for each data row, because each home sale happened at a unique location on a unique date).