anything
AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Only logs with call signs in MyLog.db3?  (Read 4235 times)

0 Members and 1 Guest are viewing this topic.

Harry

  • Jr. Member
  • **
  • Posts: 98
Only logs with call signs in MyLog.db3?
« on: July 22, 2008, 05:35:56 AM »
Hi All,

Last month I did run Radarbox for two weeks in France. First I noticed that only hex codes with ads-b are send via port 7879. The second thing I noticed is that only hex codes with call signs are stored in the MyLog.db3. Is this correct or was it pure coincidence that I didn’t log any hex codes without call signs?

Harry

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Only logs with call signs in MyLog.db3?
« Reply #1 on: July 22, 2008, 08:36:18 AM »
Aircraft without callsigns should appear in MyLog.db3, but only in the "Aircraft" table, not in the "Flights" table.  In the "Aircraft" table, you'll see the first and last date/time that you've detected that aircraft.

Without a callsign, RB can't identify each individual flight of that aircraft.

Allocator

  • RadarBox24.com Beta Testers
  • Hero Member
  • *
  • Posts: 3568
Re: Only logs with call signs in MyLog.db3?
« Reply #2 on: July 22, 2008, 08:37:10 AM »
Harry,

All "live" aircraft received using your antenna will show up in MyLog, even if they don't have a callsign.  They will also show even if they were not giving full ADS-B (position) information.

I'd be very suprised if you didn't get some aircraft without callsigns over a 2 week period.

If there is no callsign, you won't get any details in the lower window of MyLog, but all the aircraft will be there in the list in the top window.

Harry

  • Jr. Member
  • **
  • Posts: 98
Re: Only logs with call signs in MyLog.db3?
« Reply #3 on: July 22, 2008, 08:54:51 AM »
Hi Tarbat, Allocator,

Thanks for your replies. I wrote a program that creates logs files over a certain period. The program did  only check the Flights table. I will take a look at the Aircraft table too. So all the logs will end up in the Aircraft table and those with a callsign will also be written to the Flight table.

Again thanks.

Harry

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Only logs with call signs in MyLog.db3?
« Reply #4 on: July 22, 2008, 09:25:30 AM »
Harry, you can join the Aircraft and Flights tables with SQL:

SELECT
  Aircraft.Comment,
  Aircraft.LastTime,
  Aircraft.FirstTime,
  Aircraft.AircraftTypeLong,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline,
  Aircraft.ModeS,
  Aircraft.ModeSCountry,
  Aircraft.Registration,
  Flights.Route,
  Flights.Callsign,
  Flights.EndTime,
  Flights.ModeS,
  Flights.MsgCount,
  Flights.Registration,
  Flights.Session,
  Flights.StartTime
FROM
 Aircraft
 LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)

Harry

  • Jr. Member
  • **
  • Posts: 98
Re: Only logs with call signs in MyLog.db3?
« Reply #5 on: July 22, 2008, 09:47:06 AM »
Hi Tarbat,

Thanks for your query. I will test this at home.

As far as I can see now I only have to use the Aircraft.Lasttime, the Aircraft.Modes and  Flights.Callsign to get my output right. (Hex, Date, Time, Callsign)

Harry

Harry, you can join the Aircraft and Flights tables with SQL:

SELECT
  Aircraft.Comment,
  Aircraft.LastTime,
  Aircraft.FirstTime,
  Aircraft.AircraftTypeLong,
  Aircraft.AircraftTypeSmall,
  Aircraft.Airline,
  Aircraft.ModeS,
  Aircraft.ModeSCountry,
  Aircraft.Registration,
  Flights.Route,
  Flights.Callsign,
  Flights.EndTime,
  Flights.ModeS,
  Flights.MsgCount,
  Flights.Registration,
  Flights.Session,
  Flights.StartTime
FROM
 Aircraft
 LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS)

Harry

  • Jr. Member
  • **
  • Posts: 98
Re: Only logs with call signs in MyLog.db3?
« Reply #6 on: July 23, 2008, 10:51:28 AM »
Hi Tarbat, Allocator,

Again thanks for your replies. The program now also show the hex codes without a call sign.


Harry