G-Earth KML files

[CallMeAlan]

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?

 

[bbfpv]

https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=csv to kml converter

 

[mikeboruta]

You could try the site "GPS Visualizer" I find it to be quite useful for many tasks like this. Here is a link:
http://www.gpsvisualizer.com/convert_input

 

[barefootbeachcombing]

GPS Visualizer is an awesome site. Lots of good tools there. Highly recommended.

 

[Stephan]

Not a bad way for flylitchi to collect and analyze our flight data. With that kind of info they could create an awesome app?

 

[Stephan]

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

 

[CallMeAlan]

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.

 

[Stephan]

@CallMeAlan, follow the directions and you have a line in about 3-4 minutes.

 

[DanH]

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

 

[CallMeAlan]

Thanks DanH. Unfortunately the site repeatedly reports server errors!

 

[DanH]

I tried it a minute ago and it reports a server error as well !
Hopefully it will be back online soon !

 

[CallMeAlan]

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.

 

[DanH]

You're welcome