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

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