Improved Routing Information

[orkney]

hello

I have converted this into csv.

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

Andrew

[LSZS]

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.

[flybhx]

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]

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]

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 "."

[flybhx]

found the problem, now resolved

Kev

[Chris11]

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.

[tarbat]

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?

[Chris11]

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.

[bratters]

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]

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.

[bratters]

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]

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.

[Chris11]

Thanks - got sorted

[Chris11]

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.