Professional G-Earth KML files

Joined
Apr 26, 2014
Messages
203
Reaction score
25
Location
Newbury, UK
Apple Mac. I'm having no trouble getting the .DAT flight logs off the iPad (via iTunes) and converting them to CSV (via flylitchi.com). But I would like to convert the CSVs to .KML files for import into Google Earth. A KML will use latitude, longitude and altitude to display your flight on Earth's map very accurately.

Has anybody found a good way to convert CSV -> KML?
 
Joined
Apr 6, 2015
Messages
276
Reaction score
82
Not a bad way for flylitchi to collect and analyze our flight data. With that kind of info they could create an awesome app?
 
Last edited:
Joined
Apr 6, 2015
Messages
276
Reaction score
82
Capture.JPG


a cool method of analyzing a flight in 3D when viewed with google earth. I think it will be very helpful to determine P3 errant behaviour

here is the process, not automatic am afraid...

output the csv
open it in Excel or Google sheets
delete all the columns except lat,lon,altitude
switch the lat & lon columns VERY NB
delete the row with the header
save/download as csv
open the csv in wordpad
copy the contents (should be no extra commas)
open the kml file in notepad
replace coordinates
edit the other obvious text as required

here is the kml file code

<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Document>
<name>Stephan’s Drone flight</name>
<description>Add your own description here. This flight occured on blah blah blah</description>
<Style id="yellowLineGreenPoly">
<LineStyle>
<color>7f00ffff</color>
<width>4</width>
</LineStyle>
<PolyStyle>
<color>7f00ff00</color>
</PolyStyle>
</Style>
<Placemark>
<name>My Drone Flight</name>
<description>Stephan's Drone Flight</description>
<styleUrl>#redLine</styleUrl>
<LineString>
<altitudeMode>absolute</altitudeMode>
<coordinates>
long,lat,height

</coordinates>
</LineString>
</Placemark>
</Document>
</kml>

garnish as required...

the reason for some of the flight being missing is because this example was on the side of a mountain and Google's elevation model is not perfect so appears if drone has gone sub terranean

graph.jpg
 
Last edited:
  • Like
Reactions: taroh
Joined
Apr 26, 2014
Messages
203
Reaction score
25
Location
Newbury, UK
Thanks to all for your help. I did manage to create aKML and view it in Earth - as a zillion yellow push pins! Needs more work. I like Stephan's approach and next I must find out how to get his white line rather than all the push pins.
 
Joined
Jun 1, 2015
Messages
33
Reaction score
14
Hi,

I'm using the uavforecast site to convert my Ipad log files.
This one gives you the csv log as well as a KML file in a minute ! ;)

DJI Log Converter

Dan
 
Joined
Apr 26, 2014
Messages
203
Reaction score
25
Location
Newbury, UK
Thanks DanH. Unfortunately the site repeatedly reports server errors!
 
Joined
Jun 1, 2015
Messages
33
Reaction score
14
I tried it a minute ago and it reports a server error as well !
Hopefully it will be back online soon !
 
Joined
Apr 26, 2014
Messages
203
Reaction score
25
Location
Newbury, UK
DanH - I can tell you that having just tried this morning it all seems to be working well, including a KML export.
Stephan - the KML provides a proper tracking line. It looks great!
Thanks to all.
 

New Threads

Forum statistics

Threads
135,781
Messages
1,404,699
Members
98,855
Latest member
johnvanlit