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

Login with username, password and session length
 


Author Topic: DB Tidy up in prep for V3  (Read 6099 times)

0 Members and 1 Guest are viewing this topic.

GreekSpy2001

  • Hero Member
  • *****
  • Posts: 695
    • Graham's Aircraft Photos
DB Tidy up in prep for V3
« on: June 17, 2009, 10:44:03 AM »
Assuming that v3 will update my current db of aircraft recorded thought it might be prudent to clear out some of the errors.  The most obvious is the three dots instead of the short aircraft type.  I would like just to delete those records in the assumption that they will populate correctly in v3. Has anyone a script that can do this quickly?

Maybe someone may have other suggestions for tidying up the db?

Thanks

Graham
« Last Edit: June 17, 2009, 10:47:22 AM by GreekSpy2001 »

dumpty

  • Jr. Member
  • **
  • Posts: 84
Re: DB Tidy up in prep for V3
« Reply #1 on: June 18, 2009, 03:57:35 AM »
Good question Graham.

Does anybody know?

RodBearden

  • Hero Member
  • *****
  • Posts: 9148
    • Rod's RadarBox Downloads
Re: DB Tidy up in prep for V3
« Reply #2 on: June 18, 2009, 09:28:13 AM »
On tip I can give is that we'll be making use of the Airlines table to give us logos for aircraft using IATA codes as flight ID's.

So it will help to check which airlines are using IATA codes, and make sure that the Airlines table contains the correct ICAO code for them.

Rod
Rod

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: DB Tidy up in prep for V3
« Reply #3 on: June 18, 2009, 11:53:42 AM »
On tip I can give is that we'll be making use of the Airlines table to give us logos for aircraft using IATA codes as flight ID's.

So it will help to check which airlines are using IATA codes, and make sure that the Airlines table contains the correct ICAO code for them.

That's a wise move, you would be surprised how many airlines are still guilty of this.

In the last couple of weeks at Heathrow alone I've logged the following examples, amongst others:

9W122
AA79
AI111
AZ204
BA124
BD5WC
EI176
ET710
GF007
IB3168
IT007
JL401
ME201
RJ111
UN353
WY911
XM5248

Note that XM is used by CAI First (Alitalia codeshare, ICAO SMX) whereas the database has Australian Air Express for XM.

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

malc41

  • RadarBox Beta Testers
  • Hero Member
  • *
  • Posts: 586
Re: DB Tidy up in prep for V3
« Reply #4 on: June 18, 2009, 04:12:13 PM »
Some of this is down to crew laziness, though more often that not the planners try to hit too many keys at the wrong time

15 Miles East of EGNJ

RodBearden

  • Hero Member
  • *****
  • Posts: 9148
    • Rod's RadarBox Downloads
Re: DB Tidy up in prep for V3
« Reply #5 on: June 18, 2009, 04:32:43 PM »
BTW, it will also help to delete old defunct airlines from the table, as their IATA codes may confuse things.

There are some duplicate IATA codes there too - it appears that IATA tolerates duplicates - you get a few current duplicates in airframes.org, anyway. I suggest that you remove unwanted duplicates, but you may want to wait until you get V3 before you decide which duplicate to delete!

Rod
Rod

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: DB Tidy up in prep for V3
« Reply #6 on: June 18, 2009, 04:39:00 PM »
There are some duplicate IATA codes there too

Airnav, might be worth changing the primary key on the table.  When I originally created the primary keys, I made C3 the primary key, and prevented duplicates.  Suggest we make C2 the primary key, and prevent duplicates, if that's going to be the main use for this table now.

RodBearden

  • Hero Member
  • *****
  • Posts: 9148
    • Rod's RadarBox Downloads
Re: DB Tidy up in prep for V3
« Reply #7 on: June 18, 2009, 04:45:31 PM »
I vote for that too - excellent idea, Tarbat.

Rod
Rod

DaveReid

  • Hero Member
  • *****
  • Posts: 1815
    • Heathrow last 100 ADS-B arrivals
Re: DB Tidy up in prep for V3
« Reply #8 on: June 18, 2009, 05:01:04 PM »
Airnav, might be worth changing the primary key on the table.  When I originally created the primary keys, I made C3 the primary key, and prevented duplicates.  Suggest we make C2 the primary key, and prevent duplicates, if that's going to be the main use for this table now.

Beware.

Because of the relatively small number of combinations available, IATA have made provision for what they refer to as "controlled duplication" of codes, so you could in theory see the same code used by two small, local airlines on opposite sides of the world or, in some cases, a code used by one passenger carrier and another all-cargo airline.

Having said that, I can't think of any current examples off the top of my head, apart from the aforementioned XM.

It's also true, of course, that many operators have ICAO codes but no IATA code, which might affect the ability to create a PK on C2.
This post has been scanned for any traces of negativity, bias, sarcasm and general anti-social behaviour

RodBearden

  • Hero Member
  • *****
  • Posts: 9148
    • Rod's RadarBox Downloads
Re: DB Tidy up in prep for V3
« Reply #9 on: June 18, 2009, 05:05:18 PM »
Dave - in the case of valid duplicate IATA codes, users are going to have to decide for themselves which logo to show, so forcing them to be unique won't do any harm, unless the logic gets more complex and compares the airline name with the one retrieved from GAS, and that won't always work (chartered aircraft, etc).

Rod
Rod

CoastGuardJon

  • Hero Member
  • *****
  • Posts: 1178
  • Mullion Cove, Kernow --- sw Cornwall UK.
Re: DB Tidy up in prep for V3
« Reply #10 on: June 18, 2009, 08:21:32 PM »
more often that not the planners try to hit too many keys at the wrong time

I suffer from the same syndrome - my mate calls it "sausage fingers" - I have to use a stylus (usually a biro) to set my Tom Tom and use the work's mobile.
ANRB :  AOR AR8000 : Icom R-7000 : Icom IC-R9000 : JRC NRD-545 : OptoElectronics Digital Scout and OptoLinx Interface; Realistic Pro-2005 : UBC 800XLT - listed in alphabetical order, not cost, preference, performance or entertainment value!