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
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：AERO2K Flight Movement Inventory Project Report(46)
