# HpfRmk

Remarks associated with holding pattern records, referencing specific NASR table columns or general notes

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

> Ordered by HP_NAME, HP_NO, TAB_NAME, REF_COL_NAME, REF_COL_SEQ_NO. The combination of these five fields forms the unique record key. Non-specific remarks are identified as GENERAL_REMARK in REF_COL_NAME.

## Example query

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

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 |  |  |
| `hpName` | `String` | Holding Pattern Identifier formatted as NAVAID_NAME FACILITY_TYPE*STATE_CODE or FIX_NAME FIX_TYPE*STATE_CODE*ICAO_REGION_CODE |  |  |
| `hpNo` | `HpfRmkHpNo` | Pattern Number to Uniquely Identify Holding Pattern |  | `1`=Pattern 1; `2`=Pattern 2; `3`=Pattern 3; `4`=Pattern 4; `5`=Pattern 5 |
| `stateCode` | `HpfRmkStateCode` | Associated State Post Office Code, standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (32 values) |
| `countryCode` | `HpfBaseCountryCode` | Country Post Office Code |  | `AS`, `BS`, `CA`, … (8 values) |
| `tabName` | `String` | NASR table name associated with the Remark |  |  |
| `refColName` | `String` | NASR column name associated with the Remark. Non-specific remarks are identified as GENERAL_REMARK |  |  |
| `refColSeqNo` | `ContinuationRecordNo` | Sequence number assigned to the Reference Column Remark to order multiple remarks for the same column |  | `0`=First or only remark; `1`=Second remark; `2`=Third remark |
| `remark` | `String` | Free form text that further describes a specific information item for the holding pattern |  | `175K ICON`, `210K ICON`, `CHART 10 NM LEGS`, … (26 values) |

## Enum values

### `stateCode` (`HpfRmkStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `DE` | Delaware |
| `FL` | Florida |
| `GA` | Georgia |
| `HI` | Hawaii |
| `ID` | Idaho |
| `IL` | Illinois |
| `MA` | Massachusetts |
| `MD` | Maryland |
| `ME` | Maine |
| `MI` | Michigan |
| `MT` | Montana |
| `NC` | North Carolina |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OH` | Ohio |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VT` | Vermont |
| `WA` | Washington |
| `WV` | West Virginia |

### `countryCode` (`HpfBaseCountryCode`)

| Code | Description |
|---|---|
| `AS` | American Samoa |
| `BS` | Bahamas |
| `CA` | Canada |
| `FM` | Federated States of Micronesia |
| `MH` | Marshall Islands |
| `MP` | Northern Mariana Islands |
| `PW` | Palau |
| `US` | United States |

### `remark` (`String`)

| Code | Description |
|---|---|
| `175K ICON` | Chart with 175 knot speed icon |
| `210K ICON` | Chart with 210 knot speed icon |
| `CHART 10 NM LEGS` | Chart with 10 nautical mile legs |
| `CHART 100K ICON` | Chart with 100 knot speed icon |
| `CHART 175K ICON` | Chart with 175 knot speed icon |
| `CHART 175K ICON.` | Chart with 175 knot speed icon (with period) |
| `CHART 200K ICON` | Chart with 200 knot speed icon |
| `CHART 210 ICON` | Chart with 210 knot speed icon |
| `CHART 210K ICON` | Chart with 210 knot speed icon |
| `CHART 210K ICON ON ENROUTE LOW & STAR CHARTS.` | Chart 210 knot icon on Enroute Low and STAR charts |
| `CHART 210K ICON ON LOW CHART` | Chart 210 knot icon on low altitude chart |
| `CHART 210K ICON.` | Chart with 210 knot speed icon (with period) |
| `CHART 230K ICON` | Chart with 230 knot speed icon |
| `CHART 230K ICON.` | Chart with 230 knot speed icon (with period) |
| `CHART 250K ICON` | Chart with 250 knot speed icon |
| `CHART 265K ICON` | Chart with 265 knot speed icon |
| `CHART 310K ICON` | Chart with 310 knot speed icon |
| `CHART 90K ICON` | Chart with 90 knot speed icon |
| `CHART ONLY ON SURFN STAR` | Chart only on SURFN STAR procedure |
| `CHART PAT 1 WITH 210K ICON` | Chart Pattern 1 with 210 knot speed icon |
| `COPTER HOLDING ALT 70/100` | Helicopter holding altitude 70/100 |
| `DME REQUIRED.` | DME equipment required |
| `PAT 1 CHART 210 ICON` | Pattern 1 chart with 210 knot icon |
| `PRIOR COORDINATION REQUIRED WITH CONTROLLING AGENCY FOR HOLDING IN R-2915` | Prior coordination required with controlling agency for holding in restricted area R-2915 |
| `SINCA STAR ONLY` | Applicable to SINCA STAR procedure only |
| `SPECIAL DP` | Special Departure Procedure |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `hpName` | `HP_NAME` |
| `hpNo` | `HP_NO` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `tabName` | `TAB_NAME` |
| `refColName` | `REF_COL_NAME` |
| `refColSeqNo` | `REF_COL_SEQ_NO` |
| `remark` | `REMARK` |