python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-12 _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 : (0, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 12 mtr_id : dashboard_places : SCCU_cam8 date : 2025-12 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-12%') and created_at like '%2025-12%'))); nb_day : (0, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 12 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 12 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%122025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-12-01 : dt_date_just_month_year : 2025-12-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-12-01" AND ded.date <= "2025-12-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 (2684977,2689691,2697177,2703916,2710454,2722875,2714379,2715510,2719449,2725919,2744938,2738469,2742690,2743208,2748548,2754950,2761361,2768173,2774121,2777585,2778022,2783303,2788313,2794693,2799963,2805945,2809664,2810374,2815649,2822675,2829226) 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.02382505008679924, 'nb_photo': 30056, 'list_port_cont': '29034588,29034707,29034812,29038131,29038335,29040333,29042592,29043617,29046506,29049865,29049974,29050000,29090316,29090345,29090959,29091061,29091105,29091229,29091306,29091347,29091391,29096154,29096248,29096810,29113366,29113587,29113747,29114287,29114388,29114757,29115171,29115437,29115690,29115870,29115928,29115992,29116548,29116628,29117098,29117229,29117755,29117787,29118316,29118379,29118829,29119014,29119252,29122608,29160036,29160257,29160292,29160325,29160374,29160492,29160571,29160682,29160736,29160796,29160845,29160872,29160955,29160989,29161238,29161282,29161415,29161517,29161550,29161635,29161682,29161751,29162057,29164612,29195959,29201241,29203657,29203794,29203858,29203919,29204023,29204233,29204321,29206691,29206737,29206829,29206904,29206986,29207031,29207144,29207201,29207461,29207522,29208287,29208526,29237279,29237745,29237849,29237950,29237983,29238122,29238131,29238182,29238342,29238441,29238679,29238714,29238806,29238893,29238991,29239073,29239174,29239258,29239289,29239416,2923952', 'assoc_port': '29034547:29034588,29034548:29034707,29034793:29034812,29037836:29038131,29037837:29042592,29037838:29038335,29037839:29096810,29039886:29040333,29041923:29046506,29043410:29043617,29049700:29050000,29049701:29049974,29049703:29049865,29053134:29096248,29053135:29096154,29084518:29091347,29084538:29091391,29084541:29091306,29084543:29091229,29084546:29091105,29084564:29091061,29084567:29090959,29084584:29090345,29084588:29090316,29112739:29119252,29112742:29118316,29112745:29118829,29112749:29118379,29112767:29117787,29112772:29117755,29112776:29117229,29112781:29117098,29112785:29116548,29112788:29122608,29112808:29116628,29112827:29115870,29112829:29115992,29112830:29115690,29112833:29115437,29112847:29115171,29112861:29114757,29112863:29114287,29112865:29113747,29112866:29114388,29112868:29113366,29112870:29113587,29115422:29115928,29118207:29119014,29159958:29161751,29159961:29161682,29159964:29161550,29159967:29161635,29159970:29161517,29159973:29161282,29159974:29161415,29159978:29161238,29159980:2916087', 'assoc_mat': '29034547:autre:4230:29034588,29034548:autre:4230:29034707,29034793:autre:4230:29034812,29037836:autre:4230:29038131,29037837:autre:4230:29042592,29037838:autre:4230:29038335,29037839:autre:4230:29096810,29039886:autre:4230:29040333,29041923:autre:4230:29046506,29043410:autre:4230:29043617,29049700:autre:4230:29050000,29049701:autre:4230:29049974,29049703:autre:4230:29049865,29053134:autre:4230:29096248,29053135:autre:4230:29096154,29084518:autre:4230:29091347,29084538:autre:4230:29091391,29084541:autre:4230:29091306,29084543:autre:4230:29091229,29084546:autre:4230:29091105,29084564:autre:4230:29091061,29084567:autre:4230:29090959,29084584:autre:4230:29090345,29084588:autre:4230:29090316,29112739:autre:4230:29119252,29112742:autre:4230:29118316,29112745:autre:4230:29118829,29112749:autre:4230:29118379,29112767:autre:4230:29117787,29112772:autre:4230:29117755,29112776:autre:4230:29117229,29112781:autre:4230:29117098,29112785:autre:4230:29116548,29112788:autre:4230:29122608,29112808:autre:4230:29116628,29112827:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.10444436189783306, 'nb_photo': 178237, 'list_port_cont': '29034581,29034702,29034814,29038144,29038327,29040332,29042602,29043627,29046510,29049864,29049964,29050002,29090313,29090359,29090958,29091062,29091109,29091240,29091309,29091355,29091392,29096156,29096246,29096817,29113359,29113593,29113741,29114293,29114381,29114764,29115183,29115440,29115693,29115880,29115940,29115993,29116552,29116642,29117111,29117227,29117757,29117803,29118322,29118371,29118840,29119017,29119257,29122616,29160047,29160266,29160303,29160340,29160372,29160495,29160577,29160678,29160731,29160803,29160844,29160870,29160964,29160995,29161246,29161286,29161410,29161523,29161554,29161632,29161697,29161756,29162069,29164614,29195949,29201244,29203669,29203795,29203864,29203928,29204020,29204242,29204324,29206702,29206736,29206824,29206912,29206982,29207044,29207143,29207206,29207460,29207528,29208289,29208523,29237280,29237733,29237845,29237951,29237977,29238125,29238141,29238190,29238348,29238436,29238673,29238723,29238816,29238887,29239004,29239070,29239175,29239246,29239280,29239412,2923953', 'assoc_port': '29034547:29034581,29034548:29034702,29034793:29034814,29037836:29038144,29037837:29042602,29037838:29038327,29037839:29096817,29039886:29040332,29041923:29046510,29043410:29043627,29049700:29050002,29049701:29049964,29049703:29049864,29053134:29096246,29053135:29096156,29084518:29091355,29084538:29091392,29084541:29091309,29084543:29091240,29084546:29091109,29084564:29091062,29084567:29090958,29084584:29090359,29084588:29090313,29112739:29119257,29112742:29118322,29112745:29118840,29112749:29118371,29112767:29117803,29112772:29117757,29112776:29117227,29112781:29117111,29112785:29116552,29112788:29122616,29112808:29116642,29112827:29115880,29112829:29115993,29112830:29115693,29112833:29115440,29112847:29115183,29112861:29114764,29112863:29114293,29112865:29113741,29112866:29114381,29112868:29113359,29112870:29113593,29115422:29115940,29118207:29119017,29159958:29161756,29159961:29161697,29159964:29161554,29159967:29161632,29159970:29161523,29159973:29161286,29159974:29161410,29159978:29161246,29159980:2916087', 'assoc_mat': '29034547:carton:4230:29034581,29034548:carton:4230:29034702,29034793:carton:4230:29034814,29037836:carton:4230:29038144,29037837:carton:4230:29042602,29037838:carton:4230:29038327,29037839:carton:4230:29096817,29039886:carton:4230:29040332,29041923:carton:4230:29046510,29043410:carton:4230:29043627,29049700:carton:4230:29050002,29049701:carton:4230:29049964,29049703:carton:4230:29049864,29053134:carton:4230:29096246,29053135:carton:4230:29096156,29084518:carton:4230:29091355,29084538:carton:4230:29091392,29084541:carton:4230:29091309,29084543:carton:4230:29091240,29084546:carton:4230:29091109,29084564:carton:4230:29091062,29084567:carton:4230:29090958,29084584:carton:4230:29090359,29084588:carton:4230:29090313,29112739:carton:4230:29119257,29112742:carton:4230:29118322,29112745:carton:4230:29118840,29112749:carton:4230:29118371,29112767:carton:4230:29117803,29112772:carton:4230:29117757,29112776:carton:4230:29117227,29112781:carton:4230:29117111,29112785:carton:4230:29116552,29112788:carton:4230:29122616,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028106906516751112, 'nb_photo': 2988, 'list_port_cont': '29034565,29034705,29034815,29038130,29040321,29042585,29043611,29046509,29049854,29049972,29050001,29090307,29090360,29090961,29091064,29091097,29091235,29091348,29091385,29096151,29096247,29096815,29113365,29113603,29113740,29114386,29114749,29115163,29115433,29115679,29115867,29115939,29115995,29116562,29116640,29117095,29117221,29117760,29118319,29118362,29118835,29119022,29119258,29122617,29160050,29160258,29160290,29160364,29160505,29160585,29160683,29160721,29160801,29160843,29160873,29160947,29160991,29161240,29161269,29161411,29161518,29161544,29161629,29161695,29161742,29162070,29164591,29195957,29201247,29203673,29203797,29203862,29203920,29204013,29204237,29204328,29206688,29206732,29206817,29206907,29206973,29207034,29207138,29207192,29207462,29207523,29208294,29208521,29237281,29237741,29237853,29237948,29237979,29238136,29238144,29238183,29238356,29238425,29238672,29238719,29238807,29238879,29238998,29239062,29239183,29239252,29239294,29239409,29239519,29239597,29239665,29240032,29249379,2924945', 'assoc_port': '29034547:29034565,29034548:29034705,29034793:29034815,29037836:29038130,29037837:29042585,29037839:29096815,29039886:29040321,29041923:29046509,29043410:29043611,29049700:29050001,29049701:29049972,29049703:29049854,29053134:29096247,29053135:29096151,29084518:29091348,29084538:29091385,29084543:29091235,29084546:29091097,29084564:29091064,29084567:29090961,29084584:29090360,29084588:29090307,29112739:29119258,29112742:29118319,29112745:29118835,29112749:29118362,29112772:29117760,29112776:29117221,29112781:29117095,29112785:29116562,29112788:29122617,29112808:29116640,29112827:29115867,29112829:29115995,29112830:29115679,29112833:29115433,29112847:29115163,29112861:29114749,29112865:29113740,29112866:29114386,29112868:29113365,29112870:29113603,29115422:29115939,29118207:29119022,29159958:29161742,29159961:29161695,29159964:29161544,29159967:29161629,29159970:29161518,29159973:29161269,29159974:29161411,29159978:29161240,29159980:29160873,29159983:29160947,29159987:29160991,29159989:29160721,29159990:2916050', 'assoc_mat': '29034547:metal:4230:29034565,29034548:metal:4230:29034705,29034793:metal:4230:29034815,29037836:metal:4230:29038130,29037837:metal:4230:29042585,29037839:metal:4230:29096815,29039886:metal:4230:29040321,29041923:metal:4230:29046509,29043410:metal:4230:29043611,29049700:metal:4230:29050001,29049701:metal:4230:29049972,29049703:metal:4230:29049854,29053134:metal:4230:29096247,29053135:metal:4230:29096151,29084518:metal:4230:29091348,29084538:metal:4230:29091385,29084543:metal:4230:29091235,29084546:metal:4230:29091097,29084564:metal:4230:29091064,29084567:metal:4230:29090961,29084584:metal:4230:29090360,29084588:metal:4230:29090307,29112739:metal:4230:29119258,29112742:metal:4230:29118319,29112745:metal:4230:29118835,29112749:metal:4230:29118362,29112772:metal:4230:29117760,29112776:metal:4230:29117221,29112781:metal:4230:29117095,29112785:metal:4230:29116562,29112788:metal:4230:29122617,29112808:metal:4230:29116640,29112827:metal:4230:29115867,29112829:metal:4230:29115995,29112830:metal:4230:29115679,29112833:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3027453370820153, 'nb_photo': 525526, 'list_port_cont': '29034589,29034714,29034808,29038142,29038336,29040328,29042595,29043621,29046502,29049871,29049971,29050008,29090321,29090348,29090949,29091071,29091111,29091243,29091308,29091353,29091393,29096145,29096243,29096819,29113367,29113598,29113745,29114289,29114389,29114758,29115181,29115438,29115694,29115877,29115937,29115994,29116564,29116644,29117106,29117224,29117761,29117794,29118309,29118370,29118841,29119019,29119264,29122615,29160045,29160268,29160305,29160339,29160367,29160504,29160569,29160676,29160726,29160804,29160842,29160878,29160958,29160993,29161245,29161276,29161406,29161508,29161555,29161637,29161689,29161746,29162066,29164605,29195962,29201243,29203668,29203789,29203857,29203927,29204019,29204245,29204326,29206696,29206739,29206821,29206911,29206981,29207046,29207135,29207197,29207454,29207519,29208283,29208525,29237287,29237744,29237852,29237949,29237991,29238124,29238143,29238198,29238352,29238427,29238686,29238720,29238809,29238896,29238993,29239075,29239184,29239254,29239292,29239415,2923953', 'assoc_port': '29034547:29034589,29034548:29034714,29034793:29034808,29037836:29038142,29037837:29042595,29037838:29038336,29037839:29096819,29039886:29040328,29041923:29046502,29043410:29043621,29049700:29050008,29049701:29049971,29049703:29049871,29053134:29096243,29053135:29096145,29084518:29091353,29084538:29091393,29084541:29091308,29084543:29091243,29084546:29091111,29084564:29091071,29084567:29090949,29084584:29090348,29084588:29090321,29112739:29119264,29112742:29118309,29112745:29118841,29112749:29118370,29112767:29117794,29112772:29117761,29112776:29117224,29112781:29117106,29112785:29116564,29112788:29122615,29112808:29116644,29112827:29115877,29112829:29115994,29112830:29115694,29112833:29115438,29112847:29115181,29112861:29114758,29112863:29114289,29112865:29113745,29112866:29114389,29112868:29113367,29112870:29113598,29115422:29115937,29118207:29119019,29159958:29161746,29159961:29161689,29159964:29161555,29159967:29161637,29159970:29161508,29159973:29161276,29159974:29161406,29159978:29161245,29159980:2916087', 'assoc_mat': '29034547:papier:4230:29034589,29034548:papier:4230:29034714,29034793:papier:4230:29034808,29037836:papier:4230:29038142,29037837:papier:4230:29042595,29037838:papier:4230:29038336,29037839:papier:4230:29096819,29039886:papier:4230:29040328,29041923:papier:4230:29046502,29043410:papier:4230:29043621,29049700:papier:4230:29050008,29049701:papier:4230:29049971,29049703:papier:4230:29049871,29053134:papier:4230:29096243,29053135:papier:4230:29096145,29084518:papier:4230:29091353,29084538:papier:4230:29091393,29084541:papier:4230:29091308,29084543:papier:4230:29091243,29084546:papier:4230:29091111,29084564:papier:4230:29091071,29084567:papier:4230:29090949,29084584:papier:4230:29090348,29084588:papier:4230:29090321,29112739:papier:4230:29119264,29112742:papier:4230:29118309,29112745:papier:4230:29118841,29112749:papier:4230:29118370,29112767:papier:4230:29117794,29112772:papier:4230:29117761,29112776:papier:4230:29117224,29112781:papier:4230:29117106,29112785:papier:4230:29116564,29112788:papier:4230:29122615,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007011180503772047, 'nb_photo': 8002, 'list_port_cont': '29034577,29034713,29034807,29038135,29038342,29043624,29046500,29049869,29049961,29050007,29090312,29090357,29090951,29091075,29091110,29091242,29091311,29091346,29091386,29096149,29096256,29113368,29113596,29113754,29114281,29114382,29114762,29115185,29115442,29115685,29115866,29115989,29116556,29116631,29117108,29117223,29117758,29117797,29118317,29118378,29118843,29119027,29119253,29122611,29160049,29160263,29160299,29160334,29160380,29160491,29160587,29160668,29160724,29160808,29160833,29160883,29160961,29160998,29161241,29161279,29161414,29161512,29161553,29161622,29161693,29161759,29162072,29164597,29195947,29201239,29203670,29203790,29203867,29203916,29204022,29204235,29204329,29206701,29206729,29206826,29206905,29206979,29207045,29207147,29207200,29207458,29207525,29208291,29208528,29237286,29237738,29237851,29237944,29238128,29238142,29238192,29238346,29238439,29238684,29238716,29238818,29238888,29238997,29239068,29239185,29239257,29239286,29239419,29239525,29239602,29239669,29240033,29249395,2924944', 'assoc_port': '29034547:29034577,29034548:29034713,29034793:29034807,29037836:29038135,29037838:29038342,29041923:29046500,29043410:29043624,29049700:29050007,29049701:29049961,29049703:29049869,29053134:29096256,29053135:29096149,29084518:29091346,29084538:29091386,29084541:29091311,29084543:29091242,29084546:29091110,29084564:29091075,29084567:29090951,29084584:29090357,29084588:29090312,29112739:29119253,29112742:29118317,29112745:29118843,29112749:29118378,29112767:29117797,29112772:29117758,29112776:29117223,29112781:29117108,29112785:29116556,29112788:29122611,29112808:29116631,29112827:29115866,29112829:29115989,29112830:29115685,29112833:29115442,29112847:29115185,29112861:29114762,29112863:29114281,29112865:29113754,29112866:29114382,29112868:29113368,29112870:29113596,29118207:29119027,29159958:29161759,29159961:29161693,29159964:29161553,29159967:29161622,29159970:29161512,29159973:29161279,29159974:29161414,29159978:29161241,29159980:29160883,29159983:29160961,29159987:29160998,29159989:29160724,29159990:2916049', 'assoc_mat': '29034547:pehd:4230:29034577,29034548:pehd:4230:29034713,29034793:pehd:4230:29034807,29037836:pehd:4230:29038135,29037838:pehd:4230:29038342,29041923:pehd:4230:29046500,29043410:pehd:4230:29043624,29049700:pehd:4230:29050007,29049701:pehd:4230:29049961,29049703:pehd:4230:29049869,29053134:pehd:4230:29096256,29053135:pehd:4230:29096149,29084518:pehd:4230:29091346,29084538:pehd:4230:29091386,29084541:pehd:4230:29091311,29084543:pehd:4230:29091242,29084546:pehd:4230:29091110,29084564:pehd:4230:29091075,29084567:pehd:4230:29090951,29084584:pehd:4230:29090357,29084588:pehd:4230:29090312,29112739:pehd:4230:29119253,29112742:pehd:4230:29118317,29112745:pehd:4230:29118843,29112749:pehd:4230:29118378,29112767:pehd:4230:29117797,29112772:pehd:4230:29117758,29112776:pehd:4230:29117223,29112781:pehd:4230:29117108,29112785:pehd:4230:29116556,29112788:pehd:4230:29122611,29112808:pehd:4230:29116631,29112827:pehd:4230:29115866,29112829:pehd:4230:29115989,29112830:pehd:4230:29115685,29112833:pehd:4230:29115442,29112847:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01442302039860197, 'nb_photo': 36716, 'list_port_cont': '29034586,29034712,29034805,29038147,29038338,29040325,29042598,29043626,29046503,29049870,29049966,29050003,29090308,29090358,29090950,29091068,29091101,29091238,29091320,29091357,29091381,29096150,29096251,29096826,29113362,29113602,29113749,29114283,29114387,29114752,29115187,29115444,29115692,29115878,29115936,29115988,29116555,29116641,29117112,29117222,29117762,29117796,29118314,29118375,29118836,29119025,29119260,29122618,29160052,29160265,29160296,29160338,29160379,29160501,29160583,29160680,29160730,29160798,29160841,29160877,29160963,29160997,29161247,29161281,29161405,29161520,29161559,29161631,29161685,29161753,29162071,29164618,29195960,29201251,29203671,29203787,29203865,29203929,29204021,29204236,29204316,29206699,29206735,29206825,29206901,29206983,29207041,29207146,29207203,29207459,29207518,29208282,29208518,29237291,29237746,29237855,29237945,29237988,29238123,29238129,29238195,29238351,29238432,29238683,29238717,29238815,29238895,29238992,29239060,29239182,29239247,29239291,29239418,2923952', 'assoc_port': '29034547:29034586,29034548:29034712,29034793:29034805,29037836:29038147,29037837:29042598,29037838:29038338,29037839:29096826,29039886:29040325,29041923:29046503,29043410:29043626,29049700:29050003,29049701:29049966,29049703:29049870,29053134:29096251,29053135:29096150,29084518:29091357,29084538:29091381,29084541:29091320,29084543:29091238,29084546:29091101,29084564:29091068,29084567:29090950,29084584:29090358,29084588:29090308,29112739:29119260,29112742:29118314,29112745:29118836,29112749:29118375,29112767:29117796,29112772:29117762,29112776:29117222,29112781:29117112,29112785:29116555,29112788:29122618,29112808:29116641,29112827:29115878,29112829:29115988,29112830:29115692,29112833:29115444,29112847:29115187,29112861:29114752,29112863:29114283,29112865:29113749,29112866:29114387,29112868:29113362,29112870:29113602,29115422:29115936,29118207:29119025,29159958:29161753,29159961:29161685,29159964:29161559,29159967:29161631,29159970:29161520,29159973:29161281,29159974:29161405,29159978:29161247,29159980:2916087', 'assoc_mat': '29034547:pet_clair:4230:29034586,29034548:pet_clair:4230:29034712,29034793:pet_clair:4230:29034805,29037836:pet_clair:4230:29038147,29037837:pet_clair:4230:29042598,29037838:pet_clair:4230:29038338,29037839:pet_clair:4230:29096826,29039886:pet_clair:4230:29040325,29041923:pet_clair:4230:29046503,29043410:pet_clair:4230:29043626,29049700:pet_clair:4230:29050003,29049701:pet_clair:4230:29049966,29049703:pet_clair:4230:29049870,29053134:pet_clair:4230:29096251,29053135:pet_clair:4230:29096150,29084518:pet_clair:4230:29091357,29084538:pet_clair:4230:29091381,29084541:pet_clair:4230:29091320,29084543:pet_clair:4230:29091238,29084546:pet_clair:4230:29091101,29084564:pet_clair:4230:29091068,29084567:pet_clair:4230:29090950,29084584:pet_clair:4230:29090358,29084588:pet_clair:4230:29090308,29112739:pet_clair:4230:29119260,29112742:pet_clair:4230:29118314,29112745:pet_clair:4230:29118836,29112749:pet_clair:4230:29118375,29112767:pet_clair:4230:29117796,29112772:pet_clair:4230:29117762,29112776:pet_clair:4230:29117222,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006743745680824763, 'nb_photo': 2781, 'list_port_cont': '29034582,29034715,29034809,29038140,29040334,29043625,29046499,29049868,29049970,29050004,29090318,29090355,29090955,29091073,29091107,29091233,29091321,29091351,29091384,29096157,29096255,29096824,29113364,29113595,29113753,29114295,29114377,29114754,29115180,29115434,29115684,29115879,29115933,29115991,29116637,29117228,29117749,29117799,29118311,29118376,29118837,29119030,29119255,29122609,29160041,29160264,29160300,29160341,29160378,29160502,29160573,29160674,29160805,29160839,29160954,29161004,29161244,29161277,29161412,29161509,29161551,29161636,29161694,29161749,29162073,29164610,29201257,29203674,29203793,29203866,29203925,29204025,29204322,29206698,29206733,29206822,29206903,29206987,29207140,29207194,29207457,29207526,29208293,29208527,29237285,29237737,29238132,29238135,29238197,29238349,29238445,29238674,29238718,29238817,29238894,29239000,29239072,29239181,29239256,29239293,29239404,29239532,29239605,29240036,29249392,29249448,29249484,29249690,29249951,29250440,29250549,29250586,29250627,2925083', 'assoc_port': '29034547:29034582,29034548:29034715,29034793:29034809,29037836:29038140,29037839:29096824,29039886:29040334,29041923:29046499,29043410:29043625,29049700:29050004,29049701:29049970,29049703:29049868,29053134:29096255,29053135:29096157,29084518:29091351,29084538:29091384,29084541:29091321,29084543:29091233,29084546:29091107,29084564:29091073,29084567:29090955,29084584:29090355,29084588:29090318,29112739:29119255,29112742:29118311,29112745:29118837,29112749:29118376,29112767:29117799,29112772:29117749,29112776:29117228,29112788:29122609,29112808:29116637,29112827:29115879,29112829:29115991,29112830:29115684,29112833:29115434,29112847:29115180,29112861:29114754,29112863:29114295,29112865:29113753,29112866:29114377,29112868:29113364,29112870:29113595,29115422:29115933,29118207:29119030,29159958:29161749,29159961:29161694,29159964:29161551,29159967:29161636,29159970:29161509,29159973:29161277,29159974:29161412,29159978:29161244,29159983:29160954,29159987:29161004,29159990:29160502,29159993:29160805,29159995:2916083', 'assoc_mat': '29034547:pet_fonce:4230:29034582,29034548:pet_fonce:4230:29034715,29034793:pet_fonce:4230:29034809,29037836:pet_fonce:4230:29038140,29037839:pet_fonce:4230:29096824,29039886:pet_fonce:4230:29040334,29041923:pet_fonce:4230:29046499,29043410:pet_fonce:4230:29043625,29049700:pet_fonce:4230:29050004,29049701:pet_fonce:4230:29049970,29049703:pet_fonce:4230:29049868,29053134:pet_fonce:4230:29096255,29053135:pet_fonce:4230:29096157,29084518:pet_fonce:4230:29091351,29084538:pet_fonce:4230:29091384,29084541:pet_fonce:4230:29091321,29084543:pet_fonce:4230:29091233,29084546:pet_fonce:4230:29091107,29084564:pet_fonce:4230:29091073,29084567:pet_fonce:4230:29090955,29084584:pet_fonce:4230:29090355,29084588:pet_fonce:4230:29090318,29112739:pet_fonce:4230:29119255,29112742:pet_fonce:4230:29118311,29112745:pet_fonce:4230:29118837,29112749:pet_fonce:4230:29118376,29112767:pet_fonce:4230:29117799,29112772:pet_fonce:4230:29117749,29112776:pet_fonce:4230:29117228,29112788:pet_fonce:4230:29122609,29112808:pet_fonce:4230:29116637,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(2684977,2689691,2697177,2703916,2710454,2722875,2714379,2715510,2719449,2725919,2744938,2738469,2742690,2743208,2748548,2754950,2761361,2768173,2774121,2777585,2778022,2783303,2788313,2794693,2799963,2805945,2809664,2810374,2815649,2822675,2829226)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-12-01' and date <= '2025-12-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2413,),), 'unwanted_material_monthly_percentage': ((0.5652982074846754,),), 'material_repartition': (('incineration', 2413),), 'material_dict': {'incineration': 2413}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 12, 1), 0.7271904696091147, 2), (datetime.date(2025, 12, 2), 0.6572200518709879, 1), (datetime.date(2025, 12, 3), 0.6720229594692333, 4), (datetime.date(2025, 12, 4), 0.6248050959260681, 4), (datetime.date(2025, 12, 5), 0.5404423799495068, 3), (datetime.date(2025, 12, 6), 0.5450828055839572, 4), (datetime.date(2025, 12, 7), 0.627953516769156, 3), (datetime.date(2025, 12, 8), 0.7047457859670648, 1), (datetime.date(2025, 12, 9), 0.5128564272980599, 1), (datetime.date(2025, 12, 10), 0.516071255494798, 1), (datetime.date(2025, 12, 11), 0.5060195461242207, 3), (datetime.date(2025, 12, 12), 0.5472468820231575, 4), (datetime.date(2025, 12, 13), 0.5287786238342235, 4), (datetime.date(2025, 12, 14), 0.6230397079606531, 4), (datetime.date(2025, 12, 15), 0.7155931347382596, 4), (datetime.date(2025, 12, 16), 0.5531043425748933, 2), (datetime.date(2025, 12, 17), 0.518211066141437, 4), (datetime.date(2025, 12, 18), 0.44993162042436113, 4), (datetime.date(2025, 12, 19), 0.40818169495636186, 4), (datetime.date(2025, 12, 20), 0.3960867436740943, 3), (datetime.date(2025, 12, 21), 0.41741440940079627, 4), (datetime.date(2025, 12, 22), 0.5233507435546026, 4), (datetime.date(2025, 12, 23), 0.3965010108368137, 3), (datetime.date(2025, 12, 24), 0.5290996382762214, 3), (datetime.date(2025, 12, 25), 0.6999999034531119, 4), (datetime.date(2025, 12, 26), 0.6306700042594179, 4), (datetime.date(2025, 12, 27), 0.5882842596555364, 4), (datetime.date(2025, 12, 28), 0.6243870529440609, 3), (datetime.date(2025, 12, 29), 0.6629018470809372, 2), (datetime.date(2025, 12, 30), 0.5353666861235317, 4), (datetime.date(2025, 12, 31), 0.5506081527484349, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 12, 1), 0.7271904696091147, 2), (datetime.date(2025, 12, 2), 0.6572200518709879, 1), (datetime.date(2025, 12, 3), 0.6720229594692333, 4), (datetime.date(2025, 12, 4), 0.6248050959260681, 4), (datetime.date(2025, 12, 5), 0.5404423799495068, 3), (datetime.date(2025, 12, 6), 0.5450828055839572, 4), (datetime.date(2025, 12, 7), 0.627953516769156, 3), (datetime.date(2025, 12, 8), 0.7047457859670648, 1), (datetime.date(2025, 12, 9), 0.5128564272980599, 1), (datetime.date(2025, 12, 10), 0.516071255494798, 1), (datetime.date(2025, 12, 11), 0.5060195461242207, 3), (datetime.date(2025, 12, 12), 0.5472468820231575, 4), (datetime.date(2025, 12, 13), 0.5287786238342235, 4), (datetime.date(2025, 12, 14), 0.6230397079606531, 4), (datetime.date(2025, 12, 15), 0.7155931347382596, 4), (datetime.date(2025, 12, 16), 0.5531043425748933, 2), (datetime.date(2025, 12, 17), 0.518211066141437, 4), (datetime.date(2025, 12, 18), 0.44993162042436113, 4), (datetime.date(2025, 12, 19), 0.40818169495636186, 4), (datetime.date(2025, 12, 20), 0.3960867436740943, 3), (datetime.date(2025, 12, 21), 0.41741440940079627, 4), (datetime.date(2025, 12, 22), 0.5233507435546026, 4), (datetime.date(2025, 12, 23), 0.3965010108368137, 3), (datetime.date(2025, 12, 24), 0.5290996382762214, 3), (datetime.date(2025, 12, 25), 0.6999999034531119, 4), (datetime.date(2025, 12, 26), 0.6306700042594179, 4), (datetime.date(2025, 12, 27), 0.5882842596555364, 4), (datetime.date(2025, 12, 28), 0.6243870529440609, 3), (datetime.date(2025, 12, 29), 0.6629018470809372, 2), (datetime.date(2025, 12, 30), 0.5353666861235317, 4), (datetime.date(2025, 12, 31), 0.5506081527484349, 3))}, 'quality_array': [['-7.8672005711219795', '01122025'], ['-7.3660876453345905', '02122025'], ['-7.668686104097708', '03122025'], ['-7.942456594989139', '04122025'], ['-8.5214763972984', '05122025'], ['-8.6963553908759', '06122025'], ['-8.61921208170242', '07122025'], ['-8.715805332895899', '08122025'], ['-8.45438606059538', '09122025'], ['-8.414267179739458', '10122025'], ['-8.975324543608968', '11122025'], ['-9.131866817686124', '12122025'], ['-8.934778215422307', '13122025'], ['-8.886868218914916', '14122025'], ['-8.137408422250118', '15122025'], ['-8.37530142315747', '16122025'], ['-8.552437285363323', '17122025'], ['-8.235382741705479', '18122025'], ['-7.317652279560258', '19122025'], ['-7.319857515937351', '20122025'], ['-8.838074443259908', '21122025'], ['-8.71903677975604', '22122025'], ['-8.207590931335154', '23122025'], ['-8.562839165537694', '24122025'], ['-9.089795624413256', '25122025'], ['-8.739865832028435', '26122025'], ['-7.852546044848388', '27122025'], ['-8.023341469475346', '28122025'], ['-7.0464963251785075', '29122025'], ['-7.832819830956236', '30122025'], ['-8.524373766840798', '31122025']], 'number_of_batch': ((702,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02382505008679924, 'nb_photo': 30056, 'list_port_cont': '29034588,29034707,29034812,29038131,29038335,29040333,29042592,29043617,29046506,29049865,29049974,29050000,29090316,29090345,29090959,29091061,29091105,29091229,29091306,29091347,29091391,29096154,29096248,29096810,29113366,29113587,29113747,29114287,29114388,29114757,29115171,29115437,29115690,29115870,29115928,29115992,29116548,29116628,29117098,29117229,29117755,29117787,29118316,29118379,29118829,29119014,29119252,29122608,29160036,29160257,29160292,29160325,29160374,29160492,29160571,29160682,29160736,29160796,29160845,29160872,29160955,29160989,29161238,29161282,29161415,29161517,29161550,29161635,29161682,29161751,29162057,29164612,29195959,29201241,29203657,29203794,29203858,29203919,29204023,29204233,29204321,29206691,29206737,29206829,29206904,29206986,29207031,29207144,29207201,29207461,29207522,29208287,29208526,29237279,29237745,29237849,29237950,29237983,29238122,29238131,29238182,29238342,29238441,29238679,29238714,29238806,29238893,29238991,29239073,29239174,29239258,29239289,29239416,2923952', 'assoc_port': '29034547:29034588,29034548:29034707,29034793:29034812,29037836:29038131,29037837:29042592,29037838:29038335,29037839:29096810,29039886:29040333,29041923:29046506,29043410:29043617,29049700:29050000,29049701:29049974,29049703:29049865,29053134:29096248,29053135:29096154,29084518:29091347,29084538:29091391,29084541:29091306,29084543:29091229,29084546:29091105,29084564:29091061,29084567:29090959,29084584:29090345,29084588:29090316,29112739:29119252,29112742:29118316,29112745:29118829,29112749:29118379,29112767:29117787,29112772:29117755,29112776:29117229,29112781:29117098,29112785:29116548,29112788:29122608,29112808:29116628,29112827:29115870,29112829:29115992,29112830:29115690,29112833:29115437,29112847:29115171,29112861:29114757,29112863:29114287,29112865:29113747,29112866:29114388,29112868:29113366,29112870:29113587,29115422:29115928,29118207:29119014,29159958:29161751,29159961:29161682,29159964:29161550,29159967:29161635,29159970:29161517,29159973:29161282,29159974:29161415,29159978:29161238,29159980:2916087', 'assoc_mat': '29034547:autre:4230:29034588,29034548:autre:4230:29034707,29034793:autre:4230:29034812,29037836:autre:4230:29038131,29037837:autre:4230:29042592,29037838:autre:4230:29038335,29037839:autre:4230:29096810,29039886:autre:4230:29040333,29041923:autre:4230:29046506,29043410:autre:4230:29043617,29049700:autre:4230:29050000,29049701:autre:4230:29049974,29049703:autre:4230:29049865,29053134:autre:4230:29096248,29053135:autre:4230:29096154,29084518:autre:4230:29091347,29084538:autre:4230:29091391,29084541:autre:4230:29091306,29084543:autre:4230:29091229,29084546:autre:4230:29091105,29084564:autre:4230:29091061,29084567:autre:4230:29090959,29084584:autre:4230:29090345,29084588:autre:4230:29090316,29112739:autre:4230:29119252,29112742:autre:4230:29118316,29112745:autre:4230:29118829,29112749:autre:4230:29118379,29112767:autre:4230:29117787,29112772:autre:4230:29117755,29112776:autre:4230:29117229,29112781:autre:4230:29117098,29112785:autre:4230:29116548,29112788:autre:4230:29122608,29112808:autre:4230:29116628,29112827:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.10444436189783306, 'nb_photo': 178237, 'list_port_cont': '29034581,29034702,29034814,29038144,29038327,29040332,29042602,29043627,29046510,29049864,29049964,29050002,29090313,29090359,29090958,29091062,29091109,29091240,29091309,29091355,29091392,29096156,29096246,29096817,29113359,29113593,29113741,29114293,29114381,29114764,29115183,29115440,29115693,29115880,29115940,29115993,29116552,29116642,29117111,29117227,29117757,29117803,29118322,29118371,29118840,29119017,29119257,29122616,29160047,29160266,29160303,29160340,29160372,29160495,29160577,29160678,29160731,29160803,29160844,29160870,29160964,29160995,29161246,29161286,29161410,29161523,29161554,29161632,29161697,29161756,29162069,29164614,29195949,29201244,29203669,29203795,29203864,29203928,29204020,29204242,29204324,29206702,29206736,29206824,29206912,29206982,29207044,29207143,29207206,29207460,29207528,29208289,29208523,29237280,29237733,29237845,29237951,29237977,29238125,29238141,29238190,29238348,29238436,29238673,29238723,29238816,29238887,29239004,29239070,29239175,29239246,29239280,29239412,2923953', 'assoc_port': '29034547:29034581,29034548:29034702,29034793:29034814,29037836:29038144,29037837:29042602,29037838:29038327,29037839:29096817,29039886:29040332,29041923:29046510,29043410:29043627,29049700:29050002,29049701:29049964,29049703:29049864,29053134:29096246,29053135:29096156,29084518:29091355,29084538:29091392,29084541:29091309,29084543:29091240,29084546:29091109,29084564:29091062,29084567:29090958,29084584:29090359,29084588:29090313,29112739:29119257,29112742:29118322,29112745:29118840,29112749:29118371,29112767:29117803,29112772:29117757,29112776:29117227,29112781:29117111,29112785:29116552,29112788:29122616,29112808:29116642,29112827:29115880,29112829:29115993,29112830:29115693,29112833:29115440,29112847:29115183,29112861:29114764,29112863:29114293,29112865:29113741,29112866:29114381,29112868:29113359,29112870:29113593,29115422:29115940,29118207:29119017,29159958:29161756,29159961:29161697,29159964:29161554,29159967:29161632,29159970:29161523,29159973:29161286,29159974:29161410,29159978:29161246,29159980:2916087', 'assoc_mat': '29034547:carton:4230:29034581,29034548:carton:4230:29034702,29034793:carton:4230:29034814,29037836:carton:4230:29038144,29037837:carton:4230:29042602,29037838:carton:4230:29038327,29037839:carton:4230:29096817,29039886:carton:4230:29040332,29041923:carton:4230:29046510,29043410:carton:4230:29043627,29049700:carton:4230:29050002,29049701:carton:4230:29049964,29049703:carton:4230:29049864,29053134:carton:4230:29096246,29053135:carton:4230:29096156,29084518:carton:4230:29091355,29084538:carton:4230:29091392,29084541:carton:4230:29091309,29084543:carton:4230:29091240,29084546:carton:4230:29091109,29084564:carton:4230:29091062,29084567:carton:4230:29090958,29084584:carton:4230:29090359,29084588:carton:4230:29090313,29112739:carton:4230:29119257,29112742:carton:4230:29118322,29112745:carton:4230:29118840,29112749:carton:4230:29118371,29112767:carton:4230:29117803,29112772:carton:4230:29117757,29112776:carton:4230:29117227,29112781:carton:4230:29117111,29112785:carton:4230:29116552,29112788:carton:4230:29122616,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028106906516751112, 'nb_photo': 2988, 'list_port_cont': '29034565,29034705,29034815,29038130,29040321,29042585,29043611,29046509,29049854,29049972,29050001,29090307,29090360,29090961,29091064,29091097,29091235,29091348,29091385,29096151,29096247,29096815,29113365,29113603,29113740,29114386,29114749,29115163,29115433,29115679,29115867,29115939,29115995,29116562,29116640,29117095,29117221,29117760,29118319,29118362,29118835,29119022,29119258,29122617,29160050,29160258,29160290,29160364,29160505,29160585,29160683,29160721,29160801,29160843,29160873,29160947,29160991,29161240,29161269,29161411,29161518,29161544,29161629,29161695,29161742,29162070,29164591,29195957,29201247,29203673,29203797,29203862,29203920,29204013,29204237,29204328,29206688,29206732,29206817,29206907,29206973,29207034,29207138,29207192,29207462,29207523,29208294,29208521,29237281,29237741,29237853,29237948,29237979,29238136,29238144,29238183,29238356,29238425,29238672,29238719,29238807,29238879,29238998,29239062,29239183,29239252,29239294,29239409,29239519,29239597,29239665,29240032,29249379,2924945', 'assoc_port': '29034547:29034565,29034548:29034705,29034793:29034815,29037836:29038130,29037837:29042585,29037839:29096815,29039886:29040321,29041923:29046509,29043410:29043611,29049700:29050001,29049701:29049972,29049703:29049854,29053134:29096247,29053135:29096151,29084518:29091348,29084538:29091385,29084543:29091235,29084546:29091097,29084564:29091064,29084567:29090961,29084584:29090360,29084588:29090307,29112739:29119258,29112742:29118319,29112745:29118835,29112749:29118362,29112772:29117760,29112776:29117221,29112781:29117095,29112785:29116562,29112788:29122617,29112808:29116640,29112827:29115867,29112829:29115995,29112830:29115679,29112833:29115433,29112847:29115163,29112861:29114749,29112865:29113740,29112866:29114386,29112868:29113365,29112870:29113603,29115422:29115939,29118207:29119022,29159958:29161742,29159961:29161695,29159964:29161544,29159967:29161629,29159970:29161518,29159973:29161269,29159974:29161411,29159978:29161240,29159980:29160873,29159983:29160947,29159987:29160991,29159989:29160721,29159990:2916050', 'assoc_mat': '29034547:metal:4230:29034565,29034548:metal:4230:29034705,29034793:metal:4230:29034815,29037836:metal:4230:29038130,29037837:metal:4230:29042585,29037839:metal:4230:29096815,29039886:metal:4230:29040321,29041923:metal:4230:29046509,29043410:metal:4230:29043611,29049700:metal:4230:29050001,29049701:metal:4230:29049972,29049703:metal:4230:29049854,29053134:metal:4230:29096247,29053135:metal:4230:29096151,29084518:metal:4230:29091348,29084538:metal:4230:29091385,29084543:metal:4230:29091235,29084546:metal:4230:29091097,29084564:metal:4230:29091064,29084567:metal:4230:29090961,29084584:metal:4230:29090360,29084588:metal:4230:29090307,29112739:metal:4230:29119258,29112742:metal:4230:29118319,29112745:metal:4230:29118835,29112749:metal:4230:29118362,29112772:metal:4230:29117760,29112776:metal:4230:29117221,29112781:metal:4230:29117095,29112785:metal:4230:29116562,29112788:metal:4230:29122617,29112808:metal:4230:29116640,29112827:metal:4230:29115867,29112829:metal:4230:29115995,29112830:metal:4230:29115679,29112833:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3027453370820153, 'nb_photo': 525526, 'list_port_cont': '29034589,29034714,29034808,29038142,29038336,29040328,29042595,29043621,29046502,29049871,29049971,29050008,29090321,29090348,29090949,29091071,29091111,29091243,29091308,29091353,29091393,29096145,29096243,29096819,29113367,29113598,29113745,29114289,29114389,29114758,29115181,29115438,29115694,29115877,29115937,29115994,29116564,29116644,29117106,29117224,29117761,29117794,29118309,29118370,29118841,29119019,29119264,29122615,29160045,29160268,29160305,29160339,29160367,29160504,29160569,29160676,29160726,29160804,29160842,29160878,29160958,29160993,29161245,29161276,29161406,29161508,29161555,29161637,29161689,29161746,29162066,29164605,29195962,29201243,29203668,29203789,29203857,29203927,29204019,29204245,29204326,29206696,29206739,29206821,29206911,29206981,29207046,29207135,29207197,29207454,29207519,29208283,29208525,29237287,29237744,29237852,29237949,29237991,29238124,29238143,29238198,29238352,29238427,29238686,29238720,29238809,29238896,29238993,29239075,29239184,29239254,29239292,29239415,2923953', 'assoc_port': '29034547:29034589,29034548:29034714,29034793:29034808,29037836:29038142,29037837:29042595,29037838:29038336,29037839:29096819,29039886:29040328,29041923:29046502,29043410:29043621,29049700:29050008,29049701:29049971,29049703:29049871,29053134:29096243,29053135:29096145,29084518:29091353,29084538:29091393,29084541:29091308,29084543:29091243,29084546:29091111,29084564:29091071,29084567:29090949,29084584:29090348,29084588:29090321,29112739:29119264,29112742:29118309,29112745:29118841,29112749:29118370,29112767:29117794,29112772:29117761,29112776:29117224,29112781:29117106,29112785:29116564,29112788:29122615,29112808:29116644,29112827:29115877,29112829:29115994,29112830:29115694,29112833:29115438,29112847:29115181,29112861:29114758,29112863:29114289,29112865:29113745,29112866:29114389,29112868:29113367,29112870:29113598,29115422:29115937,29118207:29119019,29159958:29161746,29159961:29161689,29159964:29161555,29159967:29161637,29159970:29161508,29159973:29161276,29159974:29161406,29159978:29161245,29159980:2916087', 'assoc_mat': '29034547:papier:4230:29034589,29034548:papier:4230:29034714,29034793:papier:4230:29034808,29037836:papier:4230:29038142,29037837:papier:4230:29042595,29037838:papier:4230:29038336,29037839:papier:4230:29096819,29039886:papier:4230:29040328,29041923:papier:4230:29046502,29043410:papier:4230:29043621,29049700:papier:4230:29050008,29049701:papier:4230:29049971,29049703:papier:4230:29049871,29053134:papier:4230:29096243,29053135:papier:4230:29096145,29084518:papier:4230:29091353,29084538:papier:4230:29091393,29084541:papier:4230:29091308,29084543:papier:4230:29091243,29084546:papier:4230:29091111,29084564:papier:4230:29091071,29084567:papier:4230:29090949,29084584:papier:4230:29090348,29084588:papier:4230:29090321,29112739:papier:4230:29119264,29112742:papier:4230:29118309,29112745:papier:4230:29118841,29112749:papier:4230:29118370,29112767:papier:4230:29117794,29112772:papier:4230:29117761,29112776:papier:4230:29117224,29112781:papier:4230:29117106,29112785:papier:4230:29116564,29112788:papier:4230:29122615,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007011180503772047, 'nb_photo': 8002, 'list_port_cont': '29034577,29034713,29034807,29038135,29038342,29043624,29046500,29049869,29049961,29050007,29090312,29090357,29090951,29091075,29091110,29091242,29091311,29091346,29091386,29096149,29096256,29113368,29113596,29113754,29114281,29114382,29114762,29115185,29115442,29115685,29115866,29115989,29116556,29116631,29117108,29117223,29117758,29117797,29118317,29118378,29118843,29119027,29119253,29122611,29160049,29160263,29160299,29160334,29160380,29160491,29160587,29160668,29160724,29160808,29160833,29160883,29160961,29160998,29161241,29161279,29161414,29161512,29161553,29161622,29161693,29161759,29162072,29164597,29195947,29201239,29203670,29203790,29203867,29203916,29204022,29204235,29204329,29206701,29206729,29206826,29206905,29206979,29207045,29207147,29207200,29207458,29207525,29208291,29208528,29237286,29237738,29237851,29237944,29238128,29238142,29238192,29238346,29238439,29238684,29238716,29238818,29238888,29238997,29239068,29239185,29239257,29239286,29239419,29239525,29239602,29239669,29240033,29249395,2924944', 'assoc_port': '29034547:29034577,29034548:29034713,29034793:29034807,29037836:29038135,29037838:29038342,29041923:29046500,29043410:29043624,29049700:29050007,29049701:29049961,29049703:29049869,29053134:29096256,29053135:29096149,29084518:29091346,29084538:29091386,29084541:29091311,29084543:29091242,29084546:29091110,29084564:29091075,29084567:29090951,29084584:29090357,29084588:29090312,29112739:29119253,29112742:29118317,29112745:29118843,29112749:29118378,29112767:29117797,29112772:29117758,29112776:29117223,29112781:29117108,29112785:29116556,29112788:29122611,29112808:29116631,29112827:29115866,29112829:29115989,29112830:29115685,29112833:29115442,29112847:29115185,29112861:29114762,29112863:29114281,29112865:29113754,29112866:29114382,29112868:29113368,29112870:29113596,29118207:29119027,29159958:29161759,29159961:29161693,29159964:29161553,29159967:29161622,29159970:29161512,29159973:29161279,29159974:29161414,29159978:29161241,29159980:29160883,29159983:29160961,29159987:29160998,29159989:29160724,29159990:2916049', 'assoc_mat': '29034547:pehd:4230:29034577,29034548:pehd:4230:29034713,29034793:pehd:4230:29034807,29037836:pehd:4230:29038135,29037838:pehd:4230:29038342,29041923:pehd:4230:29046500,29043410:pehd:4230:29043624,29049700:pehd:4230:29050007,29049701:pehd:4230:29049961,29049703:pehd:4230:29049869,29053134:pehd:4230:29096256,29053135:pehd:4230:29096149,29084518:pehd:4230:29091346,29084538:pehd:4230:29091386,29084541:pehd:4230:29091311,29084543:pehd:4230:29091242,29084546:pehd:4230:29091110,29084564:pehd:4230:29091075,29084567:pehd:4230:29090951,29084584:pehd:4230:29090357,29084588:pehd:4230:29090312,29112739:pehd:4230:29119253,29112742:pehd:4230:29118317,29112745:pehd:4230:29118843,29112749:pehd:4230:29118378,29112767:pehd:4230:29117797,29112772:pehd:4230:29117758,29112776:pehd:4230:29117223,29112781:pehd:4230:29117108,29112785:pehd:4230:29116556,29112788:pehd:4230:29122611,29112808:pehd:4230:29116631,29112827:pehd:4230:29115866,29112829:pehd:4230:29115989,29112830:pehd:4230:29115685,29112833:pehd:4230:29115442,29112847:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01442302039860197, 'nb_photo': 36716, 'list_port_cont': '29034586,29034712,29034805,29038147,29038338,29040325,29042598,29043626,29046503,29049870,29049966,29050003,29090308,29090358,29090950,29091068,29091101,29091238,29091320,29091357,29091381,29096150,29096251,29096826,29113362,29113602,29113749,29114283,29114387,29114752,29115187,29115444,29115692,29115878,29115936,29115988,29116555,29116641,29117112,29117222,29117762,29117796,29118314,29118375,29118836,29119025,29119260,29122618,29160052,29160265,29160296,29160338,29160379,29160501,29160583,29160680,29160730,29160798,29160841,29160877,29160963,29160997,29161247,29161281,29161405,29161520,29161559,29161631,29161685,29161753,29162071,29164618,29195960,29201251,29203671,29203787,29203865,29203929,29204021,29204236,29204316,29206699,29206735,29206825,29206901,29206983,29207041,29207146,29207203,29207459,29207518,29208282,29208518,29237291,29237746,29237855,29237945,29237988,29238123,29238129,29238195,29238351,29238432,29238683,29238717,29238815,29238895,29238992,29239060,29239182,29239247,29239291,29239418,2923952', 'assoc_port': '29034547:29034586,29034548:29034712,29034793:29034805,29037836:29038147,29037837:29042598,29037838:29038338,29037839:29096826,29039886:29040325,29041923:29046503,29043410:29043626,29049700:29050003,29049701:29049966,29049703:29049870,29053134:29096251,29053135:29096150,29084518:29091357,29084538:29091381,29084541:29091320,29084543:29091238,29084546:29091101,29084564:29091068,29084567:29090950,29084584:29090358,29084588:29090308,29112739:29119260,29112742:29118314,29112745:29118836,29112749:29118375,29112767:29117796,29112772:29117762,29112776:29117222,29112781:29117112,29112785:29116555,29112788:29122618,29112808:29116641,29112827:29115878,29112829:29115988,29112830:29115692,29112833:29115444,29112847:29115187,29112861:29114752,29112863:29114283,29112865:29113749,29112866:29114387,29112868:29113362,29112870:29113602,29115422:29115936,29118207:29119025,29159958:29161753,29159961:29161685,29159964:29161559,29159967:29161631,29159970:29161520,29159973:29161281,29159974:29161405,29159978:29161247,29159980:2916087', 'assoc_mat': '29034547:pet_clair:4230:29034586,29034548:pet_clair:4230:29034712,29034793:pet_clair:4230:29034805,29037836:pet_clair:4230:29038147,29037837:pet_clair:4230:29042598,29037838:pet_clair:4230:29038338,29037839:pet_clair:4230:29096826,29039886:pet_clair:4230:29040325,29041923:pet_clair:4230:29046503,29043410:pet_clair:4230:29043626,29049700:pet_clair:4230:29050003,29049701:pet_clair:4230:29049966,29049703:pet_clair:4230:29049870,29053134:pet_clair:4230:29096251,29053135:pet_clair:4230:29096150,29084518:pet_clair:4230:29091357,29084538:pet_clair:4230:29091381,29084541:pet_clair:4230:29091320,29084543:pet_clair:4230:29091238,29084546:pet_clair:4230:29091101,29084564:pet_clair:4230:29091068,29084567:pet_clair:4230:29090950,29084584:pet_clair:4230:29090358,29084588:pet_clair:4230:29090308,29112739:pet_clair:4230:29119260,29112742:pet_clair:4230:29118314,29112745:pet_clair:4230:29118836,29112749:pet_clair:4230:29118375,29112767:pet_clair:4230:29117796,29112772:pet_clair:4230:29117762,29112776:pet_clair:4230:29117222,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006743745680824763, 'nb_photo': 2781, 'list_port_cont': '29034582,29034715,29034809,29038140,29040334,29043625,29046499,29049868,29049970,29050004,29090318,29090355,29090955,29091073,29091107,29091233,29091321,29091351,29091384,29096157,29096255,29096824,29113364,29113595,29113753,29114295,29114377,29114754,29115180,29115434,29115684,29115879,29115933,29115991,29116637,29117228,29117749,29117799,29118311,29118376,29118837,29119030,29119255,29122609,29160041,29160264,29160300,29160341,29160378,29160502,29160573,29160674,29160805,29160839,29160954,29161004,29161244,29161277,29161412,29161509,29161551,29161636,29161694,29161749,29162073,29164610,29201257,29203674,29203793,29203866,29203925,29204025,29204322,29206698,29206733,29206822,29206903,29206987,29207140,29207194,29207457,29207526,29208293,29208527,29237285,29237737,29238132,29238135,29238197,29238349,29238445,29238674,29238718,29238817,29238894,29239000,29239072,29239181,29239256,29239293,29239404,29239532,29239605,29240036,29249392,29249448,29249484,29249690,29249951,29250440,29250549,29250586,29250627,2925083', 'assoc_port': '29034547:29034582,29034548:29034715,29034793:29034809,29037836:29038140,29037839:29096824,29039886:29040334,29041923:29046499,29043410:29043625,29049700:29050004,29049701:29049970,29049703:29049868,29053134:29096255,29053135:29096157,29084518:29091351,29084538:29091384,29084541:29091321,29084543:29091233,29084546:29091107,29084564:29091073,29084567:29090955,29084584:29090355,29084588:29090318,29112739:29119255,29112742:29118311,29112745:29118837,29112749:29118376,29112767:29117799,29112772:29117749,29112776:29117228,29112788:29122609,29112808:29116637,29112827:29115879,29112829:29115991,29112830:29115684,29112833:29115434,29112847:29115180,29112861:29114754,29112863:29114295,29112865:29113753,29112866:29114377,29112868:29113364,29112870:29113595,29115422:29115933,29118207:29119030,29159958:29161749,29159961:29161694,29159964:29161551,29159967:29161636,29159970:29161509,29159973:29161277,29159974:29161412,29159978:29161244,29159983:29160954,29159987:29161004,29159990:29160502,29159993:29160805,29159995:2916083', 'assoc_mat': '29034547:pet_fonce:4230:29034582,29034548:pet_fonce:4230:29034715,29034793:pet_fonce:4230:29034809,29037836:pet_fonce:4230:29038140,29037839:pet_fonce:4230:29096824,29039886:pet_fonce:4230:29040334,29041923:pet_fonce:4230:29046499,29043410:pet_fonce:4230:29043625,29049700:pet_fonce:4230:29050004,29049701:pet_fonce:4230:29049970,29049703:pet_fonce:4230:29049868,29053134:pet_fonce:4230:29096255,29053135:pet_fonce:4230:29096157,29084518:pet_fonce:4230:29091351,29084538:pet_fonce:4230:29091384,29084541:pet_fonce:4230:29091321,29084543:pet_fonce:4230:29091233,29084546:pet_fonce:4230:29091107,29084564:pet_fonce:4230:29091073,29084567:pet_fonce:4230:29090955,29084584:pet_fonce:4230:29090355,29084588:pet_fonce:4230:29090318,29112739:pet_fonce:4230:29119255,29112742:pet_fonce:4230:29118311,29112745:pet_fonce:4230:29118837,29112749:pet_fonce:4230:29118376,29112767:pet_fonce:4230:29117799,29112772:pet_fonce:4230:29117749,29112776:pet_fonce:4230:29117228,29112788:pet_fonce:4230:29122609,29112808:pet_fonce:4230:29116637,2'}), 'main_stat': {'nb_photos': 2413}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-12', 0.5652982074846754),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2413,),), 'unwanted_material_monthly_percentage': ((0.5652982074846754,),), 'material_repartition': (('incineration', 2413),), 'material_dict': {'incineration': 2413}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 12, 1), 0.7271904696091147, 2), (datetime.date(2025, 12, 2), 0.6572200518709879, 1), (datetime.date(2025, 12, 3), 0.6720229594692333, 4), (datetime.date(2025, 12, 4), 0.6248050959260681, 4), (datetime.date(2025, 12, 5), 0.5404423799495068, 3), (datetime.date(2025, 12, 6), 0.5450828055839572, 4), (datetime.date(2025, 12, 7), 0.627953516769156, 3), (datetime.date(2025, 12, 8), 0.7047457859670648, 1), (datetime.date(2025, 12, 9), 0.5128564272980599, 1), (datetime.date(2025, 12, 10), 0.516071255494798, 1), (datetime.date(2025, 12, 11), 0.5060195461242207, 3), (datetime.date(2025, 12, 12), 0.5472468820231575, 4), (datetime.date(2025, 12, 13), 0.5287786238342235, 4), (datetime.date(2025, 12, 14), 0.6230397079606531, 4), (datetime.date(2025, 12, 15), 0.7155931347382596, 4), (datetime.date(2025, 12, 16), 0.5531043425748933, 2), (datetime.date(2025, 12, 17), 0.518211066141437, 4), (datetime.date(2025, 12, 18), 0.44993162042436113, 4), (datetime.date(2025, 12, 19), 0.40818169495636186, 4), (datetime.date(2025, 12, 20), 0.3960867436740943, 3), (datetime.date(2025, 12, 21), 0.41741440940079627, 4), (datetime.date(2025, 12, 22), 0.5233507435546026, 4), (datetime.date(2025, 12, 23), 0.3965010108368137, 3), (datetime.date(2025, 12, 24), 0.5290996382762214, 3), (datetime.date(2025, 12, 25), 0.6999999034531119, 4), (datetime.date(2025, 12, 26), 0.6306700042594179, 4), (datetime.date(2025, 12, 27), 0.5882842596555364, 4), (datetime.date(2025, 12, 28), 0.6243870529440609, 3), (datetime.date(2025, 12, 29), 0.6629018470809372, 2), (datetime.date(2025, 12, 30), 0.5353666861235317, 4), (datetime.date(2025, 12, 31), 0.5506081527484349, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 12, 1), 0.7271904696091147, 2), (datetime.date(2025, 12, 2), 0.6572200518709879, 1), (datetime.date(2025, 12, 3), 0.6720229594692333, 4), (datetime.date(2025, 12, 4), 0.6248050959260681, 4), (datetime.date(2025, 12, 5), 0.5404423799495068, 3), (datetime.date(2025, 12, 6), 0.5450828055839572, 4), (datetime.date(2025, 12, 7), 0.627953516769156, 3), (datetime.date(2025, 12, 8), 0.7047457859670648, 1), (datetime.date(2025, 12, 9), 0.5128564272980599, 1), (datetime.date(2025, 12, 10), 0.516071255494798, 1), (datetime.date(2025, 12, 11), 0.5060195461242207, 3), (datetime.date(2025, 12, 12), 0.5472468820231575, 4), (datetime.date(2025, 12, 13), 0.5287786238342235, 4), (datetime.date(2025, 12, 14), 0.6230397079606531, 4), (datetime.date(2025, 12, 15), 0.7155931347382596, 4), (datetime.date(2025, 12, 16), 0.5531043425748933, 2), (datetime.date(2025, 12, 17), 0.518211066141437, 4), (datetime.date(2025, 12, 18), 0.44993162042436113, 4), (datetime.date(2025, 12, 19), 0.40818169495636186, 4), (datetime.date(2025, 12, 20), 0.3960867436740943, 3), (datetime.date(2025, 12, 21), 0.41741440940079627, 4), (datetime.date(2025, 12, 22), 0.5233507435546026, 4), (datetime.date(2025, 12, 23), 0.3965010108368137, 3), (datetime.date(2025, 12, 24), 0.5290996382762214, 3), (datetime.date(2025, 12, 25), 0.6999999034531119, 4), (datetime.date(2025, 12, 26), 0.6306700042594179, 4), (datetime.date(2025, 12, 27), 0.5882842596555364, 4), (datetime.date(2025, 12, 28), 0.6243870529440609, 3), (datetime.date(2025, 12, 29), 0.6629018470809372, 2), (datetime.date(2025, 12, 30), 0.5353666861235317, 4), (datetime.date(2025, 12, 31), 0.5506081527484349, 3))}, 'quality_array': [['-7.8672005711219795', '01122025'], ['-7.3660876453345905', '02122025'], ['-7.668686104097708', '03122025'], ['-7.942456594989139', '04122025'], ['-8.5214763972984', '05122025'], ['-8.6963553908759', '06122025'], ['-8.61921208170242', '07122025'], ['-8.715805332895899', '08122025'], ['-8.45438606059538', '09122025'], ['-8.414267179739458', '10122025'], ['-8.975324543608968', '11122025'], ['-9.131866817686124', '12122025'], ['-8.934778215422307', '13122025'], ['-8.886868218914916', '14122025'], ['-8.137408422250118', '15122025'], ['-8.37530142315747', '16122025'], ['-8.552437285363323', '17122025'], ['-8.235382741705479', '18122025'], ['-7.317652279560258', '19122025'], ['-7.319857515937351', '20122025'], ['-8.838074443259908', '21122025'], ['-8.71903677975604', '22122025'], ['-8.207590931335154', '23122025'], ['-8.562839165537694', '24122025'], ['-9.089795624413256', '25122025'], ['-8.739865832028435', '26122025'], ['-7.852546044848388', '27122025'], ['-8.023341469475346', '28122025'], ['-7.0464963251785075', '29122025'], ['-7.832819830956236', '30122025'], ['-8.524373766840798', '31122025']], 'number_of_batch': ((702,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.02382505008679924, 'nb_photo': 30056, 'list_port_cont': '29034588,29034707,29034812,29038131,29038335,29040333,29042592,29043617,29046506,29049865,29049974,29050000,29090316,29090345,29090959,29091061,29091105,29091229,29091306,29091347,29091391,29096154,29096248,29096810,29113366,29113587,29113747,29114287,29114388,29114757,29115171,29115437,29115690,29115870,29115928,29115992,29116548,29116628,29117098,29117229,29117755,29117787,29118316,29118379,29118829,29119014,29119252,29122608,29160036,29160257,29160292,29160325,29160374,29160492,29160571,29160682,29160736,29160796,29160845,29160872,29160955,29160989,29161238,29161282,29161415,29161517,29161550,29161635,29161682,29161751,29162057,29164612,29195959,29201241,29203657,29203794,29203858,29203919,29204023,29204233,29204321,29206691,29206737,29206829,29206904,29206986,29207031,29207144,29207201,29207461,29207522,29208287,29208526,29237279,29237745,29237849,29237950,29237983,29238122,29238131,29238182,29238342,29238441,29238679,29238714,29238806,29238893,29238991,29239073,29239174,29239258,29239289,29239416,2923952', 'assoc_port': '29034547:29034588,29034548:29034707,29034793:29034812,29037836:29038131,29037837:29042592,29037838:29038335,29037839:29096810,29039886:29040333,29041923:29046506,29043410:29043617,29049700:29050000,29049701:29049974,29049703:29049865,29053134:29096248,29053135:29096154,29084518:29091347,29084538:29091391,29084541:29091306,29084543:29091229,29084546:29091105,29084564:29091061,29084567:29090959,29084584:29090345,29084588:29090316,29112739:29119252,29112742:29118316,29112745:29118829,29112749:29118379,29112767:29117787,29112772:29117755,29112776:29117229,29112781:29117098,29112785:29116548,29112788:29122608,29112808:29116628,29112827:29115870,29112829:29115992,29112830:29115690,29112833:29115437,29112847:29115171,29112861:29114757,29112863:29114287,29112865:29113747,29112866:29114388,29112868:29113366,29112870:29113587,29115422:29115928,29118207:29119014,29159958:29161751,29159961:29161682,29159964:29161550,29159967:29161635,29159970:29161517,29159973:29161282,29159974:29161415,29159978:29161238,29159980:2916087', 'assoc_mat': '29034547:autre:4230:29034588,29034548:autre:4230:29034707,29034793:autre:4230:29034812,29037836:autre:4230:29038131,29037837:autre:4230:29042592,29037838:autre:4230:29038335,29037839:autre:4230:29096810,29039886:autre:4230:29040333,29041923:autre:4230:29046506,29043410:autre:4230:29043617,29049700:autre:4230:29050000,29049701:autre:4230:29049974,29049703:autre:4230:29049865,29053134:autre:4230:29096248,29053135:autre:4230:29096154,29084518:autre:4230:29091347,29084538:autre:4230:29091391,29084541:autre:4230:29091306,29084543:autre:4230:29091229,29084546:autre:4230:29091105,29084564:autre:4230:29091061,29084567:autre:4230:29090959,29084584:autre:4230:29090345,29084588:autre:4230:29090316,29112739:autre:4230:29119252,29112742:autre:4230:29118316,29112745:autre:4230:29118829,29112749:autre:4230:29118379,29112767:autre:4230:29117787,29112772:autre:4230:29117755,29112776:autre:4230:29117229,29112781:autre:4230:29117098,29112785:autre:4230:29116548,29112788:autre:4230:29122608,29112808:autre:4230:29116628,29112827:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.10444436189783306, 'nb_photo': 178237, 'list_port_cont': '29034581,29034702,29034814,29038144,29038327,29040332,29042602,29043627,29046510,29049864,29049964,29050002,29090313,29090359,29090958,29091062,29091109,29091240,29091309,29091355,29091392,29096156,29096246,29096817,29113359,29113593,29113741,29114293,29114381,29114764,29115183,29115440,29115693,29115880,29115940,29115993,29116552,29116642,29117111,29117227,29117757,29117803,29118322,29118371,29118840,29119017,29119257,29122616,29160047,29160266,29160303,29160340,29160372,29160495,29160577,29160678,29160731,29160803,29160844,29160870,29160964,29160995,29161246,29161286,29161410,29161523,29161554,29161632,29161697,29161756,29162069,29164614,29195949,29201244,29203669,29203795,29203864,29203928,29204020,29204242,29204324,29206702,29206736,29206824,29206912,29206982,29207044,29207143,29207206,29207460,29207528,29208289,29208523,29237280,29237733,29237845,29237951,29237977,29238125,29238141,29238190,29238348,29238436,29238673,29238723,29238816,29238887,29239004,29239070,29239175,29239246,29239280,29239412,2923953', 'assoc_port': '29034547:29034581,29034548:29034702,29034793:29034814,29037836:29038144,29037837:29042602,29037838:29038327,29037839:29096817,29039886:29040332,29041923:29046510,29043410:29043627,29049700:29050002,29049701:29049964,29049703:29049864,29053134:29096246,29053135:29096156,29084518:29091355,29084538:29091392,29084541:29091309,29084543:29091240,29084546:29091109,29084564:29091062,29084567:29090958,29084584:29090359,29084588:29090313,29112739:29119257,29112742:29118322,29112745:29118840,29112749:29118371,29112767:29117803,29112772:29117757,29112776:29117227,29112781:29117111,29112785:29116552,29112788:29122616,29112808:29116642,29112827:29115880,29112829:29115993,29112830:29115693,29112833:29115440,29112847:29115183,29112861:29114764,29112863:29114293,29112865:29113741,29112866:29114381,29112868:29113359,29112870:29113593,29115422:29115940,29118207:29119017,29159958:29161756,29159961:29161697,29159964:29161554,29159967:29161632,29159970:29161523,29159973:29161286,29159974:29161410,29159978:29161246,29159980:2916087', 'assoc_mat': '29034547:carton:4230:29034581,29034548:carton:4230:29034702,29034793:carton:4230:29034814,29037836:carton:4230:29038144,29037837:carton:4230:29042602,29037838:carton:4230:29038327,29037839:carton:4230:29096817,29039886:carton:4230:29040332,29041923:carton:4230:29046510,29043410:carton:4230:29043627,29049700:carton:4230:29050002,29049701:carton:4230:29049964,29049703:carton:4230:29049864,29053134:carton:4230:29096246,29053135:carton:4230:29096156,29084518:carton:4230:29091355,29084538:carton:4230:29091392,29084541:carton:4230:29091309,29084543:carton:4230:29091240,29084546:carton:4230:29091109,29084564:carton:4230:29091062,29084567:carton:4230:29090958,29084584:carton:4230:29090359,29084588:carton:4230:29090313,29112739:carton:4230:29119257,29112742:carton:4230:29118322,29112745:carton:4230:29118840,29112749:carton:4230:29118371,29112767:carton:4230:29117803,29112772:carton:4230:29117757,29112776:carton:4230:29117227,29112781:carton:4230:29117111,29112785:carton:4230:29116552,29112788:carton:4230:29122616,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028106906516751112, 'nb_photo': 2988, 'list_port_cont': '29034565,29034705,29034815,29038130,29040321,29042585,29043611,29046509,29049854,29049972,29050001,29090307,29090360,29090961,29091064,29091097,29091235,29091348,29091385,29096151,29096247,29096815,29113365,29113603,29113740,29114386,29114749,29115163,29115433,29115679,29115867,29115939,29115995,29116562,29116640,29117095,29117221,29117760,29118319,29118362,29118835,29119022,29119258,29122617,29160050,29160258,29160290,29160364,29160505,29160585,29160683,29160721,29160801,29160843,29160873,29160947,29160991,29161240,29161269,29161411,29161518,29161544,29161629,29161695,29161742,29162070,29164591,29195957,29201247,29203673,29203797,29203862,29203920,29204013,29204237,29204328,29206688,29206732,29206817,29206907,29206973,29207034,29207138,29207192,29207462,29207523,29208294,29208521,29237281,29237741,29237853,29237948,29237979,29238136,29238144,29238183,29238356,29238425,29238672,29238719,29238807,29238879,29238998,29239062,29239183,29239252,29239294,29239409,29239519,29239597,29239665,29240032,29249379,2924945', 'assoc_port': '29034547:29034565,29034548:29034705,29034793:29034815,29037836:29038130,29037837:29042585,29037839:29096815,29039886:29040321,29041923:29046509,29043410:29043611,29049700:29050001,29049701:29049972,29049703:29049854,29053134:29096247,29053135:29096151,29084518:29091348,29084538:29091385,29084543:29091235,29084546:29091097,29084564:29091064,29084567:29090961,29084584:29090360,29084588:29090307,29112739:29119258,29112742:29118319,29112745:29118835,29112749:29118362,29112772:29117760,29112776:29117221,29112781:29117095,29112785:29116562,29112788:29122617,29112808:29116640,29112827:29115867,29112829:29115995,29112830:29115679,29112833:29115433,29112847:29115163,29112861:29114749,29112865:29113740,29112866:29114386,29112868:29113365,29112870:29113603,29115422:29115939,29118207:29119022,29159958:29161742,29159961:29161695,29159964:29161544,29159967:29161629,29159970:29161518,29159973:29161269,29159974:29161411,29159978:29161240,29159980:29160873,29159983:29160947,29159987:29160991,29159989:29160721,29159990:2916050', 'assoc_mat': '29034547:metal:4230:29034565,29034548:metal:4230:29034705,29034793:metal:4230:29034815,29037836:metal:4230:29038130,29037837:metal:4230:29042585,29037839:metal:4230:29096815,29039886:metal:4230:29040321,29041923:metal:4230:29046509,29043410:metal:4230:29043611,29049700:metal:4230:29050001,29049701:metal:4230:29049972,29049703:metal:4230:29049854,29053134:metal:4230:29096247,29053135:metal:4230:29096151,29084518:metal:4230:29091348,29084538:metal:4230:29091385,29084543:metal:4230:29091235,29084546:metal:4230:29091097,29084564:metal:4230:29091064,29084567:metal:4230:29090961,29084584:metal:4230:29090360,29084588:metal:4230:29090307,29112739:metal:4230:29119258,29112742:metal:4230:29118319,29112745:metal:4230:29118835,29112749:metal:4230:29118362,29112772:metal:4230:29117760,29112776:metal:4230:29117221,29112781:metal:4230:29117095,29112785:metal:4230:29116562,29112788:metal:4230:29122617,29112808:metal:4230:29116640,29112827:metal:4230:29115867,29112829:metal:4230:29115995,29112830:metal:4230:29115679,29112833:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3027453370820153, 'nb_photo': 525526, 'list_port_cont': '29034589,29034714,29034808,29038142,29038336,29040328,29042595,29043621,29046502,29049871,29049971,29050008,29090321,29090348,29090949,29091071,29091111,29091243,29091308,29091353,29091393,29096145,29096243,29096819,29113367,29113598,29113745,29114289,29114389,29114758,29115181,29115438,29115694,29115877,29115937,29115994,29116564,29116644,29117106,29117224,29117761,29117794,29118309,29118370,29118841,29119019,29119264,29122615,29160045,29160268,29160305,29160339,29160367,29160504,29160569,29160676,29160726,29160804,29160842,29160878,29160958,29160993,29161245,29161276,29161406,29161508,29161555,29161637,29161689,29161746,29162066,29164605,29195962,29201243,29203668,29203789,29203857,29203927,29204019,29204245,29204326,29206696,29206739,29206821,29206911,29206981,29207046,29207135,29207197,29207454,29207519,29208283,29208525,29237287,29237744,29237852,29237949,29237991,29238124,29238143,29238198,29238352,29238427,29238686,29238720,29238809,29238896,29238993,29239075,29239184,29239254,29239292,29239415,2923953', 'assoc_port': '29034547:29034589,29034548:29034714,29034793:29034808,29037836:29038142,29037837:29042595,29037838:29038336,29037839:29096819,29039886:29040328,29041923:29046502,29043410:29043621,29049700:29050008,29049701:29049971,29049703:29049871,29053134:29096243,29053135:29096145,29084518:29091353,29084538:29091393,29084541:29091308,29084543:29091243,29084546:29091111,29084564:29091071,29084567:29090949,29084584:29090348,29084588:29090321,29112739:29119264,29112742:29118309,29112745:29118841,29112749:29118370,29112767:29117794,29112772:29117761,29112776:29117224,29112781:29117106,29112785:29116564,29112788:29122615,29112808:29116644,29112827:29115877,29112829:29115994,29112830:29115694,29112833:29115438,29112847:29115181,29112861:29114758,29112863:29114289,29112865:29113745,29112866:29114389,29112868:29113367,29112870:29113598,29115422:29115937,29118207:29119019,29159958:29161746,29159961:29161689,29159964:29161555,29159967:29161637,29159970:29161508,29159973:29161276,29159974:29161406,29159978:29161245,29159980:2916087', 'assoc_mat': '29034547:papier:4230:29034589,29034548:papier:4230:29034714,29034793:papier:4230:29034808,29037836:papier:4230:29038142,29037837:papier:4230:29042595,29037838:papier:4230:29038336,29037839:papier:4230:29096819,29039886:papier:4230:29040328,29041923:papier:4230:29046502,29043410:papier:4230:29043621,29049700:papier:4230:29050008,29049701:papier:4230:29049971,29049703:papier:4230:29049871,29053134:papier:4230:29096243,29053135:papier:4230:29096145,29084518:papier:4230:29091353,29084538:papier:4230:29091393,29084541:papier:4230:29091308,29084543:papier:4230:29091243,29084546:papier:4230:29091111,29084564:papier:4230:29091071,29084567:papier:4230:29090949,29084584:papier:4230:29090348,29084588:papier:4230:29090321,29112739:papier:4230:29119264,29112742:papier:4230:29118309,29112745:papier:4230:29118841,29112749:papier:4230:29118370,29112767:papier:4230:29117794,29112772:papier:4230:29117761,29112776:papier:4230:29117224,29112781:papier:4230:29117106,29112785:papier:4230:29116564,29112788:papier:4230:29122615,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007011180503772047, 'nb_photo': 8002, 'list_port_cont': '29034577,29034713,29034807,29038135,29038342,29043624,29046500,29049869,29049961,29050007,29090312,29090357,29090951,29091075,29091110,29091242,29091311,29091346,29091386,29096149,29096256,29113368,29113596,29113754,29114281,29114382,29114762,29115185,29115442,29115685,29115866,29115989,29116556,29116631,29117108,29117223,29117758,29117797,29118317,29118378,29118843,29119027,29119253,29122611,29160049,29160263,29160299,29160334,29160380,29160491,29160587,29160668,29160724,29160808,29160833,29160883,29160961,29160998,29161241,29161279,29161414,29161512,29161553,29161622,29161693,29161759,29162072,29164597,29195947,29201239,29203670,29203790,29203867,29203916,29204022,29204235,29204329,29206701,29206729,29206826,29206905,29206979,29207045,29207147,29207200,29207458,29207525,29208291,29208528,29237286,29237738,29237851,29237944,29238128,29238142,29238192,29238346,29238439,29238684,29238716,29238818,29238888,29238997,29239068,29239185,29239257,29239286,29239419,29239525,29239602,29239669,29240033,29249395,2924944', 'assoc_port': '29034547:29034577,29034548:29034713,29034793:29034807,29037836:29038135,29037838:29038342,29041923:29046500,29043410:29043624,29049700:29050007,29049701:29049961,29049703:29049869,29053134:29096256,29053135:29096149,29084518:29091346,29084538:29091386,29084541:29091311,29084543:29091242,29084546:29091110,29084564:29091075,29084567:29090951,29084584:29090357,29084588:29090312,29112739:29119253,29112742:29118317,29112745:29118843,29112749:29118378,29112767:29117797,29112772:29117758,29112776:29117223,29112781:29117108,29112785:29116556,29112788:29122611,29112808:29116631,29112827:29115866,29112829:29115989,29112830:29115685,29112833:29115442,29112847:29115185,29112861:29114762,29112863:29114281,29112865:29113754,29112866:29114382,29112868:29113368,29112870:29113596,29118207:29119027,29159958:29161759,29159961:29161693,29159964:29161553,29159967:29161622,29159970:29161512,29159973:29161279,29159974:29161414,29159978:29161241,29159980:29160883,29159983:29160961,29159987:29160998,29159989:29160724,29159990:2916049', 'assoc_mat': '29034547:pehd:4230:29034577,29034548:pehd:4230:29034713,29034793:pehd:4230:29034807,29037836:pehd:4230:29038135,29037838:pehd:4230:29038342,29041923:pehd:4230:29046500,29043410:pehd:4230:29043624,29049700:pehd:4230:29050007,29049701:pehd:4230:29049961,29049703:pehd:4230:29049869,29053134:pehd:4230:29096256,29053135:pehd:4230:29096149,29084518:pehd:4230:29091346,29084538:pehd:4230:29091386,29084541:pehd:4230:29091311,29084543:pehd:4230:29091242,29084546:pehd:4230:29091110,29084564:pehd:4230:29091075,29084567:pehd:4230:29090951,29084584:pehd:4230:29090357,29084588:pehd:4230:29090312,29112739:pehd:4230:29119253,29112742:pehd:4230:29118317,29112745:pehd:4230:29118843,29112749:pehd:4230:29118378,29112767:pehd:4230:29117797,29112772:pehd:4230:29117758,29112776:pehd:4230:29117223,29112781:pehd:4230:29117108,29112785:pehd:4230:29116556,29112788:pehd:4230:29122611,29112808:pehd:4230:29116631,29112827:pehd:4230:29115866,29112829:pehd:4230:29115989,29112830:pehd:4230:29115685,29112833:pehd:4230:29115442,29112847:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01442302039860197, 'nb_photo': 36716, 'list_port_cont': '29034586,29034712,29034805,29038147,29038338,29040325,29042598,29043626,29046503,29049870,29049966,29050003,29090308,29090358,29090950,29091068,29091101,29091238,29091320,29091357,29091381,29096150,29096251,29096826,29113362,29113602,29113749,29114283,29114387,29114752,29115187,29115444,29115692,29115878,29115936,29115988,29116555,29116641,29117112,29117222,29117762,29117796,29118314,29118375,29118836,29119025,29119260,29122618,29160052,29160265,29160296,29160338,29160379,29160501,29160583,29160680,29160730,29160798,29160841,29160877,29160963,29160997,29161247,29161281,29161405,29161520,29161559,29161631,29161685,29161753,29162071,29164618,29195960,29201251,29203671,29203787,29203865,29203929,29204021,29204236,29204316,29206699,29206735,29206825,29206901,29206983,29207041,29207146,29207203,29207459,29207518,29208282,29208518,29237291,29237746,29237855,29237945,29237988,29238123,29238129,29238195,29238351,29238432,29238683,29238717,29238815,29238895,29238992,29239060,29239182,29239247,29239291,29239418,2923952', 'assoc_port': '29034547:29034586,29034548:29034712,29034793:29034805,29037836:29038147,29037837:29042598,29037838:29038338,29037839:29096826,29039886:29040325,29041923:29046503,29043410:29043626,29049700:29050003,29049701:29049966,29049703:29049870,29053134:29096251,29053135:29096150,29084518:29091357,29084538:29091381,29084541:29091320,29084543:29091238,29084546:29091101,29084564:29091068,29084567:29090950,29084584:29090358,29084588:29090308,29112739:29119260,29112742:29118314,29112745:29118836,29112749:29118375,29112767:29117796,29112772:29117762,29112776:29117222,29112781:29117112,29112785:29116555,29112788:29122618,29112808:29116641,29112827:29115878,29112829:29115988,29112830:29115692,29112833:29115444,29112847:29115187,29112861:29114752,29112863:29114283,29112865:29113749,29112866:29114387,29112868:29113362,29112870:29113602,29115422:29115936,29118207:29119025,29159958:29161753,29159961:29161685,29159964:29161559,29159967:29161631,29159970:29161520,29159973:29161281,29159974:29161405,29159978:29161247,29159980:2916087', 'assoc_mat': '29034547:pet_clair:4230:29034586,29034548:pet_clair:4230:29034712,29034793:pet_clair:4230:29034805,29037836:pet_clair:4230:29038147,29037837:pet_clair:4230:29042598,29037838:pet_clair:4230:29038338,29037839:pet_clair:4230:29096826,29039886:pet_clair:4230:29040325,29041923:pet_clair:4230:29046503,29043410:pet_clair:4230:29043626,29049700:pet_clair:4230:29050003,29049701:pet_clair:4230:29049966,29049703:pet_clair:4230:29049870,29053134:pet_clair:4230:29096251,29053135:pet_clair:4230:29096150,29084518:pet_clair:4230:29091357,29084538:pet_clair:4230:29091381,29084541:pet_clair:4230:29091320,29084543:pet_clair:4230:29091238,29084546:pet_clair:4230:29091101,29084564:pet_clair:4230:29091068,29084567:pet_clair:4230:29090950,29084584:pet_clair:4230:29090358,29084588:pet_clair:4230:29090308,29112739:pet_clair:4230:29119260,29112742:pet_clair:4230:29118314,29112745:pet_clair:4230:29118836,29112749:pet_clair:4230:29118375,29112767:pet_clair:4230:29117796,29112772:pet_clair:4230:29117762,29112776:pet_clair:4230:29117222,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006743745680824763, 'nb_photo': 2781, 'list_port_cont': '29034582,29034715,29034809,29038140,29040334,29043625,29046499,29049868,29049970,29050004,29090318,29090355,29090955,29091073,29091107,29091233,29091321,29091351,29091384,29096157,29096255,29096824,29113364,29113595,29113753,29114295,29114377,29114754,29115180,29115434,29115684,29115879,29115933,29115991,29116637,29117228,29117749,29117799,29118311,29118376,29118837,29119030,29119255,29122609,29160041,29160264,29160300,29160341,29160378,29160502,29160573,29160674,29160805,29160839,29160954,29161004,29161244,29161277,29161412,29161509,29161551,29161636,29161694,29161749,29162073,29164610,29201257,29203674,29203793,29203866,29203925,29204025,29204322,29206698,29206733,29206822,29206903,29206987,29207140,29207194,29207457,29207526,29208293,29208527,29237285,29237737,29238132,29238135,29238197,29238349,29238445,29238674,29238718,29238817,29238894,29239000,29239072,29239181,29239256,29239293,29239404,29239532,29239605,29240036,29249392,29249448,29249484,29249690,29249951,29250440,29250549,29250586,29250627,2925083', 'assoc_port': '29034547:29034582,29034548:29034715,29034793:29034809,29037836:29038140,29037839:29096824,29039886:29040334,29041923:29046499,29043410:29043625,29049700:29050004,29049701:29049970,29049703:29049868,29053134:29096255,29053135:29096157,29084518:29091351,29084538:29091384,29084541:29091321,29084543:29091233,29084546:29091107,29084564:29091073,29084567:29090955,29084584:29090355,29084588:29090318,29112739:29119255,29112742:29118311,29112745:29118837,29112749:29118376,29112767:29117799,29112772:29117749,29112776:29117228,29112788:29122609,29112808:29116637,29112827:29115879,29112829:29115991,29112830:29115684,29112833:29115434,29112847:29115180,29112861:29114754,29112863:29114295,29112865:29113753,29112866:29114377,29112868:29113364,29112870:29113595,29115422:29115933,29118207:29119030,29159958:29161749,29159961:29161694,29159964:29161551,29159967:29161636,29159970:29161509,29159973:29161277,29159974:29161412,29159978:29161244,29159983:29160954,29159987:29161004,29159990:29160502,29159993:29160805,29159995:2916083', 'assoc_mat': '29034547:pet_fonce:4230:29034582,29034548:pet_fonce:4230:29034715,29034793:pet_fonce:4230:29034809,29037836:pet_fonce:4230:29038140,29037839:pet_fonce:4230:29096824,29039886:pet_fonce:4230:29040334,29041923:pet_fonce:4230:29046499,29043410:pet_fonce:4230:29043625,29049700:pet_fonce:4230:29050004,29049701:pet_fonce:4230:29049970,29049703:pet_fonce:4230:29049868,29053134:pet_fonce:4230:29096255,29053135:pet_fonce:4230:29096157,29084518:pet_fonce:4230:29091351,29084538:pet_fonce:4230:29091384,29084541:pet_fonce:4230:29091321,29084543:pet_fonce:4230:29091233,29084546:pet_fonce:4230:29091107,29084564:pet_fonce:4230:29091073,29084567:pet_fonce:4230:29090955,29084584:pet_fonce:4230:29090355,29084588:pet_fonce:4230:29090318,29112739:pet_fonce:4230:29119255,29112742:pet_fonce:4230:29118311,29112745:pet_fonce:4230:29118837,29112749:pet_fonce:4230:29118376,29112767:pet_fonce:4230:29117799,29112772:pet_fonce:4230:29117749,29112776:pet_fonce:4230:29117228,29112788:pet_fonce:4230:29122609,29112808:pet_fonce:4230:29116637,2'}), 'main_stat': {'nb_photos': 2413}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-12', 0.5652982074846754),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_12_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.38%', 30056], 'carton': ['carton', '10.44%', 178237], 'metal': ['metal', '0.28%', 2988], 'papier': ['papier', '30.27%', 525526], 'pehd': ['pehd', '0.7%', 8002], 'pet_clair': ['pet_clair', '1.44%', 36716], 'pet_fonce': ['pet_fonce', '0.67%', 2781]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_12_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.52user 2.58system 0:08.80elapsed 57%CPU (0avgtext+0avgdata 183964maxresident)k 8inputs+288outputs (61major+48296minor)pagefaults 0swaps