python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-06 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 06 mtr_id : dashboard_places : SCCU_cam7 date : 2026-06 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-06%') and created_at like '%2026-06%'))); nb_day : (0, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 06 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 06 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%062026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-06-01 : dt_date_just_month_year : 2026-06-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-06-01" AND ded.date <= "2026-06-30" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (3002274,2996338,2996314,3001674,3001188,2997662,2998116,2998636,2999166,2999792,3000336,3000780,3001290,3001826,3002432,3002776,3003142,3003566,3004098,3004258) 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.015785903388376134, 'nb_photo': 17871, 'list_port_cont': '31141769,31142027,31142154,31142388,31142696,31142741,31143449,31143488,31143692,31144021,31144047,31144548,31144588,31144613,31144686,31145701,31145754,31147551,31147613,31147650,31147706,31147734,31147781,31147807,31147862,31147906,31147960,31147995,31148031,31148062,31148110,31148147,31148190,31149252,31149286,31149330,31149368,31149414,31149468,31149503,31149532,31149584,31149622,31149650,31149689,31149737,31149775,31149804,31149857,31149892,31149926,31149961,31150006,31152312,31152339,31152390,31152422,31152459,31152541,31152568,31152853,31152939,31152992,31153385,31154199,31154230,31155111,31155153,31155200,31155231,31155269,31155309,31155346,31155397,31155431,31155474,31155538,31155581,31155654,31156811,31157290,31158200,31158232,31158273,31158307,31158346,31158377,31158421,31158473,31158509,31158551,31158593,31158631,31158664,31158702,31158749,31158773,31158816,31158856,31158898,31158922,31158979,31161061,31161107,31161145,31161190,31161223,31161258,31161300,31161332,31161371,31161427,31161465,3116150', 'assoc_port': '31141673:31141769,31141924:31142027,31142101:31142154,31142346:31142388,31142556:31142696,31142557:31142741,31142885:31143692,31143307:31143488,31143308:31143449,31143741:31144021,31143742:31144047,31144236:31144548,31144237:31144588,31144238:31144613,31144239:31144686,31144873:31145701,31144874:31145754,31144875:31190295,31146782:31147551,31146783:31147613,31146784:31147650,31146785:31152568,31146786:31147706,31146787:31147734,31146788:31147807,31146789:31147781,31146790:31147862,31146791:31147906,31146792:31147960,31146793:31147995,31146794:31152853,31146795:31148062,31146796:31148031,31146797:31152939,31146798:31148110,31146799:31152992,31146800:31148147,31146801:31148190,31146842:31184259,31146864:31149252,31146865:31149286,31146866:31149368,31146867:31149330,31146868:31154230,31146869:31149414,31146870:31156811,31146871:31149468,31146872:31153385,31146874:31149503,31146875:31149532,31146876:31149584,31146877:31154199,31146878:31149622,31146879:31149689,31146880:31149650,31146881:31149737,31146882:3114977', 'assoc_mat': '31141673:autre:4230:31141769,31141924:autre:4230:31142027,31142101:autre:4230:31142154,31142346:autre:4230:31142388,31142556:autre:4230:31142696,31142557:autre:4230:31142741,31142885:autre:4230:31143692,31143307:autre:4230:31143488,31143308:autre:4230:31143449,31143741:autre:4230:31144021,31143742:autre:4230:31144047,31144236:autre:4230:31144548,31144237:autre:4230:31144588,31144238:autre:4230:31144613,31144239:autre:4230:31144686,31144873:autre:4230:31145701,31144874:autre:4230:31145754,31144875:autre:4230:31190295,31146782:autre:4230:31147551,31146783:autre:4230:31147613,31146784:autre:4230:31147650,31146785:autre:4230:31152568,31146786:autre:4230:31147706,31146787:autre:4230:31147734,31146788:autre:4230:31147807,31146789:autre:4230:31147781,31146790:autre:4230:31147862,31146791:autre:4230:31147906,31146792:autre:4230:31147960,31146793:autre:4230:31147995,31146794:autre:4230:31152853,31146795:autre:4230:31148062,31146796:autre:4230:31148031,31146797:autre:4230:31152939,31146798:autre:4230:31148110,31146799:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06466775374868074, 'nb_photo': 112807, 'list_port_cont': '31141777,31142022,31142158,31142383,31142702,31142743,31143450,31143499,31143691,31144018,31144060,31144550,31144590,31144619,31144690,31145707,31145752,31147548,31147619,31147655,31147705,31147746,31147777,31147823,31147872,31147918,31147958,31147994,31148032,31148072,31148102,31148145,31148193,31149263,31149295,31149340,31149372,31149416,31149464,31149505,31149543,31149587,31149623,31149657,31149692,31149732,31149776,31149807,31149856,31149896,31149918,31149975,31150004,31152310,31152352,31152378,31152426,31152464,31152545,31152577,31152851,31152955,31152989,31153379,31154192,31154236,31155120,31155163,31155192,31155242,31155267,31155322,31155349,31155387,31155434,31155478,31155543,31155587,31155655,31156809,31157291,31158203,31158236,31158266,31158321,31158354,31158385,31158431,31158466,31158504,31158549,31158598,31158634,31158663,31158699,31158742,31158783,31158820,31158852,31158897,31158938,31158974,31161076,31161109,31161149,31161186,31161224,31161263,31161296,31161334,31161367,31161423,31161455,3116149', 'assoc_port': '31141673:31141777,31141924:31142022,31142101:31142158,31142346:31142383,31142556:31142702,31142557:31142743,31142885:31143691,31143307:31143499,31143308:31143450,31143741:31144018,31143742:31144060,31144236:31144550,31144237:31144590,31144238:31144619,31144239:31144690,31144873:31145707,31144874:31145752,31144875:31190304,31146782:31147548,31146783:31147619,31146784:31147655,31146785:31152577,31146786:31147705,31146787:31147746,31146788:31147823,31146789:31147777,31146790:31147872,31146791:31147918,31146792:31147958,31146793:31147994,31146794:31152851,31146795:31148072,31146796:31148032,31146797:31152955,31146798:31148102,31146799:31152989,31146800:31148145,31146801:31148193,31146842:31184270,31146864:31149263,31146865:31149295,31146866:31149372,31146867:31149340,31146868:31154236,31146869:31149416,31146870:31156809,31146871:31149464,31146872:31153379,31146874:31149505,31146875:31149543,31146876:31149587,31146877:31154192,31146878:31149623,31146879:31149692,31146880:31149657,31146881:31149732,31146882:3114977', 'assoc_mat': '31141673:carton:4230:31141777,31141924:carton:4230:31142022,31142101:carton:4230:31142158,31142346:carton:4230:31142383,31142556:carton:4230:31142702,31142557:carton:4230:31142743,31142885:carton:4230:31143691,31143307:carton:4230:31143499,31143308:carton:4230:31143450,31143741:carton:4230:31144018,31143742:carton:4230:31144060,31144236:carton:4230:31144550,31144237:carton:4230:31144590,31144238:carton:4230:31144619,31144239:carton:4230:31144690,31144873:carton:4230:31145707,31144874:carton:4230:31145752,31144875:carton:4230:31190304,31146782:carton:4230:31147548,31146783:carton:4230:31147619,31146784:carton:4230:31147655,31146785:carton:4230:31152577,31146786:carton:4230:31147705,31146787:carton:4230:31147746,31146788:carton:4230:31147823,31146789:carton:4230:31147777,31146790:carton:4230:31147872,31146791:carton:4230:31147918,31146792:carton:4230:31147958,31146793:carton:4230:31147994,31146794:carton:4230:31152851,31146795:carton:4230:31148072,31146796:carton:4230:31148032,31146797:carton:4230:31152955,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001700040910576424, 'nb_photo': 2680, 'list_port_cont': '31141779,31142021,31142168,31142381,31143458,31143686,31144012,31144061,31144553,31144579,31144620,31144689,31145706,31145751,31147614,31147658,31147696,31147743,31147772,31147811,31147860,31147907,31147949,31147990,31148038,31148059,31148111,31148137,31148178,31149287,31149336,31149359,31149406,31149469,31149494,31149528,31149579,31149610,31149662,31149700,31149738,31149783,31149812,31149843,31149885,31149933,31149969,31152295,31152379,31152460,31152531,31152576,31152844,31152994,31153384,31154183,31154237,31155116,31155162,31155193,31155233,31155268,31155308,31155353,31155392,31155423,31155466,31155551,31155572,31155658,31156803,31157289,31158199,31158237,31158272,31158316,31158345,31158394,31158432,31158468,31158506,31158547,31158583,31158635,31158661,31158708,31158734,31158771,31158824,31158863,31158900,31158924,31158972,31161066,31161100,31161147,31161213,31161255,31161291,31161331,31161360,31161428,31161487,31161570,31161605,31161648,31161680,31161720,31161763,31164148,31164209,31164290,31164331,3116436', 'assoc_port': '31141673:31141779,31141924:31142021,31142101:31142168,31142346:31142381,31142885:31143686,31143308:31143458,31143741:31144012,31143742:31144061,31144236:31144553,31144237:31144579,31144238:31144620,31144239:31144689,31144873:31145706,31144874:31145751,31144875:31190308,31146783:31147614,31146784:31147658,31146785:31152576,31146786:31147696,31146787:31147743,31146788:31147811,31146789:31147772,31146790:31147860,31146791:31147907,31146792:31147949,31146793:31147990,31146794:31152844,31146795:31148059,31146796:31148038,31146798:31148111,31146799:31152994,31146800:31148137,31146801:31148178,31146842:31184263,31146865:31149287,31146866:31149359,31146867:31149336,31146868:31154237,31146869:31149406,31146870:31156803,31146871:31149469,31146872:31153384,31146874:31149494,31146875:31149528,31146876:31149579,31146877:31154183,31146878:31149610,31146879:31149700,31146880:31149662,31146881:31149738,31146882:31149783,31146883:31149812,31146884:31149843,31146885:31149885,31146886:31149933,31146887:31149969,31148220:3115229', 'assoc_mat': '31141673:metal:4230:31141779,31141924:metal:4230:31142021,31142101:metal:4230:31142168,31142346:metal:4230:31142381,31142885:metal:4230:31143686,31143308:metal:4230:31143458,31143741:metal:4230:31144012,31143742:metal:4230:31144061,31144236:metal:4230:31144553,31144237:metal:4230:31144579,31144238:metal:4230:31144620,31144239:metal:4230:31144689,31144873:metal:4230:31145706,31144874:metal:4230:31145751,31144875:metal:4230:31190308,31146783:metal:4230:31147614,31146784:metal:4230:31147658,31146785:metal:4230:31152576,31146786:metal:4230:31147696,31146787:metal:4230:31147743,31146788:metal:4230:31147811,31146789:metal:4230:31147772,31146790:metal:4230:31147860,31146791:metal:4230:31147907,31146792:metal:4230:31147949,31146793:metal:4230:31147990,31146794:metal:4230:31152844,31146795:metal:4230:31148059,31146796:metal:4230:31148038,31146798:metal:4230:31148111,31146799:metal:4230:31152994,31146800:metal:4230:31148137,31146801:metal:4230:31148178,31146842:metal:4230:31184263,31146865:metal:4230:31149287,31146866:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18317728774140768, 'nb_photo': 404814, 'list_port_cont': '31141775,31142032,31142164,31142372,31142701,31142738,31143462,31143491,31143690,31144013,31144056,31144552,31144586,31144617,31144691,31145715,31145753,31147549,31147628,31147663,31147711,31147738,31147776,31147821,31147876,31147917,31147952,31147993,31148023,31148069,31148113,31148144,31148187,31149260,31149303,31149333,31149367,31149405,31149466,31149501,31149537,31149580,31149620,31149663,31149690,31149736,31149781,31149821,31149853,31149891,31149929,31149974,31150007,31152307,31152355,31152392,31152425,31152481,31152540,31152584,31152854,31152949,31152991,31153374,31154198,31154241,31155114,31155152,31155204,31155235,31155281,31155320,31155357,31155386,31155436,31155472,31155548,31155582,31155665,31156804,31157293,31158193,31158230,31158278,31158320,31158358,31158389,31158426,31158472,31158510,31158560,31158592,31158626,31158665,31158698,31158745,31158777,31158818,31158862,31158899,31158937,31158978,31161067,31161114,31161152,31161179,31161219,31161253,31161303,31161340,31161374,31161429,31161463,3116150', 'assoc_port': '31141673:31141775,31141924:31142032,31142101:31142164,31142346:31142372,31142556:31142701,31142557:31142738,31142885:31143690,31143307:31143491,31143308:31143462,31143741:31144013,31143742:31144056,31144236:31144552,31144237:31144586,31144238:31144617,31144239:31144691,31144873:31145715,31144874:31145753,31144875:31190306,31146782:31147549,31146783:31147628,31146784:31147663,31146785:31152584,31146786:31147711,31146787:31147738,31146788:31147821,31146789:31147776,31146790:31147876,31146791:31147917,31146792:31147952,31146793:31147993,31146794:31152854,31146795:31148069,31146796:31148023,31146797:31152949,31146798:31148113,31146799:31152991,31146800:31148144,31146801:31148187,31146842:31184275,31146864:31149260,31146865:31149303,31146866:31149367,31146867:31149333,31146868:31154241,31146869:31149405,31146870:31156804,31146871:31149466,31146872:31153374,31146874:31149501,31146875:31149537,31146876:31149580,31146877:31154198,31146878:31149620,31146879:31149690,31146880:31149663,31146881:31149736,31146882:3114978', 'assoc_mat': '31141673:papier:4230:31141775,31141924:papier:4230:31142032,31142101:papier:4230:31142164,31142346:papier:4230:31142372,31142556:papier:4230:31142701,31142557:papier:4230:31142738,31142885:papier:4230:31143690,31143307:papier:4230:31143491,31143308:papier:4230:31143462,31143741:papier:4230:31144013,31143742:papier:4230:31144056,31144236:papier:4230:31144552,31144237:papier:4230:31144586,31144238:papier:4230:31144617,31144239:papier:4230:31144691,31144873:papier:4230:31145715,31144874:papier:4230:31145753,31144875:papier:4230:31190306,31146782:papier:4230:31147549,31146783:papier:4230:31147628,31146784:papier:4230:31147663,31146785:papier:4230:31152584,31146786:papier:4230:31147711,31146787:papier:4230:31147738,31146788:papier:4230:31147821,31146789:papier:4230:31147776,31146790:papier:4230:31147876,31146791:papier:4230:31147917,31146792:papier:4230:31147952,31146793:papier:4230:31147993,31146794:papier:4230:31152854,31146795:papier:4230:31148069,31146796:papier:4230:31148023,31146797:papier:4230:31152949,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003531145998802526, 'nb_photo': 1896, 'list_port_cont': '31142034,31142165,31142384,31142689,31143459,31143492,31143684,31144024,31144542,31144626,31144695,31145713,31145750,31147543,31147625,31147652,31147708,31147740,31147784,31147815,31147867,31147915,31147950,31147987,31148074,31148106,31148151,31148185,31149264,31149302,31149375,31149408,31149459,31149498,31149581,31149655,31149699,31149733,31149779,31149816,31149851,31149887,31149972,31152385,31152430,31152473,31152534,31152585,31152850,31153382,31154195,31155118,31155159,31155237,31155278,31155317,31155356,31155390,31155435,31155477,31155552,31155577,31155662,31157294,31158240,31158502,31158658,31158975,31161103,31161150,31161264,31161337,31161363,31161614,31161650,31164153,31164184,31164282,31164404,31164439,31164471,31164508,31164537,31164585,31164613,31164697,31164724,31164767,31164795,31164831,31164863,31164911,31165939,31167232,31167383,31167417,31167445,31167494,31167639,31167785,31167833,31167871,31168976,31169930,31170044,31170069,31170153,31170188,31171850,31171876,31171959,31172035,31172113,3117214', 'assoc_port': '31141924:31142034,31142101:31142165,31142346:31142384,31142556:31142689,31142885:31143684,31143307:31143492,31143308:31143459,31143741:31144024,31144236:31144542,31144238:31144626,31144239:31144695,31144873:31145713,31144874:31145750,31144875:31190305,31146782:31147543,31146783:31147625,31146784:31147652,31146785:31152585,31146786:31147708,31146787:31147740,31146788:31147815,31146789:31147784,31146790:31147867,31146791:31147915,31146792:31147950,31146793:31147987,31146794:31152850,31146795:31148074,31146798:31148106,31146800:31148151,31146801:31148185,31146864:31149264,31146865:31149302,31146866:31149375,31146869:31149408,31146871:31149459,31146872:31153382,31146874:31149498,31146876:31149581,31146877:31154195,31146879:31149699,31146880:31149655,31146881:31149733,31146882:31149779,31146883:31149816,31146884:31149851,31146885:31149887,31146887:31149972,31148221:31152385,31148223:31152430,31148224:31152473,31148225:31152534,31152899:31179774,31152900:31179850,31152902:31179812,31152903:31188120,31152904:3117989', 'assoc_mat': '31141924:pehd:4230:31142034,31142101:pehd:4230:31142165,31142346:pehd:4230:31142384,31142556:pehd:4230:31142689,31142885:pehd:4230:31143684,31143307:pehd:4230:31143492,31143308:pehd:4230:31143459,31143741:pehd:4230:31144024,31144236:pehd:4230:31144542,31144238:pehd:4230:31144626,31144239:pehd:4230:31144695,31144873:pehd:4230:31145713,31144874:pehd:4230:31145750,31144875:pehd:4230:31190305,31146782:pehd:4230:31147543,31146783:pehd:4230:31147625,31146784:pehd:4230:31147652,31146785:pehd:4230:31152585,31146786:pehd:4230:31147708,31146787:pehd:4230:31147740,31146788:pehd:4230:31147815,31146789:pehd:4230:31147784,31146790:pehd:4230:31147867,31146791:pehd:4230:31147915,31146792:pehd:4230:31147950,31146793:pehd:4230:31147987,31146794:pehd:4230:31152850,31146795:pehd:4230:31148074,31146798:pehd:4230:31148106,31146800:pehd:4230:31148151,31146801:pehd:4230:31148185,31146864:pehd:4230:31149264,31146865:pehd:4230:31149302,31146866:pehd:4230:31149375,31146869:pehd:4230:31149408,31146871:pehd:4230:31149459,31146872:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010712125001778452, 'nb_photo': 18837, 'list_port_cont': '31141774,31142033,31142157,31142382,31142693,31142739,31143464,31143500,31143685,31144023,31144059,31144544,31144589,31144615,31144699,31145708,31145747,31147550,31147626,31147664,31147712,31147748,31147785,31147819,31147868,31147913,31147951,31147992,31148033,31148067,31148114,31148143,31148186,31149248,31149291,31149334,31149376,31149409,31149462,31149497,31149538,31149583,31149616,31149649,31149687,31149725,31149774,31149817,31149854,31149884,31149931,31149976,31150011,31152308,31152353,31152383,31152429,31152469,31152538,31152583,31152847,31152954,31152981,31153381,31154200,31154242,31155124,31155158,31155202,31155241,31155276,31155321,31155355,31155396,31155437,31155475,31155553,31155589,31155663,31156798,31157296,31158201,31158241,31158275,31158310,31158356,31158390,31158433,31158463,31158499,31158552,31158597,31158629,31158662,31158709,31158744,31158785,31158819,31158861,31158894,31158931,31158977,31161078,31161110,31161154,31161188,31161218,31161262,31161299,31161335,31161369,31161420,31161459,3116149', 'assoc_port': '31141673:31141774,31141924:31142033,31142101:31142157,31142346:31142382,31142556:31142693,31142557:31142739,31142885:31143685,31143307:31143500,31143308:31143464,31143741:31144023,31143742:31144059,31144236:31144544,31144237:31144589,31144238:31144615,31144239:31144699,31144873:31145708,31144874:31145747,31144875:31190300,31146782:31147550,31146783:31147626,31146784:31147664,31146785:31152583,31146786:31147712,31146787:31147748,31146788:31147819,31146789:31147785,31146790:31147868,31146791:31147913,31146792:31147951,31146793:31147992,31146794:31152847,31146795:31148067,31146796:31148033,31146797:31152954,31146798:31148114,31146799:31152981,31146800:31148143,31146801:31148186,31146842:31184272,31146864:31149248,31146865:31149291,31146866:31149376,31146867:31149334,31146868:31154242,31146869:31149409,31146870:31156798,31146871:31149462,31146872:31153381,31146874:31149497,31146875:31149538,31146876:31149583,31146877:31154200,31146878:31149616,31146879:31149687,31146880:31149649,31146881:31149725,31146882:3114977', 'assoc_mat': '31141673:pet_clair:4230:31141774,31141924:pet_clair:4230:31142033,31142101:pet_clair:4230:31142157,31142346:pet_clair:4230:31142382,31142556:pet_clair:4230:31142693,31142557:pet_clair:4230:31142739,31142885:pet_clair:4230:31143685,31143307:pet_clair:4230:31143500,31143308:pet_clair:4230:31143464,31143741:pet_clair:4230:31144023,31143742:pet_clair:4230:31144059,31144236:pet_clair:4230:31144544,31144237:pet_clair:4230:31144589,31144238:pet_clair:4230:31144615,31144239:pet_clair:4230:31144699,31144873:pet_clair:4230:31145708,31144874:pet_clair:4230:31145747,31144875:pet_clair:4230:31190300,31146782:pet_clair:4230:31147550,31146783:pet_clair:4230:31147626,31146784:pet_clair:4230:31147664,31146785:pet_clair:4230:31152583,31146786:pet_clair:4230:31147712,31146787:pet_clair:4230:31147748,31146788:pet_clair:4230:31147819,31146789:pet_clair:4230:31147785,31146790:pet_clair:4230:31147868,31146791:pet_clair:4230:31147913,31146792:pet_clair:4230:31147951,31146793:pet_clair:4230:31147992,31146794:pet_clair:4230:31152847,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022412327478405054, 'nb_photo': 1038, 'list_port_cont': '31141766,31142036,31142697,31143460,31143502,31143689,31144016,31144581,31144693,31147616,31147665,31147713,31147783,31147818,31147871,31147914,31147956,31147983,31148037,31148153,31149259,31149300,31149337,31149365,31149412,31149457,31149499,31149539,31149586,31149614,31149653,31149694,31149731,31149784,31149819,31149850,31149895,31149922,31149967,31150010,31152387,31152475,31152539,31152575,31152860,31152944,31152996,31153376,31154190,31154239,31155205,31155280,31155385,31155427,31155473,31155550,31155588,31155659,31156808,31157297,31158204,31158269,31158387,31158422,31158558,31158893,31158935,31161075,31161260,31161301,31161426,31161453,31161757,31164261,31164359,31164514,31164615,31164732,31164753,31164804,31167450,31167568,31167643,31167674,31170080,31170158,31170222,31171851,31171888,31171958,31172031,31172105,31174395,31174435,31174497,31174702,31174738,31176353,31176428,31176459,31176503,31176533,31178094,31178242,31179776,31179820,31179929,31179963,31180007,31180068,31180156,31180266,31180338,3118212', 'assoc_port': '31141673:31141766,31141924:31142036,31142556:31142697,31142885:31143689,31143307:31143502,31143308:31143460,31143741:31144016,31144237:31144581,31144239:31144693,31146783:31147616,31146784:31147665,31146785:31152575,31146786:31147713,31146788:31147818,31146789:31147783,31146790:31147871,31146791:31147914,31146792:31147956,31146793:31147983,31146794:31152860,31146796:31148037,31146797:31152944,31146799:31152996,31146800:31148153,31146864:31149259,31146865:31149300,31146866:31149365,31146867:31149337,31146868:31154239,31146869:31149412,31146870:31156808,31146871:31149457,31146872:31153376,31146874:31149499,31146875:31149539,31146876:31149586,31146877:31154190,31146878:31149614,31146879:31149694,31146880:31149653,31146881:31149731,31146882:31149784,31146883:31149819,31146884:31149850,31146885:31149895,31146886:31149922,31146887:31149967,31146888:31150010,31148221:31152387,31148224:31152475,31148225:31152539,31152899:31179776,31152902:31179820,31152903:31188115,31152905:31179963,31152906:31179929,31152907:3118000', 'assoc_mat': '31141673:pet_fonce:4230:31141766,31141924:pet_fonce:4230:31142036,31142556:pet_fonce:4230:31142697,31142885:pet_fonce:4230:31143689,31143307:pet_fonce:4230:31143502,31143308:pet_fonce:4230:31143460,31143741:pet_fonce:4230:31144016,31144237:pet_fonce:4230:31144581,31144239:pet_fonce:4230:31144693,31146783:pet_fonce:4230:31147616,31146784:pet_fonce:4230:31147665,31146785:pet_fonce:4230:31152575,31146786:pet_fonce:4230:31147713,31146788:pet_fonce:4230:31147818,31146789:pet_fonce:4230:31147783,31146790:pet_fonce:4230:31147871,31146791:pet_fonce:4230:31147914,31146792:pet_fonce:4230:31147956,31146793:pet_fonce:4230:31147983,31146794:pet_fonce:4230:31152860,31146796:pet_fonce:4230:31148037,31146797:pet_fonce:4230:31152944,31146799:pet_fonce:4230:31152996,31146800:pet_fonce:4230:31148153,31146864:pet_fonce:4230:31149259,31146865:pet_fonce:4230:31149300,31146866:pet_fonce:4230:31149365,31146867:pet_fonce:4230:31149337,31146868:pet_fonce:4230:31154239,31146869:pet_fonce:4230:31149412,31146870:pet_fonce:4230:31156808,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(3002274,2996338,2996314,3001674,3001188,2997662,2998116,2998636,2999166,2999792,3000336,3000780,3001290,3001826,3002432,3002776,3003142,3003566,3004098,3004258)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197042, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141769,31142027,31142154,31142388,31142696,31142741,31143449,31143488,31143692,31144021,31144047,31144548,31144588,31144613,31144686,31145701,31145754,31147551,31147613,31147650,31147706,31147734,31147781,31147807,31147862,31147906,31147960,31147995,31148031,31148062,31148110,31148147,31148190,31149252,31149286,31149330,31149368,31149414,31149468,31149503,31149532,31149584,31149622,31149650,31149689,31149737,31149775,31149804,31149857,31149892,31149926,31149961,31150006,31152312,31152339,31152390,31152422,31152459,31152541,31152568,31152853,31152939,31152992,31153385,31154199,31154230,31155111,31155153,31155200,31155231,31155269,31155309,31155346,31155397,31155431,31155474,31155538,31155581,31155654,31156811,31157290,31158200,31158232,31158273,31158307,31158346,31158377,31158421,31158473,31158509,31158551,31158593,31158631,31158664,31158702,31158749,31158773,31158816,31158856,31158898,31158922,31158979,31161061,31161107,31161145,31161190,31161223,31161258,31161300,31161332,31161371,31161427,31161465,3116150 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197043, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141777,31142022,31142158,31142383,31142702,31142743,31143450,31143499,31143691,31144018,31144060,31144550,31144590,31144619,31144690,31145707,31145752,31147548,31147619,31147655,31147705,31147746,31147777,31147823,31147872,31147918,31147958,31147994,31148032,31148072,31148102,31148145,31148193,31149263,31149295,31149340,31149372,31149416,31149464,31149505,31149543,31149587,31149623,31149657,31149692,31149732,31149776,31149807,31149856,31149896,31149918,31149975,31150004,31152310,31152352,31152378,31152426,31152464,31152545,31152577,31152851,31152955,31152989,31153379,31154192,31154236,31155120,31155163,31155192,31155242,31155267,31155322,31155349,31155387,31155434,31155478,31155543,31155587,31155655,31156809,31157291,31158203,31158236,31158266,31158321,31158354,31158385,31158431,31158466,31158504,31158549,31158598,31158634,31158663,31158699,31158742,31158783,31158820,31158852,31158897,31158938,31158974,31161076,31161109,31161149,31161186,31161224,31161263,31161296,31161334,31161367,31161423,31161455,3116149 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197044, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141779,31142021,31142168,31142381,31143458,31143686,31144012,31144061,31144553,31144579,31144620,31144689,31145706,31145751,31147614,31147658,31147696,31147743,31147772,31147811,31147860,31147907,31147949,31147990,31148038,31148059,31148111,31148137,31148178,31149287,31149336,31149359,31149406,31149469,31149494,31149528,31149579,31149610,31149662,31149700,31149738,31149783,31149812,31149843,31149885,31149933,31149969,31152295,31152379,31152460,31152531,31152576,31152844,31152994,31153384,31154183,31154237,31155116,31155162,31155193,31155233,31155268,31155308,31155353,31155392,31155423,31155466,31155551,31155572,31155658,31156803,31157289,31158199,31158237,31158272,31158316,31158345,31158394,31158432,31158468,31158506,31158547,31158583,31158635,31158661,31158708,31158734,31158771,31158824,31158863,31158900,31158924,31158972,31161066,31161100,31161147,31161213,31161255,31161291,31161331,31161360,31161428,31161487,31161570,31161605,31161648,31161680,31161720,31161763,31164148,31164209,31164290,31164331,3116436 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197045, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141775,31142032,31142164,31142372,31142701,31142738,31143462,31143491,31143690,31144013,31144056,31144552,31144586,31144617,31144691,31145715,31145753,31147549,31147628,31147663,31147711,31147738,31147776,31147821,31147876,31147917,31147952,31147993,31148023,31148069,31148113,31148144,31148187,31149260,31149303,31149333,31149367,31149405,31149466,31149501,31149537,31149580,31149620,31149663,31149690,31149736,31149781,31149821,31149853,31149891,31149929,31149974,31150007,31152307,31152355,31152392,31152425,31152481,31152540,31152584,31152854,31152949,31152991,31153374,31154198,31154241,31155114,31155152,31155204,31155235,31155281,31155320,31155357,31155386,31155436,31155472,31155548,31155582,31155665,31156804,31157293,31158193,31158230,31158278,31158320,31158358,31158389,31158426,31158472,31158510,31158560,31158592,31158626,31158665,31158698,31158745,31158777,31158818,31158862,31158899,31158937,31158978,31161067,31161114,31161152,31161179,31161219,31161253,31161303,31161340,31161374,31161429,31161463,3116150 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197046, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31142034,31142165,31142384,31142689,31143459,31143492,31143684,31144024,31144542,31144626,31144695,31145713,31145750,31147543,31147625,31147652,31147708,31147740,31147784,31147815,31147867,31147915,31147950,31147987,31148074,31148106,31148151,31148185,31149264,31149302,31149375,31149408,31149459,31149498,31149581,31149655,31149699,31149733,31149779,31149816,31149851,31149887,31149972,31152385,31152430,31152473,31152534,31152585,31152850,31153382,31154195,31155118,31155159,31155237,31155278,31155317,31155356,31155390,31155435,31155477,31155552,31155577,31155662,31157294,31158240,31158502,31158658,31158975,31161103,31161150,31161264,31161337,31161363,31161614,31161650,31164153,31164184,31164282,31164404,31164439,31164471,31164508,31164537,31164585,31164613,31164697,31164724,31164767,31164795,31164831,31164863,31164911,31165939,31167232,31167383,31167417,31167445,31167494,31167639,31167785,31167833,31167871,31168976,31169930,31170044,31170069,31170153,31170188,31171850,31171876,31171959,31172035,31172113,3117214 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197047, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141774,31142033,31142157,31142382,31142693,31142739,31143464,31143500,31143685,31144023,31144059,31144544,31144589,31144615,31144699,31145708,31145747,31147550,31147626,31147664,31147712,31147748,31147785,31147819,31147868,31147913,31147951,31147992,31148033,31148067,31148114,31148143,31148186,31149248,31149291,31149334,31149376,31149409,31149462,31149497,31149538,31149583,31149616,31149649,31149687,31149725,31149774,31149817,31149854,31149884,31149931,31149976,31150011,31152308,31152353,31152383,31152429,31152469,31152538,31152583,31152847,31152954,31152981,31153381,31154200,31154242,31155124,31155158,31155202,31155241,31155276,31155321,31155355,31155396,31155437,31155475,31155553,31155589,31155663,31156798,31157296,31158201,31158241,31158275,31158310,31158356,31158390,31158433,31158463,31158499,31158552,31158597,31158629,31158662,31158709,31158744,31158785,31158819,31158861,31158894,31158931,31158977,31161078,31161110,31161154,31161188,31161218,31161262,31161299,31161335,31161369,31161420,31161459,3116149 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31197048, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31141766,31142036,31142697,31143460,31143502,31143689,31144016,31144581,31144693,31147616,31147665,31147713,31147783,31147818,31147871,31147914,31147956,31147983,31148037,31148153,31149259,31149300,31149337,31149365,31149412,31149457,31149499,31149539,31149586,31149614,31149653,31149694,31149731,31149784,31149819,31149850,31149895,31149922,31149967,31150010,31152387,31152475,31152539,31152575,31152860,31152944,31152996,31153376,31154190,31154239,31155205,31155280,31155385,31155427,31155473,31155550,31155588,31155659,31156808,31157297,31158204,31158269,31158387,31158422,31158558,31158893,31158935,31161075,31161260,31161301,31161426,31161453,31161757,31164261,31164359,31164514,31164615,31164732,31164753,31164804,31167450,31167568,31167643,31167674,31170080,31170158,31170222,31171851,31171888,31171958,31172031,31172105,31174395,31174435,31174497,31174702,31174738,31176353,31176428,31176459,31176503,31176533,31178094,31178242,31179776,31179820,31179929,31179963,31180007,31180068,31180156,31180266,31180338,3118212 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31197042,31197043,31197044,31197045,31197046,31197047,31197048?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-06-01' and date <= '2026-06-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((704,),), 'unwanted_material_monthly_percentage': ((0.7499980868314844,),), 'material_repartition': (('incineration', 700),), 'material_dict': {'incineration': 700}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 6, 1), 0.7292214241389781, 2), (datetime.date(2026, 6, 10), 0.7045081247142333, 1), (datetime.date(2026, 6, 11), 0.7140958852123527, 1), (datetime.date(2026, 6, 12), 0.6850462479377323, 1), (datetime.date(2026, 6, 13), 0.6895736875242624, 1), (datetime.date(2026, 6, 14), 0.8218841318130097, 2), (datetime.date(2026, 6, 15), 0.801134294767754, 2), (datetime.date(2026, 6, 16), 0.7743403597011145, 2), (datetime.date(2026, 6, 17), 0.8037040267640145, 1), (datetime.date(2026, 6, 18), 0.8027934667388921, 2), (datetime.date(2026, 6, 19), 0.7768402209549823, 2), (datetime.date(2026, 6, 20), 0.7555420280556414, 2), (datetime.date(2026, 6, 21), 0.8100942125801677, 1), (datetime.date(2026, 6, 22), 0.8154361281548289, 1), (datetime.date(2026, 6, 23), 0.8055754927903156, 1), (datetime.date(2026, 6, 24), 0.6939901609272255, 3), (datetime.date(2026, 6, 25), 0.7148413252622087, 1), (datetime.date(2026, 6, 26), 0.7014286495353935, 1), (datetime.date(2026, 6, 27), 0.6956963271773087, 1), (datetime.date(2026, 6, 28), 0.7213458705595204, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 6, 1), 0.7292214241389781, 2), (datetime.date(2026, 6, 10), 0.7045081247142333, 1), (datetime.date(2026, 6, 11), 0.7140958852123527, 1), (datetime.date(2026, 6, 12), 0.6850462479377323, 1), (datetime.date(2026, 6, 13), 0.6895736875242624, 1), (datetime.date(2026, 6, 14), 0.8218841318130097, 2), (datetime.date(2026, 6, 15), 0.801134294767754, 2), (datetime.date(2026, 6, 16), 0.7743403597011145, 2), (datetime.date(2026, 6, 17), 0.8037040267640145, 1), (datetime.date(2026, 6, 18), 0.8027934667388921, 2), (datetime.date(2026, 6, 19), 0.7768402209549823, 2), (datetime.date(2026, 6, 20), 0.7555420280556414, 2), (datetime.date(2026, 6, 21), 0.8100942125801677, 1), (datetime.date(2026, 6, 22), 0.8154361281548289, 1), (datetime.date(2026, 6, 23), 0.8055754927903156, 1), (datetime.date(2026, 6, 24), 0.6939901609272255, 3), (datetime.date(2026, 6, 25), 0.7148413252622087, 1), (datetime.date(2026, 6, 26), 0.7014286495353935, 1), (datetime.date(2026, 6, 27), 0.6956963271773087, 1), (datetime.date(2026, 6, 28), 0.7213458705595204, 1))}, 'quality_array': [['-9.024295910998239', '01062026'], ['-8.799051286401388', '10062026'], ['-8.88314241051677', '11062026'], ['-9.059154987056148', '12062026'], ['-8.93346659194772', '13062026'], ['-8.640301794323634', '14062026'], ['-8.264874511420755', '15062026'], ['-8.620067051899994', '16062026'], ['-8.442374421404192', '17062026'], ['-8.399776701000523', '18062026'], ['-8.828466156220443', '19062026'], ['-8.710116762318346', '20062026'], ['-8.898631644190182', '21062026'], ['-8.69914725933626', '22062026'], ['-8.458970485782068', '23062026'], ['-8.718855042733868', '24062026'], ['-8.562023153606226', '25062026'], ['-8.334317292262812', '26062026'], ['-8.573550487776439', '27062026'], ['-8.986330016338142', '28062026']], 'number_of_batch': ((376,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015785903388376134, 'nb_photo': 17871, 'list_port_cont': '31141769,31142027,31142154,31142388,31142696,31142741,31143449,31143488,31143692,31144021,31144047,31144548,31144588,31144613,31144686,31145701,31145754,31147551,31147613,31147650,31147706,31147734,31147781,31147807,31147862,31147906,31147960,31147995,31148031,31148062,31148110,31148147,31148190,31149252,31149286,31149330,31149368,31149414,31149468,31149503,31149532,31149584,31149622,31149650,31149689,31149737,31149775,31149804,31149857,31149892,31149926,31149961,31150006,31152312,31152339,31152390,31152422,31152459,31152541,31152568,31152853,31152939,31152992,31153385,31154199,31154230,31155111,31155153,31155200,31155231,31155269,31155309,31155346,31155397,31155431,31155474,31155538,31155581,31155654,31156811,31157290,31158200,31158232,31158273,31158307,31158346,31158377,31158421,31158473,31158509,31158551,31158593,31158631,31158664,31158702,31158749,31158773,31158816,31158856,31158898,31158922,31158979,31161061,31161107,31161145,31161190,31161223,31161258,31161300,31161332,31161371,31161427,31161465,3116150', 'assoc_port': '31141673:31141769,31141924:31142027,31142101:31142154,31142346:31142388,31142556:31142696,31142557:31142741,31142885:31143692,31143307:31143488,31143308:31143449,31143741:31144021,31143742:31144047,31144236:31144548,31144237:31144588,31144238:31144613,31144239:31144686,31144873:31145701,31144874:31145754,31144875:31190295,31146782:31147551,31146783:31147613,31146784:31147650,31146785:31152568,31146786:31147706,31146787:31147734,31146788:31147807,31146789:31147781,31146790:31147862,31146791:31147906,31146792:31147960,31146793:31147995,31146794:31152853,31146795:31148062,31146796:31148031,31146797:31152939,31146798:31148110,31146799:31152992,31146800:31148147,31146801:31148190,31146842:31184259,31146864:31149252,31146865:31149286,31146866:31149368,31146867:31149330,31146868:31154230,31146869:31149414,31146870:31156811,31146871:31149468,31146872:31153385,31146874:31149503,31146875:31149532,31146876:31149584,31146877:31154199,31146878:31149622,31146879:31149689,31146880:31149650,31146881:31149737,31146882:3114977', 'assoc_mat': '31141673:autre:4230:31141769,31141924:autre:4230:31142027,31142101:autre:4230:31142154,31142346:autre:4230:31142388,31142556:autre:4230:31142696,31142557:autre:4230:31142741,31142885:autre:4230:31143692,31143307:autre:4230:31143488,31143308:autre:4230:31143449,31143741:autre:4230:31144021,31143742:autre:4230:31144047,31144236:autre:4230:31144548,31144237:autre:4230:31144588,31144238:autre:4230:31144613,31144239:autre:4230:31144686,31144873:autre:4230:31145701,31144874:autre:4230:31145754,31144875:autre:4230:31190295,31146782:autre:4230:31147551,31146783:autre:4230:31147613,31146784:autre:4230:31147650,31146785:autre:4230:31152568,31146786:autre:4230:31147706,31146787:autre:4230:31147734,31146788:autre:4230:31147807,31146789:autre:4230:31147781,31146790:autre:4230:31147862,31146791:autre:4230:31147906,31146792:autre:4230:31147960,31146793:autre:4230:31147995,31146794:autre:4230:31152853,31146795:autre:4230:31148062,31146796:autre:4230:31148031,31146797:autre:4230:31152939,31146798:autre:4230:31148110,31146799:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06466775374868074, 'nb_photo': 112807, 'list_port_cont': '31141777,31142022,31142158,31142383,31142702,31142743,31143450,31143499,31143691,31144018,31144060,31144550,31144590,31144619,31144690,31145707,31145752,31147548,31147619,31147655,31147705,31147746,31147777,31147823,31147872,31147918,31147958,31147994,31148032,31148072,31148102,31148145,31148193,31149263,31149295,31149340,31149372,31149416,31149464,31149505,31149543,31149587,31149623,31149657,31149692,31149732,31149776,31149807,31149856,31149896,31149918,31149975,31150004,31152310,31152352,31152378,31152426,31152464,31152545,31152577,31152851,31152955,31152989,31153379,31154192,31154236,31155120,31155163,31155192,31155242,31155267,31155322,31155349,31155387,31155434,31155478,31155543,31155587,31155655,31156809,31157291,31158203,31158236,31158266,31158321,31158354,31158385,31158431,31158466,31158504,31158549,31158598,31158634,31158663,31158699,31158742,31158783,31158820,31158852,31158897,31158938,31158974,31161076,31161109,31161149,31161186,31161224,31161263,31161296,31161334,31161367,31161423,31161455,3116149', 'assoc_port': '31141673:31141777,31141924:31142022,31142101:31142158,31142346:31142383,31142556:31142702,31142557:31142743,31142885:31143691,31143307:31143499,31143308:31143450,31143741:31144018,31143742:31144060,31144236:31144550,31144237:31144590,31144238:31144619,31144239:31144690,31144873:31145707,31144874:31145752,31144875:31190304,31146782:31147548,31146783:31147619,31146784:31147655,31146785:31152577,31146786:31147705,31146787:31147746,31146788:31147823,31146789:31147777,31146790:31147872,31146791:31147918,31146792:31147958,31146793:31147994,31146794:31152851,31146795:31148072,31146796:31148032,31146797:31152955,31146798:31148102,31146799:31152989,31146800:31148145,31146801:31148193,31146842:31184270,31146864:31149263,31146865:31149295,31146866:31149372,31146867:31149340,31146868:31154236,31146869:31149416,31146870:31156809,31146871:31149464,31146872:31153379,31146874:31149505,31146875:31149543,31146876:31149587,31146877:31154192,31146878:31149623,31146879:31149692,31146880:31149657,31146881:31149732,31146882:3114977', 'assoc_mat': '31141673:carton:4230:31141777,31141924:carton:4230:31142022,31142101:carton:4230:31142158,31142346:carton:4230:31142383,31142556:carton:4230:31142702,31142557:carton:4230:31142743,31142885:carton:4230:31143691,31143307:carton:4230:31143499,31143308:carton:4230:31143450,31143741:carton:4230:31144018,31143742:carton:4230:31144060,31144236:carton:4230:31144550,31144237:carton:4230:31144590,31144238:carton:4230:31144619,31144239:carton:4230:31144690,31144873:carton:4230:31145707,31144874:carton:4230:31145752,31144875:carton:4230:31190304,31146782:carton:4230:31147548,31146783:carton:4230:31147619,31146784:carton:4230:31147655,31146785:carton:4230:31152577,31146786:carton:4230:31147705,31146787:carton:4230:31147746,31146788:carton:4230:31147823,31146789:carton:4230:31147777,31146790:carton:4230:31147872,31146791:carton:4230:31147918,31146792:carton:4230:31147958,31146793:carton:4230:31147994,31146794:carton:4230:31152851,31146795:carton:4230:31148072,31146796:carton:4230:31148032,31146797:carton:4230:31152955,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001700040910576424, 'nb_photo': 2680, 'list_port_cont': '31141779,31142021,31142168,31142381,31143458,31143686,31144012,31144061,31144553,31144579,31144620,31144689,31145706,31145751,31147614,31147658,31147696,31147743,31147772,31147811,31147860,31147907,31147949,31147990,31148038,31148059,31148111,31148137,31148178,31149287,31149336,31149359,31149406,31149469,31149494,31149528,31149579,31149610,31149662,31149700,31149738,31149783,31149812,31149843,31149885,31149933,31149969,31152295,31152379,31152460,31152531,31152576,31152844,31152994,31153384,31154183,31154237,31155116,31155162,31155193,31155233,31155268,31155308,31155353,31155392,31155423,31155466,31155551,31155572,31155658,31156803,31157289,31158199,31158237,31158272,31158316,31158345,31158394,31158432,31158468,31158506,31158547,31158583,31158635,31158661,31158708,31158734,31158771,31158824,31158863,31158900,31158924,31158972,31161066,31161100,31161147,31161213,31161255,31161291,31161331,31161360,31161428,31161487,31161570,31161605,31161648,31161680,31161720,31161763,31164148,31164209,31164290,31164331,3116436', 'assoc_port': '31141673:31141779,31141924:31142021,31142101:31142168,31142346:31142381,31142885:31143686,31143308:31143458,31143741:31144012,31143742:31144061,31144236:31144553,31144237:31144579,31144238:31144620,31144239:31144689,31144873:31145706,31144874:31145751,31144875:31190308,31146783:31147614,31146784:31147658,31146785:31152576,31146786:31147696,31146787:31147743,31146788:31147811,31146789:31147772,31146790:31147860,31146791:31147907,31146792:31147949,31146793:31147990,31146794:31152844,31146795:31148059,31146796:31148038,31146798:31148111,31146799:31152994,31146800:31148137,31146801:31148178,31146842:31184263,31146865:31149287,31146866:31149359,31146867:31149336,31146868:31154237,31146869:31149406,31146870:31156803,31146871:31149469,31146872:31153384,31146874:31149494,31146875:31149528,31146876:31149579,31146877:31154183,31146878:31149610,31146879:31149700,31146880:31149662,31146881:31149738,31146882:31149783,31146883:31149812,31146884:31149843,31146885:31149885,31146886:31149933,31146887:31149969,31148220:3115229', 'assoc_mat': '31141673:metal:4230:31141779,31141924:metal:4230:31142021,31142101:metal:4230:31142168,31142346:metal:4230:31142381,31142885:metal:4230:31143686,31143308:metal:4230:31143458,31143741:metal:4230:31144012,31143742:metal:4230:31144061,31144236:metal:4230:31144553,31144237:metal:4230:31144579,31144238:metal:4230:31144620,31144239:metal:4230:31144689,31144873:metal:4230:31145706,31144874:metal:4230:31145751,31144875:metal:4230:31190308,31146783:metal:4230:31147614,31146784:metal:4230:31147658,31146785:metal:4230:31152576,31146786:metal:4230:31147696,31146787:metal:4230:31147743,31146788:metal:4230:31147811,31146789:metal:4230:31147772,31146790:metal:4230:31147860,31146791:metal:4230:31147907,31146792:metal:4230:31147949,31146793:metal:4230:31147990,31146794:metal:4230:31152844,31146795:metal:4230:31148059,31146796:metal:4230:31148038,31146798:metal:4230:31148111,31146799:metal:4230:31152994,31146800:metal:4230:31148137,31146801:metal:4230:31148178,31146842:metal:4230:31184263,31146865:metal:4230:31149287,31146866:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18317728774140768, 'nb_photo': 404814, 'list_port_cont': '31141775,31142032,31142164,31142372,31142701,31142738,31143462,31143491,31143690,31144013,31144056,31144552,31144586,31144617,31144691,31145715,31145753,31147549,31147628,31147663,31147711,31147738,31147776,31147821,31147876,31147917,31147952,31147993,31148023,31148069,31148113,31148144,31148187,31149260,31149303,31149333,31149367,31149405,31149466,31149501,31149537,31149580,31149620,31149663,31149690,31149736,31149781,31149821,31149853,31149891,31149929,31149974,31150007,31152307,31152355,31152392,31152425,31152481,31152540,31152584,31152854,31152949,31152991,31153374,31154198,31154241,31155114,31155152,31155204,31155235,31155281,31155320,31155357,31155386,31155436,31155472,31155548,31155582,31155665,31156804,31157293,31158193,31158230,31158278,31158320,31158358,31158389,31158426,31158472,31158510,31158560,31158592,31158626,31158665,31158698,31158745,31158777,31158818,31158862,31158899,31158937,31158978,31161067,31161114,31161152,31161179,31161219,31161253,31161303,31161340,31161374,31161429,31161463,3116150', 'assoc_port': '31141673:31141775,31141924:31142032,31142101:31142164,31142346:31142372,31142556:31142701,31142557:31142738,31142885:31143690,31143307:31143491,31143308:31143462,31143741:31144013,31143742:31144056,31144236:31144552,31144237:31144586,31144238:31144617,31144239:31144691,31144873:31145715,31144874:31145753,31144875:31190306,31146782:31147549,31146783:31147628,31146784:31147663,31146785:31152584,31146786:31147711,31146787:31147738,31146788:31147821,31146789:31147776,31146790:31147876,31146791:31147917,31146792:31147952,31146793:31147993,31146794:31152854,31146795:31148069,31146796:31148023,31146797:31152949,31146798:31148113,31146799:31152991,31146800:31148144,31146801:31148187,31146842:31184275,31146864:31149260,31146865:31149303,31146866:31149367,31146867:31149333,31146868:31154241,31146869:31149405,31146870:31156804,31146871:31149466,31146872:31153374,31146874:31149501,31146875:31149537,31146876:31149580,31146877:31154198,31146878:31149620,31146879:31149690,31146880:31149663,31146881:31149736,31146882:3114978', 'assoc_mat': '31141673:papier:4230:31141775,31141924:papier:4230:31142032,31142101:papier:4230:31142164,31142346:papier:4230:31142372,31142556:papier:4230:31142701,31142557:papier:4230:31142738,31142885:papier:4230:31143690,31143307:papier:4230:31143491,31143308:papier:4230:31143462,31143741:papier:4230:31144013,31143742:papier:4230:31144056,31144236:papier:4230:31144552,31144237:papier:4230:31144586,31144238:papier:4230:31144617,31144239:papier:4230:31144691,31144873:papier:4230:31145715,31144874:papier:4230:31145753,31144875:papier:4230:31190306,31146782:papier:4230:31147549,31146783:papier:4230:31147628,31146784:papier:4230:31147663,31146785:papier:4230:31152584,31146786:papier:4230:31147711,31146787:papier:4230:31147738,31146788:papier:4230:31147821,31146789:papier:4230:31147776,31146790:papier:4230:31147876,31146791:papier:4230:31147917,31146792:papier:4230:31147952,31146793:papier:4230:31147993,31146794:papier:4230:31152854,31146795:papier:4230:31148069,31146796:papier:4230:31148023,31146797:papier:4230:31152949,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003531145998802526, 'nb_photo': 1896, 'list_port_cont': '31142034,31142165,31142384,31142689,31143459,31143492,31143684,31144024,31144542,31144626,31144695,31145713,31145750,31147543,31147625,31147652,31147708,31147740,31147784,31147815,31147867,31147915,31147950,31147987,31148074,31148106,31148151,31148185,31149264,31149302,31149375,31149408,31149459,31149498,31149581,31149655,31149699,31149733,31149779,31149816,31149851,31149887,31149972,31152385,31152430,31152473,31152534,31152585,31152850,31153382,31154195,31155118,31155159,31155237,31155278,31155317,31155356,31155390,31155435,31155477,31155552,31155577,31155662,31157294,31158240,31158502,31158658,31158975,31161103,31161150,31161264,31161337,31161363,31161614,31161650,31164153,31164184,31164282,31164404,31164439,31164471,31164508,31164537,31164585,31164613,31164697,31164724,31164767,31164795,31164831,31164863,31164911,31165939,31167232,31167383,31167417,31167445,31167494,31167639,31167785,31167833,31167871,31168976,31169930,31170044,31170069,31170153,31170188,31171850,31171876,31171959,31172035,31172113,3117214', 'assoc_port': '31141924:31142034,31142101:31142165,31142346:31142384,31142556:31142689,31142885:31143684,31143307:31143492,31143308:31143459,31143741:31144024,31144236:31144542,31144238:31144626,31144239:31144695,31144873:31145713,31144874:31145750,31144875:31190305,31146782:31147543,31146783:31147625,31146784:31147652,31146785:31152585,31146786:31147708,31146787:31147740,31146788:31147815,31146789:31147784,31146790:31147867,31146791:31147915,31146792:31147950,31146793:31147987,31146794:31152850,31146795:31148074,31146798:31148106,31146800:31148151,31146801:31148185,31146864:31149264,31146865:31149302,31146866:31149375,31146869:31149408,31146871:31149459,31146872:31153382,31146874:31149498,31146876:31149581,31146877:31154195,31146879:31149699,31146880:31149655,31146881:31149733,31146882:31149779,31146883:31149816,31146884:31149851,31146885:31149887,31146887:31149972,31148221:31152385,31148223:31152430,31148224:31152473,31148225:31152534,31152899:31179774,31152900:31179850,31152902:31179812,31152903:31188120,31152904:3117989', 'assoc_mat': '31141924:pehd:4230:31142034,31142101:pehd:4230:31142165,31142346:pehd:4230:31142384,31142556:pehd:4230:31142689,31142885:pehd:4230:31143684,31143307:pehd:4230:31143492,31143308:pehd:4230:31143459,31143741:pehd:4230:31144024,31144236:pehd:4230:31144542,31144238:pehd:4230:31144626,31144239:pehd:4230:31144695,31144873:pehd:4230:31145713,31144874:pehd:4230:31145750,31144875:pehd:4230:31190305,31146782:pehd:4230:31147543,31146783:pehd:4230:31147625,31146784:pehd:4230:31147652,31146785:pehd:4230:31152585,31146786:pehd:4230:31147708,31146787:pehd:4230:31147740,31146788:pehd:4230:31147815,31146789:pehd:4230:31147784,31146790:pehd:4230:31147867,31146791:pehd:4230:31147915,31146792:pehd:4230:31147950,31146793:pehd:4230:31147987,31146794:pehd:4230:31152850,31146795:pehd:4230:31148074,31146798:pehd:4230:31148106,31146800:pehd:4230:31148151,31146801:pehd:4230:31148185,31146864:pehd:4230:31149264,31146865:pehd:4230:31149302,31146866:pehd:4230:31149375,31146869:pehd:4230:31149408,31146871:pehd:4230:31149459,31146872:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010712125001778452, 'nb_photo': 18837, 'list_port_cont': '31141774,31142033,31142157,31142382,31142693,31142739,31143464,31143500,31143685,31144023,31144059,31144544,31144589,31144615,31144699,31145708,31145747,31147550,31147626,31147664,31147712,31147748,31147785,31147819,31147868,31147913,31147951,31147992,31148033,31148067,31148114,31148143,31148186,31149248,31149291,31149334,31149376,31149409,31149462,31149497,31149538,31149583,31149616,31149649,31149687,31149725,31149774,31149817,31149854,31149884,31149931,31149976,31150011,31152308,31152353,31152383,31152429,31152469,31152538,31152583,31152847,31152954,31152981,31153381,31154200,31154242,31155124,31155158,31155202,31155241,31155276,31155321,31155355,31155396,31155437,31155475,31155553,31155589,31155663,31156798,31157296,31158201,31158241,31158275,31158310,31158356,31158390,31158433,31158463,31158499,31158552,31158597,31158629,31158662,31158709,31158744,31158785,31158819,31158861,31158894,31158931,31158977,31161078,31161110,31161154,31161188,31161218,31161262,31161299,31161335,31161369,31161420,31161459,3116149', 'assoc_port': '31141673:31141774,31141924:31142033,31142101:31142157,31142346:31142382,31142556:31142693,31142557:31142739,31142885:31143685,31143307:31143500,31143308:31143464,31143741:31144023,31143742:31144059,31144236:31144544,31144237:31144589,31144238:31144615,31144239:31144699,31144873:31145708,31144874:31145747,31144875:31190300,31146782:31147550,31146783:31147626,31146784:31147664,31146785:31152583,31146786:31147712,31146787:31147748,31146788:31147819,31146789:31147785,31146790:31147868,31146791:31147913,31146792:31147951,31146793:31147992,31146794:31152847,31146795:31148067,31146796:31148033,31146797:31152954,31146798:31148114,31146799:31152981,31146800:31148143,31146801:31148186,31146842:31184272,31146864:31149248,31146865:31149291,31146866:31149376,31146867:31149334,31146868:31154242,31146869:31149409,31146870:31156798,31146871:31149462,31146872:31153381,31146874:31149497,31146875:31149538,31146876:31149583,31146877:31154200,31146878:31149616,31146879:31149687,31146880:31149649,31146881:31149725,31146882:3114977', 'assoc_mat': '31141673:pet_clair:4230:31141774,31141924:pet_clair:4230:31142033,31142101:pet_clair:4230:31142157,31142346:pet_clair:4230:31142382,31142556:pet_clair:4230:31142693,31142557:pet_clair:4230:31142739,31142885:pet_clair:4230:31143685,31143307:pet_clair:4230:31143500,31143308:pet_clair:4230:31143464,31143741:pet_clair:4230:31144023,31143742:pet_clair:4230:31144059,31144236:pet_clair:4230:31144544,31144237:pet_clair:4230:31144589,31144238:pet_clair:4230:31144615,31144239:pet_clair:4230:31144699,31144873:pet_clair:4230:31145708,31144874:pet_clair:4230:31145747,31144875:pet_clair:4230:31190300,31146782:pet_clair:4230:31147550,31146783:pet_clair:4230:31147626,31146784:pet_clair:4230:31147664,31146785:pet_clair:4230:31152583,31146786:pet_clair:4230:31147712,31146787:pet_clair:4230:31147748,31146788:pet_clair:4230:31147819,31146789:pet_clair:4230:31147785,31146790:pet_clair:4230:31147868,31146791:pet_clair:4230:31147913,31146792:pet_clair:4230:31147951,31146793:pet_clair:4230:31147992,31146794:pet_clair:4230:31152847,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022412327478405054, 'nb_photo': 1038, 'list_port_cont': '31141766,31142036,31142697,31143460,31143502,31143689,31144016,31144581,31144693,31147616,31147665,31147713,31147783,31147818,31147871,31147914,31147956,31147983,31148037,31148153,31149259,31149300,31149337,31149365,31149412,31149457,31149499,31149539,31149586,31149614,31149653,31149694,31149731,31149784,31149819,31149850,31149895,31149922,31149967,31150010,31152387,31152475,31152539,31152575,31152860,31152944,31152996,31153376,31154190,31154239,31155205,31155280,31155385,31155427,31155473,31155550,31155588,31155659,31156808,31157297,31158204,31158269,31158387,31158422,31158558,31158893,31158935,31161075,31161260,31161301,31161426,31161453,31161757,31164261,31164359,31164514,31164615,31164732,31164753,31164804,31167450,31167568,31167643,31167674,31170080,31170158,31170222,31171851,31171888,31171958,31172031,31172105,31174395,31174435,31174497,31174702,31174738,31176353,31176428,31176459,31176503,31176533,31178094,31178242,31179776,31179820,31179929,31179963,31180007,31180068,31180156,31180266,31180338,3118212', 'assoc_port': '31141673:31141766,31141924:31142036,31142556:31142697,31142885:31143689,31143307:31143502,31143308:31143460,31143741:31144016,31144237:31144581,31144239:31144693,31146783:31147616,31146784:31147665,31146785:31152575,31146786:31147713,31146788:31147818,31146789:31147783,31146790:31147871,31146791:31147914,31146792:31147956,31146793:31147983,31146794:31152860,31146796:31148037,31146797:31152944,31146799:31152996,31146800:31148153,31146864:31149259,31146865:31149300,31146866:31149365,31146867:31149337,31146868:31154239,31146869:31149412,31146870:31156808,31146871:31149457,31146872:31153376,31146874:31149499,31146875:31149539,31146876:31149586,31146877:31154190,31146878:31149614,31146879:31149694,31146880:31149653,31146881:31149731,31146882:31149784,31146883:31149819,31146884:31149850,31146885:31149895,31146886:31149922,31146887:31149967,31146888:31150010,31148221:31152387,31148224:31152475,31148225:31152539,31152899:31179776,31152902:31179820,31152903:31188115,31152905:31179963,31152906:31179929,31152907:3118000', 'assoc_mat': '31141673:pet_fonce:4230:31141766,31141924:pet_fonce:4230:31142036,31142556:pet_fonce:4230:31142697,31142885:pet_fonce:4230:31143689,31143307:pet_fonce:4230:31143502,31143308:pet_fonce:4230:31143460,31143741:pet_fonce:4230:31144016,31144237:pet_fonce:4230:31144581,31144239:pet_fonce:4230:31144693,31146783:pet_fonce:4230:31147616,31146784:pet_fonce:4230:31147665,31146785:pet_fonce:4230:31152575,31146786:pet_fonce:4230:31147713,31146788:pet_fonce:4230:31147818,31146789:pet_fonce:4230:31147783,31146790:pet_fonce:4230:31147871,31146791:pet_fonce:4230:31147914,31146792:pet_fonce:4230:31147956,31146793:pet_fonce:4230:31147983,31146794:pet_fonce:4230:31152860,31146796:pet_fonce:4230:31148037,31146797:pet_fonce:4230:31152944,31146799:pet_fonce:4230:31152996,31146800:pet_fonce:4230:31148153,31146864:pet_fonce:4230:31149259,31146865:pet_fonce:4230:31149300,31146866:pet_fonce:4230:31149365,31146867:pet_fonce:4230:31149337,31146868:pet_fonce:4230:31154239,31146869:pet_fonce:4230:31149412,31146870:pet_fonce:4230:31156808,3'}), 'main_stat': {'nb_photos': 704}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31197042,31197043,31197044,31197045,31197046,31197047,31197048?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-06', 0.7499980868314844),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((704,),), 'unwanted_material_monthly_percentage': ((0.7499980868314844,),), 'material_repartition': (('incineration', 700),), 'material_dict': {'incineration': 700}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 6, 1), 0.7292214241389781, 2), (datetime.date(2026, 6, 10), 0.7045081247142333, 1), (datetime.date(2026, 6, 11), 0.7140958852123527, 1), (datetime.date(2026, 6, 12), 0.6850462479377323, 1), (datetime.date(2026, 6, 13), 0.6895736875242624, 1), (datetime.date(2026, 6, 14), 0.8218841318130097, 2), (datetime.date(2026, 6, 15), 0.801134294767754, 2), (datetime.date(2026, 6, 16), 0.7743403597011145, 2), (datetime.date(2026, 6, 17), 0.8037040267640145, 1), (datetime.date(2026, 6, 18), 0.8027934667388921, 2), (datetime.date(2026, 6, 19), 0.7768402209549823, 2), (datetime.date(2026, 6, 20), 0.7555420280556414, 2), (datetime.date(2026, 6, 21), 0.8100942125801677, 1), (datetime.date(2026, 6, 22), 0.8154361281548289, 1), (datetime.date(2026, 6, 23), 0.8055754927903156, 1), (datetime.date(2026, 6, 24), 0.6939901609272255, 3), (datetime.date(2026, 6, 25), 0.7148413252622087, 1), (datetime.date(2026, 6, 26), 0.7014286495353935, 1), (datetime.date(2026, 6, 27), 0.6956963271773087, 1), (datetime.date(2026, 6, 28), 0.7213458705595204, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 6, 1), 0.7292214241389781, 2), (datetime.date(2026, 6, 10), 0.7045081247142333, 1), (datetime.date(2026, 6, 11), 0.7140958852123527, 1), (datetime.date(2026, 6, 12), 0.6850462479377323, 1), (datetime.date(2026, 6, 13), 0.6895736875242624, 1), (datetime.date(2026, 6, 14), 0.8218841318130097, 2), (datetime.date(2026, 6, 15), 0.801134294767754, 2), (datetime.date(2026, 6, 16), 0.7743403597011145, 2), (datetime.date(2026, 6, 17), 0.8037040267640145, 1), (datetime.date(2026, 6, 18), 0.8027934667388921, 2), (datetime.date(2026, 6, 19), 0.7768402209549823, 2), (datetime.date(2026, 6, 20), 0.7555420280556414, 2), (datetime.date(2026, 6, 21), 0.8100942125801677, 1), (datetime.date(2026, 6, 22), 0.8154361281548289, 1), (datetime.date(2026, 6, 23), 0.8055754927903156, 1), (datetime.date(2026, 6, 24), 0.6939901609272255, 3), (datetime.date(2026, 6, 25), 0.7148413252622087, 1), (datetime.date(2026, 6, 26), 0.7014286495353935, 1), (datetime.date(2026, 6, 27), 0.6956963271773087, 1), (datetime.date(2026, 6, 28), 0.7213458705595204, 1))}, 'quality_array': [['-9.024295910998239', '01062026'], ['-8.799051286401388', '10062026'], ['-8.88314241051677', '11062026'], ['-9.059154987056148', '12062026'], ['-8.93346659194772', '13062026'], ['-8.640301794323634', '14062026'], ['-8.264874511420755', '15062026'], ['-8.620067051899994', '16062026'], ['-8.442374421404192', '17062026'], ['-8.399776701000523', '18062026'], ['-8.828466156220443', '19062026'], ['-8.710116762318346', '20062026'], ['-8.898631644190182', '21062026'], ['-8.69914725933626', '22062026'], ['-8.458970485782068', '23062026'], ['-8.718855042733868', '24062026'], ['-8.562023153606226', '25062026'], ['-8.334317292262812', '26062026'], ['-8.573550487776439', '27062026'], ['-8.986330016338142', '28062026']], 'number_of_batch': ((376,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015785903388376134, 'nb_photo': 17871, 'list_port_cont': '31141769,31142027,31142154,31142388,31142696,31142741,31143449,31143488,31143692,31144021,31144047,31144548,31144588,31144613,31144686,31145701,31145754,31147551,31147613,31147650,31147706,31147734,31147781,31147807,31147862,31147906,31147960,31147995,31148031,31148062,31148110,31148147,31148190,31149252,31149286,31149330,31149368,31149414,31149468,31149503,31149532,31149584,31149622,31149650,31149689,31149737,31149775,31149804,31149857,31149892,31149926,31149961,31150006,31152312,31152339,31152390,31152422,31152459,31152541,31152568,31152853,31152939,31152992,31153385,31154199,31154230,31155111,31155153,31155200,31155231,31155269,31155309,31155346,31155397,31155431,31155474,31155538,31155581,31155654,31156811,31157290,31158200,31158232,31158273,31158307,31158346,31158377,31158421,31158473,31158509,31158551,31158593,31158631,31158664,31158702,31158749,31158773,31158816,31158856,31158898,31158922,31158979,31161061,31161107,31161145,31161190,31161223,31161258,31161300,31161332,31161371,31161427,31161465,3116150', 'assoc_port': '31141673:31141769,31141924:31142027,31142101:31142154,31142346:31142388,31142556:31142696,31142557:31142741,31142885:31143692,31143307:31143488,31143308:31143449,31143741:31144021,31143742:31144047,31144236:31144548,31144237:31144588,31144238:31144613,31144239:31144686,31144873:31145701,31144874:31145754,31144875:31190295,31146782:31147551,31146783:31147613,31146784:31147650,31146785:31152568,31146786:31147706,31146787:31147734,31146788:31147807,31146789:31147781,31146790:31147862,31146791:31147906,31146792:31147960,31146793:31147995,31146794:31152853,31146795:31148062,31146796:31148031,31146797:31152939,31146798:31148110,31146799:31152992,31146800:31148147,31146801:31148190,31146842:31184259,31146864:31149252,31146865:31149286,31146866:31149368,31146867:31149330,31146868:31154230,31146869:31149414,31146870:31156811,31146871:31149468,31146872:31153385,31146874:31149503,31146875:31149532,31146876:31149584,31146877:31154199,31146878:31149622,31146879:31149689,31146880:31149650,31146881:31149737,31146882:3114977', 'assoc_mat': '31141673:autre:4230:31141769,31141924:autre:4230:31142027,31142101:autre:4230:31142154,31142346:autre:4230:31142388,31142556:autre:4230:31142696,31142557:autre:4230:31142741,31142885:autre:4230:31143692,31143307:autre:4230:31143488,31143308:autre:4230:31143449,31143741:autre:4230:31144021,31143742:autre:4230:31144047,31144236:autre:4230:31144548,31144237:autre:4230:31144588,31144238:autre:4230:31144613,31144239:autre:4230:31144686,31144873:autre:4230:31145701,31144874:autre:4230:31145754,31144875:autre:4230:31190295,31146782:autre:4230:31147551,31146783:autre:4230:31147613,31146784:autre:4230:31147650,31146785:autre:4230:31152568,31146786:autre:4230:31147706,31146787:autre:4230:31147734,31146788:autre:4230:31147807,31146789:autre:4230:31147781,31146790:autre:4230:31147862,31146791:autre:4230:31147906,31146792:autre:4230:31147960,31146793:autre:4230:31147995,31146794:autre:4230:31152853,31146795:autre:4230:31148062,31146796:autre:4230:31148031,31146797:autre:4230:31152939,31146798:autre:4230:31148110,31146799:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06466775374868074, 'nb_photo': 112807, 'list_port_cont': '31141777,31142022,31142158,31142383,31142702,31142743,31143450,31143499,31143691,31144018,31144060,31144550,31144590,31144619,31144690,31145707,31145752,31147548,31147619,31147655,31147705,31147746,31147777,31147823,31147872,31147918,31147958,31147994,31148032,31148072,31148102,31148145,31148193,31149263,31149295,31149340,31149372,31149416,31149464,31149505,31149543,31149587,31149623,31149657,31149692,31149732,31149776,31149807,31149856,31149896,31149918,31149975,31150004,31152310,31152352,31152378,31152426,31152464,31152545,31152577,31152851,31152955,31152989,31153379,31154192,31154236,31155120,31155163,31155192,31155242,31155267,31155322,31155349,31155387,31155434,31155478,31155543,31155587,31155655,31156809,31157291,31158203,31158236,31158266,31158321,31158354,31158385,31158431,31158466,31158504,31158549,31158598,31158634,31158663,31158699,31158742,31158783,31158820,31158852,31158897,31158938,31158974,31161076,31161109,31161149,31161186,31161224,31161263,31161296,31161334,31161367,31161423,31161455,3116149', 'assoc_port': '31141673:31141777,31141924:31142022,31142101:31142158,31142346:31142383,31142556:31142702,31142557:31142743,31142885:31143691,31143307:31143499,31143308:31143450,31143741:31144018,31143742:31144060,31144236:31144550,31144237:31144590,31144238:31144619,31144239:31144690,31144873:31145707,31144874:31145752,31144875:31190304,31146782:31147548,31146783:31147619,31146784:31147655,31146785:31152577,31146786:31147705,31146787:31147746,31146788:31147823,31146789:31147777,31146790:31147872,31146791:31147918,31146792:31147958,31146793:31147994,31146794:31152851,31146795:31148072,31146796:31148032,31146797:31152955,31146798:31148102,31146799:31152989,31146800:31148145,31146801:31148193,31146842:31184270,31146864:31149263,31146865:31149295,31146866:31149372,31146867:31149340,31146868:31154236,31146869:31149416,31146870:31156809,31146871:31149464,31146872:31153379,31146874:31149505,31146875:31149543,31146876:31149587,31146877:31154192,31146878:31149623,31146879:31149692,31146880:31149657,31146881:31149732,31146882:3114977', 'assoc_mat': '31141673:carton:4230:31141777,31141924:carton:4230:31142022,31142101:carton:4230:31142158,31142346:carton:4230:31142383,31142556:carton:4230:31142702,31142557:carton:4230:31142743,31142885:carton:4230:31143691,31143307:carton:4230:31143499,31143308:carton:4230:31143450,31143741:carton:4230:31144018,31143742:carton:4230:31144060,31144236:carton:4230:31144550,31144237:carton:4230:31144590,31144238:carton:4230:31144619,31144239:carton:4230:31144690,31144873:carton:4230:31145707,31144874:carton:4230:31145752,31144875:carton:4230:31190304,31146782:carton:4230:31147548,31146783:carton:4230:31147619,31146784:carton:4230:31147655,31146785:carton:4230:31152577,31146786:carton:4230:31147705,31146787:carton:4230:31147746,31146788:carton:4230:31147823,31146789:carton:4230:31147777,31146790:carton:4230:31147872,31146791:carton:4230:31147918,31146792:carton:4230:31147958,31146793:carton:4230:31147994,31146794:carton:4230:31152851,31146795:carton:4230:31148072,31146796:carton:4230:31148032,31146797:carton:4230:31152955,3114'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001700040910576424, 'nb_photo': 2680, 'list_port_cont': '31141779,31142021,31142168,31142381,31143458,31143686,31144012,31144061,31144553,31144579,31144620,31144689,31145706,31145751,31147614,31147658,31147696,31147743,31147772,31147811,31147860,31147907,31147949,31147990,31148038,31148059,31148111,31148137,31148178,31149287,31149336,31149359,31149406,31149469,31149494,31149528,31149579,31149610,31149662,31149700,31149738,31149783,31149812,31149843,31149885,31149933,31149969,31152295,31152379,31152460,31152531,31152576,31152844,31152994,31153384,31154183,31154237,31155116,31155162,31155193,31155233,31155268,31155308,31155353,31155392,31155423,31155466,31155551,31155572,31155658,31156803,31157289,31158199,31158237,31158272,31158316,31158345,31158394,31158432,31158468,31158506,31158547,31158583,31158635,31158661,31158708,31158734,31158771,31158824,31158863,31158900,31158924,31158972,31161066,31161100,31161147,31161213,31161255,31161291,31161331,31161360,31161428,31161487,31161570,31161605,31161648,31161680,31161720,31161763,31164148,31164209,31164290,31164331,3116436', 'assoc_port': '31141673:31141779,31141924:31142021,31142101:31142168,31142346:31142381,31142885:31143686,31143308:31143458,31143741:31144012,31143742:31144061,31144236:31144553,31144237:31144579,31144238:31144620,31144239:31144689,31144873:31145706,31144874:31145751,31144875:31190308,31146783:31147614,31146784:31147658,31146785:31152576,31146786:31147696,31146787:31147743,31146788:31147811,31146789:31147772,31146790:31147860,31146791:31147907,31146792:31147949,31146793:31147990,31146794:31152844,31146795:31148059,31146796:31148038,31146798:31148111,31146799:31152994,31146800:31148137,31146801:31148178,31146842:31184263,31146865:31149287,31146866:31149359,31146867:31149336,31146868:31154237,31146869:31149406,31146870:31156803,31146871:31149469,31146872:31153384,31146874:31149494,31146875:31149528,31146876:31149579,31146877:31154183,31146878:31149610,31146879:31149700,31146880:31149662,31146881:31149738,31146882:31149783,31146883:31149812,31146884:31149843,31146885:31149885,31146886:31149933,31146887:31149969,31148220:3115229', 'assoc_mat': '31141673:metal:4230:31141779,31141924:metal:4230:31142021,31142101:metal:4230:31142168,31142346:metal:4230:31142381,31142885:metal:4230:31143686,31143308:metal:4230:31143458,31143741:metal:4230:31144012,31143742:metal:4230:31144061,31144236:metal:4230:31144553,31144237:metal:4230:31144579,31144238:metal:4230:31144620,31144239:metal:4230:31144689,31144873:metal:4230:31145706,31144874:metal:4230:31145751,31144875:metal:4230:31190308,31146783:metal:4230:31147614,31146784:metal:4230:31147658,31146785:metal:4230:31152576,31146786:metal:4230:31147696,31146787:metal:4230:31147743,31146788:metal:4230:31147811,31146789:metal:4230:31147772,31146790:metal:4230:31147860,31146791:metal:4230:31147907,31146792:metal:4230:31147949,31146793:metal:4230:31147990,31146794:metal:4230:31152844,31146795:metal:4230:31148059,31146796:metal:4230:31148038,31146798:metal:4230:31148111,31146799:metal:4230:31152994,31146800:metal:4230:31148137,31146801:metal:4230:31148178,31146842:metal:4230:31184263,31146865:metal:4230:31149287,31146866:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18317728774140768, 'nb_photo': 404814, 'list_port_cont': '31141775,31142032,31142164,31142372,31142701,31142738,31143462,31143491,31143690,31144013,31144056,31144552,31144586,31144617,31144691,31145715,31145753,31147549,31147628,31147663,31147711,31147738,31147776,31147821,31147876,31147917,31147952,31147993,31148023,31148069,31148113,31148144,31148187,31149260,31149303,31149333,31149367,31149405,31149466,31149501,31149537,31149580,31149620,31149663,31149690,31149736,31149781,31149821,31149853,31149891,31149929,31149974,31150007,31152307,31152355,31152392,31152425,31152481,31152540,31152584,31152854,31152949,31152991,31153374,31154198,31154241,31155114,31155152,31155204,31155235,31155281,31155320,31155357,31155386,31155436,31155472,31155548,31155582,31155665,31156804,31157293,31158193,31158230,31158278,31158320,31158358,31158389,31158426,31158472,31158510,31158560,31158592,31158626,31158665,31158698,31158745,31158777,31158818,31158862,31158899,31158937,31158978,31161067,31161114,31161152,31161179,31161219,31161253,31161303,31161340,31161374,31161429,31161463,3116150', 'assoc_port': '31141673:31141775,31141924:31142032,31142101:31142164,31142346:31142372,31142556:31142701,31142557:31142738,31142885:31143690,31143307:31143491,31143308:31143462,31143741:31144013,31143742:31144056,31144236:31144552,31144237:31144586,31144238:31144617,31144239:31144691,31144873:31145715,31144874:31145753,31144875:31190306,31146782:31147549,31146783:31147628,31146784:31147663,31146785:31152584,31146786:31147711,31146787:31147738,31146788:31147821,31146789:31147776,31146790:31147876,31146791:31147917,31146792:31147952,31146793:31147993,31146794:31152854,31146795:31148069,31146796:31148023,31146797:31152949,31146798:31148113,31146799:31152991,31146800:31148144,31146801:31148187,31146842:31184275,31146864:31149260,31146865:31149303,31146866:31149367,31146867:31149333,31146868:31154241,31146869:31149405,31146870:31156804,31146871:31149466,31146872:31153374,31146874:31149501,31146875:31149537,31146876:31149580,31146877:31154198,31146878:31149620,31146879:31149690,31146880:31149663,31146881:31149736,31146882:3114978', 'assoc_mat': '31141673:papier:4230:31141775,31141924:papier:4230:31142032,31142101:papier:4230:31142164,31142346:papier:4230:31142372,31142556:papier:4230:31142701,31142557:papier:4230:31142738,31142885:papier:4230:31143690,31143307:papier:4230:31143491,31143308:papier:4230:31143462,31143741:papier:4230:31144013,31143742:papier:4230:31144056,31144236:papier:4230:31144552,31144237:papier:4230:31144586,31144238:papier:4230:31144617,31144239:papier:4230:31144691,31144873:papier:4230:31145715,31144874:papier:4230:31145753,31144875:papier:4230:31190306,31146782:papier:4230:31147549,31146783:papier:4230:31147628,31146784:papier:4230:31147663,31146785:papier:4230:31152584,31146786:papier:4230:31147711,31146787:papier:4230:31147738,31146788:papier:4230:31147821,31146789:papier:4230:31147776,31146790:papier:4230:31147876,31146791:papier:4230:31147917,31146792:papier:4230:31147952,31146793:papier:4230:31147993,31146794:papier:4230:31152854,31146795:papier:4230:31148069,31146796:papier:4230:31148023,31146797:papier:4230:31152949,3114'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003531145998802526, 'nb_photo': 1896, 'list_port_cont': '31142034,31142165,31142384,31142689,31143459,31143492,31143684,31144024,31144542,31144626,31144695,31145713,31145750,31147543,31147625,31147652,31147708,31147740,31147784,31147815,31147867,31147915,31147950,31147987,31148074,31148106,31148151,31148185,31149264,31149302,31149375,31149408,31149459,31149498,31149581,31149655,31149699,31149733,31149779,31149816,31149851,31149887,31149972,31152385,31152430,31152473,31152534,31152585,31152850,31153382,31154195,31155118,31155159,31155237,31155278,31155317,31155356,31155390,31155435,31155477,31155552,31155577,31155662,31157294,31158240,31158502,31158658,31158975,31161103,31161150,31161264,31161337,31161363,31161614,31161650,31164153,31164184,31164282,31164404,31164439,31164471,31164508,31164537,31164585,31164613,31164697,31164724,31164767,31164795,31164831,31164863,31164911,31165939,31167232,31167383,31167417,31167445,31167494,31167639,31167785,31167833,31167871,31168976,31169930,31170044,31170069,31170153,31170188,31171850,31171876,31171959,31172035,31172113,3117214', 'assoc_port': '31141924:31142034,31142101:31142165,31142346:31142384,31142556:31142689,31142885:31143684,31143307:31143492,31143308:31143459,31143741:31144024,31144236:31144542,31144238:31144626,31144239:31144695,31144873:31145713,31144874:31145750,31144875:31190305,31146782:31147543,31146783:31147625,31146784:31147652,31146785:31152585,31146786:31147708,31146787:31147740,31146788:31147815,31146789:31147784,31146790:31147867,31146791:31147915,31146792:31147950,31146793:31147987,31146794:31152850,31146795:31148074,31146798:31148106,31146800:31148151,31146801:31148185,31146864:31149264,31146865:31149302,31146866:31149375,31146869:31149408,31146871:31149459,31146872:31153382,31146874:31149498,31146876:31149581,31146877:31154195,31146879:31149699,31146880:31149655,31146881:31149733,31146882:31149779,31146883:31149816,31146884:31149851,31146885:31149887,31146887:31149972,31148221:31152385,31148223:31152430,31148224:31152473,31148225:31152534,31152899:31179774,31152900:31179850,31152902:31179812,31152903:31188120,31152904:3117989', 'assoc_mat': '31141924:pehd:4230:31142034,31142101:pehd:4230:31142165,31142346:pehd:4230:31142384,31142556:pehd:4230:31142689,31142885:pehd:4230:31143684,31143307:pehd:4230:31143492,31143308:pehd:4230:31143459,31143741:pehd:4230:31144024,31144236:pehd:4230:31144542,31144238:pehd:4230:31144626,31144239:pehd:4230:31144695,31144873:pehd:4230:31145713,31144874:pehd:4230:31145750,31144875:pehd:4230:31190305,31146782:pehd:4230:31147543,31146783:pehd:4230:31147625,31146784:pehd:4230:31147652,31146785:pehd:4230:31152585,31146786:pehd:4230:31147708,31146787:pehd:4230:31147740,31146788:pehd:4230:31147815,31146789:pehd:4230:31147784,31146790:pehd:4230:31147867,31146791:pehd:4230:31147915,31146792:pehd:4230:31147950,31146793:pehd:4230:31147987,31146794:pehd:4230:31152850,31146795:pehd:4230:31148074,31146798:pehd:4230:31148106,31146800:pehd:4230:31148151,31146801:pehd:4230:31148185,31146864:pehd:4230:31149264,31146865:pehd:4230:31149302,31146866:pehd:4230:31149375,31146869:pehd:4230:31149408,31146871:pehd:4230:31149459,31146872:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010712125001778452, 'nb_photo': 18837, 'list_port_cont': '31141774,31142033,31142157,31142382,31142693,31142739,31143464,31143500,31143685,31144023,31144059,31144544,31144589,31144615,31144699,31145708,31145747,31147550,31147626,31147664,31147712,31147748,31147785,31147819,31147868,31147913,31147951,31147992,31148033,31148067,31148114,31148143,31148186,31149248,31149291,31149334,31149376,31149409,31149462,31149497,31149538,31149583,31149616,31149649,31149687,31149725,31149774,31149817,31149854,31149884,31149931,31149976,31150011,31152308,31152353,31152383,31152429,31152469,31152538,31152583,31152847,31152954,31152981,31153381,31154200,31154242,31155124,31155158,31155202,31155241,31155276,31155321,31155355,31155396,31155437,31155475,31155553,31155589,31155663,31156798,31157296,31158201,31158241,31158275,31158310,31158356,31158390,31158433,31158463,31158499,31158552,31158597,31158629,31158662,31158709,31158744,31158785,31158819,31158861,31158894,31158931,31158977,31161078,31161110,31161154,31161188,31161218,31161262,31161299,31161335,31161369,31161420,31161459,3116149', 'assoc_port': '31141673:31141774,31141924:31142033,31142101:31142157,31142346:31142382,31142556:31142693,31142557:31142739,31142885:31143685,31143307:31143500,31143308:31143464,31143741:31144023,31143742:31144059,31144236:31144544,31144237:31144589,31144238:31144615,31144239:31144699,31144873:31145708,31144874:31145747,31144875:31190300,31146782:31147550,31146783:31147626,31146784:31147664,31146785:31152583,31146786:31147712,31146787:31147748,31146788:31147819,31146789:31147785,31146790:31147868,31146791:31147913,31146792:31147951,31146793:31147992,31146794:31152847,31146795:31148067,31146796:31148033,31146797:31152954,31146798:31148114,31146799:31152981,31146800:31148143,31146801:31148186,31146842:31184272,31146864:31149248,31146865:31149291,31146866:31149376,31146867:31149334,31146868:31154242,31146869:31149409,31146870:31156798,31146871:31149462,31146872:31153381,31146874:31149497,31146875:31149538,31146876:31149583,31146877:31154200,31146878:31149616,31146879:31149687,31146880:31149649,31146881:31149725,31146882:3114977', 'assoc_mat': '31141673:pet_clair:4230:31141774,31141924:pet_clair:4230:31142033,31142101:pet_clair:4230:31142157,31142346:pet_clair:4230:31142382,31142556:pet_clair:4230:31142693,31142557:pet_clair:4230:31142739,31142885:pet_clair:4230:31143685,31143307:pet_clair:4230:31143500,31143308:pet_clair:4230:31143464,31143741:pet_clair:4230:31144023,31143742:pet_clair:4230:31144059,31144236:pet_clair:4230:31144544,31144237:pet_clair:4230:31144589,31144238:pet_clair:4230:31144615,31144239:pet_clair:4230:31144699,31144873:pet_clair:4230:31145708,31144874:pet_clair:4230:31145747,31144875:pet_clair:4230:31190300,31146782:pet_clair:4230:31147550,31146783:pet_clair:4230:31147626,31146784:pet_clair:4230:31147664,31146785:pet_clair:4230:31152583,31146786:pet_clair:4230:31147712,31146787:pet_clair:4230:31147748,31146788:pet_clair:4230:31147819,31146789:pet_clair:4230:31147785,31146790:pet_clair:4230:31147868,31146791:pet_clair:4230:31147913,31146792:pet_clair:4230:31147951,31146793:pet_clair:4230:31147992,31146794:pet_clair:4230:31152847,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022412327478405054, 'nb_photo': 1038, 'list_port_cont': '31141766,31142036,31142697,31143460,31143502,31143689,31144016,31144581,31144693,31147616,31147665,31147713,31147783,31147818,31147871,31147914,31147956,31147983,31148037,31148153,31149259,31149300,31149337,31149365,31149412,31149457,31149499,31149539,31149586,31149614,31149653,31149694,31149731,31149784,31149819,31149850,31149895,31149922,31149967,31150010,31152387,31152475,31152539,31152575,31152860,31152944,31152996,31153376,31154190,31154239,31155205,31155280,31155385,31155427,31155473,31155550,31155588,31155659,31156808,31157297,31158204,31158269,31158387,31158422,31158558,31158893,31158935,31161075,31161260,31161301,31161426,31161453,31161757,31164261,31164359,31164514,31164615,31164732,31164753,31164804,31167450,31167568,31167643,31167674,31170080,31170158,31170222,31171851,31171888,31171958,31172031,31172105,31174395,31174435,31174497,31174702,31174738,31176353,31176428,31176459,31176503,31176533,31178094,31178242,31179776,31179820,31179929,31179963,31180007,31180068,31180156,31180266,31180338,3118212', 'assoc_port': '31141673:31141766,31141924:31142036,31142556:31142697,31142885:31143689,31143307:31143502,31143308:31143460,31143741:31144016,31144237:31144581,31144239:31144693,31146783:31147616,31146784:31147665,31146785:31152575,31146786:31147713,31146788:31147818,31146789:31147783,31146790:31147871,31146791:31147914,31146792:31147956,31146793:31147983,31146794:31152860,31146796:31148037,31146797:31152944,31146799:31152996,31146800:31148153,31146864:31149259,31146865:31149300,31146866:31149365,31146867:31149337,31146868:31154239,31146869:31149412,31146870:31156808,31146871:31149457,31146872:31153376,31146874:31149499,31146875:31149539,31146876:31149586,31146877:31154190,31146878:31149614,31146879:31149694,31146880:31149653,31146881:31149731,31146882:31149784,31146883:31149819,31146884:31149850,31146885:31149895,31146886:31149922,31146887:31149967,31146888:31150010,31148221:31152387,31148224:31152475,31148225:31152539,31152899:31179776,31152902:31179820,31152903:31188115,31152905:31179963,31152906:31179929,31152907:3118000', 'assoc_mat': '31141673:pet_fonce:4230:31141766,31141924:pet_fonce:4230:31142036,31142556:pet_fonce:4230:31142697,31142885:pet_fonce:4230:31143689,31143307:pet_fonce:4230:31143502,31143308:pet_fonce:4230:31143460,31143741:pet_fonce:4230:31144016,31144237:pet_fonce:4230:31144581,31144239:pet_fonce:4230:31144693,31146783:pet_fonce:4230:31147616,31146784:pet_fonce:4230:31147665,31146785:pet_fonce:4230:31152575,31146786:pet_fonce:4230:31147713,31146788:pet_fonce:4230:31147818,31146789:pet_fonce:4230:31147783,31146790:pet_fonce:4230:31147871,31146791:pet_fonce:4230:31147914,31146792:pet_fonce:4230:31147956,31146793:pet_fonce:4230:31147983,31146794:pet_fonce:4230:31152860,31146796:pet_fonce:4230:31148037,31146797:pet_fonce:4230:31152944,31146799:pet_fonce:4230:31152996,31146800:pet_fonce:4230:31148153,31146864:pet_fonce:4230:31149259,31146865:pet_fonce:4230:31149300,31146866:pet_fonce:4230:31149365,31146867:pet_fonce:4230:31149337,31146868:pet_fonce:4230:31154239,31146869:pet_fonce:4230:31149412,31146870:pet_fonce:4230:31156808,3'}), 'main_stat': {'nb_photos': 704}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31197042,31197043,31197044,31197045,31197046,31197047,31197048?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-06', 0.7499980868314844),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_06_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.58%', 17871], 'carton': ['carton', '6.47%', 112807], 'metal': ['metal', '0.17%', 2680], 'papier': ['papier', '18.32%', 404814], 'pehd': ['pehd', '0.35%', 1896], 'pet_clair': ['pet_clair', '1.07%', 18837], 'pet_fonce': ['pet_fonce', '0.22%', 1038]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_06_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.44user 2.93system 0:25.32elapsed 21%CPU (0avgtext+0avgdata 190396maxresident)k 8inputs+312outputs (0major+53862minor)pagefaults 0swaps