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
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 (decimal degrees)
Longitude Number Single Longitude position (decimal degrees)
GroundSpeed Number Long Ground speed (knots)
FlightLevel Number Long Flight level (hundred of feet)
Source Text 5 The name of the source application this record was imported from ('ETMS', ‘AMOC’...)
AvgSpeed Number Single Calculated average speed between two consecutive points
DeltaLevel Number Single Climb/descent rate
Flight table indexes
No. NAME FIELDS PROPERTIES
1 PrimaryKey UniqueID Ascending
2 traffic_id TrafficId Ascending
3 tfTime TrafficId Ascending
1 Cf Phase 1 / Paragraphs 2 and 3 and appendix.
EventTime Ascending
1.2. Date-leg filtering
Files collected listed data for a longer period than the one considered for the study i.e. an AMOC file dated 6/6/02 contained flights for the 5/6/02 and the 7/6/02. It was necessary to filter the data in order to keep only flight data for the day or period selected. It also meant that legs of flights starting/ending before/after midnight of the period considered should be deleted. It was then necessary to interpolate the flight position at midnight. For this reason, a filter was developed based on the date and the leg of the flights. The procedure for filtering is described in Table 3.
Table 3: Date-leg filtering procedure.
Traffic table Flight table Procedure
Callsign Callsign -
Departure and arrival on selected day D Take all flight legs (complete trajectory) -
Departure on D-1 and arrival on D Get last position before midnight on day D-1 and all position on day D. Calculation of the aircraft location at midnight based on Great Circle geometry interpolation.
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址:AERO2K Flight Movement Inventory Project Report(10)