Find Airport Locations

This example looks at airport locations, their altitude and where they are most dense on Earth. What will become apparent is that often a large amount of a data scientist time is devoted to making sure the data is clean and complete and that missing values are treated correctly.

A commonly used database for worldwide airport locations is available from this website.

In order to query the data, you have to construct an EntityStore and register it.

Here is how many airports are present in this dataset.

And what properties they have.

What are the most extreme airports by elevation?

You can select all airports over 3000 meters above sea level.

There are 10 of them. Find out where they are.

You can visualize where they are in the world.

There appear to be a lot of airports at a position that looks suspiciously like the (0,0) coordinates.

There are in fact a large number of them that appear to have missing coordinates; filter them out.

Now you can look at all the points.