topic Re: Put Raster Properties into table in Python Questions

Put Raster Properties into table

JannWendt — Fri, 05 Oct 2012 12:12:35 GMT

Hi,

maybe someone is able to help me with my problem (I'm new to python :)):

I try to get some raster data into a table with a python script but I get the following error:

Traceback (most recent call last):
File "C:/Users/Jann/Dropbox/EGEOS/BÃ¼ro/2012/Projekte/Georeferenzierung in Attributtabelle/Online.py", line 21, in <module>
row.top = arcpy.GetRasterProperties_management(raster, "top")
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__
return setattr(self._arc_object, attr, ao)
ValueError: Row: Invalid input value for setting

My script looks like this:

import arcpy
from arcpy import env
env.workspace = "E:/Data/X-005"

# Create table
if arcpy.Exists("E:/Data/X-005/Test.dbf"):
arcpy.Delete_management("E:/Data/X-005/Test.dbf")

table = arcpy.CreateTable_management("E:/Data/X-005", "Test.dbf")

# Add fields
arcpy.AddField_management(table, "name", "TEXT")
arcpy.AddField_management(table, "top", "TEXT")

# Insert values
rows = arcpy.InsertCursor("E:/Data/X-005/Test.dbf")
rasters = arcpy.ListRasters()

for raster in rasters:
row = rows.newRow()
row.top = arcpy.GetRasterProperties_management(raster, "top")
row.name = raster

rows.insertRow(row)

# Delete cursor and row objects ro remove locks on the data
#
del row
del rows

Maybe someone can give me some tipps.

Best regards,
Jann

Re: Put Raster Properties into table

JakeSkinner — Fri, 05 Oct 2012 17:39:01 GMT

Hi Jann,

Change the following line:

row.top = arcpy.GetRasterProperties_management(raster, "top")

to:

row.top = str(arcpy.GetRasterProperties_management(raster, "top"))

Re: Put Raster Properties into table

curtvprice — Sun, 12 Dec 2021 08:19:29 GMT

row.top = str(arcpy.GetRasterProperties_management(raster, "top"))

Thanks, Jake, I learned something new today. If you str() a result object, you'll get a string representation of its the result's value. If you know this is a single value and what type it is, this does make for a simple way to get the value:

>>> r = arcpy.GetRasterProperties_management("cdl20091.tif","top") # result object
>>> r
<Result '3173073.79641599'>
>>> r.getOutput(0)  # result object output 
u'3173073.79641599'
>>> str(r) # returns string rep of result output
'3173073.79641599'
>>> float(str(r)) # convert to float
3173073.79641599

Re: Put Raster Properties into table

JannWendt — Tue, 09 Oct 2012 17:07:48 GMT

Thank you both! JSkinn3 for the right way and curtvprice for the explanation 🙂

Re: Put Raster Properties into table

JannWendt — Sat, 27 Oct 2012 14:05:14 GMT

Okay now Ive an additional question which makes it a little bit more complicated... 😄

With the code above it is possible to get the information about the georeference of rasters in one folder into a .dbf file. My problem is that my folder structure is a little bit different. The rasters are distributed in subfolders. Does anybody has an idea how to get the information of all raster of the subfolders together in one .dbf instead of doing it for each folder individually?

Thanks for your help!

Re: Put Raster Properties into table

RaphaelR — Sun, 12 Dec 2021 08:19:31 GMT

you can get a list with the tif-rasters from different subfolders with os.walk:

import os

path = "e:\\test\\"
rasters = []

for path,dirs,files in os.walk(path):
    
    for file in files:
        if file.endswith(".tif") == True:
            rasters.append(str(path) + "\\" + str(file))

Re: Put Raster Properties into table

JannWendt — Mon, 29 Oct 2012 12:36:56 GMT

This works well but I don't know how to put the this together with the raster information script. As I've written before, I'm more or less completely knew to python...

Re: Put Raster Properties into table

RaphaelR — Sun, 12 Dec 2021 08:19:34 GMT

import os
import arcpy
from arcpy import env
env.workspace = "E:/Data/X-005"

# Create table
if arcpy.Exists("E:/Data/X-005/Test.dbf"):
    arcpy.Delete_management("E:/Data/X-005/Test.dbf")

    table = arcpy.CreateTable_management("E:/Data/X-005", "Test.dbf")

# Add fields
arcpy.AddField_management(table, "name", "TEXT")
arcpy.AddField_management(table, "top", "TEXT")

# Insert values
rows = arcpy.InsertCursor("E:/Data/X-005/Test.dbf")

# get rasters
path = "e:\\test"
rasters = []

for path,dirs,files in os.walk(path):
    
    for file in files:
        if file.endswith(".tif") == True:            
            rasters.append(str(path) + "\\" + str(file))


for raster in rasters:
    row = rows.newRow()
    row.top = arcpy.GetRasterProperties_management(raster, "top")
    row.name = raster
    
    rows.insertRow(row)

# Delete cursor and row objects ro remove locks on the data
#
del row
del rows

Re: Put Raster Properties into table

JannWendt — Sun, 12 Dec 2021 08:19:37 GMT

Hi rafaelr,

thanks for your support. Now I get the following problem when I run the script:

Traceback (most recent call last):
  File "W:\Organisation\10013 Aktualisierung der Luftbilddatenbank in Bezug auf Georeferenzierung\Daten\georeference_in_attribute_table_new.py", line 31, in <module>
    row.top = arcpy.GetRasterProperties_management(raster, "top")
  File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__
    return setattr(self._arc_object, attr, ao)
ValueError: Row: Invalid input value for setting

Here is the script I'm using:

import os
import arcpy
from arcpy import env
env.workspace = "C:/Data"

# Create table
if arcpy.Exists("C:/Data/Test.dbf"):
    arcpy.Delete_management("C:/Data/Test.dbf")

table = arcpy.CreateTable_management("C:/Data", "Test.dbf")

# Add fields
arcpy.AddField_management(table, "name", "TEXT")
arcpy.AddField_management(table, "top", "TEXT")

# Insert values
rows = arcpy.InsertCursor("C:/Data/Test.dbf")

# get rasters
path = "C:/data"
rasters = []

for path,dirs,files in os.walk(path):
    
    for file in files:
        if file.endswith(".ecw") == True:            
            rasters.append(str(path) + "/" + str(file))

for raster in rasters:
    row = rows.newRow()
    row.top = arcpy.GetRasterProperties_management(raster, "top")
    row.name = raster
    
    rows.insertRow(row)

# Delete cursor and row objects ro remove locks on the data
#
del row
del rows

Do you (or anybody else) have an idea what to do?

Thanks!
Jann

Re: Put Raster Properties into table

curtvprice — Sun, 12 Dec 2021 08:19:39 GMT

Now I get the following problem when I run the script:

Traceback (most recent call last):
  File "W:\Organisation\10013 Aktualisierung der Luftbilddatenbank in Bezug auf Georeferenzierung\Daten\georeference_in_attribute_table_new.py", line 31, in <module>
    row.top = arcpy.GetRasterProperties_management(raster, "top")
  File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__
    return setattr(self._arc_object, attr, ao)
ValueError: Row: Invalid input value for setting

GetRasterProperties returns a result object. See the [post=238595]top of this thread[/post] for how to convert that into a value you can write to a field.