7
.
T
h
e
p
r
o
c
e
d
u
r
e
f
o
r
m
e
r
g
i
n
g
t
r
a
j
e
c
t
o
r
i
e
s
7.1. Merge of AMOC and ETMS data
The purpose of the merge is to select the right flight data information coming from different sources and contained into the temporary Flight and Flight_Legs tables (Table 18 and Table 19). The merge process is first applied to AMOC and ETMS data. It consists of retrieving the data such as a flight appears only once in the final inventory. Two groups of processes are carried out on these data before the real merge. They are a consistency check and an assessment.
Consistency check
. Move of inconsistent marked flights
All flights marked as inconsistent during the import are moved to an inconsistency table (Table 26 and Table 27). Each time an exception was raised and caught, an appropriate reason message was mentioned to keep track of the errors.
Table 26: Table INCONSISTENT_FLIGHT.
Col # Column Name Data Type Data Description
1 OID NUMBER(15) Object Identifier
2 CALLSIGN VARCHAR2(15) Flight’s callsign
3 DEP_TIME DATE Time and date of departure
4 DEP_AIRPORT VARCHAR2(5) Airport of departure
5 ARR_AIRPORT VARCHAR2(5) Airport of arrival
6 SOURCES VARCHAR2(20) The name of the sources this record was imported from (AMOC, ETMS, Back Aviation)
7 FLUID VARCHAR2(21) Flight unique identifier
8 AIRCRAFT_TYPE VARCHAR2(15) Aircraft type
9 ARR_TIME DATE Time and date of arrival
10 REASON VARCHAR2(50) All kind of reasons such as unrecognized airline code or airport code or aircraft type…
11 ASSESSMENT NUMBER Number (0 to 7) attributed to the trajectory for assessing the quality
12 IMPORT_LOG_OID NUMBER Object Identifier for the import_log table (foreign key)
Table 27: Table INCONSISTENT_FLIGHT_LEG.
Col # Column Name Data Type Data Description
1 OID NUMBER(15) Object Identifier for the flight
2 FLIGHT_OID NUMBER(15)
3 CALLSIGN VARCHAR2(15) Flight’s callsign
4 EVENT_TIME DATE Time and date of the event
5 LATITUDE NUMBER(17,7) Latitude of the event in decimal degree
6 LONGITUDE NUMBER(17,7) Longitude of the event in decimal degree
7 GROUND_SPEED NUMBER(17,7) Ground speed in knots
8 FLIGHT_LEVEL NUMBER(14) Flight level in hundred of feet
9 SOURCE VARCHAR2(5) The name of the sources this record was imported from (AMOC, ETMS, Back Aviation)
10 AVG_SPEED NUMBER(17,7) Average speed between two chords in nm/hour
11 DELTA_LEVEL NUMBER(17,7) Variation of flight level between two chords in feet/min
12 REASON VARCHAR2(50) List of reasons such as ”missing flight header”
13 ZONE_INDICATOR VARCHAR2(1) Identify in which zone of the trajectory, the event is: “D” for departure “E” for en route “A” for arrival
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：AERO2K Flight Movement Inventory Project Report(24)
