I have video frame grabs (jpg) from drone imagery. I need to have the images geotagged with latitude, longitude, and elevation. I have a csv file that has the image name, latitude, latitude, and elevation. The latitude and longitude are in decimal degrees. Is there a method of using the csv file to geo tag the images. Each row of the csv file has the photo name, lat, long, and elevation.
I don't know how to do this in the GUI, but from the command line this is possible if you add the following header line at the top of the CSV:
SourceFile,GPSlatitude,GPSLongitude,GPSElevation
From the command line, this would be:
exiftool -csv=YOURCSVFILENAME *.jpg
But you should probably also write GPSLatitudeRef, GPSLongitudeRef and GPSElevationRef. Assuming north/west and above sea level, it would be:
exiftool -csv=YOURCSVFILENAME -gpslatituderef=N -gpslongituderef=W -gpsaltituderef=above *.jpg
- Phil
Standard copy/paste, As per the stickied thread (https://exiftool.org/forum/index.php?topic=4553.0), the exiftoolGUI no longer has support from it's author.
"GPSElevation" should be GPSAltitude in Phil's post.
Alternatively, you could select the GPSlatitude,GPSLongitude,GPSAltitude columns in a spreadsheet program, copy/paste them as new columns, and then append "Ref" to the end. The final CSV file would look like
Sourcefile,GPSlatitude,GPSLongitude,GPSAltitude,GPSlatitudeRef,GPSLongitudeRef,GPSAltitudeRef
/path/to/file.jpg,40.6892,-74.0445,10,40.6892,-74.0445,10
Exiftool is smart enough to figure out the N/S/E/W/Above/Below referencess directly from the numbered coordinate.
If the SourceFile only contains the filename, then you must run the command from the directory that contains the files.
Quote from: StarGeek on December 02, 2022, 11:05:41 AM"GPSElevation" should be GPSAltitude in Phil's post.
Ooops. Thanks!
- Phil
Thank you both for your help with this. After several trial and error attempts the following seemed to work:
exiftool -csv=73-EXIF-Simple.csv -gpslatituderef=N -gpslongituderef=W -gpsaltituderef=above -Make=Autel_Robotics -CameraModel=XT709 -FocalLength=4.7 *.jpg
The csv file contains the following (first few lines shown):
SourceFile,GPSlatitude,GPSLongitude,GPSAltitude,DateTimeOriginal
73_00_01.jpg,39.5574104928,-110.7651502383,1759,2022:11:21 12:00:01
73_00_02.jpg,39.5573632892,-110.7650991671,1759,2022:11:21 12:00:02
73_00_04.jpg,39.5573160856,-110.7650480959,1759,2022:11:21 12:00:04
I am not sure that the code added the camera model XT709 to the images exif data as it does not show up. Also the focal length seems to be rounded to 5.
The bottom line is that the images have been accepted by the orthomosaic program I use.
Thank you both so much for your help.
You should be writing "Model" instead of "CameraModel".
The 4.7 should be there -- use the -n option when extracting to avoid the round-off.
- Phil
New posts added to this thread were moved here (https://exiftool.org/forum/index.php?topic=16631.0)