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-08 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_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 : (4, 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 : 08 mtr_id : dashboard_places : SCCU_cam7 date : 2025-08 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2025-08%') and created_at like '%2025-08%'))); nb_day : (4, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 08 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 08 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%082025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-08-01 : dt_date_just_month_year : 2025-08-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_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-08-01" AND ded.date <= "2025-08-31" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (2056923,2061677,2062289,2069407,2077253,2084729,2092449,2099717,2103947,2104515,2111945,2119829,2121855,2129597,2136741,2140385,2147845,2154191,2161059,2166125,2170029,2174075,2174713,2180789,2187779,2194889,2201511,2208131,2212789,2213809) 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.012561692582422374, 'nb_photo': 20957, 'list_port_cont': '25591951,25592932,25592975,25593049,25593123,25593247,25593352,25593413,25593492,25593579,25593765,25595287,25595719,25595902,25595976,25596096,25596185,25596835,25598824,25598958,25602875,25602955,25603143,25603520,25609617,25610151,25610728,25611414,25611958,25612581,25613042,25613672,25614240,25614621,25615904,25615976,25616062,25616087,25616130,25616230,25616266,25616310,25616403,25616407,25616460,25616516,25616813,25617251,25621962,25622011,25622014,25622082,25622120,25622161,25622221,25622267,25622299,25622337,25622382,25622397,25622439,25622527,25622558,25622584,25622673,25622694,25622739,25622776,25622856,25622875,25624342,25624482,25651657,25653640,25653824,25654007,25654327,25654419,25654597,25654816,25654863,25655067,25655102,25655180,25655229,25655357,25655519,25655573,25655649,25655675,25655804,25655920,25656018,25656217,25656291,25656769,25664516,25665741,25667468,25670085,25672980,25675596,25679103,25682375,25684861,25686715,25688709,25691357,25693719,25695680,25698244,25700561,25702469,2570409', 'assoc_port': '25585951:25591951,25592808:25596185,25592812:25593492,25592815:25603520,25592820:25593413,25592823:25593352,25592828:25602955,25592831:25595976,25592833:25593765,25592837:25596096,25592840:25593579,25592842:25598958,25592843:25603143,25592845:25593123,25592846:25593247,25592848:25598824,25592849:25595902,25592851:25593049,25592852:25595719,25592853:25602875,25592854:25592932,25592855:25592975,25594536:25596835,25595247:25595287,25609538:25609617,25609986:25610151,25610558:25610728,25611226:25611414,25611836:25611958,25612497:25612581,25612967:25613042,25613553:25613672,25614079:25614240,25614559:25616407,25614563:25616516,25614566:25616310,25614570:25616266,25614574:25614621,25614578:25616230,25614582:25616460,25614584:25616403,25614587:25616130,25614589:25616087,25614592:25615904,25614594:25616062,25614597:25615976,25616550:25616813,25617206:25617251,25621919:25622776,25621921:25622739,25621923:25622558,25621926:25622694,25621928:25622584,25621931:25622856,25621933:25622439,25621936:25622527,25621938:2562287', 'assoc_mat': '25585951:autre:4230:25591951,25592808:autre:4230:25596185,25592812:autre:4230:25593492,25592815:autre:4230:25603520,25592820:autre:4230:25593413,25592823:autre:4230:25593352,25592828:autre:4230:25602955,25592831:autre:4230:25595976,25592833:autre:4230:25593765,25592837:autre:4230:25596096,25592840:autre:4230:25593579,25592842:autre:4230:25598958,25592843:autre:4230:25603143,25592845:autre:4230:25593123,25592846:autre:4230:25593247,25592848:autre:4230:25598824,25592849:autre:4230:25595902,25592851:autre:4230:25593049,25592852:autre:4230:25595719,25592853:autre:4230:25602875,25592854:autre:4230:25592932,25592855:autre:4230:25592975,25594536:autre:4230:25596835,25595247:autre:4230:25595287,25609538:autre:4230:25609617,25609986:autre:4230:25610151,25610558:autre:4230:25610728,25611226:autre:4230:25611414,25611836:autre:4230:25611958,25612497:autre:4230:25612581,25612967:autre:4230:25613042,25613553:autre:4230:25613672,25614079:autre:4230:25614240,25614559:autre:4230:25616407,25614563:autre:4230:25616516,25614566:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06306379182155027, 'nb_photo': 154883, 'list_port_cont': '25591947,25592940,25592987,25593055,25593124,25593257,25593363,25593422,25593480,25593583,25593770,25595283,25595723,25595913,25595978,25596098,25596182,25596827,25598840,25598973,25602868,25602972,25603153,25603510,25609627,25610160,25610737,25611413,25611980,25612585,25613038,25613669,25614237,25614632,25615896,25615985,25616059,25616100,25616141,25616232,25616277,25616306,25616401,25616416,25616470,25616523,25616812,25617264,25621965,25622012,25622021,25622087,25622121,25622152,25622228,25622271,25622306,25622342,25622373,25622389,25622444,25622524,25622561,25622597,25622669,25622696,25622740,25622781,25622852,25622883,25624350,25624492,25651669,25653649,25653835,25654022,25654339,25654431,25654599,25654824,25654859,25655064,25655106,25655187,25655236,25655358,25655521,25655580,25655665,25655685,25655806,25655925,25656021,25656226,25656296,25656762,25664519,25665743,25667485,25670086,25672986,25675607,25679102,25682382,25684884,25686722,25688715,25691363,25693722,25695700,25698251,25700560,25702471,2570410', 'assoc_port': '25585951:25591947,25592808:25596182,25592812:25593480,25592815:25603510,25592820:25593422,25592823:25593363,25592828:25602972,25592831:25595978,25592833:25593770,25592837:25596098,25592840:25593583,25592842:25598973,25592843:25603153,25592845:25593124,25592846:25593257,25592848:25598840,25592849:25595913,25592851:25593055,25592852:25595723,25592853:25602868,25592854:25592940,25592855:25592987,25594536:25596827,25595247:25595283,25609538:25609627,25609986:25610160,25610558:25610737,25611226:25611413,25611836:25611980,25612497:25612585,25612967:25613038,25613553:25613669,25614079:25614237,25614559:25616416,25614563:25616523,25614566:25616306,25614570:25616277,25614574:25614632,25614578:25616232,25614582:25616470,25614584:25616401,25614587:25616141,25614589:25616100,25614592:25615896,25614594:25616059,25614597:25615985,25616550:25616812,25617206:25617264,25621919:25622781,25621921:25622740,25621923:25622561,25621926:25622696,25621928:25622597,25621931:25622852,25621933:25622444,25621936:25622524,25621938:2562288', 'assoc_mat': '25585951:carton:4230:25591947,25592808:carton:4230:25596182,25592812:carton:4230:25593480,25592815:carton:4230:25603510,25592820:carton:4230:25593422,25592823:carton:4230:25593363,25592828:carton:4230:25602972,25592831:carton:4230:25595978,25592833:carton:4230:25593770,25592837:carton:4230:25596098,25592840:carton:4230:25593583,25592842:carton:4230:25598973,25592843:carton:4230:25603153,25592845:carton:4230:25593124,25592846:carton:4230:25593257,25592848:carton:4230:25598840,25592849:carton:4230:25595913,25592851:carton:4230:25593055,25592852:carton:4230:25595723,25592853:carton:4230:25602868,25592854:carton:4230:25592940,25592855:carton:4230:25592987,25594536:carton:4230:25596827,25595247:carton:4230:25595283,25609538:carton:4230:25609627,25609986:carton:4230:25610160,25610558:carton:4230:25610737,25611226:carton:4230:25611413,25611836:carton:4230:25611980,25612497:carton:4230:25612585,25612967:carton:4230:25613038,25613553:carton:4230:25613669,25614079:carton:4230:25614237,25614559:carton:4230:25616416,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014115509667752086, 'nb_photo': 2395, 'list_port_cont': '25591952,25592943,25592977,25593060,25593131,25593248,25593362,25593415,25593490,25593585,25593760,25595292,25595712,25595918,25595967,25596083,25596173,25596828,25598962,25603138,25603518,25609625,25610153,25610727,25611397,25611978,25612592,25613034,25613658,25614232,25614624,25615888,25615989,25616049,25616093,25616140,25616226,25616267,25616390,25616410,25616478,25616521,25617266,25622157,25622234,25622269,25622302,25622331,25622380,25622411,25622453,25622528,25622585,25622672,25622699,25622846,25622881,25651655,25653652,25654416,25654865,25655072,25655109,25655172,25655242,25655349,25655512,25655582,25655650,25655673,25655821,25655927,25656010,25656225,25656304,25656764,25664520,25665737,25667477,25670077,25672975,25675595,25679092,25682391,25684875,25686721,25688710,25691361,25693723,25695697,25698249,25700562,25704096,25706014,25706326,25706443,25706486,25706603,25707053,25747256,25747725,25748346,25748541,25748675,25749367,25749535,25749824,25749911,25749938,25750249,25750518,25750644,25750914,2575098', 'assoc_port': '25585951:25591952,25592808:25596173,25592812:25593490,25592815:25603518,25592820:25593415,25592823:25593362,25592831:25595967,25592833:25593760,25592837:25596083,25592840:25593585,25592842:25598962,25592843:25603138,25592845:25593131,25592846:25593248,25592849:25595918,25592851:25593060,25592852:25595712,25592854:25592943,25592855:25592977,25594536:25596828,25595247:25595292,25609538:25609625,25609986:25610153,25610558:25610727,25611226:25611397,25611836:25611978,25612497:25612592,25612967:25613034,25613553:25613658,25614079:25614232,25614559:25616410,25614563:25616521,25614570:25616267,25614574:25614624,25614578:25616226,25614582:25616478,25614584:25616390,25614587:25616140,25614589:25616093,25614592:25615888,25614594:25616049,25614597:25615989,25617206:25617266,25621926:25622699,25621928:25622585,25621931:25622846,25621933:25622453,25621936:25622528,25621938:25622881,25621940:25622302,25621943:25622411,25621945:25622672,25621946:25622380,25621948:25622331,25621950:25622157,25621952:25622269,25621955:2562223', 'assoc_mat': '25585951:metal:4230:25591952,25592808:metal:4230:25596173,25592812:metal:4230:25593490,25592815:metal:4230:25603518,25592820:metal:4230:25593415,25592823:metal:4230:25593362,25592831:metal:4230:25595967,25592833:metal:4230:25593760,25592837:metal:4230:25596083,25592840:metal:4230:25593585,25592842:metal:4230:25598962,25592843:metal:4230:25603138,25592845:metal:4230:25593131,25592846:metal:4230:25593248,25592849:metal:4230:25595918,25592851:metal:4230:25593060,25592852:metal:4230:25595712,25592854:metal:4230:25592943,25592855:metal:4230:25592977,25594536:metal:4230:25596828,25595247:metal:4230:25595292,25609538:metal:4230:25609625,25609986:metal:4230:25610153,25610558:metal:4230:25610727,25611226:metal:4230:25611397,25611836:metal:4230:25611978,25612497:metal:4230:25612592,25612967:metal:4230:25613034,25613553:metal:4230:25613658,25614079:metal:4230:25614232,25614559:metal:4230:25616410,25614563:metal:4230:25616521,25614570:metal:4230:25616267,25614574:metal:4230:25614624,25614578:metal:4230:25616226,25614582:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1563022616222523, 'nb_photo': 417773, 'list_port_cont': '25591946,25592935,25592989,25593052,25593125,25593251,25593359,25593428,25593487,25593577,25593771,25595291,25595724,25595919,25595977,25596097,25596181,25596836,25598838,25598965,25602873,25602969,25603152,25603508,25609619,25610155,25610734,25611412,25611982,25612590,25613046,25613673,25614234,25614633,25615899,25615990,25616060,25616098,25616135,25616227,25616271,25616302,25616395,25616413,25616476,25616515,25616822,25617263,25621975,25622000,25622031,25622086,25622124,25622159,25622235,25622270,25622309,25622344,25622371,25622386,25622450,25622525,25622557,25622593,25622663,25622707,25622734,25622777,25622844,25622890,25624348,25624486,25651672,25653646,25653831,25654009,25654338,25654415,25654595,25654825,25654861,25655065,25655112,25655185,25655241,25655360,25655511,25655576,25655666,25655676,25655816,25655930,25656017,25656223,25656295,25656766,25664524,25665739,25667462,25670084,25672981,25675603,25679099,25682389,25684882,25686717,25688711,25691356,25693724,25695701,25698245,25700557,25702457,2570410', 'assoc_port': '25585951:25591946,25592808:25596181,25592812:25593487,25592815:25603508,25592820:25593428,25592823:25593359,25592828:25602969,25592831:25595977,25592833:25593771,25592837:25596097,25592840:25593577,25592842:25598965,25592843:25603152,25592845:25593125,25592846:25593251,25592848:25598838,25592849:25595919,25592851:25593052,25592852:25595724,25592853:25602873,25592854:25592935,25592855:25592989,25594536:25596836,25595247:25595291,25609538:25609619,25609986:25610155,25610558:25610734,25611226:25611412,25611836:25611982,25612497:25612590,25612967:25613046,25613553:25613673,25614079:25614234,25614559:25616413,25614563:25616515,25614566:25616302,25614570:25616271,25614574:25614633,25614578:25616227,25614582:25616476,25614584:25616395,25614587:25616135,25614589:25616098,25614592:25615899,25614594:25616060,25614597:25615990,25616550:25616822,25617206:25617263,25621919:25622777,25621921:25622734,25621923:25622557,25621926:25622707,25621928:25622593,25621931:25622844,25621933:25622450,25621936:25622525,25621938:2562289', 'assoc_mat': '25585951:papier:4230:25591946,25592808:papier:4230:25596181,25592812:papier:4230:25593487,25592815:papier:4230:25603508,25592820:papier:4230:25593428,25592823:papier:4230:25593359,25592828:papier:4230:25602969,25592831:papier:4230:25595977,25592833:papier:4230:25593771,25592837:papier:4230:25596097,25592840:papier:4230:25593577,25592842:papier:4230:25598965,25592843:papier:4230:25603152,25592845:papier:4230:25593125,25592846:papier:4230:25593251,25592848:papier:4230:25598838,25592849:papier:4230:25595919,25592851:papier:4230:25593052,25592852:papier:4230:25595724,25592853:papier:4230:25602873,25592854:papier:4230:25592935,25592855:papier:4230:25592989,25594536:papier:4230:25596836,25595247:papier:4230:25595291,25609538:papier:4230:25609619,25609986:papier:4230:25610155,25610558:papier:4230:25610734,25611226:papier:4230:25611412,25611836:papier:4230:25611982,25612497:papier:4230:25612590,25612967:papier:4230:25613046,25613553:papier:4230:25613673,25614079:papier:4230:25614234,25614559:papier:4230:25616413,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002985368302241439, 'nb_photo': 2014, 'list_port_cont': '25592944,25593573,25593761,25595280,25595982,25596186,25598969,25602879,25602970,25603147,25610732,25611411,25611972,25612578,25613044,25613665,25614243,25615982,25616228,25616397,25616421,25616475,25616819,25622147,25622345,25622376,25622888,25651667,25654430,25654867,25655070,25655103,25655186,25655243,25655355,25655520,25655578,25655664,25655684,25655817,25656016,25656214,25656767,25664526,25670073,25679097,25682381,25686719,25688714,25691359,25693730,25695690,25700563,25702462,25704103,25706330,25706451,25706484,25706613,25747734,25748337,25748533,25749360,25749910,25749955,25750258,25750519,25750922,25750983,25751090,25751129,25796235,25796393,25796494,25796583,25796624,25796664,25796710,25796800,25796808,25796919,25797084,25824538,25826128,25826243,25826397,25826440,25826542,25826646,25826836,25826957,25827045,25827114,25827171,25827284,25827345,25828312,25828921,25831599,25852580,25852634,25852712,25852830,25852915,25852947,25852978,25853010,25853079,25853134,25853182,25853240,25853273,25853316,2585334', 'assoc_port': '25592808:25596186,25592828:25602970,25592831:25595982,25592833:25593761,25592840:25593573,25592842:25598969,25592843:25603147,25592853:25602879,25592854:25592944,25595247:25595280,25610558:25610732,25611226:25611411,25611836:25611972,25612497:25612578,25612967:25613044,25613553:25613665,25614079:25614243,25614559:25616421,25614578:25616228,25614582:25616475,25614584:25616397,25614597:25615982,25616550:25616819,25621938:25622888,25621946:25622376,25621948:25622345,25621950:25622147,25651313:25655243,25651314:25655520,25651316:25655684,25651318:25656016,25651321:25656214,25651322:25655664,25651323:25655817,25651326:25655355,25651327:25655578,25651329:25655103,25651330:25655186,25651331:25655070,25651333:25654867,25651346:25651667,25653971:25654430,25656627:25656767,25664468:25664526,25669657:25670073,25678517:25679097,25682025:25682381,25686291:25686719,25688323:25688714,25690709:25691359,25693250:25693730,25695440:25695690,25700142:25700563,25702306:25702462,25703761:25706330,25703765:25706451,25703767:2570648', 'assoc_mat': '25592808:pehd:4230:25596186,25592828:pehd:4230:25602970,25592831:pehd:4230:25595982,25592833:pehd:4230:25593761,25592840:pehd:4230:25593573,25592842:pehd:4230:25598969,25592843:pehd:4230:25603147,25592853:pehd:4230:25602879,25592854:pehd:4230:25592944,25595247:pehd:4230:25595280,25610558:pehd:4230:25610732,25611226:pehd:4230:25611411,25611836:pehd:4230:25611972,25612497:pehd:4230:25612578,25612967:pehd:4230:25613044,25613553:pehd:4230:25613665,25614079:pehd:4230:25614243,25614559:pehd:4230:25616421,25614578:pehd:4230:25616228,25614582:pehd:4230:25616475,25614584:pehd:4230:25616397,25614597:pehd:4230:25615982,25616550:pehd:4230:25616819,25621938:pehd:4230:25622888,25621946:pehd:4230:25622376,25621948:pehd:4230:25622345,25621950:pehd:4230:25622147,25651313:pehd:4230:25655243,25651314:pehd:4230:25655520,25651316:pehd:4230:25655684,25651318:pehd:4230:25656016,25651321:pehd:4230:25656214,25651322:pehd:4230:25655664,25651323:pehd:4230:25655817,25651326:pehd:4230:25655355,25651327:pehd:4230:25655578,25651329:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010642639683317887, 'nb_photo': 22706, 'list_port_cont': '25591953,25592936,25592976,25593050,25593129,25593255,25593360,25593417,25593477,25593578,25593773,25595290,25595714,25595914,25595975,25596099,25596183,25596829,25598835,25598974,25602878,25602968,25603154,25603515,25609623,25610157,25610739,25611402,25611976,25612591,25613047,25613663,25614233,25614639,25615897,25615987,25616057,25616094,25616129,25616234,25616279,25616316,25616399,25616419,25616472,25616524,25616821,25617259,25621972,25622005,25622025,25622084,25622118,25622156,25622229,25622272,25622296,25622346,25622375,25622401,25622451,25622521,25622553,25622601,25622665,25622704,25622737,25622772,25622855,25622891,25624345,25624487,25651671,25653650,25653836,25654014,25654342,25654418,25654588,25654817,25654866,25655063,25655114,25655183,25655234,25655363,25655518,25655584,25655658,25655677,25655820,25655919,25656022,25656224,25656305,25656759,25664528,25665735,25667479,25670083,25672988,25675608,25679105,25682388,25684894,25686712,25688716,25691366,25693720,25695686,25698247,25700559,25702464,2570409', 'assoc_port': '25585951:25591953,25592808:25596183,25592812:25593477,25592815:25603515,25592820:25593417,25592823:25593360,25592828:25602968,25592831:25595975,25592833:25593773,25592837:25596099,25592840:25593578,25592842:25598974,25592843:25603154,25592845:25593129,25592846:25593255,25592848:25598835,25592849:25595914,25592851:25593050,25592852:25595714,25592853:25602878,25592854:25592936,25592855:25592976,25594536:25596829,25595247:25595290,25609538:25609623,25609986:25610157,25610558:25610739,25611226:25611402,25611836:25611976,25612497:25612591,25612967:25613047,25613553:25613663,25614079:25614233,25614559:25616419,25614563:25616524,25614566:25616316,25614570:25616279,25614574:25614639,25614578:25616234,25614582:25616472,25614584:25616399,25614587:25616129,25614589:25616094,25614592:25615897,25614594:25616057,25614597:25615987,25616550:25616821,25617206:25617259,25621919:25622772,25621921:25622737,25621923:25622553,25621926:25622704,25621928:25622601,25621931:25622855,25621933:25622451,25621936:25622521,25621938:2562289', 'assoc_mat': '25585951:pet_clair:4230:25591953,25592808:pet_clair:4230:25596183,25592812:pet_clair:4230:25593477,25592815:pet_clair:4230:25603515,25592820:pet_clair:4230:25593417,25592823:pet_clair:4230:25593360,25592828:pet_clair:4230:25602968,25592831:pet_clair:4230:25595975,25592833:pet_clair:4230:25593773,25592837:pet_clair:4230:25596099,25592840:pet_clair:4230:25593578,25592842:pet_clair:4230:25598974,25592843:pet_clair:4230:25603154,25592845:pet_clair:4230:25593129,25592846:pet_clair:4230:25593255,25592848:pet_clair:4230:25598835,25592849:pet_clair:4230:25595914,25592851:pet_clair:4230:25593050,25592852:pet_clair:4230:25595714,25592853:pet_clair:4230:25602878,25592854:pet_clair:4230:25592936,25592855:pet_clair:4230:25592976,25594536:pet_clair:4230:25596829,25595247:pet_clair:4230:25595290,25609538:pet_clair:4230:25609623,25609986:pet_clair:4230:25610157,25610558:pet_clair:4230:25610739,25611226:pet_clair:4230:25611402,25611836:pet_clair:4230:25611976,25612497:pet_clair:4230:25612591,25612967:pet_clair:4230:25613047,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022113715121430903, 'nb_photo': 1016, 'list_port_cont': '25591949,25593258,25593358,25593488,25593574,25593772,25595968,25596094,25596177,25598976,25602871,25602965,25603150,25611407,25611988,25612589,25613040,25613674,25614239,25614638,25615902,25615983,25616055,25616091,25616142,25616820,25622230,25622310,25622339,25622379,25622403,25622666,25654593,25655069,25655111,25655189,25655238,25655365,25655516,25655680,25656020,25656303,25667471,25670082,25675604,25679104,25682390,25684879,25688718,25698241,25700555,25702472,25706342,25706452,25706615,25707041,25746880,25747249,25748348,25748539,25748672,25748949,25749366,25749541,25749661,25749916,25749941,25750256,25750517,25750651,25750929,25750989,25751087,25751136,25796230,25796271,25796395,25796492,25796627,25796659,25796700,25796751,25796791,25796813,25796894,25796930,25797038,25797163,25797251,25797292,25798520,25799712,25824520,25826134,25826244,25826394,25826435,25826549,25826638,25826840,25826960,25827051,25827123,25827163,25827295,25827338,25827436,25827611,25827991,25828069,25828107,25828319,25828446,2582891', 'assoc_port': '25585951:25591949,25592808:25596177,25592812:25593488,25592823:25593358,25592828:25602965,25592831:25595968,25592833:25593772,25592837:25596094,25592840:25593574,25592842:25598976,25592843:25603150,25592846:25593258,25592853:25602871,25611226:25611407,25611836:25611988,25612497:25612589,25612967:25613040,25613553:25613674,25614079:25614239,25614574:25614638,25614587:25616142,25614589:25616091,25614592:25615902,25614594:25616055,25614597:25615983,25616550:25616820,25621940:25622310,25621943:25622403,25621945:25622666,25621946:25622379,25621948:25622339,25621955:25622230,25651309:25654593,25651313:25655238,25651314:25655516,25651316:25655680,25651318:25656020,25651319:25656303,25651326:25655365,25651329:25655111,25651330:25655189,25651331:25655069,25667252:25667471,25669657:25670082,25675223:25675604,25678517:25679104,25682025:25682390,25684589:25684879,25688323:25688718,25697551:25698241,25700142:25700555,25702306:25702472,25703761:25706342,25703765:25706452,25703774:25706615,25706895:25707041,25746127:2574954', 'assoc_mat': '25585951:pet_fonce:4230:25591949,25592808:pet_fonce:4230:25596177,25592812:pet_fonce:4230:25593488,25592823:pet_fonce:4230:25593358,25592828:pet_fonce:4230:25602965,25592831:pet_fonce:4230:25595968,25592833:pet_fonce:4230:25593772,25592837:pet_fonce:4230:25596094,25592840:pet_fonce:4230:25593574,25592842:pet_fonce:4230:25598976,25592843:pet_fonce:4230:25603150,25592846:pet_fonce:4230:25593258,25592853:pet_fonce:4230:25602871,25611226:pet_fonce:4230:25611407,25611836:pet_fonce:4230:25611988,25612497:pet_fonce:4230:25612589,25612967:pet_fonce:4230:25613040,25613553:pet_fonce:4230:25613674,25614079:pet_fonce:4230:25614239,25614574:pet_fonce:4230:25614638,25614587:pet_fonce:4230:25616142,25614589:pet_fonce:4230:25616091,25614592:pet_fonce:4230:25615902,25614594:pet_fonce:4230:25616055,25614597:pet_fonce:4230:25615983,25616550:pet_fonce:4230:25616820,25621940:pet_fonce:4230:25622310,25621943:pet_fonce:4230:25622403,25621945:pet_fonce:4230:25622666,25621946:pet_fonce:4230:25622379,25621948:pet_fonce:4230:25622339,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(2056923,2061677,2062289,2069407,2077253,2084729,2092449,2099717,2103947,2104515,2111945,2119829,2121855,2129597,2136741,2140385,2147845,2154191,2161059,2166125,2170029,2174075,2174713,2180789,2187779,2194889,2201511,2208131,2212789,2213809)); 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-08-01' and date <= '2025-08-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2223,),), 'unwanted_material_monthly_percentage': ((0.7725448692742881,),), 'material_repartition': (('incineration', 2219),), 'material_dict': {'incineration': 2219}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 8, 1), 0.8436056889553188, 4), (datetime.date(2025, 8, 2), 0.8477600674363825, 2), (datetime.date(2025, 8, 3), 0.8757499257052777, 2), (datetime.date(2025, 8, 4), 0.8494943684948052, 3), (datetime.date(2025, 8, 5), 0.8164967728933511, 4), (datetime.date(2025, 8, 6), 0.8228056638385527, 3), (datetime.date(2025, 8, 7), 0.788276437881812, 3), (datetime.date(2025, 8, 8), 0.6547000705255688, 3), (datetime.date(2025, 8, 9), 0.6675295367167469, 3), (datetime.date(2025, 8, 10), 0.722671742287966, 3), (datetime.date(2025, 8, 11), 0.7434356815036564, 2), (datetime.date(2025, 8, 12), 0.7424369886737613, 4), (datetime.date(2025, 8, 13), 0.7158420365892312, 2), (datetime.date(2025, 8, 14), 0.7356091405873249, 4), (datetime.date(2025, 8, 15), 0.778902289029302, 3), (datetime.date(2025, 8, 16), 0.7227595767504877, 4), (datetime.date(2025, 8, 17), 0.8598146991733467, 4), (datetime.date(2025, 8, 19), 0.7151292124590206, 1), (datetime.date(2025, 8, 20), 0.7555395361703068, 3), (datetime.date(2025, 8, 21), 0.7189929395719372, 4), (datetime.date(2025, 8, 22), 0.7650506021714879, 4), (datetime.date(2025, 8, 23), 0.7477083134361759, 4), (datetime.date(2025, 8, 24), 0.8000013124635227, 4), (datetime.date(2025, 8, 25), 0.7842042813208194, 1), (datetime.date(2025, 8, 26), 0.7869412911778886, 4), (datetime.date(2025, 8, 27), 0.8221515034912503, 4), (datetime.date(2025, 8, 28), 0.79758506903881, 4), (datetime.date(2025, 8, 29), 0.7953987465017591, 4), (datetime.date(2025, 8, 30), 0.7268220892596043, 4), (datetime.date(2025, 8, 31), 0.789634968188741, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 8, 1), 0.8436056889553188, 4), (datetime.date(2025, 8, 2), 0.8477600674363825, 2), (datetime.date(2025, 8, 3), 0.8757499257052777, 2), (datetime.date(2025, 8, 4), 0.8494943684948052, 3), (datetime.date(2025, 8, 5), 0.8164967728933511, 4), (datetime.date(2025, 8, 6), 0.8228056638385527, 3), (datetime.date(2025, 8, 7), 0.788276437881812, 3), (datetime.date(2025, 8, 8), 0.6547000705255688, 3), (datetime.date(2025, 8, 9), 0.6675295367167469, 3), (datetime.date(2025, 8, 10), 0.722671742287966, 3), (datetime.date(2025, 8, 11), 0.7434356815036564, 2), (datetime.date(2025, 8, 12), 0.7424369886737613, 4), (datetime.date(2025, 8, 13), 0.7158420365892312, 2), (datetime.date(2025, 8, 14), 0.7356091405873249, 4), (datetime.date(2025, 8, 15), 0.778902289029302, 3), (datetime.date(2025, 8, 16), 0.7227595767504877, 4), (datetime.date(2025, 8, 17), 0.8598146991733467, 4), (datetime.date(2025, 8, 19), 0.7151292124590206, 1), (datetime.date(2025, 8, 20), 0.7555395361703068, 3), (datetime.date(2025, 8, 21), 0.7189929395719372, 4), (datetime.date(2025, 8, 22), 0.7650506021714879, 4), (datetime.date(2025, 8, 23), 0.7477083134361759, 4), (datetime.date(2025, 8, 24), 0.8000013124635227, 4), (datetime.date(2025, 8, 25), 0.7842042813208194, 1), (datetime.date(2025, 8, 26), 0.7869412911778886, 4), (datetime.date(2025, 8, 27), 0.8221515034912503, 4), (datetime.date(2025, 8, 28), 0.79758506903881, 4), (datetime.date(2025, 8, 29), 0.7953987465017591, 4), (datetime.date(2025, 8, 30), 0.7268220892596043, 4), (datetime.date(2025, 8, 31), 0.789634968188741, 1))}, 'quality_array': [['-7.880332167880612', '01082025'], ['-7.807623373342185', '02082025'], ['-7.9536353999189835', '03082025'], ['-7.877284371185709', '04082025'], ['-7.802549857215383', '05082025'], ['-7.685023786998043', '06082025'], ['-7.855444817260359', '07082025'], ['-8.65568067194663', '08082025'], ['-8.540180593415961', '09082025'], ['-8.764126281785343', '10082025'], ['-8.652801506319566', '11082025'], ['-8.676929473433388', '12082025'], ['-8.392550800247701', '13082025'], ['-8.65845648145875', '14082025'], ['-8.986161950958033', '15082025'], ['-8.459397490101626', '16082025'], ['-8.557149924127224', '17082025'], ['-8.212374545811073', '19082025'], ['-8.599121364857957', '20082025'], ['-8.700156169844075', '21082025'], ['-8.688673412189027', '22082025'], ['-8.468591562561475', '23082025'], ['-8.608051685481223', '24082025'], ['-8.530069516326401', '25082025'], ['-8.540512992277495', '26082025'], ['-8.726055756851105', '27082025'], ['-8.743736036099367', '28082025'], ['-8.360859856641339', '29082025'], ['-8.46457811950197', '30082025'], ['-8.652484414014504', '31082025']], 'number_of_batch': ((670,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012561692582422374, 'nb_photo': 20957, 'list_port_cont': '25591951,25592932,25592975,25593049,25593123,25593247,25593352,25593413,25593492,25593579,25593765,25595287,25595719,25595902,25595976,25596096,25596185,25596835,25598824,25598958,25602875,25602955,25603143,25603520,25609617,25610151,25610728,25611414,25611958,25612581,25613042,25613672,25614240,25614621,25615904,25615976,25616062,25616087,25616130,25616230,25616266,25616310,25616403,25616407,25616460,25616516,25616813,25617251,25621962,25622011,25622014,25622082,25622120,25622161,25622221,25622267,25622299,25622337,25622382,25622397,25622439,25622527,25622558,25622584,25622673,25622694,25622739,25622776,25622856,25622875,25624342,25624482,25651657,25653640,25653824,25654007,25654327,25654419,25654597,25654816,25654863,25655067,25655102,25655180,25655229,25655357,25655519,25655573,25655649,25655675,25655804,25655920,25656018,25656217,25656291,25656769,25664516,25665741,25667468,25670085,25672980,25675596,25679103,25682375,25684861,25686715,25688709,25691357,25693719,25695680,25698244,25700561,25702469,2570409', 'assoc_port': '25585951:25591951,25592808:25596185,25592812:25593492,25592815:25603520,25592820:25593413,25592823:25593352,25592828:25602955,25592831:25595976,25592833:25593765,25592837:25596096,25592840:25593579,25592842:25598958,25592843:25603143,25592845:25593123,25592846:25593247,25592848:25598824,25592849:25595902,25592851:25593049,25592852:25595719,25592853:25602875,25592854:25592932,25592855:25592975,25594536:25596835,25595247:25595287,25609538:25609617,25609986:25610151,25610558:25610728,25611226:25611414,25611836:25611958,25612497:25612581,25612967:25613042,25613553:25613672,25614079:25614240,25614559:25616407,25614563:25616516,25614566:25616310,25614570:25616266,25614574:25614621,25614578:25616230,25614582:25616460,25614584:25616403,25614587:25616130,25614589:25616087,25614592:25615904,25614594:25616062,25614597:25615976,25616550:25616813,25617206:25617251,25621919:25622776,25621921:25622739,25621923:25622558,25621926:25622694,25621928:25622584,25621931:25622856,25621933:25622439,25621936:25622527,25621938:2562287', 'assoc_mat': '25585951:autre:4230:25591951,25592808:autre:4230:25596185,25592812:autre:4230:25593492,25592815:autre:4230:25603520,25592820:autre:4230:25593413,25592823:autre:4230:25593352,25592828:autre:4230:25602955,25592831:autre:4230:25595976,25592833:autre:4230:25593765,25592837:autre:4230:25596096,25592840:autre:4230:25593579,25592842:autre:4230:25598958,25592843:autre:4230:25603143,25592845:autre:4230:25593123,25592846:autre:4230:25593247,25592848:autre:4230:25598824,25592849:autre:4230:25595902,25592851:autre:4230:25593049,25592852:autre:4230:25595719,25592853:autre:4230:25602875,25592854:autre:4230:25592932,25592855:autre:4230:25592975,25594536:autre:4230:25596835,25595247:autre:4230:25595287,25609538:autre:4230:25609617,25609986:autre:4230:25610151,25610558:autre:4230:25610728,25611226:autre:4230:25611414,25611836:autre:4230:25611958,25612497:autre:4230:25612581,25612967:autre:4230:25613042,25613553:autre:4230:25613672,25614079:autre:4230:25614240,25614559:autre:4230:25616407,25614563:autre:4230:25616516,25614566:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06306379182155027, 'nb_photo': 154883, 'list_port_cont': '25591947,25592940,25592987,25593055,25593124,25593257,25593363,25593422,25593480,25593583,25593770,25595283,25595723,25595913,25595978,25596098,25596182,25596827,25598840,25598973,25602868,25602972,25603153,25603510,25609627,25610160,25610737,25611413,25611980,25612585,25613038,25613669,25614237,25614632,25615896,25615985,25616059,25616100,25616141,25616232,25616277,25616306,25616401,25616416,25616470,25616523,25616812,25617264,25621965,25622012,25622021,25622087,25622121,25622152,25622228,25622271,25622306,25622342,25622373,25622389,25622444,25622524,25622561,25622597,25622669,25622696,25622740,25622781,25622852,25622883,25624350,25624492,25651669,25653649,25653835,25654022,25654339,25654431,25654599,25654824,25654859,25655064,25655106,25655187,25655236,25655358,25655521,25655580,25655665,25655685,25655806,25655925,25656021,25656226,25656296,25656762,25664519,25665743,25667485,25670086,25672986,25675607,25679102,25682382,25684884,25686722,25688715,25691363,25693722,25695700,25698251,25700560,25702471,2570410', 'assoc_port': '25585951:25591947,25592808:25596182,25592812:25593480,25592815:25603510,25592820:25593422,25592823:25593363,25592828:25602972,25592831:25595978,25592833:25593770,25592837:25596098,25592840:25593583,25592842:25598973,25592843:25603153,25592845:25593124,25592846:25593257,25592848:25598840,25592849:25595913,25592851:25593055,25592852:25595723,25592853:25602868,25592854:25592940,25592855:25592987,25594536:25596827,25595247:25595283,25609538:25609627,25609986:25610160,25610558:25610737,25611226:25611413,25611836:25611980,25612497:25612585,25612967:25613038,25613553:25613669,25614079:25614237,25614559:25616416,25614563:25616523,25614566:25616306,25614570:25616277,25614574:25614632,25614578:25616232,25614582:25616470,25614584:25616401,25614587:25616141,25614589:25616100,25614592:25615896,25614594:25616059,25614597:25615985,25616550:25616812,25617206:25617264,25621919:25622781,25621921:25622740,25621923:25622561,25621926:25622696,25621928:25622597,25621931:25622852,25621933:25622444,25621936:25622524,25621938:2562288', 'assoc_mat': '25585951:carton:4230:25591947,25592808:carton:4230:25596182,25592812:carton:4230:25593480,25592815:carton:4230:25603510,25592820:carton:4230:25593422,25592823:carton:4230:25593363,25592828:carton:4230:25602972,25592831:carton:4230:25595978,25592833:carton:4230:25593770,25592837:carton:4230:25596098,25592840:carton:4230:25593583,25592842:carton:4230:25598973,25592843:carton:4230:25603153,25592845:carton:4230:25593124,25592846:carton:4230:25593257,25592848:carton:4230:25598840,25592849:carton:4230:25595913,25592851:carton:4230:25593055,25592852:carton:4230:25595723,25592853:carton:4230:25602868,25592854:carton:4230:25592940,25592855:carton:4230:25592987,25594536:carton:4230:25596827,25595247:carton:4230:25595283,25609538:carton:4230:25609627,25609986:carton:4230:25610160,25610558:carton:4230:25610737,25611226:carton:4230:25611413,25611836:carton:4230:25611980,25612497:carton:4230:25612585,25612967:carton:4230:25613038,25613553:carton:4230:25613669,25614079:carton:4230:25614237,25614559:carton:4230:25616416,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014115509667752086, 'nb_photo': 2395, 'list_port_cont': '25591952,25592943,25592977,25593060,25593131,25593248,25593362,25593415,25593490,25593585,25593760,25595292,25595712,25595918,25595967,25596083,25596173,25596828,25598962,25603138,25603518,25609625,25610153,25610727,25611397,25611978,25612592,25613034,25613658,25614232,25614624,25615888,25615989,25616049,25616093,25616140,25616226,25616267,25616390,25616410,25616478,25616521,25617266,25622157,25622234,25622269,25622302,25622331,25622380,25622411,25622453,25622528,25622585,25622672,25622699,25622846,25622881,25651655,25653652,25654416,25654865,25655072,25655109,25655172,25655242,25655349,25655512,25655582,25655650,25655673,25655821,25655927,25656010,25656225,25656304,25656764,25664520,25665737,25667477,25670077,25672975,25675595,25679092,25682391,25684875,25686721,25688710,25691361,25693723,25695697,25698249,25700562,25704096,25706014,25706326,25706443,25706486,25706603,25707053,25747256,25747725,25748346,25748541,25748675,25749367,25749535,25749824,25749911,25749938,25750249,25750518,25750644,25750914,2575098', 'assoc_port': '25585951:25591952,25592808:25596173,25592812:25593490,25592815:25603518,25592820:25593415,25592823:25593362,25592831:25595967,25592833:25593760,25592837:25596083,25592840:25593585,25592842:25598962,25592843:25603138,25592845:25593131,25592846:25593248,25592849:25595918,25592851:25593060,25592852:25595712,25592854:25592943,25592855:25592977,25594536:25596828,25595247:25595292,25609538:25609625,25609986:25610153,25610558:25610727,25611226:25611397,25611836:25611978,25612497:25612592,25612967:25613034,25613553:25613658,25614079:25614232,25614559:25616410,25614563:25616521,25614570:25616267,25614574:25614624,25614578:25616226,25614582:25616478,25614584:25616390,25614587:25616140,25614589:25616093,25614592:25615888,25614594:25616049,25614597:25615989,25617206:25617266,25621926:25622699,25621928:25622585,25621931:25622846,25621933:25622453,25621936:25622528,25621938:25622881,25621940:25622302,25621943:25622411,25621945:25622672,25621946:25622380,25621948:25622331,25621950:25622157,25621952:25622269,25621955:2562223', 'assoc_mat': '25585951:metal:4230:25591952,25592808:metal:4230:25596173,25592812:metal:4230:25593490,25592815:metal:4230:25603518,25592820:metal:4230:25593415,25592823:metal:4230:25593362,25592831:metal:4230:25595967,25592833:metal:4230:25593760,25592837:metal:4230:25596083,25592840:metal:4230:25593585,25592842:metal:4230:25598962,25592843:metal:4230:25603138,25592845:metal:4230:25593131,25592846:metal:4230:25593248,25592849:metal:4230:25595918,25592851:metal:4230:25593060,25592852:metal:4230:25595712,25592854:metal:4230:25592943,25592855:metal:4230:25592977,25594536:metal:4230:25596828,25595247:metal:4230:25595292,25609538:metal:4230:25609625,25609986:metal:4230:25610153,25610558:metal:4230:25610727,25611226:metal:4230:25611397,25611836:metal:4230:25611978,25612497:metal:4230:25612592,25612967:metal:4230:25613034,25613553:metal:4230:25613658,25614079:metal:4230:25614232,25614559:metal:4230:25616410,25614563:metal:4230:25616521,25614570:metal:4230:25616267,25614574:metal:4230:25614624,25614578:metal:4230:25616226,25614582:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1563022616222523, 'nb_photo': 417773, 'list_port_cont': '25591946,25592935,25592989,25593052,25593125,25593251,25593359,25593428,25593487,25593577,25593771,25595291,25595724,25595919,25595977,25596097,25596181,25596836,25598838,25598965,25602873,25602969,25603152,25603508,25609619,25610155,25610734,25611412,25611982,25612590,25613046,25613673,25614234,25614633,25615899,25615990,25616060,25616098,25616135,25616227,25616271,25616302,25616395,25616413,25616476,25616515,25616822,25617263,25621975,25622000,25622031,25622086,25622124,25622159,25622235,25622270,25622309,25622344,25622371,25622386,25622450,25622525,25622557,25622593,25622663,25622707,25622734,25622777,25622844,25622890,25624348,25624486,25651672,25653646,25653831,25654009,25654338,25654415,25654595,25654825,25654861,25655065,25655112,25655185,25655241,25655360,25655511,25655576,25655666,25655676,25655816,25655930,25656017,25656223,25656295,25656766,25664524,25665739,25667462,25670084,25672981,25675603,25679099,25682389,25684882,25686717,25688711,25691356,25693724,25695701,25698245,25700557,25702457,2570410', 'assoc_port': '25585951:25591946,25592808:25596181,25592812:25593487,25592815:25603508,25592820:25593428,25592823:25593359,25592828:25602969,25592831:25595977,25592833:25593771,25592837:25596097,25592840:25593577,25592842:25598965,25592843:25603152,25592845:25593125,25592846:25593251,25592848:25598838,25592849:25595919,25592851:25593052,25592852:25595724,25592853:25602873,25592854:25592935,25592855:25592989,25594536:25596836,25595247:25595291,25609538:25609619,25609986:25610155,25610558:25610734,25611226:25611412,25611836:25611982,25612497:25612590,25612967:25613046,25613553:25613673,25614079:25614234,25614559:25616413,25614563:25616515,25614566:25616302,25614570:25616271,25614574:25614633,25614578:25616227,25614582:25616476,25614584:25616395,25614587:25616135,25614589:25616098,25614592:25615899,25614594:25616060,25614597:25615990,25616550:25616822,25617206:25617263,25621919:25622777,25621921:25622734,25621923:25622557,25621926:25622707,25621928:25622593,25621931:25622844,25621933:25622450,25621936:25622525,25621938:2562289', 'assoc_mat': '25585951:papier:4230:25591946,25592808:papier:4230:25596181,25592812:papier:4230:25593487,25592815:papier:4230:25603508,25592820:papier:4230:25593428,25592823:papier:4230:25593359,25592828:papier:4230:25602969,25592831:papier:4230:25595977,25592833:papier:4230:25593771,25592837:papier:4230:25596097,25592840:papier:4230:25593577,25592842:papier:4230:25598965,25592843:papier:4230:25603152,25592845:papier:4230:25593125,25592846:papier:4230:25593251,25592848:papier:4230:25598838,25592849:papier:4230:25595919,25592851:papier:4230:25593052,25592852:papier:4230:25595724,25592853:papier:4230:25602873,25592854:papier:4230:25592935,25592855:papier:4230:25592989,25594536:papier:4230:25596836,25595247:papier:4230:25595291,25609538:papier:4230:25609619,25609986:papier:4230:25610155,25610558:papier:4230:25610734,25611226:papier:4230:25611412,25611836:papier:4230:25611982,25612497:papier:4230:25612590,25612967:papier:4230:25613046,25613553:papier:4230:25613673,25614079:papier:4230:25614234,25614559:papier:4230:25616413,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002985368302241439, 'nb_photo': 2014, 'list_port_cont': '25592944,25593573,25593761,25595280,25595982,25596186,25598969,25602879,25602970,25603147,25610732,25611411,25611972,25612578,25613044,25613665,25614243,25615982,25616228,25616397,25616421,25616475,25616819,25622147,25622345,25622376,25622888,25651667,25654430,25654867,25655070,25655103,25655186,25655243,25655355,25655520,25655578,25655664,25655684,25655817,25656016,25656214,25656767,25664526,25670073,25679097,25682381,25686719,25688714,25691359,25693730,25695690,25700563,25702462,25704103,25706330,25706451,25706484,25706613,25747734,25748337,25748533,25749360,25749910,25749955,25750258,25750519,25750922,25750983,25751090,25751129,25796235,25796393,25796494,25796583,25796624,25796664,25796710,25796800,25796808,25796919,25797084,25824538,25826128,25826243,25826397,25826440,25826542,25826646,25826836,25826957,25827045,25827114,25827171,25827284,25827345,25828312,25828921,25831599,25852580,25852634,25852712,25852830,25852915,25852947,25852978,25853010,25853079,25853134,25853182,25853240,25853273,25853316,2585334', 'assoc_port': '25592808:25596186,25592828:25602970,25592831:25595982,25592833:25593761,25592840:25593573,25592842:25598969,25592843:25603147,25592853:25602879,25592854:25592944,25595247:25595280,25610558:25610732,25611226:25611411,25611836:25611972,25612497:25612578,25612967:25613044,25613553:25613665,25614079:25614243,25614559:25616421,25614578:25616228,25614582:25616475,25614584:25616397,25614597:25615982,25616550:25616819,25621938:25622888,25621946:25622376,25621948:25622345,25621950:25622147,25651313:25655243,25651314:25655520,25651316:25655684,25651318:25656016,25651321:25656214,25651322:25655664,25651323:25655817,25651326:25655355,25651327:25655578,25651329:25655103,25651330:25655186,25651331:25655070,25651333:25654867,25651346:25651667,25653971:25654430,25656627:25656767,25664468:25664526,25669657:25670073,25678517:25679097,25682025:25682381,25686291:25686719,25688323:25688714,25690709:25691359,25693250:25693730,25695440:25695690,25700142:25700563,25702306:25702462,25703761:25706330,25703765:25706451,25703767:2570648', 'assoc_mat': '25592808:pehd:4230:25596186,25592828:pehd:4230:25602970,25592831:pehd:4230:25595982,25592833:pehd:4230:25593761,25592840:pehd:4230:25593573,25592842:pehd:4230:25598969,25592843:pehd:4230:25603147,25592853:pehd:4230:25602879,25592854:pehd:4230:25592944,25595247:pehd:4230:25595280,25610558:pehd:4230:25610732,25611226:pehd:4230:25611411,25611836:pehd:4230:25611972,25612497:pehd:4230:25612578,25612967:pehd:4230:25613044,25613553:pehd:4230:25613665,25614079:pehd:4230:25614243,25614559:pehd:4230:25616421,25614578:pehd:4230:25616228,25614582:pehd:4230:25616475,25614584:pehd:4230:25616397,25614597:pehd:4230:25615982,25616550:pehd:4230:25616819,25621938:pehd:4230:25622888,25621946:pehd:4230:25622376,25621948:pehd:4230:25622345,25621950:pehd:4230:25622147,25651313:pehd:4230:25655243,25651314:pehd:4230:25655520,25651316:pehd:4230:25655684,25651318:pehd:4230:25656016,25651321:pehd:4230:25656214,25651322:pehd:4230:25655664,25651323:pehd:4230:25655817,25651326:pehd:4230:25655355,25651327:pehd:4230:25655578,25651329:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010642639683317887, 'nb_photo': 22706, 'list_port_cont': '25591953,25592936,25592976,25593050,25593129,25593255,25593360,25593417,25593477,25593578,25593773,25595290,25595714,25595914,25595975,25596099,25596183,25596829,25598835,25598974,25602878,25602968,25603154,25603515,25609623,25610157,25610739,25611402,25611976,25612591,25613047,25613663,25614233,25614639,25615897,25615987,25616057,25616094,25616129,25616234,25616279,25616316,25616399,25616419,25616472,25616524,25616821,25617259,25621972,25622005,25622025,25622084,25622118,25622156,25622229,25622272,25622296,25622346,25622375,25622401,25622451,25622521,25622553,25622601,25622665,25622704,25622737,25622772,25622855,25622891,25624345,25624487,25651671,25653650,25653836,25654014,25654342,25654418,25654588,25654817,25654866,25655063,25655114,25655183,25655234,25655363,25655518,25655584,25655658,25655677,25655820,25655919,25656022,25656224,25656305,25656759,25664528,25665735,25667479,25670083,25672988,25675608,25679105,25682388,25684894,25686712,25688716,25691366,25693720,25695686,25698247,25700559,25702464,2570409', 'assoc_port': '25585951:25591953,25592808:25596183,25592812:25593477,25592815:25603515,25592820:25593417,25592823:25593360,25592828:25602968,25592831:25595975,25592833:25593773,25592837:25596099,25592840:25593578,25592842:25598974,25592843:25603154,25592845:25593129,25592846:25593255,25592848:25598835,25592849:25595914,25592851:25593050,25592852:25595714,25592853:25602878,25592854:25592936,25592855:25592976,25594536:25596829,25595247:25595290,25609538:25609623,25609986:25610157,25610558:25610739,25611226:25611402,25611836:25611976,25612497:25612591,25612967:25613047,25613553:25613663,25614079:25614233,25614559:25616419,25614563:25616524,25614566:25616316,25614570:25616279,25614574:25614639,25614578:25616234,25614582:25616472,25614584:25616399,25614587:25616129,25614589:25616094,25614592:25615897,25614594:25616057,25614597:25615987,25616550:25616821,25617206:25617259,25621919:25622772,25621921:25622737,25621923:25622553,25621926:25622704,25621928:25622601,25621931:25622855,25621933:25622451,25621936:25622521,25621938:2562289', 'assoc_mat': '25585951:pet_clair:4230:25591953,25592808:pet_clair:4230:25596183,25592812:pet_clair:4230:25593477,25592815:pet_clair:4230:25603515,25592820:pet_clair:4230:25593417,25592823:pet_clair:4230:25593360,25592828:pet_clair:4230:25602968,25592831:pet_clair:4230:25595975,25592833:pet_clair:4230:25593773,25592837:pet_clair:4230:25596099,25592840:pet_clair:4230:25593578,25592842:pet_clair:4230:25598974,25592843:pet_clair:4230:25603154,25592845:pet_clair:4230:25593129,25592846:pet_clair:4230:25593255,25592848:pet_clair:4230:25598835,25592849:pet_clair:4230:25595914,25592851:pet_clair:4230:25593050,25592852:pet_clair:4230:25595714,25592853:pet_clair:4230:25602878,25592854:pet_clair:4230:25592936,25592855:pet_clair:4230:25592976,25594536:pet_clair:4230:25596829,25595247:pet_clair:4230:25595290,25609538:pet_clair:4230:25609623,25609986:pet_clair:4230:25610157,25610558:pet_clair:4230:25610739,25611226:pet_clair:4230:25611402,25611836:pet_clair:4230:25611976,25612497:pet_clair:4230:25612591,25612967:pet_clair:4230:25613047,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022113715121430903, 'nb_photo': 1016, 'list_port_cont': '25591949,25593258,25593358,25593488,25593574,25593772,25595968,25596094,25596177,25598976,25602871,25602965,25603150,25611407,25611988,25612589,25613040,25613674,25614239,25614638,25615902,25615983,25616055,25616091,25616142,25616820,25622230,25622310,25622339,25622379,25622403,25622666,25654593,25655069,25655111,25655189,25655238,25655365,25655516,25655680,25656020,25656303,25667471,25670082,25675604,25679104,25682390,25684879,25688718,25698241,25700555,25702472,25706342,25706452,25706615,25707041,25746880,25747249,25748348,25748539,25748672,25748949,25749366,25749541,25749661,25749916,25749941,25750256,25750517,25750651,25750929,25750989,25751087,25751136,25796230,25796271,25796395,25796492,25796627,25796659,25796700,25796751,25796791,25796813,25796894,25796930,25797038,25797163,25797251,25797292,25798520,25799712,25824520,25826134,25826244,25826394,25826435,25826549,25826638,25826840,25826960,25827051,25827123,25827163,25827295,25827338,25827436,25827611,25827991,25828069,25828107,25828319,25828446,2582891', 'assoc_port': '25585951:25591949,25592808:25596177,25592812:25593488,25592823:25593358,25592828:25602965,25592831:25595968,25592833:25593772,25592837:25596094,25592840:25593574,25592842:25598976,25592843:25603150,25592846:25593258,25592853:25602871,25611226:25611407,25611836:25611988,25612497:25612589,25612967:25613040,25613553:25613674,25614079:25614239,25614574:25614638,25614587:25616142,25614589:25616091,25614592:25615902,25614594:25616055,25614597:25615983,25616550:25616820,25621940:25622310,25621943:25622403,25621945:25622666,25621946:25622379,25621948:25622339,25621955:25622230,25651309:25654593,25651313:25655238,25651314:25655516,25651316:25655680,25651318:25656020,25651319:25656303,25651326:25655365,25651329:25655111,25651330:25655189,25651331:25655069,25667252:25667471,25669657:25670082,25675223:25675604,25678517:25679104,25682025:25682390,25684589:25684879,25688323:25688718,25697551:25698241,25700142:25700555,25702306:25702472,25703761:25706342,25703765:25706452,25703774:25706615,25706895:25707041,25746127:2574954', 'assoc_mat': '25585951:pet_fonce:4230:25591949,25592808:pet_fonce:4230:25596177,25592812:pet_fonce:4230:25593488,25592823:pet_fonce:4230:25593358,25592828:pet_fonce:4230:25602965,25592831:pet_fonce:4230:25595968,25592833:pet_fonce:4230:25593772,25592837:pet_fonce:4230:25596094,25592840:pet_fonce:4230:25593574,25592842:pet_fonce:4230:25598976,25592843:pet_fonce:4230:25603150,25592846:pet_fonce:4230:25593258,25592853:pet_fonce:4230:25602871,25611226:pet_fonce:4230:25611407,25611836:pet_fonce:4230:25611988,25612497:pet_fonce:4230:25612589,25612967:pet_fonce:4230:25613040,25613553:pet_fonce:4230:25613674,25614079:pet_fonce:4230:25614239,25614574:pet_fonce:4230:25614638,25614587:pet_fonce:4230:25616142,25614589:pet_fonce:4230:25616091,25614592:pet_fonce:4230:25615902,25614594:pet_fonce:4230:25616055,25614597:pet_fonce:4230:25615983,25616550:pet_fonce:4230:25616820,25621940:pet_fonce:4230:25622310,25621943:pet_fonce:4230:25622403,25621945:pet_fonce:4230:25622666,25621946:pet_fonce:4230:25622379,25621948:pet_fonce:4230:25622339,2'}), 'main_stat': {'nb_photos': 2223}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-08', 0.7725448692742881),)]} 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': ((2223,),), 'unwanted_material_monthly_percentage': ((0.7725448692742881,),), 'material_repartition': (('incineration', 2219),), 'material_dict': {'incineration': 2219}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 8, 1), 0.8436056889553188, 4), (datetime.date(2025, 8, 2), 0.8477600674363825, 2), (datetime.date(2025, 8, 3), 0.8757499257052777, 2), (datetime.date(2025, 8, 4), 0.8494943684948052, 3), (datetime.date(2025, 8, 5), 0.8164967728933511, 4), (datetime.date(2025, 8, 6), 0.8228056638385527, 3), (datetime.date(2025, 8, 7), 0.788276437881812, 3), (datetime.date(2025, 8, 8), 0.6547000705255688, 3), (datetime.date(2025, 8, 9), 0.6675295367167469, 3), (datetime.date(2025, 8, 10), 0.722671742287966, 3), (datetime.date(2025, 8, 11), 0.7434356815036564, 2), (datetime.date(2025, 8, 12), 0.7424369886737613, 4), (datetime.date(2025, 8, 13), 0.7158420365892312, 2), (datetime.date(2025, 8, 14), 0.7356091405873249, 4), (datetime.date(2025, 8, 15), 0.778902289029302, 3), (datetime.date(2025, 8, 16), 0.7227595767504877, 4), (datetime.date(2025, 8, 17), 0.8598146991733467, 4), (datetime.date(2025, 8, 19), 0.7151292124590206, 1), (datetime.date(2025, 8, 20), 0.7555395361703068, 3), (datetime.date(2025, 8, 21), 0.7189929395719372, 4), (datetime.date(2025, 8, 22), 0.7650506021714879, 4), (datetime.date(2025, 8, 23), 0.7477083134361759, 4), (datetime.date(2025, 8, 24), 0.8000013124635227, 4), (datetime.date(2025, 8, 25), 0.7842042813208194, 1), (datetime.date(2025, 8, 26), 0.7869412911778886, 4), (datetime.date(2025, 8, 27), 0.8221515034912503, 4), (datetime.date(2025, 8, 28), 0.79758506903881, 4), (datetime.date(2025, 8, 29), 0.7953987465017591, 4), (datetime.date(2025, 8, 30), 0.7268220892596043, 4), (datetime.date(2025, 8, 31), 0.789634968188741, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 8, 1), 0.8436056889553188, 4), (datetime.date(2025, 8, 2), 0.8477600674363825, 2), (datetime.date(2025, 8, 3), 0.8757499257052777, 2), (datetime.date(2025, 8, 4), 0.8494943684948052, 3), (datetime.date(2025, 8, 5), 0.8164967728933511, 4), (datetime.date(2025, 8, 6), 0.8228056638385527, 3), (datetime.date(2025, 8, 7), 0.788276437881812, 3), (datetime.date(2025, 8, 8), 0.6547000705255688, 3), (datetime.date(2025, 8, 9), 0.6675295367167469, 3), (datetime.date(2025, 8, 10), 0.722671742287966, 3), (datetime.date(2025, 8, 11), 0.7434356815036564, 2), (datetime.date(2025, 8, 12), 0.7424369886737613, 4), (datetime.date(2025, 8, 13), 0.7158420365892312, 2), (datetime.date(2025, 8, 14), 0.7356091405873249, 4), (datetime.date(2025, 8, 15), 0.778902289029302, 3), (datetime.date(2025, 8, 16), 0.7227595767504877, 4), (datetime.date(2025, 8, 17), 0.8598146991733467, 4), (datetime.date(2025, 8, 19), 0.7151292124590206, 1), (datetime.date(2025, 8, 20), 0.7555395361703068, 3), (datetime.date(2025, 8, 21), 0.7189929395719372, 4), (datetime.date(2025, 8, 22), 0.7650506021714879, 4), (datetime.date(2025, 8, 23), 0.7477083134361759, 4), (datetime.date(2025, 8, 24), 0.8000013124635227, 4), (datetime.date(2025, 8, 25), 0.7842042813208194, 1), (datetime.date(2025, 8, 26), 0.7869412911778886, 4), (datetime.date(2025, 8, 27), 0.8221515034912503, 4), (datetime.date(2025, 8, 28), 0.79758506903881, 4), (datetime.date(2025, 8, 29), 0.7953987465017591, 4), (datetime.date(2025, 8, 30), 0.7268220892596043, 4), (datetime.date(2025, 8, 31), 0.789634968188741, 1))}, 'quality_array': [['-7.880332167880612', '01082025'], ['-7.807623373342185', '02082025'], ['-7.9536353999189835', '03082025'], ['-7.877284371185709', '04082025'], ['-7.802549857215383', '05082025'], ['-7.685023786998043', '06082025'], ['-7.855444817260359', '07082025'], ['-8.65568067194663', '08082025'], ['-8.540180593415961', '09082025'], ['-8.764126281785343', '10082025'], ['-8.652801506319566', '11082025'], ['-8.676929473433388', '12082025'], ['-8.392550800247701', '13082025'], ['-8.65845648145875', '14082025'], ['-8.986161950958033', '15082025'], ['-8.459397490101626', '16082025'], ['-8.557149924127224', '17082025'], ['-8.212374545811073', '19082025'], ['-8.599121364857957', '20082025'], ['-8.700156169844075', '21082025'], ['-8.688673412189027', '22082025'], ['-8.468591562561475', '23082025'], ['-8.608051685481223', '24082025'], ['-8.530069516326401', '25082025'], ['-8.540512992277495', '26082025'], ['-8.726055756851105', '27082025'], ['-8.743736036099367', '28082025'], ['-8.360859856641339', '29082025'], ['-8.46457811950197', '30082025'], ['-8.652484414014504', '31082025']], 'number_of_batch': ((670,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012561692582422374, 'nb_photo': 20957, 'list_port_cont': '25591951,25592932,25592975,25593049,25593123,25593247,25593352,25593413,25593492,25593579,25593765,25595287,25595719,25595902,25595976,25596096,25596185,25596835,25598824,25598958,25602875,25602955,25603143,25603520,25609617,25610151,25610728,25611414,25611958,25612581,25613042,25613672,25614240,25614621,25615904,25615976,25616062,25616087,25616130,25616230,25616266,25616310,25616403,25616407,25616460,25616516,25616813,25617251,25621962,25622011,25622014,25622082,25622120,25622161,25622221,25622267,25622299,25622337,25622382,25622397,25622439,25622527,25622558,25622584,25622673,25622694,25622739,25622776,25622856,25622875,25624342,25624482,25651657,25653640,25653824,25654007,25654327,25654419,25654597,25654816,25654863,25655067,25655102,25655180,25655229,25655357,25655519,25655573,25655649,25655675,25655804,25655920,25656018,25656217,25656291,25656769,25664516,25665741,25667468,25670085,25672980,25675596,25679103,25682375,25684861,25686715,25688709,25691357,25693719,25695680,25698244,25700561,25702469,2570409', 'assoc_port': '25585951:25591951,25592808:25596185,25592812:25593492,25592815:25603520,25592820:25593413,25592823:25593352,25592828:25602955,25592831:25595976,25592833:25593765,25592837:25596096,25592840:25593579,25592842:25598958,25592843:25603143,25592845:25593123,25592846:25593247,25592848:25598824,25592849:25595902,25592851:25593049,25592852:25595719,25592853:25602875,25592854:25592932,25592855:25592975,25594536:25596835,25595247:25595287,25609538:25609617,25609986:25610151,25610558:25610728,25611226:25611414,25611836:25611958,25612497:25612581,25612967:25613042,25613553:25613672,25614079:25614240,25614559:25616407,25614563:25616516,25614566:25616310,25614570:25616266,25614574:25614621,25614578:25616230,25614582:25616460,25614584:25616403,25614587:25616130,25614589:25616087,25614592:25615904,25614594:25616062,25614597:25615976,25616550:25616813,25617206:25617251,25621919:25622776,25621921:25622739,25621923:25622558,25621926:25622694,25621928:25622584,25621931:25622856,25621933:25622439,25621936:25622527,25621938:2562287', 'assoc_mat': '25585951:autre:4230:25591951,25592808:autre:4230:25596185,25592812:autre:4230:25593492,25592815:autre:4230:25603520,25592820:autre:4230:25593413,25592823:autre:4230:25593352,25592828:autre:4230:25602955,25592831:autre:4230:25595976,25592833:autre:4230:25593765,25592837:autre:4230:25596096,25592840:autre:4230:25593579,25592842:autre:4230:25598958,25592843:autre:4230:25603143,25592845:autre:4230:25593123,25592846:autre:4230:25593247,25592848:autre:4230:25598824,25592849:autre:4230:25595902,25592851:autre:4230:25593049,25592852:autre:4230:25595719,25592853:autre:4230:25602875,25592854:autre:4230:25592932,25592855:autre:4230:25592975,25594536:autre:4230:25596835,25595247:autre:4230:25595287,25609538:autre:4230:25609617,25609986:autre:4230:25610151,25610558:autre:4230:25610728,25611226:autre:4230:25611414,25611836:autre:4230:25611958,25612497:autre:4230:25612581,25612967:autre:4230:25613042,25613553:autre:4230:25613672,25614079:autre:4230:25614240,25614559:autre:4230:25616407,25614563:autre:4230:25616516,25614566:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06306379182155027, 'nb_photo': 154883, 'list_port_cont': '25591947,25592940,25592987,25593055,25593124,25593257,25593363,25593422,25593480,25593583,25593770,25595283,25595723,25595913,25595978,25596098,25596182,25596827,25598840,25598973,25602868,25602972,25603153,25603510,25609627,25610160,25610737,25611413,25611980,25612585,25613038,25613669,25614237,25614632,25615896,25615985,25616059,25616100,25616141,25616232,25616277,25616306,25616401,25616416,25616470,25616523,25616812,25617264,25621965,25622012,25622021,25622087,25622121,25622152,25622228,25622271,25622306,25622342,25622373,25622389,25622444,25622524,25622561,25622597,25622669,25622696,25622740,25622781,25622852,25622883,25624350,25624492,25651669,25653649,25653835,25654022,25654339,25654431,25654599,25654824,25654859,25655064,25655106,25655187,25655236,25655358,25655521,25655580,25655665,25655685,25655806,25655925,25656021,25656226,25656296,25656762,25664519,25665743,25667485,25670086,25672986,25675607,25679102,25682382,25684884,25686722,25688715,25691363,25693722,25695700,25698251,25700560,25702471,2570410', 'assoc_port': '25585951:25591947,25592808:25596182,25592812:25593480,25592815:25603510,25592820:25593422,25592823:25593363,25592828:25602972,25592831:25595978,25592833:25593770,25592837:25596098,25592840:25593583,25592842:25598973,25592843:25603153,25592845:25593124,25592846:25593257,25592848:25598840,25592849:25595913,25592851:25593055,25592852:25595723,25592853:25602868,25592854:25592940,25592855:25592987,25594536:25596827,25595247:25595283,25609538:25609627,25609986:25610160,25610558:25610737,25611226:25611413,25611836:25611980,25612497:25612585,25612967:25613038,25613553:25613669,25614079:25614237,25614559:25616416,25614563:25616523,25614566:25616306,25614570:25616277,25614574:25614632,25614578:25616232,25614582:25616470,25614584:25616401,25614587:25616141,25614589:25616100,25614592:25615896,25614594:25616059,25614597:25615985,25616550:25616812,25617206:25617264,25621919:25622781,25621921:25622740,25621923:25622561,25621926:25622696,25621928:25622597,25621931:25622852,25621933:25622444,25621936:25622524,25621938:2562288', 'assoc_mat': '25585951:carton:4230:25591947,25592808:carton:4230:25596182,25592812:carton:4230:25593480,25592815:carton:4230:25603510,25592820:carton:4230:25593422,25592823:carton:4230:25593363,25592828:carton:4230:25602972,25592831:carton:4230:25595978,25592833:carton:4230:25593770,25592837:carton:4230:25596098,25592840:carton:4230:25593583,25592842:carton:4230:25598973,25592843:carton:4230:25603153,25592845:carton:4230:25593124,25592846:carton:4230:25593257,25592848:carton:4230:25598840,25592849:carton:4230:25595913,25592851:carton:4230:25593055,25592852:carton:4230:25595723,25592853:carton:4230:25602868,25592854:carton:4230:25592940,25592855:carton:4230:25592987,25594536:carton:4230:25596827,25595247:carton:4230:25595283,25609538:carton:4230:25609627,25609986:carton:4230:25610160,25610558:carton:4230:25610737,25611226:carton:4230:25611413,25611836:carton:4230:25611980,25612497:carton:4230:25612585,25612967:carton:4230:25613038,25613553:carton:4230:25613669,25614079:carton:4230:25614237,25614559:carton:4230:25616416,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014115509667752086, 'nb_photo': 2395, 'list_port_cont': '25591952,25592943,25592977,25593060,25593131,25593248,25593362,25593415,25593490,25593585,25593760,25595292,25595712,25595918,25595967,25596083,25596173,25596828,25598962,25603138,25603518,25609625,25610153,25610727,25611397,25611978,25612592,25613034,25613658,25614232,25614624,25615888,25615989,25616049,25616093,25616140,25616226,25616267,25616390,25616410,25616478,25616521,25617266,25622157,25622234,25622269,25622302,25622331,25622380,25622411,25622453,25622528,25622585,25622672,25622699,25622846,25622881,25651655,25653652,25654416,25654865,25655072,25655109,25655172,25655242,25655349,25655512,25655582,25655650,25655673,25655821,25655927,25656010,25656225,25656304,25656764,25664520,25665737,25667477,25670077,25672975,25675595,25679092,25682391,25684875,25686721,25688710,25691361,25693723,25695697,25698249,25700562,25704096,25706014,25706326,25706443,25706486,25706603,25707053,25747256,25747725,25748346,25748541,25748675,25749367,25749535,25749824,25749911,25749938,25750249,25750518,25750644,25750914,2575098', 'assoc_port': '25585951:25591952,25592808:25596173,25592812:25593490,25592815:25603518,25592820:25593415,25592823:25593362,25592831:25595967,25592833:25593760,25592837:25596083,25592840:25593585,25592842:25598962,25592843:25603138,25592845:25593131,25592846:25593248,25592849:25595918,25592851:25593060,25592852:25595712,25592854:25592943,25592855:25592977,25594536:25596828,25595247:25595292,25609538:25609625,25609986:25610153,25610558:25610727,25611226:25611397,25611836:25611978,25612497:25612592,25612967:25613034,25613553:25613658,25614079:25614232,25614559:25616410,25614563:25616521,25614570:25616267,25614574:25614624,25614578:25616226,25614582:25616478,25614584:25616390,25614587:25616140,25614589:25616093,25614592:25615888,25614594:25616049,25614597:25615989,25617206:25617266,25621926:25622699,25621928:25622585,25621931:25622846,25621933:25622453,25621936:25622528,25621938:25622881,25621940:25622302,25621943:25622411,25621945:25622672,25621946:25622380,25621948:25622331,25621950:25622157,25621952:25622269,25621955:2562223', 'assoc_mat': '25585951:metal:4230:25591952,25592808:metal:4230:25596173,25592812:metal:4230:25593490,25592815:metal:4230:25603518,25592820:metal:4230:25593415,25592823:metal:4230:25593362,25592831:metal:4230:25595967,25592833:metal:4230:25593760,25592837:metal:4230:25596083,25592840:metal:4230:25593585,25592842:metal:4230:25598962,25592843:metal:4230:25603138,25592845:metal:4230:25593131,25592846:metal:4230:25593248,25592849:metal:4230:25595918,25592851:metal:4230:25593060,25592852:metal:4230:25595712,25592854:metal:4230:25592943,25592855:metal:4230:25592977,25594536:metal:4230:25596828,25595247:metal:4230:25595292,25609538:metal:4230:25609625,25609986:metal:4230:25610153,25610558:metal:4230:25610727,25611226:metal:4230:25611397,25611836:metal:4230:25611978,25612497:metal:4230:25612592,25612967:metal:4230:25613034,25613553:metal:4230:25613658,25614079:metal:4230:25614232,25614559:metal:4230:25616410,25614563:metal:4230:25616521,25614570:metal:4230:25616267,25614574:metal:4230:25614624,25614578:metal:4230:25616226,25614582:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.1563022616222523, 'nb_photo': 417773, 'list_port_cont': '25591946,25592935,25592989,25593052,25593125,25593251,25593359,25593428,25593487,25593577,25593771,25595291,25595724,25595919,25595977,25596097,25596181,25596836,25598838,25598965,25602873,25602969,25603152,25603508,25609619,25610155,25610734,25611412,25611982,25612590,25613046,25613673,25614234,25614633,25615899,25615990,25616060,25616098,25616135,25616227,25616271,25616302,25616395,25616413,25616476,25616515,25616822,25617263,25621975,25622000,25622031,25622086,25622124,25622159,25622235,25622270,25622309,25622344,25622371,25622386,25622450,25622525,25622557,25622593,25622663,25622707,25622734,25622777,25622844,25622890,25624348,25624486,25651672,25653646,25653831,25654009,25654338,25654415,25654595,25654825,25654861,25655065,25655112,25655185,25655241,25655360,25655511,25655576,25655666,25655676,25655816,25655930,25656017,25656223,25656295,25656766,25664524,25665739,25667462,25670084,25672981,25675603,25679099,25682389,25684882,25686717,25688711,25691356,25693724,25695701,25698245,25700557,25702457,2570410', 'assoc_port': '25585951:25591946,25592808:25596181,25592812:25593487,25592815:25603508,25592820:25593428,25592823:25593359,25592828:25602969,25592831:25595977,25592833:25593771,25592837:25596097,25592840:25593577,25592842:25598965,25592843:25603152,25592845:25593125,25592846:25593251,25592848:25598838,25592849:25595919,25592851:25593052,25592852:25595724,25592853:25602873,25592854:25592935,25592855:25592989,25594536:25596836,25595247:25595291,25609538:25609619,25609986:25610155,25610558:25610734,25611226:25611412,25611836:25611982,25612497:25612590,25612967:25613046,25613553:25613673,25614079:25614234,25614559:25616413,25614563:25616515,25614566:25616302,25614570:25616271,25614574:25614633,25614578:25616227,25614582:25616476,25614584:25616395,25614587:25616135,25614589:25616098,25614592:25615899,25614594:25616060,25614597:25615990,25616550:25616822,25617206:25617263,25621919:25622777,25621921:25622734,25621923:25622557,25621926:25622707,25621928:25622593,25621931:25622844,25621933:25622450,25621936:25622525,25621938:2562289', 'assoc_mat': '25585951:papier:4230:25591946,25592808:papier:4230:25596181,25592812:papier:4230:25593487,25592815:papier:4230:25603508,25592820:papier:4230:25593428,25592823:papier:4230:25593359,25592828:papier:4230:25602969,25592831:papier:4230:25595977,25592833:papier:4230:25593771,25592837:papier:4230:25596097,25592840:papier:4230:25593577,25592842:papier:4230:25598965,25592843:papier:4230:25603152,25592845:papier:4230:25593125,25592846:papier:4230:25593251,25592848:papier:4230:25598838,25592849:papier:4230:25595919,25592851:papier:4230:25593052,25592852:papier:4230:25595724,25592853:papier:4230:25602873,25592854:papier:4230:25592935,25592855:papier:4230:25592989,25594536:papier:4230:25596836,25595247:papier:4230:25595291,25609538:papier:4230:25609619,25609986:papier:4230:25610155,25610558:papier:4230:25610734,25611226:papier:4230:25611412,25611836:papier:4230:25611982,25612497:papier:4230:25612590,25612967:papier:4230:25613046,25613553:papier:4230:25613673,25614079:papier:4230:25614234,25614559:papier:4230:25616413,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002985368302241439, 'nb_photo': 2014, 'list_port_cont': '25592944,25593573,25593761,25595280,25595982,25596186,25598969,25602879,25602970,25603147,25610732,25611411,25611972,25612578,25613044,25613665,25614243,25615982,25616228,25616397,25616421,25616475,25616819,25622147,25622345,25622376,25622888,25651667,25654430,25654867,25655070,25655103,25655186,25655243,25655355,25655520,25655578,25655664,25655684,25655817,25656016,25656214,25656767,25664526,25670073,25679097,25682381,25686719,25688714,25691359,25693730,25695690,25700563,25702462,25704103,25706330,25706451,25706484,25706613,25747734,25748337,25748533,25749360,25749910,25749955,25750258,25750519,25750922,25750983,25751090,25751129,25796235,25796393,25796494,25796583,25796624,25796664,25796710,25796800,25796808,25796919,25797084,25824538,25826128,25826243,25826397,25826440,25826542,25826646,25826836,25826957,25827045,25827114,25827171,25827284,25827345,25828312,25828921,25831599,25852580,25852634,25852712,25852830,25852915,25852947,25852978,25853010,25853079,25853134,25853182,25853240,25853273,25853316,2585334', 'assoc_port': '25592808:25596186,25592828:25602970,25592831:25595982,25592833:25593761,25592840:25593573,25592842:25598969,25592843:25603147,25592853:25602879,25592854:25592944,25595247:25595280,25610558:25610732,25611226:25611411,25611836:25611972,25612497:25612578,25612967:25613044,25613553:25613665,25614079:25614243,25614559:25616421,25614578:25616228,25614582:25616475,25614584:25616397,25614597:25615982,25616550:25616819,25621938:25622888,25621946:25622376,25621948:25622345,25621950:25622147,25651313:25655243,25651314:25655520,25651316:25655684,25651318:25656016,25651321:25656214,25651322:25655664,25651323:25655817,25651326:25655355,25651327:25655578,25651329:25655103,25651330:25655186,25651331:25655070,25651333:25654867,25651346:25651667,25653971:25654430,25656627:25656767,25664468:25664526,25669657:25670073,25678517:25679097,25682025:25682381,25686291:25686719,25688323:25688714,25690709:25691359,25693250:25693730,25695440:25695690,25700142:25700563,25702306:25702462,25703761:25706330,25703765:25706451,25703767:2570648', 'assoc_mat': '25592808:pehd:4230:25596186,25592828:pehd:4230:25602970,25592831:pehd:4230:25595982,25592833:pehd:4230:25593761,25592840:pehd:4230:25593573,25592842:pehd:4230:25598969,25592843:pehd:4230:25603147,25592853:pehd:4230:25602879,25592854:pehd:4230:25592944,25595247:pehd:4230:25595280,25610558:pehd:4230:25610732,25611226:pehd:4230:25611411,25611836:pehd:4230:25611972,25612497:pehd:4230:25612578,25612967:pehd:4230:25613044,25613553:pehd:4230:25613665,25614079:pehd:4230:25614243,25614559:pehd:4230:25616421,25614578:pehd:4230:25616228,25614582:pehd:4230:25616475,25614584:pehd:4230:25616397,25614597:pehd:4230:25615982,25616550:pehd:4230:25616819,25621938:pehd:4230:25622888,25621946:pehd:4230:25622376,25621948:pehd:4230:25622345,25621950:pehd:4230:25622147,25651313:pehd:4230:25655243,25651314:pehd:4230:25655520,25651316:pehd:4230:25655684,25651318:pehd:4230:25656016,25651321:pehd:4230:25656214,25651322:pehd:4230:25655664,25651323:pehd:4230:25655817,25651326:pehd:4230:25655355,25651327:pehd:4230:25655578,25651329:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.010642639683317887, 'nb_photo': 22706, 'list_port_cont': '25591953,25592936,25592976,25593050,25593129,25593255,25593360,25593417,25593477,25593578,25593773,25595290,25595714,25595914,25595975,25596099,25596183,25596829,25598835,25598974,25602878,25602968,25603154,25603515,25609623,25610157,25610739,25611402,25611976,25612591,25613047,25613663,25614233,25614639,25615897,25615987,25616057,25616094,25616129,25616234,25616279,25616316,25616399,25616419,25616472,25616524,25616821,25617259,25621972,25622005,25622025,25622084,25622118,25622156,25622229,25622272,25622296,25622346,25622375,25622401,25622451,25622521,25622553,25622601,25622665,25622704,25622737,25622772,25622855,25622891,25624345,25624487,25651671,25653650,25653836,25654014,25654342,25654418,25654588,25654817,25654866,25655063,25655114,25655183,25655234,25655363,25655518,25655584,25655658,25655677,25655820,25655919,25656022,25656224,25656305,25656759,25664528,25665735,25667479,25670083,25672988,25675608,25679105,25682388,25684894,25686712,25688716,25691366,25693720,25695686,25698247,25700559,25702464,2570409', 'assoc_port': '25585951:25591953,25592808:25596183,25592812:25593477,25592815:25603515,25592820:25593417,25592823:25593360,25592828:25602968,25592831:25595975,25592833:25593773,25592837:25596099,25592840:25593578,25592842:25598974,25592843:25603154,25592845:25593129,25592846:25593255,25592848:25598835,25592849:25595914,25592851:25593050,25592852:25595714,25592853:25602878,25592854:25592936,25592855:25592976,25594536:25596829,25595247:25595290,25609538:25609623,25609986:25610157,25610558:25610739,25611226:25611402,25611836:25611976,25612497:25612591,25612967:25613047,25613553:25613663,25614079:25614233,25614559:25616419,25614563:25616524,25614566:25616316,25614570:25616279,25614574:25614639,25614578:25616234,25614582:25616472,25614584:25616399,25614587:25616129,25614589:25616094,25614592:25615897,25614594:25616057,25614597:25615987,25616550:25616821,25617206:25617259,25621919:25622772,25621921:25622737,25621923:25622553,25621926:25622704,25621928:25622601,25621931:25622855,25621933:25622451,25621936:25622521,25621938:2562289', 'assoc_mat': '25585951:pet_clair:4230:25591953,25592808:pet_clair:4230:25596183,25592812:pet_clair:4230:25593477,25592815:pet_clair:4230:25603515,25592820:pet_clair:4230:25593417,25592823:pet_clair:4230:25593360,25592828:pet_clair:4230:25602968,25592831:pet_clair:4230:25595975,25592833:pet_clair:4230:25593773,25592837:pet_clair:4230:25596099,25592840:pet_clair:4230:25593578,25592842:pet_clair:4230:25598974,25592843:pet_clair:4230:25603154,25592845:pet_clair:4230:25593129,25592846:pet_clair:4230:25593255,25592848:pet_clair:4230:25598835,25592849:pet_clair:4230:25595914,25592851:pet_clair:4230:25593050,25592852:pet_clair:4230:25595714,25592853:pet_clair:4230:25602878,25592854:pet_clair:4230:25592936,25592855:pet_clair:4230:25592976,25594536:pet_clair:4230:25596829,25595247:pet_clair:4230:25595290,25609538:pet_clair:4230:25609623,25609986:pet_clair:4230:25610157,25610558:pet_clair:4230:25610739,25611226:pet_clair:4230:25611402,25611836:pet_clair:4230:25611976,25612497:pet_clair:4230:25612591,25612967:pet_clair:4230:25613047,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0022113715121430903, 'nb_photo': 1016, 'list_port_cont': '25591949,25593258,25593358,25593488,25593574,25593772,25595968,25596094,25596177,25598976,25602871,25602965,25603150,25611407,25611988,25612589,25613040,25613674,25614239,25614638,25615902,25615983,25616055,25616091,25616142,25616820,25622230,25622310,25622339,25622379,25622403,25622666,25654593,25655069,25655111,25655189,25655238,25655365,25655516,25655680,25656020,25656303,25667471,25670082,25675604,25679104,25682390,25684879,25688718,25698241,25700555,25702472,25706342,25706452,25706615,25707041,25746880,25747249,25748348,25748539,25748672,25748949,25749366,25749541,25749661,25749916,25749941,25750256,25750517,25750651,25750929,25750989,25751087,25751136,25796230,25796271,25796395,25796492,25796627,25796659,25796700,25796751,25796791,25796813,25796894,25796930,25797038,25797163,25797251,25797292,25798520,25799712,25824520,25826134,25826244,25826394,25826435,25826549,25826638,25826840,25826960,25827051,25827123,25827163,25827295,25827338,25827436,25827611,25827991,25828069,25828107,25828319,25828446,2582891', 'assoc_port': '25585951:25591949,25592808:25596177,25592812:25593488,25592823:25593358,25592828:25602965,25592831:25595968,25592833:25593772,25592837:25596094,25592840:25593574,25592842:25598976,25592843:25603150,25592846:25593258,25592853:25602871,25611226:25611407,25611836:25611988,25612497:25612589,25612967:25613040,25613553:25613674,25614079:25614239,25614574:25614638,25614587:25616142,25614589:25616091,25614592:25615902,25614594:25616055,25614597:25615983,25616550:25616820,25621940:25622310,25621943:25622403,25621945:25622666,25621946:25622379,25621948:25622339,25621955:25622230,25651309:25654593,25651313:25655238,25651314:25655516,25651316:25655680,25651318:25656020,25651319:25656303,25651326:25655365,25651329:25655111,25651330:25655189,25651331:25655069,25667252:25667471,25669657:25670082,25675223:25675604,25678517:25679104,25682025:25682390,25684589:25684879,25688323:25688718,25697551:25698241,25700142:25700555,25702306:25702472,25703761:25706342,25703765:25706452,25703774:25706615,25706895:25707041,25746127:2574954', 'assoc_mat': '25585951:pet_fonce:4230:25591949,25592808:pet_fonce:4230:25596177,25592812:pet_fonce:4230:25593488,25592823:pet_fonce:4230:25593358,25592828:pet_fonce:4230:25602965,25592831:pet_fonce:4230:25595968,25592833:pet_fonce:4230:25593772,25592837:pet_fonce:4230:25596094,25592840:pet_fonce:4230:25593574,25592842:pet_fonce:4230:25598976,25592843:pet_fonce:4230:25603150,25592846:pet_fonce:4230:25593258,25592853:pet_fonce:4230:25602871,25611226:pet_fonce:4230:25611407,25611836:pet_fonce:4230:25611988,25612497:pet_fonce:4230:25612589,25612967:pet_fonce:4230:25613040,25613553:pet_fonce:4230:25613674,25614079:pet_fonce:4230:25614239,25614574:pet_fonce:4230:25614638,25614587:pet_fonce:4230:25616142,25614589:pet_fonce:4230:25616091,25614592:pet_fonce:4230:25615902,25614594:pet_fonce:4230:25616055,25614597:pet_fonce:4230:25615983,25616550:pet_fonce:4230:25616820,25621940:pet_fonce:4230:25622310,25621943:pet_fonce:4230:25622403,25621945:pet_fonce:4230:25622666,25621946:pet_fonce:4230:25622379,25621948:pet_fonce:4230:25622339,2'}), 'main_stat': {'nb_photos': 2223}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-08', 0.7725448692742881),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_08_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.26%', 20957], 'carton': ['carton', '6.31%', 154883], 'metal': ['metal', '0.14%', 2395], 'papier': ['papier', '15.63%', 417773], 'pehd': ['pehd', '0.3%', 2014], 'pet_clair': ['pet_clair', '1.06%', 22706], 'pet_fonce': ['pet_fonce', '0.22%', 1016]}} 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_08_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.80user 2.42system 0:11.18elapsed 46%CPU (0avgtext+0avgdata 173832maxresident)k 16inputs+280outputs (1major+44554minor)pagefaults 0swaps