PATTERN 3: HHNN DDD-WWW-MMM (eg. "0200 1ST-SUN-MAR") DDD can be: 1ST 2ND 3RD LST WWW can be: SUN MON TUE WED THU FRI SAT MMM can be: JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC If the pattern length is 16 then | PatternDay = CPatternDay(DDD, WWW, MMM, PatternYear) | PatternDate = Format(PatternDay-MMM-PatternYear HH:NN:00, "dd-mm-yyyy
hh:nn:ss") | CPatternDate = PatternDate []
End Function
Public Function GetUTCTime(LocalTime As Date, StdBias As Long, DstBias As Long,
DstStartPattern As String, DstEndPattern As String) As Date If Daylight Saving Time exist (DstBias <> "") then | If DstStartPattern <= LocalTime <= DstEndPattern then | | UTCTime = LocalTime - DstBias | Else | | UTCTime = LocalTime - StdBias | [] Else | UTCTime = LocalTime - StdBias [] GetUTCTime = UTCTime
End Function
Public Function GetGlobalTime(UTCTime As Date, StdBias As Long, DstBias As Long, DstStartPattern As String, DstEndPattern As String) As Date
GlobalTime = UTCTime + StdBias
If Daylight Saving Time exist (DstBias <> "") then
| If DstStartPattern <= GlobalTime <= DstEndPattern then
| | GlobalTime = UTCTime + DstBias
| []
[]
GetGlobalTime = GlobalTime End Function
6
.
A
i
r
p
o
r
t
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
As explained in Phase 1 Paragraph 1.3, a list of airports needed to be compiled in order to identify the location of the airport (latitude, longitude and elevation) and to match the three and four code systems used to name an airport. The airport data consists of a set of six tables and three queries:
.
"IATA_Name" table.
.
"IATA_Lat_Lon_Elev_GMT" table.
.
"ICAO_Name" table.
.
"ICAO_Lat_Lon_Elev" table.
.
"IATA_ICAO_Link" table.
.
"Iso country code" table.
.
"IATA" query.
.
"ICAO" query.
.
"Link" query.
The structure of the tables is described in Table 8 to Table 13. The information source comes from the database published by IATA as a location identifiers diskette (ASCII format). It was completed with ICAO codes derived from different web sites. The latitude, longitude and elevation information comes from EEC software such as AMOC, INM and COSAAC and was verified with ESRI Mapping data and/or on the world-wide-web. GMT offset comes from a file provided by Back Aviation Ltd in order to convert local time to GMT time. Countries were classified into regions according to the regions listed in the ICAO DGCA Directory (Directorate General of Civil Aviation).
“IATA_ICAO_Link" table provides the link between IATA code and ICAO code when this link is available as not all airports have a IATA code and a ICAO code. Links between tables are illustrated in Figure 5, Figure 6 and Figure 7.
The three queries created provided all information available either with IATA code or ICAO code or the complete information on an airport when the ICAO/IATA link is known. When ICAO and IATA fields contain the same information (i.e. latitude, longitude and elevation), the ICAO value is displayed.
Table 8: "IATA_Name" table structure.
中国航空网 www.aero.cn
航空翻译 www.aviation.cn
本文链接地址：AERO2K Flight Movement Inventory Project Report(15)
