python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SyctomXV_Mask_23Q4 -j sla_mensuel -v --date=2024-12 --rootfolder_sla=/data_2/data_log/job/memo/SyctomXV ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2024-12 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SyctomXV_Mask_23Q4"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4932 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4932 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4932 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4932 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} We expected an STS datou with a camera_place_name, so there is a PB, datou_id: 4932 ! {'id': 4932, 'name': 'split_time_score_cod_upm_SyctomXV_Mask_23Q1', 'limit_max': 150, 'nb_steps': 1, 'estimated_time': 8640, 'list_steps': [{'id': 14066, 'type': 'split_time_score_with_photo', 'param': '0', 'json_param_as_string': "{'cod': 1, 'camera_place_name': 'SyctomXV_Mask_23Q4', 'ETA': 8640, 'param_moyenne_mobile': 5, 'thcl': 3379, 'list_task_complete': [''], 'list_tasks': 'LOAD,ORDER,CONVENTION,SPLIT_BY_DARK,SPLIT_TIME, CREATE_PORT_LAUNCH_CARAC_FILL_DASHBOARD,READ_PLATE', 'forced_hashtag': 'entrant', 'list_hashtag_class_create': 'entrant', 'ponderation': '0.001,0.001,0.001,0.001,0.001', 'host': 'www.fotonower.com', 'interval': 10, 'datou_proportion_papier': {'test': 370, 'entrant': 4742}, 'check_plate_format': 1, 'input_default_values': []}", 'json_param': {'cod': 1, 'camera_place_name': 'SyctomXV_Mask_23Q4', 'ETA': 8640, 'param_moyenne_mobile': 5, 'thcl': 3379, 'list_task_complete': [''], 'list_tasks': 'LOAD,ORDER,CONVENTION,SPLIT_BY_DARK,SPLIT_TIME, CREATE_PORT_LAUNCH_CARAC_FILL_DASHBOARD,READ_PLATE', 'forced_hashtag': 'entrant', 'list_hashtag_class_create': 'entrant', 'ponderation': '0.001,0.001,0.001,0.001,0.001', 'host': 'www.fotonower.com', 'interval': 10, 'datou_proportion_papier': {'test': 370, 'entrant': 4742}, 'check_plate_format': 1, 'input_default_values': []}, 'nb_input': 2, 'nb_output': 1, 'prod': False, 'is_local': False, 'is_datou_depend': False, 'is_photo_id_local': False, 'list_data': []}], 'depends_step': []} check if it is the case where we have multiple sts in one datou yes, we found a datou with multiple sts, we will choose the last one by default SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=370 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=370 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 370 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=370 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'min_score': 0.7, 'name_pipeline': 'proportion_papier_tapis', 'hashtag_type': 705, 'hashtag_proportion': 492668766, 'hashtag_parmi': 538914404, 'hashtag_to_consider': 'papier_only', 'hashtag_background': 493012381} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier ventilate_hashtags_in_portfolio step not found ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4742 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4742 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4742 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4742 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 13169 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13170 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 13167 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 13167 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13174 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13168 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 13171 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13172 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13173 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 13175 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13169 have datatype=11 whereas input 0 of step 13167 have datatype=2 WARNING : type of output 1 of step 13170 doesn't seem to be define in the database( WARNING : type of input 3 of step 13168 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13170 doesn't seem to be define in the database( WARNING : type of input 1 of step 13167 doesn't seem to be define in the database( WARNING : output 0 of step 13174 have datatype=10 whereas input 3 of step 13173 have datatype=6 WARNING : type of input 1 of step 13174 doesn't seem to be define in the database( WARNING : output 1 of step 13167 have datatype=7 whereas input 1 of step 13174 have datatype=None WARNING : type of output 1 of step 13174 doesn't seem to be define in the database( WARNING : type of input 4 of step 13168 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13169 doesn't seem to be define in the database( WARNING : type of input 1 of step 13170 doesn't seem to be define in the database( DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4857, 'hashtag_proportion': 'sac_om_plein,textiles,verre,organique,dasri,masque,encombrant,autre_non_emballage', 'hashtag_parmi': 'papier,carton,metal,pet_clair,pehd,flux_dev,film_dev_souple,ela', 'hashtag_weights': {'papier': 3, 'carton': 2.8, 'metal': 6, 'pet_clair': 1.4, 'pehd': 2.8, 'flux_dev': 2.8, 'pet_opaque': 3, 'barquette_opaque': 2.8, 'film_dev_souple': 0.8, 'ela': 3.0, 'sac_om_plein': 6.5, 'textiles': 3, 'verre': 10.0, 'organique': 4.0, 'dasri': 2.0, 'masque': 1, 'encombrant': 7, 'autre_emballage': 6.0, 'autre_non_emballage': 6.0}, 'check_plaque': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SyctomXV_Mask_23Q4"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4932 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4932 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4932 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4932 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} We expected an STS datou with a camera_place_name, so there is a PB, datou_id: 4932 ! {'id': 4932, 'name': 'split_time_score_cod_upm_SyctomXV_Mask_23Q1', 'limit_max': 150, 'nb_steps': 1, 'estimated_time': 8640, 'list_steps': [{'id': 14066, 'type': 'split_time_score_with_photo', 'param': '0', 'json_param_as_string': "{'cod': 1, 'camera_place_name': 'SyctomXV_Mask_23Q4', 'ETA': 8640, 'param_moyenne_mobile': 5, 'thcl': 3379, 'list_task_complete': [''], 'list_tasks': 'LOAD,ORDER,CONVENTION,SPLIT_BY_DARK,SPLIT_TIME, CREATE_PORT_LAUNCH_CARAC_FILL_DASHBOARD,READ_PLATE', 'forced_hashtag': 'entrant', 'list_hashtag_class_create': 'entrant', 'ponderation': '0.001,0.001,0.001,0.001,0.001', 'host': 'www.fotonower.com', 'interval': 10, 'datou_proportion_papier': {'test': 370, 'entrant': 4742}, 'check_plate_format': 1, 'input_default_values': []}", 'json_param': {'cod': 1, 'camera_place_name': 'SyctomXV_Mask_23Q4', 'ETA': 8640, 'param_moyenne_mobile': 5, 'thcl': 3379, 'list_task_complete': [''], 'list_tasks': 'LOAD,ORDER,CONVENTION,SPLIT_BY_DARK,SPLIT_TIME, CREATE_PORT_LAUNCH_CARAC_FILL_DASHBOARD,READ_PLATE', 'forced_hashtag': 'entrant', 'list_hashtag_class_create': 'entrant', 'ponderation': '0.001,0.001,0.001,0.001,0.001', 'host': 'www.fotonower.com', 'interval': 10, 'datou_proportion_papier': {'test': 370, 'entrant': 4742}, 'check_plate_format': 1, 'input_default_values': []}, 'nb_input': 2, 'nb_output': 1, 'prod': False, 'is_local': False, 'is_datou_depend': False, 'is_photo_id_local': False, 'list_data': []}], 'depends_step': []} check if it is the case where we have multiple sts in one datou yes, we found a datou with multiple sts, we will choose the last one by default SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=370 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=370 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 370 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=370 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'min_score': 0.7, 'name_pipeline': 'proportion_papier_tapis', 'hashtag_type': 705, 'hashtag_proportion': 492668766, 'hashtag_parmi': 538914404, 'hashtag_to_consider': 'papier_only', 'hashtag_background': 493012381} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier ventilate_hashtags_in_portfolio step not found ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4742 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4742 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4742 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4742 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 13169 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13170 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 13167 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 13167 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13174 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13168 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 13171 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13172 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13173 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 13175 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13169 have datatype=11 whereas input 0 of step 13167 have datatype=2 WARNING : type of output 1 of step 13170 doesn't seem to be define in the database( WARNING : type of input 3 of step 13168 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13170 doesn't seem to be define in the database( WARNING : type of input 1 of step 13167 doesn't seem to be define in the database( WARNING : output 0 of step 13174 have datatype=10 whereas input 3 of step 13173 have datatype=6 WARNING : type of input 1 of step 13174 doesn't seem to be define in the database( WARNING : output 1 of step 13167 have datatype=7 whereas input 1 of step 13174 have datatype=None WARNING : type of output 1 of step 13174 doesn't seem to be define in the database( WARNING : type of input 4 of step 13168 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13169 doesn't seem to be define in the database( WARNING : type of input 1 of step 13170 doesn't seem to be define in the database( DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4857, 'hashtag_proportion': 'sac_om_plein,textiles,verre,organique,dasri,masque,encombrant,autre_non_emballage', 'hashtag_parmi': 'papier,carton,metal,pet_clair,pehd,flux_dev,film_dev_souple,ela', 'hashtag_weights': {'papier': 3, 'carton': 2.8, 'metal': 6, 'pet_clair': 1.4, 'pehd': 2.8, 'flux_dev': 2.8, 'pet_opaque': 3, 'barquette_opaque': 2.8, 'film_dev_souple': 0.8, 'ela': 3.0, 'sac_om_plein': 6.5, 'textiles': 3, 'verre': 10.0, 'organique': 4.0, 'dasri': 2.0, 'masque': 1, 'encombrant': 7, 'autre_emballage': 6.0, 'autre_non_emballage': 6.0}, 'check_plaque': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 188 month : 12 mtr_id : dashboard_places : SyctomXV_Mask_23Q4 date : 2024-12 year : 2024 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SyctomXV_Mask_23Q4' and date like '%2024-12%') and created_at like '%2024-12%'))); nb_day : (6, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 188 and month(ded.date) = 12 and year(ded.date) = 2024 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______entrant' and ded.dashboard_place_id = 188 and month(ded.date) = 12 and year(ded.date) = 2024 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 188 and mp.name like '%122024%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2024-12-01 : dt_date_just_month_year : 2024-12-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SyctomXV_Mask_23Q4" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2024-12-01" AND ded.date <= "2024-12-31" apple3 {'test': {'mat': 'test', 'pht': 0, 'datou_carac_id': 370, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 538914404}, 'entrant': {'mat': 'entrant', 'pht': 4857, 'datou_carac_id': 4742, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'papier,carton,metal,pet_clair,pehd,flux_dev,film_dev_souple,ela'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1453783,1457413,1472017,1471968,1475260,1480923,1480912,1480879,1480786,1480763,1481050,1521364,1521336,1521294) AND dr.mtr_portfolio_id=ptp.mtr_portfolio_id_1 AND dr.qualite >= 0 AND mpp.mtr_portfolio_id=ptp.mtr_portfolio_id_2 AND pcr.portfolio_id=ptp.mtr_portfolio_id_1 AND h.hashtag_id = pcr.hashtag_id AND ptp.type = pcr.hashtag_type AND mpp.hide_status = 0 AND ptp.hashtag_id=h.hashtag_id AND ptp.type IN (0,4857) group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'autre_non_emballage', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02938235691925842, 'nb_photo': 794, 'list_port_cont': '18931108,18931127,18935147,18935166,18956150,18956169,18968521,18968540,18969568,18969597,18971945,18971964,19079888,19079907,19080890,19080918,19098597,19098616,19099698,19099753,19100686,19100712,19115539,19115568,19118002,19118028,19136347,19136367,19176632,19176721,19176740,19177035,19177055,19177272,19177291,19177380,19177823,19177842,19177886,19177968,19177987,19178056,19178240,19178612,19178667,19178795,19178814,19178842,19178861,19178958,19178977,19179028,19179098,19179118,19179193,19179212,19179262,19179308,19179327,19179386,19179405,19179431,19179500,19179519,19333893,19333921,19335132,19335158,19455440,19456107,19456126,19457840,19467908,19467927,19487001,19487893,19487912,19489259,19489278,19506753,19571435,19571454,19572718,19572737', 'assoc_port': '18879290:18935147,18879290:18935166,18879291:18931108,18879291:18931127,18939988:18956150,18939988:18956169,18941899:18969568,18941899:18969597,18941980:18971945,18941980:18971964,18942377:18968521,18942377:18968540,19061644:19178795,19061644:19178814,19061645:19178842,19061645:19178861,19061693:19079888,19061693:19079907,19061694:19099698,19061694:19099753,19061695:19100686,19061695:19100712,19061849:19115539,19061849:19115568,19062627:19080890,19062627:19080918,19062628:19098597,19062628:19098616,19082880:19178958,19082880:19178977,19082881:19118002,19082881:19118028,19119419:19179028,19119530:19178612,19119530:19178667,19120122:19179262,19120123:19177380,19120421:19179308,19120421:19179327,19120422:19179386,19120422:19179405,19120761:19179431,19120762:19179500,19120762:19179519,19121348:19176632,19121349:19179193,19121349:19179212,19121350:19176721,19121350:19176740,19121351:19177035,19121351:19177055,19121352:19177272,19121352:19177291,19121761:19178240,19121762:19177823,19121762:19177842,19123092:1917909', 'assoc_mat': '18879290:autre_non_emballage:4857:18935147,18879290:autre_non_emballage:4857:18935166,18879291:autre_non_emballage:4857:18931108,18879291:autre_non_emballage:4857:18931127,18939988:autre_non_emballage:4857:18956150,18939988:autre_non_emballage:4857:18956169,18941899:autre_non_emballage:4857:18969568,18941899:autre_non_emballage:4857:18969597,18941980:autre_non_emballage:4857:18971945,18941980:autre_non_emballage:4857:18971964,18942377:autre_non_emballage:4857:18968521,18942377:autre_non_emballage:4857:18968540,19061644:autre_non_emballage:4857:19178795,19061644:autre_non_emballage:4857:19178814,19061645:autre_non_emballage:4857:19178842,19061645:autre_non_emballage:4857:19178861,19061693:autre_non_emballage:4857:19079888,19061693:autre_non_emballage:4857:19079907,19061694:autre_non_emballage:4857:19099698,19061694:autre_non_emballage:4857:19099753,19061695:autre_non_emballage:4857:19100686,19061695:autre_non_emballage:4857:19100712,19061849:autre_non_emballage:4857:19115539,19061849:autre_non_emballage:4857:1'}, {'unwanted_material': 'carton', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.5909515428448618, 'nb_photo': 11359, 'list_port_cont': '18931094,18931113,18935133,18935152,18956136,18956155,18967966,18967986,18968507,18968526,18969554,18969583,18971931,18971950,18972744,18972763,19079874,19079893,19080876,19080904,19098583,19098602,19099684,19099739,19100671,19100698,19115525,19115554,19115721,19115745,19117987,19118014,19136333,19136353,19140424,19140452,19140688,19140713,19176267,19176286,19176618,19176637,19176707,19176726,19177021,19177041,19177258,19177277,19177347,19177366,19177462,19177481,19177599,19177619,19177809,19177828,19177853,19177872,19177954,19177973,19178023,19178042,19178067,19178086,19178113,19178132,19178207,19178226,19178598,19178653,19178781,19178800,19178828,19178847,19178897,19178916,19178944,19178963,19179014,19179033,19179084,19179104,19179133,19179153,19179179,19179198,19179248,19179267,19179294,19179313,19179372,19179391,19179417,19179436,19179486,19179505,19333879,19333907,19335118,19335144,19455426,19455445,19456093,19456112,19457826,19457846,19467894,19467913,19475099,19475118,19486987,19487006,19487879,1948789', 'assoc_port': '18879290:18935133,18879290:18935152,18879291:18931094,18879291:18931113,18939988:18956136,18939988:18956155,18941899:18969554,18941899:18969583,18941980:18971931,18941980:18971950,18942192:18972744,18942192:18972763,18942376:18967966,18942376:18967986,18942377:18968507,18942377:18968526,19061644:19178781,19061644:19178800,19061645:19178828,19061645:19178847,19061693:19079874,19061693:19079893,19061694:19099684,19061694:19099739,19061695:19100671,19061695:19100698,19061849:19115525,19061849:19115554,19061850:19115721,19061850:19115745,19062627:19080876,19062627:19080904,19062628:19098583,19062628:19098602,19062629:19178897,19062629:19178916,19082880:19178944,19082880:19178963,19082881:19117987,19082881:19118014,19119419:19179014,19119419:19179033,19119530:19178598,19119530:19178653,19120122:19179248,19120122:19179267,19120123:19177347,19120123:19177366,19120421:19179294,19120421:19179313,19120422:19179372,19120422:19179391,19120760:19177599,19120760:19177619,19120761:19179417,19120761:19179436,19120762:1917948', 'assoc_mat': '18879290:carton:4857:18935133,18879290:carton:4857:18935152,18879291:carton:4857:18931094,18879291:carton:4857:18931113,18939988:carton:4857:18956136,18939988:carton:4857:18956155,18941899:carton:4857:18969554,18941899:carton:4857:18969583,18941980:carton:4857:18971931,18941980:carton:4857:18971950,18942192:carton:4857:18972744,18942192:carton:4857:18972763,18942376:carton:4857:18967966,18942376:carton:4857:18967986,18942377:carton:4857:18968507,18942377:carton:4857:18968526,19061644:carton:4857:19178781,19061644:carton:4857:19178800,19061645:carton:4857:19178828,19061645:carton:4857:19178847,19061693:carton:4857:19079874,19061693:carton:4857:19079893,19061694:carton:4857:19099684,19061694:carton:4857:19099739,19061695:carton:4857:19100671,19061695:carton:4857:19100698,19061849:carton:4857:19115525,19061849:carton:4857:19115554,19061850:carton:4857:19115721,19061850:carton:4857:19115745,19062627:carton:4857:19080876,19062627:carton:4857:19080904,19062628:carton:4857:19098583,19062628:carton:4857:19098602,1906'}, {'unwanted_material': 'dasri', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.0, 'nb_photo': 5, 'list_port_cont': '19177864,19178034', 'assoc_port': '19124099:19177864,19124200:19178034', 'assoc_mat': '19124099:dasri:4857:19177864,19124200:dasri:4857:19178034'}, {'unwanted_material': 'ela', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.007356838113043555, 'nb_photo': 100, 'list_port_cont': '18931100,18931119,18935139,18935158,18968513,18968532,19079880,19079899,19080882,19080910,19098589,19098608,19099690,19099745,19100678,19100704,19115531,19115560,19140694,19140719,19176624,19176643,19176713,19176732,19177027,19177047,19177264,19177283,19177372,19177468,19177487,19177605,19177626,19177960,19178048,19178073,19178092,19178119,19178138,19178213,19178232,19178659,19178806,19178969,19179039,19179090,19179110,19179139,19179159,19179319,19179397,19179442,19333913,19335124,19335150,19456118,19457832,19457852,19467900,19467919,19489251,19489270,19572710,19572729', 'assoc_port': '18879290:18935139,18879290:18935158,18879291:18931100,18879291:18931119,18942377:18968513,18942377:18968532,19061644:19178806,19061693:19079880,19061693:19079899,19061694:19099690,19061694:19099745,19061695:19100678,19061695:19100704,19061849:19115531,19061849:19115560,19062627:19080882,19062627:19080910,19062628:19098589,19062628:19098608,19082880:19178969,19119419:19179039,19119530:19178659,19120123:19177372,19120421:19179319,19120422:19179397,19120760:19177605,19120760:19177626,19120761:19179442,19121173:19177468,19121173:19177487,19121348:19176624,19121348:19176643,19121350:19176713,19121350:19176732,19121351:19177027,19121351:19177047,19121352:19177264,19121352:19177283,19121761:19178213,19121761:19178232,19122779:19179139,19122779:19179159,19122782:19140694,19122782:19140719,19123092:19179090,19123092:19179110,19124096:19178119,19124096:19178138,19124100:19178073,19124100:19178092,19124200:19178048,19124201:19177960,19324569:19335124,19324569:19335150,19324570:19333913,19451566:19489251,19451566:1948927', 'assoc_mat': '18879290:ela:4857:18935139,18879290:ela:4857:18935158,18879291:ela:4857:18931100,18879291:ela:4857:18931119,18942377:ela:4857:18968513,18942377:ela:4857:18968532,19061644:ela:4857:19178806,19061693:ela:4857:19079880,19061693:ela:4857:19079899,19061694:ela:4857:19099690,19061694:ela:4857:19099745,19061695:ela:4857:19100678,19061695:ela:4857:19100704,19061849:ela:4857:19115531,19061849:ela:4857:19115560,19062627:ela:4857:19080882,19062627:ela:4857:19080910,19062628:ela:4857:19098589,19062628:ela:4857:19098608,19082880:ela:4857:19178969,19119419:ela:4857:19179039,19119530:ela:4857:19178659,19120123:ela:4857:19177372,19120421:ela:4857:19179319,19120422:ela:4857:19179397,19120760:ela:4857:19177605,19120760:ela:4857:19177626,19120761:ela:4857:19179442,19121173:ela:4857:19177468,19121173:ela:4857:19177487,19121348:ela:4857:19176624,19121348:ela:4857:19176643,19121350:ela:4857:19176713,19121350:ela:4857:19176732,19121351:ela:4857:19177027,19121351:ela:4857:19177047,19121352:ela:4857:19177264,19121352:ela:4857:1917728'}, {'unwanted_material': 'encombrant', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.024245367728555192, 'nb_photo': 9, 'list_port_cont': '18931126,18967979,18967999,18971944,18971963,19118001,19118027,19177841,19179385,19467907,19467926,19475112,19475131', 'assoc_port': '18879291:18931126,18941980:18971944,18941980:18971963,18942376:18967979,18942376:18967999,19082881:19118001,19082881:19118027,19120422:19179385,19121762:19177841,19451719:19467907,19451719:19467926,19451721:19475112,19451721:19475131', 'assoc_mat': '18879291:encombrant:4857:18931126,18941980:encombrant:4857:18971944,18941980:encombrant:4857:18971963,18942376:encombrant:4857:18967979,18942376:encombrant:4857:18967999,19082881:encombrant:4857:19118001,19082881:encombrant:4857:19118027,19120422:encombrant:4857:19179385,19121762:encombrant:4857:19177841,19451719:encombrant:4857:19467907,19451719:encombrant:4857:19467926,19451721:encombrant:4857:19475112,19451721:encombrant:4857:19475131'}, {'unwanted_material': 'film_dev_souple', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02753387418414352, 'nb_photo': 1677, 'list_port_cont': '18931099,18931118,18935138,18935157,18956141,18956160,18967971,18967991,18968512,18968531,18969559,18969588,18971936,18971955,18972749,18972768,19079879,19079898,19080881,19080909,19098588,19098607,19099689,19099744,19100677,19100703,19115530,19115559,19115726,19115750,19117992,19118019,19136338,19136358,19140429,19140457,19140693,19140718,19176272,19176291,19176623,19176642,19176712,19176731,19177026,19177046,19177263,19177282,19177352,19177371,19177467,19177486,19177604,19177625,19177814,19177833,19177858,19177877,19177959,19177978,19178028,19178047,19178072,19178091,19178118,19178137,19178212,19178231,19178603,19178658,19178805,19178968,19179038,19179089,19179109,19179138,19179158,19179272,19179318,19179396,19179441,19179510,19333884,19333912,19335123,19335149,19455431,19455450,19456098,19456117,19457831,19457851,19467899,19467918,19475104,19475123,19486992,19487011,19487884,19487903,19489250,19489269,19506763,19571426,19571445,19572709,19572728', 'assoc_port': '18879290:18935138,18879290:18935157,18879291:18931099,18879291:18931118,18939988:18956141,18939988:18956160,18941899:18969559,18941899:18969588,18941980:18971936,18941980:18971955,18942192:18972749,18942192:18972768,18942376:18967971,18942376:18967991,18942377:18968512,18942377:18968531,19061644:19178805,19061693:19079879,19061693:19079898,19061694:19099689,19061694:19099744,19061695:19100677,19061695:19100703,19061849:19115530,19061849:19115559,19061850:19115726,19061850:19115750,19062627:19080881,19062627:19080909,19062628:19098588,19062628:19098607,19082880:19178968,19082881:19117992,19082881:19118019,19119419:19179038,19119530:19178603,19119530:19178658,19120122:19179272,19120123:19177352,19120123:19177371,19120421:19179318,19120422:19179396,19120760:19177604,19120760:19177625,19120761:19179441,19120762:19179510,19121173:19177467,19121173:19177486,19121348:19176623,19121348:19176642,19121350:19176712,19121350:19176731,19121351:19177026,19121351:19177046,19121352:19177263,19121352:19177282,19121761:1917821', 'assoc_mat': '18879290:film_dev_souple:4857:18935138,18879290:film_dev_souple:4857:18935157,18879291:film_dev_souple:4857:18931099,18879291:film_dev_souple:4857:18931118,18939988:film_dev_souple:4857:18956141,18939988:film_dev_souple:4857:18956160,18941899:film_dev_souple:4857:18969559,18941899:film_dev_souple:4857:18969588,18941980:film_dev_souple:4857:18971936,18941980:film_dev_souple:4857:18971955,18942192:film_dev_souple:4857:18972749,18942192:film_dev_souple:4857:18972768,18942376:film_dev_souple:4857:18967971,18942376:film_dev_souple:4857:18967991,18942377:film_dev_souple:4857:18968512,18942377:film_dev_souple:4857:18968531,19061644:film_dev_souple:4857:19178805,19061693:film_dev_souple:4857:19079879,19061693:film_dev_souple:4857:19079898,19061694:film_dev_souple:4857:19099689,19061694:film_dev_souple:4857:19099744,19061695:film_dev_souple:4857:19100677,19061695:film_dev_souple:4857:19100703,19061849:film_dev_souple:4857:19115530,19061849:film_dev_souple:4857:19115559,19061850:film_dev_souple:4857:19115726,19061850:f'}, {'unwanted_material': 'flux_dev', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02867813702836465, 'nb_photo': 897, 'list_port_cont': '18931098,18931117,18935137,18935156,18956140,18956159,18967970,18967990,18968511,18968530,18969558,18969587,18971935,18971954,18972748,18972767,19079878,19079897,19080880,19080908,19098587,19098606,19099688,19099743,19100676,19100702,19115529,19115558,19117991,19118018,19136337,19136357,19140428,19140456,19140692,19140717,19176271,19176290,19176622,19176641,19176711,19176730,19177025,19177045,19177262,19177281,19177351,19177370,19177466,19177485,19177603,19177624,19177813,19177832,19177857,19177876,19177958,19177977,19178027,19178046,19178071,19178090,19178117,19178136,19178211,19178230,19178602,19178657,19178785,19178804,19178832,19178851,19178948,19178967,19179018,19179037,19179088,19179108,19179137,19179157,19179183,19179202,19179252,19179271,19179298,19179317,19179376,19179395,19179421,19179440,19179490,19179509,19333883,19333911,19335122,19335148,19455430,19455449,19456097,19456116,19467898,19467917,19475103,19475122,19486991,19487010,19487883,19487902,19489249,19489268,19506762,19571425,19571444,1957270', 'assoc_port': '18879290:18935137,18879290:18935156,18879291:18931098,18879291:18931117,18939988:18956140,18939988:18956159,18941899:18969558,18941899:18969587,18941980:18971935,18941980:18971954,18942192:18972748,18942192:18972767,18942376:18967970,18942376:18967990,18942377:18968511,18942377:18968530,19061644:19178785,19061644:19178804,19061645:19178832,19061645:19178851,19061693:19079878,19061693:19079897,19061694:19099688,19061694:19099743,19061695:19100676,19061695:19100702,19061849:19115529,19061849:19115558,19062627:19080880,19062627:19080908,19062628:19098587,19062628:19098606,19082880:19178948,19082880:19178967,19082881:19117991,19082881:19118018,19119419:19179018,19119419:19179037,19119530:19178602,19119530:19178657,19120122:19179252,19120122:19179271,19120123:19177351,19120123:19177370,19120421:19179298,19120421:19179317,19120422:19179376,19120422:19179395,19120760:19177603,19120760:19177624,19120761:19179421,19120761:19179440,19120762:19179490,19120762:19179509,19121173:19177466,19121173:19177485,19121348:1917662', 'assoc_mat': '18879290:flux_dev:4857:18935137,18879290:flux_dev:4857:18935156,18879291:flux_dev:4857:18931098,18879291:flux_dev:4857:18931117,18939988:flux_dev:4857:18956140,18939988:flux_dev:4857:18956159,18941899:flux_dev:4857:18969558,18941899:flux_dev:4857:18969587,18941980:flux_dev:4857:18971935,18941980:flux_dev:4857:18971954,18942192:flux_dev:4857:18972748,18942192:flux_dev:4857:18972767,18942376:flux_dev:4857:18967970,18942376:flux_dev:4857:18967990,18942377:flux_dev:4857:18968511,18942377:flux_dev:4857:18968530,19061644:flux_dev:4857:19178785,19061644:flux_dev:4857:19178804,19061645:flux_dev:4857:19178832,19061645:flux_dev:4857:19178851,19061693:flux_dev:4857:19079878,19061693:flux_dev:4857:19079897,19061694:flux_dev:4857:19099688,19061694:flux_dev:4857:19099743,19061695:flux_dev:4857:19100676,19061695:flux_dev:4857:19100702,19061849:flux_dev:4857:19115529,19061849:flux_dev:4857:19115558,19062627:flux_dev:4857:19080880,19062627:flux_dev:4857:19080908,19062628:flux_dev:4857:19098587,19062628:flux_dev:4857:19098606,'}, {'unwanted_material': 'masque', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.0008057284073268392, 'nb_photo': 3, 'list_port_cont': '18972756,18972775,19179403', 'assoc_port': '18942192:18972756,18942192:18972775,19120422:19179403', 'assoc_mat': '18942192:masque:4857:18972756,18942192:masque:4857:18972775,19120422:masque:4857:19179403'}, {'unwanted_material': 'metal', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.055083991228555396, 'nb_photo': 1153, 'list_port_cont': '18931095,18931114,18935134,18935153,18967967,18967987,18968508,18968527,18969555,18969584,18971932,18971951,18972745,18972764,19079875,19079894,19080877,19080905,19098584,19098603,19099685,19099740,19100672,19100699,19115526,19115555,19115722,19115746,19117988,19118015,19136334,19136354,19140425,19140453,19140689,19140714,19176619,19176638,19176708,19176727,19177022,19177042,19177259,19177278,19177348,19177367,19177463,19177482,19177600,19177620,19177810,19177829,19177854,19177873,19177955,19177974,19178024,19178043,19178068,19178087,19178114,19178133,19178208,19178227,19178599,19178654,19178782,19178801,19178829,19178848,19178945,19178964,19179015,19179034,19179085,19179105,19179134,19179154,19179180,19179199,19179249,19179268,19179295,19179314,19179373,19179392,19179418,19179437,19179487,19179506,19333880,19333908,19335119,19335145,19455427,19455446,19456094,19456113,19457827,19457847,19467895,19467914,19486988,19487007,19487880,19487899,19489246,19489265,19506740,19571422,19571441,19572705,19572724', 'assoc_port': '18879290:18935134,18879290:18935153,18879291:18931095,18879291:18931114,18941899:18969555,18941899:18969584,18941980:18971932,18941980:18971951,18942192:18972745,18942192:18972764,18942376:18967967,18942376:18967987,18942377:18968508,18942377:18968527,19061644:19178782,19061644:19178801,19061645:19178829,19061645:19178848,19061693:19079875,19061693:19079894,19061694:19099685,19061694:19099740,19061695:19100672,19061695:19100699,19061849:19115526,19061849:19115555,19061850:19115722,19061850:19115746,19062627:19080877,19062627:19080905,19062628:19098584,19062628:19098603,19082880:19178945,19082880:19178964,19082881:19117988,19082881:19118015,19119419:19179015,19119419:19179034,19119530:19178599,19119530:19178654,19120122:19179249,19120122:19179268,19120123:19177348,19120123:19177367,19120421:19179295,19120421:19179314,19120422:19179373,19120422:19179392,19120760:19177600,19120760:19177620,19120761:19179418,19120761:19179437,19120762:19179487,19120762:19179506,19121173:19177463,19121173:19177482,19121348:1917661', 'assoc_mat': '18879290:metal:4857:18935134,18879290:metal:4857:18935153,18879291:metal:4857:18931095,18879291:metal:4857:18931114,18941899:metal:4857:18969555,18941899:metal:4857:18969584,18941980:metal:4857:18971932,18941980:metal:4857:18971951,18942192:metal:4857:18972745,18942192:metal:4857:18972764,18942376:metal:4857:18967967,18942376:metal:4857:18967987,18942377:metal:4857:18968508,18942377:metal:4857:18968527,19061644:metal:4857:19178782,19061644:metal:4857:19178801,19061645:metal:4857:19178829,19061645:metal:4857:19178848,19061693:metal:4857:19079875,19061693:metal:4857:19079894,19061694:metal:4857:19099685,19061694:metal:4857:19099740,19061695:metal:4857:19100672,19061695:metal:4857:19100699,19061849:metal:4857:19115526,19061849:metal:4857:19115555,19061850:metal:4857:19115722,19061850:metal:4857:19115746,19062627:metal:4857:19080877,19062627:metal:4857:19080905,19062628:metal:4857:19098584,19062628:metal:4857:19098603,19082880:metal:4857:19178945,19082880:metal:4857:19178964,19082881:metal:4857:19117988,19082881:'}, {'unwanted_material': 'papier', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.13749776840136102, 'nb_photo': 3173, 'list_port_cont': '18931093,18931112,18935132,18935151,18956135,18956154,18967965,18967985,18968506,18968525,18969553,18969582,18971930,18971949,18972743,18972762,19079873,19079892,19080875,19080903,19098582,19098601,19099683,19099738,19100670,19100697,19115524,19115553,19115720,19115743,19117986,19118013,19136332,19136352,19140423,19140451,19140687,19140712,19176266,19176285,19176617,19176636,19176706,19176725,19177020,19177040,19177257,19177276,19177346,19177365,19177461,19177480,19177598,19177618,19177808,19177827,19177852,19177871,19177953,19177972,19178022,19178041,19178066,19178085,19178112,19178131,19178206,19178225,19178597,19178652,19178780,19178799,19178827,19178846,19178943,19178962,19179013,19179032,19179083,19179103,19179132,19179152,19179178,19179197,19179247,19179266,19179293,19179312,19179371,19179390,19179416,19179435,19179485,19179504,19333878,19333906,19335117,19335143,19455425,19455444,19456092,19456111,19457825,19457845,19467893,19467912,19475098,19475117,19486986,19487005,19487878,19487897,19489244,1948926', 'assoc_port': '18879290:18935132,18879290:18935151,18879291:18931093,18879291:18931112,18939988:18956135,18939988:18956154,18941899:18969553,18941899:18969582,18941980:18971930,18941980:18971949,18942192:18972743,18942192:18972762,18942376:18967965,18942376:18967985,18942377:18968506,18942377:18968525,19061644:19178780,19061644:19178799,19061645:19178827,19061645:19178846,19061693:19079873,19061693:19079892,19061694:19099683,19061694:19099738,19061695:19100670,19061695:19100697,19061849:19115524,19061849:19115553,19061850:19115720,19061850:19115743,19062627:19080875,19062627:19080903,19062628:19098582,19062628:19098601,19082880:19178943,19082880:19178962,19082881:19117986,19082881:19118013,19119419:19179013,19119419:19179032,19119530:19178597,19119530:19178652,19120122:19179247,19120122:19179266,19120123:19177346,19120123:19177365,19120421:19179293,19120421:19179312,19120422:19179371,19120422:19179390,19120760:19177598,19120760:19177618,19120761:19179416,19120761:19179435,19120762:19179485,19120762:19179504,19121173:1917746', 'assoc_mat': '18879290:papier:4857:18935132,18879290:papier:4857:18935151,18879291:papier:4857:18931093,18879291:papier:4857:18931112,18939988:papier:4857:18956135,18939988:papier:4857:18956154,18941899:papier:4857:18969553,18941899:papier:4857:18969582,18941980:papier:4857:18971930,18941980:papier:4857:18971949,18942192:papier:4857:18972743,18942192:papier:4857:18972762,18942376:papier:4857:18967965,18942376:papier:4857:18967985,18942377:papier:4857:18968506,18942377:papier:4857:18968525,19061644:papier:4857:19178780,19061644:papier:4857:19178799,19061645:papier:4857:19178827,19061645:papier:4857:19178846,19061693:papier:4857:19079873,19061693:papier:4857:19079892,19061694:papier:4857:19099683,19061694:papier:4857:19099738,19061695:papier:4857:19100670,19061695:papier:4857:19100697,19061849:papier:4857:19115524,19061849:papier:4857:19115553,19061850:papier:4857:19115720,19061850:papier:4857:19115743,19062627:papier:4857:19080875,19062627:papier:4857:19080903,19062628:papier:4857:19098582,19062628:papier:4857:19098601,1908'}, {'unwanted_material': 'pehd', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.008694406286314592, 'nb_photo': 271, 'list_port_cont': '18931097,18931116,18935136,18935155,18956139,18956158,18967969,18967989,18968510,18968529,18969557,18969586,18971934,18971953,18972747,18972766,19079877,19079896,19080879,19080907,19098586,19098605,19099687,19099742,19115528,19115557,19115724,19115748,19117990,19118017,19136336,19136356,19140427,19140455,19140691,19140716,19176270,19176289,19176621,19176640,19176710,19176729,19177024,19177044,19177261,19177280,19177350,19177369,19177465,19177484,19177602,19177623,19177812,19177831,19177856,19177875,19177957,19177976,19178026,19178045,19178070,19178116,19178135,19178210,19178229,19178601,19178656,19178784,19178803,19178831,19178850,19178947,19178966,19179017,19179036,19179087,19179107,19179136,19179156,19179182,19179201,19179251,19179270,19179297,19179316,19179375,19179394,19179420,19179439,19179489,19179508,19333910,19455429,19455448,19467897,19467916,19487882,19487901,19489248,19489267,19506742,19506761,19571424,19571443,19572707,19572726', 'assoc_port': '18879290:18935136,18879290:18935155,18879291:18931097,18879291:18931116,18939988:18956139,18939988:18956158,18941899:18969557,18941899:18969586,18941980:18971934,18941980:18971953,18942192:18972747,18942192:18972766,18942376:18967969,18942376:18967989,18942377:18968510,18942377:18968529,19061644:19178784,19061644:19178803,19061645:19178831,19061645:19178850,19061693:19079877,19061693:19079896,19061694:19099687,19061694:19099742,19061849:19115528,19061849:19115557,19061850:19115724,19061850:19115748,19062627:19080879,19062627:19080907,19062628:19098586,19062628:19098605,19082880:19178947,19082880:19178966,19082881:19117990,19082881:19118017,19119419:19179017,19119419:19179036,19119530:19178601,19119530:19178656,19120122:19179251,19120122:19179270,19120123:19177350,19120123:19177369,19120421:19179297,19120421:19179316,19120422:19179375,19120422:19179394,19120760:19177602,19120760:19177623,19120761:19179420,19120761:19179439,19120762:19179489,19120762:19179508,19121173:19177465,19121173:19177484,19121348:1917662', 'assoc_mat': '18879290:pehd:4857:18935136,18879290:pehd:4857:18935155,18879291:pehd:4857:18931097,18879291:pehd:4857:18931116,18939988:pehd:4857:18956139,18939988:pehd:4857:18956158,18941899:pehd:4857:18969557,18941899:pehd:4857:18969586,18941980:pehd:4857:18971934,18941980:pehd:4857:18971953,18942192:pehd:4857:18972747,18942192:pehd:4857:18972766,18942376:pehd:4857:18967969,18942376:pehd:4857:18967989,18942377:pehd:4857:18968510,18942377:pehd:4857:18968529,19061644:pehd:4857:19178784,19061644:pehd:4857:19178803,19061645:pehd:4857:19178831,19061645:pehd:4857:19178850,19061693:pehd:4857:19079877,19061693:pehd:4857:19079896,19061694:pehd:4857:19099687,19061694:pehd:4857:19099742,19061849:pehd:4857:19115528,19061849:pehd:4857:19115557,19061850:pehd:4857:19115724,19061850:pehd:4857:19115748,19062627:pehd:4857:19080879,19062627:pehd:4857:19080907,19062628:pehd:4857:19098586,19062628:pehd:4857:19098605,19082880:pehd:4857:19178947,19082880:pehd:4857:19178966,19082881:pehd:4857:19117990,19082881:pehd:4857:19118017,19119419:pehd:48'}, {'unwanted_material': 'pet_clair', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.020800550400248825, 'nb_photo': 1575, 'list_port_cont': '18931096,18931115,18935135,18935154,18956138,18956157,18967968,18967988,18968509,18968528,18969556,18969585,18971933,18971952,18972746,18972765,19079876,19079895,19080878,19080906,19098585,19098604,19099686,19099741,19100673,19100700,19115527,19115556,19115723,19115747,19117989,19118016,19136335,19136355,19140426,19140454,19140690,19140715,19176269,19176288,19176620,19176639,19176709,19176728,19177023,19177043,19177260,19177279,19177349,19177368,19177464,19177483,19177601,19177621,19177811,19177830,19177855,19177874,19177956,19177975,19178025,19178044,19178069,19178088,19178115,19178134,19178209,19178228,19178600,19178655,19178783,19178802,19178830,19178849,19178946,19178965,19179016,19179035,19179086,19179106,19179135,19179155,19179181,19179200,19179250,19179269,19179296,19179315,19179374,19179393,19179419,19179438,19179488,19179507,19333881,19333909,19335120,19335146,19455428,19455447,19456095,19456114,19457828,19457848,19467896,19467915,19475101,19475120,19486989,19487008,19487881,19487900,19489247,1948926', 'assoc_port': '18879290:18935135,18879290:18935154,18879291:18931096,18879291:18931115,18939988:18956138,18939988:18956157,18941899:18969556,18941899:18969585,18941980:18971933,18941980:18971952,18942192:18972746,18942192:18972765,18942376:18967968,18942376:18967988,18942377:18968509,18942377:18968528,19061644:19178783,19061644:19178802,19061645:19178830,19061645:19178849,19061693:19079876,19061693:19079895,19061694:19099686,19061694:19099741,19061695:19100673,19061695:19100700,19061849:19115527,19061849:19115556,19061850:19115723,19061850:19115747,19062627:19080878,19062627:19080906,19062628:19098585,19062628:19098604,19082880:19178946,19082880:19178965,19082881:19117989,19082881:19118016,19119419:19179016,19119419:19179035,19119530:19178600,19119530:19178655,19120122:19179250,19120122:19179269,19120123:19177349,19120123:19177368,19120421:19179296,19120421:19179315,19120422:19179374,19120422:19179393,19120760:19177601,19120760:19177621,19120761:19179419,19120761:19179438,19120762:19179488,19120762:19179507,19121173:1917746', 'assoc_mat': '18879290:pet_clair:4857:18935135,18879290:pet_clair:4857:18935154,18879291:pet_clair:4857:18931096,18879291:pet_clair:4857:18931115,18939988:pet_clair:4857:18956138,18939988:pet_clair:4857:18956157,18941899:pet_clair:4857:18969556,18941899:pet_clair:4857:18969585,18941980:pet_clair:4857:18971933,18941980:pet_clair:4857:18971952,18942192:pet_clair:4857:18972746,18942192:pet_clair:4857:18972765,18942376:pet_clair:4857:18967968,18942376:pet_clair:4857:18967988,18942377:pet_clair:4857:18968509,18942377:pet_clair:4857:18968528,19061644:pet_clair:4857:19178783,19061644:pet_clair:4857:19178802,19061645:pet_clair:4857:19178830,19061645:pet_clair:4857:19178849,19061693:pet_clair:4857:19079876,19061693:pet_clair:4857:19079895,19061694:pet_clair:4857:19099686,19061694:pet_clair:4857:19099741,19061695:pet_clair:4857:19100673,19061695:pet_clair:4857:19100700,19061849:pet_clair:4857:19115527,19061849:pet_clair:4857:19115556,19061850:pet_clair:4857:19115723,19061850:pet_clair:4857:19115747,19062627:pet_clair:4857:19080878,1'}, {'unwanted_material': 'sac_om_plein', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.20422874167683033, 'nb_photo': 1334, 'list_port_cont': '18931101,18931120,18935140,18935159,18956143,18956162,18967973,18967993,18968514,18968533,18969561,18969590,18971938,18971957,18972751,18972770,19079881,19079900,19080883,19080911,19098590,19098609,19099691,19099746,19100679,19100705,19115532,19115561,19115728,19115753,19117994,19118021,19136340,19136360,19140431,19140459,19140695,19140720,19176274,19176293,19176625,19176644,19176714,19176733,19177028,19177048,19177265,19177284,19177354,19177373,19177469,19177488,19177606,19177627,19177816,19177835,19177860,19177879,19177961,19177980,19178030,19178049,19178074,19178093,19178120,19178139,19178214,19178233,19178605,19178660,19178788,19178807,19178835,19178854,19178951,19178970,19179021,19179040,19179091,19179111,19179140,19179160,19179186,19179205,19179255,19179274,19179301,19179320,19179379,19179398,19179424,19179443,19179493,19179512,19333886,19333914,19335125,19335151,19455433,19455452,19456100,19456119,19457833,19457853,19467901,19467920,19475106,19475125,19486994,19487013,19487886,19487905,19489252,1948927', 'assoc_port': '18879290:18935140,18879290:18935159,18879291:18931101,18879291:18931120,18939988:18956143,18939988:18956162,18941899:18969561,18941899:18969590,18941980:18971938,18941980:18971957,18942192:18972751,18942192:18972770,18942376:18967973,18942376:18967993,18942377:18968514,18942377:18968533,19061644:19178788,19061644:19178807,19061645:19178835,19061645:19178854,19061693:19079881,19061693:19079900,19061694:19099691,19061694:19099746,19061695:19100679,19061695:19100705,19061849:19115532,19061849:19115561,19061850:19115728,19061850:19115753,19062627:19080883,19062627:19080911,19062628:19098590,19062628:19098609,19082880:19178951,19082880:19178970,19082881:19117994,19082881:19118021,19119419:19179021,19119419:19179040,19119530:19178605,19119530:19178660,19120122:19179255,19120122:19179274,19120123:19177354,19120123:19177373,19120421:19179301,19120421:19179320,19120422:19179379,19120422:19179398,19120760:19177606,19120760:19177627,19120761:19179424,19120761:19179443,19120762:19179493,19120762:19179512,19121173:1917746', 'assoc_mat': '18879290:sac_om_plein:4857:18935140,18879290:sac_om_plein:4857:18935159,18879291:sac_om_plein:4857:18931101,18879291:sac_om_plein:4857:18931120,18939988:sac_om_plein:4857:18956143,18939988:sac_om_plein:4857:18956162,18941899:sac_om_plein:4857:18969561,18941899:sac_om_plein:4857:18969590,18941980:sac_om_plein:4857:18971938,18941980:sac_om_plein:4857:18971957,18942192:sac_om_plein:4857:18972751,18942192:sac_om_plein:4857:18972770,18942376:sac_om_plein:4857:18967973,18942376:sac_om_plein:4857:18967993,18942377:sac_om_plein:4857:18968514,18942377:sac_om_plein:4857:18968533,19061644:sac_om_plein:4857:19178788,19061644:sac_om_plein:4857:19178807,19061645:sac_om_plein:4857:19178835,19061645:sac_om_plein:4857:19178854,19061693:sac_om_plein:4857:19079881,19061693:sac_om_plein:4857:19079900,19061694:sac_om_plein:4857:19099691,19061694:sac_om_plein:4857:19099746,19061695:sac_om_plein:4857:19100679,19061695:sac_om_plein:4857:19100705,19061849:sac_om_plein:4857:19115532,19061849:sac_om_plein:4857:19115561,19061850:sac_om_'}, {'unwanted_material': 'textiles', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.010069962291664132, 'nb_photo': 196, 'list_port_cont': '18931102,18931121,18935141,18935160,18956144,18956163,18969562,18969591,18971939,18971958,18972752,19079882,19079901,19098591,19098610,19100680,19100706,19115533,19115562,19136341,19136361,19140696,19140721,19176275,19176294,19176626,19176645,19176715,19176734,19177029,19177049,19177355,19177607,19177628,19177836,19177861,19177880,19177981,19178215,19178234,19178789,19178808,19178836,19178855,19178952,19178971,19179022,19179041,19179092,19179112,19179187,19179206,19179256,19179275,19179302,19179321,19179380,19179399,19179425,19179444,19179494,19179513,19333887,19333915,19455434,19455453,19456101,19456120,19457834,19457854,19486995,19487014,19489253,19489272,19506747,19506766', 'assoc_port': '18879290:18935141,18879290:18935160,18879291:18931102,18879291:18931121,18939988:18956144,18939988:18956163,18941899:18969562,18941899:18969591,18941980:18971939,18941980:18971958,18942192:18972752,19061644:19178789,19061644:19178808,19061645:19178836,19061645:19178855,19061693:19079882,19061693:19079901,19061695:19100680,19061695:19100706,19061849:19115533,19061849:19115562,19062628:19098591,19062628:19098610,19082880:19178952,19082880:19178971,19119419:19179022,19119419:19179041,19120122:19179256,19120122:19179275,19120123:19177355,19120421:19179302,19120421:19179321,19120422:19179380,19120422:19179399,19120760:19177607,19120760:19177628,19120761:19179425,19120761:19179444,19120762:19179494,19120762:19179513,19121348:19176626,19121348:19176645,19121349:19179187,19121349:19179206,19121350:19176715,19121350:19176734,19121351:19177029,19121351:19177049,19121761:19178215,19121761:19178234,19121762:19177836,19122780:19176275,19122780:19176294,19122782:19140696,19122782:19140721,19123092:19179092,19123092:1917911', 'assoc_mat': '18879290:textiles:4857:18935141,18879290:textiles:4857:18935160,18879291:textiles:4857:18931102,18879291:textiles:4857:18931121,18939988:textiles:4857:18956144,18939988:textiles:4857:18956163,18941899:textiles:4857:18969562,18941899:textiles:4857:18969591,18941980:textiles:4857:18971939,18941980:textiles:4857:18971958,18942192:textiles:4857:18972752,19061644:textiles:4857:19178789,19061644:textiles:4857:19178808,19061645:textiles:4857:19178836,19061645:textiles:4857:19178855,19061693:textiles:4857:19079882,19061693:textiles:4857:19079901,19061695:textiles:4857:19100680,19061695:textiles:4857:19100706,19061849:textiles:4857:19115533,19061849:textiles:4857:19115562,19062628:textiles:4857:19098591,19062628:textiles:4857:19098610,19082880:textiles:4857:19178952,19082880:textiles:4857:19178971,19119419:textiles:4857:19179022,19119419:textiles:4857:19179041,19120122:textiles:4857:19179256,19120122:textiles:4857:19179275,19120123:textiles:4857:19177355,19120421:textiles:4857:19179302,19120421:textiles:4857:19179321,'}, {'unwanted_material': 'verre', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.012965507188723175, 'nb_photo': 37, 'list_port_cont': '19115534,19115563,19115730,19115755,19136342,19136362,19140697,19140722,19178953,19178972,19179042,19179188,19179207,19179303,19179381,19179426,19179445,19179495,19179514,19333916', 'assoc_port': '19061849:19115534,19061849:19115563,19061850:19115730,19061850:19115755,19082880:19178953,19082880:19178972,19119419:19179042,19120421:19179303,19120422:19179381,19120761:19179426,19120761:19179445,19120762:19179495,19120762:19179514,19121349:19179188,19121349:19179207,19122782:19140697,19122782:19140722,19123093:19136342,19123093:19136362,19324570:19333916', 'assoc_mat': '19061849:verre:4857:19115534,19061849:verre:4857:19115563,19061850:verre:4857:19115730,19061850:verre:4857:19115755,19082880:verre:4857:19178953,19082880:verre:4857:19178972,19119419:verre:4857:19179042,19120421:verre:4857:19179303,19120422:verre:4857:19179381,19120761:verre:4857:19179426,19120761:verre:4857:19179445,19120762:verre:4857:19179495,19120762:verre:4857:19179514,19121349:verre:4857:19179188,19121349:verre:4857:19179207,19122782:verre:4857:19140697,19122782:verre:4857:19140722,19123093:verre:4857:19136342,19123093:verre:4857:19136362,19324570:verre:4857:19333916'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(1453783,1457413,1472017,1471968,1475260,1480923,1480912,1480879,1480786,1480763,1481050,1521364,1521336,1521294)); after get_hostname_from_raspi hasthag : entrant hasthag that could be used but not yet : _______papier,carton,metal,pet_clair,pehd,flux_dev,film_dev_souple,ela SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______entrant' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=188 and date >='2024-12-01' and date <= '2024-12-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((600,),), 'unwanted_material_monthly_percentage': ((0.2099124318620656,),), 'material_repartition': (('entrant', 568),), 'material_dict': {'entrant': 568}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2024, 12, 2), 0.2508067585957011, 21), (datetime.date(2024, 12, 6), 0.16231281559130883, 15), (datetime.date(2024, 12, 7), 0.16134498582994541, 61), (datetime.date(2024, 12, 9), 0.3336292878327366, 24), (datetime.date(2024, 12, 12), 0.25728088920326303, 77), (datetime.date(2024, 12, 13), 0.23335021454096755, 40), (datetime.date(2024, 12, 14), 0.1092044133886686, 36), (datetime.date(2024, 12, 16), 0.18236003747021667, 74), (datetime.date(2024, 12, 17), 0.23205389494726658, 83), (datetime.date(2024, 12, 18), 0.18524914506201048, 49), (datetime.date(2024, 12, 19), 0.2173558023973865, 88), (datetime.date(2024, 12, 27), 0.18099292940939735, 32), (datetime.date(2024, 12, 28), 0.19102718411673753, 46), (datetime.date(2024, 12, 30), 0.18472766267316953, 23)), 'impurety_average_data_per_hashtag': {'entrant': ((datetime.date(2024, 12, 2), 0.2508067585957011, 21), (datetime.date(2024, 12, 6), 0.16231281559130883, 15), (datetime.date(2024, 12, 7), 0.16134498582994541, 61), (datetime.date(2024, 12, 9), 0.3336292878327366, 24), (datetime.date(2024, 12, 12), 0.25728088920326303, 77), (datetime.date(2024, 12, 13), 0.23335021454096755, 40), (datetime.date(2024, 12, 14), 0.1092044133886686, 36), (datetime.date(2024, 12, 16), 0.18236003747021667, 74), (datetime.date(2024, 12, 17), 0.23205389494726658, 83), (datetime.date(2024, 12, 18), 0.18524914506201048, 49), (datetime.date(2024, 12, 19), 0.2173558023973865, 88), (datetime.date(2024, 12, 27), 0.18099292940939735, 32), (datetime.date(2024, 12, 28), 0.19102718411673753, 46), (datetime.date(2024, 12, 30), 0.18472766267316953, 23))}, 'quality_array': [], 'number_of_batch': ((61,),), 'datou_id_sts': 4932, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_non_emballage', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02938235691925842, 'nb_photo': 794, 'list_port_cont': '18931108,18931127,18935147,18935166,18956150,18956169,18968521,18968540,18969568,18969597,18971945,18971964,19079888,19079907,19080890,19080918,19098597,19098616,19099698,19099753,19100686,19100712,19115539,19115568,19118002,19118028,19136347,19136367,19176632,19176721,19176740,19177035,19177055,19177272,19177291,19177380,19177823,19177842,19177886,19177968,19177987,19178056,19178240,19178612,19178667,19178795,19178814,19178842,19178861,19178958,19178977,19179028,19179098,19179118,19179193,19179212,19179262,19179308,19179327,19179386,19179405,19179431,19179500,19179519,19333893,19333921,19335132,19335158,19455440,19456107,19456126,19457840,19467908,19467927,19487001,19487893,19487912,19489259,19489278,19506753,19571435,19571454,19572718,19572737', 'assoc_port': '18879290:18935147,18879290:18935166,18879291:18931108,18879291:18931127,18939988:18956150,18939988:18956169,18941899:18969568,18941899:18969597,18941980:18971945,18941980:18971964,18942377:18968521,18942377:18968540,19061644:19178795,19061644:19178814,19061645:19178842,19061645:19178861,19061693:19079888,19061693:19079907,19061694:19099698,19061694:19099753,19061695:19100686,19061695:19100712,19061849:19115539,19061849:19115568,19062627:19080890,19062627:19080918,19062628:19098597,19062628:19098616,19082880:19178958,19082880:19178977,19082881:19118002,19082881:19118028,19119419:19179028,19119530:19178612,19119530:19178667,19120122:19179262,19120123:19177380,19120421:19179308,19120421:19179327,19120422:19179386,19120422:19179405,19120761:19179431,19120762:19179500,19120762:19179519,19121348:19176632,19121349:19179193,19121349:19179212,19121350:19176721,19121350:19176740,19121351:19177035,19121351:19177055,19121352:19177272,19121352:19177291,19121761:19178240,19121762:19177823,19121762:19177842,19123092:1917909', 'assoc_mat': '18879290:autre_non_emballage:4857:18935147,18879290:autre_non_emballage:4857:18935166,18879291:autre_non_emballage:4857:18931108,18879291:autre_non_emballage:4857:18931127,18939988:autre_non_emballage:4857:18956150,18939988:autre_non_emballage:4857:18956169,18941899:autre_non_emballage:4857:18969568,18941899:autre_non_emballage:4857:18969597,18941980:autre_non_emballage:4857:18971945,18941980:autre_non_emballage:4857:18971964,18942377:autre_non_emballage:4857:18968521,18942377:autre_non_emballage:4857:18968540,19061644:autre_non_emballage:4857:19178795,19061644:autre_non_emballage:4857:19178814,19061645:autre_non_emballage:4857:19178842,19061645:autre_non_emballage:4857:19178861,19061693:autre_non_emballage:4857:19079888,19061693:autre_non_emballage:4857:19079907,19061694:autre_non_emballage:4857:19099698,19061694:autre_non_emballage:4857:19099753,19061695:autre_non_emballage:4857:19100686,19061695:autre_non_emballage:4857:19100712,19061849:autre_non_emballage:4857:19115539,19061849:autre_non_emballage:4857:1'}, {'unwanted_material': 'carton', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.5909515428448618, 'nb_photo': 11359, 'list_port_cont': '18931094,18931113,18935133,18935152,18956136,18956155,18967966,18967986,18968507,18968526,18969554,18969583,18971931,18971950,18972744,18972763,19079874,19079893,19080876,19080904,19098583,19098602,19099684,19099739,19100671,19100698,19115525,19115554,19115721,19115745,19117987,19118014,19136333,19136353,19140424,19140452,19140688,19140713,19176267,19176286,19176618,19176637,19176707,19176726,19177021,19177041,19177258,19177277,19177347,19177366,19177462,19177481,19177599,19177619,19177809,19177828,19177853,19177872,19177954,19177973,19178023,19178042,19178067,19178086,19178113,19178132,19178207,19178226,19178598,19178653,19178781,19178800,19178828,19178847,19178897,19178916,19178944,19178963,19179014,19179033,19179084,19179104,19179133,19179153,19179179,19179198,19179248,19179267,19179294,19179313,19179372,19179391,19179417,19179436,19179486,19179505,19333879,19333907,19335118,19335144,19455426,19455445,19456093,19456112,19457826,19457846,19467894,19467913,19475099,19475118,19486987,19487006,19487879,1948789', 'assoc_port': '18879290:18935133,18879290:18935152,18879291:18931094,18879291:18931113,18939988:18956136,18939988:18956155,18941899:18969554,18941899:18969583,18941980:18971931,18941980:18971950,18942192:18972744,18942192:18972763,18942376:18967966,18942376:18967986,18942377:18968507,18942377:18968526,19061644:19178781,19061644:19178800,19061645:19178828,19061645:19178847,19061693:19079874,19061693:19079893,19061694:19099684,19061694:19099739,19061695:19100671,19061695:19100698,19061849:19115525,19061849:19115554,19061850:19115721,19061850:19115745,19062627:19080876,19062627:19080904,19062628:19098583,19062628:19098602,19062629:19178897,19062629:19178916,19082880:19178944,19082880:19178963,19082881:19117987,19082881:19118014,19119419:19179014,19119419:19179033,19119530:19178598,19119530:19178653,19120122:19179248,19120122:19179267,19120123:19177347,19120123:19177366,19120421:19179294,19120421:19179313,19120422:19179372,19120422:19179391,19120760:19177599,19120760:19177619,19120761:19179417,19120761:19179436,19120762:1917948', 'assoc_mat': '18879290:carton:4857:18935133,18879290:carton:4857:18935152,18879291:carton:4857:18931094,18879291:carton:4857:18931113,18939988:carton:4857:18956136,18939988:carton:4857:18956155,18941899:carton:4857:18969554,18941899:carton:4857:18969583,18941980:carton:4857:18971931,18941980:carton:4857:18971950,18942192:carton:4857:18972744,18942192:carton:4857:18972763,18942376:carton:4857:18967966,18942376:carton:4857:18967986,18942377:carton:4857:18968507,18942377:carton:4857:18968526,19061644:carton:4857:19178781,19061644:carton:4857:19178800,19061645:carton:4857:19178828,19061645:carton:4857:19178847,19061693:carton:4857:19079874,19061693:carton:4857:19079893,19061694:carton:4857:19099684,19061694:carton:4857:19099739,19061695:carton:4857:19100671,19061695:carton:4857:19100698,19061849:carton:4857:19115525,19061849:carton:4857:19115554,19061850:carton:4857:19115721,19061850:carton:4857:19115745,19062627:carton:4857:19080876,19062627:carton:4857:19080904,19062628:carton:4857:19098583,19062628:carton:4857:19098602,1906'}, {'unwanted_material': 'dasri', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.0, 'nb_photo': 5, 'list_port_cont': '19177864,19178034', 'assoc_port': '19124099:19177864,19124200:19178034', 'assoc_mat': '19124099:dasri:4857:19177864,19124200:dasri:4857:19178034'}, {'unwanted_material': 'ela', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.007356838113043555, 'nb_photo': 100, 'list_port_cont': '18931100,18931119,18935139,18935158,18968513,18968532,19079880,19079899,19080882,19080910,19098589,19098608,19099690,19099745,19100678,19100704,19115531,19115560,19140694,19140719,19176624,19176643,19176713,19176732,19177027,19177047,19177264,19177283,19177372,19177468,19177487,19177605,19177626,19177960,19178048,19178073,19178092,19178119,19178138,19178213,19178232,19178659,19178806,19178969,19179039,19179090,19179110,19179139,19179159,19179319,19179397,19179442,19333913,19335124,19335150,19456118,19457832,19457852,19467900,19467919,19489251,19489270,19572710,19572729', 'assoc_port': '18879290:18935139,18879290:18935158,18879291:18931100,18879291:18931119,18942377:18968513,18942377:18968532,19061644:19178806,19061693:19079880,19061693:19079899,19061694:19099690,19061694:19099745,19061695:19100678,19061695:19100704,19061849:19115531,19061849:19115560,19062627:19080882,19062627:19080910,19062628:19098589,19062628:19098608,19082880:19178969,19119419:19179039,19119530:19178659,19120123:19177372,19120421:19179319,19120422:19179397,19120760:19177605,19120760:19177626,19120761:19179442,19121173:19177468,19121173:19177487,19121348:19176624,19121348:19176643,19121350:19176713,19121350:19176732,19121351:19177027,19121351:19177047,19121352:19177264,19121352:19177283,19121761:19178213,19121761:19178232,19122779:19179139,19122779:19179159,19122782:19140694,19122782:19140719,19123092:19179090,19123092:19179110,19124096:19178119,19124096:19178138,19124100:19178073,19124100:19178092,19124200:19178048,19124201:19177960,19324569:19335124,19324569:19335150,19324570:19333913,19451566:19489251,19451566:1948927', 'assoc_mat': '18879290:ela:4857:18935139,18879290:ela:4857:18935158,18879291:ela:4857:18931100,18879291:ela:4857:18931119,18942377:ela:4857:18968513,18942377:ela:4857:18968532,19061644:ela:4857:19178806,19061693:ela:4857:19079880,19061693:ela:4857:19079899,19061694:ela:4857:19099690,19061694:ela:4857:19099745,19061695:ela:4857:19100678,19061695:ela:4857:19100704,19061849:ela:4857:19115531,19061849:ela:4857:19115560,19062627:ela:4857:19080882,19062627:ela:4857:19080910,19062628:ela:4857:19098589,19062628:ela:4857:19098608,19082880:ela:4857:19178969,19119419:ela:4857:19179039,19119530:ela:4857:19178659,19120123:ela:4857:19177372,19120421:ela:4857:19179319,19120422:ela:4857:19179397,19120760:ela:4857:19177605,19120760:ela:4857:19177626,19120761:ela:4857:19179442,19121173:ela:4857:19177468,19121173:ela:4857:19177487,19121348:ela:4857:19176624,19121348:ela:4857:19176643,19121350:ela:4857:19176713,19121350:ela:4857:19176732,19121351:ela:4857:19177027,19121351:ela:4857:19177047,19121352:ela:4857:19177264,19121352:ela:4857:1917728'}, {'unwanted_material': 'encombrant', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.024245367728555192, 'nb_photo': 9, 'list_port_cont': '18931126,18967979,18967999,18971944,18971963,19118001,19118027,19177841,19179385,19467907,19467926,19475112,19475131', 'assoc_port': '18879291:18931126,18941980:18971944,18941980:18971963,18942376:18967979,18942376:18967999,19082881:19118001,19082881:19118027,19120422:19179385,19121762:19177841,19451719:19467907,19451719:19467926,19451721:19475112,19451721:19475131', 'assoc_mat': '18879291:encombrant:4857:18931126,18941980:encombrant:4857:18971944,18941980:encombrant:4857:18971963,18942376:encombrant:4857:18967979,18942376:encombrant:4857:18967999,19082881:encombrant:4857:19118001,19082881:encombrant:4857:19118027,19120422:encombrant:4857:19179385,19121762:encombrant:4857:19177841,19451719:encombrant:4857:19467907,19451719:encombrant:4857:19467926,19451721:encombrant:4857:19475112,19451721:encombrant:4857:19475131'}, {'unwanted_material': 'film_dev_souple', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02753387418414352, 'nb_photo': 1677, 'list_port_cont': '18931099,18931118,18935138,18935157,18956141,18956160,18967971,18967991,18968512,18968531,18969559,18969588,18971936,18971955,18972749,18972768,19079879,19079898,19080881,19080909,19098588,19098607,19099689,19099744,19100677,19100703,19115530,19115559,19115726,19115750,19117992,19118019,19136338,19136358,19140429,19140457,19140693,19140718,19176272,19176291,19176623,19176642,19176712,19176731,19177026,19177046,19177263,19177282,19177352,19177371,19177467,19177486,19177604,19177625,19177814,19177833,19177858,19177877,19177959,19177978,19178028,19178047,19178072,19178091,19178118,19178137,19178212,19178231,19178603,19178658,19178805,19178968,19179038,19179089,19179109,19179138,19179158,19179272,19179318,19179396,19179441,19179510,19333884,19333912,19335123,19335149,19455431,19455450,19456098,19456117,19457831,19457851,19467899,19467918,19475104,19475123,19486992,19487011,19487884,19487903,19489250,19489269,19506763,19571426,19571445,19572709,19572728', 'assoc_port': '18879290:18935138,18879290:18935157,18879291:18931099,18879291:18931118,18939988:18956141,18939988:18956160,18941899:18969559,18941899:18969588,18941980:18971936,18941980:18971955,18942192:18972749,18942192:18972768,18942376:18967971,18942376:18967991,18942377:18968512,18942377:18968531,19061644:19178805,19061693:19079879,19061693:19079898,19061694:19099689,19061694:19099744,19061695:19100677,19061695:19100703,19061849:19115530,19061849:19115559,19061850:19115726,19061850:19115750,19062627:19080881,19062627:19080909,19062628:19098588,19062628:19098607,19082880:19178968,19082881:19117992,19082881:19118019,19119419:19179038,19119530:19178603,19119530:19178658,19120122:19179272,19120123:19177352,19120123:19177371,19120421:19179318,19120422:19179396,19120760:19177604,19120760:19177625,19120761:19179441,19120762:19179510,19121173:19177467,19121173:19177486,19121348:19176623,19121348:19176642,19121350:19176712,19121350:19176731,19121351:19177026,19121351:19177046,19121352:19177263,19121352:19177282,19121761:1917821', 'assoc_mat': '18879290:film_dev_souple:4857:18935138,18879290:film_dev_souple:4857:18935157,18879291:film_dev_souple:4857:18931099,18879291:film_dev_souple:4857:18931118,18939988:film_dev_souple:4857:18956141,18939988:film_dev_souple:4857:18956160,18941899:film_dev_souple:4857:18969559,18941899:film_dev_souple:4857:18969588,18941980:film_dev_souple:4857:18971936,18941980:film_dev_souple:4857:18971955,18942192:film_dev_souple:4857:18972749,18942192:film_dev_souple:4857:18972768,18942376:film_dev_souple:4857:18967971,18942376:film_dev_souple:4857:18967991,18942377:film_dev_souple:4857:18968512,18942377:film_dev_souple:4857:18968531,19061644:film_dev_souple:4857:19178805,19061693:film_dev_souple:4857:19079879,19061693:film_dev_souple:4857:19079898,19061694:film_dev_souple:4857:19099689,19061694:film_dev_souple:4857:19099744,19061695:film_dev_souple:4857:19100677,19061695:film_dev_souple:4857:19100703,19061849:film_dev_souple:4857:19115530,19061849:film_dev_souple:4857:19115559,19061850:film_dev_souple:4857:19115726,19061850:f'}, {'unwanted_material': 'flux_dev', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02867813702836465, 'nb_photo': 897, 'list_port_cont': '18931098,18931117,18935137,18935156,18956140,18956159,18967970,18967990,18968511,18968530,18969558,18969587,18971935,18971954,18972748,18972767,19079878,19079897,19080880,19080908,19098587,19098606,19099688,19099743,19100676,19100702,19115529,19115558,19117991,19118018,19136337,19136357,19140428,19140456,19140692,19140717,19176271,19176290,19176622,19176641,19176711,19176730,19177025,19177045,19177262,19177281,19177351,19177370,19177466,19177485,19177603,19177624,19177813,19177832,19177857,19177876,19177958,19177977,19178027,19178046,19178071,19178090,19178117,19178136,19178211,19178230,19178602,19178657,19178785,19178804,19178832,19178851,19178948,19178967,19179018,19179037,19179088,19179108,19179137,19179157,19179183,19179202,19179252,19179271,19179298,19179317,19179376,19179395,19179421,19179440,19179490,19179509,19333883,19333911,19335122,19335148,19455430,19455449,19456097,19456116,19467898,19467917,19475103,19475122,19486991,19487010,19487883,19487902,19489249,19489268,19506762,19571425,19571444,1957270', 'assoc_port': '18879290:18935137,18879290:18935156,18879291:18931098,18879291:18931117,18939988:18956140,18939988:18956159,18941899:18969558,18941899:18969587,18941980:18971935,18941980:18971954,18942192:18972748,18942192:18972767,18942376:18967970,18942376:18967990,18942377:18968511,18942377:18968530,19061644:19178785,19061644:19178804,19061645:19178832,19061645:19178851,19061693:19079878,19061693:19079897,19061694:19099688,19061694:19099743,19061695:19100676,19061695:19100702,19061849:19115529,19061849:19115558,19062627:19080880,19062627:19080908,19062628:19098587,19062628:19098606,19082880:19178948,19082880:19178967,19082881:19117991,19082881:19118018,19119419:19179018,19119419:19179037,19119530:19178602,19119530:19178657,19120122:19179252,19120122:19179271,19120123:19177351,19120123:19177370,19120421:19179298,19120421:19179317,19120422:19179376,19120422:19179395,19120760:19177603,19120760:19177624,19120761:19179421,19120761:19179440,19120762:19179490,19120762:19179509,19121173:19177466,19121173:19177485,19121348:1917662', 'assoc_mat': '18879290:flux_dev:4857:18935137,18879290:flux_dev:4857:18935156,18879291:flux_dev:4857:18931098,18879291:flux_dev:4857:18931117,18939988:flux_dev:4857:18956140,18939988:flux_dev:4857:18956159,18941899:flux_dev:4857:18969558,18941899:flux_dev:4857:18969587,18941980:flux_dev:4857:18971935,18941980:flux_dev:4857:18971954,18942192:flux_dev:4857:18972748,18942192:flux_dev:4857:18972767,18942376:flux_dev:4857:18967970,18942376:flux_dev:4857:18967990,18942377:flux_dev:4857:18968511,18942377:flux_dev:4857:18968530,19061644:flux_dev:4857:19178785,19061644:flux_dev:4857:19178804,19061645:flux_dev:4857:19178832,19061645:flux_dev:4857:19178851,19061693:flux_dev:4857:19079878,19061693:flux_dev:4857:19079897,19061694:flux_dev:4857:19099688,19061694:flux_dev:4857:19099743,19061695:flux_dev:4857:19100676,19061695:flux_dev:4857:19100702,19061849:flux_dev:4857:19115529,19061849:flux_dev:4857:19115558,19062627:flux_dev:4857:19080880,19062627:flux_dev:4857:19080908,19062628:flux_dev:4857:19098587,19062628:flux_dev:4857:19098606,'}, {'unwanted_material': 'masque', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.0008057284073268392, 'nb_photo': 3, 'list_port_cont': '18972756,18972775,19179403', 'assoc_port': '18942192:18972756,18942192:18972775,19120422:19179403', 'assoc_mat': '18942192:masque:4857:18972756,18942192:masque:4857:18972775,19120422:masque:4857:19179403'}, {'unwanted_material': 'metal', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.055083991228555396, 'nb_photo': 1153, 'list_port_cont': '18931095,18931114,18935134,18935153,18967967,18967987,18968508,18968527,18969555,18969584,18971932,18971951,18972745,18972764,19079875,19079894,19080877,19080905,19098584,19098603,19099685,19099740,19100672,19100699,19115526,19115555,19115722,19115746,19117988,19118015,19136334,19136354,19140425,19140453,19140689,19140714,19176619,19176638,19176708,19176727,19177022,19177042,19177259,19177278,19177348,19177367,19177463,19177482,19177600,19177620,19177810,19177829,19177854,19177873,19177955,19177974,19178024,19178043,19178068,19178087,19178114,19178133,19178208,19178227,19178599,19178654,19178782,19178801,19178829,19178848,19178945,19178964,19179015,19179034,19179085,19179105,19179134,19179154,19179180,19179199,19179249,19179268,19179295,19179314,19179373,19179392,19179418,19179437,19179487,19179506,19333880,19333908,19335119,19335145,19455427,19455446,19456094,19456113,19457827,19457847,19467895,19467914,19486988,19487007,19487880,19487899,19489246,19489265,19506740,19571422,19571441,19572705,19572724', 'assoc_port': '18879290:18935134,18879290:18935153,18879291:18931095,18879291:18931114,18941899:18969555,18941899:18969584,18941980:18971932,18941980:18971951,18942192:18972745,18942192:18972764,18942376:18967967,18942376:18967987,18942377:18968508,18942377:18968527,19061644:19178782,19061644:19178801,19061645:19178829,19061645:19178848,19061693:19079875,19061693:19079894,19061694:19099685,19061694:19099740,19061695:19100672,19061695:19100699,19061849:19115526,19061849:19115555,19061850:19115722,19061850:19115746,19062627:19080877,19062627:19080905,19062628:19098584,19062628:19098603,19082880:19178945,19082880:19178964,19082881:19117988,19082881:19118015,19119419:19179015,19119419:19179034,19119530:19178599,19119530:19178654,19120122:19179249,19120122:19179268,19120123:19177348,19120123:19177367,19120421:19179295,19120421:19179314,19120422:19179373,19120422:19179392,19120760:19177600,19120760:19177620,19120761:19179418,19120761:19179437,19120762:19179487,19120762:19179506,19121173:19177463,19121173:19177482,19121348:1917661', 'assoc_mat': '18879290:metal:4857:18935134,18879290:metal:4857:18935153,18879291:metal:4857:18931095,18879291:metal:4857:18931114,18941899:metal:4857:18969555,18941899:metal:4857:18969584,18941980:metal:4857:18971932,18941980:metal:4857:18971951,18942192:metal:4857:18972745,18942192:metal:4857:18972764,18942376:metal:4857:18967967,18942376:metal:4857:18967987,18942377:metal:4857:18968508,18942377:metal:4857:18968527,19061644:metal:4857:19178782,19061644:metal:4857:19178801,19061645:metal:4857:19178829,19061645:metal:4857:19178848,19061693:metal:4857:19079875,19061693:metal:4857:19079894,19061694:metal:4857:19099685,19061694:metal:4857:19099740,19061695:metal:4857:19100672,19061695:metal:4857:19100699,19061849:metal:4857:19115526,19061849:metal:4857:19115555,19061850:metal:4857:19115722,19061850:metal:4857:19115746,19062627:metal:4857:19080877,19062627:metal:4857:19080905,19062628:metal:4857:19098584,19062628:metal:4857:19098603,19082880:metal:4857:19178945,19082880:metal:4857:19178964,19082881:metal:4857:19117988,19082881:'}, {'unwanted_material': 'papier', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.13749776840136102, 'nb_photo': 3173, 'list_port_cont': '18931093,18931112,18935132,18935151,18956135,18956154,18967965,18967985,18968506,18968525,18969553,18969582,18971930,18971949,18972743,18972762,19079873,19079892,19080875,19080903,19098582,19098601,19099683,19099738,19100670,19100697,19115524,19115553,19115720,19115743,19117986,19118013,19136332,19136352,19140423,19140451,19140687,19140712,19176266,19176285,19176617,19176636,19176706,19176725,19177020,19177040,19177257,19177276,19177346,19177365,19177461,19177480,19177598,19177618,19177808,19177827,19177852,19177871,19177953,19177972,19178022,19178041,19178066,19178085,19178112,19178131,19178206,19178225,19178597,19178652,19178780,19178799,19178827,19178846,19178943,19178962,19179013,19179032,19179083,19179103,19179132,19179152,19179178,19179197,19179247,19179266,19179293,19179312,19179371,19179390,19179416,19179435,19179485,19179504,19333878,19333906,19335117,19335143,19455425,19455444,19456092,19456111,19457825,19457845,19467893,19467912,19475098,19475117,19486986,19487005,19487878,19487897,19489244,1948926', 'assoc_port': '18879290:18935132,18879290:18935151,18879291:18931093,18879291:18931112,18939988:18956135,18939988:18956154,18941899:18969553,18941899:18969582,18941980:18971930,18941980:18971949,18942192:18972743,18942192:18972762,18942376:18967965,18942376:18967985,18942377:18968506,18942377:18968525,19061644:19178780,19061644:19178799,19061645:19178827,19061645:19178846,19061693:19079873,19061693:19079892,19061694:19099683,19061694:19099738,19061695:19100670,19061695:19100697,19061849:19115524,19061849:19115553,19061850:19115720,19061850:19115743,19062627:19080875,19062627:19080903,19062628:19098582,19062628:19098601,19082880:19178943,19082880:19178962,19082881:19117986,19082881:19118013,19119419:19179013,19119419:19179032,19119530:19178597,19119530:19178652,19120122:19179247,19120122:19179266,19120123:19177346,19120123:19177365,19120421:19179293,19120421:19179312,19120422:19179371,19120422:19179390,19120760:19177598,19120760:19177618,19120761:19179416,19120761:19179435,19120762:19179485,19120762:19179504,19121173:1917746', 'assoc_mat': '18879290:papier:4857:18935132,18879290:papier:4857:18935151,18879291:papier:4857:18931093,18879291:papier:4857:18931112,18939988:papier:4857:18956135,18939988:papier:4857:18956154,18941899:papier:4857:18969553,18941899:papier:4857:18969582,18941980:papier:4857:18971930,18941980:papier:4857:18971949,18942192:papier:4857:18972743,18942192:papier:4857:18972762,18942376:papier:4857:18967965,18942376:papier:4857:18967985,18942377:papier:4857:18968506,18942377:papier:4857:18968525,19061644:papier:4857:19178780,19061644:papier:4857:19178799,19061645:papier:4857:19178827,19061645:papier:4857:19178846,19061693:papier:4857:19079873,19061693:papier:4857:19079892,19061694:papier:4857:19099683,19061694:papier:4857:19099738,19061695:papier:4857:19100670,19061695:papier:4857:19100697,19061849:papier:4857:19115524,19061849:papier:4857:19115553,19061850:papier:4857:19115720,19061850:papier:4857:19115743,19062627:papier:4857:19080875,19062627:papier:4857:19080903,19062628:papier:4857:19098582,19062628:papier:4857:19098601,1908'}, {'unwanted_material': 'pehd', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.008694406286314592, 'nb_photo': 271, 'list_port_cont': '18931097,18931116,18935136,18935155,18956139,18956158,18967969,18967989,18968510,18968529,18969557,18969586,18971934,18971953,18972747,18972766,19079877,19079896,19080879,19080907,19098586,19098605,19099687,19099742,19115528,19115557,19115724,19115748,19117990,19118017,19136336,19136356,19140427,19140455,19140691,19140716,19176270,19176289,19176621,19176640,19176710,19176729,19177024,19177044,19177261,19177280,19177350,19177369,19177465,19177484,19177602,19177623,19177812,19177831,19177856,19177875,19177957,19177976,19178026,19178045,19178070,19178116,19178135,19178210,19178229,19178601,19178656,19178784,19178803,19178831,19178850,19178947,19178966,19179017,19179036,19179087,19179107,19179136,19179156,19179182,19179201,19179251,19179270,19179297,19179316,19179375,19179394,19179420,19179439,19179489,19179508,19333910,19455429,19455448,19467897,19467916,19487882,19487901,19489248,19489267,19506742,19506761,19571424,19571443,19572707,19572726', 'assoc_port': '18879290:18935136,18879290:18935155,18879291:18931097,18879291:18931116,18939988:18956139,18939988:18956158,18941899:18969557,18941899:18969586,18941980:18971934,18941980:18971953,18942192:18972747,18942192:18972766,18942376:18967969,18942376:18967989,18942377:18968510,18942377:18968529,19061644:19178784,19061644:19178803,19061645:19178831,19061645:19178850,19061693:19079877,19061693:19079896,19061694:19099687,19061694:19099742,19061849:19115528,19061849:19115557,19061850:19115724,19061850:19115748,19062627:19080879,19062627:19080907,19062628:19098586,19062628:19098605,19082880:19178947,19082880:19178966,19082881:19117990,19082881:19118017,19119419:19179017,19119419:19179036,19119530:19178601,19119530:19178656,19120122:19179251,19120122:19179270,19120123:19177350,19120123:19177369,19120421:19179297,19120421:19179316,19120422:19179375,19120422:19179394,19120760:19177602,19120760:19177623,19120761:19179420,19120761:19179439,19120762:19179489,19120762:19179508,19121173:19177465,19121173:19177484,19121348:1917662', 'assoc_mat': '18879290:pehd:4857:18935136,18879290:pehd:4857:18935155,18879291:pehd:4857:18931097,18879291:pehd:4857:18931116,18939988:pehd:4857:18956139,18939988:pehd:4857:18956158,18941899:pehd:4857:18969557,18941899:pehd:4857:18969586,18941980:pehd:4857:18971934,18941980:pehd:4857:18971953,18942192:pehd:4857:18972747,18942192:pehd:4857:18972766,18942376:pehd:4857:18967969,18942376:pehd:4857:18967989,18942377:pehd:4857:18968510,18942377:pehd:4857:18968529,19061644:pehd:4857:19178784,19061644:pehd:4857:19178803,19061645:pehd:4857:19178831,19061645:pehd:4857:19178850,19061693:pehd:4857:19079877,19061693:pehd:4857:19079896,19061694:pehd:4857:19099687,19061694:pehd:4857:19099742,19061849:pehd:4857:19115528,19061849:pehd:4857:19115557,19061850:pehd:4857:19115724,19061850:pehd:4857:19115748,19062627:pehd:4857:19080879,19062627:pehd:4857:19080907,19062628:pehd:4857:19098586,19062628:pehd:4857:19098605,19082880:pehd:4857:19178947,19082880:pehd:4857:19178966,19082881:pehd:4857:19117990,19082881:pehd:4857:19118017,19119419:pehd:48'}, {'unwanted_material': 'pet_clair', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.020800550400248825, 'nb_photo': 1575, 'list_port_cont': '18931096,18931115,18935135,18935154,18956138,18956157,18967968,18967988,18968509,18968528,18969556,18969585,18971933,18971952,18972746,18972765,19079876,19079895,19080878,19080906,19098585,19098604,19099686,19099741,19100673,19100700,19115527,19115556,19115723,19115747,19117989,19118016,19136335,19136355,19140426,19140454,19140690,19140715,19176269,19176288,19176620,19176639,19176709,19176728,19177023,19177043,19177260,19177279,19177349,19177368,19177464,19177483,19177601,19177621,19177811,19177830,19177855,19177874,19177956,19177975,19178025,19178044,19178069,19178088,19178115,19178134,19178209,19178228,19178600,19178655,19178783,19178802,19178830,19178849,19178946,19178965,19179016,19179035,19179086,19179106,19179135,19179155,19179181,19179200,19179250,19179269,19179296,19179315,19179374,19179393,19179419,19179438,19179488,19179507,19333881,19333909,19335120,19335146,19455428,19455447,19456095,19456114,19457828,19457848,19467896,19467915,19475101,19475120,19486989,19487008,19487881,19487900,19489247,1948926', 'assoc_port': '18879290:18935135,18879290:18935154,18879291:18931096,18879291:18931115,18939988:18956138,18939988:18956157,18941899:18969556,18941899:18969585,18941980:18971933,18941980:18971952,18942192:18972746,18942192:18972765,18942376:18967968,18942376:18967988,18942377:18968509,18942377:18968528,19061644:19178783,19061644:19178802,19061645:19178830,19061645:19178849,19061693:19079876,19061693:19079895,19061694:19099686,19061694:19099741,19061695:19100673,19061695:19100700,19061849:19115527,19061849:19115556,19061850:19115723,19061850:19115747,19062627:19080878,19062627:19080906,19062628:19098585,19062628:19098604,19082880:19178946,19082880:19178965,19082881:19117989,19082881:19118016,19119419:19179016,19119419:19179035,19119530:19178600,19119530:19178655,19120122:19179250,19120122:19179269,19120123:19177349,19120123:19177368,19120421:19179296,19120421:19179315,19120422:19179374,19120422:19179393,19120760:19177601,19120760:19177621,19120761:19179419,19120761:19179438,19120762:19179488,19120762:19179507,19121173:1917746', 'assoc_mat': '18879290:pet_clair:4857:18935135,18879290:pet_clair:4857:18935154,18879291:pet_clair:4857:18931096,18879291:pet_clair:4857:18931115,18939988:pet_clair:4857:18956138,18939988:pet_clair:4857:18956157,18941899:pet_clair:4857:18969556,18941899:pet_clair:4857:18969585,18941980:pet_clair:4857:18971933,18941980:pet_clair:4857:18971952,18942192:pet_clair:4857:18972746,18942192:pet_clair:4857:18972765,18942376:pet_clair:4857:18967968,18942376:pet_clair:4857:18967988,18942377:pet_clair:4857:18968509,18942377:pet_clair:4857:18968528,19061644:pet_clair:4857:19178783,19061644:pet_clair:4857:19178802,19061645:pet_clair:4857:19178830,19061645:pet_clair:4857:19178849,19061693:pet_clair:4857:19079876,19061693:pet_clair:4857:19079895,19061694:pet_clair:4857:19099686,19061694:pet_clair:4857:19099741,19061695:pet_clair:4857:19100673,19061695:pet_clair:4857:19100700,19061849:pet_clair:4857:19115527,19061849:pet_clair:4857:19115556,19061850:pet_clair:4857:19115723,19061850:pet_clair:4857:19115747,19062627:pet_clair:4857:19080878,1'}, {'unwanted_material': 'sac_om_plein', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.20422874167683033, 'nb_photo': 1334, 'list_port_cont': '18931101,18931120,18935140,18935159,18956143,18956162,18967973,18967993,18968514,18968533,18969561,18969590,18971938,18971957,18972751,18972770,19079881,19079900,19080883,19080911,19098590,19098609,19099691,19099746,19100679,19100705,19115532,19115561,19115728,19115753,19117994,19118021,19136340,19136360,19140431,19140459,19140695,19140720,19176274,19176293,19176625,19176644,19176714,19176733,19177028,19177048,19177265,19177284,19177354,19177373,19177469,19177488,19177606,19177627,19177816,19177835,19177860,19177879,19177961,19177980,19178030,19178049,19178074,19178093,19178120,19178139,19178214,19178233,19178605,19178660,19178788,19178807,19178835,19178854,19178951,19178970,19179021,19179040,19179091,19179111,19179140,19179160,19179186,19179205,19179255,19179274,19179301,19179320,19179379,19179398,19179424,19179443,19179493,19179512,19333886,19333914,19335125,19335151,19455433,19455452,19456100,19456119,19457833,19457853,19467901,19467920,19475106,19475125,19486994,19487013,19487886,19487905,19489252,1948927', 'assoc_port': '18879290:18935140,18879290:18935159,18879291:18931101,18879291:18931120,18939988:18956143,18939988:18956162,18941899:18969561,18941899:18969590,18941980:18971938,18941980:18971957,18942192:18972751,18942192:18972770,18942376:18967973,18942376:18967993,18942377:18968514,18942377:18968533,19061644:19178788,19061644:19178807,19061645:19178835,19061645:19178854,19061693:19079881,19061693:19079900,19061694:19099691,19061694:19099746,19061695:19100679,19061695:19100705,19061849:19115532,19061849:19115561,19061850:19115728,19061850:19115753,19062627:19080883,19062627:19080911,19062628:19098590,19062628:19098609,19082880:19178951,19082880:19178970,19082881:19117994,19082881:19118021,19119419:19179021,19119419:19179040,19119530:19178605,19119530:19178660,19120122:19179255,19120122:19179274,19120123:19177354,19120123:19177373,19120421:19179301,19120421:19179320,19120422:19179379,19120422:19179398,19120760:19177606,19120760:19177627,19120761:19179424,19120761:19179443,19120762:19179493,19120762:19179512,19121173:1917746', 'assoc_mat': '18879290:sac_om_plein:4857:18935140,18879290:sac_om_plein:4857:18935159,18879291:sac_om_plein:4857:18931101,18879291:sac_om_plein:4857:18931120,18939988:sac_om_plein:4857:18956143,18939988:sac_om_plein:4857:18956162,18941899:sac_om_plein:4857:18969561,18941899:sac_om_plein:4857:18969590,18941980:sac_om_plein:4857:18971938,18941980:sac_om_plein:4857:18971957,18942192:sac_om_plein:4857:18972751,18942192:sac_om_plein:4857:18972770,18942376:sac_om_plein:4857:18967973,18942376:sac_om_plein:4857:18967993,18942377:sac_om_plein:4857:18968514,18942377:sac_om_plein:4857:18968533,19061644:sac_om_plein:4857:19178788,19061644:sac_om_plein:4857:19178807,19061645:sac_om_plein:4857:19178835,19061645:sac_om_plein:4857:19178854,19061693:sac_om_plein:4857:19079881,19061693:sac_om_plein:4857:19079900,19061694:sac_om_plein:4857:19099691,19061694:sac_om_plein:4857:19099746,19061695:sac_om_plein:4857:19100679,19061695:sac_om_plein:4857:19100705,19061849:sac_om_plein:4857:19115532,19061849:sac_om_plein:4857:19115561,19061850:sac_om_'}, {'unwanted_material': 'textiles', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.010069962291664132, 'nb_photo': 196, 'list_port_cont': '18931102,18931121,18935141,18935160,18956144,18956163,18969562,18969591,18971939,18971958,18972752,19079882,19079901,19098591,19098610,19100680,19100706,19115533,19115562,19136341,19136361,19140696,19140721,19176275,19176294,19176626,19176645,19176715,19176734,19177029,19177049,19177355,19177607,19177628,19177836,19177861,19177880,19177981,19178215,19178234,19178789,19178808,19178836,19178855,19178952,19178971,19179022,19179041,19179092,19179112,19179187,19179206,19179256,19179275,19179302,19179321,19179380,19179399,19179425,19179444,19179494,19179513,19333887,19333915,19455434,19455453,19456101,19456120,19457834,19457854,19486995,19487014,19489253,19489272,19506747,19506766', 'assoc_port': '18879290:18935141,18879290:18935160,18879291:18931102,18879291:18931121,18939988:18956144,18939988:18956163,18941899:18969562,18941899:18969591,18941980:18971939,18941980:18971958,18942192:18972752,19061644:19178789,19061644:19178808,19061645:19178836,19061645:19178855,19061693:19079882,19061693:19079901,19061695:19100680,19061695:19100706,19061849:19115533,19061849:19115562,19062628:19098591,19062628:19098610,19082880:19178952,19082880:19178971,19119419:19179022,19119419:19179041,19120122:19179256,19120122:19179275,19120123:19177355,19120421:19179302,19120421:19179321,19120422:19179380,19120422:19179399,19120760:19177607,19120760:19177628,19120761:19179425,19120761:19179444,19120762:19179494,19120762:19179513,19121348:19176626,19121348:19176645,19121349:19179187,19121349:19179206,19121350:19176715,19121350:19176734,19121351:19177029,19121351:19177049,19121761:19178215,19121761:19178234,19121762:19177836,19122780:19176275,19122780:19176294,19122782:19140696,19122782:19140721,19123092:19179092,19123092:1917911', 'assoc_mat': '18879290:textiles:4857:18935141,18879290:textiles:4857:18935160,18879291:textiles:4857:18931102,18879291:textiles:4857:18931121,18939988:textiles:4857:18956144,18939988:textiles:4857:18956163,18941899:textiles:4857:18969562,18941899:textiles:4857:18969591,18941980:textiles:4857:18971939,18941980:textiles:4857:18971958,18942192:textiles:4857:18972752,19061644:textiles:4857:19178789,19061644:textiles:4857:19178808,19061645:textiles:4857:19178836,19061645:textiles:4857:19178855,19061693:textiles:4857:19079882,19061693:textiles:4857:19079901,19061695:textiles:4857:19100680,19061695:textiles:4857:19100706,19061849:textiles:4857:19115533,19061849:textiles:4857:19115562,19062628:textiles:4857:19098591,19062628:textiles:4857:19098610,19082880:textiles:4857:19178952,19082880:textiles:4857:19178971,19119419:textiles:4857:19179022,19119419:textiles:4857:19179041,19120122:textiles:4857:19179256,19120122:textiles:4857:19179275,19120123:textiles:4857:19177355,19120421:textiles:4857:19179302,19120421:textiles:4857:19179321,'}, {'unwanted_material': 'verre', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.012965507188723175, 'nb_photo': 37, 'list_port_cont': '19115534,19115563,19115730,19115755,19136342,19136362,19140697,19140722,19178953,19178972,19179042,19179188,19179207,19179303,19179381,19179426,19179445,19179495,19179514,19333916', 'assoc_port': '19061849:19115534,19061849:19115563,19061850:19115730,19061850:19115755,19082880:19178953,19082880:19178972,19119419:19179042,19120421:19179303,19120422:19179381,19120761:19179426,19120761:19179445,19120762:19179495,19120762:19179514,19121349:19179188,19121349:19179207,19122782:19140697,19122782:19140722,19123093:19136342,19123093:19136362,19324570:19333916', 'assoc_mat': '19061849:verre:4857:19115534,19061849:verre:4857:19115563,19061850:verre:4857:19115730,19061850:verre:4857:19115755,19082880:verre:4857:19178953,19082880:verre:4857:19178972,19119419:verre:4857:19179042,19120421:verre:4857:19179303,19120422:verre:4857:19179381,19120761:verre:4857:19179426,19120761:verre:4857:19179445,19120762:verre:4857:19179495,19120762:verre:4857:19179514,19121349:verre:4857:19179188,19121349:verre:4857:19179207,19122782:verre:4857:19140697,19122782:verre:4857:19140722,19123093:verre:4857:19136342,19123093:verre:4857:19136362,19324570:verre:4857:19333916'}), 'main_stat': {'nb_photos': 669}}, 'hostname': (), 'impurety_average_per_hashtag': [(('entrant', '2024-12', 0.2099124318620656),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SyctomXV_Mask_23Q4"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4932 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4932 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4932 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4932 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} We expected an STS datou with a camera_place_name, so there is a PB, datou_id: 4932 ! {'id': 4932, 'name': 'split_time_score_cod_upm_SyctomXV_Mask_23Q1', 'limit_max': 150, 'nb_steps': 1, 'estimated_time': 8640, 'list_steps': [{'id': 14066, 'type': 'split_time_score_with_photo', 'param': '0', 'json_param_as_string': "{'cod': 1, 'camera_place_name': 'SyctomXV_Mask_23Q4', 'ETA': 8640, 'param_moyenne_mobile': 5, 'thcl': 3379, 'list_task_complete': [''], 'list_tasks': 'LOAD,ORDER,CONVENTION,SPLIT_BY_DARK,SPLIT_TIME, CREATE_PORT_LAUNCH_CARAC_FILL_DASHBOARD,READ_PLATE', 'forced_hashtag': 'entrant', 'list_hashtag_class_create': 'entrant', 'ponderation': '0.001,0.001,0.001,0.001,0.001', 'host': 'www.fotonower.com', 'interval': 10, 'datou_proportion_papier': {'test': 370, 'entrant': 4742}, 'check_plate_format': 1, 'input_default_values': []}", 'json_param': {'cod': 1, 'camera_place_name': 'SyctomXV_Mask_23Q4', 'ETA': 8640, 'param_moyenne_mobile': 5, 'thcl': 3379, 'list_task_complete': [''], 'list_tasks': 'LOAD,ORDER,CONVENTION,SPLIT_BY_DARK,SPLIT_TIME, CREATE_PORT_LAUNCH_CARAC_FILL_DASHBOARD,READ_PLATE', 'forced_hashtag': 'entrant', 'list_hashtag_class_create': 'entrant', 'ponderation': '0.001,0.001,0.001,0.001,0.001', 'host': 'www.fotonower.com', 'interval': 10, 'datou_proportion_papier': {'test': 370, 'entrant': 4742}, 'check_plate_format': 1, 'input_default_values': []}, 'nb_input': 2, 'nb_output': 1, 'prod': False, 'is_local': False, 'is_datou_depend': False, 'is_photo_id_local': False, 'list_data': []}], 'depends_step': []} check if it is the case where we have multiple sts in one datou yes, we found a datou with multiple sts, we will choose the last one by default SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=370 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=370 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 370 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=370 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'min_score': 0.7, 'name_pipeline': 'proportion_papier_tapis', 'hashtag_type': 705, 'hashtag_proportion': 492668766, 'hashtag_parmi': 538914404, 'hashtag_to_consider': 'papier_only', 'hashtag_background': 493012381} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier ventilate_hashtags_in_portfolio step not found ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4742 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4742 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4742 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4742 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 13169 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13170 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 13167 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 13167 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13174 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13168 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 13171 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13172 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13173 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 13175 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13169 have datatype=11 whereas input 0 of step 13167 have datatype=2 WARNING : type of output 1 of step 13170 doesn't seem to be define in the database( WARNING : type of input 3 of step 13168 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13170 doesn't seem to be define in the database( WARNING : type of input 1 of step 13167 doesn't seem to be define in the database( WARNING : output 0 of step 13174 have datatype=10 whereas input 3 of step 13173 have datatype=6 WARNING : type of input 1 of step 13174 doesn't seem to be define in the database( WARNING : output 1 of step 13167 have datatype=7 whereas input 1 of step 13174 have datatype=None WARNING : type of output 1 of step 13174 doesn't seem to be define in the database( WARNING : type of input 4 of step 13168 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13169 doesn't seem to be define in the database( WARNING : type of input 1 of step 13170 doesn't seem to be define in the database( DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4857, 'hashtag_proportion': 'sac_om_plein,textiles,verre,organique,dasri,masque,encombrant,autre_non_emballage', 'hashtag_parmi': 'papier,carton,metal,pet_clair,pehd,flux_dev,film_dev_souple,ela', 'hashtag_weights': {'papier': 3, 'carton': 2.8, 'metal': 6, 'pet_clair': 1.4, 'pehd': 2.8, 'flux_dev': 2.8, 'pet_opaque': 3, 'barquette_opaque': 2.8, 'film_dev_souple': 0.8, 'ela': 3.0, 'sac_om_plein': 6.5, 'textiles': 3, 'verre': 10.0, 'organique': 4.0, 'dasri': 2.0, 'masque': 1, 'encombrant': 7, 'autre_emballage': 6.0, 'autre_non_emballage': 6.0}, 'check_plaque': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((600,),), 'unwanted_material_monthly_percentage': ((0.2099124318620656,),), 'material_repartition': (('entrant', 568),), 'material_dict': {'entrant': 568}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2024, 12, 2), 0.2508067585957011, 21), (datetime.date(2024, 12, 6), 0.16231281559130883, 15), (datetime.date(2024, 12, 7), 0.16134498582994541, 61), (datetime.date(2024, 12, 9), 0.3336292878327366, 24), (datetime.date(2024, 12, 12), 0.25728088920326303, 77), (datetime.date(2024, 12, 13), 0.23335021454096755, 40), (datetime.date(2024, 12, 14), 0.1092044133886686, 36), (datetime.date(2024, 12, 16), 0.18236003747021667, 74), (datetime.date(2024, 12, 17), 0.23205389494726658, 83), (datetime.date(2024, 12, 18), 0.18524914506201048, 49), (datetime.date(2024, 12, 19), 0.2173558023973865, 88), (datetime.date(2024, 12, 27), 0.18099292940939735, 32), (datetime.date(2024, 12, 28), 0.19102718411673753, 46), (datetime.date(2024, 12, 30), 0.18472766267316953, 23)), 'impurety_average_data_per_hashtag': {'entrant': ((datetime.date(2024, 12, 2), 0.2508067585957011, 21), (datetime.date(2024, 12, 6), 0.16231281559130883, 15), (datetime.date(2024, 12, 7), 0.16134498582994541, 61), (datetime.date(2024, 12, 9), 0.3336292878327366, 24), (datetime.date(2024, 12, 12), 0.25728088920326303, 77), (datetime.date(2024, 12, 13), 0.23335021454096755, 40), (datetime.date(2024, 12, 14), 0.1092044133886686, 36), (datetime.date(2024, 12, 16), 0.18236003747021667, 74), (datetime.date(2024, 12, 17), 0.23205389494726658, 83), (datetime.date(2024, 12, 18), 0.18524914506201048, 49), (datetime.date(2024, 12, 19), 0.2173558023973865, 88), (datetime.date(2024, 12, 27), 0.18099292940939735, 32), (datetime.date(2024, 12, 28), 0.19102718411673753, 46), (datetime.date(2024, 12, 30), 0.18472766267316953, 23))}, 'quality_array': [], 'number_of_batch': ((61,),), 'datou_id_sts': 4932, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre_non_emballage', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02938235691925842, 'nb_photo': 794, 'list_port_cont': '18931108,18931127,18935147,18935166,18956150,18956169,18968521,18968540,18969568,18969597,18971945,18971964,19079888,19079907,19080890,19080918,19098597,19098616,19099698,19099753,19100686,19100712,19115539,19115568,19118002,19118028,19136347,19136367,19176632,19176721,19176740,19177035,19177055,19177272,19177291,19177380,19177823,19177842,19177886,19177968,19177987,19178056,19178240,19178612,19178667,19178795,19178814,19178842,19178861,19178958,19178977,19179028,19179098,19179118,19179193,19179212,19179262,19179308,19179327,19179386,19179405,19179431,19179500,19179519,19333893,19333921,19335132,19335158,19455440,19456107,19456126,19457840,19467908,19467927,19487001,19487893,19487912,19489259,19489278,19506753,19571435,19571454,19572718,19572737', 'assoc_port': '18879290:18935147,18879290:18935166,18879291:18931108,18879291:18931127,18939988:18956150,18939988:18956169,18941899:18969568,18941899:18969597,18941980:18971945,18941980:18971964,18942377:18968521,18942377:18968540,19061644:19178795,19061644:19178814,19061645:19178842,19061645:19178861,19061693:19079888,19061693:19079907,19061694:19099698,19061694:19099753,19061695:19100686,19061695:19100712,19061849:19115539,19061849:19115568,19062627:19080890,19062627:19080918,19062628:19098597,19062628:19098616,19082880:19178958,19082880:19178977,19082881:19118002,19082881:19118028,19119419:19179028,19119530:19178612,19119530:19178667,19120122:19179262,19120123:19177380,19120421:19179308,19120421:19179327,19120422:19179386,19120422:19179405,19120761:19179431,19120762:19179500,19120762:19179519,19121348:19176632,19121349:19179193,19121349:19179212,19121350:19176721,19121350:19176740,19121351:19177035,19121351:19177055,19121352:19177272,19121352:19177291,19121761:19178240,19121762:19177823,19121762:19177842,19123092:1917909', 'assoc_mat': '18879290:autre_non_emballage:4857:18935147,18879290:autre_non_emballage:4857:18935166,18879291:autre_non_emballage:4857:18931108,18879291:autre_non_emballage:4857:18931127,18939988:autre_non_emballage:4857:18956150,18939988:autre_non_emballage:4857:18956169,18941899:autre_non_emballage:4857:18969568,18941899:autre_non_emballage:4857:18969597,18941980:autre_non_emballage:4857:18971945,18941980:autre_non_emballage:4857:18971964,18942377:autre_non_emballage:4857:18968521,18942377:autre_non_emballage:4857:18968540,19061644:autre_non_emballage:4857:19178795,19061644:autre_non_emballage:4857:19178814,19061645:autre_non_emballage:4857:19178842,19061645:autre_non_emballage:4857:19178861,19061693:autre_non_emballage:4857:19079888,19061693:autre_non_emballage:4857:19079907,19061694:autre_non_emballage:4857:19099698,19061694:autre_non_emballage:4857:19099753,19061695:autre_non_emballage:4857:19100686,19061695:autre_non_emballage:4857:19100712,19061849:autre_non_emballage:4857:19115539,19061849:autre_non_emballage:4857:1'}, {'unwanted_material': 'carton', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.5909515428448618, 'nb_photo': 11359, 'list_port_cont': '18931094,18931113,18935133,18935152,18956136,18956155,18967966,18967986,18968507,18968526,18969554,18969583,18971931,18971950,18972744,18972763,19079874,19079893,19080876,19080904,19098583,19098602,19099684,19099739,19100671,19100698,19115525,19115554,19115721,19115745,19117987,19118014,19136333,19136353,19140424,19140452,19140688,19140713,19176267,19176286,19176618,19176637,19176707,19176726,19177021,19177041,19177258,19177277,19177347,19177366,19177462,19177481,19177599,19177619,19177809,19177828,19177853,19177872,19177954,19177973,19178023,19178042,19178067,19178086,19178113,19178132,19178207,19178226,19178598,19178653,19178781,19178800,19178828,19178847,19178897,19178916,19178944,19178963,19179014,19179033,19179084,19179104,19179133,19179153,19179179,19179198,19179248,19179267,19179294,19179313,19179372,19179391,19179417,19179436,19179486,19179505,19333879,19333907,19335118,19335144,19455426,19455445,19456093,19456112,19457826,19457846,19467894,19467913,19475099,19475118,19486987,19487006,19487879,1948789', 'assoc_port': '18879290:18935133,18879290:18935152,18879291:18931094,18879291:18931113,18939988:18956136,18939988:18956155,18941899:18969554,18941899:18969583,18941980:18971931,18941980:18971950,18942192:18972744,18942192:18972763,18942376:18967966,18942376:18967986,18942377:18968507,18942377:18968526,19061644:19178781,19061644:19178800,19061645:19178828,19061645:19178847,19061693:19079874,19061693:19079893,19061694:19099684,19061694:19099739,19061695:19100671,19061695:19100698,19061849:19115525,19061849:19115554,19061850:19115721,19061850:19115745,19062627:19080876,19062627:19080904,19062628:19098583,19062628:19098602,19062629:19178897,19062629:19178916,19082880:19178944,19082880:19178963,19082881:19117987,19082881:19118014,19119419:19179014,19119419:19179033,19119530:19178598,19119530:19178653,19120122:19179248,19120122:19179267,19120123:19177347,19120123:19177366,19120421:19179294,19120421:19179313,19120422:19179372,19120422:19179391,19120760:19177599,19120760:19177619,19120761:19179417,19120761:19179436,19120762:1917948', 'assoc_mat': '18879290:carton:4857:18935133,18879290:carton:4857:18935152,18879291:carton:4857:18931094,18879291:carton:4857:18931113,18939988:carton:4857:18956136,18939988:carton:4857:18956155,18941899:carton:4857:18969554,18941899:carton:4857:18969583,18941980:carton:4857:18971931,18941980:carton:4857:18971950,18942192:carton:4857:18972744,18942192:carton:4857:18972763,18942376:carton:4857:18967966,18942376:carton:4857:18967986,18942377:carton:4857:18968507,18942377:carton:4857:18968526,19061644:carton:4857:19178781,19061644:carton:4857:19178800,19061645:carton:4857:19178828,19061645:carton:4857:19178847,19061693:carton:4857:19079874,19061693:carton:4857:19079893,19061694:carton:4857:19099684,19061694:carton:4857:19099739,19061695:carton:4857:19100671,19061695:carton:4857:19100698,19061849:carton:4857:19115525,19061849:carton:4857:19115554,19061850:carton:4857:19115721,19061850:carton:4857:19115745,19062627:carton:4857:19080876,19062627:carton:4857:19080904,19062628:carton:4857:19098583,19062628:carton:4857:19098602,1906'}, {'unwanted_material': 'dasri', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.0, 'nb_photo': 5, 'list_port_cont': '19177864,19178034', 'assoc_port': '19124099:19177864,19124200:19178034', 'assoc_mat': '19124099:dasri:4857:19177864,19124200:dasri:4857:19178034'}, {'unwanted_material': 'ela', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.007356838113043555, 'nb_photo': 100, 'list_port_cont': '18931100,18931119,18935139,18935158,18968513,18968532,19079880,19079899,19080882,19080910,19098589,19098608,19099690,19099745,19100678,19100704,19115531,19115560,19140694,19140719,19176624,19176643,19176713,19176732,19177027,19177047,19177264,19177283,19177372,19177468,19177487,19177605,19177626,19177960,19178048,19178073,19178092,19178119,19178138,19178213,19178232,19178659,19178806,19178969,19179039,19179090,19179110,19179139,19179159,19179319,19179397,19179442,19333913,19335124,19335150,19456118,19457832,19457852,19467900,19467919,19489251,19489270,19572710,19572729', 'assoc_port': '18879290:18935139,18879290:18935158,18879291:18931100,18879291:18931119,18942377:18968513,18942377:18968532,19061644:19178806,19061693:19079880,19061693:19079899,19061694:19099690,19061694:19099745,19061695:19100678,19061695:19100704,19061849:19115531,19061849:19115560,19062627:19080882,19062627:19080910,19062628:19098589,19062628:19098608,19082880:19178969,19119419:19179039,19119530:19178659,19120123:19177372,19120421:19179319,19120422:19179397,19120760:19177605,19120760:19177626,19120761:19179442,19121173:19177468,19121173:19177487,19121348:19176624,19121348:19176643,19121350:19176713,19121350:19176732,19121351:19177027,19121351:19177047,19121352:19177264,19121352:19177283,19121761:19178213,19121761:19178232,19122779:19179139,19122779:19179159,19122782:19140694,19122782:19140719,19123092:19179090,19123092:19179110,19124096:19178119,19124096:19178138,19124100:19178073,19124100:19178092,19124200:19178048,19124201:19177960,19324569:19335124,19324569:19335150,19324570:19333913,19451566:19489251,19451566:1948927', 'assoc_mat': '18879290:ela:4857:18935139,18879290:ela:4857:18935158,18879291:ela:4857:18931100,18879291:ela:4857:18931119,18942377:ela:4857:18968513,18942377:ela:4857:18968532,19061644:ela:4857:19178806,19061693:ela:4857:19079880,19061693:ela:4857:19079899,19061694:ela:4857:19099690,19061694:ela:4857:19099745,19061695:ela:4857:19100678,19061695:ela:4857:19100704,19061849:ela:4857:19115531,19061849:ela:4857:19115560,19062627:ela:4857:19080882,19062627:ela:4857:19080910,19062628:ela:4857:19098589,19062628:ela:4857:19098608,19082880:ela:4857:19178969,19119419:ela:4857:19179039,19119530:ela:4857:19178659,19120123:ela:4857:19177372,19120421:ela:4857:19179319,19120422:ela:4857:19179397,19120760:ela:4857:19177605,19120760:ela:4857:19177626,19120761:ela:4857:19179442,19121173:ela:4857:19177468,19121173:ela:4857:19177487,19121348:ela:4857:19176624,19121348:ela:4857:19176643,19121350:ela:4857:19176713,19121350:ela:4857:19176732,19121351:ela:4857:19177027,19121351:ela:4857:19177047,19121352:ela:4857:19177264,19121352:ela:4857:1917728'}, {'unwanted_material': 'encombrant', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.024245367728555192, 'nb_photo': 9, 'list_port_cont': '18931126,18967979,18967999,18971944,18971963,19118001,19118027,19177841,19179385,19467907,19467926,19475112,19475131', 'assoc_port': '18879291:18931126,18941980:18971944,18941980:18971963,18942376:18967979,18942376:18967999,19082881:19118001,19082881:19118027,19120422:19179385,19121762:19177841,19451719:19467907,19451719:19467926,19451721:19475112,19451721:19475131', 'assoc_mat': '18879291:encombrant:4857:18931126,18941980:encombrant:4857:18971944,18941980:encombrant:4857:18971963,18942376:encombrant:4857:18967979,18942376:encombrant:4857:18967999,19082881:encombrant:4857:19118001,19082881:encombrant:4857:19118027,19120422:encombrant:4857:19179385,19121762:encombrant:4857:19177841,19451719:encombrant:4857:19467907,19451719:encombrant:4857:19467926,19451721:encombrant:4857:19475112,19451721:encombrant:4857:19475131'}, {'unwanted_material': 'film_dev_souple', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02753387418414352, 'nb_photo': 1677, 'list_port_cont': '18931099,18931118,18935138,18935157,18956141,18956160,18967971,18967991,18968512,18968531,18969559,18969588,18971936,18971955,18972749,18972768,19079879,19079898,19080881,19080909,19098588,19098607,19099689,19099744,19100677,19100703,19115530,19115559,19115726,19115750,19117992,19118019,19136338,19136358,19140429,19140457,19140693,19140718,19176272,19176291,19176623,19176642,19176712,19176731,19177026,19177046,19177263,19177282,19177352,19177371,19177467,19177486,19177604,19177625,19177814,19177833,19177858,19177877,19177959,19177978,19178028,19178047,19178072,19178091,19178118,19178137,19178212,19178231,19178603,19178658,19178805,19178968,19179038,19179089,19179109,19179138,19179158,19179272,19179318,19179396,19179441,19179510,19333884,19333912,19335123,19335149,19455431,19455450,19456098,19456117,19457831,19457851,19467899,19467918,19475104,19475123,19486992,19487011,19487884,19487903,19489250,19489269,19506763,19571426,19571445,19572709,19572728', 'assoc_port': '18879290:18935138,18879290:18935157,18879291:18931099,18879291:18931118,18939988:18956141,18939988:18956160,18941899:18969559,18941899:18969588,18941980:18971936,18941980:18971955,18942192:18972749,18942192:18972768,18942376:18967971,18942376:18967991,18942377:18968512,18942377:18968531,19061644:19178805,19061693:19079879,19061693:19079898,19061694:19099689,19061694:19099744,19061695:19100677,19061695:19100703,19061849:19115530,19061849:19115559,19061850:19115726,19061850:19115750,19062627:19080881,19062627:19080909,19062628:19098588,19062628:19098607,19082880:19178968,19082881:19117992,19082881:19118019,19119419:19179038,19119530:19178603,19119530:19178658,19120122:19179272,19120123:19177352,19120123:19177371,19120421:19179318,19120422:19179396,19120760:19177604,19120760:19177625,19120761:19179441,19120762:19179510,19121173:19177467,19121173:19177486,19121348:19176623,19121348:19176642,19121350:19176712,19121350:19176731,19121351:19177026,19121351:19177046,19121352:19177263,19121352:19177282,19121761:1917821', 'assoc_mat': '18879290:film_dev_souple:4857:18935138,18879290:film_dev_souple:4857:18935157,18879291:film_dev_souple:4857:18931099,18879291:film_dev_souple:4857:18931118,18939988:film_dev_souple:4857:18956141,18939988:film_dev_souple:4857:18956160,18941899:film_dev_souple:4857:18969559,18941899:film_dev_souple:4857:18969588,18941980:film_dev_souple:4857:18971936,18941980:film_dev_souple:4857:18971955,18942192:film_dev_souple:4857:18972749,18942192:film_dev_souple:4857:18972768,18942376:film_dev_souple:4857:18967971,18942376:film_dev_souple:4857:18967991,18942377:film_dev_souple:4857:18968512,18942377:film_dev_souple:4857:18968531,19061644:film_dev_souple:4857:19178805,19061693:film_dev_souple:4857:19079879,19061693:film_dev_souple:4857:19079898,19061694:film_dev_souple:4857:19099689,19061694:film_dev_souple:4857:19099744,19061695:film_dev_souple:4857:19100677,19061695:film_dev_souple:4857:19100703,19061849:film_dev_souple:4857:19115530,19061849:film_dev_souple:4857:19115559,19061850:film_dev_souple:4857:19115726,19061850:f'}, {'unwanted_material': 'flux_dev', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.02867813702836465, 'nb_photo': 897, 'list_port_cont': '18931098,18931117,18935137,18935156,18956140,18956159,18967970,18967990,18968511,18968530,18969558,18969587,18971935,18971954,18972748,18972767,19079878,19079897,19080880,19080908,19098587,19098606,19099688,19099743,19100676,19100702,19115529,19115558,19117991,19118018,19136337,19136357,19140428,19140456,19140692,19140717,19176271,19176290,19176622,19176641,19176711,19176730,19177025,19177045,19177262,19177281,19177351,19177370,19177466,19177485,19177603,19177624,19177813,19177832,19177857,19177876,19177958,19177977,19178027,19178046,19178071,19178090,19178117,19178136,19178211,19178230,19178602,19178657,19178785,19178804,19178832,19178851,19178948,19178967,19179018,19179037,19179088,19179108,19179137,19179157,19179183,19179202,19179252,19179271,19179298,19179317,19179376,19179395,19179421,19179440,19179490,19179509,19333883,19333911,19335122,19335148,19455430,19455449,19456097,19456116,19467898,19467917,19475103,19475122,19486991,19487010,19487883,19487902,19489249,19489268,19506762,19571425,19571444,1957270', 'assoc_port': '18879290:18935137,18879290:18935156,18879291:18931098,18879291:18931117,18939988:18956140,18939988:18956159,18941899:18969558,18941899:18969587,18941980:18971935,18941980:18971954,18942192:18972748,18942192:18972767,18942376:18967970,18942376:18967990,18942377:18968511,18942377:18968530,19061644:19178785,19061644:19178804,19061645:19178832,19061645:19178851,19061693:19079878,19061693:19079897,19061694:19099688,19061694:19099743,19061695:19100676,19061695:19100702,19061849:19115529,19061849:19115558,19062627:19080880,19062627:19080908,19062628:19098587,19062628:19098606,19082880:19178948,19082880:19178967,19082881:19117991,19082881:19118018,19119419:19179018,19119419:19179037,19119530:19178602,19119530:19178657,19120122:19179252,19120122:19179271,19120123:19177351,19120123:19177370,19120421:19179298,19120421:19179317,19120422:19179376,19120422:19179395,19120760:19177603,19120760:19177624,19120761:19179421,19120761:19179440,19120762:19179490,19120762:19179509,19121173:19177466,19121173:19177485,19121348:1917662', 'assoc_mat': '18879290:flux_dev:4857:18935137,18879290:flux_dev:4857:18935156,18879291:flux_dev:4857:18931098,18879291:flux_dev:4857:18931117,18939988:flux_dev:4857:18956140,18939988:flux_dev:4857:18956159,18941899:flux_dev:4857:18969558,18941899:flux_dev:4857:18969587,18941980:flux_dev:4857:18971935,18941980:flux_dev:4857:18971954,18942192:flux_dev:4857:18972748,18942192:flux_dev:4857:18972767,18942376:flux_dev:4857:18967970,18942376:flux_dev:4857:18967990,18942377:flux_dev:4857:18968511,18942377:flux_dev:4857:18968530,19061644:flux_dev:4857:19178785,19061644:flux_dev:4857:19178804,19061645:flux_dev:4857:19178832,19061645:flux_dev:4857:19178851,19061693:flux_dev:4857:19079878,19061693:flux_dev:4857:19079897,19061694:flux_dev:4857:19099688,19061694:flux_dev:4857:19099743,19061695:flux_dev:4857:19100676,19061695:flux_dev:4857:19100702,19061849:flux_dev:4857:19115529,19061849:flux_dev:4857:19115558,19062627:flux_dev:4857:19080880,19062627:flux_dev:4857:19080908,19062628:flux_dev:4857:19098587,19062628:flux_dev:4857:19098606,'}, {'unwanted_material': 'masque', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.0008057284073268392, 'nb_photo': 3, 'list_port_cont': '18972756,18972775,19179403', 'assoc_port': '18942192:18972756,18942192:18972775,19120422:19179403', 'assoc_mat': '18942192:masque:4857:18972756,18942192:masque:4857:18972775,19120422:masque:4857:19179403'}, {'unwanted_material': 'metal', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.055083991228555396, 'nb_photo': 1153, 'list_port_cont': '18931095,18931114,18935134,18935153,18967967,18967987,18968508,18968527,18969555,18969584,18971932,18971951,18972745,18972764,19079875,19079894,19080877,19080905,19098584,19098603,19099685,19099740,19100672,19100699,19115526,19115555,19115722,19115746,19117988,19118015,19136334,19136354,19140425,19140453,19140689,19140714,19176619,19176638,19176708,19176727,19177022,19177042,19177259,19177278,19177348,19177367,19177463,19177482,19177600,19177620,19177810,19177829,19177854,19177873,19177955,19177974,19178024,19178043,19178068,19178087,19178114,19178133,19178208,19178227,19178599,19178654,19178782,19178801,19178829,19178848,19178945,19178964,19179015,19179034,19179085,19179105,19179134,19179154,19179180,19179199,19179249,19179268,19179295,19179314,19179373,19179392,19179418,19179437,19179487,19179506,19333880,19333908,19335119,19335145,19455427,19455446,19456094,19456113,19457827,19457847,19467895,19467914,19486988,19487007,19487880,19487899,19489246,19489265,19506740,19571422,19571441,19572705,19572724', 'assoc_port': '18879290:18935134,18879290:18935153,18879291:18931095,18879291:18931114,18941899:18969555,18941899:18969584,18941980:18971932,18941980:18971951,18942192:18972745,18942192:18972764,18942376:18967967,18942376:18967987,18942377:18968508,18942377:18968527,19061644:19178782,19061644:19178801,19061645:19178829,19061645:19178848,19061693:19079875,19061693:19079894,19061694:19099685,19061694:19099740,19061695:19100672,19061695:19100699,19061849:19115526,19061849:19115555,19061850:19115722,19061850:19115746,19062627:19080877,19062627:19080905,19062628:19098584,19062628:19098603,19082880:19178945,19082880:19178964,19082881:19117988,19082881:19118015,19119419:19179015,19119419:19179034,19119530:19178599,19119530:19178654,19120122:19179249,19120122:19179268,19120123:19177348,19120123:19177367,19120421:19179295,19120421:19179314,19120422:19179373,19120422:19179392,19120760:19177600,19120760:19177620,19120761:19179418,19120761:19179437,19120762:19179487,19120762:19179506,19121173:19177463,19121173:19177482,19121348:1917661', 'assoc_mat': '18879290:metal:4857:18935134,18879290:metal:4857:18935153,18879291:metal:4857:18931095,18879291:metal:4857:18931114,18941899:metal:4857:18969555,18941899:metal:4857:18969584,18941980:metal:4857:18971932,18941980:metal:4857:18971951,18942192:metal:4857:18972745,18942192:metal:4857:18972764,18942376:metal:4857:18967967,18942376:metal:4857:18967987,18942377:metal:4857:18968508,18942377:metal:4857:18968527,19061644:metal:4857:19178782,19061644:metal:4857:19178801,19061645:metal:4857:19178829,19061645:metal:4857:19178848,19061693:metal:4857:19079875,19061693:metal:4857:19079894,19061694:metal:4857:19099685,19061694:metal:4857:19099740,19061695:metal:4857:19100672,19061695:metal:4857:19100699,19061849:metal:4857:19115526,19061849:metal:4857:19115555,19061850:metal:4857:19115722,19061850:metal:4857:19115746,19062627:metal:4857:19080877,19062627:metal:4857:19080905,19062628:metal:4857:19098584,19062628:metal:4857:19098603,19082880:metal:4857:19178945,19082880:metal:4857:19178964,19082881:metal:4857:19117988,19082881:'}, {'unwanted_material': 'papier', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.13749776840136102, 'nb_photo': 3173, 'list_port_cont': '18931093,18931112,18935132,18935151,18956135,18956154,18967965,18967985,18968506,18968525,18969553,18969582,18971930,18971949,18972743,18972762,19079873,19079892,19080875,19080903,19098582,19098601,19099683,19099738,19100670,19100697,19115524,19115553,19115720,19115743,19117986,19118013,19136332,19136352,19140423,19140451,19140687,19140712,19176266,19176285,19176617,19176636,19176706,19176725,19177020,19177040,19177257,19177276,19177346,19177365,19177461,19177480,19177598,19177618,19177808,19177827,19177852,19177871,19177953,19177972,19178022,19178041,19178066,19178085,19178112,19178131,19178206,19178225,19178597,19178652,19178780,19178799,19178827,19178846,19178943,19178962,19179013,19179032,19179083,19179103,19179132,19179152,19179178,19179197,19179247,19179266,19179293,19179312,19179371,19179390,19179416,19179435,19179485,19179504,19333878,19333906,19335117,19335143,19455425,19455444,19456092,19456111,19457825,19457845,19467893,19467912,19475098,19475117,19486986,19487005,19487878,19487897,19489244,1948926', 'assoc_port': '18879290:18935132,18879290:18935151,18879291:18931093,18879291:18931112,18939988:18956135,18939988:18956154,18941899:18969553,18941899:18969582,18941980:18971930,18941980:18971949,18942192:18972743,18942192:18972762,18942376:18967965,18942376:18967985,18942377:18968506,18942377:18968525,19061644:19178780,19061644:19178799,19061645:19178827,19061645:19178846,19061693:19079873,19061693:19079892,19061694:19099683,19061694:19099738,19061695:19100670,19061695:19100697,19061849:19115524,19061849:19115553,19061850:19115720,19061850:19115743,19062627:19080875,19062627:19080903,19062628:19098582,19062628:19098601,19082880:19178943,19082880:19178962,19082881:19117986,19082881:19118013,19119419:19179013,19119419:19179032,19119530:19178597,19119530:19178652,19120122:19179247,19120122:19179266,19120123:19177346,19120123:19177365,19120421:19179293,19120421:19179312,19120422:19179371,19120422:19179390,19120760:19177598,19120760:19177618,19120761:19179416,19120761:19179435,19120762:19179485,19120762:19179504,19121173:1917746', 'assoc_mat': '18879290:papier:4857:18935132,18879290:papier:4857:18935151,18879291:papier:4857:18931093,18879291:papier:4857:18931112,18939988:papier:4857:18956135,18939988:papier:4857:18956154,18941899:papier:4857:18969553,18941899:papier:4857:18969582,18941980:papier:4857:18971930,18941980:papier:4857:18971949,18942192:papier:4857:18972743,18942192:papier:4857:18972762,18942376:papier:4857:18967965,18942376:papier:4857:18967985,18942377:papier:4857:18968506,18942377:papier:4857:18968525,19061644:papier:4857:19178780,19061644:papier:4857:19178799,19061645:papier:4857:19178827,19061645:papier:4857:19178846,19061693:papier:4857:19079873,19061693:papier:4857:19079892,19061694:papier:4857:19099683,19061694:papier:4857:19099738,19061695:papier:4857:19100670,19061695:papier:4857:19100697,19061849:papier:4857:19115524,19061849:papier:4857:19115553,19061850:papier:4857:19115720,19061850:papier:4857:19115743,19062627:papier:4857:19080875,19062627:papier:4857:19080903,19062628:papier:4857:19098582,19062628:papier:4857:19098601,1908'}, {'unwanted_material': 'pehd', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.008694406286314592, 'nb_photo': 271, 'list_port_cont': '18931097,18931116,18935136,18935155,18956139,18956158,18967969,18967989,18968510,18968529,18969557,18969586,18971934,18971953,18972747,18972766,19079877,19079896,19080879,19080907,19098586,19098605,19099687,19099742,19115528,19115557,19115724,19115748,19117990,19118017,19136336,19136356,19140427,19140455,19140691,19140716,19176270,19176289,19176621,19176640,19176710,19176729,19177024,19177044,19177261,19177280,19177350,19177369,19177465,19177484,19177602,19177623,19177812,19177831,19177856,19177875,19177957,19177976,19178026,19178045,19178070,19178116,19178135,19178210,19178229,19178601,19178656,19178784,19178803,19178831,19178850,19178947,19178966,19179017,19179036,19179087,19179107,19179136,19179156,19179182,19179201,19179251,19179270,19179297,19179316,19179375,19179394,19179420,19179439,19179489,19179508,19333910,19455429,19455448,19467897,19467916,19487882,19487901,19489248,19489267,19506742,19506761,19571424,19571443,19572707,19572726', 'assoc_port': '18879290:18935136,18879290:18935155,18879291:18931097,18879291:18931116,18939988:18956139,18939988:18956158,18941899:18969557,18941899:18969586,18941980:18971934,18941980:18971953,18942192:18972747,18942192:18972766,18942376:18967969,18942376:18967989,18942377:18968510,18942377:18968529,19061644:19178784,19061644:19178803,19061645:19178831,19061645:19178850,19061693:19079877,19061693:19079896,19061694:19099687,19061694:19099742,19061849:19115528,19061849:19115557,19061850:19115724,19061850:19115748,19062627:19080879,19062627:19080907,19062628:19098586,19062628:19098605,19082880:19178947,19082880:19178966,19082881:19117990,19082881:19118017,19119419:19179017,19119419:19179036,19119530:19178601,19119530:19178656,19120122:19179251,19120122:19179270,19120123:19177350,19120123:19177369,19120421:19179297,19120421:19179316,19120422:19179375,19120422:19179394,19120760:19177602,19120760:19177623,19120761:19179420,19120761:19179439,19120762:19179489,19120762:19179508,19121173:19177465,19121173:19177484,19121348:1917662', 'assoc_mat': '18879290:pehd:4857:18935136,18879290:pehd:4857:18935155,18879291:pehd:4857:18931097,18879291:pehd:4857:18931116,18939988:pehd:4857:18956139,18939988:pehd:4857:18956158,18941899:pehd:4857:18969557,18941899:pehd:4857:18969586,18941980:pehd:4857:18971934,18941980:pehd:4857:18971953,18942192:pehd:4857:18972747,18942192:pehd:4857:18972766,18942376:pehd:4857:18967969,18942376:pehd:4857:18967989,18942377:pehd:4857:18968510,18942377:pehd:4857:18968529,19061644:pehd:4857:19178784,19061644:pehd:4857:19178803,19061645:pehd:4857:19178831,19061645:pehd:4857:19178850,19061693:pehd:4857:19079877,19061693:pehd:4857:19079896,19061694:pehd:4857:19099687,19061694:pehd:4857:19099742,19061849:pehd:4857:19115528,19061849:pehd:4857:19115557,19061850:pehd:4857:19115724,19061850:pehd:4857:19115748,19062627:pehd:4857:19080879,19062627:pehd:4857:19080907,19062628:pehd:4857:19098586,19062628:pehd:4857:19098605,19082880:pehd:4857:19178947,19082880:pehd:4857:19178966,19082881:pehd:4857:19117990,19082881:pehd:4857:19118017,19119419:pehd:48'}, {'unwanted_material': 'pet_clair', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.020800550400248825, 'nb_photo': 1575, 'list_port_cont': '18931096,18931115,18935135,18935154,18956138,18956157,18967968,18967988,18968509,18968528,18969556,18969585,18971933,18971952,18972746,18972765,19079876,19079895,19080878,19080906,19098585,19098604,19099686,19099741,19100673,19100700,19115527,19115556,19115723,19115747,19117989,19118016,19136335,19136355,19140426,19140454,19140690,19140715,19176269,19176288,19176620,19176639,19176709,19176728,19177023,19177043,19177260,19177279,19177349,19177368,19177464,19177483,19177601,19177621,19177811,19177830,19177855,19177874,19177956,19177975,19178025,19178044,19178069,19178088,19178115,19178134,19178209,19178228,19178600,19178655,19178783,19178802,19178830,19178849,19178946,19178965,19179016,19179035,19179086,19179106,19179135,19179155,19179181,19179200,19179250,19179269,19179296,19179315,19179374,19179393,19179419,19179438,19179488,19179507,19333881,19333909,19335120,19335146,19455428,19455447,19456095,19456114,19457828,19457848,19467896,19467915,19475101,19475120,19486989,19487008,19487881,19487900,19489247,1948926', 'assoc_port': '18879290:18935135,18879290:18935154,18879291:18931096,18879291:18931115,18939988:18956138,18939988:18956157,18941899:18969556,18941899:18969585,18941980:18971933,18941980:18971952,18942192:18972746,18942192:18972765,18942376:18967968,18942376:18967988,18942377:18968509,18942377:18968528,19061644:19178783,19061644:19178802,19061645:19178830,19061645:19178849,19061693:19079876,19061693:19079895,19061694:19099686,19061694:19099741,19061695:19100673,19061695:19100700,19061849:19115527,19061849:19115556,19061850:19115723,19061850:19115747,19062627:19080878,19062627:19080906,19062628:19098585,19062628:19098604,19082880:19178946,19082880:19178965,19082881:19117989,19082881:19118016,19119419:19179016,19119419:19179035,19119530:19178600,19119530:19178655,19120122:19179250,19120122:19179269,19120123:19177349,19120123:19177368,19120421:19179296,19120421:19179315,19120422:19179374,19120422:19179393,19120760:19177601,19120760:19177621,19120761:19179419,19120761:19179438,19120762:19179488,19120762:19179507,19121173:1917746', 'assoc_mat': '18879290:pet_clair:4857:18935135,18879290:pet_clair:4857:18935154,18879291:pet_clair:4857:18931096,18879291:pet_clair:4857:18931115,18939988:pet_clair:4857:18956138,18939988:pet_clair:4857:18956157,18941899:pet_clair:4857:18969556,18941899:pet_clair:4857:18969585,18941980:pet_clair:4857:18971933,18941980:pet_clair:4857:18971952,18942192:pet_clair:4857:18972746,18942192:pet_clair:4857:18972765,18942376:pet_clair:4857:18967968,18942376:pet_clair:4857:18967988,18942377:pet_clair:4857:18968509,18942377:pet_clair:4857:18968528,19061644:pet_clair:4857:19178783,19061644:pet_clair:4857:19178802,19061645:pet_clair:4857:19178830,19061645:pet_clair:4857:19178849,19061693:pet_clair:4857:19079876,19061693:pet_clair:4857:19079895,19061694:pet_clair:4857:19099686,19061694:pet_clair:4857:19099741,19061695:pet_clair:4857:19100673,19061695:pet_clair:4857:19100700,19061849:pet_clair:4857:19115527,19061849:pet_clair:4857:19115556,19061850:pet_clair:4857:19115723,19061850:pet_clair:4857:19115747,19062627:pet_clair:4857:19080878,1'}, {'unwanted_material': 'sac_om_plein', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.20422874167683033, 'nb_photo': 1334, 'list_port_cont': '18931101,18931120,18935140,18935159,18956143,18956162,18967973,18967993,18968514,18968533,18969561,18969590,18971938,18971957,18972751,18972770,19079881,19079900,19080883,19080911,19098590,19098609,19099691,19099746,19100679,19100705,19115532,19115561,19115728,19115753,19117994,19118021,19136340,19136360,19140431,19140459,19140695,19140720,19176274,19176293,19176625,19176644,19176714,19176733,19177028,19177048,19177265,19177284,19177354,19177373,19177469,19177488,19177606,19177627,19177816,19177835,19177860,19177879,19177961,19177980,19178030,19178049,19178074,19178093,19178120,19178139,19178214,19178233,19178605,19178660,19178788,19178807,19178835,19178854,19178951,19178970,19179021,19179040,19179091,19179111,19179140,19179160,19179186,19179205,19179255,19179274,19179301,19179320,19179379,19179398,19179424,19179443,19179493,19179512,19333886,19333914,19335125,19335151,19455433,19455452,19456100,19456119,19457833,19457853,19467901,19467920,19475106,19475125,19486994,19487013,19487886,19487905,19489252,1948927', 'assoc_port': '18879290:18935140,18879290:18935159,18879291:18931101,18879291:18931120,18939988:18956143,18939988:18956162,18941899:18969561,18941899:18969590,18941980:18971938,18941980:18971957,18942192:18972751,18942192:18972770,18942376:18967973,18942376:18967993,18942377:18968514,18942377:18968533,19061644:19178788,19061644:19178807,19061645:19178835,19061645:19178854,19061693:19079881,19061693:19079900,19061694:19099691,19061694:19099746,19061695:19100679,19061695:19100705,19061849:19115532,19061849:19115561,19061850:19115728,19061850:19115753,19062627:19080883,19062627:19080911,19062628:19098590,19062628:19098609,19082880:19178951,19082880:19178970,19082881:19117994,19082881:19118021,19119419:19179021,19119419:19179040,19119530:19178605,19119530:19178660,19120122:19179255,19120122:19179274,19120123:19177354,19120123:19177373,19120421:19179301,19120421:19179320,19120422:19179379,19120422:19179398,19120760:19177606,19120760:19177627,19120761:19179424,19120761:19179443,19120762:19179493,19120762:19179512,19121173:1917746', 'assoc_mat': '18879290:sac_om_plein:4857:18935140,18879290:sac_om_plein:4857:18935159,18879291:sac_om_plein:4857:18931101,18879291:sac_om_plein:4857:18931120,18939988:sac_om_plein:4857:18956143,18939988:sac_om_plein:4857:18956162,18941899:sac_om_plein:4857:18969561,18941899:sac_om_plein:4857:18969590,18941980:sac_om_plein:4857:18971938,18941980:sac_om_plein:4857:18971957,18942192:sac_om_plein:4857:18972751,18942192:sac_om_plein:4857:18972770,18942376:sac_om_plein:4857:18967973,18942376:sac_om_plein:4857:18967993,18942377:sac_om_plein:4857:18968514,18942377:sac_om_plein:4857:18968533,19061644:sac_om_plein:4857:19178788,19061644:sac_om_plein:4857:19178807,19061645:sac_om_plein:4857:19178835,19061645:sac_om_plein:4857:19178854,19061693:sac_om_plein:4857:19079881,19061693:sac_om_plein:4857:19079900,19061694:sac_om_plein:4857:19099691,19061694:sac_om_plein:4857:19099746,19061695:sac_om_plein:4857:19100679,19061695:sac_om_plein:4857:19100705,19061849:sac_om_plein:4857:19115532,19061849:sac_om_plein:4857:19115561,19061850:sac_om_'}, {'unwanted_material': 'textiles', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.010069962291664132, 'nb_photo': 196, 'list_port_cont': '18931102,18931121,18935141,18935160,18956144,18956163,18969562,18969591,18971939,18971958,18972752,19079882,19079901,19098591,19098610,19100680,19100706,19115533,19115562,19136341,19136361,19140696,19140721,19176275,19176294,19176626,19176645,19176715,19176734,19177029,19177049,19177355,19177607,19177628,19177836,19177861,19177880,19177981,19178215,19178234,19178789,19178808,19178836,19178855,19178952,19178971,19179022,19179041,19179092,19179112,19179187,19179206,19179256,19179275,19179302,19179321,19179380,19179399,19179425,19179444,19179494,19179513,19333887,19333915,19455434,19455453,19456101,19456120,19457834,19457854,19486995,19487014,19489253,19489272,19506747,19506766', 'assoc_port': '18879290:18935141,18879290:18935160,18879291:18931102,18879291:18931121,18939988:18956144,18939988:18956163,18941899:18969562,18941899:18969591,18941980:18971939,18941980:18971958,18942192:18972752,19061644:19178789,19061644:19178808,19061645:19178836,19061645:19178855,19061693:19079882,19061693:19079901,19061695:19100680,19061695:19100706,19061849:19115533,19061849:19115562,19062628:19098591,19062628:19098610,19082880:19178952,19082880:19178971,19119419:19179022,19119419:19179041,19120122:19179256,19120122:19179275,19120123:19177355,19120421:19179302,19120421:19179321,19120422:19179380,19120422:19179399,19120760:19177607,19120760:19177628,19120761:19179425,19120761:19179444,19120762:19179494,19120762:19179513,19121348:19176626,19121348:19176645,19121349:19179187,19121349:19179206,19121350:19176715,19121350:19176734,19121351:19177029,19121351:19177049,19121761:19178215,19121761:19178234,19121762:19177836,19122780:19176275,19122780:19176294,19122782:19140696,19122782:19140721,19123092:19179092,19123092:1917911', 'assoc_mat': '18879290:textiles:4857:18935141,18879290:textiles:4857:18935160,18879291:textiles:4857:18931102,18879291:textiles:4857:18931121,18939988:textiles:4857:18956144,18939988:textiles:4857:18956163,18941899:textiles:4857:18969562,18941899:textiles:4857:18969591,18941980:textiles:4857:18971939,18941980:textiles:4857:18971958,18942192:textiles:4857:18972752,19061644:textiles:4857:19178789,19061644:textiles:4857:19178808,19061645:textiles:4857:19178836,19061645:textiles:4857:19178855,19061693:textiles:4857:19079882,19061693:textiles:4857:19079901,19061695:textiles:4857:19100680,19061695:textiles:4857:19100706,19061849:textiles:4857:19115533,19061849:textiles:4857:19115562,19062628:textiles:4857:19098591,19062628:textiles:4857:19098610,19082880:textiles:4857:19178952,19082880:textiles:4857:19178971,19119419:textiles:4857:19179022,19119419:textiles:4857:19179041,19120122:textiles:4857:19179256,19120122:textiles:4857:19179275,19120123:textiles:4857:19177355,19120421:textiles:4857:19179302,19120421:textiles:4857:19179321,'}, {'unwanted_material': 'verre', 'main_material': 'entrant', 'pht_type': 4857, 'ratio': 0.012965507188723175, 'nb_photo': 37, 'list_port_cont': '19115534,19115563,19115730,19115755,19136342,19136362,19140697,19140722,19178953,19178972,19179042,19179188,19179207,19179303,19179381,19179426,19179445,19179495,19179514,19333916', 'assoc_port': '19061849:19115534,19061849:19115563,19061850:19115730,19061850:19115755,19082880:19178953,19082880:19178972,19119419:19179042,19120421:19179303,19120422:19179381,19120761:19179426,19120761:19179445,19120762:19179495,19120762:19179514,19121349:19179188,19121349:19179207,19122782:19140697,19122782:19140722,19123093:19136342,19123093:19136362,19324570:19333916', 'assoc_mat': '19061849:verre:4857:19115534,19061849:verre:4857:19115563,19061850:verre:4857:19115730,19061850:verre:4857:19115755,19082880:verre:4857:19178953,19082880:verre:4857:19178972,19119419:verre:4857:19179042,19120421:verre:4857:19179303,19120422:verre:4857:19179381,19120761:verre:4857:19179426,19120761:verre:4857:19179445,19120762:verre:4857:19179495,19120762:verre:4857:19179514,19121349:verre:4857:19179188,19121349:verre:4857:19179207,19122782:verre:4857:19140697,19122782:verre:4857:19140722,19123093:verre:4857:19136342,19123093:verre:4857:19136362,19324570:verre:4857:19333916'}), 'main_stat': {'nb_photos': 669}}, 'hostname': (), 'impurety_average_per_hashtag': [(('entrant', '2024-12', 0.2099124318620656),)]} filepath : /data_2/data_log/job/memo/SyctomXV/sla_mensuel_SyctomXV_Mask_23Q4_mois_12_annee_2024.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Before organize_and_plot_unwanted_material_stats {'entrant': {'autre_non_emballage': ['autre_non_emballage', '2.94%', 794], 'carton': ['carton', '59.1%', 11359], 'dasri': ['dasri', '0.0%', 5], 'ela': ['ela', '0.74%', 100], 'encombrant': ['encombrant', '2.42%', 9], 'film_dev_souple': ['film_dev_souple', '2.75%', 1677], 'flux_dev': ['flux_dev', '2.87%', 897], 'masque': ['masque', '0.08%', 3], 'metal': ['metal', '5.51%', 1153], 'papier': ['papier', '13.75%', 3173], 'pehd': ['pehd', '0.87%', 271], 'pet_clair': ['pet_clair', '2.08%', 1575], 'sac_om_plein': ['sac_om_plein', '20.42%', 1334], 'textiles': ['textiles', '1.01%', 196], 'verre': ['verre', '1.3%', 37]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SyctomXV/sla_mensuel_SyctomXV_Mask_23Q4_mois_12_annee_2024.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SyctomXV 3.03user 2.71system 0:05.05elapsed 113%CPU (0avgtext+0avgdata 190904maxresident)k 20624inputs+376outputs (109major+63334minor)pagefaults 0swaps