Some of my photos in Apple Photos 2.0 (3150.4.120) have the wrong time zone, but I don't know which ones. I can find the time zone for an individual photo, by selecting Image > Adjust Date and Time.
But how can I find all photos with a certain time zone? I've tried searching in the Finder, in the photos' filesystem metadata (using mdls), in the photos' EXIF metadata (using exiftool), and even in the Photos sqlite database, but haven't found where it's stored.
Where is this information?
Best Answer
It may depend on the camera/phone and OS; but, I don't think the timezone is explicitly stored in the picture's EXIF metadata.
In some metadata, there is a
GPS Time (Atomic Clock)
which is set to UTC. So, Photos probably just calculates the offsets ofDate and Time (Original)
to display the timezone.You may be able to use exiftool to build a list of those two times for your pictures, and search for outliers which are more (or less) different than the others.
Update from original poster:
I threw together a quick Python script to compare these times, and print the ones that aren't in the expected time zone, or have different values for minutes. You'll need to export the unmodified originals from Photos, since the modified ones don't have this metadata, and then pass their filenames to this script.
Of course, I have no idea if this is anything close to what Photos does to set the time zone. But it correctly identified the photos that I knew of with the wrong time zone, and didn't find any false positives.