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.

This seems like it should be a no-brainer, but I am unable to find any info on how to use model builder to run a certain spatial analysis function on each column in a table.

Problem: I have a table to sample locations and at each location there are a series of measures (e.g. temperature, flow rate, number of certain species). For each of those attributes (columns in the table), I was to run the IDW function from the surface tools.

This would be easy if I had each attribute in a separate shp/feature class, but not very efficient. I tried Iterate Feature Selection, but was unable to pass the field name as the Z value in the IDW function.

EDIT: this is for ArcGIS 10.1 (Basic and Spatial Analyst license)

Any help would be greatly appreciated! Thanks!

share|improve this question

2 Answers 2

up vote 3 down vote accepted

I believe you will need to build a small Python script and paste that into your Model. You would use the ArcPy module and build a field list on your layer:

fieldList = arcpy.ListFields("C:/Data/MyGIS.gdb/MyLayer")

and then you would iterate through the fieldList using a for loop, for example

for field in fieldList:
    #run your spatial analysis function on field
share|improve this answer
    
Thanks! The ListFields() is super handy. I took it out of model builder now and am trying to do it all in a Python script. I had figure there would be an iterator for that, but it now gives me a good reason to work with Py. –  Mr.ecos Mar 18 '13 at 21:02
    
This just helped me out with the Global Moran's I tool. Worth adding that the field object in Arc has properties and tools may be after field.name rather than field. They may also throw an error depending on the field.type. –  Oliver Burdekin Jul 24 at 1:24

@nmpeterson I am also trying to do the exact same thing but having a hard time to make it work, can you share how you did it in Py or model builder?

share|improve this answer

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.