Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I would like to create an iterated interpolation tool through ModelBuilder. I have an excel file containing different columns and each column represents a data that will be interpolated using Spline Tool. How can I do this through ModelBuilder? I am using ArcGIS 10.

enter image description here

Image contains point data with lat/long and sample# are the columns to be interpolated.

share|improve this question
    
Can you edit your Question to include a few rows from your CSV file and let us know how their columns relate to each iteration of Spline, please? –  PolyGeo Apr 8 at 7:28

1 Answer 1

up vote 2 down vote accepted

The following model will achieve what you require:

Iterate over fields

  • Your screen shot shows fields SAMPLE 1 to 9 so set the For iterator to this.
  • Convert your lat/long into an event layer which feeds into the Spline tool. Note the use of in-line substitution to create the field name that will be the Z field. The same is used to create unique output raster names.
share|improve this answer
    
Hi, Hornbydd: May I know where is the connecting arrow between "FOR" and "Sheet1$ event"? –  user2543 Apr 12 at 8:50
    
There is no connection, the iterator controls the whole model and is generating a variable called value which you use inline substitution to make use of it. –  Hornbydd Apr 12 at 12:32
    
Hi, Hornbydd: I tried the model you posted and I got similar range of values from SAMPLE1.tif to SAMPLE9.tif. I am not sure what went wrong. –  user2543 Apr 14 at 8:01
    
Did you ensure you Z value field was set to: SAMPLE%Value% –  Hornbydd Apr 14 at 8:42
    
thank you. i went back to your model and it worked! –  user2543 May 7 at 2:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.