Forum

Author Topic: Use Geo location and yaw/pitch/roll from a csv instead of EXIF  (Read 667 times)

iaerobotics

  • Newbie
  • *
  • Posts: 18
    • View Profile
I have a csv file that lists the name of an image, its corrected GPS location, Altitude, Yaw/Pitch/Roll based on a INS trajectory. How can I update the imported phots to use this corrected data instead of what was imported from the EXIF?

Sample CSV file...
File,Latitude,Longitude,Altitude,Omega,Phi,Kappa,Week,GPSTimeOfWeek
1-001-SEAG000007.JPG,32.871815101700001,-111.7738095111,393.48200000000003,179.17115877410916,-179.68127459227892,4.4593806406064935,,2353,577351.47900009155
1-001-SEAG000008.JPG,32.871815101700001,-111.7738095111,393.48200000000003,179.17521728767403,-179.68538982084593,4.4591635429383096,,2353,577353.48000001907
1-001-SEAG000009.JPG,32.871815101700001,-111.7738095111,393.48200000000003,179.17715721323125,-179.68448463918335,4.4639890248579892,,2353,577355.48000001907
1-001-SEAG000010.JPG,32.871815101700001,-111.7738095111,393.48200000000003,179.17831020034396,-179.68678701404116,4.4647425969004617,,2353,577357.47900009155
1-001-SEAG000011.JPG,32.871815101700001,-111.7738095111,393.48200000000003,179.17993543053154,-179.69103286405917,4.4672304927127291,,2353,577359.47900009155



Paulo

  • Hero Member
  • *****
  • Posts: 1456
    • View Profile
Re: Use Geo location and yaw/pitch/roll from a csv instead of EXIF
« Reply #1 on: March 04, 2025, 06:58:42 AM »
Hi iaerobotics,

just use the Import Reference button from Reference pane, choose csv and set up CS, import columns assignment,  ....

see following:
Best Regards,
Paul Pelletier,
Surveyor

iaerobotics

  • Newbie
  • *
  • Posts: 18
    • View Profile
Re: Use Geo location and yaw/pitch/roll from a csv instead of EXIF
« Reply #2 on: March 04, 2025, 07:06:27 AM »
I tried that. But it just creates a bunch of markers (even when I say cameras and not markers or both). It does not update the info for the loaded photos.

Paulo

  • Hero Member
  • *****
  • Posts: 1456
    • View Profile
Re: Use Geo location and yaw/pitch/roll from a csv instead of EXIF
« Reply #3 on: March 04, 2025, 08:52:04 AM »
I would suggest to look at strip file  extensions to camera labels in Preferences Advanced options ... Maybe untick and try again....
Best Regards,
Paul Pelletier,
Surveyor

iaerobotics

  • Newbie
  • *
  • Posts: 18
    • View Profile
Re: Use Geo location and yaw/pitch/roll from a csv instead of EXIF
« Reply #4 on: March 04, 2025, 04:33:57 PM »
I was able to get it to work. But the csv has to have exact matches or it will not work. My process is to import photos, remove photos I do not want in processing, then import the csv. When I import photos, import csv then remove photos it works. Thanks for the help.