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-04 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_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 : (2, 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 : 04 mtr_id : dashboard_places : SCCU_cam8 date : 2026-04 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2026-04%') and created_at like '%2026-04%'))); nb_day : (2, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 04 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 04 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%042026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-04-01 : dt_date_just_month_year : 2026-04-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_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-04-01" AND ded.date <= "2026-04-30" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (2972770,2973449,2974045,2974638,2975093,2975656,2976329,2976995,2977611,2977794,2978150,2978634,2979190,2979816,2980456,2981066,2981298,2981734,2982020,2982468,2982876,2983336,2983886,2984368,2984782,2984978) 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.02141778841964629, 'nb_photo': 20113, 'list_port_cont': '30919090,30919198,30919228,30919311,30919414,30919537,30919643,30919670,30919755,30919832,30919902,30919967,30920055,30920114,30920205,30920277,30920377,30920420,30920498,30920531,30920727,30920793,30920941,30921336,30925069,30925104,30925180,30925264,30925363,30925404,30925481,30925558,30925668,30925712,30925816,30925885,30925926,30925970,30926013,30926034,30926084,30926124,30926157,30926189,30926291,30926383,30926926,30926955,30930172,30930200,30930237,30930268,30930319,30930349,30930394,30930416,30930455,30930501,30930543,30930573,30930616,30930649,30930681,30930719,30930747,30930793,30930822,30930865,30930900,30930932,30930985,30931839,30931926,30931996,30932237,30932510,30932580,30932620,30932767,30932900,30933142,30933273,30933421,30933505,30933765,30933806,30933935,30934029,30934201,30934340,30934461,30934564,30934715,30934829,30935632,30935698,30938894,30939828,30939862,30939898,30939945,30939973,30940014,30940086,30940191,30940278,30940357,30940433,30940500,30940577,30940641,30940685,30940844,3094087', 'assoc_port': '30918213:30919090,30918216:30919198,30918219:30919228,30918222:30919311,30918225:30920941,30918228:30919414,30918231:30919537,30918234:30919643,30918237:30919670,30918240:30919755,30918243:30919832,30918246:30919902,30918249:30919967,30918252:30920055,30918255:30920114,30918257:30920205,30918259:30920277,30918261:30920377,30918263:30920420,30918265:30920498,30918267:30920531,30918269:30921336,30918614:30920727,30918923:30920793,30923839:30925069,30923842:30925104,30923845:30925180,30923848:30925264,30923851:30925363,30923854:30925404,30923857:30925481,30923860:30925558,30923863:30925668,30923866:30925712,30923869:30925816,30923872:30925885,30923875:30925926,30923878:30925970,30923881:30926926,30923883:30926034,30923885:30926157,30923887:30926013,30923889:30926084,30923891:30926955,30923893:30926124,30923894:30926189,30924275:30926291,30924729:30926383,30929372:30930172,30929374:30930200,30929377:30930237,30929379:30930268,30929381:30930319,30929383:30930349,30929385:30930394,30929386:30930416,30929389:3093045', 'assoc_mat': '30918213:autre:4230:30919090,30918216:autre:4230:30919198,30918219:autre:4230:30919228,30918222:autre:4230:30919311,30918225:autre:4230:30920941,30918228:autre:4230:30919414,30918231:autre:4230:30919537,30918234:autre:4230:30919643,30918237:autre:4230:30919670,30918240:autre:4230:30919755,30918243:autre:4230:30919832,30918246:autre:4230:30919902,30918249:autre:4230:30919967,30918252:autre:4230:30920055,30918255:autre:4230:30920114,30918257:autre:4230:30920205,30918259:autre:4230:30920277,30918261:autre:4230:30920377,30918263:autre:4230:30920420,30918265:autre:4230:30920498,30918267:autre:4230:30920531,30918269:autre:4230:30921336,30918614:autre:4230:30920727,30918923:autre:4230:30920793,30923839:autre:4230:30925069,30923842:autre:4230:30925104,30923845:autre:4230:30925180,30923848:autre:4230:30925264,30923851:autre:4230:30925363,30923854:autre:4230:30925404,30923857:autre:4230:30925481,30923860:autre:4230:30925558,30923863:autre:4230:30925668,30923866:autre:4230:30925712,30923869:autre:4230:30925816,30923872:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0867916440219037, 'nb_photo': 99901, 'list_port_cont': '30919088,30919196,30919238,30919313,30919423,30919529,30919637,30919677,30919752,30919834,30919908,30919980,30920045,30920131,30920198,30920278,30920382,30920422,30920492,30920533,30920728,30920802,30920949,30921350,30925082,30925117,30925181,30925259,30925380,30925408,30925484,30925566,30925667,30925711,30925821,30925889,30925939,30925975,30926001,30926047,30926087,30926115,30926156,30926196,30926308,30926377,30926923,30926964,30930163,30930208,30930240,30930279,30930315,30930348,30930392,30930428,30930463,30930503,30930528,30930581,30930612,30930653,30930676,30930721,30930764,30930800,30930829,30930859,30930904,30930940,30930991,30931848,30931915,30931994,30932243,30932503,30932582,30932624,30932779,30932891,30933145,30933283,30933427,30933506,30933776,30933813,30933929,30934034,30934214,30934339,30934469,30934562,30934723,30934825,30935636,30935704,30938887,30939841,30939878,30939914,30939940,30939977,30940024,30940095,30940205,30940277,30940355,30940425,30940505,30940570,30940643,30940689,30940840,3094086', 'assoc_port': '30918213:30919088,30918216:30919196,30918219:30919238,30918222:30919313,30918225:30920949,30918228:30919423,30918231:30919529,30918234:30919637,30918237:30919677,30918240:30919752,30918243:30919834,30918246:30919908,30918249:30919980,30918252:30920045,30918255:30920131,30918257:30920198,30918259:30920278,30918261:30920382,30918263:30920422,30918265:30920492,30918267:30920533,30918269:30921350,30918614:30920728,30918923:30920802,30923839:30925082,30923842:30925117,30923845:30925181,30923848:30925259,30923851:30925380,30923854:30925408,30923857:30925484,30923860:30925566,30923863:30925667,30923866:30925711,30923869:30925821,30923872:30925889,30923875:30925939,30923878:30925975,30923881:30926923,30923883:30926047,30923885:30926156,30923887:30926001,30923889:30926087,30923891:30926964,30923893:30926115,30923894:30926196,30924275:30926308,30924729:30926377,30929372:30930163,30929374:30930208,30929377:30930240,30929379:30930279,30929381:30930315,30929383:30930348,30929385:30930392,30929386:30930428,30929389:3093046', 'assoc_mat': '30918213:carton:4230:30919088,30918216:carton:4230:30919196,30918219:carton:4230:30919238,30918222:carton:4230:30919313,30918225:carton:4230:30920949,30918228:carton:4230:30919423,30918231:carton:4230:30919529,30918234:carton:4230:30919637,30918237:carton:4230:30919677,30918240:carton:4230:30919752,30918243:carton:4230:30919834,30918246:carton:4230:30919908,30918249:carton:4230:30919980,30918252:carton:4230:30920045,30918255:carton:4230:30920131,30918257:carton:4230:30920198,30918259:carton:4230:30920278,30918261:carton:4230:30920382,30918263:carton:4230:30920422,30918265:carton:4230:30920492,30918267:carton:4230:30920533,30918269:carton:4230:30921350,30918614:carton:4230:30920728,30918923:carton:4230:30920802,30923839:carton:4230:30925082,30923842:carton:4230:30925117,30923845:carton:4230:30925181,30923848:carton:4230:30925259,30923851:carton:4230:30925380,30923854:carton:4230:30925408,30923857:carton:4230:30925484,30923860:carton:4230:30925566,30923863:carton:4230:30925667,30923866:carton:4230:30925711,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018313742914263698, 'nb_photo': 1819, 'list_port_cont': '30919084,30919195,30919224,30919312,30919426,30919522,30919646,30919678,30919758,30919824,30919896,30919982,30920056,30920121,30920194,30920273,30920376,30920414,30920496,30920523,30920714,30920799,30920948,30921340,30925066,30925111,30925184,30925261,30925377,30925414,30925485,30925567,30925679,30925702,30925822,30925892,30925937,30925974,30926004,30926049,30926079,30926121,30926307,30926372,30926927,30926960,30930170,30930205,30930245,30930269,30930316,30930341,30930387,30930432,30930457,30930492,30930538,30930582,30930609,30930646,30930678,30930724,30930763,30930803,30930835,30930867,30930896,30930936,30930982,30931850,30931914,30931993,30932234,30932501,30932572,30932609,30932766,30933144,30933275,30933419,30933509,30933761,30933802,30933932,30934033,30934197,30934343,30934727,30935635,30939829,30939943,30940017,30940200,30940274,30940416,30940506,30940654,30940691,30940837,30940866,30940943,30941014,30941088,30941419,30941565,30945166,30945199,30945270,30945339,30945428,30945492,30945575,30945644,3094571', 'assoc_port': '30918213:30919084,30918216:30919195,30918219:30919224,30918222:30919312,30918225:30920948,30918228:30919426,30918231:30919522,30918234:30919646,30918237:30919678,30918240:30919758,30918243:30919824,30918246:30919896,30918249:30919982,30918252:30920056,30918255:30920121,30918257:30920194,30918259:30920273,30918261:30920376,30918263:30920414,30918265:30920496,30918267:30920523,30918269:30921340,30918614:30920714,30918923:30920799,30923839:30925066,30923842:30925111,30923845:30925184,30923848:30925261,30923851:30925377,30923854:30925414,30923857:30925485,30923860:30925567,30923863:30925679,30923866:30925702,30923869:30925822,30923872:30925892,30923875:30925937,30923878:30925974,30923881:30926927,30923883:30926049,30923887:30926004,30923889:30926079,30923891:30926960,30923893:30926121,30924275:30926307,30924729:30926372,30929372:30930170,30929374:30930205,30929377:30930245,30929379:30930269,30929381:30930316,30929383:30930341,30929385:30930387,30929386:30930432,30929389:30930457,30929391:30930492,30929392:3093053', 'assoc_mat': '30918213:metal:4230:30919084,30918216:metal:4230:30919195,30918219:metal:4230:30919224,30918222:metal:4230:30919312,30918225:metal:4230:30920948,30918228:metal:4230:30919426,30918231:metal:4230:30919522,30918234:metal:4230:30919646,30918237:metal:4230:30919678,30918240:metal:4230:30919758,30918243:metal:4230:30919824,30918246:metal:4230:30919896,30918249:metal:4230:30919982,30918252:metal:4230:30920056,30918255:metal:4230:30920121,30918257:metal:4230:30920194,30918259:metal:4230:30920273,30918261:metal:4230:30920376,30918263:metal:4230:30920414,30918265:metal:4230:30920496,30918267:metal:4230:30920523,30918269:metal:4230:30921340,30918614:metal:4230:30920714,30918923:metal:4230:30920799,30923839:metal:4230:30925066,30923842:metal:4230:30925111,30923845:metal:4230:30925184,30923848:metal:4230:30925261,30923851:metal:4230:30925377,30923854:metal:4230:30925414,30923857:metal:4230:30925485,30923860:metal:4230:30925567,30923863:metal:4230:30925679,30923866:metal:4230:30925702,30923869:metal:4230:30925822,30923872:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3184084051365039, 'nb_photo': 333250, 'list_port_cont': '30919092,30919197,30919227,30919304,30919422,30919532,30919642,30919682,30919754,30919831,30919904,30919979,30920054,30920130,30920202,30920279,30920385,30920426,30920494,30920535,30920730,30920803,30920944,30921343,30925071,30925106,30925196,30925269,30925373,30925413,30925493,30925564,30925673,30925715,30925824,30925899,30925938,30925971,30926010,30926050,30926086,30926119,30926160,30926193,30926305,30926388,30926920,30926957,30930169,30930206,30930244,30930275,30930306,30930356,30930386,30930431,30930464,30930504,30930541,30930571,30930608,30930644,30930684,30930726,30930757,30930791,30930837,30930874,30930906,30930946,30930992,30931840,30931924,30931995,30932246,30932508,30932576,30932622,30932775,30932899,30933137,30933278,30933425,30933516,30933770,30933815,30933940,30934026,30934200,30934329,30934464,30934557,30934717,30934831,30935637,30935708,30938892,30939838,30939875,30939911,30939939,30939981,30940015,30940098,30940208,30940281,30940354,30940430,30940504,30940574,30940645,30940686,30940836,3094087', 'assoc_port': '30918213:30919092,30918216:30919197,30918219:30919227,30918222:30919304,30918225:30920944,30918228:30919422,30918231:30919532,30918234:30919642,30918237:30919682,30918240:30919754,30918243:30919831,30918246:30919904,30918249:30919979,30918252:30920054,30918255:30920130,30918257:30920202,30918259:30920279,30918261:30920385,30918263:30920426,30918265:30920494,30918267:30920535,30918269:30921343,30918614:30920730,30918923:30920803,30923839:30925071,30923842:30925106,30923845:30925196,30923848:30925269,30923851:30925373,30923854:30925413,30923857:30925493,30923860:30925564,30923863:30925673,30923866:30925715,30923869:30925824,30923872:30925899,30923875:30925938,30923878:30925971,30923881:30926920,30923883:30926050,30923885:30926160,30923887:30926010,30923889:30926086,30923891:30926957,30923893:30926119,30923894:30926193,30924275:30926305,30924729:30926388,30929372:30930169,30929374:30930206,30929377:30930244,30929379:30930275,30929381:30930306,30929383:30930356,30929385:30930386,30929386:30930431,30929389:3093046', 'assoc_mat': '30918213:papier:4230:30919092,30918216:papier:4230:30919197,30918219:papier:4230:30919227,30918222:papier:4230:30919304,30918225:papier:4230:30920944,30918228:papier:4230:30919422,30918231:papier:4230:30919532,30918234:papier:4230:30919642,30918237:papier:4230:30919682,30918240:papier:4230:30919754,30918243:papier:4230:30919831,30918246:papier:4230:30919904,30918249:papier:4230:30919979,30918252:papier:4230:30920054,30918255:papier:4230:30920130,30918257:papier:4230:30920202,30918259:papier:4230:30920279,30918261:papier:4230:30920385,30918263:papier:4230:30920426,30918265:papier:4230:30920494,30918267:papier:4230:30920535,30918269:papier:4230:30921343,30918614:papier:4230:30920730,30918923:papier:4230:30920803,30923839:papier:4230:30925071,30923842:papier:4230:30925106,30923845:papier:4230:30925196,30923848:papier:4230:30925269,30923851:papier:4230:30925373,30923854:papier:4230:30925413,30923857:papier:4230:30925493,30923860:papier:4230:30925564,30923863:papier:4230:30925673,30923866:papier:4230:30925715,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0065984801188874575, 'nb_photo': 4291, 'list_port_cont': '30919091,30919201,30919239,30919301,30919421,30919533,30919647,30919680,30919748,30919829,30919906,30919977,30920050,30920127,30920196,30920275,30920381,30920425,30920723,30920801,30920952,30921348,30925080,30925116,30925194,30925260,30925366,30925416,30925491,30925569,30925678,30925713,30925818,30925894,30925935,30925967,30926012,30926048,30926085,30926123,30926147,30926191,30926306,30926387,30926921,30926968,30930167,30930198,30930247,30930281,30930317,30930358,30930385,30930427,30930465,30930496,30930535,30930576,30930618,30930648,30930683,30930725,30930762,30930801,30930834,30930866,30930910,30930949,30930987,30931842,30931922,30932002,30932244,30932509,30932581,30932619,30932772,30932902,30933143,30933282,30933417,30933514,30933773,30933817,30933933,30934021,30934208,30934336,30934473,30934556,30934725,30934821,30935627,30935705,30938890,30939835,30939869,30939910,30939980,30940023,30940092,30940197,30940280,30940345,30940427,30940507,30940832,30940872,30940949,30941019,30941101,30941582,30941690,3094517', 'assoc_port': '30918213:30919091,30918216:30919201,30918219:30919239,30918222:30919301,30918225:30920952,30918228:30919421,30918231:30919533,30918234:30919647,30918237:30919680,30918240:30919748,30918243:30919829,30918246:30919906,30918249:30919977,30918252:30920050,30918255:30920127,30918257:30920196,30918259:30920275,30918261:30920381,30918263:30920425,30918269:30921348,30918614:30920723,30918923:30920801,30923839:30925080,30923842:30925116,30923845:30925194,30923848:30925260,30923851:30925366,30923854:30925416,30923857:30925491,30923860:30925569,30923863:30925678,30923866:30925713,30923869:30925818,30923872:30925894,30923875:30925935,30923878:30925967,30923881:30926921,30923883:30926048,30923885:30926147,30923887:30926012,30923889:30926085,30923891:30926968,30923893:30926123,30923894:30926191,30924275:30926306,30924729:30926387,30929372:30930167,30929374:30930198,30929377:30930247,30929379:30930281,30929381:30930317,30929383:30930358,30929385:30930385,30929386:30930427,30929389:30930465,30929391:30930496,30929392:3093053', 'assoc_mat': '30918213:pehd:4230:30919091,30918216:pehd:4230:30919201,30918219:pehd:4230:30919239,30918222:pehd:4230:30919301,30918225:pehd:4230:30920952,30918228:pehd:4230:30919421,30918231:pehd:4230:30919533,30918234:pehd:4230:30919647,30918237:pehd:4230:30919680,30918240:pehd:4230:30919748,30918243:pehd:4230:30919829,30918246:pehd:4230:30919906,30918249:pehd:4230:30919977,30918252:pehd:4230:30920050,30918255:pehd:4230:30920127,30918257:pehd:4230:30920196,30918259:pehd:4230:30920275,30918261:pehd:4230:30920381,30918263:pehd:4230:30920425,30918269:pehd:4230:30921348,30918614:pehd:4230:30920723,30918923:pehd:4230:30920801,30923839:pehd:4230:30925080,30923842:pehd:4230:30925116,30923845:pehd:4230:30925194,30923848:pehd:4230:30925260,30923851:pehd:4230:30925366,30923854:pehd:4230:30925416,30923857:pehd:4230:30925491,30923860:pehd:4230:30925569,30923863:pehd:4230:30925678,30923866:pehd:4230:30925713,30923869:pehd:4230:30925818,30923872:pehd:4230:30925894,30923875:pehd:4230:30925935,30923878:pehd:4230:30925967,30923881:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01130668890810181, 'nb_photo': 21107, 'list_port_cont': '30919089,30919199,30919237,30919310,30919428,30919538,30919645,30919671,30919757,30919833,30919899,30919984,30920047,30920126,30920204,30920276,30920387,30920417,30920499,30920534,30920731,30920795,30920950,30921337,30925075,30925113,30925189,30925268,30925368,30925417,30925488,30925557,30925671,30925701,30925815,30925897,30925931,30925969,30926009,30926051,30926081,30926122,30926155,30926188,30926304,30926374,30926915,30926966,30930160,30930211,30930242,30930278,30930312,30930343,30930390,30930426,30930456,30930498,30930539,30930579,30930610,30930651,30930689,30930717,30930755,30930802,30930832,30930870,30930907,30930945,30930988,30931845,30931921,30932000,30932247,30932499,30932583,30932610,30932774,30932904,30933132,30933281,30933424,30933510,30933772,30933812,30933934,30934030,30934204,30934342,30934466,30934563,30934713,30934833,30935638,30935707,30938891,30939843,30939871,30939907,30939948,30939979,30940010,30940091,30940207,30940273,30940353,30940432,30940493,30940579,30940653,30940690,30940843,3094087', 'assoc_port': '30918213:30919089,30918216:30919199,30918219:30919237,30918222:30919310,30918225:30920950,30918228:30919428,30918231:30919538,30918234:30919645,30918237:30919671,30918240:30919757,30918243:30919833,30918246:30919899,30918249:30919984,30918252:30920047,30918255:30920126,30918257:30920204,30918259:30920276,30918261:30920387,30918263:30920417,30918265:30920499,30918267:30920534,30918269:30921337,30918614:30920731,30918923:30920795,30923839:30925075,30923842:30925113,30923845:30925189,30923848:30925268,30923851:30925368,30923854:30925417,30923857:30925488,30923860:30925557,30923863:30925671,30923866:30925701,30923869:30925815,30923872:30925897,30923875:30925931,30923878:30925969,30923881:30926915,30923883:30926051,30923885:30926155,30923887:30926009,30923889:30926081,30923891:30926966,30923893:30926122,30923894:30926188,30924275:30926304,30924729:30926374,30929372:30930160,30929374:30930211,30929377:30930242,30929379:30930278,30929381:30930312,30929383:30930343,30929385:30930390,30929386:30930426,30929389:3093045', 'assoc_mat': '30918213:pet_clair:4230:30919089,30918216:pet_clair:4230:30919199,30918219:pet_clair:4230:30919237,30918222:pet_clair:4230:30919310,30918225:pet_clair:4230:30920950,30918228:pet_clair:4230:30919428,30918231:pet_clair:4230:30919538,30918234:pet_clair:4230:30919645,30918237:pet_clair:4230:30919671,30918240:pet_clair:4230:30919757,30918243:pet_clair:4230:30919833,30918246:pet_clair:4230:30919899,30918249:pet_clair:4230:30919984,30918252:pet_clair:4230:30920047,30918255:pet_clair:4230:30920126,30918257:pet_clair:4230:30920204,30918259:pet_clair:4230:30920276,30918261:pet_clair:4230:30920387,30918263:pet_clair:4230:30920417,30918265:pet_clair:4230:30920499,30918267:pet_clair:4230:30920534,30918269:pet_clair:4230:30921337,30918614:pet_clair:4230:30920731,30918923:pet_clair:4230:30920795,30923839:pet_clair:4230:30925075,30923842:pet_clair:4230:30925113,30923845:pet_clair:4230:30925189,30923848:pet_clair:4230:30925268,30923851:pet_clair:4230:30925368,30923854:pet_clair:4230:30925417,30923857:pet_clair:4230:30925488,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005135514422327376, 'nb_photo': 1580, 'list_port_cont': '30919191,30919231,30919309,30919425,30919534,30919641,30919685,30919745,30919822,30919905,30919983,30920051,30920128,30920192,30920269,30920386,30920415,30920488,30920537,30920796,30920937,30921347,30925077,30925118,30925193,30925258,30925376,30925411,30925494,30925568,30925669,30925703,30925823,30925887,30925940,30925973,30926011,30926044,30926083,30926114,30926159,30926190,30926300,30926385,30926928,30926962,30930173,30930207,30930236,30930280,30930314,30930357,30930393,30930421,30930460,30930497,30930537,30930575,30930613,30930652,30930690,30930750,30930911,30930942,30930994,30931837,30931925,30931997,30932240,30932504,30932579,30932621,30932778,30932905,30933136,30933285,30933414,30933512,30933775,30933803,30933939,30934024,30934205,30934341,30934553,30934718,30934835,30935630,30935712,30939837,30939906,30939942,30939978,30940018,30940099,30940203,30940282,30940356,30940426,30940494,30940647,30940692,30940833,30940878,30940948,30941025,30941687,30945579,30945647,30945869,30946499,30951058,30951283,3095135', 'assoc_port': '30918216:30919191,30918219:30919231,30918222:30919309,30918225:30920937,30918228:30919425,30918231:30919534,30918234:30919641,30918237:30919685,30918240:30919745,30918243:30919822,30918246:30919905,30918249:30919983,30918252:30920051,30918255:30920128,30918257:30920192,30918259:30920269,30918261:30920386,30918263:30920415,30918265:30920488,30918267:30920537,30918269:30921347,30918923:30920796,30923839:30925077,30923842:30925118,30923845:30925193,30923848:30925258,30923851:30925376,30923854:30925411,30923857:30925494,30923860:30925568,30923863:30925669,30923866:30925703,30923869:30925823,30923872:30925887,30923875:30925940,30923878:30925973,30923881:30926928,30923883:30926044,30923885:30926159,30923887:30926011,30923889:30926083,30923891:30926962,30923893:30926114,30923894:30926190,30924275:30926300,30924729:30926385,30929372:30930173,30929374:30930207,30929377:30930236,30929379:30930280,30929381:30930314,30929383:30930357,30929385:30930393,30929386:30930421,30929389:30930460,30929391:30930497,30929392:3093053', 'assoc_mat': '30918216:pet_fonce:4230:30919191,30918219:pet_fonce:4230:30919231,30918222:pet_fonce:4230:30919309,30918225:pet_fonce:4230:30920937,30918228:pet_fonce:4230:30919425,30918231:pet_fonce:4230:30919534,30918234:pet_fonce:4230:30919641,30918237:pet_fonce:4230:30919685,30918240:pet_fonce:4230:30919745,30918243:pet_fonce:4230:30919822,30918246:pet_fonce:4230:30919905,30918249:pet_fonce:4230:30919983,30918252:pet_fonce:4230:30920051,30918255:pet_fonce:4230:30920128,30918257:pet_fonce:4230:30920192,30918259:pet_fonce:4230:30920269,30918261:pet_fonce:4230:30920386,30918263:pet_fonce:4230:30920415,30918265:pet_fonce:4230:30920488,30918267:pet_fonce:4230:30920537,30918269:pet_fonce:4230:30921347,30918923:pet_fonce:4230:30920796,30923839:pet_fonce:4230:30925077,30923842:pet_fonce:4230:30925118,30923845:pet_fonce:4230:30925193,30923848:pet_fonce:4230:30925258,30923851:pet_fonce:4230:30925376,30923854:pet_fonce:4230:30925411,30923857:pet_fonce:4230:30925494,30923860:pet_fonce:4230:30925568,30923863:pet_fonce:4230:30925669,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(2972770,2973449,2974045,2974638,2975093,2975656,2976329,2976995,2977611,2977794,2978150,2978634,2979190,2979816,2980456,2981066,2981298,2981734,2982020,2982468,2982876,2983336,2983886,2984368,2984782,2984978)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998258, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919090,30919198,30919228,30919311,30919414,30919537,30919643,30919670,30919755,30919832,30919902,30919967,30920055,30920114,30920205,30920277,30920377,30920420,30920498,30920531,30920727,30920793,30920941,30921336,30925069,30925104,30925180,30925264,30925363,30925404,30925481,30925558,30925668,30925712,30925816,30925885,30925926,30925970,30926013,30926034,30926084,30926124,30926157,30926189,30926291,30926383,30926926,30926955,30930172,30930200,30930237,30930268,30930319,30930349,30930394,30930416,30930455,30930501,30930543,30930573,30930616,30930649,30930681,30930719,30930747,30930793,30930822,30930865,30930900,30930932,30930985,30931839,30931926,30931996,30932237,30932510,30932580,30932620,30932767,30932900,30933142,30933273,30933421,30933505,30933765,30933806,30933935,30934029,30934201,30934340,30934461,30934564,30934715,30934829,30935632,30935698,30938894,30939828,30939862,30939898,30939945,30939973,30940014,30940086,30940191,30940278,30940357,30940433,30940500,30940577,30940641,30940685,30940844,3094087 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998259, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919088,30919196,30919238,30919313,30919423,30919529,30919637,30919677,30919752,30919834,30919908,30919980,30920045,30920131,30920198,30920278,30920382,30920422,30920492,30920533,30920728,30920802,30920949,30921350,30925082,30925117,30925181,30925259,30925380,30925408,30925484,30925566,30925667,30925711,30925821,30925889,30925939,30925975,30926001,30926047,30926087,30926115,30926156,30926196,30926308,30926377,30926923,30926964,30930163,30930208,30930240,30930279,30930315,30930348,30930392,30930428,30930463,30930503,30930528,30930581,30930612,30930653,30930676,30930721,30930764,30930800,30930829,30930859,30930904,30930940,30930991,30931848,30931915,30931994,30932243,30932503,30932582,30932624,30932779,30932891,30933145,30933283,30933427,30933506,30933776,30933813,30933929,30934034,30934214,30934339,30934469,30934562,30934723,30934825,30935636,30935704,30938887,30939841,30939878,30939914,30939940,30939977,30940024,30940095,30940205,30940277,30940355,30940425,30940505,30940570,30940643,30940689,30940840,3094086 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998260, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919084,30919195,30919224,30919312,30919426,30919522,30919646,30919678,30919758,30919824,30919896,30919982,30920056,30920121,30920194,30920273,30920376,30920414,30920496,30920523,30920714,30920799,30920948,30921340,30925066,30925111,30925184,30925261,30925377,30925414,30925485,30925567,30925679,30925702,30925822,30925892,30925937,30925974,30926004,30926049,30926079,30926121,30926307,30926372,30926927,30926960,30930170,30930205,30930245,30930269,30930316,30930341,30930387,30930432,30930457,30930492,30930538,30930582,30930609,30930646,30930678,30930724,30930763,30930803,30930835,30930867,30930896,30930936,30930982,30931850,30931914,30931993,30932234,30932501,30932572,30932609,30932766,30933144,30933275,30933419,30933509,30933761,30933802,30933932,30934033,30934197,30934343,30934727,30935635,30939829,30939943,30940017,30940200,30940274,30940416,30940506,30940654,30940691,30940837,30940866,30940943,30941014,30941088,30941419,30941565,30945166,30945199,30945270,30945339,30945428,30945492,30945575,30945644,3094571 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998261, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919092,30919197,30919227,30919304,30919422,30919532,30919642,30919682,30919754,30919831,30919904,30919979,30920054,30920130,30920202,30920279,30920385,30920426,30920494,30920535,30920730,30920803,30920944,30921343,30925071,30925106,30925196,30925269,30925373,30925413,30925493,30925564,30925673,30925715,30925824,30925899,30925938,30925971,30926010,30926050,30926086,30926119,30926160,30926193,30926305,30926388,30926920,30926957,30930169,30930206,30930244,30930275,30930306,30930356,30930386,30930431,30930464,30930504,30930541,30930571,30930608,30930644,30930684,30930726,30930757,30930791,30930837,30930874,30930906,30930946,30930992,30931840,30931924,30931995,30932246,30932508,30932576,30932622,30932775,30932899,30933137,30933278,30933425,30933516,30933770,30933815,30933940,30934026,30934200,30934329,30934464,30934557,30934717,30934831,30935637,30935708,30938892,30939838,30939875,30939911,30939939,30939981,30940015,30940098,30940208,30940281,30940354,30940430,30940504,30940574,30940645,30940686,30940836,3094087 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998263, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919091,30919201,30919239,30919301,30919421,30919533,30919647,30919680,30919748,30919829,30919906,30919977,30920050,30920127,30920196,30920275,30920381,30920425,30920723,30920801,30920952,30921348,30925080,30925116,30925194,30925260,30925366,30925416,30925491,30925569,30925678,30925713,30925818,30925894,30925935,30925967,30926012,30926048,30926085,30926123,30926147,30926191,30926306,30926387,30926921,30926968,30930167,30930198,30930247,30930281,30930317,30930358,30930385,30930427,30930465,30930496,30930535,30930576,30930618,30930648,30930683,30930725,30930762,30930801,30930834,30930866,30930910,30930949,30930987,30931842,30931922,30932002,30932244,30932509,30932581,30932619,30932772,30932902,30933143,30933282,30933417,30933514,30933773,30933817,30933933,30934021,30934208,30934336,30934473,30934556,30934725,30934821,30935627,30935705,30938890,30939835,30939869,30939910,30939980,30940023,30940092,30940197,30940280,30940345,30940427,30940507,30940832,30940872,30940949,30941019,30941101,30941582,30941690,3094517 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998264, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919089,30919199,30919237,30919310,30919428,30919538,30919645,30919671,30919757,30919833,30919899,30919984,30920047,30920126,30920204,30920276,30920387,30920417,30920499,30920534,30920731,30920795,30920950,30921337,30925075,30925113,30925189,30925268,30925368,30925417,30925488,30925557,30925671,30925701,30925815,30925897,30925931,30925969,30926009,30926051,30926081,30926122,30926155,30926188,30926304,30926374,30926915,30926966,30930160,30930211,30930242,30930278,30930312,30930343,30930390,30930426,30930456,30930498,30930539,30930579,30930610,30930651,30930689,30930717,30930755,30930802,30930832,30930870,30930907,30930945,30930988,30931845,30931921,30932000,30932247,30932499,30932583,30932610,30932774,30932904,30933132,30933281,30933424,30933510,30933772,30933812,30933934,30934030,30934204,30934342,30934466,30934563,30934713,30934833,30935638,30935707,30938891,30939843,30939871,30939907,30939948,30939979,30940010,30940091,30940207,30940273,30940353,30940432,30940493,30940579,30940653,30940690,30940843,3094087 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998265, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30919191,30919231,30919309,30919425,30919534,30919641,30919685,30919745,30919822,30919905,30919983,30920051,30920128,30920192,30920269,30920386,30920415,30920488,30920537,30920796,30920937,30921347,30925077,30925118,30925193,30925258,30925376,30925411,30925494,30925568,30925669,30925703,30925823,30925887,30925940,30925973,30926011,30926044,30926083,30926114,30926159,30926190,30926300,30926385,30926928,30926962,30930173,30930207,30930236,30930280,30930314,30930357,30930393,30930421,30930460,30930497,30930537,30930575,30930613,30930652,30930690,30930750,30930911,30930942,30930994,30931837,30931925,30931997,30932240,30932504,30932579,30932621,30932778,30932905,30933136,30933285,30933414,30933512,30933775,30933803,30933939,30934024,30934205,30934341,30934553,30934718,30934835,30935630,30935712,30939837,30939906,30939942,30939978,30940018,30940099,30940203,30940282,30940356,30940426,30940494,30940647,30940692,30940833,30940878,30940948,30941025,30941687,30945579,30945647,30945869,30946499,30951058,30951283,3095135 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30998258,30998259,30998260,30998261,30998263,30998264,30998265?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-04-01' and date <= '2026-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1560,),), 'unwanted_material_monthly_percentage': ((0.5859191724248235,),), 'material_repartition': (('incineration', 1554),), 'material_dict': {'incineration': 1554}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 4, 1), 0.5018778057282319, 4), (datetime.date(2026, 4, 2), 0.49290614125602283, 3), (datetime.date(2026, 4, 3), 0.475401339098257, 4), (datetime.date(2026, 4, 4), 0.4834500951520462, 3), (datetime.date(2026, 4, 5), 0.7108950715113861, 4), (datetime.date(2026, 4, 6), 0.773769468543086, 4), (datetime.date(2026, 4, 7), 0.7811732770279853, 4), (datetime.date(2026, 4, 8), 0.7324838658187119, 3), (datetime.date(2026, 4, 9), 0.6054957404491326, 3), (datetime.date(2026, 4, 10), 0.514574385507816, 4), (datetime.date(2026, 4, 11), 0.4580222464310797, 2), (datetime.date(2026, 4, 12), 0.47558480995958086, 1), (datetime.date(2026, 4, 13), 0.4979648734311427, 2), (datetime.date(2026, 4, 14), 0.5313000047106647, 3), (datetime.date(2026, 4, 15), 0.576209489125348, 2), (datetime.date(2026, 4, 16), 0.535071933801229, 4), (datetime.date(2026, 4, 17), 0.5498982476933619, 1), (datetime.date(2026, 4, 18), 0.5839777097205224, 3), (datetime.date(2026, 4, 19), 0.6545491282370174, 3), (datetime.date(2026, 4, 20), 0.7336301699225193, 3), (datetime.date(2026, 4, 21), 0.792197289547998, 1), (datetime.date(2026, 4, 22), 0.6706721833472276, 2), (datetime.date(2026, 4, 23), 0.5654189620015336, 3), (datetime.date(2026, 4, 24), 0.5107156900135217, 2), (datetime.date(2026, 4, 25), 0.4759869473127213, 4), (datetime.date(2026, 4, 26), 0.47662206837888754, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 4, 1), 0.5018778057282319, 4), (datetime.date(2026, 4, 2), 0.49290614125602283, 3), (datetime.date(2026, 4, 3), 0.475401339098257, 4), (datetime.date(2026, 4, 4), 0.4834500951520462, 3), (datetime.date(2026, 4, 5), 0.7108950715113861, 4), (datetime.date(2026, 4, 6), 0.773769468543086, 4), (datetime.date(2026, 4, 7), 0.7811732770279853, 4), (datetime.date(2026, 4, 8), 0.7324838658187119, 3), (datetime.date(2026, 4, 9), 0.6054957404491326, 3), (datetime.date(2026, 4, 10), 0.514574385507816, 4), (datetime.date(2026, 4, 11), 0.4580222464310797, 2), (datetime.date(2026, 4, 12), 0.47558480995958086, 1), (datetime.date(2026, 4, 13), 0.4979648734311427, 2), (datetime.date(2026, 4, 14), 0.5313000047106647, 3), (datetime.date(2026, 4, 15), 0.576209489125348, 2), (datetime.date(2026, 4, 16), 0.535071933801229, 4), (datetime.date(2026, 4, 17), 0.5498982476933619, 1), (datetime.date(2026, 4, 18), 0.5839777097205224, 3), (datetime.date(2026, 4, 19), 0.6545491282370174, 3), (datetime.date(2026, 4, 20), 0.7336301699225193, 3), (datetime.date(2026, 4, 21), 0.792197289547998, 1), (datetime.date(2026, 4, 22), 0.6706721833472276, 2), (datetime.date(2026, 4, 23), 0.5654189620015336, 3), (datetime.date(2026, 4, 24), 0.5107156900135217, 2), (datetime.date(2026, 4, 25), 0.4759869473127213, 4), (datetime.date(2026, 4, 26), 0.47662206837888754, 2))}, 'quality_array': [['-7.854566651000625', '01042026'], ['-7.647920877442716', '02042026'], ['-7.721492312514128', '03042026'], ['-8.61609851870657', '04042026'], ['-8.643346703122758', '05042026'], ['-8.396409414931753', '06042026'], ['-7.794710685460984', '07042026'], ['-7.498398285305459', '08042026'], ['-7.939191817342551', '09042026'], ['-8.92860312125933', '10042026'], ['-8.91286966865884', '11042026'], ['-8.685137439778499', '12042026'], ['-8.414608335416574', '13042026'], ['-8.599415374865726', '14042026'], ['-8.67465138176147', '15042026'], ['-8.446300984318857', '16042026'], ['-8.855519572908369', '17042026'], ['-8.807584230429963', '18042026'], ['-8.854660360896904', '19042026'], ['-8.295533421914419', '20042026'], ['-7.755305867976193', '21042026'], ['-7.665061401833666', '22042026'], ['-8.037048724882721', '23042026'], ['-8.433261086276334', '24042026'], ['-8.343685813761393', '25042026'], ['-8.17739867407949', '26042026']], 'number_of_batch': ((577,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02141778841964629, 'nb_photo': 20113, 'list_port_cont': '30919090,30919198,30919228,30919311,30919414,30919537,30919643,30919670,30919755,30919832,30919902,30919967,30920055,30920114,30920205,30920277,30920377,30920420,30920498,30920531,30920727,30920793,30920941,30921336,30925069,30925104,30925180,30925264,30925363,30925404,30925481,30925558,30925668,30925712,30925816,30925885,30925926,30925970,30926013,30926034,30926084,30926124,30926157,30926189,30926291,30926383,30926926,30926955,30930172,30930200,30930237,30930268,30930319,30930349,30930394,30930416,30930455,30930501,30930543,30930573,30930616,30930649,30930681,30930719,30930747,30930793,30930822,30930865,30930900,30930932,30930985,30931839,30931926,30931996,30932237,30932510,30932580,30932620,30932767,30932900,30933142,30933273,30933421,30933505,30933765,30933806,30933935,30934029,30934201,30934340,30934461,30934564,30934715,30934829,30935632,30935698,30938894,30939828,30939862,30939898,30939945,30939973,30940014,30940086,30940191,30940278,30940357,30940433,30940500,30940577,30940641,30940685,30940844,3094087', 'assoc_port': '30918213:30919090,30918216:30919198,30918219:30919228,30918222:30919311,30918225:30920941,30918228:30919414,30918231:30919537,30918234:30919643,30918237:30919670,30918240:30919755,30918243:30919832,30918246:30919902,30918249:30919967,30918252:30920055,30918255:30920114,30918257:30920205,30918259:30920277,30918261:30920377,30918263:30920420,30918265:30920498,30918267:30920531,30918269:30921336,30918614:30920727,30918923:30920793,30923839:30925069,30923842:30925104,30923845:30925180,30923848:30925264,30923851:30925363,30923854:30925404,30923857:30925481,30923860:30925558,30923863:30925668,30923866:30925712,30923869:30925816,30923872:30925885,30923875:30925926,30923878:30925970,30923881:30926926,30923883:30926034,30923885:30926157,30923887:30926013,30923889:30926084,30923891:30926955,30923893:30926124,30923894:30926189,30924275:30926291,30924729:30926383,30929372:30930172,30929374:30930200,30929377:30930237,30929379:30930268,30929381:30930319,30929383:30930349,30929385:30930394,30929386:30930416,30929389:3093045', 'assoc_mat': '30918213:autre:4230:30919090,30918216:autre:4230:30919198,30918219:autre:4230:30919228,30918222:autre:4230:30919311,30918225:autre:4230:30920941,30918228:autre:4230:30919414,30918231:autre:4230:30919537,30918234:autre:4230:30919643,30918237:autre:4230:30919670,30918240:autre:4230:30919755,30918243:autre:4230:30919832,30918246:autre:4230:30919902,30918249:autre:4230:30919967,30918252:autre:4230:30920055,30918255:autre:4230:30920114,30918257:autre:4230:30920205,30918259:autre:4230:30920277,30918261:autre:4230:30920377,30918263:autre:4230:30920420,30918265:autre:4230:30920498,30918267:autre:4230:30920531,30918269:autre:4230:30921336,30918614:autre:4230:30920727,30918923:autre:4230:30920793,30923839:autre:4230:30925069,30923842:autre:4230:30925104,30923845:autre:4230:30925180,30923848:autre:4230:30925264,30923851:autre:4230:30925363,30923854:autre:4230:30925404,30923857:autre:4230:30925481,30923860:autre:4230:30925558,30923863:autre:4230:30925668,30923866:autre:4230:30925712,30923869:autre:4230:30925816,30923872:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0867916440219037, 'nb_photo': 99901, 'list_port_cont': '30919088,30919196,30919238,30919313,30919423,30919529,30919637,30919677,30919752,30919834,30919908,30919980,30920045,30920131,30920198,30920278,30920382,30920422,30920492,30920533,30920728,30920802,30920949,30921350,30925082,30925117,30925181,30925259,30925380,30925408,30925484,30925566,30925667,30925711,30925821,30925889,30925939,30925975,30926001,30926047,30926087,30926115,30926156,30926196,30926308,30926377,30926923,30926964,30930163,30930208,30930240,30930279,30930315,30930348,30930392,30930428,30930463,30930503,30930528,30930581,30930612,30930653,30930676,30930721,30930764,30930800,30930829,30930859,30930904,30930940,30930991,30931848,30931915,30931994,30932243,30932503,30932582,30932624,30932779,30932891,30933145,30933283,30933427,30933506,30933776,30933813,30933929,30934034,30934214,30934339,30934469,30934562,30934723,30934825,30935636,30935704,30938887,30939841,30939878,30939914,30939940,30939977,30940024,30940095,30940205,30940277,30940355,30940425,30940505,30940570,30940643,30940689,30940840,3094086', 'assoc_port': '30918213:30919088,30918216:30919196,30918219:30919238,30918222:30919313,30918225:30920949,30918228:30919423,30918231:30919529,30918234:30919637,30918237:30919677,30918240:30919752,30918243:30919834,30918246:30919908,30918249:30919980,30918252:30920045,30918255:30920131,30918257:30920198,30918259:30920278,30918261:30920382,30918263:30920422,30918265:30920492,30918267:30920533,30918269:30921350,30918614:30920728,30918923:30920802,30923839:30925082,30923842:30925117,30923845:30925181,30923848:30925259,30923851:30925380,30923854:30925408,30923857:30925484,30923860:30925566,30923863:30925667,30923866:30925711,30923869:30925821,30923872:30925889,30923875:30925939,30923878:30925975,30923881:30926923,30923883:30926047,30923885:30926156,30923887:30926001,30923889:30926087,30923891:30926964,30923893:30926115,30923894:30926196,30924275:30926308,30924729:30926377,30929372:30930163,30929374:30930208,30929377:30930240,30929379:30930279,30929381:30930315,30929383:30930348,30929385:30930392,30929386:30930428,30929389:3093046', 'assoc_mat': '30918213:carton:4230:30919088,30918216:carton:4230:30919196,30918219:carton:4230:30919238,30918222:carton:4230:30919313,30918225:carton:4230:30920949,30918228:carton:4230:30919423,30918231:carton:4230:30919529,30918234:carton:4230:30919637,30918237:carton:4230:30919677,30918240:carton:4230:30919752,30918243:carton:4230:30919834,30918246:carton:4230:30919908,30918249:carton:4230:30919980,30918252:carton:4230:30920045,30918255:carton:4230:30920131,30918257:carton:4230:30920198,30918259:carton:4230:30920278,30918261:carton:4230:30920382,30918263:carton:4230:30920422,30918265:carton:4230:30920492,30918267:carton:4230:30920533,30918269:carton:4230:30921350,30918614:carton:4230:30920728,30918923:carton:4230:30920802,30923839:carton:4230:30925082,30923842:carton:4230:30925117,30923845:carton:4230:30925181,30923848:carton:4230:30925259,30923851:carton:4230:30925380,30923854:carton:4230:30925408,30923857:carton:4230:30925484,30923860:carton:4230:30925566,30923863:carton:4230:30925667,30923866:carton:4230:30925711,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018313742914263698, 'nb_photo': 1819, 'list_port_cont': '30919084,30919195,30919224,30919312,30919426,30919522,30919646,30919678,30919758,30919824,30919896,30919982,30920056,30920121,30920194,30920273,30920376,30920414,30920496,30920523,30920714,30920799,30920948,30921340,30925066,30925111,30925184,30925261,30925377,30925414,30925485,30925567,30925679,30925702,30925822,30925892,30925937,30925974,30926004,30926049,30926079,30926121,30926307,30926372,30926927,30926960,30930170,30930205,30930245,30930269,30930316,30930341,30930387,30930432,30930457,30930492,30930538,30930582,30930609,30930646,30930678,30930724,30930763,30930803,30930835,30930867,30930896,30930936,30930982,30931850,30931914,30931993,30932234,30932501,30932572,30932609,30932766,30933144,30933275,30933419,30933509,30933761,30933802,30933932,30934033,30934197,30934343,30934727,30935635,30939829,30939943,30940017,30940200,30940274,30940416,30940506,30940654,30940691,30940837,30940866,30940943,30941014,30941088,30941419,30941565,30945166,30945199,30945270,30945339,30945428,30945492,30945575,30945644,3094571', 'assoc_port': '30918213:30919084,30918216:30919195,30918219:30919224,30918222:30919312,30918225:30920948,30918228:30919426,30918231:30919522,30918234:30919646,30918237:30919678,30918240:30919758,30918243:30919824,30918246:30919896,30918249:30919982,30918252:30920056,30918255:30920121,30918257:30920194,30918259:30920273,30918261:30920376,30918263:30920414,30918265:30920496,30918267:30920523,30918269:30921340,30918614:30920714,30918923:30920799,30923839:30925066,30923842:30925111,30923845:30925184,30923848:30925261,30923851:30925377,30923854:30925414,30923857:30925485,30923860:30925567,30923863:30925679,30923866:30925702,30923869:30925822,30923872:30925892,30923875:30925937,30923878:30925974,30923881:30926927,30923883:30926049,30923887:30926004,30923889:30926079,30923891:30926960,30923893:30926121,30924275:30926307,30924729:30926372,30929372:30930170,30929374:30930205,30929377:30930245,30929379:30930269,30929381:30930316,30929383:30930341,30929385:30930387,30929386:30930432,30929389:30930457,30929391:30930492,30929392:3093053', 'assoc_mat': '30918213:metal:4230:30919084,30918216:metal:4230:30919195,30918219:metal:4230:30919224,30918222:metal:4230:30919312,30918225:metal:4230:30920948,30918228:metal:4230:30919426,30918231:metal:4230:30919522,30918234:metal:4230:30919646,30918237:metal:4230:30919678,30918240:metal:4230:30919758,30918243:metal:4230:30919824,30918246:metal:4230:30919896,30918249:metal:4230:30919982,30918252:metal:4230:30920056,30918255:metal:4230:30920121,30918257:metal:4230:30920194,30918259:metal:4230:30920273,30918261:metal:4230:30920376,30918263:metal:4230:30920414,30918265:metal:4230:30920496,30918267:metal:4230:30920523,30918269:metal:4230:30921340,30918614:metal:4230:30920714,30918923:metal:4230:30920799,30923839:metal:4230:30925066,30923842:metal:4230:30925111,30923845:metal:4230:30925184,30923848:metal:4230:30925261,30923851:metal:4230:30925377,30923854:metal:4230:30925414,30923857:metal:4230:30925485,30923860:metal:4230:30925567,30923863:metal:4230:30925679,30923866:metal:4230:30925702,30923869:metal:4230:30925822,30923872:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3184084051365039, 'nb_photo': 333250, 'list_port_cont': '30919092,30919197,30919227,30919304,30919422,30919532,30919642,30919682,30919754,30919831,30919904,30919979,30920054,30920130,30920202,30920279,30920385,30920426,30920494,30920535,30920730,30920803,30920944,30921343,30925071,30925106,30925196,30925269,30925373,30925413,30925493,30925564,30925673,30925715,30925824,30925899,30925938,30925971,30926010,30926050,30926086,30926119,30926160,30926193,30926305,30926388,30926920,30926957,30930169,30930206,30930244,30930275,30930306,30930356,30930386,30930431,30930464,30930504,30930541,30930571,30930608,30930644,30930684,30930726,30930757,30930791,30930837,30930874,30930906,30930946,30930992,30931840,30931924,30931995,30932246,30932508,30932576,30932622,30932775,30932899,30933137,30933278,30933425,30933516,30933770,30933815,30933940,30934026,30934200,30934329,30934464,30934557,30934717,30934831,30935637,30935708,30938892,30939838,30939875,30939911,30939939,30939981,30940015,30940098,30940208,30940281,30940354,30940430,30940504,30940574,30940645,30940686,30940836,3094087', 'assoc_port': '30918213:30919092,30918216:30919197,30918219:30919227,30918222:30919304,30918225:30920944,30918228:30919422,30918231:30919532,30918234:30919642,30918237:30919682,30918240:30919754,30918243:30919831,30918246:30919904,30918249:30919979,30918252:30920054,30918255:30920130,30918257:30920202,30918259:30920279,30918261:30920385,30918263:30920426,30918265:30920494,30918267:30920535,30918269:30921343,30918614:30920730,30918923:30920803,30923839:30925071,30923842:30925106,30923845:30925196,30923848:30925269,30923851:30925373,30923854:30925413,30923857:30925493,30923860:30925564,30923863:30925673,30923866:30925715,30923869:30925824,30923872:30925899,30923875:30925938,30923878:30925971,30923881:30926920,30923883:30926050,30923885:30926160,30923887:30926010,30923889:30926086,30923891:30926957,30923893:30926119,30923894:30926193,30924275:30926305,30924729:30926388,30929372:30930169,30929374:30930206,30929377:30930244,30929379:30930275,30929381:30930306,30929383:30930356,30929385:30930386,30929386:30930431,30929389:3093046', 'assoc_mat': '30918213:papier:4230:30919092,30918216:papier:4230:30919197,30918219:papier:4230:30919227,30918222:papier:4230:30919304,30918225:papier:4230:30920944,30918228:papier:4230:30919422,30918231:papier:4230:30919532,30918234:papier:4230:30919642,30918237:papier:4230:30919682,30918240:papier:4230:30919754,30918243:papier:4230:30919831,30918246:papier:4230:30919904,30918249:papier:4230:30919979,30918252:papier:4230:30920054,30918255:papier:4230:30920130,30918257:papier:4230:30920202,30918259:papier:4230:30920279,30918261:papier:4230:30920385,30918263:papier:4230:30920426,30918265:papier:4230:30920494,30918267:papier:4230:30920535,30918269:papier:4230:30921343,30918614:papier:4230:30920730,30918923:papier:4230:30920803,30923839:papier:4230:30925071,30923842:papier:4230:30925106,30923845:papier:4230:30925196,30923848:papier:4230:30925269,30923851:papier:4230:30925373,30923854:papier:4230:30925413,30923857:papier:4230:30925493,30923860:papier:4230:30925564,30923863:papier:4230:30925673,30923866:papier:4230:30925715,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0065984801188874575, 'nb_photo': 4291, 'list_port_cont': '30919091,30919201,30919239,30919301,30919421,30919533,30919647,30919680,30919748,30919829,30919906,30919977,30920050,30920127,30920196,30920275,30920381,30920425,30920723,30920801,30920952,30921348,30925080,30925116,30925194,30925260,30925366,30925416,30925491,30925569,30925678,30925713,30925818,30925894,30925935,30925967,30926012,30926048,30926085,30926123,30926147,30926191,30926306,30926387,30926921,30926968,30930167,30930198,30930247,30930281,30930317,30930358,30930385,30930427,30930465,30930496,30930535,30930576,30930618,30930648,30930683,30930725,30930762,30930801,30930834,30930866,30930910,30930949,30930987,30931842,30931922,30932002,30932244,30932509,30932581,30932619,30932772,30932902,30933143,30933282,30933417,30933514,30933773,30933817,30933933,30934021,30934208,30934336,30934473,30934556,30934725,30934821,30935627,30935705,30938890,30939835,30939869,30939910,30939980,30940023,30940092,30940197,30940280,30940345,30940427,30940507,30940832,30940872,30940949,30941019,30941101,30941582,30941690,3094517', 'assoc_port': '30918213:30919091,30918216:30919201,30918219:30919239,30918222:30919301,30918225:30920952,30918228:30919421,30918231:30919533,30918234:30919647,30918237:30919680,30918240:30919748,30918243:30919829,30918246:30919906,30918249:30919977,30918252:30920050,30918255:30920127,30918257:30920196,30918259:30920275,30918261:30920381,30918263:30920425,30918269:30921348,30918614:30920723,30918923:30920801,30923839:30925080,30923842:30925116,30923845:30925194,30923848:30925260,30923851:30925366,30923854:30925416,30923857:30925491,30923860:30925569,30923863:30925678,30923866:30925713,30923869:30925818,30923872:30925894,30923875:30925935,30923878:30925967,30923881:30926921,30923883:30926048,30923885:30926147,30923887:30926012,30923889:30926085,30923891:30926968,30923893:30926123,30923894:30926191,30924275:30926306,30924729:30926387,30929372:30930167,30929374:30930198,30929377:30930247,30929379:30930281,30929381:30930317,30929383:30930358,30929385:30930385,30929386:30930427,30929389:30930465,30929391:30930496,30929392:3093053', 'assoc_mat': '30918213:pehd:4230:30919091,30918216:pehd:4230:30919201,30918219:pehd:4230:30919239,30918222:pehd:4230:30919301,30918225:pehd:4230:30920952,30918228:pehd:4230:30919421,30918231:pehd:4230:30919533,30918234:pehd:4230:30919647,30918237:pehd:4230:30919680,30918240:pehd:4230:30919748,30918243:pehd:4230:30919829,30918246:pehd:4230:30919906,30918249:pehd:4230:30919977,30918252:pehd:4230:30920050,30918255:pehd:4230:30920127,30918257:pehd:4230:30920196,30918259:pehd:4230:30920275,30918261:pehd:4230:30920381,30918263:pehd:4230:30920425,30918269:pehd:4230:30921348,30918614:pehd:4230:30920723,30918923:pehd:4230:30920801,30923839:pehd:4230:30925080,30923842:pehd:4230:30925116,30923845:pehd:4230:30925194,30923848:pehd:4230:30925260,30923851:pehd:4230:30925366,30923854:pehd:4230:30925416,30923857:pehd:4230:30925491,30923860:pehd:4230:30925569,30923863:pehd:4230:30925678,30923866:pehd:4230:30925713,30923869:pehd:4230:30925818,30923872:pehd:4230:30925894,30923875:pehd:4230:30925935,30923878:pehd:4230:30925967,30923881:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01130668890810181, 'nb_photo': 21107, 'list_port_cont': '30919089,30919199,30919237,30919310,30919428,30919538,30919645,30919671,30919757,30919833,30919899,30919984,30920047,30920126,30920204,30920276,30920387,30920417,30920499,30920534,30920731,30920795,30920950,30921337,30925075,30925113,30925189,30925268,30925368,30925417,30925488,30925557,30925671,30925701,30925815,30925897,30925931,30925969,30926009,30926051,30926081,30926122,30926155,30926188,30926304,30926374,30926915,30926966,30930160,30930211,30930242,30930278,30930312,30930343,30930390,30930426,30930456,30930498,30930539,30930579,30930610,30930651,30930689,30930717,30930755,30930802,30930832,30930870,30930907,30930945,30930988,30931845,30931921,30932000,30932247,30932499,30932583,30932610,30932774,30932904,30933132,30933281,30933424,30933510,30933772,30933812,30933934,30934030,30934204,30934342,30934466,30934563,30934713,30934833,30935638,30935707,30938891,30939843,30939871,30939907,30939948,30939979,30940010,30940091,30940207,30940273,30940353,30940432,30940493,30940579,30940653,30940690,30940843,3094087', 'assoc_port': '30918213:30919089,30918216:30919199,30918219:30919237,30918222:30919310,30918225:30920950,30918228:30919428,30918231:30919538,30918234:30919645,30918237:30919671,30918240:30919757,30918243:30919833,30918246:30919899,30918249:30919984,30918252:30920047,30918255:30920126,30918257:30920204,30918259:30920276,30918261:30920387,30918263:30920417,30918265:30920499,30918267:30920534,30918269:30921337,30918614:30920731,30918923:30920795,30923839:30925075,30923842:30925113,30923845:30925189,30923848:30925268,30923851:30925368,30923854:30925417,30923857:30925488,30923860:30925557,30923863:30925671,30923866:30925701,30923869:30925815,30923872:30925897,30923875:30925931,30923878:30925969,30923881:30926915,30923883:30926051,30923885:30926155,30923887:30926009,30923889:30926081,30923891:30926966,30923893:30926122,30923894:30926188,30924275:30926304,30924729:30926374,30929372:30930160,30929374:30930211,30929377:30930242,30929379:30930278,30929381:30930312,30929383:30930343,30929385:30930390,30929386:30930426,30929389:3093045', 'assoc_mat': '30918213:pet_clair:4230:30919089,30918216:pet_clair:4230:30919199,30918219:pet_clair:4230:30919237,30918222:pet_clair:4230:30919310,30918225:pet_clair:4230:30920950,30918228:pet_clair:4230:30919428,30918231:pet_clair:4230:30919538,30918234:pet_clair:4230:30919645,30918237:pet_clair:4230:30919671,30918240:pet_clair:4230:30919757,30918243:pet_clair:4230:30919833,30918246:pet_clair:4230:30919899,30918249:pet_clair:4230:30919984,30918252:pet_clair:4230:30920047,30918255:pet_clair:4230:30920126,30918257:pet_clair:4230:30920204,30918259:pet_clair:4230:30920276,30918261:pet_clair:4230:30920387,30918263:pet_clair:4230:30920417,30918265:pet_clair:4230:30920499,30918267:pet_clair:4230:30920534,30918269:pet_clair:4230:30921337,30918614:pet_clair:4230:30920731,30918923:pet_clair:4230:30920795,30923839:pet_clair:4230:30925075,30923842:pet_clair:4230:30925113,30923845:pet_clair:4230:30925189,30923848:pet_clair:4230:30925268,30923851:pet_clair:4230:30925368,30923854:pet_clair:4230:30925417,30923857:pet_clair:4230:30925488,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005135514422327376, 'nb_photo': 1580, 'list_port_cont': '30919191,30919231,30919309,30919425,30919534,30919641,30919685,30919745,30919822,30919905,30919983,30920051,30920128,30920192,30920269,30920386,30920415,30920488,30920537,30920796,30920937,30921347,30925077,30925118,30925193,30925258,30925376,30925411,30925494,30925568,30925669,30925703,30925823,30925887,30925940,30925973,30926011,30926044,30926083,30926114,30926159,30926190,30926300,30926385,30926928,30926962,30930173,30930207,30930236,30930280,30930314,30930357,30930393,30930421,30930460,30930497,30930537,30930575,30930613,30930652,30930690,30930750,30930911,30930942,30930994,30931837,30931925,30931997,30932240,30932504,30932579,30932621,30932778,30932905,30933136,30933285,30933414,30933512,30933775,30933803,30933939,30934024,30934205,30934341,30934553,30934718,30934835,30935630,30935712,30939837,30939906,30939942,30939978,30940018,30940099,30940203,30940282,30940356,30940426,30940494,30940647,30940692,30940833,30940878,30940948,30941025,30941687,30945579,30945647,30945869,30946499,30951058,30951283,3095135', 'assoc_port': '30918216:30919191,30918219:30919231,30918222:30919309,30918225:30920937,30918228:30919425,30918231:30919534,30918234:30919641,30918237:30919685,30918240:30919745,30918243:30919822,30918246:30919905,30918249:30919983,30918252:30920051,30918255:30920128,30918257:30920192,30918259:30920269,30918261:30920386,30918263:30920415,30918265:30920488,30918267:30920537,30918269:30921347,30918923:30920796,30923839:30925077,30923842:30925118,30923845:30925193,30923848:30925258,30923851:30925376,30923854:30925411,30923857:30925494,30923860:30925568,30923863:30925669,30923866:30925703,30923869:30925823,30923872:30925887,30923875:30925940,30923878:30925973,30923881:30926928,30923883:30926044,30923885:30926159,30923887:30926011,30923889:30926083,30923891:30926962,30923893:30926114,30923894:30926190,30924275:30926300,30924729:30926385,30929372:30930173,30929374:30930207,30929377:30930236,30929379:30930280,30929381:30930314,30929383:30930357,30929385:30930393,30929386:30930421,30929389:30930460,30929391:30930497,30929392:3093053', 'assoc_mat': '30918216:pet_fonce:4230:30919191,30918219:pet_fonce:4230:30919231,30918222:pet_fonce:4230:30919309,30918225:pet_fonce:4230:30920937,30918228:pet_fonce:4230:30919425,30918231:pet_fonce:4230:30919534,30918234:pet_fonce:4230:30919641,30918237:pet_fonce:4230:30919685,30918240:pet_fonce:4230:30919745,30918243:pet_fonce:4230:30919822,30918246:pet_fonce:4230:30919905,30918249:pet_fonce:4230:30919983,30918252:pet_fonce:4230:30920051,30918255:pet_fonce:4230:30920128,30918257:pet_fonce:4230:30920192,30918259:pet_fonce:4230:30920269,30918261:pet_fonce:4230:30920386,30918263:pet_fonce:4230:30920415,30918265:pet_fonce:4230:30920488,30918267:pet_fonce:4230:30920537,30918269:pet_fonce:4230:30921347,30918923:pet_fonce:4230:30920796,30923839:pet_fonce:4230:30925077,30923842:pet_fonce:4230:30925118,30923845:pet_fonce:4230:30925193,30923848:pet_fonce:4230:30925258,30923851:pet_fonce:4230:30925376,30923854:pet_fonce:4230:30925411,30923857:pet_fonce:4230:30925494,30923860:pet_fonce:4230:30925568,30923863:pet_fonce:4230:30925669,3'}), 'main_stat': {'nb_photos': 1560}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30998258,30998259,30998260,30998261,30998263,30998264,30998265?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-04', 0.5859191724248235),)]} 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': ((1560,),), 'unwanted_material_monthly_percentage': ((0.5859191724248235,),), 'material_repartition': (('incineration', 1554),), 'material_dict': {'incineration': 1554}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 4, 1), 0.5018778057282319, 4), (datetime.date(2026, 4, 2), 0.49290614125602283, 3), (datetime.date(2026, 4, 3), 0.475401339098257, 4), (datetime.date(2026, 4, 4), 0.4834500951520462, 3), (datetime.date(2026, 4, 5), 0.7108950715113861, 4), (datetime.date(2026, 4, 6), 0.773769468543086, 4), (datetime.date(2026, 4, 7), 0.7811732770279853, 4), (datetime.date(2026, 4, 8), 0.7324838658187119, 3), (datetime.date(2026, 4, 9), 0.6054957404491326, 3), (datetime.date(2026, 4, 10), 0.514574385507816, 4), (datetime.date(2026, 4, 11), 0.4580222464310797, 2), (datetime.date(2026, 4, 12), 0.47558480995958086, 1), (datetime.date(2026, 4, 13), 0.4979648734311427, 2), (datetime.date(2026, 4, 14), 0.5313000047106647, 3), (datetime.date(2026, 4, 15), 0.576209489125348, 2), (datetime.date(2026, 4, 16), 0.535071933801229, 4), (datetime.date(2026, 4, 17), 0.5498982476933619, 1), (datetime.date(2026, 4, 18), 0.5839777097205224, 3), (datetime.date(2026, 4, 19), 0.6545491282370174, 3), (datetime.date(2026, 4, 20), 0.7336301699225193, 3), (datetime.date(2026, 4, 21), 0.792197289547998, 1), (datetime.date(2026, 4, 22), 0.6706721833472276, 2), (datetime.date(2026, 4, 23), 0.5654189620015336, 3), (datetime.date(2026, 4, 24), 0.5107156900135217, 2), (datetime.date(2026, 4, 25), 0.4759869473127213, 4), (datetime.date(2026, 4, 26), 0.47662206837888754, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 4, 1), 0.5018778057282319, 4), (datetime.date(2026, 4, 2), 0.49290614125602283, 3), (datetime.date(2026, 4, 3), 0.475401339098257, 4), (datetime.date(2026, 4, 4), 0.4834500951520462, 3), (datetime.date(2026, 4, 5), 0.7108950715113861, 4), (datetime.date(2026, 4, 6), 0.773769468543086, 4), (datetime.date(2026, 4, 7), 0.7811732770279853, 4), (datetime.date(2026, 4, 8), 0.7324838658187119, 3), (datetime.date(2026, 4, 9), 0.6054957404491326, 3), (datetime.date(2026, 4, 10), 0.514574385507816, 4), (datetime.date(2026, 4, 11), 0.4580222464310797, 2), (datetime.date(2026, 4, 12), 0.47558480995958086, 1), (datetime.date(2026, 4, 13), 0.4979648734311427, 2), (datetime.date(2026, 4, 14), 0.5313000047106647, 3), (datetime.date(2026, 4, 15), 0.576209489125348, 2), (datetime.date(2026, 4, 16), 0.535071933801229, 4), (datetime.date(2026, 4, 17), 0.5498982476933619, 1), (datetime.date(2026, 4, 18), 0.5839777097205224, 3), (datetime.date(2026, 4, 19), 0.6545491282370174, 3), (datetime.date(2026, 4, 20), 0.7336301699225193, 3), (datetime.date(2026, 4, 21), 0.792197289547998, 1), (datetime.date(2026, 4, 22), 0.6706721833472276, 2), (datetime.date(2026, 4, 23), 0.5654189620015336, 3), (datetime.date(2026, 4, 24), 0.5107156900135217, 2), (datetime.date(2026, 4, 25), 0.4759869473127213, 4), (datetime.date(2026, 4, 26), 0.47662206837888754, 2))}, 'quality_array': [['-7.854566651000625', '01042026'], ['-7.647920877442716', '02042026'], ['-7.721492312514128', '03042026'], ['-8.61609851870657', '04042026'], ['-8.643346703122758', '05042026'], ['-8.396409414931753', '06042026'], ['-7.794710685460984', '07042026'], ['-7.498398285305459', '08042026'], ['-7.939191817342551', '09042026'], ['-8.92860312125933', '10042026'], ['-8.91286966865884', '11042026'], ['-8.685137439778499', '12042026'], ['-8.414608335416574', '13042026'], ['-8.599415374865726', '14042026'], ['-8.67465138176147', '15042026'], ['-8.446300984318857', '16042026'], ['-8.855519572908369', '17042026'], ['-8.807584230429963', '18042026'], ['-8.854660360896904', '19042026'], ['-8.295533421914419', '20042026'], ['-7.755305867976193', '21042026'], ['-7.665061401833666', '22042026'], ['-8.037048724882721', '23042026'], ['-8.433261086276334', '24042026'], ['-8.343685813761393', '25042026'], ['-8.17739867407949', '26042026']], 'number_of_batch': ((577,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02141778841964629, 'nb_photo': 20113, 'list_port_cont': '30919090,30919198,30919228,30919311,30919414,30919537,30919643,30919670,30919755,30919832,30919902,30919967,30920055,30920114,30920205,30920277,30920377,30920420,30920498,30920531,30920727,30920793,30920941,30921336,30925069,30925104,30925180,30925264,30925363,30925404,30925481,30925558,30925668,30925712,30925816,30925885,30925926,30925970,30926013,30926034,30926084,30926124,30926157,30926189,30926291,30926383,30926926,30926955,30930172,30930200,30930237,30930268,30930319,30930349,30930394,30930416,30930455,30930501,30930543,30930573,30930616,30930649,30930681,30930719,30930747,30930793,30930822,30930865,30930900,30930932,30930985,30931839,30931926,30931996,30932237,30932510,30932580,30932620,30932767,30932900,30933142,30933273,30933421,30933505,30933765,30933806,30933935,30934029,30934201,30934340,30934461,30934564,30934715,30934829,30935632,30935698,30938894,30939828,30939862,30939898,30939945,30939973,30940014,30940086,30940191,30940278,30940357,30940433,30940500,30940577,30940641,30940685,30940844,3094087', 'assoc_port': '30918213:30919090,30918216:30919198,30918219:30919228,30918222:30919311,30918225:30920941,30918228:30919414,30918231:30919537,30918234:30919643,30918237:30919670,30918240:30919755,30918243:30919832,30918246:30919902,30918249:30919967,30918252:30920055,30918255:30920114,30918257:30920205,30918259:30920277,30918261:30920377,30918263:30920420,30918265:30920498,30918267:30920531,30918269:30921336,30918614:30920727,30918923:30920793,30923839:30925069,30923842:30925104,30923845:30925180,30923848:30925264,30923851:30925363,30923854:30925404,30923857:30925481,30923860:30925558,30923863:30925668,30923866:30925712,30923869:30925816,30923872:30925885,30923875:30925926,30923878:30925970,30923881:30926926,30923883:30926034,30923885:30926157,30923887:30926013,30923889:30926084,30923891:30926955,30923893:30926124,30923894:30926189,30924275:30926291,30924729:30926383,30929372:30930172,30929374:30930200,30929377:30930237,30929379:30930268,30929381:30930319,30929383:30930349,30929385:30930394,30929386:30930416,30929389:3093045', 'assoc_mat': '30918213:autre:4230:30919090,30918216:autre:4230:30919198,30918219:autre:4230:30919228,30918222:autre:4230:30919311,30918225:autre:4230:30920941,30918228:autre:4230:30919414,30918231:autre:4230:30919537,30918234:autre:4230:30919643,30918237:autre:4230:30919670,30918240:autre:4230:30919755,30918243:autre:4230:30919832,30918246:autre:4230:30919902,30918249:autre:4230:30919967,30918252:autre:4230:30920055,30918255:autre:4230:30920114,30918257:autre:4230:30920205,30918259:autre:4230:30920277,30918261:autre:4230:30920377,30918263:autre:4230:30920420,30918265:autre:4230:30920498,30918267:autre:4230:30920531,30918269:autre:4230:30921336,30918614:autre:4230:30920727,30918923:autre:4230:30920793,30923839:autre:4230:30925069,30923842:autre:4230:30925104,30923845:autre:4230:30925180,30923848:autre:4230:30925264,30923851:autre:4230:30925363,30923854:autre:4230:30925404,30923857:autre:4230:30925481,30923860:autre:4230:30925558,30923863:autre:4230:30925668,30923866:autre:4230:30925712,30923869:autre:4230:30925816,30923872:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0867916440219037, 'nb_photo': 99901, 'list_port_cont': '30919088,30919196,30919238,30919313,30919423,30919529,30919637,30919677,30919752,30919834,30919908,30919980,30920045,30920131,30920198,30920278,30920382,30920422,30920492,30920533,30920728,30920802,30920949,30921350,30925082,30925117,30925181,30925259,30925380,30925408,30925484,30925566,30925667,30925711,30925821,30925889,30925939,30925975,30926001,30926047,30926087,30926115,30926156,30926196,30926308,30926377,30926923,30926964,30930163,30930208,30930240,30930279,30930315,30930348,30930392,30930428,30930463,30930503,30930528,30930581,30930612,30930653,30930676,30930721,30930764,30930800,30930829,30930859,30930904,30930940,30930991,30931848,30931915,30931994,30932243,30932503,30932582,30932624,30932779,30932891,30933145,30933283,30933427,30933506,30933776,30933813,30933929,30934034,30934214,30934339,30934469,30934562,30934723,30934825,30935636,30935704,30938887,30939841,30939878,30939914,30939940,30939977,30940024,30940095,30940205,30940277,30940355,30940425,30940505,30940570,30940643,30940689,30940840,3094086', 'assoc_port': '30918213:30919088,30918216:30919196,30918219:30919238,30918222:30919313,30918225:30920949,30918228:30919423,30918231:30919529,30918234:30919637,30918237:30919677,30918240:30919752,30918243:30919834,30918246:30919908,30918249:30919980,30918252:30920045,30918255:30920131,30918257:30920198,30918259:30920278,30918261:30920382,30918263:30920422,30918265:30920492,30918267:30920533,30918269:30921350,30918614:30920728,30918923:30920802,30923839:30925082,30923842:30925117,30923845:30925181,30923848:30925259,30923851:30925380,30923854:30925408,30923857:30925484,30923860:30925566,30923863:30925667,30923866:30925711,30923869:30925821,30923872:30925889,30923875:30925939,30923878:30925975,30923881:30926923,30923883:30926047,30923885:30926156,30923887:30926001,30923889:30926087,30923891:30926964,30923893:30926115,30923894:30926196,30924275:30926308,30924729:30926377,30929372:30930163,30929374:30930208,30929377:30930240,30929379:30930279,30929381:30930315,30929383:30930348,30929385:30930392,30929386:30930428,30929389:3093046', 'assoc_mat': '30918213:carton:4230:30919088,30918216:carton:4230:30919196,30918219:carton:4230:30919238,30918222:carton:4230:30919313,30918225:carton:4230:30920949,30918228:carton:4230:30919423,30918231:carton:4230:30919529,30918234:carton:4230:30919637,30918237:carton:4230:30919677,30918240:carton:4230:30919752,30918243:carton:4230:30919834,30918246:carton:4230:30919908,30918249:carton:4230:30919980,30918252:carton:4230:30920045,30918255:carton:4230:30920131,30918257:carton:4230:30920198,30918259:carton:4230:30920278,30918261:carton:4230:30920382,30918263:carton:4230:30920422,30918265:carton:4230:30920492,30918267:carton:4230:30920533,30918269:carton:4230:30921350,30918614:carton:4230:30920728,30918923:carton:4230:30920802,30923839:carton:4230:30925082,30923842:carton:4230:30925117,30923845:carton:4230:30925181,30923848:carton:4230:30925259,30923851:carton:4230:30925380,30923854:carton:4230:30925408,30923857:carton:4230:30925484,30923860:carton:4230:30925566,30923863:carton:4230:30925667,30923866:carton:4230:30925711,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018313742914263698, 'nb_photo': 1819, 'list_port_cont': '30919084,30919195,30919224,30919312,30919426,30919522,30919646,30919678,30919758,30919824,30919896,30919982,30920056,30920121,30920194,30920273,30920376,30920414,30920496,30920523,30920714,30920799,30920948,30921340,30925066,30925111,30925184,30925261,30925377,30925414,30925485,30925567,30925679,30925702,30925822,30925892,30925937,30925974,30926004,30926049,30926079,30926121,30926307,30926372,30926927,30926960,30930170,30930205,30930245,30930269,30930316,30930341,30930387,30930432,30930457,30930492,30930538,30930582,30930609,30930646,30930678,30930724,30930763,30930803,30930835,30930867,30930896,30930936,30930982,30931850,30931914,30931993,30932234,30932501,30932572,30932609,30932766,30933144,30933275,30933419,30933509,30933761,30933802,30933932,30934033,30934197,30934343,30934727,30935635,30939829,30939943,30940017,30940200,30940274,30940416,30940506,30940654,30940691,30940837,30940866,30940943,30941014,30941088,30941419,30941565,30945166,30945199,30945270,30945339,30945428,30945492,30945575,30945644,3094571', 'assoc_port': '30918213:30919084,30918216:30919195,30918219:30919224,30918222:30919312,30918225:30920948,30918228:30919426,30918231:30919522,30918234:30919646,30918237:30919678,30918240:30919758,30918243:30919824,30918246:30919896,30918249:30919982,30918252:30920056,30918255:30920121,30918257:30920194,30918259:30920273,30918261:30920376,30918263:30920414,30918265:30920496,30918267:30920523,30918269:30921340,30918614:30920714,30918923:30920799,30923839:30925066,30923842:30925111,30923845:30925184,30923848:30925261,30923851:30925377,30923854:30925414,30923857:30925485,30923860:30925567,30923863:30925679,30923866:30925702,30923869:30925822,30923872:30925892,30923875:30925937,30923878:30925974,30923881:30926927,30923883:30926049,30923887:30926004,30923889:30926079,30923891:30926960,30923893:30926121,30924275:30926307,30924729:30926372,30929372:30930170,30929374:30930205,30929377:30930245,30929379:30930269,30929381:30930316,30929383:30930341,30929385:30930387,30929386:30930432,30929389:30930457,30929391:30930492,30929392:3093053', 'assoc_mat': '30918213:metal:4230:30919084,30918216:metal:4230:30919195,30918219:metal:4230:30919224,30918222:metal:4230:30919312,30918225:metal:4230:30920948,30918228:metal:4230:30919426,30918231:metal:4230:30919522,30918234:metal:4230:30919646,30918237:metal:4230:30919678,30918240:metal:4230:30919758,30918243:metal:4230:30919824,30918246:metal:4230:30919896,30918249:metal:4230:30919982,30918252:metal:4230:30920056,30918255:metal:4230:30920121,30918257:metal:4230:30920194,30918259:metal:4230:30920273,30918261:metal:4230:30920376,30918263:metal:4230:30920414,30918265:metal:4230:30920496,30918267:metal:4230:30920523,30918269:metal:4230:30921340,30918614:metal:4230:30920714,30918923:metal:4230:30920799,30923839:metal:4230:30925066,30923842:metal:4230:30925111,30923845:metal:4230:30925184,30923848:metal:4230:30925261,30923851:metal:4230:30925377,30923854:metal:4230:30925414,30923857:metal:4230:30925485,30923860:metal:4230:30925567,30923863:metal:4230:30925679,30923866:metal:4230:30925702,30923869:metal:4230:30925822,30923872:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3184084051365039, 'nb_photo': 333250, 'list_port_cont': '30919092,30919197,30919227,30919304,30919422,30919532,30919642,30919682,30919754,30919831,30919904,30919979,30920054,30920130,30920202,30920279,30920385,30920426,30920494,30920535,30920730,30920803,30920944,30921343,30925071,30925106,30925196,30925269,30925373,30925413,30925493,30925564,30925673,30925715,30925824,30925899,30925938,30925971,30926010,30926050,30926086,30926119,30926160,30926193,30926305,30926388,30926920,30926957,30930169,30930206,30930244,30930275,30930306,30930356,30930386,30930431,30930464,30930504,30930541,30930571,30930608,30930644,30930684,30930726,30930757,30930791,30930837,30930874,30930906,30930946,30930992,30931840,30931924,30931995,30932246,30932508,30932576,30932622,30932775,30932899,30933137,30933278,30933425,30933516,30933770,30933815,30933940,30934026,30934200,30934329,30934464,30934557,30934717,30934831,30935637,30935708,30938892,30939838,30939875,30939911,30939939,30939981,30940015,30940098,30940208,30940281,30940354,30940430,30940504,30940574,30940645,30940686,30940836,3094087', 'assoc_port': '30918213:30919092,30918216:30919197,30918219:30919227,30918222:30919304,30918225:30920944,30918228:30919422,30918231:30919532,30918234:30919642,30918237:30919682,30918240:30919754,30918243:30919831,30918246:30919904,30918249:30919979,30918252:30920054,30918255:30920130,30918257:30920202,30918259:30920279,30918261:30920385,30918263:30920426,30918265:30920494,30918267:30920535,30918269:30921343,30918614:30920730,30918923:30920803,30923839:30925071,30923842:30925106,30923845:30925196,30923848:30925269,30923851:30925373,30923854:30925413,30923857:30925493,30923860:30925564,30923863:30925673,30923866:30925715,30923869:30925824,30923872:30925899,30923875:30925938,30923878:30925971,30923881:30926920,30923883:30926050,30923885:30926160,30923887:30926010,30923889:30926086,30923891:30926957,30923893:30926119,30923894:30926193,30924275:30926305,30924729:30926388,30929372:30930169,30929374:30930206,30929377:30930244,30929379:30930275,30929381:30930306,30929383:30930356,30929385:30930386,30929386:30930431,30929389:3093046', 'assoc_mat': '30918213:papier:4230:30919092,30918216:papier:4230:30919197,30918219:papier:4230:30919227,30918222:papier:4230:30919304,30918225:papier:4230:30920944,30918228:papier:4230:30919422,30918231:papier:4230:30919532,30918234:papier:4230:30919642,30918237:papier:4230:30919682,30918240:papier:4230:30919754,30918243:papier:4230:30919831,30918246:papier:4230:30919904,30918249:papier:4230:30919979,30918252:papier:4230:30920054,30918255:papier:4230:30920130,30918257:papier:4230:30920202,30918259:papier:4230:30920279,30918261:papier:4230:30920385,30918263:papier:4230:30920426,30918265:papier:4230:30920494,30918267:papier:4230:30920535,30918269:papier:4230:30921343,30918614:papier:4230:30920730,30918923:papier:4230:30920803,30923839:papier:4230:30925071,30923842:papier:4230:30925106,30923845:papier:4230:30925196,30923848:papier:4230:30925269,30923851:papier:4230:30925373,30923854:papier:4230:30925413,30923857:papier:4230:30925493,30923860:papier:4230:30925564,30923863:papier:4230:30925673,30923866:papier:4230:30925715,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0065984801188874575, 'nb_photo': 4291, 'list_port_cont': '30919091,30919201,30919239,30919301,30919421,30919533,30919647,30919680,30919748,30919829,30919906,30919977,30920050,30920127,30920196,30920275,30920381,30920425,30920723,30920801,30920952,30921348,30925080,30925116,30925194,30925260,30925366,30925416,30925491,30925569,30925678,30925713,30925818,30925894,30925935,30925967,30926012,30926048,30926085,30926123,30926147,30926191,30926306,30926387,30926921,30926968,30930167,30930198,30930247,30930281,30930317,30930358,30930385,30930427,30930465,30930496,30930535,30930576,30930618,30930648,30930683,30930725,30930762,30930801,30930834,30930866,30930910,30930949,30930987,30931842,30931922,30932002,30932244,30932509,30932581,30932619,30932772,30932902,30933143,30933282,30933417,30933514,30933773,30933817,30933933,30934021,30934208,30934336,30934473,30934556,30934725,30934821,30935627,30935705,30938890,30939835,30939869,30939910,30939980,30940023,30940092,30940197,30940280,30940345,30940427,30940507,30940832,30940872,30940949,30941019,30941101,30941582,30941690,3094517', 'assoc_port': '30918213:30919091,30918216:30919201,30918219:30919239,30918222:30919301,30918225:30920952,30918228:30919421,30918231:30919533,30918234:30919647,30918237:30919680,30918240:30919748,30918243:30919829,30918246:30919906,30918249:30919977,30918252:30920050,30918255:30920127,30918257:30920196,30918259:30920275,30918261:30920381,30918263:30920425,30918269:30921348,30918614:30920723,30918923:30920801,30923839:30925080,30923842:30925116,30923845:30925194,30923848:30925260,30923851:30925366,30923854:30925416,30923857:30925491,30923860:30925569,30923863:30925678,30923866:30925713,30923869:30925818,30923872:30925894,30923875:30925935,30923878:30925967,30923881:30926921,30923883:30926048,30923885:30926147,30923887:30926012,30923889:30926085,30923891:30926968,30923893:30926123,30923894:30926191,30924275:30926306,30924729:30926387,30929372:30930167,30929374:30930198,30929377:30930247,30929379:30930281,30929381:30930317,30929383:30930358,30929385:30930385,30929386:30930427,30929389:30930465,30929391:30930496,30929392:3093053', 'assoc_mat': '30918213:pehd:4230:30919091,30918216:pehd:4230:30919201,30918219:pehd:4230:30919239,30918222:pehd:4230:30919301,30918225:pehd:4230:30920952,30918228:pehd:4230:30919421,30918231:pehd:4230:30919533,30918234:pehd:4230:30919647,30918237:pehd:4230:30919680,30918240:pehd:4230:30919748,30918243:pehd:4230:30919829,30918246:pehd:4230:30919906,30918249:pehd:4230:30919977,30918252:pehd:4230:30920050,30918255:pehd:4230:30920127,30918257:pehd:4230:30920196,30918259:pehd:4230:30920275,30918261:pehd:4230:30920381,30918263:pehd:4230:30920425,30918269:pehd:4230:30921348,30918614:pehd:4230:30920723,30918923:pehd:4230:30920801,30923839:pehd:4230:30925080,30923842:pehd:4230:30925116,30923845:pehd:4230:30925194,30923848:pehd:4230:30925260,30923851:pehd:4230:30925366,30923854:pehd:4230:30925416,30923857:pehd:4230:30925491,30923860:pehd:4230:30925569,30923863:pehd:4230:30925678,30923866:pehd:4230:30925713,30923869:pehd:4230:30925818,30923872:pehd:4230:30925894,30923875:pehd:4230:30925935,30923878:pehd:4230:30925967,30923881:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01130668890810181, 'nb_photo': 21107, 'list_port_cont': '30919089,30919199,30919237,30919310,30919428,30919538,30919645,30919671,30919757,30919833,30919899,30919984,30920047,30920126,30920204,30920276,30920387,30920417,30920499,30920534,30920731,30920795,30920950,30921337,30925075,30925113,30925189,30925268,30925368,30925417,30925488,30925557,30925671,30925701,30925815,30925897,30925931,30925969,30926009,30926051,30926081,30926122,30926155,30926188,30926304,30926374,30926915,30926966,30930160,30930211,30930242,30930278,30930312,30930343,30930390,30930426,30930456,30930498,30930539,30930579,30930610,30930651,30930689,30930717,30930755,30930802,30930832,30930870,30930907,30930945,30930988,30931845,30931921,30932000,30932247,30932499,30932583,30932610,30932774,30932904,30933132,30933281,30933424,30933510,30933772,30933812,30933934,30934030,30934204,30934342,30934466,30934563,30934713,30934833,30935638,30935707,30938891,30939843,30939871,30939907,30939948,30939979,30940010,30940091,30940207,30940273,30940353,30940432,30940493,30940579,30940653,30940690,30940843,3094087', 'assoc_port': '30918213:30919089,30918216:30919199,30918219:30919237,30918222:30919310,30918225:30920950,30918228:30919428,30918231:30919538,30918234:30919645,30918237:30919671,30918240:30919757,30918243:30919833,30918246:30919899,30918249:30919984,30918252:30920047,30918255:30920126,30918257:30920204,30918259:30920276,30918261:30920387,30918263:30920417,30918265:30920499,30918267:30920534,30918269:30921337,30918614:30920731,30918923:30920795,30923839:30925075,30923842:30925113,30923845:30925189,30923848:30925268,30923851:30925368,30923854:30925417,30923857:30925488,30923860:30925557,30923863:30925671,30923866:30925701,30923869:30925815,30923872:30925897,30923875:30925931,30923878:30925969,30923881:30926915,30923883:30926051,30923885:30926155,30923887:30926009,30923889:30926081,30923891:30926966,30923893:30926122,30923894:30926188,30924275:30926304,30924729:30926374,30929372:30930160,30929374:30930211,30929377:30930242,30929379:30930278,30929381:30930312,30929383:30930343,30929385:30930390,30929386:30930426,30929389:3093045', 'assoc_mat': '30918213:pet_clair:4230:30919089,30918216:pet_clair:4230:30919199,30918219:pet_clair:4230:30919237,30918222:pet_clair:4230:30919310,30918225:pet_clair:4230:30920950,30918228:pet_clair:4230:30919428,30918231:pet_clair:4230:30919538,30918234:pet_clair:4230:30919645,30918237:pet_clair:4230:30919671,30918240:pet_clair:4230:30919757,30918243:pet_clair:4230:30919833,30918246:pet_clair:4230:30919899,30918249:pet_clair:4230:30919984,30918252:pet_clair:4230:30920047,30918255:pet_clair:4230:30920126,30918257:pet_clair:4230:30920204,30918259:pet_clair:4230:30920276,30918261:pet_clair:4230:30920387,30918263:pet_clair:4230:30920417,30918265:pet_clair:4230:30920499,30918267:pet_clair:4230:30920534,30918269:pet_clair:4230:30921337,30918614:pet_clair:4230:30920731,30918923:pet_clair:4230:30920795,30923839:pet_clair:4230:30925075,30923842:pet_clair:4230:30925113,30923845:pet_clair:4230:30925189,30923848:pet_clair:4230:30925268,30923851:pet_clair:4230:30925368,30923854:pet_clair:4230:30925417,30923857:pet_clair:4230:30925488,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005135514422327376, 'nb_photo': 1580, 'list_port_cont': '30919191,30919231,30919309,30919425,30919534,30919641,30919685,30919745,30919822,30919905,30919983,30920051,30920128,30920192,30920269,30920386,30920415,30920488,30920537,30920796,30920937,30921347,30925077,30925118,30925193,30925258,30925376,30925411,30925494,30925568,30925669,30925703,30925823,30925887,30925940,30925973,30926011,30926044,30926083,30926114,30926159,30926190,30926300,30926385,30926928,30926962,30930173,30930207,30930236,30930280,30930314,30930357,30930393,30930421,30930460,30930497,30930537,30930575,30930613,30930652,30930690,30930750,30930911,30930942,30930994,30931837,30931925,30931997,30932240,30932504,30932579,30932621,30932778,30932905,30933136,30933285,30933414,30933512,30933775,30933803,30933939,30934024,30934205,30934341,30934553,30934718,30934835,30935630,30935712,30939837,30939906,30939942,30939978,30940018,30940099,30940203,30940282,30940356,30940426,30940494,30940647,30940692,30940833,30940878,30940948,30941025,30941687,30945579,30945647,30945869,30946499,30951058,30951283,3095135', 'assoc_port': '30918216:30919191,30918219:30919231,30918222:30919309,30918225:30920937,30918228:30919425,30918231:30919534,30918234:30919641,30918237:30919685,30918240:30919745,30918243:30919822,30918246:30919905,30918249:30919983,30918252:30920051,30918255:30920128,30918257:30920192,30918259:30920269,30918261:30920386,30918263:30920415,30918265:30920488,30918267:30920537,30918269:30921347,30918923:30920796,30923839:30925077,30923842:30925118,30923845:30925193,30923848:30925258,30923851:30925376,30923854:30925411,30923857:30925494,30923860:30925568,30923863:30925669,30923866:30925703,30923869:30925823,30923872:30925887,30923875:30925940,30923878:30925973,30923881:30926928,30923883:30926044,30923885:30926159,30923887:30926011,30923889:30926083,30923891:30926962,30923893:30926114,30923894:30926190,30924275:30926300,30924729:30926385,30929372:30930173,30929374:30930207,30929377:30930236,30929379:30930280,30929381:30930314,30929383:30930357,30929385:30930393,30929386:30930421,30929389:30930460,30929391:30930497,30929392:3093053', 'assoc_mat': '30918216:pet_fonce:4230:30919191,30918219:pet_fonce:4230:30919231,30918222:pet_fonce:4230:30919309,30918225:pet_fonce:4230:30920937,30918228:pet_fonce:4230:30919425,30918231:pet_fonce:4230:30919534,30918234:pet_fonce:4230:30919641,30918237:pet_fonce:4230:30919685,30918240:pet_fonce:4230:30919745,30918243:pet_fonce:4230:30919822,30918246:pet_fonce:4230:30919905,30918249:pet_fonce:4230:30919983,30918252:pet_fonce:4230:30920051,30918255:pet_fonce:4230:30920128,30918257:pet_fonce:4230:30920192,30918259:pet_fonce:4230:30920269,30918261:pet_fonce:4230:30920386,30918263:pet_fonce:4230:30920415,30918265:pet_fonce:4230:30920488,30918267:pet_fonce:4230:30920537,30918269:pet_fonce:4230:30921347,30918923:pet_fonce:4230:30920796,30923839:pet_fonce:4230:30925077,30923842:pet_fonce:4230:30925118,30923845:pet_fonce:4230:30925193,30923848:pet_fonce:4230:30925258,30923851:pet_fonce:4230:30925376,30923854:pet_fonce:4230:30925411,30923857:pet_fonce:4230:30925494,30923860:pet_fonce:4230:30925568,30923863:pet_fonce:4230:30925669,3'}), 'main_stat': {'nb_photos': 1560}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30998258,30998259,30998260,30998261,30998263,30998264,30998265?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-04', 0.5859191724248235),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_04_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.14%', 20113], 'carton': ['carton', '8.68%', 99901], 'metal': ['metal', '0.18%', 1819], 'papier': ['papier', '31.84%', 333250], 'pehd': ['pehd', '0.66%', 4291], 'pet_clair': ['pet_clair', '1.13%', 21107], 'pet_fonce': ['pet_fonce', '0.51%', 1580]}} 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_04_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.44user 2.49system 0:15.93elapsed 30%CPU (0avgtext+0avgdata 186676maxresident)k 8inputs+288outputs (0major+49249minor)pagefaults 0swaps