1

I'm struggling to find a software which:

  1. Takes N images
  2. For each image, create a row in a table which contains the image, GPS coordinates, and timestamp
  3. Export the table in PDF

Alternatively, a software which does this would also work:

  1. Takes N images
  2. For each image, append a white rectangle underneath it with some EXIF metadata (i.e. GPS coordinates and timestamp)
  3. Exports each image to a separate folder

So far I have only been able to find viewer programs such as MesaExif and ExifEditor for the Mac, but nothing which outputs EXIF medatada in bulk alongside the images themselves. ex

11
  • 1
    Are you familiar with the ImageMagick.org suite of tools?
    – barrycarter
    Jul 21, 2022 at 12:12
  • You can create a script by using exiftool that does that, not sure it can create pdf files though...
    – Ricardo Bohner
    Jul 21, 2022 at 12:36
  • What kind of table to create? And what did you try so far? Jul 21, 2022 at 13:17
  • Hey, @barrycarter yes I've used ImageMagick.org before, but I believe it's primarily directed at image manipulation, not metadata reporting. A quick search didn't turn up many promising avenues: imagemagick.org/script/search.php?q=exif&sa= But please let me know if I'm wrong and I'm missing something!
    – wixoft142
    Jul 21, 2022 at 14:47
  • @RicardoBohner This is great! I found this article which seems very promising: exiftool.org/forum/index.php?topic=2681.0 Do you have a command/approach in mind you could share?
    – wixoft142
    Jul 21, 2022 at 14:50

1 Answer 1

1

Here is how to create CSV file:

exiftool  -gpslatitude -gpslongitude -DateTimeOriginal -csv -T <path/to/images>

Then you can redirect the result to file and import it in your instrument for further manipulation.

Here is what I get as result on Windows 10, exiftool v12.28:

d:\photo\new\Aheloy\20220699>c:\tools\exiftool  -gpslatitude -gpslongitude -DateTimeOriginal -csv -T export
SourceFile,GPSLatitude,GPSLongitude,DateTimeOriginal
export/_M2A4848.jpg,"42 deg 38' 18.85"" N","27 deg 38' 50.18"" E",2022:06:17 10:12:41
export/_M2A4853.jpg,"42 deg 38' 18.85"" N","27 deg 38' 50.18"" E",2022:06:17 10:12:42
export/_M2A4855.jpg,"42 deg 38' 18.85"" N","27 deg 38' 50.18"" E",2022:06:17 10:13:06

You can try with specific parameter (thank you @Izzy) to create html table

exiftool  -filename -gpslatitude -gpslongitude -DateTimeOriginal -h -T .
<!-- ./_M2A4848.jpg -->
<table>
<tr><td>_M2A4848.jpg</td></tr>
<tr><td>42 deg 38&#39; 18.85&quot; N</td></tr>
<tr><td>27 deg 38&#39; 50.18&quot; E</td></tr>
<tr><td>2022:06:17 10:12:41</td></tr>
</table>
<!-- ./_M2A4853.jpg -->
<table>
<tr><td>_M2A4853.jpg</td></tr>
<tr><td>42 deg 38&#39; 18.85&quot; N</td></tr>
<tr><td>27 deg 38&#39; 50.18&quot; E</td></tr>
<tr><td>2022:06:17 10:12:42</td></tr>
</table>

to convert it to PDF you can use something like:

exiftool  -filename -gpslatitude -gpslongitude -DateTimeOriginal -h -T . | pandoc -o exif.pdf
9
  • 1
    @Izzy, maybe the output depend of the OS we run the tool. Jul 22, 2022 at 4:41
  • 1
    I won't doubt that (which is why I made it a comment and not an edit) – it might as well depend on the version of exiftool used. I'm using the one shipping with my distributions repo, being on Linux Mint 20.3. I was hoping the output could directly be used, but for me the file name is just put into a <!-- comment --> unfortunately. Is that not the case for you? Then the output of my example command could simply be piped to | pandoc -o exif.pdf.
    – Izzy
    Jul 22, 2022 at 7:16
  • 1
    @Izzy, add result for Windows 10, exiftool v 12.28 Jul 22, 2022 at 8:03
  • 1
    Thanks! What does it look like when replacing -csv by -h? Is the filename again just a comment, or included as normal cell? Btw: 11.88 here on Linux (no idea why it wasn't updated – most likely because of "LTS").
    – Izzy
    Jul 22, 2022 at 18:57
  • 2
    @Izzy, very good, thank you, just need to add explicitly -filename and you will have formatted as tables. :) Jul 22, 2022 at 19:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.