# ArbBase

Base record for each ARTCC or CERAP facility including location reference point coordinates and identifying information

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

> Ordered by and unique key: LOCATION_ID. Replaces legacy ARB.txt Subscriber File.

## Example query

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

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 |  |  |
| `locationId` | `LocationId` | Location Identifier; 3-4 character alphanumeric identifier uniquely identifying the ARTCC or CERAP facility |  | `FIMM`, `NZZO`, `SBAO`, … (38 values) |
| `locationName` | `LocationName` | Center name of the ARTCC or CERAP facility |  | `ALBUQUERQUE`, `ANCHORAGE`, `ANCHORAGE OCEANIC`, … (38 values) |
| `computerId` | `String` | Location computer identifier used internally to identify the facility |  |  |
| `icaoId` | `IcaoId` | ICAO identifier for the facility |  | `CZEG`, `CZQM`, `CZQX`, … (37 values) |
| `locationType` | `LocationType` | Type of air traffic control facility |  | `ARTCC`=Air Route Traffic Control Center; `CERAP`=Combined Center Radar Approach Control |
| `city` | `String` | City where the facility is located |  |  |
| `state` | `State` | State or province post office code; standard two-letter abbreviation for US states, territories, and Canadian provinces |  | `AB`, `AK`, `AZ`, … (29 values) |
| `countryCode` | `ArbBaseCountryCode` | Country post office code for the country where the facility is located |  | `BR`=Brazil; `CA`=Canada; `MU`=Mauritius; `NZ`=New Zealand; `US`=United States |
| `latDeg` | `Int` | Location reference point latitude degrees component | degrees |  |
| `latMin` | `Int` | Location reference point latitude minutes component | minutes |  |
| `latSec` | `Float` | Location reference point latitude seconds component | seconds |  |
| `latHemis` | `LatHemis` | Location reference point latitude hemisphere indicator |  | `N`=North; `S`=South |
| `latDecimal` | `Float` | Location reference point latitude in signed decimal degrees format (negative = South) | degrees |  |
| `longDeg` | `Int` | Location reference point longitude degrees component | degrees |  |
| `longMin` | `Int` | Location reference point longitude minutes component | minutes |  |
| `longSec` | `Float` | Location reference point longitude seconds component | seconds |  |
| `longHemis` | `LongHemis` | Location reference point longitude hemisphere indicator |  | `E`=East; `W`=West |
| `longDecimal` | `Float` | Location reference point longitude in signed decimal degrees format (negative = West) | degrees |  |
| `crossRef` | `String` | Cross reference free-form text that further describes the facility, typically indicating its physical location |  |  |

## Enum values

### `locationId` (`LocationId`)

| Code | Description |
|---|---|
| `FIMM` | Mauritius FIR |
| `NZZO` | Auckland Oceanic FIR |
| `SBAO` | Atlantico FIR |
| `ZAB` | Albuquerque ARTCC |
| `ZAK` | Oakland Oceanic ARTCC |
| `ZAN` | Anchorage Oceanic |
| `ZAP` | Anchorage |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZEG` | Edmonton |
| `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` | Moncton |
| `ZQX` | Gander |
| `ZSE` | Seattle ARTCC |
| `ZSU` | San Juan |
| `ZTL` | Atlanta ARTCC |
| `ZUA` | Guam |
| `ZUL` | Montreal |
| `ZVR` | Vancouver |
| `ZWG` | Winnipeg |
| `ZWY` | New York Oceanic FIR |
| `ZYL` | Yuma CERAP |
| `ZYZ` | Toronto |

### `locationName` (`LocationName`)

| Code | Description |
|---|---|
| `ALBUQUERQUE` | Albuquerque ARTCC |
| `ANCHORAGE` | Anchorage ARTCC |
| `ANCHORAGE OCEANIC` | Anchorage Oceanic ARTCC |
| `ATLANTA` | Atlanta ARTCC |
| `ATLANTICO FIR` | Atlantico FIR (Brazil) |
| `AUCKLAND OCEANIC FIR` | Auckland Oceanic FIR (New Zealand) |
| `BOSTON` | Boston ARTCC |
| `CHICAGO` | Chicago ARTCC |
| `CLEVELAND` | Cleveland ARTCC |
| `DENVER` | Denver ARTCC |
| `EDMONTON` | Edmonton ARTCC (Canada) |
| `FORT WORTH` | Fort Worth ARTCC |
| `GANDER` | Gander ARTCC (Canada) |
| `GUAM` | Guam ARTCC |
| `HONOLULU CONTROL FACILITY` | Honolulu Control Facility |
| `HOUSTON` | Houston ARTCC |
| `INDIANAPOLIS` | Indianapolis ARTCC |
| `JACKSONVILLE` | Jacksonville ARTCC |
| `KANSAS CITY` | Kansas City ARTCC |
| `LOS ANGELES` | Los Angeles ARTCC |
| `MAURITIUS FIR` | Mauritius FIR |
| `MEMPHIS` | Memphis ARTCC |
| `MIAMI` | Miami ARTCC |
| `MINNEAPOLIS` | Minneapolis ARTCC |
| `MONCTON` | Moncton ARTCC (Canada) |
| `MONTREAL` | Montreal ARTCC (Canada) |
| `NEW YORK` | New York ARTCC |
| `NEW YORK OCEANIC FIR` | New York Oceanic FIR |
| `OAKLAND` | Oakland ARTCC |
| `OAKLAND OCEANIC ARTCC` | Oakland Oceanic ARTCC |
| `SALT LAKE CITY` | Salt Lake City ARTCC |
| `SAN JUAN` | San Juan CERAP |
| `SEATTLE` | Seattle ARTCC |
| `TORONTO` | Toronto ARTCC (Canada) |
| `VANCOUVER` | Vancouver ARTCC (Canada) |
| `WASHINGTON` | Washington ARTCC |
| `WINNIPEG` | Winnipeg ARTCC (Canada) |
| `YUMA CERAP` | Yuma CERAP |

### `icaoId` (`IcaoId`)

| Code | Description |
|---|---|
| `CZEG` | Edmonton ARTCC (Canada) |
| `CZQM` | Moncton ARTCC (Canada) |
| `CZQX` | Gander ARTCC (Canada) |
| `CZUL` | Montreal ARTCC (Canada) |
| `CZVR` | Vancouver ARTCC (Canada) |
| `CZWG` | Winnipeg ARTCC (Canada) |
| `CZYZ` | Toronto ARTCC (Canada) |
| `FIMM` | Mauritius FIR |
| `KZAB` | Albuquerque ARTCC |
| `KZAK` | Oakland Oceanic ARTCC |
| `KZAU` | Chicago ARTCC |
| `KZBW` | Boston ARTCC |
| `KZDC` | Washington ARTCC |
| `KZDV` | Denver ARTCC |
| `KZFW` | Fort Worth ARTCC |
| `KZHU` | Houston ARTCC |
| `KZID` | Indianapolis ARTCC |
| `KZJX` | Jacksonville ARTCC |
| `KZKC` | Kansas City ARTCC |
| `KZLA` | Los Angeles ARTCC |
| `KZLC` | Salt Lake City ARTCC |
| `KZMA` | Miami ARTCC |
| `KZME` | Memphis ARTCC |
| `KZMP` | Minneapolis ARTCC |
| `KZNY` | New York ARTCC |
| `KZOA` | Oakland ARTCC |
| `KZOB` | Cleveland ARTCC |
| `KZSE` | Seattle ARTCC |
| `KZTL` | Atlanta ARTCC |
| `KZWY` | New York Oceanic FIR |
| `NZZO` | Auckland Oceanic FIR |
| `PAZA` | Anchorage ARTCC |
| `PAZN` | Anchorage Oceanic |
| `PGZU` | Guam ARTCC |
| `PHZH` | Honolulu Control Facility |
| `SBAO` | Atlantico FIR |
| `TJZS` | San Juan CERAP |

### `state` (`State`)

| Code | Description |
|---|---|
| `AB` | Alberta (Canada) |
| `AK` | Alaska |
| `AZ` | Arizona |
| `BC` | British Columbia (Canada) |
| `CA` | California |
| `CO` | Colorado |
| `DC` | District of Columbia |
| `FL` | Florida |
| `GA` | Georgia |
| `GU` | Guam |
| `HI` | Hawaii |
| `IL` | Illinois |
| `IN` | Indiana |
| `KS` | Kansas |
| `MB` | Manitoba (Canada) |
| `MN` | Minnesota |
| `NB` | New Brunswick (Canada) |
| `NH` | New Hampshire |
| `NL` | Newfoundland and Labrador (Canada) |
| `NM` | New Mexico |
| `NY` | New York |
| `OH` | Ohio |
| `ON` | Ontario (Canada) |
| `PR` | Puerto Rico |
| `QC` | Quebec (Canada) |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `WA` | Washington |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `locationId` | `LOCATION_ID` |
| `locationName` | `LOCATION_NAME` |
| `computerId` | `COMPUTER_ID` |
| `icaoId` | `ICAO_ID` |
| `locationType` | `LOCATION_TYPE` |
| `city` | `CITY` |
| `state` | `STATE` |
| `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` |
| `crossRef` | `CROSS_REF` |