Skip to contents

Access to Data(bases)

DB conection.

db_connection()
Provide a connection to the relevant Oracle database

Data

Useful data.

member_state
EUROCONTROL's Member States
aircraft_type
ICAO's Aircraft types
aircraft_model
ICAO's Manufacturer codes

Datasets

Helpers for typical queries.

airlines_tidy()
Airline info including group affiliation
airspace_profiles_tidy()
Provide all airspace profile segments intersecting an interval of interest
aodf_tidy()
Extract a clean airport operator data flow list in an interval
flights_airspace_profiles_tidy()
Extract the flights list for the airspace profile segments intersecting an interval of interest
flights_tidy()
Extract a clean flights list in an interval
point_profiles_tidy()
Export point profile from NM trajectories
airports_oa()
retrieve latest airport list from OurAirports

Formats

Helpers for format conversions.

generate_so6()
Export trajectory profiles to SO6 format

IATA season

Helpers for IATA season.

season_iata()
return the interval for an IATA season
iata_season_for_date()
Return the corresponding IATA season for a date

Tables

Access to typical tables.

airlines_tbl()
Return a reference to the Airlines table
airspace_profile_tbl()
Return a reference to the Airspace Profile table
aodf_tbl()
Return a reference to the Airport Operator Data Flow table
flights_tbl()
Return a reference to the Flights table
point_profile_tbl()
Return a reference to the Point Profile table