python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 12 mtr_id : dashboard_places : SCCU_cam7 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_cam7' 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 = 204 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 = 204 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 = 204 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_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-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 (2685025,2689701,2697181,2703918,2710209,2722873,2722857,2716815,2719445,2725917,2735595,2739029,2742686,2743210,2748550,2754948,2761363,2768175,2774117,2777581,2778144,2782725,2788309,2794689,2799961,2805191,2809662,2810052) 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.014750656401364724, 'nb_photo': 14556, 'list_port_cont': '29034674,29034750,29034897,29034967,29038095,29038479,29039297,29042373,29044301,29050032,29050261,29050515,29050643,29053503,29053521,29085975,29086167,29086399,29086704,29087150,29087690,29092417,29093016,29112996,29113321,29113504,29113863,29114114,29114569,29114984,29115272,29115564,29116076,29116131,29116517,29116565,29116738,29117041,29117329,29117848,29117977,29118289,29118734,29118961,29119380,29124194,29124605,29160077,29160124,29160189,29160221,29160417,29160455,29160549,29160628,29160665,29160769,29160905,29161038,29161078,29161123,29161200,29161322,29161369,29161451,29161479,29161597,29162080,29164446,29165406,29166302,29198291,29198477,29198685,29200459,29200721,29200799,29200915,29201133,29201452,29201634,29201694,29201720,29201834,29201975,29202151,29202247,29202468,29202544,29202693,29202847,29203006,29203190,29203227,29203420,29237766,29237888,29238048,29238088,29238214,29238265,29238393,29238464,29238509,29238562,29238620,29238775,29238923,29238961,29239025,29239109,29239142,29239208,2923935', 'assoc_port': '29034545:29034750,29034546:29034674,29034792:29039297,29034854:29034897,29034951:29034967,29037834:29038479,29037835:29038095,29039887:29044301,29041924:29042373,29043379:29050515,29049662:29050643,29049680:29050261,29049698:29050032,29053189:29053521,29053191:29053503,29085008:29087690,29085011:29087150,29085012:29093016,29085015:29086704,29085036:29086399,29085039:29086167,29085053:29085975,29085065:29092417,29112740:29124605,29112743:29118289,29112746:29118961,29112748:29117977,29112765:29117329,29112771:29117848,29112775:29117041,29112780:29116565,29112784:29116738,29112789:29116517,29112807:29116131,29112826:29116076,29112828:29115564,29112831:29115272,29112832:29114984,29112846:29114569,29112860:29114114,29112862:29113863,29112864:29113504,29112867:29119380,29112869:29112996,29112871:29113321,29118222:29118734,29118225:29124194,29159957:29166302,29159960:29161451,29159963:29161597,29159966:29161369,29159968:29161479,29159971:29161322,29159976:29161123,29159977:29161200,29159981:29161078,29159984:2916103', 'assoc_mat': '29034545:autre:4230:29034750,29034546:autre:4230:29034674,29034792:autre:4230:29039297,29034854:autre:4230:29034897,29034951:autre:4230:29034967,29037834:autre:4230:29038479,29037835:autre:4230:29038095,29039887:autre:4230:29044301,29041924:autre:4230:29042373,29043379:autre:4230:29050515,29049662:autre:4230:29050643,29049680:autre:4230:29050261,29049698:autre:4230:29050032,29053189:autre:4230:29053521,29053191:autre:4230:29053503,29085008:autre:4230:29087690,29085011:autre:4230:29087150,29085012:autre:4230:29093016,29085015:autre:4230:29086704,29085036:autre:4230:29086399,29085039:autre:4230:29086167,29085053:autre:4230:29085975,29085065:autre:4230:29092417,29112740:autre:4230:29124605,29112743:autre:4230:29118289,29112746:autre:4230:29118961,29112748:autre:4230:29117977,29112765:autre:4230:29117329,29112771:autre:4230:29117848,29112775:autre:4230:29117041,29112780:autre:4230:29116565,29112784:autre:4230:29116738,29112789:autre:4230:29116517,29112807:autre:4230:29116131,29112826:autre:4230:29116076,29112828:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05210215011330301, 'nb_photo': 80914, 'list_port_cont': '29034667,29034740,29034910,29034965,29038099,29038482,29039300,29042358,29044299,29050037,29050260,29050512,29050652,29053508,29053528,29085984,29086175,29086392,29086712,29087161,29087689,29092428,29093020,29112986,29113325,29113499,29113874,29114115,29114575,29114994,29115281,29115552,29116081,29116134,29116507,29116577,29116731,29117049,29117325,29117863,29117978,29118288,29118747,29118964,29119378,29124200,29124606,29160076,29160117,29160196,29160230,29160425,29160464,29160543,29160624,29160657,29160768,29160917,29161051,29161080,29161131,29161211,29161321,29161371,29161447,29161482,29161584,29162096,29164454,29165398,29166313,29198302,29198478,29198689,29200464,29200725,29200813,29200921,29201134,29201456,29201636,29201682,29201733,29201844,29201978,29202137,29202256,29202460,29202548,29202696,29202855,29203010,29203194,29203228,29203415,29237780,29237889,29238052,29238089,29238204,29238264,29238390,29238451,29238521,29238558,29238615,29238780,29238931,29238967,29239040,29239103,29239149,29239215,2923937', 'assoc_port': '29034545:29034740,29034546:29034667,29034792:29039300,29034854:29034910,29034951:29034965,29037834:29038482,29037835:29038099,29039887:29044299,29041924:29042358,29043379:29050512,29049662:29050652,29049680:29050260,29049698:29050037,29053189:29053528,29053191:29053508,29085008:29087689,29085011:29087161,29085012:29093020,29085015:29086712,29085036:29086392,29085039:29086175,29085053:29085984,29085065:29092428,29112740:29124606,29112743:29118288,29112746:29118964,29112748:29117978,29112765:29117325,29112771:29117863,29112775:29117049,29112780:29116577,29112784:29116731,29112789:29116507,29112807:29116134,29112826:29116081,29112828:29115552,29112831:29115281,29112832:29114994,29112846:29114575,29112860:29114115,29112862:29113874,29112864:29113499,29112867:29119378,29112869:29112986,29112871:29113325,29118222:29118747,29118225:29124200,29159957:29166313,29159960:29161447,29159963:29161584,29159966:29161371,29159968:29161482,29159971:29161321,29159976:29161131,29159977:29161211,29159981:29161080,29159984:2916105', 'assoc_mat': '29034545:carton:4230:29034740,29034546:carton:4230:29034667,29034792:carton:4230:29039300,29034854:carton:4230:29034910,29034951:carton:4230:29034965,29037834:carton:4230:29038482,29037835:carton:4230:29038099,29039887:carton:4230:29044299,29041924:carton:4230:29042358,29043379:carton:4230:29050512,29049662:carton:4230:29050652,29049680:carton:4230:29050260,29049698:carton:4230:29050037,29053189:carton:4230:29053528,29053191:carton:4230:29053508,29085008:carton:4230:29087689,29085011:carton:4230:29087161,29085012:carton:4230:29093020,29085015:carton:4230:29086712,29085036:carton:4230:29086392,29085039:carton:4230:29086175,29085053:carton:4230:29085984,29085065:carton:4230:29092428,29112740:carton:4230:29124606,29112743:carton:4230:29118288,29112746:carton:4230:29118964,29112748:carton:4230:29117978,29112765:carton:4230:29117325,29112771:carton:4230:29117863,29112775:carton:4230:29117049,29112780:carton:4230:29116577,29112784:carton:4230:29116731,29112789:carton:4230:29116507,29112807:carton:4230:29116134,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018430164590232088, 'nb_photo': 1637, 'list_port_cont': '29034675,29034738,29034900,29034971,29038085,29038484,29039292,29042372,29044289,29050045,29050252,29050506,29050647,29053507,29053532,29086166,29086395,29086696,29087156,29087675,29092429,29093013,29112984,29113316,29113498,29113868,29114110,29114563,29114987,29115282,29115553,29116078,29116137,29116512,29116574,29116739,29117318,29117854,29118738,29118950,29119370,29160073,29160121,29160179,29160227,29160433,29160553,29160613,29160652,29160763,29160904,29161036,29161079,29161213,29161311,29161363,29161439,29161472,29161596,29162092,29164450,29165404,29166315,29198304,29198475,29198675,29200720,29200811,29200914,29201122,29201449,29201625,29201696,29201724,29201845,29201982,29202140,29202243,29202451,29202683,29202845,29202996,29203192,29203219,29203418,29237765,29237885,29238044,29238079,29238200,29238256,29238381,29238452,29238517,29238557,29238607,29238774,29238922,29238952,29239038,29239214,29239354,29239454,29240102,29266756,29266793,29266829,29266896,29267058,29267060,29267160,29267246,29267316,2926746', 'assoc_port': '29034545:29034738,29034546:29034675,29034792:29039292,29034854:29034900,29034951:29034971,29037834:29038484,29037835:29038085,29039887:29044289,29041924:29042372,29043379:29050506,29049662:29050647,29049680:29050252,29049698:29050045,29053189:29053532,29053191:29053507,29085008:29087675,29085011:29087156,29085012:29093013,29085015:29086696,29085036:29086395,29085039:29086166,29085065:29092429,29112746:29118950,29112765:29117318,29112771:29117854,29112780:29116574,29112784:29116739,29112789:29116512,29112807:29116137,29112826:29116078,29112828:29115553,29112831:29115282,29112832:29114987,29112846:29114563,29112860:29114110,29112862:29113868,29112864:29113498,29112867:29119370,29112869:29112984,29112871:29113316,29118222:29118738,29159957:29166315,29159960:29161439,29159963:29161596,29159966:29161363,29159968:29161472,29159971:29161311,29159977:29161213,29159981:29161079,29159984:29161036,29159986:29160904,29159988:29160763,29159991:29165404,29159992:29160652,29159994:29160613,29159997:29160553,29160001:2916043', 'assoc_mat': '29034545:metal:4230:29034738,29034546:metal:4230:29034675,29034792:metal:4230:29039292,29034854:metal:4230:29034900,29034951:metal:4230:29034971,29037834:metal:4230:29038484,29037835:metal:4230:29038085,29039887:metal:4230:29044289,29041924:metal:4230:29042372,29043379:metal:4230:29050506,29049662:metal:4230:29050647,29049680:metal:4230:29050252,29049698:metal:4230:29050045,29053189:metal:4230:29053532,29053191:metal:4230:29053507,29085008:metal:4230:29087675,29085011:metal:4230:29087156,29085012:metal:4230:29093013,29085015:metal:4230:29086696,29085036:metal:4230:29086395,29085039:metal:4230:29086166,29085065:metal:4230:29092429,29112746:metal:4230:29118950,29112765:metal:4230:29117318,29112771:metal:4230:29117854,29112780:metal:4230:29116574,29112784:metal:4230:29116739,29112789:metal:4230:29116512,29112807:metal:4230:29116137,29112826:metal:4230:29116078,29112828:metal:4230:29115553,29112831:metal:4230:29115282,29112832:metal:4230:29114987,29112846:metal:4230:29114563,29112860:metal:4230:29114110,29112862:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19763960725928464, 'nb_photo': 268698, 'list_port_cont': '29034679,29034737,29034907,29034975,29038096,29038472,29039303,29042366,29044304,29050043,29050262,29050517,29050640,29053511,29053529,29085982,29086165,29086390,29086698,29087165,29087688,29092431,29093029,29112998,29113326,29113505,29113875,29114123,29114579,29114988,29115278,29115563,29116087,29116127,29116518,29116572,29116734,29117047,29117330,29117851,29117966,29118304,29118751,29118957,29119385,29124189,29124598,29160081,29160115,29160192,29160220,29160429,29160465,29160556,29160623,29160673,29160772,29160919,29161048,29161073,29161130,29161212,29161313,29161376,29161435,29161485,29161586,29162083,29164448,29165403,29166308,29198300,29198480,29198687,29200450,29200719,29200802,29200929,29201121,29201450,29201632,29201690,29201729,29201846,29201981,29202150,29202255,29202462,29202545,29202684,29202854,29203005,29203183,29203225,29203422,29237779,29237892,29238040,29238080,29238209,29238259,29238391,29238462,29238518,29238553,29238612,29238782,29238929,29238966,29239033,29239114,29239138,29239217,2923937', 'assoc_port': '29034545:29034737,29034546:29034679,29034792:29039303,29034854:29034907,29034951:29034975,29037834:29038472,29037835:29038096,29039887:29044304,29041924:29042366,29043379:29050517,29049662:29050640,29049680:29050262,29049698:29050043,29053189:29053529,29053191:29053511,29085008:29087688,29085011:29087165,29085012:29093029,29085015:29086698,29085036:29086390,29085039:29086165,29085053:29085982,29085065:29092431,29112740:29124598,29112743:29118304,29112746:29118957,29112748:29117966,29112765:29117330,29112771:29117851,29112775:29117047,29112780:29116572,29112784:29116734,29112789:29116518,29112807:29116127,29112826:29116087,29112828:29115563,29112831:29115278,29112832:29114988,29112846:29114579,29112860:29114123,29112862:29113875,29112864:29113505,29112867:29119385,29112869:29112998,29112871:29113326,29118222:29118751,29118225:29124189,29159957:29166308,29159960:29161435,29159963:29161586,29159966:29161376,29159968:29161485,29159971:29161313,29159976:29161130,29159977:29161212,29159981:29161073,29159984:2916104', 'assoc_mat': '29034545:papier:4230:29034737,29034546:papier:4230:29034679,29034792:papier:4230:29039303,29034854:papier:4230:29034907,29034951:papier:4230:29034975,29037834:papier:4230:29038472,29037835:papier:4230:29038096,29039887:papier:4230:29044304,29041924:papier:4230:29042366,29043379:papier:4230:29050517,29049662:papier:4230:29050640,29049680:papier:4230:29050262,29049698:papier:4230:29050043,29053189:papier:4230:29053529,29053191:papier:4230:29053511,29085008:papier:4230:29087688,29085011:papier:4230:29087165,29085012:papier:4230:29093029,29085015:papier:4230:29086698,29085036:papier:4230:29086390,29085039:papier:4230:29086165,29085053:papier:4230:29085982,29085065:papier:4230:29092431,29112740:papier:4230:29124598,29112743:papier:4230:29118304,29112746:papier:4230:29118957,29112748:papier:4230:29117966,29112765:papier:4230:29117330,29112771:papier:4230:29117851,29112775:papier:4230:29117047,29112780:papier:4230:29116572,29112784:papier:4230:29116734,29112789:papier:4230:29116518,29112807:papier:4230:29116127,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003014884951011314, 'nb_photo': 1801, 'list_port_cont': '29034672,29034752,29038100,29039304,29042370,29044292,29050035,29050516,29050653,29053515,29053533,29085980,29086401,29086710,29087164,29087695,29092430,29093024,29112991,29113331,29113506,29113872,29114120,29114577,29114983,29115280,29115562,29116082,29116146,29116508,29116575,29116736,29117036,29117328,29117971,29118750,29119381,29124197,29124604,29160085,29160122,29160191,29160233,29160432,29160463,29160551,29160627,29160671,29160766,29160914,29161045,29161081,29161136,29161210,29161318,29161450,29161484,29161593,29162098,29164457,29165407,29166317,29198299,29198473,29198681,29200462,29200727,29200804,29200916,29201123,29201458,29201633,29201684,29201728,29201849,29201972,29202147,29202252,29202467,29202546,29202688,29202852,29203004,29203185,29203218,29203421,29237773,29237876,29238039,29238086,29238213,29238266,29238384,29238523,29238555,29238616,29238776,29238925,29238956,29239034,29239150,29239222,29239364,29239471,29239631,29240114,29266757,29266797,29266832,29266906,29267057,29267066,29267155,2926724', 'assoc_port': '29034545:29034752,29034546:29034672,29034792:29039304,29037835:29038100,29039887:29044292,29041924:29042370,29043379:29050516,29049662:29050653,29049698:29050035,29053189:29053533,29053191:29053515,29085008:29087695,29085011:29087164,29085012:29093024,29085015:29086710,29085036:29086401,29085053:29085980,29085065:29092430,29112740:29124604,29112748:29117971,29112765:29117328,29112775:29117036,29112780:29116575,29112784:29116736,29112789:29116508,29112807:29116146,29112826:29116082,29112828:29115562,29112831:29115280,29112832:29114983,29112846:29114577,29112860:29114120,29112862:29113872,29112864:29113506,29112867:29119381,29112869:29112991,29112871:29113331,29118222:29118750,29118225:29124197,29159957:29166317,29159960:29161450,29159963:29161593,29159968:29161484,29159971:29161318,29159976:29161136,29159977:29161210,29159981:29161081,29159984:29161045,29159986:29160914,29159988:29160766,29159991:29165407,29159992:29160671,29159994:29160627,29159997:29160551,29159999:29160463,29160001:29160432,29160003:2916008', 'assoc_mat': '29034545:pehd:4230:29034752,29034546:pehd:4230:29034672,29034792:pehd:4230:29039304,29037835:pehd:4230:29038100,29039887:pehd:4230:29044292,29041924:pehd:4230:29042370,29043379:pehd:4230:29050516,29049662:pehd:4230:29050653,29049698:pehd:4230:29050035,29053189:pehd:4230:29053533,29053191:pehd:4230:29053515,29085008:pehd:4230:29087695,29085011:pehd:4230:29087164,29085012:pehd:4230:29093024,29085015:pehd:4230:29086710,29085036:pehd:4230:29086401,29085053:pehd:4230:29085980,29085065:pehd:4230:29092430,29112740:pehd:4230:29124604,29112748:pehd:4230:29117971,29112765:pehd:4230:29117328,29112775:pehd:4230:29117036,29112780:pehd:4230:29116575,29112784:pehd:4230:29116736,29112789:pehd:4230:29116508,29112807:pehd:4230:29116146,29112826:pehd:4230:29116082,29112828:pehd:4230:29115562,29112831:pehd:4230:29115280,29112832:pehd:4230:29114983,29112846:pehd:4230:29114577,29112860:pehd:4230:29114120,29112862:pehd:4230:29113872,29112864:pehd:4230:29113506,29112867:pehd:4230:29119381,29112869:pehd:4230:29112991,29112871:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016739993503235597, 'nb_photo': 25421, 'list_port_cont': '29034673,29034745,29034904,29034964,29038101,29038477,29039296,29042362,29044295,29050048,29050264,29050518,29050646,29053514,29053526,29085977,29086177,29086396,29086708,29087163,29087691,29092426,29093027,29112999,29113333,29113494,29113880,29114113,29114574,29114992,29115284,29115560,29116090,29116135,29116514,29116578,29116727,29117046,29117332,29117861,29117973,29118303,29118740,29118951,29119377,29124201,29124595,29160080,29160113,29160195,29160225,29160426,29160468,29160552,29160617,29160653,29160767,29160918,29161046,29161088,29161129,29161206,29161320,29161367,29161449,29161483,29161598,29162090,29164455,29165400,29166314,29198303,29198484,29198680,29200460,29200729,29200812,29200923,29201132,29201459,29201622,29201692,29201730,29201837,29201968,29202148,29202258,29202458,29202550,29202695,29202850,29203009,29203191,29203234,29203411,29237777,29237883,29238049,29238081,29238211,29238257,29238387,29238460,29238524,29238556,29238622,29238781,29238932,29238968,29239035,29239110,29239144,29239219,2923936', 'assoc_port': '29034545:29034745,29034546:29034673,29034792:29039296,29034854:29034904,29034951:29034964,29037834:29038477,29037835:29038101,29039887:29044295,29041924:29042362,29043379:29050518,29049662:29050646,29049680:29050264,29049698:29050048,29053189:29053526,29053191:29053514,29085008:29087691,29085011:29087163,29085012:29093027,29085015:29086708,29085036:29086396,29085039:29086177,29085053:29085977,29085065:29092426,29112740:29124595,29112743:29118303,29112746:29118951,29112748:29117973,29112765:29117332,29112771:29117861,29112775:29117046,29112780:29116578,29112784:29116727,29112789:29116514,29112807:29116135,29112826:29116090,29112828:29115560,29112831:29115284,29112832:29114992,29112846:29114574,29112860:29114113,29112862:29113880,29112864:29113494,29112867:29119377,29112869:29112999,29112871:29113333,29118222:29118740,29118225:29124201,29159957:29166314,29159960:29161449,29159963:29161598,29159966:29161367,29159968:29161483,29159971:29161320,29159976:29161129,29159977:29161206,29159981:29161088,29159984:2916104', 'assoc_mat': '29034545:pet_clair:4230:29034745,29034546:pet_clair:4230:29034673,29034792:pet_clair:4230:29039296,29034854:pet_clair:4230:29034904,29034951:pet_clair:4230:29034964,29037834:pet_clair:4230:29038477,29037835:pet_clair:4230:29038101,29039887:pet_clair:4230:29044295,29041924:pet_clair:4230:29042362,29043379:pet_clair:4230:29050518,29049662:pet_clair:4230:29050646,29049680:pet_clair:4230:29050264,29049698:pet_clair:4230:29050048,29053189:pet_clair:4230:29053526,29053191:pet_clair:4230:29053514,29085008:pet_clair:4230:29087691,29085011:pet_clair:4230:29087163,29085012:pet_clair:4230:29093027,29085015:pet_clair:4230:29086708,29085036:pet_clair:4230:29086396,29085039:pet_clair:4230:29086177,29085053:pet_clair:4230:29085977,29085065:pet_clair:4230:29092426,29112740:pet_clair:4230:29124595,29112743:pet_clair:4230:29118303,29112746:pet_clair:4230:29118951,29112748:pet_clair:4230:29117973,29112765:pet_clair:4230:29117332,29112771:pet_clair:4230:29117861,29112775:pet_clair:4230:29117046,29112780:pet_clair:4230:29116578,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002552641072184844, 'nb_photo': 681, 'list_port_cont': '29034678,29034751,29042367,29044303,29050040,29050253,29050513,29050642,29053512,29085986,29086172,29086397,29087160,29087696,29112992,29113502,29113878,29114118,29114578,29114990,29115283,29115556,29116088,29116141,29116509,29116571,29116737,29117042,29117326,29117860,29117969,29118963,29119379,29124601,29160083,29160118,29160185,29160427,29160461,29160557,29160771,29161134,29161208,29161475,29165405,29198307,29198479,29198688,29200457,29200718,29200809,29200927,29201131,29201455,29201688,29201842,29201977,29202254,29203181,29203232,29203410,29237782,29237890,29238047,29238083,29238267,29238386,29238525,29238550,29238611,29238926,29238960,29239036,29239113,29239147,29239212,29239360,29239465,29239638,29266798,29266826,29266908,29267051,29267070,29267263,29267450,29267633,29280707,29282938,29282999,29283207,29283328,29283396,29284034,29298728,29298848,29300006,29300137,29300355,29300451,29300565,29300601,29300774,29300809,29301064,29301172,29301327,29301875,29302158,29302281,29302870,29303026,29303072,2930607', 'assoc_port': '29034545:29034751,29034546:29034678,29039887:29044303,29041924:29042367,29043379:29050513,29049662:29050642,29049680:29050253,29049698:29050040,29053191:29053512,29085008:29087696,29085011:29087160,29085036:29086397,29085039:29086172,29085053:29085986,29112740:29124601,29112746:29118963,29112748:29117969,29112765:29117326,29112771:29117860,29112775:29117042,29112780:29116571,29112784:29116737,29112789:29116509,29112807:29116141,29112826:29116088,29112828:29115556,29112831:29115283,29112832:29114990,29112846:29114578,29112860:29114118,29112862:29113878,29112864:29113502,29112867:29119379,29112869:29112992,29159968:29161475,29159976:29161134,29159977:29161208,29159988:29160771,29159991:29165405,29159997:29160557,29159999:29160461,29160001:29160427,29160003:29160083,29160004:29160185,29160006:29160118,29197827:29203232,29197836:29203181,29197864:29202254,29197879:29198479,29197898:29201977,29197902:29201842,29197943:29201131,29197945:29201688,29197959:29201455,29197973:29200718,29197974:29200809,29197975:2920045', 'assoc_mat': '29034545:pet_fonce:4230:29034751,29034546:pet_fonce:4230:29034678,29039887:pet_fonce:4230:29044303,29041924:pet_fonce:4230:29042367,29043379:pet_fonce:4230:29050513,29049662:pet_fonce:4230:29050642,29049680:pet_fonce:4230:29050253,29049698:pet_fonce:4230:29050040,29053191:pet_fonce:4230:29053512,29085008:pet_fonce:4230:29087696,29085011:pet_fonce:4230:29087160,29085036:pet_fonce:4230:29086397,29085039:pet_fonce:4230:29086172,29085053:pet_fonce:4230:29085986,29112740:pet_fonce:4230:29124601,29112746:pet_fonce:4230:29118963,29112748:pet_fonce:4230:29117969,29112765:pet_fonce:4230:29117326,29112771:pet_fonce:4230:29117860,29112775:pet_fonce:4230:29117042,29112780:pet_fonce:4230:29116571,29112784:pet_fonce:4230:29116737,29112789:pet_fonce:4230:29116509,29112807:pet_fonce:4230:29116141,29112826:pet_fonce:4230:29116088,29112828:pet_fonce:4230:29115556,29112831:pet_fonce:4230:29115283,29112832:pet_fonce:4230:29114990,29112846:pet_fonce:4230:29114578,29112860:pet_fonce:4230:29114118,29112862:pet_fonce:4230:29113878,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(2685025,2689701,2697181,2703918,2710209,2722873,2722857,2716815,2719445,2725917,2735595,2739029,2742686,2743210,2748550,2754948,2761363,2768175,2774117,2777581,2778144,2782725,2788309,2794689,2799961,2805191,2809662,2810052)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-12-01' and date <= '2025-12-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1470,),), 'unwanted_material_monthly_percentage': ((0.7265573334042384,),), 'material_repartition': (('incineration', 1470),), 'material_dict': {'incineration': 1470}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 12, 1), 0.7991406097146174, 4), (datetime.date(2025, 12, 2), 0.7766044811413638, 3), (datetime.date(2025, 12, 3), 0.7552502291355105, 4), (datetime.date(2025, 12, 4), 0.7059575365614557, 4), (datetime.date(2025, 12, 5), 0.7240667572972483, 4), (datetime.date(2025, 12, 6), 0.7128705547762423, 1), (datetime.date(2025, 12, 7), 0.7810618444655286, 3), (datetime.date(2025, 12, 8), 0.7829694295716922, 3), (datetime.date(2025, 12, 9), 0.7351813559506037, 2), (datetime.date(2025, 12, 10), 0.7340127614504104, 2), (datetime.date(2025, 12, 11), 0.7158706533544302, 3), (datetime.date(2025, 12, 12), 0.7342188531485805, 2), (datetime.date(2025, 12, 13), 0.7595071944807656, 1), (datetime.date(2025, 12, 14), 0.7927946125944331, 3), (datetime.date(2025, 12, 15), 0.8061593786338213, 2), (datetime.date(2025, 12, 16), 0.7565683321105436, 3), (datetime.date(2025, 12, 17), 0.678129043245445, 2), (datetime.date(2025, 12, 18), 0.6150280298556764, 2), (datetime.date(2025, 12, 19), 0.6225915927952439, 2), (datetime.date(2025, 12, 20), 0.6182208648665531, 2), (datetime.date(2025, 12, 21), 0.6584141346871943, 3), (datetime.date(2025, 12, 22), 0.7225944050913317, 3), (datetime.date(2025, 12, 23), 0.6894568297932241, 4), (datetime.date(2025, 12, 24), 0.6890741469929342, 2), (datetime.date(2025, 12, 25), 0.7390946427029729, 3), (datetime.date(2025, 12, 26), 0.7025782630869309, 2), (datetime.date(2025, 12, 27), 0.6961482035370977, 3), (datetime.date(2025, 12, 28), 0.7580801942037776, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 12, 1), 0.7991406097146174, 4), (datetime.date(2025, 12, 2), 0.7766044811413638, 3), (datetime.date(2025, 12, 3), 0.7552502291355105, 4), (datetime.date(2025, 12, 4), 0.7059575365614557, 4), (datetime.date(2025, 12, 5), 0.7240667572972483, 4), (datetime.date(2025, 12, 6), 0.7128705547762423, 1), (datetime.date(2025, 12, 7), 0.7810618444655286, 3), (datetime.date(2025, 12, 8), 0.7829694295716922, 3), (datetime.date(2025, 12, 9), 0.7351813559506037, 2), (datetime.date(2025, 12, 10), 0.7340127614504104, 2), (datetime.date(2025, 12, 11), 0.7158706533544302, 3), (datetime.date(2025, 12, 12), 0.7342188531485805, 2), (datetime.date(2025, 12, 13), 0.7595071944807656, 1), (datetime.date(2025, 12, 14), 0.7927946125944331, 3), (datetime.date(2025, 12, 15), 0.8061593786338213, 2), (datetime.date(2025, 12, 16), 0.7565683321105436, 3), (datetime.date(2025, 12, 17), 0.678129043245445, 2), (datetime.date(2025, 12, 18), 0.6150280298556764, 2), (datetime.date(2025, 12, 19), 0.6225915927952439, 2), (datetime.date(2025, 12, 20), 0.6182208648665531, 2), (datetime.date(2025, 12, 21), 0.6584141346871943, 3), (datetime.date(2025, 12, 22), 0.7225944050913317, 3), (datetime.date(2025, 12, 23), 0.6894568297932241, 4), (datetime.date(2025, 12, 24), 0.6890741469929342, 2), (datetime.date(2025, 12, 25), 0.7390946427029729, 3), (datetime.date(2025, 12, 26), 0.7025782630869309, 2), (datetime.date(2025, 12, 27), 0.6961482035370977, 3), (datetime.date(2025, 12, 28), 0.7580801942037776, 2))}, 'quality_array': [['-7.682430174907037', '01122025'], ['-7.557092364818838', '02122025'], ['-7.526345331926031', '03122025'], ['-7.496614290929725', '04122025'], ['-7.4819908252650595', '05122025'], ['-7.39880688651016', '06122025'], ['-7.578154971686454', '07122025'], ['-7.658025740586917', '08122025'], ['-7.724860418573609', '09122025'], ['-7.611383403513108', '10122025'], ['-7.770407003079782', '11122025'], ['-7.799647169684124', '12122025'], ['-7.631641453405841', '13122025'], ['-7.628609355308779', '14122025'], ['-6.760027355007995', '15122025'], ['-6.884467298210814', '16122025'], ['-7.432684860547826', '17122025'], ['-7.482884108187042', '18122025'], ['-7.6357286511413776', '19122025'], ['-7.800146272276386', '20122025'], ['-7.8316245132529785', '21122025'], ['-7.395501337472362', '22122025'], ['-7.3643357539797885', '23122025'], ['-7.739867521905735', '24122025'], ['-7.789284877536598', '25122025'], ['-7.489031929892119', '26122025'], ['-7.235348918487337', '27122025'], ['-7.228731895146129', '28122025']], 'number_of_batch': ((577,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014750656401364724, 'nb_photo': 14556, 'list_port_cont': '29034674,29034750,29034897,29034967,29038095,29038479,29039297,29042373,29044301,29050032,29050261,29050515,29050643,29053503,29053521,29085975,29086167,29086399,29086704,29087150,29087690,29092417,29093016,29112996,29113321,29113504,29113863,29114114,29114569,29114984,29115272,29115564,29116076,29116131,29116517,29116565,29116738,29117041,29117329,29117848,29117977,29118289,29118734,29118961,29119380,29124194,29124605,29160077,29160124,29160189,29160221,29160417,29160455,29160549,29160628,29160665,29160769,29160905,29161038,29161078,29161123,29161200,29161322,29161369,29161451,29161479,29161597,29162080,29164446,29165406,29166302,29198291,29198477,29198685,29200459,29200721,29200799,29200915,29201133,29201452,29201634,29201694,29201720,29201834,29201975,29202151,29202247,29202468,29202544,29202693,29202847,29203006,29203190,29203227,29203420,29237766,29237888,29238048,29238088,29238214,29238265,29238393,29238464,29238509,29238562,29238620,29238775,29238923,29238961,29239025,29239109,29239142,29239208,2923935', 'assoc_port': '29034545:29034750,29034546:29034674,29034792:29039297,29034854:29034897,29034951:29034967,29037834:29038479,29037835:29038095,29039887:29044301,29041924:29042373,29043379:29050515,29049662:29050643,29049680:29050261,29049698:29050032,29053189:29053521,29053191:29053503,29085008:29087690,29085011:29087150,29085012:29093016,29085015:29086704,29085036:29086399,29085039:29086167,29085053:29085975,29085065:29092417,29112740:29124605,29112743:29118289,29112746:29118961,29112748:29117977,29112765:29117329,29112771:29117848,29112775:29117041,29112780:29116565,29112784:29116738,29112789:29116517,29112807:29116131,29112826:29116076,29112828:29115564,29112831:29115272,29112832:29114984,29112846:29114569,29112860:29114114,29112862:29113863,29112864:29113504,29112867:29119380,29112869:29112996,29112871:29113321,29118222:29118734,29118225:29124194,29159957:29166302,29159960:29161451,29159963:29161597,29159966:29161369,29159968:29161479,29159971:29161322,29159976:29161123,29159977:29161200,29159981:29161078,29159984:2916103', 'assoc_mat': '29034545:autre:4230:29034750,29034546:autre:4230:29034674,29034792:autre:4230:29039297,29034854:autre:4230:29034897,29034951:autre:4230:29034967,29037834:autre:4230:29038479,29037835:autre:4230:29038095,29039887:autre:4230:29044301,29041924:autre:4230:29042373,29043379:autre:4230:29050515,29049662:autre:4230:29050643,29049680:autre:4230:29050261,29049698:autre:4230:29050032,29053189:autre:4230:29053521,29053191:autre:4230:29053503,29085008:autre:4230:29087690,29085011:autre:4230:29087150,29085012:autre:4230:29093016,29085015:autre:4230:29086704,29085036:autre:4230:29086399,29085039:autre:4230:29086167,29085053:autre:4230:29085975,29085065:autre:4230:29092417,29112740:autre:4230:29124605,29112743:autre:4230:29118289,29112746:autre:4230:29118961,29112748:autre:4230:29117977,29112765:autre:4230:29117329,29112771:autre:4230:29117848,29112775:autre:4230:29117041,29112780:autre:4230:29116565,29112784:autre:4230:29116738,29112789:autre:4230:29116517,29112807:autre:4230:29116131,29112826:autre:4230:29116076,29112828:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05210215011330301, 'nb_photo': 80914, 'list_port_cont': '29034667,29034740,29034910,29034965,29038099,29038482,29039300,29042358,29044299,29050037,29050260,29050512,29050652,29053508,29053528,29085984,29086175,29086392,29086712,29087161,29087689,29092428,29093020,29112986,29113325,29113499,29113874,29114115,29114575,29114994,29115281,29115552,29116081,29116134,29116507,29116577,29116731,29117049,29117325,29117863,29117978,29118288,29118747,29118964,29119378,29124200,29124606,29160076,29160117,29160196,29160230,29160425,29160464,29160543,29160624,29160657,29160768,29160917,29161051,29161080,29161131,29161211,29161321,29161371,29161447,29161482,29161584,29162096,29164454,29165398,29166313,29198302,29198478,29198689,29200464,29200725,29200813,29200921,29201134,29201456,29201636,29201682,29201733,29201844,29201978,29202137,29202256,29202460,29202548,29202696,29202855,29203010,29203194,29203228,29203415,29237780,29237889,29238052,29238089,29238204,29238264,29238390,29238451,29238521,29238558,29238615,29238780,29238931,29238967,29239040,29239103,29239149,29239215,2923937', 'assoc_port': '29034545:29034740,29034546:29034667,29034792:29039300,29034854:29034910,29034951:29034965,29037834:29038482,29037835:29038099,29039887:29044299,29041924:29042358,29043379:29050512,29049662:29050652,29049680:29050260,29049698:29050037,29053189:29053528,29053191:29053508,29085008:29087689,29085011:29087161,29085012:29093020,29085015:29086712,29085036:29086392,29085039:29086175,29085053:29085984,29085065:29092428,29112740:29124606,29112743:29118288,29112746:29118964,29112748:29117978,29112765:29117325,29112771:29117863,29112775:29117049,29112780:29116577,29112784:29116731,29112789:29116507,29112807:29116134,29112826:29116081,29112828:29115552,29112831:29115281,29112832:29114994,29112846:29114575,29112860:29114115,29112862:29113874,29112864:29113499,29112867:29119378,29112869:29112986,29112871:29113325,29118222:29118747,29118225:29124200,29159957:29166313,29159960:29161447,29159963:29161584,29159966:29161371,29159968:29161482,29159971:29161321,29159976:29161131,29159977:29161211,29159981:29161080,29159984:2916105', 'assoc_mat': '29034545:carton:4230:29034740,29034546:carton:4230:29034667,29034792:carton:4230:29039300,29034854:carton:4230:29034910,29034951:carton:4230:29034965,29037834:carton:4230:29038482,29037835:carton:4230:29038099,29039887:carton:4230:29044299,29041924:carton:4230:29042358,29043379:carton:4230:29050512,29049662:carton:4230:29050652,29049680:carton:4230:29050260,29049698:carton:4230:29050037,29053189:carton:4230:29053528,29053191:carton:4230:29053508,29085008:carton:4230:29087689,29085011:carton:4230:29087161,29085012:carton:4230:29093020,29085015:carton:4230:29086712,29085036:carton:4230:29086392,29085039:carton:4230:29086175,29085053:carton:4230:29085984,29085065:carton:4230:29092428,29112740:carton:4230:29124606,29112743:carton:4230:29118288,29112746:carton:4230:29118964,29112748:carton:4230:29117978,29112765:carton:4230:29117325,29112771:carton:4230:29117863,29112775:carton:4230:29117049,29112780:carton:4230:29116577,29112784:carton:4230:29116731,29112789:carton:4230:29116507,29112807:carton:4230:29116134,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018430164590232088, 'nb_photo': 1637, 'list_port_cont': '29034675,29034738,29034900,29034971,29038085,29038484,29039292,29042372,29044289,29050045,29050252,29050506,29050647,29053507,29053532,29086166,29086395,29086696,29087156,29087675,29092429,29093013,29112984,29113316,29113498,29113868,29114110,29114563,29114987,29115282,29115553,29116078,29116137,29116512,29116574,29116739,29117318,29117854,29118738,29118950,29119370,29160073,29160121,29160179,29160227,29160433,29160553,29160613,29160652,29160763,29160904,29161036,29161079,29161213,29161311,29161363,29161439,29161472,29161596,29162092,29164450,29165404,29166315,29198304,29198475,29198675,29200720,29200811,29200914,29201122,29201449,29201625,29201696,29201724,29201845,29201982,29202140,29202243,29202451,29202683,29202845,29202996,29203192,29203219,29203418,29237765,29237885,29238044,29238079,29238200,29238256,29238381,29238452,29238517,29238557,29238607,29238774,29238922,29238952,29239038,29239214,29239354,29239454,29240102,29266756,29266793,29266829,29266896,29267058,29267060,29267160,29267246,29267316,2926746', 'assoc_port': '29034545:29034738,29034546:29034675,29034792:29039292,29034854:29034900,29034951:29034971,29037834:29038484,29037835:29038085,29039887:29044289,29041924:29042372,29043379:29050506,29049662:29050647,29049680:29050252,29049698:29050045,29053189:29053532,29053191:29053507,29085008:29087675,29085011:29087156,29085012:29093013,29085015:29086696,29085036:29086395,29085039:29086166,29085065:29092429,29112746:29118950,29112765:29117318,29112771:29117854,29112780:29116574,29112784:29116739,29112789:29116512,29112807:29116137,29112826:29116078,29112828:29115553,29112831:29115282,29112832:29114987,29112846:29114563,29112860:29114110,29112862:29113868,29112864:29113498,29112867:29119370,29112869:29112984,29112871:29113316,29118222:29118738,29159957:29166315,29159960:29161439,29159963:29161596,29159966:29161363,29159968:29161472,29159971:29161311,29159977:29161213,29159981:29161079,29159984:29161036,29159986:29160904,29159988:29160763,29159991:29165404,29159992:29160652,29159994:29160613,29159997:29160553,29160001:2916043', 'assoc_mat': '29034545:metal:4230:29034738,29034546:metal:4230:29034675,29034792:metal:4230:29039292,29034854:metal:4230:29034900,29034951:metal:4230:29034971,29037834:metal:4230:29038484,29037835:metal:4230:29038085,29039887:metal:4230:29044289,29041924:metal:4230:29042372,29043379:metal:4230:29050506,29049662:metal:4230:29050647,29049680:metal:4230:29050252,29049698:metal:4230:29050045,29053189:metal:4230:29053532,29053191:metal:4230:29053507,29085008:metal:4230:29087675,29085011:metal:4230:29087156,29085012:metal:4230:29093013,29085015:metal:4230:29086696,29085036:metal:4230:29086395,29085039:metal:4230:29086166,29085065:metal:4230:29092429,29112746:metal:4230:29118950,29112765:metal:4230:29117318,29112771:metal:4230:29117854,29112780:metal:4230:29116574,29112784:metal:4230:29116739,29112789:metal:4230:29116512,29112807:metal:4230:29116137,29112826:metal:4230:29116078,29112828:metal:4230:29115553,29112831:metal:4230:29115282,29112832:metal:4230:29114987,29112846:metal:4230:29114563,29112860:metal:4230:29114110,29112862:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19763960725928464, 'nb_photo': 268698, 'list_port_cont': '29034679,29034737,29034907,29034975,29038096,29038472,29039303,29042366,29044304,29050043,29050262,29050517,29050640,29053511,29053529,29085982,29086165,29086390,29086698,29087165,29087688,29092431,29093029,29112998,29113326,29113505,29113875,29114123,29114579,29114988,29115278,29115563,29116087,29116127,29116518,29116572,29116734,29117047,29117330,29117851,29117966,29118304,29118751,29118957,29119385,29124189,29124598,29160081,29160115,29160192,29160220,29160429,29160465,29160556,29160623,29160673,29160772,29160919,29161048,29161073,29161130,29161212,29161313,29161376,29161435,29161485,29161586,29162083,29164448,29165403,29166308,29198300,29198480,29198687,29200450,29200719,29200802,29200929,29201121,29201450,29201632,29201690,29201729,29201846,29201981,29202150,29202255,29202462,29202545,29202684,29202854,29203005,29203183,29203225,29203422,29237779,29237892,29238040,29238080,29238209,29238259,29238391,29238462,29238518,29238553,29238612,29238782,29238929,29238966,29239033,29239114,29239138,29239217,2923937', 'assoc_port': '29034545:29034737,29034546:29034679,29034792:29039303,29034854:29034907,29034951:29034975,29037834:29038472,29037835:29038096,29039887:29044304,29041924:29042366,29043379:29050517,29049662:29050640,29049680:29050262,29049698:29050043,29053189:29053529,29053191:29053511,29085008:29087688,29085011:29087165,29085012:29093029,29085015:29086698,29085036:29086390,29085039:29086165,29085053:29085982,29085065:29092431,29112740:29124598,29112743:29118304,29112746:29118957,29112748:29117966,29112765:29117330,29112771:29117851,29112775:29117047,29112780:29116572,29112784:29116734,29112789:29116518,29112807:29116127,29112826:29116087,29112828:29115563,29112831:29115278,29112832:29114988,29112846:29114579,29112860:29114123,29112862:29113875,29112864:29113505,29112867:29119385,29112869:29112998,29112871:29113326,29118222:29118751,29118225:29124189,29159957:29166308,29159960:29161435,29159963:29161586,29159966:29161376,29159968:29161485,29159971:29161313,29159976:29161130,29159977:29161212,29159981:29161073,29159984:2916104', 'assoc_mat': '29034545:papier:4230:29034737,29034546:papier:4230:29034679,29034792:papier:4230:29039303,29034854:papier:4230:29034907,29034951:papier:4230:29034975,29037834:papier:4230:29038472,29037835:papier:4230:29038096,29039887:papier:4230:29044304,29041924:papier:4230:29042366,29043379:papier:4230:29050517,29049662:papier:4230:29050640,29049680:papier:4230:29050262,29049698:papier:4230:29050043,29053189:papier:4230:29053529,29053191:papier:4230:29053511,29085008:papier:4230:29087688,29085011:papier:4230:29087165,29085012:papier:4230:29093029,29085015:papier:4230:29086698,29085036:papier:4230:29086390,29085039:papier:4230:29086165,29085053:papier:4230:29085982,29085065:papier:4230:29092431,29112740:papier:4230:29124598,29112743:papier:4230:29118304,29112746:papier:4230:29118957,29112748:papier:4230:29117966,29112765:papier:4230:29117330,29112771:papier:4230:29117851,29112775:papier:4230:29117047,29112780:papier:4230:29116572,29112784:papier:4230:29116734,29112789:papier:4230:29116518,29112807:papier:4230:29116127,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003014884951011314, 'nb_photo': 1801, 'list_port_cont': '29034672,29034752,29038100,29039304,29042370,29044292,29050035,29050516,29050653,29053515,29053533,29085980,29086401,29086710,29087164,29087695,29092430,29093024,29112991,29113331,29113506,29113872,29114120,29114577,29114983,29115280,29115562,29116082,29116146,29116508,29116575,29116736,29117036,29117328,29117971,29118750,29119381,29124197,29124604,29160085,29160122,29160191,29160233,29160432,29160463,29160551,29160627,29160671,29160766,29160914,29161045,29161081,29161136,29161210,29161318,29161450,29161484,29161593,29162098,29164457,29165407,29166317,29198299,29198473,29198681,29200462,29200727,29200804,29200916,29201123,29201458,29201633,29201684,29201728,29201849,29201972,29202147,29202252,29202467,29202546,29202688,29202852,29203004,29203185,29203218,29203421,29237773,29237876,29238039,29238086,29238213,29238266,29238384,29238523,29238555,29238616,29238776,29238925,29238956,29239034,29239150,29239222,29239364,29239471,29239631,29240114,29266757,29266797,29266832,29266906,29267057,29267066,29267155,2926724', 'assoc_port': '29034545:29034752,29034546:29034672,29034792:29039304,29037835:29038100,29039887:29044292,29041924:29042370,29043379:29050516,29049662:29050653,29049698:29050035,29053189:29053533,29053191:29053515,29085008:29087695,29085011:29087164,29085012:29093024,29085015:29086710,29085036:29086401,29085053:29085980,29085065:29092430,29112740:29124604,29112748:29117971,29112765:29117328,29112775:29117036,29112780:29116575,29112784:29116736,29112789:29116508,29112807:29116146,29112826:29116082,29112828:29115562,29112831:29115280,29112832:29114983,29112846:29114577,29112860:29114120,29112862:29113872,29112864:29113506,29112867:29119381,29112869:29112991,29112871:29113331,29118222:29118750,29118225:29124197,29159957:29166317,29159960:29161450,29159963:29161593,29159968:29161484,29159971:29161318,29159976:29161136,29159977:29161210,29159981:29161081,29159984:29161045,29159986:29160914,29159988:29160766,29159991:29165407,29159992:29160671,29159994:29160627,29159997:29160551,29159999:29160463,29160001:29160432,29160003:2916008', 'assoc_mat': '29034545:pehd:4230:29034752,29034546:pehd:4230:29034672,29034792:pehd:4230:29039304,29037835:pehd:4230:29038100,29039887:pehd:4230:29044292,29041924:pehd:4230:29042370,29043379:pehd:4230:29050516,29049662:pehd:4230:29050653,29049698:pehd:4230:29050035,29053189:pehd:4230:29053533,29053191:pehd:4230:29053515,29085008:pehd:4230:29087695,29085011:pehd:4230:29087164,29085012:pehd:4230:29093024,29085015:pehd:4230:29086710,29085036:pehd:4230:29086401,29085053:pehd:4230:29085980,29085065:pehd:4230:29092430,29112740:pehd:4230:29124604,29112748:pehd:4230:29117971,29112765:pehd:4230:29117328,29112775:pehd:4230:29117036,29112780:pehd:4230:29116575,29112784:pehd:4230:29116736,29112789:pehd:4230:29116508,29112807:pehd:4230:29116146,29112826:pehd:4230:29116082,29112828:pehd:4230:29115562,29112831:pehd:4230:29115280,29112832:pehd:4230:29114983,29112846:pehd:4230:29114577,29112860:pehd:4230:29114120,29112862:pehd:4230:29113872,29112864:pehd:4230:29113506,29112867:pehd:4230:29119381,29112869:pehd:4230:29112991,29112871:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016739993503235597, 'nb_photo': 25421, 'list_port_cont': '29034673,29034745,29034904,29034964,29038101,29038477,29039296,29042362,29044295,29050048,29050264,29050518,29050646,29053514,29053526,29085977,29086177,29086396,29086708,29087163,29087691,29092426,29093027,29112999,29113333,29113494,29113880,29114113,29114574,29114992,29115284,29115560,29116090,29116135,29116514,29116578,29116727,29117046,29117332,29117861,29117973,29118303,29118740,29118951,29119377,29124201,29124595,29160080,29160113,29160195,29160225,29160426,29160468,29160552,29160617,29160653,29160767,29160918,29161046,29161088,29161129,29161206,29161320,29161367,29161449,29161483,29161598,29162090,29164455,29165400,29166314,29198303,29198484,29198680,29200460,29200729,29200812,29200923,29201132,29201459,29201622,29201692,29201730,29201837,29201968,29202148,29202258,29202458,29202550,29202695,29202850,29203009,29203191,29203234,29203411,29237777,29237883,29238049,29238081,29238211,29238257,29238387,29238460,29238524,29238556,29238622,29238781,29238932,29238968,29239035,29239110,29239144,29239219,2923936', 'assoc_port': '29034545:29034745,29034546:29034673,29034792:29039296,29034854:29034904,29034951:29034964,29037834:29038477,29037835:29038101,29039887:29044295,29041924:29042362,29043379:29050518,29049662:29050646,29049680:29050264,29049698:29050048,29053189:29053526,29053191:29053514,29085008:29087691,29085011:29087163,29085012:29093027,29085015:29086708,29085036:29086396,29085039:29086177,29085053:29085977,29085065:29092426,29112740:29124595,29112743:29118303,29112746:29118951,29112748:29117973,29112765:29117332,29112771:29117861,29112775:29117046,29112780:29116578,29112784:29116727,29112789:29116514,29112807:29116135,29112826:29116090,29112828:29115560,29112831:29115284,29112832:29114992,29112846:29114574,29112860:29114113,29112862:29113880,29112864:29113494,29112867:29119377,29112869:29112999,29112871:29113333,29118222:29118740,29118225:29124201,29159957:29166314,29159960:29161449,29159963:29161598,29159966:29161367,29159968:29161483,29159971:29161320,29159976:29161129,29159977:29161206,29159981:29161088,29159984:2916104', 'assoc_mat': '29034545:pet_clair:4230:29034745,29034546:pet_clair:4230:29034673,29034792:pet_clair:4230:29039296,29034854:pet_clair:4230:29034904,29034951:pet_clair:4230:29034964,29037834:pet_clair:4230:29038477,29037835:pet_clair:4230:29038101,29039887:pet_clair:4230:29044295,29041924:pet_clair:4230:29042362,29043379:pet_clair:4230:29050518,29049662:pet_clair:4230:29050646,29049680:pet_clair:4230:29050264,29049698:pet_clair:4230:29050048,29053189:pet_clair:4230:29053526,29053191:pet_clair:4230:29053514,29085008:pet_clair:4230:29087691,29085011:pet_clair:4230:29087163,29085012:pet_clair:4230:29093027,29085015:pet_clair:4230:29086708,29085036:pet_clair:4230:29086396,29085039:pet_clair:4230:29086177,29085053:pet_clair:4230:29085977,29085065:pet_clair:4230:29092426,29112740:pet_clair:4230:29124595,29112743:pet_clair:4230:29118303,29112746:pet_clair:4230:29118951,29112748:pet_clair:4230:29117973,29112765:pet_clair:4230:29117332,29112771:pet_clair:4230:29117861,29112775:pet_clair:4230:29117046,29112780:pet_clair:4230:29116578,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002552641072184844, 'nb_photo': 681, 'list_port_cont': '29034678,29034751,29042367,29044303,29050040,29050253,29050513,29050642,29053512,29085986,29086172,29086397,29087160,29087696,29112992,29113502,29113878,29114118,29114578,29114990,29115283,29115556,29116088,29116141,29116509,29116571,29116737,29117042,29117326,29117860,29117969,29118963,29119379,29124601,29160083,29160118,29160185,29160427,29160461,29160557,29160771,29161134,29161208,29161475,29165405,29198307,29198479,29198688,29200457,29200718,29200809,29200927,29201131,29201455,29201688,29201842,29201977,29202254,29203181,29203232,29203410,29237782,29237890,29238047,29238083,29238267,29238386,29238525,29238550,29238611,29238926,29238960,29239036,29239113,29239147,29239212,29239360,29239465,29239638,29266798,29266826,29266908,29267051,29267070,29267263,29267450,29267633,29280707,29282938,29282999,29283207,29283328,29283396,29284034,29298728,29298848,29300006,29300137,29300355,29300451,29300565,29300601,29300774,29300809,29301064,29301172,29301327,29301875,29302158,29302281,29302870,29303026,29303072,2930607', 'assoc_port': '29034545:29034751,29034546:29034678,29039887:29044303,29041924:29042367,29043379:29050513,29049662:29050642,29049680:29050253,29049698:29050040,29053191:29053512,29085008:29087696,29085011:29087160,29085036:29086397,29085039:29086172,29085053:29085986,29112740:29124601,29112746:29118963,29112748:29117969,29112765:29117326,29112771:29117860,29112775:29117042,29112780:29116571,29112784:29116737,29112789:29116509,29112807:29116141,29112826:29116088,29112828:29115556,29112831:29115283,29112832:29114990,29112846:29114578,29112860:29114118,29112862:29113878,29112864:29113502,29112867:29119379,29112869:29112992,29159968:29161475,29159976:29161134,29159977:29161208,29159988:29160771,29159991:29165405,29159997:29160557,29159999:29160461,29160001:29160427,29160003:29160083,29160004:29160185,29160006:29160118,29197827:29203232,29197836:29203181,29197864:29202254,29197879:29198479,29197898:29201977,29197902:29201842,29197943:29201131,29197945:29201688,29197959:29201455,29197973:29200718,29197974:29200809,29197975:2920045', 'assoc_mat': '29034545:pet_fonce:4230:29034751,29034546:pet_fonce:4230:29034678,29039887:pet_fonce:4230:29044303,29041924:pet_fonce:4230:29042367,29043379:pet_fonce:4230:29050513,29049662:pet_fonce:4230:29050642,29049680:pet_fonce:4230:29050253,29049698:pet_fonce:4230:29050040,29053191:pet_fonce:4230:29053512,29085008:pet_fonce:4230:29087696,29085011:pet_fonce:4230:29087160,29085036:pet_fonce:4230:29086397,29085039:pet_fonce:4230:29086172,29085053:pet_fonce:4230:29085986,29112740:pet_fonce:4230:29124601,29112746:pet_fonce:4230:29118963,29112748:pet_fonce:4230:29117969,29112765:pet_fonce:4230:29117326,29112771:pet_fonce:4230:29117860,29112775:pet_fonce:4230:29117042,29112780:pet_fonce:4230:29116571,29112784:pet_fonce:4230:29116737,29112789:pet_fonce:4230:29116509,29112807:pet_fonce:4230:29116141,29112826:pet_fonce:4230:29116088,29112828:pet_fonce:4230:29115556,29112831:pet_fonce:4230:29115283,29112832:pet_fonce:4230:29114990,29112846:pet_fonce:4230:29114578,29112860:pet_fonce:4230:29114118,29112862:pet_fonce:4230:29113878,2'}), 'main_stat': {'nb_photos': 1470}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-12', 0.7265573334042384),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1470,),), 'unwanted_material_monthly_percentage': ((0.7265573334042384,),), 'material_repartition': (('incineration', 1470),), 'material_dict': {'incineration': 1470}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 12, 1), 0.7991406097146174, 4), (datetime.date(2025, 12, 2), 0.7766044811413638, 3), (datetime.date(2025, 12, 3), 0.7552502291355105, 4), (datetime.date(2025, 12, 4), 0.7059575365614557, 4), (datetime.date(2025, 12, 5), 0.7240667572972483, 4), (datetime.date(2025, 12, 6), 0.7128705547762423, 1), (datetime.date(2025, 12, 7), 0.7810618444655286, 3), (datetime.date(2025, 12, 8), 0.7829694295716922, 3), (datetime.date(2025, 12, 9), 0.7351813559506037, 2), (datetime.date(2025, 12, 10), 0.7340127614504104, 2), (datetime.date(2025, 12, 11), 0.7158706533544302, 3), (datetime.date(2025, 12, 12), 0.7342188531485805, 2), (datetime.date(2025, 12, 13), 0.7595071944807656, 1), (datetime.date(2025, 12, 14), 0.7927946125944331, 3), (datetime.date(2025, 12, 15), 0.8061593786338213, 2), (datetime.date(2025, 12, 16), 0.7565683321105436, 3), (datetime.date(2025, 12, 17), 0.678129043245445, 2), (datetime.date(2025, 12, 18), 0.6150280298556764, 2), (datetime.date(2025, 12, 19), 0.6225915927952439, 2), (datetime.date(2025, 12, 20), 0.6182208648665531, 2), (datetime.date(2025, 12, 21), 0.6584141346871943, 3), (datetime.date(2025, 12, 22), 0.7225944050913317, 3), (datetime.date(2025, 12, 23), 0.6894568297932241, 4), (datetime.date(2025, 12, 24), 0.6890741469929342, 2), (datetime.date(2025, 12, 25), 0.7390946427029729, 3), (datetime.date(2025, 12, 26), 0.7025782630869309, 2), (datetime.date(2025, 12, 27), 0.6961482035370977, 3), (datetime.date(2025, 12, 28), 0.7580801942037776, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 12, 1), 0.7991406097146174, 4), (datetime.date(2025, 12, 2), 0.7766044811413638, 3), (datetime.date(2025, 12, 3), 0.7552502291355105, 4), (datetime.date(2025, 12, 4), 0.7059575365614557, 4), (datetime.date(2025, 12, 5), 0.7240667572972483, 4), (datetime.date(2025, 12, 6), 0.7128705547762423, 1), (datetime.date(2025, 12, 7), 0.7810618444655286, 3), (datetime.date(2025, 12, 8), 0.7829694295716922, 3), (datetime.date(2025, 12, 9), 0.7351813559506037, 2), (datetime.date(2025, 12, 10), 0.7340127614504104, 2), (datetime.date(2025, 12, 11), 0.7158706533544302, 3), (datetime.date(2025, 12, 12), 0.7342188531485805, 2), (datetime.date(2025, 12, 13), 0.7595071944807656, 1), (datetime.date(2025, 12, 14), 0.7927946125944331, 3), (datetime.date(2025, 12, 15), 0.8061593786338213, 2), (datetime.date(2025, 12, 16), 0.7565683321105436, 3), (datetime.date(2025, 12, 17), 0.678129043245445, 2), (datetime.date(2025, 12, 18), 0.6150280298556764, 2), (datetime.date(2025, 12, 19), 0.6225915927952439, 2), (datetime.date(2025, 12, 20), 0.6182208648665531, 2), (datetime.date(2025, 12, 21), 0.6584141346871943, 3), (datetime.date(2025, 12, 22), 0.7225944050913317, 3), (datetime.date(2025, 12, 23), 0.6894568297932241, 4), (datetime.date(2025, 12, 24), 0.6890741469929342, 2), (datetime.date(2025, 12, 25), 0.7390946427029729, 3), (datetime.date(2025, 12, 26), 0.7025782630869309, 2), (datetime.date(2025, 12, 27), 0.6961482035370977, 3), (datetime.date(2025, 12, 28), 0.7580801942037776, 2))}, 'quality_array': [['-7.682430174907037', '01122025'], ['-7.557092364818838', '02122025'], ['-7.526345331926031', '03122025'], ['-7.496614290929725', '04122025'], ['-7.4819908252650595', '05122025'], ['-7.39880688651016', '06122025'], ['-7.578154971686454', '07122025'], ['-7.658025740586917', '08122025'], ['-7.724860418573609', '09122025'], ['-7.611383403513108', '10122025'], ['-7.770407003079782', '11122025'], ['-7.799647169684124', '12122025'], ['-7.631641453405841', '13122025'], ['-7.628609355308779', '14122025'], ['-6.760027355007995', '15122025'], ['-6.884467298210814', '16122025'], ['-7.432684860547826', '17122025'], ['-7.482884108187042', '18122025'], ['-7.6357286511413776', '19122025'], ['-7.800146272276386', '20122025'], ['-7.8316245132529785', '21122025'], ['-7.395501337472362', '22122025'], ['-7.3643357539797885', '23122025'], ['-7.739867521905735', '24122025'], ['-7.789284877536598', '25122025'], ['-7.489031929892119', '26122025'], ['-7.235348918487337', '27122025'], ['-7.228731895146129', '28122025']], 'number_of_batch': ((577,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014750656401364724, 'nb_photo': 14556, 'list_port_cont': '29034674,29034750,29034897,29034967,29038095,29038479,29039297,29042373,29044301,29050032,29050261,29050515,29050643,29053503,29053521,29085975,29086167,29086399,29086704,29087150,29087690,29092417,29093016,29112996,29113321,29113504,29113863,29114114,29114569,29114984,29115272,29115564,29116076,29116131,29116517,29116565,29116738,29117041,29117329,29117848,29117977,29118289,29118734,29118961,29119380,29124194,29124605,29160077,29160124,29160189,29160221,29160417,29160455,29160549,29160628,29160665,29160769,29160905,29161038,29161078,29161123,29161200,29161322,29161369,29161451,29161479,29161597,29162080,29164446,29165406,29166302,29198291,29198477,29198685,29200459,29200721,29200799,29200915,29201133,29201452,29201634,29201694,29201720,29201834,29201975,29202151,29202247,29202468,29202544,29202693,29202847,29203006,29203190,29203227,29203420,29237766,29237888,29238048,29238088,29238214,29238265,29238393,29238464,29238509,29238562,29238620,29238775,29238923,29238961,29239025,29239109,29239142,29239208,2923935', 'assoc_port': '29034545:29034750,29034546:29034674,29034792:29039297,29034854:29034897,29034951:29034967,29037834:29038479,29037835:29038095,29039887:29044301,29041924:29042373,29043379:29050515,29049662:29050643,29049680:29050261,29049698:29050032,29053189:29053521,29053191:29053503,29085008:29087690,29085011:29087150,29085012:29093016,29085015:29086704,29085036:29086399,29085039:29086167,29085053:29085975,29085065:29092417,29112740:29124605,29112743:29118289,29112746:29118961,29112748:29117977,29112765:29117329,29112771:29117848,29112775:29117041,29112780:29116565,29112784:29116738,29112789:29116517,29112807:29116131,29112826:29116076,29112828:29115564,29112831:29115272,29112832:29114984,29112846:29114569,29112860:29114114,29112862:29113863,29112864:29113504,29112867:29119380,29112869:29112996,29112871:29113321,29118222:29118734,29118225:29124194,29159957:29166302,29159960:29161451,29159963:29161597,29159966:29161369,29159968:29161479,29159971:29161322,29159976:29161123,29159977:29161200,29159981:29161078,29159984:2916103', 'assoc_mat': '29034545:autre:4230:29034750,29034546:autre:4230:29034674,29034792:autre:4230:29039297,29034854:autre:4230:29034897,29034951:autre:4230:29034967,29037834:autre:4230:29038479,29037835:autre:4230:29038095,29039887:autre:4230:29044301,29041924:autre:4230:29042373,29043379:autre:4230:29050515,29049662:autre:4230:29050643,29049680:autre:4230:29050261,29049698:autre:4230:29050032,29053189:autre:4230:29053521,29053191:autre:4230:29053503,29085008:autre:4230:29087690,29085011:autre:4230:29087150,29085012:autre:4230:29093016,29085015:autre:4230:29086704,29085036:autre:4230:29086399,29085039:autre:4230:29086167,29085053:autre:4230:29085975,29085065:autre:4230:29092417,29112740:autre:4230:29124605,29112743:autre:4230:29118289,29112746:autre:4230:29118961,29112748:autre:4230:29117977,29112765:autre:4230:29117329,29112771:autre:4230:29117848,29112775:autre:4230:29117041,29112780:autre:4230:29116565,29112784:autre:4230:29116738,29112789:autre:4230:29116517,29112807:autre:4230:29116131,29112826:autre:4230:29116076,29112828:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05210215011330301, 'nb_photo': 80914, 'list_port_cont': '29034667,29034740,29034910,29034965,29038099,29038482,29039300,29042358,29044299,29050037,29050260,29050512,29050652,29053508,29053528,29085984,29086175,29086392,29086712,29087161,29087689,29092428,29093020,29112986,29113325,29113499,29113874,29114115,29114575,29114994,29115281,29115552,29116081,29116134,29116507,29116577,29116731,29117049,29117325,29117863,29117978,29118288,29118747,29118964,29119378,29124200,29124606,29160076,29160117,29160196,29160230,29160425,29160464,29160543,29160624,29160657,29160768,29160917,29161051,29161080,29161131,29161211,29161321,29161371,29161447,29161482,29161584,29162096,29164454,29165398,29166313,29198302,29198478,29198689,29200464,29200725,29200813,29200921,29201134,29201456,29201636,29201682,29201733,29201844,29201978,29202137,29202256,29202460,29202548,29202696,29202855,29203010,29203194,29203228,29203415,29237780,29237889,29238052,29238089,29238204,29238264,29238390,29238451,29238521,29238558,29238615,29238780,29238931,29238967,29239040,29239103,29239149,29239215,2923937', 'assoc_port': '29034545:29034740,29034546:29034667,29034792:29039300,29034854:29034910,29034951:29034965,29037834:29038482,29037835:29038099,29039887:29044299,29041924:29042358,29043379:29050512,29049662:29050652,29049680:29050260,29049698:29050037,29053189:29053528,29053191:29053508,29085008:29087689,29085011:29087161,29085012:29093020,29085015:29086712,29085036:29086392,29085039:29086175,29085053:29085984,29085065:29092428,29112740:29124606,29112743:29118288,29112746:29118964,29112748:29117978,29112765:29117325,29112771:29117863,29112775:29117049,29112780:29116577,29112784:29116731,29112789:29116507,29112807:29116134,29112826:29116081,29112828:29115552,29112831:29115281,29112832:29114994,29112846:29114575,29112860:29114115,29112862:29113874,29112864:29113499,29112867:29119378,29112869:29112986,29112871:29113325,29118222:29118747,29118225:29124200,29159957:29166313,29159960:29161447,29159963:29161584,29159966:29161371,29159968:29161482,29159971:29161321,29159976:29161131,29159977:29161211,29159981:29161080,29159984:2916105', 'assoc_mat': '29034545:carton:4230:29034740,29034546:carton:4230:29034667,29034792:carton:4230:29039300,29034854:carton:4230:29034910,29034951:carton:4230:29034965,29037834:carton:4230:29038482,29037835:carton:4230:29038099,29039887:carton:4230:29044299,29041924:carton:4230:29042358,29043379:carton:4230:29050512,29049662:carton:4230:29050652,29049680:carton:4230:29050260,29049698:carton:4230:29050037,29053189:carton:4230:29053528,29053191:carton:4230:29053508,29085008:carton:4230:29087689,29085011:carton:4230:29087161,29085012:carton:4230:29093020,29085015:carton:4230:29086712,29085036:carton:4230:29086392,29085039:carton:4230:29086175,29085053:carton:4230:29085984,29085065:carton:4230:29092428,29112740:carton:4230:29124606,29112743:carton:4230:29118288,29112746:carton:4230:29118964,29112748:carton:4230:29117978,29112765:carton:4230:29117325,29112771:carton:4230:29117863,29112775:carton:4230:29117049,29112780:carton:4230:29116577,29112784:carton:4230:29116731,29112789:carton:4230:29116507,29112807:carton:4230:29116134,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018430164590232088, 'nb_photo': 1637, 'list_port_cont': '29034675,29034738,29034900,29034971,29038085,29038484,29039292,29042372,29044289,29050045,29050252,29050506,29050647,29053507,29053532,29086166,29086395,29086696,29087156,29087675,29092429,29093013,29112984,29113316,29113498,29113868,29114110,29114563,29114987,29115282,29115553,29116078,29116137,29116512,29116574,29116739,29117318,29117854,29118738,29118950,29119370,29160073,29160121,29160179,29160227,29160433,29160553,29160613,29160652,29160763,29160904,29161036,29161079,29161213,29161311,29161363,29161439,29161472,29161596,29162092,29164450,29165404,29166315,29198304,29198475,29198675,29200720,29200811,29200914,29201122,29201449,29201625,29201696,29201724,29201845,29201982,29202140,29202243,29202451,29202683,29202845,29202996,29203192,29203219,29203418,29237765,29237885,29238044,29238079,29238200,29238256,29238381,29238452,29238517,29238557,29238607,29238774,29238922,29238952,29239038,29239214,29239354,29239454,29240102,29266756,29266793,29266829,29266896,29267058,29267060,29267160,29267246,29267316,2926746', 'assoc_port': '29034545:29034738,29034546:29034675,29034792:29039292,29034854:29034900,29034951:29034971,29037834:29038484,29037835:29038085,29039887:29044289,29041924:29042372,29043379:29050506,29049662:29050647,29049680:29050252,29049698:29050045,29053189:29053532,29053191:29053507,29085008:29087675,29085011:29087156,29085012:29093013,29085015:29086696,29085036:29086395,29085039:29086166,29085065:29092429,29112746:29118950,29112765:29117318,29112771:29117854,29112780:29116574,29112784:29116739,29112789:29116512,29112807:29116137,29112826:29116078,29112828:29115553,29112831:29115282,29112832:29114987,29112846:29114563,29112860:29114110,29112862:29113868,29112864:29113498,29112867:29119370,29112869:29112984,29112871:29113316,29118222:29118738,29159957:29166315,29159960:29161439,29159963:29161596,29159966:29161363,29159968:29161472,29159971:29161311,29159977:29161213,29159981:29161079,29159984:29161036,29159986:29160904,29159988:29160763,29159991:29165404,29159992:29160652,29159994:29160613,29159997:29160553,29160001:2916043', 'assoc_mat': '29034545:metal:4230:29034738,29034546:metal:4230:29034675,29034792:metal:4230:29039292,29034854:metal:4230:29034900,29034951:metal:4230:29034971,29037834:metal:4230:29038484,29037835:metal:4230:29038085,29039887:metal:4230:29044289,29041924:metal:4230:29042372,29043379:metal:4230:29050506,29049662:metal:4230:29050647,29049680:metal:4230:29050252,29049698:metal:4230:29050045,29053189:metal:4230:29053532,29053191:metal:4230:29053507,29085008:metal:4230:29087675,29085011:metal:4230:29087156,29085012:metal:4230:29093013,29085015:metal:4230:29086696,29085036:metal:4230:29086395,29085039:metal:4230:29086166,29085065:metal:4230:29092429,29112746:metal:4230:29118950,29112765:metal:4230:29117318,29112771:metal:4230:29117854,29112780:metal:4230:29116574,29112784:metal:4230:29116739,29112789:metal:4230:29116512,29112807:metal:4230:29116137,29112826:metal:4230:29116078,29112828:metal:4230:29115553,29112831:metal:4230:29115282,29112832:metal:4230:29114987,29112846:metal:4230:29114563,29112860:metal:4230:29114110,29112862:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19763960725928464, 'nb_photo': 268698, 'list_port_cont': '29034679,29034737,29034907,29034975,29038096,29038472,29039303,29042366,29044304,29050043,29050262,29050517,29050640,29053511,29053529,29085982,29086165,29086390,29086698,29087165,29087688,29092431,29093029,29112998,29113326,29113505,29113875,29114123,29114579,29114988,29115278,29115563,29116087,29116127,29116518,29116572,29116734,29117047,29117330,29117851,29117966,29118304,29118751,29118957,29119385,29124189,29124598,29160081,29160115,29160192,29160220,29160429,29160465,29160556,29160623,29160673,29160772,29160919,29161048,29161073,29161130,29161212,29161313,29161376,29161435,29161485,29161586,29162083,29164448,29165403,29166308,29198300,29198480,29198687,29200450,29200719,29200802,29200929,29201121,29201450,29201632,29201690,29201729,29201846,29201981,29202150,29202255,29202462,29202545,29202684,29202854,29203005,29203183,29203225,29203422,29237779,29237892,29238040,29238080,29238209,29238259,29238391,29238462,29238518,29238553,29238612,29238782,29238929,29238966,29239033,29239114,29239138,29239217,2923937', 'assoc_port': '29034545:29034737,29034546:29034679,29034792:29039303,29034854:29034907,29034951:29034975,29037834:29038472,29037835:29038096,29039887:29044304,29041924:29042366,29043379:29050517,29049662:29050640,29049680:29050262,29049698:29050043,29053189:29053529,29053191:29053511,29085008:29087688,29085011:29087165,29085012:29093029,29085015:29086698,29085036:29086390,29085039:29086165,29085053:29085982,29085065:29092431,29112740:29124598,29112743:29118304,29112746:29118957,29112748:29117966,29112765:29117330,29112771:29117851,29112775:29117047,29112780:29116572,29112784:29116734,29112789:29116518,29112807:29116127,29112826:29116087,29112828:29115563,29112831:29115278,29112832:29114988,29112846:29114579,29112860:29114123,29112862:29113875,29112864:29113505,29112867:29119385,29112869:29112998,29112871:29113326,29118222:29118751,29118225:29124189,29159957:29166308,29159960:29161435,29159963:29161586,29159966:29161376,29159968:29161485,29159971:29161313,29159976:29161130,29159977:29161212,29159981:29161073,29159984:2916104', 'assoc_mat': '29034545:papier:4230:29034737,29034546:papier:4230:29034679,29034792:papier:4230:29039303,29034854:papier:4230:29034907,29034951:papier:4230:29034975,29037834:papier:4230:29038472,29037835:papier:4230:29038096,29039887:papier:4230:29044304,29041924:papier:4230:29042366,29043379:papier:4230:29050517,29049662:papier:4230:29050640,29049680:papier:4230:29050262,29049698:papier:4230:29050043,29053189:papier:4230:29053529,29053191:papier:4230:29053511,29085008:papier:4230:29087688,29085011:papier:4230:29087165,29085012:papier:4230:29093029,29085015:papier:4230:29086698,29085036:papier:4230:29086390,29085039:papier:4230:29086165,29085053:papier:4230:29085982,29085065:papier:4230:29092431,29112740:papier:4230:29124598,29112743:papier:4230:29118304,29112746:papier:4230:29118957,29112748:papier:4230:29117966,29112765:papier:4230:29117330,29112771:papier:4230:29117851,29112775:papier:4230:29117047,29112780:papier:4230:29116572,29112784:papier:4230:29116734,29112789:papier:4230:29116518,29112807:papier:4230:29116127,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003014884951011314, 'nb_photo': 1801, 'list_port_cont': '29034672,29034752,29038100,29039304,29042370,29044292,29050035,29050516,29050653,29053515,29053533,29085980,29086401,29086710,29087164,29087695,29092430,29093024,29112991,29113331,29113506,29113872,29114120,29114577,29114983,29115280,29115562,29116082,29116146,29116508,29116575,29116736,29117036,29117328,29117971,29118750,29119381,29124197,29124604,29160085,29160122,29160191,29160233,29160432,29160463,29160551,29160627,29160671,29160766,29160914,29161045,29161081,29161136,29161210,29161318,29161450,29161484,29161593,29162098,29164457,29165407,29166317,29198299,29198473,29198681,29200462,29200727,29200804,29200916,29201123,29201458,29201633,29201684,29201728,29201849,29201972,29202147,29202252,29202467,29202546,29202688,29202852,29203004,29203185,29203218,29203421,29237773,29237876,29238039,29238086,29238213,29238266,29238384,29238523,29238555,29238616,29238776,29238925,29238956,29239034,29239150,29239222,29239364,29239471,29239631,29240114,29266757,29266797,29266832,29266906,29267057,29267066,29267155,2926724', 'assoc_port': '29034545:29034752,29034546:29034672,29034792:29039304,29037835:29038100,29039887:29044292,29041924:29042370,29043379:29050516,29049662:29050653,29049698:29050035,29053189:29053533,29053191:29053515,29085008:29087695,29085011:29087164,29085012:29093024,29085015:29086710,29085036:29086401,29085053:29085980,29085065:29092430,29112740:29124604,29112748:29117971,29112765:29117328,29112775:29117036,29112780:29116575,29112784:29116736,29112789:29116508,29112807:29116146,29112826:29116082,29112828:29115562,29112831:29115280,29112832:29114983,29112846:29114577,29112860:29114120,29112862:29113872,29112864:29113506,29112867:29119381,29112869:29112991,29112871:29113331,29118222:29118750,29118225:29124197,29159957:29166317,29159960:29161450,29159963:29161593,29159968:29161484,29159971:29161318,29159976:29161136,29159977:29161210,29159981:29161081,29159984:29161045,29159986:29160914,29159988:29160766,29159991:29165407,29159992:29160671,29159994:29160627,29159997:29160551,29159999:29160463,29160001:29160432,29160003:2916008', 'assoc_mat': '29034545:pehd:4230:29034752,29034546:pehd:4230:29034672,29034792:pehd:4230:29039304,29037835:pehd:4230:29038100,29039887:pehd:4230:29044292,29041924:pehd:4230:29042370,29043379:pehd:4230:29050516,29049662:pehd:4230:29050653,29049698:pehd:4230:29050035,29053189:pehd:4230:29053533,29053191:pehd:4230:29053515,29085008:pehd:4230:29087695,29085011:pehd:4230:29087164,29085012:pehd:4230:29093024,29085015:pehd:4230:29086710,29085036:pehd:4230:29086401,29085053:pehd:4230:29085980,29085065:pehd:4230:29092430,29112740:pehd:4230:29124604,29112748:pehd:4230:29117971,29112765:pehd:4230:29117328,29112775:pehd:4230:29117036,29112780:pehd:4230:29116575,29112784:pehd:4230:29116736,29112789:pehd:4230:29116508,29112807:pehd:4230:29116146,29112826:pehd:4230:29116082,29112828:pehd:4230:29115562,29112831:pehd:4230:29115280,29112832:pehd:4230:29114983,29112846:pehd:4230:29114577,29112860:pehd:4230:29114120,29112862:pehd:4230:29113872,29112864:pehd:4230:29113506,29112867:pehd:4230:29119381,29112869:pehd:4230:29112991,29112871:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.016739993503235597, 'nb_photo': 25421, 'list_port_cont': '29034673,29034745,29034904,29034964,29038101,29038477,29039296,29042362,29044295,29050048,29050264,29050518,29050646,29053514,29053526,29085977,29086177,29086396,29086708,29087163,29087691,29092426,29093027,29112999,29113333,29113494,29113880,29114113,29114574,29114992,29115284,29115560,29116090,29116135,29116514,29116578,29116727,29117046,29117332,29117861,29117973,29118303,29118740,29118951,29119377,29124201,29124595,29160080,29160113,29160195,29160225,29160426,29160468,29160552,29160617,29160653,29160767,29160918,29161046,29161088,29161129,29161206,29161320,29161367,29161449,29161483,29161598,29162090,29164455,29165400,29166314,29198303,29198484,29198680,29200460,29200729,29200812,29200923,29201132,29201459,29201622,29201692,29201730,29201837,29201968,29202148,29202258,29202458,29202550,29202695,29202850,29203009,29203191,29203234,29203411,29237777,29237883,29238049,29238081,29238211,29238257,29238387,29238460,29238524,29238556,29238622,29238781,29238932,29238968,29239035,29239110,29239144,29239219,2923936', 'assoc_port': '29034545:29034745,29034546:29034673,29034792:29039296,29034854:29034904,29034951:29034964,29037834:29038477,29037835:29038101,29039887:29044295,29041924:29042362,29043379:29050518,29049662:29050646,29049680:29050264,29049698:29050048,29053189:29053526,29053191:29053514,29085008:29087691,29085011:29087163,29085012:29093027,29085015:29086708,29085036:29086396,29085039:29086177,29085053:29085977,29085065:29092426,29112740:29124595,29112743:29118303,29112746:29118951,29112748:29117973,29112765:29117332,29112771:29117861,29112775:29117046,29112780:29116578,29112784:29116727,29112789:29116514,29112807:29116135,29112826:29116090,29112828:29115560,29112831:29115284,29112832:29114992,29112846:29114574,29112860:29114113,29112862:29113880,29112864:29113494,29112867:29119377,29112869:29112999,29112871:29113333,29118222:29118740,29118225:29124201,29159957:29166314,29159960:29161449,29159963:29161598,29159966:29161367,29159968:29161483,29159971:29161320,29159976:29161129,29159977:29161206,29159981:29161088,29159984:2916104', 'assoc_mat': '29034545:pet_clair:4230:29034745,29034546:pet_clair:4230:29034673,29034792:pet_clair:4230:29039296,29034854:pet_clair:4230:29034904,29034951:pet_clair:4230:29034964,29037834:pet_clair:4230:29038477,29037835:pet_clair:4230:29038101,29039887:pet_clair:4230:29044295,29041924:pet_clair:4230:29042362,29043379:pet_clair:4230:29050518,29049662:pet_clair:4230:29050646,29049680:pet_clair:4230:29050264,29049698:pet_clair:4230:29050048,29053189:pet_clair:4230:29053526,29053191:pet_clair:4230:29053514,29085008:pet_clair:4230:29087691,29085011:pet_clair:4230:29087163,29085012:pet_clair:4230:29093027,29085015:pet_clair:4230:29086708,29085036:pet_clair:4230:29086396,29085039:pet_clair:4230:29086177,29085053:pet_clair:4230:29085977,29085065:pet_clair:4230:29092426,29112740:pet_clair:4230:29124595,29112743:pet_clair:4230:29118303,29112746:pet_clair:4230:29118951,29112748:pet_clair:4230:29117973,29112765:pet_clair:4230:29117332,29112771:pet_clair:4230:29117861,29112775:pet_clair:4230:29117046,29112780:pet_clair:4230:29116578,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002552641072184844, 'nb_photo': 681, 'list_port_cont': '29034678,29034751,29042367,29044303,29050040,29050253,29050513,29050642,29053512,29085986,29086172,29086397,29087160,29087696,29112992,29113502,29113878,29114118,29114578,29114990,29115283,29115556,29116088,29116141,29116509,29116571,29116737,29117042,29117326,29117860,29117969,29118963,29119379,29124601,29160083,29160118,29160185,29160427,29160461,29160557,29160771,29161134,29161208,29161475,29165405,29198307,29198479,29198688,29200457,29200718,29200809,29200927,29201131,29201455,29201688,29201842,29201977,29202254,29203181,29203232,29203410,29237782,29237890,29238047,29238083,29238267,29238386,29238525,29238550,29238611,29238926,29238960,29239036,29239113,29239147,29239212,29239360,29239465,29239638,29266798,29266826,29266908,29267051,29267070,29267263,29267450,29267633,29280707,29282938,29282999,29283207,29283328,29283396,29284034,29298728,29298848,29300006,29300137,29300355,29300451,29300565,29300601,29300774,29300809,29301064,29301172,29301327,29301875,29302158,29302281,29302870,29303026,29303072,2930607', 'assoc_port': '29034545:29034751,29034546:29034678,29039887:29044303,29041924:29042367,29043379:29050513,29049662:29050642,29049680:29050253,29049698:29050040,29053191:29053512,29085008:29087696,29085011:29087160,29085036:29086397,29085039:29086172,29085053:29085986,29112740:29124601,29112746:29118963,29112748:29117969,29112765:29117326,29112771:29117860,29112775:29117042,29112780:29116571,29112784:29116737,29112789:29116509,29112807:29116141,29112826:29116088,29112828:29115556,29112831:29115283,29112832:29114990,29112846:29114578,29112860:29114118,29112862:29113878,29112864:29113502,29112867:29119379,29112869:29112992,29159968:29161475,29159976:29161134,29159977:29161208,29159988:29160771,29159991:29165405,29159997:29160557,29159999:29160461,29160001:29160427,29160003:29160083,29160004:29160185,29160006:29160118,29197827:29203232,29197836:29203181,29197864:29202254,29197879:29198479,29197898:29201977,29197902:29201842,29197943:29201131,29197945:29201688,29197959:29201455,29197973:29200718,29197974:29200809,29197975:2920045', 'assoc_mat': '29034545:pet_fonce:4230:29034751,29034546:pet_fonce:4230:29034678,29039887:pet_fonce:4230:29044303,29041924:pet_fonce:4230:29042367,29043379:pet_fonce:4230:29050513,29049662:pet_fonce:4230:29050642,29049680:pet_fonce:4230:29050253,29049698:pet_fonce:4230:29050040,29053191:pet_fonce:4230:29053512,29085008:pet_fonce:4230:29087696,29085011:pet_fonce:4230:29087160,29085036:pet_fonce:4230:29086397,29085039:pet_fonce:4230:29086172,29085053:pet_fonce:4230:29085986,29112740:pet_fonce:4230:29124601,29112746:pet_fonce:4230:29118963,29112748:pet_fonce:4230:29117969,29112765:pet_fonce:4230:29117326,29112771:pet_fonce:4230:29117860,29112775:pet_fonce:4230:29117042,29112780:pet_fonce:4230:29116571,29112784:pet_fonce:4230:29116737,29112789:pet_fonce:4230:29116509,29112807:pet_fonce:4230:29116141,29112826:pet_fonce:4230:29116088,29112828:pet_fonce:4230:29115556,29112831:pet_fonce:4230:29115283,29112832:pet_fonce:4230:29114990,29112846:pet_fonce:4230:29114578,29112860:pet_fonce:4230:29114118,29112862:pet_fonce:4230:29113878,2'}), 'main_stat': {'nb_photos': 1470}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-12', 0.7265573334042384),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_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', '1.48%', 14556], 'carton': ['carton', '5.21%', 80914], 'metal': ['metal', '0.18%', 1637], 'papier': ['papier', '19.76%', 268698], 'pehd': ['pehd', '0.3%', 1801], 'pet_clair': ['pet_clair', '1.67%', 25421], 'pet_fonce': ['pet_fonce', '0.26%', 681]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_12_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.74user 2.76system 0:06.62elapsed 83%CPU (0avgtext+0avgdata 183888maxresident)k 8inputs+280outputs (0major+48098minor)pagefaults 0swaps