Airport Index
Snowflake table name : CYBERSYN.AIRPORT_INDEX
Name | Description | Type | Example |
---|---|---|---|
| ID for the origin airport that is part of the flight route being measured, combination of the DOT unique code and official 3 letter OAG code issued for that airport. | VARCHAR |
|
| Unique identifier assigned by the US DOT to each airport, used for administrative and reporting purposes. | NUMBER |
|
| Name of the airport. | VARCHAR |
|
| Code assigned to airports by the International Air Transport Association (IATA), which are widely used in the aviation industry for ticketing, baggage handling, and flight planning. | VARCHAR |
|
| US DOT identifier for the geographical area where the airport is based. | NUMBER |
|
| Full location name of the airport. | VARCHAR |
|
| Name of the city where the airport is located. | VARCHAR |
|
| A unique identifier for a state, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable. | VARCHAR |
|
| A unique identifier for a country, joinable to the GEOGRAPHY_INDEX table, representing the primary geography for the variable. | VARCHAR |
|
Last updated