.
Traffic unique identifier – TrafficId
This field is controlled by Access. It is an auto number.
.
Sources application (“ETMS”) – Sources
This field stores the source application name.
.
Fluid code – Fluid This field is a combination of three other fields using a predefined formula: Fluid = CCCCCCCAAAAYYMMDDHHNN, where CCCCCCC = call sign, AAAA = departure airport and YYMMDDHHNN is the departure time in <yymmddhhnn> format. If the call sign length for example is smaller than 7, then the rest of the CCCCCCC value is filled with “-”. The same procedure is used for departure airport.
2.2. ETMS flight legs text file (Flight_chord.txt)
If the text file name is Flight_20001005 then this file contains all flight legs that belong to the flight heads, which are saved in the Traffic_20001005.txt file. The file’s structure is given in Table 56.
Table 56: ETMS flight text file.
Field Name Description
1 Init_char Currently not used
2 Flight_key Combination of the ETMS-generated flight_UID and the flight_id
3 Flight_date The date that the fight operated
4 Msg_time The timestamp (curr_time, in Zulu time) for the message
5 Lat Latitude in minutes
6 Lon Longitude in minutes
7 Center The single letter code for the Center reporting the message
8 DeltaLat The difference between the latitude of this message and the latitude of the previous message
9 DeltaLon The difference between the longitude of this message and the longitude of the previous message
10 AvgAlt The average of reported altitudes between this message and the previous message
11 AltType The type of altitude
12 AvgSpeed The average of reported ground speeds between this message and the previous message (knots)
13 ActMiles Actual nautical miles traveled between the location of this message and the location of the previous message
14 SlMiles Straight line nautical miles between the location of this message and the location of the previous message
15 ReasonCode Code used for debugging
Below is a sample of the file’s content:
1 2 3 4 5 6 7 8 9 10
P,000000EGF551,2000-10-04 00:00:00,2000-10-04 02:23:00,2393,-4956,I, 3,25,79,
P,000000EGF551,2000-10-04 00:00:00,2000-10-04 02:19:00,2390,-4931,I,-1,29,100,
1112 13 14 15
C,262,19,19,5
C,340,22,22,5
Fields underlined in red are the only ones to be imported:
.
2 – Flight_key – CallSign
This field remains unchanged.
.
4 – Msg_time – EventTime
This field remains unchanged.
.
5 – Lat – Latitude
This field remains unchanged.
.
6 – Lon – Longitude
This field remains unchanged.
.
10 – AvgAlt – FlightLevel
This field remains unchanged.
.
12 – AvgSpeed – GroundSpeed
This field remains unchanged.
Beside these 6 fields, in the traffic table will be inserted another 4 fields:
.
Unique identifier – UniqueID The single use for this field is to provide consecutive numbers to two consecutive flight legs of the same flight. It is an auto number.
.
Traffic identifier – TrafficId
This field links flight legs with the flight heads from the traffic table.
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址:AERO2K Flight Movement Inventory Project Report(56)