DFD 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 ARINC 424 specifications, though tailored to Flight Simulator add-ons use. Whenever possible, we use the same naming conventions as the ARINC specification, to avoid confusion. Whenever possible, we will also clearly indicate from which sections and record columns the data has to be extracted from.

We used the standard ARINC424-18 specification, but it should forward compatible with 424-19/20. The DFD dataset is provided in a SQLite file. We can also prepare a customized DFD formatted dataset. The DFD can be parsed into any file format, including plain ASCII text files, and can include any record in this documentation, and also additional data.

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)

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

SpecificationRead the “Specification” section

When provided in SQLite binary file format, the name of the tables has following syntax:

tbl_<tablename> All columns in the records are lowercase. The columns contain no spaces, the _ (underline) character is used to separate words, if necessary.

When provided in ASCII text file format 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 – see the footnotes).

Header lineRead the “Header line” section

CREATE TABLE [tbl_header] (
    [version] TEXT(5) NOT NULL,
    [arincversion] TEXT(6) NOT NULL,
    [revision] TEXT(2) NOT NULL,
    [record_set] TEXT(8) NOT NULL,
    [current_airac] TEXT(4) NOT NULL,
    [effective_fromto] TEXT(10) NOT NULL,
    [previous_airac] TEXT(4) NOT NULL,
    [previous_fromto] TEXT(10) NOT NULL,
    [parsed_at] TEXT(22) NOT NULL
)

ASCII Format:

version|arincversion|record-set|current AIRAC cycle|Revision|effective from-to|previous AIRAC cycle|effective from-to|parsed at

Example:

0.3|424-18|extended|1610|2|1509121016|1609|1808140916|01/01/01 – 10:10:10UTC

Description:

• version : the current version of the specifications (0.3)
• arincversion : the current used ARINC version (424-18)
• record-set : indicates the data content - extended
• current AIRAC : the current AIRAC cycle (1610)
• revision : revision of the current AIRAC cycle
• effective from-to : the date, when the current AIRAC cycle starts/ends (Format DDMMDDMMYY– DD is the day, MM is the month, YY is the year) (1509121016)
• previous AIRAC : the current AIRAC cycle (1609)
• effective from-to : is the date, when the current AIRAC cycle starts/ends (Format DDMMDDMMYY– DD is the day, MM is the month, YY is the year) (1808140916)
• parsed at : parsing/creation date of the current AIRAC cycle (Format DD/MM/YY – HH:MM:SS in UTC)

VHF NavaidsRead the “VHF Navaids” section

CREATE TABLE [tbl_vhfnavaids] (
    [area_code] TEXT(3),
    [airport_identifier] TEXT(4),
    [icao_code] TEXT(2) NOT NULL,
    [vor_identifier] TEXT(4) NOT NULL,
    [vor_name] TEXT(30),
    [vor_frequency] REAL(5),
    [navaid_class] TEXT(5,
    [vor_latitude] REAL(9),
    [vor_longitude] REAL(10),
    [dme_ident] TEXT(4),
    [dme_latitude] REAL(9),
    [dme_longitude] REAL(10),
    [dme_elevation] INT(5),
    [ilsdme_bias] REAL(3),
    [range] INT(3),
    [station_declination] REAL(5)
)

CREATE UNIQUE INDEX [pk_key]
    ON [tbl_vhfnavaids]
    ([icao_code],[vor_identifier])

ASCII Format:

Area Code|Airport ICAO Identifier|ICAO Code|VOR Identifier|VOR Name|VOR Frequency|NAVAID class|VOR Latitude|VOR Longitude|DME Ident|DME Latitude|DME Longitude|DME elevation|ILS/DME bias|Range|Station Declination

Example:

EUR|LOWW|LO|WGM|WAGRAM|112.20|VDHW |48.32385556|16.49095278||48.32301667|16.49080833|574||130|4.1

EUR|LOWW|LO|OEX|SCHWECHAT|109.55| IT N|||OEX|48.10885833|16.57153889|624||25|4.1

Description:

• Area Code : geographical area of the navaid
• Airport Identifier : four character ICAO location identifier
• ICAO Code : location indicator of the navaid
• VOR Identifier : navaid identifier
• VOR Name : navaid name
• VOR Frequency : navaid frequency in kHz
• NAVAID class : navaid type, range/power, additional information & collocation (see appendix #navaid)
• VOR Latitude : navaid latitude in degrees decimal floating point (N positive, S negative)
• VOR Longitude : navaid longitude in degrees decimal floating point (E positive, W negative)
• 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)
• DME Elevation : DME elevation in feet AMSL
• ILS/DME bias : specify the DME offset
• Range : navaid usable range in nautical miles
• Station Declination : angular difference between true north and the zero degree radial of the navaid in degrees

Enroute NDB NavaidsRead the “Enroute NDB Navaids” section

CREATE TABLE [tbl_enroute_ndbnavaids] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2) NOT NULL,
    [ndb_identifier] TEXT(4) NOT NULL,
    [ndb_name] TEXT(30),
    [ndb_frequency] REAL(5),
    [navaid_class] TEXT(5),
    [ndb_latitude] REAL(9,
    [ndb_longitude] REAL(10)
)

CREATE UNIQUE INDEX [pk_db]
    ON [tbl_ndbnavaids]
    ([icao_code],[ndb_identifier])

ASCII Format:

Area Code|ICAO Code|NDB Identifier|NDB Name|NDB Frequency|NDB class|NDB Latitude|NDB Longitude

Example:

EUR|LO|STE|STEINHOF|293.00|H MW |48.21061667|16.24713611

Description:

• Area Code : geographical area of the NDB
• ICAO Code : location indicator of the NDB
• NDB Identifier : NDB identifier
• NDB Name : NDB name
• NDB Frequency : NDB frequency in Mhz
• NDB class : NDB type, range/power, additional information & collocation (see appendix 3.1)
• NDB Latitude : NDB latitude in degrees decimal floating point (N positive, S negative)
• NDB Longitude : NDB longitude in degrees decimal floating point (E positive, W negative)

Terminal NDB NavaidsRead the “Terminal NDB Navaids” section

CREATE TABLE [tbl_terminal_ndbnavaids] (
    [area_code] TEXT(3),
    [airport_identifier] TEXT(4) NOT NULL,
    [icao_code] TEXT(2) NOT NULL,
    [ndb_identifier] TEXT(4) NOT NULL,
    [ndb_name] TEXT(30),
    [ndb_frequency] REAL(5),
    [navaid_class] TEXT(5),
    [ndb_latitude] REAL(9),
    [ndb_longitude] REAL(10)
)

CREATE UNIQUE INDEX [pk_pn]
    ON [tbl_ndbnavaids]
    ([airport_identifier],[icao_code],[ndb_identifier])

ASCII Format:

Area Code|Airport Identifier|ICAO Code|NDB Identifier|NDB Name|NDB Frequency|NDB class|NDB Latitude|NDB Longitude

Example:

EUR|ED|MNW|MUNICH|338.00|H MW |48.37426667|16.24713611

Description:

• Area Code : geographical area of the NDB
• Airport Identifier : four character ICAO location identifier
• ICAO Code : location indicator of the NDB
• NDB Identifier : NDB identifier
• NDB Name : NDB name
• NDB Frequency : NDB frequency in Mhz
• NDB class : NDB type, range/power, additional information & collocation (see appendix 3.1)
• NDB Latitude : NDB latitude in degrees decimal floating point (N positive, S negative)
• NDB Longitude : NDB longitude in degrees decimal floating point (E positive, W negative)

Enroute WaypointsRead the “Enroute Waypoints” section

CREATE TABLE [tbl_enroute_waypoints] (
    [area_code] TEXT(3,
    [icao_code] TEXT(2) NOT NULL,
    [waypoint_identifier] TEXT(5) NOT NULL,
    [waypoint_name] TEXT(25),
    [waypoint_type] TEXT(3),
    [waypoint_usage] TEXT(2),
    [waypoint_latitude] REAL(9,
    [waypoint_longitude] REAL(10)
)

CREATE UNIQUE INDEX [pk_ea]
    ON [tbl_enroute_waypoints]
    ([icao_code],[waypoint_identifier])

ASCII Format:

Area Code|ICAO Code|Waypoint Identifier|Waypoint Name|Waypoint Type|Waypoint Usage|Waypoint Latitude|Waypoint Longitude

Example:

EUR|LO|ABETI|ABETI|WU|RB|47.67771389|17.01284167

Description:

• Area Code : geographical area of the waypoint
• ICAO Code : location indicator of the waypoint
• Waypoint Identifier : waypoint identifier
• Waypoint Name : waypoint name
• Waypoint Type : waypoint type (see appendix 3.3)
• Waypoint Usage : waypoint usage (see appendix 3.7)
• 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)

Terminal WaypointsRead the “Terminal Waypoints” section

CREATE TABLE [tbl_terminal_waypoints] (
    [area_code] TEXT(3),
    [region_code] TEXT(4) NOT NULL,
    [icao_code] TEXT(2) NOT NULL,
    [waypoint_identifier] TEXT(5) NOT NULL,
    [waypoint_name] TEXT(25),
    [waypoint_type] TEXT(3),
    [waypoint_latitude] REAL(9),
    [waypoint_longitude] REAL(10)
)

CREATE UNIQUE INDEX [pk_pc]
    ON [tbl_terminal_waypoints]
    ([area_code],[region_code],[icao_code],
    [waypoint_identifier])

ASCII Format:

Area Code|Region Code|ICAO Code|Waypoint Identifier|Waypoint Name|Waypoint Type|Waypoint Latitude|Waypoint Longitude

Example:

EUR|LOWW|LO|FI29|OEX112009|IAF|48.05601389|16.73783056

Description:

• Area Code : geographical area of the waypoint
• Region Code : airport identification code for the terminal waypoint
• ICAO Code : location indicator of the waypoint
• Waypoint Identifier : waypoint identifier
• Waypoint Name : waypoint name
• Waypoint Type : waypoint type (see appendix 3.4)
• 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)

HoldingsRead the “Holdings” section

CREATE TABLE [tbl_holdings] (
    [area_code] TEXT(3),
    [region_code] TEXT(4),
    [icao_code] TEXT(2),
    [fix_identifier] TEXT(5),
    [holding_name] TEXT(25),
    [fix_latitude] REAL(9),
    [fix_longitude] REAL(10),
    [duplicate_identifier] INT(2),
    [inbound_holding_course]REAL(5),
    [turn_direction] TEXT(1),
    [leg_length] REAL(3),
    [leg_time] REAL(2),
    [minimum_altitude] INT(5),
    [maximum_altitude] INT(5),
    [holding_speed] INT(3)
)

ASCII Format:

Area Code|Region Code|ICAO Code|Fix Identifier|Holding Name|Fix Latitude|Fix Longitude|Duplicate Identifier|Inbound Holding Course|Turn Direction|Leg Length|eg Time|Minimum Altitude|Maximum Altitude|Holding Speed

Example:

EUR|LOWW|LO|WW814|WW814|48.24151111|16.16855556|50|113.0|R|0|1|5000||210

EUR|ENRT|ED|LMA|LIMA|51.37091389|6.394925|20|240.0|R|0|1|4000|FL240|

Description:

• Area Code : geographical area of the waypoint
• Region Code : static text ENRT or airport identification code
• ICAO Code : location indicator of the waypoint
• Fix Identifier : navaid or waypoint identifier
• Holding Name : holding name
• Fix Latitude : navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• Fix Longitude : navaid or waypoint longitude in degrees decimal floating point (E positive, W negative)
• Duplicate Identifier : used for more than one holding patterns for a single navaid or waypoint
• Inbound Holding Course : inbound magnetic course in degrees floating point
• Turn Direction : holding turn direction (see appendix 3.8)
• Leg Length : inbound leg length in nautical miles, decimal floating point
• Leg Time : inbound leg time in minutes, decimal floating point
• Minimum Altitude : contain altitudes in feet or flight level
• Maximum Altitude : contain altitudes in feet or flight level
• Holding Speed : holding speed limit in knots

Enroute AirwaysRead the “Enroute Airways” section

CREATE TABLE [tbl_enroute_airways] (
    [area_code] TEXT(3),
    [route_identifier] TEXT(5),
    [seqno] INT(4),
    [icao_code] TEXT(2),
    [fix_identifier] TEXT(5),
    [fix_latitude] REAL(9),
    [fix_longitude] REAL(10),
    [waypoint_description_code] TEXT(4),
    [route_type] TEXT(1),
    [flightlevel] TEXT(1),
    [directional_restriction] TEXT(1),
    [crusing_table_identifier] TEXT(2),
    [minimum_altitude1] INT(5),
    [minimum_altitude2] INT(5),
    [maximum_altitude] INT(5),
    [outbound_course] REAL(5),
    [inbound_course] REAL(5),
    [inbound_distance] REAL(5)
)

ASCII Format:

Area Code|Route Identifier|Sequence Number|ICAO Code|Fix Identifier|Fix Latitude|Fix Longitude|Waypoint Description Code|Route Type|Flightlevel|Direction Restriction| Cruise Table Identifier|Minimum Altitude1|Minimum Altitude2|Maximum Altitude|Outbound Course|Inbound Course|Distance

Example:

EUR|M725|LO|UMBIL|47.35331944|15.60116944|T|R|L||9000|9000|24500|100.0|237.5|34.0

EUR|UM725|LO|UMBIL|47.35331944|15.60116944|T|R|H|B|XX|24500|26000|66000|100.0|237.5|34.0

Description:

• Area Code : geographical area of the waypoint
• Route Identifier : enroute route identifier
• Sequence Number : sort order of each enroute airway, no duplicate sequences per airway are possible
• ICAO Code : location indicator of the waypoint
• Fix Identifier : navaid or waypoint identifier
• Fix Latitude : navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• Fix Longitude : navaid or waypoint longitude in degrees decimal floating point (E positive, W negative)
• Waypoint Description Code : provides information on the type of fix (see appendix 3.2)
• Route Type : indicated the route type (see appendix 3.9)
• Flightlevel : defines the airway structure (see appendix 3.13)
• Directional Restriction : indicate the flyable direction (see appendix 3.14)
• Cruise Table Identifier : indicate the cruising table (see appendix 3.5)
• Minimum Altitude1 : contain altitudes in feet
• Minimum Altitude2 : contain altitudes in feet
• Maximum Altitude : contain altitudes in feet
• Outbound Course : outbound magnetic course from the waypoint identified in the record's "Fix Identifier" field
• Inbound Course : inbound magnetic course to the waypoint identified in the record's "Fix Identifier" field
• Inbound Distance : contain segment distances/along track distances/excursion distances/DME distances in nautical miles

AirportsRead the “Airports” section

CREATE TABLE [tbl_airports] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2) NOT NULL,
    [airport_identifier] TEXT(4) NOT NULL,
    [airport_identifier_3letter] TEXT(3),
    [airport_name] TEXT(30),
    [airport_ref_latitude] REAL(9),
    [airport_ref_longitude] REAL(10),
    [ifr_capability] TEXT(1),
    [longest_runway_surface_code] TEXT(1),
    [elevation] INT(5),
    [transition_altitude] INT(5),
    [speed_limit] INT(3),
    [speed_limit_altitude] INT(5),
    [iata_ata_designator] TEXT(3)
)

CREATE UNIQUE INDEX [pk_pa]
    ON [tbl_airports]
    ([icao_code],[airport_identifier])

ASCII Format:

Area Code|ICAO Code|Airport Identifier|Airport Identifier 3-Letter|Airport Name|Airport Ref Latitude|Airport Ref Longitude|IFR Capability|Longest Runway Surface Code|Elevation|Transition Altitude|Speedlimit|Speedlimit Altitude|Iata Ata Designator

Example:

EUR|LO|LOWW||SCHWECHAT|48.11027778|16.56972222|Y|H|600|10000|250|FL100|VIE

Description:

• Area Code : geographical area of the airport
• ICAO Code : location indicator of the airport
• Airport Identifier : four character ICAO location identifier
• Airport Identifier 3-Letter Code : three character ICAO continental location identifier for USA and CAN airports
• 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)
• IFR Capability : indicates if the airport has a published IAP (see appendix 3.15)
• Longest Runway Surface Code : define if there is a hard runway or not (see appendix 3.16)
• Elevation : elevation in feet above MSL
• Transition Altitude : transition altitude in feet
• Speed Limit : speed limit in knots
• Speed Limit Altitude : altitude below which speed limit may be imposed (feet or flight level)
• iata_ata_designator : IATA/ATA airport designator code

RunwaysRead the “Runways” section

CREATE TABLE [tbl_runways] (
    [area_code] TEXT(3,
    [icao_code] TEXT(2),
    [airport_identifier] TEXT(4) NOT NULL,
    [runway_identifier] TEXT(3) NOT NULL,
    [runway_latitude] REAL(9),
    [runway_longitude] REAL(10),
    [runway_gradient] INT(5),
    [runway_magnetic_bearing] REAL(6),
    [runway_true_bearing] REAL(7),
    [landing_threshold_elevation] INT(5),
    [displaced_threshold_distance] INT(4),
    [threshold_crossing_height] INT(2),
    [runway_length] INT(5),
    [runway_width] INT(3),
    [llz_identifier] TEXT(4),
    [llz_mls_gls_category] TEXT(1)
)

CREATE UNIQUE INDEX [pk_pg]
    ON [tbl_runways]
    ([airport_identifier],[runway_identifier])

ASCII Format:

Area Code|ICAO Code|Airport Identifier|Runway Identifier|Runway Latitude|Runway Longitude|Runway Gradient|Runway Magnetic Bearing|Runway True Bearing|Landing Threshold Elevation|Displaced Threshold Distance|Threshold Crossing Height|Runway Length|Runway Width|LLZ Identifier|LLZ Category/Class

Example:

EUR|LO|LOWW|29|48.10904722|16.57563056|-0.218|292.0|296.019|600||52|11483|148|OEX|3

Description:

• Area Code : geographical area of the runway
• ICAO Code : location indicator of the runway
• Airport Identifier : four character ICAO location identifier
• Runway Identifier : runway identifier
• Runway Latitude : runway latitude in degrees decimal floating point (N positive, S negative)
• Runway Gradient : overall gradient in percent (positive is upward, negative is downward)
• 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 : rue bearing of the runway identifier
• Landing Threshold Elevation : elevation of the landing threshold in feet
• Displaced Threshold Distance : distance from the extremity of a runway to a threshold in feet
• Threshold Crossing Height : height above the landing threshold on a normal glide path
• Runway Length : runway length in feet
• Runway Width : runway width in feet
• LLZ Identifier : ILS/MLS/GLS facility
• ILS/MLS/GLS Category : ILS/MLS/GLS performance categories (see appendix 3.17)

Localizer/GlideslopesRead the “Localizer/Glideslopes” section

CREATE TABLE [tbl_localizers_glideslopes] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [airport_identifier] TEXT(4) NOT NULL,
    [runway_identifier] TEXT(3),
    [llz_identifier] TEXT(4) NOT NULL,
    [llz_latitude] REAL(9),
    [llz_longitude] REAL(10),
    [llz_frequency] REAL(6),
    [llz_bearing] REAL(6),
    [llz_width] REAL(6),
    [ils_mls_gls_category] TEXT(1),
    [gs_latitude] REAL(9),
    [gs_longitude] REAL(10),
    [gs_angle] REAL(4),
    [gs_elevation] INT(5),
    [station_declination] REAL(5)
)

CREATE UNIQUE INDEX [pk_pi]
    ON [tbl_localizers_glideslopes]
    ([airport_identifier],[llz_identifier])

ASCII Format:

Area Code|ICAO Code|Airport Identifier|Runway Identifier|LLZ Identifier|LLZ Latitude|LLZ Longitude|LLZ Frequency|LLZ Bearing|LLZ Width|ILS Category|GS Latitude|GS Longitude|GS Angle|GS Elevation|Station Declination

Example:

EUR|LO|LOWW|29|OEX|48.124775|16.52732778|109.55|292.0|0.0|3|48.10894444|16.57161111|3.00|658|4.0

Description:

• Area Code : geographical area of the localizer
• ICAO Code : location indicator of the localizer
• Airport Identifier : four character ICAO location identifier
• Runway Identifier : runway identifier
• 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 Frequency : VHF frequency of the facility in MHz
• LLZ Bearing : magnetic bearing of the localizer course
• LLZ Width : specifies the localizer course width (in degrees) of the ILS facility
• ILS/MLS/GLS Category : ILS/MLS/GLS performance categories (see appendix 3.17)
• 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)
• GS Angle : glide slope angle of an ILS facility/GLS approach in degrees
• GS Elevation : elevation of LLZ in feet
• Station Declination : angular difference between true north and the zero degree radial of the LLZ in degrees

Localizer MarkerRead the “Localizer Marker” section

CREATE TABLE [tbl_localizer_marker] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [airport_identifier] TEXT(4) NOT NULL,
    [runway_identifier] TEXT(3),
    [llz_identifier] TEXT(4) NOT NULL,
    [marker_identifier] TEXT(4) NOT NULL,
    [marker_type] TEXT(3),
    [marker_latitude] REAL(9),
    [marker_longitude] REAL(10)
)

CREATE UNIQUE INDEX [pk_pm]
    ON [tbl_localizer_marker]
    ([airport_identifier],[llz_identifier])

ASCII Format:

Area Code|ICAO Code|Airport Identifier|Runway Identifier|LLZ Identifier|Marker Type|Marker Latitude|Marker Longitude

Example:

EUR|ED|EDDT|08L|ITLE|OM08L| OM|52.54570278|13.15108333

Description:

• Area Code : geographical area of the marker
• ICAO Code : location indicator of the marker
• Airport Identifier : four character ICAO location identifier
• Runway Identifier : runway identifier
• LLZ Identifier : identification code of the LLZ, MLS facility or GLS reference path
• Marker Identifier: marker identifier
• Marker Type : defines the type of marker (see appendix 3.18)
• 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)

Terminal ProceduresRead the “Terminal Procedures” section

CREATE TABLE [tbl_sids/stars/iaps] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [airport_identifier] TEXT(4),
    [procedure_identifier] TEXT(6),
    [route_type] TEXT(1),
    [transition_identifier] TEXT(5),
    [seqno] INT(3),
    [waypoint_identifier] TEXT(5),
    [waypoint_latitude] REAL(9),
    [waypoint_longitude] REAL(10),
    [waypoint_description_code] TEXT(4),
    [turn_direction] TEXT(1),
    [rnp] REAL(4),
    [path_termination] TEXT(2),
    [recommanded_navaid] TEXT(4),
    [recommanded_navaid_latitude] REAL(9),
    [recommanded_navaid_longitude] REAL(10),
    [arc_radius] REAL(7),
    [theta] REAL(5),
    [rho] REAL(5),
    [magnetic_course] REAL(5),
    [route_distance_holding_distance_time] REAL(5),
    [distance_time] TEXT(1),
    [altitude_description] TEXT(1),
    [altitude1] INT(5),
    [altitude2] INT(5),
    [transition_altitude] INT(5),
    [speed_limit_description] TEXT(1),
    [speed_limit] INT(3),
    [vertical angle] REAL(4),
    [center_waypoint] TEXT(5),
    [center_waypoint_latitude] REAL(9),
    [center_waypoint_longitude] REAL(9)
)

ASCII Format:

Area Code|ICAO Code|Airport Identifier|Procedure Identifier|Route Type|Transition Identifier|Sequence Number|Waypoint Identifier|Waypoint Latitude|Waypoint Longitude|Waypoint Description Code|Turn Direction|RNP|Path and Termination|Recommanded Navaid|Recommanded Navaid Latitude|Recommanded Navaid Longitude|ARC Radius|Theta|Rho|Magnetic Course|Route Distance/Holding Distance or Time|Distance Time|Altitude Description|Altitude1|Altitude2|Transition Altitude|Speed Limit Description|Speed Limit|Vertical Angle|Center Waypoint|Center Waypoint Latitude|Center Wayoint Longitude

Example:

EUR|LO|LOWW|ADAM1A|5|RW11|10|WW100|48.08981667|16.63360278|EY|||CF|FMD|48.10511389|16.62926389||165.2|0.9|112.0|3.0||||10000|-|205||||||

Description:

• Area Code : geographical area of the marker
• ICAO Code : location indicator of the marker
• Airport Identifier : four character ICAO location identifier
• Procedure Identifier : name of the terminal procedure
• Route Type : element of the terminal procedure (see appendix 3.10/3.11/3.12)
• Transition Identifier : describes the type of transition to be made from the enroute environment into the terminal area and vice versa
• Sequence Number : sequence definition phase of the terminal procedure
• Waypoint Identifier : : navaid or waypoint identifier
• Waypoint Latitude : navaid or waypoint latitude in degrees decimal floating point (N positive, S negative)
• Fix Longitude : navaid or waypoint longitude in degrees decimal floating point (E positive, W negative)
• Waypoint Description Code : the field provides information on the type of fix (see appendix 3.2)
• Turn Direction : turn direction (see appendix 3.8)
• RNP : statement of the Navigation Performance necessary for operation within a defined airspace in accordance with ICAO Annex 15 and/or State published rules
• Path and Termination : defines the path geometry for a single record of an terminal procedure (see appendix 3.21)
• Recommended Navaid : reference facility for the fix
• 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)
• ARC Radius : used to define the radius of a precision turn
• Theta : defined as the magnetic bearing to the waypoint identified in the record's "Fix Identifier" field from the Navaid in the "Recommended Navaid" field
• Rho : defined as the geodesic distance in nautical miles to the waypoint identified in the record's "Fix Identifier" field from the NAVAID in the "Recommended Navaid" field
• Magnetic Course : outbound magnetic course from the waypoint identified in the record's "Fix Identifier" field
• Route Distance/Holding Distance or Time : contain segment distances/along track distances/excursion distances/DME distances
• Distance/Time : indicates, if the value in the "Route Distance/Holding" column references to a time value, or distance value (see appendix 3.36)
• Altitude Description : designate whether a waypoint should be crossed (see appendix 3.24)
• Altitude1 : contain altitudes in feet or flight level
• Altitude2 : contain altitudes in feet or flight level
• Transition Altitude : transition altitude in feet
• Speed Limit Description : designate whether the speed limit coded at a fix in a terminal procedure description is a mandatory, minimum or maximum speed (see appendix 3.22)
• Speed Limit : speed limit in knots
• Vertical Angle : defines the vertical navigation path prescribed for the procedure
• Center Waypoint : represents the MSA Center, that point (Navaid or Waypoint) on which the MSA is predicated
• 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)

Airport CommunicationRead the “Airport Communication” section

CREATE TABLE [tbl_airport_communication] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [airport_identifier] TEXT(4),
    [communication_type] TEXT(3),
    [communication_frequency]REAL(5),
    [frequency_units] TEXT(1),
    [service_indicator] TEXT(3),
    [callsign] TEXT(25),
    [latitude] REAL(9),
    [longitude] REAL(10)
)

ASCII Format:

Area Code|ICAO Code|Airport Identifier|Communication Type|Communication Frequency|Frequency Units|Service Indicator|Callsign|Latitude|Longitude

Example:

EUR|LO|LOWW|APP|118.775|V||WIEN RADAR|48.11027778| 16.56972222

Description:

• Area Code : geographical area of the facility
• ICAO Code : location indicator of the facility
• Airport Identifier : four character ICAO location identifier
• Communication Type : specified the type of communication unit (see appendix 3.32)
• Communication Frequency : specifies a frequency for the facility identified in the communicaton type field
• Frequency Units : designate the frequency spectrum area for the frequency (see appendix 3.30)
• Service Indicator : define the use of the frequency for the specified communication type (see appendix 3.33)
• Callsign : name of the facility being called
• Latitude : latitude in degrees decimal floating point (N positive, S negative)
• Longitude : longitude in degrees decimal floating point (E positive, W negative)

Enroute CommunicationRead the “Enroute Communication” section

CREATE TABLE [tbl_enroute_communication] (
    [area_code] TEXT(3),
    [fir_rdo_ident] TEXT(4),
    [fir_uir_indicator] TEXT(1),
    [communication_type] TEXT(3),
    [communication_frequency] REAL(5),
    [frequency_units] TEXT(1),
    [service_indicator] TEXT(3),
    [remote_name] TEXT(25),
    [callsign] TEXT(30),
    [latitude] REAL(9),
    [longitude] REAL(10)
)

ASCII Format:

Area Code|FIR/RDO Ident|FIR/UIR Indicator|Communication Type|Comm Frequency|Frequency Units|Service Indicator|Remote Name|CallSign|Latitude|Longitude

Example:

EUR|LOVV|F|||130.475||||VIENNA RADAR|48.11027778| 16.56972222

Description:

• Area Code : geographical area of the facility
• FIR/RDO Ident : identifies the Flight Information Region or Upper Information Region
• FIR/UIR Indicator : contain the identifier of a FIR, UIR or combined FIR/UIR (see appendix 3.6)
• Communication Type : specified the type of communication unit (see appendix 3.32)
• Communication Frequency : specifies a frequency for the facility identified in the communicaton type field
• Frequency Units : designate the frequency spectrum area for the frequency (see appendix 3.30)
• Service Indicator : define the use of the frequency for the specified communication type (see appendix 3.33)
• Remote Name : name of unmanned air/ground facility
• Callsign : name of the facility being called
• Latitude : latitude in degrees decimal floating point (N positive, S negative)
• Longitude : longitude in degrees decimal floating point (E positive, W negative)

Grid MoraRead the “Grid Mora” section

CREATE TABLE [tbl_grid_mora] (
    [starting_latitude] INT(3),
    [starting_longitude] INT(4),
    [mora01] TEXT(3),
    [mora02] TEXT(3),
    [mora03] TEXT(3),
    [mora04] TEXT(3),
    [mora05] TEXT(3),
    [mora06] TEXT(3),
    [mora07] TEXT(3),
    [mora08] TEXT(3),
    [mora09] TEXT(3),
    [mora10] TEXT(3),
    [mora11] TEXT(3),
    [mora12] TEXT(3),
    [mora13] TEXT(3),
    [mora14] TEXT(3),
    [mora15] TEXT(3),
    [mora16] TEXT(3),
    [mora17] TEXT(3),
    [mora18] TEXT(3),
    [mora19] TEXT(3),
    [mora20] TEXT(3),
    [mora21] TEXT(3),
    [mora22] TEXT(3),
    [mora23] TEXT(3),
    [mora24] TEXT(3),
    [mora25] TEXT(3),
    [mora26] TEXT(3),
    [mora27] TEXT(3),
    [mora28] TEXT(3),
    [mora29] TEXT(3),
    [mora30] TEXT(3)
)

ASCII Format:

Start Latitude|Start Longitude|Mora01|Mora02|Mora03|Mora04|Mora05|Mora06|Mora07|Mora08|Moa09|Mora10|Mora11|Mora12|Mora13|Mora14|Mora15|Mora16|Mora17|Mora18|Mora19|Mora20|Mora21|Mora22|Mora23|Mora24|Mora25|Mora26|Mora27|Mora28|Mora29|Mora30

Example:

N48|E000|035|035|035|035|035|035|064|064|055|046|041|037|050|073|057|050|042|046|076|091|088|054|073|078|088|065|029|026|025|027

Description:

• Starting Latitude : latitude in degrees decimal floating point (N positive, S negative)
• Starting Longitude : longitude in degrees decimal floating point (E positive, W negative)
• Mora01 – Mora30: terrain and obstruction clearance within the section outlined by latitude and longitude blocks in feet

Airport MSARead the “Airport MSA” section

CREATE TABLE [tbl_airport_msa] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [airport_identifier] TEXT(4),
    [msa_center] TEXT(5),
    [msa_center_latitude] REAL(9),
    [msa_center_longitude] REAL(10),
    [magnetic_true_indicator] TEXT(1),
    [multiple_code] TEXT(1),
    [radius_limit] INT(2),
    [sector_bearing_1] INT(3),
    [sector_altitude_1] INT(3),
    [sector_bearing_2] INT(3),
    [sector_altitude_2] INT(3),
    [sector_bearing_3] INT(3),
    [sector_altitude_3] INT(3),
    [sector_bearing_4] INT(3),
    [sector_altitude_4] INT(3),
    [sector_bearing_5] INT(3),
    [sector_altitude_5] INT(3)
)

ASCII Format:

Area Code|ICAO Code|Airport Identifier|MSA Center|MSA Center Latitude|MSA Center Longitude|Magnetic/True/Indicator|Multiple Code|Radius Limit|Sector Bearing 1|Sector Altitude 1|Sector Bearing 2|Sector Altitude 2|Sector Bearing 3|Sector Altitude 3|Sector Bearing 4|Sector Altitude 4|Sector Bearing 5|Sector Altitude 5

Example:

EUR|LO|LOWW|BRK|48.06292222|16.71674722|270|2700|25|360|4200|10|||||||||||||||

Description:

• Area Code : geographical area
• ICAO Code : location indicator of the airport
• Airport Identifier : four character ICAO location identifier
• MSA Center : MSA center fix
• 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)
• Multiple Code : indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• Sector Bearing 1-7 : sector bearing in degrees
• Sector Altitude 1-7 : sector altitude in feet
• Sector Radius 1-7 : radius from MSA Center fix in nautical miles

Enroute Airways RestrictionRead the “Enroute Airways Restriction” section

CREATE TABLE [tbl_enroute_airway_restriction] (
    [area_code] TEXT(3),
    [route_identifier] TEXT(5),
    [restriction_identifier]  INT(3),
    [restriction_type] TEXT(2),
    [start_waypoint_identifier] TEXT(5),
    [start_waypoint_latitude] REAL(9),
    [start_waypoint_longitude] REAL(10),
    [end_waypoint_identifier] TEXT(5),
    [end_waypoint_latitude] REAL(9),
    [end_waypoint_longitude] REAL(10),
    [start_date] TEXT(7),
    [end_date] TEXT(7),
    [units_of_altitude] TEXT(1),
    [restriction_altitude1] INT(3),
    [block_indicator1] TEXT(1),
    [restriction_altitude2] INT(3),
    [block_indicator2] TEXT(1),
    [restriction_altitude3] INT(3),
    [block_indicator3] TEXT(1),
    [restriction_altitude4] INT(3),
    [block_indicator4] TEXT(1),
    [restriction_altitude5] INT(3),
    [block_indicator5] TEXT(1),
    [restriction_altitude6] INT(3),
    [block_indicator6] TEXT(1),
    [restriction_altitude7] INT(3),
    [block_indicator7] TEXT(1)
)

ASCII Format:

Area Code|Route Identifier|Restriction Identifier|Restriction Type|Start Waypoint Identifier|Start Waypoint Latitude|Start Waypoint Longitude|End Waypoint Identifier|End Waypoint Latitude|End Waypoint Longitude|Start Date|End Date|Units of Altitude|Restriction Altitude1|Block Indicator1|Restricted Altitude2|Block Indicator2|Restricted Altitude3|Block Indicator3|Restricted Altitude4|Block Indicator4|Restricted Altitude5|Block Indicator5|Restricted Altitude6|Block Indicator6|Restricted Altitude7|Block Indicator7

Example:

EUR|M984|033|NR|STO|48.41713611|16.01859444|MIKOV|48.78474444|16.62100278||||||||||||||||||

Description:

• Area Code : geographical area
• Route Identifier : enroute route identifier
• Restriction Identifier : assign a unique identifier
• Restriction Type : define the type of the restriction (see appendix 3.27)
• Start Waypoint Identifier : start fix
• Start Waypoint Latitude : start fix latitude in degrees decimal floating point (N positive, S negative)
• Start Waypoint Longitude : start fix longitude in degrees decimal floating point (E positive, W negative)
• End Waypoint Identifier : end fix
• End Waypoint Latitude : end fix latitude in degrees decimal floating point (N positive, S negative)
• End Waypoint Longitude : end fix longitude in degrees decimal floating point (E positive, W negative)
• Start Date: specific the effective date which does not corresponding with the AIRAC date
• End Date: specific the effective date which does not corresponding with the AIRAC date
• Units of Altitude : indicate the units of measurement for the restriction altitudes (see appendix 3.28)
• Restriction Altitude1-7 : specify the altitude profile for a specific restriction
• Block Indicator1-7 : specify that the altitudes that follow in the restriction record (see appendix 3.29)

Controlled AirspaceRead the “Controlled Airspace” section

CREATE TABLE [tbl_controlled_airspace] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [airspace_center] TEXT(5),
    [controlled_airspace_name] TEXT(30),
    [airspace_type] TEXT(1),
    [airspace_classification] TEXT(1),
    [multiple_code] TEXT(1),
    [time_code] TEXT(1),
    [seqno] INT(3),
    [flightlevel] TEXT(1),
    [boundary_via] TEXT(2),
    [latitude] REAL(9),
    [longitude] REAL(10),
    [arc_origin_latitude] REAL(9),
    [arc_origin_longitude] REAL(10),
    [arc_distance] REAL(5),
    [arc_bearing]REAL(5),
    [unit_indicator_lower_limit] TEXT(1),
    [lower_limit] TEXT(5),
    [unit_indicator_upper_limit] TEXT(1),
    [upper_limit] TEXT(5)
)

Sort Order:

[rowid]

ASCII Format:

Area Code|Area Code|Airspace Center|Controlled Airspace Name|Airspace Type|Airspace Classification|Multiple Code|Time Code|Sequence Number|Flightlevel|Boundary Via|Latitude|Longitude|Arc Origin Latitude|Arc Origin Longitude|Arc Distance|Arc Bearing|Unit Indicator Lower Limit|Lower Limit|Unit Indicator Upper Limit|Upper Limit

Example:

EUR|LOWW|VIENNA CTR|M|D|10|L||48.30611111|16.60305556||||||GND|M|2500

Description:

• Area Code : geographical area
• ICAO Code : location indicator of the airspace center
• Airspace Center : define the navigation element upon which the controlled airspace being defined is predicated, but not necessarily centered
• Controlled Airspace Name : the name of the controlled airspace when assigned
• Airspace Type : indicate the type of controlled airspace (see appendix 3.23)
• Airspace Classification : indicating the published classification of the controlled airspace, when assigned
• Multiple Code : indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• Time Code : Active Time (see appendix 3.35 )
• Airspace Type : indicated restrictive Airspace Areas or MSA Centers having the same designator but subdivided or differently divided by lateral and/or vertical detail
• Sequence Number : sort order of each airspace, no duplicate sequences per airspace are possible
• Flightlevel : defines the airway structure (see appendix 3.13)
• Boundary Via : defines the path of the boundary from the position identified in the record to the next defined position (see appendix 3.25)
• Latitude : latitude in degrees decimal floating point (N positive, S negative)
• Longitude : longitude in degrees decimal floating point (E positive, W negative)
• 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)
• Arc Distance : define the distance in nautical miles from the "Arc Origin" position
• Arc Bearing : contains the true bearing from the "Arc Origin" position to the beginning of the arc
• Unit Indicator Lower Limit : specified as "above mean sea level" (MSL) or "above ground level" (AGL)
• Lower Limit : contain the lower limits
• 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

CREATE TABLE [tbl_cruising_tables] (
    [cruise_table_identifier] TEXT(2),
    [seqno] INT(3),
    [course_from] REAL(5),
    [course_to] REAL(5),
    [mag_true] TEXT(1),
    [cruise_level_from1] INT(5),
    [vertical_separation1]INT(5),
    [cruise_level_to1] INT(5),
    [cruise_level_from2] INT(5),
    [vertical_separation2] INT(5),
    [cruise_level_to2] INT(5),
    [cruise_level_from3] INT(5),
    [vertical_separation3] INT(5),
    [cruise_level_to3] INT(5),
    [cruise_level_from4] INT(5),
    [vertical_separation4] INT(5),
    [cruise_level_to4] INT(5)
)

ASCII Format:

Cruise Table Identifier|Sequence Number|Course From|Course To|Mag/True|Cruise Level From 1|Vertical Separation 1|Cruise Level To 1|Cruise Level From 2|Vertical Separation 2|Cruise Level To 2|Cruise Level From 3|Vertical Separation 3|Cruise Level To 3|Cruise Level From 4|Vertical Separation 4|Cruise Level To 4

Example:

A4|1|360.0|179.0|M|200|2000|27000|27000|4000|31000|31000|1000|32000|32000|3000|

Description:

• Cruise Table Identifier : indicate the cruising table (see appendix 3.5)
• Sequence Number : sort order of each cruise table, no duplicate sequences per cruise table are possible
• 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
• Mag/True : course from/to in magnetic or true degrees
• Cruise Level From 1-4: indicate the lowest cruising level prescribed for use within the Course From/To fields
• Vertical Separation 1-4 : indicate the minimum separation prescribed to be maintained between the cruising levels
• Cruise Level To 1-4 : indicate the highest cruising level prescribed for use within the Course From/To fields

FIR/UIRRead the “FIR/UIR” section

CREATE TABLE [tbl_fir_uir] (
    [area_code] TEXT(3),
    [fir_uir_identifier] TEXT(4),
    [fir_uir_address] TEXT(4),
    [fir_uir_name] TEXT(25),
    [fir_uir_indicator] TEXT(1),
    [seqno] INT(3),
    [boundary_via] TEXT(2),
    [adjacent_fir_identifier] TEXT(4),
    [adjacent_uir_identifier] TEXT(4),
    [reporting_units_speed] INT(1),
    [reporting_units_altitude] INT(1),
    [fir_uir_latitude] REAL(9),
    [fir_uir_longitude] REAL(10),
    [arc_origin_latitude] REAL(9),
    [arc_origin_longitude] REAL(10),
    [arc_distance] REAL(5),
    [arc_bearing] REAL(5),
    [fir_upper_limit] TEXT(5),
    [uir_lower_limit] TEXT(5),
    [uir_upper_limit] TEXT(5),
    [cruise_table_idenfier] TEXT(2)
)

Sort Order:

[rowid]

ASCII Format:

Area Code|FIR/UIR Identifier|FIR/UIR Address|FIR/UIR Name|FIR/UIR Indicator|Sequence Number|Boundary Via|Adjacent FIR Identifier|Adjacent UIR Identifier|Reporting Units Speed|Reporting Units Altitude| FIR/UIR Latitude|FIR/UIR Longitude|Arc Origin Latitude|Arc Origin Longitude|Arc Distance|Arc Bearing|FIR Upper Limit|UIR Lower Limit|UIR Upper Limit|Cruise Table Identifier

Example:

EUR|LOVV|ZRZX|VIENNA|F|10|G|LKAA||1|1|49.000000|15.00388889|||||UNLTD|||XX

Description:

• Area Code : geographical area
• FIR/UIR Identifier : identifies the Flight Information Region and Upper Information Region of airspace
• FIR/UIR Address : communication address of the FIR/UIR to supplement the FIR/UIR ident (see appendix 3.34)
• FIR/UIR Name : the name of the controlled airspace when assigned
• FIR/UIR Indicator : indicate the type of controlled airspace (see appendix 3.6)
• Sequence Number : sort order of each airspace, no duplicate sequences per airspace are possible
• Boundary Via : defines the path of the boundary from the position identified in the record to the next defined position (see appendix 3.25)
• 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
• Reporting Units Speed : indicate the units of measurement concerning True Air Speed used in the specific FIR/UIR (see appendix 3.19)
• Reporting Units Altitude : indicate the units of measurement concerning the altitude used in the specific FIR/UIR (see appendix 3.20)
• 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)
• 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)
• Arc Distance : define the distance in nautical miles from the "Arc Origin" position
• Arc Bearing : contains the true bearing from the "Arc Origin" position to the beginning of the arc
• FIR Upper Limit : contain the FIR upper limits
• UIR Lower Limit : contain the UIR lower limits
• UIR Upper Limit : contain the UIR upper limits
• Cruise Table Identifier : indicate the cruising table (see appendix 3.5)

Restrictive AirspaceRead the “Restrictive Airspace” section

CREATE TABLE [tbl_restrictive_airspace] (
    [area_code] TEXT(3),
    [icao_code] TEXT(2),
    [restrictive_airspace_designation] TEXT(10),
    [restrictive_airspace_name] TEXT(30),
    [restrictive_type] TEXT(1),
    [multiple_code] TEXT(1),
    [seqno] INT(3),
    [boundary_via] TEXT(2),
    [flightlevel] TEXT(1),
    [latitude] REAL(9),
    [longitude] REAL(10),
    [arc_origin_latitude] REAL(9),
    [arc_origin_longitude] REAL(10),
    [arc_distance] REAL(5),
    [arc_bearing] REAL(5),
    [unit_indicator_lower_limit] TEXT(1),
    [lower_limit] TEXT(5),
    [unit_indicator_upper_limit] TEXT(1),
    [upper_limit] TEXT(5)
)

Sort Order:

[rowid]

ASCII Format:

Area Code|ICAO Code|Restrictive Airspace Designation|Restrictive Airspace Name|Restrictive Type|Multiple Code|Sequence Number|Boundary Via|Flightlevel|Latitude|Longitude|Arc Origin Latitude|Arc Origin Longitude|Arc Distance|Arc Bearing|Unit Indicator Lower Limit|Lower Limit|Unit Indicator Upper Limit|Upper Limit

Example:

EUR|LO|21|LIZUM|D||10|G|L|47.225000|11.61666667||||||GND|M|21000

Description:

• Area Code : geographical area of the airspace
• ICAO Code : location indicator of the airspace
• 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 (see appendix 3.26)
• Multiple Code : indicate Restrictive Airspace having the same designator but subdivided or differently divided by lateral and/or vertical detail
• Sequence Number : sort order of each airspace, no duplicate sequences per airspace are possible
• Boundary Via : defines the path of the boundary from the position identified in the record to the next defined position (see appendix 3.25)
• Flightlevel : defines the airway structure (see appendix 3.13)
• Latitude : latitude in degrees decimal floating point (N positive, S negative)
• Longitude : longitude in degrees decimal floating point (E positive, W negative)
• 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)
• Arc Distance : define the distance in nautical miles from the "Arc Origin" position
• Arc Bearing : contains the true bearing from the "Arc Origin" position to the beginning of the arc
• FIR Upper Limit : contain the lower and upper limits of the FIR
• UIR Lower Limit : contain the lower and lower limits of the UIR
• UIR Upper Limit : contain the lower and upper limits of the UIR

GateRead the “Gate” section

CREATE TABLE [tbl_gate] (
    [area_code] TEXT(3),
    [airport_identifier] TEXT(4),
    [icao_code] TEXT(2),
    [gate_identifier] TEXT(5),
    [gate_latitude] REAL(9),
    [gate_longitude] REAL(10),
    [name] TEXT(25)
)

ASCII Format:

Area Code|Airport Identifier|ICAO Code|Gate Identifier|Gate Latitude|Gate Longitude|Gate Name

Example:

EUR|LOWW|LO|57| 48.11837222| 16.56030833|57

Description:

• Area Code : geographical area of the gate
• Airport Identifier : four character ICAO location identifier
• ICAO Code : location indicator 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)
• Name : name of the gate

GLSRead the “GLS” section

CREATE TABLE [tbl_gls] (
    [area_code] TEXT(3),
    [airport_identifier] TEXT(4),
    [icao_code] TEXT(2),
    [gls_ref_path_identifier] TEXT(4),
    [gls_category] TEXT(1),
    [gls_channel] INT(5),
    [runway_identifier] TEXT(5),
    [gls_approach_bearing] REAL(5),
    [station_latitude] REAL(9),
    [station_longitude] REAL(10),
    [gls_station_ident] TEXT(4),
    [gls_approach_slope] REAL(4),
    [magnetic_variation] REAL(6),
    [station_elevation] INT(5),
    [station_type] TEXT(3)
)

ASCII Format:

Area Code|Airport Identifier|ICAO Code|GLS Ref Path Identifier|GLS Category|GLS Channel|Runway Identifier|GLS Approach Bearing|Station Latitude|Station Longitude|GLS Station Ident|GLS Approach Slope|Magnetic Variation|Station Elevation|Station Type

Example:

EUR|EDDF|ED|G07A|1|21159|RW07L|67.0|50.02711111|8.52151667|EDDF|3.0|2.0|376|L

Description:

• Area Code : geographical area of the station
• Airport Identifier : four character ICAO location identifier
• ICAO Code : location indicator of the station
• GLS Ref Path Identifier : Identification code of the GLS Reference Path
• GLS Category : ILS/MLS/GLS performance categories (see appendix 3.17)
• GLS Channel : identifies the channel that will be decoded to identify the augmentation system used. 20001 – 39999 for GBAS, 40000 – 99999 for SBAS
• Runway Identifier : runway identifier
• GLS Approach Bearing : magnetic bearing of the GLS course
• Station Latitude : latitude in degrees decimal floating point (N positive, S negative)
• Station Longitude : longitude in degrees decimal floating point (E positive, W negative)
• GLS Station Ident : identification code for retrieval of such a transmitter (not a transmitted identifier)
• GLS Approach Slope : glide slope angle of an GLS approach in degrees
• Magnetic Variation : specifies the angular difference between true north and magnetic north at the location
• Station Elevation : elevation of GLS ground station in feet
• Station Type : identifies the type of the different ground station (see appendix 3.31)

Path PointRead the “Path Point” section

CREATE TABLE [tbl_pathpoints] (
    [area_code] TEXT(3),
    [airport_identifier] TEXT(4),
    [icao_code] TEXT(2),
    [approach_procedure_ident] TEXT(6),
    [runway_identifier] TEXT(5),
    [sbas_service_provider_identifier] INT(2),
    [reference_path_identifier] TEXT(2),
    [landing_threshold_latitude] REAL(11),
    [landing_threshold_longitude] REAL(12),
    [ltp_ellipsoid_height] REAL(6),
    [glidepath_angle] REAL(4),
    [flightpath_alignment_latitude] REAL(11),
    [flightpath_alignment_longitude] REAL(12),
    [course_width_at_threshold] REAL(5),
    [length_offset] INT(4),
    [path_point_tch] INT(6),
    [tch_units_indicator] TEXT(1),
    [hal] INT(3),
    [val] INT(3),
    [fpap_ellipsoid_height] REAL(6),
    [fpap_orthometric_height] REAL(6),
    [ltp_orthometric_height] REAL(6),
    [approach_type_identifier] TEXT(10),
    [gnss_channel_number] INT(5)
)

ASCII Format:

Area Code|Airport Identifier|ICAO Code|Approach Procedure Ident|Runway Identifier|SBAS Service Provider Identifier|Reference Path Identifier|Landing Threshold Latitude|Landing Threshold Longitude|LTP Ellipsoid Height|Glidepath Angle|Flightpath Alignment Latitude|Flightpath Alignment Longitude|Course Width At Threshold|Length Offset|Path Point TCH|TCH Units Indicator|HAL|VAL|FPAP Ellipsoid Height|FPAP Orthometric Height|LTP Orthometric Height|Approach Type Identifier|GNSS Channel Number

Example:

USA|KCDW|K6|R10|RW10|0|W10A|40.87721667|-74.28566111|19.0|0.0|40.88016667|-74.25326389|106.75|1616|0|F|40|0|19.0|51.5|51.5|LP|81922

Description:

• Area Code : geographical area of the point
• Airport Identifier : four character ICAO location identifier
• ICAO Code : location indicator of the point
• Approach Procedure Ident : Identifier of the approach route
• Runway Identifier : runway identifier
• SBAS Service Provider Identifier : associate the approach procedure to a particular satellite based approach system service provider
• Reference Path Identifier : identifier to confirm selection of the correct approach procedure
• Landing Threshold Latitude : latitude of the navigation feature identified
• Landing Threshold Longitude : longitude of the navigation feature identified
• LTP Ellipsoid Height : height of a surveyed point in reference to the WGS-84 ellipsoid
• Glidepath Angle : angle in degrees
• Flightpath Alignment Latitude : latitude of the navigation feature identified
• Flightpath Alignment Longitude : longitude of the navigation feature identified
• Course Width At Threshold : width of the lateral course at the Landing Threshold Point (LTP)
• Length Offset : distance from the stop end of the runway (SER) to the FPAP
• Path Point TCH : height above the runway threshold (LTP)
• TCH Units Indicator : define the units (meters or feet)
• HAL : Horizontal Alert Limit is the radius of a circle in the horizontal plane
• VAL : Vertical Alert Limit is half the length of a segment on the vertical axis
• 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)
• LTP Orthometric Height : height of a surveyed point in reference to Mean Sea Level (MSL)
• Approach Type Identifier : Identifies the approach types published on a given approach procedure
• GNSS Channel Number : identifies the channel

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