Reduce FGDB Attachment Size

Blevins_Mark

Is there a method that will allow one to reduce the size (ie photo resolution) of fgdb record attachments, while they are still attached to the records inside the fgdb (as opposed to downloading the files and resizing outside of the fgdb)?

Kepa

Hi there,

I know it's an old thread but in case someone stumbles upon this issue I managed to compress them with this snippet

# Tested in ArcGIS PRO 3.5.x
import arcpy
import os
import tempfile
from PIL import Image
import io

# Attachment table
in_table = ""
quality = 70

with tempfile.TemporaryDirectory() as tmpdirname:
    with arcpy.da.UpdateCursor(in_table, ['DATA', 'ATT_NAME', 'DATA_SIZE']) as cursor:
        for row in cursor:
            attachment = row[0]
            filename = row[1]
            exported_img = os.path.join(tmpdirname, filename)
            open(exported_img, 'wb').write(attachment.tobytes())
            image = Image.open(exported_img)
            stream = io.BytesIO()
            image.save(stream, format='JPEG', quality=quality, exif=image.info.get("exif"))
            imagebytes = stream.getvalue()
            row[0] = imagebytes
            row[2] = len(imagebytes)
            cursor.updateRow(row)

It was tested on one of the two identical FileGDBs, which is actually compressing them based on the output:

Funny thing, the FileGDB size itself does not seem to shrink by itself, it's like it maintains the allocated storage. But that's for another day...

Hope this helps!