Home Free Reports and Queries   Fee Based Services   Database Description   Database Access

Home

Table description for FACILITY RUNWAY DATA in subject area AIRPORT

FACILITY_RUNWAY_DATA

Primary key: AIRPORT_IDENTIFIER, RUNWAY_IDENTIFIER
Indexes Number of rows: 22,604
Comment
      Runway information

COLUMN NAMEDATA TYPELENGTHPRECISIONNULLABLECOMMENT
RECORD_TYPEvarchar30YESRECORD TYPE
AIRPORT_IDENTIFIERvarchar110NOAIRPORT IDENTIFIER
RUNWAY_IDENTIFIERvarchar70NORUNWAY IDENTIFIER
RUNWAY_LENGTHnumeric100YESRUNWAY LENGTH
RUNWAY_WIDTHnumeric100YESRUNWAY WIDTH
RUNWAY_SURFACE_TYPEvarchar120YESRUNWAY SURFACE TYPE
RUNWAY_SURFACE_TREATMENTvarchar50YESRUNWAY SURFACE TREATMENT
PAVEMENT_CLASSIFICATION_NUMvarchar110YESPAVEMENT CLASSIFICATION NUMBER
RUNWAY_LIGHTS_EDGE_INTENSITYvarchar50YESRUNWAY LIGHTS EDGE INTENSITY
BASE_END_IDENTIFIERvarchar30YESBASE END IDENTIFIER
BASE_ILSvarchar100YESBASE INSTRUMENT LANDING SYSTEM TYPE
BASE_RH_LANDING_PATTERNvarchar10YESBASE RIGHT HAND TRAFFIC PATTERN FOR LANDING AIRCRAFT
BASE_RUNWAY_MARKINGS_TYPEvarchar50YESBASE RUNWAY MARKINGS TYPE
BASE_RUNWAY_MARKINGS_CONDvarchar10YESBASE RUNWAY MARKINGS CONDITION
BASE_AIRCRAFT_ARRESTING_DEVvarchar60YESBASE TYPE OF AIRCRAFT ARRESTING DEVICE
BASE_THRESHOLD_CROSSING_HIGHTvarchar30YESBASE THRESHOLD CROSSING HIGHT
BASE_VISUAL_GLIDE_PATH_ANGLEvarchar40YESBASE VISUAL GLIDE PATH ANGLE
BASE_VISUAL_GLIDE_SLOPE_INDvarchar50YESBASE VISUAL GLIDE SLOPE INDICATORS
BASE_RUNWAY_VISUAL_RANGE_EQPvarchar30YESBASE RUNWAY VISUAL RANGE EQUIPMENT
BASE_RUNWAY_VISIBILITY_EQUIPvarchar10YESBASE RUNWAY VISIBILITY VALUE EQUIPMENT
BASE_APPROACH_LIGHT_SYSTEM_varchar80YESBASE APPROACH LIGHT SYSTEM
BASE_RUNWAY_END_ID_LIGHTSvarchar10YESBASE RUNWAY END IDENTIFIER LIGHTS AVAILABILITY
BASE_RUNWAY_CENTERLINE_LIGHTSvarchar10YESBASE RUNWAY CENTERLINE LIGHTS AVAILABLITY
BASE_RUNWAY_END_TD_LIGHTSvarchar10YESBASE RUNWAY END TOUCHDOWN LIGHTS AVAILABILITY
BASE_FAR_PART_77_RUNWAY_CATvarchar50YESBASE FAA FAR PART 77 RUNWAY CATEGORY
RECIP_END_IDENTIFIERvarchar30YESRECIPROCAL END IDENTIFIER
RECIP_ILSvarchar100YESRECIPROCAL INSTRUMENT LANDING SYSTEM TYPE
RECIP_RH_LANDING_PATTERNvarchar10YESRECIPROCAL RIGHT HAND TRAFFIC PATTERN FOR LANDING AIRCRAFT
RECIP_RUNWAY_MARKINGS_TYPEvarchar50YESRECIPROCAL RUNWAY MARKINGS TYPE
RECIP_RUNWAY_MARKINGS_CONDvarchar10YESRECIPROCAL RUNWAY MARKINGS CONDITION
RECIP_AIRCRAFT_ARRESTING_DEVvarchar60YESRECIPROCAL TYPE OF AIRCRAFT ARRESTING DEVICE
RECIP_THRESHOLD_CROSSING_HGTvarchar30YESRECIPROCAL THRESHOLD CROSSING HEIGHT
RECIP_VISUAL_GLIDE_PATH_ANGLEvarchar40YESRECIPROCAL VISUAL GLIDE PATH ANGLE
RECIP_APPROACH_SLOPE_IND_EQUIPvarchar50YESRECIPROCAL APPROACH SLOPE INDICATOR EQUIPMENT
RECIP_RUNWAY_VISUAL_RANGE_EQPvarchar30YESRECIPROCAL RUNWAY VISUAL RANGE EQUIPMENT
RECIP_RUNWAY_VISIBILITY_EQUIPvarchar10YESRECIPROCAL RUNWAY VISIBILITY VALUE EQUIPMENT
RECIP_APPROACH_LIGHT_SYSTEMvarchar80YESRECIPROCAL APPROACH LIGHT SYSTEM
RECIP_RUNWAY_END_ID_LIGHTSvarchar10YESRECIPROCAL RUNWAY END IDENTIFIER LIGHTS AVAILABILITY
RECIP_RUNWAY_CENTER_LIGHTSvarchar10YESRECIPROCAL RUNWAY CENTERLINE LIGHTS AVAILABILITY
RECIP_RUNWAY_TOUCHDOWN_LIGHTSvarchar10YESRECIPROCAL RUNWAY END TOUCHDOWN LIGHTS AVAILABILITY
RECIP_FAR_PART_77_RUNWAY_CATvarchar50YESRECIPROCAL FAA FAR PART 77 RUNWAY CATEGORY
ADDED_TIMESTAMPtimestamp80NO 
MODIFIED_TIMESTAMPtimestamp80YES 



Legal Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved Contact Us