DFD v2 Data Format Specification

Revision HistoryRead the “Revision History” section

IntroductionRead the “Introduction” section

This document will define the complete dataset specifications of the Digital Flight Data (DFD) format. It is heavily inspired by the ARINC424 specifications, though tailored to add-ons' use. Whenever possible, I use the same naming conventions as the ARINC specification to avoid confusion. I will also clearly indicate from which sections and record columns the data must be extracted.

We used the standard ARINC424-18 specification, but it should be compatible with 424-19/20. The dataset can be provided in three different formats:

1. ASCII text-file
2. SQLite format
3. in individual file formats (must be requested)

The DFD contains the primary records of the following record types (in parenthesis, the corresponding ARINC 424 section and subsection codes):

• Airports (PA)
• Enroute Airways (ER)
• Enroute NDB Navaids (DB)
• Enroute Waypoints (EA)
• Holdings (EP)
• IAP - Instrument Arrival Procedures (PF)
• Localizer Marker (PM)
• Localizer/Glideslopes (PI)
• Runways (PG)
• SID -- Standard Instrument Departure (PD)
• STAR -- Standard Terminal Arrival Route (PE)
• Terminal NDB Navaids (PN)
• Terminal Waypoints (PC)
• VHF Navaids (D)
• Airport Communication (PV)
• Airport MSA (PS)
• Controlled Airspace (UC)
• Cruising Tables (TC)
• Enroute Airway Restriction (EU)
• Enroute Communication (EV)
• FIR/UIR (UF)
• Gate (PB)
• GLS (PT)
• Grid Mora (AS)
• Restrictive Airspace (UR)
• Path Point (PP)

Specification SQLite formatRead the “Specification SQLite format” section

Filename: ng_jeppesen_fwdfd_xxxx.3sdb (xxxx is the cycle-number)

Specification ASCII text-file formatRead the “Specification ASCII text-file format” section

All fields in the records are separated with a | character (vertical bar or ASCII 124). All blanks will be trimmed at the end of each field (excluding special marked fields -- footnote)

Header / MetadataRead the “Header / Metadata” section

SQLite Table: tbl_hdr_header

ASCII Format: creator|cycle|data_provider|dataset_version|dataset|effective_fromto|parsed_at|revision

Description:

• creator: company name (ex. Navigraph)
• cycle: valid AIRAC cycle (ex. 2410)
• data_provider: data provider (ex. Jeppesen)
• dataset_version: dataset specification version (Format: 2.0.xx.xxxx)
• dataset: name of the dataset (Format: NG_xxx...)
• effective_fromto: the date when the current AIRAC cycle starts/ends (Format DDMMDDMMYY-- DD is the day, MM is the month, YY is the year) (ex. 0310301024)
• parsed_at: parsing/creation date of this AIRAC cycle (Format YYYY-MM-DD -- HH:MM:SS in UTC)
• revision: revision of this AIRAC cycle (Format: xxx)

VHF NavaidsRead the “VHF Navaids” section

SQLite Table: tbl_d_vhfnavaids

ASCII Format: airport_identifier|area_code|continent|country|datum_code|dme_elevation|dme_ident|dme_latitude|dme_longitude|icao_code|ilsdme_bias|magnetic_variation|navaid_class|navaid_frequency|navaid_identifier|navaid_latitude|navaid_longitude|navaid_name|range|station_declination

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the navaid
• continent: the continent in which the navaid is located
• country: the country in which the navaid is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• dme_elevation: DME elevation in feet AMSL
• dme_ident: identification of a DME facility, a TACAN facility or the DME (or TACAN) component of a VORDME or VORTAC facility
• dme_latitude: DME latitude in degrees decimal floating point (N positive, S negative)
• dme_longitude: DME longitude in degrees decimal floating point (E positive, W negative)
• icao_code: 2-letter location indicator of the navaid
• ilsdme_bias: specify the DME offset
• magnetic_variation: magnetic north at the location
• navaid_class: navaid type, range/power, additional information & collocation
• navaid_frequency: navaid frequency in kHz
• navaid_identifier: navaid identifier
• navaid_latitude: navaid latitude in degrees decimal floating point (N positive, S negative)
• navaid_longitude: navaid longitude in degrees decimal floating point (E positive, W negative)
• navaid_name: navaid name
• range: distance in NM at which the signal can be received
• station_declination: the angular difference between true north and the zero degrees radial of the navaid in degrees

Enroute NDB NavaidsRead the “Enroute NDB Navaids” section

SQLite Table: tbl_db_enroute_ndbnavaids

ASCII Format: area_code|continent|country|datum_code|icao_code|magnetic_variation|navaid_class|navaid_frequency|navaid_identifier|navaid_latitude|navaid_longitude|navaid_name|range

Description:

• area_code: geographical area of the ndb
• continent: the continent in which the ndb is located
• country: the country in which the ndb is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the ndb
• magnetic_variation: magnetic north at the location
• navaid_class: ndb type, range/power, additional information & collocation
• navaid_frequency: ndb frequency in MHz
• navaid_identifier: ndb identifier
• navaid_latitude: ndb latitude in degrees decimal floating point (N positive, S negative)
• navaid_longitude: ndb longitude in degrees decimal floating point (E positive, W negative)
• navaid_name: ndb name
• range: distance in NM at which the signal can be received

Terminal NDB NavaidsRead the “Terminal NDB Navaids” section

SQLite Table: tbl_pn_terminal_ndbnavaids

ASCII Format: airport_identifier|area_code|continent|country|datum_code|icao_code|magnetic_variation|navaid_class|navaid_frequency|navaid_identifier|navaid_latitude|navaid_longitude|navaid_name|range

Description:

• airport_identifier: four-character ICAO location identifier
• area_code: geographical area of the ndb
• continent: the continent in which the ndb is located
• country: the country in which the ndb is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the ndb
• magnetic_variation: magnetic north at the location
• navaid_class: ndb type, range/power, additional information & collocation
• navaid_frequency: ndb frequency in MHz
• navaid_identifier: ndb identifier
• navaid_latitude: ndb latitude in degrees decimal floating point (N positive, S negative)
• navaid_longitude: ndb longitude in degrees decimal floating point (E positive, W negative)
• navaid_name: ndb name
• range: distance in NM at which the signal can be received

Enroute WaypointsRead the “Enroute Waypoints” section

SQLite Table: tbl_ea_enroute_waypoints

ASCII Format: area_code|continent|country|datum_code|icao_code|magnetic_variation|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_name|waypoint_type|waypoint_usage

Description:

• area_code: geographical area of the waypoint
• continent: continent in which the waypoint is located
• country: the country in which the waypoint is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the waypoint
• magnetic_variation: magnetic north at the location
• waypoint_identifier: waypoint identifier
• waypoint_latitude: waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: waypoint longitude in degrees decimal floating point (E positive, W negative)
• waypoint_name: waypoint name
• waypoint_type: waypoint type
• waypoint_usage: waypoint usage

Terminal WaypointsRead the “Terminal Waypoints” section

SQLite Table: tbl_pc_terminal_waypoints

ASCII Format: area_code|continent|country|datum_code|icao_code|magnetic_variation|region_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_name|waypoint_type

Description:

• area_code: geographical area of the terminal waypoint
• continent: continent in which the terminal waypoint is located
• country: the country in which the terminal waypoint is located
• datum_code: 3-letter code of the "local horizontal reference datum"
• icao_code: 2-letter location indicator of the terminal waypoint
• magnetic_variation: magnetic north at the location
• region_code: airport identification code for the terminal waypoint
• waypoint_identifier: terminal waypoint identifier
• waypoint_latitude: terminal waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: terminal waypoint longitude in degrees decimal floating point (E positive, W negative)
• waypoint_name: terminal waypoint name
• waypoint_type: terminal waypoint type

HoldingsRead the “Holdings” section

SQLite Table: tbl_ep_holdings

ASCII Format: area_code|duplicate_identifier|holding_name|holding_speed|icao_code|inbound_holding_course|leg_length|leg_time|maximum_altitude|minimum_altitude|region_code|turn_direction|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• area_code: geographical area of the waypoint
• duplicate_identifier: used for more than one holding pattern for a single navaid or waypoint
• holding_name: holding name
• holding_speed: holding speed limit in knots
• icao_code: location indicator of the waypoint
• inbound_holding_course: inbound magnetic course in degrees floating point
• leg_length: inbound leg length in nautical miles, decimal floating point
• leg_time: inbound leg time in minutes, decimal floating point
• maximum_altitude: contain altitudes in feet or flight level
• minimum_altitude: contain altitudes in feet or flight level
• region_code: static text ENRT or airport identification code
• turn_direction: holding turn direction
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint longitude in degrees decimal floating point (E positive, W negative)
• waypont_ref_table: reference table for more information about the specific waypoint

Enroute AirwaysRead the “Enroute Airways” section

SQLite Table: tbl_er_enroute_airways

ASCII Format: area_code|crusing_table_identifier|direction_restriction|flightlevel|icao_code|inbound_course|inbound_distance|maximum_altitude|minimum_altitude1|minimum_altitude2|outbound_course|route_identifier_postfix|route_identifier|route_type|seqno|waypoint_description_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• area_code: geographical area of the waypoint
• crusing_table_identifier: indicate the cruising table
• direction_restriction: indicate the flyable direction
• flightlevel: defines the airway structure
• icao_code: location indicator of the waypoint
• inbound_course: inbound magnetic course to the waypoint identified
• inbound_distance: contain segment distances/along track distances/excursion distances/DME distances in nautical miles
• maximum_altitude: contain altitudes in feet
• minimum_altitude1: contain altitudes in feet
• minimum_altitude2: contain altitudes in feet
• outbound_course: outbound magnetic course from the waypoint identified
• route_identifier_postfix: postfix character for the route_identifier
• route_identifier: enroute route identifier
• route_type: indicated the route type
• seqno: sort order of each enroute airway, no duplicate sequences per airway are possible
• waypoint_description_code: provides information on the type of fix
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint longitude in degrees decimal floating point (E positive, W negative)
• waypoint_ref_table: reference table for more information about the specific waypoint

AirportsRead the “Airports” section

SQLite Table: tbl_pa_airports

ASCII Format: airport_identifier|airport_name|airport_ref_latitude|airport_ref_longitude|airport_type|area_code|ata_iata_code|city|continent|country_3letter|country|elevation|fuel|icao_code|ifr_capability|longest_runway_surface_code|magnetic_variation|speed_limit_altitude|speed_limit|state_2letter|state|time_zone|transition_altitude|transition_level

Description:

• airport_identifier: four character ICAO location identifier
• airport_name: airport name
• airport_ref_latitude: airport reference latitude in degrees decimal floating point (N positive, S negative)
• airport_ref_longitude: airport reference longitude in degrees decimal floating point (E positive, W negative)
• airport_type: defines the type of airport
• area_code: geographical area of the airport
• ata_iata_code: IATA/ATA airport designator code
• city: the city where the airport is located
• continent: the continent where the airport is located
• country_3letter: 3-letter country code of the airport
• country: the country where the airport is located
• elevation: elevation in feet above MSL
• fuel: available fuel specification
• icao_code: location indicator of the airport
• ifr_capability: indicates if the airport has a published IAP
• longest_runway_surface_code: define if there is a hard runway or not
• magnetic_variation: magnetic north at the location
• speed_limit_altitude: altitude below which speed limit may be imposed (feet or flight level)
• speed_limit: speed limit in knots
• state_2letter: 2-letter state code
• state: the state where the airport is located
• time_zone: time zone where the airport is located
• transition_altitude: transition altitude in feet
• transition_level: transition level in feet

RunwaysRead the “Runways” section

SQLite Table: tbl_pg_runways

ASCII Format: airport_identifier|area_code|displaced_threshold_distance|icao_code|landing_threshold_elevation|llz_identifier|llz_mls_gls_category|part_time_lights|runway_gradient|runway_identifier|runway_latitude|runway_length|runway_lights|runway_longitude|runway_magnetic_bearing|runway_true_bearing|runway_width|surface_code|threshold_crossing_height|traffic_pattern|altitude_pattern_altitude

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area of the runway
• displaced_threshold_distance: distance from the extremity of a runway to a threshold in feet
• icao_code: location indicator of the runway
• landing_theshold_elevation: elevation of the landing threshold in feet
• llz_identifier: ILS/MLS/GLS facility
• llz_mls_gls_category: ILS/MLS/GLS performance categories
• part_time_lights: part time/full time runway lights
• runway_gradient: overall gradient in percent (positive is upward, negative is downward)
• runway_identifier: runway identifier
• runway_latitude: runway latitude in degrees decimal floating point (N positive, S negative)
• runway_length: runway length in feet
• runway_lights: runway lights existing
• runway_longitude: runway longitude in degrees decimal floating point (E positive, W negative)
• runway_magnetic_bearing: magnetic bearing of the runway identifier
• runway_true_bearing: true bearing of the runway identifier
• runway_width: runway width in feet
• surface_code: runway surface code
• threshold_crossing_height: height above the landing threshold on normal glide path
• traffic_pattern: left/right traffic pattern
• traffic_pattern_altitude: indicate the height above the ground on a traffic pattern

Localizers/GlideslopesRead the “Localizers/Glideslopes” section

SQLite Table: tbl_pi_localizers_glideslopes

ASCII Format: airport_identifier|area_code|gs_angle|gs_elevation|gs_latitude|gs_longitude|icao_code|ils_mls_gls_category|llz_bearing|llz_frequency|llz_identifier|llz_latitude|llz_longitude|llz_truebearing|llz_width|runway_identifier|station_declination

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area of the localizer
• gs_angle: glide slope angle of an ILS facility/GLS approach in degrees
• gs_elevation: elevation of LLZ in feet
• gs_latitude: GS latitude in degrees decimal floating point (N positive, S negative)
• gs_longitude: GS longitude in degrees decimal floating point (E positive, W negative)
• icao_code: location indicator of the localizer
• ils_mls_gls_category: ILS/MLS/GLS performance categories
• llz_bearing: magnetic bearing of the localizer course
• llz_frequency: VHF frequency of the facility in MHz
• llz_identifier: identification code of the LLZ, MLS facility or GLS reference path
• llz_latitude: LLZ latitude in degrees decimal floating point (N positive, S negative)
• llz_longitude: LLZ longitude in degrees decimal floating point (E positive, W negative)
• llz_truebearing: true bearing of the localizer course
• llz_width: specifies the localizer course width (in degrees) of the ILS facility
• runway_identifier: runway identifier
• station_declination: angular difference between true north and the zero degree radial of the LLZ in degrees

Localizer MarkerRead the “Localizer Marker” section

SQLite Table: tbl_pm_localizer_marker

ASCII Format: airport_identifier|area_code|icao_code|llz_identifier|marker_identifier|marker_latitude|marker_longitude|marker_type|runway_identifier

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area of the marker
• icao_code: location indicator of the marker
• llz_identifier: identification code of the LLZ, MLS facility or GLS reference path
• marker_identifier: marker identifier
• marker_latitude: marker latitude in degrees decimal floating point (N positive, S negative)
• marker_longitude: marker longitude in degrees decimal floating point (E positive, W negative)
• marker_type: defines the type of marker
• runway_identifier: runway identifier

Terminal Procedures (SID/STAR)Read the “Terminal Procedures (SID/STAR)” section

SQLite Table: tbl_pd_sids tbl_pe_stars

ASCII Format: airport_identifier|altitude_description|altitude1|altitude2|arc_radius|area_code|authorization_required|center_waypoint_icao_code|center_waypoint_latitude|center_waypoint_longitude|center_waypoint_ref_table|center_waypoint|course_flag|course|distance_time|path_termination|procedure_identifier|recommended_navaid_icao_code|recommended_navaid_latitude|recommended_navaid_longitude|recommended_navaid_ref_table|recommended_navaid|rho|rnp|route_distance_holding_distance_time|route_type|seqno|speed_limit_description|speed_limit|theta|transition_altitude|transition_identifier|turn_direction|vertical_angle|waypoint_description_code|waypoint_icao_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• airport_identifier: four character ICAO location identifier
• altitude_description: designate whether a waypoint should be crossed
• altitude1: contain altitudes in feet or flight level
• altitude2: contain altitudes in feet or flight level
• arc_radius: used to define the radius of a precision turn
• area_code: geographical area of the procedure
• authorization_required: indicates, if this procedure needs special authorization (AR procedures)
• center_waypoint_icao_code: location indicator of the center waypoint
• center_waypoint_latitude: center fix latitude in degrees decimal floating point (N positive, S negative)
• center_waypoint_longitude: center fix longitude in degrees decimal floating point (E positive, W negative)
• center_waypoint_ref_table: reference table for more information about the specific center waypoint
• center_waypoint: represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• course_flag: magnetic or true flag
• course: outbound course from the waypoint identified in the record's "waypoint_identifier" field
• distance_time: indicates, if the value in the "route_distance_holding_distance_time" column references to a time value, or distance value
• path_termination: defines the path geometry for a single record of an terminal procedure
• procedure_identifier: name of the terminal procedure
• recommended_navaid_icao_code: location indicator of the navaid
• recommended_navaid_latitude: recommended navaid latitude in degrees decimal floating point (N positive, S negative)
• recommended_navaid_longitude: recommended navaid longitude in degrees decimal floating point (E positive, W negative)
• recommended_navaid_ref_table: reference table for more information about the specific navaid
• recommended_navaid: reference facility for the waypoint
• rho: defined as the geodesic distance in nautical miles to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• rnp: statement of the Navigation Performance necessary for operation within a defined airspace in accordance with ICAO Annex 15 and/or State published rules
• route_distance_holding_distance_time: contain segment distances/along track distances/excursion distances/DME distances
• route_type: element of the terminal procedure
• seqno: sequence definition phase of the terminal procedure
• speed_limit_description: designate whether the speed limit coded at a waypoint in a terminal procedure description is a mandatory, minimum or maximum speed
• speed_limit: speed limit in knots
• theta: defined as the magnetic bearing to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• transition_altitude: transition altitude in feet
• transition_identifier: describes the type of transition to be made from the enroute environment into the terminal area and vice versa
• turn_direction: turn direction
• vertical_angle: defines the vertical navigation path prescribed for the procedure
• waypoint_description_code: the field provides information on the type of fix
• waypoint_icao_code: location indicator of the waypoint
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_ref_table: reference table for more information about the specific waypoint

Terminal Procedures (IAP)Read the “Terminal Procedures (IAP)” section

SQLite Table: tbl_pf_iaps

ASCII Format: airport_identifier|altitude_description|altitude1|altitude2|arc_radius|area_code|authorization_required|center_waypoint_icao_code|center_waypoint_latitude|center_waypoint_longitude|center_waypoint_ref_table|center_waypoint|course_flag|course|distance_time|gnss_fms_indication|lnav_authorized_sbas|lnav_level_service_name|lnav_vnav_authorized_sbas|lnav_vnav_level_service_name|path_termination|procedure_identifier|recommended_navaid_icao_code|recommended_navaid_latitude|recommended_navaid_longitude|recommended_navaid_ref_table|recommended_navaid|rho|rnp|route_distance_holding_distance_time|route_type|seqno|speed_limit_description|speed_limit|theta|transition_altitude|transition_identifier|turn_direction|vertical_angle|waypoint_description_code|waypoint_icao_code|waypoint_identifier|waypoint_latitude|waypoint_longitude|waypoint_ref_table

Description:

• airport_identifier: four character ICAO location identifier
• altitude_description: designate whether a waypoint should be crossed
• altitude1: contain altitudes in feet or flight level
• altitude2: contain altitudes in feet or flight level
• arc_radius: used to define the radius of a precision turn
• area_code: geographical area of the procedure
• authorization_required: indicates, if this procedure needs special authorization (AR procedures)
• center_waypoint_icao_code: location indicator of the center waypoint
• center_waypoint_latitude: center fix latitude in degrees decimal floating point (N positive, S negative)
• center_waypoint_longitude: center fix longitude in degrees decimal floating point (E positive, W negative)
• center_waypoint_ref_table: reference table for more information about the specific center waypoint
• center_waypoint: represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• course_flag: magnetic or true flag
• course: outbound course from the waypoint identified in the record's "waypoint_identifier" field
• distance_time: indicates, if the value in the "route_distance_holding_distance_time" column references to a time value, or distance value
• gnss_fms_indication: RNAV procedure has been authorized for GNSS based vertical navigation
• lnav_authorized_sbas: Level of Service authorized or not
• lnav_level_service_name: procedure level of service based on published procedure operating minimums information -- authorized for SBAS
• lnav_vnav_authorized_sbas: Level of Service authorized or not
• lnav_vnav_level_service_name: procedure level of service based on published procedure operating minimums information -- authorized for SBAS
• path_termination: defines the path geometry for a single record of an terminal procedure
• procedure_identifier: name of the terminal procedure
• recommended_navaid_icao_code: location indicator of the navaid
• recommended_navaid_latitude: recommended navaid latitude in degrees decimal floating point (N positive, S negative)
• recommended_navaid_longitude: recommended navaid longitude in degrees decimal floating point (E positive, W negative)
• recommended_navaid_ref_table: reference table for more information about the specific navaid
• recommended_navaid: reference facility for the waypoint
• rho: defined as the geodesic distance in nautical miles to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• rnp: statement of the Navigation Performance necessary for operation within a defined airspace in accordance with ICAO Annex 15 and/or State published rules
• route_distance_holding_distance_time: contain segment distances/along track distances/excursion distances/DME distances
• route_type: element of the terminal procedure
• seqno: sequence definition phase of the terminal procedure
• speed_limit_description: designate whether the speed limit coded at a waypoint in a terminal procedure description is a mandatory, minimum or maximum speed
• speed_limit: speed limit in knots
• theta: defined as the magnetic bearing to the waypoint identified in the record's "waypoint_identifier" field from the "recommended_navaid_identifier" field
• transition_altitude: transition altitude in feet
• transition_identifier: describes the type of transition to be made from the enroute environment into the terminal area and vice versa
• turn_direction: turn direction
• vertical_angle: defines the vertical navigation path prescribed for the procedure
• waypoint_description_code: the field provides information on the type of fix
• waypoint_icao_code: location indicator of the waypoint
• waypoint_identifier: navaid or waypoint identifier
• waypoint_latitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_longitude: navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• waypoint_ref_table: reference table for more information about the specific waypoint

Airport CommunicationRead the “Airport Communication” section

SQLite Table: tbl_pv_airport_communication

ASCII Format: airport_identifier|area_code|callsign|communication_frequency|communication_type|frequency_units|guard_transmit|icao_code|latitude|longitude|narrative|remote_facility_icao_code|remote_facility|sector_facility_icao_code|sector_facility|sectorization|service_indicator|time_of_operation_1|time_of_operation_2|time_of_operation_3|time_of_operation_4|time_of_operation_5|time_of_operation_6|time_of_operation_7

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area of the facility
• callsign: name of the facility being called
• communication_frequency: specifies a frequency for the facility identified in the communicaton type field
• communication_type: specified the type of communication unit
• frequency_units: designate the frequency spectrum area for the frequency
• guard_transmit: receive voice communications or transmit voice communications
• icao_code: location indicator of the facility
• latitude: latitude in degrees decimal floating point (N positive, S negative)
• longitude: longitude in degrees decimal floating point (E positive, W negative)
• narrative: time of operation in plain text
• remote_facility_icao_code: location indicator of the remote facility
• remote_facility: navaid or airport with a Remote Communications Outlet (RCO) will be transmitted
• sector_facility_icao_code: location indicator of the sector facility
• sector_facility: navaid or airport upon which the information in the "sectorization" is based
• sectorization: used to define the airspace sector a communication frequency is applicable for when an airport defines sectors by bearing from the same point
• service_indicator: define the use of the frequency for the specified communication type
• time_of_operation_1-7: indicates the time of operation of the facility

Enroute CommunicationRead the “Enroute Communication” section

SQLite Table: tbl_ev_enroute_communication

ASCII Format: area_code|callsign|communication_frequency|communication_type|fir_rdo_ident|fir_uir_indicator|frequency_units|latitude|longitude|remote_facility_icao_code|remote_facility|remote_name|service_indicator

Description:

• area_code: geographical area of the facility
• callsign: name of the facility being called
• communication_frequency: specifies a frequency for the facility identified in the communicaton type field
• communication_type: specified the type of communication unit
• fir_rdo_ident: identified the Flight Information Region or Upper Information Region
• fir_uir_indicator: ontain the identifier of a FIR, UIR or combined FIR/UIR
• frequency_units: designate the frequency spectrum area for the frequency
• latitude: latitude in degrees decimal floating point (N positive, S negative)
• longitude: longitude in degrees decimal floating point (E positive, W negative)
• remote_facility_icao_code: location indicator of the remote facility
• remote_facility: navaid or airport with a Remote Communications Outlet (RCO) will be transmitted
• remote_name: name of unmanned air/ground facility
• service_indicator: define the use of the frequency for the specified communication type

Grid MoraRead the “Grid Mora” section

SQLite Table: tbl_as_grid_mora

ASCII Format: mora01|mora02|mora03|mora04|mora05|mora06|mora07|mora08|mora09|mora10|mora11|mora12|mora13|mora14|mora15|mora16|mora17|mora18|mora19|mora20|mora21|mora22|mora23|mora24|mora25|mora26|mora27|mora28|mora29|mora30|quadrant_code|starting_latitude|starting_longitude

Description:

• mora01 -- mora30: terrain and obstruction clearance within the section outlined by latitude and longitude blocks in feet
• quadrant_code: indicates for which of the 30-minute quadrants of a one-degree grid square, defined by the "starting_latitude/starting_longitude", the grid mora record applies
• starting_latitude : defines the lower left corner for the first block
• starting_longitude : defines the lower left corner for the first block

Airport MSARead the “Airport MSA” section

SQLite Table: tbl_ps_airport_msa

ASCII Format: airport_identifier|area_code|icao_code|magnetic_true_indicator|msa_center_icao_code|msa_center_latitude|msa_center_longitude|msa_center_ref_table|msa_center|multiple_code|radius_limit|sector_altitude_1|sector_altitude_2|sector_altitude_3|sector_altitude_4|sector_altitude_5|sector_bearing_1|sector_bearing_2|sector_bearing_3|sector_bearing_4| sector_bearing_5

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area
• icao_code: location indicator of the airport
• magnetic_true_indicator: indicator if the course is true or magnetic
• msa_center_icao_code: location indicator of the center waypoint
• msa_center_latitude: MSA Center fix latitude in degrees decimal floating point (N positive, S negative)
• msa_center_longitude: MSA Center fix longitude in degrees decimal floating point (E positive, W negative)
• msa_center_ref_table: reference table for more information about the specific center waypoint
• msa_center: represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• multiple_code: indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• radius_limit: provides a 1000 foot obstacle clearance with a specific radius from the navigational facility/fix
• sector_altitude_1-5: sector altitude in feet
• sector_bearing_1-5: sector bearing in degrees

Enroute Airways RestrictionRead the “Enroute Airways Restriction” section

SQLite Table: tbl_eu_enroute_airway_restriction

ASCII Format: area_code|block_indicator1|block_indicator2|block_indicator3|block_indicator4|block_indicator5|block_indicator6|block_indicator7|end_date|end_waypoint_icao_code|end_waypoint_identifier|end_waypoint_latitude|end_waypoint_longitude|end_waypoint_ref_table|restriction_altitude1|restriction_altitude2|restriction_altitude3|restriction_altitude4|restriction_altitude5|restriction_altitude6|restriction_altitude7|restriction_identifier|restriction_type|route_identifier|start_date|start_waypoint_icao_code|start_waypoint_identifier|start_waypoint_latitude|start_waypoint_longitude|start_waypoint_ref_table|units_of_altitude

Description:

• area_code: geographical area
• block_indicator1-7: specify that the altitudes that follow in the restriction record
• end_date: specific the effective date which does not corresponding with the AIRAC date
• end_waypoint: end waypoint identifier
• end_waypoint_icao_code: location indicator of the "end_waypoint"
• end_waypoint_identifier: end waypoint identifier
• end_waypoint_latitude: end waypoint latitude in degrees decimal floating point (N positive, S negative)
• end_waypoint_longitude: end waypoint longitude in degrees decimal floating point (E positive, W negative)
• end_waypoint_ref_table: reference table for more information about the specific end waypoint
• restriction_altitude1-7: specify the altitude profile for a specific restriction
• restriction_identifier: assign a unique identifier
• restriction_type: define the type of the restriction
• route_identifier: enroute route identifier
• start_date: specific the effective date which does not corresponding with the AIRAC date
• start_waypoint_icao_code: location indicator of the "start_waypoint"
• start_waypoint_identifier: start waypoint identifier
• start_waypoint_latitude: start waypoint latitude in degrees decimal floating point (N positive, S negative)
• start_waypoint_longitude: start waypoint longitude in degrees decimal floating point (E positive, W negative)
• start_waypoint_ref_table: reference table for more information about the specific start waypoint
• units_of_altitude: indicate the units of measurement for the restriction altitudes

Controlled AirspaceRead the “Controlled Airspace” section

SQLite Table: tbl_uc_controlled_airspace

ASCII Format: airspace_center|airspace_classification|airspace_type|arc_bearing|arc_distance_arc_origin_latitude|arc_origin_longitude|area_code|boundary_via|controlled_airspace_name|flightlevel|icao_code|latitude|longitude|lower_limit|multiple_code|seqno|time_code|unit_indicator_lower_limit|unit_indicator_upper_limit|upper_limit

Description:

• airspace_center: define the navigation element upon which the controlled airspace being defined is predicated, but not necessarily centered
• airspace_classification: indicating the published classification of the controlled airspace, when assigned- airspace_type: indicate the type of controlled airspace
• arc_bearing: contains the true bearing from the "Arc Origin" position to the beginning of the arc
• arc_distance: define the distance in nautical miles from the "Arc Origin" position
• arc_origin_latitude: arc origin latitude in degrees decimal floating point (N positive, S negative)
• arc_origin_longitude: arc origin longitude in degrees decimal floating point (E positive, W negative)
• area_code: geographical area
• boundary_via: defines the path of the boundary from the position identified in the record to the next defined position
• controlled_airspace_name: the name of the controlled airspace when assigned
• flightlevel: defines the airway structure
• icao_code: location indicator of the airspace center
• latitude: latitude in degrees decimal floating point (N positive, S negative)
• longitude: longitude in degrees decimal floating point (E positive, W negative)
• lower_limit: contain the lower limits
• multiple_code: indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical deta
• seqno: sort order of each airspace, no duplicate sequences per airspace are possible
• time_code: Active Time
• unit_indicator_lower_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• unit_indicator_upper_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• upper_limit: contain the upper limits

Cruising TablesRead the “Cruising Tables” section

SQLite Table: tbl_tc_cruising_tables

ASCII Format: area_code|course_from|course_to|cruise_level_from1|cruise_level_from2|cruise_level_from3|cruise_level_from4|cruise_level_to1|cruise_level_to2|cruise_level_to3|cruise_level_to4|cruise_table_identifier|mag_true|seqno|vertical_separation1|vertical_separation2|vertical_separation3|vertical_separation4

Description:

• area_code: geographical area
• course_from: indicate the lowest course for which a block of cruising levels are prescribed
• course_to: indicate the highest course for which a block of cruising levels is prescribed
• cruise_level_from1-4: indicate the lowest cruising level prescribed for use within the Course From/To fields
• cruise_level_to1-4: indicate the highest cruising level prescribed for use within the Course From/To fields
• cruise_table_identifier: indicate the cruising table
• mag_true: course from/to in magnetic or true degrees
• seqno: sort order of each cruise table, no duplicate sequences per cruise table are possible
• vertical_separation1-4: indicate the minimum separation prescribed to be maintained between the cruising levels

FIR/UIRRead the “FIR/UIR” section

SQLite Table: tbl_uf_fir_uir

ASCII Format: adjacent_fir_identifier|adjacent_uir_identifier|arc_bearing|arc_distance|arc_origin_latitude|arc_origin_longitude|area_code|boundry_via|cruise_table_identifier|fir_uir_address|fir_uir_identifier|fir_uir_indicator|fir_uir_latitude|fir_uir_longitude|fir_uir_name|fir_upper_limit|reporting_units_altitude|reporting_units_speed|seqno|uir_lower_limit|uir_upper_limit

Description:

• adjacent_fir_identifier: identifies the Flight Information Region and Upper Information Region of airspace
• adjacent_uir_identifier: identifies the Flight Information Region and Upper Information Region of airspace
• arc_bearing: contains the true bearing from the "Arc Origin" position to the beginning of the arc
• arc_distance: define the distance in nautical miles from the "Arc Origin" position
• arc_origin_latitude: arc origin latitude in degrees decimal floating point (N positive, S negative)
• arc_origin_longitude: arc origin longitude in degrees decimal floating point (E positive, W negative)
• area_code: geographical area
• boundary_via: defines the path of the boundary from the position identified in the record to the next defined position
• cruise_table_identifier: indicate the cruising table
• fir_uir_address: communication address of the FIR/UIR to supplement the FIR/UIR ident
• fir_uir_identifier: identifies the Flight Information Region and Upper Information Region of airspace
• fir_uir_indicator: indicate the type of controlled airspace
• fir_uir_latitude: FIR/UIR latitude in degrees decimal floating point (N positive, S negative)
• fir_uir_longitude: FIR/UIR longitude in degrees decimal floating point (E positive, W negative)
• fir_uir_name: the name of the controlled airspace when assigned
• fir_upper_limit: contain the FIR upper limits
• reporting_units_altitude: indicate the units of measurement concerning the altitude used in the specific FIR/UIR
• reporting_units_speed: indicate the units of measurement concerning True Air Speed used in the specific FIR/UIR
• seqno: sort order of each airspace, no duplicate sequences per airspace are possible
• uir_lower_limit: contain the UIR lower limits
• uir_upper_limit: contain the UIR upper limits

Restrictive AirspaceRead the “Restrictive Airspace” section

SQLite Table: tbl_ur_restrictive_airspace

ASCII Format: arc_bearing|arc_distance|arc_origin_latitude|arc_origin_longitude|area_code|boundary_via|flightlevel|icao_code|latitude|longitude|lower_limit|multiple_code|restrictive_airspace_designation|restrictive_airspace_name|restrictive_type|seqno|unit_indicator_lower_limit|unit_indicator_upper_limit|upper_limit

Description:

• arc_bearing: contains the true bearing from the "Arc Origin" position to the beginning of the arc
• arc_distance: define the distance in nautical miles from the "Arc Origin" position
• arc_origin_latitude: arc origin latitude in degrees decimal floating point (N positive, S negative)
• arc_origin_longitude: arc origin longitude in degrees decimal floating point (E positive, W negative)
• area_code: geographical area of the airspace
• boundary_via: defines the path of the boundary from the position identified in the record to the next defined position
• flightlevel: defines the airway structure
• icao_code: location indicator of the airspace
• latitude: latitude in degrees decimal floating point (N positive, S negative)
• longitude: longitude in degrees decimal floating point (E positive, W negative)
• lower_limit: contain the lower limits
• multiple_code: indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• restrictive_airspace_designation: contains the number or name that uniquely identifies the restrictive airspace
• restrictive_airspace_name: name of the restrictive airspace when assigned
• restrictive_type: indicate the type of Airspace in which the flight of aircraft is prohibited or restricted
• seqno: sort order of each airspace, no duplicate sequences per airspace are possible
• unit_indicator_lower_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• unit_indicator_upper_limit: specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• upper_limit: contain the upper limits

GateRead the “Gate” section

SQLite Table: tbl_pb_gates

ASCII Format: airport_identifier|area_code|gate_identifier|gate_latitude|gate_longitude|icao_code|name

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area of the gate
• gate_identifier: airport gate identifier
• gate_latitude: latitude in degrees decimal floating point (N positive, S negative)
• gate_longitude: longitude in degrees decimal floating point (E positive, W negative)
• icao_code: location indicator of the gate
• name: name of the gate

GLSRead the “GLS” section

SQLite Table: tbl_pt_gls

ASCII Format: airport_identifier|area_code|gls_approach_bearing|gls_approach_slope|gls_category|gls_channel|gls_ref_path_identifier|gls_station_ident|icao_code|magnetic_variation|runway_identifier|station_elevation|station_latitude|station_longitude|station_type

Description:

• airport_identifier: four character ICAO location identifier
• area_code: geographical area of the GLS ground station
• gls_approach_bearing: magnetic bearing of the GLS course
• gls_approach_slope: glide slope angle of an GLS approach in degrees
• gls_category: ILS/MLS/GLS performance categories
• gls_channel: identifies the channel that will be decoded to identify the augmentation system used. 20001 -- 39999 for GBAS, 40000 -- 99999 for SBAS
• gls_ref_path_identifier: Identification code of the GLS Reference Path
• gls_station_ident: identification code for retrieval of such a transmitter (not a transmitted identifier)
• icao_code: location indicator of the gate
• magnetic_variation: specifies the angular difference between true north and magnetic north at the location
• runway_identifier: runway identifier
• station_elevation: elevation of GLS ground station in feet
• station_latitude: latitude in degrees decimal floating point (N positive, S negative)
• station_longitude: longitude in degrees decimal floating point (E positive, W negative)
• station_type: identifies the type of the different ground station

Path PointRead the “Path Point” section

SQLite Table: tbl_pp_pathpoint

ASCII Format: airport_icao_code|airport_identifier|approach_performance_designator|approach_procedure_ident|approach_type_identifier|area_code|course_width_at_threshold|flight_path_alignment_point_latitude|flight_path_alignment_point_longitude|fpap_ellipsoid_height|fpap_orthometric_height|glide_path_angle|gnss_channel_number|hal|landing_threshold_point_latitude|landing_threshold_point_longitude|length_offset|ltp_ellipsoid_height|operation_type|path_point_tch|reference_path_data_selector|reference_path_identifier|route_indicator|runway_identifier|sbas_service_provider_identifier|tch_units_indicator|val

Description:

• airport_icao_code: location indicator of the airport
• airport_identifier: four character ICAO location identifier
• approach_performance_designator: indicate the type or category of approach approach_procedure_ident: Identifier of the approach route
• approach_type_identifier: Identifies the approach types published on a given approach procedure
• area_code: geographical area of the point
• course_width_at_threshold: width of the lateral course at the Landing Threshold Point (LTP)
• flight_path_alignment_point_latitude: latitude of the navigation feature identified (N positive, S negative)
• flight_path_alignment_point_longitude: longitude of the navigation feature identified (E positive, W negative)
• fpap_ellipsoid_height: height of a surveyed point in reference to the WGS-84 ellipsoid
• fpap_orthometric_height: height of a surveyed point in reference to Mean Sea Level (MSL)
• glide_path_angle: angle in degrees
• gnss_channel_number: identifies the channel
• hal: horizontal alert limit is the radius of a circle in the horizontal plane
• landing_threshold_point_latitude: latitude of the navigation feature identified (N positive, S negative)
• landing_threshold_point_longitude: longitude of the navigation feature identified (E positive, W negative)
• length_offset: distance from the stop end of the runway (SER) to the FPAP
• ltp_ellipsoid_height: height of a surveyed point in reference to the WGS-84 ellipsoid
• ltp_orthometric_height: height of a surveyed point in reference to Mean Sea Level (MSL)
• operation_type: contains information on the type of final approach
• segment path_point_tch: height above the runway threshold (LTP)
• reference_path_data_selector: enables the automatic tuning of a procedure by ground based augmentation systems (GBAS) avionics
• reference_path_identifier: identifier to confirm selection of the correct approach procedure
• route_indicator: a single alpha character used to differentiate between multiple final approach segments to the same runway
• runway_identifier: runway identifier
• sbas_service_provider_identifier: associate the approach procedure to a particular satellite based approach system service provider
• tch_units_indicator: define the units (meters or feet)
• val: vertical alert limit is half the length of a segment on the vertical axis

AppendixesRead the “Appendixes” section

Navaid ClassRead the “Navaid Class” section

NDB ClassRead the “NDB Class” section

Waypoint Description CodeRead the “Waypoint Description Code” section

Waypoint Type for Enroute Waypoints (EA)Read the “Waypoint Type for Enroute Waypoints (EA)” section

Waypoint Type for Terminal Waypoints (PC)Read the “Waypoint Type for Terminal Waypoints (PC)” section

Cruise Table IdentifierRead the “Cruise Table Identifier” section

FIR/UIR IndicatorRead the “FIR/UIR Indicator” section

Waypoint UsageRead the “Waypoint Usage” section

Turn DirectionRead the “Turn Direction” section

Route Type for Enroute AirwaysRead the “Route Type for Enroute Airways” section

Route Type for SIDs (PD)Read the “Route Type for SIDs (PD)” section

Route Type for STARs (PE)Read the “Route Type for STARs (PE)” section

Route Type of IAPs (PF)Read the “Route Type of IAPs (PF)” section

LevelRead the “Level” section

Directional RestrictionRead the “Directional Restriction” section

IFR CapabilityRead the “IFR Capability” section

Longest Runway SurfaceRead the “Longest Runway Surface” section

ILS/MLS/GLS CategoryRead the “ILS/MLS/GLS Category” section

Marker TypeRead the “Marker Type” section

• blank

Reporting Units SpeedRead the “Reporting Units Speed” section

Reporting Units AltitudeRead the “Reporting Units Altitude” section

Path and TerminationRead the “Path and Termination” section

Speed Limit DescriptionRead the “Speed Limit Description” section

Airspace TypeRead the “Airspace Type” section

Altitude DescriptionRead the “Altitude Description” section

Boundary ViaRead the “Boundary Via” section

• blank

Restrictive Airspace TypeRead the “Restrictive Airspace Type” section

Restriction TypeRead the “Restriction Type” section

Units of AltitudeRead the “Units of Altitude” section

Block IndicatorRead the “Block Indicator” section

Frequency UnitsRead the “Frequency Units” section

Station TypeRead the “Station Type” section

• blank

Service IndicatorRead the “Service Indicator” section

• blank

FIR/UIR AddressRead the “FIR/UIR Address” section

Time CodesRead the “Time Codes” section

Time DistanceRead the “Time Distance” section

Airport TypeRead the “Airport Type” section

Fuel TypeRead the “Fuel Type” section

Each position at this field will indicate availability based on:

Time ZoneRead the “Time Zone” section

Part Time LightsRead the “Part Time Lights” section

Runway LightingRead the “Runway Lighting” section

Traffic PatternRead the “Traffic Pattern” section

Course FlagRead the “Course Flag” section

GNSS/FMS IndicatorRead the “GNSS/FMS Indicator” section

Level of Service AuthorizedRead the “Level of Service Authorized” section

Guard/TransmitRead the “Guard/Transmit” section

Time Of OperationRead the “Time Of Operation” section

The first two positions identify days of the week, with Monday equal to 1 and Sunday equal to 7. A single day, for example, Monday, is depicted as "01". A consecutive series of days, for example Monday through Friday, is depicted as "15". Non-consecutive days require multiple Time of Operation entries. The remaining 8 characters define a starting time of four characters and an ending time of four characters. These times are in the format HHMM (H=hours, M= minutes) using a 24 hour time system.

Times of Operation can also be expressed in terms of Sunrise (SR) and Sunset (SS). When a "Time of Operation" is defined as starting at or ending at Sunrise, that time is specified as "000R". When a "Time of Operation" is defined as starting at or ending at Sunset, that time is specified as "000S". When a "Time of Operation" is defined as starting at or ending at a certain number of hours/minutes before or after Sunrise or Sunset, those times are specified

Quadrant CodeRead the “Quadrant Code” section

Block IndicatorRead the “Block Indicator” section

Procedure Leg Data Fields (minimum requirements)Read the “Procedure Leg Data Fields (minimum requirements)” section

AF (Arc to a Fix) - FixIdentifier, TurnDirection, RecommendedNavaid, Theta (fix radial), RHO, MagCourse (boundary radial) CA (Course to an Altitude) - MagCourse, Alt1+ (at or above) CD (Course to a DME Distance) - RecommendedNavaid, MagCourse RouteDISTANCEHoldingTime (DME distance) CF (Course to a Fix) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse (course to specific fix), RouteDISTANCEHoldingTime (Path length) CI (Course to Intercept) - MagCourse CR (Course to a Radial termination) - RecommendedNavaid, Theta, MagCourse DF (Direct to a Fix) - FixIdentifier, FlyOver FA (Fix to an Altitude) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse, Alt1+ (at or above) FC (Track from a Fix for a Distance) - FixIdentifier, FlyOver, RecommendedNavaid, Theta, RHO, MagCourse, RouteDISTANCEHoldingTime (Path length) FD (Track from a Fix to a DME Distance) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse, RouteDISTANCEHoldingTime (DME distance) FM (From a Fix to Manual termination) - FixIdentifier, RecommendedNavaid, Theta, RHO, MagCourse HA (Holding mandatory) - FixIdentifier, TurnDirection, MagCourse, RouteTIMEDistanceHoldingTime, Alt1+ (at or above) HF (Holding in lieu of Procedure Turn) - FixIdentifier, TurnDirection, MagCourse, RouteTIMEDistanceHoldingTime HM (Holding mandatory) - FixIdentifier, TurnDirection, MagCourse, RouteTIMEDistanceHoldingTime IF (Initial Fix) - FixIdentifier PI (045/180 Procedure Turn) - FixIdentifier, TurnDirection, RecommendedNavaid, Theta, RHO, MagCourse, RouteTimeDISTANCEHoldingTime (excursion distance from fix), Alt1 RF (Constant Radius Arc) - FixIdentifier, TurnDirection, Theta (inbound tangential track), MagCourse, RouteTimeDISTANCEHoldingTime (along track distance), ArcCenter TF (Track to a Fix) - FixIdentifier, Overfly VA (Heading to an Altitude) - MagCourse (Heading), Alt1+ (at or above) VD (Heading to a DME Distance) - RecommendedNavaid, MagCourse (Heading), RouteTimeDISTANCEHoldingTime (DME distance) VI (Heading to an Intercept) - MagCourse (Heading) VM (Heading to a Manual Termination) - MagCourse(Heading) VR (Heading to a Radial) - RecommendedNavaid, Theta, MagCourse (Heading)