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-09 _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 : (1, 30) 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 : (1, 30) 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 : 09 mtr_id : dashboard_places : SCCU_cam8 date : 2026-09 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-09%') and created_at like '%2026-09%'))); nb_day : (1, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 09 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) = 09 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 '%092026%' and cps.thcl = 1533 GROUP BY sbstr ; Erreur dans le nom de portfolio du batch invalid literal for int() with base 10: 'SCCU' after number_of_batch date_start : 2026-09-01 : dt_date_just_month_year : 2026-09-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-09-01" AND ded.date <= "2026-09-30" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (2993824,2994602,2995344,2995938,2996586,2997138,2997732,2998402,2999060,2999684,3000348,3000750,3001104,3001524,3001986,3002510,3003116,3003742,3004304,3004756,3005302,3005956,3006584,3007254,3007850,3008430,3008802,3009350,3009778,3010480) 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.02492065915790676, 'nb_photo': 20829, 'list_port_cont': '31100496,31100686,31100962,31101165,31101432,31101668,31101711,31102169,31102513,31102615,31103089,31103216,31103472,31103669,31103935,31104261,31104496,31104750,31105027,31105356,31105394,31105648,31105695,31105723,31106251,31106404,31106683,31106888,31107190,31107359,31107591,31107879,31108169,31108428,31108591,31108972,31109293,31109470,31109811,31110112,31110314,31110521,31110696,31110946,31111151,31111356,31111569,31111597,31112114,31112308,31112517,31112618,31112908,31113195,31113438,31113665,31114081,31114322,31114612,31114814,31115103,31115151,31115408,31115678,31116063,31116351,31116584,31116785,31116995,31117032,31117321,31117522,31117830,31118032,31118233,31118445,31118527,31118792,31119023,31119223,31119475,31119516,31119930,31119968,31120388,31120580,31120853,31121067,31121566,31121607,31121768,31122081,31122288,31122622,31122956,31123116,31123196,31123488,31123747,31123983,31124196,31124454,31124700,31124958,31125210,31125444,31125721,31125913,31127251,31127295,31127347,31127392,31127439,3112748', 'assoc_port': '31100292:31100496,31100524:31100686,31100756:31100962,31100994:31101165,31101211:31101432,31101505:31101711,31101506:31101668,31101983:31102169,31102273:31102513,31102536:31102615,31102788:31103089,31102984:31103216,31103195:31103472,31103492:31103669,31103773:31103935,31104045:31104261,31104285:31104496,31104465:31105356,31104564:31104750,31104732:31105027,31105015:31105648,31105224:31105394,31105471:31105723,31105472:31105695,31106052:31106251,31106286:31106404,31106482:31106683,31106719:31106888,31106969:31107190,31107225:31107359,31107406:31107591,31107671:31107879,31107941:31108169,31108212:31108428,31108472:31108591,31108787:31108972,31109140:31109293,31109325:31109470,31109636:31109811,31109876:31110112,31110052:31110314,31110053:31110521,31110509:31110696,31110727:31110946,31110937:31111151,31111223:31111356,31111494:31111597,31111513:31111569,31111921:31112114,31112155:31112308,31112356:31112517,31112557:31112618,31112732:31112908,31113025:31113195,31113238:31113438,31113490:31113665,31113869:3111408', 'assoc_mat': '31100292:autre:4230:31100496,31100524:autre:4230:31100686,31100756:autre:4230:31100962,31100994:autre:4230:31101165,31101211:autre:4230:31101432,31101505:autre:4230:31101711,31101506:autre:4230:31101668,31101983:autre:4230:31102169,31102273:autre:4230:31102513,31102536:autre:4230:31102615,31102788:autre:4230:31103089,31102984:autre:4230:31103216,31103195:autre:4230:31103472,31103492:autre:4230:31103669,31103773:autre:4230:31103935,31104045:autre:4230:31104261,31104285:autre:4230:31104496,31104465:autre:4230:31105356,31104564:autre:4230:31104750,31104732:autre:4230:31105027,31105015:autre:4230:31105648,31105224:autre:4230:31105394,31105471:autre:4230:31105723,31105472:autre:4230:31105695,31106052:autre:4230:31106251,31106286:autre:4230:31106404,31106482:autre:4230:31106683,31106719:autre:4230:31106888,31106969:autre:4230:31107190,31107225:autre:4230:31107359,31107406:autre:4230:31107591,31107671:autre:4230:31107879,31107941:autre:4230:31108169,31108212:autre:4230:31108428,31108472:autre:4230:31108591,31108787:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.126716316504713, 'nb_photo': 139769, 'list_port_cont': '31100487,31100689,31100949,31101166,31101426,31101666,31101708,31102171,31102511,31102618,31103103,31103211,31103459,31103666,31103934,31104251,31104504,31104749,31105033,31105357,31105409,31105646,31105690,31105729,31106257,31106415,31106688,31106894,31107192,31107365,31107585,31107886,31108177,31108431,31108598,31108966,31109303,31109483,31109812,31110122,31110323,31110520,31110707,31110955,31111156,31111357,31111562,31111606,31112123,31112312,31112525,31112613,31112917,31113189,31113455,31113660,31114084,31114336,31114615,31114809,31115099,31115150,31115409,31115688,31116069,31116358,31116594,31116789,31116984,31117031,31117315,31117529,31117842,31118031,31118221,31118442,31118520,31118793,31119032,31119228,31119477,31119524,31119932,31119972,31120385,31120581,31120840,31121062,31121574,31121619,31121766,31122083,31122281,31122623,31122964,31123113,31123206,31123495,31123745,31123979,31124199,31124448,31124710,31124957,31125199,31125450,31125726,31125914,31127247,31127311,31127342,31127399,31127443,3112747', 'assoc_port': '31100292:31100487,31100524:31100689,31100756:31100949,31100994:31101166,31101211:31101426,31101505:31101708,31101506:31101666,31101983:31102171,31102273:31102511,31102536:31102618,31102788:31103103,31102984:31103211,31103195:31103459,31103492:31103666,31103773:31103934,31104045:31104251,31104285:31104504,31104465:31105357,31104564:31104749,31104732:31105033,31105015:31105646,31105224:31105409,31105471:31105729,31105472:31105690,31106052:31106257,31106286:31106415,31106482:31106688,31106719:31106894,31106969:31107192,31107225:31107365,31107406:31107585,31107671:31107886,31107941:31108177,31108212:31108431,31108472:31108598,31108787:31108966,31109140:31109303,31109325:31109483,31109636:31109812,31109876:31110122,31110052:31110323,31110053:31110520,31110509:31110707,31110727:31110955,31110937:31111156,31111223:31111357,31111494:31111606,31111513:31111562,31111921:31112123,31112155:31112312,31112356:31112525,31112557:31112613,31112732:31112917,31113025:31113189,31113238:31113455,31113490:31113660,31113869:3111408', 'assoc_mat': '31100292:carton:4230:31100487,31100524:carton:4230:31100689,31100756:carton:4230:31100949,31100994:carton:4230:31101166,31101211:carton:4230:31101426,31101505:carton:4230:31101708,31101506:carton:4230:31101666,31101983:carton:4230:31102171,31102273:carton:4230:31102511,31102536:carton:4230:31102618,31102788:carton:4230:31103103,31102984:carton:4230:31103211,31103195:carton:4230:31103459,31103492:carton:4230:31103666,31103773:carton:4230:31103934,31104045:carton:4230:31104251,31104285:carton:4230:31104504,31104465:carton:4230:31105357,31104564:carton:4230:31104749,31104732:carton:4230:31105033,31105015:carton:4230:31105646,31105224:carton:4230:31105409,31105471:carton:4230:31105729,31105472:carton:4230:31105690,31106052:carton:4230:31106257,31106286:carton:4230:31106415,31106482:carton:4230:31106688,31106719:carton:4230:31106894,31106969:carton:4230:31107192,31107225:carton:4230:31107365,31107406:carton:4230:31107585,31107671:carton:4230:31107886,31107941:carton:4230:31108177,31108212:carton:4230:31108431,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001896369468195011, 'nb_photo': 1864, 'list_port_cont': '31100483,31100676,31100947,31101167,31101417,31101699,31102507,31102617,31103104,31103670,31103929,31104264,31104505,31104740,31105036,31105360,31105728,31106247,31106418,31106684,31106887,31107187,31107352,31107576,31108162,31108429,31108594,31108971,31109289,31109481,31109804,31110114,31110325,31110941,31111153,31111599,31112325,31114339,31114624,31114805,31115110,31115152,31115394,31115680,31116066,31116350,31116583,31116786,31116999,31117033,31117513,31117836,31118029,31118437,31118528,31118799,31119026,31119221,31119482,31119519,31119936,31119974,31120379,31120586,31120841,31121576,31121771,31122618,31122954,31123109,31123198,31123487,31123740,31123980,31124188,31124439,31124695,31124941,31125194,31125451,31125723,31125899,31127246,31127298,31127332,31127391,31127429,31127476,31127973,31128025,31128057,31128098,31128132,31128481,31128559,31128769,31128888,31129203,31129635,31129775,31130120,31130382,31130669,31130698,31130773,31131176,31131388,31131557,31131656,31131879,31132134,31132632,31132695,3113273', 'assoc_port': '31100292:31100483,31100524:31100676,31100756:31100947,31100994:31101167,31101211:31101417,31101505:31101699,31102273:31102507,31102536:31102617,31102788:31103104,31103492:31103670,31103773:31103929,31104045:31104264,31104285:31104505,31104465:31105360,31104564:31104740,31104732:31105036,31105471:31105728,31106052:31106247,31106286:31106418,31106482:31106684,31106719:31106887,31106969:31107187,31107225:31107352,31107406:31107576,31107941:31108162,31108212:31108429,31108472:31108594,31108787:31108971,31109140:31109289,31109325:31109481,31109636:31109804,31109876:31110114,31110052:31110325,31110727:31110941,31110937:31111153,31111494:31111599,31112155:31112325,31114149:31114339,31114410:31114624,31114678:31114805,31114854:31115110,31115083:31115152,31115337:31115394,31115613:31115680,31115901:31116066,31116142:31116350,31116386:31116583,31116625:31116786,31116827:31117033,31116828:31116999,31117471:31117513,31117563:31117836,31117867:31118029,31118331:31118437,31118332:31118528,31118471:31118799,31118862:3111902', 'assoc_mat': '31100292:metal:4230:31100483,31100524:metal:4230:31100676,31100756:metal:4230:31100947,31100994:metal:4230:31101167,31101211:metal:4230:31101417,31101505:metal:4230:31101699,31102273:metal:4230:31102507,31102536:metal:4230:31102617,31102788:metal:4230:31103104,31103492:metal:4230:31103670,31103773:metal:4230:31103929,31104045:metal:4230:31104264,31104285:metal:4230:31104505,31104465:metal:4230:31105360,31104564:metal:4230:31104740,31104732:metal:4230:31105036,31105471:metal:4230:31105728,31106052:metal:4230:31106247,31106286:metal:4230:31106418,31106482:metal:4230:31106684,31106719:metal:4230:31106887,31106969:metal:4230:31107187,31107225:metal:4230:31107352,31107406:metal:4230:31107576,31107941:metal:4230:31108162,31108212:metal:4230:31108429,31108472:metal:4230:31108594,31108787:metal:4230:31108971,31109140:metal:4230:31109289,31109325:metal:4230:31109481,31109636:metal:4230:31109804,31109876:metal:4230:31110114,31110052:metal:4230:31110325,31110727:metal:4230:31110941,31110937:metal:4230:31111153,31111494:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3423925832918199, 'nb_photo': 332399, 'list_port_cont': '31100494,31100677,31100960,31101174,31101423,31101673,31101713,31102168,31102510,31102610,31103102,31103219,31103457,31103663,31103939,31104263,31104497,31104738,31105035,31105359,31105400,31105645,31105691,31105733,31106248,31106406,31106689,31106884,31107189,31107367,31107586,31107890,31108172,31108440,31108596,31108974,31109294,31109482,31109815,31110127,31110331,31110526,31110698,31110952,31111159,31111362,31111561,31111609,31112119,31112321,31112526,31112606,31112911,31113201,31113447,31113662,31114075,31114338,31114618,31114811,31115113,31115153,31115406,31115691,31116072,31116345,31116596,31116781,31116994,31117035,31117323,31117527,31117843,31118026,31118234,31118446,31118519,31118790,31119025,31119235,31119473,31119511,31119931,31119970,31120383,31120587,31120849,31121063,31121580,31121622,31121767,31122078,31122286,31122621,31122968,31123123,31123205,31123497,31123746,31123990,31124187,31124452,31124709,31124950,31125206,31125453,31125724,31125916,31127249,31127308,31127344,31127400,31127436,3112748', 'assoc_port': '31100292:31100494,31100524:31100677,31100756:31100960,31100994:31101174,31101211:31101423,31101505:31101713,31101506:31101673,31101983:31102168,31102273:31102510,31102536:31102610,31102788:31103102,31102984:31103219,31103195:31103457,31103492:31103663,31103773:31103939,31104045:31104263,31104285:31104497,31104465:31105359,31104564:31104738,31104732:31105035,31105015:31105645,31105224:31105400,31105471:31105733,31105472:31105691,31106052:31106248,31106286:31106406,31106482:31106689,31106719:31106884,31106969:31107189,31107225:31107367,31107406:31107586,31107671:31107890,31107941:31108172,31108212:31108440,31108472:31108596,31108787:31108974,31109140:31109294,31109325:31109482,31109636:31109815,31109876:31110127,31110052:31110331,31110053:31110526,31110509:31110698,31110727:31110952,31110937:31111159,31111223:31111362,31111494:31111609,31111513:31111561,31111921:31112119,31112155:31112321,31112356:31112526,31112557:31112606,31112732:31112911,31113025:31113201,31113238:31113447,31113490:31113662,31113869:3111407', 'assoc_mat': '31100292:papier:4230:31100494,31100524:papier:4230:31100677,31100756:papier:4230:31100960,31100994:papier:4230:31101174,31101211:papier:4230:31101423,31101505:papier:4230:31101713,31101506:papier:4230:31101673,31101983:papier:4230:31102168,31102273:papier:4230:31102510,31102536:papier:4230:31102610,31102788:papier:4230:31103102,31102984:papier:4230:31103219,31103195:papier:4230:31103457,31103492:papier:4230:31103663,31103773:papier:4230:31103939,31104045:papier:4230:31104263,31104285:papier:4230:31104497,31104465:papier:4230:31105359,31104564:papier:4230:31104738,31104732:papier:4230:31105035,31105015:papier:4230:31105645,31105224:papier:4230:31105400,31105471:papier:4230:31105733,31105472:papier:4230:31105691,31106052:papier:4230:31106248,31106286:papier:4230:31106406,31106482:papier:4230:31106689,31106719:papier:4230:31106884,31106969:papier:4230:31107189,31107225:papier:4230:31107367,31107406:papier:4230:31107586,31107671:papier:4230:31107890,31107941:papier:4230:31108172,31108212:papier:4230:31108440,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007380863903897634, 'nb_photo': 5370, 'list_port_cont': '31100492,31100955,31101169,31101428,31101705,31102167,31102620,31103098,31103937,31104256,31104499,31104746,31105030,31105358,31105403,31105635,31105694,31105726,31106259,31106414,31106687,31106892,31107184,31107364,31107587,31107894,31108174,31108438,31108595,31108981,31109296,31109479,31109819,31110123,31110319,31110524,31112126,31112314,31112523,31112604,31112920,31113203,31113451,31113659,31114079,31114337,31114620,31114804,31115115,31115156,31115694,31116068,31116593,31116998,31117530,31117839,31118523,31118794,31119029,31119229,31119481,31119522,31119979,31120393,31120596,31120845,31121571,31121621,31121770,31122289,31122614,31122957,31123124,31123209,31123494,31123748,31124193,31124455,31124707,31124951,31125202,31125455,31125722,31125912,31127244,31127309,31127336,31127394,31127445,31127484,31127976,31128026,31128062,31128104,31128147,31128494,31128570,31128785,31128885,31129131,31129197,31129662,31129778,31130139,31130385,31130675,31130711,31130782,31131175,31131394,31131561,31131645,31131874,3113214', 'assoc_port': '31100292:31100492,31100756:31100955,31100994:31101169,31101211:31101428,31101505:31101705,31101983:31102167,31102536:31102620,31102788:31103098,31103773:31103937,31104045:31104256,31104285:31104499,31104465:31105358,31104564:31104746,31104732:31105030,31105015:31105635,31105224:31105403,31105471:31105726,31105472:31105694,31106052:31106259,31106286:31106414,31106482:31106687,31106719:31106892,31106969:31107184,31107225:31107364,31107406:31107587,31107671:31107894,31107941:31108174,31108212:31108438,31108472:31108595,31108787:31108981,31109140:31109296,31109325:31109479,31109636:31109819,31109876:31110123,31110052:31110319,31110053:31110524,31111921:31112126,31112155:31112314,31112356:31112523,31112557:31112604,31112732:31112920,31113025:31113203,31113238:31113451,31113490:31113659,31113869:31114079,31114149:31114337,31114410:31114620,31114678:31114804,31114854:31115115,31115083:31115156,31115613:31115694,31115901:31116068,31116386:31116593,31116828:31116998,31117471:31117530,31117563:31117839,31118332:3111852', 'assoc_mat': '31100292:pehd:4230:31100492,31100756:pehd:4230:31100955,31100994:pehd:4230:31101169,31101211:pehd:4230:31101428,31101505:pehd:4230:31101705,31101983:pehd:4230:31102167,31102536:pehd:4230:31102620,31102788:pehd:4230:31103098,31103773:pehd:4230:31103937,31104045:pehd:4230:31104256,31104285:pehd:4230:31104499,31104465:pehd:4230:31105358,31104564:pehd:4230:31104746,31104732:pehd:4230:31105030,31105015:pehd:4230:31105635,31105224:pehd:4230:31105403,31105471:pehd:4230:31105726,31105472:pehd:4230:31105694,31106052:pehd:4230:31106259,31106286:pehd:4230:31106414,31106482:pehd:4230:31106687,31106719:pehd:4230:31106892,31106969:pehd:4230:31107184,31107225:pehd:4230:31107364,31107406:pehd:4230:31107587,31107671:pehd:4230:31107894,31107941:pehd:4230:31108174,31108212:pehd:4230:31108438,31108472:pehd:4230:31108595,31108787:pehd:4230:31108981,31109140:pehd:4230:31109296,31109325:pehd:4230:31109479,31109636:pehd:4230:31109819,31109876:pehd:4230:31110123,31110052:pehd:4230:31110319,31110053:pehd:4230:31110524,31111921:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011166584722419793, 'nb_photo': 17698, 'list_port_cont': '31100484,31100691,31100957,31101170,31101431,31101674,31101701,31102170,31102500,31102616,31103094,31103214,31103467,31103665,31103938,31104257,31104506,31104751,31105034,31105350,31105402,31105638,31105688,31105721,31106261,31106413,31106682,31106882,31107186,31107366,31107588,31107887,31108178,31108442,31108599,31108977,31109297,31109475,31109814,31110126,31110330,31110523,31110701,31110958,31111155,31111369,31111563,31111605,31112129,31112323,31112522,31112617,31112913,31113200,31113445,31113664,31114074,31114335,31114616,31114817,31115114,31115154,31115402,31115681,31116060,31116355,31116591,31116782,31116992,31117029,31117313,31117518,31117831,31118033,31118232,31118441,31118526,31118798,31119017,31119230,31119480,31119512,31119929,31119976,31120392,31120594,31120851,31121065,31121572,31121615,31121769,31122082,31122282,31122608,31122967,31123121,31123197,31123496,31123751,31123989,31124200,31124453,31124705,31124952,31125209,31125448,31125714,31125907,31127242,31127310,31127340,31127395,31127438,3112749', 'assoc_port': '31100292:31100484,31100524:31100691,31100756:31100957,31100994:31101170,31101211:31101431,31101505:31101701,31101506:31101674,31101983:31102170,31102273:31102500,31102536:31102616,31102788:31103094,31102984:31103214,31103195:31103467,31103492:31103665,31103773:31103938,31104045:31104257,31104285:31104506,31104465:31105350,31104564:31104751,31104732:31105034,31105015:31105638,31105224:31105402,31105471:31105721,31105472:31105688,31106052:31106261,31106286:31106413,31106482:31106682,31106719:31106882,31106969:31107186,31107225:31107366,31107406:31107588,31107671:31107887,31107941:31108178,31108212:31108442,31108472:31108599,31108787:31108977,31109140:31109297,31109325:31109475,31109636:31109814,31109876:31110126,31110052:31110330,31110053:31110523,31110509:31110701,31110727:31110958,31110937:31111155,31111223:31111369,31111494:31111605,31111513:31111563,31111921:31112129,31112155:31112323,31112356:31112522,31112557:31112617,31112732:31112913,31113025:31113200,31113238:31113445,31113490:31113664,31113869:3111407', 'assoc_mat': '31100292:pet_clair:4230:31100484,31100524:pet_clair:4230:31100691,31100756:pet_clair:4230:31100957,31100994:pet_clair:4230:31101170,31101211:pet_clair:4230:31101431,31101505:pet_clair:4230:31101701,31101506:pet_clair:4230:31101674,31101983:pet_clair:4230:31102170,31102273:pet_clair:4230:31102500,31102536:pet_clair:4230:31102616,31102788:pet_clair:4230:31103094,31102984:pet_clair:4230:31103214,31103195:pet_clair:4230:31103467,31103492:pet_clair:4230:31103665,31103773:pet_clair:4230:31103938,31104045:pet_clair:4230:31104257,31104285:pet_clair:4230:31104506,31104465:pet_clair:4230:31105350,31104564:pet_clair:4230:31104751,31104732:pet_clair:4230:31105034,31105015:pet_clair:4230:31105638,31105224:pet_clair:4230:31105402,31105471:pet_clair:4230:31105721,31105472:pet_clair:4230:31105688,31106052:pet_clair:4230:31106261,31106286:pet_clair:4230:31106413,31106482:pet_clair:4230:31106682,31106719:pet_clair:4230:31106882,31106969:pet_clair:4230:31107186,31107225:pet_clair:4230:31107366,31107406:pet_clair:4230:31107588,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005500565632600825, 'nb_photo': 1298, 'list_port_cont': '31101716,31102159,31102512,31102607,31103096,31103208,31103470,31103668,31104258,31104502,31104744,31105031,31105355,31105408,31105644,31105692,31106252,31106681,31106891,31107194,31107360,31107889,31108436,31108979,31109302,31109474,31109817,31110117,31110529,31110945,31111158,31111371,31112322,31112614,31114625,31114818,31115107,31115155,31115689,31117023,31118018,31118229,31118449,31118513,31118789,31119030,31119521,31120390,31120584,31120843,31121764,31122076,31122283,31122619,31122965,31123744,31123993,31124447,31124704,31124956,31125203,31125447,31125725,31125908,31127250,31127306,31127337,31127397,31127442,31127485,31127981,31128028,31128067,31128110,31128148,31128483,31128568,31128780,31128882,31129640,31129769,31130122,31130375,31130674,31130697,31130775,31131187,31131397,31131569,31131647,31131884,31132146,31132633,31132699,31132736,31132776,31132815,31132865,31132909,31132949,31132985,31133056,31133088,31134200,31134240,31134324,31134357,31134713,31135302,31135680,31135971,31136056,31136316,3113660', 'assoc_port': '31101505:31101716,31101983:31102159,31102273:31102512,31102536:31102607,31102788:31103096,31102984:31103208,31103195:31103470,31103492:31103668,31104045:31104258,31104285:31104502,31104465:31105355,31104564:31104744,31104732:31105031,31105015:31105644,31105224:31105408,31105472:31105692,31106052:31106252,31106482:31106681,31106719:31106891,31106969:31107194,31107225:31107360,31107671:31107889,31108212:31108436,31108787:31108979,31109140:31109302,31109325:31109474,31109636:31109817,31109876:31110117,31110053:31110529,31110727:31110945,31110937:31111158,31111223:31111371,31112155:31112322,31112557:31112614,31114410:31114625,31114678:31114818,31114854:31115107,31115083:31115155,31115613:31115689,31116827:31117023,31117867:31118018,31118063:31118229,31118331:31118449,31118332:31118513,31118471:31118789,31118862:31119030,31119310:31119521,31120181:31120390,31120426:31120584,31120635:31120843,31121557:31121764,31121878:31122076,31122118:31122283,31122363:31122619,31122766:31122965,31123533:31123744,31123781:3112399', 'assoc_mat': '31101505:pet_fonce:4230:31101716,31101983:pet_fonce:4230:31102159,31102273:pet_fonce:4230:31102512,31102536:pet_fonce:4230:31102607,31102788:pet_fonce:4230:31103096,31102984:pet_fonce:4230:31103208,31103195:pet_fonce:4230:31103470,31103492:pet_fonce:4230:31103668,31104045:pet_fonce:4230:31104258,31104285:pet_fonce:4230:31104502,31104465:pet_fonce:4230:31105355,31104564:pet_fonce:4230:31104744,31104732:pet_fonce:4230:31105031,31105015:pet_fonce:4230:31105644,31105224:pet_fonce:4230:31105408,31105472:pet_fonce:4230:31105692,31106052:pet_fonce:4230:31106252,31106482:pet_fonce:4230:31106681,31106719:pet_fonce:4230:31106891,31106969:pet_fonce:4230:31107194,31107225:pet_fonce:4230:31107360,31107671:pet_fonce:4230:31107889,31108212:pet_fonce:4230:31108436,31108787:pet_fonce:4230:31108979,31109140:pet_fonce:4230:31109302,31109325:pet_fonce:4230:31109474,31109636:pet_fonce:4230:31109817,31109876:pet_fonce:4230:31110117,31110053:pet_fonce:4230:31110529,31110727:pet_fonce:4230:31110945,31110937:pet_fonce:4230:31111158,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(2993824,2994602,2995344,2995938,2996586,2997138,2997732,2998402,2999060,2999684,3000348,3000750,3001104,3001524,3001986,3002510,3003116,3003742,3004304,3004756,3005302,3005956,3006584,3007254,3007850,3008430,3008802,3009350,3009778,3010480)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195441, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100496,31100686,31100962,31101165,31101432,31101668,31101711,31102169,31102513,31102615,31103089,31103216,31103472,31103669,31103935,31104261,31104496,31104750,31105027,31105356,31105394,31105648,31105695,31105723,31106251,31106404,31106683,31106888,31107190,31107359,31107591,31107879,31108169,31108428,31108591,31108972,31109293,31109470,31109811,31110112,31110314,31110521,31110696,31110946,31111151,31111356,31111569,31111597,31112114,31112308,31112517,31112618,31112908,31113195,31113438,31113665,31114081,31114322,31114612,31114814,31115103,31115151,31115408,31115678,31116063,31116351,31116584,31116785,31116995,31117032,31117321,31117522,31117830,31118032,31118233,31118445,31118527,31118792,31119023,31119223,31119475,31119516,31119930,31119968,31120388,31120580,31120853,31121067,31121566,31121607,31121768,31122081,31122288,31122622,31122956,31123116,31123196,31123488,31123747,31123983,31124196,31124454,31124700,31124958,31125210,31125444,31125721,31125913,31127251,31127295,31127347,31127392,31127439,3112748 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195442, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100487,31100689,31100949,31101166,31101426,31101666,31101708,31102171,31102511,31102618,31103103,31103211,31103459,31103666,31103934,31104251,31104504,31104749,31105033,31105357,31105409,31105646,31105690,31105729,31106257,31106415,31106688,31106894,31107192,31107365,31107585,31107886,31108177,31108431,31108598,31108966,31109303,31109483,31109812,31110122,31110323,31110520,31110707,31110955,31111156,31111357,31111562,31111606,31112123,31112312,31112525,31112613,31112917,31113189,31113455,31113660,31114084,31114336,31114615,31114809,31115099,31115150,31115409,31115688,31116069,31116358,31116594,31116789,31116984,31117031,31117315,31117529,31117842,31118031,31118221,31118442,31118520,31118793,31119032,31119228,31119477,31119524,31119932,31119972,31120385,31120581,31120840,31121062,31121574,31121619,31121766,31122083,31122281,31122623,31122964,31123113,31123206,31123495,31123745,31123979,31124199,31124448,31124710,31124957,31125199,31125450,31125726,31125914,31127247,31127311,31127342,31127399,31127443,3112747 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195443, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100483,31100676,31100947,31101167,31101417,31101699,31102507,31102617,31103104,31103670,31103929,31104264,31104505,31104740,31105036,31105360,31105728,31106247,31106418,31106684,31106887,31107187,31107352,31107576,31108162,31108429,31108594,31108971,31109289,31109481,31109804,31110114,31110325,31110941,31111153,31111599,31112325,31114339,31114624,31114805,31115110,31115152,31115394,31115680,31116066,31116350,31116583,31116786,31116999,31117033,31117513,31117836,31118029,31118437,31118528,31118799,31119026,31119221,31119482,31119519,31119936,31119974,31120379,31120586,31120841,31121576,31121771,31122618,31122954,31123109,31123198,31123487,31123740,31123980,31124188,31124439,31124695,31124941,31125194,31125451,31125723,31125899,31127246,31127298,31127332,31127391,31127429,31127476,31127973,31128025,31128057,31128098,31128132,31128481,31128559,31128769,31128888,31129203,31129635,31129775,31130120,31130382,31130669,31130698,31130773,31131176,31131388,31131557,31131656,31131879,31132134,31132632,31132695,3113273 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195444, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100494,31100677,31100960,31101174,31101423,31101673,31101713,31102168,31102510,31102610,31103102,31103219,31103457,31103663,31103939,31104263,31104497,31104738,31105035,31105359,31105400,31105645,31105691,31105733,31106248,31106406,31106689,31106884,31107189,31107367,31107586,31107890,31108172,31108440,31108596,31108974,31109294,31109482,31109815,31110127,31110331,31110526,31110698,31110952,31111159,31111362,31111561,31111609,31112119,31112321,31112526,31112606,31112911,31113201,31113447,31113662,31114075,31114338,31114618,31114811,31115113,31115153,31115406,31115691,31116072,31116345,31116596,31116781,31116994,31117035,31117323,31117527,31117843,31118026,31118234,31118446,31118519,31118790,31119025,31119235,31119473,31119511,31119931,31119970,31120383,31120587,31120849,31121063,31121580,31121622,31121767,31122078,31122286,31122621,31122968,31123123,31123205,31123497,31123746,31123990,31124187,31124452,31124709,31124950,31125206,31125453,31125724,31125916,31127249,31127308,31127344,31127400,31127436,3112748 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195445, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100492,31100955,31101169,31101428,31101705,31102167,31102620,31103098,31103937,31104256,31104499,31104746,31105030,31105358,31105403,31105635,31105694,31105726,31106259,31106414,31106687,31106892,31107184,31107364,31107587,31107894,31108174,31108438,31108595,31108981,31109296,31109479,31109819,31110123,31110319,31110524,31112126,31112314,31112523,31112604,31112920,31113203,31113451,31113659,31114079,31114337,31114620,31114804,31115115,31115156,31115694,31116068,31116593,31116998,31117530,31117839,31118523,31118794,31119029,31119229,31119481,31119522,31119979,31120393,31120596,31120845,31121571,31121621,31121770,31122289,31122614,31122957,31123124,31123209,31123494,31123748,31124193,31124455,31124707,31124951,31125202,31125455,31125722,31125912,31127244,31127309,31127336,31127394,31127445,31127484,31127976,31128026,31128062,31128104,31128147,31128494,31128570,31128785,31128885,31129131,31129197,31129662,31129778,31130139,31130385,31130675,31130711,31130782,31131175,31131394,31131561,31131645,31131874,3113214 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195446, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100484,31100691,31100957,31101170,31101431,31101674,31101701,31102170,31102500,31102616,31103094,31103214,31103467,31103665,31103938,31104257,31104506,31104751,31105034,31105350,31105402,31105638,31105688,31105721,31106261,31106413,31106682,31106882,31107186,31107366,31107588,31107887,31108178,31108442,31108599,31108977,31109297,31109475,31109814,31110126,31110330,31110523,31110701,31110958,31111155,31111369,31111563,31111605,31112129,31112323,31112522,31112617,31112913,31113200,31113445,31113664,31114074,31114335,31114616,31114817,31115114,31115154,31115402,31115681,31116060,31116355,31116591,31116782,31116992,31117029,31117313,31117518,31117831,31118033,31118232,31118441,31118526,31118798,31119017,31119230,31119480,31119512,31119929,31119976,31120392,31120594,31120851,31121065,31121572,31121615,31121769,31122082,31122282,31122608,31122967,31123121,31123197,31123496,31123751,31123989,31124200,31124453,31124705,31124952,31125209,31125448,31125714,31125907,31127242,31127310,31127340,31127395,31127438,3112749 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195447, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31101716,31102159,31102512,31102607,31103096,31103208,31103470,31103668,31104258,31104502,31104744,31105031,31105355,31105408,31105644,31105692,31106252,31106681,31106891,31107194,31107360,31107889,31108436,31108979,31109302,31109474,31109817,31110117,31110529,31110945,31111158,31111371,31112322,31112614,31114625,31114818,31115107,31115155,31115689,31117023,31118018,31118229,31118449,31118513,31118789,31119030,31119521,31120390,31120584,31120843,31121764,31122076,31122283,31122619,31122965,31123744,31123993,31124447,31124704,31124956,31125203,31125447,31125725,31125908,31127250,31127306,31127337,31127397,31127442,31127485,31127981,31128028,31128067,31128110,31128148,31128483,31128568,31128780,31128882,31129640,31129769,31130122,31130375,31130674,31130697,31130775,31131187,31131397,31131569,31131647,31131884,31132146,31132633,31132699,31132736,31132776,31132815,31132865,31132909,31132949,31132985,31133056,31133088,31134200,31134240,31134324,31134357,31134713,31135302,31135680,31135971,31136056,31136316,3113660 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31195441,31195442,31195443,31195444,31195445,31195446,31195447?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-09-01' and date <= '2026-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1471,),), 'unwanted_material_monthly_percentage': ((0.5120526145581253,),), 'material_repartition': (('incineration', 1471),), 'material_dict': {'incineration': 1471}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 1), 0.7768001118386015, 3), (datetime.date(2026, 9, 2), 0.7639054098121464, 3), (datetime.date(2026, 9, 3), 0.7825276315306483, 3), (datetime.date(2026, 9, 4), 0.7171598515923755, 3), (datetime.date(2026, 9, 5), 0.5563431289796186, 1), (datetime.date(2026, 9, 6), 0.44388017577922234, 2), (datetime.date(2026, 9, 7), 0.4750241050649462, 4), (datetime.date(2026, 9, 8), 0.49461449056312345, 1), (datetime.date(2026, 9, 9), 0.4586671025292901, 2), (datetime.date(2026, 9, 10), 0.45871436000725624, 2), (datetime.date(2026, 9, 11), 0.4518192444659192, 2), (datetime.date(2026, 9, 12), 0.45524853358121503, 3), (datetime.date(2026, 9, 13), 0.39055068837184626, 2), (datetime.date(2026, 9, 14), 0.3864067622700574, 2), (datetime.date(2026, 9, 15), 0.416399314117723, 1), (datetime.date(2026, 9, 16), 0.4854788143492851, 2), (datetime.date(2026, 9, 17), 0.5231980952946492, 3), (datetime.date(2026, 9, 18), 0.49664645211348324, 3), (datetime.date(2026, 9, 19), 0.48019264637062636, 4), (datetime.date(2026, 9, 20), 0.49034756374512467, 2), (datetime.date(2026, 9, 21), 0.4704463511759931, 3), (datetime.date(2026, 9, 22), 0.46818239511283427, 4), (datetime.date(2026, 9, 23), 0.43391421635636424, 3), (datetime.date(2026, 9, 24), 0.41053803601540345, 4), (datetime.date(2026, 9, 25), 0.36671413082129833, 1), (datetime.date(2026, 9, 26), 0.37801996462578485, 1), (datetime.date(2026, 9, 27), 0.5606120323683961, 1), (datetime.date(2026, 9, 28), 0.7359284535855268, 3), (datetime.date(2026, 9, 29), 0.45045938931418267, 1), (datetime.date(2026, 9, 30), 0.43579741020361096, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 1), 0.7768001118386015, 3), (datetime.date(2026, 9, 2), 0.7639054098121464, 3), (datetime.date(2026, 9, 3), 0.7825276315306483, 3), (datetime.date(2026, 9, 4), 0.7171598515923755, 3), (datetime.date(2026, 9, 5), 0.5563431289796186, 1), (datetime.date(2026, 9, 6), 0.44388017577922234, 2), (datetime.date(2026, 9, 7), 0.4750241050649462, 4), (datetime.date(2026, 9, 8), 0.49461449056312345, 1), (datetime.date(2026, 9, 9), 0.4586671025292901, 2), (datetime.date(2026, 9, 10), 0.45871436000725624, 2), (datetime.date(2026, 9, 11), 0.4518192444659192, 2), (datetime.date(2026, 9, 12), 0.45524853358121503, 3), (datetime.date(2026, 9, 13), 0.39055068837184626, 2), (datetime.date(2026, 9, 14), 0.3864067622700574, 2), (datetime.date(2026, 9, 15), 0.416399314117723, 1), (datetime.date(2026, 9, 16), 0.4854788143492851, 2), (datetime.date(2026, 9, 17), 0.5231980952946492, 3), (datetime.date(2026, 9, 18), 0.49664645211348324, 3), (datetime.date(2026, 9, 19), 0.48019264637062636, 4), (datetime.date(2026, 9, 20), 0.49034756374512467, 2), (datetime.date(2026, 9, 21), 0.4704463511759931, 3), (datetime.date(2026, 9, 22), 0.46818239511283427, 4), (datetime.date(2026, 9, 23), 0.43391421635636424, 3), (datetime.date(2026, 9, 24), 0.41053803601540345, 4), (datetime.date(2026, 9, 25), 0.36671413082129833, 1), (datetime.date(2026, 9, 26), 0.37801996462578485, 1), (datetime.date(2026, 9, 27), 0.5606120323683961, 1), (datetime.date(2026, 9, 28), 0.7359284535855268, 3), (datetime.date(2026, 9, 29), 0.45045938931418267, 1), (datetime.date(2026, 9, 30), 0.43579741020361096, 3))}, 'quality_array': [['-7.773622338227195', '01092026'], ['-7.73250200049155', '02092026'], ['-8.157197240637103', '03092026'], ['-8.639200425442317', '04092026'], ['-8.38228675246505', '05092026'], ['-8.155341060106666', '06092026'], ['-8.566001827907794', '07092026'], ['-8.997864680866961', '08092026'], ['-8.698247727433888', '09092026'], ['-8.744344091413902', '10092026'], ['-8.918428657835648', '11092026'], ['-9.076671915036464', '12092026'], ['-8.747162289665166', '13092026'], ['-8.849053833276223', '14092026'], ['-9.033616171029117', '15092026'], ['-9.327410060262928', '16092026'], ['-9.131776596054213', '17092026'], ['-8.86223395073806', '18092026'], ['-8.884691676648211', '19092026'], ['-9.01659964325401', '20092026'], ['-9.219282077361466', '21092026'], ['-9.13168461751525', '22092026'], ['-8.928237488679763', '23092026'], ['-9.370461171807555', '24092026'], ['-9.411738305970797', '25092026'], ['-9.414831849353286', '26092026'], ['-9.336927402633295', '27092026'], ['-8.869710171705202', '28092026'], ['-9.034348352283294', '29092026'], ['-9.040294047595573', '30092026']], 'number_of_batch': ((589,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02492065915790676, 'nb_photo': 20829, 'list_port_cont': '31100496,31100686,31100962,31101165,31101432,31101668,31101711,31102169,31102513,31102615,31103089,31103216,31103472,31103669,31103935,31104261,31104496,31104750,31105027,31105356,31105394,31105648,31105695,31105723,31106251,31106404,31106683,31106888,31107190,31107359,31107591,31107879,31108169,31108428,31108591,31108972,31109293,31109470,31109811,31110112,31110314,31110521,31110696,31110946,31111151,31111356,31111569,31111597,31112114,31112308,31112517,31112618,31112908,31113195,31113438,31113665,31114081,31114322,31114612,31114814,31115103,31115151,31115408,31115678,31116063,31116351,31116584,31116785,31116995,31117032,31117321,31117522,31117830,31118032,31118233,31118445,31118527,31118792,31119023,31119223,31119475,31119516,31119930,31119968,31120388,31120580,31120853,31121067,31121566,31121607,31121768,31122081,31122288,31122622,31122956,31123116,31123196,31123488,31123747,31123983,31124196,31124454,31124700,31124958,31125210,31125444,31125721,31125913,31127251,31127295,31127347,31127392,31127439,3112748', 'assoc_port': '31100292:31100496,31100524:31100686,31100756:31100962,31100994:31101165,31101211:31101432,31101505:31101711,31101506:31101668,31101983:31102169,31102273:31102513,31102536:31102615,31102788:31103089,31102984:31103216,31103195:31103472,31103492:31103669,31103773:31103935,31104045:31104261,31104285:31104496,31104465:31105356,31104564:31104750,31104732:31105027,31105015:31105648,31105224:31105394,31105471:31105723,31105472:31105695,31106052:31106251,31106286:31106404,31106482:31106683,31106719:31106888,31106969:31107190,31107225:31107359,31107406:31107591,31107671:31107879,31107941:31108169,31108212:31108428,31108472:31108591,31108787:31108972,31109140:31109293,31109325:31109470,31109636:31109811,31109876:31110112,31110052:31110314,31110053:31110521,31110509:31110696,31110727:31110946,31110937:31111151,31111223:31111356,31111494:31111597,31111513:31111569,31111921:31112114,31112155:31112308,31112356:31112517,31112557:31112618,31112732:31112908,31113025:31113195,31113238:31113438,31113490:31113665,31113869:3111408', 'assoc_mat': '31100292:autre:4230:31100496,31100524:autre:4230:31100686,31100756:autre:4230:31100962,31100994:autre:4230:31101165,31101211:autre:4230:31101432,31101505:autre:4230:31101711,31101506:autre:4230:31101668,31101983:autre:4230:31102169,31102273:autre:4230:31102513,31102536:autre:4230:31102615,31102788:autre:4230:31103089,31102984:autre:4230:31103216,31103195:autre:4230:31103472,31103492:autre:4230:31103669,31103773:autre:4230:31103935,31104045:autre:4230:31104261,31104285:autre:4230:31104496,31104465:autre:4230:31105356,31104564:autre:4230:31104750,31104732:autre:4230:31105027,31105015:autre:4230:31105648,31105224:autre:4230:31105394,31105471:autre:4230:31105723,31105472:autre:4230:31105695,31106052:autre:4230:31106251,31106286:autre:4230:31106404,31106482:autre:4230:31106683,31106719:autre:4230:31106888,31106969:autre:4230:31107190,31107225:autre:4230:31107359,31107406:autre:4230:31107591,31107671:autre:4230:31107879,31107941:autre:4230:31108169,31108212:autre:4230:31108428,31108472:autre:4230:31108591,31108787:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.126716316504713, 'nb_photo': 139769, 'list_port_cont': '31100487,31100689,31100949,31101166,31101426,31101666,31101708,31102171,31102511,31102618,31103103,31103211,31103459,31103666,31103934,31104251,31104504,31104749,31105033,31105357,31105409,31105646,31105690,31105729,31106257,31106415,31106688,31106894,31107192,31107365,31107585,31107886,31108177,31108431,31108598,31108966,31109303,31109483,31109812,31110122,31110323,31110520,31110707,31110955,31111156,31111357,31111562,31111606,31112123,31112312,31112525,31112613,31112917,31113189,31113455,31113660,31114084,31114336,31114615,31114809,31115099,31115150,31115409,31115688,31116069,31116358,31116594,31116789,31116984,31117031,31117315,31117529,31117842,31118031,31118221,31118442,31118520,31118793,31119032,31119228,31119477,31119524,31119932,31119972,31120385,31120581,31120840,31121062,31121574,31121619,31121766,31122083,31122281,31122623,31122964,31123113,31123206,31123495,31123745,31123979,31124199,31124448,31124710,31124957,31125199,31125450,31125726,31125914,31127247,31127311,31127342,31127399,31127443,3112747', 'assoc_port': '31100292:31100487,31100524:31100689,31100756:31100949,31100994:31101166,31101211:31101426,31101505:31101708,31101506:31101666,31101983:31102171,31102273:31102511,31102536:31102618,31102788:31103103,31102984:31103211,31103195:31103459,31103492:31103666,31103773:31103934,31104045:31104251,31104285:31104504,31104465:31105357,31104564:31104749,31104732:31105033,31105015:31105646,31105224:31105409,31105471:31105729,31105472:31105690,31106052:31106257,31106286:31106415,31106482:31106688,31106719:31106894,31106969:31107192,31107225:31107365,31107406:31107585,31107671:31107886,31107941:31108177,31108212:31108431,31108472:31108598,31108787:31108966,31109140:31109303,31109325:31109483,31109636:31109812,31109876:31110122,31110052:31110323,31110053:31110520,31110509:31110707,31110727:31110955,31110937:31111156,31111223:31111357,31111494:31111606,31111513:31111562,31111921:31112123,31112155:31112312,31112356:31112525,31112557:31112613,31112732:31112917,31113025:31113189,31113238:31113455,31113490:31113660,31113869:3111408', 'assoc_mat': '31100292:carton:4230:31100487,31100524:carton:4230:31100689,31100756:carton:4230:31100949,31100994:carton:4230:31101166,31101211:carton:4230:31101426,31101505:carton:4230:31101708,31101506:carton:4230:31101666,31101983:carton:4230:31102171,31102273:carton:4230:31102511,31102536:carton:4230:31102618,31102788:carton:4230:31103103,31102984:carton:4230:31103211,31103195:carton:4230:31103459,31103492:carton:4230:31103666,31103773:carton:4230:31103934,31104045:carton:4230:31104251,31104285:carton:4230:31104504,31104465:carton:4230:31105357,31104564:carton:4230:31104749,31104732:carton:4230:31105033,31105015:carton:4230:31105646,31105224:carton:4230:31105409,31105471:carton:4230:31105729,31105472:carton:4230:31105690,31106052:carton:4230:31106257,31106286:carton:4230:31106415,31106482:carton:4230:31106688,31106719:carton:4230:31106894,31106969:carton:4230:31107192,31107225:carton:4230:31107365,31107406:carton:4230:31107585,31107671:carton:4230:31107886,31107941:carton:4230:31108177,31108212:carton:4230:31108431,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001896369468195011, 'nb_photo': 1864, 'list_port_cont': '31100483,31100676,31100947,31101167,31101417,31101699,31102507,31102617,31103104,31103670,31103929,31104264,31104505,31104740,31105036,31105360,31105728,31106247,31106418,31106684,31106887,31107187,31107352,31107576,31108162,31108429,31108594,31108971,31109289,31109481,31109804,31110114,31110325,31110941,31111153,31111599,31112325,31114339,31114624,31114805,31115110,31115152,31115394,31115680,31116066,31116350,31116583,31116786,31116999,31117033,31117513,31117836,31118029,31118437,31118528,31118799,31119026,31119221,31119482,31119519,31119936,31119974,31120379,31120586,31120841,31121576,31121771,31122618,31122954,31123109,31123198,31123487,31123740,31123980,31124188,31124439,31124695,31124941,31125194,31125451,31125723,31125899,31127246,31127298,31127332,31127391,31127429,31127476,31127973,31128025,31128057,31128098,31128132,31128481,31128559,31128769,31128888,31129203,31129635,31129775,31130120,31130382,31130669,31130698,31130773,31131176,31131388,31131557,31131656,31131879,31132134,31132632,31132695,3113273', 'assoc_port': '31100292:31100483,31100524:31100676,31100756:31100947,31100994:31101167,31101211:31101417,31101505:31101699,31102273:31102507,31102536:31102617,31102788:31103104,31103492:31103670,31103773:31103929,31104045:31104264,31104285:31104505,31104465:31105360,31104564:31104740,31104732:31105036,31105471:31105728,31106052:31106247,31106286:31106418,31106482:31106684,31106719:31106887,31106969:31107187,31107225:31107352,31107406:31107576,31107941:31108162,31108212:31108429,31108472:31108594,31108787:31108971,31109140:31109289,31109325:31109481,31109636:31109804,31109876:31110114,31110052:31110325,31110727:31110941,31110937:31111153,31111494:31111599,31112155:31112325,31114149:31114339,31114410:31114624,31114678:31114805,31114854:31115110,31115083:31115152,31115337:31115394,31115613:31115680,31115901:31116066,31116142:31116350,31116386:31116583,31116625:31116786,31116827:31117033,31116828:31116999,31117471:31117513,31117563:31117836,31117867:31118029,31118331:31118437,31118332:31118528,31118471:31118799,31118862:3111902', 'assoc_mat': '31100292:metal:4230:31100483,31100524:metal:4230:31100676,31100756:metal:4230:31100947,31100994:metal:4230:31101167,31101211:metal:4230:31101417,31101505:metal:4230:31101699,31102273:metal:4230:31102507,31102536:metal:4230:31102617,31102788:metal:4230:31103104,31103492:metal:4230:31103670,31103773:metal:4230:31103929,31104045:metal:4230:31104264,31104285:metal:4230:31104505,31104465:metal:4230:31105360,31104564:metal:4230:31104740,31104732:metal:4230:31105036,31105471:metal:4230:31105728,31106052:metal:4230:31106247,31106286:metal:4230:31106418,31106482:metal:4230:31106684,31106719:metal:4230:31106887,31106969:metal:4230:31107187,31107225:metal:4230:31107352,31107406:metal:4230:31107576,31107941:metal:4230:31108162,31108212:metal:4230:31108429,31108472:metal:4230:31108594,31108787:metal:4230:31108971,31109140:metal:4230:31109289,31109325:metal:4230:31109481,31109636:metal:4230:31109804,31109876:metal:4230:31110114,31110052:metal:4230:31110325,31110727:metal:4230:31110941,31110937:metal:4230:31111153,31111494:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3423925832918199, 'nb_photo': 332399, 'list_port_cont': '31100494,31100677,31100960,31101174,31101423,31101673,31101713,31102168,31102510,31102610,31103102,31103219,31103457,31103663,31103939,31104263,31104497,31104738,31105035,31105359,31105400,31105645,31105691,31105733,31106248,31106406,31106689,31106884,31107189,31107367,31107586,31107890,31108172,31108440,31108596,31108974,31109294,31109482,31109815,31110127,31110331,31110526,31110698,31110952,31111159,31111362,31111561,31111609,31112119,31112321,31112526,31112606,31112911,31113201,31113447,31113662,31114075,31114338,31114618,31114811,31115113,31115153,31115406,31115691,31116072,31116345,31116596,31116781,31116994,31117035,31117323,31117527,31117843,31118026,31118234,31118446,31118519,31118790,31119025,31119235,31119473,31119511,31119931,31119970,31120383,31120587,31120849,31121063,31121580,31121622,31121767,31122078,31122286,31122621,31122968,31123123,31123205,31123497,31123746,31123990,31124187,31124452,31124709,31124950,31125206,31125453,31125724,31125916,31127249,31127308,31127344,31127400,31127436,3112748', 'assoc_port': '31100292:31100494,31100524:31100677,31100756:31100960,31100994:31101174,31101211:31101423,31101505:31101713,31101506:31101673,31101983:31102168,31102273:31102510,31102536:31102610,31102788:31103102,31102984:31103219,31103195:31103457,31103492:31103663,31103773:31103939,31104045:31104263,31104285:31104497,31104465:31105359,31104564:31104738,31104732:31105035,31105015:31105645,31105224:31105400,31105471:31105733,31105472:31105691,31106052:31106248,31106286:31106406,31106482:31106689,31106719:31106884,31106969:31107189,31107225:31107367,31107406:31107586,31107671:31107890,31107941:31108172,31108212:31108440,31108472:31108596,31108787:31108974,31109140:31109294,31109325:31109482,31109636:31109815,31109876:31110127,31110052:31110331,31110053:31110526,31110509:31110698,31110727:31110952,31110937:31111159,31111223:31111362,31111494:31111609,31111513:31111561,31111921:31112119,31112155:31112321,31112356:31112526,31112557:31112606,31112732:31112911,31113025:31113201,31113238:31113447,31113490:31113662,31113869:3111407', 'assoc_mat': '31100292:papier:4230:31100494,31100524:papier:4230:31100677,31100756:papier:4230:31100960,31100994:papier:4230:31101174,31101211:papier:4230:31101423,31101505:papier:4230:31101713,31101506:papier:4230:31101673,31101983:papier:4230:31102168,31102273:papier:4230:31102510,31102536:papier:4230:31102610,31102788:papier:4230:31103102,31102984:papier:4230:31103219,31103195:papier:4230:31103457,31103492:papier:4230:31103663,31103773:papier:4230:31103939,31104045:papier:4230:31104263,31104285:papier:4230:31104497,31104465:papier:4230:31105359,31104564:papier:4230:31104738,31104732:papier:4230:31105035,31105015:papier:4230:31105645,31105224:papier:4230:31105400,31105471:papier:4230:31105733,31105472:papier:4230:31105691,31106052:papier:4230:31106248,31106286:papier:4230:31106406,31106482:papier:4230:31106689,31106719:papier:4230:31106884,31106969:papier:4230:31107189,31107225:papier:4230:31107367,31107406:papier:4230:31107586,31107671:papier:4230:31107890,31107941:papier:4230:31108172,31108212:papier:4230:31108440,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007380863903897634, 'nb_photo': 5370, 'list_port_cont': '31100492,31100955,31101169,31101428,31101705,31102167,31102620,31103098,31103937,31104256,31104499,31104746,31105030,31105358,31105403,31105635,31105694,31105726,31106259,31106414,31106687,31106892,31107184,31107364,31107587,31107894,31108174,31108438,31108595,31108981,31109296,31109479,31109819,31110123,31110319,31110524,31112126,31112314,31112523,31112604,31112920,31113203,31113451,31113659,31114079,31114337,31114620,31114804,31115115,31115156,31115694,31116068,31116593,31116998,31117530,31117839,31118523,31118794,31119029,31119229,31119481,31119522,31119979,31120393,31120596,31120845,31121571,31121621,31121770,31122289,31122614,31122957,31123124,31123209,31123494,31123748,31124193,31124455,31124707,31124951,31125202,31125455,31125722,31125912,31127244,31127309,31127336,31127394,31127445,31127484,31127976,31128026,31128062,31128104,31128147,31128494,31128570,31128785,31128885,31129131,31129197,31129662,31129778,31130139,31130385,31130675,31130711,31130782,31131175,31131394,31131561,31131645,31131874,3113214', 'assoc_port': '31100292:31100492,31100756:31100955,31100994:31101169,31101211:31101428,31101505:31101705,31101983:31102167,31102536:31102620,31102788:31103098,31103773:31103937,31104045:31104256,31104285:31104499,31104465:31105358,31104564:31104746,31104732:31105030,31105015:31105635,31105224:31105403,31105471:31105726,31105472:31105694,31106052:31106259,31106286:31106414,31106482:31106687,31106719:31106892,31106969:31107184,31107225:31107364,31107406:31107587,31107671:31107894,31107941:31108174,31108212:31108438,31108472:31108595,31108787:31108981,31109140:31109296,31109325:31109479,31109636:31109819,31109876:31110123,31110052:31110319,31110053:31110524,31111921:31112126,31112155:31112314,31112356:31112523,31112557:31112604,31112732:31112920,31113025:31113203,31113238:31113451,31113490:31113659,31113869:31114079,31114149:31114337,31114410:31114620,31114678:31114804,31114854:31115115,31115083:31115156,31115613:31115694,31115901:31116068,31116386:31116593,31116828:31116998,31117471:31117530,31117563:31117839,31118332:3111852', 'assoc_mat': '31100292:pehd:4230:31100492,31100756:pehd:4230:31100955,31100994:pehd:4230:31101169,31101211:pehd:4230:31101428,31101505:pehd:4230:31101705,31101983:pehd:4230:31102167,31102536:pehd:4230:31102620,31102788:pehd:4230:31103098,31103773:pehd:4230:31103937,31104045:pehd:4230:31104256,31104285:pehd:4230:31104499,31104465:pehd:4230:31105358,31104564:pehd:4230:31104746,31104732:pehd:4230:31105030,31105015:pehd:4230:31105635,31105224:pehd:4230:31105403,31105471:pehd:4230:31105726,31105472:pehd:4230:31105694,31106052:pehd:4230:31106259,31106286:pehd:4230:31106414,31106482:pehd:4230:31106687,31106719:pehd:4230:31106892,31106969:pehd:4230:31107184,31107225:pehd:4230:31107364,31107406:pehd:4230:31107587,31107671:pehd:4230:31107894,31107941:pehd:4230:31108174,31108212:pehd:4230:31108438,31108472:pehd:4230:31108595,31108787:pehd:4230:31108981,31109140:pehd:4230:31109296,31109325:pehd:4230:31109479,31109636:pehd:4230:31109819,31109876:pehd:4230:31110123,31110052:pehd:4230:31110319,31110053:pehd:4230:31110524,31111921:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011166584722419793, 'nb_photo': 17698, 'list_port_cont': '31100484,31100691,31100957,31101170,31101431,31101674,31101701,31102170,31102500,31102616,31103094,31103214,31103467,31103665,31103938,31104257,31104506,31104751,31105034,31105350,31105402,31105638,31105688,31105721,31106261,31106413,31106682,31106882,31107186,31107366,31107588,31107887,31108178,31108442,31108599,31108977,31109297,31109475,31109814,31110126,31110330,31110523,31110701,31110958,31111155,31111369,31111563,31111605,31112129,31112323,31112522,31112617,31112913,31113200,31113445,31113664,31114074,31114335,31114616,31114817,31115114,31115154,31115402,31115681,31116060,31116355,31116591,31116782,31116992,31117029,31117313,31117518,31117831,31118033,31118232,31118441,31118526,31118798,31119017,31119230,31119480,31119512,31119929,31119976,31120392,31120594,31120851,31121065,31121572,31121615,31121769,31122082,31122282,31122608,31122967,31123121,31123197,31123496,31123751,31123989,31124200,31124453,31124705,31124952,31125209,31125448,31125714,31125907,31127242,31127310,31127340,31127395,31127438,3112749', 'assoc_port': '31100292:31100484,31100524:31100691,31100756:31100957,31100994:31101170,31101211:31101431,31101505:31101701,31101506:31101674,31101983:31102170,31102273:31102500,31102536:31102616,31102788:31103094,31102984:31103214,31103195:31103467,31103492:31103665,31103773:31103938,31104045:31104257,31104285:31104506,31104465:31105350,31104564:31104751,31104732:31105034,31105015:31105638,31105224:31105402,31105471:31105721,31105472:31105688,31106052:31106261,31106286:31106413,31106482:31106682,31106719:31106882,31106969:31107186,31107225:31107366,31107406:31107588,31107671:31107887,31107941:31108178,31108212:31108442,31108472:31108599,31108787:31108977,31109140:31109297,31109325:31109475,31109636:31109814,31109876:31110126,31110052:31110330,31110053:31110523,31110509:31110701,31110727:31110958,31110937:31111155,31111223:31111369,31111494:31111605,31111513:31111563,31111921:31112129,31112155:31112323,31112356:31112522,31112557:31112617,31112732:31112913,31113025:31113200,31113238:31113445,31113490:31113664,31113869:3111407', 'assoc_mat': '31100292:pet_clair:4230:31100484,31100524:pet_clair:4230:31100691,31100756:pet_clair:4230:31100957,31100994:pet_clair:4230:31101170,31101211:pet_clair:4230:31101431,31101505:pet_clair:4230:31101701,31101506:pet_clair:4230:31101674,31101983:pet_clair:4230:31102170,31102273:pet_clair:4230:31102500,31102536:pet_clair:4230:31102616,31102788:pet_clair:4230:31103094,31102984:pet_clair:4230:31103214,31103195:pet_clair:4230:31103467,31103492:pet_clair:4230:31103665,31103773:pet_clair:4230:31103938,31104045:pet_clair:4230:31104257,31104285:pet_clair:4230:31104506,31104465:pet_clair:4230:31105350,31104564:pet_clair:4230:31104751,31104732:pet_clair:4230:31105034,31105015:pet_clair:4230:31105638,31105224:pet_clair:4230:31105402,31105471:pet_clair:4230:31105721,31105472:pet_clair:4230:31105688,31106052:pet_clair:4230:31106261,31106286:pet_clair:4230:31106413,31106482:pet_clair:4230:31106682,31106719:pet_clair:4230:31106882,31106969:pet_clair:4230:31107186,31107225:pet_clair:4230:31107366,31107406:pet_clair:4230:31107588,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005500565632600825, 'nb_photo': 1298, 'list_port_cont': '31101716,31102159,31102512,31102607,31103096,31103208,31103470,31103668,31104258,31104502,31104744,31105031,31105355,31105408,31105644,31105692,31106252,31106681,31106891,31107194,31107360,31107889,31108436,31108979,31109302,31109474,31109817,31110117,31110529,31110945,31111158,31111371,31112322,31112614,31114625,31114818,31115107,31115155,31115689,31117023,31118018,31118229,31118449,31118513,31118789,31119030,31119521,31120390,31120584,31120843,31121764,31122076,31122283,31122619,31122965,31123744,31123993,31124447,31124704,31124956,31125203,31125447,31125725,31125908,31127250,31127306,31127337,31127397,31127442,31127485,31127981,31128028,31128067,31128110,31128148,31128483,31128568,31128780,31128882,31129640,31129769,31130122,31130375,31130674,31130697,31130775,31131187,31131397,31131569,31131647,31131884,31132146,31132633,31132699,31132736,31132776,31132815,31132865,31132909,31132949,31132985,31133056,31133088,31134200,31134240,31134324,31134357,31134713,31135302,31135680,31135971,31136056,31136316,3113660', 'assoc_port': '31101505:31101716,31101983:31102159,31102273:31102512,31102536:31102607,31102788:31103096,31102984:31103208,31103195:31103470,31103492:31103668,31104045:31104258,31104285:31104502,31104465:31105355,31104564:31104744,31104732:31105031,31105015:31105644,31105224:31105408,31105472:31105692,31106052:31106252,31106482:31106681,31106719:31106891,31106969:31107194,31107225:31107360,31107671:31107889,31108212:31108436,31108787:31108979,31109140:31109302,31109325:31109474,31109636:31109817,31109876:31110117,31110053:31110529,31110727:31110945,31110937:31111158,31111223:31111371,31112155:31112322,31112557:31112614,31114410:31114625,31114678:31114818,31114854:31115107,31115083:31115155,31115613:31115689,31116827:31117023,31117867:31118018,31118063:31118229,31118331:31118449,31118332:31118513,31118471:31118789,31118862:31119030,31119310:31119521,31120181:31120390,31120426:31120584,31120635:31120843,31121557:31121764,31121878:31122076,31122118:31122283,31122363:31122619,31122766:31122965,31123533:31123744,31123781:3112399', 'assoc_mat': '31101505:pet_fonce:4230:31101716,31101983:pet_fonce:4230:31102159,31102273:pet_fonce:4230:31102512,31102536:pet_fonce:4230:31102607,31102788:pet_fonce:4230:31103096,31102984:pet_fonce:4230:31103208,31103195:pet_fonce:4230:31103470,31103492:pet_fonce:4230:31103668,31104045:pet_fonce:4230:31104258,31104285:pet_fonce:4230:31104502,31104465:pet_fonce:4230:31105355,31104564:pet_fonce:4230:31104744,31104732:pet_fonce:4230:31105031,31105015:pet_fonce:4230:31105644,31105224:pet_fonce:4230:31105408,31105472:pet_fonce:4230:31105692,31106052:pet_fonce:4230:31106252,31106482:pet_fonce:4230:31106681,31106719:pet_fonce:4230:31106891,31106969:pet_fonce:4230:31107194,31107225:pet_fonce:4230:31107360,31107671:pet_fonce:4230:31107889,31108212:pet_fonce:4230:31108436,31108787:pet_fonce:4230:31108979,31109140:pet_fonce:4230:31109302,31109325:pet_fonce:4230:31109474,31109636:pet_fonce:4230:31109817,31109876:pet_fonce:4230:31110117,31110053:pet_fonce:4230:31110529,31110727:pet_fonce:4230:31110945,31110937:pet_fonce:4230:31111158,3'}), 'main_stat': {'nb_photos': 1471}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31195441,31195442,31195443,31195444,31195445,31195446,31195447?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.5120526145581253),)]} 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': ((1471,),), 'unwanted_material_monthly_percentage': ((0.5120526145581253,),), 'material_repartition': (('incineration', 1471),), 'material_dict': {'incineration': 1471}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 1), 0.7768001118386015, 3), (datetime.date(2026, 9, 2), 0.7639054098121464, 3), (datetime.date(2026, 9, 3), 0.7825276315306483, 3), (datetime.date(2026, 9, 4), 0.7171598515923755, 3), (datetime.date(2026, 9, 5), 0.5563431289796186, 1), (datetime.date(2026, 9, 6), 0.44388017577922234, 2), (datetime.date(2026, 9, 7), 0.4750241050649462, 4), (datetime.date(2026, 9, 8), 0.49461449056312345, 1), (datetime.date(2026, 9, 9), 0.4586671025292901, 2), (datetime.date(2026, 9, 10), 0.45871436000725624, 2), (datetime.date(2026, 9, 11), 0.4518192444659192, 2), (datetime.date(2026, 9, 12), 0.45524853358121503, 3), (datetime.date(2026, 9, 13), 0.39055068837184626, 2), (datetime.date(2026, 9, 14), 0.3864067622700574, 2), (datetime.date(2026, 9, 15), 0.416399314117723, 1), (datetime.date(2026, 9, 16), 0.4854788143492851, 2), (datetime.date(2026, 9, 17), 0.5231980952946492, 3), (datetime.date(2026, 9, 18), 0.49664645211348324, 3), (datetime.date(2026, 9, 19), 0.48019264637062636, 4), (datetime.date(2026, 9, 20), 0.49034756374512467, 2), (datetime.date(2026, 9, 21), 0.4704463511759931, 3), (datetime.date(2026, 9, 22), 0.46818239511283427, 4), (datetime.date(2026, 9, 23), 0.43391421635636424, 3), (datetime.date(2026, 9, 24), 0.41053803601540345, 4), (datetime.date(2026, 9, 25), 0.36671413082129833, 1), (datetime.date(2026, 9, 26), 0.37801996462578485, 1), (datetime.date(2026, 9, 27), 0.5606120323683961, 1), (datetime.date(2026, 9, 28), 0.7359284535855268, 3), (datetime.date(2026, 9, 29), 0.45045938931418267, 1), (datetime.date(2026, 9, 30), 0.43579741020361096, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 1), 0.7768001118386015, 3), (datetime.date(2026, 9, 2), 0.7639054098121464, 3), (datetime.date(2026, 9, 3), 0.7825276315306483, 3), (datetime.date(2026, 9, 4), 0.7171598515923755, 3), (datetime.date(2026, 9, 5), 0.5563431289796186, 1), (datetime.date(2026, 9, 6), 0.44388017577922234, 2), (datetime.date(2026, 9, 7), 0.4750241050649462, 4), (datetime.date(2026, 9, 8), 0.49461449056312345, 1), (datetime.date(2026, 9, 9), 0.4586671025292901, 2), (datetime.date(2026, 9, 10), 0.45871436000725624, 2), (datetime.date(2026, 9, 11), 0.4518192444659192, 2), (datetime.date(2026, 9, 12), 0.45524853358121503, 3), (datetime.date(2026, 9, 13), 0.39055068837184626, 2), (datetime.date(2026, 9, 14), 0.3864067622700574, 2), (datetime.date(2026, 9, 15), 0.416399314117723, 1), (datetime.date(2026, 9, 16), 0.4854788143492851, 2), (datetime.date(2026, 9, 17), 0.5231980952946492, 3), (datetime.date(2026, 9, 18), 0.49664645211348324, 3), (datetime.date(2026, 9, 19), 0.48019264637062636, 4), (datetime.date(2026, 9, 20), 0.49034756374512467, 2), (datetime.date(2026, 9, 21), 0.4704463511759931, 3), (datetime.date(2026, 9, 22), 0.46818239511283427, 4), (datetime.date(2026, 9, 23), 0.43391421635636424, 3), (datetime.date(2026, 9, 24), 0.41053803601540345, 4), (datetime.date(2026, 9, 25), 0.36671413082129833, 1), (datetime.date(2026, 9, 26), 0.37801996462578485, 1), (datetime.date(2026, 9, 27), 0.5606120323683961, 1), (datetime.date(2026, 9, 28), 0.7359284535855268, 3), (datetime.date(2026, 9, 29), 0.45045938931418267, 1), (datetime.date(2026, 9, 30), 0.43579741020361096, 3))}, 'quality_array': [['-7.773622338227195', '01092026'], ['-7.73250200049155', '02092026'], ['-8.157197240637103', '03092026'], ['-8.639200425442317', '04092026'], ['-8.38228675246505', '05092026'], ['-8.155341060106666', '06092026'], ['-8.566001827907794', '07092026'], ['-8.997864680866961', '08092026'], ['-8.698247727433888', '09092026'], ['-8.744344091413902', '10092026'], ['-8.918428657835648', '11092026'], ['-9.076671915036464', '12092026'], ['-8.747162289665166', '13092026'], ['-8.849053833276223', '14092026'], ['-9.033616171029117', '15092026'], ['-9.327410060262928', '16092026'], ['-9.131776596054213', '17092026'], ['-8.86223395073806', '18092026'], ['-8.884691676648211', '19092026'], ['-9.01659964325401', '20092026'], ['-9.219282077361466', '21092026'], ['-9.13168461751525', '22092026'], ['-8.928237488679763', '23092026'], ['-9.370461171807555', '24092026'], ['-9.411738305970797', '25092026'], ['-9.414831849353286', '26092026'], ['-9.336927402633295', '27092026'], ['-8.869710171705202', '28092026'], ['-9.034348352283294', '29092026'], ['-9.040294047595573', '30092026']], 'number_of_batch': ((589,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02492065915790676, 'nb_photo': 20829, 'list_port_cont': '31100496,31100686,31100962,31101165,31101432,31101668,31101711,31102169,31102513,31102615,31103089,31103216,31103472,31103669,31103935,31104261,31104496,31104750,31105027,31105356,31105394,31105648,31105695,31105723,31106251,31106404,31106683,31106888,31107190,31107359,31107591,31107879,31108169,31108428,31108591,31108972,31109293,31109470,31109811,31110112,31110314,31110521,31110696,31110946,31111151,31111356,31111569,31111597,31112114,31112308,31112517,31112618,31112908,31113195,31113438,31113665,31114081,31114322,31114612,31114814,31115103,31115151,31115408,31115678,31116063,31116351,31116584,31116785,31116995,31117032,31117321,31117522,31117830,31118032,31118233,31118445,31118527,31118792,31119023,31119223,31119475,31119516,31119930,31119968,31120388,31120580,31120853,31121067,31121566,31121607,31121768,31122081,31122288,31122622,31122956,31123116,31123196,31123488,31123747,31123983,31124196,31124454,31124700,31124958,31125210,31125444,31125721,31125913,31127251,31127295,31127347,31127392,31127439,3112748', 'assoc_port': '31100292:31100496,31100524:31100686,31100756:31100962,31100994:31101165,31101211:31101432,31101505:31101711,31101506:31101668,31101983:31102169,31102273:31102513,31102536:31102615,31102788:31103089,31102984:31103216,31103195:31103472,31103492:31103669,31103773:31103935,31104045:31104261,31104285:31104496,31104465:31105356,31104564:31104750,31104732:31105027,31105015:31105648,31105224:31105394,31105471:31105723,31105472:31105695,31106052:31106251,31106286:31106404,31106482:31106683,31106719:31106888,31106969:31107190,31107225:31107359,31107406:31107591,31107671:31107879,31107941:31108169,31108212:31108428,31108472:31108591,31108787:31108972,31109140:31109293,31109325:31109470,31109636:31109811,31109876:31110112,31110052:31110314,31110053:31110521,31110509:31110696,31110727:31110946,31110937:31111151,31111223:31111356,31111494:31111597,31111513:31111569,31111921:31112114,31112155:31112308,31112356:31112517,31112557:31112618,31112732:31112908,31113025:31113195,31113238:31113438,31113490:31113665,31113869:3111408', 'assoc_mat': '31100292:autre:4230:31100496,31100524:autre:4230:31100686,31100756:autre:4230:31100962,31100994:autre:4230:31101165,31101211:autre:4230:31101432,31101505:autre:4230:31101711,31101506:autre:4230:31101668,31101983:autre:4230:31102169,31102273:autre:4230:31102513,31102536:autre:4230:31102615,31102788:autre:4230:31103089,31102984:autre:4230:31103216,31103195:autre:4230:31103472,31103492:autre:4230:31103669,31103773:autre:4230:31103935,31104045:autre:4230:31104261,31104285:autre:4230:31104496,31104465:autre:4230:31105356,31104564:autre:4230:31104750,31104732:autre:4230:31105027,31105015:autre:4230:31105648,31105224:autre:4230:31105394,31105471:autre:4230:31105723,31105472:autre:4230:31105695,31106052:autre:4230:31106251,31106286:autre:4230:31106404,31106482:autre:4230:31106683,31106719:autre:4230:31106888,31106969:autre:4230:31107190,31107225:autre:4230:31107359,31107406:autre:4230:31107591,31107671:autre:4230:31107879,31107941:autre:4230:31108169,31108212:autre:4230:31108428,31108472:autre:4230:31108591,31108787:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.126716316504713, 'nb_photo': 139769, 'list_port_cont': '31100487,31100689,31100949,31101166,31101426,31101666,31101708,31102171,31102511,31102618,31103103,31103211,31103459,31103666,31103934,31104251,31104504,31104749,31105033,31105357,31105409,31105646,31105690,31105729,31106257,31106415,31106688,31106894,31107192,31107365,31107585,31107886,31108177,31108431,31108598,31108966,31109303,31109483,31109812,31110122,31110323,31110520,31110707,31110955,31111156,31111357,31111562,31111606,31112123,31112312,31112525,31112613,31112917,31113189,31113455,31113660,31114084,31114336,31114615,31114809,31115099,31115150,31115409,31115688,31116069,31116358,31116594,31116789,31116984,31117031,31117315,31117529,31117842,31118031,31118221,31118442,31118520,31118793,31119032,31119228,31119477,31119524,31119932,31119972,31120385,31120581,31120840,31121062,31121574,31121619,31121766,31122083,31122281,31122623,31122964,31123113,31123206,31123495,31123745,31123979,31124199,31124448,31124710,31124957,31125199,31125450,31125726,31125914,31127247,31127311,31127342,31127399,31127443,3112747', 'assoc_port': '31100292:31100487,31100524:31100689,31100756:31100949,31100994:31101166,31101211:31101426,31101505:31101708,31101506:31101666,31101983:31102171,31102273:31102511,31102536:31102618,31102788:31103103,31102984:31103211,31103195:31103459,31103492:31103666,31103773:31103934,31104045:31104251,31104285:31104504,31104465:31105357,31104564:31104749,31104732:31105033,31105015:31105646,31105224:31105409,31105471:31105729,31105472:31105690,31106052:31106257,31106286:31106415,31106482:31106688,31106719:31106894,31106969:31107192,31107225:31107365,31107406:31107585,31107671:31107886,31107941:31108177,31108212:31108431,31108472:31108598,31108787:31108966,31109140:31109303,31109325:31109483,31109636:31109812,31109876:31110122,31110052:31110323,31110053:31110520,31110509:31110707,31110727:31110955,31110937:31111156,31111223:31111357,31111494:31111606,31111513:31111562,31111921:31112123,31112155:31112312,31112356:31112525,31112557:31112613,31112732:31112917,31113025:31113189,31113238:31113455,31113490:31113660,31113869:3111408', 'assoc_mat': '31100292:carton:4230:31100487,31100524:carton:4230:31100689,31100756:carton:4230:31100949,31100994:carton:4230:31101166,31101211:carton:4230:31101426,31101505:carton:4230:31101708,31101506:carton:4230:31101666,31101983:carton:4230:31102171,31102273:carton:4230:31102511,31102536:carton:4230:31102618,31102788:carton:4230:31103103,31102984:carton:4230:31103211,31103195:carton:4230:31103459,31103492:carton:4230:31103666,31103773:carton:4230:31103934,31104045:carton:4230:31104251,31104285:carton:4230:31104504,31104465:carton:4230:31105357,31104564:carton:4230:31104749,31104732:carton:4230:31105033,31105015:carton:4230:31105646,31105224:carton:4230:31105409,31105471:carton:4230:31105729,31105472:carton:4230:31105690,31106052:carton:4230:31106257,31106286:carton:4230:31106415,31106482:carton:4230:31106688,31106719:carton:4230:31106894,31106969:carton:4230:31107192,31107225:carton:4230:31107365,31107406:carton:4230:31107585,31107671:carton:4230:31107886,31107941:carton:4230:31108177,31108212:carton:4230:31108431,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001896369468195011, 'nb_photo': 1864, 'list_port_cont': '31100483,31100676,31100947,31101167,31101417,31101699,31102507,31102617,31103104,31103670,31103929,31104264,31104505,31104740,31105036,31105360,31105728,31106247,31106418,31106684,31106887,31107187,31107352,31107576,31108162,31108429,31108594,31108971,31109289,31109481,31109804,31110114,31110325,31110941,31111153,31111599,31112325,31114339,31114624,31114805,31115110,31115152,31115394,31115680,31116066,31116350,31116583,31116786,31116999,31117033,31117513,31117836,31118029,31118437,31118528,31118799,31119026,31119221,31119482,31119519,31119936,31119974,31120379,31120586,31120841,31121576,31121771,31122618,31122954,31123109,31123198,31123487,31123740,31123980,31124188,31124439,31124695,31124941,31125194,31125451,31125723,31125899,31127246,31127298,31127332,31127391,31127429,31127476,31127973,31128025,31128057,31128098,31128132,31128481,31128559,31128769,31128888,31129203,31129635,31129775,31130120,31130382,31130669,31130698,31130773,31131176,31131388,31131557,31131656,31131879,31132134,31132632,31132695,3113273', 'assoc_port': '31100292:31100483,31100524:31100676,31100756:31100947,31100994:31101167,31101211:31101417,31101505:31101699,31102273:31102507,31102536:31102617,31102788:31103104,31103492:31103670,31103773:31103929,31104045:31104264,31104285:31104505,31104465:31105360,31104564:31104740,31104732:31105036,31105471:31105728,31106052:31106247,31106286:31106418,31106482:31106684,31106719:31106887,31106969:31107187,31107225:31107352,31107406:31107576,31107941:31108162,31108212:31108429,31108472:31108594,31108787:31108971,31109140:31109289,31109325:31109481,31109636:31109804,31109876:31110114,31110052:31110325,31110727:31110941,31110937:31111153,31111494:31111599,31112155:31112325,31114149:31114339,31114410:31114624,31114678:31114805,31114854:31115110,31115083:31115152,31115337:31115394,31115613:31115680,31115901:31116066,31116142:31116350,31116386:31116583,31116625:31116786,31116827:31117033,31116828:31116999,31117471:31117513,31117563:31117836,31117867:31118029,31118331:31118437,31118332:31118528,31118471:31118799,31118862:3111902', 'assoc_mat': '31100292:metal:4230:31100483,31100524:metal:4230:31100676,31100756:metal:4230:31100947,31100994:metal:4230:31101167,31101211:metal:4230:31101417,31101505:metal:4230:31101699,31102273:metal:4230:31102507,31102536:metal:4230:31102617,31102788:metal:4230:31103104,31103492:metal:4230:31103670,31103773:metal:4230:31103929,31104045:metal:4230:31104264,31104285:metal:4230:31104505,31104465:metal:4230:31105360,31104564:metal:4230:31104740,31104732:metal:4230:31105036,31105471:metal:4230:31105728,31106052:metal:4230:31106247,31106286:metal:4230:31106418,31106482:metal:4230:31106684,31106719:metal:4230:31106887,31106969:metal:4230:31107187,31107225:metal:4230:31107352,31107406:metal:4230:31107576,31107941:metal:4230:31108162,31108212:metal:4230:31108429,31108472:metal:4230:31108594,31108787:metal:4230:31108971,31109140:metal:4230:31109289,31109325:metal:4230:31109481,31109636:metal:4230:31109804,31109876:metal:4230:31110114,31110052:metal:4230:31110325,31110727:metal:4230:31110941,31110937:metal:4230:31111153,31111494:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3423925832918199, 'nb_photo': 332399, 'list_port_cont': '31100494,31100677,31100960,31101174,31101423,31101673,31101713,31102168,31102510,31102610,31103102,31103219,31103457,31103663,31103939,31104263,31104497,31104738,31105035,31105359,31105400,31105645,31105691,31105733,31106248,31106406,31106689,31106884,31107189,31107367,31107586,31107890,31108172,31108440,31108596,31108974,31109294,31109482,31109815,31110127,31110331,31110526,31110698,31110952,31111159,31111362,31111561,31111609,31112119,31112321,31112526,31112606,31112911,31113201,31113447,31113662,31114075,31114338,31114618,31114811,31115113,31115153,31115406,31115691,31116072,31116345,31116596,31116781,31116994,31117035,31117323,31117527,31117843,31118026,31118234,31118446,31118519,31118790,31119025,31119235,31119473,31119511,31119931,31119970,31120383,31120587,31120849,31121063,31121580,31121622,31121767,31122078,31122286,31122621,31122968,31123123,31123205,31123497,31123746,31123990,31124187,31124452,31124709,31124950,31125206,31125453,31125724,31125916,31127249,31127308,31127344,31127400,31127436,3112748', 'assoc_port': '31100292:31100494,31100524:31100677,31100756:31100960,31100994:31101174,31101211:31101423,31101505:31101713,31101506:31101673,31101983:31102168,31102273:31102510,31102536:31102610,31102788:31103102,31102984:31103219,31103195:31103457,31103492:31103663,31103773:31103939,31104045:31104263,31104285:31104497,31104465:31105359,31104564:31104738,31104732:31105035,31105015:31105645,31105224:31105400,31105471:31105733,31105472:31105691,31106052:31106248,31106286:31106406,31106482:31106689,31106719:31106884,31106969:31107189,31107225:31107367,31107406:31107586,31107671:31107890,31107941:31108172,31108212:31108440,31108472:31108596,31108787:31108974,31109140:31109294,31109325:31109482,31109636:31109815,31109876:31110127,31110052:31110331,31110053:31110526,31110509:31110698,31110727:31110952,31110937:31111159,31111223:31111362,31111494:31111609,31111513:31111561,31111921:31112119,31112155:31112321,31112356:31112526,31112557:31112606,31112732:31112911,31113025:31113201,31113238:31113447,31113490:31113662,31113869:3111407', 'assoc_mat': '31100292:papier:4230:31100494,31100524:papier:4230:31100677,31100756:papier:4230:31100960,31100994:papier:4230:31101174,31101211:papier:4230:31101423,31101505:papier:4230:31101713,31101506:papier:4230:31101673,31101983:papier:4230:31102168,31102273:papier:4230:31102510,31102536:papier:4230:31102610,31102788:papier:4230:31103102,31102984:papier:4230:31103219,31103195:papier:4230:31103457,31103492:papier:4230:31103663,31103773:papier:4230:31103939,31104045:papier:4230:31104263,31104285:papier:4230:31104497,31104465:papier:4230:31105359,31104564:papier:4230:31104738,31104732:papier:4230:31105035,31105015:papier:4230:31105645,31105224:papier:4230:31105400,31105471:papier:4230:31105733,31105472:papier:4230:31105691,31106052:papier:4230:31106248,31106286:papier:4230:31106406,31106482:papier:4230:31106689,31106719:papier:4230:31106884,31106969:papier:4230:31107189,31107225:papier:4230:31107367,31107406:papier:4230:31107586,31107671:papier:4230:31107890,31107941:papier:4230:31108172,31108212:papier:4230:31108440,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007380863903897634, 'nb_photo': 5370, 'list_port_cont': '31100492,31100955,31101169,31101428,31101705,31102167,31102620,31103098,31103937,31104256,31104499,31104746,31105030,31105358,31105403,31105635,31105694,31105726,31106259,31106414,31106687,31106892,31107184,31107364,31107587,31107894,31108174,31108438,31108595,31108981,31109296,31109479,31109819,31110123,31110319,31110524,31112126,31112314,31112523,31112604,31112920,31113203,31113451,31113659,31114079,31114337,31114620,31114804,31115115,31115156,31115694,31116068,31116593,31116998,31117530,31117839,31118523,31118794,31119029,31119229,31119481,31119522,31119979,31120393,31120596,31120845,31121571,31121621,31121770,31122289,31122614,31122957,31123124,31123209,31123494,31123748,31124193,31124455,31124707,31124951,31125202,31125455,31125722,31125912,31127244,31127309,31127336,31127394,31127445,31127484,31127976,31128026,31128062,31128104,31128147,31128494,31128570,31128785,31128885,31129131,31129197,31129662,31129778,31130139,31130385,31130675,31130711,31130782,31131175,31131394,31131561,31131645,31131874,3113214', 'assoc_port': '31100292:31100492,31100756:31100955,31100994:31101169,31101211:31101428,31101505:31101705,31101983:31102167,31102536:31102620,31102788:31103098,31103773:31103937,31104045:31104256,31104285:31104499,31104465:31105358,31104564:31104746,31104732:31105030,31105015:31105635,31105224:31105403,31105471:31105726,31105472:31105694,31106052:31106259,31106286:31106414,31106482:31106687,31106719:31106892,31106969:31107184,31107225:31107364,31107406:31107587,31107671:31107894,31107941:31108174,31108212:31108438,31108472:31108595,31108787:31108981,31109140:31109296,31109325:31109479,31109636:31109819,31109876:31110123,31110052:31110319,31110053:31110524,31111921:31112126,31112155:31112314,31112356:31112523,31112557:31112604,31112732:31112920,31113025:31113203,31113238:31113451,31113490:31113659,31113869:31114079,31114149:31114337,31114410:31114620,31114678:31114804,31114854:31115115,31115083:31115156,31115613:31115694,31115901:31116068,31116386:31116593,31116828:31116998,31117471:31117530,31117563:31117839,31118332:3111852', 'assoc_mat': '31100292:pehd:4230:31100492,31100756:pehd:4230:31100955,31100994:pehd:4230:31101169,31101211:pehd:4230:31101428,31101505:pehd:4230:31101705,31101983:pehd:4230:31102167,31102536:pehd:4230:31102620,31102788:pehd:4230:31103098,31103773:pehd:4230:31103937,31104045:pehd:4230:31104256,31104285:pehd:4230:31104499,31104465:pehd:4230:31105358,31104564:pehd:4230:31104746,31104732:pehd:4230:31105030,31105015:pehd:4230:31105635,31105224:pehd:4230:31105403,31105471:pehd:4230:31105726,31105472:pehd:4230:31105694,31106052:pehd:4230:31106259,31106286:pehd:4230:31106414,31106482:pehd:4230:31106687,31106719:pehd:4230:31106892,31106969:pehd:4230:31107184,31107225:pehd:4230:31107364,31107406:pehd:4230:31107587,31107671:pehd:4230:31107894,31107941:pehd:4230:31108174,31108212:pehd:4230:31108438,31108472:pehd:4230:31108595,31108787:pehd:4230:31108981,31109140:pehd:4230:31109296,31109325:pehd:4230:31109479,31109636:pehd:4230:31109819,31109876:pehd:4230:31110123,31110052:pehd:4230:31110319,31110053:pehd:4230:31110524,31111921:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011166584722419793, 'nb_photo': 17698, 'list_port_cont': '31100484,31100691,31100957,31101170,31101431,31101674,31101701,31102170,31102500,31102616,31103094,31103214,31103467,31103665,31103938,31104257,31104506,31104751,31105034,31105350,31105402,31105638,31105688,31105721,31106261,31106413,31106682,31106882,31107186,31107366,31107588,31107887,31108178,31108442,31108599,31108977,31109297,31109475,31109814,31110126,31110330,31110523,31110701,31110958,31111155,31111369,31111563,31111605,31112129,31112323,31112522,31112617,31112913,31113200,31113445,31113664,31114074,31114335,31114616,31114817,31115114,31115154,31115402,31115681,31116060,31116355,31116591,31116782,31116992,31117029,31117313,31117518,31117831,31118033,31118232,31118441,31118526,31118798,31119017,31119230,31119480,31119512,31119929,31119976,31120392,31120594,31120851,31121065,31121572,31121615,31121769,31122082,31122282,31122608,31122967,31123121,31123197,31123496,31123751,31123989,31124200,31124453,31124705,31124952,31125209,31125448,31125714,31125907,31127242,31127310,31127340,31127395,31127438,3112749', 'assoc_port': '31100292:31100484,31100524:31100691,31100756:31100957,31100994:31101170,31101211:31101431,31101505:31101701,31101506:31101674,31101983:31102170,31102273:31102500,31102536:31102616,31102788:31103094,31102984:31103214,31103195:31103467,31103492:31103665,31103773:31103938,31104045:31104257,31104285:31104506,31104465:31105350,31104564:31104751,31104732:31105034,31105015:31105638,31105224:31105402,31105471:31105721,31105472:31105688,31106052:31106261,31106286:31106413,31106482:31106682,31106719:31106882,31106969:31107186,31107225:31107366,31107406:31107588,31107671:31107887,31107941:31108178,31108212:31108442,31108472:31108599,31108787:31108977,31109140:31109297,31109325:31109475,31109636:31109814,31109876:31110126,31110052:31110330,31110053:31110523,31110509:31110701,31110727:31110958,31110937:31111155,31111223:31111369,31111494:31111605,31111513:31111563,31111921:31112129,31112155:31112323,31112356:31112522,31112557:31112617,31112732:31112913,31113025:31113200,31113238:31113445,31113490:31113664,31113869:3111407', 'assoc_mat': '31100292:pet_clair:4230:31100484,31100524:pet_clair:4230:31100691,31100756:pet_clair:4230:31100957,31100994:pet_clair:4230:31101170,31101211:pet_clair:4230:31101431,31101505:pet_clair:4230:31101701,31101506:pet_clair:4230:31101674,31101983:pet_clair:4230:31102170,31102273:pet_clair:4230:31102500,31102536:pet_clair:4230:31102616,31102788:pet_clair:4230:31103094,31102984:pet_clair:4230:31103214,31103195:pet_clair:4230:31103467,31103492:pet_clair:4230:31103665,31103773:pet_clair:4230:31103938,31104045:pet_clair:4230:31104257,31104285:pet_clair:4230:31104506,31104465:pet_clair:4230:31105350,31104564:pet_clair:4230:31104751,31104732:pet_clair:4230:31105034,31105015:pet_clair:4230:31105638,31105224:pet_clair:4230:31105402,31105471:pet_clair:4230:31105721,31105472:pet_clair:4230:31105688,31106052:pet_clair:4230:31106261,31106286:pet_clair:4230:31106413,31106482:pet_clair:4230:31106682,31106719:pet_clair:4230:31106882,31106969:pet_clair:4230:31107186,31107225:pet_clair:4230:31107366,31107406:pet_clair:4230:31107588,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005500565632600825, 'nb_photo': 1298, 'list_port_cont': '31101716,31102159,31102512,31102607,31103096,31103208,31103470,31103668,31104258,31104502,31104744,31105031,31105355,31105408,31105644,31105692,31106252,31106681,31106891,31107194,31107360,31107889,31108436,31108979,31109302,31109474,31109817,31110117,31110529,31110945,31111158,31111371,31112322,31112614,31114625,31114818,31115107,31115155,31115689,31117023,31118018,31118229,31118449,31118513,31118789,31119030,31119521,31120390,31120584,31120843,31121764,31122076,31122283,31122619,31122965,31123744,31123993,31124447,31124704,31124956,31125203,31125447,31125725,31125908,31127250,31127306,31127337,31127397,31127442,31127485,31127981,31128028,31128067,31128110,31128148,31128483,31128568,31128780,31128882,31129640,31129769,31130122,31130375,31130674,31130697,31130775,31131187,31131397,31131569,31131647,31131884,31132146,31132633,31132699,31132736,31132776,31132815,31132865,31132909,31132949,31132985,31133056,31133088,31134200,31134240,31134324,31134357,31134713,31135302,31135680,31135971,31136056,31136316,3113660', 'assoc_port': '31101505:31101716,31101983:31102159,31102273:31102512,31102536:31102607,31102788:31103096,31102984:31103208,31103195:31103470,31103492:31103668,31104045:31104258,31104285:31104502,31104465:31105355,31104564:31104744,31104732:31105031,31105015:31105644,31105224:31105408,31105472:31105692,31106052:31106252,31106482:31106681,31106719:31106891,31106969:31107194,31107225:31107360,31107671:31107889,31108212:31108436,31108787:31108979,31109140:31109302,31109325:31109474,31109636:31109817,31109876:31110117,31110053:31110529,31110727:31110945,31110937:31111158,31111223:31111371,31112155:31112322,31112557:31112614,31114410:31114625,31114678:31114818,31114854:31115107,31115083:31115155,31115613:31115689,31116827:31117023,31117867:31118018,31118063:31118229,31118331:31118449,31118332:31118513,31118471:31118789,31118862:31119030,31119310:31119521,31120181:31120390,31120426:31120584,31120635:31120843,31121557:31121764,31121878:31122076,31122118:31122283,31122363:31122619,31122766:31122965,31123533:31123744,31123781:3112399', 'assoc_mat': '31101505:pet_fonce:4230:31101716,31101983:pet_fonce:4230:31102159,31102273:pet_fonce:4230:31102512,31102536:pet_fonce:4230:31102607,31102788:pet_fonce:4230:31103096,31102984:pet_fonce:4230:31103208,31103195:pet_fonce:4230:31103470,31103492:pet_fonce:4230:31103668,31104045:pet_fonce:4230:31104258,31104285:pet_fonce:4230:31104502,31104465:pet_fonce:4230:31105355,31104564:pet_fonce:4230:31104744,31104732:pet_fonce:4230:31105031,31105015:pet_fonce:4230:31105644,31105224:pet_fonce:4230:31105408,31105472:pet_fonce:4230:31105692,31106052:pet_fonce:4230:31106252,31106482:pet_fonce:4230:31106681,31106719:pet_fonce:4230:31106891,31106969:pet_fonce:4230:31107194,31107225:pet_fonce:4230:31107360,31107671:pet_fonce:4230:31107889,31108212:pet_fonce:4230:31108436,31108787:pet_fonce:4230:31108979,31109140:pet_fonce:4230:31109302,31109325:pet_fonce:4230:31109474,31109636:pet_fonce:4230:31109817,31109876:pet_fonce:4230:31110117,31110053:pet_fonce:4230:31110529,31110727:pet_fonce:4230:31110945,31110937:pet_fonce:4230:31111158,3'}), 'main_stat': {'nb_photos': 1471}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31195441,31195442,31195443,31195444,31195445,31195446,31195447?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.5120526145581253),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_09_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.49%', 20829], 'carton': ['carton', '12.67%', 139769], 'metal': ['metal', '0.19%', 1864], 'papier': ['papier', '34.24%', 332399], 'pehd': ['pehd', '0.74%', 5370], 'pet_clair': ['pet_clair', '1.12%', 17698], 'pet_fonce': ['pet_fonce', '0.55%', 1298]}} 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_09_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.65user 2.81system 0:07.14elapsed 76%CPU (0avgtext+0avgdata 191072maxresident)k 8inputs+320outputs (1major+54323minor)pagefaults 0swaps