AERO2K Flight Movement Inventory Project Report(51)

曝光台 注意防骗 网曝天猫店富美金盛家居专营店坑蒙拐骗欺诈消费者

In order to decrease database's size, all unnecessary indexes must be deleted. After being used in the precedent sub step, the csTime index belonging to the flight table must be deleted because already another index duplicates it. This index is tfTime (TrafficId + EventTime) (see Table 53). To delete csTime index the following SQL code is used:
'------------------------------------------------------------------------------
DROP INDEX csTime ON AmocFlight;
'------------------------------------------------------------------------------
Step 6 - Change airport codes to a preferred code (IATA)
In order to have a standard data for further use, no matter of the source application (AMOC, ETMS, Back Aviation, …), all data that may differ from one application to another will be converted to AERO2K data type. Two of the fields that will be changed are the departure airport and the arrival airport. Their codes will be converted to IATA code. The updating query SQL code is:
'--------------------------------------------------------------------------------
UPDATE AmocTraffic INNER JOIN IATA_ICAO_Link ON AmocTraffic.DepartureAirport = IATA_ICAO_Link.ICAO SET AmocTraffic.DepartureAirport = [IATA];
'--------------------------------------------------------------------------------
UPDATE AmocTraffic INNER JOIN IATA_ICAO_Link ON AmocTraffic.ArrivalAirport = IATA_ICAO_Link.ICAO SET AmocTraffic.ArrivalAirport = [IATA];
'--------------------------------------------------------------------------------
The IATA_ICAO_Link is a table that stores the links between different codes of the same airport (IATA, ICAO).

Step 7 - Consistency check
To complete this step, two sub steps must be done.

3.2.3.1.11. Sub step 7.1 - Delete inconsistent flight data
The inconsistent data is: flight heads without flight legs. flight legs without flight head.

 

Before deleting all inconsistent data, they are saved in the Amoc_InconsistentTraffic (flight heads) and Amoc_InconsistentFlight (flight legs).
3.2.3.1.12. Sub step 7.2 - Update flight legs that belong to the same flight and have identical EventTime
This sub step implies searching for flight legs with the same call sign and event time. After detecting all sets of similar flight legs, for each set, the first flight leg will remain unchanged and each next flight leg's event time will be incremented step by step with 1 second. This method is temporary and a better solution will be developed in further versions.
Step 8 - Change all Date/Time field values to GMT time

The AMOC application provides data with all Date/Time fields already converted to GMT time, so in this step nothing happens. It exists just for compatibility with all other AERO2K importing tools.
Step 9 -Calculate the fluid

The fluid field is a unique identifier for a flight. It is calculated from flight head's important data. Fluid = CCCCCCCAAAAYYMMDDHHNN CCCCCCC = CallSign, if CallSign length is smaller than 7, then the rest of this CCCCCCC field will be filled with '-' character AAAA = DepartureAirport, if DepartureAirport length is smaller than 4, then the rest of this AAAA field will be filled with '-' character YYMMDDHHNN = Format (DepartureTime, "yymmddhhnn"). The leading 0 for each YY, MM, DD, HH and NNfield components is important. To complete this step, the updating query SQL code shown below is executed: '--------------------------------------------------------------------------------
UPDATE AmocTraffic SET AmocTraffic.Fluid = [CallSign] & String(7-Len([CallSign]),'-') & IIf(IsNull([DepartureAirport]),'',[DepartureAirport]) & String(4-Len(IIf(IsNull([DepartureAirport]),'',[DepartureAirport])),'-') & Right(Trim(Str(Year([DepartureTime]))),2) & IIf(Month([DepartureTime])<10,'0','') & Trim(Str(Month([DepartureTime]))) & IIf(Day([DepartureTime])<10,'0','') & Trim(Str(Day([DepartureTime]))) & IIf(Hour([DepartureTime])<10,'0','') & Trim(Str(Hour([DepartureTime]))) & IIf(Minute([DepartureTime])<10,'0','') & Trim(Str(Minute([DepartureTime])))
　
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：AERO2K Flight Movement Inventory Project Report(51)