OT: Timestamp puzzle

terrypin wrote on 11/9/2017, 6:09 AM

Anyone have any photos taken in 'summer' time on an iPhone in a time zone ahead of UK, such as mainland Europe etc?

If so, can you advise what these two EXIF fields report please?
Date TimeOriginal
GPS Date Timestamp

My iPhone 6S+ (latest iOS 11.1) shows these as only differing by one hour instead of the two I would expect, for JPGs taken in Italy in May. (Plus 1 for BST instead of GMT/UTC and plus 1 for the timezone change.)  My wife's Sony Xperia (Android OS) does show two.

Terry, East Grinstead, UK

Comments

johnebaker wrote on 11/9/2017, 7:51 AM

Hi Terry

Yours is correct and the Android is not - Italy is always 1 hour ahead of UK time - they have daylight saving (IST?) which changes same date as ours.

The Android Sony Experia is probably not using Geo-location to adjust the GPS time.

HTH

John EB

Last changed by johnebaker on 11/9/2017, 7:52 AM, changed a total of 1 times.

VPX 16, Movie Studio 2025, and earlier versions 2015 and 2016, Music Maker Premium 2024.

PC - running Windows 11 23H2 Professional on Intel i7-8700K 3.2 GHz, 16GB RAM, RTX 2060 6GB 192-bit GDDR6, 1 x 1Tb Sabrent NVME SSD (OS and programs), 2 x 4TB (Data) internal HDD + 1TB internal SSD (Work disc), + 6 ext backup HDDs.

Laptop - Lenovo Legion 5i Phantom - running Windows 11 24H2 on Intel Core i7-10750H, 16GB DDR4-SDRAM, 512GB SSD, 43.9 cm screen Full HD 1920 x 1080, Intel UHD 630 iGPU and NVIDIA GeForce RTX 2060 (6GB GDDR6)

Sony FDR-AX53e Video camera, DJI Osmo Action 3 and Sony HDR-AS30V Sports cams.

terrypin wrote on 11/9/2017, 9:24 AM

Thanks John, that seems reassuring, but I thought the GPS Timestamp was supposed to be UTC (or GMT as I call it)? Which is surely independent of DST and timezones? I assume it's also the timestamp you'd find in a GPX file downloaded from any GPS-enabled device, whether dedicated or inbuilt to a smartphone.

I'm wondering if perhaps different devices adjust the UTC value to get their 'GPS Timestamp' for the EXIF metadata? Presumably thinking that's more 'user friendly'? If so then IMO that defeats the purpose of a universal standard!

Do you have any examples in your files we can mull over please?

EDIT, more info:

Self explanatory screenshot showing an apparently correct result:

Last changed by terrypin on 11/9/2017, 9:25 AM, changed a total of 1 times.

Terry, East Grinstead, UK. PC: i7 6700K, 4.0 GHz, 32GB with Win 10 pro. Used many earlier versions of MEPP, currently mainly MEPP 2016 & 2017 (Using scores of macro scripts to add functionality, tailored to these versions.)

johnebaker wrote on 11/9/2017, 11:23 AM

Hi Terry

. . . . I thought the GPS Timestamp was supposed to be UTC . . . . I'm wondering if perhaps different devices adjust the UTC value to get their 'GPS Timestamp' for the EXIF metadata? Presumably thinking that's more 'user friendly'? . . . .

It is, and I think you are correct - some devices eg mobiles, automatically adjust their time to 'local time', based on the local phone network zone, however others, eg my old sat nav, used the GPS time data and then adjusted its local time to GPS+ locale offset, however, I had to set the locale - for some reason it did not use the GPS location to calculate the offset.

I seem to remember we have had a similar discussion before on this topic because my video camera gives 2 different time stamps based the 'home' timezone or, if the GPS is on, the GPS date time + locale offset derived from the cameras location, however this can be 1 hour out as DST, AFAICS, is not programmed into it, - the camera has a world map built into so I can see where video and pictures were taken 'in camera'.

HTH

John EB

VPX 16, Movie Studio 2025, and earlier versions 2015 and 2016, Music Maker Premium 2024.

PC - running Windows 11 23H2 Professional on Intel i7-8700K 3.2 GHz, 16GB RAM, RTX 2060 6GB 192-bit GDDR6, 1 x 1Tb Sabrent NVME SSD (OS and programs), 2 x 4TB (Data) internal HDD + 1TB internal SSD (Work disc), + 6 ext backup HDDs.

Laptop - Lenovo Legion 5i Phantom - running Windows 11 24H2 on Intel Core i7-10750H, 16GB DDR4-SDRAM, 512GB SSD, 43.9 cm screen Full HD 1920 x 1080, Intel UHD 630 iGPU and NVIDIA GeForce RTX 2060 (6GB GDDR6)

Sony FDR-AX53e Video camera, DJI Osmo Action 3 and Sony HDR-AS30V Sports cams.

terrypin wrote on 11/10/2017, 10:54 AM

Hi John,

Thanks for the helpful follow up. I've come to the conclusion we cannot rely on 'GPS TimeStamp' (with logical manual adjustment) as a confirmation of (or alternative to) 'Date TimeOriginal' for determining a JPG's local time taken.

I also reckon that for three of our five days in Italy my iPhone's time zone setting must somehow have been wrong. Can't fathom it because I just let it do its stuff automatically. And I think I'd have noticed if the home screen time was an hour slow! Unfortunately I've finished my MEP video for two of those three days, so I'm going to have to redo them.😟

Thanks for the help and have a good weekend.

 

 

 

Last changed by terrypin on 11/10/2017, 4:59 PM, changed a total of 2 times.

Terry, East Grinstead, UK. PC: i7 6700K, 4.0 GHz, 32GB with Win 10 pro. Used many earlier versions of MEPP, currently mainly MEPP 2016 & 2017 (Using scores of macro scripts to add functionality, tailored to these versions.)

browj2 wrote on 11/11/2017, 12:40 PM

Hi Terry,

I admire your precision. I try to avoid this, as I have enough trouble trying to find enough time to do anything much. Sometimes I do things by day, but I found that even that is problematic. Overnight travel camping was a problem, as I took photos and video upon arrival and/or the next morning prior to departure. I took the easy way out and did a VdG travel route per day, then everything along the way and at the destination, whether or not it was filmed the next day. Then started with the VdG for the next leg. I ran into problems with time zone changes and the cameras being out of sync with one on daylight savings, the other on standard, and then forgetting to change the time zone on top of it. So I just try to make a story out of it.

I'm off to Africa again in another week. Too much work, not enough Magix.

Regards,

John CB

John C.B.

VideoPro X(16); Movie Studio 2025 Platinum; Music Maker 2025 Premium Edition; Samplitude Pro X8 Suite; see About me for more.

Desktop System - Windows 10 Pro 22H2; MB ROG STRIX B560-A Gaming WiFi; Graphics Card Zotac Gaming NVIDIA GeForce RTX-3060, PS; Power supply EVGA 750W; Intel Core i7-10700K @ 3.80GHz (UHD Graphics 630); RAM 32 GB; OS on Kingston SSD 1TB; secondary WD 2TB; others 1.5TB, 3TB, 500GB, 4TB, 5TB, 6TB, 8TB, 12TB, 14TB; three monitors - HP 25" main, LG 4K 27" second, HP 27" third; Casio WK-225 piano keyboard; M-Audio M-Track USB mixer.

Notebook - Microsoft Surface Pro 4, i5-6300U, 8 GB RAM, 256 SSD, W10 Pro 20H2.

YouTube Channel: @JCBrownVideos

johnebaker wrote on 11/11/2017, 1:12 PM

Hi John CB

. . . . So I just try to make a story out of it. . . . .

Same here - often gey 'that shot' the next day or just prior to leaving somewhere. Artisitc licence comes in to play telling the story rather than the actual sequence of events.

However I can understand Terry's methodology particularly when covering walks/hikes, which by their nature tend to be one way and give only one chance to get the shots.

. . . . I'm off to Africa again in another week. Too much work, not enough Magix. . . . .

Too true 🙁

John EB

 

VPX 16, Movie Studio 2025, and earlier versions 2015 and 2016, Music Maker Premium 2024.

PC - running Windows 11 23H2 Professional on Intel i7-8700K 3.2 GHz, 16GB RAM, RTX 2060 6GB 192-bit GDDR6, 1 x 1Tb Sabrent NVME SSD (OS and programs), 2 x 4TB (Data) internal HDD + 1TB internal SSD (Work disc), + 6 ext backup HDDs.

Laptop - Lenovo Legion 5i Phantom - running Windows 11 24H2 on Intel Core i7-10750H, 16GB DDR4-SDRAM, 512GB SSD, 43.9 cm screen Full HD 1920 x 1080, Intel UHD 630 iGPU and NVIDIA GeForce RTX 2060 (6GB GDDR6)

Sony FDR-AX53e Video camera, DJI Osmo Action 3 and Sony HDR-AS30V Sports cams.

johnebaker wrote on 11/11/2017, 1:18 PM

Hi Terry

Had a thought after posting above - have you tried taking a photo of the data and time, eg written on a pad at the start of the day and used this as a relative reference for the remainder of the days photos?

IIRC you use one of the bulk renaming programs - and could you automatically fix the time issue by bulk adjustment using the actual time/date and the 'taken time' from the reference photo to working out the correct date/time for the remainder - hope that makes sense.

I have done this using one camera as a reference for the other (did not turn on GPS on my sportscam or time zone) with Advanced Renamer - using the delta option

John EB

Last changed by johnebaker on 11/11/2017, 1:24 PM, changed a total of 2 times.

VPX 16, Movie Studio 2025, and earlier versions 2015 and 2016, Music Maker Premium 2024.

PC - running Windows 11 23H2 Professional on Intel i7-8700K 3.2 GHz, 16GB RAM, RTX 2060 6GB 192-bit GDDR6, 1 x 1Tb Sabrent NVME SSD (OS and programs), 2 x 4TB (Data) internal HDD + 1TB internal SSD (Work disc), + 6 ext backup HDDs.

Laptop - Lenovo Legion 5i Phantom - running Windows 11 24H2 on Intel Core i7-10750H, 16GB DDR4-SDRAM, 512GB SSD, 43.9 cm screen Full HD 1920 x 1080, Intel UHD 630 iGPU and NVIDIA GeForce RTX 2060 (6GB GDDR6)

Sony FDR-AX53e Video camera, DJI Osmo Action 3 and Sony HDR-AS30V Sports cams.

terrypin wrote on 11/11/2017, 4:41 PM

Hi John CB,

Africa again so soon - you’re almost a commuter! Bon voyage.

Hi John EB,

My forensics include very similar operations to those you suggest and a whole bunch of other stuff. Even spent an hour this afternoon using shadow measurement to help me distinguish between photos taken at hh:mm or hh+1:mm! You can walk a long way in an hour. 🙂And it’s annoying to discover a bunch of photos or movies time-stamped wrongly after that day’s project has been rendered.

The simplest approach remains the best IMO: include a watch or clock in the material as frequently as possible! Coupled with GPS data, that’s pretty well certain to let you time stamp everything correctly with minimal effort.

Terry, East Grinstead, UK

Terry, East Grinstead, UK. PC: i7 6700K, 4.0 GHz, 32GB with Win 10 pro. Used many earlier versions of MEPP, currently mainly MEPP 2016 & 2017 (Using scores of macro scripts to add functionality, tailored to these versions.)