Automate the export of rasters from a geodatabase raster catalog

Summary

GIS managers and administrators sometimes need to automate the process of exporting rasters from geodatabase raster catalogs to raster datasets on disk. Instructions provided describe how to do this.

Procedure

workspace = r"Database Connections\lclinton2_SQL08_R2.sde\sde101.SDE.Prasanta"
outras = r"C:\Data\outrasters"

Code:
import arcpy, os, string

def ExtractRasterFromRC(workspace,outras):
    
    count = arcpy.GetCount_management(workspace)
    str_cnt = str(count)
    int_cnt = int(str_cnt)
      
    cnt = 1
    while cnt <= int_cnt:
        raster = workspace + os.sep + "Raster.OBJECTID=" + str(cnt)
        name = "tiff_" + str(cnt) + ".tif"
        name_out = outras + os.sep + name
        print ("Reading {0}".format(raster))
        arcpy.CopyRaster_management(raster,name_out,"DEFAULTS","0","0","","","8_BIT_UNSIGNED")
        print ("Copied {0}".format(name_out))
        cnt += 1
    

if __name__=="__main__":
    workspace = r"Database Connections\lclinton2_SQL08_R2.sde\sde101.SDE.Prasanta"
    outras = r"C:\Data\outrasters"
    ExtractRasterFromRC(workspace,outras)