Advertisements

An original point of view

GIS, Tourism, Transport

How to show your flight route in Google Earth?

Ryanair flight route Google Earth from Zadar to London

Ryanair flight from Zadar (ZAD) to London Stansted (STN) Google Earth flying route example

 

     There is a lot of real-time flight trackers and at least a few flight archives on the web. Some of them offer to purchase the data. After purchasing you are receiving full flight data, ready for further manipulation. The most popular flight tracker with a big flight data history is the Flightradar24.com. There is also the option to get this data in .csv or .kml file however only for users, who decided to purchase at least a silver account. Moreover downloading this data is restricted and for the cheapest option, the limit is 10 per month only. I realize, that you don’t need more, because usually, you fly not often than 10 times per month  (considerate your own flights only). Nonetheless is quite uncomfortable being reliant for this server without a chance to display your flight in a different software than map provided there.

Flighradar24.com flight list

Pic. 1 The Flightradar24.com service offers only flight simulation back up to 7 days. The .kml and .csv files are not available for basic account.

Let’s consider the different options then. Before I will come across my own example with the last flight I would like to tell you about the most convenient options to gain the .kml data from your flight. There are 2 other live flight trackers  (as far as I know) with accessible data of the flight. Besides, there are other options to display the flights provided on the GitHub platform. Back to the web trackers for Americans, the most convenient is to be the Flightwise.com. At least a few advice can be found on the web on how to use flight information from Flightwise.com on Google Earth. One of them you can see in the movie below.

My example is based on the Flightaware.com, which has a pretty good archival flights database. Writing pretty good I mean not equal the Flightradar24.com but still OK. When finding your flight you have insight into the flight log data. The “View track log” option is very useful for preparing your .kml file in the future. All details about the preparation of your flight data you can see in the video below.

The movie above doesn’t cover the moment of data manipulation in MS Excel. I will show you step by step how to do it on my own example. This is the flight from Zadar (ZAD) to London Stansted (STN) operated by Ryanair. You can see the overview of your flight when finding it on this website (Pic. 2). Once you copied the data, you should have the table in MS Excel that looks like this below (Pic.3).

Ryanair flight example on Flightaware.com

Pic. 2 The overview of your flight when finding it on the Flightaware.com website.

Ryanair flight example on Flightaware.com transferred to MS Excel

Pic. 3 The output flight log table in MS Excel.

  1. The table copied to MS Excel looks almost the same. I mean almost the same, because (possibly you have spotted it) some values have been copied wrong. You can get rid of these mismatches and adjust this table following the steps below.
  2. Some columns are not necessary for our flight details. Obviously, you don’t have to do the same as me. This is my example only. I decided to remove 3 columns: “Direction“, “Rate” and “Reporting facility”. I don’t need the direction when I have the azimuth in the “Course” column. I don’t need the rate too because I am not interested in how many meters the plane have ascended/descended in past time interval. Basically, all I need is: “Longitude”, “Latitude”, “Time” and “Meters” (altitude).

    Ryanair flight example on Flightaware.com, important columns in MS Excel

    Pic. 4 Selected unnecessary columns are to be deleted.

  3. Once you remove unnecessary columns remember about unnecessary rows too. There are 3 on the top and another 2 on the very bottom.

    Ryanair flight example on Flightaware.com with rows not needed in MS Excel

    Pic. 5 Selected unnecessary rows are to be deleted.

  4. Now is the time to make our data tidy. As I have written earlier there are some discrepancies between values on the website log and values copied to the MS Excel document (time and meters). The values look like they have been copied twice to the same row and appear as string text. Our current task is to convert this text to separate columns. Before you do this make sure, that you selected proper rows. Remember to avoid the 1st row with the column name and repeat this for each group values (e.g separately for values from 100 to 999, next from 1000 to 9999, etc) to avoid further inconsistencies as per below. The value should have a fixed width.
    MS Excel Data column and Text to columns option

    Pic. 6 In the “Data” section select the “Text to column” option.

    Ryanair flight data manipulation in MS Excel

    Ryanair flight data manipulation in MS Excel

    Pic. 7, 8 Conversion text to the column: firstly for the values lower than 1000.

    Ryanair flight data manipulation in MS Excel, putting text to column

    Ryanair flight data manipulation in MS Excel

    Pic. 9, 10 Conversion text to the column for the values between 1000 and 9999.

  5. Fine! Now you have created a new column. Using this column seems to be more comfortable, because there are no comas. So let’s copy the “Meters” column name to our newly created column and delete the old one.

    Ryanair flight data manipulation in MS Excel meters above ground

    Pic. 11 The old “Meters” column is going to be removed.

  6. You have to make similar steps within the “Time” column. I have got the BST (British Summer Time) – GMT+1 due to the time zone in your destination airport. Initially, you have a weekday and 2 types of time descriptions set as strong.  In terms of this, you will need to insert 2 new columns between the “Time” and “Latitude” where you finally embed the time values converted. I have chosen the hh-mm format,  because in my opinion is more readable. Besides the log is actualized around twice per minute.
    Ryanair flight data manipulation in MS Excel

    Pic. 12 Insert 2 new columns where you will put the converted data.

    Ryanair flight data manipulation in MS Excel real time aircraft position

    Ryanair flight data manipulation in MS Excel, real time aircraft position

    Pic. 13, 14. Converting the time values.

  7. Sometimes you can see the alert as per below. Don’t worry about it just click OK. We are going to replace the leftmost column, another two will be used for newly converted data input.

    Pic. 15 Alert about the data in our output columns. Click OK to replace it.

  8. Now when you have the “Time” issues sorted remove unnecessary columns making your table clear.

    Ryanair flight data manipulation in MS Excel, time section

    Pic. 16 First, two leftmost columns are going to be deleted.

  9. The last step is removing repeatable rows or as you wish more rows can be removed depends on how “dense” route would you like to have. I decided to leave everything as it stands just without 2 repeatable rows near the top.

    Ryanair flight data manipulation in MS Excel, removing repeteable rows

    Pic. 17 Look on the “Time” column and find the repeatable values, then remove them.

  10.  Save your file in .csv format, which is recognizable by Google Earth software. Ryanair flight data manipulation in MS Excel, CSV format saving

Great! Now you have the .csv file ready to input to Google Earth. There are solutions on the web on how to do this. The process is quite simple like in the video shown below. The issues with import Excel data to Google Earth has been raised in an earlier article. Just in case you can see the video with the instruction below.

The difference between the standard process of input the MS Excel data to Google Earth lies in the data specification. You cannot follow the aforementioned movie exactly step by step because you have to specify your field types correctly.

As per the picture above the “Time UTC+1” field should have the string type because our time value contains the string of both numbers and symbols.  The “Latitude” and “Longitude” have to be set as the floating-point type. Otherwise, the tool will not interpret the flight track coordinates correctly. Finally, the route of your flight will not be shown correctly. Other fields should be set in the integer type.Ryanair flight data transfer from MS Excel to Google Earth

Considerating, that you came through the other steps and reached the moment of the “Style Template Settings” there are 2 very important factors, that you have to look at. First is the “Name” where it would be good to select from our “Time UTC + 1” column. If you miss this nothing wrong happened. Only your simple points on your route will not be identified. A much more important issue is “Height”, where we have basically 2 options. To simplify our process select “Clamp features to ground” and then click OK.

Ryanair flight data transfer from MS Excel to Google Earth, solumn settings

Pic. 20 Set the name field from the leftmost column.

Ryanair flight data transfer from MS Excel to Google Earth properties

Pic. 21 Choose the “Clamp features to ground” option, when you prefer to show your flight route in a terrestrial way.

As a result, you should get an awesome flight route between 2 airports. I have not selected the name field hence my route contains the signatures only. After the name field selection as per above, you should have a multitude of text alongside the route, which can be not comfortable enough for the smallest zoom. Anyway, your flight route in Google Earth has been generated. Now, when you zoom in close to the ground and click on one of the signatures the popup window will appear with all information provided to .csv file before (Pic. 23, 24). Basically, our flight route is ready then!…

Ryanair flying route shown in Google Earth

Pic. 22 My flight route ZAD-STN clamped to the ground.

Ryanair flying route local circumstances above Davos, Switzerland

Ryanair flying route local circumstances above Davos, Switzerland

Pic. 23, 24 The flight route details displayed in simple circumstances

…But some people can ask what about the real plane altitude during the flight???

You can also prepare the flight route with an altitude factor if you want. I am not going to remove clamped to the ground route. The new route will exist above the first one. Do the same steps as I have described above and when you get to the “Style Template Settings” again select the “Set height from field” option. As a field select the “Meters” column because this column contains the plane altitude data during the flight (Pic. 25). Other things do as per the image below. Remember to set minimum and maximum value the same both for meters and height. Otherwise, the altitude will not be displayed correctly. When does this go OK making your aerial flight route ready.

Ryanair flight route, height settings in Google Earth

Pic. 25 Set “Meters” column as a height field.

Ryanair flight altitude circumstances above Croatia

Ryanair flight altitude circumstances above United Kingdom

Pic. 26, 27 Our flight route is shown on almost real altitude.

Excellent! Now you can see both routes clamped to the ground (blue) and aerial  (yellowish). Unfortunately, it is one detail, that can make you slightly disappointed. All figures have been set relative to the ground, which means if your route passes above the mountainous area the real position will be elevated by the mountain altitude. To fix this problem you must right-click an object, choose the “Altitude” section and next choose the “Absolute” option. It will keep your flight altitude relative to the sea level. At this moment you have to do it one by one (sic!) because this problem has not been solved on Google Earth yet.Ryanair flight route single point edit in Google Earth

Ryanair flight route single point edit in Google Earth above Alps

Pic. 28, 29 Changing the altitude options from “Related to the ground” to “Absolute”.

Once you do this, you have got fully shown a flight route on Google Earth (Pic. 30, 31).Ryanair flight route in Google Earth above Alps

Ryanair flight route in Google Earth, terrestial and aerial version

Pic. 30, 31 Flight ZAD-STN above the Alps shown in Google Earth both in terrestrial and aerial versions.

Reconstruction of the flight route can be helpful mainly for flightseeing purposes. Having it shown in Google Earth you are able to simulate the cockpit view on the particular part of your flight and analyze what can you see or what have you seen during your journey. This solution can be useful for short flights, where is no information about the real-time plane position for passengers.

Mariusz Krukar

Links:

  1. https://flightaware.com/
  2. https://flightwise.com/
  3. GitHub flight tracker
  4. GitHub: Google Maps flight tracker
  5. 10 tips & tricks to make flying easier with Flight Track Pro.
  6. Tacview: KML real-life flight recordings
  7. Google Earth flight tracker and viewer
  8. Flight tracking layer from Flightwise.com
  9. Weird altitude effects in Google Earth
  10. Google Earth copy & paste trick
  11. Google Maps flight tracker for Flight Gear
  12. https://www.experts-exchange.com/questions/24918085/Google-Earth-can-you-move-multiple-placemarks-in-My-Places-to-new-folder-at-same-time.html
  13. Flightwise.com flight tracker discussion
  14. Select more than 1 place at once in Google Earth

 

Read also:

1. The flood simulation in Google Earth
2. Total solar eclipse visualization on Google Earth
3. Using Heywhatsthat.com to generate multiple summit-perspective views in Google Earth
4. How to show the coordinate grids in Google Earth and Google Maps?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advertisements
Follow

Get the latest posts delivered to your mailbox:

%d bloggers like this: