ops_flt_data['ACFT_ID'].extend(ops_flts[op]['ACFT_ID'])
ops_flt_data['OP_TYPE'].extend(ops_flts[op]['OP_TYPE'])
ops_flt_data['PROF_ID1'].extend(ops_flts[op]['PROF_ID1'])
ops_flt_data['PROF_ID2'].extend(ops_flts[op]['PROF_ID2'])
ops_flt_data['RWY_ID'].extend(ops_flts[op]['RWY_ID'])
ops_flt_data['TRK_ID1'].extend(ops_flts[op]['TRK_ID1'])
ops_flt_data['OPS_DAY'].extend(ops_flts[op]['OPS_DAY'])
ops_flt_data['OPS_EVE'].extend(ops_flts[op]['OPS_EVE'])
ops_flt_data['OPS_NIGHT'].extend(ops_flts[op]['OPS_NIGHT'])
study_dir = 'G:/Projects/307XXX/307260_PANYNJ_Newark_Teterboro_Part_150/TEB/Task_D_Develop_NEMs/Altitude_Profiles/JED/8_SEL_INM_SDY/TEST_TEB_P150_70d_sdy/'
#study_dir = 'C:/Users/jed/Desktop/TEST_TEB_P150_70d_sdy/'
make_dbf(profile_field_dict, profile_data, 'profile', profile_order)
make_dbf(procedur_field_dict, procedur_data, 'procedur', procedur_order)
for row in range(len(ops_flt_data['ACFT_ID'])):
if ops_flt_data['PROF_ID1'][row] == 'STANDARD':
name = ops_flt_data['ACFT_ID'][row]+'_'+ops_flt_data['OP_TYPE'][row]+'_'+ops_flt_data['RWY_ID'][row]+ops_flt_data['PROF_ID1'][row]+'_'+str(ops_flt_data['PROF_ID2'][row])
else:
name = ops_flt_data['ACFT_ID'][row]+'_'+ops_flt_data['OP_TYPE'][row]+'_'+ops_flt_data['PROF_ID1'][row]+'_'+str(ops_flt_data['PROF_ID2'][row])
case_folder = 'C_' + name + '/'
data = {'ACFT_ID':[ops_flt_data['ACFT_ID'][row]],
'OP_TYPE':[ops_flt_data['OP_TYPE'][row]],
'PROF_ID1':[ops_flt_data['PROF_ID1'][row]],
'PROF_ID2':[ops_flt_data['PROF_ID2'][row]],
'RWY_ID':[ops_flt_data['RWY_ID'][row]],
'TRK_ID1':[ops_flt_data['TRK_ID1'][row]],
'OPS_DAY':[ops_flt_data['OPS_DAY'][row]],
'OPS_NIGHT':['OPS_NIGHT','N','11',6]}
order = ['ACFT_ID', 'OP_TYPE', 'PROF_ID1', 'PROF_ID2', 'RWY_ID', 'TRK_ID1', 'OPS_DAY', 'OPS_EVE', 'OPS_NIGHT']
for case in cases:
filename = study_dir + case + '/ops_flt.dbf'
acft_id = case.split('_')[1]
op_type = case.split('_')[2]
prof_id1 = case.split('_')[3]
prof_id2 = 1
if acft_id == 'S76':
rwy_id = 'S_H'
else:
if op_type == 'A':
rwy_id = '06'
elif op_type == 'D':
rwy_id = '24'
data = {'ACFT_ID':[acft_id],
'OP_TYPE':[op_type],
'PROF_ID1':[prof_id1],
'PROF_ID2':[prof_id2],
'RWY_ID':[rwy_id],
'TRK_ID1':[rwy_id + op_type],
'OPS_DAY':[1.0],
'OPS_EVE':[0.0],
'OPS_NIGHT':[0.0]}
make_dbf(field_dict, data, filename, order)
