python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-10 _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 : (2, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (2, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 10 mtr_id : dashboard_places : SCCU_cam8 date : 2025-10 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-10%') and created_at like '%2025-10%'))); nb_day : (2, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 10 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 10 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%102025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-10-01 : dt_date_just_month_year : 2025-10-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-10-01" AND ded.date <= "2025-10-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 (2384949,2392601,2406373,2406359,2406349,2408599,2412707,2419635,2428105,2436197,2442073,2442773,2450017,2457657,2465473,2468727,2473647,2476959,2484331,2484211,2484321,2484307,2484297,2484285,2484279,2484227,2484263,2493483,2493489,2496807) 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.01910962275316125, 'nb_photo': 22434, 'list_port_cont': '27420029,27420325,27420492,27420976,27421424,27421670,27422081,27422164,27422540,27422996,27423115,27423693,27424060,27424313,27424503,27425027,27425103,27425567,27425786,27425965,27426228,27426851,27427200,27427482,27432970,27433956,27435592,27438385,27441010,27442602,27443689,27444640,27445041,27446106,27447162,27448304,27449897,27451320,27453007,27455292,27457514,27459650,27459804,27460157,27460295,27460310,27461171,27462555,27539942,27540231,27540544,27540865,27541299,27541850,27542198,27542268,27543047,27543684,27544072,27544257,27544389,27544674,27544777,27545001,27545062,27545155,27545306,27545415,27545586,27545694,27549892,27551301,27552289,27552862,27553204,27553472,27553698,27553815,27554060,27554224,27554322,27554666,27555096,27555424,27555492,27555569,27555816,27556234,27556275,27556512,27556757,27556919,27557161,27560042,27560523,27560784,27561367,27561626,27562533,27563025,27563391,27564141,27564403,27564794,27564947,27565132,27565671,27566170,27566581,27566953,27567049,27567350,27567599,2756764', 'assoc_port': '27419507:27427200,27419510:27427482,27419513:27426851,27419516:27425965,27419519:27426228,27419522:27425786,27419525:27425567,27419527:27424503,27419533:27425103,27419535:27424313,27419541:27424060,27419544:27423115,27419548:27423693,27419552:27422996,27419554:27422540,27419557:27422081,27419561:27421424,27419565:27421670,27419570:27420976,27419575:27420325,27419602:27420029,27419604:27420492,27421654:27422164,27424391:27425027,27432597:27432970,27433683:27433956,27435070:27435592,27437916:27438385,27440113:27441010,27442089:27442602,27443592:27443689,27444389:27444640,27444827:27445041,27445934:27446106,27446964:27447162,27448177:27448304,27449313:27449897,27450899:27451320,27452508:27453007,27454831:27455292,27457154:27457514,27458265:27459650,27458268:27459804,27458271:27460310,27458274:27460295,27458279:27461171,27459637:27460157,27462141:27462555,27530979:27539942,27530983:27540231,27530987:27540544,27530990:27540865,27530994:27541299,27530998:27541850,27531002:27542198,27531006:27542268,27531010:2754304', 'assoc_mat': '27419507:autre:4230:27427200,27419510:autre:4230:27427482,27419513:autre:4230:27426851,27419516:autre:4230:27425965,27419519:autre:4230:27426228,27419522:autre:4230:27425786,27419525:autre:4230:27425567,27419527:autre:4230:27424503,27419533:autre:4230:27425103,27419535:autre:4230:27424313,27419541:autre:4230:27424060,27419544:autre:4230:27423115,27419548:autre:4230:27423693,27419552:autre:4230:27422996,27419554:autre:4230:27422540,27419557:autre:4230:27422081,27419561:autre:4230:27421424,27419565:autre:4230:27421670,27419570:autre:4230:27420976,27419575:autre:4230:27420325,27419602:autre:4230:27420029,27419604:autre:4230:27420492,27421654:autre:4230:27422164,27424391:autre:4230:27425027,27432597:autre:4230:27432970,27433683:autre:4230:27433956,27435070:autre:4230:27435592,27437916:autre:4230:27438385,27440113:autre:4230:27441010,27442089:autre:4230:27442602,27443592:autre:4230:27443689,27444389:autre:4230:27444640,27444827:autre:4230:27445041,27445934:autre:4230:27446106,27446964:autre:4230:27447162,27448177:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.08771510519278632, 'nb_photo': 133916, 'list_port_cont': '27420024,27420332,27420486,27420974,27421410,27421666,27422080,27422171,27422549,27422985,27423122,27423689,27424067,27424308,27424500,27425041,27425092,27425566,27425784,27425975,27426238,27426864,27427204,27427487,27432965,27433955,27435608,27438381,27441014,27442607,27443702,27444650,27445056,27446096,27447149,27448300,27449899,27451325,27453019,27455298,27457519,27459656,27459797,27460163,27460294,27460316,27461163,27462567,27539950,27540226,27540546,27540872,27541296,27541856,27542206,27542275,27543043,27543694,27544070,27544256,27544397,27544680,27544776,27545004,27545059,27545157,27545322,27545416,27545584,27545706,27549905,27551316,27552297,27552861,27553192,27553474,27553701,27553823,27554075,27554219,27554321,27554677,27555106,27555422,27555487,27555584,27555818,27556249,27556284,27556521,27556759,27556909,27557156,27560057,27560530,27560785,27561368,27561635,27562543,27563033,27563389,27564151,27564400,27564810,27564960,27565126,27565674,27566165,27566590,27566960,27567065,27567355,27567596,2756765', 'assoc_port': '27419507:27427204,27419510:27427487,27419513:27426864,27419516:27425975,27419519:27426238,27419522:27425784,27419525:27425566,27419527:27424500,27419533:27425092,27419535:27424308,27419541:27424067,27419544:27423122,27419548:27423689,27419552:27422985,27419554:27422549,27419557:27422080,27419561:27421410,27419565:27421666,27419570:27420974,27419575:27420332,27419602:27420024,27419604:27420486,27421654:27422171,27424391:27425041,27432597:27432965,27433683:27433955,27435070:27435608,27437916:27438381,27440113:27441014,27442089:27442607,27443592:27443702,27444389:27444650,27444827:27445056,27445934:27446096,27446964:27447149,27448177:27448300,27449313:27449899,27450899:27451325,27452508:27453019,27454831:27455298,27457154:27457519,27458265:27459656,27458268:27459797,27458271:27460316,27458274:27460294,27458279:27461163,27459637:27460163,27462141:27462567,27530979:27539950,27530983:27540226,27530987:27540546,27530990:27540872,27530994:27541296,27530998:27541856,27531002:27542206,27531006:27542275,27531010:2754304', 'assoc_mat': '27419507:carton:4230:27427204,27419510:carton:4230:27427487,27419513:carton:4230:27426864,27419516:carton:4230:27425975,27419519:carton:4230:27426238,27419522:carton:4230:27425784,27419525:carton:4230:27425566,27419527:carton:4230:27424500,27419533:carton:4230:27425092,27419535:carton:4230:27424308,27419541:carton:4230:27424067,27419544:carton:4230:27423122,27419548:carton:4230:27423689,27419552:carton:4230:27422985,27419554:carton:4230:27422549,27419557:carton:4230:27422080,27419561:carton:4230:27421410,27419565:carton:4230:27421666,27419570:carton:4230:27420974,27419575:carton:4230:27420332,27419602:carton:4230:27420024,27419604:carton:4230:27420486,27421654:carton:4230:27422171,27424391:carton:4230:27425041,27432597:carton:4230:27432965,27433683:carton:4230:27433955,27435070:carton:4230:27435608,27437916:carton:4230:27438381,27440113:carton:4230:27441014,27442089:carton:4230:27442607,27443592:carton:4230:27443702,27444389:carton:4230:27444650,27444827:carton:4230:27445056,27445934:carton:4230:27446096,2744'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014737838044769599, 'nb_photo': 2023, 'list_port_cont': '27420028,27420494,27420975,27421423,27421667,27422076,27422162,27422542,27422991,27423125,27423686,27424063,27424319,27424488,27425036,27425096,27425564,27425974,27426243,27426849,27427483,27432957,27433954,27435596,27438380,27441021,27442605,27444642,27446091,27447165,27448295,27449888,27451326,27453021,27455294,27457515,27459646,27459803,27460162,27460280,27460311,27461168,27462550,27539958,27540229,27540533,27540870,27541301,27541847,27542212,27543044,27543699,27544082,27544251,27544387,27544682,27544987,27545069,27545153,27545314,27545588,27545695,27549894,27552300,27553205,27553466,27553696,27553808,27554063,27554215,27554319,27554663,27555095,27555436,27555479,27555572,27555821,27556232,27556268,27556524,27556753,27556922,27557147,27560054,27560520,27561369,27561639,27562545,27563026,27563390,27564146,27564389,27564806,27564943,27565119,27565669,27566176,27566583,27566957,27567053,27567342,27567583,27567653,27567997,27573351,27573489,27573537,27573559,27573645,27573692,27573736,27573812,27573910,2757419', 'assoc_port': '27419510:27427483,27419513:27426849,27419516:27425974,27419519:27426243,27419525:27425564,27419527:27424488,27419533:27425096,27419535:27424319,27419541:27424063,27419544:27423125,27419548:27423686,27419552:27422991,27419554:27422542,27419557:27422076,27419561:27421423,27419565:27421667,27419570:27420975,27419602:27420028,27419604:27420494,27421654:27422162,27424391:27425036,27432597:27432957,27433683:27433954,27435070:27435596,27437916:27438380,27440113:27441021,27442089:27442605,27444389:27444642,27445934:27446091,27446964:27447165,27448177:27448295,27449313:27449888,27450899:27451326,27452508:27453021,27454831:27455294,27457154:27457515,27458265:27459646,27458268:27459803,27458271:27460311,27458274:27460280,27458279:27461168,27459637:27460162,27462141:27462550,27530979:27539958,27530983:27540229,27530987:27540533,27530990:27540870,27530994:27541301,27530998:27541847,27531002:27542212,27531010:27543044,27531015:27577036,27531019:27543699,27531024:27578826,27531028:27544082,27531032:27544251,27531037:2754438', 'assoc_mat': '27419510:metal:4230:27427483,27419513:metal:4230:27426849,27419516:metal:4230:27425974,27419519:metal:4230:27426243,27419525:metal:4230:27425564,27419527:metal:4230:27424488,27419533:metal:4230:27425096,27419535:metal:4230:27424319,27419541:metal:4230:27424063,27419544:metal:4230:27423125,27419548:metal:4230:27423686,27419552:metal:4230:27422991,27419554:metal:4230:27422542,27419557:metal:4230:27422076,27419561:metal:4230:27421423,27419565:metal:4230:27421667,27419570:metal:4230:27420975,27419602:metal:4230:27420028,27419604:metal:4230:27420494,27421654:metal:4230:27422162,27424391:metal:4230:27425036,27432597:metal:4230:27432957,27433683:metal:4230:27433954,27435070:metal:4230:27435596,27437916:metal:4230:27438380,27440113:metal:4230:27441021,27442089:metal:4230:27442605,27444389:metal:4230:27444642,27445934:metal:4230:27446091,27446964:metal:4230:27447165,27448177:metal:4230:27448295,27449313:metal:4230:27449888,27450899:metal:4230:27451326,27452508:metal:4230:27453021,27454831:metal:4230:27455294,27457154:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24302153054234552, 'nb_photo': 414994, 'list_port_cont': '27420030,27420327,27420496,27420981,27421422,27421672,27422074,27422177,27422544,27422992,27423123,27423692,27424058,27424306,27424502,27425042,27425095,27425575,27425787,27425978,27426233,27426854,27427207,27427486,27432962,27433953,27435605,27438383,27441018,27442596,27443699,27444653,27445045,27446099,27447158,27448307,27449895,27451322,27453020,27455304,27457522,27459654,27459800,27460164,27460291,27460307,27461179,27462559,27539955,27540225,27540547,27540859,27541293,27541859,27542204,27542277,27543045,27543700,27544081,27544268,27544393,27544683,27544770,27544992,27545066,27545165,27545323,27545426,27545579,27545693,27549903,27551311,27552306,27552854,27553203,27553464,27553699,27553820,27554064,27554231,27554325,27554672,27555109,27555435,27555489,27555578,27555811,27556245,27556283,27556522,27556763,27556923,27557150,27560047,27560531,27560783,27561371,27561630,27562549,27563030,27563383,27564154,27564402,27564807,27564959,27565133,27565683,27566177,27566594,27566964,27567062,27567353,27567598,2756765', 'assoc_port': '27419507:27427207,27419510:27427486,27419513:27426854,27419516:27425978,27419519:27426233,27419522:27425787,27419525:27425575,27419527:27424502,27419533:27425095,27419535:27424306,27419541:27424058,27419544:27423123,27419548:27423692,27419552:27422992,27419554:27422544,27419557:27422074,27419561:27421422,27419565:27421672,27419570:27420981,27419575:27420327,27419602:27420030,27419604:27420496,27421654:27422177,27424391:27425042,27432597:27432962,27433683:27433953,27435070:27435605,27437916:27438383,27440113:27441018,27442089:27442596,27443592:27443699,27444389:27444653,27444827:27445045,27445934:27446099,27446964:27447158,27448177:27448307,27449313:27449895,27450899:27451322,27452508:27453020,27454831:27455304,27457154:27457522,27458265:27459654,27458268:27459800,27458271:27460307,27458274:27460291,27458279:27461179,27459637:27460164,27462141:27462559,27530979:27539955,27530983:27540225,27530987:27540547,27530990:27540859,27530994:27541293,27530998:27541859,27531002:27542204,27531006:27542277,27531010:2754304', 'assoc_mat': '27419507:papier:4230:27427207,27419510:papier:4230:27427486,27419513:papier:4230:27426854,27419516:papier:4230:27425978,27419519:papier:4230:27426233,27419522:papier:4230:27425787,27419525:papier:4230:27425575,27419527:papier:4230:27424502,27419533:papier:4230:27425095,27419535:papier:4230:27424306,27419541:papier:4230:27424058,27419544:papier:4230:27423123,27419548:papier:4230:27423692,27419552:papier:4230:27422992,27419554:papier:4230:27422544,27419557:papier:4230:27422074,27419561:papier:4230:27421422,27419565:papier:4230:27421672,27419570:papier:4230:27420981,27419575:papier:4230:27420327,27419602:papier:4230:27420030,27419604:papier:4230:27420496,27421654:papier:4230:27422177,27424391:papier:4230:27425042,27432597:papier:4230:27432962,27433683:papier:4230:27433953,27435070:papier:4230:27435605,27437916:papier:4230:27438383,27440113:papier:4230:27441018,27442089:papier:4230:27442596,27443592:papier:4230:27443699,27444389:papier:4230:27444653,27444827:papier:4230:27445045,27445934:papier:4230:27446099,2744'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005832209617567787, 'nb_photo': 4289, 'list_port_cont': '27420022,27420331,27420488,27420980,27421425,27421668,27422077,27422172,27422552,27422997,27423691,27424065,27425035,27425102,27425573,27425782,27425973,27426236,27426861,27427499,27432967,27433951,27435604,27438390,27441027,27442608,27443698,27444654,27445048,27446104,27447164,27448306,27449900,27451324,27453011,27455302,27457517,27459647,27459799,27460154,27460288,27460309,27461178,27462563,27539946,27540234,27540548,27540864,27541291,27541860,27542202,27542263,27543046,27543695,27544071,27544260,27544384,27544678,27544766,27545003,27545067,27545162,27545318,27545418,27545580,27545708,27549891,27551314,27552305,27552860,27553200,27553476,27553694,27554069,27554220,27554329,27554681,27555105,27555432,27555488,27555573,27555815,27556242,27556285,27556514,27556762,27556913,27557162,27560049,27560527,27560778,27561364,27561634,27562547,27563018,27563387,27564147,27564401,27564808,27564957,27565128,27565678,27566175,27566595,27566956,27567064,27567345,27567594,27567648,27568013,27573492,27573565,27573646,2757370', 'assoc_port': '27419510:27427499,27419513:27426861,27419516:27425973,27419519:27426236,27419522:27425782,27419525:27425573,27419533:27425102,27419541:27424065,27419548:27423691,27419552:27422997,27419554:27422552,27419557:27422077,27419561:27421425,27419565:27421668,27419570:27420980,27419575:27420331,27419602:27420022,27419604:27420488,27421654:27422172,27424391:27425035,27432597:27432967,27433683:27433951,27435070:27435604,27437916:27438390,27440113:27441027,27442089:27442608,27443592:27443698,27444389:27444654,27444827:27445048,27445934:27446104,27446964:27447164,27448177:27448306,27449313:27449900,27450899:27451324,27452508:27453011,27454831:27455302,27457154:27457517,27458265:27459647,27458268:27459799,27458271:27460309,27458274:27460288,27458279:27461178,27459637:27460154,27462141:27462563,27530979:27539946,27530983:27540234,27530987:27540548,27530990:27540864,27530994:27541291,27530998:27541860,27531002:27542202,27531006:27542263,27531010:27543046,27531015:27577044,27531019:27543695,27531024:27578831,27531028:2754407', 'assoc_mat': '27419510:pehd:4230:27427499,27419513:pehd:4230:27426861,27419516:pehd:4230:27425973,27419519:pehd:4230:27426236,27419522:pehd:4230:27425782,27419525:pehd:4230:27425573,27419533:pehd:4230:27425102,27419541:pehd:4230:27424065,27419548:pehd:4230:27423691,27419552:pehd:4230:27422997,27419554:pehd:4230:27422552,27419557:pehd:4230:27422077,27419561:pehd:4230:27421425,27419565:pehd:4230:27421668,27419570:pehd:4230:27420980,27419575:pehd:4230:27420331,27419602:pehd:4230:27420022,27419604:pehd:4230:27420488,27421654:pehd:4230:27422172,27424391:pehd:4230:27425035,27432597:pehd:4230:27432967,27433683:pehd:4230:27433951,27435070:pehd:4230:27435604,27437916:pehd:4230:27438390,27440113:pehd:4230:27441027,27442089:pehd:4230:27442608,27443592:pehd:4230:27443698,27444389:pehd:4230:27444654,27444827:pehd:4230:27445048,27445934:pehd:4230:27446104,27446964:pehd:4230:27447164,27448177:pehd:4230:27448306,27449313:pehd:4230:27449900,27450899:pehd:4230:27451324,27452508:pehd:4230:27453011,27454831:pehd:4230:27455302,27457154:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0119961364248105, 'nb_photo': 27682, 'list_port_cont': '27420023,27420326,27420497,27420979,27421420,27421660,27422075,27422178,27422548,27422987,27423124,27423683,27424057,27424318,27424505,27425037,27425104,27425563,27425785,27425970,27426244,27426865,27427199,27427494,27432960,27433952,27435609,27438387,27441015,27442601,27443695,27444649,27445057,27446102,27447163,27448294,27449893,27451321,27453008,27455303,27457516,27459648,27459798,27460159,27460293,27460314,27461167,27462554,27539952,27540232,27540545,27540873,27541289,27541863,27542209,27542276,27543039,27543697,27544083,27544266,27544386,27544673,27544768,27544998,27545065,27545168,27545317,27545427,27545578,27545705,27549900,27551308,27552298,27552859,27553202,27553467,27553695,27553821,27554074,27554230,27554330,27554670,27555108,27555437,27555490,27555581,27555820,27556247,27556282,27556523,27556764,27556921,27557155,27560048,27560528,27560779,27561373,27561638,27562552,27563028,27563384,27564150,27564395,27564804,27564946,27565129,27565682,27566174,27566589,27566965,27567048,27567354,27567600,2756765', 'assoc_port': '27419507:27427199,27419510:27427494,27419513:27426865,27419516:27425970,27419519:27426244,27419522:27425785,27419525:27425563,27419527:27424505,27419533:27425104,27419535:27424318,27419541:27424057,27419544:27423124,27419548:27423683,27419552:27422987,27419554:27422548,27419557:27422075,27419561:27421420,27419565:27421660,27419570:27420979,27419575:27420326,27419602:27420023,27419604:27420497,27421654:27422178,27424391:27425037,27432597:27432960,27433683:27433952,27435070:27435609,27437916:27438387,27440113:27441015,27442089:27442601,27443592:27443695,27444389:27444649,27444827:27445057,27445934:27446102,27446964:27447163,27448177:27448294,27449313:27449893,27450899:27451321,27452508:27453008,27454831:27455303,27457154:27457516,27458265:27459648,27458268:27459798,27458271:27460314,27458274:27460293,27458279:27461167,27459637:27460159,27462141:27462554,27530979:27539952,27530983:27540232,27530987:27540545,27530990:27540873,27530994:27541289,27530998:27541863,27531002:27542209,27531006:27542276,27531010:2754303', 'assoc_mat': '27419507:pet_clair:4230:27427199,27419510:pet_clair:4230:27427494,27419513:pet_clair:4230:27426865,27419516:pet_clair:4230:27425970,27419519:pet_clair:4230:27426244,27419522:pet_clair:4230:27425785,27419525:pet_clair:4230:27425563,27419527:pet_clair:4230:27424505,27419533:pet_clair:4230:27425104,27419535:pet_clair:4230:27424318,27419541:pet_clair:4230:27424057,27419544:pet_clair:4230:27423124,27419548:pet_clair:4230:27423683,27419552:pet_clair:4230:27422987,27419554:pet_clair:4230:27422548,27419557:pet_clair:4230:27422075,27419561:pet_clair:4230:27421420,27419565:pet_clair:4230:27421660,27419570:pet_clair:4230:27420979,27419575:pet_clair:4230:27420326,27419602:pet_clair:4230:27420023,27419604:pet_clair:4230:27420497,27421654:pet_clair:4230:27422178,27424391:pet_clair:4230:27425037,27432597:pet_clair:4230:27432960,27433683:pet_clair:4230:27433952,27435070:pet_clair:4230:27435609,27437916:pet_clair:4230:27438387,27440113:pet_clair:4230:27441015,27442089:pet_clair:4230:27442601,27443592:pet_clair:4230:27443695,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005529741630084897, 'nb_photo': 1935, 'list_port_cont': '27420031,27420321,27420493,27420970,27421671,27422070,27422550,27422994,27423118,27424064,27424498,27425043,27425571,27425778,27425972,27427198,27427498,27432968,27433957,27438384,27442606,27443692,27444643,27445054,27446100,27447159,27448309,27449901,27451314,27453015,27455307,27459655,27459801,27460156,27460298,27460308,27461176,27462557,27539951,27540235,27540551,27540871,27541295,27541862,27542207,27542278,27543048,27543696,27544080,27544261,27544396,27544684,27544765,27545002,27545070,27545163,27545424,27545709,27549898,27551313,27552301,27553199,27553477,27553702,27553822,27554072,27554229,27554327,27554678,27555111,27555434,27555493,27555580,27555808,27556241,27556273,27556520,27556754,27556917,27557158,27560058,27560532,27560780,27561376,27561637,27562541,27563020,27563393,27564152,27564406,27564811,27564954,27565130,27565672,27566166,27566582,27566959,27567057,27567351,27567589,27567646,27568006,27573341,27573498,27573534,27573567,27573704,27573918,27574197,27574309,27574628,27574989,27575247,2757540', 'assoc_port': '27419507:27427198,27419510:27427498,27419516:27425972,27419522:27425778,27419525:27425571,27419527:27424498,27419541:27424064,27419544:27423118,27419552:27422994,27419554:27422550,27419557:27422070,27419565:27421671,27419570:27420970,27419575:27420321,27419602:27420031,27419604:27420493,27424391:27425043,27432597:27432968,27433683:27433957,27437916:27438384,27442089:27442606,27443592:27443692,27444389:27444643,27444827:27445054,27445934:27446100,27446964:27447159,27448177:27448309,27449313:27449901,27450899:27451314,27452508:27453015,27454831:27455307,27458265:27459655,27458268:27459801,27458271:27460308,27458274:27460298,27458279:27461176,27459637:27460156,27462141:27462557,27530979:27539951,27530983:27540235,27530987:27540551,27530990:27540871,27530994:27541295,27530998:27541862,27531002:27542207,27531006:27542278,27531010:27543048,27531015:27577033,27531019:27543696,27531024:27578824,27531028:27544080,27531032:27544261,27531037:27544396,27531041:27544684,27531045:27544765,27531050:27545002,27531056:2754507', 'assoc_mat': '27419507:pet_fonce:4230:27427198,27419510:pet_fonce:4230:27427498,27419516:pet_fonce:4230:27425972,27419522:pet_fonce:4230:27425778,27419525:pet_fonce:4230:27425571,27419527:pet_fonce:4230:27424498,27419541:pet_fonce:4230:27424064,27419544:pet_fonce:4230:27423118,27419552:pet_fonce:4230:27422994,27419554:pet_fonce:4230:27422550,27419557:pet_fonce:4230:27422070,27419565:pet_fonce:4230:27421671,27419570:pet_fonce:4230:27420970,27419575:pet_fonce:4230:27420321,27419602:pet_fonce:4230:27420031,27419604:pet_fonce:4230:27420493,27424391:pet_fonce:4230:27425043,27432597:pet_fonce:4230:27432968,27433683:pet_fonce:4230:27433957,27437916:pet_fonce:4230:27438384,27442089:pet_fonce:4230:27442606,27443592:pet_fonce:4230:27443692,27444389:pet_fonce:4230:27444643,27444827:pet_fonce:4230:27445054,27445934:pet_fonce:4230:27446100,27446964:pet_fonce:4230:27447159,27448177:pet_fonce:4230:27448309,27449313:pet_fonce:4230:27449901,27450899:pet_fonce:4230:27451314,27452508:pet_fonce:4230:27453015,27454831:pet_fonce:4230:27455307,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(2384949,2392601,2406373,2406359,2406349,2408599,2412707,2419635,2428105,2436197,2442073,2442773,2450017,2457657,2465473,2468727,2473647,2476959,2484331,2484211,2484321,2484307,2484297,2484285,2484279,2484227,2484263,2493483,2493489,2496807)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-10-01' and date <= '2025-10-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2152,),), 'unwanted_material_monthly_percentage': ((0.6708652212339095,),), 'material_repartition': (('incineration', 2148),), 'material_dict': {'incineration': 2148}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.6621836224573042, 2), (datetime.date(2025, 10, 2), 0.5501164382160674, 3), (datetime.date(2025, 10, 3), 0.5545390101921929, 4), (datetime.date(2025, 10, 4), 0.6446752648513556, 1), (datetime.date(2025, 10, 5), 0.6016927782393107, 3), (datetime.date(2025, 10, 6), 0.7549256199912632, 1), (datetime.date(2025, 10, 7), 0.7316584429779153, 3), (datetime.date(2025, 10, 8), 0.7076534620515413, 2), (datetime.date(2025, 10, 9), 0.612213913384973, 4), (datetime.date(2025, 10, 10), 0.5720284550296283, 2), (datetime.date(2025, 10, 11), 0.5755685716496846, 4), (datetime.date(2025, 10, 12), 0.6681944154140348, 1), (datetime.date(2025, 10, 13), 0.776209558590578, 3), (datetime.date(2025, 10, 14), 0.7605121993265609, 4), (datetime.date(2025, 10, 15), 0.7704658343518099, 3), (datetime.date(2025, 10, 16), 0.69815574783463, 4), (datetime.date(2025, 10, 17), 0.6293686731484096, 4), (datetime.date(2025, 10, 18), 0.6253293128695391, 3), (datetime.date(2025, 10, 19), 0.6465025094692616, 4), (datetime.date(2025, 10, 21), 0.738425827970602, 3), (datetime.date(2025, 10, 22), 0.7184346902083866, 4), (datetime.date(2025, 10, 23), 0.7032820900065192, 2), (datetime.date(2025, 10, 24), 0.693218698834392, 4), (datetime.date(2025, 10, 25), 0.676005327526496, 4), (datetime.date(2025, 10, 26), 0.7766134652133286, 4), (datetime.date(2025, 10, 27), 0.810267851234653, 4), (datetime.date(2025, 10, 28), 0.8014256415981628, 3), (datetime.date(2025, 10, 29), 0.6912286342013098, 4), (datetime.date(2025, 10, 30), 0.4817887379951049, 4), (datetime.date(2025, 10, 31), 0.4953854487740901, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 10, 1), 0.6621836224573042, 2), (datetime.date(2025, 10, 2), 0.5501164382160674, 3), (datetime.date(2025, 10, 3), 0.5545390101921929, 4), (datetime.date(2025, 10, 4), 0.6446752648513556, 1), (datetime.date(2025, 10, 5), 0.6016927782393107, 3), (datetime.date(2025, 10, 6), 0.7549256199912632, 1), (datetime.date(2025, 10, 7), 0.7316584429779153, 3), (datetime.date(2025, 10, 8), 0.7076534620515413, 2), (datetime.date(2025, 10, 9), 0.612213913384973, 4), (datetime.date(2025, 10, 10), 0.5720284550296283, 2), (datetime.date(2025, 10, 11), 0.5755685716496846, 4), (datetime.date(2025, 10, 12), 0.6681944154140348, 1), (datetime.date(2025, 10, 13), 0.776209558590578, 3), (datetime.date(2025, 10, 14), 0.7605121993265609, 4), (datetime.date(2025, 10, 15), 0.7704658343518099, 3), (datetime.date(2025, 10, 16), 0.69815574783463, 4), (datetime.date(2025, 10, 17), 0.6293686731484096, 4), (datetime.date(2025, 10, 18), 0.6253293128695391, 3), (datetime.date(2025, 10, 19), 0.6465025094692616, 4), (datetime.date(2025, 10, 21), 0.738425827970602, 3), (datetime.date(2025, 10, 22), 0.7184346902083866, 4), (datetime.date(2025, 10, 23), 0.7032820900065192, 2), (datetime.date(2025, 10, 24), 0.693218698834392, 4), (datetime.date(2025, 10, 25), 0.676005327526496, 4), (datetime.date(2025, 10, 26), 0.7766134652133286, 4), (datetime.date(2025, 10, 27), 0.810267851234653, 4), (datetime.date(2025, 10, 28), 0.8014256415981628, 3), (datetime.date(2025, 10, 29), 0.6912286342013098, 4), (datetime.date(2025, 10, 30), 0.4817887379951049, 4), (datetime.date(2025, 10, 31), 0.4953854487740901, 4))}, 'quality_array': [['-8.33077176146175', '01102025'], ['-8.635916142733915', '02102025'], ['-8.591152372620439', '03102025'], ['-8.803530082666903', '04102025'], ['-8.81216817608284', '05102025'], ['-8.498116110300105', '06102025'], ['-8.25616084860426', '07102025'], ['-8.400015563971495', '08102025'], ['-8.452120773083804', '09102025'], ['-8.77157569860041', '10102025'], ['-8.65546649336655', '11102025'], ['-8.784366384301817', '12102025'], ['-8.30725682482933', '13102025'], ['-8.346850065398085', '14102025'], ['-8.289256295916505', '15102025'], ['-8.84541420683443', '16102025'], ['-8.164414068635008', '17102025'], ['-8.18296722605106', '18102025'], ['-8.264181270569255', '19102025'], ['-7.856636687992362', '21102025'], ['-8.118009205042236', '22102025'], ['-8.243693555807878', '23102025'], ['-7.994337376404259', '24102025'], ['-7.784099365424771', '25102025'], ['-8.096799593417588', '26102025'], ['-7.757500804751207', '27102025'], ['-7.091212254773034', '28102025'], ['-7.795104921642021', '29102025'], ['-8.780524548910494', '30102025'], ['-8.973931545654855', '31102025']], 'number_of_batch': ((657,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01910962275316125, 'nb_photo': 22434, 'list_port_cont': '27420029,27420325,27420492,27420976,27421424,27421670,27422081,27422164,27422540,27422996,27423115,27423693,27424060,27424313,27424503,27425027,27425103,27425567,27425786,27425965,27426228,27426851,27427200,27427482,27432970,27433956,27435592,27438385,27441010,27442602,27443689,27444640,27445041,27446106,27447162,27448304,27449897,27451320,27453007,27455292,27457514,27459650,27459804,27460157,27460295,27460310,27461171,27462555,27539942,27540231,27540544,27540865,27541299,27541850,27542198,27542268,27543047,27543684,27544072,27544257,27544389,27544674,27544777,27545001,27545062,27545155,27545306,27545415,27545586,27545694,27549892,27551301,27552289,27552862,27553204,27553472,27553698,27553815,27554060,27554224,27554322,27554666,27555096,27555424,27555492,27555569,27555816,27556234,27556275,27556512,27556757,27556919,27557161,27560042,27560523,27560784,27561367,27561626,27562533,27563025,27563391,27564141,27564403,27564794,27564947,27565132,27565671,27566170,27566581,27566953,27567049,27567350,27567599,2756764', 'assoc_port': '27419507:27427200,27419510:27427482,27419513:27426851,27419516:27425965,27419519:27426228,27419522:27425786,27419525:27425567,27419527:27424503,27419533:27425103,27419535:27424313,27419541:27424060,27419544:27423115,27419548:27423693,27419552:27422996,27419554:27422540,27419557:27422081,27419561:27421424,27419565:27421670,27419570:27420976,27419575:27420325,27419602:27420029,27419604:27420492,27421654:27422164,27424391:27425027,27432597:27432970,27433683:27433956,27435070:27435592,27437916:27438385,27440113:27441010,27442089:27442602,27443592:27443689,27444389:27444640,27444827:27445041,27445934:27446106,27446964:27447162,27448177:27448304,27449313:27449897,27450899:27451320,27452508:27453007,27454831:27455292,27457154:27457514,27458265:27459650,27458268:27459804,27458271:27460310,27458274:27460295,27458279:27461171,27459637:27460157,27462141:27462555,27530979:27539942,27530983:27540231,27530987:27540544,27530990:27540865,27530994:27541299,27530998:27541850,27531002:27542198,27531006:27542268,27531010:2754304', 'assoc_mat': '27419507:autre:4230:27427200,27419510:autre:4230:27427482,27419513:autre:4230:27426851,27419516:autre:4230:27425965,27419519:autre:4230:27426228,27419522:autre:4230:27425786,27419525:autre:4230:27425567,27419527:autre:4230:27424503,27419533:autre:4230:27425103,27419535:autre:4230:27424313,27419541:autre:4230:27424060,27419544:autre:4230:27423115,27419548:autre:4230:27423693,27419552:autre:4230:27422996,27419554:autre:4230:27422540,27419557:autre:4230:27422081,27419561:autre:4230:27421424,27419565:autre:4230:27421670,27419570:autre:4230:27420976,27419575:autre:4230:27420325,27419602:autre:4230:27420029,27419604:autre:4230:27420492,27421654:autre:4230:27422164,27424391:autre:4230:27425027,27432597:autre:4230:27432970,27433683:autre:4230:27433956,27435070:autre:4230:27435592,27437916:autre:4230:27438385,27440113:autre:4230:27441010,27442089:autre:4230:27442602,27443592:autre:4230:27443689,27444389:autre:4230:27444640,27444827:autre:4230:27445041,27445934:autre:4230:27446106,27446964:autre:4230:27447162,27448177:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.08771510519278632, 'nb_photo': 133916, 'list_port_cont': '27420024,27420332,27420486,27420974,27421410,27421666,27422080,27422171,27422549,27422985,27423122,27423689,27424067,27424308,27424500,27425041,27425092,27425566,27425784,27425975,27426238,27426864,27427204,27427487,27432965,27433955,27435608,27438381,27441014,27442607,27443702,27444650,27445056,27446096,27447149,27448300,27449899,27451325,27453019,27455298,27457519,27459656,27459797,27460163,27460294,27460316,27461163,27462567,27539950,27540226,27540546,27540872,27541296,27541856,27542206,27542275,27543043,27543694,27544070,27544256,27544397,27544680,27544776,27545004,27545059,27545157,27545322,27545416,27545584,27545706,27549905,27551316,27552297,27552861,27553192,27553474,27553701,27553823,27554075,27554219,27554321,27554677,27555106,27555422,27555487,27555584,27555818,27556249,27556284,27556521,27556759,27556909,27557156,27560057,27560530,27560785,27561368,27561635,27562543,27563033,27563389,27564151,27564400,27564810,27564960,27565126,27565674,27566165,27566590,27566960,27567065,27567355,27567596,2756765', 'assoc_port': '27419507:27427204,27419510:27427487,27419513:27426864,27419516:27425975,27419519:27426238,27419522:27425784,27419525:27425566,27419527:27424500,27419533:27425092,27419535:27424308,27419541:27424067,27419544:27423122,27419548:27423689,27419552:27422985,27419554:27422549,27419557:27422080,27419561:27421410,27419565:27421666,27419570:27420974,27419575:27420332,27419602:27420024,27419604:27420486,27421654:27422171,27424391:27425041,27432597:27432965,27433683:27433955,27435070:27435608,27437916:27438381,27440113:27441014,27442089:27442607,27443592:27443702,27444389:27444650,27444827:27445056,27445934:27446096,27446964:27447149,27448177:27448300,27449313:27449899,27450899:27451325,27452508:27453019,27454831:27455298,27457154:27457519,27458265:27459656,27458268:27459797,27458271:27460316,27458274:27460294,27458279:27461163,27459637:27460163,27462141:27462567,27530979:27539950,27530983:27540226,27530987:27540546,27530990:27540872,27530994:27541296,27530998:27541856,27531002:27542206,27531006:27542275,27531010:2754304', 'assoc_mat': '27419507:carton:4230:27427204,27419510:carton:4230:27427487,27419513:carton:4230:27426864,27419516:carton:4230:27425975,27419519:carton:4230:27426238,27419522:carton:4230:27425784,27419525:carton:4230:27425566,27419527:carton:4230:27424500,27419533:carton:4230:27425092,27419535:carton:4230:27424308,27419541:carton:4230:27424067,27419544:carton:4230:27423122,27419548:carton:4230:27423689,27419552:carton:4230:27422985,27419554:carton:4230:27422549,27419557:carton:4230:27422080,27419561:carton:4230:27421410,27419565:carton:4230:27421666,27419570:carton:4230:27420974,27419575:carton:4230:27420332,27419602:carton:4230:27420024,27419604:carton:4230:27420486,27421654:carton:4230:27422171,27424391:carton:4230:27425041,27432597:carton:4230:27432965,27433683:carton:4230:27433955,27435070:carton:4230:27435608,27437916:carton:4230:27438381,27440113:carton:4230:27441014,27442089:carton:4230:27442607,27443592:carton:4230:27443702,27444389:carton:4230:27444650,27444827:carton:4230:27445056,27445934:carton:4230:27446096,2744'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014737838044769599, 'nb_photo': 2023, 'list_port_cont': '27420028,27420494,27420975,27421423,27421667,27422076,27422162,27422542,27422991,27423125,27423686,27424063,27424319,27424488,27425036,27425096,27425564,27425974,27426243,27426849,27427483,27432957,27433954,27435596,27438380,27441021,27442605,27444642,27446091,27447165,27448295,27449888,27451326,27453021,27455294,27457515,27459646,27459803,27460162,27460280,27460311,27461168,27462550,27539958,27540229,27540533,27540870,27541301,27541847,27542212,27543044,27543699,27544082,27544251,27544387,27544682,27544987,27545069,27545153,27545314,27545588,27545695,27549894,27552300,27553205,27553466,27553696,27553808,27554063,27554215,27554319,27554663,27555095,27555436,27555479,27555572,27555821,27556232,27556268,27556524,27556753,27556922,27557147,27560054,27560520,27561369,27561639,27562545,27563026,27563390,27564146,27564389,27564806,27564943,27565119,27565669,27566176,27566583,27566957,27567053,27567342,27567583,27567653,27567997,27573351,27573489,27573537,27573559,27573645,27573692,27573736,27573812,27573910,2757419', 'assoc_port': '27419510:27427483,27419513:27426849,27419516:27425974,27419519:27426243,27419525:27425564,27419527:27424488,27419533:27425096,27419535:27424319,27419541:27424063,27419544:27423125,27419548:27423686,27419552:27422991,27419554:27422542,27419557:27422076,27419561:27421423,27419565:27421667,27419570:27420975,27419602:27420028,27419604:27420494,27421654:27422162,27424391:27425036,27432597:27432957,27433683:27433954,27435070:27435596,27437916:27438380,27440113:27441021,27442089:27442605,27444389:27444642,27445934:27446091,27446964:27447165,27448177:27448295,27449313:27449888,27450899:27451326,27452508:27453021,27454831:27455294,27457154:27457515,27458265:27459646,27458268:27459803,27458271:27460311,27458274:27460280,27458279:27461168,27459637:27460162,27462141:27462550,27530979:27539958,27530983:27540229,27530987:27540533,27530990:27540870,27530994:27541301,27530998:27541847,27531002:27542212,27531010:27543044,27531015:27577036,27531019:27543699,27531024:27578826,27531028:27544082,27531032:27544251,27531037:2754438', 'assoc_mat': '27419510:metal:4230:27427483,27419513:metal:4230:27426849,27419516:metal:4230:27425974,27419519:metal:4230:27426243,27419525:metal:4230:27425564,27419527:metal:4230:27424488,27419533:metal:4230:27425096,27419535:metal:4230:27424319,27419541:metal:4230:27424063,27419544:metal:4230:27423125,27419548:metal:4230:27423686,27419552:metal:4230:27422991,27419554:metal:4230:27422542,27419557:metal:4230:27422076,27419561:metal:4230:27421423,27419565:metal:4230:27421667,27419570:metal:4230:27420975,27419602:metal:4230:27420028,27419604:metal:4230:27420494,27421654:metal:4230:27422162,27424391:metal:4230:27425036,27432597:metal:4230:27432957,27433683:metal:4230:27433954,27435070:metal:4230:27435596,27437916:metal:4230:27438380,27440113:metal:4230:27441021,27442089:metal:4230:27442605,27444389:metal:4230:27444642,27445934:metal:4230:27446091,27446964:metal:4230:27447165,27448177:metal:4230:27448295,27449313:metal:4230:27449888,27450899:metal:4230:27451326,27452508:metal:4230:27453021,27454831:metal:4230:27455294,27457154:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24302153054234552, 'nb_photo': 414994, 'list_port_cont': '27420030,27420327,27420496,27420981,27421422,27421672,27422074,27422177,27422544,27422992,27423123,27423692,27424058,27424306,27424502,27425042,27425095,27425575,27425787,27425978,27426233,27426854,27427207,27427486,27432962,27433953,27435605,27438383,27441018,27442596,27443699,27444653,27445045,27446099,27447158,27448307,27449895,27451322,27453020,27455304,27457522,27459654,27459800,27460164,27460291,27460307,27461179,27462559,27539955,27540225,27540547,27540859,27541293,27541859,27542204,27542277,27543045,27543700,27544081,27544268,27544393,27544683,27544770,27544992,27545066,27545165,27545323,27545426,27545579,27545693,27549903,27551311,27552306,27552854,27553203,27553464,27553699,27553820,27554064,27554231,27554325,27554672,27555109,27555435,27555489,27555578,27555811,27556245,27556283,27556522,27556763,27556923,27557150,27560047,27560531,27560783,27561371,27561630,27562549,27563030,27563383,27564154,27564402,27564807,27564959,27565133,27565683,27566177,27566594,27566964,27567062,27567353,27567598,2756765', 'assoc_port': '27419507:27427207,27419510:27427486,27419513:27426854,27419516:27425978,27419519:27426233,27419522:27425787,27419525:27425575,27419527:27424502,27419533:27425095,27419535:27424306,27419541:27424058,27419544:27423123,27419548:27423692,27419552:27422992,27419554:27422544,27419557:27422074,27419561:27421422,27419565:27421672,27419570:27420981,27419575:27420327,27419602:27420030,27419604:27420496,27421654:27422177,27424391:27425042,27432597:27432962,27433683:27433953,27435070:27435605,27437916:27438383,27440113:27441018,27442089:27442596,27443592:27443699,27444389:27444653,27444827:27445045,27445934:27446099,27446964:27447158,27448177:27448307,27449313:27449895,27450899:27451322,27452508:27453020,27454831:27455304,27457154:27457522,27458265:27459654,27458268:27459800,27458271:27460307,27458274:27460291,27458279:27461179,27459637:27460164,27462141:27462559,27530979:27539955,27530983:27540225,27530987:27540547,27530990:27540859,27530994:27541293,27530998:27541859,27531002:27542204,27531006:27542277,27531010:2754304', 'assoc_mat': '27419507:papier:4230:27427207,27419510:papier:4230:27427486,27419513:papier:4230:27426854,27419516:papier:4230:27425978,27419519:papier:4230:27426233,27419522:papier:4230:27425787,27419525:papier:4230:27425575,27419527:papier:4230:27424502,27419533:papier:4230:27425095,27419535:papier:4230:27424306,27419541:papier:4230:27424058,27419544:papier:4230:27423123,27419548:papier:4230:27423692,27419552:papier:4230:27422992,27419554:papier:4230:27422544,27419557:papier:4230:27422074,27419561:papier:4230:27421422,27419565:papier:4230:27421672,27419570:papier:4230:27420981,27419575:papier:4230:27420327,27419602:papier:4230:27420030,27419604:papier:4230:27420496,27421654:papier:4230:27422177,27424391:papier:4230:27425042,27432597:papier:4230:27432962,27433683:papier:4230:27433953,27435070:papier:4230:27435605,27437916:papier:4230:27438383,27440113:papier:4230:27441018,27442089:papier:4230:27442596,27443592:papier:4230:27443699,27444389:papier:4230:27444653,27444827:papier:4230:27445045,27445934:papier:4230:27446099,2744'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005832209617567787, 'nb_photo': 4289, 'list_port_cont': '27420022,27420331,27420488,27420980,27421425,27421668,27422077,27422172,27422552,27422997,27423691,27424065,27425035,27425102,27425573,27425782,27425973,27426236,27426861,27427499,27432967,27433951,27435604,27438390,27441027,27442608,27443698,27444654,27445048,27446104,27447164,27448306,27449900,27451324,27453011,27455302,27457517,27459647,27459799,27460154,27460288,27460309,27461178,27462563,27539946,27540234,27540548,27540864,27541291,27541860,27542202,27542263,27543046,27543695,27544071,27544260,27544384,27544678,27544766,27545003,27545067,27545162,27545318,27545418,27545580,27545708,27549891,27551314,27552305,27552860,27553200,27553476,27553694,27554069,27554220,27554329,27554681,27555105,27555432,27555488,27555573,27555815,27556242,27556285,27556514,27556762,27556913,27557162,27560049,27560527,27560778,27561364,27561634,27562547,27563018,27563387,27564147,27564401,27564808,27564957,27565128,27565678,27566175,27566595,27566956,27567064,27567345,27567594,27567648,27568013,27573492,27573565,27573646,2757370', 'assoc_port': '27419510:27427499,27419513:27426861,27419516:27425973,27419519:27426236,27419522:27425782,27419525:27425573,27419533:27425102,27419541:27424065,27419548:27423691,27419552:27422997,27419554:27422552,27419557:27422077,27419561:27421425,27419565:27421668,27419570:27420980,27419575:27420331,27419602:27420022,27419604:27420488,27421654:27422172,27424391:27425035,27432597:27432967,27433683:27433951,27435070:27435604,27437916:27438390,27440113:27441027,27442089:27442608,27443592:27443698,27444389:27444654,27444827:27445048,27445934:27446104,27446964:27447164,27448177:27448306,27449313:27449900,27450899:27451324,27452508:27453011,27454831:27455302,27457154:27457517,27458265:27459647,27458268:27459799,27458271:27460309,27458274:27460288,27458279:27461178,27459637:27460154,27462141:27462563,27530979:27539946,27530983:27540234,27530987:27540548,27530990:27540864,27530994:27541291,27530998:27541860,27531002:27542202,27531006:27542263,27531010:27543046,27531015:27577044,27531019:27543695,27531024:27578831,27531028:2754407', 'assoc_mat': '27419510:pehd:4230:27427499,27419513:pehd:4230:27426861,27419516:pehd:4230:27425973,27419519:pehd:4230:27426236,27419522:pehd:4230:27425782,27419525:pehd:4230:27425573,27419533:pehd:4230:27425102,27419541:pehd:4230:27424065,27419548:pehd:4230:27423691,27419552:pehd:4230:27422997,27419554:pehd:4230:27422552,27419557:pehd:4230:27422077,27419561:pehd:4230:27421425,27419565:pehd:4230:27421668,27419570:pehd:4230:27420980,27419575:pehd:4230:27420331,27419602:pehd:4230:27420022,27419604:pehd:4230:27420488,27421654:pehd:4230:27422172,27424391:pehd:4230:27425035,27432597:pehd:4230:27432967,27433683:pehd:4230:27433951,27435070:pehd:4230:27435604,27437916:pehd:4230:27438390,27440113:pehd:4230:27441027,27442089:pehd:4230:27442608,27443592:pehd:4230:27443698,27444389:pehd:4230:27444654,27444827:pehd:4230:27445048,27445934:pehd:4230:27446104,27446964:pehd:4230:27447164,27448177:pehd:4230:27448306,27449313:pehd:4230:27449900,27450899:pehd:4230:27451324,27452508:pehd:4230:27453011,27454831:pehd:4230:27455302,27457154:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0119961364248105, 'nb_photo': 27682, 'list_port_cont': '27420023,27420326,27420497,27420979,27421420,27421660,27422075,27422178,27422548,27422987,27423124,27423683,27424057,27424318,27424505,27425037,27425104,27425563,27425785,27425970,27426244,27426865,27427199,27427494,27432960,27433952,27435609,27438387,27441015,27442601,27443695,27444649,27445057,27446102,27447163,27448294,27449893,27451321,27453008,27455303,27457516,27459648,27459798,27460159,27460293,27460314,27461167,27462554,27539952,27540232,27540545,27540873,27541289,27541863,27542209,27542276,27543039,27543697,27544083,27544266,27544386,27544673,27544768,27544998,27545065,27545168,27545317,27545427,27545578,27545705,27549900,27551308,27552298,27552859,27553202,27553467,27553695,27553821,27554074,27554230,27554330,27554670,27555108,27555437,27555490,27555581,27555820,27556247,27556282,27556523,27556764,27556921,27557155,27560048,27560528,27560779,27561373,27561638,27562552,27563028,27563384,27564150,27564395,27564804,27564946,27565129,27565682,27566174,27566589,27566965,27567048,27567354,27567600,2756765', 'assoc_port': '27419507:27427199,27419510:27427494,27419513:27426865,27419516:27425970,27419519:27426244,27419522:27425785,27419525:27425563,27419527:27424505,27419533:27425104,27419535:27424318,27419541:27424057,27419544:27423124,27419548:27423683,27419552:27422987,27419554:27422548,27419557:27422075,27419561:27421420,27419565:27421660,27419570:27420979,27419575:27420326,27419602:27420023,27419604:27420497,27421654:27422178,27424391:27425037,27432597:27432960,27433683:27433952,27435070:27435609,27437916:27438387,27440113:27441015,27442089:27442601,27443592:27443695,27444389:27444649,27444827:27445057,27445934:27446102,27446964:27447163,27448177:27448294,27449313:27449893,27450899:27451321,27452508:27453008,27454831:27455303,27457154:27457516,27458265:27459648,27458268:27459798,27458271:27460314,27458274:27460293,27458279:27461167,27459637:27460159,27462141:27462554,27530979:27539952,27530983:27540232,27530987:27540545,27530990:27540873,27530994:27541289,27530998:27541863,27531002:27542209,27531006:27542276,27531010:2754303', 'assoc_mat': '27419507:pet_clair:4230:27427199,27419510:pet_clair:4230:27427494,27419513:pet_clair:4230:27426865,27419516:pet_clair:4230:27425970,27419519:pet_clair:4230:27426244,27419522:pet_clair:4230:27425785,27419525:pet_clair:4230:27425563,27419527:pet_clair:4230:27424505,27419533:pet_clair:4230:27425104,27419535:pet_clair:4230:27424318,27419541:pet_clair:4230:27424057,27419544:pet_clair:4230:27423124,27419548:pet_clair:4230:27423683,27419552:pet_clair:4230:27422987,27419554:pet_clair:4230:27422548,27419557:pet_clair:4230:27422075,27419561:pet_clair:4230:27421420,27419565:pet_clair:4230:27421660,27419570:pet_clair:4230:27420979,27419575:pet_clair:4230:27420326,27419602:pet_clair:4230:27420023,27419604:pet_clair:4230:27420497,27421654:pet_clair:4230:27422178,27424391:pet_clair:4230:27425037,27432597:pet_clair:4230:27432960,27433683:pet_clair:4230:27433952,27435070:pet_clair:4230:27435609,27437916:pet_clair:4230:27438387,27440113:pet_clair:4230:27441015,27442089:pet_clair:4230:27442601,27443592:pet_clair:4230:27443695,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005529741630084897, 'nb_photo': 1935, 'list_port_cont': '27420031,27420321,27420493,27420970,27421671,27422070,27422550,27422994,27423118,27424064,27424498,27425043,27425571,27425778,27425972,27427198,27427498,27432968,27433957,27438384,27442606,27443692,27444643,27445054,27446100,27447159,27448309,27449901,27451314,27453015,27455307,27459655,27459801,27460156,27460298,27460308,27461176,27462557,27539951,27540235,27540551,27540871,27541295,27541862,27542207,27542278,27543048,27543696,27544080,27544261,27544396,27544684,27544765,27545002,27545070,27545163,27545424,27545709,27549898,27551313,27552301,27553199,27553477,27553702,27553822,27554072,27554229,27554327,27554678,27555111,27555434,27555493,27555580,27555808,27556241,27556273,27556520,27556754,27556917,27557158,27560058,27560532,27560780,27561376,27561637,27562541,27563020,27563393,27564152,27564406,27564811,27564954,27565130,27565672,27566166,27566582,27566959,27567057,27567351,27567589,27567646,27568006,27573341,27573498,27573534,27573567,27573704,27573918,27574197,27574309,27574628,27574989,27575247,2757540', 'assoc_port': '27419507:27427198,27419510:27427498,27419516:27425972,27419522:27425778,27419525:27425571,27419527:27424498,27419541:27424064,27419544:27423118,27419552:27422994,27419554:27422550,27419557:27422070,27419565:27421671,27419570:27420970,27419575:27420321,27419602:27420031,27419604:27420493,27424391:27425043,27432597:27432968,27433683:27433957,27437916:27438384,27442089:27442606,27443592:27443692,27444389:27444643,27444827:27445054,27445934:27446100,27446964:27447159,27448177:27448309,27449313:27449901,27450899:27451314,27452508:27453015,27454831:27455307,27458265:27459655,27458268:27459801,27458271:27460308,27458274:27460298,27458279:27461176,27459637:27460156,27462141:27462557,27530979:27539951,27530983:27540235,27530987:27540551,27530990:27540871,27530994:27541295,27530998:27541862,27531002:27542207,27531006:27542278,27531010:27543048,27531015:27577033,27531019:27543696,27531024:27578824,27531028:27544080,27531032:27544261,27531037:27544396,27531041:27544684,27531045:27544765,27531050:27545002,27531056:2754507', 'assoc_mat': '27419507:pet_fonce:4230:27427198,27419510:pet_fonce:4230:27427498,27419516:pet_fonce:4230:27425972,27419522:pet_fonce:4230:27425778,27419525:pet_fonce:4230:27425571,27419527:pet_fonce:4230:27424498,27419541:pet_fonce:4230:27424064,27419544:pet_fonce:4230:27423118,27419552:pet_fonce:4230:27422994,27419554:pet_fonce:4230:27422550,27419557:pet_fonce:4230:27422070,27419565:pet_fonce:4230:27421671,27419570:pet_fonce:4230:27420970,27419575:pet_fonce:4230:27420321,27419602:pet_fonce:4230:27420031,27419604:pet_fonce:4230:27420493,27424391:pet_fonce:4230:27425043,27432597:pet_fonce:4230:27432968,27433683:pet_fonce:4230:27433957,27437916:pet_fonce:4230:27438384,27442089:pet_fonce:4230:27442606,27443592:pet_fonce:4230:27443692,27444389:pet_fonce:4230:27444643,27444827:pet_fonce:4230:27445054,27445934:pet_fonce:4230:27446100,27446964:pet_fonce:4230:27447159,27448177:pet_fonce:4230:27448309,27449313:pet_fonce:4230:27449901,27450899:pet_fonce:4230:27451314,27452508:pet_fonce:4230:27453015,27454831:pet_fonce:4230:27455307,2'}), 'main_stat': {'nb_photos': 2152}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-10', 0.6708652212339095),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2152,),), 'unwanted_material_monthly_percentage': ((0.6708652212339095,),), 'material_repartition': (('incineration', 2148),), 'material_dict': {'incineration': 2148}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 10, 1), 0.6621836224573042, 2), (datetime.date(2025, 10, 2), 0.5501164382160674, 3), (datetime.date(2025, 10, 3), 0.5545390101921929, 4), (datetime.date(2025, 10, 4), 0.6446752648513556, 1), (datetime.date(2025, 10, 5), 0.6016927782393107, 3), (datetime.date(2025, 10, 6), 0.7549256199912632, 1), (datetime.date(2025, 10, 7), 0.7316584429779153, 3), (datetime.date(2025, 10, 8), 0.7076534620515413, 2), (datetime.date(2025, 10, 9), 0.612213913384973, 4), (datetime.date(2025, 10, 10), 0.5720284550296283, 2), (datetime.date(2025, 10, 11), 0.5755685716496846, 4), (datetime.date(2025, 10, 12), 0.6681944154140348, 1), (datetime.date(2025, 10, 13), 0.776209558590578, 3), (datetime.date(2025, 10, 14), 0.7605121993265609, 4), (datetime.date(2025, 10, 15), 0.7704658343518099, 3), (datetime.date(2025, 10, 16), 0.69815574783463, 4), (datetime.date(2025, 10, 17), 0.6293686731484096, 4), (datetime.date(2025, 10, 18), 0.6253293128695391, 3), (datetime.date(2025, 10, 19), 0.6465025094692616, 4), (datetime.date(2025, 10, 21), 0.738425827970602, 3), (datetime.date(2025, 10, 22), 0.7184346902083866, 4), (datetime.date(2025, 10, 23), 0.7032820900065192, 2), (datetime.date(2025, 10, 24), 0.693218698834392, 4), (datetime.date(2025, 10, 25), 0.676005327526496, 4), (datetime.date(2025, 10, 26), 0.7766134652133286, 4), (datetime.date(2025, 10, 27), 0.810267851234653, 4), (datetime.date(2025, 10, 28), 0.8014256415981628, 3), (datetime.date(2025, 10, 29), 0.6912286342013098, 4), (datetime.date(2025, 10, 30), 0.4817887379951049, 4), (datetime.date(2025, 10, 31), 0.4953854487740901, 4)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 10, 1), 0.6621836224573042, 2), (datetime.date(2025, 10, 2), 0.5501164382160674, 3), (datetime.date(2025, 10, 3), 0.5545390101921929, 4), (datetime.date(2025, 10, 4), 0.6446752648513556, 1), (datetime.date(2025, 10, 5), 0.6016927782393107, 3), (datetime.date(2025, 10, 6), 0.7549256199912632, 1), (datetime.date(2025, 10, 7), 0.7316584429779153, 3), (datetime.date(2025, 10, 8), 0.7076534620515413, 2), (datetime.date(2025, 10, 9), 0.612213913384973, 4), (datetime.date(2025, 10, 10), 0.5720284550296283, 2), (datetime.date(2025, 10, 11), 0.5755685716496846, 4), (datetime.date(2025, 10, 12), 0.6681944154140348, 1), (datetime.date(2025, 10, 13), 0.776209558590578, 3), (datetime.date(2025, 10, 14), 0.7605121993265609, 4), (datetime.date(2025, 10, 15), 0.7704658343518099, 3), (datetime.date(2025, 10, 16), 0.69815574783463, 4), (datetime.date(2025, 10, 17), 0.6293686731484096, 4), (datetime.date(2025, 10, 18), 0.6253293128695391, 3), (datetime.date(2025, 10, 19), 0.6465025094692616, 4), (datetime.date(2025, 10, 21), 0.738425827970602, 3), (datetime.date(2025, 10, 22), 0.7184346902083866, 4), (datetime.date(2025, 10, 23), 0.7032820900065192, 2), (datetime.date(2025, 10, 24), 0.693218698834392, 4), (datetime.date(2025, 10, 25), 0.676005327526496, 4), (datetime.date(2025, 10, 26), 0.7766134652133286, 4), (datetime.date(2025, 10, 27), 0.810267851234653, 4), (datetime.date(2025, 10, 28), 0.8014256415981628, 3), (datetime.date(2025, 10, 29), 0.6912286342013098, 4), (datetime.date(2025, 10, 30), 0.4817887379951049, 4), (datetime.date(2025, 10, 31), 0.4953854487740901, 4))}, 'quality_array': [['-8.33077176146175', '01102025'], ['-8.635916142733915', '02102025'], ['-8.591152372620439', '03102025'], ['-8.803530082666903', '04102025'], ['-8.81216817608284', '05102025'], ['-8.498116110300105', '06102025'], ['-8.25616084860426', '07102025'], ['-8.400015563971495', '08102025'], ['-8.452120773083804', '09102025'], ['-8.77157569860041', '10102025'], ['-8.65546649336655', '11102025'], ['-8.784366384301817', '12102025'], ['-8.30725682482933', '13102025'], ['-8.346850065398085', '14102025'], ['-8.289256295916505', '15102025'], ['-8.84541420683443', '16102025'], ['-8.164414068635008', '17102025'], ['-8.18296722605106', '18102025'], ['-8.264181270569255', '19102025'], ['-7.856636687992362', '21102025'], ['-8.118009205042236', '22102025'], ['-8.243693555807878', '23102025'], ['-7.994337376404259', '24102025'], ['-7.784099365424771', '25102025'], ['-8.096799593417588', '26102025'], ['-7.757500804751207', '27102025'], ['-7.091212254773034', '28102025'], ['-7.795104921642021', '29102025'], ['-8.780524548910494', '30102025'], ['-8.973931545654855', '31102025']], 'number_of_batch': ((657,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01910962275316125, 'nb_photo': 22434, 'list_port_cont': '27420029,27420325,27420492,27420976,27421424,27421670,27422081,27422164,27422540,27422996,27423115,27423693,27424060,27424313,27424503,27425027,27425103,27425567,27425786,27425965,27426228,27426851,27427200,27427482,27432970,27433956,27435592,27438385,27441010,27442602,27443689,27444640,27445041,27446106,27447162,27448304,27449897,27451320,27453007,27455292,27457514,27459650,27459804,27460157,27460295,27460310,27461171,27462555,27539942,27540231,27540544,27540865,27541299,27541850,27542198,27542268,27543047,27543684,27544072,27544257,27544389,27544674,27544777,27545001,27545062,27545155,27545306,27545415,27545586,27545694,27549892,27551301,27552289,27552862,27553204,27553472,27553698,27553815,27554060,27554224,27554322,27554666,27555096,27555424,27555492,27555569,27555816,27556234,27556275,27556512,27556757,27556919,27557161,27560042,27560523,27560784,27561367,27561626,27562533,27563025,27563391,27564141,27564403,27564794,27564947,27565132,27565671,27566170,27566581,27566953,27567049,27567350,27567599,2756764', 'assoc_port': '27419507:27427200,27419510:27427482,27419513:27426851,27419516:27425965,27419519:27426228,27419522:27425786,27419525:27425567,27419527:27424503,27419533:27425103,27419535:27424313,27419541:27424060,27419544:27423115,27419548:27423693,27419552:27422996,27419554:27422540,27419557:27422081,27419561:27421424,27419565:27421670,27419570:27420976,27419575:27420325,27419602:27420029,27419604:27420492,27421654:27422164,27424391:27425027,27432597:27432970,27433683:27433956,27435070:27435592,27437916:27438385,27440113:27441010,27442089:27442602,27443592:27443689,27444389:27444640,27444827:27445041,27445934:27446106,27446964:27447162,27448177:27448304,27449313:27449897,27450899:27451320,27452508:27453007,27454831:27455292,27457154:27457514,27458265:27459650,27458268:27459804,27458271:27460310,27458274:27460295,27458279:27461171,27459637:27460157,27462141:27462555,27530979:27539942,27530983:27540231,27530987:27540544,27530990:27540865,27530994:27541299,27530998:27541850,27531002:27542198,27531006:27542268,27531010:2754304', 'assoc_mat': '27419507:autre:4230:27427200,27419510:autre:4230:27427482,27419513:autre:4230:27426851,27419516:autre:4230:27425965,27419519:autre:4230:27426228,27419522:autre:4230:27425786,27419525:autre:4230:27425567,27419527:autre:4230:27424503,27419533:autre:4230:27425103,27419535:autre:4230:27424313,27419541:autre:4230:27424060,27419544:autre:4230:27423115,27419548:autre:4230:27423693,27419552:autre:4230:27422996,27419554:autre:4230:27422540,27419557:autre:4230:27422081,27419561:autre:4230:27421424,27419565:autre:4230:27421670,27419570:autre:4230:27420976,27419575:autre:4230:27420325,27419602:autre:4230:27420029,27419604:autre:4230:27420492,27421654:autre:4230:27422164,27424391:autre:4230:27425027,27432597:autre:4230:27432970,27433683:autre:4230:27433956,27435070:autre:4230:27435592,27437916:autre:4230:27438385,27440113:autre:4230:27441010,27442089:autre:4230:27442602,27443592:autre:4230:27443689,27444389:autre:4230:27444640,27444827:autre:4230:27445041,27445934:autre:4230:27446106,27446964:autre:4230:27447162,27448177:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.08771510519278632, 'nb_photo': 133916, 'list_port_cont': '27420024,27420332,27420486,27420974,27421410,27421666,27422080,27422171,27422549,27422985,27423122,27423689,27424067,27424308,27424500,27425041,27425092,27425566,27425784,27425975,27426238,27426864,27427204,27427487,27432965,27433955,27435608,27438381,27441014,27442607,27443702,27444650,27445056,27446096,27447149,27448300,27449899,27451325,27453019,27455298,27457519,27459656,27459797,27460163,27460294,27460316,27461163,27462567,27539950,27540226,27540546,27540872,27541296,27541856,27542206,27542275,27543043,27543694,27544070,27544256,27544397,27544680,27544776,27545004,27545059,27545157,27545322,27545416,27545584,27545706,27549905,27551316,27552297,27552861,27553192,27553474,27553701,27553823,27554075,27554219,27554321,27554677,27555106,27555422,27555487,27555584,27555818,27556249,27556284,27556521,27556759,27556909,27557156,27560057,27560530,27560785,27561368,27561635,27562543,27563033,27563389,27564151,27564400,27564810,27564960,27565126,27565674,27566165,27566590,27566960,27567065,27567355,27567596,2756765', 'assoc_port': '27419507:27427204,27419510:27427487,27419513:27426864,27419516:27425975,27419519:27426238,27419522:27425784,27419525:27425566,27419527:27424500,27419533:27425092,27419535:27424308,27419541:27424067,27419544:27423122,27419548:27423689,27419552:27422985,27419554:27422549,27419557:27422080,27419561:27421410,27419565:27421666,27419570:27420974,27419575:27420332,27419602:27420024,27419604:27420486,27421654:27422171,27424391:27425041,27432597:27432965,27433683:27433955,27435070:27435608,27437916:27438381,27440113:27441014,27442089:27442607,27443592:27443702,27444389:27444650,27444827:27445056,27445934:27446096,27446964:27447149,27448177:27448300,27449313:27449899,27450899:27451325,27452508:27453019,27454831:27455298,27457154:27457519,27458265:27459656,27458268:27459797,27458271:27460316,27458274:27460294,27458279:27461163,27459637:27460163,27462141:27462567,27530979:27539950,27530983:27540226,27530987:27540546,27530990:27540872,27530994:27541296,27530998:27541856,27531002:27542206,27531006:27542275,27531010:2754304', 'assoc_mat': '27419507:carton:4230:27427204,27419510:carton:4230:27427487,27419513:carton:4230:27426864,27419516:carton:4230:27425975,27419519:carton:4230:27426238,27419522:carton:4230:27425784,27419525:carton:4230:27425566,27419527:carton:4230:27424500,27419533:carton:4230:27425092,27419535:carton:4230:27424308,27419541:carton:4230:27424067,27419544:carton:4230:27423122,27419548:carton:4230:27423689,27419552:carton:4230:27422985,27419554:carton:4230:27422549,27419557:carton:4230:27422080,27419561:carton:4230:27421410,27419565:carton:4230:27421666,27419570:carton:4230:27420974,27419575:carton:4230:27420332,27419602:carton:4230:27420024,27419604:carton:4230:27420486,27421654:carton:4230:27422171,27424391:carton:4230:27425041,27432597:carton:4230:27432965,27433683:carton:4230:27433955,27435070:carton:4230:27435608,27437916:carton:4230:27438381,27440113:carton:4230:27441014,27442089:carton:4230:27442607,27443592:carton:4230:27443702,27444389:carton:4230:27444650,27444827:carton:4230:27445056,27445934:carton:4230:27446096,2744'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0014737838044769599, 'nb_photo': 2023, 'list_port_cont': '27420028,27420494,27420975,27421423,27421667,27422076,27422162,27422542,27422991,27423125,27423686,27424063,27424319,27424488,27425036,27425096,27425564,27425974,27426243,27426849,27427483,27432957,27433954,27435596,27438380,27441021,27442605,27444642,27446091,27447165,27448295,27449888,27451326,27453021,27455294,27457515,27459646,27459803,27460162,27460280,27460311,27461168,27462550,27539958,27540229,27540533,27540870,27541301,27541847,27542212,27543044,27543699,27544082,27544251,27544387,27544682,27544987,27545069,27545153,27545314,27545588,27545695,27549894,27552300,27553205,27553466,27553696,27553808,27554063,27554215,27554319,27554663,27555095,27555436,27555479,27555572,27555821,27556232,27556268,27556524,27556753,27556922,27557147,27560054,27560520,27561369,27561639,27562545,27563026,27563390,27564146,27564389,27564806,27564943,27565119,27565669,27566176,27566583,27566957,27567053,27567342,27567583,27567653,27567997,27573351,27573489,27573537,27573559,27573645,27573692,27573736,27573812,27573910,2757419', 'assoc_port': '27419510:27427483,27419513:27426849,27419516:27425974,27419519:27426243,27419525:27425564,27419527:27424488,27419533:27425096,27419535:27424319,27419541:27424063,27419544:27423125,27419548:27423686,27419552:27422991,27419554:27422542,27419557:27422076,27419561:27421423,27419565:27421667,27419570:27420975,27419602:27420028,27419604:27420494,27421654:27422162,27424391:27425036,27432597:27432957,27433683:27433954,27435070:27435596,27437916:27438380,27440113:27441021,27442089:27442605,27444389:27444642,27445934:27446091,27446964:27447165,27448177:27448295,27449313:27449888,27450899:27451326,27452508:27453021,27454831:27455294,27457154:27457515,27458265:27459646,27458268:27459803,27458271:27460311,27458274:27460280,27458279:27461168,27459637:27460162,27462141:27462550,27530979:27539958,27530983:27540229,27530987:27540533,27530990:27540870,27530994:27541301,27530998:27541847,27531002:27542212,27531010:27543044,27531015:27577036,27531019:27543699,27531024:27578826,27531028:27544082,27531032:27544251,27531037:2754438', 'assoc_mat': '27419510:metal:4230:27427483,27419513:metal:4230:27426849,27419516:metal:4230:27425974,27419519:metal:4230:27426243,27419525:metal:4230:27425564,27419527:metal:4230:27424488,27419533:metal:4230:27425096,27419535:metal:4230:27424319,27419541:metal:4230:27424063,27419544:metal:4230:27423125,27419548:metal:4230:27423686,27419552:metal:4230:27422991,27419554:metal:4230:27422542,27419557:metal:4230:27422076,27419561:metal:4230:27421423,27419565:metal:4230:27421667,27419570:metal:4230:27420975,27419602:metal:4230:27420028,27419604:metal:4230:27420494,27421654:metal:4230:27422162,27424391:metal:4230:27425036,27432597:metal:4230:27432957,27433683:metal:4230:27433954,27435070:metal:4230:27435596,27437916:metal:4230:27438380,27440113:metal:4230:27441021,27442089:metal:4230:27442605,27444389:metal:4230:27444642,27445934:metal:4230:27446091,27446964:metal:4230:27447165,27448177:metal:4230:27448295,27449313:metal:4230:27449888,27450899:metal:4230:27451326,27452508:metal:4230:27453021,27454831:metal:4230:27455294,27457154:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.24302153054234552, 'nb_photo': 414994, 'list_port_cont': '27420030,27420327,27420496,27420981,27421422,27421672,27422074,27422177,27422544,27422992,27423123,27423692,27424058,27424306,27424502,27425042,27425095,27425575,27425787,27425978,27426233,27426854,27427207,27427486,27432962,27433953,27435605,27438383,27441018,27442596,27443699,27444653,27445045,27446099,27447158,27448307,27449895,27451322,27453020,27455304,27457522,27459654,27459800,27460164,27460291,27460307,27461179,27462559,27539955,27540225,27540547,27540859,27541293,27541859,27542204,27542277,27543045,27543700,27544081,27544268,27544393,27544683,27544770,27544992,27545066,27545165,27545323,27545426,27545579,27545693,27549903,27551311,27552306,27552854,27553203,27553464,27553699,27553820,27554064,27554231,27554325,27554672,27555109,27555435,27555489,27555578,27555811,27556245,27556283,27556522,27556763,27556923,27557150,27560047,27560531,27560783,27561371,27561630,27562549,27563030,27563383,27564154,27564402,27564807,27564959,27565133,27565683,27566177,27566594,27566964,27567062,27567353,27567598,2756765', 'assoc_port': '27419507:27427207,27419510:27427486,27419513:27426854,27419516:27425978,27419519:27426233,27419522:27425787,27419525:27425575,27419527:27424502,27419533:27425095,27419535:27424306,27419541:27424058,27419544:27423123,27419548:27423692,27419552:27422992,27419554:27422544,27419557:27422074,27419561:27421422,27419565:27421672,27419570:27420981,27419575:27420327,27419602:27420030,27419604:27420496,27421654:27422177,27424391:27425042,27432597:27432962,27433683:27433953,27435070:27435605,27437916:27438383,27440113:27441018,27442089:27442596,27443592:27443699,27444389:27444653,27444827:27445045,27445934:27446099,27446964:27447158,27448177:27448307,27449313:27449895,27450899:27451322,27452508:27453020,27454831:27455304,27457154:27457522,27458265:27459654,27458268:27459800,27458271:27460307,27458274:27460291,27458279:27461179,27459637:27460164,27462141:27462559,27530979:27539955,27530983:27540225,27530987:27540547,27530990:27540859,27530994:27541293,27530998:27541859,27531002:27542204,27531006:27542277,27531010:2754304', 'assoc_mat': '27419507:papier:4230:27427207,27419510:papier:4230:27427486,27419513:papier:4230:27426854,27419516:papier:4230:27425978,27419519:papier:4230:27426233,27419522:papier:4230:27425787,27419525:papier:4230:27425575,27419527:papier:4230:27424502,27419533:papier:4230:27425095,27419535:papier:4230:27424306,27419541:papier:4230:27424058,27419544:papier:4230:27423123,27419548:papier:4230:27423692,27419552:papier:4230:27422992,27419554:papier:4230:27422544,27419557:papier:4230:27422074,27419561:papier:4230:27421422,27419565:papier:4230:27421672,27419570:papier:4230:27420981,27419575:papier:4230:27420327,27419602:papier:4230:27420030,27419604:papier:4230:27420496,27421654:papier:4230:27422177,27424391:papier:4230:27425042,27432597:papier:4230:27432962,27433683:papier:4230:27433953,27435070:papier:4230:27435605,27437916:papier:4230:27438383,27440113:papier:4230:27441018,27442089:papier:4230:27442596,27443592:papier:4230:27443699,27444389:papier:4230:27444653,27444827:papier:4230:27445045,27445934:papier:4230:27446099,2744'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005832209617567787, 'nb_photo': 4289, 'list_port_cont': '27420022,27420331,27420488,27420980,27421425,27421668,27422077,27422172,27422552,27422997,27423691,27424065,27425035,27425102,27425573,27425782,27425973,27426236,27426861,27427499,27432967,27433951,27435604,27438390,27441027,27442608,27443698,27444654,27445048,27446104,27447164,27448306,27449900,27451324,27453011,27455302,27457517,27459647,27459799,27460154,27460288,27460309,27461178,27462563,27539946,27540234,27540548,27540864,27541291,27541860,27542202,27542263,27543046,27543695,27544071,27544260,27544384,27544678,27544766,27545003,27545067,27545162,27545318,27545418,27545580,27545708,27549891,27551314,27552305,27552860,27553200,27553476,27553694,27554069,27554220,27554329,27554681,27555105,27555432,27555488,27555573,27555815,27556242,27556285,27556514,27556762,27556913,27557162,27560049,27560527,27560778,27561364,27561634,27562547,27563018,27563387,27564147,27564401,27564808,27564957,27565128,27565678,27566175,27566595,27566956,27567064,27567345,27567594,27567648,27568013,27573492,27573565,27573646,2757370', 'assoc_port': '27419510:27427499,27419513:27426861,27419516:27425973,27419519:27426236,27419522:27425782,27419525:27425573,27419533:27425102,27419541:27424065,27419548:27423691,27419552:27422997,27419554:27422552,27419557:27422077,27419561:27421425,27419565:27421668,27419570:27420980,27419575:27420331,27419602:27420022,27419604:27420488,27421654:27422172,27424391:27425035,27432597:27432967,27433683:27433951,27435070:27435604,27437916:27438390,27440113:27441027,27442089:27442608,27443592:27443698,27444389:27444654,27444827:27445048,27445934:27446104,27446964:27447164,27448177:27448306,27449313:27449900,27450899:27451324,27452508:27453011,27454831:27455302,27457154:27457517,27458265:27459647,27458268:27459799,27458271:27460309,27458274:27460288,27458279:27461178,27459637:27460154,27462141:27462563,27530979:27539946,27530983:27540234,27530987:27540548,27530990:27540864,27530994:27541291,27530998:27541860,27531002:27542202,27531006:27542263,27531010:27543046,27531015:27577044,27531019:27543695,27531024:27578831,27531028:2754407', 'assoc_mat': '27419510:pehd:4230:27427499,27419513:pehd:4230:27426861,27419516:pehd:4230:27425973,27419519:pehd:4230:27426236,27419522:pehd:4230:27425782,27419525:pehd:4230:27425573,27419533:pehd:4230:27425102,27419541:pehd:4230:27424065,27419548:pehd:4230:27423691,27419552:pehd:4230:27422997,27419554:pehd:4230:27422552,27419557:pehd:4230:27422077,27419561:pehd:4230:27421425,27419565:pehd:4230:27421668,27419570:pehd:4230:27420980,27419575:pehd:4230:27420331,27419602:pehd:4230:27420022,27419604:pehd:4230:27420488,27421654:pehd:4230:27422172,27424391:pehd:4230:27425035,27432597:pehd:4230:27432967,27433683:pehd:4230:27433951,27435070:pehd:4230:27435604,27437916:pehd:4230:27438390,27440113:pehd:4230:27441027,27442089:pehd:4230:27442608,27443592:pehd:4230:27443698,27444389:pehd:4230:27444654,27444827:pehd:4230:27445048,27445934:pehd:4230:27446104,27446964:pehd:4230:27447164,27448177:pehd:4230:27448306,27449313:pehd:4230:27449900,27450899:pehd:4230:27451324,27452508:pehd:4230:27453011,27454831:pehd:4230:27455302,27457154:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0119961364248105, 'nb_photo': 27682, 'list_port_cont': '27420023,27420326,27420497,27420979,27421420,27421660,27422075,27422178,27422548,27422987,27423124,27423683,27424057,27424318,27424505,27425037,27425104,27425563,27425785,27425970,27426244,27426865,27427199,27427494,27432960,27433952,27435609,27438387,27441015,27442601,27443695,27444649,27445057,27446102,27447163,27448294,27449893,27451321,27453008,27455303,27457516,27459648,27459798,27460159,27460293,27460314,27461167,27462554,27539952,27540232,27540545,27540873,27541289,27541863,27542209,27542276,27543039,27543697,27544083,27544266,27544386,27544673,27544768,27544998,27545065,27545168,27545317,27545427,27545578,27545705,27549900,27551308,27552298,27552859,27553202,27553467,27553695,27553821,27554074,27554230,27554330,27554670,27555108,27555437,27555490,27555581,27555820,27556247,27556282,27556523,27556764,27556921,27557155,27560048,27560528,27560779,27561373,27561638,27562552,27563028,27563384,27564150,27564395,27564804,27564946,27565129,27565682,27566174,27566589,27566965,27567048,27567354,27567600,2756765', 'assoc_port': '27419507:27427199,27419510:27427494,27419513:27426865,27419516:27425970,27419519:27426244,27419522:27425785,27419525:27425563,27419527:27424505,27419533:27425104,27419535:27424318,27419541:27424057,27419544:27423124,27419548:27423683,27419552:27422987,27419554:27422548,27419557:27422075,27419561:27421420,27419565:27421660,27419570:27420979,27419575:27420326,27419602:27420023,27419604:27420497,27421654:27422178,27424391:27425037,27432597:27432960,27433683:27433952,27435070:27435609,27437916:27438387,27440113:27441015,27442089:27442601,27443592:27443695,27444389:27444649,27444827:27445057,27445934:27446102,27446964:27447163,27448177:27448294,27449313:27449893,27450899:27451321,27452508:27453008,27454831:27455303,27457154:27457516,27458265:27459648,27458268:27459798,27458271:27460314,27458274:27460293,27458279:27461167,27459637:27460159,27462141:27462554,27530979:27539952,27530983:27540232,27530987:27540545,27530990:27540873,27530994:27541289,27530998:27541863,27531002:27542209,27531006:27542276,27531010:2754303', 'assoc_mat': '27419507:pet_clair:4230:27427199,27419510:pet_clair:4230:27427494,27419513:pet_clair:4230:27426865,27419516:pet_clair:4230:27425970,27419519:pet_clair:4230:27426244,27419522:pet_clair:4230:27425785,27419525:pet_clair:4230:27425563,27419527:pet_clair:4230:27424505,27419533:pet_clair:4230:27425104,27419535:pet_clair:4230:27424318,27419541:pet_clair:4230:27424057,27419544:pet_clair:4230:27423124,27419548:pet_clair:4230:27423683,27419552:pet_clair:4230:27422987,27419554:pet_clair:4230:27422548,27419557:pet_clair:4230:27422075,27419561:pet_clair:4230:27421420,27419565:pet_clair:4230:27421660,27419570:pet_clair:4230:27420979,27419575:pet_clair:4230:27420326,27419602:pet_clair:4230:27420023,27419604:pet_clair:4230:27420497,27421654:pet_clair:4230:27422178,27424391:pet_clair:4230:27425037,27432597:pet_clair:4230:27432960,27433683:pet_clair:4230:27433952,27435070:pet_clair:4230:27435609,27437916:pet_clair:4230:27438387,27440113:pet_clair:4230:27441015,27442089:pet_clair:4230:27442601,27443592:pet_clair:4230:27443695,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.005529741630084897, 'nb_photo': 1935, 'list_port_cont': '27420031,27420321,27420493,27420970,27421671,27422070,27422550,27422994,27423118,27424064,27424498,27425043,27425571,27425778,27425972,27427198,27427498,27432968,27433957,27438384,27442606,27443692,27444643,27445054,27446100,27447159,27448309,27449901,27451314,27453015,27455307,27459655,27459801,27460156,27460298,27460308,27461176,27462557,27539951,27540235,27540551,27540871,27541295,27541862,27542207,27542278,27543048,27543696,27544080,27544261,27544396,27544684,27544765,27545002,27545070,27545163,27545424,27545709,27549898,27551313,27552301,27553199,27553477,27553702,27553822,27554072,27554229,27554327,27554678,27555111,27555434,27555493,27555580,27555808,27556241,27556273,27556520,27556754,27556917,27557158,27560058,27560532,27560780,27561376,27561637,27562541,27563020,27563393,27564152,27564406,27564811,27564954,27565130,27565672,27566166,27566582,27566959,27567057,27567351,27567589,27567646,27568006,27573341,27573498,27573534,27573567,27573704,27573918,27574197,27574309,27574628,27574989,27575247,2757540', 'assoc_port': '27419507:27427198,27419510:27427498,27419516:27425972,27419522:27425778,27419525:27425571,27419527:27424498,27419541:27424064,27419544:27423118,27419552:27422994,27419554:27422550,27419557:27422070,27419565:27421671,27419570:27420970,27419575:27420321,27419602:27420031,27419604:27420493,27424391:27425043,27432597:27432968,27433683:27433957,27437916:27438384,27442089:27442606,27443592:27443692,27444389:27444643,27444827:27445054,27445934:27446100,27446964:27447159,27448177:27448309,27449313:27449901,27450899:27451314,27452508:27453015,27454831:27455307,27458265:27459655,27458268:27459801,27458271:27460308,27458274:27460298,27458279:27461176,27459637:27460156,27462141:27462557,27530979:27539951,27530983:27540235,27530987:27540551,27530990:27540871,27530994:27541295,27530998:27541862,27531002:27542207,27531006:27542278,27531010:27543048,27531015:27577033,27531019:27543696,27531024:27578824,27531028:27544080,27531032:27544261,27531037:27544396,27531041:27544684,27531045:27544765,27531050:27545002,27531056:2754507', 'assoc_mat': '27419507:pet_fonce:4230:27427198,27419510:pet_fonce:4230:27427498,27419516:pet_fonce:4230:27425972,27419522:pet_fonce:4230:27425778,27419525:pet_fonce:4230:27425571,27419527:pet_fonce:4230:27424498,27419541:pet_fonce:4230:27424064,27419544:pet_fonce:4230:27423118,27419552:pet_fonce:4230:27422994,27419554:pet_fonce:4230:27422550,27419557:pet_fonce:4230:27422070,27419565:pet_fonce:4230:27421671,27419570:pet_fonce:4230:27420970,27419575:pet_fonce:4230:27420321,27419602:pet_fonce:4230:27420031,27419604:pet_fonce:4230:27420493,27424391:pet_fonce:4230:27425043,27432597:pet_fonce:4230:27432968,27433683:pet_fonce:4230:27433957,27437916:pet_fonce:4230:27438384,27442089:pet_fonce:4230:27442606,27443592:pet_fonce:4230:27443692,27444389:pet_fonce:4230:27444643,27444827:pet_fonce:4230:27445054,27445934:pet_fonce:4230:27446100,27446964:pet_fonce:4230:27447159,27448177:pet_fonce:4230:27448309,27449313:pet_fonce:4230:27449901,27450899:pet_fonce:4230:27451314,27452508:pet_fonce:4230:27453015,27454831:pet_fonce:4230:27455307,2'}), 'main_stat': {'nb_photos': 2152}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-10', 0.6708652212339095),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_10_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.91%', 22434], 'carton': ['carton', '8.77%', 133916], 'metal': ['metal', '0.15%', 2023], 'papier': ['papier', '24.3%', 414994], 'pehd': ['pehd', '0.58%', 4289], 'pet_clair': ['pet_clair', '1.2%', 27682], 'pet_fonce': ['pet_fonce', '0.55%', 1935]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_10_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.59user 2.38system 0:08.96elapsed 55%CPU (0avgtext+0avgdata 177952maxresident)k 136808inputs+288outputs (634major+44836minor)pagefaults 0swaps