3000 for Holland (sorry John :-)
I feel so inadequate.
This has been explained dozens of times now. Please read our message earlier in this thread regarding it.OK Support, thank you and verry sorry for the inconvenience,
Aircrafttype is in the Aircraft table, so just do a " LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)" to join the tables, and you can then pull data from the Aircraft table as well.
SELECT
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,
Aircraft.Comment,
Aircraft.LastTime,
Aircraft.FirstTime,
Aircraft.AircraftTypeLong,
Aircraft.AircraftTypeSmall,
Aircraft.Airline,
Aircraft.ModeS,
Aircraft.ModeSCountry,
Aircraft.Registration,
Aircraft.ADSB
FROM
Flights
LEFT OUTER JOIN Aircraft ON (Flights.ModeS=Aircraft.ModeS)
Can you post the SQL you're using.
I am using SQLiteMaestro version 8.11.0.1
Congratulations John, you are now the top lister in the Netherlands,
and maybe even Europe :-)
Hi Glyn,
Your officially an A-Lister now.
You passed the 2500 mark by 16.
I bow my hat to you :-)
Your the Man.
Have to agree with you on the Midnight UTC thing,
very annoying, roll on version 2.1
Hi All,
Yesterday (Thuesday, June 2nd) - 24 hours = 4107 aircraft-movings logged.
If you are interested in the list, please let me know and I will sent it to you.
That's a hell of a total...
By way of comparison what would be your total be for individual/unique aircraft in a day then John?
Also is there an easy way for me to tell how many aircraft movements I have seen in a 24 hour period without resorting to any 3rd party tools to do the job?
If Tarbat or an other SQL-specialist is listening to this I would ask to them or there is a SQL-syntax for making such a report as you mean. Also to remove all doubles of registrations and Mode-S codes in one report.
By way of comparison what would be your total be for individual/unique aircraft in a day then John?
Hi Glyn,
1. I am not sure about that but, ofcourse in my case, much lower.
With all the respect of the developers, today I do still absolute not understand what the reports from RB's MyLog "Today" us tell.
Now I see that my exemple of June 2nd falls from 1137 yesterday to 911 this morning...
It may take a while before I reach my own goal of 2000, I might have to get the Watson up another 10feet :-)
It may take a while before I reach my own goal of 2000, I might have to get the Watson up another 10feet :-)
Another Watson user...I have mine mounted on the top of a 17 foot pole at the top of the gable end of the house which is already @ 460 feet asl
Even at that great location and height my own polar diagram shows my coverage to the South-West to be limited compared to the rest of the coverage.
Not sure why - there must be aircraft down there in Devon & Cornwall ;^)
Kind regards,
-=Glyn=-
I was wondering whether
I have a question about the SQL-syntax below: how get I aircraft NOT with ADSB equipped in this generated report?
Love the setup Glyn (drools all over table)
My long term goal is to have a similar setup to that !
Is that a HF antenna in the middle ?
With that kind of cash on a pole, I'd make sure it's all properly earthed,
unless you live beside a church :-) with there fancy lightning conductors :-)
hi GlynH, what type of external antenna are you using for radarbox? is that an GP1090? how does it compare to the DPD?
also whats the difference in range between the standard supplied aerial compared to your setup?
thanks