Fly!2 Database Mini-Tutorials

[Guest Rob Westhouse]

:+Here are a few links to information about the Fly! databases. For each utility program listed, be sure to check for updated versions. The links listed should be the latest as of March 1, 2002. Each utility will contain documentation. Read it to learn how they are used. For those authors who created these utilities, it would help if they contacted the library manager to have old redundent versions removed.Be sure you are patched up to the latest .230 version of Fly! In the runway database (all databases are found in the Fly! system folder) new approach lighting has been added. Check the AVSIM Fly! II Patches library for Updates. I hope to have a visual tutorial on that sometime in the future.Before fooling with the databases, make a backup of all original databases.For Fly! 1.0, but this tutorial contains some useful informationFLY Database Howto by Emiliano Gomes Padilhahttp://ftp.avsim.com/library/sendfile.php?DownloadID=5905Quick Database Tutorial by Marty Shultzhttp://www.science.widener.edu/~schultz/fly/dbedit.htmlDexImport Version 1.2 by Frank RacisDexImport imports Database Export (DEX) files into Fly2. DEX files are used for adding and moving runways, airports, and navaids, among other things. Version 1.2 adds support for deleting objects and fixes a few bugs.http://ftp.avsim.com/library/sendfile.php?DownloadID=12835Vol!Edit New version 1.1http://ftp.avsim.com/library/sendfile.php?DownloadID=13141Vol!Edit is a tool for Fly! to edit, create and modify DEX files. You can have visualise the contains of files as Airport, Navaid, ILS, Com, Runway, Waypoint. With VolEdit you do not need to use Podview and do not need to extract files from POD to create DEX. Vol!Edit has been tested since six month by the french team of ROTW. New version for Fly! 1 and Fly! 2.The following document was part of the Fly! 1.0 documentation in the Howto Folder. For Fly! 2.0, additional fields have been added.################################################################################################################## AIRPORT.DBD -- Field Values#################################################################################################################--------------------------------------------------------Airport Type (add values together for combined types)--------------------------------------------------------Unknown = 0Airport = 2Heliport = 4Seaplane Base = 8Balloonport = 16Gliderport = 32Stolport = 64Ultralight = 128--------------------------------------------------------Airport Ownership (one value only)--------------------------------------------------------Unknown = 0Public = 1Private = 2Air Force = 3Navy = 4Army = 5--------------------------------------------------------Airport Usage (one value only)--------------------------------------------------------Unknown = 0Public = 1Private = 2--------------------------------------------------------Airport Frame Service (one value only)--------------------------------------------------------Unknown = 0None = 1Minor = 2Major = 3--------------------------------------------------------Airport Engine Service (one value only)--------------------------------------------------------Unknown = 0None = 0Minor = 1Major = 2--------------------------------------------------------Airport Oxygen (one value only)--------------------------------------------------------Unknown = 0None = 1Low = 2High = 3HighLow = 4--------------------------------------------------------Airport Beacon Lens Color (one value only)--------------------------------------------------------Unknown = 0None = 1ClearGreen = 2ClearYellow = 3ClearGreenYellow = 4SplitClearGreen = 5Yellow = 6Green = 7--------------------------------------------------------Airport Region (one value only)--------------------------------------------------------Unknown = 0FAA Alaska = 1FAA Central = 2FAA Eastern = 3FAA GreatLakes = 4FAA International = 5FAA NewEngland = 6FAA NorthwestMountain = 7FAA Southern = 8FAA Southwest = 9FAA WesternPacific = 10--------------------------------------------------------Airport Fuel Types (add values together for combined types)--------------------------------------------------------Unknown = 080 = 2100 = 4100LL = 8115 = 16JetA = 32JetA1 = 64JetA1Plus = 128JetB = 256JetBPlus = 512Automotive = 1024--------------------------------------------------------Airport Based Aircraft (add values togther for combined types)--------------------------------------------------------Unknown = 0SingleEngine = 2MultiEngine = 4JetEngine = 8Helicopter = 16Gliders = 32Military = 64Ultralight = 128--------------------------------------------------------Airport Schedule Month (add values together for combined types; add together with Day and Range values below)--------------------------------------------------------January = 2February = 4March = 8April = 16May = 32June = 64July = 128August = 256September = 512October = 1024November = 2048December = 4096--------------------------------------------------------Airport Schedule Day (add values together for combined types; add together with Month and Range values)--------------------------------------------------------Sunday = 65536Monday = 131072Tuesday = 262144Wednesday = 524288Thursday = 1048576Friday = 2097152Saturday = 4194304--------------------------------------------------------Airport Schedule Range (add values together for combined types; add together with Month and Day values)--------------------------------------------------------AllDay = 268435456Specific Time = 536870912Sunrise = 1073741824Sunset = 2147483648--------------------------------------------------------Airport Lighting Control (add values together for combines types)--------------------------------------------------------24 Hours = 2ATC Controlled = 4Radio Controlled = 8Radio Required = 16Phone Required = 32--------------------------------------------------------Airport Airspace (one value only)--------------------------------------------------------Class A = 1Class B = 2Class C = 3Class D = 4Class E = 5Class G = 6################################################################################################################## RUNWAY.DBD -- Field Values#################################################################################################################--------------------------------------------------------Runway Edge Light Intensity (one value only)--------------------------------------------------------Unknown = 0Low = 1Medium = 2High = 3--------------------------------------------------------Runway Traffic Pattern (one value only)--------------------------------------------------------Unknown = 0Right = 'R'Left = 'L'--------------------------------------------------------Runway Marking Type (one value only)--------------------------------------------------------Unknown = 0None = 0Basic = 1Buoy = 2NPI = 4NumbersOnly = 5NonStandard = 6PIR = 7STOL = 8--------------------------------------------------------Runway Visual Range (add values together for combined types)--------------------------------------------------------None = 0Touchdown = 1Midfield = 2Rollout = 4--------------------------------------------------------Runway Light System (one value only)--------------------------------------------------------Unknown = 0None = 0Pilot Controlled = 1Sequenced Flashing = 2Touchdown Zone = 3Centerline = 4High Intensity Edge = 5Medium Intensity Edge = 6Low Intensity Edge = 7Alignment = 8Runway End = 9A = 10ALSF2 = 10A1 = 11ALSAF = 11ALSF1 = 11A2 = 12SALS = 12SSALF = 12A3 = 13SSALR = 13A4 = 14MALS = 14MALSF = 14SSALS = 14SALSF = 14A5 = 15MALSR = 15AF = 16AI = 17B = 18BE = 19BG = 20BF = 21BN = 22BO = 23BP = 24BQ = 25BR = 26BS = 27C = 28Neon = 28D = 29E = 30F = 31I = 32MILOVRN = 32J = 33M = 34N = 35O = 36Q = 37S = 38T = 39U = 40X = 41ODALS = 42V = 43VASI = 43VA = 44V1 = 45TVASI = 45V2 = 46PVASI = 46V3 = 47V4 = 48VT = 48V5 = 49VL = 49P = 50PAPI = 50OLS = 51WaveOff = 52Portable = 53FloodLights = 54Generic = 55LCVASI = 56--------------------------------------------------------Runway Glideslope Configuration (one value only)--------------------------------------------------------Default = 01 Light = 12 Lights = 23 Lights = 34 Lights = 46 Lights = 612 Lights = 1216 Lights = 16--------------------------------------------------------Runway Glideslope Location--------------------------------------------------------Unknown = 0Left = 'L'Right = 'R'Both = 'B'--------------------------------------------------------Runway Pavement Type--------------------------------------------------------Pavement Rigid = 'R',Pavement Flexible = 'F'--------------------------------------------------------Runway Condition (one value only)--------------------------------------------------------Unknown = 0Poor = 1Fair = 2Good = 3--------------------------------------------------------Runway Surface Type (add values for combined types)--------------------------------------------------------kTypeUnknown = 0kTypeConcrete = 1kTypeAsphalt = 2kTypeTurf = 4kTypeDirt = 8kTypeGravel = 16kTypeMetal = 32kTypeSand = 64kTypeWood = 128kTypeWater = 256kTypeMats = 512kTypeSnow = 1024kTypeIce = 2048kTypeBrick = 4096kTypeGrooved = 1073741824kTypeTreated = 2147483648--------------------------------------------------------Runway Subgrade Strength (one value only) --------------------------------------------------------Unknown = 0High = 1Medium = 2Low = 4UltraLow = 8--------------------------------------------------------Runway Tire PSI (one value only) --------------------------------------------------------PSI Unknown = 0PSI High = 1PSI Medium = 2PSI Low = 4PSI Very Low = 8--------------------------------------------------------Runway Pilot Controlled Lighting--------------------------------------------------------No = 0Yes = 1################################################################################################################## NAVAID.DBD -- Field Values#################################################################################################################--------------------------------------------------------Navaid Magnetic Variation--------------------------------------------------------Actual magnetic variation, in +/- fractional degrees--------------------------------------------------------Navaid Slaved Variation--------------------------------------------------------The slaved variation is the variation Fly! will actuallyuse in place of magnetic variation. The FAA or airauthority may slave a VOR to the nearest whole degreeor other angle. Also stored in +/- fractional degrees.--------------------------------------------------------Navaid Type (add values together for shared attributes, suchas VOR/DME, etc.)--------------------------------------------------------VOR = 1TACAN = 4NDB = 8DME = 16Locator = 32Localizer = 64Glideslope = 128Back Course Marker = 256Inner Marker = 512Middle Marker = 1024Outer Marker = 2048Waypoint = 4096VOT = 8192--------------------------------------------------------Navaid Class (one value only)--------------------------------------------------------Unknown = 0High = 1Low = 2Terminal = 3Medium Homing = 4High Homing = 5Anticipated = 6--------------------------------------------------------Navaid Usage (one value only)--------------------------------------------------------Unknown = 0High = 1Low = 2Both = 3Terminal = 4High Alt RNAV = 5--------------------------------------------------------Navaid Power (watts)--------------------------------------------------------In watts of power--------------------------------------------------------Navaid Range (NM)--------------------------------------------------------In nautical miles. Fly! automatically will calculaterange based on type/class for major navaid types (VOR,NDB, etc.)################################################################################################################## ILS.DBD -- Field Values#################################################################################################################--------------------------------------------------------ILS Component Type (add values for combined types, though LOC/DMEshould be the only combined type used for now.)--------------------------------------------------------DME = 16Locator = 32Localizer = 64Glideslope = 128Back Course Marker = 256Inner Marker = 512Middle Marker = 1024Outer Marker = 2048--------------------------------------------------------ILS Glideslope Angle--------------------------------------------------------In +/- fractional degrees################################################################################################################## COMM.DBD -- Field Values#################################################################################################################--------------------------------------------------------COMM Type(add values together for combined services)--------------------------------------------------------Unknown = 0Tower = 1Clearance Delivery = 2Ground Control = 4Approach Control = 8Departure Control = 16Flight Service Station = 32Center = 64ATIS = 128CTAF = 256Multicom = 512Emergency = 1024################################################################################################################## WAYPOINT.DBD -- Field Values#################################################################################################################--------------------------------------------------------Waypoint At Navaid--------------------------------------------------------Not Co-Located = 0Co-Located = 1--------------------------------------------------------Waypoint Type (one value only)--------------------------------------------------------Unnamed = 1NDB = 2Named = 4Off Route = 8--------------------------------------------------------Waypoint Usage (one value only)--------------------------------------------------------Unknown = 0High = 1Low = 2Both = 3Terminal = 4High Alt RNAV = 5--------------------------------------------------------Waypoint Bearing To Navaid--------------------------------------------------------In +/- fractional degrees################################################################################################################## OBSTRUCT.DBD -- Field Values#################################################################################################################--------------------------------------------------------Obstruction Type--------------------------------------------------------Tower = 1Pole = 2--------------------------------------------------------Obstruction Strobe--------------------------------------------------------Currently unused -- tower and poles are randomly seededwith strobe values.--------------------------------------------------------Obstruction Frequency--------------------------------------------------------Currently unused -- tower and poles are randomly seededwith strobe frequency.

[jkanold 0]

This thread is a keeper.http://members.rogers.com/jkanold/jimlogo.gifhttp://members.rogers.com/eelvish/flyurl.gif

[Guest Rob Westhouse]

Here are some .gif images of the various approach lighting systems for the Runway Light System field. The diagrams are appoximate and not to scale.(230 Patch) If anyone notices errors, let me know...Runway Light System (one value only)

http://www.members.shaw.ca/fly2/images/App...Lighting/09.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/10.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/11.gif----------http://www.members.shaw.ca/fly2/images/App...hting/12&14.gif----------http://www.members.shaw.ca/fly2/images/App...hting/13&15.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/17.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/18.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/20.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/21.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/22.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/23.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/24.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/27.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/30.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/31.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/33.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/34.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/35.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/36.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/37.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/38.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/39.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/40.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/41.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/42.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/43.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/46.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/47.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/48.gif----------http://www.members.shaw.ca/fly2/images/App...Lighting/50.gif

http://members.shaw.ca/fly2/images/snoopyace.gifRob Westhouse, VE5VKSaskatoon, Saskatchewan, Canada"Land of Living Skies"

[RandallR 444]

I would recommend the inclusion of these posts by Rob and Rich as being more fodder for this thread:http://ftp.avsim.com/cgi-bin/dcforum/dcboa...rum=DCForumID19