python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-08 _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 : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 08 mtr_id : dashboard_places : SCCU_cam6 date : 2026-08 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2026-08%') and created_at like '%2026-08%'))); nb_day : (5, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 08 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 08 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%082026%' and cps.thcl = 1533 GROUP BY sbstr ; Erreur dans le nom de portfolio du batch invalid literal for int() with base 10: 'SCCU' after number_of_batch date_start : 2026-08-01 : dt_date_just_month_year : 2026-08-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-08-01" AND ded.date <= "2026-08-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 (2987110,2987340,2987530,2987666,2987940,2988214,2988686,2989188,2989716,2990224,2990718,2991230,2991758,2992354,2993102) 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.01383059353906557, 'nb_photo': 6504, 'list_port_cont': '31046621,31046749,31046793,31046828,31046865,31046908,31047196,31047301,31047336,31047451,31047629,31047782,31047942,31048018,31048176,31048593,31048629,31048728,31048798,31049044,31049095,31049452,31049698,31050023,31050210,31050443,31050720,31051053,31051221,31051476,31051651,31051847,31051896,31052204,31052438,31052652,31053174,31053313,31053408,31053949,31054090,31054201,31054388,31054652,31054895,31055144,31055391,31055634,31055834,31056171,31056373,31056618,31056868,31057067,31057316,31057493,31057536,31057811,31058098,31058331,31058612,31058842,31059093,31059264,31059719,31060034,31060259,31060450,31060495,31060737,31061006,31061217,31061460,31061711,31061916,31062284,31062570,31062753,31062851,31063056,31063079,31063454,31063480,31063755,31063926,31064258,31064406,31064618,31064861,31065001,31065300,31065516,31065847,31066148,31066357,31066614,31066810,31066992,31067268,31067555,31067716,31067853,31068128,31068296,31068325,31068800,31068891,31069108,31069272,31069579,31069851,31070104,31070268,3107049', 'assoc_port': '31045057:31046621,31045058:31046749,31045059:31046793,31045060:31046908,31045061:31046865,31045062:31046828,31045266:31047196,31047218:31047336,31047219:31047301,31047374:31047451,31047561:31047629,31047762:31047782,31047938:31048018,31047939:31047942,31048152:31048176,31048582:31048629,31048583:31048593,31048720:31048728,31048779:31048798,31049041:31049095,31049042:31049044,31049405:31049452,31049688:31049698,31049893:31050023,31050098:31050210,31050347:31050443,31050593:31050720,31050885:31051053,31051157:31051221,31051365:31051476,31051616:31051651,31051829:31051896,31051830:31051847,31052139:31052204,31052383:31052438,31052632:31052652,31052879:31053313,31053088:31053174,31053351:31053408,31053598:31054201,31053844:31053949,31054019:31054090,31054312:31054388,31054568:31054652,31054826:31054895,31055086:31055144,31055334:31055391,31055580:31055634,31055820:31055834,31056058:31056171,31056319:31056373,31056561:31056618,31056805:31056868,31057012:31057067,31057262:31057316,31057476:31057493,31057477:3105753', 'assoc_mat': '31045057:autre:4230:31046621,31045058:autre:4230:31046749,31045059:autre:4230:31046793,31045060:autre:4230:31046908,31045061:autre:4230:31046865,31045062:autre:4230:31046828,31045266:autre:4230:31047196,31047218:autre:4230:31047336,31047219:autre:4230:31047301,31047374:autre:4230:31047451,31047561:autre:4230:31047629,31047762:autre:4230:31047782,31047938:autre:4230:31048018,31047939:autre:4230:31047942,31048152:autre:4230:31048176,31048582:autre:4230:31048629,31048583:autre:4230:31048593,31048720:autre:4230:31048728,31048779:autre:4230:31048798,31049041:autre:4230:31049095,31049042:autre:4230:31049044,31049405:autre:4230:31049452,31049688:autre:4230:31049698,31049893:autre:4230:31050023,31050098:autre:4230:31050210,31050347:autre:4230:31050443,31050593:autre:4230:31050720,31050885:autre:4230:31051053,31051157:autre:4230:31051221,31051365:autre:4230:31051476,31051616:autre:4230:31051651,31051829:autre:4230:31051896,31051830:autre:4230:31051847,31052139:autre:4230:31052204,31052383:autre:4230:31052438,31052632:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02865100388724626, 'nb_photo': 20108, 'list_port_cont': '31046620,31046761,31046800,31046837,31046868,31046905,31047184,31047316,31047351,31047458,31047623,31047778,31047956,31048027,31048183,31048589,31048632,31048732,31048793,31049057,31049090,31049441,31049709,31050032,31050198,31050455,31050713,31051056,31051226,31051466,31051648,31051855,31051897,31052195,31052454,31052661,31053170,31053316,31053421,31053950,31054084,31054208,31054374,31054645,31054907,31055156,31055393,31055637,31055844,31056173,31056383,31056621,31056865,31057076,31057330,31057505,31057543,31057810,31058092,31058339,31058624,31058838,31059090,31059257,31059729,31060031,31060254,31060445,31060494,31060728,31061012,31061206,31061469,31061718,31061917,31062292,31062574,31062765,31062849,31063045,31063092,31063445,31063492,31063763,31063929,31064254,31064411,31064630,31064877,31065010,31065305,31065522,31065839,31066158,31066364,31066608,31066821,31067000,31067283,31067557,31067718,31067858,31068134,31068286,31068333,31068809,31068890,31069119,31069276,31069581,31069860,31070095,31070272,3107048', 'assoc_port': '31045057:31046620,31045058:31046761,31045059:31046800,31045060:31046905,31045061:31046868,31045062:31046837,31045266:31047184,31047218:31047351,31047219:31047316,31047374:31047458,31047561:31047623,31047762:31047778,31047938:31048027,31047939:31047956,31048152:31048183,31048582:31048632,31048583:31048589,31048720:31048732,31048779:31048793,31049041:31049090,31049042:31049057,31049405:31049441,31049688:31049709,31049893:31050032,31050098:31050198,31050347:31050455,31050593:31050713,31050885:31051056,31051157:31051226,31051365:31051466,31051616:31051648,31051829:31051897,31051830:31051855,31052139:31052195,31052383:31052454,31052632:31052661,31052879:31053316,31053088:31053170,31053351:31053421,31053598:31054208,31053844:31053950,31054019:31054084,31054312:31054374,31054568:31054645,31054826:31054907,31055086:31055156,31055334:31055393,31055580:31055637,31055820:31055844,31056058:31056173,31056319:31056383,31056561:31056621,31056805:31056865,31057012:31057076,31057262:31057330,31057476:31057505,31057477:3105754', 'assoc_mat': '31045057:carton:4230:31046620,31045058:carton:4230:31046761,31045059:carton:4230:31046800,31045060:carton:4230:31046905,31045061:carton:4230:31046868,31045062:carton:4230:31046837,31045266:carton:4230:31047184,31047218:carton:4230:31047351,31047219:carton:4230:31047316,31047374:carton:4230:31047458,31047561:carton:4230:31047623,31047762:carton:4230:31047778,31047938:carton:4230:31048027,31047939:carton:4230:31047956,31048152:carton:4230:31048183,31048582:carton:4230:31048632,31048583:carton:4230:31048589,31048720:carton:4230:31048732,31048779:carton:4230:31048793,31049041:carton:4230:31049090,31049042:carton:4230:31049057,31049405:carton:4230:31049441,31049688:carton:4230:31049709,31049893:carton:4230:31050032,31050098:carton:4230:31050198,31050347:carton:4230:31050455,31050593:carton:4230:31050713,31050885:carton:4230:31051056,31051157:carton:4230:31051226,31051365:carton:4230:31051466,31051616:carton:4230:31051648,31051829:carton:4230:31051897,31051830:carton:4230:31051855,31052139:carton:4230:31052195,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008604005016482317, 'nb_photo': 413, 'list_port_cont': '31046608,31046762,31046797,31046833,31046901,31047350,31047456,31047768,31048024,31048171,31048634,31049705,31050030,31050201,31050448,31051057,31051212,31051470,31051636,31052453,31052651,31053311,31053415,31054636,31055149,31055397,31055645,31056168,31056370,31056854,31057072,31057509,31060487,31061459,31061713,31061925,31062572,31062836,31063081,31063451,31063761,31063916,31064246,31064873,31064998,31065297,31065526,31065834,31066150,31066365,31066615,31066819,31066991,31067270,31067560,31067713,31068130,31068319,31068802,31069111,31069277,31069571,31069853,31070102,31070263,31070495,31070781,31070997,31071241,31071347,31071592,31071879,31072584,31072755,31072984,31073164,31073484,31073612,31073649,31074057,31074333,31074529,31074746,31074961,31075190,31075580,31075820,31076046,31076209,31076454,31076631,31076917,31077086,31077404,31077637,31078061,31078297,31078765,31079111,31079608,31079878,31080333,31080524,31080887,31081095,31081278,31081466,31081728,31082210,31082450,31082707,31083152,31083333,3108360', 'assoc_port': '31045057:31046608,31045058:31046762,31045059:31046797,31045060:31046901,31045062:31046833,31047218:31047350,31047374:31047456,31047762:31047768,31047938:31048024,31048152:31048171,31048582:31048634,31049688:31049705,31049893:31050030,31050098:31050201,31050347:31050448,31050885:31051057,31051157:31051212,31051365:31051470,31051616:31051636,31052383:31052453,31052632:31052651,31052879:31053311,31053351:31053415,31054568:31054636,31055086:31055149,31055334:31055397,31055580:31055645,31056058:31056168,31056319:31056370,31056805:31056854,31057012:31057072,31057476:31057509,31060437:31060487,31061399:31061459,31061642:31061713,31061899:31061925,31062510:31062572,31062789:31062836,31063031:31063081,31063433:31063451,31063739:31063761,31063899:31063916,31064144:31064246,31064773:31064873,31064983:31064998,31065237:31065297,31065488:31065526,31065752:31065834,31066031:31066150,31066305:31066365,31066515:31066615,31066754:31066819,31066923:31066991,31067145:31067270,31067422:31067560,31067661:31067713,31068071:3106813', 'assoc_mat': '31045057:metal:4230:31046608,31045058:metal:4230:31046762,31045059:metal:4230:31046797,31045060:metal:4230:31046901,31045062:metal:4230:31046833,31047218:metal:4230:31047350,31047374:metal:4230:31047456,31047762:metal:4230:31047768,31047938:metal:4230:31048024,31048152:metal:4230:31048171,31048582:metal:4230:31048634,31049688:metal:4230:31049705,31049893:metal:4230:31050030,31050098:metal:4230:31050201,31050347:metal:4230:31050448,31050885:metal:4230:31051057,31051157:metal:4230:31051212,31051365:metal:4230:31051470,31051616:metal:4230:31051636,31052383:metal:4230:31052453,31052632:metal:4230:31052651,31052879:metal:4230:31053311,31053351:metal:4230:31053415,31054568:metal:4230:31054636,31055086:metal:4230:31055149,31055334:metal:4230:31055397,31055580:metal:4230:31055645,31056058:metal:4230:31056168,31056319:metal:4230:31056370,31056805:metal:4230:31056854,31057012:metal:4230:31057072,31057476:metal:4230:31057509,31060437:metal:4230:31060487,31061399:metal:4230:31061459,31061642:metal:4230:31061713,31061899:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16700071442774592, 'nb_photo': 118958, 'list_port_cont': '31046612,31046765,31046799,31046824,31046874,31046907,31047198,31047310,31047352,31047454,31047625,31047776,31047955,31048026,31048185,31048598,31048635,31048733,31048796,31049058,31049085,31049449,31049700,31050027,31050200,31050452,31050726,31051055,31051217,31051474,31051652,31051858,31051890,31052205,31052450,31052665,31053173,31053320,31053420,31053944,31054087,31054207,31054385,31054651,31054902,31055157,31055401,31055646,31055842,31056178,31056382,31056626,31056862,31057075,31057326,31057502,31057535,31057806,31058093,31058335,31058618,31058840,31059094,31059266,31059730,31060035,31060247,31060456,31060489,31060736,31061019,31061212,31061466,31061714,31061927,31062299,31062565,31062760,31062848,31063051,31063094,31063449,31063497,31063762,31063930,31064251,31064421,31064622,31064874,31065007,31065302,31065530,31065845,31066154,31066366,31066610,31066814,31067006,31067281,31067562,31067721,31067848,31068124,31068291,31068321,31068813,31068883,31069114,31069285,31069575,31069847,31070107,31070266,3107048', 'assoc_port': '31045057:31046612,31045058:31046765,31045059:31046799,31045060:31046907,31045061:31046874,31045062:31046824,31045266:31047198,31047218:31047352,31047219:31047310,31047374:31047454,31047561:31047625,31047762:31047776,31047938:31048026,31047939:31047955,31048152:31048185,31048582:31048635,31048583:31048598,31048720:31048733,31048779:31048796,31049041:31049085,31049042:31049058,31049405:31049449,31049688:31049700,31049893:31050027,31050098:31050200,31050347:31050452,31050593:31050726,31050885:31051055,31051157:31051217,31051365:31051474,31051616:31051652,31051829:31051890,31051830:31051858,31052139:31052205,31052383:31052450,31052632:31052665,31052879:31053320,31053088:31053173,31053351:31053420,31053598:31054207,31053844:31053944,31054019:31054087,31054312:31054385,31054568:31054651,31054826:31054902,31055086:31055157,31055334:31055401,31055580:31055646,31055820:31055842,31056058:31056178,31056319:31056382,31056561:31056626,31056805:31056862,31057012:31057075,31057262:31057326,31057476:31057502,31057477:3105753', 'assoc_mat': '31045057:papier:4230:31046612,31045058:papier:4230:31046765,31045059:papier:4230:31046799,31045060:papier:4230:31046907,31045061:papier:4230:31046874,31045062:papier:4230:31046824,31045266:papier:4230:31047198,31047218:papier:4230:31047352,31047219:papier:4230:31047310,31047374:papier:4230:31047454,31047561:papier:4230:31047625,31047762:papier:4230:31047776,31047938:papier:4230:31048026,31047939:papier:4230:31047955,31048152:papier:4230:31048185,31048582:papier:4230:31048635,31048583:papier:4230:31048598,31048720:papier:4230:31048733,31048779:papier:4230:31048796,31049041:papier:4230:31049085,31049042:papier:4230:31049058,31049405:papier:4230:31049449,31049688:papier:4230:31049700,31049893:papier:4230:31050027,31050098:papier:4230:31050200,31050347:papier:4230:31050452,31050593:papier:4230:31050726,31050885:papier:4230:31051055,31051157:papier:4230:31051217,31051365:papier:4230:31051474,31051616:papier:4230:31051652,31051829:papier:4230:31051890,31051830:papier:4230:31051858,31052139:papier:4230:31052205,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0025050445267051, 'nb_photo': 479, 'list_port_cont': '31046759,31046902,31047347,31047462,31047616,31047954,31048023,31048180,31049084,31049711,31050025,31050208,31050457,31050725,31051048,31051222,31051643,31051853,31051891,31052206,31052444,31052660,31053416,31054908,31055394,31055640,31056625,31056861,31058626,31059259,31059727,31060030,31060258,31060455,31060498,31061210,31061467,31061712,31061926,31062297,31062576,31062844,31063461,31063760,31063928,31064256,31064409,31065293,31065532,31066153,31066355,31066613,31066818,31067002,31067285,31067559,31067715,31068298,31068329,31068882,31069284,31069577,31069852,31070782,31071010,31071240,31071583,31072339,31072590,31072752,31072990,31073174,31073490,31073607,31073657,31074074,31074337,31074527,31074754,31074963,31075194,31075372,31075577,31075816,31076044,31076217,31076447,31076624,31077078,31077401,31077817,31078057,31078747,31079540,31079891,31080890,31081096,31081276,31081481,31081726,31081938,31082203,31082458,31082708,31082833,31083145,31083334,31083612,31083847,31083945,31084026,31084578,31084817,3108509', 'assoc_port': '31045058:31046759,31045060:31046902,31047218:31047347,31047374:31047462,31047561:31047616,31047938:31048023,31047939:31047954,31048152:31048180,31049041:31049084,31049688:31049711,31049893:31050025,31050098:31050208,31050347:31050457,31050593:31050725,31050885:31051048,31051157:31051222,31051616:31051643,31051829:31051891,31051830:31051853,31052139:31052206,31052383:31052444,31052632:31052660,31053351:31053416,31054826:31054908,31055334:31055394,31055580:31055640,31056561:31056625,31056805:31056861,31058521:31058626,31059238:31059259,31059484:31060455,31059698:31059727,31059959:31060030,31060214:31060258,31060437:31060498,31061194:31061210,31061399:31061467,31061642:31061712,31061899:31061926,31062270:31062297,31062510:31062576,31062789:31062844,31063433:31063461,31063739:31063760,31063899:31063928,31064144:31064256,31064395:31064409,31065237:31065293,31065488:31065532,31066031:31066153,31066305:31066355,31066515:31066613,31066754:31066818,31066923:31067002,31067145:31067285,31067422:31067559,31067661:3106771', 'assoc_mat': '31045058:pehd:4230:31046759,31045060:pehd:4230:31046902,31047218:pehd:4230:31047347,31047374:pehd:4230:31047462,31047561:pehd:4230:31047616,31047938:pehd:4230:31048023,31047939:pehd:4230:31047954,31048152:pehd:4230:31048180,31049041:pehd:4230:31049084,31049688:pehd:4230:31049711,31049893:pehd:4230:31050025,31050098:pehd:4230:31050208,31050347:pehd:4230:31050457,31050593:pehd:4230:31050725,31050885:pehd:4230:31051048,31051157:pehd:4230:31051222,31051616:pehd:4230:31051643,31051829:pehd:4230:31051891,31051830:pehd:4230:31051853,31052139:pehd:4230:31052206,31052383:pehd:4230:31052444,31052632:pehd:4230:31052660,31053351:pehd:4230:31053416,31054826:pehd:4230:31054908,31055334:pehd:4230:31055394,31055580:pehd:4230:31055640,31056561:pehd:4230:31056625,31056805:pehd:4230:31056861,31058521:pehd:4230:31058626,31059238:pehd:4230:31059259,31059484:pehd:4230:31060455,31059698:pehd:4230:31059727,31059959:pehd:4230:31060030,31060214:pehd:4230:31060258,31060437:pehd:4230:31060498,31061194:pehd:4230:31061210,31061399:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.019963231551467696, 'nb_photo': 9440, 'list_port_cont': '31046610,31046752,31046795,31046836,31046873,31046909,31047199,31047312,31047346,31047464,31047618,31047781,31047953,31048028,31048186,31048597,31048633,31048735,31048786,31049050,31049088,31049446,31049713,31050028,31050206,31050460,31050722,31051059,31051218,31051473,31051649,31051848,31051893,31052201,31052447,31052662,31053163,31053324,31053419,31053947,31054089,31054202,31054386,31054642,31054899,31055150,31055398,31055647,31055841,31056175,31056381,31056627,31056863,31057083,31057332,31057508,31057545,31057802,31058096,31058333,31058617,31058843,31059095,31059265,31059731,31060023,31060256,31060447,31060496,31060726,31061017,31061216,31061465,31061721,31061923,31062295,31062577,31062757,31062847,31063055,31063089,31063458,31063496,31063757,31063920,31064259,31064423,31064621,31064876,31065003,31065304,31065529,31065846,31066160,31066361,31066616,31066822,31067004,31067284,31067547,31067714,31067845,31068127,31068292,31068330,31068808,31068888,31069120,31069282,31069578,31069861,31070106,31070271,3107048', 'assoc_port': '31045057:31046610,31045058:31046752,31045059:31046795,31045060:31046909,31045061:31046873,31045062:31046836,31045266:31047199,31047218:31047346,31047219:31047312,31047374:31047464,31047561:31047618,31047762:31047781,31047938:31048028,31047939:31047953,31048152:31048186,31048582:31048633,31048583:31048597,31048720:31048735,31048779:31048786,31049041:31049088,31049042:31049050,31049405:31049446,31049688:31049713,31049893:31050028,31050098:31050206,31050347:31050460,31050593:31050722,31050885:31051059,31051157:31051218,31051365:31051473,31051616:31051649,31051829:31051893,31051830:31051848,31052139:31052201,31052383:31052447,31052632:31052662,31052879:31053324,31053088:31053163,31053351:31053419,31053598:31054202,31053844:31053947,31054019:31054089,31054312:31054386,31054568:31054642,31054826:31054899,31055086:31055150,31055334:31055398,31055580:31055647,31055820:31055841,31056058:31056175,31056319:31056381,31056561:31056627,31056805:31056863,31057012:31057083,31057262:31057332,31057476:31057508,31057477:3105754', 'assoc_mat': '31045057:pet_clair:4230:31046610,31045058:pet_clair:4230:31046752,31045059:pet_clair:4230:31046795,31045060:pet_clair:4230:31046909,31045061:pet_clair:4230:31046873,31045062:pet_clair:4230:31046836,31045266:pet_clair:4230:31047199,31047218:pet_clair:4230:31047346,31047219:pet_clair:4230:31047312,31047374:pet_clair:4230:31047464,31047561:pet_clair:4230:31047618,31047762:pet_clair:4230:31047781,31047938:pet_clair:4230:31048028,31047939:pet_clair:4230:31047953,31048152:pet_clair:4230:31048186,31048582:pet_clair:4230:31048633,31048583:pet_clair:4230:31048597,31048720:pet_clair:4230:31048735,31048779:pet_clair:4230:31048786,31049041:pet_clair:4230:31049088,31049042:pet_clair:4230:31049050,31049405:pet_clair:4230:31049446,31049688:pet_clair:4230:31049713,31049893:pet_clair:4230:31050028,31050098:pet_clair:4230:31050206,31050347:pet_clair:4230:31050460,31050593:pet_clair:4230:31050722,31050885:pet_clair:4230:31051059,31051157:pet_clair:4230:31051218,31051365:pet_clair:4230:31051473,31051616:pet_clair:4230:31051649,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021249525124067306, 'nb_photo': 257, 'list_port_cont': '31046906,31047190,31047315,31047348,31047628,31047777,31048020,31048791,31049442,31049712,31050029,31050209,31050459,31050728,31051051,31051475,31052452,31053948,31054206,31054383,31054638,31054905,31055154,31055389,31055843,31056624,31057510,31058097,31059262,31060029,31061214,31061453,31061720,31061921,31062755,31063759,31063925,31064253,31064629,31064875,31065012,31065298,31065531,31065844,31066152,31066369,31066609,31066812,31067277,31067563,31067722,31067856,31069582,31069855,31070493,31070783,31071007,31071349,31071875,31072337,31072582,31072757,31072995,31073175,31073644,31074073,31075579,31075832,31076048,31076216,31076457,31076908,31077080,31077408,31077651,31077809,31078755,31080323,31080525,31081101,31082216,31082456,31082713,31083159,31083610,31083852,31084020,31084624,31085256,31085452,31086041,31086373,31086606,31086891,31087055,31087539,31087722,31087807,31088209,31088418,31088493,31088662,31088879,31089633,31090106,31090919,31091363,31091610,31092131,31092550,31093173,31094018,31094278,3109485', 'assoc_port': '31045060:31046906,31045266:31047190,31047218:31047348,31047219:31047315,31047561:31047628,31047762:31047777,31047938:31048020,31048779:31048791,31049405:31049442,31049688:31049712,31049893:31050029,31050098:31050209,31050347:31050459,31050593:31050728,31050885:31051051,31051365:31051475,31052383:31052452,31053598:31054206,31053844:31053948,31054312:31054383,31054568:31054638,31054826:31054905,31055086:31055154,31055334:31055389,31055820:31055843,31056561:31056624,31057476:31057510,31058026:31058097,31059238:31059262,31059959:31060029,31061194:31061214,31061399:31061453,31061642:31061720,31061899:31061921,31062141:31062755,31063739:31063759,31063899:31063925,31064144:31064253,31064564:31064629,31064773:31064875,31064983:31065012,31065237:31065298,31065488:31065531,31065752:31065844,31066031:31066152,31066305:31066369,31066515:31066609,31066754:31066812,31067145:31067277,31067422:31067563,31067661:31067722,31067830:31067856,31069504:31069582,31069759:31069855,31070403:31070493,31070678:31070783,31070927:3107100', 'assoc_mat': '31045060:pet_fonce:4230:31046906,31045266:pet_fonce:4230:31047190,31047218:pet_fonce:4230:31047348,31047219:pet_fonce:4230:31047315,31047561:pet_fonce:4230:31047628,31047762:pet_fonce:4230:31047777,31047938:pet_fonce:4230:31048020,31048779:pet_fonce:4230:31048791,31049405:pet_fonce:4230:31049442,31049688:pet_fonce:4230:31049712,31049893:pet_fonce:4230:31050029,31050098:pet_fonce:4230:31050209,31050347:pet_fonce:4230:31050459,31050593:pet_fonce:4230:31050728,31050885:pet_fonce:4230:31051051,31051365:pet_fonce:4230:31051475,31052383:pet_fonce:4230:31052452,31053598:pet_fonce:4230:31054206,31053844:pet_fonce:4230:31053948,31054312:pet_fonce:4230:31054383,31054568:pet_fonce:4230:31054638,31054826:pet_fonce:4230:31054905,31055086:pet_fonce:4230:31055154,31055334:pet_fonce:4230:31055389,31055820:pet_fonce:4230:31055843,31056561:pet_fonce:4230:31056624,31057476:pet_fonce:4230:31057510,31058026:pet_fonce:4230:31058097,31059238:pet_fonce:4230:31059262,31059959:pet_fonce:4230:31060029,31061194:pet_fonce:4230:31061214,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(2987110,2987340,2987530,2987666,2987940,2988214,2988686,2989188,2989716,2990224,2990718,2991230,2991758,2992354,2993102)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048690, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046621,31046749,31046793,31046828,31046865,31046908,31047196,31047301,31047336,31047451,31047629,31047782,31047942,31048018,31048176,31048593,31048629,31048728,31048798,31049044,31049095,31049452,31049698,31050023,31050210,31050443,31050720,31051053,31051221,31051476,31051651,31051847,31051896,31052204,31052438,31052652,31053174,31053313,31053408,31053949,31054090,31054201,31054388,31054652,31054895,31055144,31055391,31055634,31055834,31056171,31056373,31056618,31056868,31057067,31057316,31057493,31057536,31057811,31058098,31058331,31058612,31058842,31059093,31059264,31059719,31060034,31060259,31060450,31060495,31060737,31061006,31061217,31061460,31061711,31061916,31062284,31062570,31062753,31062851,31063056,31063079,31063454,31063480,31063755,31063926,31064258,31064406,31064618,31064861,31065001,31065300,31065516,31065847,31066148,31066357,31066614,31066810,31066992,31067268,31067555,31067716,31067853,31068128,31068296,31068325,31068800,31068891,31069108,31069272,31069579,31069851,31070104,31070268,3107049 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048691, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046620,31046761,31046800,31046837,31046868,31046905,31047184,31047316,31047351,31047458,31047623,31047778,31047956,31048027,31048183,31048589,31048632,31048732,31048793,31049057,31049090,31049441,31049709,31050032,31050198,31050455,31050713,31051056,31051226,31051466,31051648,31051855,31051897,31052195,31052454,31052661,31053170,31053316,31053421,31053950,31054084,31054208,31054374,31054645,31054907,31055156,31055393,31055637,31055844,31056173,31056383,31056621,31056865,31057076,31057330,31057505,31057543,31057810,31058092,31058339,31058624,31058838,31059090,31059257,31059729,31060031,31060254,31060445,31060494,31060728,31061012,31061206,31061469,31061718,31061917,31062292,31062574,31062765,31062849,31063045,31063092,31063445,31063492,31063763,31063929,31064254,31064411,31064630,31064877,31065010,31065305,31065522,31065839,31066158,31066364,31066608,31066821,31067000,31067283,31067557,31067718,31067858,31068134,31068286,31068333,31068809,31068890,31069119,31069276,31069581,31069860,31070095,31070272,3107048 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048692, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046608,31046762,31046797,31046833,31046901,31047350,31047456,31047768,31048024,31048171,31048634,31049705,31050030,31050201,31050448,31051057,31051212,31051470,31051636,31052453,31052651,31053311,31053415,31054636,31055149,31055397,31055645,31056168,31056370,31056854,31057072,31057509,31060487,31061459,31061713,31061925,31062572,31062836,31063081,31063451,31063761,31063916,31064246,31064873,31064998,31065297,31065526,31065834,31066150,31066365,31066615,31066819,31066991,31067270,31067560,31067713,31068130,31068319,31068802,31069111,31069277,31069571,31069853,31070102,31070263,31070495,31070781,31070997,31071241,31071347,31071592,31071879,31072584,31072755,31072984,31073164,31073484,31073612,31073649,31074057,31074333,31074529,31074746,31074961,31075190,31075580,31075820,31076046,31076209,31076454,31076631,31076917,31077086,31077404,31077637,31078061,31078297,31078765,31079111,31079608,31079878,31080333,31080524,31080887,31081095,31081278,31081466,31081728,31082210,31082450,31082707,31083152,31083333,3108360 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048693, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046612,31046765,31046799,31046824,31046874,31046907,31047198,31047310,31047352,31047454,31047625,31047776,31047955,31048026,31048185,31048598,31048635,31048733,31048796,31049058,31049085,31049449,31049700,31050027,31050200,31050452,31050726,31051055,31051217,31051474,31051652,31051858,31051890,31052205,31052450,31052665,31053173,31053320,31053420,31053944,31054087,31054207,31054385,31054651,31054902,31055157,31055401,31055646,31055842,31056178,31056382,31056626,31056862,31057075,31057326,31057502,31057535,31057806,31058093,31058335,31058618,31058840,31059094,31059266,31059730,31060035,31060247,31060456,31060489,31060736,31061019,31061212,31061466,31061714,31061927,31062299,31062565,31062760,31062848,31063051,31063094,31063449,31063497,31063762,31063930,31064251,31064421,31064622,31064874,31065007,31065302,31065530,31065845,31066154,31066366,31066610,31066814,31067006,31067281,31067562,31067721,31067848,31068124,31068291,31068321,31068813,31068883,31069114,31069285,31069575,31069847,31070107,31070266,3107048 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048694, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046759,31046902,31047347,31047462,31047616,31047954,31048023,31048180,31049084,31049711,31050025,31050208,31050457,31050725,31051048,31051222,31051643,31051853,31051891,31052206,31052444,31052660,31053416,31054908,31055394,31055640,31056625,31056861,31058626,31059259,31059727,31060030,31060258,31060455,31060498,31061210,31061467,31061712,31061926,31062297,31062576,31062844,31063461,31063760,31063928,31064256,31064409,31065293,31065532,31066153,31066355,31066613,31066818,31067002,31067285,31067559,31067715,31068298,31068329,31068882,31069284,31069577,31069852,31070782,31071010,31071240,31071583,31072339,31072590,31072752,31072990,31073174,31073490,31073607,31073657,31074074,31074337,31074527,31074754,31074963,31075194,31075372,31075577,31075816,31076044,31076217,31076447,31076624,31077078,31077401,31077817,31078057,31078747,31079540,31079891,31080890,31081096,31081276,31081481,31081726,31081938,31082203,31082458,31082708,31082833,31083145,31083334,31083612,31083847,31083945,31084026,31084578,31084817,3108509 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048695, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046610,31046752,31046795,31046836,31046873,31046909,31047199,31047312,31047346,31047464,31047618,31047781,31047953,31048028,31048186,31048597,31048633,31048735,31048786,31049050,31049088,31049446,31049713,31050028,31050206,31050460,31050722,31051059,31051218,31051473,31051649,31051848,31051893,31052201,31052447,31052662,31053163,31053324,31053419,31053947,31054089,31054202,31054386,31054642,31054899,31055150,31055398,31055647,31055841,31056175,31056381,31056627,31056863,31057083,31057332,31057508,31057545,31057802,31058096,31058333,31058617,31058843,31059095,31059265,31059731,31060023,31060256,31060447,31060496,31060726,31061017,31061216,31061465,31061721,31061923,31062295,31062577,31062757,31062847,31063055,31063089,31063458,31063496,31063757,31063920,31064259,31064423,31064621,31064876,31065003,31065304,31065529,31065846,31066160,31066361,31066616,31066822,31067004,31067284,31067547,31067714,31067845,31068127,31068292,31068330,31068808,31068888,31069120,31069282,31069578,31069861,31070106,31070271,3107048 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31048696, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31046906,31047190,31047315,31047348,31047628,31047777,31048020,31048791,31049442,31049712,31050029,31050209,31050459,31050728,31051051,31051475,31052452,31053948,31054206,31054383,31054638,31054905,31055154,31055389,31055843,31056624,31057510,31058097,31059262,31060029,31061214,31061453,31061720,31061921,31062755,31063759,31063925,31064253,31064629,31064875,31065012,31065298,31065531,31065844,31066152,31066369,31066609,31066812,31067277,31067563,31067722,31067856,31069582,31069855,31070493,31070783,31071007,31071349,31071875,31072337,31072582,31072757,31072995,31073175,31073644,31074073,31075579,31075832,31076048,31076216,31076457,31076908,31077080,31077408,31077651,31077809,31078755,31080323,31080525,31081101,31082216,31082456,31082713,31083159,31083610,31083852,31084020,31084624,31085256,31085452,31086041,31086373,31086606,31086891,31087055,31087539,31087722,31087807,31088209,31088418,31088493,31088662,31088879,31089633,31090106,31090919,31091363,31091610,31092131,31092550,31093173,31094018,31094278,3109485 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31048690,31048691,31048692,31048693,31048694,31048695,31048696?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2026-08-01' and date <= '2026-08-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((706,),), 'unwanted_material_monthly_percentage': ((0.786783804034288,),), 'material_repartition': (('incineration', 706),), 'material_dict': {'incineration': 706}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 8, 14), 0.8172577538908338, 2), (datetime.date(2026, 8, 15), 0.8072805604704503, 3), (datetime.date(2026, 8, 16), 0.797755360865052, 1), (datetime.date(2026, 8, 17), 0.8150300570022155, 1), (datetime.date(2026, 8, 21), 0.73241518355875, 1), (datetime.date(2026, 8, 22), 0.7575470366838193, 1), (datetime.date(2026, 8, 23), 0.8141625521350961, 4), (datetime.date(2026, 8, 24), 0.830877547959782, 3), (datetime.date(2026, 8, 25), 0.7927731560561426, 1), (datetime.date(2026, 8, 26), 0.7657419338933033, 3), (datetime.date(2026, 8, 27), 0.7603594851161498, 4), (datetime.date(2026, 8, 28), 0.7721759369646576, 3), (datetime.date(2026, 8, 29), 0.7088070692150604, 3), (datetime.date(2026, 8, 30), 0.8042694813777334, 1), (datetime.date(2026, 8, 31), 0.8366558342225808, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 8, 14), 0.8172577538908338, 2), (datetime.date(2026, 8, 15), 0.8072805604704503, 3), (datetime.date(2026, 8, 16), 0.797755360865052, 1), (datetime.date(2026, 8, 17), 0.8150300570022155, 1), (datetime.date(2026, 8, 21), 0.73241518355875, 1), (datetime.date(2026, 8, 22), 0.7575470366838193, 1), (datetime.date(2026, 8, 23), 0.8141625521350961, 4), (datetime.date(2026, 8, 24), 0.830877547959782, 3), (datetime.date(2026, 8, 25), 0.7927731560561426, 1), (datetime.date(2026, 8, 26), 0.7657419338933033, 3), (datetime.date(2026, 8, 27), 0.7603594851161498, 4), (datetime.date(2026, 8, 28), 0.7721759369646576, 3), (datetime.date(2026, 8, 29), 0.7088070692150604, 3), (datetime.date(2026, 8, 30), 0.8042694813777334, 1), (datetime.date(2026, 8, 31), 0.8366558342225808, 4))}, 'quality_array': [['-7.280194676923888', '14082026'], ['-7.609509422738808', '15082026'], ['-7.351209343890349', '16082026'], ['-7.14033936196261', '17082026'], ['-7.9657122777691445', '21082026'], ['-7.308050432063004', '22082026'], ['-7.134222103179468', '23082026'], ['-6.801918767537304', '24082026'], ['-6.675143814005521', '25082026'], ['-7.153723695527532', '26082026'], ['-7.252233242913919', '27082026'], ['-7.4631117996647145', '28082026'], ['-7.396634579822316', '29082026'], ['-7.338315974311606', '30082026'], ['-7.205620804245861', '31082026']], 'number_of_batch': ((246,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01383059353906557, 'nb_photo': 6504, 'list_port_cont': '31046621,31046749,31046793,31046828,31046865,31046908,31047196,31047301,31047336,31047451,31047629,31047782,31047942,31048018,31048176,31048593,31048629,31048728,31048798,31049044,31049095,31049452,31049698,31050023,31050210,31050443,31050720,31051053,31051221,31051476,31051651,31051847,31051896,31052204,31052438,31052652,31053174,31053313,31053408,31053949,31054090,31054201,31054388,31054652,31054895,31055144,31055391,31055634,31055834,31056171,31056373,31056618,31056868,31057067,31057316,31057493,31057536,31057811,31058098,31058331,31058612,31058842,31059093,31059264,31059719,31060034,31060259,31060450,31060495,31060737,31061006,31061217,31061460,31061711,31061916,31062284,31062570,31062753,31062851,31063056,31063079,31063454,31063480,31063755,31063926,31064258,31064406,31064618,31064861,31065001,31065300,31065516,31065847,31066148,31066357,31066614,31066810,31066992,31067268,31067555,31067716,31067853,31068128,31068296,31068325,31068800,31068891,31069108,31069272,31069579,31069851,31070104,31070268,3107049', 'assoc_port': '31045057:31046621,31045058:31046749,31045059:31046793,31045060:31046908,31045061:31046865,31045062:31046828,31045266:31047196,31047218:31047336,31047219:31047301,31047374:31047451,31047561:31047629,31047762:31047782,31047938:31048018,31047939:31047942,31048152:31048176,31048582:31048629,31048583:31048593,31048720:31048728,31048779:31048798,31049041:31049095,31049042:31049044,31049405:31049452,31049688:31049698,31049893:31050023,31050098:31050210,31050347:31050443,31050593:31050720,31050885:31051053,31051157:31051221,31051365:31051476,31051616:31051651,31051829:31051896,31051830:31051847,31052139:31052204,31052383:31052438,31052632:31052652,31052879:31053313,31053088:31053174,31053351:31053408,31053598:31054201,31053844:31053949,31054019:31054090,31054312:31054388,31054568:31054652,31054826:31054895,31055086:31055144,31055334:31055391,31055580:31055634,31055820:31055834,31056058:31056171,31056319:31056373,31056561:31056618,31056805:31056868,31057012:31057067,31057262:31057316,31057476:31057493,31057477:3105753', 'assoc_mat': '31045057:autre:4230:31046621,31045058:autre:4230:31046749,31045059:autre:4230:31046793,31045060:autre:4230:31046908,31045061:autre:4230:31046865,31045062:autre:4230:31046828,31045266:autre:4230:31047196,31047218:autre:4230:31047336,31047219:autre:4230:31047301,31047374:autre:4230:31047451,31047561:autre:4230:31047629,31047762:autre:4230:31047782,31047938:autre:4230:31048018,31047939:autre:4230:31047942,31048152:autre:4230:31048176,31048582:autre:4230:31048629,31048583:autre:4230:31048593,31048720:autre:4230:31048728,31048779:autre:4230:31048798,31049041:autre:4230:31049095,31049042:autre:4230:31049044,31049405:autre:4230:31049452,31049688:autre:4230:31049698,31049893:autre:4230:31050023,31050098:autre:4230:31050210,31050347:autre:4230:31050443,31050593:autre:4230:31050720,31050885:autre:4230:31051053,31051157:autre:4230:31051221,31051365:autre:4230:31051476,31051616:autre:4230:31051651,31051829:autre:4230:31051896,31051830:autre:4230:31051847,31052139:autre:4230:31052204,31052383:autre:4230:31052438,31052632:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02865100388724626, 'nb_photo': 20108, 'list_port_cont': '31046620,31046761,31046800,31046837,31046868,31046905,31047184,31047316,31047351,31047458,31047623,31047778,31047956,31048027,31048183,31048589,31048632,31048732,31048793,31049057,31049090,31049441,31049709,31050032,31050198,31050455,31050713,31051056,31051226,31051466,31051648,31051855,31051897,31052195,31052454,31052661,31053170,31053316,31053421,31053950,31054084,31054208,31054374,31054645,31054907,31055156,31055393,31055637,31055844,31056173,31056383,31056621,31056865,31057076,31057330,31057505,31057543,31057810,31058092,31058339,31058624,31058838,31059090,31059257,31059729,31060031,31060254,31060445,31060494,31060728,31061012,31061206,31061469,31061718,31061917,31062292,31062574,31062765,31062849,31063045,31063092,31063445,31063492,31063763,31063929,31064254,31064411,31064630,31064877,31065010,31065305,31065522,31065839,31066158,31066364,31066608,31066821,31067000,31067283,31067557,31067718,31067858,31068134,31068286,31068333,31068809,31068890,31069119,31069276,31069581,31069860,31070095,31070272,3107048', 'assoc_port': '31045057:31046620,31045058:31046761,31045059:31046800,31045060:31046905,31045061:31046868,31045062:31046837,31045266:31047184,31047218:31047351,31047219:31047316,31047374:31047458,31047561:31047623,31047762:31047778,31047938:31048027,31047939:31047956,31048152:31048183,31048582:31048632,31048583:31048589,31048720:31048732,31048779:31048793,31049041:31049090,31049042:31049057,31049405:31049441,31049688:31049709,31049893:31050032,31050098:31050198,31050347:31050455,31050593:31050713,31050885:31051056,31051157:31051226,31051365:31051466,31051616:31051648,31051829:31051897,31051830:31051855,31052139:31052195,31052383:31052454,31052632:31052661,31052879:31053316,31053088:31053170,31053351:31053421,31053598:31054208,31053844:31053950,31054019:31054084,31054312:31054374,31054568:31054645,31054826:31054907,31055086:31055156,31055334:31055393,31055580:31055637,31055820:31055844,31056058:31056173,31056319:31056383,31056561:31056621,31056805:31056865,31057012:31057076,31057262:31057330,31057476:31057505,31057477:3105754', 'assoc_mat': '31045057:carton:4230:31046620,31045058:carton:4230:31046761,31045059:carton:4230:31046800,31045060:carton:4230:31046905,31045061:carton:4230:31046868,31045062:carton:4230:31046837,31045266:carton:4230:31047184,31047218:carton:4230:31047351,31047219:carton:4230:31047316,31047374:carton:4230:31047458,31047561:carton:4230:31047623,31047762:carton:4230:31047778,31047938:carton:4230:31048027,31047939:carton:4230:31047956,31048152:carton:4230:31048183,31048582:carton:4230:31048632,31048583:carton:4230:31048589,31048720:carton:4230:31048732,31048779:carton:4230:31048793,31049041:carton:4230:31049090,31049042:carton:4230:31049057,31049405:carton:4230:31049441,31049688:carton:4230:31049709,31049893:carton:4230:31050032,31050098:carton:4230:31050198,31050347:carton:4230:31050455,31050593:carton:4230:31050713,31050885:carton:4230:31051056,31051157:carton:4230:31051226,31051365:carton:4230:31051466,31051616:carton:4230:31051648,31051829:carton:4230:31051897,31051830:carton:4230:31051855,31052139:carton:4230:31052195,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008604005016482317, 'nb_photo': 413, 'list_port_cont': '31046608,31046762,31046797,31046833,31046901,31047350,31047456,31047768,31048024,31048171,31048634,31049705,31050030,31050201,31050448,31051057,31051212,31051470,31051636,31052453,31052651,31053311,31053415,31054636,31055149,31055397,31055645,31056168,31056370,31056854,31057072,31057509,31060487,31061459,31061713,31061925,31062572,31062836,31063081,31063451,31063761,31063916,31064246,31064873,31064998,31065297,31065526,31065834,31066150,31066365,31066615,31066819,31066991,31067270,31067560,31067713,31068130,31068319,31068802,31069111,31069277,31069571,31069853,31070102,31070263,31070495,31070781,31070997,31071241,31071347,31071592,31071879,31072584,31072755,31072984,31073164,31073484,31073612,31073649,31074057,31074333,31074529,31074746,31074961,31075190,31075580,31075820,31076046,31076209,31076454,31076631,31076917,31077086,31077404,31077637,31078061,31078297,31078765,31079111,31079608,31079878,31080333,31080524,31080887,31081095,31081278,31081466,31081728,31082210,31082450,31082707,31083152,31083333,3108360', 'assoc_port': '31045057:31046608,31045058:31046762,31045059:31046797,31045060:31046901,31045062:31046833,31047218:31047350,31047374:31047456,31047762:31047768,31047938:31048024,31048152:31048171,31048582:31048634,31049688:31049705,31049893:31050030,31050098:31050201,31050347:31050448,31050885:31051057,31051157:31051212,31051365:31051470,31051616:31051636,31052383:31052453,31052632:31052651,31052879:31053311,31053351:31053415,31054568:31054636,31055086:31055149,31055334:31055397,31055580:31055645,31056058:31056168,31056319:31056370,31056805:31056854,31057012:31057072,31057476:31057509,31060437:31060487,31061399:31061459,31061642:31061713,31061899:31061925,31062510:31062572,31062789:31062836,31063031:31063081,31063433:31063451,31063739:31063761,31063899:31063916,31064144:31064246,31064773:31064873,31064983:31064998,31065237:31065297,31065488:31065526,31065752:31065834,31066031:31066150,31066305:31066365,31066515:31066615,31066754:31066819,31066923:31066991,31067145:31067270,31067422:31067560,31067661:31067713,31068071:3106813', 'assoc_mat': '31045057:metal:4230:31046608,31045058:metal:4230:31046762,31045059:metal:4230:31046797,31045060:metal:4230:31046901,31045062:metal:4230:31046833,31047218:metal:4230:31047350,31047374:metal:4230:31047456,31047762:metal:4230:31047768,31047938:metal:4230:31048024,31048152:metal:4230:31048171,31048582:metal:4230:31048634,31049688:metal:4230:31049705,31049893:metal:4230:31050030,31050098:metal:4230:31050201,31050347:metal:4230:31050448,31050885:metal:4230:31051057,31051157:metal:4230:31051212,31051365:metal:4230:31051470,31051616:metal:4230:31051636,31052383:metal:4230:31052453,31052632:metal:4230:31052651,31052879:metal:4230:31053311,31053351:metal:4230:31053415,31054568:metal:4230:31054636,31055086:metal:4230:31055149,31055334:metal:4230:31055397,31055580:metal:4230:31055645,31056058:metal:4230:31056168,31056319:metal:4230:31056370,31056805:metal:4230:31056854,31057012:metal:4230:31057072,31057476:metal:4230:31057509,31060437:metal:4230:31060487,31061399:metal:4230:31061459,31061642:metal:4230:31061713,31061899:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16700071442774592, 'nb_photo': 118958, 'list_port_cont': '31046612,31046765,31046799,31046824,31046874,31046907,31047198,31047310,31047352,31047454,31047625,31047776,31047955,31048026,31048185,31048598,31048635,31048733,31048796,31049058,31049085,31049449,31049700,31050027,31050200,31050452,31050726,31051055,31051217,31051474,31051652,31051858,31051890,31052205,31052450,31052665,31053173,31053320,31053420,31053944,31054087,31054207,31054385,31054651,31054902,31055157,31055401,31055646,31055842,31056178,31056382,31056626,31056862,31057075,31057326,31057502,31057535,31057806,31058093,31058335,31058618,31058840,31059094,31059266,31059730,31060035,31060247,31060456,31060489,31060736,31061019,31061212,31061466,31061714,31061927,31062299,31062565,31062760,31062848,31063051,31063094,31063449,31063497,31063762,31063930,31064251,31064421,31064622,31064874,31065007,31065302,31065530,31065845,31066154,31066366,31066610,31066814,31067006,31067281,31067562,31067721,31067848,31068124,31068291,31068321,31068813,31068883,31069114,31069285,31069575,31069847,31070107,31070266,3107048', 'assoc_port': '31045057:31046612,31045058:31046765,31045059:31046799,31045060:31046907,31045061:31046874,31045062:31046824,31045266:31047198,31047218:31047352,31047219:31047310,31047374:31047454,31047561:31047625,31047762:31047776,31047938:31048026,31047939:31047955,31048152:31048185,31048582:31048635,31048583:31048598,31048720:31048733,31048779:31048796,31049041:31049085,31049042:31049058,31049405:31049449,31049688:31049700,31049893:31050027,31050098:31050200,31050347:31050452,31050593:31050726,31050885:31051055,31051157:31051217,31051365:31051474,31051616:31051652,31051829:31051890,31051830:31051858,31052139:31052205,31052383:31052450,31052632:31052665,31052879:31053320,31053088:31053173,31053351:31053420,31053598:31054207,31053844:31053944,31054019:31054087,31054312:31054385,31054568:31054651,31054826:31054902,31055086:31055157,31055334:31055401,31055580:31055646,31055820:31055842,31056058:31056178,31056319:31056382,31056561:31056626,31056805:31056862,31057012:31057075,31057262:31057326,31057476:31057502,31057477:3105753', 'assoc_mat': '31045057:papier:4230:31046612,31045058:papier:4230:31046765,31045059:papier:4230:31046799,31045060:papier:4230:31046907,31045061:papier:4230:31046874,31045062:papier:4230:31046824,31045266:papier:4230:31047198,31047218:papier:4230:31047352,31047219:papier:4230:31047310,31047374:papier:4230:31047454,31047561:papier:4230:31047625,31047762:papier:4230:31047776,31047938:papier:4230:31048026,31047939:papier:4230:31047955,31048152:papier:4230:31048185,31048582:papier:4230:31048635,31048583:papier:4230:31048598,31048720:papier:4230:31048733,31048779:papier:4230:31048796,31049041:papier:4230:31049085,31049042:papier:4230:31049058,31049405:papier:4230:31049449,31049688:papier:4230:31049700,31049893:papier:4230:31050027,31050098:papier:4230:31050200,31050347:papier:4230:31050452,31050593:papier:4230:31050726,31050885:papier:4230:31051055,31051157:papier:4230:31051217,31051365:papier:4230:31051474,31051616:papier:4230:31051652,31051829:papier:4230:31051890,31051830:papier:4230:31051858,31052139:papier:4230:31052205,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0025050445267051, 'nb_photo': 479, 'list_port_cont': '31046759,31046902,31047347,31047462,31047616,31047954,31048023,31048180,31049084,31049711,31050025,31050208,31050457,31050725,31051048,31051222,31051643,31051853,31051891,31052206,31052444,31052660,31053416,31054908,31055394,31055640,31056625,31056861,31058626,31059259,31059727,31060030,31060258,31060455,31060498,31061210,31061467,31061712,31061926,31062297,31062576,31062844,31063461,31063760,31063928,31064256,31064409,31065293,31065532,31066153,31066355,31066613,31066818,31067002,31067285,31067559,31067715,31068298,31068329,31068882,31069284,31069577,31069852,31070782,31071010,31071240,31071583,31072339,31072590,31072752,31072990,31073174,31073490,31073607,31073657,31074074,31074337,31074527,31074754,31074963,31075194,31075372,31075577,31075816,31076044,31076217,31076447,31076624,31077078,31077401,31077817,31078057,31078747,31079540,31079891,31080890,31081096,31081276,31081481,31081726,31081938,31082203,31082458,31082708,31082833,31083145,31083334,31083612,31083847,31083945,31084026,31084578,31084817,3108509', 'assoc_port': '31045058:31046759,31045060:31046902,31047218:31047347,31047374:31047462,31047561:31047616,31047938:31048023,31047939:31047954,31048152:31048180,31049041:31049084,31049688:31049711,31049893:31050025,31050098:31050208,31050347:31050457,31050593:31050725,31050885:31051048,31051157:31051222,31051616:31051643,31051829:31051891,31051830:31051853,31052139:31052206,31052383:31052444,31052632:31052660,31053351:31053416,31054826:31054908,31055334:31055394,31055580:31055640,31056561:31056625,31056805:31056861,31058521:31058626,31059238:31059259,31059484:31060455,31059698:31059727,31059959:31060030,31060214:31060258,31060437:31060498,31061194:31061210,31061399:31061467,31061642:31061712,31061899:31061926,31062270:31062297,31062510:31062576,31062789:31062844,31063433:31063461,31063739:31063760,31063899:31063928,31064144:31064256,31064395:31064409,31065237:31065293,31065488:31065532,31066031:31066153,31066305:31066355,31066515:31066613,31066754:31066818,31066923:31067002,31067145:31067285,31067422:31067559,31067661:3106771', 'assoc_mat': '31045058:pehd:4230:31046759,31045060:pehd:4230:31046902,31047218:pehd:4230:31047347,31047374:pehd:4230:31047462,31047561:pehd:4230:31047616,31047938:pehd:4230:31048023,31047939:pehd:4230:31047954,31048152:pehd:4230:31048180,31049041:pehd:4230:31049084,31049688:pehd:4230:31049711,31049893:pehd:4230:31050025,31050098:pehd:4230:31050208,31050347:pehd:4230:31050457,31050593:pehd:4230:31050725,31050885:pehd:4230:31051048,31051157:pehd:4230:31051222,31051616:pehd:4230:31051643,31051829:pehd:4230:31051891,31051830:pehd:4230:31051853,31052139:pehd:4230:31052206,31052383:pehd:4230:31052444,31052632:pehd:4230:31052660,31053351:pehd:4230:31053416,31054826:pehd:4230:31054908,31055334:pehd:4230:31055394,31055580:pehd:4230:31055640,31056561:pehd:4230:31056625,31056805:pehd:4230:31056861,31058521:pehd:4230:31058626,31059238:pehd:4230:31059259,31059484:pehd:4230:31060455,31059698:pehd:4230:31059727,31059959:pehd:4230:31060030,31060214:pehd:4230:31060258,31060437:pehd:4230:31060498,31061194:pehd:4230:31061210,31061399:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.019963231551467696, 'nb_photo': 9440, 'list_port_cont': '31046610,31046752,31046795,31046836,31046873,31046909,31047199,31047312,31047346,31047464,31047618,31047781,31047953,31048028,31048186,31048597,31048633,31048735,31048786,31049050,31049088,31049446,31049713,31050028,31050206,31050460,31050722,31051059,31051218,31051473,31051649,31051848,31051893,31052201,31052447,31052662,31053163,31053324,31053419,31053947,31054089,31054202,31054386,31054642,31054899,31055150,31055398,31055647,31055841,31056175,31056381,31056627,31056863,31057083,31057332,31057508,31057545,31057802,31058096,31058333,31058617,31058843,31059095,31059265,31059731,31060023,31060256,31060447,31060496,31060726,31061017,31061216,31061465,31061721,31061923,31062295,31062577,31062757,31062847,31063055,31063089,31063458,31063496,31063757,31063920,31064259,31064423,31064621,31064876,31065003,31065304,31065529,31065846,31066160,31066361,31066616,31066822,31067004,31067284,31067547,31067714,31067845,31068127,31068292,31068330,31068808,31068888,31069120,31069282,31069578,31069861,31070106,31070271,3107048', 'assoc_port': '31045057:31046610,31045058:31046752,31045059:31046795,31045060:31046909,31045061:31046873,31045062:31046836,31045266:31047199,31047218:31047346,31047219:31047312,31047374:31047464,31047561:31047618,31047762:31047781,31047938:31048028,31047939:31047953,31048152:31048186,31048582:31048633,31048583:31048597,31048720:31048735,31048779:31048786,31049041:31049088,31049042:31049050,31049405:31049446,31049688:31049713,31049893:31050028,31050098:31050206,31050347:31050460,31050593:31050722,31050885:31051059,31051157:31051218,31051365:31051473,31051616:31051649,31051829:31051893,31051830:31051848,31052139:31052201,31052383:31052447,31052632:31052662,31052879:31053324,31053088:31053163,31053351:31053419,31053598:31054202,31053844:31053947,31054019:31054089,31054312:31054386,31054568:31054642,31054826:31054899,31055086:31055150,31055334:31055398,31055580:31055647,31055820:31055841,31056058:31056175,31056319:31056381,31056561:31056627,31056805:31056863,31057012:31057083,31057262:31057332,31057476:31057508,31057477:3105754', 'assoc_mat': '31045057:pet_clair:4230:31046610,31045058:pet_clair:4230:31046752,31045059:pet_clair:4230:31046795,31045060:pet_clair:4230:31046909,31045061:pet_clair:4230:31046873,31045062:pet_clair:4230:31046836,31045266:pet_clair:4230:31047199,31047218:pet_clair:4230:31047346,31047219:pet_clair:4230:31047312,31047374:pet_clair:4230:31047464,31047561:pet_clair:4230:31047618,31047762:pet_clair:4230:31047781,31047938:pet_clair:4230:31048028,31047939:pet_clair:4230:31047953,31048152:pet_clair:4230:31048186,31048582:pet_clair:4230:31048633,31048583:pet_clair:4230:31048597,31048720:pet_clair:4230:31048735,31048779:pet_clair:4230:31048786,31049041:pet_clair:4230:31049088,31049042:pet_clair:4230:31049050,31049405:pet_clair:4230:31049446,31049688:pet_clair:4230:31049713,31049893:pet_clair:4230:31050028,31050098:pet_clair:4230:31050206,31050347:pet_clair:4230:31050460,31050593:pet_clair:4230:31050722,31050885:pet_clair:4230:31051059,31051157:pet_clair:4230:31051218,31051365:pet_clair:4230:31051473,31051616:pet_clair:4230:31051649,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021249525124067306, 'nb_photo': 257, 'list_port_cont': '31046906,31047190,31047315,31047348,31047628,31047777,31048020,31048791,31049442,31049712,31050029,31050209,31050459,31050728,31051051,31051475,31052452,31053948,31054206,31054383,31054638,31054905,31055154,31055389,31055843,31056624,31057510,31058097,31059262,31060029,31061214,31061453,31061720,31061921,31062755,31063759,31063925,31064253,31064629,31064875,31065012,31065298,31065531,31065844,31066152,31066369,31066609,31066812,31067277,31067563,31067722,31067856,31069582,31069855,31070493,31070783,31071007,31071349,31071875,31072337,31072582,31072757,31072995,31073175,31073644,31074073,31075579,31075832,31076048,31076216,31076457,31076908,31077080,31077408,31077651,31077809,31078755,31080323,31080525,31081101,31082216,31082456,31082713,31083159,31083610,31083852,31084020,31084624,31085256,31085452,31086041,31086373,31086606,31086891,31087055,31087539,31087722,31087807,31088209,31088418,31088493,31088662,31088879,31089633,31090106,31090919,31091363,31091610,31092131,31092550,31093173,31094018,31094278,3109485', 'assoc_port': '31045060:31046906,31045266:31047190,31047218:31047348,31047219:31047315,31047561:31047628,31047762:31047777,31047938:31048020,31048779:31048791,31049405:31049442,31049688:31049712,31049893:31050029,31050098:31050209,31050347:31050459,31050593:31050728,31050885:31051051,31051365:31051475,31052383:31052452,31053598:31054206,31053844:31053948,31054312:31054383,31054568:31054638,31054826:31054905,31055086:31055154,31055334:31055389,31055820:31055843,31056561:31056624,31057476:31057510,31058026:31058097,31059238:31059262,31059959:31060029,31061194:31061214,31061399:31061453,31061642:31061720,31061899:31061921,31062141:31062755,31063739:31063759,31063899:31063925,31064144:31064253,31064564:31064629,31064773:31064875,31064983:31065012,31065237:31065298,31065488:31065531,31065752:31065844,31066031:31066152,31066305:31066369,31066515:31066609,31066754:31066812,31067145:31067277,31067422:31067563,31067661:31067722,31067830:31067856,31069504:31069582,31069759:31069855,31070403:31070493,31070678:31070783,31070927:3107100', 'assoc_mat': '31045060:pet_fonce:4230:31046906,31045266:pet_fonce:4230:31047190,31047218:pet_fonce:4230:31047348,31047219:pet_fonce:4230:31047315,31047561:pet_fonce:4230:31047628,31047762:pet_fonce:4230:31047777,31047938:pet_fonce:4230:31048020,31048779:pet_fonce:4230:31048791,31049405:pet_fonce:4230:31049442,31049688:pet_fonce:4230:31049712,31049893:pet_fonce:4230:31050029,31050098:pet_fonce:4230:31050209,31050347:pet_fonce:4230:31050459,31050593:pet_fonce:4230:31050728,31050885:pet_fonce:4230:31051051,31051365:pet_fonce:4230:31051475,31052383:pet_fonce:4230:31052452,31053598:pet_fonce:4230:31054206,31053844:pet_fonce:4230:31053948,31054312:pet_fonce:4230:31054383,31054568:pet_fonce:4230:31054638,31054826:pet_fonce:4230:31054905,31055086:pet_fonce:4230:31055154,31055334:pet_fonce:4230:31055389,31055820:pet_fonce:4230:31055843,31056561:pet_fonce:4230:31056624,31057476:pet_fonce:4230:31057510,31058026:pet_fonce:4230:31058097,31059238:pet_fonce:4230:31059262,31059959:pet_fonce:4230:31060029,31061194:pet_fonce:4230:31061214,3'}), 'main_stat': {'nb_photos': 706}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31048690,31048691,31048692,31048693,31048694,31048695,31048696?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-08', 0.786783804034288),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((706,),), 'unwanted_material_monthly_percentage': ((0.786783804034288,),), 'material_repartition': (('incineration', 706),), 'material_dict': {'incineration': 706}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 8, 14), 0.8172577538908338, 2), (datetime.date(2026, 8, 15), 0.8072805604704503, 3), (datetime.date(2026, 8, 16), 0.797755360865052, 1), (datetime.date(2026, 8, 17), 0.8150300570022155, 1), (datetime.date(2026, 8, 21), 0.73241518355875, 1), (datetime.date(2026, 8, 22), 0.7575470366838193, 1), (datetime.date(2026, 8, 23), 0.8141625521350961, 4), (datetime.date(2026, 8, 24), 0.830877547959782, 3), (datetime.date(2026, 8, 25), 0.7927731560561426, 1), (datetime.date(2026, 8, 26), 0.7657419338933033, 3), (datetime.date(2026, 8, 27), 0.7603594851161498, 4), (datetime.date(2026, 8, 28), 0.7721759369646576, 3), (datetime.date(2026, 8, 29), 0.7088070692150604, 3), (datetime.date(2026, 8, 30), 0.8042694813777334, 1), (datetime.date(2026, 8, 31), 0.8366558342225808, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 8, 14), 0.8172577538908338, 2), (datetime.date(2026, 8, 15), 0.8072805604704503, 3), (datetime.date(2026, 8, 16), 0.797755360865052, 1), (datetime.date(2026, 8, 17), 0.8150300570022155, 1), (datetime.date(2026, 8, 21), 0.73241518355875, 1), (datetime.date(2026, 8, 22), 0.7575470366838193, 1), (datetime.date(2026, 8, 23), 0.8141625521350961, 4), (datetime.date(2026, 8, 24), 0.830877547959782, 3), (datetime.date(2026, 8, 25), 0.7927731560561426, 1), (datetime.date(2026, 8, 26), 0.7657419338933033, 3), (datetime.date(2026, 8, 27), 0.7603594851161498, 4), (datetime.date(2026, 8, 28), 0.7721759369646576, 3), (datetime.date(2026, 8, 29), 0.7088070692150604, 3), (datetime.date(2026, 8, 30), 0.8042694813777334, 1), (datetime.date(2026, 8, 31), 0.8366558342225808, 4))}, 'quality_array': [['-7.280194676923888', '14082026'], ['-7.609509422738808', '15082026'], ['-7.351209343890349', '16082026'], ['-7.14033936196261', '17082026'], ['-7.9657122777691445', '21082026'], ['-7.308050432063004', '22082026'], ['-7.134222103179468', '23082026'], ['-6.801918767537304', '24082026'], ['-6.675143814005521', '25082026'], ['-7.153723695527532', '26082026'], ['-7.252233242913919', '27082026'], ['-7.4631117996647145', '28082026'], ['-7.396634579822316', '29082026'], ['-7.338315974311606', '30082026'], ['-7.205620804245861', '31082026']], 'number_of_batch': ((246,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01383059353906557, 'nb_photo': 6504, 'list_port_cont': '31046621,31046749,31046793,31046828,31046865,31046908,31047196,31047301,31047336,31047451,31047629,31047782,31047942,31048018,31048176,31048593,31048629,31048728,31048798,31049044,31049095,31049452,31049698,31050023,31050210,31050443,31050720,31051053,31051221,31051476,31051651,31051847,31051896,31052204,31052438,31052652,31053174,31053313,31053408,31053949,31054090,31054201,31054388,31054652,31054895,31055144,31055391,31055634,31055834,31056171,31056373,31056618,31056868,31057067,31057316,31057493,31057536,31057811,31058098,31058331,31058612,31058842,31059093,31059264,31059719,31060034,31060259,31060450,31060495,31060737,31061006,31061217,31061460,31061711,31061916,31062284,31062570,31062753,31062851,31063056,31063079,31063454,31063480,31063755,31063926,31064258,31064406,31064618,31064861,31065001,31065300,31065516,31065847,31066148,31066357,31066614,31066810,31066992,31067268,31067555,31067716,31067853,31068128,31068296,31068325,31068800,31068891,31069108,31069272,31069579,31069851,31070104,31070268,3107049', 'assoc_port': '31045057:31046621,31045058:31046749,31045059:31046793,31045060:31046908,31045061:31046865,31045062:31046828,31045266:31047196,31047218:31047336,31047219:31047301,31047374:31047451,31047561:31047629,31047762:31047782,31047938:31048018,31047939:31047942,31048152:31048176,31048582:31048629,31048583:31048593,31048720:31048728,31048779:31048798,31049041:31049095,31049042:31049044,31049405:31049452,31049688:31049698,31049893:31050023,31050098:31050210,31050347:31050443,31050593:31050720,31050885:31051053,31051157:31051221,31051365:31051476,31051616:31051651,31051829:31051896,31051830:31051847,31052139:31052204,31052383:31052438,31052632:31052652,31052879:31053313,31053088:31053174,31053351:31053408,31053598:31054201,31053844:31053949,31054019:31054090,31054312:31054388,31054568:31054652,31054826:31054895,31055086:31055144,31055334:31055391,31055580:31055634,31055820:31055834,31056058:31056171,31056319:31056373,31056561:31056618,31056805:31056868,31057012:31057067,31057262:31057316,31057476:31057493,31057477:3105753', 'assoc_mat': '31045057:autre:4230:31046621,31045058:autre:4230:31046749,31045059:autre:4230:31046793,31045060:autre:4230:31046908,31045061:autre:4230:31046865,31045062:autre:4230:31046828,31045266:autre:4230:31047196,31047218:autre:4230:31047336,31047219:autre:4230:31047301,31047374:autre:4230:31047451,31047561:autre:4230:31047629,31047762:autre:4230:31047782,31047938:autre:4230:31048018,31047939:autre:4230:31047942,31048152:autre:4230:31048176,31048582:autre:4230:31048629,31048583:autre:4230:31048593,31048720:autre:4230:31048728,31048779:autre:4230:31048798,31049041:autre:4230:31049095,31049042:autre:4230:31049044,31049405:autre:4230:31049452,31049688:autre:4230:31049698,31049893:autre:4230:31050023,31050098:autre:4230:31050210,31050347:autre:4230:31050443,31050593:autre:4230:31050720,31050885:autre:4230:31051053,31051157:autre:4230:31051221,31051365:autre:4230:31051476,31051616:autre:4230:31051651,31051829:autre:4230:31051896,31051830:autre:4230:31051847,31052139:autre:4230:31052204,31052383:autre:4230:31052438,31052632:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02865100388724626, 'nb_photo': 20108, 'list_port_cont': '31046620,31046761,31046800,31046837,31046868,31046905,31047184,31047316,31047351,31047458,31047623,31047778,31047956,31048027,31048183,31048589,31048632,31048732,31048793,31049057,31049090,31049441,31049709,31050032,31050198,31050455,31050713,31051056,31051226,31051466,31051648,31051855,31051897,31052195,31052454,31052661,31053170,31053316,31053421,31053950,31054084,31054208,31054374,31054645,31054907,31055156,31055393,31055637,31055844,31056173,31056383,31056621,31056865,31057076,31057330,31057505,31057543,31057810,31058092,31058339,31058624,31058838,31059090,31059257,31059729,31060031,31060254,31060445,31060494,31060728,31061012,31061206,31061469,31061718,31061917,31062292,31062574,31062765,31062849,31063045,31063092,31063445,31063492,31063763,31063929,31064254,31064411,31064630,31064877,31065010,31065305,31065522,31065839,31066158,31066364,31066608,31066821,31067000,31067283,31067557,31067718,31067858,31068134,31068286,31068333,31068809,31068890,31069119,31069276,31069581,31069860,31070095,31070272,3107048', 'assoc_port': '31045057:31046620,31045058:31046761,31045059:31046800,31045060:31046905,31045061:31046868,31045062:31046837,31045266:31047184,31047218:31047351,31047219:31047316,31047374:31047458,31047561:31047623,31047762:31047778,31047938:31048027,31047939:31047956,31048152:31048183,31048582:31048632,31048583:31048589,31048720:31048732,31048779:31048793,31049041:31049090,31049042:31049057,31049405:31049441,31049688:31049709,31049893:31050032,31050098:31050198,31050347:31050455,31050593:31050713,31050885:31051056,31051157:31051226,31051365:31051466,31051616:31051648,31051829:31051897,31051830:31051855,31052139:31052195,31052383:31052454,31052632:31052661,31052879:31053316,31053088:31053170,31053351:31053421,31053598:31054208,31053844:31053950,31054019:31054084,31054312:31054374,31054568:31054645,31054826:31054907,31055086:31055156,31055334:31055393,31055580:31055637,31055820:31055844,31056058:31056173,31056319:31056383,31056561:31056621,31056805:31056865,31057012:31057076,31057262:31057330,31057476:31057505,31057477:3105754', 'assoc_mat': '31045057:carton:4230:31046620,31045058:carton:4230:31046761,31045059:carton:4230:31046800,31045060:carton:4230:31046905,31045061:carton:4230:31046868,31045062:carton:4230:31046837,31045266:carton:4230:31047184,31047218:carton:4230:31047351,31047219:carton:4230:31047316,31047374:carton:4230:31047458,31047561:carton:4230:31047623,31047762:carton:4230:31047778,31047938:carton:4230:31048027,31047939:carton:4230:31047956,31048152:carton:4230:31048183,31048582:carton:4230:31048632,31048583:carton:4230:31048589,31048720:carton:4230:31048732,31048779:carton:4230:31048793,31049041:carton:4230:31049090,31049042:carton:4230:31049057,31049405:carton:4230:31049441,31049688:carton:4230:31049709,31049893:carton:4230:31050032,31050098:carton:4230:31050198,31050347:carton:4230:31050455,31050593:carton:4230:31050713,31050885:carton:4230:31051056,31051157:carton:4230:31051226,31051365:carton:4230:31051466,31051616:carton:4230:31051648,31051829:carton:4230:31051897,31051830:carton:4230:31051855,31052139:carton:4230:31052195,3105'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008604005016482317, 'nb_photo': 413, 'list_port_cont': '31046608,31046762,31046797,31046833,31046901,31047350,31047456,31047768,31048024,31048171,31048634,31049705,31050030,31050201,31050448,31051057,31051212,31051470,31051636,31052453,31052651,31053311,31053415,31054636,31055149,31055397,31055645,31056168,31056370,31056854,31057072,31057509,31060487,31061459,31061713,31061925,31062572,31062836,31063081,31063451,31063761,31063916,31064246,31064873,31064998,31065297,31065526,31065834,31066150,31066365,31066615,31066819,31066991,31067270,31067560,31067713,31068130,31068319,31068802,31069111,31069277,31069571,31069853,31070102,31070263,31070495,31070781,31070997,31071241,31071347,31071592,31071879,31072584,31072755,31072984,31073164,31073484,31073612,31073649,31074057,31074333,31074529,31074746,31074961,31075190,31075580,31075820,31076046,31076209,31076454,31076631,31076917,31077086,31077404,31077637,31078061,31078297,31078765,31079111,31079608,31079878,31080333,31080524,31080887,31081095,31081278,31081466,31081728,31082210,31082450,31082707,31083152,31083333,3108360', 'assoc_port': '31045057:31046608,31045058:31046762,31045059:31046797,31045060:31046901,31045062:31046833,31047218:31047350,31047374:31047456,31047762:31047768,31047938:31048024,31048152:31048171,31048582:31048634,31049688:31049705,31049893:31050030,31050098:31050201,31050347:31050448,31050885:31051057,31051157:31051212,31051365:31051470,31051616:31051636,31052383:31052453,31052632:31052651,31052879:31053311,31053351:31053415,31054568:31054636,31055086:31055149,31055334:31055397,31055580:31055645,31056058:31056168,31056319:31056370,31056805:31056854,31057012:31057072,31057476:31057509,31060437:31060487,31061399:31061459,31061642:31061713,31061899:31061925,31062510:31062572,31062789:31062836,31063031:31063081,31063433:31063451,31063739:31063761,31063899:31063916,31064144:31064246,31064773:31064873,31064983:31064998,31065237:31065297,31065488:31065526,31065752:31065834,31066031:31066150,31066305:31066365,31066515:31066615,31066754:31066819,31066923:31066991,31067145:31067270,31067422:31067560,31067661:31067713,31068071:3106813', 'assoc_mat': '31045057:metal:4230:31046608,31045058:metal:4230:31046762,31045059:metal:4230:31046797,31045060:metal:4230:31046901,31045062:metal:4230:31046833,31047218:metal:4230:31047350,31047374:metal:4230:31047456,31047762:metal:4230:31047768,31047938:metal:4230:31048024,31048152:metal:4230:31048171,31048582:metal:4230:31048634,31049688:metal:4230:31049705,31049893:metal:4230:31050030,31050098:metal:4230:31050201,31050347:metal:4230:31050448,31050885:metal:4230:31051057,31051157:metal:4230:31051212,31051365:metal:4230:31051470,31051616:metal:4230:31051636,31052383:metal:4230:31052453,31052632:metal:4230:31052651,31052879:metal:4230:31053311,31053351:metal:4230:31053415,31054568:metal:4230:31054636,31055086:metal:4230:31055149,31055334:metal:4230:31055397,31055580:metal:4230:31055645,31056058:metal:4230:31056168,31056319:metal:4230:31056370,31056805:metal:4230:31056854,31057012:metal:4230:31057072,31057476:metal:4230:31057509,31060437:metal:4230:31060487,31061399:metal:4230:31061459,31061642:metal:4230:31061713,31061899:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16700071442774592, 'nb_photo': 118958, 'list_port_cont': '31046612,31046765,31046799,31046824,31046874,31046907,31047198,31047310,31047352,31047454,31047625,31047776,31047955,31048026,31048185,31048598,31048635,31048733,31048796,31049058,31049085,31049449,31049700,31050027,31050200,31050452,31050726,31051055,31051217,31051474,31051652,31051858,31051890,31052205,31052450,31052665,31053173,31053320,31053420,31053944,31054087,31054207,31054385,31054651,31054902,31055157,31055401,31055646,31055842,31056178,31056382,31056626,31056862,31057075,31057326,31057502,31057535,31057806,31058093,31058335,31058618,31058840,31059094,31059266,31059730,31060035,31060247,31060456,31060489,31060736,31061019,31061212,31061466,31061714,31061927,31062299,31062565,31062760,31062848,31063051,31063094,31063449,31063497,31063762,31063930,31064251,31064421,31064622,31064874,31065007,31065302,31065530,31065845,31066154,31066366,31066610,31066814,31067006,31067281,31067562,31067721,31067848,31068124,31068291,31068321,31068813,31068883,31069114,31069285,31069575,31069847,31070107,31070266,3107048', 'assoc_port': '31045057:31046612,31045058:31046765,31045059:31046799,31045060:31046907,31045061:31046874,31045062:31046824,31045266:31047198,31047218:31047352,31047219:31047310,31047374:31047454,31047561:31047625,31047762:31047776,31047938:31048026,31047939:31047955,31048152:31048185,31048582:31048635,31048583:31048598,31048720:31048733,31048779:31048796,31049041:31049085,31049042:31049058,31049405:31049449,31049688:31049700,31049893:31050027,31050098:31050200,31050347:31050452,31050593:31050726,31050885:31051055,31051157:31051217,31051365:31051474,31051616:31051652,31051829:31051890,31051830:31051858,31052139:31052205,31052383:31052450,31052632:31052665,31052879:31053320,31053088:31053173,31053351:31053420,31053598:31054207,31053844:31053944,31054019:31054087,31054312:31054385,31054568:31054651,31054826:31054902,31055086:31055157,31055334:31055401,31055580:31055646,31055820:31055842,31056058:31056178,31056319:31056382,31056561:31056626,31056805:31056862,31057012:31057075,31057262:31057326,31057476:31057502,31057477:3105753', 'assoc_mat': '31045057:papier:4230:31046612,31045058:papier:4230:31046765,31045059:papier:4230:31046799,31045060:papier:4230:31046907,31045061:papier:4230:31046874,31045062:papier:4230:31046824,31045266:papier:4230:31047198,31047218:papier:4230:31047352,31047219:papier:4230:31047310,31047374:papier:4230:31047454,31047561:papier:4230:31047625,31047762:papier:4230:31047776,31047938:papier:4230:31048026,31047939:papier:4230:31047955,31048152:papier:4230:31048185,31048582:papier:4230:31048635,31048583:papier:4230:31048598,31048720:papier:4230:31048733,31048779:papier:4230:31048796,31049041:papier:4230:31049085,31049042:papier:4230:31049058,31049405:papier:4230:31049449,31049688:papier:4230:31049700,31049893:papier:4230:31050027,31050098:papier:4230:31050200,31050347:papier:4230:31050452,31050593:papier:4230:31050726,31050885:papier:4230:31051055,31051157:papier:4230:31051217,31051365:papier:4230:31051474,31051616:papier:4230:31051652,31051829:papier:4230:31051890,31051830:papier:4230:31051858,31052139:papier:4230:31052205,3105'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0025050445267051, 'nb_photo': 479, 'list_port_cont': '31046759,31046902,31047347,31047462,31047616,31047954,31048023,31048180,31049084,31049711,31050025,31050208,31050457,31050725,31051048,31051222,31051643,31051853,31051891,31052206,31052444,31052660,31053416,31054908,31055394,31055640,31056625,31056861,31058626,31059259,31059727,31060030,31060258,31060455,31060498,31061210,31061467,31061712,31061926,31062297,31062576,31062844,31063461,31063760,31063928,31064256,31064409,31065293,31065532,31066153,31066355,31066613,31066818,31067002,31067285,31067559,31067715,31068298,31068329,31068882,31069284,31069577,31069852,31070782,31071010,31071240,31071583,31072339,31072590,31072752,31072990,31073174,31073490,31073607,31073657,31074074,31074337,31074527,31074754,31074963,31075194,31075372,31075577,31075816,31076044,31076217,31076447,31076624,31077078,31077401,31077817,31078057,31078747,31079540,31079891,31080890,31081096,31081276,31081481,31081726,31081938,31082203,31082458,31082708,31082833,31083145,31083334,31083612,31083847,31083945,31084026,31084578,31084817,3108509', 'assoc_port': '31045058:31046759,31045060:31046902,31047218:31047347,31047374:31047462,31047561:31047616,31047938:31048023,31047939:31047954,31048152:31048180,31049041:31049084,31049688:31049711,31049893:31050025,31050098:31050208,31050347:31050457,31050593:31050725,31050885:31051048,31051157:31051222,31051616:31051643,31051829:31051891,31051830:31051853,31052139:31052206,31052383:31052444,31052632:31052660,31053351:31053416,31054826:31054908,31055334:31055394,31055580:31055640,31056561:31056625,31056805:31056861,31058521:31058626,31059238:31059259,31059484:31060455,31059698:31059727,31059959:31060030,31060214:31060258,31060437:31060498,31061194:31061210,31061399:31061467,31061642:31061712,31061899:31061926,31062270:31062297,31062510:31062576,31062789:31062844,31063433:31063461,31063739:31063760,31063899:31063928,31064144:31064256,31064395:31064409,31065237:31065293,31065488:31065532,31066031:31066153,31066305:31066355,31066515:31066613,31066754:31066818,31066923:31067002,31067145:31067285,31067422:31067559,31067661:3106771', 'assoc_mat': '31045058:pehd:4230:31046759,31045060:pehd:4230:31046902,31047218:pehd:4230:31047347,31047374:pehd:4230:31047462,31047561:pehd:4230:31047616,31047938:pehd:4230:31048023,31047939:pehd:4230:31047954,31048152:pehd:4230:31048180,31049041:pehd:4230:31049084,31049688:pehd:4230:31049711,31049893:pehd:4230:31050025,31050098:pehd:4230:31050208,31050347:pehd:4230:31050457,31050593:pehd:4230:31050725,31050885:pehd:4230:31051048,31051157:pehd:4230:31051222,31051616:pehd:4230:31051643,31051829:pehd:4230:31051891,31051830:pehd:4230:31051853,31052139:pehd:4230:31052206,31052383:pehd:4230:31052444,31052632:pehd:4230:31052660,31053351:pehd:4230:31053416,31054826:pehd:4230:31054908,31055334:pehd:4230:31055394,31055580:pehd:4230:31055640,31056561:pehd:4230:31056625,31056805:pehd:4230:31056861,31058521:pehd:4230:31058626,31059238:pehd:4230:31059259,31059484:pehd:4230:31060455,31059698:pehd:4230:31059727,31059959:pehd:4230:31060030,31060214:pehd:4230:31060258,31060437:pehd:4230:31060498,31061194:pehd:4230:31061210,31061399:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.019963231551467696, 'nb_photo': 9440, 'list_port_cont': '31046610,31046752,31046795,31046836,31046873,31046909,31047199,31047312,31047346,31047464,31047618,31047781,31047953,31048028,31048186,31048597,31048633,31048735,31048786,31049050,31049088,31049446,31049713,31050028,31050206,31050460,31050722,31051059,31051218,31051473,31051649,31051848,31051893,31052201,31052447,31052662,31053163,31053324,31053419,31053947,31054089,31054202,31054386,31054642,31054899,31055150,31055398,31055647,31055841,31056175,31056381,31056627,31056863,31057083,31057332,31057508,31057545,31057802,31058096,31058333,31058617,31058843,31059095,31059265,31059731,31060023,31060256,31060447,31060496,31060726,31061017,31061216,31061465,31061721,31061923,31062295,31062577,31062757,31062847,31063055,31063089,31063458,31063496,31063757,31063920,31064259,31064423,31064621,31064876,31065003,31065304,31065529,31065846,31066160,31066361,31066616,31066822,31067004,31067284,31067547,31067714,31067845,31068127,31068292,31068330,31068808,31068888,31069120,31069282,31069578,31069861,31070106,31070271,3107048', 'assoc_port': '31045057:31046610,31045058:31046752,31045059:31046795,31045060:31046909,31045061:31046873,31045062:31046836,31045266:31047199,31047218:31047346,31047219:31047312,31047374:31047464,31047561:31047618,31047762:31047781,31047938:31048028,31047939:31047953,31048152:31048186,31048582:31048633,31048583:31048597,31048720:31048735,31048779:31048786,31049041:31049088,31049042:31049050,31049405:31049446,31049688:31049713,31049893:31050028,31050098:31050206,31050347:31050460,31050593:31050722,31050885:31051059,31051157:31051218,31051365:31051473,31051616:31051649,31051829:31051893,31051830:31051848,31052139:31052201,31052383:31052447,31052632:31052662,31052879:31053324,31053088:31053163,31053351:31053419,31053598:31054202,31053844:31053947,31054019:31054089,31054312:31054386,31054568:31054642,31054826:31054899,31055086:31055150,31055334:31055398,31055580:31055647,31055820:31055841,31056058:31056175,31056319:31056381,31056561:31056627,31056805:31056863,31057012:31057083,31057262:31057332,31057476:31057508,31057477:3105754', 'assoc_mat': '31045057:pet_clair:4230:31046610,31045058:pet_clair:4230:31046752,31045059:pet_clair:4230:31046795,31045060:pet_clair:4230:31046909,31045061:pet_clair:4230:31046873,31045062:pet_clair:4230:31046836,31045266:pet_clair:4230:31047199,31047218:pet_clair:4230:31047346,31047219:pet_clair:4230:31047312,31047374:pet_clair:4230:31047464,31047561:pet_clair:4230:31047618,31047762:pet_clair:4230:31047781,31047938:pet_clair:4230:31048028,31047939:pet_clair:4230:31047953,31048152:pet_clair:4230:31048186,31048582:pet_clair:4230:31048633,31048583:pet_clair:4230:31048597,31048720:pet_clair:4230:31048735,31048779:pet_clair:4230:31048786,31049041:pet_clair:4230:31049088,31049042:pet_clair:4230:31049050,31049405:pet_clair:4230:31049446,31049688:pet_clair:4230:31049713,31049893:pet_clair:4230:31050028,31050098:pet_clair:4230:31050206,31050347:pet_clair:4230:31050460,31050593:pet_clair:4230:31050722,31050885:pet_clair:4230:31051059,31051157:pet_clair:4230:31051218,31051365:pet_clair:4230:31051473,31051616:pet_clair:4230:31051649,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021249525124067306, 'nb_photo': 257, 'list_port_cont': '31046906,31047190,31047315,31047348,31047628,31047777,31048020,31048791,31049442,31049712,31050029,31050209,31050459,31050728,31051051,31051475,31052452,31053948,31054206,31054383,31054638,31054905,31055154,31055389,31055843,31056624,31057510,31058097,31059262,31060029,31061214,31061453,31061720,31061921,31062755,31063759,31063925,31064253,31064629,31064875,31065012,31065298,31065531,31065844,31066152,31066369,31066609,31066812,31067277,31067563,31067722,31067856,31069582,31069855,31070493,31070783,31071007,31071349,31071875,31072337,31072582,31072757,31072995,31073175,31073644,31074073,31075579,31075832,31076048,31076216,31076457,31076908,31077080,31077408,31077651,31077809,31078755,31080323,31080525,31081101,31082216,31082456,31082713,31083159,31083610,31083852,31084020,31084624,31085256,31085452,31086041,31086373,31086606,31086891,31087055,31087539,31087722,31087807,31088209,31088418,31088493,31088662,31088879,31089633,31090106,31090919,31091363,31091610,31092131,31092550,31093173,31094018,31094278,3109485', 'assoc_port': '31045060:31046906,31045266:31047190,31047218:31047348,31047219:31047315,31047561:31047628,31047762:31047777,31047938:31048020,31048779:31048791,31049405:31049442,31049688:31049712,31049893:31050029,31050098:31050209,31050347:31050459,31050593:31050728,31050885:31051051,31051365:31051475,31052383:31052452,31053598:31054206,31053844:31053948,31054312:31054383,31054568:31054638,31054826:31054905,31055086:31055154,31055334:31055389,31055820:31055843,31056561:31056624,31057476:31057510,31058026:31058097,31059238:31059262,31059959:31060029,31061194:31061214,31061399:31061453,31061642:31061720,31061899:31061921,31062141:31062755,31063739:31063759,31063899:31063925,31064144:31064253,31064564:31064629,31064773:31064875,31064983:31065012,31065237:31065298,31065488:31065531,31065752:31065844,31066031:31066152,31066305:31066369,31066515:31066609,31066754:31066812,31067145:31067277,31067422:31067563,31067661:31067722,31067830:31067856,31069504:31069582,31069759:31069855,31070403:31070493,31070678:31070783,31070927:3107100', 'assoc_mat': '31045060:pet_fonce:4230:31046906,31045266:pet_fonce:4230:31047190,31047218:pet_fonce:4230:31047348,31047219:pet_fonce:4230:31047315,31047561:pet_fonce:4230:31047628,31047762:pet_fonce:4230:31047777,31047938:pet_fonce:4230:31048020,31048779:pet_fonce:4230:31048791,31049405:pet_fonce:4230:31049442,31049688:pet_fonce:4230:31049712,31049893:pet_fonce:4230:31050029,31050098:pet_fonce:4230:31050209,31050347:pet_fonce:4230:31050459,31050593:pet_fonce:4230:31050728,31050885:pet_fonce:4230:31051051,31051365:pet_fonce:4230:31051475,31052383:pet_fonce:4230:31052452,31053598:pet_fonce:4230:31054206,31053844:pet_fonce:4230:31053948,31054312:pet_fonce:4230:31054383,31054568:pet_fonce:4230:31054638,31054826:pet_fonce:4230:31054905,31055086:pet_fonce:4230:31055154,31055334:pet_fonce:4230:31055389,31055820:pet_fonce:4230:31055843,31056561:pet_fonce:4230:31056624,31057476:pet_fonce:4230:31057510,31058026:pet_fonce:4230:31058097,31059238:pet_fonce:4230:31059262,31059959:pet_fonce:4230:31060029,31061194:pet_fonce:4230:31061214,3'}), 'main_stat': {'nb_photos': 706}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31048690,31048691,31048692,31048693,31048694,31048695,31048696?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-08', 0.786783804034288),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_08_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.38%', 6504], 'carton': ['carton', '2.87%', 20108], 'metal': ['metal', '0.09%', 413], 'papier': ['papier', '16.7%', 118958], 'pehd': ['pehd', '0.25%', 479], 'pet_clair': ['pet_clair', '2.0%', 9440], 'pet_fonce': ['pet_fonce', '0.21%', 257]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_08_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.47user 3.00system 0:42.95elapsed 12%CPU (0avgtext+0avgdata 190520maxresident)k 143856inputs+312outputs (661major+52672minor)pagefaults 0swaps