# WxlSvc

Weather services available at each weather reporting location with affected area information

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

> Ordered by WEA_ID, COUNTRY_CODE, WEA_SVC_TYPE_CODE. This is the unique record key. WEA_AFFECT_AREA may include LE, LH, LM, LO, LS for the Great Lakes (Erie, Huron, Michigan, Ontario, Superior). Replaces legacy WXL.txt Subscriber File.

## Example query

```graphql
# Introspect the WxlSvc 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) |
| `weaSvcTypeCode` | `WeaSvcTypeCode` | Weather Services Available at the reporting location |  | `AC`, `AWW`, `CWA`, … (22 values) |
| `weaAffectArea` | `String` | Affected State or Area expressed as an alphabetically ordered series of two-character US State Post Office abbreviations separated by commas. May also include LE (Lake Erie), LH (Lake Huron), LM (Lake Michigan), LO (Lake Ontario), LS (Lake Superior), CB (Caribbean), CN (Canada), HW (Hawaii), HI (Hawaii), MX (Mexico), OA (Pacific Ocean Area), OP (Other Pacific) |  |  |

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

### `weaSvcTypeCode` (`WeaSvcTypeCode`)

| Code | Description |
|---|---|
| `AC` | Severe Weather Outlook Narrative |
| `AWW` | Severe Weather Forecast Alert |
| `CWA` | Central Weather Advisory |
| `FA` | Area Forecast |
| `FD` | Winds and Temperature Aloft Forecast |
| `FT` | Aviation Terminal Forecast |
| `FX` | Miscellaneous Forecasts |
| `METAR` | Aviation Routine Weather Report (ICAO) |
| `MIS` | Meteorological Impact Summary |
| `NOTAM` | Notice to Airmen |
| `SA` | Surface Observation Report |
| `SD` | Radar Weather Report |
| `SPECI` | Aviation Special Weather Report (ICAO) |
| `TAF` | Aviation Terminal Forecast (ICAO) |
| `TWEB` | Transcribed Weather Broadcast |
| `UA` | Aircraft Report (PIREP) |
| `WA` | Weather Advisory |
| `WH` | Abbreviated Hurricane Advisory |
| `WO` | Tropical Depressions |
| `WS` | Flight Advisory - SIGMET |
| `WST` | Convective SIGMET |
| `WW` | Severe Weather Broadcasts or Bulletins |

## Column provenance

Every field maps 1:1 to a column in the `WXL_SVC` 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` |
| `weaSvcTypeCode` | `WEA_SVC_TYPE_CODE` |
| `weaAffectArea` | `WEA_AFFECT_AREA` |