As much for a bit of a challenge as for a bit of fun, I thought I’d have a go at updating the database in dump1090-fa with the data from my installation of VRS using the tools provided in the master zip file I’d downloaded from GitHub.
I now realise that I reinvented the wheel rather as I later discovered that this has been done before by various people who have documented their progress on this site but here goes:
The other thing is that because I’ve been running VRS continuously since 2015 the basestation database is 25GB in size and I wasn’t sure whether the Pi would be up to dealing with that volume of data.
So I decided to do as much of the processing as possible on one of my PCs by installing whatever software was required. Just to make things more complicated, I don’t currently have any PCs running LINUX so I had to use Windows instead.
I tried using the vrs-to-csv python script to start with but had issues with it because the column names in the my VRS database are different to the ones in the original (no longer updated) basic aircraft lookup database the script was written for. I tried modifying it to suit but couldn’t get it to output in the correct format so I created a modified version of the SQLite3 script I use to do the conversion from VRS to adsbSCOPE instead.
This gave me a CSV file containing a little under half a million records.
Next came the csv-to-json python script. I was actually surprised at how quickly this ran on my Pi 3B+. All that was left to do was to make a backup of the original db folder and drop the newly created one in its place.
There was initially a bit of slowness loading the maps but after a couple of minutes, the Pi seemed to be back to normal and the difference was immediately obvious.