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-04 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_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 : (2, 30) 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 : 04 mtr_id : dashboard_places : SCCU_cam6 date : 2026-04 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2026-04%') and created_at like '%2026-04%'))); nb_day : (2, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 04 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 04 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%042026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-04-01 : dt_date_just_month_year : 2026-04-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_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-04-01" AND ded.date <= "2026-04-30" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (2972772,2973441,2974039,2974634,2975087,2975654,2976327,2976993,2977605,2977788,2978162,2978630,2979206,2979812,2980462,2981074,2981304,2981496,2982014,2982462,2982878,2983332,2983880,2984362,2984776,2984974) 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.01793031414406819, 'nb_photo': 20084, 'list_port_cont': '30918278,30918312,30918361,30918398,30918433,30918479,30918507,30918540,30918579,30918620,30918655,30918698,30918742,30918787,30918807,30918860,30918885,30918931,30918968,30919012,30920608,30920686,30920831,30920867,30923900,30923951,30923978,30924012,30924057,30924097,30924128,30924177,30924198,30924236,30924285,30924320,30924353,30924405,30924443,30924474,30924506,30924542,30924581,30924633,30924654,30924705,30926218,30926346,30929425,30929452,30929499,30929541,30929575,30929614,30929643,30929697,30929753,30929781,30929830,30929865,30929890,30929939,30929970,30930020,30930056,30930086,30930122,30931766,30931884,30932109,30932637,30932735,30934858,30934894,30934946,30934976,30935013,30935060,30935084,30935127,30935173,30935208,30935243,30935287,30935326,30935356,30935405,30935445,30935479,30935520,30935563,30935587,30935674,30935736,30935811,30935925,30938993,30939033,30939067,30939107,30939144,30939191,30939220,30939257,30939298,30939339,30939380,30939415,30939446,30939491,30939524,30939574,30939607,3093964', 'assoc_port': '30918204:30918312,30918205:30918278,30918206:30918361,30918207:30918398,30918208:30918433,30918209:30918479,30918210:30918507,30918212:30918540,30918215:30918579,30918218:30920686,30918221:30920867,30918224:30918620,30918227:30918655,30918230:30918698,30918232:30918742,30918235:30918787,30918238:30918807,30918241:30918860,30918244:30918885,30918247:30918931,30918250:30919012,30918253:30918968,30918613:30920608,30918925:30920831,30923830:30923900,30923831:30923951,30923832:30924012,30923833:30923978,30923834:30924057,30923835:30924097,30923836:30924128,30923838:30924177,30923840:30924198,30923843:30924236,30923846:30924285,30923849:30924320,30923852:30924353,30923855:30924405,30923858:30924443,30923861:30924474,30923864:30924506,30923867:30924581,30923870:30924542,30923873:30924633,30923876:30924654,30923879:30924705,30924273:30926218,30924728:30926346,30929365:30929452,30929366:30929425,30929367:30929499,30929368:30929541,30929369:30929575,30929370:30929614,30929371:30929643,30929373:30929697,30929375:3092975', 'assoc_mat': '30918204:autre:4230:30918312,30918205:autre:4230:30918278,30918206:autre:4230:30918361,30918207:autre:4230:30918398,30918208:autre:4230:30918433,30918209:autre:4230:30918479,30918210:autre:4230:30918507,30918212:autre:4230:30918540,30918215:autre:4230:30918579,30918218:autre:4230:30920686,30918221:autre:4230:30920867,30918224:autre:4230:30918620,30918227:autre:4230:30918655,30918230:autre:4230:30918698,30918232:autre:4230:30918742,30918235:autre:4230:30918787,30918238:autre:4230:30918807,30918241:autre:4230:30918860,30918244:autre:4230:30918885,30918247:autre:4230:30918931,30918250:autre:4230:30919012,30918253:autre:4230:30918968,30918613:autre:4230:30920608,30918925:autre:4230:30920831,30923830:autre:4230:30923900,30923831:autre:4230:30923951,30923832:autre:4230:30924012,30923833:autre:4230:30923978,30923834:autre:4230:30924057,30923835:autre:4230:30924097,30923836:autre:4230:30924128,30923838:autre:4230:30924177,30923840:autre:4230:30924198,30923843:autre:4230:30924236,30923846:autre:4230:30924285,30923849:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03660388262130405, 'nb_photo': 65883, 'list_port_cont': '30918287,30918329,30918363,30918403,30918441,30918476,30918509,30918557,30918593,30918623,30918661,30918706,30918743,30918783,30918824,30918861,30918897,30918934,30918976,30919016,30920609,30920695,30920830,30920874,30923903,30923945,30923986,30924015,30924054,30924101,30924135,30924165,30924205,30924251,30924288,30924330,30924362,30924395,30924444,30924481,30924518,30924557,30924587,30924627,30924671,30924695,30926223,30926338,30929427,30929453,30929489,30929535,30929582,30929613,30929646,30929692,30929752,30929795,30929831,30929854,30929904,30929940,30929979,30930018,30930051,30930098,30930135,30931767,30931885,30932111,30932641,30932729,30934869,30934907,30934933,30934985,30935020,30935057,30935100,30935128,30935176,30935206,30935238,30935284,30935330,30935363,30935399,30935451,30935493,30935529,30935555,30935600,30935669,30935742,30935822,30935937,30939008,30939038,30939077,30939117,30939152,30939184,30939232,30939268,30939300,30939331,30939375,30939421,30939457,30939496,30939536,30939562,30939608,3093965', 'assoc_port': '30918204:30918329,30918205:30918287,30918206:30918363,30918207:30918403,30918208:30918441,30918209:30918476,30918210:30918509,30918212:30918557,30918215:30918593,30918218:30920695,30918221:30920874,30918224:30918623,30918227:30918661,30918230:30918706,30918232:30918743,30918235:30918783,30918238:30918824,30918241:30918861,30918244:30918897,30918247:30918934,30918250:30919016,30918253:30918976,30918613:30920609,30918925:30920830,30923830:30923903,30923831:30923945,30923832:30924015,30923833:30923986,30923834:30924054,30923835:30924101,30923836:30924135,30923838:30924165,30923840:30924205,30923843:30924251,30923846:30924288,30923849:30924330,30923852:30924362,30923855:30924395,30923858:30924444,30923861:30924481,30923864:30924518,30923867:30924587,30923870:30924557,30923873:30924627,30923876:30924671,30923879:30924695,30924273:30926223,30924728:30926338,30929365:30929453,30929366:30929427,30929367:30929489,30929368:30929535,30929369:30929582,30929370:30929613,30929371:30929646,30929373:30929692,30929375:3092975', 'assoc_mat': '30918204:carton:4230:30918329,30918205:carton:4230:30918287,30918206:carton:4230:30918363,30918207:carton:4230:30918403,30918208:carton:4230:30918441,30918209:carton:4230:30918476,30918210:carton:4230:30918509,30918212:carton:4230:30918557,30918215:carton:4230:30918593,30918218:carton:4230:30920695,30918221:carton:4230:30920874,30918224:carton:4230:30918623,30918227:carton:4230:30918661,30918230:carton:4230:30918706,30918232:carton:4230:30918743,30918235:carton:4230:30918783,30918238:carton:4230:30918824,30918241:carton:4230:30918861,30918244:carton:4230:30918897,30918247:carton:4230:30918934,30918250:carton:4230:30919016,30918253:carton:4230:30918976,30918613:carton:4230:30920609,30918925:carton:4230:30920830,30923830:carton:4230:30923903,30923831:carton:4230:30923945,30923832:carton:4230:30924015,30923833:carton:4230:30923986,30923834:carton:4230:30924054,30923835:carton:4230:30924101,30923836:carton:4230:30924135,30923838:carton:4230:30924165,30923840:carton:4230:30924205,30923843:carton:4230:30924251,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001138341142811731, 'nb_photo': 1596, 'list_port_cont': '30918281,30918327,30918353,30918474,30918503,30918552,30918583,30918632,30918660,30918696,30918784,30918816,30918847,30918896,30918941,30919018,30920603,30920682,30920839,30920870,30923946,30924019,30924048,30924099,30924125,30924175,30924202,30924240,30924292,30924327,30924369,30924404,30924427,30924479,30924509,30924541,30924579,30924661,30924702,30926231,30926339,30929417,30929464,30929502,30929531,30929572,30929606,30929654,30929691,30929745,30929784,30929829,30929867,30929902,30929942,30929971,30930012,30930041,30930087,30930120,30931758,30931878,30932115,30932625,30932734,30934862,30934978,30935010,30935049,30935085,30935133,30935209,30935249,30935290,30935319,30935355,30935394,30935454,30935481,30935525,30935561,30935601,30935667,30935734,30935926,30939030,30939149,30939193,30939291,30939342,30939376,30939454,30939486,30939525,30939569,30939635,30939710,30939795,30941361,30941503,30944418,30944446,30944495,30944536,30944602,30944647,30944680,30944715,30944751,30944787,30944831,30944875,30944942,3094498', 'assoc_port': '30918204:30918327,30918205:30918281,30918206:30918353,30918209:30918474,30918210:30918503,30918212:30918552,30918215:30918583,30918218:30920682,30918221:30920870,30918224:30918632,30918227:30918660,30918230:30918696,30918235:30918784,30918238:30918816,30918241:30918847,30918244:30918896,30918247:30918941,30918250:30919018,30918613:30920603,30918925:30920839,30923831:30923946,30923832:30924019,30923834:30924048,30923835:30924099,30923836:30924125,30923838:30924175,30923840:30924202,30923843:30924240,30923846:30924292,30923849:30924327,30923852:30924369,30923855:30924404,30923858:30924427,30923861:30924479,30923864:30924509,30923867:30924579,30923870:30924541,30923876:30924661,30923879:30924702,30924273:30926231,30924728:30926339,30929365:30929464,30929366:30929417,30929367:30929502,30929368:30929531,30929369:30929572,30929370:30929606,30929371:30929654,30929373:30929691,30929375:30929745,30929376:30929902,30929378:30929784,30929380:30932734,30929382:30929829,30929384:30929867,30929387:30929942,30929388:3092997', 'assoc_mat': '30918204:metal:4230:30918327,30918205:metal:4230:30918281,30918206:metal:4230:30918353,30918209:metal:4230:30918474,30918210:metal:4230:30918503,30918212:metal:4230:30918552,30918215:metal:4230:30918583,30918218:metal:4230:30920682,30918221:metal:4230:30920870,30918224:metal:4230:30918632,30918227:metal:4230:30918660,30918230:metal:4230:30918696,30918235:metal:4230:30918784,30918238:metal:4230:30918816,30918241:metal:4230:30918847,30918244:metal:4230:30918896,30918247:metal:4230:30918941,30918250:metal:4230:30919018,30918613:metal:4230:30920603,30918925:metal:4230:30920839,30923831:metal:4230:30923946,30923832:metal:4230:30924019,30923834:metal:4230:30924048,30923835:metal:4230:30924099,30923836:metal:4230:30924125,30923838:metal:4230:30924175,30923840:metal:4230:30924202,30923843:metal:4230:30924240,30923846:metal:4230:30924292,30923849:metal:4230:30924327,30923852:metal:4230:30924369,30923855:metal:4230:30924404,30923858:metal:4230:30924427,30923861:metal:4230:30924479,30923864:metal:4230:30924509,30923867:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.181623777380301, 'nb_photo': 363568, 'list_port_cont': '30918279,30918325,30918356,30918401,30918436,30918478,30918516,30918550,30918588,30918630,30918672,30918708,30918747,30918781,30918823,30918859,30918898,30918935,30918975,30919015,30920606,30920690,30920837,30920878,30923915,30923944,30923989,30924027,30924062,30924103,30924130,30924176,30924213,30924248,30924294,30924329,30924367,30924403,30924438,30924469,30924512,30924558,30924578,30924629,30924667,30924707,30926228,30926342,30929421,30929463,30929496,30929528,30929573,30929609,30929656,30929694,30929751,30929790,30929826,30929870,30929901,30929938,30929981,30930016,30930055,30930095,30930128,30931769,30931879,30932107,30932630,30932723,30934871,30934905,30934942,30934982,30935022,30935047,30935097,30935123,30935175,30935210,30935247,30935289,30935331,30935367,30935402,30935447,30935490,30935517,30935564,30935598,30935676,30935743,30935823,30935932,30939003,30939034,30939082,30939110,30939156,30939192,30939227,30939265,30939303,30939341,30939384,30939419,30939460,30939501,30939530,30939570,30939606,3093964', 'assoc_port': '30918204:30918325,30918205:30918279,30918206:30918356,30918207:30918401,30918208:30918436,30918209:30918478,30918210:30918516,30918212:30918550,30918215:30918588,30918218:30920690,30918221:30920878,30918224:30918630,30918227:30918672,30918230:30918708,30918232:30918747,30918235:30918781,30918238:30918823,30918241:30918859,30918244:30918898,30918247:30918935,30918250:30919015,30918253:30918975,30918613:30920606,30918925:30920837,30923830:30923915,30923831:30923944,30923832:30924027,30923833:30923989,30923834:30924062,30923835:30924103,30923836:30924130,30923838:30924176,30923840:30924213,30923843:30924248,30923846:30924294,30923849:30924329,30923852:30924367,30923855:30924403,30923858:30924438,30923861:30924469,30923864:30924512,30923867:30924578,30923870:30924558,30923873:30924629,30923876:30924667,30923879:30924707,30924273:30926228,30924728:30926342,30929365:30929463,30929366:30929421,30929367:30929496,30929368:30929528,30929369:30929573,30929370:30929609,30929371:30929656,30929373:30929694,30929375:3092975', 'assoc_mat': '30918204:papier:4230:30918325,30918205:papier:4230:30918279,30918206:papier:4230:30918356,30918207:papier:4230:30918401,30918208:papier:4230:30918436,30918209:papier:4230:30918478,30918210:papier:4230:30918516,30918212:papier:4230:30918550,30918215:papier:4230:30918588,30918218:papier:4230:30920690,30918221:papier:4230:30920878,30918224:papier:4230:30918630,30918227:papier:4230:30918672,30918230:papier:4230:30918708,30918232:papier:4230:30918747,30918235:papier:4230:30918781,30918238:papier:4230:30918823,30918241:papier:4230:30918859,30918244:papier:4230:30918898,30918247:papier:4230:30918935,30918250:papier:4230:30919015,30918253:papier:4230:30918975,30918613:papier:4230:30920606,30918925:papier:4230:30920837,30923830:papier:4230:30923915,30923831:papier:4230:30923944,30923832:papier:4230:30924027,30923833:papier:4230:30923989,30923834:papier:4230:30924062,30923835:papier:4230:30924103,30923836:papier:4230:30924130,30923838:papier:4230:30924176,30923840:papier:4230:30924213,30923843:papier:4230:30924248,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038538430261352698, 'nb_photo': 1978, 'list_port_cont': '30918282,30918367,30918438,30918469,30918514,30918547,30918591,30918628,30918669,30918703,30918738,30918788,30918819,30918862,30918901,30918936,30918981,30919017,30920605,30920692,30920834,30920875,30923916,30923947,30924026,30924093,30924137,30924174,30924214,30924243,30924291,30924333,30924364,30924390,30924439,30924477,30924516,30924554,30924591,30924632,30924669,30924704,30926229,30926343,30929457,30929500,30929539,30929576,30929616,30929698,30929756,30929789,30929931,30930021,30930047,30930101,30930137,30931881,30932113,30932642,30932730,30934873,30934910,30935053,30935130,30935170,30935211,30935250,30935280,30935329,30935360,30935391,30935455,30935491,30935528,30935562,30935593,30935749,30935819,30935931,30939005,30939157,30939194,30939222,30939258,30939337,30939378,30939413,30939461,30939646,30939790,30941351,30941496,30944413,30944497,30944531,30944614,30944686,30944718,30944756,30944797,30944834,30944948,30944976,30946646,30946802,30949962,30950003,30950041,30950069,30950104,30950147,30950184,3095023', 'assoc_port': '30918205:30918282,30918206:30918367,30918208:30918438,30918209:30918469,30918210:30918514,30918212:30918547,30918215:30918591,30918218:30920692,30918221:30920875,30918224:30918628,30918227:30918669,30918230:30918703,30918232:30918738,30918235:30918788,30918238:30918819,30918241:30918862,30918244:30918901,30918247:30918936,30918250:30919017,30918253:30918981,30918613:30920605,30918925:30920834,30923830:30923916,30923831:30923947,30923832:30924026,30923835:30924093,30923836:30924137,30923838:30924174,30923840:30924214,30923843:30924243,30923846:30924291,30923849:30924333,30923852:30924364,30923855:30924390,30923858:30924439,30923861:30924477,30923864:30924516,30923867:30924591,30923870:30924554,30923873:30924632,30923876:30924669,30923879:30924704,30924273:30926229,30924728:30926343,30929365:30929457,30929367:30929500,30929368:30929539,30929369:30929576,30929370:30929616,30929373:30929698,30929375:30929756,30929378:30929789,30929380:30932730,30929387:30929931,30929390:30932642,30929393:30931881,30929394:3093002', 'assoc_mat': '30918205:pehd:4230:30918282,30918206:pehd:4230:30918367,30918208:pehd:4230:30918438,30918209:pehd:4230:30918469,30918210:pehd:4230:30918514,30918212:pehd:4230:30918547,30918215:pehd:4230:30918591,30918218:pehd:4230:30920692,30918221:pehd:4230:30920875,30918224:pehd:4230:30918628,30918227:pehd:4230:30918669,30918230:pehd:4230:30918703,30918232:pehd:4230:30918738,30918235:pehd:4230:30918788,30918238:pehd:4230:30918819,30918241:pehd:4230:30918862,30918244:pehd:4230:30918901,30918247:pehd:4230:30918936,30918250:pehd:4230:30919017,30918253:pehd:4230:30918981,30918613:pehd:4230:30920605,30918925:pehd:4230:30920834,30923830:pehd:4230:30923916,30923831:pehd:4230:30923947,30923832:pehd:4230:30924026,30923835:pehd:4230:30924093,30923836:pehd:4230:30924137,30923838:pehd:4230:30924174,30923840:pehd:4230:30924214,30923843:pehd:4230:30924243,30923846:pehd:4230:30924291,30923849:pehd:4230:30924333,30923852:pehd:4230:30924364,30923855:pehd:4230:30924390,30923858:pehd:4230:30924439,30923861:pehd:4230:30924477,30923864:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017933922975085236, 'nb_photo': 26738, 'list_port_cont': '30918290,30918319,30918366,30918394,30918428,30918477,30918515,30918556,30918582,30918633,30918668,30918704,30918748,30918780,30918822,30918855,30918895,30918940,30918971,30919006,30920611,30920693,30920827,30920872,30923908,30923950,30923990,30924022,30924059,30924089,30924139,30924166,30924209,30924252,30924280,30924323,30924363,30924400,30924429,30924470,30924513,30924548,30924594,30924634,30924666,30924703,30926226,30926337,30929430,30929460,30929501,30929536,30929581,30929611,30929655,30929689,30929744,30929792,30929818,30929868,30929905,30929935,30929977,30930015,30930054,30930094,30930133,30931762,30931872,30932117,30932634,30932733,30934872,30934906,30934940,30934971,30935019,30935056,30935099,30935129,30935174,30935204,30935248,30935286,30935318,30935359,30935392,30935443,30935485,30935524,30935553,30935604,30935664,30935750,30935812,30935938,30939006,30939039,30939080,30939116,30939158,30939190,30939231,30939264,30939307,30939345,30939386,30939416,30939463,30939488,30939533,30939577,30939605,3093964', 'assoc_port': '30918204:30918319,30918205:30918290,30918206:30918366,30918207:30918394,30918208:30918428,30918209:30918477,30918210:30918515,30918212:30918556,30918215:30918582,30918218:30920693,30918221:30920872,30918224:30918633,30918227:30918668,30918230:30918704,30918232:30918748,30918235:30918780,30918238:30918822,30918241:30918855,30918244:30918895,30918247:30918940,30918250:30919006,30918253:30918971,30918613:30920611,30918925:30920827,30923830:30923908,30923831:30923950,30923832:30924022,30923833:30923990,30923834:30924059,30923835:30924089,30923836:30924139,30923838:30924166,30923840:30924209,30923843:30924252,30923846:30924280,30923849:30924323,30923852:30924363,30923855:30924400,30923858:30924429,30923861:30924470,30923864:30924513,30923867:30924594,30923870:30924548,30923873:30924634,30923876:30924666,30923879:30924703,30924273:30926226,30924728:30926337,30929365:30929460,30929366:30929430,30929367:30929501,30929368:30929536,30929369:30929581,30929370:30929611,30929371:30929655,30929373:30929689,30929375:3092974', 'assoc_mat': '30918204:pet_clair:4230:30918319,30918205:pet_clair:4230:30918290,30918206:pet_clair:4230:30918366,30918207:pet_clair:4230:30918394,30918208:pet_clair:4230:30918428,30918209:pet_clair:4230:30918477,30918210:pet_clair:4230:30918515,30918212:pet_clair:4230:30918556,30918215:pet_clair:4230:30918582,30918218:pet_clair:4230:30920693,30918221:pet_clair:4230:30920872,30918224:pet_clair:4230:30918633,30918227:pet_clair:4230:30918668,30918230:pet_clair:4230:30918704,30918232:pet_clair:4230:30918748,30918235:pet_clair:4230:30918780,30918238:pet_clair:4230:30918822,30918241:pet_clair:4230:30918855,30918244:pet_clair:4230:30918895,30918247:pet_clair:4230:30918940,30918250:pet_clair:4230:30919006,30918253:pet_clair:4230:30918971,30918613:pet_clair:4230:30920611,30918925:pet_clair:4230:30920827,30923830:pet_clair:4230:30923908,30923831:pet_clair:4230:30923950,30923832:pet_clair:4230:30924022,30923833:pet_clair:4230:30923990,30923834:pet_clair:4230:30924059,30923835:pet_clair:4230:30924089,30923836:pet_clair:4230:30924139,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028882596028359836, 'nb_photo': 1039, 'list_port_cont': '30918291,30918323,30918359,30918429,30918473,30918555,30918592,30918634,30918663,30918702,30918777,30918815,30918900,30918982,30920610,30920688,30920836,30920873,30923909,30923942,30923983,30924025,30924063,30924094,30924133,30924173,30924211,30924250,30924284,30924324,30924366,30924401,30924436,30924517,30924546,30924592,30924628,30924670,30924708,30926232,30926345,30929420,30929455,30929495,30929538,30929578,30929617,30929650,30929699,30929822,30929943,30930017,30930048,30931759,30934870,30934909,30934984,30935012,30935202,30935251,30935288,30935327,30935401,30935453,30935488,30935516,30935595,30935670,30935746,30935936,30939009,30939071,30939112,30939151,30939189,30939230,30939266,30939305,30939338,30939382,30939422,30939527,30939613,30939643,30939687,30939800,30941359,30944496,30944532,30944616,30944655,30944684,30944725,30944755,30944795,30944830,30944870,30945022,30946654,30946797,30950038,30950109,30950149,30950190,30950229,30950262,30950329,30950375,30950415,30950445,30950486,30950524,30950563,3095220', 'assoc_port': '30918204:30918323,30918205:30918291,30918206:30918359,30918208:30918429,30918209:30918473,30918212:30918555,30918215:30918592,30918218:30920688,30918221:30920873,30918224:30918634,30918227:30918663,30918230:30918702,30918235:30918777,30918238:30918815,30918244:30918900,30918253:30918982,30918613:30920610,30918925:30920836,30923830:30923909,30923831:30923942,30923832:30924025,30923833:30923983,30923834:30924063,30923835:30924094,30923836:30924133,30923838:30924173,30923840:30924211,30923843:30924250,30923846:30924284,30923849:30924324,30923852:30924366,30923855:30924401,30923858:30924436,30923864:30924517,30923867:30924592,30923870:30924546,30923873:30924628,30923876:30924670,30923879:30924708,30924273:30926232,30924728:30926345,30929365:30929455,30929366:30929420,30929367:30929495,30929368:30929538,30929369:30929578,30929370:30929617,30929371:30929650,30929373:30929699,30929382:30929822,30929387:30929943,30929394:30930017,30929396:30930048,30930076:30931759,30934754:30934870,30934756:30934909,30934758:3093498', 'assoc_mat': '30918204:pet_fonce:4230:30918323,30918205:pet_fonce:4230:30918291,30918206:pet_fonce:4230:30918359,30918208:pet_fonce:4230:30918429,30918209:pet_fonce:4230:30918473,30918212:pet_fonce:4230:30918555,30918215:pet_fonce:4230:30918592,30918218:pet_fonce:4230:30920688,30918221:pet_fonce:4230:30920873,30918224:pet_fonce:4230:30918634,30918227:pet_fonce:4230:30918663,30918230:pet_fonce:4230:30918702,30918235:pet_fonce:4230:30918777,30918238:pet_fonce:4230:30918815,30918244:pet_fonce:4230:30918900,30918253:pet_fonce:4230:30918982,30918613:pet_fonce:4230:30920610,30918925:pet_fonce:4230:30920836,30923830:pet_fonce:4230:30923909,30923831:pet_fonce:4230:30923942,30923832:pet_fonce:4230:30924025,30923833:pet_fonce:4230:30923983,30923834:pet_fonce:4230:30924063,30923835:pet_fonce:4230:30924094,30923836:pet_fonce:4230:30924133,30923838:pet_fonce:4230:30924173,30923840:pet_fonce:4230:30924211,30923843:pet_fonce:4230:30924250,30923846:pet_fonce:4230:30924284,30923849:pet_fonce:4230:30924324,30923852:pet_fonce:4230:30924366,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(2972772,2973441,2974039,2974634,2975087,2975654,2976327,2976993,2977605,2977788,2978162,2978630,2979206,2979812,2980462,2981074,2981304,2981496,2982014,2982462,2982878,2983332,2983880,2984362,2984776,2984974)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998170, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918278,30918312,30918361,30918398,30918433,30918479,30918507,30918540,30918579,30918620,30918655,30918698,30918742,30918787,30918807,30918860,30918885,30918931,30918968,30919012,30920608,30920686,30920831,30920867,30923900,30923951,30923978,30924012,30924057,30924097,30924128,30924177,30924198,30924236,30924285,30924320,30924353,30924405,30924443,30924474,30924506,30924542,30924581,30924633,30924654,30924705,30926218,30926346,30929425,30929452,30929499,30929541,30929575,30929614,30929643,30929697,30929753,30929781,30929830,30929865,30929890,30929939,30929970,30930020,30930056,30930086,30930122,30931766,30931884,30932109,30932637,30932735,30934858,30934894,30934946,30934976,30935013,30935060,30935084,30935127,30935173,30935208,30935243,30935287,30935326,30935356,30935405,30935445,30935479,30935520,30935563,30935587,30935674,30935736,30935811,30935925,30938993,30939033,30939067,30939107,30939144,30939191,30939220,30939257,30939298,30939339,30939380,30939415,30939446,30939491,30939524,30939574,30939607,3093964 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998171, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918287,30918329,30918363,30918403,30918441,30918476,30918509,30918557,30918593,30918623,30918661,30918706,30918743,30918783,30918824,30918861,30918897,30918934,30918976,30919016,30920609,30920695,30920830,30920874,30923903,30923945,30923986,30924015,30924054,30924101,30924135,30924165,30924205,30924251,30924288,30924330,30924362,30924395,30924444,30924481,30924518,30924557,30924587,30924627,30924671,30924695,30926223,30926338,30929427,30929453,30929489,30929535,30929582,30929613,30929646,30929692,30929752,30929795,30929831,30929854,30929904,30929940,30929979,30930018,30930051,30930098,30930135,30931767,30931885,30932111,30932641,30932729,30934869,30934907,30934933,30934985,30935020,30935057,30935100,30935128,30935176,30935206,30935238,30935284,30935330,30935363,30935399,30935451,30935493,30935529,30935555,30935600,30935669,30935742,30935822,30935937,30939008,30939038,30939077,30939117,30939152,30939184,30939232,30939268,30939300,30939331,30939375,30939421,30939457,30939496,30939536,30939562,30939608,3093965 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998172, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918281,30918327,30918353,30918474,30918503,30918552,30918583,30918632,30918660,30918696,30918784,30918816,30918847,30918896,30918941,30919018,30920603,30920682,30920839,30920870,30923946,30924019,30924048,30924099,30924125,30924175,30924202,30924240,30924292,30924327,30924369,30924404,30924427,30924479,30924509,30924541,30924579,30924661,30924702,30926231,30926339,30929417,30929464,30929502,30929531,30929572,30929606,30929654,30929691,30929745,30929784,30929829,30929867,30929902,30929942,30929971,30930012,30930041,30930087,30930120,30931758,30931878,30932115,30932625,30932734,30934862,30934978,30935010,30935049,30935085,30935133,30935209,30935249,30935290,30935319,30935355,30935394,30935454,30935481,30935525,30935561,30935601,30935667,30935734,30935926,30939030,30939149,30939193,30939291,30939342,30939376,30939454,30939486,30939525,30939569,30939635,30939710,30939795,30941361,30941503,30944418,30944446,30944495,30944536,30944602,30944647,30944680,30944715,30944751,30944787,30944831,30944875,30944942,3094498 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998173, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918279,30918325,30918356,30918401,30918436,30918478,30918516,30918550,30918588,30918630,30918672,30918708,30918747,30918781,30918823,30918859,30918898,30918935,30918975,30919015,30920606,30920690,30920837,30920878,30923915,30923944,30923989,30924027,30924062,30924103,30924130,30924176,30924213,30924248,30924294,30924329,30924367,30924403,30924438,30924469,30924512,30924558,30924578,30924629,30924667,30924707,30926228,30926342,30929421,30929463,30929496,30929528,30929573,30929609,30929656,30929694,30929751,30929790,30929826,30929870,30929901,30929938,30929981,30930016,30930055,30930095,30930128,30931769,30931879,30932107,30932630,30932723,30934871,30934905,30934942,30934982,30935022,30935047,30935097,30935123,30935175,30935210,30935247,30935289,30935331,30935367,30935402,30935447,30935490,30935517,30935564,30935598,30935676,30935743,30935823,30935932,30939003,30939034,30939082,30939110,30939156,30939192,30939227,30939265,30939303,30939341,30939384,30939419,30939460,30939501,30939530,30939570,30939606,3093964 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998174, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918282,30918367,30918438,30918469,30918514,30918547,30918591,30918628,30918669,30918703,30918738,30918788,30918819,30918862,30918901,30918936,30918981,30919017,30920605,30920692,30920834,30920875,30923916,30923947,30924026,30924093,30924137,30924174,30924214,30924243,30924291,30924333,30924364,30924390,30924439,30924477,30924516,30924554,30924591,30924632,30924669,30924704,30926229,30926343,30929457,30929500,30929539,30929576,30929616,30929698,30929756,30929789,30929931,30930021,30930047,30930101,30930137,30931881,30932113,30932642,30932730,30934873,30934910,30935053,30935130,30935170,30935211,30935250,30935280,30935329,30935360,30935391,30935455,30935491,30935528,30935562,30935593,30935749,30935819,30935931,30939005,30939157,30939194,30939222,30939258,30939337,30939378,30939413,30939461,30939646,30939790,30941351,30941496,30944413,30944497,30944531,30944614,30944686,30944718,30944756,30944797,30944834,30944948,30944976,30946646,30946802,30949962,30950003,30950041,30950069,30950104,30950147,30950184,3095023 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998175, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918290,30918319,30918366,30918394,30918428,30918477,30918515,30918556,30918582,30918633,30918668,30918704,30918748,30918780,30918822,30918855,30918895,30918940,30918971,30919006,30920611,30920693,30920827,30920872,30923908,30923950,30923990,30924022,30924059,30924089,30924139,30924166,30924209,30924252,30924280,30924323,30924363,30924400,30924429,30924470,30924513,30924548,30924594,30924634,30924666,30924703,30926226,30926337,30929430,30929460,30929501,30929536,30929581,30929611,30929655,30929689,30929744,30929792,30929818,30929868,30929905,30929935,30929977,30930015,30930054,30930094,30930133,30931762,30931872,30932117,30932634,30932733,30934872,30934906,30934940,30934971,30935019,30935056,30935099,30935129,30935174,30935204,30935248,30935286,30935318,30935359,30935392,30935443,30935485,30935524,30935553,30935604,30935664,30935750,30935812,30935938,30939006,30939039,30939080,30939116,30939158,30939190,30939231,30939264,30939307,30939345,30939386,30939416,30939463,30939488,30939533,30939577,30939605,3093964 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30998176, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30918291,30918323,30918359,30918429,30918473,30918555,30918592,30918634,30918663,30918702,30918777,30918815,30918900,30918982,30920610,30920688,30920836,30920873,30923909,30923942,30923983,30924025,30924063,30924094,30924133,30924173,30924211,30924250,30924284,30924324,30924366,30924401,30924436,30924517,30924546,30924592,30924628,30924670,30924708,30926232,30926345,30929420,30929455,30929495,30929538,30929578,30929617,30929650,30929699,30929822,30929943,30930017,30930048,30931759,30934870,30934909,30934984,30935012,30935202,30935251,30935288,30935327,30935401,30935453,30935488,30935516,30935595,30935670,30935746,30935936,30939009,30939071,30939112,30939151,30939189,30939230,30939266,30939305,30939338,30939382,30939422,30939527,30939613,30939643,30939687,30939800,30941359,30944496,30944532,30944616,30944655,30944684,30944725,30944755,30944795,30944830,30944870,30945022,30946654,30946797,30950038,30950109,30950149,30950190,30950229,30950262,30950329,30950375,30950415,30950445,30950486,30950524,30950563,3095220 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30998170,30998171,30998172,30998173,30998174,30998175,30998176?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-04-01' and date <= '2026-04-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1674,),), 'unwanted_material_monthly_percentage': ((0.7599222468274857,),), 'material_repartition': (('incineration', 1674),), 'material_dict': {'incineration': 1674}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 4, 1), 0.7249829059287605, 4), (datetime.date(2026, 4, 2), 0.7191173622328932, 1), (datetime.date(2026, 4, 3), 0.7799775656899308, 3), (datetime.date(2026, 4, 4), 0.7494981459342882, 3), (datetime.date(2026, 4, 5), 0.8363058786154853, 2), (datetime.date(2026, 4, 6), 0.8018980532552408, 1), (datetime.date(2026, 4, 7), 0.7720590324595733, 2), (datetime.date(2026, 4, 8), 0.7341913947678574, 3), (datetime.date(2026, 4, 9), 0.6974955114012599, 1), (datetime.date(2026, 4, 10), 0.7533074916486423, 4), (datetime.date(2026, 4, 11), 0.6892418768688457, 1), (datetime.date(2026, 4, 12), 0.8079890012447754, 4), (datetime.date(2026, 4, 13), 0.7736727587443476, 2), (datetime.date(2026, 4, 14), 0.784150661214115, 3), (datetime.date(2026, 4, 15), 0.7733877904086945, 2), (datetime.date(2026, 4, 16), 0.7327758488720243, 2), (datetime.date(2026, 4, 17), 0.7221468198949348, 3), (datetime.date(2026, 4, 18), 0.7853150000852306, 3), (datetime.date(2026, 4, 19), 0.8231311373387633, 1), (datetime.date(2026, 4, 20), 0.8210834777792858, 2), (datetime.date(2026, 4, 21), 0.7771839861108812, 3), (datetime.date(2026, 4, 22), 0.7593202519337041, 4), (datetime.date(2026, 4, 23), 0.7474576343985825, 3), (datetime.date(2026, 4, 24), 0.7097653169223415, 1), (datetime.date(2026, 4, 25), 0.7190580537790504, 2), (datetime.date(2026, 4, 26), 0.7465914039514471, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 4, 1), 0.7249829059287605, 4), (datetime.date(2026, 4, 2), 0.7191173622328932, 1), (datetime.date(2026, 4, 3), 0.7799775656899308, 3), (datetime.date(2026, 4, 4), 0.7494981459342882, 3), (datetime.date(2026, 4, 5), 0.8363058786154853, 2), (datetime.date(2026, 4, 6), 0.8018980532552408, 1), (datetime.date(2026, 4, 7), 0.7720590324595733, 2), (datetime.date(2026, 4, 8), 0.7341913947678574, 3), (datetime.date(2026, 4, 9), 0.6974955114012599, 1), (datetime.date(2026, 4, 10), 0.7533074916486423, 4), (datetime.date(2026, 4, 11), 0.6892418768688457, 1), (datetime.date(2026, 4, 12), 0.8079890012447754, 4), (datetime.date(2026, 4, 13), 0.7736727587443476, 2), (datetime.date(2026, 4, 14), 0.784150661214115, 3), (datetime.date(2026, 4, 15), 0.7733877904086945, 2), (datetime.date(2026, 4, 16), 0.7327758488720243, 2), (datetime.date(2026, 4, 17), 0.7221468198949348, 3), (datetime.date(2026, 4, 18), 0.7853150000852306, 3), (datetime.date(2026, 4, 19), 0.8231311373387633, 1), (datetime.date(2026, 4, 20), 0.8210834777792858, 2), (datetime.date(2026, 4, 21), 0.7771839861108812, 3), (datetime.date(2026, 4, 22), 0.7593202519337041, 4), (datetime.date(2026, 4, 23), 0.7474576343985825, 3), (datetime.date(2026, 4, 24), 0.7097653169223415, 1), (datetime.date(2026, 4, 25), 0.7190580537790504, 2), (datetime.date(2026, 4, 26), 0.7465914039514471, 1))}, 'quality_array': [['-7.621831900435656', '01042026'], ['-7.846278498434913', '02042026'], ['-7.944135256376369', '03042026'], ['-7.794487535269842', '04042026'], ['-7.692964219063319', '05042026'], ['-7.452075642125215', '06042026'], ['-7.161704309135991', '07042026'], ['-7.5649961519335935', '08042026'], ['-7.815914003999868', '09042026'], ['-8.293979085858677', '10042026'], ['-7.9771029282309165', '11042026'], ['-7.8326841377843595', '12042026'], ['-7.508953777841921', '13042026'], ['-7.59003189376534', '14042026'], ['-7.529630711995469', '15042026'], ['-7.545864589056825', '16042026'], ['-7.403966338375979', '17042026'], ['-7.129474080563234', '18042026'], ['-7.352676823094494', '19042026'], ['-7.20094903193259', '20042026'], ['-7.262948832952815', '21042026'], ['-7.4998295496540335', '22042026'], ['-7.431170760973426', '23042026'], ['-7.795984174995072', '24042026'], ['-7.710687253171737', '25042026'], ['-7.831876306291994', '26042026']], 'number_of_batch': ((575,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01793031414406819, 'nb_photo': 20084, 'list_port_cont': '30918278,30918312,30918361,30918398,30918433,30918479,30918507,30918540,30918579,30918620,30918655,30918698,30918742,30918787,30918807,30918860,30918885,30918931,30918968,30919012,30920608,30920686,30920831,30920867,30923900,30923951,30923978,30924012,30924057,30924097,30924128,30924177,30924198,30924236,30924285,30924320,30924353,30924405,30924443,30924474,30924506,30924542,30924581,30924633,30924654,30924705,30926218,30926346,30929425,30929452,30929499,30929541,30929575,30929614,30929643,30929697,30929753,30929781,30929830,30929865,30929890,30929939,30929970,30930020,30930056,30930086,30930122,30931766,30931884,30932109,30932637,30932735,30934858,30934894,30934946,30934976,30935013,30935060,30935084,30935127,30935173,30935208,30935243,30935287,30935326,30935356,30935405,30935445,30935479,30935520,30935563,30935587,30935674,30935736,30935811,30935925,30938993,30939033,30939067,30939107,30939144,30939191,30939220,30939257,30939298,30939339,30939380,30939415,30939446,30939491,30939524,30939574,30939607,3093964', 'assoc_port': '30918204:30918312,30918205:30918278,30918206:30918361,30918207:30918398,30918208:30918433,30918209:30918479,30918210:30918507,30918212:30918540,30918215:30918579,30918218:30920686,30918221:30920867,30918224:30918620,30918227:30918655,30918230:30918698,30918232:30918742,30918235:30918787,30918238:30918807,30918241:30918860,30918244:30918885,30918247:30918931,30918250:30919012,30918253:30918968,30918613:30920608,30918925:30920831,30923830:30923900,30923831:30923951,30923832:30924012,30923833:30923978,30923834:30924057,30923835:30924097,30923836:30924128,30923838:30924177,30923840:30924198,30923843:30924236,30923846:30924285,30923849:30924320,30923852:30924353,30923855:30924405,30923858:30924443,30923861:30924474,30923864:30924506,30923867:30924581,30923870:30924542,30923873:30924633,30923876:30924654,30923879:30924705,30924273:30926218,30924728:30926346,30929365:30929452,30929366:30929425,30929367:30929499,30929368:30929541,30929369:30929575,30929370:30929614,30929371:30929643,30929373:30929697,30929375:3092975', 'assoc_mat': '30918204:autre:4230:30918312,30918205:autre:4230:30918278,30918206:autre:4230:30918361,30918207:autre:4230:30918398,30918208:autre:4230:30918433,30918209:autre:4230:30918479,30918210:autre:4230:30918507,30918212:autre:4230:30918540,30918215:autre:4230:30918579,30918218:autre:4230:30920686,30918221:autre:4230:30920867,30918224:autre:4230:30918620,30918227:autre:4230:30918655,30918230:autre:4230:30918698,30918232:autre:4230:30918742,30918235:autre:4230:30918787,30918238:autre:4230:30918807,30918241:autre:4230:30918860,30918244:autre:4230:30918885,30918247:autre:4230:30918931,30918250:autre:4230:30919012,30918253:autre:4230:30918968,30918613:autre:4230:30920608,30918925:autre:4230:30920831,30923830:autre:4230:30923900,30923831:autre:4230:30923951,30923832:autre:4230:30924012,30923833:autre:4230:30923978,30923834:autre:4230:30924057,30923835:autre:4230:30924097,30923836:autre:4230:30924128,30923838:autre:4230:30924177,30923840:autre:4230:30924198,30923843:autre:4230:30924236,30923846:autre:4230:30924285,30923849:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03660388262130405, 'nb_photo': 65883, 'list_port_cont': '30918287,30918329,30918363,30918403,30918441,30918476,30918509,30918557,30918593,30918623,30918661,30918706,30918743,30918783,30918824,30918861,30918897,30918934,30918976,30919016,30920609,30920695,30920830,30920874,30923903,30923945,30923986,30924015,30924054,30924101,30924135,30924165,30924205,30924251,30924288,30924330,30924362,30924395,30924444,30924481,30924518,30924557,30924587,30924627,30924671,30924695,30926223,30926338,30929427,30929453,30929489,30929535,30929582,30929613,30929646,30929692,30929752,30929795,30929831,30929854,30929904,30929940,30929979,30930018,30930051,30930098,30930135,30931767,30931885,30932111,30932641,30932729,30934869,30934907,30934933,30934985,30935020,30935057,30935100,30935128,30935176,30935206,30935238,30935284,30935330,30935363,30935399,30935451,30935493,30935529,30935555,30935600,30935669,30935742,30935822,30935937,30939008,30939038,30939077,30939117,30939152,30939184,30939232,30939268,30939300,30939331,30939375,30939421,30939457,30939496,30939536,30939562,30939608,3093965', 'assoc_port': '30918204:30918329,30918205:30918287,30918206:30918363,30918207:30918403,30918208:30918441,30918209:30918476,30918210:30918509,30918212:30918557,30918215:30918593,30918218:30920695,30918221:30920874,30918224:30918623,30918227:30918661,30918230:30918706,30918232:30918743,30918235:30918783,30918238:30918824,30918241:30918861,30918244:30918897,30918247:30918934,30918250:30919016,30918253:30918976,30918613:30920609,30918925:30920830,30923830:30923903,30923831:30923945,30923832:30924015,30923833:30923986,30923834:30924054,30923835:30924101,30923836:30924135,30923838:30924165,30923840:30924205,30923843:30924251,30923846:30924288,30923849:30924330,30923852:30924362,30923855:30924395,30923858:30924444,30923861:30924481,30923864:30924518,30923867:30924587,30923870:30924557,30923873:30924627,30923876:30924671,30923879:30924695,30924273:30926223,30924728:30926338,30929365:30929453,30929366:30929427,30929367:30929489,30929368:30929535,30929369:30929582,30929370:30929613,30929371:30929646,30929373:30929692,30929375:3092975', 'assoc_mat': '30918204:carton:4230:30918329,30918205:carton:4230:30918287,30918206:carton:4230:30918363,30918207:carton:4230:30918403,30918208:carton:4230:30918441,30918209:carton:4230:30918476,30918210:carton:4230:30918509,30918212:carton:4230:30918557,30918215:carton:4230:30918593,30918218:carton:4230:30920695,30918221:carton:4230:30920874,30918224:carton:4230:30918623,30918227:carton:4230:30918661,30918230:carton:4230:30918706,30918232:carton:4230:30918743,30918235:carton:4230:30918783,30918238:carton:4230:30918824,30918241:carton:4230:30918861,30918244:carton:4230:30918897,30918247:carton:4230:30918934,30918250:carton:4230:30919016,30918253:carton:4230:30918976,30918613:carton:4230:30920609,30918925:carton:4230:30920830,30923830:carton:4230:30923903,30923831:carton:4230:30923945,30923832:carton:4230:30924015,30923833:carton:4230:30923986,30923834:carton:4230:30924054,30923835:carton:4230:30924101,30923836:carton:4230:30924135,30923838:carton:4230:30924165,30923840:carton:4230:30924205,30923843:carton:4230:30924251,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001138341142811731, 'nb_photo': 1596, 'list_port_cont': '30918281,30918327,30918353,30918474,30918503,30918552,30918583,30918632,30918660,30918696,30918784,30918816,30918847,30918896,30918941,30919018,30920603,30920682,30920839,30920870,30923946,30924019,30924048,30924099,30924125,30924175,30924202,30924240,30924292,30924327,30924369,30924404,30924427,30924479,30924509,30924541,30924579,30924661,30924702,30926231,30926339,30929417,30929464,30929502,30929531,30929572,30929606,30929654,30929691,30929745,30929784,30929829,30929867,30929902,30929942,30929971,30930012,30930041,30930087,30930120,30931758,30931878,30932115,30932625,30932734,30934862,30934978,30935010,30935049,30935085,30935133,30935209,30935249,30935290,30935319,30935355,30935394,30935454,30935481,30935525,30935561,30935601,30935667,30935734,30935926,30939030,30939149,30939193,30939291,30939342,30939376,30939454,30939486,30939525,30939569,30939635,30939710,30939795,30941361,30941503,30944418,30944446,30944495,30944536,30944602,30944647,30944680,30944715,30944751,30944787,30944831,30944875,30944942,3094498', 'assoc_port': '30918204:30918327,30918205:30918281,30918206:30918353,30918209:30918474,30918210:30918503,30918212:30918552,30918215:30918583,30918218:30920682,30918221:30920870,30918224:30918632,30918227:30918660,30918230:30918696,30918235:30918784,30918238:30918816,30918241:30918847,30918244:30918896,30918247:30918941,30918250:30919018,30918613:30920603,30918925:30920839,30923831:30923946,30923832:30924019,30923834:30924048,30923835:30924099,30923836:30924125,30923838:30924175,30923840:30924202,30923843:30924240,30923846:30924292,30923849:30924327,30923852:30924369,30923855:30924404,30923858:30924427,30923861:30924479,30923864:30924509,30923867:30924579,30923870:30924541,30923876:30924661,30923879:30924702,30924273:30926231,30924728:30926339,30929365:30929464,30929366:30929417,30929367:30929502,30929368:30929531,30929369:30929572,30929370:30929606,30929371:30929654,30929373:30929691,30929375:30929745,30929376:30929902,30929378:30929784,30929380:30932734,30929382:30929829,30929384:30929867,30929387:30929942,30929388:3092997', 'assoc_mat': '30918204:metal:4230:30918327,30918205:metal:4230:30918281,30918206:metal:4230:30918353,30918209:metal:4230:30918474,30918210:metal:4230:30918503,30918212:metal:4230:30918552,30918215:metal:4230:30918583,30918218:metal:4230:30920682,30918221:metal:4230:30920870,30918224:metal:4230:30918632,30918227:metal:4230:30918660,30918230:metal:4230:30918696,30918235:metal:4230:30918784,30918238:metal:4230:30918816,30918241:metal:4230:30918847,30918244:metal:4230:30918896,30918247:metal:4230:30918941,30918250:metal:4230:30919018,30918613:metal:4230:30920603,30918925:metal:4230:30920839,30923831:metal:4230:30923946,30923832:metal:4230:30924019,30923834:metal:4230:30924048,30923835:metal:4230:30924099,30923836:metal:4230:30924125,30923838:metal:4230:30924175,30923840:metal:4230:30924202,30923843:metal:4230:30924240,30923846:metal:4230:30924292,30923849:metal:4230:30924327,30923852:metal:4230:30924369,30923855:metal:4230:30924404,30923858:metal:4230:30924427,30923861:metal:4230:30924479,30923864:metal:4230:30924509,30923867:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.181623777380301, 'nb_photo': 363568, 'list_port_cont': '30918279,30918325,30918356,30918401,30918436,30918478,30918516,30918550,30918588,30918630,30918672,30918708,30918747,30918781,30918823,30918859,30918898,30918935,30918975,30919015,30920606,30920690,30920837,30920878,30923915,30923944,30923989,30924027,30924062,30924103,30924130,30924176,30924213,30924248,30924294,30924329,30924367,30924403,30924438,30924469,30924512,30924558,30924578,30924629,30924667,30924707,30926228,30926342,30929421,30929463,30929496,30929528,30929573,30929609,30929656,30929694,30929751,30929790,30929826,30929870,30929901,30929938,30929981,30930016,30930055,30930095,30930128,30931769,30931879,30932107,30932630,30932723,30934871,30934905,30934942,30934982,30935022,30935047,30935097,30935123,30935175,30935210,30935247,30935289,30935331,30935367,30935402,30935447,30935490,30935517,30935564,30935598,30935676,30935743,30935823,30935932,30939003,30939034,30939082,30939110,30939156,30939192,30939227,30939265,30939303,30939341,30939384,30939419,30939460,30939501,30939530,30939570,30939606,3093964', 'assoc_port': '30918204:30918325,30918205:30918279,30918206:30918356,30918207:30918401,30918208:30918436,30918209:30918478,30918210:30918516,30918212:30918550,30918215:30918588,30918218:30920690,30918221:30920878,30918224:30918630,30918227:30918672,30918230:30918708,30918232:30918747,30918235:30918781,30918238:30918823,30918241:30918859,30918244:30918898,30918247:30918935,30918250:30919015,30918253:30918975,30918613:30920606,30918925:30920837,30923830:30923915,30923831:30923944,30923832:30924027,30923833:30923989,30923834:30924062,30923835:30924103,30923836:30924130,30923838:30924176,30923840:30924213,30923843:30924248,30923846:30924294,30923849:30924329,30923852:30924367,30923855:30924403,30923858:30924438,30923861:30924469,30923864:30924512,30923867:30924578,30923870:30924558,30923873:30924629,30923876:30924667,30923879:30924707,30924273:30926228,30924728:30926342,30929365:30929463,30929366:30929421,30929367:30929496,30929368:30929528,30929369:30929573,30929370:30929609,30929371:30929656,30929373:30929694,30929375:3092975', 'assoc_mat': '30918204:papier:4230:30918325,30918205:papier:4230:30918279,30918206:papier:4230:30918356,30918207:papier:4230:30918401,30918208:papier:4230:30918436,30918209:papier:4230:30918478,30918210:papier:4230:30918516,30918212:papier:4230:30918550,30918215:papier:4230:30918588,30918218:papier:4230:30920690,30918221:papier:4230:30920878,30918224:papier:4230:30918630,30918227:papier:4230:30918672,30918230:papier:4230:30918708,30918232:papier:4230:30918747,30918235:papier:4230:30918781,30918238:papier:4230:30918823,30918241:papier:4230:30918859,30918244:papier:4230:30918898,30918247:papier:4230:30918935,30918250:papier:4230:30919015,30918253:papier:4230:30918975,30918613:papier:4230:30920606,30918925:papier:4230:30920837,30923830:papier:4230:30923915,30923831:papier:4230:30923944,30923832:papier:4230:30924027,30923833:papier:4230:30923989,30923834:papier:4230:30924062,30923835:papier:4230:30924103,30923836:papier:4230:30924130,30923838:papier:4230:30924176,30923840:papier:4230:30924213,30923843:papier:4230:30924248,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038538430261352698, 'nb_photo': 1978, 'list_port_cont': '30918282,30918367,30918438,30918469,30918514,30918547,30918591,30918628,30918669,30918703,30918738,30918788,30918819,30918862,30918901,30918936,30918981,30919017,30920605,30920692,30920834,30920875,30923916,30923947,30924026,30924093,30924137,30924174,30924214,30924243,30924291,30924333,30924364,30924390,30924439,30924477,30924516,30924554,30924591,30924632,30924669,30924704,30926229,30926343,30929457,30929500,30929539,30929576,30929616,30929698,30929756,30929789,30929931,30930021,30930047,30930101,30930137,30931881,30932113,30932642,30932730,30934873,30934910,30935053,30935130,30935170,30935211,30935250,30935280,30935329,30935360,30935391,30935455,30935491,30935528,30935562,30935593,30935749,30935819,30935931,30939005,30939157,30939194,30939222,30939258,30939337,30939378,30939413,30939461,30939646,30939790,30941351,30941496,30944413,30944497,30944531,30944614,30944686,30944718,30944756,30944797,30944834,30944948,30944976,30946646,30946802,30949962,30950003,30950041,30950069,30950104,30950147,30950184,3095023', 'assoc_port': '30918205:30918282,30918206:30918367,30918208:30918438,30918209:30918469,30918210:30918514,30918212:30918547,30918215:30918591,30918218:30920692,30918221:30920875,30918224:30918628,30918227:30918669,30918230:30918703,30918232:30918738,30918235:30918788,30918238:30918819,30918241:30918862,30918244:30918901,30918247:30918936,30918250:30919017,30918253:30918981,30918613:30920605,30918925:30920834,30923830:30923916,30923831:30923947,30923832:30924026,30923835:30924093,30923836:30924137,30923838:30924174,30923840:30924214,30923843:30924243,30923846:30924291,30923849:30924333,30923852:30924364,30923855:30924390,30923858:30924439,30923861:30924477,30923864:30924516,30923867:30924591,30923870:30924554,30923873:30924632,30923876:30924669,30923879:30924704,30924273:30926229,30924728:30926343,30929365:30929457,30929367:30929500,30929368:30929539,30929369:30929576,30929370:30929616,30929373:30929698,30929375:30929756,30929378:30929789,30929380:30932730,30929387:30929931,30929390:30932642,30929393:30931881,30929394:3093002', 'assoc_mat': '30918205:pehd:4230:30918282,30918206:pehd:4230:30918367,30918208:pehd:4230:30918438,30918209:pehd:4230:30918469,30918210:pehd:4230:30918514,30918212:pehd:4230:30918547,30918215:pehd:4230:30918591,30918218:pehd:4230:30920692,30918221:pehd:4230:30920875,30918224:pehd:4230:30918628,30918227:pehd:4230:30918669,30918230:pehd:4230:30918703,30918232:pehd:4230:30918738,30918235:pehd:4230:30918788,30918238:pehd:4230:30918819,30918241:pehd:4230:30918862,30918244:pehd:4230:30918901,30918247:pehd:4230:30918936,30918250:pehd:4230:30919017,30918253:pehd:4230:30918981,30918613:pehd:4230:30920605,30918925:pehd:4230:30920834,30923830:pehd:4230:30923916,30923831:pehd:4230:30923947,30923832:pehd:4230:30924026,30923835:pehd:4230:30924093,30923836:pehd:4230:30924137,30923838:pehd:4230:30924174,30923840:pehd:4230:30924214,30923843:pehd:4230:30924243,30923846:pehd:4230:30924291,30923849:pehd:4230:30924333,30923852:pehd:4230:30924364,30923855:pehd:4230:30924390,30923858:pehd:4230:30924439,30923861:pehd:4230:30924477,30923864:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017933922975085236, 'nb_photo': 26738, 'list_port_cont': '30918290,30918319,30918366,30918394,30918428,30918477,30918515,30918556,30918582,30918633,30918668,30918704,30918748,30918780,30918822,30918855,30918895,30918940,30918971,30919006,30920611,30920693,30920827,30920872,30923908,30923950,30923990,30924022,30924059,30924089,30924139,30924166,30924209,30924252,30924280,30924323,30924363,30924400,30924429,30924470,30924513,30924548,30924594,30924634,30924666,30924703,30926226,30926337,30929430,30929460,30929501,30929536,30929581,30929611,30929655,30929689,30929744,30929792,30929818,30929868,30929905,30929935,30929977,30930015,30930054,30930094,30930133,30931762,30931872,30932117,30932634,30932733,30934872,30934906,30934940,30934971,30935019,30935056,30935099,30935129,30935174,30935204,30935248,30935286,30935318,30935359,30935392,30935443,30935485,30935524,30935553,30935604,30935664,30935750,30935812,30935938,30939006,30939039,30939080,30939116,30939158,30939190,30939231,30939264,30939307,30939345,30939386,30939416,30939463,30939488,30939533,30939577,30939605,3093964', 'assoc_port': '30918204:30918319,30918205:30918290,30918206:30918366,30918207:30918394,30918208:30918428,30918209:30918477,30918210:30918515,30918212:30918556,30918215:30918582,30918218:30920693,30918221:30920872,30918224:30918633,30918227:30918668,30918230:30918704,30918232:30918748,30918235:30918780,30918238:30918822,30918241:30918855,30918244:30918895,30918247:30918940,30918250:30919006,30918253:30918971,30918613:30920611,30918925:30920827,30923830:30923908,30923831:30923950,30923832:30924022,30923833:30923990,30923834:30924059,30923835:30924089,30923836:30924139,30923838:30924166,30923840:30924209,30923843:30924252,30923846:30924280,30923849:30924323,30923852:30924363,30923855:30924400,30923858:30924429,30923861:30924470,30923864:30924513,30923867:30924594,30923870:30924548,30923873:30924634,30923876:30924666,30923879:30924703,30924273:30926226,30924728:30926337,30929365:30929460,30929366:30929430,30929367:30929501,30929368:30929536,30929369:30929581,30929370:30929611,30929371:30929655,30929373:30929689,30929375:3092974', 'assoc_mat': '30918204:pet_clair:4230:30918319,30918205:pet_clair:4230:30918290,30918206:pet_clair:4230:30918366,30918207:pet_clair:4230:30918394,30918208:pet_clair:4230:30918428,30918209:pet_clair:4230:30918477,30918210:pet_clair:4230:30918515,30918212:pet_clair:4230:30918556,30918215:pet_clair:4230:30918582,30918218:pet_clair:4230:30920693,30918221:pet_clair:4230:30920872,30918224:pet_clair:4230:30918633,30918227:pet_clair:4230:30918668,30918230:pet_clair:4230:30918704,30918232:pet_clair:4230:30918748,30918235:pet_clair:4230:30918780,30918238:pet_clair:4230:30918822,30918241:pet_clair:4230:30918855,30918244:pet_clair:4230:30918895,30918247:pet_clair:4230:30918940,30918250:pet_clair:4230:30919006,30918253:pet_clair:4230:30918971,30918613:pet_clair:4230:30920611,30918925:pet_clair:4230:30920827,30923830:pet_clair:4230:30923908,30923831:pet_clair:4230:30923950,30923832:pet_clair:4230:30924022,30923833:pet_clair:4230:30923990,30923834:pet_clair:4230:30924059,30923835:pet_clair:4230:30924089,30923836:pet_clair:4230:30924139,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028882596028359836, 'nb_photo': 1039, 'list_port_cont': '30918291,30918323,30918359,30918429,30918473,30918555,30918592,30918634,30918663,30918702,30918777,30918815,30918900,30918982,30920610,30920688,30920836,30920873,30923909,30923942,30923983,30924025,30924063,30924094,30924133,30924173,30924211,30924250,30924284,30924324,30924366,30924401,30924436,30924517,30924546,30924592,30924628,30924670,30924708,30926232,30926345,30929420,30929455,30929495,30929538,30929578,30929617,30929650,30929699,30929822,30929943,30930017,30930048,30931759,30934870,30934909,30934984,30935012,30935202,30935251,30935288,30935327,30935401,30935453,30935488,30935516,30935595,30935670,30935746,30935936,30939009,30939071,30939112,30939151,30939189,30939230,30939266,30939305,30939338,30939382,30939422,30939527,30939613,30939643,30939687,30939800,30941359,30944496,30944532,30944616,30944655,30944684,30944725,30944755,30944795,30944830,30944870,30945022,30946654,30946797,30950038,30950109,30950149,30950190,30950229,30950262,30950329,30950375,30950415,30950445,30950486,30950524,30950563,3095220', 'assoc_port': '30918204:30918323,30918205:30918291,30918206:30918359,30918208:30918429,30918209:30918473,30918212:30918555,30918215:30918592,30918218:30920688,30918221:30920873,30918224:30918634,30918227:30918663,30918230:30918702,30918235:30918777,30918238:30918815,30918244:30918900,30918253:30918982,30918613:30920610,30918925:30920836,30923830:30923909,30923831:30923942,30923832:30924025,30923833:30923983,30923834:30924063,30923835:30924094,30923836:30924133,30923838:30924173,30923840:30924211,30923843:30924250,30923846:30924284,30923849:30924324,30923852:30924366,30923855:30924401,30923858:30924436,30923864:30924517,30923867:30924592,30923870:30924546,30923873:30924628,30923876:30924670,30923879:30924708,30924273:30926232,30924728:30926345,30929365:30929455,30929366:30929420,30929367:30929495,30929368:30929538,30929369:30929578,30929370:30929617,30929371:30929650,30929373:30929699,30929382:30929822,30929387:30929943,30929394:30930017,30929396:30930048,30930076:30931759,30934754:30934870,30934756:30934909,30934758:3093498', 'assoc_mat': '30918204:pet_fonce:4230:30918323,30918205:pet_fonce:4230:30918291,30918206:pet_fonce:4230:30918359,30918208:pet_fonce:4230:30918429,30918209:pet_fonce:4230:30918473,30918212:pet_fonce:4230:30918555,30918215:pet_fonce:4230:30918592,30918218:pet_fonce:4230:30920688,30918221:pet_fonce:4230:30920873,30918224:pet_fonce:4230:30918634,30918227:pet_fonce:4230:30918663,30918230:pet_fonce:4230:30918702,30918235:pet_fonce:4230:30918777,30918238:pet_fonce:4230:30918815,30918244:pet_fonce:4230:30918900,30918253:pet_fonce:4230:30918982,30918613:pet_fonce:4230:30920610,30918925:pet_fonce:4230:30920836,30923830:pet_fonce:4230:30923909,30923831:pet_fonce:4230:30923942,30923832:pet_fonce:4230:30924025,30923833:pet_fonce:4230:30923983,30923834:pet_fonce:4230:30924063,30923835:pet_fonce:4230:30924094,30923836:pet_fonce:4230:30924133,30923838:pet_fonce:4230:30924173,30923840:pet_fonce:4230:30924211,30923843:pet_fonce:4230:30924250,30923846:pet_fonce:4230:30924284,30923849:pet_fonce:4230:30924324,30923852:pet_fonce:4230:30924366,3'}), 'main_stat': {'nb_photos': 1674}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30998170,30998171,30998172,30998173,30998174,30998175,30998176?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-04', 0.7599222468274857),)]} 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': ((1674,),), 'unwanted_material_monthly_percentage': ((0.7599222468274857,),), 'material_repartition': (('incineration', 1674),), 'material_dict': {'incineration': 1674}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 4, 1), 0.7249829059287605, 4), (datetime.date(2026, 4, 2), 0.7191173622328932, 1), (datetime.date(2026, 4, 3), 0.7799775656899308, 3), (datetime.date(2026, 4, 4), 0.7494981459342882, 3), (datetime.date(2026, 4, 5), 0.8363058786154853, 2), (datetime.date(2026, 4, 6), 0.8018980532552408, 1), (datetime.date(2026, 4, 7), 0.7720590324595733, 2), (datetime.date(2026, 4, 8), 0.7341913947678574, 3), (datetime.date(2026, 4, 9), 0.6974955114012599, 1), (datetime.date(2026, 4, 10), 0.7533074916486423, 4), (datetime.date(2026, 4, 11), 0.6892418768688457, 1), (datetime.date(2026, 4, 12), 0.8079890012447754, 4), (datetime.date(2026, 4, 13), 0.7736727587443476, 2), (datetime.date(2026, 4, 14), 0.784150661214115, 3), (datetime.date(2026, 4, 15), 0.7733877904086945, 2), (datetime.date(2026, 4, 16), 0.7327758488720243, 2), (datetime.date(2026, 4, 17), 0.7221468198949348, 3), (datetime.date(2026, 4, 18), 0.7853150000852306, 3), (datetime.date(2026, 4, 19), 0.8231311373387633, 1), (datetime.date(2026, 4, 20), 0.8210834777792858, 2), (datetime.date(2026, 4, 21), 0.7771839861108812, 3), (datetime.date(2026, 4, 22), 0.7593202519337041, 4), (datetime.date(2026, 4, 23), 0.7474576343985825, 3), (datetime.date(2026, 4, 24), 0.7097653169223415, 1), (datetime.date(2026, 4, 25), 0.7190580537790504, 2), (datetime.date(2026, 4, 26), 0.7465914039514471, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 4, 1), 0.7249829059287605, 4), (datetime.date(2026, 4, 2), 0.7191173622328932, 1), (datetime.date(2026, 4, 3), 0.7799775656899308, 3), (datetime.date(2026, 4, 4), 0.7494981459342882, 3), (datetime.date(2026, 4, 5), 0.8363058786154853, 2), (datetime.date(2026, 4, 6), 0.8018980532552408, 1), (datetime.date(2026, 4, 7), 0.7720590324595733, 2), (datetime.date(2026, 4, 8), 0.7341913947678574, 3), (datetime.date(2026, 4, 9), 0.6974955114012599, 1), (datetime.date(2026, 4, 10), 0.7533074916486423, 4), (datetime.date(2026, 4, 11), 0.6892418768688457, 1), (datetime.date(2026, 4, 12), 0.8079890012447754, 4), (datetime.date(2026, 4, 13), 0.7736727587443476, 2), (datetime.date(2026, 4, 14), 0.784150661214115, 3), (datetime.date(2026, 4, 15), 0.7733877904086945, 2), (datetime.date(2026, 4, 16), 0.7327758488720243, 2), (datetime.date(2026, 4, 17), 0.7221468198949348, 3), (datetime.date(2026, 4, 18), 0.7853150000852306, 3), (datetime.date(2026, 4, 19), 0.8231311373387633, 1), (datetime.date(2026, 4, 20), 0.8210834777792858, 2), (datetime.date(2026, 4, 21), 0.7771839861108812, 3), (datetime.date(2026, 4, 22), 0.7593202519337041, 4), (datetime.date(2026, 4, 23), 0.7474576343985825, 3), (datetime.date(2026, 4, 24), 0.7097653169223415, 1), (datetime.date(2026, 4, 25), 0.7190580537790504, 2), (datetime.date(2026, 4, 26), 0.7465914039514471, 1))}, 'quality_array': [['-7.621831900435656', '01042026'], ['-7.846278498434913', '02042026'], ['-7.944135256376369', '03042026'], ['-7.794487535269842', '04042026'], ['-7.692964219063319', '05042026'], ['-7.452075642125215', '06042026'], ['-7.161704309135991', '07042026'], ['-7.5649961519335935', '08042026'], ['-7.815914003999868', '09042026'], ['-8.293979085858677', '10042026'], ['-7.9771029282309165', '11042026'], ['-7.8326841377843595', '12042026'], ['-7.508953777841921', '13042026'], ['-7.59003189376534', '14042026'], ['-7.529630711995469', '15042026'], ['-7.545864589056825', '16042026'], ['-7.403966338375979', '17042026'], ['-7.129474080563234', '18042026'], ['-7.352676823094494', '19042026'], ['-7.20094903193259', '20042026'], ['-7.262948832952815', '21042026'], ['-7.4998295496540335', '22042026'], ['-7.431170760973426', '23042026'], ['-7.795984174995072', '24042026'], ['-7.710687253171737', '25042026'], ['-7.831876306291994', '26042026']], 'number_of_batch': ((575,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01793031414406819, 'nb_photo': 20084, 'list_port_cont': '30918278,30918312,30918361,30918398,30918433,30918479,30918507,30918540,30918579,30918620,30918655,30918698,30918742,30918787,30918807,30918860,30918885,30918931,30918968,30919012,30920608,30920686,30920831,30920867,30923900,30923951,30923978,30924012,30924057,30924097,30924128,30924177,30924198,30924236,30924285,30924320,30924353,30924405,30924443,30924474,30924506,30924542,30924581,30924633,30924654,30924705,30926218,30926346,30929425,30929452,30929499,30929541,30929575,30929614,30929643,30929697,30929753,30929781,30929830,30929865,30929890,30929939,30929970,30930020,30930056,30930086,30930122,30931766,30931884,30932109,30932637,30932735,30934858,30934894,30934946,30934976,30935013,30935060,30935084,30935127,30935173,30935208,30935243,30935287,30935326,30935356,30935405,30935445,30935479,30935520,30935563,30935587,30935674,30935736,30935811,30935925,30938993,30939033,30939067,30939107,30939144,30939191,30939220,30939257,30939298,30939339,30939380,30939415,30939446,30939491,30939524,30939574,30939607,3093964', 'assoc_port': '30918204:30918312,30918205:30918278,30918206:30918361,30918207:30918398,30918208:30918433,30918209:30918479,30918210:30918507,30918212:30918540,30918215:30918579,30918218:30920686,30918221:30920867,30918224:30918620,30918227:30918655,30918230:30918698,30918232:30918742,30918235:30918787,30918238:30918807,30918241:30918860,30918244:30918885,30918247:30918931,30918250:30919012,30918253:30918968,30918613:30920608,30918925:30920831,30923830:30923900,30923831:30923951,30923832:30924012,30923833:30923978,30923834:30924057,30923835:30924097,30923836:30924128,30923838:30924177,30923840:30924198,30923843:30924236,30923846:30924285,30923849:30924320,30923852:30924353,30923855:30924405,30923858:30924443,30923861:30924474,30923864:30924506,30923867:30924581,30923870:30924542,30923873:30924633,30923876:30924654,30923879:30924705,30924273:30926218,30924728:30926346,30929365:30929452,30929366:30929425,30929367:30929499,30929368:30929541,30929369:30929575,30929370:30929614,30929371:30929643,30929373:30929697,30929375:3092975', 'assoc_mat': '30918204:autre:4230:30918312,30918205:autre:4230:30918278,30918206:autre:4230:30918361,30918207:autre:4230:30918398,30918208:autre:4230:30918433,30918209:autre:4230:30918479,30918210:autre:4230:30918507,30918212:autre:4230:30918540,30918215:autre:4230:30918579,30918218:autre:4230:30920686,30918221:autre:4230:30920867,30918224:autre:4230:30918620,30918227:autre:4230:30918655,30918230:autre:4230:30918698,30918232:autre:4230:30918742,30918235:autre:4230:30918787,30918238:autre:4230:30918807,30918241:autre:4230:30918860,30918244:autre:4230:30918885,30918247:autre:4230:30918931,30918250:autre:4230:30919012,30918253:autre:4230:30918968,30918613:autre:4230:30920608,30918925:autre:4230:30920831,30923830:autre:4230:30923900,30923831:autre:4230:30923951,30923832:autre:4230:30924012,30923833:autre:4230:30923978,30923834:autre:4230:30924057,30923835:autre:4230:30924097,30923836:autre:4230:30924128,30923838:autre:4230:30924177,30923840:autre:4230:30924198,30923843:autre:4230:30924236,30923846:autre:4230:30924285,30923849:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03660388262130405, 'nb_photo': 65883, 'list_port_cont': '30918287,30918329,30918363,30918403,30918441,30918476,30918509,30918557,30918593,30918623,30918661,30918706,30918743,30918783,30918824,30918861,30918897,30918934,30918976,30919016,30920609,30920695,30920830,30920874,30923903,30923945,30923986,30924015,30924054,30924101,30924135,30924165,30924205,30924251,30924288,30924330,30924362,30924395,30924444,30924481,30924518,30924557,30924587,30924627,30924671,30924695,30926223,30926338,30929427,30929453,30929489,30929535,30929582,30929613,30929646,30929692,30929752,30929795,30929831,30929854,30929904,30929940,30929979,30930018,30930051,30930098,30930135,30931767,30931885,30932111,30932641,30932729,30934869,30934907,30934933,30934985,30935020,30935057,30935100,30935128,30935176,30935206,30935238,30935284,30935330,30935363,30935399,30935451,30935493,30935529,30935555,30935600,30935669,30935742,30935822,30935937,30939008,30939038,30939077,30939117,30939152,30939184,30939232,30939268,30939300,30939331,30939375,30939421,30939457,30939496,30939536,30939562,30939608,3093965', 'assoc_port': '30918204:30918329,30918205:30918287,30918206:30918363,30918207:30918403,30918208:30918441,30918209:30918476,30918210:30918509,30918212:30918557,30918215:30918593,30918218:30920695,30918221:30920874,30918224:30918623,30918227:30918661,30918230:30918706,30918232:30918743,30918235:30918783,30918238:30918824,30918241:30918861,30918244:30918897,30918247:30918934,30918250:30919016,30918253:30918976,30918613:30920609,30918925:30920830,30923830:30923903,30923831:30923945,30923832:30924015,30923833:30923986,30923834:30924054,30923835:30924101,30923836:30924135,30923838:30924165,30923840:30924205,30923843:30924251,30923846:30924288,30923849:30924330,30923852:30924362,30923855:30924395,30923858:30924444,30923861:30924481,30923864:30924518,30923867:30924587,30923870:30924557,30923873:30924627,30923876:30924671,30923879:30924695,30924273:30926223,30924728:30926338,30929365:30929453,30929366:30929427,30929367:30929489,30929368:30929535,30929369:30929582,30929370:30929613,30929371:30929646,30929373:30929692,30929375:3092975', 'assoc_mat': '30918204:carton:4230:30918329,30918205:carton:4230:30918287,30918206:carton:4230:30918363,30918207:carton:4230:30918403,30918208:carton:4230:30918441,30918209:carton:4230:30918476,30918210:carton:4230:30918509,30918212:carton:4230:30918557,30918215:carton:4230:30918593,30918218:carton:4230:30920695,30918221:carton:4230:30920874,30918224:carton:4230:30918623,30918227:carton:4230:30918661,30918230:carton:4230:30918706,30918232:carton:4230:30918743,30918235:carton:4230:30918783,30918238:carton:4230:30918824,30918241:carton:4230:30918861,30918244:carton:4230:30918897,30918247:carton:4230:30918934,30918250:carton:4230:30919016,30918253:carton:4230:30918976,30918613:carton:4230:30920609,30918925:carton:4230:30920830,30923830:carton:4230:30923903,30923831:carton:4230:30923945,30923832:carton:4230:30924015,30923833:carton:4230:30923986,30923834:carton:4230:30924054,30923835:carton:4230:30924101,30923836:carton:4230:30924135,30923838:carton:4230:30924165,30923840:carton:4230:30924205,30923843:carton:4230:30924251,3092'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001138341142811731, 'nb_photo': 1596, 'list_port_cont': '30918281,30918327,30918353,30918474,30918503,30918552,30918583,30918632,30918660,30918696,30918784,30918816,30918847,30918896,30918941,30919018,30920603,30920682,30920839,30920870,30923946,30924019,30924048,30924099,30924125,30924175,30924202,30924240,30924292,30924327,30924369,30924404,30924427,30924479,30924509,30924541,30924579,30924661,30924702,30926231,30926339,30929417,30929464,30929502,30929531,30929572,30929606,30929654,30929691,30929745,30929784,30929829,30929867,30929902,30929942,30929971,30930012,30930041,30930087,30930120,30931758,30931878,30932115,30932625,30932734,30934862,30934978,30935010,30935049,30935085,30935133,30935209,30935249,30935290,30935319,30935355,30935394,30935454,30935481,30935525,30935561,30935601,30935667,30935734,30935926,30939030,30939149,30939193,30939291,30939342,30939376,30939454,30939486,30939525,30939569,30939635,30939710,30939795,30941361,30941503,30944418,30944446,30944495,30944536,30944602,30944647,30944680,30944715,30944751,30944787,30944831,30944875,30944942,3094498', 'assoc_port': '30918204:30918327,30918205:30918281,30918206:30918353,30918209:30918474,30918210:30918503,30918212:30918552,30918215:30918583,30918218:30920682,30918221:30920870,30918224:30918632,30918227:30918660,30918230:30918696,30918235:30918784,30918238:30918816,30918241:30918847,30918244:30918896,30918247:30918941,30918250:30919018,30918613:30920603,30918925:30920839,30923831:30923946,30923832:30924019,30923834:30924048,30923835:30924099,30923836:30924125,30923838:30924175,30923840:30924202,30923843:30924240,30923846:30924292,30923849:30924327,30923852:30924369,30923855:30924404,30923858:30924427,30923861:30924479,30923864:30924509,30923867:30924579,30923870:30924541,30923876:30924661,30923879:30924702,30924273:30926231,30924728:30926339,30929365:30929464,30929366:30929417,30929367:30929502,30929368:30929531,30929369:30929572,30929370:30929606,30929371:30929654,30929373:30929691,30929375:30929745,30929376:30929902,30929378:30929784,30929380:30932734,30929382:30929829,30929384:30929867,30929387:30929942,30929388:3092997', 'assoc_mat': '30918204:metal:4230:30918327,30918205:metal:4230:30918281,30918206:metal:4230:30918353,30918209:metal:4230:30918474,30918210:metal:4230:30918503,30918212:metal:4230:30918552,30918215:metal:4230:30918583,30918218:metal:4230:30920682,30918221:metal:4230:30920870,30918224:metal:4230:30918632,30918227:metal:4230:30918660,30918230:metal:4230:30918696,30918235:metal:4230:30918784,30918238:metal:4230:30918816,30918241:metal:4230:30918847,30918244:metal:4230:30918896,30918247:metal:4230:30918941,30918250:metal:4230:30919018,30918613:metal:4230:30920603,30918925:metal:4230:30920839,30923831:metal:4230:30923946,30923832:metal:4230:30924019,30923834:metal:4230:30924048,30923835:metal:4230:30924099,30923836:metal:4230:30924125,30923838:metal:4230:30924175,30923840:metal:4230:30924202,30923843:metal:4230:30924240,30923846:metal:4230:30924292,30923849:metal:4230:30924327,30923852:metal:4230:30924369,30923855:metal:4230:30924404,30923858:metal:4230:30924427,30923861:metal:4230:30924479,30923864:metal:4230:30924509,30923867:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.181623777380301, 'nb_photo': 363568, 'list_port_cont': '30918279,30918325,30918356,30918401,30918436,30918478,30918516,30918550,30918588,30918630,30918672,30918708,30918747,30918781,30918823,30918859,30918898,30918935,30918975,30919015,30920606,30920690,30920837,30920878,30923915,30923944,30923989,30924027,30924062,30924103,30924130,30924176,30924213,30924248,30924294,30924329,30924367,30924403,30924438,30924469,30924512,30924558,30924578,30924629,30924667,30924707,30926228,30926342,30929421,30929463,30929496,30929528,30929573,30929609,30929656,30929694,30929751,30929790,30929826,30929870,30929901,30929938,30929981,30930016,30930055,30930095,30930128,30931769,30931879,30932107,30932630,30932723,30934871,30934905,30934942,30934982,30935022,30935047,30935097,30935123,30935175,30935210,30935247,30935289,30935331,30935367,30935402,30935447,30935490,30935517,30935564,30935598,30935676,30935743,30935823,30935932,30939003,30939034,30939082,30939110,30939156,30939192,30939227,30939265,30939303,30939341,30939384,30939419,30939460,30939501,30939530,30939570,30939606,3093964', 'assoc_port': '30918204:30918325,30918205:30918279,30918206:30918356,30918207:30918401,30918208:30918436,30918209:30918478,30918210:30918516,30918212:30918550,30918215:30918588,30918218:30920690,30918221:30920878,30918224:30918630,30918227:30918672,30918230:30918708,30918232:30918747,30918235:30918781,30918238:30918823,30918241:30918859,30918244:30918898,30918247:30918935,30918250:30919015,30918253:30918975,30918613:30920606,30918925:30920837,30923830:30923915,30923831:30923944,30923832:30924027,30923833:30923989,30923834:30924062,30923835:30924103,30923836:30924130,30923838:30924176,30923840:30924213,30923843:30924248,30923846:30924294,30923849:30924329,30923852:30924367,30923855:30924403,30923858:30924438,30923861:30924469,30923864:30924512,30923867:30924578,30923870:30924558,30923873:30924629,30923876:30924667,30923879:30924707,30924273:30926228,30924728:30926342,30929365:30929463,30929366:30929421,30929367:30929496,30929368:30929528,30929369:30929573,30929370:30929609,30929371:30929656,30929373:30929694,30929375:3092975', 'assoc_mat': '30918204:papier:4230:30918325,30918205:papier:4230:30918279,30918206:papier:4230:30918356,30918207:papier:4230:30918401,30918208:papier:4230:30918436,30918209:papier:4230:30918478,30918210:papier:4230:30918516,30918212:papier:4230:30918550,30918215:papier:4230:30918588,30918218:papier:4230:30920690,30918221:papier:4230:30920878,30918224:papier:4230:30918630,30918227:papier:4230:30918672,30918230:papier:4230:30918708,30918232:papier:4230:30918747,30918235:papier:4230:30918781,30918238:papier:4230:30918823,30918241:papier:4230:30918859,30918244:papier:4230:30918898,30918247:papier:4230:30918935,30918250:papier:4230:30919015,30918253:papier:4230:30918975,30918613:papier:4230:30920606,30918925:papier:4230:30920837,30923830:papier:4230:30923915,30923831:papier:4230:30923944,30923832:papier:4230:30924027,30923833:papier:4230:30923989,30923834:papier:4230:30924062,30923835:papier:4230:30924103,30923836:papier:4230:30924130,30923838:papier:4230:30924176,30923840:papier:4230:30924213,30923843:papier:4230:30924248,3092'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0038538430261352698, 'nb_photo': 1978, 'list_port_cont': '30918282,30918367,30918438,30918469,30918514,30918547,30918591,30918628,30918669,30918703,30918738,30918788,30918819,30918862,30918901,30918936,30918981,30919017,30920605,30920692,30920834,30920875,30923916,30923947,30924026,30924093,30924137,30924174,30924214,30924243,30924291,30924333,30924364,30924390,30924439,30924477,30924516,30924554,30924591,30924632,30924669,30924704,30926229,30926343,30929457,30929500,30929539,30929576,30929616,30929698,30929756,30929789,30929931,30930021,30930047,30930101,30930137,30931881,30932113,30932642,30932730,30934873,30934910,30935053,30935130,30935170,30935211,30935250,30935280,30935329,30935360,30935391,30935455,30935491,30935528,30935562,30935593,30935749,30935819,30935931,30939005,30939157,30939194,30939222,30939258,30939337,30939378,30939413,30939461,30939646,30939790,30941351,30941496,30944413,30944497,30944531,30944614,30944686,30944718,30944756,30944797,30944834,30944948,30944976,30946646,30946802,30949962,30950003,30950041,30950069,30950104,30950147,30950184,3095023', 'assoc_port': '30918205:30918282,30918206:30918367,30918208:30918438,30918209:30918469,30918210:30918514,30918212:30918547,30918215:30918591,30918218:30920692,30918221:30920875,30918224:30918628,30918227:30918669,30918230:30918703,30918232:30918738,30918235:30918788,30918238:30918819,30918241:30918862,30918244:30918901,30918247:30918936,30918250:30919017,30918253:30918981,30918613:30920605,30918925:30920834,30923830:30923916,30923831:30923947,30923832:30924026,30923835:30924093,30923836:30924137,30923838:30924174,30923840:30924214,30923843:30924243,30923846:30924291,30923849:30924333,30923852:30924364,30923855:30924390,30923858:30924439,30923861:30924477,30923864:30924516,30923867:30924591,30923870:30924554,30923873:30924632,30923876:30924669,30923879:30924704,30924273:30926229,30924728:30926343,30929365:30929457,30929367:30929500,30929368:30929539,30929369:30929576,30929370:30929616,30929373:30929698,30929375:30929756,30929378:30929789,30929380:30932730,30929387:30929931,30929390:30932642,30929393:30931881,30929394:3093002', 'assoc_mat': '30918205:pehd:4230:30918282,30918206:pehd:4230:30918367,30918208:pehd:4230:30918438,30918209:pehd:4230:30918469,30918210:pehd:4230:30918514,30918212:pehd:4230:30918547,30918215:pehd:4230:30918591,30918218:pehd:4230:30920692,30918221:pehd:4230:30920875,30918224:pehd:4230:30918628,30918227:pehd:4230:30918669,30918230:pehd:4230:30918703,30918232:pehd:4230:30918738,30918235:pehd:4230:30918788,30918238:pehd:4230:30918819,30918241:pehd:4230:30918862,30918244:pehd:4230:30918901,30918247:pehd:4230:30918936,30918250:pehd:4230:30919017,30918253:pehd:4230:30918981,30918613:pehd:4230:30920605,30918925:pehd:4230:30920834,30923830:pehd:4230:30923916,30923831:pehd:4230:30923947,30923832:pehd:4230:30924026,30923835:pehd:4230:30924093,30923836:pehd:4230:30924137,30923838:pehd:4230:30924174,30923840:pehd:4230:30924214,30923843:pehd:4230:30924243,30923846:pehd:4230:30924291,30923849:pehd:4230:30924333,30923852:pehd:4230:30924364,30923855:pehd:4230:30924390,30923858:pehd:4230:30924439,30923861:pehd:4230:30924477,30923864:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017933922975085236, 'nb_photo': 26738, 'list_port_cont': '30918290,30918319,30918366,30918394,30918428,30918477,30918515,30918556,30918582,30918633,30918668,30918704,30918748,30918780,30918822,30918855,30918895,30918940,30918971,30919006,30920611,30920693,30920827,30920872,30923908,30923950,30923990,30924022,30924059,30924089,30924139,30924166,30924209,30924252,30924280,30924323,30924363,30924400,30924429,30924470,30924513,30924548,30924594,30924634,30924666,30924703,30926226,30926337,30929430,30929460,30929501,30929536,30929581,30929611,30929655,30929689,30929744,30929792,30929818,30929868,30929905,30929935,30929977,30930015,30930054,30930094,30930133,30931762,30931872,30932117,30932634,30932733,30934872,30934906,30934940,30934971,30935019,30935056,30935099,30935129,30935174,30935204,30935248,30935286,30935318,30935359,30935392,30935443,30935485,30935524,30935553,30935604,30935664,30935750,30935812,30935938,30939006,30939039,30939080,30939116,30939158,30939190,30939231,30939264,30939307,30939345,30939386,30939416,30939463,30939488,30939533,30939577,30939605,3093964', 'assoc_port': '30918204:30918319,30918205:30918290,30918206:30918366,30918207:30918394,30918208:30918428,30918209:30918477,30918210:30918515,30918212:30918556,30918215:30918582,30918218:30920693,30918221:30920872,30918224:30918633,30918227:30918668,30918230:30918704,30918232:30918748,30918235:30918780,30918238:30918822,30918241:30918855,30918244:30918895,30918247:30918940,30918250:30919006,30918253:30918971,30918613:30920611,30918925:30920827,30923830:30923908,30923831:30923950,30923832:30924022,30923833:30923990,30923834:30924059,30923835:30924089,30923836:30924139,30923838:30924166,30923840:30924209,30923843:30924252,30923846:30924280,30923849:30924323,30923852:30924363,30923855:30924400,30923858:30924429,30923861:30924470,30923864:30924513,30923867:30924594,30923870:30924548,30923873:30924634,30923876:30924666,30923879:30924703,30924273:30926226,30924728:30926337,30929365:30929460,30929366:30929430,30929367:30929501,30929368:30929536,30929369:30929581,30929370:30929611,30929371:30929655,30929373:30929689,30929375:3092974', 'assoc_mat': '30918204:pet_clair:4230:30918319,30918205:pet_clair:4230:30918290,30918206:pet_clair:4230:30918366,30918207:pet_clair:4230:30918394,30918208:pet_clair:4230:30918428,30918209:pet_clair:4230:30918477,30918210:pet_clair:4230:30918515,30918212:pet_clair:4230:30918556,30918215:pet_clair:4230:30918582,30918218:pet_clair:4230:30920693,30918221:pet_clair:4230:30920872,30918224:pet_clair:4230:30918633,30918227:pet_clair:4230:30918668,30918230:pet_clair:4230:30918704,30918232:pet_clair:4230:30918748,30918235:pet_clair:4230:30918780,30918238:pet_clair:4230:30918822,30918241:pet_clair:4230:30918855,30918244:pet_clair:4230:30918895,30918247:pet_clair:4230:30918940,30918250:pet_clair:4230:30919006,30918253:pet_clair:4230:30918971,30918613:pet_clair:4230:30920611,30918925:pet_clair:4230:30920827,30923830:pet_clair:4230:30923908,30923831:pet_clair:4230:30923950,30923832:pet_clair:4230:30924022,30923833:pet_clair:4230:30923990,30923834:pet_clair:4230:30924059,30923835:pet_clair:4230:30924089,30923836:pet_clair:4230:30924139,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028882596028359836, 'nb_photo': 1039, 'list_port_cont': '30918291,30918323,30918359,30918429,30918473,30918555,30918592,30918634,30918663,30918702,30918777,30918815,30918900,30918982,30920610,30920688,30920836,30920873,30923909,30923942,30923983,30924025,30924063,30924094,30924133,30924173,30924211,30924250,30924284,30924324,30924366,30924401,30924436,30924517,30924546,30924592,30924628,30924670,30924708,30926232,30926345,30929420,30929455,30929495,30929538,30929578,30929617,30929650,30929699,30929822,30929943,30930017,30930048,30931759,30934870,30934909,30934984,30935012,30935202,30935251,30935288,30935327,30935401,30935453,30935488,30935516,30935595,30935670,30935746,30935936,30939009,30939071,30939112,30939151,30939189,30939230,30939266,30939305,30939338,30939382,30939422,30939527,30939613,30939643,30939687,30939800,30941359,30944496,30944532,30944616,30944655,30944684,30944725,30944755,30944795,30944830,30944870,30945022,30946654,30946797,30950038,30950109,30950149,30950190,30950229,30950262,30950329,30950375,30950415,30950445,30950486,30950524,30950563,3095220', 'assoc_port': '30918204:30918323,30918205:30918291,30918206:30918359,30918208:30918429,30918209:30918473,30918212:30918555,30918215:30918592,30918218:30920688,30918221:30920873,30918224:30918634,30918227:30918663,30918230:30918702,30918235:30918777,30918238:30918815,30918244:30918900,30918253:30918982,30918613:30920610,30918925:30920836,30923830:30923909,30923831:30923942,30923832:30924025,30923833:30923983,30923834:30924063,30923835:30924094,30923836:30924133,30923838:30924173,30923840:30924211,30923843:30924250,30923846:30924284,30923849:30924324,30923852:30924366,30923855:30924401,30923858:30924436,30923864:30924517,30923867:30924592,30923870:30924546,30923873:30924628,30923876:30924670,30923879:30924708,30924273:30926232,30924728:30926345,30929365:30929455,30929366:30929420,30929367:30929495,30929368:30929538,30929369:30929578,30929370:30929617,30929371:30929650,30929373:30929699,30929382:30929822,30929387:30929943,30929394:30930017,30929396:30930048,30930076:30931759,30934754:30934870,30934756:30934909,30934758:3093498', 'assoc_mat': '30918204:pet_fonce:4230:30918323,30918205:pet_fonce:4230:30918291,30918206:pet_fonce:4230:30918359,30918208:pet_fonce:4230:30918429,30918209:pet_fonce:4230:30918473,30918212:pet_fonce:4230:30918555,30918215:pet_fonce:4230:30918592,30918218:pet_fonce:4230:30920688,30918221:pet_fonce:4230:30920873,30918224:pet_fonce:4230:30918634,30918227:pet_fonce:4230:30918663,30918230:pet_fonce:4230:30918702,30918235:pet_fonce:4230:30918777,30918238:pet_fonce:4230:30918815,30918244:pet_fonce:4230:30918900,30918253:pet_fonce:4230:30918982,30918613:pet_fonce:4230:30920610,30918925:pet_fonce:4230:30920836,30923830:pet_fonce:4230:30923909,30923831:pet_fonce:4230:30923942,30923832:pet_fonce:4230:30924025,30923833:pet_fonce:4230:30923983,30923834:pet_fonce:4230:30924063,30923835:pet_fonce:4230:30924094,30923836:pet_fonce:4230:30924133,30923838:pet_fonce:4230:30924173,30923840:pet_fonce:4230:30924211,30923843:pet_fonce:4230:30924250,30923846:pet_fonce:4230:30924284,30923849:pet_fonce:4230:30924324,30923852:pet_fonce:4230:30924366,3'}), 'main_stat': {'nb_photos': 1674}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30998170,30998171,30998172,30998173,30998174,30998175,30998176?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-04', 0.7599222468274857),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_04_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.79%', 20084], 'carton': ['carton', '3.66%', 65883], 'metal': ['metal', '0.11%', 1596], 'papier': ['papier', '18.16%', 363568], 'pehd': ['pehd', '0.39%', 1978], 'pet_clair': ['pet_clair', '1.79%', 26738], 'pet_fonce': ['pet_fonce', '0.29%', 1039]}} 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_04_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.38user 3.01system 0:17.45elapsed 30%CPU (0avgtext+0avgdata 185636maxresident)k 6392inputs+288outputs (20major+46719minor)pagefaults 0swaps