Extract/Copy Latitude & Longitude from MOV files to a Text/Spreadsheet File

Question

ggm1960 Author

Level 1

4 points

Extract/Copy Latitude & Longitude from MOV files to a Text/Spreadsheet File

I'm going through a big collection of video (mov) files that we've shot while traveling. I'm pinpointing location using 'Command I' where I can copy the latitude/longitude info and paste. This is a tedious, time consuming process when there are 100s of files to go through. I've searched but don't see an app that could speed up the process by extracting this data from a list of files and saving the data to a file. If this makes any sense I'd truly appreciate any leads on an app or better method for this, thanks!

MacBook Pro 16″

Posted on Aug 28, 2023 2:40 PM

Reply

Answer 1

Aug 28, 2023 10:35 PM in response to ggm1960

I use exiftool for this:

exiftool -a -G1 -s -n --ext csv -api LargeFileSupport=1 -Composite:GPSPosition . > locations.csv

======== ./2023-0718-2051-28.mp4
[Composite]     GPSPosition                     : 24.5551 -81.7793
======== ./2023-0718-1851-00.mp4
[Composite]     GPSPosition                     : 41.8667 -87.6099
======== ./2023-0718-1853-00.mp4
[Composite]     GPSPosition                     : 28.524 -80.6508
======== ./2023-0718-1851-28.jpg
[Composite]     GPSPosition                     : 28.3768 -81.5493
======== ./2023-0719-0708-02.jpg
[Composite]     GPSPosition                     : 24.5551 -81.7793
======== ./2023-0719-0732-09.mp4
[Composite]     GPSPosition                     : 40.7114 -74.0133

With more options you get more tags like date, camera model, description etc in a .csv. I use that for proof-reading metadata in a spreadsheet with something like:

exiftool -a -G1 -s -n -r -api LargeFileSupport=1 -fileOrder5 FileName -api QuickTimeUTC=1 -System:FileName -MacOS:FileCreateDate -System:FileModifyDate -QuickTime:CreateDate -Keys:CreationDate -ExifIFD:DateTimeOriginal -ExifIFD:OffsetTime -IFD0:Make -Keys:Make -IFD0:Model -Keys:Model -IFD0:Software -Keys:Software -Composite:GPSPosition -XMP-xmp:Rating -Keys:UserRating -IPTC:Caption-Abstract -XMP-dc:Description -Keys:Description -IPTC:Keywords -XMP-dc:Subject -Keys:Keywords -csv . > out.csv

Reply

Answer 2

ggm1960 Author

Level 1

4 points

Aug 29, 2023 8:58 AM in response to Matti Haveri

Appreciate the response, exiftool is what keep showing up in searches. I had hoped to get away from command line programs but I went ahead and installed that program and will try it.

Reply