AERO2K Flight Movement Inventory Project Report(57)

.  
Source application (“ETMS”) – 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 ImportETMS.mdb. This tool’s primary goal is to import the two text files described before and save all the flights into a new format, AERO2K predefined format.

3.1. AERO2K tables format
The structure of AERO2K application tables and indexes are shown in Table 57, Table 58, Table 59 and Table 60.
Table 57: 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 ('ETMS', ’BACK’, ...) 
Fluid  Text  21  Flight unique identifier
 MaxStopTime  Date/Time  yyyy-mm-dd hh:nn:ss  Last possible arrival time 

Table 58: 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 
Table 59: The flight table.

Key  Field name  Data type  Size/Format  Description 
.  UniqueID  Number  Autonumber  Unique identifier 
TrafficId  Number  Long  This field links the flight table with the traffic table 
CallSign  Text  15  Flight’s call sign 
EventTime  Date/Time  yyyy-mm-dd hh:nn:ss  Flight’s event time 
Latitude  Number  Single  Latitude position (degrees)
 Longitude  Number  Single  Longitude position (degrees) 
GroundSpeed  Number  Long  Ground speed (knots)
 FlightLevel  Number  Long  Flight level 
Source  Text  5  The name of the source application this record was imported from ('ETMS', 'BACK',...) 
AvgSpeed  Number  Single  The average speed between two consecutive points
 DeltaLevel  Number  Single  Climb/descent rate 

Table 60: Flight table indexes.

No.  NAME  FIELDS  PROPERTIES 
1  PrimaryKey  UniqueID  Ascending 
2  traffic_id  TrafficId  Ascending 
3  tfTime  TrafficId  Ascending 
EventTime  Ascending 

3.2.

3.3. The importing procedure