| effDate ← EFF_DATE | String | The 28 Day NASR Subscription Effective Date in format YYYY/MM/DD | | |
| fixId ← FIX_ID | String | Fixed Geographical Position Identifier | | |
| icaoRegionCode ← ICAO_REGION_CODE | 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. | | 22 values- 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 ← STATE_CODE | FixBaseStateCode | Associated State Post Office Code - standard two letter abbreviation for US States and Territories | | 61 values- 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 ← COUNTRY_CODE | FixBaseCountryCode | Country Post Office Code identifying the country associated with the fix | | 13 values- 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
|
| latDeg ← LAT_DEG | Int | FIX Latitude Degrees component of the DMS coordinate | degrees | |
| latMin ← LAT_MIN | Int | FIX Latitude Minutes component of the DMS coordinate | minutes | |
| latSec ← LAT_SEC | Float | FIX Latitude Seconds component of the DMS coordinate | seconds | |
| latHemis ← LAT_HEMIS | LatHemis | FIX Latitude Hemisphere indicator | | |
| latDecimal ← LAT_DECIMAL | Float | FIX Latitude expressed in decimal degrees format | degrees | |
| longDeg ← LONG_DEG | Int | FIX Longitude Degrees component of the DMS coordinate | degrees | |
| longMin ← LONG_MIN | Int | FIX Longitude Minutes component of the DMS coordinate | minutes | |
| longSec ← LONG_SEC | Float | FIX Longitude Seconds component of the DMS coordinate | seconds | |
| longHemis ← LONG_HEMIS | LongHemis | FIX Longitude Hemisphere indicator | | |
| longDecimal ← LONG_DECIMAL | Float | FIX Longitude expressed in decimal degrees format | degrees | |
| fixIdOld ← FIX_ID_OLD | String | Previous name(s) of the fix before it was renamed | | |
| chartingRemark ← CHARTING_REMARK | String | Charting information and remarks describing how and where the fix is depicted on charts | | 39 values- 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 ← FIX_USE_CODE | FixUseCode | FIX Type code indicating the primary use or classification of the fix | | 8 values- 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 ← ARTCC_ID_HIGH | ArtccIdHigh | Denotes High ARTCC (Air Route Traffic Control Center) Area Of Jurisdiction identifier | | 33 values- 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 ← ARTCC_ID_LOW | ArtccIdHigh | Denotes Low ARTCC (Air Route Traffic Control Center) Area Of Jurisdiction identifier | | 33 values- 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
|
| pitchFlag ← PITCH_FLAG | ContrFuelAvbl | Indicates whether the fix is a PITCH point (part of the NAVAID-to-NAVAID airway system) | | |
| catchFlag ← CATCH_FLAG | ContrFuelAvbl | Indicates whether the fix is a CATCH point (part of the NAVAID-to-NAVAID airway system) | | |
| suaAtcaaFlag ← SUA_ATCAA_FLAG | ContrFuelAvbl | Indicates whether the fix is associated with Special Use Airspace (SUA) or ATC Assigned Airspace (ATCAA) | | |
| minRecepAlt ← MIN_RECEP_ALT | Int | Fix Minimum Reception Altitude (MRA) - the lowest altitude at which the fix can be determined | feet MSL | |
| compulsory ← 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 ← CHARTS | String | Concatenated list of charting information found in the FIX_CHRT table, separated by commas | | |