python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-06 _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 : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 06 mtr_id : dashboard_places : SCCU_cam8 date : 2026-06 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2026-06%') and created_at like '%2026-06%'))); nb_day : (0, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 06 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 06 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%062026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-06-01 : dt_date_just_month_year : 2026-06-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-06-01" AND ded.date <= "2026-06-30" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (3002278,2996350,2996322,3001680,3001234,2997664,2998118,2998638,2999170,2999794,3000340,3000782,3001292,3001828,3002436,3002342,3002716,3003452,3004064,3004366) 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.011037633018188607, 'nb_photo': 18842, 'list_port_cont': '31141639,31141883,31142269,31142489,31142807,31142890,31143542,31143618,31143764,31143797,31144176,31144212,31144723,31144766,31144837,31145574,31145614,31145674,31145781,31148250,31148293,31148324,31148368,31148402,31148438,31148482,31148525,31148561,31148588,31148644,31148666,31148709,31148746,31148786,31148822,31148879,31148916,31148960,31148986,31150038,31150091,31150129,31150171,31150209,31150233,31150270,31150325,31150349,31150392,31150440,31150474,31150516,31150558,31150586,31150639,31150675,31150710,31150756,31150777,31150823,31150861,31152611,31152666,31152697,31152741,31152821,31153427,31153936,31155720,31155745,31155802,31155841,31155884,31155932,31155973,31155999,31156037,31156079,31156126,31156170,31156207,31156239,31156286,31156355,31157357,31159018,31159063,31159103,31159127,31159167,31159217,31159255,31159294,31159315,31159377,31159411,31159439,31159491,31159526,31159569,31159591,31159648,31159675,31159715,31159755,31159805,31159839,31159877,31159917,31161830,31161861,31161910,31161938,3116197', 'assoc_port': '31141465:31141639,31141680:31141883,31141931:31143797,31142107:31142269,31142352:31142489,31142560:31142807,31142561:31142890,31142925:31143764,31143336:31143542,31143338:31143618,31143747:31144176,31143748:31144212,31144243:31144766,31144245:31144723,31144246:31145674,31144247:31144837,31144876:31145781,31144877:31145574,31144878:31145614,31146818:31148250,31146820:31148293,31146821:31148324,31146822:31148368,31146823:31148402,31146824:31159917,31146825:31148438,31146826:31148482,31146827:31148525,31146828:31148561,31146829:31148588,31146831:31148644,31146832:31148666,31146833:31148709,31146834:31148746,31146835:31148786,31146836:31148822,31146837:31148879,31146838:31148916,31146839:31148960,31146840:31148986,31146892:31184309,31146893:31184344,31146894:31184392,31146903:31150038,31146904:31153427,31146905:31150091,31146906:31150129,31146907:31150171,31146908:31150209,31146909:31150233,31146910:31150270,31146911:31150325,31146912:31150349,31146913:31150392,31146915:31150440,31146916:31150474,31146917:3115051', 'assoc_mat': '31141465:autre:4230:31141639,31141680:autre:4230:31141883,31141931:autre:4230:31143797,31142107:autre:4230:31142269,31142352:autre:4230:31142489,31142560:autre:4230:31142807,31142561:autre:4230:31142890,31142925:autre:4230:31143764,31143336:autre:4230:31143542,31143338:autre:4230:31143618,31143747:autre:4230:31144176,31143748:autre:4230:31144212,31144243:autre:4230:31144766,31144245:autre:4230:31144723,31144246:autre:4230:31145674,31144247:autre:4230:31144837,31144876:autre:4230:31145781,31144877:autre:4230:31145574,31144878:autre:4230:31145614,31146818:autre:4230:31148250,31146820:autre:4230:31148293,31146821:autre:4230:31148324,31146822:autre:4230:31148368,31146823:autre:4230:31148402,31146824:autre:4230:31159917,31146825:autre:4230:31148438,31146826:autre:4230:31148482,31146827:autre:4230:31148525,31146828:autre:4230:31148561,31146829:autre:4230:31148588,31146831:autre:4230:31148644,31146832:autre:4230:31148666,31146833:autre:4230:31148709,31146834:autre:4230:31148746,31146835:autre:4230:31148786,31146836:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07123531996887002, 'nb_photo': 129003, 'list_port_cont': '31141633,31141900,31142281,31142502,31142815,31142899,31143547,31143624,31143766,31143804,31144180,31144215,31144731,31144763,31144831,31145587,31145631,31145669,31145792,31148249,31148285,31148325,31148370,31148409,31148448,31148479,31148515,31148563,31148598,31148642,31148677,31148710,31148751,31148793,31148828,31148877,31148910,31148951,31149001,31150047,31150096,31150134,31150170,31150198,31150248,31150278,31150326,31150363,31150389,31150433,31150468,31150517,31150556,31150588,31150625,31150673,31150714,31150754,31150786,31150816,31150859,31152618,31152658,31152701,31152745,31152818,31153433,31153941,31155715,31155752,31155796,31155838,31155873,31155923,31155964,31156009,31156044,31156076,31156127,31156157,31156202,31156254,31156290,31156370,31157364,31159024,31159061,31159097,31159140,31159179,31159209,31159247,31159282,31159331,31159379,31159417,31159453,31159492,31159531,31159567,31159607,31159641,31159682,31159724,31159763,31159796,31159828,31159873,31159910,31161826,31161867,31161901,31161951,3116198', 'assoc_port': '31141465:31141633,31141680:31141900,31141931:31143804,31142107:31142281,31142352:31142502,31142560:31142815,31142561:31142899,31142925:31143766,31143336:31143547,31143338:31143624,31143747:31144180,31143748:31144215,31144243:31144763,31144245:31144731,31144246:31145669,31144247:31144831,31144876:31145792,31144877:31145587,31144878:31145631,31146818:31148249,31146820:31148285,31146821:31148325,31146822:31148370,31146823:31148409,31146824:31159910,31146825:31148448,31146826:31148479,31146827:31148515,31146828:31148563,31146829:31148598,31146831:31148642,31146832:31148677,31146833:31148710,31146834:31148751,31146835:31148793,31146836:31148828,31146837:31148877,31146838:31148910,31146839:31148951,31146840:31149001,31146892:31184308,31146893:31184342,31146894:31184394,31146903:31150047,31146904:31153433,31146905:31150096,31146906:31150134,31146907:31150170,31146908:31150198,31146909:31150248,31146910:31150278,31146911:31150326,31146912:31150363,31146913:31150389,31146915:31150433,31146916:31150468,31146917:3115051', 'assoc_mat': '31141465:carton:4230:31141633,31141680:carton:4230:31141900,31141931:carton:4230:31143804,31142107:carton:4230:31142281,31142352:carton:4230:31142502,31142560:carton:4230:31142815,31142561:carton:4230:31142899,31142925:carton:4230:31143766,31143336:carton:4230:31143547,31143338:carton:4230:31143624,31143747:carton:4230:31144180,31143748:carton:4230:31144215,31144243:carton:4230:31144763,31144245:carton:4230:31144731,31144246:carton:4230:31145669,31144247:carton:4230:31144831,31144876:carton:4230:31145792,31144877:carton:4230:31145587,31144878:carton:4230:31145631,31146818:carton:4230:31148249,31146820:carton:4230:31148285,31146821:carton:4230:31148325,31146822:carton:4230:31148370,31146823:carton:4230:31148409,31146824:carton:4230:31159910,31146825:carton:4230:31148448,31146826:carton:4230:31148479,31146827:carton:4230:31148515,31146828:carton:4230:31148563,31146829:carton:4230:31148598,31146831:carton:4230:31148642,31146832:carton:4230:31148677,31146833:carton:4230:31148710,31146834:carton:4230:31148751,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010703122726468954, 'nb_photo': 2170, 'list_port_cont': '31141637,31141888,31142282,31142486,31142817,31142891,31143549,31143622,31143756,31143802,31144169,31144726,31144759,31144833,31145579,31145618,31145673,31145784,31148330,31148361,31148486,31148516,31148562,31148601,31148637,31148678,31148717,31148749,31148794,31148830,31148869,31148915,31148947,31148995,31150055,31150084,31150122,31150168,31150204,31150236,31150286,31150513,31150711,31152625,31152668,31152705,31152743,31152808,31153947,31155707,31155750,31155798,31155825,31155869,31155925,31155969,31156033,31156078,31156115,31156153,31156210,31156255,31156277,31156360,31157360,31159012,31159064,31159090,31159166,31159211,31159256,31159292,31159367,31159402,31159455,31159480,31159535,31159564,31159639,31159685,31159723,31159767,31159793,31159833,31159879,31159914,31161827,31161863,31161908,31161952,31161989,31162016,31162050,31162101,31162129,31162171,31162214,31162237,31162279,31162309,31162396,31162432,31162475,31162506,31162540,31162584,31164983,31165007,31165040,31165085,31165159,31165186,31165236,3116527', 'assoc_port': '31141465:31141637,31141680:31141888,31141931:31143802,31142107:31142282,31142352:31142486,31142560:31142817,31142561:31142891,31142925:31143756,31143336:31143549,31143338:31143622,31143747:31144169,31144243:31144759,31144245:31144726,31144246:31145673,31144247:31144833,31144876:31145784,31144877:31145579,31144878:31145618,31146821:31148330,31146822:31148361,31146824:31159914,31146826:31148486,31146827:31148516,31146828:31148562,31146829:31148601,31146831:31148637,31146832:31148678,31146833:31148717,31146834:31148749,31146835:31148794,31146836:31148830,31146837:31148869,31146838:31148915,31146839:31148947,31146840:31148995,31146892:31184310,31146893:31184332,31146894:31184386,31146903:31150055,31146905:31150084,31146906:31150122,31146907:31150168,31146908:31150204,31146909:31150236,31146910:31150286,31146917:31150513,31146921:31150711,31148229:31153947,31148230:31152625,31148231:31152668,31148232:31152705,31148233:31152743,31148234:31152808,31152917:31180380,31152918:31180411,31152919:31180446,31152920:3118047', 'assoc_mat': '31141465:metal:4230:31141637,31141680:metal:4230:31141888,31141931:metal:4230:31143802,31142107:metal:4230:31142282,31142352:metal:4230:31142486,31142560:metal:4230:31142817,31142561:metal:4230:31142891,31142925:metal:4230:31143756,31143336:metal:4230:31143549,31143338:metal:4230:31143622,31143747:metal:4230:31144169,31144243:metal:4230:31144759,31144245:metal:4230:31144726,31144246:metal:4230:31145673,31144247:metal:4230:31144833,31144876:metal:4230:31145784,31144877:metal:4230:31145579,31144878:metal:4230:31145618,31146821:metal:4230:31148330,31146822:metal:4230:31148361,31146824:metal:4230:31159914,31146826:metal:4230:31148486,31146827:metal:4230:31148516,31146828:metal:4230:31148562,31146829:metal:4230:31148601,31146831:metal:4230:31148637,31146832:metal:4230:31148678,31146833:metal:4230:31148717,31146834:metal:4230:31148749,31146835:metal:4230:31148794,31146836:metal:4230:31148830,31146837:metal:4230:31148869,31146838:metal:4230:31148915,31146839:metal:4230:31148947,31146840:metal:4230:31148995,31146892:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3195074761519967, 'nb_photo': 572174, 'list_port_cont': '31141641,31141891,31142271,31142499,31142821,31142896,31143551,31143615,31143762,31143799,31144175,31144210,31144732,31144772,31144846,31145582,31145624,31145665,31145787,31148245,31148284,31148332,31148372,31148401,31148447,31148478,31148512,31148559,31148597,31148632,31148671,31148721,31148753,31148782,31148833,31148870,31148919,31148954,31149000,31150053,31150097,31150135,31150165,31150203,31150246,31150280,31150320,31150358,31150398,31150432,31150469,31150520,31150554,31150593,31150630,31150677,31150713,31150743,31150783,31150826,31150864,31152627,31152663,31152696,31152744,31152815,31153422,31153942,31155714,31155748,31155800,31155839,31155871,31155929,31155961,31156005,31156048,31156077,31156113,31156161,31156208,31156247,31156276,31156367,31157359,31159017,31159054,31159104,31159141,31159174,31159214,31159250,31159290,31159318,31159374,31159416,31159452,31159490,31159525,31159571,31159593,31159645,31159689,31159722,31159760,31159804,31159840,31159883,31159920,31161824,31161875,31161899,31161950,3116198', 'assoc_port': '31141465:31141641,31141680:31141891,31141931:31143799,31142107:31142271,31142352:31142499,31142560:31142821,31142561:31142896,31142925:31143762,31143336:31143551,31143338:31143615,31143747:31144175,31143748:31144210,31144243:31144772,31144245:31144732,31144246:31145665,31144247:31144846,31144876:31145787,31144877:31145582,31144878:31145624,31146818:31148245,31146820:31148284,31146821:31148332,31146822:31148372,31146823:31148401,31146824:31159920,31146825:31148447,31146826:31148478,31146827:31148512,31146828:31148559,31146829:31148597,31146831:31148632,31146832:31148671,31146833:31148721,31146834:31148753,31146835:31148782,31146836:31148833,31146837:31148870,31146838:31148919,31146839:31148954,31146840:31149000,31146892:31184311,31146893:31184343,31146894:31184398,31146903:31150053,31146904:31153422,31146905:31150097,31146906:31150135,31146907:31150165,31146908:31150203,31146909:31150246,31146910:31150280,31146911:31150320,31146912:31150358,31146913:31150398,31146915:31150432,31146916:31150469,31146917:3115052', 'assoc_mat': '31141465:papier:4230:31141641,31141680:papier:4230:31141891,31141931:papier:4230:31143799,31142107:papier:4230:31142271,31142352:papier:4230:31142499,31142560:papier:4230:31142821,31142561:papier:4230:31142896,31142925:papier:4230:31143762,31143336:papier:4230:31143551,31143338:papier:4230:31143615,31143747:papier:4230:31144175,31143748:papier:4230:31144210,31144243:papier:4230:31144772,31144245:papier:4230:31144732,31144246:papier:4230:31145665,31144247:papier:4230:31144846,31144876:papier:4230:31145787,31144877:papier:4230:31145582,31144878:papier:4230:31145624,31146818:papier:4230:31148245,31146820:papier:4230:31148284,31146821:papier:4230:31148332,31146822:papier:4230:31148372,31146823:papier:4230:31148401,31146824:papier:4230:31159920,31146825:papier:4230:31148447,31146826:papier:4230:31148478,31146827:papier:4230:31148512,31146828:papier:4230:31148559,31146829:papier:4230:31148597,31146831:papier:4230:31148632,31146832:papier:4230:31148671,31146833:papier:4230:31148721,31146834:papier:4230:31148753,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004500209930648316, 'nb_photo': 4042, 'list_port_cont': '31141640,31141894,31142279,31142497,31142819,31142905,31143540,31143623,31143759,31143806,31144178,31144209,31144729,31144768,31144844,31145589,31145629,31145670,31145789,31148247,31148290,31148331,31148371,31148408,31148522,31148557,31148604,31148719,31148759,31148791,31148835,31148871,31148918,31148957,31148993,31150052,31150094,31150133,31150169,31150210,31150245,31150275,31150321,31150362,31150429,31150478,31150553,31150598,31150637,31150704,31150781,31150818,31150856,31152623,31152667,31152694,31152737,31152811,31153430,31153944,31155712,31155755,31155797,31155837,31155879,31155927,31155968,31156000,31156047,31156085,31156119,31156160,31156199,31156251,31156287,31156362,31157358,31159016,31159065,31159094,31159134,31159181,31159212,31159249,31159287,31159323,31159380,31159412,31159451,31159488,31159529,31159570,31159599,31159635,31159686,31159766,31159803,31159835,31159881,31159918,31161831,31161870,31161903,31161946,31161981,31162023,31162094,31162139,31162207,31162252,31162281,31162313,31162364,3116239', 'assoc_port': '31141465:31141640,31141680:31141894,31141931:31143806,31142107:31142279,31142352:31142497,31142560:31142819,31142561:31142905,31142925:31143759,31143336:31143540,31143338:31143623,31143747:31144178,31143748:31144209,31144243:31144768,31144245:31144729,31144246:31145670,31144247:31144844,31144876:31145789,31144877:31145589,31144878:31145629,31146818:31148247,31146820:31148290,31146821:31148331,31146822:31148371,31146823:31148408,31146824:31159918,31146827:31148522,31146828:31148557,31146829:31148604,31146833:31148719,31146834:31148759,31146835:31148791,31146836:31148835,31146837:31148871,31146838:31148918,31146839:31148957,31146840:31148993,31146893:31184348,31146894:31184396,31146903:31150052,31146904:31153430,31146905:31150094,31146906:31150133,31146907:31150169,31146908:31150210,31146909:31150245,31146910:31150275,31146911:31150321,31146912:31150362,31146915:31150429,31146916:31150478,31146918:31150553,31146919:31150598,31146920:31150637,31146921:31150704,31146923:31150781,31146925:31150856,31146926:3115081', 'assoc_mat': '31141465:pehd:4230:31141640,31141680:pehd:4230:31141894,31141931:pehd:4230:31143806,31142107:pehd:4230:31142279,31142352:pehd:4230:31142497,31142560:pehd:4230:31142819,31142561:pehd:4230:31142905,31142925:pehd:4230:31143759,31143336:pehd:4230:31143540,31143338:pehd:4230:31143623,31143747:pehd:4230:31144178,31143748:pehd:4230:31144209,31144243:pehd:4230:31144768,31144245:pehd:4230:31144729,31144246:pehd:4230:31145670,31144247:pehd:4230:31144844,31144876:pehd:4230:31145789,31144877:pehd:4230:31145589,31144878:pehd:4230:31145629,31146818:pehd:4230:31148247,31146820:pehd:4230:31148290,31146821:pehd:4230:31148331,31146822:pehd:4230:31148371,31146823:pehd:4230:31148408,31146824:pehd:4230:31159918,31146827:pehd:4230:31148522,31146828:pehd:4230:31148557,31146829:pehd:4230:31148604,31146833:pehd:4230:31148719,31146834:pehd:4230:31148759,31146835:pehd:4230:31148791,31146836:pehd:4230:31148835,31146837:pehd:4230:31148871,31146838:pehd:4230:31148918,31146839:pehd:4230:31148957,31146840:pehd:4230:31148993,31146893:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006287164919957356, 'nb_photo': 22620, 'list_port_cont': '31141642,31141898,31142278,31142498,31142808,31142904,31143550,31143616,31143767,31143807,31144179,31144217,31144733,31144762,31144838,31145590,31145620,31145667,31145790,31148256,31148294,31148329,31148365,31148393,31148446,31148488,31148520,31148553,31148594,31148633,31148681,31148713,31148757,31148790,31148829,31148881,31148913,31148956,31148999,31150048,31150095,31150127,31150172,31150211,31150244,31150274,31150319,31150360,31150399,31150437,31150481,31150521,31150559,31150590,31150640,31150672,31150708,31150755,31150791,31150824,31150863,31152626,31152652,31152699,31152746,31152816,31153431,31153945,31155711,31155757,31155799,31155840,31155882,31155934,31155972,31155997,31156046,31156088,31156120,31156163,31156212,31156248,31156284,31156366,31157363,31159020,31159058,31159098,31159131,31159180,31159207,31159243,31159293,31159324,31159376,31159409,31159450,31159486,31159532,31159562,31159601,31159636,31159681,31159714,31159762,31159795,31159842,31159882,31159913,31161838,31161874,31161913,31161943,3116198', 'assoc_port': '31141465:31141642,31141680:31141898,31141931:31143807,31142107:31142278,31142352:31142498,31142560:31142808,31142561:31142904,31142925:31143767,31143336:31143550,31143338:31143616,31143747:31144179,31143748:31144217,31144243:31144762,31144245:31144733,31144246:31145667,31144247:31144838,31144876:31145790,31144877:31145590,31144878:31145620,31146818:31148256,31146820:31148294,31146821:31148329,31146822:31148365,31146823:31148393,31146824:31159913,31146825:31148446,31146826:31148488,31146827:31148520,31146828:31148553,31146829:31148594,31146831:31148633,31146832:31148681,31146833:31148713,31146834:31148757,31146835:31148790,31146836:31148829,31146837:31148881,31146838:31148913,31146839:31148956,31146840:31148999,31146892:31184313,31146893:31184346,31146894:31184389,31146903:31150048,31146904:31153431,31146905:31150095,31146906:31150127,31146907:31150172,31146908:31150211,31146909:31150244,31146910:31150274,31146911:31150319,31146912:31150360,31146913:31150399,31146915:31150437,31146916:31150481,31146917:3115052', 'assoc_mat': '31141465:pet_clair:4230:31141642,31141680:pet_clair:4230:31141898,31141931:pet_clair:4230:31143807,31142107:pet_clair:4230:31142278,31142352:pet_clair:4230:31142498,31142560:pet_clair:4230:31142808,31142561:pet_clair:4230:31142904,31142925:pet_clair:4230:31143767,31143336:pet_clair:4230:31143550,31143338:pet_clair:4230:31143616,31143747:pet_clair:4230:31144179,31143748:pet_clair:4230:31144217,31144243:pet_clair:4230:31144762,31144245:pet_clair:4230:31144733,31144246:pet_clair:4230:31145667,31144247:pet_clair:4230:31144838,31144876:pet_clair:4230:31145790,31144877:pet_clair:4230:31145590,31144878:pet_clair:4230:31145620,31146818:pet_clair:4230:31148256,31146820:pet_clair:4230:31148294,31146821:pet_clair:4230:31148329,31146822:pet_clair:4230:31148365,31146823:pet_clair:4230:31148393,31146824:pet_clair:4230:31159913,31146825:pet_clair:4230:31148446,31146826:pet_clair:4230:31148488,31146827:pet_clair:4230:31148520,31146828:pet_clair:4230:31148553,31146829:pet_clair:4230:31148594,31146831:pet_clair:4230:31148633,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017462698623891195, 'nb_photo': 875, 'list_port_cont': '31141896,31142280,31142501,31142812,31142895,31144168,31144214,31144738,31144761,31144834,31145584,31145623,31145663,31145786,31148369,31148475,31148600,31148748,31148785,31148880,31150173,31150284,31150442,31150475,31150712,31152733,31152819,31153948,31155718,31155842,31155878,31155933,31155971,31156006,31156049,31156087,31156125,31156166,31156209,31156291,31156369,31157365,31159023,31159056,31159102,31159138,31159178,31159216,31159253,31159483,31159646,31159688,31159765,31159876,31161837,31161869,31161909,31161944,31162024,31162134,31162180,31162244,31162286,31162356,31162400,31162440,31162469,31164944,31164985,31165055,31165082,31165119,31165164,31165234,31165272,31165595,31165632,31165668,31165695,31165739,31168097,31168127,31168163,31168206,31168350,31168391,31168653,31170303,31170484,31170571,31170609,31170646,31170676,31171217,31175079,31175406,31176573,31176612,31176656,31176694,31176727,31176836,31178353,31178728,31180415,31180449,31180492,31180601,31180641,31180785,31180931,31180963,31183429,3118354', 'assoc_port': '31141680:31141896,31142107:31142280,31142352:31142501,31142560:31142812,31142561:31142895,31143747:31144168,31143748:31144214,31144243:31144761,31144245:31144738,31144246:31145663,31144247:31144834,31144876:31145786,31144877:31145584,31144878:31145623,31146822:31148369,31146826:31148475,31146829:31148600,31146834:31148748,31146835:31148785,31146837:31148880,31146893:31184349,31146907:31150173,31146910:31150284,31146915:31150442,31146916:31150475,31146921:31150712,31148229:31153948,31148233:31152733,31148234:31152819,31152918:31180415,31152919:31180449,31152920:31180492,31152923:31180601,31152924:31180641,31152928:31180785,31152932:31180931,31152933:31180963,31153870:31155718,31153873:31155842,31153874:31155878,31153875:31155933,31153876:31155971,31153877:31156006,31153878:31156049,31153879:31156087,31153880:31156125,31153881:31156166,31153882:31157365,31153883:31156209,31153884:31156291,31153886:31156369,31156481:31176573,31156482:31176612,31156484:31176656,31156485:31176694,31156486:31176727,31156487:3117683', 'assoc_mat': '31141680:pet_fonce:4230:31141896,31142107:pet_fonce:4230:31142280,31142352:pet_fonce:4230:31142501,31142560:pet_fonce:4230:31142812,31142561:pet_fonce:4230:31142895,31143747:pet_fonce:4230:31144168,31143748:pet_fonce:4230:31144214,31144243:pet_fonce:4230:31144761,31144245:pet_fonce:4230:31144738,31144246:pet_fonce:4230:31145663,31144247:pet_fonce:4230:31144834,31144876:pet_fonce:4230:31145786,31144877:pet_fonce:4230:31145584,31144878:pet_fonce:4230:31145623,31146822:pet_fonce:4230:31148369,31146826:pet_fonce:4230:31148475,31146829:pet_fonce:4230:31148600,31146834:pet_fonce:4230:31148748,31146835:pet_fonce:4230:31148785,31146837:pet_fonce:4230:31148880,31146893:pet_fonce:4230:31184349,31146907:pet_fonce:4230:31150173,31146910:pet_fonce:4230:31150284,31146915:pet_fonce:4230:31150442,31146916:pet_fonce:4230:31150475,31146921:pet_fonce:4230:31150712,31148229:pet_fonce:4230:31153948,31148233:pet_fonce:4230:31152733,31148234:pet_fonce:4230:31152819,31152918:pet_fonce:4230:31180415,31152919:pet_fonce:4230:31180449,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(3002278,2996350,2996322,3001680,3001234,2997664,2998118,2998638,2999170,2999794,3000340,3000782,3001292,3001828,3002436,3002342,3002716,3003452,3004064,3004366)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197087, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141639,31141883,31142269,31142489,31142807,31142890,31143542,31143618,31143764,31143797,31144176,31144212,31144723,31144766,31144837,31145574,31145614,31145674,31145781,31148250,31148293,31148324,31148368,31148402,31148438,31148482,31148525,31148561,31148588,31148644,31148666,31148709,31148746,31148786,31148822,31148879,31148916,31148960,31148986,31150038,31150091,31150129,31150171,31150209,31150233,31150270,31150325,31150349,31150392,31150440,31150474,31150516,31150558,31150586,31150639,31150675,31150710,31150756,31150777,31150823,31150861,31152611,31152666,31152697,31152741,31152821,31153427,31153936,31155720,31155745,31155802,31155841,31155884,31155932,31155973,31155999,31156037,31156079,31156126,31156170,31156207,31156239,31156286,31156355,31157357,31159018,31159063,31159103,31159127,31159167,31159217,31159255,31159294,31159315,31159377,31159411,31159439,31159491,31159526,31159569,31159591,31159648,31159675,31159715,31159755,31159805,31159839,31159877,31159917,31161830,31161861,31161910,31161938,3116197 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197088, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141633,31141900,31142281,31142502,31142815,31142899,31143547,31143624,31143766,31143804,31144180,31144215,31144731,31144763,31144831,31145587,31145631,31145669,31145792,31148249,31148285,31148325,31148370,31148409,31148448,31148479,31148515,31148563,31148598,31148642,31148677,31148710,31148751,31148793,31148828,31148877,31148910,31148951,31149001,31150047,31150096,31150134,31150170,31150198,31150248,31150278,31150326,31150363,31150389,31150433,31150468,31150517,31150556,31150588,31150625,31150673,31150714,31150754,31150786,31150816,31150859,31152618,31152658,31152701,31152745,31152818,31153433,31153941,31155715,31155752,31155796,31155838,31155873,31155923,31155964,31156009,31156044,31156076,31156127,31156157,31156202,31156254,31156290,31156370,31157364,31159024,31159061,31159097,31159140,31159179,31159209,31159247,31159282,31159331,31159379,31159417,31159453,31159492,31159531,31159567,31159607,31159641,31159682,31159724,31159763,31159796,31159828,31159873,31159910,31161826,31161867,31161901,31161951,3116198 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197089, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141637,31141888,31142282,31142486,31142817,31142891,31143549,31143622,31143756,31143802,31144169,31144726,31144759,31144833,31145579,31145618,31145673,31145784,31148330,31148361,31148486,31148516,31148562,31148601,31148637,31148678,31148717,31148749,31148794,31148830,31148869,31148915,31148947,31148995,31150055,31150084,31150122,31150168,31150204,31150236,31150286,31150513,31150711,31152625,31152668,31152705,31152743,31152808,31153947,31155707,31155750,31155798,31155825,31155869,31155925,31155969,31156033,31156078,31156115,31156153,31156210,31156255,31156277,31156360,31157360,31159012,31159064,31159090,31159166,31159211,31159256,31159292,31159367,31159402,31159455,31159480,31159535,31159564,31159639,31159685,31159723,31159767,31159793,31159833,31159879,31159914,31161827,31161863,31161908,31161952,31161989,31162016,31162050,31162101,31162129,31162171,31162214,31162237,31162279,31162309,31162396,31162432,31162475,31162506,31162540,31162584,31164983,31165007,31165040,31165085,31165159,31165186,31165236,3116527 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197090, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141641,31141891,31142271,31142499,31142821,31142896,31143551,31143615,31143762,31143799,31144175,31144210,31144732,31144772,31144846,31145582,31145624,31145665,31145787,31148245,31148284,31148332,31148372,31148401,31148447,31148478,31148512,31148559,31148597,31148632,31148671,31148721,31148753,31148782,31148833,31148870,31148919,31148954,31149000,31150053,31150097,31150135,31150165,31150203,31150246,31150280,31150320,31150358,31150398,31150432,31150469,31150520,31150554,31150593,31150630,31150677,31150713,31150743,31150783,31150826,31150864,31152627,31152663,31152696,31152744,31152815,31153422,31153942,31155714,31155748,31155800,31155839,31155871,31155929,31155961,31156005,31156048,31156077,31156113,31156161,31156208,31156247,31156276,31156367,31157359,31159017,31159054,31159104,31159141,31159174,31159214,31159250,31159290,31159318,31159374,31159416,31159452,31159490,31159525,31159571,31159593,31159645,31159689,31159722,31159760,31159804,31159840,31159883,31159920,31161824,31161875,31161899,31161950,3116198 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197091, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141640,31141894,31142279,31142497,31142819,31142905,31143540,31143623,31143759,31143806,31144178,31144209,31144729,31144768,31144844,31145589,31145629,31145670,31145789,31148247,31148290,31148331,31148371,31148408,31148522,31148557,31148604,31148719,31148759,31148791,31148835,31148871,31148918,31148957,31148993,31150052,31150094,31150133,31150169,31150210,31150245,31150275,31150321,31150362,31150429,31150478,31150553,31150598,31150637,31150704,31150781,31150818,31150856,31152623,31152667,31152694,31152737,31152811,31153430,31153944,31155712,31155755,31155797,31155837,31155879,31155927,31155968,31156000,31156047,31156085,31156119,31156160,31156199,31156251,31156287,31156362,31157358,31159016,31159065,31159094,31159134,31159181,31159212,31159249,31159287,31159323,31159380,31159412,31159451,31159488,31159529,31159570,31159599,31159635,31159686,31159766,31159803,31159835,31159881,31159918,31161831,31161870,31161903,31161946,31161981,31162023,31162094,31162139,31162207,31162252,31162281,31162313,31162364,3116239 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197092, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141642,31141898,31142278,31142498,31142808,31142904,31143550,31143616,31143767,31143807,31144179,31144217,31144733,31144762,31144838,31145590,31145620,31145667,31145790,31148256,31148294,31148329,31148365,31148393,31148446,31148488,31148520,31148553,31148594,31148633,31148681,31148713,31148757,31148790,31148829,31148881,31148913,31148956,31148999,31150048,31150095,31150127,31150172,31150211,31150244,31150274,31150319,31150360,31150399,31150437,31150481,31150521,31150559,31150590,31150640,31150672,31150708,31150755,31150791,31150824,31150863,31152626,31152652,31152699,31152746,31152816,31153431,31153945,31155711,31155757,31155799,31155840,31155882,31155934,31155972,31155997,31156046,31156088,31156120,31156163,31156212,31156248,31156284,31156366,31157363,31159020,31159058,31159098,31159131,31159180,31159207,31159243,31159293,31159324,31159376,31159409,31159450,31159486,31159532,31159562,31159601,31159636,31159681,31159714,31159762,31159795,31159842,31159882,31159913,31161838,31161874,31161913,31161943,3116198 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197093, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141896,31142280,31142501,31142812,31142895,31144168,31144214,31144738,31144761,31144834,31145584,31145623,31145663,31145786,31148369,31148475,31148600,31148748,31148785,31148880,31150173,31150284,31150442,31150475,31150712,31152733,31152819,31153948,31155718,31155842,31155878,31155933,31155971,31156006,31156049,31156087,31156125,31156166,31156209,31156291,31156369,31157365,31159023,31159056,31159102,31159138,31159178,31159216,31159253,31159483,31159646,31159688,31159765,31159876,31161837,31161869,31161909,31161944,31162024,31162134,31162180,31162244,31162286,31162356,31162400,31162440,31162469,31164944,31164985,31165055,31165082,31165119,31165164,31165234,31165272,31165595,31165632,31165668,31165695,31165739,31168097,31168127,31168163,31168206,31168350,31168391,31168653,31170303,31170484,31170571,31170609,31170646,31170676,31171217,31175079,31175406,31176573,31176612,31176656,31176694,31176727,31176836,31178353,31178728,31180415,31180449,31180492,31180601,31180641,31180785,31180931,31180963,31183429,3118354 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31197087,31197088,31197089,31197090,31197091,31197092,31197093?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2026-06-01' and date <= '2026-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1084,),), 'unwanted_material_monthly_percentage': ((0.6984458663119686,),), 'material_repartition': (('incineration', 1066),), 'material_dict': {'incineration': 1066}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 6, 1), 0.6473885445946537, 2), (datetime.date(2026, 6, 10), 0.5604276854555451, 2), (datetime.date(2026, 6, 11), 0.578664250289358, 4), (datetime.date(2026, 6, 12), 0.4874014790251046, 4), (datetime.date(2026, 6, 13), 0.4901510946035238, 4), (datetime.date(2026, 6, 14), 0.5359080878107442, 2), (datetime.date(2026, 6, 15), 0.6265535091656811, 3), (datetime.date(2026, 6, 16), 0.742382419866849, 4), (datetime.date(2026, 6, 17), 0.7835428595893237, 2), (datetime.date(2026, 6, 18), 0.7761129327828027, 3), (datetime.date(2026, 6, 19), 0.8911991280984556, 2), (datetime.date(2026, 6, 20), 0.8467287896823465, 2), (datetime.date(2026, 6, 21), 0.8337708593641743, 1), (datetime.date(2026, 6, 22), 0.8418021955526981, 3), (datetime.date(2026, 6, 23), 0.8370044846380879, 1), (datetime.date(2026, 6, 24), 0.7727884276374041, 2), (datetime.date(2026, 6, 25), 0.7772262299760785, 3), (datetime.date(2026, 6, 26), 0.8041098649527229, 1), (datetime.date(2026, 6, 27), 0.7270890487988626, 2), (datetime.date(2026, 6, 28), 0.6574827240433945, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 6, 1), 0.6473885445946537, 2), (datetime.date(2026, 6, 10), 0.5604276854555451, 2), (datetime.date(2026, 6, 11), 0.578664250289358, 4), (datetime.date(2026, 6, 12), 0.4874014790251046, 4), (datetime.date(2026, 6, 13), 0.4901510946035238, 4), (datetime.date(2026, 6, 14), 0.5359080878107442, 2), (datetime.date(2026, 6, 15), 0.6265535091656811, 3), (datetime.date(2026, 6, 16), 0.742382419866849, 4), (datetime.date(2026, 6, 17), 0.7835428595893237, 2), (datetime.date(2026, 6, 18), 0.7761129327828027, 3), (datetime.date(2026, 6, 19), 0.8911991280984556, 2), (datetime.date(2026, 6, 20), 0.8467287896823465, 2), (datetime.date(2026, 6, 21), 0.8337708593641743, 1), (datetime.date(2026, 6, 22), 0.8418021955526981, 3), (datetime.date(2026, 6, 23), 0.8370044846380879, 1), (datetime.date(2026, 6, 24), 0.7727884276374041, 2), (datetime.date(2026, 6, 25), 0.7772262299760785, 3), (datetime.date(2026, 6, 26), 0.8041098649527229, 1), (datetime.date(2026, 6, 27), 0.7270890487988626, 2), (datetime.date(2026, 6, 28), 0.6574827240433945, 1))}, 'quality_array': [['-9.115172016410735', '01062026'], ['-8.974538827512593', '10062026'], ['-9.183140826652938', '11062026'], ['-9.33246395429187', '12062026'], ['-9.2920980576452', '13062026'], ['-9.36315180332025', '14062026'], ['-9.06522818319805', '15062026'], ['-9.058706380052266', '16062026'], ['-8.703880212578344', '17062026'], ['-8.574015549123189', '18062026'], ['-8.18294097761958', '19062026'], ['-8.463162305310632', '20062026'], ['-8.644085341526472', '21062026'], ['-8.167877179060012', '22062026'], ['-7.741166457477087', '23062026'], ['-7.709293431104009', '24062026'], ['-7.5433914570268366', '25062026'], ['-7.828087601681257', '26062026'], ['-7.7900056763407965', '27062026'], ['-8.152486934013337', '28062026']], 'number_of_batch': ((427,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011037633018188607, 'nb_photo': 18842, 'list_port_cont': '31141639,31141883,31142269,31142489,31142807,31142890,31143542,31143618,31143764,31143797,31144176,31144212,31144723,31144766,31144837,31145574,31145614,31145674,31145781,31148250,31148293,31148324,31148368,31148402,31148438,31148482,31148525,31148561,31148588,31148644,31148666,31148709,31148746,31148786,31148822,31148879,31148916,31148960,31148986,31150038,31150091,31150129,31150171,31150209,31150233,31150270,31150325,31150349,31150392,31150440,31150474,31150516,31150558,31150586,31150639,31150675,31150710,31150756,31150777,31150823,31150861,31152611,31152666,31152697,31152741,31152821,31153427,31153936,31155720,31155745,31155802,31155841,31155884,31155932,31155973,31155999,31156037,31156079,31156126,31156170,31156207,31156239,31156286,31156355,31157357,31159018,31159063,31159103,31159127,31159167,31159217,31159255,31159294,31159315,31159377,31159411,31159439,31159491,31159526,31159569,31159591,31159648,31159675,31159715,31159755,31159805,31159839,31159877,31159917,31161830,31161861,31161910,31161938,3116197', 'assoc_port': '31141465:31141639,31141680:31141883,31141931:31143797,31142107:31142269,31142352:31142489,31142560:31142807,31142561:31142890,31142925:31143764,31143336:31143542,31143338:31143618,31143747:31144176,31143748:31144212,31144243:31144766,31144245:31144723,31144246:31145674,31144247:31144837,31144876:31145781,31144877:31145574,31144878:31145614,31146818:31148250,31146820:31148293,31146821:31148324,31146822:31148368,31146823:31148402,31146824:31159917,31146825:31148438,31146826:31148482,31146827:31148525,31146828:31148561,31146829:31148588,31146831:31148644,31146832:31148666,31146833:31148709,31146834:31148746,31146835:31148786,31146836:31148822,31146837:31148879,31146838:31148916,31146839:31148960,31146840:31148986,31146892:31184309,31146893:31184344,31146894:31184392,31146903:31150038,31146904:31153427,31146905:31150091,31146906:31150129,31146907:31150171,31146908:31150209,31146909:31150233,31146910:31150270,31146911:31150325,31146912:31150349,31146913:31150392,31146915:31150440,31146916:31150474,31146917:3115051', 'assoc_mat': '31141465:autre:4230:31141639,31141680:autre:4230:31141883,31141931:autre:4230:31143797,31142107:autre:4230:31142269,31142352:autre:4230:31142489,31142560:autre:4230:31142807,31142561:autre:4230:31142890,31142925:autre:4230:31143764,31143336:autre:4230:31143542,31143338:autre:4230:31143618,31143747:autre:4230:31144176,31143748:autre:4230:31144212,31144243:autre:4230:31144766,31144245:autre:4230:31144723,31144246:autre:4230:31145674,31144247:autre:4230:31144837,31144876:autre:4230:31145781,31144877:autre:4230:31145574,31144878:autre:4230:31145614,31146818:autre:4230:31148250,31146820:autre:4230:31148293,31146821:autre:4230:31148324,31146822:autre:4230:31148368,31146823:autre:4230:31148402,31146824:autre:4230:31159917,31146825:autre:4230:31148438,31146826:autre:4230:31148482,31146827:autre:4230:31148525,31146828:autre:4230:31148561,31146829:autre:4230:31148588,31146831:autre:4230:31148644,31146832:autre:4230:31148666,31146833:autre:4230:31148709,31146834:autre:4230:31148746,31146835:autre:4230:31148786,31146836:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07123531996887002, 'nb_photo': 129003, 'list_port_cont': '31141633,31141900,31142281,31142502,31142815,31142899,31143547,31143624,31143766,31143804,31144180,31144215,31144731,31144763,31144831,31145587,31145631,31145669,31145792,31148249,31148285,31148325,31148370,31148409,31148448,31148479,31148515,31148563,31148598,31148642,31148677,31148710,31148751,31148793,31148828,31148877,31148910,31148951,31149001,31150047,31150096,31150134,31150170,31150198,31150248,31150278,31150326,31150363,31150389,31150433,31150468,31150517,31150556,31150588,31150625,31150673,31150714,31150754,31150786,31150816,31150859,31152618,31152658,31152701,31152745,31152818,31153433,31153941,31155715,31155752,31155796,31155838,31155873,31155923,31155964,31156009,31156044,31156076,31156127,31156157,31156202,31156254,31156290,31156370,31157364,31159024,31159061,31159097,31159140,31159179,31159209,31159247,31159282,31159331,31159379,31159417,31159453,31159492,31159531,31159567,31159607,31159641,31159682,31159724,31159763,31159796,31159828,31159873,31159910,31161826,31161867,31161901,31161951,3116198', 'assoc_port': '31141465:31141633,31141680:31141900,31141931:31143804,31142107:31142281,31142352:31142502,31142560:31142815,31142561:31142899,31142925:31143766,31143336:31143547,31143338:31143624,31143747:31144180,31143748:31144215,31144243:31144763,31144245:31144731,31144246:31145669,31144247:31144831,31144876:31145792,31144877:31145587,31144878:31145631,31146818:31148249,31146820:31148285,31146821:31148325,31146822:31148370,31146823:31148409,31146824:31159910,31146825:31148448,31146826:31148479,31146827:31148515,31146828:31148563,31146829:31148598,31146831:31148642,31146832:31148677,31146833:31148710,31146834:31148751,31146835:31148793,31146836:31148828,31146837:31148877,31146838:31148910,31146839:31148951,31146840:31149001,31146892:31184308,31146893:31184342,31146894:31184394,31146903:31150047,31146904:31153433,31146905:31150096,31146906:31150134,31146907:31150170,31146908:31150198,31146909:31150248,31146910:31150278,31146911:31150326,31146912:31150363,31146913:31150389,31146915:31150433,31146916:31150468,31146917:3115051', 'assoc_mat': '31141465:carton:4230:31141633,31141680:carton:4230:31141900,31141931:carton:4230:31143804,31142107:carton:4230:31142281,31142352:carton:4230:31142502,31142560:carton:4230:31142815,31142561:carton:4230:31142899,31142925:carton:4230:31143766,31143336:carton:4230:31143547,31143338:carton:4230:31143624,31143747:carton:4230:31144180,31143748:carton:4230:31144215,31144243:carton:4230:31144763,31144245:carton:4230:31144731,31144246:carton:4230:31145669,31144247:carton:4230:31144831,31144876:carton:4230:31145792,31144877:carton:4230:31145587,31144878:carton:4230:31145631,31146818:carton:4230:31148249,31146820:carton:4230:31148285,31146821:carton:4230:31148325,31146822:carton:4230:31148370,31146823:carton:4230:31148409,31146824:carton:4230:31159910,31146825:carton:4230:31148448,31146826:carton:4230:31148479,31146827:carton:4230:31148515,31146828:carton:4230:31148563,31146829:carton:4230:31148598,31146831:carton:4230:31148642,31146832:carton:4230:31148677,31146833:carton:4230:31148710,31146834:carton:4230:31148751,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010703122726468954, 'nb_photo': 2170, 'list_port_cont': '31141637,31141888,31142282,31142486,31142817,31142891,31143549,31143622,31143756,31143802,31144169,31144726,31144759,31144833,31145579,31145618,31145673,31145784,31148330,31148361,31148486,31148516,31148562,31148601,31148637,31148678,31148717,31148749,31148794,31148830,31148869,31148915,31148947,31148995,31150055,31150084,31150122,31150168,31150204,31150236,31150286,31150513,31150711,31152625,31152668,31152705,31152743,31152808,31153947,31155707,31155750,31155798,31155825,31155869,31155925,31155969,31156033,31156078,31156115,31156153,31156210,31156255,31156277,31156360,31157360,31159012,31159064,31159090,31159166,31159211,31159256,31159292,31159367,31159402,31159455,31159480,31159535,31159564,31159639,31159685,31159723,31159767,31159793,31159833,31159879,31159914,31161827,31161863,31161908,31161952,31161989,31162016,31162050,31162101,31162129,31162171,31162214,31162237,31162279,31162309,31162396,31162432,31162475,31162506,31162540,31162584,31164983,31165007,31165040,31165085,31165159,31165186,31165236,3116527', 'assoc_port': '31141465:31141637,31141680:31141888,31141931:31143802,31142107:31142282,31142352:31142486,31142560:31142817,31142561:31142891,31142925:31143756,31143336:31143549,31143338:31143622,31143747:31144169,31144243:31144759,31144245:31144726,31144246:31145673,31144247:31144833,31144876:31145784,31144877:31145579,31144878:31145618,31146821:31148330,31146822:31148361,31146824:31159914,31146826:31148486,31146827:31148516,31146828:31148562,31146829:31148601,31146831:31148637,31146832:31148678,31146833:31148717,31146834:31148749,31146835:31148794,31146836:31148830,31146837:31148869,31146838:31148915,31146839:31148947,31146840:31148995,31146892:31184310,31146893:31184332,31146894:31184386,31146903:31150055,31146905:31150084,31146906:31150122,31146907:31150168,31146908:31150204,31146909:31150236,31146910:31150286,31146917:31150513,31146921:31150711,31148229:31153947,31148230:31152625,31148231:31152668,31148232:31152705,31148233:31152743,31148234:31152808,31152917:31180380,31152918:31180411,31152919:31180446,31152920:3118047', 'assoc_mat': '31141465:metal:4230:31141637,31141680:metal:4230:31141888,31141931:metal:4230:31143802,31142107:metal:4230:31142282,31142352:metal:4230:31142486,31142560:metal:4230:31142817,31142561:metal:4230:31142891,31142925:metal:4230:31143756,31143336:metal:4230:31143549,31143338:metal:4230:31143622,31143747:metal:4230:31144169,31144243:metal:4230:31144759,31144245:metal:4230:31144726,31144246:metal:4230:31145673,31144247:metal:4230:31144833,31144876:metal:4230:31145784,31144877:metal:4230:31145579,31144878:metal:4230:31145618,31146821:metal:4230:31148330,31146822:metal:4230:31148361,31146824:metal:4230:31159914,31146826:metal:4230:31148486,31146827:metal:4230:31148516,31146828:metal:4230:31148562,31146829:metal:4230:31148601,31146831:metal:4230:31148637,31146832:metal:4230:31148678,31146833:metal:4230:31148717,31146834:metal:4230:31148749,31146835:metal:4230:31148794,31146836:metal:4230:31148830,31146837:metal:4230:31148869,31146838:metal:4230:31148915,31146839:metal:4230:31148947,31146840:metal:4230:31148995,31146892:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3195074761519967, 'nb_photo': 572174, 'list_port_cont': '31141641,31141891,31142271,31142499,31142821,31142896,31143551,31143615,31143762,31143799,31144175,31144210,31144732,31144772,31144846,31145582,31145624,31145665,31145787,31148245,31148284,31148332,31148372,31148401,31148447,31148478,31148512,31148559,31148597,31148632,31148671,31148721,31148753,31148782,31148833,31148870,31148919,31148954,31149000,31150053,31150097,31150135,31150165,31150203,31150246,31150280,31150320,31150358,31150398,31150432,31150469,31150520,31150554,31150593,31150630,31150677,31150713,31150743,31150783,31150826,31150864,31152627,31152663,31152696,31152744,31152815,31153422,31153942,31155714,31155748,31155800,31155839,31155871,31155929,31155961,31156005,31156048,31156077,31156113,31156161,31156208,31156247,31156276,31156367,31157359,31159017,31159054,31159104,31159141,31159174,31159214,31159250,31159290,31159318,31159374,31159416,31159452,31159490,31159525,31159571,31159593,31159645,31159689,31159722,31159760,31159804,31159840,31159883,31159920,31161824,31161875,31161899,31161950,3116198', 'assoc_port': '31141465:31141641,31141680:31141891,31141931:31143799,31142107:31142271,31142352:31142499,31142560:31142821,31142561:31142896,31142925:31143762,31143336:31143551,31143338:31143615,31143747:31144175,31143748:31144210,31144243:31144772,31144245:31144732,31144246:31145665,31144247:31144846,31144876:31145787,31144877:31145582,31144878:31145624,31146818:31148245,31146820:31148284,31146821:31148332,31146822:31148372,31146823:31148401,31146824:31159920,31146825:31148447,31146826:31148478,31146827:31148512,31146828:31148559,31146829:31148597,31146831:31148632,31146832:31148671,31146833:31148721,31146834:31148753,31146835:31148782,31146836:31148833,31146837:31148870,31146838:31148919,31146839:31148954,31146840:31149000,31146892:31184311,31146893:31184343,31146894:31184398,31146903:31150053,31146904:31153422,31146905:31150097,31146906:31150135,31146907:31150165,31146908:31150203,31146909:31150246,31146910:31150280,31146911:31150320,31146912:31150358,31146913:31150398,31146915:31150432,31146916:31150469,31146917:3115052', 'assoc_mat': '31141465:papier:4230:31141641,31141680:papier:4230:31141891,31141931:papier:4230:31143799,31142107:papier:4230:31142271,31142352:papier:4230:31142499,31142560:papier:4230:31142821,31142561:papier:4230:31142896,31142925:papier:4230:31143762,31143336:papier:4230:31143551,31143338:papier:4230:31143615,31143747:papier:4230:31144175,31143748:papier:4230:31144210,31144243:papier:4230:31144772,31144245:papier:4230:31144732,31144246:papier:4230:31145665,31144247:papier:4230:31144846,31144876:papier:4230:31145787,31144877:papier:4230:31145582,31144878:papier:4230:31145624,31146818:papier:4230:31148245,31146820:papier:4230:31148284,31146821:papier:4230:31148332,31146822:papier:4230:31148372,31146823:papier:4230:31148401,31146824:papier:4230:31159920,31146825:papier:4230:31148447,31146826:papier:4230:31148478,31146827:papier:4230:31148512,31146828:papier:4230:31148559,31146829:papier:4230:31148597,31146831:papier:4230:31148632,31146832:papier:4230:31148671,31146833:papier:4230:31148721,31146834:papier:4230:31148753,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004500209930648316, 'nb_photo': 4042, 'list_port_cont': '31141640,31141894,31142279,31142497,31142819,31142905,31143540,31143623,31143759,31143806,31144178,31144209,31144729,31144768,31144844,31145589,31145629,31145670,31145789,31148247,31148290,31148331,31148371,31148408,31148522,31148557,31148604,31148719,31148759,31148791,31148835,31148871,31148918,31148957,31148993,31150052,31150094,31150133,31150169,31150210,31150245,31150275,31150321,31150362,31150429,31150478,31150553,31150598,31150637,31150704,31150781,31150818,31150856,31152623,31152667,31152694,31152737,31152811,31153430,31153944,31155712,31155755,31155797,31155837,31155879,31155927,31155968,31156000,31156047,31156085,31156119,31156160,31156199,31156251,31156287,31156362,31157358,31159016,31159065,31159094,31159134,31159181,31159212,31159249,31159287,31159323,31159380,31159412,31159451,31159488,31159529,31159570,31159599,31159635,31159686,31159766,31159803,31159835,31159881,31159918,31161831,31161870,31161903,31161946,31161981,31162023,31162094,31162139,31162207,31162252,31162281,31162313,31162364,3116239', 'assoc_port': '31141465:31141640,31141680:31141894,31141931:31143806,31142107:31142279,31142352:31142497,31142560:31142819,31142561:31142905,31142925:31143759,31143336:31143540,31143338:31143623,31143747:31144178,31143748:31144209,31144243:31144768,31144245:31144729,31144246:31145670,31144247:31144844,31144876:31145789,31144877:31145589,31144878:31145629,31146818:31148247,31146820:31148290,31146821:31148331,31146822:31148371,31146823:31148408,31146824:31159918,31146827:31148522,31146828:31148557,31146829:31148604,31146833:31148719,31146834:31148759,31146835:31148791,31146836:31148835,31146837:31148871,31146838:31148918,31146839:31148957,31146840:31148993,31146893:31184348,31146894:31184396,31146903:31150052,31146904:31153430,31146905:31150094,31146906:31150133,31146907:31150169,31146908:31150210,31146909:31150245,31146910:31150275,31146911:31150321,31146912:31150362,31146915:31150429,31146916:31150478,31146918:31150553,31146919:31150598,31146920:31150637,31146921:31150704,31146923:31150781,31146925:31150856,31146926:3115081', 'assoc_mat': '31141465:pehd:4230:31141640,31141680:pehd:4230:31141894,31141931:pehd:4230:31143806,31142107:pehd:4230:31142279,31142352:pehd:4230:31142497,31142560:pehd:4230:31142819,31142561:pehd:4230:31142905,31142925:pehd:4230:31143759,31143336:pehd:4230:31143540,31143338:pehd:4230:31143623,31143747:pehd:4230:31144178,31143748:pehd:4230:31144209,31144243:pehd:4230:31144768,31144245:pehd:4230:31144729,31144246:pehd:4230:31145670,31144247:pehd:4230:31144844,31144876:pehd:4230:31145789,31144877:pehd:4230:31145589,31144878:pehd:4230:31145629,31146818:pehd:4230:31148247,31146820:pehd:4230:31148290,31146821:pehd:4230:31148331,31146822:pehd:4230:31148371,31146823:pehd:4230:31148408,31146824:pehd:4230:31159918,31146827:pehd:4230:31148522,31146828:pehd:4230:31148557,31146829:pehd:4230:31148604,31146833:pehd:4230:31148719,31146834:pehd:4230:31148759,31146835:pehd:4230:31148791,31146836:pehd:4230:31148835,31146837:pehd:4230:31148871,31146838:pehd:4230:31148918,31146839:pehd:4230:31148957,31146840:pehd:4230:31148993,31146893:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006287164919957356, 'nb_photo': 22620, 'list_port_cont': '31141642,31141898,31142278,31142498,31142808,31142904,31143550,31143616,31143767,31143807,31144179,31144217,31144733,31144762,31144838,31145590,31145620,31145667,31145790,31148256,31148294,31148329,31148365,31148393,31148446,31148488,31148520,31148553,31148594,31148633,31148681,31148713,31148757,31148790,31148829,31148881,31148913,31148956,31148999,31150048,31150095,31150127,31150172,31150211,31150244,31150274,31150319,31150360,31150399,31150437,31150481,31150521,31150559,31150590,31150640,31150672,31150708,31150755,31150791,31150824,31150863,31152626,31152652,31152699,31152746,31152816,31153431,31153945,31155711,31155757,31155799,31155840,31155882,31155934,31155972,31155997,31156046,31156088,31156120,31156163,31156212,31156248,31156284,31156366,31157363,31159020,31159058,31159098,31159131,31159180,31159207,31159243,31159293,31159324,31159376,31159409,31159450,31159486,31159532,31159562,31159601,31159636,31159681,31159714,31159762,31159795,31159842,31159882,31159913,31161838,31161874,31161913,31161943,3116198', 'assoc_port': '31141465:31141642,31141680:31141898,31141931:31143807,31142107:31142278,31142352:31142498,31142560:31142808,31142561:31142904,31142925:31143767,31143336:31143550,31143338:31143616,31143747:31144179,31143748:31144217,31144243:31144762,31144245:31144733,31144246:31145667,31144247:31144838,31144876:31145790,31144877:31145590,31144878:31145620,31146818:31148256,31146820:31148294,31146821:31148329,31146822:31148365,31146823:31148393,31146824:31159913,31146825:31148446,31146826:31148488,31146827:31148520,31146828:31148553,31146829:31148594,31146831:31148633,31146832:31148681,31146833:31148713,31146834:31148757,31146835:31148790,31146836:31148829,31146837:31148881,31146838:31148913,31146839:31148956,31146840:31148999,31146892:31184313,31146893:31184346,31146894:31184389,31146903:31150048,31146904:31153431,31146905:31150095,31146906:31150127,31146907:31150172,31146908:31150211,31146909:31150244,31146910:31150274,31146911:31150319,31146912:31150360,31146913:31150399,31146915:31150437,31146916:31150481,31146917:3115052', 'assoc_mat': '31141465:pet_clair:4230:31141642,31141680:pet_clair:4230:31141898,31141931:pet_clair:4230:31143807,31142107:pet_clair:4230:31142278,31142352:pet_clair:4230:31142498,31142560:pet_clair:4230:31142808,31142561:pet_clair:4230:31142904,31142925:pet_clair:4230:31143767,31143336:pet_clair:4230:31143550,31143338:pet_clair:4230:31143616,31143747:pet_clair:4230:31144179,31143748:pet_clair:4230:31144217,31144243:pet_clair:4230:31144762,31144245:pet_clair:4230:31144733,31144246:pet_clair:4230:31145667,31144247:pet_clair:4230:31144838,31144876:pet_clair:4230:31145790,31144877:pet_clair:4230:31145590,31144878:pet_clair:4230:31145620,31146818:pet_clair:4230:31148256,31146820:pet_clair:4230:31148294,31146821:pet_clair:4230:31148329,31146822:pet_clair:4230:31148365,31146823:pet_clair:4230:31148393,31146824:pet_clair:4230:31159913,31146825:pet_clair:4230:31148446,31146826:pet_clair:4230:31148488,31146827:pet_clair:4230:31148520,31146828:pet_clair:4230:31148553,31146829:pet_clair:4230:31148594,31146831:pet_clair:4230:31148633,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017462698623891195, 'nb_photo': 875, 'list_port_cont': '31141896,31142280,31142501,31142812,31142895,31144168,31144214,31144738,31144761,31144834,31145584,31145623,31145663,31145786,31148369,31148475,31148600,31148748,31148785,31148880,31150173,31150284,31150442,31150475,31150712,31152733,31152819,31153948,31155718,31155842,31155878,31155933,31155971,31156006,31156049,31156087,31156125,31156166,31156209,31156291,31156369,31157365,31159023,31159056,31159102,31159138,31159178,31159216,31159253,31159483,31159646,31159688,31159765,31159876,31161837,31161869,31161909,31161944,31162024,31162134,31162180,31162244,31162286,31162356,31162400,31162440,31162469,31164944,31164985,31165055,31165082,31165119,31165164,31165234,31165272,31165595,31165632,31165668,31165695,31165739,31168097,31168127,31168163,31168206,31168350,31168391,31168653,31170303,31170484,31170571,31170609,31170646,31170676,31171217,31175079,31175406,31176573,31176612,31176656,31176694,31176727,31176836,31178353,31178728,31180415,31180449,31180492,31180601,31180641,31180785,31180931,31180963,31183429,3118354', 'assoc_port': '31141680:31141896,31142107:31142280,31142352:31142501,31142560:31142812,31142561:31142895,31143747:31144168,31143748:31144214,31144243:31144761,31144245:31144738,31144246:31145663,31144247:31144834,31144876:31145786,31144877:31145584,31144878:31145623,31146822:31148369,31146826:31148475,31146829:31148600,31146834:31148748,31146835:31148785,31146837:31148880,31146893:31184349,31146907:31150173,31146910:31150284,31146915:31150442,31146916:31150475,31146921:31150712,31148229:31153948,31148233:31152733,31148234:31152819,31152918:31180415,31152919:31180449,31152920:31180492,31152923:31180601,31152924:31180641,31152928:31180785,31152932:31180931,31152933:31180963,31153870:31155718,31153873:31155842,31153874:31155878,31153875:31155933,31153876:31155971,31153877:31156006,31153878:31156049,31153879:31156087,31153880:31156125,31153881:31156166,31153882:31157365,31153883:31156209,31153884:31156291,31153886:31156369,31156481:31176573,31156482:31176612,31156484:31176656,31156485:31176694,31156486:31176727,31156487:3117683', 'assoc_mat': '31141680:pet_fonce:4230:31141896,31142107:pet_fonce:4230:31142280,31142352:pet_fonce:4230:31142501,31142560:pet_fonce:4230:31142812,31142561:pet_fonce:4230:31142895,31143747:pet_fonce:4230:31144168,31143748:pet_fonce:4230:31144214,31144243:pet_fonce:4230:31144761,31144245:pet_fonce:4230:31144738,31144246:pet_fonce:4230:31145663,31144247:pet_fonce:4230:31144834,31144876:pet_fonce:4230:31145786,31144877:pet_fonce:4230:31145584,31144878:pet_fonce:4230:31145623,31146822:pet_fonce:4230:31148369,31146826:pet_fonce:4230:31148475,31146829:pet_fonce:4230:31148600,31146834:pet_fonce:4230:31148748,31146835:pet_fonce:4230:31148785,31146837:pet_fonce:4230:31148880,31146893:pet_fonce:4230:31184349,31146907:pet_fonce:4230:31150173,31146910:pet_fonce:4230:31150284,31146915:pet_fonce:4230:31150442,31146916:pet_fonce:4230:31150475,31146921:pet_fonce:4230:31150712,31148229:pet_fonce:4230:31153948,31148233:pet_fonce:4230:31152733,31148234:pet_fonce:4230:31152819,31152918:pet_fonce:4230:31180415,31152919:pet_fonce:4230:31180449,3'}), 'main_stat': {'nb_photos': 1084}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31197087,31197088,31197089,31197090,31197091,31197092,31197093?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-06', 0.6984458663119686),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1084,),), 'unwanted_material_monthly_percentage': ((0.6984458663119686,),), 'material_repartition': (('incineration', 1066),), 'material_dict': {'incineration': 1066}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 6, 1), 0.6473885445946537, 2), (datetime.date(2026, 6, 10), 0.5604276854555451, 2), (datetime.date(2026, 6, 11), 0.578664250289358, 4), (datetime.date(2026, 6, 12), 0.4874014790251046, 4), (datetime.date(2026, 6, 13), 0.4901510946035238, 4), (datetime.date(2026, 6, 14), 0.5359080878107442, 2), (datetime.date(2026, 6, 15), 0.6265535091656811, 3), (datetime.date(2026, 6, 16), 0.742382419866849, 4), (datetime.date(2026, 6, 17), 0.7835428595893237, 2), (datetime.date(2026, 6, 18), 0.7761129327828027, 3), (datetime.date(2026, 6, 19), 0.8911991280984556, 2), (datetime.date(2026, 6, 20), 0.8467287896823465, 2), (datetime.date(2026, 6, 21), 0.8337708593641743, 1), (datetime.date(2026, 6, 22), 0.8418021955526981, 3), (datetime.date(2026, 6, 23), 0.8370044846380879, 1), (datetime.date(2026, 6, 24), 0.7727884276374041, 2), (datetime.date(2026, 6, 25), 0.7772262299760785, 3), (datetime.date(2026, 6, 26), 0.8041098649527229, 1), (datetime.date(2026, 6, 27), 0.7270890487988626, 2), (datetime.date(2026, 6, 28), 0.6574827240433945, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 6, 1), 0.6473885445946537, 2), (datetime.date(2026, 6, 10), 0.5604276854555451, 2), (datetime.date(2026, 6, 11), 0.578664250289358, 4), (datetime.date(2026, 6, 12), 0.4874014790251046, 4), (datetime.date(2026, 6, 13), 0.4901510946035238, 4), (datetime.date(2026, 6, 14), 0.5359080878107442, 2), (datetime.date(2026, 6, 15), 0.6265535091656811, 3), (datetime.date(2026, 6, 16), 0.742382419866849, 4), (datetime.date(2026, 6, 17), 0.7835428595893237, 2), (datetime.date(2026, 6, 18), 0.7761129327828027, 3), (datetime.date(2026, 6, 19), 0.8911991280984556, 2), (datetime.date(2026, 6, 20), 0.8467287896823465, 2), (datetime.date(2026, 6, 21), 0.8337708593641743, 1), (datetime.date(2026, 6, 22), 0.8418021955526981, 3), (datetime.date(2026, 6, 23), 0.8370044846380879, 1), (datetime.date(2026, 6, 24), 0.7727884276374041, 2), (datetime.date(2026, 6, 25), 0.7772262299760785, 3), (datetime.date(2026, 6, 26), 0.8041098649527229, 1), (datetime.date(2026, 6, 27), 0.7270890487988626, 2), (datetime.date(2026, 6, 28), 0.6574827240433945, 1))}, 'quality_array': [['-9.115172016410735', '01062026'], ['-8.974538827512593', '10062026'], ['-9.183140826652938', '11062026'], ['-9.33246395429187', '12062026'], ['-9.2920980576452', '13062026'], ['-9.36315180332025', '14062026'], ['-9.06522818319805', '15062026'], ['-9.058706380052266', '16062026'], ['-8.703880212578344', '17062026'], ['-8.574015549123189', '18062026'], ['-8.18294097761958', '19062026'], ['-8.463162305310632', '20062026'], ['-8.644085341526472', '21062026'], ['-8.167877179060012', '22062026'], ['-7.741166457477087', '23062026'], ['-7.709293431104009', '24062026'], ['-7.5433914570268366', '25062026'], ['-7.828087601681257', '26062026'], ['-7.7900056763407965', '27062026'], ['-8.152486934013337', '28062026']], 'number_of_batch': ((427,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011037633018188607, 'nb_photo': 18842, 'list_port_cont': '31141639,31141883,31142269,31142489,31142807,31142890,31143542,31143618,31143764,31143797,31144176,31144212,31144723,31144766,31144837,31145574,31145614,31145674,31145781,31148250,31148293,31148324,31148368,31148402,31148438,31148482,31148525,31148561,31148588,31148644,31148666,31148709,31148746,31148786,31148822,31148879,31148916,31148960,31148986,31150038,31150091,31150129,31150171,31150209,31150233,31150270,31150325,31150349,31150392,31150440,31150474,31150516,31150558,31150586,31150639,31150675,31150710,31150756,31150777,31150823,31150861,31152611,31152666,31152697,31152741,31152821,31153427,31153936,31155720,31155745,31155802,31155841,31155884,31155932,31155973,31155999,31156037,31156079,31156126,31156170,31156207,31156239,31156286,31156355,31157357,31159018,31159063,31159103,31159127,31159167,31159217,31159255,31159294,31159315,31159377,31159411,31159439,31159491,31159526,31159569,31159591,31159648,31159675,31159715,31159755,31159805,31159839,31159877,31159917,31161830,31161861,31161910,31161938,3116197', 'assoc_port': '31141465:31141639,31141680:31141883,31141931:31143797,31142107:31142269,31142352:31142489,31142560:31142807,31142561:31142890,31142925:31143764,31143336:31143542,31143338:31143618,31143747:31144176,31143748:31144212,31144243:31144766,31144245:31144723,31144246:31145674,31144247:31144837,31144876:31145781,31144877:31145574,31144878:31145614,31146818:31148250,31146820:31148293,31146821:31148324,31146822:31148368,31146823:31148402,31146824:31159917,31146825:31148438,31146826:31148482,31146827:31148525,31146828:31148561,31146829:31148588,31146831:31148644,31146832:31148666,31146833:31148709,31146834:31148746,31146835:31148786,31146836:31148822,31146837:31148879,31146838:31148916,31146839:31148960,31146840:31148986,31146892:31184309,31146893:31184344,31146894:31184392,31146903:31150038,31146904:31153427,31146905:31150091,31146906:31150129,31146907:31150171,31146908:31150209,31146909:31150233,31146910:31150270,31146911:31150325,31146912:31150349,31146913:31150392,31146915:31150440,31146916:31150474,31146917:3115051', 'assoc_mat': '31141465:autre:4230:31141639,31141680:autre:4230:31141883,31141931:autre:4230:31143797,31142107:autre:4230:31142269,31142352:autre:4230:31142489,31142560:autre:4230:31142807,31142561:autre:4230:31142890,31142925:autre:4230:31143764,31143336:autre:4230:31143542,31143338:autre:4230:31143618,31143747:autre:4230:31144176,31143748:autre:4230:31144212,31144243:autre:4230:31144766,31144245:autre:4230:31144723,31144246:autre:4230:31145674,31144247:autre:4230:31144837,31144876:autre:4230:31145781,31144877:autre:4230:31145574,31144878:autre:4230:31145614,31146818:autre:4230:31148250,31146820:autre:4230:31148293,31146821:autre:4230:31148324,31146822:autre:4230:31148368,31146823:autre:4230:31148402,31146824:autre:4230:31159917,31146825:autre:4230:31148438,31146826:autre:4230:31148482,31146827:autre:4230:31148525,31146828:autre:4230:31148561,31146829:autre:4230:31148588,31146831:autre:4230:31148644,31146832:autre:4230:31148666,31146833:autre:4230:31148709,31146834:autre:4230:31148746,31146835:autre:4230:31148786,31146836:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07123531996887002, 'nb_photo': 129003, 'list_port_cont': '31141633,31141900,31142281,31142502,31142815,31142899,31143547,31143624,31143766,31143804,31144180,31144215,31144731,31144763,31144831,31145587,31145631,31145669,31145792,31148249,31148285,31148325,31148370,31148409,31148448,31148479,31148515,31148563,31148598,31148642,31148677,31148710,31148751,31148793,31148828,31148877,31148910,31148951,31149001,31150047,31150096,31150134,31150170,31150198,31150248,31150278,31150326,31150363,31150389,31150433,31150468,31150517,31150556,31150588,31150625,31150673,31150714,31150754,31150786,31150816,31150859,31152618,31152658,31152701,31152745,31152818,31153433,31153941,31155715,31155752,31155796,31155838,31155873,31155923,31155964,31156009,31156044,31156076,31156127,31156157,31156202,31156254,31156290,31156370,31157364,31159024,31159061,31159097,31159140,31159179,31159209,31159247,31159282,31159331,31159379,31159417,31159453,31159492,31159531,31159567,31159607,31159641,31159682,31159724,31159763,31159796,31159828,31159873,31159910,31161826,31161867,31161901,31161951,3116198', 'assoc_port': '31141465:31141633,31141680:31141900,31141931:31143804,31142107:31142281,31142352:31142502,31142560:31142815,31142561:31142899,31142925:31143766,31143336:31143547,31143338:31143624,31143747:31144180,31143748:31144215,31144243:31144763,31144245:31144731,31144246:31145669,31144247:31144831,31144876:31145792,31144877:31145587,31144878:31145631,31146818:31148249,31146820:31148285,31146821:31148325,31146822:31148370,31146823:31148409,31146824:31159910,31146825:31148448,31146826:31148479,31146827:31148515,31146828:31148563,31146829:31148598,31146831:31148642,31146832:31148677,31146833:31148710,31146834:31148751,31146835:31148793,31146836:31148828,31146837:31148877,31146838:31148910,31146839:31148951,31146840:31149001,31146892:31184308,31146893:31184342,31146894:31184394,31146903:31150047,31146904:31153433,31146905:31150096,31146906:31150134,31146907:31150170,31146908:31150198,31146909:31150248,31146910:31150278,31146911:31150326,31146912:31150363,31146913:31150389,31146915:31150433,31146916:31150468,31146917:3115051', 'assoc_mat': '31141465:carton:4230:31141633,31141680:carton:4230:31141900,31141931:carton:4230:31143804,31142107:carton:4230:31142281,31142352:carton:4230:31142502,31142560:carton:4230:31142815,31142561:carton:4230:31142899,31142925:carton:4230:31143766,31143336:carton:4230:31143547,31143338:carton:4230:31143624,31143747:carton:4230:31144180,31143748:carton:4230:31144215,31144243:carton:4230:31144763,31144245:carton:4230:31144731,31144246:carton:4230:31145669,31144247:carton:4230:31144831,31144876:carton:4230:31145792,31144877:carton:4230:31145587,31144878:carton:4230:31145631,31146818:carton:4230:31148249,31146820:carton:4230:31148285,31146821:carton:4230:31148325,31146822:carton:4230:31148370,31146823:carton:4230:31148409,31146824:carton:4230:31159910,31146825:carton:4230:31148448,31146826:carton:4230:31148479,31146827:carton:4230:31148515,31146828:carton:4230:31148563,31146829:carton:4230:31148598,31146831:carton:4230:31148642,31146832:carton:4230:31148677,31146833:carton:4230:31148710,31146834:carton:4230:31148751,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010703122726468954, 'nb_photo': 2170, 'list_port_cont': '31141637,31141888,31142282,31142486,31142817,31142891,31143549,31143622,31143756,31143802,31144169,31144726,31144759,31144833,31145579,31145618,31145673,31145784,31148330,31148361,31148486,31148516,31148562,31148601,31148637,31148678,31148717,31148749,31148794,31148830,31148869,31148915,31148947,31148995,31150055,31150084,31150122,31150168,31150204,31150236,31150286,31150513,31150711,31152625,31152668,31152705,31152743,31152808,31153947,31155707,31155750,31155798,31155825,31155869,31155925,31155969,31156033,31156078,31156115,31156153,31156210,31156255,31156277,31156360,31157360,31159012,31159064,31159090,31159166,31159211,31159256,31159292,31159367,31159402,31159455,31159480,31159535,31159564,31159639,31159685,31159723,31159767,31159793,31159833,31159879,31159914,31161827,31161863,31161908,31161952,31161989,31162016,31162050,31162101,31162129,31162171,31162214,31162237,31162279,31162309,31162396,31162432,31162475,31162506,31162540,31162584,31164983,31165007,31165040,31165085,31165159,31165186,31165236,3116527', 'assoc_port': '31141465:31141637,31141680:31141888,31141931:31143802,31142107:31142282,31142352:31142486,31142560:31142817,31142561:31142891,31142925:31143756,31143336:31143549,31143338:31143622,31143747:31144169,31144243:31144759,31144245:31144726,31144246:31145673,31144247:31144833,31144876:31145784,31144877:31145579,31144878:31145618,31146821:31148330,31146822:31148361,31146824:31159914,31146826:31148486,31146827:31148516,31146828:31148562,31146829:31148601,31146831:31148637,31146832:31148678,31146833:31148717,31146834:31148749,31146835:31148794,31146836:31148830,31146837:31148869,31146838:31148915,31146839:31148947,31146840:31148995,31146892:31184310,31146893:31184332,31146894:31184386,31146903:31150055,31146905:31150084,31146906:31150122,31146907:31150168,31146908:31150204,31146909:31150236,31146910:31150286,31146917:31150513,31146921:31150711,31148229:31153947,31148230:31152625,31148231:31152668,31148232:31152705,31148233:31152743,31148234:31152808,31152917:31180380,31152918:31180411,31152919:31180446,31152920:3118047', 'assoc_mat': '31141465:metal:4230:31141637,31141680:metal:4230:31141888,31141931:metal:4230:31143802,31142107:metal:4230:31142282,31142352:metal:4230:31142486,31142560:metal:4230:31142817,31142561:metal:4230:31142891,31142925:metal:4230:31143756,31143336:metal:4230:31143549,31143338:metal:4230:31143622,31143747:metal:4230:31144169,31144243:metal:4230:31144759,31144245:metal:4230:31144726,31144246:metal:4230:31145673,31144247:metal:4230:31144833,31144876:metal:4230:31145784,31144877:metal:4230:31145579,31144878:metal:4230:31145618,31146821:metal:4230:31148330,31146822:metal:4230:31148361,31146824:metal:4230:31159914,31146826:metal:4230:31148486,31146827:metal:4230:31148516,31146828:metal:4230:31148562,31146829:metal:4230:31148601,31146831:metal:4230:31148637,31146832:metal:4230:31148678,31146833:metal:4230:31148717,31146834:metal:4230:31148749,31146835:metal:4230:31148794,31146836:metal:4230:31148830,31146837:metal:4230:31148869,31146838:metal:4230:31148915,31146839:metal:4230:31148947,31146840:metal:4230:31148995,31146892:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3195074761519967, 'nb_photo': 572174, 'list_port_cont': '31141641,31141891,31142271,31142499,31142821,31142896,31143551,31143615,31143762,31143799,31144175,31144210,31144732,31144772,31144846,31145582,31145624,31145665,31145787,31148245,31148284,31148332,31148372,31148401,31148447,31148478,31148512,31148559,31148597,31148632,31148671,31148721,31148753,31148782,31148833,31148870,31148919,31148954,31149000,31150053,31150097,31150135,31150165,31150203,31150246,31150280,31150320,31150358,31150398,31150432,31150469,31150520,31150554,31150593,31150630,31150677,31150713,31150743,31150783,31150826,31150864,31152627,31152663,31152696,31152744,31152815,31153422,31153942,31155714,31155748,31155800,31155839,31155871,31155929,31155961,31156005,31156048,31156077,31156113,31156161,31156208,31156247,31156276,31156367,31157359,31159017,31159054,31159104,31159141,31159174,31159214,31159250,31159290,31159318,31159374,31159416,31159452,31159490,31159525,31159571,31159593,31159645,31159689,31159722,31159760,31159804,31159840,31159883,31159920,31161824,31161875,31161899,31161950,3116198', 'assoc_port': '31141465:31141641,31141680:31141891,31141931:31143799,31142107:31142271,31142352:31142499,31142560:31142821,31142561:31142896,31142925:31143762,31143336:31143551,31143338:31143615,31143747:31144175,31143748:31144210,31144243:31144772,31144245:31144732,31144246:31145665,31144247:31144846,31144876:31145787,31144877:31145582,31144878:31145624,31146818:31148245,31146820:31148284,31146821:31148332,31146822:31148372,31146823:31148401,31146824:31159920,31146825:31148447,31146826:31148478,31146827:31148512,31146828:31148559,31146829:31148597,31146831:31148632,31146832:31148671,31146833:31148721,31146834:31148753,31146835:31148782,31146836:31148833,31146837:31148870,31146838:31148919,31146839:31148954,31146840:31149000,31146892:31184311,31146893:31184343,31146894:31184398,31146903:31150053,31146904:31153422,31146905:31150097,31146906:31150135,31146907:31150165,31146908:31150203,31146909:31150246,31146910:31150280,31146911:31150320,31146912:31150358,31146913:31150398,31146915:31150432,31146916:31150469,31146917:3115052', 'assoc_mat': '31141465:papier:4230:31141641,31141680:papier:4230:31141891,31141931:papier:4230:31143799,31142107:papier:4230:31142271,31142352:papier:4230:31142499,31142560:papier:4230:31142821,31142561:papier:4230:31142896,31142925:papier:4230:31143762,31143336:papier:4230:31143551,31143338:papier:4230:31143615,31143747:papier:4230:31144175,31143748:papier:4230:31144210,31144243:papier:4230:31144772,31144245:papier:4230:31144732,31144246:papier:4230:31145665,31144247:papier:4230:31144846,31144876:papier:4230:31145787,31144877:papier:4230:31145582,31144878:papier:4230:31145624,31146818:papier:4230:31148245,31146820:papier:4230:31148284,31146821:papier:4230:31148332,31146822:papier:4230:31148372,31146823:papier:4230:31148401,31146824:papier:4230:31159920,31146825:papier:4230:31148447,31146826:papier:4230:31148478,31146827:papier:4230:31148512,31146828:papier:4230:31148559,31146829:papier:4230:31148597,31146831:papier:4230:31148632,31146832:papier:4230:31148671,31146833:papier:4230:31148721,31146834:papier:4230:31148753,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004500209930648316, 'nb_photo': 4042, 'list_port_cont': '31141640,31141894,31142279,31142497,31142819,31142905,31143540,31143623,31143759,31143806,31144178,31144209,31144729,31144768,31144844,31145589,31145629,31145670,31145789,31148247,31148290,31148331,31148371,31148408,31148522,31148557,31148604,31148719,31148759,31148791,31148835,31148871,31148918,31148957,31148993,31150052,31150094,31150133,31150169,31150210,31150245,31150275,31150321,31150362,31150429,31150478,31150553,31150598,31150637,31150704,31150781,31150818,31150856,31152623,31152667,31152694,31152737,31152811,31153430,31153944,31155712,31155755,31155797,31155837,31155879,31155927,31155968,31156000,31156047,31156085,31156119,31156160,31156199,31156251,31156287,31156362,31157358,31159016,31159065,31159094,31159134,31159181,31159212,31159249,31159287,31159323,31159380,31159412,31159451,31159488,31159529,31159570,31159599,31159635,31159686,31159766,31159803,31159835,31159881,31159918,31161831,31161870,31161903,31161946,31161981,31162023,31162094,31162139,31162207,31162252,31162281,31162313,31162364,3116239', 'assoc_port': '31141465:31141640,31141680:31141894,31141931:31143806,31142107:31142279,31142352:31142497,31142560:31142819,31142561:31142905,31142925:31143759,31143336:31143540,31143338:31143623,31143747:31144178,31143748:31144209,31144243:31144768,31144245:31144729,31144246:31145670,31144247:31144844,31144876:31145789,31144877:31145589,31144878:31145629,31146818:31148247,31146820:31148290,31146821:31148331,31146822:31148371,31146823:31148408,31146824:31159918,31146827:31148522,31146828:31148557,31146829:31148604,31146833:31148719,31146834:31148759,31146835:31148791,31146836:31148835,31146837:31148871,31146838:31148918,31146839:31148957,31146840:31148993,31146893:31184348,31146894:31184396,31146903:31150052,31146904:31153430,31146905:31150094,31146906:31150133,31146907:31150169,31146908:31150210,31146909:31150245,31146910:31150275,31146911:31150321,31146912:31150362,31146915:31150429,31146916:31150478,31146918:31150553,31146919:31150598,31146920:31150637,31146921:31150704,31146923:31150781,31146925:31150856,31146926:3115081', 'assoc_mat': '31141465:pehd:4230:31141640,31141680:pehd:4230:31141894,31141931:pehd:4230:31143806,31142107:pehd:4230:31142279,31142352:pehd:4230:31142497,31142560:pehd:4230:31142819,31142561:pehd:4230:31142905,31142925:pehd:4230:31143759,31143336:pehd:4230:31143540,31143338:pehd:4230:31143623,31143747:pehd:4230:31144178,31143748:pehd:4230:31144209,31144243:pehd:4230:31144768,31144245:pehd:4230:31144729,31144246:pehd:4230:31145670,31144247:pehd:4230:31144844,31144876:pehd:4230:31145789,31144877:pehd:4230:31145589,31144878:pehd:4230:31145629,31146818:pehd:4230:31148247,31146820:pehd:4230:31148290,31146821:pehd:4230:31148331,31146822:pehd:4230:31148371,31146823:pehd:4230:31148408,31146824:pehd:4230:31159918,31146827:pehd:4230:31148522,31146828:pehd:4230:31148557,31146829:pehd:4230:31148604,31146833:pehd:4230:31148719,31146834:pehd:4230:31148759,31146835:pehd:4230:31148791,31146836:pehd:4230:31148835,31146837:pehd:4230:31148871,31146838:pehd:4230:31148918,31146839:pehd:4230:31148957,31146840:pehd:4230:31148993,31146893:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006287164919957356, 'nb_photo': 22620, 'list_port_cont': '31141642,31141898,31142278,31142498,31142808,31142904,31143550,31143616,31143767,31143807,31144179,31144217,31144733,31144762,31144838,31145590,31145620,31145667,31145790,31148256,31148294,31148329,31148365,31148393,31148446,31148488,31148520,31148553,31148594,31148633,31148681,31148713,31148757,31148790,31148829,31148881,31148913,31148956,31148999,31150048,31150095,31150127,31150172,31150211,31150244,31150274,31150319,31150360,31150399,31150437,31150481,31150521,31150559,31150590,31150640,31150672,31150708,31150755,31150791,31150824,31150863,31152626,31152652,31152699,31152746,31152816,31153431,31153945,31155711,31155757,31155799,31155840,31155882,31155934,31155972,31155997,31156046,31156088,31156120,31156163,31156212,31156248,31156284,31156366,31157363,31159020,31159058,31159098,31159131,31159180,31159207,31159243,31159293,31159324,31159376,31159409,31159450,31159486,31159532,31159562,31159601,31159636,31159681,31159714,31159762,31159795,31159842,31159882,31159913,31161838,31161874,31161913,31161943,3116198', 'assoc_port': '31141465:31141642,31141680:31141898,31141931:31143807,31142107:31142278,31142352:31142498,31142560:31142808,31142561:31142904,31142925:31143767,31143336:31143550,31143338:31143616,31143747:31144179,31143748:31144217,31144243:31144762,31144245:31144733,31144246:31145667,31144247:31144838,31144876:31145790,31144877:31145590,31144878:31145620,31146818:31148256,31146820:31148294,31146821:31148329,31146822:31148365,31146823:31148393,31146824:31159913,31146825:31148446,31146826:31148488,31146827:31148520,31146828:31148553,31146829:31148594,31146831:31148633,31146832:31148681,31146833:31148713,31146834:31148757,31146835:31148790,31146836:31148829,31146837:31148881,31146838:31148913,31146839:31148956,31146840:31148999,31146892:31184313,31146893:31184346,31146894:31184389,31146903:31150048,31146904:31153431,31146905:31150095,31146906:31150127,31146907:31150172,31146908:31150211,31146909:31150244,31146910:31150274,31146911:31150319,31146912:31150360,31146913:31150399,31146915:31150437,31146916:31150481,31146917:3115052', 'assoc_mat': '31141465:pet_clair:4230:31141642,31141680:pet_clair:4230:31141898,31141931:pet_clair:4230:31143807,31142107:pet_clair:4230:31142278,31142352:pet_clair:4230:31142498,31142560:pet_clair:4230:31142808,31142561:pet_clair:4230:31142904,31142925:pet_clair:4230:31143767,31143336:pet_clair:4230:31143550,31143338:pet_clair:4230:31143616,31143747:pet_clair:4230:31144179,31143748:pet_clair:4230:31144217,31144243:pet_clair:4230:31144762,31144245:pet_clair:4230:31144733,31144246:pet_clair:4230:31145667,31144247:pet_clair:4230:31144838,31144876:pet_clair:4230:31145790,31144877:pet_clair:4230:31145590,31144878:pet_clair:4230:31145620,31146818:pet_clair:4230:31148256,31146820:pet_clair:4230:31148294,31146821:pet_clair:4230:31148329,31146822:pet_clair:4230:31148365,31146823:pet_clair:4230:31148393,31146824:pet_clair:4230:31159913,31146825:pet_clair:4230:31148446,31146826:pet_clair:4230:31148488,31146827:pet_clair:4230:31148520,31146828:pet_clair:4230:31148553,31146829:pet_clair:4230:31148594,31146831:pet_clair:4230:31148633,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017462698623891195, 'nb_photo': 875, 'list_port_cont': '31141896,31142280,31142501,31142812,31142895,31144168,31144214,31144738,31144761,31144834,31145584,31145623,31145663,31145786,31148369,31148475,31148600,31148748,31148785,31148880,31150173,31150284,31150442,31150475,31150712,31152733,31152819,31153948,31155718,31155842,31155878,31155933,31155971,31156006,31156049,31156087,31156125,31156166,31156209,31156291,31156369,31157365,31159023,31159056,31159102,31159138,31159178,31159216,31159253,31159483,31159646,31159688,31159765,31159876,31161837,31161869,31161909,31161944,31162024,31162134,31162180,31162244,31162286,31162356,31162400,31162440,31162469,31164944,31164985,31165055,31165082,31165119,31165164,31165234,31165272,31165595,31165632,31165668,31165695,31165739,31168097,31168127,31168163,31168206,31168350,31168391,31168653,31170303,31170484,31170571,31170609,31170646,31170676,31171217,31175079,31175406,31176573,31176612,31176656,31176694,31176727,31176836,31178353,31178728,31180415,31180449,31180492,31180601,31180641,31180785,31180931,31180963,31183429,3118354', 'assoc_port': '31141680:31141896,31142107:31142280,31142352:31142501,31142560:31142812,31142561:31142895,31143747:31144168,31143748:31144214,31144243:31144761,31144245:31144738,31144246:31145663,31144247:31144834,31144876:31145786,31144877:31145584,31144878:31145623,31146822:31148369,31146826:31148475,31146829:31148600,31146834:31148748,31146835:31148785,31146837:31148880,31146893:31184349,31146907:31150173,31146910:31150284,31146915:31150442,31146916:31150475,31146921:31150712,31148229:31153948,31148233:31152733,31148234:31152819,31152918:31180415,31152919:31180449,31152920:31180492,31152923:31180601,31152924:31180641,31152928:31180785,31152932:31180931,31152933:31180963,31153870:31155718,31153873:31155842,31153874:31155878,31153875:31155933,31153876:31155971,31153877:31156006,31153878:31156049,31153879:31156087,31153880:31156125,31153881:31156166,31153882:31157365,31153883:31156209,31153884:31156291,31153886:31156369,31156481:31176573,31156482:31176612,31156484:31176656,31156485:31176694,31156486:31176727,31156487:3117683', 'assoc_mat': '31141680:pet_fonce:4230:31141896,31142107:pet_fonce:4230:31142280,31142352:pet_fonce:4230:31142501,31142560:pet_fonce:4230:31142812,31142561:pet_fonce:4230:31142895,31143747:pet_fonce:4230:31144168,31143748:pet_fonce:4230:31144214,31144243:pet_fonce:4230:31144761,31144245:pet_fonce:4230:31144738,31144246:pet_fonce:4230:31145663,31144247:pet_fonce:4230:31144834,31144876:pet_fonce:4230:31145786,31144877:pet_fonce:4230:31145584,31144878:pet_fonce:4230:31145623,31146822:pet_fonce:4230:31148369,31146826:pet_fonce:4230:31148475,31146829:pet_fonce:4230:31148600,31146834:pet_fonce:4230:31148748,31146835:pet_fonce:4230:31148785,31146837:pet_fonce:4230:31148880,31146893:pet_fonce:4230:31184349,31146907:pet_fonce:4230:31150173,31146910:pet_fonce:4230:31150284,31146915:pet_fonce:4230:31150442,31146916:pet_fonce:4230:31150475,31146921:pet_fonce:4230:31150712,31148229:pet_fonce:4230:31153948,31148233:pet_fonce:4230:31152733,31148234:pet_fonce:4230:31152819,31152918:pet_fonce:4230:31180415,31152919:pet_fonce:4230:31180449,3'}), 'main_stat': {'nb_photos': 1084}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31197087,31197088,31197089,31197090,31197091,31197092,31197093?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-06', 0.6984458663119686),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_06_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.1%', 18842], 'carton': ['carton', '7.12%', 129003], 'metal': ['metal', '0.11%', 2170], 'papier': ['papier', '31.95%', 572174], 'pehd': ['pehd', '0.45%', 4042], 'pet_clair': ['pet_clair', '0.63%', 22620], 'pet_fonce': ['pet_fonce', '0.17%', 875]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_06_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.37user 2.51system 0:34.46elapsed 14%CPU (0avgtext+0avgdata 191140maxresident)k 8inputs+304outputs (4major+51956minor)pagefaults 0swaps