python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-12 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (0, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 12 mtr_id : dashboard_places : SCCU_cam6 date : 2025-12 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2025-12%') and created_at like '%2025-12%'))); nb_day : (0, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 12 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 12 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%122025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-12-01 : dt_date_just_month_year : 2025-12-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-12-01" AND ded.date <= "2025-12-31" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (2685011,2689703,2697179,2703914,2710464,2713936,2722805,2716805,2719447,2725915,2735554,2739027,2742684,2743212,2748546,2754952,2761371,2768187,2774119,2777583,2778146,2783301,2788311,2794687,2799959,2805955,2809666,2810372,2815645,2822673,2829224) 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.017166292060819696, 'nb_photo': 20520, 'list_port_cont': '29034558,29034640,29034877,29035008,29035335,29036305,29038664,29040128,29043760,29047013,29050159,29050447,29050566,29088135,29088570,29088699,29089008,29089063,29089087,29092782,29094699,29096528,29096605,29105643,29111507,29113232,29115969,29119509,29119822,29119859,29120012,29120374,29120475,29120519,29120776,29120811,29120979,29121053,29121124,29121355,29121656,29121778,29121817,29121856,29122076,29122165,29122226,29124274,29159498,29160152,29161804,29162178,29162248,29162475,29162537,29162676,29162781,29162863,29162931,29163045,29163268,29163358,29163413,29163549,29163739,29163881,29163995,29164120,29164144,29164556,29167125,29168097,29198192,29201020,29201291,29201357,29201908,29202110,29202163,29202597,29202755,29202936,29203126,29203377,29203613,29203701,29204533,29204965,29205418,29205643,29205886,29206205,29206460,29206665,29207602,29208383,29209537,29209678,29210057,29212247,29212307,29214146,29215895,29219367,29219523,29220744,29222579,29224538,29225491,29226084,29227632,29230972,29232007,2923462', 'assoc_port': '29034543:29034558,29034544:29034640,29034791:29035335,29034853:29034877,29034950:29035008,29036058:29036305,29037833:29038664,29039888:29040128,29041915:29047013,29043378:29043760,29049663:29050566,29049681:29050447,29049699:29050159,29053101:29096605,29053103:29096528,29084807:29089087,29084809:29089063,29084812:29089008,29084815:29088699,29084818:29088570,29084835:29094699,29084850:29088135,29084854:29092782,29084856:29105643,29105656:29111507,29112704:29122226,29112705:29122076,29112706:29122165,29112707:29121856,29112720:29121817,29112721:29121778,29112734:29121656,29112735:29121124,29112736:29121355,29112737:29121053,29112738:29120979,29112741:29120811,29112744:29120776,29112747:29120519,29112750:29120475,29112770:29120374,29112773:29119822,29112777:29120012,29112779:29119509,29112782:29119859,29112786:29113232,29115405:29115969,29118224:29124274,29159192:29159498,29159921:29164120,29159922:29163995,29159923:29163881,29159948:29164144,29159949:29168097,29159950:29163549,29159951:29163739,29159952:2916335', 'assoc_mat': '29034543:autre:4230:29034558,29034544:autre:4230:29034640,29034791:autre:4230:29035335,29034853:autre:4230:29034877,29034950:autre:4230:29035008,29036058:autre:4230:29036305,29037833:autre:4230:29038664,29039888:autre:4230:29040128,29041915:autre:4230:29047013,29043378:autre:4230:29043760,29049663:autre:4230:29050566,29049681:autre:4230:29050447,29049699:autre:4230:29050159,29053101:autre:4230:29096605,29053103:autre:4230:29096528,29084807:autre:4230:29089087,29084809:autre:4230:29089063,29084812:autre:4230:29089008,29084815:autre:4230:29088699,29084818:autre:4230:29088570,29084835:autre:4230:29094699,29084850:autre:4230:29088135,29084854:autre:4230:29092782,29084856:autre:4230:29105643,29105656:autre:4230:29111507,29112704:autre:4230:29122226,29112705:autre:4230:29122076,29112706:autre:4230:29122165,29112707:autre:4230:29121856,29112720:autre:4230:29121817,29112721:autre:4230:29121778,29112734:autre:4230:29121656,29112735:autre:4230:29121124,29112736:autre:4230:29121355,29112737:autre:4230:29121053,29112738:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04849495263304614, 'nb_photo': 91606, 'list_port_cont': '29034559,29034633,29034873,29035000,29035325,29036317,29038662,29040135,29043752,29047011,29050161,29050448,29050555,29088149,29088559,29088700,29089019,29089058,29089095,29092778,29094701,29096536,29096612,29105647,29111519,29113234,29115971,29119512,29119814,29119848,29120016,29120384,29120487,29120524,29120775,29120803,29120976,29121044,29121122,29121370,29121666,29121781,29121828,29121868,29122077,29122160,29122231,29124278,29159511,29160155,29161818,29162174,29162257,29162484,29162542,29162678,29162779,29162857,29162927,29163051,29163265,29163369,29163417,29163548,29163749,29163890,29164003,29164115,29164160,29164571,29167113,29168094,29198196,29201029,29201295,29201353,29201910,29202106,29202166,29202612,29202760,29202940,29203120,29203382,29203614,29203706,29204528,29204975,29205437,29205652,29205887,29206206,29206449,29206657,29207610,29208382,29209536,29209682,29210055,29212255,29212317,29214158,29215897,29219366,29219518,29220757,29222589,29224550,29225492,29226096,29227641,29230978,29232009,2923461', 'assoc_port': '29034543:29034559,29034544:29034633,29034791:29035325,29034853:29034873,29034950:29035000,29036058:29036317,29037833:29038662,29039888:29040135,29041915:29047011,29043378:29043752,29049663:29050555,29049681:29050448,29049699:29050161,29053101:29096612,29053103:29096536,29084807:29089095,29084809:29089058,29084812:29089019,29084815:29088700,29084818:29088559,29084835:29094701,29084850:29088149,29084854:29092778,29084856:29105647,29105656:29111519,29112704:29122231,29112705:29122077,29112706:29122160,29112707:29121868,29112720:29121828,29112721:29121781,29112734:29121666,29112735:29121122,29112736:29121370,29112737:29121044,29112738:29120976,29112741:29120803,29112744:29120775,29112747:29120524,29112750:29120487,29112770:29120384,29112773:29119814,29112777:29120016,29112779:29119512,29112782:29119848,29112786:29113234,29115405:29115971,29118224:29124278,29159192:29159511,29159921:29164115,29159922:29164003,29159923:29163890,29159948:29164160,29159949:29168094,29159950:29163548,29159951:29163749,29159952:2916336', 'assoc_mat': '29034543:carton:4230:29034559,29034544:carton:4230:29034633,29034791:carton:4230:29035325,29034853:carton:4230:29034873,29034950:carton:4230:29035000,29036058:carton:4230:29036317,29037833:carton:4230:29038662,29039888:carton:4230:29040135,29041915:carton:4230:29047011,29043378:carton:4230:29043752,29049663:carton:4230:29050555,29049681:carton:4230:29050448,29049699:carton:4230:29050161,29053101:carton:4230:29096612,29053103:carton:4230:29096536,29084807:carton:4230:29089095,29084809:carton:4230:29089058,29084812:carton:4230:29089019,29084815:carton:4230:29088700,29084818:carton:4230:29088559,29084835:carton:4230:29094701,29084850:carton:4230:29088149,29084854:carton:4230:29092778,29084856:carton:4230:29105647,29105656:carton:4230:29111519,29112704:carton:4230:29122231,29112705:carton:4230:29122077,29112706:carton:4230:29122160,29112707:carton:4230:29121868,29112720:carton:4230:29121828,29112721:carton:4230:29121781,29112734:carton:4230:29121666,29112735:carton:4230:29121122,29112736:carton:4230:29121370,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013129743914947476, 'nb_photo': 1796, 'list_port_cont': '29034632,29036304,29038660,29040124,29043751,29047009,29050163,29050443,29088144,29088553,29088711,29089068,29089102,29092770,29094687,29096530,29096597,29105644,29111514,29113237,29115963,29119495,29119854,29120007,29120377,29120476,29120528,29120761,29120814,29120972,29121055,29121366,29121667,29121782,29121822,29121866,29122159,29122229,29159505,29160147,29161802,29162172,29162259,29162473,29162547,29162680,29162795,29162860,29162935,29163040,29163267,29163360,29163414,29163550,29163753,29163885,29164010,29164119,29164554,29167120,29168096,29198191,29201019,29201285,29201355,29201893,29202115,29202154,29202598,29202751,29202939,29203125,29203371,29203607,29203705,29204537,29204976,29205424,29205880,29206200,29206461,29206661,29207618,29208379,29209546,29209677,29210064,29212239,29212306,29214151,29215896,29219380,29219510,29220758,29222577,29224541,29225502,29226089,29227636,29230971,29232012,29234620,29236132,29237232,29237815,29240075,29240848,29240892,29241227,29241917,29242020,29242246,29242434,2924317', 'assoc_port': '29034544:29034632,29036058:29036304,29037833:29038660,29039888:29040124,29041915:29047009,29043378:29043751,29049681:29050443,29049699:29050163,29053101:29096597,29053103:29096530,29084807:29089102,29084809:29089068,29084815:29088711,29084818:29088553,29084835:29094687,29084850:29088144,29084854:29092770,29084856:29105644,29105656:29111514,29112704:29122229,29112706:29122159,29112707:29121866,29112720:29121822,29112721:29121782,29112734:29121667,29112736:29121366,29112737:29121055,29112738:29120972,29112741:29120814,29112744:29120761,29112747:29120528,29112750:29120476,29112770:29120377,29112777:29120007,29112779:29119495,29112782:29119854,29112786:29113237,29115405:29115963,29159192:29159505,29159921:29164119,29159922:29164010,29159923:29163885,29159949:29168096,29159950:29163550,29159951:29163753,29159952:29163360,29159953:29167120,29159954:29163414,29159955:29163267,29159956:29162795,29159959:29162680,29159962:29163040,29159965:29162860,29159969:29162935,29159972:29162547,29159975:29162473,29159979:2916217', 'assoc_mat': '29034544:metal:4230:29034632,29036058:metal:4230:29036304,29037833:metal:4230:29038660,29039888:metal:4230:29040124,29041915:metal:4230:29047009,29043378:metal:4230:29043751,29049681:metal:4230:29050443,29049699:metal:4230:29050163,29053101:metal:4230:29096597,29053103:metal:4230:29096530,29084807:metal:4230:29089102,29084809:metal:4230:29089068,29084815:metal:4230:29088711,29084818:metal:4230:29088553,29084835:metal:4230:29094687,29084850:metal:4230:29088144,29084854:metal:4230:29092770,29084856:metal:4230:29105644,29105656:metal:4230:29111514,29112704:metal:4230:29122229,29112706:metal:4230:29122159,29112707:metal:4230:29121866,29112720:metal:4230:29121822,29112721:metal:4230:29121782,29112734:metal:4230:29121667,29112736:metal:4230:29121366,29112737:metal:4230:29121055,29112738:metal:4230:29120972,29112741:metal:4230:29120814,29112744:metal:4230:29120761,29112747:metal:4230:29120528,29112750:metal:4230:29120476,29112770:metal:4230:29120377,29112777:metal:4230:29120007,29112779:metal:4230:29119495,29112782:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19601479110557848, 'nb_photo': 429129, 'list_port_cont': '29034570,29034639,29034874,29035002,29035336,29036314,29038663,29040141,29043758,29047017,29050157,29050449,29050561,29088146,29088562,29088698,29089014,29089060,29089104,29092783,29094698,29096544,29096608,29105654,29111517,29113238,29115976,29119503,29119812,29119856,29120019,29120386,29120485,29120523,29120773,29120815,29120971,29121045,29121125,29121365,29121662,29121791,29121825,29121859,29122079,29122167,29122227,29124283,29159510,29160158,29161813,29162182,29162252,29162474,29162548,29162691,29162794,29162865,29162929,29163042,29163273,29163372,29163407,29163539,29163752,29163878,29164001,29164116,29164176,29164572,29167124,29168099,29198205,29201025,29201292,29201358,29201895,29202111,29202157,29202607,29202765,29202928,29203129,29203375,29203602,29203712,29204530,29204974,29205426,29205646,29205879,29206199,29206458,29206666,29207617,29208378,29209538,29209680,29210066,29212249,29212319,29214147,29215890,29219378,29219517,29220756,29222575,29224549,29225501,29226094,29227643,29230967,29231997,2923462', 'assoc_port': '29034543:29034570,29034544:29034639,29034791:29035336,29034853:29034874,29034950:29035002,29036058:29036314,29037833:29038663,29039888:29040141,29041915:29047017,29043378:29043758,29049663:29050561,29049681:29050449,29049699:29050157,29053101:29096608,29053103:29096544,29084807:29089104,29084809:29089060,29084812:29089014,29084815:29088698,29084818:29088562,29084835:29094698,29084850:29088146,29084854:29092783,29084856:29105654,29105656:29111517,29112704:29122227,29112705:29122079,29112706:29122167,29112707:29121859,29112720:29121825,29112721:29121791,29112734:29121662,29112735:29121125,29112736:29121365,29112737:29121045,29112738:29120971,29112741:29120815,29112744:29120773,29112747:29120523,29112750:29120485,29112770:29120386,29112773:29119812,29112777:29120019,29112779:29119503,29112782:29119856,29112786:29113238,29115405:29115976,29118224:29124283,29159192:29159510,29159921:29164116,29159922:29164001,29159923:29163878,29159948:29164176,29159949:29168099,29159950:29163539,29159951:29163752,29159952:2916337', 'assoc_mat': '29034543:papier:4230:29034570,29034544:papier:4230:29034639,29034791:papier:4230:29035336,29034853:papier:4230:29034874,29034950:papier:4230:29035002,29036058:papier:4230:29036314,29037833:papier:4230:29038663,29039888:papier:4230:29040141,29041915:papier:4230:29047017,29043378:papier:4230:29043758,29049663:papier:4230:29050561,29049681:papier:4230:29050449,29049699:papier:4230:29050157,29053101:papier:4230:29096608,29053103:papier:4230:29096544,29084807:papier:4230:29089104,29084809:papier:4230:29089060,29084812:papier:4230:29089014,29084815:papier:4230:29088698,29084818:papier:4230:29088562,29084835:papier:4230:29094698,29084850:papier:4230:29088146,29084854:papier:4230:29092783,29084856:papier:4230:29105654,29105656:papier:4230:29111517,29112704:papier:4230:29122227,29112705:papier:4230:29122079,29112706:papier:4230:29122167,29112707:papier:4230:29121859,29112720:papier:4230:29121825,29112721:papier:4230:29121791,29112734:papier:4230:29121662,29112735:papier:4230:29121125,29112736:papier:4230:29121365,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0037781965532824196, 'nb_photo': 2462, 'list_port_cont': '29034635,29034861,29040133,29043754,29047024,29050156,29050446,29050570,29088566,29088710,29089013,29089103,29092780,29094686,29096542,29096604,29105650,29111520,29113233,29115973,29119511,29119818,29119849,29120006,29120380,29120479,29120518,29120774,29120808,29120974,29121049,29121117,29121364,29121665,29121794,29121830,29122073,29122156,29122228,29124280,29159513,29160160,29161817,29162177,29162261,29162482,29162551,29162689,29162777,29162870,29162933,29163044,29163274,29163370,29163409,29163538,29163744,29163886,29164009,29164124,29164569,29167121,29168102,29198207,29201033,29201288,29201349,29201903,29202112,29202167,29202609,29202759,29202932,29203114,29203385,29203609,29203717,29204540,29204966,29205430,29205884,29206211,29206455,29206660,29207613,29208386,29209547,29209686,29210058,29212322,29215893,29219374,29219522,29220761,29222587,29224554,29225499,29226087,29227639,29230980,29232001,29234626,29236134,29237230,29237809,29240077,29240858,29241919,29242027,29242250,29242436,29243171,29244998,2924543', 'assoc_port': '29034544:29034635,29034853:29034861,29039888:29040133,29041915:29047024,29043378:29043754,29049663:29050570,29049681:29050446,29049699:29050156,29053101:29096604,29053103:29096542,29084807:29089103,29084812:29089013,29084815:29088710,29084818:29088566,29084835:29094686,29084854:29092780,29084856:29105650,29105656:29111520,29112704:29122228,29112705:29122073,29112706:29122156,29112720:29121830,29112721:29121794,29112734:29121665,29112735:29121117,29112736:29121364,29112737:29121049,29112738:29120974,29112741:29120808,29112744:29120774,29112747:29120518,29112750:29120479,29112770:29120380,29112773:29119818,29112777:29120006,29112779:29119511,29112782:29119849,29112786:29113233,29115405:29115973,29118224:29124280,29159192:29159513,29159921:29164124,29159922:29164009,29159923:29163886,29159949:29168102,29159950:29163538,29159951:29163744,29159952:29163370,29159953:29167121,29159954:29163409,29159955:29163274,29159956:29162777,29159959:29162689,29159962:29163044,29159965:29162870,29159969:29162933,29159972:2916255', 'assoc_mat': '29034544:pehd:4230:29034635,29034853:pehd:4230:29034861,29039888:pehd:4230:29040133,29041915:pehd:4230:29047024,29043378:pehd:4230:29043754,29049663:pehd:4230:29050570,29049681:pehd:4230:29050446,29049699:pehd:4230:29050156,29053101:pehd:4230:29096604,29053103:pehd:4230:29096542,29084807:pehd:4230:29089103,29084812:pehd:4230:29089013,29084815:pehd:4230:29088710,29084818:pehd:4230:29088566,29084835:pehd:4230:29094686,29084854:pehd:4230:29092780,29084856:pehd:4230:29105650,29105656:pehd:4230:29111520,29112704:pehd:4230:29122228,29112705:pehd:4230:29122073,29112706:pehd:4230:29122156,29112720:pehd:4230:29121830,29112721:pehd:4230:29121794,29112734:pehd:4230:29121665,29112735:pehd:4230:29121117,29112736:pehd:4230:29121364,29112737:pehd:4230:29121049,29112738:pehd:4230:29120974,29112741:pehd:4230:29120808,29112744:pehd:4230:29120774,29112747:pehd:4230:29120518,29112750:pehd:4230:29120479,29112770:pehd:4230:29120380,29112773:pehd:4230:29119818,29112777:pehd:4230:29120006,29112779:pehd:4230:29119511,29112782:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011427899946044009, 'nb_photo': 25002, 'list_port_cont': '29034568,29034638,29034864,29034997,29035328,29036303,29038656,29040139,29043761,29047023,29050153,29050435,29050559,29088139,29088567,29088708,29089018,29089067,29089097,29092785,29094697,29096541,29096610,29105641,29111516,29113228,29115974,29119502,29119823,29119855,29120020,29120383,29120486,29120521,29120778,29120813,29120973,29121056,29121121,29121354,29121668,29121795,29121824,29121862,29122081,29122162,29122233,29124282,29159509,29160148,29161819,29162179,29162260,29162479,29162544,29162684,29162775,29162869,29162934,29163049,29163275,29163373,29163423,29163551,29163755,29163883,29164006,29164129,29164154,29164567,29167119,29168093,29198202,29201028,29201299,29201354,29201899,29202108,29202169,29202610,29202766,29202934,29203128,29203381,29203611,29203716,29204536,29204972,29205431,29205642,29205890,29206212,29206453,29206667,29207619,29208381,29209544,29209675,29210056,29212253,29212321,29214154,29215888,29219371,29219524,29220752,29222583,29224552,29225505,29226086,29227628,29230981,29232011,2923463', 'assoc_port': '29034543:29034568,29034544:29034638,29034791:29035328,29034853:29034864,29034950:29034997,29036058:29036303,29037833:29038656,29039888:29040139,29041915:29047023,29043378:29043761,29049663:29050559,29049681:29050435,29049699:29050153,29053101:29096610,29053103:29096541,29084807:29089097,29084809:29089067,29084812:29089018,29084815:29088708,29084818:29088567,29084835:29094697,29084850:29088139,29084854:29092785,29084856:29105641,29105656:29111516,29112704:29122233,29112705:29122081,29112706:29122162,29112707:29121862,29112720:29121824,29112721:29121795,29112734:29121668,29112735:29121121,29112736:29121354,29112737:29121056,29112738:29120973,29112741:29120813,29112744:29120778,29112747:29120521,29112750:29120486,29112770:29120383,29112773:29119823,29112777:29120020,29112779:29119502,29112782:29119855,29112786:29113228,29115405:29115974,29118224:29124282,29159192:29159509,29159921:29164129,29159922:29164006,29159923:29163883,29159948:29164154,29159949:29168093,29159950:29163551,29159951:29163755,29159952:2916337', 'assoc_mat': '29034543:pet_clair:4230:29034568,29034544:pet_clair:4230:29034638,29034791:pet_clair:4230:29035328,29034853:pet_clair:4230:29034864,29034950:pet_clair:4230:29034997,29036058:pet_clair:4230:29036303,29037833:pet_clair:4230:29038656,29039888:pet_clair:4230:29040139,29041915:pet_clair:4230:29047023,29043378:pet_clair:4230:29043761,29049663:pet_clair:4230:29050559,29049681:pet_clair:4230:29050435,29049699:pet_clair:4230:29050153,29053101:pet_clair:4230:29096610,29053103:pet_clair:4230:29096541,29084807:pet_clair:4230:29089097,29084809:pet_clair:4230:29089067,29084812:pet_clair:4230:29089018,29084815:pet_clair:4230:29088708,29084818:pet_clair:4230:29088567,29084835:pet_clair:4230:29094697,29084850:pet_clair:4230:29088139,29084854:pet_clair:4230:29092785,29084856:pet_clair:4230:29105641,29105656:pet_clair:4230:29111516,29112704:pet_clair:4230:29122233,29112705:pet_clair:4230:29122081,29112706:pet_clair:4230:29122162,29112707:pet_clair:4230:29121862,29112720:pet_clair:4230:29121824,29112721:pet_clair:4230:29121795,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028309843607396963, 'nb_photo': 1109, 'list_port_cont': '29034644,29040140,29043747,29050148,29050441,29050569,29088557,29089100,29096539,29096606,29111523,29115967,29119510,29119821,29119850,29120017,29120385,29120480,29120527,29120772,29120809,29120978,29121054,29121123,29121368,29121660,29121792,29121827,29122071,29124286,29159503,29160156,29161805,29162180,29162483,29162549,29162866,29162923,29163052,29163365,29163748,29164128,29164168,29164562,29167123,29168104,29198208,29201030,29202104,29202160,29202764,29202931,29203124,29203374,29203612,29203715,29204529,29204967,29205429,29205650,29206201,29206450,29206664,29207616,29208387,29209543,29210059,29212256,29214156,29219377,29219521,29220759,29222580,29224545,29225493,29226095,29227642,29230977,29232003,29234631,29236127,29237234,29237803,29240850,29240900,29241228,29241920,29242031,29242243,29242439,29243166,29245442,29245900,29246191,29246357,29246670,29246959,29247027,29247432,29247911,29248046,29248882,29249092,29266727,29266869,29266977,29267420,29268077,29268305,29268358,29268508,29268903,29269064,2928177', 'assoc_port': '29034544:29034644,29039888:29040140,29043378:29043747,29049663:29050569,29049681:29050441,29049699:29050148,29053101:29096606,29053103:29096539,29084807:29089100,29084818:29088557,29105656:29111523,29112705:29122071,29112720:29121827,29112721:29121792,29112734:29121660,29112735:29121123,29112736:29121368,29112737:29121054,29112738:29120978,29112741:29120809,29112744:29120772,29112747:29120527,29112750:29120480,29112770:29120385,29112773:29119821,29112777:29120017,29112779:29119510,29112782:29119850,29115405:29115967,29118224:29124286,29159192:29159503,29159921:29164128,29159948:29164168,29159949:29168104,29159951:29163748,29159952:29163365,29159953:29167123,29159962:29163052,29159965:29162866,29159969:29162923,29159972:29162549,29159975:29162483,29159979:29162180,29159982:29161805,29159985:29160156,29163964:29164562,29197790:29201030,29197804:29207616,29197818:29202104,29197819:29202160,29197821:29202764,29197822:29202931,29197823:29203124,29197824:29203374,29197825:29203715,29197828:29208387,29197831:2920452', 'assoc_mat': '29034544:pet_fonce:4230:29034644,29039888:pet_fonce:4230:29040140,29043378:pet_fonce:4230:29043747,29049663:pet_fonce:4230:29050569,29049681:pet_fonce:4230:29050441,29049699:pet_fonce:4230:29050148,29053101:pet_fonce:4230:29096606,29053103:pet_fonce:4230:29096539,29084807:pet_fonce:4230:29089100,29084818:pet_fonce:4230:29088557,29105656:pet_fonce:4230:29111523,29112705:pet_fonce:4230:29122071,29112720:pet_fonce:4230:29121827,29112721:pet_fonce:4230:29121792,29112734:pet_fonce:4230:29121660,29112735:pet_fonce:4230:29121123,29112736:pet_fonce:4230:29121368,29112737:pet_fonce:4230:29121054,29112738:pet_fonce:4230:29120978,29112741:pet_fonce:4230:29120809,29112744:pet_fonce:4230:29120772,29112747:pet_fonce:4230:29120527,29112750:pet_fonce:4230:29120480,29112770:pet_fonce:4230:29120385,29112773:pet_fonce:4230:29119821,29112777:pet_fonce:4230:29120017,29112779:pet_fonce:4230:29119510,29112782:pet_fonce:4230:29119850,29115405:pet_fonce:4230:29115967,29118224:pet_fonce:4230:29124286,29159192:pet_fonce:4230:29159503,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(2685011,2689703,2697179,2703914,2710464,2713936,2722805,2716805,2719447,2725915,2735554,2739027,2742684,2743212,2748546,2754952,2761371,2768187,2774119,2777583,2778146,2783301,2788311,2794687,2799959,2805955,2809666,2810372,2815645,2822673,2829224)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-12-01' and date <= '2025-12-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1878,),), 'unwanted_material_monthly_percentage': ((0.7458038867249532,),), 'material_repartition': (('incineration', 1878),), 'material_dict': {'incineration': 1878}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 12, 1), 0.782559127879385, 1), (datetime.date(2025, 12, 2), 0.7607520907333681, 4), (datetime.date(2025, 12, 3), 0.7305432847728657, 4), (datetime.date(2025, 12, 4), 0.7001190730723347, 4), (datetime.date(2025, 12, 5), 0.6793942935044911, 3), (datetime.date(2025, 12, 6), 0.7099478516370435, 3), (datetime.date(2025, 12, 7), 0.8003211873614124, 2), (datetime.date(2025, 12, 8), 0.7857616485441914, 2), (datetime.date(2025, 12, 9), 0.7199457506440788, 1), (datetime.date(2025, 12, 10), 0.7003958306796186, 3), (datetime.date(2025, 12, 11), 0.7052070172627848, 4), (datetime.date(2025, 12, 12), 0.7031190004805288, 4), (datetime.date(2025, 12, 13), 0.7165559988181703, 4), (datetime.date(2025, 12, 14), 0.7972605377181596, 2), (datetime.date(2025, 12, 15), 0.7855811968380854, 3), (datetime.date(2025, 12, 16), 0.7325160071988582, 3), (datetime.date(2025, 12, 17), 0.7143676105549198, 4), (datetime.date(2025, 12, 18), 0.7019727109395051, 2), (datetime.date(2025, 12, 19), 0.6850009577178664, 2), (datetime.date(2025, 12, 20), 0.7233248780084995, 1), (datetime.date(2025, 12, 21), 0.812572055287931, 3), (datetime.date(2025, 12, 22), 0.7956852560395747, 2), (datetime.date(2025, 12, 23), 0.7444263902347409, 2), (datetime.date(2025, 12, 24), 0.662238382761879, 3), (datetime.date(2025, 12, 25), 0.7719450048002514, 3), (datetime.date(2025, 12, 26), 0.7952135353825008, 3), (datetime.date(2025, 12, 27), 0.8068679279304548, 3), (datetime.date(2025, 12, 28), 0.8452341224083783, 2), (datetime.date(2025, 12, 29), 0.8450183398258632, 3), (datetime.date(2025, 12, 30), 0.7556402286669106, 2), (datetime.date(2025, 12, 31), 0.6958647775556747, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 12, 1), 0.782559127879385, 1), (datetime.date(2025, 12, 2), 0.7607520907333681, 4), (datetime.date(2025, 12, 3), 0.7305432847728657, 4), (datetime.date(2025, 12, 4), 0.7001190730723347, 4), (datetime.date(2025, 12, 5), 0.6793942935044911, 3), (datetime.date(2025, 12, 6), 0.7099478516370435, 3), (datetime.date(2025, 12, 7), 0.8003211873614124, 2), (datetime.date(2025, 12, 8), 0.7857616485441914, 2), (datetime.date(2025, 12, 9), 0.7199457506440788, 1), (datetime.date(2025, 12, 10), 0.7003958306796186, 3), (datetime.date(2025, 12, 11), 0.7052070172627848, 4), (datetime.date(2025, 12, 12), 0.7031190004805288, 4), (datetime.date(2025, 12, 13), 0.7165559988181703, 4), (datetime.date(2025, 12, 14), 0.7972605377181596, 2), (datetime.date(2025, 12, 15), 0.7855811968380854, 3), (datetime.date(2025, 12, 16), 0.7325160071988582, 3), (datetime.date(2025, 12, 17), 0.7143676105549198, 4), (datetime.date(2025, 12, 18), 0.7019727109395051, 2), (datetime.date(2025, 12, 19), 0.6850009577178664, 2), (datetime.date(2025, 12, 20), 0.7233248780084995, 1), (datetime.date(2025, 12, 21), 0.812572055287931, 3), (datetime.date(2025, 12, 22), 0.7956852560395747, 2), (datetime.date(2025, 12, 23), 0.7444263902347409, 2), (datetime.date(2025, 12, 24), 0.662238382761879, 3), (datetime.date(2025, 12, 25), 0.7719450048002514, 3), (datetime.date(2025, 12, 26), 0.7952135353825008, 3), (datetime.date(2025, 12, 27), 0.8068679279304548, 3), (datetime.date(2025, 12, 28), 0.8452341224083783, 2), (datetime.date(2025, 12, 29), 0.8450183398258632, 3), (datetime.date(2025, 12, 30), 0.7556402286669106, 2), (datetime.date(2025, 12, 31), 0.6958647775556747, 2))}, 'quality_array': [['-7.805783329419552', '01122025'], ['-7.985406040609226', '02122025'], ['-8.276789589619664', '03122025'], ['-8.251438541846154', '04122025'], ['-8.507259207630412', '05122025'], ['-8.390081864331483', '06122025'], ['-7.750434480256057', '07122025'], ['-7.595853509100009', '08122025'], ['-8.182876707848592', '09122025'], ['-8.111270424939885', '10122025'], ['-8.328604231938124', '11122025'], ['-8.32653002941889', '12122025'], ['-8.340504373652804', '13122025'], ['-8.028589448260991', '14122025'], ['-7.296941517806946', '15122025'], ['-7.847199661297485', '16122025'], ['-8.159191285946976', '17122025'], ['-8.20000801405989', '18122025'], ['-8.23136539861369', '19122025'], ['-8.204519450345279', '20122025'], ['-7.813935862577304', '21122025'], ['-6.537733552912789', '22122025'], ['-7.563697723333075', '23122025'], ['-8.473440283935185', '24122025'], ['-8.67087993411329', '25122025'], ['-7.873780070345554', '26122025'], ['-7.406193558887963', '27122025'], ['-7.629740979233771', '28122025'], ['-6.713891405734814', '29122025'], ['-7.747092100088277', '30122025'], ['-8.177967888731127', '31122025']], 'number_of_batch': ((699,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017166292060819696, 'nb_photo': 20520, 'list_port_cont': '29034558,29034640,29034877,29035008,29035335,29036305,29038664,29040128,29043760,29047013,29050159,29050447,29050566,29088135,29088570,29088699,29089008,29089063,29089087,29092782,29094699,29096528,29096605,29105643,29111507,29113232,29115969,29119509,29119822,29119859,29120012,29120374,29120475,29120519,29120776,29120811,29120979,29121053,29121124,29121355,29121656,29121778,29121817,29121856,29122076,29122165,29122226,29124274,29159498,29160152,29161804,29162178,29162248,29162475,29162537,29162676,29162781,29162863,29162931,29163045,29163268,29163358,29163413,29163549,29163739,29163881,29163995,29164120,29164144,29164556,29167125,29168097,29198192,29201020,29201291,29201357,29201908,29202110,29202163,29202597,29202755,29202936,29203126,29203377,29203613,29203701,29204533,29204965,29205418,29205643,29205886,29206205,29206460,29206665,29207602,29208383,29209537,29209678,29210057,29212247,29212307,29214146,29215895,29219367,29219523,29220744,29222579,29224538,29225491,29226084,29227632,29230972,29232007,2923462', 'assoc_port': '29034543:29034558,29034544:29034640,29034791:29035335,29034853:29034877,29034950:29035008,29036058:29036305,29037833:29038664,29039888:29040128,29041915:29047013,29043378:29043760,29049663:29050566,29049681:29050447,29049699:29050159,29053101:29096605,29053103:29096528,29084807:29089087,29084809:29089063,29084812:29089008,29084815:29088699,29084818:29088570,29084835:29094699,29084850:29088135,29084854:29092782,29084856:29105643,29105656:29111507,29112704:29122226,29112705:29122076,29112706:29122165,29112707:29121856,29112720:29121817,29112721:29121778,29112734:29121656,29112735:29121124,29112736:29121355,29112737:29121053,29112738:29120979,29112741:29120811,29112744:29120776,29112747:29120519,29112750:29120475,29112770:29120374,29112773:29119822,29112777:29120012,29112779:29119509,29112782:29119859,29112786:29113232,29115405:29115969,29118224:29124274,29159192:29159498,29159921:29164120,29159922:29163995,29159923:29163881,29159948:29164144,29159949:29168097,29159950:29163549,29159951:29163739,29159952:2916335', 'assoc_mat': '29034543:autre:4230:29034558,29034544:autre:4230:29034640,29034791:autre:4230:29035335,29034853:autre:4230:29034877,29034950:autre:4230:29035008,29036058:autre:4230:29036305,29037833:autre:4230:29038664,29039888:autre:4230:29040128,29041915:autre:4230:29047013,29043378:autre:4230:29043760,29049663:autre:4230:29050566,29049681:autre:4230:29050447,29049699:autre:4230:29050159,29053101:autre:4230:29096605,29053103:autre:4230:29096528,29084807:autre:4230:29089087,29084809:autre:4230:29089063,29084812:autre:4230:29089008,29084815:autre:4230:29088699,29084818:autre:4230:29088570,29084835:autre:4230:29094699,29084850:autre:4230:29088135,29084854:autre:4230:29092782,29084856:autre:4230:29105643,29105656:autre:4230:29111507,29112704:autre:4230:29122226,29112705:autre:4230:29122076,29112706:autre:4230:29122165,29112707:autre:4230:29121856,29112720:autre:4230:29121817,29112721:autre:4230:29121778,29112734:autre:4230:29121656,29112735:autre:4230:29121124,29112736:autre:4230:29121355,29112737:autre:4230:29121053,29112738:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04849495263304614, 'nb_photo': 91606, 'list_port_cont': '29034559,29034633,29034873,29035000,29035325,29036317,29038662,29040135,29043752,29047011,29050161,29050448,29050555,29088149,29088559,29088700,29089019,29089058,29089095,29092778,29094701,29096536,29096612,29105647,29111519,29113234,29115971,29119512,29119814,29119848,29120016,29120384,29120487,29120524,29120775,29120803,29120976,29121044,29121122,29121370,29121666,29121781,29121828,29121868,29122077,29122160,29122231,29124278,29159511,29160155,29161818,29162174,29162257,29162484,29162542,29162678,29162779,29162857,29162927,29163051,29163265,29163369,29163417,29163548,29163749,29163890,29164003,29164115,29164160,29164571,29167113,29168094,29198196,29201029,29201295,29201353,29201910,29202106,29202166,29202612,29202760,29202940,29203120,29203382,29203614,29203706,29204528,29204975,29205437,29205652,29205887,29206206,29206449,29206657,29207610,29208382,29209536,29209682,29210055,29212255,29212317,29214158,29215897,29219366,29219518,29220757,29222589,29224550,29225492,29226096,29227641,29230978,29232009,2923461', 'assoc_port': '29034543:29034559,29034544:29034633,29034791:29035325,29034853:29034873,29034950:29035000,29036058:29036317,29037833:29038662,29039888:29040135,29041915:29047011,29043378:29043752,29049663:29050555,29049681:29050448,29049699:29050161,29053101:29096612,29053103:29096536,29084807:29089095,29084809:29089058,29084812:29089019,29084815:29088700,29084818:29088559,29084835:29094701,29084850:29088149,29084854:29092778,29084856:29105647,29105656:29111519,29112704:29122231,29112705:29122077,29112706:29122160,29112707:29121868,29112720:29121828,29112721:29121781,29112734:29121666,29112735:29121122,29112736:29121370,29112737:29121044,29112738:29120976,29112741:29120803,29112744:29120775,29112747:29120524,29112750:29120487,29112770:29120384,29112773:29119814,29112777:29120016,29112779:29119512,29112782:29119848,29112786:29113234,29115405:29115971,29118224:29124278,29159192:29159511,29159921:29164115,29159922:29164003,29159923:29163890,29159948:29164160,29159949:29168094,29159950:29163548,29159951:29163749,29159952:2916336', 'assoc_mat': '29034543:carton:4230:29034559,29034544:carton:4230:29034633,29034791:carton:4230:29035325,29034853:carton:4230:29034873,29034950:carton:4230:29035000,29036058:carton:4230:29036317,29037833:carton:4230:29038662,29039888:carton:4230:29040135,29041915:carton:4230:29047011,29043378:carton:4230:29043752,29049663:carton:4230:29050555,29049681:carton:4230:29050448,29049699:carton:4230:29050161,29053101:carton:4230:29096612,29053103:carton:4230:29096536,29084807:carton:4230:29089095,29084809:carton:4230:29089058,29084812:carton:4230:29089019,29084815:carton:4230:29088700,29084818:carton:4230:29088559,29084835:carton:4230:29094701,29084850:carton:4230:29088149,29084854:carton:4230:29092778,29084856:carton:4230:29105647,29105656:carton:4230:29111519,29112704:carton:4230:29122231,29112705:carton:4230:29122077,29112706:carton:4230:29122160,29112707:carton:4230:29121868,29112720:carton:4230:29121828,29112721:carton:4230:29121781,29112734:carton:4230:29121666,29112735:carton:4230:29121122,29112736:carton:4230:29121370,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013129743914947476, 'nb_photo': 1796, 'list_port_cont': '29034632,29036304,29038660,29040124,29043751,29047009,29050163,29050443,29088144,29088553,29088711,29089068,29089102,29092770,29094687,29096530,29096597,29105644,29111514,29113237,29115963,29119495,29119854,29120007,29120377,29120476,29120528,29120761,29120814,29120972,29121055,29121366,29121667,29121782,29121822,29121866,29122159,29122229,29159505,29160147,29161802,29162172,29162259,29162473,29162547,29162680,29162795,29162860,29162935,29163040,29163267,29163360,29163414,29163550,29163753,29163885,29164010,29164119,29164554,29167120,29168096,29198191,29201019,29201285,29201355,29201893,29202115,29202154,29202598,29202751,29202939,29203125,29203371,29203607,29203705,29204537,29204976,29205424,29205880,29206200,29206461,29206661,29207618,29208379,29209546,29209677,29210064,29212239,29212306,29214151,29215896,29219380,29219510,29220758,29222577,29224541,29225502,29226089,29227636,29230971,29232012,29234620,29236132,29237232,29237815,29240075,29240848,29240892,29241227,29241917,29242020,29242246,29242434,2924317', 'assoc_port': '29034544:29034632,29036058:29036304,29037833:29038660,29039888:29040124,29041915:29047009,29043378:29043751,29049681:29050443,29049699:29050163,29053101:29096597,29053103:29096530,29084807:29089102,29084809:29089068,29084815:29088711,29084818:29088553,29084835:29094687,29084850:29088144,29084854:29092770,29084856:29105644,29105656:29111514,29112704:29122229,29112706:29122159,29112707:29121866,29112720:29121822,29112721:29121782,29112734:29121667,29112736:29121366,29112737:29121055,29112738:29120972,29112741:29120814,29112744:29120761,29112747:29120528,29112750:29120476,29112770:29120377,29112777:29120007,29112779:29119495,29112782:29119854,29112786:29113237,29115405:29115963,29159192:29159505,29159921:29164119,29159922:29164010,29159923:29163885,29159949:29168096,29159950:29163550,29159951:29163753,29159952:29163360,29159953:29167120,29159954:29163414,29159955:29163267,29159956:29162795,29159959:29162680,29159962:29163040,29159965:29162860,29159969:29162935,29159972:29162547,29159975:29162473,29159979:2916217', 'assoc_mat': '29034544:metal:4230:29034632,29036058:metal:4230:29036304,29037833:metal:4230:29038660,29039888:metal:4230:29040124,29041915:metal:4230:29047009,29043378:metal:4230:29043751,29049681:metal:4230:29050443,29049699:metal:4230:29050163,29053101:metal:4230:29096597,29053103:metal:4230:29096530,29084807:metal:4230:29089102,29084809:metal:4230:29089068,29084815:metal:4230:29088711,29084818:metal:4230:29088553,29084835:metal:4230:29094687,29084850:metal:4230:29088144,29084854:metal:4230:29092770,29084856:metal:4230:29105644,29105656:metal:4230:29111514,29112704:metal:4230:29122229,29112706:metal:4230:29122159,29112707:metal:4230:29121866,29112720:metal:4230:29121822,29112721:metal:4230:29121782,29112734:metal:4230:29121667,29112736:metal:4230:29121366,29112737:metal:4230:29121055,29112738:metal:4230:29120972,29112741:metal:4230:29120814,29112744:metal:4230:29120761,29112747:metal:4230:29120528,29112750:metal:4230:29120476,29112770:metal:4230:29120377,29112777:metal:4230:29120007,29112779:metal:4230:29119495,29112782:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19601479110557848, 'nb_photo': 429129, 'list_port_cont': '29034570,29034639,29034874,29035002,29035336,29036314,29038663,29040141,29043758,29047017,29050157,29050449,29050561,29088146,29088562,29088698,29089014,29089060,29089104,29092783,29094698,29096544,29096608,29105654,29111517,29113238,29115976,29119503,29119812,29119856,29120019,29120386,29120485,29120523,29120773,29120815,29120971,29121045,29121125,29121365,29121662,29121791,29121825,29121859,29122079,29122167,29122227,29124283,29159510,29160158,29161813,29162182,29162252,29162474,29162548,29162691,29162794,29162865,29162929,29163042,29163273,29163372,29163407,29163539,29163752,29163878,29164001,29164116,29164176,29164572,29167124,29168099,29198205,29201025,29201292,29201358,29201895,29202111,29202157,29202607,29202765,29202928,29203129,29203375,29203602,29203712,29204530,29204974,29205426,29205646,29205879,29206199,29206458,29206666,29207617,29208378,29209538,29209680,29210066,29212249,29212319,29214147,29215890,29219378,29219517,29220756,29222575,29224549,29225501,29226094,29227643,29230967,29231997,2923462', 'assoc_port': '29034543:29034570,29034544:29034639,29034791:29035336,29034853:29034874,29034950:29035002,29036058:29036314,29037833:29038663,29039888:29040141,29041915:29047017,29043378:29043758,29049663:29050561,29049681:29050449,29049699:29050157,29053101:29096608,29053103:29096544,29084807:29089104,29084809:29089060,29084812:29089014,29084815:29088698,29084818:29088562,29084835:29094698,29084850:29088146,29084854:29092783,29084856:29105654,29105656:29111517,29112704:29122227,29112705:29122079,29112706:29122167,29112707:29121859,29112720:29121825,29112721:29121791,29112734:29121662,29112735:29121125,29112736:29121365,29112737:29121045,29112738:29120971,29112741:29120815,29112744:29120773,29112747:29120523,29112750:29120485,29112770:29120386,29112773:29119812,29112777:29120019,29112779:29119503,29112782:29119856,29112786:29113238,29115405:29115976,29118224:29124283,29159192:29159510,29159921:29164116,29159922:29164001,29159923:29163878,29159948:29164176,29159949:29168099,29159950:29163539,29159951:29163752,29159952:2916337', 'assoc_mat': '29034543:papier:4230:29034570,29034544:papier:4230:29034639,29034791:papier:4230:29035336,29034853:papier:4230:29034874,29034950:papier:4230:29035002,29036058:papier:4230:29036314,29037833:papier:4230:29038663,29039888:papier:4230:29040141,29041915:papier:4230:29047017,29043378:papier:4230:29043758,29049663:papier:4230:29050561,29049681:papier:4230:29050449,29049699:papier:4230:29050157,29053101:papier:4230:29096608,29053103:papier:4230:29096544,29084807:papier:4230:29089104,29084809:papier:4230:29089060,29084812:papier:4230:29089014,29084815:papier:4230:29088698,29084818:papier:4230:29088562,29084835:papier:4230:29094698,29084850:papier:4230:29088146,29084854:papier:4230:29092783,29084856:papier:4230:29105654,29105656:papier:4230:29111517,29112704:papier:4230:29122227,29112705:papier:4230:29122079,29112706:papier:4230:29122167,29112707:papier:4230:29121859,29112720:papier:4230:29121825,29112721:papier:4230:29121791,29112734:papier:4230:29121662,29112735:papier:4230:29121125,29112736:papier:4230:29121365,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0037781965532824196, 'nb_photo': 2462, 'list_port_cont': '29034635,29034861,29040133,29043754,29047024,29050156,29050446,29050570,29088566,29088710,29089013,29089103,29092780,29094686,29096542,29096604,29105650,29111520,29113233,29115973,29119511,29119818,29119849,29120006,29120380,29120479,29120518,29120774,29120808,29120974,29121049,29121117,29121364,29121665,29121794,29121830,29122073,29122156,29122228,29124280,29159513,29160160,29161817,29162177,29162261,29162482,29162551,29162689,29162777,29162870,29162933,29163044,29163274,29163370,29163409,29163538,29163744,29163886,29164009,29164124,29164569,29167121,29168102,29198207,29201033,29201288,29201349,29201903,29202112,29202167,29202609,29202759,29202932,29203114,29203385,29203609,29203717,29204540,29204966,29205430,29205884,29206211,29206455,29206660,29207613,29208386,29209547,29209686,29210058,29212322,29215893,29219374,29219522,29220761,29222587,29224554,29225499,29226087,29227639,29230980,29232001,29234626,29236134,29237230,29237809,29240077,29240858,29241919,29242027,29242250,29242436,29243171,29244998,2924543', 'assoc_port': '29034544:29034635,29034853:29034861,29039888:29040133,29041915:29047024,29043378:29043754,29049663:29050570,29049681:29050446,29049699:29050156,29053101:29096604,29053103:29096542,29084807:29089103,29084812:29089013,29084815:29088710,29084818:29088566,29084835:29094686,29084854:29092780,29084856:29105650,29105656:29111520,29112704:29122228,29112705:29122073,29112706:29122156,29112720:29121830,29112721:29121794,29112734:29121665,29112735:29121117,29112736:29121364,29112737:29121049,29112738:29120974,29112741:29120808,29112744:29120774,29112747:29120518,29112750:29120479,29112770:29120380,29112773:29119818,29112777:29120006,29112779:29119511,29112782:29119849,29112786:29113233,29115405:29115973,29118224:29124280,29159192:29159513,29159921:29164124,29159922:29164009,29159923:29163886,29159949:29168102,29159950:29163538,29159951:29163744,29159952:29163370,29159953:29167121,29159954:29163409,29159955:29163274,29159956:29162777,29159959:29162689,29159962:29163044,29159965:29162870,29159969:29162933,29159972:2916255', 'assoc_mat': '29034544:pehd:4230:29034635,29034853:pehd:4230:29034861,29039888:pehd:4230:29040133,29041915:pehd:4230:29047024,29043378:pehd:4230:29043754,29049663:pehd:4230:29050570,29049681:pehd:4230:29050446,29049699:pehd:4230:29050156,29053101:pehd:4230:29096604,29053103:pehd:4230:29096542,29084807:pehd:4230:29089103,29084812:pehd:4230:29089013,29084815:pehd:4230:29088710,29084818:pehd:4230:29088566,29084835:pehd:4230:29094686,29084854:pehd:4230:29092780,29084856:pehd:4230:29105650,29105656:pehd:4230:29111520,29112704:pehd:4230:29122228,29112705:pehd:4230:29122073,29112706:pehd:4230:29122156,29112720:pehd:4230:29121830,29112721:pehd:4230:29121794,29112734:pehd:4230:29121665,29112735:pehd:4230:29121117,29112736:pehd:4230:29121364,29112737:pehd:4230:29121049,29112738:pehd:4230:29120974,29112741:pehd:4230:29120808,29112744:pehd:4230:29120774,29112747:pehd:4230:29120518,29112750:pehd:4230:29120479,29112770:pehd:4230:29120380,29112773:pehd:4230:29119818,29112777:pehd:4230:29120006,29112779:pehd:4230:29119511,29112782:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011427899946044009, 'nb_photo': 25002, 'list_port_cont': '29034568,29034638,29034864,29034997,29035328,29036303,29038656,29040139,29043761,29047023,29050153,29050435,29050559,29088139,29088567,29088708,29089018,29089067,29089097,29092785,29094697,29096541,29096610,29105641,29111516,29113228,29115974,29119502,29119823,29119855,29120020,29120383,29120486,29120521,29120778,29120813,29120973,29121056,29121121,29121354,29121668,29121795,29121824,29121862,29122081,29122162,29122233,29124282,29159509,29160148,29161819,29162179,29162260,29162479,29162544,29162684,29162775,29162869,29162934,29163049,29163275,29163373,29163423,29163551,29163755,29163883,29164006,29164129,29164154,29164567,29167119,29168093,29198202,29201028,29201299,29201354,29201899,29202108,29202169,29202610,29202766,29202934,29203128,29203381,29203611,29203716,29204536,29204972,29205431,29205642,29205890,29206212,29206453,29206667,29207619,29208381,29209544,29209675,29210056,29212253,29212321,29214154,29215888,29219371,29219524,29220752,29222583,29224552,29225505,29226086,29227628,29230981,29232011,2923463', 'assoc_port': '29034543:29034568,29034544:29034638,29034791:29035328,29034853:29034864,29034950:29034997,29036058:29036303,29037833:29038656,29039888:29040139,29041915:29047023,29043378:29043761,29049663:29050559,29049681:29050435,29049699:29050153,29053101:29096610,29053103:29096541,29084807:29089097,29084809:29089067,29084812:29089018,29084815:29088708,29084818:29088567,29084835:29094697,29084850:29088139,29084854:29092785,29084856:29105641,29105656:29111516,29112704:29122233,29112705:29122081,29112706:29122162,29112707:29121862,29112720:29121824,29112721:29121795,29112734:29121668,29112735:29121121,29112736:29121354,29112737:29121056,29112738:29120973,29112741:29120813,29112744:29120778,29112747:29120521,29112750:29120486,29112770:29120383,29112773:29119823,29112777:29120020,29112779:29119502,29112782:29119855,29112786:29113228,29115405:29115974,29118224:29124282,29159192:29159509,29159921:29164129,29159922:29164006,29159923:29163883,29159948:29164154,29159949:29168093,29159950:29163551,29159951:29163755,29159952:2916337', 'assoc_mat': '29034543:pet_clair:4230:29034568,29034544:pet_clair:4230:29034638,29034791:pet_clair:4230:29035328,29034853:pet_clair:4230:29034864,29034950:pet_clair:4230:29034997,29036058:pet_clair:4230:29036303,29037833:pet_clair:4230:29038656,29039888:pet_clair:4230:29040139,29041915:pet_clair:4230:29047023,29043378:pet_clair:4230:29043761,29049663:pet_clair:4230:29050559,29049681:pet_clair:4230:29050435,29049699:pet_clair:4230:29050153,29053101:pet_clair:4230:29096610,29053103:pet_clair:4230:29096541,29084807:pet_clair:4230:29089097,29084809:pet_clair:4230:29089067,29084812:pet_clair:4230:29089018,29084815:pet_clair:4230:29088708,29084818:pet_clair:4230:29088567,29084835:pet_clair:4230:29094697,29084850:pet_clair:4230:29088139,29084854:pet_clair:4230:29092785,29084856:pet_clair:4230:29105641,29105656:pet_clair:4230:29111516,29112704:pet_clair:4230:29122233,29112705:pet_clair:4230:29122081,29112706:pet_clair:4230:29122162,29112707:pet_clair:4230:29121862,29112720:pet_clair:4230:29121824,29112721:pet_clair:4230:29121795,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028309843607396963, 'nb_photo': 1109, 'list_port_cont': '29034644,29040140,29043747,29050148,29050441,29050569,29088557,29089100,29096539,29096606,29111523,29115967,29119510,29119821,29119850,29120017,29120385,29120480,29120527,29120772,29120809,29120978,29121054,29121123,29121368,29121660,29121792,29121827,29122071,29124286,29159503,29160156,29161805,29162180,29162483,29162549,29162866,29162923,29163052,29163365,29163748,29164128,29164168,29164562,29167123,29168104,29198208,29201030,29202104,29202160,29202764,29202931,29203124,29203374,29203612,29203715,29204529,29204967,29205429,29205650,29206201,29206450,29206664,29207616,29208387,29209543,29210059,29212256,29214156,29219377,29219521,29220759,29222580,29224545,29225493,29226095,29227642,29230977,29232003,29234631,29236127,29237234,29237803,29240850,29240900,29241228,29241920,29242031,29242243,29242439,29243166,29245442,29245900,29246191,29246357,29246670,29246959,29247027,29247432,29247911,29248046,29248882,29249092,29266727,29266869,29266977,29267420,29268077,29268305,29268358,29268508,29268903,29269064,2928177', 'assoc_port': '29034544:29034644,29039888:29040140,29043378:29043747,29049663:29050569,29049681:29050441,29049699:29050148,29053101:29096606,29053103:29096539,29084807:29089100,29084818:29088557,29105656:29111523,29112705:29122071,29112720:29121827,29112721:29121792,29112734:29121660,29112735:29121123,29112736:29121368,29112737:29121054,29112738:29120978,29112741:29120809,29112744:29120772,29112747:29120527,29112750:29120480,29112770:29120385,29112773:29119821,29112777:29120017,29112779:29119510,29112782:29119850,29115405:29115967,29118224:29124286,29159192:29159503,29159921:29164128,29159948:29164168,29159949:29168104,29159951:29163748,29159952:29163365,29159953:29167123,29159962:29163052,29159965:29162866,29159969:29162923,29159972:29162549,29159975:29162483,29159979:29162180,29159982:29161805,29159985:29160156,29163964:29164562,29197790:29201030,29197804:29207616,29197818:29202104,29197819:29202160,29197821:29202764,29197822:29202931,29197823:29203124,29197824:29203374,29197825:29203715,29197828:29208387,29197831:2920452', 'assoc_mat': '29034544:pet_fonce:4230:29034644,29039888:pet_fonce:4230:29040140,29043378:pet_fonce:4230:29043747,29049663:pet_fonce:4230:29050569,29049681:pet_fonce:4230:29050441,29049699:pet_fonce:4230:29050148,29053101:pet_fonce:4230:29096606,29053103:pet_fonce:4230:29096539,29084807:pet_fonce:4230:29089100,29084818:pet_fonce:4230:29088557,29105656:pet_fonce:4230:29111523,29112705:pet_fonce:4230:29122071,29112720:pet_fonce:4230:29121827,29112721:pet_fonce:4230:29121792,29112734:pet_fonce:4230:29121660,29112735:pet_fonce:4230:29121123,29112736:pet_fonce:4230:29121368,29112737:pet_fonce:4230:29121054,29112738:pet_fonce:4230:29120978,29112741:pet_fonce:4230:29120809,29112744:pet_fonce:4230:29120772,29112747:pet_fonce:4230:29120527,29112750:pet_fonce:4230:29120480,29112770:pet_fonce:4230:29120385,29112773:pet_fonce:4230:29119821,29112777:pet_fonce:4230:29120017,29112779:pet_fonce:4230:29119510,29112782:pet_fonce:4230:29119850,29115405:pet_fonce:4230:29115967,29118224:pet_fonce:4230:29124286,29159192:pet_fonce:4230:29159503,2'}), 'main_stat': {'nb_photos': 1878}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-12', 0.7458038867249532),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1878,),), 'unwanted_material_monthly_percentage': ((0.7458038867249532,),), 'material_repartition': (('incineration', 1878),), 'material_dict': {'incineration': 1878}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 12, 1), 0.782559127879385, 1), (datetime.date(2025, 12, 2), 0.7607520907333681, 4), (datetime.date(2025, 12, 3), 0.7305432847728657, 4), (datetime.date(2025, 12, 4), 0.7001190730723347, 4), (datetime.date(2025, 12, 5), 0.6793942935044911, 3), (datetime.date(2025, 12, 6), 0.7099478516370435, 3), (datetime.date(2025, 12, 7), 0.8003211873614124, 2), (datetime.date(2025, 12, 8), 0.7857616485441914, 2), (datetime.date(2025, 12, 9), 0.7199457506440788, 1), (datetime.date(2025, 12, 10), 0.7003958306796186, 3), (datetime.date(2025, 12, 11), 0.7052070172627848, 4), (datetime.date(2025, 12, 12), 0.7031190004805288, 4), (datetime.date(2025, 12, 13), 0.7165559988181703, 4), (datetime.date(2025, 12, 14), 0.7972605377181596, 2), (datetime.date(2025, 12, 15), 0.7855811968380854, 3), (datetime.date(2025, 12, 16), 0.7325160071988582, 3), (datetime.date(2025, 12, 17), 0.7143676105549198, 4), (datetime.date(2025, 12, 18), 0.7019727109395051, 2), (datetime.date(2025, 12, 19), 0.6850009577178664, 2), (datetime.date(2025, 12, 20), 0.7233248780084995, 1), (datetime.date(2025, 12, 21), 0.812572055287931, 3), (datetime.date(2025, 12, 22), 0.7956852560395747, 2), (datetime.date(2025, 12, 23), 0.7444263902347409, 2), (datetime.date(2025, 12, 24), 0.662238382761879, 3), (datetime.date(2025, 12, 25), 0.7719450048002514, 3), (datetime.date(2025, 12, 26), 0.7952135353825008, 3), (datetime.date(2025, 12, 27), 0.8068679279304548, 3), (datetime.date(2025, 12, 28), 0.8452341224083783, 2), (datetime.date(2025, 12, 29), 0.8450183398258632, 3), (datetime.date(2025, 12, 30), 0.7556402286669106, 2), (datetime.date(2025, 12, 31), 0.6958647775556747, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 12, 1), 0.782559127879385, 1), (datetime.date(2025, 12, 2), 0.7607520907333681, 4), (datetime.date(2025, 12, 3), 0.7305432847728657, 4), (datetime.date(2025, 12, 4), 0.7001190730723347, 4), (datetime.date(2025, 12, 5), 0.6793942935044911, 3), (datetime.date(2025, 12, 6), 0.7099478516370435, 3), (datetime.date(2025, 12, 7), 0.8003211873614124, 2), (datetime.date(2025, 12, 8), 0.7857616485441914, 2), (datetime.date(2025, 12, 9), 0.7199457506440788, 1), (datetime.date(2025, 12, 10), 0.7003958306796186, 3), (datetime.date(2025, 12, 11), 0.7052070172627848, 4), (datetime.date(2025, 12, 12), 0.7031190004805288, 4), (datetime.date(2025, 12, 13), 0.7165559988181703, 4), (datetime.date(2025, 12, 14), 0.7972605377181596, 2), (datetime.date(2025, 12, 15), 0.7855811968380854, 3), (datetime.date(2025, 12, 16), 0.7325160071988582, 3), (datetime.date(2025, 12, 17), 0.7143676105549198, 4), (datetime.date(2025, 12, 18), 0.7019727109395051, 2), (datetime.date(2025, 12, 19), 0.6850009577178664, 2), (datetime.date(2025, 12, 20), 0.7233248780084995, 1), (datetime.date(2025, 12, 21), 0.812572055287931, 3), (datetime.date(2025, 12, 22), 0.7956852560395747, 2), (datetime.date(2025, 12, 23), 0.7444263902347409, 2), (datetime.date(2025, 12, 24), 0.662238382761879, 3), (datetime.date(2025, 12, 25), 0.7719450048002514, 3), (datetime.date(2025, 12, 26), 0.7952135353825008, 3), (datetime.date(2025, 12, 27), 0.8068679279304548, 3), (datetime.date(2025, 12, 28), 0.8452341224083783, 2), (datetime.date(2025, 12, 29), 0.8450183398258632, 3), (datetime.date(2025, 12, 30), 0.7556402286669106, 2), (datetime.date(2025, 12, 31), 0.6958647775556747, 2))}, 'quality_array': [['-7.805783329419552', '01122025'], ['-7.985406040609226', '02122025'], ['-8.276789589619664', '03122025'], ['-8.251438541846154', '04122025'], ['-8.507259207630412', '05122025'], ['-8.390081864331483', '06122025'], ['-7.750434480256057', '07122025'], ['-7.595853509100009', '08122025'], ['-8.182876707848592', '09122025'], ['-8.111270424939885', '10122025'], ['-8.328604231938124', '11122025'], ['-8.32653002941889', '12122025'], ['-8.340504373652804', '13122025'], ['-8.028589448260991', '14122025'], ['-7.296941517806946', '15122025'], ['-7.847199661297485', '16122025'], ['-8.159191285946976', '17122025'], ['-8.20000801405989', '18122025'], ['-8.23136539861369', '19122025'], ['-8.204519450345279', '20122025'], ['-7.813935862577304', '21122025'], ['-6.537733552912789', '22122025'], ['-7.563697723333075', '23122025'], ['-8.473440283935185', '24122025'], ['-8.67087993411329', '25122025'], ['-7.873780070345554', '26122025'], ['-7.406193558887963', '27122025'], ['-7.629740979233771', '28122025'], ['-6.713891405734814', '29122025'], ['-7.747092100088277', '30122025'], ['-8.177967888731127', '31122025']], 'number_of_batch': ((699,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017166292060819696, 'nb_photo': 20520, 'list_port_cont': '29034558,29034640,29034877,29035008,29035335,29036305,29038664,29040128,29043760,29047013,29050159,29050447,29050566,29088135,29088570,29088699,29089008,29089063,29089087,29092782,29094699,29096528,29096605,29105643,29111507,29113232,29115969,29119509,29119822,29119859,29120012,29120374,29120475,29120519,29120776,29120811,29120979,29121053,29121124,29121355,29121656,29121778,29121817,29121856,29122076,29122165,29122226,29124274,29159498,29160152,29161804,29162178,29162248,29162475,29162537,29162676,29162781,29162863,29162931,29163045,29163268,29163358,29163413,29163549,29163739,29163881,29163995,29164120,29164144,29164556,29167125,29168097,29198192,29201020,29201291,29201357,29201908,29202110,29202163,29202597,29202755,29202936,29203126,29203377,29203613,29203701,29204533,29204965,29205418,29205643,29205886,29206205,29206460,29206665,29207602,29208383,29209537,29209678,29210057,29212247,29212307,29214146,29215895,29219367,29219523,29220744,29222579,29224538,29225491,29226084,29227632,29230972,29232007,2923462', 'assoc_port': '29034543:29034558,29034544:29034640,29034791:29035335,29034853:29034877,29034950:29035008,29036058:29036305,29037833:29038664,29039888:29040128,29041915:29047013,29043378:29043760,29049663:29050566,29049681:29050447,29049699:29050159,29053101:29096605,29053103:29096528,29084807:29089087,29084809:29089063,29084812:29089008,29084815:29088699,29084818:29088570,29084835:29094699,29084850:29088135,29084854:29092782,29084856:29105643,29105656:29111507,29112704:29122226,29112705:29122076,29112706:29122165,29112707:29121856,29112720:29121817,29112721:29121778,29112734:29121656,29112735:29121124,29112736:29121355,29112737:29121053,29112738:29120979,29112741:29120811,29112744:29120776,29112747:29120519,29112750:29120475,29112770:29120374,29112773:29119822,29112777:29120012,29112779:29119509,29112782:29119859,29112786:29113232,29115405:29115969,29118224:29124274,29159192:29159498,29159921:29164120,29159922:29163995,29159923:29163881,29159948:29164144,29159949:29168097,29159950:29163549,29159951:29163739,29159952:2916335', 'assoc_mat': '29034543:autre:4230:29034558,29034544:autre:4230:29034640,29034791:autre:4230:29035335,29034853:autre:4230:29034877,29034950:autre:4230:29035008,29036058:autre:4230:29036305,29037833:autre:4230:29038664,29039888:autre:4230:29040128,29041915:autre:4230:29047013,29043378:autre:4230:29043760,29049663:autre:4230:29050566,29049681:autre:4230:29050447,29049699:autre:4230:29050159,29053101:autre:4230:29096605,29053103:autre:4230:29096528,29084807:autre:4230:29089087,29084809:autre:4230:29089063,29084812:autre:4230:29089008,29084815:autre:4230:29088699,29084818:autre:4230:29088570,29084835:autre:4230:29094699,29084850:autre:4230:29088135,29084854:autre:4230:29092782,29084856:autre:4230:29105643,29105656:autre:4230:29111507,29112704:autre:4230:29122226,29112705:autre:4230:29122076,29112706:autre:4230:29122165,29112707:autre:4230:29121856,29112720:autre:4230:29121817,29112721:autre:4230:29121778,29112734:autre:4230:29121656,29112735:autre:4230:29121124,29112736:autre:4230:29121355,29112737:autre:4230:29121053,29112738:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04849495263304614, 'nb_photo': 91606, 'list_port_cont': '29034559,29034633,29034873,29035000,29035325,29036317,29038662,29040135,29043752,29047011,29050161,29050448,29050555,29088149,29088559,29088700,29089019,29089058,29089095,29092778,29094701,29096536,29096612,29105647,29111519,29113234,29115971,29119512,29119814,29119848,29120016,29120384,29120487,29120524,29120775,29120803,29120976,29121044,29121122,29121370,29121666,29121781,29121828,29121868,29122077,29122160,29122231,29124278,29159511,29160155,29161818,29162174,29162257,29162484,29162542,29162678,29162779,29162857,29162927,29163051,29163265,29163369,29163417,29163548,29163749,29163890,29164003,29164115,29164160,29164571,29167113,29168094,29198196,29201029,29201295,29201353,29201910,29202106,29202166,29202612,29202760,29202940,29203120,29203382,29203614,29203706,29204528,29204975,29205437,29205652,29205887,29206206,29206449,29206657,29207610,29208382,29209536,29209682,29210055,29212255,29212317,29214158,29215897,29219366,29219518,29220757,29222589,29224550,29225492,29226096,29227641,29230978,29232009,2923461', 'assoc_port': '29034543:29034559,29034544:29034633,29034791:29035325,29034853:29034873,29034950:29035000,29036058:29036317,29037833:29038662,29039888:29040135,29041915:29047011,29043378:29043752,29049663:29050555,29049681:29050448,29049699:29050161,29053101:29096612,29053103:29096536,29084807:29089095,29084809:29089058,29084812:29089019,29084815:29088700,29084818:29088559,29084835:29094701,29084850:29088149,29084854:29092778,29084856:29105647,29105656:29111519,29112704:29122231,29112705:29122077,29112706:29122160,29112707:29121868,29112720:29121828,29112721:29121781,29112734:29121666,29112735:29121122,29112736:29121370,29112737:29121044,29112738:29120976,29112741:29120803,29112744:29120775,29112747:29120524,29112750:29120487,29112770:29120384,29112773:29119814,29112777:29120016,29112779:29119512,29112782:29119848,29112786:29113234,29115405:29115971,29118224:29124278,29159192:29159511,29159921:29164115,29159922:29164003,29159923:29163890,29159948:29164160,29159949:29168094,29159950:29163548,29159951:29163749,29159952:2916336', 'assoc_mat': '29034543:carton:4230:29034559,29034544:carton:4230:29034633,29034791:carton:4230:29035325,29034853:carton:4230:29034873,29034950:carton:4230:29035000,29036058:carton:4230:29036317,29037833:carton:4230:29038662,29039888:carton:4230:29040135,29041915:carton:4230:29047011,29043378:carton:4230:29043752,29049663:carton:4230:29050555,29049681:carton:4230:29050448,29049699:carton:4230:29050161,29053101:carton:4230:29096612,29053103:carton:4230:29096536,29084807:carton:4230:29089095,29084809:carton:4230:29089058,29084812:carton:4230:29089019,29084815:carton:4230:29088700,29084818:carton:4230:29088559,29084835:carton:4230:29094701,29084850:carton:4230:29088149,29084854:carton:4230:29092778,29084856:carton:4230:29105647,29105656:carton:4230:29111519,29112704:carton:4230:29122231,29112705:carton:4230:29122077,29112706:carton:4230:29122160,29112707:carton:4230:29121868,29112720:carton:4230:29121828,29112721:carton:4230:29121781,29112734:carton:4230:29121666,29112735:carton:4230:29121122,29112736:carton:4230:29121370,2911'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013129743914947476, 'nb_photo': 1796, 'list_port_cont': '29034632,29036304,29038660,29040124,29043751,29047009,29050163,29050443,29088144,29088553,29088711,29089068,29089102,29092770,29094687,29096530,29096597,29105644,29111514,29113237,29115963,29119495,29119854,29120007,29120377,29120476,29120528,29120761,29120814,29120972,29121055,29121366,29121667,29121782,29121822,29121866,29122159,29122229,29159505,29160147,29161802,29162172,29162259,29162473,29162547,29162680,29162795,29162860,29162935,29163040,29163267,29163360,29163414,29163550,29163753,29163885,29164010,29164119,29164554,29167120,29168096,29198191,29201019,29201285,29201355,29201893,29202115,29202154,29202598,29202751,29202939,29203125,29203371,29203607,29203705,29204537,29204976,29205424,29205880,29206200,29206461,29206661,29207618,29208379,29209546,29209677,29210064,29212239,29212306,29214151,29215896,29219380,29219510,29220758,29222577,29224541,29225502,29226089,29227636,29230971,29232012,29234620,29236132,29237232,29237815,29240075,29240848,29240892,29241227,29241917,29242020,29242246,29242434,2924317', 'assoc_port': '29034544:29034632,29036058:29036304,29037833:29038660,29039888:29040124,29041915:29047009,29043378:29043751,29049681:29050443,29049699:29050163,29053101:29096597,29053103:29096530,29084807:29089102,29084809:29089068,29084815:29088711,29084818:29088553,29084835:29094687,29084850:29088144,29084854:29092770,29084856:29105644,29105656:29111514,29112704:29122229,29112706:29122159,29112707:29121866,29112720:29121822,29112721:29121782,29112734:29121667,29112736:29121366,29112737:29121055,29112738:29120972,29112741:29120814,29112744:29120761,29112747:29120528,29112750:29120476,29112770:29120377,29112777:29120007,29112779:29119495,29112782:29119854,29112786:29113237,29115405:29115963,29159192:29159505,29159921:29164119,29159922:29164010,29159923:29163885,29159949:29168096,29159950:29163550,29159951:29163753,29159952:29163360,29159953:29167120,29159954:29163414,29159955:29163267,29159956:29162795,29159959:29162680,29159962:29163040,29159965:29162860,29159969:29162935,29159972:29162547,29159975:29162473,29159979:2916217', 'assoc_mat': '29034544:metal:4230:29034632,29036058:metal:4230:29036304,29037833:metal:4230:29038660,29039888:metal:4230:29040124,29041915:metal:4230:29047009,29043378:metal:4230:29043751,29049681:metal:4230:29050443,29049699:metal:4230:29050163,29053101:metal:4230:29096597,29053103:metal:4230:29096530,29084807:metal:4230:29089102,29084809:metal:4230:29089068,29084815:metal:4230:29088711,29084818:metal:4230:29088553,29084835:metal:4230:29094687,29084850:metal:4230:29088144,29084854:metal:4230:29092770,29084856:metal:4230:29105644,29105656:metal:4230:29111514,29112704:metal:4230:29122229,29112706:metal:4230:29122159,29112707:metal:4230:29121866,29112720:metal:4230:29121822,29112721:metal:4230:29121782,29112734:metal:4230:29121667,29112736:metal:4230:29121366,29112737:metal:4230:29121055,29112738:metal:4230:29120972,29112741:metal:4230:29120814,29112744:metal:4230:29120761,29112747:metal:4230:29120528,29112750:metal:4230:29120476,29112770:metal:4230:29120377,29112777:metal:4230:29120007,29112779:metal:4230:29119495,29112782:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19601479110557848, 'nb_photo': 429129, 'list_port_cont': '29034570,29034639,29034874,29035002,29035336,29036314,29038663,29040141,29043758,29047017,29050157,29050449,29050561,29088146,29088562,29088698,29089014,29089060,29089104,29092783,29094698,29096544,29096608,29105654,29111517,29113238,29115976,29119503,29119812,29119856,29120019,29120386,29120485,29120523,29120773,29120815,29120971,29121045,29121125,29121365,29121662,29121791,29121825,29121859,29122079,29122167,29122227,29124283,29159510,29160158,29161813,29162182,29162252,29162474,29162548,29162691,29162794,29162865,29162929,29163042,29163273,29163372,29163407,29163539,29163752,29163878,29164001,29164116,29164176,29164572,29167124,29168099,29198205,29201025,29201292,29201358,29201895,29202111,29202157,29202607,29202765,29202928,29203129,29203375,29203602,29203712,29204530,29204974,29205426,29205646,29205879,29206199,29206458,29206666,29207617,29208378,29209538,29209680,29210066,29212249,29212319,29214147,29215890,29219378,29219517,29220756,29222575,29224549,29225501,29226094,29227643,29230967,29231997,2923462', 'assoc_port': '29034543:29034570,29034544:29034639,29034791:29035336,29034853:29034874,29034950:29035002,29036058:29036314,29037833:29038663,29039888:29040141,29041915:29047017,29043378:29043758,29049663:29050561,29049681:29050449,29049699:29050157,29053101:29096608,29053103:29096544,29084807:29089104,29084809:29089060,29084812:29089014,29084815:29088698,29084818:29088562,29084835:29094698,29084850:29088146,29084854:29092783,29084856:29105654,29105656:29111517,29112704:29122227,29112705:29122079,29112706:29122167,29112707:29121859,29112720:29121825,29112721:29121791,29112734:29121662,29112735:29121125,29112736:29121365,29112737:29121045,29112738:29120971,29112741:29120815,29112744:29120773,29112747:29120523,29112750:29120485,29112770:29120386,29112773:29119812,29112777:29120019,29112779:29119503,29112782:29119856,29112786:29113238,29115405:29115976,29118224:29124283,29159192:29159510,29159921:29164116,29159922:29164001,29159923:29163878,29159948:29164176,29159949:29168099,29159950:29163539,29159951:29163752,29159952:2916337', 'assoc_mat': '29034543:papier:4230:29034570,29034544:papier:4230:29034639,29034791:papier:4230:29035336,29034853:papier:4230:29034874,29034950:papier:4230:29035002,29036058:papier:4230:29036314,29037833:papier:4230:29038663,29039888:papier:4230:29040141,29041915:papier:4230:29047017,29043378:papier:4230:29043758,29049663:papier:4230:29050561,29049681:papier:4230:29050449,29049699:papier:4230:29050157,29053101:papier:4230:29096608,29053103:papier:4230:29096544,29084807:papier:4230:29089104,29084809:papier:4230:29089060,29084812:papier:4230:29089014,29084815:papier:4230:29088698,29084818:papier:4230:29088562,29084835:papier:4230:29094698,29084850:papier:4230:29088146,29084854:papier:4230:29092783,29084856:papier:4230:29105654,29105656:papier:4230:29111517,29112704:papier:4230:29122227,29112705:papier:4230:29122079,29112706:papier:4230:29122167,29112707:papier:4230:29121859,29112720:papier:4230:29121825,29112721:papier:4230:29121791,29112734:papier:4230:29121662,29112735:papier:4230:29121125,29112736:papier:4230:29121365,2911'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0037781965532824196, 'nb_photo': 2462, 'list_port_cont': '29034635,29034861,29040133,29043754,29047024,29050156,29050446,29050570,29088566,29088710,29089013,29089103,29092780,29094686,29096542,29096604,29105650,29111520,29113233,29115973,29119511,29119818,29119849,29120006,29120380,29120479,29120518,29120774,29120808,29120974,29121049,29121117,29121364,29121665,29121794,29121830,29122073,29122156,29122228,29124280,29159513,29160160,29161817,29162177,29162261,29162482,29162551,29162689,29162777,29162870,29162933,29163044,29163274,29163370,29163409,29163538,29163744,29163886,29164009,29164124,29164569,29167121,29168102,29198207,29201033,29201288,29201349,29201903,29202112,29202167,29202609,29202759,29202932,29203114,29203385,29203609,29203717,29204540,29204966,29205430,29205884,29206211,29206455,29206660,29207613,29208386,29209547,29209686,29210058,29212322,29215893,29219374,29219522,29220761,29222587,29224554,29225499,29226087,29227639,29230980,29232001,29234626,29236134,29237230,29237809,29240077,29240858,29241919,29242027,29242250,29242436,29243171,29244998,2924543', 'assoc_port': '29034544:29034635,29034853:29034861,29039888:29040133,29041915:29047024,29043378:29043754,29049663:29050570,29049681:29050446,29049699:29050156,29053101:29096604,29053103:29096542,29084807:29089103,29084812:29089013,29084815:29088710,29084818:29088566,29084835:29094686,29084854:29092780,29084856:29105650,29105656:29111520,29112704:29122228,29112705:29122073,29112706:29122156,29112720:29121830,29112721:29121794,29112734:29121665,29112735:29121117,29112736:29121364,29112737:29121049,29112738:29120974,29112741:29120808,29112744:29120774,29112747:29120518,29112750:29120479,29112770:29120380,29112773:29119818,29112777:29120006,29112779:29119511,29112782:29119849,29112786:29113233,29115405:29115973,29118224:29124280,29159192:29159513,29159921:29164124,29159922:29164009,29159923:29163886,29159949:29168102,29159950:29163538,29159951:29163744,29159952:29163370,29159953:29167121,29159954:29163409,29159955:29163274,29159956:29162777,29159959:29162689,29159962:29163044,29159965:29162870,29159969:29162933,29159972:2916255', 'assoc_mat': '29034544:pehd:4230:29034635,29034853:pehd:4230:29034861,29039888:pehd:4230:29040133,29041915:pehd:4230:29047024,29043378:pehd:4230:29043754,29049663:pehd:4230:29050570,29049681:pehd:4230:29050446,29049699:pehd:4230:29050156,29053101:pehd:4230:29096604,29053103:pehd:4230:29096542,29084807:pehd:4230:29089103,29084812:pehd:4230:29089013,29084815:pehd:4230:29088710,29084818:pehd:4230:29088566,29084835:pehd:4230:29094686,29084854:pehd:4230:29092780,29084856:pehd:4230:29105650,29105656:pehd:4230:29111520,29112704:pehd:4230:29122228,29112705:pehd:4230:29122073,29112706:pehd:4230:29122156,29112720:pehd:4230:29121830,29112721:pehd:4230:29121794,29112734:pehd:4230:29121665,29112735:pehd:4230:29121117,29112736:pehd:4230:29121364,29112737:pehd:4230:29121049,29112738:pehd:4230:29120974,29112741:pehd:4230:29120808,29112744:pehd:4230:29120774,29112747:pehd:4230:29120518,29112750:pehd:4230:29120479,29112770:pehd:4230:29120380,29112773:pehd:4230:29119818,29112777:pehd:4230:29120006,29112779:pehd:4230:29119511,29112782:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011427899946044009, 'nb_photo': 25002, 'list_port_cont': '29034568,29034638,29034864,29034997,29035328,29036303,29038656,29040139,29043761,29047023,29050153,29050435,29050559,29088139,29088567,29088708,29089018,29089067,29089097,29092785,29094697,29096541,29096610,29105641,29111516,29113228,29115974,29119502,29119823,29119855,29120020,29120383,29120486,29120521,29120778,29120813,29120973,29121056,29121121,29121354,29121668,29121795,29121824,29121862,29122081,29122162,29122233,29124282,29159509,29160148,29161819,29162179,29162260,29162479,29162544,29162684,29162775,29162869,29162934,29163049,29163275,29163373,29163423,29163551,29163755,29163883,29164006,29164129,29164154,29164567,29167119,29168093,29198202,29201028,29201299,29201354,29201899,29202108,29202169,29202610,29202766,29202934,29203128,29203381,29203611,29203716,29204536,29204972,29205431,29205642,29205890,29206212,29206453,29206667,29207619,29208381,29209544,29209675,29210056,29212253,29212321,29214154,29215888,29219371,29219524,29220752,29222583,29224552,29225505,29226086,29227628,29230981,29232011,2923463', 'assoc_port': '29034543:29034568,29034544:29034638,29034791:29035328,29034853:29034864,29034950:29034997,29036058:29036303,29037833:29038656,29039888:29040139,29041915:29047023,29043378:29043761,29049663:29050559,29049681:29050435,29049699:29050153,29053101:29096610,29053103:29096541,29084807:29089097,29084809:29089067,29084812:29089018,29084815:29088708,29084818:29088567,29084835:29094697,29084850:29088139,29084854:29092785,29084856:29105641,29105656:29111516,29112704:29122233,29112705:29122081,29112706:29122162,29112707:29121862,29112720:29121824,29112721:29121795,29112734:29121668,29112735:29121121,29112736:29121354,29112737:29121056,29112738:29120973,29112741:29120813,29112744:29120778,29112747:29120521,29112750:29120486,29112770:29120383,29112773:29119823,29112777:29120020,29112779:29119502,29112782:29119855,29112786:29113228,29115405:29115974,29118224:29124282,29159192:29159509,29159921:29164129,29159922:29164006,29159923:29163883,29159948:29164154,29159949:29168093,29159950:29163551,29159951:29163755,29159952:2916337', 'assoc_mat': '29034543:pet_clair:4230:29034568,29034544:pet_clair:4230:29034638,29034791:pet_clair:4230:29035328,29034853:pet_clair:4230:29034864,29034950:pet_clair:4230:29034997,29036058:pet_clair:4230:29036303,29037833:pet_clair:4230:29038656,29039888:pet_clair:4230:29040139,29041915:pet_clair:4230:29047023,29043378:pet_clair:4230:29043761,29049663:pet_clair:4230:29050559,29049681:pet_clair:4230:29050435,29049699:pet_clair:4230:29050153,29053101:pet_clair:4230:29096610,29053103:pet_clair:4230:29096541,29084807:pet_clair:4230:29089097,29084809:pet_clair:4230:29089067,29084812:pet_clair:4230:29089018,29084815:pet_clair:4230:29088708,29084818:pet_clair:4230:29088567,29084835:pet_clair:4230:29094697,29084850:pet_clair:4230:29088139,29084854:pet_clair:4230:29092785,29084856:pet_clair:4230:29105641,29105656:pet_clair:4230:29111516,29112704:pet_clair:4230:29122233,29112705:pet_clair:4230:29122081,29112706:pet_clair:4230:29122162,29112707:pet_clair:4230:29121862,29112720:pet_clair:4230:29121824,29112721:pet_clair:4230:29121795,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028309843607396963, 'nb_photo': 1109, 'list_port_cont': '29034644,29040140,29043747,29050148,29050441,29050569,29088557,29089100,29096539,29096606,29111523,29115967,29119510,29119821,29119850,29120017,29120385,29120480,29120527,29120772,29120809,29120978,29121054,29121123,29121368,29121660,29121792,29121827,29122071,29124286,29159503,29160156,29161805,29162180,29162483,29162549,29162866,29162923,29163052,29163365,29163748,29164128,29164168,29164562,29167123,29168104,29198208,29201030,29202104,29202160,29202764,29202931,29203124,29203374,29203612,29203715,29204529,29204967,29205429,29205650,29206201,29206450,29206664,29207616,29208387,29209543,29210059,29212256,29214156,29219377,29219521,29220759,29222580,29224545,29225493,29226095,29227642,29230977,29232003,29234631,29236127,29237234,29237803,29240850,29240900,29241228,29241920,29242031,29242243,29242439,29243166,29245442,29245900,29246191,29246357,29246670,29246959,29247027,29247432,29247911,29248046,29248882,29249092,29266727,29266869,29266977,29267420,29268077,29268305,29268358,29268508,29268903,29269064,2928177', 'assoc_port': '29034544:29034644,29039888:29040140,29043378:29043747,29049663:29050569,29049681:29050441,29049699:29050148,29053101:29096606,29053103:29096539,29084807:29089100,29084818:29088557,29105656:29111523,29112705:29122071,29112720:29121827,29112721:29121792,29112734:29121660,29112735:29121123,29112736:29121368,29112737:29121054,29112738:29120978,29112741:29120809,29112744:29120772,29112747:29120527,29112750:29120480,29112770:29120385,29112773:29119821,29112777:29120017,29112779:29119510,29112782:29119850,29115405:29115967,29118224:29124286,29159192:29159503,29159921:29164128,29159948:29164168,29159949:29168104,29159951:29163748,29159952:29163365,29159953:29167123,29159962:29163052,29159965:29162866,29159969:29162923,29159972:29162549,29159975:29162483,29159979:29162180,29159982:29161805,29159985:29160156,29163964:29164562,29197790:29201030,29197804:29207616,29197818:29202104,29197819:29202160,29197821:29202764,29197822:29202931,29197823:29203124,29197824:29203374,29197825:29203715,29197828:29208387,29197831:2920452', 'assoc_mat': '29034544:pet_fonce:4230:29034644,29039888:pet_fonce:4230:29040140,29043378:pet_fonce:4230:29043747,29049663:pet_fonce:4230:29050569,29049681:pet_fonce:4230:29050441,29049699:pet_fonce:4230:29050148,29053101:pet_fonce:4230:29096606,29053103:pet_fonce:4230:29096539,29084807:pet_fonce:4230:29089100,29084818:pet_fonce:4230:29088557,29105656:pet_fonce:4230:29111523,29112705:pet_fonce:4230:29122071,29112720:pet_fonce:4230:29121827,29112721:pet_fonce:4230:29121792,29112734:pet_fonce:4230:29121660,29112735:pet_fonce:4230:29121123,29112736:pet_fonce:4230:29121368,29112737:pet_fonce:4230:29121054,29112738:pet_fonce:4230:29120978,29112741:pet_fonce:4230:29120809,29112744:pet_fonce:4230:29120772,29112747:pet_fonce:4230:29120527,29112750:pet_fonce:4230:29120480,29112770:pet_fonce:4230:29120385,29112773:pet_fonce:4230:29119821,29112777:pet_fonce:4230:29120017,29112779:pet_fonce:4230:29119510,29112782:pet_fonce:4230:29119850,29115405:pet_fonce:4230:29115967,29118224:pet_fonce:4230:29124286,29159192:pet_fonce:4230:29159503,2'}), 'main_stat': {'nb_photos': 1878}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-12', 0.7458038867249532),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_12_annee_2025.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '1.72%', 20520], 'carton': ['carton', '4.85%', 91606], 'metal': ['metal', '0.13%', 1796], 'papier': ['papier', '19.6%', 429129], 'pehd': ['pehd', '0.38%', 2462], 'pet_clair': ['pet_clair', '1.14%', 25002], 'pet_fonce': ['pet_fonce', '0.28%', 1109]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_12_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.44user 2.87system 0:11.25elapsed 47%CPU (0avgtext+0avgdata 182416maxresident)k 4456inputs+280outputs (86major+50433minor)pagefaults 0swaps