ExifTool Forum

ExifTool => Newbies => Topic started by: jacobverdesi on February 28, 2023, 01:25:25 AM

Title: csv flag for each
Post by: jacobverdesi on February 28, 2023, 01:25:25 AM
Hello i just stumbled across this marvilous program but still learning some if its quirks and features

Im currently running the command 'exiftool -ee -n -GPS* filename' and I get all of the gps lat/long/speed/track/date/time information as follows
GPS Latitude                    : 42.887158203125
GPS Longitude                   : -71.3512858072917
GPS Speed                       : 104.026836608887
GPS Track                       : 139.979995727539
GPS Date/Time                   : 2023:02:26 12:31:57Z
GPS Latitude                    : 42.886962890625
GPS Longitude                   : -71.3510579427083
GPS Speed                       : 103.397163391113
GPS Track                       : 139.809997558594
GPS Date/Time                   : 2023:02:26 12:31:58Z
GPS Latitude                    : 42.886767578125
GPS Longitude                   : -71.350830078125
GPS Speed                       : 103.397163391113
GPS Track                       : 139.970001220703
GPS Position                    : 43.0183675130208 -71.4480061848958
I would like to put into csv format where each row is a new group of gps data so i use the -csv option but it only selects the last entry
Title: Re: csv flag for each
Post by: Phil Harvey on February 28, 2023, 07:55:34 AM
Try using the -p option instead:

exiftool -ee -n -p "$gpsdatetime,$gpslatitude,$gpslongitude,$gpsspeed,$gpstrack" FILE

- Phil
Title: Re: csv flag for each
Post by: StarGeek on February 28, 2023, 09:54:34 AM
And in case you didn't see it, you can also turn it into a GPX or KML file.  See Inverse Geotagging (https://exiftool.org/geotag.html#Inverse).  You can find the needed FMT files on GitHub (https://github.com/exiftool/exiftool/tree/master/fmt_files).