SQL query to split flights into tracks?

dkovar
Topic Author
Visitor

2 years 3 months ago #1723 by dkovar

SQL query to split flights into tracks? was created by dkovar

Greetings,

I've loaded a day's worth of ADSB data into a SQL database to play with it. My current question is - how can I break a series of points for a specific aircraft up into tracks? At the moment, if I query for a given callsign or icao24 ID I get the entire day's worth of data, including time spent on the ground at an airport.

It seems like there should be a SQL query that looks at onground and the callsign to split this up but I cannot figure out what it looks like.

Thank you.

-David

Please Log in or Create an account to join the conversation.

strohmeier
Offline
Administrator

2 years 3 months ago #1724 by strohmeier

Replied by strohmeier on topic SQL query to split flights into tracks?

In the Impala database we do this for you, take a look at the flights table. The algorithm is described here: essd.copernicus.org/articles/13/357/2021/essd-13-357-2021.html

Please Log in or Create an account to join the conversation.

dkovar
Topic Author
Visitor

2 years 3 months ago #1725 by dkovar

Replied by dkovar on topic SQL query to split flights into tracks?

Greetings,

Thank you -very- much.

-David

Please Log in or Create an account to join the conversation.