# StarRte

Route point-by-point details for each STAR body and transition segment

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

> Ordered by STAR_COMPUTER_CODE, ROUTE_PORTION_TYPE, ROUTE_NAME, BODY_SEQ, POINT_SEQ. The ordered-by list is also the unique record key.

## Example query

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

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 |  |  |
| `starComputerCode` | `String` | FAA-assigned computer identifier for the STAR; references STAR_COMPUTER_CODE in STAR_BASE |  |  |
| `artcc` | `StarAptArtcc` | List of all responsible ARTCCs based on airports served |  | `ZAB`, `ZAN`, `ZAU`, … (26 values) |
| `routePortionType` | `RoutePortionType` | Identifies whether the route segment is a transition or a body |  | `BODY`=Body segment of the STAR; `TRANSITION`=Transition segment of the STAR |
| `routeName` | `String` | The name of the transition or body segment |  |  |
| `bodySeq` | `CifpPathPointContinuationRecordNo` | Sequence number to uniquely identify a body segment in the rare case that the body name is not unique for a given STAR |  | `1`=First body segment; `2`=Second body segment |
| `transitionComputerCode` | `String` | FAA-assigned computer identifier for the transition segment |  |  |
| `pointSeq` | `StarRtePointSeq` | Sequencing number in multiples of ten; points are in order as adapted for the given segment |  | `10`, `20`, `30`, … (18 values) |
| `point` | `String` | The fix or NAVAID adapted on the segment |  |  |
| `icaoRegionCode` | `CifpSidIcaoCode2` | Two-letter ICAO region code applicable to FIX point types only |  | `CY`, `K`, `K1`, … (15 values) |
| `pointType` | `FromPtType` | Specific fix or NAVAID type for the route point |  | `CN`, `MR`, `MW`, … (21 values) |
| `nextPoint` | `String` | The point that directly follows the current point on an individual segment |  |  |
| `arptRwyAssoc` | `String` | List of airports and/or airport/runway combinations associated with a given segment |  |  |

## Enum values

### `artcc` (`StarAptArtcc`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZBW ZNY` | Boston and New York ARTCCs |
| `ZDC` | Washington ARTCC |
| `ZDC ZNY` | Washington and New York ARTCCs |
| `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 |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZVR` | Vancouver (Canadian) ARTCC |

### `pointSeq` (`StarRtePointSeq`)

| Code | Description |
|---|---|
| `10` | First point |
| `20` | Second point |
| `30` | Third point |
| `40` | Fourth point |
| `50` | Fifth point |
| `60` | Sixth point |
| `70` | Seventh point |
| `80` | Eighth point |
| `90` | Ninth point |
| `100` | Tenth point |
| `110` | Eleventh point |
| `120` | Twelfth point |
| `130` | Thirteenth point |
| `140` | Fourteenth point |
| `150` | Fifteenth point |
| `160` | Sixteenth point |
| `170` | Seventeenth point |
| `180` | Eighteenth point |

### `icaoRegionCode` (`CifpSidIcaoCode2`)

| 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 |
| `MY` | Bahamas |
| `P` | North Pacific |
| `PA` | Alaska |
| `PH` | Hawaii |
| `TI` | US Virgin Islands |
| `TJ` | Puerto Rico |

### `pointType` (`FromPtType`)

| Code | Description |
|---|---|
| `CN` | Computer Navigation Fix |
| `MR` | Military Reporting Point |
| `MW` | Military Waypoint |
| `NDB` | Non-Directional Beacon |
| `RP` | Reporting Point |
| `VOR` | VHF Omni-Directional Range providing azimuth only |
| `VOR/DME` | VHF Omni-Directional Range with associated Distance Measuring Equipment |
| `VORTAC` | Facility consisting of VOR and TACAN components providing VOR azimuth, TACAN azimuth, and TACAN distance (DME) |
| `WP` | Waypoint |
| `DME` | Distance Measuring Equipment only |
| `CONSOLAN` | Low frequency long-distance NAVAID used principally for transoceanic navigation |
| `FAN MARKER` | En route marker beacon used to provide positive identification of positions at definite points along airways |
| `MARINE NDB` | Non-Directional Beacon used primarily for marine surface navigation |
| `MARINE NDB/DME` | Non-Directional Beacon with associated Distance Measuring Equipment used primarily for marine surface navigation |
| `NDB/DME` | Non-Directional Beacon with associated Distance Measuring Equipment |
| `NRS` | NRS Waypoint |
| `RADAR` | Radar |
| `TACAN` | Tactical Air Navigation System providing azimuth and slant range distance |
| `UHF/NDB` | Ultra High Frequency/Non-Directional Beacon |
| `VFR` | VFR Waypoint |
| `VOT` | FAA VOR Test Facility |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `starComputerCode` | `STAR_COMPUTER_CODE` |
| `artcc` | `ARTCC` |
| `routePortionType` | `ROUTE_PORTION_TYPE` |
| `routeName` | `ROUTE_NAME` |
| `bodySeq` | `BODY_SEQ` |
| `transitionComputerCode` | `TRANSITION_COMPUTER_CODE` |
| `pointSeq` | `POINT_SEQ` |
| `point` | `POINT` |
| `icaoRegionCode` | `ICAO_REGION_CODE` |
| `pointType` | `POINT_TYPE` |
| `nextPoint` | `NEXT_POINT` |
| `arptRwyAssoc` | `ARPT_RWY_ASSOC` |