Airport Data
Airport data files contain information that is specific to an airport and, overall, that remains static. Airport data files can be uploaded from the Organisation view, and Echo accepts SQLite files (.sqlite). Below you can find a specification of all tables that can be part of the SQLite file.
The symbol [PK] after the column name refers to a column being used as a primary key in the database. The combination of primary keys in the table needs to be unique within the table.
Table 'runways' [Optional]
This table contains the runways of the airport.
| Name | Type | Unit | Description | Possible Values |
|---|---|---|---|---|
| name [PK] | TEXT | - | Name of the runway. | - |
| airport | TEXT | - | ICAO code of the airport where the runway is located. | - |
| designation | TEXT | - | Runway designator. Corresponds to the 2-letter or 3-letter designator of the runway. | - |
| start | ARRAY | meter | Array containing the start point of the runway [X, Y]. | - |
| end | ARRAY | meter | Array containing the end point of the runway [X, Y]. | - |
| threshold | ARRAY | meter | Array containing the threshold of the runway [X, Y]. | - |
| tora | NUMERIC | meter | Takeoff run available. | - |
| runway_type | TEXT | - | Type of take-off or landing area | 'runway', 'helipad' |
| altitude | NUMERIC | meter | Altitude (elevation) of the runway. | - |
The fields start and end are used to determine the length of the runway. The fields threshold, tora, runway_type and altitude are currently
not being used in any feature, and they serve only as extra information about the runway.
Table 'airplane_model_routes' [Optional]
This table contains the airplane model routes. Note that, if you include airplane model routes, you also need to include the 'runways' table.
| Name | Type | Unit | Description | Foreign Key | Possible Values |
|---|---|---|---|---|---|
| name [PK] | TEXT | - | Name of the model route. | - | - |
| runway [PK] | TEXT | - | Name of the runway linked to the model route. | runways:name | - |
| flight_type [PK] | TEXT | - | Flight type of the route. | - | 'a', 'd' |
| point_number [PK] | INTEGER | - | - | - | - |
| x | NUMERIC | meter | X-coordinate of the point. | - | - |
| y | NUMERIC | meter | Y-coordinate of the point. | - | - |