# FixBase

Base table for airspace fixes containing position, classification, and operational data for fixed geographical positions

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

> Ordered by FIX_ID, ICAO_REGION_CODE. This ordering also serves as the unique record key. Replaces legacy FIX.txt Subscriber File.

## Example query

```graphql
{
  fix(fixId: "OSI") {
    fixId
    stateCode
    latDecimal
    longDecimal
  }
}
```

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 |  |  |
| `fixId` | `String` | Fixed Geographical Position Identifier |  |  |
| `icaoRegionCode` | `CifpEnrouteWaypointIcaoCode2` | International Civil Aviation Organization (ICAO) Code. In general, the first letter refers to the country, the second letter discerns the region within the country. |  | `CY`, `K`, `K1`, … (22 values) |
| `stateCode` | `FixBaseStateCode` | Associated State Post Office Code - standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (61 values) |
| `countryCode` | `FixBaseCountryCode` | Country Post Office Code identifying the country associated with the fix |  | `AS`, `BS`, `CA`, … (13 values) |
| `latDeg` | `Int` | FIX Latitude Degrees component of the DMS coordinate | degrees |  |
| `latMin` | `Int` | FIX Latitude Minutes component of the DMS coordinate | minutes |  |
| `latSec` | `Float` | FIX Latitude Seconds component of the DMS coordinate | seconds |  |
| `latHemis` | `LatHemis` | FIX Latitude Hemisphere indicator |  | `N`=North; `S`=South |
| `latDecimal` | `Float` | FIX Latitude expressed in decimal degrees format | degrees |  |
| `longDeg` | `Int` | FIX Longitude Degrees component of the DMS coordinate | degrees |  |
| `longMin` | `Int` | FIX Longitude Minutes component of the DMS coordinate | minutes |  |
| `longSec` | `Float` | FIX Longitude Seconds component of the DMS coordinate | seconds |  |
| `longHemis` | `LongHemis` | FIX Longitude Hemisphere indicator |  | `E`=East; `W`=West |
| `longDecimal` | `Float` | FIX Longitude expressed in decimal degrees format | degrees |  |
| `fixIdOld` | `String` | Previous name(s) of the fix before it was renamed |  |  |
| `chartingRemark` | `String` | Charting information and remarks describing how and where the fix is depicted on charts |  | `COMPULSORY`, `COMPULSORY RNAV`, `COMPULSORY BELOW FL200`, … (39 values) |
| `fixUseCode` | `FixUseCode` | FIX Type code indicating the primary use or classification of the fix |  | `CN`, `MR`, `MW`, … (8 values) |
| `artccIdHigh` | `ArtccIdHigh` | Denotes High ARTCC (Air Route Traffic Control Center) Area Of Jurisdiction identifier |  | `ZAB`, `ZAK`, `ZAN`, … (33 values) |
| `artccIdLow` | `ArtccIdHigh` | Denotes Low ARTCC (Air Route Traffic Control Center) Area Of Jurisdiction identifier |  | `ZAB`, `ZAK`, `ZAN`, … (33 values) |
| `pitchFlag` | `ContrFuelAvbl` | Indicates whether the fix is a PITCH point (part of the NAVAID-to-NAVAID airway system) |  | `Y`=Yes; `N`=No |
| `catchFlag` | `ContrFuelAvbl` | Indicates whether the fix is a CATCH point (part of the NAVAID-to-NAVAID airway system) |  | `Y`=Yes; `N`=No |
| `suaAtcaaFlag` | `ContrFuelAvbl` | Indicates whether the fix is associated with Special Use Airspace (SUA) or ATC Assigned Airspace (ATCAA) |  | `Y`=Yes; `N`=No |
| `minRecepAlt` | `Int` | Fix Minimum Reception Altitude (MRA) - the lowest altitude at which the fix can be determined | feet MSL |  |
| `compulsory` | `Compulsory` | Indicates whether the fix is a compulsory reporting point and at which altitude stratum. Null indicates a non-compulsory fix. |  | `HIGH`=Compulsory reporting point for high altitude; `LOW`=Compulsory reporting point for low altitude; `LOW/HIGH`=Compulsory reporting point for both low and high altitude |
| `charts` | `String` | Concatenated list of charting information found in the FIX_CHRT table, separated by commas |  |  |

## Enum values

### `icaoRegionCode` (`CifpEnrouteWaypointIcaoCode2`)

| 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` | Maryland/Mid-Atlantic |
| `MM` | Mexico |
| `MY` | Bahamas |
| `NZ` | New Zealand |
| `P` | North Pacific |
| `PA` | Alaska |
| `PG` | Guam/Mariana Islands |
| `PH` | Hawaii |
| `TI` | US Virgin Islands |
| `TJ` | Puerto Rico |
| `TN` | Caribbean |
| `UH` | Russia Far East |
| `UL` | Russia |

### `stateCode` (`FixBaseStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AS` | American Samoa |
| `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` | Pacific Ocean Area |
| `OG` | Gulf of Mexico Area |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OP` | Pacific Ocean |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QM` | Atlantic Ocean Area |
| `QW` | Atlantic Ocean |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | US Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`FixBaseCountryCode`)

| Code | Description |
|---|---|
| `AS` | American Samoa |
| `BS` | Bahamas |
| `CA` | Canada |
| `DO` | Dominican Republic |
| `FM` | Federated States of Micronesia |
| `IB` | International/High Seas |
| `MH` | Marshall Islands |
| `MP` | Northern Mariana Islands |
| `MX` | Mexico |
| `PW` | Palau |
| `RU` | Russia |
| `TC` | Turks and Caicos Islands |
| `US` | United States |

### `chartingRemark` (`String`)

| Code | Description |
|---|---|
| `COMPULSORY` | Compulsory reporting point |
| `COMPULSORY RNAV` | Compulsory RNAV fix |
| `COMPULSORY BELOW FL200` | Compulsory below FL200 |
| `COMPULSORY HIGH` | Compulsory for high altitude |
| `COMPULSORY HIGH RNAV` | Compulsory high altitude RNAV fix |
| `COMPULSORY HIGH; ON REQUEST LOW` | Compulsory high altitude; on request for low altitude |
| `COMPULSORY LOW` | Compulsory for low altitude |
| `COMPULSORY LOW RNAV` | Compulsory low altitude RNAV fix |
| `COMPULSORY LOW/HIGH` | Compulsory for both low and high altitude |
| `COMPULSORY ON A555 ONLY RNAV` | Compulsory on ATS route A555 only RNAV |
| `COMPULSORY ON ATS ROUTE A216` | Compulsory on ATS route A216 |
| `COMPULSORY ON ATS ROUTE A216.` | Compulsory on ATS route A216 |
| `COMPULSORY ON ATS ROUTE A337.` | Compulsory on ATS route A337 |
| `COMPULSORY ON ATS ROUTE G205.` | Compulsory on ATS route G205 |
| `COMPULSORY ON ATS ROUTE R204.` | Compulsory on ATS route R204 |
| `COMPULSORY ON ATS ROUTES` | Compulsory on ATS routes |
| `COMPULSORY ON L451 ONLY` | Compulsory on L451 only |
| `COMPULSORY ON L453 ONLY` | Compulsory on L453 only |
| `COMPULSORY ON L454 ONLY` | Compulsory on L454 only |
| `COMPULSORY ON L455 ONLY` | Compulsory on L455 only |
| `COMPULSORY ON L456 ONLY` | Compulsory on L456 only |
| `COMPULSORY ON M202 AND L453 ONLY` | Compulsory on M202 and L453 only |
| `COMPULSORY ON M204 ONLY` | Compulsory on M204 only |
| `COMPULSORY ON M593 ONLY` | Compulsory on M593 only |
| `COMPULSORY ON M595 ONLY` | Compulsory on M595 only |
| `COMPULSORY SBND L454 ON LY` | Compulsory southbound on L454 only |
| `COMPULSORY SBND L455 AND L457` | Compulsory southbound on L455 and L457 |
| `COMPULSORY SBND L456 AND L459` | Compulsory southbound on L456 and L459 |
| `COMPULSORY SBND L461 ONLY` | Compulsory southbound on L461 only |
| `RADAR` | Radar fix |
| `RNAV` | RNAV fix |
| `RNAV COMPULSORY` | RNAV compulsory fix |
| `RNAV COMPULSORY HIGH` | RNAV compulsory high altitude |
| `RNAV COMPULSORY LOW` | RNAV compulsory low altitude |
| `RNAV  COMPULSORY LOW` | RNAV compulsory low altitude |
| `RNAV SPECIAL ENROUTE` | RNAV special enroute fix |
| `SPECIAL ENROUTE` | Special enroute fix |
| `SPECIAL ROUTE` | Special route fix |
| `` |  |

### `fixUseCode` (`FixUseCode`)

| 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 |

### `artccIdHigh` (`ArtccIdHigh`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAK` | Oakland Oceanic ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZEG` | Belem ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu Control Facility |
| `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` | New York Oceanic East ARTCC |
| `ZQX` | New York Oceanic West 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 High ARTCC |
| `ZYZ` | Toronto ARTCC |

### `artccIdLow` (`ArtccIdHigh`)

| Code | Description |
|---|---|
| `ZAB` | Albuquerque ARTCC |
| `ZAK` | Oakland Oceanic ARTCC |
| `ZAN` | Anchorage ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZEG` | Belem ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu Control Facility |
| `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` | New York Oceanic East ARTCC |
| `ZQX` | New York Oceanic West 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 High ARTCC |
| `ZYZ` | Toronto ARTCC |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `fixChrt` | [`[FixChrt]`](./FixChrt.md) | `FIX_ID` |
| `fixNav` | [`[FixNav]`](./FixNav.md) | `FIX_ID` |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `fixId` | `FIX_ID` |
| `icaoRegionCode` | `ICAO_REGION_CODE` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `latDeg` | `LAT_DEG` |
| `latMin` | `LAT_MIN` |
| `latSec` | `LAT_SEC` |
| `latHemis` | `LAT_HEMIS` |
| `latDecimal` | `LAT_DECIMAL` |
| `longDeg` | `LONG_DEG` |
| `longMin` | `LONG_MIN` |
| `longSec` | `LONG_SEC` |
| `longHemis` | `LONG_HEMIS` |
| `longDecimal` | `LONG_DECIMAL` |
| `fixIdOld` | `FIX_ID_OLD` |
| `chartingRemark` | `CHARTING_REMARK` |
| `fixUseCode` | `FIX_USE_CODE` |
| `artccIdHigh` | `ARTCC_ID_HIGH` |
| `artccIdLow` | `ARTCC_ID_LOW` |
| `pitchFlag` | `PITCH_FLAG` |
| `catchFlag` | `CATCH_FLAG` |
| `suaAtcaaFlag` | `SUA_ATCAA_FLAG` |
| `minRecepAlt` | `MIN_RECEP_ALT` |
| `compulsory` | `COMPULSORY` |
| `charts` | `CHARTS` |