X-Git-Url: https://git.gag.com/?p=web%2Fgag.com;a=blobdiff_plain;f=bdale%2Fblog%2Fposts%2FDigital_Photo_Creation_Dates.mdwn;h=3fe98a00b3b03eab3fbde069c798d6d9a09e37f6;hp=7814de82fa7496c1d48f3d1228fa69f0e632e81c;hb=5313925fc1c4b4aec1cf68ea68de79f706da4ce9;hpb=0e101747be0d249176861d3f22c87ab2eed4b0e0

diff --git a/bdale/blog/posts/Digital_Photo_Creation_Dates.mdwn b/bdale/blog/posts/Digital_Photo_Creation_Dates.mdwn
index 7814de8..3fe98a0 100644
--- a/bdale/blog/posts/Digital_Photo_Creation_Dates.mdwn
+++ b/bdale/blog/posts/Digital_Photo_Creation_Dates.mdwn
@@ -5,7 +5,7 @@ I learned something new yesterday, that probably shouldn't have shocked me
 as much as it did.  For legacy reasons, the "creation time" in the 
 [Exif](https://en.wikipedia.org/wiki/Exif) metadata attached to digital
 camera pictures is not expressed in absolute time, but rather in some
-arbitrary express of "local" time!  This caused me to spend a long evening 
+arbitrary expression of "local" time!  This caused me to spend a long evening 
 learning how to twiddle Exif data, and then how to convince
 [Piwigo](https://piwigo.org/) to use the updated metadata.  In case I or 
 someone else need to do this in the future, it seems worth taking the time
@@ -83,6 +83,12 @@ plus 4 time zones from home to where the photos were taken.  And the remaining
 was originally set by hand, and drift of the camera's clock in the many 
 months since then.
 
+I thought briefly about hacking Piwigo to use the GPS time stamps, but quickly
+realized that wouldn't actually solve the problem, since they're in UTC and
+the pictures from our phone cameras were all using local time.  There's 
+probably a solution lurking there somewhere, but just fixing up the times in
+the photo files that were wrong seemed like an easier path forward.
+
 A Google search or two later, and I found 
 [jhead](https://www.sentex.ca/~mwandel/jhead/),
 which fortunately was already packaged for Debian.  It makes changing Exif
@@ -92,7 +98,7 @@ Compounding my problem was that my wife had already spent many hours tagging
 her photos in the Piwigo web GUI, so it really seemed necessary to fix the
 images "in place" on the Piwigo server.  The first problem with that is that
 as you upload photos to the server, they are assigned unique filenames on
-disk based on the upload date and time plus a random has, and the original
+disk based on the upload date and time plus a random hash, and the original
 filename becomes just an element of metadata in the Piwigo database.  Piwigo
 scans the Exif data at image import time and stuffs the database with a 
 number of useful values from there, including the image creation time that is
@@ -101,7 +107,7 @@ fundamental to aligning images taken by different cameras on a timeline.
 I could find no Piwigo interface to easily extract the on-disk filenames for
 a given set of photos, so I ended up playing with the underlying database
 directly.  The Piwigo source tree contains a fle piwigo_structure-mysql.sql
-used in the installation process to set up the database tables tha served as
+used in the installation process to set up the database tables that served as
 a handy reference for figuring out the database schema.  Looking at the
 piwigo_categories table, I learned that the "folder" I had uploaded all of
 the raw photos from my wife's camera to was category 109.  After a couple 
@@ -137,6 +143,5 @@ date range (which I expressed as taken:2019-12-14..2021), then selected all
 photos in the resulting set, and performed action "synchronize metadata".  All
 the selected image files were rescanned, the database got updated...
 
-Voila!
-
+Voila!  Happy wife!