CSV track log file format for Geotagging

[dzeek]

I need to create a track log in CSV format for geotagging a series JPG files with ExifTool. The ExifTool GPX format uses lat, lon, ele and time field names for each entry in a track.

What are the corresponding field (column) names and time format to use in a CSV file?

Also, do I do the tagging with csv like this, for example?

exiftool -geotag track.csv *.jpg

Thank you

[krzysiu]

edit: sorry, I missed *track* log. Then AFAIK it's not possible, but you could convert your file to GPX.

Columns are up to you, you define it in the command line. The explaination and short example is here: https://exiftool.org/forum/index.php?topic=5996.0

[dzeek]

That's what I thought might be the answer. How would I convert the file to GPX format?

[Phil Harvey]

ExifTool does read GPS/IMU-formatted CSV files.  Here are the recognized column headings for this file format:

Code Select Expand

Date*           - date in DD/MM/YYYY format
Time*           - time in HH:MM:SS.SSS format
[Pos]Lat*       - latitude in decimal degrees
[Pos]Lon*       - longitude in decimal degrees
[Angle]Heading* - GPSTrack in degrees true
[Angle]Pitch*   - pitch angle in degrees
[Angle]Roll*    - roll angle in degrees


- Phil

[dzeek]

Thank you. Could I ask where this is documented? I could not find it.

[dzeek]

ExifTool does read GPS/IMU-formatted CSV files.  Here are the recognized column headings for this file format:

Code Select Expand

Date*           - date in DD/MM/YYYY format
Time*           - time in HH:MM:SS.SSS format
[Pos]Lat*       - latitude in decimal degrees
[Pos]Lon*       - longitude in decimal degrees
[Angle]Heading* - GPSTrack in degrees true
[Angle]Pitch*   - pitch angle in degrees
[Angle]Roll*    - roll angle in degrees


- Phil

Sorry. A few questions on the format:

1. Is Altitude also included?
2. What does the * mean in the column heading names?
3. Are the times UTC?
4. Are all columns required? Our data does not include heading, pitch and roll.

Thank you

[Phil Harvey]

This is not documented anywhere here, it is an external format specified by GPS/IMU.  I am thinking of expanding this for my own use and documenting it.  If I do this, I'll add Elevation.  The required columns for geotagging are Date, TIme, Lat and Lon. Others are optional.  The "*" means anything after that is OK, and stuff in brackets is optional (ie. "PosLat", "Lat" and "Latitude" are all OK).  The time should be in UTC.

- Phil

[dzeek]

Thank you. If you expand it I think it would be helpful to support other date formats such as yyyy-mm-dd.

[Phil Harvey]

Yes.  Was planning on adding support for ExifTool-compatible date/times (perhaps even allow -d to apply).

Look for this feature in ExifTool 11.95.

- Phil

[Phil Harvey]

Oh.  I just noticed that Altitude is currently supported, with a heading [Pos]Alt*.

- Phil

[dzeek]

Excellent! Thank you, again!

[Phil Harvey]

ExifTool 11.95 will enhance this feature to allow standard ExifTool tag names as column headings, and will document this on the Geotagging page.

- Phil

[dzeek]

Thank you. When do you expect  11.95 to be available.

[Phil Harvey]

I'll see about pushing it out within a couple of days.

- Phil

[Phil Harvey]

11.95 is now available.

- Phil