ropensci-archive/ozflights

:no_entry: ARCHIVED :no_entry: Get Australian Flight Data, 1985-2016

ozflights

This repository has been archived. The former README is now in README-NOT.md.

ozflights's Issues

install code on README

needs to be fixed:

devtools::install_github("ropenscilabs/ozflights")

Basic documentation, rationalising that in source spreadsheet + website

Uses the annual airport traffic data from the Australian Government Department of Infrastructure and Regional Development located at: https://bitre.gov.au/publications/ongoing/airport_traffic_data.aspx

Package author notes:

Data was available at URL as at 17/10/26. Data is imported into R and cleaned by removing redundant headers and transforming into a tidy format.

Airport ranking variable was removed: the interested party can recalculate.

Contact details for the data itself can be found in the original spreadsheet, but please don’t contact the aviation stats team for problems with the package!

Beware: there are both Australian totals and individual airport figures in the tables- you may wish to filter either out.

From the publication notes:

This publication presents time series data on scheduled Regular Public Transport (RPT) services at selected Australian airports by calendar year over the period 1986 to 2016.

Coverage: Data is derived from International and Domestic (including Regional) RPT services, and does not include charter or other non-scheduled activity. Data is presented on all Australian airports with more than 7,000 revenue passenger movements during 2016, except for Avalon Airport which is excluded for commercial-in-confidence reasons.

Information on revenue passengers and aircraft movements is provided for all airports that meet the criteria above. Freight and mail data is also provided for those airports receiving international services. Domestic mail and freight data has been excluded as the dataset is incomplete.

Basis for collection:

The data in this report is presented separately for International and Domestic (including Regional) airline sectors. International airlines are those airlines operating RPT services into or out of Australia. Domestic airlines are those operating RPT services between two Australian airports. From August 2013, statistics on Regional airlines can no longer be separately identified. Calendar year data including Regional airline data separately identified can be found in the file "Airport Traffic Data 1985 to 2012".

International airline statistics are based on Uplift/Discharge. Uplift/Discharge (UD) data shows, by direction, the revenue traffic between the actual points of uplift and discharge within the same flight number, aggregated for all flights within the period.

Domestic (including Regional) airline data have been compiled using a combination of Uplift/Discharge and Traffic On Board (TOB) data. Traffic On Board: One flight stage refers to one take-off and landing. If a passenger's journey involves more than one take-off and landing, then that passenger will be counted for each stage travelled. Traffic On Board statistics, therefore, reflect the number of revenue passengers to/from or via the particular airport.

Domestic passengers carried on domestic legs of international flights are not included in these statistics. However, for July 2011 and onwards domestic passengers carried on international flight numbers that operate only between domestic ports have been included. This change in reporting provides more accurate passenger traffic figures.

Revenue Passenger Definition:

Up to December 1999, international revenue passengers represented the aggregate of all passengers paying 25 per cent or more of the standard airfare (the ICAO definition of revenue passenger at that time). From January to July 2000, a broader definition of revenue passenger was introduced. Revenue passengers for international services now include all passengers excluding 'free of charge' passengers and positioning crew.

Revenue passengers for domestic and regional airline services are regarded as those paying any fare. Airlines also include passengers travelling on tickets acquired under the terms of frequent flyer schemes.

In this report, airport passenger movement numbers are the sum of passenger arrivals and departures at each airport for Regular Public Transport operations only. Each domestic passenger generates two passenger movements (a departure and an arrival). For example, a passenger flying from Melbourne to Sydney will be counted twice, as a passenger departure at Melbourne and a passenger arrival at Sydney. Each international passenger, however, generates only one passenger movement (either an arrival or a departure).

Other Points:

Rank for passenger movements is only shown for airports with 50,000 or more passenger movements a year.

Rank for aircraft movements is only shown for airports with 5,000 or more aircraft movements a year.

Rankings for airports that no longer meet the reporting criteria will not be included for prior years.

Domestic airline services were severely affected by the pilots' dispute in 1989-90.

Domestic and Regional services for 2001 and 2002 were affected by the collapse of Ansett in September 2001.

Domestic freighter movements are partial from early 1990s to mid 2000s.

Virgin Australia entered the domestic market in 2000.

Jetstar entered the domestic market in 2004.

Tigerair Australia entered the domestic market in November 2007.

Figures may include estimates and figures for some airports for some years may not be complete.

Indemnity Statement:

The Bureau of Infrastructure, Transport and Regional Economics has taken due care in preparing this information. However, noting that data have been provided by third parties, the Commonwealth gives no warranty as to the accuracy, reliability, fitness for purpose, or otherwise of the information.

Copyright

© Commonwealth of Australia, 2017

This work is copyright and the data contained in this publication should not be reproduced or used in any form without acknowledgement.

Vignette to do list

• Author notes, details, sources etc
• Source notes: info from the spreadsheets
• Usage notes: how to get the data
• Data analysis: plots, summary statistics, maybe a regression

Link to data is broken

The link to the data (https://www.bitre.gov.au/publications/ongoing/files/WebAirport_CY_1985-2018.xlsx) is broken.
I think the new link should be: https://www.bitre.gov.au/sites/default/files/WebAirport_CY_1985-2018.xlsx

Add tests

• Does it download?
• Are the dimensions the same?
• Are the column names the same?

Transfer repo to personal account?

@Lingtax @stephstammel 👋 according to our recently created package curation policy this repo should now be transferred to either one of your personal accounts, or the ropensci-archive organization.

If you don't answer within one month, I'll transfer the repository to ropensci-archive, after which you could still email me to transfer the repo to a personal account.

Thank you!

Update data url

Hi! This package no longer works because the data URL is 404.

The source seems to have changed. Can you update it to the 2018 data? https://www.bitre.gov.au/publications/ongoing/airport_traffic_data.aspx

Add Travis CI

Functions leave residual temp.xls

Current implementation leaves a temp file.
Suggest using file.remove() after read.xls().