AirNav Systems Forum
AirNav RadarBox and RadarBox24.com => AirNav RadarBox and RadarBox24.com Discussion => Topic started by: DaveReid on August 31, 2010, 09:40:58 AM
-
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>BAW43AM</FlightNumber>
<Callsign>Speedbird 43AM</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EHAM</ICAOCode>
<IATACode>AMS</IATACode>
<AirportName>AMSTERDAM</AirportName>
<Country>NETHERLANDS</Country>
</Origin>
- <Destination>
<ICAOCode>EGLL</ICAOCode>
<IATACode>LHR</IATACode>
<AirportName>LONDON/HEATHROW</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>200</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Thanks. Might be helpful to post this data in a form that can be readily imported into the routes table, using, for example, the sqlite command line interface:
sqlite3 data/navdata.db3
.separator ","
.import routes.csv routes
.exit
So, in your example, you would import a routes.csv file containing:
BAW43AM,EHAM,EGLL,,20100831095842
-
Thanks. Might be helpful to post this data in a form that can be readily imported into the routes table, using, for example, the sqlite command line interface:
sqlite3 data/navdata.db3
.separator ","
.import routes.csv routes
.exit
So, in your example, you would import a routes.csv file containing:
BAW43AM,EHAM,EGLL,,20100831095842
Actually, AirNav did specifically request updates in XML format. See http://www.airnavsystems.com/forum/index.php?topic=5333.msg53548#msg53548
But as you rightly say, if individual users want to update their own routes tables while waiting for the server to be updated, then they simply need to extract the <FlightNumber> value and then the <ICAOCode> values (or <IATACode>, if preferred) from successive <Leg> nodes.
Realistically, I can't see myself having the time to contribute updates in sufficient quantity to make a bulk CSV import format worthwhile.
-
Just landed LHR, no route shown:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>AFR228D</FlightNumber>
<Callsign>Airfrans 228D</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LFPG</ICAOCode>
<IATACode>CDG</IATACode>
<AirportName>PARIS/CHARLES DE GAULLE</AirportName>
<Country>FRANCE</Country>
</Origin>
- <Destination>
<ICAOCode>EGLL</ICAOCode>
<IATACode>LHR</IATACode>
<AirportName>LONDON/HEATHROW</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>187</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Just landed LHR, no route shown:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>DLH3HR</FlightNumber>
<Callsign>Lufthansa 3HR</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EDDL</ICAOCode>
<IATACode>DUS</IATACode>
<AirportName>DUSSELDORF</AirportName>
<Country>GERMANY</Country>
</Origin>
- <Destination>
<ICAOCode>EGLL</ICAOCode>
<IATACode>LHR</IATACode>
<AirportName>LONDON/HEATHROW</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>270</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Server is currently returning LEPA-UMBB:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>BIE6657</FlightNumber>
<Callsign>Mediterranee 6657</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LFQQ</ICAOCode>
<IATACode>LIL</IATACode>
<AirportName>LILLE (LESQUIN)</AirportName>
<Country>FRANCE</Country>
</Origin>
- <Destination>
<ICAOCode>LEPA</ICAOCode>
<IATACode>PMI</IATACode>
<AirportName>PALMA DE MALLORCA</AirportName>
<Country>SPAIN</Country>
</Destination>
<GCDistanceNM>661</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Dublin to Edinburgh, according to the server !
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>RYR8812</FlightNumber>
<Callsign>Ryanair 8812</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EPKK</ICAOCode>
<IATACode>KRK</IATACode>
<AirportName>KRAKOW</AirportName>
<Country>POLAND</Country>
</Origin>
- <Destination>
<ICAOCode>LMML</ICAOCode>
<IATACode>MLA</IATACode>
<AirportName>MALTA (LUQA)</AirportName>
<Country>MALTA</Country>
</Destination>
<GCDistanceNM>885</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Server is returning Belfast/Aldergrove-Luton:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>EZY162</FlightNumber>
<Callsign>Easy 162</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LFPG</ICAOCode>
<IATACode>CDG</IATACode>
<AirportName>PARIS/CHARLES DE GAULLE</AirportName>
<Country>FRANCE</Country>
</Origin>
- <Destination>
<ICAOCode>LIMC</ICAOCode>
<IATACode>MXP</IATACode>
<AirportName>MILAN (MALPENSA)</AirportName>
<Country>ITALY</Country>
</Destination>
<GCDistanceNM>322</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Server only returns 3rd leg:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>NCA166</FlightNumber>
<Callsign>Nippon Cargo 166</Callsign>
- <Leg>
- <Origin>
<ICAOCode>RJAA</ICAOCode>
<IATACode>NRT</IATACode>
<AirportName>TOKYO (NARITA)</AirportName>
<Country>JAPAN</Country>
</Origin>
- <Destination>
<ICAOCode>PANC</ICAOCode>
<IATACode>ANC</IATACode>
<AirportName>ANCHORAGE (INTERNATIONAL/KULIS ANGB)</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>2976</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>PANC</ICAOCode>
<IATACode>ANC</IATACode>
<AirportName>ANCHORAGE (INTERNATIONAL/KULIS ANGB)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>KORD</ICAOCode>
<IATACode>ORD</IATACode>
<AirportName>CHICAGO (O'HARE INTERNATIONAL)</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>2465</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>KORD</ICAOCode>
<IATACode>ORD</IATACode>
<AirportName>CHICAGO (O'HARE INTERNATIONAL)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>KJFK</ICAOCode>
<IATACode>JFK</IATACode>
<AirportName>NEW YORK/JOHN F KENNEDY INTERNATIONAL</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>641</GCDistanceNM>
</Leg>
</Flight>
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Showing on the server as a Madrid flight:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>EZY54MH</FlightNumber>
<Callsign>Easy 54MH</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LFRS</ICAOCode>
<IATACode>NTE</IATACode>
<AirportName>NANTES</AirportName>
<Country>FRANCE</Country>
</Origin>
- <Destination>
<ICAOCode>LFLL</ICAOCode>
<IATACode>LYS</IATACode>
<AirportName>LYON (SATOLAS)</AirportName>
<Country>FRANCE</Country>
</Destination>
<GCDistanceNM>289</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Server shown Belfast-Liverpool:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>EZY8DF</FlightNumber>
<Callsign>Easy 8DF</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LPFR</ICAOCode>
<IATACode>FAO</IATACode>
<AirportName>FARO</AirportName>
<Country>PORTUGAL</Country>
</Origin>
- <Destination>
<ICAOCode>EGGD</ICAOCode>
<IATACode>BRS</IATACode>
<AirportName>BRISTOL/LULSGATE</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>890</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Interesting route in the database for this one - Bucharest to Bucharest !
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>WZZ746Q</FlightNumber>
<Callsign>Wizzair 746Q</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LIRA</ICAOCode>
<IATACode>CIA</IATACode>
<AirportName>ROME (CIAMPINO)</AirportName>
<Country>ITALY</Country>
</Origin>
- <Destination>
<ICAOCode>LRBS</ICAOCode>
<IATACode>BBU</IATACode>
<AirportName>BUCHAREST (BANEASA)</AirportName>
<Country>ROMANIA</Country>
</Destination>
<GCDistanceNM>612</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Just landed at Gatwick (server showing Dublin to Glasgow):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>EIN232</FlightNumber>
<Callsign>Shamrock 232</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EIDW</ICAOCode>
<IATACode>DUB</IATACode>
<AirportName>DUBLIN</AirportName>
<Country>IRELAND</Country>
</Origin>
- <Destination>
<ICAOCode>EGKK</ICAOCode>
<IATACode>LGW</IATACode>
<AirportName>LONDON/GATWICK</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>261</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
-
Currently inbound LHR, no route showing:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>SWR54Y</FlightNumber>
<Callsign>Swiss 54Y</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LSGG</ICAOCode>
<IATACode>GVA</IATACode>
<AirportName>GENEVA</AirportName>
<Country>SWITZERLAND</Country>
</Origin>
- <Destination>
<ICAOCode>EGLL</ICAOCode>
<IATACode>LHR</IATACode>
<AirportName>LONDON/HEATHROW</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>407</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Dave: are you interested in correcting our database directly instead of posting 1 or 2 corrections that make no difference at all for the total number of records we have?
-
Dave: are you interested in correcting our database directly instead of posting 1 or 2 corrections that make no difference at all for the total number of records we have?
I don't understand what you mean.
Anyone is free to use my posts to update their local flights table.
Equally, you are perfectly welcome to use the same data youselves to update the central database, to everyone's benefit, although I note that you haven't done so as yet, if that's what you mean by "making no difference".
Do you have a proposition in mind, or are you simply complaining that I'm not posting enough updates ? PM me if it's something you prefer not to discuss in the open forum.
-
hello
Here are 2 routes chosen at random to be updated By Dave.
<Flight>
<FlightNumber>TFL995</FlightNumber>
<Callsign>Arkefly 995</Callsign>
<Error>No information for this flight number</Error>
</Flight>
(EHAM-BIKF from airnav's route server)
<Flight>
<FlightNumber>DLH6HT</FlightNumber>
<Callsign>Lufthansa 6HT</Callsign>
<Error>No information for this flight number</Error>
</Flight>
(EGLL-EDDK from libhomeradar)
Also in my opinion the best service for transatlantic/USA flight routes is flightaware .
Andrew
-
DLH6HT (LH4787) does indeed fly EGLL-EDDK.
TFL995 doesn't belong in any database as it's a positioning flight.
That's fortunate, as today's routing (EHAM-BIKF-CYYZ-KMIA) wouldn't fit in AirNav's From-To-Via database structure anyway.
-
TFL995 doesn't belong in any database as it's a positioning flight.
hello
If you know it is a positioning wouldn't using "positioning flight - various routes" rather than "No information for this flight number" be better?
Andrew
-
If you know it is a positioning wouldn't using "positioning flight - various routes" rather than "No information for this flight number" be better?
That might be worth considering, although it's not quite that straightforward.
Despite having a simple web browser interface which allows end-users like you to interrogate the database, the web service is principally aimed at server-based SOAP/.NET-compatible applications (which is why it returns data in XML format).
I'll check with the operators of those hosts that are currently using the web service (or the ones that I know about, at least) to make sure it wouldn't break any of their applications.
-
Hello Dave
Thanks for letting me know that
Andrew
-
hello again
Sorry to bother you again but Do you have any idea what the routing of AEY14 AEY19 and AEY15 is within the last 5 days?
Andrew
-
Sorry to bother you again but Do you have any idea what the routing of AEY14 AEY19 and AEY15 is within the last 5 days?
Afraid not.
Other than the AEY1xx domestic routes and the AEY4xx/5xx international services I don't have any other Air Italy routings.
And best not to ask AirNav directly, I did that with an Air India flight a week ago and got my knuckles rapped for it ...
-
Dave, if you have a way for us to automatically update our database let us know.
We have to be inteligent here and posting routing information one by one is not the smartest way of getting and even better database.
-
Just departed LHR, no route shown:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>IBE31GL</FlightNumber>
<Callsign>Iberia 31GL</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EGLL</ICAOCode>
<IATACode>LHR</IATACode>
<AirportName>LONDON/HEATHROW</AirportName>
<Country>UNITED KINGDOM</Country>
</Origin>
- <Destination>
<ICAOCode>LEMD</ICAOCode>
<IATACode>MAD</IATACode>
<AirportName>MADRID (BARAJAS)</AirportName>
<Country>SPAIN</Country>
</Destination>
<GCDistanceNM>672</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Dave, if you have a way for us to automatically update our database let us know.
We have to be inteligent here and posting routing information one by one is not the smartest way of getting and even better database.
We're going round in circles here.
I have already suggested a method by which routes could be automatically derived and validated from network flights data.
You tell us that you have now implemented this (although you refuse to discuss the details).
It clearly isn't working.
What do you want me to do about it ?
-
Currently on the network over western France (server shows Rome to Addis Ababa):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>ETH501</FlightNumber>
<Callsign>Ethiopian 501</Callsign>
- <Leg>
- <Origin>
<ICAOCode>KIAD</ICAOCode>
<IATACode>IAD</IATACode>
<AirportName>WASHINGTON (DULLES)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>LIRF</ICAOCode>
<IATACode>FCO</IATACode>
<AirportName>ROME (LEONARDO DA VINCI)</AirportName>
<Country>ITALY</Country>
</Destination>
<GCDistanceNM>3902</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>LIRF</ICAOCode>
<IATACode>FCO</IATACode>
<AirportName>ROME (LEONARDO DA VINCI)</AirportName>
<Country>ITALY</Country>
</Origin>
- <Destination>
<ICAOCode>HAAB</ICAOCode>
<IATACode>ADD</IATACode>
<AirportName>ADDIS ABABA (BOLE INTERNATIONAL)</AirportName>
<Country>ETHIOPIA</Country>
</Destination>
<GCDistanceNM>2418</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Just airborne from Heathrow, no route showing:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>BAW982G</FlightNumber>
<Callsign>Speedbird 982G</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EGLL</ICAOCode>
<IATACode>LHR</IATACode>
<AirportName>LONDON/HEATHROW</AirportName>
<Country>UNITED KINGDOM</Country>
</Origin>
- <Destination>
<ICAOCode>EDDT</ICAOCode>
<IATACode>TXL</IATACode>
<AirportName>BERLIN (TEGEL)</AirportName>
<Country>GERMANY</Country>
</Destination>
<GCDistanceNM>511</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Currently showing on the network on finals for Madrid/Barajas (route showing as Houston-Newark):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>COA62</FlightNumber>
<Callsign>Continental 62</Callsign>
- <Leg>
- <Origin>
<ICAOCode>KIAH</ICAOCode>
<IATACode>IAH</IATACode>
<AirportName>HOUSTON (INTERCONTINENTAL)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>KEWR</ICAOCode>
<IATACode>EWR</IATACode>
<AirportName>NEWARK</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>1215</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>KEWR</ICAOCode>
<IATACode>EWR</IATACode>
<AirportName>NEWARK</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>LEMD</ICAOCode>
<IATACode>MAD</IATACode>
<AirportName>MADRID (BARAJAS)</AirportName>
<Country>SPAIN</Country>
</Destination>
<GCDistanceNM>3124</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Currently showing on the network overhead Banbury (route showing as Gatwick to Heathrow): BAW9263
BAW9xxx flight numbers are non-scheduled flights, with variable routings, and should not be in the flight lookup database.
-
Currently showing on the network overhead Nantes (route showing as Liverpool to Stansted): EZY8005
EZY8xxx flight numbers are non-scheduled flights, with variable routings, and should not be in the flight lookup database.
-
Noted on the network, southbound over Munich (database shows Berlin to Gatwick):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>EZY655Q</FlightNumber>
<Callsign>Easy 655Q</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EDDB</ICAOCode>
<IATACode>SXF</IATACode>
<AirportName>BERLIN (SCHONEFELD)</AirportName>
<Country>GERMANY</Country>
</Origin>
- <Destination>
<ICAOCode>LIPZ</ICAOCode>
<IATACode>VCE</IATACode>
<AirportName>VENICE (MARCO POLO)</AirportName>
<Country>ITALY</Country>
</Destination>
<GCDistanceNM>414</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Currently on the network, on final approach to Frankfurt (route showing as Denver-Washington):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>UAL932</FlightNumber>
<Callsign>United 932</Callsign>
- <Leg>
- <Origin>
<ICAOCode>KDEN</ICAOCode>
<IATACode>DEN</IATACode>
<AirportName>DENVER (INTERNATIONAL)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>KIAD</ICAOCode>
<IATACode>IAD</IATACode>
<AirportName>WASHINGTON (DULLES)</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>1258</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>KIAD</ICAOCode>
<IATACode>IAD</IATACode>
<AirportName>WASHINGTON (DULLES)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>EDDF</ICAOCode>
<IATACode>FRA</IATACode>
<AirportName>FRANKFURT (INTERNATIONAL)</AirportName>
<Country>GERMANY</Country>
</Destination>
<GCDistanceNM>3535</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Noted on the network over Bucharest: BAF630 (Belgian Air Force) showing as Washington-Brussels.
Can this flight be removed from the database, please ?
-
Currently on the network on final approach to Ontario (route showing as Hong Kong-Anchorage):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>UPS59</FlightNumber>
<Callsign>UPS 59</Callsign>
- <Leg>
- <Origin>
<ICAOCode>VHHH</ICAOCode>
<IATACode>HKG</IATACode>
<AirportName>HONG KONG (INTERNATIONAL)</AirportName>
<Country>HONG KONG</Country>
</Origin>
- <Destination>
<ICAOCode>PANC</ICAOCode>
<IATACode>ANC</IATACode>
<AirportName>ANCHORAGE (INTERNATIONAL/KULIS ANGB)</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>4397</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>PANC</ICAOCode>
<IATACode>ANC</IATACode>
<AirportName>ANCHORAGE (INTERNATIONAL/KULIS ANGB)</AirportName>
<Country>UNITED STATES</Country>
</Origin>
- <Destination>
<ICAOCode>KONT</ICAOCode>
<IATACode>ONT</IATACode>
<AirportName>ONTARIO</AirportName>
<Country>UNITED STATES</Country>
</Destination>
<GCDistanceNM>2047</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
Dave
-
Noted on the network on finals for 27L at Paris/CDG (server shows Montreal to Varadero, Cuba):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>TSC278</FlightNumber>
<Callsign>Air Transat 278</Callsign>
- <Leg>
- <Origin>
<ICAOCode>CYYZ</ICAOCode>
<IATACode>YYZ</IATACode>
<AirportName>TORONTO (LESTER B PEARSON INTERNATIONAL)</AirportName>
<Country>CANADA</Country>
</Origin>
- <Destination>
<ICAOCode>CYQB</ICAOCode>
<IATACode>YQB</IATACode>
<AirportName>QUEBEC</AirportName>
<Country>CANADA</Country>
</Destination>
<GCDistanceNM>395</GCDistanceNM>
</Leg>
- <Leg>
- <Origin>
<ICAOCode>CYQB</ICAOCode>
<IATACode>YQB</IATACode>
<AirportName>QUEBEC</AirportName>
<Country>CANADA</Country>
</Origin>
- <Destination>
<ICAOCode>LFPG</ICAOCode>
<IATACode>CDG</IATACode>
<AirportName>PARIS/CHARLES DE GAULLE</AirportName>
<Country>FRANCE</Country>
</Destination>
<GCDistanceNM>2855</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
AirNav - when are we going to start seeing routes being properly validated by this new algorithm that is supposedly now in operation ?
Clearly if the network sees an aircraft landing at CDG, it's not rocket science to work out that it can't be flying from Canada to Cuba !
-
AirNav - when are we going to start seeing routes being properly validated by this new algorithm that is supposedly now in operation ?
And answer - predictably - came there none.
I guess that tells us all we need to know ...
-
Noted on the network on finals for runway 18 at Frankfurt (server shows Heathrow to Hamburg):
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>DLH3YE</FlightNumber>
<Callsign>Lufthansa 3YE</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EDDT</ICAOCode>
<IATACode>TXL</IATACode>
<AirportName>BERLIN (TEGEL)</AirportName>
<Country>GERMANY</Country>
</Origin>
- <Destination>
<ICAOCode>EDDF</ICAOCode>
<IATACode>FRA</IATACode>
<AirportName>FRANKFURT (INTERNATIONAL)</AirportName>
<Country>GERMANY</Country>
</Destination>
<GCDistanceNM>234</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
-
On the network overhead Paris:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>RYR8PM</FlightNumber>
<Callsign>Ryanair 8PM</Callsign>
- <Leg>
- <Origin>
<ICAOCode>EGSS</ICAOCode>
<IATACode>STN</IATACode>
<AirportName>LONDON/STANSTED</AirportName>
<Country>UNITED KINGDOM</Country>
</Origin>
- <Destination>
<ICAOCode>LIMF</ICAOCode>
<IATACode>TRN</IATACode>
<AirportName>TURIN (CASELLE)</AirportName>
<Country>ITALY</Country>
</Destination>
<GCDistanceNM>497</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
-
Just outbound from Gatwick now, due back 1805 on the return leg:
<?xml version="1.0" encoding="utf-8" ?>
- <Flight>
<FlightNumber>EZY268W</FlightNumber>
<Callsign>Easy 268W</Callsign>
- <Leg>
- <Origin>
<ICAOCode>LIPZ</ICAOCode>
<IATACode>VCE</IATACode>
<AirportName>VENICE (MARCO POLO)</AirportName>
<Country>ITALY</Country>
</Origin>
- <Destination>
<ICAOCode>EGKK</ICAOCode>
<IATACode>LGW</IATACode>
<AirportName>LONDON/GATWICK</AirportName>
<Country>UNITED KINGDOM</Country>
</Destination>
<GCDistanceNM>603</GCDistanceNM>
</Leg>
</Flight>
Source: www.flightroutelookup.com
This information is hereby placed in the public domain and may be freely used without attribution by any individual or organisation.
-
Dave,
If you want to help out please send us a document (xml, database) to provide us the routes which we are missing and we will do our best to add it to the database.
Please do not continue posting like this as we do not have the man power to individually go through posts and add them. Thanks.
-
If you want to help out please send us a document (xml, database) to provide us the routes which we are missing and we will do our best to add it to the database.
I certainly don't have any problem providing updates in XML format and/or as email attachments, if that makes it easier for you to use them.
I'm assuming that you're happy with the schema as it's one that you specifically requested: www.airnavsystems.com/forum/index.php?topic=5333.msg53551#msg53551, and that as you've asked for that format, you have a process that can easily import them.
Just tell me where you'd like them sent.
Please do not continue posting like this as we do not have the man power to individually go through posts and add them. Thanks.
You're forgetting one important thing - as we've seen from the main Improved Routing Information thread, many members are interested in keeping their own local flights database up-to-date while you sort out yours.
The route updates are as much for their benefit as yours. In fact there appears to be a demand for an easy-to-use utility with which less technically-inclined members can maintain their routes databases - if there's enough interest, I'll look at the possibility of providing one.
-
Cheers Dave.
-
there appears to be a demand for an easy-to-use utility with which less technically-inclined members can maintain their routes databases
The technical term for this is a "clerical assistant".
Get it done and there's a cheque in the post young Dave.
-
Understood Dave.
We are working on a way to get some of these routes bulk update and will provide a method soon. Please be patient with us.
In meantime we do ask not to provide individual flight routes on this forum. While there may be users who want to update there local databses, we will provide a method to bulk update so this is not needed.
-
there appears to be a demand for an easy-to-use utility with which less technically-inclined members can maintain their routes databases
Get it done and there's a cheque in the post young Dave.
It would definitely be free to anyone who calls me "young" :-)
But seriously, it's not something it would ever have occurred to me to charge for. Anyway, here's a preview of what it might look like (subject to change):
(http://www.civilaircraftregisters.org/Mode_S_Resources/AirNav%20NavData%20Route%20Update%201.jpg)
Minimum functionality, IMHO, should include:
i) pull-down selection and validation of origin, destination and intermediate airports
ii) ability to sort and search by O/D/via
iii) automatic date/timestamping of updates
iv) import/export from/to CSV and Excel
v) ability to compare local and server routings
Comments welcomed.
Dave
-
Suitable for Numpties?
-
Suitable for Numpties?
Taken as read :-)
-
Suitable for Numpties
Never underestimate the stupidity of humanity
after all " Where is Any Key on my keyboard"
-
I`ve got reams of paper with "click" on it. :-)
-
Any offers for TOM2EW ?
On the network abeam Florence at FL370, heading south-east. Seems to operate on Fridays only, usually returns as TOM88T.
Route showing as EGBB-EGNX, presumably taking the good folks of Birmingham on a package holiday to Nottingham (or vice versa).
-
Is it at all conceivable that a callsign such as TOM2EW can be used on a different day for a different flight or is this just not possble?
-
Is it at all conceivable that a callsign such as TOM2EW can be used on a different day for a different flight or is this just not possble?
Yes, it's perfectly possible for the routing for a given flight number to vary from day to day.
AIC188 from Heathrow is a good example of that - 4 days a week it routes EGLL-VIAR and the other 3 days EGLL-VIDP.
The industry has a term for this: IV (Itinerary Variation).
-
Is it at all conceivable that a callsign such as TOM2EW can be used on a different day for a different flight or is this just not possble?
Yes, it's perfectly possible for the routing for a given flight number to vary from day to day.
AIC188 from Heathrow is a good example of that - 4 days a week it routes EGLL-VIAR and the other 3 days EGLL-VIDP.
The industry has a term for this: IV (Itinerary Variation).
I have a term for it as well but not one I'm prepared to write down.
Just wondered if it might explain the odd different interpretation of the same ID. I'll keep my eye open for an example or two,
-
Just wondered if it might explain the odd different interpretation of the same ID. I'll keep my eye open for an example or two,
You won't see the same (scheduled) flight number being used on two completely different routes at the same time - that would be a recipe for chaos - IVs only cover minor route variations or, more often, other details like timings or aircraft type.
But that's not what's happening with that TOM flight - even if it hadn't been over Italy, RB's suggestion that they have a scheduled service on the 27nm route from Birmingham to East Midlands is just plain daft.