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

Login with username, password and session length
 


Author Topic: Improved Routing Information  (Read 228114 times)

0 Members and 1 Guest are viewing this topic.

orkney

  • Database Updater Moderator
  • Hero Member
  • *****
  • Posts: 1550
    • orkney radarbox screenshot
Re: Improved Routing Information
« Reply #405 on: October 28, 2010, 11:03:44 AM »
hello

I have converted this into csv.

The format is callsign, origin (ICAO), destination (ICAO)

Andrew

LSZS

  • Jr. Member
  • **
  • Posts: 66
Re: Improved Routing Information
« Reply #406 on: October 28, 2010, 05:55:25 PM »
I'd like to contribute to the routing population. Here are the ONLY numerical flights number of LIMC Airport.
Timestamp is the expire date of end March.
Then, day per day I write the alphanumerical callsign with the Tarbat’s Route Mach database of post#272 and DaveReid’s FRL
I can contribute with flights from/to LIMC, LIML and LIME
I remember that Lufthansa changes ALL flight numbers from Sunday.
Saturday night I empty the routes table of navdata to start from the beginning with routes and I turn off for the first week the routing autopopulate option. So, I can't overwrite with old routes.
I forgot to insert the EZY flights. Unfortunately I wrote the airports in IATA format. Tarbat or an other who can use SLQlite can convert these in ICAO format.
The Easy file is attached here now

Happy Iata winter season to all.
« Last Edit: October 30, 2010, 10:19:07 AM by LSZS »
Engadin Airport auf 1707m / 5600ft. Europas höchstgelegener Flughafen
http://www.flickr.com/photos/stefanobazzi/

flybhx

  • Guest
Re: Improved Routing Information
« Reply #407 on: November 08, 2010, 11:04:28 PM »
Is there an easy way of importing the flybee csv file to the local database or is there a way of converting it so that sqlite can import it please

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Improved Routing Information
« Reply #408 on: November 09, 2010, 08:55:40 AM »
Is there an easy way of importing the flybee csv file to the local database or is there a way of converting it so that sqlite can import it please

Try running this SQL

flybhx

  • Guest
Re: Improved Routing Information
« Reply #409 on: November 09, 2010, 11:35:57 AM »
thanks Tarbat you're a star

One problem, when I run it in the screen is flashing error messages in the dos window about an error near "."
« Last Edit: November 09, 2010, 11:41:11 AM by flybhx »

flybhx

  • Guest
Re: Improved Routing Information
« Reply #410 on: November 09, 2010, 11:44:18 AM »
found the problem, now resolved

Kev

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: Improved Routing Information
« Reply #411 on: November 20, 2010, 06:47:15 PM »
I noticed that there were no routes showing for Wizz flights. Here is a list that you might want to import.

PS - it took me about an hour to get all the Wizz routes sorted.
« Last Edit: November 21, 2010, 03:55:13 PM by Chris11 »

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Improved Routing Information
« Reply #412 on: November 22, 2010, 05:32:00 PM »
A useful source of route data is that used by the Planeplotter community and others.  There is a database of 32000+ routes on a Yahoo group at
http://groups.yahoo.com/group/PP-logs-and-routes/files/

It even has those elusive Loganair routes :)  I can't vouch for it's accuracy, but I believe a lot of work goes into updating it.

It's an SQLite database, so I've created the following SQL to extract the relevant data for import into a Radarbox routes table.  I haven't included the vias (NV), since there aren't many in the database anyway.

SELECT DISTINCT 
  FlightRoute.flight AS FN,
  substr(FlightRoute.route,1,4) AS NO,
  substr(FlightRoute.route,length(FlightRoute.route)-3,4) AS ND,
  "" AS NV,
  substr(date('now'),1,4) || substr(date('now'),6,2) || substr(date('now'),9,2) || "090000" AS CH
FROM
 FlightRoute
ORDER BY
  FN


Airnav, how about adding these to your central database?
« Last Edit: November 22, 2010, 05:40:48 PM by tarbat »

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: Improved Routing Information
« Reply #413 on: November 22, 2010, 05:56:16 PM »
Hi Tarbat
Thanks for that link. Is there sql for dummies that will enable me to understand your post above.

I agree that Airnav should consider importing these. Anything is better than nothing.
« Last Edit: November 22, 2010, 06:13:59 PM by Chris11 »

bratters

  • Hero Member
  • *****
  • Posts: 935
Re: Improved Routing Information
« Reply #414 on: November 22, 2010, 07:48:25 PM »

I agree that Airnav should consider importing these. Anything is better than nothing.

Not quite Chris - I'd rather have nothing than some of the totally misleading rubbish that continues to plague my screen. 

If it isn't accurate, leave it blank.


tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Improved Routing Information
« Reply #415 on: November 22, 2010, 07:59:24 PM »

I agree that Airnav should consider importing these. Anything is better than nothing.

Not quite Chris - I'd rather have nothing than some of the totally misleading rubbish that continues to plague my screen.  

If it isn't accurate, leave it blank.



Well, the ones I've checked from the Planeplotter routes database have all been spot on.  Not sure how anyone can check all 32000 routes for accuracy, but I'm happy to use them in my routes table.
« Last Edit: November 22, 2010, 08:04:17 PM by tarbat »

bratters

  • Hero Member
  • *****
  • Posts: 935
Re: Improved Routing Information
« Reply #416 on: November 22, 2010, 08:07:26 PM »
Hiya Tarbat - I and a few dozen others are still wating patiently on the sidelines. It would make a nice Christmas present? Or maybe Hogmanay?

Actually when Chris11 writes "anything is better than nothing" I have a horrible feeling he's closer to the truth than perhaps he thinks. Could be wrong though - we live in hope.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Improved Routing Information
« Reply #417 on: November 22, 2010, 09:22:03 PM »
Hi Tarbat
Thanks for that link. Is there sql for dummies that will enable me to understand your post above.

Unless you understand SQL, I wouldn't recommend attempting an import of 30000+ records.  I used SQLite Maestro to import the database, write the SQL query, export the data in XML format, and then import the XML data into the routes table.

Sorry if it sounds complex, but my programming skills don't extend to writing a program to do it automatically.
« Last Edit: November 22, 2010, 09:30:20 PM by tarbat »

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: Improved Routing Information
« Reply #418 on: November 23, 2010, 08:42:34 AM »
Thanks - got sorted

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: Improved Routing Information
« Reply #419 on: November 24, 2010, 05:19:51 AM »
The problem with importing flight routes that you only see on the network is that they will never be updated so your database will continue to grow.