# DpBase

Base record for each Standard Departure Procedure (DP/SID), one record per DP

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

> Ordered by DP_COMPUTER_CODE. The ordered-by list is also the unique record key.

## Example query

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

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 |  |  |
| `amendmentNo` | `AmendmentNo` | Amendment number (spelled out) of the DP that will be active on the effective date |  | `ONE`, `TWO`, `THREE`, … (9 values) |
| `artcc` | `DpBaseArtcc` | List of all responsible ARTCCs based on airports served |  | `ZAB`, `ZAN`, `ZAP`, … (26 values) |
| `dpAmendEffDate` | `String` | The first effective date for which the DP amendment became active, in format YYYY/MM/DD |  |  |
| `rnavFlag` | `ContrFuelAvbl` | Y/N flag indicating whether the DP is RNAV required |  | `Y`=RNAV required; `N`=RNAV not required |
| `dpComputerCode` | `String` | FAA-Assigned Computer Identifier for the DP (e.g. ADELL6.ADELL) |  |  |
| `graphicalDpType` | `GraphicalDpType` | Identifies whether the graphical DP is type SID or OBSTACLE |  | `SID`=Standard Instrument Departure; `OBSTACLE`=Obstacle Departure Procedure |
| `servedArpt` | `String` | List of airports served by the DP |  |  |

## Enum values

### `amendmentNo` (`AmendmentNo`)

| Code | Description |
|---|---|
| `ONE` | Amendment number one |
| `TWO` | Amendment number two |
| `THREE` | Amendment number three |
| `FOUR` | Amendment number four |
| `FIVE` | Amendment number five |
| `SIX` | Amendment number six |
| `SEVEN` | Amendment number seven |
| `EIGHT` | Amendment number eight |
| `NINE` | Amendment number nine |

### `artcc` (`DpBaseArtcc`)

| 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 |
| `ZYZ` | Toronto ARTCC |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `dpApt` | [`[DpApt]`](./DpApt.md) | `DP_COMPUTER_CODE` |
| `dpRte` | [`[DpRte]`](./DpRte.md) | `DP_COMPUTER_CODE` |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `dpName` | `DP_NAME` |
| `amendmentNo` | `AMENDMENT_NO` |
| `artcc` | `ARTCC` |
| `dpAmendEffDate` | `DP_AMEND_EFF_DATE` |
| `rnavFlag` | `RNAV_FLAG` |
| `dpComputerCode` | `DP_COMPUTER_CODE` |
| `graphicalDpType` | `GRAPHICAL_DP_TYPE` |
| `servedArpt` | `SERVED_ARPT` |