Welcome to PhantomPilots.com

Sign up for a weekly email of the latest drone news & information

Professional G-Earth KML files

Discussion in 'Phantom 3 Help' started by CallMeAlan, Jun 12, 2015.

  1. CallMeAlan

    Joined:
    Apr 26, 2014
    Messages:
    203
    Likes Received:
    23
    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?
     
  2. mikeboruta

    Joined:
    Dec 5, 2013
    Messages:
    41
    Likes Received:
    1
    Location:
    Ouray, Colorado
  3. barefootbeachcombing

    Joined:
    Nov 2, 2014
    Messages:
    509
    Likes Received:
    107
    Location:
    US
    GPS Visualizer is an awesome site. Lots of good tools there. Highly recommended.
     
  4. Stephan

    Joined:
    Apr 6, 2015
    Messages:
    276
    Likes Received:
    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?
     
    #5 Stephan, Jun 12, 2015
    Last edited: Jun 12, 2015
  5. Stephan

    Joined:
    Apr 6, 2015
    Messages:
    276
    Likes Received:
    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
     
    #6 Stephan, Jun 13, 2015
    Last edited: Jun 13, 2015
    taroh likes this.
  6. CallMeAlan

    Joined:
    Apr 26, 2014
    Messages:
    203
    Likes Received:
    23
    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.
     
  7. Stephan

    Joined:
    Apr 6, 2015
    Messages:
    276
    Likes Received:
    82
    @CallMeAlan, follow the directions and you have a line in about 3-4 minutes.
     
  8. DanH

    Joined:
    Jun 1, 2015
    Messages:
    33
    Likes Received:
    13
    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
     
  9. CallMeAlan

    Joined:
    Apr 26, 2014
    Messages:
    203
    Likes Received:
    23
    Location:
    Newbury, UK
    Thanks DanH. Unfortunately the site repeatedly reports server errors!
     
  10. DanH

    Joined:
    Jun 1, 2015
    Messages:
    33
    Likes Received:
    13
    I tried it a minute ago and it reports a server error as well !
    Hopefully it will be back online soon !
     
  11. CallMeAlan

    Joined:
    Apr 26, 2014
    Messages:
    203
    Likes Received:
    23
    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.
     
  12. DanH

    Joined:
    Jun 1, 2015
    Messages:
    33
    Likes Received:
    13
    You're welcome ;)