[GIS] Clipping Single Raster with Multiple Polygons in ArcGIS ModelBuilder

arcgis-10.2arcgis-desktopmodelbuilder

I am quite new to using iterators, and ModelBuilder in general. I have a .tiff format raster (not a feature class) and I would like to clip it with 18 polygon shapefiles which are spatially present within the raster extent.

I looked at some other model formulas, such as Batch Clip in ModelBuilder of ArcGIS for Desktop?

But, I just can't seem to get it working in ArcGIS 10.2.

Any ideas how I can set up a model which would automate this process and export 18 unique clipped rasters?

I have edited below and added the final correct model.

Best Answer

Playing off of your current model something like this should work.

As @Hornbydd mentioned using inline substitution in the clip output will allow you to create unique output names so your output isn't overwritten each time. Also make sure you use the Clip (Data Management) tool for the raster clip.

Related Solutions

[GIS] How to clip multiple raster datasets with county polygons

Presumably since you want to automate this, you'll want each raster to figure out which polygon should be used to clip itself? Pseudo code:

iterate through the list of list of input rasters
convert the raster to a polygon
obtain the polygon's centroid
determine which county polygon the centroid (and therefore the raster) falls within
convert that polygon to a County raster, with a value of 1 (and everything else 0 or NULL)
multiply the county raster with the original raster

[GIS] Exporting data from DBF to Excel template using ModelBuilder

In python it's possible. I have done something similar.

This tutorial was very helpful for me: basic-excel-driving-with-python

With this, you can open an existing excel file and add/change values to whatever you want.

Once you have setup a python script that works for you, you can change it for reading parameters so you can add it as a script in ArcToolbox. Then you can call it in ModelBuilder.

Some code that can help you, basically it export to excel an attribute table:

import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Add()
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Add()

#Fields List
desc=arcpy.Describe(LayerToExport)
Fields=[]
for Fi in desc.fields:
    if Fi.type != "Blob" and Fi.type != "Geometry": 
        Fields.append(Fi.Name)

iFi = 1
for Fi in Fields:
    excel.ActiveSheet.Cells(1,iFi).Value = Fi
    iFi+=1

#Each row
rows = arcpy.SearchCursor(LayerToExport) 
iRow=2
for row in rows:
    iFi = 1
    for Fi in Fields:
        excel.ActiveSheet.Cells(iRow,iFi).Value = row.getValue(Fi)
        iFi+=1
    iRow+=1

# Clean up cursor and row objects
del row
del rows
wb.SaveAs(outFile)          
wb.Close(False)

Note: As this use win32com, VBA function are supported. So it's possible you can use your "TransferSpreadsheet" function.

Best Answer

Related Solutions

[GIS] How to clip multiple raster datasets with county polygons

[GIS] Exporting data from DBF to Excel template using ModelBuilder

Related Question