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-07 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 31) 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 : (2, 31) 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 : 07 mtr_id : dashboard_places : SCCU_cam7 date : 2026-07 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-07%') and created_at like '%2026-07%'))); nb_day : (2, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 07 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) = 07 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 '%072026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-07-01 : dt_date_just_month_year : 2026-07-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-07-01" AND ded.date <= "2026-07-31" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (3006644,3006912,3007508,3008140,3008422,3009170,3009766,3010322,3010784,3011402,3011972,3012268,3012850,3013524,3014190,3014846,3015402,3015954,3016190) 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.012893863052266336, 'nb_photo': 8289, 'list_port_cont': '31200349,31200393,31200440,31200484,31200531,31200572,31200620,31200658,31200706,31200742,31203334,31206618,31206679,31206712,31206773,31206803,31206860,31206912,31206946,31206991,31207037,31207077,31207115,31207166,31207202,31207261,31207301,31207347,31207385,31207431,31207467,31207524,31207563,31207602,31207649,31207688,31207721,31207782,31212046,31212095,31212139,31212187,31212215,31214030,31214066,31214094,31214142,31214179,31214224,31214279,31214336,31214369,31214418,31215126,31215155,31215210,31215244,31215698,31215773,31215849,31215974,31216293,31216355,31216407,31216456,31217061,31217111,31217329,31217539,31217778,31218039,31218319,31218530,31218852,31219172,31219516,31219659,31219872,31220226,31220509,31220785,31220990,31221321,31221542,31221780,31222003,31222356,31222536,31222613,31222989,31223204,31223437,31223751,31223979,31224249,31224459,31224702,31224887,31225140,31225427,31225920,31226529,31226991,31227018,31227272,31227536,31227969,31228215,31228464,31228660,31228990,31229306,31229662,3122997', 'assoc_port': '31200262:31200349,31200263:31200393,31200264:31200440,31200266:31200484,31200269:31200531,31200271:31200572,31200273:31200620,31200276:31200658,31200278:31200706,31200280:31200742,31200283:31203334,31203033:31206618,31203034:31206679,31203035:31206712,31203036:31206773,31203037:31206803,31203038:31206860,31203039:31206912,31203040:31206946,31203041:31206991,31203042:31207037,31203043:31207115,31203044:31207077,31203045:31207166,31203046:31207202,31203047:31207431,31203048:31207347,31203049:31207261,31203050:31207301,31203051:31207385,31203052:31207524,31203053:31207467,31203095:31207563,31203096:31207602,31203097:31207688,31203099:31207649,31203100:31207721,31203101:31207782,31207763:31212046,31207764:31212095,31207765:31212139,31207766:31212215,31207767:31212187,31211828:31214030,31211829:31214066,31211830:31214094,31211831:31214142,31211832:31214179,31211833:31214224,31211835:31214279,31211837:31214336,31211838:31214369,31211840:31214418,31214521:31215155,31214522:31215126,31214523:31215974,31214525:3121524', 'assoc_mat': '31200262:autre:4230:31200349,31200263:autre:4230:31200393,31200264:autre:4230:31200440,31200266:autre:4230:31200484,31200269:autre:4230:31200531,31200271:autre:4230:31200572,31200273:autre:4230:31200620,31200276:autre:4230:31200658,31200278:autre:4230:31200706,31200280:autre:4230:31200742,31200283:autre:4230:31203334,31203033:autre:4230:31206618,31203034:autre:4230:31206679,31203035:autre:4230:31206712,31203036:autre:4230:31206773,31203037:autre:4230:31206803,31203038:autre:4230:31206860,31203039:autre:4230:31206912,31203040:autre:4230:31206946,31203041:autre:4230:31206991,31203042:autre:4230:31207037,31203043:autre:4230:31207115,31203044:autre:4230:31207077,31203045:autre:4230:31207166,31203046:autre:4230:31207202,31203047:autre:4230:31207431,31203048:autre:4230:31207347,31203049:autre:4230:31207261,31203050:autre:4230:31207301,31203051:autre:4230:31207385,31203052:autre:4230:31207524,31203053:autre:4230:31207467,31203095:autre:4230:31207563,31203096:autre:4230:31207602,31203097:autre:4230:31207688,31203099:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04851694421087934, 'nb_photo': 50910, 'list_port_cont': '31200365,31200396,31200450,31200486,31200540,31200567,31200621,31200674,31200711,31200747,31203332,31206630,31206670,31206725,31206769,31206809,31206859,31206911,31206950,31206998,31207048,31207074,31207110,31207161,31207210,31207260,31207309,31207348,31207384,31207433,31207469,31207512,31207566,31207608,31207654,31207691,31207734,31207781,31212059,31212108,31212147,31212180,31212230,31214018,31214068,31214107,31214145,31214182,31214228,31214273,31214330,31214368,31214411,31215127,31215164,31215215,31215257,31215693,31215776,31215852,31215986,31216300,31216350,31216409,31216454,31217065,31217109,31217321,31217548,31217772,31218050,31218328,31218544,31218850,31219171,31219523,31219672,31219868,31220238,31220512,31220787,31220988,31221316,31221532,31221782,31222013,31222354,31222530,31222615,31222995,31223214,31223441,31223740,31223984,31224242,31224476,31224704,31224890,31225151,31225429,31225911,31226537,31226988,31227027,31227265,31227546,31227975,31228227,31228475,31228665,31229003,31229307,31229656,3122998', 'assoc_port': '31200262:31200365,31200263:31200396,31200264:31200450,31200266:31200486,31200269:31200540,31200271:31200567,31200273:31200621,31200276:31200674,31200278:31200711,31200280:31200747,31200283:31203332,31203033:31206630,31203034:31206670,31203035:31206725,31203036:31206769,31203037:31206809,31203038:31206859,31203039:31206911,31203040:31206950,31203041:31206998,31203042:31207048,31203043:31207110,31203044:31207074,31203045:31207161,31203046:31207210,31203047:31207433,31203048:31207348,31203049:31207260,31203050:31207309,31203051:31207384,31203052:31207512,31203053:31207469,31203095:31207566,31203096:31207608,31203097:31207691,31203099:31207654,31203100:31207734,31203101:31207781,31207763:31212059,31207764:31212108,31207765:31212147,31207766:31212230,31207767:31212180,31211828:31214018,31211829:31214068,31211830:31214107,31211831:31214145,31211832:31214182,31211833:31214228,31211835:31214273,31211837:31214330,31211838:31214368,31211840:31214411,31214521:31215164,31214522:31215127,31214523:31215986,31214525:3121525', 'assoc_mat': '31200262:carton:4230:31200365,31200263:carton:4230:31200396,31200264:carton:4230:31200450,31200266:carton:4230:31200486,31200269:carton:4230:31200540,31200271:carton:4230:31200567,31200273:carton:4230:31200621,31200276:carton:4230:31200674,31200278:carton:4230:31200711,31200280:carton:4230:31200747,31200283:carton:4230:31203332,31203033:carton:4230:31206630,31203034:carton:4230:31206670,31203035:carton:4230:31206725,31203036:carton:4230:31206769,31203037:carton:4230:31206809,31203038:carton:4230:31206859,31203039:carton:4230:31206911,31203040:carton:4230:31206950,31203041:carton:4230:31206998,31203042:carton:4230:31207048,31203043:carton:4230:31207110,31203044:carton:4230:31207074,31203045:carton:4230:31207161,31203046:carton:4230:31207210,31203047:carton:4230:31207433,31203048:carton:4230:31207348,31203049:carton:4230:31207260,31203050:carton:4230:31207309,31203051:carton:4230:31207384,31203052:carton:4230:31207512,31203053:carton:4230:31207469,31203095:carton:4230:31207566,31203096:carton:4230:31207608,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011941160088214623, 'nb_photo': 883, 'list_port_cont': '31200360,31200404,31200445,31200493,31200539,31200565,31200613,31200657,31200699,31200748,31203345,31206619,31206675,31206721,31206815,31206852,31206914,31206984,31207032,31207088,31207262,31207307,31207334,31207386,31207426,31207476,31207523,31207571,31207599,31207678,31207772,31212060,31212134,31212231,31214071,31214108,31214262,31214334,31214365,31214406,31215128,31215157,31215213,31215255,31215785,31215844,31215990,31216295,31216358,31216397,31217099,31217317,31217542,31217773,31218325,31218545,31218848,31219176,31219514,31219664,31219879,31220784,31220989,31221317,31221526,31221769,31221997,31222348,31222533,31222617,31222983,31223746,31223981,31224237,31224475,31224693,31224891,31225152,31227270,31227986,31228224,31228467,31228994,31229305,31229661,31229980,31230193,31230417,31230663,31230938,31231216,31231525,31231770,31231998,31232490,31232544,31232997,31233212,31233424,31234000,31234807,31235116,31235383,31235710,31236088,31236132,31236598,31236637,31236893,31237229,31237752,31238149,31238427,3123864', 'assoc_port': '31200262:31200360,31200263:31200404,31200264:31200445,31200266:31200493,31200269:31200539,31200271:31200565,31200273:31200613,31200276:31200657,31200278:31200699,31200280:31200748,31200283:31203345,31203033:31206619,31203034:31206675,31203035:31206721,31203037:31206815,31203038:31206852,31203039:31206914,31203041:31206984,31203042:31207032,31203044:31207088,31203047:31207426,31203048:31207334,31203049:31207262,31203050:31207307,31203051:31207386,31203052:31207523,31203053:31207476,31203095:31207571,31203096:31207599,31203097:31207678,31203101:31207772,31207763:31212060,31207765:31212134,31207766:31212231,31211829:31214071,31211830:31214108,31211835:31214262,31211837:31214334,31211838:31214365,31211840:31214406,31214521:31215157,31214522:31215128,31214523:31215990,31214525:31215255,31214527:31215213,31215325:31215785,31215327:31215844,31215830:31216295,31215831:31216358,31215952:31216397,31216871:31217099,31217194:31217317,31217426:31217542,31217692:31217773,31218176:31218325,31218469:31218545,31218733:3121884', 'assoc_mat': '31200262:metal:4230:31200360,31200263:metal:4230:31200404,31200264:metal:4230:31200445,31200266:metal:4230:31200493,31200269:metal:4230:31200539,31200271:metal:4230:31200565,31200273:metal:4230:31200613,31200276:metal:4230:31200657,31200278:metal:4230:31200699,31200280:metal:4230:31200748,31200283:metal:4230:31203345,31203033:metal:4230:31206619,31203034:metal:4230:31206675,31203035:metal:4230:31206721,31203037:metal:4230:31206815,31203038:metal:4230:31206852,31203039:metal:4230:31206914,31203041:metal:4230:31206984,31203042:metal:4230:31207032,31203044:metal:4230:31207088,31203047:metal:4230:31207426,31203048:metal:4230:31207334,31203049:metal:4230:31207262,31203050:metal:4230:31207307,31203051:metal:4230:31207386,31203052:metal:4230:31207523,31203053:metal:4230:31207476,31203095:metal:4230:31207571,31203096:metal:4230:31207599,31203097:metal:4230:31207678,31203101:metal:4230:31207772,31207763:metal:4230:31212060,31207765:metal:4230:31212134,31207766:metal:4230:31212231,31211829:metal:4230:31214071,31211830:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16940392854732947, 'nb_photo': 183918, 'list_port_cont': '31200355,31200407,31200443,31200491,31200533,31200576,31200618,31200668,31200714,31200749,31203337,31206633,31206672,31206727,31206764,31206816,31206862,31206907,31206952,31206988,31207034,31207086,31207117,31207162,31207198,31207268,31207311,31207336,31207394,31207430,31207468,31207525,31207568,31207616,31207644,31207690,31207727,31207777,31212058,31212097,31212144,31212188,31212227,31214029,31214064,31214105,31214147,31214188,31214220,31214277,31214323,31214380,31214414,31215116,31215160,31215212,31215249,31215701,31215781,31215853,31215982,31216301,31216356,31216405,31216462,31217062,31217106,31217326,31217551,31217776,31218045,31218324,31218541,31218851,31219174,31219522,31219669,31219878,31220239,31220511,31220786,31220999,31221313,31221539,31221773,31222012,31222358,31222539,31222623,31222992,31223208,31223449,31223750,31223988,31224248,31224473,31224703,31224889,31225148,31225428,31225910,31226535,31226981,31227015,31227275,31227535,31227982,31228216,31228478,31228667,31228993,31229309,31229663,3122998', 'assoc_port': '31200262:31200355,31200263:31200407,31200264:31200443,31200266:31200491,31200269:31200533,31200271:31200576,31200273:31200618,31200276:31200668,31200278:31200714,31200280:31200749,31200283:31203337,31203033:31206633,31203034:31206672,31203035:31206727,31203036:31206764,31203037:31206816,31203038:31206862,31203039:31206907,31203040:31206952,31203041:31206988,31203042:31207034,31203043:31207117,31203044:31207086,31203045:31207162,31203046:31207198,31203047:31207430,31203048:31207336,31203049:31207268,31203050:31207311,31203051:31207394,31203052:31207525,31203053:31207468,31203095:31207568,31203096:31207616,31203097:31207690,31203099:31207644,31203100:31207727,31203101:31207777,31207763:31212058,31207764:31212097,31207765:31212144,31207766:31212227,31207767:31212188,31211828:31214029,31211829:31214064,31211830:31214105,31211831:31214147,31211832:31214188,31211833:31214220,31211835:31214277,31211837:31214323,31211838:31214380,31211840:31214414,31214521:31215160,31214522:31215116,31214523:31215982,31214525:3121524', 'assoc_mat': '31200262:papier:4230:31200355,31200263:papier:4230:31200407,31200264:papier:4230:31200443,31200266:papier:4230:31200491,31200269:papier:4230:31200533,31200271:papier:4230:31200576,31200273:papier:4230:31200618,31200276:papier:4230:31200668,31200278:papier:4230:31200714,31200280:papier:4230:31200749,31200283:papier:4230:31203337,31203033:papier:4230:31206633,31203034:papier:4230:31206672,31203035:papier:4230:31206727,31203036:papier:4230:31206764,31203037:papier:4230:31206816,31203038:papier:4230:31206862,31203039:papier:4230:31206907,31203040:papier:4230:31206952,31203041:papier:4230:31206988,31203042:papier:4230:31207034,31203043:papier:4230:31207117,31203044:papier:4230:31207086,31203045:papier:4230:31207162,31203046:papier:4230:31207198,31203047:papier:4230:31207430,31203048:papier:4230:31207336,31203049:papier:4230:31207268,31203050:papier:4230:31207311,31203051:papier:4230:31207394,31203052:papier:4230:31207525,31203053:papier:4230:31207468,31203095:papier:4230:31207568,31203096:papier:4230:31207616,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0043032605629586065, 'nb_photo': 903, 'list_port_cont': '31200358,31200401,31200622,31200671,31200707,31200751,31203340,31206634,31206959,31206995,31207044,31207083,31207116,31207267,31207304,31207392,31207574,31207613,31207652,31207685,31207735,31212143,31212228,31214028,31214101,31214144,31214181,31214230,31214278,31214324,31214379,31214419,31215125,31215162,31215214,31215254,31215784,31215989,31216307,31217113,31217320,31217546,31217769,31218539,31218843,31219179,31219524,31219670,31219876,31220231,31220499,31220780,31221000,31221320,31221534,31221784,31222010,31222359,31222542,31222619,31222986,31223977,31224885,31225153,31225425,31227025,31227984,31228222,31228997,31229302,31229983,31230198,31230420,31230949,31231208,31231524,31231765,31232009,31232182,31232506,31232549,31232989,31233227,31233666,31233997,31234238,31234538,31234808,31235113,31235380,31236083,31236131,31236600,31236894,31237241,31237465,31238158,31238431,31238653,31238920,31239353,31239572,31239840,31240129,31240666,31240993,31241334,31241731,31242563,31242728,31244332,31244520,31244639,3124474', 'assoc_port': '31200262:31200358,31200263:31200401,31200273:31200622,31200276:31200671,31200278:31200707,31200280:31200751,31200283:31203340,31203033:31206634,31203040:31206959,31203041:31206995,31203042:31207044,31203043:31207116,31203044:31207083,31203049:31207267,31203050:31207304,31203051:31207392,31203095:31207574,31203096:31207613,31203097:31207685,31203099:31207652,31203100:31207735,31207765:31212143,31207766:31212228,31211828:31214028,31211830:31214101,31211831:31214144,31211832:31214181,31211833:31214230,31211835:31214278,31211837:31214324,31211838:31214379,31211840:31214419,31214521:31215162,31214522:31215125,31214523:31215989,31214525:31215254,31214527:31215214,31215325:31215784,31215830:31216307,31216871:31217113,31217194:31217320,31217426:31217546,31217692:31217769,31218469:31218539,31218733:31218843,31219009:31219179,31219311:31219524,31219552:31219670,31219767:31219876,31220084:31220231,31220364:31220499,31220631:31220780,31220867:31221000,31221124:31221320,31221398:31221534,31221632:31221784,31221903:3122201', 'assoc_mat': '31200262:pehd:4230:31200358,31200263:pehd:4230:31200401,31200273:pehd:4230:31200622,31200276:pehd:4230:31200671,31200278:pehd:4230:31200707,31200280:pehd:4230:31200751,31200283:pehd:4230:31203340,31203033:pehd:4230:31206634,31203040:pehd:4230:31206959,31203041:pehd:4230:31206995,31203042:pehd:4230:31207044,31203043:pehd:4230:31207116,31203044:pehd:4230:31207083,31203049:pehd:4230:31207267,31203050:pehd:4230:31207304,31203051:pehd:4230:31207392,31203095:pehd:4230:31207574,31203096:pehd:4230:31207613,31203097:pehd:4230:31207685,31203099:pehd:4230:31207652,31203100:pehd:4230:31207735,31207765:pehd:4230:31212143,31207766:pehd:4230:31212228,31211828:pehd:4230:31214028,31211830:pehd:4230:31214101,31211831:pehd:4230:31214144,31211832:pehd:4230:31214181,31211833:pehd:4230:31214230,31211835:pehd:4230:31214278,31211837:pehd:4230:31214324,31211838:pehd:4230:31214379,31211840:pehd:4230:31214419,31214521:pehd:4230:31215162,31214522:pehd:4230:31215125,31214523:pehd:4230:31215989,31214525:pehd:4230:31215254,31214527:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014001514843920345, 'nb_photo': 10173, 'list_port_cont': '31200356,31200406,31200451,31200495,31200529,31200570,31200614,31200669,31200709,31200753,31203342,31206624,31206674,31206718,31206768,31206820,31206864,31206915,31206958,31206994,31207042,31207079,31207124,31207158,31207208,31207263,31207302,31207341,31207380,31207421,31207473,31207522,31207570,31207610,31207656,31207689,31207737,31207786,31212057,31212110,31212148,31212185,31212221,31214033,31214070,31214104,31214143,31214189,31214226,31214271,31214337,31214374,31214412,31215123,31215159,31215208,31215252,31215705,31215782,31215847,31215978,31216306,31216353,31216408,31216449,31217067,31217100,31217327,31217544,31217781,31218038,31218327,31218540,31218842,31219183,31219527,31219671,31219867,31220234,31220507,31220792,31220997,31221315,31221535,31221774,31222007,31222355,31222541,31222609,31222982,31223210,31223436,31223752,31223992,31224244,31224474,31224700,31224892,31225149,31225430,31225918,31226538,31226982,31227024,31227264,31227543,31227985,31228228,31228479,31228661,31229001,31229299,31229660,3122998', 'assoc_port': '31200262:31200356,31200263:31200406,31200264:31200451,31200266:31200495,31200269:31200529,31200271:31200570,31200273:31200614,31200276:31200669,31200278:31200709,31200280:31200753,31200283:31203342,31203033:31206624,31203034:31206674,31203035:31206718,31203036:31206768,31203037:31206820,31203038:31206864,31203039:31206915,31203040:31206958,31203041:31206994,31203042:31207042,31203043:31207124,31203044:31207079,31203045:31207158,31203046:31207208,31203047:31207421,31203048:31207341,31203049:31207263,31203050:31207302,31203051:31207380,31203052:31207522,31203053:31207473,31203095:31207570,31203096:31207610,31203097:31207689,31203099:31207656,31203100:31207737,31203101:31207786,31207763:31212057,31207764:31212110,31207765:31212148,31207766:31212221,31207767:31212185,31211828:31214033,31211829:31214070,31211830:31214104,31211831:31214143,31211832:31214189,31211833:31214226,31211835:31214271,31211837:31214337,31211838:31214374,31211840:31214412,31214521:31215159,31214522:31215123,31214523:31215978,31214525:3121525', 'assoc_mat': '31200262:pet_clair:4230:31200356,31200263:pet_clair:4230:31200406,31200264:pet_clair:4230:31200451,31200266:pet_clair:4230:31200495,31200269:pet_clair:4230:31200529,31200271:pet_clair:4230:31200570,31200273:pet_clair:4230:31200614,31200276:pet_clair:4230:31200669,31200278:pet_clair:4230:31200709,31200280:pet_clair:4230:31200753,31200283:pet_clair:4230:31203342,31203033:pet_clair:4230:31206624,31203034:pet_clair:4230:31206674,31203035:pet_clair:4230:31206718,31203036:pet_clair:4230:31206768,31203037:pet_clair:4230:31206820,31203038:pet_clair:4230:31206864,31203039:pet_clair:4230:31206915,31203040:pet_clair:4230:31206958,31203041:pet_clair:4230:31206994,31203042:pet_clair:4230:31207042,31203043:pet_clair:4230:31207124,31203044:pet_clair:4230:31207079,31203045:pet_clair:4230:31207158,31203046:pet_clair:4230:31207208,31203047:pet_clair:4230:31207421,31203048:pet_clair:4230:31207341,31203049:pet_clair:4230:31207263,31203050:pet_clair:4230:31207302,31203051:pet_clair:4230:31207380,31203052:pet_clair:4230:31207522,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002107358984980607, 'nb_photo': 336, 'list_port_cont': '31200615,31200700,31203335,31206962,31207045,31207084,31207125,31207573,31207611,31207686,31207733,31212151,31214024,31214067,31214106,31214141,31214190,31214231,31214335,31214381,31214415,31215150,31215253,31215845,31215983,31216304,31216348,31217108,31217315,31218049,31219521,31219663,31220230,31220793,31220993,31221314,31221533,31221777,31222004,31222349,31222621,31222981,31223445,31223742,31224245,31224698,31225145,31225419,31228223,31229002,31229304,31230201,31230943,31231218,31231520,31231771,31232012,31232504,31232542,31233223,31234226,31235118,31236886,31237239,31237458,31237759,31238156,31238425,31238655,31238926,31239355,31239574,31239832,31240139,31241340,31241718,31242569,31242731,31244345,31244522,31244649,31244742,31245793,31245896,31245939,31245986,31246670,31246802,31247088,31247136,31247674,31247719,31247764,31248338,31248429,31248896,31249797,31250665,31251116,31251700,31252016,31252310,31252652,31253537,31255164,31255204,31256292,31257469,31258648,31259062,31259368,31259664,31260021,3126025', 'assoc_port': '31200273:31200615,31200278:31200700,31200283:31203335,31203040:31206962,31203042:31207045,31203043:31207125,31203044:31207084,31203095:31207573,31203096:31207611,31203097:31207686,31203100:31207733,31207765:31212151,31211828:31214024,31211829:31214067,31211830:31214106,31211831:31214141,31211832:31214190,31211833:31214231,31211837:31214335,31211838:31214381,31211840:31214415,31214521:31215150,31214523:31215983,31214525:31215253,31215327:31215845,31215830:31216304,31215831:31216348,31216871:31217108,31217194:31217315,31217924:31218049,31219311:31219521,31219552:31219663,31220084:31220230,31220631:31220793,31220867:31220993,31221124:31221314,31221398:31221533,31221632:31221777,31221903:31222004,31222164:31222349,31222433:31222621,31222845:31222981,31223371:31223445,31223604:31223742,31224141:31224245,31224559:31224698,31225039:31225145,31225307:31225419,31228036:31228223,31228828:31229002,31229131:31229304,31230013:31230201,31230832:31230943,31231103:31231218,31231364:31231520,31231611:31231771,31231844:3123201', 'assoc_mat': '31200273:pet_fonce:4230:31200615,31200278:pet_fonce:4230:31200700,31200283:pet_fonce:4230:31203335,31203040:pet_fonce:4230:31206962,31203042:pet_fonce:4230:31207045,31203043:pet_fonce:4230:31207125,31203044:pet_fonce:4230:31207084,31203095:pet_fonce:4230:31207573,31203096:pet_fonce:4230:31207611,31203097:pet_fonce:4230:31207686,31203100:pet_fonce:4230:31207733,31207765:pet_fonce:4230:31212151,31211828:pet_fonce:4230:31214024,31211829:pet_fonce:4230:31214067,31211830:pet_fonce:4230:31214106,31211831:pet_fonce:4230:31214141,31211832:pet_fonce:4230:31214190,31211833:pet_fonce:4230:31214231,31211837:pet_fonce:4230:31214335,31211838:pet_fonce:4230:31214381,31211840:pet_fonce:4230:31214415,31214521:pet_fonce:4230:31215150,31214523:pet_fonce:4230:31215983,31214525:pet_fonce:4230:31215253,31215327:pet_fonce:4230:31215845,31215830:pet_fonce:4230:31216304,31215831:pet_fonce:4230:31216348,31216871:pet_fonce:4230:31217108,31217194:pet_fonce:4230:31217315,31217924:pet_fonce:4230:31218049,31219311:pet_fonce:4230:31219521,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(3006644,3006912,3007508,3008140,3008422,3009170,3009766,3010322,3010784,3011402,3011972,3012268,3012850,3013524,3014190,3014846,3015402,3015954,3016190)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302781, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200349,31200393,31200440,31200484,31200531,31200572,31200620,31200658,31200706,31200742,31203334,31206618,31206679,31206712,31206773,31206803,31206860,31206912,31206946,31206991,31207037,31207077,31207115,31207166,31207202,31207261,31207301,31207347,31207385,31207431,31207467,31207524,31207563,31207602,31207649,31207688,31207721,31207782,31212046,31212095,31212139,31212187,31212215,31214030,31214066,31214094,31214142,31214179,31214224,31214279,31214336,31214369,31214418,31215126,31215155,31215210,31215244,31215698,31215773,31215849,31215974,31216293,31216355,31216407,31216456,31217061,31217111,31217329,31217539,31217778,31218039,31218319,31218530,31218852,31219172,31219516,31219659,31219872,31220226,31220509,31220785,31220990,31221321,31221542,31221780,31222003,31222356,31222536,31222613,31222989,31223204,31223437,31223751,31223979,31224249,31224459,31224702,31224887,31225140,31225427,31225920,31226529,31226991,31227018,31227272,31227536,31227969,31228215,31228464,31228660,31228990,31229306,31229662,3122997 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302782, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200365,31200396,31200450,31200486,31200540,31200567,31200621,31200674,31200711,31200747,31203332,31206630,31206670,31206725,31206769,31206809,31206859,31206911,31206950,31206998,31207048,31207074,31207110,31207161,31207210,31207260,31207309,31207348,31207384,31207433,31207469,31207512,31207566,31207608,31207654,31207691,31207734,31207781,31212059,31212108,31212147,31212180,31212230,31214018,31214068,31214107,31214145,31214182,31214228,31214273,31214330,31214368,31214411,31215127,31215164,31215215,31215257,31215693,31215776,31215852,31215986,31216300,31216350,31216409,31216454,31217065,31217109,31217321,31217548,31217772,31218050,31218328,31218544,31218850,31219171,31219523,31219672,31219868,31220238,31220512,31220787,31220988,31221316,31221532,31221782,31222013,31222354,31222530,31222615,31222995,31223214,31223441,31223740,31223984,31224242,31224476,31224704,31224890,31225151,31225429,31225911,31226537,31226988,31227027,31227265,31227546,31227975,31228227,31228475,31228665,31229003,31229307,31229656,3122998 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302783, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200360,31200404,31200445,31200493,31200539,31200565,31200613,31200657,31200699,31200748,31203345,31206619,31206675,31206721,31206815,31206852,31206914,31206984,31207032,31207088,31207262,31207307,31207334,31207386,31207426,31207476,31207523,31207571,31207599,31207678,31207772,31212060,31212134,31212231,31214071,31214108,31214262,31214334,31214365,31214406,31215128,31215157,31215213,31215255,31215785,31215844,31215990,31216295,31216358,31216397,31217099,31217317,31217542,31217773,31218325,31218545,31218848,31219176,31219514,31219664,31219879,31220784,31220989,31221317,31221526,31221769,31221997,31222348,31222533,31222617,31222983,31223746,31223981,31224237,31224475,31224693,31224891,31225152,31227270,31227986,31228224,31228467,31228994,31229305,31229661,31229980,31230193,31230417,31230663,31230938,31231216,31231525,31231770,31231998,31232490,31232544,31232997,31233212,31233424,31234000,31234807,31235116,31235383,31235710,31236088,31236132,31236598,31236637,31236893,31237229,31237752,31238149,31238427,3123864 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302784, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200355,31200407,31200443,31200491,31200533,31200576,31200618,31200668,31200714,31200749,31203337,31206633,31206672,31206727,31206764,31206816,31206862,31206907,31206952,31206988,31207034,31207086,31207117,31207162,31207198,31207268,31207311,31207336,31207394,31207430,31207468,31207525,31207568,31207616,31207644,31207690,31207727,31207777,31212058,31212097,31212144,31212188,31212227,31214029,31214064,31214105,31214147,31214188,31214220,31214277,31214323,31214380,31214414,31215116,31215160,31215212,31215249,31215701,31215781,31215853,31215982,31216301,31216356,31216405,31216462,31217062,31217106,31217326,31217551,31217776,31218045,31218324,31218541,31218851,31219174,31219522,31219669,31219878,31220239,31220511,31220786,31220999,31221313,31221539,31221773,31222012,31222358,31222539,31222623,31222992,31223208,31223449,31223750,31223988,31224248,31224473,31224703,31224889,31225148,31225428,31225910,31226535,31226981,31227015,31227275,31227535,31227982,31228216,31228478,31228667,31228993,31229309,31229663,3122998 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302785, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200358,31200401,31200622,31200671,31200707,31200751,31203340,31206634,31206959,31206995,31207044,31207083,31207116,31207267,31207304,31207392,31207574,31207613,31207652,31207685,31207735,31212143,31212228,31214028,31214101,31214144,31214181,31214230,31214278,31214324,31214379,31214419,31215125,31215162,31215214,31215254,31215784,31215989,31216307,31217113,31217320,31217546,31217769,31218539,31218843,31219179,31219524,31219670,31219876,31220231,31220499,31220780,31221000,31221320,31221534,31221784,31222010,31222359,31222542,31222619,31222986,31223977,31224885,31225153,31225425,31227025,31227984,31228222,31228997,31229302,31229983,31230198,31230420,31230949,31231208,31231524,31231765,31232009,31232182,31232506,31232549,31232989,31233227,31233666,31233997,31234238,31234538,31234808,31235113,31235380,31236083,31236131,31236600,31236894,31237241,31237465,31238158,31238431,31238653,31238920,31239353,31239572,31239840,31240129,31240666,31240993,31241334,31241731,31242563,31242728,31244332,31244520,31244639,3124474 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302786, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200356,31200406,31200451,31200495,31200529,31200570,31200614,31200669,31200709,31200753,31203342,31206624,31206674,31206718,31206768,31206820,31206864,31206915,31206958,31206994,31207042,31207079,31207124,31207158,31207208,31207263,31207302,31207341,31207380,31207421,31207473,31207522,31207570,31207610,31207656,31207689,31207737,31207786,31212057,31212110,31212148,31212185,31212221,31214033,31214070,31214104,31214143,31214189,31214226,31214271,31214337,31214374,31214412,31215123,31215159,31215208,31215252,31215705,31215782,31215847,31215978,31216306,31216353,31216408,31216449,31217067,31217100,31217327,31217544,31217781,31218038,31218327,31218540,31218842,31219183,31219527,31219671,31219867,31220234,31220507,31220792,31220997,31221315,31221535,31221774,31222007,31222355,31222541,31222609,31222982,31223210,31223436,31223752,31223992,31224244,31224474,31224700,31224892,31225149,31225430,31225918,31226538,31226982,31227024,31227264,31227543,31227985,31228228,31228479,31228661,31229001,31229299,31229660,3122998 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302787, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31200615,31200700,31203335,31206962,31207045,31207084,31207125,31207573,31207611,31207686,31207733,31212151,31214024,31214067,31214106,31214141,31214190,31214231,31214335,31214381,31214415,31215150,31215253,31215845,31215983,31216304,31216348,31217108,31217315,31218049,31219521,31219663,31220230,31220793,31220993,31221314,31221533,31221777,31222004,31222349,31222621,31222981,31223445,31223742,31224245,31224698,31225145,31225419,31228223,31229002,31229304,31230201,31230943,31231218,31231520,31231771,31232012,31232504,31232542,31233223,31234226,31235118,31236886,31237239,31237458,31237759,31238156,31238425,31238655,31238926,31239355,31239574,31239832,31240139,31241340,31241718,31242569,31242731,31244345,31244522,31244649,31244742,31245793,31245896,31245939,31245986,31246670,31246802,31247088,31247136,31247674,31247719,31247764,31248338,31248429,31248896,31249797,31250665,31251116,31251700,31252016,31252310,31252652,31253537,31255164,31255204,31256292,31257469,31258648,31259062,31259368,31259664,31260021,3126025 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31302781,31302782,31302783,31302784,31302785,31302786,31302787?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-07-01' and date <= '2026-07-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((982,),), 'unwanted_material_monthly_percentage': ((0.7771262491488797,),), 'material_repartition': (('incineration', 982),), 'material_dict': {'incineration': 982}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 7, 1), 0.801944436310415, 1), (datetime.date(2026, 7, 2), 0.7455776641806129, 2), (datetime.date(2026, 7, 3), 0.7015556387422021, 2), (datetime.date(2026, 7, 4), 0.682090292797055, 3), (datetime.date(2026, 7, 5), 0.8077756197311334, 4), (datetime.date(2026, 7, 6), 0.7879099572621902, 2), (datetime.date(2026, 7, 7), 0.7654625224109125, 2), (datetime.date(2026, 7, 8), 0.7198458596945221, 3), (datetime.date(2026, 7, 9), 0.7581099836248356, 1), (datetime.date(2026, 7, 10), 0.7488022082000949, 1), (datetime.date(2026, 7, 11), 0.739341962940344, 2), (datetime.date(2026, 7, 12), 0.794657766999548, 1), (datetime.date(2026, 7, 13), 0.811575100111914, 2), (datetime.date(2026, 7, 14), 0.8891834682446904, 2), (datetime.date(2026, 7, 15), 0.8574969679278797, 2), (datetime.date(2026, 7, 16), 0.825843669663959, 2), (datetime.date(2026, 7, 17), 0.7975564521905616, 4), (datetime.date(2026, 7, 18), 0.7475528540484261, 3), (datetime.date(2026, 7, 19), 0.8089815799577867, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 7, 1), 0.801944436310415, 1), (datetime.date(2026, 7, 2), 0.7455776641806129, 2), (datetime.date(2026, 7, 3), 0.7015556387422021, 2), (datetime.date(2026, 7, 4), 0.682090292797055, 3), (datetime.date(2026, 7, 5), 0.8077756197311334, 4), (datetime.date(2026, 7, 6), 0.7879099572621902, 2), (datetime.date(2026, 7, 7), 0.7654625224109125, 2), (datetime.date(2026, 7, 8), 0.7198458596945221, 3), (datetime.date(2026, 7, 9), 0.7581099836248356, 1), (datetime.date(2026, 7, 10), 0.7488022082000949, 1), (datetime.date(2026, 7, 11), 0.739341962940344, 2), (datetime.date(2026, 7, 12), 0.794657766999548, 1), (datetime.date(2026, 7, 13), 0.811575100111914, 2), (datetime.date(2026, 7, 14), 0.8891834682446904, 2), (datetime.date(2026, 7, 15), 0.8574969679278797, 2), (datetime.date(2026, 7, 16), 0.825843669663959, 2), (datetime.date(2026, 7, 17), 0.7975564521905616, 4), (datetime.date(2026, 7, 18), 0.7475528540484261, 3), (datetime.date(2026, 7, 19), 0.8089815799577867, 1))}, 'quality_array': [['-8.26159304774946', '01072026'], ['-8.47337784902641', '02072026'], ['-8.762847646379026', '03072026'], ['-8.715348171394462', '04072026'], ['-8.73282949233469', '05072026'], ['-8.692909087623525', '06072026'], ['-8.573366702729304', '07072026'], ['-8.78116193175665', '08072026'], ['-8.493369342483122', '09072026'], ['-8.313019625025733', '10072026'], ['-8.610766993024924', '11072026'], ['-8.860880604025448', '12072026'], ['-8.372375951695034', '13072026'], ['-8.52097794682945', '14072026'], ['-7.931508041116178', '15072026'], ['-7.954455485665405', '16072026'], ['-8.18904692033734', '17072026'], ['-8.356651802926173', '18072026'], ['-8.446738672724795', '19072026']], 'number_of_batch': ((403,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012893863052266336, 'nb_photo': 8289, 'list_port_cont': '31200349,31200393,31200440,31200484,31200531,31200572,31200620,31200658,31200706,31200742,31203334,31206618,31206679,31206712,31206773,31206803,31206860,31206912,31206946,31206991,31207037,31207077,31207115,31207166,31207202,31207261,31207301,31207347,31207385,31207431,31207467,31207524,31207563,31207602,31207649,31207688,31207721,31207782,31212046,31212095,31212139,31212187,31212215,31214030,31214066,31214094,31214142,31214179,31214224,31214279,31214336,31214369,31214418,31215126,31215155,31215210,31215244,31215698,31215773,31215849,31215974,31216293,31216355,31216407,31216456,31217061,31217111,31217329,31217539,31217778,31218039,31218319,31218530,31218852,31219172,31219516,31219659,31219872,31220226,31220509,31220785,31220990,31221321,31221542,31221780,31222003,31222356,31222536,31222613,31222989,31223204,31223437,31223751,31223979,31224249,31224459,31224702,31224887,31225140,31225427,31225920,31226529,31226991,31227018,31227272,31227536,31227969,31228215,31228464,31228660,31228990,31229306,31229662,3122997', 'assoc_port': '31200262:31200349,31200263:31200393,31200264:31200440,31200266:31200484,31200269:31200531,31200271:31200572,31200273:31200620,31200276:31200658,31200278:31200706,31200280:31200742,31200283:31203334,31203033:31206618,31203034:31206679,31203035:31206712,31203036:31206773,31203037:31206803,31203038:31206860,31203039:31206912,31203040:31206946,31203041:31206991,31203042:31207037,31203043:31207115,31203044:31207077,31203045:31207166,31203046:31207202,31203047:31207431,31203048:31207347,31203049:31207261,31203050:31207301,31203051:31207385,31203052:31207524,31203053:31207467,31203095:31207563,31203096:31207602,31203097:31207688,31203099:31207649,31203100:31207721,31203101:31207782,31207763:31212046,31207764:31212095,31207765:31212139,31207766:31212215,31207767:31212187,31211828:31214030,31211829:31214066,31211830:31214094,31211831:31214142,31211832:31214179,31211833:31214224,31211835:31214279,31211837:31214336,31211838:31214369,31211840:31214418,31214521:31215155,31214522:31215126,31214523:31215974,31214525:3121524', 'assoc_mat': '31200262:autre:4230:31200349,31200263:autre:4230:31200393,31200264:autre:4230:31200440,31200266:autre:4230:31200484,31200269:autre:4230:31200531,31200271:autre:4230:31200572,31200273:autre:4230:31200620,31200276:autre:4230:31200658,31200278:autre:4230:31200706,31200280:autre:4230:31200742,31200283:autre:4230:31203334,31203033:autre:4230:31206618,31203034:autre:4230:31206679,31203035:autre:4230:31206712,31203036:autre:4230:31206773,31203037:autre:4230:31206803,31203038:autre:4230:31206860,31203039:autre:4230:31206912,31203040:autre:4230:31206946,31203041:autre:4230:31206991,31203042:autre:4230:31207037,31203043:autre:4230:31207115,31203044:autre:4230:31207077,31203045:autre:4230:31207166,31203046:autre:4230:31207202,31203047:autre:4230:31207431,31203048:autre:4230:31207347,31203049:autre:4230:31207261,31203050:autre:4230:31207301,31203051:autre:4230:31207385,31203052:autre:4230:31207524,31203053:autre:4230:31207467,31203095:autre:4230:31207563,31203096:autre:4230:31207602,31203097:autre:4230:31207688,31203099:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04851694421087934, 'nb_photo': 50910, 'list_port_cont': '31200365,31200396,31200450,31200486,31200540,31200567,31200621,31200674,31200711,31200747,31203332,31206630,31206670,31206725,31206769,31206809,31206859,31206911,31206950,31206998,31207048,31207074,31207110,31207161,31207210,31207260,31207309,31207348,31207384,31207433,31207469,31207512,31207566,31207608,31207654,31207691,31207734,31207781,31212059,31212108,31212147,31212180,31212230,31214018,31214068,31214107,31214145,31214182,31214228,31214273,31214330,31214368,31214411,31215127,31215164,31215215,31215257,31215693,31215776,31215852,31215986,31216300,31216350,31216409,31216454,31217065,31217109,31217321,31217548,31217772,31218050,31218328,31218544,31218850,31219171,31219523,31219672,31219868,31220238,31220512,31220787,31220988,31221316,31221532,31221782,31222013,31222354,31222530,31222615,31222995,31223214,31223441,31223740,31223984,31224242,31224476,31224704,31224890,31225151,31225429,31225911,31226537,31226988,31227027,31227265,31227546,31227975,31228227,31228475,31228665,31229003,31229307,31229656,3122998', 'assoc_port': '31200262:31200365,31200263:31200396,31200264:31200450,31200266:31200486,31200269:31200540,31200271:31200567,31200273:31200621,31200276:31200674,31200278:31200711,31200280:31200747,31200283:31203332,31203033:31206630,31203034:31206670,31203035:31206725,31203036:31206769,31203037:31206809,31203038:31206859,31203039:31206911,31203040:31206950,31203041:31206998,31203042:31207048,31203043:31207110,31203044:31207074,31203045:31207161,31203046:31207210,31203047:31207433,31203048:31207348,31203049:31207260,31203050:31207309,31203051:31207384,31203052:31207512,31203053:31207469,31203095:31207566,31203096:31207608,31203097:31207691,31203099:31207654,31203100:31207734,31203101:31207781,31207763:31212059,31207764:31212108,31207765:31212147,31207766:31212230,31207767:31212180,31211828:31214018,31211829:31214068,31211830:31214107,31211831:31214145,31211832:31214182,31211833:31214228,31211835:31214273,31211837:31214330,31211838:31214368,31211840:31214411,31214521:31215164,31214522:31215127,31214523:31215986,31214525:3121525', 'assoc_mat': '31200262:carton:4230:31200365,31200263:carton:4230:31200396,31200264:carton:4230:31200450,31200266:carton:4230:31200486,31200269:carton:4230:31200540,31200271:carton:4230:31200567,31200273:carton:4230:31200621,31200276:carton:4230:31200674,31200278:carton:4230:31200711,31200280:carton:4230:31200747,31200283:carton:4230:31203332,31203033:carton:4230:31206630,31203034:carton:4230:31206670,31203035:carton:4230:31206725,31203036:carton:4230:31206769,31203037:carton:4230:31206809,31203038:carton:4230:31206859,31203039:carton:4230:31206911,31203040:carton:4230:31206950,31203041:carton:4230:31206998,31203042:carton:4230:31207048,31203043:carton:4230:31207110,31203044:carton:4230:31207074,31203045:carton:4230:31207161,31203046:carton:4230:31207210,31203047:carton:4230:31207433,31203048:carton:4230:31207348,31203049:carton:4230:31207260,31203050:carton:4230:31207309,31203051:carton:4230:31207384,31203052:carton:4230:31207512,31203053:carton:4230:31207469,31203095:carton:4230:31207566,31203096:carton:4230:31207608,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011941160088214623, 'nb_photo': 883, 'list_port_cont': '31200360,31200404,31200445,31200493,31200539,31200565,31200613,31200657,31200699,31200748,31203345,31206619,31206675,31206721,31206815,31206852,31206914,31206984,31207032,31207088,31207262,31207307,31207334,31207386,31207426,31207476,31207523,31207571,31207599,31207678,31207772,31212060,31212134,31212231,31214071,31214108,31214262,31214334,31214365,31214406,31215128,31215157,31215213,31215255,31215785,31215844,31215990,31216295,31216358,31216397,31217099,31217317,31217542,31217773,31218325,31218545,31218848,31219176,31219514,31219664,31219879,31220784,31220989,31221317,31221526,31221769,31221997,31222348,31222533,31222617,31222983,31223746,31223981,31224237,31224475,31224693,31224891,31225152,31227270,31227986,31228224,31228467,31228994,31229305,31229661,31229980,31230193,31230417,31230663,31230938,31231216,31231525,31231770,31231998,31232490,31232544,31232997,31233212,31233424,31234000,31234807,31235116,31235383,31235710,31236088,31236132,31236598,31236637,31236893,31237229,31237752,31238149,31238427,3123864', 'assoc_port': '31200262:31200360,31200263:31200404,31200264:31200445,31200266:31200493,31200269:31200539,31200271:31200565,31200273:31200613,31200276:31200657,31200278:31200699,31200280:31200748,31200283:31203345,31203033:31206619,31203034:31206675,31203035:31206721,31203037:31206815,31203038:31206852,31203039:31206914,31203041:31206984,31203042:31207032,31203044:31207088,31203047:31207426,31203048:31207334,31203049:31207262,31203050:31207307,31203051:31207386,31203052:31207523,31203053:31207476,31203095:31207571,31203096:31207599,31203097:31207678,31203101:31207772,31207763:31212060,31207765:31212134,31207766:31212231,31211829:31214071,31211830:31214108,31211835:31214262,31211837:31214334,31211838:31214365,31211840:31214406,31214521:31215157,31214522:31215128,31214523:31215990,31214525:31215255,31214527:31215213,31215325:31215785,31215327:31215844,31215830:31216295,31215831:31216358,31215952:31216397,31216871:31217099,31217194:31217317,31217426:31217542,31217692:31217773,31218176:31218325,31218469:31218545,31218733:3121884', 'assoc_mat': '31200262:metal:4230:31200360,31200263:metal:4230:31200404,31200264:metal:4230:31200445,31200266:metal:4230:31200493,31200269:metal:4230:31200539,31200271:metal:4230:31200565,31200273:metal:4230:31200613,31200276:metal:4230:31200657,31200278:metal:4230:31200699,31200280:metal:4230:31200748,31200283:metal:4230:31203345,31203033:metal:4230:31206619,31203034:metal:4230:31206675,31203035:metal:4230:31206721,31203037:metal:4230:31206815,31203038:metal:4230:31206852,31203039:metal:4230:31206914,31203041:metal:4230:31206984,31203042:metal:4230:31207032,31203044:metal:4230:31207088,31203047:metal:4230:31207426,31203048:metal:4230:31207334,31203049:metal:4230:31207262,31203050:metal:4230:31207307,31203051:metal:4230:31207386,31203052:metal:4230:31207523,31203053:metal:4230:31207476,31203095:metal:4230:31207571,31203096:metal:4230:31207599,31203097:metal:4230:31207678,31203101:metal:4230:31207772,31207763:metal:4230:31212060,31207765:metal:4230:31212134,31207766:metal:4230:31212231,31211829:metal:4230:31214071,31211830:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16940392854732947, 'nb_photo': 183918, 'list_port_cont': '31200355,31200407,31200443,31200491,31200533,31200576,31200618,31200668,31200714,31200749,31203337,31206633,31206672,31206727,31206764,31206816,31206862,31206907,31206952,31206988,31207034,31207086,31207117,31207162,31207198,31207268,31207311,31207336,31207394,31207430,31207468,31207525,31207568,31207616,31207644,31207690,31207727,31207777,31212058,31212097,31212144,31212188,31212227,31214029,31214064,31214105,31214147,31214188,31214220,31214277,31214323,31214380,31214414,31215116,31215160,31215212,31215249,31215701,31215781,31215853,31215982,31216301,31216356,31216405,31216462,31217062,31217106,31217326,31217551,31217776,31218045,31218324,31218541,31218851,31219174,31219522,31219669,31219878,31220239,31220511,31220786,31220999,31221313,31221539,31221773,31222012,31222358,31222539,31222623,31222992,31223208,31223449,31223750,31223988,31224248,31224473,31224703,31224889,31225148,31225428,31225910,31226535,31226981,31227015,31227275,31227535,31227982,31228216,31228478,31228667,31228993,31229309,31229663,3122998', 'assoc_port': '31200262:31200355,31200263:31200407,31200264:31200443,31200266:31200491,31200269:31200533,31200271:31200576,31200273:31200618,31200276:31200668,31200278:31200714,31200280:31200749,31200283:31203337,31203033:31206633,31203034:31206672,31203035:31206727,31203036:31206764,31203037:31206816,31203038:31206862,31203039:31206907,31203040:31206952,31203041:31206988,31203042:31207034,31203043:31207117,31203044:31207086,31203045:31207162,31203046:31207198,31203047:31207430,31203048:31207336,31203049:31207268,31203050:31207311,31203051:31207394,31203052:31207525,31203053:31207468,31203095:31207568,31203096:31207616,31203097:31207690,31203099:31207644,31203100:31207727,31203101:31207777,31207763:31212058,31207764:31212097,31207765:31212144,31207766:31212227,31207767:31212188,31211828:31214029,31211829:31214064,31211830:31214105,31211831:31214147,31211832:31214188,31211833:31214220,31211835:31214277,31211837:31214323,31211838:31214380,31211840:31214414,31214521:31215160,31214522:31215116,31214523:31215982,31214525:3121524', 'assoc_mat': '31200262:papier:4230:31200355,31200263:papier:4230:31200407,31200264:papier:4230:31200443,31200266:papier:4230:31200491,31200269:papier:4230:31200533,31200271:papier:4230:31200576,31200273:papier:4230:31200618,31200276:papier:4230:31200668,31200278:papier:4230:31200714,31200280:papier:4230:31200749,31200283:papier:4230:31203337,31203033:papier:4230:31206633,31203034:papier:4230:31206672,31203035:papier:4230:31206727,31203036:papier:4230:31206764,31203037:papier:4230:31206816,31203038:papier:4230:31206862,31203039:papier:4230:31206907,31203040:papier:4230:31206952,31203041:papier:4230:31206988,31203042:papier:4230:31207034,31203043:papier:4230:31207117,31203044:papier:4230:31207086,31203045:papier:4230:31207162,31203046:papier:4230:31207198,31203047:papier:4230:31207430,31203048:papier:4230:31207336,31203049:papier:4230:31207268,31203050:papier:4230:31207311,31203051:papier:4230:31207394,31203052:papier:4230:31207525,31203053:papier:4230:31207468,31203095:papier:4230:31207568,31203096:papier:4230:31207616,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0043032605629586065, 'nb_photo': 903, 'list_port_cont': '31200358,31200401,31200622,31200671,31200707,31200751,31203340,31206634,31206959,31206995,31207044,31207083,31207116,31207267,31207304,31207392,31207574,31207613,31207652,31207685,31207735,31212143,31212228,31214028,31214101,31214144,31214181,31214230,31214278,31214324,31214379,31214419,31215125,31215162,31215214,31215254,31215784,31215989,31216307,31217113,31217320,31217546,31217769,31218539,31218843,31219179,31219524,31219670,31219876,31220231,31220499,31220780,31221000,31221320,31221534,31221784,31222010,31222359,31222542,31222619,31222986,31223977,31224885,31225153,31225425,31227025,31227984,31228222,31228997,31229302,31229983,31230198,31230420,31230949,31231208,31231524,31231765,31232009,31232182,31232506,31232549,31232989,31233227,31233666,31233997,31234238,31234538,31234808,31235113,31235380,31236083,31236131,31236600,31236894,31237241,31237465,31238158,31238431,31238653,31238920,31239353,31239572,31239840,31240129,31240666,31240993,31241334,31241731,31242563,31242728,31244332,31244520,31244639,3124474', 'assoc_port': '31200262:31200358,31200263:31200401,31200273:31200622,31200276:31200671,31200278:31200707,31200280:31200751,31200283:31203340,31203033:31206634,31203040:31206959,31203041:31206995,31203042:31207044,31203043:31207116,31203044:31207083,31203049:31207267,31203050:31207304,31203051:31207392,31203095:31207574,31203096:31207613,31203097:31207685,31203099:31207652,31203100:31207735,31207765:31212143,31207766:31212228,31211828:31214028,31211830:31214101,31211831:31214144,31211832:31214181,31211833:31214230,31211835:31214278,31211837:31214324,31211838:31214379,31211840:31214419,31214521:31215162,31214522:31215125,31214523:31215989,31214525:31215254,31214527:31215214,31215325:31215784,31215830:31216307,31216871:31217113,31217194:31217320,31217426:31217546,31217692:31217769,31218469:31218539,31218733:31218843,31219009:31219179,31219311:31219524,31219552:31219670,31219767:31219876,31220084:31220231,31220364:31220499,31220631:31220780,31220867:31221000,31221124:31221320,31221398:31221534,31221632:31221784,31221903:3122201', 'assoc_mat': '31200262:pehd:4230:31200358,31200263:pehd:4230:31200401,31200273:pehd:4230:31200622,31200276:pehd:4230:31200671,31200278:pehd:4230:31200707,31200280:pehd:4230:31200751,31200283:pehd:4230:31203340,31203033:pehd:4230:31206634,31203040:pehd:4230:31206959,31203041:pehd:4230:31206995,31203042:pehd:4230:31207044,31203043:pehd:4230:31207116,31203044:pehd:4230:31207083,31203049:pehd:4230:31207267,31203050:pehd:4230:31207304,31203051:pehd:4230:31207392,31203095:pehd:4230:31207574,31203096:pehd:4230:31207613,31203097:pehd:4230:31207685,31203099:pehd:4230:31207652,31203100:pehd:4230:31207735,31207765:pehd:4230:31212143,31207766:pehd:4230:31212228,31211828:pehd:4230:31214028,31211830:pehd:4230:31214101,31211831:pehd:4230:31214144,31211832:pehd:4230:31214181,31211833:pehd:4230:31214230,31211835:pehd:4230:31214278,31211837:pehd:4230:31214324,31211838:pehd:4230:31214379,31211840:pehd:4230:31214419,31214521:pehd:4230:31215162,31214522:pehd:4230:31215125,31214523:pehd:4230:31215989,31214525:pehd:4230:31215254,31214527:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014001514843920345, 'nb_photo': 10173, 'list_port_cont': '31200356,31200406,31200451,31200495,31200529,31200570,31200614,31200669,31200709,31200753,31203342,31206624,31206674,31206718,31206768,31206820,31206864,31206915,31206958,31206994,31207042,31207079,31207124,31207158,31207208,31207263,31207302,31207341,31207380,31207421,31207473,31207522,31207570,31207610,31207656,31207689,31207737,31207786,31212057,31212110,31212148,31212185,31212221,31214033,31214070,31214104,31214143,31214189,31214226,31214271,31214337,31214374,31214412,31215123,31215159,31215208,31215252,31215705,31215782,31215847,31215978,31216306,31216353,31216408,31216449,31217067,31217100,31217327,31217544,31217781,31218038,31218327,31218540,31218842,31219183,31219527,31219671,31219867,31220234,31220507,31220792,31220997,31221315,31221535,31221774,31222007,31222355,31222541,31222609,31222982,31223210,31223436,31223752,31223992,31224244,31224474,31224700,31224892,31225149,31225430,31225918,31226538,31226982,31227024,31227264,31227543,31227985,31228228,31228479,31228661,31229001,31229299,31229660,3122998', 'assoc_port': '31200262:31200356,31200263:31200406,31200264:31200451,31200266:31200495,31200269:31200529,31200271:31200570,31200273:31200614,31200276:31200669,31200278:31200709,31200280:31200753,31200283:31203342,31203033:31206624,31203034:31206674,31203035:31206718,31203036:31206768,31203037:31206820,31203038:31206864,31203039:31206915,31203040:31206958,31203041:31206994,31203042:31207042,31203043:31207124,31203044:31207079,31203045:31207158,31203046:31207208,31203047:31207421,31203048:31207341,31203049:31207263,31203050:31207302,31203051:31207380,31203052:31207522,31203053:31207473,31203095:31207570,31203096:31207610,31203097:31207689,31203099:31207656,31203100:31207737,31203101:31207786,31207763:31212057,31207764:31212110,31207765:31212148,31207766:31212221,31207767:31212185,31211828:31214033,31211829:31214070,31211830:31214104,31211831:31214143,31211832:31214189,31211833:31214226,31211835:31214271,31211837:31214337,31211838:31214374,31211840:31214412,31214521:31215159,31214522:31215123,31214523:31215978,31214525:3121525', 'assoc_mat': '31200262:pet_clair:4230:31200356,31200263:pet_clair:4230:31200406,31200264:pet_clair:4230:31200451,31200266:pet_clair:4230:31200495,31200269:pet_clair:4230:31200529,31200271:pet_clair:4230:31200570,31200273:pet_clair:4230:31200614,31200276:pet_clair:4230:31200669,31200278:pet_clair:4230:31200709,31200280:pet_clair:4230:31200753,31200283:pet_clair:4230:31203342,31203033:pet_clair:4230:31206624,31203034:pet_clair:4230:31206674,31203035:pet_clair:4230:31206718,31203036:pet_clair:4230:31206768,31203037:pet_clair:4230:31206820,31203038:pet_clair:4230:31206864,31203039:pet_clair:4230:31206915,31203040:pet_clair:4230:31206958,31203041:pet_clair:4230:31206994,31203042:pet_clair:4230:31207042,31203043:pet_clair:4230:31207124,31203044:pet_clair:4230:31207079,31203045:pet_clair:4230:31207158,31203046:pet_clair:4230:31207208,31203047:pet_clair:4230:31207421,31203048:pet_clair:4230:31207341,31203049:pet_clair:4230:31207263,31203050:pet_clair:4230:31207302,31203051:pet_clair:4230:31207380,31203052:pet_clair:4230:31207522,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002107358984980607, 'nb_photo': 336, 'list_port_cont': '31200615,31200700,31203335,31206962,31207045,31207084,31207125,31207573,31207611,31207686,31207733,31212151,31214024,31214067,31214106,31214141,31214190,31214231,31214335,31214381,31214415,31215150,31215253,31215845,31215983,31216304,31216348,31217108,31217315,31218049,31219521,31219663,31220230,31220793,31220993,31221314,31221533,31221777,31222004,31222349,31222621,31222981,31223445,31223742,31224245,31224698,31225145,31225419,31228223,31229002,31229304,31230201,31230943,31231218,31231520,31231771,31232012,31232504,31232542,31233223,31234226,31235118,31236886,31237239,31237458,31237759,31238156,31238425,31238655,31238926,31239355,31239574,31239832,31240139,31241340,31241718,31242569,31242731,31244345,31244522,31244649,31244742,31245793,31245896,31245939,31245986,31246670,31246802,31247088,31247136,31247674,31247719,31247764,31248338,31248429,31248896,31249797,31250665,31251116,31251700,31252016,31252310,31252652,31253537,31255164,31255204,31256292,31257469,31258648,31259062,31259368,31259664,31260021,3126025', 'assoc_port': '31200273:31200615,31200278:31200700,31200283:31203335,31203040:31206962,31203042:31207045,31203043:31207125,31203044:31207084,31203095:31207573,31203096:31207611,31203097:31207686,31203100:31207733,31207765:31212151,31211828:31214024,31211829:31214067,31211830:31214106,31211831:31214141,31211832:31214190,31211833:31214231,31211837:31214335,31211838:31214381,31211840:31214415,31214521:31215150,31214523:31215983,31214525:31215253,31215327:31215845,31215830:31216304,31215831:31216348,31216871:31217108,31217194:31217315,31217924:31218049,31219311:31219521,31219552:31219663,31220084:31220230,31220631:31220793,31220867:31220993,31221124:31221314,31221398:31221533,31221632:31221777,31221903:31222004,31222164:31222349,31222433:31222621,31222845:31222981,31223371:31223445,31223604:31223742,31224141:31224245,31224559:31224698,31225039:31225145,31225307:31225419,31228036:31228223,31228828:31229002,31229131:31229304,31230013:31230201,31230832:31230943,31231103:31231218,31231364:31231520,31231611:31231771,31231844:3123201', 'assoc_mat': '31200273:pet_fonce:4230:31200615,31200278:pet_fonce:4230:31200700,31200283:pet_fonce:4230:31203335,31203040:pet_fonce:4230:31206962,31203042:pet_fonce:4230:31207045,31203043:pet_fonce:4230:31207125,31203044:pet_fonce:4230:31207084,31203095:pet_fonce:4230:31207573,31203096:pet_fonce:4230:31207611,31203097:pet_fonce:4230:31207686,31203100:pet_fonce:4230:31207733,31207765:pet_fonce:4230:31212151,31211828:pet_fonce:4230:31214024,31211829:pet_fonce:4230:31214067,31211830:pet_fonce:4230:31214106,31211831:pet_fonce:4230:31214141,31211832:pet_fonce:4230:31214190,31211833:pet_fonce:4230:31214231,31211837:pet_fonce:4230:31214335,31211838:pet_fonce:4230:31214381,31211840:pet_fonce:4230:31214415,31214521:pet_fonce:4230:31215150,31214523:pet_fonce:4230:31215983,31214525:pet_fonce:4230:31215253,31215327:pet_fonce:4230:31215845,31215830:pet_fonce:4230:31216304,31215831:pet_fonce:4230:31216348,31216871:pet_fonce:4230:31217108,31217194:pet_fonce:4230:31217315,31217924:pet_fonce:4230:31218049,31219311:pet_fonce:4230:31219521,3'}), 'main_stat': {'nb_photos': 982}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31302781,31302782,31302783,31302784,31302785,31302786,31302787?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-07', 0.7771262491488797),)]} 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': ((982,),), 'unwanted_material_monthly_percentage': ((0.7771262491488797,),), 'material_repartition': (('incineration', 982),), 'material_dict': {'incineration': 982}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 7, 1), 0.801944436310415, 1), (datetime.date(2026, 7, 2), 0.7455776641806129, 2), (datetime.date(2026, 7, 3), 0.7015556387422021, 2), (datetime.date(2026, 7, 4), 0.682090292797055, 3), (datetime.date(2026, 7, 5), 0.8077756197311334, 4), (datetime.date(2026, 7, 6), 0.7879099572621902, 2), (datetime.date(2026, 7, 7), 0.7654625224109125, 2), (datetime.date(2026, 7, 8), 0.7198458596945221, 3), (datetime.date(2026, 7, 9), 0.7581099836248356, 1), (datetime.date(2026, 7, 10), 0.7488022082000949, 1), (datetime.date(2026, 7, 11), 0.739341962940344, 2), (datetime.date(2026, 7, 12), 0.794657766999548, 1), (datetime.date(2026, 7, 13), 0.811575100111914, 2), (datetime.date(2026, 7, 14), 0.8891834682446904, 2), (datetime.date(2026, 7, 15), 0.8574969679278797, 2), (datetime.date(2026, 7, 16), 0.825843669663959, 2), (datetime.date(2026, 7, 17), 0.7975564521905616, 4), (datetime.date(2026, 7, 18), 0.7475528540484261, 3), (datetime.date(2026, 7, 19), 0.8089815799577867, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 7, 1), 0.801944436310415, 1), (datetime.date(2026, 7, 2), 0.7455776641806129, 2), (datetime.date(2026, 7, 3), 0.7015556387422021, 2), (datetime.date(2026, 7, 4), 0.682090292797055, 3), (datetime.date(2026, 7, 5), 0.8077756197311334, 4), (datetime.date(2026, 7, 6), 0.7879099572621902, 2), (datetime.date(2026, 7, 7), 0.7654625224109125, 2), (datetime.date(2026, 7, 8), 0.7198458596945221, 3), (datetime.date(2026, 7, 9), 0.7581099836248356, 1), (datetime.date(2026, 7, 10), 0.7488022082000949, 1), (datetime.date(2026, 7, 11), 0.739341962940344, 2), (datetime.date(2026, 7, 12), 0.794657766999548, 1), (datetime.date(2026, 7, 13), 0.811575100111914, 2), (datetime.date(2026, 7, 14), 0.8891834682446904, 2), (datetime.date(2026, 7, 15), 0.8574969679278797, 2), (datetime.date(2026, 7, 16), 0.825843669663959, 2), (datetime.date(2026, 7, 17), 0.7975564521905616, 4), (datetime.date(2026, 7, 18), 0.7475528540484261, 3), (datetime.date(2026, 7, 19), 0.8089815799577867, 1))}, 'quality_array': [['-8.26159304774946', '01072026'], ['-8.47337784902641', '02072026'], ['-8.762847646379026', '03072026'], ['-8.715348171394462', '04072026'], ['-8.73282949233469', '05072026'], ['-8.692909087623525', '06072026'], ['-8.573366702729304', '07072026'], ['-8.78116193175665', '08072026'], ['-8.493369342483122', '09072026'], ['-8.313019625025733', '10072026'], ['-8.610766993024924', '11072026'], ['-8.860880604025448', '12072026'], ['-8.372375951695034', '13072026'], ['-8.52097794682945', '14072026'], ['-7.931508041116178', '15072026'], ['-7.954455485665405', '16072026'], ['-8.18904692033734', '17072026'], ['-8.356651802926173', '18072026'], ['-8.446738672724795', '19072026']], 'number_of_batch': ((403,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012893863052266336, 'nb_photo': 8289, 'list_port_cont': '31200349,31200393,31200440,31200484,31200531,31200572,31200620,31200658,31200706,31200742,31203334,31206618,31206679,31206712,31206773,31206803,31206860,31206912,31206946,31206991,31207037,31207077,31207115,31207166,31207202,31207261,31207301,31207347,31207385,31207431,31207467,31207524,31207563,31207602,31207649,31207688,31207721,31207782,31212046,31212095,31212139,31212187,31212215,31214030,31214066,31214094,31214142,31214179,31214224,31214279,31214336,31214369,31214418,31215126,31215155,31215210,31215244,31215698,31215773,31215849,31215974,31216293,31216355,31216407,31216456,31217061,31217111,31217329,31217539,31217778,31218039,31218319,31218530,31218852,31219172,31219516,31219659,31219872,31220226,31220509,31220785,31220990,31221321,31221542,31221780,31222003,31222356,31222536,31222613,31222989,31223204,31223437,31223751,31223979,31224249,31224459,31224702,31224887,31225140,31225427,31225920,31226529,31226991,31227018,31227272,31227536,31227969,31228215,31228464,31228660,31228990,31229306,31229662,3122997', 'assoc_port': '31200262:31200349,31200263:31200393,31200264:31200440,31200266:31200484,31200269:31200531,31200271:31200572,31200273:31200620,31200276:31200658,31200278:31200706,31200280:31200742,31200283:31203334,31203033:31206618,31203034:31206679,31203035:31206712,31203036:31206773,31203037:31206803,31203038:31206860,31203039:31206912,31203040:31206946,31203041:31206991,31203042:31207037,31203043:31207115,31203044:31207077,31203045:31207166,31203046:31207202,31203047:31207431,31203048:31207347,31203049:31207261,31203050:31207301,31203051:31207385,31203052:31207524,31203053:31207467,31203095:31207563,31203096:31207602,31203097:31207688,31203099:31207649,31203100:31207721,31203101:31207782,31207763:31212046,31207764:31212095,31207765:31212139,31207766:31212215,31207767:31212187,31211828:31214030,31211829:31214066,31211830:31214094,31211831:31214142,31211832:31214179,31211833:31214224,31211835:31214279,31211837:31214336,31211838:31214369,31211840:31214418,31214521:31215155,31214522:31215126,31214523:31215974,31214525:3121524', 'assoc_mat': '31200262:autre:4230:31200349,31200263:autre:4230:31200393,31200264:autre:4230:31200440,31200266:autre:4230:31200484,31200269:autre:4230:31200531,31200271:autre:4230:31200572,31200273:autre:4230:31200620,31200276:autre:4230:31200658,31200278:autre:4230:31200706,31200280:autre:4230:31200742,31200283:autre:4230:31203334,31203033:autre:4230:31206618,31203034:autre:4230:31206679,31203035:autre:4230:31206712,31203036:autre:4230:31206773,31203037:autre:4230:31206803,31203038:autre:4230:31206860,31203039:autre:4230:31206912,31203040:autre:4230:31206946,31203041:autre:4230:31206991,31203042:autre:4230:31207037,31203043:autre:4230:31207115,31203044:autre:4230:31207077,31203045:autre:4230:31207166,31203046:autre:4230:31207202,31203047:autre:4230:31207431,31203048:autre:4230:31207347,31203049:autre:4230:31207261,31203050:autre:4230:31207301,31203051:autre:4230:31207385,31203052:autre:4230:31207524,31203053:autre:4230:31207467,31203095:autre:4230:31207563,31203096:autre:4230:31207602,31203097:autre:4230:31207688,31203099:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04851694421087934, 'nb_photo': 50910, 'list_port_cont': '31200365,31200396,31200450,31200486,31200540,31200567,31200621,31200674,31200711,31200747,31203332,31206630,31206670,31206725,31206769,31206809,31206859,31206911,31206950,31206998,31207048,31207074,31207110,31207161,31207210,31207260,31207309,31207348,31207384,31207433,31207469,31207512,31207566,31207608,31207654,31207691,31207734,31207781,31212059,31212108,31212147,31212180,31212230,31214018,31214068,31214107,31214145,31214182,31214228,31214273,31214330,31214368,31214411,31215127,31215164,31215215,31215257,31215693,31215776,31215852,31215986,31216300,31216350,31216409,31216454,31217065,31217109,31217321,31217548,31217772,31218050,31218328,31218544,31218850,31219171,31219523,31219672,31219868,31220238,31220512,31220787,31220988,31221316,31221532,31221782,31222013,31222354,31222530,31222615,31222995,31223214,31223441,31223740,31223984,31224242,31224476,31224704,31224890,31225151,31225429,31225911,31226537,31226988,31227027,31227265,31227546,31227975,31228227,31228475,31228665,31229003,31229307,31229656,3122998', 'assoc_port': '31200262:31200365,31200263:31200396,31200264:31200450,31200266:31200486,31200269:31200540,31200271:31200567,31200273:31200621,31200276:31200674,31200278:31200711,31200280:31200747,31200283:31203332,31203033:31206630,31203034:31206670,31203035:31206725,31203036:31206769,31203037:31206809,31203038:31206859,31203039:31206911,31203040:31206950,31203041:31206998,31203042:31207048,31203043:31207110,31203044:31207074,31203045:31207161,31203046:31207210,31203047:31207433,31203048:31207348,31203049:31207260,31203050:31207309,31203051:31207384,31203052:31207512,31203053:31207469,31203095:31207566,31203096:31207608,31203097:31207691,31203099:31207654,31203100:31207734,31203101:31207781,31207763:31212059,31207764:31212108,31207765:31212147,31207766:31212230,31207767:31212180,31211828:31214018,31211829:31214068,31211830:31214107,31211831:31214145,31211832:31214182,31211833:31214228,31211835:31214273,31211837:31214330,31211838:31214368,31211840:31214411,31214521:31215164,31214522:31215127,31214523:31215986,31214525:3121525', 'assoc_mat': '31200262:carton:4230:31200365,31200263:carton:4230:31200396,31200264:carton:4230:31200450,31200266:carton:4230:31200486,31200269:carton:4230:31200540,31200271:carton:4230:31200567,31200273:carton:4230:31200621,31200276:carton:4230:31200674,31200278:carton:4230:31200711,31200280:carton:4230:31200747,31200283:carton:4230:31203332,31203033:carton:4230:31206630,31203034:carton:4230:31206670,31203035:carton:4230:31206725,31203036:carton:4230:31206769,31203037:carton:4230:31206809,31203038:carton:4230:31206859,31203039:carton:4230:31206911,31203040:carton:4230:31206950,31203041:carton:4230:31206998,31203042:carton:4230:31207048,31203043:carton:4230:31207110,31203044:carton:4230:31207074,31203045:carton:4230:31207161,31203046:carton:4230:31207210,31203047:carton:4230:31207433,31203048:carton:4230:31207348,31203049:carton:4230:31207260,31203050:carton:4230:31207309,31203051:carton:4230:31207384,31203052:carton:4230:31207512,31203053:carton:4230:31207469,31203095:carton:4230:31207566,31203096:carton:4230:31207608,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011941160088214623, 'nb_photo': 883, 'list_port_cont': '31200360,31200404,31200445,31200493,31200539,31200565,31200613,31200657,31200699,31200748,31203345,31206619,31206675,31206721,31206815,31206852,31206914,31206984,31207032,31207088,31207262,31207307,31207334,31207386,31207426,31207476,31207523,31207571,31207599,31207678,31207772,31212060,31212134,31212231,31214071,31214108,31214262,31214334,31214365,31214406,31215128,31215157,31215213,31215255,31215785,31215844,31215990,31216295,31216358,31216397,31217099,31217317,31217542,31217773,31218325,31218545,31218848,31219176,31219514,31219664,31219879,31220784,31220989,31221317,31221526,31221769,31221997,31222348,31222533,31222617,31222983,31223746,31223981,31224237,31224475,31224693,31224891,31225152,31227270,31227986,31228224,31228467,31228994,31229305,31229661,31229980,31230193,31230417,31230663,31230938,31231216,31231525,31231770,31231998,31232490,31232544,31232997,31233212,31233424,31234000,31234807,31235116,31235383,31235710,31236088,31236132,31236598,31236637,31236893,31237229,31237752,31238149,31238427,3123864', 'assoc_port': '31200262:31200360,31200263:31200404,31200264:31200445,31200266:31200493,31200269:31200539,31200271:31200565,31200273:31200613,31200276:31200657,31200278:31200699,31200280:31200748,31200283:31203345,31203033:31206619,31203034:31206675,31203035:31206721,31203037:31206815,31203038:31206852,31203039:31206914,31203041:31206984,31203042:31207032,31203044:31207088,31203047:31207426,31203048:31207334,31203049:31207262,31203050:31207307,31203051:31207386,31203052:31207523,31203053:31207476,31203095:31207571,31203096:31207599,31203097:31207678,31203101:31207772,31207763:31212060,31207765:31212134,31207766:31212231,31211829:31214071,31211830:31214108,31211835:31214262,31211837:31214334,31211838:31214365,31211840:31214406,31214521:31215157,31214522:31215128,31214523:31215990,31214525:31215255,31214527:31215213,31215325:31215785,31215327:31215844,31215830:31216295,31215831:31216358,31215952:31216397,31216871:31217099,31217194:31217317,31217426:31217542,31217692:31217773,31218176:31218325,31218469:31218545,31218733:3121884', 'assoc_mat': '31200262:metal:4230:31200360,31200263:metal:4230:31200404,31200264:metal:4230:31200445,31200266:metal:4230:31200493,31200269:metal:4230:31200539,31200271:metal:4230:31200565,31200273:metal:4230:31200613,31200276:metal:4230:31200657,31200278:metal:4230:31200699,31200280:metal:4230:31200748,31200283:metal:4230:31203345,31203033:metal:4230:31206619,31203034:metal:4230:31206675,31203035:metal:4230:31206721,31203037:metal:4230:31206815,31203038:metal:4230:31206852,31203039:metal:4230:31206914,31203041:metal:4230:31206984,31203042:metal:4230:31207032,31203044:metal:4230:31207088,31203047:metal:4230:31207426,31203048:metal:4230:31207334,31203049:metal:4230:31207262,31203050:metal:4230:31207307,31203051:metal:4230:31207386,31203052:metal:4230:31207523,31203053:metal:4230:31207476,31203095:metal:4230:31207571,31203096:metal:4230:31207599,31203097:metal:4230:31207678,31203101:metal:4230:31207772,31207763:metal:4230:31212060,31207765:metal:4230:31212134,31207766:metal:4230:31212231,31211829:metal:4230:31214071,31211830:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16940392854732947, 'nb_photo': 183918, 'list_port_cont': '31200355,31200407,31200443,31200491,31200533,31200576,31200618,31200668,31200714,31200749,31203337,31206633,31206672,31206727,31206764,31206816,31206862,31206907,31206952,31206988,31207034,31207086,31207117,31207162,31207198,31207268,31207311,31207336,31207394,31207430,31207468,31207525,31207568,31207616,31207644,31207690,31207727,31207777,31212058,31212097,31212144,31212188,31212227,31214029,31214064,31214105,31214147,31214188,31214220,31214277,31214323,31214380,31214414,31215116,31215160,31215212,31215249,31215701,31215781,31215853,31215982,31216301,31216356,31216405,31216462,31217062,31217106,31217326,31217551,31217776,31218045,31218324,31218541,31218851,31219174,31219522,31219669,31219878,31220239,31220511,31220786,31220999,31221313,31221539,31221773,31222012,31222358,31222539,31222623,31222992,31223208,31223449,31223750,31223988,31224248,31224473,31224703,31224889,31225148,31225428,31225910,31226535,31226981,31227015,31227275,31227535,31227982,31228216,31228478,31228667,31228993,31229309,31229663,3122998', 'assoc_port': '31200262:31200355,31200263:31200407,31200264:31200443,31200266:31200491,31200269:31200533,31200271:31200576,31200273:31200618,31200276:31200668,31200278:31200714,31200280:31200749,31200283:31203337,31203033:31206633,31203034:31206672,31203035:31206727,31203036:31206764,31203037:31206816,31203038:31206862,31203039:31206907,31203040:31206952,31203041:31206988,31203042:31207034,31203043:31207117,31203044:31207086,31203045:31207162,31203046:31207198,31203047:31207430,31203048:31207336,31203049:31207268,31203050:31207311,31203051:31207394,31203052:31207525,31203053:31207468,31203095:31207568,31203096:31207616,31203097:31207690,31203099:31207644,31203100:31207727,31203101:31207777,31207763:31212058,31207764:31212097,31207765:31212144,31207766:31212227,31207767:31212188,31211828:31214029,31211829:31214064,31211830:31214105,31211831:31214147,31211832:31214188,31211833:31214220,31211835:31214277,31211837:31214323,31211838:31214380,31211840:31214414,31214521:31215160,31214522:31215116,31214523:31215982,31214525:3121524', 'assoc_mat': '31200262:papier:4230:31200355,31200263:papier:4230:31200407,31200264:papier:4230:31200443,31200266:papier:4230:31200491,31200269:papier:4230:31200533,31200271:papier:4230:31200576,31200273:papier:4230:31200618,31200276:papier:4230:31200668,31200278:papier:4230:31200714,31200280:papier:4230:31200749,31200283:papier:4230:31203337,31203033:papier:4230:31206633,31203034:papier:4230:31206672,31203035:papier:4230:31206727,31203036:papier:4230:31206764,31203037:papier:4230:31206816,31203038:papier:4230:31206862,31203039:papier:4230:31206907,31203040:papier:4230:31206952,31203041:papier:4230:31206988,31203042:papier:4230:31207034,31203043:papier:4230:31207117,31203044:papier:4230:31207086,31203045:papier:4230:31207162,31203046:papier:4230:31207198,31203047:papier:4230:31207430,31203048:papier:4230:31207336,31203049:papier:4230:31207268,31203050:papier:4230:31207311,31203051:papier:4230:31207394,31203052:papier:4230:31207525,31203053:papier:4230:31207468,31203095:papier:4230:31207568,31203096:papier:4230:31207616,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0043032605629586065, 'nb_photo': 903, 'list_port_cont': '31200358,31200401,31200622,31200671,31200707,31200751,31203340,31206634,31206959,31206995,31207044,31207083,31207116,31207267,31207304,31207392,31207574,31207613,31207652,31207685,31207735,31212143,31212228,31214028,31214101,31214144,31214181,31214230,31214278,31214324,31214379,31214419,31215125,31215162,31215214,31215254,31215784,31215989,31216307,31217113,31217320,31217546,31217769,31218539,31218843,31219179,31219524,31219670,31219876,31220231,31220499,31220780,31221000,31221320,31221534,31221784,31222010,31222359,31222542,31222619,31222986,31223977,31224885,31225153,31225425,31227025,31227984,31228222,31228997,31229302,31229983,31230198,31230420,31230949,31231208,31231524,31231765,31232009,31232182,31232506,31232549,31232989,31233227,31233666,31233997,31234238,31234538,31234808,31235113,31235380,31236083,31236131,31236600,31236894,31237241,31237465,31238158,31238431,31238653,31238920,31239353,31239572,31239840,31240129,31240666,31240993,31241334,31241731,31242563,31242728,31244332,31244520,31244639,3124474', 'assoc_port': '31200262:31200358,31200263:31200401,31200273:31200622,31200276:31200671,31200278:31200707,31200280:31200751,31200283:31203340,31203033:31206634,31203040:31206959,31203041:31206995,31203042:31207044,31203043:31207116,31203044:31207083,31203049:31207267,31203050:31207304,31203051:31207392,31203095:31207574,31203096:31207613,31203097:31207685,31203099:31207652,31203100:31207735,31207765:31212143,31207766:31212228,31211828:31214028,31211830:31214101,31211831:31214144,31211832:31214181,31211833:31214230,31211835:31214278,31211837:31214324,31211838:31214379,31211840:31214419,31214521:31215162,31214522:31215125,31214523:31215989,31214525:31215254,31214527:31215214,31215325:31215784,31215830:31216307,31216871:31217113,31217194:31217320,31217426:31217546,31217692:31217769,31218469:31218539,31218733:31218843,31219009:31219179,31219311:31219524,31219552:31219670,31219767:31219876,31220084:31220231,31220364:31220499,31220631:31220780,31220867:31221000,31221124:31221320,31221398:31221534,31221632:31221784,31221903:3122201', 'assoc_mat': '31200262:pehd:4230:31200358,31200263:pehd:4230:31200401,31200273:pehd:4230:31200622,31200276:pehd:4230:31200671,31200278:pehd:4230:31200707,31200280:pehd:4230:31200751,31200283:pehd:4230:31203340,31203033:pehd:4230:31206634,31203040:pehd:4230:31206959,31203041:pehd:4230:31206995,31203042:pehd:4230:31207044,31203043:pehd:4230:31207116,31203044:pehd:4230:31207083,31203049:pehd:4230:31207267,31203050:pehd:4230:31207304,31203051:pehd:4230:31207392,31203095:pehd:4230:31207574,31203096:pehd:4230:31207613,31203097:pehd:4230:31207685,31203099:pehd:4230:31207652,31203100:pehd:4230:31207735,31207765:pehd:4230:31212143,31207766:pehd:4230:31212228,31211828:pehd:4230:31214028,31211830:pehd:4230:31214101,31211831:pehd:4230:31214144,31211832:pehd:4230:31214181,31211833:pehd:4230:31214230,31211835:pehd:4230:31214278,31211837:pehd:4230:31214324,31211838:pehd:4230:31214379,31211840:pehd:4230:31214419,31214521:pehd:4230:31215162,31214522:pehd:4230:31215125,31214523:pehd:4230:31215989,31214525:pehd:4230:31215254,31214527:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014001514843920345, 'nb_photo': 10173, 'list_port_cont': '31200356,31200406,31200451,31200495,31200529,31200570,31200614,31200669,31200709,31200753,31203342,31206624,31206674,31206718,31206768,31206820,31206864,31206915,31206958,31206994,31207042,31207079,31207124,31207158,31207208,31207263,31207302,31207341,31207380,31207421,31207473,31207522,31207570,31207610,31207656,31207689,31207737,31207786,31212057,31212110,31212148,31212185,31212221,31214033,31214070,31214104,31214143,31214189,31214226,31214271,31214337,31214374,31214412,31215123,31215159,31215208,31215252,31215705,31215782,31215847,31215978,31216306,31216353,31216408,31216449,31217067,31217100,31217327,31217544,31217781,31218038,31218327,31218540,31218842,31219183,31219527,31219671,31219867,31220234,31220507,31220792,31220997,31221315,31221535,31221774,31222007,31222355,31222541,31222609,31222982,31223210,31223436,31223752,31223992,31224244,31224474,31224700,31224892,31225149,31225430,31225918,31226538,31226982,31227024,31227264,31227543,31227985,31228228,31228479,31228661,31229001,31229299,31229660,3122998', 'assoc_port': '31200262:31200356,31200263:31200406,31200264:31200451,31200266:31200495,31200269:31200529,31200271:31200570,31200273:31200614,31200276:31200669,31200278:31200709,31200280:31200753,31200283:31203342,31203033:31206624,31203034:31206674,31203035:31206718,31203036:31206768,31203037:31206820,31203038:31206864,31203039:31206915,31203040:31206958,31203041:31206994,31203042:31207042,31203043:31207124,31203044:31207079,31203045:31207158,31203046:31207208,31203047:31207421,31203048:31207341,31203049:31207263,31203050:31207302,31203051:31207380,31203052:31207522,31203053:31207473,31203095:31207570,31203096:31207610,31203097:31207689,31203099:31207656,31203100:31207737,31203101:31207786,31207763:31212057,31207764:31212110,31207765:31212148,31207766:31212221,31207767:31212185,31211828:31214033,31211829:31214070,31211830:31214104,31211831:31214143,31211832:31214189,31211833:31214226,31211835:31214271,31211837:31214337,31211838:31214374,31211840:31214412,31214521:31215159,31214522:31215123,31214523:31215978,31214525:3121525', 'assoc_mat': '31200262:pet_clair:4230:31200356,31200263:pet_clair:4230:31200406,31200264:pet_clair:4230:31200451,31200266:pet_clair:4230:31200495,31200269:pet_clair:4230:31200529,31200271:pet_clair:4230:31200570,31200273:pet_clair:4230:31200614,31200276:pet_clair:4230:31200669,31200278:pet_clair:4230:31200709,31200280:pet_clair:4230:31200753,31200283:pet_clair:4230:31203342,31203033:pet_clair:4230:31206624,31203034:pet_clair:4230:31206674,31203035:pet_clair:4230:31206718,31203036:pet_clair:4230:31206768,31203037:pet_clair:4230:31206820,31203038:pet_clair:4230:31206864,31203039:pet_clair:4230:31206915,31203040:pet_clair:4230:31206958,31203041:pet_clair:4230:31206994,31203042:pet_clair:4230:31207042,31203043:pet_clair:4230:31207124,31203044:pet_clair:4230:31207079,31203045:pet_clair:4230:31207158,31203046:pet_clair:4230:31207208,31203047:pet_clair:4230:31207421,31203048:pet_clair:4230:31207341,31203049:pet_clair:4230:31207263,31203050:pet_clair:4230:31207302,31203051:pet_clair:4230:31207380,31203052:pet_clair:4230:31207522,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002107358984980607, 'nb_photo': 336, 'list_port_cont': '31200615,31200700,31203335,31206962,31207045,31207084,31207125,31207573,31207611,31207686,31207733,31212151,31214024,31214067,31214106,31214141,31214190,31214231,31214335,31214381,31214415,31215150,31215253,31215845,31215983,31216304,31216348,31217108,31217315,31218049,31219521,31219663,31220230,31220793,31220993,31221314,31221533,31221777,31222004,31222349,31222621,31222981,31223445,31223742,31224245,31224698,31225145,31225419,31228223,31229002,31229304,31230201,31230943,31231218,31231520,31231771,31232012,31232504,31232542,31233223,31234226,31235118,31236886,31237239,31237458,31237759,31238156,31238425,31238655,31238926,31239355,31239574,31239832,31240139,31241340,31241718,31242569,31242731,31244345,31244522,31244649,31244742,31245793,31245896,31245939,31245986,31246670,31246802,31247088,31247136,31247674,31247719,31247764,31248338,31248429,31248896,31249797,31250665,31251116,31251700,31252016,31252310,31252652,31253537,31255164,31255204,31256292,31257469,31258648,31259062,31259368,31259664,31260021,3126025', 'assoc_port': '31200273:31200615,31200278:31200700,31200283:31203335,31203040:31206962,31203042:31207045,31203043:31207125,31203044:31207084,31203095:31207573,31203096:31207611,31203097:31207686,31203100:31207733,31207765:31212151,31211828:31214024,31211829:31214067,31211830:31214106,31211831:31214141,31211832:31214190,31211833:31214231,31211837:31214335,31211838:31214381,31211840:31214415,31214521:31215150,31214523:31215983,31214525:31215253,31215327:31215845,31215830:31216304,31215831:31216348,31216871:31217108,31217194:31217315,31217924:31218049,31219311:31219521,31219552:31219663,31220084:31220230,31220631:31220793,31220867:31220993,31221124:31221314,31221398:31221533,31221632:31221777,31221903:31222004,31222164:31222349,31222433:31222621,31222845:31222981,31223371:31223445,31223604:31223742,31224141:31224245,31224559:31224698,31225039:31225145,31225307:31225419,31228036:31228223,31228828:31229002,31229131:31229304,31230013:31230201,31230832:31230943,31231103:31231218,31231364:31231520,31231611:31231771,31231844:3123201', 'assoc_mat': '31200273:pet_fonce:4230:31200615,31200278:pet_fonce:4230:31200700,31200283:pet_fonce:4230:31203335,31203040:pet_fonce:4230:31206962,31203042:pet_fonce:4230:31207045,31203043:pet_fonce:4230:31207125,31203044:pet_fonce:4230:31207084,31203095:pet_fonce:4230:31207573,31203096:pet_fonce:4230:31207611,31203097:pet_fonce:4230:31207686,31203100:pet_fonce:4230:31207733,31207765:pet_fonce:4230:31212151,31211828:pet_fonce:4230:31214024,31211829:pet_fonce:4230:31214067,31211830:pet_fonce:4230:31214106,31211831:pet_fonce:4230:31214141,31211832:pet_fonce:4230:31214190,31211833:pet_fonce:4230:31214231,31211837:pet_fonce:4230:31214335,31211838:pet_fonce:4230:31214381,31211840:pet_fonce:4230:31214415,31214521:pet_fonce:4230:31215150,31214523:pet_fonce:4230:31215983,31214525:pet_fonce:4230:31215253,31215327:pet_fonce:4230:31215845,31215830:pet_fonce:4230:31216304,31215831:pet_fonce:4230:31216348,31216871:pet_fonce:4230:31217108,31217194:pet_fonce:4230:31217315,31217924:pet_fonce:4230:31218049,31219311:pet_fonce:4230:31219521,3'}), 'main_stat': {'nb_photos': 982}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31302781,31302782,31302783,31302784,31302785,31302786,31302787?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-07', 0.7771262491488797),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_07_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.29%', 8289], 'carton': ['carton', '4.85%', 50910], 'metal': ['metal', '0.12%', 883], 'papier': ['papier', '16.94%', 183918], 'pehd': ['pehd', '0.43%', 903], 'pet_clair': ['pet_clair', '1.4%', 10173], 'pet_fonce': ['pet_fonce', '0.21%', 336]}} 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_07_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.60user 3.08system 0:08.74elapsed 65%CPU (0avgtext+0avgdata 189276maxresident)k 8inputs+296outputs (1major+54143minor)pagefaults 0swaps