I'm trying to calculate average rainfall value from a number of points using Inverse Weighted Distance tool in ArcGIS 9.3. My problem is that: each point has it own time series, therefore the interpolation process should be able to carry out for all years (kind of iteration so to speak). Following is a sample attribute table:
ID X Y Name Rain1990 Rain1991 Rain1992 Rain1993 .... Rain2010
1 xx1 yy1 AA 1210 1189 1863 1269 ......
2 xx2 yy2 BB 1492 1502 2187 1923 ...... ......
Could anybody show me how to do that. Any suggestion would be much appreciated
Nice weekend every1
Edit 1: I finally did this by using C++ code which required ArcGIS mask grid, data files & locations of all the points. If someone needs the code, contact me and I'd love to share!
Edit 2: I recently used R to do this interpolation task. You can use either hydroTSM, gstat or spacetime packages. Few example links below: http://spatial-analyst.net/wiki/index.php?title=Spatial_interpolation_exercises_%28NL%29 http://www.geostat-course.org/Topic_Bivand_2012