Servelec Group - PI in the Sky
Flight Crew - Alexander Dixon, Gregor Emslie, Michael Nelson, James Todd
Good morning Ladies and Gentlemen, this is your Captain speaking. We hope you enjoy your flight with us today Our Hackathon concept was to visualise the real-time flight data of commercial aircraft and helicopters in the (almost never) sunny skies above North East Scotland.
Data is collected from two sources. Firstly for the helicopters, we have a PowerShell script that just after midnight, makes a connection to the Bristow's helicopter 'flight schedule. From there it parses the data looking for flights from our chosen Oil and Gas operator. For each flight it creates an Event Frame of the template type "flight". The flight Event Frames contain attributes to allow the flight to be tracked e.g. speed altitude, longitude, latitude etc.:
Example flight Event Frame
For commercial flights - a RaspberryPi furnished with a flight aware(http://flightaware.com/adsb/piaware/build) USB receiver was used to collect real-time flight data using the dump1090 open source system (https://github.com/antirez/dump1090 ). The data is provided in a json file which is made available to the PI Server via the web.
A second PowerShell script reads the aircraft.json file created above. Using it's known list of aircraft of interest (from the Event Frames created in the first step), the script looks in the aircraft.json file for data of interest. If data is found it is appended to the Event Frame. Once the flight is no longer seen the flight data is set to 0.
Two PI Vision extensions were created to visualise this dataset.
The EFTable extension was created to visualise, in tabular form, each flight that was currently 'active' in the sky. As above, flight data collected from the Event Frames via the PIWebAPI and written to an angular table within PI Vision, updating every 30 seconds.
PI in the Sky Data Flow
Clockwise from bottom left: Alexander, Michael, Gregor and James
The videos below provide some engrossing in-flight entertainment:
Link to our GitHub repository: https://github.com/james9005/SC1_Hackathon