Warning message using the Geolocate feature on some MP4 files

Started by FrankB, March 17, 2024, 05:23:34 AM

Previous topic - Next topic

FrankB

@Moderators: Not sure if this topic belongs here, or in the ExifToolGui section. Feel free to move if it belongs there.

@Phil.

In ExifToolGui I'm using this command to geolocate files.
-XMP-photoshop:XMP-iptcCore:XMP-iptcExt:geolocate<GPSPosition -api geolocation <list of files>

For some MP4 files I get a warning 'No such city in Geolocation database'. What is wrong with it I dont know, but the message makes no sense to me. If I use the same function, with the same coordinates on a JPG it works fine.

Note: The version V6.3.0. that I released yesterday uses the command you proposed earlier:
-geolocate<GPSPosition -api geolocation -xmp:LocationShownCountryCode<GeolocationCountryCode -xmp:LocationShownCountryName<GeolocationCountry -xmp:LocationShownProvinceState<GeolocationRegion -xmp:LocationShownCity<GeolocationCity <list of files>
But the results are the same.

I have compared an MP4 file that gives the warning, with an MP4 that gives no warning. This might be a clue.

No warning (Coordinates stored in Userdata):

---- UserData ----
PlayMode: SEQ_PLAY
GPSCoordinates: nn°nn.nnnn Y, n°nn.nnn X
---- Keys ----
AndroidVersion: xx


Warning (Coordinates stored in ItemList):
---- UserData ----
PlayMode: SEQ_PLAY
DateTimeOriginal: dddd:dd:dd tt:tt:tt+tt:tt
---- ItemList ----
GPSCoordinates: nn°nn.nnn Y, n°nn.nnn X, 0 m Above Sea Level
---- Keys ----
AndroidVersion: xx

Commands and Log used:
- Starting point. Gps coordinates filled, All XMP cleared.

-g -a -xmp:all -gps* K:\test\2023-08-25\_IGP0008.jpg K:\test\2023-08-25\20211129_152602.mp4

Shows this:
======== K:/test/2023-08-25/_IGP0008.jpg
---- EXIF ----
GPS Version ID                  : 2.3.0.0
GPS Latitude Ref                : North
GPS Latitude                    : 50°20.6427
GPS Longitude Ref               : East
GPS Longitude                   : 7°32.8860
---- Composite ----
GPS Latitude                    : 50°20.6427 N
GPS Longitude                   : 7°32.8860 E
GPS Position                    : 50°20.6427 N, 7°32.8860 E
======== K:/test/2023-08-25/20211129_152602.mp4
---- QuickTime ----
GPS Coordinates                 : 50°20.6430 N, 7°32.8860 E, 0 m Above Sea Level
---- Composite ----
GPS Altitude                    : 0 m
GPS Altitude Ref                : Above Sea Level
GPS Latitude                    : 50°20.6430 N
GPS Longitude                   : 7°32.8860 E
GPS Position                    : 50°20.6430 N, 7°32.8860 E
    2 image files read
{ready24}

Execution of:
-XMP-photoshop:XMP-iptcCore:XMP-iptcExt:geolocate<GPSPosition -api geolocation K:\test\2023-08-25\_IGP0008.jpg K:\test\2023-08-25\20211129_152602.mp4

Returns: (Notice the warning)
======== K:/test/2023-08-25/_IGP0008.jpg
======== K:/test/2023-08-25/20211129_152602.mp4
    2 image files updated
Warning: No such city in Geolocation database - K:/test/2023-08-25/20211129_152602.mp4

But both files are updated correctly (As far as I can see):

-g -a -xmp:all -gps* K:\test\2023-08-25\_IGP0008.jpg K:\test\2023-08-25\20211129_152602.mp4

======== K:/test/2023-08-25/_IGP0008.jpg
---- EXIF ----
GPS Version ID                  : 2.3.0.0
GPS Latitude Ref                : North
GPS Latitude                    : 50°20.6427
GPS Longitude Ref               : East
GPS Longitude                   : 7°32.8860
---- XMP ----
XMP Toolkit                     : Image::ExifTool 12.79
Country Code                    : DE
Location Shown City             : Koblenz
Location Shown Country Code     : DE
Location Shown Country Name     : Germany
Location Shown Province State   : Rheinland-Pfalz
Location Shown GPS Latitude     : 50°21.2160 N
Location Shown GPS Longitude    : 7°34.7280 E
City                            : Koblenz
Country                         : Germany
State                           : Rheinland-Pfalz
---- Composite ----
GPS Latitude                    : 50°20.6427 N
GPS Longitude                   : 7°32.8860 E
GPS Position                    : 50°20.6427 N, 7°32.8860 E
======== K:/test/2023-08-25/20211129_152602.mp4
---- QuickTime ----
GPS Coordinates                 : 50°20.6430 N, 7°32.8860 E, 0 m Above Sea Level
---- XMP ----
XMP Toolkit                     : Image::ExifTool 12.79
Country Code                    : DE
Location Shown City             : Koblenz
Location Shown Country Code     : DE
Location Shown Country Name     : Germany
Location Shown Province State   : Rheinland-Pfalz
Location Shown GPS Latitude     : 50°21.2160 N
Location Shown GPS Longitude    : 7°34.7280 E
City                            : Koblenz
Country                         : Germany
State                           : Rheinland-Pfalz
---- Composite ----
GPS Altitude                    : 0 m
GPS Altitude Ref                : Above Sea Level
GPS Latitude                    : 50°20.6430 N
GPS Longitude                   : 7°32.8860 E
GPS Position                    : 50°20.6430 N, 7°32.8860 E
    2 image files read

Additional info:
Also if you're not updating the files, but use this command:
-api geolocation -geolocation* <list of files>
the same warning appears for the MP4 file, not for the JPG

Privacy note: This is not my home location, just an hotel where I once stayed.

wywh

Altitude seems to confuse Geolocation in movies:

exiftool -overwrite_original -Keys:GPSCoordinates='48.1375, 11.5755, 119.9' a.mp4

exiftool -a -G1 -s -n -GPSCoordinates a.mp4                                     
[Keys]          GPSCoordinates                  : 48.1375 11.5755 119.9

exiftool -api Geolocation '-Geolocation*' a.mp4                                 
Warning: No such city in Geolocation database - a.mp4

exiftool -overwrite_original -Keys:GPSCoordinates='48.1375, 11.5755' a.mp4       

exiftool -a -G1 -s -n -GPSCoordinates a.mp4                               
[Keys]          GPSCoordinates                  : 48.1375 11.5755

exiftool -api Geolocation '-Geolocation*' a.mp4                           
Geolocation City                : Munich
Geolocation Region              : Bavaria
Geolocation Subregion           : Upper Bavaria
Geolocation Country Code        : DE
Geolocation Country             : Germany
Geolocation Time Zone           : Europe/Berlin
Geolocation Population          : 1300000
Geolocation Position            : 48.1375, 11.5755
Geolocation Distance            : 0.00 km

- Matti

FrankB

I can confirm that the Altitude makes a difference. Very good catch!

Phil Harvey

Thanks.  I'll fix this.  Edit: this was already fixed in my current working version. :)

But Frank, your command:

Quote-XMP-photoshop:XMP-iptcCore:XMP-iptcExt:geolocate<GPSPosition -api geolocation <list of files>

Should not be using the API Geolocation option.  That option is only used to generate the GeolocationXxx tags, which you are not using here.

- Phil
...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

FrankB

Thanks Phil,

- For looking into the warning message
- For pointing out the needless use of '-api geolocation'. Even worse without it the warning would not have appeared.

Will fix it in GUI.

Frank

Phil Harvey

...where DIR is the name of a directory/folder containing the images.  On Mac/Linux/PowerShell, use single quotes (') instead of double quotes (") around arguments containing a dollar sign ($).

FrankB

Hi Phil,

Works as expected. Thanks.

Frank

P.S.: GeoLocation is a hot topic, looking at the nr of posts lately. You opened a can!