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

Login with username, password and session length
 


Author Topic: NavData.db3 - Blank clear copy of the file.  (Read 3931 times)

0 Members and 1 Guest are viewing this topic.

Brian

  • Jr. Member
  • **
  • Posts: 74
NavData.db3 - Blank clear copy of the file.
« on: December 20, 2008, 12:02:53 AM »
Hi,

I was wondering if anyone has a blank copy of the NavData.db3 file with no aircraft info in it.    Just want to start fresh for my area.

-Brian
RadarBox User Forum
http://radarspotters.eu/forum/
« Last Edit: May 16, 2009, 08:49:22 PM by Brian »

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: NavData.db3 - Blank clear copy of the file.
« Reply #1 on: December 20, 2008, 07:45:45 AM »
I've got one that is empty except for the actype, airlines, and airports tables.  However, even after vacuuming and zipping, it's too big to attach here (664kb).

You can create your own with SQLite Maestro.  Just open the database, right click on the tables you want to empty and select "empty".
« Last Edit: December 20, 2008, 07:51:05 AM by tarbat »

Brian

  • Jr. Member
  • **
  • Posts: 74
Re: NavData.db3 - Blank clear copy of the file.
« Reply #2 on: December 20, 2008, 07:55:54 AM »
Edit:  Just saw the screen shot.  Thanks! Didn't know it was that easy with two clicks :)

Thanks for the offer on the zip file.

I sent your a PM(personal message).

Edit2:  Thanks for the file. It works great. Nice and fresh database to start off with.

-Brian
RadarBox User Forum
http://radarspotters.eu/forum/
« Last Edit: May 16, 2009, 08:49:44 PM by Brian »

abrad41

  • Guest
Re: NavData.db3 - Blank clear copy of the file.
« Reply #3 on: December 20, 2008, 11:21:34 AM »
Thanks to tarbat I done the same thing Brian.

I thinks its the only way to go - I now can keep my database upto date manually. I started with a fresh database about a week ago, then on the 1st Jan 2009 I will clear mylog database so everything will be fresh for the new year.

There is a lot of manual updating to do at the start, but it will get easier as time goes on. 

Cheers

Andy

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: NavData.db3 - Blank clear copy of the file.
« Reply #4 on: December 20, 2008, 11:36:39 AM »
Agreed.  I took a blank Navdata, and for the aircraft table, I used GASPopulate to get reliable data for the 8000+ aircraft in MyLog, and imported that into the aircraft table.  I can now easily find new aircraft as they're added and check/correct the data.

jmhayes

  • Jr. Member
  • **
  • Posts: 62
Re: NavData.db3 - Blank clear copy of the file.
« Reply #5 on: December 20, 2008, 03:26:05 PM »
Here's what I did to make a completely empty database, using sqlite3:

Code: [Select]
% sqlite3 NavData.db3
sqlite3> .output schema
sqlite3> .schema
sqlite3> .exit
% sqlite3 NewNavData.db3
sqlite3> .read schema
sqlite3> .exit

That's it.

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: NavData.db3 - Blank clear copy of the file.
« Reply #6 on: December 20, 2008, 03:52:47 PM »
Doesn't that empty all tables, including the airports, aircraft types, companies, etc.   You would then need to populate these tables with new data, otherwise there'll be a lot of missing data.  For example, routes wouldn't display the airport name.

The approach I took was to only empty the aircraft and routes tables, since they're the only ones that get regular updates in Radarbox.