# DpRte

Route points and sequencing for each DP body segment and transition

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

> Ordered by DP_NAME, DP_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 DpRte type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    dpName
    artcc
    dpComputerCode
  # }
}
```

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 |  |  |
| `dpName` | `String` | Name assigned to the Departure Procedure |  |  |
| `artcc` | `DpAptArtcc` | List of all responsible ARTCCs based on airports served |  | `ZAB`, `ZAN`, `ZAP`, … (25 values) |
| `dpComputerCode` | `String` | FAA-Assigned Computer Identifier for the DP (e.g. ADELL6.ADELL) |  |  |
| `routePortionType` | `RoutePortionType` | Identifies whether the segment is a Transition or Body portion of the DP |  | `BODY`=Body segment of the departure procedure; `TRANSITION`=Transition segment of the departure procedure |
| `routeName` | `String` | The transition or body name for this route segment |  |  |
| `bodySeq` | `Int` | Uniquely identifies the segment in the rare case that body name is not unique for a given DP |  |  |
| `transitionComputerCode` | `String` | FAA-Assigned Computer Identifier for the transition |  |  |
| `pointSeq` | `PointSeq` | Sequencing number in multiples of ten; points are ordered as adapted for the given segment |  | `10`, `20`, `30`, … (13 values) |
| `point` | `String` | The fix or NAVAID adapted on the segment |  |  |
| `icaoRegionCode` | `CifpSidIcaoCode2` | The two-letter ICAO region code for FIX point types only |  | `CY`, `K`, `K1`, … (15 values) |
| `pointType` | `FromPtType` | Specific fix or NAVAID type for the point on the segment |  | `CN`, `MR`, `MW`, … (21 values) |
| `nextPoint` | `String` | The point that directly follows the current point on an individual segment |  |  |
| `arptRwyAssoc` | `String` | The list of airports and/or airport/runway combinations associated with a given segment |  |  |

## Enum values

### `artcc` (`DpAptArtcc`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAP` | Anchorage Oceanic 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 |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan ARTCC |
| `ZTL` | Atlanta ARTCC |
| `ZVR` | Vancouver ARTCC |

### `pointSeq` (`PointSeq`)

| Code | Description |
|---|---|
| `10` | Sequence position 10 |
| `20` | Sequence position 20 |
| `30` | Sequence position 30 |
| `40` | Sequence position 40 |
| `50` | Sequence position 50 |
| `60` | Sequence position 60 |
| `70` | Sequence position 70 |
| `80` | Sequence position 80 |
| `90` | Sequence position 90 |
| `100` | Sequence position 100 |
| `110` | Sequence position 110 |
| `120` | Sequence position 120 |
| `130` | Sequence position 130 |

### `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 |
| `NRS` | NRS Waypoint |
| `RADAR` | Radar |
| `RP` | Reporting Point |
| `VFR` | VFR Waypoint |
| `WP` | Waypoint |
| `CONSOLAN` | 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` | 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` | Non-Directional Beacon |
| `NDB/DME` | Non-Directional Beacon with associated Distance Measuring Equipment |
| `TACAN` | Tactical Air Navigation System providing azimuth and slant range distance |
| `UHF/NDB` | Ultra High Frequency Non-Directional Beacon |
| `VOR` | VHF Omni-Directional Range providing azimuth only |
| `VORTAC` | Facility consisting of VOR and TACAN components providing VOR azimuth, TACAN azimuth, and TACAN distance (DME) |
| `VOR/DME` | VHF Omni-Directional Range with associated Distance Measuring Equipment |
| `VOT` | FAA VOR Test Facility |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `dpName` | `DP_NAME` |
| `artcc` | `ARTCC` |
| `dpComputerCode` | `DP_COMPUTER_CODE` |
| `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` |