Replying to my own post in case this helps anyone...I at least found a method to do so in Python after the fact. Forgive me for sloppy code...
import requests
import arcgis
from PIL import Image
from PIL.ExifTags import TAGS, GPSTAGS, IFD
from io import BytesIO
import arcpy
userName = ''
print("Log in to Org Account")
gis = arcgis.GIS("https://yourOrg.maps.arcgis.com", username= userName)
print("Successfully logged in as " + str(gis.properties.user.username)
def get_exif_data(self):
exif_data = {}
info = self._getexif()
if info:
for tag, value in info.items():
decoded = TAGS.get(tag, tag)
if decoded == "GPSInfo":
gps_data = {}
for t in value:
sub_decoded = GPSTAGS.get(t, t)
gps_data[sub_decoded] = value[t]
exif_data[decoded] = gps_data
else:
exif_data[decoded] = value
return exif_data
def convert_to_degress(value):
"""Helper function to convert the GPS coordinates
stored in the EXIF to degress in float format"""
d = float(value[0])
m = float(value[1])
s = float(value[2])
return d + (m / 60.0) + (s / 3600.0)
def get_lat(self):
if 'GPSInfo' in self:
gps_info = self['GPSInfo']
if 'GPSLatitude' and 'GPSLatitudeRef' in gps_info:
gps_lat = gps_info['GPSLatitude']
gps_lat_ref = gps_info['GPSLatitudeRef']
if gps_lat and gps_lat_ref:
lat = convert_to_degress(gps_lat)
if gps_lat_ref !='N':
lat = 0-lat
print(f'GPSLatitude: {lat}')
return lat
else:
print('GPSLatitude not found!')
return None
else:
return None
def get_long(self):
if 'GPSInfo' in self:
gps_info = self['GPSInfo']
if 'GPSLongitude' and 'GPSLongitudeRef' in gps_info:
gps_long = gps_info['GPSLongitude']
gps_long_ref = gps_info['GPSLongitudeRef']
if gps_long and gps_long_ref:
long = convert_to_degress(gps_long)
if gps_long_ref !='E':
long = 0-long
print(f'GPSLongitude: {long}')
return long
else:
print("GPSLongitude not found!")
return None
else:
return None
def get_angle(self):
if 'GPSInfo' in self:
gps_info = self['GPSInfo']
if 'GPSImgDirection' in gps_info:
gps_angle = gps_info['GPSImgDirection']
if gps_angle:
print(f'GPSImgDirection: {gps_angle}')
return gps_angle
else:
print(f'GPSImgDirection not found!')
return None
else:
return None
layerID = ''
layerItem = arcgis.gis.Item(gis, layerID)
photoPointLayer = layerItem.layers[]
where_clause = "PhotoAngle IS NULL OR PhotoLat IS NULL OR PhotoLong IS NULL"
photoPointFSet = photoPointLayer.query(where=where_clause, return_geometry=False)
runCount = len(photoPointFSet)
if runCount > 0:
print(f"---{runCount} features returned that require EXIF metadata updates---")
fieldsList = ['OBJECTID', 'PhotoAngle', 'PhotoLat', 'PhotoLong']
with arcpy.da.UpdateCursor(photoPointLayer.url, fieldsList, where_clause) as cursor:
for row in cursor:
OID = row[0]
attachmentInfo = photoPointLayer.attachments.search(object_ids=[OID])
for attachment in attachmentInfo:
downloadURL = attachment["DOWNLOAD_URL"]
response = requests.get(downloadURL, stream=True)
if response.status_code == 200:
img = Image.open(BytesIO(response.content))
exif_data = get_exif_data(img)
if exif_data:
# exif = {TAGS.get(tag, tag): value for tag, value in exif_data.items()}
print(f"EXIF metadata for {attachment['NAME']}:\n", exif_data)
exifAngle = get_angle(exif_data)
exifLat = get_lat(exif_data)
exifLong = get_long(exif_data)
if exifAngle or exifLat or exifLong:
if exifAngle:
row[1] = exifAngle
if exifLat:
row[2] = exifLat
if exifLong:
row[3] = exifLong
cursor.updateRow(row)
else:
print(f"No EXIF metadata found for {attachment['NAME']}")
else:
print(f"Failed to access {attachment['NAME']}")
else:
print('No features require updating. Have a nice day.')
This is also apparently possible with a Power Automate connector but haven't tried it yet.
