See https://github.com/RhetTbull/osxphotos

[junkblocker]

Saw the note about difficulties with keeping up with format changes. @RhetTbull has been doing a lot of work on reverse engineering OSX Photos library format over at https://github.com/RhetTbull/osxphotos . Maybe it would be helpful to look at that.

[RhetTbull]

Thanks for the mention @junkblocker

I don't yet have Faces implemented in osxphotos (though Persons are implemented). I do plan to eventually add support though -- see issue #21.

In Photos 5, the detailed face info is in ZDETECTEDFACE. The following SQL snipped shows how to associate the face with a photo and a person. The coordinates all appear to be percent of X, Y, reference seems to be bottom left corner. Haven't done a lot of experimenting with this yet though. The columns in ZDETECTEDFACE are self-explanatory.

SELECT 
ZGENERICASSET.ZUUID, 
ZPERSON.ZFULLNAME, 
ZDETECTEDFACE.ZCENTERX, 
ZDETECTEDFACE.ZCENTERY, 
ZDETECTEDFACE.ZSIZE
FROM 
ZGENERICASSET
JOIN ZDETECTEDFACE ON ZDETECTEDFACE.ZASSET = ZGENERICASSET.Z_PK
JOIN ZPERSON on ZDETECTEDFACE.ZPERSON = ZPERSON.Z_PK