PBWG EUROCONTROL Workbench

High-level R helpers for PBWG workflows at EUROCONTROL. The package wraps eurocontrol primitives and purpose-built SQL to pull NM area traffic, DAIO, APDF airport data, punctuality extracts, and combined CHN-EUR summaries.

Note: The package expects connectivity to PRU Oracle schemas (PRU_DEV/PRU_ATMAP) and the ROracle client; these are not available on CRAN.

Installation

# install.packages("devtools")
devtools::install_github("eurocontrol/eurocontrol")   # dependency
devtools::install_github("eurocontrol/pbwg-eurocontrol")

Key functions

• pbwg_weight_segment_tfc_counts() - NM area traffic split by wake turbulence and aircraft category.
• pbwg_market_segment_tfc_counts() - NM area traffic by market segment.
• pbwg_daio() - Daily DAIO counts for a region.
• pbwg_traffic_summary() / pbwg_chn_summary() - Composite daily tables used in PBWG outputs.
• pbwg_apdf_fetch_airport_raw() / pbwg_apdf_daily_airport_movements() - APDF airport extracts and daily summaries.
• pbwg_otp_punctuality() - Punctuality extracts for selected airports/years.

Usage

library(pbwg.eurocontrol)

# NM area by wake turbulence category
wtc <- pbwg_weight_segment_tfc_counts(wef = "2024-01-01", til = "2024-01-31")

# DAIO daily counts and composite PBWG summary
daio <- pbwg_daio("2024-01-01", "2024-01-31", region = "ECAC")
summary <- pbwg_traffic_summary("2024-01-01", "2024-01-31")

# APDF airport movements for a set of ICAO codes
apdf <- pbwg_apdf_daily_airport_movements(
  airports = c("EBBR", "EIDW"),
  wef = "2024-01-01",
  til = "2024-01-07"
)

Each function accepts an optional conn (DBI connection). When omitted, a fresh Oracle connection is created via eurocontrol::db_connection(); ensure your environment provides the required credentials and Oracle client.