3.2.2.2.2. Merge flight legs for duplicated flights
In the merged flight table will be inserted only those flight legs that fulfill trajectory assessment merging conditions. Table 69 shows with yellow color what flight legs will be merged in the MergedTraffic table.
'------------------------------------------------------------------------------
INSERT INTO MergedFlight ( TrafficId, CallSign, EventTime, Latitude, Longitude, FlightLevel, GroundSpeed, Source, AvgSpeed, DeltaLevel )
SELECT AmocAssessmentFlightLegs.TrafficID, AmocAssessmentFlightLegs.CallSign, AmocAssessmentFlightLegs.EventTime, AmocAssessmentFlightLegs.Latitude, AmocAssessmentFlightLegs.Longitude, AmocAssessmentFlightLegs.FlightLevel, AmocAssessmentFlightLegs.GroundSpeed, AmocAssessmentFlightLegs.Source, AmocAssessmentFlightLegs.AvgSpeed, AmocAssessmentFlightLegs.DeltaLevel
FROM AMOCETMSAssessmentCombinations INNER JOIN AmocAssessmentFlightLegs ON AMOCETMSAssessmentCombinations.Fluid = AmocAssessmentFlightLegs.Fluid
WHERE (((AmocAssessmentFlightLegs.Assessment)="1") AND ((Mid([AMOCETMSAssessmentCombinations].[Action],4,1))=1)) OR (((AmocAssessmentFlightLegs.Assessment)="2") AND ((Mid([AMOCETMSAssessmentCombinations].[Action],5,1))=1)) OR (((AmocAssessmentFlightLegs.Assessment)="3") AND ((Right([AMOCETMSAssessmentCombinations].[Action],1))=1));
'------------------------------------------------------------------------------
Table 69: Assessment categories.
ETMS AMOC
1
C F C C F C
C F C C F I
C F C I F C
C F C I F I
C F C C D C
C F C C D I
C F C I D C
C F C I D I
2
C F I C F C
C F I C F I
C F I I F C
C F I I F I
C F I C D C
C F I C D I
C F I I D C
C F I I D I
3
I F C C F C
I F C C F I
I F C I F C
I F C I F I
I F C C D C
I F C C D I
I F C I D C
I F C I D I
4
I F I C F C
I F I C F I
I F I I F C
I F I I F I
I F I C D C
I F I C D I
I F I I D C
I F I I D I
5
C D C C F C
C D C C F I
C D C I F C
C D C I F I
C D C C D C
C D C C D I
C D C I D C
C D C I D I
6
C D I C F C
C D I C F I
C D I I F C
C D I I F I
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址:AERO2K Flight Movement Inventory Project Report(73)