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-07 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 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 : (2, 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 : 07 mtr_id : dashboard_places : SCCU_cam8 date : 2026-07 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-07%') and created_at like '%2026-07%'))); nb_day : (2, 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) = 07 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) = 07 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 '%072026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-07-01 : dt_date_just_month_year : 2026-07-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-07-01" AND ded.date <= "2026-07-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 (3006642,3006916,3007506,3008144,3008436,3009172,3009768,3010250,3010786,3011392,3011974,3012278,3012852,3013526,3014192,3014848,3015404,3015956,3016428,3017018,3017648,3018324,3019076,3019978,3020768,3021274,3021548,3022222,3022930,3023650,3024336) 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.013650217983355228, 'nb_photo': 13319, 'list_port_cont': '31201051,31201237,31201319,31201391,31201529,31201607,31201792,31201911,31201980,31203110,31203261,31203305,31203371,31203413,31204322,31204384,31204471,31205665,31205709,31205748,31205789,31205826,31205867,31205897,31205961,31206006,31206057,31206089,31206135,31206178,31206227,31206255,31206306,31206348,31206393,31206448,31206496,31206526,31206575,31211867,31211913,31211973,31212007,31212259,31212311,31212353,31212420,31212452,31212487,31212545,31212591,31212649,31212689,31213026,31213226,31213370,31213451,31214559,31214598,31214707,31214794,31214846,31215384,31215421,31215476,31215905,31216082,31216108,31216661,31216894,31216925,31217641,31217805,31217866,31218369,31218621,31218920,31219207,31219343,31219959,31219991,31220277,31220584,31220830,31221076,31221345,31221573,31221866,31222087,31222397,31222566,31222661,31223020,31223291,31223551,31223815,31224057,31224282,31224321,31224963,31225213,31225501,31225996,31226145,31226305,31226750,31226782,31227141,31227631,31227734,31228056,31228274,31228778,3122903', 'assoc_port': '31200282:31201051,31200285:31203305,31200288:31201237,31200290:31201319,31200293:31201391,31200295:31201529,31200298:31201607,31200300:31204322,31200302:31201792,31200304:31201911,31200306:31201980,31200435:31203110,31200918:31203261,31201389:31203371,31201853:31203413,31202289:31204384,31202757:31204471,31203005:31205665,31203006:31205709,31203007:31205748,31203008:31205789,31203009:31205826,31203011:31206135,31203012:31205867,31203013:31205897,31203014:31205961,31203015:31206006,31203016:31206057,31203017:31206089,31203018:31206178,31203019:31206227,31203020:31206255,31203021:31206306,31203022:31206348,31203023:31206393,31203024:31206448,31203025:31206496,31203026:31206526,31203027:31206575,31205934:31211867,31206481:31211913,31207020:31211973,31207501:31212007,31207815:31212259,31207817:31212311,31207818:31212353,31207819:31212420,31207820:31212452,31207821:31212487,31207963:31212545,31208466:31212591,31209020:31212649,31209540:31212689,31210076:31213026,31210574:31213226,31211134:31213370,31211680:3121345', 'assoc_mat': '31200282:autre:4230:31201051,31200285:autre:4230:31203305,31200288:autre:4230:31201237,31200290:autre:4230:31201319,31200293:autre:4230:31201391,31200295:autre:4230:31201529,31200298:autre:4230:31201607,31200300:autre:4230:31204322,31200302:autre:4230:31201792,31200304:autre:4230:31201911,31200306:autre:4230:31201980,31200435:autre:4230:31203110,31200918:autre:4230:31203261,31201389:autre:4230:31203371,31201853:autre:4230:31203413,31202289:autre:4230:31204384,31202757:autre:4230:31204471,31203005:autre:4230:31205665,31203006:autre:4230:31205709,31203007:autre:4230:31205748,31203008:autre:4230:31205789,31203009:autre:4230:31205826,31203011:autre:4230:31206135,31203012:autre:4230:31205867,31203013:autre:4230:31205897,31203014:autre:4230:31205961,31203015:autre:4230:31206006,31203016:autre:4230:31206057,31203017:autre:4230:31206089,31203018:autre:4230:31206178,31203019:autre:4230:31206227,31203020:autre:4230:31206255,31203021:autre:4230:31206306,31203022:autre:4230:31206348,31203023:autre:4230:31206393,31203024:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03948303942476122, 'nb_photo': 59482, 'list_port_cont': '31201060,31201232,31201323,31201408,31201537,31201622,31201784,31201915,31201992,31203114,31203256,31203302,31203382,31203418,31204325,31204392,31204474,31205661,31205710,31205741,31205785,31205825,31205870,31205910,31205950,31206001,31206047,31206097,31206139,31206189,31206225,31206269,31206311,31206357,31206402,31206453,31206497,31206541,31206591,31211866,31211917,31211959,31212015,31212272,31212325,31212358,31212413,31212454,31212498,31212546,31212589,31212653,31212683,31213020,31213223,31213386,31213466,31214561,31214599,31214709,31214804,31214859,31215390,31215428,31215478,31215906,31216070,31216116,31216646,31216896,31216936,31217635,31217815,31217876,31218370,31218622,31218932,31219215,31219350,31219966,31220000,31220272,31220595,31220824,31221085,31221354,31221577,31221862,31222088,31222393,31222579,31222659,31223033,31223288,31223557,31223830,31224059,31224279,31224323,31224960,31225217,31225496,31226003,31226142,31226322,31226748,31226793,31227155,31227630,31227731,31228057,31228270,31228790,3122904', 'assoc_port': '31200282:31201060,31200285:31203302,31200288:31201232,31200290:31201323,31200293:31201408,31200295:31201537,31200298:31201622,31200300:31204325,31200302:31201784,31200304:31201915,31200306:31201992,31200435:31203114,31200918:31203256,31201389:31203382,31201853:31203418,31202289:31204392,31202757:31204474,31203005:31205661,31203006:31205710,31203007:31205741,31203008:31205785,31203009:31205825,31203011:31206139,31203012:31205870,31203013:31205910,31203014:31205950,31203015:31206001,31203016:31206047,31203017:31206097,31203018:31206189,31203019:31206225,31203020:31206269,31203021:31206311,31203022:31206357,31203023:31206402,31203024:31206453,31203025:31206497,31203026:31206541,31203027:31206591,31205934:31211866,31206481:31211917,31207020:31211959,31207501:31212015,31207815:31212272,31207817:31212325,31207818:31212358,31207819:31212413,31207820:31212454,31207821:31212498,31207963:31212546,31208466:31212589,31209020:31212653,31209540:31212683,31210076:31213020,31210574:31213223,31211134:31213386,31211680:3121346', 'assoc_mat': '31200282:carton:4230:31201060,31200285:carton:4230:31203302,31200288:carton:4230:31201232,31200290:carton:4230:31201323,31200293:carton:4230:31201408,31200295:carton:4230:31201537,31200298:carton:4230:31201622,31200300:carton:4230:31204325,31200302:carton:4230:31201784,31200304:carton:4230:31201915,31200306:carton:4230:31201992,31200435:carton:4230:31203114,31200918:carton:4230:31203256,31201389:carton:4230:31203382,31201853:carton:4230:31203418,31202289:carton:4230:31204392,31202757:carton:4230:31204474,31203005:carton:4230:31205661,31203006:carton:4230:31205710,31203007:carton:4230:31205741,31203008:carton:4230:31205785,31203009:carton:4230:31205825,31203011:carton:4230:31206139,31203012:carton:4230:31205870,31203013:carton:4230:31205910,31203014:carton:4230:31205950,31203015:carton:4230:31206001,31203016:carton:4230:31206047,31203017:carton:4230:31206097,31203018:carton:4230:31206189,31203019:carton:4230:31206225,31203020:carton:4230:31206269,31203021:carton:4230:31206311,31203022:carton:4230:31206357,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010529250396589607, 'nb_photo': 1061, 'list_port_cont': '31201053,31201307,31201781,31201985,31203379,31205695,31205902,31205946,31206042,31206399,31206449,31212008,31212324,31212359,31212441,31212501,31212544,31212588,31212645,31213012,31213219,31213450,31214546,31214796,31214860,31215392,31215475,31216888,31216929,31217632,31217802,31217868,31218360,31218618,31218926,31219220,31219341,31219961,31219996,31220261,31220594,31220832,31221576,31221864,31222082,31222386,31222570,31222660,31223021,31223293,31223558,31223817,31224058,31224285,31224322,31225497,31226753,31226783,31227150,31227642,31228272,31228795,31229047,31229407,31229457,31229793,31230236,31230512,31231028,31231631,31233043,31235458,31235892,31235940,31236194,31236477,31236726,31236957,31237931,31238697,31239622,31240486,31241076,31241475,31241578,31241772,31242864,31244367,31244455,31244596,31244782,31244812,31244861,31244901,31244935,31244989,31245163,31245277,31245324,31245732,31246094,31247036,31247261,31247402,31247875,31247943,31248002,31248039,31248566,31248646,31248951,31249011,31249320,3124944', 'assoc_port': '31200282:31201053,31200290:31201307,31200302:31201781,31200306:31201985,31201389:31203379,31203006:31205695,31203013:31205902,31203014:31205946,31203016:31206042,31203023:31206399,31203024:31206449,31207501:31212008,31207817:31212324,31207818:31212359,31207820:31212441,31207821:31212501,31207963:31212544,31208466:31212588,31209020:31212645,31210076:31213012,31210574:31213219,31211680:31213450,31212170:31214546,31213705:31214796,31213706:31214860,31214633:31215392,31214978:31215475,31216863:31216929,31216864:31216888,31217436:31217632,31217697:31217868,31217698:31217802,31218182:31218360,31218476:31218618,31218740:31218926,31219017:31219220,31219297:31219341,31219561:31219996,31219772:31219961,31220094:31220261,31220372:31220594,31220638:31220832,31221404:31221576,31221636:31221864,31221910:31222082,31222175:31222386,31222441:31222660,31222443:31222570,31222850:31223021,31223115:31223293,31223378:31223558,31223612:31223817,31223876:31224058,31224145:31224285,31224146:31224322,31225314:31225497,31226633:3122675', 'assoc_mat': '31200282:metal:4230:31201053,31200290:metal:4230:31201307,31200302:metal:4230:31201781,31200306:metal:4230:31201985,31201389:metal:4230:31203379,31203006:metal:4230:31205695,31203013:metal:4230:31205902,31203014:metal:4230:31205946,31203016:metal:4230:31206042,31203023:metal:4230:31206399,31203024:metal:4230:31206449,31207501:metal:4230:31212008,31207817:metal:4230:31212324,31207818:metal:4230:31212359,31207820:metal:4230:31212441,31207821:metal:4230:31212501,31207963:metal:4230:31212544,31208466:metal:4230:31212588,31209020:metal:4230:31212645,31210076:metal:4230:31213012,31210574:metal:4230:31213219,31211680:metal:4230:31213450,31212170:metal:4230:31214546,31213705:metal:4230:31214796,31213706:metal:4230:31214860,31214633:metal:4230:31215392,31214978:metal:4230:31215475,31216863:metal:4230:31216929,31216864:metal:4230:31216888,31217436:metal:4230:31217632,31217697:metal:4230:31217868,31217698:metal:4230:31217802,31218182:metal:4230:31218360,31218476:metal:4230:31218618,31218740:metal:4230:31218926,31219017:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16966531396940623, 'nb_photo': 232954, 'list_port_cont': '31201057,31201233,31201320,31201405,31201531,31201614,31201782,31201910,31201982,31203120,31203259,31203303,31203380,31203414,31204318,31204394,31204468,31205660,31205698,31205747,31205784,31205821,31205872,31205909,31205954,31206002,31206056,31206098,31206145,31206176,31206219,31206257,31206315,31206355,31206404,31206460,31206486,31206539,31206590,31211868,31211915,31211966,31212005,31212264,31212319,31212351,31212414,31212451,31212500,31212552,31212595,31212643,31212688,31213022,31213232,31213379,31213460,31214557,31214593,31214700,31214801,31214850,31215391,31215422,31215479,31215910,31216081,31216114,31216653,31216897,31216935,31217639,31217806,31217877,31218372,31218614,31218921,31219221,31219345,31219964,31219999,31220268,31220589,31220828,31221086,31221352,31221581,31221863,31222074,31222395,31222580,31222656,31223029,31223292,31223560,31223818,31224064,31224284,31224320,31224966,31225229,31225490,31226010,31226139,31226320,31226758,31226784,31227144,31227643,31227727,31228061,31228269,31228792,3122904', 'assoc_port': '31200282:31201057,31200285:31203303,31200288:31201233,31200290:31201320,31200293:31201405,31200295:31201531,31200298:31201614,31200300:31204318,31200302:31201782,31200304:31201910,31200306:31201982,31200435:31203120,31200918:31203259,31201389:31203380,31201853:31203414,31202289:31204394,31202757:31204468,31203005:31205660,31203006:31205698,31203007:31205747,31203008:31205784,31203009:31205821,31203011:31206145,31203012:31205872,31203013:31205909,31203014:31205954,31203015:31206002,31203016:31206056,31203017:31206098,31203018:31206176,31203019:31206219,31203020:31206257,31203021:31206315,31203022:31206355,31203023:31206404,31203024:31206460,31203025:31206486,31203026:31206539,31203027:31206590,31205934:31211868,31206481:31211915,31207020:31211966,31207501:31212005,31207815:31212264,31207817:31212319,31207818:31212351,31207819:31212414,31207820:31212451,31207821:31212500,31207963:31212552,31208466:31212595,31209020:31212643,31209540:31212688,31210076:31213022,31210574:31213232,31211134:31213379,31211680:3121346', 'assoc_mat': '31200282:papier:4230:31201057,31200285:papier:4230:31203303,31200288:papier:4230:31201233,31200290:papier:4230:31201320,31200293:papier:4230:31201405,31200295:papier:4230:31201531,31200298:papier:4230:31201614,31200300:papier:4230:31204318,31200302:papier:4230:31201782,31200304:papier:4230:31201910,31200306:papier:4230:31201982,31200435:papier:4230:31203120,31200918:papier:4230:31203259,31201389:papier:4230:31203380,31201853:papier:4230:31203414,31202289:papier:4230:31204394,31202757:papier:4230:31204468,31203005:papier:4230:31205660,31203006:papier:4230:31205698,31203007:papier:4230:31205747,31203008:papier:4230:31205784,31203009:papier:4230:31205821,31203011:papier:4230:31206145,31203012:papier:4230:31205872,31203013:papier:4230:31205909,31203014:papier:4230:31205954,31203015:papier:4230:31206002,31203016:papier:4230:31206056,31203017:papier:4230:31206098,31203018:papier:4230:31206176,31203019:papier:4230:31206219,31203020:papier:4230:31206257,31203021:papier:4230:31206315,31203022:papier:4230:31206355,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024398486162732352, 'nb_photo': 851, 'list_port_cont': '31201236,31201407,31201621,31201795,31201914,31201989,31203292,31204472,31205751,31205911,31205962,31206051,31206141,31211972,31212269,31212326,31212419,31212447,31212550,31212594,31212650,31212690,31213229,31213381,31213461,31214551,31214806,31214857,31215389,31216076,31216656,31216932,31218612,31218923,31219224,31219342,31219962,31220004,31221081,31223287,31223555,31223826,31224066,31224311,31224959,31225223,31226007,31226144,31227153,31227639,31227732,31228059,31228786,31229463,31230516,31230752,31231017,31231291,31231481,31231626,31231966,31233047,31233257,31233382,31234622,31234851,31235208,31235463,31235953,31236195,31236483,31238700,31238968,31239390,31239623,31239923,31240175,31240495,31240754,31241072,31241473,31241827,31242859,31244092,31244288,31244991,31245730,31246103,31247050,31247258,31247887,31247949,31248038,31248578,31248657,31249004,31249325,31249462,31250016,31250182,31250977,31251496,31251789,31252106,31252417,31252753,31253215,31253314,31253583,31253900,31254174,31254716,31254765,3125479', 'assoc_port': '31200285:31203292,31200288:31201236,31200293:31201407,31200298:31201621,31200302:31201795,31200304:31201914,31200306:31201989,31202757:31204472,31203007:31205751,31203011:31206141,31203013:31205911,31203014:31205962,31203016:31206051,31207020:31211972,31207815:31212269,31207817:31212326,31207819:31212419,31207820:31212447,31207963:31212550,31208466:31212594,31209020:31212650,31209540:31212690,31210574:31213229,31211134:31213381,31211680:31213461,31212170:31214551,31213705:31214806,31213706:31214857,31214633:31215389,31215631:31216076,31216552:31216656,31216863:31216932,31218476:31218612,31218740:31218923,31219017:31219224,31219297:31219342,31219561:31220004,31219772:31219962,31220877:31221081,31223115:31223287,31223378:31223555,31223612:31223826,31223876:31224066,31224146:31224311,31224791:31224959,31225046:31225223,31225946:31226007,31225947:31226144,31226972:31227153,31227429:31227639,31227662:31227732,31228011:31228059,31228566:31228786,31229387:31229463,31230354:31230516,31230575:31230752,31230837:3123101', 'assoc_mat': '31200285:pehd:4230:31203292,31200288:pehd:4230:31201236,31200293:pehd:4230:31201407,31200298:pehd:4230:31201621,31200302:pehd:4230:31201795,31200304:pehd:4230:31201914,31200306:pehd:4230:31201989,31202757:pehd:4230:31204472,31203007:pehd:4230:31205751,31203011:pehd:4230:31206141,31203013:pehd:4230:31205911,31203014:pehd:4230:31205962,31203016:pehd:4230:31206051,31207020:pehd:4230:31211972,31207815:pehd:4230:31212269,31207817:pehd:4230:31212326,31207819:pehd:4230:31212419,31207820:pehd:4230:31212447,31207963:pehd:4230:31212550,31208466:pehd:4230:31212594,31209020:pehd:4230:31212650,31209540:pehd:4230:31212690,31210574:pehd:4230:31213229,31211134:pehd:4230:31213381,31211680:pehd:4230:31213461,31212170:pehd:4230:31214551,31213705:pehd:4230:31214806,31213706:pehd:4230:31214857,31214633:pehd:4230:31215389,31215631:pehd:4230:31216076,31216552:pehd:4230:31216656,31216863:pehd:4230:31216932,31218476:pehd:4230:31218612,31218740:pehd:4230:31218923,31219017:pehd:4230:31219224,31219297:pehd:4230:31219342,31219561:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013239351106620733, 'nb_photo': 17160, 'list_port_cont': '31201061,31201238,31201314,31201404,31201530,31201612,31201791,31201917,31201991,31203117,31203265,31203295,31203381,31203420,31204319,31204400,31204465,31205664,31205706,31205746,31205788,31205819,31205865,31205912,31205960,31206005,31206054,31206095,31206136,31206180,31206218,31206268,31206304,31206353,31206406,31206457,31206500,31206536,31206589,31211865,31211906,31211968,31212011,31212262,31212323,31212352,31212415,31212449,31212502,31212540,31212590,31212651,31212687,31213027,31213227,31213387,31213463,31214556,31214600,31214710,31214802,31214856,31215393,31215427,31215484,31215901,31216071,31216111,31216660,31216898,31216930,31217636,31217818,31217875,31218377,31218616,31218933,31219219,31219352,31219963,31220005,31220273,31220580,31220827,31221087,31221357,31221579,31221865,31222078,31222394,31222575,31222655,31223025,31223279,31223559,31223829,31224054,31224283,31224308,31224969,31225225,31225492,31226006,31226136,31226321,31226757,31226791,31227151,31227634,31227721,31228058,31228271,31228794,3122903', 'assoc_port': '31200282:31201061,31200285:31203295,31200288:31201238,31200290:31201314,31200293:31201404,31200295:31201530,31200298:31201612,31200300:31204319,31200302:31201791,31200304:31201917,31200306:31201991,31200435:31203117,31200918:31203265,31201389:31203381,31201853:31203420,31202289:31204400,31202757:31204465,31203005:31205664,31203006:31205706,31203007:31205746,31203008:31205788,31203009:31205819,31203011:31206136,31203012:31205865,31203013:31205912,31203014:31205960,31203015:31206005,31203016:31206054,31203017:31206095,31203018:31206180,31203019:31206218,31203020:31206268,31203021:31206304,31203022:31206353,31203023:31206406,31203024:31206457,31203025:31206500,31203026:31206536,31203027:31206589,31205934:31211865,31206481:31211906,31207020:31211968,31207501:31212011,31207815:31212262,31207817:31212323,31207818:31212352,31207819:31212415,31207820:31212449,31207821:31212502,31207963:31212540,31208466:31212590,31209020:31212651,31209540:31212687,31210076:31213027,31210574:31213227,31211134:31213387,31211680:3121346', 'assoc_mat': '31200282:pet_clair:4230:31201061,31200285:pet_clair:4230:31203295,31200288:pet_clair:4230:31201238,31200290:pet_clair:4230:31201314,31200293:pet_clair:4230:31201404,31200295:pet_clair:4230:31201530,31200298:pet_clair:4230:31201612,31200300:pet_clair:4230:31204319,31200302:pet_clair:4230:31201791,31200304:pet_clair:4230:31201917,31200306:pet_clair:4230:31201991,31200435:pet_clair:4230:31203117,31200918:pet_clair:4230:31203265,31201389:pet_clair:4230:31203381,31201853:pet_clair:4230:31203420,31202289:pet_clair:4230:31204400,31202757:pet_clair:4230:31204465,31203005:pet_clair:4230:31205664,31203006:pet_clair:4230:31205706,31203007:pet_clair:4230:31205746,31203008:pet_clair:4230:31205788,31203009:pet_clair:4230:31205819,31203011:pet_clair:4230:31206136,31203012:pet_clair:4230:31205865,31203013:pet_clair:4230:31205912,31203014:pet_clair:4230:31205960,31203015:pet_clair:4230:31206005,31203016:pet_clair:4230:31206054,31203017:pet_clair:4230:31206095,31203018:pet_clair:4230:31206180,31203019:pet_clair:4230:31206218,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031708764483975136, 'nb_photo': 527, 'list_port_cont': '31201067,31201317,31201913,31204398,31204467,31206049,31206187,31206214,31212273,31212321,31212362,31212410,31212647,31212692,31213024,31213233,31213385,31213457,31214554,31214596,31214708,31214809,31214853,31216934,31218374,31218620,31218930,31219223,31219347,31219956,31219994,31220593,31220829,31221074,31222648,31224281,31225226,31225500,31225995,31226756,31227152,31227638,31228261,31228782,31229041,31229410,31231479,31231633,31235466,31235883,31235951,31236484,31237837,31237935,31238201,31238692,31238966,31240178,31244289,31245293,31247260,31247958,31248000,31248048,31248574,31248655,31248952,31249007,31249327,31249452,31250013,31250056,31250196,31250737,31250925,31251788,31252110,31252416,31252747,31253220,31253573,31253890,31254168,31254721,31254754,31254944,31255364,31255642,31257267,31257559,31257903,31257933,31258216,31258459,31258685,31259181,31259407,31259696,31259860,31260052,31260617,31261271,31261540,31261764,31261968,31263220,31264921,31265284,31265525,31265821,31265926,31266231,31266268,3126656', 'assoc_port': '31200282:31201067,31200290:31201317,31200304:31201913,31202289:31204398,31202757:31204467,31203016:31206049,31203018:31206187,31203019:31206214,31207815:31212273,31207817:31212321,31207818:31212362,31207819:31212410,31209020:31212647,31209540:31212692,31210076:31213024,31210574:31213233,31211134:31213385,31211680:31213457,31212170:31214554,31212712:31214596,31213096:31214708,31213705:31214809,31213706:31214853,31216863:31216934,31218182:31218374,31218476:31218620,31218740:31218930,31219017:31219223,31219297:31219347,31219561:31219994,31219772:31219956,31220372:31220593,31220638:31220829,31220877:31221074,31222441:31222648,31224145:31224281,31225046:31225226,31225314:31225500,31225946:31225995,31226633:31226756,31226972:31227152,31227429:31227638,31228205:31228261,31228566:31228782,31228847:31229041,31229143:31229410,31231373:31231479,31231606:31231633,31235309:31235466,31235583:31235883,31235809:31235951,31236344:31236484,31237077:31237935,31237639:31237837,31237970:31238201,31238577:31238692,31238810:3123896', 'assoc_mat': '31200282:pet_fonce:4230:31201067,31200290:pet_fonce:4230:31201317,31200304:pet_fonce:4230:31201913,31202289:pet_fonce:4230:31204398,31202757:pet_fonce:4230:31204467,31203016:pet_fonce:4230:31206049,31203018:pet_fonce:4230:31206187,31203019:pet_fonce:4230:31206214,31207815:pet_fonce:4230:31212273,31207817:pet_fonce:4230:31212321,31207818:pet_fonce:4230:31212362,31207819:pet_fonce:4230:31212410,31209020:pet_fonce:4230:31212647,31209540:pet_fonce:4230:31212692,31210076:pet_fonce:4230:31213024,31210574:pet_fonce:4230:31213233,31211134:pet_fonce:4230:31213385,31211680:pet_fonce:4230:31213457,31212170:pet_fonce:4230:31214554,31212712:pet_fonce:4230:31214596,31213096:pet_fonce:4230:31214708,31213705:pet_fonce:4230:31214809,31213706:pet_fonce:4230:31214853,31216863:pet_fonce:4230:31216934,31218182:pet_fonce:4230:31218374,31218476:pet_fonce:4230:31218620,31218740:pet_fonce:4230:31218930,31219017:pet_fonce:4230:31219223,31219297:pet_fonce:4230:31219347,31219561:pet_fonce:4230:31219994,31219772:pet_fonce:4230:31219956,3'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(3006642,3006916,3007506,3008144,3008436,3009172,3009768,3010250,3010786,3011392,3011974,3012278,3012852,3013526,3014192,3014848,3015404,3015956,3016428,3017018,3017648,3018324,3019076,3019978,3020768,3021274,3021548,3022222,3022930,3023650,3024336)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302791, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201051,31201237,31201319,31201391,31201529,31201607,31201792,31201911,31201980,31203110,31203261,31203305,31203371,31203413,31204322,31204384,31204471,31205665,31205709,31205748,31205789,31205826,31205867,31205897,31205961,31206006,31206057,31206089,31206135,31206178,31206227,31206255,31206306,31206348,31206393,31206448,31206496,31206526,31206575,31211867,31211913,31211973,31212007,31212259,31212311,31212353,31212420,31212452,31212487,31212545,31212591,31212649,31212689,31213026,31213226,31213370,31213451,31214559,31214598,31214707,31214794,31214846,31215384,31215421,31215476,31215905,31216082,31216108,31216661,31216894,31216925,31217641,31217805,31217866,31218369,31218621,31218920,31219207,31219343,31219959,31219991,31220277,31220584,31220830,31221076,31221345,31221573,31221866,31222087,31222397,31222566,31222661,31223020,31223291,31223551,31223815,31224057,31224282,31224321,31224963,31225213,31225501,31225996,31226145,31226305,31226750,31226782,31227141,31227631,31227734,31228056,31228274,31228778,3122903 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302792, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201060,31201232,31201323,31201408,31201537,31201622,31201784,31201915,31201992,31203114,31203256,31203302,31203382,31203418,31204325,31204392,31204474,31205661,31205710,31205741,31205785,31205825,31205870,31205910,31205950,31206001,31206047,31206097,31206139,31206189,31206225,31206269,31206311,31206357,31206402,31206453,31206497,31206541,31206591,31211866,31211917,31211959,31212015,31212272,31212325,31212358,31212413,31212454,31212498,31212546,31212589,31212653,31212683,31213020,31213223,31213386,31213466,31214561,31214599,31214709,31214804,31214859,31215390,31215428,31215478,31215906,31216070,31216116,31216646,31216896,31216936,31217635,31217815,31217876,31218370,31218622,31218932,31219215,31219350,31219966,31220000,31220272,31220595,31220824,31221085,31221354,31221577,31221862,31222088,31222393,31222579,31222659,31223033,31223288,31223557,31223830,31224059,31224279,31224323,31224960,31225217,31225496,31226003,31226142,31226322,31226748,31226793,31227155,31227630,31227731,31228057,31228270,31228790,3122904 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302793, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201053,31201307,31201781,31201985,31203379,31205695,31205902,31205946,31206042,31206399,31206449,31212008,31212324,31212359,31212441,31212501,31212544,31212588,31212645,31213012,31213219,31213450,31214546,31214796,31214860,31215392,31215475,31216888,31216929,31217632,31217802,31217868,31218360,31218618,31218926,31219220,31219341,31219961,31219996,31220261,31220594,31220832,31221576,31221864,31222082,31222386,31222570,31222660,31223021,31223293,31223558,31223817,31224058,31224285,31224322,31225497,31226753,31226783,31227150,31227642,31228272,31228795,31229047,31229407,31229457,31229793,31230236,31230512,31231028,31231631,31233043,31235458,31235892,31235940,31236194,31236477,31236726,31236957,31237931,31238697,31239622,31240486,31241076,31241475,31241578,31241772,31242864,31244367,31244455,31244596,31244782,31244812,31244861,31244901,31244935,31244989,31245163,31245277,31245324,31245732,31246094,31247036,31247261,31247402,31247875,31247943,31248002,31248039,31248566,31248646,31248951,31249011,31249320,3124944 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302794, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201057,31201233,31201320,31201405,31201531,31201614,31201782,31201910,31201982,31203120,31203259,31203303,31203380,31203414,31204318,31204394,31204468,31205660,31205698,31205747,31205784,31205821,31205872,31205909,31205954,31206002,31206056,31206098,31206145,31206176,31206219,31206257,31206315,31206355,31206404,31206460,31206486,31206539,31206590,31211868,31211915,31211966,31212005,31212264,31212319,31212351,31212414,31212451,31212500,31212552,31212595,31212643,31212688,31213022,31213232,31213379,31213460,31214557,31214593,31214700,31214801,31214850,31215391,31215422,31215479,31215910,31216081,31216114,31216653,31216897,31216935,31217639,31217806,31217877,31218372,31218614,31218921,31219221,31219345,31219964,31219999,31220268,31220589,31220828,31221086,31221352,31221581,31221863,31222074,31222395,31222580,31222656,31223029,31223292,31223560,31223818,31224064,31224284,31224320,31224966,31225229,31225490,31226010,31226139,31226320,31226758,31226784,31227144,31227643,31227727,31228061,31228269,31228792,3122904 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302795, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201236,31201407,31201621,31201795,31201914,31201989,31203292,31204472,31205751,31205911,31205962,31206051,31206141,31211972,31212269,31212326,31212419,31212447,31212550,31212594,31212650,31212690,31213229,31213381,31213461,31214551,31214806,31214857,31215389,31216076,31216656,31216932,31218612,31218923,31219224,31219342,31219962,31220004,31221081,31223287,31223555,31223826,31224066,31224311,31224959,31225223,31226007,31226144,31227153,31227639,31227732,31228059,31228786,31229463,31230516,31230752,31231017,31231291,31231481,31231626,31231966,31233047,31233257,31233382,31234622,31234851,31235208,31235463,31235953,31236195,31236483,31238700,31238968,31239390,31239623,31239923,31240175,31240495,31240754,31241072,31241473,31241827,31242859,31244092,31244288,31244991,31245730,31246103,31247050,31247258,31247887,31247949,31248038,31248578,31248657,31249004,31249325,31249462,31250016,31250182,31250977,31251496,31251789,31252106,31252417,31252753,31253215,31253314,31253583,31253900,31254174,31254716,31254765,3125479 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302796, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201061,31201238,31201314,31201404,31201530,31201612,31201791,31201917,31201991,31203117,31203265,31203295,31203381,31203420,31204319,31204400,31204465,31205664,31205706,31205746,31205788,31205819,31205865,31205912,31205960,31206005,31206054,31206095,31206136,31206180,31206218,31206268,31206304,31206353,31206406,31206457,31206500,31206536,31206589,31211865,31211906,31211968,31212011,31212262,31212323,31212352,31212415,31212449,31212502,31212540,31212590,31212651,31212687,31213027,31213227,31213387,31213463,31214556,31214600,31214710,31214802,31214856,31215393,31215427,31215484,31215901,31216071,31216111,31216660,31216898,31216930,31217636,31217818,31217875,31218377,31218616,31218933,31219219,31219352,31219963,31220005,31220273,31220580,31220827,31221087,31221357,31221579,31221865,31222078,31222394,31222575,31222655,31223025,31223279,31223559,31223829,31224054,31224283,31224308,31224969,31225225,31225492,31226006,31226136,31226321,31226757,31226791,31227151,31227634,31227721,31228058,31228271,31228794,3122903 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302797, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31201067,31201317,31201913,31204398,31204467,31206049,31206187,31206214,31212273,31212321,31212362,31212410,31212647,31212692,31213024,31213233,31213385,31213457,31214554,31214596,31214708,31214809,31214853,31216934,31218374,31218620,31218930,31219223,31219347,31219956,31219994,31220593,31220829,31221074,31222648,31224281,31225226,31225500,31225995,31226756,31227152,31227638,31228261,31228782,31229041,31229410,31231479,31231633,31235466,31235883,31235951,31236484,31237837,31237935,31238201,31238692,31238966,31240178,31244289,31245293,31247260,31247958,31248000,31248048,31248574,31248655,31248952,31249007,31249327,31249452,31250013,31250056,31250196,31250737,31250925,31251788,31252110,31252416,31252747,31253220,31253573,31253890,31254168,31254721,31254754,31254944,31255364,31255642,31257267,31257559,31257903,31257933,31258216,31258459,31258685,31259181,31259407,31259696,31259860,31260052,31260617,31261271,31261540,31261764,31261968,31263220,31264921,31265284,31265525,31265821,31265926,31266231,31266268,3126656 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31302791,31302792,31302793,31302794,31302795,31302796,31302797?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2026-07-01' and date <= '2026-07-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1808,),), 'unwanted_material_monthly_percentage': ((0.79195074322685,),), 'material_repartition': (('incineration', 1808),), 'material_dict': {'incineration': 1808}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 7, 1), 0.830574409534932, 1), (datetime.date(2026, 7, 2), 0.7725579231231258, 2), (datetime.date(2026, 7, 3), 0.7305970185801278, 1), (datetime.date(2026, 7, 4), 0.7386331722076744, 2), (datetime.date(2026, 7, 5), 0.8266119233994701, 2), (datetime.date(2026, 7, 6), 0.8404057826640864, 2), (datetime.date(2026, 7, 7), 0.8040359407771097, 3), (datetime.date(2026, 7, 8), 0.7926164586794533, 2), (datetime.date(2026, 7, 9), 0.8030511693170649, 2), (datetime.date(2026, 7, 10), 0.6559375983918322, 2), (datetime.date(2026, 7, 11), 0.6679445613098494, 3), (datetime.date(2026, 7, 12), 0.7428260817948962, 3), (datetime.date(2026, 7, 13), 0.8209298654715089, 2), (datetime.date(2026, 7, 14), 0.8488809040851504, 3), (datetime.date(2026, 7, 15), 0.8868393763933369, 2), (datetime.date(2026, 7, 16), 0.8883366932835887, 3), (datetime.date(2026, 7, 17), 0.8685081310541171, 3), (datetime.date(2026, 7, 18), 0.8494036578885326, 3), (datetime.date(2026, 7, 19), 0.8805253302321996, 3), (datetime.date(2026, 7, 20), 0.8638673424104237, 3), (datetime.date(2026, 7, 21), 0.8112258057241046, 3), (datetime.date(2026, 7, 22), 0.7953679711199227, 3), (datetime.date(2026, 7, 23), 0.7364060014336886, 3), (datetime.date(2026, 7, 24), 0.696544799106259, 3), (datetime.date(2026, 7, 25), 0.7305573818488151, 2), (datetime.date(2026, 7, 26), 0.76301672193645, 2), (datetime.date(2026, 7, 27), 0.7292398613221802, 2), (datetime.date(2026, 7, 28), 0.7876114919084376, 3), (datetime.date(2026, 7, 29), 0.8464218495200986, 3), (datetime.date(2026, 7, 30), 0.710612789628917, 2), (datetime.date(2026, 7, 31), 0.7211185672909245, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 7, 1), 0.830574409534932, 1), (datetime.date(2026, 7, 2), 0.7725579231231258, 2), (datetime.date(2026, 7, 3), 0.7305970185801278, 1), (datetime.date(2026, 7, 4), 0.7386331722076744, 2), (datetime.date(2026, 7, 5), 0.8266119233994701, 2), (datetime.date(2026, 7, 6), 0.8404057826640864, 2), (datetime.date(2026, 7, 7), 0.8040359407771097, 3), (datetime.date(2026, 7, 8), 0.7926164586794533, 2), (datetime.date(2026, 7, 9), 0.8030511693170649, 2), (datetime.date(2026, 7, 10), 0.6559375983918322, 2), (datetime.date(2026, 7, 11), 0.6679445613098494, 3), (datetime.date(2026, 7, 12), 0.7428260817948962, 3), (datetime.date(2026, 7, 13), 0.8209298654715089, 2), (datetime.date(2026, 7, 14), 0.8488809040851504, 3), (datetime.date(2026, 7, 15), 0.8868393763933369, 2), (datetime.date(2026, 7, 16), 0.8883366932835887, 3), (datetime.date(2026, 7, 17), 0.8685081310541171, 3), (datetime.date(2026, 7, 18), 0.8494036578885326, 3), (datetime.date(2026, 7, 19), 0.8805253302321996, 3), (datetime.date(2026, 7, 20), 0.8638673424104237, 3), (datetime.date(2026, 7, 21), 0.8112258057241046, 3), (datetime.date(2026, 7, 22), 0.7953679711199227, 3), (datetime.date(2026, 7, 23), 0.7364060014336886, 3), (datetime.date(2026, 7, 24), 0.696544799106259, 3), (datetime.date(2026, 7, 25), 0.7305573818488151, 2), (datetime.date(2026, 7, 26), 0.76301672193645, 2), (datetime.date(2026, 7, 27), 0.7292398613221802, 2), (datetime.date(2026, 7, 28), 0.7876114919084376, 3), (datetime.date(2026, 7, 29), 0.8464218495200986, 3), (datetime.date(2026, 7, 30), 0.710612789628917, 2), (datetime.date(2026, 7, 31), 0.7211185672909245, 4))}, 'quality_array': [['-7.261808690071288', '01072026'], ['-7.763701593137046', '02072026'], ['-7.7976123411089695', '03072026'], ['-7.619326591586537', '04072026'], ['-7.839831168936529', '05072026'], ['-7.941305052684', '06072026'], ['-7.976512810620059', '07072026'], ['-8.09846742894104', '08072026'], ['-7.505729735795942', '09072026'], ['-8.37347364559421', '10072026'], ['-8.504673477144303', '11072026'], ['-8.824789680243459', '12072026'], ['-8.228346641780844', '13072026'], ['-8.265685931758266', '14072026'], ['-7.279718317668015', '15072026'], ['-6.6796985918339535', '16072026'], ['-6.331562020737288', '17072026'], ['-6.656510916648004', '18072026'], ['-6.71088757190879', '19072026'], ['-6.661509923651142', '20072026'], ['-7.255757744880323', '21072026'], ['-7.860795133831168', '22072026'], ['-7.994614633581421', '23072026'], ['-8.218222332660385', '24072026'], ['-8.2370636059866', '25072026'], ['-8.099671902131426', '26072026'], ['-7.393033249047379', '27072026'], ['-7.328218119775821', '28072026'], ['-7.61682202706101', '29072026'], ['-7.550689181351694', '30072026'], ['-7.882297209849404', '31072026']], 'number_of_batch': ((682,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013650217983355228, 'nb_photo': 13319, 'list_port_cont': '31201051,31201237,31201319,31201391,31201529,31201607,31201792,31201911,31201980,31203110,31203261,31203305,31203371,31203413,31204322,31204384,31204471,31205665,31205709,31205748,31205789,31205826,31205867,31205897,31205961,31206006,31206057,31206089,31206135,31206178,31206227,31206255,31206306,31206348,31206393,31206448,31206496,31206526,31206575,31211867,31211913,31211973,31212007,31212259,31212311,31212353,31212420,31212452,31212487,31212545,31212591,31212649,31212689,31213026,31213226,31213370,31213451,31214559,31214598,31214707,31214794,31214846,31215384,31215421,31215476,31215905,31216082,31216108,31216661,31216894,31216925,31217641,31217805,31217866,31218369,31218621,31218920,31219207,31219343,31219959,31219991,31220277,31220584,31220830,31221076,31221345,31221573,31221866,31222087,31222397,31222566,31222661,31223020,31223291,31223551,31223815,31224057,31224282,31224321,31224963,31225213,31225501,31225996,31226145,31226305,31226750,31226782,31227141,31227631,31227734,31228056,31228274,31228778,3122903', 'assoc_port': '31200282:31201051,31200285:31203305,31200288:31201237,31200290:31201319,31200293:31201391,31200295:31201529,31200298:31201607,31200300:31204322,31200302:31201792,31200304:31201911,31200306:31201980,31200435:31203110,31200918:31203261,31201389:31203371,31201853:31203413,31202289:31204384,31202757:31204471,31203005:31205665,31203006:31205709,31203007:31205748,31203008:31205789,31203009:31205826,31203011:31206135,31203012:31205867,31203013:31205897,31203014:31205961,31203015:31206006,31203016:31206057,31203017:31206089,31203018:31206178,31203019:31206227,31203020:31206255,31203021:31206306,31203022:31206348,31203023:31206393,31203024:31206448,31203025:31206496,31203026:31206526,31203027:31206575,31205934:31211867,31206481:31211913,31207020:31211973,31207501:31212007,31207815:31212259,31207817:31212311,31207818:31212353,31207819:31212420,31207820:31212452,31207821:31212487,31207963:31212545,31208466:31212591,31209020:31212649,31209540:31212689,31210076:31213026,31210574:31213226,31211134:31213370,31211680:3121345', 'assoc_mat': '31200282:autre:4230:31201051,31200285:autre:4230:31203305,31200288:autre:4230:31201237,31200290:autre:4230:31201319,31200293:autre:4230:31201391,31200295:autre:4230:31201529,31200298:autre:4230:31201607,31200300:autre:4230:31204322,31200302:autre:4230:31201792,31200304:autre:4230:31201911,31200306:autre:4230:31201980,31200435:autre:4230:31203110,31200918:autre:4230:31203261,31201389:autre:4230:31203371,31201853:autre:4230:31203413,31202289:autre:4230:31204384,31202757:autre:4230:31204471,31203005:autre:4230:31205665,31203006:autre:4230:31205709,31203007:autre:4230:31205748,31203008:autre:4230:31205789,31203009:autre:4230:31205826,31203011:autre:4230:31206135,31203012:autre:4230:31205867,31203013:autre:4230:31205897,31203014:autre:4230:31205961,31203015:autre:4230:31206006,31203016:autre:4230:31206057,31203017:autre:4230:31206089,31203018:autre:4230:31206178,31203019:autre:4230:31206227,31203020:autre:4230:31206255,31203021:autre:4230:31206306,31203022:autre:4230:31206348,31203023:autre:4230:31206393,31203024:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03948303942476122, 'nb_photo': 59482, 'list_port_cont': '31201060,31201232,31201323,31201408,31201537,31201622,31201784,31201915,31201992,31203114,31203256,31203302,31203382,31203418,31204325,31204392,31204474,31205661,31205710,31205741,31205785,31205825,31205870,31205910,31205950,31206001,31206047,31206097,31206139,31206189,31206225,31206269,31206311,31206357,31206402,31206453,31206497,31206541,31206591,31211866,31211917,31211959,31212015,31212272,31212325,31212358,31212413,31212454,31212498,31212546,31212589,31212653,31212683,31213020,31213223,31213386,31213466,31214561,31214599,31214709,31214804,31214859,31215390,31215428,31215478,31215906,31216070,31216116,31216646,31216896,31216936,31217635,31217815,31217876,31218370,31218622,31218932,31219215,31219350,31219966,31220000,31220272,31220595,31220824,31221085,31221354,31221577,31221862,31222088,31222393,31222579,31222659,31223033,31223288,31223557,31223830,31224059,31224279,31224323,31224960,31225217,31225496,31226003,31226142,31226322,31226748,31226793,31227155,31227630,31227731,31228057,31228270,31228790,3122904', 'assoc_port': '31200282:31201060,31200285:31203302,31200288:31201232,31200290:31201323,31200293:31201408,31200295:31201537,31200298:31201622,31200300:31204325,31200302:31201784,31200304:31201915,31200306:31201992,31200435:31203114,31200918:31203256,31201389:31203382,31201853:31203418,31202289:31204392,31202757:31204474,31203005:31205661,31203006:31205710,31203007:31205741,31203008:31205785,31203009:31205825,31203011:31206139,31203012:31205870,31203013:31205910,31203014:31205950,31203015:31206001,31203016:31206047,31203017:31206097,31203018:31206189,31203019:31206225,31203020:31206269,31203021:31206311,31203022:31206357,31203023:31206402,31203024:31206453,31203025:31206497,31203026:31206541,31203027:31206591,31205934:31211866,31206481:31211917,31207020:31211959,31207501:31212015,31207815:31212272,31207817:31212325,31207818:31212358,31207819:31212413,31207820:31212454,31207821:31212498,31207963:31212546,31208466:31212589,31209020:31212653,31209540:31212683,31210076:31213020,31210574:31213223,31211134:31213386,31211680:3121346', 'assoc_mat': '31200282:carton:4230:31201060,31200285:carton:4230:31203302,31200288:carton:4230:31201232,31200290:carton:4230:31201323,31200293:carton:4230:31201408,31200295:carton:4230:31201537,31200298:carton:4230:31201622,31200300:carton:4230:31204325,31200302:carton:4230:31201784,31200304:carton:4230:31201915,31200306:carton:4230:31201992,31200435:carton:4230:31203114,31200918:carton:4230:31203256,31201389:carton:4230:31203382,31201853:carton:4230:31203418,31202289:carton:4230:31204392,31202757:carton:4230:31204474,31203005:carton:4230:31205661,31203006:carton:4230:31205710,31203007:carton:4230:31205741,31203008:carton:4230:31205785,31203009:carton:4230:31205825,31203011:carton:4230:31206139,31203012:carton:4230:31205870,31203013:carton:4230:31205910,31203014:carton:4230:31205950,31203015:carton:4230:31206001,31203016:carton:4230:31206047,31203017:carton:4230:31206097,31203018:carton:4230:31206189,31203019:carton:4230:31206225,31203020:carton:4230:31206269,31203021:carton:4230:31206311,31203022:carton:4230:31206357,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010529250396589607, 'nb_photo': 1061, 'list_port_cont': '31201053,31201307,31201781,31201985,31203379,31205695,31205902,31205946,31206042,31206399,31206449,31212008,31212324,31212359,31212441,31212501,31212544,31212588,31212645,31213012,31213219,31213450,31214546,31214796,31214860,31215392,31215475,31216888,31216929,31217632,31217802,31217868,31218360,31218618,31218926,31219220,31219341,31219961,31219996,31220261,31220594,31220832,31221576,31221864,31222082,31222386,31222570,31222660,31223021,31223293,31223558,31223817,31224058,31224285,31224322,31225497,31226753,31226783,31227150,31227642,31228272,31228795,31229047,31229407,31229457,31229793,31230236,31230512,31231028,31231631,31233043,31235458,31235892,31235940,31236194,31236477,31236726,31236957,31237931,31238697,31239622,31240486,31241076,31241475,31241578,31241772,31242864,31244367,31244455,31244596,31244782,31244812,31244861,31244901,31244935,31244989,31245163,31245277,31245324,31245732,31246094,31247036,31247261,31247402,31247875,31247943,31248002,31248039,31248566,31248646,31248951,31249011,31249320,3124944', 'assoc_port': '31200282:31201053,31200290:31201307,31200302:31201781,31200306:31201985,31201389:31203379,31203006:31205695,31203013:31205902,31203014:31205946,31203016:31206042,31203023:31206399,31203024:31206449,31207501:31212008,31207817:31212324,31207818:31212359,31207820:31212441,31207821:31212501,31207963:31212544,31208466:31212588,31209020:31212645,31210076:31213012,31210574:31213219,31211680:31213450,31212170:31214546,31213705:31214796,31213706:31214860,31214633:31215392,31214978:31215475,31216863:31216929,31216864:31216888,31217436:31217632,31217697:31217868,31217698:31217802,31218182:31218360,31218476:31218618,31218740:31218926,31219017:31219220,31219297:31219341,31219561:31219996,31219772:31219961,31220094:31220261,31220372:31220594,31220638:31220832,31221404:31221576,31221636:31221864,31221910:31222082,31222175:31222386,31222441:31222660,31222443:31222570,31222850:31223021,31223115:31223293,31223378:31223558,31223612:31223817,31223876:31224058,31224145:31224285,31224146:31224322,31225314:31225497,31226633:3122675', 'assoc_mat': '31200282:metal:4230:31201053,31200290:metal:4230:31201307,31200302:metal:4230:31201781,31200306:metal:4230:31201985,31201389:metal:4230:31203379,31203006:metal:4230:31205695,31203013:metal:4230:31205902,31203014:metal:4230:31205946,31203016:metal:4230:31206042,31203023:metal:4230:31206399,31203024:metal:4230:31206449,31207501:metal:4230:31212008,31207817:metal:4230:31212324,31207818:metal:4230:31212359,31207820:metal:4230:31212441,31207821:metal:4230:31212501,31207963:metal:4230:31212544,31208466:metal:4230:31212588,31209020:metal:4230:31212645,31210076:metal:4230:31213012,31210574:metal:4230:31213219,31211680:metal:4230:31213450,31212170:metal:4230:31214546,31213705:metal:4230:31214796,31213706:metal:4230:31214860,31214633:metal:4230:31215392,31214978:metal:4230:31215475,31216863:metal:4230:31216929,31216864:metal:4230:31216888,31217436:metal:4230:31217632,31217697:metal:4230:31217868,31217698:metal:4230:31217802,31218182:metal:4230:31218360,31218476:metal:4230:31218618,31218740:metal:4230:31218926,31219017:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16966531396940623, 'nb_photo': 232954, 'list_port_cont': '31201057,31201233,31201320,31201405,31201531,31201614,31201782,31201910,31201982,31203120,31203259,31203303,31203380,31203414,31204318,31204394,31204468,31205660,31205698,31205747,31205784,31205821,31205872,31205909,31205954,31206002,31206056,31206098,31206145,31206176,31206219,31206257,31206315,31206355,31206404,31206460,31206486,31206539,31206590,31211868,31211915,31211966,31212005,31212264,31212319,31212351,31212414,31212451,31212500,31212552,31212595,31212643,31212688,31213022,31213232,31213379,31213460,31214557,31214593,31214700,31214801,31214850,31215391,31215422,31215479,31215910,31216081,31216114,31216653,31216897,31216935,31217639,31217806,31217877,31218372,31218614,31218921,31219221,31219345,31219964,31219999,31220268,31220589,31220828,31221086,31221352,31221581,31221863,31222074,31222395,31222580,31222656,31223029,31223292,31223560,31223818,31224064,31224284,31224320,31224966,31225229,31225490,31226010,31226139,31226320,31226758,31226784,31227144,31227643,31227727,31228061,31228269,31228792,3122904', 'assoc_port': '31200282:31201057,31200285:31203303,31200288:31201233,31200290:31201320,31200293:31201405,31200295:31201531,31200298:31201614,31200300:31204318,31200302:31201782,31200304:31201910,31200306:31201982,31200435:31203120,31200918:31203259,31201389:31203380,31201853:31203414,31202289:31204394,31202757:31204468,31203005:31205660,31203006:31205698,31203007:31205747,31203008:31205784,31203009:31205821,31203011:31206145,31203012:31205872,31203013:31205909,31203014:31205954,31203015:31206002,31203016:31206056,31203017:31206098,31203018:31206176,31203019:31206219,31203020:31206257,31203021:31206315,31203022:31206355,31203023:31206404,31203024:31206460,31203025:31206486,31203026:31206539,31203027:31206590,31205934:31211868,31206481:31211915,31207020:31211966,31207501:31212005,31207815:31212264,31207817:31212319,31207818:31212351,31207819:31212414,31207820:31212451,31207821:31212500,31207963:31212552,31208466:31212595,31209020:31212643,31209540:31212688,31210076:31213022,31210574:31213232,31211134:31213379,31211680:3121346', 'assoc_mat': '31200282:papier:4230:31201057,31200285:papier:4230:31203303,31200288:papier:4230:31201233,31200290:papier:4230:31201320,31200293:papier:4230:31201405,31200295:papier:4230:31201531,31200298:papier:4230:31201614,31200300:papier:4230:31204318,31200302:papier:4230:31201782,31200304:papier:4230:31201910,31200306:papier:4230:31201982,31200435:papier:4230:31203120,31200918:papier:4230:31203259,31201389:papier:4230:31203380,31201853:papier:4230:31203414,31202289:papier:4230:31204394,31202757:papier:4230:31204468,31203005:papier:4230:31205660,31203006:papier:4230:31205698,31203007:papier:4230:31205747,31203008:papier:4230:31205784,31203009:papier:4230:31205821,31203011:papier:4230:31206145,31203012:papier:4230:31205872,31203013:papier:4230:31205909,31203014:papier:4230:31205954,31203015:papier:4230:31206002,31203016:papier:4230:31206056,31203017:papier:4230:31206098,31203018:papier:4230:31206176,31203019:papier:4230:31206219,31203020:papier:4230:31206257,31203021:papier:4230:31206315,31203022:papier:4230:31206355,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024398486162732352, 'nb_photo': 851, 'list_port_cont': '31201236,31201407,31201621,31201795,31201914,31201989,31203292,31204472,31205751,31205911,31205962,31206051,31206141,31211972,31212269,31212326,31212419,31212447,31212550,31212594,31212650,31212690,31213229,31213381,31213461,31214551,31214806,31214857,31215389,31216076,31216656,31216932,31218612,31218923,31219224,31219342,31219962,31220004,31221081,31223287,31223555,31223826,31224066,31224311,31224959,31225223,31226007,31226144,31227153,31227639,31227732,31228059,31228786,31229463,31230516,31230752,31231017,31231291,31231481,31231626,31231966,31233047,31233257,31233382,31234622,31234851,31235208,31235463,31235953,31236195,31236483,31238700,31238968,31239390,31239623,31239923,31240175,31240495,31240754,31241072,31241473,31241827,31242859,31244092,31244288,31244991,31245730,31246103,31247050,31247258,31247887,31247949,31248038,31248578,31248657,31249004,31249325,31249462,31250016,31250182,31250977,31251496,31251789,31252106,31252417,31252753,31253215,31253314,31253583,31253900,31254174,31254716,31254765,3125479', 'assoc_port': '31200285:31203292,31200288:31201236,31200293:31201407,31200298:31201621,31200302:31201795,31200304:31201914,31200306:31201989,31202757:31204472,31203007:31205751,31203011:31206141,31203013:31205911,31203014:31205962,31203016:31206051,31207020:31211972,31207815:31212269,31207817:31212326,31207819:31212419,31207820:31212447,31207963:31212550,31208466:31212594,31209020:31212650,31209540:31212690,31210574:31213229,31211134:31213381,31211680:31213461,31212170:31214551,31213705:31214806,31213706:31214857,31214633:31215389,31215631:31216076,31216552:31216656,31216863:31216932,31218476:31218612,31218740:31218923,31219017:31219224,31219297:31219342,31219561:31220004,31219772:31219962,31220877:31221081,31223115:31223287,31223378:31223555,31223612:31223826,31223876:31224066,31224146:31224311,31224791:31224959,31225046:31225223,31225946:31226007,31225947:31226144,31226972:31227153,31227429:31227639,31227662:31227732,31228011:31228059,31228566:31228786,31229387:31229463,31230354:31230516,31230575:31230752,31230837:3123101', 'assoc_mat': '31200285:pehd:4230:31203292,31200288:pehd:4230:31201236,31200293:pehd:4230:31201407,31200298:pehd:4230:31201621,31200302:pehd:4230:31201795,31200304:pehd:4230:31201914,31200306:pehd:4230:31201989,31202757:pehd:4230:31204472,31203007:pehd:4230:31205751,31203011:pehd:4230:31206141,31203013:pehd:4230:31205911,31203014:pehd:4230:31205962,31203016:pehd:4230:31206051,31207020:pehd:4230:31211972,31207815:pehd:4230:31212269,31207817:pehd:4230:31212326,31207819:pehd:4230:31212419,31207820:pehd:4230:31212447,31207963:pehd:4230:31212550,31208466:pehd:4230:31212594,31209020:pehd:4230:31212650,31209540:pehd:4230:31212690,31210574:pehd:4230:31213229,31211134:pehd:4230:31213381,31211680:pehd:4230:31213461,31212170:pehd:4230:31214551,31213705:pehd:4230:31214806,31213706:pehd:4230:31214857,31214633:pehd:4230:31215389,31215631:pehd:4230:31216076,31216552:pehd:4230:31216656,31216863:pehd:4230:31216932,31218476:pehd:4230:31218612,31218740:pehd:4230:31218923,31219017:pehd:4230:31219224,31219297:pehd:4230:31219342,31219561:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013239351106620733, 'nb_photo': 17160, 'list_port_cont': '31201061,31201238,31201314,31201404,31201530,31201612,31201791,31201917,31201991,31203117,31203265,31203295,31203381,31203420,31204319,31204400,31204465,31205664,31205706,31205746,31205788,31205819,31205865,31205912,31205960,31206005,31206054,31206095,31206136,31206180,31206218,31206268,31206304,31206353,31206406,31206457,31206500,31206536,31206589,31211865,31211906,31211968,31212011,31212262,31212323,31212352,31212415,31212449,31212502,31212540,31212590,31212651,31212687,31213027,31213227,31213387,31213463,31214556,31214600,31214710,31214802,31214856,31215393,31215427,31215484,31215901,31216071,31216111,31216660,31216898,31216930,31217636,31217818,31217875,31218377,31218616,31218933,31219219,31219352,31219963,31220005,31220273,31220580,31220827,31221087,31221357,31221579,31221865,31222078,31222394,31222575,31222655,31223025,31223279,31223559,31223829,31224054,31224283,31224308,31224969,31225225,31225492,31226006,31226136,31226321,31226757,31226791,31227151,31227634,31227721,31228058,31228271,31228794,3122903', 'assoc_port': '31200282:31201061,31200285:31203295,31200288:31201238,31200290:31201314,31200293:31201404,31200295:31201530,31200298:31201612,31200300:31204319,31200302:31201791,31200304:31201917,31200306:31201991,31200435:31203117,31200918:31203265,31201389:31203381,31201853:31203420,31202289:31204400,31202757:31204465,31203005:31205664,31203006:31205706,31203007:31205746,31203008:31205788,31203009:31205819,31203011:31206136,31203012:31205865,31203013:31205912,31203014:31205960,31203015:31206005,31203016:31206054,31203017:31206095,31203018:31206180,31203019:31206218,31203020:31206268,31203021:31206304,31203022:31206353,31203023:31206406,31203024:31206457,31203025:31206500,31203026:31206536,31203027:31206589,31205934:31211865,31206481:31211906,31207020:31211968,31207501:31212011,31207815:31212262,31207817:31212323,31207818:31212352,31207819:31212415,31207820:31212449,31207821:31212502,31207963:31212540,31208466:31212590,31209020:31212651,31209540:31212687,31210076:31213027,31210574:31213227,31211134:31213387,31211680:3121346', 'assoc_mat': '31200282:pet_clair:4230:31201061,31200285:pet_clair:4230:31203295,31200288:pet_clair:4230:31201238,31200290:pet_clair:4230:31201314,31200293:pet_clair:4230:31201404,31200295:pet_clair:4230:31201530,31200298:pet_clair:4230:31201612,31200300:pet_clair:4230:31204319,31200302:pet_clair:4230:31201791,31200304:pet_clair:4230:31201917,31200306:pet_clair:4230:31201991,31200435:pet_clair:4230:31203117,31200918:pet_clair:4230:31203265,31201389:pet_clair:4230:31203381,31201853:pet_clair:4230:31203420,31202289:pet_clair:4230:31204400,31202757:pet_clair:4230:31204465,31203005:pet_clair:4230:31205664,31203006:pet_clair:4230:31205706,31203007:pet_clair:4230:31205746,31203008:pet_clair:4230:31205788,31203009:pet_clair:4230:31205819,31203011:pet_clair:4230:31206136,31203012:pet_clair:4230:31205865,31203013:pet_clair:4230:31205912,31203014:pet_clair:4230:31205960,31203015:pet_clair:4230:31206005,31203016:pet_clair:4230:31206054,31203017:pet_clair:4230:31206095,31203018:pet_clair:4230:31206180,31203019:pet_clair:4230:31206218,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031708764483975136, 'nb_photo': 527, 'list_port_cont': '31201067,31201317,31201913,31204398,31204467,31206049,31206187,31206214,31212273,31212321,31212362,31212410,31212647,31212692,31213024,31213233,31213385,31213457,31214554,31214596,31214708,31214809,31214853,31216934,31218374,31218620,31218930,31219223,31219347,31219956,31219994,31220593,31220829,31221074,31222648,31224281,31225226,31225500,31225995,31226756,31227152,31227638,31228261,31228782,31229041,31229410,31231479,31231633,31235466,31235883,31235951,31236484,31237837,31237935,31238201,31238692,31238966,31240178,31244289,31245293,31247260,31247958,31248000,31248048,31248574,31248655,31248952,31249007,31249327,31249452,31250013,31250056,31250196,31250737,31250925,31251788,31252110,31252416,31252747,31253220,31253573,31253890,31254168,31254721,31254754,31254944,31255364,31255642,31257267,31257559,31257903,31257933,31258216,31258459,31258685,31259181,31259407,31259696,31259860,31260052,31260617,31261271,31261540,31261764,31261968,31263220,31264921,31265284,31265525,31265821,31265926,31266231,31266268,3126656', 'assoc_port': '31200282:31201067,31200290:31201317,31200304:31201913,31202289:31204398,31202757:31204467,31203016:31206049,31203018:31206187,31203019:31206214,31207815:31212273,31207817:31212321,31207818:31212362,31207819:31212410,31209020:31212647,31209540:31212692,31210076:31213024,31210574:31213233,31211134:31213385,31211680:31213457,31212170:31214554,31212712:31214596,31213096:31214708,31213705:31214809,31213706:31214853,31216863:31216934,31218182:31218374,31218476:31218620,31218740:31218930,31219017:31219223,31219297:31219347,31219561:31219994,31219772:31219956,31220372:31220593,31220638:31220829,31220877:31221074,31222441:31222648,31224145:31224281,31225046:31225226,31225314:31225500,31225946:31225995,31226633:31226756,31226972:31227152,31227429:31227638,31228205:31228261,31228566:31228782,31228847:31229041,31229143:31229410,31231373:31231479,31231606:31231633,31235309:31235466,31235583:31235883,31235809:31235951,31236344:31236484,31237077:31237935,31237639:31237837,31237970:31238201,31238577:31238692,31238810:3123896', 'assoc_mat': '31200282:pet_fonce:4230:31201067,31200290:pet_fonce:4230:31201317,31200304:pet_fonce:4230:31201913,31202289:pet_fonce:4230:31204398,31202757:pet_fonce:4230:31204467,31203016:pet_fonce:4230:31206049,31203018:pet_fonce:4230:31206187,31203019:pet_fonce:4230:31206214,31207815:pet_fonce:4230:31212273,31207817:pet_fonce:4230:31212321,31207818:pet_fonce:4230:31212362,31207819:pet_fonce:4230:31212410,31209020:pet_fonce:4230:31212647,31209540:pet_fonce:4230:31212692,31210076:pet_fonce:4230:31213024,31210574:pet_fonce:4230:31213233,31211134:pet_fonce:4230:31213385,31211680:pet_fonce:4230:31213457,31212170:pet_fonce:4230:31214554,31212712:pet_fonce:4230:31214596,31213096:pet_fonce:4230:31214708,31213705:pet_fonce:4230:31214809,31213706:pet_fonce:4230:31214853,31216863:pet_fonce:4230:31216934,31218182:pet_fonce:4230:31218374,31218476:pet_fonce:4230:31218620,31218740:pet_fonce:4230:31218930,31219017:pet_fonce:4230:31219223,31219297:pet_fonce:4230:31219347,31219561:pet_fonce:4230:31219994,31219772:pet_fonce:4230:31219956,3'}), 'main_stat': {'nb_photos': 1808}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31302791,31302792,31302793,31302794,31302795,31302796,31302797?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-07', 0.79195074322685),)]} 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': ((1808,),), 'unwanted_material_monthly_percentage': ((0.79195074322685,),), 'material_repartition': (('incineration', 1808),), 'material_dict': {'incineration': 1808}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 7, 1), 0.830574409534932, 1), (datetime.date(2026, 7, 2), 0.7725579231231258, 2), (datetime.date(2026, 7, 3), 0.7305970185801278, 1), (datetime.date(2026, 7, 4), 0.7386331722076744, 2), (datetime.date(2026, 7, 5), 0.8266119233994701, 2), (datetime.date(2026, 7, 6), 0.8404057826640864, 2), (datetime.date(2026, 7, 7), 0.8040359407771097, 3), (datetime.date(2026, 7, 8), 0.7926164586794533, 2), (datetime.date(2026, 7, 9), 0.8030511693170649, 2), (datetime.date(2026, 7, 10), 0.6559375983918322, 2), (datetime.date(2026, 7, 11), 0.6679445613098494, 3), (datetime.date(2026, 7, 12), 0.7428260817948962, 3), (datetime.date(2026, 7, 13), 0.8209298654715089, 2), (datetime.date(2026, 7, 14), 0.8488809040851504, 3), (datetime.date(2026, 7, 15), 0.8868393763933369, 2), (datetime.date(2026, 7, 16), 0.8883366932835887, 3), (datetime.date(2026, 7, 17), 0.8685081310541171, 3), (datetime.date(2026, 7, 18), 0.8494036578885326, 3), (datetime.date(2026, 7, 19), 0.8805253302321996, 3), (datetime.date(2026, 7, 20), 0.8638673424104237, 3), (datetime.date(2026, 7, 21), 0.8112258057241046, 3), (datetime.date(2026, 7, 22), 0.7953679711199227, 3), (datetime.date(2026, 7, 23), 0.7364060014336886, 3), (datetime.date(2026, 7, 24), 0.696544799106259, 3), (datetime.date(2026, 7, 25), 0.7305573818488151, 2), (datetime.date(2026, 7, 26), 0.76301672193645, 2), (datetime.date(2026, 7, 27), 0.7292398613221802, 2), (datetime.date(2026, 7, 28), 0.7876114919084376, 3), (datetime.date(2026, 7, 29), 0.8464218495200986, 3), (datetime.date(2026, 7, 30), 0.710612789628917, 2), (datetime.date(2026, 7, 31), 0.7211185672909245, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 7, 1), 0.830574409534932, 1), (datetime.date(2026, 7, 2), 0.7725579231231258, 2), (datetime.date(2026, 7, 3), 0.7305970185801278, 1), (datetime.date(2026, 7, 4), 0.7386331722076744, 2), (datetime.date(2026, 7, 5), 0.8266119233994701, 2), (datetime.date(2026, 7, 6), 0.8404057826640864, 2), (datetime.date(2026, 7, 7), 0.8040359407771097, 3), (datetime.date(2026, 7, 8), 0.7926164586794533, 2), (datetime.date(2026, 7, 9), 0.8030511693170649, 2), (datetime.date(2026, 7, 10), 0.6559375983918322, 2), (datetime.date(2026, 7, 11), 0.6679445613098494, 3), (datetime.date(2026, 7, 12), 0.7428260817948962, 3), (datetime.date(2026, 7, 13), 0.8209298654715089, 2), (datetime.date(2026, 7, 14), 0.8488809040851504, 3), (datetime.date(2026, 7, 15), 0.8868393763933369, 2), (datetime.date(2026, 7, 16), 0.8883366932835887, 3), (datetime.date(2026, 7, 17), 0.8685081310541171, 3), (datetime.date(2026, 7, 18), 0.8494036578885326, 3), (datetime.date(2026, 7, 19), 0.8805253302321996, 3), (datetime.date(2026, 7, 20), 0.8638673424104237, 3), (datetime.date(2026, 7, 21), 0.8112258057241046, 3), (datetime.date(2026, 7, 22), 0.7953679711199227, 3), (datetime.date(2026, 7, 23), 0.7364060014336886, 3), (datetime.date(2026, 7, 24), 0.696544799106259, 3), (datetime.date(2026, 7, 25), 0.7305573818488151, 2), (datetime.date(2026, 7, 26), 0.76301672193645, 2), (datetime.date(2026, 7, 27), 0.7292398613221802, 2), (datetime.date(2026, 7, 28), 0.7876114919084376, 3), (datetime.date(2026, 7, 29), 0.8464218495200986, 3), (datetime.date(2026, 7, 30), 0.710612789628917, 2), (datetime.date(2026, 7, 31), 0.7211185672909245, 4))}, 'quality_array': [['-7.261808690071288', '01072026'], ['-7.763701593137046', '02072026'], ['-7.7976123411089695', '03072026'], ['-7.619326591586537', '04072026'], ['-7.839831168936529', '05072026'], ['-7.941305052684', '06072026'], ['-7.976512810620059', '07072026'], ['-8.09846742894104', '08072026'], ['-7.505729735795942', '09072026'], ['-8.37347364559421', '10072026'], ['-8.504673477144303', '11072026'], ['-8.824789680243459', '12072026'], ['-8.228346641780844', '13072026'], ['-8.265685931758266', '14072026'], ['-7.279718317668015', '15072026'], ['-6.6796985918339535', '16072026'], ['-6.331562020737288', '17072026'], ['-6.656510916648004', '18072026'], ['-6.71088757190879', '19072026'], ['-6.661509923651142', '20072026'], ['-7.255757744880323', '21072026'], ['-7.860795133831168', '22072026'], ['-7.994614633581421', '23072026'], ['-8.218222332660385', '24072026'], ['-8.2370636059866', '25072026'], ['-8.099671902131426', '26072026'], ['-7.393033249047379', '27072026'], ['-7.328218119775821', '28072026'], ['-7.61682202706101', '29072026'], ['-7.550689181351694', '30072026'], ['-7.882297209849404', '31072026']], 'number_of_batch': ((682,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013650217983355228, 'nb_photo': 13319, 'list_port_cont': '31201051,31201237,31201319,31201391,31201529,31201607,31201792,31201911,31201980,31203110,31203261,31203305,31203371,31203413,31204322,31204384,31204471,31205665,31205709,31205748,31205789,31205826,31205867,31205897,31205961,31206006,31206057,31206089,31206135,31206178,31206227,31206255,31206306,31206348,31206393,31206448,31206496,31206526,31206575,31211867,31211913,31211973,31212007,31212259,31212311,31212353,31212420,31212452,31212487,31212545,31212591,31212649,31212689,31213026,31213226,31213370,31213451,31214559,31214598,31214707,31214794,31214846,31215384,31215421,31215476,31215905,31216082,31216108,31216661,31216894,31216925,31217641,31217805,31217866,31218369,31218621,31218920,31219207,31219343,31219959,31219991,31220277,31220584,31220830,31221076,31221345,31221573,31221866,31222087,31222397,31222566,31222661,31223020,31223291,31223551,31223815,31224057,31224282,31224321,31224963,31225213,31225501,31225996,31226145,31226305,31226750,31226782,31227141,31227631,31227734,31228056,31228274,31228778,3122903', 'assoc_port': '31200282:31201051,31200285:31203305,31200288:31201237,31200290:31201319,31200293:31201391,31200295:31201529,31200298:31201607,31200300:31204322,31200302:31201792,31200304:31201911,31200306:31201980,31200435:31203110,31200918:31203261,31201389:31203371,31201853:31203413,31202289:31204384,31202757:31204471,31203005:31205665,31203006:31205709,31203007:31205748,31203008:31205789,31203009:31205826,31203011:31206135,31203012:31205867,31203013:31205897,31203014:31205961,31203015:31206006,31203016:31206057,31203017:31206089,31203018:31206178,31203019:31206227,31203020:31206255,31203021:31206306,31203022:31206348,31203023:31206393,31203024:31206448,31203025:31206496,31203026:31206526,31203027:31206575,31205934:31211867,31206481:31211913,31207020:31211973,31207501:31212007,31207815:31212259,31207817:31212311,31207818:31212353,31207819:31212420,31207820:31212452,31207821:31212487,31207963:31212545,31208466:31212591,31209020:31212649,31209540:31212689,31210076:31213026,31210574:31213226,31211134:31213370,31211680:3121345', 'assoc_mat': '31200282:autre:4230:31201051,31200285:autre:4230:31203305,31200288:autre:4230:31201237,31200290:autre:4230:31201319,31200293:autre:4230:31201391,31200295:autre:4230:31201529,31200298:autre:4230:31201607,31200300:autre:4230:31204322,31200302:autre:4230:31201792,31200304:autre:4230:31201911,31200306:autre:4230:31201980,31200435:autre:4230:31203110,31200918:autre:4230:31203261,31201389:autre:4230:31203371,31201853:autre:4230:31203413,31202289:autre:4230:31204384,31202757:autre:4230:31204471,31203005:autre:4230:31205665,31203006:autre:4230:31205709,31203007:autre:4230:31205748,31203008:autre:4230:31205789,31203009:autre:4230:31205826,31203011:autre:4230:31206135,31203012:autre:4230:31205867,31203013:autre:4230:31205897,31203014:autre:4230:31205961,31203015:autre:4230:31206006,31203016:autre:4230:31206057,31203017:autre:4230:31206089,31203018:autre:4230:31206178,31203019:autre:4230:31206227,31203020:autre:4230:31206255,31203021:autre:4230:31206306,31203022:autre:4230:31206348,31203023:autre:4230:31206393,31203024:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03948303942476122, 'nb_photo': 59482, 'list_port_cont': '31201060,31201232,31201323,31201408,31201537,31201622,31201784,31201915,31201992,31203114,31203256,31203302,31203382,31203418,31204325,31204392,31204474,31205661,31205710,31205741,31205785,31205825,31205870,31205910,31205950,31206001,31206047,31206097,31206139,31206189,31206225,31206269,31206311,31206357,31206402,31206453,31206497,31206541,31206591,31211866,31211917,31211959,31212015,31212272,31212325,31212358,31212413,31212454,31212498,31212546,31212589,31212653,31212683,31213020,31213223,31213386,31213466,31214561,31214599,31214709,31214804,31214859,31215390,31215428,31215478,31215906,31216070,31216116,31216646,31216896,31216936,31217635,31217815,31217876,31218370,31218622,31218932,31219215,31219350,31219966,31220000,31220272,31220595,31220824,31221085,31221354,31221577,31221862,31222088,31222393,31222579,31222659,31223033,31223288,31223557,31223830,31224059,31224279,31224323,31224960,31225217,31225496,31226003,31226142,31226322,31226748,31226793,31227155,31227630,31227731,31228057,31228270,31228790,3122904', 'assoc_port': '31200282:31201060,31200285:31203302,31200288:31201232,31200290:31201323,31200293:31201408,31200295:31201537,31200298:31201622,31200300:31204325,31200302:31201784,31200304:31201915,31200306:31201992,31200435:31203114,31200918:31203256,31201389:31203382,31201853:31203418,31202289:31204392,31202757:31204474,31203005:31205661,31203006:31205710,31203007:31205741,31203008:31205785,31203009:31205825,31203011:31206139,31203012:31205870,31203013:31205910,31203014:31205950,31203015:31206001,31203016:31206047,31203017:31206097,31203018:31206189,31203019:31206225,31203020:31206269,31203021:31206311,31203022:31206357,31203023:31206402,31203024:31206453,31203025:31206497,31203026:31206541,31203027:31206591,31205934:31211866,31206481:31211917,31207020:31211959,31207501:31212015,31207815:31212272,31207817:31212325,31207818:31212358,31207819:31212413,31207820:31212454,31207821:31212498,31207963:31212546,31208466:31212589,31209020:31212653,31209540:31212683,31210076:31213020,31210574:31213223,31211134:31213386,31211680:3121346', 'assoc_mat': '31200282:carton:4230:31201060,31200285:carton:4230:31203302,31200288:carton:4230:31201232,31200290:carton:4230:31201323,31200293:carton:4230:31201408,31200295:carton:4230:31201537,31200298:carton:4230:31201622,31200300:carton:4230:31204325,31200302:carton:4230:31201784,31200304:carton:4230:31201915,31200306:carton:4230:31201992,31200435:carton:4230:31203114,31200918:carton:4230:31203256,31201389:carton:4230:31203382,31201853:carton:4230:31203418,31202289:carton:4230:31204392,31202757:carton:4230:31204474,31203005:carton:4230:31205661,31203006:carton:4230:31205710,31203007:carton:4230:31205741,31203008:carton:4230:31205785,31203009:carton:4230:31205825,31203011:carton:4230:31206139,31203012:carton:4230:31205870,31203013:carton:4230:31205910,31203014:carton:4230:31205950,31203015:carton:4230:31206001,31203016:carton:4230:31206047,31203017:carton:4230:31206097,31203018:carton:4230:31206189,31203019:carton:4230:31206225,31203020:carton:4230:31206269,31203021:carton:4230:31206311,31203022:carton:4230:31206357,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010529250396589607, 'nb_photo': 1061, 'list_port_cont': '31201053,31201307,31201781,31201985,31203379,31205695,31205902,31205946,31206042,31206399,31206449,31212008,31212324,31212359,31212441,31212501,31212544,31212588,31212645,31213012,31213219,31213450,31214546,31214796,31214860,31215392,31215475,31216888,31216929,31217632,31217802,31217868,31218360,31218618,31218926,31219220,31219341,31219961,31219996,31220261,31220594,31220832,31221576,31221864,31222082,31222386,31222570,31222660,31223021,31223293,31223558,31223817,31224058,31224285,31224322,31225497,31226753,31226783,31227150,31227642,31228272,31228795,31229047,31229407,31229457,31229793,31230236,31230512,31231028,31231631,31233043,31235458,31235892,31235940,31236194,31236477,31236726,31236957,31237931,31238697,31239622,31240486,31241076,31241475,31241578,31241772,31242864,31244367,31244455,31244596,31244782,31244812,31244861,31244901,31244935,31244989,31245163,31245277,31245324,31245732,31246094,31247036,31247261,31247402,31247875,31247943,31248002,31248039,31248566,31248646,31248951,31249011,31249320,3124944', 'assoc_port': '31200282:31201053,31200290:31201307,31200302:31201781,31200306:31201985,31201389:31203379,31203006:31205695,31203013:31205902,31203014:31205946,31203016:31206042,31203023:31206399,31203024:31206449,31207501:31212008,31207817:31212324,31207818:31212359,31207820:31212441,31207821:31212501,31207963:31212544,31208466:31212588,31209020:31212645,31210076:31213012,31210574:31213219,31211680:31213450,31212170:31214546,31213705:31214796,31213706:31214860,31214633:31215392,31214978:31215475,31216863:31216929,31216864:31216888,31217436:31217632,31217697:31217868,31217698:31217802,31218182:31218360,31218476:31218618,31218740:31218926,31219017:31219220,31219297:31219341,31219561:31219996,31219772:31219961,31220094:31220261,31220372:31220594,31220638:31220832,31221404:31221576,31221636:31221864,31221910:31222082,31222175:31222386,31222441:31222660,31222443:31222570,31222850:31223021,31223115:31223293,31223378:31223558,31223612:31223817,31223876:31224058,31224145:31224285,31224146:31224322,31225314:31225497,31226633:3122675', 'assoc_mat': '31200282:metal:4230:31201053,31200290:metal:4230:31201307,31200302:metal:4230:31201781,31200306:metal:4230:31201985,31201389:metal:4230:31203379,31203006:metal:4230:31205695,31203013:metal:4230:31205902,31203014:metal:4230:31205946,31203016:metal:4230:31206042,31203023:metal:4230:31206399,31203024:metal:4230:31206449,31207501:metal:4230:31212008,31207817:metal:4230:31212324,31207818:metal:4230:31212359,31207820:metal:4230:31212441,31207821:metal:4230:31212501,31207963:metal:4230:31212544,31208466:metal:4230:31212588,31209020:metal:4230:31212645,31210076:metal:4230:31213012,31210574:metal:4230:31213219,31211680:metal:4230:31213450,31212170:metal:4230:31214546,31213705:metal:4230:31214796,31213706:metal:4230:31214860,31214633:metal:4230:31215392,31214978:metal:4230:31215475,31216863:metal:4230:31216929,31216864:metal:4230:31216888,31217436:metal:4230:31217632,31217697:metal:4230:31217868,31217698:metal:4230:31217802,31218182:metal:4230:31218360,31218476:metal:4230:31218618,31218740:metal:4230:31218926,31219017:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16966531396940623, 'nb_photo': 232954, 'list_port_cont': '31201057,31201233,31201320,31201405,31201531,31201614,31201782,31201910,31201982,31203120,31203259,31203303,31203380,31203414,31204318,31204394,31204468,31205660,31205698,31205747,31205784,31205821,31205872,31205909,31205954,31206002,31206056,31206098,31206145,31206176,31206219,31206257,31206315,31206355,31206404,31206460,31206486,31206539,31206590,31211868,31211915,31211966,31212005,31212264,31212319,31212351,31212414,31212451,31212500,31212552,31212595,31212643,31212688,31213022,31213232,31213379,31213460,31214557,31214593,31214700,31214801,31214850,31215391,31215422,31215479,31215910,31216081,31216114,31216653,31216897,31216935,31217639,31217806,31217877,31218372,31218614,31218921,31219221,31219345,31219964,31219999,31220268,31220589,31220828,31221086,31221352,31221581,31221863,31222074,31222395,31222580,31222656,31223029,31223292,31223560,31223818,31224064,31224284,31224320,31224966,31225229,31225490,31226010,31226139,31226320,31226758,31226784,31227144,31227643,31227727,31228061,31228269,31228792,3122904', 'assoc_port': '31200282:31201057,31200285:31203303,31200288:31201233,31200290:31201320,31200293:31201405,31200295:31201531,31200298:31201614,31200300:31204318,31200302:31201782,31200304:31201910,31200306:31201982,31200435:31203120,31200918:31203259,31201389:31203380,31201853:31203414,31202289:31204394,31202757:31204468,31203005:31205660,31203006:31205698,31203007:31205747,31203008:31205784,31203009:31205821,31203011:31206145,31203012:31205872,31203013:31205909,31203014:31205954,31203015:31206002,31203016:31206056,31203017:31206098,31203018:31206176,31203019:31206219,31203020:31206257,31203021:31206315,31203022:31206355,31203023:31206404,31203024:31206460,31203025:31206486,31203026:31206539,31203027:31206590,31205934:31211868,31206481:31211915,31207020:31211966,31207501:31212005,31207815:31212264,31207817:31212319,31207818:31212351,31207819:31212414,31207820:31212451,31207821:31212500,31207963:31212552,31208466:31212595,31209020:31212643,31209540:31212688,31210076:31213022,31210574:31213232,31211134:31213379,31211680:3121346', 'assoc_mat': '31200282:papier:4230:31201057,31200285:papier:4230:31203303,31200288:papier:4230:31201233,31200290:papier:4230:31201320,31200293:papier:4230:31201405,31200295:papier:4230:31201531,31200298:papier:4230:31201614,31200300:papier:4230:31204318,31200302:papier:4230:31201782,31200304:papier:4230:31201910,31200306:papier:4230:31201982,31200435:papier:4230:31203120,31200918:papier:4230:31203259,31201389:papier:4230:31203380,31201853:papier:4230:31203414,31202289:papier:4230:31204394,31202757:papier:4230:31204468,31203005:papier:4230:31205660,31203006:papier:4230:31205698,31203007:papier:4230:31205747,31203008:papier:4230:31205784,31203009:papier:4230:31205821,31203011:papier:4230:31206145,31203012:papier:4230:31205872,31203013:papier:4230:31205909,31203014:papier:4230:31205954,31203015:papier:4230:31206002,31203016:papier:4230:31206056,31203017:papier:4230:31206098,31203018:papier:4230:31206176,31203019:papier:4230:31206219,31203020:papier:4230:31206257,31203021:papier:4230:31206315,31203022:papier:4230:31206355,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024398486162732352, 'nb_photo': 851, 'list_port_cont': '31201236,31201407,31201621,31201795,31201914,31201989,31203292,31204472,31205751,31205911,31205962,31206051,31206141,31211972,31212269,31212326,31212419,31212447,31212550,31212594,31212650,31212690,31213229,31213381,31213461,31214551,31214806,31214857,31215389,31216076,31216656,31216932,31218612,31218923,31219224,31219342,31219962,31220004,31221081,31223287,31223555,31223826,31224066,31224311,31224959,31225223,31226007,31226144,31227153,31227639,31227732,31228059,31228786,31229463,31230516,31230752,31231017,31231291,31231481,31231626,31231966,31233047,31233257,31233382,31234622,31234851,31235208,31235463,31235953,31236195,31236483,31238700,31238968,31239390,31239623,31239923,31240175,31240495,31240754,31241072,31241473,31241827,31242859,31244092,31244288,31244991,31245730,31246103,31247050,31247258,31247887,31247949,31248038,31248578,31248657,31249004,31249325,31249462,31250016,31250182,31250977,31251496,31251789,31252106,31252417,31252753,31253215,31253314,31253583,31253900,31254174,31254716,31254765,3125479', 'assoc_port': '31200285:31203292,31200288:31201236,31200293:31201407,31200298:31201621,31200302:31201795,31200304:31201914,31200306:31201989,31202757:31204472,31203007:31205751,31203011:31206141,31203013:31205911,31203014:31205962,31203016:31206051,31207020:31211972,31207815:31212269,31207817:31212326,31207819:31212419,31207820:31212447,31207963:31212550,31208466:31212594,31209020:31212650,31209540:31212690,31210574:31213229,31211134:31213381,31211680:31213461,31212170:31214551,31213705:31214806,31213706:31214857,31214633:31215389,31215631:31216076,31216552:31216656,31216863:31216932,31218476:31218612,31218740:31218923,31219017:31219224,31219297:31219342,31219561:31220004,31219772:31219962,31220877:31221081,31223115:31223287,31223378:31223555,31223612:31223826,31223876:31224066,31224146:31224311,31224791:31224959,31225046:31225223,31225946:31226007,31225947:31226144,31226972:31227153,31227429:31227639,31227662:31227732,31228011:31228059,31228566:31228786,31229387:31229463,31230354:31230516,31230575:31230752,31230837:3123101', 'assoc_mat': '31200285:pehd:4230:31203292,31200288:pehd:4230:31201236,31200293:pehd:4230:31201407,31200298:pehd:4230:31201621,31200302:pehd:4230:31201795,31200304:pehd:4230:31201914,31200306:pehd:4230:31201989,31202757:pehd:4230:31204472,31203007:pehd:4230:31205751,31203011:pehd:4230:31206141,31203013:pehd:4230:31205911,31203014:pehd:4230:31205962,31203016:pehd:4230:31206051,31207020:pehd:4230:31211972,31207815:pehd:4230:31212269,31207817:pehd:4230:31212326,31207819:pehd:4230:31212419,31207820:pehd:4230:31212447,31207963:pehd:4230:31212550,31208466:pehd:4230:31212594,31209020:pehd:4230:31212650,31209540:pehd:4230:31212690,31210574:pehd:4230:31213229,31211134:pehd:4230:31213381,31211680:pehd:4230:31213461,31212170:pehd:4230:31214551,31213705:pehd:4230:31214806,31213706:pehd:4230:31214857,31214633:pehd:4230:31215389,31215631:pehd:4230:31216076,31216552:pehd:4230:31216656,31216863:pehd:4230:31216932,31218476:pehd:4230:31218612,31218740:pehd:4230:31218923,31219017:pehd:4230:31219224,31219297:pehd:4230:31219342,31219561:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013239351106620733, 'nb_photo': 17160, 'list_port_cont': '31201061,31201238,31201314,31201404,31201530,31201612,31201791,31201917,31201991,31203117,31203265,31203295,31203381,31203420,31204319,31204400,31204465,31205664,31205706,31205746,31205788,31205819,31205865,31205912,31205960,31206005,31206054,31206095,31206136,31206180,31206218,31206268,31206304,31206353,31206406,31206457,31206500,31206536,31206589,31211865,31211906,31211968,31212011,31212262,31212323,31212352,31212415,31212449,31212502,31212540,31212590,31212651,31212687,31213027,31213227,31213387,31213463,31214556,31214600,31214710,31214802,31214856,31215393,31215427,31215484,31215901,31216071,31216111,31216660,31216898,31216930,31217636,31217818,31217875,31218377,31218616,31218933,31219219,31219352,31219963,31220005,31220273,31220580,31220827,31221087,31221357,31221579,31221865,31222078,31222394,31222575,31222655,31223025,31223279,31223559,31223829,31224054,31224283,31224308,31224969,31225225,31225492,31226006,31226136,31226321,31226757,31226791,31227151,31227634,31227721,31228058,31228271,31228794,3122903', 'assoc_port': '31200282:31201061,31200285:31203295,31200288:31201238,31200290:31201314,31200293:31201404,31200295:31201530,31200298:31201612,31200300:31204319,31200302:31201791,31200304:31201917,31200306:31201991,31200435:31203117,31200918:31203265,31201389:31203381,31201853:31203420,31202289:31204400,31202757:31204465,31203005:31205664,31203006:31205706,31203007:31205746,31203008:31205788,31203009:31205819,31203011:31206136,31203012:31205865,31203013:31205912,31203014:31205960,31203015:31206005,31203016:31206054,31203017:31206095,31203018:31206180,31203019:31206218,31203020:31206268,31203021:31206304,31203022:31206353,31203023:31206406,31203024:31206457,31203025:31206500,31203026:31206536,31203027:31206589,31205934:31211865,31206481:31211906,31207020:31211968,31207501:31212011,31207815:31212262,31207817:31212323,31207818:31212352,31207819:31212415,31207820:31212449,31207821:31212502,31207963:31212540,31208466:31212590,31209020:31212651,31209540:31212687,31210076:31213027,31210574:31213227,31211134:31213387,31211680:3121346', 'assoc_mat': '31200282:pet_clair:4230:31201061,31200285:pet_clair:4230:31203295,31200288:pet_clair:4230:31201238,31200290:pet_clair:4230:31201314,31200293:pet_clair:4230:31201404,31200295:pet_clair:4230:31201530,31200298:pet_clair:4230:31201612,31200300:pet_clair:4230:31204319,31200302:pet_clair:4230:31201791,31200304:pet_clair:4230:31201917,31200306:pet_clair:4230:31201991,31200435:pet_clair:4230:31203117,31200918:pet_clair:4230:31203265,31201389:pet_clair:4230:31203381,31201853:pet_clair:4230:31203420,31202289:pet_clair:4230:31204400,31202757:pet_clair:4230:31204465,31203005:pet_clair:4230:31205664,31203006:pet_clair:4230:31205706,31203007:pet_clair:4230:31205746,31203008:pet_clair:4230:31205788,31203009:pet_clair:4230:31205819,31203011:pet_clair:4230:31206136,31203012:pet_clair:4230:31205865,31203013:pet_clair:4230:31205912,31203014:pet_clair:4230:31205960,31203015:pet_clair:4230:31206005,31203016:pet_clair:4230:31206054,31203017:pet_clair:4230:31206095,31203018:pet_clair:4230:31206180,31203019:pet_clair:4230:31206218,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031708764483975136, 'nb_photo': 527, 'list_port_cont': '31201067,31201317,31201913,31204398,31204467,31206049,31206187,31206214,31212273,31212321,31212362,31212410,31212647,31212692,31213024,31213233,31213385,31213457,31214554,31214596,31214708,31214809,31214853,31216934,31218374,31218620,31218930,31219223,31219347,31219956,31219994,31220593,31220829,31221074,31222648,31224281,31225226,31225500,31225995,31226756,31227152,31227638,31228261,31228782,31229041,31229410,31231479,31231633,31235466,31235883,31235951,31236484,31237837,31237935,31238201,31238692,31238966,31240178,31244289,31245293,31247260,31247958,31248000,31248048,31248574,31248655,31248952,31249007,31249327,31249452,31250013,31250056,31250196,31250737,31250925,31251788,31252110,31252416,31252747,31253220,31253573,31253890,31254168,31254721,31254754,31254944,31255364,31255642,31257267,31257559,31257903,31257933,31258216,31258459,31258685,31259181,31259407,31259696,31259860,31260052,31260617,31261271,31261540,31261764,31261968,31263220,31264921,31265284,31265525,31265821,31265926,31266231,31266268,3126656', 'assoc_port': '31200282:31201067,31200290:31201317,31200304:31201913,31202289:31204398,31202757:31204467,31203016:31206049,31203018:31206187,31203019:31206214,31207815:31212273,31207817:31212321,31207818:31212362,31207819:31212410,31209020:31212647,31209540:31212692,31210076:31213024,31210574:31213233,31211134:31213385,31211680:31213457,31212170:31214554,31212712:31214596,31213096:31214708,31213705:31214809,31213706:31214853,31216863:31216934,31218182:31218374,31218476:31218620,31218740:31218930,31219017:31219223,31219297:31219347,31219561:31219994,31219772:31219956,31220372:31220593,31220638:31220829,31220877:31221074,31222441:31222648,31224145:31224281,31225046:31225226,31225314:31225500,31225946:31225995,31226633:31226756,31226972:31227152,31227429:31227638,31228205:31228261,31228566:31228782,31228847:31229041,31229143:31229410,31231373:31231479,31231606:31231633,31235309:31235466,31235583:31235883,31235809:31235951,31236344:31236484,31237077:31237935,31237639:31237837,31237970:31238201,31238577:31238692,31238810:3123896', 'assoc_mat': '31200282:pet_fonce:4230:31201067,31200290:pet_fonce:4230:31201317,31200304:pet_fonce:4230:31201913,31202289:pet_fonce:4230:31204398,31202757:pet_fonce:4230:31204467,31203016:pet_fonce:4230:31206049,31203018:pet_fonce:4230:31206187,31203019:pet_fonce:4230:31206214,31207815:pet_fonce:4230:31212273,31207817:pet_fonce:4230:31212321,31207818:pet_fonce:4230:31212362,31207819:pet_fonce:4230:31212410,31209020:pet_fonce:4230:31212647,31209540:pet_fonce:4230:31212692,31210076:pet_fonce:4230:31213024,31210574:pet_fonce:4230:31213233,31211134:pet_fonce:4230:31213385,31211680:pet_fonce:4230:31213457,31212170:pet_fonce:4230:31214554,31212712:pet_fonce:4230:31214596,31213096:pet_fonce:4230:31214708,31213705:pet_fonce:4230:31214809,31213706:pet_fonce:4230:31214853,31216863:pet_fonce:4230:31216934,31218182:pet_fonce:4230:31218374,31218476:pet_fonce:4230:31218620,31218740:pet_fonce:4230:31218930,31219017:pet_fonce:4230:31219223,31219297:pet_fonce:4230:31219347,31219561:pet_fonce:4230:31219994,31219772:pet_fonce:4230:31219956,3'}), 'main_stat': {'nb_photos': 1808}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31302791,31302792,31302793,31302794,31302795,31302796,31302797?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-07', 0.79195074322685),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_07_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.37%', 13319], 'carton': ['carton', '3.95%', 59482], 'metal': ['metal', '0.11%', 1061], 'papier': ['papier', '16.97%', 232954], 'pehd': ['pehd', '0.24%', 851], 'pet_clair': ['pet_clair', '1.32%', 17160], 'pet_fonce': ['pet_fonce', '0.32%', 527]}} 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_07_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.52user 2.81system 0:08.93elapsed 59%CPU (0avgtext+0avgdata 194332maxresident)k 24inputs+312outputs (8major+53452minor)pagefaults 0swaps