Hi,
I'm currently playing with Kibana and FlightRadar, to display all of our "active" flights using the latest version of the stack.
To construct this map, I've been using the following datasets:
- a list of all continents ( https://datahub.io/core/continent-codes )
- a list of all countries ( https://ourairports.com/data/ )
- a list of all regions ( https://ourairports.com/data/ )
- a list of all international airports / medium airports / small airports / heliports ( https://ourairports.com/data/)
- an internal dataset of all of our past/current/future "active" flights
- flightradar APIs to retrieve actual flight data ( https://www.flightradar24.com/ )
The map shown above shows the following:
- a geo-line between the departure and the arrival airport
- a clickable bubble on the arrival airport showing relevant informations on the airports
- all airports, depending on zoom level
- the dots of the actual positions at which the plane's ADS-B transmitters pingged
- the latest known position of various planes, oriented using the heading value
- the estimated path between the latest known position of the plane and its arrival airport
All the relevant data for my questions are stored in an index consisting of mostly the following data:
- actual status date time
- geopoint of the ping
- aircraft identification data
- aircraft origin airport stored as a geopoint
- aircraft destination airport stored as a geopoint
=> for a single flight, I have as many documents as there are pings
So after this long introduction ( ) here's my questions:
- is there a good way to interpolate a line from many geopoints stored within multiple documents in maps ?
- using KQL is there a way to retrieve the document with the highest timestamp while still matching other criteria ? This would be helpful to draw the line between the latest known aircraft position and its destination...so far I'm doing some weird stuff at ingest time.
Best regards,
Charles.w