DELETE ETMSFlight.* FROM ETMSFlight LEFT JOIN ETMSTraffic ON [ETMSFlight].[TrafficId]=[ETMSTraffic].[TrafficId] WHERE ((([ETMSTraffic].[TrafficId]) Is Null));
'------------------------------------------------------------------------------

3.3.3.11.13.  Sub step 11.13 - Merge flight legs for duplicated flights

After all these steps it is still possible that some flights be duplicated i.e. a flight could be split in two or more fragments. A method was developed to avoid this problem. This method purpose is to identify flights with:
e.
CallSign1 = CallSign2

f.
DepartureAirport1 = DepartureAirport2

g.
DepartureTime1 – DepartureTime2 < 800 minutes

h.
AverageSpeed(FirstFlightLeg1, FirstFlightLeg2) >= 110

i.
AverageSpeed(LastFlightLeg1, FirstFlightLeg2) >= 110

j. FirstFlightLegEventTime1 < FirstFlightLegEventTime2 If two flights are found duplicated, then the second flight's flight legs will be merged with the first and the record from the traffic table that corresponds to the second flight will be removed.

3.4. The Import ETMS tool interface
3.4.1. The Import ETMS tool menus
The Import ETMS tool menus are shown in Figure 65.

3.4.2. The Import ETMS tool interface
The Import ETMS files menu command will open the importing interface. This interface allows users to import ETMS generated text files automatically or manually. For each importing type there is an importing interface.
Figure 66 and Figure 67 show these interfaces.

Figure 66: Automatic import interface.

As it might be seen in these two pictures, each step presented before is reflected in the interfaces. When the automatically importing is selected, all steps are executed one by one without being possible to stop the process. Selecting the manual importing, it is possible to execute all the steps or just some of them. Of course some steps must be executed after other important steps were executed before. For example if the step 9 is executed before step 7 or 8, the calculated fluids might not be correct.

3.4.3. Import ETMS tool utilities
The tool provides also some utilities. These utilities can be accessed directly from the menu (Figure 65) or through another interface that is shown below in Figure 68. Figure 69 to Figure 76 illustrate the utilities included in the tool.

Figure 68: Import ETMS tool utilities.

Figure 71: List of inconsistent flight heads.

Figure 73: First point coordinates.

Figure 76: Flight legs at midnight.

A
E
R
O
2
K
M
e
r
g
i
n
g
t
o
o
l
(
A
c
c
e
s
s
p
r
o
t
o
t
y
p
e
)

By Nicu Stancioi April 2002

1
.
I
n
t
r
o
d
u
c
t
i
o
n

Merging tool's purpose is to collect flight information from different sources, after these flights have initially been imported and converted into AERO2K standard format. The importing and converting procedures are included in other tools, like Import AMOC tool or Import ETMS tool.

2
.
D
a
t
a
b
a
s
e
s
t
r
u
c
t
u
r
e

Merged data collected from the importing tools are saved into several tables. There are four important tables:
-MergedTraffic.
-MergedFlight.
　
中國航空網 m.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(66)