OnGround and FlightStatus Inaccuracies

[tardoe]

The OnGround flag appears to sometimes not be set when the FlightStatus indicates the plane is on the ground.

SELECT count(*)
FROM location_updates_high
WHERE (OnGround = 0) AND (FlightStatus = 'Normal, On the ground')

Query id: 3dd1135f-e653-4337-b90e-955e8093e734

┌─count()─┐
│ 1974772 │
└─────────┘

1 rows in set. Elapsed: 0.885 sec. Processed 137.14 million rows, 3.17 GB (154.89 million rows/s., 3.58 GB/s.)

The inverse appears to be correct (Airbourne)

SELECT count(*)
FROM location_updates_high
WHERE (OnGround = 1) AND (FlightStatus = 'Normal, Airbourne')

Query id: c035f6c8-7285-4947-b4f0-b97f7361fbee

┌─count()─┐
│       0 │
└─────────┘

1 rows in set. Elapsed: 0.774 sec. Processed 137.18 million rows, 3.17 GB (177.34 million rows/s., 4.09 GB/s.)

While there is also some correct indicators but it's far fewer.

SELECT count(*)
FROM location_updates_high
WHERE (OnGround = 1) AND (FlightStatus = 'Normal, On the ground')

Query id: ffe6d44a-14af-46bc-9c44-420afe878e39

┌─count()─┐
│  735577 │
└─────────┘

1 rows in set. Elapsed: 0.805 sec. Processed 137.20 million rows, 3.17 GB (170.41 million rows/s., 3.93 GB/s.)

Similarly there appears to be a lot of flights with an Altitude > 10,000ft with a status of "Normal, On the ground" where OnGround = 0, likely correctly which makes the status incorrect.

SELECT count(*)
FROM location_updates_high
WHERE (OnGround = 0) AND (Altitude > 10000) AND (FlightStatus = 'Normal, On the ground')
LIMIT 100

Query id: 3566519a-c6d4-43ac-bf0c-a7559f95af16

┌─count()─┐
│ 1608113 │
└─────────┘

1 rows in set. Elapsed: 1.388 sec. Processed 137.51 million rows, 3.72 GB (99.10 million rows/s., 2.68 GB/s.)