曝光臺 注意防騙 網曝天貓店富美金盛家居專營店坑蒙拐騙欺詐消費者

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.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：AERO2K Flight Movement Inventory Project Report(65)