曝光台 注意防骗
网曝天猫店富美金盛家居专营店坑蒙拐骗欺诈消费者
INSERT INTO ETMS_InconsistentTraffic (TrafficId, CallSign, DepartureTime, DepartureAirport, ArrivalAirport, AircraftType, Sources, Fluid, MaxStopTime, Cause) SELECT DISTINCT ETMSTraffic.TrafficId, ETMSTraffic.CallSign, ETMSTraffic.DepartureTime, ETMSTraffic.DepartureAirport, ETMSTraffic.ArrivalAirport, ETMSTraffic.AircraftType, ETMSTraffic.Sources, ETMSTraffic.Fluid, ETMSTraffic.MaxStopTime, 'average speed too big' AS Cause FROM ETMSTraffic INNER JOIN ETMSFlight ON ETMSTraffic.TrafficId = ETMSFlight.TrafficId WHERE (((ETMSFlight.AvgSpeed)>=3000));
'------------------------------------------------------------------------------
3.3.3.11.8. Sub step 11.8 - Delete dubious flights that have flight legs with average speed to high The dubious flight detected in the previous sub step will be deleted:
'------------------------------------------------------------------------------
DELETE ETMSTraffic.* FROM ETMSTraffic INNER JOIN ETMS_InconsistentTraffic ON [ETMSTraffic].[TrafficId]=[ETMS_InconsistentTraffic].[TrafficId];
'------------------------------------------------------------------------------
3.3.3.11.9. Sub step 11.9 - Save flights with few flight legs A flight, which has fewer than 5 flight legs, is considered to be futile, because it doesn't contain complete useful information. Initially these flights will be saved into the "inconsistent table". In the next sub step they will be deleted.
'------------------------------------------------------------------------------
INSERT INTO ETMS_InconsistentTraffic (TrafficId, CallSign, DepartureTime, DepartureAirport, ArrivalAirport, AircraftType, Sources, Fluid, MaxStopTime, Cause) SELECT ETMSTraffic.TrafficId, ETMSTraffic.CallSign, ETMSTraffic.DepartureTime, ETMSTraffic.DepartureAirport, ETMSTraffic.ArrivalAirport, ETMSTraffic.AircraftType, ETMSTraffic.Sources, ETMSTraffic.Fluid, ETMSTraffic.MaxStopTime, 'few flight legs' AS Cause FROM ETMSTraffic INNER JOIN ETMSFlight ON ETMSTraffic.TrafficId = ETMSFlight.TrafficId GROUP BY ETMSTraffic.TrafficId, ETMSTraffic.CallSign, ETMSTraffic.DepartureTime, ETMSTraffic.DepartureAirport, ETMSTraffic.ArrivalAirport, ETMSTraffic.AircraftType, ETMSTraffic.Sources, ETMSTraffic.Fluid, ETMSTraffic.MaxStopTime, 'few flight legs' HAVING (((Count(ETMSFlight.TrafficId))<=4));
'------------------------------------------------------------------------------
3.3.3.11.10. Sub step 11.10 - Delete flights with few flight legs
As explained in the previous sub step, the flights with fewer than 5 flight legs will be
'------------------------------------------------------------------------------
deleted: '------------------------------------------------------------------------------
DELETE ETMSTraffic.* FROM ETMSTraffic INNER ETMS_InconsistentTraffic [ETMSTraffic].[TrafficId]=[ETMS_InconsistentTraffic].[TrafficId]; JOIN ON
3.3.3.11.11. Sub step 11.11 - Save flight legs for all the flights deleted in precedent sub steps
In precedent sub steps, only the information about flight's head was deleted. In this sub step their flight legs will be saved in the "inconsistent table":
'------------------------------------------------------------------------------
INSERT INTO ETMS_InconsistentFlight (TrafficId, CallSign, EventTime, Latitude, Longitude, FlightLevel, GroundSpeed, Source, AvgSpeed, DeltaLevel) SELECT ETMSFlight.TrafficId, ETMSFlight.CallSign, ETMSFlight.EventTime, ETMSFlight.Latitude, ETMSFlight.Longitude, ETMSFlight.FlightLevel, ETMSFlight.GroundSpeed, ETMSFlight.Source, ETMSFlight.AvgSpeed, ETMSFlight.DeltaLevel FROM ETMSFlight LEFT JOIN ETMSTraffic ON ETMSFlight.TrafficId = ETMSTraffic.TrafficId WHERE (((ETMSTraffic.TrafficId) Is Null));
'------------------------------------------------------------------------------
3.3.3.11.12. Sub step 11.12 - Delete flight legs for all the flights deleted in precedent sub steps
The saved flight legs from the precedent sub step will be now deleted:
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：AERO2K Flight Movement Inventory Project Report(65)
