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)