Apple Photos App Metadata

Started by neebah, May 25, 2018, 09:16:21 AM

Previous topic - Next topic

neebah

So using the export unmodified originals function on the Mac Photos App and selecting export IPTC as XMP all of the metadata from the photos app is exported as a sidecar xmp file.  The exceptions to this are the album information and the location of the faces tagged by the user.  Keywords, titles, and descriptions are exported.  The face names are exported in an XMP subject bag.  The information for the location and size of the faces are stored in the photos.db sqlite3 database.  I've used a db explorer program to export the relevant tables as csv files.  These tables are RKFace, RKMaster, and RKPerson

RKMaster is mostly for the filenames
RKFace has the face information and links it RKPerson
RKPerson has the person name information. 

I'm mostly leaving this for the public to digest.  I'm currently working on a script to output this information as an XMP MWG face region.  Shouldn't be that bad.  I don't want to use sqlite to C# connection.  I'd rather just trim the excess information in the CSV and run a collate script to make the XMP.