13 14 15 16 17 18
360 360 360 FALSE FALSE FALSE

360 360 360 FALSE FALSE FALSE

The red colored fields are the only ones to be imported:
.  
2 – flight call sign – CallSign
This field remains unchanged.

.  
3 – event time – EventTime This field represents the legs’ time. It will be converted from its format <HH:nn:ss> (HH covers 3 days, so its value can be from 00 to 71), to standard <yyyy-mm-dd hh:nn:ss> date-time format. The conversion is explained further.

.  
9 – ground speed – GroundSpeed
This field remains unchanged.

.  
11 – latitude position – Latitude
This field remains unchanged.

.  
12 – longitude position – Longitude
This field remains unchanged.

.  
13 – flight level – FlightLevel
This field remains unchanged.

Besides these 6 fields, another 5 fields are inserted in the flight table:

.  
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.

.  
Source application (“AMOC”) – Source This field stores the source application name.

.  
Average Speed – AvgSpeed This field will contain the average speed calculated between the current flight leg and the next one.

.  
Delta level – DeltaLevel This field will contain the climb/descent rates, calculated between the current flight leg and the next one.

3
.
T
h
e
i
m
p
o
r
t
i
n
g
t
o
o
l

The importing tool is an Access implemented database. Its name is ImportAMOC.mdb. This tool’s primary goal is to import the two text files described before and save all the flights in a new format, AERO2K predefined format.

3.1. AERO2K tables format
The structure of AERO2K application tables and their indexes are shown in Table 50, Table 51, Table 52 and Table 53:
Table 50: The traffic table.

Key  Field name  Data type  Size/Format  Description 
.  TrafficId  Number  Autonumber  Unique identifier for the flight 
CallSign  Text  15  Flight’s call sign
 DepartureTime  Date/Time  yyyy-mm-dd hh:nn:ss  Flight's date
 DepartureAirport  Text  5  Departure airport
 ArrivalAirport  Text  5  Arrival airport
 AircraftType  Text  10  Aircraft type 
Sources  Text  20  The name of the sources this record was imported from ('AMOC', 'ETMS', ‘AEM3’,’BACK’, ‘OAG’...) 
Fluid  Text  21  Flight unique identifier
 MaxStopTime  Date/Time  yyyy-mm-dd hh:nn:ss  Last possible arrival time 

Table 51: Traffic table indexes.

No.  NAME  FIELDS  PROPERTIES 
1  PrimaryKey  TrafficId  Ascending 
2  call_sign  CallSign  Ascending 
3  departure_time  DepartureTime  Ascending 
4  departure_airport  DepartureAirport  Ascending 
5  arrival_airport  ArrivalAirport  Ascending 
6  Fluid  Fluid  Ascending 
7  MaxStopTime  MaxStopTime  Ascending 
　
中國航空網 m.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(46)