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
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
That's what I thought might be the answer. How would I convert the file to GPX format?
ExifTool does read GPS/IMU-formatted CSV files. Here are the recognized column headings for this file format:
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
Thank you. Could I ask where this is documented? I could not find it.
Quote from: Phil Harvey on April 20, 2020, 01:04:13 PM
ExifTool does read GPS/IMU-formatted CSV files. Here are the recognized column headings for this file format:
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
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
Thank you. If you expand it I think it would be helpful to support other date formats such as yyyy-mm-dd.
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
Oh. I just noticed that Altitude is currently supported, with a heading [Pos]Alt*.
- Phil
Excellent! Thank you, again!
ExifTool 11.95 will enhance this feature to allow standard ExifTool tag names as column headings, and will document this on the Geotagging page (https://exiftool.org/geotag.html#CSVFormat).
- Phil
Thank you. When do you expect 11.95 to be available.
I'll see about pushing it out within a couple of days.
- Phil
11.95 is now available.
- Phil
Thank you!