Improved Routing Information

[DaveReid]

If your promoting your site again to help, then can you please confirm that you will let us hook into it for free as you do for other software?

This is nothing to do with the existing FRL database, other than the fact that it runs on the same server.  Come to that, it's nothing to do with you either.

The data on submitted routes and half routes belongs to the users who contribute it.  You will have to ask them if you want to use it.

[AirNav Support]

DaveReid,

Considering you have tried to sell your services (Aircraft, Routes) to us at vastly high price and used the forum to try and leverage us on more than once occasion. We would have to question your motive here.

We would just like to make our customers aware what and whom they are dealing with.

[tarbat]

Not sure what you mean about only simple for completed routes - for a half route just leave the origin or destination blank, as appropriate.

Is there a process that then runs to match entries with the same FlightID and blank origin or destination?

[bratters]

Right Dave - 2 points - is it case sensitive and what is the date format? Looks dead simple for confirmed completed routes as opposed to half routes.

No, it's not case-sensitive (anything you enter in lower case is automatically uppercased before saving).

Date format is DD/MM/YYYY.

Not sure what you mean about only simple for completed routes - for a half route just leave the origin or destination blank, as appropriate.

Good stuff Dave - speaking as the ultimate test pilot for anything to do with Computing, I'll give it a whirl.

I'm now going off on a little detour for a while. I want to see how far I can get in cracking as many of the EGNX routes as possible by using RB in combination with the online EMA Arrivals/Departures board (as outlined above somewhere)

This might prove a decent alternative strategy that anyone can employ at an airport that offers accurate on line info.

Certainly worth a go and hopefully not too difficult.

[DaveReid]

Is there a process that then runs to match entries with the same FlightID and blank origin or destination?

There will be - at least when my phone stops ringing !

[DaveReid]

Considering you have tried to sell your services (Aircraft, Routes) to us at vastly high price and used the forum to try and leverage us on more than once occasion. We would have to question your motive here.

We would just like to make our customers aware what and whom they are dealing with.

Read my lips:  it isn't my data

Just what part of that don't you understand ?

[abrad41]

DaveReid,

If your promoting your site again to help, then can you please confirm that you will let us hook into it for free as you do for other software?

If not please make that obvious to everyone. The last think we want is RadarBox users involved in something that they think will help there system when actually it won't at all.

Speachless & Amazed

Come to that, it's nothing to do with you either.

You tell them Dave - I for one will thank you for all the help you are giving to the user's of this forum

[bratters]

can I suggest holding fire on the project till the end of the month when the timetable change is complete

Hi flybhx - I think the accent is very much on "project" at the moment! but lots of interesting ideas and avenues opening up. Good thinking though on your part. If we ever get off the ground it will be more likely Spring Schedules to worry about.

[Chris11]

There is little point to this project if the data does not find its way into the AirNav database or into a csv file that can easily be imported into the local database ala tarbat import

[DaveReid]

There is little point to this project if the data does not find its way into the AirNav database or into a csv file that can easily be imported into the local database ala tarbat import

Rest assured that both CSV import/output and SQL bulk load statements will be supported, so as a last resort everyone will be able to use the data to update their local NavData database and thereby see the routes on their RadarBox screens.

I agree that it would be much better to get AirNav to use the data to update the server, but you'll have to ask them about that. 

I'm certainly not about to engage in discussion with an organisation that thinks posts like #286 above are acceptable.

[tarbat]

In parallel running of Radarbox and FD7.5 today, out of 354 FlightIDs, FD7.5 returned 84 different or additional routes:

   FN   FD7.NO   FD7.ND   FD7.CH      anrb.NO   anrb.ND   anrb.CH
   AA41   LFPG   KORD      20101001000000         
  AAL51   EGKK   KDFW      20100930000000   EGLL   KDFW   20100929000000
AAL9420   KLAX   EGLL      20101001000000         
AEU781P   EGKK   CYHZ      20100930000000         
 AIC127   EDDF   KORD      20100930000000   VOHS   EDDF   20100903083411
 AIC191   EDDF   KEWR      20100930000000   VAAH   KEWR   20100924000000
 AWE707   EDDM   KPHL      20100930000000   KPHL   KDCA   20100905121632
BCY505D   EGPH   LFPG      20101001000000         
 BEE643   EGTE   EGNM      20100930000000   EGNM   EGPD   20100928100000
  CFEMT   CYYR   BIKF      20100930000000         
  CGRFO   CYYR   CYUL      20100930000000   CYYR   BIKF   20100929000000
CJT1891   CYYT   EDLP      20101001000000   CYHM   MUHA   20101001172514
  COA17   EGPF   KEWR      20100930000000   EGPF   KLAX   20100905081531
  COA37   EGPH   KEWR      20100930000000   EGPH   KMCO   20100924000000
 DAL143   EDDF   KDTW      20100930000000   EDDF   KMSP   20100929000000
 DAL243   VABB   EHAM      20101001000000   VABB   KDTW   20100929000000
  DAL79   EDDT   KJFK      20100930000000   KJFK   KLAX   20100904110749
DAL8955   KPWM   BIKF      20101001000000   KEWR   KDFW   20101001100943
EXS6383   ENVA   EIDW      20101001000000         
EZE1041   EGPD   EDDH      20100930000000   EIDL   EGPD   20100929000000
EZE1803   EGPD   EGPB      20101001000000         
 EZE26Z   EGPD   EGNX      20100930000000         
EZY14PW   EGPD   EGGW      20100930000000         
 EZY238   EGPH   EGSS      20101001000000   EGSS   EGPH   20100929000000
EZY688Y   EGPF   LFPG      20100930000000         
EZY905G   EGPH   LSGG      20100930000000         
EZY94EG   EGPH   LEMD      20100930000000   EGPH   EGSS   20100831093407
FDX9006   KBGR   LFPG      20100930000000   KMEM   KHRL   20100930155823
GEC8240   EDDF   KDFW      20100930000000   KORD   MMMX   20100905152201
 GMA651   EGLF   LFPB      20100930000000         
 GMA665   KBGR   KBCT      20101001000000         
 ICE436   BIKF   EGCC      20101001000000   BIKF   BIKF   20100924000000
 IRL251   EIME   EINN      20100930000000         
  KAI80   KSDM   EGPE      20101001000000   KOAK   KEGE   20101001174736
 KLM663   EHAM   KIAH      20100930000000   KIAH   EHAM   20100904125343
MON7648   EGPH   GCRR      20100930000000   EGPD   LEPA   20100909145709
 N118EA   CYYR   BGBW      20101001000000         
 N427SA   EGPH   KPTK      20101001000000         
 N436QS   CYYT   LIBR      20100930000000         
 N450EE   KACK   KBED      20101001000000         
 N454QS   KTEB   EGPH      20101001000000         
 N53235   CYYR   BGBW      20101001000000         
 N604FJ   KBGR   EBAW      20100930000000         
 N817ME   CYYR   LFPB      20101001000000         
 N8220M   CYYR   BGBW      20100930000000         
  N874C   CYYR   EGGW      20101001000000         
 NAO990   PHNL   PGUA      20100930000000   KDFW   KJFK   20100930112802
NCR0601   CYQX   EETN      20101001000000   TJBQ   GVAC   20101001081416
 NJE5HW   EGSH   LFPB      20100930000000         
 NJE5LE   LFSB   EGLF      20101001000000         
 NJE7QC   EHAM   EGPH      20101001000000         
 RYN530   KBGR   EDDP      20101001000000         
 RYN532   EDDP   KLSF      20100930000000   KAEX   EDDP   20100930075633
RYN7120   KSVN   EDDP      20100930000000   KVCV   KRFD   20100930155750
RYR29YV   EGPK   EPWR      20101001000000         
 RYR2RC   EPGD   EIDW      20100930000000         
 RYR5WA   EGPH   LEPA      20101001000000         
RYR61KF   EIDW   EGPD      20100930000000         
RYR69RF   EVRA   EIDW      20100930000000         
 RYR6DC   EGPH   LFBD      20101001000000         
 TCX24K   EGCC   CYVR      20101001000000   CYYC   EGKK   20100910143616
 TCX31K   EGCC   MUHG      20101001000000   EGCC   CYYC   20100903114337
 TCX84K   EGKK   CYVR      20101001000000   EGKK   EGKK   20100924000000
 TCX86K   EGCC   TBPB      20100930000000   EGKK   CYVR   20100909102411
   THT7   LFPG   KLAX      20100930000000   LFPG   NTAA   20100924000000
 TSC409   LFPG   CYYC      20101001000000   LFPG   CYVR   20100924000000
 UAL901   EDDF   KSFO      20101001000000   EDDF   KSAN   20100923000000
 UAL909   EHAM   KORD      20101001000000   EHAM   KDEN   20100903102656
 UAL917   EDDF   KIAD      20100930000000   EDDF   KSEA   20100905120042
 UAL926   KSFO   EDDF      20100930000000   KLAX   EDDF   20100924000000
 UAL927   EDDF   KSFO      20101001000000   EDDF   KLAX   20100831165621
 UAL929   EGLL   KORD      20100930000000   EBBR   KORD   20100909072628
 UAL931   EGLL   KSFO      20100930000000   EGLL   KLAX   20100929000000
 UAL933   EDDF   KIAD      20100930000000   EDDF   KDEN   20100905162804
 UAL935   EGLL   KLAX      20100930000000   EGLL   PHNL   20100929000000
 UAL939   EGLL   KDEN      20100930000000   EGLL   KSAN   20100929000000
 UAL941   EDDF   KORD      20100930000000   EDDF   KDEN   20100929000000
 UAL943   LFPG   KORD      20100930000000   LFPG   KLAX   20100929000000
 UAL945   EDDF   KORD      20100930000000   EDDF   KLAX   20100905074528
 UAL947   EHAM   KIAD      20100930000000   EHAM   KLAX   20100831111554
 UAL953   EDDF   KIAD      20100930000000   EDDF   KPHX   20100905103943
 UAL955   EGLL   KSFO      20100930000000   EGLL   KSAN   20100929000000
WIF0393   EGPD   ENBR      20100930000000         
  WWI14   KTEB   EGGW      20100930000000   KSAT   KTCS   20100930071104

Using route lookup sites in the following order:
1. FRL Service
2. FlyteCom
3. FlightAware
4. FlightStats
5. Libhomeradar

[DaveReid]

What does the FD7.CH column indicate ?

[tarbat]

What does the FD7.CH column indicate ?

Its the "Posted" date from the FD7 routes table.  And you've also spotted my deliberate error!!!  I picked up FD7 routes from yesterday as well.

After a few days of using FD7, I've decided that it gives me most of what I need for routes.  Attached are today's new/corrected routes.

[bratters]

In parallel running of Radarbox and FD7.5 today, out of 354 FlightIDs, FD7.5 returned 84 different or additional routes:

That's 24% which is high but as we mentioned before it's difficult to draw any conclusions without thorough checking.

On which point the very limited time I spent this afternoon working on EGNX flights was sufficient to convince me that I can crack the majority of lo-cost flights, esp. Ryanair & BMI in and out of EMA.

It's a bit laborious and time consuming but a bit of experience on my part will speed things up. Anyone who can monitor a local airport that offers an accurate flight info service can make a big impact on these missing routes.

An encouraging day one way and another.

[Chris11]

I'm certainly not about to engage in discussion with an organisation that thinks posts like #286 above are acceptable.

Dave - while you have a lot to add - if I was AirNav I would have banned you for the constant sniping which adds little to to this forum. You must accept that this forum is owned by AirNav - please respect that.

I am an "outsider" but I even feel dubious when you start offering services.

This is an AirNav forum and so all suggestions must be for the benefit of Radarbox users in general or else they do not belong here.