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 : 2026-01 _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 : (3, 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 : (3, 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 : 01 mtr_id : dashboard_places : SCCU_cam8 date : 2026-01 year : 2026 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 '%2026-01%') and created_at like '%2026-01%'))); nb_day : (3, 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) = 01 and year(ded.date) = 2026 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) = 01 and year(ded.date) = 2026 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 '%012026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-01-01 : dt_date_just_month_year : 2026-01-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 >= "2026-01-01" AND ded.date <= "2026-01-31" 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 (2835561,2842688,2847229,2847813,2853847,2860820,2867737,2872228,2873661,2874682,2875163,2876305,2877691,2879027,2880250,2881433,2882502,2883061,2884127,2885206,2885915,2886690,2887650,2888786,2889142,2890532,2891699,2892852,2894244,2895552,2896707) 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.020532739699440777, 'nb_photo': 29757, 'list_port_cont': '29872106,29872135,29872182,29872254,29872297,29872370,29872396,29872479,29872524,29872564,29872606,29872628,29872673,29872746,29872828,29872867,29872910,29872994,29873054,29873092,29873217,29873289,29873520,29910339,29910512,29910644,29910903,29910951,29911092,29911162,29911247,29911628,29911671,29911730,29912070,29912103,29912271,29912449,29912510,29912614,29912829,29912995,29913203,29913357,29913396,29913415,29913655,29935090,29935161,29935196,29935236,29935258,29935280,29935379,29935417,29935437,29935489,29935564,29935586,29935629,29935673,29935694,29935771,29935813,29935836,29935887,29935962,29935991,29936003,29936254,29937133,29937815,29937975,29938128,29938236,29938396,29938541,29938677,29938798,29939667,29939752,29939886,29940019,29940149,29940213,29940419,29940634,29940688,29940823,29940967,29941090,29941253,29941615,29942865,29943159,29976537,29976641,29976721,29976771,29976796,29976883,29976936,29976971,29977012,29977099,29977140,29977171,29977212,29977302,29977346,29977380,29977431,29977549,2997758', 'assoc_port': '29872039:29873289,29872042:29873217,29872046:29872994,29872049:29873092,29872052:29873054,29872055:29872910,29872057:29872828,29872061:29872867,29872064:29872746,29872068:29872673,29872070:29872606,29872073:29872479,29872075:29872564,29872077:29872524,29872079:29872628,29872080:29872297,29872081:29872370,29872082:29872182,29872083:29872106,29872084:29872396,29872085:29872254,29872086:29872135,29873350:29873520,29910028:29913655,29910033:29913396,29910036:29913357,29910040:29913203,29910044:29910339,29910047:29912995,29910052:29912614,29910056:29912829,29910074:29912510,29910076:29912271,29910079:29912449,29910082:29912103,29910084:29912070,29910087:29911730,29910089:29910512,29910091:29911628,29910105:29911671,29910119:29911162,29910121:29911247,29910123:29911092,29910124:29910903,29910125:29910644,29910126:29910951,29912891:29913415,29934985:29935962,29934988:29936254,29934992:29936003,29934994:29935991,29934996:29935887,29934997:29935673,29934999:29935836,29935000:29935629,29935002:29935564,29935004:2993558', 'assoc_mat': '29872039:autre:4230:29873289,29872042:autre:4230:29873217,29872046:autre:4230:29872994,29872049:autre:4230:29873092,29872052:autre:4230:29873054,29872055:autre:4230:29872910,29872057:autre:4230:29872828,29872061:autre:4230:29872867,29872064:autre:4230:29872746,29872068:autre:4230:29872673,29872070:autre:4230:29872606,29872073:autre:4230:29872479,29872075:autre:4230:29872564,29872077:autre:4230:29872524,29872079:autre:4230:29872628,29872080:autre:4230:29872297,29872081:autre:4230:29872370,29872082:autre:4230:29872182,29872083:autre:4230:29872106,29872084:autre:4230:29872396,29872085:autre:4230:29872254,29872086:autre:4230:29872135,29873350:autre:4230:29873520,29910028:autre:4230:29913655,29910033:autre:4230:29913396,29910036:autre:4230:29913357,29910040:autre:4230:29913203,29910044:autre:4230:29910339,29910047:autre:4230:29912995,29910052:autre:4230:29912614,29910056:autre:4230:29912829,29910074:autre:4230:29912510,29910076:autre:4230:29912271,29910079:autre:4230:29912449,29910082:autre:4230:29912103,29910084:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.101180400304597, 'nb_photo': 184930, 'list_port_cont': '29872104,29872151,29872188,29872258,29872287,29872366,29872408,29872491,29872535,29872560,29872605,29872642,29872682,29872754,29872830,29872865,29872914,29872995,29873062,29873102,29873202,29873278,29873514,29910346,29910509,29910660,29910912,29910956,29911086,29911158,29911250,29911631,29911674,29911733,29912069,29912112,29912267,29912453,29912519,29912613,29912838,29913002,29913211,29913368,29913405,29913438,29913659,29935088,29935163,29935197,29935232,29935269,29935288,29935365,29935412,29935448,29935482,29935560,29935598,29935621,29935663,29935704,29935773,29935817,29935853,29935882,29935958,29936001,29936031,29936247,29937130,29937810,29937986,29938137,29938241,29938409,29938534,29938668,29938815,29939681,29939741,29939890,29940021,29940142,29940208,29940420,29940654,29940695,29940826,29940959,29941089,29941264,29941629,29942874,29943156,29976535,29976640,29976731,29976767,29976800,29976881,29976929,29976961,29977029,29977105,29977149,29977187,29977220,29977308,29977355,29977396,29977425,29977550,2997759', 'assoc_port': '29872039:29873278,29872042:29873202,29872046:29872995,29872049:29873102,29872052:29873062,29872055:29872914,29872057:29872830,29872061:29872865,29872064:29872754,29872068:29872682,29872070:29872605,29872073:29872491,29872075:29872560,29872077:29872535,29872079:29872642,29872080:29872287,29872081:29872366,29872082:29872188,29872083:29872104,29872084:29872408,29872085:29872258,29872086:29872151,29873350:29873514,29910028:29913659,29910033:29913405,29910036:29913368,29910040:29913211,29910044:29910346,29910047:29913002,29910052:29912613,29910056:29912838,29910074:29912519,29910076:29912267,29910079:29912453,29910082:29912112,29910084:29912069,29910087:29911733,29910089:29910509,29910091:29911631,29910105:29911674,29910119:29911158,29910121:29911250,29910123:29911086,29910124:29910912,29910125:29910660,29910126:29910956,29912891:29913438,29934985:29935958,29934988:29936247,29934992:29936031,29934994:29936001,29934996:29935882,29934997:29935663,29934999:29935853,29935000:29935621,29935002:29935560,29935004:2993559', 'assoc_mat': '29872039:carton:4230:29873278,29872042:carton:4230:29873202,29872046:carton:4230:29872995,29872049:carton:4230:29873102,29872052:carton:4230:29873062,29872055:carton:4230:29872914,29872057:carton:4230:29872830,29872061:carton:4230:29872865,29872064:carton:4230:29872754,29872068:carton:4230:29872682,29872070:carton:4230:29872605,29872073:carton:4230:29872491,29872075:carton:4230:29872560,29872077:carton:4230:29872535,29872079:carton:4230:29872642,29872080:carton:4230:29872287,29872081:carton:4230:29872366,29872082:carton:4230:29872188,29872083:carton:4230:29872104,29872084:carton:4230:29872408,29872085:carton:4230:29872258,29872086:carton:4230:29872151,29873350:carton:4230:29873514,29910028:carton:4230:29913659,29910033:carton:4230:29913405,29910036:carton:4230:29913368,29910040:carton:4230:29913211,29910044:carton:4230:29910346,29910047:carton:4230:29913002,29910052:carton:4230:29912613,29910056:carton:4230:29912838,29910074:carton:4230:29912519,29910076:carton:4230:29912267,29910079:carton:4230:29912453,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016569065923495753, 'nb_photo': 2598, 'list_port_cont': '29872102,29872150,29872183,29872261,29872285,29872373,29872405,29872487,29872572,29872639,29872826,29872876,29872909,29872986,29873066,29873094,29873215,29873286,29873504,29910336,29910510,29910946,29911084,29911150,29911255,29911618,29911663,29911729,29912068,29912109,29912272,29912461,29912521,29912603,29912835,29912993,29913209,29913362,29913410,29913420,29913666,29935150,29935228,29935267,29935410,29935439,29935480,29935549,29935599,29935696,29935770,29935814,29935850,29935885,29935956,29935988,29936253,29937132,29937978,29938135,29938402,29938547,29938681,29938812,29939676,29939746,29939876,29940010,29940147,29940211,29940418,29940644,29940698,29940821,29940956,29941105,29941254,29941631,29942860,29943146,29976759,29976801,29976880,29976932,29976959,29977015,29977142,29977183,29977213,29977303,29977438,29977551,29977583,29977744,29977788,29993686,29993758,29993914,29994059,29994203,29994539,29997172,29997642,29999292,30031608,30031942,30032617,30033310,30033893,30034104,30034736,30034974,30035163,3003520', 'assoc_port': '29872039:29873286,29872042:29873215,29872046:29872986,29872049:29873094,29872052:29873066,29872055:29872909,29872057:29872826,29872061:29872876,29872073:29872487,29872075:29872572,29872079:29872639,29872080:29872285,29872081:29872373,29872082:29872183,29872083:29872102,29872084:29872405,29872085:29872261,29872086:29872150,29873350:29873504,29910028:29913666,29910033:29913410,29910036:29913362,29910040:29913209,29910044:29910336,29910047:29912993,29910052:29912603,29910056:29912835,29910074:29912521,29910076:29912272,29910079:29912461,29910082:29912109,29910084:29912068,29910087:29911729,29910089:29910510,29910091:29911618,29910105:29911663,29910119:29911150,29910121:29911255,29910123:29911084,29910126:29910946,29912891:29913420,29934985:29935956,29934988:29936253,29934994:29935988,29934996:29935885,29934999:29935850,29935002:29935549,29935004:29935599,29935005:29935770,29935007:29935814,29935008:29935696,29935010:29935480,29935012:29935228,29935013:29935410,29935016:29935267,29935021:29935439,29935024:2993515', 'assoc_mat': '29872039:metal:4230:29873286,29872042:metal:4230:29873215,29872046:metal:4230:29872986,29872049:metal:4230:29873094,29872052:metal:4230:29873066,29872055:metal:4230:29872909,29872057:metal:4230:29872826,29872061:metal:4230:29872876,29872073:metal:4230:29872487,29872075:metal:4230:29872572,29872079:metal:4230:29872639,29872080:metal:4230:29872285,29872081:metal:4230:29872373,29872082:metal:4230:29872183,29872083:metal:4230:29872102,29872084:metal:4230:29872405,29872085:metal:4230:29872261,29872086:metal:4230:29872150,29873350:metal:4230:29873504,29910028:metal:4230:29913666,29910033:metal:4230:29913410,29910036:metal:4230:29913362,29910040:metal:4230:29913209,29910044:metal:4230:29910336,29910047:metal:4230:29912993,29910052:metal:4230:29912603,29910056:metal:4230:29912835,29910074:metal:4230:29912521,29910076:metal:4230:29912272,29910079:metal:4230:29912461,29910082:metal:4230:29912109,29910084:metal:4230:29912068,29910087:metal:4230:29911729,29910089:metal:4230:29910510,29910091:metal:4230:29911618,29910105:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3030832964132918, 'nb_photo': 551263, 'list_port_cont': '29872108,29872146,29872181,29872252,29872288,29872369,29872409,29872481,29872532,29872568,29872608,29872640,29872677,29872760,29872833,29872875,29872907,29872988,29873060,29873101,29873213,29873280,29873508,29910350,29910503,29910656,29910913,29910955,29911082,29911165,29911257,29911625,29911673,29911726,29912076,29912116,29912277,29912457,29912524,29912607,29912834,29913000,29913195,29913371,29913401,29913434,29913667,29935082,29935152,29935195,29935224,29935271,29935285,29935376,29935408,29935451,29935474,29935553,29935601,29935636,29935671,29935703,29935781,29935810,29935849,29935881,29935953,29935995,29936029,29936255,29937134,29937814,29937982,29938145,29938239,29938406,29938545,29938680,29938811,29939673,29939745,29939878,29940023,29940154,29940217,29940421,29940638,29940697,29940830,29940964,29941102,29941270,29941622,29942867,29943153,29976532,29976630,29976729,29976769,29976798,29976876,29976934,29976969,29977020,29977110,29977147,29977177,29977222,29977315,29977351,29977387,29977439,29977546,2997759', 'assoc_port': '29872039:29873280,29872042:29873213,29872046:29872988,29872049:29873101,29872052:29873060,29872055:29872907,29872057:29872833,29872061:29872875,29872064:29872760,29872068:29872677,29872070:29872608,29872073:29872481,29872075:29872568,29872077:29872532,29872079:29872640,29872080:29872288,29872081:29872369,29872082:29872181,29872083:29872108,29872084:29872409,29872085:29872252,29872086:29872146,29873350:29873508,29910028:29913667,29910033:29913401,29910036:29913371,29910040:29913195,29910044:29910350,29910047:29913000,29910052:29912607,29910056:29912834,29910074:29912524,29910076:29912277,29910079:29912457,29910082:29912116,29910084:29912076,29910087:29911726,29910089:29910503,29910091:29911625,29910105:29911673,29910119:29911165,29910121:29911257,29910123:29911082,29910124:29910913,29910125:29910656,29910126:29910955,29912891:29913434,29934985:29935953,29934988:29936255,29934992:29936029,29934994:29935995,29934996:29935881,29934997:29935671,29934999:29935849,29935000:29935636,29935002:29935553,29935004:2993560', 'assoc_mat': '29872039:papier:4230:29873280,29872042:papier:4230:29873213,29872046:papier:4230:29872988,29872049:papier:4230:29873101,29872052:papier:4230:29873060,29872055:papier:4230:29872907,29872057:papier:4230:29872833,29872061:papier:4230:29872875,29872064:papier:4230:29872760,29872068:papier:4230:29872677,29872070:papier:4230:29872608,29872073:papier:4230:29872481,29872075:papier:4230:29872568,29872077:papier:4230:29872532,29872079:papier:4230:29872640,29872080:papier:4230:29872288,29872081:papier:4230:29872369,29872082:papier:4230:29872181,29872083:papier:4230:29872108,29872084:papier:4230:29872409,29872085:papier:4230:29872252,29872086:papier:4230:29872146,29873350:papier:4230:29873508,29910028:papier:4230:29913667,29910033:papier:4230:29913401,29910036:papier:4230:29913371,29910040:papier:4230:29913195,29910044:papier:4230:29910350,29910047:papier:4230:29913000,29910052:papier:4230:29912607,29910056:papier:4230:29912834,29910074:papier:4230:29912524,29910076:papier:4230:29912277,29910079:papier:4230:29912457,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007240459651323948, 'nb_photo': 8040, 'list_port_cont': '29872103,29872149,29872185,29872257,29872299,29872372,29872529,29872570,29872600,29872643,29872679,29872762,29872839,29872877,29872912,29872990,29873068,29873104,29873214,29873287,29873511,29910343,29910493,29910650,29910914,29910945,29911091,29911166,29911248,29911619,29911678,29911727,29912075,29912117,29912275,29912464,29912523,29912615,29912833,29912994,29913200,29913373,29913411,29913436,29913660,29935083,29935160,29935194,29935227,29935266,29935281,29935372,29935416,29935452,29935484,29935563,29935592,29935632,29935667,29935708,29935777,29935809,29935839,29935880,29935955,29936000,29936009,29936246,29937122,29937813,29937974,29938141,29938235,29938412,29938543,29938671,29938804,29939680,29939750,29939891,29940020,29940153,29940216,29940424,29940660,29940699,29940952,29941099,29941267,29942870,29943152,29976527,29976635,29976726,29976764,29976806,29976872,29976935,29976972,29977021,29977148,29977184,29977316,29977344,29977430,29977542,29977747,29978894,29979501,29993926,29994047,29994215,29994545,2999467', 'assoc_port': '29872039:29873287,29872042:29873214,29872046:29872990,29872049:29873104,29872052:29873068,29872055:29872912,29872057:29872839,29872061:29872877,29872064:29872762,29872068:29872679,29872070:29872600,29872075:29872570,29872077:29872529,29872079:29872643,29872080:29872299,29872081:29872372,29872082:29872185,29872083:29872103,29872085:29872257,29872086:29872149,29873350:29873511,29910028:29913660,29910033:29913411,29910036:29913373,29910040:29913200,29910044:29910343,29910047:29912994,29910052:29912615,29910056:29912833,29910074:29912523,29910076:29912275,29910079:29912464,29910082:29912117,29910084:29912075,29910087:29911727,29910089:29910493,29910091:29911619,29910105:29911678,29910119:29911166,29910121:29911248,29910123:29911091,29910124:29910914,29910125:29910650,29910126:29910945,29912891:29913436,29934985:29935955,29934988:29936246,29934992:29936009,29934994:29936000,29934996:29935880,29934997:29935667,29934999:29935839,29935000:29935632,29935002:29935563,29935004:29935592,29935005:29935777,29935007:2993580', 'assoc_mat': '29872039:pehd:4230:29873287,29872042:pehd:4230:29873214,29872046:pehd:4230:29872990,29872049:pehd:4230:29873104,29872052:pehd:4230:29873068,29872055:pehd:4230:29872912,29872057:pehd:4230:29872839,29872061:pehd:4230:29872877,29872064:pehd:4230:29872762,29872068:pehd:4230:29872679,29872070:pehd:4230:29872600,29872075:pehd:4230:29872570,29872077:pehd:4230:29872529,29872079:pehd:4230:29872643,29872080:pehd:4230:29872299,29872081:pehd:4230:29872372,29872082:pehd:4230:29872185,29872083:pehd:4230:29872103,29872085:pehd:4230:29872257,29872086:pehd:4230:29872149,29873350:pehd:4230:29873511,29910028:pehd:4230:29913660,29910033:pehd:4230:29913411,29910036:pehd:4230:29913373,29910040:pehd:4230:29913200,29910044:pehd:4230:29910343,29910047:pehd:4230:29912994,29910052:pehd:4230:29912615,29910056:pehd:4230:29912833,29910074:pehd:4230:29912523,29910076:pehd:4230:29912275,29910079:pehd:4230:29912464,29910082:pehd:4230:29912117,29910084:pehd:4230:29912075,29910087:pehd:4230:29911727,29910089:pehd:4230:29910493,29910091:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017619377937600246, 'nb_photo': 45313, 'list_port_cont': '29872097,29872148,29872180,29872256,29872298,29872362,29872401,29872493,29872533,29872569,29872604,29872641,29872680,29872745,29872834,29872870,29872908,29872992,29873063,29873107,29873210,29873291,29873513,29910348,29910497,29910658,29910917,29910947,29911087,29911163,29911251,29911626,29911677,29911722,29912072,29912110,29912270,29912456,29912525,29912611,29912836,29912996,29913202,29913370,29913408,29913430,29913662,29935086,29935164,29935193,29935233,29935264,29935276,29935375,29935414,29935450,29935476,29935557,29935595,29935637,29935665,29935701,29935778,29935803,29935847,29935889,29935961,29935989,29936027,29936251,29937129,29937817,29937979,29938144,29938231,29938411,29938549,29938678,29938802,29939672,29939753,29939892,29940011,29940146,29940206,29940422,29940656,29940694,29940822,29940962,29941096,29941269,29941630,29942876,29943157,29976536,29976643,29976733,29976768,29976804,29976885,29976927,29976973,29977025,29977106,29977139,29977186,29977211,29977311,29977354,29977394,29977437,29977548,2997759', 'assoc_port': '29872039:29873291,29872042:29873210,29872046:29872992,29872049:29873107,29872052:29873063,29872055:29872908,29872057:29872834,29872061:29872870,29872064:29872745,29872068:29872680,29872070:29872604,29872073:29872493,29872075:29872569,29872077:29872533,29872079:29872641,29872080:29872298,29872081:29872362,29872082:29872180,29872083:29872097,29872084:29872401,29872085:29872256,29872086:29872148,29873350:29873513,29910028:29913662,29910033:29913408,29910036:29913370,29910040:29913202,29910044:29910348,29910047:29912996,29910052:29912611,29910056:29912836,29910074:29912525,29910076:29912270,29910079:29912456,29910082:29912110,29910084:29912072,29910087:29911722,29910089:29910497,29910091:29911626,29910105:29911677,29910119:29911163,29910121:29911251,29910123:29911087,29910124:29910917,29910125:29910658,29910126:29910947,29912891:29913430,29934985:29935961,29934988:29936251,29934992:29936027,29934994:29935989,29934996:29935889,29934997:29935665,29934999:29935847,29935000:29935637,29935002:29935557,29935004:2993559', 'assoc_mat': '29872039:pet_clair:4230:29873291,29872042:pet_clair:4230:29873210,29872046:pet_clair:4230:29872992,29872049:pet_clair:4230:29873107,29872052:pet_clair:4230:29873063,29872055:pet_clair:4230:29872908,29872057:pet_clair:4230:29872834,29872061:pet_clair:4230:29872870,29872064:pet_clair:4230:29872745,29872068:pet_clair:4230:29872680,29872070:pet_clair:4230:29872604,29872073:pet_clair:4230:29872493,29872075:pet_clair:4230:29872569,29872077:pet_clair:4230:29872533,29872079:pet_clair:4230:29872641,29872080:pet_clair:4230:29872298,29872081:pet_clair:4230:29872362,29872082:pet_clair:4230:29872180,29872083:pet_clair:4230:29872097,29872084:pet_clair:4230:29872401,29872085:pet_clair:4230:29872256,29872086:pet_clair:4230:29872148,29873350:pet_clair:4230:29873513,29910028:pet_clair:4230:29913662,29910033:pet_clair:4230:29913408,29910036:pet_clair:4230:29913370,29910040:pet_clair:4230:29913202,29910044:pet_clair:4230:29910348,29910047:pet_clair:4230:29912996,29910052:pet_clair:4230:29912611,29910056:pet_clair:4230:29912836,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006464944443794383, 'nb_photo': 2669, 'list_port_cont': '29872144,29872186,29872259,29872296,29872406,29872534,29872561,29872837,29872873,29872916,29872989,29873059,29873106,29873516,29910344,29910491,29910659,29910904,29910950,29911093,29911253,29911624,29911679,29912067,29912114,29912274,29912522,29912841,29912997,29913374,29913440,29913665,29935080,29935279,29935378,29935453,29935487,29935561,29935591,29935705,29935780,29935842,29935879,29935957,29936002,29936248,29937131,29937807,29937981,29938139,29938544,29938674,29938814,29939679,29939751,29939887,29940022,29940148,29940415,29940693,29940831,29940966,29941268,29943151,29976529,29976734,29976772,29976807,29976884,29976933,29976960,29977027,29977145,29977181,29978897,29979502,29993696,29993773,29993903,29994053,29994220,29994542,29994680,29994929,29995202,29995373,29995737,29995782,29996103,29996159,29996279,29996604,29996759,29997141,29997185,29997369,29997770,29998102,29999294,30031604,30031934,30032614,30033312,30033906,30034101,30034751,30034979,30035174,30035197,30035744,30035936,30036024,30036159,3003646', 'assoc_port': '29872046:29872989,29872049:29873106,29872052:29873059,29872055:29872916,29872057:29872837,29872061:29872873,29872075:29872561,29872077:29872534,29872080:29872296,29872082:29872186,29872084:29872406,29872085:29872259,29872086:29872144,29873350:29873516,29910028:29913665,29910036:29913374,29910044:29910344,29910047:29912997,29910056:29912841,29910074:29912522,29910076:29912274,29910082:29912114,29910084:29912067,29910089:29910491,29910091:29911624,29910105:29911679,29910121:29911253,29910123:29911093,29910124:29910904,29910125:29910659,29910126:29910950,29912891:29913440,29934985:29935957,29934988:29936248,29934994:29936002,29934996:29935879,29934999:29935842,29935002:29935561,29935004:29935591,29935005:29935780,29935008:29935705,29935010:29935487,29935018:29935080,29935019:29935378,29935021:29935453,29935023:29935279,29936859:29937131,29937690:29937807,29937892:29937981,29938052:29938139,29938455:29938544,29938589:29938674,29938720:29938814,29939587:29939751,29939588:29939679,29939797:29939887,29939926:2994002', 'assoc_mat': '29872046:pet_fonce:4230:29872989,29872049:pet_fonce:4230:29873106,29872052:pet_fonce:4230:29873059,29872055:pet_fonce:4230:29872916,29872057:pet_fonce:4230:29872837,29872061:pet_fonce:4230:29872873,29872075:pet_fonce:4230:29872561,29872077:pet_fonce:4230:29872534,29872080:pet_fonce:4230:29872296,29872082:pet_fonce:4230:29872186,29872084:pet_fonce:4230:29872406,29872085:pet_fonce:4230:29872259,29872086:pet_fonce:4230:29872144,29873350:pet_fonce:4230:29873516,29910028:pet_fonce:4230:29913665,29910036:pet_fonce:4230:29913374,29910044:pet_fonce:4230:29910344,29910047:pet_fonce:4230:29912997,29910056:pet_fonce:4230:29912841,29910074:pet_fonce:4230:29912522,29910076:pet_fonce:4230:29912274,29910082:pet_fonce:4230:29912114,29910084:pet_fonce:4230:29912067,29910089:pet_fonce:4230:29910491,29910091:pet_fonce:4230:29911624,29910105:pet_fonce:4230:29911679,29910121:pet_fonce:4230:29911253,29910123:pet_fonce:4230:29911093,29910124:pet_fonce:4230:29910904,29910125:pet_fonce:4230:29910659,29910126:pet_fonce:4230:29910950,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(2835561,2842688,2847229,2847813,2853847,2860820,2867737,2872228,2873661,2874682,2875163,2876305,2877691,2879027,2880250,2881433,2882502,2883061,2884127,2885206,2885915,2886690,2887650,2888786,2889142,2890532,2891699,2892852,2894244,2895552,2896707)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148093, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872106,29872135,29872182,29872254,29872297,29872370,29872396,29872479,29872524,29872564,29872606,29872628,29872673,29872746,29872828,29872867,29872910,29872994,29873054,29873092,29873217,29873289,29873520,29910339,29910512,29910644,29910903,29910951,29911092,29911162,29911247,29911628,29911671,29911730,29912070,29912103,29912271,29912449,29912510,29912614,29912829,29912995,29913203,29913357,29913396,29913415,29913655,29935090,29935161,29935196,29935236,29935258,29935280,29935379,29935417,29935437,29935489,29935564,29935586,29935629,29935673,29935694,29935771,29935813,29935836,29935887,29935962,29935991,29936003,29936254,29937133,29937815,29937975,29938128,29938236,29938396,29938541,29938677,29938798,29939667,29939752,29939886,29940019,29940149,29940213,29940419,29940634,29940688,29940823,29940967,29941090,29941253,29941615,29942865,29943159,29976537,29976641,29976721,29976771,29976796,29976883,29976936,29976971,29977012,29977099,29977140,29977171,29977212,29977302,29977346,29977380,29977431,29977549,2997758 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148094, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872104,29872151,29872188,29872258,29872287,29872366,29872408,29872491,29872535,29872560,29872605,29872642,29872682,29872754,29872830,29872865,29872914,29872995,29873062,29873102,29873202,29873278,29873514,29910346,29910509,29910660,29910912,29910956,29911086,29911158,29911250,29911631,29911674,29911733,29912069,29912112,29912267,29912453,29912519,29912613,29912838,29913002,29913211,29913368,29913405,29913438,29913659,29935088,29935163,29935197,29935232,29935269,29935288,29935365,29935412,29935448,29935482,29935560,29935598,29935621,29935663,29935704,29935773,29935817,29935853,29935882,29935958,29936001,29936031,29936247,29937130,29937810,29937986,29938137,29938241,29938409,29938534,29938668,29938815,29939681,29939741,29939890,29940021,29940142,29940208,29940420,29940654,29940695,29940826,29940959,29941089,29941264,29941629,29942874,29943156,29976535,29976640,29976731,29976767,29976800,29976881,29976929,29976961,29977029,29977105,29977149,29977187,29977220,29977308,29977355,29977396,29977425,29977550,2997759 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148095, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872102,29872150,29872183,29872261,29872285,29872373,29872405,29872487,29872572,29872639,29872826,29872876,29872909,29872986,29873066,29873094,29873215,29873286,29873504,29910336,29910510,29910946,29911084,29911150,29911255,29911618,29911663,29911729,29912068,29912109,29912272,29912461,29912521,29912603,29912835,29912993,29913209,29913362,29913410,29913420,29913666,29935150,29935228,29935267,29935410,29935439,29935480,29935549,29935599,29935696,29935770,29935814,29935850,29935885,29935956,29935988,29936253,29937132,29937978,29938135,29938402,29938547,29938681,29938812,29939676,29939746,29939876,29940010,29940147,29940211,29940418,29940644,29940698,29940821,29940956,29941105,29941254,29941631,29942860,29943146,29976759,29976801,29976880,29976932,29976959,29977015,29977142,29977183,29977213,29977303,29977438,29977551,29977583,29977744,29977788,29993686,29993758,29993914,29994059,29994203,29994539,29997172,29997642,29999292,30031608,30031942,30032617,30033310,30033893,30034104,30034736,30034974,30035163,3003520 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148096, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872108,29872146,29872181,29872252,29872288,29872369,29872409,29872481,29872532,29872568,29872608,29872640,29872677,29872760,29872833,29872875,29872907,29872988,29873060,29873101,29873213,29873280,29873508,29910350,29910503,29910656,29910913,29910955,29911082,29911165,29911257,29911625,29911673,29911726,29912076,29912116,29912277,29912457,29912524,29912607,29912834,29913000,29913195,29913371,29913401,29913434,29913667,29935082,29935152,29935195,29935224,29935271,29935285,29935376,29935408,29935451,29935474,29935553,29935601,29935636,29935671,29935703,29935781,29935810,29935849,29935881,29935953,29935995,29936029,29936255,29937134,29937814,29937982,29938145,29938239,29938406,29938545,29938680,29938811,29939673,29939745,29939878,29940023,29940154,29940217,29940421,29940638,29940697,29940830,29940964,29941102,29941270,29941622,29942867,29943153,29976532,29976630,29976729,29976769,29976798,29976876,29976934,29976969,29977020,29977110,29977147,29977177,29977222,29977315,29977351,29977387,29977439,29977546,2997759 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148098, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872103,29872149,29872185,29872257,29872299,29872372,29872529,29872570,29872600,29872643,29872679,29872762,29872839,29872877,29872912,29872990,29873068,29873104,29873214,29873287,29873511,29910343,29910493,29910650,29910914,29910945,29911091,29911166,29911248,29911619,29911678,29911727,29912075,29912117,29912275,29912464,29912523,29912615,29912833,29912994,29913200,29913373,29913411,29913436,29913660,29935083,29935160,29935194,29935227,29935266,29935281,29935372,29935416,29935452,29935484,29935563,29935592,29935632,29935667,29935708,29935777,29935809,29935839,29935880,29935955,29936000,29936009,29936246,29937122,29937813,29937974,29938141,29938235,29938412,29938543,29938671,29938804,29939680,29939750,29939891,29940020,29940153,29940216,29940424,29940660,29940699,29940952,29941099,29941267,29942870,29943152,29976527,29976635,29976726,29976764,29976806,29976872,29976935,29976972,29977021,29977148,29977184,29977316,29977344,29977430,29977542,29977747,29978894,29979501,29993926,29994047,29994215,29994545,2999467 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148099, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872097,29872148,29872180,29872256,29872298,29872362,29872401,29872493,29872533,29872569,29872604,29872641,29872680,29872745,29872834,29872870,29872908,29872992,29873063,29873107,29873210,29873291,29873513,29910348,29910497,29910658,29910917,29910947,29911087,29911163,29911251,29911626,29911677,29911722,29912072,29912110,29912270,29912456,29912525,29912611,29912836,29912996,29913202,29913370,29913408,29913430,29913662,29935086,29935164,29935193,29935233,29935264,29935276,29935375,29935414,29935450,29935476,29935557,29935595,29935637,29935665,29935701,29935778,29935803,29935847,29935889,29935961,29935989,29936027,29936251,29937129,29937817,29937979,29938144,29938231,29938411,29938549,29938678,29938802,29939672,29939753,29939892,29940011,29940146,29940206,29940422,29940656,29940694,29940822,29940962,29941096,29941269,29941630,29942876,29943157,29976536,29976643,29976733,29976768,29976804,29976885,29976927,29976973,29977025,29977106,29977139,29977186,29977211,29977311,29977354,29977394,29977437,29977548,2997759 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30148100, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29872144,29872186,29872259,29872296,29872406,29872534,29872561,29872837,29872873,29872916,29872989,29873059,29873106,29873516,29910344,29910491,29910659,29910904,29910950,29911093,29911253,29911624,29911679,29912067,29912114,29912274,29912522,29912841,29912997,29913374,29913440,29913665,29935080,29935279,29935378,29935453,29935487,29935561,29935591,29935705,29935780,29935842,29935879,29935957,29936002,29936248,29937131,29937807,29937981,29938139,29938544,29938674,29938814,29939679,29939751,29939887,29940022,29940148,29940415,29940693,29940831,29940966,29941268,29943151,29976529,29976734,29976772,29976807,29976884,29976933,29976960,29977027,29977145,29977181,29978897,29979502,29993696,29993773,29993903,29994053,29994220,29994542,29994680,29994929,29995202,29995373,29995737,29995782,29996103,29996159,29996279,29996604,29996759,29997141,29997185,29997369,29997770,29998102,29999294,30031604,30031934,30032614,30033312,30033906,30034101,30034751,30034979,30035174,30035197,30035744,30035936,30036024,30036159,3003646 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30148093,30148094,30148095,30148096,30148098,30148099,30148100?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce 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 >='2026-01-01' and date <= '2026-01-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2435,),), 'unwanted_material_monthly_percentage': ((0.5673829812480208,),), 'material_repartition': (('incineration', 2429),), 'material_dict': {'incineration': 2429}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.5769880847524937, 3), (datetime.date(2026, 1, 2), 0.5528819552572392, 3), (datetime.date(2026, 1, 3), 0.6130399324201989, 3), (datetime.date(2026, 1, 4), 0.6725045713310018, 3), (datetime.date(2026, 1, 5), 0.6628053230645524, 4), (datetime.date(2026, 1, 6), 0.6008156744464253, 3), (datetime.date(2026, 1, 7), 0.6557692548311543, 4), (datetime.date(2026, 1, 8), 0.5541133735696154, 4), (datetime.date(2026, 1, 9), 0.5495990401364065, 4), (datetime.date(2026, 1, 10), 0.6309876898298268, 3), (datetime.date(2026, 1, 11), 0.6318164733300079, 3), (datetime.date(2026, 1, 12), 0.6479264144298684, 3), (datetime.date(2026, 1, 13), 0.6050677736398479, 2), (datetime.date(2026, 1, 14), 0.5271101125931342, 4), (datetime.date(2026, 1, 15), 0.5318810155382768, 4), (datetime.date(2026, 1, 16), 0.5548426698956006, 4), (datetime.date(2026, 1, 17), 0.5334112854077824, 3), (datetime.date(2026, 1, 18), 0.5608886820963794, 4), (datetime.date(2026, 1, 19), 0.6368690052007396, 3), (datetime.date(2026, 1, 20), 0.6209843268302115, 4), (datetime.date(2026, 1, 21), 0.5732864394191755, 3), (datetime.date(2026, 1, 22), 0.49632913732835804, 4), (datetime.date(2026, 1, 23), 0.4440050991288463, 4), (datetime.date(2026, 1, 24), 0.4228264877757532, 4), (datetime.date(2026, 1, 25), 0.5400789101161776, 4), (datetime.date(2026, 1, 26), 0.5951262506186459, 4), (datetime.date(2026, 1, 27), 0.5031656274160088, 4), (datetime.date(2026, 1, 28), 0.5305029766339596, 4), (datetime.date(2026, 1, 29), 0.548216496227061, 2), (datetime.date(2026, 1, 30), 0.5255878388432254, 3), (datetime.date(2026, 1, 31), 0.4885725841212415, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.5769880847524937, 3), (datetime.date(2026, 1, 2), 0.5528819552572392, 3), (datetime.date(2026, 1, 3), 0.6130399324201989, 3), (datetime.date(2026, 1, 4), 0.6725045713310018, 3), (datetime.date(2026, 1, 5), 0.6628053230645524, 4), (datetime.date(2026, 1, 6), 0.6008156744464253, 3), (datetime.date(2026, 1, 7), 0.6557692548311543, 4), (datetime.date(2026, 1, 8), 0.5541133735696154, 4), (datetime.date(2026, 1, 9), 0.5495990401364065, 4), (datetime.date(2026, 1, 10), 0.6309876898298268, 3), (datetime.date(2026, 1, 11), 0.6318164733300079, 3), (datetime.date(2026, 1, 12), 0.6479264144298684, 3), (datetime.date(2026, 1, 13), 0.6050677736398479, 2), (datetime.date(2026, 1, 14), 0.5271101125931342, 4), (datetime.date(2026, 1, 15), 0.5318810155382768, 4), (datetime.date(2026, 1, 16), 0.5548426698956006, 4), (datetime.date(2026, 1, 17), 0.5334112854077824, 3), (datetime.date(2026, 1, 18), 0.5608886820963794, 4), (datetime.date(2026, 1, 19), 0.6368690052007396, 3), (datetime.date(2026, 1, 20), 0.6209843268302115, 4), (datetime.date(2026, 1, 21), 0.5732864394191755, 3), (datetime.date(2026, 1, 22), 0.49632913732835804, 4), (datetime.date(2026, 1, 23), 0.4440050991288463, 4), (datetime.date(2026, 1, 24), 0.4228264877757532, 4), (datetime.date(2026, 1, 25), 0.5400789101161776, 4), (datetime.date(2026, 1, 26), 0.5951262506186459, 4), (datetime.date(2026, 1, 27), 0.5031656274160088, 4), (datetime.date(2026, 1, 28), 0.5305029766339596, 4), (datetime.date(2026, 1, 29), 0.548216496227061, 2), (datetime.date(2026, 1, 30), 0.5255878388432254, 3), (datetime.date(2026, 1, 31), 0.4885725841212415, 3))}, 'quality_array': [['-8.360159122215908', '01012026'], ['-8.43894677761763', '02012026'], ['-8.502918992890685', '03012026'], ['-8.341010073005117', '04012026'], ['-7.443304729378126', '05012026'], ['-6.658334921201998', '06012026'], ['-7.456296870284379', '07012026'], ['-8.121014029427421', '08012026'], ['-8.634960349501528', '09012026'], ['-8.541503074440186', '10012026'], ['-8.398630154678344', '11012026'], ['-8.013709378635667', '12012026'], ['-7.262945295394159', '13012026'], ['-7.414499675320423', '14012026'], ['-8.056872186400758', '15012026'], ['-8.30756001865134', '16012026'], ['-8.155845329454928', '17012026'], ['-8.219579207584207', '18012026'], ['-7.443052829674207', '19012026'], ['-7.3229124595377355', '20012026'], ['-7.904166671183346', '21012026'], ['-8.183513364156195', '22012026'], ['-7.981487085691583', '23012026'], ['-8.159562960725042', '24012026'], ['-8.116999291755736', '25012026'], ['-7.7274319955653406', '26012026'], ['-7.5043242241701', '27012026'], ['-7.960843163561165', '28012026'], ['-8.300351547356954', '29012026'], ['-8.318892254333532', '30012026'], ['-8.211603830580549', '31012026']], 'number_of_batch': ((735,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020532739699440777, 'nb_photo': 29757, 'list_port_cont': '29872106,29872135,29872182,29872254,29872297,29872370,29872396,29872479,29872524,29872564,29872606,29872628,29872673,29872746,29872828,29872867,29872910,29872994,29873054,29873092,29873217,29873289,29873520,29910339,29910512,29910644,29910903,29910951,29911092,29911162,29911247,29911628,29911671,29911730,29912070,29912103,29912271,29912449,29912510,29912614,29912829,29912995,29913203,29913357,29913396,29913415,29913655,29935090,29935161,29935196,29935236,29935258,29935280,29935379,29935417,29935437,29935489,29935564,29935586,29935629,29935673,29935694,29935771,29935813,29935836,29935887,29935962,29935991,29936003,29936254,29937133,29937815,29937975,29938128,29938236,29938396,29938541,29938677,29938798,29939667,29939752,29939886,29940019,29940149,29940213,29940419,29940634,29940688,29940823,29940967,29941090,29941253,29941615,29942865,29943159,29976537,29976641,29976721,29976771,29976796,29976883,29976936,29976971,29977012,29977099,29977140,29977171,29977212,29977302,29977346,29977380,29977431,29977549,2997758', 'assoc_port': '29872039:29873289,29872042:29873217,29872046:29872994,29872049:29873092,29872052:29873054,29872055:29872910,29872057:29872828,29872061:29872867,29872064:29872746,29872068:29872673,29872070:29872606,29872073:29872479,29872075:29872564,29872077:29872524,29872079:29872628,29872080:29872297,29872081:29872370,29872082:29872182,29872083:29872106,29872084:29872396,29872085:29872254,29872086:29872135,29873350:29873520,29910028:29913655,29910033:29913396,29910036:29913357,29910040:29913203,29910044:29910339,29910047:29912995,29910052:29912614,29910056:29912829,29910074:29912510,29910076:29912271,29910079:29912449,29910082:29912103,29910084:29912070,29910087:29911730,29910089:29910512,29910091:29911628,29910105:29911671,29910119:29911162,29910121:29911247,29910123:29911092,29910124:29910903,29910125:29910644,29910126:29910951,29912891:29913415,29934985:29935962,29934988:29936254,29934992:29936003,29934994:29935991,29934996:29935887,29934997:29935673,29934999:29935836,29935000:29935629,29935002:29935564,29935004:2993558', 'assoc_mat': '29872039:autre:4230:29873289,29872042:autre:4230:29873217,29872046:autre:4230:29872994,29872049:autre:4230:29873092,29872052:autre:4230:29873054,29872055:autre:4230:29872910,29872057:autre:4230:29872828,29872061:autre:4230:29872867,29872064:autre:4230:29872746,29872068:autre:4230:29872673,29872070:autre:4230:29872606,29872073:autre:4230:29872479,29872075:autre:4230:29872564,29872077:autre:4230:29872524,29872079:autre:4230:29872628,29872080:autre:4230:29872297,29872081:autre:4230:29872370,29872082:autre:4230:29872182,29872083:autre:4230:29872106,29872084:autre:4230:29872396,29872085:autre:4230:29872254,29872086:autre:4230:29872135,29873350:autre:4230:29873520,29910028:autre:4230:29913655,29910033:autre:4230:29913396,29910036:autre:4230:29913357,29910040:autre:4230:29913203,29910044:autre:4230:29910339,29910047:autre:4230:29912995,29910052:autre:4230:29912614,29910056:autre:4230:29912829,29910074:autre:4230:29912510,29910076:autre:4230:29912271,29910079:autre:4230:29912449,29910082:autre:4230:29912103,29910084:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.101180400304597, 'nb_photo': 184930, 'list_port_cont': '29872104,29872151,29872188,29872258,29872287,29872366,29872408,29872491,29872535,29872560,29872605,29872642,29872682,29872754,29872830,29872865,29872914,29872995,29873062,29873102,29873202,29873278,29873514,29910346,29910509,29910660,29910912,29910956,29911086,29911158,29911250,29911631,29911674,29911733,29912069,29912112,29912267,29912453,29912519,29912613,29912838,29913002,29913211,29913368,29913405,29913438,29913659,29935088,29935163,29935197,29935232,29935269,29935288,29935365,29935412,29935448,29935482,29935560,29935598,29935621,29935663,29935704,29935773,29935817,29935853,29935882,29935958,29936001,29936031,29936247,29937130,29937810,29937986,29938137,29938241,29938409,29938534,29938668,29938815,29939681,29939741,29939890,29940021,29940142,29940208,29940420,29940654,29940695,29940826,29940959,29941089,29941264,29941629,29942874,29943156,29976535,29976640,29976731,29976767,29976800,29976881,29976929,29976961,29977029,29977105,29977149,29977187,29977220,29977308,29977355,29977396,29977425,29977550,2997759', 'assoc_port': '29872039:29873278,29872042:29873202,29872046:29872995,29872049:29873102,29872052:29873062,29872055:29872914,29872057:29872830,29872061:29872865,29872064:29872754,29872068:29872682,29872070:29872605,29872073:29872491,29872075:29872560,29872077:29872535,29872079:29872642,29872080:29872287,29872081:29872366,29872082:29872188,29872083:29872104,29872084:29872408,29872085:29872258,29872086:29872151,29873350:29873514,29910028:29913659,29910033:29913405,29910036:29913368,29910040:29913211,29910044:29910346,29910047:29913002,29910052:29912613,29910056:29912838,29910074:29912519,29910076:29912267,29910079:29912453,29910082:29912112,29910084:29912069,29910087:29911733,29910089:29910509,29910091:29911631,29910105:29911674,29910119:29911158,29910121:29911250,29910123:29911086,29910124:29910912,29910125:29910660,29910126:29910956,29912891:29913438,29934985:29935958,29934988:29936247,29934992:29936031,29934994:29936001,29934996:29935882,29934997:29935663,29934999:29935853,29935000:29935621,29935002:29935560,29935004:2993559', 'assoc_mat': '29872039:carton:4230:29873278,29872042:carton:4230:29873202,29872046:carton:4230:29872995,29872049:carton:4230:29873102,29872052:carton:4230:29873062,29872055:carton:4230:29872914,29872057:carton:4230:29872830,29872061:carton:4230:29872865,29872064:carton:4230:29872754,29872068:carton:4230:29872682,29872070:carton:4230:29872605,29872073:carton:4230:29872491,29872075:carton:4230:29872560,29872077:carton:4230:29872535,29872079:carton:4230:29872642,29872080:carton:4230:29872287,29872081:carton:4230:29872366,29872082:carton:4230:29872188,29872083:carton:4230:29872104,29872084:carton:4230:29872408,29872085:carton:4230:29872258,29872086:carton:4230:29872151,29873350:carton:4230:29873514,29910028:carton:4230:29913659,29910033:carton:4230:29913405,29910036:carton:4230:29913368,29910040:carton:4230:29913211,29910044:carton:4230:29910346,29910047:carton:4230:29913002,29910052:carton:4230:29912613,29910056:carton:4230:29912838,29910074:carton:4230:29912519,29910076:carton:4230:29912267,29910079:carton:4230:29912453,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016569065923495753, 'nb_photo': 2598, 'list_port_cont': '29872102,29872150,29872183,29872261,29872285,29872373,29872405,29872487,29872572,29872639,29872826,29872876,29872909,29872986,29873066,29873094,29873215,29873286,29873504,29910336,29910510,29910946,29911084,29911150,29911255,29911618,29911663,29911729,29912068,29912109,29912272,29912461,29912521,29912603,29912835,29912993,29913209,29913362,29913410,29913420,29913666,29935150,29935228,29935267,29935410,29935439,29935480,29935549,29935599,29935696,29935770,29935814,29935850,29935885,29935956,29935988,29936253,29937132,29937978,29938135,29938402,29938547,29938681,29938812,29939676,29939746,29939876,29940010,29940147,29940211,29940418,29940644,29940698,29940821,29940956,29941105,29941254,29941631,29942860,29943146,29976759,29976801,29976880,29976932,29976959,29977015,29977142,29977183,29977213,29977303,29977438,29977551,29977583,29977744,29977788,29993686,29993758,29993914,29994059,29994203,29994539,29997172,29997642,29999292,30031608,30031942,30032617,30033310,30033893,30034104,30034736,30034974,30035163,3003520', 'assoc_port': '29872039:29873286,29872042:29873215,29872046:29872986,29872049:29873094,29872052:29873066,29872055:29872909,29872057:29872826,29872061:29872876,29872073:29872487,29872075:29872572,29872079:29872639,29872080:29872285,29872081:29872373,29872082:29872183,29872083:29872102,29872084:29872405,29872085:29872261,29872086:29872150,29873350:29873504,29910028:29913666,29910033:29913410,29910036:29913362,29910040:29913209,29910044:29910336,29910047:29912993,29910052:29912603,29910056:29912835,29910074:29912521,29910076:29912272,29910079:29912461,29910082:29912109,29910084:29912068,29910087:29911729,29910089:29910510,29910091:29911618,29910105:29911663,29910119:29911150,29910121:29911255,29910123:29911084,29910126:29910946,29912891:29913420,29934985:29935956,29934988:29936253,29934994:29935988,29934996:29935885,29934999:29935850,29935002:29935549,29935004:29935599,29935005:29935770,29935007:29935814,29935008:29935696,29935010:29935480,29935012:29935228,29935013:29935410,29935016:29935267,29935021:29935439,29935024:2993515', 'assoc_mat': '29872039:metal:4230:29873286,29872042:metal:4230:29873215,29872046:metal:4230:29872986,29872049:metal:4230:29873094,29872052:metal:4230:29873066,29872055:metal:4230:29872909,29872057:metal:4230:29872826,29872061:metal:4230:29872876,29872073:metal:4230:29872487,29872075:metal:4230:29872572,29872079:metal:4230:29872639,29872080:metal:4230:29872285,29872081:metal:4230:29872373,29872082:metal:4230:29872183,29872083:metal:4230:29872102,29872084:metal:4230:29872405,29872085:metal:4230:29872261,29872086:metal:4230:29872150,29873350:metal:4230:29873504,29910028:metal:4230:29913666,29910033:metal:4230:29913410,29910036:metal:4230:29913362,29910040:metal:4230:29913209,29910044:metal:4230:29910336,29910047:metal:4230:29912993,29910052:metal:4230:29912603,29910056:metal:4230:29912835,29910074:metal:4230:29912521,29910076:metal:4230:29912272,29910079:metal:4230:29912461,29910082:metal:4230:29912109,29910084:metal:4230:29912068,29910087:metal:4230:29911729,29910089:metal:4230:29910510,29910091:metal:4230:29911618,29910105:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3030832964132918, 'nb_photo': 551263, 'list_port_cont': '29872108,29872146,29872181,29872252,29872288,29872369,29872409,29872481,29872532,29872568,29872608,29872640,29872677,29872760,29872833,29872875,29872907,29872988,29873060,29873101,29873213,29873280,29873508,29910350,29910503,29910656,29910913,29910955,29911082,29911165,29911257,29911625,29911673,29911726,29912076,29912116,29912277,29912457,29912524,29912607,29912834,29913000,29913195,29913371,29913401,29913434,29913667,29935082,29935152,29935195,29935224,29935271,29935285,29935376,29935408,29935451,29935474,29935553,29935601,29935636,29935671,29935703,29935781,29935810,29935849,29935881,29935953,29935995,29936029,29936255,29937134,29937814,29937982,29938145,29938239,29938406,29938545,29938680,29938811,29939673,29939745,29939878,29940023,29940154,29940217,29940421,29940638,29940697,29940830,29940964,29941102,29941270,29941622,29942867,29943153,29976532,29976630,29976729,29976769,29976798,29976876,29976934,29976969,29977020,29977110,29977147,29977177,29977222,29977315,29977351,29977387,29977439,29977546,2997759', 'assoc_port': '29872039:29873280,29872042:29873213,29872046:29872988,29872049:29873101,29872052:29873060,29872055:29872907,29872057:29872833,29872061:29872875,29872064:29872760,29872068:29872677,29872070:29872608,29872073:29872481,29872075:29872568,29872077:29872532,29872079:29872640,29872080:29872288,29872081:29872369,29872082:29872181,29872083:29872108,29872084:29872409,29872085:29872252,29872086:29872146,29873350:29873508,29910028:29913667,29910033:29913401,29910036:29913371,29910040:29913195,29910044:29910350,29910047:29913000,29910052:29912607,29910056:29912834,29910074:29912524,29910076:29912277,29910079:29912457,29910082:29912116,29910084:29912076,29910087:29911726,29910089:29910503,29910091:29911625,29910105:29911673,29910119:29911165,29910121:29911257,29910123:29911082,29910124:29910913,29910125:29910656,29910126:29910955,29912891:29913434,29934985:29935953,29934988:29936255,29934992:29936029,29934994:29935995,29934996:29935881,29934997:29935671,29934999:29935849,29935000:29935636,29935002:29935553,29935004:2993560', 'assoc_mat': '29872039:papier:4230:29873280,29872042:papier:4230:29873213,29872046:papier:4230:29872988,29872049:papier:4230:29873101,29872052:papier:4230:29873060,29872055:papier:4230:29872907,29872057:papier:4230:29872833,29872061:papier:4230:29872875,29872064:papier:4230:29872760,29872068:papier:4230:29872677,29872070:papier:4230:29872608,29872073:papier:4230:29872481,29872075:papier:4230:29872568,29872077:papier:4230:29872532,29872079:papier:4230:29872640,29872080:papier:4230:29872288,29872081:papier:4230:29872369,29872082:papier:4230:29872181,29872083:papier:4230:29872108,29872084:papier:4230:29872409,29872085:papier:4230:29872252,29872086:papier:4230:29872146,29873350:papier:4230:29873508,29910028:papier:4230:29913667,29910033:papier:4230:29913401,29910036:papier:4230:29913371,29910040:papier:4230:29913195,29910044:papier:4230:29910350,29910047:papier:4230:29913000,29910052:papier:4230:29912607,29910056:papier:4230:29912834,29910074:papier:4230:29912524,29910076:papier:4230:29912277,29910079:papier:4230:29912457,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007240459651323948, 'nb_photo': 8040, 'list_port_cont': '29872103,29872149,29872185,29872257,29872299,29872372,29872529,29872570,29872600,29872643,29872679,29872762,29872839,29872877,29872912,29872990,29873068,29873104,29873214,29873287,29873511,29910343,29910493,29910650,29910914,29910945,29911091,29911166,29911248,29911619,29911678,29911727,29912075,29912117,29912275,29912464,29912523,29912615,29912833,29912994,29913200,29913373,29913411,29913436,29913660,29935083,29935160,29935194,29935227,29935266,29935281,29935372,29935416,29935452,29935484,29935563,29935592,29935632,29935667,29935708,29935777,29935809,29935839,29935880,29935955,29936000,29936009,29936246,29937122,29937813,29937974,29938141,29938235,29938412,29938543,29938671,29938804,29939680,29939750,29939891,29940020,29940153,29940216,29940424,29940660,29940699,29940952,29941099,29941267,29942870,29943152,29976527,29976635,29976726,29976764,29976806,29976872,29976935,29976972,29977021,29977148,29977184,29977316,29977344,29977430,29977542,29977747,29978894,29979501,29993926,29994047,29994215,29994545,2999467', 'assoc_port': '29872039:29873287,29872042:29873214,29872046:29872990,29872049:29873104,29872052:29873068,29872055:29872912,29872057:29872839,29872061:29872877,29872064:29872762,29872068:29872679,29872070:29872600,29872075:29872570,29872077:29872529,29872079:29872643,29872080:29872299,29872081:29872372,29872082:29872185,29872083:29872103,29872085:29872257,29872086:29872149,29873350:29873511,29910028:29913660,29910033:29913411,29910036:29913373,29910040:29913200,29910044:29910343,29910047:29912994,29910052:29912615,29910056:29912833,29910074:29912523,29910076:29912275,29910079:29912464,29910082:29912117,29910084:29912075,29910087:29911727,29910089:29910493,29910091:29911619,29910105:29911678,29910119:29911166,29910121:29911248,29910123:29911091,29910124:29910914,29910125:29910650,29910126:29910945,29912891:29913436,29934985:29935955,29934988:29936246,29934992:29936009,29934994:29936000,29934996:29935880,29934997:29935667,29934999:29935839,29935000:29935632,29935002:29935563,29935004:29935592,29935005:29935777,29935007:2993580', 'assoc_mat': '29872039:pehd:4230:29873287,29872042:pehd:4230:29873214,29872046:pehd:4230:29872990,29872049:pehd:4230:29873104,29872052:pehd:4230:29873068,29872055:pehd:4230:29872912,29872057:pehd:4230:29872839,29872061:pehd:4230:29872877,29872064:pehd:4230:29872762,29872068:pehd:4230:29872679,29872070:pehd:4230:29872600,29872075:pehd:4230:29872570,29872077:pehd:4230:29872529,29872079:pehd:4230:29872643,29872080:pehd:4230:29872299,29872081:pehd:4230:29872372,29872082:pehd:4230:29872185,29872083:pehd:4230:29872103,29872085:pehd:4230:29872257,29872086:pehd:4230:29872149,29873350:pehd:4230:29873511,29910028:pehd:4230:29913660,29910033:pehd:4230:29913411,29910036:pehd:4230:29913373,29910040:pehd:4230:29913200,29910044:pehd:4230:29910343,29910047:pehd:4230:29912994,29910052:pehd:4230:29912615,29910056:pehd:4230:29912833,29910074:pehd:4230:29912523,29910076:pehd:4230:29912275,29910079:pehd:4230:29912464,29910082:pehd:4230:29912117,29910084:pehd:4230:29912075,29910087:pehd:4230:29911727,29910089:pehd:4230:29910493,29910091:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017619377937600246, 'nb_photo': 45313, 'list_port_cont': '29872097,29872148,29872180,29872256,29872298,29872362,29872401,29872493,29872533,29872569,29872604,29872641,29872680,29872745,29872834,29872870,29872908,29872992,29873063,29873107,29873210,29873291,29873513,29910348,29910497,29910658,29910917,29910947,29911087,29911163,29911251,29911626,29911677,29911722,29912072,29912110,29912270,29912456,29912525,29912611,29912836,29912996,29913202,29913370,29913408,29913430,29913662,29935086,29935164,29935193,29935233,29935264,29935276,29935375,29935414,29935450,29935476,29935557,29935595,29935637,29935665,29935701,29935778,29935803,29935847,29935889,29935961,29935989,29936027,29936251,29937129,29937817,29937979,29938144,29938231,29938411,29938549,29938678,29938802,29939672,29939753,29939892,29940011,29940146,29940206,29940422,29940656,29940694,29940822,29940962,29941096,29941269,29941630,29942876,29943157,29976536,29976643,29976733,29976768,29976804,29976885,29976927,29976973,29977025,29977106,29977139,29977186,29977211,29977311,29977354,29977394,29977437,29977548,2997759', 'assoc_port': '29872039:29873291,29872042:29873210,29872046:29872992,29872049:29873107,29872052:29873063,29872055:29872908,29872057:29872834,29872061:29872870,29872064:29872745,29872068:29872680,29872070:29872604,29872073:29872493,29872075:29872569,29872077:29872533,29872079:29872641,29872080:29872298,29872081:29872362,29872082:29872180,29872083:29872097,29872084:29872401,29872085:29872256,29872086:29872148,29873350:29873513,29910028:29913662,29910033:29913408,29910036:29913370,29910040:29913202,29910044:29910348,29910047:29912996,29910052:29912611,29910056:29912836,29910074:29912525,29910076:29912270,29910079:29912456,29910082:29912110,29910084:29912072,29910087:29911722,29910089:29910497,29910091:29911626,29910105:29911677,29910119:29911163,29910121:29911251,29910123:29911087,29910124:29910917,29910125:29910658,29910126:29910947,29912891:29913430,29934985:29935961,29934988:29936251,29934992:29936027,29934994:29935989,29934996:29935889,29934997:29935665,29934999:29935847,29935000:29935637,29935002:29935557,29935004:2993559', 'assoc_mat': '29872039:pet_clair:4230:29873291,29872042:pet_clair:4230:29873210,29872046:pet_clair:4230:29872992,29872049:pet_clair:4230:29873107,29872052:pet_clair:4230:29873063,29872055:pet_clair:4230:29872908,29872057:pet_clair:4230:29872834,29872061:pet_clair:4230:29872870,29872064:pet_clair:4230:29872745,29872068:pet_clair:4230:29872680,29872070:pet_clair:4230:29872604,29872073:pet_clair:4230:29872493,29872075:pet_clair:4230:29872569,29872077:pet_clair:4230:29872533,29872079:pet_clair:4230:29872641,29872080:pet_clair:4230:29872298,29872081:pet_clair:4230:29872362,29872082:pet_clair:4230:29872180,29872083:pet_clair:4230:29872097,29872084:pet_clair:4230:29872401,29872085:pet_clair:4230:29872256,29872086:pet_clair:4230:29872148,29873350:pet_clair:4230:29873513,29910028:pet_clair:4230:29913662,29910033:pet_clair:4230:29913408,29910036:pet_clair:4230:29913370,29910040:pet_clair:4230:29913202,29910044:pet_clair:4230:29910348,29910047:pet_clair:4230:29912996,29910052:pet_clair:4230:29912611,29910056:pet_clair:4230:29912836,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006464944443794383, 'nb_photo': 2669, 'list_port_cont': '29872144,29872186,29872259,29872296,29872406,29872534,29872561,29872837,29872873,29872916,29872989,29873059,29873106,29873516,29910344,29910491,29910659,29910904,29910950,29911093,29911253,29911624,29911679,29912067,29912114,29912274,29912522,29912841,29912997,29913374,29913440,29913665,29935080,29935279,29935378,29935453,29935487,29935561,29935591,29935705,29935780,29935842,29935879,29935957,29936002,29936248,29937131,29937807,29937981,29938139,29938544,29938674,29938814,29939679,29939751,29939887,29940022,29940148,29940415,29940693,29940831,29940966,29941268,29943151,29976529,29976734,29976772,29976807,29976884,29976933,29976960,29977027,29977145,29977181,29978897,29979502,29993696,29993773,29993903,29994053,29994220,29994542,29994680,29994929,29995202,29995373,29995737,29995782,29996103,29996159,29996279,29996604,29996759,29997141,29997185,29997369,29997770,29998102,29999294,30031604,30031934,30032614,30033312,30033906,30034101,30034751,30034979,30035174,30035197,30035744,30035936,30036024,30036159,3003646', 'assoc_port': '29872046:29872989,29872049:29873106,29872052:29873059,29872055:29872916,29872057:29872837,29872061:29872873,29872075:29872561,29872077:29872534,29872080:29872296,29872082:29872186,29872084:29872406,29872085:29872259,29872086:29872144,29873350:29873516,29910028:29913665,29910036:29913374,29910044:29910344,29910047:29912997,29910056:29912841,29910074:29912522,29910076:29912274,29910082:29912114,29910084:29912067,29910089:29910491,29910091:29911624,29910105:29911679,29910121:29911253,29910123:29911093,29910124:29910904,29910125:29910659,29910126:29910950,29912891:29913440,29934985:29935957,29934988:29936248,29934994:29936002,29934996:29935879,29934999:29935842,29935002:29935561,29935004:29935591,29935005:29935780,29935008:29935705,29935010:29935487,29935018:29935080,29935019:29935378,29935021:29935453,29935023:29935279,29936859:29937131,29937690:29937807,29937892:29937981,29938052:29938139,29938455:29938544,29938589:29938674,29938720:29938814,29939587:29939751,29939588:29939679,29939797:29939887,29939926:2994002', 'assoc_mat': '29872046:pet_fonce:4230:29872989,29872049:pet_fonce:4230:29873106,29872052:pet_fonce:4230:29873059,29872055:pet_fonce:4230:29872916,29872057:pet_fonce:4230:29872837,29872061:pet_fonce:4230:29872873,29872075:pet_fonce:4230:29872561,29872077:pet_fonce:4230:29872534,29872080:pet_fonce:4230:29872296,29872082:pet_fonce:4230:29872186,29872084:pet_fonce:4230:29872406,29872085:pet_fonce:4230:29872259,29872086:pet_fonce:4230:29872144,29873350:pet_fonce:4230:29873516,29910028:pet_fonce:4230:29913665,29910036:pet_fonce:4230:29913374,29910044:pet_fonce:4230:29910344,29910047:pet_fonce:4230:29912997,29910056:pet_fonce:4230:29912841,29910074:pet_fonce:4230:29912522,29910076:pet_fonce:4230:29912274,29910082:pet_fonce:4230:29912114,29910084:pet_fonce:4230:29912067,29910089:pet_fonce:4230:29910491,29910091:pet_fonce:4230:29911624,29910105:pet_fonce:4230:29911679,29910121:pet_fonce:4230:29911253,29910123:pet_fonce:4230:29911093,29910124:pet_fonce:4230:29910904,29910125:pet_fonce:4230:29910659,29910126:pet_fonce:4230:29910950,2'}), 'main_stat': {'nb_photos': 2435}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30148093,30148094,30148095,30148096,30148098,30148099,30148100?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.5673829812480208),)]} 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': ((2435,),), 'unwanted_material_monthly_percentage': ((0.5673829812480208,),), 'material_repartition': (('incineration', 2429),), 'material_dict': {'incineration': 2429}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.5769880847524937, 3), (datetime.date(2026, 1, 2), 0.5528819552572392, 3), (datetime.date(2026, 1, 3), 0.6130399324201989, 3), (datetime.date(2026, 1, 4), 0.6725045713310018, 3), (datetime.date(2026, 1, 5), 0.6628053230645524, 4), (datetime.date(2026, 1, 6), 0.6008156744464253, 3), (datetime.date(2026, 1, 7), 0.6557692548311543, 4), (datetime.date(2026, 1, 8), 0.5541133735696154, 4), (datetime.date(2026, 1, 9), 0.5495990401364065, 4), (datetime.date(2026, 1, 10), 0.6309876898298268, 3), (datetime.date(2026, 1, 11), 0.6318164733300079, 3), (datetime.date(2026, 1, 12), 0.6479264144298684, 3), (datetime.date(2026, 1, 13), 0.6050677736398479, 2), (datetime.date(2026, 1, 14), 0.5271101125931342, 4), (datetime.date(2026, 1, 15), 0.5318810155382768, 4), (datetime.date(2026, 1, 16), 0.5548426698956006, 4), (datetime.date(2026, 1, 17), 0.5334112854077824, 3), (datetime.date(2026, 1, 18), 0.5608886820963794, 4), (datetime.date(2026, 1, 19), 0.6368690052007396, 3), (datetime.date(2026, 1, 20), 0.6209843268302115, 4), (datetime.date(2026, 1, 21), 0.5732864394191755, 3), (datetime.date(2026, 1, 22), 0.49632913732835804, 4), (datetime.date(2026, 1, 23), 0.4440050991288463, 4), (datetime.date(2026, 1, 24), 0.4228264877757532, 4), (datetime.date(2026, 1, 25), 0.5400789101161776, 4), (datetime.date(2026, 1, 26), 0.5951262506186459, 4), (datetime.date(2026, 1, 27), 0.5031656274160088, 4), (datetime.date(2026, 1, 28), 0.5305029766339596, 4), (datetime.date(2026, 1, 29), 0.548216496227061, 2), (datetime.date(2026, 1, 30), 0.5255878388432254, 3), (datetime.date(2026, 1, 31), 0.4885725841212415, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.5769880847524937, 3), (datetime.date(2026, 1, 2), 0.5528819552572392, 3), (datetime.date(2026, 1, 3), 0.6130399324201989, 3), (datetime.date(2026, 1, 4), 0.6725045713310018, 3), (datetime.date(2026, 1, 5), 0.6628053230645524, 4), (datetime.date(2026, 1, 6), 0.6008156744464253, 3), (datetime.date(2026, 1, 7), 0.6557692548311543, 4), (datetime.date(2026, 1, 8), 0.5541133735696154, 4), (datetime.date(2026, 1, 9), 0.5495990401364065, 4), (datetime.date(2026, 1, 10), 0.6309876898298268, 3), (datetime.date(2026, 1, 11), 0.6318164733300079, 3), (datetime.date(2026, 1, 12), 0.6479264144298684, 3), (datetime.date(2026, 1, 13), 0.6050677736398479, 2), (datetime.date(2026, 1, 14), 0.5271101125931342, 4), (datetime.date(2026, 1, 15), 0.5318810155382768, 4), (datetime.date(2026, 1, 16), 0.5548426698956006, 4), (datetime.date(2026, 1, 17), 0.5334112854077824, 3), (datetime.date(2026, 1, 18), 0.5608886820963794, 4), (datetime.date(2026, 1, 19), 0.6368690052007396, 3), (datetime.date(2026, 1, 20), 0.6209843268302115, 4), (datetime.date(2026, 1, 21), 0.5732864394191755, 3), (datetime.date(2026, 1, 22), 0.49632913732835804, 4), (datetime.date(2026, 1, 23), 0.4440050991288463, 4), (datetime.date(2026, 1, 24), 0.4228264877757532, 4), (datetime.date(2026, 1, 25), 0.5400789101161776, 4), (datetime.date(2026, 1, 26), 0.5951262506186459, 4), (datetime.date(2026, 1, 27), 0.5031656274160088, 4), (datetime.date(2026, 1, 28), 0.5305029766339596, 4), (datetime.date(2026, 1, 29), 0.548216496227061, 2), (datetime.date(2026, 1, 30), 0.5255878388432254, 3), (datetime.date(2026, 1, 31), 0.4885725841212415, 3))}, 'quality_array': [['-8.360159122215908', '01012026'], ['-8.43894677761763', '02012026'], ['-8.502918992890685', '03012026'], ['-8.341010073005117', '04012026'], ['-7.443304729378126', '05012026'], ['-6.658334921201998', '06012026'], ['-7.456296870284379', '07012026'], ['-8.121014029427421', '08012026'], ['-8.634960349501528', '09012026'], ['-8.541503074440186', '10012026'], ['-8.398630154678344', '11012026'], ['-8.013709378635667', '12012026'], ['-7.262945295394159', '13012026'], ['-7.414499675320423', '14012026'], ['-8.056872186400758', '15012026'], ['-8.30756001865134', '16012026'], ['-8.155845329454928', '17012026'], ['-8.219579207584207', '18012026'], ['-7.443052829674207', '19012026'], ['-7.3229124595377355', '20012026'], ['-7.904166671183346', '21012026'], ['-8.183513364156195', '22012026'], ['-7.981487085691583', '23012026'], ['-8.159562960725042', '24012026'], ['-8.116999291755736', '25012026'], ['-7.7274319955653406', '26012026'], ['-7.5043242241701', '27012026'], ['-7.960843163561165', '28012026'], ['-8.300351547356954', '29012026'], ['-8.318892254333532', '30012026'], ['-8.211603830580549', '31012026']], 'number_of_batch': ((735,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.020532739699440777, 'nb_photo': 29757, 'list_port_cont': '29872106,29872135,29872182,29872254,29872297,29872370,29872396,29872479,29872524,29872564,29872606,29872628,29872673,29872746,29872828,29872867,29872910,29872994,29873054,29873092,29873217,29873289,29873520,29910339,29910512,29910644,29910903,29910951,29911092,29911162,29911247,29911628,29911671,29911730,29912070,29912103,29912271,29912449,29912510,29912614,29912829,29912995,29913203,29913357,29913396,29913415,29913655,29935090,29935161,29935196,29935236,29935258,29935280,29935379,29935417,29935437,29935489,29935564,29935586,29935629,29935673,29935694,29935771,29935813,29935836,29935887,29935962,29935991,29936003,29936254,29937133,29937815,29937975,29938128,29938236,29938396,29938541,29938677,29938798,29939667,29939752,29939886,29940019,29940149,29940213,29940419,29940634,29940688,29940823,29940967,29941090,29941253,29941615,29942865,29943159,29976537,29976641,29976721,29976771,29976796,29976883,29976936,29976971,29977012,29977099,29977140,29977171,29977212,29977302,29977346,29977380,29977431,29977549,2997758', 'assoc_port': '29872039:29873289,29872042:29873217,29872046:29872994,29872049:29873092,29872052:29873054,29872055:29872910,29872057:29872828,29872061:29872867,29872064:29872746,29872068:29872673,29872070:29872606,29872073:29872479,29872075:29872564,29872077:29872524,29872079:29872628,29872080:29872297,29872081:29872370,29872082:29872182,29872083:29872106,29872084:29872396,29872085:29872254,29872086:29872135,29873350:29873520,29910028:29913655,29910033:29913396,29910036:29913357,29910040:29913203,29910044:29910339,29910047:29912995,29910052:29912614,29910056:29912829,29910074:29912510,29910076:29912271,29910079:29912449,29910082:29912103,29910084:29912070,29910087:29911730,29910089:29910512,29910091:29911628,29910105:29911671,29910119:29911162,29910121:29911247,29910123:29911092,29910124:29910903,29910125:29910644,29910126:29910951,29912891:29913415,29934985:29935962,29934988:29936254,29934992:29936003,29934994:29935991,29934996:29935887,29934997:29935673,29934999:29935836,29935000:29935629,29935002:29935564,29935004:2993558', 'assoc_mat': '29872039:autre:4230:29873289,29872042:autre:4230:29873217,29872046:autre:4230:29872994,29872049:autre:4230:29873092,29872052:autre:4230:29873054,29872055:autre:4230:29872910,29872057:autre:4230:29872828,29872061:autre:4230:29872867,29872064:autre:4230:29872746,29872068:autre:4230:29872673,29872070:autre:4230:29872606,29872073:autre:4230:29872479,29872075:autre:4230:29872564,29872077:autre:4230:29872524,29872079:autre:4230:29872628,29872080:autre:4230:29872297,29872081:autre:4230:29872370,29872082:autre:4230:29872182,29872083:autre:4230:29872106,29872084:autre:4230:29872396,29872085:autre:4230:29872254,29872086:autre:4230:29872135,29873350:autre:4230:29873520,29910028:autre:4230:29913655,29910033:autre:4230:29913396,29910036:autre:4230:29913357,29910040:autre:4230:29913203,29910044:autre:4230:29910339,29910047:autre:4230:29912995,29910052:autre:4230:29912614,29910056:autre:4230:29912829,29910074:autre:4230:29912510,29910076:autre:4230:29912271,29910079:autre:4230:29912449,29910082:autre:4230:29912103,29910084:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.101180400304597, 'nb_photo': 184930, 'list_port_cont': '29872104,29872151,29872188,29872258,29872287,29872366,29872408,29872491,29872535,29872560,29872605,29872642,29872682,29872754,29872830,29872865,29872914,29872995,29873062,29873102,29873202,29873278,29873514,29910346,29910509,29910660,29910912,29910956,29911086,29911158,29911250,29911631,29911674,29911733,29912069,29912112,29912267,29912453,29912519,29912613,29912838,29913002,29913211,29913368,29913405,29913438,29913659,29935088,29935163,29935197,29935232,29935269,29935288,29935365,29935412,29935448,29935482,29935560,29935598,29935621,29935663,29935704,29935773,29935817,29935853,29935882,29935958,29936001,29936031,29936247,29937130,29937810,29937986,29938137,29938241,29938409,29938534,29938668,29938815,29939681,29939741,29939890,29940021,29940142,29940208,29940420,29940654,29940695,29940826,29940959,29941089,29941264,29941629,29942874,29943156,29976535,29976640,29976731,29976767,29976800,29976881,29976929,29976961,29977029,29977105,29977149,29977187,29977220,29977308,29977355,29977396,29977425,29977550,2997759', 'assoc_port': '29872039:29873278,29872042:29873202,29872046:29872995,29872049:29873102,29872052:29873062,29872055:29872914,29872057:29872830,29872061:29872865,29872064:29872754,29872068:29872682,29872070:29872605,29872073:29872491,29872075:29872560,29872077:29872535,29872079:29872642,29872080:29872287,29872081:29872366,29872082:29872188,29872083:29872104,29872084:29872408,29872085:29872258,29872086:29872151,29873350:29873514,29910028:29913659,29910033:29913405,29910036:29913368,29910040:29913211,29910044:29910346,29910047:29913002,29910052:29912613,29910056:29912838,29910074:29912519,29910076:29912267,29910079:29912453,29910082:29912112,29910084:29912069,29910087:29911733,29910089:29910509,29910091:29911631,29910105:29911674,29910119:29911158,29910121:29911250,29910123:29911086,29910124:29910912,29910125:29910660,29910126:29910956,29912891:29913438,29934985:29935958,29934988:29936247,29934992:29936031,29934994:29936001,29934996:29935882,29934997:29935663,29934999:29935853,29935000:29935621,29935002:29935560,29935004:2993559', 'assoc_mat': '29872039:carton:4230:29873278,29872042:carton:4230:29873202,29872046:carton:4230:29872995,29872049:carton:4230:29873102,29872052:carton:4230:29873062,29872055:carton:4230:29872914,29872057:carton:4230:29872830,29872061:carton:4230:29872865,29872064:carton:4230:29872754,29872068:carton:4230:29872682,29872070:carton:4230:29872605,29872073:carton:4230:29872491,29872075:carton:4230:29872560,29872077:carton:4230:29872535,29872079:carton:4230:29872642,29872080:carton:4230:29872287,29872081:carton:4230:29872366,29872082:carton:4230:29872188,29872083:carton:4230:29872104,29872084:carton:4230:29872408,29872085:carton:4230:29872258,29872086:carton:4230:29872151,29873350:carton:4230:29873514,29910028:carton:4230:29913659,29910033:carton:4230:29913405,29910036:carton:4230:29913368,29910040:carton:4230:29913211,29910044:carton:4230:29910346,29910047:carton:4230:29913002,29910052:carton:4230:29912613,29910056:carton:4230:29912838,29910074:carton:4230:29912519,29910076:carton:4230:29912267,29910079:carton:4230:29912453,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0016569065923495753, 'nb_photo': 2598, 'list_port_cont': '29872102,29872150,29872183,29872261,29872285,29872373,29872405,29872487,29872572,29872639,29872826,29872876,29872909,29872986,29873066,29873094,29873215,29873286,29873504,29910336,29910510,29910946,29911084,29911150,29911255,29911618,29911663,29911729,29912068,29912109,29912272,29912461,29912521,29912603,29912835,29912993,29913209,29913362,29913410,29913420,29913666,29935150,29935228,29935267,29935410,29935439,29935480,29935549,29935599,29935696,29935770,29935814,29935850,29935885,29935956,29935988,29936253,29937132,29937978,29938135,29938402,29938547,29938681,29938812,29939676,29939746,29939876,29940010,29940147,29940211,29940418,29940644,29940698,29940821,29940956,29941105,29941254,29941631,29942860,29943146,29976759,29976801,29976880,29976932,29976959,29977015,29977142,29977183,29977213,29977303,29977438,29977551,29977583,29977744,29977788,29993686,29993758,29993914,29994059,29994203,29994539,29997172,29997642,29999292,30031608,30031942,30032617,30033310,30033893,30034104,30034736,30034974,30035163,3003520', 'assoc_port': '29872039:29873286,29872042:29873215,29872046:29872986,29872049:29873094,29872052:29873066,29872055:29872909,29872057:29872826,29872061:29872876,29872073:29872487,29872075:29872572,29872079:29872639,29872080:29872285,29872081:29872373,29872082:29872183,29872083:29872102,29872084:29872405,29872085:29872261,29872086:29872150,29873350:29873504,29910028:29913666,29910033:29913410,29910036:29913362,29910040:29913209,29910044:29910336,29910047:29912993,29910052:29912603,29910056:29912835,29910074:29912521,29910076:29912272,29910079:29912461,29910082:29912109,29910084:29912068,29910087:29911729,29910089:29910510,29910091:29911618,29910105:29911663,29910119:29911150,29910121:29911255,29910123:29911084,29910126:29910946,29912891:29913420,29934985:29935956,29934988:29936253,29934994:29935988,29934996:29935885,29934999:29935850,29935002:29935549,29935004:29935599,29935005:29935770,29935007:29935814,29935008:29935696,29935010:29935480,29935012:29935228,29935013:29935410,29935016:29935267,29935021:29935439,29935024:2993515', 'assoc_mat': '29872039:metal:4230:29873286,29872042:metal:4230:29873215,29872046:metal:4230:29872986,29872049:metal:4230:29873094,29872052:metal:4230:29873066,29872055:metal:4230:29872909,29872057:metal:4230:29872826,29872061:metal:4230:29872876,29872073:metal:4230:29872487,29872075:metal:4230:29872572,29872079:metal:4230:29872639,29872080:metal:4230:29872285,29872081:metal:4230:29872373,29872082:metal:4230:29872183,29872083:metal:4230:29872102,29872084:metal:4230:29872405,29872085:metal:4230:29872261,29872086:metal:4230:29872150,29873350:metal:4230:29873504,29910028:metal:4230:29913666,29910033:metal:4230:29913410,29910036:metal:4230:29913362,29910040:metal:4230:29913209,29910044:metal:4230:29910336,29910047:metal:4230:29912993,29910052:metal:4230:29912603,29910056:metal:4230:29912835,29910074:metal:4230:29912521,29910076:metal:4230:29912272,29910079:metal:4230:29912461,29910082:metal:4230:29912109,29910084:metal:4230:29912068,29910087:metal:4230:29911729,29910089:metal:4230:29910510,29910091:metal:4230:29911618,29910105:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.3030832964132918, 'nb_photo': 551263, 'list_port_cont': '29872108,29872146,29872181,29872252,29872288,29872369,29872409,29872481,29872532,29872568,29872608,29872640,29872677,29872760,29872833,29872875,29872907,29872988,29873060,29873101,29873213,29873280,29873508,29910350,29910503,29910656,29910913,29910955,29911082,29911165,29911257,29911625,29911673,29911726,29912076,29912116,29912277,29912457,29912524,29912607,29912834,29913000,29913195,29913371,29913401,29913434,29913667,29935082,29935152,29935195,29935224,29935271,29935285,29935376,29935408,29935451,29935474,29935553,29935601,29935636,29935671,29935703,29935781,29935810,29935849,29935881,29935953,29935995,29936029,29936255,29937134,29937814,29937982,29938145,29938239,29938406,29938545,29938680,29938811,29939673,29939745,29939878,29940023,29940154,29940217,29940421,29940638,29940697,29940830,29940964,29941102,29941270,29941622,29942867,29943153,29976532,29976630,29976729,29976769,29976798,29976876,29976934,29976969,29977020,29977110,29977147,29977177,29977222,29977315,29977351,29977387,29977439,29977546,2997759', 'assoc_port': '29872039:29873280,29872042:29873213,29872046:29872988,29872049:29873101,29872052:29873060,29872055:29872907,29872057:29872833,29872061:29872875,29872064:29872760,29872068:29872677,29872070:29872608,29872073:29872481,29872075:29872568,29872077:29872532,29872079:29872640,29872080:29872288,29872081:29872369,29872082:29872181,29872083:29872108,29872084:29872409,29872085:29872252,29872086:29872146,29873350:29873508,29910028:29913667,29910033:29913401,29910036:29913371,29910040:29913195,29910044:29910350,29910047:29913000,29910052:29912607,29910056:29912834,29910074:29912524,29910076:29912277,29910079:29912457,29910082:29912116,29910084:29912076,29910087:29911726,29910089:29910503,29910091:29911625,29910105:29911673,29910119:29911165,29910121:29911257,29910123:29911082,29910124:29910913,29910125:29910656,29910126:29910955,29912891:29913434,29934985:29935953,29934988:29936255,29934992:29936029,29934994:29935995,29934996:29935881,29934997:29935671,29934999:29935849,29935000:29935636,29935002:29935553,29935004:2993560', 'assoc_mat': '29872039:papier:4230:29873280,29872042:papier:4230:29873213,29872046:papier:4230:29872988,29872049:papier:4230:29873101,29872052:papier:4230:29873060,29872055:papier:4230:29872907,29872057:papier:4230:29872833,29872061:papier:4230:29872875,29872064:papier:4230:29872760,29872068:papier:4230:29872677,29872070:papier:4230:29872608,29872073:papier:4230:29872481,29872075:papier:4230:29872568,29872077:papier:4230:29872532,29872079:papier:4230:29872640,29872080:papier:4230:29872288,29872081:papier:4230:29872369,29872082:papier:4230:29872181,29872083:papier:4230:29872108,29872084:papier:4230:29872409,29872085:papier:4230:29872252,29872086:papier:4230:29872146,29873350:papier:4230:29873508,29910028:papier:4230:29913667,29910033:papier:4230:29913401,29910036:papier:4230:29913371,29910040:papier:4230:29913195,29910044:papier:4230:29910350,29910047:papier:4230:29913000,29910052:papier:4230:29912607,29910056:papier:4230:29912834,29910074:papier:4230:29912524,29910076:papier:4230:29912277,29910079:papier:4230:29912457,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.007240459651323948, 'nb_photo': 8040, 'list_port_cont': '29872103,29872149,29872185,29872257,29872299,29872372,29872529,29872570,29872600,29872643,29872679,29872762,29872839,29872877,29872912,29872990,29873068,29873104,29873214,29873287,29873511,29910343,29910493,29910650,29910914,29910945,29911091,29911166,29911248,29911619,29911678,29911727,29912075,29912117,29912275,29912464,29912523,29912615,29912833,29912994,29913200,29913373,29913411,29913436,29913660,29935083,29935160,29935194,29935227,29935266,29935281,29935372,29935416,29935452,29935484,29935563,29935592,29935632,29935667,29935708,29935777,29935809,29935839,29935880,29935955,29936000,29936009,29936246,29937122,29937813,29937974,29938141,29938235,29938412,29938543,29938671,29938804,29939680,29939750,29939891,29940020,29940153,29940216,29940424,29940660,29940699,29940952,29941099,29941267,29942870,29943152,29976527,29976635,29976726,29976764,29976806,29976872,29976935,29976972,29977021,29977148,29977184,29977316,29977344,29977430,29977542,29977747,29978894,29979501,29993926,29994047,29994215,29994545,2999467', 'assoc_port': '29872039:29873287,29872042:29873214,29872046:29872990,29872049:29873104,29872052:29873068,29872055:29872912,29872057:29872839,29872061:29872877,29872064:29872762,29872068:29872679,29872070:29872600,29872075:29872570,29872077:29872529,29872079:29872643,29872080:29872299,29872081:29872372,29872082:29872185,29872083:29872103,29872085:29872257,29872086:29872149,29873350:29873511,29910028:29913660,29910033:29913411,29910036:29913373,29910040:29913200,29910044:29910343,29910047:29912994,29910052:29912615,29910056:29912833,29910074:29912523,29910076:29912275,29910079:29912464,29910082:29912117,29910084:29912075,29910087:29911727,29910089:29910493,29910091:29911619,29910105:29911678,29910119:29911166,29910121:29911248,29910123:29911091,29910124:29910914,29910125:29910650,29910126:29910945,29912891:29913436,29934985:29935955,29934988:29936246,29934992:29936009,29934994:29936000,29934996:29935880,29934997:29935667,29934999:29935839,29935000:29935632,29935002:29935563,29935004:29935592,29935005:29935777,29935007:2993580', 'assoc_mat': '29872039:pehd:4230:29873287,29872042:pehd:4230:29873214,29872046:pehd:4230:29872990,29872049:pehd:4230:29873104,29872052:pehd:4230:29873068,29872055:pehd:4230:29872912,29872057:pehd:4230:29872839,29872061:pehd:4230:29872877,29872064:pehd:4230:29872762,29872068:pehd:4230:29872679,29872070:pehd:4230:29872600,29872075:pehd:4230:29872570,29872077:pehd:4230:29872529,29872079:pehd:4230:29872643,29872080:pehd:4230:29872299,29872081:pehd:4230:29872372,29872082:pehd:4230:29872185,29872083:pehd:4230:29872103,29872085:pehd:4230:29872257,29872086:pehd:4230:29872149,29873350:pehd:4230:29873511,29910028:pehd:4230:29913660,29910033:pehd:4230:29913411,29910036:pehd:4230:29913373,29910040:pehd:4230:29913200,29910044:pehd:4230:29910343,29910047:pehd:4230:29912994,29910052:pehd:4230:29912615,29910056:pehd:4230:29912833,29910074:pehd:4230:29912523,29910076:pehd:4230:29912275,29910079:pehd:4230:29912464,29910082:pehd:4230:29912117,29910084:pehd:4230:29912075,29910087:pehd:4230:29911727,29910089:pehd:4230:29910493,29910091:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.017619377937600246, 'nb_photo': 45313, 'list_port_cont': '29872097,29872148,29872180,29872256,29872298,29872362,29872401,29872493,29872533,29872569,29872604,29872641,29872680,29872745,29872834,29872870,29872908,29872992,29873063,29873107,29873210,29873291,29873513,29910348,29910497,29910658,29910917,29910947,29911087,29911163,29911251,29911626,29911677,29911722,29912072,29912110,29912270,29912456,29912525,29912611,29912836,29912996,29913202,29913370,29913408,29913430,29913662,29935086,29935164,29935193,29935233,29935264,29935276,29935375,29935414,29935450,29935476,29935557,29935595,29935637,29935665,29935701,29935778,29935803,29935847,29935889,29935961,29935989,29936027,29936251,29937129,29937817,29937979,29938144,29938231,29938411,29938549,29938678,29938802,29939672,29939753,29939892,29940011,29940146,29940206,29940422,29940656,29940694,29940822,29940962,29941096,29941269,29941630,29942876,29943157,29976536,29976643,29976733,29976768,29976804,29976885,29976927,29976973,29977025,29977106,29977139,29977186,29977211,29977311,29977354,29977394,29977437,29977548,2997759', 'assoc_port': '29872039:29873291,29872042:29873210,29872046:29872992,29872049:29873107,29872052:29873063,29872055:29872908,29872057:29872834,29872061:29872870,29872064:29872745,29872068:29872680,29872070:29872604,29872073:29872493,29872075:29872569,29872077:29872533,29872079:29872641,29872080:29872298,29872081:29872362,29872082:29872180,29872083:29872097,29872084:29872401,29872085:29872256,29872086:29872148,29873350:29873513,29910028:29913662,29910033:29913408,29910036:29913370,29910040:29913202,29910044:29910348,29910047:29912996,29910052:29912611,29910056:29912836,29910074:29912525,29910076:29912270,29910079:29912456,29910082:29912110,29910084:29912072,29910087:29911722,29910089:29910497,29910091:29911626,29910105:29911677,29910119:29911163,29910121:29911251,29910123:29911087,29910124:29910917,29910125:29910658,29910126:29910947,29912891:29913430,29934985:29935961,29934988:29936251,29934992:29936027,29934994:29935989,29934996:29935889,29934997:29935665,29934999:29935847,29935000:29935637,29935002:29935557,29935004:2993559', 'assoc_mat': '29872039:pet_clair:4230:29873291,29872042:pet_clair:4230:29873210,29872046:pet_clair:4230:29872992,29872049:pet_clair:4230:29873107,29872052:pet_clair:4230:29873063,29872055:pet_clair:4230:29872908,29872057:pet_clair:4230:29872834,29872061:pet_clair:4230:29872870,29872064:pet_clair:4230:29872745,29872068:pet_clair:4230:29872680,29872070:pet_clair:4230:29872604,29872073:pet_clair:4230:29872493,29872075:pet_clair:4230:29872569,29872077:pet_clair:4230:29872533,29872079:pet_clair:4230:29872641,29872080:pet_clair:4230:29872298,29872081:pet_clair:4230:29872362,29872082:pet_clair:4230:29872180,29872083:pet_clair:4230:29872097,29872084:pet_clair:4230:29872401,29872085:pet_clair:4230:29872256,29872086:pet_clair:4230:29872148,29873350:pet_clair:4230:29873513,29910028:pet_clair:4230:29913662,29910033:pet_clair:4230:29913408,29910036:pet_clair:4230:29913370,29910040:pet_clair:4230:29913202,29910044:pet_clair:4230:29910348,29910047:pet_clair:4230:29912996,29910052:pet_clair:4230:29912611,29910056:pet_clair:4230:29912836,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006464944443794383, 'nb_photo': 2669, 'list_port_cont': '29872144,29872186,29872259,29872296,29872406,29872534,29872561,29872837,29872873,29872916,29872989,29873059,29873106,29873516,29910344,29910491,29910659,29910904,29910950,29911093,29911253,29911624,29911679,29912067,29912114,29912274,29912522,29912841,29912997,29913374,29913440,29913665,29935080,29935279,29935378,29935453,29935487,29935561,29935591,29935705,29935780,29935842,29935879,29935957,29936002,29936248,29937131,29937807,29937981,29938139,29938544,29938674,29938814,29939679,29939751,29939887,29940022,29940148,29940415,29940693,29940831,29940966,29941268,29943151,29976529,29976734,29976772,29976807,29976884,29976933,29976960,29977027,29977145,29977181,29978897,29979502,29993696,29993773,29993903,29994053,29994220,29994542,29994680,29994929,29995202,29995373,29995737,29995782,29996103,29996159,29996279,29996604,29996759,29997141,29997185,29997369,29997770,29998102,29999294,30031604,30031934,30032614,30033312,30033906,30034101,30034751,30034979,30035174,30035197,30035744,30035936,30036024,30036159,3003646', 'assoc_port': '29872046:29872989,29872049:29873106,29872052:29873059,29872055:29872916,29872057:29872837,29872061:29872873,29872075:29872561,29872077:29872534,29872080:29872296,29872082:29872186,29872084:29872406,29872085:29872259,29872086:29872144,29873350:29873516,29910028:29913665,29910036:29913374,29910044:29910344,29910047:29912997,29910056:29912841,29910074:29912522,29910076:29912274,29910082:29912114,29910084:29912067,29910089:29910491,29910091:29911624,29910105:29911679,29910121:29911253,29910123:29911093,29910124:29910904,29910125:29910659,29910126:29910950,29912891:29913440,29934985:29935957,29934988:29936248,29934994:29936002,29934996:29935879,29934999:29935842,29935002:29935561,29935004:29935591,29935005:29935780,29935008:29935705,29935010:29935487,29935018:29935080,29935019:29935378,29935021:29935453,29935023:29935279,29936859:29937131,29937690:29937807,29937892:29937981,29938052:29938139,29938455:29938544,29938589:29938674,29938720:29938814,29939587:29939751,29939588:29939679,29939797:29939887,29939926:2994002', 'assoc_mat': '29872046:pet_fonce:4230:29872989,29872049:pet_fonce:4230:29873106,29872052:pet_fonce:4230:29873059,29872055:pet_fonce:4230:29872916,29872057:pet_fonce:4230:29872837,29872061:pet_fonce:4230:29872873,29872075:pet_fonce:4230:29872561,29872077:pet_fonce:4230:29872534,29872080:pet_fonce:4230:29872296,29872082:pet_fonce:4230:29872186,29872084:pet_fonce:4230:29872406,29872085:pet_fonce:4230:29872259,29872086:pet_fonce:4230:29872144,29873350:pet_fonce:4230:29873516,29910028:pet_fonce:4230:29913665,29910036:pet_fonce:4230:29913374,29910044:pet_fonce:4230:29910344,29910047:pet_fonce:4230:29912997,29910056:pet_fonce:4230:29912841,29910074:pet_fonce:4230:29912522,29910076:pet_fonce:4230:29912274,29910082:pet_fonce:4230:29912114,29910084:pet_fonce:4230:29912067,29910089:pet_fonce:4230:29910491,29910091:pet_fonce:4230:29911624,29910105:pet_fonce:4230:29911679,29910121:pet_fonce:4230:29911253,29910123:pet_fonce:4230:29911093,29910124:pet_fonce:4230:29910904,29910125:pet_fonce:4230:29910659,29910126:pet_fonce:4230:29910950,2'}), 'main_stat': {'nb_photos': 2435}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30148093,30148094,30148095,30148096,30148098,30148099,30148100?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.5673829812480208),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_01_annee_2026.pdf Before plot_photos_and_unwanted_material_summary # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? Before organize_and_plot_unwanted_material_stats {'incineration': {'autre': ['autre', '2.05%', 29757], 'carton': ['carton', '10.12%', 184930], 'metal': ['metal', '0.17%', 2598], 'papier': ['papier', '30.31%', 551263], 'pehd': ['pehd', '0.72%', 8040], 'pet_clair': ['pet_clair', '1.76%', 45313], 'pet_fonce': ['pet_fonce', '0.65%', 2669]}} 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_01_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.40user 2.70system 0:13.68elapsed 37%CPU (0avgtext+0avgdata 181836maxresident)k 8inputs+312outputs (1major+48765minor)pagefaults 0swaps