Adding raster from attribute table?

Question

I have a table("ecw") with a field ("raster_path") which contains the paths of many rasters (ecw type) Selecting several rows from the table, I Would like to add the rasters into my dataframe.

How do I do it?

(Sorry if my english is not good; It isn't my native languaje)

Answer 1

Thank's for your answer. I applied your code to my work. but it doesn't works good.The first raster is added correctly,but it is no one of the selected raster in the table. I think the code tries to add all the files. And then, the code show this message: Runtime error Traceback (most recent call last): File "", line 20, in NameError: name 'result' is not defined

Mi code is this:

#get the mxd you're in
mxd = arcpy.mapping.MapDocument("CURRENT")

#get the dataframe
df = mxd.activeDataFrame

#select the records via your query
arcpy.SelectLayerByAttribute_management("CATALUNA_2013", "NEW_SELECTION")

#create a cursor to go through those records
rows = arcpy.SearchCursor("CATALUNA_2013")

#go through the records
for row in rows:
    #get the path
    tablePath = row.getValue("FILENAME")
    #set up the new raster layer
    rasterLayer = arcpy.MakeRasterLayer_management(tablePath, row.NAME)
    #get the output from the in memory layer
    addLayer = result.getOutput(0)
    #insert into the data frame
    arcpy.mapping.AddLayer(df, addLayer, "AUTO_ARRANGE")


del rows

Answer 2

My solution is more arcpy based. I would run this from the interactive window. I left some spots in there for you to add your own information/query/etc. I borrowed some of the raster code from this other post.

#get the mxd you're in
mxd = arcpy.mapping.MapDocument("CURRENT")

#get the dataframe
df = mxd.activeDataFrame

#select the records via your query
arcpy.SelectLayerByAttribute_management("TABLENAME", "NEW_SELECTION", "WHERE QUERY OF SORTS")

#create a cursor to go through those records
rows = arcpy.SearchCursor("TABLENAME")

#go through the records
for row in rows:
    #get the path
    tablePath = row.getValue("raster_path")
    #set up the new raster layer
    rasterLayer = arcpy.MakeRasterLayer_management(tablePath, "NAME FOR THE LAYER")
    #get the output from the in memory layer
    addLayer = rasterLayer.getOutput(0)
    #insert into the data frame
    arcpy.mapping.AddLayer(df, addLayer, "AUTO_ARRANGE")

del rows