Flight route update info

DaveReid · 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

tarbat · August 31, 2010, 09:59:35 AM

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

DaveReid · August 31, 2010, 11:04:14 AM

Quote from: tarbat on August 31, 2010, 09:59:35 AM
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.

DaveReid · August 31, 2010, 12:55:37 PM

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

DaveReid · September 01, 2010, 11:33:12 AM

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

DaveReid · September 01, 2010, 05:26:58 PM

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

DaveReid · September 02, 2010, 07:48:45 AM

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

DaveReid · September 02, 2010, 08:21:21 AM

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

DaveReid · September 02, 2010, 11:51:20 AM

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

DaveReid · September 03, 2010, 07:59:30 AM

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

DaveReid · September 03, 2010, 10:58:09 AM

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

DaveReid · September 03, 2010, 02:40:18 PM

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

DaveReid · September 04, 2010, 09:36:04 AM

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.

DaveReid · September 04, 2010, 11:31:40 AM

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

AirNav Development · September 04, 2010, 01:52:40 PM

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?