TRACON Operations: Data Download Dictionary

From ASPMHelp
Jump to: navigation, search

This is the dictionary for the Data Download feature in OPSNET: TRACON Operations.

Field Name Type Width Description
LOCID Character 4 FAA Location ID
YYYYMMDD Character 8 Year(YYYY), Month(MM), Day(DD)
STATE Character 2 State ID
REGION Character 3 Region ID (Old Region Code)

5 = AAL: ALASKAN REGION
3 = ACE: CENTRAL REGION
1 = AEA: EASTERN REGION
C = AGL: GREAT LAKES REGION
E = ANE: NEW ENGLAND REGION
S = ANM: NORTHWEST MOUNTAIN REGION
7 = ASO: SOUTHERN REGION
2 = ASW: SOUTHWEST REGION
4 = AWP: WESTERN ‐ PACIFIC REGION

SAREA Character 2 Service Area

EE, ET ‐ Eastern Enroute, Terminal
CE, CT ‐ Centrol Enroute, Terminal
WE, WT ‐ Western Enroute, Terminal

CLASS_ID Numeric 2 Classification ID

1 ‐ Tower without Radar
2 ‐ TRACON, RAPCON, or CERAP
3 ‐ Combined TRACON & Tower with Radar
4 ‐ Combination Non‐Radar Approach Control & Tower w/o Radar
5 ‐ Non Approach Control Tower (VFR)
6 ‐ Combined Control Facility
7 ‐ Towers with Radar
8 ‐ Air Route Traffic Control Center
9 ‐ Combined TRACON
10 ‐ Reserved
11 ‐ Federal Contract Tower (FCT)
12 ‐ Non‐FAA Facility

FTYPE Character 1 Facility Type

A ‐ Tracons, Rapcons, Ceraps
B ‐ Radar Tower
C ‐ Limited Radar Tower
D ‐ Nonradar Tower
E ‐ VFR Tower
F ‐ Not an FAA Facility
G ‐ Federal Contract Tower
H ‐ Air Route Traffic Control Center

I_ITIN_AC Numeric 8 IFR Itinerant Air Carrier
I_ITIN_AT Numeric 8 IFR Itinerant Air Taxi
I_ITIN_GA Numeric 8 IFR Itinerant General Aviation
I_ITIN_MI Numeric 8 IFR Itinerant Military
V_ITIN_AC Numeric 8 VFR Itinerant Air Carrier
V_ITIN_AT Numeric 8 VFR Itinerant Air Taxi
V_ITIN_GA Numeric 8 VFR Itinerant General Aviation
V_ITIN_MI Numeric 8 VFR Itinerant Military
I_OVER_AC Numeric 8 IFR Overflights Air Carrier
I_OVER_AT Numeric 8 IFR Overflights Air Taxi
I_OVER_GA Numeric 8 IFR Overflights General Aviation
I_OVER_MI Numeric 8 IFR Overflights Military
V_OVER_AC Numeric 8 VFR Overflights Air Carrier
V_OVER_AT Numeric 8 VFR Overflights Air Taxi
V_OVER_GA Numeric 8 VFR Overflights General Aviation
V_OVER_MI Numeric 8 VFR Overflights Military
TOTAL Numeric 8 Total TRACON Operations =

I_ITIN_AC + I_ITIN_AT + I_ITIN_GA + I_ITIN_MI +
V_ITIN_AC + V_ITIN_AT + V_ITIN_GA + V_ITIN_MI + 
I_OVER_AC + I_OVER_AT + I_OVER_GA + I_OVER_MI + 
V_OVER_AC + V_OVER_AT + V_OVER_GA + V_OVER_MI