News:

2023-03-15 Major improvements to the new Geolocation feature

Main Menu

GeoTag Data File Formats Supported Don't (seem to) Include a CSV Format!

Started by techedge, December 02, 2015, 06:47:40 PM

Previous topic - Next topic

techedge

Over 27 days, when bicycling 1,621km in outback Australia earlier this year I generated over 20Gb of image data.  I also ran an Android app GPSlogger:

   http://code.mendhak.com/gpslogger/

.. which produced daily .TXT file GPS logs which are really CSV files with a very basic format (first 4 lines of a file shown, first line gives field names):

(time),(lat),(lon),(elevation),(accuracy),(bearing),(speed)
2015-08-11T11:19:03Z,-19.691823,127.487404,312.200012,41.000000,0.000000,0.250000
2015-08-11T11:20:28Z,-19.691894,127.487223,316.500000,3.000000,266.500000,2.500000
2015-08-11T11:20:49Z,-19.691993,127.486322,317.100006,3.000000,262.399994,4.250000
etc.

I selected this file format because it's very basic and I figured my phone (in Flight Mode as there are no cell towers out there!) wasn't going to run out of storage, and I could manipulate it easily later if necessary (yes, I appreciate that ExifTool can shift timestamps, but my other tools can't). We also took most of the images on another camera without GPS.

So, do I have to update my C program (I wrote to update the time stamps in the CSV files) to create an output format  that's supported by the geotag operation, or is there some hidden CSV geotag file support?

No problem to update my code but, if so, what is the simplest format the ExifTool supports for geotag data?

Peter.

StarGeek

Have you tried seeing if Exiftool can read the gps file directly?  See the Geotagging with ExifTool page for instructions.

* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

techedge

Thanks StarGeek - Yes and no. I renamed my .TXT file to .log and .csv, and ExifTool didn't work out what to do magically. Yes, there are other tools to convert CSV to some of the supported formats, but that's not what I want the answer to.

c:\exiftool -geotag log.csv Dsci1133.jpg
Warning: No track points found in GPS file 'log.csv' in File:Geotag (ValueConvInv)
Warning: GPS track is empty in File:Geotime (ValueConvInv) - Dsci1133.jpg
Warning: No writable tags set from Dsci1133.jpg
    0 image files updated
    1 image files unchanged

techedge

Oh, I see (http://www.exiftool.org/geotag.html):

1. "No track points found in GPS file"

If you see the above message, either exiftool does not yet support your track log file format, or your track log does not contain the necessary position/timestamp information. For instance, in KML files each Placemark must contain a TimeStamp. If you believe your track log contains the necessary information, please send me a sample file and I will add support for this format.


No problem. I'll write that bit of code (I'm in a hurry ;-)

techedge

Seem to be having some basic problems ...

I create a KML file (x.kml):

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
   <Document>
      <name>Test</name>
      <Placemark>
         <name>CSR</name>
         <description>Starting from Billiluna</description>
         <Point>
            <coordinates>-19.691823,127.487404</coordinates>
         <TimeStamp>
            <when>2015-08-11T11:41:06</when>
         </TimeStamp>
      </Placemark>
   </Document>
</kml>


I check my image's DateTimeOriginal tag:

c:\exiftool Dsci1133.jpg -verbose
  ExifToolVersion = 10.07
  FileName = Dsci1133.jpg
...
  | | 5) DateTimeOriginal = 2015:08:11 11:41:06
...


I try to add the geotag info (Lat, Long) specified in the KML file:

c:\exiftool -geotag x.kml Dsci1133.jpg -v
Argument "-Geotime<DateTimeOriginal" is assumed
Loaded 1 points from XML-format GPS track log file 'x.kml'
======== Dsci1133.jpg
Setting new values from Dsci1133.jpg
Warning: Time is too far before track in File:Geotime (ValueConvInv) - Dsci1133.jpg
Warning: No writable tags set from Dsci1133.jpg
Nothing changed in Dsci1133.jpg
    0 image files updated
    1 image files unchanged


It's unclear (to me) from the documentation http://www.exiftool.org/exiftool_pod.html#special_features if some kind of assumed timezone offset isn't being added in to the calculation, and throwing off the comparison.

Can anyone suggest what's happening?

StarGeek

Might it be a time sync issue?  You said the pictures were taken in Australia, but you have the same time stamp in your KML file as in your DateTimeOriginal.  The time stamp in the KML must be in UTC time.  See geotag trouble shooting question three.
* Did you read FAQ #3 and use the command listed there?
* Please use the Code button for exiftool code/output.
 
* Please include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).

techedge

StarGeek, thanks for your reply. This command line does (well, sort of) what I want:

c:\exiftool -geotag x.kml -geosync=+10:00:00  Dsci1133.jpg

I have to do some checking, and I think I'll have to make some suggestions for updating the documentation. But I'm getting ahead of myself. Thanks again.