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_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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 : 202 month : 03 mtr_id : dashboard_places : SCCU_cam6 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_cam6' 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 = 202 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 = 202 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 = 202 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_cam6" 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 (2935049,2936596,2938324,2940111,2943516,2944699,2945779,2946567,2947681,2948814,2950250,2951659,2952641,2953222,2954935,2956521,2958002,2959606,2961723,2962849,2963390,2965020,2966601,2968218,2969002,2969726,2970306,2970811,2971483,2972144) 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.01656923096325058, 'nb_photo': 23698, 'list_port_cont': '30579190,30579401,30580123,30580517,30580769,30581051,30581525,30581573,30581971,30582377,30582736,30583023,30583462,30584090,30584479,30584862,30585009,30585109,30585269,30585378,30585587,30585706,30586553,30586721,30586977,30587096,30587317,30587395,30587773,30588310,30589245,30590200,30590995,30591572,30592412,30592897,30594419,30594576,30595505,30596042,30597617,30597815,30598197,30598905,30599418,30599698,30601537,30601764,30613868,30614036,30614475,30614754,30614978,30615286,30615401,30615694,30615727,30615732,30615812,30615883,30615925,30616008,30616032,30616102,30616143,30616179,30616227,30616271,30616324,30616380,30616510,30616735,30631381,30631431,30631473,30631548,30631603,30631687,30631752,30631854,30631907,30631956,30632008,30632046,30632070,30632123,30632233,30632320,30632366,30632413,30632514,30632662,30632848,30632894,30633532,30634187,30653048,30653255,30653346,30653431,30653739,30654079,30654306,30654513,30654546,30654755,30654795,30654827,30654970,30655014,30655050,30655095,30655120,3065515', 'assoc_port': '30578995:30579190,30579357:30579401,30579971:30580123,30580349:30580517,30580703:30580769,30580962:30581051,30581506:30581525,30581507:30581573,30581887:30581971,30582200:30582377,30582555:30582736,30582936:30583023,30583319:30583462,30583939:30584090,30584428:30584479,30584788:30584862,30584955:30585009,30585084:30585109,30585249:30585269,30585250:30585378,30585419:30585587,30585621:30585706,30586494:30586553,30586657:30586721,30586865:30586977,30587092:30587096,30587296:30587395,30587297:30587317,30587552:30587773,30588279:30588310,30589061:30589245,30590114:30590200,30590942:30590995,30591512:30591572,30592286:30592412,30592783:30592897,30594261:30594419,30594262:30594576,30595171:30595505,30595869:30596042,30597461:30597617,30597462:30597815,30598166:30598197,30598812:30598905,30599262:30599418,30599639:30599698,30601505:30601537,30601759:30601764,30613718:30613868,30613719:30614036,30613720:30614475,30613721:30614754,30613722:30614978,30613723:30615286,30613725:30615401,30613727:30615732,30613729:3061603', 'assoc_mat': '30578995:autre:4230:30579190,30579357:autre:4230:30579401,30579971:autre:4230:30580123,30580349:autre:4230:30580517,30580703:autre:4230:30580769,30580962:autre:4230:30581051,30581506:autre:4230:30581525,30581507:autre:4230:30581573,30581887:autre:4230:30581971,30582200:autre:4230:30582377,30582555:autre:4230:30582736,30582936:autre:4230:30583023,30583319:autre:4230:30583462,30583939:autre:4230:30584090,30584428:autre:4230:30584479,30584788:autre:4230:30584862,30584955:autre:4230:30585009,30585084:autre:4230:30585109,30585249:autre:4230:30585269,30585250:autre:4230:30585378,30585419:autre:4230:30585587,30585621:autre:4230:30585706,30586494:autre:4230:30586553,30586657:autre:4230:30586721,30586865:autre:4230:30586977,30587092:autre:4230:30587096,30587296:autre:4230:30587395,30587297:autre:4230:30587317,30587552:autre:4230:30587773,30588279:autre:4230:30588310,30589061:autre:4230:30589245,30590114:autre:4230:30590200,30590942:autre:4230:30590995,30591512:autre:4230:30591572,30592286:autre:4230:30592412,30592783:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04268492423802562, 'nb_photo': 93968, 'list_port_cont': '30579194,30579402,30580131,30580514,30580779,30581059,30581531,30581576,30581975,30582385,30582738,30583025,30583473,30584101,30584487,30584859,30585004,30585103,30585272,30585377,30585575,30585715,30586549,30586718,30586989,30587097,30587315,30587388,30587782,30588320,30589249,30590193,30590994,30591570,30592420,30592896,30594415,30594593,30595508,30596036,30597621,30597812,30598190,30598900,30599435,30599714,30601542,30601769,30613867,30614032,30614472,30614763,30614976,30615279,30615414,30615685,30615719,30615741,30615813,30615857,30615938,30616004,30616042,30616103,30616149,30616189,30616240,30616266,30616323,30616394,30616516,30616740,30631390,30631425,30631461,30631556,30631617,30631695,30631758,30631846,30631931,30631969,30632010,30632040,30632086,30632129,30632239,30632323,30632362,30632418,30632531,30632657,30632847,30632910,30633537,30634205,30653045,30653265,30653351,30653435,30653737,30654076,30654301,30654502,30654551,30654762,30654797,30654826,30654982,30655018,30655053,30655090,30655133,3065516', 'assoc_port': '30578995:30579194,30579357:30579402,30579971:30580131,30580349:30580514,30580703:30580779,30580962:30581059,30581506:30581531,30581507:30581576,30581887:30581975,30582200:30582385,30582555:30582738,30582936:30583025,30583319:30583473,30583939:30584101,30584428:30584487,30584788:30584859,30584955:30585004,30585084:30585103,30585249:30585272,30585250:30585377,30585419:30585575,30585621:30585715,30586494:30586549,30586657:30586718,30586865:30586989,30587092:30587097,30587296:30587388,30587297:30587315,30587552:30587782,30588279:30588320,30589061:30589249,30590114:30590193,30590942:30590994,30591512:30591570,30592286:30592420,30592783:30592896,30594261:30594415,30594262:30594593,30595171:30595508,30595869:30596036,30597461:30597621,30597462:30597812,30598166:30598190,30598812:30598900,30599262:30599435,30599639:30599714,30601505:30601542,30601759:30601769,30613718:30613867,30613719:30614032,30613720:30614472,30613721:30614763,30613722:30614976,30613723:30615279,30613725:30615414,30613727:30615741,30613729:3061604', 'assoc_mat': '30578995:carton:4230:30579194,30579357:carton:4230:30579402,30579971:carton:4230:30580131,30580349:carton:4230:30580514,30580703:carton:4230:30580779,30580962:carton:4230:30581059,30581506:carton:4230:30581531,30581507:carton:4230:30581576,30581887:carton:4230:30581975,30582200:carton:4230:30582385,30582555:carton:4230:30582738,30582936:carton:4230:30583025,30583319:carton:4230:30583473,30583939:carton:4230:30584101,30584428:carton:4230:30584487,30584788:carton:4230:30584859,30584955:carton:4230:30585004,30585084:carton:4230:30585103,30585249:carton:4230:30585272,30585250:carton:4230:30585377,30585419:carton:4230:30585575,30585621:carton:4230:30585715,30586494:carton:4230:30586549,30586657:carton:4230:30586718,30586865:carton:4230:30586989,30587092:carton:4230:30587097,30587296:carton:4230:30587388,30587297:carton:4230:30587315,30587552:carton:4230:30587782,30588279:carton:4230:30588320,30589061:carton:4230:30589249,30590114:carton:4230:30590193,30590942:carton:4230:30590994,30591512:carton:4230:30591570,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011946985956659505, 'nb_photo': 1950, 'list_port_cont': '30579183,30580134,30580512,30580774,30581528,30581569,30581965,30582734,30583465,30584103,30584481,30584864,30585274,30585572,30585705,30586548,30586708,30586994,30588324,30589252,30590194,30590990,30591583,30592405,30594410,30594580,30595501,30597616,30597811,30598904,30599431,30601540,30601778,30613877,30614028,30614473,30614747,30614967,30615282,30615399,30615683,30615713,30615738,30615799,30615853,30615928,30616001,30616045,30616101,30616151,30616188,30616238,30616265,30616321,30616386,30616520,30616729,30631396,30631418,30631466,30631611,30631688,30631748,30631850,30631891,30631971,30632005,30632041,30632084,30632119,30632226,30632319,30632371,30632426,30632516,30632663,30632849,30632896,30633540,30634191,30653043,30653253,30653738,30654087,30654299,30654507,30654544,30654793,30654981,30655022,30655081,30655119,30655161,30655303,30655472,30655476,30655574,30655658,30655814,30664139,30664445,30664591,30664864,30665001,30665086,30665214,30665255,30665279,30665340,30665406,30665443,30665485,30665537,3066557', 'assoc_port': '30578995:30579183,30579971:30580134,30580349:30580512,30580703:30580774,30581506:30581528,30581507:30581569,30581887:30581965,30582555:30582734,30583319:30583465,30583939:30584103,30584428:30584481,30584788:30584864,30585249:30585274,30585419:30585572,30585621:30585705,30586494:30586548,30586657:30586708,30586865:30586994,30588279:30588324,30589061:30589252,30590114:30590194,30590942:30590990,30591512:30591583,30592286:30592405,30594261:30594410,30594262:30594580,30595171:30595501,30597461:30597616,30597462:30597811,30598812:30598904,30599262:30599431,30601505:30601540,30601759:30601778,30613718:30613877,30613719:30614028,30613720:30614473,30613721:30614747,30613722:30614967,30613723:30615282,30613725:30615399,30613727:30615738,30613729:30616045,30613731:30616265,30613733:30616238,30613735:30616188,30613737:30616321,30613739:30616101,30613741:30616001,30613743:30616151,30613745:30616386,30613747:30615799,30613750:30615683,30613753:30615928,30613756:30615853,30613759:30615713,30616413:30616520,30616601:3061672', 'assoc_mat': '30578995:metal:4230:30579183,30579971:metal:4230:30580134,30580349:metal:4230:30580512,30580703:metal:4230:30580774,30581506:metal:4230:30581528,30581507:metal:4230:30581569,30581887:metal:4230:30581965,30582555:metal:4230:30582734,30583319:metal:4230:30583465,30583939:metal:4230:30584103,30584428:metal:4230:30584481,30584788:metal:4230:30584864,30585249:metal:4230:30585274,30585419:metal:4230:30585572,30585621:metal:4230:30585705,30586494:metal:4230:30586548,30586657:metal:4230:30586708,30586865:metal:4230:30586994,30588279:metal:4230:30588324,30589061:metal:4230:30589252,30590114:metal:4230:30590194,30590942:metal:4230:30590990,30591512:metal:4230:30591583,30592286:metal:4230:30592405,30594261:metal:4230:30594410,30594262:metal:4230:30594580,30595171:metal:4230:30595501,30597461:metal:4230:30597616,30597462:metal:4230:30597811,30598812:metal:4230:30598904,30599262:metal:4230:30599431,30601505:metal:4230:30601540,30601759:metal:4230:30601778,30613718:metal:4230:30613877,30613719:metal:4230:30614028,30613720:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20014058983289676, 'nb_photo': 469831, 'list_port_cont': '30579197,30579399,30580135,30580509,30580773,30581052,30581521,30581572,30581967,30582393,30582740,30583015,30583472,30584107,30584486,30584861,30585000,30585095,30585265,30585376,30585586,30585719,30586552,30586720,30586991,30587102,30587314,30587397,30587781,30588322,30589248,30590206,30590986,30591582,30592421,30592885,30594417,30594592,30595510,30596040,30597623,30597808,30598186,30598909,30599425,30599716,30601541,30601776,30613870,30614026,30614468,30614749,30614979,30615290,30615407,30615686,30615726,30615746,30615808,30615877,30615932,30616010,30616039,30616112,30616150,30616184,30616237,30616274,30616311,30616389,30616525,30616743,30631392,30631430,30631464,30631562,30631616,30631700,30631754,30631844,30631926,30631967,30631996,30632051,30632076,30632124,30632234,30632326,30632360,30632423,30632529,30632666,30632841,30632903,30633542,30634202,30653038,30653269,30653359,30653427,30653742,30654091,30654303,30654497,30654548,30654749,30654796,30654836,30654977,30655010,30655054,30655094,30655128,3065515', 'assoc_port': '30578995:30579197,30579357:30579399,30579971:30580135,30580349:30580509,30580703:30580773,30580962:30581052,30581506:30581521,30581507:30581572,30581887:30581967,30582200:30582393,30582555:30582740,30582936:30583015,30583319:30583472,30583939:30584107,30584428:30584486,30584788:30584861,30584955:30585000,30585084:30585095,30585249:30585265,30585250:30585376,30585419:30585586,30585621:30585719,30586494:30586552,30586657:30586720,30586865:30586991,30587092:30587102,30587296:30587397,30587297:30587314,30587552:30587781,30588279:30588322,30589061:30589248,30590114:30590206,30590942:30590986,30591512:30591582,30592286:30592421,30592783:30592885,30594261:30594417,30594262:30594592,30595171:30595510,30595869:30596040,30597461:30597623,30597462:30597808,30598166:30598186,30598812:30598909,30599262:30599425,30599639:30599716,30601505:30601541,30601759:30601776,30613718:30613870,30613719:30614026,30613720:30614468,30613721:30614749,30613722:30614979,30613723:30615290,30613725:30615407,30613727:30615746,30613729:3061603', 'assoc_mat': '30578995:papier:4230:30579197,30579357:papier:4230:30579399,30579971:papier:4230:30580135,30580349:papier:4230:30580509,30580703:papier:4230:30580773,30580962:papier:4230:30581052,30581506:papier:4230:30581521,30581507:papier:4230:30581572,30581887:papier:4230:30581967,30582200:papier:4230:30582393,30582555:papier:4230:30582740,30582936:papier:4230:30583015,30583319:papier:4230:30583472,30583939:papier:4230:30584107,30584428:papier:4230:30584486,30584788:papier:4230:30584861,30584955:papier:4230:30585000,30585084:papier:4230:30585095,30585249:papier:4230:30585265,30585250:papier:4230:30585376,30585419:papier:4230:30585586,30585621:papier:4230:30585719,30586494:papier:4230:30586552,30586657:papier:4230:30586720,30586865:papier:4230:30586991,30587092:papier:4230:30587102,30587296:papier:4230:30587397,30587297:papier:4230:30587314,30587552:papier:4230:30587781,30588279:papier:4230:30588322,30589061:papier:4230:30589248,30590114:papier:4230:30590206,30590942:papier:4230:30590986,30591512:papier:4230:30591582,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004057395193952689, 'nb_photo': 2650, 'list_port_cont': '30579188,30579406,30580132,30580515,30580776,30581530,30581580,30581964,30582731,30584108,30584483,30585015,30585711,30586712,30586982,30587399,30587787,30588323,30590201,30591585,30592410,30592882,30594414,30595513,30596052,30597627,30598195,30598896,30599434,30599708,30601546,30601779,30613874,30615413,30615690,30615722,30615747,30615811,30615861,30615935,30616011,30616044,30616109,30616146,30616183,30616232,30616269,30616318,30616390,30616526,30616746,30631424,30631469,30631613,30631693,30631749,30631859,30631912,30631972,30632004,30632050,30632066,30632126,30632232,30632315,30632367,30632425,30632528,30632658,30632839,30632897,30633528,30634198,30653040,30653261,30654083,30654308,30654504,30654554,30654748,30654980,30655021,30655057,30655093,30655127,30655170,30655305,30655462,30655490,30655575,30655647,30664152,30664317,30664447,30664599,30664866,30664940,30665013,30665078,30665260,30665284,30665357,30665409,30665436,30665482,30665543,30665569,30665625,30665630,30665702,30665873,30666075,30666160,3067729', 'assoc_port': '30578995:30579188,30579357:30579406,30579971:30580132,30580349:30580515,30580703:30580776,30581506:30581530,30581507:30581580,30581887:30581964,30582555:30582731,30583939:30584108,30584428:30584483,30584955:30585015,30585621:30585711,30586657:30586712,30586865:30586982,30587296:30587399,30587552:30587787,30588279:30588323,30590114:30590201,30591512:30591585,30592286:30592410,30592783:30592882,30594261:30594414,30595171:30595513,30595869:30596052,30597461:30597627,30598166:30598195,30598812:30598896,30599262:30599434,30599639:30599708,30601505:30601546,30601759:30601779,30613718:30613874,30613725:30615413,30613727:30615747,30613729:30616044,30613731:30616269,30613733:30616232,30613735:30616183,30613737:30616318,30613739:30616109,30613741:30616011,30613743:30616146,30613745:30616390,30613747:30615811,30613750:30615690,30613753:30615935,30613756:30615861,30613759:30615722,30616413:30616526,30616601:30616746,30629636:30632658,30629641:30632897,30629643:30632528,30629648:30632315,30629652:30632126,30629659:3063205', 'assoc_mat': '30578995:pehd:4230:30579188,30579357:pehd:4230:30579406,30579971:pehd:4230:30580132,30580349:pehd:4230:30580515,30580703:pehd:4230:30580776,30581506:pehd:4230:30581530,30581507:pehd:4230:30581580,30581887:pehd:4230:30581964,30582555:pehd:4230:30582731,30583939:pehd:4230:30584108,30584428:pehd:4230:30584483,30584955:pehd:4230:30585015,30585621:pehd:4230:30585711,30586657:pehd:4230:30586712,30586865:pehd:4230:30586982,30587296:pehd:4230:30587399,30587552:pehd:4230:30587787,30588279:pehd:4230:30588323,30590114:pehd:4230:30590201,30591512:pehd:4230:30591585,30592286:pehd:4230:30592410,30592783:pehd:4230:30592882,30594261:pehd:4230:30594414,30595171:pehd:4230:30595513,30595869:pehd:4230:30596052,30597461:pehd:4230:30597627,30598166:pehd:4230:30598195,30598812:pehd:4230:30598896,30599262:pehd:4230:30599434,30599639:pehd:4230:30599708,30601505:pehd:4230:30601546,30601759:pehd:4230:30601779,30613718:pehd:4230:30613874,30613725:pehd:4230:30615413,30613727:pehd:4230:30615747,30613729:pehd:4230:30616044,30613731:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01783076766240922, 'nb_photo': 31558, 'list_port_cont': '30579195,30579392,30580138,30580516,30580775,30581053,30581527,30581584,30581974,30582382,30582732,30583013,30583470,30584095,30584485,30584865,30585008,30585105,30585262,30585380,30585588,30585721,30586545,30586716,30586993,30587103,30587308,30587389,30587779,30588314,30589254,30590196,30590992,30591579,30592415,30592890,30594407,30594586,30595516,30596053,30597630,30597817,30598185,30598907,30599426,30599711,30601536,30601781,30613876,30614033,30614470,30614758,30614980,30615291,30615410,30615691,30615730,30615737,30615805,30615873,30615931,30616007,30616047,30616115,30616147,30616176,30616233,30616276,30616322,30616391,30616524,30616744,30631394,30631428,30631475,30631563,30631602,30631698,30631756,30631855,30631917,30631973,30632003,30632045,30632068,30632127,30632241,30632311,30632368,30632424,30632521,30632668,30632850,30632907,30633531,30634196,30653047,30653266,30653360,30653439,30653736,30654084,30654312,30654511,30654543,30654753,30654791,30654834,30654979,30655012,30655056,30655091,30655130,3065516', 'assoc_port': '30578995:30579195,30579357:30579392,30579971:30580138,30580349:30580516,30580703:30580775,30580962:30581053,30581506:30581527,30581507:30581584,30581887:30581974,30582200:30582382,30582555:30582732,30582936:30583013,30583319:30583470,30583939:30584095,30584428:30584485,30584788:30584865,30584955:30585008,30585084:30585105,30585249:30585262,30585250:30585380,30585419:30585588,30585621:30585721,30586494:30586545,30586657:30586716,30586865:30586993,30587092:30587103,30587296:30587389,30587297:30587308,30587552:30587779,30588279:30588314,30589061:30589254,30590114:30590196,30590942:30590992,30591512:30591579,30592286:30592415,30592783:30592890,30594261:30594407,30594262:30594586,30595171:30595516,30595869:30596053,30597461:30597630,30597462:30597817,30598166:30598185,30598812:30598907,30599262:30599426,30599639:30599711,30601505:30601536,30601759:30601781,30613718:30613876,30613719:30614033,30613720:30614470,30613721:30614758,30613722:30614980,30613723:30615291,30613725:30615410,30613727:30615737,30613729:3061604', 'assoc_mat': '30578995:pet_clair:4230:30579195,30579357:pet_clair:4230:30579392,30579971:pet_clair:4230:30580138,30580349:pet_clair:4230:30580516,30580703:pet_clair:4230:30580775,30580962:pet_clair:4230:30581053,30581506:pet_clair:4230:30581527,30581507:pet_clair:4230:30581584,30581887:pet_clair:4230:30581974,30582200:pet_clair:4230:30582382,30582555:pet_clair:4230:30582732,30582936:pet_clair:4230:30583013,30583319:pet_clair:4230:30583470,30583939:pet_clair:4230:30584095,30584428:pet_clair:4230:30584485,30584788:pet_clair:4230:30584865,30584955:pet_clair:4230:30585008,30585084:pet_clair:4230:30585105,30585249:pet_clair:4230:30585262,30585250:pet_clair:4230:30585380,30585419:pet_clair:4230:30585588,30585621:pet_clair:4230:30585721,30586494:pet_clair:4230:30586545,30586657:pet_clair:4230:30586716,30586865:pet_clair:4230:30586993,30587092:pet_clair:4230:30587103,30587296:pet_clair:4230:30587389,30587297:pet_clair:4230:30587308,30587552:pet_clair:4230:30587779,30588279:pet_clair:4230:30588314,30589061:pet_clair:4230:30589254,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00258470061457594, 'nb_photo': 1533, 'list_port_cont': '30579198,30579407,30580128,30580778,30581055,30581520,30581586,30581970,30582394,30582739,30583022,30583466,30584096,30584482,30584867,30585003,30585106,30585384,30585579,30585720,30586554,30586709,30587320,30587396,30588317,30589253,30590982,30591576,30592416,30592892,30594411,30594589,30595517,30596044,30597620,30597806,30598901,30599428,30599710,30601547,30614034,30614459,30614756,30614981,30615288,30615408,30615693,30615745,30615814,30615871,30615940,30616009,30616114,30616148,30616185,30616228,30616272,30616326,30616385,30616522,30631393,30631429,30631468,30631553,30631606,30631702,30631746,30631858,30631895,30631968,30632007,30632052,30632088,30632128,30632240,30632364,30632421,30632667,30633539,30634203,30653041,30653268,30653358,30653438,30653733,30654090,30654309,30654510,30654556,30654976,30655020,30655055,30655085,30655134,30655171,30655309,30655463,30655491,30655583,30655655,30655819,30664154,30664442,30664588,30664860,30664937,30665007,30665077,30665230,30665262,30665283,30665411,30665445,3066547', 'assoc_port': '30578995:30579198,30579357:30579407,30579971:30580128,30580703:30580778,30580962:30581055,30581506:30581520,30581507:30581586,30581887:30581970,30582200:30582394,30582555:30582739,30582936:30583022,30583319:30583466,30583939:30584096,30584428:30584482,30584788:30584867,30584955:30585003,30585084:30585106,30585250:30585384,30585419:30585579,30585621:30585720,30586494:30586554,30586657:30586709,30587296:30587396,30587297:30587320,30588279:30588317,30589061:30589253,30590942:30590982,30591512:30591576,30592286:30592416,30592783:30592892,30594261:30594411,30594262:30594589,30595171:30595517,30595869:30596044,30597461:30597620,30597462:30597806,30598812:30598901,30599262:30599428,30599639:30599710,30601505:30601547,30613719:30614034,30613720:30614459,30613721:30614756,30613722:30614981,30613723:30615288,30613725:30615408,30613727:30615745,30613731:30616272,30613733:30616228,30613735:30616185,30613737:30616326,30613739:30616114,30613741:30616009,30613743:30616148,30613745:30616385,30613747:30615814,30613750:3061569', 'assoc_mat': '30578995:pet_fonce:4230:30579198,30579357:pet_fonce:4230:30579407,30579971:pet_fonce:4230:30580128,30580703:pet_fonce:4230:30580778,30580962:pet_fonce:4230:30581055,30581506:pet_fonce:4230:30581520,30581507:pet_fonce:4230:30581586,30581887:pet_fonce:4230:30581970,30582200:pet_fonce:4230:30582394,30582555:pet_fonce:4230:30582739,30582936:pet_fonce:4230:30583022,30583319:pet_fonce:4230:30583466,30583939:pet_fonce:4230:30584096,30584428:pet_fonce:4230:30584482,30584788:pet_fonce:4230:30584867,30584955:pet_fonce:4230:30585003,30585084:pet_fonce:4230:30585106,30585250:pet_fonce:4230:30585384,30585419:pet_fonce:4230:30585579,30585621:pet_fonce:4230:30585720,30586494:pet_fonce:4230:30586554,30586657:pet_fonce:4230:30586709,30587296:pet_fonce:4230:30587396,30587297:pet_fonce:4230:30587320,30588279:pet_fonce:4230:30588317,30589061:pet_fonce:4230:30589253,30590942:pet_fonce:4230:30590982,30591512:pet_fonce:4230:30591576,30592286:pet_fonce:4230:30592416,30592783:pet_fonce:4230:30592892,30594261:pet_fonce:4230:30594411,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(2935049,2936596,2938324,2940111,2943516,2944699,2945779,2946567,2947681,2948814,2950250,2951659,2952641,2953222,2954935,2956521,2958002,2959606,2961723,2962849,2963390,2965020,2966601,2968218,2969002,2969726,2970306,2970811,2971483,2972144)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842494, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579190,30579401,30580123,30580517,30580769,30581051,30581525,30581573,30581971,30582377,30582736,30583023,30583462,30584090,30584479,30584862,30585009,30585109,30585269,30585378,30585587,30585706,30586553,30586721,30586977,30587096,30587317,30587395,30587773,30588310,30589245,30590200,30590995,30591572,30592412,30592897,30594419,30594576,30595505,30596042,30597617,30597815,30598197,30598905,30599418,30599698,30601537,30601764,30613868,30614036,30614475,30614754,30614978,30615286,30615401,30615694,30615727,30615732,30615812,30615883,30615925,30616008,30616032,30616102,30616143,30616179,30616227,30616271,30616324,30616380,30616510,30616735,30631381,30631431,30631473,30631548,30631603,30631687,30631752,30631854,30631907,30631956,30632008,30632046,30632070,30632123,30632233,30632320,30632366,30632413,30632514,30632662,30632848,30632894,30633532,30634187,30653048,30653255,30653346,30653431,30653739,30654079,30654306,30654513,30654546,30654755,30654795,30654827,30654970,30655014,30655050,30655095,30655120,3065515 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842495, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579194,30579402,30580131,30580514,30580779,30581059,30581531,30581576,30581975,30582385,30582738,30583025,30583473,30584101,30584487,30584859,30585004,30585103,30585272,30585377,30585575,30585715,30586549,30586718,30586989,30587097,30587315,30587388,30587782,30588320,30589249,30590193,30590994,30591570,30592420,30592896,30594415,30594593,30595508,30596036,30597621,30597812,30598190,30598900,30599435,30599714,30601542,30601769,30613867,30614032,30614472,30614763,30614976,30615279,30615414,30615685,30615719,30615741,30615813,30615857,30615938,30616004,30616042,30616103,30616149,30616189,30616240,30616266,30616323,30616394,30616516,30616740,30631390,30631425,30631461,30631556,30631617,30631695,30631758,30631846,30631931,30631969,30632010,30632040,30632086,30632129,30632239,30632323,30632362,30632418,30632531,30632657,30632847,30632910,30633537,30634205,30653045,30653265,30653351,30653435,30653737,30654076,30654301,30654502,30654551,30654762,30654797,30654826,30654982,30655018,30655053,30655090,30655133,3065516 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842496, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579183,30580134,30580512,30580774,30581528,30581569,30581965,30582734,30583465,30584103,30584481,30584864,30585274,30585572,30585705,30586548,30586708,30586994,30588324,30589252,30590194,30590990,30591583,30592405,30594410,30594580,30595501,30597616,30597811,30598904,30599431,30601540,30601778,30613877,30614028,30614473,30614747,30614967,30615282,30615399,30615683,30615713,30615738,30615799,30615853,30615928,30616001,30616045,30616101,30616151,30616188,30616238,30616265,30616321,30616386,30616520,30616729,30631396,30631418,30631466,30631611,30631688,30631748,30631850,30631891,30631971,30632005,30632041,30632084,30632119,30632226,30632319,30632371,30632426,30632516,30632663,30632849,30632896,30633540,30634191,30653043,30653253,30653738,30654087,30654299,30654507,30654544,30654793,30654981,30655022,30655081,30655119,30655161,30655303,30655472,30655476,30655574,30655658,30655814,30664139,30664445,30664591,30664864,30665001,30665086,30665214,30665255,30665279,30665340,30665406,30665443,30665485,30665537,3066557 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842497, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579197,30579399,30580135,30580509,30580773,30581052,30581521,30581572,30581967,30582393,30582740,30583015,30583472,30584107,30584486,30584861,30585000,30585095,30585265,30585376,30585586,30585719,30586552,30586720,30586991,30587102,30587314,30587397,30587781,30588322,30589248,30590206,30590986,30591582,30592421,30592885,30594417,30594592,30595510,30596040,30597623,30597808,30598186,30598909,30599425,30599716,30601541,30601776,30613870,30614026,30614468,30614749,30614979,30615290,30615407,30615686,30615726,30615746,30615808,30615877,30615932,30616010,30616039,30616112,30616150,30616184,30616237,30616274,30616311,30616389,30616525,30616743,30631392,30631430,30631464,30631562,30631616,30631700,30631754,30631844,30631926,30631967,30631996,30632051,30632076,30632124,30632234,30632326,30632360,30632423,30632529,30632666,30632841,30632903,30633542,30634202,30653038,30653269,30653359,30653427,30653742,30654091,30654303,30654497,30654548,30654749,30654796,30654836,30654977,30655010,30655054,30655094,30655128,3065515 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842498, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579188,30579406,30580132,30580515,30580776,30581530,30581580,30581964,30582731,30584108,30584483,30585015,30585711,30586712,30586982,30587399,30587787,30588323,30590201,30591585,30592410,30592882,30594414,30595513,30596052,30597627,30598195,30598896,30599434,30599708,30601546,30601779,30613874,30615413,30615690,30615722,30615747,30615811,30615861,30615935,30616011,30616044,30616109,30616146,30616183,30616232,30616269,30616318,30616390,30616526,30616746,30631424,30631469,30631613,30631693,30631749,30631859,30631912,30631972,30632004,30632050,30632066,30632126,30632232,30632315,30632367,30632425,30632528,30632658,30632839,30632897,30633528,30634198,30653040,30653261,30654083,30654308,30654504,30654554,30654748,30654980,30655021,30655057,30655093,30655127,30655170,30655305,30655462,30655490,30655575,30655647,30664152,30664317,30664447,30664599,30664866,30664940,30665013,30665078,30665260,30665284,30665357,30665409,30665436,30665482,30665543,30665569,30665625,30665630,30665702,30665873,30666075,30666160,3067729 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842499, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579195,30579392,30580138,30580516,30580775,30581053,30581527,30581584,30581974,30582382,30582732,30583013,30583470,30584095,30584485,30584865,30585008,30585105,30585262,30585380,30585588,30585721,30586545,30586716,30586993,30587103,30587308,30587389,30587779,30588314,30589254,30590196,30590992,30591579,30592415,30592890,30594407,30594586,30595516,30596053,30597630,30597817,30598185,30598907,30599426,30599711,30601536,30601781,30613876,30614033,30614470,30614758,30614980,30615291,30615410,30615691,30615730,30615737,30615805,30615873,30615931,30616007,30616047,30616115,30616147,30616176,30616233,30616276,30616322,30616391,30616524,30616744,30631394,30631428,30631475,30631563,30631602,30631698,30631756,30631855,30631917,30631973,30632003,30632045,30632068,30632127,30632241,30632311,30632368,30632424,30632521,30632668,30632850,30632907,30633531,30634196,30653047,30653266,30653360,30653439,30653736,30654084,30654312,30654511,30654543,30654753,30654791,30654834,30654979,30655012,30655056,30655091,30655130,3065516 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30842500, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30579198,30579407,30580128,30580778,30581055,30581520,30581586,30581970,30582394,30582739,30583022,30583466,30584096,30584482,30584867,30585003,30585106,30585384,30585579,30585720,30586554,30586709,30587320,30587396,30588317,30589253,30590982,30591576,30592416,30592892,30594411,30594589,30595517,30596044,30597620,30597806,30598901,30599428,30599710,30601547,30614034,30614459,30614756,30614981,30615288,30615408,30615693,30615745,30615814,30615871,30615940,30616009,30616114,30616148,30616185,30616228,30616272,30616326,30616385,30616522,30631393,30631429,30631468,30631553,30631606,30631702,30631746,30631858,30631895,30631968,30632007,30632052,30632088,30632128,30632240,30632364,30632421,30632667,30633539,30634203,30653041,30653268,30653358,30653438,30653733,30654090,30654309,30654510,30654556,30654976,30655020,30655055,30655085,30655134,30655171,30655309,30655463,30655491,30655583,30655655,30655819,30664154,30664442,30664588,30664860,30664937,30665007,30665077,30665230,30665262,30665283,30665411,30665445,3066547 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30842494,30842495,30842496,30842497,30842498,30842499,30842500?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=202 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': ((2076,),), 'unwanted_material_monthly_percentage': ((0.7357855325825561,),), 'material_repartition': (('incineration', 2076),), 'material_dict': {'incineration': 2076}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 3, 1), 0.7864950647946027, 4), (datetime.date(2026, 3, 2), 0.8257438771771449, 1), (datetime.date(2026, 3, 3), 0.758378734304989, 3), (datetime.date(2026, 3, 4), 0.7225490027985252, 3), (datetime.date(2026, 3, 5), 0.7244705778980826, 3), (datetime.date(2026, 3, 6), 0.708624722702837, 3), (datetime.date(2026, 3, 7), 0.7068323647744009, 3), (datetime.date(2026, 3, 9), 0.7239734509043848, 2), (datetime.date(2026, 3, 10), 0.6866665473395044, 4), (datetime.date(2026, 3, 11), 0.6687873615448551, 3), (datetime.date(2026, 3, 12), 0.6732463635554408, 3), (datetime.date(2026, 3, 13), 0.6650193507592149, 3), (datetime.date(2026, 3, 14), 0.6847992035280632, 3), (datetime.date(2026, 3, 15), 0.7791417586833362, 4), (datetime.date(2026, 3, 16), 0.7959025824436757, 3), (datetime.date(2026, 3, 17), 0.7405051554375826, 4), (datetime.date(2026, 3, 18), 0.7077679130712992, 4), (datetime.date(2026, 3, 19), 0.7400802810381252, 3), (datetime.date(2026, 3, 20), 0.7329217200359018, 2), (datetime.date(2026, 3, 21), 0.7214996722592972, 3), (datetime.date(2026, 3, 22), 0.7566225522442153, 2), (datetime.date(2026, 3, 23), 0.8065724853914388, 3), (datetime.date(2026, 3, 24), 0.7777049957713661, 3), (datetime.date(2026, 3, 25), 0.7443980425900903, 2), (datetime.date(2026, 3, 26), 0.6914114490338167, 2), (datetime.date(2026, 3, 27), 0.6681201733258749, 3), (datetime.date(2026, 3, 28), 0.7030308573370955, 3), (datetime.date(2026, 3, 29), 0.7860153237350005, 3), (datetime.date(2026, 3, 30), 0.7715240673385374, 1), (datetime.date(2026, 3, 31), 0.7446140979913586, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 3, 1), 0.7864950647946027, 4), (datetime.date(2026, 3, 2), 0.8257438771771449, 1), (datetime.date(2026, 3, 3), 0.758378734304989, 3), (datetime.date(2026, 3, 4), 0.7225490027985252, 3), (datetime.date(2026, 3, 5), 0.7244705778980826, 3), (datetime.date(2026, 3, 6), 0.708624722702837, 3), (datetime.date(2026, 3, 7), 0.7068323647744009, 3), (datetime.date(2026, 3, 9), 0.7239734509043848, 2), (datetime.date(2026, 3, 10), 0.6866665473395044, 4), (datetime.date(2026, 3, 11), 0.6687873615448551, 3), (datetime.date(2026, 3, 12), 0.6732463635554408, 3), (datetime.date(2026, 3, 13), 0.6650193507592149, 3), (datetime.date(2026, 3, 14), 0.6847992035280632, 3), (datetime.date(2026, 3, 15), 0.7791417586833362, 4), (datetime.date(2026, 3, 16), 0.7959025824436757, 3), (datetime.date(2026, 3, 17), 0.7405051554375826, 4), (datetime.date(2026, 3, 18), 0.7077679130712992, 4), (datetime.date(2026, 3, 19), 0.7400802810381252, 3), (datetime.date(2026, 3, 20), 0.7329217200359018, 2), (datetime.date(2026, 3, 21), 0.7214996722592972, 3), (datetime.date(2026, 3, 22), 0.7566225522442153, 2), (datetime.date(2026, 3, 23), 0.8065724853914388, 3), (datetime.date(2026, 3, 24), 0.7777049957713661, 3), (datetime.date(2026, 3, 25), 0.7443980425900903, 2), (datetime.date(2026, 3, 26), 0.6914114490338167, 2), (datetime.date(2026, 3, 27), 0.6681201733258749, 3), (datetime.date(2026, 3, 28), 0.7030308573370955, 3), (datetime.date(2026, 3, 29), 0.7860153237350005, 3), (datetime.date(2026, 3, 30), 0.7715240673385374, 1), (datetime.date(2026, 3, 31), 0.7446140979913586, 4))}, 'quality_array': [['-7.849794138799676', '01032026'], ['-7.42622057234797', '02032026'], ['-7.5265670293387', '03032026'], ['-7.941376644355562', '04032026'], ['-7.990494718285453', '05032026'], ['-8.140525943483771', '06032026'], ['-7.986146054307795', '07032026'], ['-7.627731769329139', '09032026'], ['-7.911696042278952', '10032026'], ['-8.134007814099485', '11032026'], ['-8.063975474421865', '12032026'], ['-8.269124685657896', '13032026'], ['-8.084367099413617', '14032026'], ['-7.890427066061814', '15032026'], ['-7.26582130237497', '16032026'], ['-7.573619492609426', '17032026'], ['-7.817158636813311', '18032026'], ['-7.832424409682767', '19032026'], ['-7.891611310899813', '20032026'], ['-7.942985594987121', '21032026'], ['-7.873437133479427', '22032026'], ['-7.186881827462885', '23032026'], ['-7.371234425625504', '24032026'], ['-7.570420711242004', '25032026'], ['-7.873741987506771', '26032026'], ['-8.069125444029169', '27032026'], ['-8.011971790379869', '28032026'], ['-7.76132891127454', '29032026'], ['-7.3553649939417145', '30032026'], ['-7.261230003277931', '31032026']], 'number_of_batch': ((673,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01656923096325058, 'nb_photo': 23698, 'list_port_cont': '30579190,30579401,30580123,30580517,30580769,30581051,30581525,30581573,30581971,30582377,30582736,30583023,30583462,30584090,30584479,30584862,30585009,30585109,30585269,30585378,30585587,30585706,30586553,30586721,30586977,30587096,30587317,30587395,30587773,30588310,30589245,30590200,30590995,30591572,30592412,30592897,30594419,30594576,30595505,30596042,30597617,30597815,30598197,30598905,30599418,30599698,30601537,30601764,30613868,30614036,30614475,30614754,30614978,30615286,30615401,30615694,30615727,30615732,30615812,30615883,30615925,30616008,30616032,30616102,30616143,30616179,30616227,30616271,30616324,30616380,30616510,30616735,30631381,30631431,30631473,30631548,30631603,30631687,30631752,30631854,30631907,30631956,30632008,30632046,30632070,30632123,30632233,30632320,30632366,30632413,30632514,30632662,30632848,30632894,30633532,30634187,30653048,30653255,30653346,30653431,30653739,30654079,30654306,30654513,30654546,30654755,30654795,30654827,30654970,30655014,30655050,30655095,30655120,3065515', 'assoc_port': '30578995:30579190,30579357:30579401,30579971:30580123,30580349:30580517,30580703:30580769,30580962:30581051,30581506:30581525,30581507:30581573,30581887:30581971,30582200:30582377,30582555:30582736,30582936:30583023,30583319:30583462,30583939:30584090,30584428:30584479,30584788:30584862,30584955:30585009,30585084:30585109,30585249:30585269,30585250:30585378,30585419:30585587,30585621:30585706,30586494:30586553,30586657:30586721,30586865:30586977,30587092:30587096,30587296:30587395,30587297:30587317,30587552:30587773,30588279:30588310,30589061:30589245,30590114:30590200,30590942:30590995,30591512:30591572,30592286:30592412,30592783:30592897,30594261:30594419,30594262:30594576,30595171:30595505,30595869:30596042,30597461:30597617,30597462:30597815,30598166:30598197,30598812:30598905,30599262:30599418,30599639:30599698,30601505:30601537,30601759:30601764,30613718:30613868,30613719:30614036,30613720:30614475,30613721:30614754,30613722:30614978,30613723:30615286,30613725:30615401,30613727:30615732,30613729:3061603', 'assoc_mat': '30578995:autre:4230:30579190,30579357:autre:4230:30579401,30579971:autre:4230:30580123,30580349:autre:4230:30580517,30580703:autre:4230:30580769,30580962:autre:4230:30581051,30581506:autre:4230:30581525,30581507:autre:4230:30581573,30581887:autre:4230:30581971,30582200:autre:4230:30582377,30582555:autre:4230:30582736,30582936:autre:4230:30583023,30583319:autre:4230:30583462,30583939:autre:4230:30584090,30584428:autre:4230:30584479,30584788:autre:4230:30584862,30584955:autre:4230:30585009,30585084:autre:4230:30585109,30585249:autre:4230:30585269,30585250:autre:4230:30585378,30585419:autre:4230:30585587,30585621:autre:4230:30585706,30586494:autre:4230:30586553,30586657:autre:4230:30586721,30586865:autre:4230:30586977,30587092:autre:4230:30587096,30587296:autre:4230:30587395,30587297:autre:4230:30587317,30587552:autre:4230:30587773,30588279:autre:4230:30588310,30589061:autre:4230:30589245,30590114:autre:4230:30590200,30590942:autre:4230:30590995,30591512:autre:4230:30591572,30592286:autre:4230:30592412,30592783:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04268492423802562, 'nb_photo': 93968, 'list_port_cont': '30579194,30579402,30580131,30580514,30580779,30581059,30581531,30581576,30581975,30582385,30582738,30583025,30583473,30584101,30584487,30584859,30585004,30585103,30585272,30585377,30585575,30585715,30586549,30586718,30586989,30587097,30587315,30587388,30587782,30588320,30589249,30590193,30590994,30591570,30592420,30592896,30594415,30594593,30595508,30596036,30597621,30597812,30598190,30598900,30599435,30599714,30601542,30601769,30613867,30614032,30614472,30614763,30614976,30615279,30615414,30615685,30615719,30615741,30615813,30615857,30615938,30616004,30616042,30616103,30616149,30616189,30616240,30616266,30616323,30616394,30616516,30616740,30631390,30631425,30631461,30631556,30631617,30631695,30631758,30631846,30631931,30631969,30632010,30632040,30632086,30632129,30632239,30632323,30632362,30632418,30632531,30632657,30632847,30632910,30633537,30634205,30653045,30653265,30653351,30653435,30653737,30654076,30654301,30654502,30654551,30654762,30654797,30654826,30654982,30655018,30655053,30655090,30655133,3065516', 'assoc_port': '30578995:30579194,30579357:30579402,30579971:30580131,30580349:30580514,30580703:30580779,30580962:30581059,30581506:30581531,30581507:30581576,30581887:30581975,30582200:30582385,30582555:30582738,30582936:30583025,30583319:30583473,30583939:30584101,30584428:30584487,30584788:30584859,30584955:30585004,30585084:30585103,30585249:30585272,30585250:30585377,30585419:30585575,30585621:30585715,30586494:30586549,30586657:30586718,30586865:30586989,30587092:30587097,30587296:30587388,30587297:30587315,30587552:30587782,30588279:30588320,30589061:30589249,30590114:30590193,30590942:30590994,30591512:30591570,30592286:30592420,30592783:30592896,30594261:30594415,30594262:30594593,30595171:30595508,30595869:30596036,30597461:30597621,30597462:30597812,30598166:30598190,30598812:30598900,30599262:30599435,30599639:30599714,30601505:30601542,30601759:30601769,30613718:30613867,30613719:30614032,30613720:30614472,30613721:30614763,30613722:30614976,30613723:30615279,30613725:30615414,30613727:30615741,30613729:3061604', 'assoc_mat': '30578995:carton:4230:30579194,30579357:carton:4230:30579402,30579971:carton:4230:30580131,30580349:carton:4230:30580514,30580703:carton:4230:30580779,30580962:carton:4230:30581059,30581506:carton:4230:30581531,30581507:carton:4230:30581576,30581887:carton:4230:30581975,30582200:carton:4230:30582385,30582555:carton:4230:30582738,30582936:carton:4230:30583025,30583319:carton:4230:30583473,30583939:carton:4230:30584101,30584428:carton:4230:30584487,30584788:carton:4230:30584859,30584955:carton:4230:30585004,30585084:carton:4230:30585103,30585249:carton:4230:30585272,30585250:carton:4230:30585377,30585419:carton:4230:30585575,30585621:carton:4230:30585715,30586494:carton:4230:30586549,30586657:carton:4230:30586718,30586865:carton:4230:30586989,30587092:carton:4230:30587097,30587296:carton:4230:30587388,30587297:carton:4230:30587315,30587552:carton:4230:30587782,30588279:carton:4230:30588320,30589061:carton:4230:30589249,30590114:carton:4230:30590193,30590942:carton:4230:30590994,30591512:carton:4230:30591570,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011946985956659505, 'nb_photo': 1950, 'list_port_cont': '30579183,30580134,30580512,30580774,30581528,30581569,30581965,30582734,30583465,30584103,30584481,30584864,30585274,30585572,30585705,30586548,30586708,30586994,30588324,30589252,30590194,30590990,30591583,30592405,30594410,30594580,30595501,30597616,30597811,30598904,30599431,30601540,30601778,30613877,30614028,30614473,30614747,30614967,30615282,30615399,30615683,30615713,30615738,30615799,30615853,30615928,30616001,30616045,30616101,30616151,30616188,30616238,30616265,30616321,30616386,30616520,30616729,30631396,30631418,30631466,30631611,30631688,30631748,30631850,30631891,30631971,30632005,30632041,30632084,30632119,30632226,30632319,30632371,30632426,30632516,30632663,30632849,30632896,30633540,30634191,30653043,30653253,30653738,30654087,30654299,30654507,30654544,30654793,30654981,30655022,30655081,30655119,30655161,30655303,30655472,30655476,30655574,30655658,30655814,30664139,30664445,30664591,30664864,30665001,30665086,30665214,30665255,30665279,30665340,30665406,30665443,30665485,30665537,3066557', 'assoc_port': '30578995:30579183,30579971:30580134,30580349:30580512,30580703:30580774,30581506:30581528,30581507:30581569,30581887:30581965,30582555:30582734,30583319:30583465,30583939:30584103,30584428:30584481,30584788:30584864,30585249:30585274,30585419:30585572,30585621:30585705,30586494:30586548,30586657:30586708,30586865:30586994,30588279:30588324,30589061:30589252,30590114:30590194,30590942:30590990,30591512:30591583,30592286:30592405,30594261:30594410,30594262:30594580,30595171:30595501,30597461:30597616,30597462:30597811,30598812:30598904,30599262:30599431,30601505:30601540,30601759:30601778,30613718:30613877,30613719:30614028,30613720:30614473,30613721:30614747,30613722:30614967,30613723:30615282,30613725:30615399,30613727:30615738,30613729:30616045,30613731:30616265,30613733:30616238,30613735:30616188,30613737:30616321,30613739:30616101,30613741:30616001,30613743:30616151,30613745:30616386,30613747:30615799,30613750:30615683,30613753:30615928,30613756:30615853,30613759:30615713,30616413:30616520,30616601:3061672', 'assoc_mat': '30578995:metal:4230:30579183,30579971:metal:4230:30580134,30580349:metal:4230:30580512,30580703:metal:4230:30580774,30581506:metal:4230:30581528,30581507:metal:4230:30581569,30581887:metal:4230:30581965,30582555:metal:4230:30582734,30583319:metal:4230:30583465,30583939:metal:4230:30584103,30584428:metal:4230:30584481,30584788:metal:4230:30584864,30585249:metal:4230:30585274,30585419:metal:4230:30585572,30585621:metal:4230:30585705,30586494:metal:4230:30586548,30586657:metal:4230:30586708,30586865:metal:4230:30586994,30588279:metal:4230:30588324,30589061:metal:4230:30589252,30590114:metal:4230:30590194,30590942:metal:4230:30590990,30591512:metal:4230:30591583,30592286:metal:4230:30592405,30594261:metal:4230:30594410,30594262:metal:4230:30594580,30595171:metal:4230:30595501,30597461:metal:4230:30597616,30597462:metal:4230:30597811,30598812:metal:4230:30598904,30599262:metal:4230:30599431,30601505:metal:4230:30601540,30601759:metal:4230:30601778,30613718:metal:4230:30613877,30613719:metal:4230:30614028,30613720:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20014058983289676, 'nb_photo': 469831, 'list_port_cont': '30579197,30579399,30580135,30580509,30580773,30581052,30581521,30581572,30581967,30582393,30582740,30583015,30583472,30584107,30584486,30584861,30585000,30585095,30585265,30585376,30585586,30585719,30586552,30586720,30586991,30587102,30587314,30587397,30587781,30588322,30589248,30590206,30590986,30591582,30592421,30592885,30594417,30594592,30595510,30596040,30597623,30597808,30598186,30598909,30599425,30599716,30601541,30601776,30613870,30614026,30614468,30614749,30614979,30615290,30615407,30615686,30615726,30615746,30615808,30615877,30615932,30616010,30616039,30616112,30616150,30616184,30616237,30616274,30616311,30616389,30616525,30616743,30631392,30631430,30631464,30631562,30631616,30631700,30631754,30631844,30631926,30631967,30631996,30632051,30632076,30632124,30632234,30632326,30632360,30632423,30632529,30632666,30632841,30632903,30633542,30634202,30653038,30653269,30653359,30653427,30653742,30654091,30654303,30654497,30654548,30654749,30654796,30654836,30654977,30655010,30655054,30655094,30655128,3065515', 'assoc_port': '30578995:30579197,30579357:30579399,30579971:30580135,30580349:30580509,30580703:30580773,30580962:30581052,30581506:30581521,30581507:30581572,30581887:30581967,30582200:30582393,30582555:30582740,30582936:30583015,30583319:30583472,30583939:30584107,30584428:30584486,30584788:30584861,30584955:30585000,30585084:30585095,30585249:30585265,30585250:30585376,30585419:30585586,30585621:30585719,30586494:30586552,30586657:30586720,30586865:30586991,30587092:30587102,30587296:30587397,30587297:30587314,30587552:30587781,30588279:30588322,30589061:30589248,30590114:30590206,30590942:30590986,30591512:30591582,30592286:30592421,30592783:30592885,30594261:30594417,30594262:30594592,30595171:30595510,30595869:30596040,30597461:30597623,30597462:30597808,30598166:30598186,30598812:30598909,30599262:30599425,30599639:30599716,30601505:30601541,30601759:30601776,30613718:30613870,30613719:30614026,30613720:30614468,30613721:30614749,30613722:30614979,30613723:30615290,30613725:30615407,30613727:30615746,30613729:3061603', 'assoc_mat': '30578995:papier:4230:30579197,30579357:papier:4230:30579399,30579971:papier:4230:30580135,30580349:papier:4230:30580509,30580703:papier:4230:30580773,30580962:papier:4230:30581052,30581506:papier:4230:30581521,30581507:papier:4230:30581572,30581887:papier:4230:30581967,30582200:papier:4230:30582393,30582555:papier:4230:30582740,30582936:papier:4230:30583015,30583319:papier:4230:30583472,30583939:papier:4230:30584107,30584428:papier:4230:30584486,30584788:papier:4230:30584861,30584955:papier:4230:30585000,30585084:papier:4230:30585095,30585249:papier:4230:30585265,30585250:papier:4230:30585376,30585419:papier:4230:30585586,30585621:papier:4230:30585719,30586494:papier:4230:30586552,30586657:papier:4230:30586720,30586865:papier:4230:30586991,30587092:papier:4230:30587102,30587296:papier:4230:30587397,30587297:papier:4230:30587314,30587552:papier:4230:30587781,30588279:papier:4230:30588322,30589061:papier:4230:30589248,30590114:papier:4230:30590206,30590942:papier:4230:30590986,30591512:papier:4230:30591582,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004057395193952689, 'nb_photo': 2650, 'list_port_cont': '30579188,30579406,30580132,30580515,30580776,30581530,30581580,30581964,30582731,30584108,30584483,30585015,30585711,30586712,30586982,30587399,30587787,30588323,30590201,30591585,30592410,30592882,30594414,30595513,30596052,30597627,30598195,30598896,30599434,30599708,30601546,30601779,30613874,30615413,30615690,30615722,30615747,30615811,30615861,30615935,30616011,30616044,30616109,30616146,30616183,30616232,30616269,30616318,30616390,30616526,30616746,30631424,30631469,30631613,30631693,30631749,30631859,30631912,30631972,30632004,30632050,30632066,30632126,30632232,30632315,30632367,30632425,30632528,30632658,30632839,30632897,30633528,30634198,30653040,30653261,30654083,30654308,30654504,30654554,30654748,30654980,30655021,30655057,30655093,30655127,30655170,30655305,30655462,30655490,30655575,30655647,30664152,30664317,30664447,30664599,30664866,30664940,30665013,30665078,30665260,30665284,30665357,30665409,30665436,30665482,30665543,30665569,30665625,30665630,30665702,30665873,30666075,30666160,3067729', 'assoc_port': '30578995:30579188,30579357:30579406,30579971:30580132,30580349:30580515,30580703:30580776,30581506:30581530,30581507:30581580,30581887:30581964,30582555:30582731,30583939:30584108,30584428:30584483,30584955:30585015,30585621:30585711,30586657:30586712,30586865:30586982,30587296:30587399,30587552:30587787,30588279:30588323,30590114:30590201,30591512:30591585,30592286:30592410,30592783:30592882,30594261:30594414,30595171:30595513,30595869:30596052,30597461:30597627,30598166:30598195,30598812:30598896,30599262:30599434,30599639:30599708,30601505:30601546,30601759:30601779,30613718:30613874,30613725:30615413,30613727:30615747,30613729:30616044,30613731:30616269,30613733:30616232,30613735:30616183,30613737:30616318,30613739:30616109,30613741:30616011,30613743:30616146,30613745:30616390,30613747:30615811,30613750:30615690,30613753:30615935,30613756:30615861,30613759:30615722,30616413:30616526,30616601:30616746,30629636:30632658,30629641:30632897,30629643:30632528,30629648:30632315,30629652:30632126,30629659:3063205', 'assoc_mat': '30578995:pehd:4230:30579188,30579357:pehd:4230:30579406,30579971:pehd:4230:30580132,30580349:pehd:4230:30580515,30580703:pehd:4230:30580776,30581506:pehd:4230:30581530,30581507:pehd:4230:30581580,30581887:pehd:4230:30581964,30582555:pehd:4230:30582731,30583939:pehd:4230:30584108,30584428:pehd:4230:30584483,30584955:pehd:4230:30585015,30585621:pehd:4230:30585711,30586657:pehd:4230:30586712,30586865:pehd:4230:30586982,30587296:pehd:4230:30587399,30587552:pehd:4230:30587787,30588279:pehd:4230:30588323,30590114:pehd:4230:30590201,30591512:pehd:4230:30591585,30592286:pehd:4230:30592410,30592783:pehd:4230:30592882,30594261:pehd:4230:30594414,30595171:pehd:4230:30595513,30595869:pehd:4230:30596052,30597461:pehd:4230:30597627,30598166:pehd:4230:30598195,30598812:pehd:4230:30598896,30599262:pehd:4230:30599434,30599639:pehd:4230:30599708,30601505:pehd:4230:30601546,30601759:pehd:4230:30601779,30613718:pehd:4230:30613874,30613725:pehd:4230:30615413,30613727:pehd:4230:30615747,30613729:pehd:4230:30616044,30613731:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01783076766240922, 'nb_photo': 31558, 'list_port_cont': '30579195,30579392,30580138,30580516,30580775,30581053,30581527,30581584,30581974,30582382,30582732,30583013,30583470,30584095,30584485,30584865,30585008,30585105,30585262,30585380,30585588,30585721,30586545,30586716,30586993,30587103,30587308,30587389,30587779,30588314,30589254,30590196,30590992,30591579,30592415,30592890,30594407,30594586,30595516,30596053,30597630,30597817,30598185,30598907,30599426,30599711,30601536,30601781,30613876,30614033,30614470,30614758,30614980,30615291,30615410,30615691,30615730,30615737,30615805,30615873,30615931,30616007,30616047,30616115,30616147,30616176,30616233,30616276,30616322,30616391,30616524,30616744,30631394,30631428,30631475,30631563,30631602,30631698,30631756,30631855,30631917,30631973,30632003,30632045,30632068,30632127,30632241,30632311,30632368,30632424,30632521,30632668,30632850,30632907,30633531,30634196,30653047,30653266,30653360,30653439,30653736,30654084,30654312,30654511,30654543,30654753,30654791,30654834,30654979,30655012,30655056,30655091,30655130,3065516', 'assoc_port': '30578995:30579195,30579357:30579392,30579971:30580138,30580349:30580516,30580703:30580775,30580962:30581053,30581506:30581527,30581507:30581584,30581887:30581974,30582200:30582382,30582555:30582732,30582936:30583013,30583319:30583470,30583939:30584095,30584428:30584485,30584788:30584865,30584955:30585008,30585084:30585105,30585249:30585262,30585250:30585380,30585419:30585588,30585621:30585721,30586494:30586545,30586657:30586716,30586865:30586993,30587092:30587103,30587296:30587389,30587297:30587308,30587552:30587779,30588279:30588314,30589061:30589254,30590114:30590196,30590942:30590992,30591512:30591579,30592286:30592415,30592783:30592890,30594261:30594407,30594262:30594586,30595171:30595516,30595869:30596053,30597461:30597630,30597462:30597817,30598166:30598185,30598812:30598907,30599262:30599426,30599639:30599711,30601505:30601536,30601759:30601781,30613718:30613876,30613719:30614033,30613720:30614470,30613721:30614758,30613722:30614980,30613723:30615291,30613725:30615410,30613727:30615737,30613729:3061604', 'assoc_mat': '30578995:pet_clair:4230:30579195,30579357:pet_clair:4230:30579392,30579971:pet_clair:4230:30580138,30580349:pet_clair:4230:30580516,30580703:pet_clair:4230:30580775,30580962:pet_clair:4230:30581053,30581506:pet_clair:4230:30581527,30581507:pet_clair:4230:30581584,30581887:pet_clair:4230:30581974,30582200:pet_clair:4230:30582382,30582555:pet_clair:4230:30582732,30582936:pet_clair:4230:30583013,30583319:pet_clair:4230:30583470,30583939:pet_clair:4230:30584095,30584428:pet_clair:4230:30584485,30584788:pet_clair:4230:30584865,30584955:pet_clair:4230:30585008,30585084:pet_clair:4230:30585105,30585249:pet_clair:4230:30585262,30585250:pet_clair:4230:30585380,30585419:pet_clair:4230:30585588,30585621:pet_clair:4230:30585721,30586494:pet_clair:4230:30586545,30586657:pet_clair:4230:30586716,30586865:pet_clair:4230:30586993,30587092:pet_clair:4230:30587103,30587296:pet_clair:4230:30587389,30587297:pet_clair:4230:30587308,30587552:pet_clair:4230:30587779,30588279:pet_clair:4230:30588314,30589061:pet_clair:4230:30589254,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00258470061457594, 'nb_photo': 1533, 'list_port_cont': '30579198,30579407,30580128,30580778,30581055,30581520,30581586,30581970,30582394,30582739,30583022,30583466,30584096,30584482,30584867,30585003,30585106,30585384,30585579,30585720,30586554,30586709,30587320,30587396,30588317,30589253,30590982,30591576,30592416,30592892,30594411,30594589,30595517,30596044,30597620,30597806,30598901,30599428,30599710,30601547,30614034,30614459,30614756,30614981,30615288,30615408,30615693,30615745,30615814,30615871,30615940,30616009,30616114,30616148,30616185,30616228,30616272,30616326,30616385,30616522,30631393,30631429,30631468,30631553,30631606,30631702,30631746,30631858,30631895,30631968,30632007,30632052,30632088,30632128,30632240,30632364,30632421,30632667,30633539,30634203,30653041,30653268,30653358,30653438,30653733,30654090,30654309,30654510,30654556,30654976,30655020,30655055,30655085,30655134,30655171,30655309,30655463,30655491,30655583,30655655,30655819,30664154,30664442,30664588,30664860,30664937,30665007,30665077,30665230,30665262,30665283,30665411,30665445,3066547', 'assoc_port': '30578995:30579198,30579357:30579407,30579971:30580128,30580703:30580778,30580962:30581055,30581506:30581520,30581507:30581586,30581887:30581970,30582200:30582394,30582555:30582739,30582936:30583022,30583319:30583466,30583939:30584096,30584428:30584482,30584788:30584867,30584955:30585003,30585084:30585106,30585250:30585384,30585419:30585579,30585621:30585720,30586494:30586554,30586657:30586709,30587296:30587396,30587297:30587320,30588279:30588317,30589061:30589253,30590942:30590982,30591512:30591576,30592286:30592416,30592783:30592892,30594261:30594411,30594262:30594589,30595171:30595517,30595869:30596044,30597461:30597620,30597462:30597806,30598812:30598901,30599262:30599428,30599639:30599710,30601505:30601547,30613719:30614034,30613720:30614459,30613721:30614756,30613722:30614981,30613723:30615288,30613725:30615408,30613727:30615745,30613731:30616272,30613733:30616228,30613735:30616185,30613737:30616326,30613739:30616114,30613741:30616009,30613743:30616148,30613745:30616385,30613747:30615814,30613750:3061569', 'assoc_mat': '30578995:pet_fonce:4230:30579198,30579357:pet_fonce:4230:30579407,30579971:pet_fonce:4230:30580128,30580703:pet_fonce:4230:30580778,30580962:pet_fonce:4230:30581055,30581506:pet_fonce:4230:30581520,30581507:pet_fonce:4230:30581586,30581887:pet_fonce:4230:30581970,30582200:pet_fonce:4230:30582394,30582555:pet_fonce:4230:30582739,30582936:pet_fonce:4230:30583022,30583319:pet_fonce:4230:30583466,30583939:pet_fonce:4230:30584096,30584428:pet_fonce:4230:30584482,30584788:pet_fonce:4230:30584867,30584955:pet_fonce:4230:30585003,30585084:pet_fonce:4230:30585106,30585250:pet_fonce:4230:30585384,30585419:pet_fonce:4230:30585579,30585621:pet_fonce:4230:30585720,30586494:pet_fonce:4230:30586554,30586657:pet_fonce:4230:30586709,30587296:pet_fonce:4230:30587396,30587297:pet_fonce:4230:30587320,30588279:pet_fonce:4230:30588317,30589061:pet_fonce:4230:30589253,30590942:pet_fonce:4230:30590982,30591512:pet_fonce:4230:30591576,30592286:pet_fonce:4230:30592416,30592783:pet_fonce:4230:30592892,30594261:pet_fonce:4230:30594411,3'}), 'main_stat': {'nb_photos': 2076}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30842494,30842495,30842496,30842497,30842498,30842499,30842500?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-03', 0.7357855325825561),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 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=4849 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= 4849 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=4849 # 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': ((2076,),), 'unwanted_material_monthly_percentage': ((0.7357855325825561,),), 'material_repartition': (('incineration', 2076),), 'material_dict': {'incineration': 2076}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 3, 1), 0.7864950647946027, 4), (datetime.date(2026, 3, 2), 0.8257438771771449, 1), (datetime.date(2026, 3, 3), 0.758378734304989, 3), (datetime.date(2026, 3, 4), 0.7225490027985252, 3), (datetime.date(2026, 3, 5), 0.7244705778980826, 3), (datetime.date(2026, 3, 6), 0.708624722702837, 3), (datetime.date(2026, 3, 7), 0.7068323647744009, 3), (datetime.date(2026, 3, 9), 0.7239734509043848, 2), (datetime.date(2026, 3, 10), 0.6866665473395044, 4), (datetime.date(2026, 3, 11), 0.6687873615448551, 3), (datetime.date(2026, 3, 12), 0.6732463635554408, 3), (datetime.date(2026, 3, 13), 0.6650193507592149, 3), (datetime.date(2026, 3, 14), 0.6847992035280632, 3), (datetime.date(2026, 3, 15), 0.7791417586833362, 4), (datetime.date(2026, 3, 16), 0.7959025824436757, 3), (datetime.date(2026, 3, 17), 0.7405051554375826, 4), (datetime.date(2026, 3, 18), 0.7077679130712992, 4), (datetime.date(2026, 3, 19), 0.7400802810381252, 3), (datetime.date(2026, 3, 20), 0.7329217200359018, 2), (datetime.date(2026, 3, 21), 0.7214996722592972, 3), (datetime.date(2026, 3, 22), 0.7566225522442153, 2), (datetime.date(2026, 3, 23), 0.8065724853914388, 3), (datetime.date(2026, 3, 24), 0.7777049957713661, 3), (datetime.date(2026, 3, 25), 0.7443980425900903, 2), (datetime.date(2026, 3, 26), 0.6914114490338167, 2), (datetime.date(2026, 3, 27), 0.6681201733258749, 3), (datetime.date(2026, 3, 28), 0.7030308573370955, 3), (datetime.date(2026, 3, 29), 0.7860153237350005, 3), (datetime.date(2026, 3, 30), 0.7715240673385374, 1), (datetime.date(2026, 3, 31), 0.7446140979913586, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 3, 1), 0.7864950647946027, 4), (datetime.date(2026, 3, 2), 0.8257438771771449, 1), (datetime.date(2026, 3, 3), 0.758378734304989, 3), (datetime.date(2026, 3, 4), 0.7225490027985252, 3), (datetime.date(2026, 3, 5), 0.7244705778980826, 3), (datetime.date(2026, 3, 6), 0.708624722702837, 3), (datetime.date(2026, 3, 7), 0.7068323647744009, 3), (datetime.date(2026, 3, 9), 0.7239734509043848, 2), (datetime.date(2026, 3, 10), 0.6866665473395044, 4), (datetime.date(2026, 3, 11), 0.6687873615448551, 3), (datetime.date(2026, 3, 12), 0.6732463635554408, 3), (datetime.date(2026, 3, 13), 0.6650193507592149, 3), (datetime.date(2026, 3, 14), 0.6847992035280632, 3), (datetime.date(2026, 3, 15), 0.7791417586833362, 4), (datetime.date(2026, 3, 16), 0.7959025824436757, 3), (datetime.date(2026, 3, 17), 0.7405051554375826, 4), (datetime.date(2026, 3, 18), 0.7077679130712992, 4), (datetime.date(2026, 3, 19), 0.7400802810381252, 3), (datetime.date(2026, 3, 20), 0.7329217200359018, 2), (datetime.date(2026, 3, 21), 0.7214996722592972, 3), (datetime.date(2026, 3, 22), 0.7566225522442153, 2), (datetime.date(2026, 3, 23), 0.8065724853914388, 3), (datetime.date(2026, 3, 24), 0.7777049957713661, 3), (datetime.date(2026, 3, 25), 0.7443980425900903, 2), (datetime.date(2026, 3, 26), 0.6914114490338167, 2), (datetime.date(2026, 3, 27), 0.6681201733258749, 3), (datetime.date(2026, 3, 28), 0.7030308573370955, 3), (datetime.date(2026, 3, 29), 0.7860153237350005, 3), (datetime.date(2026, 3, 30), 0.7715240673385374, 1), (datetime.date(2026, 3, 31), 0.7446140979913586, 4))}, 'quality_array': [['-7.849794138799676', '01032026'], ['-7.42622057234797', '02032026'], ['-7.5265670293387', '03032026'], ['-7.941376644355562', '04032026'], ['-7.990494718285453', '05032026'], ['-8.140525943483771', '06032026'], ['-7.986146054307795', '07032026'], ['-7.627731769329139', '09032026'], ['-7.911696042278952', '10032026'], ['-8.134007814099485', '11032026'], ['-8.063975474421865', '12032026'], ['-8.269124685657896', '13032026'], ['-8.084367099413617', '14032026'], ['-7.890427066061814', '15032026'], ['-7.26582130237497', '16032026'], ['-7.573619492609426', '17032026'], ['-7.817158636813311', '18032026'], ['-7.832424409682767', '19032026'], ['-7.891611310899813', '20032026'], ['-7.942985594987121', '21032026'], ['-7.873437133479427', '22032026'], ['-7.186881827462885', '23032026'], ['-7.371234425625504', '24032026'], ['-7.570420711242004', '25032026'], ['-7.873741987506771', '26032026'], ['-8.069125444029169', '27032026'], ['-8.011971790379869', '28032026'], ['-7.76132891127454', '29032026'], ['-7.3553649939417145', '30032026'], ['-7.261230003277931', '31032026']], 'number_of_batch': ((673,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01656923096325058, 'nb_photo': 23698, 'list_port_cont': '30579190,30579401,30580123,30580517,30580769,30581051,30581525,30581573,30581971,30582377,30582736,30583023,30583462,30584090,30584479,30584862,30585009,30585109,30585269,30585378,30585587,30585706,30586553,30586721,30586977,30587096,30587317,30587395,30587773,30588310,30589245,30590200,30590995,30591572,30592412,30592897,30594419,30594576,30595505,30596042,30597617,30597815,30598197,30598905,30599418,30599698,30601537,30601764,30613868,30614036,30614475,30614754,30614978,30615286,30615401,30615694,30615727,30615732,30615812,30615883,30615925,30616008,30616032,30616102,30616143,30616179,30616227,30616271,30616324,30616380,30616510,30616735,30631381,30631431,30631473,30631548,30631603,30631687,30631752,30631854,30631907,30631956,30632008,30632046,30632070,30632123,30632233,30632320,30632366,30632413,30632514,30632662,30632848,30632894,30633532,30634187,30653048,30653255,30653346,30653431,30653739,30654079,30654306,30654513,30654546,30654755,30654795,30654827,30654970,30655014,30655050,30655095,30655120,3065515', 'assoc_port': '30578995:30579190,30579357:30579401,30579971:30580123,30580349:30580517,30580703:30580769,30580962:30581051,30581506:30581525,30581507:30581573,30581887:30581971,30582200:30582377,30582555:30582736,30582936:30583023,30583319:30583462,30583939:30584090,30584428:30584479,30584788:30584862,30584955:30585009,30585084:30585109,30585249:30585269,30585250:30585378,30585419:30585587,30585621:30585706,30586494:30586553,30586657:30586721,30586865:30586977,30587092:30587096,30587296:30587395,30587297:30587317,30587552:30587773,30588279:30588310,30589061:30589245,30590114:30590200,30590942:30590995,30591512:30591572,30592286:30592412,30592783:30592897,30594261:30594419,30594262:30594576,30595171:30595505,30595869:30596042,30597461:30597617,30597462:30597815,30598166:30598197,30598812:30598905,30599262:30599418,30599639:30599698,30601505:30601537,30601759:30601764,30613718:30613868,30613719:30614036,30613720:30614475,30613721:30614754,30613722:30614978,30613723:30615286,30613725:30615401,30613727:30615732,30613729:3061603', 'assoc_mat': '30578995:autre:4230:30579190,30579357:autre:4230:30579401,30579971:autre:4230:30580123,30580349:autre:4230:30580517,30580703:autre:4230:30580769,30580962:autre:4230:30581051,30581506:autre:4230:30581525,30581507:autre:4230:30581573,30581887:autre:4230:30581971,30582200:autre:4230:30582377,30582555:autre:4230:30582736,30582936:autre:4230:30583023,30583319:autre:4230:30583462,30583939:autre:4230:30584090,30584428:autre:4230:30584479,30584788:autre:4230:30584862,30584955:autre:4230:30585009,30585084:autre:4230:30585109,30585249:autre:4230:30585269,30585250:autre:4230:30585378,30585419:autre:4230:30585587,30585621:autre:4230:30585706,30586494:autre:4230:30586553,30586657:autre:4230:30586721,30586865:autre:4230:30586977,30587092:autre:4230:30587096,30587296:autre:4230:30587395,30587297:autre:4230:30587317,30587552:autre:4230:30587773,30588279:autre:4230:30588310,30589061:autre:4230:30589245,30590114:autre:4230:30590200,30590942:autre:4230:30590995,30591512:autre:4230:30591572,30592286:autre:4230:30592412,30592783:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04268492423802562, 'nb_photo': 93968, 'list_port_cont': '30579194,30579402,30580131,30580514,30580779,30581059,30581531,30581576,30581975,30582385,30582738,30583025,30583473,30584101,30584487,30584859,30585004,30585103,30585272,30585377,30585575,30585715,30586549,30586718,30586989,30587097,30587315,30587388,30587782,30588320,30589249,30590193,30590994,30591570,30592420,30592896,30594415,30594593,30595508,30596036,30597621,30597812,30598190,30598900,30599435,30599714,30601542,30601769,30613867,30614032,30614472,30614763,30614976,30615279,30615414,30615685,30615719,30615741,30615813,30615857,30615938,30616004,30616042,30616103,30616149,30616189,30616240,30616266,30616323,30616394,30616516,30616740,30631390,30631425,30631461,30631556,30631617,30631695,30631758,30631846,30631931,30631969,30632010,30632040,30632086,30632129,30632239,30632323,30632362,30632418,30632531,30632657,30632847,30632910,30633537,30634205,30653045,30653265,30653351,30653435,30653737,30654076,30654301,30654502,30654551,30654762,30654797,30654826,30654982,30655018,30655053,30655090,30655133,3065516', 'assoc_port': '30578995:30579194,30579357:30579402,30579971:30580131,30580349:30580514,30580703:30580779,30580962:30581059,30581506:30581531,30581507:30581576,30581887:30581975,30582200:30582385,30582555:30582738,30582936:30583025,30583319:30583473,30583939:30584101,30584428:30584487,30584788:30584859,30584955:30585004,30585084:30585103,30585249:30585272,30585250:30585377,30585419:30585575,30585621:30585715,30586494:30586549,30586657:30586718,30586865:30586989,30587092:30587097,30587296:30587388,30587297:30587315,30587552:30587782,30588279:30588320,30589061:30589249,30590114:30590193,30590942:30590994,30591512:30591570,30592286:30592420,30592783:30592896,30594261:30594415,30594262:30594593,30595171:30595508,30595869:30596036,30597461:30597621,30597462:30597812,30598166:30598190,30598812:30598900,30599262:30599435,30599639:30599714,30601505:30601542,30601759:30601769,30613718:30613867,30613719:30614032,30613720:30614472,30613721:30614763,30613722:30614976,30613723:30615279,30613725:30615414,30613727:30615741,30613729:3061604', 'assoc_mat': '30578995:carton:4230:30579194,30579357:carton:4230:30579402,30579971:carton:4230:30580131,30580349:carton:4230:30580514,30580703:carton:4230:30580779,30580962:carton:4230:30581059,30581506:carton:4230:30581531,30581507:carton:4230:30581576,30581887:carton:4230:30581975,30582200:carton:4230:30582385,30582555:carton:4230:30582738,30582936:carton:4230:30583025,30583319:carton:4230:30583473,30583939:carton:4230:30584101,30584428:carton:4230:30584487,30584788:carton:4230:30584859,30584955:carton:4230:30585004,30585084:carton:4230:30585103,30585249:carton:4230:30585272,30585250:carton:4230:30585377,30585419:carton:4230:30585575,30585621:carton:4230:30585715,30586494:carton:4230:30586549,30586657:carton:4230:30586718,30586865:carton:4230:30586989,30587092:carton:4230:30587097,30587296:carton:4230:30587388,30587297:carton:4230:30587315,30587552:carton:4230:30587782,30588279:carton:4230:30588320,30589061:carton:4230:30589249,30590114:carton:4230:30590193,30590942:carton:4230:30590994,30591512:carton:4230:30591570,3059'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011946985956659505, 'nb_photo': 1950, 'list_port_cont': '30579183,30580134,30580512,30580774,30581528,30581569,30581965,30582734,30583465,30584103,30584481,30584864,30585274,30585572,30585705,30586548,30586708,30586994,30588324,30589252,30590194,30590990,30591583,30592405,30594410,30594580,30595501,30597616,30597811,30598904,30599431,30601540,30601778,30613877,30614028,30614473,30614747,30614967,30615282,30615399,30615683,30615713,30615738,30615799,30615853,30615928,30616001,30616045,30616101,30616151,30616188,30616238,30616265,30616321,30616386,30616520,30616729,30631396,30631418,30631466,30631611,30631688,30631748,30631850,30631891,30631971,30632005,30632041,30632084,30632119,30632226,30632319,30632371,30632426,30632516,30632663,30632849,30632896,30633540,30634191,30653043,30653253,30653738,30654087,30654299,30654507,30654544,30654793,30654981,30655022,30655081,30655119,30655161,30655303,30655472,30655476,30655574,30655658,30655814,30664139,30664445,30664591,30664864,30665001,30665086,30665214,30665255,30665279,30665340,30665406,30665443,30665485,30665537,3066557', 'assoc_port': '30578995:30579183,30579971:30580134,30580349:30580512,30580703:30580774,30581506:30581528,30581507:30581569,30581887:30581965,30582555:30582734,30583319:30583465,30583939:30584103,30584428:30584481,30584788:30584864,30585249:30585274,30585419:30585572,30585621:30585705,30586494:30586548,30586657:30586708,30586865:30586994,30588279:30588324,30589061:30589252,30590114:30590194,30590942:30590990,30591512:30591583,30592286:30592405,30594261:30594410,30594262:30594580,30595171:30595501,30597461:30597616,30597462:30597811,30598812:30598904,30599262:30599431,30601505:30601540,30601759:30601778,30613718:30613877,30613719:30614028,30613720:30614473,30613721:30614747,30613722:30614967,30613723:30615282,30613725:30615399,30613727:30615738,30613729:30616045,30613731:30616265,30613733:30616238,30613735:30616188,30613737:30616321,30613739:30616101,30613741:30616001,30613743:30616151,30613745:30616386,30613747:30615799,30613750:30615683,30613753:30615928,30613756:30615853,30613759:30615713,30616413:30616520,30616601:3061672', 'assoc_mat': '30578995:metal:4230:30579183,30579971:metal:4230:30580134,30580349:metal:4230:30580512,30580703:metal:4230:30580774,30581506:metal:4230:30581528,30581507:metal:4230:30581569,30581887:metal:4230:30581965,30582555:metal:4230:30582734,30583319:metal:4230:30583465,30583939:metal:4230:30584103,30584428:metal:4230:30584481,30584788:metal:4230:30584864,30585249:metal:4230:30585274,30585419:metal:4230:30585572,30585621:metal:4230:30585705,30586494:metal:4230:30586548,30586657:metal:4230:30586708,30586865:metal:4230:30586994,30588279:metal:4230:30588324,30589061:metal:4230:30589252,30590114:metal:4230:30590194,30590942:metal:4230:30590990,30591512:metal:4230:30591583,30592286:metal:4230:30592405,30594261:metal:4230:30594410,30594262:metal:4230:30594580,30595171:metal:4230:30595501,30597461:metal:4230:30597616,30597462:metal:4230:30597811,30598812:metal:4230:30598904,30599262:metal:4230:30599431,30601505:metal:4230:30601540,30601759:metal:4230:30601778,30613718:metal:4230:30613877,30613719:metal:4230:30614028,30613720:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20014058983289676, 'nb_photo': 469831, 'list_port_cont': '30579197,30579399,30580135,30580509,30580773,30581052,30581521,30581572,30581967,30582393,30582740,30583015,30583472,30584107,30584486,30584861,30585000,30585095,30585265,30585376,30585586,30585719,30586552,30586720,30586991,30587102,30587314,30587397,30587781,30588322,30589248,30590206,30590986,30591582,30592421,30592885,30594417,30594592,30595510,30596040,30597623,30597808,30598186,30598909,30599425,30599716,30601541,30601776,30613870,30614026,30614468,30614749,30614979,30615290,30615407,30615686,30615726,30615746,30615808,30615877,30615932,30616010,30616039,30616112,30616150,30616184,30616237,30616274,30616311,30616389,30616525,30616743,30631392,30631430,30631464,30631562,30631616,30631700,30631754,30631844,30631926,30631967,30631996,30632051,30632076,30632124,30632234,30632326,30632360,30632423,30632529,30632666,30632841,30632903,30633542,30634202,30653038,30653269,30653359,30653427,30653742,30654091,30654303,30654497,30654548,30654749,30654796,30654836,30654977,30655010,30655054,30655094,30655128,3065515', 'assoc_port': '30578995:30579197,30579357:30579399,30579971:30580135,30580349:30580509,30580703:30580773,30580962:30581052,30581506:30581521,30581507:30581572,30581887:30581967,30582200:30582393,30582555:30582740,30582936:30583015,30583319:30583472,30583939:30584107,30584428:30584486,30584788:30584861,30584955:30585000,30585084:30585095,30585249:30585265,30585250:30585376,30585419:30585586,30585621:30585719,30586494:30586552,30586657:30586720,30586865:30586991,30587092:30587102,30587296:30587397,30587297:30587314,30587552:30587781,30588279:30588322,30589061:30589248,30590114:30590206,30590942:30590986,30591512:30591582,30592286:30592421,30592783:30592885,30594261:30594417,30594262:30594592,30595171:30595510,30595869:30596040,30597461:30597623,30597462:30597808,30598166:30598186,30598812:30598909,30599262:30599425,30599639:30599716,30601505:30601541,30601759:30601776,30613718:30613870,30613719:30614026,30613720:30614468,30613721:30614749,30613722:30614979,30613723:30615290,30613725:30615407,30613727:30615746,30613729:3061603', 'assoc_mat': '30578995:papier:4230:30579197,30579357:papier:4230:30579399,30579971:papier:4230:30580135,30580349:papier:4230:30580509,30580703:papier:4230:30580773,30580962:papier:4230:30581052,30581506:papier:4230:30581521,30581507:papier:4230:30581572,30581887:papier:4230:30581967,30582200:papier:4230:30582393,30582555:papier:4230:30582740,30582936:papier:4230:30583015,30583319:papier:4230:30583472,30583939:papier:4230:30584107,30584428:papier:4230:30584486,30584788:papier:4230:30584861,30584955:papier:4230:30585000,30585084:papier:4230:30585095,30585249:papier:4230:30585265,30585250:papier:4230:30585376,30585419:papier:4230:30585586,30585621:papier:4230:30585719,30586494:papier:4230:30586552,30586657:papier:4230:30586720,30586865:papier:4230:30586991,30587092:papier:4230:30587102,30587296:papier:4230:30587397,30587297:papier:4230:30587314,30587552:papier:4230:30587781,30588279:papier:4230:30588322,30589061:papier:4230:30589248,30590114:papier:4230:30590206,30590942:papier:4230:30590986,30591512:papier:4230:30591582,3059'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004057395193952689, 'nb_photo': 2650, 'list_port_cont': '30579188,30579406,30580132,30580515,30580776,30581530,30581580,30581964,30582731,30584108,30584483,30585015,30585711,30586712,30586982,30587399,30587787,30588323,30590201,30591585,30592410,30592882,30594414,30595513,30596052,30597627,30598195,30598896,30599434,30599708,30601546,30601779,30613874,30615413,30615690,30615722,30615747,30615811,30615861,30615935,30616011,30616044,30616109,30616146,30616183,30616232,30616269,30616318,30616390,30616526,30616746,30631424,30631469,30631613,30631693,30631749,30631859,30631912,30631972,30632004,30632050,30632066,30632126,30632232,30632315,30632367,30632425,30632528,30632658,30632839,30632897,30633528,30634198,30653040,30653261,30654083,30654308,30654504,30654554,30654748,30654980,30655021,30655057,30655093,30655127,30655170,30655305,30655462,30655490,30655575,30655647,30664152,30664317,30664447,30664599,30664866,30664940,30665013,30665078,30665260,30665284,30665357,30665409,30665436,30665482,30665543,30665569,30665625,30665630,30665702,30665873,30666075,30666160,3067729', 'assoc_port': '30578995:30579188,30579357:30579406,30579971:30580132,30580349:30580515,30580703:30580776,30581506:30581530,30581507:30581580,30581887:30581964,30582555:30582731,30583939:30584108,30584428:30584483,30584955:30585015,30585621:30585711,30586657:30586712,30586865:30586982,30587296:30587399,30587552:30587787,30588279:30588323,30590114:30590201,30591512:30591585,30592286:30592410,30592783:30592882,30594261:30594414,30595171:30595513,30595869:30596052,30597461:30597627,30598166:30598195,30598812:30598896,30599262:30599434,30599639:30599708,30601505:30601546,30601759:30601779,30613718:30613874,30613725:30615413,30613727:30615747,30613729:30616044,30613731:30616269,30613733:30616232,30613735:30616183,30613737:30616318,30613739:30616109,30613741:30616011,30613743:30616146,30613745:30616390,30613747:30615811,30613750:30615690,30613753:30615935,30613756:30615861,30613759:30615722,30616413:30616526,30616601:30616746,30629636:30632658,30629641:30632897,30629643:30632528,30629648:30632315,30629652:30632126,30629659:3063205', 'assoc_mat': '30578995:pehd:4230:30579188,30579357:pehd:4230:30579406,30579971:pehd:4230:30580132,30580349:pehd:4230:30580515,30580703:pehd:4230:30580776,30581506:pehd:4230:30581530,30581507:pehd:4230:30581580,30581887:pehd:4230:30581964,30582555:pehd:4230:30582731,30583939:pehd:4230:30584108,30584428:pehd:4230:30584483,30584955:pehd:4230:30585015,30585621:pehd:4230:30585711,30586657:pehd:4230:30586712,30586865:pehd:4230:30586982,30587296:pehd:4230:30587399,30587552:pehd:4230:30587787,30588279:pehd:4230:30588323,30590114:pehd:4230:30590201,30591512:pehd:4230:30591585,30592286:pehd:4230:30592410,30592783:pehd:4230:30592882,30594261:pehd:4230:30594414,30595171:pehd:4230:30595513,30595869:pehd:4230:30596052,30597461:pehd:4230:30597627,30598166:pehd:4230:30598195,30598812:pehd:4230:30598896,30599262:pehd:4230:30599434,30599639:pehd:4230:30599708,30601505:pehd:4230:30601546,30601759:pehd:4230:30601779,30613718:pehd:4230:30613874,30613725:pehd:4230:30615413,30613727:pehd:4230:30615747,30613729:pehd:4230:30616044,30613731:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01783076766240922, 'nb_photo': 31558, 'list_port_cont': '30579195,30579392,30580138,30580516,30580775,30581053,30581527,30581584,30581974,30582382,30582732,30583013,30583470,30584095,30584485,30584865,30585008,30585105,30585262,30585380,30585588,30585721,30586545,30586716,30586993,30587103,30587308,30587389,30587779,30588314,30589254,30590196,30590992,30591579,30592415,30592890,30594407,30594586,30595516,30596053,30597630,30597817,30598185,30598907,30599426,30599711,30601536,30601781,30613876,30614033,30614470,30614758,30614980,30615291,30615410,30615691,30615730,30615737,30615805,30615873,30615931,30616007,30616047,30616115,30616147,30616176,30616233,30616276,30616322,30616391,30616524,30616744,30631394,30631428,30631475,30631563,30631602,30631698,30631756,30631855,30631917,30631973,30632003,30632045,30632068,30632127,30632241,30632311,30632368,30632424,30632521,30632668,30632850,30632907,30633531,30634196,30653047,30653266,30653360,30653439,30653736,30654084,30654312,30654511,30654543,30654753,30654791,30654834,30654979,30655012,30655056,30655091,30655130,3065516', 'assoc_port': '30578995:30579195,30579357:30579392,30579971:30580138,30580349:30580516,30580703:30580775,30580962:30581053,30581506:30581527,30581507:30581584,30581887:30581974,30582200:30582382,30582555:30582732,30582936:30583013,30583319:30583470,30583939:30584095,30584428:30584485,30584788:30584865,30584955:30585008,30585084:30585105,30585249:30585262,30585250:30585380,30585419:30585588,30585621:30585721,30586494:30586545,30586657:30586716,30586865:30586993,30587092:30587103,30587296:30587389,30587297:30587308,30587552:30587779,30588279:30588314,30589061:30589254,30590114:30590196,30590942:30590992,30591512:30591579,30592286:30592415,30592783:30592890,30594261:30594407,30594262:30594586,30595171:30595516,30595869:30596053,30597461:30597630,30597462:30597817,30598166:30598185,30598812:30598907,30599262:30599426,30599639:30599711,30601505:30601536,30601759:30601781,30613718:30613876,30613719:30614033,30613720:30614470,30613721:30614758,30613722:30614980,30613723:30615291,30613725:30615410,30613727:30615737,30613729:3061604', 'assoc_mat': '30578995:pet_clair:4230:30579195,30579357:pet_clair:4230:30579392,30579971:pet_clair:4230:30580138,30580349:pet_clair:4230:30580516,30580703:pet_clair:4230:30580775,30580962:pet_clair:4230:30581053,30581506:pet_clair:4230:30581527,30581507:pet_clair:4230:30581584,30581887:pet_clair:4230:30581974,30582200:pet_clair:4230:30582382,30582555:pet_clair:4230:30582732,30582936:pet_clair:4230:30583013,30583319:pet_clair:4230:30583470,30583939:pet_clair:4230:30584095,30584428:pet_clair:4230:30584485,30584788:pet_clair:4230:30584865,30584955:pet_clair:4230:30585008,30585084:pet_clair:4230:30585105,30585249:pet_clair:4230:30585262,30585250:pet_clair:4230:30585380,30585419:pet_clair:4230:30585588,30585621:pet_clair:4230:30585721,30586494:pet_clair:4230:30586545,30586657:pet_clair:4230:30586716,30586865:pet_clair:4230:30586993,30587092:pet_clair:4230:30587103,30587296:pet_clair:4230:30587389,30587297:pet_clair:4230:30587308,30587552:pet_clair:4230:30587779,30588279:pet_clair:4230:30588314,30589061:pet_clair:4230:30589254,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00258470061457594, 'nb_photo': 1533, 'list_port_cont': '30579198,30579407,30580128,30580778,30581055,30581520,30581586,30581970,30582394,30582739,30583022,30583466,30584096,30584482,30584867,30585003,30585106,30585384,30585579,30585720,30586554,30586709,30587320,30587396,30588317,30589253,30590982,30591576,30592416,30592892,30594411,30594589,30595517,30596044,30597620,30597806,30598901,30599428,30599710,30601547,30614034,30614459,30614756,30614981,30615288,30615408,30615693,30615745,30615814,30615871,30615940,30616009,30616114,30616148,30616185,30616228,30616272,30616326,30616385,30616522,30631393,30631429,30631468,30631553,30631606,30631702,30631746,30631858,30631895,30631968,30632007,30632052,30632088,30632128,30632240,30632364,30632421,30632667,30633539,30634203,30653041,30653268,30653358,30653438,30653733,30654090,30654309,30654510,30654556,30654976,30655020,30655055,30655085,30655134,30655171,30655309,30655463,30655491,30655583,30655655,30655819,30664154,30664442,30664588,30664860,30664937,30665007,30665077,30665230,30665262,30665283,30665411,30665445,3066547', 'assoc_port': '30578995:30579198,30579357:30579407,30579971:30580128,30580703:30580778,30580962:30581055,30581506:30581520,30581507:30581586,30581887:30581970,30582200:30582394,30582555:30582739,30582936:30583022,30583319:30583466,30583939:30584096,30584428:30584482,30584788:30584867,30584955:30585003,30585084:30585106,30585250:30585384,30585419:30585579,30585621:30585720,30586494:30586554,30586657:30586709,30587296:30587396,30587297:30587320,30588279:30588317,30589061:30589253,30590942:30590982,30591512:30591576,30592286:30592416,30592783:30592892,30594261:30594411,30594262:30594589,30595171:30595517,30595869:30596044,30597461:30597620,30597462:30597806,30598812:30598901,30599262:30599428,30599639:30599710,30601505:30601547,30613719:30614034,30613720:30614459,30613721:30614756,30613722:30614981,30613723:30615288,30613725:30615408,30613727:30615745,30613731:30616272,30613733:30616228,30613735:30616185,30613737:30616326,30613739:30616114,30613741:30616009,30613743:30616148,30613745:30616385,30613747:30615814,30613750:3061569', 'assoc_mat': '30578995:pet_fonce:4230:30579198,30579357:pet_fonce:4230:30579407,30579971:pet_fonce:4230:30580128,30580703:pet_fonce:4230:30580778,30580962:pet_fonce:4230:30581055,30581506:pet_fonce:4230:30581520,30581507:pet_fonce:4230:30581586,30581887:pet_fonce:4230:30581970,30582200:pet_fonce:4230:30582394,30582555:pet_fonce:4230:30582739,30582936:pet_fonce:4230:30583022,30583319:pet_fonce:4230:30583466,30583939:pet_fonce:4230:30584096,30584428:pet_fonce:4230:30584482,30584788:pet_fonce:4230:30584867,30584955:pet_fonce:4230:30585003,30585084:pet_fonce:4230:30585106,30585250:pet_fonce:4230:30585384,30585419:pet_fonce:4230:30585579,30585621:pet_fonce:4230:30585720,30586494:pet_fonce:4230:30586554,30586657:pet_fonce:4230:30586709,30587296:pet_fonce:4230:30587396,30587297:pet_fonce:4230:30587320,30588279:pet_fonce:4230:30588317,30589061:pet_fonce:4230:30589253,30590942:pet_fonce:4230:30590982,30591512:pet_fonce:4230:30591576,30592286:pet_fonce:4230:30592416,30592783:pet_fonce:4230:30592892,30594261:pet_fonce:4230:30594411,3'}), 'main_stat': {'nb_photos': 2076}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30842494,30842495,30842496,30842497,30842498,30842499,30842500?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-03', 0.7357855325825561),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_03_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.66%', 23698], 'carton': ['carton', '4.27%', 93968], 'metal': ['metal', '0.12%', 1950], 'papier': ['papier', '20.01%', 469831], 'pehd': ['pehd', '0.41%', 2650], 'pet_clair': ['pet_clair', '1.78%', 31558], 'pet_fonce': ['pet_fonce', '0.26%', 1533]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_03_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.39user 2.84system 0:10.29elapsed 50%CPU (0avgtext+0avgdata 187396maxresident)k 3872inputs+312outputs (50major+49288minor)pagefaults 0swaps