NavData.db3 - Blank clear copy of the file.

[Brian]

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/

[tarbat]

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

[Brian]

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/

[abrad41]

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]

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]

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]

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.