python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 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_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 11 mtr_id : dashboard_places : SCCU_cam8 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_cam8' 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 = 203 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 = 203 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 = 203 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_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "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 (2501835,2503327,2510381,2519615,2528255,2537429,2545382,2553364,2556007,2563745,2571262,2578140,2584770,2592277,2598229,2598793,2605107,2613598,2621074,2630916,2634689,2638880,2639432) 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.02125814846063444, 'nb_photo': 19245, 'list_port_cont': '28067557,28067987,28068076,28068110,28068162,28068251,28068361,28068425,28068466,28068519,28068652,28068696,28068839,28068877,28069081,28069116,28069176,28069208,28069241,28069465,28069685,28070204,28070570,28070747,28075244,28075411,28075455,28075526,28075567,28075591,28075643,28075681,28075740,28075785,28075814,28075995,28076077,28076108,28076782,28077016,28077064,28077134,28077187,28077217,28077224,28077324,28077393,28078202,28120254,28120424,28120956,28120988,28122143,28122350,28122555,28123273,28123649,28123994,28124410,28124484,28124557,28124793,28125059,28125226,28126480,28127156,28127516,28128918,28131851,28134472,28135802,28138533,28180330,28182260,28182667,28182698,28182900,28183080,28183196,28183262,28183491,28183575,28183727,28183843,28183907,28184092,28184206,28184329,28184382,28184414,28184473,28184559,28185789,28186423,28186532,28187015,28230410,28230464,28230645,28230725,28230774,28231089,28231438,28231513,28231622,28231740,28232294,28232385,28232588,28232961,28233394,28233584,28234019,2823416', 'assoc_port': '28067357:28067557,28067802:28069685,28067805:28069465,28067808:28069241,28067811:28069208,28067814:28069176,28067816:28069116,28067819:28069081,28067822:28070747,28067825:28068877,28067827:28068839,28067830:28068696,28067832:28068652,28067835:28068466,28067838:28068425,28067840:28068519,28067843:28068361,28067845:28068251,28067848:28068162,28067850:28068110,28067853:28068076,28067855:28067987,28069319:28070204,28070473:28070570,28075152:28075244,28075322:28075995,28075325:28077393,28075328:28077324,28075331:28076108,28075334:28076077,28075337:28077224,28075340:28077187,28075342:28077134,28075344:28075740,28075346:28075681,28075348:28075814,28075351:28075785,28075352:28075526,28075354:28077064,28075355:28075567,28075356:28077217,28075357:28075643,28075358:28075411,28075359:28075455,28075360:28078202,28075361:28075591,28076697:28076782,28076881:28077016,28119040:28125226,28119042:28127156,28119045:28125059,28119048:28128918,28119051:28123649,28119054:28123273,28119058:28134472,28119062:28127516,28119065:2812255', 'assoc_mat': '28067357:autre:4230:28067557,28067802:autre:4230:28069685,28067805:autre:4230:28069465,28067808:autre:4230:28069241,28067811:autre:4230:28069208,28067814:autre:4230:28069176,28067816:autre:4230:28069116,28067819:autre:4230:28069081,28067822:autre:4230:28070747,28067825:autre:4230:28068877,28067827:autre:4230:28068839,28067830:autre:4230:28068696,28067832:autre:4230:28068652,28067835:autre:4230:28068466,28067838:autre:4230:28068425,28067840:autre:4230:28068519,28067843:autre:4230:28068361,28067845:autre:4230:28068251,28067848:autre:4230:28068162,28067850:autre:4230:28068110,28067853:autre:4230:28068076,28067855:autre:4230:28067987,28069319:autre:4230:28070204,28070473:autre:4230:28070570,28075152:autre:4230:28075244,28075322:autre:4230:28075995,28075325:autre:4230:28077393,28075328:autre:4230:28077324,28075331:autre:4230:28076108,28075334:autre:4230:28076077,28075337:autre:4230:28077224,28075340:autre:4230:28077187,28075342:autre:4230:28077134,28075344:autre:4230:28075740,28075346:autre:4230:28075681,28075348:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.11102049715374607, 'nb_photo': 128597, 'list_port_cont': '28067553,28067981,28068082,28068123,28068149,28068246,28068354,28068427,28068473,28068512,28068659,28068698,28068851,28068883,28069090,28069109,28069171,28069205,28069250,28069478,28069686,28070205,28070576,28070749,28075251,28075410,28075454,28075531,28075562,28075605,28075635,28075674,28075752,28075782,28075819,28076008,28076084,28076120,28076792,28077020,28077071,28077149,28077174,28077215,28077241,28077330,28077410,28078196,28120247,28120419,28120959,28120990,28122149,28122357,28122562,28123279,28123657,28124004,28124426,28124480,28124558,28124787,28125060,28125219,28126493,28127154,28127525,28128927,28131861,28134461,28135813,28138543,28180338,28182272,28182661,28182700,28182902,28183076,28183211,28183272,28183492,28183578,28183738,28183839,28183923,28184089,28184210,28184332,28184391,28184428,28184483,28184552,28185788,28186445,28186536,28187013,28230412,28230471,28230647,28230723,28230778,28231084,28231439,28231530,28231627,28231726,28232296,28232398,28232584,28232970,28233390,28233599,28234021,2823417', 'assoc_port': '28067357:28067553,28067802:28069686,28067805:28069478,28067808:28069250,28067811:28069205,28067814:28069171,28067816:28069109,28067819:28069090,28067822:28070749,28067825:28068883,28067827:28068851,28067830:28068698,28067832:28068659,28067835:28068473,28067838:28068427,28067840:28068512,28067843:28068354,28067845:28068246,28067848:28068149,28067850:28068123,28067853:28068082,28067855:28067981,28069319:28070205,28070473:28070576,28075152:28075251,28075322:28076008,28075325:28077410,28075328:28077330,28075331:28076120,28075334:28076084,28075337:28077241,28075340:28077174,28075342:28077149,28075344:28075752,28075346:28075674,28075348:28075819,28075351:28075782,28075352:28075531,28075354:28077071,28075355:28075562,28075356:28077215,28075357:28075635,28075358:28075410,28075359:28075454,28075360:28078196,28075361:28075605,28076697:28076792,28076881:28077020,28119040:28125219,28119042:28127154,28119045:28125060,28119048:28128927,28119051:28123657,28119054:28123279,28119058:28134461,28119062:28127525,28119065:2812256', 'assoc_mat': '28067357:carton:4230:28067553,28067802:carton:4230:28069686,28067805:carton:4230:28069478,28067808:carton:4230:28069250,28067811:carton:4230:28069205,28067814:carton:4230:28069171,28067816:carton:4230:28069109,28067819:carton:4230:28069090,28067822:carton:4230:28070749,28067825:carton:4230:28068883,28067827:carton:4230:28068851,28067830:carton:4230:28068698,28067832:carton:4230:28068659,28067835:carton:4230:28068473,28067838:carton:4230:28068427,28067840:carton:4230:28068512,28067843:carton:4230:28068354,28067845:carton:4230:28068246,28067848:carton:4230:28068149,28067850:carton:4230:28068123,28067853:carton:4230:28068082,28067855:carton:4230:28067981,28069319:carton:4230:28070205,28070473:carton:4230:28070576,28075152:carton:4230:28075251,28075322:carton:4230:28076008,28075325:carton:4230:28077410,28075328:carton:4230:28077330,28075331:carton:4230:28076120,28075334:carton:4230:28076084,28075337:carton:4230:28077241,28075340:carton:4230:28077174,28075342:carton:4230:28077149,28075344:carton:4230:28075752,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014854814712516597, 'nb_photo': 1744, 'list_port_cont': '28067550,28067991,28068067,28068118,28068157,28068250,28068363,28068435,28068472,28068505,28068644,28068694,28068852,28068885,28069092,28069105,28069160,28069219,28069479,28069694,28070195,28070572,28070748,28075249,28075412,28075440,28075517,28075555,28075589,28075631,28075668,28075737,28075773,28075817,28075999,28076083,28076105,28076794,28077022,28077059,28077151,28077173,28077216,28077233,28077327,28077396,28078201,28120243,28120421,28120946,28120984,28122154,28122363,28122552,28123278,28123662,28124005,28124415,28124476,28124564,28124789,28125050,28125213,28126478,28127155,28127517,28128916,28131855,28134470,28135798,28138547,28180326,28182261,28182656,28182701,28182889,28183074,28183197,28183266,28183494,28183587,28183722,28183849,28183906,28184083,28184198,28184331,28184379,28184412,28184470,28184554,28185796,28186435,28186523,28186997,28230408,28230468,28230653,28230713,28230777,28231085,28231430,28231523,28231619,28231725,28232285,28232400,28232587,28232955,28233389,28233588,28234013,28234166,2823435', 'assoc_port': '28067357:28067550,28067802:28069694,28067805:28069479,28067811:28069219,28067814:28069160,28067816:28069105,28067819:28069092,28067822:28070748,28067825:28068885,28067827:28068852,28067830:28068694,28067832:28068644,28067835:28068472,28067838:28068435,28067840:28068505,28067843:28068363,28067845:28068250,28067848:28068157,28067850:28068118,28067853:28068067,28067855:28067991,28069319:28070195,28070473:28070572,28075152:28075249,28075322:28075999,28075325:28077396,28075328:28077327,28075331:28076105,28075334:28076083,28075337:28077233,28075340:28077173,28075342:28077151,28075344:28075737,28075346:28075668,28075348:28075817,28075351:28075773,28075352:28075517,28075354:28077059,28075355:28075555,28075356:28077216,28075357:28075631,28075358:28075412,28075359:28075440,28075360:28078201,28075361:28075589,28076697:28076794,28076881:28077022,28119040:28125213,28119042:28127155,28119045:28125050,28119048:28128916,28119051:28123662,28119054:28123278,28119058:28134470,28119062:28127517,28119065:28122552,28119085:2812236', 'assoc_mat': '28067357:metal:4230:28067550,28067802:metal:4230:28069694,28067805:metal:4230:28069479,28067811:metal:4230:28069219,28067814:metal:4230:28069160,28067816:metal:4230:28069105,28067819:metal:4230:28069092,28067822:metal:4230:28070748,28067825:metal:4230:28068885,28067827:metal:4230:28068852,28067830:metal:4230:28068694,28067832:metal:4230:28068644,28067835:metal:4230:28068472,28067838:metal:4230:28068435,28067840:metal:4230:28068505,28067843:metal:4230:28068363,28067845:metal:4230:28068250,28067848:metal:4230:28068157,28067850:metal:4230:28068118,28067853:metal:4230:28068067,28067855:metal:4230:28067991,28069319:metal:4230:28070195,28070473:metal:4230:28070572,28075152:metal:4230:28075249,28075322:metal:4230:28075999,28075325:metal:4230:28077396,28075328:metal:4230:28077327,28075331:metal:4230:28076105,28075334:metal:4230:28076083,28075337:metal:4230:28077233,28075340:metal:4230:28077173,28075342:metal:4230:28077151,28075344:metal:4230:28075737,28075346:metal:4230:28075668,28075348:metal:4230:28075817,28075351:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2692321085074215, 'nb_photo': 363365, 'list_port_cont': '28067555,28067979,28068070,28068115,28068159,28068258,28068357,28068428,28068471,28068518,28068650,28068705,28068842,28068888,28069097,28069113,28069173,28069215,28069255,28069468,28069693,28070206,28070575,28070745,28075252,28075418,28075450,28075527,28075561,28075598,28075641,28075678,28075754,28075786,28075813,28076005,28076076,28076114,28076797,28077010,28077072,28077139,28077181,28077221,28077232,28077328,28077408,28078195,28120255,28120426,28120960,28120998,28122153,28122365,28122548,28123288,28123656,28124006,28124422,28124482,28124562,28124791,28125055,28125225,28126494,28127162,28127530,28128931,28131854,28134468,28135809,28138538,28180343,28182273,28182664,28182695,28182898,28183083,28183200,28183260,28183496,28183581,28183734,28183836,28183920,28184094,28184211,28184343,28184389,28184422,28184482,28184557,28185793,28186441,28186534,28187006,28230417,28230477,28230644,28230729,28230782,28231081,28231434,28231526,28231620,28231741,28232290,28232402,28232579,28232962,28233392,28233600,28234023,2823417', 'assoc_port': '28067357:28067555,28067802:28069693,28067805:28069468,28067808:28069255,28067811:28069215,28067814:28069173,28067816:28069113,28067819:28069097,28067822:28070745,28067825:28068888,28067827:28068842,28067830:28068705,28067832:28068650,28067835:28068471,28067838:28068428,28067840:28068518,28067843:28068357,28067845:28068258,28067848:28068159,28067850:28068115,28067853:28068070,28067855:28067979,28069319:28070206,28070473:28070575,28075152:28075252,28075322:28076005,28075325:28077408,28075328:28077328,28075331:28076114,28075334:28076076,28075337:28077232,28075340:28077181,28075342:28077139,28075344:28075754,28075346:28075678,28075348:28075813,28075351:28075786,28075352:28075527,28075354:28077072,28075355:28075561,28075356:28077221,28075357:28075641,28075358:28075418,28075359:28075450,28075360:28078195,28075361:28075598,28076697:28076797,28076881:28077010,28119040:28125225,28119042:28127162,28119045:28125055,28119048:28128931,28119051:28123656,28119054:28123288,28119058:28134468,28119062:28127530,28119065:2812254', 'assoc_mat': '28067357:papier:4230:28067555,28067802:papier:4230:28069693,28067805:papier:4230:28069468,28067808:papier:4230:28069255,28067811:papier:4230:28069215,28067814:papier:4230:28069173,28067816:papier:4230:28069113,28067819:papier:4230:28069097,28067822:papier:4230:28070745,28067825:papier:4230:28068888,28067827:papier:4230:28068842,28067830:papier:4230:28068705,28067832:papier:4230:28068650,28067835:papier:4230:28068471,28067838:papier:4230:28068428,28067840:papier:4230:28068518,28067843:papier:4230:28068357,28067845:papier:4230:28068258,28067848:papier:4230:28068159,28067850:papier:4230:28068115,28067853:papier:4230:28068070,28067855:papier:4230:28067979,28069319:papier:4230:28070206,28070473:papier:4230:28070575,28075152:papier:4230:28075252,28075322:papier:4230:28076005,28075325:papier:4230:28077408,28075328:papier:4230:28077328,28075331:papier:4230:28076114,28075334:papier:4230:28076076,28075337:papier:4230:28077232,28075340:papier:4230:28077181,28075342:papier:4230:28077139,28075344:papier:4230:28075754,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006159889349602773, 'nb_photo': 4171, 'list_port_cont': '28067548,28067990,28068073,28068109,28068156,28068256,28068360,28068431,28068474,28068510,28068655,28068701,28068846,28068889,28069094,28069107,28069174,28069217,28069257,28069480,28069688,28070208,28070567,28070750,28075247,28075407,28075451,28075529,28075569,28075606,28075636,28075667,28075746,28075788,28075827,28076004,28076079,28076113,28076795,28077019,28077074,28077144,28077186,28077218,28077228,28077329,28077409,28078203,28120256,28120425,28120951,28120999,28122155,28122351,28122557,28123284,28123659,28123995,28124416,28124481,28124567,28124788,28125046,28125216,28126491,28127157,28127527,28128932,28131866,28134463,28135810,28138544,28180340,28182275,28182665,28182691,28182899,28183077,28183212,28183269,28183487,28183588,28183733,28183841,28183919,28184095,28184197,28184338,28184384,28184420,28184477,28184560,28185794,28186444,28186539,28187014,28230414,28230474,28230654,28230720,28230771,28231078,28231443,28231527,28231626,28231732,28232297,28232399,28232591,28232966,28233385,28233597,28234014,2823416', 'assoc_port': '28067357:28067548,28067802:28069688,28067805:28069480,28067808:28069257,28067811:28069217,28067814:28069174,28067816:28069107,28067819:28069094,28067822:28070750,28067825:28068889,28067827:28068846,28067830:28068701,28067832:28068655,28067835:28068474,28067838:28068431,28067840:28068510,28067843:28068360,28067845:28068256,28067848:28068156,28067850:28068109,28067853:28068073,28067855:28067990,28069319:28070208,28070473:28070567,28075152:28075247,28075322:28076004,28075325:28077409,28075328:28077329,28075331:28076113,28075334:28076079,28075337:28077228,28075340:28077186,28075342:28077144,28075344:28075746,28075346:28075667,28075348:28075827,28075351:28075788,28075352:28075529,28075354:28077074,28075355:28075569,28075356:28077218,28075357:28075636,28075358:28075407,28075359:28075451,28075360:28078203,28075361:28075606,28076697:28076795,28076881:28077019,28119040:28125216,28119042:28127157,28119045:28125046,28119048:28128932,28119051:28123659,28119054:28123284,28119058:28134463,28119062:28127527,28119065:2812255', 'assoc_mat': '28067357:pehd:4230:28067548,28067802:pehd:4230:28069688,28067805:pehd:4230:28069480,28067808:pehd:4230:28069257,28067811:pehd:4230:28069217,28067814:pehd:4230:28069174,28067816:pehd:4230:28069107,28067819:pehd:4230:28069094,28067822:pehd:4230:28070750,28067825:pehd:4230:28068889,28067827:pehd:4230:28068846,28067830:pehd:4230:28068701,28067832:pehd:4230:28068655,28067835:pehd:4230:28068474,28067838:pehd:4230:28068431,28067840:pehd:4230:28068510,28067843:pehd:4230:28068360,28067845:pehd:4230:28068256,28067848:pehd:4230:28068156,28067850:pehd:4230:28068109,28067853:pehd:4230:28068073,28067855:pehd:4230:28067990,28069319:pehd:4230:28070208,28070473:pehd:4230:28070567,28075152:pehd:4230:28075247,28075322:pehd:4230:28076004,28075325:pehd:4230:28077409,28075328:pehd:4230:28077329,28075331:pehd:4230:28076113,28075334:pehd:4230:28076079,28075337:pehd:4230:28077228,28075340:pehd:4230:28077186,28075342:pehd:4230:28077144,28075344:pehd:4230:28075746,28075346:pehd:4230:28075667,28075348:pehd:4230:28075827,28075351:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012522325149416496, 'nb_photo': 23842, 'list_port_cont': '28067554,28067976,28068068,28068121,28068155,28068260,28068364,28068433,28068469,28068511,28068647,28068706,28068837,28068878,28069096,28069114,28069170,28069220,28069245,28069469,28069690,28070202,28070577,28070738,28075250,28075420,28075447,28075528,28075559,28075600,28075638,28075679,28075749,28075777,28075825,28076009,28076075,28076118,28076788,28077023,28077069,28077146,28077184,28077208,28077229,28077332,28077404,28078207,28120250,28120423,28120957,28120986,28122159,28122364,28122563,28123285,28123658,28123997,28124424,28124477,28124565,28124790,28125053,28125228,28126483,28127164,28127524,28128925,28131864,28134469,28135808,28138540,28180335,28182276,28182662,28182692,28182904,28183068,28183209,28183267,28183485,28183584,28183739,28183846,28183916,28184090,28184195,28184333,28184386,28184425,28184480,28184555,28185787,28186440,28186538,28187011,28230403,28230462,28230649,28230721,28230784,28231082,28231433,28231521,28231614,28231737,28232289,28232396,28232578,28232971,28233393,28233592,28234022,2823416', 'assoc_port': '28067357:28067554,28067802:28069690,28067805:28069469,28067808:28069245,28067811:28069220,28067814:28069170,28067816:28069114,28067819:28069096,28067822:28070738,28067825:28068878,28067827:28068837,28067830:28068706,28067832:28068647,28067835:28068469,28067838:28068433,28067840:28068511,28067843:28068364,28067845:28068260,28067848:28068155,28067850:28068121,28067853:28068068,28067855:28067976,28069319:28070202,28070473:28070577,28075152:28075250,28075322:28076009,28075325:28077404,28075328:28077332,28075331:28076118,28075334:28076075,28075337:28077229,28075340:28077184,28075342:28077146,28075344:28075749,28075346:28075679,28075348:28075825,28075351:28075777,28075352:28075528,28075354:28077069,28075355:28075559,28075356:28077208,28075357:28075638,28075358:28075420,28075359:28075447,28075360:28078207,28075361:28075600,28076697:28076788,28076881:28077023,28119040:28125228,28119042:28127164,28119045:28125053,28119048:28128925,28119051:28123658,28119054:28123285,28119058:28134469,28119062:28127524,28119065:2812256', 'assoc_mat': '28067357:pet_clair:4230:28067554,28067802:pet_clair:4230:28069690,28067805:pet_clair:4230:28069469,28067808:pet_clair:4230:28069245,28067811:pet_clair:4230:28069220,28067814:pet_clair:4230:28069170,28067816:pet_clair:4230:28069114,28067819:pet_clair:4230:28069096,28067822:pet_clair:4230:28070738,28067825:pet_clair:4230:28068878,28067827:pet_clair:4230:28068837,28067830:pet_clair:4230:28068706,28067832:pet_clair:4230:28068647,28067835:pet_clair:4230:28068469,28067838:pet_clair:4230:28068433,28067840:pet_clair:4230:28068511,28067843:pet_clair:4230:28068364,28067845:pet_clair:4230:28068260,28067848:pet_clair:4230:28068155,28067850:pet_clair:4230:28068121,28067853:pet_clair:4230:28068068,28067855:pet_clair:4230:28067976,28069319:pet_clair:4230:28070202,28070473:pet_clair:4230:28070577,28075152:pet_clair:4230:28075250,28075322:pet_clair:4230:28076009,28075325:pet_clair:4230:28077404,28075328:pet_clair:4230:28077332,28075331:pet_clair:4230:28076118,28075334:pet_clair:4230:28076075,28075337:pet_clair:4230:28077229,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006066505030584147, 'nb_photo': 1607, 'list_port_cont': '28067561,28067986,28068079,28068358,28068429,28068461,28068517,28068656,28068695,28068844,28068886,28069093,28069115,28069164,28069218,28069253,28069698,28070200,28070566,28070753,28075238,28075415,28075446,28075519,28075568,28075593,28075644,28075680,28075751,28075780,28075818,28076001,28076081,28076116,28076796,28077013,28077073,28077145,28077183,28077220,28077234,28077334,28077402,28078208,28120251,28120403,28120955,28120997,28122158,28122362,28122550,28123281,28123664,28124003,28124414,28124485,28124568,28124783,28125054,28125223,28126487,28127163,28127529,28128930,28131865,28134473,28135811,28138552,28180332,28182267,28182704,28182896,28183082,28183265,28183483,28183577,28183729,28183838,28183917,28184096,28184200,28184334,28184378,28184427,28184481,28185797,28186439,28186540,28187007,28230413,28230475,28230642,28230730,28230783,28231087,28231440,28231520,28231621,28231733,28232293,28232391,28232583,28232969,28233397,28233595,28234020,28234357,28234421,28235215,28235433,28285288,28289698,28290024,2829141', 'assoc_port': '28067357:28067561,28067802:28069698,28067808:28069253,28067811:28069218,28067814:28069164,28067816:28069115,28067819:28069093,28067822:28070753,28067825:28068886,28067827:28068844,28067830:28068695,28067832:28068656,28067835:28068461,28067838:28068429,28067840:28068517,28067843:28068358,28067853:28068079,28067855:28067986,28069319:28070200,28070473:28070566,28075152:28075238,28075322:28076001,28075325:28077402,28075328:28077334,28075331:28076116,28075334:28076081,28075337:28077234,28075340:28077183,28075342:28077145,28075344:28075751,28075346:28075680,28075348:28075818,28075351:28075780,28075352:28075519,28075354:28077073,28075355:28075568,28075356:28077220,28075357:28075644,28075358:28075415,28075359:28075446,28075360:28078208,28075361:28075593,28076697:28076796,28076881:28077013,28119040:28125223,28119042:28127163,28119045:28125054,28119048:28128930,28119051:28123664,28119054:28123281,28119058:28134473,28119062:28127529,28119065:28122550,28119085:28122362,28119088:28131865,28119113:28122158,28119126:2812099', 'assoc_mat': '28067357:pet_fonce:4230:28067561,28067802:pet_fonce:4230:28069698,28067808:pet_fonce:4230:28069253,28067811:pet_fonce:4230:28069218,28067814:pet_fonce:4230:28069164,28067816:pet_fonce:4230:28069115,28067819:pet_fonce:4230:28069093,28067822:pet_fonce:4230:28070753,28067825:pet_fonce:4230:28068886,28067827:pet_fonce:4230:28068844,28067830:pet_fonce:4230:28068695,28067832:pet_fonce:4230:28068656,28067835:pet_fonce:4230:28068461,28067838:pet_fonce:4230:28068429,28067840:pet_fonce:4230:28068517,28067843:pet_fonce:4230:28068358,28067853:pet_fonce:4230:28068079,28067855:pet_fonce:4230:28067986,28069319:pet_fonce:4230:28070200,28070473:pet_fonce:4230:28070566,28075152:pet_fonce:4230:28075238,28075322:pet_fonce:4230:28076001,28075325:pet_fonce:4230:28077402,28075328:pet_fonce:4230:28077334,28075331:pet_fonce:4230:28076116,28075334:pet_fonce:4230:28076081,28075337:pet_fonce:4230:28077234,28075340:pet_fonce:4230:28077183,28075342:pet_fonce:4230:28077145,28075344:pet_fonce:4230:28075751,28075346:pet_fonce:4230:28075680,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(2501835,2503327,2510381,2519615,2528255,2537429,2545382,2553364,2556007,2563745,2571262,2578140,2584770,2592277,2598229,2598793,2605107,2613598,2621074,2630916,2634689,2638880,2639432)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-11-01' and date <= '2025-11-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1803,),), 'unwanted_material_monthly_percentage': ((0.6273057922567403,),), 'material_repartition': (('incineration', 1799),), 'material_dict': {'incineration': 1799}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 11, 1), 0.4942163047884082, 4), (datetime.date(2025, 11, 2), 0.5171817509303603, 3), (datetime.date(2025, 11, 3), 0.5028104636800095, 2), (datetime.date(2025, 11, 4), 0.48757500039948876, 3), (datetime.date(2025, 11, 5), 0.45155694640005395, 4), (datetime.date(2025, 11, 6), 0.515762073317457, 2), (datetime.date(2025, 11, 7), 0.4937134166061022, 3), (datetime.date(2025, 11, 8), 0.5111753577662862, 4), (datetime.date(2025, 11, 9), 0.5861048077191015, 4), (datetime.date(2025, 11, 10), 0.5847124202428751, 4), (datetime.date(2025, 11, 11), 0.626929993546497, 2), (datetime.date(2025, 11, 12), 0.7182470231322161, 4), (datetime.date(2025, 11, 13), 0.7420157218395402, 4), (datetime.date(2025, 11, 14), 0.6798469302753353, 3), (datetime.date(2025, 11, 15), 0.7248251849715974, 4), (datetime.date(2025, 11, 16), 0.7389046811238653, 4), (datetime.date(2025, 11, 17), 0.757306465389342, 4), (datetime.date(2025, 11, 18), 0.7968084153022256, 4), (datetime.date(2025, 11, 19), 0.7142994895811758, 3), (datetime.date(2025, 11, 20), 0.6298857927145235, 2), (datetime.date(2025, 11, 21), 0.6867031522962312, 3), (datetime.date(2025, 11, 22), 0.7291884790988172, 3), (datetime.date(2025, 11, 23), 0.7361011567660717, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 11, 1), 0.4942163047884082, 4), (datetime.date(2025, 11, 2), 0.5171817509303603, 3), (datetime.date(2025, 11, 3), 0.5028104636800095, 2), (datetime.date(2025, 11, 4), 0.48757500039948876, 3), (datetime.date(2025, 11, 5), 0.45155694640005395, 4), (datetime.date(2025, 11, 6), 0.515762073317457, 2), (datetime.date(2025, 11, 7), 0.4937134166061022, 3), (datetime.date(2025, 11, 8), 0.5111753577662862, 4), (datetime.date(2025, 11, 9), 0.5861048077191015, 4), (datetime.date(2025, 11, 10), 0.5847124202428751, 4), (datetime.date(2025, 11, 11), 0.626929993546497, 2), (datetime.date(2025, 11, 12), 0.7182470231322161, 4), (datetime.date(2025, 11, 13), 0.7420157218395402, 4), (datetime.date(2025, 11, 14), 0.6798469302753353, 3), (datetime.date(2025, 11, 15), 0.7248251849715974, 4), (datetime.date(2025, 11, 16), 0.7389046811238653, 4), (datetime.date(2025, 11, 17), 0.757306465389342, 4), (datetime.date(2025, 11, 18), 0.7968084153022256, 4), (datetime.date(2025, 11, 19), 0.7142994895811758, 3), (datetime.date(2025, 11, 20), 0.6298857927145235, 2), (datetime.date(2025, 11, 21), 0.6867031522962312, 3), (datetime.date(2025, 11, 22), 0.7291884790988172, 3), (datetime.date(2025, 11, 23), 0.7361011567660717, 4))}, 'quality_array': [['-9.13163916574185', '01112025'], ['-9.105476568580466', '02112025'], ['-8.795065785914499', '03112025'], ['-8.860685636746766', '04112025'], ['-8.733681533050698', '05112025'], ['-8.532234032493028', '06112025'], ['-8.79869338599861', '07112025'], ['-8.817973563759494', '08112025'], ['-8.712250258034597', '09112025'], ['-8.488231322911147', '10112025'], ['-8.673915883484437', '11112025'], ['-7.803543269169573', '12112025'], ['-7.472867894468921', '13112025'], ['-8.068920010628982', '14112025'], ['-7.988511628482428', '15112025'], ['-8.168720436450801', '16112025'], ['-7.903706952952863', '17112025'], ['-7.336671736751455', '18112025'], ['-7.460000897316784', '19112025'], ['-7.92958699835851', '20112025'], ['-7.961020926137406', '21112025'], ['-7.573467064163134', '22112025'], ['-8.013038204886273', '23112025']], 'number_of_batch': ((526,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02125814846063444, 'nb_photo': 19245, 'list_port_cont': '28067557,28067987,28068076,28068110,28068162,28068251,28068361,28068425,28068466,28068519,28068652,28068696,28068839,28068877,28069081,28069116,28069176,28069208,28069241,28069465,28069685,28070204,28070570,28070747,28075244,28075411,28075455,28075526,28075567,28075591,28075643,28075681,28075740,28075785,28075814,28075995,28076077,28076108,28076782,28077016,28077064,28077134,28077187,28077217,28077224,28077324,28077393,28078202,28120254,28120424,28120956,28120988,28122143,28122350,28122555,28123273,28123649,28123994,28124410,28124484,28124557,28124793,28125059,28125226,28126480,28127156,28127516,28128918,28131851,28134472,28135802,28138533,28180330,28182260,28182667,28182698,28182900,28183080,28183196,28183262,28183491,28183575,28183727,28183843,28183907,28184092,28184206,28184329,28184382,28184414,28184473,28184559,28185789,28186423,28186532,28187015,28230410,28230464,28230645,28230725,28230774,28231089,28231438,28231513,28231622,28231740,28232294,28232385,28232588,28232961,28233394,28233584,28234019,2823416', 'assoc_port': '28067357:28067557,28067802:28069685,28067805:28069465,28067808:28069241,28067811:28069208,28067814:28069176,28067816:28069116,28067819:28069081,28067822:28070747,28067825:28068877,28067827:28068839,28067830:28068696,28067832:28068652,28067835:28068466,28067838:28068425,28067840:28068519,28067843:28068361,28067845:28068251,28067848:28068162,28067850:28068110,28067853:28068076,28067855:28067987,28069319:28070204,28070473:28070570,28075152:28075244,28075322:28075995,28075325:28077393,28075328:28077324,28075331:28076108,28075334:28076077,28075337:28077224,28075340:28077187,28075342:28077134,28075344:28075740,28075346:28075681,28075348:28075814,28075351:28075785,28075352:28075526,28075354:28077064,28075355:28075567,28075356:28077217,28075357:28075643,28075358:28075411,28075359:28075455,28075360:28078202,28075361:28075591,28076697:28076782,28076881:28077016,28119040:28125226,28119042:28127156,28119045:28125059,28119048:28128918,28119051:28123649,28119054:28123273,28119058:28134472,28119062:28127516,28119065:2812255', 'assoc_mat': '28067357:autre:4230:28067557,28067802:autre:4230:28069685,28067805:autre:4230:28069465,28067808:autre:4230:28069241,28067811:autre:4230:28069208,28067814:autre:4230:28069176,28067816:autre:4230:28069116,28067819:autre:4230:28069081,28067822:autre:4230:28070747,28067825:autre:4230:28068877,28067827:autre:4230:28068839,28067830:autre:4230:28068696,28067832:autre:4230:28068652,28067835:autre:4230:28068466,28067838:autre:4230:28068425,28067840:autre:4230:28068519,28067843:autre:4230:28068361,28067845:autre:4230:28068251,28067848:autre:4230:28068162,28067850:autre:4230:28068110,28067853:autre:4230:28068076,28067855:autre:4230:28067987,28069319:autre:4230:28070204,28070473:autre:4230:28070570,28075152:autre:4230:28075244,28075322:autre:4230:28075995,28075325:autre:4230:28077393,28075328:autre:4230:28077324,28075331:autre:4230:28076108,28075334:autre:4230:28076077,28075337:autre:4230:28077224,28075340:autre:4230:28077187,28075342:autre:4230:28077134,28075344:autre:4230:28075740,28075346:autre:4230:28075681,28075348:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.11102049715374607, 'nb_photo': 128597, 'list_port_cont': '28067553,28067981,28068082,28068123,28068149,28068246,28068354,28068427,28068473,28068512,28068659,28068698,28068851,28068883,28069090,28069109,28069171,28069205,28069250,28069478,28069686,28070205,28070576,28070749,28075251,28075410,28075454,28075531,28075562,28075605,28075635,28075674,28075752,28075782,28075819,28076008,28076084,28076120,28076792,28077020,28077071,28077149,28077174,28077215,28077241,28077330,28077410,28078196,28120247,28120419,28120959,28120990,28122149,28122357,28122562,28123279,28123657,28124004,28124426,28124480,28124558,28124787,28125060,28125219,28126493,28127154,28127525,28128927,28131861,28134461,28135813,28138543,28180338,28182272,28182661,28182700,28182902,28183076,28183211,28183272,28183492,28183578,28183738,28183839,28183923,28184089,28184210,28184332,28184391,28184428,28184483,28184552,28185788,28186445,28186536,28187013,28230412,28230471,28230647,28230723,28230778,28231084,28231439,28231530,28231627,28231726,28232296,28232398,28232584,28232970,28233390,28233599,28234021,2823417', 'assoc_port': '28067357:28067553,28067802:28069686,28067805:28069478,28067808:28069250,28067811:28069205,28067814:28069171,28067816:28069109,28067819:28069090,28067822:28070749,28067825:28068883,28067827:28068851,28067830:28068698,28067832:28068659,28067835:28068473,28067838:28068427,28067840:28068512,28067843:28068354,28067845:28068246,28067848:28068149,28067850:28068123,28067853:28068082,28067855:28067981,28069319:28070205,28070473:28070576,28075152:28075251,28075322:28076008,28075325:28077410,28075328:28077330,28075331:28076120,28075334:28076084,28075337:28077241,28075340:28077174,28075342:28077149,28075344:28075752,28075346:28075674,28075348:28075819,28075351:28075782,28075352:28075531,28075354:28077071,28075355:28075562,28075356:28077215,28075357:28075635,28075358:28075410,28075359:28075454,28075360:28078196,28075361:28075605,28076697:28076792,28076881:28077020,28119040:28125219,28119042:28127154,28119045:28125060,28119048:28128927,28119051:28123657,28119054:28123279,28119058:28134461,28119062:28127525,28119065:2812256', 'assoc_mat': '28067357:carton:4230:28067553,28067802:carton:4230:28069686,28067805:carton:4230:28069478,28067808:carton:4230:28069250,28067811:carton:4230:28069205,28067814:carton:4230:28069171,28067816:carton:4230:28069109,28067819:carton:4230:28069090,28067822:carton:4230:28070749,28067825:carton:4230:28068883,28067827:carton:4230:28068851,28067830:carton:4230:28068698,28067832:carton:4230:28068659,28067835:carton:4230:28068473,28067838:carton:4230:28068427,28067840:carton:4230:28068512,28067843:carton:4230:28068354,28067845:carton:4230:28068246,28067848:carton:4230:28068149,28067850:carton:4230:28068123,28067853:carton:4230:28068082,28067855:carton:4230:28067981,28069319:carton:4230:28070205,28070473:carton:4230:28070576,28075152:carton:4230:28075251,28075322:carton:4230:28076008,28075325:carton:4230:28077410,28075328:carton:4230:28077330,28075331:carton:4230:28076120,28075334:carton:4230:28076084,28075337:carton:4230:28077241,28075340:carton:4230:28077174,28075342:carton:4230:28077149,28075344:carton:4230:28075752,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014854814712516597, 'nb_photo': 1744, 'list_port_cont': '28067550,28067991,28068067,28068118,28068157,28068250,28068363,28068435,28068472,28068505,28068644,28068694,28068852,28068885,28069092,28069105,28069160,28069219,28069479,28069694,28070195,28070572,28070748,28075249,28075412,28075440,28075517,28075555,28075589,28075631,28075668,28075737,28075773,28075817,28075999,28076083,28076105,28076794,28077022,28077059,28077151,28077173,28077216,28077233,28077327,28077396,28078201,28120243,28120421,28120946,28120984,28122154,28122363,28122552,28123278,28123662,28124005,28124415,28124476,28124564,28124789,28125050,28125213,28126478,28127155,28127517,28128916,28131855,28134470,28135798,28138547,28180326,28182261,28182656,28182701,28182889,28183074,28183197,28183266,28183494,28183587,28183722,28183849,28183906,28184083,28184198,28184331,28184379,28184412,28184470,28184554,28185796,28186435,28186523,28186997,28230408,28230468,28230653,28230713,28230777,28231085,28231430,28231523,28231619,28231725,28232285,28232400,28232587,28232955,28233389,28233588,28234013,28234166,2823435', 'assoc_port': '28067357:28067550,28067802:28069694,28067805:28069479,28067811:28069219,28067814:28069160,28067816:28069105,28067819:28069092,28067822:28070748,28067825:28068885,28067827:28068852,28067830:28068694,28067832:28068644,28067835:28068472,28067838:28068435,28067840:28068505,28067843:28068363,28067845:28068250,28067848:28068157,28067850:28068118,28067853:28068067,28067855:28067991,28069319:28070195,28070473:28070572,28075152:28075249,28075322:28075999,28075325:28077396,28075328:28077327,28075331:28076105,28075334:28076083,28075337:28077233,28075340:28077173,28075342:28077151,28075344:28075737,28075346:28075668,28075348:28075817,28075351:28075773,28075352:28075517,28075354:28077059,28075355:28075555,28075356:28077216,28075357:28075631,28075358:28075412,28075359:28075440,28075360:28078201,28075361:28075589,28076697:28076794,28076881:28077022,28119040:28125213,28119042:28127155,28119045:28125050,28119048:28128916,28119051:28123662,28119054:28123278,28119058:28134470,28119062:28127517,28119065:28122552,28119085:2812236', 'assoc_mat': '28067357:metal:4230:28067550,28067802:metal:4230:28069694,28067805:metal:4230:28069479,28067811:metal:4230:28069219,28067814:metal:4230:28069160,28067816:metal:4230:28069105,28067819:metal:4230:28069092,28067822:metal:4230:28070748,28067825:metal:4230:28068885,28067827:metal:4230:28068852,28067830:metal:4230:28068694,28067832:metal:4230:28068644,28067835:metal:4230:28068472,28067838:metal:4230:28068435,28067840:metal:4230:28068505,28067843:metal:4230:28068363,28067845:metal:4230:28068250,28067848:metal:4230:28068157,28067850:metal:4230:28068118,28067853:metal:4230:28068067,28067855:metal:4230:28067991,28069319:metal:4230:28070195,28070473:metal:4230:28070572,28075152:metal:4230:28075249,28075322:metal:4230:28075999,28075325:metal:4230:28077396,28075328:metal:4230:28077327,28075331:metal:4230:28076105,28075334:metal:4230:28076083,28075337:metal:4230:28077233,28075340:metal:4230:28077173,28075342:metal:4230:28077151,28075344:metal:4230:28075737,28075346:metal:4230:28075668,28075348:metal:4230:28075817,28075351:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2692321085074215, 'nb_photo': 363365, 'list_port_cont': '28067555,28067979,28068070,28068115,28068159,28068258,28068357,28068428,28068471,28068518,28068650,28068705,28068842,28068888,28069097,28069113,28069173,28069215,28069255,28069468,28069693,28070206,28070575,28070745,28075252,28075418,28075450,28075527,28075561,28075598,28075641,28075678,28075754,28075786,28075813,28076005,28076076,28076114,28076797,28077010,28077072,28077139,28077181,28077221,28077232,28077328,28077408,28078195,28120255,28120426,28120960,28120998,28122153,28122365,28122548,28123288,28123656,28124006,28124422,28124482,28124562,28124791,28125055,28125225,28126494,28127162,28127530,28128931,28131854,28134468,28135809,28138538,28180343,28182273,28182664,28182695,28182898,28183083,28183200,28183260,28183496,28183581,28183734,28183836,28183920,28184094,28184211,28184343,28184389,28184422,28184482,28184557,28185793,28186441,28186534,28187006,28230417,28230477,28230644,28230729,28230782,28231081,28231434,28231526,28231620,28231741,28232290,28232402,28232579,28232962,28233392,28233600,28234023,2823417', 'assoc_port': '28067357:28067555,28067802:28069693,28067805:28069468,28067808:28069255,28067811:28069215,28067814:28069173,28067816:28069113,28067819:28069097,28067822:28070745,28067825:28068888,28067827:28068842,28067830:28068705,28067832:28068650,28067835:28068471,28067838:28068428,28067840:28068518,28067843:28068357,28067845:28068258,28067848:28068159,28067850:28068115,28067853:28068070,28067855:28067979,28069319:28070206,28070473:28070575,28075152:28075252,28075322:28076005,28075325:28077408,28075328:28077328,28075331:28076114,28075334:28076076,28075337:28077232,28075340:28077181,28075342:28077139,28075344:28075754,28075346:28075678,28075348:28075813,28075351:28075786,28075352:28075527,28075354:28077072,28075355:28075561,28075356:28077221,28075357:28075641,28075358:28075418,28075359:28075450,28075360:28078195,28075361:28075598,28076697:28076797,28076881:28077010,28119040:28125225,28119042:28127162,28119045:28125055,28119048:28128931,28119051:28123656,28119054:28123288,28119058:28134468,28119062:28127530,28119065:2812254', 'assoc_mat': '28067357:papier:4230:28067555,28067802:papier:4230:28069693,28067805:papier:4230:28069468,28067808:papier:4230:28069255,28067811:papier:4230:28069215,28067814:papier:4230:28069173,28067816:papier:4230:28069113,28067819:papier:4230:28069097,28067822:papier:4230:28070745,28067825:papier:4230:28068888,28067827:papier:4230:28068842,28067830:papier:4230:28068705,28067832:papier:4230:28068650,28067835:papier:4230:28068471,28067838:papier:4230:28068428,28067840:papier:4230:28068518,28067843:papier:4230:28068357,28067845:papier:4230:28068258,28067848:papier:4230:28068159,28067850:papier:4230:28068115,28067853:papier:4230:28068070,28067855:papier:4230:28067979,28069319:papier:4230:28070206,28070473:papier:4230:28070575,28075152:papier:4230:28075252,28075322:papier:4230:28076005,28075325:papier:4230:28077408,28075328:papier:4230:28077328,28075331:papier:4230:28076114,28075334:papier:4230:28076076,28075337:papier:4230:28077232,28075340:papier:4230:28077181,28075342:papier:4230:28077139,28075344:papier:4230:28075754,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006159889349602773, 'nb_photo': 4171, 'list_port_cont': '28067548,28067990,28068073,28068109,28068156,28068256,28068360,28068431,28068474,28068510,28068655,28068701,28068846,28068889,28069094,28069107,28069174,28069217,28069257,28069480,28069688,28070208,28070567,28070750,28075247,28075407,28075451,28075529,28075569,28075606,28075636,28075667,28075746,28075788,28075827,28076004,28076079,28076113,28076795,28077019,28077074,28077144,28077186,28077218,28077228,28077329,28077409,28078203,28120256,28120425,28120951,28120999,28122155,28122351,28122557,28123284,28123659,28123995,28124416,28124481,28124567,28124788,28125046,28125216,28126491,28127157,28127527,28128932,28131866,28134463,28135810,28138544,28180340,28182275,28182665,28182691,28182899,28183077,28183212,28183269,28183487,28183588,28183733,28183841,28183919,28184095,28184197,28184338,28184384,28184420,28184477,28184560,28185794,28186444,28186539,28187014,28230414,28230474,28230654,28230720,28230771,28231078,28231443,28231527,28231626,28231732,28232297,28232399,28232591,28232966,28233385,28233597,28234014,2823416', 'assoc_port': '28067357:28067548,28067802:28069688,28067805:28069480,28067808:28069257,28067811:28069217,28067814:28069174,28067816:28069107,28067819:28069094,28067822:28070750,28067825:28068889,28067827:28068846,28067830:28068701,28067832:28068655,28067835:28068474,28067838:28068431,28067840:28068510,28067843:28068360,28067845:28068256,28067848:28068156,28067850:28068109,28067853:28068073,28067855:28067990,28069319:28070208,28070473:28070567,28075152:28075247,28075322:28076004,28075325:28077409,28075328:28077329,28075331:28076113,28075334:28076079,28075337:28077228,28075340:28077186,28075342:28077144,28075344:28075746,28075346:28075667,28075348:28075827,28075351:28075788,28075352:28075529,28075354:28077074,28075355:28075569,28075356:28077218,28075357:28075636,28075358:28075407,28075359:28075451,28075360:28078203,28075361:28075606,28076697:28076795,28076881:28077019,28119040:28125216,28119042:28127157,28119045:28125046,28119048:28128932,28119051:28123659,28119054:28123284,28119058:28134463,28119062:28127527,28119065:2812255', 'assoc_mat': '28067357:pehd:4230:28067548,28067802:pehd:4230:28069688,28067805:pehd:4230:28069480,28067808:pehd:4230:28069257,28067811:pehd:4230:28069217,28067814:pehd:4230:28069174,28067816:pehd:4230:28069107,28067819:pehd:4230:28069094,28067822:pehd:4230:28070750,28067825:pehd:4230:28068889,28067827:pehd:4230:28068846,28067830:pehd:4230:28068701,28067832:pehd:4230:28068655,28067835:pehd:4230:28068474,28067838:pehd:4230:28068431,28067840:pehd:4230:28068510,28067843:pehd:4230:28068360,28067845:pehd:4230:28068256,28067848:pehd:4230:28068156,28067850:pehd:4230:28068109,28067853:pehd:4230:28068073,28067855:pehd:4230:28067990,28069319:pehd:4230:28070208,28070473:pehd:4230:28070567,28075152:pehd:4230:28075247,28075322:pehd:4230:28076004,28075325:pehd:4230:28077409,28075328:pehd:4230:28077329,28075331:pehd:4230:28076113,28075334:pehd:4230:28076079,28075337:pehd:4230:28077228,28075340:pehd:4230:28077186,28075342:pehd:4230:28077144,28075344:pehd:4230:28075746,28075346:pehd:4230:28075667,28075348:pehd:4230:28075827,28075351:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012522325149416496, 'nb_photo': 23842, 'list_port_cont': '28067554,28067976,28068068,28068121,28068155,28068260,28068364,28068433,28068469,28068511,28068647,28068706,28068837,28068878,28069096,28069114,28069170,28069220,28069245,28069469,28069690,28070202,28070577,28070738,28075250,28075420,28075447,28075528,28075559,28075600,28075638,28075679,28075749,28075777,28075825,28076009,28076075,28076118,28076788,28077023,28077069,28077146,28077184,28077208,28077229,28077332,28077404,28078207,28120250,28120423,28120957,28120986,28122159,28122364,28122563,28123285,28123658,28123997,28124424,28124477,28124565,28124790,28125053,28125228,28126483,28127164,28127524,28128925,28131864,28134469,28135808,28138540,28180335,28182276,28182662,28182692,28182904,28183068,28183209,28183267,28183485,28183584,28183739,28183846,28183916,28184090,28184195,28184333,28184386,28184425,28184480,28184555,28185787,28186440,28186538,28187011,28230403,28230462,28230649,28230721,28230784,28231082,28231433,28231521,28231614,28231737,28232289,28232396,28232578,28232971,28233393,28233592,28234022,2823416', 'assoc_port': '28067357:28067554,28067802:28069690,28067805:28069469,28067808:28069245,28067811:28069220,28067814:28069170,28067816:28069114,28067819:28069096,28067822:28070738,28067825:28068878,28067827:28068837,28067830:28068706,28067832:28068647,28067835:28068469,28067838:28068433,28067840:28068511,28067843:28068364,28067845:28068260,28067848:28068155,28067850:28068121,28067853:28068068,28067855:28067976,28069319:28070202,28070473:28070577,28075152:28075250,28075322:28076009,28075325:28077404,28075328:28077332,28075331:28076118,28075334:28076075,28075337:28077229,28075340:28077184,28075342:28077146,28075344:28075749,28075346:28075679,28075348:28075825,28075351:28075777,28075352:28075528,28075354:28077069,28075355:28075559,28075356:28077208,28075357:28075638,28075358:28075420,28075359:28075447,28075360:28078207,28075361:28075600,28076697:28076788,28076881:28077023,28119040:28125228,28119042:28127164,28119045:28125053,28119048:28128925,28119051:28123658,28119054:28123285,28119058:28134469,28119062:28127524,28119065:2812256', 'assoc_mat': '28067357:pet_clair:4230:28067554,28067802:pet_clair:4230:28069690,28067805:pet_clair:4230:28069469,28067808:pet_clair:4230:28069245,28067811:pet_clair:4230:28069220,28067814:pet_clair:4230:28069170,28067816:pet_clair:4230:28069114,28067819:pet_clair:4230:28069096,28067822:pet_clair:4230:28070738,28067825:pet_clair:4230:28068878,28067827:pet_clair:4230:28068837,28067830:pet_clair:4230:28068706,28067832:pet_clair:4230:28068647,28067835:pet_clair:4230:28068469,28067838:pet_clair:4230:28068433,28067840:pet_clair:4230:28068511,28067843:pet_clair:4230:28068364,28067845:pet_clair:4230:28068260,28067848:pet_clair:4230:28068155,28067850:pet_clair:4230:28068121,28067853:pet_clair:4230:28068068,28067855:pet_clair:4230:28067976,28069319:pet_clair:4230:28070202,28070473:pet_clair:4230:28070577,28075152:pet_clair:4230:28075250,28075322:pet_clair:4230:28076009,28075325:pet_clair:4230:28077404,28075328:pet_clair:4230:28077332,28075331:pet_clair:4230:28076118,28075334:pet_clair:4230:28076075,28075337:pet_clair:4230:28077229,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006066505030584147, 'nb_photo': 1607, 'list_port_cont': '28067561,28067986,28068079,28068358,28068429,28068461,28068517,28068656,28068695,28068844,28068886,28069093,28069115,28069164,28069218,28069253,28069698,28070200,28070566,28070753,28075238,28075415,28075446,28075519,28075568,28075593,28075644,28075680,28075751,28075780,28075818,28076001,28076081,28076116,28076796,28077013,28077073,28077145,28077183,28077220,28077234,28077334,28077402,28078208,28120251,28120403,28120955,28120997,28122158,28122362,28122550,28123281,28123664,28124003,28124414,28124485,28124568,28124783,28125054,28125223,28126487,28127163,28127529,28128930,28131865,28134473,28135811,28138552,28180332,28182267,28182704,28182896,28183082,28183265,28183483,28183577,28183729,28183838,28183917,28184096,28184200,28184334,28184378,28184427,28184481,28185797,28186439,28186540,28187007,28230413,28230475,28230642,28230730,28230783,28231087,28231440,28231520,28231621,28231733,28232293,28232391,28232583,28232969,28233397,28233595,28234020,28234357,28234421,28235215,28235433,28285288,28289698,28290024,2829141', 'assoc_port': '28067357:28067561,28067802:28069698,28067808:28069253,28067811:28069218,28067814:28069164,28067816:28069115,28067819:28069093,28067822:28070753,28067825:28068886,28067827:28068844,28067830:28068695,28067832:28068656,28067835:28068461,28067838:28068429,28067840:28068517,28067843:28068358,28067853:28068079,28067855:28067986,28069319:28070200,28070473:28070566,28075152:28075238,28075322:28076001,28075325:28077402,28075328:28077334,28075331:28076116,28075334:28076081,28075337:28077234,28075340:28077183,28075342:28077145,28075344:28075751,28075346:28075680,28075348:28075818,28075351:28075780,28075352:28075519,28075354:28077073,28075355:28075568,28075356:28077220,28075357:28075644,28075358:28075415,28075359:28075446,28075360:28078208,28075361:28075593,28076697:28076796,28076881:28077013,28119040:28125223,28119042:28127163,28119045:28125054,28119048:28128930,28119051:28123664,28119054:28123281,28119058:28134473,28119062:28127529,28119065:28122550,28119085:28122362,28119088:28131865,28119113:28122158,28119126:2812099', 'assoc_mat': '28067357:pet_fonce:4230:28067561,28067802:pet_fonce:4230:28069698,28067808:pet_fonce:4230:28069253,28067811:pet_fonce:4230:28069218,28067814:pet_fonce:4230:28069164,28067816:pet_fonce:4230:28069115,28067819:pet_fonce:4230:28069093,28067822:pet_fonce:4230:28070753,28067825:pet_fonce:4230:28068886,28067827:pet_fonce:4230:28068844,28067830:pet_fonce:4230:28068695,28067832:pet_fonce:4230:28068656,28067835:pet_fonce:4230:28068461,28067838:pet_fonce:4230:28068429,28067840:pet_fonce:4230:28068517,28067843:pet_fonce:4230:28068358,28067853:pet_fonce:4230:28068079,28067855:pet_fonce:4230:28067986,28069319:pet_fonce:4230:28070200,28070473:pet_fonce:4230:28070566,28075152:pet_fonce:4230:28075238,28075322:pet_fonce:4230:28076001,28075325:pet_fonce:4230:28077402,28075328:pet_fonce:4230:28077334,28075331:pet_fonce:4230:28076116,28075334:pet_fonce:4230:28076081,28075337:pet_fonce:4230:28077234,28075340:pet_fonce:4230:28077183,28075342:pet_fonce:4230:28077145,28075344:pet_fonce:4230:28075751,28075346:pet_fonce:4230:28075680,2'}), 'main_stat': {'nb_photos': 1803}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-11', 0.6273057922567403),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1803,),), 'unwanted_material_monthly_percentage': ((0.6273057922567403,),), 'material_repartition': (('incineration', 1799),), 'material_dict': {'incineration': 1799}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 11, 1), 0.4942163047884082, 4), (datetime.date(2025, 11, 2), 0.5171817509303603, 3), (datetime.date(2025, 11, 3), 0.5028104636800095, 2), (datetime.date(2025, 11, 4), 0.48757500039948876, 3), (datetime.date(2025, 11, 5), 0.45155694640005395, 4), (datetime.date(2025, 11, 6), 0.515762073317457, 2), (datetime.date(2025, 11, 7), 0.4937134166061022, 3), (datetime.date(2025, 11, 8), 0.5111753577662862, 4), (datetime.date(2025, 11, 9), 0.5861048077191015, 4), (datetime.date(2025, 11, 10), 0.5847124202428751, 4), (datetime.date(2025, 11, 11), 0.626929993546497, 2), (datetime.date(2025, 11, 12), 0.7182470231322161, 4), (datetime.date(2025, 11, 13), 0.7420157218395402, 4), (datetime.date(2025, 11, 14), 0.6798469302753353, 3), (datetime.date(2025, 11, 15), 0.7248251849715974, 4), (datetime.date(2025, 11, 16), 0.7389046811238653, 4), (datetime.date(2025, 11, 17), 0.757306465389342, 4), (datetime.date(2025, 11, 18), 0.7968084153022256, 4), (datetime.date(2025, 11, 19), 0.7142994895811758, 3), (datetime.date(2025, 11, 20), 0.6298857927145235, 2), (datetime.date(2025, 11, 21), 0.6867031522962312, 3), (datetime.date(2025, 11, 22), 0.7291884790988172, 3), (datetime.date(2025, 11, 23), 0.7361011567660717, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 11, 1), 0.4942163047884082, 4), (datetime.date(2025, 11, 2), 0.5171817509303603, 3), (datetime.date(2025, 11, 3), 0.5028104636800095, 2), (datetime.date(2025, 11, 4), 0.48757500039948876, 3), (datetime.date(2025, 11, 5), 0.45155694640005395, 4), (datetime.date(2025, 11, 6), 0.515762073317457, 2), (datetime.date(2025, 11, 7), 0.4937134166061022, 3), (datetime.date(2025, 11, 8), 0.5111753577662862, 4), (datetime.date(2025, 11, 9), 0.5861048077191015, 4), (datetime.date(2025, 11, 10), 0.5847124202428751, 4), (datetime.date(2025, 11, 11), 0.626929993546497, 2), (datetime.date(2025, 11, 12), 0.7182470231322161, 4), (datetime.date(2025, 11, 13), 0.7420157218395402, 4), (datetime.date(2025, 11, 14), 0.6798469302753353, 3), (datetime.date(2025, 11, 15), 0.7248251849715974, 4), (datetime.date(2025, 11, 16), 0.7389046811238653, 4), (datetime.date(2025, 11, 17), 0.757306465389342, 4), (datetime.date(2025, 11, 18), 0.7968084153022256, 4), (datetime.date(2025, 11, 19), 0.7142994895811758, 3), (datetime.date(2025, 11, 20), 0.6298857927145235, 2), (datetime.date(2025, 11, 21), 0.6867031522962312, 3), (datetime.date(2025, 11, 22), 0.7291884790988172, 3), (datetime.date(2025, 11, 23), 0.7361011567660717, 4))}, 'quality_array': [['-9.13163916574185', '01112025'], ['-9.105476568580466', '02112025'], ['-8.795065785914499', '03112025'], ['-8.860685636746766', '04112025'], ['-8.733681533050698', '05112025'], ['-8.532234032493028', '06112025'], ['-8.79869338599861', '07112025'], ['-8.817973563759494', '08112025'], ['-8.712250258034597', '09112025'], ['-8.488231322911147', '10112025'], ['-8.673915883484437', '11112025'], ['-7.803543269169573', '12112025'], ['-7.472867894468921', '13112025'], ['-8.068920010628982', '14112025'], ['-7.988511628482428', '15112025'], ['-8.168720436450801', '16112025'], ['-7.903706952952863', '17112025'], ['-7.336671736751455', '18112025'], ['-7.460000897316784', '19112025'], ['-7.92958699835851', '20112025'], ['-7.961020926137406', '21112025'], ['-7.573467064163134', '22112025'], ['-8.013038204886273', '23112025']], 'number_of_batch': ((526,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02125814846063444, 'nb_photo': 19245, 'list_port_cont': '28067557,28067987,28068076,28068110,28068162,28068251,28068361,28068425,28068466,28068519,28068652,28068696,28068839,28068877,28069081,28069116,28069176,28069208,28069241,28069465,28069685,28070204,28070570,28070747,28075244,28075411,28075455,28075526,28075567,28075591,28075643,28075681,28075740,28075785,28075814,28075995,28076077,28076108,28076782,28077016,28077064,28077134,28077187,28077217,28077224,28077324,28077393,28078202,28120254,28120424,28120956,28120988,28122143,28122350,28122555,28123273,28123649,28123994,28124410,28124484,28124557,28124793,28125059,28125226,28126480,28127156,28127516,28128918,28131851,28134472,28135802,28138533,28180330,28182260,28182667,28182698,28182900,28183080,28183196,28183262,28183491,28183575,28183727,28183843,28183907,28184092,28184206,28184329,28184382,28184414,28184473,28184559,28185789,28186423,28186532,28187015,28230410,28230464,28230645,28230725,28230774,28231089,28231438,28231513,28231622,28231740,28232294,28232385,28232588,28232961,28233394,28233584,28234019,2823416', 'assoc_port': '28067357:28067557,28067802:28069685,28067805:28069465,28067808:28069241,28067811:28069208,28067814:28069176,28067816:28069116,28067819:28069081,28067822:28070747,28067825:28068877,28067827:28068839,28067830:28068696,28067832:28068652,28067835:28068466,28067838:28068425,28067840:28068519,28067843:28068361,28067845:28068251,28067848:28068162,28067850:28068110,28067853:28068076,28067855:28067987,28069319:28070204,28070473:28070570,28075152:28075244,28075322:28075995,28075325:28077393,28075328:28077324,28075331:28076108,28075334:28076077,28075337:28077224,28075340:28077187,28075342:28077134,28075344:28075740,28075346:28075681,28075348:28075814,28075351:28075785,28075352:28075526,28075354:28077064,28075355:28075567,28075356:28077217,28075357:28075643,28075358:28075411,28075359:28075455,28075360:28078202,28075361:28075591,28076697:28076782,28076881:28077016,28119040:28125226,28119042:28127156,28119045:28125059,28119048:28128918,28119051:28123649,28119054:28123273,28119058:28134472,28119062:28127516,28119065:2812255', 'assoc_mat': '28067357:autre:4230:28067557,28067802:autre:4230:28069685,28067805:autre:4230:28069465,28067808:autre:4230:28069241,28067811:autre:4230:28069208,28067814:autre:4230:28069176,28067816:autre:4230:28069116,28067819:autre:4230:28069081,28067822:autre:4230:28070747,28067825:autre:4230:28068877,28067827:autre:4230:28068839,28067830:autre:4230:28068696,28067832:autre:4230:28068652,28067835:autre:4230:28068466,28067838:autre:4230:28068425,28067840:autre:4230:28068519,28067843:autre:4230:28068361,28067845:autre:4230:28068251,28067848:autre:4230:28068162,28067850:autre:4230:28068110,28067853:autre:4230:28068076,28067855:autre:4230:28067987,28069319:autre:4230:28070204,28070473:autre:4230:28070570,28075152:autre:4230:28075244,28075322:autre:4230:28075995,28075325:autre:4230:28077393,28075328:autre:4230:28077324,28075331:autre:4230:28076108,28075334:autre:4230:28076077,28075337:autre:4230:28077224,28075340:autre:4230:28077187,28075342:autre:4230:28077134,28075344:autre:4230:28075740,28075346:autre:4230:28075681,28075348:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.11102049715374607, 'nb_photo': 128597, 'list_port_cont': '28067553,28067981,28068082,28068123,28068149,28068246,28068354,28068427,28068473,28068512,28068659,28068698,28068851,28068883,28069090,28069109,28069171,28069205,28069250,28069478,28069686,28070205,28070576,28070749,28075251,28075410,28075454,28075531,28075562,28075605,28075635,28075674,28075752,28075782,28075819,28076008,28076084,28076120,28076792,28077020,28077071,28077149,28077174,28077215,28077241,28077330,28077410,28078196,28120247,28120419,28120959,28120990,28122149,28122357,28122562,28123279,28123657,28124004,28124426,28124480,28124558,28124787,28125060,28125219,28126493,28127154,28127525,28128927,28131861,28134461,28135813,28138543,28180338,28182272,28182661,28182700,28182902,28183076,28183211,28183272,28183492,28183578,28183738,28183839,28183923,28184089,28184210,28184332,28184391,28184428,28184483,28184552,28185788,28186445,28186536,28187013,28230412,28230471,28230647,28230723,28230778,28231084,28231439,28231530,28231627,28231726,28232296,28232398,28232584,28232970,28233390,28233599,28234021,2823417', 'assoc_port': '28067357:28067553,28067802:28069686,28067805:28069478,28067808:28069250,28067811:28069205,28067814:28069171,28067816:28069109,28067819:28069090,28067822:28070749,28067825:28068883,28067827:28068851,28067830:28068698,28067832:28068659,28067835:28068473,28067838:28068427,28067840:28068512,28067843:28068354,28067845:28068246,28067848:28068149,28067850:28068123,28067853:28068082,28067855:28067981,28069319:28070205,28070473:28070576,28075152:28075251,28075322:28076008,28075325:28077410,28075328:28077330,28075331:28076120,28075334:28076084,28075337:28077241,28075340:28077174,28075342:28077149,28075344:28075752,28075346:28075674,28075348:28075819,28075351:28075782,28075352:28075531,28075354:28077071,28075355:28075562,28075356:28077215,28075357:28075635,28075358:28075410,28075359:28075454,28075360:28078196,28075361:28075605,28076697:28076792,28076881:28077020,28119040:28125219,28119042:28127154,28119045:28125060,28119048:28128927,28119051:28123657,28119054:28123279,28119058:28134461,28119062:28127525,28119065:2812256', 'assoc_mat': '28067357:carton:4230:28067553,28067802:carton:4230:28069686,28067805:carton:4230:28069478,28067808:carton:4230:28069250,28067811:carton:4230:28069205,28067814:carton:4230:28069171,28067816:carton:4230:28069109,28067819:carton:4230:28069090,28067822:carton:4230:28070749,28067825:carton:4230:28068883,28067827:carton:4230:28068851,28067830:carton:4230:28068698,28067832:carton:4230:28068659,28067835:carton:4230:28068473,28067838:carton:4230:28068427,28067840:carton:4230:28068512,28067843:carton:4230:28068354,28067845:carton:4230:28068246,28067848:carton:4230:28068149,28067850:carton:4230:28068123,28067853:carton:4230:28068082,28067855:carton:4230:28067981,28069319:carton:4230:28070205,28070473:carton:4230:28070576,28075152:carton:4230:28075251,28075322:carton:4230:28076008,28075325:carton:4230:28077410,28075328:carton:4230:28077330,28075331:carton:4230:28076120,28075334:carton:4230:28076084,28075337:carton:4230:28077241,28075340:carton:4230:28077174,28075342:carton:4230:28077149,28075344:carton:4230:28075752,2807'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014854814712516597, 'nb_photo': 1744, 'list_port_cont': '28067550,28067991,28068067,28068118,28068157,28068250,28068363,28068435,28068472,28068505,28068644,28068694,28068852,28068885,28069092,28069105,28069160,28069219,28069479,28069694,28070195,28070572,28070748,28075249,28075412,28075440,28075517,28075555,28075589,28075631,28075668,28075737,28075773,28075817,28075999,28076083,28076105,28076794,28077022,28077059,28077151,28077173,28077216,28077233,28077327,28077396,28078201,28120243,28120421,28120946,28120984,28122154,28122363,28122552,28123278,28123662,28124005,28124415,28124476,28124564,28124789,28125050,28125213,28126478,28127155,28127517,28128916,28131855,28134470,28135798,28138547,28180326,28182261,28182656,28182701,28182889,28183074,28183197,28183266,28183494,28183587,28183722,28183849,28183906,28184083,28184198,28184331,28184379,28184412,28184470,28184554,28185796,28186435,28186523,28186997,28230408,28230468,28230653,28230713,28230777,28231085,28231430,28231523,28231619,28231725,28232285,28232400,28232587,28232955,28233389,28233588,28234013,28234166,2823435', 'assoc_port': '28067357:28067550,28067802:28069694,28067805:28069479,28067811:28069219,28067814:28069160,28067816:28069105,28067819:28069092,28067822:28070748,28067825:28068885,28067827:28068852,28067830:28068694,28067832:28068644,28067835:28068472,28067838:28068435,28067840:28068505,28067843:28068363,28067845:28068250,28067848:28068157,28067850:28068118,28067853:28068067,28067855:28067991,28069319:28070195,28070473:28070572,28075152:28075249,28075322:28075999,28075325:28077396,28075328:28077327,28075331:28076105,28075334:28076083,28075337:28077233,28075340:28077173,28075342:28077151,28075344:28075737,28075346:28075668,28075348:28075817,28075351:28075773,28075352:28075517,28075354:28077059,28075355:28075555,28075356:28077216,28075357:28075631,28075358:28075412,28075359:28075440,28075360:28078201,28075361:28075589,28076697:28076794,28076881:28077022,28119040:28125213,28119042:28127155,28119045:28125050,28119048:28128916,28119051:28123662,28119054:28123278,28119058:28134470,28119062:28127517,28119065:28122552,28119085:2812236', 'assoc_mat': '28067357:metal:4230:28067550,28067802:metal:4230:28069694,28067805:metal:4230:28069479,28067811:metal:4230:28069219,28067814:metal:4230:28069160,28067816:metal:4230:28069105,28067819:metal:4230:28069092,28067822:metal:4230:28070748,28067825:metal:4230:28068885,28067827:metal:4230:28068852,28067830:metal:4230:28068694,28067832:metal:4230:28068644,28067835:metal:4230:28068472,28067838:metal:4230:28068435,28067840:metal:4230:28068505,28067843:metal:4230:28068363,28067845:metal:4230:28068250,28067848:metal:4230:28068157,28067850:metal:4230:28068118,28067853:metal:4230:28068067,28067855:metal:4230:28067991,28069319:metal:4230:28070195,28070473:metal:4230:28070572,28075152:metal:4230:28075249,28075322:metal:4230:28075999,28075325:metal:4230:28077396,28075328:metal:4230:28077327,28075331:metal:4230:28076105,28075334:metal:4230:28076083,28075337:metal:4230:28077233,28075340:metal:4230:28077173,28075342:metal:4230:28077151,28075344:metal:4230:28075737,28075346:metal:4230:28075668,28075348:metal:4230:28075817,28075351:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.2692321085074215, 'nb_photo': 363365, 'list_port_cont': '28067555,28067979,28068070,28068115,28068159,28068258,28068357,28068428,28068471,28068518,28068650,28068705,28068842,28068888,28069097,28069113,28069173,28069215,28069255,28069468,28069693,28070206,28070575,28070745,28075252,28075418,28075450,28075527,28075561,28075598,28075641,28075678,28075754,28075786,28075813,28076005,28076076,28076114,28076797,28077010,28077072,28077139,28077181,28077221,28077232,28077328,28077408,28078195,28120255,28120426,28120960,28120998,28122153,28122365,28122548,28123288,28123656,28124006,28124422,28124482,28124562,28124791,28125055,28125225,28126494,28127162,28127530,28128931,28131854,28134468,28135809,28138538,28180343,28182273,28182664,28182695,28182898,28183083,28183200,28183260,28183496,28183581,28183734,28183836,28183920,28184094,28184211,28184343,28184389,28184422,28184482,28184557,28185793,28186441,28186534,28187006,28230417,28230477,28230644,28230729,28230782,28231081,28231434,28231526,28231620,28231741,28232290,28232402,28232579,28232962,28233392,28233600,28234023,2823417', 'assoc_port': '28067357:28067555,28067802:28069693,28067805:28069468,28067808:28069255,28067811:28069215,28067814:28069173,28067816:28069113,28067819:28069097,28067822:28070745,28067825:28068888,28067827:28068842,28067830:28068705,28067832:28068650,28067835:28068471,28067838:28068428,28067840:28068518,28067843:28068357,28067845:28068258,28067848:28068159,28067850:28068115,28067853:28068070,28067855:28067979,28069319:28070206,28070473:28070575,28075152:28075252,28075322:28076005,28075325:28077408,28075328:28077328,28075331:28076114,28075334:28076076,28075337:28077232,28075340:28077181,28075342:28077139,28075344:28075754,28075346:28075678,28075348:28075813,28075351:28075786,28075352:28075527,28075354:28077072,28075355:28075561,28075356:28077221,28075357:28075641,28075358:28075418,28075359:28075450,28075360:28078195,28075361:28075598,28076697:28076797,28076881:28077010,28119040:28125225,28119042:28127162,28119045:28125055,28119048:28128931,28119051:28123656,28119054:28123288,28119058:28134468,28119062:28127530,28119065:2812254', 'assoc_mat': '28067357:papier:4230:28067555,28067802:papier:4230:28069693,28067805:papier:4230:28069468,28067808:papier:4230:28069255,28067811:papier:4230:28069215,28067814:papier:4230:28069173,28067816:papier:4230:28069113,28067819:papier:4230:28069097,28067822:papier:4230:28070745,28067825:papier:4230:28068888,28067827:papier:4230:28068842,28067830:papier:4230:28068705,28067832:papier:4230:28068650,28067835:papier:4230:28068471,28067838:papier:4230:28068428,28067840:papier:4230:28068518,28067843:papier:4230:28068357,28067845:papier:4230:28068258,28067848:papier:4230:28068159,28067850:papier:4230:28068115,28067853:papier:4230:28068070,28067855:papier:4230:28067979,28069319:papier:4230:28070206,28070473:papier:4230:28070575,28075152:papier:4230:28075252,28075322:papier:4230:28076005,28075325:papier:4230:28077408,28075328:papier:4230:28077328,28075331:papier:4230:28076114,28075334:papier:4230:28076076,28075337:papier:4230:28077232,28075340:papier:4230:28077181,28075342:papier:4230:28077139,28075344:papier:4230:28075754,2807'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006159889349602773, 'nb_photo': 4171, 'list_port_cont': '28067548,28067990,28068073,28068109,28068156,28068256,28068360,28068431,28068474,28068510,28068655,28068701,28068846,28068889,28069094,28069107,28069174,28069217,28069257,28069480,28069688,28070208,28070567,28070750,28075247,28075407,28075451,28075529,28075569,28075606,28075636,28075667,28075746,28075788,28075827,28076004,28076079,28076113,28076795,28077019,28077074,28077144,28077186,28077218,28077228,28077329,28077409,28078203,28120256,28120425,28120951,28120999,28122155,28122351,28122557,28123284,28123659,28123995,28124416,28124481,28124567,28124788,28125046,28125216,28126491,28127157,28127527,28128932,28131866,28134463,28135810,28138544,28180340,28182275,28182665,28182691,28182899,28183077,28183212,28183269,28183487,28183588,28183733,28183841,28183919,28184095,28184197,28184338,28184384,28184420,28184477,28184560,28185794,28186444,28186539,28187014,28230414,28230474,28230654,28230720,28230771,28231078,28231443,28231527,28231626,28231732,28232297,28232399,28232591,28232966,28233385,28233597,28234014,2823416', 'assoc_port': '28067357:28067548,28067802:28069688,28067805:28069480,28067808:28069257,28067811:28069217,28067814:28069174,28067816:28069107,28067819:28069094,28067822:28070750,28067825:28068889,28067827:28068846,28067830:28068701,28067832:28068655,28067835:28068474,28067838:28068431,28067840:28068510,28067843:28068360,28067845:28068256,28067848:28068156,28067850:28068109,28067853:28068073,28067855:28067990,28069319:28070208,28070473:28070567,28075152:28075247,28075322:28076004,28075325:28077409,28075328:28077329,28075331:28076113,28075334:28076079,28075337:28077228,28075340:28077186,28075342:28077144,28075344:28075746,28075346:28075667,28075348:28075827,28075351:28075788,28075352:28075529,28075354:28077074,28075355:28075569,28075356:28077218,28075357:28075636,28075358:28075407,28075359:28075451,28075360:28078203,28075361:28075606,28076697:28076795,28076881:28077019,28119040:28125216,28119042:28127157,28119045:28125046,28119048:28128932,28119051:28123659,28119054:28123284,28119058:28134463,28119062:28127527,28119065:2812255', 'assoc_mat': '28067357:pehd:4230:28067548,28067802:pehd:4230:28069688,28067805:pehd:4230:28069480,28067808:pehd:4230:28069257,28067811:pehd:4230:28069217,28067814:pehd:4230:28069174,28067816:pehd:4230:28069107,28067819:pehd:4230:28069094,28067822:pehd:4230:28070750,28067825:pehd:4230:28068889,28067827:pehd:4230:28068846,28067830:pehd:4230:28068701,28067832:pehd:4230:28068655,28067835:pehd:4230:28068474,28067838:pehd:4230:28068431,28067840:pehd:4230:28068510,28067843:pehd:4230:28068360,28067845:pehd:4230:28068256,28067848:pehd:4230:28068156,28067850:pehd:4230:28068109,28067853:pehd:4230:28068073,28067855:pehd:4230:28067990,28069319:pehd:4230:28070208,28070473:pehd:4230:28070567,28075152:pehd:4230:28075247,28075322:pehd:4230:28076004,28075325:pehd:4230:28077409,28075328:pehd:4230:28077329,28075331:pehd:4230:28076113,28075334:pehd:4230:28076079,28075337:pehd:4230:28077228,28075340:pehd:4230:28077186,28075342:pehd:4230:28077144,28075344:pehd:4230:28075746,28075346:pehd:4230:28075667,28075348:pehd:4230:28075827,28075351:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012522325149416496, 'nb_photo': 23842, 'list_port_cont': '28067554,28067976,28068068,28068121,28068155,28068260,28068364,28068433,28068469,28068511,28068647,28068706,28068837,28068878,28069096,28069114,28069170,28069220,28069245,28069469,28069690,28070202,28070577,28070738,28075250,28075420,28075447,28075528,28075559,28075600,28075638,28075679,28075749,28075777,28075825,28076009,28076075,28076118,28076788,28077023,28077069,28077146,28077184,28077208,28077229,28077332,28077404,28078207,28120250,28120423,28120957,28120986,28122159,28122364,28122563,28123285,28123658,28123997,28124424,28124477,28124565,28124790,28125053,28125228,28126483,28127164,28127524,28128925,28131864,28134469,28135808,28138540,28180335,28182276,28182662,28182692,28182904,28183068,28183209,28183267,28183485,28183584,28183739,28183846,28183916,28184090,28184195,28184333,28184386,28184425,28184480,28184555,28185787,28186440,28186538,28187011,28230403,28230462,28230649,28230721,28230784,28231082,28231433,28231521,28231614,28231737,28232289,28232396,28232578,28232971,28233393,28233592,28234022,2823416', 'assoc_port': '28067357:28067554,28067802:28069690,28067805:28069469,28067808:28069245,28067811:28069220,28067814:28069170,28067816:28069114,28067819:28069096,28067822:28070738,28067825:28068878,28067827:28068837,28067830:28068706,28067832:28068647,28067835:28068469,28067838:28068433,28067840:28068511,28067843:28068364,28067845:28068260,28067848:28068155,28067850:28068121,28067853:28068068,28067855:28067976,28069319:28070202,28070473:28070577,28075152:28075250,28075322:28076009,28075325:28077404,28075328:28077332,28075331:28076118,28075334:28076075,28075337:28077229,28075340:28077184,28075342:28077146,28075344:28075749,28075346:28075679,28075348:28075825,28075351:28075777,28075352:28075528,28075354:28077069,28075355:28075559,28075356:28077208,28075357:28075638,28075358:28075420,28075359:28075447,28075360:28078207,28075361:28075600,28076697:28076788,28076881:28077023,28119040:28125228,28119042:28127164,28119045:28125053,28119048:28128925,28119051:28123658,28119054:28123285,28119058:28134469,28119062:28127524,28119065:2812256', 'assoc_mat': '28067357:pet_clair:4230:28067554,28067802:pet_clair:4230:28069690,28067805:pet_clair:4230:28069469,28067808:pet_clair:4230:28069245,28067811:pet_clair:4230:28069220,28067814:pet_clair:4230:28069170,28067816:pet_clair:4230:28069114,28067819:pet_clair:4230:28069096,28067822:pet_clair:4230:28070738,28067825:pet_clair:4230:28068878,28067827:pet_clair:4230:28068837,28067830:pet_clair:4230:28068706,28067832:pet_clair:4230:28068647,28067835:pet_clair:4230:28068469,28067838:pet_clair:4230:28068433,28067840:pet_clair:4230:28068511,28067843:pet_clair:4230:28068364,28067845:pet_clair:4230:28068260,28067848:pet_clair:4230:28068155,28067850:pet_clair:4230:28068121,28067853:pet_clair:4230:28068068,28067855:pet_clair:4230:28067976,28069319:pet_clair:4230:28070202,28070473:pet_clair:4230:28070577,28075152:pet_clair:4230:28075250,28075322:pet_clair:4230:28076009,28075325:pet_clair:4230:28077404,28075328:pet_clair:4230:28077332,28075331:pet_clair:4230:28076118,28075334:pet_clair:4230:28076075,28075337:pet_clair:4230:28077229,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006066505030584147, 'nb_photo': 1607, 'list_port_cont': '28067561,28067986,28068079,28068358,28068429,28068461,28068517,28068656,28068695,28068844,28068886,28069093,28069115,28069164,28069218,28069253,28069698,28070200,28070566,28070753,28075238,28075415,28075446,28075519,28075568,28075593,28075644,28075680,28075751,28075780,28075818,28076001,28076081,28076116,28076796,28077013,28077073,28077145,28077183,28077220,28077234,28077334,28077402,28078208,28120251,28120403,28120955,28120997,28122158,28122362,28122550,28123281,28123664,28124003,28124414,28124485,28124568,28124783,28125054,28125223,28126487,28127163,28127529,28128930,28131865,28134473,28135811,28138552,28180332,28182267,28182704,28182896,28183082,28183265,28183483,28183577,28183729,28183838,28183917,28184096,28184200,28184334,28184378,28184427,28184481,28185797,28186439,28186540,28187007,28230413,28230475,28230642,28230730,28230783,28231087,28231440,28231520,28231621,28231733,28232293,28232391,28232583,28232969,28233397,28233595,28234020,28234357,28234421,28235215,28235433,28285288,28289698,28290024,2829141', 'assoc_port': '28067357:28067561,28067802:28069698,28067808:28069253,28067811:28069218,28067814:28069164,28067816:28069115,28067819:28069093,28067822:28070753,28067825:28068886,28067827:28068844,28067830:28068695,28067832:28068656,28067835:28068461,28067838:28068429,28067840:28068517,28067843:28068358,28067853:28068079,28067855:28067986,28069319:28070200,28070473:28070566,28075152:28075238,28075322:28076001,28075325:28077402,28075328:28077334,28075331:28076116,28075334:28076081,28075337:28077234,28075340:28077183,28075342:28077145,28075344:28075751,28075346:28075680,28075348:28075818,28075351:28075780,28075352:28075519,28075354:28077073,28075355:28075568,28075356:28077220,28075357:28075644,28075358:28075415,28075359:28075446,28075360:28078208,28075361:28075593,28076697:28076796,28076881:28077013,28119040:28125223,28119042:28127163,28119045:28125054,28119048:28128930,28119051:28123664,28119054:28123281,28119058:28134473,28119062:28127529,28119065:28122550,28119085:28122362,28119088:28131865,28119113:28122158,28119126:2812099', 'assoc_mat': '28067357:pet_fonce:4230:28067561,28067802:pet_fonce:4230:28069698,28067808:pet_fonce:4230:28069253,28067811:pet_fonce:4230:28069218,28067814:pet_fonce:4230:28069164,28067816:pet_fonce:4230:28069115,28067819:pet_fonce:4230:28069093,28067822:pet_fonce:4230:28070753,28067825:pet_fonce:4230:28068886,28067827:pet_fonce:4230:28068844,28067830:pet_fonce:4230:28068695,28067832:pet_fonce:4230:28068656,28067835:pet_fonce:4230:28068461,28067838:pet_fonce:4230:28068429,28067840:pet_fonce:4230:28068517,28067843:pet_fonce:4230:28068358,28067853:pet_fonce:4230:28068079,28067855:pet_fonce:4230:28067986,28069319:pet_fonce:4230:28070200,28070473:pet_fonce:4230:28070566,28075152:pet_fonce:4230:28075238,28075322:pet_fonce:4230:28076001,28075325:pet_fonce:4230:28077402,28075328:pet_fonce:4230:28077334,28075331:pet_fonce:4230:28076116,28075334:pet_fonce:4230:28076081,28075337:pet_fonce:4230:28077234,28075340:pet_fonce:4230:28077183,28075342:pet_fonce:4230:28077145,28075344:pet_fonce:4230:28075751,28075346:pet_fonce:4230:28075680,2'}), 'main_stat': {'nb_photos': 1803}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-11', 0.6273057922567403),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_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', '2.13%', 19245], 'carton': ['carton', '11.1%', 128597], 'metal': ['metal', '0.15%', 1744], 'papier': ['papier', '26.92%', 363365], 'pehd': ['pehd', '0.62%', 4171], 'pet_clair': ['pet_clair', '1.25%', 23842], 'pet_fonce': ['pet_fonce', '0.61%', 1607]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_11_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.34user 2.06system 0:07.04elapsed 62%CPU (0avgtext+0avgdata 176748maxresident)k 17192inputs+280outputs (158major+45112minor)pagefaults 0swaps