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_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-11 _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 : (5, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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 : (5, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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 : 204 month : 11 mtr_id : dashboard_places : SCCU_cam7 date : 2025-11 year : 2025 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_cam7' and date like '%2025-11%') and created_at like '%2025-11%'))); nb_day : (5, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 11 and year(ded.date) = 2025 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 = 204 and month(ded.date) = 11 and year(ded.date) = 2025 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 = 204 and mp.name like '%112025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-11-01 : dt_date_just_month_year : 2025-11-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_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-11-01" AND ded.date <= "2025-11-30" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} 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 (2501831,2503325,2510375,2519617,2528251,2537431,2546981,2553360,2556005,2563743,2571264,2578458,2584758,2592275,2598231,2598795,2605097,2612936,2621076,2668451,2634691,2638878,2639754,2644630,2651926,2658927,2664693,2671873,2676270,2677587) 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.014519781465732616, 'nb_photo': 14186, 'list_port_cont': '28067880,28068921,28069540,28069613,28069659,28069717,28069739,28069837,28069873,28069935,28069974,28070010,28070045,28070097,28070166,28070244,28070279,28070316,28070329,28070374,28070451,28070533,28075370,28075486,28075702,28075848,28075900,28076044,28076205,28076297,28076361,28076407,28076459,28076497,28076550,28076584,28076626,28076658,28076752,28076891,28077622,28077661,28117897,28121638,28122099,28122399,28122883,28123615,28124353,28124832,28126258,28126652,28127225,28128258,28128602,28129267,28130577,28130866,28131052,28131121,28132129,28133985,28134377,28134629,28135673,28181720,28183750,28184228,28184279,28184463,28184605,28184642,28184676,28184728,28184765,28184800,28184884,28184925,28184951,28184990,28185034,28185084,28185105,28185165,28229778,28233040,28236297,28236471,28236631,28236762,28236860,28236939,28237184,28237269,28237428,28237567,28237671,28237703,28237825,28237918,28238052,28238123,28240918,28330500,28330663,28330762,28330921,28331018,28331099,28331278,28331550,28331608,28331782,2833187', 'assoc_port': '28067787:28068921,28067788:28070451,28067789:28069540,28067790:28069613,28067791:28069974,28067792:28070045,28067793:28070374,28067794:28070329,28067795:28070166,28067796:28070316,28067797:28070244,28067798:28070097,28067799:28070010,28067801:28070279,28067804:28069935,28067807:28069873,28067810:28069717,28067813:28069659,28067817:28069739,28067820:28067880,28069259:28069837,28070470:28070533,28075301:28075370,28075302:28075486,28075303:28075702,28075305:28075848,28075307:28075900,28075309:28076044,28075311:28076205,28075313:28076297,28075315:28076584,28075317:28076626,28075319:28076497,28075321:28076658,28075324:28076550,28075327:28077622,28075330:28076407,28075333:28077661,28075336:28076361,28075339:28076459,28076694:28076752,28076878:28076891,28111813:28117897,28119041:28131121,28119044:28131052,28119047:28130866,28119050:28130577,28119053:28135673,28119057:28134629,28119059:28134377,28119063:28129267,28119077:28127225,28119086:28132129,28119101:28126652,28119124:28124832,28119128:28124353,28119132:2812860', 'assoc_mat': '28067787:autre:4230:28068921,28067788:autre:4230:28070451,28067789:autre:4230:28069540,28067790:autre:4230:28069613,28067791:autre:4230:28069974,28067792:autre:4230:28070045,28067793:autre:4230:28070374,28067794:autre:4230:28070329,28067795:autre:4230:28070166,28067796:autre:4230:28070316,28067797:autre:4230:28070244,28067798:autre:4230:28070097,28067799:autre:4230:28070010,28067801:autre:4230:28070279,28067804:autre:4230:28069935,28067807:autre:4230:28069873,28067810:autre:4230:28069717,28067813:autre:4230:28069659,28067817:autre:4230:28069739,28067820:autre:4230:28067880,28069259:autre:4230:28069837,28070470:autre:4230:28070533,28075301:autre:4230:28075370,28075302:autre:4230:28075486,28075303:autre:4230:28075702,28075305:autre:4230:28075848,28075307:autre:4230:28075900,28075309:autre:4230:28076044,28075311:autre:4230:28076205,28075313:autre:4230:28076297,28075315:autre:4230:28076584,28075317:autre:4230:28076626,28075319:autre:4230:28076497,28075321:autre:4230:28076658,28075324:autre:4230:28076550,28075327:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.054933396851168756, 'nb_photo': 88049, 'list_port_cont': '28067883,28068917,28069537,28069621,28069660,28069731,28069732,28069841,28069870,28069945,28069982,28070020,28070053,28070094,28070168,28070237,28070277,28070312,28070328,28070389,28070448,28070537,28075376,28075494,28075711,28075862,28075887,28076041,28076203,28076291,28076370,28076410,28076464,28076495,28076555,28076589,28076627,28076666,28076756,28076907,28077633,28077660,28117893,28121628,28122106,28122395,28122884,28123619,28124354,28124830,28126263,28126654,28127227,28128262,28128610,28129276,28130576,28130859,28131062,28131131,28132128,28133996,28134391,28134624,28135676,28181734,28183751,28184225,28184278,28184464,28184602,28184641,28184684,28184743,28184770,28184807,28184888,28184924,28184965,28184997,28185044,28185089,28185108,28185160,28229789,28233045,28236300,28236475,28236633,28236761,28236866,28236935,28237175,28237272,28237429,28237575,28237668,28237701,28237826,28237915,28238061,28238135,28240923,28330497,28330674,28330779,28330938,28331019,28331111,28331272,28331558,28331599,28331783,2833188', 'assoc_port': '28067787:28068917,28067788:28070448,28067789:28069537,28067790:28069621,28067791:28069982,28067792:28070053,28067793:28070389,28067794:28070328,28067795:28070168,28067796:28070312,28067797:28070237,28067798:28070094,28067799:28070020,28067801:28070277,28067804:28069945,28067807:28069870,28067810:28069732,28067813:28069660,28067817:28069731,28067820:28067883,28069259:28069841,28070470:28070537,28075301:28075376,28075302:28075494,28075303:28075711,28075305:28075862,28075307:28075887,28075309:28076041,28075311:28076203,28075313:28076291,28075315:28076589,28075317:28076627,28075319:28076495,28075321:28076666,28075324:28076555,28075327:28077633,28075330:28076410,28075333:28077660,28075336:28076370,28075339:28076464,28076694:28076756,28076878:28076907,28111813:28117893,28119041:28131131,28119044:28131062,28119047:28130859,28119050:28130576,28119053:28135676,28119057:28134624,28119059:28134391,28119063:28129276,28119077:28127227,28119086:28132128,28119101:28126654,28119124:28124830,28119128:28124354,28119132:2812861', 'assoc_mat': '28067787:carton:4230:28068917,28067788:carton:4230:28070448,28067789:carton:4230:28069537,28067790:carton:4230:28069621,28067791:carton:4230:28069982,28067792:carton:4230:28070053,28067793:carton:4230:28070389,28067794:carton:4230:28070328,28067795:carton:4230:28070168,28067796:carton:4230:28070312,28067797:carton:4230:28070237,28067798:carton:4230:28070094,28067799:carton:4230:28070020,28067801:carton:4230:28070277,28067804:carton:4230:28069945,28067807:carton:4230:28069870,28067810:carton:4230:28069732,28067813:carton:4230:28069660,28067817:carton:4230:28069731,28067820:carton:4230:28067883,28069259:carton:4230:28069841,28070470:carton:4230:28070537,28075301:carton:4230:28075376,28075302:carton:4230:28075494,28075303:carton:4230:28075711,28075305:carton:4230:28075862,28075307:carton:4230:28075887,28075309:carton:4230:28076041,28075311:carton:4230:28076203,28075313:carton:4230:28076291,28075315:carton:4230:28076589,28075317:carton:4230:28076627,28075319:carton:4230:28076495,28075321:carton:4230:28076666,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014380910318766789, 'nb_photo': 1629, 'list_port_cont': '28067878,28068932,28069549,28069617,28069657,28069741,28069746,28069834,28069868,28069941,28069972,28070024,28070088,28070163,28070235,28070275,28070315,28070335,28070390,28070434,28070530,28075367,28075483,28075710,28076037,28076208,28076303,28076365,28076411,28076450,28076499,28076556,28076633,28076660,28076905,28077616,28077654,28117896,28121637,28122101,28122391,28122873,28123621,28124350,28124823,28126655,28127221,28128260,28128611,28129271,28130575,28130870,28131058,28131126,28132120,28134373,28134634,28135667,28181732,28183749,28184226,28184276,28184460,28184606,28184633,28184669,28184733,28184774,28184808,28184875,28184923,28184949,28184985,28185026,28185091,28185103,28185169,28229776,28233041,28236292,28236477,28236622,28236749,28236872,28236932,28237180,28237260,28237422,28237577,28237666,28237707,28237815,28237921,28238051,28238136,28240921,28330499,28330664,28330768,28330922,28331007,28331101,28331256,28331557,28331598,28331776,28331888,28332112,28332178,28332275,28332393,28332443,28332518,2833274', 'assoc_port': '28067787:28068932,28067788:28070434,28067789:28069549,28067790:28069617,28067791:28069972,28067793:28070390,28067794:28070335,28067795:28070163,28067796:28070315,28067797:28070235,28067798:28070088,28067799:28070024,28067801:28070275,28067804:28069941,28067807:28069868,28067810:28069746,28067813:28069657,28067817:28069741,28067820:28067878,28069259:28069834,28070470:28070530,28075301:28075367,28075302:28075483,28075303:28075710,28075309:28076037,28075311:28076208,28075313:28076303,28075317:28076633,28075319:28076499,28075321:28076660,28075324:28076556,28075327:28077616,28075330:28076411,28075333:28077654,28075336:28076365,28075339:28076450,28076878:28076905,28111813:28117896,28119041:28131126,28119044:28131058,28119047:28130870,28119050:28130575,28119053:28135667,28119057:28134634,28119059:28134373,28119063:28129271,28119077:28127221,28119086:28132120,28119101:28126655,28119124:28124823,28119128:28124350,28119132:28128611,28119135:28123621,28119139:28122873,28119146:28122391,28119150:28122101,28121341:2812163', 'assoc_mat': '28067787:metal:4230:28068932,28067788:metal:4230:28070434,28067789:metal:4230:28069549,28067790:metal:4230:28069617,28067791:metal:4230:28069972,28067793:metal:4230:28070390,28067794:metal:4230:28070335,28067795:metal:4230:28070163,28067796:metal:4230:28070315,28067797:metal:4230:28070235,28067798:metal:4230:28070088,28067799:metal:4230:28070024,28067801:metal:4230:28070275,28067804:metal:4230:28069941,28067807:metal:4230:28069868,28067810:metal:4230:28069746,28067813:metal:4230:28069657,28067817:metal:4230:28069741,28067820:metal:4230:28067878,28069259:metal:4230:28069834,28070470:metal:4230:28070530,28075301:metal:4230:28075367,28075302:metal:4230:28075483,28075303:metal:4230:28075710,28075309:metal:4230:28076037,28075311:metal:4230:28076208,28075313:metal:4230:28076303,28075317:metal:4230:28076633,28075319:metal:4230:28076499,28075321:metal:4230:28076660,28075324:metal:4230:28076556,28075327:metal:4230:28077616,28075330:metal:4230:28076411,28075333:metal:4230:28077654,28075336:metal:4230:28076365,28075339:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1696267901886624, 'nb_photo': 252150, 'list_port_cont': '28067881,28068931,28069547,28069619,28069651,28069730,28069752,28069835,28069874,28069938,28069986,28070025,28070054,28070090,28070170,28070243,28070272,28070314,28070323,28070386,28070444,28070535,28075381,28075493,28075715,28075856,28075899,28076029,28076211,28076300,28076374,28076406,28076466,28076501,28076554,28076586,28076625,28076662,28076755,28076897,28077623,28077670,28117901,28121631,28122097,28122402,28122885,28123618,28124343,28124820,28126264,28126653,28127234,28128271,28128608,28129275,28130568,28130869,28131053,28131128,28132126,28133995,28134393,28134636,28135681,28181731,28183757,28184219,28184277,28184465,28184608,28184634,28184679,28184744,28184769,28184815,28184882,28184922,28184955,28184998,28185042,28185088,28185110,28185170,28229795,28233051,28236303,28236481,28236630,28236760,28236874,28236927,28237182,28237265,28237426,28237576,28237670,28237705,28237821,28237920,28238049,28238133,28240917,28330498,28330670,28330771,28330929,28331014,28331100,28331280,28331552,28331611,28331785,2833188', 'assoc_port': '28067787:28068931,28067788:28070444,28067789:28069547,28067790:28069619,28067791:28069986,28067792:28070054,28067793:28070386,28067794:28070323,28067795:28070170,28067796:28070314,28067797:28070243,28067798:28070090,28067799:28070025,28067801:28070272,28067804:28069938,28067807:28069874,28067810:28069730,28067813:28069651,28067817:28069752,28067820:28067881,28069259:28069835,28070470:28070535,28075301:28075381,28075302:28075493,28075303:28075715,28075305:28075856,28075307:28075899,28075309:28076029,28075311:28076211,28075313:28076300,28075315:28076586,28075317:28076625,28075319:28076501,28075321:28076662,28075324:28076554,28075327:28077623,28075330:28076406,28075333:28077670,28075336:28076374,28075339:28076466,28076694:28076755,28076878:28076897,28111813:28117901,28119041:28131128,28119044:28131053,28119047:28130869,28119050:28130568,28119053:28135681,28119057:28134636,28119059:28134393,28119063:28129275,28119077:28127234,28119086:28132126,28119101:28126653,28119124:28124820,28119128:28124343,28119132:2812860', 'assoc_mat': '28067787:papier:4230:28068931,28067788:papier:4230:28070444,28067789:papier:4230:28069547,28067790:papier:4230:28069619,28067791:papier:4230:28069986,28067792:papier:4230:28070054,28067793:papier:4230:28070386,28067794:papier:4230:28070323,28067795:papier:4230:28070170,28067796:papier:4230:28070314,28067797:papier:4230:28070243,28067798:papier:4230:28070090,28067799:papier:4230:28070025,28067801:papier:4230:28070272,28067804:papier:4230:28069938,28067807:papier:4230:28069874,28067810:papier:4230:28069730,28067813:papier:4230:28069651,28067817:papier:4230:28069752,28067820:papier:4230:28067881,28069259:papier:4230:28069835,28070470:papier:4230:28070535,28075301:papier:4230:28075381,28075302:papier:4230:28075493,28075303:papier:4230:28075715,28075305:papier:4230:28075856,28075307:papier:4230:28075899,28075309:papier:4230:28076029,28075311:papier:4230:28076211,28075313:papier:4230:28076300,28075315:papier:4230:28076586,28075317:papier:4230:28076625,28075319:papier:4230:28076501,28075321:papier:4230:28076662,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035544242628207257, 'nb_photo': 1769, 'list_port_cont': '28067886,28069546,28069624,28069652,28069747,28069748,28069840,28069869,28069981,28070021,28070087,28070171,28070233,28070281,28070305,28070330,28070391,28070532,28075490,28075718,28075863,28075897,28076043,28076206,28076375,28076404,28076462,28076491,28076553,28076664,28076748,28117898,28121634,28122100,28122400,28122879,28123625,28124349,28124824,28126266,28126658,28127233,28128617,28129274,28130569,28130867,28131051,28132132,28133984,28134365,28184215,28184281,28184453,28184610,28184647,28184681,28184740,28184779,28184817,28184959,28185028,28185094,28185164,28233050,28236306,28236476,28236618,28236759,28236862,28236938,28237176,28237266,28237432,28237573,28237667,28237924,28240922,28330490,28330672,28330778,28330925,28331017,28331113,28331268,28331553,28331614,28331890,28332124,28332181,28332277,28332410,28332444,28332761,28332863,28335613,28335820,28337503,28337542,28337688,28337961,28337980,28338068,28338247,28338717,28338947,28339032,28339069,28339216,28339284,28339333,28339387,28339512,28339741,2833979', 'assoc_port': '28067789:28069546,28067790:28069624,28067791:28069981,28067793:28070391,28067794:28070330,28067795:28070171,28067796:28070305,28067797:28070233,28067798:28070087,28067799:28070021,28067801:28070281,28067807:28069869,28067810:28069748,28067813:28069652,28067817:28069747,28067820:28067886,28069259:28069840,28070470:28070532,28075302:28075490,28075303:28075718,28075305:28075863,28075307:28075897,28075309:28076043,28075311:28076206,28075319:28076491,28075321:28076664,28075324:28076553,28075330:28076404,28075336:28076375,28075339:28076462,28076694:28076748,28111813:28117898,28119044:28131051,28119047:28130867,28119050:28130569,28119059:28134365,28119063:28129274,28119077:28127233,28119086:28132132,28119101:28126658,28119124:28124824,28119128:28124349,28119132:28128617,28119135:28123625,28119139:28122879,28119142:28133984,28119146:28122400,28119150:28122100,28119153:28126266,28121341:28121634,28181605:28185028,28181637:28184779,28181638:28185094,28181640:28185164,28181641:28184740,28181643:28184681,28181644:2818461', 'assoc_mat': '28067789:pehd:4230:28069546,28067790:pehd:4230:28069624,28067791:pehd:4230:28069981,28067793:pehd:4230:28070391,28067794:pehd:4230:28070330,28067795:pehd:4230:28070171,28067796:pehd:4230:28070305,28067797:pehd:4230:28070233,28067798:pehd:4230:28070087,28067799:pehd:4230:28070021,28067801:pehd:4230:28070281,28067807:pehd:4230:28069869,28067810:pehd:4230:28069748,28067813:pehd:4230:28069652,28067817:pehd:4230:28069747,28067820:pehd:4230:28067886,28069259:pehd:4230:28069840,28070470:pehd:4230:28070532,28075302:pehd:4230:28075490,28075303:pehd:4230:28075718,28075305:pehd:4230:28075863,28075307:pehd:4230:28075897,28075309:pehd:4230:28076043,28075311:pehd:4230:28076206,28075319:pehd:4230:28076491,28075321:pehd:4230:28076664,28075324:pehd:4230:28076553,28075330:pehd:4230:28076404,28075336:pehd:4230:28076375,28075339:pehd:4230:28076462,28076694:pehd:4230:28076748,28111813:pehd:4230:28117898,28119044:pehd:4230:28131051,28119047:pehd:4230:28130867,28119050:pehd:4230:28130569,28119059:pehd:4230:28134365,28119063:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01371419783021479, 'nb_photo': 20194, 'list_port_cont': '28067887,28068933,28069552,28069611,28069661,28069742,28069751,28069832,28069877,28069951,28069987,28070013,28070048,28070092,28070167,28070242,28070280,28070317,28070334,28070388,28070440,28070538,28075382,28075480,28075713,28075857,28075894,28076035,28076212,28076298,28076372,28076413,28076461,28076503,28076546,28076591,28076631,28076663,28076746,28076906,28077624,28077669,28117891,28121633,28122108,28122398,28122888,28123616,28124356,28124827,28126260,28126649,28127235,28128266,28128615,28129277,28130573,28130860,28131054,28131123,28132125,28133989,28134383,28134635,28135679,28181729,28183755,28184217,28184282,28184459,28184598,28184644,28184683,28184736,28184777,28184816,28184876,28184920,28184960,28184987,28185030,28185095,28185114,28185167,28229798,28233042,28236305,28236478,28236621,28236758,28236870,28236933,28237179,28237271,28237427,28237578,28237672,28237706,28237830,28237923,28238058,28238129,28240915,28330495,28330671,28330774,28330936,28331024,28331105,28331274,28331560,28331612,28331780,2833188', 'assoc_port': '28067787:28068933,28067788:28070440,28067789:28069552,28067790:28069611,28067791:28069987,28067792:28070048,28067793:28070388,28067794:28070334,28067795:28070167,28067796:28070317,28067797:28070242,28067798:28070092,28067799:28070013,28067801:28070280,28067804:28069951,28067807:28069877,28067810:28069742,28067813:28069661,28067817:28069751,28067820:28067887,28069259:28069832,28070470:28070538,28075301:28075382,28075302:28075480,28075303:28075713,28075305:28075857,28075307:28075894,28075309:28076035,28075311:28076212,28075313:28076298,28075315:28076591,28075317:28076631,28075319:28076503,28075321:28076663,28075324:28076546,28075327:28077624,28075330:28076413,28075333:28077669,28075336:28076372,28075339:28076461,28076694:28076746,28076878:28076906,28111813:28117891,28119041:28131123,28119044:28131054,28119047:28130860,28119050:28130573,28119053:28135679,28119057:28134635,28119059:28134383,28119063:28129277,28119077:28127235,28119086:28132125,28119101:28126649,28119124:28124827,28119128:28124356,28119132:2812861', 'assoc_mat': '28067787:pet_clair:4230:28068933,28067788:pet_clair:4230:28070440,28067789:pet_clair:4230:28069552,28067790:pet_clair:4230:28069611,28067791:pet_clair:4230:28069987,28067792:pet_clair:4230:28070048,28067793:pet_clair:4230:28070388,28067794:pet_clair:4230:28070334,28067795:pet_clair:4230:28070167,28067796:pet_clair:4230:28070317,28067797:pet_clair:4230:28070242,28067798:pet_clair:4230:28070092,28067799:pet_clair:4230:28070013,28067801:pet_clair:4230:28070280,28067804:pet_clair:4230:28069951,28067807:pet_clair:4230:28069877,28067810:pet_clair:4230:28069742,28067813:pet_clair:4230:28069661,28067817:pet_clair:4230:28069751,28067820:pet_clair:4230:28067887,28069259:pet_clair:4230:28069832,28070470:pet_clair:4230:28070538,28075301:pet_clair:4230:28075382,28075302:pet_clair:4230:28075480,28075303:pet_clair:4230:28075713,28075305:pet_clair:4230:28075857,28075307:pet_clair:4230:28075894,28075309:pet_clair:4230:28076035,28075311:pet_clair:4230:28076212,28075313:pet_clair:4230:28076298,28075315:pet_clair:4230:28076591,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0030076582100091, 'nb_photo': 661, 'list_port_cont': '28069653,28069721,28069738,28070018,28070056,28070098,28070240,28070274,28070333,28070385,28070534,28076465,28076632,28076669,28076750,28117903,28121625,28122103,28122390,28122880,28124831,28126255,28126651,28128257,28132134,28133993,28134371,28134633,28183754,28184609,28184640,28184680,28184742,28184773,28184812,28184928,28184964,28185040,28185090,28185157,28229790,28233055,28236298,28236483,28236629,28236867,28236931,28237183,28237263,28237418,28237574,28237665,28237831,28237913,28238060,28330493,28330675,28330776,28331021,28331109,28331276,28331607,28331878,28332173,28332445,28332528,28335617,28335802,28337504,28337964,28337971,28338248,28338711,28338951,28339021,28339060,28339278,28339718,28339743,28339979,28362851,28362925,28363107,28363340,28363405,28363518,28368446,28368515,28368683,28412742,28412792,28412953,28413098,28413255,28413316,28413448,28413658,28414076,28435578,28435852,28435891,28436210,28436497,28436620,28436756,28436935,28437051,28437119,28437197,28469824,28469868,28470032,28470084,2847020', 'assoc_port': '28067792:28070056,28067793:28070385,28067794:28070333,28067797:28070240,28067798:28070098,28067799:28070018,28067801:28070274,28067810:28069738,28067813:28069653,28067817:28069721,28070470:28070534,28075317:28076632,28075321:28076669,28075339:28076465,28076694:28076750,28111813:28117903,28119057:28134633,28119059:28134371,28119086:28132134,28119101:28126651,28119124:28124831,28119139:28122880,28119142:28133993,28119146:28122390,28119150:28122103,28119153:28126255,28121341:28121625,28123207:28128257,28181605:28185040,28181608:28184928,28181637:28184773,28181638:28185090,28181640:28185157,28181641:28184742,28181643:28184680,28181644:28184609,28181646:28184812,28181647:28184964,28181653:28184640,28183615:28183754,28229583:28238060,28229584:28237831,28229597:28237913,28229598:28237574,28229611:28237665,28229614:28237418,28229615:28237183,28229616:28237263,28229617:28236931,28229618:28236867,28229621:28236629,28229631:28236483,28229635:28236298,28229640:28229790,28232611:28233055,28276909:28339979,28276911:2833974', 'assoc_mat': '28067792:pet_fonce:4230:28070056,28067793:pet_fonce:4230:28070385,28067794:pet_fonce:4230:28070333,28067797:pet_fonce:4230:28070240,28067798:pet_fonce:4230:28070098,28067799:pet_fonce:4230:28070018,28067801:pet_fonce:4230:28070274,28067810:pet_fonce:4230:28069738,28067813:pet_fonce:4230:28069653,28067817:pet_fonce:4230:28069721,28070470:pet_fonce:4230:28070534,28075317:pet_fonce:4230:28076632,28075321:pet_fonce:4230:28076669,28075339:pet_fonce:4230:28076465,28076694:pet_fonce:4230:28076750,28111813:pet_fonce:4230:28117903,28119057:pet_fonce:4230:28134633,28119059:pet_fonce:4230:28134371,28119086:pet_fonce:4230:28132134,28119101:pet_fonce:4230:28126651,28119124:pet_fonce:4230:28124831,28119139:pet_fonce:4230:28122880,28119142:pet_fonce:4230:28133993,28119146:pet_fonce:4230:28122390,28119150:pet_fonce:4230:28122103,28119153:pet_fonce:4230:28126255,28121341:pet_fonce:4230:28121625,28123207:pet_fonce:4230:28128257,28181605:pet_fonce:4230:28185040,28181608:pet_fonce:4230:28184928,28181637:pet_fonce:4230:28184773,2'}) 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(2501831,2503325,2510375,2519617,2528251,2537431,2546981,2553360,2556005,2563743,2571264,2578458,2584758,2592275,2598231,2598795,2605097,2612936,2621076,2668451,2634691,2638878,2639754,2644630,2651926,2658927,2664693,2671873,2676270,2677587)); 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=204 and date >='2025-11-01' and date <= '2025-11-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1438,),), 'unwanted_material_monthly_percentage': ((0.7518545156661435,),), 'material_repartition': (('incineration', 1438),), 'material_dict': {'incineration': 1438}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 11, 1), 0.7086637498937932, 1), (datetime.date(2025, 11, 2), 0.7332753707484142, 1), (datetime.date(2025, 11, 3), 0.7290110702579551, 2), (datetime.date(2025, 11, 4), 0.7109235819886419, 1), (datetime.date(2025, 11, 5), 0.6812315840065326, 3), (datetime.date(2025, 11, 6), 0.6639823261046317, 1), (datetime.date(2025, 11, 7), 0.7041761535619381, 3), (datetime.date(2025, 11, 8), 0.7370359613950824, 2), (datetime.date(2025, 11, 9), 0.8285550197149263, 3), (datetime.date(2025, 11, 10), 0.7677874039985979, 2), (datetime.date(2025, 11, 11), 0.803390296972739, 1), (datetime.date(2025, 11, 12), 0.7703954321148463, 1), (datetime.date(2025, 11, 13), 0.734544261444827, 1), (datetime.date(2025, 11, 14), 0.7331286766925561, 3), (datetime.date(2025, 11, 15), 0.7415060162018934, 1), (datetime.date(2025, 11, 16), 0.7793553318538203, 1), (datetime.date(2025, 11, 17), 0.7672838553393281, 2), (datetime.date(2025, 11, 18), 0.7660241552716502, 3), (datetime.date(2025, 11, 19), 0.7332714880285166, 1), (datetime.date(2025, 11, 20), 0.7025880915135392, 1), (datetime.date(2025, 11, 21), 0.7150655975151947, 3), (datetime.date(2025, 11, 22), 0.7422553468631929, 1), (datetime.date(2025, 11, 23), 0.7801714108271633, 4), (datetime.date(2025, 11, 24), 0.7652646591950307, 1), (datetime.date(2025, 11, 25), 0.7403132670288509, 2), (datetime.date(2025, 11, 26), 0.7706224361360379, 2), (datetime.date(2025, 11, 27), 0.7517862355997502, 2), (datetime.date(2025, 11, 28), 0.7389462819449392, 4), (datetime.date(2025, 11, 29), 0.7993331918990682, 4), (datetime.date(2025, 11, 30), 0.8201406804601161, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 11, 1), 0.7086637498937932, 1), (datetime.date(2025, 11, 2), 0.7332753707484142, 1), (datetime.date(2025, 11, 3), 0.7290110702579551, 2), (datetime.date(2025, 11, 4), 0.7109235819886419, 1), (datetime.date(2025, 11, 5), 0.6812315840065326, 3), (datetime.date(2025, 11, 6), 0.6639823261046317, 1), (datetime.date(2025, 11, 7), 0.7041761535619381, 3), (datetime.date(2025, 11, 8), 0.7370359613950824, 2), (datetime.date(2025, 11, 9), 0.8285550197149263, 3), (datetime.date(2025, 11, 10), 0.7677874039985979, 2), (datetime.date(2025, 11, 11), 0.803390296972739, 1), (datetime.date(2025, 11, 12), 0.7703954321148463, 1), (datetime.date(2025, 11, 13), 0.734544261444827, 1), (datetime.date(2025, 11, 14), 0.7331286766925561, 3), (datetime.date(2025, 11, 15), 0.7415060162018934, 1), (datetime.date(2025, 11, 16), 0.7793553318538203, 1), (datetime.date(2025, 11, 17), 0.7672838553393281, 2), (datetime.date(2025, 11, 18), 0.7660241552716502, 3), (datetime.date(2025, 11, 19), 0.7332714880285166, 1), (datetime.date(2025, 11, 20), 0.7025880915135392, 1), (datetime.date(2025, 11, 21), 0.7150655975151947, 3), (datetime.date(2025, 11, 22), 0.7422553468631929, 1), (datetime.date(2025, 11, 23), 0.7801714108271633, 4), (datetime.date(2025, 11, 24), 0.7652646591950307, 1), (datetime.date(2025, 11, 25), 0.7403132670288509, 2), (datetime.date(2025, 11, 26), 0.7706224361360379, 2), (datetime.date(2025, 11, 27), 0.7517862355997502, 2), (datetime.date(2025, 11, 28), 0.7389462819449392, 4), (datetime.date(2025, 11, 29), 0.7993331918990682, 4), (datetime.date(2025, 11, 30), 0.8201406804601161, 4))}, 'quality_array': [['-8.398026474535236', '01112025'], ['-8.35888284478845', '02112025'], ['-8.067712051594576', '03112025'], ['-7.945102684379106', '04112025'], ['-8.01827628501776', '05112025'], ['-7.939596705364024', '06112025'], ['-8.000431349650002', '07112025'], ['-7.960625539708045', '08112025'], ['-7.963264628650207', '09112025'], ['-7.762440530888007', '10112025'], ['-8.019937644551614', '11112025'], ['-7.315776933762011', '12112025'], ['-7.551929792305123', '13112025'], ['-7.875581845569814', '14112025'], ['-7.5314049349273855', '15112025'], ['-7.831944554062369', '16112025'], ['-7.852364796691473', '17112025'], ['-7.3795018476000624', '18112025'], ['-7.418190275792029', '19112025'], ['-7.603041957247732', '20112025'], ['-7.336839236044747', '21112025'], ['-7.110018562568477', '22112025'], ['-7.628062587635092', '23112025'], ['-7.522823764403562', '24112025'], ['-7.767458264611627', '25112025'], ['-7.9844482669232875', '26112025'], ['-7.690024945504662', '27112025'], ['-7.742691221584303', '28112025'], ['-7.9997518334078555', '29112025'], ['-7.954428350200598', '30112025']], 'number_of_batch': ((637,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014519781465732616, 'nb_photo': 14186, 'list_port_cont': '28067880,28068921,28069540,28069613,28069659,28069717,28069739,28069837,28069873,28069935,28069974,28070010,28070045,28070097,28070166,28070244,28070279,28070316,28070329,28070374,28070451,28070533,28075370,28075486,28075702,28075848,28075900,28076044,28076205,28076297,28076361,28076407,28076459,28076497,28076550,28076584,28076626,28076658,28076752,28076891,28077622,28077661,28117897,28121638,28122099,28122399,28122883,28123615,28124353,28124832,28126258,28126652,28127225,28128258,28128602,28129267,28130577,28130866,28131052,28131121,28132129,28133985,28134377,28134629,28135673,28181720,28183750,28184228,28184279,28184463,28184605,28184642,28184676,28184728,28184765,28184800,28184884,28184925,28184951,28184990,28185034,28185084,28185105,28185165,28229778,28233040,28236297,28236471,28236631,28236762,28236860,28236939,28237184,28237269,28237428,28237567,28237671,28237703,28237825,28237918,28238052,28238123,28240918,28330500,28330663,28330762,28330921,28331018,28331099,28331278,28331550,28331608,28331782,2833187', 'assoc_port': '28067787:28068921,28067788:28070451,28067789:28069540,28067790:28069613,28067791:28069974,28067792:28070045,28067793:28070374,28067794:28070329,28067795:28070166,28067796:28070316,28067797:28070244,28067798:28070097,28067799:28070010,28067801:28070279,28067804:28069935,28067807:28069873,28067810:28069717,28067813:28069659,28067817:28069739,28067820:28067880,28069259:28069837,28070470:28070533,28075301:28075370,28075302:28075486,28075303:28075702,28075305:28075848,28075307:28075900,28075309:28076044,28075311:28076205,28075313:28076297,28075315:28076584,28075317:28076626,28075319:28076497,28075321:28076658,28075324:28076550,28075327:28077622,28075330:28076407,28075333:28077661,28075336:28076361,28075339:28076459,28076694:28076752,28076878:28076891,28111813:28117897,28119041:28131121,28119044:28131052,28119047:28130866,28119050:28130577,28119053:28135673,28119057:28134629,28119059:28134377,28119063:28129267,28119077:28127225,28119086:28132129,28119101:28126652,28119124:28124832,28119128:28124353,28119132:2812860', 'assoc_mat': '28067787:autre:4230:28068921,28067788:autre:4230:28070451,28067789:autre:4230:28069540,28067790:autre:4230:28069613,28067791:autre:4230:28069974,28067792:autre:4230:28070045,28067793:autre:4230:28070374,28067794:autre:4230:28070329,28067795:autre:4230:28070166,28067796:autre:4230:28070316,28067797:autre:4230:28070244,28067798:autre:4230:28070097,28067799:autre:4230:28070010,28067801:autre:4230:28070279,28067804:autre:4230:28069935,28067807:autre:4230:28069873,28067810:autre:4230:28069717,28067813:autre:4230:28069659,28067817:autre:4230:28069739,28067820:autre:4230:28067880,28069259:autre:4230:28069837,28070470:autre:4230:28070533,28075301:autre:4230:28075370,28075302:autre:4230:28075486,28075303:autre:4230:28075702,28075305:autre:4230:28075848,28075307:autre:4230:28075900,28075309:autre:4230:28076044,28075311:autre:4230:28076205,28075313:autre:4230:28076297,28075315:autre:4230:28076584,28075317:autre:4230:28076626,28075319:autre:4230:28076497,28075321:autre:4230:28076658,28075324:autre:4230:28076550,28075327:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.054933396851168756, 'nb_photo': 88049, 'list_port_cont': '28067883,28068917,28069537,28069621,28069660,28069731,28069732,28069841,28069870,28069945,28069982,28070020,28070053,28070094,28070168,28070237,28070277,28070312,28070328,28070389,28070448,28070537,28075376,28075494,28075711,28075862,28075887,28076041,28076203,28076291,28076370,28076410,28076464,28076495,28076555,28076589,28076627,28076666,28076756,28076907,28077633,28077660,28117893,28121628,28122106,28122395,28122884,28123619,28124354,28124830,28126263,28126654,28127227,28128262,28128610,28129276,28130576,28130859,28131062,28131131,28132128,28133996,28134391,28134624,28135676,28181734,28183751,28184225,28184278,28184464,28184602,28184641,28184684,28184743,28184770,28184807,28184888,28184924,28184965,28184997,28185044,28185089,28185108,28185160,28229789,28233045,28236300,28236475,28236633,28236761,28236866,28236935,28237175,28237272,28237429,28237575,28237668,28237701,28237826,28237915,28238061,28238135,28240923,28330497,28330674,28330779,28330938,28331019,28331111,28331272,28331558,28331599,28331783,2833188', 'assoc_port': '28067787:28068917,28067788:28070448,28067789:28069537,28067790:28069621,28067791:28069982,28067792:28070053,28067793:28070389,28067794:28070328,28067795:28070168,28067796:28070312,28067797:28070237,28067798:28070094,28067799:28070020,28067801:28070277,28067804:28069945,28067807:28069870,28067810:28069732,28067813:28069660,28067817:28069731,28067820:28067883,28069259:28069841,28070470:28070537,28075301:28075376,28075302:28075494,28075303:28075711,28075305:28075862,28075307:28075887,28075309:28076041,28075311:28076203,28075313:28076291,28075315:28076589,28075317:28076627,28075319:28076495,28075321:28076666,28075324:28076555,28075327:28077633,28075330:28076410,28075333:28077660,28075336:28076370,28075339:28076464,28076694:28076756,28076878:28076907,28111813:28117893,28119041:28131131,28119044:28131062,28119047:28130859,28119050:28130576,28119053:28135676,28119057:28134624,28119059:28134391,28119063:28129276,28119077:28127227,28119086:28132128,28119101:28126654,28119124:28124830,28119128:28124354,28119132:2812861', 'assoc_mat': '28067787:carton:4230:28068917,28067788:carton:4230:28070448,28067789:carton:4230:28069537,28067790:carton:4230:28069621,28067791:carton:4230:28069982,28067792:carton:4230:28070053,28067793:carton:4230:28070389,28067794:carton:4230:28070328,28067795:carton:4230:28070168,28067796:carton:4230:28070312,28067797:carton:4230:28070237,28067798:carton:4230:28070094,28067799:carton:4230:28070020,28067801:carton:4230:28070277,28067804:carton:4230:28069945,28067807:carton:4230:28069870,28067810:carton:4230:28069732,28067813:carton:4230:28069660,28067817:carton:4230:28069731,28067820:carton:4230:28067883,28069259:carton:4230:28069841,28070470:carton:4230:28070537,28075301:carton:4230:28075376,28075302:carton:4230:28075494,28075303:carton:4230:28075711,28075305:carton:4230:28075862,28075307:carton:4230:28075887,28075309:carton:4230:28076041,28075311:carton:4230:28076203,28075313:carton:4230:28076291,28075315:carton:4230:28076589,28075317:carton:4230:28076627,28075319:carton:4230:28076495,28075321:carton:4230:28076666,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014380910318766789, 'nb_photo': 1629, 'list_port_cont': '28067878,28068932,28069549,28069617,28069657,28069741,28069746,28069834,28069868,28069941,28069972,28070024,28070088,28070163,28070235,28070275,28070315,28070335,28070390,28070434,28070530,28075367,28075483,28075710,28076037,28076208,28076303,28076365,28076411,28076450,28076499,28076556,28076633,28076660,28076905,28077616,28077654,28117896,28121637,28122101,28122391,28122873,28123621,28124350,28124823,28126655,28127221,28128260,28128611,28129271,28130575,28130870,28131058,28131126,28132120,28134373,28134634,28135667,28181732,28183749,28184226,28184276,28184460,28184606,28184633,28184669,28184733,28184774,28184808,28184875,28184923,28184949,28184985,28185026,28185091,28185103,28185169,28229776,28233041,28236292,28236477,28236622,28236749,28236872,28236932,28237180,28237260,28237422,28237577,28237666,28237707,28237815,28237921,28238051,28238136,28240921,28330499,28330664,28330768,28330922,28331007,28331101,28331256,28331557,28331598,28331776,28331888,28332112,28332178,28332275,28332393,28332443,28332518,2833274', 'assoc_port': '28067787:28068932,28067788:28070434,28067789:28069549,28067790:28069617,28067791:28069972,28067793:28070390,28067794:28070335,28067795:28070163,28067796:28070315,28067797:28070235,28067798:28070088,28067799:28070024,28067801:28070275,28067804:28069941,28067807:28069868,28067810:28069746,28067813:28069657,28067817:28069741,28067820:28067878,28069259:28069834,28070470:28070530,28075301:28075367,28075302:28075483,28075303:28075710,28075309:28076037,28075311:28076208,28075313:28076303,28075317:28076633,28075319:28076499,28075321:28076660,28075324:28076556,28075327:28077616,28075330:28076411,28075333:28077654,28075336:28076365,28075339:28076450,28076878:28076905,28111813:28117896,28119041:28131126,28119044:28131058,28119047:28130870,28119050:28130575,28119053:28135667,28119057:28134634,28119059:28134373,28119063:28129271,28119077:28127221,28119086:28132120,28119101:28126655,28119124:28124823,28119128:28124350,28119132:28128611,28119135:28123621,28119139:28122873,28119146:28122391,28119150:28122101,28121341:2812163', 'assoc_mat': '28067787:metal:4230:28068932,28067788:metal:4230:28070434,28067789:metal:4230:28069549,28067790:metal:4230:28069617,28067791:metal:4230:28069972,28067793:metal:4230:28070390,28067794:metal:4230:28070335,28067795:metal:4230:28070163,28067796:metal:4230:28070315,28067797:metal:4230:28070235,28067798:metal:4230:28070088,28067799:metal:4230:28070024,28067801:metal:4230:28070275,28067804:metal:4230:28069941,28067807:metal:4230:28069868,28067810:metal:4230:28069746,28067813:metal:4230:28069657,28067817:metal:4230:28069741,28067820:metal:4230:28067878,28069259:metal:4230:28069834,28070470:metal:4230:28070530,28075301:metal:4230:28075367,28075302:metal:4230:28075483,28075303:metal:4230:28075710,28075309:metal:4230:28076037,28075311:metal:4230:28076208,28075313:metal:4230:28076303,28075317:metal:4230:28076633,28075319:metal:4230:28076499,28075321:metal:4230:28076660,28075324:metal:4230:28076556,28075327:metal:4230:28077616,28075330:metal:4230:28076411,28075333:metal:4230:28077654,28075336:metal:4230:28076365,28075339:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1696267901886624, 'nb_photo': 252150, 'list_port_cont': '28067881,28068931,28069547,28069619,28069651,28069730,28069752,28069835,28069874,28069938,28069986,28070025,28070054,28070090,28070170,28070243,28070272,28070314,28070323,28070386,28070444,28070535,28075381,28075493,28075715,28075856,28075899,28076029,28076211,28076300,28076374,28076406,28076466,28076501,28076554,28076586,28076625,28076662,28076755,28076897,28077623,28077670,28117901,28121631,28122097,28122402,28122885,28123618,28124343,28124820,28126264,28126653,28127234,28128271,28128608,28129275,28130568,28130869,28131053,28131128,28132126,28133995,28134393,28134636,28135681,28181731,28183757,28184219,28184277,28184465,28184608,28184634,28184679,28184744,28184769,28184815,28184882,28184922,28184955,28184998,28185042,28185088,28185110,28185170,28229795,28233051,28236303,28236481,28236630,28236760,28236874,28236927,28237182,28237265,28237426,28237576,28237670,28237705,28237821,28237920,28238049,28238133,28240917,28330498,28330670,28330771,28330929,28331014,28331100,28331280,28331552,28331611,28331785,2833188', 'assoc_port': '28067787:28068931,28067788:28070444,28067789:28069547,28067790:28069619,28067791:28069986,28067792:28070054,28067793:28070386,28067794:28070323,28067795:28070170,28067796:28070314,28067797:28070243,28067798:28070090,28067799:28070025,28067801:28070272,28067804:28069938,28067807:28069874,28067810:28069730,28067813:28069651,28067817:28069752,28067820:28067881,28069259:28069835,28070470:28070535,28075301:28075381,28075302:28075493,28075303:28075715,28075305:28075856,28075307:28075899,28075309:28076029,28075311:28076211,28075313:28076300,28075315:28076586,28075317:28076625,28075319:28076501,28075321:28076662,28075324:28076554,28075327:28077623,28075330:28076406,28075333:28077670,28075336:28076374,28075339:28076466,28076694:28076755,28076878:28076897,28111813:28117901,28119041:28131128,28119044:28131053,28119047:28130869,28119050:28130568,28119053:28135681,28119057:28134636,28119059:28134393,28119063:28129275,28119077:28127234,28119086:28132126,28119101:28126653,28119124:28124820,28119128:28124343,28119132:2812860', 'assoc_mat': '28067787:papier:4230:28068931,28067788:papier:4230:28070444,28067789:papier:4230:28069547,28067790:papier:4230:28069619,28067791:papier:4230:28069986,28067792:papier:4230:28070054,28067793:papier:4230:28070386,28067794:papier:4230:28070323,28067795:papier:4230:28070170,28067796:papier:4230:28070314,28067797:papier:4230:28070243,28067798:papier:4230:28070090,28067799:papier:4230:28070025,28067801:papier:4230:28070272,28067804:papier:4230:28069938,28067807:papier:4230:28069874,28067810:papier:4230:28069730,28067813:papier:4230:28069651,28067817:papier:4230:28069752,28067820:papier:4230:28067881,28069259:papier:4230:28069835,28070470:papier:4230:28070535,28075301:papier:4230:28075381,28075302:papier:4230:28075493,28075303:papier:4230:28075715,28075305:papier:4230:28075856,28075307:papier:4230:28075899,28075309:papier:4230:28076029,28075311:papier:4230:28076211,28075313:papier:4230:28076300,28075315:papier:4230:28076586,28075317:papier:4230:28076625,28075319:papier:4230:28076501,28075321:papier:4230:28076662,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035544242628207257, 'nb_photo': 1769, 'list_port_cont': '28067886,28069546,28069624,28069652,28069747,28069748,28069840,28069869,28069981,28070021,28070087,28070171,28070233,28070281,28070305,28070330,28070391,28070532,28075490,28075718,28075863,28075897,28076043,28076206,28076375,28076404,28076462,28076491,28076553,28076664,28076748,28117898,28121634,28122100,28122400,28122879,28123625,28124349,28124824,28126266,28126658,28127233,28128617,28129274,28130569,28130867,28131051,28132132,28133984,28134365,28184215,28184281,28184453,28184610,28184647,28184681,28184740,28184779,28184817,28184959,28185028,28185094,28185164,28233050,28236306,28236476,28236618,28236759,28236862,28236938,28237176,28237266,28237432,28237573,28237667,28237924,28240922,28330490,28330672,28330778,28330925,28331017,28331113,28331268,28331553,28331614,28331890,28332124,28332181,28332277,28332410,28332444,28332761,28332863,28335613,28335820,28337503,28337542,28337688,28337961,28337980,28338068,28338247,28338717,28338947,28339032,28339069,28339216,28339284,28339333,28339387,28339512,28339741,2833979', 'assoc_port': '28067789:28069546,28067790:28069624,28067791:28069981,28067793:28070391,28067794:28070330,28067795:28070171,28067796:28070305,28067797:28070233,28067798:28070087,28067799:28070021,28067801:28070281,28067807:28069869,28067810:28069748,28067813:28069652,28067817:28069747,28067820:28067886,28069259:28069840,28070470:28070532,28075302:28075490,28075303:28075718,28075305:28075863,28075307:28075897,28075309:28076043,28075311:28076206,28075319:28076491,28075321:28076664,28075324:28076553,28075330:28076404,28075336:28076375,28075339:28076462,28076694:28076748,28111813:28117898,28119044:28131051,28119047:28130867,28119050:28130569,28119059:28134365,28119063:28129274,28119077:28127233,28119086:28132132,28119101:28126658,28119124:28124824,28119128:28124349,28119132:28128617,28119135:28123625,28119139:28122879,28119142:28133984,28119146:28122400,28119150:28122100,28119153:28126266,28121341:28121634,28181605:28185028,28181637:28184779,28181638:28185094,28181640:28185164,28181641:28184740,28181643:28184681,28181644:2818461', 'assoc_mat': '28067789:pehd:4230:28069546,28067790:pehd:4230:28069624,28067791:pehd:4230:28069981,28067793:pehd:4230:28070391,28067794:pehd:4230:28070330,28067795:pehd:4230:28070171,28067796:pehd:4230:28070305,28067797:pehd:4230:28070233,28067798:pehd:4230:28070087,28067799:pehd:4230:28070021,28067801:pehd:4230:28070281,28067807:pehd:4230:28069869,28067810:pehd:4230:28069748,28067813:pehd:4230:28069652,28067817:pehd:4230:28069747,28067820:pehd:4230:28067886,28069259:pehd:4230:28069840,28070470:pehd:4230:28070532,28075302:pehd:4230:28075490,28075303:pehd:4230:28075718,28075305:pehd:4230:28075863,28075307:pehd:4230:28075897,28075309:pehd:4230:28076043,28075311:pehd:4230:28076206,28075319:pehd:4230:28076491,28075321:pehd:4230:28076664,28075324:pehd:4230:28076553,28075330:pehd:4230:28076404,28075336:pehd:4230:28076375,28075339:pehd:4230:28076462,28076694:pehd:4230:28076748,28111813:pehd:4230:28117898,28119044:pehd:4230:28131051,28119047:pehd:4230:28130867,28119050:pehd:4230:28130569,28119059:pehd:4230:28134365,28119063:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01371419783021479, 'nb_photo': 20194, 'list_port_cont': '28067887,28068933,28069552,28069611,28069661,28069742,28069751,28069832,28069877,28069951,28069987,28070013,28070048,28070092,28070167,28070242,28070280,28070317,28070334,28070388,28070440,28070538,28075382,28075480,28075713,28075857,28075894,28076035,28076212,28076298,28076372,28076413,28076461,28076503,28076546,28076591,28076631,28076663,28076746,28076906,28077624,28077669,28117891,28121633,28122108,28122398,28122888,28123616,28124356,28124827,28126260,28126649,28127235,28128266,28128615,28129277,28130573,28130860,28131054,28131123,28132125,28133989,28134383,28134635,28135679,28181729,28183755,28184217,28184282,28184459,28184598,28184644,28184683,28184736,28184777,28184816,28184876,28184920,28184960,28184987,28185030,28185095,28185114,28185167,28229798,28233042,28236305,28236478,28236621,28236758,28236870,28236933,28237179,28237271,28237427,28237578,28237672,28237706,28237830,28237923,28238058,28238129,28240915,28330495,28330671,28330774,28330936,28331024,28331105,28331274,28331560,28331612,28331780,2833188', 'assoc_port': '28067787:28068933,28067788:28070440,28067789:28069552,28067790:28069611,28067791:28069987,28067792:28070048,28067793:28070388,28067794:28070334,28067795:28070167,28067796:28070317,28067797:28070242,28067798:28070092,28067799:28070013,28067801:28070280,28067804:28069951,28067807:28069877,28067810:28069742,28067813:28069661,28067817:28069751,28067820:28067887,28069259:28069832,28070470:28070538,28075301:28075382,28075302:28075480,28075303:28075713,28075305:28075857,28075307:28075894,28075309:28076035,28075311:28076212,28075313:28076298,28075315:28076591,28075317:28076631,28075319:28076503,28075321:28076663,28075324:28076546,28075327:28077624,28075330:28076413,28075333:28077669,28075336:28076372,28075339:28076461,28076694:28076746,28076878:28076906,28111813:28117891,28119041:28131123,28119044:28131054,28119047:28130860,28119050:28130573,28119053:28135679,28119057:28134635,28119059:28134383,28119063:28129277,28119077:28127235,28119086:28132125,28119101:28126649,28119124:28124827,28119128:28124356,28119132:2812861', 'assoc_mat': '28067787:pet_clair:4230:28068933,28067788:pet_clair:4230:28070440,28067789:pet_clair:4230:28069552,28067790:pet_clair:4230:28069611,28067791:pet_clair:4230:28069987,28067792:pet_clair:4230:28070048,28067793:pet_clair:4230:28070388,28067794:pet_clair:4230:28070334,28067795:pet_clair:4230:28070167,28067796:pet_clair:4230:28070317,28067797:pet_clair:4230:28070242,28067798:pet_clair:4230:28070092,28067799:pet_clair:4230:28070013,28067801:pet_clair:4230:28070280,28067804:pet_clair:4230:28069951,28067807:pet_clair:4230:28069877,28067810:pet_clair:4230:28069742,28067813:pet_clair:4230:28069661,28067817:pet_clair:4230:28069751,28067820:pet_clair:4230:28067887,28069259:pet_clair:4230:28069832,28070470:pet_clair:4230:28070538,28075301:pet_clair:4230:28075382,28075302:pet_clair:4230:28075480,28075303:pet_clair:4230:28075713,28075305:pet_clair:4230:28075857,28075307:pet_clair:4230:28075894,28075309:pet_clair:4230:28076035,28075311:pet_clair:4230:28076212,28075313:pet_clair:4230:28076298,28075315:pet_clair:4230:28076591,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0030076582100091, 'nb_photo': 661, 'list_port_cont': '28069653,28069721,28069738,28070018,28070056,28070098,28070240,28070274,28070333,28070385,28070534,28076465,28076632,28076669,28076750,28117903,28121625,28122103,28122390,28122880,28124831,28126255,28126651,28128257,28132134,28133993,28134371,28134633,28183754,28184609,28184640,28184680,28184742,28184773,28184812,28184928,28184964,28185040,28185090,28185157,28229790,28233055,28236298,28236483,28236629,28236867,28236931,28237183,28237263,28237418,28237574,28237665,28237831,28237913,28238060,28330493,28330675,28330776,28331021,28331109,28331276,28331607,28331878,28332173,28332445,28332528,28335617,28335802,28337504,28337964,28337971,28338248,28338711,28338951,28339021,28339060,28339278,28339718,28339743,28339979,28362851,28362925,28363107,28363340,28363405,28363518,28368446,28368515,28368683,28412742,28412792,28412953,28413098,28413255,28413316,28413448,28413658,28414076,28435578,28435852,28435891,28436210,28436497,28436620,28436756,28436935,28437051,28437119,28437197,28469824,28469868,28470032,28470084,2847020', 'assoc_port': '28067792:28070056,28067793:28070385,28067794:28070333,28067797:28070240,28067798:28070098,28067799:28070018,28067801:28070274,28067810:28069738,28067813:28069653,28067817:28069721,28070470:28070534,28075317:28076632,28075321:28076669,28075339:28076465,28076694:28076750,28111813:28117903,28119057:28134633,28119059:28134371,28119086:28132134,28119101:28126651,28119124:28124831,28119139:28122880,28119142:28133993,28119146:28122390,28119150:28122103,28119153:28126255,28121341:28121625,28123207:28128257,28181605:28185040,28181608:28184928,28181637:28184773,28181638:28185090,28181640:28185157,28181641:28184742,28181643:28184680,28181644:28184609,28181646:28184812,28181647:28184964,28181653:28184640,28183615:28183754,28229583:28238060,28229584:28237831,28229597:28237913,28229598:28237574,28229611:28237665,28229614:28237418,28229615:28237183,28229616:28237263,28229617:28236931,28229618:28236867,28229621:28236629,28229631:28236483,28229635:28236298,28229640:28229790,28232611:28233055,28276909:28339979,28276911:2833974', 'assoc_mat': '28067792:pet_fonce:4230:28070056,28067793:pet_fonce:4230:28070385,28067794:pet_fonce:4230:28070333,28067797:pet_fonce:4230:28070240,28067798:pet_fonce:4230:28070098,28067799:pet_fonce:4230:28070018,28067801:pet_fonce:4230:28070274,28067810:pet_fonce:4230:28069738,28067813:pet_fonce:4230:28069653,28067817:pet_fonce:4230:28069721,28070470:pet_fonce:4230:28070534,28075317:pet_fonce:4230:28076632,28075321:pet_fonce:4230:28076669,28075339:pet_fonce:4230:28076465,28076694:pet_fonce:4230:28076750,28111813:pet_fonce:4230:28117903,28119057:pet_fonce:4230:28134633,28119059:pet_fonce:4230:28134371,28119086:pet_fonce:4230:28132134,28119101:pet_fonce:4230:28126651,28119124:pet_fonce:4230:28124831,28119139:pet_fonce:4230:28122880,28119142:pet_fonce:4230:28133993,28119146:pet_fonce:4230:28122390,28119150:pet_fonce:4230:28122103,28119153:pet_fonce:4230:28126255,28121341:pet_fonce:4230:28121625,28123207:pet_fonce:4230:28128257,28181605:pet_fonce:4230:28185040,28181608:pet_fonce:4230:28184928,28181637:pet_fonce:4230:28184773,2'}), 'main_stat': {'nb_photos': 1438}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-11', 0.7518545156661435),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 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=4850 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= 4850 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=4850 # 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': ((1438,),), 'unwanted_material_monthly_percentage': ((0.7518545156661435,),), 'material_repartition': (('incineration', 1438),), 'material_dict': {'incineration': 1438}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 11, 1), 0.7086637498937932, 1), (datetime.date(2025, 11, 2), 0.7332753707484142, 1), (datetime.date(2025, 11, 3), 0.7290110702579551, 2), (datetime.date(2025, 11, 4), 0.7109235819886419, 1), (datetime.date(2025, 11, 5), 0.6812315840065326, 3), (datetime.date(2025, 11, 6), 0.6639823261046317, 1), (datetime.date(2025, 11, 7), 0.7041761535619381, 3), (datetime.date(2025, 11, 8), 0.7370359613950824, 2), (datetime.date(2025, 11, 9), 0.8285550197149263, 3), (datetime.date(2025, 11, 10), 0.7677874039985979, 2), (datetime.date(2025, 11, 11), 0.803390296972739, 1), (datetime.date(2025, 11, 12), 0.7703954321148463, 1), (datetime.date(2025, 11, 13), 0.734544261444827, 1), (datetime.date(2025, 11, 14), 0.7331286766925561, 3), (datetime.date(2025, 11, 15), 0.7415060162018934, 1), (datetime.date(2025, 11, 16), 0.7793553318538203, 1), (datetime.date(2025, 11, 17), 0.7672838553393281, 2), (datetime.date(2025, 11, 18), 0.7660241552716502, 3), (datetime.date(2025, 11, 19), 0.7332714880285166, 1), (datetime.date(2025, 11, 20), 0.7025880915135392, 1), (datetime.date(2025, 11, 21), 0.7150655975151947, 3), (datetime.date(2025, 11, 22), 0.7422553468631929, 1), (datetime.date(2025, 11, 23), 0.7801714108271633, 4), (datetime.date(2025, 11, 24), 0.7652646591950307, 1), (datetime.date(2025, 11, 25), 0.7403132670288509, 2), (datetime.date(2025, 11, 26), 0.7706224361360379, 2), (datetime.date(2025, 11, 27), 0.7517862355997502, 2), (datetime.date(2025, 11, 28), 0.7389462819449392, 4), (datetime.date(2025, 11, 29), 0.7993331918990682, 4), (datetime.date(2025, 11, 30), 0.8201406804601161, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 11, 1), 0.7086637498937932, 1), (datetime.date(2025, 11, 2), 0.7332753707484142, 1), (datetime.date(2025, 11, 3), 0.7290110702579551, 2), (datetime.date(2025, 11, 4), 0.7109235819886419, 1), (datetime.date(2025, 11, 5), 0.6812315840065326, 3), (datetime.date(2025, 11, 6), 0.6639823261046317, 1), (datetime.date(2025, 11, 7), 0.7041761535619381, 3), (datetime.date(2025, 11, 8), 0.7370359613950824, 2), (datetime.date(2025, 11, 9), 0.8285550197149263, 3), (datetime.date(2025, 11, 10), 0.7677874039985979, 2), (datetime.date(2025, 11, 11), 0.803390296972739, 1), (datetime.date(2025, 11, 12), 0.7703954321148463, 1), (datetime.date(2025, 11, 13), 0.734544261444827, 1), (datetime.date(2025, 11, 14), 0.7331286766925561, 3), (datetime.date(2025, 11, 15), 0.7415060162018934, 1), (datetime.date(2025, 11, 16), 0.7793553318538203, 1), (datetime.date(2025, 11, 17), 0.7672838553393281, 2), (datetime.date(2025, 11, 18), 0.7660241552716502, 3), (datetime.date(2025, 11, 19), 0.7332714880285166, 1), (datetime.date(2025, 11, 20), 0.7025880915135392, 1), (datetime.date(2025, 11, 21), 0.7150655975151947, 3), (datetime.date(2025, 11, 22), 0.7422553468631929, 1), (datetime.date(2025, 11, 23), 0.7801714108271633, 4), (datetime.date(2025, 11, 24), 0.7652646591950307, 1), (datetime.date(2025, 11, 25), 0.7403132670288509, 2), (datetime.date(2025, 11, 26), 0.7706224361360379, 2), (datetime.date(2025, 11, 27), 0.7517862355997502, 2), (datetime.date(2025, 11, 28), 0.7389462819449392, 4), (datetime.date(2025, 11, 29), 0.7993331918990682, 4), (datetime.date(2025, 11, 30), 0.8201406804601161, 4))}, 'quality_array': [['-8.398026474535236', '01112025'], ['-8.35888284478845', '02112025'], ['-8.067712051594576', '03112025'], ['-7.945102684379106', '04112025'], ['-8.01827628501776', '05112025'], ['-7.939596705364024', '06112025'], ['-8.000431349650002', '07112025'], ['-7.960625539708045', '08112025'], ['-7.963264628650207', '09112025'], ['-7.762440530888007', '10112025'], ['-8.019937644551614', '11112025'], ['-7.315776933762011', '12112025'], ['-7.551929792305123', '13112025'], ['-7.875581845569814', '14112025'], ['-7.5314049349273855', '15112025'], ['-7.831944554062369', '16112025'], ['-7.852364796691473', '17112025'], ['-7.3795018476000624', '18112025'], ['-7.418190275792029', '19112025'], ['-7.603041957247732', '20112025'], ['-7.336839236044747', '21112025'], ['-7.110018562568477', '22112025'], ['-7.628062587635092', '23112025'], ['-7.522823764403562', '24112025'], ['-7.767458264611627', '25112025'], ['-7.9844482669232875', '26112025'], ['-7.690024945504662', '27112025'], ['-7.742691221584303', '28112025'], ['-7.9997518334078555', '29112025'], ['-7.954428350200598', '30112025']], 'number_of_batch': ((637,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014519781465732616, 'nb_photo': 14186, 'list_port_cont': '28067880,28068921,28069540,28069613,28069659,28069717,28069739,28069837,28069873,28069935,28069974,28070010,28070045,28070097,28070166,28070244,28070279,28070316,28070329,28070374,28070451,28070533,28075370,28075486,28075702,28075848,28075900,28076044,28076205,28076297,28076361,28076407,28076459,28076497,28076550,28076584,28076626,28076658,28076752,28076891,28077622,28077661,28117897,28121638,28122099,28122399,28122883,28123615,28124353,28124832,28126258,28126652,28127225,28128258,28128602,28129267,28130577,28130866,28131052,28131121,28132129,28133985,28134377,28134629,28135673,28181720,28183750,28184228,28184279,28184463,28184605,28184642,28184676,28184728,28184765,28184800,28184884,28184925,28184951,28184990,28185034,28185084,28185105,28185165,28229778,28233040,28236297,28236471,28236631,28236762,28236860,28236939,28237184,28237269,28237428,28237567,28237671,28237703,28237825,28237918,28238052,28238123,28240918,28330500,28330663,28330762,28330921,28331018,28331099,28331278,28331550,28331608,28331782,2833187', 'assoc_port': '28067787:28068921,28067788:28070451,28067789:28069540,28067790:28069613,28067791:28069974,28067792:28070045,28067793:28070374,28067794:28070329,28067795:28070166,28067796:28070316,28067797:28070244,28067798:28070097,28067799:28070010,28067801:28070279,28067804:28069935,28067807:28069873,28067810:28069717,28067813:28069659,28067817:28069739,28067820:28067880,28069259:28069837,28070470:28070533,28075301:28075370,28075302:28075486,28075303:28075702,28075305:28075848,28075307:28075900,28075309:28076044,28075311:28076205,28075313:28076297,28075315:28076584,28075317:28076626,28075319:28076497,28075321:28076658,28075324:28076550,28075327:28077622,28075330:28076407,28075333:28077661,28075336:28076361,28075339:28076459,28076694:28076752,28076878:28076891,28111813:28117897,28119041:28131121,28119044:28131052,28119047:28130866,28119050:28130577,28119053:28135673,28119057:28134629,28119059:28134377,28119063:28129267,28119077:28127225,28119086:28132129,28119101:28126652,28119124:28124832,28119128:28124353,28119132:2812860', 'assoc_mat': '28067787:autre:4230:28068921,28067788:autre:4230:28070451,28067789:autre:4230:28069540,28067790:autre:4230:28069613,28067791:autre:4230:28069974,28067792:autre:4230:28070045,28067793:autre:4230:28070374,28067794:autre:4230:28070329,28067795:autre:4230:28070166,28067796:autre:4230:28070316,28067797:autre:4230:28070244,28067798:autre:4230:28070097,28067799:autre:4230:28070010,28067801:autre:4230:28070279,28067804:autre:4230:28069935,28067807:autre:4230:28069873,28067810:autre:4230:28069717,28067813:autre:4230:28069659,28067817:autre:4230:28069739,28067820:autre:4230:28067880,28069259:autre:4230:28069837,28070470:autre:4230:28070533,28075301:autre:4230:28075370,28075302:autre:4230:28075486,28075303:autre:4230:28075702,28075305:autre:4230:28075848,28075307:autre:4230:28075900,28075309:autre:4230:28076044,28075311:autre:4230:28076205,28075313:autre:4230:28076297,28075315:autre:4230:28076584,28075317:autre:4230:28076626,28075319:autre:4230:28076497,28075321:autre:4230:28076658,28075324:autre:4230:28076550,28075327:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.054933396851168756, 'nb_photo': 88049, 'list_port_cont': '28067883,28068917,28069537,28069621,28069660,28069731,28069732,28069841,28069870,28069945,28069982,28070020,28070053,28070094,28070168,28070237,28070277,28070312,28070328,28070389,28070448,28070537,28075376,28075494,28075711,28075862,28075887,28076041,28076203,28076291,28076370,28076410,28076464,28076495,28076555,28076589,28076627,28076666,28076756,28076907,28077633,28077660,28117893,28121628,28122106,28122395,28122884,28123619,28124354,28124830,28126263,28126654,28127227,28128262,28128610,28129276,28130576,28130859,28131062,28131131,28132128,28133996,28134391,28134624,28135676,28181734,28183751,28184225,28184278,28184464,28184602,28184641,28184684,28184743,28184770,28184807,28184888,28184924,28184965,28184997,28185044,28185089,28185108,28185160,28229789,28233045,28236300,28236475,28236633,28236761,28236866,28236935,28237175,28237272,28237429,28237575,28237668,28237701,28237826,28237915,28238061,28238135,28240923,28330497,28330674,28330779,28330938,28331019,28331111,28331272,28331558,28331599,28331783,2833188', 'assoc_port': '28067787:28068917,28067788:28070448,28067789:28069537,28067790:28069621,28067791:28069982,28067792:28070053,28067793:28070389,28067794:28070328,28067795:28070168,28067796:28070312,28067797:28070237,28067798:28070094,28067799:28070020,28067801:28070277,28067804:28069945,28067807:28069870,28067810:28069732,28067813:28069660,28067817:28069731,28067820:28067883,28069259:28069841,28070470:28070537,28075301:28075376,28075302:28075494,28075303:28075711,28075305:28075862,28075307:28075887,28075309:28076041,28075311:28076203,28075313:28076291,28075315:28076589,28075317:28076627,28075319:28076495,28075321:28076666,28075324:28076555,28075327:28077633,28075330:28076410,28075333:28077660,28075336:28076370,28075339:28076464,28076694:28076756,28076878:28076907,28111813:28117893,28119041:28131131,28119044:28131062,28119047:28130859,28119050:28130576,28119053:28135676,28119057:28134624,28119059:28134391,28119063:28129276,28119077:28127227,28119086:28132128,28119101:28126654,28119124:28124830,28119128:28124354,28119132:2812861', 'assoc_mat': '28067787:carton:4230:28068917,28067788:carton:4230:28070448,28067789:carton:4230:28069537,28067790:carton:4230:28069621,28067791:carton:4230:28069982,28067792:carton:4230:28070053,28067793:carton:4230:28070389,28067794:carton:4230:28070328,28067795:carton:4230:28070168,28067796:carton:4230:28070312,28067797:carton:4230:28070237,28067798:carton:4230:28070094,28067799:carton:4230:28070020,28067801:carton:4230:28070277,28067804:carton:4230:28069945,28067807:carton:4230:28069870,28067810:carton:4230:28069732,28067813:carton:4230:28069660,28067817:carton:4230:28069731,28067820:carton:4230:28067883,28069259:carton:4230:28069841,28070470:carton:4230:28070537,28075301:carton:4230:28075376,28075302:carton:4230:28075494,28075303:carton:4230:28075711,28075305:carton:4230:28075862,28075307:carton:4230:28075887,28075309:carton:4230:28076041,28075311:carton:4230:28076203,28075313:carton:4230:28076291,28075315:carton:4230:28076589,28075317:carton:4230:28076627,28075319:carton:4230:28076495,28075321:carton:4230:28076666,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014380910318766789, 'nb_photo': 1629, 'list_port_cont': '28067878,28068932,28069549,28069617,28069657,28069741,28069746,28069834,28069868,28069941,28069972,28070024,28070088,28070163,28070235,28070275,28070315,28070335,28070390,28070434,28070530,28075367,28075483,28075710,28076037,28076208,28076303,28076365,28076411,28076450,28076499,28076556,28076633,28076660,28076905,28077616,28077654,28117896,28121637,28122101,28122391,28122873,28123621,28124350,28124823,28126655,28127221,28128260,28128611,28129271,28130575,28130870,28131058,28131126,28132120,28134373,28134634,28135667,28181732,28183749,28184226,28184276,28184460,28184606,28184633,28184669,28184733,28184774,28184808,28184875,28184923,28184949,28184985,28185026,28185091,28185103,28185169,28229776,28233041,28236292,28236477,28236622,28236749,28236872,28236932,28237180,28237260,28237422,28237577,28237666,28237707,28237815,28237921,28238051,28238136,28240921,28330499,28330664,28330768,28330922,28331007,28331101,28331256,28331557,28331598,28331776,28331888,28332112,28332178,28332275,28332393,28332443,28332518,2833274', 'assoc_port': '28067787:28068932,28067788:28070434,28067789:28069549,28067790:28069617,28067791:28069972,28067793:28070390,28067794:28070335,28067795:28070163,28067796:28070315,28067797:28070235,28067798:28070088,28067799:28070024,28067801:28070275,28067804:28069941,28067807:28069868,28067810:28069746,28067813:28069657,28067817:28069741,28067820:28067878,28069259:28069834,28070470:28070530,28075301:28075367,28075302:28075483,28075303:28075710,28075309:28076037,28075311:28076208,28075313:28076303,28075317:28076633,28075319:28076499,28075321:28076660,28075324:28076556,28075327:28077616,28075330:28076411,28075333:28077654,28075336:28076365,28075339:28076450,28076878:28076905,28111813:28117896,28119041:28131126,28119044:28131058,28119047:28130870,28119050:28130575,28119053:28135667,28119057:28134634,28119059:28134373,28119063:28129271,28119077:28127221,28119086:28132120,28119101:28126655,28119124:28124823,28119128:28124350,28119132:28128611,28119135:28123621,28119139:28122873,28119146:28122391,28119150:28122101,28121341:2812163', 'assoc_mat': '28067787:metal:4230:28068932,28067788:metal:4230:28070434,28067789:metal:4230:28069549,28067790:metal:4230:28069617,28067791:metal:4230:28069972,28067793:metal:4230:28070390,28067794:metal:4230:28070335,28067795:metal:4230:28070163,28067796:metal:4230:28070315,28067797:metal:4230:28070235,28067798:metal:4230:28070088,28067799:metal:4230:28070024,28067801:metal:4230:28070275,28067804:metal:4230:28069941,28067807:metal:4230:28069868,28067810:metal:4230:28069746,28067813:metal:4230:28069657,28067817:metal:4230:28069741,28067820:metal:4230:28067878,28069259:metal:4230:28069834,28070470:metal:4230:28070530,28075301:metal:4230:28075367,28075302:metal:4230:28075483,28075303:metal:4230:28075710,28075309:metal:4230:28076037,28075311:metal:4230:28076208,28075313:metal:4230:28076303,28075317:metal:4230:28076633,28075319:metal:4230:28076499,28075321:metal:4230:28076660,28075324:metal:4230:28076556,28075327:metal:4230:28077616,28075330:metal:4230:28076411,28075333:metal:4230:28077654,28075336:metal:4230:28076365,28075339:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1696267901886624, 'nb_photo': 252150, 'list_port_cont': '28067881,28068931,28069547,28069619,28069651,28069730,28069752,28069835,28069874,28069938,28069986,28070025,28070054,28070090,28070170,28070243,28070272,28070314,28070323,28070386,28070444,28070535,28075381,28075493,28075715,28075856,28075899,28076029,28076211,28076300,28076374,28076406,28076466,28076501,28076554,28076586,28076625,28076662,28076755,28076897,28077623,28077670,28117901,28121631,28122097,28122402,28122885,28123618,28124343,28124820,28126264,28126653,28127234,28128271,28128608,28129275,28130568,28130869,28131053,28131128,28132126,28133995,28134393,28134636,28135681,28181731,28183757,28184219,28184277,28184465,28184608,28184634,28184679,28184744,28184769,28184815,28184882,28184922,28184955,28184998,28185042,28185088,28185110,28185170,28229795,28233051,28236303,28236481,28236630,28236760,28236874,28236927,28237182,28237265,28237426,28237576,28237670,28237705,28237821,28237920,28238049,28238133,28240917,28330498,28330670,28330771,28330929,28331014,28331100,28331280,28331552,28331611,28331785,2833188', 'assoc_port': '28067787:28068931,28067788:28070444,28067789:28069547,28067790:28069619,28067791:28069986,28067792:28070054,28067793:28070386,28067794:28070323,28067795:28070170,28067796:28070314,28067797:28070243,28067798:28070090,28067799:28070025,28067801:28070272,28067804:28069938,28067807:28069874,28067810:28069730,28067813:28069651,28067817:28069752,28067820:28067881,28069259:28069835,28070470:28070535,28075301:28075381,28075302:28075493,28075303:28075715,28075305:28075856,28075307:28075899,28075309:28076029,28075311:28076211,28075313:28076300,28075315:28076586,28075317:28076625,28075319:28076501,28075321:28076662,28075324:28076554,28075327:28077623,28075330:28076406,28075333:28077670,28075336:28076374,28075339:28076466,28076694:28076755,28076878:28076897,28111813:28117901,28119041:28131128,28119044:28131053,28119047:28130869,28119050:28130568,28119053:28135681,28119057:28134636,28119059:28134393,28119063:28129275,28119077:28127234,28119086:28132126,28119101:28126653,28119124:28124820,28119128:28124343,28119132:2812860', 'assoc_mat': '28067787:papier:4230:28068931,28067788:papier:4230:28070444,28067789:papier:4230:28069547,28067790:papier:4230:28069619,28067791:papier:4230:28069986,28067792:papier:4230:28070054,28067793:papier:4230:28070386,28067794:papier:4230:28070323,28067795:papier:4230:28070170,28067796:papier:4230:28070314,28067797:papier:4230:28070243,28067798:papier:4230:28070090,28067799:papier:4230:28070025,28067801:papier:4230:28070272,28067804:papier:4230:28069938,28067807:papier:4230:28069874,28067810:papier:4230:28069730,28067813:papier:4230:28069651,28067817:papier:4230:28069752,28067820:papier:4230:28067881,28069259:papier:4230:28069835,28070470:papier:4230:28070535,28075301:papier:4230:28075381,28075302:papier:4230:28075493,28075303:papier:4230:28075715,28075305:papier:4230:28075856,28075307:papier:4230:28075899,28075309:papier:4230:28076029,28075311:papier:4230:28076211,28075313:papier:4230:28076300,28075315:papier:4230:28076586,28075317:papier:4230:28076625,28075319:papier:4230:28076501,28075321:papier:4230:28076662,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0035544242628207257, 'nb_photo': 1769, 'list_port_cont': '28067886,28069546,28069624,28069652,28069747,28069748,28069840,28069869,28069981,28070021,28070087,28070171,28070233,28070281,28070305,28070330,28070391,28070532,28075490,28075718,28075863,28075897,28076043,28076206,28076375,28076404,28076462,28076491,28076553,28076664,28076748,28117898,28121634,28122100,28122400,28122879,28123625,28124349,28124824,28126266,28126658,28127233,28128617,28129274,28130569,28130867,28131051,28132132,28133984,28134365,28184215,28184281,28184453,28184610,28184647,28184681,28184740,28184779,28184817,28184959,28185028,28185094,28185164,28233050,28236306,28236476,28236618,28236759,28236862,28236938,28237176,28237266,28237432,28237573,28237667,28237924,28240922,28330490,28330672,28330778,28330925,28331017,28331113,28331268,28331553,28331614,28331890,28332124,28332181,28332277,28332410,28332444,28332761,28332863,28335613,28335820,28337503,28337542,28337688,28337961,28337980,28338068,28338247,28338717,28338947,28339032,28339069,28339216,28339284,28339333,28339387,28339512,28339741,2833979', 'assoc_port': '28067789:28069546,28067790:28069624,28067791:28069981,28067793:28070391,28067794:28070330,28067795:28070171,28067796:28070305,28067797:28070233,28067798:28070087,28067799:28070021,28067801:28070281,28067807:28069869,28067810:28069748,28067813:28069652,28067817:28069747,28067820:28067886,28069259:28069840,28070470:28070532,28075302:28075490,28075303:28075718,28075305:28075863,28075307:28075897,28075309:28076043,28075311:28076206,28075319:28076491,28075321:28076664,28075324:28076553,28075330:28076404,28075336:28076375,28075339:28076462,28076694:28076748,28111813:28117898,28119044:28131051,28119047:28130867,28119050:28130569,28119059:28134365,28119063:28129274,28119077:28127233,28119086:28132132,28119101:28126658,28119124:28124824,28119128:28124349,28119132:28128617,28119135:28123625,28119139:28122879,28119142:28133984,28119146:28122400,28119150:28122100,28119153:28126266,28121341:28121634,28181605:28185028,28181637:28184779,28181638:28185094,28181640:28185164,28181641:28184740,28181643:28184681,28181644:2818461', 'assoc_mat': '28067789:pehd:4230:28069546,28067790:pehd:4230:28069624,28067791:pehd:4230:28069981,28067793:pehd:4230:28070391,28067794:pehd:4230:28070330,28067795:pehd:4230:28070171,28067796:pehd:4230:28070305,28067797:pehd:4230:28070233,28067798:pehd:4230:28070087,28067799:pehd:4230:28070021,28067801:pehd:4230:28070281,28067807:pehd:4230:28069869,28067810:pehd:4230:28069748,28067813:pehd:4230:28069652,28067817:pehd:4230:28069747,28067820:pehd:4230:28067886,28069259:pehd:4230:28069840,28070470:pehd:4230:28070532,28075302:pehd:4230:28075490,28075303:pehd:4230:28075718,28075305:pehd:4230:28075863,28075307:pehd:4230:28075897,28075309:pehd:4230:28076043,28075311:pehd:4230:28076206,28075319:pehd:4230:28076491,28075321:pehd:4230:28076664,28075324:pehd:4230:28076553,28075330:pehd:4230:28076404,28075336:pehd:4230:28076375,28075339:pehd:4230:28076462,28076694:pehd:4230:28076748,28111813:pehd:4230:28117898,28119044:pehd:4230:28131051,28119047:pehd:4230:28130867,28119050:pehd:4230:28130569,28119059:pehd:4230:28134365,28119063:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01371419783021479, 'nb_photo': 20194, 'list_port_cont': '28067887,28068933,28069552,28069611,28069661,28069742,28069751,28069832,28069877,28069951,28069987,28070013,28070048,28070092,28070167,28070242,28070280,28070317,28070334,28070388,28070440,28070538,28075382,28075480,28075713,28075857,28075894,28076035,28076212,28076298,28076372,28076413,28076461,28076503,28076546,28076591,28076631,28076663,28076746,28076906,28077624,28077669,28117891,28121633,28122108,28122398,28122888,28123616,28124356,28124827,28126260,28126649,28127235,28128266,28128615,28129277,28130573,28130860,28131054,28131123,28132125,28133989,28134383,28134635,28135679,28181729,28183755,28184217,28184282,28184459,28184598,28184644,28184683,28184736,28184777,28184816,28184876,28184920,28184960,28184987,28185030,28185095,28185114,28185167,28229798,28233042,28236305,28236478,28236621,28236758,28236870,28236933,28237179,28237271,28237427,28237578,28237672,28237706,28237830,28237923,28238058,28238129,28240915,28330495,28330671,28330774,28330936,28331024,28331105,28331274,28331560,28331612,28331780,2833188', 'assoc_port': '28067787:28068933,28067788:28070440,28067789:28069552,28067790:28069611,28067791:28069987,28067792:28070048,28067793:28070388,28067794:28070334,28067795:28070167,28067796:28070317,28067797:28070242,28067798:28070092,28067799:28070013,28067801:28070280,28067804:28069951,28067807:28069877,28067810:28069742,28067813:28069661,28067817:28069751,28067820:28067887,28069259:28069832,28070470:28070538,28075301:28075382,28075302:28075480,28075303:28075713,28075305:28075857,28075307:28075894,28075309:28076035,28075311:28076212,28075313:28076298,28075315:28076591,28075317:28076631,28075319:28076503,28075321:28076663,28075324:28076546,28075327:28077624,28075330:28076413,28075333:28077669,28075336:28076372,28075339:28076461,28076694:28076746,28076878:28076906,28111813:28117891,28119041:28131123,28119044:28131054,28119047:28130860,28119050:28130573,28119053:28135679,28119057:28134635,28119059:28134383,28119063:28129277,28119077:28127235,28119086:28132125,28119101:28126649,28119124:28124827,28119128:28124356,28119132:2812861', 'assoc_mat': '28067787:pet_clair:4230:28068933,28067788:pet_clair:4230:28070440,28067789:pet_clair:4230:28069552,28067790:pet_clair:4230:28069611,28067791:pet_clair:4230:28069987,28067792:pet_clair:4230:28070048,28067793:pet_clair:4230:28070388,28067794:pet_clair:4230:28070334,28067795:pet_clair:4230:28070167,28067796:pet_clair:4230:28070317,28067797:pet_clair:4230:28070242,28067798:pet_clair:4230:28070092,28067799:pet_clair:4230:28070013,28067801:pet_clair:4230:28070280,28067804:pet_clair:4230:28069951,28067807:pet_clair:4230:28069877,28067810:pet_clair:4230:28069742,28067813:pet_clair:4230:28069661,28067817:pet_clair:4230:28069751,28067820:pet_clair:4230:28067887,28069259:pet_clair:4230:28069832,28070470:pet_clair:4230:28070538,28075301:pet_clair:4230:28075382,28075302:pet_clair:4230:28075480,28075303:pet_clair:4230:28075713,28075305:pet_clair:4230:28075857,28075307:pet_clair:4230:28075894,28075309:pet_clair:4230:28076035,28075311:pet_clair:4230:28076212,28075313:pet_clair:4230:28076298,28075315:pet_clair:4230:28076591,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0030076582100091, 'nb_photo': 661, 'list_port_cont': '28069653,28069721,28069738,28070018,28070056,28070098,28070240,28070274,28070333,28070385,28070534,28076465,28076632,28076669,28076750,28117903,28121625,28122103,28122390,28122880,28124831,28126255,28126651,28128257,28132134,28133993,28134371,28134633,28183754,28184609,28184640,28184680,28184742,28184773,28184812,28184928,28184964,28185040,28185090,28185157,28229790,28233055,28236298,28236483,28236629,28236867,28236931,28237183,28237263,28237418,28237574,28237665,28237831,28237913,28238060,28330493,28330675,28330776,28331021,28331109,28331276,28331607,28331878,28332173,28332445,28332528,28335617,28335802,28337504,28337964,28337971,28338248,28338711,28338951,28339021,28339060,28339278,28339718,28339743,28339979,28362851,28362925,28363107,28363340,28363405,28363518,28368446,28368515,28368683,28412742,28412792,28412953,28413098,28413255,28413316,28413448,28413658,28414076,28435578,28435852,28435891,28436210,28436497,28436620,28436756,28436935,28437051,28437119,28437197,28469824,28469868,28470032,28470084,2847020', 'assoc_port': '28067792:28070056,28067793:28070385,28067794:28070333,28067797:28070240,28067798:28070098,28067799:28070018,28067801:28070274,28067810:28069738,28067813:28069653,28067817:28069721,28070470:28070534,28075317:28076632,28075321:28076669,28075339:28076465,28076694:28076750,28111813:28117903,28119057:28134633,28119059:28134371,28119086:28132134,28119101:28126651,28119124:28124831,28119139:28122880,28119142:28133993,28119146:28122390,28119150:28122103,28119153:28126255,28121341:28121625,28123207:28128257,28181605:28185040,28181608:28184928,28181637:28184773,28181638:28185090,28181640:28185157,28181641:28184742,28181643:28184680,28181644:28184609,28181646:28184812,28181647:28184964,28181653:28184640,28183615:28183754,28229583:28238060,28229584:28237831,28229597:28237913,28229598:28237574,28229611:28237665,28229614:28237418,28229615:28237183,28229616:28237263,28229617:28236931,28229618:28236867,28229621:28236629,28229631:28236483,28229635:28236298,28229640:28229790,28232611:28233055,28276909:28339979,28276911:2833974', 'assoc_mat': '28067792:pet_fonce:4230:28070056,28067793:pet_fonce:4230:28070385,28067794:pet_fonce:4230:28070333,28067797:pet_fonce:4230:28070240,28067798:pet_fonce:4230:28070098,28067799:pet_fonce:4230:28070018,28067801:pet_fonce:4230:28070274,28067810:pet_fonce:4230:28069738,28067813:pet_fonce:4230:28069653,28067817:pet_fonce:4230:28069721,28070470:pet_fonce:4230:28070534,28075317:pet_fonce:4230:28076632,28075321:pet_fonce:4230:28076669,28075339:pet_fonce:4230:28076465,28076694:pet_fonce:4230:28076750,28111813:pet_fonce:4230:28117903,28119057:pet_fonce:4230:28134633,28119059:pet_fonce:4230:28134371,28119086:pet_fonce:4230:28132134,28119101:pet_fonce:4230:28126651,28119124:pet_fonce:4230:28124831,28119139:pet_fonce:4230:28122880,28119142:pet_fonce:4230:28133993,28119146:pet_fonce:4230:28122390,28119150:pet_fonce:4230:28122103,28119153:pet_fonce:4230:28126255,28121341:pet_fonce:4230:28121625,28123207:pet_fonce:4230:28128257,28181605:pet_fonce:4230:28185040,28181608:pet_fonce:4230:28184928,28181637:pet_fonce:4230:28184773,2'}), 'main_stat': {'nb_photos': 1438}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-11', 0.7518545156661435),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_11_annee_2025.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.45%', 14186], 'carton': ['carton', '5.49%', 88049], 'metal': ['metal', '0.14%', 1629], 'papier': ['papier', '16.96%', 252150], 'pehd': ['pehd', '0.36%', 1769], 'pet_clair': ['pet_clair', '1.37%', 20194], 'pet_fonce': ['pet_fonce', '0.3%', 661]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_11_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.80user 2.67system 0:07.14elapsed 76%CPU (0avgtext+0avgdata 184388maxresident)k 3048inputs+272outputs (68major+47876minor)pagefaults 0swaps