python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --job=sla_mensuel --raspi=20092 --dashboard_places=refus_amiens --rootfolder_sla=/data_2/data_log/job/memo/refus_amiens -v --mtr_id=983 --date=`date -d"$nowdate 15 day ago" +%Y-%m` ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : 20092, Date : 2025-04 _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 : (1, 30) 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 ! 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 ! 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 ! 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 ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (1, 30) 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 ! 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 ! 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 ! 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 ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 15 month : 04 mtr_id : 983 dashboard_places : refus_amiens date : 2025-04 year : 2025 raspi : 20092 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 = 'refus_amiens' and date like '%2025-04%') and created_at like '%2025-04%'))); nb_day : (1, 30) after unwanted_material_data nb_day : (1, 30) WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used WARNING: No hour configured for port 20092, from 00:00 to 24:00 used SQL: SELECT ms.id, ms.name, mst.name as type, ms.test_group, ms.test_name, ms.server, ms.version_code, ms.result_str, ms.result_bool, ms.result_float, ms.lien, ms.created_at FROM MTRAdmin.monitor_sys ms INNER JOIN MTRAdmin.monitor_sys_type mst on mst.id = ms.type WHERE ms.test_name like '%20092%' AND ms.result_str like '%2025/04%'ORDER BY ms.id desc LIMIT 0, 1000000; Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! Missing day sla_per_day needs to be called ! We will need to call the sla_per_day for these missing days : 2025-04-01 00:00:00,2025-04-02 00:00:00,2025-04-03 00:00:00,2025-04-04 00:00:00,2025-04-05 00:00:00,2025-04-06 00:00:00,2025-04-07 00:00:00,2025-04-08 00:00:00,2025-04-09 00:00:00,2025-04-10 00:00:00,2025-04-11 00:00:00,2025-04-12 00:00:00,2025-04-13 00:00:00,2025-04-14 00:00:00,2025-04-15 00:00:00,2025-04-16 00:00:00,2025-04-17 00:00:00,2025-04-18 00:00:00,2025-04-19 00:00:00,2025-04-20 00:00:00,2025-04-21 00:00:00,2025-04-22 00:00:00,2025-04-23 00:00:00,2025-04-24 00:00:00,2025-04-25 00:00:00,2025-04-26 00:00:00,2025-04-27 00:00:00,2025-04-28 00:00:00,2025-04-29 00:00:00,2025-04-30 00:00:00 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 = 15 and month(ded.date) = 04 and year(ded.date) = 2025 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 = '_______refus' and ded.dashboard_place_id = 15 and month(ded.date) = 04 and year(ded.date) = 2025 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 = 15 and mp.name like '%042025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-04-01 : dt_date_just_month_year : 2025-04-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= "refus_amiens" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-04-01" AND ded.date <= "2025-04-30" apple3 {'refus': {'mat': 'refus', 'pht': 4213, 'datou_carac_id': 3996, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus,textiles_sanitaires'}} 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 (1717453,1720479,1722022,1729930,1729452,1733361,1737890,1740075,1740577,1743830,1747622,1751855,1755838,1761432,1765842,1765821,1769843) 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 group by h.hashtag, dr.hashtag, ptp.type; VR TODO TO BETTER PARSE ! ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004108143242236501, 'nb_photo': 2246, 'list_port_cont': '21937821,21939162,21939746,21941786,21942286,21942545,21942710,21943656,21944041,21944452,21944820,21944855,21944892,21948133,21948695,21951644,21954467,21954496,21956205,21956628,21958502,21960306,21962713,21963637,21967999,21969915,21973608,21975500,21975800,21977007,21979024,21979274,21979535,21979655,21983684,21985983,21987573,21987720,21987872,21987946,21990023,21991769,21992349,21996567,21999338,22010235,22011237,22012691,22014637,22015182,22015551,22017043,22017719,22018831,22019753,22020338,22023199,22023576,22026100,22026474,22026711,22028391,22028723,22028802,22029232,22029374,22032118,22034309,22037607,22040747,22042545,22045690,22049555,22049900,22050612,22052435,22052797,22053826,22054025,22054398,22056638,22057265,22064001,22065163,22066559,22067770,22068399,22068561,22070705,22072133,22072562,22076257,22076688,22078508,22080961,22081709,22086857,22097057,22101172,22101851,22106600,22109817,22111064,22122018,22122445,22122480,22122525,22122682,22123080,22124555,22125261,22125331,22127464,2213174', 'assoc_port': '21936862:21944855,21936863:21944892,21936864:21944041,21936865:21942286,21936890:21937821,21936891:21942710,21938118:21939162,21939370:21939746,21941592:21941786,21942442:21942545,21943568:21943656,21944347:21944452,21944620:21944820,21947409:21948133,21947410:21956205,21948383:21948695,21951418:21951644,21954280:21954496,21954281:21954467,21956389:21956628,21958293:21958502,21960222:21960306,21962610:21962713,21963434:21963637,21967261:21979274,21967262:21979535,21967263:21967999,21967264:21979655,21967265:21987573,21967266:21987720,21967267:21987872,21969569:21969915,21972738:21975500,21972739:21973608,21975410:21991769,21975411:21990023,21975412:21977007,21975413:21979024,21975414:21975800,21980179:21987946,21982976:21983684,21985604:21985983,21991685:21992349,21996082:21996567,21998719:21999338,22009703:22017043,22009706:22019753,22009708:22015182,22009713:22011237,22009717:22014637,22009719:22010235,22009721:22018831,22012335:22012691,22015078:22015551,22017423:22017719,22019959:22020338,22023102:2202319', 'assoc_mat': '21936862:barquette_opaque:4213:21944855,21936863:barquette_opaque:4213:21944892,21936864:barquette_opaque:4213:21944041,21936865:barquette_opaque:4213:21942286,21936890:barquette_opaque:4213:21937821,21936891:barquette_opaque:4213:21942710,21938118:barquette_opaque:4213:21939162,21939370:barquette_opaque:4213:21939746,21941592:barquette_opaque:4213:21941786,21942442:barquette_opaque:4213:21942545,21943568:barquette_opaque:4213:21943656,21944347:barquette_opaque:4213:21944452,21944620:barquette_opaque:4213:21944820,21947409:barquette_opaque:4213:21948133,21947410:barquette_opaque:4213:21956205,21948383:barquette_opaque:4213:21948695,21951418:barquette_opaque:4213:21951644,21954280:barquette_opaque:4213:21954496,21954281:barquette_opaque:4213:21954467,21956389:barquette_opaque:4213:21956628,21958293:barquette_opaque:4213:21958502,21960222:barquette_opaque:4213:21960306,21962610:barquette_opaque:4213:21962713,21963434:barquette_opaque:4213:21963637,21967261:barquette_opaque:4213:21979274,21967262:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.002458002690027309, 'nb_photo': 2501, 'list_port_cont': '21937830,21939168,21939750,21941788,21942278,21942544,21942711,21943655,21944049,21944463,21944830,21944861,21944898,21948138,21948691,21951655,21954462,21954502,21956215,21956639,21958505,21960307,21962715,21963635,21967984,21969920,21973605,21975504,21975796,21977012,21979016,21979286,21979525,21979650,21983680,21985984,21987572,21987721,21987808,21987865,21987945,21990018,21991772,21992341,21996561,21999339,22010228,22011231,22012680,22014638,22015191,22017045,22017718,22018818,22019740,22020336,22023201,22023573,22025976,22026108,22026479,22026705,22028394,22028724,22028813,22029242,22029371,22032116,22034320,22037604,22040749,22042538,22045677,22049561,22049896,22050613,22052439,22052783,22053835,22054028,22054396,22056618,22057266,22064000,22065171,22066566,22067778,22068410,22068566,22070689,22072127,22072566,22076250,22078511,22080971,22081713,22086854,22091685,22101177,22101850,22106592,22109806,22111065,22121894,22122028,22122452,22122478,22122526,22122667,22123090,22124550,22125265,22125338,2212745', 'assoc_port': '21936862:21944861,21936863:21944898,21936864:21944049,21936865:21942278,21936890:21937830,21936891:21942711,21938118:21939168,21939370:21939750,21941592:21941788,21942442:21942544,21943568:21943655,21944347:21944463,21944620:21944830,21947409:21948138,21947410:21956215,21948383:21948691,21951418:21951655,21954280:21954502,21954281:21954462,21956389:21956639,21958293:21958505,21960222:21960307,21962610:21962715,21963434:21963635,21967261:21979286,21967262:21979525,21967263:21967984,21967264:21979650,21967265:21987572,21967266:21987721,21967267:21987865,21969569:21969920,21972738:21975504,21972739:21973605,21975410:21991772,21975411:21990018,21975412:21977012,21975413:21979016,21975414:21975796,21980179:21987945,21982976:21983680,21982979:21987808,21985604:21985984,21991685:21992341,21996082:21996561,21998719:21999339,22009703:22017045,22009706:22019740,22009708:22015191,22009713:22011231,22009717:22014638,22009719:22010228,22009721:22018818,22012335:22012680,22017423:22017718,22019959:22020336,22023102:2202320', 'assoc_mat': '21936862:carton:4213:21944861,21936863:carton:4213:21944898,21936864:carton:4213:21944049,21936865:carton:4213:21942278,21936890:carton:4213:21937830,21936891:carton:4213:21942711,21938118:carton:4213:21939168,21939370:carton:4213:21939750,21941592:carton:4213:21941788,21942442:carton:4213:21942544,21943568:carton:4213:21943655,21944347:carton:4213:21944463,21944620:carton:4213:21944830,21947409:carton:4213:21948138,21947410:carton:4213:21956215,21948383:carton:4213:21948691,21951418:carton:4213:21951655,21954280:carton:4213:21954502,21954281:carton:4213:21954462,21956389:carton:4213:21956639,21958293:carton:4213:21958505,21960222:carton:4213:21960307,21962610:carton:4213:21962715,21963434:carton:4213:21963635,21967261:carton:4213:21979286,21967262:carton:4213:21979525,21967263:carton:4213:21967984,21967264:carton:4213:21979650,21967265:carton:4213:21987572,21967266:carton:4213:21987721,21967267:carton:4213:21987865,21969569:carton:4213:21969920,21972738:carton:4213:21975504,21972739:carton:4213:21973605,2197'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004443851377616915, 'nb_photo': 813, 'list_port_cont': '21937831,21941796,21942272,21942537,21942703,21943662,21944052,21944458,21944822,21944854,21948129,21948689,21951651,21954503,21956208,21956635,21960314,21963647,21967988,21969913,21973614,21975505,21976999,21979279,21979536,21979646,21983690,21985981,21987578,21987867,21987935,21990017,21991770,21996565,21999346,22011243,22012678,22014630,22015180,22015560,22017033,22018822,22020328,22023196,22023575,22026094,22026470,22026718,22028395,22028733,22028804,22029245,22029378,22034307,22040750,22042534,22045685,22049567,22052443,22052795,22053839,22054022,22056624,22057268,22064006,22065165,22066571,22068564,22070704,22072122,22076248,22080967,22081718,22086856,22097069,22101176,22101843,22106602,22109811,22111075,22122030,22122446,22122522,22122677,22123092,22124556,22125264,22125340,22131748,22132016,22135579,22139185,22142832,22150440,22151050,22153499,22158515,22163121,22163214,22176190,22176308,22176355,22176655,22176745,22181024,22182630,22189816,22191924,22197112,22201221,22205037,22210788,22215933,2222747', 'assoc_port': '21936862:21944854,21936864:21944052,21936865:21942272,21936890:21937831,21936891:21942703,21941592:21941796,21942442:21942537,21943568:21943662,21944347:21944458,21944620:21944822,21947409:21948129,21947410:21956208,21948383:21948689,21951418:21951651,21954280:21954503,21956389:21956635,21960222:21960314,21963434:21963647,21967261:21979279,21967262:21979536,21967263:21967988,21967264:21979646,21967265:21987578,21967267:21987867,21969569:21969913,21972738:21975505,21972739:21973614,21975410:21991770,21975411:21990017,21975412:21976999,21980179:21987935,21982976:21983690,21985604:21985981,21996082:21996565,21998719:21999346,22009703:22017033,22009708:22015180,22009713:22011243,22009717:22014630,22009721:22018822,22012335:22012678,22015078:22015560,22019959:22020328,22023102:22023196,22023491:22023575,22025770:22026094,22026342:22026718,22026343:22026470,22027664:22057268,22028201:22028395,22028577:22028804,22028579:22028733,22029158:22029378,22029159:22029245,22033902:22054022,22033904:22034307,22037011:2205383', 'assoc_mat': '21936862:ela:4213:21944854,21936864:ela:4213:21944052,21936865:ela:4213:21942272,21936890:ela:4213:21937831,21936891:ela:4213:21942703,21941592:ela:4213:21941796,21942442:ela:4213:21942537,21943568:ela:4213:21943662,21944347:ela:4213:21944458,21944620:ela:4213:21944822,21947409:ela:4213:21948129,21947410:ela:4213:21956208,21948383:ela:4213:21948689,21951418:ela:4213:21951651,21954280:ela:4213:21954503,21956389:ela:4213:21956635,21960222:ela:4213:21960314,21963434:ela:4213:21963647,21967261:ela:4213:21979279,21967262:ela:4213:21979536,21967263:ela:4213:21967988,21967264:ela:4213:21979646,21967265:ela:4213:21987578,21967267:ela:4213:21987867,21969569:ela:4213:21969913,21972738:ela:4213:21975505,21972739:ela:4213:21973614,21975410:ela:4213:21991770,21975411:ela:4213:21990017,21975412:ela:4213:21976999,21980179:ela:4213:21987935,21982976:ela:4213:21983690,21985604:ela:4213:21985981,21996082:ela:4213:21996565,21998719:ela:4213:21999346,22009703:ela:4213:22017033,22009708:ela:4213:22015180,22009713:ela:4213:2201124'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003038590602422445, 'nb_photo': 3002, 'list_port_cont': '21937832,21939163,21939737,21941797,21942271,21942543,21942714,21943657,21944045,21944459,21944829,21944866,21944889,21948137,21948682,21951643,21954468,21954505,21956210,21956629,21958503,21960317,21962726,21963646,21967993,21969912,21973603,21975499,21975794,21977009,21979027,21979287,21979521,21979647,21983235,21983683,21985972,21987576,21987718,21987859,21987931,21988184,21990028,21991774,21992347,21996570,21999347,22010232,22011229,22012692,22014636,22015186,22015549,22017041,22017725,22018819,22019747,22020332,22023191,22023569,22025985,22026106,22026477,22026719,22028381,22028721,22028803,22029240,22029382,22032130,22034319,22037606,22040746,22042541,22045692,22049563,22049903,22050621,22052444,22052792,22053838,22054034,22054399,22056636,22057261,22064004,22065170,22066561,22067781,22068406,22068569,22070695,22072126,22072552,22076246,22076689,22078509,22080959,22081706,22086858,22088449,22091694,22097058,22101169,22101848,22106604,22109816,22111074,22121899,22122034,22122444,22122481,22122517,2212267', 'assoc_port': '21936862:21944866,21936863:21944889,21936864:21944045,21936865:21942271,21936890:21937832,21936891:21942714,21938118:21939163,21939370:21939737,21941592:21941797,21942442:21942543,21943568:21943657,21944347:21944459,21944620:21944829,21947409:21948137,21947410:21956210,21948383:21948682,21951418:21951643,21954280:21954505,21954281:21954468,21956389:21956629,21958293:21958503,21960222:21960317,21962610:21962726,21963434:21963646,21967261:21979287,21967262:21979521,21967263:21967993,21967264:21979647,21967265:21987576,21967266:21987718,21967267:21987859,21969569:21969912,21972738:21975499,21972739:21973603,21975410:21991774,21975411:21990028,21975412:21977009,21975413:21979027,21975414:21975794,21980179:21987931,21982976:21983683,21982980:21983235,21985604:21985972,21987906:21988184,21991685:21992347,21996082:21996570,21998719:21999347,22009703:22017041,22009706:22019747,22009708:22015186,22009713:22011229,22009717:22014636,22009719:22010232,22009721:22018819,22012335:22012692,22015078:22015549,22017423:2201772', 'assoc_mat': '21936862:etiquette:4213:21944866,21936863:etiquette:4213:21944889,21936864:etiquette:4213:21944045,21936865:etiquette:4213:21942271,21936890:etiquette:4213:21937832,21936891:etiquette:4213:21942714,21938118:etiquette:4213:21939163,21939370:etiquette:4213:21939737,21941592:etiquette:4213:21941797,21942442:etiquette:4213:21942543,21943568:etiquette:4213:21943657,21944347:etiquette:4213:21944459,21944620:etiquette:4213:21944829,21947409:etiquette:4213:21948137,21947410:etiquette:4213:21956210,21948383:etiquette:4213:21948682,21951418:etiquette:4213:21951643,21954280:etiquette:4213:21954505,21954281:etiquette:4213:21954468,21956389:etiquette:4213:21956629,21958293:etiquette:4213:21958503,21960222:etiquette:4213:21960317,21962610:etiquette:4213:21962726,21963434:etiquette:4213:21963646,21967261:etiquette:4213:21979287,21967262:etiquette:4213:21979521,21967263:etiquette:4213:21967993,21967264:etiquette:4213:21979647,21967265:etiquette:4213:21987576,21967266:etiquette:4213:21987718,21967267:etiquette:4213:21987859,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03274580738220678, 'nb_photo': 7891, 'list_port_cont': '21937818,21939175,21939740,21941790,21942276,21942534,21942712,21943653,21944044,21944468,21944823,21944853,21944888,21948124,21948693,21951647,21954463,21954509,21956213,21956627,21958510,21960322,21962720,21963644,21967985,21969910,21973618,21975498,21975790,21977000,21979018,21979275,21979534,21979651,21983681,21985975,21987570,21987715,21987869,21987944,21988183,21990029,21991760,21992348,21996564,21999336,22010236,22011230,22012677,22014626,22015181,22015557,22017038,22017717,22018823,22019748,22020339,22023185,22023578,22025980,22026096,22026482,22026709,22028390,22028729,22028801,22029237,22029381,22032129,22034317,22037595,22040744,22042547,22045687,22049552,22049895,22050614,22052437,22052798,22053830,22054024,22054391,22056616,22057270,22064005,22065166,22066557,22067780,22068411,22068576,22068705,22070693,22072129,22072563,22076244,22076686,22078507,22080960,22081702,22086846,22088448,22091682,22097060,22101173,22101844,22106597,22109813,22111068,22121887,22122026,22122447,22122483,22122520,2212268', 'assoc_port': '21936862:21944853,21936863:21944888,21936864:21944044,21936865:21942276,21936890:21937818,21936891:21942712,21938118:21939175,21939370:21939740,21941592:21941790,21942442:21942534,21943568:21943653,21944347:21944468,21944620:21944823,21947409:21948124,21947410:21956213,21948383:21948693,21951418:21951647,21954280:21954509,21954281:21954463,21956389:21956627,21958293:21958510,21960222:21960322,21962610:21962720,21963434:21963644,21967261:21979275,21967262:21979534,21967263:21967985,21967264:21979651,21967265:21987570,21967266:21987715,21967267:21987869,21969569:21969910,21972738:21975498,21972739:21973618,21975410:21991760,21975411:21990029,21975412:21977000,21975413:21979018,21975414:21975790,21980179:21987944,21982976:21983681,21985604:21985975,21987906:21988183,21991685:21992348,21996082:21996564,21998719:21999336,22009703:22017038,22009706:22019748,22009708:22015181,22009713:22011230,22009717:22014626,22009719:22010236,22009721:22018823,22012335:22012677,22015078:22015557,22017423:22017717,22019959:2202033', 'assoc_mat': '21936862:film_plastique:4213:21944853,21936863:film_plastique:4213:21944888,21936864:film_plastique:4213:21944044,21936865:film_plastique:4213:21942276,21936890:film_plastique:4213:21937818,21936891:film_plastique:4213:21942712,21938118:film_plastique:4213:21939175,21939370:film_plastique:4213:21939740,21941592:film_plastique:4213:21941790,21942442:film_plastique:4213:21942534,21943568:film_plastique:4213:21943653,21944347:film_plastique:4213:21944468,21944620:film_plastique:4213:21944823,21947409:film_plastique:4213:21948124,21947410:film_plastique:4213:21956213,21948383:film_plastique:4213:21948693,21951418:film_plastique:4213:21951647,21954280:film_plastique:4213:21954509,21954281:film_plastique:4213:21954463,21956389:film_plastique:4213:21956627,21958293:film_plastique:4213:21958510,21960222:film_plastique:4213:21960322,21962610:film_plastique:4213:21962720,21963434:film_plastique:4213:21963644,21967261:film_plastique:4213:21979275,21967262:film_plastique:4213:21979534,21967263:film_plastique:4213:2196798'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0007051638095873881, 'nb_photo': 23, 'list_port_cont': '21942277,21944864,21969916,21977011,22057267,22072137,22101180,22125330,22163117,22244944,22248072,22270905,22272865,22331009,22355412,22372238,22448590,22477742,22487918,22540430,22575382', 'assoc_port': '21936862:21944864,21936865:21942277,21969569:21969916,21975412:21977011,22027664:22057267,22062303:22072137,22099990:22101180,22125241:22125330,22162864:22163117,22244778:22244944,22247768:22248072,22270725:22270905,22272668:22272865,22328684:22331009,22355014:22355412,22370563:22372238,22448178:22448590,22477089:22477742,22487766:22487918,22539960:22540430,22575196:22575382', 'assoc_mat': '21936862:kraft:4213:21944864,21936865:kraft:4213:21942277,21969569:kraft:4213:21969916,21975412:kraft:4213:21977011,22027664:kraft:4213:22057267,22062303:kraft:4213:22072137,22099990:kraft:4213:22101180,22125241:kraft:4213:22125330,22162864:kraft:4213:22163117,22244778:kraft:4213:22244944,22247768:kraft:4213:22248072,22270725:kraft:4213:22270905,22272668:kraft:4213:22272865,22328684:kraft:4213:22331009,22355014:kraft:4213:22355412,22370563:kraft:4213:22372238,22448178:kraft:4213:22448590,22477089:kraft:4213:22477742,22487766:kraft:4213:22487918,22539960:kraft:4213:22540430,22575196:kraft:4213:22575382'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004268357933411616, 'nb_photo': 5133, 'list_port_cont': '21937823,21939172,21939743,21941800,21942284,21942538,21942715,21943658,21944046,21944467,21944818,21944867,21944903,21948132,21948687,21951656,21954476,21954497,21956207,21956640,21958507,21960308,21962716,21963642,21967989,21969909,21973613,21975490,21975798,21977010,21979020,21979280,21979527,21979658,21983688,21985969,21987565,21987729,21987875,21987941,21988187,21990016,21991766,21992355,21996563,21999334,22010225,22011232,22012682,22014625,22015189,22015556,22017035,22017721,22018816,22019743,22020331,22023198,22023570,22025979,22026107,22026478,22026703,22028387,22028726,22028811,22029243,22029375,22032132,22034308,22037600,22040742,22042536,22045691,22049564,22049905,22050618,22052433,22052789,22053837,22054030,22054384,22056612,22057262,22063996,22065175,22066562,22067777,22068403,22068574,22070702,22072136,22072568,22076253,22076693,22078512,22080964,22081714,22086843,22088446,22091699,22097062,22101174,22101845,22106601,22109803,22111073,22121902,22122019,22122457,22122482,22122511,22122673,2212308', 'assoc_port': '21936862:21944867,21936863:21944903,21936864:21944046,21936865:21942284,21936890:21937823,21936891:21942715,21938118:21939172,21939370:21939743,21941592:21941800,21942442:21942538,21943568:21943658,21944347:21944467,21944620:21944818,21947409:21948132,21947410:21956207,21948383:21948687,21951418:21951656,21954280:21954497,21954281:21954476,21956389:21956640,21958293:21958507,21960222:21960308,21962610:21962716,21963434:21963642,21967261:21979280,21967262:21979527,21967263:21967989,21967264:21979658,21967265:21987565,21967266:21987729,21967267:21987875,21969569:21969909,21972738:21975490,21972739:21973613,21975410:21991766,21975411:21990016,21975412:21977010,21975413:21979020,21975414:21975798,21980179:21987941,21982976:21983688,21985604:21985969,21987906:21988187,21991685:21992355,21996082:21996563,21998719:21999334,22009703:22017035,22009706:22019743,22009708:22015189,22009713:22011232,22009717:22014625,22009719:22010225,22009721:22018816,22012335:22012682,22015078:22015556,22017423:22017721,22019959:2202033', 'assoc_mat': '21936862:metal:4213:21944867,21936863:metal:4213:21944903,21936864:metal:4213:21944046,21936865:metal:4213:21942284,21936890:metal:4213:21937823,21936891:metal:4213:21942715,21938118:metal:4213:21939172,21939370:metal:4213:21939743,21941592:metal:4213:21941800,21942442:metal:4213:21942538,21943568:metal:4213:21943658,21944347:metal:4213:21944467,21944620:metal:4213:21944818,21947409:metal:4213:21948132,21947410:metal:4213:21956207,21948383:metal:4213:21948687,21951418:metal:4213:21951656,21954280:metal:4213:21954497,21954281:metal:4213:21954476,21956389:metal:4213:21956640,21958293:metal:4213:21958507,21960222:metal:4213:21960308,21962610:metal:4213:21962716,21963434:metal:4213:21963642,21967261:metal:4213:21979280,21967262:metal:4213:21979527,21967263:metal:4213:21967989,21967264:metal:4213:21979658,21967265:metal:4213:21987565,21967266:metal:4213:21987729,21967267:metal:4213:21987875,21969569:metal:4213:21969909,21972738:metal:4213:21975490,21972739:metal:4213:21973613,21975410:metal:4213:21991766,21975411:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03328641992937033, 'nb_photo': 13766, 'list_port_cont': '21937822,21939165,21939738,21941792,21942279,21942547,21942706,21943659,21944047,21944457,21944833,21944865,21944896,21948130,21948698,21951653,21954469,21954494,21956211,21956633,21958512,21960309,21962723,21963643,21967986,21969908,21973610,21975502,21975799,21977008,21979021,21979288,21979528,21979659,21983231,21983676,21985982,21987571,21987717,21987870,21987943,21988179,21990024,21991767,21992345,21996566,21999332,22010233,22011235,22012684,22014623,22015185,22015550,22017034,22017729,22018827,22019749,22020333,22023187,22023580,22025978,22026095,22026468,22026710,22028379,22028734,22028798,22029233,22029370,22032125,22034310,22037598,22040743,22042546,22045678,22049566,22049891,22050622,22052436,22052787,22053833,22054027,22054395,22056632,22057260,22064003,22065167,22066567,22067774,22068396,22068560,22070690,22072134,22072555,22076245,22076682,22078516,22080968,22081707,22086847,22088435,22091691,22097063,22101182,22101839,22106607,22109809,22111061,22121903,22122020,22122449,22122492,22122518,2212266', 'assoc_port': '21936862:21944865,21936863:21944896,21936864:21944047,21936865:21942279,21936890:21937822,21936891:21942706,21938118:21939165,21939370:21939738,21941592:21941792,21942442:21942547,21943568:21943659,21944347:21944457,21944620:21944833,21947409:21948130,21947410:21956211,21948383:21948698,21951418:21951653,21954280:21954494,21954281:21954469,21956389:21956633,21958293:21958512,21960222:21960309,21962610:21962723,21963434:21963643,21967261:21979288,21967262:21979528,21967263:21967986,21967264:21979659,21967265:21987571,21967266:21987717,21967267:21987870,21969569:21969908,21972738:21975502,21972739:21973610,21975410:21991767,21975411:21990024,21975412:21977008,21975413:21979021,21975414:21975799,21980179:21987943,21982976:21983676,21982980:21983231,21985604:21985982,21987906:21988179,21991685:21992345,21996082:21996566,21998719:21999332,22009703:22017034,22009706:22019749,22009708:22015185,22009713:22011235,22009717:22014623,22009719:22010233,22009721:22018827,22012335:22012684,22015078:22015550,22017423:2201772', 'assoc_mat': '21936862:papier:4213:21944865,21936863:papier:4213:21944896,21936864:papier:4213:21944047,21936865:papier:4213:21942279,21936890:papier:4213:21937822,21936891:papier:4213:21942706,21938118:papier:4213:21939165,21939370:papier:4213:21939738,21941592:papier:4213:21941792,21942442:papier:4213:21942547,21943568:papier:4213:21943659,21944347:papier:4213:21944457,21944620:papier:4213:21944833,21947409:papier:4213:21948130,21947410:papier:4213:21956211,21948383:papier:4213:21948698,21951418:papier:4213:21951653,21954280:papier:4213:21954494,21954281:papier:4213:21954469,21956389:papier:4213:21956633,21958293:papier:4213:21958512,21960222:papier:4213:21960309,21962610:papier:4213:21962723,21963434:papier:4213:21963643,21967261:papier:4213:21979288,21967262:papier:4213:21979528,21967263:papier:4213:21967986,21967264:papier:4213:21979659,21967265:papier:4213:21987571,21967266:papier:4213:21987717,21967267:papier:4213:21987870,21969569:papier:4213:21969908,21972738:papier:4213:21975502,21972739:papier:4213:21973610,2197'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004110088233363629, 'nb_photo': 280, 'list_port_cont': '21937819,21939177,21942285,21942708,21944042,21944460,21944824,21948683,21951658,21956637,21962714,21963648,21975495,21975795,21979028,21979276,21979520,21985980,21987569,21987860,21987938,21990020,21996571,21999343,22015179,22015558,22017040,22018824,22023197,22028392,22028736,22029366,22032121,22034312,22037602,22040737,22042535,22045684,22049558,22050611,22053824,22054020,22054393,22056615,22066558,22067782,22068407,22070696,22076690,22078518,22080958,22081712,22101183,22111066,22122021,22122450,22125259,22127466,22131746,22132010,22133386,22135586,22139184,22150438,22158512,22163223,22176192,22176314,22176645,22176759,22180508,22197099,22219841,22221673,22227476,22230562,22243183,22243841,22244633,22245827,22249989,22250980,22251215,22251270,22252880,22255227,22258161,22258205,22269101,22269152,22269169,22269246,22269343,22269560,22270813,22270874,22270916,22270985,22271054,22271251,22273180,22281578,22287545,22289043,22289363,22292915,22297156,22303279,22305430,22308918,22311681,22313794,22316065,2232450', 'assoc_port': '21936864:21944042,21936865:21942285,21936890:21937819,21936891:21942708,21938118:21939177,21944347:21944460,21944620:21944824,21948383:21948683,21951418:21951658,21956389:21956637,21962610:21962714,21963434:21963648,21967261:21979276,21967262:21979520,21967265:21987569,21967267:21987860,21972738:21975495,21975411:21990020,21975413:21979028,21975414:21975795,21980179:21987938,21985604:21985980,21996082:21996571,21998719:21999343,22009703:22017040,22009708:22015179,22009721:22018824,22015078:22015558,22023102:22023197,22027663:22054393,22028201:22028392,22028579:22028736,22029158:22029366,22031255:22032121,22033902:22054020,22033904:22034312,22037011:22053824,22037027:22037602,22040165:22040737,22042111:22042535,22045129:22050611,22045137:22045684,22048331:22049558,22054309:22056615,22062302:22080958,22062304:22070696,22062332:22066558,22067331:22067782,22068081:22068407,22076628:22076690,22078115:22078518,22081249:22081712,22099990:22101183,22109361:22111066,22121606:22122450,22121613:22122021,22125164:2212525', 'assoc_mat': '21936864:pehd:4213:21944042,21936865:pehd:4213:21942285,21936890:pehd:4213:21937819,21936891:pehd:4213:21942708,21938118:pehd:4213:21939177,21944347:pehd:4213:21944460,21944620:pehd:4213:21944824,21948383:pehd:4213:21948683,21951418:pehd:4213:21951658,21956389:pehd:4213:21956637,21962610:pehd:4213:21962714,21963434:pehd:4213:21963648,21967261:pehd:4213:21979276,21967262:pehd:4213:21979520,21967265:pehd:4213:21987569,21967267:pehd:4213:21987860,21972738:pehd:4213:21975495,21975411:pehd:4213:21990020,21975413:pehd:4213:21979028,21975414:pehd:4213:21975795,21980179:pehd:4213:21987938,21985604:pehd:4213:21985980,21996082:pehd:4213:21996571,21998719:pehd:4213:21999343,22009703:pehd:4213:22017040,22009708:pehd:4213:22015179,22009721:pehd:4213:22018824,22015078:pehd:4213:22015558,22023102:pehd:4213:22023197,22027663:pehd:4213:22054393,22028201:pehd:4213:22028392,22028579:pehd:4213:22028736,22029158:pehd:4213:22029366,22031255:pehd:4213:22032121,22033902:pehd:4213:22054020,22033904:pehd:4213:22034312,22037011:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.019543802319342298, 'nb_photo': 10053, 'list_port_cont': '21937820,21939161,21939748,21941791,21942280,21942542,21942704,21943650,21944048,21944455,21944821,21944862,21944900,21948131,21948688,21951650,21954464,21954501,21956216,21956632,21958499,21960320,21962725,21963649,21967987,21969911,21973612,21975491,21975786,21977001,21979025,21979278,21979529,21979652,21983675,21985970,21987575,21987719,21987868,21987934,21988188,21990021,21991771,21992352,21996576,21999335,22010222,22011233,22012685,22014633,22015192,22015564,22017044,22017720,22018829,22019751,22020327,22023193,22023577,22025977,22026098,22026467,22026706,22028389,22028728,22028809,22029231,22029373,22032122,22034306,22037593,22040751,22042532,22045688,22049562,22049897,22050615,22052429,22052790,22053828,22054023,22054388,22056626,22057273,22063993,22065174,22066556,22067785,22068409,22068570,22070692,22072123,22072553,22076249,22076687,22078514,22080969,22081703,22086855,22088441,22091684,22097064,22101170,22101846,22106605,22109807,22111063,22121891,22122022,22122456,22122487,22122516,22122678,2212308', 'assoc_port': '21936862:21944862,21936863:21944900,21936864:21944048,21936865:21942280,21936890:21937820,21936891:21942704,21938118:21939161,21939370:21939748,21941592:21941791,21942442:21942542,21943568:21943650,21944347:21944455,21944620:21944821,21947409:21948131,21947410:21956216,21948383:21948688,21951418:21951650,21954280:21954501,21954281:21954464,21956389:21956632,21958293:21958499,21960222:21960320,21962610:21962725,21963434:21963649,21967261:21979278,21967262:21979529,21967263:21967987,21967264:21979652,21967265:21987575,21967266:21987719,21967267:21987868,21969569:21969911,21972738:21975491,21972739:21973612,21975410:21991771,21975411:21990021,21975412:21977001,21975413:21979025,21975414:21975786,21980179:21987934,21982976:21983675,21985604:21985970,21987906:21988188,21991685:21992352,21996082:21996576,21998719:21999335,22009703:22017044,22009706:22019751,22009708:22015192,22009713:22011233,22009717:22014633,22009719:22010222,22009721:22018829,22012335:22012685,22015078:22015564,22017423:22017720,22019959:2202032', 'assoc_mat': '21936862:pet_clair:4213:21944862,21936863:pet_clair:4213:21944900,21936864:pet_clair:4213:21944048,21936865:pet_clair:4213:21942280,21936890:pet_clair:4213:21937820,21936891:pet_clair:4213:21942704,21938118:pet_clair:4213:21939161,21939370:pet_clair:4213:21939748,21941592:pet_clair:4213:21941791,21942442:pet_clair:4213:21942542,21943568:pet_clair:4213:21943650,21944347:pet_clair:4213:21944455,21944620:pet_clair:4213:21944821,21947409:pet_clair:4213:21948131,21947410:pet_clair:4213:21956216,21948383:pet_clair:4213:21948688,21951418:pet_clair:4213:21951650,21954280:pet_clair:4213:21954501,21954281:pet_clair:4213:21954464,21956389:pet_clair:4213:21956632,21958293:pet_clair:4213:21958499,21960222:pet_clair:4213:21960320,21962610:pet_clair:4213:21962725,21963434:pet_clair:4213:21963649,21967261:pet_clair:4213:21979278,21967262:pet_clair:4213:21979529,21967263:pet_clair:4213:21967987,21967264:pet_clair:4213:21979652,21967265:pet_clair:4213:21987575,21967266:pet_clair:4213:21987719,21967267:pet_clair:4213:21987868,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00037107035335104985, 'nb_photo': 128, 'list_port_cont': '21941793,21942281,21942540,21954471,21954510,21956214,21962722,21963636,21967998,21973602,21975493,21975791,21979277,21979531,21987874,21996562,22020330,22026469,22028388,22028807,22029367,22034318,22037601,22067784,22068405,22080962,22081715,22086852,22101179,22132023,22147355,22150432,22163127,22163225,22176312,22176650,22181021,22189818,22210779,22244258,22245422,22245833,22249994,22250620,22250988,22251217,22251276,22252874,22255705,22258201,22269147,22269658,22269694,22269840,22269911,22271261,22288754,22289045,22289356,22297161,22312507,22324492,22330482,22331005,22343320,22372681,22379142,22393337,22422154,22425191,22428641,22430914,22454441,22455734,22462543,22463136,22477741,22487883,22492876,22496093,22513527,22525115,22532602,22536425,22537955,22543198,22549619,22552299,22561904,22563289,22568929,22575376', 'assoc_port': '21936865:21942281,21941592:21941793,21942442:21942540,21947410:21956214,21954280:21954510,21954281:21954471,21962610:21962722,21963434:21963636,21967261:21979277,21967262:21979531,21967263:21967998,21967267:21987874,21972738:21975493,21972739:21973602,21975414:21975791,21996082:21996562,22019959:22020330,22026343:22026469,22028201:22028388,22028577:22028807,22029158:22029367,22033904:22034318,22037027:22037601,22062302:22080962,22067331:22067784,22068081:22068405,22081249:22081715,22086128:22086852,22099990:22101179,22131689:22132023,22146589:22147355,22148725:22150432,22162864:22163127,22162865:22163225,22174349:22176650,22175881:22176312,22180112:22181021,22189332:22189818,22210237:22210779,22242953:22245833,22242954:22250988,22244167:22244258,22245281:22245422,22249280:22249994,22250548:22250620,22251175:22251217,22251176:22251276,22252720:22252874,22255555:22255705,22258026:22258201,22269045:22269840,22269050:22269911,22269051:22269658,22269052:22269694,22269065:22269147,22271182:22271261,22286576:2228875', 'assoc_mat': '21936865:pet_fonce:4213:21942281,21941592:pet_fonce:4213:21941793,21942442:pet_fonce:4213:21942540,21947410:pet_fonce:4213:21956214,21954280:pet_fonce:4213:21954510,21954281:pet_fonce:4213:21954471,21962610:pet_fonce:4213:21962722,21963434:pet_fonce:4213:21963636,21967261:pet_fonce:4213:21979277,21967262:pet_fonce:4213:21979531,21967263:pet_fonce:4213:21967998,21967267:pet_fonce:4213:21987874,21972738:pet_fonce:4213:21975493,21972739:pet_fonce:4213:21973602,21975414:pet_fonce:4213:21975791,21996082:pet_fonce:4213:21996562,22019959:pet_fonce:4213:22020330,22026343:pet_fonce:4213:22026469,22028201:pet_fonce:4213:22028388,22028577:pet_fonce:4213:22028807,22029158:pet_fonce:4213:22029367,22033904:pet_fonce:4213:22034318,22037027:pet_fonce:4213:22037601,22062302:pet_fonce:4213:22080962,22067331:pet_fonce:4213:22067784,22068081:pet_fonce:4213:22068405,22081249:pet_fonce:4213:22081715,22086128:pet_fonce:4213:22086852,22099990:pet_fonce:4213:22101179,22131689:pet_fonce:4213:22132023,22146589:pet_fonce:4213:22147355,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.010509359292383195, 'nb_photo': 4176, 'list_port_cont': '21937824,21939173,21939741,21941801,21942287,21942536,21942709,21943654,21944054,21944465,21944826,21944860,21944902,21948127,21948692,21951659,21954465,21954504,21956206,21956630,21958508,21960315,21962721,21963638,21967991,21969907,21973611,21975503,21975797,21977002,21979015,21979283,21979530,21979656,21983689,21985971,21987564,21987728,21987863,21987937,21988181,21990015,21991761,21992343,21996578,21999345,22010234,22011236,22012688,22014635,22015187,22015548,22017031,22017728,22018820,22019741,22020323,22023190,22023568,22025982,22026097,22026475,22026714,22028383,22028735,22028806,22029235,22029380,22032120,22034305,22037596,22040741,22042544,22045683,22049559,22049894,22050619,22052438,22052791,22053823,22054031,22054392,22056614,22057274,22064002,22065168,22066564,22067779,22068398,22068571,22070700,22072124,22072554,22076259,22076691,22078519,22080956,22081711,22086851,22088450,22091696,22097068,22101181,22101842,22106595,22109810,22111060,22121898,22122032,22122451,22122484,22122519,22122670,2212308', 'assoc_port': '21936862:21944860,21936863:21944902,21936864:21944054,21936865:21942287,21936890:21937824,21936891:21942709,21938118:21939173,21939370:21939741,21941592:21941801,21942442:21942536,21943568:21943654,21944347:21944465,21944620:21944826,21947409:21948127,21947410:21956206,21948383:21948692,21951418:21951659,21954280:21954504,21954281:21954465,21956389:21956630,21958293:21958508,21960222:21960315,21962610:21962721,21963434:21963638,21967261:21979283,21967262:21979530,21967263:21967991,21967264:21979656,21967265:21987564,21967266:21987728,21967267:21987863,21969569:21969907,21972738:21975503,21972739:21973611,21975410:21991761,21975411:21990015,21975412:21977002,21975413:21979015,21975414:21975797,21980179:21987937,21982976:21983689,21985604:21985971,21987906:21988181,21991685:21992343,21996082:21996578,21998719:21999345,22009703:22017031,22009706:22019741,22009708:22015187,22009713:22011236,22009717:22014635,22009719:22010234,22009721:22018820,22012335:22012688,22015078:22015548,22017423:22017728,22019959:2202032', 'assoc_mat': '21936862:pet_opaque:4213:21944860,21936863:pet_opaque:4213:21944902,21936864:pet_opaque:4213:21944054,21936865:pet_opaque:4213:21942287,21936890:pet_opaque:4213:21937824,21936891:pet_opaque:4213:21942709,21938118:pet_opaque:4213:21939173,21939370:pet_opaque:4213:21939741,21941592:pet_opaque:4213:21941801,21942442:pet_opaque:4213:21942536,21943568:pet_opaque:4213:21943654,21944347:pet_opaque:4213:21944465,21944620:pet_opaque:4213:21944826,21947409:pet_opaque:4213:21948127,21947410:pet_opaque:4213:21956206,21948383:pet_opaque:4213:21948692,21951418:pet_opaque:4213:21951659,21954280:pet_opaque:4213:21954504,21954281:pet_opaque:4213:21954465,21956389:pet_opaque:4213:21956630,21958293:pet_opaque:4213:21958508,21960222:pet_opaque:4213:21960315,21962610:pet_opaque:4213:21962721,21963434:pet_opaque:4213:21963638,21967261:pet_opaque:4213:21979283,21967262:pet_opaque:4213:21979530,21967263:pet_opaque:4213:21967991,21967264:pet_opaque:4213:21979656,21967265:pet_opaque:4213:21987564,21967266:pet_opaque:4213:21987728,2196'}) 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(1717453,1720479,1722022,1729930,1729452,1733361,1737890,1740075,1740577,1743830,1747622,1751855,1755838,1761432,1765842,1765821,1769843)); after get_hostname_from_raspi hasthag : refus hasthag that could be used but not yet : _______refus,textiles_sanitaires SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______refus' and mtr_portfolio_id in (select id FROM MTRUser.mtr_portfolios where mtr_user_id=983) and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=15 and date >='2025-04-01' and date <= '2025-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((10289,),), 'unwanted_material_monthly_percentage': ((0.10545454222745454,),), 'material_repartition': (('refus', 9505),), 'material_dict': {'refus': 9505}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.13512648719161072, 327), (datetime.date(2025, 4, 15), 0.09941740959530766, 783), (datetime.date(2025, 4, 16), 0.1043744342484117, 632), (datetime.date(2025, 4, 17), 0.10502896153045592, 737), (datetime.date(2025, 4, 18), 0.11130520673262517, 702), (datetime.date(2025, 4, 19), 0.08678541779840526, 898), (datetime.date(2025, 4, 20), 0.10204182124944955, 466), (datetime.date(2025, 4, 21), 0.09702486023602183, 376), (datetime.date(2025, 4, 22), 0.09974312522637868, 579), (datetime.date(2025, 4, 23), 0.13019140744565738, 346), (datetime.date(2025, 4, 24), 0.10880003812221362, 146), (datetime.date(2025, 4, 25), 0.08655851041734378, 315), (datetime.date(2025, 4, 28), 0.10023063708027577, 568), (datetime.date(2025, 4, 29), 0.0939075863041547, 717), (datetime.date(2025, 4, 30), 0.10718695142538777, 784)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.13512648719161072, 327), (datetime.date(2025, 4, 15), 0.09941740959530766, 783), (datetime.date(2025, 4, 16), 0.1043744342484117, 632), (datetime.date(2025, 4, 17), 0.10502896153045592, 737), (datetime.date(2025, 4, 18), 0.11130520673262517, 702), (datetime.date(2025, 4, 19), 0.08678541779840526, 898), (datetime.date(2025, 4, 20), 0.10204182124944955, 466), (datetime.date(2025, 4, 21), 0.09702486023602183, 376), (datetime.date(2025, 4, 22), 0.09974312522637868, 579), (datetime.date(2025, 4, 23), 0.13019140744565738, 346), (datetime.date(2025, 4, 24), 0.10880003812221362, 146), (datetime.date(2025, 4, 25), 0.08655851041734378, 315), (datetime.date(2025, 4, 28), 0.10023063708027577, 568), (datetime.date(2025, 4, 29), 0.0939075863041547, 717), (datetime.date(2025, 4, 30), 0.10718695142538777, 784))}, 'quality_array': [['-2.4864147866338886', '01042025'], ['-2.472981252729084', '02042025'], ['-2.788215443157055', '03042025'], ['-2.400774424658296', '15042025'], ['-2.3311456371666472', '16042025'], ['-2.267627155642355', '17042025'], ['-2.3696749135764827', '18042025'], ['-2.559122253884004', '19042025'], ['-2.2164436271647525', '20042025'], ['-2.1695806833211666', '21042025'], ['-2.150534756301885', '22042025'], ['-2.3484549247166484', '23042025'], ['-1.7013619224805132', '24042025'], ['-1.7702668351956723', '25042025'], ['-2.1031149012610193', '28042025'], ['-2.0341007975686067', '29042025'], ['-1.940333398946985', '30042025']], 'number_of_batch': ((389,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004108143242236501, 'nb_photo': 2246, 'list_port_cont': '21937821,21939162,21939746,21941786,21942286,21942545,21942710,21943656,21944041,21944452,21944820,21944855,21944892,21948133,21948695,21951644,21954467,21954496,21956205,21956628,21958502,21960306,21962713,21963637,21967999,21969915,21973608,21975500,21975800,21977007,21979024,21979274,21979535,21979655,21983684,21985983,21987573,21987720,21987872,21987946,21990023,21991769,21992349,21996567,21999338,22010235,22011237,22012691,22014637,22015182,22015551,22017043,22017719,22018831,22019753,22020338,22023199,22023576,22026100,22026474,22026711,22028391,22028723,22028802,22029232,22029374,22032118,22034309,22037607,22040747,22042545,22045690,22049555,22049900,22050612,22052435,22052797,22053826,22054025,22054398,22056638,22057265,22064001,22065163,22066559,22067770,22068399,22068561,22070705,22072133,22072562,22076257,22076688,22078508,22080961,22081709,22086857,22097057,22101172,22101851,22106600,22109817,22111064,22122018,22122445,22122480,22122525,22122682,22123080,22124555,22125261,22125331,22127464,2213174', 'assoc_port': '21936862:21944855,21936863:21944892,21936864:21944041,21936865:21942286,21936890:21937821,21936891:21942710,21938118:21939162,21939370:21939746,21941592:21941786,21942442:21942545,21943568:21943656,21944347:21944452,21944620:21944820,21947409:21948133,21947410:21956205,21948383:21948695,21951418:21951644,21954280:21954496,21954281:21954467,21956389:21956628,21958293:21958502,21960222:21960306,21962610:21962713,21963434:21963637,21967261:21979274,21967262:21979535,21967263:21967999,21967264:21979655,21967265:21987573,21967266:21987720,21967267:21987872,21969569:21969915,21972738:21975500,21972739:21973608,21975410:21991769,21975411:21990023,21975412:21977007,21975413:21979024,21975414:21975800,21980179:21987946,21982976:21983684,21985604:21985983,21991685:21992349,21996082:21996567,21998719:21999338,22009703:22017043,22009706:22019753,22009708:22015182,22009713:22011237,22009717:22014637,22009719:22010235,22009721:22018831,22012335:22012691,22015078:22015551,22017423:22017719,22019959:22020338,22023102:2202319', 'assoc_mat': '21936862:barquette_opaque:4213:21944855,21936863:barquette_opaque:4213:21944892,21936864:barquette_opaque:4213:21944041,21936865:barquette_opaque:4213:21942286,21936890:barquette_opaque:4213:21937821,21936891:barquette_opaque:4213:21942710,21938118:barquette_opaque:4213:21939162,21939370:barquette_opaque:4213:21939746,21941592:barquette_opaque:4213:21941786,21942442:barquette_opaque:4213:21942545,21943568:barquette_opaque:4213:21943656,21944347:barquette_opaque:4213:21944452,21944620:barquette_opaque:4213:21944820,21947409:barquette_opaque:4213:21948133,21947410:barquette_opaque:4213:21956205,21948383:barquette_opaque:4213:21948695,21951418:barquette_opaque:4213:21951644,21954280:barquette_opaque:4213:21954496,21954281:barquette_opaque:4213:21954467,21956389:barquette_opaque:4213:21956628,21958293:barquette_opaque:4213:21958502,21960222:barquette_opaque:4213:21960306,21962610:barquette_opaque:4213:21962713,21963434:barquette_opaque:4213:21963637,21967261:barquette_opaque:4213:21979274,21967262:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.002458002690027309, 'nb_photo': 2501, 'list_port_cont': '21937830,21939168,21939750,21941788,21942278,21942544,21942711,21943655,21944049,21944463,21944830,21944861,21944898,21948138,21948691,21951655,21954462,21954502,21956215,21956639,21958505,21960307,21962715,21963635,21967984,21969920,21973605,21975504,21975796,21977012,21979016,21979286,21979525,21979650,21983680,21985984,21987572,21987721,21987808,21987865,21987945,21990018,21991772,21992341,21996561,21999339,22010228,22011231,22012680,22014638,22015191,22017045,22017718,22018818,22019740,22020336,22023201,22023573,22025976,22026108,22026479,22026705,22028394,22028724,22028813,22029242,22029371,22032116,22034320,22037604,22040749,22042538,22045677,22049561,22049896,22050613,22052439,22052783,22053835,22054028,22054396,22056618,22057266,22064000,22065171,22066566,22067778,22068410,22068566,22070689,22072127,22072566,22076250,22078511,22080971,22081713,22086854,22091685,22101177,22101850,22106592,22109806,22111065,22121894,22122028,22122452,22122478,22122526,22122667,22123090,22124550,22125265,22125338,2212745', 'assoc_port': '21936862:21944861,21936863:21944898,21936864:21944049,21936865:21942278,21936890:21937830,21936891:21942711,21938118:21939168,21939370:21939750,21941592:21941788,21942442:21942544,21943568:21943655,21944347:21944463,21944620:21944830,21947409:21948138,21947410:21956215,21948383:21948691,21951418:21951655,21954280:21954502,21954281:21954462,21956389:21956639,21958293:21958505,21960222:21960307,21962610:21962715,21963434:21963635,21967261:21979286,21967262:21979525,21967263:21967984,21967264:21979650,21967265:21987572,21967266:21987721,21967267:21987865,21969569:21969920,21972738:21975504,21972739:21973605,21975410:21991772,21975411:21990018,21975412:21977012,21975413:21979016,21975414:21975796,21980179:21987945,21982976:21983680,21982979:21987808,21985604:21985984,21991685:21992341,21996082:21996561,21998719:21999339,22009703:22017045,22009706:22019740,22009708:22015191,22009713:22011231,22009717:22014638,22009719:22010228,22009721:22018818,22012335:22012680,22017423:22017718,22019959:22020336,22023102:2202320', 'assoc_mat': '21936862:carton:4213:21944861,21936863:carton:4213:21944898,21936864:carton:4213:21944049,21936865:carton:4213:21942278,21936890:carton:4213:21937830,21936891:carton:4213:21942711,21938118:carton:4213:21939168,21939370:carton:4213:21939750,21941592:carton:4213:21941788,21942442:carton:4213:21942544,21943568:carton:4213:21943655,21944347:carton:4213:21944463,21944620:carton:4213:21944830,21947409:carton:4213:21948138,21947410:carton:4213:21956215,21948383:carton:4213:21948691,21951418:carton:4213:21951655,21954280:carton:4213:21954502,21954281:carton:4213:21954462,21956389:carton:4213:21956639,21958293:carton:4213:21958505,21960222:carton:4213:21960307,21962610:carton:4213:21962715,21963434:carton:4213:21963635,21967261:carton:4213:21979286,21967262:carton:4213:21979525,21967263:carton:4213:21967984,21967264:carton:4213:21979650,21967265:carton:4213:21987572,21967266:carton:4213:21987721,21967267:carton:4213:21987865,21969569:carton:4213:21969920,21972738:carton:4213:21975504,21972739:carton:4213:21973605,2197'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004443851377616915, 'nb_photo': 813, 'list_port_cont': '21937831,21941796,21942272,21942537,21942703,21943662,21944052,21944458,21944822,21944854,21948129,21948689,21951651,21954503,21956208,21956635,21960314,21963647,21967988,21969913,21973614,21975505,21976999,21979279,21979536,21979646,21983690,21985981,21987578,21987867,21987935,21990017,21991770,21996565,21999346,22011243,22012678,22014630,22015180,22015560,22017033,22018822,22020328,22023196,22023575,22026094,22026470,22026718,22028395,22028733,22028804,22029245,22029378,22034307,22040750,22042534,22045685,22049567,22052443,22052795,22053839,22054022,22056624,22057268,22064006,22065165,22066571,22068564,22070704,22072122,22076248,22080967,22081718,22086856,22097069,22101176,22101843,22106602,22109811,22111075,22122030,22122446,22122522,22122677,22123092,22124556,22125264,22125340,22131748,22132016,22135579,22139185,22142832,22150440,22151050,22153499,22158515,22163121,22163214,22176190,22176308,22176355,22176655,22176745,22181024,22182630,22189816,22191924,22197112,22201221,22205037,22210788,22215933,2222747', 'assoc_port': '21936862:21944854,21936864:21944052,21936865:21942272,21936890:21937831,21936891:21942703,21941592:21941796,21942442:21942537,21943568:21943662,21944347:21944458,21944620:21944822,21947409:21948129,21947410:21956208,21948383:21948689,21951418:21951651,21954280:21954503,21956389:21956635,21960222:21960314,21963434:21963647,21967261:21979279,21967262:21979536,21967263:21967988,21967264:21979646,21967265:21987578,21967267:21987867,21969569:21969913,21972738:21975505,21972739:21973614,21975410:21991770,21975411:21990017,21975412:21976999,21980179:21987935,21982976:21983690,21985604:21985981,21996082:21996565,21998719:21999346,22009703:22017033,22009708:22015180,22009713:22011243,22009717:22014630,22009721:22018822,22012335:22012678,22015078:22015560,22019959:22020328,22023102:22023196,22023491:22023575,22025770:22026094,22026342:22026718,22026343:22026470,22027664:22057268,22028201:22028395,22028577:22028804,22028579:22028733,22029158:22029378,22029159:22029245,22033902:22054022,22033904:22034307,22037011:2205383', 'assoc_mat': '21936862:ela:4213:21944854,21936864:ela:4213:21944052,21936865:ela:4213:21942272,21936890:ela:4213:21937831,21936891:ela:4213:21942703,21941592:ela:4213:21941796,21942442:ela:4213:21942537,21943568:ela:4213:21943662,21944347:ela:4213:21944458,21944620:ela:4213:21944822,21947409:ela:4213:21948129,21947410:ela:4213:21956208,21948383:ela:4213:21948689,21951418:ela:4213:21951651,21954280:ela:4213:21954503,21956389:ela:4213:21956635,21960222:ela:4213:21960314,21963434:ela:4213:21963647,21967261:ela:4213:21979279,21967262:ela:4213:21979536,21967263:ela:4213:21967988,21967264:ela:4213:21979646,21967265:ela:4213:21987578,21967267:ela:4213:21987867,21969569:ela:4213:21969913,21972738:ela:4213:21975505,21972739:ela:4213:21973614,21975410:ela:4213:21991770,21975411:ela:4213:21990017,21975412:ela:4213:21976999,21980179:ela:4213:21987935,21982976:ela:4213:21983690,21985604:ela:4213:21985981,21996082:ela:4213:21996565,21998719:ela:4213:21999346,22009703:ela:4213:22017033,22009708:ela:4213:22015180,22009713:ela:4213:2201124'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003038590602422445, 'nb_photo': 3002, 'list_port_cont': '21937832,21939163,21939737,21941797,21942271,21942543,21942714,21943657,21944045,21944459,21944829,21944866,21944889,21948137,21948682,21951643,21954468,21954505,21956210,21956629,21958503,21960317,21962726,21963646,21967993,21969912,21973603,21975499,21975794,21977009,21979027,21979287,21979521,21979647,21983235,21983683,21985972,21987576,21987718,21987859,21987931,21988184,21990028,21991774,21992347,21996570,21999347,22010232,22011229,22012692,22014636,22015186,22015549,22017041,22017725,22018819,22019747,22020332,22023191,22023569,22025985,22026106,22026477,22026719,22028381,22028721,22028803,22029240,22029382,22032130,22034319,22037606,22040746,22042541,22045692,22049563,22049903,22050621,22052444,22052792,22053838,22054034,22054399,22056636,22057261,22064004,22065170,22066561,22067781,22068406,22068569,22070695,22072126,22072552,22076246,22076689,22078509,22080959,22081706,22086858,22088449,22091694,22097058,22101169,22101848,22106604,22109816,22111074,22121899,22122034,22122444,22122481,22122517,2212267', 'assoc_port': '21936862:21944866,21936863:21944889,21936864:21944045,21936865:21942271,21936890:21937832,21936891:21942714,21938118:21939163,21939370:21939737,21941592:21941797,21942442:21942543,21943568:21943657,21944347:21944459,21944620:21944829,21947409:21948137,21947410:21956210,21948383:21948682,21951418:21951643,21954280:21954505,21954281:21954468,21956389:21956629,21958293:21958503,21960222:21960317,21962610:21962726,21963434:21963646,21967261:21979287,21967262:21979521,21967263:21967993,21967264:21979647,21967265:21987576,21967266:21987718,21967267:21987859,21969569:21969912,21972738:21975499,21972739:21973603,21975410:21991774,21975411:21990028,21975412:21977009,21975413:21979027,21975414:21975794,21980179:21987931,21982976:21983683,21982980:21983235,21985604:21985972,21987906:21988184,21991685:21992347,21996082:21996570,21998719:21999347,22009703:22017041,22009706:22019747,22009708:22015186,22009713:22011229,22009717:22014636,22009719:22010232,22009721:22018819,22012335:22012692,22015078:22015549,22017423:2201772', 'assoc_mat': '21936862:etiquette:4213:21944866,21936863:etiquette:4213:21944889,21936864:etiquette:4213:21944045,21936865:etiquette:4213:21942271,21936890:etiquette:4213:21937832,21936891:etiquette:4213:21942714,21938118:etiquette:4213:21939163,21939370:etiquette:4213:21939737,21941592:etiquette:4213:21941797,21942442:etiquette:4213:21942543,21943568:etiquette:4213:21943657,21944347:etiquette:4213:21944459,21944620:etiquette:4213:21944829,21947409:etiquette:4213:21948137,21947410:etiquette:4213:21956210,21948383:etiquette:4213:21948682,21951418:etiquette:4213:21951643,21954280:etiquette:4213:21954505,21954281:etiquette:4213:21954468,21956389:etiquette:4213:21956629,21958293:etiquette:4213:21958503,21960222:etiquette:4213:21960317,21962610:etiquette:4213:21962726,21963434:etiquette:4213:21963646,21967261:etiquette:4213:21979287,21967262:etiquette:4213:21979521,21967263:etiquette:4213:21967993,21967264:etiquette:4213:21979647,21967265:etiquette:4213:21987576,21967266:etiquette:4213:21987718,21967267:etiquette:4213:21987859,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03274580738220678, 'nb_photo': 7891, 'list_port_cont': '21937818,21939175,21939740,21941790,21942276,21942534,21942712,21943653,21944044,21944468,21944823,21944853,21944888,21948124,21948693,21951647,21954463,21954509,21956213,21956627,21958510,21960322,21962720,21963644,21967985,21969910,21973618,21975498,21975790,21977000,21979018,21979275,21979534,21979651,21983681,21985975,21987570,21987715,21987869,21987944,21988183,21990029,21991760,21992348,21996564,21999336,22010236,22011230,22012677,22014626,22015181,22015557,22017038,22017717,22018823,22019748,22020339,22023185,22023578,22025980,22026096,22026482,22026709,22028390,22028729,22028801,22029237,22029381,22032129,22034317,22037595,22040744,22042547,22045687,22049552,22049895,22050614,22052437,22052798,22053830,22054024,22054391,22056616,22057270,22064005,22065166,22066557,22067780,22068411,22068576,22068705,22070693,22072129,22072563,22076244,22076686,22078507,22080960,22081702,22086846,22088448,22091682,22097060,22101173,22101844,22106597,22109813,22111068,22121887,22122026,22122447,22122483,22122520,2212268', 'assoc_port': '21936862:21944853,21936863:21944888,21936864:21944044,21936865:21942276,21936890:21937818,21936891:21942712,21938118:21939175,21939370:21939740,21941592:21941790,21942442:21942534,21943568:21943653,21944347:21944468,21944620:21944823,21947409:21948124,21947410:21956213,21948383:21948693,21951418:21951647,21954280:21954509,21954281:21954463,21956389:21956627,21958293:21958510,21960222:21960322,21962610:21962720,21963434:21963644,21967261:21979275,21967262:21979534,21967263:21967985,21967264:21979651,21967265:21987570,21967266:21987715,21967267:21987869,21969569:21969910,21972738:21975498,21972739:21973618,21975410:21991760,21975411:21990029,21975412:21977000,21975413:21979018,21975414:21975790,21980179:21987944,21982976:21983681,21985604:21985975,21987906:21988183,21991685:21992348,21996082:21996564,21998719:21999336,22009703:22017038,22009706:22019748,22009708:22015181,22009713:22011230,22009717:22014626,22009719:22010236,22009721:22018823,22012335:22012677,22015078:22015557,22017423:22017717,22019959:2202033', 'assoc_mat': '21936862:film_plastique:4213:21944853,21936863:film_plastique:4213:21944888,21936864:film_plastique:4213:21944044,21936865:film_plastique:4213:21942276,21936890:film_plastique:4213:21937818,21936891:film_plastique:4213:21942712,21938118:film_plastique:4213:21939175,21939370:film_plastique:4213:21939740,21941592:film_plastique:4213:21941790,21942442:film_plastique:4213:21942534,21943568:film_plastique:4213:21943653,21944347:film_plastique:4213:21944468,21944620:film_plastique:4213:21944823,21947409:film_plastique:4213:21948124,21947410:film_plastique:4213:21956213,21948383:film_plastique:4213:21948693,21951418:film_plastique:4213:21951647,21954280:film_plastique:4213:21954509,21954281:film_plastique:4213:21954463,21956389:film_plastique:4213:21956627,21958293:film_plastique:4213:21958510,21960222:film_plastique:4213:21960322,21962610:film_plastique:4213:21962720,21963434:film_plastique:4213:21963644,21967261:film_plastique:4213:21979275,21967262:film_plastique:4213:21979534,21967263:film_plastique:4213:2196798'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0007051638095873881, 'nb_photo': 23, 'list_port_cont': '21942277,21944864,21969916,21977011,22057267,22072137,22101180,22125330,22163117,22244944,22248072,22270905,22272865,22331009,22355412,22372238,22448590,22477742,22487918,22540430,22575382', 'assoc_port': '21936862:21944864,21936865:21942277,21969569:21969916,21975412:21977011,22027664:22057267,22062303:22072137,22099990:22101180,22125241:22125330,22162864:22163117,22244778:22244944,22247768:22248072,22270725:22270905,22272668:22272865,22328684:22331009,22355014:22355412,22370563:22372238,22448178:22448590,22477089:22477742,22487766:22487918,22539960:22540430,22575196:22575382', 'assoc_mat': '21936862:kraft:4213:21944864,21936865:kraft:4213:21942277,21969569:kraft:4213:21969916,21975412:kraft:4213:21977011,22027664:kraft:4213:22057267,22062303:kraft:4213:22072137,22099990:kraft:4213:22101180,22125241:kraft:4213:22125330,22162864:kraft:4213:22163117,22244778:kraft:4213:22244944,22247768:kraft:4213:22248072,22270725:kraft:4213:22270905,22272668:kraft:4213:22272865,22328684:kraft:4213:22331009,22355014:kraft:4213:22355412,22370563:kraft:4213:22372238,22448178:kraft:4213:22448590,22477089:kraft:4213:22477742,22487766:kraft:4213:22487918,22539960:kraft:4213:22540430,22575196:kraft:4213:22575382'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004268357933411616, 'nb_photo': 5133, 'list_port_cont': '21937823,21939172,21939743,21941800,21942284,21942538,21942715,21943658,21944046,21944467,21944818,21944867,21944903,21948132,21948687,21951656,21954476,21954497,21956207,21956640,21958507,21960308,21962716,21963642,21967989,21969909,21973613,21975490,21975798,21977010,21979020,21979280,21979527,21979658,21983688,21985969,21987565,21987729,21987875,21987941,21988187,21990016,21991766,21992355,21996563,21999334,22010225,22011232,22012682,22014625,22015189,22015556,22017035,22017721,22018816,22019743,22020331,22023198,22023570,22025979,22026107,22026478,22026703,22028387,22028726,22028811,22029243,22029375,22032132,22034308,22037600,22040742,22042536,22045691,22049564,22049905,22050618,22052433,22052789,22053837,22054030,22054384,22056612,22057262,22063996,22065175,22066562,22067777,22068403,22068574,22070702,22072136,22072568,22076253,22076693,22078512,22080964,22081714,22086843,22088446,22091699,22097062,22101174,22101845,22106601,22109803,22111073,22121902,22122019,22122457,22122482,22122511,22122673,2212308', 'assoc_port': '21936862:21944867,21936863:21944903,21936864:21944046,21936865:21942284,21936890:21937823,21936891:21942715,21938118:21939172,21939370:21939743,21941592:21941800,21942442:21942538,21943568:21943658,21944347:21944467,21944620:21944818,21947409:21948132,21947410:21956207,21948383:21948687,21951418:21951656,21954280:21954497,21954281:21954476,21956389:21956640,21958293:21958507,21960222:21960308,21962610:21962716,21963434:21963642,21967261:21979280,21967262:21979527,21967263:21967989,21967264:21979658,21967265:21987565,21967266:21987729,21967267:21987875,21969569:21969909,21972738:21975490,21972739:21973613,21975410:21991766,21975411:21990016,21975412:21977010,21975413:21979020,21975414:21975798,21980179:21987941,21982976:21983688,21985604:21985969,21987906:21988187,21991685:21992355,21996082:21996563,21998719:21999334,22009703:22017035,22009706:22019743,22009708:22015189,22009713:22011232,22009717:22014625,22009719:22010225,22009721:22018816,22012335:22012682,22015078:22015556,22017423:22017721,22019959:2202033', 'assoc_mat': '21936862:metal:4213:21944867,21936863:metal:4213:21944903,21936864:metal:4213:21944046,21936865:metal:4213:21942284,21936890:metal:4213:21937823,21936891:metal:4213:21942715,21938118:metal:4213:21939172,21939370:metal:4213:21939743,21941592:metal:4213:21941800,21942442:metal:4213:21942538,21943568:metal:4213:21943658,21944347:metal:4213:21944467,21944620:metal:4213:21944818,21947409:metal:4213:21948132,21947410:metal:4213:21956207,21948383:metal:4213:21948687,21951418:metal:4213:21951656,21954280:metal:4213:21954497,21954281:metal:4213:21954476,21956389:metal:4213:21956640,21958293:metal:4213:21958507,21960222:metal:4213:21960308,21962610:metal:4213:21962716,21963434:metal:4213:21963642,21967261:metal:4213:21979280,21967262:metal:4213:21979527,21967263:metal:4213:21967989,21967264:metal:4213:21979658,21967265:metal:4213:21987565,21967266:metal:4213:21987729,21967267:metal:4213:21987875,21969569:metal:4213:21969909,21972738:metal:4213:21975490,21972739:metal:4213:21973613,21975410:metal:4213:21991766,21975411:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03328641992937033, 'nb_photo': 13766, 'list_port_cont': '21937822,21939165,21939738,21941792,21942279,21942547,21942706,21943659,21944047,21944457,21944833,21944865,21944896,21948130,21948698,21951653,21954469,21954494,21956211,21956633,21958512,21960309,21962723,21963643,21967986,21969908,21973610,21975502,21975799,21977008,21979021,21979288,21979528,21979659,21983231,21983676,21985982,21987571,21987717,21987870,21987943,21988179,21990024,21991767,21992345,21996566,21999332,22010233,22011235,22012684,22014623,22015185,22015550,22017034,22017729,22018827,22019749,22020333,22023187,22023580,22025978,22026095,22026468,22026710,22028379,22028734,22028798,22029233,22029370,22032125,22034310,22037598,22040743,22042546,22045678,22049566,22049891,22050622,22052436,22052787,22053833,22054027,22054395,22056632,22057260,22064003,22065167,22066567,22067774,22068396,22068560,22070690,22072134,22072555,22076245,22076682,22078516,22080968,22081707,22086847,22088435,22091691,22097063,22101182,22101839,22106607,22109809,22111061,22121903,22122020,22122449,22122492,22122518,2212266', 'assoc_port': '21936862:21944865,21936863:21944896,21936864:21944047,21936865:21942279,21936890:21937822,21936891:21942706,21938118:21939165,21939370:21939738,21941592:21941792,21942442:21942547,21943568:21943659,21944347:21944457,21944620:21944833,21947409:21948130,21947410:21956211,21948383:21948698,21951418:21951653,21954280:21954494,21954281:21954469,21956389:21956633,21958293:21958512,21960222:21960309,21962610:21962723,21963434:21963643,21967261:21979288,21967262:21979528,21967263:21967986,21967264:21979659,21967265:21987571,21967266:21987717,21967267:21987870,21969569:21969908,21972738:21975502,21972739:21973610,21975410:21991767,21975411:21990024,21975412:21977008,21975413:21979021,21975414:21975799,21980179:21987943,21982976:21983676,21982980:21983231,21985604:21985982,21987906:21988179,21991685:21992345,21996082:21996566,21998719:21999332,22009703:22017034,22009706:22019749,22009708:22015185,22009713:22011235,22009717:22014623,22009719:22010233,22009721:22018827,22012335:22012684,22015078:22015550,22017423:2201772', 'assoc_mat': '21936862:papier:4213:21944865,21936863:papier:4213:21944896,21936864:papier:4213:21944047,21936865:papier:4213:21942279,21936890:papier:4213:21937822,21936891:papier:4213:21942706,21938118:papier:4213:21939165,21939370:papier:4213:21939738,21941592:papier:4213:21941792,21942442:papier:4213:21942547,21943568:papier:4213:21943659,21944347:papier:4213:21944457,21944620:papier:4213:21944833,21947409:papier:4213:21948130,21947410:papier:4213:21956211,21948383:papier:4213:21948698,21951418:papier:4213:21951653,21954280:papier:4213:21954494,21954281:papier:4213:21954469,21956389:papier:4213:21956633,21958293:papier:4213:21958512,21960222:papier:4213:21960309,21962610:papier:4213:21962723,21963434:papier:4213:21963643,21967261:papier:4213:21979288,21967262:papier:4213:21979528,21967263:papier:4213:21967986,21967264:papier:4213:21979659,21967265:papier:4213:21987571,21967266:papier:4213:21987717,21967267:papier:4213:21987870,21969569:papier:4213:21969908,21972738:papier:4213:21975502,21972739:papier:4213:21973610,2197'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004110088233363629, 'nb_photo': 280, 'list_port_cont': '21937819,21939177,21942285,21942708,21944042,21944460,21944824,21948683,21951658,21956637,21962714,21963648,21975495,21975795,21979028,21979276,21979520,21985980,21987569,21987860,21987938,21990020,21996571,21999343,22015179,22015558,22017040,22018824,22023197,22028392,22028736,22029366,22032121,22034312,22037602,22040737,22042535,22045684,22049558,22050611,22053824,22054020,22054393,22056615,22066558,22067782,22068407,22070696,22076690,22078518,22080958,22081712,22101183,22111066,22122021,22122450,22125259,22127466,22131746,22132010,22133386,22135586,22139184,22150438,22158512,22163223,22176192,22176314,22176645,22176759,22180508,22197099,22219841,22221673,22227476,22230562,22243183,22243841,22244633,22245827,22249989,22250980,22251215,22251270,22252880,22255227,22258161,22258205,22269101,22269152,22269169,22269246,22269343,22269560,22270813,22270874,22270916,22270985,22271054,22271251,22273180,22281578,22287545,22289043,22289363,22292915,22297156,22303279,22305430,22308918,22311681,22313794,22316065,2232450', 'assoc_port': '21936864:21944042,21936865:21942285,21936890:21937819,21936891:21942708,21938118:21939177,21944347:21944460,21944620:21944824,21948383:21948683,21951418:21951658,21956389:21956637,21962610:21962714,21963434:21963648,21967261:21979276,21967262:21979520,21967265:21987569,21967267:21987860,21972738:21975495,21975411:21990020,21975413:21979028,21975414:21975795,21980179:21987938,21985604:21985980,21996082:21996571,21998719:21999343,22009703:22017040,22009708:22015179,22009721:22018824,22015078:22015558,22023102:22023197,22027663:22054393,22028201:22028392,22028579:22028736,22029158:22029366,22031255:22032121,22033902:22054020,22033904:22034312,22037011:22053824,22037027:22037602,22040165:22040737,22042111:22042535,22045129:22050611,22045137:22045684,22048331:22049558,22054309:22056615,22062302:22080958,22062304:22070696,22062332:22066558,22067331:22067782,22068081:22068407,22076628:22076690,22078115:22078518,22081249:22081712,22099990:22101183,22109361:22111066,22121606:22122450,22121613:22122021,22125164:2212525', 'assoc_mat': '21936864:pehd:4213:21944042,21936865:pehd:4213:21942285,21936890:pehd:4213:21937819,21936891:pehd:4213:21942708,21938118:pehd:4213:21939177,21944347:pehd:4213:21944460,21944620:pehd:4213:21944824,21948383:pehd:4213:21948683,21951418:pehd:4213:21951658,21956389:pehd:4213:21956637,21962610:pehd:4213:21962714,21963434:pehd:4213:21963648,21967261:pehd:4213:21979276,21967262:pehd:4213:21979520,21967265:pehd:4213:21987569,21967267:pehd:4213:21987860,21972738:pehd:4213:21975495,21975411:pehd:4213:21990020,21975413:pehd:4213:21979028,21975414:pehd:4213:21975795,21980179:pehd:4213:21987938,21985604:pehd:4213:21985980,21996082:pehd:4213:21996571,21998719:pehd:4213:21999343,22009703:pehd:4213:22017040,22009708:pehd:4213:22015179,22009721:pehd:4213:22018824,22015078:pehd:4213:22015558,22023102:pehd:4213:22023197,22027663:pehd:4213:22054393,22028201:pehd:4213:22028392,22028579:pehd:4213:22028736,22029158:pehd:4213:22029366,22031255:pehd:4213:22032121,22033902:pehd:4213:22054020,22033904:pehd:4213:22034312,22037011:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.019543802319342298, 'nb_photo': 10053, 'list_port_cont': '21937820,21939161,21939748,21941791,21942280,21942542,21942704,21943650,21944048,21944455,21944821,21944862,21944900,21948131,21948688,21951650,21954464,21954501,21956216,21956632,21958499,21960320,21962725,21963649,21967987,21969911,21973612,21975491,21975786,21977001,21979025,21979278,21979529,21979652,21983675,21985970,21987575,21987719,21987868,21987934,21988188,21990021,21991771,21992352,21996576,21999335,22010222,22011233,22012685,22014633,22015192,22015564,22017044,22017720,22018829,22019751,22020327,22023193,22023577,22025977,22026098,22026467,22026706,22028389,22028728,22028809,22029231,22029373,22032122,22034306,22037593,22040751,22042532,22045688,22049562,22049897,22050615,22052429,22052790,22053828,22054023,22054388,22056626,22057273,22063993,22065174,22066556,22067785,22068409,22068570,22070692,22072123,22072553,22076249,22076687,22078514,22080969,22081703,22086855,22088441,22091684,22097064,22101170,22101846,22106605,22109807,22111063,22121891,22122022,22122456,22122487,22122516,22122678,2212308', 'assoc_port': '21936862:21944862,21936863:21944900,21936864:21944048,21936865:21942280,21936890:21937820,21936891:21942704,21938118:21939161,21939370:21939748,21941592:21941791,21942442:21942542,21943568:21943650,21944347:21944455,21944620:21944821,21947409:21948131,21947410:21956216,21948383:21948688,21951418:21951650,21954280:21954501,21954281:21954464,21956389:21956632,21958293:21958499,21960222:21960320,21962610:21962725,21963434:21963649,21967261:21979278,21967262:21979529,21967263:21967987,21967264:21979652,21967265:21987575,21967266:21987719,21967267:21987868,21969569:21969911,21972738:21975491,21972739:21973612,21975410:21991771,21975411:21990021,21975412:21977001,21975413:21979025,21975414:21975786,21980179:21987934,21982976:21983675,21985604:21985970,21987906:21988188,21991685:21992352,21996082:21996576,21998719:21999335,22009703:22017044,22009706:22019751,22009708:22015192,22009713:22011233,22009717:22014633,22009719:22010222,22009721:22018829,22012335:22012685,22015078:22015564,22017423:22017720,22019959:2202032', 'assoc_mat': '21936862:pet_clair:4213:21944862,21936863:pet_clair:4213:21944900,21936864:pet_clair:4213:21944048,21936865:pet_clair:4213:21942280,21936890:pet_clair:4213:21937820,21936891:pet_clair:4213:21942704,21938118:pet_clair:4213:21939161,21939370:pet_clair:4213:21939748,21941592:pet_clair:4213:21941791,21942442:pet_clair:4213:21942542,21943568:pet_clair:4213:21943650,21944347:pet_clair:4213:21944455,21944620:pet_clair:4213:21944821,21947409:pet_clair:4213:21948131,21947410:pet_clair:4213:21956216,21948383:pet_clair:4213:21948688,21951418:pet_clair:4213:21951650,21954280:pet_clair:4213:21954501,21954281:pet_clair:4213:21954464,21956389:pet_clair:4213:21956632,21958293:pet_clair:4213:21958499,21960222:pet_clair:4213:21960320,21962610:pet_clair:4213:21962725,21963434:pet_clair:4213:21963649,21967261:pet_clair:4213:21979278,21967262:pet_clair:4213:21979529,21967263:pet_clair:4213:21967987,21967264:pet_clair:4213:21979652,21967265:pet_clair:4213:21987575,21967266:pet_clair:4213:21987719,21967267:pet_clair:4213:21987868,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00037107035335104985, 'nb_photo': 128, 'list_port_cont': '21941793,21942281,21942540,21954471,21954510,21956214,21962722,21963636,21967998,21973602,21975493,21975791,21979277,21979531,21987874,21996562,22020330,22026469,22028388,22028807,22029367,22034318,22037601,22067784,22068405,22080962,22081715,22086852,22101179,22132023,22147355,22150432,22163127,22163225,22176312,22176650,22181021,22189818,22210779,22244258,22245422,22245833,22249994,22250620,22250988,22251217,22251276,22252874,22255705,22258201,22269147,22269658,22269694,22269840,22269911,22271261,22288754,22289045,22289356,22297161,22312507,22324492,22330482,22331005,22343320,22372681,22379142,22393337,22422154,22425191,22428641,22430914,22454441,22455734,22462543,22463136,22477741,22487883,22492876,22496093,22513527,22525115,22532602,22536425,22537955,22543198,22549619,22552299,22561904,22563289,22568929,22575376', 'assoc_port': '21936865:21942281,21941592:21941793,21942442:21942540,21947410:21956214,21954280:21954510,21954281:21954471,21962610:21962722,21963434:21963636,21967261:21979277,21967262:21979531,21967263:21967998,21967267:21987874,21972738:21975493,21972739:21973602,21975414:21975791,21996082:21996562,22019959:22020330,22026343:22026469,22028201:22028388,22028577:22028807,22029158:22029367,22033904:22034318,22037027:22037601,22062302:22080962,22067331:22067784,22068081:22068405,22081249:22081715,22086128:22086852,22099990:22101179,22131689:22132023,22146589:22147355,22148725:22150432,22162864:22163127,22162865:22163225,22174349:22176650,22175881:22176312,22180112:22181021,22189332:22189818,22210237:22210779,22242953:22245833,22242954:22250988,22244167:22244258,22245281:22245422,22249280:22249994,22250548:22250620,22251175:22251217,22251176:22251276,22252720:22252874,22255555:22255705,22258026:22258201,22269045:22269840,22269050:22269911,22269051:22269658,22269052:22269694,22269065:22269147,22271182:22271261,22286576:2228875', 'assoc_mat': '21936865:pet_fonce:4213:21942281,21941592:pet_fonce:4213:21941793,21942442:pet_fonce:4213:21942540,21947410:pet_fonce:4213:21956214,21954280:pet_fonce:4213:21954510,21954281:pet_fonce:4213:21954471,21962610:pet_fonce:4213:21962722,21963434:pet_fonce:4213:21963636,21967261:pet_fonce:4213:21979277,21967262:pet_fonce:4213:21979531,21967263:pet_fonce:4213:21967998,21967267:pet_fonce:4213:21987874,21972738:pet_fonce:4213:21975493,21972739:pet_fonce:4213:21973602,21975414:pet_fonce:4213:21975791,21996082:pet_fonce:4213:21996562,22019959:pet_fonce:4213:22020330,22026343:pet_fonce:4213:22026469,22028201:pet_fonce:4213:22028388,22028577:pet_fonce:4213:22028807,22029158:pet_fonce:4213:22029367,22033904:pet_fonce:4213:22034318,22037027:pet_fonce:4213:22037601,22062302:pet_fonce:4213:22080962,22067331:pet_fonce:4213:22067784,22068081:pet_fonce:4213:22068405,22081249:pet_fonce:4213:22081715,22086128:pet_fonce:4213:22086852,22099990:pet_fonce:4213:22101179,22131689:pet_fonce:4213:22132023,22146589:pet_fonce:4213:22147355,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.010509359292383195, 'nb_photo': 4176, 'list_port_cont': '21937824,21939173,21939741,21941801,21942287,21942536,21942709,21943654,21944054,21944465,21944826,21944860,21944902,21948127,21948692,21951659,21954465,21954504,21956206,21956630,21958508,21960315,21962721,21963638,21967991,21969907,21973611,21975503,21975797,21977002,21979015,21979283,21979530,21979656,21983689,21985971,21987564,21987728,21987863,21987937,21988181,21990015,21991761,21992343,21996578,21999345,22010234,22011236,22012688,22014635,22015187,22015548,22017031,22017728,22018820,22019741,22020323,22023190,22023568,22025982,22026097,22026475,22026714,22028383,22028735,22028806,22029235,22029380,22032120,22034305,22037596,22040741,22042544,22045683,22049559,22049894,22050619,22052438,22052791,22053823,22054031,22054392,22056614,22057274,22064002,22065168,22066564,22067779,22068398,22068571,22070700,22072124,22072554,22076259,22076691,22078519,22080956,22081711,22086851,22088450,22091696,22097068,22101181,22101842,22106595,22109810,22111060,22121898,22122032,22122451,22122484,22122519,22122670,2212308', 'assoc_port': '21936862:21944860,21936863:21944902,21936864:21944054,21936865:21942287,21936890:21937824,21936891:21942709,21938118:21939173,21939370:21939741,21941592:21941801,21942442:21942536,21943568:21943654,21944347:21944465,21944620:21944826,21947409:21948127,21947410:21956206,21948383:21948692,21951418:21951659,21954280:21954504,21954281:21954465,21956389:21956630,21958293:21958508,21960222:21960315,21962610:21962721,21963434:21963638,21967261:21979283,21967262:21979530,21967263:21967991,21967264:21979656,21967265:21987564,21967266:21987728,21967267:21987863,21969569:21969907,21972738:21975503,21972739:21973611,21975410:21991761,21975411:21990015,21975412:21977002,21975413:21979015,21975414:21975797,21980179:21987937,21982976:21983689,21985604:21985971,21987906:21988181,21991685:21992343,21996082:21996578,21998719:21999345,22009703:22017031,22009706:22019741,22009708:22015187,22009713:22011236,22009717:22014635,22009719:22010234,22009721:22018820,22012335:22012688,22015078:22015548,22017423:22017728,22019959:2202032', 'assoc_mat': '21936862:pet_opaque:4213:21944860,21936863:pet_opaque:4213:21944902,21936864:pet_opaque:4213:21944054,21936865:pet_opaque:4213:21942287,21936890:pet_opaque:4213:21937824,21936891:pet_opaque:4213:21942709,21938118:pet_opaque:4213:21939173,21939370:pet_opaque:4213:21939741,21941592:pet_opaque:4213:21941801,21942442:pet_opaque:4213:21942536,21943568:pet_opaque:4213:21943654,21944347:pet_opaque:4213:21944465,21944620:pet_opaque:4213:21944826,21947409:pet_opaque:4213:21948127,21947410:pet_opaque:4213:21956206,21948383:pet_opaque:4213:21948692,21951418:pet_opaque:4213:21951659,21954280:pet_opaque:4213:21954504,21954281:pet_opaque:4213:21954465,21956389:pet_opaque:4213:21956630,21958293:pet_opaque:4213:21958508,21960222:pet_opaque:4213:21960315,21962610:pet_opaque:4213:21962721,21963434:pet_opaque:4213:21963638,21967261:pet_opaque:4213:21979283,21967262:pet_opaque:4213:21979530,21967263:pet_opaque:4213:21967991,21967264:pet_opaque:4213:21979656,21967265:pet_opaque:4213:21987564,21967266:pet_opaque:4213:21987728,2196'}), 'main_stat': {'nb_photos': 10289}}, 'hostname': (('raspi-92',),), 'impurety_average_per_hashtag': [(('refus', '2025-04', 0.10545454222745454),)]} 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 ! 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 ! 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 ! 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 ! SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="refus_amiens"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3142 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=3142 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= 3142 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=3142 # 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":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=3996 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=3996 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= 3996 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=3996 # 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 ! 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 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 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 : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 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': 4213, 'hashtag_proportion': 'barquette_opaque,carton,ela,etiquette,film_plastique,kraft,metal,papier,pehd,pet_clair,pet_opaque,pet_fonce', 'hashtag_parmi': 'refus,textiles_sanitaires', 'hashtag_weights': {'barquette_opaque': 1, 'carton': 1, 'ela': 1, 'etiquette': 1, 'film_plastique': 1, 'kraft': 1, 'metal': 1, 'papier': 1, 'pehd': 1, 'pet_clair': 1, 'pet_opaque': 1, 'pet_fonce': 1, 'textiles_sanitaires': 1, 'refus': 3}} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((10289,),), 'unwanted_material_monthly_percentage': ((0.10545454222745454,),), 'material_repartition': (('refus', 9505),), 'material_dict': {'refus': 9505}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.13512648719161072, 327), (datetime.date(2025, 4, 15), 0.09941740959530766, 783), (datetime.date(2025, 4, 16), 0.1043744342484117, 632), (datetime.date(2025, 4, 17), 0.10502896153045592, 737), (datetime.date(2025, 4, 18), 0.11130520673262517, 702), (datetime.date(2025, 4, 19), 0.08678541779840526, 898), (datetime.date(2025, 4, 20), 0.10204182124944955, 466), (datetime.date(2025, 4, 21), 0.09702486023602183, 376), (datetime.date(2025, 4, 22), 0.09974312522637868, 579), (datetime.date(2025, 4, 23), 0.13019140744565738, 346), (datetime.date(2025, 4, 24), 0.10880003812221362, 146), (datetime.date(2025, 4, 25), 0.08655851041734378, 315), (datetime.date(2025, 4, 28), 0.10023063708027577, 568), (datetime.date(2025, 4, 29), 0.0939075863041547, 717), (datetime.date(2025, 4, 30), 0.10718695142538777, 784)), 'impurety_average_data_per_hashtag': {'refus': ((datetime.date(2025, 4, 1), 0.11460468725305437, 894), (datetime.date(2025, 4, 2), 0.11726475064195395, 1019), (datetime.date(2025, 4, 3), 0.13512648719161072, 327), (datetime.date(2025, 4, 15), 0.09941740959530766, 783), (datetime.date(2025, 4, 16), 0.1043744342484117, 632), (datetime.date(2025, 4, 17), 0.10502896153045592, 737), (datetime.date(2025, 4, 18), 0.11130520673262517, 702), (datetime.date(2025, 4, 19), 0.08678541779840526, 898), (datetime.date(2025, 4, 20), 0.10204182124944955, 466), (datetime.date(2025, 4, 21), 0.09702486023602183, 376), (datetime.date(2025, 4, 22), 0.09974312522637868, 579), (datetime.date(2025, 4, 23), 0.13019140744565738, 346), (datetime.date(2025, 4, 24), 0.10880003812221362, 146), (datetime.date(2025, 4, 25), 0.08655851041734378, 315), (datetime.date(2025, 4, 28), 0.10023063708027577, 568), (datetime.date(2025, 4, 29), 0.0939075863041547, 717), (datetime.date(2025, 4, 30), 0.10718695142538777, 784))}, 'quality_array': [['-2.4864147866338886', '01042025'], ['-2.472981252729084', '02042025'], ['-2.788215443157055', '03042025'], ['-2.400774424658296', '15042025'], ['-2.3311456371666472', '16042025'], ['-2.267627155642355', '17042025'], ['-2.3696749135764827', '18042025'], ['-2.559122253884004', '19042025'], ['-2.2164436271647525', '20042025'], ['-2.1695806833211666', '21042025'], ['-2.150534756301885', '22042025'], ['-2.3484549247166484', '23042025'], ['-1.7013619224805132', '24042025'], ['-1.7702668351956723', '25042025'], ['-2.1031149012610193', '28042025'], ['-2.0341007975686067', '29042025'], ['-1.940333398946985', '30042025']], 'number_of_batch': ((389,),), 'datou_id_sts': 3142, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'barquette_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004108143242236501, 'nb_photo': 2246, 'list_port_cont': '21937821,21939162,21939746,21941786,21942286,21942545,21942710,21943656,21944041,21944452,21944820,21944855,21944892,21948133,21948695,21951644,21954467,21954496,21956205,21956628,21958502,21960306,21962713,21963637,21967999,21969915,21973608,21975500,21975800,21977007,21979024,21979274,21979535,21979655,21983684,21985983,21987573,21987720,21987872,21987946,21990023,21991769,21992349,21996567,21999338,22010235,22011237,22012691,22014637,22015182,22015551,22017043,22017719,22018831,22019753,22020338,22023199,22023576,22026100,22026474,22026711,22028391,22028723,22028802,22029232,22029374,22032118,22034309,22037607,22040747,22042545,22045690,22049555,22049900,22050612,22052435,22052797,22053826,22054025,22054398,22056638,22057265,22064001,22065163,22066559,22067770,22068399,22068561,22070705,22072133,22072562,22076257,22076688,22078508,22080961,22081709,22086857,22097057,22101172,22101851,22106600,22109817,22111064,22122018,22122445,22122480,22122525,22122682,22123080,22124555,22125261,22125331,22127464,2213174', 'assoc_port': '21936862:21944855,21936863:21944892,21936864:21944041,21936865:21942286,21936890:21937821,21936891:21942710,21938118:21939162,21939370:21939746,21941592:21941786,21942442:21942545,21943568:21943656,21944347:21944452,21944620:21944820,21947409:21948133,21947410:21956205,21948383:21948695,21951418:21951644,21954280:21954496,21954281:21954467,21956389:21956628,21958293:21958502,21960222:21960306,21962610:21962713,21963434:21963637,21967261:21979274,21967262:21979535,21967263:21967999,21967264:21979655,21967265:21987573,21967266:21987720,21967267:21987872,21969569:21969915,21972738:21975500,21972739:21973608,21975410:21991769,21975411:21990023,21975412:21977007,21975413:21979024,21975414:21975800,21980179:21987946,21982976:21983684,21985604:21985983,21991685:21992349,21996082:21996567,21998719:21999338,22009703:22017043,22009706:22019753,22009708:22015182,22009713:22011237,22009717:22014637,22009719:22010235,22009721:22018831,22012335:22012691,22015078:22015551,22017423:22017719,22019959:22020338,22023102:2202319', 'assoc_mat': '21936862:barquette_opaque:4213:21944855,21936863:barquette_opaque:4213:21944892,21936864:barquette_opaque:4213:21944041,21936865:barquette_opaque:4213:21942286,21936890:barquette_opaque:4213:21937821,21936891:barquette_opaque:4213:21942710,21938118:barquette_opaque:4213:21939162,21939370:barquette_opaque:4213:21939746,21941592:barquette_opaque:4213:21941786,21942442:barquette_opaque:4213:21942545,21943568:barquette_opaque:4213:21943656,21944347:barquette_opaque:4213:21944452,21944620:barquette_opaque:4213:21944820,21947409:barquette_opaque:4213:21948133,21947410:barquette_opaque:4213:21956205,21948383:barquette_opaque:4213:21948695,21951418:barquette_opaque:4213:21951644,21954280:barquette_opaque:4213:21954496,21954281:barquette_opaque:4213:21954467,21956389:barquette_opaque:4213:21956628,21958293:barquette_opaque:4213:21958502,21960222:barquette_opaque:4213:21960306,21962610:barquette_opaque:4213:21962713,21963434:barquette_opaque:4213:21963637,21967261:barquette_opaque:4213:21979274,21967262:barquette_opaqu'}, {'unwanted_material': 'carton', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.002458002690027309, 'nb_photo': 2501, 'list_port_cont': '21937830,21939168,21939750,21941788,21942278,21942544,21942711,21943655,21944049,21944463,21944830,21944861,21944898,21948138,21948691,21951655,21954462,21954502,21956215,21956639,21958505,21960307,21962715,21963635,21967984,21969920,21973605,21975504,21975796,21977012,21979016,21979286,21979525,21979650,21983680,21985984,21987572,21987721,21987808,21987865,21987945,21990018,21991772,21992341,21996561,21999339,22010228,22011231,22012680,22014638,22015191,22017045,22017718,22018818,22019740,22020336,22023201,22023573,22025976,22026108,22026479,22026705,22028394,22028724,22028813,22029242,22029371,22032116,22034320,22037604,22040749,22042538,22045677,22049561,22049896,22050613,22052439,22052783,22053835,22054028,22054396,22056618,22057266,22064000,22065171,22066566,22067778,22068410,22068566,22070689,22072127,22072566,22076250,22078511,22080971,22081713,22086854,22091685,22101177,22101850,22106592,22109806,22111065,22121894,22122028,22122452,22122478,22122526,22122667,22123090,22124550,22125265,22125338,2212745', 'assoc_port': '21936862:21944861,21936863:21944898,21936864:21944049,21936865:21942278,21936890:21937830,21936891:21942711,21938118:21939168,21939370:21939750,21941592:21941788,21942442:21942544,21943568:21943655,21944347:21944463,21944620:21944830,21947409:21948138,21947410:21956215,21948383:21948691,21951418:21951655,21954280:21954502,21954281:21954462,21956389:21956639,21958293:21958505,21960222:21960307,21962610:21962715,21963434:21963635,21967261:21979286,21967262:21979525,21967263:21967984,21967264:21979650,21967265:21987572,21967266:21987721,21967267:21987865,21969569:21969920,21972738:21975504,21972739:21973605,21975410:21991772,21975411:21990018,21975412:21977012,21975413:21979016,21975414:21975796,21980179:21987945,21982976:21983680,21982979:21987808,21985604:21985984,21991685:21992341,21996082:21996561,21998719:21999339,22009703:22017045,22009706:22019740,22009708:22015191,22009713:22011231,22009717:22014638,22009719:22010228,22009721:22018818,22012335:22012680,22017423:22017718,22019959:22020336,22023102:2202320', 'assoc_mat': '21936862:carton:4213:21944861,21936863:carton:4213:21944898,21936864:carton:4213:21944049,21936865:carton:4213:21942278,21936890:carton:4213:21937830,21936891:carton:4213:21942711,21938118:carton:4213:21939168,21939370:carton:4213:21939750,21941592:carton:4213:21941788,21942442:carton:4213:21942544,21943568:carton:4213:21943655,21944347:carton:4213:21944463,21944620:carton:4213:21944830,21947409:carton:4213:21948138,21947410:carton:4213:21956215,21948383:carton:4213:21948691,21951418:carton:4213:21951655,21954280:carton:4213:21954502,21954281:carton:4213:21954462,21956389:carton:4213:21956639,21958293:carton:4213:21958505,21960222:carton:4213:21960307,21962610:carton:4213:21962715,21963434:carton:4213:21963635,21967261:carton:4213:21979286,21967262:carton:4213:21979525,21967263:carton:4213:21967984,21967264:carton:4213:21979650,21967265:carton:4213:21987572,21967266:carton:4213:21987721,21967267:carton:4213:21987865,21969569:carton:4213:21969920,21972738:carton:4213:21975504,21972739:carton:4213:21973605,2197'}, {'unwanted_material': 'ela', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004443851377616915, 'nb_photo': 813, 'list_port_cont': '21937831,21941796,21942272,21942537,21942703,21943662,21944052,21944458,21944822,21944854,21948129,21948689,21951651,21954503,21956208,21956635,21960314,21963647,21967988,21969913,21973614,21975505,21976999,21979279,21979536,21979646,21983690,21985981,21987578,21987867,21987935,21990017,21991770,21996565,21999346,22011243,22012678,22014630,22015180,22015560,22017033,22018822,22020328,22023196,22023575,22026094,22026470,22026718,22028395,22028733,22028804,22029245,22029378,22034307,22040750,22042534,22045685,22049567,22052443,22052795,22053839,22054022,22056624,22057268,22064006,22065165,22066571,22068564,22070704,22072122,22076248,22080967,22081718,22086856,22097069,22101176,22101843,22106602,22109811,22111075,22122030,22122446,22122522,22122677,22123092,22124556,22125264,22125340,22131748,22132016,22135579,22139185,22142832,22150440,22151050,22153499,22158515,22163121,22163214,22176190,22176308,22176355,22176655,22176745,22181024,22182630,22189816,22191924,22197112,22201221,22205037,22210788,22215933,2222747', 'assoc_port': '21936862:21944854,21936864:21944052,21936865:21942272,21936890:21937831,21936891:21942703,21941592:21941796,21942442:21942537,21943568:21943662,21944347:21944458,21944620:21944822,21947409:21948129,21947410:21956208,21948383:21948689,21951418:21951651,21954280:21954503,21956389:21956635,21960222:21960314,21963434:21963647,21967261:21979279,21967262:21979536,21967263:21967988,21967264:21979646,21967265:21987578,21967267:21987867,21969569:21969913,21972738:21975505,21972739:21973614,21975410:21991770,21975411:21990017,21975412:21976999,21980179:21987935,21982976:21983690,21985604:21985981,21996082:21996565,21998719:21999346,22009703:22017033,22009708:22015180,22009713:22011243,22009717:22014630,22009721:22018822,22012335:22012678,22015078:22015560,22019959:22020328,22023102:22023196,22023491:22023575,22025770:22026094,22026342:22026718,22026343:22026470,22027664:22057268,22028201:22028395,22028577:22028804,22028579:22028733,22029158:22029378,22029159:22029245,22033902:22054022,22033904:22034307,22037011:2205383', 'assoc_mat': '21936862:ela:4213:21944854,21936864:ela:4213:21944052,21936865:ela:4213:21942272,21936890:ela:4213:21937831,21936891:ela:4213:21942703,21941592:ela:4213:21941796,21942442:ela:4213:21942537,21943568:ela:4213:21943662,21944347:ela:4213:21944458,21944620:ela:4213:21944822,21947409:ela:4213:21948129,21947410:ela:4213:21956208,21948383:ela:4213:21948689,21951418:ela:4213:21951651,21954280:ela:4213:21954503,21956389:ela:4213:21956635,21960222:ela:4213:21960314,21963434:ela:4213:21963647,21967261:ela:4213:21979279,21967262:ela:4213:21979536,21967263:ela:4213:21967988,21967264:ela:4213:21979646,21967265:ela:4213:21987578,21967267:ela:4213:21987867,21969569:ela:4213:21969913,21972738:ela:4213:21975505,21972739:ela:4213:21973614,21975410:ela:4213:21991770,21975411:ela:4213:21990017,21975412:ela:4213:21976999,21980179:ela:4213:21987935,21982976:ela:4213:21983690,21985604:ela:4213:21985981,21996082:ela:4213:21996565,21998719:ela:4213:21999346,22009703:ela:4213:22017033,22009708:ela:4213:22015180,22009713:ela:4213:2201124'}, {'unwanted_material': 'etiquette', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.003038590602422445, 'nb_photo': 3002, 'list_port_cont': '21937832,21939163,21939737,21941797,21942271,21942543,21942714,21943657,21944045,21944459,21944829,21944866,21944889,21948137,21948682,21951643,21954468,21954505,21956210,21956629,21958503,21960317,21962726,21963646,21967993,21969912,21973603,21975499,21975794,21977009,21979027,21979287,21979521,21979647,21983235,21983683,21985972,21987576,21987718,21987859,21987931,21988184,21990028,21991774,21992347,21996570,21999347,22010232,22011229,22012692,22014636,22015186,22015549,22017041,22017725,22018819,22019747,22020332,22023191,22023569,22025985,22026106,22026477,22026719,22028381,22028721,22028803,22029240,22029382,22032130,22034319,22037606,22040746,22042541,22045692,22049563,22049903,22050621,22052444,22052792,22053838,22054034,22054399,22056636,22057261,22064004,22065170,22066561,22067781,22068406,22068569,22070695,22072126,22072552,22076246,22076689,22078509,22080959,22081706,22086858,22088449,22091694,22097058,22101169,22101848,22106604,22109816,22111074,22121899,22122034,22122444,22122481,22122517,2212267', 'assoc_port': '21936862:21944866,21936863:21944889,21936864:21944045,21936865:21942271,21936890:21937832,21936891:21942714,21938118:21939163,21939370:21939737,21941592:21941797,21942442:21942543,21943568:21943657,21944347:21944459,21944620:21944829,21947409:21948137,21947410:21956210,21948383:21948682,21951418:21951643,21954280:21954505,21954281:21954468,21956389:21956629,21958293:21958503,21960222:21960317,21962610:21962726,21963434:21963646,21967261:21979287,21967262:21979521,21967263:21967993,21967264:21979647,21967265:21987576,21967266:21987718,21967267:21987859,21969569:21969912,21972738:21975499,21972739:21973603,21975410:21991774,21975411:21990028,21975412:21977009,21975413:21979027,21975414:21975794,21980179:21987931,21982976:21983683,21982980:21983235,21985604:21985972,21987906:21988184,21991685:21992347,21996082:21996570,21998719:21999347,22009703:22017041,22009706:22019747,22009708:22015186,22009713:22011229,22009717:22014636,22009719:22010232,22009721:22018819,22012335:22012692,22015078:22015549,22017423:2201772', 'assoc_mat': '21936862:etiquette:4213:21944866,21936863:etiquette:4213:21944889,21936864:etiquette:4213:21944045,21936865:etiquette:4213:21942271,21936890:etiquette:4213:21937832,21936891:etiquette:4213:21942714,21938118:etiquette:4213:21939163,21939370:etiquette:4213:21939737,21941592:etiquette:4213:21941797,21942442:etiquette:4213:21942543,21943568:etiquette:4213:21943657,21944347:etiquette:4213:21944459,21944620:etiquette:4213:21944829,21947409:etiquette:4213:21948137,21947410:etiquette:4213:21956210,21948383:etiquette:4213:21948682,21951418:etiquette:4213:21951643,21954280:etiquette:4213:21954505,21954281:etiquette:4213:21954468,21956389:etiquette:4213:21956629,21958293:etiquette:4213:21958503,21960222:etiquette:4213:21960317,21962610:etiquette:4213:21962726,21963434:etiquette:4213:21963646,21967261:etiquette:4213:21979287,21967262:etiquette:4213:21979521,21967263:etiquette:4213:21967993,21967264:etiquette:4213:21979647,21967265:etiquette:4213:21987576,21967266:etiquette:4213:21987718,21967267:etiquette:4213:21987859,2'}, {'unwanted_material': 'film_plastique', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03274580738220678, 'nb_photo': 7891, 'list_port_cont': '21937818,21939175,21939740,21941790,21942276,21942534,21942712,21943653,21944044,21944468,21944823,21944853,21944888,21948124,21948693,21951647,21954463,21954509,21956213,21956627,21958510,21960322,21962720,21963644,21967985,21969910,21973618,21975498,21975790,21977000,21979018,21979275,21979534,21979651,21983681,21985975,21987570,21987715,21987869,21987944,21988183,21990029,21991760,21992348,21996564,21999336,22010236,22011230,22012677,22014626,22015181,22015557,22017038,22017717,22018823,22019748,22020339,22023185,22023578,22025980,22026096,22026482,22026709,22028390,22028729,22028801,22029237,22029381,22032129,22034317,22037595,22040744,22042547,22045687,22049552,22049895,22050614,22052437,22052798,22053830,22054024,22054391,22056616,22057270,22064005,22065166,22066557,22067780,22068411,22068576,22068705,22070693,22072129,22072563,22076244,22076686,22078507,22080960,22081702,22086846,22088448,22091682,22097060,22101173,22101844,22106597,22109813,22111068,22121887,22122026,22122447,22122483,22122520,2212268', 'assoc_port': '21936862:21944853,21936863:21944888,21936864:21944044,21936865:21942276,21936890:21937818,21936891:21942712,21938118:21939175,21939370:21939740,21941592:21941790,21942442:21942534,21943568:21943653,21944347:21944468,21944620:21944823,21947409:21948124,21947410:21956213,21948383:21948693,21951418:21951647,21954280:21954509,21954281:21954463,21956389:21956627,21958293:21958510,21960222:21960322,21962610:21962720,21963434:21963644,21967261:21979275,21967262:21979534,21967263:21967985,21967264:21979651,21967265:21987570,21967266:21987715,21967267:21987869,21969569:21969910,21972738:21975498,21972739:21973618,21975410:21991760,21975411:21990029,21975412:21977000,21975413:21979018,21975414:21975790,21980179:21987944,21982976:21983681,21985604:21985975,21987906:21988183,21991685:21992348,21996082:21996564,21998719:21999336,22009703:22017038,22009706:22019748,22009708:22015181,22009713:22011230,22009717:22014626,22009719:22010236,22009721:22018823,22012335:22012677,22015078:22015557,22017423:22017717,22019959:2202033', 'assoc_mat': '21936862:film_plastique:4213:21944853,21936863:film_plastique:4213:21944888,21936864:film_plastique:4213:21944044,21936865:film_plastique:4213:21942276,21936890:film_plastique:4213:21937818,21936891:film_plastique:4213:21942712,21938118:film_plastique:4213:21939175,21939370:film_plastique:4213:21939740,21941592:film_plastique:4213:21941790,21942442:film_plastique:4213:21942534,21943568:film_plastique:4213:21943653,21944347:film_plastique:4213:21944468,21944620:film_plastique:4213:21944823,21947409:film_plastique:4213:21948124,21947410:film_plastique:4213:21956213,21948383:film_plastique:4213:21948693,21951418:film_plastique:4213:21951647,21954280:film_plastique:4213:21954509,21954281:film_plastique:4213:21954463,21956389:film_plastique:4213:21956627,21958293:film_plastique:4213:21958510,21960222:film_plastique:4213:21960322,21962610:film_plastique:4213:21962720,21963434:film_plastique:4213:21963644,21967261:film_plastique:4213:21979275,21967262:film_plastique:4213:21979534,21967263:film_plastique:4213:2196798'}, {'unwanted_material': 'kraft', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.0007051638095873881, 'nb_photo': 23, 'list_port_cont': '21942277,21944864,21969916,21977011,22057267,22072137,22101180,22125330,22163117,22244944,22248072,22270905,22272865,22331009,22355412,22372238,22448590,22477742,22487918,22540430,22575382', 'assoc_port': '21936862:21944864,21936865:21942277,21969569:21969916,21975412:21977011,22027664:22057267,22062303:22072137,22099990:22101180,22125241:22125330,22162864:22163117,22244778:22244944,22247768:22248072,22270725:22270905,22272668:22272865,22328684:22331009,22355014:22355412,22370563:22372238,22448178:22448590,22477089:22477742,22487766:22487918,22539960:22540430,22575196:22575382', 'assoc_mat': '21936862:kraft:4213:21944864,21936865:kraft:4213:21942277,21969569:kraft:4213:21969916,21975412:kraft:4213:21977011,22027664:kraft:4213:22057267,22062303:kraft:4213:22072137,22099990:kraft:4213:22101180,22125241:kraft:4213:22125330,22162864:kraft:4213:22163117,22244778:kraft:4213:22244944,22247768:kraft:4213:22248072,22270725:kraft:4213:22270905,22272668:kraft:4213:22272865,22328684:kraft:4213:22331009,22355014:kraft:4213:22355412,22370563:kraft:4213:22372238,22448178:kraft:4213:22448590,22477089:kraft:4213:22477742,22487766:kraft:4213:22487918,22539960:kraft:4213:22540430,22575196:kraft:4213:22575382'}, {'unwanted_material': 'metal', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004268357933411616, 'nb_photo': 5133, 'list_port_cont': '21937823,21939172,21939743,21941800,21942284,21942538,21942715,21943658,21944046,21944467,21944818,21944867,21944903,21948132,21948687,21951656,21954476,21954497,21956207,21956640,21958507,21960308,21962716,21963642,21967989,21969909,21973613,21975490,21975798,21977010,21979020,21979280,21979527,21979658,21983688,21985969,21987565,21987729,21987875,21987941,21988187,21990016,21991766,21992355,21996563,21999334,22010225,22011232,22012682,22014625,22015189,22015556,22017035,22017721,22018816,22019743,22020331,22023198,22023570,22025979,22026107,22026478,22026703,22028387,22028726,22028811,22029243,22029375,22032132,22034308,22037600,22040742,22042536,22045691,22049564,22049905,22050618,22052433,22052789,22053837,22054030,22054384,22056612,22057262,22063996,22065175,22066562,22067777,22068403,22068574,22070702,22072136,22072568,22076253,22076693,22078512,22080964,22081714,22086843,22088446,22091699,22097062,22101174,22101845,22106601,22109803,22111073,22121902,22122019,22122457,22122482,22122511,22122673,2212308', 'assoc_port': '21936862:21944867,21936863:21944903,21936864:21944046,21936865:21942284,21936890:21937823,21936891:21942715,21938118:21939172,21939370:21939743,21941592:21941800,21942442:21942538,21943568:21943658,21944347:21944467,21944620:21944818,21947409:21948132,21947410:21956207,21948383:21948687,21951418:21951656,21954280:21954497,21954281:21954476,21956389:21956640,21958293:21958507,21960222:21960308,21962610:21962716,21963434:21963642,21967261:21979280,21967262:21979527,21967263:21967989,21967264:21979658,21967265:21987565,21967266:21987729,21967267:21987875,21969569:21969909,21972738:21975490,21972739:21973613,21975410:21991766,21975411:21990016,21975412:21977010,21975413:21979020,21975414:21975798,21980179:21987941,21982976:21983688,21985604:21985969,21987906:21988187,21991685:21992355,21996082:21996563,21998719:21999334,22009703:22017035,22009706:22019743,22009708:22015189,22009713:22011232,22009717:22014625,22009719:22010225,22009721:22018816,22012335:22012682,22015078:22015556,22017423:22017721,22019959:2202033', 'assoc_mat': '21936862:metal:4213:21944867,21936863:metal:4213:21944903,21936864:metal:4213:21944046,21936865:metal:4213:21942284,21936890:metal:4213:21937823,21936891:metal:4213:21942715,21938118:metal:4213:21939172,21939370:metal:4213:21939743,21941592:metal:4213:21941800,21942442:metal:4213:21942538,21943568:metal:4213:21943658,21944347:metal:4213:21944467,21944620:metal:4213:21944818,21947409:metal:4213:21948132,21947410:metal:4213:21956207,21948383:metal:4213:21948687,21951418:metal:4213:21951656,21954280:metal:4213:21954497,21954281:metal:4213:21954476,21956389:metal:4213:21956640,21958293:metal:4213:21958507,21960222:metal:4213:21960308,21962610:metal:4213:21962716,21963434:metal:4213:21963642,21967261:metal:4213:21979280,21967262:metal:4213:21979527,21967263:metal:4213:21967989,21967264:metal:4213:21979658,21967265:metal:4213:21987565,21967266:metal:4213:21987729,21967267:metal:4213:21987875,21969569:metal:4213:21969909,21972738:metal:4213:21975490,21972739:metal:4213:21973613,21975410:metal:4213:21991766,21975411:'}, {'unwanted_material': 'papier', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.03328641992937033, 'nb_photo': 13766, 'list_port_cont': '21937822,21939165,21939738,21941792,21942279,21942547,21942706,21943659,21944047,21944457,21944833,21944865,21944896,21948130,21948698,21951653,21954469,21954494,21956211,21956633,21958512,21960309,21962723,21963643,21967986,21969908,21973610,21975502,21975799,21977008,21979021,21979288,21979528,21979659,21983231,21983676,21985982,21987571,21987717,21987870,21987943,21988179,21990024,21991767,21992345,21996566,21999332,22010233,22011235,22012684,22014623,22015185,22015550,22017034,22017729,22018827,22019749,22020333,22023187,22023580,22025978,22026095,22026468,22026710,22028379,22028734,22028798,22029233,22029370,22032125,22034310,22037598,22040743,22042546,22045678,22049566,22049891,22050622,22052436,22052787,22053833,22054027,22054395,22056632,22057260,22064003,22065167,22066567,22067774,22068396,22068560,22070690,22072134,22072555,22076245,22076682,22078516,22080968,22081707,22086847,22088435,22091691,22097063,22101182,22101839,22106607,22109809,22111061,22121903,22122020,22122449,22122492,22122518,2212266', 'assoc_port': '21936862:21944865,21936863:21944896,21936864:21944047,21936865:21942279,21936890:21937822,21936891:21942706,21938118:21939165,21939370:21939738,21941592:21941792,21942442:21942547,21943568:21943659,21944347:21944457,21944620:21944833,21947409:21948130,21947410:21956211,21948383:21948698,21951418:21951653,21954280:21954494,21954281:21954469,21956389:21956633,21958293:21958512,21960222:21960309,21962610:21962723,21963434:21963643,21967261:21979288,21967262:21979528,21967263:21967986,21967264:21979659,21967265:21987571,21967266:21987717,21967267:21987870,21969569:21969908,21972738:21975502,21972739:21973610,21975410:21991767,21975411:21990024,21975412:21977008,21975413:21979021,21975414:21975799,21980179:21987943,21982976:21983676,21982980:21983231,21985604:21985982,21987906:21988179,21991685:21992345,21996082:21996566,21998719:21999332,22009703:22017034,22009706:22019749,22009708:22015185,22009713:22011235,22009717:22014623,22009719:22010233,22009721:22018827,22012335:22012684,22015078:22015550,22017423:2201772', 'assoc_mat': '21936862:papier:4213:21944865,21936863:papier:4213:21944896,21936864:papier:4213:21944047,21936865:papier:4213:21942279,21936890:papier:4213:21937822,21936891:papier:4213:21942706,21938118:papier:4213:21939165,21939370:papier:4213:21939738,21941592:papier:4213:21941792,21942442:papier:4213:21942547,21943568:papier:4213:21943659,21944347:papier:4213:21944457,21944620:papier:4213:21944833,21947409:papier:4213:21948130,21947410:papier:4213:21956211,21948383:papier:4213:21948698,21951418:papier:4213:21951653,21954280:papier:4213:21954494,21954281:papier:4213:21954469,21956389:papier:4213:21956633,21958293:papier:4213:21958512,21960222:papier:4213:21960309,21962610:papier:4213:21962723,21963434:papier:4213:21963643,21967261:papier:4213:21979288,21967262:papier:4213:21979528,21967263:papier:4213:21967986,21967264:papier:4213:21979659,21967265:papier:4213:21987571,21967266:papier:4213:21987717,21967267:papier:4213:21987870,21969569:papier:4213:21969908,21972738:papier:4213:21975502,21972739:papier:4213:21973610,2197'}, {'unwanted_material': 'pehd', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.004110088233363629, 'nb_photo': 280, 'list_port_cont': '21937819,21939177,21942285,21942708,21944042,21944460,21944824,21948683,21951658,21956637,21962714,21963648,21975495,21975795,21979028,21979276,21979520,21985980,21987569,21987860,21987938,21990020,21996571,21999343,22015179,22015558,22017040,22018824,22023197,22028392,22028736,22029366,22032121,22034312,22037602,22040737,22042535,22045684,22049558,22050611,22053824,22054020,22054393,22056615,22066558,22067782,22068407,22070696,22076690,22078518,22080958,22081712,22101183,22111066,22122021,22122450,22125259,22127466,22131746,22132010,22133386,22135586,22139184,22150438,22158512,22163223,22176192,22176314,22176645,22176759,22180508,22197099,22219841,22221673,22227476,22230562,22243183,22243841,22244633,22245827,22249989,22250980,22251215,22251270,22252880,22255227,22258161,22258205,22269101,22269152,22269169,22269246,22269343,22269560,22270813,22270874,22270916,22270985,22271054,22271251,22273180,22281578,22287545,22289043,22289363,22292915,22297156,22303279,22305430,22308918,22311681,22313794,22316065,2232450', 'assoc_port': '21936864:21944042,21936865:21942285,21936890:21937819,21936891:21942708,21938118:21939177,21944347:21944460,21944620:21944824,21948383:21948683,21951418:21951658,21956389:21956637,21962610:21962714,21963434:21963648,21967261:21979276,21967262:21979520,21967265:21987569,21967267:21987860,21972738:21975495,21975411:21990020,21975413:21979028,21975414:21975795,21980179:21987938,21985604:21985980,21996082:21996571,21998719:21999343,22009703:22017040,22009708:22015179,22009721:22018824,22015078:22015558,22023102:22023197,22027663:22054393,22028201:22028392,22028579:22028736,22029158:22029366,22031255:22032121,22033902:22054020,22033904:22034312,22037011:22053824,22037027:22037602,22040165:22040737,22042111:22042535,22045129:22050611,22045137:22045684,22048331:22049558,22054309:22056615,22062302:22080958,22062304:22070696,22062332:22066558,22067331:22067782,22068081:22068407,22076628:22076690,22078115:22078518,22081249:22081712,22099990:22101183,22109361:22111066,22121606:22122450,22121613:22122021,22125164:2212525', 'assoc_mat': '21936864:pehd:4213:21944042,21936865:pehd:4213:21942285,21936890:pehd:4213:21937819,21936891:pehd:4213:21942708,21938118:pehd:4213:21939177,21944347:pehd:4213:21944460,21944620:pehd:4213:21944824,21948383:pehd:4213:21948683,21951418:pehd:4213:21951658,21956389:pehd:4213:21956637,21962610:pehd:4213:21962714,21963434:pehd:4213:21963648,21967261:pehd:4213:21979276,21967262:pehd:4213:21979520,21967265:pehd:4213:21987569,21967267:pehd:4213:21987860,21972738:pehd:4213:21975495,21975411:pehd:4213:21990020,21975413:pehd:4213:21979028,21975414:pehd:4213:21975795,21980179:pehd:4213:21987938,21985604:pehd:4213:21985980,21996082:pehd:4213:21996571,21998719:pehd:4213:21999343,22009703:pehd:4213:22017040,22009708:pehd:4213:22015179,22009721:pehd:4213:22018824,22015078:pehd:4213:22015558,22023102:pehd:4213:22023197,22027663:pehd:4213:22054393,22028201:pehd:4213:22028392,22028579:pehd:4213:22028736,22029158:pehd:4213:22029366,22031255:pehd:4213:22032121,22033902:pehd:4213:22054020,22033904:pehd:4213:22034312,22037011:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.019543802319342298, 'nb_photo': 10053, 'list_port_cont': '21937820,21939161,21939748,21941791,21942280,21942542,21942704,21943650,21944048,21944455,21944821,21944862,21944900,21948131,21948688,21951650,21954464,21954501,21956216,21956632,21958499,21960320,21962725,21963649,21967987,21969911,21973612,21975491,21975786,21977001,21979025,21979278,21979529,21979652,21983675,21985970,21987575,21987719,21987868,21987934,21988188,21990021,21991771,21992352,21996576,21999335,22010222,22011233,22012685,22014633,22015192,22015564,22017044,22017720,22018829,22019751,22020327,22023193,22023577,22025977,22026098,22026467,22026706,22028389,22028728,22028809,22029231,22029373,22032122,22034306,22037593,22040751,22042532,22045688,22049562,22049897,22050615,22052429,22052790,22053828,22054023,22054388,22056626,22057273,22063993,22065174,22066556,22067785,22068409,22068570,22070692,22072123,22072553,22076249,22076687,22078514,22080969,22081703,22086855,22088441,22091684,22097064,22101170,22101846,22106605,22109807,22111063,22121891,22122022,22122456,22122487,22122516,22122678,2212308', 'assoc_port': '21936862:21944862,21936863:21944900,21936864:21944048,21936865:21942280,21936890:21937820,21936891:21942704,21938118:21939161,21939370:21939748,21941592:21941791,21942442:21942542,21943568:21943650,21944347:21944455,21944620:21944821,21947409:21948131,21947410:21956216,21948383:21948688,21951418:21951650,21954280:21954501,21954281:21954464,21956389:21956632,21958293:21958499,21960222:21960320,21962610:21962725,21963434:21963649,21967261:21979278,21967262:21979529,21967263:21967987,21967264:21979652,21967265:21987575,21967266:21987719,21967267:21987868,21969569:21969911,21972738:21975491,21972739:21973612,21975410:21991771,21975411:21990021,21975412:21977001,21975413:21979025,21975414:21975786,21980179:21987934,21982976:21983675,21985604:21985970,21987906:21988188,21991685:21992352,21996082:21996576,21998719:21999335,22009703:22017044,22009706:22019751,22009708:22015192,22009713:22011233,22009717:22014633,22009719:22010222,22009721:22018829,22012335:22012685,22015078:22015564,22017423:22017720,22019959:2202032', 'assoc_mat': '21936862:pet_clair:4213:21944862,21936863:pet_clair:4213:21944900,21936864:pet_clair:4213:21944048,21936865:pet_clair:4213:21942280,21936890:pet_clair:4213:21937820,21936891:pet_clair:4213:21942704,21938118:pet_clair:4213:21939161,21939370:pet_clair:4213:21939748,21941592:pet_clair:4213:21941791,21942442:pet_clair:4213:21942542,21943568:pet_clair:4213:21943650,21944347:pet_clair:4213:21944455,21944620:pet_clair:4213:21944821,21947409:pet_clair:4213:21948131,21947410:pet_clair:4213:21956216,21948383:pet_clair:4213:21948688,21951418:pet_clair:4213:21951650,21954280:pet_clair:4213:21954501,21954281:pet_clair:4213:21954464,21956389:pet_clair:4213:21956632,21958293:pet_clair:4213:21958499,21960222:pet_clair:4213:21960320,21962610:pet_clair:4213:21962725,21963434:pet_clair:4213:21963649,21967261:pet_clair:4213:21979278,21967262:pet_clair:4213:21979529,21967263:pet_clair:4213:21967987,21967264:pet_clair:4213:21979652,21967265:pet_clair:4213:21987575,21967266:pet_clair:4213:21987719,21967267:pet_clair:4213:21987868,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.00037107035335104985, 'nb_photo': 128, 'list_port_cont': '21941793,21942281,21942540,21954471,21954510,21956214,21962722,21963636,21967998,21973602,21975493,21975791,21979277,21979531,21987874,21996562,22020330,22026469,22028388,22028807,22029367,22034318,22037601,22067784,22068405,22080962,22081715,22086852,22101179,22132023,22147355,22150432,22163127,22163225,22176312,22176650,22181021,22189818,22210779,22244258,22245422,22245833,22249994,22250620,22250988,22251217,22251276,22252874,22255705,22258201,22269147,22269658,22269694,22269840,22269911,22271261,22288754,22289045,22289356,22297161,22312507,22324492,22330482,22331005,22343320,22372681,22379142,22393337,22422154,22425191,22428641,22430914,22454441,22455734,22462543,22463136,22477741,22487883,22492876,22496093,22513527,22525115,22532602,22536425,22537955,22543198,22549619,22552299,22561904,22563289,22568929,22575376', 'assoc_port': '21936865:21942281,21941592:21941793,21942442:21942540,21947410:21956214,21954280:21954510,21954281:21954471,21962610:21962722,21963434:21963636,21967261:21979277,21967262:21979531,21967263:21967998,21967267:21987874,21972738:21975493,21972739:21973602,21975414:21975791,21996082:21996562,22019959:22020330,22026343:22026469,22028201:22028388,22028577:22028807,22029158:22029367,22033904:22034318,22037027:22037601,22062302:22080962,22067331:22067784,22068081:22068405,22081249:22081715,22086128:22086852,22099990:22101179,22131689:22132023,22146589:22147355,22148725:22150432,22162864:22163127,22162865:22163225,22174349:22176650,22175881:22176312,22180112:22181021,22189332:22189818,22210237:22210779,22242953:22245833,22242954:22250988,22244167:22244258,22245281:22245422,22249280:22249994,22250548:22250620,22251175:22251217,22251176:22251276,22252720:22252874,22255555:22255705,22258026:22258201,22269045:22269840,22269050:22269911,22269051:22269658,22269052:22269694,22269065:22269147,22271182:22271261,22286576:2228875', 'assoc_mat': '21936865:pet_fonce:4213:21942281,21941592:pet_fonce:4213:21941793,21942442:pet_fonce:4213:21942540,21947410:pet_fonce:4213:21956214,21954280:pet_fonce:4213:21954510,21954281:pet_fonce:4213:21954471,21962610:pet_fonce:4213:21962722,21963434:pet_fonce:4213:21963636,21967261:pet_fonce:4213:21979277,21967262:pet_fonce:4213:21979531,21967263:pet_fonce:4213:21967998,21967267:pet_fonce:4213:21987874,21972738:pet_fonce:4213:21975493,21972739:pet_fonce:4213:21973602,21975414:pet_fonce:4213:21975791,21996082:pet_fonce:4213:21996562,22019959:pet_fonce:4213:22020330,22026343:pet_fonce:4213:22026469,22028201:pet_fonce:4213:22028388,22028577:pet_fonce:4213:22028807,22029158:pet_fonce:4213:22029367,22033904:pet_fonce:4213:22034318,22037027:pet_fonce:4213:22037601,22062302:pet_fonce:4213:22080962,22067331:pet_fonce:4213:22067784,22068081:pet_fonce:4213:22068405,22081249:pet_fonce:4213:22081715,22086128:pet_fonce:4213:22086852,22099990:pet_fonce:4213:22101179,22131689:pet_fonce:4213:22132023,22146589:pet_fonce:4213:22147355,2'}, {'unwanted_material': 'pet_opaque', 'main_material': 'refus', 'pht_type': 4213, 'ratio': 0.010509359292383195, 'nb_photo': 4176, 'list_port_cont': '21937824,21939173,21939741,21941801,21942287,21942536,21942709,21943654,21944054,21944465,21944826,21944860,21944902,21948127,21948692,21951659,21954465,21954504,21956206,21956630,21958508,21960315,21962721,21963638,21967991,21969907,21973611,21975503,21975797,21977002,21979015,21979283,21979530,21979656,21983689,21985971,21987564,21987728,21987863,21987937,21988181,21990015,21991761,21992343,21996578,21999345,22010234,22011236,22012688,22014635,22015187,22015548,22017031,22017728,22018820,22019741,22020323,22023190,22023568,22025982,22026097,22026475,22026714,22028383,22028735,22028806,22029235,22029380,22032120,22034305,22037596,22040741,22042544,22045683,22049559,22049894,22050619,22052438,22052791,22053823,22054031,22054392,22056614,22057274,22064002,22065168,22066564,22067779,22068398,22068571,22070700,22072124,22072554,22076259,22076691,22078519,22080956,22081711,22086851,22088450,22091696,22097068,22101181,22101842,22106595,22109810,22111060,22121898,22122032,22122451,22122484,22122519,22122670,2212308', 'assoc_port': '21936862:21944860,21936863:21944902,21936864:21944054,21936865:21942287,21936890:21937824,21936891:21942709,21938118:21939173,21939370:21939741,21941592:21941801,21942442:21942536,21943568:21943654,21944347:21944465,21944620:21944826,21947409:21948127,21947410:21956206,21948383:21948692,21951418:21951659,21954280:21954504,21954281:21954465,21956389:21956630,21958293:21958508,21960222:21960315,21962610:21962721,21963434:21963638,21967261:21979283,21967262:21979530,21967263:21967991,21967264:21979656,21967265:21987564,21967266:21987728,21967267:21987863,21969569:21969907,21972738:21975503,21972739:21973611,21975410:21991761,21975411:21990015,21975412:21977002,21975413:21979015,21975414:21975797,21980179:21987937,21982976:21983689,21985604:21985971,21987906:21988181,21991685:21992343,21996082:21996578,21998719:21999345,22009703:22017031,22009706:22019741,22009708:22015187,22009713:22011236,22009717:22014635,22009719:22010234,22009721:22018820,22012335:22012688,22015078:22015548,22017423:22017728,22019959:2202032', 'assoc_mat': '21936862:pet_opaque:4213:21944860,21936863:pet_opaque:4213:21944902,21936864:pet_opaque:4213:21944054,21936865:pet_opaque:4213:21942287,21936890:pet_opaque:4213:21937824,21936891:pet_opaque:4213:21942709,21938118:pet_opaque:4213:21939173,21939370:pet_opaque:4213:21939741,21941592:pet_opaque:4213:21941801,21942442:pet_opaque:4213:21942536,21943568:pet_opaque:4213:21943654,21944347:pet_opaque:4213:21944465,21944620:pet_opaque:4213:21944826,21947409:pet_opaque:4213:21948127,21947410:pet_opaque:4213:21956206,21948383:pet_opaque:4213:21948692,21951418:pet_opaque:4213:21951659,21954280:pet_opaque:4213:21954504,21954281:pet_opaque:4213:21954465,21956389:pet_opaque:4213:21956630,21958293:pet_opaque:4213:21958508,21960222:pet_opaque:4213:21960315,21962610:pet_opaque:4213:21962721,21963434:pet_opaque:4213:21963638,21967261:pet_opaque:4213:21979283,21967262:pet_opaque:4213:21979530,21967263:pet_opaque:4213:21967991,21967264:pet_opaque:4213:21979656,21967265:pet_opaque:4213:21987564,21967266:pet_opaque:4213:21987728,2196'}), 'main_stat': {'nb_photos': 10289}}, 'hostname': (('raspi-92',),), 'impurety_average_per_hashtag': [(('refus', '2025-04', 0.10545454222745454),)]} filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_04_annee_2025.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 ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'refus': {'barquette_opaque': ['barquette_opaque', '0.41%', 2246], 'carton': ['carton', '0.25%', 2501], 'ela': ['ela', '0.44%', 813], 'etiquette': ['etiquette', '0.3%', 3002], 'film_plastique': ['film_plastique', '3.27%', 7891], 'kraft': ['kraft', '0.07%', 23], 'metal': ['metal', '0.43%', 5133], 'papier': ['papier', '3.33%', 13766], 'pehd': ['pehd', '0.41%', 280], 'pet_clair': ['pet_clair', '1.95%', 10053], 'pet_fonce': ['pet_fonce', '0.04%', 128], 'pet_opaque': ['pet_opaque', '1.05%', 4176]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/refus_amiens/sla_mensuel_refus_amiens_mois_04_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/refus_amiens 3.05user 2.49system 0:09.63elapsed 57%CPU (0avgtext+0avgdata 192320maxresident)k 16664inputs+504outputs (0major+86103minor)pagefaults 0swaps