python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (1, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 09 mtr_id : dashboard_places : SCCU_cam6 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_cam6' 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 = 202 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 = 202 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 = 202 and mp.name like '%092026%' and cps.thcl = 1533 GROUP BY sbstr ; 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_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-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 (2993842,2994608,2995340,2995934,2996660,2997266,2997726,2998398,2999054,2999690,3000340,3000752,3001106,3001526,3001980,3002522,3003122,3003750,3004300,3004750,3005322,3005960,3006580,3007262,3007846,3008426,3008798,3009346,3009780,3010494) 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.011638589706217254, 'nb_photo': 16132, 'list_port_cont': '31100385,31100582,31100833,31101050,31101279,31101560,31101847,31102075,31102329,31102899,31103014,31103254,31103515,31103742,31104013,31104420,31104582,31104773,31104811,31105145,31105439,31105527,31105757,31105801,31106140,31106333,31106532,31106810,31107043,31107279,31107464,31107743,31108035,31108273,31108565,31108888,31109203,31109564,31109886,31110194,31110440,31110564,31110819,31111054,31111449,31111644,31111683,31111830,31111940,31112198,31112689,31112758,31112992,31113106,31113369,31113575,31113784,31113956,31114282,31114535,31114736,31114870,31115217,31115517,31115751,31115956,31116195,31116436,31116713,31116838,31117166,31117208,31117568,31117605,31117913,31118121,31118285,31118586,31118818,31118867,31119125,31119354,31119648,31119865,31120098,31120203,31120477,31120737,31120948,31121105,31121451,31121688,31121917,31122198,31122381,31122411,31122782,31123004,31123159,31123342,31123560,31123829,31124039,31124248,31124533,31124787,31125038,31125246,31125557,31125953,31127530,31127554,31127594,3112767', 'assoc_port': '31100285:31100385,31100518:31100582,31100750:31100833,31100987:31101050,31101200:31101279,31101495:31101560,31101741:31101847,31101969:31102075,31102237:31102329,31102542:31103014,31102775:31102899,31103059:31103254,31103395:31103515,31103576:31103742,31103857:31104013,31104234:31104420,31104453:31104582,31104646:31104773,31104647:31104811,31105005:31105145,31105212:31105439,31105384:31105527,31105667:31105801,31105668:31105757,31106045:31106140,31106280:31106333,31106476:31106532,31106713:31106810,31106959:31107043,31107217:31107279,31107396:31107464,31107660:31107743,31107925:31108035,31108198:31108273,31108477:31108565,31108773:31108888,31109076:31109203,31109330:31109564,31109725:31109886,31110040:31110194,31110264:31110440,31110500:31110564,31110675:31110819,31110888:31111054,31111093:31111830,31111300:31111449,31111544:31111683,31111545:31111644,31111915:31111940,31112149:31112198,31112349:31112689,31112549:31112992,31112722:31112758,31113016:31113106,31113228:31113369,31113480:31113575,31113690:3111378', 'assoc_mat': '31100285:autre:4230:31100385,31100518:autre:4230:31100582,31100750:autre:4230:31100833,31100987:autre:4230:31101050,31101200:autre:4230:31101279,31101495:autre:4230:31101560,31101741:autre:4230:31101847,31101969:autre:4230:31102075,31102237:autre:4230:31102329,31102542:autre:4230:31103014,31102775:autre:4230:31102899,31103059:autre:4230:31103254,31103395:autre:4230:31103515,31103576:autre:4230:31103742,31103857:autre:4230:31104013,31104234:autre:4230:31104420,31104453:autre:4230:31104582,31104646:autre:4230:31104773,31104647:autre:4230:31104811,31105005:autre:4230:31105145,31105212:autre:4230:31105439,31105384:autre:4230:31105527,31105667:autre:4230:31105801,31105668:autre:4230:31105757,31106045:autre:4230:31106140,31106280:autre:4230:31106333,31106476:autre:4230:31106532,31106713:autre:4230:31106810,31106959:autre:4230:31107043,31107217:autre:4230:31107279,31107396:autre:4230:31107464,31107660:autre:4230:31107743,31107925:autre:4230:31108035,31108198:autre:4230:31108273,31108477:autre:4230:31108565,31108773:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0320679391976196, 'nb_photo': 65158, 'list_port_cont': '31100380,31100570,31100844,31101052,31101270,31101559,31101852,31102086,31102340,31102898,31103019,31103253,31103507,31103740,31104016,31104424,31104578,31104787,31104825,31105147,31105446,31105519,31105773,31105810,31106139,31106336,31106531,31106805,31107032,31107287,31107461,31107747,31108046,31108272,31108554,31108893,31109218,31109562,31109891,31110196,31110442,31110578,31110822,31111056,31111448,31111646,31111679,31111839,31111936,31112202,31112678,31112765,31112989,31113122,31113370,31113573,31113780,31113963,31114290,31114541,31114738,31114869,31115230,31115516,31115762,31115949,31116184,31116433,31116711,31116840,31117165,31117206,31117581,31117618,31117920,31118114,31118294,31118597,31118834,31118878,31119126,31119359,31119659,31119862,31120107,31120200,31120484,31120734,31120939,31121115,31121446,31121698,31121934,31122212,31122384,31122422,31122781,31123006,31123160,31123333,31123564,31123840,31124037,31124254,31124538,31124785,31125051,31125256,31125560,31125947,31127525,31127562,31127601,3112767', 'assoc_port': '31100285:31100380,31100518:31100570,31100750:31100844,31100987:31101052,31101200:31101270,31101495:31101559,31101741:31101852,31101969:31102086,31102237:31102340,31102542:31103019,31102775:31102898,31103059:31103253,31103395:31103507,31103576:31103740,31103857:31104016,31104234:31104424,31104453:31104578,31104646:31104787,31104647:31104825,31105005:31105147,31105212:31105446,31105384:31105519,31105667:31105810,31105668:31105773,31106045:31106139,31106280:31106336,31106476:31106531,31106713:31106805,31106959:31107032,31107217:31107287,31107396:31107461,31107660:31107747,31107925:31108046,31108198:31108272,31108477:31108554,31108773:31108893,31109076:31109218,31109330:31109562,31109725:31109891,31110040:31110196,31110264:31110442,31110500:31110578,31110675:31110822,31110888:31111056,31111093:31111839,31111300:31111448,31111544:31111679,31111545:31111646,31111915:31111936,31112149:31112202,31112349:31112678,31112549:31112989,31112722:31112765,31113016:31113122,31113228:31113370,31113480:31113573,31113690:3111378', 'assoc_mat': '31100285:carton:4230:31100380,31100518:carton:4230:31100570,31100750:carton:4230:31100844,31100987:carton:4230:31101052,31101200:carton:4230:31101270,31101495:carton:4230:31101559,31101741:carton:4230:31101852,31101969:carton:4230:31102086,31102237:carton:4230:31102340,31102542:carton:4230:31103019,31102775:carton:4230:31102898,31103059:carton:4230:31103253,31103395:carton:4230:31103507,31103576:carton:4230:31103740,31103857:carton:4230:31104016,31104234:carton:4230:31104424,31104453:carton:4230:31104578,31104646:carton:4230:31104787,31104647:carton:4230:31104825,31105005:carton:4230:31105147,31105212:carton:4230:31105446,31105384:carton:4230:31105519,31105667:carton:4230:31105810,31105668:carton:4230:31105773,31106045:carton:4230:31106139,31106280:carton:4230:31106336,31106476:carton:4230:31106531,31106713:carton:4230:31106805,31106959:carton:4230:31107032,31107217:carton:4230:31107287,31107396:carton:4230:31107461,31107660:carton:4230:31107747,31107925:carton:4230:31108046,31108198:carton:4230:31108272,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008653669402062256, 'nb_photo': 1448, 'list_port_cont': '31100372,31100568,31100834,31101051,31102076,31102331,31102887,31103016,31103256,31103511,31103743,31104427,31104569,31104777,31104828,31105124,31105438,31105765,31105803,31106132,31106338,31106809,31107041,31107738,31108033,31108263,31108559,31108881,31109210,31109572,31109889,31110205,31110433,31110577,31110816,31111066,31111437,31111633,31111668,31111837,31111930,31112763,31112980,31113116,31113374,31113580,31113792,31113955,31114284,31114536,31114723,31114865,31115233,31115518,31115754,31115959,31116193,31116438,31116719,31116834,31117199,31117576,31118119,31118870,31119114,31119355,31119646,31119852,31120096,31120193,31120473,31120736,31120952,31121114,31121436,31121691,31122213,31122419,31123565,31123832,31124048,31124544,31124793,31125049,31125247,31125941,31127566,31127592,31127664,31128181,31128216,31128252,31128288,31128438,31128529,31128592,31128642,31128923,31129322,31130068,31130425,31130742,31130849,31130900,31131322,31131481,31131720,31131844,31132188,31132583,31133132,31133217,31133344,3113346', 'assoc_port': '31100285:31100372,31100518:31100568,31100750:31100834,31100987:31101051,31101969:31102076,31102237:31102331,31102542:31103016,31102775:31102887,31103059:31103256,31103395:31103511,31103576:31103743,31104234:31104427,31104453:31104569,31104646:31104777,31104647:31104828,31105005:31105124,31105212:31105438,31105667:31105803,31105668:31105765,31106045:31106132,31106280:31106338,31106713:31106809,31106959:31107041,31107660:31107738,31107925:31108033,31108198:31108263,31108477:31108559,31108773:31108881,31109076:31109210,31109330:31109572,31109725:31109889,31110040:31110205,31110264:31110433,31110500:31110577,31110675:31110816,31110888:31111066,31111093:31111837,31111300:31111437,31111544:31111668,31111545:31111633,31111915:31111930,31112549:31112980,31112722:31112763,31113016:31113116,31113228:31113374,31113480:31113580,31113690:31113792,31113859:31113955,31114137:31114284,31114402:31114536,31114646:31114723,31114845:31114865,31115086:31115233,31115344:31115518,31115616:31115754,31115894:31115959,31116135:3111619', 'assoc_mat': '31100285:metal:4230:31100372,31100518:metal:4230:31100568,31100750:metal:4230:31100834,31100987:metal:4230:31101051,31101969:metal:4230:31102076,31102237:metal:4230:31102331,31102542:metal:4230:31103016,31102775:metal:4230:31102887,31103059:metal:4230:31103256,31103395:metal:4230:31103511,31103576:metal:4230:31103743,31104234:metal:4230:31104427,31104453:metal:4230:31104569,31104646:metal:4230:31104777,31104647:metal:4230:31104828,31105005:metal:4230:31105124,31105212:metal:4230:31105438,31105667:metal:4230:31105803,31105668:metal:4230:31105765,31106045:metal:4230:31106132,31106280:metal:4230:31106338,31106713:metal:4230:31106809,31106959:metal:4230:31107041,31107660:metal:4230:31107738,31107925:metal:4230:31108033,31108198:metal:4230:31108263,31108477:metal:4230:31108559,31108773:metal:4230:31108881,31109076:metal:4230:31109210,31109330:metal:4230:31109572,31109725:metal:4230:31109889,31110040:metal:4230:31110205,31110264:metal:4230:31110433,31110500:metal:4230:31110577,31110675:metal:4230:31110816,31110888:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16440502167032695, 'nb_photo': 404375, 'list_port_cont': '31100370,31100575,31100848,31101056,31101278,31101561,31101853,31102074,31102343,31102902,31103030,31103248,31103517,31103744,31104010,31104431,31104580,31104784,31104819,31105137,31105450,31105523,31105769,31105797,31106148,31106337,31106533,31106801,31107042,31107284,31107467,31107753,31108039,31108269,31108556,31108887,31109211,31109567,31109892,31110204,31110436,31110579,31110826,31111070,31111436,31111643,31111672,31111843,31111933,31112207,31112676,31112754,31112991,31113120,31113364,31113581,31113789,31113967,31114295,31114545,31114731,31114868,31115224,31115520,31115758,31115951,31116188,31116439,31116715,31116845,31117167,31117203,31117580,31117615,31117914,31118120,31118295,31118601,31118832,31118881,31119113,31119362,31119657,31119861,31120103,31120197,31120481,31120732,31120944,31121106,31121441,31121687,31121931,31122211,31122377,31122412,31122774,31123012,31123169,31123346,31123555,31123841,31124042,31124253,31124548,31124789,31125045,31125250,31125566,31125950,31127521,31127565,31127593,3112767', 'assoc_port': '31100285:31100370,31100518:31100575,31100750:31100848,31100987:31101056,31101200:31101278,31101495:31101561,31101741:31101853,31101969:31102074,31102237:31102343,31102542:31103030,31102775:31102902,31103059:31103248,31103395:31103517,31103576:31103744,31103857:31104010,31104234:31104431,31104453:31104580,31104646:31104784,31104647:31104819,31105005:31105137,31105212:31105450,31105384:31105523,31105667:31105797,31105668:31105769,31106045:31106148,31106280:31106337,31106476:31106533,31106713:31106801,31106959:31107042,31107217:31107284,31107396:31107467,31107660:31107753,31107925:31108039,31108198:31108269,31108477:31108556,31108773:31108887,31109076:31109211,31109330:31109567,31109725:31109892,31110040:31110204,31110264:31110436,31110500:31110579,31110675:31110826,31110888:31111070,31111093:31111843,31111300:31111436,31111544:31111672,31111545:31111643,31111915:31111933,31112149:31112207,31112349:31112676,31112549:31112991,31112722:31112754,31113016:31113120,31113228:31113364,31113480:31113581,31113690:3111378', 'assoc_mat': '31100285:papier:4230:31100370,31100518:papier:4230:31100575,31100750:papier:4230:31100848,31100987:papier:4230:31101056,31101200:papier:4230:31101278,31101495:papier:4230:31101561,31101741:papier:4230:31101853,31101969:papier:4230:31102074,31102237:papier:4230:31102343,31102542:papier:4230:31103030,31102775:papier:4230:31102902,31103059:papier:4230:31103248,31103395:papier:4230:31103517,31103576:papier:4230:31103744,31103857:papier:4230:31104010,31104234:papier:4230:31104431,31104453:papier:4230:31104580,31104646:papier:4230:31104784,31104647:papier:4230:31104819,31105005:papier:4230:31105137,31105212:papier:4230:31105450,31105384:papier:4230:31105523,31105667:papier:4230:31105797,31105668:papier:4230:31105769,31106045:papier:4230:31106148,31106280:papier:4230:31106337,31106476:papier:4230:31106533,31106713:papier:4230:31106801,31106959:papier:4230:31107042,31107217:papier:4230:31107284,31107396:papier:4230:31107467,31107660:papier:4230:31107753,31107925:papier:4230:31108039,31108198:papier:4230:31108269,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023970000469461265, 'nb_photo': 1414, 'list_port_cont': '31100384,31101055,31101562,31102080,31103031,31103514,31103737,31104425,31104581,31104776,31104826,31105143,31105448,31105525,31107034,31107469,31107752,31108886,31109217,31109570,31109885,31110190,31110443,31110574,31110830,31111067,31111447,31111935,31112205,31112687,31112760,31112994,31113115,31113376,31113583,31113791,31114293,31114543,31114737,31114873,31115226,31115763,31117604,31118600,31118873,31119119,31119654,31120104,31120188,31120485,31121110,31121448,31122784,31123833,31124792,31125044,31125254,31125569,31125954,31127529,31127563,31127602,31127667,31128263,31128453,31128523,31128844,31130057,31130739,31130860,31130898,31131449,31131722,31133574,31134431,31134501,31134743,31135033,31135070,31135269,31135605,31135808,31135856,31138059,31138269,31138850,31139117,31139341,31139595,31139919,31140830,31141099,31141385,31141784,31142442,31142487,31142884,31143112,31143290,31143459,31143806,31144049,31144339,31144616,31144757,31145074,31145385,31145880,31146718,31147231,31147443,31147721,31149954,3115053', 'assoc_port': '31100285:31100384,31100987:31101055,31101495:31101562,31101969:31102080,31102542:31103031,31103395:31103514,31103576:31103737,31104234:31104425,31104453:31104581,31104646:31104776,31104647:31104826,31105005:31105143,31105212:31105448,31105384:31105525,31106959:31107034,31107396:31107469,31107660:31107752,31108773:31108886,31109076:31109217,31109330:31109570,31109725:31109885,31110040:31110190,31110264:31110443,31110500:31110574,31110675:31110830,31110888:31111067,31111300:31111447,31111915:31111935,31112149:31112205,31112349:31112687,31112549:31112994,31112722:31112760,31113016:31113115,31113228:31113376,31113480:31113583,31113690:31113791,31114137:31114293,31114402:31114543,31114646:31114737,31114845:31114873,31115086:31115226,31115616:31115763,31117556:31117604,31118387:31118600,31118854:31118873,31119055:31119119,31119545:31119654,31120003:31120104,31120171:31120188,31120420:31120485,31121090:31121110,31121317:31121448,31122759:31122784,31123774:31123833,31124688:31124792,31124939:31125044,31125230:3112525', 'assoc_mat': '31100285:pehd:4230:31100384,31100987:pehd:4230:31101055,31101495:pehd:4230:31101562,31101969:pehd:4230:31102080,31102542:pehd:4230:31103031,31103395:pehd:4230:31103514,31103576:pehd:4230:31103737,31104234:pehd:4230:31104425,31104453:pehd:4230:31104581,31104646:pehd:4230:31104776,31104647:pehd:4230:31104826,31105005:pehd:4230:31105143,31105212:pehd:4230:31105448,31105384:pehd:4230:31105525,31106959:pehd:4230:31107034,31107396:pehd:4230:31107469,31107660:pehd:4230:31107752,31108773:pehd:4230:31108886,31109076:pehd:4230:31109217,31109330:pehd:4230:31109570,31109725:pehd:4230:31109885,31110040:pehd:4230:31110190,31110264:pehd:4230:31110443,31110500:pehd:4230:31110574,31110675:pehd:4230:31110830,31110888:pehd:4230:31111067,31111300:pehd:4230:31111447,31111915:pehd:4230:31111935,31112149:pehd:4230:31112205,31112349:pehd:4230:31112687,31112549:pehd:4230:31112994,31112722:pehd:4230:31112760,31113016:pehd:4230:31113115,31113228:pehd:4230:31113376,31113480:pehd:4230:31113583,31113690:pehd:4230:31113791,31114137:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.019088504064345726, 'nb_photo': 25295, 'list_port_cont': '31100383,31100579,31100850,31101059,31101280,31101563,31101846,31102087,31102344,31102901,31103020,31103251,31103513,31103741,31104007,31104421,31104579,31104785,31104827,31105149,31105449,31105532,31105774,31105807,31106144,31106341,31106539,31106815,31107035,31107282,31107468,31107751,31108045,31108267,31108564,31108891,31109216,31109566,31109895,31110203,31110445,31110572,31110831,31111068,31111439,31111647,31111678,31111842,31111937,31112208,31112681,31112757,31112985,31113110,31113377,31113585,31113785,31113971,31114297,31114538,31114726,31114863,31115229,31115524,31115767,31115957,31116191,31116428,31116720,31116843,31117164,31117204,31117577,31117611,31117921,31118123,31118299,31118595,31118835,31118883,31119118,31119361,31119661,31119864,31120105,31120199,31120480,31120729,31120946,31121118,31121450,31121699,31121930,31122208,31122378,31122420,31122776,31123014,31123168,31123344,31123553,31123842,31124033,31124252,31124539,31124795,31125053,31125259,31125564,31125951,31127520,31127561,31127604,3112766', 'assoc_port': '31100285:31100383,31100518:31100579,31100750:31100850,31100987:31101059,31101200:31101280,31101495:31101563,31101741:31101846,31101969:31102087,31102237:31102344,31102542:31103020,31102775:31102901,31103059:31103251,31103395:31103513,31103576:31103741,31103857:31104007,31104234:31104421,31104453:31104579,31104646:31104785,31104647:31104827,31105005:31105149,31105212:31105449,31105384:31105532,31105667:31105807,31105668:31105774,31106045:31106144,31106280:31106341,31106476:31106539,31106713:31106815,31106959:31107035,31107217:31107282,31107396:31107468,31107660:31107751,31107925:31108045,31108198:31108267,31108477:31108564,31108773:31108891,31109076:31109216,31109330:31109566,31109725:31109895,31110040:31110203,31110264:31110445,31110500:31110572,31110675:31110831,31110888:31111068,31111093:31111842,31111300:31111439,31111544:31111678,31111545:31111647,31111915:31111937,31112149:31112208,31112349:31112681,31112549:31112985,31112722:31112757,31113016:31113110,31113228:31113377,31113480:31113585,31113690:3111378', 'assoc_mat': '31100285:pet_clair:4230:31100383,31100518:pet_clair:4230:31100579,31100750:pet_clair:4230:31100850,31100987:pet_clair:4230:31101059,31101200:pet_clair:4230:31101280,31101495:pet_clair:4230:31101563,31101741:pet_clair:4230:31101846,31101969:pet_clair:4230:31102087,31102237:pet_clair:4230:31102344,31102542:pet_clair:4230:31103020,31102775:pet_clair:4230:31102901,31103059:pet_clair:4230:31103251,31103395:pet_clair:4230:31103513,31103576:pet_clair:4230:31103741,31103857:pet_clair:4230:31104007,31104234:pet_clair:4230:31104421,31104453:pet_clair:4230:31104579,31104646:pet_clair:4230:31104785,31104647:pet_clair:4230:31104827,31105005:pet_clair:4230:31105149,31105212:pet_clair:4230:31105449,31105384:pet_clair:4230:31105532,31105667:pet_clair:4230:31105807,31105668:pet_clair:4230:31105774,31106045:pet_clair:4230:31106144,31106280:pet_clair:4230:31106341,31106476:pet_clair:4230:31106539,31106713:pet_clair:4230:31106815,31106959:pet_clair:4230:31107035,31107217:pet_clair:4230:31107282,31107396:pet_clair:4230:31107468,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0020269251894684836, 'nb_photo': 805, 'list_port_cont': '31100577,31101054,31103029,31103508,31103739,31104008,31104426,31104576,31104782,31104820,31105151,31106146,31106331,31106807,31107754,31108047,31108562,31108894,31109213,31109557,31110201,31110437,31110829,31111440,31111828,31111939,31112209,31112684,31112762,31112988,31113117,31113378,31113587,31113790,31113966,31114296,31114542,31114735,31114874,31115232,31118118,31118596,31119120,31119367,31119658,31120102,31120937,31121928,31122418,31122783,31123010,31123557,31124255,31124543,31124796,31125052,31125260,31125567,31125946,31127527,31127557,31127598,31127678,31128180,31128226,31128258,31128452,31128607,31128841,31128920,31129236,31129317,31129532,31129808,31130421,31130895,31131321,31132581,31133138,31134426,31134741,31134820,31135029,31135057,31135261,31135591,31135852,31136728,31137376,31137715,31137888,31138264,31138581,31139107,31139348,31139916,31140831,31141957,31142449,31142481,31142889,31143109,31143293,31143464,31143800,31144051,31144341,31144607,31144758,31145381,31145614,31145878,31146905,3114743', 'assoc_port': '31100518:31100577,31100987:31101054,31102542:31103029,31103395:31103508,31103576:31103739,31103857:31104008,31104234:31104426,31104453:31104576,31104646:31104782,31104647:31104820,31105005:31105151,31106045:31106146,31106280:31106331,31106713:31106807,31107660:31107754,31107925:31108047,31108477:31108562,31108773:31108894,31109076:31109213,31109330:31109557,31110040:31110201,31110264:31110437,31110675:31110829,31111093:31111828,31111300:31111440,31111915:31111939,31112149:31112209,31112349:31112684,31112549:31112988,31112722:31112762,31113016:31113117,31113228:31113378,31113480:31113587,31113690:31113790,31113859:31113966,31114137:31114296,31114402:31114542,31114646:31114735,31114845:31114874,31115086:31115232,31118057:31118118,31118387:31118596,31119055:31119120,31119301:31119367,31119545:31119658,31120003:31120102,31120878:31120937,31121869:31121928,31122356:31122418,31122759:31122783,31122990:31123010,31123523:31123557,31124227:31124255,31124474:31124543,31124688:31124796,31124939:31125052,31125230:3112526', 'assoc_mat': '31100518:pet_fonce:4230:31100577,31100987:pet_fonce:4230:31101054,31102542:pet_fonce:4230:31103029,31103395:pet_fonce:4230:31103508,31103576:pet_fonce:4230:31103739,31103857:pet_fonce:4230:31104008,31104234:pet_fonce:4230:31104426,31104453:pet_fonce:4230:31104576,31104646:pet_fonce:4230:31104782,31104647:pet_fonce:4230:31104820,31105005:pet_fonce:4230:31105151,31106045:pet_fonce:4230:31106146,31106280:pet_fonce:4230:31106331,31106713:pet_fonce:4230:31106807,31107660:pet_fonce:4230:31107754,31107925:pet_fonce:4230:31108047,31108477:pet_fonce:4230:31108562,31108773:pet_fonce:4230:31108894,31109076:pet_fonce:4230:31109213,31109330:pet_fonce:4230:31109557,31110040:pet_fonce:4230:31110201,31110264:pet_fonce:4230:31110437,31110675:pet_fonce:4230:31110829,31111093:pet_fonce:4230:31111828,31111300:pet_fonce:4230:31111440,31111915:pet_fonce:4230:31111939,31112149:pet_fonce:4230:31112209,31112349:pet_fonce:4230:31112684,31112549:pet_fonce:4230:31112988,31112722:pet_fonce:4230:31112762,31113016:pet_fonce:4230:31113117,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(2993842,2994608,2995340,2995934,2996660,2997266,2997726,2998398,2999054,2999690,3000340,3000752,3001106,3001526,3001980,3002522,3003122,3003750,3004300,3004750,3005322,3005960,3006580,3007262,3007846,3008426,3008798,3009346,3009780,3010494)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195415, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100385,31100582,31100833,31101050,31101279,31101560,31101847,31102075,31102329,31102899,31103014,31103254,31103515,31103742,31104013,31104420,31104582,31104773,31104811,31105145,31105439,31105527,31105757,31105801,31106140,31106333,31106532,31106810,31107043,31107279,31107464,31107743,31108035,31108273,31108565,31108888,31109203,31109564,31109886,31110194,31110440,31110564,31110819,31111054,31111449,31111644,31111683,31111830,31111940,31112198,31112689,31112758,31112992,31113106,31113369,31113575,31113784,31113956,31114282,31114535,31114736,31114870,31115217,31115517,31115751,31115956,31116195,31116436,31116713,31116838,31117166,31117208,31117568,31117605,31117913,31118121,31118285,31118586,31118818,31118867,31119125,31119354,31119648,31119865,31120098,31120203,31120477,31120737,31120948,31121105,31121451,31121688,31121917,31122198,31122381,31122411,31122782,31123004,31123159,31123342,31123560,31123829,31124039,31124248,31124533,31124787,31125038,31125246,31125557,31125953,31127530,31127554,31127594,3112767 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195416, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100380,31100570,31100844,31101052,31101270,31101559,31101852,31102086,31102340,31102898,31103019,31103253,31103507,31103740,31104016,31104424,31104578,31104787,31104825,31105147,31105446,31105519,31105773,31105810,31106139,31106336,31106531,31106805,31107032,31107287,31107461,31107747,31108046,31108272,31108554,31108893,31109218,31109562,31109891,31110196,31110442,31110578,31110822,31111056,31111448,31111646,31111679,31111839,31111936,31112202,31112678,31112765,31112989,31113122,31113370,31113573,31113780,31113963,31114290,31114541,31114738,31114869,31115230,31115516,31115762,31115949,31116184,31116433,31116711,31116840,31117165,31117206,31117581,31117618,31117920,31118114,31118294,31118597,31118834,31118878,31119126,31119359,31119659,31119862,31120107,31120200,31120484,31120734,31120939,31121115,31121446,31121698,31121934,31122212,31122384,31122422,31122781,31123006,31123160,31123333,31123564,31123840,31124037,31124254,31124538,31124785,31125051,31125256,31125560,31125947,31127525,31127562,31127601,3112767 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195417, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100372,31100568,31100834,31101051,31102076,31102331,31102887,31103016,31103256,31103511,31103743,31104427,31104569,31104777,31104828,31105124,31105438,31105765,31105803,31106132,31106338,31106809,31107041,31107738,31108033,31108263,31108559,31108881,31109210,31109572,31109889,31110205,31110433,31110577,31110816,31111066,31111437,31111633,31111668,31111837,31111930,31112763,31112980,31113116,31113374,31113580,31113792,31113955,31114284,31114536,31114723,31114865,31115233,31115518,31115754,31115959,31116193,31116438,31116719,31116834,31117199,31117576,31118119,31118870,31119114,31119355,31119646,31119852,31120096,31120193,31120473,31120736,31120952,31121114,31121436,31121691,31122213,31122419,31123565,31123832,31124048,31124544,31124793,31125049,31125247,31125941,31127566,31127592,31127664,31128181,31128216,31128252,31128288,31128438,31128529,31128592,31128642,31128923,31129322,31130068,31130425,31130742,31130849,31130900,31131322,31131481,31131720,31131844,31132188,31132583,31133132,31133217,31133344,3113346 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195418, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100370,31100575,31100848,31101056,31101278,31101561,31101853,31102074,31102343,31102902,31103030,31103248,31103517,31103744,31104010,31104431,31104580,31104784,31104819,31105137,31105450,31105523,31105769,31105797,31106148,31106337,31106533,31106801,31107042,31107284,31107467,31107753,31108039,31108269,31108556,31108887,31109211,31109567,31109892,31110204,31110436,31110579,31110826,31111070,31111436,31111643,31111672,31111843,31111933,31112207,31112676,31112754,31112991,31113120,31113364,31113581,31113789,31113967,31114295,31114545,31114731,31114868,31115224,31115520,31115758,31115951,31116188,31116439,31116715,31116845,31117167,31117203,31117580,31117615,31117914,31118120,31118295,31118601,31118832,31118881,31119113,31119362,31119657,31119861,31120103,31120197,31120481,31120732,31120944,31121106,31121441,31121687,31121931,31122211,31122377,31122412,31122774,31123012,31123169,31123346,31123555,31123841,31124042,31124253,31124548,31124789,31125045,31125250,31125566,31125950,31127521,31127565,31127593,3112767 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195419, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100384,31101055,31101562,31102080,31103031,31103514,31103737,31104425,31104581,31104776,31104826,31105143,31105448,31105525,31107034,31107469,31107752,31108886,31109217,31109570,31109885,31110190,31110443,31110574,31110830,31111067,31111447,31111935,31112205,31112687,31112760,31112994,31113115,31113376,31113583,31113791,31114293,31114543,31114737,31114873,31115226,31115763,31117604,31118600,31118873,31119119,31119654,31120104,31120188,31120485,31121110,31121448,31122784,31123833,31124792,31125044,31125254,31125569,31125954,31127529,31127563,31127602,31127667,31128263,31128453,31128523,31128844,31130057,31130739,31130860,31130898,31131449,31131722,31133574,31134431,31134501,31134743,31135033,31135070,31135269,31135605,31135808,31135856,31138059,31138269,31138850,31139117,31139341,31139595,31139919,31140830,31141099,31141385,31141784,31142442,31142487,31142884,31143112,31143290,31143459,31143806,31144049,31144339,31144616,31144757,31145074,31145385,31145880,31146718,31147231,31147443,31147721,31149954,3115053 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195420, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100383,31100579,31100850,31101059,31101280,31101563,31101846,31102087,31102344,31102901,31103020,31103251,31103513,31103741,31104007,31104421,31104579,31104785,31104827,31105149,31105449,31105532,31105774,31105807,31106144,31106341,31106539,31106815,31107035,31107282,31107468,31107751,31108045,31108267,31108564,31108891,31109216,31109566,31109895,31110203,31110445,31110572,31110831,31111068,31111439,31111647,31111678,31111842,31111937,31112208,31112681,31112757,31112985,31113110,31113377,31113585,31113785,31113971,31114297,31114538,31114726,31114863,31115229,31115524,31115767,31115957,31116191,31116428,31116720,31116843,31117164,31117204,31117577,31117611,31117921,31118123,31118299,31118595,31118835,31118883,31119118,31119361,31119661,31119864,31120105,31120199,31120480,31120729,31120946,31121118,31121450,31121699,31121930,31122208,31122378,31122420,31122776,31123014,31123168,31123344,31123553,31123842,31124033,31124252,31124539,31124795,31125053,31125259,31125564,31125951,31127520,31127561,31127604,3112766 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31195421, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31100577,31101054,31103029,31103508,31103739,31104008,31104426,31104576,31104782,31104820,31105151,31106146,31106331,31106807,31107754,31108047,31108562,31108894,31109213,31109557,31110201,31110437,31110829,31111440,31111828,31111939,31112209,31112684,31112762,31112988,31113117,31113378,31113587,31113790,31113966,31114296,31114542,31114735,31114874,31115232,31118118,31118596,31119120,31119367,31119658,31120102,31120937,31121928,31122418,31122783,31123010,31123557,31124255,31124543,31124796,31125052,31125260,31125567,31125946,31127527,31127557,31127598,31127678,31128180,31128226,31128258,31128452,31128607,31128841,31128920,31129236,31129317,31129532,31129808,31130421,31130895,31131321,31132581,31133138,31134426,31134741,31134820,31135029,31135057,31135261,31135591,31135852,31136728,31137376,31137715,31137888,31138264,31138581,31139107,31139348,31139916,31140831,31141957,31142449,31142481,31142889,31143109,31143293,31143464,31143800,31144051,31144341,31144607,31144758,31145381,31145614,31145878,31146905,3114743 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31195415,31195416,31195417,31195418,31195419,31195420,31195421?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2026-09-01' and date <= '2026-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2055,),), 'unwanted_material_monthly_percentage': ((0.7901543952307981,),), 'material_repartition': (('incineration', 2055),), 'material_dict': {'incineration': 2055}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 1), 0.7957394253401661, 4), (datetime.date(2026, 9, 2), 0.7687751186894979, 3), (datetime.date(2026, 9, 3), 0.7795496767164527, 2), (datetime.date(2026, 9, 4), 0.809604507819987, 3), (datetime.date(2026, 9, 5), 0.7843032114338266, 3), (datetime.date(2026, 9, 6), 0.8227348165379373, 2), (datetime.date(2026, 9, 7), 0.8535833773487876, 2), (datetime.date(2026, 9, 8), 0.8339116278945193, 3), (datetime.date(2026, 9, 9), 0.781757853232779, 3), (datetime.date(2026, 9, 10), 0.8367846023961564, 4), (datetime.date(2026, 9, 11), 0.8264422623937697, 2), (datetime.date(2026, 9, 12), 0.7682802468023477, 3), (datetime.date(2026, 9, 13), 0.8249454823869581, 2), (datetime.date(2026, 9, 14), 0.837873620891417, 3), (datetime.date(2026, 9, 15), 0.8423787478212782, 4), (datetime.date(2026, 9, 16), 0.8305989133993357, 3), (datetime.date(2026, 9, 17), 0.7787083148054813, 3), (datetime.date(2026, 9, 18), 0.7889054619089731, 2), (datetime.date(2026, 9, 19), 0.7655841126592324, 3), (datetime.date(2026, 9, 20), 0.8276845048144649, 4), (datetime.date(2026, 9, 21), 0.800862712842792, 1), (datetime.date(2026, 9, 22), 0.8119615522786376, 1), (datetime.date(2026, 9, 23), 0.7339957384725629, 2), (datetime.date(2026, 9, 24), 0.7054513542631663, 2), (datetime.date(2026, 9, 25), 0.7210532575662483, 4), (datetime.date(2026, 9, 26), 0.7744012496550754, 1), (datetime.date(2026, 9, 27), 0.7828581169916261, 3), (datetime.date(2026, 9, 28), 0.7828923097269037, 4), (datetime.date(2026, 9, 29), 0.6991339788866691, 1), (datetime.date(2026, 9, 30), 0.689363639413933, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 1), 0.7957394253401661, 4), (datetime.date(2026, 9, 2), 0.7687751186894979, 3), (datetime.date(2026, 9, 3), 0.7795496767164527, 2), (datetime.date(2026, 9, 4), 0.809604507819987, 3), (datetime.date(2026, 9, 5), 0.7843032114338266, 3), (datetime.date(2026, 9, 6), 0.8227348165379373, 2), (datetime.date(2026, 9, 7), 0.8535833773487876, 2), (datetime.date(2026, 9, 8), 0.8339116278945193, 3), (datetime.date(2026, 9, 9), 0.781757853232779, 3), (datetime.date(2026, 9, 10), 0.8367846023961564, 4), (datetime.date(2026, 9, 11), 0.8264422623937697, 2), (datetime.date(2026, 9, 12), 0.7682802468023477, 3), (datetime.date(2026, 9, 13), 0.8249454823869581, 2), (datetime.date(2026, 9, 14), 0.837873620891417, 3), (datetime.date(2026, 9, 15), 0.8423787478212782, 4), (datetime.date(2026, 9, 16), 0.8305989133993357, 3), (datetime.date(2026, 9, 17), 0.7787083148054813, 3), (datetime.date(2026, 9, 18), 0.7889054619089731, 2), (datetime.date(2026, 9, 19), 0.7655841126592324, 3), (datetime.date(2026, 9, 20), 0.8276845048144649, 4), (datetime.date(2026, 9, 21), 0.800862712842792, 1), (datetime.date(2026, 9, 22), 0.8119615522786376, 1), (datetime.date(2026, 9, 23), 0.7339957384725629, 2), (datetime.date(2026, 9, 24), 0.7054513542631663, 2), (datetime.date(2026, 9, 25), 0.7210532575662483, 4), (datetime.date(2026, 9, 26), 0.7744012496550754, 1), (datetime.date(2026, 9, 27), 0.7828581169916261, 3), (datetime.date(2026, 9, 28), 0.7828923097269037, 4), (datetime.date(2026, 9, 29), 0.6991339788866691, 1), (datetime.date(2026, 9, 30), 0.689363639413933, 2))}, 'quality_array': [['-7.150469302757905', '01092026'], ['-7.38581456546919', '02092026'], ['-7.448703778463211', '03092026'], ['-7.38485074177827', '04092026'], ['-7.066431037764153', '05092026'], ['-7.121195358669097', '06092026'], ['-7.164229920668063', '07092026'], ['-6.983734540121665', '08092026'], ['-7.189798429181855', '09092026'], ['-7.2925010387916585', '10092026'], ['-7.578393525316175', '11092026'], ['-7.613123752587596', '12092026'], ['-7.483121218048929', '13092026'], ['-7.113768974580717', '14092026'], ['-7.309642097915525', '15092026'], ['-7.571638102339823', '16092026'], ['-7.5592762997917715', '17092026'], ['-7.74371397841471', '18092026'], ['-7.407436250124943', '19092026'], ['-7.615638870620507', '20092026'], ['-7.382569391582708', '21092026'], ['-7.353030905733803', '22092026'], ['-7.927150846256104', '23092026'], ['-8.275912725149638', '24092026'], ['-8.33805121625418', '25092026'], ['-8.095633501007072', '26092026'], ['-8.290376965610289', '27092026'], ['-7.8137910871553045', '28092026'], ['-7.930105007810214', '29092026'], ['-7.551556295195435', '30092026']], 'number_of_batch': ((694,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011638589706217254, 'nb_photo': 16132, 'list_port_cont': '31100385,31100582,31100833,31101050,31101279,31101560,31101847,31102075,31102329,31102899,31103014,31103254,31103515,31103742,31104013,31104420,31104582,31104773,31104811,31105145,31105439,31105527,31105757,31105801,31106140,31106333,31106532,31106810,31107043,31107279,31107464,31107743,31108035,31108273,31108565,31108888,31109203,31109564,31109886,31110194,31110440,31110564,31110819,31111054,31111449,31111644,31111683,31111830,31111940,31112198,31112689,31112758,31112992,31113106,31113369,31113575,31113784,31113956,31114282,31114535,31114736,31114870,31115217,31115517,31115751,31115956,31116195,31116436,31116713,31116838,31117166,31117208,31117568,31117605,31117913,31118121,31118285,31118586,31118818,31118867,31119125,31119354,31119648,31119865,31120098,31120203,31120477,31120737,31120948,31121105,31121451,31121688,31121917,31122198,31122381,31122411,31122782,31123004,31123159,31123342,31123560,31123829,31124039,31124248,31124533,31124787,31125038,31125246,31125557,31125953,31127530,31127554,31127594,3112767', 'assoc_port': '31100285:31100385,31100518:31100582,31100750:31100833,31100987:31101050,31101200:31101279,31101495:31101560,31101741:31101847,31101969:31102075,31102237:31102329,31102542:31103014,31102775:31102899,31103059:31103254,31103395:31103515,31103576:31103742,31103857:31104013,31104234:31104420,31104453:31104582,31104646:31104773,31104647:31104811,31105005:31105145,31105212:31105439,31105384:31105527,31105667:31105801,31105668:31105757,31106045:31106140,31106280:31106333,31106476:31106532,31106713:31106810,31106959:31107043,31107217:31107279,31107396:31107464,31107660:31107743,31107925:31108035,31108198:31108273,31108477:31108565,31108773:31108888,31109076:31109203,31109330:31109564,31109725:31109886,31110040:31110194,31110264:31110440,31110500:31110564,31110675:31110819,31110888:31111054,31111093:31111830,31111300:31111449,31111544:31111683,31111545:31111644,31111915:31111940,31112149:31112198,31112349:31112689,31112549:31112992,31112722:31112758,31113016:31113106,31113228:31113369,31113480:31113575,31113690:3111378', 'assoc_mat': '31100285:autre:4230:31100385,31100518:autre:4230:31100582,31100750:autre:4230:31100833,31100987:autre:4230:31101050,31101200:autre:4230:31101279,31101495:autre:4230:31101560,31101741:autre:4230:31101847,31101969:autre:4230:31102075,31102237:autre:4230:31102329,31102542:autre:4230:31103014,31102775:autre:4230:31102899,31103059:autre:4230:31103254,31103395:autre:4230:31103515,31103576:autre:4230:31103742,31103857:autre:4230:31104013,31104234:autre:4230:31104420,31104453:autre:4230:31104582,31104646:autre:4230:31104773,31104647:autre:4230:31104811,31105005:autre:4230:31105145,31105212:autre:4230:31105439,31105384:autre:4230:31105527,31105667:autre:4230:31105801,31105668:autre:4230:31105757,31106045:autre:4230:31106140,31106280:autre:4230:31106333,31106476:autre:4230:31106532,31106713:autre:4230:31106810,31106959:autre:4230:31107043,31107217:autre:4230:31107279,31107396:autre:4230:31107464,31107660:autre:4230:31107743,31107925:autre:4230:31108035,31108198:autre:4230:31108273,31108477:autre:4230:31108565,31108773:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0320679391976196, 'nb_photo': 65158, 'list_port_cont': '31100380,31100570,31100844,31101052,31101270,31101559,31101852,31102086,31102340,31102898,31103019,31103253,31103507,31103740,31104016,31104424,31104578,31104787,31104825,31105147,31105446,31105519,31105773,31105810,31106139,31106336,31106531,31106805,31107032,31107287,31107461,31107747,31108046,31108272,31108554,31108893,31109218,31109562,31109891,31110196,31110442,31110578,31110822,31111056,31111448,31111646,31111679,31111839,31111936,31112202,31112678,31112765,31112989,31113122,31113370,31113573,31113780,31113963,31114290,31114541,31114738,31114869,31115230,31115516,31115762,31115949,31116184,31116433,31116711,31116840,31117165,31117206,31117581,31117618,31117920,31118114,31118294,31118597,31118834,31118878,31119126,31119359,31119659,31119862,31120107,31120200,31120484,31120734,31120939,31121115,31121446,31121698,31121934,31122212,31122384,31122422,31122781,31123006,31123160,31123333,31123564,31123840,31124037,31124254,31124538,31124785,31125051,31125256,31125560,31125947,31127525,31127562,31127601,3112767', 'assoc_port': '31100285:31100380,31100518:31100570,31100750:31100844,31100987:31101052,31101200:31101270,31101495:31101559,31101741:31101852,31101969:31102086,31102237:31102340,31102542:31103019,31102775:31102898,31103059:31103253,31103395:31103507,31103576:31103740,31103857:31104016,31104234:31104424,31104453:31104578,31104646:31104787,31104647:31104825,31105005:31105147,31105212:31105446,31105384:31105519,31105667:31105810,31105668:31105773,31106045:31106139,31106280:31106336,31106476:31106531,31106713:31106805,31106959:31107032,31107217:31107287,31107396:31107461,31107660:31107747,31107925:31108046,31108198:31108272,31108477:31108554,31108773:31108893,31109076:31109218,31109330:31109562,31109725:31109891,31110040:31110196,31110264:31110442,31110500:31110578,31110675:31110822,31110888:31111056,31111093:31111839,31111300:31111448,31111544:31111679,31111545:31111646,31111915:31111936,31112149:31112202,31112349:31112678,31112549:31112989,31112722:31112765,31113016:31113122,31113228:31113370,31113480:31113573,31113690:3111378', 'assoc_mat': '31100285:carton:4230:31100380,31100518:carton:4230:31100570,31100750:carton:4230:31100844,31100987:carton:4230:31101052,31101200:carton:4230:31101270,31101495:carton:4230:31101559,31101741:carton:4230:31101852,31101969:carton:4230:31102086,31102237:carton:4230:31102340,31102542:carton:4230:31103019,31102775:carton:4230:31102898,31103059:carton:4230:31103253,31103395:carton:4230:31103507,31103576:carton:4230:31103740,31103857:carton:4230:31104016,31104234:carton:4230:31104424,31104453:carton:4230:31104578,31104646:carton:4230:31104787,31104647:carton:4230:31104825,31105005:carton:4230:31105147,31105212:carton:4230:31105446,31105384:carton:4230:31105519,31105667:carton:4230:31105810,31105668:carton:4230:31105773,31106045:carton:4230:31106139,31106280:carton:4230:31106336,31106476:carton:4230:31106531,31106713:carton:4230:31106805,31106959:carton:4230:31107032,31107217:carton:4230:31107287,31107396:carton:4230:31107461,31107660:carton:4230:31107747,31107925:carton:4230:31108046,31108198:carton:4230:31108272,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008653669402062256, 'nb_photo': 1448, 'list_port_cont': '31100372,31100568,31100834,31101051,31102076,31102331,31102887,31103016,31103256,31103511,31103743,31104427,31104569,31104777,31104828,31105124,31105438,31105765,31105803,31106132,31106338,31106809,31107041,31107738,31108033,31108263,31108559,31108881,31109210,31109572,31109889,31110205,31110433,31110577,31110816,31111066,31111437,31111633,31111668,31111837,31111930,31112763,31112980,31113116,31113374,31113580,31113792,31113955,31114284,31114536,31114723,31114865,31115233,31115518,31115754,31115959,31116193,31116438,31116719,31116834,31117199,31117576,31118119,31118870,31119114,31119355,31119646,31119852,31120096,31120193,31120473,31120736,31120952,31121114,31121436,31121691,31122213,31122419,31123565,31123832,31124048,31124544,31124793,31125049,31125247,31125941,31127566,31127592,31127664,31128181,31128216,31128252,31128288,31128438,31128529,31128592,31128642,31128923,31129322,31130068,31130425,31130742,31130849,31130900,31131322,31131481,31131720,31131844,31132188,31132583,31133132,31133217,31133344,3113346', 'assoc_port': '31100285:31100372,31100518:31100568,31100750:31100834,31100987:31101051,31101969:31102076,31102237:31102331,31102542:31103016,31102775:31102887,31103059:31103256,31103395:31103511,31103576:31103743,31104234:31104427,31104453:31104569,31104646:31104777,31104647:31104828,31105005:31105124,31105212:31105438,31105667:31105803,31105668:31105765,31106045:31106132,31106280:31106338,31106713:31106809,31106959:31107041,31107660:31107738,31107925:31108033,31108198:31108263,31108477:31108559,31108773:31108881,31109076:31109210,31109330:31109572,31109725:31109889,31110040:31110205,31110264:31110433,31110500:31110577,31110675:31110816,31110888:31111066,31111093:31111837,31111300:31111437,31111544:31111668,31111545:31111633,31111915:31111930,31112549:31112980,31112722:31112763,31113016:31113116,31113228:31113374,31113480:31113580,31113690:31113792,31113859:31113955,31114137:31114284,31114402:31114536,31114646:31114723,31114845:31114865,31115086:31115233,31115344:31115518,31115616:31115754,31115894:31115959,31116135:3111619', 'assoc_mat': '31100285:metal:4230:31100372,31100518:metal:4230:31100568,31100750:metal:4230:31100834,31100987:metal:4230:31101051,31101969:metal:4230:31102076,31102237:metal:4230:31102331,31102542:metal:4230:31103016,31102775:metal:4230:31102887,31103059:metal:4230:31103256,31103395:metal:4230:31103511,31103576:metal:4230:31103743,31104234:metal:4230:31104427,31104453:metal:4230:31104569,31104646:metal:4230:31104777,31104647:metal:4230:31104828,31105005:metal:4230:31105124,31105212:metal:4230:31105438,31105667:metal:4230:31105803,31105668:metal:4230:31105765,31106045:metal:4230:31106132,31106280:metal:4230:31106338,31106713:metal:4230:31106809,31106959:metal:4230:31107041,31107660:metal:4230:31107738,31107925:metal:4230:31108033,31108198:metal:4230:31108263,31108477:metal:4230:31108559,31108773:metal:4230:31108881,31109076:metal:4230:31109210,31109330:metal:4230:31109572,31109725:metal:4230:31109889,31110040:metal:4230:31110205,31110264:metal:4230:31110433,31110500:metal:4230:31110577,31110675:metal:4230:31110816,31110888:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16440502167032695, 'nb_photo': 404375, 'list_port_cont': '31100370,31100575,31100848,31101056,31101278,31101561,31101853,31102074,31102343,31102902,31103030,31103248,31103517,31103744,31104010,31104431,31104580,31104784,31104819,31105137,31105450,31105523,31105769,31105797,31106148,31106337,31106533,31106801,31107042,31107284,31107467,31107753,31108039,31108269,31108556,31108887,31109211,31109567,31109892,31110204,31110436,31110579,31110826,31111070,31111436,31111643,31111672,31111843,31111933,31112207,31112676,31112754,31112991,31113120,31113364,31113581,31113789,31113967,31114295,31114545,31114731,31114868,31115224,31115520,31115758,31115951,31116188,31116439,31116715,31116845,31117167,31117203,31117580,31117615,31117914,31118120,31118295,31118601,31118832,31118881,31119113,31119362,31119657,31119861,31120103,31120197,31120481,31120732,31120944,31121106,31121441,31121687,31121931,31122211,31122377,31122412,31122774,31123012,31123169,31123346,31123555,31123841,31124042,31124253,31124548,31124789,31125045,31125250,31125566,31125950,31127521,31127565,31127593,3112767', 'assoc_port': '31100285:31100370,31100518:31100575,31100750:31100848,31100987:31101056,31101200:31101278,31101495:31101561,31101741:31101853,31101969:31102074,31102237:31102343,31102542:31103030,31102775:31102902,31103059:31103248,31103395:31103517,31103576:31103744,31103857:31104010,31104234:31104431,31104453:31104580,31104646:31104784,31104647:31104819,31105005:31105137,31105212:31105450,31105384:31105523,31105667:31105797,31105668:31105769,31106045:31106148,31106280:31106337,31106476:31106533,31106713:31106801,31106959:31107042,31107217:31107284,31107396:31107467,31107660:31107753,31107925:31108039,31108198:31108269,31108477:31108556,31108773:31108887,31109076:31109211,31109330:31109567,31109725:31109892,31110040:31110204,31110264:31110436,31110500:31110579,31110675:31110826,31110888:31111070,31111093:31111843,31111300:31111436,31111544:31111672,31111545:31111643,31111915:31111933,31112149:31112207,31112349:31112676,31112549:31112991,31112722:31112754,31113016:31113120,31113228:31113364,31113480:31113581,31113690:3111378', 'assoc_mat': '31100285:papier:4230:31100370,31100518:papier:4230:31100575,31100750:papier:4230:31100848,31100987:papier:4230:31101056,31101200:papier:4230:31101278,31101495:papier:4230:31101561,31101741:papier:4230:31101853,31101969:papier:4230:31102074,31102237:papier:4230:31102343,31102542:papier:4230:31103030,31102775:papier:4230:31102902,31103059:papier:4230:31103248,31103395:papier:4230:31103517,31103576:papier:4230:31103744,31103857:papier:4230:31104010,31104234:papier:4230:31104431,31104453:papier:4230:31104580,31104646:papier:4230:31104784,31104647:papier:4230:31104819,31105005:papier:4230:31105137,31105212:papier:4230:31105450,31105384:papier:4230:31105523,31105667:papier:4230:31105797,31105668:papier:4230:31105769,31106045:papier:4230:31106148,31106280:papier:4230:31106337,31106476:papier:4230:31106533,31106713:papier:4230:31106801,31106959:papier:4230:31107042,31107217:papier:4230:31107284,31107396:papier:4230:31107467,31107660:papier:4230:31107753,31107925:papier:4230:31108039,31108198:papier:4230:31108269,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023970000469461265, 'nb_photo': 1414, 'list_port_cont': '31100384,31101055,31101562,31102080,31103031,31103514,31103737,31104425,31104581,31104776,31104826,31105143,31105448,31105525,31107034,31107469,31107752,31108886,31109217,31109570,31109885,31110190,31110443,31110574,31110830,31111067,31111447,31111935,31112205,31112687,31112760,31112994,31113115,31113376,31113583,31113791,31114293,31114543,31114737,31114873,31115226,31115763,31117604,31118600,31118873,31119119,31119654,31120104,31120188,31120485,31121110,31121448,31122784,31123833,31124792,31125044,31125254,31125569,31125954,31127529,31127563,31127602,31127667,31128263,31128453,31128523,31128844,31130057,31130739,31130860,31130898,31131449,31131722,31133574,31134431,31134501,31134743,31135033,31135070,31135269,31135605,31135808,31135856,31138059,31138269,31138850,31139117,31139341,31139595,31139919,31140830,31141099,31141385,31141784,31142442,31142487,31142884,31143112,31143290,31143459,31143806,31144049,31144339,31144616,31144757,31145074,31145385,31145880,31146718,31147231,31147443,31147721,31149954,3115053', 'assoc_port': '31100285:31100384,31100987:31101055,31101495:31101562,31101969:31102080,31102542:31103031,31103395:31103514,31103576:31103737,31104234:31104425,31104453:31104581,31104646:31104776,31104647:31104826,31105005:31105143,31105212:31105448,31105384:31105525,31106959:31107034,31107396:31107469,31107660:31107752,31108773:31108886,31109076:31109217,31109330:31109570,31109725:31109885,31110040:31110190,31110264:31110443,31110500:31110574,31110675:31110830,31110888:31111067,31111300:31111447,31111915:31111935,31112149:31112205,31112349:31112687,31112549:31112994,31112722:31112760,31113016:31113115,31113228:31113376,31113480:31113583,31113690:31113791,31114137:31114293,31114402:31114543,31114646:31114737,31114845:31114873,31115086:31115226,31115616:31115763,31117556:31117604,31118387:31118600,31118854:31118873,31119055:31119119,31119545:31119654,31120003:31120104,31120171:31120188,31120420:31120485,31121090:31121110,31121317:31121448,31122759:31122784,31123774:31123833,31124688:31124792,31124939:31125044,31125230:3112525', 'assoc_mat': '31100285:pehd:4230:31100384,31100987:pehd:4230:31101055,31101495:pehd:4230:31101562,31101969:pehd:4230:31102080,31102542:pehd:4230:31103031,31103395:pehd:4230:31103514,31103576:pehd:4230:31103737,31104234:pehd:4230:31104425,31104453:pehd:4230:31104581,31104646:pehd:4230:31104776,31104647:pehd:4230:31104826,31105005:pehd:4230:31105143,31105212:pehd:4230:31105448,31105384:pehd:4230:31105525,31106959:pehd:4230:31107034,31107396:pehd:4230:31107469,31107660:pehd:4230:31107752,31108773:pehd:4230:31108886,31109076:pehd:4230:31109217,31109330:pehd:4230:31109570,31109725:pehd:4230:31109885,31110040:pehd:4230:31110190,31110264:pehd:4230:31110443,31110500:pehd:4230:31110574,31110675:pehd:4230:31110830,31110888:pehd:4230:31111067,31111300:pehd:4230:31111447,31111915:pehd:4230:31111935,31112149:pehd:4230:31112205,31112349:pehd:4230:31112687,31112549:pehd:4230:31112994,31112722:pehd:4230:31112760,31113016:pehd:4230:31113115,31113228:pehd:4230:31113376,31113480:pehd:4230:31113583,31113690:pehd:4230:31113791,31114137:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.019088504064345726, 'nb_photo': 25295, 'list_port_cont': '31100383,31100579,31100850,31101059,31101280,31101563,31101846,31102087,31102344,31102901,31103020,31103251,31103513,31103741,31104007,31104421,31104579,31104785,31104827,31105149,31105449,31105532,31105774,31105807,31106144,31106341,31106539,31106815,31107035,31107282,31107468,31107751,31108045,31108267,31108564,31108891,31109216,31109566,31109895,31110203,31110445,31110572,31110831,31111068,31111439,31111647,31111678,31111842,31111937,31112208,31112681,31112757,31112985,31113110,31113377,31113585,31113785,31113971,31114297,31114538,31114726,31114863,31115229,31115524,31115767,31115957,31116191,31116428,31116720,31116843,31117164,31117204,31117577,31117611,31117921,31118123,31118299,31118595,31118835,31118883,31119118,31119361,31119661,31119864,31120105,31120199,31120480,31120729,31120946,31121118,31121450,31121699,31121930,31122208,31122378,31122420,31122776,31123014,31123168,31123344,31123553,31123842,31124033,31124252,31124539,31124795,31125053,31125259,31125564,31125951,31127520,31127561,31127604,3112766', 'assoc_port': '31100285:31100383,31100518:31100579,31100750:31100850,31100987:31101059,31101200:31101280,31101495:31101563,31101741:31101846,31101969:31102087,31102237:31102344,31102542:31103020,31102775:31102901,31103059:31103251,31103395:31103513,31103576:31103741,31103857:31104007,31104234:31104421,31104453:31104579,31104646:31104785,31104647:31104827,31105005:31105149,31105212:31105449,31105384:31105532,31105667:31105807,31105668:31105774,31106045:31106144,31106280:31106341,31106476:31106539,31106713:31106815,31106959:31107035,31107217:31107282,31107396:31107468,31107660:31107751,31107925:31108045,31108198:31108267,31108477:31108564,31108773:31108891,31109076:31109216,31109330:31109566,31109725:31109895,31110040:31110203,31110264:31110445,31110500:31110572,31110675:31110831,31110888:31111068,31111093:31111842,31111300:31111439,31111544:31111678,31111545:31111647,31111915:31111937,31112149:31112208,31112349:31112681,31112549:31112985,31112722:31112757,31113016:31113110,31113228:31113377,31113480:31113585,31113690:3111378', 'assoc_mat': '31100285:pet_clair:4230:31100383,31100518:pet_clair:4230:31100579,31100750:pet_clair:4230:31100850,31100987:pet_clair:4230:31101059,31101200:pet_clair:4230:31101280,31101495:pet_clair:4230:31101563,31101741:pet_clair:4230:31101846,31101969:pet_clair:4230:31102087,31102237:pet_clair:4230:31102344,31102542:pet_clair:4230:31103020,31102775:pet_clair:4230:31102901,31103059:pet_clair:4230:31103251,31103395:pet_clair:4230:31103513,31103576:pet_clair:4230:31103741,31103857:pet_clair:4230:31104007,31104234:pet_clair:4230:31104421,31104453:pet_clair:4230:31104579,31104646:pet_clair:4230:31104785,31104647:pet_clair:4230:31104827,31105005:pet_clair:4230:31105149,31105212:pet_clair:4230:31105449,31105384:pet_clair:4230:31105532,31105667:pet_clair:4230:31105807,31105668:pet_clair:4230:31105774,31106045:pet_clair:4230:31106144,31106280:pet_clair:4230:31106341,31106476:pet_clair:4230:31106539,31106713:pet_clair:4230:31106815,31106959:pet_clair:4230:31107035,31107217:pet_clair:4230:31107282,31107396:pet_clair:4230:31107468,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0020269251894684836, 'nb_photo': 805, 'list_port_cont': '31100577,31101054,31103029,31103508,31103739,31104008,31104426,31104576,31104782,31104820,31105151,31106146,31106331,31106807,31107754,31108047,31108562,31108894,31109213,31109557,31110201,31110437,31110829,31111440,31111828,31111939,31112209,31112684,31112762,31112988,31113117,31113378,31113587,31113790,31113966,31114296,31114542,31114735,31114874,31115232,31118118,31118596,31119120,31119367,31119658,31120102,31120937,31121928,31122418,31122783,31123010,31123557,31124255,31124543,31124796,31125052,31125260,31125567,31125946,31127527,31127557,31127598,31127678,31128180,31128226,31128258,31128452,31128607,31128841,31128920,31129236,31129317,31129532,31129808,31130421,31130895,31131321,31132581,31133138,31134426,31134741,31134820,31135029,31135057,31135261,31135591,31135852,31136728,31137376,31137715,31137888,31138264,31138581,31139107,31139348,31139916,31140831,31141957,31142449,31142481,31142889,31143109,31143293,31143464,31143800,31144051,31144341,31144607,31144758,31145381,31145614,31145878,31146905,3114743', 'assoc_port': '31100518:31100577,31100987:31101054,31102542:31103029,31103395:31103508,31103576:31103739,31103857:31104008,31104234:31104426,31104453:31104576,31104646:31104782,31104647:31104820,31105005:31105151,31106045:31106146,31106280:31106331,31106713:31106807,31107660:31107754,31107925:31108047,31108477:31108562,31108773:31108894,31109076:31109213,31109330:31109557,31110040:31110201,31110264:31110437,31110675:31110829,31111093:31111828,31111300:31111440,31111915:31111939,31112149:31112209,31112349:31112684,31112549:31112988,31112722:31112762,31113016:31113117,31113228:31113378,31113480:31113587,31113690:31113790,31113859:31113966,31114137:31114296,31114402:31114542,31114646:31114735,31114845:31114874,31115086:31115232,31118057:31118118,31118387:31118596,31119055:31119120,31119301:31119367,31119545:31119658,31120003:31120102,31120878:31120937,31121869:31121928,31122356:31122418,31122759:31122783,31122990:31123010,31123523:31123557,31124227:31124255,31124474:31124543,31124688:31124796,31124939:31125052,31125230:3112526', 'assoc_mat': '31100518:pet_fonce:4230:31100577,31100987:pet_fonce:4230:31101054,31102542:pet_fonce:4230:31103029,31103395:pet_fonce:4230:31103508,31103576:pet_fonce:4230:31103739,31103857:pet_fonce:4230:31104008,31104234:pet_fonce:4230:31104426,31104453:pet_fonce:4230:31104576,31104646:pet_fonce:4230:31104782,31104647:pet_fonce:4230:31104820,31105005:pet_fonce:4230:31105151,31106045:pet_fonce:4230:31106146,31106280:pet_fonce:4230:31106331,31106713:pet_fonce:4230:31106807,31107660:pet_fonce:4230:31107754,31107925:pet_fonce:4230:31108047,31108477:pet_fonce:4230:31108562,31108773:pet_fonce:4230:31108894,31109076:pet_fonce:4230:31109213,31109330:pet_fonce:4230:31109557,31110040:pet_fonce:4230:31110201,31110264:pet_fonce:4230:31110437,31110675:pet_fonce:4230:31110829,31111093:pet_fonce:4230:31111828,31111300:pet_fonce:4230:31111440,31111915:pet_fonce:4230:31111939,31112149:pet_fonce:4230:31112209,31112349:pet_fonce:4230:31112684,31112549:pet_fonce:4230:31112988,31112722:pet_fonce:4230:31112762,31113016:pet_fonce:4230:31113117,3'}), 'main_stat': {'nb_photos': 2055}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31195415,31195416,31195417,31195418,31195419,31195420,31195421?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.7901543952307981),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2055,),), 'unwanted_material_monthly_percentage': ((0.7901543952307981,),), 'material_repartition': (('incineration', 2055),), 'material_dict': {'incineration': 2055}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 9, 1), 0.7957394253401661, 4), (datetime.date(2026, 9, 2), 0.7687751186894979, 3), (datetime.date(2026, 9, 3), 0.7795496767164527, 2), (datetime.date(2026, 9, 4), 0.809604507819987, 3), (datetime.date(2026, 9, 5), 0.7843032114338266, 3), (datetime.date(2026, 9, 6), 0.8227348165379373, 2), (datetime.date(2026, 9, 7), 0.8535833773487876, 2), (datetime.date(2026, 9, 8), 0.8339116278945193, 3), (datetime.date(2026, 9, 9), 0.781757853232779, 3), (datetime.date(2026, 9, 10), 0.8367846023961564, 4), (datetime.date(2026, 9, 11), 0.8264422623937697, 2), (datetime.date(2026, 9, 12), 0.7682802468023477, 3), (datetime.date(2026, 9, 13), 0.8249454823869581, 2), (datetime.date(2026, 9, 14), 0.837873620891417, 3), (datetime.date(2026, 9, 15), 0.8423787478212782, 4), (datetime.date(2026, 9, 16), 0.8305989133993357, 3), (datetime.date(2026, 9, 17), 0.7787083148054813, 3), (datetime.date(2026, 9, 18), 0.7889054619089731, 2), (datetime.date(2026, 9, 19), 0.7655841126592324, 3), (datetime.date(2026, 9, 20), 0.8276845048144649, 4), (datetime.date(2026, 9, 21), 0.800862712842792, 1), (datetime.date(2026, 9, 22), 0.8119615522786376, 1), (datetime.date(2026, 9, 23), 0.7339957384725629, 2), (datetime.date(2026, 9, 24), 0.7054513542631663, 2), (datetime.date(2026, 9, 25), 0.7210532575662483, 4), (datetime.date(2026, 9, 26), 0.7744012496550754, 1), (datetime.date(2026, 9, 27), 0.7828581169916261, 3), (datetime.date(2026, 9, 28), 0.7828923097269037, 4), (datetime.date(2026, 9, 29), 0.6991339788866691, 1), (datetime.date(2026, 9, 30), 0.689363639413933, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 9, 1), 0.7957394253401661, 4), (datetime.date(2026, 9, 2), 0.7687751186894979, 3), (datetime.date(2026, 9, 3), 0.7795496767164527, 2), (datetime.date(2026, 9, 4), 0.809604507819987, 3), (datetime.date(2026, 9, 5), 0.7843032114338266, 3), (datetime.date(2026, 9, 6), 0.8227348165379373, 2), (datetime.date(2026, 9, 7), 0.8535833773487876, 2), (datetime.date(2026, 9, 8), 0.8339116278945193, 3), (datetime.date(2026, 9, 9), 0.781757853232779, 3), (datetime.date(2026, 9, 10), 0.8367846023961564, 4), (datetime.date(2026, 9, 11), 0.8264422623937697, 2), (datetime.date(2026, 9, 12), 0.7682802468023477, 3), (datetime.date(2026, 9, 13), 0.8249454823869581, 2), (datetime.date(2026, 9, 14), 0.837873620891417, 3), (datetime.date(2026, 9, 15), 0.8423787478212782, 4), (datetime.date(2026, 9, 16), 0.8305989133993357, 3), (datetime.date(2026, 9, 17), 0.7787083148054813, 3), (datetime.date(2026, 9, 18), 0.7889054619089731, 2), (datetime.date(2026, 9, 19), 0.7655841126592324, 3), (datetime.date(2026, 9, 20), 0.8276845048144649, 4), (datetime.date(2026, 9, 21), 0.800862712842792, 1), (datetime.date(2026, 9, 22), 0.8119615522786376, 1), (datetime.date(2026, 9, 23), 0.7339957384725629, 2), (datetime.date(2026, 9, 24), 0.7054513542631663, 2), (datetime.date(2026, 9, 25), 0.7210532575662483, 4), (datetime.date(2026, 9, 26), 0.7744012496550754, 1), (datetime.date(2026, 9, 27), 0.7828581169916261, 3), (datetime.date(2026, 9, 28), 0.7828923097269037, 4), (datetime.date(2026, 9, 29), 0.6991339788866691, 1), (datetime.date(2026, 9, 30), 0.689363639413933, 2))}, 'quality_array': [['-7.150469302757905', '01092026'], ['-7.38581456546919', '02092026'], ['-7.448703778463211', '03092026'], ['-7.38485074177827', '04092026'], ['-7.066431037764153', '05092026'], ['-7.121195358669097', '06092026'], ['-7.164229920668063', '07092026'], ['-6.983734540121665', '08092026'], ['-7.189798429181855', '09092026'], ['-7.2925010387916585', '10092026'], ['-7.578393525316175', '11092026'], ['-7.613123752587596', '12092026'], ['-7.483121218048929', '13092026'], ['-7.113768974580717', '14092026'], ['-7.309642097915525', '15092026'], ['-7.571638102339823', '16092026'], ['-7.5592762997917715', '17092026'], ['-7.74371397841471', '18092026'], ['-7.407436250124943', '19092026'], ['-7.615638870620507', '20092026'], ['-7.382569391582708', '21092026'], ['-7.353030905733803', '22092026'], ['-7.927150846256104', '23092026'], ['-8.275912725149638', '24092026'], ['-8.33805121625418', '25092026'], ['-8.095633501007072', '26092026'], ['-8.290376965610289', '27092026'], ['-7.8137910871553045', '28092026'], ['-7.930105007810214', '29092026'], ['-7.551556295195435', '30092026']], 'number_of_batch': ((694,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011638589706217254, 'nb_photo': 16132, 'list_port_cont': '31100385,31100582,31100833,31101050,31101279,31101560,31101847,31102075,31102329,31102899,31103014,31103254,31103515,31103742,31104013,31104420,31104582,31104773,31104811,31105145,31105439,31105527,31105757,31105801,31106140,31106333,31106532,31106810,31107043,31107279,31107464,31107743,31108035,31108273,31108565,31108888,31109203,31109564,31109886,31110194,31110440,31110564,31110819,31111054,31111449,31111644,31111683,31111830,31111940,31112198,31112689,31112758,31112992,31113106,31113369,31113575,31113784,31113956,31114282,31114535,31114736,31114870,31115217,31115517,31115751,31115956,31116195,31116436,31116713,31116838,31117166,31117208,31117568,31117605,31117913,31118121,31118285,31118586,31118818,31118867,31119125,31119354,31119648,31119865,31120098,31120203,31120477,31120737,31120948,31121105,31121451,31121688,31121917,31122198,31122381,31122411,31122782,31123004,31123159,31123342,31123560,31123829,31124039,31124248,31124533,31124787,31125038,31125246,31125557,31125953,31127530,31127554,31127594,3112767', 'assoc_port': '31100285:31100385,31100518:31100582,31100750:31100833,31100987:31101050,31101200:31101279,31101495:31101560,31101741:31101847,31101969:31102075,31102237:31102329,31102542:31103014,31102775:31102899,31103059:31103254,31103395:31103515,31103576:31103742,31103857:31104013,31104234:31104420,31104453:31104582,31104646:31104773,31104647:31104811,31105005:31105145,31105212:31105439,31105384:31105527,31105667:31105801,31105668:31105757,31106045:31106140,31106280:31106333,31106476:31106532,31106713:31106810,31106959:31107043,31107217:31107279,31107396:31107464,31107660:31107743,31107925:31108035,31108198:31108273,31108477:31108565,31108773:31108888,31109076:31109203,31109330:31109564,31109725:31109886,31110040:31110194,31110264:31110440,31110500:31110564,31110675:31110819,31110888:31111054,31111093:31111830,31111300:31111449,31111544:31111683,31111545:31111644,31111915:31111940,31112149:31112198,31112349:31112689,31112549:31112992,31112722:31112758,31113016:31113106,31113228:31113369,31113480:31113575,31113690:3111378', 'assoc_mat': '31100285:autre:4230:31100385,31100518:autre:4230:31100582,31100750:autre:4230:31100833,31100987:autre:4230:31101050,31101200:autre:4230:31101279,31101495:autre:4230:31101560,31101741:autre:4230:31101847,31101969:autre:4230:31102075,31102237:autre:4230:31102329,31102542:autre:4230:31103014,31102775:autre:4230:31102899,31103059:autre:4230:31103254,31103395:autre:4230:31103515,31103576:autre:4230:31103742,31103857:autre:4230:31104013,31104234:autre:4230:31104420,31104453:autre:4230:31104582,31104646:autre:4230:31104773,31104647:autre:4230:31104811,31105005:autre:4230:31105145,31105212:autre:4230:31105439,31105384:autre:4230:31105527,31105667:autre:4230:31105801,31105668:autre:4230:31105757,31106045:autre:4230:31106140,31106280:autre:4230:31106333,31106476:autre:4230:31106532,31106713:autre:4230:31106810,31106959:autre:4230:31107043,31107217:autre:4230:31107279,31107396:autre:4230:31107464,31107660:autre:4230:31107743,31107925:autre:4230:31108035,31108198:autre:4230:31108273,31108477:autre:4230:31108565,31108773:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0320679391976196, 'nb_photo': 65158, 'list_port_cont': '31100380,31100570,31100844,31101052,31101270,31101559,31101852,31102086,31102340,31102898,31103019,31103253,31103507,31103740,31104016,31104424,31104578,31104787,31104825,31105147,31105446,31105519,31105773,31105810,31106139,31106336,31106531,31106805,31107032,31107287,31107461,31107747,31108046,31108272,31108554,31108893,31109218,31109562,31109891,31110196,31110442,31110578,31110822,31111056,31111448,31111646,31111679,31111839,31111936,31112202,31112678,31112765,31112989,31113122,31113370,31113573,31113780,31113963,31114290,31114541,31114738,31114869,31115230,31115516,31115762,31115949,31116184,31116433,31116711,31116840,31117165,31117206,31117581,31117618,31117920,31118114,31118294,31118597,31118834,31118878,31119126,31119359,31119659,31119862,31120107,31120200,31120484,31120734,31120939,31121115,31121446,31121698,31121934,31122212,31122384,31122422,31122781,31123006,31123160,31123333,31123564,31123840,31124037,31124254,31124538,31124785,31125051,31125256,31125560,31125947,31127525,31127562,31127601,3112767', 'assoc_port': '31100285:31100380,31100518:31100570,31100750:31100844,31100987:31101052,31101200:31101270,31101495:31101559,31101741:31101852,31101969:31102086,31102237:31102340,31102542:31103019,31102775:31102898,31103059:31103253,31103395:31103507,31103576:31103740,31103857:31104016,31104234:31104424,31104453:31104578,31104646:31104787,31104647:31104825,31105005:31105147,31105212:31105446,31105384:31105519,31105667:31105810,31105668:31105773,31106045:31106139,31106280:31106336,31106476:31106531,31106713:31106805,31106959:31107032,31107217:31107287,31107396:31107461,31107660:31107747,31107925:31108046,31108198:31108272,31108477:31108554,31108773:31108893,31109076:31109218,31109330:31109562,31109725:31109891,31110040:31110196,31110264:31110442,31110500:31110578,31110675:31110822,31110888:31111056,31111093:31111839,31111300:31111448,31111544:31111679,31111545:31111646,31111915:31111936,31112149:31112202,31112349:31112678,31112549:31112989,31112722:31112765,31113016:31113122,31113228:31113370,31113480:31113573,31113690:3111378', 'assoc_mat': '31100285:carton:4230:31100380,31100518:carton:4230:31100570,31100750:carton:4230:31100844,31100987:carton:4230:31101052,31101200:carton:4230:31101270,31101495:carton:4230:31101559,31101741:carton:4230:31101852,31101969:carton:4230:31102086,31102237:carton:4230:31102340,31102542:carton:4230:31103019,31102775:carton:4230:31102898,31103059:carton:4230:31103253,31103395:carton:4230:31103507,31103576:carton:4230:31103740,31103857:carton:4230:31104016,31104234:carton:4230:31104424,31104453:carton:4230:31104578,31104646:carton:4230:31104787,31104647:carton:4230:31104825,31105005:carton:4230:31105147,31105212:carton:4230:31105446,31105384:carton:4230:31105519,31105667:carton:4230:31105810,31105668:carton:4230:31105773,31106045:carton:4230:31106139,31106280:carton:4230:31106336,31106476:carton:4230:31106531,31106713:carton:4230:31106805,31106959:carton:4230:31107032,31107217:carton:4230:31107287,31107396:carton:4230:31107461,31107660:carton:4230:31107747,31107925:carton:4230:31108046,31108198:carton:4230:31108272,3110'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0008653669402062256, 'nb_photo': 1448, 'list_port_cont': '31100372,31100568,31100834,31101051,31102076,31102331,31102887,31103016,31103256,31103511,31103743,31104427,31104569,31104777,31104828,31105124,31105438,31105765,31105803,31106132,31106338,31106809,31107041,31107738,31108033,31108263,31108559,31108881,31109210,31109572,31109889,31110205,31110433,31110577,31110816,31111066,31111437,31111633,31111668,31111837,31111930,31112763,31112980,31113116,31113374,31113580,31113792,31113955,31114284,31114536,31114723,31114865,31115233,31115518,31115754,31115959,31116193,31116438,31116719,31116834,31117199,31117576,31118119,31118870,31119114,31119355,31119646,31119852,31120096,31120193,31120473,31120736,31120952,31121114,31121436,31121691,31122213,31122419,31123565,31123832,31124048,31124544,31124793,31125049,31125247,31125941,31127566,31127592,31127664,31128181,31128216,31128252,31128288,31128438,31128529,31128592,31128642,31128923,31129322,31130068,31130425,31130742,31130849,31130900,31131322,31131481,31131720,31131844,31132188,31132583,31133132,31133217,31133344,3113346', 'assoc_port': '31100285:31100372,31100518:31100568,31100750:31100834,31100987:31101051,31101969:31102076,31102237:31102331,31102542:31103016,31102775:31102887,31103059:31103256,31103395:31103511,31103576:31103743,31104234:31104427,31104453:31104569,31104646:31104777,31104647:31104828,31105005:31105124,31105212:31105438,31105667:31105803,31105668:31105765,31106045:31106132,31106280:31106338,31106713:31106809,31106959:31107041,31107660:31107738,31107925:31108033,31108198:31108263,31108477:31108559,31108773:31108881,31109076:31109210,31109330:31109572,31109725:31109889,31110040:31110205,31110264:31110433,31110500:31110577,31110675:31110816,31110888:31111066,31111093:31111837,31111300:31111437,31111544:31111668,31111545:31111633,31111915:31111930,31112549:31112980,31112722:31112763,31113016:31113116,31113228:31113374,31113480:31113580,31113690:31113792,31113859:31113955,31114137:31114284,31114402:31114536,31114646:31114723,31114845:31114865,31115086:31115233,31115344:31115518,31115616:31115754,31115894:31115959,31116135:3111619', 'assoc_mat': '31100285:metal:4230:31100372,31100518:metal:4230:31100568,31100750:metal:4230:31100834,31100987:metal:4230:31101051,31101969:metal:4230:31102076,31102237:metal:4230:31102331,31102542:metal:4230:31103016,31102775:metal:4230:31102887,31103059:metal:4230:31103256,31103395:metal:4230:31103511,31103576:metal:4230:31103743,31104234:metal:4230:31104427,31104453:metal:4230:31104569,31104646:metal:4230:31104777,31104647:metal:4230:31104828,31105005:metal:4230:31105124,31105212:metal:4230:31105438,31105667:metal:4230:31105803,31105668:metal:4230:31105765,31106045:metal:4230:31106132,31106280:metal:4230:31106338,31106713:metal:4230:31106809,31106959:metal:4230:31107041,31107660:metal:4230:31107738,31107925:metal:4230:31108033,31108198:metal:4230:31108263,31108477:metal:4230:31108559,31108773:metal:4230:31108881,31109076:metal:4230:31109210,31109330:metal:4230:31109572,31109725:metal:4230:31109889,31110040:metal:4230:31110205,31110264:metal:4230:31110433,31110500:metal:4230:31110577,31110675:metal:4230:31110816,31110888:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16440502167032695, 'nb_photo': 404375, 'list_port_cont': '31100370,31100575,31100848,31101056,31101278,31101561,31101853,31102074,31102343,31102902,31103030,31103248,31103517,31103744,31104010,31104431,31104580,31104784,31104819,31105137,31105450,31105523,31105769,31105797,31106148,31106337,31106533,31106801,31107042,31107284,31107467,31107753,31108039,31108269,31108556,31108887,31109211,31109567,31109892,31110204,31110436,31110579,31110826,31111070,31111436,31111643,31111672,31111843,31111933,31112207,31112676,31112754,31112991,31113120,31113364,31113581,31113789,31113967,31114295,31114545,31114731,31114868,31115224,31115520,31115758,31115951,31116188,31116439,31116715,31116845,31117167,31117203,31117580,31117615,31117914,31118120,31118295,31118601,31118832,31118881,31119113,31119362,31119657,31119861,31120103,31120197,31120481,31120732,31120944,31121106,31121441,31121687,31121931,31122211,31122377,31122412,31122774,31123012,31123169,31123346,31123555,31123841,31124042,31124253,31124548,31124789,31125045,31125250,31125566,31125950,31127521,31127565,31127593,3112767', 'assoc_port': '31100285:31100370,31100518:31100575,31100750:31100848,31100987:31101056,31101200:31101278,31101495:31101561,31101741:31101853,31101969:31102074,31102237:31102343,31102542:31103030,31102775:31102902,31103059:31103248,31103395:31103517,31103576:31103744,31103857:31104010,31104234:31104431,31104453:31104580,31104646:31104784,31104647:31104819,31105005:31105137,31105212:31105450,31105384:31105523,31105667:31105797,31105668:31105769,31106045:31106148,31106280:31106337,31106476:31106533,31106713:31106801,31106959:31107042,31107217:31107284,31107396:31107467,31107660:31107753,31107925:31108039,31108198:31108269,31108477:31108556,31108773:31108887,31109076:31109211,31109330:31109567,31109725:31109892,31110040:31110204,31110264:31110436,31110500:31110579,31110675:31110826,31110888:31111070,31111093:31111843,31111300:31111436,31111544:31111672,31111545:31111643,31111915:31111933,31112149:31112207,31112349:31112676,31112549:31112991,31112722:31112754,31113016:31113120,31113228:31113364,31113480:31113581,31113690:3111378', 'assoc_mat': '31100285:papier:4230:31100370,31100518:papier:4230:31100575,31100750:papier:4230:31100848,31100987:papier:4230:31101056,31101200:papier:4230:31101278,31101495:papier:4230:31101561,31101741:papier:4230:31101853,31101969:papier:4230:31102074,31102237:papier:4230:31102343,31102542:papier:4230:31103030,31102775:papier:4230:31102902,31103059:papier:4230:31103248,31103395:papier:4230:31103517,31103576:papier:4230:31103744,31103857:papier:4230:31104010,31104234:papier:4230:31104431,31104453:papier:4230:31104580,31104646:papier:4230:31104784,31104647:papier:4230:31104819,31105005:papier:4230:31105137,31105212:papier:4230:31105450,31105384:papier:4230:31105523,31105667:papier:4230:31105797,31105668:papier:4230:31105769,31106045:papier:4230:31106148,31106280:papier:4230:31106337,31106476:papier:4230:31106533,31106713:papier:4230:31106801,31106959:papier:4230:31107042,31107217:papier:4230:31107284,31107396:papier:4230:31107467,31107660:papier:4230:31107753,31107925:papier:4230:31108039,31108198:papier:4230:31108269,3110'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023970000469461265, 'nb_photo': 1414, 'list_port_cont': '31100384,31101055,31101562,31102080,31103031,31103514,31103737,31104425,31104581,31104776,31104826,31105143,31105448,31105525,31107034,31107469,31107752,31108886,31109217,31109570,31109885,31110190,31110443,31110574,31110830,31111067,31111447,31111935,31112205,31112687,31112760,31112994,31113115,31113376,31113583,31113791,31114293,31114543,31114737,31114873,31115226,31115763,31117604,31118600,31118873,31119119,31119654,31120104,31120188,31120485,31121110,31121448,31122784,31123833,31124792,31125044,31125254,31125569,31125954,31127529,31127563,31127602,31127667,31128263,31128453,31128523,31128844,31130057,31130739,31130860,31130898,31131449,31131722,31133574,31134431,31134501,31134743,31135033,31135070,31135269,31135605,31135808,31135856,31138059,31138269,31138850,31139117,31139341,31139595,31139919,31140830,31141099,31141385,31141784,31142442,31142487,31142884,31143112,31143290,31143459,31143806,31144049,31144339,31144616,31144757,31145074,31145385,31145880,31146718,31147231,31147443,31147721,31149954,3115053', 'assoc_port': '31100285:31100384,31100987:31101055,31101495:31101562,31101969:31102080,31102542:31103031,31103395:31103514,31103576:31103737,31104234:31104425,31104453:31104581,31104646:31104776,31104647:31104826,31105005:31105143,31105212:31105448,31105384:31105525,31106959:31107034,31107396:31107469,31107660:31107752,31108773:31108886,31109076:31109217,31109330:31109570,31109725:31109885,31110040:31110190,31110264:31110443,31110500:31110574,31110675:31110830,31110888:31111067,31111300:31111447,31111915:31111935,31112149:31112205,31112349:31112687,31112549:31112994,31112722:31112760,31113016:31113115,31113228:31113376,31113480:31113583,31113690:31113791,31114137:31114293,31114402:31114543,31114646:31114737,31114845:31114873,31115086:31115226,31115616:31115763,31117556:31117604,31118387:31118600,31118854:31118873,31119055:31119119,31119545:31119654,31120003:31120104,31120171:31120188,31120420:31120485,31121090:31121110,31121317:31121448,31122759:31122784,31123774:31123833,31124688:31124792,31124939:31125044,31125230:3112525', 'assoc_mat': '31100285:pehd:4230:31100384,31100987:pehd:4230:31101055,31101495:pehd:4230:31101562,31101969:pehd:4230:31102080,31102542:pehd:4230:31103031,31103395:pehd:4230:31103514,31103576:pehd:4230:31103737,31104234:pehd:4230:31104425,31104453:pehd:4230:31104581,31104646:pehd:4230:31104776,31104647:pehd:4230:31104826,31105005:pehd:4230:31105143,31105212:pehd:4230:31105448,31105384:pehd:4230:31105525,31106959:pehd:4230:31107034,31107396:pehd:4230:31107469,31107660:pehd:4230:31107752,31108773:pehd:4230:31108886,31109076:pehd:4230:31109217,31109330:pehd:4230:31109570,31109725:pehd:4230:31109885,31110040:pehd:4230:31110190,31110264:pehd:4230:31110443,31110500:pehd:4230:31110574,31110675:pehd:4230:31110830,31110888:pehd:4230:31111067,31111300:pehd:4230:31111447,31111915:pehd:4230:31111935,31112149:pehd:4230:31112205,31112349:pehd:4230:31112687,31112549:pehd:4230:31112994,31112722:pehd:4230:31112760,31113016:pehd:4230:31113115,31113228:pehd:4230:31113376,31113480:pehd:4230:31113583,31113690:pehd:4230:31113791,31114137:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.019088504064345726, 'nb_photo': 25295, 'list_port_cont': '31100383,31100579,31100850,31101059,31101280,31101563,31101846,31102087,31102344,31102901,31103020,31103251,31103513,31103741,31104007,31104421,31104579,31104785,31104827,31105149,31105449,31105532,31105774,31105807,31106144,31106341,31106539,31106815,31107035,31107282,31107468,31107751,31108045,31108267,31108564,31108891,31109216,31109566,31109895,31110203,31110445,31110572,31110831,31111068,31111439,31111647,31111678,31111842,31111937,31112208,31112681,31112757,31112985,31113110,31113377,31113585,31113785,31113971,31114297,31114538,31114726,31114863,31115229,31115524,31115767,31115957,31116191,31116428,31116720,31116843,31117164,31117204,31117577,31117611,31117921,31118123,31118299,31118595,31118835,31118883,31119118,31119361,31119661,31119864,31120105,31120199,31120480,31120729,31120946,31121118,31121450,31121699,31121930,31122208,31122378,31122420,31122776,31123014,31123168,31123344,31123553,31123842,31124033,31124252,31124539,31124795,31125053,31125259,31125564,31125951,31127520,31127561,31127604,3112766', 'assoc_port': '31100285:31100383,31100518:31100579,31100750:31100850,31100987:31101059,31101200:31101280,31101495:31101563,31101741:31101846,31101969:31102087,31102237:31102344,31102542:31103020,31102775:31102901,31103059:31103251,31103395:31103513,31103576:31103741,31103857:31104007,31104234:31104421,31104453:31104579,31104646:31104785,31104647:31104827,31105005:31105149,31105212:31105449,31105384:31105532,31105667:31105807,31105668:31105774,31106045:31106144,31106280:31106341,31106476:31106539,31106713:31106815,31106959:31107035,31107217:31107282,31107396:31107468,31107660:31107751,31107925:31108045,31108198:31108267,31108477:31108564,31108773:31108891,31109076:31109216,31109330:31109566,31109725:31109895,31110040:31110203,31110264:31110445,31110500:31110572,31110675:31110831,31110888:31111068,31111093:31111842,31111300:31111439,31111544:31111678,31111545:31111647,31111915:31111937,31112149:31112208,31112349:31112681,31112549:31112985,31112722:31112757,31113016:31113110,31113228:31113377,31113480:31113585,31113690:3111378', 'assoc_mat': '31100285:pet_clair:4230:31100383,31100518:pet_clair:4230:31100579,31100750:pet_clair:4230:31100850,31100987:pet_clair:4230:31101059,31101200:pet_clair:4230:31101280,31101495:pet_clair:4230:31101563,31101741:pet_clair:4230:31101846,31101969:pet_clair:4230:31102087,31102237:pet_clair:4230:31102344,31102542:pet_clair:4230:31103020,31102775:pet_clair:4230:31102901,31103059:pet_clair:4230:31103251,31103395:pet_clair:4230:31103513,31103576:pet_clair:4230:31103741,31103857:pet_clair:4230:31104007,31104234:pet_clair:4230:31104421,31104453:pet_clair:4230:31104579,31104646:pet_clair:4230:31104785,31104647:pet_clair:4230:31104827,31105005:pet_clair:4230:31105149,31105212:pet_clair:4230:31105449,31105384:pet_clair:4230:31105532,31105667:pet_clair:4230:31105807,31105668:pet_clair:4230:31105774,31106045:pet_clair:4230:31106144,31106280:pet_clair:4230:31106341,31106476:pet_clair:4230:31106539,31106713:pet_clair:4230:31106815,31106959:pet_clair:4230:31107035,31107217:pet_clair:4230:31107282,31107396:pet_clair:4230:31107468,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0020269251894684836, 'nb_photo': 805, 'list_port_cont': '31100577,31101054,31103029,31103508,31103739,31104008,31104426,31104576,31104782,31104820,31105151,31106146,31106331,31106807,31107754,31108047,31108562,31108894,31109213,31109557,31110201,31110437,31110829,31111440,31111828,31111939,31112209,31112684,31112762,31112988,31113117,31113378,31113587,31113790,31113966,31114296,31114542,31114735,31114874,31115232,31118118,31118596,31119120,31119367,31119658,31120102,31120937,31121928,31122418,31122783,31123010,31123557,31124255,31124543,31124796,31125052,31125260,31125567,31125946,31127527,31127557,31127598,31127678,31128180,31128226,31128258,31128452,31128607,31128841,31128920,31129236,31129317,31129532,31129808,31130421,31130895,31131321,31132581,31133138,31134426,31134741,31134820,31135029,31135057,31135261,31135591,31135852,31136728,31137376,31137715,31137888,31138264,31138581,31139107,31139348,31139916,31140831,31141957,31142449,31142481,31142889,31143109,31143293,31143464,31143800,31144051,31144341,31144607,31144758,31145381,31145614,31145878,31146905,3114743', 'assoc_port': '31100518:31100577,31100987:31101054,31102542:31103029,31103395:31103508,31103576:31103739,31103857:31104008,31104234:31104426,31104453:31104576,31104646:31104782,31104647:31104820,31105005:31105151,31106045:31106146,31106280:31106331,31106713:31106807,31107660:31107754,31107925:31108047,31108477:31108562,31108773:31108894,31109076:31109213,31109330:31109557,31110040:31110201,31110264:31110437,31110675:31110829,31111093:31111828,31111300:31111440,31111915:31111939,31112149:31112209,31112349:31112684,31112549:31112988,31112722:31112762,31113016:31113117,31113228:31113378,31113480:31113587,31113690:31113790,31113859:31113966,31114137:31114296,31114402:31114542,31114646:31114735,31114845:31114874,31115086:31115232,31118057:31118118,31118387:31118596,31119055:31119120,31119301:31119367,31119545:31119658,31120003:31120102,31120878:31120937,31121869:31121928,31122356:31122418,31122759:31122783,31122990:31123010,31123523:31123557,31124227:31124255,31124474:31124543,31124688:31124796,31124939:31125052,31125230:3112526', 'assoc_mat': '31100518:pet_fonce:4230:31100577,31100987:pet_fonce:4230:31101054,31102542:pet_fonce:4230:31103029,31103395:pet_fonce:4230:31103508,31103576:pet_fonce:4230:31103739,31103857:pet_fonce:4230:31104008,31104234:pet_fonce:4230:31104426,31104453:pet_fonce:4230:31104576,31104646:pet_fonce:4230:31104782,31104647:pet_fonce:4230:31104820,31105005:pet_fonce:4230:31105151,31106045:pet_fonce:4230:31106146,31106280:pet_fonce:4230:31106331,31106713:pet_fonce:4230:31106807,31107660:pet_fonce:4230:31107754,31107925:pet_fonce:4230:31108047,31108477:pet_fonce:4230:31108562,31108773:pet_fonce:4230:31108894,31109076:pet_fonce:4230:31109213,31109330:pet_fonce:4230:31109557,31110040:pet_fonce:4230:31110201,31110264:pet_fonce:4230:31110437,31110675:pet_fonce:4230:31110829,31111093:pet_fonce:4230:31111828,31111300:pet_fonce:4230:31111440,31111915:pet_fonce:4230:31111939,31112149:pet_fonce:4230:31112209,31112349:pet_fonce:4230:31112684,31112549:pet_fonce:4230:31112988,31112722:pet_fonce:4230:31112762,31113016:pet_fonce:4230:31113117,3'}), 'main_stat': {'nb_photos': 2055}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31195415,31195416,31195417,31195418,31195419,31195420,31195421?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-09', 0.7901543952307981),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_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', '1.16%', 16132], 'carton': ['carton', '3.21%', 65158], 'metal': ['metal', '0.09%', 1448], 'papier': ['papier', '16.44%', 404375], 'pehd': ['pehd', '0.24%', 1414], 'pet_clair': ['pet_clair', '1.91%', 25295], 'pet_fonce': ['pet_fonce', '0.2%', 805]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_09_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.55user 2.94system 0:07.19elapsed 76%CPU (0avgtext+0avgdata 192116maxresident)k 192inputs+304outputs (9major+54563minor)pagefaults 0swaps