python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-02 _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 : (6, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 02 mtr_id : dashboard_places : SCCU_cam8 date : 2026-02 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2026-02%') and created_at like '%2026-02%'))); nb_day : (6, 28) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%022026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-02-01 : dt_date_just_month_year : 2026-02-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-02-01" AND ded.date <= "2026-02-28" 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 (2897177,2898373,2899357,2900191,2901464,2902240,2903176,2903643,2904629,2905407,2906429,2907537,2908597,2909395,2909950,2911151,2912409,2913615,2919458,2922897,2923661,2924347,2925280,2926594,2927386,2928103,2929335,2933506) 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.020734520107480375, 'nb_photo': 23634, 'list_port_cont': '30284430,30284466,30284504,30284611,30284628,30284695,30284728,30284769,30284800,30284835,30284871,30284889,30284973,30285118,30285154,30285310,30285343,30285413,30285511,30285590,30285613,30285890,30286619,30286977,30288341,30288371,30288596,30288621,30288784,30288913,30289201,30289633,30289883,30290216,30290640,30291506,30291771,30292685,30292718,30293345,30294050,30294801,30295242,30295512,30295748,30296865,30297567,30297794,30304256,30305396,30305517,30305542,30305581,30305628,30305664,30305696,30305732,30305762,30305802,30305844,30305880,30305890,30305947,30305988,30306015,30306052,30306096,30306129,30306164,30306340,30306374,30306570,30306602,30306672,30306829,30307052,30307089,30307487,30307688,30308339,30308628,30308978,30309228,30309397,30309698,30310373,30310440,30311096,30311183,30312045,30312072,30312720,30313165,30313889,30314028,30323429,30323449,30323486,30323562,30323605,30323614,30323662,30323744,30323787,30323834,30323877,30324002,30324044,30324069,30324100,30324216,30324317,30324577,3032461', 'assoc_port': '30284314:30285890,30284318:30285613,30284320:30285511,30284323:30285154,30284327:30284871,30284330:30284769,30284332:30285590,30284335:30284973,30284337:30285310,30284339:30285413,30284341:30284695,30284342:30285343,30284343:30285118,30284344:30284504,30284345:30284835,30284346:30284800,30284347:30284466,30284348:30284430,30284349:30284889,30284350:30284628,30284351:30284728,30284352:30284611,30286526:30286619,30286651:30286977,30288258:30288341,30288259:30288371,30288427:30288596,30288429:30288621,30288700:30288784,30288823:30288913,30288961:30289201,30289446:30289633,30289756:30289883,30290024:30290216,30290520:30290640,30291263:30291506,30291741:30291771,30292430:30292685,30292432:30292718,30293130:30293345,30293703:30294050,30294586:30294801,30294979:30295242,30295410:30295512,30295573:30295748,30295962:30296865,30297483:30297567,30297612:30297794,30303877:30304256,30305354:30306015,30305355:30306340,30305356:30306164,30305357:30306052,30305358:30306129,30305359:30305844,30305360:30306096,30305361:3030576', 'assoc_mat': '30284314:autre:4230:30285890,30284318:autre:4230:30285613,30284320:autre:4230:30285511,30284323:autre:4230:30285154,30284327:autre:4230:30284871,30284330:autre:4230:30284769,30284332:autre:4230:30285590,30284335:autre:4230:30284973,30284337:autre:4230:30285310,30284339:autre:4230:30285413,30284341:autre:4230:30284695,30284342:autre:4230:30285343,30284343:autre:4230:30285118,30284344:autre:4230:30284504,30284345:autre:4230:30284835,30284346:autre:4230:30284800,30284347:autre:4230:30284466,30284348:autre:4230:30284430,30284349:autre:4230:30284889,30284350:autre:4230:30284628,30284351:autre:4230:30284728,30284352:autre:4230:30284611,30286526:autre:4230:30286619,30286651:autre:4230:30286977,30288258:autre:4230:30288341,30288259:autre:4230:30288371,30288427:autre:4230:30288596,30288429:autre:4230:30288621,30288700:autre:4230:30288784,30288823:autre:4230:30288913,30288961:autre:4230:30289201,30289446:autre:4230:30289633,30289756:autre:4230:30289883,30290024:autre:4230:30290216,30290520:autre:4230:30290640,30291263:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.09131866063733568, 'nb_photo': 138822, 'list_port_cont': '30284443,30284474,30284507,30284625,30284641,30284694,30284721,30284758,30284797,30284840,30284874,30284894,30284982,30285129,30285153,30285307,30285344,30285416,30285523,30285600,30285618,30285905,30286615,30286987,30288340,30288383,30288597,30288633,30288794,30288920,30289211,30289628,30289881,30290226,30290639,30291509,30291769,30292694,30292730,30293351,30294048,30294810,30295233,30295510,30295754,30296875,30297571,30297800,30304254,30305409,30305522,30305557,30305590,30305626,30305667,30305701,30305735,30305768,30305809,30305847,30305876,30305904,30305954,30305992,30306025,30306057,30306102,30306134,30306168,30306343,30306364,30306565,30306596,30306689,30306841,30307061,30307090,30307490,30307685,30308335,30308639,30308984,30309233,30309405,30309687,30310370,30310446,30311097,30311186,30312043,30312082,30312721,30313163,30313903,30314025,30323416,30323460,30323498,30323570,30323598,30323633,30323659,30323752,30323788,30323849,30323876,30323997,30324028,30324077,30324113,30324214,30324328,30324574,3032461', 'assoc_port': '30284314:30285905,30284318:30285618,30284320:30285523,30284323:30285153,30284327:30284874,30284330:30284758,30284332:30285600,30284335:30284982,30284337:30285307,30284339:30285416,30284341:30284694,30284342:30285344,30284343:30285129,30284344:30284507,30284345:30284840,30284346:30284797,30284347:30284474,30284348:30284443,30284349:30284894,30284350:30284641,30284351:30284721,30284352:30284625,30286526:30286615,30286651:30286987,30288258:30288340,30288259:30288383,30288427:30288597,30288429:30288633,30288700:30288794,30288823:30288920,30288961:30289211,30289446:30289628,30289756:30289881,30290024:30290226,30290520:30290639,30291263:30291509,30291741:30291769,30292430:30292694,30292432:30292730,30293130:30293351,30293703:30294048,30294586:30294810,30294979:30295233,30295410:30295510,30295573:30295754,30295962:30296875,30297483:30297571,30297612:30297800,30303877:30304254,30305354:30306025,30305355:30306343,30305356:30306168,30305357:30306057,30305358:30306134,30305359:30305847,30305360:30306102,30305361:3030576', 'assoc_mat': '30284314:carton:4230:30285905,30284318:carton:4230:30285618,30284320:carton:4230:30285523,30284323:carton:4230:30285153,30284327:carton:4230:30284874,30284330:carton:4230:30284758,30284332:carton:4230:30285600,30284335:carton:4230:30284982,30284337:carton:4230:30285307,30284339:carton:4230:30285416,30284341:carton:4230:30284694,30284342:carton:4230:30285344,30284343:carton:4230:30285129,30284344:carton:4230:30284507,30284345:carton:4230:30284840,30284346:carton:4230:30284797,30284347:carton:4230:30284474,30284348:carton:4230:30284443,30284349:carton:4230:30284894,30284350:carton:4230:30284641,30284351:carton:4230:30284721,30284352:carton:4230:30284625,30286526:carton:4230:30286615,30286651:carton:4230:30286987,30288258:carton:4230:30288340,30288259:carton:4230:30288383,30288427:carton:4230:30288597,30288429:carton:4230:30288633,30288700:carton:4230:30288794,30288823:carton:4230:30288920,30288961:carton:4230:30289211,30289446:carton:4230:30289628,30289756:carton:4230:30289881,30290024:carton:4230:30290226,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017210538133663334, 'nb_photo': 1997, 'list_port_cont': '30284442,30284468,30284508,30284620,30284627,30284684,30284719,30284767,30284796,30284832,30284875,30284896,30284971,30285116,30285166,30285298,30285334,30285411,30285584,30285614,30286613,30286983,30288344,30288381,30288580,30288625,30288778,30288903,30289202,30289634,30289886,30290229,30290636,30293343,30294049,30295241,30295521,30295761,30296871,30297558,30297791,30304266,30305515,30305556,30305593,30305625,30305663,30305692,30305739,30305808,30305885,30305891,30305958,30305987,30306053,30306094,30306121,30306161,30306369,30306597,30306687,30306840,30307046,30307091,30307481,30307680,30308334,30308982,30309230,30309400,30309681,30310371,30310443,30311102,30311199,30312086,30312727,30313164,30313899,30314030,30323426,30323461,30323487,30323573,30323593,30323639,30323652,30323755,30323789,30323853,30324008,30324043,30324080,30324103,30324224,30324329,30324571,30324589,30324880,30324920,30325076,30325785,30325813,30326013,30326153,30326284,30326431,30326617,30326723,30326840,30327444,30327447,30328118,3032877', 'assoc_port': '30284318:30285614,30284323:30285166,30284327:30284875,30284330:30284767,30284332:30285584,30284335:30284971,30284337:30285298,30284339:30285411,30284341:30284684,30284342:30285334,30284343:30285116,30284344:30284508,30284345:30284832,30284346:30284796,30284347:30284468,30284348:30284442,30284349:30284896,30284350:30284627,30284351:30284719,30284352:30284620,30286526:30286613,30286651:30286983,30288258:30288344,30288259:30288381,30288427:30288580,30288429:30288625,30288700:30288778,30288823:30288903,30288961:30289202,30289446:30289634,30289756:30289886,30290024:30290229,30290520:30290636,30293130:30293343,30293703:30294049,30294979:30295241,30295410:30295521,30295573:30295761,30295962:30296871,30297483:30297558,30297612:30297791,30303877:30304266,30305356:30306161,30305357:30306053,30305358:30306121,30305360:30306094,30305362:30305958,30305363:30305885,30305364:30305987,30305366:30305891,30305368:30305556,30305369:30305692,30305370:30306369,30305371:30305593,30305372:30305808,30305373:30305515,30305374:3030573', 'assoc_mat': '30284318:metal:4230:30285614,30284323:metal:4230:30285166,30284327:metal:4230:30284875,30284330:metal:4230:30284767,30284332:metal:4230:30285584,30284335:metal:4230:30284971,30284337:metal:4230:30285298,30284339:metal:4230:30285411,30284341:metal:4230:30284684,30284342:metal:4230:30285334,30284343:metal:4230:30285116,30284344:metal:4230:30284508,30284345:metal:4230:30284832,30284346:metal:4230:30284796,30284347:metal:4230:30284468,30284348:metal:4230:30284442,30284349:metal:4230:30284896,30284350:metal:4230:30284627,30284351:metal:4230:30284719,30284352:metal:4230:30284620,30286526:metal:4230:30286613,30286651:metal:4230:30286983,30288258:metal:4230:30288344,30288259:metal:4230:30288381,30288427:metal:4230:30288580,30288429:metal:4230:30288625,30288700:metal:4230:30288778,30288823:metal:4230:30288903,30288961:metal:4230:30289202,30289446:metal:4230:30289634,30289756:metal:4230:30289886,30290024:metal:4230:30290229,30290520:metal:4230:30290636,30293130:metal:4230:30293343,30293703:metal:4230:30294049,30294979:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3656671724673985, 'nb_photo': 449884, 'list_port_cont': '30284439,30284478,30284514,30284621,30284636,30284697,30284732,30284768,30284805,30284826,30284868,30284895,30284981,30285130,30285167,30285304,30285341,30285408,30285528,30285589,30285607,30285906,30286620,30286993,30288350,30288386,30288588,30288630,30288782,30288912,30289207,30289635,30289888,30290223,30290644,30291508,30291777,30292693,30292733,30293346,30294042,30294807,30295238,30295514,30295762,30296872,30297574,30297790,30304267,30305411,30305520,30305554,30305586,30305620,30305665,30305698,30305736,30305774,30305800,30305849,30305886,30305899,30305948,30305986,30306029,30306062,30306089,30306132,30306173,30306334,30306378,30306569,30306601,30306682,30306846,30307057,30307096,30307491,30307691,30308346,30308636,30308974,30309229,30309413,30309690,30310364,30310447,30311101,30311193,30312049,30312078,30312719,30313162,30313904,30314035,30323422,30323456,30323500,30323571,30323609,30323631,30323664,30323747,30323792,30323832,30323881,30324003,30324041,30324072,30324115,30324210,30324324,30324586,3032461', 'assoc_port': '30284314:30285906,30284318:30285607,30284320:30285528,30284323:30285167,30284327:30284868,30284330:30284768,30284332:30285589,30284335:30284981,30284337:30285304,30284339:30285408,30284341:30284697,30284342:30285341,30284343:30285130,30284344:30284514,30284345:30284826,30284346:30284805,30284347:30284478,30284348:30284439,30284349:30284895,30284350:30284636,30284351:30284732,30284352:30284621,30286526:30286620,30286651:30286993,30288258:30288350,30288259:30288386,30288427:30288588,30288429:30288630,30288700:30288782,30288823:30288912,30288961:30289207,30289446:30289635,30289756:30289888,30290024:30290223,30290520:30290644,30291263:30291508,30291741:30291777,30292430:30292693,30292432:30292733,30293130:30293346,30293703:30294042,30294586:30294807,30294979:30295238,30295410:30295514,30295573:30295762,30295962:30296872,30297483:30297574,30297612:30297790,30303877:30304267,30305354:30306029,30305355:30306334,30305356:30306173,30305357:30306062,30305358:30306132,30305359:30305849,30305360:30306089,30305361:3030577', 'assoc_mat': '30284314:papier:4230:30285906,30284318:papier:4230:30285607,30284320:papier:4230:30285528,30284323:papier:4230:30285167,30284327:papier:4230:30284868,30284330:papier:4230:30284768,30284332:papier:4230:30285589,30284335:papier:4230:30284981,30284337:papier:4230:30285304,30284339:papier:4230:30285408,30284341:papier:4230:30284697,30284342:papier:4230:30285341,30284343:papier:4230:30285130,30284344:papier:4230:30284514,30284345:papier:4230:30284826,30284346:papier:4230:30284805,30284347:papier:4230:30284478,30284348:papier:4230:30284439,30284349:papier:4230:30284895,30284350:papier:4230:30284636,30284351:papier:4230:30284732,30284352:papier:4230:30284621,30286526:papier:4230:30286620,30286651:papier:4230:30286993,30288258:papier:4230:30288350,30288259:papier:4230:30288386,30288427:papier:4230:30288588,30288429:papier:4230:30288630,30288700:papier:4230:30288782,30288823:papier:4230:30288912,30288961:papier:4230:30289207,30289446:papier:4230:30289635,30289756:papier:4230:30289888,30290024:papier:4230:30290223,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006320417572341072, 'nb_photo': 7560, 'list_port_cont': '30284432,30284477,30284511,30284624,30284643,30284686,30284730,30284760,30284798,30284841,30284865,30284891,30284983,30285125,30285164,30285302,30285347,30285420,30285519,30285597,30285617,30285896,30286614,30286990,30288351,30288388,30288589,30288632,30288793,30288915,30289205,30289630,30289878,30290215,30290629,30291512,30291772,30292684,30292729,30293355,30294053,30294812,30295243,30295516,30295757,30296879,30297575,30297795,30304260,30305413,30305518,30305553,30305591,30305623,30305652,30305700,30305738,30305771,30305805,30305843,30305883,30305894,30305957,30305983,30306024,30306061,30306093,30306135,30306171,30306341,30306370,30306559,30306608,30306686,30306844,30307053,30307093,30307486,30307692,30308344,30308637,30308980,30309231,30309407,30309693,30310362,30310434,30311092,30311203,30312084,30312724,30313159,30313897,30314037,30323424,30323463,30323493,30323563,30323606,30323635,30323663,30323753,30323782,30323833,30323878,30324005,30324042,30324071,30324116,30324220,30324332,30324585,30324605,3032488', 'assoc_port': '30284314:30285896,30284318:30285617,30284320:30285519,30284323:30285164,30284327:30284865,30284330:30284760,30284332:30285597,30284335:30284983,30284337:30285302,30284339:30285420,30284341:30284686,30284342:30285347,30284343:30285125,30284344:30284511,30284345:30284841,30284346:30284798,30284347:30284477,30284348:30284432,30284349:30284891,30284350:30284643,30284351:30284730,30284352:30284624,30286526:30286614,30286651:30286990,30288258:30288351,30288259:30288388,30288427:30288589,30288429:30288632,30288700:30288793,30288823:30288915,30288961:30289205,30289446:30289630,30289756:30289878,30290024:30290215,30290520:30290629,30291263:30291512,30291741:30291772,30292430:30292684,30292432:30292729,30293130:30293355,30293703:30294053,30294586:30294812,30294979:30295243,30295410:30295516,30295573:30295757,30295962:30296879,30297483:30297575,30297612:30297795,30303877:30304260,30305354:30306024,30305355:30306341,30305356:30306171,30305357:30306061,30305358:30306135,30305359:30305843,30305360:30306093,30305361:3030577', 'assoc_mat': '30284314:pehd:4230:30285896,30284318:pehd:4230:30285617,30284320:pehd:4230:30285519,30284323:pehd:4230:30285164,30284327:pehd:4230:30284865,30284330:pehd:4230:30284760,30284332:pehd:4230:30285597,30284335:pehd:4230:30284983,30284337:pehd:4230:30285302,30284339:pehd:4230:30285420,30284341:pehd:4230:30284686,30284342:pehd:4230:30285347,30284343:pehd:4230:30285125,30284344:pehd:4230:30284511,30284345:pehd:4230:30284841,30284346:pehd:4230:30284798,30284347:pehd:4230:30284477,30284348:pehd:4230:30284432,30284349:pehd:4230:30284891,30284350:pehd:4230:30284643,30284351:pehd:4230:30284730,30284352:pehd:4230:30284624,30286526:pehd:4230:30286614,30286651:pehd:4230:30286990,30288258:pehd:4230:30288351,30288259:pehd:4230:30288388,30288427:pehd:4230:30288589,30288429:pehd:4230:30288632,30288700:pehd:4230:30288793,30288823:pehd:4230:30288915,30288961:pehd:4230:30289205,30289446:pehd:4230:30289630,30289756:pehd:4230:30289878,30290024:pehd:4230:30290215,30290520:pehd:4230:30290629,30291263:pehd:4230:30291512,30291741:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012740952680303444, 'nb_photo': 25829, 'list_port_cont': '30284436,30284471,30284515,30284623,30284639,30284687,30284722,30284761,30284802,30284839,30284879,30284892,30284986,30285128,30285160,30285311,30285340,30285419,30285526,30285596,30285610,30285904,30286616,30286992,30288352,30288379,30288590,30288618,30288786,30288911,30289200,30289624,30289885,30290228,30290642,30291514,30291773,30292687,30292717,30293349,30294044,30294814,30295234,30295518,30295751,30296878,30297573,30297799,30304259,30305402,30305521,30305551,30305585,30305631,30305656,30305702,30305737,30305776,30305813,30305842,30305877,30305896,30305953,30305985,30306022,30306063,30306101,30306127,30306169,30306342,30306371,30306562,30306605,30306688,30306845,30307062,30307084,30307489,30307687,30308338,30308630,30308981,30309232,30309398,30309688,30310366,30310445,30311100,30311191,30312048,30312081,30312713,30313161,30313905,30314029,30323425,30323462,30323497,30323574,30323610,30323623,30323654,30323749,30323781,30323847,30323875,30323996,30324030,30324079,30324114,30324221,30324327,30324587,3032460', 'assoc_port': '30284314:30285904,30284318:30285610,30284320:30285526,30284323:30285160,30284327:30284879,30284330:30284761,30284332:30285596,30284335:30284986,30284337:30285311,30284339:30285419,30284341:30284687,30284342:30285340,30284343:30285128,30284344:30284515,30284345:30284839,30284346:30284802,30284347:30284471,30284348:30284436,30284349:30284892,30284350:30284639,30284351:30284722,30284352:30284623,30286526:30286616,30286651:30286992,30288258:30288352,30288259:30288379,30288427:30288590,30288429:30288618,30288700:30288786,30288823:30288911,30288961:30289200,30289446:30289624,30289756:30289885,30290024:30290228,30290520:30290642,30291263:30291514,30291741:30291773,30292430:30292687,30292432:30292717,30293130:30293349,30293703:30294044,30294586:30294814,30294979:30295234,30295410:30295518,30295573:30295751,30295962:30296878,30297483:30297573,30297612:30297799,30303877:30304259,30305354:30306022,30305355:30306342,30305356:30306169,30305357:30306063,30305358:30306127,30305359:30305842,30305360:30306101,30305361:3030577', 'assoc_mat': '30284314:pet_clair:4230:30285904,30284318:pet_clair:4230:30285610,30284320:pet_clair:4230:30285526,30284323:pet_clair:4230:30285160,30284327:pet_clair:4230:30284879,30284330:pet_clair:4230:30284761,30284332:pet_clair:4230:30285596,30284335:pet_clair:4230:30284986,30284337:pet_clair:4230:30285311,30284339:pet_clair:4230:30285419,30284341:pet_clair:4230:30284687,30284342:pet_clair:4230:30285340,30284343:pet_clair:4230:30285128,30284344:pet_clair:4230:30284515,30284345:pet_clair:4230:30284839,30284346:pet_clair:4230:30284802,30284347:pet_clair:4230:30284471,30284348:pet_clair:4230:30284436,30284349:pet_clair:4230:30284892,30284350:pet_clair:4230:30284639,30284351:pet_clair:4230:30284722,30284352:pet_clair:4230:30284623,30286526:pet_clair:4230:30286616,30286651:pet_clair:4230:30286992,30288258:pet_clair:4230:30288352,30288259:pet_clair:4230:30288379,30288427:pet_clair:4230:30288590,30288429:pet_clair:4230:30288618,30288700:pet_clair:4230:30288786,30288823:pet_clair:4230:30288911,30288961:pet_clair:4230:30289200,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010513197748981509, 'nb_photo': 2538, 'list_port_cont': '30284431,30284473,30284509,30284613,30284629,30284690,30284726,30284765,30284795,30284838,30284878,30284897,30284980,30285122,30285162,30285309,30285348,30285417,30285525,30285593,30285616,30285901,30286612,30286984,30288336,30288382,30288593,30288624,30288792,30288914,30289208,30289627,30289877,30290230,30290633,30291511,30291775,30292695,30292722,30293353,30294051,30294804,30295235,30295517,30295760,30296880,30297565,30304262,30305401,30305519,30305547,30305592,30305621,30305666,30305694,30305730,30305772,30305801,30305840,30305884,30305903,30305956,30305990,30306030,30306060,30306095,30306138,30306166,30306336,30306377,30306561,30306606,30306681,30306832,30307059,30307097,30307480,30307690,30308345,30308638,30308987,30309227,30310368,30311103,30311205,30312042,30312080,30312722,30313155,30313896,30314033,30323428,30323466,30323496,30323566,30323607,30323641,30323657,30323743,30323783,30323851,30323872,30324006,30324032,30324067,30324112,30324223,30324326,30324582,30324623,30324892,30324931,30325072,3032579', 'assoc_port': '30284314:30285901,30284318:30285616,30284320:30285525,30284323:30285162,30284327:30284878,30284330:30284765,30284332:30285593,30284335:30284980,30284337:30285309,30284339:30285417,30284341:30284690,30284342:30285348,30284343:30285122,30284344:30284509,30284345:30284838,30284346:30284795,30284347:30284473,30284348:30284431,30284349:30284897,30284350:30284629,30284351:30284726,30284352:30284613,30286526:30286612,30286651:30286984,30288258:30288336,30288259:30288382,30288427:30288593,30288429:30288624,30288700:30288792,30288823:30288914,30288961:30289208,30289446:30289627,30289756:30289877,30290024:30290230,30290520:30290633,30291263:30291511,30291741:30291775,30292430:30292695,30292432:30292722,30293130:30293353,30293703:30294051,30294586:30294804,30294979:30295235,30295410:30295517,30295573:30295760,30295962:30296880,30297483:30297565,30303877:30304262,30305354:30306030,30305355:30306336,30305356:30306166,30305357:30306060,30305358:30306138,30305359:30305840,30305360:30306095,30305361:30305772,30305362:3030595', 'assoc_mat': '30284314:pet_fonce:4230:30285901,30284318:pet_fonce:4230:30285616,30284320:pet_fonce:4230:30285525,30284323:pet_fonce:4230:30285162,30284327:pet_fonce:4230:30284878,30284330:pet_fonce:4230:30284765,30284332:pet_fonce:4230:30285593,30284335:pet_fonce:4230:30284980,30284337:pet_fonce:4230:30285309,30284339:pet_fonce:4230:30285417,30284341:pet_fonce:4230:30284690,30284342:pet_fonce:4230:30285348,30284343:pet_fonce:4230:30285122,30284344:pet_fonce:4230:30284509,30284345:pet_fonce:4230:30284838,30284346:pet_fonce:4230:30284795,30284347:pet_fonce:4230:30284473,30284348:pet_fonce:4230:30284431,30284349:pet_fonce:4230:30284897,30284350:pet_fonce:4230:30284629,30284351:pet_fonce:4230:30284726,30284352:pet_fonce:4230:30284613,30286526:pet_fonce:4230:30286612,30286651:pet_fonce:4230:30286984,30288258:pet_fonce:4230:30288336,30288259:pet_fonce:4230:30288382,30288427:pet_fonce:4230:30288593,30288429:pet_fonce:4230:30288624,30288700:pet_fonce:4230:30288792,30288823:pet_fonce:4230:30288914,30288961:pet_fonce:4230:30289208,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(2897177,2898373,2899357,2900191,2901464,2902240,2903176,2903643,2904629,2905407,2906429,2907537,2908597,2909395,2909950,2911151,2912409,2913615,2919458,2922897,2923661,2924347,2925280,2926594,2927386,2928103,2929335,2933506)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496548, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284430,30284466,30284504,30284611,30284628,30284695,30284728,30284769,30284800,30284835,30284871,30284889,30284973,30285118,30285154,30285310,30285343,30285413,30285511,30285590,30285613,30285890,30286619,30286977,30288341,30288371,30288596,30288621,30288784,30288913,30289201,30289633,30289883,30290216,30290640,30291506,30291771,30292685,30292718,30293345,30294050,30294801,30295242,30295512,30295748,30296865,30297567,30297794,30304256,30305396,30305517,30305542,30305581,30305628,30305664,30305696,30305732,30305762,30305802,30305844,30305880,30305890,30305947,30305988,30306015,30306052,30306096,30306129,30306164,30306340,30306374,30306570,30306602,30306672,30306829,30307052,30307089,30307487,30307688,30308339,30308628,30308978,30309228,30309397,30309698,30310373,30310440,30311096,30311183,30312045,30312072,30312720,30313165,30313889,30314028,30323429,30323449,30323486,30323562,30323605,30323614,30323662,30323744,30323787,30323834,30323877,30324002,30324044,30324069,30324100,30324216,30324317,30324577,3032461 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496549, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284443,30284474,30284507,30284625,30284641,30284694,30284721,30284758,30284797,30284840,30284874,30284894,30284982,30285129,30285153,30285307,30285344,30285416,30285523,30285600,30285618,30285905,30286615,30286987,30288340,30288383,30288597,30288633,30288794,30288920,30289211,30289628,30289881,30290226,30290639,30291509,30291769,30292694,30292730,30293351,30294048,30294810,30295233,30295510,30295754,30296875,30297571,30297800,30304254,30305409,30305522,30305557,30305590,30305626,30305667,30305701,30305735,30305768,30305809,30305847,30305876,30305904,30305954,30305992,30306025,30306057,30306102,30306134,30306168,30306343,30306364,30306565,30306596,30306689,30306841,30307061,30307090,30307490,30307685,30308335,30308639,30308984,30309233,30309405,30309687,30310370,30310446,30311097,30311186,30312043,30312082,30312721,30313163,30313903,30314025,30323416,30323460,30323498,30323570,30323598,30323633,30323659,30323752,30323788,30323849,30323876,30323997,30324028,30324077,30324113,30324214,30324328,30324574,3032461 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496550, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284442,30284468,30284508,30284620,30284627,30284684,30284719,30284767,30284796,30284832,30284875,30284896,30284971,30285116,30285166,30285298,30285334,30285411,30285584,30285614,30286613,30286983,30288344,30288381,30288580,30288625,30288778,30288903,30289202,30289634,30289886,30290229,30290636,30293343,30294049,30295241,30295521,30295761,30296871,30297558,30297791,30304266,30305515,30305556,30305593,30305625,30305663,30305692,30305739,30305808,30305885,30305891,30305958,30305987,30306053,30306094,30306121,30306161,30306369,30306597,30306687,30306840,30307046,30307091,30307481,30307680,30308334,30308982,30309230,30309400,30309681,30310371,30310443,30311102,30311199,30312086,30312727,30313164,30313899,30314030,30323426,30323461,30323487,30323573,30323593,30323639,30323652,30323755,30323789,30323853,30324008,30324043,30324080,30324103,30324224,30324329,30324571,30324589,30324880,30324920,30325076,30325785,30325813,30326013,30326153,30326284,30326431,30326617,30326723,30326840,30327444,30327447,30328118,3032877 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496551, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284439,30284478,30284514,30284621,30284636,30284697,30284732,30284768,30284805,30284826,30284868,30284895,30284981,30285130,30285167,30285304,30285341,30285408,30285528,30285589,30285607,30285906,30286620,30286993,30288350,30288386,30288588,30288630,30288782,30288912,30289207,30289635,30289888,30290223,30290644,30291508,30291777,30292693,30292733,30293346,30294042,30294807,30295238,30295514,30295762,30296872,30297574,30297790,30304267,30305411,30305520,30305554,30305586,30305620,30305665,30305698,30305736,30305774,30305800,30305849,30305886,30305899,30305948,30305986,30306029,30306062,30306089,30306132,30306173,30306334,30306378,30306569,30306601,30306682,30306846,30307057,30307096,30307491,30307691,30308346,30308636,30308974,30309229,30309413,30309690,30310364,30310447,30311101,30311193,30312049,30312078,30312719,30313162,30313904,30314035,30323422,30323456,30323500,30323571,30323609,30323631,30323664,30323747,30323792,30323832,30323881,30324003,30324041,30324072,30324115,30324210,30324324,30324586,3032461 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496552, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284432,30284477,30284511,30284624,30284643,30284686,30284730,30284760,30284798,30284841,30284865,30284891,30284983,30285125,30285164,30285302,30285347,30285420,30285519,30285597,30285617,30285896,30286614,30286990,30288351,30288388,30288589,30288632,30288793,30288915,30289205,30289630,30289878,30290215,30290629,30291512,30291772,30292684,30292729,30293355,30294053,30294812,30295243,30295516,30295757,30296879,30297575,30297795,30304260,30305413,30305518,30305553,30305591,30305623,30305652,30305700,30305738,30305771,30305805,30305843,30305883,30305894,30305957,30305983,30306024,30306061,30306093,30306135,30306171,30306341,30306370,30306559,30306608,30306686,30306844,30307053,30307093,30307486,30307692,30308344,30308637,30308980,30309231,30309407,30309693,30310362,30310434,30311092,30311203,30312084,30312724,30313159,30313897,30314037,30323424,30323463,30323493,30323563,30323606,30323635,30323663,30323753,30323782,30323833,30323878,30324005,30324042,30324071,30324116,30324220,30324332,30324585,30324605,3032488 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496553, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284436,30284471,30284515,30284623,30284639,30284687,30284722,30284761,30284802,30284839,30284879,30284892,30284986,30285128,30285160,30285311,30285340,30285419,30285526,30285596,30285610,30285904,30286616,30286992,30288352,30288379,30288590,30288618,30288786,30288911,30289200,30289624,30289885,30290228,30290642,30291514,30291773,30292687,30292717,30293349,30294044,30294814,30295234,30295518,30295751,30296878,30297573,30297799,30304259,30305402,30305521,30305551,30305585,30305631,30305656,30305702,30305737,30305776,30305813,30305842,30305877,30305896,30305953,30305985,30306022,30306063,30306101,30306127,30306169,30306342,30306371,30306562,30306605,30306688,30306845,30307062,30307084,30307489,30307687,30308338,30308630,30308981,30309232,30309398,30309688,30310366,30310445,30311100,30311191,30312048,30312081,30312713,30313161,30313905,30314029,30323425,30323462,30323497,30323574,30323610,30323623,30323654,30323749,30323781,30323847,30323875,30323996,30324030,30324079,30324114,30324221,30324327,30324587,3032460 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496554, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284431,30284473,30284509,30284613,30284629,30284690,30284726,30284765,30284795,30284838,30284878,30284897,30284980,30285122,30285162,30285309,30285348,30285417,30285525,30285593,30285616,30285901,30286612,30286984,30288336,30288382,30288593,30288624,30288792,30288914,30289208,30289627,30289877,30290230,30290633,30291511,30291775,30292695,30292722,30293353,30294051,30294804,30295235,30295517,30295760,30296880,30297565,30304262,30305401,30305519,30305547,30305592,30305621,30305666,30305694,30305730,30305772,30305801,30305840,30305884,30305903,30305956,30305990,30306030,30306060,30306095,30306138,30306166,30306336,30306377,30306561,30306606,30306681,30306832,30307059,30307097,30307480,30307690,30308345,30308638,30308987,30309227,30310368,30311103,30311205,30312042,30312080,30312722,30313155,30313896,30314033,30323428,30323466,30323496,30323566,30323607,30323641,30323657,30323743,30323783,30323851,30323872,30324006,30324032,30324067,30324112,30324223,30324326,30324582,30324623,30324892,30324931,30325072,3032579 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30496548,30496549,30496550,30496551,30496552,30496553,30496554?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2026-02-01' and date <= '2026-02-28') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2266,),), 'unwanted_material_monthly_percentage': ((0.5182679042154106,),), 'material_repartition': (('incineration', 2242),), 'material_dict': {'incineration': 2242}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 1), 0.5045011478035957, 4), (datetime.date(2026, 2, 2), 0.5863584995700786, 3), (datetime.date(2026, 2, 3), 0.5944539689517075, 3), (datetime.date(2026, 2, 4), 0.551754460228643, 4), (datetime.date(2026, 2, 5), 0.4693990007482676, 2), (datetime.date(2026, 2, 6), 0.4820443924805212, 4), (datetime.date(2026, 2, 7), 0.4891050857653609, 4), (datetime.date(2026, 2, 8), 0.4541642763515844, 4), (datetime.date(2026, 2, 9), 0.4777981801055459, 3), (datetime.date(2026, 2, 10), 0.48045047370220345, 4), (datetime.date(2026, 2, 11), 0.4399495215374271, 4), (datetime.date(2026, 2, 12), 0.4918406534322611, 3), (datetime.date(2026, 2, 13), 0.488676934661029, 3), (datetime.date(2026, 2, 14), 0.5125855904873436, 3), (datetime.date(2026, 2, 15), 0.49378548993133675, 3), (datetime.date(2026, 2, 16), 0.5074246831965797, 3), (datetime.date(2026, 2, 17), 0.4255952378120972, 4), (datetime.date(2026, 2, 18), 0.3696099743339117, 3), (datetime.date(2026, 2, 19), 0.46559148615400603, 4), (datetime.date(2026, 2, 20), 0.46816498439593, 4), (datetime.date(2026, 2, 21), 0.505577694460779, 3), (datetime.date(2026, 2, 22), 0.56146875187593, 4), (datetime.date(2026, 2, 23), 0.7061706975189861, 4), (datetime.date(2026, 2, 24), 0.7160140035702065, 2), (datetime.date(2026, 2, 25), 0.6217965041046974, 4), (datetime.date(2026, 2, 26), 0.5855854377743865, 3), (datetime.date(2026, 2, 27), 0.5560932282040596, 2), (datetime.date(2026, 2, 28), 0.5476606716055046, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 2, 1), 0.5045011478035957, 4), (datetime.date(2026, 2, 2), 0.5863584995700786, 3), (datetime.date(2026, 2, 3), 0.5944539689517075, 3), (datetime.date(2026, 2, 4), 0.551754460228643, 4), (datetime.date(2026, 2, 5), 0.4693990007482676, 2), (datetime.date(2026, 2, 6), 0.4820443924805212, 4), (datetime.date(2026, 2, 7), 0.4891050857653609, 4), (datetime.date(2026, 2, 8), 0.4541642763515844, 4), (datetime.date(2026, 2, 9), 0.4777981801055459, 3), (datetime.date(2026, 2, 10), 0.48045047370220345, 4), (datetime.date(2026, 2, 11), 0.4399495215374271, 4), (datetime.date(2026, 2, 12), 0.4918406534322611, 3), (datetime.date(2026, 2, 13), 0.488676934661029, 3), (datetime.date(2026, 2, 14), 0.5125855904873436, 3), (datetime.date(2026, 2, 15), 0.49378548993133675, 3), (datetime.date(2026, 2, 16), 0.5074246831965797, 3), (datetime.date(2026, 2, 17), 0.4255952378120972, 4), (datetime.date(2026, 2, 18), 0.3696099743339117, 3), (datetime.date(2026, 2, 19), 0.46559148615400603, 4), (datetime.date(2026, 2, 20), 0.46816498439593, 4), (datetime.date(2026, 2, 21), 0.505577694460779, 3), (datetime.date(2026, 2, 22), 0.56146875187593, 4), (datetime.date(2026, 2, 23), 0.7061706975189861, 4), (datetime.date(2026, 2, 24), 0.7160140035702065, 2), (datetime.date(2026, 2, 25), 0.6217965041046974, 4), (datetime.date(2026, 2, 26), 0.5855854377743865, 3), (datetime.date(2026, 2, 27), 0.5560932282040596, 2), (datetime.date(2026, 2, 28), 0.5476606716055046, 1))}, 'quality_array': [['-8.356157940201003', '01022026'], ['-8.06634657555095', '02022026'], ['-8.25359871012922', '03022026'], ['-8.770308938422518', '04022026'], ['-8.136331749388788', '05022026'], ['-6.055377649416584', '06022026'], ['-6.864595080944836', '07022026'], ['-7.553815851689254', '08022026'], ['-8.365815311768062', '09022026'], ['-7.965931155270757', '10022026'], ['-7.853015061094285', '11022026'], ['-8.807149024587536', '12022026'], ['-8.681288446597641', '13022026'], ['-8.359444019661593', '14022026'], ['-8.366174557764472', '15022026'], ['-8.476324606442217', '16022026'], ['-8.181608973463504', '17022026'], ['-7.693294111834492', '18022026'], ['-8.322761123390979', '19022026'], ['-8.130015310380603', '20022026'], ['-8.360477586631562', '21022026'], ['-8.479908646971019', '22022026'], ['-8.476508776733187', '23022026'], ['-8.470881174609868', '24022026'], ['-8.075618450496165', '25022026'], ['-8.336797671988979', '26022026'], ['-8.243222135004839', '27022026'], ['-8.166762630445229', '28022026']], 'number_of_batch': ((666,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020734520107480375, 'nb_photo': 23634, 'list_port_cont': '30284430,30284466,30284504,30284611,30284628,30284695,30284728,30284769,30284800,30284835,30284871,30284889,30284973,30285118,30285154,30285310,30285343,30285413,30285511,30285590,30285613,30285890,30286619,30286977,30288341,30288371,30288596,30288621,30288784,30288913,30289201,30289633,30289883,30290216,30290640,30291506,30291771,30292685,30292718,30293345,30294050,30294801,30295242,30295512,30295748,30296865,30297567,30297794,30304256,30305396,30305517,30305542,30305581,30305628,30305664,30305696,30305732,30305762,30305802,30305844,30305880,30305890,30305947,30305988,30306015,30306052,30306096,30306129,30306164,30306340,30306374,30306570,30306602,30306672,30306829,30307052,30307089,30307487,30307688,30308339,30308628,30308978,30309228,30309397,30309698,30310373,30310440,30311096,30311183,30312045,30312072,30312720,30313165,30313889,30314028,30323429,30323449,30323486,30323562,30323605,30323614,30323662,30323744,30323787,30323834,30323877,30324002,30324044,30324069,30324100,30324216,30324317,30324577,3032461', 'assoc_port': '30284314:30285890,30284318:30285613,30284320:30285511,30284323:30285154,30284327:30284871,30284330:30284769,30284332:30285590,30284335:30284973,30284337:30285310,30284339:30285413,30284341:30284695,30284342:30285343,30284343:30285118,30284344:30284504,30284345:30284835,30284346:30284800,30284347:30284466,30284348:30284430,30284349:30284889,30284350:30284628,30284351:30284728,30284352:30284611,30286526:30286619,30286651:30286977,30288258:30288341,30288259:30288371,30288427:30288596,30288429:30288621,30288700:30288784,30288823:30288913,30288961:30289201,30289446:30289633,30289756:30289883,30290024:30290216,30290520:30290640,30291263:30291506,30291741:30291771,30292430:30292685,30292432:30292718,30293130:30293345,30293703:30294050,30294586:30294801,30294979:30295242,30295410:30295512,30295573:30295748,30295962:30296865,30297483:30297567,30297612:30297794,30303877:30304256,30305354:30306015,30305355:30306340,30305356:30306164,30305357:30306052,30305358:30306129,30305359:30305844,30305360:30306096,30305361:3030576', 'assoc_mat': '30284314:autre:4230:30285890,30284318:autre:4230:30285613,30284320:autre:4230:30285511,30284323:autre:4230:30285154,30284327:autre:4230:30284871,30284330:autre:4230:30284769,30284332:autre:4230:30285590,30284335:autre:4230:30284973,30284337:autre:4230:30285310,30284339:autre:4230:30285413,30284341:autre:4230:30284695,30284342:autre:4230:30285343,30284343:autre:4230:30285118,30284344:autre:4230:30284504,30284345:autre:4230:30284835,30284346:autre:4230:30284800,30284347:autre:4230:30284466,30284348:autre:4230:30284430,30284349:autre:4230:30284889,30284350:autre:4230:30284628,30284351:autre:4230:30284728,30284352:autre:4230:30284611,30286526:autre:4230:30286619,30286651:autre:4230:30286977,30288258:autre:4230:30288341,30288259:autre:4230:30288371,30288427:autre:4230:30288596,30288429:autre:4230:30288621,30288700:autre:4230:30288784,30288823:autre:4230:30288913,30288961:autre:4230:30289201,30289446:autre:4230:30289633,30289756:autre:4230:30289883,30290024:autre:4230:30290216,30290520:autre:4230:30290640,30291263:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.09131866063733568, 'nb_photo': 138822, 'list_port_cont': '30284443,30284474,30284507,30284625,30284641,30284694,30284721,30284758,30284797,30284840,30284874,30284894,30284982,30285129,30285153,30285307,30285344,30285416,30285523,30285600,30285618,30285905,30286615,30286987,30288340,30288383,30288597,30288633,30288794,30288920,30289211,30289628,30289881,30290226,30290639,30291509,30291769,30292694,30292730,30293351,30294048,30294810,30295233,30295510,30295754,30296875,30297571,30297800,30304254,30305409,30305522,30305557,30305590,30305626,30305667,30305701,30305735,30305768,30305809,30305847,30305876,30305904,30305954,30305992,30306025,30306057,30306102,30306134,30306168,30306343,30306364,30306565,30306596,30306689,30306841,30307061,30307090,30307490,30307685,30308335,30308639,30308984,30309233,30309405,30309687,30310370,30310446,30311097,30311186,30312043,30312082,30312721,30313163,30313903,30314025,30323416,30323460,30323498,30323570,30323598,30323633,30323659,30323752,30323788,30323849,30323876,30323997,30324028,30324077,30324113,30324214,30324328,30324574,3032461', 'assoc_port': '30284314:30285905,30284318:30285618,30284320:30285523,30284323:30285153,30284327:30284874,30284330:30284758,30284332:30285600,30284335:30284982,30284337:30285307,30284339:30285416,30284341:30284694,30284342:30285344,30284343:30285129,30284344:30284507,30284345:30284840,30284346:30284797,30284347:30284474,30284348:30284443,30284349:30284894,30284350:30284641,30284351:30284721,30284352:30284625,30286526:30286615,30286651:30286987,30288258:30288340,30288259:30288383,30288427:30288597,30288429:30288633,30288700:30288794,30288823:30288920,30288961:30289211,30289446:30289628,30289756:30289881,30290024:30290226,30290520:30290639,30291263:30291509,30291741:30291769,30292430:30292694,30292432:30292730,30293130:30293351,30293703:30294048,30294586:30294810,30294979:30295233,30295410:30295510,30295573:30295754,30295962:30296875,30297483:30297571,30297612:30297800,30303877:30304254,30305354:30306025,30305355:30306343,30305356:30306168,30305357:30306057,30305358:30306134,30305359:30305847,30305360:30306102,30305361:3030576', 'assoc_mat': '30284314:carton:4230:30285905,30284318:carton:4230:30285618,30284320:carton:4230:30285523,30284323:carton:4230:30285153,30284327:carton:4230:30284874,30284330:carton:4230:30284758,30284332:carton:4230:30285600,30284335:carton:4230:30284982,30284337:carton:4230:30285307,30284339:carton:4230:30285416,30284341:carton:4230:30284694,30284342:carton:4230:30285344,30284343:carton:4230:30285129,30284344:carton:4230:30284507,30284345:carton:4230:30284840,30284346:carton:4230:30284797,30284347:carton:4230:30284474,30284348:carton:4230:30284443,30284349:carton:4230:30284894,30284350:carton:4230:30284641,30284351:carton:4230:30284721,30284352:carton:4230:30284625,30286526:carton:4230:30286615,30286651:carton:4230:30286987,30288258:carton:4230:30288340,30288259:carton:4230:30288383,30288427:carton:4230:30288597,30288429:carton:4230:30288633,30288700:carton:4230:30288794,30288823:carton:4230:30288920,30288961:carton:4230:30289211,30289446:carton:4230:30289628,30289756:carton:4230:30289881,30290024:carton:4230:30290226,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017210538133663334, 'nb_photo': 1997, 'list_port_cont': '30284442,30284468,30284508,30284620,30284627,30284684,30284719,30284767,30284796,30284832,30284875,30284896,30284971,30285116,30285166,30285298,30285334,30285411,30285584,30285614,30286613,30286983,30288344,30288381,30288580,30288625,30288778,30288903,30289202,30289634,30289886,30290229,30290636,30293343,30294049,30295241,30295521,30295761,30296871,30297558,30297791,30304266,30305515,30305556,30305593,30305625,30305663,30305692,30305739,30305808,30305885,30305891,30305958,30305987,30306053,30306094,30306121,30306161,30306369,30306597,30306687,30306840,30307046,30307091,30307481,30307680,30308334,30308982,30309230,30309400,30309681,30310371,30310443,30311102,30311199,30312086,30312727,30313164,30313899,30314030,30323426,30323461,30323487,30323573,30323593,30323639,30323652,30323755,30323789,30323853,30324008,30324043,30324080,30324103,30324224,30324329,30324571,30324589,30324880,30324920,30325076,30325785,30325813,30326013,30326153,30326284,30326431,30326617,30326723,30326840,30327444,30327447,30328118,3032877', 'assoc_port': '30284318:30285614,30284323:30285166,30284327:30284875,30284330:30284767,30284332:30285584,30284335:30284971,30284337:30285298,30284339:30285411,30284341:30284684,30284342:30285334,30284343:30285116,30284344:30284508,30284345:30284832,30284346:30284796,30284347:30284468,30284348:30284442,30284349:30284896,30284350:30284627,30284351:30284719,30284352:30284620,30286526:30286613,30286651:30286983,30288258:30288344,30288259:30288381,30288427:30288580,30288429:30288625,30288700:30288778,30288823:30288903,30288961:30289202,30289446:30289634,30289756:30289886,30290024:30290229,30290520:30290636,30293130:30293343,30293703:30294049,30294979:30295241,30295410:30295521,30295573:30295761,30295962:30296871,30297483:30297558,30297612:30297791,30303877:30304266,30305356:30306161,30305357:30306053,30305358:30306121,30305360:30306094,30305362:30305958,30305363:30305885,30305364:30305987,30305366:30305891,30305368:30305556,30305369:30305692,30305370:30306369,30305371:30305593,30305372:30305808,30305373:30305515,30305374:3030573', 'assoc_mat': '30284318:metal:4230:30285614,30284323:metal:4230:30285166,30284327:metal:4230:30284875,30284330:metal:4230:30284767,30284332:metal:4230:30285584,30284335:metal:4230:30284971,30284337:metal:4230:30285298,30284339:metal:4230:30285411,30284341:metal:4230:30284684,30284342:metal:4230:30285334,30284343:metal:4230:30285116,30284344:metal:4230:30284508,30284345:metal:4230:30284832,30284346:metal:4230:30284796,30284347:metal:4230:30284468,30284348:metal:4230:30284442,30284349:metal:4230:30284896,30284350:metal:4230:30284627,30284351:metal:4230:30284719,30284352:metal:4230:30284620,30286526:metal:4230:30286613,30286651:metal:4230:30286983,30288258:metal:4230:30288344,30288259:metal:4230:30288381,30288427:metal:4230:30288580,30288429:metal:4230:30288625,30288700:metal:4230:30288778,30288823:metal:4230:30288903,30288961:metal:4230:30289202,30289446:metal:4230:30289634,30289756:metal:4230:30289886,30290024:metal:4230:30290229,30290520:metal:4230:30290636,30293130:metal:4230:30293343,30293703:metal:4230:30294049,30294979:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3656671724673985, 'nb_photo': 449884, 'list_port_cont': '30284439,30284478,30284514,30284621,30284636,30284697,30284732,30284768,30284805,30284826,30284868,30284895,30284981,30285130,30285167,30285304,30285341,30285408,30285528,30285589,30285607,30285906,30286620,30286993,30288350,30288386,30288588,30288630,30288782,30288912,30289207,30289635,30289888,30290223,30290644,30291508,30291777,30292693,30292733,30293346,30294042,30294807,30295238,30295514,30295762,30296872,30297574,30297790,30304267,30305411,30305520,30305554,30305586,30305620,30305665,30305698,30305736,30305774,30305800,30305849,30305886,30305899,30305948,30305986,30306029,30306062,30306089,30306132,30306173,30306334,30306378,30306569,30306601,30306682,30306846,30307057,30307096,30307491,30307691,30308346,30308636,30308974,30309229,30309413,30309690,30310364,30310447,30311101,30311193,30312049,30312078,30312719,30313162,30313904,30314035,30323422,30323456,30323500,30323571,30323609,30323631,30323664,30323747,30323792,30323832,30323881,30324003,30324041,30324072,30324115,30324210,30324324,30324586,3032461', 'assoc_port': '30284314:30285906,30284318:30285607,30284320:30285528,30284323:30285167,30284327:30284868,30284330:30284768,30284332:30285589,30284335:30284981,30284337:30285304,30284339:30285408,30284341:30284697,30284342:30285341,30284343:30285130,30284344:30284514,30284345:30284826,30284346:30284805,30284347:30284478,30284348:30284439,30284349:30284895,30284350:30284636,30284351:30284732,30284352:30284621,30286526:30286620,30286651:30286993,30288258:30288350,30288259:30288386,30288427:30288588,30288429:30288630,30288700:30288782,30288823:30288912,30288961:30289207,30289446:30289635,30289756:30289888,30290024:30290223,30290520:30290644,30291263:30291508,30291741:30291777,30292430:30292693,30292432:30292733,30293130:30293346,30293703:30294042,30294586:30294807,30294979:30295238,30295410:30295514,30295573:30295762,30295962:30296872,30297483:30297574,30297612:30297790,30303877:30304267,30305354:30306029,30305355:30306334,30305356:30306173,30305357:30306062,30305358:30306132,30305359:30305849,30305360:30306089,30305361:3030577', 'assoc_mat': '30284314:papier:4230:30285906,30284318:papier:4230:30285607,30284320:papier:4230:30285528,30284323:papier:4230:30285167,30284327:papier:4230:30284868,30284330:papier:4230:30284768,30284332:papier:4230:30285589,30284335:papier:4230:30284981,30284337:papier:4230:30285304,30284339:papier:4230:30285408,30284341:papier:4230:30284697,30284342:papier:4230:30285341,30284343:papier:4230:30285130,30284344:papier:4230:30284514,30284345:papier:4230:30284826,30284346:papier:4230:30284805,30284347:papier:4230:30284478,30284348:papier:4230:30284439,30284349:papier:4230:30284895,30284350:papier:4230:30284636,30284351:papier:4230:30284732,30284352:papier:4230:30284621,30286526:papier:4230:30286620,30286651:papier:4230:30286993,30288258:papier:4230:30288350,30288259:papier:4230:30288386,30288427:papier:4230:30288588,30288429:papier:4230:30288630,30288700:papier:4230:30288782,30288823:papier:4230:30288912,30288961:papier:4230:30289207,30289446:papier:4230:30289635,30289756:papier:4230:30289888,30290024:papier:4230:30290223,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006320417572341072, 'nb_photo': 7560, 'list_port_cont': '30284432,30284477,30284511,30284624,30284643,30284686,30284730,30284760,30284798,30284841,30284865,30284891,30284983,30285125,30285164,30285302,30285347,30285420,30285519,30285597,30285617,30285896,30286614,30286990,30288351,30288388,30288589,30288632,30288793,30288915,30289205,30289630,30289878,30290215,30290629,30291512,30291772,30292684,30292729,30293355,30294053,30294812,30295243,30295516,30295757,30296879,30297575,30297795,30304260,30305413,30305518,30305553,30305591,30305623,30305652,30305700,30305738,30305771,30305805,30305843,30305883,30305894,30305957,30305983,30306024,30306061,30306093,30306135,30306171,30306341,30306370,30306559,30306608,30306686,30306844,30307053,30307093,30307486,30307692,30308344,30308637,30308980,30309231,30309407,30309693,30310362,30310434,30311092,30311203,30312084,30312724,30313159,30313897,30314037,30323424,30323463,30323493,30323563,30323606,30323635,30323663,30323753,30323782,30323833,30323878,30324005,30324042,30324071,30324116,30324220,30324332,30324585,30324605,3032488', 'assoc_port': '30284314:30285896,30284318:30285617,30284320:30285519,30284323:30285164,30284327:30284865,30284330:30284760,30284332:30285597,30284335:30284983,30284337:30285302,30284339:30285420,30284341:30284686,30284342:30285347,30284343:30285125,30284344:30284511,30284345:30284841,30284346:30284798,30284347:30284477,30284348:30284432,30284349:30284891,30284350:30284643,30284351:30284730,30284352:30284624,30286526:30286614,30286651:30286990,30288258:30288351,30288259:30288388,30288427:30288589,30288429:30288632,30288700:30288793,30288823:30288915,30288961:30289205,30289446:30289630,30289756:30289878,30290024:30290215,30290520:30290629,30291263:30291512,30291741:30291772,30292430:30292684,30292432:30292729,30293130:30293355,30293703:30294053,30294586:30294812,30294979:30295243,30295410:30295516,30295573:30295757,30295962:30296879,30297483:30297575,30297612:30297795,30303877:30304260,30305354:30306024,30305355:30306341,30305356:30306171,30305357:30306061,30305358:30306135,30305359:30305843,30305360:30306093,30305361:3030577', 'assoc_mat': '30284314:pehd:4230:30285896,30284318:pehd:4230:30285617,30284320:pehd:4230:30285519,30284323:pehd:4230:30285164,30284327:pehd:4230:30284865,30284330:pehd:4230:30284760,30284332:pehd:4230:30285597,30284335:pehd:4230:30284983,30284337:pehd:4230:30285302,30284339:pehd:4230:30285420,30284341:pehd:4230:30284686,30284342:pehd:4230:30285347,30284343:pehd:4230:30285125,30284344:pehd:4230:30284511,30284345:pehd:4230:30284841,30284346:pehd:4230:30284798,30284347:pehd:4230:30284477,30284348:pehd:4230:30284432,30284349:pehd:4230:30284891,30284350:pehd:4230:30284643,30284351:pehd:4230:30284730,30284352:pehd:4230:30284624,30286526:pehd:4230:30286614,30286651:pehd:4230:30286990,30288258:pehd:4230:30288351,30288259:pehd:4230:30288388,30288427:pehd:4230:30288589,30288429:pehd:4230:30288632,30288700:pehd:4230:30288793,30288823:pehd:4230:30288915,30288961:pehd:4230:30289205,30289446:pehd:4230:30289630,30289756:pehd:4230:30289878,30290024:pehd:4230:30290215,30290520:pehd:4230:30290629,30291263:pehd:4230:30291512,30291741:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012740952680303444, 'nb_photo': 25829, 'list_port_cont': '30284436,30284471,30284515,30284623,30284639,30284687,30284722,30284761,30284802,30284839,30284879,30284892,30284986,30285128,30285160,30285311,30285340,30285419,30285526,30285596,30285610,30285904,30286616,30286992,30288352,30288379,30288590,30288618,30288786,30288911,30289200,30289624,30289885,30290228,30290642,30291514,30291773,30292687,30292717,30293349,30294044,30294814,30295234,30295518,30295751,30296878,30297573,30297799,30304259,30305402,30305521,30305551,30305585,30305631,30305656,30305702,30305737,30305776,30305813,30305842,30305877,30305896,30305953,30305985,30306022,30306063,30306101,30306127,30306169,30306342,30306371,30306562,30306605,30306688,30306845,30307062,30307084,30307489,30307687,30308338,30308630,30308981,30309232,30309398,30309688,30310366,30310445,30311100,30311191,30312048,30312081,30312713,30313161,30313905,30314029,30323425,30323462,30323497,30323574,30323610,30323623,30323654,30323749,30323781,30323847,30323875,30323996,30324030,30324079,30324114,30324221,30324327,30324587,3032460', 'assoc_port': '30284314:30285904,30284318:30285610,30284320:30285526,30284323:30285160,30284327:30284879,30284330:30284761,30284332:30285596,30284335:30284986,30284337:30285311,30284339:30285419,30284341:30284687,30284342:30285340,30284343:30285128,30284344:30284515,30284345:30284839,30284346:30284802,30284347:30284471,30284348:30284436,30284349:30284892,30284350:30284639,30284351:30284722,30284352:30284623,30286526:30286616,30286651:30286992,30288258:30288352,30288259:30288379,30288427:30288590,30288429:30288618,30288700:30288786,30288823:30288911,30288961:30289200,30289446:30289624,30289756:30289885,30290024:30290228,30290520:30290642,30291263:30291514,30291741:30291773,30292430:30292687,30292432:30292717,30293130:30293349,30293703:30294044,30294586:30294814,30294979:30295234,30295410:30295518,30295573:30295751,30295962:30296878,30297483:30297573,30297612:30297799,30303877:30304259,30305354:30306022,30305355:30306342,30305356:30306169,30305357:30306063,30305358:30306127,30305359:30305842,30305360:30306101,30305361:3030577', 'assoc_mat': '30284314:pet_clair:4230:30285904,30284318:pet_clair:4230:30285610,30284320:pet_clair:4230:30285526,30284323:pet_clair:4230:30285160,30284327:pet_clair:4230:30284879,30284330:pet_clair:4230:30284761,30284332:pet_clair:4230:30285596,30284335:pet_clair:4230:30284986,30284337:pet_clair:4230:30285311,30284339:pet_clair:4230:30285419,30284341:pet_clair:4230:30284687,30284342:pet_clair:4230:30285340,30284343:pet_clair:4230:30285128,30284344:pet_clair:4230:30284515,30284345:pet_clair:4230:30284839,30284346:pet_clair:4230:30284802,30284347:pet_clair:4230:30284471,30284348:pet_clair:4230:30284436,30284349:pet_clair:4230:30284892,30284350:pet_clair:4230:30284639,30284351:pet_clair:4230:30284722,30284352:pet_clair:4230:30284623,30286526:pet_clair:4230:30286616,30286651:pet_clair:4230:30286992,30288258:pet_clair:4230:30288352,30288259:pet_clair:4230:30288379,30288427:pet_clair:4230:30288590,30288429:pet_clair:4230:30288618,30288700:pet_clair:4230:30288786,30288823:pet_clair:4230:30288911,30288961:pet_clair:4230:30289200,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010513197748981509, 'nb_photo': 2538, 'list_port_cont': '30284431,30284473,30284509,30284613,30284629,30284690,30284726,30284765,30284795,30284838,30284878,30284897,30284980,30285122,30285162,30285309,30285348,30285417,30285525,30285593,30285616,30285901,30286612,30286984,30288336,30288382,30288593,30288624,30288792,30288914,30289208,30289627,30289877,30290230,30290633,30291511,30291775,30292695,30292722,30293353,30294051,30294804,30295235,30295517,30295760,30296880,30297565,30304262,30305401,30305519,30305547,30305592,30305621,30305666,30305694,30305730,30305772,30305801,30305840,30305884,30305903,30305956,30305990,30306030,30306060,30306095,30306138,30306166,30306336,30306377,30306561,30306606,30306681,30306832,30307059,30307097,30307480,30307690,30308345,30308638,30308987,30309227,30310368,30311103,30311205,30312042,30312080,30312722,30313155,30313896,30314033,30323428,30323466,30323496,30323566,30323607,30323641,30323657,30323743,30323783,30323851,30323872,30324006,30324032,30324067,30324112,30324223,30324326,30324582,30324623,30324892,30324931,30325072,3032579', 'assoc_port': '30284314:30285901,30284318:30285616,30284320:30285525,30284323:30285162,30284327:30284878,30284330:30284765,30284332:30285593,30284335:30284980,30284337:30285309,30284339:30285417,30284341:30284690,30284342:30285348,30284343:30285122,30284344:30284509,30284345:30284838,30284346:30284795,30284347:30284473,30284348:30284431,30284349:30284897,30284350:30284629,30284351:30284726,30284352:30284613,30286526:30286612,30286651:30286984,30288258:30288336,30288259:30288382,30288427:30288593,30288429:30288624,30288700:30288792,30288823:30288914,30288961:30289208,30289446:30289627,30289756:30289877,30290024:30290230,30290520:30290633,30291263:30291511,30291741:30291775,30292430:30292695,30292432:30292722,30293130:30293353,30293703:30294051,30294586:30294804,30294979:30295235,30295410:30295517,30295573:30295760,30295962:30296880,30297483:30297565,30303877:30304262,30305354:30306030,30305355:30306336,30305356:30306166,30305357:30306060,30305358:30306138,30305359:30305840,30305360:30306095,30305361:30305772,30305362:3030595', 'assoc_mat': '30284314:pet_fonce:4230:30285901,30284318:pet_fonce:4230:30285616,30284320:pet_fonce:4230:30285525,30284323:pet_fonce:4230:30285162,30284327:pet_fonce:4230:30284878,30284330:pet_fonce:4230:30284765,30284332:pet_fonce:4230:30285593,30284335:pet_fonce:4230:30284980,30284337:pet_fonce:4230:30285309,30284339:pet_fonce:4230:30285417,30284341:pet_fonce:4230:30284690,30284342:pet_fonce:4230:30285348,30284343:pet_fonce:4230:30285122,30284344:pet_fonce:4230:30284509,30284345:pet_fonce:4230:30284838,30284346:pet_fonce:4230:30284795,30284347:pet_fonce:4230:30284473,30284348:pet_fonce:4230:30284431,30284349:pet_fonce:4230:30284897,30284350:pet_fonce:4230:30284629,30284351:pet_fonce:4230:30284726,30284352:pet_fonce:4230:30284613,30286526:pet_fonce:4230:30286612,30286651:pet_fonce:4230:30286984,30288258:pet_fonce:4230:30288336,30288259:pet_fonce:4230:30288382,30288427:pet_fonce:4230:30288593,30288429:pet_fonce:4230:30288624,30288700:pet_fonce:4230:30288792,30288823:pet_fonce:4230:30288914,30288961:pet_fonce:4230:30289208,3'}), 'main_stat': {'nb_photos': 2266}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30496548,30496549,30496550,30496551,30496552,30496553,30496554?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-02', 0.5182679042154106),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2266,),), 'unwanted_material_monthly_percentage': ((0.5182679042154106,),), 'material_repartition': (('incineration', 2242),), 'material_dict': {'incineration': 2242}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 1), 0.5045011478035957, 4), (datetime.date(2026, 2, 2), 0.5863584995700786, 3), (datetime.date(2026, 2, 3), 0.5944539689517075, 3), (datetime.date(2026, 2, 4), 0.551754460228643, 4), (datetime.date(2026, 2, 5), 0.4693990007482676, 2), (datetime.date(2026, 2, 6), 0.4820443924805212, 4), (datetime.date(2026, 2, 7), 0.4891050857653609, 4), (datetime.date(2026, 2, 8), 0.4541642763515844, 4), (datetime.date(2026, 2, 9), 0.4777981801055459, 3), (datetime.date(2026, 2, 10), 0.48045047370220345, 4), (datetime.date(2026, 2, 11), 0.4399495215374271, 4), (datetime.date(2026, 2, 12), 0.4918406534322611, 3), (datetime.date(2026, 2, 13), 0.488676934661029, 3), (datetime.date(2026, 2, 14), 0.5125855904873436, 3), (datetime.date(2026, 2, 15), 0.49378548993133675, 3), (datetime.date(2026, 2, 16), 0.5074246831965797, 3), (datetime.date(2026, 2, 17), 0.4255952378120972, 4), (datetime.date(2026, 2, 18), 0.3696099743339117, 3), (datetime.date(2026, 2, 19), 0.46559148615400603, 4), (datetime.date(2026, 2, 20), 0.46816498439593, 4), (datetime.date(2026, 2, 21), 0.505577694460779, 3), (datetime.date(2026, 2, 22), 0.56146875187593, 4), (datetime.date(2026, 2, 23), 0.7061706975189861, 4), (datetime.date(2026, 2, 24), 0.7160140035702065, 2), (datetime.date(2026, 2, 25), 0.6217965041046974, 4), (datetime.date(2026, 2, 26), 0.5855854377743865, 3), (datetime.date(2026, 2, 27), 0.5560932282040596, 2), (datetime.date(2026, 2, 28), 0.5476606716055046, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 2, 1), 0.5045011478035957, 4), (datetime.date(2026, 2, 2), 0.5863584995700786, 3), (datetime.date(2026, 2, 3), 0.5944539689517075, 3), (datetime.date(2026, 2, 4), 0.551754460228643, 4), (datetime.date(2026, 2, 5), 0.4693990007482676, 2), (datetime.date(2026, 2, 6), 0.4820443924805212, 4), (datetime.date(2026, 2, 7), 0.4891050857653609, 4), (datetime.date(2026, 2, 8), 0.4541642763515844, 4), (datetime.date(2026, 2, 9), 0.4777981801055459, 3), (datetime.date(2026, 2, 10), 0.48045047370220345, 4), (datetime.date(2026, 2, 11), 0.4399495215374271, 4), (datetime.date(2026, 2, 12), 0.4918406534322611, 3), (datetime.date(2026, 2, 13), 0.488676934661029, 3), (datetime.date(2026, 2, 14), 0.5125855904873436, 3), (datetime.date(2026, 2, 15), 0.49378548993133675, 3), (datetime.date(2026, 2, 16), 0.5074246831965797, 3), (datetime.date(2026, 2, 17), 0.4255952378120972, 4), (datetime.date(2026, 2, 18), 0.3696099743339117, 3), (datetime.date(2026, 2, 19), 0.46559148615400603, 4), (datetime.date(2026, 2, 20), 0.46816498439593, 4), (datetime.date(2026, 2, 21), 0.505577694460779, 3), (datetime.date(2026, 2, 22), 0.56146875187593, 4), (datetime.date(2026, 2, 23), 0.7061706975189861, 4), (datetime.date(2026, 2, 24), 0.7160140035702065, 2), (datetime.date(2026, 2, 25), 0.6217965041046974, 4), (datetime.date(2026, 2, 26), 0.5855854377743865, 3), (datetime.date(2026, 2, 27), 0.5560932282040596, 2), (datetime.date(2026, 2, 28), 0.5476606716055046, 1))}, 'quality_array': [['-8.356157940201003', '01022026'], ['-8.06634657555095', '02022026'], ['-8.25359871012922', '03022026'], ['-8.770308938422518', '04022026'], ['-8.136331749388788', '05022026'], ['-6.055377649416584', '06022026'], ['-6.864595080944836', '07022026'], ['-7.553815851689254', '08022026'], ['-8.365815311768062', '09022026'], ['-7.965931155270757', '10022026'], ['-7.853015061094285', '11022026'], ['-8.807149024587536', '12022026'], ['-8.681288446597641', '13022026'], ['-8.359444019661593', '14022026'], ['-8.366174557764472', '15022026'], ['-8.476324606442217', '16022026'], ['-8.181608973463504', '17022026'], ['-7.693294111834492', '18022026'], ['-8.322761123390979', '19022026'], ['-8.130015310380603', '20022026'], ['-8.360477586631562', '21022026'], ['-8.479908646971019', '22022026'], ['-8.476508776733187', '23022026'], ['-8.470881174609868', '24022026'], ['-8.075618450496165', '25022026'], ['-8.336797671988979', '26022026'], ['-8.243222135004839', '27022026'], ['-8.166762630445229', '28022026']], 'number_of_batch': ((666,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020734520107480375, 'nb_photo': 23634, 'list_port_cont': '30284430,30284466,30284504,30284611,30284628,30284695,30284728,30284769,30284800,30284835,30284871,30284889,30284973,30285118,30285154,30285310,30285343,30285413,30285511,30285590,30285613,30285890,30286619,30286977,30288341,30288371,30288596,30288621,30288784,30288913,30289201,30289633,30289883,30290216,30290640,30291506,30291771,30292685,30292718,30293345,30294050,30294801,30295242,30295512,30295748,30296865,30297567,30297794,30304256,30305396,30305517,30305542,30305581,30305628,30305664,30305696,30305732,30305762,30305802,30305844,30305880,30305890,30305947,30305988,30306015,30306052,30306096,30306129,30306164,30306340,30306374,30306570,30306602,30306672,30306829,30307052,30307089,30307487,30307688,30308339,30308628,30308978,30309228,30309397,30309698,30310373,30310440,30311096,30311183,30312045,30312072,30312720,30313165,30313889,30314028,30323429,30323449,30323486,30323562,30323605,30323614,30323662,30323744,30323787,30323834,30323877,30324002,30324044,30324069,30324100,30324216,30324317,30324577,3032461', 'assoc_port': '30284314:30285890,30284318:30285613,30284320:30285511,30284323:30285154,30284327:30284871,30284330:30284769,30284332:30285590,30284335:30284973,30284337:30285310,30284339:30285413,30284341:30284695,30284342:30285343,30284343:30285118,30284344:30284504,30284345:30284835,30284346:30284800,30284347:30284466,30284348:30284430,30284349:30284889,30284350:30284628,30284351:30284728,30284352:30284611,30286526:30286619,30286651:30286977,30288258:30288341,30288259:30288371,30288427:30288596,30288429:30288621,30288700:30288784,30288823:30288913,30288961:30289201,30289446:30289633,30289756:30289883,30290024:30290216,30290520:30290640,30291263:30291506,30291741:30291771,30292430:30292685,30292432:30292718,30293130:30293345,30293703:30294050,30294586:30294801,30294979:30295242,30295410:30295512,30295573:30295748,30295962:30296865,30297483:30297567,30297612:30297794,30303877:30304256,30305354:30306015,30305355:30306340,30305356:30306164,30305357:30306052,30305358:30306129,30305359:30305844,30305360:30306096,30305361:3030576', 'assoc_mat': '30284314:autre:4230:30285890,30284318:autre:4230:30285613,30284320:autre:4230:30285511,30284323:autre:4230:30285154,30284327:autre:4230:30284871,30284330:autre:4230:30284769,30284332:autre:4230:30285590,30284335:autre:4230:30284973,30284337:autre:4230:30285310,30284339:autre:4230:30285413,30284341:autre:4230:30284695,30284342:autre:4230:30285343,30284343:autre:4230:30285118,30284344:autre:4230:30284504,30284345:autre:4230:30284835,30284346:autre:4230:30284800,30284347:autre:4230:30284466,30284348:autre:4230:30284430,30284349:autre:4230:30284889,30284350:autre:4230:30284628,30284351:autre:4230:30284728,30284352:autre:4230:30284611,30286526:autre:4230:30286619,30286651:autre:4230:30286977,30288258:autre:4230:30288341,30288259:autre:4230:30288371,30288427:autre:4230:30288596,30288429:autre:4230:30288621,30288700:autre:4230:30288784,30288823:autre:4230:30288913,30288961:autre:4230:30289201,30289446:autre:4230:30289633,30289756:autre:4230:30289883,30290024:autre:4230:30290216,30290520:autre:4230:30290640,30291263:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.09131866063733568, 'nb_photo': 138822, 'list_port_cont': '30284443,30284474,30284507,30284625,30284641,30284694,30284721,30284758,30284797,30284840,30284874,30284894,30284982,30285129,30285153,30285307,30285344,30285416,30285523,30285600,30285618,30285905,30286615,30286987,30288340,30288383,30288597,30288633,30288794,30288920,30289211,30289628,30289881,30290226,30290639,30291509,30291769,30292694,30292730,30293351,30294048,30294810,30295233,30295510,30295754,30296875,30297571,30297800,30304254,30305409,30305522,30305557,30305590,30305626,30305667,30305701,30305735,30305768,30305809,30305847,30305876,30305904,30305954,30305992,30306025,30306057,30306102,30306134,30306168,30306343,30306364,30306565,30306596,30306689,30306841,30307061,30307090,30307490,30307685,30308335,30308639,30308984,30309233,30309405,30309687,30310370,30310446,30311097,30311186,30312043,30312082,30312721,30313163,30313903,30314025,30323416,30323460,30323498,30323570,30323598,30323633,30323659,30323752,30323788,30323849,30323876,30323997,30324028,30324077,30324113,30324214,30324328,30324574,3032461', 'assoc_port': '30284314:30285905,30284318:30285618,30284320:30285523,30284323:30285153,30284327:30284874,30284330:30284758,30284332:30285600,30284335:30284982,30284337:30285307,30284339:30285416,30284341:30284694,30284342:30285344,30284343:30285129,30284344:30284507,30284345:30284840,30284346:30284797,30284347:30284474,30284348:30284443,30284349:30284894,30284350:30284641,30284351:30284721,30284352:30284625,30286526:30286615,30286651:30286987,30288258:30288340,30288259:30288383,30288427:30288597,30288429:30288633,30288700:30288794,30288823:30288920,30288961:30289211,30289446:30289628,30289756:30289881,30290024:30290226,30290520:30290639,30291263:30291509,30291741:30291769,30292430:30292694,30292432:30292730,30293130:30293351,30293703:30294048,30294586:30294810,30294979:30295233,30295410:30295510,30295573:30295754,30295962:30296875,30297483:30297571,30297612:30297800,30303877:30304254,30305354:30306025,30305355:30306343,30305356:30306168,30305357:30306057,30305358:30306134,30305359:30305847,30305360:30306102,30305361:3030576', 'assoc_mat': '30284314:carton:4230:30285905,30284318:carton:4230:30285618,30284320:carton:4230:30285523,30284323:carton:4230:30285153,30284327:carton:4230:30284874,30284330:carton:4230:30284758,30284332:carton:4230:30285600,30284335:carton:4230:30284982,30284337:carton:4230:30285307,30284339:carton:4230:30285416,30284341:carton:4230:30284694,30284342:carton:4230:30285344,30284343:carton:4230:30285129,30284344:carton:4230:30284507,30284345:carton:4230:30284840,30284346:carton:4230:30284797,30284347:carton:4230:30284474,30284348:carton:4230:30284443,30284349:carton:4230:30284894,30284350:carton:4230:30284641,30284351:carton:4230:30284721,30284352:carton:4230:30284625,30286526:carton:4230:30286615,30286651:carton:4230:30286987,30288258:carton:4230:30288340,30288259:carton:4230:30288383,30288427:carton:4230:30288597,30288429:carton:4230:30288633,30288700:carton:4230:30288794,30288823:carton:4230:30288920,30288961:carton:4230:30289211,30289446:carton:4230:30289628,30289756:carton:4230:30289881,30290024:carton:4230:30290226,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0017210538133663334, 'nb_photo': 1997, 'list_port_cont': '30284442,30284468,30284508,30284620,30284627,30284684,30284719,30284767,30284796,30284832,30284875,30284896,30284971,30285116,30285166,30285298,30285334,30285411,30285584,30285614,30286613,30286983,30288344,30288381,30288580,30288625,30288778,30288903,30289202,30289634,30289886,30290229,30290636,30293343,30294049,30295241,30295521,30295761,30296871,30297558,30297791,30304266,30305515,30305556,30305593,30305625,30305663,30305692,30305739,30305808,30305885,30305891,30305958,30305987,30306053,30306094,30306121,30306161,30306369,30306597,30306687,30306840,30307046,30307091,30307481,30307680,30308334,30308982,30309230,30309400,30309681,30310371,30310443,30311102,30311199,30312086,30312727,30313164,30313899,30314030,30323426,30323461,30323487,30323573,30323593,30323639,30323652,30323755,30323789,30323853,30324008,30324043,30324080,30324103,30324224,30324329,30324571,30324589,30324880,30324920,30325076,30325785,30325813,30326013,30326153,30326284,30326431,30326617,30326723,30326840,30327444,30327447,30328118,3032877', 'assoc_port': '30284318:30285614,30284323:30285166,30284327:30284875,30284330:30284767,30284332:30285584,30284335:30284971,30284337:30285298,30284339:30285411,30284341:30284684,30284342:30285334,30284343:30285116,30284344:30284508,30284345:30284832,30284346:30284796,30284347:30284468,30284348:30284442,30284349:30284896,30284350:30284627,30284351:30284719,30284352:30284620,30286526:30286613,30286651:30286983,30288258:30288344,30288259:30288381,30288427:30288580,30288429:30288625,30288700:30288778,30288823:30288903,30288961:30289202,30289446:30289634,30289756:30289886,30290024:30290229,30290520:30290636,30293130:30293343,30293703:30294049,30294979:30295241,30295410:30295521,30295573:30295761,30295962:30296871,30297483:30297558,30297612:30297791,30303877:30304266,30305356:30306161,30305357:30306053,30305358:30306121,30305360:30306094,30305362:30305958,30305363:30305885,30305364:30305987,30305366:30305891,30305368:30305556,30305369:30305692,30305370:30306369,30305371:30305593,30305372:30305808,30305373:30305515,30305374:3030573', 'assoc_mat': '30284318:metal:4230:30285614,30284323:metal:4230:30285166,30284327:metal:4230:30284875,30284330:metal:4230:30284767,30284332:metal:4230:30285584,30284335:metal:4230:30284971,30284337:metal:4230:30285298,30284339:metal:4230:30285411,30284341:metal:4230:30284684,30284342:metal:4230:30285334,30284343:metal:4230:30285116,30284344:metal:4230:30284508,30284345:metal:4230:30284832,30284346:metal:4230:30284796,30284347:metal:4230:30284468,30284348:metal:4230:30284442,30284349:metal:4230:30284896,30284350:metal:4230:30284627,30284351:metal:4230:30284719,30284352:metal:4230:30284620,30286526:metal:4230:30286613,30286651:metal:4230:30286983,30288258:metal:4230:30288344,30288259:metal:4230:30288381,30288427:metal:4230:30288580,30288429:metal:4230:30288625,30288700:metal:4230:30288778,30288823:metal:4230:30288903,30288961:metal:4230:30289202,30289446:metal:4230:30289634,30289756:metal:4230:30289886,30290024:metal:4230:30290229,30290520:metal:4230:30290636,30293130:metal:4230:30293343,30293703:metal:4230:30294049,30294979:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3656671724673985, 'nb_photo': 449884, 'list_port_cont': '30284439,30284478,30284514,30284621,30284636,30284697,30284732,30284768,30284805,30284826,30284868,30284895,30284981,30285130,30285167,30285304,30285341,30285408,30285528,30285589,30285607,30285906,30286620,30286993,30288350,30288386,30288588,30288630,30288782,30288912,30289207,30289635,30289888,30290223,30290644,30291508,30291777,30292693,30292733,30293346,30294042,30294807,30295238,30295514,30295762,30296872,30297574,30297790,30304267,30305411,30305520,30305554,30305586,30305620,30305665,30305698,30305736,30305774,30305800,30305849,30305886,30305899,30305948,30305986,30306029,30306062,30306089,30306132,30306173,30306334,30306378,30306569,30306601,30306682,30306846,30307057,30307096,30307491,30307691,30308346,30308636,30308974,30309229,30309413,30309690,30310364,30310447,30311101,30311193,30312049,30312078,30312719,30313162,30313904,30314035,30323422,30323456,30323500,30323571,30323609,30323631,30323664,30323747,30323792,30323832,30323881,30324003,30324041,30324072,30324115,30324210,30324324,30324586,3032461', 'assoc_port': '30284314:30285906,30284318:30285607,30284320:30285528,30284323:30285167,30284327:30284868,30284330:30284768,30284332:30285589,30284335:30284981,30284337:30285304,30284339:30285408,30284341:30284697,30284342:30285341,30284343:30285130,30284344:30284514,30284345:30284826,30284346:30284805,30284347:30284478,30284348:30284439,30284349:30284895,30284350:30284636,30284351:30284732,30284352:30284621,30286526:30286620,30286651:30286993,30288258:30288350,30288259:30288386,30288427:30288588,30288429:30288630,30288700:30288782,30288823:30288912,30288961:30289207,30289446:30289635,30289756:30289888,30290024:30290223,30290520:30290644,30291263:30291508,30291741:30291777,30292430:30292693,30292432:30292733,30293130:30293346,30293703:30294042,30294586:30294807,30294979:30295238,30295410:30295514,30295573:30295762,30295962:30296872,30297483:30297574,30297612:30297790,30303877:30304267,30305354:30306029,30305355:30306334,30305356:30306173,30305357:30306062,30305358:30306132,30305359:30305849,30305360:30306089,30305361:3030577', 'assoc_mat': '30284314:papier:4230:30285906,30284318:papier:4230:30285607,30284320:papier:4230:30285528,30284323:papier:4230:30285167,30284327:papier:4230:30284868,30284330:papier:4230:30284768,30284332:papier:4230:30285589,30284335:papier:4230:30284981,30284337:papier:4230:30285304,30284339:papier:4230:30285408,30284341:papier:4230:30284697,30284342:papier:4230:30285341,30284343:papier:4230:30285130,30284344:papier:4230:30284514,30284345:papier:4230:30284826,30284346:papier:4230:30284805,30284347:papier:4230:30284478,30284348:papier:4230:30284439,30284349:papier:4230:30284895,30284350:papier:4230:30284636,30284351:papier:4230:30284732,30284352:papier:4230:30284621,30286526:papier:4230:30286620,30286651:papier:4230:30286993,30288258:papier:4230:30288350,30288259:papier:4230:30288386,30288427:papier:4230:30288588,30288429:papier:4230:30288630,30288700:papier:4230:30288782,30288823:papier:4230:30288912,30288961:papier:4230:30289207,30289446:papier:4230:30289635,30289756:papier:4230:30289888,30290024:papier:4230:30290223,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006320417572341072, 'nb_photo': 7560, 'list_port_cont': '30284432,30284477,30284511,30284624,30284643,30284686,30284730,30284760,30284798,30284841,30284865,30284891,30284983,30285125,30285164,30285302,30285347,30285420,30285519,30285597,30285617,30285896,30286614,30286990,30288351,30288388,30288589,30288632,30288793,30288915,30289205,30289630,30289878,30290215,30290629,30291512,30291772,30292684,30292729,30293355,30294053,30294812,30295243,30295516,30295757,30296879,30297575,30297795,30304260,30305413,30305518,30305553,30305591,30305623,30305652,30305700,30305738,30305771,30305805,30305843,30305883,30305894,30305957,30305983,30306024,30306061,30306093,30306135,30306171,30306341,30306370,30306559,30306608,30306686,30306844,30307053,30307093,30307486,30307692,30308344,30308637,30308980,30309231,30309407,30309693,30310362,30310434,30311092,30311203,30312084,30312724,30313159,30313897,30314037,30323424,30323463,30323493,30323563,30323606,30323635,30323663,30323753,30323782,30323833,30323878,30324005,30324042,30324071,30324116,30324220,30324332,30324585,30324605,3032488', 'assoc_port': '30284314:30285896,30284318:30285617,30284320:30285519,30284323:30285164,30284327:30284865,30284330:30284760,30284332:30285597,30284335:30284983,30284337:30285302,30284339:30285420,30284341:30284686,30284342:30285347,30284343:30285125,30284344:30284511,30284345:30284841,30284346:30284798,30284347:30284477,30284348:30284432,30284349:30284891,30284350:30284643,30284351:30284730,30284352:30284624,30286526:30286614,30286651:30286990,30288258:30288351,30288259:30288388,30288427:30288589,30288429:30288632,30288700:30288793,30288823:30288915,30288961:30289205,30289446:30289630,30289756:30289878,30290024:30290215,30290520:30290629,30291263:30291512,30291741:30291772,30292430:30292684,30292432:30292729,30293130:30293355,30293703:30294053,30294586:30294812,30294979:30295243,30295410:30295516,30295573:30295757,30295962:30296879,30297483:30297575,30297612:30297795,30303877:30304260,30305354:30306024,30305355:30306341,30305356:30306171,30305357:30306061,30305358:30306135,30305359:30305843,30305360:30306093,30305361:3030577', 'assoc_mat': '30284314:pehd:4230:30285896,30284318:pehd:4230:30285617,30284320:pehd:4230:30285519,30284323:pehd:4230:30285164,30284327:pehd:4230:30284865,30284330:pehd:4230:30284760,30284332:pehd:4230:30285597,30284335:pehd:4230:30284983,30284337:pehd:4230:30285302,30284339:pehd:4230:30285420,30284341:pehd:4230:30284686,30284342:pehd:4230:30285347,30284343:pehd:4230:30285125,30284344:pehd:4230:30284511,30284345:pehd:4230:30284841,30284346:pehd:4230:30284798,30284347:pehd:4230:30284477,30284348:pehd:4230:30284432,30284349:pehd:4230:30284891,30284350:pehd:4230:30284643,30284351:pehd:4230:30284730,30284352:pehd:4230:30284624,30286526:pehd:4230:30286614,30286651:pehd:4230:30286990,30288258:pehd:4230:30288351,30288259:pehd:4230:30288388,30288427:pehd:4230:30288589,30288429:pehd:4230:30288632,30288700:pehd:4230:30288793,30288823:pehd:4230:30288915,30288961:pehd:4230:30289205,30289446:pehd:4230:30289630,30289756:pehd:4230:30289878,30290024:pehd:4230:30290215,30290520:pehd:4230:30290629,30291263:pehd:4230:30291512,30291741:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012740952680303444, 'nb_photo': 25829, 'list_port_cont': '30284436,30284471,30284515,30284623,30284639,30284687,30284722,30284761,30284802,30284839,30284879,30284892,30284986,30285128,30285160,30285311,30285340,30285419,30285526,30285596,30285610,30285904,30286616,30286992,30288352,30288379,30288590,30288618,30288786,30288911,30289200,30289624,30289885,30290228,30290642,30291514,30291773,30292687,30292717,30293349,30294044,30294814,30295234,30295518,30295751,30296878,30297573,30297799,30304259,30305402,30305521,30305551,30305585,30305631,30305656,30305702,30305737,30305776,30305813,30305842,30305877,30305896,30305953,30305985,30306022,30306063,30306101,30306127,30306169,30306342,30306371,30306562,30306605,30306688,30306845,30307062,30307084,30307489,30307687,30308338,30308630,30308981,30309232,30309398,30309688,30310366,30310445,30311100,30311191,30312048,30312081,30312713,30313161,30313905,30314029,30323425,30323462,30323497,30323574,30323610,30323623,30323654,30323749,30323781,30323847,30323875,30323996,30324030,30324079,30324114,30324221,30324327,30324587,3032460', 'assoc_port': '30284314:30285904,30284318:30285610,30284320:30285526,30284323:30285160,30284327:30284879,30284330:30284761,30284332:30285596,30284335:30284986,30284337:30285311,30284339:30285419,30284341:30284687,30284342:30285340,30284343:30285128,30284344:30284515,30284345:30284839,30284346:30284802,30284347:30284471,30284348:30284436,30284349:30284892,30284350:30284639,30284351:30284722,30284352:30284623,30286526:30286616,30286651:30286992,30288258:30288352,30288259:30288379,30288427:30288590,30288429:30288618,30288700:30288786,30288823:30288911,30288961:30289200,30289446:30289624,30289756:30289885,30290024:30290228,30290520:30290642,30291263:30291514,30291741:30291773,30292430:30292687,30292432:30292717,30293130:30293349,30293703:30294044,30294586:30294814,30294979:30295234,30295410:30295518,30295573:30295751,30295962:30296878,30297483:30297573,30297612:30297799,30303877:30304259,30305354:30306022,30305355:30306342,30305356:30306169,30305357:30306063,30305358:30306127,30305359:30305842,30305360:30306101,30305361:3030577', 'assoc_mat': '30284314:pet_clair:4230:30285904,30284318:pet_clair:4230:30285610,30284320:pet_clair:4230:30285526,30284323:pet_clair:4230:30285160,30284327:pet_clair:4230:30284879,30284330:pet_clair:4230:30284761,30284332:pet_clair:4230:30285596,30284335:pet_clair:4230:30284986,30284337:pet_clair:4230:30285311,30284339:pet_clair:4230:30285419,30284341:pet_clair:4230:30284687,30284342:pet_clair:4230:30285340,30284343:pet_clair:4230:30285128,30284344:pet_clair:4230:30284515,30284345:pet_clair:4230:30284839,30284346:pet_clair:4230:30284802,30284347:pet_clair:4230:30284471,30284348:pet_clair:4230:30284436,30284349:pet_clair:4230:30284892,30284350:pet_clair:4230:30284639,30284351:pet_clair:4230:30284722,30284352:pet_clair:4230:30284623,30286526:pet_clair:4230:30286616,30286651:pet_clair:4230:30286992,30288258:pet_clair:4230:30288352,30288259:pet_clair:4230:30288379,30288427:pet_clair:4230:30288590,30288429:pet_clair:4230:30288618,30288700:pet_clair:4230:30288786,30288823:pet_clair:4230:30288911,30288961:pet_clair:4230:30289200,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010513197748981509, 'nb_photo': 2538, 'list_port_cont': '30284431,30284473,30284509,30284613,30284629,30284690,30284726,30284765,30284795,30284838,30284878,30284897,30284980,30285122,30285162,30285309,30285348,30285417,30285525,30285593,30285616,30285901,30286612,30286984,30288336,30288382,30288593,30288624,30288792,30288914,30289208,30289627,30289877,30290230,30290633,30291511,30291775,30292695,30292722,30293353,30294051,30294804,30295235,30295517,30295760,30296880,30297565,30304262,30305401,30305519,30305547,30305592,30305621,30305666,30305694,30305730,30305772,30305801,30305840,30305884,30305903,30305956,30305990,30306030,30306060,30306095,30306138,30306166,30306336,30306377,30306561,30306606,30306681,30306832,30307059,30307097,30307480,30307690,30308345,30308638,30308987,30309227,30310368,30311103,30311205,30312042,30312080,30312722,30313155,30313896,30314033,30323428,30323466,30323496,30323566,30323607,30323641,30323657,30323743,30323783,30323851,30323872,30324006,30324032,30324067,30324112,30324223,30324326,30324582,30324623,30324892,30324931,30325072,3032579', 'assoc_port': '30284314:30285901,30284318:30285616,30284320:30285525,30284323:30285162,30284327:30284878,30284330:30284765,30284332:30285593,30284335:30284980,30284337:30285309,30284339:30285417,30284341:30284690,30284342:30285348,30284343:30285122,30284344:30284509,30284345:30284838,30284346:30284795,30284347:30284473,30284348:30284431,30284349:30284897,30284350:30284629,30284351:30284726,30284352:30284613,30286526:30286612,30286651:30286984,30288258:30288336,30288259:30288382,30288427:30288593,30288429:30288624,30288700:30288792,30288823:30288914,30288961:30289208,30289446:30289627,30289756:30289877,30290024:30290230,30290520:30290633,30291263:30291511,30291741:30291775,30292430:30292695,30292432:30292722,30293130:30293353,30293703:30294051,30294586:30294804,30294979:30295235,30295410:30295517,30295573:30295760,30295962:30296880,30297483:30297565,30303877:30304262,30305354:30306030,30305355:30306336,30305356:30306166,30305357:30306060,30305358:30306138,30305359:30305840,30305360:30306095,30305361:30305772,30305362:3030595', 'assoc_mat': '30284314:pet_fonce:4230:30285901,30284318:pet_fonce:4230:30285616,30284320:pet_fonce:4230:30285525,30284323:pet_fonce:4230:30285162,30284327:pet_fonce:4230:30284878,30284330:pet_fonce:4230:30284765,30284332:pet_fonce:4230:30285593,30284335:pet_fonce:4230:30284980,30284337:pet_fonce:4230:30285309,30284339:pet_fonce:4230:30285417,30284341:pet_fonce:4230:30284690,30284342:pet_fonce:4230:30285348,30284343:pet_fonce:4230:30285122,30284344:pet_fonce:4230:30284509,30284345:pet_fonce:4230:30284838,30284346:pet_fonce:4230:30284795,30284347:pet_fonce:4230:30284473,30284348:pet_fonce:4230:30284431,30284349:pet_fonce:4230:30284897,30284350:pet_fonce:4230:30284629,30284351:pet_fonce:4230:30284726,30284352:pet_fonce:4230:30284613,30286526:pet_fonce:4230:30286612,30286651:pet_fonce:4230:30286984,30288258:pet_fonce:4230:30288336,30288259:pet_fonce:4230:30288382,30288427:pet_fonce:4230:30288593,30288429:pet_fonce:4230:30288624,30288700:pet_fonce:4230:30288792,30288823:pet_fonce:4230:30288914,30288961:pet_fonce:4230:30289208,3'}), 'main_stat': {'nb_photos': 2266}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30496548,30496549,30496550,30496551,30496552,30496553,30496554?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-02', 0.5182679042154106),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_02_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.07%', 23634], 'carton': ['carton', '9.13%', 138822], 'metal': ['metal', '0.17%', 1997], 'papier': ['papier', '36.57%', 449884], 'pehd': ['pehd', '0.63%', 7560], 'pet_clair': ['pet_clair', '1.27%', 25829], 'pet_fonce': ['pet_fonce', '1.05%', 2538]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_02_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.39user 2.67system 0:12.11elapsed 41%CPU (0avgtext+0avgdata 182896maxresident)k 8inputs+320outputs (0major+48604minor)pagefaults 0swaps