Name: Runway Ends Table

Display Field: EFF_DATE

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: The Runway Ends Table dataset is updated every 28 days from the Federal Aviation Administration (FAA) and is part of the U.S. Department of Transportation (USDOT)/Bureau of Transportation Statistics (BTS) National Transportation Atlas Database (NTAD). The Runways database contains runways in the United States and US territories with information on the physical characteristics of the runways. Not all runways in this dataset have geospatial locations associated with them, as this is not a required data element from the airport source. As a result, this database contains a polyline layer, a points layer and a table. The polyline layer contains runways that had corresponding runways ends. The points layer contains mostly heliports, but also non-linear landing areas. The table contains runways where geospatial information was not reported. The runways in the database are associated with the airports dataset on NTAD, showing runways for all official and operational aerodromes. This geospatial data is derived from the FAA's National Airspace System Resource Aeronautical Data.

Copyright Text: This NTAD dataset is a work of the United States government as defined in 17 U.S.C. § 101 and as such are not protected by any U.S. copyrights. This work is available for unrestricted public use.

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• EFF_DATE (type: esriFieldTypeString, alias: EFF_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SITE_NO (type: esriFieldTypeString, alias: SITE_NO, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• SITE_TYPE_CODE (type: esriFieldTypeString, alias: SITE_TYPE_CODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• STATE_CODE (type: esriFieldTypeString, alias: STATE_CODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ARPT_ID (type: esriFieldTypeString, alias: ARPT_ID, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• COUNTRY_CODE (type: esriFieldTypeString, alias: COUNTRY_CODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RWY_ID (type: esriFieldTypeString, alias: RWY_ID, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• RWY_END_ID (type: esriFieldTypeString, alias: RWY_END_ID, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• TRUE_ALIGNMENT (type: esriFieldTypeInteger, alias: TRUE_ALIGNMENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ILS_TYPE (type: esriFieldTypeString, alias: ILS_TYPE, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• RIGHT_HAND_TRAFFIC_PAT_FLAG (type: esriFieldTypeString, alias: RIGHT_HAND_TRAFFIC_PAT_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• RWY_MARKING_TYPE_CODE (type: esriFieldTypeString, alias: RWY_MARKING_TYPE_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• RWY_MARKING_COND (type: esriFieldTypeString, alias: RWY_MARKING_COND, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• RWY_END_LAT_DEG (type: esriFieldTypeInteger, alias: RWY_END_LAT_DEG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LAT_MIN (type: esriFieldTypeInteger, alias: RWY_END_LAT_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LAT_SEC (type: esriFieldTypeDouble, alias: RWY_END_LAT_SEC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LAT_HEMIS (type: esriFieldTypeString, alias: RWY_END_LAT_HEMIS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LAT_DECIMAL (type: esriFieldTypeDouble, alias: LAT_DECIMAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LONG_DEG (type: esriFieldTypeInteger, alias: RWY_END_LONG_DEG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LONG_MIN (type: esriFieldTypeInteger, alias: RWY_END_LONG_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LONG_SEC (type: esriFieldTypeDouble, alias: RWY_END_LONG_SEC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_LONG_HEMIS (type: esriFieldTypeString, alias: RWY_END_LONG_HEMIS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LONG_DECIMAL (type: esriFieldTypeDouble, alias: LONG_DECIMAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_ELEV (type: esriFieldTypeDouble, alias: RWY_END_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• THR_CROSSING_HGT (type: esriFieldTypeInteger, alias: THR_CROSSING_HGT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VISUAL_GLIDE_PATH_ANGLE (type: esriFieldTypeDouble, alias: VISUAL_GLIDE_PATH_ANGLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LAT_DEG (type: esriFieldTypeInteger, alias: DISPLACED_THR_LAT_DEG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LAT_MIN (type: esriFieldTypeInteger, alias: DISPLACED_THR_LAT_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LAT_SEC (type: esriFieldTypeDouble, alias: DISPLACED_THR_LAT_SEC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LAT_HEMIS (type: esriFieldTypeString, alias: DISPLACED_THR_LAT_HEMIS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LAT_DISPLACED_THR_DECIMAL (type: esriFieldTypeDouble, alias: LAT_DISPLACED_THR_DECIMAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LONG_DEG (type: esriFieldTypeInteger, alias: DISPLACED_THR_LONG_DEG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LONG_MIN (type: esriFieldTypeInteger, alias: DISPLACED_THR_LONG_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LONG_SEC (type: esriFieldTypeDouble, alias: DISPLACED_THR_LONG_SEC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LONG_HEMIS (type: esriFieldTypeString, alias: DISPLACED_THR_LONG_HEMIS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• LONG_DISPLACED_THR_DECIMAL (type: esriFieldTypeDouble, alias: LONG_DISPLACED_THR_DECIMAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_ELEV (type: esriFieldTypeDouble, alias: DISPLACED_THR_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISPLACED_THR_LEN (type: esriFieldTypeInteger, alias: DISPLACED_THR_LEN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TDZ_ELEV (type: esriFieldTypeDouble, alias: TDZ_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VGSI_CODE (type: esriFieldTypeString, alias: VGSI_CODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• RWY_VISUAL_RANGE_EQUIP_CODE (type: esriFieldTypeString, alias: RWY_VISUAL_RANGE_EQUIP_CODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• RWY_VSBY_VALUE_EQUIP_FLAG (type: esriFieldTypeString, alias: RWY_VSBY_VALUE_EQUIP_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• APCH_LGT_SYSTEM_CODE (type: esriFieldTypeString, alias: APCH_LGT_SYSTEM_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• RWY_END_LGTS_FLAG (type: esriFieldTypeString, alias: RWY_END_LGTS_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CNTRLN_LGTS_AVBL_FLAG (type: esriFieldTypeString, alias: CNTRLN_LGTS_AVBL_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TDZ_LGT_AVBL_FLAG (type: esriFieldTypeString, alias: TDZ_LGT_AVBL_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• OBSTN_TYPE (type: esriFieldTypeString, alias: OBSTN_TYPE, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• OBSTN_MRKD_CODE (type: esriFieldTypeString, alias: OBSTN_MRKD_CODE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• FAR_PART_77_CODE (type: esriFieldTypeString, alias: FAR_PART_77_CODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• OBSTN_CLNC_SLOPE (type: esriFieldTypeInteger, alias: OBSTN_CLNC_SLOPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBSTN_HGT (type: esriFieldTypeInteger, alias: OBSTN_HGT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIST_FROM_THR (type: esriFieldTypeInteger, alias: DIST_FROM_THR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CNTRLN_OFFSET (type: esriFieldTypeInteger, alias: CNTRLN_OFFSET, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CNTRLN_DIR_CODE (type: esriFieldTypeString, alias: CNTRLN_DIR_CODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• RWY_GRAD (type: esriFieldTypeString, alias: RWY_GRAD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RWY_GRAD_DIRECTION (type: esriFieldTypeString, alias: RWY_GRAD_DIRECTION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RWY_END_PSN_SOURCE (type: esriFieldTypeString, alias: RWY_END_PSN_SOURCE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RWY_END_PSN_DATE (type: esriFieldTypeString, alias: RWY_END_PSN_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RWY_END_ELEV_SOURCE (type: esriFieldTypeString, alias: RWY_END_ELEV_SOURCE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RWY_END_ELEV_DATE (type: esriFieldTypeString, alias: RWY_END_ELEV_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DSPL_THR_PSN_SOURCE (type: esriFieldTypeString, alias: DSPL_THR_PSN_SOURCE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RWY_END_DSPL_THR_PSN_DATE (type: esriFieldTypeString, alias: RWY_END_DSPL_THR_PSN_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DSPL_THR_ELEV_SOURCE (type: esriFieldTypeString, alias: DSPL_THR_ELEV_SOURCE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RWY_END_DSPL_THR_ELEV_DATE (type: esriFieldTypeString, alias: RWY_END_DSPL_THR_ELEV_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TDZ_ELEV_SOURCE (type: esriFieldTypeString, alias: TDZ_ELEV_SOURCE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RWY_END_TDZ_ELEV_DATE (type: esriFieldTypeString, alias: RWY_END_TDZ_ELEV_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TKOF_RUN_AVBL (type: esriFieldTypeInteger, alias: TKOF_RUN_AVBL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TKOF_DIST_AVBL (type: esriFieldTypeInteger, alias: TKOF_DIST_AVBL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ACLT_STOP_DIST_AVBL (type: esriFieldTypeInteger, alias: ACLT_STOP_DIST_AVBL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LNDG_DIST_AVBL (type: esriFieldTypeInteger, alias: LNDG_DIST_AVBL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAHSO_ALD (type: esriFieldTypeInteger, alias: LAHSO_ALD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RWY_END_INTERSECT_LAHSO (type: esriFieldTypeString, alias: RWY_END_INTERSECT_LAHSO, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• LAHSO_DESC (type: esriFieldTypeString, alias: LAHSO_DESC, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• LAHSO_LAT (type: esriFieldTypeString, alias: LAHSO_LAT, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• LAT_LAHSO_DECIMAL (type: esriFieldTypeDouble, alias: LAT_LAHSO_DECIMAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAHSO_LONG (type: esriFieldTypeString, alias: LAHSO_LONG, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• LONG_LAHSO_DECIMAL (type: esriFieldTypeDouble, alias: LONG_LAHSO_DECIMAL, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAHSO_PSN_SOURCE (type: esriFieldTypeString, alias: LAHSO_PSN_SOURCE, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• RWY_END_LAHSO_PSN_DATE (type: esriFieldTypeString, alias: RWY_END_LAHSO_PSN_DATE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)

Templates:

Name: Runway Ends Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/4/2026 10:09:20 PM

Schema Last Edit Date: 5/4/2026 10:09:03 PM

Data Last Edit Date: 5/4/2026 10:09:03 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat