python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-10 _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 : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 10 mtr_id : dashboard_places : SCCU_cam8 date : 2026-10 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2026-10%') and created_at like '%2026-10%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 10 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 10 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%102026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-10-01 : dt_date_just_month_year : 2026-10-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-10-01" AND ded.date <= "2026-10-31" SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (3011128,3011768,3012512,3013150,3013838,3014426,3015042,3015518,3016050,3016540,3017066,3017598,3018372,3018600,3019224,3019816,3020398,3020930,3021490,3022050,3022580,3023080,3023526,3023882,3024244,3024630) 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.023767043101033464, 'nb_photo': 19045, 'list_port_cont': '31242946,31243223,31243546,31243921,31244140,31244252,31244996,31245040,31245049,31245542,31245587,31245639,31245685,31245798,31246268,31246386,31246614,31246702,31246905,31247111,31247331,31247488,31247600,31247941,31248148,31248343,31248479,31248858,31248960,31249239,31249505,31249544,31250432,31250846,31250961,31251301,31251354,31251519,31251772,31252376,31252463,31252507,31252750,31252993,31253111,31253382,31253663,31253755,31254037,31254292,31254946,31255010,31255307,31255571,31255755,31255913,31255947,31256279,31256529,31256862,31257024,31257074,31257354,31257682,31257897,31257950,31258168,31258342,31258573,31258734,31259040,31259378,31259415,31259774,31260075,31260511,31260819,31260979,31261377,31261472,31261862,31262101,31262643,31262898,31262958,31263015,31263289,31263571,31263772,31263808,31264123,31264410,31264671,31264917,31265220,31265489,31265782,31266138,31266412,31266867,31266957,31267257,31267307,31267683,31267859,31267935,31268265,31268312,31268632,31268666,31269041,31269207,31269242,3126976', 'assoc_port': '31242832:31242946,31242968:31243223,31243173:31243546,31243656:31244252,31243667:31243921,31243835:31244140,31244368:31244996,31244382:31245040,31244579:31245542,31244666:31245049,31244976:31245587,31245189:31245685,31245246:31245639,31245448:31245798,31245622:31246268,31246014:31246386,31246291:31246614,31246428:31246702,31246607:31246905,31246899:31247111,31247188:31247331,31247417:31247600,31247418:31247488,31247848:31247941,31247991:31248148,31248204:31248343,31248407:31248479,31248665:31248858,31248887:31248960,31249119:31249239,31249315:31249544,31249316:31249505,31250366:31250432,31250521:31250846,31250546:31250961,31251051:31251301,31251094:31251354,31251342:31251519,31251597:31251772,31252021:31252376,31252043:31252463,31252044:31252507,31252539:31252750,31252742:31252993,31253014:31253111,31253289:31253382,31253469:31253663,31253693:31253755,31253871:31254037,31254125:31254292,31254404:31254946,31254549:31255755,31254852:31255010,31255127:31255307,31255415:31255571,31255742:31255913,31255842:3125594', 'assoc_mat': '31242832:autre:4230:31242946,31242968:autre:4230:31243223,31243173:autre:4230:31243546,31243656:autre:4230:31244252,31243667:autre:4230:31243921,31243835:autre:4230:31244140,31244368:autre:4230:31244996,31244382:autre:4230:31245040,31244579:autre:4230:31245542,31244666:autre:4230:31245049,31244976:autre:4230:31245587,31245189:autre:4230:31245685,31245246:autre:4230:31245639,31245448:autre:4230:31245798,31245622:autre:4230:31246268,31246014:autre:4230:31246386,31246291:autre:4230:31246614,31246428:autre:4230:31246702,31246607:autre:4230:31246905,31246899:autre:4230:31247111,31247188:autre:4230:31247331,31247417:autre:4230:31247600,31247418:autre:4230:31247488,31247848:autre:4230:31247941,31247991:autre:4230:31248148,31248204:autre:4230:31248343,31248407:autre:4230:31248479,31248665:autre:4230:31248858,31248887:autre:4230:31248960,31249119:autre:4230:31249239,31249315:autre:4230:31249544,31249316:autre:4230:31249505,31250366:autre:4230:31250432,31250521:autre:4230:31250846,31250546:autre:4230:31250961,31251051:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13010374542499828, 'nb_photo': 133458, 'list_port_cont': '31242943,31243222,31243554,31243909,31244138,31244259,31244999,31245035,31245054,31245539,31245596,31245642,31245681,31245807,31246269,31246381,31246623,31246698,31246912,31247122,31247334,31247487,31247602,31247948,31248157,31248335,31248485,31248861,31248952,31249236,31249495,31249534,31250437,31250856,31250967,31251314,31251357,31251533,31251782,31252390,31252459,31252517,31252765,31252994,31253112,31253384,31253659,31253757,31254036,31254290,31254938,31255019,31255312,31255582,31255758,31255908,31255957,31256277,31256541,31256860,31257034,31257072,31257365,31257688,31257908,31257951,31258183,31258349,31258572,31258749,31259041,31259389,31259419,31259779,31260069,31260506,31260822,31260992,31261391,31261461,31261875,31262108,31262652,31262889,31262965,31263017,31263291,31263567,31263775,31263804,31264137,31264402,31264678,31264920,31265212,31265494,31265796,31266151,31266418,31266878,31266959,31267270,31267308,31267694,31267855,31267948,31268269,31268315,31268628,31268663,31269043,31269182,31269215,3126925', 'assoc_port': '31242832:31242943,31242968:31243222,31243173:31243554,31243656:31244259,31243667:31243909,31243835:31244138,31244368:31244999,31244382:31245035,31244579:31245539,31244666:31245054,31244976:31245596,31245189:31245681,31245246:31245642,31245448:31245807,31245622:31246269,31246014:31246381,31246291:31246623,31246428:31246698,31246607:31246912,31246899:31247122,31247188:31247334,31247417:31247602,31247418:31247487,31247848:31247948,31247991:31248157,31248204:31248335,31248407:31248485,31248665:31248861,31248887:31248952,31249119:31249236,31249315:31249534,31249316:31249495,31250366:31250437,31250521:31250856,31250546:31250967,31251051:31251314,31251094:31251357,31251342:31251533,31251597:31251782,31252021:31252390,31252043:31252459,31252044:31252517,31252539:31252765,31252742:31252994,31253014:31253112,31253289:31253384,31253469:31253659,31253693:31253757,31253871:31254036,31254125:31254290,31254404:31254938,31254549:31255758,31254852:31255019,31255127:31255312,31255415:31255582,31255742:31255908,31255842:3125595', 'assoc_mat': '31242832:carton:4230:31242943,31242968:carton:4230:31243222,31243173:carton:4230:31243554,31243656:carton:4230:31244259,31243667:carton:4230:31243909,31243835:carton:4230:31244138,31244368:carton:4230:31244999,31244382:carton:4230:31245035,31244579:carton:4230:31245539,31244666:carton:4230:31245054,31244976:carton:4230:31245596,31245189:carton:4230:31245681,31245246:carton:4230:31245642,31245448:carton:4230:31245807,31245622:carton:4230:31246269,31246014:carton:4230:31246381,31246291:carton:4230:31246623,31246428:carton:4230:31246698,31246607:carton:4230:31246912,31246899:carton:4230:31247122,31247188:carton:4230:31247334,31247417:carton:4230:31247602,31247418:carton:4230:31247487,31247848:carton:4230:31247948,31247991:carton:4230:31248157,31248204:carton:4230:31248335,31248407:carton:4230:31248485,31248665:carton:4230:31248861,31248887:carton:4230:31248952,31249119:carton:4230:31249236,31249315:carton:4230:31249534,31249316:carton:4230:31249495,31250366:carton:4230:31250437,31250521:carton:4230:31250856,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001769906429229689, 'nb_photo': 1649, 'list_port_cont': '31242935,31243224,31243537,31243907,31244141,31244257,31244995,31245037,31245046,31245532,31245600,31245627,31245684,31245801,31246265,31246388,31246628,31246692,31246904,31247106,31247336,31247483,31247593,31247940,31248158,31248345,31248475,31248866,31248951,31249503,31249535,31250422,31250847,31251535,31254937,31255003,31255302,31255581,31255745,31255916,31255953,31256281,31256528,31256864,31260497,31260821,31260982,31261385,31261462,31261860,31262102,31262649,31264405,31264677,31265496,31265781,31266153,31266414,31266866,31266956,31267266,31267295,31267682,31268258,31268306,31268671,31269168,31269214,31270743,31271700,31271864,31271901,31272358,31272517,31272901,31273070,31273568,31273963,31274044,31274093,31274854,31274972,31275184,31275514,31275826,31276020,31276366,31276483,31276777,31276927,31277306,31277483,31277795,31277850,31277977,31278214,31278690,31278745,31279888,31280028,31280422,31280961,31281010,31281371,31281736,31282233,31282342,31282670,31282987,31283803,31283973,31284108,31284278,3128491', 'assoc_port': '31242832:31242935,31242968:31243224,31243173:31243537,31243656:31244257,31243667:31243907,31243835:31244141,31244368:31244995,31244382:31245037,31244579:31245532,31244666:31245046,31244976:31245600,31245189:31245684,31245246:31245627,31245448:31245801,31245622:31246265,31246014:31246388,31246291:31246628,31246428:31246692,31246607:31246904,31246899:31247106,31247188:31247336,31247417:31247593,31247418:31247483,31247848:31247940,31247991:31248158,31248204:31248345,31248407:31248475,31248665:31248866,31248887:31248951,31249315:31249535,31249316:31249503,31250366:31250422,31250521:31250847,31251342:31251535,31254404:31254937,31254549:31255745,31254852:31255003,31255127:31255302,31255415:31255581,31255742:31255916,31255842:31255953,31256100:31256281,31256388:31256528,31256648:31256864,31260174:31260497,31260532:31260821,31260789:31260982,31261169:31261385,31261218:31261462,31261573:31261860,31261931:31262102,31262347:31262649,31264242:31264405,31264547:31264677,31265361:31265496,31265618:31265781,31265819:3126615', 'assoc_mat': '31242832:metal:4230:31242935,31242968:metal:4230:31243224,31243173:metal:4230:31243537,31243656:metal:4230:31244257,31243667:metal:4230:31243907,31243835:metal:4230:31244141,31244368:metal:4230:31244995,31244382:metal:4230:31245037,31244579:metal:4230:31245532,31244666:metal:4230:31245046,31244976:metal:4230:31245600,31245189:metal:4230:31245684,31245246:metal:4230:31245627,31245448:metal:4230:31245801,31245622:metal:4230:31246265,31246014:metal:4230:31246388,31246291:metal:4230:31246628,31246428:metal:4230:31246692,31246607:metal:4230:31246904,31246899:metal:4230:31247106,31247188:metal:4230:31247336,31247417:metal:4230:31247593,31247418:metal:4230:31247483,31247848:metal:4230:31247940,31247991:metal:4230:31248158,31248204:metal:4230:31248345,31248407:metal:4230:31248475,31248665:metal:4230:31248866,31248887:metal:4230:31248951,31249315:metal:4230:31249535,31249316:metal:4230:31249503,31250366:metal:4230:31250422,31250521:metal:4230:31250847,31251342:metal:4230:31251535,31254404:metal:4230:31254937,31254549:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.378768363122113, 'nb_photo': 320558, 'list_port_cont': '31242944,31243232,31243553,31243920,31244133,31244255,31245003,31245034,31245059,31245543,31245594,31245636,31245686,31245805,31246272,31246378,31246617,31246704,31246919,31247121,31247333,31247484,31247608,31247947,31248159,31248337,31248484,31248860,31248957,31249244,31249501,31249539,31250439,31250857,31250975,31251311,31251351,31251529,31251783,31252386,31252462,31252506,31252756,31252989,31253102,31253388,31253658,31253748,31254046,31254297,31254939,31255015,31255309,31255580,31255759,31255920,31255949,31256276,31256538,31256861,31257029,31257070,31257363,31257676,31257905,31257949,31258179,31258348,31258583,31258745,31259048,31259387,31259423,31259780,31260064,31260498,31260816,31260987,31261393,31261467,31261871,31262110,31262645,31262894,31262966,31263011,31263292,31263564,31263769,31263812,31264132,31264407,31264674,31264921,31265217,31265504,31265791,31266154,31266421,31266880,31266965,31267264,31267306,31267693,31267862,31267941,31268272,31268314,31268625,31268669,31269049,31269172,31269218,3126925', 'assoc_port': '31242832:31242944,31242968:31243232,31243173:31243553,31243656:31244255,31243667:31243920,31243835:31244133,31244368:31245003,31244382:31245034,31244579:31245543,31244666:31245059,31244976:31245594,31245189:31245686,31245246:31245636,31245448:31245805,31245622:31246272,31246014:31246378,31246291:31246617,31246428:31246704,31246607:31246919,31246899:31247121,31247188:31247333,31247417:31247608,31247418:31247484,31247848:31247947,31247991:31248159,31248204:31248337,31248407:31248484,31248665:31248860,31248887:31248957,31249119:31249244,31249315:31249539,31249316:31249501,31250366:31250439,31250521:31250857,31250546:31250975,31251051:31251311,31251094:31251351,31251342:31251529,31251597:31251783,31252021:31252386,31252043:31252462,31252044:31252506,31252539:31252756,31252742:31252989,31253014:31253102,31253289:31253388,31253469:31253658,31253693:31253748,31253871:31254046,31254125:31254297,31254404:31254939,31254549:31255759,31254852:31255015,31255127:31255309,31255415:31255580,31255742:31255920,31255842:3125594', 'assoc_mat': '31242832:papier:4230:31242944,31242968:papier:4230:31243232,31243173:papier:4230:31243553,31243656:papier:4230:31244255,31243667:papier:4230:31243920,31243835:papier:4230:31244133,31244368:papier:4230:31245003,31244382:papier:4230:31245034,31244579:papier:4230:31245543,31244666:papier:4230:31245059,31244976:papier:4230:31245594,31245189:papier:4230:31245686,31245246:papier:4230:31245636,31245448:papier:4230:31245805,31245622:papier:4230:31246272,31246014:papier:4230:31246378,31246291:papier:4230:31246617,31246428:papier:4230:31246704,31246607:papier:4230:31246919,31246899:papier:4230:31247121,31247188:papier:4230:31247333,31247417:papier:4230:31247608,31247418:papier:4230:31247484,31247848:papier:4230:31247947,31247991:papier:4230:31248159,31248204:papier:4230:31248337,31248407:papier:4230:31248484,31248665:papier:4230:31248860,31248887:papier:4230:31248957,31249119:papier:4230:31249244,31249315:papier:4230:31249539,31249316:papier:4230:31249501,31250366:papier:4230:31250439,31250521:papier:4230:31250857,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0092656568232982, 'nb_photo': 7313, 'list_port_cont': '31242949,31243221,31243550,31243915,31244136,31244262,31244997,31245038,31245062,31245547,31245597,31245643,31245677,31245797,31246271,31246387,31246620,31246697,31246913,31247119,31247330,31247481,31247604,31247943,31248153,31248338,31248480,31248867,31248962,31249246,31249498,31249542,31250433,31250853,31250978,31251313,31251365,31251525,31251777,31252382,31252466,31252763,31252984,31253109,31253390,31253664,31253747,31254047,31254291,31254942,31255012,31255316,31255587,31255757,31255918,31255956,31256280,31256543,31256853,31257026,31257073,31257367,31257690,31257898,31257937,31258176,31258338,31258578,31258736,31259050,31259384,31259417,31259789,31260071,31260509,31260817,31260989,31261389,31261466,31261870,31262097,31262658,31262892,31262972,31263008,31263770,31263806,31264133,31264406,31264675,31265218,31265506,31265797,31266150,31266409,31271714,31271875,31271907,31272353,31272514,31272906,31273066,31273573,31273837,31273971,31274042,31274101,31274859,31274965,31275196,31275524,31275827,31276017,3127636', 'assoc_port': '31242832:31242949,31242968:31243221,31243173:31243550,31243656:31244262,31243667:31243915,31243835:31244136,31244368:31244997,31244382:31245038,31244579:31245547,31244666:31245062,31244976:31245597,31245189:31245677,31245246:31245643,31245448:31245797,31245622:31246271,31246014:31246387,31246291:31246620,31246428:31246697,31246607:31246913,31246899:31247119,31247188:31247330,31247417:31247604,31247418:31247481,31247848:31247943,31247991:31248153,31248204:31248338,31248407:31248480,31248665:31248867,31248887:31248962,31249119:31249246,31249315:31249542,31249316:31249498,31250366:31250433,31250521:31250853,31250546:31250978,31251051:31251313,31251094:31251365,31251342:31251525,31251597:31251777,31252021:31252382,31252043:31252466,31252539:31252763,31252742:31252984,31253014:31253109,31253289:31253390,31253469:31253664,31253693:31253747,31253871:31254047,31254125:31254291,31254404:31254942,31254549:31255757,31254852:31255012,31255127:31255316,31255415:31255587,31255742:31255918,31255842:31255956,31256100:3125628', 'assoc_mat': '31242832:pehd:4230:31242949,31242968:pehd:4230:31243221,31243173:pehd:4230:31243550,31243656:pehd:4230:31244262,31243667:pehd:4230:31243915,31243835:pehd:4230:31244136,31244368:pehd:4230:31244997,31244382:pehd:4230:31245038,31244579:pehd:4230:31245547,31244666:pehd:4230:31245062,31244976:pehd:4230:31245597,31245189:pehd:4230:31245677,31245246:pehd:4230:31245643,31245448:pehd:4230:31245797,31245622:pehd:4230:31246271,31246014:pehd:4230:31246387,31246291:pehd:4230:31246620,31246428:pehd:4230:31246697,31246607:pehd:4230:31246913,31246899:pehd:4230:31247119,31247188:pehd:4230:31247330,31247417:pehd:4230:31247604,31247418:pehd:4230:31247481,31247848:pehd:4230:31247943,31247991:pehd:4230:31248153,31248204:pehd:4230:31248338,31248407:pehd:4230:31248480,31248665:pehd:4230:31248867,31248887:pehd:4230:31248962,31249119:pehd:4230:31249246,31249315:pehd:4230:31249542,31249316:pehd:4230:31249498,31250366:pehd:4230:31250433,31250521:pehd:4230:31250853,31250546:pehd:4230:31250978,31251051:pehd:4230:31251313,31251094:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017338679647802575, 'nb_photo': 14261, 'list_port_cont': '31242939,31243229,31243545,31243916,31244135,31244265,31245001,31245042,31245063,31245541,31245599,31245634,31245678,31245806,31246267,31246382,31246624,31246696,31246916,31247114,31247335,31247480,31247605,31247951,31248156,31248342,31248482,31248865,31248958,31249245,31249504,31249541,31250438,31250850,31250974,31251307,31251367,31251534,31251780,31252387,31252464,31252512,31252764,31252988,31253104,31253387,31253660,31253753,31254041,31254300,31254943,31255011,31255313,31255586,31255756,31255912,31255955,31256274,31256545,31256863,31257032,31257060,31257366,31257681,31257902,31257944,31258173,31258346,31258581,31258746,31259043,31259390,31259427,31259782,31260070,31260512,31260824,31260986,31261386,31261475,31261867,31262107,31262656,31262893,31262968,31263019,31263294,31263562,31263766,31263811,31264135,31264403,31264672,31264919,31265216,31265505,31265793,31266152,31266417,31266874,31266963,31267271,31267304,31267688,31267861,31267947,31268271,31268316,31268631,31268665,31269056,31269175,31269212,3126925', 'assoc_port': '31242832:31242939,31242968:31243229,31243173:31243545,31243656:31244265,31243667:31243916,31243835:31244135,31244368:31245001,31244382:31245042,31244579:31245541,31244666:31245063,31244976:31245599,31245189:31245678,31245246:31245634,31245448:31245806,31245622:31246267,31246014:31246382,31246291:31246624,31246428:31246696,31246607:31246916,31246899:31247114,31247188:31247335,31247417:31247605,31247418:31247480,31247848:31247951,31247991:31248156,31248204:31248342,31248407:31248482,31248665:31248865,31248887:31248958,31249119:31249245,31249315:31249541,31249316:31249504,31250366:31250438,31250521:31250850,31250546:31250974,31251051:31251307,31251094:31251367,31251342:31251534,31251597:31251780,31252021:31252387,31252043:31252464,31252044:31252512,31252539:31252764,31252742:31252988,31253014:31253104,31253289:31253387,31253469:31253660,31253693:31253753,31253871:31254041,31254125:31254300,31254404:31254943,31254549:31255756,31254852:31255011,31255127:31255313,31255415:31255586,31255742:31255912,31255842:3125595', 'assoc_mat': '31242832:pet_clair:4230:31242939,31242968:pet_clair:4230:31243229,31243173:pet_clair:4230:31243545,31243656:pet_clair:4230:31244265,31243667:pet_clair:4230:31243916,31243835:pet_clair:4230:31244135,31244368:pet_clair:4230:31245001,31244382:pet_clair:4230:31245042,31244579:pet_clair:4230:31245541,31244666:pet_clair:4230:31245063,31244976:pet_clair:4230:31245599,31245189:pet_clair:4230:31245678,31245246:pet_clair:4230:31245634,31245448:pet_clair:4230:31245806,31245622:pet_clair:4230:31246267,31246014:pet_clair:4230:31246382,31246291:pet_clair:4230:31246624,31246428:pet_clair:4230:31246696,31246607:pet_clair:4230:31246916,31246899:pet_clair:4230:31247114,31247188:pet_clair:4230:31247335,31247417:pet_clair:4230:31247605,31247418:pet_clair:4230:31247480,31247848:pet_clair:4230:31247951,31247991:pet_clair:4230:31248156,31248204:pet_clair:4230:31248342,31248407:pet_clair:4230:31248482,31248665:pet_clair:4230:31248865,31248887:pet_clair:4230:31248958,31249119:pet_clair:4230:31249245,31249315:pet_clair:4230:31249541,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006438531946792458, 'nb_photo': 1527, 'list_port_cont': '31243549,31243914,31244266,31245032,31245056,31245544,31245601,31245631,31245675,31245804,31246264,31246627,31246699,31246917,31247120,31247323,31247486,31247607,31247942,31248154,31248331,31248470,31248864,31248953,31249248,31249491,31249543,31250428,31250854,31251316,31251359,31251528,31255761,31255919,31255958,31256544,31257027,31257685,31257901,31260499,31260823,31261384,31261474,31261876,31262100,31262653,31263298,31264673,31265498,31266149,31266876,31266955,31267260,31267311,31267685,31267851,31267945,31268310,31271873,31271911,31272359,31272896,31273072,31273570,31273843,31273964,31274040,31274104,31274861,31274970,31275195,31275522,31275835,31276021,31276356,31276488,31276776,31276937,31277303,31277495,31277810,31277838,31277974,31278230,31278703,31278759,31279894,31280035,31280412,31281380,31281742,31282235,31282347,31282682,31282986,31283656,31283819,31283983,31284117,31284280,31284404,31284627,31285174,31285904,31286050,31286413,31287017,31287114,31287277,31287710,31287876,31288050,31288135,3128823', 'assoc_port': '31243173:31243549,31243656:31244266,31243667:31243914,31244382:31245032,31244579:31245544,31244666:31245056,31244976:31245601,31245189:31245675,31245246:31245631,31245448:31245804,31245622:31246264,31246291:31246627,31246428:31246699,31246607:31246917,31246899:31247120,31247188:31247323,31247417:31247607,31247418:31247486,31247848:31247942,31247991:31248154,31248204:31248331,31248407:31248470,31248665:31248864,31248887:31248953,31249119:31249248,31249315:31249543,31249316:31249491,31250366:31250428,31250521:31250854,31251051:31251316,31251094:31251359,31251342:31251528,31254549:31255761,31255742:31255919,31255842:31255958,31256388:31256544,31256823:31257027,31257544:31257685,31257803:31257901,31260174:31260499,31260532:31260823,31261169:31261384,31261218:31261474,31261573:31261876,31261931:31262100,31262347:31262653,31263125:31263298,31264547:31264673,31265361:31265498,31265819:31266149,31266525:31266876,31266571:31266955,31267083:31267260,31267084:31267311,31267334:31267685,31267345:31267851,31267621:3126794', 'assoc_mat': '31243173:pet_fonce:4230:31243549,31243656:pet_fonce:4230:31244266,31243667:pet_fonce:4230:31243914,31244382:pet_fonce:4230:31245032,31244579:pet_fonce:4230:31245544,31244666:pet_fonce:4230:31245056,31244976:pet_fonce:4230:31245601,31245189:pet_fonce:4230:31245675,31245246:pet_fonce:4230:31245631,31245448:pet_fonce:4230:31245804,31245622:pet_fonce:4230:31246264,31246291:pet_fonce:4230:31246627,31246428:pet_fonce:4230:31246699,31246607:pet_fonce:4230:31246917,31246899:pet_fonce:4230:31247120,31247188:pet_fonce:4230:31247323,31247417:pet_fonce:4230:31247607,31247418:pet_fonce:4230:31247486,31247848:pet_fonce:4230:31247942,31247991:pet_fonce:4230:31248154,31248204:pet_fonce:4230:31248331,31248407:pet_fonce:4230:31248470,31248665:pet_fonce:4230:31248864,31248887:pet_fonce:4230:31248953,31249119:pet_fonce:4230:31249248,31249315:pet_fonce:4230:31249543,31249316:pet_fonce:4230:31249491,31250366:pet_fonce:4230:31250428,31250521:pet_fonce:4230:31250854,31251051:pet_fonce:4230:31251316,31251094:pet_fonce:4230:31251359,3'}, {'unwanted_material': 'refus', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3680266736220992, 'nb_photo': 146, 'list_port_cont': '31355406', 'assoc_port': '31355140:31355406', 'assoc_mat': '31355140:refus:4230:31355406'}) 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(3011128,3011768,3012512,3013150,3013838,3014426,3015042,3015518,3016050,3016540,3017066,3017598,3018372,3018600,3019224,3019816,3020398,3020930,3021490,3022050,3022580,3023080,3023526,3023882,3024244,3024630)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341236, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31242946,31243223,31243546,31243921,31244140,31244252,31244996,31245040,31245049,31245542,31245587,31245639,31245685,31245798,31246268,31246386,31246614,31246702,31246905,31247111,31247331,31247488,31247600,31247941,31248148,31248343,31248479,31248858,31248960,31249239,31249505,31249544,31250432,31250846,31250961,31251301,31251354,31251519,31251772,31252376,31252463,31252507,31252750,31252993,31253111,31253382,31253663,31253755,31254037,31254292,31254946,31255010,31255307,31255571,31255755,31255913,31255947,31256279,31256529,31256862,31257024,31257074,31257354,31257682,31257897,31257950,31258168,31258342,31258573,31258734,31259040,31259378,31259415,31259774,31260075,31260511,31260819,31260979,31261377,31261472,31261862,31262101,31262643,31262898,31262958,31263015,31263289,31263571,31263772,31263808,31264123,31264410,31264671,31264917,31265220,31265489,31265782,31266138,31266412,31266867,31266957,31267257,31267307,31267683,31267859,31267935,31268265,31268312,31268632,31268666,31269041,31269207,31269242,3126976 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341237, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31242943,31243222,31243554,31243909,31244138,31244259,31244999,31245035,31245054,31245539,31245596,31245642,31245681,31245807,31246269,31246381,31246623,31246698,31246912,31247122,31247334,31247487,31247602,31247948,31248157,31248335,31248485,31248861,31248952,31249236,31249495,31249534,31250437,31250856,31250967,31251314,31251357,31251533,31251782,31252390,31252459,31252517,31252765,31252994,31253112,31253384,31253659,31253757,31254036,31254290,31254938,31255019,31255312,31255582,31255758,31255908,31255957,31256277,31256541,31256860,31257034,31257072,31257365,31257688,31257908,31257951,31258183,31258349,31258572,31258749,31259041,31259389,31259419,31259779,31260069,31260506,31260822,31260992,31261391,31261461,31261875,31262108,31262652,31262889,31262965,31263017,31263291,31263567,31263775,31263804,31264137,31264402,31264678,31264920,31265212,31265494,31265796,31266151,31266418,31266878,31266959,31267270,31267308,31267694,31267855,31267948,31268269,31268315,31268628,31268663,31269043,31269182,31269215,3126925 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341238, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31242935,31243224,31243537,31243907,31244141,31244257,31244995,31245037,31245046,31245532,31245600,31245627,31245684,31245801,31246265,31246388,31246628,31246692,31246904,31247106,31247336,31247483,31247593,31247940,31248158,31248345,31248475,31248866,31248951,31249503,31249535,31250422,31250847,31251535,31254937,31255003,31255302,31255581,31255745,31255916,31255953,31256281,31256528,31256864,31260497,31260821,31260982,31261385,31261462,31261860,31262102,31262649,31264405,31264677,31265496,31265781,31266153,31266414,31266866,31266956,31267266,31267295,31267682,31268258,31268306,31268671,31269168,31269214,31270743,31271700,31271864,31271901,31272358,31272517,31272901,31273070,31273568,31273963,31274044,31274093,31274854,31274972,31275184,31275514,31275826,31276020,31276366,31276483,31276777,31276927,31277306,31277483,31277795,31277850,31277977,31278214,31278690,31278745,31279888,31280028,31280422,31280961,31281010,31281371,31281736,31282233,31282342,31282670,31282987,31283803,31283973,31284108,31284278,3128491 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341239, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31242944,31243232,31243553,31243920,31244133,31244255,31245003,31245034,31245059,31245543,31245594,31245636,31245686,31245805,31246272,31246378,31246617,31246704,31246919,31247121,31247333,31247484,31247608,31247947,31248159,31248337,31248484,31248860,31248957,31249244,31249501,31249539,31250439,31250857,31250975,31251311,31251351,31251529,31251783,31252386,31252462,31252506,31252756,31252989,31253102,31253388,31253658,31253748,31254046,31254297,31254939,31255015,31255309,31255580,31255759,31255920,31255949,31256276,31256538,31256861,31257029,31257070,31257363,31257676,31257905,31257949,31258179,31258348,31258583,31258745,31259048,31259387,31259423,31259780,31260064,31260498,31260816,31260987,31261393,31261467,31261871,31262110,31262645,31262894,31262966,31263011,31263292,31263564,31263769,31263812,31264132,31264407,31264674,31264921,31265217,31265504,31265791,31266154,31266421,31266880,31266965,31267264,31267306,31267693,31267862,31267941,31268272,31268314,31268625,31268669,31269049,31269172,31269218,3126925 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341240, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31242949,31243221,31243550,31243915,31244136,31244262,31244997,31245038,31245062,31245547,31245597,31245643,31245677,31245797,31246271,31246387,31246620,31246697,31246913,31247119,31247330,31247481,31247604,31247943,31248153,31248338,31248480,31248867,31248962,31249246,31249498,31249542,31250433,31250853,31250978,31251313,31251365,31251525,31251777,31252382,31252466,31252763,31252984,31253109,31253390,31253664,31253747,31254047,31254291,31254942,31255012,31255316,31255587,31255757,31255918,31255956,31256280,31256543,31256853,31257026,31257073,31257367,31257690,31257898,31257937,31258176,31258338,31258578,31258736,31259050,31259384,31259417,31259789,31260071,31260509,31260817,31260989,31261389,31261466,31261870,31262097,31262658,31262892,31262972,31263008,31263770,31263806,31264133,31264406,31264675,31265218,31265506,31265797,31266150,31266409,31271714,31271875,31271907,31272353,31272514,31272906,31273066,31273573,31273837,31273971,31274042,31274101,31274859,31274965,31275196,31275524,31275827,31276017,3127636 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341241, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31242939,31243229,31243545,31243916,31244135,31244265,31245001,31245042,31245063,31245541,31245599,31245634,31245678,31245806,31246267,31246382,31246624,31246696,31246916,31247114,31247335,31247480,31247605,31247951,31248156,31248342,31248482,31248865,31248958,31249245,31249504,31249541,31250438,31250850,31250974,31251307,31251367,31251534,31251780,31252387,31252464,31252512,31252764,31252988,31253104,31253387,31253660,31253753,31254041,31254300,31254943,31255011,31255313,31255586,31255756,31255912,31255955,31256274,31256545,31256863,31257032,31257060,31257366,31257681,31257902,31257944,31258173,31258346,31258581,31258746,31259043,31259390,31259427,31259782,31260070,31260512,31260824,31260986,31261386,31261475,31261867,31262107,31262656,31262893,31262968,31263019,31263294,31263562,31263766,31263811,31264135,31264403,31264672,31264919,31265216,31265505,31265793,31266152,31266417,31266874,31266963,31267271,31267304,31267688,31267861,31267947,31268271,31268316,31268631,31268665,31269056,31269175,31269212,3126925 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31341242, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31243549,31243914,31244266,31245032,31245056,31245544,31245601,31245631,31245675,31245804,31246264,31246627,31246699,31246917,31247120,31247323,31247486,31247607,31247942,31248154,31248331,31248470,31248864,31248953,31249248,31249491,31249543,31250428,31250854,31251316,31251359,31251528,31255761,31255919,31255958,31256544,31257027,31257685,31257901,31260499,31260823,31261384,31261474,31261876,31262100,31262653,31263298,31264673,31265498,31266149,31266876,31266955,31267260,31267311,31267685,31267851,31267945,31268310,31271873,31271911,31272359,31272896,31273072,31273570,31273843,31273964,31274040,31274104,31274861,31274970,31275195,31275522,31275835,31276021,31276356,31276488,31276776,31276937,31277303,31277495,31277810,31277838,31277974,31278230,31278703,31278759,31279894,31280035,31280412,31281380,31281742,31282235,31282347,31282682,31282986,31283656,31283819,31283983,31284117,31284280,31284404,31284627,31285174,31285904,31286050,31286413,31287017,31287114,31287277,31287710,31287876,31288050,31288135,3128823 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31378959, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31355406 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31341236,31341237,31341238,31341239,31341240,31341241,31341242,31378959?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce,refus after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2026-10-01' and date <= '2026-10-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1378,),), 'unwanted_material_monthly_percentage': ((0.4889558627583436,),), 'material_repartition': (('incineration', 1378),), 'material_dict': {'incineration': 1378}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.4652299222505289, 2), (datetime.date(2026, 10, 2), 0.5634983824614184, 3), (datetime.date(2026, 10, 3), 0.7064769876713316, 3), (datetime.date(2026, 10, 4), 0.6865523296314423, 3), (datetime.date(2026, 10, 5), 0.8271912723505553, 2), (datetime.date(2026, 10, 6), 0.7092184734397243, 3), (datetime.date(2026, 10, 7), 0.47369063982763904, 2), (datetime.date(2026, 10, 8), 0.45525653267325417, 3), (datetime.date(2026, 10, 9), 0.4432410913264354, 1), (datetime.date(2026, 10, 10), 0.4722146537958655, 2), (datetime.date(2026, 10, 11), 0.44271641378241633, 3), (datetime.date(2026, 10, 12), 0.4930524976969901, 2), (datetime.date(2026, 10, 13), 0.44653240141644934, 2), (datetime.date(2026, 10, 14), 0.446820106675175, 2), (datetime.date(2026, 10, 15), 0.42573961179950387, 2), (datetime.date(2026, 10, 16), 0.42630309997266014, 2), (datetime.date(2026, 10, 17), 0.4308652343578406, 1), (datetime.date(2026, 10, 18), 0.4183977859326374, 1), (datetime.date(2026, 10, 19), 0.3846401198673579, 2), (datetime.date(2026, 10, 20), 0.3732661496090892, 3), (datetime.date(2026, 10, 21), 0.37551026112935915, 2), (datetime.date(2026, 10, 22), 0.37430936715892493, 3), (datetime.date(2026, 10, 23), 0.3661131841619704, 2), (datetime.date(2026, 10, 24), 0.4239338854517438, 2), (datetime.date(2026, 10, 25), 0.41189265269103886, 3), (datetime.date(2026, 10, 26), 0.43794817290894855, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.4652299222505289, 2), (datetime.date(2026, 10, 2), 0.5634983824614184, 3), (datetime.date(2026, 10, 3), 0.7064769876713316, 3), (datetime.date(2026, 10, 4), 0.6865523296314423, 3), (datetime.date(2026, 10, 5), 0.8271912723505553, 2), (datetime.date(2026, 10, 6), 0.7092184734397243, 3), (datetime.date(2026, 10, 7), 0.47369063982763904, 2), (datetime.date(2026, 10, 8), 0.45525653267325417, 3), (datetime.date(2026, 10, 9), 0.4432410913264354, 1), (datetime.date(2026, 10, 10), 0.4722146537958655, 2), (datetime.date(2026, 10, 11), 0.44271641378241633, 3), (datetime.date(2026, 10, 12), 0.4930524976969901, 2), (datetime.date(2026, 10, 13), 0.44653240141644934, 2), (datetime.date(2026, 10, 14), 0.446820106675175, 2), (datetime.date(2026, 10, 15), 0.42573961179950387, 2), (datetime.date(2026, 10, 16), 0.42630309997266014, 2), (datetime.date(2026, 10, 17), 0.4308652343578406, 1), (datetime.date(2026, 10, 18), 0.4183977859326374, 1), (datetime.date(2026, 10, 19), 0.3846401198673579, 2), (datetime.date(2026, 10, 20), 0.3732661496090892, 3), (datetime.date(2026, 10, 21), 0.37551026112935915, 2), (datetime.date(2026, 10, 22), 0.37430936715892493, 3), (datetime.date(2026, 10, 23), 0.3661131841619704, 2), (datetime.date(2026, 10, 24), 0.4239338854517438, 2), (datetime.date(2026, 10, 25), 0.41189265269103886, 3), (datetime.date(2026, 10, 26), 0.43794817290894855, 3))}, 'quality_array': [['-9.114763677368375', '01102026'], ['-7.642592881239511', '02102026'], ['-5.915254856608112', '03102026'], ['-6.1847886364587135', '04102026'], ['-5.116621655467581', '05102026'], ['-7.014046993257052', '06102026'], ['-9.217851850614043', '07102026'], ['-8.669071591071171', '08102026'], ['-8.82547940010849', '09102026'], ['-9.039526671355313', '10102026'], ['-9.079387687550295', '11102026'], ['-9.326304263953782', '12102026'], ['-9.435571628896428', '13102026'], ['-8.678716695453211', '14102026'], ['-8.937341817034099', '15102026'], ['-8.919599446807169', '16102026'], ['-7.8038022868050385', '17102026'], ['-8.156532762067714', '18102026'], ['-9.020686544214437', '19102026'], ['-8.928218578782275', '20102026'], ['-8.852875246564455', '21102026'], ['-8.864156633029786', '22102026'], ['-9.077843389212358', '23102026'], ['-9.058955642117974', '24102026'], ['-9.025044974060776', '25102026'], ['-8.94714323389459', '26102026']], 'number_of_batch': ((553,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.023767043101033464, 'nb_photo': 19045, 'list_port_cont': '31242946,31243223,31243546,31243921,31244140,31244252,31244996,31245040,31245049,31245542,31245587,31245639,31245685,31245798,31246268,31246386,31246614,31246702,31246905,31247111,31247331,31247488,31247600,31247941,31248148,31248343,31248479,31248858,31248960,31249239,31249505,31249544,31250432,31250846,31250961,31251301,31251354,31251519,31251772,31252376,31252463,31252507,31252750,31252993,31253111,31253382,31253663,31253755,31254037,31254292,31254946,31255010,31255307,31255571,31255755,31255913,31255947,31256279,31256529,31256862,31257024,31257074,31257354,31257682,31257897,31257950,31258168,31258342,31258573,31258734,31259040,31259378,31259415,31259774,31260075,31260511,31260819,31260979,31261377,31261472,31261862,31262101,31262643,31262898,31262958,31263015,31263289,31263571,31263772,31263808,31264123,31264410,31264671,31264917,31265220,31265489,31265782,31266138,31266412,31266867,31266957,31267257,31267307,31267683,31267859,31267935,31268265,31268312,31268632,31268666,31269041,31269207,31269242,3126976', 'assoc_port': '31242832:31242946,31242968:31243223,31243173:31243546,31243656:31244252,31243667:31243921,31243835:31244140,31244368:31244996,31244382:31245040,31244579:31245542,31244666:31245049,31244976:31245587,31245189:31245685,31245246:31245639,31245448:31245798,31245622:31246268,31246014:31246386,31246291:31246614,31246428:31246702,31246607:31246905,31246899:31247111,31247188:31247331,31247417:31247600,31247418:31247488,31247848:31247941,31247991:31248148,31248204:31248343,31248407:31248479,31248665:31248858,31248887:31248960,31249119:31249239,31249315:31249544,31249316:31249505,31250366:31250432,31250521:31250846,31250546:31250961,31251051:31251301,31251094:31251354,31251342:31251519,31251597:31251772,31252021:31252376,31252043:31252463,31252044:31252507,31252539:31252750,31252742:31252993,31253014:31253111,31253289:31253382,31253469:31253663,31253693:31253755,31253871:31254037,31254125:31254292,31254404:31254946,31254549:31255755,31254852:31255010,31255127:31255307,31255415:31255571,31255742:31255913,31255842:3125594', 'assoc_mat': '31242832:autre:4230:31242946,31242968:autre:4230:31243223,31243173:autre:4230:31243546,31243656:autre:4230:31244252,31243667:autre:4230:31243921,31243835:autre:4230:31244140,31244368:autre:4230:31244996,31244382:autre:4230:31245040,31244579:autre:4230:31245542,31244666:autre:4230:31245049,31244976:autre:4230:31245587,31245189:autre:4230:31245685,31245246:autre:4230:31245639,31245448:autre:4230:31245798,31245622:autre:4230:31246268,31246014:autre:4230:31246386,31246291:autre:4230:31246614,31246428:autre:4230:31246702,31246607:autre:4230:31246905,31246899:autre:4230:31247111,31247188:autre:4230:31247331,31247417:autre:4230:31247600,31247418:autre:4230:31247488,31247848:autre:4230:31247941,31247991:autre:4230:31248148,31248204:autre:4230:31248343,31248407:autre:4230:31248479,31248665:autre:4230:31248858,31248887:autre:4230:31248960,31249119:autre:4230:31249239,31249315:autre:4230:31249544,31249316:autre:4230:31249505,31250366:autre:4230:31250432,31250521:autre:4230:31250846,31250546:autre:4230:31250961,31251051:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13010374542499828, 'nb_photo': 133458, 'list_port_cont': '31242943,31243222,31243554,31243909,31244138,31244259,31244999,31245035,31245054,31245539,31245596,31245642,31245681,31245807,31246269,31246381,31246623,31246698,31246912,31247122,31247334,31247487,31247602,31247948,31248157,31248335,31248485,31248861,31248952,31249236,31249495,31249534,31250437,31250856,31250967,31251314,31251357,31251533,31251782,31252390,31252459,31252517,31252765,31252994,31253112,31253384,31253659,31253757,31254036,31254290,31254938,31255019,31255312,31255582,31255758,31255908,31255957,31256277,31256541,31256860,31257034,31257072,31257365,31257688,31257908,31257951,31258183,31258349,31258572,31258749,31259041,31259389,31259419,31259779,31260069,31260506,31260822,31260992,31261391,31261461,31261875,31262108,31262652,31262889,31262965,31263017,31263291,31263567,31263775,31263804,31264137,31264402,31264678,31264920,31265212,31265494,31265796,31266151,31266418,31266878,31266959,31267270,31267308,31267694,31267855,31267948,31268269,31268315,31268628,31268663,31269043,31269182,31269215,3126925', 'assoc_port': '31242832:31242943,31242968:31243222,31243173:31243554,31243656:31244259,31243667:31243909,31243835:31244138,31244368:31244999,31244382:31245035,31244579:31245539,31244666:31245054,31244976:31245596,31245189:31245681,31245246:31245642,31245448:31245807,31245622:31246269,31246014:31246381,31246291:31246623,31246428:31246698,31246607:31246912,31246899:31247122,31247188:31247334,31247417:31247602,31247418:31247487,31247848:31247948,31247991:31248157,31248204:31248335,31248407:31248485,31248665:31248861,31248887:31248952,31249119:31249236,31249315:31249534,31249316:31249495,31250366:31250437,31250521:31250856,31250546:31250967,31251051:31251314,31251094:31251357,31251342:31251533,31251597:31251782,31252021:31252390,31252043:31252459,31252044:31252517,31252539:31252765,31252742:31252994,31253014:31253112,31253289:31253384,31253469:31253659,31253693:31253757,31253871:31254036,31254125:31254290,31254404:31254938,31254549:31255758,31254852:31255019,31255127:31255312,31255415:31255582,31255742:31255908,31255842:3125595', 'assoc_mat': '31242832:carton:4230:31242943,31242968:carton:4230:31243222,31243173:carton:4230:31243554,31243656:carton:4230:31244259,31243667:carton:4230:31243909,31243835:carton:4230:31244138,31244368:carton:4230:31244999,31244382:carton:4230:31245035,31244579:carton:4230:31245539,31244666:carton:4230:31245054,31244976:carton:4230:31245596,31245189:carton:4230:31245681,31245246:carton:4230:31245642,31245448:carton:4230:31245807,31245622:carton:4230:31246269,31246014:carton:4230:31246381,31246291:carton:4230:31246623,31246428:carton:4230:31246698,31246607:carton:4230:31246912,31246899:carton:4230:31247122,31247188:carton:4230:31247334,31247417:carton:4230:31247602,31247418:carton:4230:31247487,31247848:carton:4230:31247948,31247991:carton:4230:31248157,31248204:carton:4230:31248335,31248407:carton:4230:31248485,31248665:carton:4230:31248861,31248887:carton:4230:31248952,31249119:carton:4230:31249236,31249315:carton:4230:31249534,31249316:carton:4230:31249495,31250366:carton:4230:31250437,31250521:carton:4230:31250856,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001769906429229689, 'nb_photo': 1649, 'list_port_cont': '31242935,31243224,31243537,31243907,31244141,31244257,31244995,31245037,31245046,31245532,31245600,31245627,31245684,31245801,31246265,31246388,31246628,31246692,31246904,31247106,31247336,31247483,31247593,31247940,31248158,31248345,31248475,31248866,31248951,31249503,31249535,31250422,31250847,31251535,31254937,31255003,31255302,31255581,31255745,31255916,31255953,31256281,31256528,31256864,31260497,31260821,31260982,31261385,31261462,31261860,31262102,31262649,31264405,31264677,31265496,31265781,31266153,31266414,31266866,31266956,31267266,31267295,31267682,31268258,31268306,31268671,31269168,31269214,31270743,31271700,31271864,31271901,31272358,31272517,31272901,31273070,31273568,31273963,31274044,31274093,31274854,31274972,31275184,31275514,31275826,31276020,31276366,31276483,31276777,31276927,31277306,31277483,31277795,31277850,31277977,31278214,31278690,31278745,31279888,31280028,31280422,31280961,31281010,31281371,31281736,31282233,31282342,31282670,31282987,31283803,31283973,31284108,31284278,3128491', 'assoc_port': '31242832:31242935,31242968:31243224,31243173:31243537,31243656:31244257,31243667:31243907,31243835:31244141,31244368:31244995,31244382:31245037,31244579:31245532,31244666:31245046,31244976:31245600,31245189:31245684,31245246:31245627,31245448:31245801,31245622:31246265,31246014:31246388,31246291:31246628,31246428:31246692,31246607:31246904,31246899:31247106,31247188:31247336,31247417:31247593,31247418:31247483,31247848:31247940,31247991:31248158,31248204:31248345,31248407:31248475,31248665:31248866,31248887:31248951,31249315:31249535,31249316:31249503,31250366:31250422,31250521:31250847,31251342:31251535,31254404:31254937,31254549:31255745,31254852:31255003,31255127:31255302,31255415:31255581,31255742:31255916,31255842:31255953,31256100:31256281,31256388:31256528,31256648:31256864,31260174:31260497,31260532:31260821,31260789:31260982,31261169:31261385,31261218:31261462,31261573:31261860,31261931:31262102,31262347:31262649,31264242:31264405,31264547:31264677,31265361:31265496,31265618:31265781,31265819:3126615', 'assoc_mat': '31242832:metal:4230:31242935,31242968:metal:4230:31243224,31243173:metal:4230:31243537,31243656:metal:4230:31244257,31243667:metal:4230:31243907,31243835:metal:4230:31244141,31244368:metal:4230:31244995,31244382:metal:4230:31245037,31244579:metal:4230:31245532,31244666:metal:4230:31245046,31244976:metal:4230:31245600,31245189:metal:4230:31245684,31245246:metal:4230:31245627,31245448:metal:4230:31245801,31245622:metal:4230:31246265,31246014:metal:4230:31246388,31246291:metal:4230:31246628,31246428:metal:4230:31246692,31246607:metal:4230:31246904,31246899:metal:4230:31247106,31247188:metal:4230:31247336,31247417:metal:4230:31247593,31247418:metal:4230:31247483,31247848:metal:4230:31247940,31247991:metal:4230:31248158,31248204:metal:4230:31248345,31248407:metal:4230:31248475,31248665:metal:4230:31248866,31248887:metal:4230:31248951,31249315:metal:4230:31249535,31249316:metal:4230:31249503,31250366:metal:4230:31250422,31250521:metal:4230:31250847,31251342:metal:4230:31251535,31254404:metal:4230:31254937,31254549:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.378768363122113, 'nb_photo': 320558, 'list_port_cont': '31242944,31243232,31243553,31243920,31244133,31244255,31245003,31245034,31245059,31245543,31245594,31245636,31245686,31245805,31246272,31246378,31246617,31246704,31246919,31247121,31247333,31247484,31247608,31247947,31248159,31248337,31248484,31248860,31248957,31249244,31249501,31249539,31250439,31250857,31250975,31251311,31251351,31251529,31251783,31252386,31252462,31252506,31252756,31252989,31253102,31253388,31253658,31253748,31254046,31254297,31254939,31255015,31255309,31255580,31255759,31255920,31255949,31256276,31256538,31256861,31257029,31257070,31257363,31257676,31257905,31257949,31258179,31258348,31258583,31258745,31259048,31259387,31259423,31259780,31260064,31260498,31260816,31260987,31261393,31261467,31261871,31262110,31262645,31262894,31262966,31263011,31263292,31263564,31263769,31263812,31264132,31264407,31264674,31264921,31265217,31265504,31265791,31266154,31266421,31266880,31266965,31267264,31267306,31267693,31267862,31267941,31268272,31268314,31268625,31268669,31269049,31269172,31269218,3126925', 'assoc_port': '31242832:31242944,31242968:31243232,31243173:31243553,31243656:31244255,31243667:31243920,31243835:31244133,31244368:31245003,31244382:31245034,31244579:31245543,31244666:31245059,31244976:31245594,31245189:31245686,31245246:31245636,31245448:31245805,31245622:31246272,31246014:31246378,31246291:31246617,31246428:31246704,31246607:31246919,31246899:31247121,31247188:31247333,31247417:31247608,31247418:31247484,31247848:31247947,31247991:31248159,31248204:31248337,31248407:31248484,31248665:31248860,31248887:31248957,31249119:31249244,31249315:31249539,31249316:31249501,31250366:31250439,31250521:31250857,31250546:31250975,31251051:31251311,31251094:31251351,31251342:31251529,31251597:31251783,31252021:31252386,31252043:31252462,31252044:31252506,31252539:31252756,31252742:31252989,31253014:31253102,31253289:31253388,31253469:31253658,31253693:31253748,31253871:31254046,31254125:31254297,31254404:31254939,31254549:31255759,31254852:31255015,31255127:31255309,31255415:31255580,31255742:31255920,31255842:3125594', 'assoc_mat': '31242832:papier:4230:31242944,31242968:papier:4230:31243232,31243173:papier:4230:31243553,31243656:papier:4230:31244255,31243667:papier:4230:31243920,31243835:papier:4230:31244133,31244368:papier:4230:31245003,31244382:papier:4230:31245034,31244579:papier:4230:31245543,31244666:papier:4230:31245059,31244976:papier:4230:31245594,31245189:papier:4230:31245686,31245246:papier:4230:31245636,31245448:papier:4230:31245805,31245622:papier:4230:31246272,31246014:papier:4230:31246378,31246291:papier:4230:31246617,31246428:papier:4230:31246704,31246607:papier:4230:31246919,31246899:papier:4230:31247121,31247188:papier:4230:31247333,31247417:papier:4230:31247608,31247418:papier:4230:31247484,31247848:papier:4230:31247947,31247991:papier:4230:31248159,31248204:papier:4230:31248337,31248407:papier:4230:31248484,31248665:papier:4230:31248860,31248887:papier:4230:31248957,31249119:papier:4230:31249244,31249315:papier:4230:31249539,31249316:papier:4230:31249501,31250366:papier:4230:31250439,31250521:papier:4230:31250857,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0092656568232982, 'nb_photo': 7313, 'list_port_cont': '31242949,31243221,31243550,31243915,31244136,31244262,31244997,31245038,31245062,31245547,31245597,31245643,31245677,31245797,31246271,31246387,31246620,31246697,31246913,31247119,31247330,31247481,31247604,31247943,31248153,31248338,31248480,31248867,31248962,31249246,31249498,31249542,31250433,31250853,31250978,31251313,31251365,31251525,31251777,31252382,31252466,31252763,31252984,31253109,31253390,31253664,31253747,31254047,31254291,31254942,31255012,31255316,31255587,31255757,31255918,31255956,31256280,31256543,31256853,31257026,31257073,31257367,31257690,31257898,31257937,31258176,31258338,31258578,31258736,31259050,31259384,31259417,31259789,31260071,31260509,31260817,31260989,31261389,31261466,31261870,31262097,31262658,31262892,31262972,31263008,31263770,31263806,31264133,31264406,31264675,31265218,31265506,31265797,31266150,31266409,31271714,31271875,31271907,31272353,31272514,31272906,31273066,31273573,31273837,31273971,31274042,31274101,31274859,31274965,31275196,31275524,31275827,31276017,3127636', 'assoc_port': '31242832:31242949,31242968:31243221,31243173:31243550,31243656:31244262,31243667:31243915,31243835:31244136,31244368:31244997,31244382:31245038,31244579:31245547,31244666:31245062,31244976:31245597,31245189:31245677,31245246:31245643,31245448:31245797,31245622:31246271,31246014:31246387,31246291:31246620,31246428:31246697,31246607:31246913,31246899:31247119,31247188:31247330,31247417:31247604,31247418:31247481,31247848:31247943,31247991:31248153,31248204:31248338,31248407:31248480,31248665:31248867,31248887:31248962,31249119:31249246,31249315:31249542,31249316:31249498,31250366:31250433,31250521:31250853,31250546:31250978,31251051:31251313,31251094:31251365,31251342:31251525,31251597:31251777,31252021:31252382,31252043:31252466,31252539:31252763,31252742:31252984,31253014:31253109,31253289:31253390,31253469:31253664,31253693:31253747,31253871:31254047,31254125:31254291,31254404:31254942,31254549:31255757,31254852:31255012,31255127:31255316,31255415:31255587,31255742:31255918,31255842:31255956,31256100:3125628', 'assoc_mat': '31242832:pehd:4230:31242949,31242968:pehd:4230:31243221,31243173:pehd:4230:31243550,31243656:pehd:4230:31244262,31243667:pehd:4230:31243915,31243835:pehd:4230:31244136,31244368:pehd:4230:31244997,31244382:pehd:4230:31245038,31244579:pehd:4230:31245547,31244666:pehd:4230:31245062,31244976:pehd:4230:31245597,31245189:pehd:4230:31245677,31245246:pehd:4230:31245643,31245448:pehd:4230:31245797,31245622:pehd:4230:31246271,31246014:pehd:4230:31246387,31246291:pehd:4230:31246620,31246428:pehd:4230:31246697,31246607:pehd:4230:31246913,31246899:pehd:4230:31247119,31247188:pehd:4230:31247330,31247417:pehd:4230:31247604,31247418:pehd:4230:31247481,31247848:pehd:4230:31247943,31247991:pehd:4230:31248153,31248204:pehd:4230:31248338,31248407:pehd:4230:31248480,31248665:pehd:4230:31248867,31248887:pehd:4230:31248962,31249119:pehd:4230:31249246,31249315:pehd:4230:31249542,31249316:pehd:4230:31249498,31250366:pehd:4230:31250433,31250521:pehd:4230:31250853,31250546:pehd:4230:31250978,31251051:pehd:4230:31251313,31251094:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017338679647802575, 'nb_photo': 14261, 'list_port_cont': '31242939,31243229,31243545,31243916,31244135,31244265,31245001,31245042,31245063,31245541,31245599,31245634,31245678,31245806,31246267,31246382,31246624,31246696,31246916,31247114,31247335,31247480,31247605,31247951,31248156,31248342,31248482,31248865,31248958,31249245,31249504,31249541,31250438,31250850,31250974,31251307,31251367,31251534,31251780,31252387,31252464,31252512,31252764,31252988,31253104,31253387,31253660,31253753,31254041,31254300,31254943,31255011,31255313,31255586,31255756,31255912,31255955,31256274,31256545,31256863,31257032,31257060,31257366,31257681,31257902,31257944,31258173,31258346,31258581,31258746,31259043,31259390,31259427,31259782,31260070,31260512,31260824,31260986,31261386,31261475,31261867,31262107,31262656,31262893,31262968,31263019,31263294,31263562,31263766,31263811,31264135,31264403,31264672,31264919,31265216,31265505,31265793,31266152,31266417,31266874,31266963,31267271,31267304,31267688,31267861,31267947,31268271,31268316,31268631,31268665,31269056,31269175,31269212,3126925', 'assoc_port': '31242832:31242939,31242968:31243229,31243173:31243545,31243656:31244265,31243667:31243916,31243835:31244135,31244368:31245001,31244382:31245042,31244579:31245541,31244666:31245063,31244976:31245599,31245189:31245678,31245246:31245634,31245448:31245806,31245622:31246267,31246014:31246382,31246291:31246624,31246428:31246696,31246607:31246916,31246899:31247114,31247188:31247335,31247417:31247605,31247418:31247480,31247848:31247951,31247991:31248156,31248204:31248342,31248407:31248482,31248665:31248865,31248887:31248958,31249119:31249245,31249315:31249541,31249316:31249504,31250366:31250438,31250521:31250850,31250546:31250974,31251051:31251307,31251094:31251367,31251342:31251534,31251597:31251780,31252021:31252387,31252043:31252464,31252044:31252512,31252539:31252764,31252742:31252988,31253014:31253104,31253289:31253387,31253469:31253660,31253693:31253753,31253871:31254041,31254125:31254300,31254404:31254943,31254549:31255756,31254852:31255011,31255127:31255313,31255415:31255586,31255742:31255912,31255842:3125595', 'assoc_mat': '31242832:pet_clair:4230:31242939,31242968:pet_clair:4230:31243229,31243173:pet_clair:4230:31243545,31243656:pet_clair:4230:31244265,31243667:pet_clair:4230:31243916,31243835:pet_clair:4230:31244135,31244368:pet_clair:4230:31245001,31244382:pet_clair:4230:31245042,31244579:pet_clair:4230:31245541,31244666:pet_clair:4230:31245063,31244976:pet_clair:4230:31245599,31245189:pet_clair:4230:31245678,31245246:pet_clair:4230:31245634,31245448:pet_clair:4230:31245806,31245622:pet_clair:4230:31246267,31246014:pet_clair:4230:31246382,31246291:pet_clair:4230:31246624,31246428:pet_clair:4230:31246696,31246607:pet_clair:4230:31246916,31246899:pet_clair:4230:31247114,31247188:pet_clair:4230:31247335,31247417:pet_clair:4230:31247605,31247418:pet_clair:4230:31247480,31247848:pet_clair:4230:31247951,31247991:pet_clair:4230:31248156,31248204:pet_clair:4230:31248342,31248407:pet_clair:4230:31248482,31248665:pet_clair:4230:31248865,31248887:pet_clair:4230:31248958,31249119:pet_clair:4230:31249245,31249315:pet_clair:4230:31249541,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006438531946792458, 'nb_photo': 1527, 'list_port_cont': '31243549,31243914,31244266,31245032,31245056,31245544,31245601,31245631,31245675,31245804,31246264,31246627,31246699,31246917,31247120,31247323,31247486,31247607,31247942,31248154,31248331,31248470,31248864,31248953,31249248,31249491,31249543,31250428,31250854,31251316,31251359,31251528,31255761,31255919,31255958,31256544,31257027,31257685,31257901,31260499,31260823,31261384,31261474,31261876,31262100,31262653,31263298,31264673,31265498,31266149,31266876,31266955,31267260,31267311,31267685,31267851,31267945,31268310,31271873,31271911,31272359,31272896,31273072,31273570,31273843,31273964,31274040,31274104,31274861,31274970,31275195,31275522,31275835,31276021,31276356,31276488,31276776,31276937,31277303,31277495,31277810,31277838,31277974,31278230,31278703,31278759,31279894,31280035,31280412,31281380,31281742,31282235,31282347,31282682,31282986,31283656,31283819,31283983,31284117,31284280,31284404,31284627,31285174,31285904,31286050,31286413,31287017,31287114,31287277,31287710,31287876,31288050,31288135,3128823', 'assoc_port': '31243173:31243549,31243656:31244266,31243667:31243914,31244382:31245032,31244579:31245544,31244666:31245056,31244976:31245601,31245189:31245675,31245246:31245631,31245448:31245804,31245622:31246264,31246291:31246627,31246428:31246699,31246607:31246917,31246899:31247120,31247188:31247323,31247417:31247607,31247418:31247486,31247848:31247942,31247991:31248154,31248204:31248331,31248407:31248470,31248665:31248864,31248887:31248953,31249119:31249248,31249315:31249543,31249316:31249491,31250366:31250428,31250521:31250854,31251051:31251316,31251094:31251359,31251342:31251528,31254549:31255761,31255742:31255919,31255842:31255958,31256388:31256544,31256823:31257027,31257544:31257685,31257803:31257901,31260174:31260499,31260532:31260823,31261169:31261384,31261218:31261474,31261573:31261876,31261931:31262100,31262347:31262653,31263125:31263298,31264547:31264673,31265361:31265498,31265819:31266149,31266525:31266876,31266571:31266955,31267083:31267260,31267084:31267311,31267334:31267685,31267345:31267851,31267621:3126794', 'assoc_mat': '31243173:pet_fonce:4230:31243549,31243656:pet_fonce:4230:31244266,31243667:pet_fonce:4230:31243914,31244382:pet_fonce:4230:31245032,31244579:pet_fonce:4230:31245544,31244666:pet_fonce:4230:31245056,31244976:pet_fonce:4230:31245601,31245189:pet_fonce:4230:31245675,31245246:pet_fonce:4230:31245631,31245448:pet_fonce:4230:31245804,31245622:pet_fonce:4230:31246264,31246291:pet_fonce:4230:31246627,31246428:pet_fonce:4230:31246699,31246607:pet_fonce:4230:31246917,31246899:pet_fonce:4230:31247120,31247188:pet_fonce:4230:31247323,31247417:pet_fonce:4230:31247607,31247418:pet_fonce:4230:31247486,31247848:pet_fonce:4230:31247942,31247991:pet_fonce:4230:31248154,31248204:pet_fonce:4230:31248331,31248407:pet_fonce:4230:31248470,31248665:pet_fonce:4230:31248864,31248887:pet_fonce:4230:31248953,31249119:pet_fonce:4230:31249248,31249315:pet_fonce:4230:31249543,31249316:pet_fonce:4230:31249491,31250366:pet_fonce:4230:31250428,31250521:pet_fonce:4230:31250854,31251051:pet_fonce:4230:31251316,31251094:pet_fonce:4230:31251359,3'}, {'unwanted_material': 'refus', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3680266736220992, 'nb_photo': 146, 'list_port_cont': '31355406', 'assoc_port': '31355140:31355406', 'assoc_mat': '31355140:refus:4230:31355406'}), 'main_stat': {'nb_photos': 1378}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341236,31341237,31341238,31341239,31341240,31341241,31341242,31378959?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce,refus'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.4889558627583436),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1378,),), 'unwanted_material_monthly_percentage': ((0.4889558627583436,),), 'material_repartition': (('incineration', 1378),), 'material_dict': {'incineration': 1378}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 10, 1), 0.4652299222505289, 2), (datetime.date(2026, 10, 2), 0.5634983824614184, 3), (datetime.date(2026, 10, 3), 0.7064769876713316, 3), (datetime.date(2026, 10, 4), 0.6865523296314423, 3), (datetime.date(2026, 10, 5), 0.8271912723505553, 2), (datetime.date(2026, 10, 6), 0.7092184734397243, 3), (datetime.date(2026, 10, 7), 0.47369063982763904, 2), (datetime.date(2026, 10, 8), 0.45525653267325417, 3), (datetime.date(2026, 10, 9), 0.4432410913264354, 1), (datetime.date(2026, 10, 10), 0.4722146537958655, 2), (datetime.date(2026, 10, 11), 0.44271641378241633, 3), (datetime.date(2026, 10, 12), 0.4930524976969901, 2), (datetime.date(2026, 10, 13), 0.44653240141644934, 2), (datetime.date(2026, 10, 14), 0.446820106675175, 2), (datetime.date(2026, 10, 15), 0.42573961179950387, 2), (datetime.date(2026, 10, 16), 0.42630309997266014, 2), (datetime.date(2026, 10, 17), 0.4308652343578406, 1), (datetime.date(2026, 10, 18), 0.4183977859326374, 1), (datetime.date(2026, 10, 19), 0.3846401198673579, 2), (datetime.date(2026, 10, 20), 0.3732661496090892, 3), (datetime.date(2026, 10, 21), 0.37551026112935915, 2), (datetime.date(2026, 10, 22), 0.37430936715892493, 3), (datetime.date(2026, 10, 23), 0.3661131841619704, 2), (datetime.date(2026, 10, 24), 0.4239338854517438, 2), (datetime.date(2026, 10, 25), 0.41189265269103886, 3), (datetime.date(2026, 10, 26), 0.43794817290894855, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 10, 1), 0.4652299222505289, 2), (datetime.date(2026, 10, 2), 0.5634983824614184, 3), (datetime.date(2026, 10, 3), 0.7064769876713316, 3), (datetime.date(2026, 10, 4), 0.6865523296314423, 3), (datetime.date(2026, 10, 5), 0.8271912723505553, 2), (datetime.date(2026, 10, 6), 0.7092184734397243, 3), (datetime.date(2026, 10, 7), 0.47369063982763904, 2), (datetime.date(2026, 10, 8), 0.45525653267325417, 3), (datetime.date(2026, 10, 9), 0.4432410913264354, 1), (datetime.date(2026, 10, 10), 0.4722146537958655, 2), (datetime.date(2026, 10, 11), 0.44271641378241633, 3), (datetime.date(2026, 10, 12), 0.4930524976969901, 2), (datetime.date(2026, 10, 13), 0.44653240141644934, 2), (datetime.date(2026, 10, 14), 0.446820106675175, 2), (datetime.date(2026, 10, 15), 0.42573961179950387, 2), (datetime.date(2026, 10, 16), 0.42630309997266014, 2), (datetime.date(2026, 10, 17), 0.4308652343578406, 1), (datetime.date(2026, 10, 18), 0.4183977859326374, 1), (datetime.date(2026, 10, 19), 0.3846401198673579, 2), (datetime.date(2026, 10, 20), 0.3732661496090892, 3), (datetime.date(2026, 10, 21), 0.37551026112935915, 2), (datetime.date(2026, 10, 22), 0.37430936715892493, 3), (datetime.date(2026, 10, 23), 0.3661131841619704, 2), (datetime.date(2026, 10, 24), 0.4239338854517438, 2), (datetime.date(2026, 10, 25), 0.41189265269103886, 3), (datetime.date(2026, 10, 26), 0.43794817290894855, 3))}, 'quality_array': [['-9.114763677368375', '01102026'], ['-7.642592881239511', '02102026'], ['-5.915254856608112', '03102026'], ['-6.1847886364587135', '04102026'], ['-5.116621655467581', '05102026'], ['-7.014046993257052', '06102026'], ['-9.217851850614043', '07102026'], ['-8.669071591071171', '08102026'], ['-8.82547940010849', '09102026'], ['-9.039526671355313', '10102026'], ['-9.079387687550295', '11102026'], ['-9.326304263953782', '12102026'], ['-9.435571628896428', '13102026'], ['-8.678716695453211', '14102026'], ['-8.937341817034099', '15102026'], ['-8.919599446807169', '16102026'], ['-7.8038022868050385', '17102026'], ['-8.156532762067714', '18102026'], ['-9.020686544214437', '19102026'], ['-8.928218578782275', '20102026'], ['-8.852875246564455', '21102026'], ['-8.864156633029786', '22102026'], ['-9.077843389212358', '23102026'], ['-9.058955642117974', '24102026'], ['-9.025044974060776', '25102026'], ['-8.94714323389459', '26102026']], 'number_of_batch': ((553,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.023767043101033464, 'nb_photo': 19045, 'list_port_cont': '31242946,31243223,31243546,31243921,31244140,31244252,31244996,31245040,31245049,31245542,31245587,31245639,31245685,31245798,31246268,31246386,31246614,31246702,31246905,31247111,31247331,31247488,31247600,31247941,31248148,31248343,31248479,31248858,31248960,31249239,31249505,31249544,31250432,31250846,31250961,31251301,31251354,31251519,31251772,31252376,31252463,31252507,31252750,31252993,31253111,31253382,31253663,31253755,31254037,31254292,31254946,31255010,31255307,31255571,31255755,31255913,31255947,31256279,31256529,31256862,31257024,31257074,31257354,31257682,31257897,31257950,31258168,31258342,31258573,31258734,31259040,31259378,31259415,31259774,31260075,31260511,31260819,31260979,31261377,31261472,31261862,31262101,31262643,31262898,31262958,31263015,31263289,31263571,31263772,31263808,31264123,31264410,31264671,31264917,31265220,31265489,31265782,31266138,31266412,31266867,31266957,31267257,31267307,31267683,31267859,31267935,31268265,31268312,31268632,31268666,31269041,31269207,31269242,3126976', 'assoc_port': '31242832:31242946,31242968:31243223,31243173:31243546,31243656:31244252,31243667:31243921,31243835:31244140,31244368:31244996,31244382:31245040,31244579:31245542,31244666:31245049,31244976:31245587,31245189:31245685,31245246:31245639,31245448:31245798,31245622:31246268,31246014:31246386,31246291:31246614,31246428:31246702,31246607:31246905,31246899:31247111,31247188:31247331,31247417:31247600,31247418:31247488,31247848:31247941,31247991:31248148,31248204:31248343,31248407:31248479,31248665:31248858,31248887:31248960,31249119:31249239,31249315:31249544,31249316:31249505,31250366:31250432,31250521:31250846,31250546:31250961,31251051:31251301,31251094:31251354,31251342:31251519,31251597:31251772,31252021:31252376,31252043:31252463,31252044:31252507,31252539:31252750,31252742:31252993,31253014:31253111,31253289:31253382,31253469:31253663,31253693:31253755,31253871:31254037,31254125:31254292,31254404:31254946,31254549:31255755,31254852:31255010,31255127:31255307,31255415:31255571,31255742:31255913,31255842:3125594', 'assoc_mat': '31242832:autre:4230:31242946,31242968:autre:4230:31243223,31243173:autre:4230:31243546,31243656:autre:4230:31244252,31243667:autre:4230:31243921,31243835:autre:4230:31244140,31244368:autre:4230:31244996,31244382:autre:4230:31245040,31244579:autre:4230:31245542,31244666:autre:4230:31245049,31244976:autre:4230:31245587,31245189:autre:4230:31245685,31245246:autre:4230:31245639,31245448:autre:4230:31245798,31245622:autre:4230:31246268,31246014:autre:4230:31246386,31246291:autre:4230:31246614,31246428:autre:4230:31246702,31246607:autre:4230:31246905,31246899:autre:4230:31247111,31247188:autre:4230:31247331,31247417:autre:4230:31247600,31247418:autre:4230:31247488,31247848:autre:4230:31247941,31247991:autre:4230:31248148,31248204:autre:4230:31248343,31248407:autre:4230:31248479,31248665:autre:4230:31248858,31248887:autre:4230:31248960,31249119:autre:4230:31249239,31249315:autre:4230:31249544,31249316:autre:4230:31249505,31250366:autre:4230:31250432,31250521:autre:4230:31250846,31250546:autre:4230:31250961,31251051:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.13010374542499828, 'nb_photo': 133458, 'list_port_cont': '31242943,31243222,31243554,31243909,31244138,31244259,31244999,31245035,31245054,31245539,31245596,31245642,31245681,31245807,31246269,31246381,31246623,31246698,31246912,31247122,31247334,31247487,31247602,31247948,31248157,31248335,31248485,31248861,31248952,31249236,31249495,31249534,31250437,31250856,31250967,31251314,31251357,31251533,31251782,31252390,31252459,31252517,31252765,31252994,31253112,31253384,31253659,31253757,31254036,31254290,31254938,31255019,31255312,31255582,31255758,31255908,31255957,31256277,31256541,31256860,31257034,31257072,31257365,31257688,31257908,31257951,31258183,31258349,31258572,31258749,31259041,31259389,31259419,31259779,31260069,31260506,31260822,31260992,31261391,31261461,31261875,31262108,31262652,31262889,31262965,31263017,31263291,31263567,31263775,31263804,31264137,31264402,31264678,31264920,31265212,31265494,31265796,31266151,31266418,31266878,31266959,31267270,31267308,31267694,31267855,31267948,31268269,31268315,31268628,31268663,31269043,31269182,31269215,3126925', 'assoc_port': '31242832:31242943,31242968:31243222,31243173:31243554,31243656:31244259,31243667:31243909,31243835:31244138,31244368:31244999,31244382:31245035,31244579:31245539,31244666:31245054,31244976:31245596,31245189:31245681,31245246:31245642,31245448:31245807,31245622:31246269,31246014:31246381,31246291:31246623,31246428:31246698,31246607:31246912,31246899:31247122,31247188:31247334,31247417:31247602,31247418:31247487,31247848:31247948,31247991:31248157,31248204:31248335,31248407:31248485,31248665:31248861,31248887:31248952,31249119:31249236,31249315:31249534,31249316:31249495,31250366:31250437,31250521:31250856,31250546:31250967,31251051:31251314,31251094:31251357,31251342:31251533,31251597:31251782,31252021:31252390,31252043:31252459,31252044:31252517,31252539:31252765,31252742:31252994,31253014:31253112,31253289:31253384,31253469:31253659,31253693:31253757,31253871:31254036,31254125:31254290,31254404:31254938,31254549:31255758,31254852:31255019,31255127:31255312,31255415:31255582,31255742:31255908,31255842:3125595', 'assoc_mat': '31242832:carton:4230:31242943,31242968:carton:4230:31243222,31243173:carton:4230:31243554,31243656:carton:4230:31244259,31243667:carton:4230:31243909,31243835:carton:4230:31244138,31244368:carton:4230:31244999,31244382:carton:4230:31245035,31244579:carton:4230:31245539,31244666:carton:4230:31245054,31244976:carton:4230:31245596,31245189:carton:4230:31245681,31245246:carton:4230:31245642,31245448:carton:4230:31245807,31245622:carton:4230:31246269,31246014:carton:4230:31246381,31246291:carton:4230:31246623,31246428:carton:4230:31246698,31246607:carton:4230:31246912,31246899:carton:4230:31247122,31247188:carton:4230:31247334,31247417:carton:4230:31247602,31247418:carton:4230:31247487,31247848:carton:4230:31247948,31247991:carton:4230:31248157,31248204:carton:4230:31248335,31248407:carton:4230:31248485,31248665:carton:4230:31248861,31248887:carton:4230:31248952,31249119:carton:4230:31249236,31249315:carton:4230:31249534,31249316:carton:4230:31249495,31250366:carton:4230:31250437,31250521:carton:4230:31250856,3125'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001769906429229689, 'nb_photo': 1649, 'list_port_cont': '31242935,31243224,31243537,31243907,31244141,31244257,31244995,31245037,31245046,31245532,31245600,31245627,31245684,31245801,31246265,31246388,31246628,31246692,31246904,31247106,31247336,31247483,31247593,31247940,31248158,31248345,31248475,31248866,31248951,31249503,31249535,31250422,31250847,31251535,31254937,31255003,31255302,31255581,31255745,31255916,31255953,31256281,31256528,31256864,31260497,31260821,31260982,31261385,31261462,31261860,31262102,31262649,31264405,31264677,31265496,31265781,31266153,31266414,31266866,31266956,31267266,31267295,31267682,31268258,31268306,31268671,31269168,31269214,31270743,31271700,31271864,31271901,31272358,31272517,31272901,31273070,31273568,31273963,31274044,31274093,31274854,31274972,31275184,31275514,31275826,31276020,31276366,31276483,31276777,31276927,31277306,31277483,31277795,31277850,31277977,31278214,31278690,31278745,31279888,31280028,31280422,31280961,31281010,31281371,31281736,31282233,31282342,31282670,31282987,31283803,31283973,31284108,31284278,3128491', 'assoc_port': '31242832:31242935,31242968:31243224,31243173:31243537,31243656:31244257,31243667:31243907,31243835:31244141,31244368:31244995,31244382:31245037,31244579:31245532,31244666:31245046,31244976:31245600,31245189:31245684,31245246:31245627,31245448:31245801,31245622:31246265,31246014:31246388,31246291:31246628,31246428:31246692,31246607:31246904,31246899:31247106,31247188:31247336,31247417:31247593,31247418:31247483,31247848:31247940,31247991:31248158,31248204:31248345,31248407:31248475,31248665:31248866,31248887:31248951,31249315:31249535,31249316:31249503,31250366:31250422,31250521:31250847,31251342:31251535,31254404:31254937,31254549:31255745,31254852:31255003,31255127:31255302,31255415:31255581,31255742:31255916,31255842:31255953,31256100:31256281,31256388:31256528,31256648:31256864,31260174:31260497,31260532:31260821,31260789:31260982,31261169:31261385,31261218:31261462,31261573:31261860,31261931:31262102,31262347:31262649,31264242:31264405,31264547:31264677,31265361:31265496,31265618:31265781,31265819:3126615', 'assoc_mat': '31242832:metal:4230:31242935,31242968:metal:4230:31243224,31243173:metal:4230:31243537,31243656:metal:4230:31244257,31243667:metal:4230:31243907,31243835:metal:4230:31244141,31244368:metal:4230:31244995,31244382:metal:4230:31245037,31244579:metal:4230:31245532,31244666:metal:4230:31245046,31244976:metal:4230:31245600,31245189:metal:4230:31245684,31245246:metal:4230:31245627,31245448:metal:4230:31245801,31245622:metal:4230:31246265,31246014:metal:4230:31246388,31246291:metal:4230:31246628,31246428:metal:4230:31246692,31246607:metal:4230:31246904,31246899:metal:4230:31247106,31247188:metal:4230:31247336,31247417:metal:4230:31247593,31247418:metal:4230:31247483,31247848:metal:4230:31247940,31247991:metal:4230:31248158,31248204:metal:4230:31248345,31248407:metal:4230:31248475,31248665:metal:4230:31248866,31248887:metal:4230:31248951,31249315:metal:4230:31249535,31249316:metal:4230:31249503,31250366:metal:4230:31250422,31250521:metal:4230:31250847,31251342:metal:4230:31251535,31254404:metal:4230:31254937,31254549:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.378768363122113, 'nb_photo': 320558, 'list_port_cont': '31242944,31243232,31243553,31243920,31244133,31244255,31245003,31245034,31245059,31245543,31245594,31245636,31245686,31245805,31246272,31246378,31246617,31246704,31246919,31247121,31247333,31247484,31247608,31247947,31248159,31248337,31248484,31248860,31248957,31249244,31249501,31249539,31250439,31250857,31250975,31251311,31251351,31251529,31251783,31252386,31252462,31252506,31252756,31252989,31253102,31253388,31253658,31253748,31254046,31254297,31254939,31255015,31255309,31255580,31255759,31255920,31255949,31256276,31256538,31256861,31257029,31257070,31257363,31257676,31257905,31257949,31258179,31258348,31258583,31258745,31259048,31259387,31259423,31259780,31260064,31260498,31260816,31260987,31261393,31261467,31261871,31262110,31262645,31262894,31262966,31263011,31263292,31263564,31263769,31263812,31264132,31264407,31264674,31264921,31265217,31265504,31265791,31266154,31266421,31266880,31266965,31267264,31267306,31267693,31267862,31267941,31268272,31268314,31268625,31268669,31269049,31269172,31269218,3126925', 'assoc_port': '31242832:31242944,31242968:31243232,31243173:31243553,31243656:31244255,31243667:31243920,31243835:31244133,31244368:31245003,31244382:31245034,31244579:31245543,31244666:31245059,31244976:31245594,31245189:31245686,31245246:31245636,31245448:31245805,31245622:31246272,31246014:31246378,31246291:31246617,31246428:31246704,31246607:31246919,31246899:31247121,31247188:31247333,31247417:31247608,31247418:31247484,31247848:31247947,31247991:31248159,31248204:31248337,31248407:31248484,31248665:31248860,31248887:31248957,31249119:31249244,31249315:31249539,31249316:31249501,31250366:31250439,31250521:31250857,31250546:31250975,31251051:31251311,31251094:31251351,31251342:31251529,31251597:31251783,31252021:31252386,31252043:31252462,31252044:31252506,31252539:31252756,31252742:31252989,31253014:31253102,31253289:31253388,31253469:31253658,31253693:31253748,31253871:31254046,31254125:31254297,31254404:31254939,31254549:31255759,31254852:31255015,31255127:31255309,31255415:31255580,31255742:31255920,31255842:3125594', 'assoc_mat': '31242832:papier:4230:31242944,31242968:papier:4230:31243232,31243173:papier:4230:31243553,31243656:papier:4230:31244255,31243667:papier:4230:31243920,31243835:papier:4230:31244133,31244368:papier:4230:31245003,31244382:papier:4230:31245034,31244579:papier:4230:31245543,31244666:papier:4230:31245059,31244976:papier:4230:31245594,31245189:papier:4230:31245686,31245246:papier:4230:31245636,31245448:papier:4230:31245805,31245622:papier:4230:31246272,31246014:papier:4230:31246378,31246291:papier:4230:31246617,31246428:papier:4230:31246704,31246607:papier:4230:31246919,31246899:papier:4230:31247121,31247188:papier:4230:31247333,31247417:papier:4230:31247608,31247418:papier:4230:31247484,31247848:papier:4230:31247947,31247991:papier:4230:31248159,31248204:papier:4230:31248337,31248407:papier:4230:31248484,31248665:papier:4230:31248860,31248887:papier:4230:31248957,31249119:papier:4230:31249244,31249315:papier:4230:31249539,31249316:papier:4230:31249501,31250366:papier:4230:31250439,31250521:papier:4230:31250857,3125'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0092656568232982, 'nb_photo': 7313, 'list_port_cont': '31242949,31243221,31243550,31243915,31244136,31244262,31244997,31245038,31245062,31245547,31245597,31245643,31245677,31245797,31246271,31246387,31246620,31246697,31246913,31247119,31247330,31247481,31247604,31247943,31248153,31248338,31248480,31248867,31248962,31249246,31249498,31249542,31250433,31250853,31250978,31251313,31251365,31251525,31251777,31252382,31252466,31252763,31252984,31253109,31253390,31253664,31253747,31254047,31254291,31254942,31255012,31255316,31255587,31255757,31255918,31255956,31256280,31256543,31256853,31257026,31257073,31257367,31257690,31257898,31257937,31258176,31258338,31258578,31258736,31259050,31259384,31259417,31259789,31260071,31260509,31260817,31260989,31261389,31261466,31261870,31262097,31262658,31262892,31262972,31263008,31263770,31263806,31264133,31264406,31264675,31265218,31265506,31265797,31266150,31266409,31271714,31271875,31271907,31272353,31272514,31272906,31273066,31273573,31273837,31273971,31274042,31274101,31274859,31274965,31275196,31275524,31275827,31276017,3127636', 'assoc_port': '31242832:31242949,31242968:31243221,31243173:31243550,31243656:31244262,31243667:31243915,31243835:31244136,31244368:31244997,31244382:31245038,31244579:31245547,31244666:31245062,31244976:31245597,31245189:31245677,31245246:31245643,31245448:31245797,31245622:31246271,31246014:31246387,31246291:31246620,31246428:31246697,31246607:31246913,31246899:31247119,31247188:31247330,31247417:31247604,31247418:31247481,31247848:31247943,31247991:31248153,31248204:31248338,31248407:31248480,31248665:31248867,31248887:31248962,31249119:31249246,31249315:31249542,31249316:31249498,31250366:31250433,31250521:31250853,31250546:31250978,31251051:31251313,31251094:31251365,31251342:31251525,31251597:31251777,31252021:31252382,31252043:31252466,31252539:31252763,31252742:31252984,31253014:31253109,31253289:31253390,31253469:31253664,31253693:31253747,31253871:31254047,31254125:31254291,31254404:31254942,31254549:31255757,31254852:31255012,31255127:31255316,31255415:31255587,31255742:31255918,31255842:31255956,31256100:3125628', 'assoc_mat': '31242832:pehd:4230:31242949,31242968:pehd:4230:31243221,31243173:pehd:4230:31243550,31243656:pehd:4230:31244262,31243667:pehd:4230:31243915,31243835:pehd:4230:31244136,31244368:pehd:4230:31244997,31244382:pehd:4230:31245038,31244579:pehd:4230:31245547,31244666:pehd:4230:31245062,31244976:pehd:4230:31245597,31245189:pehd:4230:31245677,31245246:pehd:4230:31245643,31245448:pehd:4230:31245797,31245622:pehd:4230:31246271,31246014:pehd:4230:31246387,31246291:pehd:4230:31246620,31246428:pehd:4230:31246697,31246607:pehd:4230:31246913,31246899:pehd:4230:31247119,31247188:pehd:4230:31247330,31247417:pehd:4230:31247604,31247418:pehd:4230:31247481,31247848:pehd:4230:31247943,31247991:pehd:4230:31248153,31248204:pehd:4230:31248338,31248407:pehd:4230:31248480,31248665:pehd:4230:31248867,31248887:pehd:4230:31248962,31249119:pehd:4230:31249246,31249315:pehd:4230:31249542,31249316:pehd:4230:31249498,31250366:pehd:4230:31250433,31250521:pehd:4230:31250853,31250546:pehd:4230:31250978,31251051:pehd:4230:31251313,31251094:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017338679647802575, 'nb_photo': 14261, 'list_port_cont': '31242939,31243229,31243545,31243916,31244135,31244265,31245001,31245042,31245063,31245541,31245599,31245634,31245678,31245806,31246267,31246382,31246624,31246696,31246916,31247114,31247335,31247480,31247605,31247951,31248156,31248342,31248482,31248865,31248958,31249245,31249504,31249541,31250438,31250850,31250974,31251307,31251367,31251534,31251780,31252387,31252464,31252512,31252764,31252988,31253104,31253387,31253660,31253753,31254041,31254300,31254943,31255011,31255313,31255586,31255756,31255912,31255955,31256274,31256545,31256863,31257032,31257060,31257366,31257681,31257902,31257944,31258173,31258346,31258581,31258746,31259043,31259390,31259427,31259782,31260070,31260512,31260824,31260986,31261386,31261475,31261867,31262107,31262656,31262893,31262968,31263019,31263294,31263562,31263766,31263811,31264135,31264403,31264672,31264919,31265216,31265505,31265793,31266152,31266417,31266874,31266963,31267271,31267304,31267688,31267861,31267947,31268271,31268316,31268631,31268665,31269056,31269175,31269212,3126925', 'assoc_port': '31242832:31242939,31242968:31243229,31243173:31243545,31243656:31244265,31243667:31243916,31243835:31244135,31244368:31245001,31244382:31245042,31244579:31245541,31244666:31245063,31244976:31245599,31245189:31245678,31245246:31245634,31245448:31245806,31245622:31246267,31246014:31246382,31246291:31246624,31246428:31246696,31246607:31246916,31246899:31247114,31247188:31247335,31247417:31247605,31247418:31247480,31247848:31247951,31247991:31248156,31248204:31248342,31248407:31248482,31248665:31248865,31248887:31248958,31249119:31249245,31249315:31249541,31249316:31249504,31250366:31250438,31250521:31250850,31250546:31250974,31251051:31251307,31251094:31251367,31251342:31251534,31251597:31251780,31252021:31252387,31252043:31252464,31252044:31252512,31252539:31252764,31252742:31252988,31253014:31253104,31253289:31253387,31253469:31253660,31253693:31253753,31253871:31254041,31254125:31254300,31254404:31254943,31254549:31255756,31254852:31255011,31255127:31255313,31255415:31255586,31255742:31255912,31255842:3125595', 'assoc_mat': '31242832:pet_clair:4230:31242939,31242968:pet_clair:4230:31243229,31243173:pet_clair:4230:31243545,31243656:pet_clair:4230:31244265,31243667:pet_clair:4230:31243916,31243835:pet_clair:4230:31244135,31244368:pet_clair:4230:31245001,31244382:pet_clair:4230:31245042,31244579:pet_clair:4230:31245541,31244666:pet_clair:4230:31245063,31244976:pet_clair:4230:31245599,31245189:pet_clair:4230:31245678,31245246:pet_clair:4230:31245634,31245448:pet_clair:4230:31245806,31245622:pet_clair:4230:31246267,31246014:pet_clair:4230:31246382,31246291:pet_clair:4230:31246624,31246428:pet_clair:4230:31246696,31246607:pet_clair:4230:31246916,31246899:pet_clair:4230:31247114,31247188:pet_clair:4230:31247335,31247417:pet_clair:4230:31247605,31247418:pet_clair:4230:31247480,31247848:pet_clair:4230:31247951,31247991:pet_clair:4230:31248156,31248204:pet_clair:4230:31248342,31248407:pet_clair:4230:31248482,31248665:pet_clair:4230:31248865,31248887:pet_clair:4230:31248958,31249119:pet_clair:4230:31249245,31249315:pet_clair:4230:31249541,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006438531946792458, 'nb_photo': 1527, 'list_port_cont': '31243549,31243914,31244266,31245032,31245056,31245544,31245601,31245631,31245675,31245804,31246264,31246627,31246699,31246917,31247120,31247323,31247486,31247607,31247942,31248154,31248331,31248470,31248864,31248953,31249248,31249491,31249543,31250428,31250854,31251316,31251359,31251528,31255761,31255919,31255958,31256544,31257027,31257685,31257901,31260499,31260823,31261384,31261474,31261876,31262100,31262653,31263298,31264673,31265498,31266149,31266876,31266955,31267260,31267311,31267685,31267851,31267945,31268310,31271873,31271911,31272359,31272896,31273072,31273570,31273843,31273964,31274040,31274104,31274861,31274970,31275195,31275522,31275835,31276021,31276356,31276488,31276776,31276937,31277303,31277495,31277810,31277838,31277974,31278230,31278703,31278759,31279894,31280035,31280412,31281380,31281742,31282235,31282347,31282682,31282986,31283656,31283819,31283983,31284117,31284280,31284404,31284627,31285174,31285904,31286050,31286413,31287017,31287114,31287277,31287710,31287876,31288050,31288135,3128823', 'assoc_port': '31243173:31243549,31243656:31244266,31243667:31243914,31244382:31245032,31244579:31245544,31244666:31245056,31244976:31245601,31245189:31245675,31245246:31245631,31245448:31245804,31245622:31246264,31246291:31246627,31246428:31246699,31246607:31246917,31246899:31247120,31247188:31247323,31247417:31247607,31247418:31247486,31247848:31247942,31247991:31248154,31248204:31248331,31248407:31248470,31248665:31248864,31248887:31248953,31249119:31249248,31249315:31249543,31249316:31249491,31250366:31250428,31250521:31250854,31251051:31251316,31251094:31251359,31251342:31251528,31254549:31255761,31255742:31255919,31255842:31255958,31256388:31256544,31256823:31257027,31257544:31257685,31257803:31257901,31260174:31260499,31260532:31260823,31261169:31261384,31261218:31261474,31261573:31261876,31261931:31262100,31262347:31262653,31263125:31263298,31264547:31264673,31265361:31265498,31265819:31266149,31266525:31266876,31266571:31266955,31267083:31267260,31267084:31267311,31267334:31267685,31267345:31267851,31267621:3126794', 'assoc_mat': '31243173:pet_fonce:4230:31243549,31243656:pet_fonce:4230:31244266,31243667:pet_fonce:4230:31243914,31244382:pet_fonce:4230:31245032,31244579:pet_fonce:4230:31245544,31244666:pet_fonce:4230:31245056,31244976:pet_fonce:4230:31245601,31245189:pet_fonce:4230:31245675,31245246:pet_fonce:4230:31245631,31245448:pet_fonce:4230:31245804,31245622:pet_fonce:4230:31246264,31246291:pet_fonce:4230:31246627,31246428:pet_fonce:4230:31246699,31246607:pet_fonce:4230:31246917,31246899:pet_fonce:4230:31247120,31247188:pet_fonce:4230:31247323,31247417:pet_fonce:4230:31247607,31247418:pet_fonce:4230:31247486,31247848:pet_fonce:4230:31247942,31247991:pet_fonce:4230:31248154,31248204:pet_fonce:4230:31248331,31248407:pet_fonce:4230:31248470,31248665:pet_fonce:4230:31248864,31248887:pet_fonce:4230:31248953,31249119:pet_fonce:4230:31249248,31249315:pet_fonce:4230:31249543,31249316:pet_fonce:4230:31249491,31250366:pet_fonce:4230:31250428,31250521:pet_fonce:4230:31250854,31251051:pet_fonce:4230:31251316,31251094:pet_fonce:4230:31251359,3'}, {'unwanted_material': 'refus', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3680266736220992, 'nb_photo': 146, 'list_port_cont': '31355406', 'assoc_port': '31355140:31355406', 'assoc_mat': '31355140:refus:4230:31355406'}), 'main_stat': {'nb_photos': 1378}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31341236,31341237,31341238,31341239,31341240,31341241,31341242,31378959?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce,refus'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-10', 0.4889558627583436),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_10_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.38%', 19045], 'carton': ['carton', '13.01%', 133458], 'metal': ['metal', '0.18%', 1649], 'papier': ['papier', '37.88%', 320558], 'pehd': ['pehd', '0.93%', 7313], 'pet_clair': ['pet_clair', '1.73%', 14261], 'pet_fonce': ['pet_fonce', '0.64%', 1527], 'refus': ['refus', '36.8%', 146]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_10_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.43user 2.91system 0:06.67elapsed 80%CPU (0avgtext+0avgdata 184024maxresident)k 16inputs+304outputs (49major+49398minor)pagefaults 0swaps