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

Login with username, password and session length
 


Author Topic: Data Base Explorer abbreviations  (Read 3002 times)

0 Members and 1 Guest are viewing this topic.

leomicen

  • New Member
  • *
  • Posts: 16
Data Base Explorer abbreviations
« on: September 09, 2011, 11:58:26 AM »
my friends:
 I would like to inform the meaning of the abbreviations in the Data Base Explorer as an example: P4, P3, PT, PS, PN, PM, LK, CN, PM ETC as a couple that I may have some information. There are over 50 abbreviations that you can not know what it is and the manual is silent.
 thank you very much.
leonard

bindeaw

  • New Member
  • *
  • Posts: 1
Re: Data Base Explorer abbreviations
« Reply #1 on: November 16, 2011, 03:42:54 PM »
I don't understand too.

RodBearden

  • Hero Member
  • *****
  • Posts: 8781
    • Rod's RadarBox Downloads
Re: Data Base Explorer abbreviations
« Reply #2 on: November 16, 2011, 05:51:36 PM »
Here's all that I know:

Aircraft Table:

MS - Mode-S Code
AR - Aircraft Registration
AT - Aircraft Type (ICAO Code)
AN - Aircraft Name (make and model)
AC - Aircraft Company (Owner)
CN - Constructor's Number / Line Number)
PT - Photographer (first)
LK - Link to first photo
PT2 - Photographer (second)
LK2 - Link to second photo
CO - ???

Actype Table (Table not currently used):

AT - Aircraft Type (ICAO Code)
AN - Aircraft Name (make and model)
AG - Aircraft Group (landplane, amphibian, helicopter etc)

Airlines Table:

CN - Company (airline/operator) name
C3 - ICAO Code
CM - Company Type (not used)
C2 - IATA Code

Airports Table:

P4 - ICAO Code
P3 - IATA Code
PN - Airport Name
PC - Airport name again (?) - don't know how these are used
PS - ?
PT - Country
PM - ?
PA - Centrepoint Latitude
PO - Centrepoint Longitude (used for route lines)

Routes Table:
FN - Flight Number
NO - Origin Airport ICAO Code
ND - Destination Airport (ICAO Code)
NV - Via Airport (ICAO Code)
CH - Date and time record was changed (data will be refreshed 6 months after this date when flight is received again)

I hope someone can fill in my unknowns and correct my mistakes!

Rod
« Last Edit: November 16, 2011, 07:52:16 PM by RodBearden »
Rod

Runway 31

  • Moderator
  • Hero Member
  • *****
  • Posts: 32034
Re: Data Base Explorer abbreviations
« Reply #3 on: November 16, 2011, 07:26:21 PM »
In the aircraft table CO = company/owner/operator

Alan

RodBearden

  • Hero Member
  • *****
  • Posts: 8781
    • Rod's RadarBox Downloads
Re: Data Base Explorer abbreviations
« Reply #4 on: November 16, 2011, 07:30:15 PM »
Alan - what's the difference between CO and AC, then?

Rod
Rod

Runway 31

  • Moderator
  • Hero Member
  • *****
  • Posts: 32034
Re: Data Base Explorer abbreviations
« Reply #5 on: November 16, 2011, 07:49:46 PM »
Sorry Rod, we use CO in the updater, I presumed they were the same but having looked in d/b explorer after you asked and  having not noted AC in your list, obviously not. Havent a clue what it is for.

BTW good compilation

Alan

RodBearden

  • Hero Member
  • *****
  • Posts: 8781
    • Rod's RadarBox Downloads
Re: Data Base Explorer abbreviations
« Reply #6 on: November 16, 2011, 07:57:23 PM »
Ah well, thanks anyway, Alan.

Rod
Rod

Bell 407

  • Full Member
  • ***
  • Posts: 124
Re: Data Base Explorer abbreviations
« Reply #7 on: November 19, 2011, 10:32:44 AM »
It's interesting to note that the Airports Table is the only table with the headers in lowercase. All the other tables have their headers in UPPERCASE?