acid |
varchar |
Aircraft ID |
aircraft_type |
varchar |
Physical aircraft type |
airport |
varchar |
Airport name associated with this message update in IATA format |
altitude |
double precision |
Altitude in decimal format |
asdex_id |
bigint |
Unique record ID for each PositionMessage from PositionMessageList messages |
beacon_code |
integer |
The beacon code for the flight |
gufi |
varchar |
Unique Identifier for this flight operation |
heading |
double precision |
Calculated heading in degrees |
latitude |
double precision |
Latitude in decimal format |
longitude |
double precision |
Longitude in decimal format |
mosde_s_address |
varchar |
ModeS address |
on_ground |
boolean |
Indication whether a flight is on ground |
speed |
integer |
Calculated speed in knots |
time |
timestamp |
timestamp when Aerobahn received the position report |
time_processed |
timestamp |
timestamp when the message is processed in AsdexImport |
track_number |
integer |
Tracking Number of the flight |
velocity_x |
double precision |
Velocity in x direction |
velocity_y |
double precision |
Velocity in y direction |