python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-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 : (2, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 ! 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (2, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 ! 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 04 mtr_id : dashboard_places : SCCU_cam7 date : 2026-04 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-04%') and created_at like '%2026-04%'))); nb_day : (2, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 04 and year(ded.date) = 2026 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), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 04 and year(ded.date) = 2026 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 = 204 and mp.name like '%042026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-04-01 : dt_date_just_month_year : 2026-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= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-04-01" AND ded.date <= "2026-04-30" 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 (2972768,2973447,2974047,2974640,2975091,2975658,2976331,2976991,2977609,2977790,2978182,2978632,2979208,2979814,2980466,2981076,2981306,2981512,2982016,2982466,2982872,2983334,2983884,2984364,2984778,2984976) 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': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013792769840264271, 'nb_photo': 14975, 'list_port_cont': '30919042,30919127,30919162,30919275,30919343,30919372,30919459,30919499,30919559,30919599,30919711,30919794,30919871,30919936,30920010,30920084,30920159,30920230,30920302,30920350,30920463,30920557,30920644,30920762,30923797,30924746,30924782,30924806,30924853,30924878,30924921,30924953,30924991,30925033,30925138,30925221,30925298,30925337,30925447,30925518,30925602,30925638,30925744,30925787,30925858,30926260,30926686,30927157,30929314,30931025,30931060,30931088,30931123,30931163,30931208,30931243,30931273,30931308,30931355,30931397,30931434,30931460,30931498,30931544,30931570,30931605,30931650,30931691,30931725,30931800,30932082,30932154,30932275,30932321,30932390,30932454,30932539,30932856,30932980,30933008,30933058,30933196,30933364,30933663,30933699,30933737,30933896,30934057,30934122,30934265,30934427,30934595,30934683,30934786,30935784,30935854,30940054,30940127,30940163,30940232,30940317,30940384,30940462,30940528,30940603,30940732,30940760,30940805,30940910,30940977,30941063,30941134,30941161,3094120', 'assoc_port': '30918211:30919459,30918214:30919042,30918217:30919127,30918220:30919162,30918223:30919275,30918226:30919343,30918229:30919372,30918233:30919499,30918236:30919559,30918239:30919599,30918242:30919711,30918245:30919794,30918248:30919871,30918251:30919936,30918254:30920010,30918256:30920084,30918258:30920159,30918260:30920230,30918262:30920302,30918264:30920350,30918266:30920463,30918268:30920557,30918612:30920644,30918924:30920762,30923700:30923797,30923837:30924746,30923841:30924782,30923844:30924806,30923847:30924853,30923850:30924878,30923853:30924921,30923856:30924953,30923859:30924991,30923862:30925033,30923865:30925602,30923868:30925138,30923871:30925221,30923874:30925298,30923877:30925337,30923880:30925447,30923882:30925518,30923884:30925638,30923886:30925744,30923888:30925787,30923890:30925858,30923892:30926686,30924274:30926260,30924727:30927157,30929229:30929314,30929680:30931025,30929681:30931060,30929682:30931088,30929683:30931123,30929712:30931163,30929722:30932390,30929723:30931208,30929724:3093124', 'assoc_mat': '30918211:autre:4230:30919459,30918214:autre:4230:30919042,30918217:autre:4230:30919127,30918220:autre:4230:30919162,30918223:autre:4230:30919275,30918226:autre:4230:30919343,30918229:autre:4230:30919372,30918233:autre:4230:30919499,30918236:autre:4230:30919559,30918239:autre:4230:30919599,30918242:autre:4230:30919711,30918245:autre:4230:30919794,30918248:autre:4230:30919871,30918251:autre:4230:30919936,30918254:autre:4230:30920010,30918256:autre:4230:30920084,30918258:autre:4230:30920159,30918260:autre:4230:30920230,30918262:autre:4230:30920302,30918264:autre:4230:30920350,30918266:autre:4230:30920463,30918268:autre:4230:30920557,30918612:autre:4230:30920644,30918924:autre:4230:30920762,30923700:autre:4230:30923797,30923837:autre:4230:30924746,30923841:autre:4230:30924782,30923844:autre:4230:30924806,30923847:autre:4230:30924853,30923850:autre:4230:30924878,30923853:autre:4230:30924921,30923856:autre:4230:30924953,30923859:autre:4230:30924991,30923862:autre:4230:30925033,30923865:autre:4230:30925602,30923868:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03407029644841383, 'nb_photo': 69284, 'list_port_cont': '30919046,30919126,30919165,30919270,30919344,30919385,30919461,30919497,30919570,30919610,30919718,30919792,30919869,30919944,30920012,30920094,30920166,30920237,30920315,30920345,30920453,30920569,30920642,30920759,30923798,30924735,30924781,30924816,30924849,30924888,30924924,30924966,30925007,30925042,30925150,30925220,30925304,30925333,30925451,30925530,30925597,30925643,30925749,30925779,30925856,30926270,30926687,30927152,30929312,30931030,30931063,30931101,30931136,30931171,30931205,30931247,30931280,30931325,30931352,30931395,30931430,30931468,30931508,30931543,30931574,30931616,30931654,30931693,30931728,30931808,30932080,30932156,30932273,30932309,30932387,30932462,30932535,30932844,30932972,30933007,30933059,30933205,30933372,30933664,30933702,30933736,30933899,30934063,30934123,30934270,30934438,30934591,30934684,30934798,30935772,30935850,30940061,30940136,30940165,30940244,30940320,30940390,30940469,30940532,30940607,30940731,30940766,30940795,30940901,30940986,30941064,30941136,30941167,3094121', 'assoc_port': '30918211:30919461,30918214:30919046,30918217:30919126,30918220:30919165,30918223:30919270,30918226:30919344,30918229:30919385,30918233:30919497,30918236:30919570,30918239:30919610,30918242:30919718,30918245:30919792,30918248:30919869,30918251:30919944,30918254:30920012,30918256:30920094,30918258:30920166,30918260:30920237,30918262:30920315,30918264:30920345,30918266:30920453,30918268:30920569,30918612:30920642,30918924:30920759,30923700:30923798,30923837:30924735,30923841:30924781,30923844:30924816,30923847:30924849,30923850:30924888,30923853:30924924,30923856:30924966,30923859:30925007,30923862:30925042,30923865:30925597,30923868:30925150,30923871:30925220,30923874:30925304,30923877:30925333,30923880:30925451,30923882:30925530,30923884:30925643,30923886:30925749,30923888:30925779,30923890:30925856,30923892:30926687,30924274:30926270,30924727:30927152,30929229:30929312,30929680:30931030,30929681:30931063,30929682:30931101,30929683:30931136,30929712:30931171,30929722:30932387,30929723:30931205,30929724:3093124', 'assoc_mat': '30918211:carton:4230:30919461,30918214:carton:4230:30919046,30918217:carton:4230:30919126,30918220:carton:4230:30919165,30918223:carton:4230:30919270,30918226:carton:4230:30919344,30918229:carton:4230:30919385,30918233:carton:4230:30919497,30918236:carton:4230:30919570,30918239:carton:4230:30919610,30918242:carton:4230:30919718,30918245:carton:4230:30919792,30918248:carton:4230:30919869,30918251:carton:4230:30919944,30918254:carton:4230:30920012,30918256:carton:4230:30920094,30918258:carton:4230:30920166,30918260:carton:4230:30920237,30918262:carton:4230:30920315,30918264:carton:4230:30920345,30918266:carton:4230:30920453,30918268:carton:4230:30920569,30918612:carton:4230:30920642,30918924:carton:4230:30920759,30923700:carton:4230:30923798,30923837:carton:4230:30924735,30923841:carton:4230:30924781,30923844:carton:4230:30924816,30923847:carton:4230:30924849,30923850:carton:4230:30924888,30923853:carton:4230:30924924,30923856:carton:4230:30924966,30923859:carton:4230:30925007,30923862:carton:4230:30925042,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011913206017685972, 'nb_photo': 1470, 'list_port_cont': '30919054,30919125,30919157,30919378,30919448,30919491,30919565,30919603,30919715,30919779,30919868,30919945,30920091,30920165,30920303,30920338,30920565,30920646,30920753,30923785,30924740,30924772,30924811,30924854,30924889,30924961,30924994,30925037,30925141,30925230,30925302,30925338,30925453,30925532,30925600,30925640,30925742,30925776,30925851,30926262,30926681,30927149,30929323,30931021,30931058,30931099,30931128,30931159,30931204,30931239,30931277,30931317,30931362,30931423,30931461,30931511,30931532,30931575,30931608,30931657,30931692,30931724,30931792,30932065,30932144,30932277,30932319,30932381,30932464,30932544,30932981,30933013,30933067,30933190,30933366,30933661,30933688,30933731,30933895,30934062,30934111,30934256,30934429,30934600,30934671,30934783,30935777,30935844,30940057,30940123,30940168,30940319,30940393,30940465,30940531,30940610,30940726,30940756,30940799,30940899,30940974,30941061,30941251,30941275,30941309,30941386,30945237,30945389,30945464,30945675,30945749,30945821,30945937,3094597', 'assoc_port': '30918211:30919448,30918214:30919054,30918217:30919125,30918220:30919157,30918229:30919378,30918233:30919491,30918236:30919565,30918239:30919603,30918242:30919715,30918245:30919779,30918248:30919868,30918251:30919945,30918256:30920091,30918258:30920165,30918262:30920303,30918264:30920338,30918268:30920565,30918612:30920646,30918924:30920753,30923700:30923785,30923837:30924740,30923841:30924772,30923844:30924811,30923847:30924854,30923850:30924889,30923856:30924961,30923859:30924994,30923862:30925037,30923865:30925600,30923868:30925141,30923871:30925230,30923874:30925302,30923877:30925338,30923880:30925453,30923882:30925532,30923884:30925640,30923886:30925742,30923888:30925776,30923890:30925851,30923892:30926681,30924274:30926262,30924727:30927149,30929229:30929323,30929680:30931021,30929681:30931058,30929682:30931099,30929683:30931128,30929712:30931159,30929722:30932381,30929723:30931204,30929724:30931239,30929725:30931277,30929726:30931317,30929727:30931362,30929729:30931423,30929730:30931461,30929731:3093151', 'assoc_mat': '30918211:metal:4230:30919448,30918214:metal:4230:30919054,30918217:metal:4230:30919125,30918220:metal:4230:30919157,30918229:metal:4230:30919378,30918233:metal:4230:30919491,30918236:metal:4230:30919565,30918239:metal:4230:30919603,30918242:metal:4230:30919715,30918245:metal:4230:30919779,30918248:metal:4230:30919868,30918251:metal:4230:30919945,30918256:metal:4230:30920091,30918258:metal:4230:30920165,30918262:metal:4230:30920303,30918264:metal:4230:30920338,30918268:metal:4230:30920565,30918612:metal:4230:30920646,30918924:metal:4230:30920753,30923700:metal:4230:30923785,30923837:metal:4230:30924740,30923841:metal:4230:30924772,30923844:metal:4230:30924811,30923847:metal:4230:30924854,30923850:metal:4230:30924889,30923856:metal:4230:30924961,30923859:metal:4230:30924994,30923862:metal:4230:30925037,30923865:metal:4230:30925600,30923868:metal:4230:30925141,30923871:metal:4230:30925230,30923874:metal:4230:30925302,30923877:metal:4230:30925338,30923880:metal:4230:30925453,30923882:metal:4230:30925532,30923884:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16261482236176186, 'nb_photo': 244667, 'list_port_cont': '30919050,30919129,30919158,30919272,30919341,30919383,30919457,30919496,30919575,30919602,30919710,30919793,30919864,30919933,30920018,30920092,30920160,30920235,30920314,30920346,30920458,30920571,30920637,30920755,30923793,30924738,30924783,30924822,30924856,30924882,30924923,30924958,30925003,30925036,30925153,30925232,30925305,30925336,30925443,30925528,30925601,30925636,30925745,30925778,30925859,30926259,30926690,30927146,30929327,30931024,30931053,30931095,30931134,30931168,30931215,30931238,30931288,30931322,30931360,30931400,30931429,30931459,30931503,30931549,30931573,30931613,30931653,30931690,30931731,30931805,30932073,30932151,30932278,30932312,30932392,30932467,30932543,30932855,30932975,30933009,30933070,30933204,30933365,30933652,30933695,30933733,30933897,30934070,30934124,30934260,30934430,30934593,30934686,30934796,30935780,30935857,30940059,30940132,30940164,30940243,30940311,30940392,30940458,30940543,30940609,30940727,30940768,30940802,30940913,30940987,30941066,30941142,30941174,3094120', 'assoc_port': '30918211:30919457,30918214:30919050,30918217:30919129,30918220:30919158,30918223:30919272,30918226:30919341,30918229:30919383,30918233:30919496,30918236:30919575,30918239:30919602,30918242:30919710,30918245:30919793,30918248:30919864,30918251:30919933,30918254:30920018,30918256:30920092,30918258:30920160,30918260:30920235,30918262:30920314,30918264:30920346,30918266:30920458,30918268:30920571,30918612:30920637,30918924:30920755,30923700:30923793,30923837:30924738,30923841:30924783,30923844:30924822,30923847:30924856,30923850:30924882,30923853:30924923,30923856:30924958,30923859:30925003,30923862:30925036,30923865:30925601,30923868:30925153,30923871:30925232,30923874:30925305,30923877:30925336,30923880:30925443,30923882:30925528,30923884:30925636,30923886:30925745,30923888:30925778,30923890:30925859,30923892:30926690,30924274:30926259,30924727:30927146,30929229:30929327,30929680:30931024,30929681:30931053,30929682:30931095,30929683:30931134,30929712:30931168,30929722:30932392,30929723:30931215,30929724:3093123', 'assoc_mat': '30918211:papier:4230:30919457,30918214:papier:4230:30919050,30918217:papier:4230:30919129,30918220:papier:4230:30919158,30918223:papier:4230:30919272,30918226:papier:4230:30919341,30918229:papier:4230:30919383,30918233:papier:4230:30919496,30918236:papier:4230:30919575,30918239:papier:4230:30919602,30918242:papier:4230:30919710,30918245:papier:4230:30919793,30918248:papier:4230:30919864,30918251:papier:4230:30919933,30918254:papier:4230:30920018,30918256:papier:4230:30920092,30918258:papier:4230:30920160,30918260:papier:4230:30920235,30918262:papier:4230:30920314,30918264:papier:4230:30920346,30918266:papier:4230:30920458,30918268:papier:4230:30920571,30918612:papier:4230:30920637,30918924:papier:4230:30920755,30923700:papier:4230:30923793,30923837:papier:4230:30924738,30923841:papier:4230:30924783,30923844:papier:4230:30924822,30923847:papier:4230:30924856,30923850:papier:4230:30924882,30923853:papier:4230:30924923,30923856:papier:4230:30924958,30923859:papier:4230:30925003,30923862:papier:4230:30925036,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026982780040502264, 'nb_photo': 1030, 'list_port_cont': '30919048,30919120,30919163,30919340,30919388,30919573,30919607,30919709,30919791,30919862,30919934,30920014,30920087,30920239,30920352,30920461,30920572,30920643,30923799,30924737,30924787,30924823,30924932,30924967,30925005,30925043,30925152,30925223,30925306,30925335,30925449,30925529,30925599,30925642,30925748,30925785,30925861,30926257,30926688,30927159,30931027,30931054,30931175,30931213,30931249,30931284,30931316,30931469,30931504,30931548,30931615,30931723,30932386,30932465,30932545,30932979,30933010,30933064,30933201,30933357,30933662,30933694,30933734,30933900,30934065,30934262,30934433,30934597,30934685,30934797,30940170,30940239,30940389,30940464,30940537,30940618,30940793,30940912,30940989,30941288,30941324,30945612,30945688,30945755,30945833,30945941,30945977,30946580,30950648,30951162,30951509,30951576,30951690,30951728,30951804,30951878,30951948,30952020,30952098,30953195,30955329,30956504,30956540,30956577,30956612,30956652,30956685,30956763,30956837,30956878,30956949,30957026,30957102,3095724', 'assoc_port': '30918214:30919048,30918217:30919120,30918220:30919163,30918226:30919340,30918229:30919388,30918236:30919573,30918239:30919607,30918242:30919709,30918245:30919791,30918248:30919862,30918251:30919934,30918254:30920014,30918256:30920087,30918260:30920239,30918264:30920352,30918266:30920461,30918268:30920572,30918612:30920643,30923700:30923799,30923837:30924737,30923841:30924787,30923844:30924823,30923853:30924932,30923856:30924967,30923859:30925005,30923862:30925043,30923865:30925599,30923868:30925152,30923871:30925223,30923874:30925306,30923877:30925335,30923880:30925449,30923882:30925529,30923884:30925642,30923886:30925748,30923888:30925785,30923890:30925861,30923892:30926688,30924274:30926257,30924727:30927159,30929680:30931027,30929681:30931054,30929712:30931175,30929722:30932386,30929723:30931213,30929724:30931249,30929725:30931284,30929726:30931316,30929730:30931469,30929731:30931504,30929732:30932545,30929733:30931548,30929735:30931615,30929738:30931723,30932024:30932465,30932883:30933010,30932884:3093297', 'assoc_mat': '30918214:pehd:4230:30919048,30918217:pehd:4230:30919120,30918220:pehd:4230:30919163,30918226:pehd:4230:30919340,30918229:pehd:4230:30919388,30918236:pehd:4230:30919573,30918239:pehd:4230:30919607,30918242:pehd:4230:30919709,30918245:pehd:4230:30919791,30918248:pehd:4230:30919862,30918251:pehd:4230:30919934,30918254:pehd:4230:30920014,30918256:pehd:4230:30920087,30918260:pehd:4230:30920239,30918264:pehd:4230:30920352,30918266:pehd:4230:30920461,30918268:pehd:4230:30920572,30918612:pehd:4230:30920643,30923700:pehd:4230:30923799,30923837:pehd:4230:30924737,30923841:pehd:4230:30924787,30923844:pehd:4230:30924823,30923853:pehd:4230:30924932,30923856:pehd:4230:30924967,30923859:pehd:4230:30925005,30923862:pehd:4230:30925043,30923865:pehd:4230:30925599,30923868:pehd:4230:30925152,30923871:pehd:4230:30925223,30923874:pehd:4230:30925306,30923877:pehd:4230:30925335,30923880:pehd:4230:30925449,30923882:pehd:4230:30925529,30923884:pehd:4230:30925642,30923886:pehd:4230:30925748,30923888:pehd:4230:30925785,30923890:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.026421274448888823, 'nb_photo': 23923, 'list_port_cont': '30919051,30919116,30919159,30919271,30919342,30919386,30919463,30919485,30919571,30919609,30919717,30919786,30919863,30919939,30920019,30920080,30920161,30920234,30920312,30920348,30920450,30920561,30920647,30920766,30923792,30924741,30924786,30924812,30924852,30924885,30924929,30924963,30924998,30925044,30925149,30925229,30925299,30925342,30925442,30925527,30925603,30925632,30925751,30925788,30925853,30926265,30926689,30927154,30929320,30931020,30931061,30931103,30931139,30931176,30931202,30931237,30931282,30931315,30931357,30931394,30931433,30931473,30931509,30931542,30931582,30931621,30931651,30931684,30931729,30931798,30932071,30932142,30932282,30932318,30932393,30932469,30932531,30932846,30932971,30933018,30933069,30933197,30933362,30933655,30933696,30933738,30933905,30934069,30934116,30934269,30934436,30934594,30934674,30934787,30935783,30935855,30940055,30940126,30940161,30940236,30940318,30940391,30940455,30940529,30940617,30940730,30940765,30940807,30940907,30940985,30941065,30941133,30941169,3094121', 'assoc_port': '30918211:30919463,30918214:30919051,30918217:30919116,30918220:30919159,30918223:30919271,30918226:30919342,30918229:30919386,30918233:30919485,30918236:30919571,30918239:30919609,30918242:30919717,30918245:30919786,30918248:30919863,30918251:30919939,30918254:30920019,30918256:30920080,30918258:30920161,30918260:30920234,30918262:30920312,30918264:30920348,30918266:30920450,30918268:30920561,30918612:30920647,30918924:30920766,30923700:30923792,30923837:30924741,30923841:30924786,30923844:30924812,30923847:30924852,30923850:30924885,30923853:30924929,30923856:30924963,30923859:30924998,30923862:30925044,30923865:30925603,30923868:30925149,30923871:30925229,30923874:30925299,30923877:30925342,30923880:30925442,30923882:30925527,30923884:30925632,30923886:30925751,30923888:30925788,30923890:30925853,30923892:30926689,30924274:30926265,30924727:30927154,30929229:30929320,30929680:30931020,30929681:30931061,30929682:30931103,30929683:30931139,30929712:30931176,30929722:30932393,30929723:30931202,30929724:3093123', 'assoc_mat': '30918211:pet_clair:4230:30919463,30918214:pet_clair:4230:30919051,30918217:pet_clair:4230:30919116,30918220:pet_clair:4230:30919159,30918223:pet_clair:4230:30919271,30918226:pet_clair:4230:30919342,30918229:pet_clair:4230:30919386,30918233:pet_clair:4230:30919485,30918236:pet_clair:4230:30919571,30918239:pet_clair:4230:30919609,30918242:pet_clair:4230:30919717,30918245:pet_clair:4230:30919786,30918248:pet_clair:4230:30919863,30918251:pet_clair:4230:30919939,30918254:pet_clair:4230:30920019,30918256:pet_clair:4230:30920080,30918258:pet_clair:4230:30920161,30918260:pet_clair:4230:30920234,30918262:pet_clair:4230:30920312,30918264:pet_clair:4230:30920348,30918266:pet_clair:4230:30920450,30918268:pet_clair:4230:30920561,30918612:pet_clair:4230:30920647,30918924:pet_clair:4230:30920766,30923700:pet_clair:4230:30923792,30923837:pet_clair:4230:30924741,30923841:pet_clair:4230:30924786,30923844:pet_clair:4230:30924812,30923847:pet_clair:4230:30924852,30923850:pet_clair:4230:30924885,30923853:pet_clair:4230:30924929,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002480788517217438, 'nb_photo': 606, 'list_port_cont': '30919049,30919122,30919276,30919350,30919572,30919604,30919721,30919789,30919940,30920017,30920088,30920241,30920351,30920573,30923794,30924745,30924785,30924850,30924894,30925032,30925151,30925226,30925300,30925343,30925445,30925523,30925605,30925635,30925741,30925783,30926269,30926691,30927155,30931023,30931097,30931173,30931285,30931583,30931617,30931730,30931806,30932143,30932391,30932466,30932974,30933062,30933369,30933665,30933698,30933735,30933893,30934058,30934119,30934598,30934676,30935858,30940733,30940753,30940988,30941137,30941250,30941282,30941322,30941461,30941543,30945246,30945539,30945760,30945837,30945946,30945981,30946203,30946462,30946541,30946577,30951005,30951092,30951169,30951240,30951312,30951430,30951694,30951723,30951797,30951871,30951955,30952140,30953184,30955335,30956395,30956536,30956575,30956688,30956759,30956840,30956868,30956945,30957018,30957105,30957166,30957243,30957312,30957880,30960868,30961829,30961869,30961900,30961940,30962015,30962052,30962092,30962128,30962319,3096238', 'assoc_port': '30918214:30919049,30918217:30919122,30918223:30919276,30918226:30919350,30918236:30919572,30918239:30919604,30918242:30919721,30918245:30919789,30918251:30919940,30918254:30920017,30918256:30920088,30918260:30920241,30918264:30920351,30918268:30920573,30923700:30923794,30923837:30924745,30923841:30924785,30923847:30924850,30923850:30924894,30923862:30925032,30923865:30925605,30923868:30925151,30923871:30925226,30923874:30925300,30923877:30925343,30923880:30925445,30923882:30925523,30923884:30925635,30923886:30925741,30923888:30925783,30923892:30926691,30924274:30926269,30924727:30927155,30929680:30931023,30929682:30931097,30929712:30931173,30929722:30932391,30929725:30931285,30929734:30931583,30929735:30931617,30929738:30931730,30930077:30931806,30930973:30932143,30932024:30932466,30932884:30932974,30933048:30933062,30933313:30933369,30933562:30933665,30933563:30933698,30933564:30933735,30933840:30933893,30933973:30934058,30934103:30934119,30934502:30934598,30934627:30934676,30935433:30935858,30938959:3094073', 'assoc_mat': '30918214:pet_fonce:4230:30919049,30918217:pet_fonce:4230:30919122,30918223:pet_fonce:4230:30919276,30918226:pet_fonce:4230:30919350,30918236:pet_fonce:4230:30919572,30918239:pet_fonce:4230:30919604,30918242:pet_fonce:4230:30919721,30918245:pet_fonce:4230:30919789,30918251:pet_fonce:4230:30919940,30918254:pet_fonce:4230:30920017,30918256:pet_fonce:4230:30920088,30918260:pet_fonce:4230:30920241,30918264:pet_fonce:4230:30920351,30918268:pet_fonce:4230:30920573,30923700:pet_fonce:4230:30923794,30923837:pet_fonce:4230:30924745,30923841:pet_fonce:4230:30924785,30923847:pet_fonce:4230:30924850,30923850:pet_fonce:4230:30924894,30923862:pet_fonce:4230:30925032,30923865:pet_fonce:4230:30925605,30923868:pet_fonce:4230:30925151,30923871:pet_fonce:4230:30925226,30923874:pet_fonce:4230:30925300,30923877:pet_fonce:4230:30925343,30923880:pet_fonce:4230:30925445,30923882:pet_fonce:4230:30925523,30923884:pet_fonce:4230:30925635,30923886:pet_fonce:4230:30925741,30923888:pet_fonce:4230:30925783,30923892:pet_fonce:4230:30926691,3'}) 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(2972768,2973447,2974047,2974640,2975091,2975658,2976331,2976991,2977609,2977790,2978182,2978632,2979208,2979814,2980466,2981076,2981306,2981512,2982016,2982466,2982872,2983334,2983884,2984364,2984778,2984976)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998214, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919042,30919127,30919162,30919275,30919343,30919372,30919459,30919499,30919559,30919599,30919711,30919794,30919871,30919936,30920010,30920084,30920159,30920230,30920302,30920350,30920463,30920557,30920644,30920762,30923797,30924746,30924782,30924806,30924853,30924878,30924921,30924953,30924991,30925033,30925138,30925221,30925298,30925337,30925447,30925518,30925602,30925638,30925744,30925787,30925858,30926260,30926686,30927157,30929314,30931025,30931060,30931088,30931123,30931163,30931208,30931243,30931273,30931308,30931355,30931397,30931434,30931460,30931498,30931544,30931570,30931605,30931650,30931691,30931725,30931800,30932082,30932154,30932275,30932321,30932390,30932454,30932539,30932856,30932980,30933008,30933058,30933196,30933364,30933663,30933699,30933737,30933896,30934057,30934122,30934265,30934427,30934595,30934683,30934786,30935784,30935854,30940054,30940127,30940163,30940232,30940317,30940384,30940462,30940528,30940603,30940732,30940760,30940805,30940910,30940977,30941063,30941134,30941161,3094120 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998215, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919046,30919126,30919165,30919270,30919344,30919385,30919461,30919497,30919570,30919610,30919718,30919792,30919869,30919944,30920012,30920094,30920166,30920237,30920315,30920345,30920453,30920569,30920642,30920759,30923798,30924735,30924781,30924816,30924849,30924888,30924924,30924966,30925007,30925042,30925150,30925220,30925304,30925333,30925451,30925530,30925597,30925643,30925749,30925779,30925856,30926270,30926687,30927152,30929312,30931030,30931063,30931101,30931136,30931171,30931205,30931247,30931280,30931325,30931352,30931395,30931430,30931468,30931508,30931543,30931574,30931616,30931654,30931693,30931728,30931808,30932080,30932156,30932273,30932309,30932387,30932462,30932535,30932844,30932972,30933007,30933059,30933205,30933372,30933664,30933702,30933736,30933899,30934063,30934123,30934270,30934438,30934591,30934684,30934798,30935772,30935850,30940061,30940136,30940165,30940244,30940320,30940390,30940469,30940532,30940607,30940731,30940766,30940795,30940901,30940986,30941064,30941136,30941167,3094121 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998216, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919054,30919125,30919157,30919378,30919448,30919491,30919565,30919603,30919715,30919779,30919868,30919945,30920091,30920165,30920303,30920338,30920565,30920646,30920753,30923785,30924740,30924772,30924811,30924854,30924889,30924961,30924994,30925037,30925141,30925230,30925302,30925338,30925453,30925532,30925600,30925640,30925742,30925776,30925851,30926262,30926681,30927149,30929323,30931021,30931058,30931099,30931128,30931159,30931204,30931239,30931277,30931317,30931362,30931423,30931461,30931511,30931532,30931575,30931608,30931657,30931692,30931724,30931792,30932065,30932144,30932277,30932319,30932381,30932464,30932544,30932981,30933013,30933067,30933190,30933366,30933661,30933688,30933731,30933895,30934062,30934111,30934256,30934429,30934600,30934671,30934783,30935777,30935844,30940057,30940123,30940168,30940319,30940393,30940465,30940531,30940610,30940726,30940756,30940799,30940899,30940974,30941061,30941251,30941275,30941309,30941386,30945237,30945389,30945464,30945675,30945749,30945821,30945937,3094597 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998217, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919050,30919129,30919158,30919272,30919341,30919383,30919457,30919496,30919575,30919602,30919710,30919793,30919864,30919933,30920018,30920092,30920160,30920235,30920314,30920346,30920458,30920571,30920637,30920755,30923793,30924738,30924783,30924822,30924856,30924882,30924923,30924958,30925003,30925036,30925153,30925232,30925305,30925336,30925443,30925528,30925601,30925636,30925745,30925778,30925859,30926259,30926690,30927146,30929327,30931024,30931053,30931095,30931134,30931168,30931215,30931238,30931288,30931322,30931360,30931400,30931429,30931459,30931503,30931549,30931573,30931613,30931653,30931690,30931731,30931805,30932073,30932151,30932278,30932312,30932392,30932467,30932543,30932855,30932975,30933009,30933070,30933204,30933365,30933652,30933695,30933733,30933897,30934070,30934124,30934260,30934430,30934593,30934686,30934796,30935780,30935857,30940059,30940132,30940164,30940243,30940311,30940392,30940458,30940543,30940609,30940727,30940768,30940802,30940913,30940987,30941066,30941142,30941174,3094120 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998218, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919048,30919120,30919163,30919340,30919388,30919573,30919607,30919709,30919791,30919862,30919934,30920014,30920087,30920239,30920352,30920461,30920572,30920643,30923799,30924737,30924787,30924823,30924932,30924967,30925005,30925043,30925152,30925223,30925306,30925335,30925449,30925529,30925599,30925642,30925748,30925785,30925861,30926257,30926688,30927159,30931027,30931054,30931175,30931213,30931249,30931284,30931316,30931469,30931504,30931548,30931615,30931723,30932386,30932465,30932545,30932979,30933010,30933064,30933201,30933357,30933662,30933694,30933734,30933900,30934065,30934262,30934433,30934597,30934685,30934797,30940170,30940239,30940389,30940464,30940537,30940618,30940793,30940912,30940989,30941288,30941324,30945612,30945688,30945755,30945833,30945941,30945977,30946580,30950648,30951162,30951509,30951576,30951690,30951728,30951804,30951878,30951948,30952020,30952098,30953195,30955329,30956504,30956540,30956577,30956612,30956652,30956685,30956763,30956837,30956878,30956949,30957026,30957102,3095724 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998219, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919051,30919116,30919159,30919271,30919342,30919386,30919463,30919485,30919571,30919609,30919717,30919786,30919863,30919939,30920019,30920080,30920161,30920234,30920312,30920348,30920450,30920561,30920647,30920766,30923792,30924741,30924786,30924812,30924852,30924885,30924929,30924963,30924998,30925044,30925149,30925229,30925299,30925342,30925442,30925527,30925603,30925632,30925751,30925788,30925853,30926265,30926689,30927154,30929320,30931020,30931061,30931103,30931139,30931176,30931202,30931237,30931282,30931315,30931357,30931394,30931433,30931473,30931509,30931542,30931582,30931621,30931651,30931684,30931729,30931798,30932071,30932142,30932282,30932318,30932393,30932469,30932531,30932846,30932971,30933018,30933069,30933197,30933362,30933655,30933696,30933738,30933905,30934069,30934116,30934269,30934436,30934594,30934674,30934787,30935783,30935855,30940055,30940126,30940161,30940236,30940318,30940391,30940455,30940529,30940617,30940730,30940765,30940807,30940907,30940985,30941065,30941133,30941169,3094121 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998220, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919049,30919122,30919276,30919350,30919572,30919604,30919721,30919789,30919940,30920017,30920088,30920241,30920351,30920573,30923794,30924745,30924785,30924850,30924894,30925032,30925151,30925226,30925300,30925343,30925445,30925523,30925605,30925635,30925741,30925783,30926269,30926691,30927155,30931023,30931097,30931173,30931285,30931583,30931617,30931730,30931806,30932143,30932391,30932466,30932974,30933062,30933369,30933665,30933698,30933735,30933893,30934058,30934119,30934598,30934676,30935858,30940733,30940753,30940988,30941137,30941250,30941282,30941322,30941461,30941543,30945246,30945539,30945760,30945837,30945946,30945981,30946203,30946462,30946541,30946577,30951005,30951092,30951169,30951240,30951312,30951430,30951694,30951723,30951797,30951871,30951955,30952140,30953184,30955335,30956395,30956536,30956575,30956688,30956759,30956840,30956868,30956945,30957018,30957105,30957166,30957243,30957312,30957880,30960868,30961829,30961869,30961900,30961940,30962015,30962052,30962092,30962128,30962319,3096238 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30998214,30998215,30998216,30998217,30998218,30998219,30998220?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-04-01' and date <= '2026-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1625,),), 'unwanted_material_monthly_percentage': ((0.7715628405406448,),), 'material_repartition': (('incineration', 1625),), 'material_dict': {'incineration': 1625}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 4, 1), 0.7914413519733902, 2), (datetime.date(2026, 4, 2), 0.7029241475165613, 4), (datetime.date(2026, 4, 3), 0.7440026527670248, 3), (datetime.date(2026, 4, 4), 0.7579980328951105, 3), (datetime.date(2026, 4, 5), 0.810879917125018, 3), (datetime.date(2026, 4, 6), 0.7794338023615961, 2), (datetime.date(2026, 4, 7), 0.7682824856835292, 3), (datetime.date(2026, 4, 8), 0.7595743745612558, 4), (datetime.date(2026, 4, 9), 0.752014731635319, 4), (datetime.date(2026, 4, 10), 0.7745656775708861, 2), (datetime.date(2026, 4, 11), 0.7540917827950835, 2), (datetime.date(2026, 4, 12), 0.8196466143248988, 2), (datetime.date(2026, 4, 13), 0.7979381094309882, 1), (datetime.date(2026, 4, 14), 0.7987344948611049, 2), (datetime.date(2026, 4, 15), 0.7832926080520172, 3), (datetime.date(2026, 4, 16), 0.7555006374981464, 2), (datetime.date(2026, 4, 17), 0.765056353581959, 3), (datetime.date(2026, 4, 18), 0.7971838646920509, 2), (datetime.date(2026, 4, 19), 0.7637793631711637, 1), (datetime.date(2026, 4, 20), 0.7829970128235628, 2), (datetime.date(2026, 4, 21), 0.7826599142677685, 3), (datetime.date(2026, 4, 22), 0.7534531060122457, 3), (datetime.date(2026, 4, 23), 0.7712083766667631, 2), (datetime.date(2026, 4, 24), 0.7642748935164958, 3), (datetime.date(2026, 4, 25), 0.7706774722309959, 2), (datetime.date(2026, 4, 26), 0.7994108454319523, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 4, 1), 0.7914413519733902, 2), (datetime.date(2026, 4, 2), 0.7029241475165613, 4), (datetime.date(2026, 4, 3), 0.7440026527670248, 3), (datetime.date(2026, 4, 4), 0.7579980328951105, 3), (datetime.date(2026, 4, 5), 0.810879917125018, 3), (datetime.date(2026, 4, 6), 0.7794338023615961, 2), (datetime.date(2026, 4, 7), 0.7682824856835292, 3), (datetime.date(2026, 4, 8), 0.7595743745612558, 4), (datetime.date(2026, 4, 9), 0.752014731635319, 4), (datetime.date(2026, 4, 10), 0.7745656775708861, 2), (datetime.date(2026, 4, 11), 0.7540917827950835, 2), (datetime.date(2026, 4, 12), 0.8196466143248988, 2), (datetime.date(2026, 4, 13), 0.7979381094309882, 1), (datetime.date(2026, 4, 14), 0.7987344948611049, 2), (datetime.date(2026, 4, 15), 0.7832926080520172, 3), (datetime.date(2026, 4, 16), 0.7555006374981464, 2), (datetime.date(2026, 4, 17), 0.765056353581959, 3), (datetime.date(2026, 4, 18), 0.7971838646920509, 2), (datetime.date(2026, 4, 19), 0.7637793631711637, 1), (datetime.date(2026, 4, 20), 0.7829970128235628, 2), (datetime.date(2026, 4, 21), 0.7826599142677685, 3), (datetime.date(2026, 4, 22), 0.7534531060122457, 3), (datetime.date(2026, 4, 23), 0.7712083766667631, 2), (datetime.date(2026, 4, 24), 0.7642748935164958, 3), (datetime.date(2026, 4, 25), 0.7706774722309959, 2), (datetime.date(2026, 4, 26), 0.7994108454319523, 2))}, 'quality_array': [['-6.428931187595944', '01042026'], ['-6.639668782583365', '02042026'], ['-6.872311005459129', '03042026'], ['-6.954142228865635', '04042026'], ['-7.3591014609467695', '05042026'], ['-7.144564016010076', '06042026'], ['-6.822517271981807', '07042026'], ['-6.596719491640225', '08042026'], ['-6.840410617574503', '09042026'], ['-7.303121024407601', '10042026'], ['-7.071068739090438', '11042026'], ['-7.199993187272763', '12042026'], ['-6.993927178921982', '13042026'], ['-7.160006432979458', '14042026'], ['-6.947793008275419', '15042026'], ['-6.9294129316664455', '16042026'], ['-6.517939841668576', '17042026'], ['-6.350491608679454', '18042026'], ['-6.768114554182825', '19042026'], ['-6.485276737904907', '20042026'], ['-6.498852420757635', '21042026'], ['-6.502474272881468', '22042026'], ['-6.52593820150952', '23042026'], ['-6.960165816773543', '24042026'], ['-6.775080644215326', '25042026'], ['-6.980274468866018', '26042026']], 'number_of_batch': ((574,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013792769840264271, 'nb_photo': 14975, 'list_port_cont': '30919042,30919127,30919162,30919275,30919343,30919372,30919459,30919499,30919559,30919599,30919711,30919794,30919871,30919936,30920010,30920084,30920159,30920230,30920302,30920350,30920463,30920557,30920644,30920762,30923797,30924746,30924782,30924806,30924853,30924878,30924921,30924953,30924991,30925033,30925138,30925221,30925298,30925337,30925447,30925518,30925602,30925638,30925744,30925787,30925858,30926260,30926686,30927157,30929314,30931025,30931060,30931088,30931123,30931163,30931208,30931243,30931273,30931308,30931355,30931397,30931434,30931460,30931498,30931544,30931570,30931605,30931650,30931691,30931725,30931800,30932082,30932154,30932275,30932321,30932390,30932454,30932539,30932856,30932980,30933008,30933058,30933196,30933364,30933663,30933699,30933737,30933896,30934057,30934122,30934265,30934427,30934595,30934683,30934786,30935784,30935854,30940054,30940127,30940163,30940232,30940317,30940384,30940462,30940528,30940603,30940732,30940760,30940805,30940910,30940977,30941063,30941134,30941161,3094120', 'assoc_port': '30918211:30919459,30918214:30919042,30918217:30919127,30918220:30919162,30918223:30919275,30918226:30919343,30918229:30919372,30918233:30919499,30918236:30919559,30918239:30919599,30918242:30919711,30918245:30919794,30918248:30919871,30918251:30919936,30918254:30920010,30918256:30920084,30918258:30920159,30918260:30920230,30918262:30920302,30918264:30920350,30918266:30920463,30918268:30920557,30918612:30920644,30918924:30920762,30923700:30923797,30923837:30924746,30923841:30924782,30923844:30924806,30923847:30924853,30923850:30924878,30923853:30924921,30923856:30924953,30923859:30924991,30923862:30925033,30923865:30925602,30923868:30925138,30923871:30925221,30923874:30925298,30923877:30925337,30923880:30925447,30923882:30925518,30923884:30925638,30923886:30925744,30923888:30925787,30923890:30925858,30923892:30926686,30924274:30926260,30924727:30927157,30929229:30929314,30929680:30931025,30929681:30931060,30929682:30931088,30929683:30931123,30929712:30931163,30929722:30932390,30929723:30931208,30929724:3093124', 'assoc_mat': '30918211:autre:4230:30919459,30918214:autre:4230:30919042,30918217:autre:4230:30919127,30918220:autre:4230:30919162,30918223:autre:4230:30919275,30918226:autre:4230:30919343,30918229:autre:4230:30919372,30918233:autre:4230:30919499,30918236:autre:4230:30919559,30918239:autre:4230:30919599,30918242:autre:4230:30919711,30918245:autre:4230:30919794,30918248:autre:4230:30919871,30918251:autre:4230:30919936,30918254:autre:4230:30920010,30918256:autre:4230:30920084,30918258:autre:4230:30920159,30918260:autre:4230:30920230,30918262:autre:4230:30920302,30918264:autre:4230:30920350,30918266:autre:4230:30920463,30918268:autre:4230:30920557,30918612:autre:4230:30920644,30918924:autre:4230:30920762,30923700:autre:4230:30923797,30923837:autre:4230:30924746,30923841:autre:4230:30924782,30923844:autre:4230:30924806,30923847:autre:4230:30924853,30923850:autre:4230:30924878,30923853:autre:4230:30924921,30923856:autre:4230:30924953,30923859:autre:4230:30924991,30923862:autre:4230:30925033,30923865:autre:4230:30925602,30923868:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03407029644841383, 'nb_photo': 69284, 'list_port_cont': '30919046,30919126,30919165,30919270,30919344,30919385,30919461,30919497,30919570,30919610,30919718,30919792,30919869,30919944,30920012,30920094,30920166,30920237,30920315,30920345,30920453,30920569,30920642,30920759,30923798,30924735,30924781,30924816,30924849,30924888,30924924,30924966,30925007,30925042,30925150,30925220,30925304,30925333,30925451,30925530,30925597,30925643,30925749,30925779,30925856,30926270,30926687,30927152,30929312,30931030,30931063,30931101,30931136,30931171,30931205,30931247,30931280,30931325,30931352,30931395,30931430,30931468,30931508,30931543,30931574,30931616,30931654,30931693,30931728,30931808,30932080,30932156,30932273,30932309,30932387,30932462,30932535,30932844,30932972,30933007,30933059,30933205,30933372,30933664,30933702,30933736,30933899,30934063,30934123,30934270,30934438,30934591,30934684,30934798,30935772,30935850,30940061,30940136,30940165,30940244,30940320,30940390,30940469,30940532,30940607,30940731,30940766,30940795,30940901,30940986,30941064,30941136,30941167,3094121', 'assoc_port': '30918211:30919461,30918214:30919046,30918217:30919126,30918220:30919165,30918223:30919270,30918226:30919344,30918229:30919385,30918233:30919497,30918236:30919570,30918239:30919610,30918242:30919718,30918245:30919792,30918248:30919869,30918251:30919944,30918254:30920012,30918256:30920094,30918258:30920166,30918260:30920237,30918262:30920315,30918264:30920345,30918266:30920453,30918268:30920569,30918612:30920642,30918924:30920759,30923700:30923798,30923837:30924735,30923841:30924781,30923844:30924816,30923847:30924849,30923850:30924888,30923853:30924924,30923856:30924966,30923859:30925007,30923862:30925042,30923865:30925597,30923868:30925150,30923871:30925220,30923874:30925304,30923877:30925333,30923880:30925451,30923882:30925530,30923884:30925643,30923886:30925749,30923888:30925779,30923890:30925856,30923892:30926687,30924274:30926270,30924727:30927152,30929229:30929312,30929680:30931030,30929681:30931063,30929682:30931101,30929683:30931136,30929712:30931171,30929722:30932387,30929723:30931205,30929724:3093124', 'assoc_mat': '30918211:carton:4230:30919461,30918214:carton:4230:30919046,30918217:carton:4230:30919126,30918220:carton:4230:30919165,30918223:carton:4230:30919270,30918226:carton:4230:30919344,30918229:carton:4230:30919385,30918233:carton:4230:30919497,30918236:carton:4230:30919570,30918239:carton:4230:30919610,30918242:carton:4230:30919718,30918245:carton:4230:30919792,30918248:carton:4230:30919869,30918251:carton:4230:30919944,30918254:carton:4230:30920012,30918256:carton:4230:30920094,30918258:carton:4230:30920166,30918260:carton:4230:30920237,30918262:carton:4230:30920315,30918264:carton:4230:30920345,30918266:carton:4230:30920453,30918268:carton:4230:30920569,30918612:carton:4230:30920642,30918924:carton:4230:30920759,30923700:carton:4230:30923798,30923837:carton:4230:30924735,30923841:carton:4230:30924781,30923844:carton:4230:30924816,30923847:carton:4230:30924849,30923850:carton:4230:30924888,30923853:carton:4230:30924924,30923856:carton:4230:30924966,30923859:carton:4230:30925007,30923862:carton:4230:30925042,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011913206017685972, 'nb_photo': 1470, 'list_port_cont': '30919054,30919125,30919157,30919378,30919448,30919491,30919565,30919603,30919715,30919779,30919868,30919945,30920091,30920165,30920303,30920338,30920565,30920646,30920753,30923785,30924740,30924772,30924811,30924854,30924889,30924961,30924994,30925037,30925141,30925230,30925302,30925338,30925453,30925532,30925600,30925640,30925742,30925776,30925851,30926262,30926681,30927149,30929323,30931021,30931058,30931099,30931128,30931159,30931204,30931239,30931277,30931317,30931362,30931423,30931461,30931511,30931532,30931575,30931608,30931657,30931692,30931724,30931792,30932065,30932144,30932277,30932319,30932381,30932464,30932544,30932981,30933013,30933067,30933190,30933366,30933661,30933688,30933731,30933895,30934062,30934111,30934256,30934429,30934600,30934671,30934783,30935777,30935844,30940057,30940123,30940168,30940319,30940393,30940465,30940531,30940610,30940726,30940756,30940799,30940899,30940974,30941061,30941251,30941275,30941309,30941386,30945237,30945389,30945464,30945675,30945749,30945821,30945937,3094597', 'assoc_port': '30918211:30919448,30918214:30919054,30918217:30919125,30918220:30919157,30918229:30919378,30918233:30919491,30918236:30919565,30918239:30919603,30918242:30919715,30918245:30919779,30918248:30919868,30918251:30919945,30918256:30920091,30918258:30920165,30918262:30920303,30918264:30920338,30918268:30920565,30918612:30920646,30918924:30920753,30923700:30923785,30923837:30924740,30923841:30924772,30923844:30924811,30923847:30924854,30923850:30924889,30923856:30924961,30923859:30924994,30923862:30925037,30923865:30925600,30923868:30925141,30923871:30925230,30923874:30925302,30923877:30925338,30923880:30925453,30923882:30925532,30923884:30925640,30923886:30925742,30923888:30925776,30923890:30925851,30923892:30926681,30924274:30926262,30924727:30927149,30929229:30929323,30929680:30931021,30929681:30931058,30929682:30931099,30929683:30931128,30929712:30931159,30929722:30932381,30929723:30931204,30929724:30931239,30929725:30931277,30929726:30931317,30929727:30931362,30929729:30931423,30929730:30931461,30929731:3093151', 'assoc_mat': '30918211:metal:4230:30919448,30918214:metal:4230:30919054,30918217:metal:4230:30919125,30918220:metal:4230:30919157,30918229:metal:4230:30919378,30918233:metal:4230:30919491,30918236:metal:4230:30919565,30918239:metal:4230:30919603,30918242:metal:4230:30919715,30918245:metal:4230:30919779,30918248:metal:4230:30919868,30918251:metal:4230:30919945,30918256:metal:4230:30920091,30918258:metal:4230:30920165,30918262:metal:4230:30920303,30918264:metal:4230:30920338,30918268:metal:4230:30920565,30918612:metal:4230:30920646,30918924:metal:4230:30920753,30923700:metal:4230:30923785,30923837:metal:4230:30924740,30923841:metal:4230:30924772,30923844:metal:4230:30924811,30923847:metal:4230:30924854,30923850:metal:4230:30924889,30923856:metal:4230:30924961,30923859:metal:4230:30924994,30923862:metal:4230:30925037,30923865:metal:4230:30925600,30923868:metal:4230:30925141,30923871:metal:4230:30925230,30923874:metal:4230:30925302,30923877:metal:4230:30925338,30923880:metal:4230:30925453,30923882:metal:4230:30925532,30923884:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16261482236176186, 'nb_photo': 244667, 'list_port_cont': '30919050,30919129,30919158,30919272,30919341,30919383,30919457,30919496,30919575,30919602,30919710,30919793,30919864,30919933,30920018,30920092,30920160,30920235,30920314,30920346,30920458,30920571,30920637,30920755,30923793,30924738,30924783,30924822,30924856,30924882,30924923,30924958,30925003,30925036,30925153,30925232,30925305,30925336,30925443,30925528,30925601,30925636,30925745,30925778,30925859,30926259,30926690,30927146,30929327,30931024,30931053,30931095,30931134,30931168,30931215,30931238,30931288,30931322,30931360,30931400,30931429,30931459,30931503,30931549,30931573,30931613,30931653,30931690,30931731,30931805,30932073,30932151,30932278,30932312,30932392,30932467,30932543,30932855,30932975,30933009,30933070,30933204,30933365,30933652,30933695,30933733,30933897,30934070,30934124,30934260,30934430,30934593,30934686,30934796,30935780,30935857,30940059,30940132,30940164,30940243,30940311,30940392,30940458,30940543,30940609,30940727,30940768,30940802,30940913,30940987,30941066,30941142,30941174,3094120', 'assoc_port': '30918211:30919457,30918214:30919050,30918217:30919129,30918220:30919158,30918223:30919272,30918226:30919341,30918229:30919383,30918233:30919496,30918236:30919575,30918239:30919602,30918242:30919710,30918245:30919793,30918248:30919864,30918251:30919933,30918254:30920018,30918256:30920092,30918258:30920160,30918260:30920235,30918262:30920314,30918264:30920346,30918266:30920458,30918268:30920571,30918612:30920637,30918924:30920755,30923700:30923793,30923837:30924738,30923841:30924783,30923844:30924822,30923847:30924856,30923850:30924882,30923853:30924923,30923856:30924958,30923859:30925003,30923862:30925036,30923865:30925601,30923868:30925153,30923871:30925232,30923874:30925305,30923877:30925336,30923880:30925443,30923882:30925528,30923884:30925636,30923886:30925745,30923888:30925778,30923890:30925859,30923892:30926690,30924274:30926259,30924727:30927146,30929229:30929327,30929680:30931024,30929681:30931053,30929682:30931095,30929683:30931134,30929712:30931168,30929722:30932392,30929723:30931215,30929724:3093123', 'assoc_mat': '30918211:papier:4230:30919457,30918214:papier:4230:30919050,30918217:papier:4230:30919129,30918220:papier:4230:30919158,30918223:papier:4230:30919272,30918226:papier:4230:30919341,30918229:papier:4230:30919383,30918233:papier:4230:30919496,30918236:papier:4230:30919575,30918239:papier:4230:30919602,30918242:papier:4230:30919710,30918245:papier:4230:30919793,30918248:papier:4230:30919864,30918251:papier:4230:30919933,30918254:papier:4230:30920018,30918256:papier:4230:30920092,30918258:papier:4230:30920160,30918260:papier:4230:30920235,30918262:papier:4230:30920314,30918264:papier:4230:30920346,30918266:papier:4230:30920458,30918268:papier:4230:30920571,30918612:papier:4230:30920637,30918924:papier:4230:30920755,30923700:papier:4230:30923793,30923837:papier:4230:30924738,30923841:papier:4230:30924783,30923844:papier:4230:30924822,30923847:papier:4230:30924856,30923850:papier:4230:30924882,30923853:papier:4230:30924923,30923856:papier:4230:30924958,30923859:papier:4230:30925003,30923862:papier:4230:30925036,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026982780040502264, 'nb_photo': 1030, 'list_port_cont': '30919048,30919120,30919163,30919340,30919388,30919573,30919607,30919709,30919791,30919862,30919934,30920014,30920087,30920239,30920352,30920461,30920572,30920643,30923799,30924737,30924787,30924823,30924932,30924967,30925005,30925043,30925152,30925223,30925306,30925335,30925449,30925529,30925599,30925642,30925748,30925785,30925861,30926257,30926688,30927159,30931027,30931054,30931175,30931213,30931249,30931284,30931316,30931469,30931504,30931548,30931615,30931723,30932386,30932465,30932545,30932979,30933010,30933064,30933201,30933357,30933662,30933694,30933734,30933900,30934065,30934262,30934433,30934597,30934685,30934797,30940170,30940239,30940389,30940464,30940537,30940618,30940793,30940912,30940989,30941288,30941324,30945612,30945688,30945755,30945833,30945941,30945977,30946580,30950648,30951162,30951509,30951576,30951690,30951728,30951804,30951878,30951948,30952020,30952098,30953195,30955329,30956504,30956540,30956577,30956612,30956652,30956685,30956763,30956837,30956878,30956949,30957026,30957102,3095724', 'assoc_port': '30918214:30919048,30918217:30919120,30918220:30919163,30918226:30919340,30918229:30919388,30918236:30919573,30918239:30919607,30918242:30919709,30918245:30919791,30918248:30919862,30918251:30919934,30918254:30920014,30918256:30920087,30918260:30920239,30918264:30920352,30918266:30920461,30918268:30920572,30918612:30920643,30923700:30923799,30923837:30924737,30923841:30924787,30923844:30924823,30923853:30924932,30923856:30924967,30923859:30925005,30923862:30925043,30923865:30925599,30923868:30925152,30923871:30925223,30923874:30925306,30923877:30925335,30923880:30925449,30923882:30925529,30923884:30925642,30923886:30925748,30923888:30925785,30923890:30925861,30923892:30926688,30924274:30926257,30924727:30927159,30929680:30931027,30929681:30931054,30929712:30931175,30929722:30932386,30929723:30931213,30929724:30931249,30929725:30931284,30929726:30931316,30929730:30931469,30929731:30931504,30929732:30932545,30929733:30931548,30929735:30931615,30929738:30931723,30932024:30932465,30932883:30933010,30932884:3093297', 'assoc_mat': '30918214:pehd:4230:30919048,30918217:pehd:4230:30919120,30918220:pehd:4230:30919163,30918226:pehd:4230:30919340,30918229:pehd:4230:30919388,30918236:pehd:4230:30919573,30918239:pehd:4230:30919607,30918242:pehd:4230:30919709,30918245:pehd:4230:30919791,30918248:pehd:4230:30919862,30918251:pehd:4230:30919934,30918254:pehd:4230:30920014,30918256:pehd:4230:30920087,30918260:pehd:4230:30920239,30918264:pehd:4230:30920352,30918266:pehd:4230:30920461,30918268:pehd:4230:30920572,30918612:pehd:4230:30920643,30923700:pehd:4230:30923799,30923837:pehd:4230:30924737,30923841:pehd:4230:30924787,30923844:pehd:4230:30924823,30923853:pehd:4230:30924932,30923856:pehd:4230:30924967,30923859:pehd:4230:30925005,30923862:pehd:4230:30925043,30923865:pehd:4230:30925599,30923868:pehd:4230:30925152,30923871:pehd:4230:30925223,30923874:pehd:4230:30925306,30923877:pehd:4230:30925335,30923880:pehd:4230:30925449,30923882:pehd:4230:30925529,30923884:pehd:4230:30925642,30923886:pehd:4230:30925748,30923888:pehd:4230:30925785,30923890:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.026421274448888823, 'nb_photo': 23923, 'list_port_cont': '30919051,30919116,30919159,30919271,30919342,30919386,30919463,30919485,30919571,30919609,30919717,30919786,30919863,30919939,30920019,30920080,30920161,30920234,30920312,30920348,30920450,30920561,30920647,30920766,30923792,30924741,30924786,30924812,30924852,30924885,30924929,30924963,30924998,30925044,30925149,30925229,30925299,30925342,30925442,30925527,30925603,30925632,30925751,30925788,30925853,30926265,30926689,30927154,30929320,30931020,30931061,30931103,30931139,30931176,30931202,30931237,30931282,30931315,30931357,30931394,30931433,30931473,30931509,30931542,30931582,30931621,30931651,30931684,30931729,30931798,30932071,30932142,30932282,30932318,30932393,30932469,30932531,30932846,30932971,30933018,30933069,30933197,30933362,30933655,30933696,30933738,30933905,30934069,30934116,30934269,30934436,30934594,30934674,30934787,30935783,30935855,30940055,30940126,30940161,30940236,30940318,30940391,30940455,30940529,30940617,30940730,30940765,30940807,30940907,30940985,30941065,30941133,30941169,3094121', 'assoc_port': '30918211:30919463,30918214:30919051,30918217:30919116,30918220:30919159,30918223:30919271,30918226:30919342,30918229:30919386,30918233:30919485,30918236:30919571,30918239:30919609,30918242:30919717,30918245:30919786,30918248:30919863,30918251:30919939,30918254:30920019,30918256:30920080,30918258:30920161,30918260:30920234,30918262:30920312,30918264:30920348,30918266:30920450,30918268:30920561,30918612:30920647,30918924:30920766,30923700:30923792,30923837:30924741,30923841:30924786,30923844:30924812,30923847:30924852,30923850:30924885,30923853:30924929,30923856:30924963,30923859:30924998,30923862:30925044,30923865:30925603,30923868:30925149,30923871:30925229,30923874:30925299,30923877:30925342,30923880:30925442,30923882:30925527,30923884:30925632,30923886:30925751,30923888:30925788,30923890:30925853,30923892:30926689,30924274:30926265,30924727:30927154,30929229:30929320,30929680:30931020,30929681:30931061,30929682:30931103,30929683:30931139,30929712:30931176,30929722:30932393,30929723:30931202,30929724:3093123', 'assoc_mat': '30918211:pet_clair:4230:30919463,30918214:pet_clair:4230:30919051,30918217:pet_clair:4230:30919116,30918220:pet_clair:4230:30919159,30918223:pet_clair:4230:30919271,30918226:pet_clair:4230:30919342,30918229:pet_clair:4230:30919386,30918233:pet_clair:4230:30919485,30918236:pet_clair:4230:30919571,30918239:pet_clair:4230:30919609,30918242:pet_clair:4230:30919717,30918245:pet_clair:4230:30919786,30918248:pet_clair:4230:30919863,30918251:pet_clair:4230:30919939,30918254:pet_clair:4230:30920019,30918256:pet_clair:4230:30920080,30918258:pet_clair:4230:30920161,30918260:pet_clair:4230:30920234,30918262:pet_clair:4230:30920312,30918264:pet_clair:4230:30920348,30918266:pet_clair:4230:30920450,30918268:pet_clair:4230:30920561,30918612:pet_clair:4230:30920647,30918924:pet_clair:4230:30920766,30923700:pet_clair:4230:30923792,30923837:pet_clair:4230:30924741,30923841:pet_clair:4230:30924786,30923844:pet_clair:4230:30924812,30923847:pet_clair:4230:30924852,30923850:pet_clair:4230:30924885,30923853:pet_clair:4230:30924929,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002480788517217438, 'nb_photo': 606, 'list_port_cont': '30919049,30919122,30919276,30919350,30919572,30919604,30919721,30919789,30919940,30920017,30920088,30920241,30920351,30920573,30923794,30924745,30924785,30924850,30924894,30925032,30925151,30925226,30925300,30925343,30925445,30925523,30925605,30925635,30925741,30925783,30926269,30926691,30927155,30931023,30931097,30931173,30931285,30931583,30931617,30931730,30931806,30932143,30932391,30932466,30932974,30933062,30933369,30933665,30933698,30933735,30933893,30934058,30934119,30934598,30934676,30935858,30940733,30940753,30940988,30941137,30941250,30941282,30941322,30941461,30941543,30945246,30945539,30945760,30945837,30945946,30945981,30946203,30946462,30946541,30946577,30951005,30951092,30951169,30951240,30951312,30951430,30951694,30951723,30951797,30951871,30951955,30952140,30953184,30955335,30956395,30956536,30956575,30956688,30956759,30956840,30956868,30956945,30957018,30957105,30957166,30957243,30957312,30957880,30960868,30961829,30961869,30961900,30961940,30962015,30962052,30962092,30962128,30962319,3096238', 'assoc_port': '30918214:30919049,30918217:30919122,30918223:30919276,30918226:30919350,30918236:30919572,30918239:30919604,30918242:30919721,30918245:30919789,30918251:30919940,30918254:30920017,30918256:30920088,30918260:30920241,30918264:30920351,30918268:30920573,30923700:30923794,30923837:30924745,30923841:30924785,30923847:30924850,30923850:30924894,30923862:30925032,30923865:30925605,30923868:30925151,30923871:30925226,30923874:30925300,30923877:30925343,30923880:30925445,30923882:30925523,30923884:30925635,30923886:30925741,30923888:30925783,30923892:30926691,30924274:30926269,30924727:30927155,30929680:30931023,30929682:30931097,30929712:30931173,30929722:30932391,30929725:30931285,30929734:30931583,30929735:30931617,30929738:30931730,30930077:30931806,30930973:30932143,30932024:30932466,30932884:30932974,30933048:30933062,30933313:30933369,30933562:30933665,30933563:30933698,30933564:30933735,30933840:30933893,30933973:30934058,30934103:30934119,30934502:30934598,30934627:30934676,30935433:30935858,30938959:3094073', 'assoc_mat': '30918214:pet_fonce:4230:30919049,30918217:pet_fonce:4230:30919122,30918223:pet_fonce:4230:30919276,30918226:pet_fonce:4230:30919350,30918236:pet_fonce:4230:30919572,30918239:pet_fonce:4230:30919604,30918242:pet_fonce:4230:30919721,30918245:pet_fonce:4230:30919789,30918251:pet_fonce:4230:30919940,30918254:pet_fonce:4230:30920017,30918256:pet_fonce:4230:30920088,30918260:pet_fonce:4230:30920241,30918264:pet_fonce:4230:30920351,30918268:pet_fonce:4230:30920573,30923700:pet_fonce:4230:30923794,30923837:pet_fonce:4230:30924745,30923841:pet_fonce:4230:30924785,30923847:pet_fonce:4230:30924850,30923850:pet_fonce:4230:30924894,30923862:pet_fonce:4230:30925032,30923865:pet_fonce:4230:30925605,30923868:pet_fonce:4230:30925151,30923871:pet_fonce:4230:30925226,30923874:pet_fonce:4230:30925300,30923877:pet_fonce:4230:30925343,30923880:pet_fonce:4230:30925445,30923882:pet_fonce:4230:30925523,30923884:pet_fonce:4230:30925635,30923886:pet_fonce:4230:30925741,30923888:pet_fonce:4230:30925783,30923892:pet_fonce:4230:30926691,3'}), 'main_stat': {'nb_photos': 1625}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30998214,30998215,30998216,30998217,30998218,30998219,30998220?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-04', 0.7715628405406448),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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=4234 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=4234 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= 4234 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=4234 # 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 ! 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1625,),), 'unwanted_material_monthly_percentage': ((0.7715628405406448,),), 'material_repartition': (('incineration', 1625),), 'material_dict': {'incineration': 1625}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 4, 1), 0.7914413519733902, 2), (datetime.date(2026, 4, 2), 0.7029241475165613, 4), (datetime.date(2026, 4, 3), 0.7440026527670248, 3), (datetime.date(2026, 4, 4), 0.7579980328951105, 3), (datetime.date(2026, 4, 5), 0.810879917125018, 3), (datetime.date(2026, 4, 6), 0.7794338023615961, 2), (datetime.date(2026, 4, 7), 0.7682824856835292, 3), (datetime.date(2026, 4, 8), 0.7595743745612558, 4), (datetime.date(2026, 4, 9), 0.752014731635319, 4), (datetime.date(2026, 4, 10), 0.7745656775708861, 2), (datetime.date(2026, 4, 11), 0.7540917827950835, 2), (datetime.date(2026, 4, 12), 0.8196466143248988, 2), (datetime.date(2026, 4, 13), 0.7979381094309882, 1), (datetime.date(2026, 4, 14), 0.7987344948611049, 2), (datetime.date(2026, 4, 15), 0.7832926080520172, 3), (datetime.date(2026, 4, 16), 0.7555006374981464, 2), (datetime.date(2026, 4, 17), 0.765056353581959, 3), (datetime.date(2026, 4, 18), 0.7971838646920509, 2), (datetime.date(2026, 4, 19), 0.7637793631711637, 1), (datetime.date(2026, 4, 20), 0.7829970128235628, 2), (datetime.date(2026, 4, 21), 0.7826599142677685, 3), (datetime.date(2026, 4, 22), 0.7534531060122457, 3), (datetime.date(2026, 4, 23), 0.7712083766667631, 2), (datetime.date(2026, 4, 24), 0.7642748935164958, 3), (datetime.date(2026, 4, 25), 0.7706774722309959, 2), (datetime.date(2026, 4, 26), 0.7994108454319523, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 4, 1), 0.7914413519733902, 2), (datetime.date(2026, 4, 2), 0.7029241475165613, 4), (datetime.date(2026, 4, 3), 0.7440026527670248, 3), (datetime.date(2026, 4, 4), 0.7579980328951105, 3), (datetime.date(2026, 4, 5), 0.810879917125018, 3), (datetime.date(2026, 4, 6), 0.7794338023615961, 2), (datetime.date(2026, 4, 7), 0.7682824856835292, 3), (datetime.date(2026, 4, 8), 0.7595743745612558, 4), (datetime.date(2026, 4, 9), 0.752014731635319, 4), (datetime.date(2026, 4, 10), 0.7745656775708861, 2), (datetime.date(2026, 4, 11), 0.7540917827950835, 2), (datetime.date(2026, 4, 12), 0.8196466143248988, 2), (datetime.date(2026, 4, 13), 0.7979381094309882, 1), (datetime.date(2026, 4, 14), 0.7987344948611049, 2), (datetime.date(2026, 4, 15), 0.7832926080520172, 3), (datetime.date(2026, 4, 16), 0.7555006374981464, 2), (datetime.date(2026, 4, 17), 0.765056353581959, 3), (datetime.date(2026, 4, 18), 0.7971838646920509, 2), (datetime.date(2026, 4, 19), 0.7637793631711637, 1), (datetime.date(2026, 4, 20), 0.7829970128235628, 2), (datetime.date(2026, 4, 21), 0.7826599142677685, 3), (datetime.date(2026, 4, 22), 0.7534531060122457, 3), (datetime.date(2026, 4, 23), 0.7712083766667631, 2), (datetime.date(2026, 4, 24), 0.7642748935164958, 3), (datetime.date(2026, 4, 25), 0.7706774722309959, 2), (datetime.date(2026, 4, 26), 0.7994108454319523, 2))}, 'quality_array': [['-6.428931187595944', '01042026'], ['-6.639668782583365', '02042026'], ['-6.872311005459129', '03042026'], ['-6.954142228865635', '04042026'], ['-7.3591014609467695', '05042026'], ['-7.144564016010076', '06042026'], ['-6.822517271981807', '07042026'], ['-6.596719491640225', '08042026'], ['-6.840410617574503', '09042026'], ['-7.303121024407601', '10042026'], ['-7.071068739090438', '11042026'], ['-7.199993187272763', '12042026'], ['-6.993927178921982', '13042026'], ['-7.160006432979458', '14042026'], ['-6.947793008275419', '15042026'], ['-6.9294129316664455', '16042026'], ['-6.517939841668576', '17042026'], ['-6.350491608679454', '18042026'], ['-6.768114554182825', '19042026'], ['-6.485276737904907', '20042026'], ['-6.498852420757635', '21042026'], ['-6.502474272881468', '22042026'], ['-6.52593820150952', '23042026'], ['-6.960165816773543', '24042026'], ['-6.775080644215326', '25042026'], ['-6.980274468866018', '26042026']], 'number_of_batch': ((574,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013792769840264271, 'nb_photo': 14975, 'list_port_cont': '30919042,30919127,30919162,30919275,30919343,30919372,30919459,30919499,30919559,30919599,30919711,30919794,30919871,30919936,30920010,30920084,30920159,30920230,30920302,30920350,30920463,30920557,30920644,30920762,30923797,30924746,30924782,30924806,30924853,30924878,30924921,30924953,30924991,30925033,30925138,30925221,30925298,30925337,30925447,30925518,30925602,30925638,30925744,30925787,30925858,30926260,30926686,30927157,30929314,30931025,30931060,30931088,30931123,30931163,30931208,30931243,30931273,30931308,30931355,30931397,30931434,30931460,30931498,30931544,30931570,30931605,30931650,30931691,30931725,30931800,30932082,30932154,30932275,30932321,30932390,30932454,30932539,30932856,30932980,30933008,30933058,30933196,30933364,30933663,30933699,30933737,30933896,30934057,30934122,30934265,30934427,30934595,30934683,30934786,30935784,30935854,30940054,30940127,30940163,30940232,30940317,30940384,30940462,30940528,30940603,30940732,30940760,30940805,30940910,30940977,30941063,30941134,30941161,3094120', 'assoc_port': '30918211:30919459,30918214:30919042,30918217:30919127,30918220:30919162,30918223:30919275,30918226:30919343,30918229:30919372,30918233:30919499,30918236:30919559,30918239:30919599,30918242:30919711,30918245:30919794,30918248:30919871,30918251:30919936,30918254:30920010,30918256:30920084,30918258:30920159,30918260:30920230,30918262:30920302,30918264:30920350,30918266:30920463,30918268:30920557,30918612:30920644,30918924:30920762,30923700:30923797,30923837:30924746,30923841:30924782,30923844:30924806,30923847:30924853,30923850:30924878,30923853:30924921,30923856:30924953,30923859:30924991,30923862:30925033,30923865:30925602,30923868:30925138,30923871:30925221,30923874:30925298,30923877:30925337,30923880:30925447,30923882:30925518,30923884:30925638,30923886:30925744,30923888:30925787,30923890:30925858,30923892:30926686,30924274:30926260,30924727:30927157,30929229:30929314,30929680:30931025,30929681:30931060,30929682:30931088,30929683:30931123,30929712:30931163,30929722:30932390,30929723:30931208,30929724:3093124', 'assoc_mat': '30918211:autre:4230:30919459,30918214:autre:4230:30919042,30918217:autre:4230:30919127,30918220:autre:4230:30919162,30918223:autre:4230:30919275,30918226:autre:4230:30919343,30918229:autre:4230:30919372,30918233:autre:4230:30919499,30918236:autre:4230:30919559,30918239:autre:4230:30919599,30918242:autre:4230:30919711,30918245:autre:4230:30919794,30918248:autre:4230:30919871,30918251:autre:4230:30919936,30918254:autre:4230:30920010,30918256:autre:4230:30920084,30918258:autre:4230:30920159,30918260:autre:4230:30920230,30918262:autre:4230:30920302,30918264:autre:4230:30920350,30918266:autre:4230:30920463,30918268:autre:4230:30920557,30918612:autre:4230:30920644,30918924:autre:4230:30920762,30923700:autre:4230:30923797,30923837:autre:4230:30924746,30923841:autre:4230:30924782,30923844:autre:4230:30924806,30923847:autre:4230:30924853,30923850:autre:4230:30924878,30923853:autre:4230:30924921,30923856:autre:4230:30924953,30923859:autre:4230:30924991,30923862:autre:4230:30925033,30923865:autre:4230:30925602,30923868:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03407029644841383, 'nb_photo': 69284, 'list_port_cont': '30919046,30919126,30919165,30919270,30919344,30919385,30919461,30919497,30919570,30919610,30919718,30919792,30919869,30919944,30920012,30920094,30920166,30920237,30920315,30920345,30920453,30920569,30920642,30920759,30923798,30924735,30924781,30924816,30924849,30924888,30924924,30924966,30925007,30925042,30925150,30925220,30925304,30925333,30925451,30925530,30925597,30925643,30925749,30925779,30925856,30926270,30926687,30927152,30929312,30931030,30931063,30931101,30931136,30931171,30931205,30931247,30931280,30931325,30931352,30931395,30931430,30931468,30931508,30931543,30931574,30931616,30931654,30931693,30931728,30931808,30932080,30932156,30932273,30932309,30932387,30932462,30932535,30932844,30932972,30933007,30933059,30933205,30933372,30933664,30933702,30933736,30933899,30934063,30934123,30934270,30934438,30934591,30934684,30934798,30935772,30935850,30940061,30940136,30940165,30940244,30940320,30940390,30940469,30940532,30940607,30940731,30940766,30940795,30940901,30940986,30941064,30941136,30941167,3094121', 'assoc_port': '30918211:30919461,30918214:30919046,30918217:30919126,30918220:30919165,30918223:30919270,30918226:30919344,30918229:30919385,30918233:30919497,30918236:30919570,30918239:30919610,30918242:30919718,30918245:30919792,30918248:30919869,30918251:30919944,30918254:30920012,30918256:30920094,30918258:30920166,30918260:30920237,30918262:30920315,30918264:30920345,30918266:30920453,30918268:30920569,30918612:30920642,30918924:30920759,30923700:30923798,30923837:30924735,30923841:30924781,30923844:30924816,30923847:30924849,30923850:30924888,30923853:30924924,30923856:30924966,30923859:30925007,30923862:30925042,30923865:30925597,30923868:30925150,30923871:30925220,30923874:30925304,30923877:30925333,30923880:30925451,30923882:30925530,30923884:30925643,30923886:30925749,30923888:30925779,30923890:30925856,30923892:30926687,30924274:30926270,30924727:30927152,30929229:30929312,30929680:30931030,30929681:30931063,30929682:30931101,30929683:30931136,30929712:30931171,30929722:30932387,30929723:30931205,30929724:3093124', 'assoc_mat': '30918211:carton:4230:30919461,30918214:carton:4230:30919046,30918217:carton:4230:30919126,30918220:carton:4230:30919165,30918223:carton:4230:30919270,30918226:carton:4230:30919344,30918229:carton:4230:30919385,30918233:carton:4230:30919497,30918236:carton:4230:30919570,30918239:carton:4230:30919610,30918242:carton:4230:30919718,30918245:carton:4230:30919792,30918248:carton:4230:30919869,30918251:carton:4230:30919944,30918254:carton:4230:30920012,30918256:carton:4230:30920094,30918258:carton:4230:30920166,30918260:carton:4230:30920237,30918262:carton:4230:30920315,30918264:carton:4230:30920345,30918266:carton:4230:30920453,30918268:carton:4230:30920569,30918612:carton:4230:30920642,30918924:carton:4230:30920759,30923700:carton:4230:30923798,30923837:carton:4230:30924735,30923841:carton:4230:30924781,30923844:carton:4230:30924816,30923847:carton:4230:30924849,30923850:carton:4230:30924888,30923853:carton:4230:30924924,30923856:carton:4230:30924966,30923859:carton:4230:30925007,30923862:carton:4230:30925042,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011913206017685972, 'nb_photo': 1470, 'list_port_cont': '30919054,30919125,30919157,30919378,30919448,30919491,30919565,30919603,30919715,30919779,30919868,30919945,30920091,30920165,30920303,30920338,30920565,30920646,30920753,30923785,30924740,30924772,30924811,30924854,30924889,30924961,30924994,30925037,30925141,30925230,30925302,30925338,30925453,30925532,30925600,30925640,30925742,30925776,30925851,30926262,30926681,30927149,30929323,30931021,30931058,30931099,30931128,30931159,30931204,30931239,30931277,30931317,30931362,30931423,30931461,30931511,30931532,30931575,30931608,30931657,30931692,30931724,30931792,30932065,30932144,30932277,30932319,30932381,30932464,30932544,30932981,30933013,30933067,30933190,30933366,30933661,30933688,30933731,30933895,30934062,30934111,30934256,30934429,30934600,30934671,30934783,30935777,30935844,30940057,30940123,30940168,30940319,30940393,30940465,30940531,30940610,30940726,30940756,30940799,30940899,30940974,30941061,30941251,30941275,30941309,30941386,30945237,30945389,30945464,30945675,30945749,30945821,30945937,3094597', 'assoc_port': '30918211:30919448,30918214:30919054,30918217:30919125,30918220:30919157,30918229:30919378,30918233:30919491,30918236:30919565,30918239:30919603,30918242:30919715,30918245:30919779,30918248:30919868,30918251:30919945,30918256:30920091,30918258:30920165,30918262:30920303,30918264:30920338,30918268:30920565,30918612:30920646,30918924:30920753,30923700:30923785,30923837:30924740,30923841:30924772,30923844:30924811,30923847:30924854,30923850:30924889,30923856:30924961,30923859:30924994,30923862:30925037,30923865:30925600,30923868:30925141,30923871:30925230,30923874:30925302,30923877:30925338,30923880:30925453,30923882:30925532,30923884:30925640,30923886:30925742,30923888:30925776,30923890:30925851,30923892:30926681,30924274:30926262,30924727:30927149,30929229:30929323,30929680:30931021,30929681:30931058,30929682:30931099,30929683:30931128,30929712:30931159,30929722:30932381,30929723:30931204,30929724:30931239,30929725:30931277,30929726:30931317,30929727:30931362,30929729:30931423,30929730:30931461,30929731:3093151', 'assoc_mat': '30918211:metal:4230:30919448,30918214:metal:4230:30919054,30918217:metal:4230:30919125,30918220:metal:4230:30919157,30918229:metal:4230:30919378,30918233:metal:4230:30919491,30918236:metal:4230:30919565,30918239:metal:4230:30919603,30918242:metal:4230:30919715,30918245:metal:4230:30919779,30918248:metal:4230:30919868,30918251:metal:4230:30919945,30918256:metal:4230:30920091,30918258:metal:4230:30920165,30918262:metal:4230:30920303,30918264:metal:4230:30920338,30918268:metal:4230:30920565,30918612:metal:4230:30920646,30918924:metal:4230:30920753,30923700:metal:4230:30923785,30923837:metal:4230:30924740,30923841:metal:4230:30924772,30923844:metal:4230:30924811,30923847:metal:4230:30924854,30923850:metal:4230:30924889,30923856:metal:4230:30924961,30923859:metal:4230:30924994,30923862:metal:4230:30925037,30923865:metal:4230:30925600,30923868:metal:4230:30925141,30923871:metal:4230:30925230,30923874:metal:4230:30925302,30923877:metal:4230:30925338,30923880:metal:4230:30925453,30923882:metal:4230:30925532,30923884:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16261482236176186, 'nb_photo': 244667, 'list_port_cont': '30919050,30919129,30919158,30919272,30919341,30919383,30919457,30919496,30919575,30919602,30919710,30919793,30919864,30919933,30920018,30920092,30920160,30920235,30920314,30920346,30920458,30920571,30920637,30920755,30923793,30924738,30924783,30924822,30924856,30924882,30924923,30924958,30925003,30925036,30925153,30925232,30925305,30925336,30925443,30925528,30925601,30925636,30925745,30925778,30925859,30926259,30926690,30927146,30929327,30931024,30931053,30931095,30931134,30931168,30931215,30931238,30931288,30931322,30931360,30931400,30931429,30931459,30931503,30931549,30931573,30931613,30931653,30931690,30931731,30931805,30932073,30932151,30932278,30932312,30932392,30932467,30932543,30932855,30932975,30933009,30933070,30933204,30933365,30933652,30933695,30933733,30933897,30934070,30934124,30934260,30934430,30934593,30934686,30934796,30935780,30935857,30940059,30940132,30940164,30940243,30940311,30940392,30940458,30940543,30940609,30940727,30940768,30940802,30940913,30940987,30941066,30941142,30941174,3094120', 'assoc_port': '30918211:30919457,30918214:30919050,30918217:30919129,30918220:30919158,30918223:30919272,30918226:30919341,30918229:30919383,30918233:30919496,30918236:30919575,30918239:30919602,30918242:30919710,30918245:30919793,30918248:30919864,30918251:30919933,30918254:30920018,30918256:30920092,30918258:30920160,30918260:30920235,30918262:30920314,30918264:30920346,30918266:30920458,30918268:30920571,30918612:30920637,30918924:30920755,30923700:30923793,30923837:30924738,30923841:30924783,30923844:30924822,30923847:30924856,30923850:30924882,30923853:30924923,30923856:30924958,30923859:30925003,30923862:30925036,30923865:30925601,30923868:30925153,30923871:30925232,30923874:30925305,30923877:30925336,30923880:30925443,30923882:30925528,30923884:30925636,30923886:30925745,30923888:30925778,30923890:30925859,30923892:30926690,30924274:30926259,30924727:30927146,30929229:30929327,30929680:30931024,30929681:30931053,30929682:30931095,30929683:30931134,30929712:30931168,30929722:30932392,30929723:30931215,30929724:3093123', 'assoc_mat': '30918211:papier:4230:30919457,30918214:papier:4230:30919050,30918217:papier:4230:30919129,30918220:papier:4230:30919158,30918223:papier:4230:30919272,30918226:papier:4230:30919341,30918229:papier:4230:30919383,30918233:papier:4230:30919496,30918236:papier:4230:30919575,30918239:papier:4230:30919602,30918242:papier:4230:30919710,30918245:papier:4230:30919793,30918248:papier:4230:30919864,30918251:papier:4230:30919933,30918254:papier:4230:30920018,30918256:papier:4230:30920092,30918258:papier:4230:30920160,30918260:papier:4230:30920235,30918262:papier:4230:30920314,30918264:papier:4230:30920346,30918266:papier:4230:30920458,30918268:papier:4230:30920571,30918612:papier:4230:30920637,30918924:papier:4230:30920755,30923700:papier:4230:30923793,30923837:papier:4230:30924738,30923841:papier:4230:30924783,30923844:papier:4230:30924822,30923847:papier:4230:30924856,30923850:papier:4230:30924882,30923853:papier:4230:30924923,30923856:papier:4230:30924958,30923859:papier:4230:30925003,30923862:papier:4230:30925036,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026982780040502264, 'nb_photo': 1030, 'list_port_cont': '30919048,30919120,30919163,30919340,30919388,30919573,30919607,30919709,30919791,30919862,30919934,30920014,30920087,30920239,30920352,30920461,30920572,30920643,30923799,30924737,30924787,30924823,30924932,30924967,30925005,30925043,30925152,30925223,30925306,30925335,30925449,30925529,30925599,30925642,30925748,30925785,30925861,30926257,30926688,30927159,30931027,30931054,30931175,30931213,30931249,30931284,30931316,30931469,30931504,30931548,30931615,30931723,30932386,30932465,30932545,30932979,30933010,30933064,30933201,30933357,30933662,30933694,30933734,30933900,30934065,30934262,30934433,30934597,30934685,30934797,30940170,30940239,30940389,30940464,30940537,30940618,30940793,30940912,30940989,30941288,30941324,30945612,30945688,30945755,30945833,30945941,30945977,30946580,30950648,30951162,30951509,30951576,30951690,30951728,30951804,30951878,30951948,30952020,30952098,30953195,30955329,30956504,30956540,30956577,30956612,30956652,30956685,30956763,30956837,30956878,30956949,30957026,30957102,3095724', 'assoc_port': '30918214:30919048,30918217:30919120,30918220:30919163,30918226:30919340,30918229:30919388,30918236:30919573,30918239:30919607,30918242:30919709,30918245:30919791,30918248:30919862,30918251:30919934,30918254:30920014,30918256:30920087,30918260:30920239,30918264:30920352,30918266:30920461,30918268:30920572,30918612:30920643,30923700:30923799,30923837:30924737,30923841:30924787,30923844:30924823,30923853:30924932,30923856:30924967,30923859:30925005,30923862:30925043,30923865:30925599,30923868:30925152,30923871:30925223,30923874:30925306,30923877:30925335,30923880:30925449,30923882:30925529,30923884:30925642,30923886:30925748,30923888:30925785,30923890:30925861,30923892:30926688,30924274:30926257,30924727:30927159,30929680:30931027,30929681:30931054,30929712:30931175,30929722:30932386,30929723:30931213,30929724:30931249,30929725:30931284,30929726:30931316,30929730:30931469,30929731:30931504,30929732:30932545,30929733:30931548,30929735:30931615,30929738:30931723,30932024:30932465,30932883:30933010,30932884:3093297', 'assoc_mat': '30918214:pehd:4230:30919048,30918217:pehd:4230:30919120,30918220:pehd:4230:30919163,30918226:pehd:4230:30919340,30918229:pehd:4230:30919388,30918236:pehd:4230:30919573,30918239:pehd:4230:30919607,30918242:pehd:4230:30919709,30918245:pehd:4230:30919791,30918248:pehd:4230:30919862,30918251:pehd:4230:30919934,30918254:pehd:4230:30920014,30918256:pehd:4230:30920087,30918260:pehd:4230:30920239,30918264:pehd:4230:30920352,30918266:pehd:4230:30920461,30918268:pehd:4230:30920572,30918612:pehd:4230:30920643,30923700:pehd:4230:30923799,30923837:pehd:4230:30924737,30923841:pehd:4230:30924787,30923844:pehd:4230:30924823,30923853:pehd:4230:30924932,30923856:pehd:4230:30924967,30923859:pehd:4230:30925005,30923862:pehd:4230:30925043,30923865:pehd:4230:30925599,30923868:pehd:4230:30925152,30923871:pehd:4230:30925223,30923874:pehd:4230:30925306,30923877:pehd:4230:30925335,30923880:pehd:4230:30925449,30923882:pehd:4230:30925529,30923884:pehd:4230:30925642,30923886:pehd:4230:30925748,30923888:pehd:4230:30925785,30923890:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.026421274448888823, 'nb_photo': 23923, 'list_port_cont': '30919051,30919116,30919159,30919271,30919342,30919386,30919463,30919485,30919571,30919609,30919717,30919786,30919863,30919939,30920019,30920080,30920161,30920234,30920312,30920348,30920450,30920561,30920647,30920766,30923792,30924741,30924786,30924812,30924852,30924885,30924929,30924963,30924998,30925044,30925149,30925229,30925299,30925342,30925442,30925527,30925603,30925632,30925751,30925788,30925853,30926265,30926689,30927154,30929320,30931020,30931061,30931103,30931139,30931176,30931202,30931237,30931282,30931315,30931357,30931394,30931433,30931473,30931509,30931542,30931582,30931621,30931651,30931684,30931729,30931798,30932071,30932142,30932282,30932318,30932393,30932469,30932531,30932846,30932971,30933018,30933069,30933197,30933362,30933655,30933696,30933738,30933905,30934069,30934116,30934269,30934436,30934594,30934674,30934787,30935783,30935855,30940055,30940126,30940161,30940236,30940318,30940391,30940455,30940529,30940617,30940730,30940765,30940807,30940907,30940985,30941065,30941133,30941169,3094121', 'assoc_port': '30918211:30919463,30918214:30919051,30918217:30919116,30918220:30919159,30918223:30919271,30918226:30919342,30918229:30919386,30918233:30919485,30918236:30919571,30918239:30919609,30918242:30919717,30918245:30919786,30918248:30919863,30918251:30919939,30918254:30920019,30918256:30920080,30918258:30920161,30918260:30920234,30918262:30920312,30918264:30920348,30918266:30920450,30918268:30920561,30918612:30920647,30918924:30920766,30923700:30923792,30923837:30924741,30923841:30924786,30923844:30924812,30923847:30924852,30923850:30924885,30923853:30924929,30923856:30924963,30923859:30924998,30923862:30925044,30923865:30925603,30923868:30925149,30923871:30925229,30923874:30925299,30923877:30925342,30923880:30925442,30923882:30925527,30923884:30925632,30923886:30925751,30923888:30925788,30923890:30925853,30923892:30926689,30924274:30926265,30924727:30927154,30929229:30929320,30929680:30931020,30929681:30931061,30929682:30931103,30929683:30931139,30929712:30931176,30929722:30932393,30929723:30931202,30929724:3093123', 'assoc_mat': '30918211:pet_clair:4230:30919463,30918214:pet_clair:4230:30919051,30918217:pet_clair:4230:30919116,30918220:pet_clair:4230:30919159,30918223:pet_clair:4230:30919271,30918226:pet_clair:4230:30919342,30918229:pet_clair:4230:30919386,30918233:pet_clair:4230:30919485,30918236:pet_clair:4230:30919571,30918239:pet_clair:4230:30919609,30918242:pet_clair:4230:30919717,30918245:pet_clair:4230:30919786,30918248:pet_clair:4230:30919863,30918251:pet_clair:4230:30919939,30918254:pet_clair:4230:30920019,30918256:pet_clair:4230:30920080,30918258:pet_clair:4230:30920161,30918260:pet_clair:4230:30920234,30918262:pet_clair:4230:30920312,30918264:pet_clair:4230:30920348,30918266:pet_clair:4230:30920450,30918268:pet_clair:4230:30920561,30918612:pet_clair:4230:30920647,30918924:pet_clair:4230:30920766,30923700:pet_clair:4230:30923792,30923837:pet_clair:4230:30924741,30923841:pet_clair:4230:30924786,30923844:pet_clair:4230:30924812,30923847:pet_clair:4230:30924852,30923850:pet_clair:4230:30924885,30923853:pet_clair:4230:30924929,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002480788517217438, 'nb_photo': 606, 'list_port_cont': '30919049,30919122,30919276,30919350,30919572,30919604,30919721,30919789,30919940,30920017,30920088,30920241,30920351,30920573,30923794,30924745,30924785,30924850,30924894,30925032,30925151,30925226,30925300,30925343,30925445,30925523,30925605,30925635,30925741,30925783,30926269,30926691,30927155,30931023,30931097,30931173,30931285,30931583,30931617,30931730,30931806,30932143,30932391,30932466,30932974,30933062,30933369,30933665,30933698,30933735,30933893,30934058,30934119,30934598,30934676,30935858,30940733,30940753,30940988,30941137,30941250,30941282,30941322,30941461,30941543,30945246,30945539,30945760,30945837,30945946,30945981,30946203,30946462,30946541,30946577,30951005,30951092,30951169,30951240,30951312,30951430,30951694,30951723,30951797,30951871,30951955,30952140,30953184,30955335,30956395,30956536,30956575,30956688,30956759,30956840,30956868,30956945,30957018,30957105,30957166,30957243,30957312,30957880,30960868,30961829,30961869,30961900,30961940,30962015,30962052,30962092,30962128,30962319,3096238', 'assoc_port': '30918214:30919049,30918217:30919122,30918223:30919276,30918226:30919350,30918236:30919572,30918239:30919604,30918242:30919721,30918245:30919789,30918251:30919940,30918254:30920017,30918256:30920088,30918260:30920241,30918264:30920351,30918268:30920573,30923700:30923794,30923837:30924745,30923841:30924785,30923847:30924850,30923850:30924894,30923862:30925032,30923865:30925605,30923868:30925151,30923871:30925226,30923874:30925300,30923877:30925343,30923880:30925445,30923882:30925523,30923884:30925635,30923886:30925741,30923888:30925783,30923892:30926691,30924274:30926269,30924727:30927155,30929680:30931023,30929682:30931097,30929712:30931173,30929722:30932391,30929725:30931285,30929734:30931583,30929735:30931617,30929738:30931730,30930077:30931806,30930973:30932143,30932024:30932466,30932884:30932974,30933048:30933062,30933313:30933369,30933562:30933665,30933563:30933698,30933564:30933735,30933840:30933893,30933973:30934058,30934103:30934119,30934502:30934598,30934627:30934676,30935433:30935858,30938959:3094073', 'assoc_mat': '30918214:pet_fonce:4230:30919049,30918217:pet_fonce:4230:30919122,30918223:pet_fonce:4230:30919276,30918226:pet_fonce:4230:30919350,30918236:pet_fonce:4230:30919572,30918239:pet_fonce:4230:30919604,30918242:pet_fonce:4230:30919721,30918245:pet_fonce:4230:30919789,30918251:pet_fonce:4230:30919940,30918254:pet_fonce:4230:30920017,30918256:pet_fonce:4230:30920088,30918260:pet_fonce:4230:30920241,30918264:pet_fonce:4230:30920351,30918268:pet_fonce:4230:30920573,30923700:pet_fonce:4230:30923794,30923837:pet_fonce:4230:30924745,30923841:pet_fonce:4230:30924785,30923847:pet_fonce:4230:30924850,30923850:pet_fonce:4230:30924894,30923862:pet_fonce:4230:30925032,30923865:pet_fonce:4230:30925605,30923868:pet_fonce:4230:30925151,30923871:pet_fonce:4230:30925226,30923874:pet_fonce:4230:30925300,30923877:pet_fonce:4230:30925343,30923880:pet_fonce:4230:30925445,30923882:pet_fonce:4230:30925523,30923884:pet_fonce:4230:30925635,30923886:pet_fonce:4230:30925741,30923888:pet_fonce:4230:30925783,30923892:pet_fonce:4230:30926691,3'}), 'main_stat': {'nb_photos': 1625}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30998214,30998215,30998216,30998217,30998218,30998219,30998220?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-04', 0.7715628405406448),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_04_annee_2026.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 {'incineration': {'autre': ['autre', '1.38%', 14975], 'carton': ['carton', '3.41%', 69284], 'metal': ['metal', '0.12%', 1470], 'papier': ['papier', '16.26%', 244667], 'pehd': ['pehd', '0.27%', 1030], 'pet_clair': ['pet_clair', '2.64%', 23923], 'pet_fonce': ['pet_fonce', '0.25%', 606]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_04_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.47user 2.61system 0:08.72elapsed 58%CPU (0avgtext+0avgdata 185868maxresident)k 16inputs+296outputs (0major+49234minor)pagefaults 0swaps