Save GPS data from .mov

[whiting123]

Hi,

I am extracting GPS data from a .mov file (KDLINKS X1 dash cam). Using the command exiftool -ee "gps*" FILE I can see all the values but how do I save the data. What I want is a file where the first column is time, second column latitude, third column longitude, ect. Is this possible?

[StarGeek]

You would list the tags you want in the order you want, use the -csv option, and redirect the output into a file.  For example
exiftool -ee -GPSLatitude -GPSLongitude -GPSAltitude -csv /path/to/file.mov >output.csv

Another option would be to create a geotrack, such as a .GPX file.  You can find instructions on how to do so under Inverse Geotagging.

[Phil Harvey]

Unfortunately the -csv option does not work for extracting multiple duplicate tags (eg. timed GPS) from a single file.

For this, you would need to use -p, with a command something like this:

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

- Phil

[lavAzza]

Hi.
Help me, pls.
I get this output by command

Code Select Expand

exiftool -ee -G3 2022-12-25-14-22-37.MOV > out.txt

Code Select Expand

...
[Doc1]          Sample Time                    : 0 s
[Doc1]          Sample Duration                : 1.00 s
[Doc1]          Text                            :  $GS:-4038,-2366,-3902 $G:2022-12-25 14:22:36-N51.727145-E54.964781-S000_END
[Doc1]          Text                            : $G:2022-12-25 14:22:36-N51.727145-E54.964781-S000_END
[Doc2]          Sample Time                    : 1.00 s
[Doc2]          Sample Duration                : 1.00 s
[Doc2]          Text                            :  $GS:-4094,-2446,-4094$G:2022-12-25 14:22:37-N51.727144-E54.964780-S000_END
[Doc2]          Text                            : $G:2022-12-25 14:22:37-N51.727144-E54.964780-S000_END
[Doc3]          Sample Time                    : 2.00 s
[Doc3]          Sample Duration                : 1.00 s
[Doc3]          Text                            :  $GS:4032,-2462,-3870$G:2022-12-25 14:22:38-N51.727143-E54.964780-S000_END
[Doc3]          Text                            : $G:2022-12-25 14:22:38-N51.727143-E54.964780-S000_END
...
Is there way to generate file with format
filename-Sample time-N-E
?
Or I need to process this output in Excel?

[Phil Harvey]

This appears to be a GPS format not supported yet by ExifTool.  Can you send me a sample so I can add support for this?  My email is philharvey66 at gmail.com

- Phil

[lavAzza]

This appears to be a GPS format not supported yet by ExifTool.  Can you send me a sample so I can add support for this? 

Thank you, I sent the file.

[Phil Harvey]

I got the sample and can decode the GPS information.

Two questions:

1. What was the camera make and model?

2. Do you know what these numbers are (typically they are some sort of accelerometer readings, but they seem to jump around a lot in your video)?:

Code Select Expand

3870 -2560 4038
4046 -2400 -3968
-4094 -2334 -3646
-3998 -2558 -3772
4080 -2496 3936
3854 -2560 -4094
3968 -2462 -3662
-3838 -2366 -3782
3900 -2432 4064
-3974 -2352 -3614
3504 -2400 3696
3710 -2446 3772
4032 -2366 -3598
-4032 -2424 -3598
3824 -2432 -4046
-4032 -2366 -3632
-3968 -2432 -3910
-3998 -2118 -3136
-3998 -2502 -3552
3534 -2544 3998
3390 -2590 4024
4032 -2446 -4032
3710 -2334 3998
3424 -2240 3906
4080 -2296 4094
3854 -2528 3910
3840 -2558 3998
3520 -2366 4064
-3854 -2432 -4094
3902 -2400 -3952
-3936 -2272 -3776
-3808 -2558 -3776
3760 -2496 -3376
3708 -2462 -4094
4046 -2496 -3904
-4024 -2492 -3936
3998 -2544 -3936
-3936 -2366 -3680
-3936 -2366 -3680
3772 -2480 3968
3906 -2306 4034
3710 -2432 3726
-4064 -2400 3936
3902 -2438 4092
3646 -2496 3968
- Phil

[lavAzza]

1. What was the camera make and model?

2. Do you know what these numbers are (typically they are some sort of accelerometer readings, but they seem to jump around a lot in your video)?:

1. CARCAM Q7 https://carcam.ru/product/carcam_q7.html
2. Unfortunately I dont know what is this data. I dont know typical range of accelerometer sensor data, but this video shooted on bad road. There is win app that can view this video, may be it can help to know. https://datakam.ru/upload/medialibrary/509/bq4v90n9p9rxhr0la7bet693r7hhj256/RegistratorViewer_v.6.0.0.22.zip

[Phil Harvey]

Thanks.  I think the "G" plot in your screen capture was likely the total G acceleration.  It would be more helpful if the app displayed separate X-Y-Z plots.  I can't run the app myself.  I think these numbers are likely the acceleration components, but I would be guessing at the scaling factor without seeing the separate plots.

- Phil

[lavAzza]

This app can export data to csv format. If you want I sent it. I tryed to understand relation, but I cant.
https://drive.google.com/drive/folders/1BuZ6-X-vri1GnlLbbro8DZD63r6BDA9l?usp=sharing

[Phil Harvey]

Got it, thanks.

I can convert the stored numbers to the ones reported by the Win app using these formulas:

Code Select Expand

my @acc = ( ($2+2432)/1000, ($3 + 361)/1000, ($1-3708)/1000 );
Note that the ordering also changed.  The 1st number reported by the Win app is the 2nd stored number ($2), etc.

ExifTool 12.55 will use this decoding, but I'm a bit worried that the arbitrary constants (2432, 361, -3708) may not be all that constant.  It would be good if you could test this when it is released to see if this conversion works for other videos.

- Phil

[lavAzza]

ExifTool 12.55 will use this decoding, but I'm a bit worried that the arbitrary constants (2432, 361, -3708) may not be all that constant.  It would be good if you could test this when it is released to see if this conversion works for other videos.

Ok, I will.
Thank you very much.

[lavAzza]

Hello.
How I can get filename in the each string of the output?
When I run

Code Select Expand

exiftool -n -p "$filename,$gpsdatetime,$gpslatitude,$gpslongitude" -ee FILEI get

Code Select Expand

Warning: [Minor] Tag 'DocXXX:filename' not definedWith -m key I get first string the filename and other strings are time and coordinates.

[StarGeek]

Do you get the proper data anyway?  The warning shouldn't affect the output otherwise.

Can you share a sample file?  I don't think I've seen that warning before.

[Phil Harvey]

Use $main:filename if you want the same filename to appear on each line.  (It is in the Main group, not in a sub-document like the GPS tags.)

- Phil