EGKK Log or Report

[Horsham Spotter]

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.

[tarbat]

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%")

[Horsham Spotter]

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

[abrad41]

Chris

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

Cheers

Andy

[abrad41]

Chris

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

Andy

[tarbat]

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%")

[abrad41]

Chris

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

Andy