AirNav Systems Forum

AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: Horsham Spotter on November 14, 2009, 10:22:58 AM

Title: EGKK Log or Report
Post by: Horsham Spotter on November 14, 2009, 10:22:58 AM

Is it possible to create a log for a single airfields movements.
For example in MyLog or Reporter, or do I have to use a outside program.
I am 8 miles from EGKK and would like to record my own records of that airport.
Any help would be great Steve.

Title: Re: EGKK Log or Report
Post by: tarbat on November 14, 2009, 03:26:45 PM

I can't think of any simple way of doing this within Radarbox.

You should be able to write an SQL query that looks for EGKK at the start or end of the flight route in the MyLog database.

SELECT DISTINCT
  Flights.Route,
  Flights.Callsign,
  Flights.EndTime,
  Flights.ModeS,
  Flights.MsgCount,
  Flights.Registration,
  Flights.Session,
  Flights.StartTime,
  Flights.StartPosition,
  Flights.EndPosition,
  Flights.StartAltitude,
  Flights.EndAltitude,
  Flights.StartGS,
  Flights.EndGS
FROM
 Flights
WHERE
  (Flights.Route LIKE "%EGKK%")

Title: Re: EGKK Log or Report
Post by: Horsham Spotter on November 14, 2009, 09:04:46 PM

Thank you Tarbat. I will try this but does seem a lot of work.
Will let you know the outcome? Cheers Steve.

Title: Re: EGKK Log or Report
Post by: abrad41 on November 15, 2009, 09:46:11 AM

Chris

Is there anyway of searching for a certain date within the Sql query above.

Cheers

Andy

Title: Re: EGKK Log or Report
Post by: abrad41 on November 16, 2009, 05:00:33 PM

Chris

Did you miss this one mate, it was well down the list.

Andy

Title: Re: EGKK Log or Report
Post by: tarbat on November 16, 2009, 05:07:34 PM

Quote from: abrad41 on November 16, 2009, 05:00:33 PM

Chris

Did you miss this one mate, it was well down the list.

Andy

Yes, I did miss it!!!  I only get to look at the forum between visiting hours, and then I'm only on my netbook.  You should be able to use a select statement on the Flights.EndTime.  So, for today's flights:

WHERE
  (Flights.Route LIKE "%EGKK%") AND
  (Flights.EndTime LIKE "2009/11/16%")

Title: Re: EGKK Log or Report
Post by: abrad41 on November 16, 2009, 06:09:44 PM

Chris

Thanks mate, sorry to trouble you, I do know you are very busy at moment.

Andy