python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-08 _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 : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 08 mtr_id : dashboard_places : SCCU_cam6 date : 2025-08 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2025-08%') and created_at like '%2025-08%'))); nb_day : (4, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 08 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 08 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%082025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-08-01 : dt_date_just_month_year : 2025-08-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-08-01" AND ded.date <= "2025-08-31" 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 (2056919,2061675,2062291,2069409,2077251,2084725,2092451,2099713,2103945,2104513,2111943,2119831,2121851,2129599,2136743,2140387,2147841,2154195,2161063,2166121,2170031,2174071,2174711,2180791,2187777,2194891,2201509,2208133,2212791,2213805) 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.01120596275990249, 'nb_photo': 21327, 'list_port_cont': '25592873,25593635,25593723,25593827,25593913,25593968,25594027,25594072,25594178,25594201,25594313,25594340,25596286,25596353,25596556,25598039,25599046,25599194,25599457,25599877,25602263,25603661,25603758,25603792,25614840,25614940,25615145,25615267,25615644,25615994,25616180,25616330,25616568,25616602,25616651,25616706,25616746,25616768,25616893,25616915,25616954,25617003,25617037,25617074,25617099,25617151,25617287,25617369,25622797,25622924,25622948,25622999,25623020,25623064,25623088,25623182,25623210,25623252,25623259,25623282,25623349,25623385,25623494,25623531,25623570,25623625,25623674,25623897,25624052,25624375,25624578,25625842,25626033,25626152,25626333,25626467,25626607,25627600,25628787,25629851,25631774,25633289,25635498,25636858,25638154,25639072,25640268,25641116,25642758,25644423,25646088,25648261,25650201,25651467,25654280,25656710,25703869,25703955,25703991,25704194,25704251,25704329,25704401,25704428,25704470,25704527,25704561,25704586,25704671,25704717,25704781,25704830,25704898,2570493', 'assoc_port': '25592799:25594313,25592800:25594201,25592801:25599457,25592802:25594178,25592803:25596556,25592804:25603792,25592805:25594027,25592807:25594340,25592809:25596353,25592811:25603758,25592814:25594072,25592817:25593968,25592819:25602263,25592822:25599194,25592825:25593827,25592827:25603661,25592829:25593913,25592832:25593723,25592834:25596286,25592835:25592873,25592838:25599046,25592839:25593635,25594538:25599877,25595244:25598039,25614542:25614840,25614543:25614940,25614544:25615145,25614545:25615267,25614546:25617151,25614547:25615644,25614548:25617369,25614549:25615994,25614551:25616180,25614552:25616330,25614554:25616602,25614556:25616746,25614557:25616954,25614560:25617074,25614562:25617037,25614564:25617003,25614567:25616915,25614569:25617099,25614571:25616568,25614575:25616706,25614577:25616893,25614579:25616651,25616549:25616768,25617205:25617287,25621898:25624052,25621900:25625842,25621901:25623897,25621903:25623674,25621905:25623494,25621907:25623531,25621909:25623570,25621911:25623385,25621913:2562362', 'assoc_mat': '25592799:autre:4230:25594313,25592800:autre:4230:25594201,25592801:autre:4230:25599457,25592802:autre:4230:25594178,25592803:autre:4230:25596556,25592804:autre:4230:25603792,25592805:autre:4230:25594027,25592807:autre:4230:25594340,25592809:autre:4230:25596353,25592811:autre:4230:25603758,25592814:autre:4230:25594072,25592817:autre:4230:25593968,25592819:autre:4230:25602263,25592822:autre:4230:25599194,25592825:autre:4230:25593827,25592827:autre:4230:25603661,25592829:autre:4230:25593913,25592832:autre:4230:25593723,25592834:autre:4230:25596286,25592835:autre:4230:25592873,25592838:autre:4230:25599046,25592839:autre:4230:25593635,25594538:autre:4230:25599877,25595244:autre:4230:25598039,25614542:autre:4230:25614840,25614543:autre:4230:25614940,25614544:autre:4230:25615145,25614545:autre:4230:25615267,25614546:autre:4230:25617151,25614547:autre:4230:25615644,25614548:autre:4230:25617369,25614549:autre:4230:25615994,25614551:autre:4230:25616180,25614552:autre:4230:25616330,25614554:autre:4230:25616602,25614556:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04663817603453066, 'nb_photo': 104338, 'list_port_cont': '25592885,25593639,25593735,25593835,25593905,25593985,25594038,25594080,25594173,25594200,25594304,25594347,25596298,25596364,25596568,25598042,25599044,25599192,25599452,25599875,25602277,25603663,25603752,25603795,25614836,25614944,25615135,25615264,25615654,25616002,25616175,25616332,25616573,25616613,25616642,25616701,25616745,25616775,25616885,25616931,25616964,25617005,25617030,25617067,25617110,25617163,25617301,25617370,25622792,25622915,25622965,25622997,25623035,25623073,25623091,25623181,25623215,25623242,25623272,25623284,25623354,25623399,25623498,25623537,25623579,25623642,25623691,25623901,25624042,25624373,25624576,25625849,25626042,25626148,25626330,25626472,25626613,25627590,25628791,25629847,25631785,25633296,25635501,25636846,25638159,25639088,25640271,25641124,25642757,25644429,25646095,25648259,25650218,25651468,25654271,25656705,25703875,25703968,25704004,25704190,25704257,25704335,25704397,25704442,25704482,25704516,25704560,25704594,25704673,25704710,25704796,25704835,25704901,2570493', 'assoc_port': '25592799:25594304,25592800:25594200,25592801:25599452,25592802:25594173,25592803:25596568,25592804:25603795,25592805:25594038,25592807:25594347,25592809:25596364,25592811:25603752,25592814:25594080,25592817:25593985,25592819:25602277,25592822:25599192,25592825:25593835,25592827:25603663,25592829:25593905,25592832:25593735,25592834:25596298,25592835:25592885,25592838:25599044,25592839:25593639,25594538:25599875,25595244:25598042,25614542:25614836,25614543:25614944,25614544:25615135,25614545:25615264,25614546:25617163,25614547:25615654,25614548:25617370,25614549:25616002,25614551:25616175,25614552:25616332,25614554:25616613,25614556:25616745,25614557:25616964,25614560:25617067,25614562:25617030,25614564:25617005,25614567:25616931,25614569:25617110,25614571:25616573,25614575:25616701,25614577:25616885,25614579:25616642,25616549:25616775,25617205:25617301,25621898:25624042,25621900:25625849,25621901:25623901,25621903:25623691,25621905:25623498,25621907:25623537,25621909:25623579,25621911:25623399,25621913:2562364', 'assoc_mat': '25592799:carton:4230:25594304,25592800:carton:4230:25594200,25592801:carton:4230:25599452,25592802:carton:4230:25594173,25592803:carton:4230:25596568,25592804:carton:4230:25603795,25592805:carton:4230:25594038,25592807:carton:4230:25594347,25592809:carton:4230:25596364,25592811:carton:4230:25603752,25592814:carton:4230:25594080,25592817:carton:4230:25593985,25592819:carton:4230:25602277,25592822:carton:4230:25599192,25592825:carton:4230:25593835,25592827:carton:4230:25603663,25592829:carton:4230:25593905,25592832:carton:4230:25593735,25592834:carton:4230:25596298,25592835:carton:4230:25592885,25592838:carton:4230:25599044,25592839:carton:4230:25593639,25594538:carton:4230:25599875,25595244:carton:4230:25598042,25614542:carton:4230:25614836,25614543:carton:4230:25614944,25614544:carton:4230:25615135,25614545:carton:4230:25615264,25614546:carton:4230:25617163,25614547:carton:4230:25615654,25614548:carton:4230:25617370,25614549:carton:4230:25616002,25614551:carton:4230:25616175,25614552:carton:4230:25616332,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001093980305136697, 'nb_photo': 2019, 'list_port_cont': '25593738,25593832,25593910,25594025,25594077,25594169,25594184,25594311,25594338,25596297,25596360,25596562,25598036,25599037,25599191,25599440,25602269,25603668,25603751,25614837,25614946,25615132,25615254,25615651,25615991,25616567,25616646,25616699,25616742,25616772,25616881,25616922,25616952,25616991,25617063,25617108,25617303,25617357,25622960,25623060,25623179,25623250,25623530,25623646,25623898,25624054,25624361,25624575,25625850,25626328,25626462,25626622,25628795,25629856,25631784,25633297,25635490,25636849,25638167,25639082,25640273,25641123,25642764,25644412,25646084,25648252,25650202,25651458,25654276,25656694,25703868,25703990,25704195,25704253,25704393,25704431,25704520,25704555,25704674,25704711,25704942,25704992,25705051,25705180,25705925,25706930,25746309,25746473,25746719,25747058,25747176,25747528,25747611,25748064,25748490,25748766,25749065,25749292,25749389,25749488,25749714,25750026,25750097,25750462,25750804,25750879,25751431,25795137,25796431,25798636,25798683,25798724,25798784,2579884', 'assoc_port': '25592799:25594311,25592800:25594184,25592801:25599440,25592802:25594169,25592803:25596562,25592805:25594025,25592807:25594338,25592809:25596360,25592811:25603751,25592814:25594077,25592819:25602269,25592822:25599191,25592825:25593832,25592827:25603668,25592829:25593910,25592832:25593738,25592834:25596297,25592838:25599037,25595244:25598036,25614542:25614837,25614543:25614946,25614544:25615132,25614545:25615254,25614547:25615651,25614548:25617357,25614549:25615991,25614556:25616742,25614557:25616952,25614560:25617063,25614564:25616991,25614567:25616922,25614569:25617108,25614571:25616567,25614575:25616699,25614577:25616881,25614579:25616646,25616549:25616772,25617205:25617303,25621898:25624054,25621900:25625850,25621901:25623898,25621907:25623530,25621913:25623646,25621917:25623250,25621930:25623179,25621934:25623060,25621944:25622960,25624330:25624361,25624472:25624575,25626273:25626328,25626417:25626462,25626564:25626622,25628503:25628795,25629687:25629856,25631607:25631784,25633146:25633297,25634837:2563549', 'assoc_mat': '25592799:metal:4230:25594311,25592800:metal:4230:25594184,25592801:metal:4230:25599440,25592802:metal:4230:25594169,25592803:metal:4230:25596562,25592805:metal:4230:25594025,25592807:metal:4230:25594338,25592809:metal:4230:25596360,25592811:metal:4230:25603751,25592814:metal:4230:25594077,25592819:metal:4230:25602269,25592822:metal:4230:25599191,25592825:metal:4230:25593832,25592827:metal:4230:25603668,25592829:metal:4230:25593910,25592832:metal:4230:25593738,25592834:metal:4230:25596297,25592838:metal:4230:25599037,25595244:metal:4230:25598036,25614542:metal:4230:25614837,25614543:metal:4230:25614946,25614544:metal:4230:25615132,25614545:metal:4230:25615254,25614547:metal:4230:25615651,25614548:metal:4230:25617357,25614549:metal:4230:25615991,25614556:metal:4230:25616742,25614557:metal:4230:25616952,25614560:metal:4230:25617063,25614564:metal:4230:25616991,25614567:metal:4230:25616922,25614569:metal:4230:25617108,25614571:metal:4230:25616567,25614575:metal:4230:25616699,25614577:metal:4230:25616881,25614579:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19282201773440044, 'nb_photo': 571078, 'list_port_cont': '25592888,25593647,25593728,25593823,25593907,25593983,25594041,25594076,25594175,25594198,25594314,25594348,25596296,25596365,25596566,25598041,25599038,25599184,25599456,25599884,25602280,25603670,25603748,25603791,25614830,25614955,25615142,25615259,25615648,25616008,25616187,25616331,25616566,25616606,25616650,25616700,25616749,25616784,25616890,25616929,25616966,25616997,25617034,25617080,25617112,25617156,25617298,25617372,25622801,25622925,25622957,25623001,25623033,25623071,25623084,25623174,25623214,25623249,25623264,25623286,25623363,25623395,25623495,25623545,25623582,25623626,25623685,25623899,25624048,25624379,25624577,25625855,25626035,25626147,25626326,25626473,25626610,25627592,25628798,25629846,25631791,25633287,25635489,25636853,25638156,25639087,25640267,25641122,25642767,25644422,25646086,25648250,25650209,25651471,25654274,25656706,25703873,25703970,25704003,25704183,25704261,25704328,25704394,25704438,25704477,25704530,25704564,25704595,25704681,25704705,25704787,25704828,25704897,2570494', 'assoc_port': '25592799:25594314,25592800:25594198,25592801:25599456,25592802:25594175,25592803:25596566,25592804:25603791,25592805:25594041,25592807:25594348,25592809:25596365,25592811:25603748,25592814:25594076,25592817:25593983,25592819:25602280,25592822:25599184,25592825:25593823,25592827:25603670,25592829:25593907,25592832:25593728,25592834:25596296,25592835:25592888,25592838:25599038,25592839:25593647,25594538:25599884,25595244:25598041,25614542:25614830,25614543:25614955,25614544:25615142,25614545:25615259,25614546:25617156,25614547:25615648,25614548:25617372,25614549:25616008,25614551:25616187,25614552:25616331,25614554:25616606,25614556:25616749,25614557:25616966,25614560:25617080,25614562:25617034,25614564:25616997,25614567:25616929,25614569:25617112,25614571:25616566,25614575:25616700,25614577:25616890,25614579:25616650,25616549:25616784,25617205:25617298,25621898:25624048,25621900:25625855,25621901:25623899,25621903:25623685,25621905:25623495,25621907:25623545,25621909:25623582,25621911:25623395,25621913:2562362', 'assoc_mat': '25592799:papier:4230:25594314,25592800:papier:4230:25594198,25592801:papier:4230:25599456,25592802:papier:4230:25594175,25592803:papier:4230:25596566,25592804:papier:4230:25603791,25592805:papier:4230:25594041,25592807:papier:4230:25594348,25592809:papier:4230:25596365,25592811:papier:4230:25603748,25592814:papier:4230:25594076,25592817:papier:4230:25593983,25592819:papier:4230:25602280,25592822:papier:4230:25599184,25592825:papier:4230:25593823,25592827:papier:4230:25603670,25592829:papier:4230:25593907,25592832:papier:4230:25593728,25592834:papier:4230:25596296,25592835:papier:4230:25592888,25592838:papier:4230:25599038,25592839:papier:4230:25593647,25594538:papier:4230:25599884,25595244:papier:4230:25598041,25614542:papier:4230:25614830,25614543:papier:4230:25614955,25614544:papier:4230:25615142,25614545:papier:4230:25615259,25614546:papier:4230:25617156,25614547:papier:4230:25615648,25614548:papier:4230:25617372,25614549:papier:4230:25616008,25614551:papier:4230:25616187,25614552:papier:4230:25616331,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003685300950621834, 'nb_photo': 2884, 'list_port_cont': '25592872,25593732,25593986,25594071,25596295,25596557,25599040,25602281,25603759,25603796,25614831,25616004,25616186,25616605,25616644,25616739,25616927,25616968,25617001,25617040,25617107,25617162,25617361,25623178,25623218,25623254,25623269,25623287,25623362,25623638,25628792,25631787,25635497,25636851,25638171,25640270,25641125,25642759,25644428,25646097,25654279,25703880,25704001,25704399,25704436,25704478,25704521,25704565,25704602,25704903,25706941,25746316,25747180,25747526,25747613,25747834,25748501,25748759,25749298,25749399,25750034,25750805,25795151,25796440,25798698,25798733,25798880,25798918,25798954,25798985,25799023,25799055,25799077,25799132,25799166,25799240,25799277,25799312,25799372,25799443,25799776,25808677,25810768,25811454,25811879,25812695,25814033,25814730,25816064,25817242,25818147,25818736,25820931,25823193,25824448,25828710,25828830,25829007,25829281,25829476,25830223,25830398,25830529,25831615,25831962,25839560,25839821,25840145,25841504,25842654,25843337,25844471,25845208,2584595', 'assoc_port': '25592803:25596557,25592804:25603796,25592811:25603759,25592814:25594071,25592817:25593986,25592819:25602281,25592832:25593732,25592834:25596295,25592835:25592872,25592838:25599040,25614542:25614831,25614546:25617162,25614548:25617361,25614549:25616004,25614551:25616186,25614554:25616605,25614556:25616739,25614557:25616968,25614562:25617040,25614564:25617001,25614567:25616927,25614569:25617107,25614579:25616644,25621913:25623638,25621915:25623362,25621917:25623254,25621920:25623218,25621924:25623269,25621927:25623287,25621930:25623178,25628503:25628792,25631607:25631787,25634837:25635497,25636691:25636851,25638080:25638171,25640096:25640270,25640961:25641125,25642659:25642759,25644311:25644428,25645929:25646097,25653969:25654279,25703777:25704903,25703784:25704602,25703785:25704565,25703787:25704478,25703788:25704399,25703789:25704436,25703790:25704521,25703792:25704001,25703795:25703880,25706893:25706941,25746133:25750805,25746149:25750034,25746152:25749298,25746155:25749399,25746158:25748759,25746162:2574850', 'assoc_mat': '25592803:pehd:4230:25596557,25592804:pehd:4230:25603796,25592811:pehd:4230:25603759,25592814:pehd:4230:25594071,25592817:pehd:4230:25593986,25592819:pehd:4230:25602281,25592832:pehd:4230:25593732,25592834:pehd:4230:25596295,25592835:pehd:4230:25592872,25592838:pehd:4230:25599040,25614542:pehd:4230:25614831,25614546:pehd:4230:25617162,25614548:pehd:4230:25617361,25614549:pehd:4230:25616004,25614551:pehd:4230:25616186,25614554:pehd:4230:25616605,25614556:pehd:4230:25616739,25614557:pehd:4230:25616968,25614562:pehd:4230:25617040,25614564:pehd:4230:25617001,25614567:pehd:4230:25616927,25614569:pehd:4230:25617107,25614579:pehd:4230:25616644,25621913:pehd:4230:25623638,25621915:pehd:4230:25623362,25621917:pehd:4230:25623254,25621920:pehd:4230:25623218,25621924:pehd:4230:25623269,25621927:pehd:4230:25623287,25621930:pehd:4230:25623178,25628503:pehd:4230:25628792,25631607:pehd:4230:25631787,25634837:pehd:4230:25635497,25636691:pehd:4230:25636851,25638080:pehd:4230:25638171,25640096:pehd:4230:25640270,25640961:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01644701299219006, 'nb_photo': 25540, 'list_port_cont': '25592883,25593645,25593739,25593834,25593911,25593984,25594029,25594068,25594174,25594197,25594308,25594342,25596291,25596366,25596570,25598035,25599045,25599197,25599446,25599882,25602272,25603671,25603754,25603789,25614833,25614956,25615140,25615261,25615653,25615995,25616176,25616334,25616576,25616607,25616649,25616705,25616743,25616780,25616888,25616918,25616961,25616995,25617031,25617078,25617115,25617161,25617304,25617367,25622800,25622920,25622953,25622989,25623036,25623066,25623092,25623177,25623205,25623255,25623271,25623291,25623358,25623390,25623507,25623540,25623583,25623630,25623690,25623906,25624050,25624377,25624570,25625847,25626031,25626151,25626322,25626471,25626618,25627599,25628785,25629857,25631790,25633302,25635496,25636852,25638169,25639089,25640275,25641126,25642761,25644424,25646087,25648253,25650210,25651462,25654275,25656709,25703870,25703971,25704002,25704188,25704262,25704333,25704398,25704432,25704481,25704524,25704563,25704600,25704672,25704716,25704792,25704834,25704911,2570494', 'assoc_port': '25592799:25594308,25592800:25594197,25592801:25599446,25592802:25594174,25592803:25596570,25592804:25603789,25592805:25594029,25592807:25594342,25592809:25596366,25592811:25603754,25592814:25594068,25592817:25593984,25592819:25602272,25592822:25599197,25592825:25593834,25592827:25603671,25592829:25593911,25592832:25593739,25592834:25596291,25592835:25592883,25592838:25599045,25592839:25593645,25594538:25599882,25595244:25598035,25614542:25614833,25614543:25614956,25614544:25615140,25614545:25615261,25614546:25617161,25614547:25615653,25614548:25617367,25614549:25615995,25614551:25616176,25614552:25616334,25614554:25616607,25614556:25616743,25614557:25616961,25614560:25617078,25614562:25617031,25614564:25616995,25614567:25616918,25614569:25617115,25614571:25616576,25614575:25616705,25614577:25616888,25614579:25616649,25616549:25616780,25617205:25617304,25621898:25624050,25621900:25625847,25621901:25623906,25621903:25623690,25621905:25623507,25621907:25623540,25621909:25623583,25621911:25623390,25621913:2562363', 'assoc_mat': '25592799:pet_clair:4230:25594308,25592800:pet_clair:4230:25594197,25592801:pet_clair:4230:25599446,25592802:pet_clair:4230:25594174,25592803:pet_clair:4230:25596570,25592804:pet_clair:4230:25603789,25592805:pet_clair:4230:25594029,25592807:pet_clair:4230:25594342,25592809:pet_clair:4230:25596366,25592811:pet_clair:4230:25603754,25592814:pet_clair:4230:25594068,25592817:pet_clair:4230:25593984,25592819:pet_clair:4230:25602272,25592822:pet_clair:4230:25599197,25592825:pet_clair:4230:25593834,25592827:pet_clair:4230:25603671,25592829:pet_clair:4230:25593911,25592832:pet_clair:4230:25593739,25592834:pet_clair:4230:25596291,25592835:pet_clair:4230:25592883,25592838:pet_clair:4230:25599045,25592839:pet_clair:4230:25593645,25594538:pet_clair:4230:25599882,25595244:pet_clair:4230:25598035,25614542:pet_clair:4230:25614833,25614543:pet_clair:4230:25614956,25614544:pet_clair:4230:25615140,25614545:pet_clair:4230:25615261,25614546:pet_clair:4230:25617161,25614547:pet_clair:4230:25615653,25614548:pet_clair:4230:25617367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002532351342047139, 'nb_photo': 1397, 'list_port_cont': '25593977,25594075,25594199,25594310,25596362,25598037,25599047,25603666,25603757,25616178,25616648,25616711,25616894,25616930,25616998,25617029,25617113,25622963,25623173,25623253,25623273,25623276,25623351,25623383,25623508,25623575,25623640,25628793,25635487,25641113,25642763,25644427,25646092,25648260,25650214,25651469,25654284,25656702,25703876,25703967,25704189,25704263,25704332,25704391,25704677,25704703,25704998,25705115,25705182,25746318,25746492,25746812,25747170,25747533,25747607,25747832,25748062,25748498,25748756,25749063,25749303,25749402,25750100,25751422,25795138,25796435,25798635,25798732,25798844,25798878,25798913,25798986,25799061,25799078,25799133,25799172,25799203,25799269,25799446,25808671,25810756,25811460,25811885,25812691,25814030,25814736,25816063,25817241,25818149,25818741,25820923,25823199,25828700,25828829,25829004,25829282,25829484,25830230,25830402,25831609,25839816,25840154,25841508,25842658,25843336,25844475,25845214,25845955,25846441,25847478,25848130,25848800,25849481,2585002', 'assoc_port': '25592799:25594310,25592800:25594199,25592809:25596362,25592811:25603757,25592814:25594075,25592817:25593977,25592827:25603666,25592838:25599047,25595244:25598037,25614551:25616178,25614562:25617029,25614564:25616998,25614567:25616930,25614569:25617113,25614575:25616711,25614577:25616894,25614579:25616648,25621905:25623508,25621909:25623575,25621911:25623383,25621913:25623640,25621915:25623351,25621917:25623253,25621924:25623273,25621927:25623276,25621930:25623173,25621944:25622963,25628503:25628793,25634837:25635487,25640961:25641113,25642659:25642763,25644311:25644427,25645929:25646092,25648063:25648260,25649922:25650214,25651303:25651469,25653969:25654284,25656628:25656702,25703760:25705182,25703764:25705115,25703770:25704998,25703780:25704677,25703782:25704703,25703788:25704391,25703791:25704332,25703793:25704189,25703794:25704263,25703795:25703876,25703796:25703967,25746138:25750100,25746152:25749303,25746155:25749402,25746158:25748756,25746162:25748498,25746165:25747832,25746168:25748062,25746172:2574760', 'assoc_mat': '25592799:pet_fonce:4230:25594310,25592800:pet_fonce:4230:25594199,25592809:pet_fonce:4230:25596362,25592811:pet_fonce:4230:25603757,25592814:pet_fonce:4230:25594075,25592817:pet_fonce:4230:25593977,25592827:pet_fonce:4230:25603666,25592838:pet_fonce:4230:25599047,25595244:pet_fonce:4230:25598037,25614551:pet_fonce:4230:25616178,25614562:pet_fonce:4230:25617029,25614564:pet_fonce:4230:25616998,25614567:pet_fonce:4230:25616930,25614569:pet_fonce:4230:25617113,25614575:pet_fonce:4230:25616711,25614577:pet_fonce:4230:25616894,25614579:pet_fonce:4230:25616648,25621905:pet_fonce:4230:25623508,25621909:pet_fonce:4230:25623575,25621911:pet_fonce:4230:25623383,25621913:pet_fonce:4230:25623640,25621915:pet_fonce:4230:25623351,25621917:pet_fonce:4230:25623253,25621924:pet_fonce:4230:25623273,25621927:pet_fonce:4230:25623276,25621930:pet_fonce:4230:25623173,25621944:pet_fonce:4230:25622963,25628503:pet_fonce:4230:25628793,25634837:pet_fonce:4230:25635487,25640961:pet_fonce:4230:25641113,25642659:pet_fonce:4230:25642763,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(2056919,2061675,2062291,2069409,2077251,2084725,2092451,2099713,2103945,2104513,2111943,2119831,2121851,2129599,2136743,2140387,2147841,2154195,2161063,2166121,2170031,2174071,2174711,2180791,2187777,2194891,2201509,2208133,2212791,2213805)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-08-01' and date <= '2025-08-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2543,),), 'unwanted_material_monthly_percentage': ((0.7646241383655079,),), 'material_repartition': (('incineration', 2543),), 'material_dict': {'incineration': 2543}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 8, 1), 0.861625514580672, 4), (datetime.date(2025, 8, 2), 0.8463428309342617, 4), (datetime.date(2025, 8, 3), 0.8904179913351169, 4), (datetime.date(2025, 8, 4), 0.888873202462103, 2), (datetime.date(2025, 8, 5), 0.8817449969052896, 4), (datetime.date(2025, 8, 6), 0.8453763768284184, 3), (datetime.date(2025, 8, 7), 0.7816527405317729, 2), (datetime.date(2025, 8, 8), 0.6554975089575862, 4), (datetime.date(2025, 8, 9), 0.6403654108004194, 3), (datetime.date(2025, 8, 10), 0.741831939484227, 4), (datetime.date(2025, 8, 11), 0.7800465714717904, 3), (datetime.date(2025, 8, 12), 0.7402431376932599, 4), (datetime.date(2025, 8, 13), 0.7131844548905044, 4), (datetime.date(2025, 8, 14), 0.6924461388844759, 4), (datetime.date(2025, 8, 15), 0.7232747295621726, 3), (datetime.date(2025, 8, 16), 0.6456039778168489, 4), (datetime.date(2025, 8, 17), 0.791834694591449, 1), (datetime.date(2025, 8, 19), 0.7833822527589699, 1), (datetime.date(2025, 8, 20), 0.7423301274217097, 4), (datetime.date(2025, 8, 21), 0.7264960405685891, 4), (datetime.date(2025, 8, 22), 0.7017992939901415, 4), (datetime.date(2025, 8, 23), 0.6823161017233729, 4), (datetime.date(2025, 8, 24), 0.7731531415182563, 4), (datetime.date(2025, 8, 25), 0.8115594118915862, 4), (datetime.date(2025, 8, 26), 0.7971553429330455, 4), (datetime.date(2025, 8, 27), 0.7832335914678837, 4), (datetime.date(2025, 8, 28), 0.7928079444948148, 4), (datetime.date(2025, 8, 29), 0.7813071477380323, 4), (datetime.date(2025, 8, 30), 0.6861895395445701, 4), (datetime.date(2025, 8, 31), 0.7631466018656438, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 8, 1), 0.861625514580672, 4), (datetime.date(2025, 8, 2), 0.8463428309342617, 4), (datetime.date(2025, 8, 3), 0.8904179913351169, 4), (datetime.date(2025, 8, 4), 0.888873202462103, 2), (datetime.date(2025, 8, 5), 0.8817449969052896, 4), (datetime.date(2025, 8, 6), 0.8453763768284184, 3), (datetime.date(2025, 8, 7), 0.7816527405317729, 2), (datetime.date(2025, 8, 8), 0.6554975089575862, 4), (datetime.date(2025, 8, 9), 0.6403654108004194, 3), (datetime.date(2025, 8, 10), 0.741831939484227, 4), (datetime.date(2025, 8, 11), 0.7800465714717904, 3), (datetime.date(2025, 8, 12), 0.7402431376932599, 4), (datetime.date(2025, 8, 13), 0.7131844548905044, 4), (datetime.date(2025, 8, 14), 0.6924461388844759, 4), (datetime.date(2025, 8, 15), 0.7232747295621726, 3), (datetime.date(2025, 8, 16), 0.6456039778168489, 4), (datetime.date(2025, 8, 17), 0.791834694591449, 1), (datetime.date(2025, 8, 19), 0.7833822527589699, 1), (datetime.date(2025, 8, 20), 0.7423301274217097, 4), (datetime.date(2025, 8, 21), 0.7264960405685891, 4), (datetime.date(2025, 8, 22), 0.7017992939901415, 4), (datetime.date(2025, 8, 23), 0.6823161017233729, 4), (datetime.date(2025, 8, 24), 0.7731531415182563, 4), (datetime.date(2025, 8, 25), 0.8115594118915862, 4), (datetime.date(2025, 8, 26), 0.7971553429330455, 4), (datetime.date(2025, 8, 27), 0.7832335914678837, 4), (datetime.date(2025, 8, 28), 0.7928079444948148, 4), (datetime.date(2025, 8, 29), 0.7813071477380323, 4), (datetime.date(2025, 8, 30), 0.6861895395445701, 4), (datetime.date(2025, 8, 31), 0.7631466018656438, 4))}, 'quality_array': [['-6.679617282891347', '01082025'], ['-6.677828270328301', '02082025'], ['-6.667567475233781', '03082025'], ['-6.518321977966098', '04082025'], ['-6.45397435412617', '05082025'], ['-6.667688058251594', '06082025'], ['-7.321356940652932', '07082025'], ['-8.547106976569648', '08082025'], ['-8.335736634171845', '09082025'], ['-8.447500636939681', '10082025'], ['-8.093829028033593', '11082025'], ['-8.05954578650856', '12082025'], ['-8.021668673784925', '13082025'], ['-8.483337147970962', '14082025'], ['-8.545313467360957', '15082025'], ['-8.115501825027007', '16082025'], ['-8.142377401744186', '17082025'], ['-7.657029033573838', '19082025'], ['-8.13420964794502', '20082025'], ['-8.302997681578967', '21082025'], ['-8.533875627346166', '22082025'], ['-8.527396889432035', '23082025'], ['-8.422751506287723', '24082025'], ['-8.206605288007607', '25082025'], ['-8.092636032957655', '26082025'], ['-8.06320270320127', '27082025'], ['-8.08849983268408', '28082025'], ['-7.8847270921899675', '29082025'], ['-8.22682248898474', '30082025'], ['-8.211049758378731', '31082025']], 'number_of_batch': ((682,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01120596275990249, 'nb_photo': 21327, 'list_port_cont': '25592873,25593635,25593723,25593827,25593913,25593968,25594027,25594072,25594178,25594201,25594313,25594340,25596286,25596353,25596556,25598039,25599046,25599194,25599457,25599877,25602263,25603661,25603758,25603792,25614840,25614940,25615145,25615267,25615644,25615994,25616180,25616330,25616568,25616602,25616651,25616706,25616746,25616768,25616893,25616915,25616954,25617003,25617037,25617074,25617099,25617151,25617287,25617369,25622797,25622924,25622948,25622999,25623020,25623064,25623088,25623182,25623210,25623252,25623259,25623282,25623349,25623385,25623494,25623531,25623570,25623625,25623674,25623897,25624052,25624375,25624578,25625842,25626033,25626152,25626333,25626467,25626607,25627600,25628787,25629851,25631774,25633289,25635498,25636858,25638154,25639072,25640268,25641116,25642758,25644423,25646088,25648261,25650201,25651467,25654280,25656710,25703869,25703955,25703991,25704194,25704251,25704329,25704401,25704428,25704470,25704527,25704561,25704586,25704671,25704717,25704781,25704830,25704898,2570493', 'assoc_port': '25592799:25594313,25592800:25594201,25592801:25599457,25592802:25594178,25592803:25596556,25592804:25603792,25592805:25594027,25592807:25594340,25592809:25596353,25592811:25603758,25592814:25594072,25592817:25593968,25592819:25602263,25592822:25599194,25592825:25593827,25592827:25603661,25592829:25593913,25592832:25593723,25592834:25596286,25592835:25592873,25592838:25599046,25592839:25593635,25594538:25599877,25595244:25598039,25614542:25614840,25614543:25614940,25614544:25615145,25614545:25615267,25614546:25617151,25614547:25615644,25614548:25617369,25614549:25615994,25614551:25616180,25614552:25616330,25614554:25616602,25614556:25616746,25614557:25616954,25614560:25617074,25614562:25617037,25614564:25617003,25614567:25616915,25614569:25617099,25614571:25616568,25614575:25616706,25614577:25616893,25614579:25616651,25616549:25616768,25617205:25617287,25621898:25624052,25621900:25625842,25621901:25623897,25621903:25623674,25621905:25623494,25621907:25623531,25621909:25623570,25621911:25623385,25621913:2562362', 'assoc_mat': '25592799:autre:4230:25594313,25592800:autre:4230:25594201,25592801:autre:4230:25599457,25592802:autre:4230:25594178,25592803:autre:4230:25596556,25592804:autre:4230:25603792,25592805:autre:4230:25594027,25592807:autre:4230:25594340,25592809:autre:4230:25596353,25592811:autre:4230:25603758,25592814:autre:4230:25594072,25592817:autre:4230:25593968,25592819:autre:4230:25602263,25592822:autre:4230:25599194,25592825:autre:4230:25593827,25592827:autre:4230:25603661,25592829:autre:4230:25593913,25592832:autre:4230:25593723,25592834:autre:4230:25596286,25592835:autre:4230:25592873,25592838:autre:4230:25599046,25592839:autre:4230:25593635,25594538:autre:4230:25599877,25595244:autre:4230:25598039,25614542:autre:4230:25614840,25614543:autre:4230:25614940,25614544:autre:4230:25615145,25614545:autre:4230:25615267,25614546:autre:4230:25617151,25614547:autre:4230:25615644,25614548:autre:4230:25617369,25614549:autre:4230:25615994,25614551:autre:4230:25616180,25614552:autre:4230:25616330,25614554:autre:4230:25616602,25614556:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04663817603453066, 'nb_photo': 104338, 'list_port_cont': '25592885,25593639,25593735,25593835,25593905,25593985,25594038,25594080,25594173,25594200,25594304,25594347,25596298,25596364,25596568,25598042,25599044,25599192,25599452,25599875,25602277,25603663,25603752,25603795,25614836,25614944,25615135,25615264,25615654,25616002,25616175,25616332,25616573,25616613,25616642,25616701,25616745,25616775,25616885,25616931,25616964,25617005,25617030,25617067,25617110,25617163,25617301,25617370,25622792,25622915,25622965,25622997,25623035,25623073,25623091,25623181,25623215,25623242,25623272,25623284,25623354,25623399,25623498,25623537,25623579,25623642,25623691,25623901,25624042,25624373,25624576,25625849,25626042,25626148,25626330,25626472,25626613,25627590,25628791,25629847,25631785,25633296,25635501,25636846,25638159,25639088,25640271,25641124,25642757,25644429,25646095,25648259,25650218,25651468,25654271,25656705,25703875,25703968,25704004,25704190,25704257,25704335,25704397,25704442,25704482,25704516,25704560,25704594,25704673,25704710,25704796,25704835,25704901,2570493', 'assoc_port': '25592799:25594304,25592800:25594200,25592801:25599452,25592802:25594173,25592803:25596568,25592804:25603795,25592805:25594038,25592807:25594347,25592809:25596364,25592811:25603752,25592814:25594080,25592817:25593985,25592819:25602277,25592822:25599192,25592825:25593835,25592827:25603663,25592829:25593905,25592832:25593735,25592834:25596298,25592835:25592885,25592838:25599044,25592839:25593639,25594538:25599875,25595244:25598042,25614542:25614836,25614543:25614944,25614544:25615135,25614545:25615264,25614546:25617163,25614547:25615654,25614548:25617370,25614549:25616002,25614551:25616175,25614552:25616332,25614554:25616613,25614556:25616745,25614557:25616964,25614560:25617067,25614562:25617030,25614564:25617005,25614567:25616931,25614569:25617110,25614571:25616573,25614575:25616701,25614577:25616885,25614579:25616642,25616549:25616775,25617205:25617301,25621898:25624042,25621900:25625849,25621901:25623901,25621903:25623691,25621905:25623498,25621907:25623537,25621909:25623579,25621911:25623399,25621913:2562364', 'assoc_mat': '25592799:carton:4230:25594304,25592800:carton:4230:25594200,25592801:carton:4230:25599452,25592802:carton:4230:25594173,25592803:carton:4230:25596568,25592804:carton:4230:25603795,25592805:carton:4230:25594038,25592807:carton:4230:25594347,25592809:carton:4230:25596364,25592811:carton:4230:25603752,25592814:carton:4230:25594080,25592817:carton:4230:25593985,25592819:carton:4230:25602277,25592822:carton:4230:25599192,25592825:carton:4230:25593835,25592827:carton:4230:25603663,25592829:carton:4230:25593905,25592832:carton:4230:25593735,25592834:carton:4230:25596298,25592835:carton:4230:25592885,25592838:carton:4230:25599044,25592839:carton:4230:25593639,25594538:carton:4230:25599875,25595244:carton:4230:25598042,25614542:carton:4230:25614836,25614543:carton:4230:25614944,25614544:carton:4230:25615135,25614545:carton:4230:25615264,25614546:carton:4230:25617163,25614547:carton:4230:25615654,25614548:carton:4230:25617370,25614549:carton:4230:25616002,25614551:carton:4230:25616175,25614552:carton:4230:25616332,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001093980305136697, 'nb_photo': 2019, 'list_port_cont': '25593738,25593832,25593910,25594025,25594077,25594169,25594184,25594311,25594338,25596297,25596360,25596562,25598036,25599037,25599191,25599440,25602269,25603668,25603751,25614837,25614946,25615132,25615254,25615651,25615991,25616567,25616646,25616699,25616742,25616772,25616881,25616922,25616952,25616991,25617063,25617108,25617303,25617357,25622960,25623060,25623179,25623250,25623530,25623646,25623898,25624054,25624361,25624575,25625850,25626328,25626462,25626622,25628795,25629856,25631784,25633297,25635490,25636849,25638167,25639082,25640273,25641123,25642764,25644412,25646084,25648252,25650202,25651458,25654276,25656694,25703868,25703990,25704195,25704253,25704393,25704431,25704520,25704555,25704674,25704711,25704942,25704992,25705051,25705180,25705925,25706930,25746309,25746473,25746719,25747058,25747176,25747528,25747611,25748064,25748490,25748766,25749065,25749292,25749389,25749488,25749714,25750026,25750097,25750462,25750804,25750879,25751431,25795137,25796431,25798636,25798683,25798724,25798784,2579884', 'assoc_port': '25592799:25594311,25592800:25594184,25592801:25599440,25592802:25594169,25592803:25596562,25592805:25594025,25592807:25594338,25592809:25596360,25592811:25603751,25592814:25594077,25592819:25602269,25592822:25599191,25592825:25593832,25592827:25603668,25592829:25593910,25592832:25593738,25592834:25596297,25592838:25599037,25595244:25598036,25614542:25614837,25614543:25614946,25614544:25615132,25614545:25615254,25614547:25615651,25614548:25617357,25614549:25615991,25614556:25616742,25614557:25616952,25614560:25617063,25614564:25616991,25614567:25616922,25614569:25617108,25614571:25616567,25614575:25616699,25614577:25616881,25614579:25616646,25616549:25616772,25617205:25617303,25621898:25624054,25621900:25625850,25621901:25623898,25621907:25623530,25621913:25623646,25621917:25623250,25621930:25623179,25621934:25623060,25621944:25622960,25624330:25624361,25624472:25624575,25626273:25626328,25626417:25626462,25626564:25626622,25628503:25628795,25629687:25629856,25631607:25631784,25633146:25633297,25634837:2563549', 'assoc_mat': '25592799:metal:4230:25594311,25592800:metal:4230:25594184,25592801:metal:4230:25599440,25592802:metal:4230:25594169,25592803:metal:4230:25596562,25592805:metal:4230:25594025,25592807:metal:4230:25594338,25592809:metal:4230:25596360,25592811:metal:4230:25603751,25592814:metal:4230:25594077,25592819:metal:4230:25602269,25592822:metal:4230:25599191,25592825:metal:4230:25593832,25592827:metal:4230:25603668,25592829:metal:4230:25593910,25592832:metal:4230:25593738,25592834:metal:4230:25596297,25592838:metal:4230:25599037,25595244:metal:4230:25598036,25614542:metal:4230:25614837,25614543:metal:4230:25614946,25614544:metal:4230:25615132,25614545:metal:4230:25615254,25614547:metal:4230:25615651,25614548:metal:4230:25617357,25614549:metal:4230:25615991,25614556:metal:4230:25616742,25614557:metal:4230:25616952,25614560:metal:4230:25617063,25614564:metal:4230:25616991,25614567:metal:4230:25616922,25614569:metal:4230:25617108,25614571:metal:4230:25616567,25614575:metal:4230:25616699,25614577:metal:4230:25616881,25614579:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19282201773440044, 'nb_photo': 571078, 'list_port_cont': '25592888,25593647,25593728,25593823,25593907,25593983,25594041,25594076,25594175,25594198,25594314,25594348,25596296,25596365,25596566,25598041,25599038,25599184,25599456,25599884,25602280,25603670,25603748,25603791,25614830,25614955,25615142,25615259,25615648,25616008,25616187,25616331,25616566,25616606,25616650,25616700,25616749,25616784,25616890,25616929,25616966,25616997,25617034,25617080,25617112,25617156,25617298,25617372,25622801,25622925,25622957,25623001,25623033,25623071,25623084,25623174,25623214,25623249,25623264,25623286,25623363,25623395,25623495,25623545,25623582,25623626,25623685,25623899,25624048,25624379,25624577,25625855,25626035,25626147,25626326,25626473,25626610,25627592,25628798,25629846,25631791,25633287,25635489,25636853,25638156,25639087,25640267,25641122,25642767,25644422,25646086,25648250,25650209,25651471,25654274,25656706,25703873,25703970,25704003,25704183,25704261,25704328,25704394,25704438,25704477,25704530,25704564,25704595,25704681,25704705,25704787,25704828,25704897,2570494', 'assoc_port': '25592799:25594314,25592800:25594198,25592801:25599456,25592802:25594175,25592803:25596566,25592804:25603791,25592805:25594041,25592807:25594348,25592809:25596365,25592811:25603748,25592814:25594076,25592817:25593983,25592819:25602280,25592822:25599184,25592825:25593823,25592827:25603670,25592829:25593907,25592832:25593728,25592834:25596296,25592835:25592888,25592838:25599038,25592839:25593647,25594538:25599884,25595244:25598041,25614542:25614830,25614543:25614955,25614544:25615142,25614545:25615259,25614546:25617156,25614547:25615648,25614548:25617372,25614549:25616008,25614551:25616187,25614552:25616331,25614554:25616606,25614556:25616749,25614557:25616966,25614560:25617080,25614562:25617034,25614564:25616997,25614567:25616929,25614569:25617112,25614571:25616566,25614575:25616700,25614577:25616890,25614579:25616650,25616549:25616784,25617205:25617298,25621898:25624048,25621900:25625855,25621901:25623899,25621903:25623685,25621905:25623495,25621907:25623545,25621909:25623582,25621911:25623395,25621913:2562362', 'assoc_mat': '25592799:papier:4230:25594314,25592800:papier:4230:25594198,25592801:papier:4230:25599456,25592802:papier:4230:25594175,25592803:papier:4230:25596566,25592804:papier:4230:25603791,25592805:papier:4230:25594041,25592807:papier:4230:25594348,25592809:papier:4230:25596365,25592811:papier:4230:25603748,25592814:papier:4230:25594076,25592817:papier:4230:25593983,25592819:papier:4230:25602280,25592822:papier:4230:25599184,25592825:papier:4230:25593823,25592827:papier:4230:25603670,25592829:papier:4230:25593907,25592832:papier:4230:25593728,25592834:papier:4230:25596296,25592835:papier:4230:25592888,25592838:papier:4230:25599038,25592839:papier:4230:25593647,25594538:papier:4230:25599884,25595244:papier:4230:25598041,25614542:papier:4230:25614830,25614543:papier:4230:25614955,25614544:papier:4230:25615142,25614545:papier:4230:25615259,25614546:papier:4230:25617156,25614547:papier:4230:25615648,25614548:papier:4230:25617372,25614549:papier:4230:25616008,25614551:papier:4230:25616187,25614552:papier:4230:25616331,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003685300950621834, 'nb_photo': 2884, 'list_port_cont': '25592872,25593732,25593986,25594071,25596295,25596557,25599040,25602281,25603759,25603796,25614831,25616004,25616186,25616605,25616644,25616739,25616927,25616968,25617001,25617040,25617107,25617162,25617361,25623178,25623218,25623254,25623269,25623287,25623362,25623638,25628792,25631787,25635497,25636851,25638171,25640270,25641125,25642759,25644428,25646097,25654279,25703880,25704001,25704399,25704436,25704478,25704521,25704565,25704602,25704903,25706941,25746316,25747180,25747526,25747613,25747834,25748501,25748759,25749298,25749399,25750034,25750805,25795151,25796440,25798698,25798733,25798880,25798918,25798954,25798985,25799023,25799055,25799077,25799132,25799166,25799240,25799277,25799312,25799372,25799443,25799776,25808677,25810768,25811454,25811879,25812695,25814033,25814730,25816064,25817242,25818147,25818736,25820931,25823193,25824448,25828710,25828830,25829007,25829281,25829476,25830223,25830398,25830529,25831615,25831962,25839560,25839821,25840145,25841504,25842654,25843337,25844471,25845208,2584595', 'assoc_port': '25592803:25596557,25592804:25603796,25592811:25603759,25592814:25594071,25592817:25593986,25592819:25602281,25592832:25593732,25592834:25596295,25592835:25592872,25592838:25599040,25614542:25614831,25614546:25617162,25614548:25617361,25614549:25616004,25614551:25616186,25614554:25616605,25614556:25616739,25614557:25616968,25614562:25617040,25614564:25617001,25614567:25616927,25614569:25617107,25614579:25616644,25621913:25623638,25621915:25623362,25621917:25623254,25621920:25623218,25621924:25623269,25621927:25623287,25621930:25623178,25628503:25628792,25631607:25631787,25634837:25635497,25636691:25636851,25638080:25638171,25640096:25640270,25640961:25641125,25642659:25642759,25644311:25644428,25645929:25646097,25653969:25654279,25703777:25704903,25703784:25704602,25703785:25704565,25703787:25704478,25703788:25704399,25703789:25704436,25703790:25704521,25703792:25704001,25703795:25703880,25706893:25706941,25746133:25750805,25746149:25750034,25746152:25749298,25746155:25749399,25746158:25748759,25746162:2574850', 'assoc_mat': '25592803:pehd:4230:25596557,25592804:pehd:4230:25603796,25592811:pehd:4230:25603759,25592814:pehd:4230:25594071,25592817:pehd:4230:25593986,25592819:pehd:4230:25602281,25592832:pehd:4230:25593732,25592834:pehd:4230:25596295,25592835:pehd:4230:25592872,25592838:pehd:4230:25599040,25614542:pehd:4230:25614831,25614546:pehd:4230:25617162,25614548:pehd:4230:25617361,25614549:pehd:4230:25616004,25614551:pehd:4230:25616186,25614554:pehd:4230:25616605,25614556:pehd:4230:25616739,25614557:pehd:4230:25616968,25614562:pehd:4230:25617040,25614564:pehd:4230:25617001,25614567:pehd:4230:25616927,25614569:pehd:4230:25617107,25614579:pehd:4230:25616644,25621913:pehd:4230:25623638,25621915:pehd:4230:25623362,25621917:pehd:4230:25623254,25621920:pehd:4230:25623218,25621924:pehd:4230:25623269,25621927:pehd:4230:25623287,25621930:pehd:4230:25623178,25628503:pehd:4230:25628792,25631607:pehd:4230:25631787,25634837:pehd:4230:25635497,25636691:pehd:4230:25636851,25638080:pehd:4230:25638171,25640096:pehd:4230:25640270,25640961:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01644701299219006, 'nb_photo': 25540, 'list_port_cont': '25592883,25593645,25593739,25593834,25593911,25593984,25594029,25594068,25594174,25594197,25594308,25594342,25596291,25596366,25596570,25598035,25599045,25599197,25599446,25599882,25602272,25603671,25603754,25603789,25614833,25614956,25615140,25615261,25615653,25615995,25616176,25616334,25616576,25616607,25616649,25616705,25616743,25616780,25616888,25616918,25616961,25616995,25617031,25617078,25617115,25617161,25617304,25617367,25622800,25622920,25622953,25622989,25623036,25623066,25623092,25623177,25623205,25623255,25623271,25623291,25623358,25623390,25623507,25623540,25623583,25623630,25623690,25623906,25624050,25624377,25624570,25625847,25626031,25626151,25626322,25626471,25626618,25627599,25628785,25629857,25631790,25633302,25635496,25636852,25638169,25639089,25640275,25641126,25642761,25644424,25646087,25648253,25650210,25651462,25654275,25656709,25703870,25703971,25704002,25704188,25704262,25704333,25704398,25704432,25704481,25704524,25704563,25704600,25704672,25704716,25704792,25704834,25704911,2570494', 'assoc_port': '25592799:25594308,25592800:25594197,25592801:25599446,25592802:25594174,25592803:25596570,25592804:25603789,25592805:25594029,25592807:25594342,25592809:25596366,25592811:25603754,25592814:25594068,25592817:25593984,25592819:25602272,25592822:25599197,25592825:25593834,25592827:25603671,25592829:25593911,25592832:25593739,25592834:25596291,25592835:25592883,25592838:25599045,25592839:25593645,25594538:25599882,25595244:25598035,25614542:25614833,25614543:25614956,25614544:25615140,25614545:25615261,25614546:25617161,25614547:25615653,25614548:25617367,25614549:25615995,25614551:25616176,25614552:25616334,25614554:25616607,25614556:25616743,25614557:25616961,25614560:25617078,25614562:25617031,25614564:25616995,25614567:25616918,25614569:25617115,25614571:25616576,25614575:25616705,25614577:25616888,25614579:25616649,25616549:25616780,25617205:25617304,25621898:25624050,25621900:25625847,25621901:25623906,25621903:25623690,25621905:25623507,25621907:25623540,25621909:25623583,25621911:25623390,25621913:2562363', 'assoc_mat': '25592799:pet_clair:4230:25594308,25592800:pet_clair:4230:25594197,25592801:pet_clair:4230:25599446,25592802:pet_clair:4230:25594174,25592803:pet_clair:4230:25596570,25592804:pet_clair:4230:25603789,25592805:pet_clair:4230:25594029,25592807:pet_clair:4230:25594342,25592809:pet_clair:4230:25596366,25592811:pet_clair:4230:25603754,25592814:pet_clair:4230:25594068,25592817:pet_clair:4230:25593984,25592819:pet_clair:4230:25602272,25592822:pet_clair:4230:25599197,25592825:pet_clair:4230:25593834,25592827:pet_clair:4230:25603671,25592829:pet_clair:4230:25593911,25592832:pet_clair:4230:25593739,25592834:pet_clair:4230:25596291,25592835:pet_clair:4230:25592883,25592838:pet_clair:4230:25599045,25592839:pet_clair:4230:25593645,25594538:pet_clair:4230:25599882,25595244:pet_clair:4230:25598035,25614542:pet_clair:4230:25614833,25614543:pet_clair:4230:25614956,25614544:pet_clair:4230:25615140,25614545:pet_clair:4230:25615261,25614546:pet_clair:4230:25617161,25614547:pet_clair:4230:25615653,25614548:pet_clair:4230:25617367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002532351342047139, 'nb_photo': 1397, 'list_port_cont': '25593977,25594075,25594199,25594310,25596362,25598037,25599047,25603666,25603757,25616178,25616648,25616711,25616894,25616930,25616998,25617029,25617113,25622963,25623173,25623253,25623273,25623276,25623351,25623383,25623508,25623575,25623640,25628793,25635487,25641113,25642763,25644427,25646092,25648260,25650214,25651469,25654284,25656702,25703876,25703967,25704189,25704263,25704332,25704391,25704677,25704703,25704998,25705115,25705182,25746318,25746492,25746812,25747170,25747533,25747607,25747832,25748062,25748498,25748756,25749063,25749303,25749402,25750100,25751422,25795138,25796435,25798635,25798732,25798844,25798878,25798913,25798986,25799061,25799078,25799133,25799172,25799203,25799269,25799446,25808671,25810756,25811460,25811885,25812691,25814030,25814736,25816063,25817241,25818149,25818741,25820923,25823199,25828700,25828829,25829004,25829282,25829484,25830230,25830402,25831609,25839816,25840154,25841508,25842658,25843336,25844475,25845214,25845955,25846441,25847478,25848130,25848800,25849481,2585002', 'assoc_port': '25592799:25594310,25592800:25594199,25592809:25596362,25592811:25603757,25592814:25594075,25592817:25593977,25592827:25603666,25592838:25599047,25595244:25598037,25614551:25616178,25614562:25617029,25614564:25616998,25614567:25616930,25614569:25617113,25614575:25616711,25614577:25616894,25614579:25616648,25621905:25623508,25621909:25623575,25621911:25623383,25621913:25623640,25621915:25623351,25621917:25623253,25621924:25623273,25621927:25623276,25621930:25623173,25621944:25622963,25628503:25628793,25634837:25635487,25640961:25641113,25642659:25642763,25644311:25644427,25645929:25646092,25648063:25648260,25649922:25650214,25651303:25651469,25653969:25654284,25656628:25656702,25703760:25705182,25703764:25705115,25703770:25704998,25703780:25704677,25703782:25704703,25703788:25704391,25703791:25704332,25703793:25704189,25703794:25704263,25703795:25703876,25703796:25703967,25746138:25750100,25746152:25749303,25746155:25749402,25746158:25748756,25746162:25748498,25746165:25747832,25746168:25748062,25746172:2574760', 'assoc_mat': '25592799:pet_fonce:4230:25594310,25592800:pet_fonce:4230:25594199,25592809:pet_fonce:4230:25596362,25592811:pet_fonce:4230:25603757,25592814:pet_fonce:4230:25594075,25592817:pet_fonce:4230:25593977,25592827:pet_fonce:4230:25603666,25592838:pet_fonce:4230:25599047,25595244:pet_fonce:4230:25598037,25614551:pet_fonce:4230:25616178,25614562:pet_fonce:4230:25617029,25614564:pet_fonce:4230:25616998,25614567:pet_fonce:4230:25616930,25614569:pet_fonce:4230:25617113,25614575:pet_fonce:4230:25616711,25614577:pet_fonce:4230:25616894,25614579:pet_fonce:4230:25616648,25621905:pet_fonce:4230:25623508,25621909:pet_fonce:4230:25623575,25621911:pet_fonce:4230:25623383,25621913:pet_fonce:4230:25623640,25621915:pet_fonce:4230:25623351,25621917:pet_fonce:4230:25623253,25621924:pet_fonce:4230:25623273,25621927:pet_fonce:4230:25623276,25621930:pet_fonce:4230:25623173,25621944:pet_fonce:4230:25622963,25628503:pet_fonce:4230:25628793,25634837:pet_fonce:4230:25635487,25640961:pet_fonce:4230:25641113,25642659:pet_fonce:4230:25642763,2'}), 'main_stat': {'nb_photos': 2543}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-08', 0.7646241383655079),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2543,),), 'unwanted_material_monthly_percentage': ((0.7646241383655079,),), 'material_repartition': (('incineration', 2543),), 'material_dict': {'incineration': 2543}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 8, 1), 0.861625514580672, 4), (datetime.date(2025, 8, 2), 0.8463428309342617, 4), (datetime.date(2025, 8, 3), 0.8904179913351169, 4), (datetime.date(2025, 8, 4), 0.888873202462103, 2), (datetime.date(2025, 8, 5), 0.8817449969052896, 4), (datetime.date(2025, 8, 6), 0.8453763768284184, 3), (datetime.date(2025, 8, 7), 0.7816527405317729, 2), (datetime.date(2025, 8, 8), 0.6554975089575862, 4), (datetime.date(2025, 8, 9), 0.6403654108004194, 3), (datetime.date(2025, 8, 10), 0.741831939484227, 4), (datetime.date(2025, 8, 11), 0.7800465714717904, 3), (datetime.date(2025, 8, 12), 0.7402431376932599, 4), (datetime.date(2025, 8, 13), 0.7131844548905044, 4), (datetime.date(2025, 8, 14), 0.6924461388844759, 4), (datetime.date(2025, 8, 15), 0.7232747295621726, 3), (datetime.date(2025, 8, 16), 0.6456039778168489, 4), (datetime.date(2025, 8, 17), 0.791834694591449, 1), (datetime.date(2025, 8, 19), 0.7833822527589699, 1), (datetime.date(2025, 8, 20), 0.7423301274217097, 4), (datetime.date(2025, 8, 21), 0.7264960405685891, 4), (datetime.date(2025, 8, 22), 0.7017992939901415, 4), (datetime.date(2025, 8, 23), 0.6823161017233729, 4), (datetime.date(2025, 8, 24), 0.7731531415182563, 4), (datetime.date(2025, 8, 25), 0.8115594118915862, 4), (datetime.date(2025, 8, 26), 0.7971553429330455, 4), (datetime.date(2025, 8, 27), 0.7832335914678837, 4), (datetime.date(2025, 8, 28), 0.7928079444948148, 4), (datetime.date(2025, 8, 29), 0.7813071477380323, 4), (datetime.date(2025, 8, 30), 0.6861895395445701, 4), (datetime.date(2025, 8, 31), 0.7631466018656438, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 8, 1), 0.861625514580672, 4), (datetime.date(2025, 8, 2), 0.8463428309342617, 4), (datetime.date(2025, 8, 3), 0.8904179913351169, 4), (datetime.date(2025, 8, 4), 0.888873202462103, 2), (datetime.date(2025, 8, 5), 0.8817449969052896, 4), (datetime.date(2025, 8, 6), 0.8453763768284184, 3), (datetime.date(2025, 8, 7), 0.7816527405317729, 2), (datetime.date(2025, 8, 8), 0.6554975089575862, 4), (datetime.date(2025, 8, 9), 0.6403654108004194, 3), (datetime.date(2025, 8, 10), 0.741831939484227, 4), (datetime.date(2025, 8, 11), 0.7800465714717904, 3), (datetime.date(2025, 8, 12), 0.7402431376932599, 4), (datetime.date(2025, 8, 13), 0.7131844548905044, 4), (datetime.date(2025, 8, 14), 0.6924461388844759, 4), (datetime.date(2025, 8, 15), 0.7232747295621726, 3), (datetime.date(2025, 8, 16), 0.6456039778168489, 4), (datetime.date(2025, 8, 17), 0.791834694591449, 1), (datetime.date(2025, 8, 19), 0.7833822527589699, 1), (datetime.date(2025, 8, 20), 0.7423301274217097, 4), (datetime.date(2025, 8, 21), 0.7264960405685891, 4), (datetime.date(2025, 8, 22), 0.7017992939901415, 4), (datetime.date(2025, 8, 23), 0.6823161017233729, 4), (datetime.date(2025, 8, 24), 0.7731531415182563, 4), (datetime.date(2025, 8, 25), 0.8115594118915862, 4), (datetime.date(2025, 8, 26), 0.7971553429330455, 4), (datetime.date(2025, 8, 27), 0.7832335914678837, 4), (datetime.date(2025, 8, 28), 0.7928079444948148, 4), (datetime.date(2025, 8, 29), 0.7813071477380323, 4), (datetime.date(2025, 8, 30), 0.6861895395445701, 4), (datetime.date(2025, 8, 31), 0.7631466018656438, 4))}, 'quality_array': [['-6.679617282891347', '01082025'], ['-6.677828270328301', '02082025'], ['-6.667567475233781', '03082025'], ['-6.518321977966098', '04082025'], ['-6.45397435412617', '05082025'], ['-6.667688058251594', '06082025'], ['-7.321356940652932', '07082025'], ['-8.547106976569648', '08082025'], ['-8.335736634171845', '09082025'], ['-8.447500636939681', '10082025'], ['-8.093829028033593', '11082025'], ['-8.05954578650856', '12082025'], ['-8.021668673784925', '13082025'], ['-8.483337147970962', '14082025'], ['-8.545313467360957', '15082025'], ['-8.115501825027007', '16082025'], ['-8.142377401744186', '17082025'], ['-7.657029033573838', '19082025'], ['-8.13420964794502', '20082025'], ['-8.302997681578967', '21082025'], ['-8.533875627346166', '22082025'], ['-8.527396889432035', '23082025'], ['-8.422751506287723', '24082025'], ['-8.206605288007607', '25082025'], ['-8.092636032957655', '26082025'], ['-8.06320270320127', '27082025'], ['-8.08849983268408', '28082025'], ['-7.8847270921899675', '29082025'], ['-8.22682248898474', '30082025'], ['-8.211049758378731', '31082025']], 'number_of_batch': ((682,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01120596275990249, 'nb_photo': 21327, 'list_port_cont': '25592873,25593635,25593723,25593827,25593913,25593968,25594027,25594072,25594178,25594201,25594313,25594340,25596286,25596353,25596556,25598039,25599046,25599194,25599457,25599877,25602263,25603661,25603758,25603792,25614840,25614940,25615145,25615267,25615644,25615994,25616180,25616330,25616568,25616602,25616651,25616706,25616746,25616768,25616893,25616915,25616954,25617003,25617037,25617074,25617099,25617151,25617287,25617369,25622797,25622924,25622948,25622999,25623020,25623064,25623088,25623182,25623210,25623252,25623259,25623282,25623349,25623385,25623494,25623531,25623570,25623625,25623674,25623897,25624052,25624375,25624578,25625842,25626033,25626152,25626333,25626467,25626607,25627600,25628787,25629851,25631774,25633289,25635498,25636858,25638154,25639072,25640268,25641116,25642758,25644423,25646088,25648261,25650201,25651467,25654280,25656710,25703869,25703955,25703991,25704194,25704251,25704329,25704401,25704428,25704470,25704527,25704561,25704586,25704671,25704717,25704781,25704830,25704898,2570493', 'assoc_port': '25592799:25594313,25592800:25594201,25592801:25599457,25592802:25594178,25592803:25596556,25592804:25603792,25592805:25594027,25592807:25594340,25592809:25596353,25592811:25603758,25592814:25594072,25592817:25593968,25592819:25602263,25592822:25599194,25592825:25593827,25592827:25603661,25592829:25593913,25592832:25593723,25592834:25596286,25592835:25592873,25592838:25599046,25592839:25593635,25594538:25599877,25595244:25598039,25614542:25614840,25614543:25614940,25614544:25615145,25614545:25615267,25614546:25617151,25614547:25615644,25614548:25617369,25614549:25615994,25614551:25616180,25614552:25616330,25614554:25616602,25614556:25616746,25614557:25616954,25614560:25617074,25614562:25617037,25614564:25617003,25614567:25616915,25614569:25617099,25614571:25616568,25614575:25616706,25614577:25616893,25614579:25616651,25616549:25616768,25617205:25617287,25621898:25624052,25621900:25625842,25621901:25623897,25621903:25623674,25621905:25623494,25621907:25623531,25621909:25623570,25621911:25623385,25621913:2562362', 'assoc_mat': '25592799:autre:4230:25594313,25592800:autre:4230:25594201,25592801:autre:4230:25599457,25592802:autre:4230:25594178,25592803:autre:4230:25596556,25592804:autre:4230:25603792,25592805:autre:4230:25594027,25592807:autre:4230:25594340,25592809:autre:4230:25596353,25592811:autre:4230:25603758,25592814:autre:4230:25594072,25592817:autre:4230:25593968,25592819:autre:4230:25602263,25592822:autre:4230:25599194,25592825:autre:4230:25593827,25592827:autre:4230:25603661,25592829:autre:4230:25593913,25592832:autre:4230:25593723,25592834:autre:4230:25596286,25592835:autre:4230:25592873,25592838:autre:4230:25599046,25592839:autre:4230:25593635,25594538:autre:4230:25599877,25595244:autre:4230:25598039,25614542:autre:4230:25614840,25614543:autre:4230:25614940,25614544:autre:4230:25615145,25614545:autre:4230:25615267,25614546:autre:4230:25617151,25614547:autre:4230:25615644,25614548:autre:4230:25617369,25614549:autre:4230:25615994,25614551:autre:4230:25616180,25614552:autre:4230:25616330,25614554:autre:4230:25616602,25614556:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04663817603453066, 'nb_photo': 104338, 'list_port_cont': '25592885,25593639,25593735,25593835,25593905,25593985,25594038,25594080,25594173,25594200,25594304,25594347,25596298,25596364,25596568,25598042,25599044,25599192,25599452,25599875,25602277,25603663,25603752,25603795,25614836,25614944,25615135,25615264,25615654,25616002,25616175,25616332,25616573,25616613,25616642,25616701,25616745,25616775,25616885,25616931,25616964,25617005,25617030,25617067,25617110,25617163,25617301,25617370,25622792,25622915,25622965,25622997,25623035,25623073,25623091,25623181,25623215,25623242,25623272,25623284,25623354,25623399,25623498,25623537,25623579,25623642,25623691,25623901,25624042,25624373,25624576,25625849,25626042,25626148,25626330,25626472,25626613,25627590,25628791,25629847,25631785,25633296,25635501,25636846,25638159,25639088,25640271,25641124,25642757,25644429,25646095,25648259,25650218,25651468,25654271,25656705,25703875,25703968,25704004,25704190,25704257,25704335,25704397,25704442,25704482,25704516,25704560,25704594,25704673,25704710,25704796,25704835,25704901,2570493', 'assoc_port': '25592799:25594304,25592800:25594200,25592801:25599452,25592802:25594173,25592803:25596568,25592804:25603795,25592805:25594038,25592807:25594347,25592809:25596364,25592811:25603752,25592814:25594080,25592817:25593985,25592819:25602277,25592822:25599192,25592825:25593835,25592827:25603663,25592829:25593905,25592832:25593735,25592834:25596298,25592835:25592885,25592838:25599044,25592839:25593639,25594538:25599875,25595244:25598042,25614542:25614836,25614543:25614944,25614544:25615135,25614545:25615264,25614546:25617163,25614547:25615654,25614548:25617370,25614549:25616002,25614551:25616175,25614552:25616332,25614554:25616613,25614556:25616745,25614557:25616964,25614560:25617067,25614562:25617030,25614564:25617005,25614567:25616931,25614569:25617110,25614571:25616573,25614575:25616701,25614577:25616885,25614579:25616642,25616549:25616775,25617205:25617301,25621898:25624042,25621900:25625849,25621901:25623901,25621903:25623691,25621905:25623498,25621907:25623537,25621909:25623579,25621911:25623399,25621913:2562364', 'assoc_mat': '25592799:carton:4230:25594304,25592800:carton:4230:25594200,25592801:carton:4230:25599452,25592802:carton:4230:25594173,25592803:carton:4230:25596568,25592804:carton:4230:25603795,25592805:carton:4230:25594038,25592807:carton:4230:25594347,25592809:carton:4230:25596364,25592811:carton:4230:25603752,25592814:carton:4230:25594080,25592817:carton:4230:25593985,25592819:carton:4230:25602277,25592822:carton:4230:25599192,25592825:carton:4230:25593835,25592827:carton:4230:25603663,25592829:carton:4230:25593905,25592832:carton:4230:25593735,25592834:carton:4230:25596298,25592835:carton:4230:25592885,25592838:carton:4230:25599044,25592839:carton:4230:25593639,25594538:carton:4230:25599875,25595244:carton:4230:25598042,25614542:carton:4230:25614836,25614543:carton:4230:25614944,25614544:carton:4230:25615135,25614545:carton:4230:25615264,25614546:carton:4230:25617163,25614547:carton:4230:25615654,25614548:carton:4230:25617370,25614549:carton:4230:25616002,25614551:carton:4230:25616175,25614552:carton:4230:25616332,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001093980305136697, 'nb_photo': 2019, 'list_port_cont': '25593738,25593832,25593910,25594025,25594077,25594169,25594184,25594311,25594338,25596297,25596360,25596562,25598036,25599037,25599191,25599440,25602269,25603668,25603751,25614837,25614946,25615132,25615254,25615651,25615991,25616567,25616646,25616699,25616742,25616772,25616881,25616922,25616952,25616991,25617063,25617108,25617303,25617357,25622960,25623060,25623179,25623250,25623530,25623646,25623898,25624054,25624361,25624575,25625850,25626328,25626462,25626622,25628795,25629856,25631784,25633297,25635490,25636849,25638167,25639082,25640273,25641123,25642764,25644412,25646084,25648252,25650202,25651458,25654276,25656694,25703868,25703990,25704195,25704253,25704393,25704431,25704520,25704555,25704674,25704711,25704942,25704992,25705051,25705180,25705925,25706930,25746309,25746473,25746719,25747058,25747176,25747528,25747611,25748064,25748490,25748766,25749065,25749292,25749389,25749488,25749714,25750026,25750097,25750462,25750804,25750879,25751431,25795137,25796431,25798636,25798683,25798724,25798784,2579884', 'assoc_port': '25592799:25594311,25592800:25594184,25592801:25599440,25592802:25594169,25592803:25596562,25592805:25594025,25592807:25594338,25592809:25596360,25592811:25603751,25592814:25594077,25592819:25602269,25592822:25599191,25592825:25593832,25592827:25603668,25592829:25593910,25592832:25593738,25592834:25596297,25592838:25599037,25595244:25598036,25614542:25614837,25614543:25614946,25614544:25615132,25614545:25615254,25614547:25615651,25614548:25617357,25614549:25615991,25614556:25616742,25614557:25616952,25614560:25617063,25614564:25616991,25614567:25616922,25614569:25617108,25614571:25616567,25614575:25616699,25614577:25616881,25614579:25616646,25616549:25616772,25617205:25617303,25621898:25624054,25621900:25625850,25621901:25623898,25621907:25623530,25621913:25623646,25621917:25623250,25621930:25623179,25621934:25623060,25621944:25622960,25624330:25624361,25624472:25624575,25626273:25626328,25626417:25626462,25626564:25626622,25628503:25628795,25629687:25629856,25631607:25631784,25633146:25633297,25634837:2563549', 'assoc_mat': '25592799:metal:4230:25594311,25592800:metal:4230:25594184,25592801:metal:4230:25599440,25592802:metal:4230:25594169,25592803:metal:4230:25596562,25592805:metal:4230:25594025,25592807:metal:4230:25594338,25592809:metal:4230:25596360,25592811:metal:4230:25603751,25592814:metal:4230:25594077,25592819:metal:4230:25602269,25592822:metal:4230:25599191,25592825:metal:4230:25593832,25592827:metal:4230:25603668,25592829:metal:4230:25593910,25592832:metal:4230:25593738,25592834:metal:4230:25596297,25592838:metal:4230:25599037,25595244:metal:4230:25598036,25614542:metal:4230:25614837,25614543:metal:4230:25614946,25614544:metal:4230:25615132,25614545:metal:4230:25615254,25614547:metal:4230:25615651,25614548:metal:4230:25617357,25614549:metal:4230:25615991,25614556:metal:4230:25616742,25614557:metal:4230:25616952,25614560:metal:4230:25617063,25614564:metal:4230:25616991,25614567:metal:4230:25616922,25614569:metal:4230:25617108,25614571:metal:4230:25616567,25614575:metal:4230:25616699,25614577:metal:4230:25616881,25614579:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19282201773440044, 'nb_photo': 571078, 'list_port_cont': '25592888,25593647,25593728,25593823,25593907,25593983,25594041,25594076,25594175,25594198,25594314,25594348,25596296,25596365,25596566,25598041,25599038,25599184,25599456,25599884,25602280,25603670,25603748,25603791,25614830,25614955,25615142,25615259,25615648,25616008,25616187,25616331,25616566,25616606,25616650,25616700,25616749,25616784,25616890,25616929,25616966,25616997,25617034,25617080,25617112,25617156,25617298,25617372,25622801,25622925,25622957,25623001,25623033,25623071,25623084,25623174,25623214,25623249,25623264,25623286,25623363,25623395,25623495,25623545,25623582,25623626,25623685,25623899,25624048,25624379,25624577,25625855,25626035,25626147,25626326,25626473,25626610,25627592,25628798,25629846,25631791,25633287,25635489,25636853,25638156,25639087,25640267,25641122,25642767,25644422,25646086,25648250,25650209,25651471,25654274,25656706,25703873,25703970,25704003,25704183,25704261,25704328,25704394,25704438,25704477,25704530,25704564,25704595,25704681,25704705,25704787,25704828,25704897,2570494', 'assoc_port': '25592799:25594314,25592800:25594198,25592801:25599456,25592802:25594175,25592803:25596566,25592804:25603791,25592805:25594041,25592807:25594348,25592809:25596365,25592811:25603748,25592814:25594076,25592817:25593983,25592819:25602280,25592822:25599184,25592825:25593823,25592827:25603670,25592829:25593907,25592832:25593728,25592834:25596296,25592835:25592888,25592838:25599038,25592839:25593647,25594538:25599884,25595244:25598041,25614542:25614830,25614543:25614955,25614544:25615142,25614545:25615259,25614546:25617156,25614547:25615648,25614548:25617372,25614549:25616008,25614551:25616187,25614552:25616331,25614554:25616606,25614556:25616749,25614557:25616966,25614560:25617080,25614562:25617034,25614564:25616997,25614567:25616929,25614569:25617112,25614571:25616566,25614575:25616700,25614577:25616890,25614579:25616650,25616549:25616784,25617205:25617298,25621898:25624048,25621900:25625855,25621901:25623899,25621903:25623685,25621905:25623495,25621907:25623545,25621909:25623582,25621911:25623395,25621913:2562362', 'assoc_mat': '25592799:papier:4230:25594314,25592800:papier:4230:25594198,25592801:papier:4230:25599456,25592802:papier:4230:25594175,25592803:papier:4230:25596566,25592804:papier:4230:25603791,25592805:papier:4230:25594041,25592807:papier:4230:25594348,25592809:papier:4230:25596365,25592811:papier:4230:25603748,25592814:papier:4230:25594076,25592817:papier:4230:25593983,25592819:papier:4230:25602280,25592822:papier:4230:25599184,25592825:papier:4230:25593823,25592827:papier:4230:25603670,25592829:papier:4230:25593907,25592832:papier:4230:25593728,25592834:papier:4230:25596296,25592835:papier:4230:25592888,25592838:papier:4230:25599038,25592839:papier:4230:25593647,25594538:papier:4230:25599884,25595244:papier:4230:25598041,25614542:papier:4230:25614830,25614543:papier:4230:25614955,25614544:papier:4230:25615142,25614545:papier:4230:25615259,25614546:papier:4230:25617156,25614547:papier:4230:25615648,25614548:papier:4230:25617372,25614549:papier:4230:25616008,25614551:papier:4230:25616187,25614552:papier:4230:25616331,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003685300950621834, 'nb_photo': 2884, 'list_port_cont': '25592872,25593732,25593986,25594071,25596295,25596557,25599040,25602281,25603759,25603796,25614831,25616004,25616186,25616605,25616644,25616739,25616927,25616968,25617001,25617040,25617107,25617162,25617361,25623178,25623218,25623254,25623269,25623287,25623362,25623638,25628792,25631787,25635497,25636851,25638171,25640270,25641125,25642759,25644428,25646097,25654279,25703880,25704001,25704399,25704436,25704478,25704521,25704565,25704602,25704903,25706941,25746316,25747180,25747526,25747613,25747834,25748501,25748759,25749298,25749399,25750034,25750805,25795151,25796440,25798698,25798733,25798880,25798918,25798954,25798985,25799023,25799055,25799077,25799132,25799166,25799240,25799277,25799312,25799372,25799443,25799776,25808677,25810768,25811454,25811879,25812695,25814033,25814730,25816064,25817242,25818147,25818736,25820931,25823193,25824448,25828710,25828830,25829007,25829281,25829476,25830223,25830398,25830529,25831615,25831962,25839560,25839821,25840145,25841504,25842654,25843337,25844471,25845208,2584595', 'assoc_port': '25592803:25596557,25592804:25603796,25592811:25603759,25592814:25594071,25592817:25593986,25592819:25602281,25592832:25593732,25592834:25596295,25592835:25592872,25592838:25599040,25614542:25614831,25614546:25617162,25614548:25617361,25614549:25616004,25614551:25616186,25614554:25616605,25614556:25616739,25614557:25616968,25614562:25617040,25614564:25617001,25614567:25616927,25614569:25617107,25614579:25616644,25621913:25623638,25621915:25623362,25621917:25623254,25621920:25623218,25621924:25623269,25621927:25623287,25621930:25623178,25628503:25628792,25631607:25631787,25634837:25635497,25636691:25636851,25638080:25638171,25640096:25640270,25640961:25641125,25642659:25642759,25644311:25644428,25645929:25646097,25653969:25654279,25703777:25704903,25703784:25704602,25703785:25704565,25703787:25704478,25703788:25704399,25703789:25704436,25703790:25704521,25703792:25704001,25703795:25703880,25706893:25706941,25746133:25750805,25746149:25750034,25746152:25749298,25746155:25749399,25746158:25748759,25746162:2574850', 'assoc_mat': '25592803:pehd:4230:25596557,25592804:pehd:4230:25603796,25592811:pehd:4230:25603759,25592814:pehd:4230:25594071,25592817:pehd:4230:25593986,25592819:pehd:4230:25602281,25592832:pehd:4230:25593732,25592834:pehd:4230:25596295,25592835:pehd:4230:25592872,25592838:pehd:4230:25599040,25614542:pehd:4230:25614831,25614546:pehd:4230:25617162,25614548:pehd:4230:25617361,25614549:pehd:4230:25616004,25614551:pehd:4230:25616186,25614554:pehd:4230:25616605,25614556:pehd:4230:25616739,25614557:pehd:4230:25616968,25614562:pehd:4230:25617040,25614564:pehd:4230:25617001,25614567:pehd:4230:25616927,25614569:pehd:4230:25617107,25614579:pehd:4230:25616644,25621913:pehd:4230:25623638,25621915:pehd:4230:25623362,25621917:pehd:4230:25623254,25621920:pehd:4230:25623218,25621924:pehd:4230:25623269,25621927:pehd:4230:25623287,25621930:pehd:4230:25623178,25628503:pehd:4230:25628792,25631607:pehd:4230:25631787,25634837:pehd:4230:25635497,25636691:pehd:4230:25636851,25638080:pehd:4230:25638171,25640096:pehd:4230:25640270,25640961:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01644701299219006, 'nb_photo': 25540, 'list_port_cont': '25592883,25593645,25593739,25593834,25593911,25593984,25594029,25594068,25594174,25594197,25594308,25594342,25596291,25596366,25596570,25598035,25599045,25599197,25599446,25599882,25602272,25603671,25603754,25603789,25614833,25614956,25615140,25615261,25615653,25615995,25616176,25616334,25616576,25616607,25616649,25616705,25616743,25616780,25616888,25616918,25616961,25616995,25617031,25617078,25617115,25617161,25617304,25617367,25622800,25622920,25622953,25622989,25623036,25623066,25623092,25623177,25623205,25623255,25623271,25623291,25623358,25623390,25623507,25623540,25623583,25623630,25623690,25623906,25624050,25624377,25624570,25625847,25626031,25626151,25626322,25626471,25626618,25627599,25628785,25629857,25631790,25633302,25635496,25636852,25638169,25639089,25640275,25641126,25642761,25644424,25646087,25648253,25650210,25651462,25654275,25656709,25703870,25703971,25704002,25704188,25704262,25704333,25704398,25704432,25704481,25704524,25704563,25704600,25704672,25704716,25704792,25704834,25704911,2570494', 'assoc_port': '25592799:25594308,25592800:25594197,25592801:25599446,25592802:25594174,25592803:25596570,25592804:25603789,25592805:25594029,25592807:25594342,25592809:25596366,25592811:25603754,25592814:25594068,25592817:25593984,25592819:25602272,25592822:25599197,25592825:25593834,25592827:25603671,25592829:25593911,25592832:25593739,25592834:25596291,25592835:25592883,25592838:25599045,25592839:25593645,25594538:25599882,25595244:25598035,25614542:25614833,25614543:25614956,25614544:25615140,25614545:25615261,25614546:25617161,25614547:25615653,25614548:25617367,25614549:25615995,25614551:25616176,25614552:25616334,25614554:25616607,25614556:25616743,25614557:25616961,25614560:25617078,25614562:25617031,25614564:25616995,25614567:25616918,25614569:25617115,25614571:25616576,25614575:25616705,25614577:25616888,25614579:25616649,25616549:25616780,25617205:25617304,25621898:25624050,25621900:25625847,25621901:25623906,25621903:25623690,25621905:25623507,25621907:25623540,25621909:25623583,25621911:25623390,25621913:2562363', 'assoc_mat': '25592799:pet_clair:4230:25594308,25592800:pet_clair:4230:25594197,25592801:pet_clair:4230:25599446,25592802:pet_clair:4230:25594174,25592803:pet_clair:4230:25596570,25592804:pet_clair:4230:25603789,25592805:pet_clair:4230:25594029,25592807:pet_clair:4230:25594342,25592809:pet_clair:4230:25596366,25592811:pet_clair:4230:25603754,25592814:pet_clair:4230:25594068,25592817:pet_clair:4230:25593984,25592819:pet_clair:4230:25602272,25592822:pet_clair:4230:25599197,25592825:pet_clair:4230:25593834,25592827:pet_clair:4230:25603671,25592829:pet_clair:4230:25593911,25592832:pet_clair:4230:25593739,25592834:pet_clair:4230:25596291,25592835:pet_clair:4230:25592883,25592838:pet_clair:4230:25599045,25592839:pet_clair:4230:25593645,25594538:pet_clair:4230:25599882,25595244:pet_clair:4230:25598035,25614542:pet_clair:4230:25614833,25614543:pet_clair:4230:25614956,25614544:pet_clair:4230:25615140,25614545:pet_clair:4230:25615261,25614546:pet_clair:4230:25617161,25614547:pet_clair:4230:25615653,25614548:pet_clair:4230:25617367,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002532351342047139, 'nb_photo': 1397, 'list_port_cont': '25593977,25594075,25594199,25594310,25596362,25598037,25599047,25603666,25603757,25616178,25616648,25616711,25616894,25616930,25616998,25617029,25617113,25622963,25623173,25623253,25623273,25623276,25623351,25623383,25623508,25623575,25623640,25628793,25635487,25641113,25642763,25644427,25646092,25648260,25650214,25651469,25654284,25656702,25703876,25703967,25704189,25704263,25704332,25704391,25704677,25704703,25704998,25705115,25705182,25746318,25746492,25746812,25747170,25747533,25747607,25747832,25748062,25748498,25748756,25749063,25749303,25749402,25750100,25751422,25795138,25796435,25798635,25798732,25798844,25798878,25798913,25798986,25799061,25799078,25799133,25799172,25799203,25799269,25799446,25808671,25810756,25811460,25811885,25812691,25814030,25814736,25816063,25817241,25818149,25818741,25820923,25823199,25828700,25828829,25829004,25829282,25829484,25830230,25830402,25831609,25839816,25840154,25841508,25842658,25843336,25844475,25845214,25845955,25846441,25847478,25848130,25848800,25849481,2585002', 'assoc_port': '25592799:25594310,25592800:25594199,25592809:25596362,25592811:25603757,25592814:25594075,25592817:25593977,25592827:25603666,25592838:25599047,25595244:25598037,25614551:25616178,25614562:25617029,25614564:25616998,25614567:25616930,25614569:25617113,25614575:25616711,25614577:25616894,25614579:25616648,25621905:25623508,25621909:25623575,25621911:25623383,25621913:25623640,25621915:25623351,25621917:25623253,25621924:25623273,25621927:25623276,25621930:25623173,25621944:25622963,25628503:25628793,25634837:25635487,25640961:25641113,25642659:25642763,25644311:25644427,25645929:25646092,25648063:25648260,25649922:25650214,25651303:25651469,25653969:25654284,25656628:25656702,25703760:25705182,25703764:25705115,25703770:25704998,25703780:25704677,25703782:25704703,25703788:25704391,25703791:25704332,25703793:25704189,25703794:25704263,25703795:25703876,25703796:25703967,25746138:25750100,25746152:25749303,25746155:25749402,25746158:25748756,25746162:25748498,25746165:25747832,25746168:25748062,25746172:2574760', 'assoc_mat': '25592799:pet_fonce:4230:25594310,25592800:pet_fonce:4230:25594199,25592809:pet_fonce:4230:25596362,25592811:pet_fonce:4230:25603757,25592814:pet_fonce:4230:25594075,25592817:pet_fonce:4230:25593977,25592827:pet_fonce:4230:25603666,25592838:pet_fonce:4230:25599047,25595244:pet_fonce:4230:25598037,25614551:pet_fonce:4230:25616178,25614562:pet_fonce:4230:25617029,25614564:pet_fonce:4230:25616998,25614567:pet_fonce:4230:25616930,25614569:pet_fonce:4230:25617113,25614575:pet_fonce:4230:25616711,25614577:pet_fonce:4230:25616894,25614579:pet_fonce:4230:25616648,25621905:pet_fonce:4230:25623508,25621909:pet_fonce:4230:25623575,25621911:pet_fonce:4230:25623383,25621913:pet_fonce:4230:25623640,25621915:pet_fonce:4230:25623351,25621917:pet_fonce:4230:25623253,25621924:pet_fonce:4230:25623273,25621927:pet_fonce:4230:25623276,25621930:pet_fonce:4230:25623173,25621944:pet_fonce:4230:25622963,25628503:pet_fonce:4230:25628793,25634837:pet_fonce:4230:25635487,25640961:pet_fonce:4230:25641113,25642659:pet_fonce:4230:25642763,2'}), 'main_stat': {'nb_photos': 2543}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-08', 0.7646241383655079),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_08_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.12%', 21327], 'carton': ['carton', '4.66%', 104338], 'metal': ['metal', '0.11%', 2019], 'papier': ['papier', '19.28%', 571078], 'pehd': ['pehd', '0.37%', 2884], 'pet_clair': ['pet_clair', '1.64%', 25540], 'pet_fonce': ['pet_fonce', '0.25%', 1397]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_08_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.45user 2.65system 0:10.59elapsed 48%CPU (0avgtext+0avgdata 173832maxresident)k 5360inputs+280outputs (29major+45026minor)pagefaults 0swaps