topic Re: Export pop-up info with attachment from geodatabase in Python Questions

Export pop-up info with attachment from geodatabase

CrystalSchiffbauer-Bowles1 — Wed, 23 Jan 2019 23:17:37 GMT

Hello. We have been provided a geodatabase containing a point feature class and related attachments and tables. I have successfully exported the attached images from the geodatabase with the specified naming scheme. However, the question came up about whether it is possible to export attachments from the geodatabase, but this time INCLUDE the pop-up info (i.e., attribute data) in the "properties" of the image file. As an example, say an image of manhole 1_WW currently shows the xy location of the point, but it does not include any of the information that was added to the point feature class such as type, diameter, depth, etc, all of which are in the attribute table of the point.

I appreciate your help. Thank you.

Here is the script I used:

import arcpy
from arcpy import da
import os

inTable = arcpy.GetParameterAsText(0)
fileLocation = arcpy.GetParameterAsText(1)

with da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'REL_GLOBALID']) as cursor:
    for item in cursor:
        attachment = item[0]
        filenum = "ATT" + str(item[2]) + "_"
        filename = filenum + str(item[1])
        open(fileLocation + os.sep + filename, 'wb').write(attachment.tobytes())

Re: Export pop-up info with attachment from geodatabase

RandyBurton — Thu, 24 Jan 2019 01:05:54 GMT

When you say 'in the "properties" of the image file', do you mean something like saving data in the exif of a jpg, or saving a text file that would have the same name as the image file?

An old thread Query a related table and export it with joined feature attributes? might give you some ideas if you want to write data to a similarly named text file.

Re: Export pop-up info with attachment from geodatabase

GregRouse — Thu, 24 Jan 2019 15:36:29 GMT

Hi Crystal,

That's exactly the sort of issue I am looking into. Have you had any luck yet?

Greg

Re: Export pop-up info with attachment from geodatabase

CrystalSchiffbauer-Bowles1 — Thu, 24 Jan 2019 23:38:32 GMT

Hello Randy. Thank you for the response. I am looking to save the attribute data to the exif of the jpeg. I understand that information stored with the image and in the exif is drone collected, but would like to be able to use the related feature class attributes to write in field collected point data to the exif. My test file is a one-to-one relate; but others are one-to-many. I have joined the feature class to the Attachment table but am unable to get beyond this point because you can't export the attach table to a new one and maintain the attachments. I appreciate your help.

I hope that makes sense...I feel like I am making circular statements...

Re: Export pop-up info with attachment from geodatabase

RandyBurton — Fri, 10 Dec 2021 21:22:12 GMT

The additional explanation helps - one feature to one or more photos. I've dabbled a little with exif data. My August 24/25 comments in this thread might be of help.

You could read the feature attributes into a dictionary using the globalID as the key with a search cursor. Then work through your related table to get the attached photos with the related globalID to access the dictionary's saved attributes. Then save the image with new exif data.

UPDATE: Here's some sample code that links the parent data with the related image data:

import arcpy, os

masterFC = r'C:\Path\to\file.gdb\feature'
masterFlds = [ 'GlobalID', 'SHAPE@XY', 'OBJECTID', 'Field1', 'Field2' ] # [ 'GlobalID', and fields you want... ]

relatedTbl = r'C:\Path\to\file.gdb\feature'__ATTACH'
relatedFlds = ['REL_GLOBALID', 'ATTACHMENTID', 'DATA', 'CONTENT_TYPE']

# Use list comprehension to build a dictionary from a da SearchCursor
masterDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(masterFC, masterFlds)}
# print masterDict
# looks something like { '{6656FDEC-6BD8CF4E16AF}': ((-14962237.7272, 8031520.472999997), 421, 'attribute', ... ), ... }

sr = arcpy.Describe(masterFC).spatialReference # get spatial reference of parent feature, if desired
print sr.factoryCode

with arcpy.da.SearchCursor(relatedTbl, relatedFlds) as cursor:
    for item in cursor:
        # item[3] is Content Type
        if item[3] == 'image/jpeg': # process only images; where clause can also be used to limit results

            # item[0] is related GlobalID; use it as key to masterDict and access tuple with indexing
            x,y = masterDict[item[0]][0] # use [0] to access SHAPE@XY
            print x, y
            # get Longitude/Latitude
            ptGeometry = arcpy.PointGeometry(arcpy.Point(x,y),arcpy.SpatialReference(sr.factoryCode)).projectAs(arcpy.SpatialReference(4326))
            lon, lat = ptGeometry.firstPoint.X, ptGeometry.firstPoint.Y  

            parentOID = masterDict[item[0]][1] # use [1] to access parent ObjectID
            attribute1 = masterDict[item[0]][2] # use [2], [3], etc. to access parent feature's attributes
            attribute2 = masterDict[item[0]][3] # use [2], [3], etc. to access parent feature's attributes

            attID = item[1] # this is the Attachment ID in related table
            # make new filename for image

            filename = "ATT_{}_{}.jpg".format(parentOID, attID)
            print filename
            print lon, lat, parentOID, attribute1, attribute2
            # do your exif stuff here
            # save the image to the desired location
            # saveName = os.path.join(saveLocation, fileName)
            # f = open(saveName, 'wb').write(item[2].tobytes())

del  cursor
del item‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Code still needs the exif stuff. Hope this helps.

Re: Export pop-up info with attachment from geodatabase

LanceCole — Fri, 25 Jan 2019 01:41:23 GMT

It looks like you have the image extraction down using How To: Batch export attachments from a feature class in ArcMap.

You need to modify your cursor to include the other attribute data you would like to include in the image metadata
You then need to write this information as metadata to each image file using an additional Python module such as piexif · PyPI or py3exiv2 · PyPI depending which version of Python you are running. There are only a limited number of valid EXIF tags so you may need to concatenate the data into a JASON string and save it to the UserComment tag.

Example of using pyexif to write JASON data: Writing complex custom metadata on images through python - Stack Overflow