Skip to contents

Fetch APDF records for a single airport

pbwg_apdf_fetch_airport_raw.Rd

Queries SWH_FCT.FAC_APDS_FLIGHT_IR691 via eurocontrol::apdf_tbl(), filters to one airport and date window, then collects the rows. The default column set keeps operational details (AC_CLASS, runway/stand, movement times) that are dropped by eurocontrol::apdf_tidy().

Usage

pbwg_apdf_fetch_airport_raw(
  airport,
  wef,
  til,
  columns = pbwg_apdf_columns_default(),
  conn = NULL
)

Arguments

airport

ICAO airport designator (e.g. "EIDW"). Only a single code is allowed.

wef

Start date (inclusive). Can be anything that lubridate::as_date() understands.

til

End date (inclusive). Can be anything that lubridate::as_date() understands.

columns

Vector of column names to include. Defaults to the exact set used by the Python scripts; see pbwg_apdf_columns_default() for details.

conn

Optional Oracle DBI::DBIConnection. When omitted a fresh connection to PRUDEV is created via eurocontrol::db_connection(), with access to SWH_FCT.V_FAC_FLIGHT_MS and PRUDEV.V_PRU_AIRCRAFT_CATEGORY.

Value

A tibble::tibble() with the requested APDF columns and an attached "sql" attribute describing the filter. Columns (default set):

  • AP_C_FLTIDFlight identifier (source airport).

  • AP_C_FLTRULRules under which the flight operates (IFR, VFR, NA).

  • AP_C_REGAircraft registration with separators removed.

  • ADEP_ICAODeparture aerodrome (ICAO).

  • ADES_ICAODestination aerodrome (ICAO).

  • SRC_PHASEDEP for departures, ARR for arrivals.

  • MVT_TIME_UTCMovement time (UTC).

  • BLOCK_TIME_UTCBlock time (UTC).

  • SCHED_TIME_UTCScheduled time (UTC).

  • ARCTYPICAO aircraft type code (e.g. A21N).

  • AC_CLASSWake turbulence class (kept for H/M/L aggregation).

  • AP_C_RWYRunway identifier.

  • AP_C_STNDStand identifier.

  • C40_CROSS_TIMETime of the first/last 40 NM crossing.

  • C40_CROSS_LATLatitude of the 40 NM crossing.

  • C40_CROSS_LONLongitude of the 40 NM crossing.

  • C100_CROSS_TIMETime of the first/last 100 NM crossing.

  • C100_CROSS_LATLatitude of the 100 NM crossing.

  • C100_CROSS_LONLongitude of the 100 NM crossing.

  • C40_BEARINGBearing at the 40 NM crossing.

  • C100_BEARINGBearing at the 100 NM crossing.