{"id":207,"date":"2023-06-08T21:09:00","date_gmt":"2023-06-08T20:09:00","guid":{"rendered":"https:\/\/zdebla.me\/?p=207"},"modified":"2023-07-14T09:36:58","modified_gmt":"2023-07-14T08:36:58","slug":"top-airport-pairs-and-their-arrival-delay","status":"publish","type":"post","link":"https:\/\/zdebla.me\/index.php\/2023\/06\/08\/top-airport-pairs-and-their-arrival-delay\/","title":{"rendered":"Top airport pairs, delays and airport information"},"content":{"rendered":"\n
\"\"<\/a><\/figure>\n\n\n\n

This is the most complex project I have created so far. To open it in the Tableau public profile, please click <<here>><\/a> or on the image above. The first page gives you more information on the contents. You can also view a static Powerpoint overview of the content <here><\/a>, which however obviously lacks the interactivity of the live visualisations.<\/p>\n\n\n\n

How I gathered, transformed, cleaned and modeled the data for this visulisation, you can read in this article<\/a>.<\/p>\n\n\n\n

Please note that the country borders don’ t reflect the shape of FIRs and the thus the areas of responsibility of the national ANSPs<\/em>, additionally MUAC is missing from the map. I could visualise the FIRs boundaries by using a geojson file, nevertheless the source en-route data is provided by country.<\/em><\/p>\n\n\n\n

Copyright notice and disclaimer:<\/em><\/p>\n\n\n\n

Eurostat <\/strong>has a policy of encouraging free re-use of its data, both for non-commercial and commercial purposes.<\/em><\/p>\n\n\n\n

The delay data is published by the EUROCONTROL <\/strong>Performance Review Unit in the interest of the exchange of information. It may be copied in whole or in part providing that this copyright notice and disclaimer are included.<\/em><\/p>\n\n\n\n

Data relationships and dictionary<\/strong><\/p>\n\n\n\n

The figure below shows how the data in the visualisation are modeled (relationships between them).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

And the data dictionary (metadata):<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

This is the most complex project I have created so far. To open it in the Tableau public profile, please click <<here>> or on the image above. The first page gives you more information on the contents. You can also view a static Powerpoint overview of the content <here>, which however obviously lacks the interactivity […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-207","post","type-post","status-publish","format-standard","hentry","category-projects"],"_links":{"self":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/comments?post=207"}],"version-history":[{"count":16,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/207\/revisions"}],"predecessor-version":[{"id":399,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/207\/revisions\/399"}],"wp:attachment":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/media?parent=207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/categories?post=207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/tags?post=207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}