Export raster attribute table into CSV using Python automation !

[YamMagar]

Hello,

I am learning python scripting. I am trying to export raster attribute table (integer value) in to .CSV file. I can manually export attribute table into .txt file but would take many hours to export for 100 raster files. I have raster files (about 100) organized in a folder called "temperature". So, how can I write a python script that scan through all raster files and export attribute table of each raster into .CSV file with unique header file.

Thanks.

[XanderBakker · Accepted solution]

Hi Milan,

Try the code below. Edit the following locations:

• ws = this is the input workspace (folder) with all he rasters


• outPath = is the folder where the output CSV files will be written

I have added the raster name as an additional field to the CSV.

import arcpy, os ws = r'C:\Project\_Forums\Viewshed\test.gdb'      # edit this outPath = r'C:\Project\_Forums\Viewshed\testexp2' # edit this outExt = ".csv"  arcpy.env.workspace = ws  rasters = arcpy.ListRasters("*") for raster in rasters:     rasloc = ws + os.sep + raster     fields = "*"     try:         lstFlds = arcpy.ListFields(rasloc)         header = ''         for fld in lstFlds:             header += ",{0}".format(fld.name)          if len(lstFlds) != 0:             outCSV = outPath + os.sep + raster + outExt             f = open(outCSV,'w')             header = header[1:] + ',RasterName\n'             f.write(header)              with arcpy.da.SearchCursor(rasloc, fields) as cursor:                 for row in cursor:                     f.write(str(row).replace("(","").replace(")","") + "," + raster + '\n')             f.close()      except:         print raster + " - is not integer or has no attribute table" del row

Example output CSV file:
OBJECTID,Value,Count,RasterName
1, 0, 1162115.0,Viewshed7
2, 1, 62868.0,Viewshed7

Kind regards,

Xander

[YamMagar]

Dear Xander,

Thank you so much for the code ! It worked in perfect manner :).

[XanderBakker]

Dear Xander,

Thank you so much for the code ! It worked in perfect manner :).

Hi Milan,

I'm glad I could be of any assistance. If you think it was helpful you    can use the "arrow" button in order to help other  members find useful   information:



More info here: http://resources.arcgis.com/en/help/forums-mvp/

Kind regards,

Xander

[JohnWani]

Hi all,

I am new to GIS, I am having large number of raster files(800) in ArcGis and I want to copy the attribute table of each raster file separately to Excel. 

I found your link through stack exchange and i want to use your code to perform the above mentioned task, if you can share the code with me as attachment as i try to run the script shared by you, it displays syntax error.

[RebeccaStrauch__GISP]

I haven't tested Xander Bakker‌ 's code, but here it is formatted (the old forum conversion scrambled some scripts)

import arcpy, os 
ws = r'C:\Project\_Forums\Viewshed\test.gdb'      
# edit this outPath = r'C:\Project\_Forums\Viewshed\testexp2' 
# edit this outExt = ".csv"  
arcpy.env.workspace = ws  
rasters = arcpy.ListRasters("*") 
for raster in rasters:
     rasloc = ws + os.sep + raster
     fields = "*"
     try:
          lstFlds = arcpy.ListFields(rasloc)
          header = ''         
          for fld in lstFlds:
               header += ",{0}".format(fld.name)
               if len(lstFlds) != 0:
                    outCSV = outPath + os.sep + raster + outExt
                    f = open(outCSV,'w')
                    header = header[1:] + ',RasterName\n'
                    f.write(header)
                    with arcpy.da.SearchCursor(rasloc, fields) as cursor:
                         for row in cursor:
                              f.write(str(row).replace("(","").replace(")","") + "," + raster + '\n')
                              f.close()
     except:
          print raster + " - is not integer or has no attribute table" 
del row  ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If you are just getting into ArcGIS, you should look into Python (if you don't already know it) since that is the scripting language many of us use.  Key about python, indentation is very important.  Good luck.

[JohnWani]

Hi all,

The code now works for me but it displays the error message "is not integer or has no attribute table". But all the raster files have the attributes.

Please help

I will share some files with you if required.

Thanks and regards

[JohnWani]

@Rebecca Strauch, thanks a lot for quick response. 

I also corrected Xander's code, it works fine and generates empty .csv files

But the error message 'is not integer or has no attribute table' is displayed.

Thanks again

[RebeccaStrauch__GISP]

I'm not a raster expert, but others here could probably help if you post something upload a sample.

[XanderBakker]

In theory everything that goes wrong inside the try except statements will yield that message. I put this message since in most cases the error would be caused by using a floating raster which does not have an attribute table. 

You could change the last rows where the exception is caught into this to get more details on the error. 

    except Exception as e:
        print(e)
‍‍