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

Login with username, password and session length
 


Author Topic: How to stop changing data  (Read 15127 times)

0 Members and 1 Guest are viewing this topic.

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: How to stop changing data
« Reply #15 on: July 14, 2010, 12:05:09 PM »
http://www.airnavsystems.com/download/anrb/databaseupdates/NavData.db3

It shouldn't really be any more complicated than that ...
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

Marpleman

  • Hero Member
  • *****
  • Posts: 738
  • Proper aeroplanes!
Re: How to stop changing data
« Reply #16 on: July 14, 2010, 12:42:25 PM »
http://www.airnavsystems.com/download/anrb/databaseupdates/NavData.db3

It shouldn't really be any more complicated than that ...

I'm getting a "dead" link on that page Dave???

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: How to stop changing data
« Reply #17 on: July 14, 2010, 12:54:58 PM »
Is the central Airnav database now up-to-date with all these updates.  If so, think I'll have a go at writing a VB program that:
1. Goes through each aircraft record in navdata.
2. Takes the ModeS hex code (HHHHHH).
2. Calls http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB111111&usversion=ANRB301&modes=HHHHHH
3. Takes the returned CSV data, and updates the aircraft record.

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: How to stop changing data
« Reply #18 on: July 14, 2010, 01:29:26 PM »
http://www.airnavsystems.com/download/anrb/databaseupdates/NavData.db3

It shouldn't really be any more complicated than that ...

I'm getting a "dead" link on that page Dave???

My point exactly !
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

DaveG

  • Hero Member
  • *****
  • Posts: 543
Re: How to stop changing data
« Reply #19 on: July 14, 2010, 01:31:16 PM »
Just for your info.  (also posted this in the other place)

The main database has currently 69637 records, and we have manually checked 31,025 to todays date, which leaves 38,612 still to check.

Majority of main production models within DB have been completed in this first push but still lots to keep us busy.

Dave
Cornwall, UK

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: How to stop changing data
« Reply #20 on: July 14, 2010, 01:33:28 PM »
Is the central Airnav database now up-to-date with all these updates.  If so, think I'll have a go at writing a VB program that:
1. Goes through each aircraft record in navdata.
2. Takes the ModeS hex code (HHHHHH).
2. Calls http://www.airnavsystems.com/cgi-bin/ANLV_SV/ANLV_SV_user.exe?usgetphoto=0&usverify_name=PGANRB111111&usversion=ANRB301&modes=HHHHHH
3. Takes the returned CSV data, and updates the aircraft record.

Yes, but (correct me if I'm wrong) that won't populate the AT (ICAO type code) column in the Aircraft table.

By the way, you're cheating - that's 4 steps, not 3  :-)
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

bratters

  • Hero Member
  • *****
  • Posts: 935
Re: How to stop changing data
« Reply #21 on: July 14, 2010, 07:28:56 PM »
I am sure I am not alone when I say I don't want to get involved with SQLite or any other, seemingly  "complex" PC centred work.

Understood.  But some of us are very happy to use a few commands to correct our local database.   I just wish Airnav would give us the choice.  They could issue a CSV file containing all updates after a certain date, for example.


With your knowledge and ability Tarbat so would I!

However my fear is that we could run the danger of establishing a two-tier community. Those (the few) who have up to date DBs in their RBs and those (the majority) who haven't.

As I see it, we are not discussing an optional add-on application here - this is about an integral and important part of RB operation and it has to be available to one and all.

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4127
Re: How to stop changing data
« Reply #22 on: July 14, 2010, 09:57:43 PM »
All,

We have amended the post below in our FAQ to answer some of the common questions about the database.

http://www.airnavsystems.com/forum/index.php?topic=2688.0

Work is ongoing on a update to the software so it can update records in the local database. We hope to have more news on this soon.

Please do not use method Tarbat has mentioned as that will overload the server with requests.

We apologise for the delay and we are doing our best that the software is rolled out as soon as possible and works 100%.

We want to keep everyone on the same page so we don't want to roll out csv's just yet. Though we may provide a navdata database with the latest entries from the AirNav database, we will look into that.

We also like to thank the database updates for there efforts so far.
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: How to stop changing data
« Reply #23 on: July 15, 2010, 06:48:41 AM »
Thanks - That's the info I needed

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: How to stop changing data
« Reply #24 on: July 15, 2010, 06:51:15 AM »
We have amended the post below in our FAQ to answer some of the common questions about the database.

http://www.airnavsystems.com/forum/index.php?topic=2688.0

You could usefully update your description on the above page of how and why Mode S codes change:

Quote
Mode-S IDs can also change there [sic] link to registrations. Example G-EUUT could go out of service and then 401240 is assigned to G-ELLB (In rare cases, usually the Mode-S link to registration stays the same).

That's not a "rare case", it's an example that can't ever happen - Mode S codes never get reassigned to a different aircraft in the UK, and indeed Mode S-to-registration tieups rarely change in any part of the world.
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

AirNav Support

  • AirNav Systems
  • Hero Member
  • *****
  • Posts: 4127
Re: How to stop changing data
« Reply #25 on: July 15, 2010, 07:45:04 AM »
Its been changed, thanks, anything else you think will explain the process better please say.
Contact Customer/Technical support via:
http://www.airnavsystems.com/contact.html
[email protected]

Chris11

  • Hero Member
  • *****
  • Posts: 1052
Re: How to stop changing data
« Reply #26 on: July 15, 2010, 08:33:30 AM »
That's not a "rare case", it's an example that can't ever happen - Mode S codes never get reassigned to a different aircraft in the UK, and indeed Mode S-to-registration tieups rarely change in any part of the world.

Maybe in the first world - try 3rd world CAA government officials. :)