# AwySegAlt

Airway segment altitude data including MEA, MOCA, MCA, MRA, and MAA for each segment between points on an airway

**Source:** NASR table `AWY_SEG_ALT` · version `e25086c3e952` · effective 2026-04-16

> Ordered by AWY_ID, AWY_LOCATION, POINT_SEQ. Unique key: AWY_ID, AWY_LOCATION, FROM_POINT. Designed to replace legacy ATS.txt and AWY.txt Subscriber Files.

## Example query

```graphql
# Introspect the AwySegAlt type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    regulatory
    awyLocation
    awyId
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `effDate` | `String` | The 28 Day NASR Subscription Effective Date in format YYYY/MM/DD |  |  |
| `regulatory` | `ContrFuelAvbl` | Identifies Airways published under 14 CFR (Code of Federal Regulation) Part-71 and Part-95 |  | `Y`=Regulatory airway published under 14 CFR Part-71 and Part-95; `N`=Non-regulatory airway |
| `awyLocation` | `AwyLocation` | Airway Type identifying the General Location of the Airway |  | `A`=ALASKA AIRWAY; `H`=HAWAII AIRWAY; `C`=U.S. CONTIGUOUS AIRWAY |
| `awyId` | `String` | Airway Identifier |  |  |
| `pointSeq` | `Int` | Sequencing number in multiples of ten; points are in the order adapted for the given Airway |  |  |
| `fromPoint` | `String` | NAVAID Facility Identifier, FIX Name, or Border crossing. A unique system-generated number is added to each Border crossing Segment Value. |  |  |
| `fromPtType` | `FromPtType` | NAVAID Facility or FIX Type identifying the type of the FROM_POINT |  | `CN`, `MR`, `MW`, … (21 values) |
| `navName` | `String` | NAVAID Facility Name |  |  |
| `navCity` | `String` | The NAVAID Facility City which is part of the key for all NAV_*.csv files |  |  |
| `artcc` | `Artcc` | Identifier of Low ARTCC Altitude Boundary that the FROM_POINT FIX/NAVAID Falls Within |  | `ZAB`, `ZAK`, `ZAN`, … (31 values) |
| `icaoRegionCode` | `IcaoRegionCode` | Two letter ICAO Region Code for FIX Point Types only |  | `CY`, `K`, `K1`, … (20 values) |
| `stateCode` | `AwySegAltStateCode` | Associated State Post Office Code standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (58 values) |
| `countryCode` | `AwySegAltCountryCode` | Country Post Office Code |  | `AG`, `AN`, `BM`, … (14 values) |
| `toPoint` | `String` | The To Point that directly follows the current From Point on an individual segment |  |  |
| `magCourse` | `Float` | Segment Magnetic Course | degrees |  |
| `oppMagCourse` | `Float` | Segment Magnetic Course in the Opposite Direction | degrees |  |
| `magCourseDist` | `Float` | Distance to Next Point in Segment | nautical miles |  |
| `chgovrPt` | `String` | NAVAID Changeover Point Facility Identifier |  |  |
| `chgovrPtName` | `String` | NAVAID Changeover Point Facility Name |  |  |
| `chgovrPtDist` | `Int` | Distance of the Changeover Point from this NAVAID Facility to the Next NAVAID Facility when the Changeover Point is more than one mile from the halfway point | nautical miles |  |
| `awySegGapFlag` | `ContrFuelAvbl` | Airway Gap Flag Indicator for when Airway is Discontinued |  | `Y`=Airway discontinued / gap present; `N`=No airway gap |
| `signalGapFlag` | `ContrFuelAvbl` | Gap in Signal Coverage Indicator for when MEA is established with a gap in Navigation Signal Coverage |  | `Y`=Gap in signal coverage exists; `N`=No gap in signal coverage |
| `dogleg` | `ContrFuelAvbl` | A Turn Point Not At A NAVAID. GPS RNAV Routes (Q, T, TK) will have Dogleg=Y at First Point, End Point, and all Turn Points in between. |  | `Y`=Turn point not at a NAVAID (dogleg); `N`=No dogleg |
| `nextMeaPt` | `String` | The To MEA_PT that directly follows the From MEA_PT for an individual Altitude record |  |  |
| `minEnrouteAlt` | `Int` | Point To Point Minimum Enroute Altitude (MEA) | feet MSL |  |
| `minEnrouteAltDir` | `DdIruMeaDir` | Point To Point Minimum Enroute Direction (MEA) when directional MEA applies |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `minEnrouteAltOpposite` | `Int` | Point To Point Minimum Enroute Altitude (MEA) in the Opposite Direction | feet MSL |  |
| `minEnrouteAltOppositeDir` | `DdIruMeaDir` | Point To Point Minimum Enroute Direction (MEA) for the Opposite Direction |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `gpsMinEnrouteAlt` | `Int` | Point To Point GNSS Minimum Enroute Altitude (Global Navigation Satellite System MEA) | feet MSL |  |
| `gpsMinEnrouteAltDir` | `DdIruMeaDir` | Point To Point GNSS Minimum Enroute Direction (Global Navigation Satellite System MEA) when directional GPS MEA applies |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `gpsMinEnrouteAltOpposite` | `Int` | Point To Point GNSS Minimum Enroute Altitude (Global Navigation Satellite System MEA) in the Opposite Direction | feet MSL |  |
| `gpsMeaOppositeDir` | `DdIruMeaDir` | Point To Point GNSS Minimum Enroute Direction (Global Navigation Satellite System MEA) for the Opposite Direction |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `ddIruMea` | `Int` | Point To Point DME/DME/IRU Minimum Enroute Altitude (MEA) | feet MSL |  |
| `ddIruMeaDir` | `DdIruMeaDir` | Point To Point DME/DME/IRU Minimum Enroute Direction (MEA) when directional DD/IRU MEA applies |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `ddIMeaOpposite` | `Int` | Point To Point DME/DME/IRU Minimum Enroute Altitude (MEA) in the Opposite Direction | feet MSL |  |
| `ddIMeaOppositeDir` | `DdIruMeaDir` | Point To Point DME/DME/IRU Minimum Enroute Direction (MEA) for the Opposite Direction |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `minObstnClncAlt` | `Int` | Point To Point Minimum Obstruction Clearance Altitude (MOCA) | feet MSL |  |
| `minCrossAlt` | `Int` | Minimum Crossing Altitude (MCA) | feet MSL |  |
| `minCrossAltDir` | `DdIruMeaDir` | Minimum Crossing Direction (MCA) when directional MCA applies |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `minCrossAltNavPt` | `String` | Minimum Crossing Altitude (MCA) Point identifier at which the MCA applies |  |  |
| `minCrossAltOpposite` | `Int` | Minimum Crossing Altitude (MCA) in the Opposite Direction | feet MSL |  |
| `minCrossAltOppositeDir` | `DdIruMeaDir` | Minimum Crossing Direction (MCA) for the Opposite Direction |  | `E BND`, `N BND`, `NE BND`, … (8 values) |
| `minRecepAlt` | `Int` | FIX Minimum Reception Altitude (MRA) | feet MSL |  |
| `maxAuthAlt` | `Int` | Point To Point Maximum Authorized Altitude (MAA) | feet MSL |  |
| `meaGap` | `MeaGap` | Identifies whether a given Airway Segment is Unusable or contains No MEA information |  | `U`=Airway segment is unusable; `N`=No MEA information for this segment |
| `reqdNavPerformance` | `Float` | Required Navigation Performance (RNP) value for the airway segment |  |  |
| `remark` | `String` | Remark Text (Free Form Text that further describes a specific Information Item) |  |  |

## Enum values

### `fromPtType` (`FromPtType`)

| Code | Description |
|---|---|
| `CN` | COMPUTER NAVIGATION FIX |
| `MR` | MILITARY REPORTING POINT |
| `MW` | MILITARY WAYPOINT |
| `NRS` | NRS WAYPOINT |
| `RADAR` | RADAR |
| `RP` | REPORTING POINT |
| `VFR` | VFR WAYPOINT |
| `WP` | WAYPOINT |
| `CONSOLAN` | A Low Frequency Long-Distance NAVAID Used Principally for Transoceanic Navigation |
| `DME` | Distance Measuring Equipment only |
| `FAN MARKER` | En Route Marker Beacon used to provide positive identification of positions at definite points along airways |
| `MARINE NDB` | A Non-Directional Beacon used primarily for Marine surface Navigation |
| `MARINE NDB/DME` | A Non-Directional Beacon with associated Distance Measuring Equipment used primarily for Marine Navigation |
| `NDB` | A Non-Directional Beacon |
| `NDB/DME` | Non-Directional Beacon with associated Distance Measuring Equipment |
| `TACAN` | A Tactical Air Navigation System providing Azimuth and Slant Range Distance |
| `UHF/NDB` | Ultra High Frequency/Non-Directional Beacon |
| `VOR` | A VHF Omni-Directional Range providing Azimuth only |
| `VORTAC` | A facility consisting of VOR and TACAN components providing VOR Azimuth, TACAN Azimuth, and TACAN Distance at one site |
| `VOR/DME` | VHF Omni-Directional Range with associated Distance Measuring Equipment |
| `VOT` | A FAA VOR Test Facility |

### `artcc` (`Artcc`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAK` | Oakland Oceanic ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu ARTCC |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZKC` | Kansas City ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZLC` | Salt Lake City ARTCC |
| `ZMA` | Miami ARTCC |
| `ZME` | Memphis ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZQM` | Special Use ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZUA` | Guam ARTCC |
| `ZUL` | Monterrey ARTCC |
| `ZVR` | Vancouver ARTCC |
| `ZWG` | Winnipeg ARTCC |
| `ZWY` | Winnipeg ARTCC |
| `ZYZ` | Toronto ARTCC |

### `icaoRegionCode` (`IcaoRegionCode`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K` | Contiguous United States |
| `K1` | Contiguous United States region 1 |
| `K2` | Contiguous United States region 2 |
| `K3` | Contiguous United States region 3 |
| `K4` | Contiguous United States region 4 |
| `K5` | Contiguous United States region 5 |
| `K6` | Contiguous United States region 6 |
| `K7` | Contiguous United States region 7 |
| `MD` | Dominican Republic |
| `MM` | Mexico |
| `MY` | Bahamas |
| `P` | North Pacific |
| `PA` | Alaska |
| `PG` | Guam/Mariana Islands |
| `PH` | Hawaii |
| `TI` | U.S. Virgin Islands |
| `TJ` | Puerto Rico |
| `TN` | Netherlands Antilles |
| `UH` | Russia Far East |

### `stateCode` (`AwySegAltStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `DC` | District of Columbia |
| `DE` | Delaware |
| `FL` | Florida |
| `GA` | Georgia |
| `GU` | Guam |
| `HI` | Hawaii |
| `IA` | Iowa |
| `ID` | Idaho |
| `IL` | Illinois |
| `IN` | Indiana |
| `KS` | Kansas |
| `KY` | Kentucky |
| `LA` | Louisiana |
| `MA` | Massachusetts |
| `MD` | Maryland |
| `ME` | Maine |
| `MI` | Michigan |
| `MN` | Minnesota |
| `MO` | Missouri |
| `MP` | Northern Mariana Islands |
| `MS` | Mississippi |
| `MT` | Montana |
| `NC` | North Carolina |
| `ND` | North Dakota |
| `NE` | Nebraska |
| `NH` | New Hampshire |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OA` | Ocean Area |
| `OG` | Ocean Area Gulf |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OP` | Ocean Area Pacific |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | U.S. Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`AwySegAltCountryCode`)

| Code | Description |
|---|---|
| `AG` | Antigua and Barbuda |
| `AN` | Netherlands Antilles |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `CA` | Canada |
| `DO` | Dominican Republic |
| `FM` | Federated States of Micronesia |
| `IB` | Cuba |
| `MH` | Marshall Islands |
| `MX` | Mexico |
| `PW` | Palau |
| `RU` | Russia |
| `TC` | Turks and Caicos Islands |
| `US` | United States |

### `minEnrouteAltDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `minEnrouteAltOppositeDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `gpsMinEnrouteAltDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `gpsMeaOppositeDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `ddIruMeaDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `ddIMeaOppositeDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `minCrossAltDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

### `minCrossAltOppositeDir` (`DdIruMeaDir`)

| Code | Description |
|---|---|
| `E BND` | Eastbound |
| `N BND` | Northbound |
| `NE BND` | Northeastbound |
| `NW BND` | Northwestbound |
| `S BND` | Southbound |
| `SE BND` | Southeastbound |
| `SW BND` | Southwestbound |
| `W BND` | Westbound |

## Column provenance

Every field maps 1:1 to a column in the `AWY_SEG_ALT` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `regulatory` | `REGULATORY` |
| `awyLocation` | `AWY_LOCATION` |
| `awyId` | `AWY_ID` |
| `pointSeq` | `POINT_SEQ` |
| `fromPoint` | `FROM_POINT` |
| `fromPtType` | `FROM_PT_TYPE` |
| `navName` | `NAV_NAME` |
| `navCity` | `NAV_CITY` |
| `artcc` | `ARTCC` |
| `icaoRegionCode` | `ICAO_REGION_CODE` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `toPoint` | `TO_POINT` |
| `magCourse` | `MAG_COURSE` |
| `oppMagCourse` | `OPP_MAG_COURSE` |
| `magCourseDist` | `MAG_COURSE_DIST` |
| `chgovrPt` | `CHGOVR_PT` |
| `chgovrPtName` | `CHGOVR_PT_NAME` |
| `chgovrPtDist` | `CHGOVR_PT_DIST` |
| `awySegGapFlag` | `AWY_SEG_GAP_FLAG` |
| `signalGapFlag` | `SIGNAL_GAP_FLAG` |
| `dogleg` | `DOGLEG` |
| `nextMeaPt` | `NEXT_MEA_PT` |
| `minEnrouteAlt` | `MIN_ENROUTE_ALT` |
| `minEnrouteAltDir` | `MIN_ENROUTE_ALT_DIR` |
| `minEnrouteAltOpposite` | `MIN_ENROUTE_ALT_OPPOSITE` |
| `minEnrouteAltOppositeDir` | `MIN_ENROUTE_ALT_OPPOSITE_DIR` |
| `gpsMinEnrouteAlt` | `GPS_MIN_ENROUTE_ALT` |
| `gpsMinEnrouteAltDir` | `GPS_MIN_ENROUTE_ALT_DIR` |
| `gpsMinEnrouteAltOpposite` | `GPS_MIN_ENROUTE_ALT_OPPOSITE` |
| `gpsMeaOppositeDir` | `GPS_MEA_OPPOSITE_DIR` |
| `ddIruMea` | `DD_IRU_MEA` |
| `ddIruMeaDir` | `DD_IRU_MEA_DIR` |
| `ddIMeaOpposite` | `DD_I_MEA_OPPOSITE` |
| `ddIMeaOppositeDir` | `DD_I_MEA_OPPOSITE_DIR` |
| `minObstnClncAlt` | `MIN_OBSTN_CLNC_ALT` |
| `minCrossAlt` | `MIN_CROSS_ALT` |
| `minCrossAltDir` | `MIN_CROSS_ALT_DIR` |
| `minCrossAltNavPt` | `MIN_CROSS_ALT_NAV_PT` |
| `minCrossAltOpposite` | `MIN_CROSS_ALT_OPPOSITE` |
| `minCrossAltOppositeDir` | `MIN_CROSS_ALT_OPPOSITE_DIR` |
| `minRecepAlt` | `MIN_RECEP_ALT` |
| `maxAuthAlt` | `MAX_AUTH_ALT` |
| `meaGap` | `MEA_GAP` |
| `reqdNavPerformance` | `REQD_NAV_PERFORMANCE` |
| `remark` | `REMARK` |