Re: Log aircraft tracked for replay
Posted: Mon Nov 02, 2020 11:52 pm
Andy this is great. I was about to start playing but since my entire setup runs on a single Raspberry Pi, I wanted to ask you here if there is a modified instructions set that covers the install on an Rpi using VRS under Mono and what not.ProHill wrote: ↑Sat Sep 05, 2015 12:01 am A quick note on this to let anyone who is interested know that there are ways to get the full track pretty easily today. I got impatient, and worked out a way to dump the tracks to MySQL along with all the other data I was already capturing.
It leverages the AircraftList.json file with the trFmt=f parameter. This is documented here: http://www.virtualradarserver.co.uk/Doc ... tList.aspx
Basically, I grab this file every couple of minutes and parse the JSON with PHP. For my purposes, I grab the ModeS code, Callsign, the MLAT flag, and the flight track (the key is named "Cot"). All this gets stored into a temporary lookup table.
Separately, I have another process that imports flights from Basestation.sqb after they have disappeared from VRS for ~30 minutes. As part of the MySQL import process, I cross-reference the ModeS code in the lookup table above looking for entries last updated within the past hour or so, and grab the MLAT flag and the track data. This then gets saved with the other flight information from the Basestation db. There is no unique identifier to tie basestation data to the data in the AircraftList.json file, so I use the ModeS code and time box it to be fairly certain I'm matching up the right flight.
This is still experimental - we'll see how it works over time. If anyone wants to take a look: http://flights.hillhome.org/flights. Click on any flight and you should get the details page with the route and track maps.
My current setup:
Raspberry Pi 4
Flightaware PiAware 4.0
FlightAware Stick w 1/4 wave antenna
VRS3 Beta under Mono running Database Writer and Database Editor Plugins