# WxlBase

Base weather reporting location records with geographic and elevation data

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

> Ordered by WEA_ID, COUNTRY_CODE. This is the unique record key. Replaces legacy WXL.txt Subscriber File.

## Example query

```graphql
# Introspect the WxlBase type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    weaId
    city
    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 |  |  |
| `weaId` | `String` | Weather Reporting Location Identifier |  |  |
| `city` | `String` | Associated City Name |  |  |
| `stateCode` | `WxlBaseStateCode` | Associated State Post Office Code - standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (60 values) |
| `countryCode` | `WxlBaseCountryCode` | Country Post Office Code |  | `AG`, `AN`, `BB`, … (32 values) |
| `latDeg` | `Int` | Weather Reporting Location Latitude Degrees | degrees |  |
| `latMin` | `Int` | Weather Reporting Location Latitude Minutes | minutes |  |
| `latSec` | `Float` | Weather Reporting Location Latitude Seconds | seconds |  |
| `latHemis` | `LatHemis` | Weather Reporting Location Latitude Hemisphere |  | `N`=North; `S`=South |
| `latDecimal` | `Float` | Weather Reporting Location Latitude in Decimal Format | degrees |  |
| `longDeg` | `Int` | Weather Reporting Location Longitude Degrees | degrees |  |
| `longMin` | `Int` | Weather Reporting Location Longitude Minutes | minutes |  |
| `longSec` | `Float` | Weather Reporting Location Longitude Seconds | seconds |  |
| `longHemis` | `LongHemis` | Weather Reporting Location Longitude Hemisphere |  | `E`=East; `W`=West |
| `longDecimal` | `Float` | Weather Reporting Location Longitude in Decimal Format | degrees |  |
| `elev` | `Int` | Weather Reporting Location Elevation as a whole number value | feet MSL |  |
| `surveyMethodCode` | `ElevMethodCode` | Weather Reporting Location Elevation accuracy method indicating whether the elevation value was surveyed or estimated |  | `S`=Value was surveyed; `E`=Value was estimated |

## Enum values

### `stateCode` (`WxlBaseStateCode`)

| 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 |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QM` | Mid-Atlantic Ocean |
| `QW` | Atlantic Ocean West |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`WxlBaseCountryCode`)

| Code | Description |
|---|---|
| `AG` | Antigua and Barbuda |
| `AN` | Netherlands Antilles |
| `BB` | Barbados |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `BZ` | Belize |
| `CA` | Canada |
| `CO` | Colombia |
| `CR` | Costa Rica |
| `CU` | Cuba |
| `DM` | Dominica |
| `DO` | Dominican Republic |
| `GD` | Grenada |
| `GF` | French Guiana |
| `GP` | Guadeloupe |
| `GT` | Guatemala |
| `HN` | Honduras |
| `HT` | Haiti |
| `JM` | Jamaica |
| `KN` | Saint Kitts and Nevis |
| `KY` | Cayman Islands |
| `LC` | Saint Lucia |
| `MQ` | Martinique |
| `MX` | Mexico |
| `NI` | Nicaragua |
| `PA` | Panama |
| `SV` | El Salvador |
| `TC` | Turks and Caicos Islands |
| `TQ` | Territory of Guam (alternate code) |
| `TT` | Trinidad and Tobago |
| `US` | United States |
| `VE` | Venezuela |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `weaId` | `WEA_ID` |
| `city` | `CITY` |
| `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` |
| `elev` | `ELEV` |
| `surveyMethodCode` | `SURVEY_METHOD_CODE` |