2. Home>
  3. Forum>
  4. Support>
  5. Data>
  6. SQL query to split flights into tracks?
×

Notice

The forum is in read only mode.

  1. Forum
  3. Support
  5. Data
  7. SQL query to split flights into tracks?

SQL query to split flights into tracks?

2 years 10 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
 
2 years 10 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
2 years 10 months ago #1725 by dkovar
Replied by dkovar on topic SQL query to split flights into tracks?
Greetings,

Thank you -very- much.

-David
  1. Forum
  3. Support
  5. Data
  7. SQL query to split flights into tracks?
Powered by Kunena Forum