68
|
OE
|
ctlr_psn_min_qty
|
Missing
|
440 Missing. Some large values (555 minutes)
|
177 missing in relevant data set, will have to excluse from some regressions
|
69
|
OE
|
ctlr_psn_otr_desc
|
Missing
|
80 missing
|
variable dropped
|
70
|
OE
|
ctlr_sctr_psn_code_oe
|
Missing. Additional Parsing
|
12 missing. Needs to be parsed further to be collapsed into small set'
|
variable dropped
|
71
|
OE
|
ctlr_trng_reltd_1yr_flag
|
Y,N,Missing
|
859 Y, 448 Missing, 197 N
|
180 missing relevant set, treat missing is no
|
72
|
OE
|
ctlr_trng_reltd_desc
|
Missing. Additional Parsing
|
654 Missing. Lots of different answers. May need to parse to collapse into aseries of flags
|
unlikely to bear fruit if parsed, most traning specifics will be related, dropping variable
|
73
|
OE
|
ctlr_wrkld_acft_qty
|
Believability
|
Range from 0 to 35. are these reasonable? 90th% is 8
|
RI only seems believable
|
74
|
OE
|
ctlr_wrksked_desc
|
Missing. Additional Parsing
|
456 missing additional parsing required to turn into usable variable
|
This is basically unusable, which is a shame.
|
75
|
OE
|
event_alt_ft_qty_oe
|
795 missing values
|
Some rounded to nearest 500 feet particularly at values 5000 and under. Since these should all be ocurring at ground level, what does it mean to have altitude of >0 ?
|
basically all zero/mssing for relevant data set, drop variable
|
76
|
OE
|
event_asp_code_oe
|
92 missing values
|
|
In relevant data set, nearly all are surface or missing, drop variable
|
77
|
OE
|
event_asp_otr_desc_oe
|
1488 coded "missing" values
|
Missing values, but all accounted for. Missing for event_asp_code_oe equal to "Other".
|
|
78
|
OE
|
event_cat flags
|
Missing, non mutually exclusive
|
replaced missing to no
|
need to double check, but in relevant data set, it looks like all have at least one yes and if there is a no, there are not missings
|
79
|
OE
|
event_cat_atcs_flag_oe
|
79 missing values
|
replaced missings with no
|
check by year, need to double check, but it appears no records contain missings and no across the 5 categories, so can likely replace missing with no and be safe
|
80
|
OE
|
event_cat_human_flag
|
variable name
|
replaced missings to no
|
check by year, need to double check, but it appears no records contain missings and no across the 5 categories, so can likely replace missing with no and be safe
|
81
|
OE
|
event_class_code
|
missing
|
71 missing values
|
D/E/missing in data set, dropping
|
82
|
OE
|
event_class_code
|
No codebook for values
|
the codebook does not have any explanation of event classes, are these incursion ratings?
|
D/E/missing in data set, dropping
|
83
|
OE
|
EVENT_RI_FLAG
|
Reliability
|
How reliably does this field indicate Ris? 994/1086 of the "Y"s match to Ris. 418/1504 are missing
|
(FROM FAA: I think this field is a preliminary determination in the field--RI database is the FINAL source. We can ignore this field.)
|
84
|
OE
|
fac_atc_ctl_code_oe
|
2 missing values
|
|
It is unclear what this variable means or contains. Only 10 "Radar" rather than "TOWER". Variable dropped
|
85
|
OE
|
fac_class_code
|
missing, codebook misreported
|
108 missing values. 52 missing on relevant set. the codebook appears to have values for fac_type_code rather than fac_class_code, as a result, it is unclear wht the codes (1-14, plus ATC-7) mean. Appears to be for pay levels (based on traffic/complexity)
|
Need additional information on classification. It may be interesting for the model.;
FAA Facility classification code. I believe this coding has changed over time. Its basically a rating of the complexity/busy-ness of the tower for employee compensation purposes (more busy, more pay). The levels are 4 through 12.
|
86
|
OE
|
fac_cnflct_alert_code_oe
|
43 missing values
|
22 missing on relevant set
|
22 missing in relevent set, will have to drop records for some regressions
|
87
|
OE
|
fac_equip_layout_flag_oe
|
4 missing values
|
1 missing on relevant set
|
drop observation if needed
|
88
|
OE
|
fac_equip_unsatfy_flag_oe
|
5 missing values
|
1 missing on relevant set. This observation also missing on fac_equip_layout_flag
|
drop observation if needed
|
89
|
OE
|
fac_id_code
|
missing
|
2 missing on relevant set. Should not use over RI data.
|
variable dropped
|
90
|
OE
|
fac_primary_code
|
No codebook for values
|
the coebook does not have any explanation of this code, all 1504 obesrvatrions (no missing) are "P"
|
variable dropped
|
91
|
OE
|
FAC_RADAR_ACDS_FLAG
|
Variable in codebook but not dataset
|
|
need variable; perhaps TRACON only
|
92
|
OE
|
FAC_RADAR_AMASS_FLAG
|
Variable in codebook but not dataset
|
|
need variable; FAA to provide
|
93
|
OE
|
FAC_RADAR_ARTS_FLAG
|
Variable in codebook but not dataset
|
|
need variable; perhaps TRACON only
|
94
|
OE
|
fac_radar_artsii_flag_oe
|
Value of "Y" and missing
|
Assume that missings are "N"s, but it is possible that some records may be missing for other reasons.
|
recode missing as "NO"
|
95
|
OE
|
fac_radar_artsiia_flag_oe
|
1,202 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode missing as "NO"
|
96
|
OE
|
fac_radar_artsiiia_flag_oe
|
1,156 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode missing as "NO"
|
97
|
OE
|
fac_radar_artsiiie_flag_oe
|
867 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode missing as "NO"
|
98
|
OE
|
fac_radar_asdeii_flag_oe
|
1192 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode missing as "NO"
|
99
|
OE
|
fac_radar_asdeiii_flag_oe
|
1007 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode missing as "NO"
|
100
|
OE
|
FAC_RADAR_ASDEX_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
101
|
OE
|
FAC_RADAR_ASR11_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
102
|
OE
|
fac_radar_asr9_flag_oe
|
639 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode mising as "NO", check against ASR11
|
103
|
OE
|
fac_radar_brd_band_flag_oe
|
Variable in dataset but not codebook, 1194 missing, others are Y, N
|
|
what is this variable?
|
104
|
OE
|
fac_radar_britiv_flag_oe
|
1189 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
verify that having neither is due to time of date
|
105
|
OE
|
fac_radar_cenrap_flag_oe
|
1,202 missing. Value of "Y", "N", and missing. 1 Y.
|
Unclear on difference between N and missing
|
variable dropped
|
106
|
OE
|
fac_radar_darc_flag_oe
|
Variable in dataset but not codebook. 1,119 missing. Value of "Y", "N", and missing.
|
Unclear on difference between N and missing
|
never yes in the relevant data set, variable dropped
|
107
|
OE
|
fac_radar_dbrite_flag_oe
|
898 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
verify that having neither is due to time of date
|
108
|
OE
|
fac_radar_earts_flag_oe
|
1,188 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
variable dropped
|
109
|
OE
|
FAC_RADAR_EBUS_HOST_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
110
|
OE
|
FAC_RADAR_HOST_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
111
|
OE
|
FAC_RADAR_MODEL1_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
112
|
OE
|
fac_radar_modes_flag_oe
|
964 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
what does it mean to have a NO (missing) for Mode-S?; seems logical
|
113
|
OE
|
fac_radar_nrw_band_flag_oe
|
Variable in dataset but not codebook. 1,200 missing. Value of "Y", "N", and missing.
|
|
what is this variable?
|
114
|
OE
|
FAC_RADAR_OASIS_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
115
|
OE
|
fac_radar_otr_desc_oe
|
1,155 missing values. Inconsistent entiries.
|
Missing values, but the 349 yes for fac_radar_otr_flag_oe is equivilent to the number of desc entries
|
will have ot parse for radar variables kept elsewhere
|
116
|
OE
|
fac_radar_otr_flag_oe
|
956 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
recode missing as "NO"
|
117
|
OE
|
FAC_RADAR_STARS_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
118
|
OE
|
fac_radar_trsn_desc_oe
|
1503 missing.
|
Missing values, but consistent with 1 "Y" in fac_radar_trsn_flag_oe
|
|
119
|
OE
|
fac_radar_trsn_flag_oe
|
18 missing values.
|
1 Y
|
variable dropped
|
120
|
OE
|
FAC_RADAR_URET_FLAG
|
Variable in codebook but not dataset
|
|
need variable
|
121
|
OE
|
fac_rgn_code
|
No codebook for values
|
Found an alternate site with codings
|
|
122
|
OE
|
fac_rgn_code
|
missing values
|
variable agrees with reg_n and duplicates values. Use reg_n for region information
|
|
123
|
OE
|
fac_type_code
|
missing
|
1202 missing values
|
all Ris are "other" or "missing". Drop variable
|
124
|
OE
|
fctr_cmplx_asp_flag_oe
|
1,160 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
125
|
OE
|
fctr_cmplx_emerg_flag_oe
|
1,184 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
126
|
OE
|
fctr_cmplx_expr_flag_oe
|
1,011 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
127
|
OE
|
fctr_cmplx_flow_ctl_flag_oe
|
1,166 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
128
|
OE
|
fctr_cmplx_na_flag_oe
|
Variable in dataset but not codebook. 1,202 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
129
|
OE
|
fctr_cmplx_nbr_acft_flag_oe
|
632 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
130
|
OE
|
fctr_cmplx_otr_desc_oe
|
1,097 missing. All values unique descriptions.
|
Missing values, but more than for 614 coded as "other" in fctr_cmplx_otr_flag_oe equal to "Other".
|
variable dropped
|
131
|
OE
|
fctr_cmplx_otr_flag_oe
|
867 missing. Value of "Y", "N", and missing
|
Unclear on difference between N and missing
|
Treat missing as N.
|
|
