GAS Database of aircraft

tarbat · January 13, 2009, 05:28:29 PM

If anyone is looking for a read-made database of 10,266 aircraft to populate into their Navdata aircraft table, note that the full GAS database is available for download as part of the SBS1 resources download, at http://www.kinetic-avionics.co.uk/downloadssbs1.php

I simply exported the aircraft from this download, and imported into my aircraft table. I've now got correct owners and serial numbers, etc.

besty · January 13, 2009, 05:44:19 PM

Is it best to empty your aircraft table or will this lose all the aircraft I have picked up? The aircraft I have picked up will still be in the My log file?

tarbat · January 13, 2009, 05:48:50 PM

MyLog stays intact. It's only the Navdata I updated. What I did was:
1. Backup Navdata
2. Empty the aircraft table in Navdata
3. Import the 10,000+ aircraft from the download
4. Export all aircraft from the backed-up Navdata
5. Import that into the new Navdata, using InsertNew/Append only (in SQLite Maestro), so that anything I had in Navdata that wasn't in the GAS download got replaced.

NOT for the faint-hearted!!

Fenris · January 13, 2009, 05:57:03 PM

Which is the actual database, one of the files named GAS<something>? I assume it's the big zipped SBS Resources file that one downloads?

tarbat · January 13, 2009, 05:57:49 PM

Yes, download the big resources file. THe GAS database is in the Registrations folder (I think).

Fenris · January 13, 2009, 06:00:38 PM

Oh yes, I see. Missed that on the first trawl through.

abrad41 · January 13, 2009, 07:02:16 PM

tarbat

Did it fill all the fields in, Inluding the AT Field - you know the one people have problem with the ---

Andy

tarbat · January 13, 2009, 07:12:01 PM

Yes, got rid of all those "..." in the AT field. Note, that it's still not a complete database of all aircraft. Even after importing the 10,000+ aircraft, there were still over 3,000 in my backed-up Navdata that I had to add back into the new database.

Haven't got time now, but tomorrow I'll do some work to see whats not in the database.

abrad41 · January 13, 2009, 07:34:13 PM

As you know I am doing mine manually, I think I am upto about 5,600 in the Navdata.db3 so far, but still a way to go.

Will have a look at the Gas Database when I get the chance.

Brian · January 13, 2009, 10:31:03 PM

I wish AirNavSystem would do the same update ^above^! It be handy if they keep the database more updated. Then it be much better for the RadarBox users. :)

-Brian
RadarBox User Forum
http://radarspotters.eu/forum/

tarbat · January 14, 2009, 10:19:52 AM

Attached zip file contains the 10,000+ aircraft from this SBS1 download in csv format. Extracted using this SQL:

SELECT 
  Aircraft.ModeS as MS,
  Aircraft.Registration as AR,
  Aircraft.ICAOTypeCode as AT,
  Aircraft.Type as AN,
  Aircraft.RegisteredOwners as AC,
  Aircraft.SerialNo as CN
FROM
 Aircraft

Airnav, is it worth considering importing this into your central database of aircraft?

DaveReid · January 14, 2009, 10:29:27 AM

Quote from: tarbat on January 14, 2009, 10:19:52 AM
Airnav, is it worth considering importing this into your central database of aircraft?

Probably - but beware there are some dodgy/missing ICAOTypeCode values that really ought to be fixed first.

Dave

GAS Database of aircraft

Fenris

Fenris

abrad41

abrad41