AERO2K Flight Movement Inventory Project Report(16)

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

Field name  Data type  Field size (access)  Field size (bytes) 
IATA_code  text  3 
City name  text  100 
Airport Name  text  100 
State/Pro  text  10 
Country Code  text  10 
Country Name  text  100 
City_Code  text  10 
DataSource  text  255 

 

Table 9: "IATA_Lat_Lon_Elev_GMT" table structure. Figure 5: Linking of "IATA_Name" and "IATA_Lat_Lon_Elev_GMT" tables.

Field name  Data type  Field size (access)  Field size (bytes) 
IATA_code  text  3 
Lat  number  double  8 
Lon  number  double  8 
ElevationFT  text  20 
GMT_offset  text  20 
DataSource  text  255 
Table 10: "ICAO_Name" table structure.

Field name  Data type  Field size (access)  Field size (bytes) 
ICAO_code  text  4 
City  text  100 
Airport Name  text  100 
State  text  100 
Country Name  text  100 
Country Code  text  20 
DataSource  text  255 
Table 11: "ICAO_Lat_Lon_Elev" table structure.

Field name  Data type  Field size (access)  Field size (bytes) 
ICAO_code  text  4 
Lat  number  double  8 
Lon  number  double  8 
ElevationFT  number  double  8 
Bearing  number  double  8 
TAR  number  double  8 
DataSource  text  255 
Table 12: "IATA_ICAO_Link" table structure.

Field name  Data type  Field size (access)  Field size (bytes) 
IATA  text  3 
ICAO  text  4 

Table 13: "Iso country code" table structure.

Field name  Data type  Field size (access)  Field size (bytes) 
Iso country code  text  10 
Country name  text  100 
WorldRegion  text  100 
EU (15 states)  yes/no  1  1 
NATO (17 states)  yes/no  1  1 
EUROCONTROL (30 states)  yes/no  1  1 
ECAC (38 states)  yes/no  1  1 

Figure 6: Linking of "ICAO_Name" and "ICAO_Lat_Lon_Elev" tables.

Figure 7: Linking of ICAO/IATA tables.

 

 

7
.
A
i
r
l
i
n
e
t
a
b
l
e
s
t
r
u
c
t
u
r
e
a
n
d
r
e
l
a
t
i
o
n
s
h
i
p
s

An airline conversion table was developed in Access in order to match airline codes from the scheduled flights database with other source of information. The structure of the table created is shown in Table 14.
Table 14: Structure of the airline_codes table.

FIELD  DESCRIPTION 
name  Airline company name 
cod2  Two-letter code 
cod3  Three-letter code 
country  Name of the country 

 

 

8
.
G
I
S
r
e
p
r
e
s
e
n
t
a
t
i
o
n

Flight trajectory data either in AMOC or ETMS are provided as latitude and longitude values. In order to visualize these values, a GIS application was developed in VBA (Visual Basic for applications) using ARCView 8.2. This application can directly read data from an Access database. It converts the flight legs latitude and longitude into trajectories. This application was used for:
　
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：AERO2K Flight Movement Inventory Project Report(16)