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

Login with username, password and session length
 


Author Topic: EGKK Log or Report  (Read 3520 times)

0 Members and 1 Guest are viewing this topic.

Horsham Spotter

  • Full Member
  • ***
  • Posts: 184
EGKK Log or Report
« 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.
3.1nm miles south of EGKK westerly App & Dep.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: EGKK Log or Report
« Reply #1 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%")
« Last Edit: November 14, 2009, 03:39:46 PM by tarbat »

Horsham Spotter

  • Full Member
  • ***
  • Posts: 184
Re: EGKK Log or Report
« Reply #2 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.
3.1nm miles south of EGKK westerly App & Dep.

abrad41

  • Guest
Re: EGKK Log or Report
« Reply #3 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

abrad41

  • Guest
Re: EGKK Log or Report
« Reply #4 on: November 16, 2009, 05:00:33 PM »
Chris

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

Andy

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: EGKK Log or Report
« Reply #5 on: November 16, 2009, 05:07:34 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%")

abrad41

  • Guest
Re: EGKK Log or Report
« Reply #6 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