AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: lennox2604 on March 06, 2008, 09:16:09 PM

Title: RadarBox 2008 Log File
Post by: lennox2604 on March 06, 2008, 09:16:09 PM

Just downloaded 2008

And it is GOOD

My onl very very small moan is that the Flight number is not includedin daily log .


Does anybody know a SQL set of commands to extract the information from the SQL database as I now very little of programming

Thanks AIRNAV

Any chance of a HFDL programme after Ship tracker

Jim C

Title: Re: RadarBox 2008 Log File
Post by: tarbat on March 06, 2008, 09:23:17 PM

Quote from: lennox2604 on March 06, 2008, 09:16:09 PM

My onl very very small moan is that the Flight number is not includedin daily log .

SELECT
  Flights.ModeS,
  Flights.Registration,
  Flights.Callsign,
  Flights.Route,
  Flights.StartTime,
  Flights.EndTime,
  Flights.Session,
  Flights.MsgCount
FROM
 Flights
ORDER BY
  Flights.Registration

SQL generated using SQLite Maestro (http://www.sqlmaestro.com/products/sqlite/maestro/)

And this retrieves almost everything from MyLog.db3:

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

Title: Re: RadarBox 2008 Log File
Post by: lennox2604 on March 06, 2008, 10:06:32 PM

Tarbat

 Many thanks for that script

I know we have just started but how do you specify a date to isolate any day

Jim C

Title: Re: RadarBox 2008 Log File
Post by: tarbat on March 06, 2008, 10:11:12 PM

Quote from: lennox2604 on March 06, 2008, 10:06:32 PM

I know we have just started but how do you specify a date to isolate any day

WHERE
  (Flights.StartTime >= "2008/03/06 00:00:00") AND
  (Flights.EndTime < "2008/03/07 00:00:00")

will give you all flights on 6th March 2008.

BTW, I know almost nothing about SQL, but using SQLite Maestro lets you create SQL using the visual query builder.

Title: Re: RadarBox 2008 Log File
Post by: lennox2604 on March 06, 2008, 10:39:41 PM

Tarbat

Many thanks for that

Jim C