INSERT INTO Traffic ( Fluid, Sources, CallSign, DepartureTime, DepartureAirport, ArrivalAirport, AircraftType, ArrivalTime )
SELECT MergedTraffic.Fluid, MergedTraffic.Sources, MergedTraffic.CallSign, MergedTraffic.DepartureTime, MergedTraffic.DepartureAirport, MergedTraffic.ArrivalAirport, MergedTraffic.AircraftType, MergedTraffic.ArrivalTime
FROM MergedTraffic LEFT JOIN AmocETMSDuplicateFlights ON MergedTraffic.Fluid = AmocETMSDuplicateFlights.Fluid
WHERE (((AmocETMSDuplicateFlights.Fluid) Is Null));
'--------------------------------------------------------------------------------
3.3.2. Copy duplicated traffic
All duplicated flights (traffic table) are selected and copied into the database, according to the merging method described at the beginning of this paragraph.
'--------------------------------------------------------------------------------
INSERT INTO Traffic ( Fluid, Sources, CallSign, DepartureTime, DepartureAirport, ArrivalAirport, AircraftType, ArrivalTime )
SELECT MergedTraffic.Fluid, 'AMOC/ETMS' AS Sources, MergedTraffic.CallSign, Format(IIf([MergedTraffic].[DepartureTime]<MergedTraffic_1.DepartureTime,[MergedTraffi c].[DepartureTime],MergedTraffic_1.DepartureTime),'yyyy-mm-dd hh:nn:ss') AS DepartureTime, MergedTraffic.DepartureAirport, MergedTraffic.ArrivalAirport, MergedTraffic.AircraftType, Format(IIf([MergedTraffic].[ArrivalTime]<MergedTraffic_1.ArrivalTime,[MergedTraffic].[Arri valTime],MergedTraffic_1.ArrivalTime),'yyyy-mm-dd hh:nn:ss') AS ArrivalTime
FROM MergedTraffic INNER JOIN MergedTraffic AS MergedTraffic_1 ON MergedTraffic.Fluid = MergedTraffic_1.Fluid
WHERE (((MergedTraffic.Sources)='AMOC') AND ((MergedTraffic_1.Sources)='ETMS'));
'--------------------------------------------------------------------------------
3.3.3. Copy flight legs
'--------------------------------------------------------------------------------
INSERT INTO Flight ( TrafficId, CallSign, EventTime, Latitude, Longitude, FlightLevel,
GroundSpeed, Source )
SELECT Traffic.TrafficID, MergedFlight.CallSign,MergedFlight.Latitude, MergedFlight.Longitude,MergedFlight.GroundSpeed, MergedFlight.Source MergedFlight.EventTime, MergedFlight.FlightLevel,
FROM (MergedTraffic INNER JOIN MergedFlight ON (MergedTraffic.Sources =
MergedFlight.Source) AND (MergedTraffic.TrafficID = MergedFlight.TrafficId)) INNER JOIN Traffic ON MergedTraffic.Fluid = Traffic.Fluid
ORDER BY Traffic.TrafficID, MergedFlight.EventTime;
'--------------------------------------------------------------------------------
4
.
T
h
e
M
e
r
g
i
n
g
t
o
o
l
u
s
e
r
i
n
t
e
r
f
a
c
e
4.1. The Merging tool menus
The Merging tool menus are shown in Figure 77.
Figure 77: Merging tool menus.
4.2. The Merging tool interface
The Merge flights menu command will open the merging interface. This interface allows users to merge flights automatically or manually. For each type of merge, there is an importing interface. These interfaces are shown in Figure 78 and Figure 79.
Figure 78: Automatic merge.
As illustrated by Figure 78 and Figure 79, each step presented before is reflected in the interfaces. When the automatically merge is selected, all steps are executed one by one without being possible to stop the process. If selecting the manual merging, it is possible to execute all the steps or just some of them. Of course some steps must be executed after other merging steps were executed.
中國航空網 www.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(75)
