For months our company has had issues getting any usable tagging data from the pixhawk and mission planner. We’ve tried everything from Drotag which was a hit and miss with tagging. Now I have to give Drotag credit because on a couple of missions it did tag the images, but without a decimal in the latitude and longitude which made the data unusable. we also resorted to using many 3rd party programs in order to tag the images. We thought it was hardware so we went from a regular pixhawk to a pixhawk 2.1 as well as replacing the gps. When that didn’t solve the issue we determined it was software. We then went looking into the csv of a tlog and found 40 rows of image commands out of 245,000 rows from a 5 minute flight. From there we extracted the raw lat and long data and made our own EO file. In the EO we were able to add the decimals as well as convert the altitude units. Below I’ve written a procedure of how to tag images using mission planner, along with “BR’sEXIFextractor” software.
Exporting image EXIF data
- Download and install a program called “BR’s EXIFextracter”
- Open and under choose files select the folder with the untagged photos that were taken during the mission
- Choose your output folder to place the Excel file in
- In select data select
Date & time
Width x height
- Once done selecting press on the “Extract button”
- Open the Excel file and sort column “A” from a to z in the Sort and Filter tab in the home tools window
Exporting data from Tlog
- Open mission planner
- On the flight data window select the “Telemetry Logs” tab underneath the artificial horizon
- Select “Tlog > Kml” or Graph button
- When the window pops up select the “Convert to CSV” button
- Select the Tlog from the mission you want to tag the photos on.
- Open up the CSV. It will be in the same place as the Tlog you opened to make the csv
- In Excel Press on the Q Column header so that the whole column is selected.
- Go and press on the Sort & Filter tab in the home tools window.
- In the drop-down press “Filter
- A drop-down box on the Q column header should pop up. Click on it then press select all to deselect everything and scroll then select the “alt_msl” variable
- Make sure that the amount of cell rows matches the number of photographs you’re tagging
- To double check if the times are in order select the “A” column header so everything is selected in it.
- Select Sort & Filter again and press “Sort A to Z”
- Select all values in columns N, P, and R by holding control and dragging your mouse over them.
- Once all of the values from those three columns are selected, copy them to the right of your exif data exported from your images in the other Excel file opened.
Adding a decimal and converting the altitude values
22. In cell “H1” type =REPLACE(E1,5,0,”1”)
23. In cell “I1” type =REPLACE(D1,3,0,”.”)
24. In cell “J1” type =(G1*3.28084) This step is to convert meters to feet. Ignore it if you want
25. One at a time drag the right bottom corner of the cells of H1, I1, and J1 down to the last row with data in it.
26. All of the rows should have values now
27. select all of the data from columns H1, I1, and J1 and copy it.
28. Select cell “E1” and paste as VALUES ONLY
29. Save the file where you can find it to add in as an input for the geolocations of the images
Leave a reply if you have any questions. Hopefully this will save a lot of people money and time. It beats buying a 6k ppk system just to tag your photos correctly.