Profile views

In the Aeronautical Solution, profile views are composed of related graphic elements. The Instrument Approach Profile View tool creates these graphic elements based on data contained in the Aeronautical Information System (AIS).

Preparing the database for creating profile views

To create a profile view, the production database must be populated with the appropriate data.

The tables below (feature classes, attributed relationship classes, or stand-alone tables) and attributes must be present in the database for the Instrument Approach Profile View tool to function.

If an attribute is described as "required," it must be populated.

NavaidSystem

AIS Field

Description

Required

GFID

Unique identifier of a NavaidSystem feature

Y

Subtype_Code

Subtype of navaid system; used to determine whether to include the ILS/MLS feather symbol for the final approach segment

N

Ident_Txt

Identifier of the navaid system; used to label the navaid on the profile

N

NavaidSystem
TerminalProcedure

AIS Field

Description

Required

GFID

Unique identifier of a TerminalProcedure record

Y

ClientKey_ID

Client key for terminal procedures; used in the Select Procedure dialog box

Y

ADHP_Id

Gives the GFID of the airport at which the procedure exists

Y

TransitionLevel_Val

Transition level of the procedure; displayed at the top of the profile view if present

N

TransitionAlt_Val

Transition altitude of the procedure; displayed at the top of the profile view if present

N

ApproachCourse_Val

Final heading of the procedure; used to determine the drawing direction of the profile (left- to-right versus right-to-left) (The determination is made with consideration to the magnetic variation of the airport.)

Y

TerminalProcedure
ADHPThresholdProcedure

AIS Field

Description

Required

ADHPThreshold_Id

Gives the GFID of a runway threshold related to the procedure; used to relate thresholds to procedures

Y

TerminalProcedure_Id

Gives the GFID of the related procedure; used to relate thresholds to procedures

Y

ADHPThresholdProcedure
ADHPThreshold

AIS Field

Description

Required

GFID

Unique identifier of a runway threshold

Y

MagBearing_Val

Gives the heading of the runway at the threshold

Y

ADHPSurfaceArea_Id

Gives the GFID of the runway on which the threshold exists

Y

Designator_Txt

Designator of the threshold

N

ADHPThreshold
ADHPSurfaceArea

AIS Field

Description

Required

GFID

Unique identifier of the runway

Y

Length_Val

Gives the length of the runway

N

ADHPSurfaceArea
ADHP

AIS Field

Description

Required

GFID

Unique identifier of the airport

Y

Name_Txt

Name of the airport; used in the Select Procedure dialog box

Y

MagneticVariation_Val

Used in combination with TerminalProcedure::ApproachCourse_Val to determine the drawing direction of the profile (left-to-right versus right-to-left)

N

ADHP
DesignatedPoint

AIS Field

Description

Required

GFID

Unique identifier of the DesignatedPoint feature

Y

Ident_Txt

Identifier of the designated point; used to label the designated point on the profile

N

DesignatedPoint
DesigPoint_NavaidAssoc

AIS Field

Description

Required

DesignatedPoint_Id

Gives the GFID of a designated point; used to relate designated points and navaid systems

N

NavaidSystem_Id

Gives the GFID of a navaid system; used to relate designated points and navaid systems

N

Distance_Val

Gives the distance between a designated point and its related navaid system; used to generate the DME distances shown on the profile

N

DesigPoint_NavaidAssoc
ProcedureLegPoint

AIS Field

Description

Required

GFID

Unique identifier of the procedure leg point (the initial fix of the procedure)

Y

TerminalProcedure_Id

Gives the GFID of the related procedure; used to relate the procedure leg point to the terminal procedures record

Y

ReferencePointClass_Code

Code indicating the type of point at which the procedure leg point (IF) exists (Classes include airport, threshold, designated point, and navaid system.)

Y

ReferencePoint_Id

Gives the GFID of the reference point

Y

TypeProc_Code

Gives the type of procedure (SID, STAR, IAP) of which the leg is a part; used to determine whether the procedure should be included in the Selection dialog box

Y

TransitionIdent_Txt

Gives the name of the transition to which the procedure leg point belongs

Y

NumSeq_Val

Sequence number of the leg (For ProcedureLegPoint, this should always be the lowest value [1 or 10], since procedure leg points always represent the beginning of a transition.)

Y

DescrDistVert_Code

Describes the altitude value at the start of the procedure; used for over/underlining the elevation values (e.g., At or Above)

N

DistVertLower_UOM

Unit of measure for the altitude at the start of the procedure

N

DistVertLower_Val

Gives the altitude at the start of the procedure

N

DistVertUpper_UOM

Unit of measure for the altitude at the start of the procedure

N

DistVertUpper_Val

Gives the altitude at the start of the procedure

N

ChartProfile_Code

Used to determine whether the transition is included in the profile

N

ProcedureLegPoint
ProcLegPt_NavSysAssoc

AIS Field

Description

Required

ProcedureLegPoint_Id

Gives the GFID of a procedure leg point; used to relate procedure leg points to navaid systems

Y

NavaidSystem_Id

Gives the GFID of a navaid system; used to relate procedure leg points to navaid systems

Y

Distance_Val

Distance from a procedure leg point to the related navaid (DME distance)

Y

PrimaryNavaidSystem_Code

Indicates whether the related navaid is the primary navaid

Y

ProcLegPt_NavSysAssoc
ProcedureLeg

AIS Field

Description

Required

GFID

Unique identifier of the procedure leg

Y

TransitionIdent_Txt

Gives the name of the transition to which the procedure leg belongs

Y

TypeProc_Code

Gives the type of procedure (SID, STAR, IAP) of which the leg is a part; used to determine whether the procedure should be included in the Selection dialog box

Y

TerminalProcedure_Id

Gives the GFID of the related procedure; used to relate the procedure leg to the terminal procedures record

Y

NumSeq_Val

Sequence number of the procedure leg. (A sequence that follows 20, 30, 40 and so on, or a similar pattern, is recommended so that new legs can be inserted and given an intermediate sequence number, like 35. However, the tool will honor any numerical sequence that is used.)

Y

RoleFix_Code

Coded value describing the role of the waypoint at the end of the procedure leg; used to determine how the waypoint and procedure leg are drawn in the profile

Y

DescrDistVert_Code

Describes the altitude value at the end of the procedure leg; used for over/underlining the elevation values (e.g., At or Above)

N

DistVertLower_UOM

Unit of measure for the altitude at the start of the procedure

N

DistVertLower_Val

Gives the altitude at the start of the procedure

N

DistVertUpper_UOM

Unit of measure for the altitude at the start of the procedure

N

DistVertUpper_Val

Gives the altitude at the start of the procedure

N

ReferencePointClass_Code

Code indicating the type of point at the end of the procedure leg (Classes include airport, threshold, designated point, and navaid system.)

Y

ReferencePoint_Id

Gives the GFID of the reference point

Y

VerticalAngle_Val

Vertical angle of the procedure leg

N

Type_Code

Code describing the type of procedure leg; defines how the leg will be drawn in the profile

Y

Dist_Val

Length of the procedure leg: distance from reference point (endpoint) to endpoint of previous leg (or IF for the first leg) (This distance is shown in the tray below the profile.)

Y

Course_Val

Direction of the procedure leg; used to label the procedure leg with the bearing

Y

Remarks_Txt

Remarks on procedure leg; shown as remarks for each procedure leg in profile view

N

ThresholdCrossingHeight_Val

Value of threshold crossing height

N

ProcedureLeg
ProcLeg_NavSysAssoc

AIS Field

Description

Required

ProcedureLeg_Id

Gives the GFID of a procedure leg; used to relate procedure legs to navaid systems

Y

NavaidSystem_Id

Gives the GFID of a navaid system; used to relate procedure legs to navaid systems

Y

Distance_Val

Distance from a procedure leg to the related navaid (DME distance)

Y

PrimaryNavaidSystem_Code

Indicates whether the related navaid is the primary navaid

Y

ProcLeg_NavSysAssoc
MissedApproachProc_C

AIS Field

Description

Required

Procedure_Id

Gives the GFID of a terminal procedure record; used to relate a terminal procedure to the MissedApproachProc_C record

N

MAProcedure_Code

Missed Approach Procedure Code; used to determine the symbology used in the Missed Approach Box in the profile view

N

TopLabel_Txt

Text to be drawn in the top portion of the Missed Approach box in the profile view

N

BottomLabel_Txt

Text to be drawn in the bottom portion of the Missed Approach box in the profile view

N

MissedApproachProc_C

Related Topics


7/31/2012