Radarspotting

Mode-S Software => Virtual Radar Server => Topic started by: SoCal Mac on May 12, 2026, 02:24:31 AM

Title: BaseStation.sqb file question
Post by: SoCal Mac on May 12, 2026, 02:24:31 AM
Running VRS with database writer & editor plugins. I use Mode S Tweaker to view the basestation file.
Is there anyway to print the data I see in the format Mose S Tweaker shows. I can also use the report function in VRS to modify the basestation file but no print feature.

I would like to call up P-8A data and print it out. Not sure if possible to do printouts on sqb type files.

Thanks,

Mac
Title: Re: BaseStation.sqb file question
Post by: Anmer on May 12, 2026, 07:20:56 AM
Quote from: SoCal Mac on May 12, 2026, 02:24:31 AMIs there anyway to print the data I see in the format Mose S Tweaker shows. I can also use the report function in VRS to modify the basestation file but no print feature.

I don't think you can achive this using BaseStation Reporter or Mode S Tweaker.

But you could use an SQL database editor such as SQLite Expert Personal (free to use) to run an SQL query on the ICAOTypeCode.  Then copy the results and paste into Excel or another application.

I just tested this using this Query (on a small test SQB file):

SELECT*
FROM Aircraft
WHERE ICAOTypeCode = 'P38'

Then right mouse clicked in the Results window and chose "Copy Records".  Then pasted in a blank Excel workbook.
Title: Re: BaseStation.sqb file question
Post by: SoCal Mac on May 12, 2026, 10:45:44 PM
Many thanks. I'll give that a try.

Mac
Title: Re: BaseStation.sqb file question
Post by: SoCal Mac on May 13, 2026, 07:06:56 AM
Gave it a try and got what I was looking for.   :)

Thanks Mike.
Title: Re: BaseStation.sqb file question
Post by: Anmer on May 13, 2026, 07:24:38 AM
Great.  Some powerful tools in the SQLite Expert Personal edition when using SQL queries.
Title: Re: BaseStation.sqb file question
Post by: SoCal Mac on May 15, 2026, 06:29:04 AM
First time using it. Your instructions let me get the info I was looking for. Will see what else I might use it for. I was looking for a P-8A data list since I get so many flights. So far I have 229 different hex codes for United States P-8A's. Around 100 must be tactical hex codes.

Next will be the KC-135's want to see how many I've seen so far.

Many thank again.

Mac,