New Navdata.db3 - 20130819

[orkney]

Hello

Once again, The new Navdata Installer can be downloaded from the link below:
http://www.airnavsystems.com/download/ANRB/DBUpdater/ANRBDBUpdater20130819.exe

This one has  203,651 aircraft records.

Thank you

Andrew

[Kenny]

Download and installed without any problem.

Thanks

[CoastGuardJon]

I've lost 2! Showing 203,649 - many thanks to all updaters who are the only people doing anything to keep RB going, such a shame that AN can't or unwilling to match your enthusiasm for their product.   Thanks Guys!!!

[vena]

Hallo,
thanks , Vena

[nortonbeak]

Thank you :-)

[Northern Watch]

Thank you once again and please keep up the good excellent work.

regards

Keith

[jim_stockwell]

Thank you all for continuing this great work. Really does make a difference! (Like CoastguardJohn I seem to have lost 2 as I have 203649)

Jim

[54901 - Jim]

Thanks, again, everyone!

[Runway 31]

Maybe I had populated another couple when looking at the total for checking, the total is round about what it states in the opening reply.  Nothing stays the same long in d/b land.

Alan

[tarbat]

Are you aware that you're using the wrong date/timestamp format on the routes table?


The field is defined as varchar(14), so using the format DDMMYYYY HH:MM:SS doesn't even match the size I defined for that field.

Routes downloaded online from the server have the correct format (YYYYMMDDHHMMSS):


Suggest you fix this to ensure that the route expiry routines in ANRB work correctly.

[orkney]

Hello Tarbat

We do not do anything with the timestamp. The format of the timestamp is decided by airnav's database settings. We cannot change it.

Andrew

[tarbat]

In that case AirNav need to fix this.  Added to bug-tracking #135.

Fortunately I use an empty Navdata database and simply rely on real-time updates from the servers, so doesn't affect me.

[MIKE.UTD]

Hi,

A big thank you again from me !!!

Mike.

[shouriken]

It looks like the new navdata database lost a lot of entries from the airlines table.
Now it contains only 1 entry. The 20130805 version contained 4985 entries.
The size of the 20130805 was 51.755.008 bytes and the size of 20130819 is 51.537.920 bytes.

PS. It's a little bit strange that the sqlite driver does not complain about the size of the data inserted in the timestamp field of the routes table.

[Runway 31]

Liviu,

I just checked the table that is used for the airlines and everything is there as it should be so it looks like the compiler must have had a problem.  I will ensure that it is OK next week when I run it again.  I have always wondered, is the airlines table actually used for anything?

Alan