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_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -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_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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 : 203 month : 03 mtr_id : dashboard_places : SCCU_cam8 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_cam8' 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 = 203 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 = 203 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 = 203 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_cam8" 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 (2935047,2936598,2938329,2940115,2943520,2944697,2945777,2946573,2947685,2948816,2950245,2951661,2952639,2953226,2954875,2956525,2958006,2959612,2961725,2962847,2963388,2965018,2966616,2968224,2969004,2969724,2970262,2970816,2971487,2972148) 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.026834563235748954, 'nb_photo': 28504, 'list_port_cont': '30585658,30585760,30585799,30585841,30585877,30585918,30585951,30585978,30586021,30586063,30586097,30586135,30586159,30586207,30586235,30586274,30586310,30586340,30586394,30586423,30586465,30586585,30586625,30586778,30600099,30600410,30600623,30600644,30600687,30600733,30600807,30600836,30600876,30600920,30600957,30601009,30601040,30601061,30601122,30601149,30601190,30601242,30601275,30601320,30601366,30601586,30601869,30613816,30613899,30614843,30614883,30614918,30614950,30615028,30615056,30615093,30615134,30615180,30615216,30615240,30615325,30615364,30615447,30615497,30615542,30615584,30615609,30615622,30615868,30616475,30616694,30630235,30630330,30630560,30630949,30631061,30631277,30631525,30631797,30631873,30632153,30632175,30632264,30632408,30632487,30632561,30632620,30632696,30632776,30633476,30633935,30652628,30653785,30653939,30654014,30654264,30654415,30654454,30654481,30654594,30654637,30654672,30654703,30654860,30654909,30654929,30655207,30655232,30655267,30655359,30655395,30655422,30655532,3065568', 'assoc_port': '30585623:30586135,30585624:30586625,30585625:30586310,30585626:30586274,30585627:30586394,30585628:30586159,30585629:30586465,30585630:30586235,30585631:30586423,30585632:30586207,30585633:30586097,30585634:30586340,30585635:30586063,30585637:30586021,30585638:30585978,30585639:30585918,30585640:30585877,30585641:30585951,30585642:30585841,30585643:30585760,30585644:30585658,30585645:30585799,30586497:30586585,30586659:30586778,30599641:30600410,30599644:30600920,30599645:30601366,30599648:30601275,30599652:30601149,30599653:30601190,30599656:30601320,30599657:30601009,30599659:30601122,30599663:30600836,30599664:30600957,30599666:30600876,30599669:30600807,30599671:30601242,30599672:30601040,30599675:30600687,30599678:30601061,30599680:30600644,30599681:30600733,30599684:30600623,30599685:30600099,30601507:30601586,30601760:30601869,30613724:30615868,30613726:30615584,30613728:30615364,30613730:30615497,30613732:30615609,30613734:30615216,30613736:30615622,30613738:30615542,30613740:30615447,30613742:3061524', 'assoc_mat': '30585623:autre:4230:30586135,30585624:autre:4230:30586625,30585625:autre:4230:30586310,30585626:autre:4230:30586274,30585627:autre:4230:30586394,30585628:autre:4230:30586159,30585629:autre:4230:30586465,30585630:autre:4230:30586235,30585631:autre:4230:30586423,30585632:autre:4230:30586207,30585633:autre:4230:30586097,30585634:autre:4230:30586340,30585635:autre:4230:30586063,30585637:autre:4230:30586021,30585638:autre:4230:30585978,30585639:autre:4230:30585918,30585640:autre:4230:30585877,30585641:autre:4230:30585951,30585642:autre:4230:30585841,30585643:autre:4230:30585760,30585644:autre:4230:30585658,30585645:autre:4230:30585799,30586497:autre:4230:30586585,30586659:autre:4230:30586778,30599641:autre:4230:30600410,30599644:autre:4230:30600920,30599645:autre:4230:30601366,30599648:autre:4230:30601275,30599652:autre:4230:30601149,30599653:autre:4230:30601190,30599656:autre:4230:30601320,30599657:autre:4230:30601009,30599659:autre:4230:30601122,30599663:autre:4230:30600836,30599664:autre:4230:30600957,30599666:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.10006369597770524, 'nb_photo': 133385, 'list_port_cont': '30585665,30585773,30585798,30585846,30585885,30585911,30585947,30585987,30586022,30586051,30586100,30586130,30586166,30586209,30586241,30586277,30586313,30586348,30586389,30586424,30586454,30586587,30586628,30586783,30600110,30600423,30600618,30600657,30600696,30600728,30600800,30600841,30600874,30600919,30600953,30601006,30601042,30601055,30601113,30601152,30601204,30601243,30601286,30601322,30601374,30601597,30601870,30613803,30613904,30614852,30614877,30614924,30614960,30615025,30615066,30615102,30615142,30615178,30615210,30615253,30615323,30615370,30615455,30615507,30615544,30615578,30615620,30615631,30615862,30616485,30616693,30630221,30630335,30630570,30630938,30631060,30631275,30631523,30631800,30631862,30632165,30632187,30632271,30632397,30632477,30632568,30632629,30632701,30632774,30633492,30633930,30652621,30653795,30653938,30654007,30654275,30654412,30654452,30654485,30654599,30654631,30654677,30654714,30654863,30654899,30654941,30655205,30655236,30655280,30655357,30655391,30655430,30655536,3065570', 'assoc_port': '30585623:30586130,30585624:30586628,30585625:30586313,30585626:30586277,30585627:30586389,30585628:30586166,30585629:30586454,30585630:30586241,30585631:30586424,30585632:30586209,30585633:30586100,30585634:30586348,30585635:30586051,30585637:30586022,30585638:30585987,30585639:30585911,30585640:30585885,30585641:30585947,30585642:30585846,30585643:30585773,30585644:30585665,30585645:30585798,30586497:30586587,30586659:30586783,30599641:30600423,30599644:30600919,30599645:30601374,30599648:30601286,30599652:30601152,30599653:30601204,30599656:30601322,30599657:30601006,30599659:30601113,30599663:30600841,30599664:30600953,30599666:30600874,30599669:30600800,30599671:30601243,30599672:30601042,30599675:30600696,30599678:30601055,30599680:30600657,30599681:30600728,30599684:30600618,30599685:30600110,30601507:30601597,30601760:30601870,30613724:30615862,30613726:30615578,30613728:30615370,30613730:30615507,30613732:30615620,30613734:30615210,30613736:30615631,30613738:30615544,30613740:30615455,30613742:3061525', 'assoc_mat': '30585623:carton:4230:30586130,30585624:carton:4230:30586628,30585625:carton:4230:30586313,30585626:carton:4230:30586277,30585627:carton:4230:30586389,30585628:carton:4230:30586166,30585629:carton:4230:30586454,30585630:carton:4230:30586241,30585631:carton:4230:30586424,30585632:carton:4230:30586209,30585633:carton:4230:30586100,30585634:carton:4230:30586348,30585635:carton:4230:30586051,30585637:carton:4230:30586022,30585638:carton:4230:30585987,30585639:carton:4230:30585911,30585640:carton:4230:30585885,30585641:carton:4230:30585947,30585642:carton:4230:30585846,30585643:carton:4230:30585773,30585644:carton:4230:30585665,30585645:carton:4230:30585798,30586497:carton:4230:30586587,30586659:carton:4230:30586783,30599641:carton:4230:30600423,30599644:carton:4230:30600919,30599645:carton:4230:30601374,30599648:carton:4230:30601286,30599652:carton:4230:30601152,30599653:carton:4230:30601204,30599656:carton:4230:30601322,30599657:carton:4230:30601006,30599659:carton:4230:30601113,30599663:carton:4230:30600841,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021539239598164237, 'nb_photo': 2322, 'list_port_cont': '30585664,30585774,30585808,30585849,30585878,30585912,30585945,30585993,30586030,30586052,30586140,30586172,30586197,30586240,30586270,30586306,30586357,30586377,30586418,30586449,30586580,30586624,30586787,30600093,30600415,30600619,30600791,30600912,30600943,30601008,30601053,30601108,30601196,30601227,30601284,30601332,30601379,30601599,30601879,30613911,30614853,30615020,30615212,30615372,30615453,30615494,30615530,30615577,30615629,30615880,30630939,30631050,30631274,30631514,30631805,30632161,30632182,30632399,30632486,30632565,30632627,30633480,30633938,30652630,30653781,30653940,30654012,30654271,30654401,30654446,30654483,30654589,30654635,30654678,30654702,30654869,30654894,30654933,30655193,30655227,30655276,30655345,30655380,30655433,30655541,30655699,30655915,30664224,30664259,30664289,30664401,30664475,30664642,30664685,30664724,30664751,30664788,30664810,30664889,30664966,30665041,30665117,30665148,30665193,30665335,30665755,30666031,30677340,30677599,30677680,30677921,30677992,30678027,3067830', 'assoc_port': '30585623:30586140,30585624:30586624,30585625:30586306,30585626:30586270,30585627:30586377,30585628:30586172,30585629:30586449,30585630:30586240,30585631:30586418,30585632:30586197,30585634:30586357,30585635:30586052,30585637:30586030,30585638:30585993,30585639:30585912,30585640:30585878,30585641:30585945,30585642:30585849,30585643:30585774,30585644:30585664,30585645:30585808,30586497:30586580,30586659:30586787,30599641:30600415,30599644:30600912,30599645:30601379,30599648:30601284,30599653:30601196,30599656:30601332,30599657:30601008,30599659:30601108,30599664:30600943,30599669:30600791,30599671:30601227,30599678:30601053,30599684:30600619,30599685:30600093,30601507:30601599,30601760:30601879,30613724:30615880,30613726:30615577,30613728:30615372,30613730:30615494,30613734:30615212,30613736:30615629,30613738:30615530,30613740:30615453,30613760:30615020,30613767:30613911,30613769:30614853,30629664:30630939,30629667:30631050,30629673:30631274,30629677:30631514,30629682:30633938,30629693:30632182,30629699:3063248', 'assoc_mat': '30585623:metal:4230:30586140,30585624:metal:4230:30586624,30585625:metal:4230:30586306,30585626:metal:4230:30586270,30585627:metal:4230:30586377,30585628:metal:4230:30586172,30585629:metal:4230:30586449,30585630:metal:4230:30586240,30585631:metal:4230:30586418,30585632:metal:4230:30586197,30585634:metal:4230:30586357,30585635:metal:4230:30586052,30585637:metal:4230:30586030,30585638:metal:4230:30585993,30585639:metal:4230:30585912,30585640:metal:4230:30585878,30585641:metal:4230:30585945,30585642:metal:4230:30585849,30585643:metal:4230:30585774,30585644:metal:4230:30585664,30585645:metal:4230:30585808,30586497:metal:4230:30586580,30586659:metal:4230:30586787,30599641:metal:4230:30600415,30599644:metal:4230:30600912,30599645:metal:4230:30601379,30599648:metal:4230:30601284,30599653:metal:4230:30601196,30599656:metal:4230:30601332,30599657:metal:4230:30601008,30599659:metal:4230:30601108,30599664:metal:4230:30600943,30599669:metal:4230:30600791,30599671:metal:4230:30601227,30599678:metal:4230:30601053,30599684:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3583340139198026, 'nb_photo': 410921, 'list_port_cont': '30585657,30585769,30585811,30585843,30585884,30585905,30585952,30585986,30586029,30586066,30586101,30586136,30586171,30586211,30586248,30586276,30586317,30586351,30586391,30586417,30586460,30586589,30586617,30586798,30600113,30600420,30600624,30600661,30600697,30600736,30600802,30600838,30600873,30600917,30600958,30600995,30601041,30601062,30601120,30601157,30601201,30601231,30601288,30601329,30601378,30601603,30601878,30613817,30613907,30614851,30614886,30614921,30614962,30615035,30615060,30615106,30615143,30615176,30615208,30615252,30615318,30615367,30615461,30615505,30615545,30615574,30615608,30615633,30615870,30616489,30616698,30630230,30630333,30630566,30630950,30631056,30631266,30631516,30631802,30631867,30632162,30632186,30632274,30632406,30632483,30632569,30632630,30632707,30632767,30633490,30633934,30652619,30653788,30653937,30654016,30654260,30654406,30654445,30654491,30654604,30654627,30654676,30654715,30654870,30654908,30654946,30655200,30655244,30655274,30655360,30655388,30655428,30655540,3065569', 'assoc_port': '30585623:30586136,30585624:30586617,30585625:30586317,30585626:30586276,30585627:30586391,30585628:30586171,30585629:30586460,30585630:30586248,30585631:30586417,30585632:30586211,30585633:30586101,30585634:30586351,30585635:30586066,30585637:30586029,30585638:30585986,30585639:30585905,30585640:30585884,30585641:30585952,30585642:30585843,30585643:30585769,30585644:30585657,30585645:30585811,30586497:30586589,30586659:30586798,30599641:30600420,30599644:30600917,30599645:30601378,30599648:30601288,30599652:30601157,30599653:30601201,30599656:30601329,30599657:30600995,30599659:30601120,30599663:30600838,30599664:30600958,30599666:30600873,30599669:30600802,30599671:30601231,30599672:30601062,30599675:30600697,30599678:30601041,30599680:30600661,30599681:30600736,30599684:30600624,30599685:30600113,30601507:30601603,30601760:30601878,30613724:30615870,30613726:30615574,30613728:30615367,30613730:30615505,30613732:30615608,30613734:30615208,30613736:30615633,30613738:30615545,30613740:30615461,30613742:3061525', 'assoc_mat': '30585623:papier:4230:30586136,30585624:papier:4230:30586617,30585625:papier:4230:30586317,30585626:papier:4230:30586276,30585627:papier:4230:30586391,30585628:papier:4230:30586171,30585629:papier:4230:30586460,30585630:papier:4230:30586248,30585631:papier:4230:30586417,30585632:papier:4230:30586211,30585633:papier:4230:30586101,30585634:papier:4230:30586351,30585635:papier:4230:30586066,30585637:papier:4230:30586029,30585638:papier:4230:30585986,30585639:papier:4230:30585905,30585640:papier:4230:30585884,30585641:papier:4230:30585952,30585642:papier:4230:30585843,30585643:papier:4230:30585769,30585644:papier:4230:30585657,30585645:papier:4230:30585811,30586497:papier:4230:30586589,30586659:papier:4230:30586798,30599641:papier:4230:30600420,30599644:papier:4230:30600917,30599645:papier:4230:30601378,30599648:papier:4230:30601288,30599652:papier:4230:30601157,30599653:papier:4230:30601201,30599656:papier:4230:30601329,30599657:papier:4230:30600995,30599659:papier:4230:30601120,30599663:papier:4230:30600838,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006489589246646342, 'nb_photo': 6808, 'list_port_cont': '30585660,30585766,30585806,30585837,30585872,30585921,30585957,30585985,30586027,30586058,30586096,30586131,30586173,30586203,30586247,30586285,30586321,30586349,30586384,30586429,30586461,30586588,30586623,30586786,30600107,30600408,30600617,30600647,30600688,30600729,30600798,30600843,30600879,30600915,30600956,30601004,30601034,30601059,30601123,30601162,30601205,30601237,30601278,30601324,30601380,30601601,30601864,30613812,30613912,30614840,30614887,30614954,30615029,30615067,30615097,30615138,30615167,30615219,30615250,30615311,30615369,30615457,30615503,30615540,30615582,30615616,30615632,30615882,30616483,30616704,30630229,30630323,30630567,30630948,30631064,30631267,30631519,30631794,30631877,30632169,30632183,30632270,30632402,30632476,30632559,30632626,30632693,30633483,30633926,30652631,30653791,30653942,30654018,30654265,30654410,30654443,30654489,30654605,30654638,30654674,30654700,30654865,30654901,30654942,30655202,30655239,30655283,30655350,30655389,30655429,30655537,30655701,30655914,3066419', 'assoc_port': '30585623:30586131,30585624:30586623,30585625:30586321,30585626:30586285,30585627:30586384,30585628:30586173,30585629:30586461,30585630:30586247,30585631:30586429,30585632:30586203,30585633:30586096,30585634:30586349,30585635:30586058,30585637:30586027,30585638:30585985,30585639:30585921,30585640:30585872,30585641:30585957,30585642:30585837,30585643:30585766,30585644:30585660,30585645:30585806,30586497:30586588,30586659:30586786,30599641:30600408,30599644:30600915,30599645:30601380,30599648:30601278,30599652:30601162,30599653:30601205,30599656:30601324,30599657:30601004,30599659:30601123,30599663:30600843,30599664:30600956,30599666:30600879,30599669:30600798,30599671:30601237,30599672:30601034,30599675:30600688,30599678:30601059,30599680:30600647,30599681:30600729,30599684:30600617,30599685:30600107,30601507:30601601,30601760:30601864,30613724:30615882,30613726:30615582,30613728:30615369,30613730:30615503,30613732:30615616,30613734:30615219,30613736:30615632,30613738:30615540,30613740:30615457,30613742:3061525', 'assoc_mat': '30585623:pehd:4230:30586131,30585624:pehd:4230:30586623,30585625:pehd:4230:30586321,30585626:pehd:4230:30586285,30585627:pehd:4230:30586384,30585628:pehd:4230:30586173,30585629:pehd:4230:30586461,30585630:pehd:4230:30586247,30585631:pehd:4230:30586429,30585632:pehd:4230:30586203,30585633:pehd:4230:30586096,30585634:pehd:4230:30586349,30585635:pehd:4230:30586058,30585637:pehd:4230:30586027,30585638:pehd:4230:30585985,30585639:pehd:4230:30585921,30585640:pehd:4230:30585872,30585641:pehd:4230:30585957,30585642:pehd:4230:30585837,30585643:pehd:4230:30585766,30585644:pehd:4230:30585660,30585645:pehd:4230:30585806,30586497:pehd:4230:30586588,30586659:pehd:4230:30586786,30599641:pehd:4230:30600408,30599644:pehd:4230:30600915,30599645:pehd:4230:30601380,30599648:pehd:4230:30601278,30599652:pehd:4230:30601162,30599653:pehd:4230:30601205,30599656:pehd:4230:30601324,30599657:pehd:4230:30601004,30599659:pehd:4230:30601123,30599663:pehd:4230:30600843,30599664:pehd:4230:30600956,30599666:pehd:4230:30600879,30599669:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014083399077655986, 'nb_photo': 27503, 'list_port_cont': '30585666,30585772,30585803,30585840,30585874,30585916,30585950,30585991,30586015,30586061,30586095,30586134,30586169,30586210,30586246,30586279,30586319,30586355,30586387,30586430,30586464,30586579,30586618,30586785,30600106,30600412,30600621,30600660,30600695,30600735,30600808,30600834,30600883,30600916,30600951,30601007,30601044,30601047,30601121,30601158,30601200,30601230,30601282,30601318,30601373,30601589,30601872,30613808,30613913,30614846,30614889,30614922,30614953,30615031,30615064,30615101,30615136,30615169,30615211,30615245,30615324,30615363,30615460,30615509,30615534,30615580,30615619,30615636,30615885,30616487,30616703,30630231,30630329,30630558,30630951,30631055,30631278,30631522,30631798,30631869,30632159,30632185,30632277,30632405,30632485,30632571,30632628,30632694,30632783,30633493,30633933,30652624,30653792,30653945,30654017,30654272,30654409,30654441,30654490,30654600,30654642,30654666,30654716,30654866,30654910,30654945,30655206,30655242,30655282,30655356,30655387,30655432,30655534,3065570', 'assoc_port': '30585623:30586134,30585624:30586618,30585625:30586319,30585626:30586279,30585627:30586387,30585628:30586169,30585629:30586464,30585630:30586246,30585631:30586430,30585632:30586210,30585633:30586095,30585634:30586355,30585635:30586061,30585637:30586015,30585638:30585991,30585639:30585916,30585640:30585874,30585641:30585950,30585642:30585840,30585643:30585772,30585644:30585666,30585645:30585803,30586497:30586579,30586659:30586785,30599641:30600412,30599644:30600916,30599645:30601373,30599648:30601282,30599652:30601158,30599653:30601200,30599656:30601318,30599657:30601007,30599659:30601121,30599663:30600834,30599664:30600951,30599666:30600883,30599669:30600808,30599671:30601230,30599672:30601044,30599675:30600695,30599678:30601047,30599680:30600660,30599681:30600735,30599684:30600621,30599685:30600106,30601507:30601589,30601760:30601872,30613724:30615885,30613726:30615580,30613728:30615363,30613730:30615509,30613732:30615619,30613734:30615211,30613736:30615636,30613738:30615534,30613740:30615460,30613742:3061524', 'assoc_mat': '30585623:pet_clair:4230:30586134,30585624:pet_clair:4230:30586618,30585625:pet_clair:4230:30586319,30585626:pet_clair:4230:30586279,30585627:pet_clair:4230:30586387,30585628:pet_clair:4230:30586169,30585629:pet_clair:4230:30586464,30585630:pet_clair:4230:30586246,30585631:pet_clair:4230:30586430,30585632:pet_clair:4230:30586210,30585633:pet_clair:4230:30586095,30585634:pet_clair:4230:30586355,30585635:pet_clair:4230:30586061,30585637:pet_clair:4230:30586015,30585638:pet_clair:4230:30585991,30585639:pet_clair:4230:30585916,30585640:pet_clair:4230:30585874,30585641:pet_clair:4230:30585950,30585642:pet_clair:4230:30585840,30585643:pet_clair:4230:30585772,30585644:pet_clair:4230:30585666,30585645:pet_clair:4230:30585803,30586497:pet_clair:4230:30586579,30586659:pet_clair:4230:30586785,30599641:pet_clair:4230:30600412,30599644:pet_clair:4230:30600916,30599645:pet_clair:4230:30601373,30599648:pet_clair:4230:30601282,30599652:pet_clair:4230:30601158,30599653:pet_clair:4230:30601200,30599656:pet_clair:4230:30601318,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007633789725173568, 'nb_photo': 2483, 'list_port_cont': '30585662,30585765,30585801,30585847,30585883,30585917,30585956,30585994,30586023,30586059,30586094,30586138,30586170,30586204,30586245,30586314,30586350,30586393,30586415,30586590,30586627,30586781,30600422,30600620,30600656,30600699,30600719,30600842,30600881,30600921,30600955,30601045,30601056,30601115,30601202,30601236,30601280,30601333,30601375,30601602,30601877,30613909,30614847,30614914,30614949,30615104,30615139,30615175,30615217,30615246,30615321,30615366,30615462,30615502,30615537,30615575,30615621,30615639,30615864,30616486,30616707,30630234,30630337,30630569,30630943,30631058,30631272,30631518,30631799,30631874,30632168,30632177,30632400,30632478,30632567,30632624,30632775,30633489,30633939,30652629,30653789,30653944,30654005,30654273,30654414,30654455,30654494,30654596,30654636,30654670,30654709,30654872,30654906,30654934,30655201,30655237,30655272,30655354,30655394,30655431,30655543,30655703,30655909,30664191,30664216,30664267,30664301,30664375,30664402,30664485,30664518,30664556,30664651,3066468', 'assoc_port': '30585623:30586138,30585624:30586627,30585625:30586314,30585627:30586393,30585628:30586170,30585630:30586245,30585631:30586415,30585632:30586204,30585633:30586094,30585634:30586350,30585635:30586059,30585637:30586023,30585638:30585994,30585639:30585917,30585640:30585883,30585641:30585956,30585642:30585847,30585643:30585765,30585644:30585662,30585645:30585801,30586497:30586590,30586659:30586781,30599641:30600422,30599644:30600921,30599645:30601375,30599648:30601280,30599653:30601202,30599656:30601333,30599659:30601115,30599663:30600842,30599664:30600955,30599666:30600881,30599671:30601236,30599672:30601056,30599675:30600699,30599678:30601045,30599680:30600656,30599681:30600719,30599684:30600620,30601507:30601602,30601760:30601877,30613724:30615864,30613726:30615575,30613728:30615366,30613730:30615502,30613732:30615621,30613734:30615217,30613736:30615639,30613738:30615537,30613740:30615462,30613742:30615246,30613744:30615321,30613746:30614914,30613748:30615175,30613751:30615104,30613754:30615139,30613757:3061494', 'assoc_mat': '30585623:pet_fonce:4230:30586138,30585624:pet_fonce:4230:30586627,30585625:pet_fonce:4230:30586314,30585627:pet_fonce:4230:30586393,30585628:pet_fonce:4230:30586170,30585630:pet_fonce:4230:30586245,30585631:pet_fonce:4230:30586415,30585632:pet_fonce:4230:30586204,30585633:pet_fonce:4230:30586094,30585634:pet_fonce:4230:30586350,30585635:pet_fonce:4230:30586059,30585637:pet_fonce:4230:30586023,30585638:pet_fonce:4230:30585994,30585639:pet_fonce:4230:30585917,30585640:pet_fonce:4230:30585883,30585641:pet_fonce:4230:30585956,30585642:pet_fonce:4230:30585847,30585643:pet_fonce:4230:30585765,30585644:pet_fonce:4230:30585662,30585645:pet_fonce:4230:30585801,30586497:pet_fonce:4230:30586590,30586659:pet_fonce:4230:30586781,30599641:pet_fonce:4230:30600422,30599644:pet_fonce:4230:30600921,30599645:pet_fonce:4230:30601375,30599648:pet_fonce:4230:30601280,30599653:pet_fonce:4230:30601202,30599656:pet_fonce:4230:30601333,30599659:pet_fonce:4230:30601115,30599663:pet_fonce:4230:30600842,30599664:pet_fonce:4230:30600955,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(2935047,2936598,2938329,2940115,2943520,2944697,2945777,2946573,2947685,2948816,2950245,2951661,2952639,2953226,2954875,2956525,2958006,2959612,2961725,2962847,2963388,2965018,2966616,2968224,2969004,2969724,2970262,2970816,2971487,2972148)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842638, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585658,30585760,30585799,30585841,30585877,30585918,30585951,30585978,30586021,30586063,30586097,30586135,30586159,30586207,30586235,30586274,30586310,30586340,30586394,30586423,30586465,30586585,30586625,30586778,30600099,30600410,30600623,30600644,30600687,30600733,30600807,30600836,30600876,30600920,30600957,30601009,30601040,30601061,30601122,30601149,30601190,30601242,30601275,30601320,30601366,30601586,30601869,30613816,30613899,30614843,30614883,30614918,30614950,30615028,30615056,30615093,30615134,30615180,30615216,30615240,30615325,30615364,30615447,30615497,30615542,30615584,30615609,30615622,30615868,30616475,30616694,30630235,30630330,30630560,30630949,30631061,30631277,30631525,30631797,30631873,30632153,30632175,30632264,30632408,30632487,30632561,30632620,30632696,30632776,30633476,30633935,30652628,30653785,30653939,30654014,30654264,30654415,30654454,30654481,30654594,30654637,30654672,30654703,30654860,30654909,30654929,30655207,30655232,30655267,30655359,30655395,30655422,30655532,3065568 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842640, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585665,30585773,30585798,30585846,30585885,30585911,30585947,30585987,30586022,30586051,30586100,30586130,30586166,30586209,30586241,30586277,30586313,30586348,30586389,30586424,30586454,30586587,30586628,30586783,30600110,30600423,30600618,30600657,30600696,30600728,30600800,30600841,30600874,30600919,30600953,30601006,30601042,30601055,30601113,30601152,30601204,30601243,30601286,30601322,30601374,30601597,30601870,30613803,30613904,30614852,30614877,30614924,30614960,30615025,30615066,30615102,30615142,30615178,30615210,30615253,30615323,30615370,30615455,30615507,30615544,30615578,30615620,30615631,30615862,30616485,30616693,30630221,30630335,30630570,30630938,30631060,30631275,30631523,30631800,30631862,30632165,30632187,30632271,30632397,30632477,30632568,30632629,30632701,30632774,30633492,30633930,30652621,30653795,30653938,30654007,30654275,30654412,30654452,30654485,30654599,30654631,30654677,30654714,30654863,30654899,30654941,30655205,30655236,30655280,30655357,30655391,30655430,30655536,3065570 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842641, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585664,30585774,30585808,30585849,30585878,30585912,30585945,30585993,30586030,30586052,30586140,30586172,30586197,30586240,30586270,30586306,30586357,30586377,30586418,30586449,30586580,30586624,30586787,30600093,30600415,30600619,30600791,30600912,30600943,30601008,30601053,30601108,30601196,30601227,30601284,30601332,30601379,30601599,30601879,30613911,30614853,30615020,30615212,30615372,30615453,30615494,30615530,30615577,30615629,30615880,30630939,30631050,30631274,30631514,30631805,30632161,30632182,30632399,30632486,30632565,30632627,30633480,30633938,30652630,30653781,30653940,30654012,30654271,30654401,30654446,30654483,30654589,30654635,30654678,30654702,30654869,30654894,30654933,30655193,30655227,30655276,30655345,30655380,30655433,30655541,30655699,30655915,30664224,30664259,30664289,30664401,30664475,30664642,30664685,30664724,30664751,30664788,30664810,30664889,30664966,30665041,30665117,30665148,30665193,30665335,30665755,30666031,30677340,30677599,30677680,30677921,30677992,30678027,3067830 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842642, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585657,30585769,30585811,30585843,30585884,30585905,30585952,30585986,30586029,30586066,30586101,30586136,30586171,30586211,30586248,30586276,30586317,30586351,30586391,30586417,30586460,30586589,30586617,30586798,30600113,30600420,30600624,30600661,30600697,30600736,30600802,30600838,30600873,30600917,30600958,30600995,30601041,30601062,30601120,30601157,30601201,30601231,30601288,30601329,30601378,30601603,30601878,30613817,30613907,30614851,30614886,30614921,30614962,30615035,30615060,30615106,30615143,30615176,30615208,30615252,30615318,30615367,30615461,30615505,30615545,30615574,30615608,30615633,30615870,30616489,30616698,30630230,30630333,30630566,30630950,30631056,30631266,30631516,30631802,30631867,30632162,30632186,30632274,30632406,30632483,30632569,30632630,30632707,30632767,30633490,30633934,30652619,30653788,30653937,30654016,30654260,30654406,30654445,30654491,30654604,30654627,30654676,30654715,30654870,30654908,30654946,30655200,30655244,30655274,30655360,30655388,30655428,30655540,3065569 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842643, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585660,30585766,30585806,30585837,30585872,30585921,30585957,30585985,30586027,30586058,30586096,30586131,30586173,30586203,30586247,30586285,30586321,30586349,30586384,30586429,30586461,30586588,30586623,30586786,30600107,30600408,30600617,30600647,30600688,30600729,30600798,30600843,30600879,30600915,30600956,30601004,30601034,30601059,30601123,30601162,30601205,30601237,30601278,30601324,30601380,30601601,30601864,30613812,30613912,30614840,30614887,30614954,30615029,30615067,30615097,30615138,30615167,30615219,30615250,30615311,30615369,30615457,30615503,30615540,30615582,30615616,30615632,30615882,30616483,30616704,30630229,30630323,30630567,30630948,30631064,30631267,30631519,30631794,30631877,30632169,30632183,30632270,30632402,30632476,30632559,30632626,30632693,30633483,30633926,30652631,30653791,30653942,30654018,30654265,30654410,30654443,30654489,30654605,30654638,30654674,30654700,30654865,30654901,30654942,30655202,30655239,30655283,30655350,30655389,30655429,30655537,30655701,30655914,3066419 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842644, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585666,30585772,30585803,30585840,30585874,30585916,30585950,30585991,30586015,30586061,30586095,30586134,30586169,30586210,30586246,30586279,30586319,30586355,30586387,30586430,30586464,30586579,30586618,30586785,30600106,30600412,30600621,30600660,30600695,30600735,30600808,30600834,30600883,30600916,30600951,30601007,30601044,30601047,30601121,30601158,30601200,30601230,30601282,30601318,30601373,30601589,30601872,30613808,30613913,30614846,30614889,30614922,30614953,30615031,30615064,30615101,30615136,30615169,30615211,30615245,30615324,30615363,30615460,30615509,30615534,30615580,30615619,30615636,30615885,30616487,30616703,30630231,30630329,30630558,30630951,30631055,30631278,30631522,30631798,30631869,30632159,30632185,30632277,30632405,30632485,30632571,30632628,30632694,30632783,30633493,30633933,30652624,30653792,30653945,30654017,30654272,30654409,30654441,30654490,30654600,30654642,30654666,30654716,30654866,30654910,30654945,30655206,30655242,30655282,30655356,30655387,30655432,30655534,3065570 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842645, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30585662,30585765,30585801,30585847,30585883,30585917,30585956,30585994,30586023,30586059,30586094,30586138,30586170,30586204,30586245,30586314,30586350,30586393,30586415,30586590,30586627,30586781,30600422,30600620,30600656,30600699,30600719,30600842,30600881,30600921,30600955,30601045,30601056,30601115,30601202,30601236,30601280,30601333,30601375,30601602,30601877,30613909,30614847,30614914,30614949,30615104,30615139,30615175,30615217,30615246,30615321,30615366,30615462,30615502,30615537,30615575,30615621,30615639,30615864,30616486,30616707,30630234,30630337,30630569,30630943,30631058,30631272,30631518,30631799,30631874,30632168,30632177,30632400,30632478,30632567,30632624,30632775,30633489,30633939,30652629,30653789,30653944,30654005,30654273,30654414,30654455,30654494,30654596,30654636,30654670,30654709,30654872,30654906,30654934,30655201,30655237,30655272,30655354,30655394,30655431,30655543,30655703,30655909,30664191,30664216,30664267,30664301,30664375,30664402,30664485,30664518,30664556,30664651,3066468 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30842638,30842640,30842641,30842642,30842643,30842644,30842645?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=203 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': ((2118,),), 'unwanted_material_monthly_percentage': ((0.5120049032463452,),), 'material_repartition': (('incineration', 2118),), 'material_dict': {'incineration': 2118}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 3, 1), 0.5126976205556434, 4), (datetime.date(2026, 3, 2), 0.537143384882954, 4), (datetime.date(2026, 3, 3), 0.447030691576785, 4), (datetime.date(2026, 3, 4), 0.43519026428294705, 4), (datetime.date(2026, 3, 5), 0.4782215886316019, 3), (datetime.date(2026, 3, 6), 0.5132197521876982, 3), (datetime.date(2026, 3, 7), 0.5323825380091316, 4), (datetime.date(2026, 3, 9), 0.4300586701350677, 4), (datetime.date(2026, 3, 10), 0.41694850601847155, 4), (datetime.date(2026, 3, 11), 0.43820248767647046, 1), (datetime.date(2026, 3, 12), 0.4439627392584588, 3), (datetime.date(2026, 3, 13), 0.4733956795655209, 3), (datetime.date(2026, 3, 14), 0.4591409429635688, 3), (datetime.date(2026, 3, 15), 0.538670279893417, 4), (datetime.date(2026, 3, 16), 0.7126006380172706, 4), (datetime.date(2026, 3, 17), 0.5734136210496968, 4), (datetime.date(2026, 3, 18), 0.4942921191220215, 3), (datetime.date(2026, 3, 19), 0.502950234477714, 4), (datetime.date(2026, 3, 20), 0.47059647937569093, 3), (datetime.date(2026, 3, 21), 0.5018912533601555, 3), (datetime.date(2026, 3, 22), 0.46516297433561504, 4), (datetime.date(2026, 3, 23), 0.5658153196685091, 1), (datetime.date(2026, 3, 24), 0.5039341872900854, 2), (datetime.date(2026, 3, 25), 0.5067162242498477, 4), (datetime.date(2026, 3, 26), 0.5544964925256038, 2), (datetime.date(2026, 3, 27), 0.5326140546903921, 2), (datetime.date(2026, 3, 28), 0.5560329815216204, 4), (datetime.date(2026, 3, 29), 0.5389692562140327, 3), (datetime.date(2026, 3, 30), 0.5869333656724182, 4), (datetime.date(2026, 3, 31), 0.5867682395975724, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 3, 1), 0.5126976205556434, 4), (datetime.date(2026, 3, 2), 0.537143384882954, 4), (datetime.date(2026, 3, 3), 0.447030691576785, 4), (datetime.date(2026, 3, 4), 0.43519026428294705, 4), (datetime.date(2026, 3, 5), 0.4782215886316019, 3), (datetime.date(2026, 3, 6), 0.5132197521876982, 3), (datetime.date(2026, 3, 7), 0.5323825380091316, 4), (datetime.date(2026, 3, 9), 0.4300586701350677, 4), (datetime.date(2026, 3, 10), 0.41694850601847155, 4), (datetime.date(2026, 3, 11), 0.43820248767647046, 1), (datetime.date(2026, 3, 12), 0.4439627392584588, 3), (datetime.date(2026, 3, 13), 0.4733956795655209, 3), (datetime.date(2026, 3, 14), 0.4591409429635688, 3), (datetime.date(2026, 3, 15), 0.538670279893417, 4), (datetime.date(2026, 3, 16), 0.7126006380172706, 4), (datetime.date(2026, 3, 17), 0.5734136210496968, 4), (datetime.date(2026, 3, 18), 0.4942921191220215, 3), (datetime.date(2026, 3, 19), 0.502950234477714, 4), (datetime.date(2026, 3, 20), 0.47059647937569093, 3), (datetime.date(2026, 3, 21), 0.5018912533601555, 3), (datetime.date(2026, 3, 22), 0.46516297433561504, 4), (datetime.date(2026, 3, 23), 0.5658153196685091, 1), (datetime.date(2026, 3, 24), 0.5039341872900854, 2), (datetime.date(2026, 3, 25), 0.5067162242498477, 4), (datetime.date(2026, 3, 26), 0.5544964925256038, 2), (datetime.date(2026, 3, 27), 0.5326140546903921, 2), (datetime.date(2026, 3, 28), 0.5560329815216204, 4), (datetime.date(2026, 3, 29), 0.5389692562140327, 3), (datetime.date(2026, 3, 30), 0.5869333656724182, 4), (datetime.date(2026, 3, 31), 0.5867682395975724, 3))}, 'quality_array': [['-8.421830871606627', '01032026'], ['-8.05279475501724', '02032026'], ['-8.013077520110315', '03032026'], ['-7.896128397743088', '04032026'], ['-8.387273080053385', '05032026'], ['-8.361574820017413', '06032026'], ['-8.24908916892196', '07032026'], ['-8.079712616625697', '09032026'], ['-7.872171899851991', '10032026'], ['-8.461628648512095', '11032026'], ['-8.168411538886149', '12032026'], ['-8.405700134898357', '13032026'], ['-8.374184692035493', '14032026'], ['-8.368408176165442', '15032026'], ['-8.156174635418335', '16032026'], ['-8.17504849994369', '17032026'], ['-7.682899033126132', '18032026'], ['-7.767544450522995', '19032026'], ['-8.009195424648615', '20032026'], ['-7.867778984613812', '21032026'], ['-7.773893123617658', '22032026'], ['-7.896589185653124', '23032026'], ['-7.837311247808208', '24032026'], ['-7.6884274618485104', '25032026'], ['-7.550336219568495', '26032026'], ['-7.902217801606997', '27032026'], ['-7.611496217375953', '28032026'], ['-8.154963907369819', '29032026'], ['-8.286445972967353', '30032026'], ['-7.924420794901804', '31032026']], 'number_of_batch': ((664,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.026834563235748954, 'nb_photo': 28504, 'list_port_cont': '30585658,30585760,30585799,30585841,30585877,30585918,30585951,30585978,30586021,30586063,30586097,30586135,30586159,30586207,30586235,30586274,30586310,30586340,30586394,30586423,30586465,30586585,30586625,30586778,30600099,30600410,30600623,30600644,30600687,30600733,30600807,30600836,30600876,30600920,30600957,30601009,30601040,30601061,30601122,30601149,30601190,30601242,30601275,30601320,30601366,30601586,30601869,30613816,30613899,30614843,30614883,30614918,30614950,30615028,30615056,30615093,30615134,30615180,30615216,30615240,30615325,30615364,30615447,30615497,30615542,30615584,30615609,30615622,30615868,30616475,30616694,30630235,30630330,30630560,30630949,30631061,30631277,30631525,30631797,30631873,30632153,30632175,30632264,30632408,30632487,30632561,30632620,30632696,30632776,30633476,30633935,30652628,30653785,30653939,30654014,30654264,30654415,30654454,30654481,30654594,30654637,30654672,30654703,30654860,30654909,30654929,30655207,30655232,30655267,30655359,30655395,30655422,30655532,3065568', 'assoc_port': '30585623:30586135,30585624:30586625,30585625:30586310,30585626:30586274,30585627:30586394,30585628:30586159,30585629:30586465,30585630:30586235,30585631:30586423,30585632:30586207,30585633:30586097,30585634:30586340,30585635:30586063,30585637:30586021,30585638:30585978,30585639:30585918,30585640:30585877,30585641:30585951,30585642:30585841,30585643:30585760,30585644:30585658,30585645:30585799,30586497:30586585,30586659:30586778,30599641:30600410,30599644:30600920,30599645:30601366,30599648:30601275,30599652:30601149,30599653:30601190,30599656:30601320,30599657:30601009,30599659:30601122,30599663:30600836,30599664:30600957,30599666:30600876,30599669:30600807,30599671:30601242,30599672:30601040,30599675:30600687,30599678:30601061,30599680:30600644,30599681:30600733,30599684:30600623,30599685:30600099,30601507:30601586,30601760:30601869,30613724:30615868,30613726:30615584,30613728:30615364,30613730:30615497,30613732:30615609,30613734:30615216,30613736:30615622,30613738:30615542,30613740:30615447,30613742:3061524', 'assoc_mat': '30585623:autre:4230:30586135,30585624:autre:4230:30586625,30585625:autre:4230:30586310,30585626:autre:4230:30586274,30585627:autre:4230:30586394,30585628:autre:4230:30586159,30585629:autre:4230:30586465,30585630:autre:4230:30586235,30585631:autre:4230:30586423,30585632:autre:4230:30586207,30585633:autre:4230:30586097,30585634:autre:4230:30586340,30585635:autre:4230:30586063,30585637:autre:4230:30586021,30585638:autre:4230:30585978,30585639:autre:4230:30585918,30585640:autre:4230:30585877,30585641:autre:4230:30585951,30585642:autre:4230:30585841,30585643:autre:4230:30585760,30585644:autre:4230:30585658,30585645:autre:4230:30585799,30586497:autre:4230:30586585,30586659:autre:4230:30586778,30599641:autre:4230:30600410,30599644:autre:4230:30600920,30599645:autre:4230:30601366,30599648:autre:4230:30601275,30599652:autre:4230:30601149,30599653:autre:4230:30601190,30599656:autre:4230:30601320,30599657:autre:4230:30601009,30599659:autre:4230:30601122,30599663:autre:4230:30600836,30599664:autre:4230:30600957,30599666:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.10006369597770524, 'nb_photo': 133385, 'list_port_cont': '30585665,30585773,30585798,30585846,30585885,30585911,30585947,30585987,30586022,30586051,30586100,30586130,30586166,30586209,30586241,30586277,30586313,30586348,30586389,30586424,30586454,30586587,30586628,30586783,30600110,30600423,30600618,30600657,30600696,30600728,30600800,30600841,30600874,30600919,30600953,30601006,30601042,30601055,30601113,30601152,30601204,30601243,30601286,30601322,30601374,30601597,30601870,30613803,30613904,30614852,30614877,30614924,30614960,30615025,30615066,30615102,30615142,30615178,30615210,30615253,30615323,30615370,30615455,30615507,30615544,30615578,30615620,30615631,30615862,30616485,30616693,30630221,30630335,30630570,30630938,30631060,30631275,30631523,30631800,30631862,30632165,30632187,30632271,30632397,30632477,30632568,30632629,30632701,30632774,30633492,30633930,30652621,30653795,30653938,30654007,30654275,30654412,30654452,30654485,30654599,30654631,30654677,30654714,30654863,30654899,30654941,30655205,30655236,30655280,30655357,30655391,30655430,30655536,3065570', 'assoc_port': '30585623:30586130,30585624:30586628,30585625:30586313,30585626:30586277,30585627:30586389,30585628:30586166,30585629:30586454,30585630:30586241,30585631:30586424,30585632:30586209,30585633:30586100,30585634:30586348,30585635:30586051,30585637:30586022,30585638:30585987,30585639:30585911,30585640:30585885,30585641:30585947,30585642:30585846,30585643:30585773,30585644:30585665,30585645:30585798,30586497:30586587,30586659:30586783,30599641:30600423,30599644:30600919,30599645:30601374,30599648:30601286,30599652:30601152,30599653:30601204,30599656:30601322,30599657:30601006,30599659:30601113,30599663:30600841,30599664:30600953,30599666:30600874,30599669:30600800,30599671:30601243,30599672:30601042,30599675:30600696,30599678:30601055,30599680:30600657,30599681:30600728,30599684:30600618,30599685:30600110,30601507:30601597,30601760:30601870,30613724:30615862,30613726:30615578,30613728:30615370,30613730:30615507,30613732:30615620,30613734:30615210,30613736:30615631,30613738:30615544,30613740:30615455,30613742:3061525', 'assoc_mat': '30585623:carton:4230:30586130,30585624:carton:4230:30586628,30585625:carton:4230:30586313,30585626:carton:4230:30586277,30585627:carton:4230:30586389,30585628:carton:4230:30586166,30585629:carton:4230:30586454,30585630:carton:4230:30586241,30585631:carton:4230:30586424,30585632:carton:4230:30586209,30585633:carton:4230:30586100,30585634:carton:4230:30586348,30585635:carton:4230:30586051,30585637:carton:4230:30586022,30585638:carton:4230:30585987,30585639:carton:4230:30585911,30585640:carton:4230:30585885,30585641:carton:4230:30585947,30585642:carton:4230:30585846,30585643:carton:4230:30585773,30585644:carton:4230:30585665,30585645:carton:4230:30585798,30586497:carton:4230:30586587,30586659:carton:4230:30586783,30599641:carton:4230:30600423,30599644:carton:4230:30600919,30599645:carton:4230:30601374,30599648:carton:4230:30601286,30599652:carton:4230:30601152,30599653:carton:4230:30601204,30599656:carton:4230:30601322,30599657:carton:4230:30601006,30599659:carton:4230:30601113,30599663:carton:4230:30600841,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021539239598164237, 'nb_photo': 2322, 'list_port_cont': '30585664,30585774,30585808,30585849,30585878,30585912,30585945,30585993,30586030,30586052,30586140,30586172,30586197,30586240,30586270,30586306,30586357,30586377,30586418,30586449,30586580,30586624,30586787,30600093,30600415,30600619,30600791,30600912,30600943,30601008,30601053,30601108,30601196,30601227,30601284,30601332,30601379,30601599,30601879,30613911,30614853,30615020,30615212,30615372,30615453,30615494,30615530,30615577,30615629,30615880,30630939,30631050,30631274,30631514,30631805,30632161,30632182,30632399,30632486,30632565,30632627,30633480,30633938,30652630,30653781,30653940,30654012,30654271,30654401,30654446,30654483,30654589,30654635,30654678,30654702,30654869,30654894,30654933,30655193,30655227,30655276,30655345,30655380,30655433,30655541,30655699,30655915,30664224,30664259,30664289,30664401,30664475,30664642,30664685,30664724,30664751,30664788,30664810,30664889,30664966,30665041,30665117,30665148,30665193,30665335,30665755,30666031,30677340,30677599,30677680,30677921,30677992,30678027,3067830', 'assoc_port': '30585623:30586140,30585624:30586624,30585625:30586306,30585626:30586270,30585627:30586377,30585628:30586172,30585629:30586449,30585630:30586240,30585631:30586418,30585632:30586197,30585634:30586357,30585635:30586052,30585637:30586030,30585638:30585993,30585639:30585912,30585640:30585878,30585641:30585945,30585642:30585849,30585643:30585774,30585644:30585664,30585645:30585808,30586497:30586580,30586659:30586787,30599641:30600415,30599644:30600912,30599645:30601379,30599648:30601284,30599653:30601196,30599656:30601332,30599657:30601008,30599659:30601108,30599664:30600943,30599669:30600791,30599671:30601227,30599678:30601053,30599684:30600619,30599685:30600093,30601507:30601599,30601760:30601879,30613724:30615880,30613726:30615577,30613728:30615372,30613730:30615494,30613734:30615212,30613736:30615629,30613738:30615530,30613740:30615453,30613760:30615020,30613767:30613911,30613769:30614853,30629664:30630939,30629667:30631050,30629673:30631274,30629677:30631514,30629682:30633938,30629693:30632182,30629699:3063248', 'assoc_mat': '30585623:metal:4230:30586140,30585624:metal:4230:30586624,30585625:metal:4230:30586306,30585626:metal:4230:30586270,30585627:metal:4230:30586377,30585628:metal:4230:30586172,30585629:metal:4230:30586449,30585630:metal:4230:30586240,30585631:metal:4230:30586418,30585632:metal:4230:30586197,30585634:metal:4230:30586357,30585635:metal:4230:30586052,30585637:metal:4230:30586030,30585638:metal:4230:30585993,30585639:metal:4230:30585912,30585640:metal:4230:30585878,30585641:metal:4230:30585945,30585642:metal:4230:30585849,30585643:metal:4230:30585774,30585644:metal:4230:30585664,30585645:metal:4230:30585808,30586497:metal:4230:30586580,30586659:metal:4230:30586787,30599641:metal:4230:30600415,30599644:metal:4230:30600912,30599645:metal:4230:30601379,30599648:metal:4230:30601284,30599653:metal:4230:30601196,30599656:metal:4230:30601332,30599657:metal:4230:30601008,30599659:metal:4230:30601108,30599664:metal:4230:30600943,30599669:metal:4230:30600791,30599671:metal:4230:30601227,30599678:metal:4230:30601053,30599684:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3583340139198026, 'nb_photo': 410921, 'list_port_cont': '30585657,30585769,30585811,30585843,30585884,30585905,30585952,30585986,30586029,30586066,30586101,30586136,30586171,30586211,30586248,30586276,30586317,30586351,30586391,30586417,30586460,30586589,30586617,30586798,30600113,30600420,30600624,30600661,30600697,30600736,30600802,30600838,30600873,30600917,30600958,30600995,30601041,30601062,30601120,30601157,30601201,30601231,30601288,30601329,30601378,30601603,30601878,30613817,30613907,30614851,30614886,30614921,30614962,30615035,30615060,30615106,30615143,30615176,30615208,30615252,30615318,30615367,30615461,30615505,30615545,30615574,30615608,30615633,30615870,30616489,30616698,30630230,30630333,30630566,30630950,30631056,30631266,30631516,30631802,30631867,30632162,30632186,30632274,30632406,30632483,30632569,30632630,30632707,30632767,30633490,30633934,30652619,30653788,30653937,30654016,30654260,30654406,30654445,30654491,30654604,30654627,30654676,30654715,30654870,30654908,30654946,30655200,30655244,30655274,30655360,30655388,30655428,30655540,3065569', 'assoc_port': '30585623:30586136,30585624:30586617,30585625:30586317,30585626:30586276,30585627:30586391,30585628:30586171,30585629:30586460,30585630:30586248,30585631:30586417,30585632:30586211,30585633:30586101,30585634:30586351,30585635:30586066,30585637:30586029,30585638:30585986,30585639:30585905,30585640:30585884,30585641:30585952,30585642:30585843,30585643:30585769,30585644:30585657,30585645:30585811,30586497:30586589,30586659:30586798,30599641:30600420,30599644:30600917,30599645:30601378,30599648:30601288,30599652:30601157,30599653:30601201,30599656:30601329,30599657:30600995,30599659:30601120,30599663:30600838,30599664:30600958,30599666:30600873,30599669:30600802,30599671:30601231,30599672:30601062,30599675:30600697,30599678:30601041,30599680:30600661,30599681:30600736,30599684:30600624,30599685:30600113,30601507:30601603,30601760:30601878,30613724:30615870,30613726:30615574,30613728:30615367,30613730:30615505,30613732:30615608,30613734:30615208,30613736:30615633,30613738:30615545,30613740:30615461,30613742:3061525', 'assoc_mat': '30585623:papier:4230:30586136,30585624:papier:4230:30586617,30585625:papier:4230:30586317,30585626:papier:4230:30586276,30585627:papier:4230:30586391,30585628:papier:4230:30586171,30585629:papier:4230:30586460,30585630:papier:4230:30586248,30585631:papier:4230:30586417,30585632:papier:4230:30586211,30585633:papier:4230:30586101,30585634:papier:4230:30586351,30585635:papier:4230:30586066,30585637:papier:4230:30586029,30585638:papier:4230:30585986,30585639:papier:4230:30585905,30585640:papier:4230:30585884,30585641:papier:4230:30585952,30585642:papier:4230:30585843,30585643:papier:4230:30585769,30585644:papier:4230:30585657,30585645:papier:4230:30585811,30586497:papier:4230:30586589,30586659:papier:4230:30586798,30599641:papier:4230:30600420,30599644:papier:4230:30600917,30599645:papier:4230:30601378,30599648:papier:4230:30601288,30599652:papier:4230:30601157,30599653:papier:4230:30601201,30599656:papier:4230:30601329,30599657:papier:4230:30600995,30599659:papier:4230:30601120,30599663:papier:4230:30600838,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006489589246646342, 'nb_photo': 6808, 'list_port_cont': '30585660,30585766,30585806,30585837,30585872,30585921,30585957,30585985,30586027,30586058,30586096,30586131,30586173,30586203,30586247,30586285,30586321,30586349,30586384,30586429,30586461,30586588,30586623,30586786,30600107,30600408,30600617,30600647,30600688,30600729,30600798,30600843,30600879,30600915,30600956,30601004,30601034,30601059,30601123,30601162,30601205,30601237,30601278,30601324,30601380,30601601,30601864,30613812,30613912,30614840,30614887,30614954,30615029,30615067,30615097,30615138,30615167,30615219,30615250,30615311,30615369,30615457,30615503,30615540,30615582,30615616,30615632,30615882,30616483,30616704,30630229,30630323,30630567,30630948,30631064,30631267,30631519,30631794,30631877,30632169,30632183,30632270,30632402,30632476,30632559,30632626,30632693,30633483,30633926,30652631,30653791,30653942,30654018,30654265,30654410,30654443,30654489,30654605,30654638,30654674,30654700,30654865,30654901,30654942,30655202,30655239,30655283,30655350,30655389,30655429,30655537,30655701,30655914,3066419', 'assoc_port': '30585623:30586131,30585624:30586623,30585625:30586321,30585626:30586285,30585627:30586384,30585628:30586173,30585629:30586461,30585630:30586247,30585631:30586429,30585632:30586203,30585633:30586096,30585634:30586349,30585635:30586058,30585637:30586027,30585638:30585985,30585639:30585921,30585640:30585872,30585641:30585957,30585642:30585837,30585643:30585766,30585644:30585660,30585645:30585806,30586497:30586588,30586659:30586786,30599641:30600408,30599644:30600915,30599645:30601380,30599648:30601278,30599652:30601162,30599653:30601205,30599656:30601324,30599657:30601004,30599659:30601123,30599663:30600843,30599664:30600956,30599666:30600879,30599669:30600798,30599671:30601237,30599672:30601034,30599675:30600688,30599678:30601059,30599680:30600647,30599681:30600729,30599684:30600617,30599685:30600107,30601507:30601601,30601760:30601864,30613724:30615882,30613726:30615582,30613728:30615369,30613730:30615503,30613732:30615616,30613734:30615219,30613736:30615632,30613738:30615540,30613740:30615457,30613742:3061525', 'assoc_mat': '30585623:pehd:4230:30586131,30585624:pehd:4230:30586623,30585625:pehd:4230:30586321,30585626:pehd:4230:30586285,30585627:pehd:4230:30586384,30585628:pehd:4230:30586173,30585629:pehd:4230:30586461,30585630:pehd:4230:30586247,30585631:pehd:4230:30586429,30585632:pehd:4230:30586203,30585633:pehd:4230:30586096,30585634:pehd:4230:30586349,30585635:pehd:4230:30586058,30585637:pehd:4230:30586027,30585638:pehd:4230:30585985,30585639:pehd:4230:30585921,30585640:pehd:4230:30585872,30585641:pehd:4230:30585957,30585642:pehd:4230:30585837,30585643:pehd:4230:30585766,30585644:pehd:4230:30585660,30585645:pehd:4230:30585806,30586497:pehd:4230:30586588,30586659:pehd:4230:30586786,30599641:pehd:4230:30600408,30599644:pehd:4230:30600915,30599645:pehd:4230:30601380,30599648:pehd:4230:30601278,30599652:pehd:4230:30601162,30599653:pehd:4230:30601205,30599656:pehd:4230:30601324,30599657:pehd:4230:30601004,30599659:pehd:4230:30601123,30599663:pehd:4230:30600843,30599664:pehd:4230:30600956,30599666:pehd:4230:30600879,30599669:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014083399077655986, 'nb_photo': 27503, 'list_port_cont': '30585666,30585772,30585803,30585840,30585874,30585916,30585950,30585991,30586015,30586061,30586095,30586134,30586169,30586210,30586246,30586279,30586319,30586355,30586387,30586430,30586464,30586579,30586618,30586785,30600106,30600412,30600621,30600660,30600695,30600735,30600808,30600834,30600883,30600916,30600951,30601007,30601044,30601047,30601121,30601158,30601200,30601230,30601282,30601318,30601373,30601589,30601872,30613808,30613913,30614846,30614889,30614922,30614953,30615031,30615064,30615101,30615136,30615169,30615211,30615245,30615324,30615363,30615460,30615509,30615534,30615580,30615619,30615636,30615885,30616487,30616703,30630231,30630329,30630558,30630951,30631055,30631278,30631522,30631798,30631869,30632159,30632185,30632277,30632405,30632485,30632571,30632628,30632694,30632783,30633493,30633933,30652624,30653792,30653945,30654017,30654272,30654409,30654441,30654490,30654600,30654642,30654666,30654716,30654866,30654910,30654945,30655206,30655242,30655282,30655356,30655387,30655432,30655534,3065570', 'assoc_port': '30585623:30586134,30585624:30586618,30585625:30586319,30585626:30586279,30585627:30586387,30585628:30586169,30585629:30586464,30585630:30586246,30585631:30586430,30585632:30586210,30585633:30586095,30585634:30586355,30585635:30586061,30585637:30586015,30585638:30585991,30585639:30585916,30585640:30585874,30585641:30585950,30585642:30585840,30585643:30585772,30585644:30585666,30585645:30585803,30586497:30586579,30586659:30586785,30599641:30600412,30599644:30600916,30599645:30601373,30599648:30601282,30599652:30601158,30599653:30601200,30599656:30601318,30599657:30601007,30599659:30601121,30599663:30600834,30599664:30600951,30599666:30600883,30599669:30600808,30599671:30601230,30599672:30601044,30599675:30600695,30599678:30601047,30599680:30600660,30599681:30600735,30599684:30600621,30599685:30600106,30601507:30601589,30601760:30601872,30613724:30615885,30613726:30615580,30613728:30615363,30613730:30615509,30613732:30615619,30613734:30615211,30613736:30615636,30613738:30615534,30613740:30615460,30613742:3061524', 'assoc_mat': '30585623:pet_clair:4230:30586134,30585624:pet_clair:4230:30586618,30585625:pet_clair:4230:30586319,30585626:pet_clair:4230:30586279,30585627:pet_clair:4230:30586387,30585628:pet_clair:4230:30586169,30585629:pet_clair:4230:30586464,30585630:pet_clair:4230:30586246,30585631:pet_clair:4230:30586430,30585632:pet_clair:4230:30586210,30585633:pet_clair:4230:30586095,30585634:pet_clair:4230:30586355,30585635:pet_clair:4230:30586061,30585637:pet_clair:4230:30586015,30585638:pet_clair:4230:30585991,30585639:pet_clair:4230:30585916,30585640:pet_clair:4230:30585874,30585641:pet_clair:4230:30585950,30585642:pet_clair:4230:30585840,30585643:pet_clair:4230:30585772,30585644:pet_clair:4230:30585666,30585645:pet_clair:4230:30585803,30586497:pet_clair:4230:30586579,30586659:pet_clair:4230:30586785,30599641:pet_clair:4230:30600412,30599644:pet_clair:4230:30600916,30599645:pet_clair:4230:30601373,30599648:pet_clair:4230:30601282,30599652:pet_clair:4230:30601158,30599653:pet_clair:4230:30601200,30599656:pet_clair:4230:30601318,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007633789725173568, 'nb_photo': 2483, 'list_port_cont': '30585662,30585765,30585801,30585847,30585883,30585917,30585956,30585994,30586023,30586059,30586094,30586138,30586170,30586204,30586245,30586314,30586350,30586393,30586415,30586590,30586627,30586781,30600422,30600620,30600656,30600699,30600719,30600842,30600881,30600921,30600955,30601045,30601056,30601115,30601202,30601236,30601280,30601333,30601375,30601602,30601877,30613909,30614847,30614914,30614949,30615104,30615139,30615175,30615217,30615246,30615321,30615366,30615462,30615502,30615537,30615575,30615621,30615639,30615864,30616486,30616707,30630234,30630337,30630569,30630943,30631058,30631272,30631518,30631799,30631874,30632168,30632177,30632400,30632478,30632567,30632624,30632775,30633489,30633939,30652629,30653789,30653944,30654005,30654273,30654414,30654455,30654494,30654596,30654636,30654670,30654709,30654872,30654906,30654934,30655201,30655237,30655272,30655354,30655394,30655431,30655543,30655703,30655909,30664191,30664216,30664267,30664301,30664375,30664402,30664485,30664518,30664556,30664651,3066468', 'assoc_port': '30585623:30586138,30585624:30586627,30585625:30586314,30585627:30586393,30585628:30586170,30585630:30586245,30585631:30586415,30585632:30586204,30585633:30586094,30585634:30586350,30585635:30586059,30585637:30586023,30585638:30585994,30585639:30585917,30585640:30585883,30585641:30585956,30585642:30585847,30585643:30585765,30585644:30585662,30585645:30585801,30586497:30586590,30586659:30586781,30599641:30600422,30599644:30600921,30599645:30601375,30599648:30601280,30599653:30601202,30599656:30601333,30599659:30601115,30599663:30600842,30599664:30600955,30599666:30600881,30599671:30601236,30599672:30601056,30599675:30600699,30599678:30601045,30599680:30600656,30599681:30600719,30599684:30600620,30601507:30601602,30601760:30601877,30613724:30615864,30613726:30615575,30613728:30615366,30613730:30615502,30613732:30615621,30613734:30615217,30613736:30615639,30613738:30615537,30613740:30615462,30613742:30615246,30613744:30615321,30613746:30614914,30613748:30615175,30613751:30615104,30613754:30615139,30613757:3061494', 'assoc_mat': '30585623:pet_fonce:4230:30586138,30585624:pet_fonce:4230:30586627,30585625:pet_fonce:4230:30586314,30585627:pet_fonce:4230:30586393,30585628:pet_fonce:4230:30586170,30585630:pet_fonce:4230:30586245,30585631:pet_fonce:4230:30586415,30585632:pet_fonce:4230:30586204,30585633:pet_fonce:4230:30586094,30585634:pet_fonce:4230:30586350,30585635:pet_fonce:4230:30586059,30585637:pet_fonce:4230:30586023,30585638:pet_fonce:4230:30585994,30585639:pet_fonce:4230:30585917,30585640:pet_fonce:4230:30585883,30585641:pet_fonce:4230:30585956,30585642:pet_fonce:4230:30585847,30585643:pet_fonce:4230:30585765,30585644:pet_fonce:4230:30585662,30585645:pet_fonce:4230:30585801,30586497:pet_fonce:4230:30586590,30586659:pet_fonce:4230:30586781,30599641:pet_fonce:4230:30600422,30599644:pet_fonce:4230:30600921,30599645:pet_fonce:4230:30601375,30599648:pet_fonce:4230:30601280,30599653:pet_fonce:4230:30601202,30599656:pet_fonce:4230:30601333,30599659:pet_fonce:4230:30601115,30599663:pet_fonce:4230:30600842,30599664:pet_fonce:4230:30600955,3'}), 'main_stat': {'nb_photos': 2118}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30842638,30842640,30842641,30842642,30842643,30842644,30842645?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-03', 0.5120049032463452),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 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=4851 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= 4851 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=4851 # 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': ((2118,),), 'unwanted_material_monthly_percentage': ((0.5120049032463452,),), 'material_repartition': (('incineration', 2118),), 'material_dict': {'incineration': 2118}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 3, 1), 0.5126976205556434, 4), (datetime.date(2026, 3, 2), 0.537143384882954, 4), (datetime.date(2026, 3, 3), 0.447030691576785, 4), (datetime.date(2026, 3, 4), 0.43519026428294705, 4), (datetime.date(2026, 3, 5), 0.4782215886316019, 3), (datetime.date(2026, 3, 6), 0.5132197521876982, 3), (datetime.date(2026, 3, 7), 0.5323825380091316, 4), (datetime.date(2026, 3, 9), 0.4300586701350677, 4), (datetime.date(2026, 3, 10), 0.41694850601847155, 4), (datetime.date(2026, 3, 11), 0.43820248767647046, 1), (datetime.date(2026, 3, 12), 0.4439627392584588, 3), (datetime.date(2026, 3, 13), 0.4733956795655209, 3), (datetime.date(2026, 3, 14), 0.4591409429635688, 3), (datetime.date(2026, 3, 15), 0.538670279893417, 4), (datetime.date(2026, 3, 16), 0.7126006380172706, 4), (datetime.date(2026, 3, 17), 0.5734136210496968, 4), (datetime.date(2026, 3, 18), 0.4942921191220215, 3), (datetime.date(2026, 3, 19), 0.502950234477714, 4), (datetime.date(2026, 3, 20), 0.47059647937569093, 3), (datetime.date(2026, 3, 21), 0.5018912533601555, 3), (datetime.date(2026, 3, 22), 0.46516297433561504, 4), (datetime.date(2026, 3, 23), 0.5658153196685091, 1), (datetime.date(2026, 3, 24), 0.5039341872900854, 2), (datetime.date(2026, 3, 25), 0.5067162242498477, 4), (datetime.date(2026, 3, 26), 0.5544964925256038, 2), (datetime.date(2026, 3, 27), 0.5326140546903921, 2), (datetime.date(2026, 3, 28), 0.5560329815216204, 4), (datetime.date(2026, 3, 29), 0.5389692562140327, 3), (datetime.date(2026, 3, 30), 0.5869333656724182, 4), (datetime.date(2026, 3, 31), 0.5867682395975724, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 3, 1), 0.5126976205556434, 4), (datetime.date(2026, 3, 2), 0.537143384882954, 4), (datetime.date(2026, 3, 3), 0.447030691576785, 4), (datetime.date(2026, 3, 4), 0.43519026428294705, 4), (datetime.date(2026, 3, 5), 0.4782215886316019, 3), (datetime.date(2026, 3, 6), 0.5132197521876982, 3), (datetime.date(2026, 3, 7), 0.5323825380091316, 4), (datetime.date(2026, 3, 9), 0.4300586701350677, 4), (datetime.date(2026, 3, 10), 0.41694850601847155, 4), (datetime.date(2026, 3, 11), 0.43820248767647046, 1), (datetime.date(2026, 3, 12), 0.4439627392584588, 3), (datetime.date(2026, 3, 13), 0.4733956795655209, 3), (datetime.date(2026, 3, 14), 0.4591409429635688, 3), (datetime.date(2026, 3, 15), 0.538670279893417, 4), (datetime.date(2026, 3, 16), 0.7126006380172706, 4), (datetime.date(2026, 3, 17), 0.5734136210496968, 4), (datetime.date(2026, 3, 18), 0.4942921191220215, 3), (datetime.date(2026, 3, 19), 0.502950234477714, 4), (datetime.date(2026, 3, 20), 0.47059647937569093, 3), (datetime.date(2026, 3, 21), 0.5018912533601555, 3), (datetime.date(2026, 3, 22), 0.46516297433561504, 4), (datetime.date(2026, 3, 23), 0.5658153196685091, 1), (datetime.date(2026, 3, 24), 0.5039341872900854, 2), (datetime.date(2026, 3, 25), 0.5067162242498477, 4), (datetime.date(2026, 3, 26), 0.5544964925256038, 2), (datetime.date(2026, 3, 27), 0.5326140546903921, 2), (datetime.date(2026, 3, 28), 0.5560329815216204, 4), (datetime.date(2026, 3, 29), 0.5389692562140327, 3), (datetime.date(2026, 3, 30), 0.5869333656724182, 4), (datetime.date(2026, 3, 31), 0.5867682395975724, 3))}, 'quality_array': [['-8.421830871606627', '01032026'], ['-8.05279475501724', '02032026'], ['-8.013077520110315', '03032026'], ['-7.896128397743088', '04032026'], ['-8.387273080053385', '05032026'], ['-8.361574820017413', '06032026'], ['-8.24908916892196', '07032026'], ['-8.079712616625697', '09032026'], ['-7.872171899851991', '10032026'], ['-8.461628648512095', '11032026'], ['-8.168411538886149', '12032026'], ['-8.405700134898357', '13032026'], ['-8.374184692035493', '14032026'], ['-8.368408176165442', '15032026'], ['-8.156174635418335', '16032026'], ['-8.17504849994369', '17032026'], ['-7.682899033126132', '18032026'], ['-7.767544450522995', '19032026'], ['-8.009195424648615', '20032026'], ['-7.867778984613812', '21032026'], ['-7.773893123617658', '22032026'], ['-7.896589185653124', '23032026'], ['-7.837311247808208', '24032026'], ['-7.6884274618485104', '25032026'], ['-7.550336219568495', '26032026'], ['-7.902217801606997', '27032026'], ['-7.611496217375953', '28032026'], ['-8.154963907369819', '29032026'], ['-8.286445972967353', '30032026'], ['-7.924420794901804', '31032026']], 'number_of_batch': ((664,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.026834563235748954, 'nb_photo': 28504, 'list_port_cont': '30585658,30585760,30585799,30585841,30585877,30585918,30585951,30585978,30586021,30586063,30586097,30586135,30586159,30586207,30586235,30586274,30586310,30586340,30586394,30586423,30586465,30586585,30586625,30586778,30600099,30600410,30600623,30600644,30600687,30600733,30600807,30600836,30600876,30600920,30600957,30601009,30601040,30601061,30601122,30601149,30601190,30601242,30601275,30601320,30601366,30601586,30601869,30613816,30613899,30614843,30614883,30614918,30614950,30615028,30615056,30615093,30615134,30615180,30615216,30615240,30615325,30615364,30615447,30615497,30615542,30615584,30615609,30615622,30615868,30616475,30616694,30630235,30630330,30630560,30630949,30631061,30631277,30631525,30631797,30631873,30632153,30632175,30632264,30632408,30632487,30632561,30632620,30632696,30632776,30633476,30633935,30652628,30653785,30653939,30654014,30654264,30654415,30654454,30654481,30654594,30654637,30654672,30654703,30654860,30654909,30654929,30655207,30655232,30655267,30655359,30655395,30655422,30655532,3065568', 'assoc_port': '30585623:30586135,30585624:30586625,30585625:30586310,30585626:30586274,30585627:30586394,30585628:30586159,30585629:30586465,30585630:30586235,30585631:30586423,30585632:30586207,30585633:30586097,30585634:30586340,30585635:30586063,30585637:30586021,30585638:30585978,30585639:30585918,30585640:30585877,30585641:30585951,30585642:30585841,30585643:30585760,30585644:30585658,30585645:30585799,30586497:30586585,30586659:30586778,30599641:30600410,30599644:30600920,30599645:30601366,30599648:30601275,30599652:30601149,30599653:30601190,30599656:30601320,30599657:30601009,30599659:30601122,30599663:30600836,30599664:30600957,30599666:30600876,30599669:30600807,30599671:30601242,30599672:30601040,30599675:30600687,30599678:30601061,30599680:30600644,30599681:30600733,30599684:30600623,30599685:30600099,30601507:30601586,30601760:30601869,30613724:30615868,30613726:30615584,30613728:30615364,30613730:30615497,30613732:30615609,30613734:30615216,30613736:30615622,30613738:30615542,30613740:30615447,30613742:3061524', 'assoc_mat': '30585623:autre:4230:30586135,30585624:autre:4230:30586625,30585625:autre:4230:30586310,30585626:autre:4230:30586274,30585627:autre:4230:30586394,30585628:autre:4230:30586159,30585629:autre:4230:30586465,30585630:autre:4230:30586235,30585631:autre:4230:30586423,30585632:autre:4230:30586207,30585633:autre:4230:30586097,30585634:autre:4230:30586340,30585635:autre:4230:30586063,30585637:autre:4230:30586021,30585638:autre:4230:30585978,30585639:autre:4230:30585918,30585640:autre:4230:30585877,30585641:autre:4230:30585951,30585642:autre:4230:30585841,30585643:autre:4230:30585760,30585644:autre:4230:30585658,30585645:autre:4230:30585799,30586497:autre:4230:30586585,30586659:autre:4230:30586778,30599641:autre:4230:30600410,30599644:autre:4230:30600920,30599645:autre:4230:30601366,30599648:autre:4230:30601275,30599652:autre:4230:30601149,30599653:autre:4230:30601190,30599656:autre:4230:30601320,30599657:autre:4230:30601009,30599659:autre:4230:30601122,30599663:autre:4230:30600836,30599664:autre:4230:30600957,30599666:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.10006369597770524, 'nb_photo': 133385, 'list_port_cont': '30585665,30585773,30585798,30585846,30585885,30585911,30585947,30585987,30586022,30586051,30586100,30586130,30586166,30586209,30586241,30586277,30586313,30586348,30586389,30586424,30586454,30586587,30586628,30586783,30600110,30600423,30600618,30600657,30600696,30600728,30600800,30600841,30600874,30600919,30600953,30601006,30601042,30601055,30601113,30601152,30601204,30601243,30601286,30601322,30601374,30601597,30601870,30613803,30613904,30614852,30614877,30614924,30614960,30615025,30615066,30615102,30615142,30615178,30615210,30615253,30615323,30615370,30615455,30615507,30615544,30615578,30615620,30615631,30615862,30616485,30616693,30630221,30630335,30630570,30630938,30631060,30631275,30631523,30631800,30631862,30632165,30632187,30632271,30632397,30632477,30632568,30632629,30632701,30632774,30633492,30633930,30652621,30653795,30653938,30654007,30654275,30654412,30654452,30654485,30654599,30654631,30654677,30654714,30654863,30654899,30654941,30655205,30655236,30655280,30655357,30655391,30655430,30655536,3065570', 'assoc_port': '30585623:30586130,30585624:30586628,30585625:30586313,30585626:30586277,30585627:30586389,30585628:30586166,30585629:30586454,30585630:30586241,30585631:30586424,30585632:30586209,30585633:30586100,30585634:30586348,30585635:30586051,30585637:30586022,30585638:30585987,30585639:30585911,30585640:30585885,30585641:30585947,30585642:30585846,30585643:30585773,30585644:30585665,30585645:30585798,30586497:30586587,30586659:30586783,30599641:30600423,30599644:30600919,30599645:30601374,30599648:30601286,30599652:30601152,30599653:30601204,30599656:30601322,30599657:30601006,30599659:30601113,30599663:30600841,30599664:30600953,30599666:30600874,30599669:30600800,30599671:30601243,30599672:30601042,30599675:30600696,30599678:30601055,30599680:30600657,30599681:30600728,30599684:30600618,30599685:30600110,30601507:30601597,30601760:30601870,30613724:30615862,30613726:30615578,30613728:30615370,30613730:30615507,30613732:30615620,30613734:30615210,30613736:30615631,30613738:30615544,30613740:30615455,30613742:3061525', 'assoc_mat': '30585623:carton:4230:30586130,30585624:carton:4230:30586628,30585625:carton:4230:30586313,30585626:carton:4230:30586277,30585627:carton:4230:30586389,30585628:carton:4230:30586166,30585629:carton:4230:30586454,30585630:carton:4230:30586241,30585631:carton:4230:30586424,30585632:carton:4230:30586209,30585633:carton:4230:30586100,30585634:carton:4230:30586348,30585635:carton:4230:30586051,30585637:carton:4230:30586022,30585638:carton:4230:30585987,30585639:carton:4230:30585911,30585640:carton:4230:30585885,30585641:carton:4230:30585947,30585642:carton:4230:30585846,30585643:carton:4230:30585773,30585644:carton:4230:30585665,30585645:carton:4230:30585798,30586497:carton:4230:30586587,30586659:carton:4230:30586783,30599641:carton:4230:30600423,30599644:carton:4230:30600919,30599645:carton:4230:30601374,30599648:carton:4230:30601286,30599652:carton:4230:30601152,30599653:carton:4230:30601204,30599656:carton:4230:30601322,30599657:carton:4230:30601006,30599659:carton:4230:30601113,30599663:carton:4230:30600841,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021539239598164237, 'nb_photo': 2322, 'list_port_cont': '30585664,30585774,30585808,30585849,30585878,30585912,30585945,30585993,30586030,30586052,30586140,30586172,30586197,30586240,30586270,30586306,30586357,30586377,30586418,30586449,30586580,30586624,30586787,30600093,30600415,30600619,30600791,30600912,30600943,30601008,30601053,30601108,30601196,30601227,30601284,30601332,30601379,30601599,30601879,30613911,30614853,30615020,30615212,30615372,30615453,30615494,30615530,30615577,30615629,30615880,30630939,30631050,30631274,30631514,30631805,30632161,30632182,30632399,30632486,30632565,30632627,30633480,30633938,30652630,30653781,30653940,30654012,30654271,30654401,30654446,30654483,30654589,30654635,30654678,30654702,30654869,30654894,30654933,30655193,30655227,30655276,30655345,30655380,30655433,30655541,30655699,30655915,30664224,30664259,30664289,30664401,30664475,30664642,30664685,30664724,30664751,30664788,30664810,30664889,30664966,30665041,30665117,30665148,30665193,30665335,30665755,30666031,30677340,30677599,30677680,30677921,30677992,30678027,3067830', 'assoc_port': '30585623:30586140,30585624:30586624,30585625:30586306,30585626:30586270,30585627:30586377,30585628:30586172,30585629:30586449,30585630:30586240,30585631:30586418,30585632:30586197,30585634:30586357,30585635:30586052,30585637:30586030,30585638:30585993,30585639:30585912,30585640:30585878,30585641:30585945,30585642:30585849,30585643:30585774,30585644:30585664,30585645:30585808,30586497:30586580,30586659:30586787,30599641:30600415,30599644:30600912,30599645:30601379,30599648:30601284,30599653:30601196,30599656:30601332,30599657:30601008,30599659:30601108,30599664:30600943,30599669:30600791,30599671:30601227,30599678:30601053,30599684:30600619,30599685:30600093,30601507:30601599,30601760:30601879,30613724:30615880,30613726:30615577,30613728:30615372,30613730:30615494,30613734:30615212,30613736:30615629,30613738:30615530,30613740:30615453,30613760:30615020,30613767:30613911,30613769:30614853,30629664:30630939,30629667:30631050,30629673:30631274,30629677:30631514,30629682:30633938,30629693:30632182,30629699:3063248', 'assoc_mat': '30585623:metal:4230:30586140,30585624:metal:4230:30586624,30585625:metal:4230:30586306,30585626:metal:4230:30586270,30585627:metal:4230:30586377,30585628:metal:4230:30586172,30585629:metal:4230:30586449,30585630:metal:4230:30586240,30585631:metal:4230:30586418,30585632:metal:4230:30586197,30585634:metal:4230:30586357,30585635:metal:4230:30586052,30585637:metal:4230:30586030,30585638:metal:4230:30585993,30585639:metal:4230:30585912,30585640:metal:4230:30585878,30585641:metal:4230:30585945,30585642:metal:4230:30585849,30585643:metal:4230:30585774,30585644:metal:4230:30585664,30585645:metal:4230:30585808,30586497:metal:4230:30586580,30586659:metal:4230:30586787,30599641:metal:4230:30600415,30599644:metal:4230:30600912,30599645:metal:4230:30601379,30599648:metal:4230:30601284,30599653:metal:4230:30601196,30599656:metal:4230:30601332,30599657:metal:4230:30601008,30599659:metal:4230:30601108,30599664:metal:4230:30600943,30599669:metal:4230:30600791,30599671:metal:4230:30601227,30599678:metal:4230:30601053,30599684:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3583340139198026, 'nb_photo': 410921, 'list_port_cont': '30585657,30585769,30585811,30585843,30585884,30585905,30585952,30585986,30586029,30586066,30586101,30586136,30586171,30586211,30586248,30586276,30586317,30586351,30586391,30586417,30586460,30586589,30586617,30586798,30600113,30600420,30600624,30600661,30600697,30600736,30600802,30600838,30600873,30600917,30600958,30600995,30601041,30601062,30601120,30601157,30601201,30601231,30601288,30601329,30601378,30601603,30601878,30613817,30613907,30614851,30614886,30614921,30614962,30615035,30615060,30615106,30615143,30615176,30615208,30615252,30615318,30615367,30615461,30615505,30615545,30615574,30615608,30615633,30615870,30616489,30616698,30630230,30630333,30630566,30630950,30631056,30631266,30631516,30631802,30631867,30632162,30632186,30632274,30632406,30632483,30632569,30632630,30632707,30632767,30633490,30633934,30652619,30653788,30653937,30654016,30654260,30654406,30654445,30654491,30654604,30654627,30654676,30654715,30654870,30654908,30654946,30655200,30655244,30655274,30655360,30655388,30655428,30655540,3065569', 'assoc_port': '30585623:30586136,30585624:30586617,30585625:30586317,30585626:30586276,30585627:30586391,30585628:30586171,30585629:30586460,30585630:30586248,30585631:30586417,30585632:30586211,30585633:30586101,30585634:30586351,30585635:30586066,30585637:30586029,30585638:30585986,30585639:30585905,30585640:30585884,30585641:30585952,30585642:30585843,30585643:30585769,30585644:30585657,30585645:30585811,30586497:30586589,30586659:30586798,30599641:30600420,30599644:30600917,30599645:30601378,30599648:30601288,30599652:30601157,30599653:30601201,30599656:30601329,30599657:30600995,30599659:30601120,30599663:30600838,30599664:30600958,30599666:30600873,30599669:30600802,30599671:30601231,30599672:30601062,30599675:30600697,30599678:30601041,30599680:30600661,30599681:30600736,30599684:30600624,30599685:30600113,30601507:30601603,30601760:30601878,30613724:30615870,30613726:30615574,30613728:30615367,30613730:30615505,30613732:30615608,30613734:30615208,30613736:30615633,30613738:30615545,30613740:30615461,30613742:3061525', 'assoc_mat': '30585623:papier:4230:30586136,30585624:papier:4230:30586617,30585625:papier:4230:30586317,30585626:papier:4230:30586276,30585627:papier:4230:30586391,30585628:papier:4230:30586171,30585629:papier:4230:30586460,30585630:papier:4230:30586248,30585631:papier:4230:30586417,30585632:papier:4230:30586211,30585633:papier:4230:30586101,30585634:papier:4230:30586351,30585635:papier:4230:30586066,30585637:papier:4230:30586029,30585638:papier:4230:30585986,30585639:papier:4230:30585905,30585640:papier:4230:30585884,30585641:papier:4230:30585952,30585642:papier:4230:30585843,30585643:papier:4230:30585769,30585644:papier:4230:30585657,30585645:papier:4230:30585811,30586497:papier:4230:30586589,30586659:papier:4230:30586798,30599641:papier:4230:30600420,30599644:papier:4230:30600917,30599645:papier:4230:30601378,30599648:papier:4230:30601288,30599652:papier:4230:30601157,30599653:papier:4230:30601201,30599656:papier:4230:30601329,30599657:papier:4230:30600995,30599659:papier:4230:30601120,30599663:papier:4230:30600838,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006489589246646342, 'nb_photo': 6808, 'list_port_cont': '30585660,30585766,30585806,30585837,30585872,30585921,30585957,30585985,30586027,30586058,30586096,30586131,30586173,30586203,30586247,30586285,30586321,30586349,30586384,30586429,30586461,30586588,30586623,30586786,30600107,30600408,30600617,30600647,30600688,30600729,30600798,30600843,30600879,30600915,30600956,30601004,30601034,30601059,30601123,30601162,30601205,30601237,30601278,30601324,30601380,30601601,30601864,30613812,30613912,30614840,30614887,30614954,30615029,30615067,30615097,30615138,30615167,30615219,30615250,30615311,30615369,30615457,30615503,30615540,30615582,30615616,30615632,30615882,30616483,30616704,30630229,30630323,30630567,30630948,30631064,30631267,30631519,30631794,30631877,30632169,30632183,30632270,30632402,30632476,30632559,30632626,30632693,30633483,30633926,30652631,30653791,30653942,30654018,30654265,30654410,30654443,30654489,30654605,30654638,30654674,30654700,30654865,30654901,30654942,30655202,30655239,30655283,30655350,30655389,30655429,30655537,30655701,30655914,3066419', 'assoc_port': '30585623:30586131,30585624:30586623,30585625:30586321,30585626:30586285,30585627:30586384,30585628:30586173,30585629:30586461,30585630:30586247,30585631:30586429,30585632:30586203,30585633:30586096,30585634:30586349,30585635:30586058,30585637:30586027,30585638:30585985,30585639:30585921,30585640:30585872,30585641:30585957,30585642:30585837,30585643:30585766,30585644:30585660,30585645:30585806,30586497:30586588,30586659:30586786,30599641:30600408,30599644:30600915,30599645:30601380,30599648:30601278,30599652:30601162,30599653:30601205,30599656:30601324,30599657:30601004,30599659:30601123,30599663:30600843,30599664:30600956,30599666:30600879,30599669:30600798,30599671:30601237,30599672:30601034,30599675:30600688,30599678:30601059,30599680:30600647,30599681:30600729,30599684:30600617,30599685:30600107,30601507:30601601,30601760:30601864,30613724:30615882,30613726:30615582,30613728:30615369,30613730:30615503,30613732:30615616,30613734:30615219,30613736:30615632,30613738:30615540,30613740:30615457,30613742:3061525', 'assoc_mat': '30585623:pehd:4230:30586131,30585624:pehd:4230:30586623,30585625:pehd:4230:30586321,30585626:pehd:4230:30586285,30585627:pehd:4230:30586384,30585628:pehd:4230:30586173,30585629:pehd:4230:30586461,30585630:pehd:4230:30586247,30585631:pehd:4230:30586429,30585632:pehd:4230:30586203,30585633:pehd:4230:30586096,30585634:pehd:4230:30586349,30585635:pehd:4230:30586058,30585637:pehd:4230:30586027,30585638:pehd:4230:30585985,30585639:pehd:4230:30585921,30585640:pehd:4230:30585872,30585641:pehd:4230:30585957,30585642:pehd:4230:30585837,30585643:pehd:4230:30585766,30585644:pehd:4230:30585660,30585645:pehd:4230:30585806,30586497:pehd:4230:30586588,30586659:pehd:4230:30586786,30599641:pehd:4230:30600408,30599644:pehd:4230:30600915,30599645:pehd:4230:30601380,30599648:pehd:4230:30601278,30599652:pehd:4230:30601162,30599653:pehd:4230:30601205,30599656:pehd:4230:30601324,30599657:pehd:4230:30601004,30599659:pehd:4230:30601123,30599663:pehd:4230:30600843,30599664:pehd:4230:30600956,30599666:pehd:4230:30600879,30599669:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014083399077655986, 'nb_photo': 27503, 'list_port_cont': '30585666,30585772,30585803,30585840,30585874,30585916,30585950,30585991,30586015,30586061,30586095,30586134,30586169,30586210,30586246,30586279,30586319,30586355,30586387,30586430,30586464,30586579,30586618,30586785,30600106,30600412,30600621,30600660,30600695,30600735,30600808,30600834,30600883,30600916,30600951,30601007,30601044,30601047,30601121,30601158,30601200,30601230,30601282,30601318,30601373,30601589,30601872,30613808,30613913,30614846,30614889,30614922,30614953,30615031,30615064,30615101,30615136,30615169,30615211,30615245,30615324,30615363,30615460,30615509,30615534,30615580,30615619,30615636,30615885,30616487,30616703,30630231,30630329,30630558,30630951,30631055,30631278,30631522,30631798,30631869,30632159,30632185,30632277,30632405,30632485,30632571,30632628,30632694,30632783,30633493,30633933,30652624,30653792,30653945,30654017,30654272,30654409,30654441,30654490,30654600,30654642,30654666,30654716,30654866,30654910,30654945,30655206,30655242,30655282,30655356,30655387,30655432,30655534,3065570', 'assoc_port': '30585623:30586134,30585624:30586618,30585625:30586319,30585626:30586279,30585627:30586387,30585628:30586169,30585629:30586464,30585630:30586246,30585631:30586430,30585632:30586210,30585633:30586095,30585634:30586355,30585635:30586061,30585637:30586015,30585638:30585991,30585639:30585916,30585640:30585874,30585641:30585950,30585642:30585840,30585643:30585772,30585644:30585666,30585645:30585803,30586497:30586579,30586659:30586785,30599641:30600412,30599644:30600916,30599645:30601373,30599648:30601282,30599652:30601158,30599653:30601200,30599656:30601318,30599657:30601007,30599659:30601121,30599663:30600834,30599664:30600951,30599666:30600883,30599669:30600808,30599671:30601230,30599672:30601044,30599675:30600695,30599678:30601047,30599680:30600660,30599681:30600735,30599684:30600621,30599685:30600106,30601507:30601589,30601760:30601872,30613724:30615885,30613726:30615580,30613728:30615363,30613730:30615509,30613732:30615619,30613734:30615211,30613736:30615636,30613738:30615534,30613740:30615460,30613742:3061524', 'assoc_mat': '30585623:pet_clair:4230:30586134,30585624:pet_clair:4230:30586618,30585625:pet_clair:4230:30586319,30585626:pet_clair:4230:30586279,30585627:pet_clair:4230:30586387,30585628:pet_clair:4230:30586169,30585629:pet_clair:4230:30586464,30585630:pet_clair:4230:30586246,30585631:pet_clair:4230:30586430,30585632:pet_clair:4230:30586210,30585633:pet_clair:4230:30586095,30585634:pet_clair:4230:30586355,30585635:pet_clair:4230:30586061,30585637:pet_clair:4230:30586015,30585638:pet_clair:4230:30585991,30585639:pet_clair:4230:30585916,30585640:pet_clair:4230:30585874,30585641:pet_clair:4230:30585950,30585642:pet_clair:4230:30585840,30585643:pet_clair:4230:30585772,30585644:pet_clair:4230:30585666,30585645:pet_clair:4230:30585803,30586497:pet_clair:4230:30586579,30586659:pet_clair:4230:30586785,30599641:pet_clair:4230:30600412,30599644:pet_clair:4230:30600916,30599645:pet_clair:4230:30601373,30599648:pet_clair:4230:30601282,30599652:pet_clair:4230:30601158,30599653:pet_clair:4230:30601200,30599656:pet_clair:4230:30601318,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007633789725173568, 'nb_photo': 2483, 'list_port_cont': '30585662,30585765,30585801,30585847,30585883,30585917,30585956,30585994,30586023,30586059,30586094,30586138,30586170,30586204,30586245,30586314,30586350,30586393,30586415,30586590,30586627,30586781,30600422,30600620,30600656,30600699,30600719,30600842,30600881,30600921,30600955,30601045,30601056,30601115,30601202,30601236,30601280,30601333,30601375,30601602,30601877,30613909,30614847,30614914,30614949,30615104,30615139,30615175,30615217,30615246,30615321,30615366,30615462,30615502,30615537,30615575,30615621,30615639,30615864,30616486,30616707,30630234,30630337,30630569,30630943,30631058,30631272,30631518,30631799,30631874,30632168,30632177,30632400,30632478,30632567,30632624,30632775,30633489,30633939,30652629,30653789,30653944,30654005,30654273,30654414,30654455,30654494,30654596,30654636,30654670,30654709,30654872,30654906,30654934,30655201,30655237,30655272,30655354,30655394,30655431,30655543,30655703,30655909,30664191,30664216,30664267,30664301,30664375,30664402,30664485,30664518,30664556,30664651,3066468', 'assoc_port': '30585623:30586138,30585624:30586627,30585625:30586314,30585627:30586393,30585628:30586170,30585630:30586245,30585631:30586415,30585632:30586204,30585633:30586094,30585634:30586350,30585635:30586059,30585637:30586023,30585638:30585994,30585639:30585917,30585640:30585883,30585641:30585956,30585642:30585847,30585643:30585765,30585644:30585662,30585645:30585801,30586497:30586590,30586659:30586781,30599641:30600422,30599644:30600921,30599645:30601375,30599648:30601280,30599653:30601202,30599656:30601333,30599659:30601115,30599663:30600842,30599664:30600955,30599666:30600881,30599671:30601236,30599672:30601056,30599675:30600699,30599678:30601045,30599680:30600656,30599681:30600719,30599684:30600620,30601507:30601602,30601760:30601877,30613724:30615864,30613726:30615575,30613728:30615366,30613730:30615502,30613732:30615621,30613734:30615217,30613736:30615639,30613738:30615537,30613740:30615462,30613742:30615246,30613744:30615321,30613746:30614914,30613748:30615175,30613751:30615104,30613754:30615139,30613757:3061494', 'assoc_mat': '30585623:pet_fonce:4230:30586138,30585624:pet_fonce:4230:30586627,30585625:pet_fonce:4230:30586314,30585627:pet_fonce:4230:30586393,30585628:pet_fonce:4230:30586170,30585630:pet_fonce:4230:30586245,30585631:pet_fonce:4230:30586415,30585632:pet_fonce:4230:30586204,30585633:pet_fonce:4230:30586094,30585634:pet_fonce:4230:30586350,30585635:pet_fonce:4230:30586059,30585637:pet_fonce:4230:30586023,30585638:pet_fonce:4230:30585994,30585639:pet_fonce:4230:30585917,30585640:pet_fonce:4230:30585883,30585641:pet_fonce:4230:30585956,30585642:pet_fonce:4230:30585847,30585643:pet_fonce:4230:30585765,30585644:pet_fonce:4230:30585662,30585645:pet_fonce:4230:30585801,30586497:pet_fonce:4230:30586590,30586659:pet_fonce:4230:30586781,30599641:pet_fonce:4230:30600422,30599644:pet_fonce:4230:30600921,30599645:pet_fonce:4230:30601375,30599648:pet_fonce:4230:30601280,30599653:pet_fonce:4230:30601202,30599656:pet_fonce:4230:30601333,30599659:pet_fonce:4230:30601115,30599663:pet_fonce:4230:30600842,30599664:pet_fonce:4230:30600955,3'}), 'main_stat': {'nb_photos': 2118}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30842638,30842640,30842641,30842642,30842643,30842644,30842645?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-03', 0.5120049032463452),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_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', '2.68%', 28504], 'carton': ['carton', '10.01%', 133385], 'metal': ['metal', '0.22%', 2322], 'papier': ['papier', '35.83%', 410921], 'pehd': ['pehd', '0.65%', 6808], 'pet_clair': ['pet_clair', '1.41%', 27503], 'pet_fonce': ['pet_fonce', '0.76%', 2483]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_03_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.53user 2.63system 0:10.73elapsed 48%CPU (0avgtext+0avgdata 186636maxresident)k 0inputs+312outputs (7major+49393minor)pagefaults 0swaps