python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 11 mtr_id : dashboard_places : SCCU_cam6 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_cam6' 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 = 202 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 = 202 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 = 202 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_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "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 (2501833,2503323,2510380,2519613,2528253,2537427,2546984,2553362,2555867,2563741,2571272,2578460,2584768,2592279,2598227,2598791,2605095,2613596,2621072,2668429,2635011,2638882,2639756,2644925,2651924,2658915,2664681,2671883,2676263,2677589) 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.01508372437039924, 'nb_photo': 19992, 'list_port_cont': '28068025,28068208,28068304,28068313,28068558,28068607,28068761,28068808,28068966,28068998,28069044,28069285,28069348,28069403,28069438,28069496,28069588,28069789,28069904,28070131,28070499,28070620,28071135,28075925,28075957,28076151,28076191,28076219,28076326,28076446,28076713,28076837,28076948,28076973,28077094,28077293,28077355,28077436,28077483,28077512,28077556,28077593,28077696,28077778,28077894,28078326,28078405,28117830,28120510,28120553,28120877,28121758,28121891,28122288,28123111,28123936,28124726,28125259,28125789,28126349,28126730,28126967,28128881,28129063,28129418,28130308,28132298,28132694,28133790,28135162,28137364,28181796,28181893,28181967,28182004,28182039,28182150,28182188,28182326,28182369,28182572,28182847,28183007,28183141,28183315,28183676,28183955,28183993,28184160,28185343,28185625,28186101,28186309,28186832,28186905,28228330,28230937,28231857,28231916,28232034,28232342,28232782,28233123,28233483,28233715,28233779,28233982,28234572,28234641,28234661,28235056,28235122,28235316,2823562', 'assoc_port': '28067800:28069789,28067803:28070131,28067806:28069588,28067809:28069403,28067812:28069348,28067815:28069904,28067818:28069496,28067821:28069044,28067823:28069285,28067826:28068998,28067828:28068808,28067831:28068966,28067833:28071135,28067836:28068558,28067839:28068607,28067841:28068304,28067844:28068761,28067846:28070620,28067849:28068208,28067851:28068025,28067854:28068313,28069320:28069438,28070472:28070499,28075304:28076948,28075306:28077778,28075308:28077696,28075310:28076191,28075312:28076326,28075314:28078405,28075316:28076837,28075318:28076151,28075320:28076446,28075323:28077512,28075326:28075957,28075329:28076219,28075332:28078326,28075335:28077355,28075338:28075925,28075341:28077593,28075343:28077556,28075345:28077483,28075347:28077894,28075349:28077436,28075350:28077293,28075353:28077094,28076696:28076713,28076879:28076973,28111765:28117830,28119039:28129418,28119043:28128881,28119046:28132298,28119049:28126967,28119052:28130308,28119056:28126730,28119060:28124726,28119064:28126349,28119075:2812906', 'assoc_mat': '28067800:autre:4230:28069789,28067803:autre:4230:28070131,28067806:autre:4230:28069588,28067809:autre:4230:28069403,28067812:autre:4230:28069348,28067815:autre:4230:28069904,28067818:autre:4230:28069496,28067821:autre:4230:28069044,28067823:autre:4230:28069285,28067826:autre:4230:28068998,28067828:autre:4230:28068808,28067831:autre:4230:28068966,28067833:autre:4230:28071135,28067836:autre:4230:28068558,28067839:autre:4230:28068607,28067841:autre:4230:28068304,28067844:autre:4230:28068761,28067846:autre:4230:28070620,28067849:autre:4230:28068208,28067851:autre:4230:28068025,28067854:autre:4230:28068313,28069320:autre:4230:28069438,28070472:autre:4230:28070499,28075304:autre:4230:28076948,28075306:autre:4230:28077778,28075308:autre:4230:28077696,28075310:autre:4230:28076191,28075312:autre:4230:28076326,28075314:autre:4230:28078405,28075316:autre:4230:28076837,28075318:autre:4230:28076151,28075320:autre:4230:28076446,28075323:autre:4230:28077512,28075326:autre:4230:28075957,28075329:autre:4230:28076219,28075332:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.051600019292880155, 'nb_photo': 97231, 'list_port_cont': '28068021,28068204,28068306,28068329,28068566,28068613,28068764,28068815,28068969,28069004,28069045,28069297,28069343,28069402,28069441,28069494,28069583,28069797,28069908,28070132,28070498,28070625,28071130,28075933,28075969,28076148,28076188,28076227,28076328,28076434,28076711,28076851,28076947,28076978,28077108,28077292,28077360,28077445,28077480,28077517,28077547,28077592,28077703,28077781,28077900,28078331,28078402,28117823,28120505,28120547,28120867,28121766,28121900,28122291,28123121,28123951,28124715,28125258,28125785,28126363,28126739,28126964,28128885,28129055,28129419,28130318,28132295,28132696,28133804,28135161,28137372,28181803,28181894,28181972,28182013,28182053,28182156,28182197,28182323,28182357,28182579,28182850,28182998,28183156,28183317,28183673,28183953,28183998,28184172,28185353,28185622,28186096,28186304,28186826,28186904,28228346,28230944,28231849,28231934,28232038,28232345,28232798,28233131,28233498,28233724,28233787,28233978,28234580,28234635,28234653,28235053,28235129,28235320,2823560', 'assoc_port': '28067800:28069797,28067803:28070132,28067806:28069583,28067809:28069402,28067812:28069343,28067815:28069908,28067818:28069494,28067821:28069045,28067823:28069297,28067826:28069004,28067828:28068815,28067831:28068969,28067833:28071130,28067836:28068566,28067839:28068613,28067841:28068306,28067844:28068764,28067846:28070625,28067849:28068204,28067851:28068021,28067854:28068329,28069320:28069441,28070472:28070498,28075304:28076947,28075306:28077781,28075308:28077703,28075310:28076188,28075312:28076328,28075314:28078402,28075316:28076851,28075318:28076148,28075320:28076434,28075323:28077517,28075326:28075969,28075329:28076227,28075332:28078331,28075335:28077360,28075338:28075933,28075341:28077592,28075343:28077547,28075345:28077480,28075347:28077900,28075349:28077445,28075350:28077292,28075353:28077108,28076696:28076711,28076879:28076978,28111765:28117823,28119039:28129419,28119043:28128885,28119046:28132295,28119049:28126964,28119052:28130318,28119056:28126739,28119060:28124715,28119064:28126363,28119075:2812905', 'assoc_mat': '28067800:carton:4230:28069797,28067803:carton:4230:28070132,28067806:carton:4230:28069583,28067809:carton:4230:28069402,28067812:carton:4230:28069343,28067815:carton:4230:28069908,28067818:carton:4230:28069494,28067821:carton:4230:28069045,28067823:carton:4230:28069297,28067826:carton:4230:28069004,28067828:carton:4230:28068815,28067831:carton:4230:28068969,28067833:carton:4230:28071130,28067836:carton:4230:28068566,28067839:carton:4230:28068613,28067841:carton:4230:28068306,28067844:carton:4230:28068764,28067846:carton:4230:28070625,28067849:carton:4230:28068204,28067851:carton:4230:28068021,28067854:carton:4230:28068329,28069320:carton:4230:28069441,28070472:carton:4230:28070498,28075304:carton:4230:28076947,28075306:carton:4230:28077781,28075308:carton:4230:28077703,28075310:carton:4230:28076188,28075312:carton:4230:28076328,28075314:carton:4230:28078402,28075316:carton:4230:28076851,28075318:carton:4230:28076148,28075320:carton:4230:28076434,28075323:carton:4230:28077517,28075326:carton:4230:28075969,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012550936076088759, 'nb_photo': 1618, 'list_port_cont': '28068017,28068212,28068328,28068565,28068608,28068801,28068973,28069001,28069051,28069287,28069346,28069391,28069434,28069488,28069577,28069799,28069906,28070120,28070501,28070616,28071120,28075921,28075960,28076146,28076194,28076248,28076338,28076439,28076715,28076845,28076945,28076983,28077097,28077440,28077472,28077507,28077591,28077700,28077784,28077903,28078327,28078392,28117818,28120506,28120554,28120878,28121886,28122289,28123106,28123944,28124728,28125260,28125769,28126353,28126727,28126957,28129057,28129413,28132312,28132684,28133806,28135173,28137362,28181978,28182017,28182046,28182146,28182200,28182325,28182365,28182586,28182856,28182997,28183163,28183301,28183682,28183948,28183989,28184171,28186102,28186820,28186907,28228329,28230935,28231856,28231918,28232039,28232338,28232785,28233122,28233481,28233713,28233785,28233976,28234644,28234662,28235123,28235599,28236205,28236330,28281903,28329682,28330067,28330093,28330168,28330298,28330736,28333351,28333565,28333693,28333917,28334027,28334125,2833418', 'assoc_port': '28067800:28069799,28067803:28070120,28067806:28069577,28067809:28069391,28067812:28069346,28067815:28069906,28067818:28069488,28067821:28069051,28067823:28069287,28067826:28069001,28067828:28068801,28067831:28068973,28067833:28071120,28067836:28068565,28067839:28068608,28067846:28070616,28067849:28068212,28067851:28068017,28067854:28068328,28069320:28069434,28070472:28070501,28075304:28076945,28075306:28077784,28075308:28077700,28075310:28076194,28075312:28076338,28075314:28078392,28075316:28076845,28075318:28076146,28075320:28076439,28075323:28077507,28075326:28075960,28075329:28076248,28075332:28078327,28075338:28075921,28075341:28077591,28075345:28077472,28075347:28077903,28075349:28077440,28075353:28077097,28076696:28076715,28076879:28076983,28111765:28117818,28119039:28129413,28119046:28132312,28119049:28126957,28119056:28126727,28119060:28124728,28119064:28126353,28119075:28129057,28119087:28123944,28119098:28123106,28119123:28137362,28119127:28132684,28119131:28122289,28119138:28125769,28119141:2813517', 'assoc_mat': '28067800:metal:4230:28069799,28067803:metal:4230:28070120,28067806:metal:4230:28069577,28067809:metal:4230:28069391,28067812:metal:4230:28069346,28067815:metal:4230:28069906,28067818:metal:4230:28069488,28067821:metal:4230:28069051,28067823:metal:4230:28069287,28067826:metal:4230:28069001,28067828:metal:4230:28068801,28067831:metal:4230:28068973,28067833:metal:4230:28071120,28067836:metal:4230:28068565,28067839:metal:4230:28068608,28067846:metal:4230:28070616,28067849:metal:4230:28068212,28067851:metal:4230:28068017,28067854:metal:4230:28068328,28069320:metal:4230:28069434,28070472:metal:4230:28070501,28075304:metal:4230:28076945,28075306:metal:4230:28077784,28075308:metal:4230:28077700,28075310:metal:4230:28076194,28075312:metal:4230:28076338,28075314:metal:4230:28078392,28075316:metal:4230:28076845,28075318:metal:4230:28076146,28075320:metal:4230:28076439,28075323:metal:4230:28077507,28075326:metal:4230:28075960,28075329:metal:4230:28076248,28075332:metal:4230:28078327,28075338:metal:4230:28075921,28075341:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2057401794615194, 'nb_photo': 456638, 'list_port_cont': '28068024,28068213,28068308,28068323,28068567,28068619,28068755,28068807,28068975,28069008,28069052,28069286,28069342,28069406,28069442,28069492,28069578,28069803,28069909,28070130,28070496,28070614,28071134,28075935,28075970,28076155,28076186,28076242,28076334,28076440,28076706,28076849,28076938,28076972,28077110,28077296,28077367,28077435,28077477,28077519,28077554,28077590,28077695,28077779,28077907,28078321,28078406,28117831,28120498,28120555,28120875,28121767,28121899,28122284,28123120,28123941,28124718,28125261,28125783,28126360,28126743,28126965,28128884,28129061,28129414,28130313,28132313,28132692,28133795,28135170,28137352,28181808,28181900,28181973,28182016,28182047,28182157,28182186,28182332,28182366,28182582,28182857,28183004,28183164,28183307,28183679,28183959,28183994,28184157,28185347,28185630,28186100,28186308,28186816,28186910,28228340,28230946,28231858,28231928,28232040,28232350,28232793,28233134,28233506,28233720,28233784,28233972,28234578,28234642,28234660,28235063,28235127,28235322,2823560', 'assoc_port': '28067800:28069803,28067803:28070130,28067806:28069578,28067809:28069406,28067812:28069342,28067815:28069909,28067818:28069492,28067821:28069052,28067823:28069286,28067826:28069008,28067828:28068807,28067831:28068975,28067833:28071134,28067836:28068567,28067839:28068619,28067841:28068308,28067844:28068755,28067846:28070614,28067849:28068213,28067851:28068024,28067854:28068323,28069320:28069442,28070472:28070496,28075304:28076938,28075306:28077779,28075308:28077695,28075310:28076186,28075312:28076334,28075314:28078406,28075316:28076849,28075318:28076155,28075320:28076440,28075323:28077519,28075326:28075970,28075329:28076242,28075332:28078321,28075335:28077367,28075338:28075935,28075341:28077590,28075343:28077554,28075345:28077477,28075347:28077907,28075349:28077435,28075350:28077296,28075353:28077110,28076696:28076706,28076879:28076972,28111765:28117831,28119039:28129414,28119043:28128884,28119046:28132313,28119049:28126965,28119052:28130313,28119056:28126743,28119060:28124718,28119064:28126360,28119075:2812906', 'assoc_mat': '28067800:papier:4230:28069803,28067803:papier:4230:28070130,28067806:papier:4230:28069578,28067809:papier:4230:28069406,28067812:papier:4230:28069342,28067815:papier:4230:28069909,28067818:papier:4230:28069492,28067821:papier:4230:28069052,28067823:papier:4230:28069286,28067826:papier:4230:28069008,28067828:papier:4230:28068807,28067831:papier:4230:28068975,28067833:papier:4230:28071134,28067836:papier:4230:28068567,28067839:papier:4230:28068619,28067841:papier:4230:28068308,28067844:papier:4230:28068755,28067846:papier:4230:28070614,28067849:papier:4230:28068213,28067851:papier:4230:28068024,28067854:papier:4230:28068323,28069320:papier:4230:28069442,28070472:papier:4230:28070496,28075304:papier:4230:28076938,28075306:papier:4230:28077779,28075308:papier:4230:28077695,28075310:papier:4230:28076186,28075312:papier:4230:28076334,28075314:papier:4230:28078406,28075316:papier:4230:28076849,28075318:papier:4230:28076155,28075320:papier:4230:28076440,28075323:papier:4230:28077519,28075326:papier:4230:28075970,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003836693774034915, 'nb_photo': 2725, 'list_port_cont': '28068026,28068211,28068311,28068321,28068570,28068622,28068754,28068812,28068974,28069015,28069048,28069298,28069350,28069408,28069444,28069490,28069579,28069806,28069903,28070119,28070497,28070621,28071136,28075927,28075968,28076154,28076184,28076221,28076336,28076447,28076718,28076844,28076949,28076980,28077111,28077295,28077365,28077447,28077484,28077543,28077587,28077707,28077776,28078330,28078404,28117821,28120501,28120549,28120868,28121765,28121902,28123119,28123940,28124724,28125255,28125788,28126358,28126961,28129060,28129422,28132689,28133799,28135168,28137363,28181891,28181977,28182008,28182041,28182158,28182194,28182333,28182371,28182585,28182848,28183002,28183136,28183306,28183685,28183951,28183988,28184167,28185354,28185624,28186104,28186302,28186828,28186898,28228341,28230941,28231853,28231922,28232032,28232337,28232797,28233135,28233502,28233722,28233781,28233979,28234643,28234657,28235121,28235314,28235612,28235675,28235889,28236199,28236335,28281911,28329676,28330077,28330096,28330173,2833025', 'assoc_port': '28067800:28069806,28067803:28070119,28067806:28069579,28067809:28069408,28067812:28069350,28067815:28069903,28067818:28069490,28067821:28069048,28067823:28069298,28067826:28069015,28067828:28068812,28067831:28068974,28067833:28071136,28067836:28068570,28067839:28068622,28067841:28068311,28067844:28068754,28067846:28070621,28067849:28068211,28067851:28068026,28067854:28068321,28069320:28069444,28070472:28070497,28075304:28076949,28075306:28077776,28075308:28077707,28075310:28076184,28075312:28076336,28075314:28078404,28075316:28076844,28075318:28076154,28075320:28076447,28075326:28075968,28075329:28076221,28075332:28078330,28075335:28077365,28075338:28075927,28075341:28077587,28075343:28077543,28075345:28077484,28075349:28077447,28075350:28077295,28075353:28077111,28076696:28076718,28076879:28076980,28111765:28117821,28119039:28129422,28119049:28126961,28119060:28124724,28119064:28126358,28119075:28129060,28119087:28123940,28119098:28123119,28119123:28137363,28119127:28132689,28119134:28121765,28119138:2812578', 'assoc_mat': '28067800:pehd:4230:28069806,28067803:pehd:4230:28070119,28067806:pehd:4230:28069579,28067809:pehd:4230:28069408,28067812:pehd:4230:28069350,28067815:pehd:4230:28069903,28067818:pehd:4230:28069490,28067821:pehd:4230:28069048,28067823:pehd:4230:28069298,28067826:pehd:4230:28069015,28067828:pehd:4230:28068812,28067831:pehd:4230:28068974,28067833:pehd:4230:28071136,28067836:pehd:4230:28068570,28067839:pehd:4230:28068622,28067841:pehd:4230:28068311,28067844:pehd:4230:28068754,28067846:pehd:4230:28070621,28067849:pehd:4230:28068211,28067851:pehd:4230:28068026,28067854:pehd:4230:28068321,28069320:pehd:4230:28069444,28070472:pehd:4230:28070497,28075304:pehd:4230:28076949,28075306:pehd:4230:28077776,28075308:pehd:4230:28077707,28075310:pehd:4230:28076184,28075312:pehd:4230:28076336,28075314:pehd:4230:28078404,28075316:pehd:4230:28076844,28075318:pehd:4230:28076154,28075320:pehd:4230:28076447,28075326:pehd:4230:28075968,28075329:pehd:4230:28076221,28075332:pehd:4230:28078330,28075335:pehd:4230:28077365,28075338:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011647047192514116, 'nb_photo': 23171, 'list_port_cont': '28068022,28068209,28068310,28068324,28068573,28068623,28068760,28068813,28068976,28069013,28069056,28069292,28069338,28069405,28069440,28069489,28069582,28069798,28069911,28070133,28070495,28070618,28071129,28075936,28075964,28076157,28076190,28076222,28076339,28076444,28076712,28076847,28076942,28076985,28077107,28077290,28077364,28077446,28077478,28077513,28077557,28077589,28077708,28077785,28077911,28078319,28078407,28117825,28120508,28120556,28120876,28121752,28121892,28122287,28123123,28123946,28124719,28125264,28125784,28126362,28126738,28126951,28128886,28129052,28129420,28130317,28132304,28132682,28133803,28135166,28137371,28181804,28181897,28181976,28182006,28182049,28182159,28182192,28182334,28182361,28182584,28182858,28183006,28183160,28183313,28183686,28183956,28183984,28184168,28185342,28185629,28186093,28186296,28186807,28186911,28228343,28230945,28231859,28231930,28232037,28232346,28232794,28233121,28233500,28233726,28233776,28233983,28234576,28234638,28234647,28235062,28235120,28235327,2823560', 'assoc_port': '28067800:28069798,28067803:28070133,28067806:28069582,28067809:28069405,28067812:28069338,28067815:28069911,28067818:28069489,28067821:28069056,28067823:28069292,28067826:28069013,28067828:28068813,28067831:28068976,28067833:28071129,28067836:28068573,28067839:28068623,28067841:28068310,28067844:28068760,28067846:28070618,28067849:28068209,28067851:28068022,28067854:28068324,28069320:28069440,28070472:28070495,28075304:28076942,28075306:28077785,28075308:28077708,28075310:28076190,28075312:28076339,28075314:28078407,28075316:28076847,28075318:28076157,28075320:28076444,28075323:28077513,28075326:28075964,28075329:28076222,28075332:28078319,28075335:28077364,28075338:28075936,28075341:28077589,28075343:28077557,28075345:28077478,28075347:28077911,28075349:28077446,28075350:28077290,28075353:28077107,28076696:28076712,28076879:28076985,28111765:28117825,28119039:28129420,28119043:28128886,28119046:28132304,28119049:28126951,28119052:28130317,28119056:28126738,28119060:28124719,28119064:28126362,28119075:2812905', 'assoc_mat': '28067800:pet_clair:4230:28069798,28067803:pet_clair:4230:28070133,28067806:pet_clair:4230:28069582,28067809:pet_clair:4230:28069405,28067812:pet_clair:4230:28069338,28067815:pet_clair:4230:28069911,28067818:pet_clair:4230:28069489,28067821:pet_clair:4230:28069056,28067823:pet_clair:4230:28069292,28067826:pet_clair:4230:28069013,28067828:pet_clair:4230:28068813,28067831:pet_clair:4230:28068976,28067833:pet_clair:4230:28071129,28067836:pet_clair:4230:28068573,28067839:pet_clair:4230:28068623,28067841:pet_clair:4230:28068310,28067844:pet_clair:4230:28068760,28067846:pet_clair:4230:28070618,28067849:pet_clair:4230:28068209,28067851:pet_clair:4230:28068022,28067854:pet_clair:4230:28068324,28069320:pet_clair:4230:28069440,28070472:pet_clair:4230:28070495,28075304:pet_clair:4230:28076942,28075306:pet_clair:4230:28077785,28075308:pet_clair:4230:28077708,28075310:pet_clair:4230:28076190,28075312:pet_clair:4230:28076339,28075314:pet_clair:4230:28078407,28075316:pet_clair:4230:28076847,28075318:pet_clair:4230:28076157,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002818190424007402, 'nb_photo': 1159, 'list_port_cont': '28068299,28068327,28068568,28068617,28068751,28068972,28069014,28069057,28069289,28069349,28069437,28069498,28069581,28069914,28070128,28070490,28071127,28075934,28076150,28076448,28076714,28076940,28076981,28077104,28077482,28077553,28077580,28077711,28077783,28117828,28120507,28120552,28120874,28121755,28121894,28123122,28123945,28124731,28125263,28125787,28126364,28126740,28129047,28132308,28132690,28135172,28181807,28181903,28181980,28182009,28182050,28182155,28182185,28182328,28182368,28182841,28182995,28183151,28183683,28183961,28183997,28185348,28185623,28186105,28186305,28186808,28186909,28228338,28230943,28231933,28232041,28232789,28233132,28233494,28233771,28233985,28234634,28234659,28235067,28235691,28235894,28236224,28236336,28281913,28329695,28330080,28330099,28330169,28330245,28330296,28330743,28333354,28333559,28333644,28333691,28333919,28334033,28334113,28334184,28334218,28334435,28335281,28335355,28335391,28335684,28335779,28335888,28335954,28336188,28336367,28336458,28336544,28336595,2833677', 'assoc_port': '28067803:28070128,28067806:28069581,28067812:28069349,28067815:28069914,28067818:28069498,28067821:28069057,28067823:28069289,28067826:28069014,28067831:28068972,28067833:28071127,28067836:28068568,28067839:28068617,28067841:28068299,28067844:28068751,28067854:28068327,28069320:28069437,28070472:28070490,28075304:28076940,28075306:28077783,28075308:28077711,28075318:28076150,28075320:28076448,28075338:28075934,28075341:28077580,28075343:28077553,28075345:28077482,28075353:28077104,28076696:28076714,28076879:28076981,28111765:28117828,28119046:28132308,28119056:28126740,28119060:28124731,28119064:28126364,28119075:28129047,28119087:28123945,28119098:28123122,28119127:28132690,28119134:28121755,28119138:28125787,28119141:28135172,28119145:28125263,28119149:28120874,28119152:28120507,28119156:28120552,28121302:28121894,28181654:28183683,28181658:28183997,28181660:28186909,28181664:28186808,28181669:28185348,28181672:28182995,28181674:28186305,28181677:28183151,28181683:28182841,28181685:28182185,28181688:2818215', 'assoc_mat': '28067803:pet_fonce:4230:28070128,28067806:pet_fonce:4230:28069581,28067812:pet_fonce:4230:28069349,28067815:pet_fonce:4230:28069914,28067818:pet_fonce:4230:28069498,28067821:pet_fonce:4230:28069057,28067823:pet_fonce:4230:28069289,28067826:pet_fonce:4230:28069014,28067831:pet_fonce:4230:28068972,28067833:pet_fonce:4230:28071127,28067836:pet_fonce:4230:28068568,28067839:pet_fonce:4230:28068617,28067841:pet_fonce:4230:28068299,28067844:pet_fonce:4230:28068751,28067854:pet_fonce:4230:28068327,28069320:pet_fonce:4230:28069437,28070472:pet_fonce:4230:28070490,28075304:pet_fonce:4230:28076940,28075306:pet_fonce:4230:28077783,28075308:pet_fonce:4230:28077711,28075318:pet_fonce:4230:28076150,28075320:pet_fonce:4230:28076448,28075338:pet_fonce:4230:28075934,28075341:pet_fonce:4230:28077580,28075343:pet_fonce:4230:28077553,28075345:pet_fonce:4230:28077482,28075353:pet_fonce:4230:28077104,28076696:pet_fonce:4230:28076714,28076879:pet_fonce:4230:28076981,28111765:pet_fonce:4230:28117828,28119046:pet_fonce:4230:28132308,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(2501833,2503323,2510380,2519613,2528253,2537427,2546984,2553362,2555867,2563741,2571272,2578460,2584768,2592279,2598227,2598791,2605095,2613596,2621072,2668429,2635011,2638882,2639756,2644925,2651924,2658915,2664681,2671883,2676263,2677589)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-11-01' and date <= '2025-11-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1910,),), 'unwanted_material_monthly_percentage': ((0.728973903504821,),), 'material_repartition': (('incineration', 1910),), 'material_dict': {'incineration': 1910}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 11, 1), 0.6564524420344995, 3), (datetime.date(2025, 11, 2), 0.7156049324861564, 3), (datetime.date(2025, 11, 3), 0.6947740313264259, 2), (datetime.date(2025, 11, 4), 0.6993368893370877, 4), (datetime.date(2025, 11, 5), 0.6565217301880245, 1), (datetime.date(2025, 11, 6), 0.658770337918953, 2), (datetime.date(2025, 11, 7), 0.6540707059959381, 1), (datetime.date(2025, 11, 8), 0.6910025838594922, 2), (datetime.date(2025, 11, 9), 0.78368359808601, 3), (datetime.date(2025, 11, 10), 0.7627996958514611, 2), (datetime.date(2025, 11, 11), 0.7961831698730412, 1), (datetime.date(2025, 11, 12), 0.776321299394225, 3), (datetime.date(2025, 11, 13), 0.7326797174057935, 4), (datetime.date(2025, 11, 14), 0.7018117358757917, 1), (datetime.date(2025, 11, 15), 0.7035483942547348, 3), (datetime.date(2025, 11, 16), 0.7395917711134115, 3), (datetime.date(2025, 11, 17), 0.7412149319972998, 3), (datetime.date(2025, 11, 18), 0.7942603261996996, 2), (datetime.date(2025, 11, 19), 0.6911191450986566, 3), (datetime.date(2025, 11, 20), 0.6885007438142253, 4), (datetime.date(2025, 11, 21), 0.712657298767642, 2), (datetime.date(2025, 11, 22), 0.7034528929192293, 2), (datetime.date(2025, 11, 23), 0.7680715695137208, 2), (datetime.date(2025, 11, 24), 0.7901121768516461, 4), (datetime.date(2025, 11, 25), 0.7682510400822112, 4), (datetime.date(2025, 11, 26), 0.7546659521081922, 3), (datetime.date(2025, 11, 27), 0.7199490702617038, 2), (datetime.date(2025, 11, 28), 0.7057157408047884, 3), (datetime.date(2025, 11, 29), 0.7571424470367693, 4), (datetime.date(2025, 11, 30), 0.7932955809920411, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 11, 1), 0.6564524420344995, 3), (datetime.date(2025, 11, 2), 0.7156049324861564, 3), (datetime.date(2025, 11, 3), 0.6947740313264259, 2), (datetime.date(2025, 11, 4), 0.6993368893370877, 4), (datetime.date(2025, 11, 5), 0.6565217301880245, 1), (datetime.date(2025, 11, 6), 0.658770337918953, 2), (datetime.date(2025, 11, 7), 0.6540707059959381, 1), (datetime.date(2025, 11, 8), 0.6910025838594922, 2), (datetime.date(2025, 11, 9), 0.78368359808601, 3), (datetime.date(2025, 11, 10), 0.7627996958514611, 2), (datetime.date(2025, 11, 11), 0.7961831698730412, 1), (datetime.date(2025, 11, 12), 0.776321299394225, 3), (datetime.date(2025, 11, 13), 0.7326797174057935, 4), (datetime.date(2025, 11, 14), 0.7018117358757917, 1), (datetime.date(2025, 11, 15), 0.7035483942547348, 3), (datetime.date(2025, 11, 16), 0.7395917711134115, 3), (datetime.date(2025, 11, 17), 0.7412149319972998, 3), (datetime.date(2025, 11, 18), 0.7942603261996996, 2), (datetime.date(2025, 11, 19), 0.6911191450986566, 3), (datetime.date(2025, 11, 20), 0.6885007438142253, 4), (datetime.date(2025, 11, 21), 0.712657298767642, 2), (datetime.date(2025, 11, 22), 0.7034528929192293, 2), (datetime.date(2025, 11, 23), 0.7680715695137208, 2), (datetime.date(2025, 11, 24), 0.7901121768516461, 4), (datetime.date(2025, 11, 25), 0.7682510400822112, 4), (datetime.date(2025, 11, 26), 0.7546659521081922, 3), (datetime.date(2025, 11, 27), 0.7199490702617038, 2), (datetime.date(2025, 11, 28), 0.7057157408047884, 3), (datetime.date(2025, 11, 29), 0.7571424470367693, 4), (datetime.date(2025, 11, 30), 0.7932955809920411, 4))}, 'quality_array': [['-8.781602104052944', '01112025'], ['-8.586002917510337', '02112025'], ['-8.200843828447844', '03112025'], ['-8.301607024791764', '04112025'], ['-8.522643661534179', '05112025'], ['-8.56845692630202', '06112025'], ['-8.688056664283891', '07112025'], ['-8.600528842204135', '08112025'], ['-8.33453526141277', '09112025'], ['-8.026377679142618', '10112025'], ['-8.051650675475212', '11112025'], ['-7.516393624959675', '12112025'], ['-8.037185436525819', '13112025'], ['-8.18280954987854', '14112025'], ['-8.308178391550284', '15112025'], ['-8.121477798624978', '16112025'], ['-7.831282532602963', '17112025'], ['-7.893644509419767', '18112025'], ['-8.014555893644754', '19112025'], ['-8.44227092361186', '20112025'], ['-8.18294491522899', '21112025'], ['-8.244606085613253', '22112025'], ['-8.116508402346204', '23112025'], ['-7.526875706300245', '24112025'], ['-7.634304322900802', '25112025'], ['-8.064355152039035', '26112025'], ['-8.32237084063219', '27112025'], ['-8.364917803388439', '28112025'], ['-8.28458942878454', '29112025'], ['-7.97504834408964', '30112025']], 'number_of_batch': ((689,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01508372437039924, 'nb_photo': 19992, 'list_port_cont': '28068025,28068208,28068304,28068313,28068558,28068607,28068761,28068808,28068966,28068998,28069044,28069285,28069348,28069403,28069438,28069496,28069588,28069789,28069904,28070131,28070499,28070620,28071135,28075925,28075957,28076151,28076191,28076219,28076326,28076446,28076713,28076837,28076948,28076973,28077094,28077293,28077355,28077436,28077483,28077512,28077556,28077593,28077696,28077778,28077894,28078326,28078405,28117830,28120510,28120553,28120877,28121758,28121891,28122288,28123111,28123936,28124726,28125259,28125789,28126349,28126730,28126967,28128881,28129063,28129418,28130308,28132298,28132694,28133790,28135162,28137364,28181796,28181893,28181967,28182004,28182039,28182150,28182188,28182326,28182369,28182572,28182847,28183007,28183141,28183315,28183676,28183955,28183993,28184160,28185343,28185625,28186101,28186309,28186832,28186905,28228330,28230937,28231857,28231916,28232034,28232342,28232782,28233123,28233483,28233715,28233779,28233982,28234572,28234641,28234661,28235056,28235122,28235316,2823562', 'assoc_port': '28067800:28069789,28067803:28070131,28067806:28069588,28067809:28069403,28067812:28069348,28067815:28069904,28067818:28069496,28067821:28069044,28067823:28069285,28067826:28068998,28067828:28068808,28067831:28068966,28067833:28071135,28067836:28068558,28067839:28068607,28067841:28068304,28067844:28068761,28067846:28070620,28067849:28068208,28067851:28068025,28067854:28068313,28069320:28069438,28070472:28070499,28075304:28076948,28075306:28077778,28075308:28077696,28075310:28076191,28075312:28076326,28075314:28078405,28075316:28076837,28075318:28076151,28075320:28076446,28075323:28077512,28075326:28075957,28075329:28076219,28075332:28078326,28075335:28077355,28075338:28075925,28075341:28077593,28075343:28077556,28075345:28077483,28075347:28077894,28075349:28077436,28075350:28077293,28075353:28077094,28076696:28076713,28076879:28076973,28111765:28117830,28119039:28129418,28119043:28128881,28119046:28132298,28119049:28126967,28119052:28130308,28119056:28126730,28119060:28124726,28119064:28126349,28119075:2812906', 'assoc_mat': '28067800:autre:4230:28069789,28067803:autre:4230:28070131,28067806:autre:4230:28069588,28067809:autre:4230:28069403,28067812:autre:4230:28069348,28067815:autre:4230:28069904,28067818:autre:4230:28069496,28067821:autre:4230:28069044,28067823:autre:4230:28069285,28067826:autre:4230:28068998,28067828:autre:4230:28068808,28067831:autre:4230:28068966,28067833:autre:4230:28071135,28067836:autre:4230:28068558,28067839:autre:4230:28068607,28067841:autre:4230:28068304,28067844:autre:4230:28068761,28067846:autre:4230:28070620,28067849:autre:4230:28068208,28067851:autre:4230:28068025,28067854:autre:4230:28068313,28069320:autre:4230:28069438,28070472:autre:4230:28070499,28075304:autre:4230:28076948,28075306:autre:4230:28077778,28075308:autre:4230:28077696,28075310:autre:4230:28076191,28075312:autre:4230:28076326,28075314:autre:4230:28078405,28075316:autre:4230:28076837,28075318:autre:4230:28076151,28075320:autre:4230:28076446,28075323:autre:4230:28077512,28075326:autre:4230:28075957,28075329:autre:4230:28076219,28075332:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.051600019292880155, 'nb_photo': 97231, 'list_port_cont': '28068021,28068204,28068306,28068329,28068566,28068613,28068764,28068815,28068969,28069004,28069045,28069297,28069343,28069402,28069441,28069494,28069583,28069797,28069908,28070132,28070498,28070625,28071130,28075933,28075969,28076148,28076188,28076227,28076328,28076434,28076711,28076851,28076947,28076978,28077108,28077292,28077360,28077445,28077480,28077517,28077547,28077592,28077703,28077781,28077900,28078331,28078402,28117823,28120505,28120547,28120867,28121766,28121900,28122291,28123121,28123951,28124715,28125258,28125785,28126363,28126739,28126964,28128885,28129055,28129419,28130318,28132295,28132696,28133804,28135161,28137372,28181803,28181894,28181972,28182013,28182053,28182156,28182197,28182323,28182357,28182579,28182850,28182998,28183156,28183317,28183673,28183953,28183998,28184172,28185353,28185622,28186096,28186304,28186826,28186904,28228346,28230944,28231849,28231934,28232038,28232345,28232798,28233131,28233498,28233724,28233787,28233978,28234580,28234635,28234653,28235053,28235129,28235320,2823560', 'assoc_port': '28067800:28069797,28067803:28070132,28067806:28069583,28067809:28069402,28067812:28069343,28067815:28069908,28067818:28069494,28067821:28069045,28067823:28069297,28067826:28069004,28067828:28068815,28067831:28068969,28067833:28071130,28067836:28068566,28067839:28068613,28067841:28068306,28067844:28068764,28067846:28070625,28067849:28068204,28067851:28068021,28067854:28068329,28069320:28069441,28070472:28070498,28075304:28076947,28075306:28077781,28075308:28077703,28075310:28076188,28075312:28076328,28075314:28078402,28075316:28076851,28075318:28076148,28075320:28076434,28075323:28077517,28075326:28075969,28075329:28076227,28075332:28078331,28075335:28077360,28075338:28075933,28075341:28077592,28075343:28077547,28075345:28077480,28075347:28077900,28075349:28077445,28075350:28077292,28075353:28077108,28076696:28076711,28076879:28076978,28111765:28117823,28119039:28129419,28119043:28128885,28119046:28132295,28119049:28126964,28119052:28130318,28119056:28126739,28119060:28124715,28119064:28126363,28119075:2812905', 'assoc_mat': '28067800:carton:4230:28069797,28067803:carton:4230:28070132,28067806:carton:4230:28069583,28067809:carton:4230:28069402,28067812:carton:4230:28069343,28067815:carton:4230:28069908,28067818:carton:4230:28069494,28067821:carton:4230:28069045,28067823:carton:4230:28069297,28067826:carton:4230:28069004,28067828:carton:4230:28068815,28067831:carton:4230:28068969,28067833:carton:4230:28071130,28067836:carton:4230:28068566,28067839:carton:4230:28068613,28067841:carton:4230:28068306,28067844:carton:4230:28068764,28067846:carton:4230:28070625,28067849:carton:4230:28068204,28067851:carton:4230:28068021,28067854:carton:4230:28068329,28069320:carton:4230:28069441,28070472:carton:4230:28070498,28075304:carton:4230:28076947,28075306:carton:4230:28077781,28075308:carton:4230:28077703,28075310:carton:4230:28076188,28075312:carton:4230:28076328,28075314:carton:4230:28078402,28075316:carton:4230:28076851,28075318:carton:4230:28076148,28075320:carton:4230:28076434,28075323:carton:4230:28077517,28075326:carton:4230:28075969,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012550936076088759, 'nb_photo': 1618, 'list_port_cont': '28068017,28068212,28068328,28068565,28068608,28068801,28068973,28069001,28069051,28069287,28069346,28069391,28069434,28069488,28069577,28069799,28069906,28070120,28070501,28070616,28071120,28075921,28075960,28076146,28076194,28076248,28076338,28076439,28076715,28076845,28076945,28076983,28077097,28077440,28077472,28077507,28077591,28077700,28077784,28077903,28078327,28078392,28117818,28120506,28120554,28120878,28121886,28122289,28123106,28123944,28124728,28125260,28125769,28126353,28126727,28126957,28129057,28129413,28132312,28132684,28133806,28135173,28137362,28181978,28182017,28182046,28182146,28182200,28182325,28182365,28182586,28182856,28182997,28183163,28183301,28183682,28183948,28183989,28184171,28186102,28186820,28186907,28228329,28230935,28231856,28231918,28232039,28232338,28232785,28233122,28233481,28233713,28233785,28233976,28234644,28234662,28235123,28235599,28236205,28236330,28281903,28329682,28330067,28330093,28330168,28330298,28330736,28333351,28333565,28333693,28333917,28334027,28334125,2833418', 'assoc_port': '28067800:28069799,28067803:28070120,28067806:28069577,28067809:28069391,28067812:28069346,28067815:28069906,28067818:28069488,28067821:28069051,28067823:28069287,28067826:28069001,28067828:28068801,28067831:28068973,28067833:28071120,28067836:28068565,28067839:28068608,28067846:28070616,28067849:28068212,28067851:28068017,28067854:28068328,28069320:28069434,28070472:28070501,28075304:28076945,28075306:28077784,28075308:28077700,28075310:28076194,28075312:28076338,28075314:28078392,28075316:28076845,28075318:28076146,28075320:28076439,28075323:28077507,28075326:28075960,28075329:28076248,28075332:28078327,28075338:28075921,28075341:28077591,28075345:28077472,28075347:28077903,28075349:28077440,28075353:28077097,28076696:28076715,28076879:28076983,28111765:28117818,28119039:28129413,28119046:28132312,28119049:28126957,28119056:28126727,28119060:28124728,28119064:28126353,28119075:28129057,28119087:28123944,28119098:28123106,28119123:28137362,28119127:28132684,28119131:28122289,28119138:28125769,28119141:2813517', 'assoc_mat': '28067800:metal:4230:28069799,28067803:metal:4230:28070120,28067806:metal:4230:28069577,28067809:metal:4230:28069391,28067812:metal:4230:28069346,28067815:metal:4230:28069906,28067818:metal:4230:28069488,28067821:metal:4230:28069051,28067823:metal:4230:28069287,28067826:metal:4230:28069001,28067828:metal:4230:28068801,28067831:metal:4230:28068973,28067833:metal:4230:28071120,28067836:metal:4230:28068565,28067839:metal:4230:28068608,28067846:metal:4230:28070616,28067849:metal:4230:28068212,28067851:metal:4230:28068017,28067854:metal:4230:28068328,28069320:metal:4230:28069434,28070472:metal:4230:28070501,28075304:metal:4230:28076945,28075306:metal:4230:28077784,28075308:metal:4230:28077700,28075310:metal:4230:28076194,28075312:metal:4230:28076338,28075314:metal:4230:28078392,28075316:metal:4230:28076845,28075318:metal:4230:28076146,28075320:metal:4230:28076439,28075323:metal:4230:28077507,28075326:metal:4230:28075960,28075329:metal:4230:28076248,28075332:metal:4230:28078327,28075338:metal:4230:28075921,28075341:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2057401794615194, 'nb_photo': 456638, 'list_port_cont': '28068024,28068213,28068308,28068323,28068567,28068619,28068755,28068807,28068975,28069008,28069052,28069286,28069342,28069406,28069442,28069492,28069578,28069803,28069909,28070130,28070496,28070614,28071134,28075935,28075970,28076155,28076186,28076242,28076334,28076440,28076706,28076849,28076938,28076972,28077110,28077296,28077367,28077435,28077477,28077519,28077554,28077590,28077695,28077779,28077907,28078321,28078406,28117831,28120498,28120555,28120875,28121767,28121899,28122284,28123120,28123941,28124718,28125261,28125783,28126360,28126743,28126965,28128884,28129061,28129414,28130313,28132313,28132692,28133795,28135170,28137352,28181808,28181900,28181973,28182016,28182047,28182157,28182186,28182332,28182366,28182582,28182857,28183004,28183164,28183307,28183679,28183959,28183994,28184157,28185347,28185630,28186100,28186308,28186816,28186910,28228340,28230946,28231858,28231928,28232040,28232350,28232793,28233134,28233506,28233720,28233784,28233972,28234578,28234642,28234660,28235063,28235127,28235322,2823560', 'assoc_port': '28067800:28069803,28067803:28070130,28067806:28069578,28067809:28069406,28067812:28069342,28067815:28069909,28067818:28069492,28067821:28069052,28067823:28069286,28067826:28069008,28067828:28068807,28067831:28068975,28067833:28071134,28067836:28068567,28067839:28068619,28067841:28068308,28067844:28068755,28067846:28070614,28067849:28068213,28067851:28068024,28067854:28068323,28069320:28069442,28070472:28070496,28075304:28076938,28075306:28077779,28075308:28077695,28075310:28076186,28075312:28076334,28075314:28078406,28075316:28076849,28075318:28076155,28075320:28076440,28075323:28077519,28075326:28075970,28075329:28076242,28075332:28078321,28075335:28077367,28075338:28075935,28075341:28077590,28075343:28077554,28075345:28077477,28075347:28077907,28075349:28077435,28075350:28077296,28075353:28077110,28076696:28076706,28076879:28076972,28111765:28117831,28119039:28129414,28119043:28128884,28119046:28132313,28119049:28126965,28119052:28130313,28119056:28126743,28119060:28124718,28119064:28126360,28119075:2812906', 'assoc_mat': '28067800:papier:4230:28069803,28067803:papier:4230:28070130,28067806:papier:4230:28069578,28067809:papier:4230:28069406,28067812:papier:4230:28069342,28067815:papier:4230:28069909,28067818:papier:4230:28069492,28067821:papier:4230:28069052,28067823:papier:4230:28069286,28067826:papier:4230:28069008,28067828:papier:4230:28068807,28067831:papier:4230:28068975,28067833:papier:4230:28071134,28067836:papier:4230:28068567,28067839:papier:4230:28068619,28067841:papier:4230:28068308,28067844:papier:4230:28068755,28067846:papier:4230:28070614,28067849:papier:4230:28068213,28067851:papier:4230:28068024,28067854:papier:4230:28068323,28069320:papier:4230:28069442,28070472:papier:4230:28070496,28075304:papier:4230:28076938,28075306:papier:4230:28077779,28075308:papier:4230:28077695,28075310:papier:4230:28076186,28075312:papier:4230:28076334,28075314:papier:4230:28078406,28075316:papier:4230:28076849,28075318:papier:4230:28076155,28075320:papier:4230:28076440,28075323:papier:4230:28077519,28075326:papier:4230:28075970,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003836693774034915, 'nb_photo': 2725, 'list_port_cont': '28068026,28068211,28068311,28068321,28068570,28068622,28068754,28068812,28068974,28069015,28069048,28069298,28069350,28069408,28069444,28069490,28069579,28069806,28069903,28070119,28070497,28070621,28071136,28075927,28075968,28076154,28076184,28076221,28076336,28076447,28076718,28076844,28076949,28076980,28077111,28077295,28077365,28077447,28077484,28077543,28077587,28077707,28077776,28078330,28078404,28117821,28120501,28120549,28120868,28121765,28121902,28123119,28123940,28124724,28125255,28125788,28126358,28126961,28129060,28129422,28132689,28133799,28135168,28137363,28181891,28181977,28182008,28182041,28182158,28182194,28182333,28182371,28182585,28182848,28183002,28183136,28183306,28183685,28183951,28183988,28184167,28185354,28185624,28186104,28186302,28186828,28186898,28228341,28230941,28231853,28231922,28232032,28232337,28232797,28233135,28233502,28233722,28233781,28233979,28234643,28234657,28235121,28235314,28235612,28235675,28235889,28236199,28236335,28281911,28329676,28330077,28330096,28330173,2833025', 'assoc_port': '28067800:28069806,28067803:28070119,28067806:28069579,28067809:28069408,28067812:28069350,28067815:28069903,28067818:28069490,28067821:28069048,28067823:28069298,28067826:28069015,28067828:28068812,28067831:28068974,28067833:28071136,28067836:28068570,28067839:28068622,28067841:28068311,28067844:28068754,28067846:28070621,28067849:28068211,28067851:28068026,28067854:28068321,28069320:28069444,28070472:28070497,28075304:28076949,28075306:28077776,28075308:28077707,28075310:28076184,28075312:28076336,28075314:28078404,28075316:28076844,28075318:28076154,28075320:28076447,28075326:28075968,28075329:28076221,28075332:28078330,28075335:28077365,28075338:28075927,28075341:28077587,28075343:28077543,28075345:28077484,28075349:28077447,28075350:28077295,28075353:28077111,28076696:28076718,28076879:28076980,28111765:28117821,28119039:28129422,28119049:28126961,28119060:28124724,28119064:28126358,28119075:28129060,28119087:28123940,28119098:28123119,28119123:28137363,28119127:28132689,28119134:28121765,28119138:2812578', 'assoc_mat': '28067800:pehd:4230:28069806,28067803:pehd:4230:28070119,28067806:pehd:4230:28069579,28067809:pehd:4230:28069408,28067812:pehd:4230:28069350,28067815:pehd:4230:28069903,28067818:pehd:4230:28069490,28067821:pehd:4230:28069048,28067823:pehd:4230:28069298,28067826:pehd:4230:28069015,28067828:pehd:4230:28068812,28067831:pehd:4230:28068974,28067833:pehd:4230:28071136,28067836:pehd:4230:28068570,28067839:pehd:4230:28068622,28067841:pehd:4230:28068311,28067844:pehd:4230:28068754,28067846:pehd:4230:28070621,28067849:pehd:4230:28068211,28067851:pehd:4230:28068026,28067854:pehd:4230:28068321,28069320:pehd:4230:28069444,28070472:pehd:4230:28070497,28075304:pehd:4230:28076949,28075306:pehd:4230:28077776,28075308:pehd:4230:28077707,28075310:pehd:4230:28076184,28075312:pehd:4230:28076336,28075314:pehd:4230:28078404,28075316:pehd:4230:28076844,28075318:pehd:4230:28076154,28075320:pehd:4230:28076447,28075326:pehd:4230:28075968,28075329:pehd:4230:28076221,28075332:pehd:4230:28078330,28075335:pehd:4230:28077365,28075338:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011647047192514116, 'nb_photo': 23171, 'list_port_cont': '28068022,28068209,28068310,28068324,28068573,28068623,28068760,28068813,28068976,28069013,28069056,28069292,28069338,28069405,28069440,28069489,28069582,28069798,28069911,28070133,28070495,28070618,28071129,28075936,28075964,28076157,28076190,28076222,28076339,28076444,28076712,28076847,28076942,28076985,28077107,28077290,28077364,28077446,28077478,28077513,28077557,28077589,28077708,28077785,28077911,28078319,28078407,28117825,28120508,28120556,28120876,28121752,28121892,28122287,28123123,28123946,28124719,28125264,28125784,28126362,28126738,28126951,28128886,28129052,28129420,28130317,28132304,28132682,28133803,28135166,28137371,28181804,28181897,28181976,28182006,28182049,28182159,28182192,28182334,28182361,28182584,28182858,28183006,28183160,28183313,28183686,28183956,28183984,28184168,28185342,28185629,28186093,28186296,28186807,28186911,28228343,28230945,28231859,28231930,28232037,28232346,28232794,28233121,28233500,28233726,28233776,28233983,28234576,28234638,28234647,28235062,28235120,28235327,2823560', 'assoc_port': '28067800:28069798,28067803:28070133,28067806:28069582,28067809:28069405,28067812:28069338,28067815:28069911,28067818:28069489,28067821:28069056,28067823:28069292,28067826:28069013,28067828:28068813,28067831:28068976,28067833:28071129,28067836:28068573,28067839:28068623,28067841:28068310,28067844:28068760,28067846:28070618,28067849:28068209,28067851:28068022,28067854:28068324,28069320:28069440,28070472:28070495,28075304:28076942,28075306:28077785,28075308:28077708,28075310:28076190,28075312:28076339,28075314:28078407,28075316:28076847,28075318:28076157,28075320:28076444,28075323:28077513,28075326:28075964,28075329:28076222,28075332:28078319,28075335:28077364,28075338:28075936,28075341:28077589,28075343:28077557,28075345:28077478,28075347:28077911,28075349:28077446,28075350:28077290,28075353:28077107,28076696:28076712,28076879:28076985,28111765:28117825,28119039:28129420,28119043:28128886,28119046:28132304,28119049:28126951,28119052:28130317,28119056:28126738,28119060:28124719,28119064:28126362,28119075:2812905', 'assoc_mat': '28067800:pet_clair:4230:28069798,28067803:pet_clair:4230:28070133,28067806:pet_clair:4230:28069582,28067809:pet_clair:4230:28069405,28067812:pet_clair:4230:28069338,28067815:pet_clair:4230:28069911,28067818:pet_clair:4230:28069489,28067821:pet_clair:4230:28069056,28067823:pet_clair:4230:28069292,28067826:pet_clair:4230:28069013,28067828:pet_clair:4230:28068813,28067831:pet_clair:4230:28068976,28067833:pet_clair:4230:28071129,28067836:pet_clair:4230:28068573,28067839:pet_clair:4230:28068623,28067841:pet_clair:4230:28068310,28067844:pet_clair:4230:28068760,28067846:pet_clair:4230:28070618,28067849:pet_clair:4230:28068209,28067851:pet_clair:4230:28068022,28067854:pet_clair:4230:28068324,28069320:pet_clair:4230:28069440,28070472:pet_clair:4230:28070495,28075304:pet_clair:4230:28076942,28075306:pet_clair:4230:28077785,28075308:pet_clair:4230:28077708,28075310:pet_clair:4230:28076190,28075312:pet_clair:4230:28076339,28075314:pet_clair:4230:28078407,28075316:pet_clair:4230:28076847,28075318:pet_clair:4230:28076157,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002818190424007402, 'nb_photo': 1159, 'list_port_cont': '28068299,28068327,28068568,28068617,28068751,28068972,28069014,28069057,28069289,28069349,28069437,28069498,28069581,28069914,28070128,28070490,28071127,28075934,28076150,28076448,28076714,28076940,28076981,28077104,28077482,28077553,28077580,28077711,28077783,28117828,28120507,28120552,28120874,28121755,28121894,28123122,28123945,28124731,28125263,28125787,28126364,28126740,28129047,28132308,28132690,28135172,28181807,28181903,28181980,28182009,28182050,28182155,28182185,28182328,28182368,28182841,28182995,28183151,28183683,28183961,28183997,28185348,28185623,28186105,28186305,28186808,28186909,28228338,28230943,28231933,28232041,28232789,28233132,28233494,28233771,28233985,28234634,28234659,28235067,28235691,28235894,28236224,28236336,28281913,28329695,28330080,28330099,28330169,28330245,28330296,28330743,28333354,28333559,28333644,28333691,28333919,28334033,28334113,28334184,28334218,28334435,28335281,28335355,28335391,28335684,28335779,28335888,28335954,28336188,28336367,28336458,28336544,28336595,2833677', 'assoc_port': '28067803:28070128,28067806:28069581,28067812:28069349,28067815:28069914,28067818:28069498,28067821:28069057,28067823:28069289,28067826:28069014,28067831:28068972,28067833:28071127,28067836:28068568,28067839:28068617,28067841:28068299,28067844:28068751,28067854:28068327,28069320:28069437,28070472:28070490,28075304:28076940,28075306:28077783,28075308:28077711,28075318:28076150,28075320:28076448,28075338:28075934,28075341:28077580,28075343:28077553,28075345:28077482,28075353:28077104,28076696:28076714,28076879:28076981,28111765:28117828,28119046:28132308,28119056:28126740,28119060:28124731,28119064:28126364,28119075:28129047,28119087:28123945,28119098:28123122,28119127:28132690,28119134:28121755,28119138:28125787,28119141:28135172,28119145:28125263,28119149:28120874,28119152:28120507,28119156:28120552,28121302:28121894,28181654:28183683,28181658:28183997,28181660:28186909,28181664:28186808,28181669:28185348,28181672:28182995,28181674:28186305,28181677:28183151,28181683:28182841,28181685:28182185,28181688:2818215', 'assoc_mat': '28067803:pet_fonce:4230:28070128,28067806:pet_fonce:4230:28069581,28067812:pet_fonce:4230:28069349,28067815:pet_fonce:4230:28069914,28067818:pet_fonce:4230:28069498,28067821:pet_fonce:4230:28069057,28067823:pet_fonce:4230:28069289,28067826:pet_fonce:4230:28069014,28067831:pet_fonce:4230:28068972,28067833:pet_fonce:4230:28071127,28067836:pet_fonce:4230:28068568,28067839:pet_fonce:4230:28068617,28067841:pet_fonce:4230:28068299,28067844:pet_fonce:4230:28068751,28067854:pet_fonce:4230:28068327,28069320:pet_fonce:4230:28069437,28070472:pet_fonce:4230:28070490,28075304:pet_fonce:4230:28076940,28075306:pet_fonce:4230:28077783,28075308:pet_fonce:4230:28077711,28075318:pet_fonce:4230:28076150,28075320:pet_fonce:4230:28076448,28075338:pet_fonce:4230:28075934,28075341:pet_fonce:4230:28077580,28075343:pet_fonce:4230:28077553,28075345:pet_fonce:4230:28077482,28075353:pet_fonce:4230:28077104,28076696:pet_fonce:4230:28076714,28076879:pet_fonce:4230:28076981,28111765:pet_fonce:4230:28117828,28119046:pet_fonce:4230:28132308,2'}), 'main_stat': {'nb_photos': 1910}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-11', 0.728973903504821),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1910,),), 'unwanted_material_monthly_percentage': ((0.728973903504821,),), 'material_repartition': (('incineration', 1910),), 'material_dict': {'incineration': 1910}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 11, 1), 0.6564524420344995, 3), (datetime.date(2025, 11, 2), 0.7156049324861564, 3), (datetime.date(2025, 11, 3), 0.6947740313264259, 2), (datetime.date(2025, 11, 4), 0.6993368893370877, 4), (datetime.date(2025, 11, 5), 0.6565217301880245, 1), (datetime.date(2025, 11, 6), 0.658770337918953, 2), (datetime.date(2025, 11, 7), 0.6540707059959381, 1), (datetime.date(2025, 11, 8), 0.6910025838594922, 2), (datetime.date(2025, 11, 9), 0.78368359808601, 3), (datetime.date(2025, 11, 10), 0.7627996958514611, 2), (datetime.date(2025, 11, 11), 0.7961831698730412, 1), (datetime.date(2025, 11, 12), 0.776321299394225, 3), (datetime.date(2025, 11, 13), 0.7326797174057935, 4), (datetime.date(2025, 11, 14), 0.7018117358757917, 1), (datetime.date(2025, 11, 15), 0.7035483942547348, 3), (datetime.date(2025, 11, 16), 0.7395917711134115, 3), (datetime.date(2025, 11, 17), 0.7412149319972998, 3), (datetime.date(2025, 11, 18), 0.7942603261996996, 2), (datetime.date(2025, 11, 19), 0.6911191450986566, 3), (datetime.date(2025, 11, 20), 0.6885007438142253, 4), (datetime.date(2025, 11, 21), 0.712657298767642, 2), (datetime.date(2025, 11, 22), 0.7034528929192293, 2), (datetime.date(2025, 11, 23), 0.7680715695137208, 2), (datetime.date(2025, 11, 24), 0.7901121768516461, 4), (datetime.date(2025, 11, 25), 0.7682510400822112, 4), (datetime.date(2025, 11, 26), 0.7546659521081922, 3), (datetime.date(2025, 11, 27), 0.7199490702617038, 2), (datetime.date(2025, 11, 28), 0.7057157408047884, 3), (datetime.date(2025, 11, 29), 0.7571424470367693, 4), (datetime.date(2025, 11, 30), 0.7932955809920411, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 11, 1), 0.6564524420344995, 3), (datetime.date(2025, 11, 2), 0.7156049324861564, 3), (datetime.date(2025, 11, 3), 0.6947740313264259, 2), (datetime.date(2025, 11, 4), 0.6993368893370877, 4), (datetime.date(2025, 11, 5), 0.6565217301880245, 1), (datetime.date(2025, 11, 6), 0.658770337918953, 2), (datetime.date(2025, 11, 7), 0.6540707059959381, 1), (datetime.date(2025, 11, 8), 0.6910025838594922, 2), (datetime.date(2025, 11, 9), 0.78368359808601, 3), (datetime.date(2025, 11, 10), 0.7627996958514611, 2), (datetime.date(2025, 11, 11), 0.7961831698730412, 1), (datetime.date(2025, 11, 12), 0.776321299394225, 3), (datetime.date(2025, 11, 13), 0.7326797174057935, 4), (datetime.date(2025, 11, 14), 0.7018117358757917, 1), (datetime.date(2025, 11, 15), 0.7035483942547348, 3), (datetime.date(2025, 11, 16), 0.7395917711134115, 3), (datetime.date(2025, 11, 17), 0.7412149319972998, 3), (datetime.date(2025, 11, 18), 0.7942603261996996, 2), (datetime.date(2025, 11, 19), 0.6911191450986566, 3), (datetime.date(2025, 11, 20), 0.6885007438142253, 4), (datetime.date(2025, 11, 21), 0.712657298767642, 2), (datetime.date(2025, 11, 22), 0.7034528929192293, 2), (datetime.date(2025, 11, 23), 0.7680715695137208, 2), (datetime.date(2025, 11, 24), 0.7901121768516461, 4), (datetime.date(2025, 11, 25), 0.7682510400822112, 4), (datetime.date(2025, 11, 26), 0.7546659521081922, 3), (datetime.date(2025, 11, 27), 0.7199490702617038, 2), (datetime.date(2025, 11, 28), 0.7057157408047884, 3), (datetime.date(2025, 11, 29), 0.7571424470367693, 4), (datetime.date(2025, 11, 30), 0.7932955809920411, 4))}, 'quality_array': [['-8.781602104052944', '01112025'], ['-8.586002917510337', '02112025'], ['-8.200843828447844', '03112025'], ['-8.301607024791764', '04112025'], ['-8.522643661534179', '05112025'], ['-8.56845692630202', '06112025'], ['-8.688056664283891', '07112025'], ['-8.600528842204135', '08112025'], ['-8.33453526141277', '09112025'], ['-8.026377679142618', '10112025'], ['-8.051650675475212', '11112025'], ['-7.516393624959675', '12112025'], ['-8.037185436525819', '13112025'], ['-8.18280954987854', '14112025'], ['-8.308178391550284', '15112025'], ['-8.121477798624978', '16112025'], ['-7.831282532602963', '17112025'], ['-7.893644509419767', '18112025'], ['-8.014555893644754', '19112025'], ['-8.44227092361186', '20112025'], ['-8.18294491522899', '21112025'], ['-8.244606085613253', '22112025'], ['-8.116508402346204', '23112025'], ['-7.526875706300245', '24112025'], ['-7.634304322900802', '25112025'], ['-8.064355152039035', '26112025'], ['-8.32237084063219', '27112025'], ['-8.364917803388439', '28112025'], ['-8.28458942878454', '29112025'], ['-7.97504834408964', '30112025']], 'number_of_batch': ((689,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01508372437039924, 'nb_photo': 19992, 'list_port_cont': '28068025,28068208,28068304,28068313,28068558,28068607,28068761,28068808,28068966,28068998,28069044,28069285,28069348,28069403,28069438,28069496,28069588,28069789,28069904,28070131,28070499,28070620,28071135,28075925,28075957,28076151,28076191,28076219,28076326,28076446,28076713,28076837,28076948,28076973,28077094,28077293,28077355,28077436,28077483,28077512,28077556,28077593,28077696,28077778,28077894,28078326,28078405,28117830,28120510,28120553,28120877,28121758,28121891,28122288,28123111,28123936,28124726,28125259,28125789,28126349,28126730,28126967,28128881,28129063,28129418,28130308,28132298,28132694,28133790,28135162,28137364,28181796,28181893,28181967,28182004,28182039,28182150,28182188,28182326,28182369,28182572,28182847,28183007,28183141,28183315,28183676,28183955,28183993,28184160,28185343,28185625,28186101,28186309,28186832,28186905,28228330,28230937,28231857,28231916,28232034,28232342,28232782,28233123,28233483,28233715,28233779,28233982,28234572,28234641,28234661,28235056,28235122,28235316,2823562', 'assoc_port': '28067800:28069789,28067803:28070131,28067806:28069588,28067809:28069403,28067812:28069348,28067815:28069904,28067818:28069496,28067821:28069044,28067823:28069285,28067826:28068998,28067828:28068808,28067831:28068966,28067833:28071135,28067836:28068558,28067839:28068607,28067841:28068304,28067844:28068761,28067846:28070620,28067849:28068208,28067851:28068025,28067854:28068313,28069320:28069438,28070472:28070499,28075304:28076948,28075306:28077778,28075308:28077696,28075310:28076191,28075312:28076326,28075314:28078405,28075316:28076837,28075318:28076151,28075320:28076446,28075323:28077512,28075326:28075957,28075329:28076219,28075332:28078326,28075335:28077355,28075338:28075925,28075341:28077593,28075343:28077556,28075345:28077483,28075347:28077894,28075349:28077436,28075350:28077293,28075353:28077094,28076696:28076713,28076879:28076973,28111765:28117830,28119039:28129418,28119043:28128881,28119046:28132298,28119049:28126967,28119052:28130308,28119056:28126730,28119060:28124726,28119064:28126349,28119075:2812906', 'assoc_mat': '28067800:autre:4230:28069789,28067803:autre:4230:28070131,28067806:autre:4230:28069588,28067809:autre:4230:28069403,28067812:autre:4230:28069348,28067815:autre:4230:28069904,28067818:autre:4230:28069496,28067821:autre:4230:28069044,28067823:autre:4230:28069285,28067826:autre:4230:28068998,28067828:autre:4230:28068808,28067831:autre:4230:28068966,28067833:autre:4230:28071135,28067836:autre:4230:28068558,28067839:autre:4230:28068607,28067841:autre:4230:28068304,28067844:autre:4230:28068761,28067846:autre:4230:28070620,28067849:autre:4230:28068208,28067851:autre:4230:28068025,28067854:autre:4230:28068313,28069320:autre:4230:28069438,28070472:autre:4230:28070499,28075304:autre:4230:28076948,28075306:autre:4230:28077778,28075308:autre:4230:28077696,28075310:autre:4230:28076191,28075312:autre:4230:28076326,28075314:autre:4230:28078405,28075316:autre:4230:28076837,28075318:autre:4230:28076151,28075320:autre:4230:28076446,28075323:autre:4230:28077512,28075326:autre:4230:28075957,28075329:autre:4230:28076219,28075332:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.051600019292880155, 'nb_photo': 97231, 'list_port_cont': '28068021,28068204,28068306,28068329,28068566,28068613,28068764,28068815,28068969,28069004,28069045,28069297,28069343,28069402,28069441,28069494,28069583,28069797,28069908,28070132,28070498,28070625,28071130,28075933,28075969,28076148,28076188,28076227,28076328,28076434,28076711,28076851,28076947,28076978,28077108,28077292,28077360,28077445,28077480,28077517,28077547,28077592,28077703,28077781,28077900,28078331,28078402,28117823,28120505,28120547,28120867,28121766,28121900,28122291,28123121,28123951,28124715,28125258,28125785,28126363,28126739,28126964,28128885,28129055,28129419,28130318,28132295,28132696,28133804,28135161,28137372,28181803,28181894,28181972,28182013,28182053,28182156,28182197,28182323,28182357,28182579,28182850,28182998,28183156,28183317,28183673,28183953,28183998,28184172,28185353,28185622,28186096,28186304,28186826,28186904,28228346,28230944,28231849,28231934,28232038,28232345,28232798,28233131,28233498,28233724,28233787,28233978,28234580,28234635,28234653,28235053,28235129,28235320,2823560', 'assoc_port': '28067800:28069797,28067803:28070132,28067806:28069583,28067809:28069402,28067812:28069343,28067815:28069908,28067818:28069494,28067821:28069045,28067823:28069297,28067826:28069004,28067828:28068815,28067831:28068969,28067833:28071130,28067836:28068566,28067839:28068613,28067841:28068306,28067844:28068764,28067846:28070625,28067849:28068204,28067851:28068021,28067854:28068329,28069320:28069441,28070472:28070498,28075304:28076947,28075306:28077781,28075308:28077703,28075310:28076188,28075312:28076328,28075314:28078402,28075316:28076851,28075318:28076148,28075320:28076434,28075323:28077517,28075326:28075969,28075329:28076227,28075332:28078331,28075335:28077360,28075338:28075933,28075341:28077592,28075343:28077547,28075345:28077480,28075347:28077900,28075349:28077445,28075350:28077292,28075353:28077108,28076696:28076711,28076879:28076978,28111765:28117823,28119039:28129419,28119043:28128885,28119046:28132295,28119049:28126964,28119052:28130318,28119056:28126739,28119060:28124715,28119064:28126363,28119075:2812905', 'assoc_mat': '28067800:carton:4230:28069797,28067803:carton:4230:28070132,28067806:carton:4230:28069583,28067809:carton:4230:28069402,28067812:carton:4230:28069343,28067815:carton:4230:28069908,28067818:carton:4230:28069494,28067821:carton:4230:28069045,28067823:carton:4230:28069297,28067826:carton:4230:28069004,28067828:carton:4230:28068815,28067831:carton:4230:28068969,28067833:carton:4230:28071130,28067836:carton:4230:28068566,28067839:carton:4230:28068613,28067841:carton:4230:28068306,28067844:carton:4230:28068764,28067846:carton:4230:28070625,28067849:carton:4230:28068204,28067851:carton:4230:28068021,28067854:carton:4230:28068329,28069320:carton:4230:28069441,28070472:carton:4230:28070498,28075304:carton:4230:28076947,28075306:carton:4230:28077781,28075308:carton:4230:28077703,28075310:carton:4230:28076188,28075312:carton:4230:28076328,28075314:carton:4230:28078402,28075316:carton:4230:28076851,28075318:carton:4230:28076148,28075320:carton:4230:28076434,28075323:carton:4230:28077517,28075326:carton:4230:28075969,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0012550936076088759, 'nb_photo': 1618, 'list_port_cont': '28068017,28068212,28068328,28068565,28068608,28068801,28068973,28069001,28069051,28069287,28069346,28069391,28069434,28069488,28069577,28069799,28069906,28070120,28070501,28070616,28071120,28075921,28075960,28076146,28076194,28076248,28076338,28076439,28076715,28076845,28076945,28076983,28077097,28077440,28077472,28077507,28077591,28077700,28077784,28077903,28078327,28078392,28117818,28120506,28120554,28120878,28121886,28122289,28123106,28123944,28124728,28125260,28125769,28126353,28126727,28126957,28129057,28129413,28132312,28132684,28133806,28135173,28137362,28181978,28182017,28182046,28182146,28182200,28182325,28182365,28182586,28182856,28182997,28183163,28183301,28183682,28183948,28183989,28184171,28186102,28186820,28186907,28228329,28230935,28231856,28231918,28232039,28232338,28232785,28233122,28233481,28233713,28233785,28233976,28234644,28234662,28235123,28235599,28236205,28236330,28281903,28329682,28330067,28330093,28330168,28330298,28330736,28333351,28333565,28333693,28333917,28334027,28334125,2833418', 'assoc_port': '28067800:28069799,28067803:28070120,28067806:28069577,28067809:28069391,28067812:28069346,28067815:28069906,28067818:28069488,28067821:28069051,28067823:28069287,28067826:28069001,28067828:28068801,28067831:28068973,28067833:28071120,28067836:28068565,28067839:28068608,28067846:28070616,28067849:28068212,28067851:28068017,28067854:28068328,28069320:28069434,28070472:28070501,28075304:28076945,28075306:28077784,28075308:28077700,28075310:28076194,28075312:28076338,28075314:28078392,28075316:28076845,28075318:28076146,28075320:28076439,28075323:28077507,28075326:28075960,28075329:28076248,28075332:28078327,28075338:28075921,28075341:28077591,28075345:28077472,28075347:28077903,28075349:28077440,28075353:28077097,28076696:28076715,28076879:28076983,28111765:28117818,28119039:28129413,28119046:28132312,28119049:28126957,28119056:28126727,28119060:28124728,28119064:28126353,28119075:28129057,28119087:28123944,28119098:28123106,28119123:28137362,28119127:28132684,28119131:28122289,28119138:28125769,28119141:2813517', 'assoc_mat': '28067800:metal:4230:28069799,28067803:metal:4230:28070120,28067806:metal:4230:28069577,28067809:metal:4230:28069391,28067812:metal:4230:28069346,28067815:metal:4230:28069906,28067818:metal:4230:28069488,28067821:metal:4230:28069051,28067823:metal:4230:28069287,28067826:metal:4230:28069001,28067828:metal:4230:28068801,28067831:metal:4230:28068973,28067833:metal:4230:28071120,28067836:metal:4230:28068565,28067839:metal:4230:28068608,28067846:metal:4230:28070616,28067849:metal:4230:28068212,28067851:metal:4230:28068017,28067854:metal:4230:28068328,28069320:metal:4230:28069434,28070472:metal:4230:28070501,28075304:metal:4230:28076945,28075306:metal:4230:28077784,28075308:metal:4230:28077700,28075310:metal:4230:28076194,28075312:metal:4230:28076338,28075314:metal:4230:28078392,28075316:metal:4230:28076845,28075318:metal:4230:28076146,28075320:metal:4230:28076439,28075323:metal:4230:28077507,28075326:metal:4230:28075960,28075329:metal:4230:28076248,28075332:metal:4230:28078327,28075338:metal:4230:28075921,28075341:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2057401794615194, 'nb_photo': 456638, 'list_port_cont': '28068024,28068213,28068308,28068323,28068567,28068619,28068755,28068807,28068975,28069008,28069052,28069286,28069342,28069406,28069442,28069492,28069578,28069803,28069909,28070130,28070496,28070614,28071134,28075935,28075970,28076155,28076186,28076242,28076334,28076440,28076706,28076849,28076938,28076972,28077110,28077296,28077367,28077435,28077477,28077519,28077554,28077590,28077695,28077779,28077907,28078321,28078406,28117831,28120498,28120555,28120875,28121767,28121899,28122284,28123120,28123941,28124718,28125261,28125783,28126360,28126743,28126965,28128884,28129061,28129414,28130313,28132313,28132692,28133795,28135170,28137352,28181808,28181900,28181973,28182016,28182047,28182157,28182186,28182332,28182366,28182582,28182857,28183004,28183164,28183307,28183679,28183959,28183994,28184157,28185347,28185630,28186100,28186308,28186816,28186910,28228340,28230946,28231858,28231928,28232040,28232350,28232793,28233134,28233506,28233720,28233784,28233972,28234578,28234642,28234660,28235063,28235127,28235322,2823560', 'assoc_port': '28067800:28069803,28067803:28070130,28067806:28069578,28067809:28069406,28067812:28069342,28067815:28069909,28067818:28069492,28067821:28069052,28067823:28069286,28067826:28069008,28067828:28068807,28067831:28068975,28067833:28071134,28067836:28068567,28067839:28068619,28067841:28068308,28067844:28068755,28067846:28070614,28067849:28068213,28067851:28068024,28067854:28068323,28069320:28069442,28070472:28070496,28075304:28076938,28075306:28077779,28075308:28077695,28075310:28076186,28075312:28076334,28075314:28078406,28075316:28076849,28075318:28076155,28075320:28076440,28075323:28077519,28075326:28075970,28075329:28076242,28075332:28078321,28075335:28077367,28075338:28075935,28075341:28077590,28075343:28077554,28075345:28077477,28075347:28077907,28075349:28077435,28075350:28077296,28075353:28077110,28076696:28076706,28076879:28076972,28111765:28117831,28119039:28129414,28119043:28128884,28119046:28132313,28119049:28126965,28119052:28130313,28119056:28126743,28119060:28124718,28119064:28126360,28119075:2812906', 'assoc_mat': '28067800:papier:4230:28069803,28067803:papier:4230:28070130,28067806:papier:4230:28069578,28067809:papier:4230:28069406,28067812:papier:4230:28069342,28067815:papier:4230:28069909,28067818:papier:4230:28069492,28067821:papier:4230:28069052,28067823:papier:4230:28069286,28067826:papier:4230:28069008,28067828:papier:4230:28068807,28067831:papier:4230:28068975,28067833:papier:4230:28071134,28067836:papier:4230:28068567,28067839:papier:4230:28068619,28067841:papier:4230:28068308,28067844:papier:4230:28068755,28067846:papier:4230:28070614,28067849:papier:4230:28068213,28067851:papier:4230:28068024,28067854:papier:4230:28068323,28069320:papier:4230:28069442,28070472:papier:4230:28070496,28075304:papier:4230:28076938,28075306:papier:4230:28077779,28075308:papier:4230:28077695,28075310:papier:4230:28076186,28075312:papier:4230:28076334,28075314:papier:4230:28078406,28075316:papier:4230:28076849,28075318:papier:4230:28076155,28075320:papier:4230:28076440,28075323:papier:4230:28077519,28075326:papier:4230:28075970,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003836693774034915, 'nb_photo': 2725, 'list_port_cont': '28068026,28068211,28068311,28068321,28068570,28068622,28068754,28068812,28068974,28069015,28069048,28069298,28069350,28069408,28069444,28069490,28069579,28069806,28069903,28070119,28070497,28070621,28071136,28075927,28075968,28076154,28076184,28076221,28076336,28076447,28076718,28076844,28076949,28076980,28077111,28077295,28077365,28077447,28077484,28077543,28077587,28077707,28077776,28078330,28078404,28117821,28120501,28120549,28120868,28121765,28121902,28123119,28123940,28124724,28125255,28125788,28126358,28126961,28129060,28129422,28132689,28133799,28135168,28137363,28181891,28181977,28182008,28182041,28182158,28182194,28182333,28182371,28182585,28182848,28183002,28183136,28183306,28183685,28183951,28183988,28184167,28185354,28185624,28186104,28186302,28186828,28186898,28228341,28230941,28231853,28231922,28232032,28232337,28232797,28233135,28233502,28233722,28233781,28233979,28234643,28234657,28235121,28235314,28235612,28235675,28235889,28236199,28236335,28281911,28329676,28330077,28330096,28330173,2833025', 'assoc_port': '28067800:28069806,28067803:28070119,28067806:28069579,28067809:28069408,28067812:28069350,28067815:28069903,28067818:28069490,28067821:28069048,28067823:28069298,28067826:28069015,28067828:28068812,28067831:28068974,28067833:28071136,28067836:28068570,28067839:28068622,28067841:28068311,28067844:28068754,28067846:28070621,28067849:28068211,28067851:28068026,28067854:28068321,28069320:28069444,28070472:28070497,28075304:28076949,28075306:28077776,28075308:28077707,28075310:28076184,28075312:28076336,28075314:28078404,28075316:28076844,28075318:28076154,28075320:28076447,28075326:28075968,28075329:28076221,28075332:28078330,28075335:28077365,28075338:28075927,28075341:28077587,28075343:28077543,28075345:28077484,28075349:28077447,28075350:28077295,28075353:28077111,28076696:28076718,28076879:28076980,28111765:28117821,28119039:28129422,28119049:28126961,28119060:28124724,28119064:28126358,28119075:28129060,28119087:28123940,28119098:28123119,28119123:28137363,28119127:28132689,28119134:28121765,28119138:2812578', 'assoc_mat': '28067800:pehd:4230:28069806,28067803:pehd:4230:28070119,28067806:pehd:4230:28069579,28067809:pehd:4230:28069408,28067812:pehd:4230:28069350,28067815:pehd:4230:28069903,28067818:pehd:4230:28069490,28067821:pehd:4230:28069048,28067823:pehd:4230:28069298,28067826:pehd:4230:28069015,28067828:pehd:4230:28068812,28067831:pehd:4230:28068974,28067833:pehd:4230:28071136,28067836:pehd:4230:28068570,28067839:pehd:4230:28068622,28067841:pehd:4230:28068311,28067844:pehd:4230:28068754,28067846:pehd:4230:28070621,28067849:pehd:4230:28068211,28067851:pehd:4230:28068026,28067854:pehd:4230:28068321,28069320:pehd:4230:28069444,28070472:pehd:4230:28070497,28075304:pehd:4230:28076949,28075306:pehd:4230:28077776,28075308:pehd:4230:28077707,28075310:pehd:4230:28076184,28075312:pehd:4230:28076336,28075314:pehd:4230:28078404,28075316:pehd:4230:28076844,28075318:pehd:4230:28076154,28075320:pehd:4230:28076447,28075326:pehd:4230:28075968,28075329:pehd:4230:28076221,28075332:pehd:4230:28078330,28075335:pehd:4230:28077365,28075338:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011647047192514116, 'nb_photo': 23171, 'list_port_cont': '28068022,28068209,28068310,28068324,28068573,28068623,28068760,28068813,28068976,28069013,28069056,28069292,28069338,28069405,28069440,28069489,28069582,28069798,28069911,28070133,28070495,28070618,28071129,28075936,28075964,28076157,28076190,28076222,28076339,28076444,28076712,28076847,28076942,28076985,28077107,28077290,28077364,28077446,28077478,28077513,28077557,28077589,28077708,28077785,28077911,28078319,28078407,28117825,28120508,28120556,28120876,28121752,28121892,28122287,28123123,28123946,28124719,28125264,28125784,28126362,28126738,28126951,28128886,28129052,28129420,28130317,28132304,28132682,28133803,28135166,28137371,28181804,28181897,28181976,28182006,28182049,28182159,28182192,28182334,28182361,28182584,28182858,28183006,28183160,28183313,28183686,28183956,28183984,28184168,28185342,28185629,28186093,28186296,28186807,28186911,28228343,28230945,28231859,28231930,28232037,28232346,28232794,28233121,28233500,28233726,28233776,28233983,28234576,28234638,28234647,28235062,28235120,28235327,2823560', 'assoc_port': '28067800:28069798,28067803:28070133,28067806:28069582,28067809:28069405,28067812:28069338,28067815:28069911,28067818:28069489,28067821:28069056,28067823:28069292,28067826:28069013,28067828:28068813,28067831:28068976,28067833:28071129,28067836:28068573,28067839:28068623,28067841:28068310,28067844:28068760,28067846:28070618,28067849:28068209,28067851:28068022,28067854:28068324,28069320:28069440,28070472:28070495,28075304:28076942,28075306:28077785,28075308:28077708,28075310:28076190,28075312:28076339,28075314:28078407,28075316:28076847,28075318:28076157,28075320:28076444,28075323:28077513,28075326:28075964,28075329:28076222,28075332:28078319,28075335:28077364,28075338:28075936,28075341:28077589,28075343:28077557,28075345:28077478,28075347:28077911,28075349:28077446,28075350:28077290,28075353:28077107,28076696:28076712,28076879:28076985,28111765:28117825,28119039:28129420,28119043:28128886,28119046:28132304,28119049:28126951,28119052:28130317,28119056:28126738,28119060:28124719,28119064:28126362,28119075:2812905', 'assoc_mat': '28067800:pet_clair:4230:28069798,28067803:pet_clair:4230:28070133,28067806:pet_clair:4230:28069582,28067809:pet_clair:4230:28069405,28067812:pet_clair:4230:28069338,28067815:pet_clair:4230:28069911,28067818:pet_clair:4230:28069489,28067821:pet_clair:4230:28069056,28067823:pet_clair:4230:28069292,28067826:pet_clair:4230:28069013,28067828:pet_clair:4230:28068813,28067831:pet_clair:4230:28068976,28067833:pet_clair:4230:28071129,28067836:pet_clair:4230:28068573,28067839:pet_clair:4230:28068623,28067841:pet_clair:4230:28068310,28067844:pet_clair:4230:28068760,28067846:pet_clair:4230:28070618,28067849:pet_clair:4230:28068209,28067851:pet_clair:4230:28068022,28067854:pet_clair:4230:28068324,28069320:pet_clair:4230:28069440,28070472:pet_clair:4230:28070495,28075304:pet_clair:4230:28076942,28075306:pet_clair:4230:28077785,28075308:pet_clair:4230:28077708,28075310:pet_clair:4230:28076190,28075312:pet_clair:4230:28076339,28075314:pet_clair:4230:28078407,28075316:pet_clair:4230:28076847,28075318:pet_clair:4230:28076157,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002818190424007402, 'nb_photo': 1159, 'list_port_cont': '28068299,28068327,28068568,28068617,28068751,28068972,28069014,28069057,28069289,28069349,28069437,28069498,28069581,28069914,28070128,28070490,28071127,28075934,28076150,28076448,28076714,28076940,28076981,28077104,28077482,28077553,28077580,28077711,28077783,28117828,28120507,28120552,28120874,28121755,28121894,28123122,28123945,28124731,28125263,28125787,28126364,28126740,28129047,28132308,28132690,28135172,28181807,28181903,28181980,28182009,28182050,28182155,28182185,28182328,28182368,28182841,28182995,28183151,28183683,28183961,28183997,28185348,28185623,28186105,28186305,28186808,28186909,28228338,28230943,28231933,28232041,28232789,28233132,28233494,28233771,28233985,28234634,28234659,28235067,28235691,28235894,28236224,28236336,28281913,28329695,28330080,28330099,28330169,28330245,28330296,28330743,28333354,28333559,28333644,28333691,28333919,28334033,28334113,28334184,28334218,28334435,28335281,28335355,28335391,28335684,28335779,28335888,28335954,28336188,28336367,28336458,28336544,28336595,2833677', 'assoc_port': '28067803:28070128,28067806:28069581,28067812:28069349,28067815:28069914,28067818:28069498,28067821:28069057,28067823:28069289,28067826:28069014,28067831:28068972,28067833:28071127,28067836:28068568,28067839:28068617,28067841:28068299,28067844:28068751,28067854:28068327,28069320:28069437,28070472:28070490,28075304:28076940,28075306:28077783,28075308:28077711,28075318:28076150,28075320:28076448,28075338:28075934,28075341:28077580,28075343:28077553,28075345:28077482,28075353:28077104,28076696:28076714,28076879:28076981,28111765:28117828,28119046:28132308,28119056:28126740,28119060:28124731,28119064:28126364,28119075:28129047,28119087:28123945,28119098:28123122,28119127:28132690,28119134:28121755,28119138:28125787,28119141:28135172,28119145:28125263,28119149:28120874,28119152:28120507,28119156:28120552,28121302:28121894,28181654:28183683,28181658:28183997,28181660:28186909,28181664:28186808,28181669:28185348,28181672:28182995,28181674:28186305,28181677:28183151,28181683:28182841,28181685:28182185,28181688:2818215', 'assoc_mat': '28067803:pet_fonce:4230:28070128,28067806:pet_fonce:4230:28069581,28067812:pet_fonce:4230:28069349,28067815:pet_fonce:4230:28069914,28067818:pet_fonce:4230:28069498,28067821:pet_fonce:4230:28069057,28067823:pet_fonce:4230:28069289,28067826:pet_fonce:4230:28069014,28067831:pet_fonce:4230:28068972,28067833:pet_fonce:4230:28071127,28067836:pet_fonce:4230:28068568,28067839:pet_fonce:4230:28068617,28067841:pet_fonce:4230:28068299,28067844:pet_fonce:4230:28068751,28067854:pet_fonce:4230:28068327,28069320:pet_fonce:4230:28069437,28070472:pet_fonce:4230:28070490,28075304:pet_fonce:4230:28076940,28075306:pet_fonce:4230:28077783,28075308:pet_fonce:4230:28077711,28075318:pet_fonce:4230:28076150,28075320:pet_fonce:4230:28076448,28075338:pet_fonce:4230:28075934,28075341:pet_fonce:4230:28077580,28075343:pet_fonce:4230:28077553,28075345:pet_fonce:4230:28077482,28075353:pet_fonce:4230:28077104,28076696:pet_fonce:4230:28076714,28076879:pet_fonce:4230:28076981,28111765:pet_fonce:4230:28117828,28119046:pet_fonce:4230:28132308,2'}), 'main_stat': {'nb_photos': 1910}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-11', 0.728973903504821),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_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.51%', 19992], 'carton': ['carton', '5.16%', 97231], 'metal': ['metal', '0.13%', 1618], 'papier': ['papier', '20.57%', 456638], 'pehd': ['pehd', '0.38%', 2725], 'pet_clair': ['pet_clair', '1.16%', 23171], 'pet_fonce': ['pet_fonce', '0.28%', 1159]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_11_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.42user 2.87system 0:13.98elapsed 37%CPU (0avgtext+0avgdata 182180maxresident)k 94048inputs+312outputs (438major+47784minor)pagefaults 0swaps