Table 1: File differences encountered between AMOC and ETMS. 23 Table 2: The output structure of the traffic and flight tables. 25 Table 3: Date-leg filtering procedure. 26 Table 4: Constraints linked to selected fields. 33 Table 5: World regions code system used in Back Aviation database. 34 Table 6: Equipment type code system used in Back Aviation database. 34 Table 7: Fields extracted from Back Aviation database and displayed. 35 Table 8: "IATA_Name" table structure. 41 Table 9: "IATA_Lat_Lon_Elev_GMT" table structure. 42 Table 10: "ICAO_Name" table structure. 42 Table 11: "ICAO_Lat_Lon_Elev" table structure. 42 Table 12: "IATA_ICAO_Link" table structure. 42 Table 13: "Iso country code" table structure. 43 Table 14: Structure of the airline_codes table. 45 Table 15: Trajectory assessment code system. 50 Table 16: Example of the summary trajectory table. 51 Table 17: Matching possibilities between two trajectories. 52 Table 18: Table FLIGHT_TEMP. 61 Table 19: Table FLIGHT_LEG_TEMP. 61 Table 20: Table TIME_ZONE_DATA. 65 Table 21: Table IATA_ICAO_AIRPORT_INFO. 67 Table 22: Table ETMS_AIRPORTS. 67 Table 23: Table IATA_ICAO_AIRLINES. 69 Table 24: Table AIRCRAFT_EQUIVALENT. 71 Table 25: Explanation of codes. 71 Table 26: Table INCONSISTENT_FLIGHT. 73 Table 27: Table INCONSISTENT_FLIGHT_LEG. 74 Table 28: Code system attributed to the zone indicator combinations. 79 Table 29: Table MERGE_FLIGHT_INFO_TEMP. 79 Table 30: Table FLIGHT. 82 Table 31: Table FLIGHT_LEG. 82 Table 32: Table IMPORT_LOG. 84 Table 33: Table MERGE_LOG. 84 Table 34: Options according to the time calculated. 90 Table 35: Table AIRCRAFT_MAX_FL_GS_2. 92 Table 36: Table AIRCRAFT_DEP_PROFILE. 93 Table 37: Table AIRCRAFT_ARR_PROFILE. 96 Table 38: Table CITY_PAIR. 99 Table 39: Table CITY_PAIR_WP. 99 Table 40: Yearly traffic averages for the ECAC area from 1997 to 2001 (Source:
CFMU, 2002). 106 Table 41: Monthly traffic in 2000 and 2001 for the ECAC area (Source: CFMU,
2002). 107 Table 42: Number of flights traveling between the US and the World in 1999 and
2000 expressed in percent of the annual traffic (Source: US Department of
Transportation, 2001). 111 Table 43: Timetable for collecting data. 111 Table 44: Constraints linked to selected fields. 116 Table 45: Sample of a file extracted from Back Aviation database showing the fields
displayed for 2002. 117 Table 46: Listing of the representative days in 2002 and classified in seasons. 118 Table 47: Dependencies, relationships, limitations and assumptions made for each
modeling steps (referring to Figure 12). 147 Table 48: AMOC traffic text file. 161 Table 49: AMOC flight text file. 163 Table 50: The traffic table. 165 Table 51: Traffic table indexes. 166 Table 52: The flight table. 166 Table 53: Flight table indexes. 166 Table 54: Linked AmocTraffic and AmocFlight tables. 172 Table 55: ETMS traffic text file. 188 Table 56: ETMS flight text file. 190 Table 57: The traffic table. 193 Table 58: Traffic table indexes. 193 Table 59: The flight table. 193 Table 60: Flight table indexes. 194 Table 61: Linked ETMSTraffic and ETMSFlight tables. 199 Table 62: MergedTraffic table. 217 Table 63: MergedTraffic indexes. 217 Table 64: MergedFlight table. 218 Table 65: FlightTable indexes 218 Table 66: Trajectory assessment code system. 219 Table 67: TrajectoryAssessment table. 219 Table 68: TrajectoryAssessment indexes. 219 Table 69: Assessment categories. 227 Table 70: List of countries members of the ECAC zone in 2002. 243 Table 71: Classification of countries per region according to ICAO and Back Aviation
database. 244 Table 72: Grouping of aircrafts. 249
L
i
s
t
o
f
A
c
r
o
n
y
m
s
ADEP Airport of departure ADES Airport of destination AERO2K Global aircraft emissions data project for climate impacts evaluation AM-Airbus Aerospatiale Matra Airbus and British Aerospace Systems AMOC ATFM Modelling Capability ANCAT Group of experts on the Abatement of Nuisances Caused by Air Transport ANCAT/EC2 Inventory data sets released by the ANCAT/EC group in August 1997 and 中國航空網 www.k6050.com 航空翻譯 www.aviation.cn 本文鏈接地址：AERO2K Flight Movement Inventory Project Report(6)
