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

Login with username, password and session length
 


« previous next »
Pages: [1] 2 3 4

Author Topic: Flight route update info  (Read 35257 times)

0 Members and 2 Guests are viewing this topic.

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Flight route update info
« 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Flight route update info
« Reply #1 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
Logged

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #2 on: 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.

Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #3 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #4 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #5 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Flight route update info
« Reply #6 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Flight route update info
« Reply #7 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Flight route update info
« Reply #8 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #9 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Flight route update info
« Reply #10 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #11 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #12 on: 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.
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: Flight route update info
« Reply #13 on: 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
Logged
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

AirNav Development

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 2545
    • AirNav Systems
Re: Flight route update info
« Reply #14 on: 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?
Logged
Pages: [1] 2 3 4
« previous next »