ExifTool Forum

General => Metadata => Topic started by: Engineer_GLTECH on July 15, 2024, 02:36:07 PM

Title: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 15, 2024, 02:36:07 PM
The Dashcam I recently acquired from eBay generates MP$ files. I need to extract GPS coordinates and vibration sensor data that it saves. I currently use GXPlayer to review files. But I would like to extract them and save as CVS file of something similar. The link to file is as follows.

https://www.dropbox.com/scl/fi/46uko1osvglnlp9kfvrxb/Share_DashVid.mp4?rlkey=mjij0f7a55gkhlaj2e7ubfqb6&st=hgjft0k0&dl=0

Thanks in advance.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 15, 2024, 09:24:06 PM
I can see the GPS in this video.  Unless I post back here with problems, expect this to be extracted by ExifTool 12.90 when it is released.

- Phil
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 15, 2024, 10:02:13 PM
A couple of questions:

1. The GPS data says you are going about 52 "km/h" during this video, but it looks more like 52 mph to me.  Which is it?

2. There is an "H" reading in the data that decreases from 361.3 at the start of the video to 245.0 at the end.  Perhaps this is supposed to be elevation (height)?  But it looks like your elevation should be about 200m for the entire video.

Another sample from a different location where you go around some corners and change speed a bit would help figure these out.  A straight line course at constant speed doesn't give me much to work with.

- Phil
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 03:49:43 AM
Phil, That is great. I look forward to Ver-12.9.
The speeds should be in MPH. I know the speed shown by car odometer and the one shown on the top left corner in the video matches. 
I have more video files. Let me verify and send you
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 10:58:32 AM
OK. Here is another video file.
https://www.dropbox.com/scl/fi/4qyrsod0ah6o9qgby2h2f/20240520_220727F.mp4?rlkey=tytde6svab4cp9035ve56jn7x&st=xtw5ck9c&dl=0

I am also interested in fetching the Accelerometer data.
Currently I use GXPlayer from following link.

https://sourceforge.net/projects/gxplayer-v4-2-8/

It can load up to three video files (Front, Rear and Incar camera) and play it simultaneously/ synchronously while showing a map and car's current position during that 3 or 5 minute clip that it's playing. It also plots accelerometer data as car is moving.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 11:10:59 AM
I am in Industrial automation field with relative decent software experience.
I intend to create a software utility that will scan through the stash of dashcam video files that i have accumulated over the week and identify the files where

1) the car was moving
2) Accelerometer showed bump or hit
3) total miles travelled that week
4) etc. etc. (TBD)

I do leave the dashcam on when I am parked at work or parked at home but on the side street. If there is a hit and run situation I would like to identify the culprit.

Ffmpeg and Exiftool will be a big part of that windows software.  I hope there will be people out there who would help me test such a software.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 16, 2024, 11:13:51 AM
Thanks.  I can extract the Accelerometer and GPSTrack, but there is still an unknown value I can't figure out.  For this track the value starts at 237.1 and goes up to 350.1

- Phil
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 11:25:08 AM
Phil,

No idea Sir.
According to Google average Elevation of the neighborhood I am travelling through is ~ 180 feet. I wonder if those numbers are reflecting that as the car is moving.
If I can think of something else I will report.
I am open to sending more video files if that would help you.

Thanks again for looking into it.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 16, 2024, 11:57:01 AM
Do you have any files where the elevation changes significantly, or taken in a location with a very different altitude?  GPS elevation is notoriously inaccurate, so I'm still thinking there is a chance this could be it.

- Phil
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 01:09:24 PM
Phil,

I sent you a link for a Dash cam video file when the car was parked and GPS didn't have lock so all values were zeros.
Unfortunately i don't have access to my HD at this moment but I really doubt if I have any file that has significant elevation changes.
The link was sent to your Gmail address. I hope you are ok with that.
Thanks
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 16, 2024, 01:30:53 PM
Links to my email are fine.  Usually that is how I request samples in case people don't want to make them public.

The way I've done things, ExifTool won't extract any timed metadata from this latest sample.

Regarding the unknown values, for now I'll extract them as "Unknown_H" if the Unknown (-u) option is used.

I think that's about as much as I can do for now.  This update will appear in version 12.90 when it is released, but if you tell me what system you are using I can make a pre-release available.

- Phil

Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 01:49:54 PM
Phil,
Thanks for looking into it.
I am using Windows 10 .
Pre release would be nice. I can test drive the tool with files I have and report how it's doing for me.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 16, 2024, 04:03:24 PM
Try this:  exiftool-12.90p_64.zip (http://exiftool.org/exiftool-12.90p_64.zip)

- Phil
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 05:34:30 PM
Phil,
It's working great on few of the files I tried. I will run more files later tonight and provide an update.
I am just using -ee option to extract all the tags and then parsing them to get what is required. I am assuming the speed is in km/h.
Any idea why it's showing Z at the end of 'GPS Date/Time'

Thanks a lot
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: StarGeek on July 16, 2024, 06:12:29 PM
Quote from: Engineer_GLTECH on July 16, 2024, 05:34:30 PMAny idea why it's showing Z at the end of 'GPS Date/Time'

It stands for Zulu Time (https://en.wikipedia.org/wiki/Coordinated_Universal_Time#Time_zones), i.e. another format for UTC time.
QuoteThe time zone using UTC is sometimes denoted UTC±00:00 or by the letter Z—a reference to the equivalent nautical time zone (GMT), which has been denoted by a Z since about 1950.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Engineer_GLTECH on July 16, 2024, 06:19:28 PM
Thanks StarGeek.
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 16, 2024, 07:17:49 PM
Correct.  Speed is in km/h.  I was assuming the stored time stored was UTC (zulu), but let me know if it is otherwise.

- Phil
Title: Re: XGODY 12" 4K Dashcam - extracting GPS, vibration data from MP$
Post by: Phil Harvey on July 16, 2024, 09:33:06 PM
I've just looked at your screen captures.  You might consider using this command to extract the data in CSV format:

exiftool -ee -n -p "$GPSDateTime,$GPSLatitude,$GPSLongitude,$GPSSpeed,$GPSTrack,$Accelerometer" FILE
- Phil