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-03 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (6, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="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 : (6, 31) 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 : 03 mtr_id : dashboard_places : SCCU_cam7 date : 2026-03 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-03%') and created_at like '%2026-03%'))); nb_day : (6, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 03 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) = 03 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 '%032026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-03-01 : dt_date_just_month_year : 2026-03-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-03-01" AND ded.date <= "2026-03-31" 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 (2935051,2936594,2938331,2940109,2943522,2944695,2945781,2946571,2947683,2948818,2950252,2951583,2952551,2953224,2954937,2956523,2958004,2959610,2961653,2962851,2963392,2965024,2966614,2968222,2969000,2969722,2970308,2970814,2971485,2972146) 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.013551222396667222, 'nb_photo': 18609, 'list_port_cont': '30579146,30580089,30580200,30580387,30580724,30581001,30581309,30581670,30581925,30582270,30582608,30582959,30583412,30584006,30584514,30584821,30584973,30585128,30585440,30585480,30585509,30585693,30586508,30586679,30599761,30599812,30599843,30599880,30599919,30599960,30600004,30600037,30600078,30600084,30600174,30600223,30600256,30600292,30600321,30600445,30600504,30600539,30600578,30600766,30601569,30601822,30601953,30601988,30613949,30613976,30614009,30614065,30614113,30614144,30614186,30614233,30614266,30614293,30614335,30614380,30614415,30614451,30614526,30614549,30614595,30614612,30614663,30614698,30614737,30614802,30616436,30616633,30629815,30629906,30629962,30630057,30630111,30630146,30630188,30630363,30630400,30630488,30630509,30630610,30630661,30630702,30630762,30630877,30630981,30631024,30631089,30631155,30631198,30631325,30632729,30633419,30652998,30653115,30653156,30653182,30653209,30653314,30653397,30653477,30653526,30653579,30653607,30653694,30653829,30653867,30653893,30653982,30654036,3065411', 'assoc_port': '30578993:30579146,30579990:30580200,30579991:30580089,30580351:30580387,30580704:30580724,30580967:30581001,30581218:30581309,30581511:30581670,30581888:30581925,30582201:30582270,30582560:30582608,30582939:30582959,30583323:30583412,30583944:30584006,30584433:30584514,30584790:30584821,30584956:30584973,30585085:30585128,30585420:30585509,30585422:30585440,30585423:30585480,30585636:30585693,30586496:30586508,30586658:30586679,30599642:30600766,30599643:30600578,30599646:30600504,30599647:30600539,30599651:30601953,30599654:30600445,30599655:30600292,30599658:30600256,30599660:30601988,30599662:30600321,30599665:30600223,30599667:30600078,30599668:30600037,30599670:30600174,30599673:30600084,30599676:30600004,30599677:30599880,30599679:30599960,30599682:30599812,30599683:30599919,30599686:30599761,30599688:30599843,30601506:30601569,30601761:30601822,30613749:30614698,30613752:30614737,30613755:30614802,30613758:30614549,30613761:30614415,30613764:30614612,30613766:30614293,30613768:30614266,30613770:3061466', 'assoc_mat': '30578993:autre:4230:30579146,30579990:autre:4230:30580200,30579991:autre:4230:30580089,30580351:autre:4230:30580387,30580704:autre:4230:30580724,30580967:autre:4230:30581001,30581218:autre:4230:30581309,30581511:autre:4230:30581670,30581888:autre:4230:30581925,30582201:autre:4230:30582270,30582560:autre:4230:30582608,30582939:autre:4230:30582959,30583323:autre:4230:30583412,30583944:autre:4230:30584006,30584433:autre:4230:30584514,30584790:autre:4230:30584821,30584956:autre:4230:30584973,30585085:autre:4230:30585128,30585420:autre:4230:30585509,30585422:autre:4230:30585440,30585423:autre:4230:30585480,30585636:autre:4230:30585693,30586496:autre:4230:30586508,30586658:autre:4230:30586679,30599642:autre:4230:30600766,30599643:autre:4230:30600578,30599646:autre:4230:30600504,30599647:autre:4230:30600539,30599651:autre:4230:30601953,30599654:autre:4230:30600445,30599655:autre:4230:30600292,30599658:autre:4230:30600256,30599660:autre:4230:30601988,30599662:autre:4230:30600321,30599665:autre:4230:30600223,30599667:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03700224619079674, 'nb_photo': 96339, 'list_port_cont': '30579143,30580087,30580206,30580385,30580739,30581012,30581322,30581676,30581923,30582269,30582605,30582968,30583411,30584008,30584530,30584820,30584978,30585134,30585437,30585466,30585511,30585701,30586516,30586678,30599754,30599809,30599852,30599878,30599929,30599970,30600002,30600040,30600076,30600102,30600187,30600217,30600254,30600295,30600336,30600458,30600500,30600538,30600581,30600768,30601579,30601819,30601966,30601999,30613947,30613973,30614017,30614074,30614126,30614138,30614193,30614235,30614273,30614303,30614339,30614377,30614418,30614455,30614528,30614564,30614601,30614618,30614664,30614696,30614743,30614815,30616432,30616645,30629802,30629916,30629967,30630064,30630117,30630147,30630189,30630373,30630409,30630486,30630507,30630606,30630643,30630698,30630757,30630888,30630983,30631017,30631094,30631154,30631202,30631334,30632732,30633418,30653002,30653113,30653152,30653202,30653212,30653320,30653392,30653476,30653521,30653566,30653606,30653707,30653833,30653855,30653906,30653965,30654025,3065412', 'assoc_port': '30578993:30579143,30579990:30580206,30579991:30580087,30580351:30580385,30580704:30580739,30580967:30581012,30581218:30581322,30581511:30581676,30581888:30581923,30582201:30582269,30582560:30582605,30582939:30582968,30583323:30583411,30583944:30584008,30584433:30584530,30584790:30584820,30584956:30584978,30585085:30585134,30585420:30585511,30585422:30585437,30585423:30585466,30585636:30585701,30586496:30586516,30586658:30586678,30599642:30600768,30599643:30600581,30599646:30600500,30599647:30600538,30599651:30601966,30599654:30600458,30599655:30600295,30599658:30600254,30599660:30601999,30599662:30600336,30599665:30600217,30599667:30600076,30599668:30600040,30599670:30600187,30599673:30600102,30599676:30600002,30599677:30599878,30599679:30599970,30599682:30599809,30599683:30599929,30599686:30599754,30599688:30599852,30601506:30601579,30601761:30601819,30613749:30614696,30613752:30614743,30613755:30614815,30613758:30614564,30613761:30614418,30613764:30614618,30613766:30614303,30613768:30614273,30613770:3061466', 'assoc_mat': '30578993:carton:4230:30579143,30579990:carton:4230:30580206,30579991:carton:4230:30580087,30580351:carton:4230:30580385,30580704:carton:4230:30580739,30580967:carton:4230:30581012,30581218:carton:4230:30581322,30581511:carton:4230:30581676,30581888:carton:4230:30581923,30582201:carton:4230:30582269,30582560:carton:4230:30582605,30582939:carton:4230:30582968,30583323:carton:4230:30583411,30583944:carton:4230:30584008,30584433:carton:4230:30584530,30584790:carton:4230:30584820,30584956:carton:4230:30584978,30585085:carton:4230:30585134,30585420:carton:4230:30585511,30585422:carton:4230:30585437,30585423:carton:4230:30585466,30585636:carton:4230:30585701,30586496:carton:4230:30586516,30586658:carton:4230:30586678,30599642:carton:4230:30600768,30599643:carton:4230:30600581,30599646:carton:4230:30600500,30599647:carton:4230:30600538,30599651:carton:4230:30601966,30599654:carton:4230:30600458,30599655:carton:4230:30600295,30599658:carton:4230:30600254,30599660:carton:4230:30601999,30599662:carton:4230:30600336,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010737123444910723, 'nb_photo': 1836, 'list_port_cont': '30579142,30580194,30580384,30580737,30581315,30581671,30581919,30582285,30582613,30583413,30584517,30584964,30585140,30585439,30585694,30586502,30586684,30599749,30599854,30599885,30599921,30599953,30600033,30600062,30600173,30600290,30600328,30600446,30600514,30600575,30601821,30601960,30601989,30613940,30613970,30614013,30614067,30614119,30614148,30614200,30614229,30614267,30614333,30614376,30614412,30614548,30614590,30614656,30616426,30616636,30629813,30629905,30629956,30630053,30630115,30630160,30630192,30630358,30630395,30630483,30630500,30630604,30630649,30630697,30630878,30630982,30631015,30631088,30631147,30631211,30631320,30632734,30633415,30652995,30653116,30653149,30653200,30653205,30653318,30653401,30653469,30653519,30653572,30653603,30653706,30653825,30653870,30653895,30653977,30654124,30654157,30654227,30654375,30655615,30655872,30655982,30656305,30656516,30657097,30657547,30657651,30657819,30658269,30658727,30659389,30659419,30659989,30660329,30661077,30661216,30662245,30662277,30662469,3066335', 'assoc_port': '30578993:30579142,30579990:30580194,30580351:30580384,30580704:30580737,30581218:30581315,30581511:30581671,30581888:30581919,30582201:30582285,30582560:30582613,30583323:30583413,30584433:30584517,30584956:30584964,30585085:30585140,30585422:30585439,30585636:30585694,30586496:30586502,30586658:30586684,30599643:30600575,30599646:30600514,30599651:30601960,30599654:30600446,30599655:30600290,30599660:30601989,30599662:30600328,30599667:30600062,30599668:30600033,30599670:30600173,30599677:30599885,30599679:30599953,30599683:30599921,30599686:30599749,30599688:30599854,30601761:30601821,30613758:30614548,30613761:30614412,30613768:30614267,30613770:30614656,30613773:30614590,30613776:30614376,30613777:30614119,30613778:30614013,30613779:30614200,30613780:30614333,30613781:30613970,30613782:30614229,30613783:30614148,30613784:30614067,30613785:30613940,30616414:30616426,30616604:30616636,30629649:30631211,30629653:30631147,30629660:30631320,30629663:30631015,30629672:30630604,30629678:30629813,30629681:3063108', 'assoc_mat': '30578993:metal:4230:30579142,30579990:metal:4230:30580194,30580351:metal:4230:30580384,30580704:metal:4230:30580737,30581218:metal:4230:30581315,30581511:metal:4230:30581671,30581888:metal:4230:30581919,30582201:metal:4230:30582285,30582560:metal:4230:30582613,30583323:metal:4230:30583413,30584433:metal:4230:30584517,30584956:metal:4230:30584964,30585085:metal:4230:30585140,30585422:metal:4230:30585439,30585636:metal:4230:30585694,30586496:metal:4230:30586502,30586658:metal:4230:30586684,30599643:metal:4230:30600575,30599646:metal:4230:30600514,30599651:metal:4230:30601960,30599654:metal:4230:30600446,30599655:metal:4230:30600290,30599660:metal:4230:30601989,30599662:metal:4230:30600328,30599667:metal:4230:30600062,30599668:metal:4230:30600033,30599670:metal:4230:30600173,30599677:metal:4230:30599885,30599679:metal:4230:30599953,30599683:metal:4230:30599921,30599686:metal:4230:30599749,30599688:metal:4230:30599854,30601761:metal:4230:30601821,30613758:metal:4230:30614548,30613761:metal:4230:30614412,30613768:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1715135762446262, 'nb_photo': 325228, 'list_port_cont': '30579139,30580093,30580207,30580388,30580738,30581007,30581317,30581679,30581921,30582274,30582611,30582967,30583421,30583999,30584525,30584822,30584972,30585144,30585436,30585464,30585503,30585700,30586507,30586683,30599757,30599815,30599851,30599888,30599934,30599964,30599992,30600041,30600069,30600094,30600179,30600213,30600263,30600301,30600335,30600453,30600509,30600550,30600585,30600765,30601583,30601825,30601964,30601995,30613942,30613984,30614014,30614072,30614129,30614158,30614199,30614232,30614271,30614310,30614337,30614383,30614420,30614447,30614524,30614558,30614592,30614608,30614673,30614706,30614735,30614805,30616435,30616646,30629812,30629915,30629974,30630060,30630119,30630153,30630196,30630367,30630402,30630490,30630510,30630608,30630663,30630700,30630754,30630896,30630987,30631026,30631093,30631151,30631208,30631336,30632746,30633412,30653000,30653118,30653153,30653196,30653199,30653310,30653398,30653467,30653513,30653577,30653599,30653704,30653832,30653865,30653903,30653976,30654034,3065412', 'assoc_port': '30578993:30579139,30579990:30580207,30579991:30580093,30580351:30580388,30580704:30580738,30580967:30581007,30581218:30581317,30581511:30581679,30581888:30581921,30582201:30582274,30582560:30582611,30582939:30582967,30583323:30583421,30583944:30583999,30584433:30584525,30584790:30584822,30584956:30584972,30585085:30585144,30585420:30585503,30585422:30585436,30585423:30585464,30585636:30585700,30586496:30586507,30586658:30586683,30599642:30600765,30599643:30600585,30599646:30600509,30599647:30600550,30599651:30601964,30599654:30600453,30599655:30600301,30599658:30600263,30599660:30601995,30599662:30600335,30599665:30600213,30599667:30600069,30599668:30600041,30599670:30600179,30599673:30600094,30599676:30599992,30599677:30599888,30599679:30599964,30599682:30599815,30599683:30599934,30599686:30599757,30599688:30599851,30601506:30601583,30601761:30601825,30613749:30614706,30613752:30614735,30613755:30614805,30613758:30614558,30613761:30614420,30613764:30614608,30613766:30614310,30613768:30614271,30613770:3061467', 'assoc_mat': '30578993:papier:4230:30579139,30579990:papier:4230:30580207,30579991:papier:4230:30580093,30580351:papier:4230:30580388,30580704:papier:4230:30580738,30580967:papier:4230:30581007,30581218:papier:4230:30581317,30581511:papier:4230:30581679,30581888:papier:4230:30581921,30582201:papier:4230:30582274,30582560:papier:4230:30582611,30582939:papier:4230:30582967,30583323:papier:4230:30583421,30583944:papier:4230:30583999,30584433:papier:4230:30584525,30584790:papier:4230:30584822,30584956:papier:4230:30584972,30585085:papier:4230:30585144,30585420:papier:4230:30585503,30585422:papier:4230:30585436,30585423:papier:4230:30585464,30585636:papier:4230:30585700,30586496:papier:4230:30586507,30586658:papier:4230:30586683,30599642:papier:4230:30600765,30599643:papier:4230:30600585,30599646:papier:4230:30600509,30599647:papier:4230:30600550,30599651:papier:4230:30601964,30599654:papier:4230:30600453,30599655:papier:4230:30600301,30599658:papier:4230:30600263,30599660:papier:4230:30601995,30599662:papier:4230:30600335,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028439679620058354, 'nb_photo': 1496, 'list_port_cont': '30579145,30580091,30580203,30580382,30580736,30580999,30581321,30581684,30581914,30585139,30585506,30585696,30586509,30586681,30599811,30599853,30599881,30599926,30599984,30600036,30600075,30600100,30600183,30600333,30601829,30613982,30614018,30614075,30614154,30614192,30614236,30614272,30614308,30614346,30614375,30614430,30614525,30614594,30614671,30614705,30616437,30616641,30629810,30629920,30629971,30630059,30630121,30630186,30630369,30630404,30630487,30630508,30630598,30630641,30630701,30630758,30630886,30630984,30631156,30631209,30631331,30632739,30653123,30653159,30653195,30653312,30653400,30653470,30653510,30653567,30653614,30653695,30653861,30655869,30655988,30656309,30656530,30657639,30657832,30658739,30659398,30659434,30660003,30660330,30661086,30661209,30662248,30662282,30662464,30663357,30663587,30665796,30665830,30665986,30677392,30677508,30677579,30677726,30677792,30677952,30678071,30678133,30678172,30678230,30678266,30678353,30678544,30678594,30678675,30678842,30695568,30695678,30695751,3069578', 'assoc_port': '30578993:30579145,30579990:30580203,30579991:30580091,30580351:30580382,30580704:30580736,30580967:30580999,30581218:30581321,30581511:30581684,30581888:30581914,30585085:30585139,30585420:30585506,30585636:30585696,30586496:30586509,30586658:30586681,30599662:30600333,30599667:30600075,30599668:30600036,30599670:30600183,30599673:30600100,30599676:30599984,30599677:30599881,30599682:30599811,30599683:30599926,30599688:30599853,30601761:30601829,30613749:30614705,30613766:30614308,30613768:30614272,30613770:30614671,30613772:30614525,30613773:30614594,30613775:30614430,30613776:30614375,30613778:30614018,30613779:30614192,30613780:30614346,30613781:30613982,30613782:30614236,30613783:30614154,30613784:30614075,30616414:30616437,30616604:30616641,30629649:30631209,30629653:30631156,30629660:30631331,30629668:30630758,30629672:30630598,30629678:30629810,30629686:30630984,30629692:30630886,30629698:30630487,30629705:30630508,30629709:30630701,30629716:30630641,30629721:30630369,30629726:30630404,30629732:3063012', 'assoc_mat': '30578993:pehd:4230:30579145,30579990:pehd:4230:30580203,30579991:pehd:4230:30580091,30580351:pehd:4230:30580382,30580704:pehd:4230:30580736,30580967:pehd:4230:30580999,30581218:pehd:4230:30581321,30581511:pehd:4230:30581684,30581888:pehd:4230:30581914,30585085:pehd:4230:30585139,30585420:pehd:4230:30585506,30585636:pehd:4230:30585696,30586496:pehd:4230:30586509,30586658:pehd:4230:30586681,30599662:pehd:4230:30600333,30599667:pehd:4230:30600075,30599668:pehd:4230:30600036,30599670:pehd:4230:30600183,30599673:pehd:4230:30600100,30599676:pehd:4230:30599984,30599677:pehd:4230:30599881,30599682:pehd:4230:30599811,30599683:pehd:4230:30599926,30599688:pehd:4230:30599853,30601761:pehd:4230:30601829,30613749:pehd:4230:30614705,30613766:pehd:4230:30614308,30613768:pehd:4230:30614272,30613770:pehd:4230:30614671,30613772:pehd:4230:30614525,30613773:pehd:4230:30614594,30613775:pehd:4230:30614430,30613776:pehd:4230:30614375,30613778:pehd:4230:30614018,30613779:pehd:4230:30614192,30613780:pehd:4230:30614346,30613781:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02493658014671728, 'nb_photo': 31880, 'list_port_cont': '30579138,30580097,30580201,30580380,30580741,30581013,30581319,30581678,30581918,30582289,30582612,30582965,30583414,30584005,30584524,30584826,30584979,30585145,30585434,30585469,30585515,30585697,30586517,30586676,30599756,30599805,30599842,30599883,30599923,30599966,30599994,30600042,30600072,30600090,30600186,30600210,30600264,30600288,30600329,30600456,30600512,30600545,30600588,30600767,30601582,30601828,30601961,30601994,30613944,30613978,30614012,30614071,30614127,30614142,30614194,30614230,30614263,30614307,30614344,30614384,30614417,30614432,30614529,30614557,30614600,30614616,30614669,30614702,30614742,30614817,30616429,30616647,30629814,30629917,30629966,30630068,30630112,30630159,30630195,30630371,30630406,30630492,30630504,30630602,30630659,30630707,30630764,30630890,30630980,30631019,30631098,30631157,30631207,30631337,30632744,30633414,30652999,30653121,30653151,30653194,30653213,30653319,30653389,30653475,30653524,30653568,30653613,30653702,30653824,30653869,30653901,30653972,30654031,3065412', 'assoc_port': '30578993:30579138,30579990:30580201,30579991:30580097,30580351:30580380,30580704:30580741,30580967:30581013,30581218:30581319,30581511:30581678,30581888:30581918,30582201:30582289,30582560:30582612,30582939:30582965,30583323:30583414,30583944:30584005,30584433:30584524,30584790:30584826,30584956:30584979,30585085:30585145,30585420:30585515,30585422:30585434,30585423:30585469,30585636:30585697,30586496:30586517,30586658:30586676,30599642:30600767,30599643:30600588,30599646:30600512,30599647:30600545,30599651:30601961,30599654:30600456,30599655:30600288,30599658:30600264,30599660:30601994,30599662:30600329,30599665:30600210,30599667:30600072,30599668:30600042,30599670:30600186,30599673:30600090,30599676:30599994,30599677:30599883,30599679:30599966,30599682:30599805,30599683:30599923,30599686:30599756,30599688:30599842,30601506:30601582,30601761:30601828,30613749:30614702,30613752:30614742,30613755:30614817,30613758:30614557,30613761:30614417,30613764:30614616,30613766:30614307,30613768:30614263,30613770:3061466', 'assoc_mat': '30578993:pet_clair:4230:30579138,30579990:pet_clair:4230:30580201,30579991:pet_clair:4230:30580097,30580351:pet_clair:4230:30580380,30580704:pet_clair:4230:30580741,30580967:pet_clair:4230:30581013,30581218:pet_clair:4230:30581319,30581511:pet_clair:4230:30581678,30581888:pet_clair:4230:30581918,30582201:pet_clair:4230:30582289,30582560:pet_clair:4230:30582612,30582939:pet_clair:4230:30582965,30583323:pet_clair:4230:30583414,30583944:pet_clair:4230:30584005,30584433:pet_clair:4230:30584524,30584790:pet_clair:4230:30584826,30584956:pet_clair:4230:30584979,30585085:pet_clair:4230:30585145,30585420:pet_clair:4230:30585515,30585422:pet_clair:4230:30585434,30585423:pet_clair:4230:30585469,30585636:pet_clair:4230:30585697,30586496:pet_clair:4230:30586517,30586658:pet_clair:4230:30586676,30599642:pet_clair:4230:30600767,30599643:pet_clair:4230:30600588,30599646:pet_clair:4230:30600512,30599647:pet_clair:4230:30600545,30599651:pet_clair:4230:30601961,30599654:pet_clair:4230:30600456,30599655:pet_clair:4230:30600288,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026009608755777317, 'nb_photo': 1098, 'list_port_cont': '30580095,30580740,30581320,30581927,30584526,30584827,30584971,30585141,30585478,30586677,30599804,30599927,30599957,30600068,30600092,30600185,30600218,30600261,30601965,30602000,30613948,30613980,30614011,30614070,30614123,30614160,30614196,30614237,30614264,30614347,30614419,30614444,30614523,30614561,30614598,30614610,30614670,30614745,30614814,30616434,30616640,30629809,30629921,30630106,30630149,30630187,30630372,30630398,30630489,30630603,30630703,30630763,30630895,30630986,30631020,30631160,30631201,30631335,30653108,30653155,30653203,30653315,30653402,30653474,30653517,30653571,30653604,30653705,30653847,30653907,30654032,30655981,30656311,30657652,30657827,30658284,30659387,30659428,30661089,30661219,30662238,30662281,30662461,30663353,30665827,30677509,30677575,30677741,30677793,30677957,30678065,30678167,30678220,30678255,30678537,30678669,30695681,30695853,30696041,30696733,30704452,30704729,30704798,30704870,30705017,30705091,30705301,30705401,30705555,30705591,30705624,30705733,30705875,3071499', 'assoc_port': '30579991:30580095,30580704:30580740,30581218:30581320,30581888:30581927,30584433:30584526,30584790:30584827,30584956:30584971,30585085:30585141,30585423:30585478,30586658:30586677,30599651:30601965,30599658:30600261,30599660:30602000,30599665:30600218,30599667:30600068,30599670:30600185,30599673:30600092,30599679:30599957,30599682:30599804,30599683:30599927,30613752:30614745,30613755:30614814,30613758:30614561,30613761:30614419,30613764:30614610,30613768:30614264,30613770:30614670,30613772:30614523,30613773:30614598,30613775:30614444,30613777:30614123,30613778:30614011,30613779:30614196,30613780:30614347,30613781:30613980,30613782:30614237,30613783:30614160,30613784:30614070,30613785:30613948,30616414:30616434,30616604:30616640,30629649:30631201,30629653:30631160,30629660:30631335,30629663:30631020,30629668:30630763,30629672:30630603,30629678:30629809,30629686:30630986,30629692:30630895,30629698:30630489,30629709:30630703,30629721:30630372,30629726:30630398,30629732:30630106,30629735:30630149,30629743:3063018', 'assoc_mat': '30579991:pet_fonce:4230:30580095,30580704:pet_fonce:4230:30580740,30581218:pet_fonce:4230:30581320,30581888:pet_fonce:4230:30581927,30584433:pet_fonce:4230:30584526,30584790:pet_fonce:4230:30584827,30584956:pet_fonce:4230:30584971,30585085:pet_fonce:4230:30585141,30585423:pet_fonce:4230:30585478,30586658:pet_fonce:4230:30586677,30599651:pet_fonce:4230:30601965,30599658:pet_fonce:4230:30600261,30599660:pet_fonce:4230:30602000,30599665:pet_fonce:4230:30600218,30599667:pet_fonce:4230:30600068,30599670:pet_fonce:4230:30600185,30599673:pet_fonce:4230:30600092,30599679:pet_fonce:4230:30599957,30599682:pet_fonce:4230:30599804,30599683:pet_fonce:4230:30599927,30613752:pet_fonce:4230:30614745,30613755:pet_fonce:4230:30614814,30613758:pet_fonce:4230:30614561,30613761:pet_fonce:4230:30614419,30613764:pet_fonce:4230:30614610,30613768:pet_fonce:4230:30614264,30613770:pet_fonce:4230:30614670,30613772:pet_fonce:4230:30614523,30613773:pet_fonce:4230:30614598,30613775:pet_fonce:4230:30614444,30613777:pet_fonce:4230:30614123,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(2935051,2936594,2938331,2940109,2943522,2944695,2945781,2946571,2947683,2948818,2950252,2951583,2952551,2953224,2954937,2956523,2958004,2959610,2961653,2962851,2963392,2965024,2966614,2968222,2969000,2969722,2970308,2970814,2971485,2972146)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842594, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579146,30580089,30580200,30580387,30580724,30581001,30581309,30581670,30581925,30582270,30582608,30582959,30583412,30584006,30584514,30584821,30584973,30585128,30585440,30585480,30585509,30585693,30586508,30586679,30599761,30599812,30599843,30599880,30599919,30599960,30600004,30600037,30600078,30600084,30600174,30600223,30600256,30600292,30600321,30600445,30600504,30600539,30600578,30600766,30601569,30601822,30601953,30601988,30613949,30613976,30614009,30614065,30614113,30614144,30614186,30614233,30614266,30614293,30614335,30614380,30614415,30614451,30614526,30614549,30614595,30614612,30614663,30614698,30614737,30614802,30616436,30616633,30629815,30629906,30629962,30630057,30630111,30630146,30630188,30630363,30630400,30630488,30630509,30630610,30630661,30630702,30630762,30630877,30630981,30631024,30631089,30631155,30631198,30631325,30632729,30633419,30652998,30653115,30653156,30653182,30653209,30653314,30653397,30653477,30653526,30653579,30653607,30653694,30653829,30653867,30653893,30653982,30654036,3065411 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842595, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579143,30580087,30580206,30580385,30580739,30581012,30581322,30581676,30581923,30582269,30582605,30582968,30583411,30584008,30584530,30584820,30584978,30585134,30585437,30585466,30585511,30585701,30586516,30586678,30599754,30599809,30599852,30599878,30599929,30599970,30600002,30600040,30600076,30600102,30600187,30600217,30600254,30600295,30600336,30600458,30600500,30600538,30600581,30600768,30601579,30601819,30601966,30601999,30613947,30613973,30614017,30614074,30614126,30614138,30614193,30614235,30614273,30614303,30614339,30614377,30614418,30614455,30614528,30614564,30614601,30614618,30614664,30614696,30614743,30614815,30616432,30616645,30629802,30629916,30629967,30630064,30630117,30630147,30630189,30630373,30630409,30630486,30630507,30630606,30630643,30630698,30630757,30630888,30630983,30631017,30631094,30631154,30631202,30631334,30632732,30633418,30653002,30653113,30653152,30653202,30653212,30653320,30653392,30653476,30653521,30653566,30653606,30653707,30653833,30653855,30653906,30653965,30654025,3065412 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842596, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579142,30580194,30580384,30580737,30581315,30581671,30581919,30582285,30582613,30583413,30584517,30584964,30585140,30585439,30585694,30586502,30586684,30599749,30599854,30599885,30599921,30599953,30600033,30600062,30600173,30600290,30600328,30600446,30600514,30600575,30601821,30601960,30601989,30613940,30613970,30614013,30614067,30614119,30614148,30614200,30614229,30614267,30614333,30614376,30614412,30614548,30614590,30614656,30616426,30616636,30629813,30629905,30629956,30630053,30630115,30630160,30630192,30630358,30630395,30630483,30630500,30630604,30630649,30630697,30630878,30630982,30631015,30631088,30631147,30631211,30631320,30632734,30633415,30652995,30653116,30653149,30653200,30653205,30653318,30653401,30653469,30653519,30653572,30653603,30653706,30653825,30653870,30653895,30653977,30654124,30654157,30654227,30654375,30655615,30655872,30655982,30656305,30656516,30657097,30657547,30657651,30657819,30658269,30658727,30659389,30659419,30659989,30660329,30661077,30661216,30662245,30662277,30662469,3066335 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842597, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579139,30580093,30580207,30580388,30580738,30581007,30581317,30581679,30581921,30582274,30582611,30582967,30583421,30583999,30584525,30584822,30584972,30585144,30585436,30585464,30585503,30585700,30586507,30586683,30599757,30599815,30599851,30599888,30599934,30599964,30599992,30600041,30600069,30600094,30600179,30600213,30600263,30600301,30600335,30600453,30600509,30600550,30600585,30600765,30601583,30601825,30601964,30601995,30613942,30613984,30614014,30614072,30614129,30614158,30614199,30614232,30614271,30614310,30614337,30614383,30614420,30614447,30614524,30614558,30614592,30614608,30614673,30614706,30614735,30614805,30616435,30616646,30629812,30629915,30629974,30630060,30630119,30630153,30630196,30630367,30630402,30630490,30630510,30630608,30630663,30630700,30630754,30630896,30630987,30631026,30631093,30631151,30631208,30631336,30632746,30633412,30653000,30653118,30653153,30653196,30653199,30653310,30653398,30653467,30653513,30653577,30653599,30653704,30653832,30653865,30653903,30653976,30654034,3065412 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842598, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579145,30580091,30580203,30580382,30580736,30580999,30581321,30581684,30581914,30585139,30585506,30585696,30586509,30586681,30599811,30599853,30599881,30599926,30599984,30600036,30600075,30600100,30600183,30600333,30601829,30613982,30614018,30614075,30614154,30614192,30614236,30614272,30614308,30614346,30614375,30614430,30614525,30614594,30614671,30614705,30616437,30616641,30629810,30629920,30629971,30630059,30630121,30630186,30630369,30630404,30630487,30630508,30630598,30630641,30630701,30630758,30630886,30630984,30631156,30631209,30631331,30632739,30653123,30653159,30653195,30653312,30653400,30653470,30653510,30653567,30653614,30653695,30653861,30655869,30655988,30656309,30656530,30657639,30657832,30658739,30659398,30659434,30660003,30660330,30661086,30661209,30662248,30662282,30662464,30663357,30663587,30665796,30665830,30665986,30677392,30677508,30677579,30677726,30677792,30677952,30678071,30678133,30678172,30678230,30678266,30678353,30678544,30678594,30678675,30678842,30695568,30695678,30695751,3069578 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842599, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579138,30580097,30580201,30580380,30580741,30581013,30581319,30581678,30581918,30582289,30582612,30582965,30583414,30584005,30584524,30584826,30584979,30585145,30585434,30585469,30585515,30585697,30586517,30586676,30599756,30599805,30599842,30599883,30599923,30599966,30599994,30600042,30600072,30600090,30600186,30600210,30600264,30600288,30600329,30600456,30600512,30600545,30600588,30600767,30601582,30601828,30601961,30601994,30613944,30613978,30614012,30614071,30614127,30614142,30614194,30614230,30614263,30614307,30614344,30614384,30614417,30614432,30614529,30614557,30614600,30614616,30614669,30614702,30614742,30614817,30616429,30616647,30629814,30629917,30629966,30630068,30630112,30630159,30630195,30630371,30630406,30630492,30630504,30630602,30630659,30630707,30630764,30630890,30630980,30631019,30631098,30631157,30631207,30631337,30632744,30633414,30652999,30653121,30653151,30653194,30653213,30653319,30653389,30653475,30653524,30653568,30653613,30653702,30653824,30653869,30653901,30653972,30654031,3065412 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842600, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30580095,30580740,30581320,30581927,30584526,30584827,30584971,30585141,30585478,30586677,30599804,30599927,30599957,30600068,30600092,30600185,30600218,30600261,30601965,30602000,30613948,30613980,30614011,30614070,30614123,30614160,30614196,30614237,30614264,30614347,30614419,30614444,30614523,30614561,30614598,30614610,30614670,30614745,30614814,30616434,30616640,30629809,30629921,30630106,30630149,30630187,30630372,30630398,30630489,30630603,30630703,30630763,30630895,30630986,30631020,30631160,30631201,30631335,30653108,30653155,30653203,30653315,30653402,30653474,30653517,30653571,30653604,30653705,30653847,30653907,30654032,30655981,30656311,30657652,30657827,30658284,30659387,30659428,30661089,30661219,30662238,30662281,30662461,30663353,30665827,30677509,30677575,30677741,30677793,30677957,30678065,30678167,30678220,30678255,30678537,30678669,30695681,30695853,30696041,30696733,30704452,30704729,30704798,30704870,30705017,30705091,30705301,30705401,30705555,30705591,30705624,30705733,30705875,3071499 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30842594,30842595,30842596,30842597,30842598,30842599,30842600?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-03-01' and date <= '2026-03-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2209,),), 'unwanted_material_monthly_percentage': ((0.759692022982996,),), 'material_repartition': (('incineration', 2209),), 'material_dict': {'incineration': 2209}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 3, 1), 0.8083737783543572, 3), (datetime.date(2026, 3, 2), 0.8015510043197223, 4), (datetime.date(2026, 3, 3), 0.7657218717305813, 3), (datetime.date(2026, 3, 4), 0.7668661785397323, 2), (datetime.date(2026, 3, 5), 0.7705045100921449, 4), (datetime.date(2026, 3, 6), 0.7556694689773618, 3), (datetime.date(2026, 3, 7), 0.7399445109700926, 3), (datetime.date(2026, 3, 9), 0.7625139927076214, 4), (datetime.date(2026, 3, 10), 0.7316615263463667, 1), (datetime.date(2026, 3, 11), 0.725648045064853, 3), (datetime.date(2026, 3, 12), 0.7244969665299009, 2), (datetime.date(2026, 3, 13), 0.7164458926787798, 4), (datetime.date(2026, 3, 14), 0.7281927713606506, 3), (datetime.date(2026, 3, 15), 0.7548733737763847, 2), (datetime.date(2026, 3, 16), 0.7617056207693037, 1), (datetime.date(2026, 3, 17), 0.7455089206169031, 3), (datetime.date(2026, 3, 18), 0.7085252274370417, 1), (datetime.date(2026, 3, 19), 0.7335525888148292, 3), (datetime.date(2026, 3, 20), 0.7487844571854089, 3), (datetime.date(2026, 3, 21), 0.7451090637949987, 3), (datetime.date(2026, 3, 22), 0.7854010558066281, 4), (datetime.date(2026, 3, 23), 0.8071339051218194, 4), (datetime.date(2026, 3, 24), 0.7612280472577949, 3), (datetime.date(2026, 3, 25), 0.7915244498038404, 3), (datetime.date(2026, 3, 26), 0.724954305630967, 4), (datetime.date(2026, 3, 27), 0.7083830601740028, 4), (datetime.date(2026, 3, 28), 0.7493172691792059, 4), (datetime.date(2026, 3, 29), 0.8250744883641435, 3), (datetime.date(2026, 3, 30), 0.8217808989774583, 4), (datetime.date(2026, 3, 31), 0.7939761104083737, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 3, 1), 0.8083737783543572, 3), (datetime.date(2026, 3, 2), 0.8015510043197223, 4), (datetime.date(2026, 3, 3), 0.7657218717305813, 3), (datetime.date(2026, 3, 4), 0.7668661785397323, 2), (datetime.date(2026, 3, 5), 0.7705045100921449, 4), (datetime.date(2026, 3, 6), 0.7556694689773618, 3), (datetime.date(2026, 3, 7), 0.7399445109700926, 3), (datetime.date(2026, 3, 9), 0.7625139927076214, 4), (datetime.date(2026, 3, 10), 0.7316615263463667, 1), (datetime.date(2026, 3, 11), 0.725648045064853, 3), (datetime.date(2026, 3, 12), 0.7244969665299009, 2), (datetime.date(2026, 3, 13), 0.7164458926787798, 4), (datetime.date(2026, 3, 14), 0.7281927713606506, 3), (datetime.date(2026, 3, 15), 0.7548733737763847, 2), (datetime.date(2026, 3, 16), 0.7617056207693037, 1), (datetime.date(2026, 3, 17), 0.7455089206169031, 3), (datetime.date(2026, 3, 18), 0.7085252274370417, 1), (datetime.date(2026, 3, 19), 0.7335525888148292, 3), (datetime.date(2026, 3, 20), 0.7487844571854089, 3), (datetime.date(2026, 3, 21), 0.7451090637949987, 3), (datetime.date(2026, 3, 22), 0.7854010558066281, 4), (datetime.date(2026, 3, 23), 0.8071339051218194, 4), (datetime.date(2026, 3, 24), 0.7612280472577949, 3), (datetime.date(2026, 3, 25), 0.7915244498038404, 3), (datetime.date(2026, 3, 26), 0.724954305630967, 4), (datetime.date(2026, 3, 27), 0.7083830601740028, 4), (datetime.date(2026, 3, 28), 0.7493172691792059, 4), (datetime.date(2026, 3, 29), 0.8250744883641435, 3), (datetime.date(2026, 3, 30), 0.8217808989774583, 4), (datetime.date(2026, 3, 31), 0.7939761104083737, 2))}, 'quality_array': [['-7.01350046093184', '01032026'], ['-6.8192615892771515', '02032026'], ['-6.917132834303172', '03032026'], ['-7.057977986085337', '04032026'], ['-7.094438231087323', '05032026'], ['-7.056359581582929', '06032026'], ['-7.01750731474685', '07032026'], ['-7.0051058224527605', '09032026'], ['-7.089813716088611', '10032026'], ['-7.268206567387244', '11032026'], ['-6.904271065374173', '12032026'], ['-7.096636361265769', '13032026'], ['-7.2526117672166865', '14032026'], ['-7.021985004277592', '15032026'], ['-6.56000551537586', '16032026'], ['-6.946892277473504', '17032026'], ['-6.777890397697568', '18032026'], ['-6.611125176096546', '19032026'], ['-6.7872258041254625', '20032026'], ['-6.823778115582026', '21032026'], ['-6.95621240100934', '22032026'], ['-6.51843883226731', '23032026'], ['-6.441397966227498', '24032026'], ['-6.717647928623908', '25032026'], ['-6.87409695083838', '26032026'], ['-6.886114426535708', '27032026'], ['-6.789843032980561', '28032026'], ['-6.966481935903355', '29032026'], ['-6.585940527345548', '30032026'], ['-6.612211847400993', '31032026']], 'number_of_batch': ((673,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013551222396667222, 'nb_photo': 18609, 'list_port_cont': '30579146,30580089,30580200,30580387,30580724,30581001,30581309,30581670,30581925,30582270,30582608,30582959,30583412,30584006,30584514,30584821,30584973,30585128,30585440,30585480,30585509,30585693,30586508,30586679,30599761,30599812,30599843,30599880,30599919,30599960,30600004,30600037,30600078,30600084,30600174,30600223,30600256,30600292,30600321,30600445,30600504,30600539,30600578,30600766,30601569,30601822,30601953,30601988,30613949,30613976,30614009,30614065,30614113,30614144,30614186,30614233,30614266,30614293,30614335,30614380,30614415,30614451,30614526,30614549,30614595,30614612,30614663,30614698,30614737,30614802,30616436,30616633,30629815,30629906,30629962,30630057,30630111,30630146,30630188,30630363,30630400,30630488,30630509,30630610,30630661,30630702,30630762,30630877,30630981,30631024,30631089,30631155,30631198,30631325,30632729,30633419,30652998,30653115,30653156,30653182,30653209,30653314,30653397,30653477,30653526,30653579,30653607,30653694,30653829,30653867,30653893,30653982,30654036,3065411', 'assoc_port': '30578993:30579146,30579990:30580200,30579991:30580089,30580351:30580387,30580704:30580724,30580967:30581001,30581218:30581309,30581511:30581670,30581888:30581925,30582201:30582270,30582560:30582608,30582939:30582959,30583323:30583412,30583944:30584006,30584433:30584514,30584790:30584821,30584956:30584973,30585085:30585128,30585420:30585509,30585422:30585440,30585423:30585480,30585636:30585693,30586496:30586508,30586658:30586679,30599642:30600766,30599643:30600578,30599646:30600504,30599647:30600539,30599651:30601953,30599654:30600445,30599655:30600292,30599658:30600256,30599660:30601988,30599662:30600321,30599665:30600223,30599667:30600078,30599668:30600037,30599670:30600174,30599673:30600084,30599676:30600004,30599677:30599880,30599679:30599960,30599682:30599812,30599683:30599919,30599686:30599761,30599688:30599843,30601506:30601569,30601761:30601822,30613749:30614698,30613752:30614737,30613755:30614802,30613758:30614549,30613761:30614415,30613764:30614612,30613766:30614293,30613768:30614266,30613770:3061466', 'assoc_mat': '30578993:autre:4230:30579146,30579990:autre:4230:30580200,30579991:autre:4230:30580089,30580351:autre:4230:30580387,30580704:autre:4230:30580724,30580967:autre:4230:30581001,30581218:autre:4230:30581309,30581511:autre:4230:30581670,30581888:autre:4230:30581925,30582201:autre:4230:30582270,30582560:autre:4230:30582608,30582939:autre:4230:30582959,30583323:autre:4230:30583412,30583944:autre:4230:30584006,30584433:autre:4230:30584514,30584790:autre:4230:30584821,30584956:autre:4230:30584973,30585085:autre:4230:30585128,30585420:autre:4230:30585509,30585422:autre:4230:30585440,30585423:autre:4230:30585480,30585636:autre:4230:30585693,30586496:autre:4230:30586508,30586658:autre:4230:30586679,30599642:autre:4230:30600766,30599643:autre:4230:30600578,30599646:autre:4230:30600504,30599647:autre:4230:30600539,30599651:autre:4230:30601953,30599654:autre:4230:30600445,30599655:autre:4230:30600292,30599658:autre:4230:30600256,30599660:autre:4230:30601988,30599662:autre:4230:30600321,30599665:autre:4230:30600223,30599667:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03700224619079674, 'nb_photo': 96339, 'list_port_cont': '30579143,30580087,30580206,30580385,30580739,30581012,30581322,30581676,30581923,30582269,30582605,30582968,30583411,30584008,30584530,30584820,30584978,30585134,30585437,30585466,30585511,30585701,30586516,30586678,30599754,30599809,30599852,30599878,30599929,30599970,30600002,30600040,30600076,30600102,30600187,30600217,30600254,30600295,30600336,30600458,30600500,30600538,30600581,30600768,30601579,30601819,30601966,30601999,30613947,30613973,30614017,30614074,30614126,30614138,30614193,30614235,30614273,30614303,30614339,30614377,30614418,30614455,30614528,30614564,30614601,30614618,30614664,30614696,30614743,30614815,30616432,30616645,30629802,30629916,30629967,30630064,30630117,30630147,30630189,30630373,30630409,30630486,30630507,30630606,30630643,30630698,30630757,30630888,30630983,30631017,30631094,30631154,30631202,30631334,30632732,30633418,30653002,30653113,30653152,30653202,30653212,30653320,30653392,30653476,30653521,30653566,30653606,30653707,30653833,30653855,30653906,30653965,30654025,3065412', 'assoc_port': '30578993:30579143,30579990:30580206,30579991:30580087,30580351:30580385,30580704:30580739,30580967:30581012,30581218:30581322,30581511:30581676,30581888:30581923,30582201:30582269,30582560:30582605,30582939:30582968,30583323:30583411,30583944:30584008,30584433:30584530,30584790:30584820,30584956:30584978,30585085:30585134,30585420:30585511,30585422:30585437,30585423:30585466,30585636:30585701,30586496:30586516,30586658:30586678,30599642:30600768,30599643:30600581,30599646:30600500,30599647:30600538,30599651:30601966,30599654:30600458,30599655:30600295,30599658:30600254,30599660:30601999,30599662:30600336,30599665:30600217,30599667:30600076,30599668:30600040,30599670:30600187,30599673:30600102,30599676:30600002,30599677:30599878,30599679:30599970,30599682:30599809,30599683:30599929,30599686:30599754,30599688:30599852,30601506:30601579,30601761:30601819,30613749:30614696,30613752:30614743,30613755:30614815,30613758:30614564,30613761:30614418,30613764:30614618,30613766:30614303,30613768:30614273,30613770:3061466', 'assoc_mat': '30578993:carton:4230:30579143,30579990:carton:4230:30580206,30579991:carton:4230:30580087,30580351:carton:4230:30580385,30580704:carton:4230:30580739,30580967:carton:4230:30581012,30581218:carton:4230:30581322,30581511:carton:4230:30581676,30581888:carton:4230:30581923,30582201:carton:4230:30582269,30582560:carton:4230:30582605,30582939:carton:4230:30582968,30583323:carton:4230:30583411,30583944:carton:4230:30584008,30584433:carton:4230:30584530,30584790:carton:4230:30584820,30584956:carton:4230:30584978,30585085:carton:4230:30585134,30585420:carton:4230:30585511,30585422:carton:4230:30585437,30585423:carton:4230:30585466,30585636:carton:4230:30585701,30586496:carton:4230:30586516,30586658:carton:4230:30586678,30599642:carton:4230:30600768,30599643:carton:4230:30600581,30599646:carton:4230:30600500,30599647:carton:4230:30600538,30599651:carton:4230:30601966,30599654:carton:4230:30600458,30599655:carton:4230:30600295,30599658:carton:4230:30600254,30599660:carton:4230:30601999,30599662:carton:4230:30600336,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010737123444910723, 'nb_photo': 1836, 'list_port_cont': '30579142,30580194,30580384,30580737,30581315,30581671,30581919,30582285,30582613,30583413,30584517,30584964,30585140,30585439,30585694,30586502,30586684,30599749,30599854,30599885,30599921,30599953,30600033,30600062,30600173,30600290,30600328,30600446,30600514,30600575,30601821,30601960,30601989,30613940,30613970,30614013,30614067,30614119,30614148,30614200,30614229,30614267,30614333,30614376,30614412,30614548,30614590,30614656,30616426,30616636,30629813,30629905,30629956,30630053,30630115,30630160,30630192,30630358,30630395,30630483,30630500,30630604,30630649,30630697,30630878,30630982,30631015,30631088,30631147,30631211,30631320,30632734,30633415,30652995,30653116,30653149,30653200,30653205,30653318,30653401,30653469,30653519,30653572,30653603,30653706,30653825,30653870,30653895,30653977,30654124,30654157,30654227,30654375,30655615,30655872,30655982,30656305,30656516,30657097,30657547,30657651,30657819,30658269,30658727,30659389,30659419,30659989,30660329,30661077,30661216,30662245,30662277,30662469,3066335', 'assoc_port': '30578993:30579142,30579990:30580194,30580351:30580384,30580704:30580737,30581218:30581315,30581511:30581671,30581888:30581919,30582201:30582285,30582560:30582613,30583323:30583413,30584433:30584517,30584956:30584964,30585085:30585140,30585422:30585439,30585636:30585694,30586496:30586502,30586658:30586684,30599643:30600575,30599646:30600514,30599651:30601960,30599654:30600446,30599655:30600290,30599660:30601989,30599662:30600328,30599667:30600062,30599668:30600033,30599670:30600173,30599677:30599885,30599679:30599953,30599683:30599921,30599686:30599749,30599688:30599854,30601761:30601821,30613758:30614548,30613761:30614412,30613768:30614267,30613770:30614656,30613773:30614590,30613776:30614376,30613777:30614119,30613778:30614013,30613779:30614200,30613780:30614333,30613781:30613970,30613782:30614229,30613783:30614148,30613784:30614067,30613785:30613940,30616414:30616426,30616604:30616636,30629649:30631211,30629653:30631147,30629660:30631320,30629663:30631015,30629672:30630604,30629678:30629813,30629681:3063108', 'assoc_mat': '30578993:metal:4230:30579142,30579990:metal:4230:30580194,30580351:metal:4230:30580384,30580704:metal:4230:30580737,30581218:metal:4230:30581315,30581511:metal:4230:30581671,30581888:metal:4230:30581919,30582201:metal:4230:30582285,30582560:metal:4230:30582613,30583323:metal:4230:30583413,30584433:metal:4230:30584517,30584956:metal:4230:30584964,30585085:metal:4230:30585140,30585422:metal:4230:30585439,30585636:metal:4230:30585694,30586496:metal:4230:30586502,30586658:metal:4230:30586684,30599643:metal:4230:30600575,30599646:metal:4230:30600514,30599651:metal:4230:30601960,30599654:metal:4230:30600446,30599655:metal:4230:30600290,30599660:metal:4230:30601989,30599662:metal:4230:30600328,30599667:metal:4230:30600062,30599668:metal:4230:30600033,30599670:metal:4230:30600173,30599677:metal:4230:30599885,30599679:metal:4230:30599953,30599683:metal:4230:30599921,30599686:metal:4230:30599749,30599688:metal:4230:30599854,30601761:metal:4230:30601821,30613758:metal:4230:30614548,30613761:metal:4230:30614412,30613768:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1715135762446262, 'nb_photo': 325228, 'list_port_cont': '30579139,30580093,30580207,30580388,30580738,30581007,30581317,30581679,30581921,30582274,30582611,30582967,30583421,30583999,30584525,30584822,30584972,30585144,30585436,30585464,30585503,30585700,30586507,30586683,30599757,30599815,30599851,30599888,30599934,30599964,30599992,30600041,30600069,30600094,30600179,30600213,30600263,30600301,30600335,30600453,30600509,30600550,30600585,30600765,30601583,30601825,30601964,30601995,30613942,30613984,30614014,30614072,30614129,30614158,30614199,30614232,30614271,30614310,30614337,30614383,30614420,30614447,30614524,30614558,30614592,30614608,30614673,30614706,30614735,30614805,30616435,30616646,30629812,30629915,30629974,30630060,30630119,30630153,30630196,30630367,30630402,30630490,30630510,30630608,30630663,30630700,30630754,30630896,30630987,30631026,30631093,30631151,30631208,30631336,30632746,30633412,30653000,30653118,30653153,30653196,30653199,30653310,30653398,30653467,30653513,30653577,30653599,30653704,30653832,30653865,30653903,30653976,30654034,3065412', 'assoc_port': '30578993:30579139,30579990:30580207,30579991:30580093,30580351:30580388,30580704:30580738,30580967:30581007,30581218:30581317,30581511:30581679,30581888:30581921,30582201:30582274,30582560:30582611,30582939:30582967,30583323:30583421,30583944:30583999,30584433:30584525,30584790:30584822,30584956:30584972,30585085:30585144,30585420:30585503,30585422:30585436,30585423:30585464,30585636:30585700,30586496:30586507,30586658:30586683,30599642:30600765,30599643:30600585,30599646:30600509,30599647:30600550,30599651:30601964,30599654:30600453,30599655:30600301,30599658:30600263,30599660:30601995,30599662:30600335,30599665:30600213,30599667:30600069,30599668:30600041,30599670:30600179,30599673:30600094,30599676:30599992,30599677:30599888,30599679:30599964,30599682:30599815,30599683:30599934,30599686:30599757,30599688:30599851,30601506:30601583,30601761:30601825,30613749:30614706,30613752:30614735,30613755:30614805,30613758:30614558,30613761:30614420,30613764:30614608,30613766:30614310,30613768:30614271,30613770:3061467', 'assoc_mat': '30578993:papier:4230:30579139,30579990:papier:4230:30580207,30579991:papier:4230:30580093,30580351:papier:4230:30580388,30580704:papier:4230:30580738,30580967:papier:4230:30581007,30581218:papier:4230:30581317,30581511:papier:4230:30581679,30581888:papier:4230:30581921,30582201:papier:4230:30582274,30582560:papier:4230:30582611,30582939:papier:4230:30582967,30583323:papier:4230:30583421,30583944:papier:4230:30583999,30584433:papier:4230:30584525,30584790:papier:4230:30584822,30584956:papier:4230:30584972,30585085:papier:4230:30585144,30585420:papier:4230:30585503,30585422:papier:4230:30585436,30585423:papier:4230:30585464,30585636:papier:4230:30585700,30586496:papier:4230:30586507,30586658:papier:4230:30586683,30599642:papier:4230:30600765,30599643:papier:4230:30600585,30599646:papier:4230:30600509,30599647:papier:4230:30600550,30599651:papier:4230:30601964,30599654:papier:4230:30600453,30599655:papier:4230:30600301,30599658:papier:4230:30600263,30599660:papier:4230:30601995,30599662:papier:4230:30600335,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028439679620058354, 'nb_photo': 1496, 'list_port_cont': '30579145,30580091,30580203,30580382,30580736,30580999,30581321,30581684,30581914,30585139,30585506,30585696,30586509,30586681,30599811,30599853,30599881,30599926,30599984,30600036,30600075,30600100,30600183,30600333,30601829,30613982,30614018,30614075,30614154,30614192,30614236,30614272,30614308,30614346,30614375,30614430,30614525,30614594,30614671,30614705,30616437,30616641,30629810,30629920,30629971,30630059,30630121,30630186,30630369,30630404,30630487,30630508,30630598,30630641,30630701,30630758,30630886,30630984,30631156,30631209,30631331,30632739,30653123,30653159,30653195,30653312,30653400,30653470,30653510,30653567,30653614,30653695,30653861,30655869,30655988,30656309,30656530,30657639,30657832,30658739,30659398,30659434,30660003,30660330,30661086,30661209,30662248,30662282,30662464,30663357,30663587,30665796,30665830,30665986,30677392,30677508,30677579,30677726,30677792,30677952,30678071,30678133,30678172,30678230,30678266,30678353,30678544,30678594,30678675,30678842,30695568,30695678,30695751,3069578', 'assoc_port': '30578993:30579145,30579990:30580203,30579991:30580091,30580351:30580382,30580704:30580736,30580967:30580999,30581218:30581321,30581511:30581684,30581888:30581914,30585085:30585139,30585420:30585506,30585636:30585696,30586496:30586509,30586658:30586681,30599662:30600333,30599667:30600075,30599668:30600036,30599670:30600183,30599673:30600100,30599676:30599984,30599677:30599881,30599682:30599811,30599683:30599926,30599688:30599853,30601761:30601829,30613749:30614705,30613766:30614308,30613768:30614272,30613770:30614671,30613772:30614525,30613773:30614594,30613775:30614430,30613776:30614375,30613778:30614018,30613779:30614192,30613780:30614346,30613781:30613982,30613782:30614236,30613783:30614154,30613784:30614075,30616414:30616437,30616604:30616641,30629649:30631209,30629653:30631156,30629660:30631331,30629668:30630758,30629672:30630598,30629678:30629810,30629686:30630984,30629692:30630886,30629698:30630487,30629705:30630508,30629709:30630701,30629716:30630641,30629721:30630369,30629726:30630404,30629732:3063012', 'assoc_mat': '30578993:pehd:4230:30579145,30579990:pehd:4230:30580203,30579991:pehd:4230:30580091,30580351:pehd:4230:30580382,30580704:pehd:4230:30580736,30580967:pehd:4230:30580999,30581218:pehd:4230:30581321,30581511:pehd:4230:30581684,30581888:pehd:4230:30581914,30585085:pehd:4230:30585139,30585420:pehd:4230:30585506,30585636:pehd:4230:30585696,30586496:pehd:4230:30586509,30586658:pehd:4230:30586681,30599662:pehd:4230:30600333,30599667:pehd:4230:30600075,30599668:pehd:4230:30600036,30599670:pehd:4230:30600183,30599673:pehd:4230:30600100,30599676:pehd:4230:30599984,30599677:pehd:4230:30599881,30599682:pehd:4230:30599811,30599683:pehd:4230:30599926,30599688:pehd:4230:30599853,30601761:pehd:4230:30601829,30613749:pehd:4230:30614705,30613766:pehd:4230:30614308,30613768:pehd:4230:30614272,30613770:pehd:4230:30614671,30613772:pehd:4230:30614525,30613773:pehd:4230:30614594,30613775:pehd:4230:30614430,30613776:pehd:4230:30614375,30613778:pehd:4230:30614018,30613779:pehd:4230:30614192,30613780:pehd:4230:30614346,30613781:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02493658014671728, 'nb_photo': 31880, 'list_port_cont': '30579138,30580097,30580201,30580380,30580741,30581013,30581319,30581678,30581918,30582289,30582612,30582965,30583414,30584005,30584524,30584826,30584979,30585145,30585434,30585469,30585515,30585697,30586517,30586676,30599756,30599805,30599842,30599883,30599923,30599966,30599994,30600042,30600072,30600090,30600186,30600210,30600264,30600288,30600329,30600456,30600512,30600545,30600588,30600767,30601582,30601828,30601961,30601994,30613944,30613978,30614012,30614071,30614127,30614142,30614194,30614230,30614263,30614307,30614344,30614384,30614417,30614432,30614529,30614557,30614600,30614616,30614669,30614702,30614742,30614817,30616429,30616647,30629814,30629917,30629966,30630068,30630112,30630159,30630195,30630371,30630406,30630492,30630504,30630602,30630659,30630707,30630764,30630890,30630980,30631019,30631098,30631157,30631207,30631337,30632744,30633414,30652999,30653121,30653151,30653194,30653213,30653319,30653389,30653475,30653524,30653568,30653613,30653702,30653824,30653869,30653901,30653972,30654031,3065412', 'assoc_port': '30578993:30579138,30579990:30580201,30579991:30580097,30580351:30580380,30580704:30580741,30580967:30581013,30581218:30581319,30581511:30581678,30581888:30581918,30582201:30582289,30582560:30582612,30582939:30582965,30583323:30583414,30583944:30584005,30584433:30584524,30584790:30584826,30584956:30584979,30585085:30585145,30585420:30585515,30585422:30585434,30585423:30585469,30585636:30585697,30586496:30586517,30586658:30586676,30599642:30600767,30599643:30600588,30599646:30600512,30599647:30600545,30599651:30601961,30599654:30600456,30599655:30600288,30599658:30600264,30599660:30601994,30599662:30600329,30599665:30600210,30599667:30600072,30599668:30600042,30599670:30600186,30599673:30600090,30599676:30599994,30599677:30599883,30599679:30599966,30599682:30599805,30599683:30599923,30599686:30599756,30599688:30599842,30601506:30601582,30601761:30601828,30613749:30614702,30613752:30614742,30613755:30614817,30613758:30614557,30613761:30614417,30613764:30614616,30613766:30614307,30613768:30614263,30613770:3061466', 'assoc_mat': '30578993:pet_clair:4230:30579138,30579990:pet_clair:4230:30580201,30579991:pet_clair:4230:30580097,30580351:pet_clair:4230:30580380,30580704:pet_clair:4230:30580741,30580967:pet_clair:4230:30581013,30581218:pet_clair:4230:30581319,30581511:pet_clair:4230:30581678,30581888:pet_clair:4230:30581918,30582201:pet_clair:4230:30582289,30582560:pet_clair:4230:30582612,30582939:pet_clair:4230:30582965,30583323:pet_clair:4230:30583414,30583944:pet_clair:4230:30584005,30584433:pet_clair:4230:30584524,30584790:pet_clair:4230:30584826,30584956:pet_clair:4230:30584979,30585085:pet_clair:4230:30585145,30585420:pet_clair:4230:30585515,30585422:pet_clair:4230:30585434,30585423:pet_clair:4230:30585469,30585636:pet_clair:4230:30585697,30586496:pet_clair:4230:30586517,30586658:pet_clair:4230:30586676,30599642:pet_clair:4230:30600767,30599643:pet_clair:4230:30600588,30599646:pet_clair:4230:30600512,30599647:pet_clair:4230:30600545,30599651:pet_clair:4230:30601961,30599654:pet_clair:4230:30600456,30599655:pet_clair:4230:30600288,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026009608755777317, 'nb_photo': 1098, 'list_port_cont': '30580095,30580740,30581320,30581927,30584526,30584827,30584971,30585141,30585478,30586677,30599804,30599927,30599957,30600068,30600092,30600185,30600218,30600261,30601965,30602000,30613948,30613980,30614011,30614070,30614123,30614160,30614196,30614237,30614264,30614347,30614419,30614444,30614523,30614561,30614598,30614610,30614670,30614745,30614814,30616434,30616640,30629809,30629921,30630106,30630149,30630187,30630372,30630398,30630489,30630603,30630703,30630763,30630895,30630986,30631020,30631160,30631201,30631335,30653108,30653155,30653203,30653315,30653402,30653474,30653517,30653571,30653604,30653705,30653847,30653907,30654032,30655981,30656311,30657652,30657827,30658284,30659387,30659428,30661089,30661219,30662238,30662281,30662461,30663353,30665827,30677509,30677575,30677741,30677793,30677957,30678065,30678167,30678220,30678255,30678537,30678669,30695681,30695853,30696041,30696733,30704452,30704729,30704798,30704870,30705017,30705091,30705301,30705401,30705555,30705591,30705624,30705733,30705875,3071499', 'assoc_port': '30579991:30580095,30580704:30580740,30581218:30581320,30581888:30581927,30584433:30584526,30584790:30584827,30584956:30584971,30585085:30585141,30585423:30585478,30586658:30586677,30599651:30601965,30599658:30600261,30599660:30602000,30599665:30600218,30599667:30600068,30599670:30600185,30599673:30600092,30599679:30599957,30599682:30599804,30599683:30599927,30613752:30614745,30613755:30614814,30613758:30614561,30613761:30614419,30613764:30614610,30613768:30614264,30613770:30614670,30613772:30614523,30613773:30614598,30613775:30614444,30613777:30614123,30613778:30614011,30613779:30614196,30613780:30614347,30613781:30613980,30613782:30614237,30613783:30614160,30613784:30614070,30613785:30613948,30616414:30616434,30616604:30616640,30629649:30631201,30629653:30631160,30629660:30631335,30629663:30631020,30629668:30630763,30629672:30630603,30629678:30629809,30629686:30630986,30629692:30630895,30629698:30630489,30629709:30630703,30629721:30630372,30629726:30630398,30629732:30630106,30629735:30630149,30629743:3063018', 'assoc_mat': '30579991:pet_fonce:4230:30580095,30580704:pet_fonce:4230:30580740,30581218:pet_fonce:4230:30581320,30581888:pet_fonce:4230:30581927,30584433:pet_fonce:4230:30584526,30584790:pet_fonce:4230:30584827,30584956:pet_fonce:4230:30584971,30585085:pet_fonce:4230:30585141,30585423:pet_fonce:4230:30585478,30586658:pet_fonce:4230:30586677,30599651:pet_fonce:4230:30601965,30599658:pet_fonce:4230:30600261,30599660:pet_fonce:4230:30602000,30599665:pet_fonce:4230:30600218,30599667:pet_fonce:4230:30600068,30599670:pet_fonce:4230:30600185,30599673:pet_fonce:4230:30600092,30599679:pet_fonce:4230:30599957,30599682:pet_fonce:4230:30599804,30599683:pet_fonce:4230:30599927,30613752:pet_fonce:4230:30614745,30613755:pet_fonce:4230:30614814,30613758:pet_fonce:4230:30614561,30613761:pet_fonce:4230:30614419,30613764:pet_fonce:4230:30614610,30613768:pet_fonce:4230:30614264,30613770:pet_fonce:4230:30614670,30613772:pet_fonce:4230:30614523,30613773:pet_fonce:4230:30614598,30613775:pet_fonce:4230:30614444,30613777:pet_fonce:4230:30614123,3'}), 'main_stat': {'nb_photos': 2209}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30842594,30842595,30842596,30842597,30842598,30842599,30842600?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-03', 0.759692022982996),)]} 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': ((2209,),), 'unwanted_material_monthly_percentage': ((0.759692022982996,),), 'material_repartition': (('incineration', 2209),), 'material_dict': {'incineration': 2209}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 3, 1), 0.8083737783543572, 3), (datetime.date(2026, 3, 2), 0.8015510043197223, 4), (datetime.date(2026, 3, 3), 0.7657218717305813, 3), (datetime.date(2026, 3, 4), 0.7668661785397323, 2), (datetime.date(2026, 3, 5), 0.7705045100921449, 4), (datetime.date(2026, 3, 6), 0.7556694689773618, 3), (datetime.date(2026, 3, 7), 0.7399445109700926, 3), (datetime.date(2026, 3, 9), 0.7625139927076214, 4), (datetime.date(2026, 3, 10), 0.7316615263463667, 1), (datetime.date(2026, 3, 11), 0.725648045064853, 3), (datetime.date(2026, 3, 12), 0.7244969665299009, 2), (datetime.date(2026, 3, 13), 0.7164458926787798, 4), (datetime.date(2026, 3, 14), 0.7281927713606506, 3), (datetime.date(2026, 3, 15), 0.7548733737763847, 2), (datetime.date(2026, 3, 16), 0.7617056207693037, 1), (datetime.date(2026, 3, 17), 0.7455089206169031, 3), (datetime.date(2026, 3, 18), 0.7085252274370417, 1), (datetime.date(2026, 3, 19), 0.7335525888148292, 3), (datetime.date(2026, 3, 20), 0.7487844571854089, 3), (datetime.date(2026, 3, 21), 0.7451090637949987, 3), (datetime.date(2026, 3, 22), 0.7854010558066281, 4), (datetime.date(2026, 3, 23), 0.8071339051218194, 4), (datetime.date(2026, 3, 24), 0.7612280472577949, 3), (datetime.date(2026, 3, 25), 0.7915244498038404, 3), (datetime.date(2026, 3, 26), 0.724954305630967, 4), (datetime.date(2026, 3, 27), 0.7083830601740028, 4), (datetime.date(2026, 3, 28), 0.7493172691792059, 4), (datetime.date(2026, 3, 29), 0.8250744883641435, 3), (datetime.date(2026, 3, 30), 0.8217808989774583, 4), (datetime.date(2026, 3, 31), 0.7939761104083737, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 3, 1), 0.8083737783543572, 3), (datetime.date(2026, 3, 2), 0.8015510043197223, 4), (datetime.date(2026, 3, 3), 0.7657218717305813, 3), (datetime.date(2026, 3, 4), 0.7668661785397323, 2), (datetime.date(2026, 3, 5), 0.7705045100921449, 4), (datetime.date(2026, 3, 6), 0.7556694689773618, 3), (datetime.date(2026, 3, 7), 0.7399445109700926, 3), (datetime.date(2026, 3, 9), 0.7625139927076214, 4), (datetime.date(2026, 3, 10), 0.7316615263463667, 1), (datetime.date(2026, 3, 11), 0.725648045064853, 3), (datetime.date(2026, 3, 12), 0.7244969665299009, 2), (datetime.date(2026, 3, 13), 0.7164458926787798, 4), (datetime.date(2026, 3, 14), 0.7281927713606506, 3), (datetime.date(2026, 3, 15), 0.7548733737763847, 2), (datetime.date(2026, 3, 16), 0.7617056207693037, 1), (datetime.date(2026, 3, 17), 0.7455089206169031, 3), (datetime.date(2026, 3, 18), 0.7085252274370417, 1), (datetime.date(2026, 3, 19), 0.7335525888148292, 3), (datetime.date(2026, 3, 20), 0.7487844571854089, 3), (datetime.date(2026, 3, 21), 0.7451090637949987, 3), (datetime.date(2026, 3, 22), 0.7854010558066281, 4), (datetime.date(2026, 3, 23), 0.8071339051218194, 4), (datetime.date(2026, 3, 24), 0.7612280472577949, 3), (datetime.date(2026, 3, 25), 0.7915244498038404, 3), (datetime.date(2026, 3, 26), 0.724954305630967, 4), (datetime.date(2026, 3, 27), 0.7083830601740028, 4), (datetime.date(2026, 3, 28), 0.7493172691792059, 4), (datetime.date(2026, 3, 29), 0.8250744883641435, 3), (datetime.date(2026, 3, 30), 0.8217808989774583, 4), (datetime.date(2026, 3, 31), 0.7939761104083737, 2))}, 'quality_array': [['-7.01350046093184', '01032026'], ['-6.8192615892771515', '02032026'], ['-6.917132834303172', '03032026'], ['-7.057977986085337', '04032026'], ['-7.094438231087323', '05032026'], ['-7.056359581582929', '06032026'], ['-7.01750731474685', '07032026'], ['-7.0051058224527605', '09032026'], ['-7.089813716088611', '10032026'], ['-7.268206567387244', '11032026'], ['-6.904271065374173', '12032026'], ['-7.096636361265769', '13032026'], ['-7.2526117672166865', '14032026'], ['-7.021985004277592', '15032026'], ['-6.56000551537586', '16032026'], ['-6.946892277473504', '17032026'], ['-6.777890397697568', '18032026'], ['-6.611125176096546', '19032026'], ['-6.7872258041254625', '20032026'], ['-6.823778115582026', '21032026'], ['-6.95621240100934', '22032026'], ['-6.51843883226731', '23032026'], ['-6.441397966227498', '24032026'], ['-6.717647928623908', '25032026'], ['-6.87409695083838', '26032026'], ['-6.886114426535708', '27032026'], ['-6.789843032980561', '28032026'], ['-6.966481935903355', '29032026'], ['-6.585940527345548', '30032026'], ['-6.612211847400993', '31032026']], 'number_of_batch': ((673,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013551222396667222, 'nb_photo': 18609, 'list_port_cont': '30579146,30580089,30580200,30580387,30580724,30581001,30581309,30581670,30581925,30582270,30582608,30582959,30583412,30584006,30584514,30584821,30584973,30585128,30585440,30585480,30585509,30585693,30586508,30586679,30599761,30599812,30599843,30599880,30599919,30599960,30600004,30600037,30600078,30600084,30600174,30600223,30600256,30600292,30600321,30600445,30600504,30600539,30600578,30600766,30601569,30601822,30601953,30601988,30613949,30613976,30614009,30614065,30614113,30614144,30614186,30614233,30614266,30614293,30614335,30614380,30614415,30614451,30614526,30614549,30614595,30614612,30614663,30614698,30614737,30614802,30616436,30616633,30629815,30629906,30629962,30630057,30630111,30630146,30630188,30630363,30630400,30630488,30630509,30630610,30630661,30630702,30630762,30630877,30630981,30631024,30631089,30631155,30631198,30631325,30632729,30633419,30652998,30653115,30653156,30653182,30653209,30653314,30653397,30653477,30653526,30653579,30653607,30653694,30653829,30653867,30653893,30653982,30654036,3065411', 'assoc_port': '30578993:30579146,30579990:30580200,30579991:30580089,30580351:30580387,30580704:30580724,30580967:30581001,30581218:30581309,30581511:30581670,30581888:30581925,30582201:30582270,30582560:30582608,30582939:30582959,30583323:30583412,30583944:30584006,30584433:30584514,30584790:30584821,30584956:30584973,30585085:30585128,30585420:30585509,30585422:30585440,30585423:30585480,30585636:30585693,30586496:30586508,30586658:30586679,30599642:30600766,30599643:30600578,30599646:30600504,30599647:30600539,30599651:30601953,30599654:30600445,30599655:30600292,30599658:30600256,30599660:30601988,30599662:30600321,30599665:30600223,30599667:30600078,30599668:30600037,30599670:30600174,30599673:30600084,30599676:30600004,30599677:30599880,30599679:30599960,30599682:30599812,30599683:30599919,30599686:30599761,30599688:30599843,30601506:30601569,30601761:30601822,30613749:30614698,30613752:30614737,30613755:30614802,30613758:30614549,30613761:30614415,30613764:30614612,30613766:30614293,30613768:30614266,30613770:3061466', 'assoc_mat': '30578993:autre:4230:30579146,30579990:autre:4230:30580200,30579991:autre:4230:30580089,30580351:autre:4230:30580387,30580704:autre:4230:30580724,30580967:autre:4230:30581001,30581218:autre:4230:30581309,30581511:autre:4230:30581670,30581888:autre:4230:30581925,30582201:autre:4230:30582270,30582560:autre:4230:30582608,30582939:autre:4230:30582959,30583323:autre:4230:30583412,30583944:autre:4230:30584006,30584433:autre:4230:30584514,30584790:autre:4230:30584821,30584956:autre:4230:30584973,30585085:autre:4230:30585128,30585420:autre:4230:30585509,30585422:autre:4230:30585440,30585423:autre:4230:30585480,30585636:autre:4230:30585693,30586496:autre:4230:30586508,30586658:autre:4230:30586679,30599642:autre:4230:30600766,30599643:autre:4230:30600578,30599646:autre:4230:30600504,30599647:autre:4230:30600539,30599651:autre:4230:30601953,30599654:autre:4230:30600445,30599655:autre:4230:30600292,30599658:autre:4230:30600256,30599660:autre:4230:30601988,30599662:autre:4230:30600321,30599665:autre:4230:30600223,30599667:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03700224619079674, 'nb_photo': 96339, 'list_port_cont': '30579143,30580087,30580206,30580385,30580739,30581012,30581322,30581676,30581923,30582269,30582605,30582968,30583411,30584008,30584530,30584820,30584978,30585134,30585437,30585466,30585511,30585701,30586516,30586678,30599754,30599809,30599852,30599878,30599929,30599970,30600002,30600040,30600076,30600102,30600187,30600217,30600254,30600295,30600336,30600458,30600500,30600538,30600581,30600768,30601579,30601819,30601966,30601999,30613947,30613973,30614017,30614074,30614126,30614138,30614193,30614235,30614273,30614303,30614339,30614377,30614418,30614455,30614528,30614564,30614601,30614618,30614664,30614696,30614743,30614815,30616432,30616645,30629802,30629916,30629967,30630064,30630117,30630147,30630189,30630373,30630409,30630486,30630507,30630606,30630643,30630698,30630757,30630888,30630983,30631017,30631094,30631154,30631202,30631334,30632732,30633418,30653002,30653113,30653152,30653202,30653212,30653320,30653392,30653476,30653521,30653566,30653606,30653707,30653833,30653855,30653906,30653965,30654025,3065412', 'assoc_port': '30578993:30579143,30579990:30580206,30579991:30580087,30580351:30580385,30580704:30580739,30580967:30581012,30581218:30581322,30581511:30581676,30581888:30581923,30582201:30582269,30582560:30582605,30582939:30582968,30583323:30583411,30583944:30584008,30584433:30584530,30584790:30584820,30584956:30584978,30585085:30585134,30585420:30585511,30585422:30585437,30585423:30585466,30585636:30585701,30586496:30586516,30586658:30586678,30599642:30600768,30599643:30600581,30599646:30600500,30599647:30600538,30599651:30601966,30599654:30600458,30599655:30600295,30599658:30600254,30599660:30601999,30599662:30600336,30599665:30600217,30599667:30600076,30599668:30600040,30599670:30600187,30599673:30600102,30599676:30600002,30599677:30599878,30599679:30599970,30599682:30599809,30599683:30599929,30599686:30599754,30599688:30599852,30601506:30601579,30601761:30601819,30613749:30614696,30613752:30614743,30613755:30614815,30613758:30614564,30613761:30614418,30613764:30614618,30613766:30614303,30613768:30614273,30613770:3061466', 'assoc_mat': '30578993:carton:4230:30579143,30579990:carton:4230:30580206,30579991:carton:4230:30580087,30580351:carton:4230:30580385,30580704:carton:4230:30580739,30580967:carton:4230:30581012,30581218:carton:4230:30581322,30581511:carton:4230:30581676,30581888:carton:4230:30581923,30582201:carton:4230:30582269,30582560:carton:4230:30582605,30582939:carton:4230:30582968,30583323:carton:4230:30583411,30583944:carton:4230:30584008,30584433:carton:4230:30584530,30584790:carton:4230:30584820,30584956:carton:4230:30584978,30585085:carton:4230:30585134,30585420:carton:4230:30585511,30585422:carton:4230:30585437,30585423:carton:4230:30585466,30585636:carton:4230:30585701,30586496:carton:4230:30586516,30586658:carton:4230:30586678,30599642:carton:4230:30600768,30599643:carton:4230:30600581,30599646:carton:4230:30600500,30599647:carton:4230:30600538,30599651:carton:4230:30601966,30599654:carton:4230:30600458,30599655:carton:4230:30600295,30599658:carton:4230:30600254,30599660:carton:4230:30601999,30599662:carton:4230:30600336,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010737123444910723, 'nb_photo': 1836, 'list_port_cont': '30579142,30580194,30580384,30580737,30581315,30581671,30581919,30582285,30582613,30583413,30584517,30584964,30585140,30585439,30585694,30586502,30586684,30599749,30599854,30599885,30599921,30599953,30600033,30600062,30600173,30600290,30600328,30600446,30600514,30600575,30601821,30601960,30601989,30613940,30613970,30614013,30614067,30614119,30614148,30614200,30614229,30614267,30614333,30614376,30614412,30614548,30614590,30614656,30616426,30616636,30629813,30629905,30629956,30630053,30630115,30630160,30630192,30630358,30630395,30630483,30630500,30630604,30630649,30630697,30630878,30630982,30631015,30631088,30631147,30631211,30631320,30632734,30633415,30652995,30653116,30653149,30653200,30653205,30653318,30653401,30653469,30653519,30653572,30653603,30653706,30653825,30653870,30653895,30653977,30654124,30654157,30654227,30654375,30655615,30655872,30655982,30656305,30656516,30657097,30657547,30657651,30657819,30658269,30658727,30659389,30659419,30659989,30660329,30661077,30661216,30662245,30662277,30662469,3066335', 'assoc_port': '30578993:30579142,30579990:30580194,30580351:30580384,30580704:30580737,30581218:30581315,30581511:30581671,30581888:30581919,30582201:30582285,30582560:30582613,30583323:30583413,30584433:30584517,30584956:30584964,30585085:30585140,30585422:30585439,30585636:30585694,30586496:30586502,30586658:30586684,30599643:30600575,30599646:30600514,30599651:30601960,30599654:30600446,30599655:30600290,30599660:30601989,30599662:30600328,30599667:30600062,30599668:30600033,30599670:30600173,30599677:30599885,30599679:30599953,30599683:30599921,30599686:30599749,30599688:30599854,30601761:30601821,30613758:30614548,30613761:30614412,30613768:30614267,30613770:30614656,30613773:30614590,30613776:30614376,30613777:30614119,30613778:30614013,30613779:30614200,30613780:30614333,30613781:30613970,30613782:30614229,30613783:30614148,30613784:30614067,30613785:30613940,30616414:30616426,30616604:30616636,30629649:30631211,30629653:30631147,30629660:30631320,30629663:30631015,30629672:30630604,30629678:30629813,30629681:3063108', 'assoc_mat': '30578993:metal:4230:30579142,30579990:metal:4230:30580194,30580351:metal:4230:30580384,30580704:metal:4230:30580737,30581218:metal:4230:30581315,30581511:metal:4230:30581671,30581888:metal:4230:30581919,30582201:metal:4230:30582285,30582560:metal:4230:30582613,30583323:metal:4230:30583413,30584433:metal:4230:30584517,30584956:metal:4230:30584964,30585085:metal:4230:30585140,30585422:metal:4230:30585439,30585636:metal:4230:30585694,30586496:metal:4230:30586502,30586658:metal:4230:30586684,30599643:metal:4230:30600575,30599646:metal:4230:30600514,30599651:metal:4230:30601960,30599654:metal:4230:30600446,30599655:metal:4230:30600290,30599660:metal:4230:30601989,30599662:metal:4230:30600328,30599667:metal:4230:30600062,30599668:metal:4230:30600033,30599670:metal:4230:30600173,30599677:metal:4230:30599885,30599679:metal:4230:30599953,30599683:metal:4230:30599921,30599686:metal:4230:30599749,30599688:metal:4230:30599854,30601761:metal:4230:30601821,30613758:metal:4230:30614548,30613761:metal:4230:30614412,30613768:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1715135762446262, 'nb_photo': 325228, 'list_port_cont': '30579139,30580093,30580207,30580388,30580738,30581007,30581317,30581679,30581921,30582274,30582611,30582967,30583421,30583999,30584525,30584822,30584972,30585144,30585436,30585464,30585503,30585700,30586507,30586683,30599757,30599815,30599851,30599888,30599934,30599964,30599992,30600041,30600069,30600094,30600179,30600213,30600263,30600301,30600335,30600453,30600509,30600550,30600585,30600765,30601583,30601825,30601964,30601995,30613942,30613984,30614014,30614072,30614129,30614158,30614199,30614232,30614271,30614310,30614337,30614383,30614420,30614447,30614524,30614558,30614592,30614608,30614673,30614706,30614735,30614805,30616435,30616646,30629812,30629915,30629974,30630060,30630119,30630153,30630196,30630367,30630402,30630490,30630510,30630608,30630663,30630700,30630754,30630896,30630987,30631026,30631093,30631151,30631208,30631336,30632746,30633412,30653000,30653118,30653153,30653196,30653199,30653310,30653398,30653467,30653513,30653577,30653599,30653704,30653832,30653865,30653903,30653976,30654034,3065412', 'assoc_port': '30578993:30579139,30579990:30580207,30579991:30580093,30580351:30580388,30580704:30580738,30580967:30581007,30581218:30581317,30581511:30581679,30581888:30581921,30582201:30582274,30582560:30582611,30582939:30582967,30583323:30583421,30583944:30583999,30584433:30584525,30584790:30584822,30584956:30584972,30585085:30585144,30585420:30585503,30585422:30585436,30585423:30585464,30585636:30585700,30586496:30586507,30586658:30586683,30599642:30600765,30599643:30600585,30599646:30600509,30599647:30600550,30599651:30601964,30599654:30600453,30599655:30600301,30599658:30600263,30599660:30601995,30599662:30600335,30599665:30600213,30599667:30600069,30599668:30600041,30599670:30600179,30599673:30600094,30599676:30599992,30599677:30599888,30599679:30599964,30599682:30599815,30599683:30599934,30599686:30599757,30599688:30599851,30601506:30601583,30601761:30601825,30613749:30614706,30613752:30614735,30613755:30614805,30613758:30614558,30613761:30614420,30613764:30614608,30613766:30614310,30613768:30614271,30613770:3061467', 'assoc_mat': '30578993:papier:4230:30579139,30579990:papier:4230:30580207,30579991:papier:4230:30580093,30580351:papier:4230:30580388,30580704:papier:4230:30580738,30580967:papier:4230:30581007,30581218:papier:4230:30581317,30581511:papier:4230:30581679,30581888:papier:4230:30581921,30582201:papier:4230:30582274,30582560:papier:4230:30582611,30582939:papier:4230:30582967,30583323:papier:4230:30583421,30583944:papier:4230:30583999,30584433:papier:4230:30584525,30584790:papier:4230:30584822,30584956:papier:4230:30584972,30585085:papier:4230:30585144,30585420:papier:4230:30585503,30585422:papier:4230:30585436,30585423:papier:4230:30585464,30585636:papier:4230:30585700,30586496:papier:4230:30586507,30586658:papier:4230:30586683,30599642:papier:4230:30600765,30599643:papier:4230:30600585,30599646:papier:4230:30600509,30599647:papier:4230:30600550,30599651:papier:4230:30601964,30599654:papier:4230:30600453,30599655:papier:4230:30600301,30599658:papier:4230:30600263,30599660:papier:4230:30601995,30599662:papier:4230:30600335,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028439679620058354, 'nb_photo': 1496, 'list_port_cont': '30579145,30580091,30580203,30580382,30580736,30580999,30581321,30581684,30581914,30585139,30585506,30585696,30586509,30586681,30599811,30599853,30599881,30599926,30599984,30600036,30600075,30600100,30600183,30600333,30601829,30613982,30614018,30614075,30614154,30614192,30614236,30614272,30614308,30614346,30614375,30614430,30614525,30614594,30614671,30614705,30616437,30616641,30629810,30629920,30629971,30630059,30630121,30630186,30630369,30630404,30630487,30630508,30630598,30630641,30630701,30630758,30630886,30630984,30631156,30631209,30631331,30632739,30653123,30653159,30653195,30653312,30653400,30653470,30653510,30653567,30653614,30653695,30653861,30655869,30655988,30656309,30656530,30657639,30657832,30658739,30659398,30659434,30660003,30660330,30661086,30661209,30662248,30662282,30662464,30663357,30663587,30665796,30665830,30665986,30677392,30677508,30677579,30677726,30677792,30677952,30678071,30678133,30678172,30678230,30678266,30678353,30678544,30678594,30678675,30678842,30695568,30695678,30695751,3069578', 'assoc_port': '30578993:30579145,30579990:30580203,30579991:30580091,30580351:30580382,30580704:30580736,30580967:30580999,30581218:30581321,30581511:30581684,30581888:30581914,30585085:30585139,30585420:30585506,30585636:30585696,30586496:30586509,30586658:30586681,30599662:30600333,30599667:30600075,30599668:30600036,30599670:30600183,30599673:30600100,30599676:30599984,30599677:30599881,30599682:30599811,30599683:30599926,30599688:30599853,30601761:30601829,30613749:30614705,30613766:30614308,30613768:30614272,30613770:30614671,30613772:30614525,30613773:30614594,30613775:30614430,30613776:30614375,30613778:30614018,30613779:30614192,30613780:30614346,30613781:30613982,30613782:30614236,30613783:30614154,30613784:30614075,30616414:30616437,30616604:30616641,30629649:30631209,30629653:30631156,30629660:30631331,30629668:30630758,30629672:30630598,30629678:30629810,30629686:30630984,30629692:30630886,30629698:30630487,30629705:30630508,30629709:30630701,30629716:30630641,30629721:30630369,30629726:30630404,30629732:3063012', 'assoc_mat': '30578993:pehd:4230:30579145,30579990:pehd:4230:30580203,30579991:pehd:4230:30580091,30580351:pehd:4230:30580382,30580704:pehd:4230:30580736,30580967:pehd:4230:30580999,30581218:pehd:4230:30581321,30581511:pehd:4230:30581684,30581888:pehd:4230:30581914,30585085:pehd:4230:30585139,30585420:pehd:4230:30585506,30585636:pehd:4230:30585696,30586496:pehd:4230:30586509,30586658:pehd:4230:30586681,30599662:pehd:4230:30600333,30599667:pehd:4230:30600075,30599668:pehd:4230:30600036,30599670:pehd:4230:30600183,30599673:pehd:4230:30600100,30599676:pehd:4230:30599984,30599677:pehd:4230:30599881,30599682:pehd:4230:30599811,30599683:pehd:4230:30599926,30599688:pehd:4230:30599853,30601761:pehd:4230:30601829,30613749:pehd:4230:30614705,30613766:pehd:4230:30614308,30613768:pehd:4230:30614272,30613770:pehd:4230:30614671,30613772:pehd:4230:30614525,30613773:pehd:4230:30614594,30613775:pehd:4230:30614430,30613776:pehd:4230:30614375,30613778:pehd:4230:30614018,30613779:pehd:4230:30614192,30613780:pehd:4230:30614346,30613781:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02493658014671728, 'nb_photo': 31880, 'list_port_cont': '30579138,30580097,30580201,30580380,30580741,30581013,30581319,30581678,30581918,30582289,30582612,30582965,30583414,30584005,30584524,30584826,30584979,30585145,30585434,30585469,30585515,30585697,30586517,30586676,30599756,30599805,30599842,30599883,30599923,30599966,30599994,30600042,30600072,30600090,30600186,30600210,30600264,30600288,30600329,30600456,30600512,30600545,30600588,30600767,30601582,30601828,30601961,30601994,30613944,30613978,30614012,30614071,30614127,30614142,30614194,30614230,30614263,30614307,30614344,30614384,30614417,30614432,30614529,30614557,30614600,30614616,30614669,30614702,30614742,30614817,30616429,30616647,30629814,30629917,30629966,30630068,30630112,30630159,30630195,30630371,30630406,30630492,30630504,30630602,30630659,30630707,30630764,30630890,30630980,30631019,30631098,30631157,30631207,30631337,30632744,30633414,30652999,30653121,30653151,30653194,30653213,30653319,30653389,30653475,30653524,30653568,30653613,30653702,30653824,30653869,30653901,30653972,30654031,3065412', 'assoc_port': '30578993:30579138,30579990:30580201,30579991:30580097,30580351:30580380,30580704:30580741,30580967:30581013,30581218:30581319,30581511:30581678,30581888:30581918,30582201:30582289,30582560:30582612,30582939:30582965,30583323:30583414,30583944:30584005,30584433:30584524,30584790:30584826,30584956:30584979,30585085:30585145,30585420:30585515,30585422:30585434,30585423:30585469,30585636:30585697,30586496:30586517,30586658:30586676,30599642:30600767,30599643:30600588,30599646:30600512,30599647:30600545,30599651:30601961,30599654:30600456,30599655:30600288,30599658:30600264,30599660:30601994,30599662:30600329,30599665:30600210,30599667:30600072,30599668:30600042,30599670:30600186,30599673:30600090,30599676:30599994,30599677:30599883,30599679:30599966,30599682:30599805,30599683:30599923,30599686:30599756,30599688:30599842,30601506:30601582,30601761:30601828,30613749:30614702,30613752:30614742,30613755:30614817,30613758:30614557,30613761:30614417,30613764:30614616,30613766:30614307,30613768:30614263,30613770:3061466', 'assoc_mat': '30578993:pet_clair:4230:30579138,30579990:pet_clair:4230:30580201,30579991:pet_clair:4230:30580097,30580351:pet_clair:4230:30580380,30580704:pet_clair:4230:30580741,30580967:pet_clair:4230:30581013,30581218:pet_clair:4230:30581319,30581511:pet_clair:4230:30581678,30581888:pet_clair:4230:30581918,30582201:pet_clair:4230:30582289,30582560:pet_clair:4230:30582612,30582939:pet_clair:4230:30582965,30583323:pet_clair:4230:30583414,30583944:pet_clair:4230:30584005,30584433:pet_clair:4230:30584524,30584790:pet_clair:4230:30584826,30584956:pet_clair:4230:30584979,30585085:pet_clair:4230:30585145,30585420:pet_clair:4230:30585515,30585422:pet_clair:4230:30585434,30585423:pet_clair:4230:30585469,30585636:pet_clair:4230:30585697,30586496:pet_clair:4230:30586517,30586658:pet_clair:4230:30586676,30599642:pet_clair:4230:30600767,30599643:pet_clair:4230:30600588,30599646:pet_clair:4230:30600512,30599647:pet_clair:4230:30600545,30599651:pet_clair:4230:30601961,30599654:pet_clair:4230:30600456,30599655:pet_clair:4230:30600288,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0026009608755777317, 'nb_photo': 1098, 'list_port_cont': '30580095,30580740,30581320,30581927,30584526,30584827,30584971,30585141,30585478,30586677,30599804,30599927,30599957,30600068,30600092,30600185,30600218,30600261,30601965,30602000,30613948,30613980,30614011,30614070,30614123,30614160,30614196,30614237,30614264,30614347,30614419,30614444,30614523,30614561,30614598,30614610,30614670,30614745,30614814,30616434,30616640,30629809,30629921,30630106,30630149,30630187,30630372,30630398,30630489,30630603,30630703,30630763,30630895,30630986,30631020,30631160,30631201,30631335,30653108,30653155,30653203,30653315,30653402,30653474,30653517,30653571,30653604,30653705,30653847,30653907,30654032,30655981,30656311,30657652,30657827,30658284,30659387,30659428,30661089,30661219,30662238,30662281,30662461,30663353,30665827,30677509,30677575,30677741,30677793,30677957,30678065,30678167,30678220,30678255,30678537,30678669,30695681,30695853,30696041,30696733,30704452,30704729,30704798,30704870,30705017,30705091,30705301,30705401,30705555,30705591,30705624,30705733,30705875,3071499', 'assoc_port': '30579991:30580095,30580704:30580740,30581218:30581320,30581888:30581927,30584433:30584526,30584790:30584827,30584956:30584971,30585085:30585141,30585423:30585478,30586658:30586677,30599651:30601965,30599658:30600261,30599660:30602000,30599665:30600218,30599667:30600068,30599670:30600185,30599673:30600092,30599679:30599957,30599682:30599804,30599683:30599927,30613752:30614745,30613755:30614814,30613758:30614561,30613761:30614419,30613764:30614610,30613768:30614264,30613770:30614670,30613772:30614523,30613773:30614598,30613775:30614444,30613777:30614123,30613778:30614011,30613779:30614196,30613780:30614347,30613781:30613980,30613782:30614237,30613783:30614160,30613784:30614070,30613785:30613948,30616414:30616434,30616604:30616640,30629649:30631201,30629653:30631160,30629660:30631335,30629663:30631020,30629668:30630763,30629672:30630603,30629678:30629809,30629686:30630986,30629692:30630895,30629698:30630489,30629709:30630703,30629721:30630372,30629726:30630398,30629732:30630106,30629735:30630149,30629743:3063018', 'assoc_mat': '30579991:pet_fonce:4230:30580095,30580704:pet_fonce:4230:30580740,30581218:pet_fonce:4230:30581320,30581888:pet_fonce:4230:30581927,30584433:pet_fonce:4230:30584526,30584790:pet_fonce:4230:30584827,30584956:pet_fonce:4230:30584971,30585085:pet_fonce:4230:30585141,30585423:pet_fonce:4230:30585478,30586658:pet_fonce:4230:30586677,30599651:pet_fonce:4230:30601965,30599658:pet_fonce:4230:30600261,30599660:pet_fonce:4230:30602000,30599665:pet_fonce:4230:30600218,30599667:pet_fonce:4230:30600068,30599670:pet_fonce:4230:30600185,30599673:pet_fonce:4230:30600092,30599679:pet_fonce:4230:30599957,30599682:pet_fonce:4230:30599804,30599683:pet_fonce:4230:30599927,30613752:pet_fonce:4230:30614745,30613755:pet_fonce:4230:30614814,30613758:pet_fonce:4230:30614561,30613761:pet_fonce:4230:30614419,30613764:pet_fonce:4230:30614610,30613768:pet_fonce:4230:30614264,30613770:pet_fonce:4230:30614670,30613772:pet_fonce:4230:30614523,30613773:pet_fonce:4230:30614598,30613775:pet_fonce:4230:30614444,30613777:pet_fonce:4230:30614123,3'}), 'main_stat': {'nb_photos': 2209}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30842594,30842595,30842596,30842597,30842598,30842599,30842600?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-03', 0.759692022982996),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_03_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.36%', 18609], 'carton': ['carton', '3.7%', 96339], 'metal': ['metal', '0.11%', 1836], 'papier': ['papier', '17.15%', 325228], 'pehd': ['pehd', '0.28%', 1496], 'pet_clair': ['pet_clair', '2.49%', 31880], 'pet_fonce': ['pet_fonce', '0.26%', 1098]}} 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_03_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.47user 2.68system 0:09.49elapsed 54%CPU (0avgtext+0avgdata 186288maxresident)k 8inputs+312outputs (0major+49076minor)pagefaults 0swaps