曝光臺 注意防騙 網曝天貓店富美金盛家居專營店坑蒙拐騙欺詐消費者

22  Act_dep_time  The estimated time of departure for the actual departure airport 
23  Act_arr_center  Single code character for the Air Traffic Control of the actual arrival airport 
24  Act_arr_time  The estimated time of arrival for the actual arrival airport 
Aircraft_type  The aircraft type 
26  Number_of_aircraft  The number of aircraft in formation 
27  Max_plan_alt  The maximum planed altitude 
28  Cancel_reason  The reason of the flight canceling 
29  Physical_class  The physical class of the aircraft 
User_class  The type of flight 
31  Weight_class  The weight class of the aircraft 
32  Purge_flag  Used for debugging 
33  Tail_number  Registration number from ASQP database 
34  Engine_model  From back aviation database 
Orig_lat  Origin airport latitude 
36  Orig_lon  Origin airport longitude 
37  Dest_lat  Destination airport latitude 
38  Dest_lon  Destination airport longitude 

Below is a sample of the file’s content:
1 2 3  45 6 7

F,000142ABX148,2000-10-04 00:00:00,142,ABX148,2000-10-03 18:30:00,1008,

F,000089NWA600,2000-10-04 00:00:00,89, NWA600,2000-10-04 00:29:00,1008,

8  9 10 11 1213 14

2000-10-04 10:33:00,1005,32,ILN,MKE,2000-10-04 09:41:00,2000-10-04 10:34:00,

2000-10-04 02:51:00,1005,21,MSP,SUX,2000-10-04 02:05:00,2000-10-04 02:52:00,

15  16 17 18 19

2000-10-04 10:00:00,2000-10-04 10:56:00,I, 2000-10-04 09:41:00,G,

xxx,  xxx, P, 2000-10-04 02:04:00,P,

20  21 22 23 24 25

2000-10-04 10:39:00,I, 2000-10-04 09:41:00,xxx,2000-10-04 10:34:00,DC9Q,

2000-10-04 02:48:00,xxx,2000-10-04 02:05:00,xxx,2000-10-04 02:52:00,DC9Q,

26 27 28 29 30 31 32 33 34 35 36 37 38

xxx,310,xxx,J, F, L, 1, xxx, xxx, xxx,xxx,xxx,xxx
xxx,280,xxx,J, C, L, 1, N8938E,JT8D-7B,xxx,xxx,xxx,xxx

Fields underlined in red are the only ones to be imported:
.  
2 – Flight key – CallSign This field represents a combination of the ETMS-generated flight_UID and the flight_id and it is considered to be a unique key. Nevertheless this key is not unique when the period of time covered by the exported traffic text file is large.

.  
6 – First_msg_time – FirstMessageTime This field represents the timestamp of the flight's first message and it is used to change the departure time (DepartureTime), if the scheduled departure time is wrong (NULL or inconsistent date).

.  
8 – Last_msg_time – LastMessageTime This field represents the timestamp of the flight's last message and it is used to change the arrival time (MaxStopTime), if the scheduled arrival time is inconsistent (NULL or inconsistent date).

.  
11 – Schd_dep_airport – DepartureAirport
This field remains unchanged.

.  
12 – Schd_arr_airport – ArrivalAirport
This field remains unchanged.

.  
13 – Schd_dep_time – DepartureTime The scheduled departure time should be the actual departure time. If the data stored in this field is inconsistent, the FirstMessageTime will replace it.

.  
14 – Schd_arr_time – MaxStopTime The scheduled arrival time should be the actual arrival time. If the data stored in this field is inconsistent, the LastMessageTime will replace it.

.  
25 – Aircraft type – AircraftType
This field remains unchanged.

 

 

After importing this text file and checking the consistency of the DepartureTime and
MaxStopTime fields, the FirstMessageTime and LastMessageTime will not be needed any
　
中國航空網 www.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(55)