python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 01 mtr_id : dashboard_places : SCCU_cam7 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_cam7' 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 = 204 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 = 204 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 = 204 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_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "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 (2835823,2842690,2847231,2847811,2853841,2860818,2867427,2872226,2873659,2874678,2875161,2876339,2877689,2879029,2880246,2881431,2882504,2883065,2884149,2885202,2885893,2886686,2887654,2888788,2889138,2890530,2891703,2892856,2894258,2895550,2896705) 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.014047082417180294, 'nb_photo': 17372, 'list_port_cont': '29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877', 'assoc_port': '29872026:29874336,29872028:29874447,29872030:29874413,29872032:29874264,29872034:29874351,29872036:29874176,29872037:29874088,29872041:29874158,29872043:29873935,29872045:29874220,29872048:29873891,29872051:29874008,29872056:29873772,29872059:29873724,29872060:29873830,29872063:29873801,29872066:29873473,29872071:29873540,29872072:29873323,29872074:29873432,29872076:29873174,29872078:29873144,29873351:29873571,29874583:29874612,29910018:29915759,29910021:29916009,29910023:29917724,29910026:29916404,29910030:29916078,29910034:29916122,29910038:29915931,29910041:29915539,29910045:29915680,29910050:29915356,29910054:29915234,29910068:29915116,29910075:29914918,29910077:29915187,29910080:29914739,29910083:29914575,29910085:29914491,29910088:29914430,29910090:29914072,29910092:29913997,29910106:29914118,29910120:29913899,29910122:29913576,29912892:29913277,29934942:29937342,29934944:29937497,29934946:29937460,29934949:29937278,29934952:29937372,29934955:29937232,29934957:29936982,29934960:29937051,29934963:2993690', 'assoc_mat': '29872026:autre:4230:29874336,29872028:autre:4230:29874447,29872030:autre:4230:29874413,29872032:autre:4230:29874264,29872034:autre:4230:29874351,29872036:autre:4230:29874176,29872037:autre:4230:29874088,29872041:autre:4230:29874158,29872043:autre:4230:29873935,29872045:autre:4230:29874220,29872048:autre:4230:29873891,29872051:autre:4230:29874008,29872056:autre:4230:29873772,29872059:autre:4230:29873724,29872060:autre:4230:29873830,29872063:autre:4230:29873801,29872066:autre:4230:29873473,29872071:autre:4230:29873540,29872072:autre:4230:29873323,29872074:autre:4230:29873432,29872076:autre:4230:29873174,29872078:autre:4230:29873144,29873351:autre:4230:29873571,29874583:autre:4230:29874612,29910018:autre:4230:29915759,29910021:autre:4230:29916009,29910023:autre:4230:29917724,29910026:autre:4230:29916404,29910030:autre:4230:29916078,29910034:autre:4230:29916122,29910038:autre:4230:29915931,29910041:autre:4230:29915539,29910045:autre:4230:29915680,29910050:autre:4230:29915356,29910054:autre:4230:29915234,29910068:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.040677685776631826, 'nb_photo': 87213, 'list_port_cont': '29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878', 'assoc_port': '29872026:29874342,29872028:29874443,29872030:29874406,29872032:29874270,29872034:29874357,29872036:29874173,29872037:29874087,29872041:29874161,29872043:29873937,29872045:29874230,29872048:29873905,29872051:29874014,29872056:29873765,29872059:29873727,29872060:29873838,29872063:29873810,29872066:29873474,29872071:29873549,29872072:29873314,29872074:29873443,29872076:29873173,29872078:29873142,29873351:29873574,29874583:29874621,29910018:29915779,29910021:29916016,29910023:29917732,29910026:29916402,29910030:29916088,29910034:29916135,29910038:29915932,29910041:29915555,29910045:29915681,29910050:29915370,29910054:29915233,29910068:29915113,29910075:29914931,29910077:29915200,29910080:29914756,29910083:29914570,29910085:29914492,29910088:29914435,29910090:29914078,29910092:29914002,29910106:29914115,29910120:29913910,29910122:29913589,29912892:29913268,29934942:29937350,29934944:29937485,29934946:29937462,29934949:29937277,29934952:29937383,29934955:29937236,29934957:29936980,29934960:29937058,29934963:2993691', 'assoc_mat': '29872026:carton:4230:29874342,29872028:carton:4230:29874443,29872030:carton:4230:29874406,29872032:carton:4230:29874270,29872034:carton:4230:29874357,29872036:carton:4230:29874173,29872037:carton:4230:29874087,29872041:carton:4230:29874161,29872043:carton:4230:29873937,29872045:carton:4230:29874230,29872048:carton:4230:29873905,29872051:carton:4230:29874014,29872056:carton:4230:29873765,29872059:carton:4230:29873727,29872060:carton:4230:29873838,29872063:carton:4230:29873810,29872066:carton:4230:29873474,29872071:carton:4230:29873549,29872072:carton:4230:29873314,29872074:carton:4230:29873443,29872076:carton:4230:29873173,29872078:carton:4230:29873142,29873351:carton:4230:29873574,29874583:carton:4230:29874621,29910018:carton:4230:29915779,29910021:carton:4230:29916016,29910023:carton:4230:29917732,29910026:carton:4230:29916402,29910030:carton:4230:29916088,29910034:carton:4230:29916135,29910038:carton:4230:29915932,29910041:carton:4230:29915555,29910045:carton:4230:29915681,29910050:carton:4230:29915370,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00148242817893768, 'nb_photo': 1977, 'list_port_cont': '29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047', 'assoc_port': '29872026:29874329,29872030:29874400,29872032:29874261,29872034:29874353,29872036:29874179,29872037:29874089,29872041:29874162,29872043:29873941,29872045:29874222,29872048:29873894,29872051:29874001,29872056:29873759,29872059:29873732,29872060:29873834,29872063:29873796,29872066:29873471,29872071:29873539,29872072:29873325,29872074:29873427,29872076:29873172,29872078:29873134,29874583:29874624,29910026:29916409,29910030:29916094,29910034:29916128,29910038:29915926,29910041:29915547,29910045:29915679,29910050:29915362,29910068:29915105,29910077:29915194,29910080:29914755,29910088:29914405,29910090:29914088,29910092:29913996,29910106:29914120,29910122:29913583,29912892:29913266,29934942:29937352,29934946:29937452,29934949:29937273,29934952:29937379,29934955:29937229,29934957:29936978,29934960:29937052,29934963:29936905,29934965:29936823,29934971:29936689,29934973:29936354,29934975:29936424,29934977:29936467,29934979:29936216,29934981:29936312,29934989:29936101,29934993:29936182,29934995:29935038,29936860:2993709', 'assoc_mat': '29872026:metal:4230:29874329,29872030:metal:4230:29874400,29872032:metal:4230:29874261,29872034:metal:4230:29874353,29872036:metal:4230:29874179,29872037:metal:4230:29874089,29872041:metal:4230:29874162,29872043:metal:4230:29873941,29872045:metal:4230:29874222,29872048:metal:4230:29873894,29872051:metal:4230:29874001,29872056:metal:4230:29873759,29872059:metal:4230:29873732,29872060:metal:4230:29873834,29872063:metal:4230:29873796,29872066:metal:4230:29873471,29872071:metal:4230:29873539,29872072:metal:4230:29873325,29872074:metal:4230:29873427,29872076:metal:4230:29873172,29872078:metal:4230:29873134,29874583:metal:4230:29874624,29910026:metal:4230:29916409,29910030:metal:4230:29916094,29910034:metal:4230:29916128,29910038:metal:4230:29915926,29910041:metal:4230:29915547,29910045:metal:4230:29915679,29910050:metal:4230:29915362,29910068:metal:4230:29915105,29910077:metal:4230:29915194,29910080:metal:4230:29914755,29910088:metal:4230:29914405,29910090:metal:4230:29914088,29910092:metal:4230:29913996,29910106:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16215618379631866, 'nb_photo': 299916, 'list_port_cont': '29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878', 'assoc_port': '29872026:29874331,29872028:29874440,29872030:29874415,29872032:29874268,29872034:29874356,29872036:29874178,29872037:29874085,29872041:29874148,29872043:29873939,29872045:29874228,29872048:29873903,29872051:29874018,29872056:29873768,29872059:29873734,29872060:29873844,29872063:29873806,29872066:29873472,29872071:29873555,29872072:29873328,29872074:29873434,29872076:29873171,29872078:29873146,29873351:29873568,29874583:29874623,29910018:29915773,29910021:29916008,29910023:29917730,29910026:29916415,29910030:29916085,29910034:29916136,29910038:29915930,29910041:29915548,29910045:29915692,29910050:29915366,29910054:29915232,29910068:29915112,29910075:29914930,29910077:29915199,29910080:29914752,29910083:29914576,29910085:29914494,29910088:29914426,29910090:29914089,29910092:29914004,29910106:29914119,29910120:29913901,29910122:29913581,29912892:29913270,29934942:29937349,29934944:29937491,29934946:29937461,29934949:29937274,29934952:29937385,29934955:29937235,29934957:29936981,29934960:29937059,29934963:2993691', 'assoc_mat': '29872026:papier:4230:29874331,29872028:papier:4230:29874440,29872030:papier:4230:29874415,29872032:papier:4230:29874268,29872034:papier:4230:29874356,29872036:papier:4230:29874178,29872037:papier:4230:29874085,29872041:papier:4230:29874148,29872043:papier:4230:29873939,29872045:papier:4230:29874228,29872048:papier:4230:29873903,29872051:papier:4230:29874018,29872056:papier:4230:29873768,29872059:papier:4230:29873734,29872060:papier:4230:29873844,29872063:papier:4230:29873806,29872066:papier:4230:29873472,29872071:papier:4230:29873555,29872072:papier:4230:29873328,29872074:papier:4230:29873434,29872076:papier:4230:29873171,29872078:papier:4230:29873146,29873351:papier:4230:29873568,29874583:papier:4230:29874623,29910018:papier:4230:29915773,29910021:papier:4230:29916008,29910023:papier:4230:29917730,29910026:papier:4230:29916415,29910030:papier:4230:29916085,29910034:papier:4230:29916136,29910038:papier:4230:29915930,29910041:papier:4230:29915548,29910045:papier:4230:29915692,29910050:papier:4230:29915366,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028902969187158114, 'nb_photo': 1581, 'list_port_cont': '29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961', 'assoc_port': '29872026:29874345,29872030:29874412,29872034:29874360,29872036:29874174,29872037:29874081,29872043:29873940,29872045:29874234,29872051:29874009,29872060:29873840,29872071:29873552,29872072:29873322,29872074:29873440,29872076:29873178,29872078:29873137,29873351:29873565,29874583:29874628,29910018:29915774,29910038:29915927,29910041:29915553,29910045:29915693,29910050:29915367,29910054:29915231,29910068:29915117,29910075:29914922,29910077:29915196,29910080:29914747,29910083:29914583,29910085:29914493,29910090:29914083,29910106:29914124,29910120:29913911,29910122:29913588,29912892:29913281,29934942:29937353,29934946:29937453,29934949:29937281,29934960:29937060,29934963:29936900,29934965:29936829,29934967:29936803,29934971:29936694,29934973:29936364,29934975:29936435,29934977:29936474,29934979:29936219,29934981:29936326,29934984:29936291,29934986:29936146,29934989:29936105,29934993:29936170,29934995:29935054,29936860:29937087,29941172:29942421,29941175:29942078,29941176:29942263,29941178:29942057,29941193:2994191', 'assoc_mat': '29872026:pehd:4230:29874345,29872030:pehd:4230:29874412,29872034:pehd:4230:29874360,29872036:pehd:4230:29874174,29872037:pehd:4230:29874081,29872043:pehd:4230:29873940,29872045:pehd:4230:29874234,29872051:pehd:4230:29874009,29872060:pehd:4230:29873840,29872071:pehd:4230:29873552,29872072:pehd:4230:29873322,29872074:pehd:4230:29873440,29872076:pehd:4230:29873178,29872078:pehd:4230:29873137,29873351:pehd:4230:29873565,29874583:pehd:4230:29874628,29910018:pehd:4230:29915774,29910038:pehd:4230:29915927,29910041:pehd:4230:29915553,29910045:pehd:4230:29915693,29910050:pehd:4230:29915367,29910054:pehd:4230:29915231,29910068:pehd:4230:29915117,29910075:pehd:4230:29914922,29910077:pehd:4230:29915196,29910080:pehd:4230:29914747,29910083:pehd:4230:29914583,29910085:pehd:4230:29914493,29910090:pehd:4230:29914083,29910106:pehd:4230:29914124,29910120:pehd:4230:29913911,29910122:pehd:4230:29913588,29912892:pehd:4230:29913281,29934942:pehd:4230:29937353,29934946:pehd:4230:29937453,29934949:pehd:4230:29937281,29934960:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.023127454673713348, 'nb_photo': 33253, 'list_port_cont': '29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878', 'assoc_port': '29872026:29874341,29872028:29874451,29872030:29874417,29872032:29874258,29872034:29874362,29872036:29874168,29872037:29874083,29872041:29874150,29872043:29873938,29872045:29874229,29872048:29873901,29872051:29874015,29872056:29873773,29872059:29873728,29872060:29873841,29872063:29873803,29872066:29873467,29872071:29873550,29872072:29873324,29872074:29873438,29872076:29873175,29872078:29873145,29873351:29873569,29874583:29874627,29910018:29915771,29910021:29916005,29910023:29917731,29910026:29916406,29910030:29916091,29910034:29916134,29910038:29915919,29910041:29915551,29910045:29915688,29910050:29915369,29910054:29915235,29910068:29915115,29910075:29914923,29910077:29915197,29910080:29914750,29910083:29914573,29910085:29914490,29910088:29914415,29910090:29914084,29910092:29914001,29910106:29914122,29910120:29913904,29910122:29913580,29912892:29913275,29934942:29937346,29934944:29937498,29934946:29937457,29934949:29937276,29934952:29937389,29934955:29937242,29934957:29936985,29934960:29937049,29934963:2993690', 'assoc_mat': '29872026:pet_clair:4230:29874341,29872028:pet_clair:4230:29874451,29872030:pet_clair:4230:29874417,29872032:pet_clair:4230:29874258,29872034:pet_clair:4230:29874362,29872036:pet_clair:4230:29874168,29872037:pet_clair:4230:29874083,29872041:pet_clair:4230:29874150,29872043:pet_clair:4230:29873938,29872045:pet_clair:4230:29874229,29872048:pet_clair:4230:29873901,29872051:pet_clair:4230:29874015,29872056:pet_clair:4230:29873773,29872059:pet_clair:4230:29873728,29872060:pet_clair:4230:29873841,29872063:pet_clair:4230:29873803,29872066:pet_clair:4230:29873467,29872071:pet_clair:4230:29873550,29872072:pet_clair:4230:29873324,29872074:pet_clair:4230:29873438,29872076:pet_clair:4230:29873175,29872078:pet_clair:4230:29873145,29873351:pet_clair:4230:29873569,29874583:pet_clair:4230:29874627,29910018:pet_clair:4230:29915771,29910021:pet_clair:4230:29916005,29910023:pet_clair:4230:29917731,29910026:pet_clair:4230:29916406,29910030:pet_clair:4230:29916091,29910034:pet_clair:4230:29916134,29910038:pet_clair:4230:29915919,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024872076517107565, 'nb_photo': 787, 'list_port_cont': '29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188', 'assoc_port': '29872026:29874332,29872028:29874453,29872030:29874414,29872034:29874361,29872036:29874175,29872037:29874086,29872048:29873900,29872059:29873733,29872063:29873804,29872066:29873477,29872071:29873554,29872072:29873318,29872076:29873180,29874583:29874626,29910018:29915778,29910021:29916004,29910023:29917733,29910026:29916412,29910030:29916087,29910034:29916132,29910038:29915920,29910041:29915550,29910045:29915685,29910068:29915114,29910075:29914932,29910077:29915203,29910080:29914759,29910083:29914582,29910085:29914483,29910088:29914413,29910090:29914085,29910106:29914127,29910120:29913906,29910122:29913585,29934942:29937351,29934944:29937487,29934946:29937449,29934949:29937279,29934952:29937388,29934963:29936908,29934965:29936828,29934967:29936800,29934969:29936513,29934971:29936690,29934973:29936362,29934975:29936437,29934977:29936476,29934979:29936213,29934981:29936325,29934984:29936280,29934986:29936143,29934993:29936181,29936860:29937083,29941175:29942082,29941180:29941954,29941182:29941844,29941193:2994191', 'assoc_mat': '29872026:pet_fonce:4230:29874332,29872028:pet_fonce:4230:29874453,29872030:pet_fonce:4230:29874414,29872034:pet_fonce:4230:29874361,29872036:pet_fonce:4230:29874175,29872037:pet_fonce:4230:29874086,29872048:pet_fonce:4230:29873900,29872059:pet_fonce:4230:29873733,29872063:pet_fonce:4230:29873804,29872066:pet_fonce:4230:29873477,29872071:pet_fonce:4230:29873554,29872072:pet_fonce:4230:29873318,29872076:pet_fonce:4230:29873180,29874583:pet_fonce:4230:29874626,29910018:pet_fonce:4230:29915778,29910021:pet_fonce:4230:29916004,29910023:pet_fonce:4230:29917733,29910026:pet_fonce:4230:29916412,29910030:pet_fonce:4230:29916087,29910034:pet_fonce:4230:29916132,29910038:pet_fonce:4230:29915920,29910041:pet_fonce:4230:29915550,29910045:pet_fonce:4230:29915685,29910068:pet_fonce:4230:29915114,29910075:pet_fonce:4230:29914932,29910077:pet_fonce:4230:29915203,29910080:pet_fonce:4230:29914759,29910083:pet_fonce:4230:29914582,29910085:pet_fonce:4230:29914483,29910088:pet_fonce:4230:29914413,29910090:pet_fonce:4230:29914085,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(2835823,2842690,2847231,2847811,2853841,2860818,2867427,2872226,2873659,2874678,2875161,2876339,2877689,2879029,2880246,2881431,2882504,2883065,2884149,2885202,2885893,2886686,2887654,2888788,2889138,2890530,2891703,2892856,2894258,2895550,2896705)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124540, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124541, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124542, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124543, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124544, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124545, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30124546, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30124540,30124541,30124542,30124543,30124544,30124545,30124546?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=204 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': ((2013,),), 'unwanted_material_monthly_percentage': ((0.7693621927394285,),), 'material_repartition': (('incineration', 2013),), 'material_dict': {'incineration': 2013}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7241403322256932, 2), (datetime.date(2026, 1, 16), 0.712559000098445, 3), (datetime.date(2026, 1, 17), 0.7397620549632145, 4), (datetime.date(2026, 1, 18), 0.8190281688151947, 2), (datetime.date(2026, 1, 19), 0.7998521751340665, 4), (datetime.date(2026, 1, 20), 0.7837810869293727, 1), (datetime.date(2026, 1, 21), 0.7341416458187252, 1), (datetime.date(2026, 1, 22), 0.7213245265687724, 2), (datetime.date(2026, 1, 23), 0.7376341294901849, 3), (datetime.date(2026, 1, 24), 0.7811841186937545, 2), (datetime.date(2026, 1, 25), 0.7891713010514773, 2), (datetime.date(2026, 1, 26), 0.7890960199954612, 3), (datetime.date(2026, 1, 27), 0.7646194262562904, 1), (datetime.date(2026, 1, 28), 0.7667175206489267, 1), (datetime.date(2026, 1, 29), 0.7624872697853409, 4), (datetime.date(2026, 1, 30), 0.7322871407392194, 4), (datetime.date(2026, 1, 31), 0.7819774399738414, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7241403322256932, 2), (datetime.date(2026, 1, 16), 0.712559000098445, 3), (datetime.date(2026, 1, 17), 0.7397620549632145, 4), (datetime.date(2026, 1, 18), 0.8190281688151947, 2), (datetime.date(2026, 1, 19), 0.7998521751340665, 4), (datetime.date(2026, 1, 20), 0.7837810869293727, 1), (datetime.date(2026, 1, 21), 0.7341416458187252, 1), (datetime.date(2026, 1, 22), 0.7213245265687724, 2), (datetime.date(2026, 1, 23), 0.7376341294901849, 3), (datetime.date(2026, 1, 24), 0.7811841186937545, 2), (datetime.date(2026, 1, 25), 0.7891713010514773, 2), (datetime.date(2026, 1, 26), 0.7890960199954612, 3), (datetime.date(2026, 1, 27), 0.7646194262562904, 1), (datetime.date(2026, 1, 28), 0.7667175206489267, 1), (datetime.date(2026, 1, 29), 0.7624872697853409, 4), (datetime.date(2026, 1, 30), 0.7322871407392194, 4), (datetime.date(2026, 1, 31), 0.7819774399738414, 2))}, 'quality_array': [['-7.1461397154465045', '01012026'], ['-6.790631642374837', '02012026'], ['-6.950659734975454', '03012026'], ['-6.932661919079431', '04012026'], ['-6.4842697940755265', '05012026'], ['-6.141143744328462', '06012026'], ['-6.687664593091492', '07012026'], ['-6.913470589711381', '08012026'], ['-7.3127044487476045', '09012026'], ['-7.270751854397152', '10012026'], ['-6.829435540902781', '11012026'], ['-7.10091400510139', '12012026'], ['-7.2419920685407755', '13012026'], ['-7.425190751008745', '14012026'], ['-7.2563729081258375', '15012026'], ['-7.226726912552739', '16012026'], ['-7.1511374059246755', '17012026'], ['-6.914782270979785', '18012026'], ['-6.56595035098907', '19012026'], ['-6.614758775135202', '20012026'], ['-6.702746738059033', '21012026'], ['-6.530975912044781', '22012026'], ['-6.885882918397778', '23012026'], ['-6.8292950973146045', '24012026'], ['-6.957917031421825', '25012026'], ['-6.475779732120948', '26012026'], ['-6.728141588750844', '27012026'], ['-7.357444828971857', '28012026'], ['-7.131372503769199', '29012026'], ['-7.042417779309024', '30012026'], ['-7.057327898353387', '31012026']], 'number_of_batch': ((720,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014047082417180294, 'nb_photo': 17372, 'list_port_cont': '29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877', 'assoc_port': '29872026:29874336,29872028:29874447,29872030:29874413,29872032:29874264,29872034:29874351,29872036:29874176,29872037:29874088,29872041:29874158,29872043:29873935,29872045:29874220,29872048:29873891,29872051:29874008,29872056:29873772,29872059:29873724,29872060:29873830,29872063:29873801,29872066:29873473,29872071:29873540,29872072:29873323,29872074:29873432,29872076:29873174,29872078:29873144,29873351:29873571,29874583:29874612,29910018:29915759,29910021:29916009,29910023:29917724,29910026:29916404,29910030:29916078,29910034:29916122,29910038:29915931,29910041:29915539,29910045:29915680,29910050:29915356,29910054:29915234,29910068:29915116,29910075:29914918,29910077:29915187,29910080:29914739,29910083:29914575,29910085:29914491,29910088:29914430,29910090:29914072,29910092:29913997,29910106:29914118,29910120:29913899,29910122:29913576,29912892:29913277,29934942:29937342,29934944:29937497,29934946:29937460,29934949:29937278,29934952:29937372,29934955:29937232,29934957:29936982,29934960:29937051,29934963:2993690', 'assoc_mat': '29872026:autre:4230:29874336,29872028:autre:4230:29874447,29872030:autre:4230:29874413,29872032:autre:4230:29874264,29872034:autre:4230:29874351,29872036:autre:4230:29874176,29872037:autre:4230:29874088,29872041:autre:4230:29874158,29872043:autre:4230:29873935,29872045:autre:4230:29874220,29872048:autre:4230:29873891,29872051:autre:4230:29874008,29872056:autre:4230:29873772,29872059:autre:4230:29873724,29872060:autre:4230:29873830,29872063:autre:4230:29873801,29872066:autre:4230:29873473,29872071:autre:4230:29873540,29872072:autre:4230:29873323,29872074:autre:4230:29873432,29872076:autre:4230:29873174,29872078:autre:4230:29873144,29873351:autre:4230:29873571,29874583:autre:4230:29874612,29910018:autre:4230:29915759,29910021:autre:4230:29916009,29910023:autre:4230:29917724,29910026:autre:4230:29916404,29910030:autre:4230:29916078,29910034:autre:4230:29916122,29910038:autre:4230:29915931,29910041:autre:4230:29915539,29910045:autre:4230:29915680,29910050:autre:4230:29915356,29910054:autre:4230:29915234,29910068:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.040677685776631826, 'nb_photo': 87213, 'list_port_cont': '29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878', 'assoc_port': '29872026:29874342,29872028:29874443,29872030:29874406,29872032:29874270,29872034:29874357,29872036:29874173,29872037:29874087,29872041:29874161,29872043:29873937,29872045:29874230,29872048:29873905,29872051:29874014,29872056:29873765,29872059:29873727,29872060:29873838,29872063:29873810,29872066:29873474,29872071:29873549,29872072:29873314,29872074:29873443,29872076:29873173,29872078:29873142,29873351:29873574,29874583:29874621,29910018:29915779,29910021:29916016,29910023:29917732,29910026:29916402,29910030:29916088,29910034:29916135,29910038:29915932,29910041:29915555,29910045:29915681,29910050:29915370,29910054:29915233,29910068:29915113,29910075:29914931,29910077:29915200,29910080:29914756,29910083:29914570,29910085:29914492,29910088:29914435,29910090:29914078,29910092:29914002,29910106:29914115,29910120:29913910,29910122:29913589,29912892:29913268,29934942:29937350,29934944:29937485,29934946:29937462,29934949:29937277,29934952:29937383,29934955:29937236,29934957:29936980,29934960:29937058,29934963:2993691', 'assoc_mat': '29872026:carton:4230:29874342,29872028:carton:4230:29874443,29872030:carton:4230:29874406,29872032:carton:4230:29874270,29872034:carton:4230:29874357,29872036:carton:4230:29874173,29872037:carton:4230:29874087,29872041:carton:4230:29874161,29872043:carton:4230:29873937,29872045:carton:4230:29874230,29872048:carton:4230:29873905,29872051:carton:4230:29874014,29872056:carton:4230:29873765,29872059:carton:4230:29873727,29872060:carton:4230:29873838,29872063:carton:4230:29873810,29872066:carton:4230:29873474,29872071:carton:4230:29873549,29872072:carton:4230:29873314,29872074:carton:4230:29873443,29872076:carton:4230:29873173,29872078:carton:4230:29873142,29873351:carton:4230:29873574,29874583:carton:4230:29874621,29910018:carton:4230:29915779,29910021:carton:4230:29916016,29910023:carton:4230:29917732,29910026:carton:4230:29916402,29910030:carton:4230:29916088,29910034:carton:4230:29916135,29910038:carton:4230:29915932,29910041:carton:4230:29915555,29910045:carton:4230:29915681,29910050:carton:4230:29915370,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00148242817893768, 'nb_photo': 1977, 'list_port_cont': '29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047', 'assoc_port': '29872026:29874329,29872030:29874400,29872032:29874261,29872034:29874353,29872036:29874179,29872037:29874089,29872041:29874162,29872043:29873941,29872045:29874222,29872048:29873894,29872051:29874001,29872056:29873759,29872059:29873732,29872060:29873834,29872063:29873796,29872066:29873471,29872071:29873539,29872072:29873325,29872074:29873427,29872076:29873172,29872078:29873134,29874583:29874624,29910026:29916409,29910030:29916094,29910034:29916128,29910038:29915926,29910041:29915547,29910045:29915679,29910050:29915362,29910068:29915105,29910077:29915194,29910080:29914755,29910088:29914405,29910090:29914088,29910092:29913996,29910106:29914120,29910122:29913583,29912892:29913266,29934942:29937352,29934946:29937452,29934949:29937273,29934952:29937379,29934955:29937229,29934957:29936978,29934960:29937052,29934963:29936905,29934965:29936823,29934971:29936689,29934973:29936354,29934975:29936424,29934977:29936467,29934979:29936216,29934981:29936312,29934989:29936101,29934993:29936182,29934995:29935038,29936860:2993709', 'assoc_mat': '29872026:metal:4230:29874329,29872030:metal:4230:29874400,29872032:metal:4230:29874261,29872034:metal:4230:29874353,29872036:metal:4230:29874179,29872037:metal:4230:29874089,29872041:metal:4230:29874162,29872043:metal:4230:29873941,29872045:metal:4230:29874222,29872048:metal:4230:29873894,29872051:metal:4230:29874001,29872056:metal:4230:29873759,29872059:metal:4230:29873732,29872060:metal:4230:29873834,29872063:metal:4230:29873796,29872066:metal:4230:29873471,29872071:metal:4230:29873539,29872072:metal:4230:29873325,29872074:metal:4230:29873427,29872076:metal:4230:29873172,29872078:metal:4230:29873134,29874583:metal:4230:29874624,29910026:metal:4230:29916409,29910030:metal:4230:29916094,29910034:metal:4230:29916128,29910038:metal:4230:29915926,29910041:metal:4230:29915547,29910045:metal:4230:29915679,29910050:metal:4230:29915362,29910068:metal:4230:29915105,29910077:metal:4230:29915194,29910080:metal:4230:29914755,29910088:metal:4230:29914405,29910090:metal:4230:29914088,29910092:metal:4230:29913996,29910106:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16215618379631866, 'nb_photo': 299916, 'list_port_cont': '29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878', 'assoc_port': '29872026:29874331,29872028:29874440,29872030:29874415,29872032:29874268,29872034:29874356,29872036:29874178,29872037:29874085,29872041:29874148,29872043:29873939,29872045:29874228,29872048:29873903,29872051:29874018,29872056:29873768,29872059:29873734,29872060:29873844,29872063:29873806,29872066:29873472,29872071:29873555,29872072:29873328,29872074:29873434,29872076:29873171,29872078:29873146,29873351:29873568,29874583:29874623,29910018:29915773,29910021:29916008,29910023:29917730,29910026:29916415,29910030:29916085,29910034:29916136,29910038:29915930,29910041:29915548,29910045:29915692,29910050:29915366,29910054:29915232,29910068:29915112,29910075:29914930,29910077:29915199,29910080:29914752,29910083:29914576,29910085:29914494,29910088:29914426,29910090:29914089,29910092:29914004,29910106:29914119,29910120:29913901,29910122:29913581,29912892:29913270,29934942:29937349,29934944:29937491,29934946:29937461,29934949:29937274,29934952:29937385,29934955:29937235,29934957:29936981,29934960:29937059,29934963:2993691', 'assoc_mat': '29872026:papier:4230:29874331,29872028:papier:4230:29874440,29872030:papier:4230:29874415,29872032:papier:4230:29874268,29872034:papier:4230:29874356,29872036:papier:4230:29874178,29872037:papier:4230:29874085,29872041:papier:4230:29874148,29872043:papier:4230:29873939,29872045:papier:4230:29874228,29872048:papier:4230:29873903,29872051:papier:4230:29874018,29872056:papier:4230:29873768,29872059:papier:4230:29873734,29872060:papier:4230:29873844,29872063:papier:4230:29873806,29872066:papier:4230:29873472,29872071:papier:4230:29873555,29872072:papier:4230:29873328,29872074:papier:4230:29873434,29872076:papier:4230:29873171,29872078:papier:4230:29873146,29873351:papier:4230:29873568,29874583:papier:4230:29874623,29910018:papier:4230:29915773,29910021:papier:4230:29916008,29910023:papier:4230:29917730,29910026:papier:4230:29916415,29910030:papier:4230:29916085,29910034:papier:4230:29916136,29910038:papier:4230:29915930,29910041:papier:4230:29915548,29910045:papier:4230:29915692,29910050:papier:4230:29915366,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028902969187158114, 'nb_photo': 1581, 'list_port_cont': '29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961', 'assoc_port': '29872026:29874345,29872030:29874412,29872034:29874360,29872036:29874174,29872037:29874081,29872043:29873940,29872045:29874234,29872051:29874009,29872060:29873840,29872071:29873552,29872072:29873322,29872074:29873440,29872076:29873178,29872078:29873137,29873351:29873565,29874583:29874628,29910018:29915774,29910038:29915927,29910041:29915553,29910045:29915693,29910050:29915367,29910054:29915231,29910068:29915117,29910075:29914922,29910077:29915196,29910080:29914747,29910083:29914583,29910085:29914493,29910090:29914083,29910106:29914124,29910120:29913911,29910122:29913588,29912892:29913281,29934942:29937353,29934946:29937453,29934949:29937281,29934960:29937060,29934963:29936900,29934965:29936829,29934967:29936803,29934971:29936694,29934973:29936364,29934975:29936435,29934977:29936474,29934979:29936219,29934981:29936326,29934984:29936291,29934986:29936146,29934989:29936105,29934993:29936170,29934995:29935054,29936860:29937087,29941172:29942421,29941175:29942078,29941176:29942263,29941178:29942057,29941193:2994191', 'assoc_mat': '29872026:pehd:4230:29874345,29872030:pehd:4230:29874412,29872034:pehd:4230:29874360,29872036:pehd:4230:29874174,29872037:pehd:4230:29874081,29872043:pehd:4230:29873940,29872045:pehd:4230:29874234,29872051:pehd:4230:29874009,29872060:pehd:4230:29873840,29872071:pehd:4230:29873552,29872072:pehd:4230:29873322,29872074:pehd:4230:29873440,29872076:pehd:4230:29873178,29872078:pehd:4230:29873137,29873351:pehd:4230:29873565,29874583:pehd:4230:29874628,29910018:pehd:4230:29915774,29910038:pehd:4230:29915927,29910041:pehd:4230:29915553,29910045:pehd:4230:29915693,29910050:pehd:4230:29915367,29910054:pehd:4230:29915231,29910068:pehd:4230:29915117,29910075:pehd:4230:29914922,29910077:pehd:4230:29915196,29910080:pehd:4230:29914747,29910083:pehd:4230:29914583,29910085:pehd:4230:29914493,29910090:pehd:4230:29914083,29910106:pehd:4230:29914124,29910120:pehd:4230:29913911,29910122:pehd:4230:29913588,29912892:pehd:4230:29913281,29934942:pehd:4230:29937353,29934946:pehd:4230:29937453,29934949:pehd:4230:29937281,29934960:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.023127454673713348, 'nb_photo': 33253, 'list_port_cont': '29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878', 'assoc_port': '29872026:29874341,29872028:29874451,29872030:29874417,29872032:29874258,29872034:29874362,29872036:29874168,29872037:29874083,29872041:29874150,29872043:29873938,29872045:29874229,29872048:29873901,29872051:29874015,29872056:29873773,29872059:29873728,29872060:29873841,29872063:29873803,29872066:29873467,29872071:29873550,29872072:29873324,29872074:29873438,29872076:29873175,29872078:29873145,29873351:29873569,29874583:29874627,29910018:29915771,29910021:29916005,29910023:29917731,29910026:29916406,29910030:29916091,29910034:29916134,29910038:29915919,29910041:29915551,29910045:29915688,29910050:29915369,29910054:29915235,29910068:29915115,29910075:29914923,29910077:29915197,29910080:29914750,29910083:29914573,29910085:29914490,29910088:29914415,29910090:29914084,29910092:29914001,29910106:29914122,29910120:29913904,29910122:29913580,29912892:29913275,29934942:29937346,29934944:29937498,29934946:29937457,29934949:29937276,29934952:29937389,29934955:29937242,29934957:29936985,29934960:29937049,29934963:2993690', 'assoc_mat': '29872026:pet_clair:4230:29874341,29872028:pet_clair:4230:29874451,29872030:pet_clair:4230:29874417,29872032:pet_clair:4230:29874258,29872034:pet_clair:4230:29874362,29872036:pet_clair:4230:29874168,29872037:pet_clair:4230:29874083,29872041:pet_clair:4230:29874150,29872043:pet_clair:4230:29873938,29872045:pet_clair:4230:29874229,29872048:pet_clair:4230:29873901,29872051:pet_clair:4230:29874015,29872056:pet_clair:4230:29873773,29872059:pet_clair:4230:29873728,29872060:pet_clair:4230:29873841,29872063:pet_clair:4230:29873803,29872066:pet_clair:4230:29873467,29872071:pet_clair:4230:29873550,29872072:pet_clair:4230:29873324,29872074:pet_clair:4230:29873438,29872076:pet_clair:4230:29873175,29872078:pet_clair:4230:29873145,29873351:pet_clair:4230:29873569,29874583:pet_clair:4230:29874627,29910018:pet_clair:4230:29915771,29910021:pet_clair:4230:29916005,29910023:pet_clair:4230:29917731,29910026:pet_clair:4230:29916406,29910030:pet_clair:4230:29916091,29910034:pet_clair:4230:29916134,29910038:pet_clair:4230:29915919,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024872076517107565, 'nb_photo': 787, 'list_port_cont': '29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188', 'assoc_port': '29872026:29874332,29872028:29874453,29872030:29874414,29872034:29874361,29872036:29874175,29872037:29874086,29872048:29873900,29872059:29873733,29872063:29873804,29872066:29873477,29872071:29873554,29872072:29873318,29872076:29873180,29874583:29874626,29910018:29915778,29910021:29916004,29910023:29917733,29910026:29916412,29910030:29916087,29910034:29916132,29910038:29915920,29910041:29915550,29910045:29915685,29910068:29915114,29910075:29914932,29910077:29915203,29910080:29914759,29910083:29914582,29910085:29914483,29910088:29914413,29910090:29914085,29910106:29914127,29910120:29913906,29910122:29913585,29934942:29937351,29934944:29937487,29934946:29937449,29934949:29937279,29934952:29937388,29934963:29936908,29934965:29936828,29934967:29936800,29934969:29936513,29934971:29936690,29934973:29936362,29934975:29936437,29934977:29936476,29934979:29936213,29934981:29936325,29934984:29936280,29934986:29936143,29934993:29936181,29936860:29937083,29941175:29942082,29941180:29941954,29941182:29941844,29941193:2994191', 'assoc_mat': '29872026:pet_fonce:4230:29874332,29872028:pet_fonce:4230:29874453,29872030:pet_fonce:4230:29874414,29872034:pet_fonce:4230:29874361,29872036:pet_fonce:4230:29874175,29872037:pet_fonce:4230:29874086,29872048:pet_fonce:4230:29873900,29872059:pet_fonce:4230:29873733,29872063:pet_fonce:4230:29873804,29872066:pet_fonce:4230:29873477,29872071:pet_fonce:4230:29873554,29872072:pet_fonce:4230:29873318,29872076:pet_fonce:4230:29873180,29874583:pet_fonce:4230:29874626,29910018:pet_fonce:4230:29915778,29910021:pet_fonce:4230:29916004,29910023:pet_fonce:4230:29917733,29910026:pet_fonce:4230:29916412,29910030:pet_fonce:4230:29916087,29910034:pet_fonce:4230:29916132,29910038:pet_fonce:4230:29915920,29910041:pet_fonce:4230:29915550,29910045:pet_fonce:4230:29915685,29910068:pet_fonce:4230:29915114,29910075:pet_fonce:4230:29914932,29910077:pet_fonce:4230:29915203,29910080:pet_fonce:4230:29914759,29910083:pet_fonce:4230:29914582,29910085:pet_fonce:4230:29914483,29910088:pet_fonce:4230:29914413,29910090:pet_fonce:4230:29914085,2'}), 'main_stat': {'nb_photos': 2013}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30124540,30124541,30124542,30124543,30124544,30124545,30124546?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.7693621927394285),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2013,),), 'unwanted_material_monthly_percentage': ((0.7693621927394285,),), 'material_repartition': (('incineration', 2013),), 'material_dict': {'incineration': 2013}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7241403322256932, 2), (datetime.date(2026, 1, 16), 0.712559000098445, 3), (datetime.date(2026, 1, 17), 0.7397620549632145, 4), (datetime.date(2026, 1, 18), 0.8190281688151947, 2), (datetime.date(2026, 1, 19), 0.7998521751340665, 4), (datetime.date(2026, 1, 20), 0.7837810869293727, 1), (datetime.date(2026, 1, 21), 0.7341416458187252, 1), (datetime.date(2026, 1, 22), 0.7213245265687724, 2), (datetime.date(2026, 1, 23), 0.7376341294901849, 3), (datetime.date(2026, 1, 24), 0.7811841186937545, 2), (datetime.date(2026, 1, 25), 0.7891713010514773, 2), (datetime.date(2026, 1, 26), 0.7890960199954612, 3), (datetime.date(2026, 1, 27), 0.7646194262562904, 1), (datetime.date(2026, 1, 28), 0.7667175206489267, 1), (datetime.date(2026, 1, 29), 0.7624872697853409, 4), (datetime.date(2026, 1, 30), 0.7322871407392194, 4), (datetime.date(2026, 1, 31), 0.7819774399738414, 2)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 1, 1), 0.7904757989416431, 4), (datetime.date(2026, 1, 2), 0.7783743324791176, 2), (datetime.date(2026, 1, 3), 0.76554129704722, 3), (datetime.date(2026, 1, 4), 0.8002954499840572, 3), (datetime.date(2026, 1, 5), 0.7700890659650086, 2), (datetime.date(2026, 1, 6), 0.7760390903352083, 3), (datetime.date(2026, 1, 7), 0.7604153327358727, 4), (datetime.date(2026, 1, 8), 0.7322867215322855, 3), (datetime.date(2026, 1, 9), 0.7636780812295932, 1), (datetime.date(2026, 1, 10), 0.8043365440951227, 3), (datetime.date(2026, 1, 11), 0.7903717173044662, 3), (datetime.date(2026, 1, 12), 0.8030408732297779, 4), (datetime.date(2026, 1, 13), 0.7759601895744425, 4), (datetime.date(2026, 1, 14), 0.7825917008337538, 3), (datetime.date(2026, 1, 15), 0.7241403322256932, 2), (datetime.date(2026, 1, 16), 0.712559000098445, 3), (datetime.date(2026, 1, 17), 0.7397620549632145, 4), (datetime.date(2026, 1, 18), 0.8190281688151947, 2), (datetime.date(2026, 1, 19), 0.7998521751340665, 4), (datetime.date(2026, 1, 20), 0.7837810869293727, 1), (datetime.date(2026, 1, 21), 0.7341416458187252, 1), (datetime.date(2026, 1, 22), 0.7213245265687724, 2), (datetime.date(2026, 1, 23), 0.7376341294901849, 3), (datetime.date(2026, 1, 24), 0.7811841186937545, 2), (datetime.date(2026, 1, 25), 0.7891713010514773, 2), (datetime.date(2026, 1, 26), 0.7890960199954612, 3), (datetime.date(2026, 1, 27), 0.7646194262562904, 1), (datetime.date(2026, 1, 28), 0.7667175206489267, 1), (datetime.date(2026, 1, 29), 0.7624872697853409, 4), (datetime.date(2026, 1, 30), 0.7322871407392194, 4), (datetime.date(2026, 1, 31), 0.7819774399738414, 2))}, 'quality_array': [['-7.1461397154465045', '01012026'], ['-6.790631642374837', '02012026'], ['-6.950659734975454', '03012026'], ['-6.932661919079431', '04012026'], ['-6.4842697940755265', '05012026'], ['-6.141143744328462', '06012026'], ['-6.687664593091492', '07012026'], ['-6.913470589711381', '08012026'], ['-7.3127044487476045', '09012026'], ['-7.270751854397152', '10012026'], ['-6.829435540902781', '11012026'], ['-7.10091400510139', '12012026'], ['-7.2419920685407755', '13012026'], ['-7.425190751008745', '14012026'], ['-7.2563729081258375', '15012026'], ['-7.226726912552739', '16012026'], ['-7.1511374059246755', '17012026'], ['-6.914782270979785', '18012026'], ['-6.56595035098907', '19012026'], ['-6.614758775135202', '20012026'], ['-6.702746738059033', '21012026'], ['-6.530975912044781', '22012026'], ['-6.885882918397778', '23012026'], ['-6.8292950973146045', '24012026'], ['-6.957917031421825', '25012026'], ['-6.475779732120948', '26012026'], ['-6.728141588750844', '27012026'], ['-7.357444828971857', '28012026'], ['-7.131372503769199', '29012026'], ['-7.042417779309024', '30012026'], ['-7.057327898353387', '31012026']], 'number_of_batch': ((720,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014047082417180294, 'nb_photo': 17372, 'list_port_cont': '29873144,29873174,29873323,29873432,29873473,29873540,29873571,29873724,29873772,29873801,29873830,29873891,29873935,29874008,29874088,29874158,29874176,29874220,29874264,29874336,29874351,29874413,29874447,29874612,29913277,29913576,29913899,29913997,29914072,29914118,29914430,29914491,29914575,29914739,29914918,29915116,29915187,29915234,29915356,29915539,29915680,29915759,29915931,29916009,29916078,29916122,29916404,29917724,29935040,29936099,29936147,29936174,29936202,29936275,29936319,29936359,29936434,29936469,29936504,29936688,29936796,29936832,29936907,29936982,29937051,29937097,29937232,29937278,29937342,29937372,29937460,29937497,29941299,29941328,29941377,29941414,29941434,29941476,29941522,29941555,29941560,29941652,29941701,29941727,29941762,29941803,29941842,29941880,29941919,29941945,29942067,29942077,29942267,29942425,29942834,29942973,29976492,29977861,29977926,29977967,29978022,29978069,29978128,29978220,29978279,29978330,29978369,29978465,29978479,29978531,29978570,29978649,29978742,2997877', 'assoc_port': '29872026:29874336,29872028:29874447,29872030:29874413,29872032:29874264,29872034:29874351,29872036:29874176,29872037:29874088,29872041:29874158,29872043:29873935,29872045:29874220,29872048:29873891,29872051:29874008,29872056:29873772,29872059:29873724,29872060:29873830,29872063:29873801,29872066:29873473,29872071:29873540,29872072:29873323,29872074:29873432,29872076:29873174,29872078:29873144,29873351:29873571,29874583:29874612,29910018:29915759,29910021:29916009,29910023:29917724,29910026:29916404,29910030:29916078,29910034:29916122,29910038:29915931,29910041:29915539,29910045:29915680,29910050:29915356,29910054:29915234,29910068:29915116,29910075:29914918,29910077:29915187,29910080:29914739,29910083:29914575,29910085:29914491,29910088:29914430,29910090:29914072,29910092:29913997,29910106:29914118,29910120:29913899,29910122:29913576,29912892:29913277,29934942:29937342,29934944:29937497,29934946:29937460,29934949:29937278,29934952:29937372,29934955:29937232,29934957:29936982,29934960:29937051,29934963:2993690', 'assoc_mat': '29872026:autre:4230:29874336,29872028:autre:4230:29874447,29872030:autre:4230:29874413,29872032:autre:4230:29874264,29872034:autre:4230:29874351,29872036:autre:4230:29874176,29872037:autre:4230:29874088,29872041:autre:4230:29874158,29872043:autre:4230:29873935,29872045:autre:4230:29874220,29872048:autre:4230:29873891,29872051:autre:4230:29874008,29872056:autre:4230:29873772,29872059:autre:4230:29873724,29872060:autre:4230:29873830,29872063:autre:4230:29873801,29872066:autre:4230:29873473,29872071:autre:4230:29873540,29872072:autre:4230:29873323,29872074:autre:4230:29873432,29872076:autre:4230:29873174,29872078:autre:4230:29873144,29873351:autre:4230:29873571,29874583:autre:4230:29874612,29910018:autre:4230:29915759,29910021:autre:4230:29916009,29910023:autre:4230:29917724,29910026:autre:4230:29916404,29910030:autre:4230:29916078,29910034:autre:4230:29916122,29910038:autre:4230:29915931,29910041:autre:4230:29915539,29910045:autre:4230:29915680,29910050:autre:4230:29915356,29910054:autre:4230:29915234,29910068:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.040677685776631826, 'nb_photo': 87213, 'list_port_cont': '29873142,29873173,29873314,29873443,29873474,29873549,29873574,29873727,29873765,29873810,29873838,29873905,29873937,29874014,29874087,29874161,29874173,29874230,29874270,29874342,29874357,29874406,29874443,29874621,29913268,29913589,29913910,29914002,29914078,29914115,29914435,29914492,29914570,29914756,29914931,29915113,29915200,29915233,29915370,29915555,29915681,29915779,29915932,29916016,29916088,29916135,29916402,29917732,29935050,29936106,29936136,29936179,29936215,29936289,29936322,29936351,29936433,29936475,29936509,29936685,29936801,29936831,29936910,29936980,29937058,29937095,29937236,29937277,29937350,29937383,29937462,29937485,29941296,29941327,29941373,29941415,29941451,29941482,29941516,29941551,29941577,29941664,29941693,29941729,29941755,29941812,29941846,29941885,29941918,29941950,29942062,29942087,29942266,29942429,29942833,29942978,29976491,29977870,29977916,29977958,29978031,29978081,29978141,29978213,29978287,29978324,29978378,29978470,29978481,29978548,29978582,29978658,29978749,2997878', 'assoc_port': '29872026:29874342,29872028:29874443,29872030:29874406,29872032:29874270,29872034:29874357,29872036:29874173,29872037:29874087,29872041:29874161,29872043:29873937,29872045:29874230,29872048:29873905,29872051:29874014,29872056:29873765,29872059:29873727,29872060:29873838,29872063:29873810,29872066:29873474,29872071:29873549,29872072:29873314,29872074:29873443,29872076:29873173,29872078:29873142,29873351:29873574,29874583:29874621,29910018:29915779,29910021:29916016,29910023:29917732,29910026:29916402,29910030:29916088,29910034:29916135,29910038:29915932,29910041:29915555,29910045:29915681,29910050:29915370,29910054:29915233,29910068:29915113,29910075:29914931,29910077:29915200,29910080:29914756,29910083:29914570,29910085:29914492,29910088:29914435,29910090:29914078,29910092:29914002,29910106:29914115,29910120:29913910,29910122:29913589,29912892:29913268,29934942:29937350,29934944:29937485,29934946:29937462,29934949:29937277,29934952:29937383,29934955:29937236,29934957:29936980,29934960:29937058,29934963:2993691', 'assoc_mat': '29872026:carton:4230:29874342,29872028:carton:4230:29874443,29872030:carton:4230:29874406,29872032:carton:4230:29874270,29872034:carton:4230:29874357,29872036:carton:4230:29874173,29872037:carton:4230:29874087,29872041:carton:4230:29874161,29872043:carton:4230:29873937,29872045:carton:4230:29874230,29872048:carton:4230:29873905,29872051:carton:4230:29874014,29872056:carton:4230:29873765,29872059:carton:4230:29873727,29872060:carton:4230:29873838,29872063:carton:4230:29873810,29872066:carton:4230:29873474,29872071:carton:4230:29873549,29872072:carton:4230:29873314,29872074:carton:4230:29873443,29872076:carton:4230:29873173,29872078:carton:4230:29873142,29873351:carton:4230:29873574,29874583:carton:4230:29874621,29910018:carton:4230:29915779,29910021:carton:4230:29916016,29910023:carton:4230:29917732,29910026:carton:4230:29916402,29910030:carton:4230:29916088,29910034:carton:4230:29916135,29910038:carton:4230:29915932,29910041:carton:4230:29915555,29910045:carton:4230:29915681,29910050:carton:4230:29915370,2991'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00148242817893768, 'nb_photo': 1977, 'list_port_cont': '29873134,29873172,29873325,29873427,29873471,29873539,29873732,29873759,29873796,29873834,29873894,29873941,29874001,29874089,29874162,29874179,29874222,29874261,29874329,29874353,29874400,29874624,29913266,29913583,29913996,29914088,29914120,29914405,29914755,29915105,29915194,29915362,29915547,29915679,29915926,29916094,29916128,29916409,29935038,29936101,29936182,29936216,29936312,29936354,29936424,29936467,29936689,29936823,29936905,29936978,29937052,29937098,29937229,29937273,29937352,29937379,29937452,29941371,29941401,29941444,29941475,29941544,29941563,29941665,29941695,29941735,29941807,29941834,29941876,29941961,29942066,29942072,29942264,29942430,29976484,29977866,29977919,29977966,29978023,29978066,29978145,29978216,29978289,29978335,29978367,29978460,29978487,29978543,29978580,29978659,29978740,29978820,29979035,29979061,29979408,29979469,29992143,29993628,29993958,29994271,29994467,29994588,29995020,29995129,29995398,29995663,29995950,29996349,29996961,29996990,29997845,29997908,29999168,3000047', 'assoc_port': '29872026:29874329,29872030:29874400,29872032:29874261,29872034:29874353,29872036:29874179,29872037:29874089,29872041:29874162,29872043:29873941,29872045:29874222,29872048:29873894,29872051:29874001,29872056:29873759,29872059:29873732,29872060:29873834,29872063:29873796,29872066:29873471,29872071:29873539,29872072:29873325,29872074:29873427,29872076:29873172,29872078:29873134,29874583:29874624,29910026:29916409,29910030:29916094,29910034:29916128,29910038:29915926,29910041:29915547,29910045:29915679,29910050:29915362,29910068:29915105,29910077:29915194,29910080:29914755,29910088:29914405,29910090:29914088,29910092:29913996,29910106:29914120,29910122:29913583,29912892:29913266,29934942:29937352,29934946:29937452,29934949:29937273,29934952:29937379,29934955:29937229,29934957:29936978,29934960:29937052,29934963:29936905,29934965:29936823,29934971:29936689,29934973:29936354,29934975:29936424,29934977:29936467,29934979:29936216,29934981:29936312,29934989:29936101,29934993:29936182,29934995:29935038,29936860:2993709', 'assoc_mat': '29872026:metal:4230:29874329,29872030:metal:4230:29874400,29872032:metal:4230:29874261,29872034:metal:4230:29874353,29872036:metal:4230:29874179,29872037:metal:4230:29874089,29872041:metal:4230:29874162,29872043:metal:4230:29873941,29872045:metal:4230:29874222,29872048:metal:4230:29873894,29872051:metal:4230:29874001,29872056:metal:4230:29873759,29872059:metal:4230:29873732,29872060:metal:4230:29873834,29872063:metal:4230:29873796,29872066:metal:4230:29873471,29872071:metal:4230:29873539,29872072:metal:4230:29873325,29872074:metal:4230:29873427,29872076:metal:4230:29873172,29872078:metal:4230:29873134,29874583:metal:4230:29874624,29910026:metal:4230:29916409,29910030:metal:4230:29916094,29910034:metal:4230:29916128,29910038:metal:4230:29915926,29910041:metal:4230:29915547,29910045:metal:4230:29915679,29910050:metal:4230:29915362,29910068:metal:4230:29915105,29910077:metal:4230:29915194,29910080:metal:4230:29914755,29910088:metal:4230:29914405,29910090:metal:4230:29914088,29910092:metal:4230:29913996,29910106:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.16215618379631866, 'nb_photo': 299916, 'list_port_cont': '29873146,29873171,29873328,29873434,29873472,29873555,29873568,29873734,29873768,29873806,29873844,29873903,29873939,29874018,29874085,29874148,29874178,29874228,29874268,29874331,29874356,29874415,29874440,29874623,29913270,29913581,29913901,29914004,29914089,29914119,29914426,29914494,29914576,29914752,29914930,29915112,29915199,29915232,29915366,29915548,29915692,29915773,29915930,29916008,29916085,29916136,29916415,29917730,29935052,29936098,29936135,29936178,29936210,29936290,29936318,29936358,29936438,29936471,29936511,29936693,29936793,29936838,29936914,29936981,29937059,29937092,29937235,29937274,29937349,29937385,29937461,29937491,29941305,29941342,29941378,29941408,29941441,29941480,29941521,29941550,29941567,29941662,29941698,29941740,29941753,29941808,29941845,29941882,29941921,29941957,29942065,29942085,29942259,29942422,29942829,29942972,29976490,29977873,29977922,29977962,29978026,29978078,29978131,29978214,29978294,29978331,29978372,29978467,29978493,29978544,29978584,29978657,29978746,2997878', 'assoc_port': '29872026:29874331,29872028:29874440,29872030:29874415,29872032:29874268,29872034:29874356,29872036:29874178,29872037:29874085,29872041:29874148,29872043:29873939,29872045:29874228,29872048:29873903,29872051:29874018,29872056:29873768,29872059:29873734,29872060:29873844,29872063:29873806,29872066:29873472,29872071:29873555,29872072:29873328,29872074:29873434,29872076:29873171,29872078:29873146,29873351:29873568,29874583:29874623,29910018:29915773,29910021:29916008,29910023:29917730,29910026:29916415,29910030:29916085,29910034:29916136,29910038:29915930,29910041:29915548,29910045:29915692,29910050:29915366,29910054:29915232,29910068:29915112,29910075:29914930,29910077:29915199,29910080:29914752,29910083:29914576,29910085:29914494,29910088:29914426,29910090:29914089,29910092:29914004,29910106:29914119,29910120:29913901,29910122:29913581,29912892:29913270,29934942:29937349,29934944:29937491,29934946:29937461,29934949:29937274,29934952:29937385,29934955:29937235,29934957:29936981,29934960:29937059,29934963:2993691', 'assoc_mat': '29872026:papier:4230:29874331,29872028:papier:4230:29874440,29872030:papier:4230:29874415,29872032:papier:4230:29874268,29872034:papier:4230:29874356,29872036:papier:4230:29874178,29872037:papier:4230:29874085,29872041:papier:4230:29874148,29872043:papier:4230:29873939,29872045:papier:4230:29874228,29872048:papier:4230:29873903,29872051:papier:4230:29874018,29872056:papier:4230:29873768,29872059:papier:4230:29873734,29872060:papier:4230:29873844,29872063:papier:4230:29873806,29872066:papier:4230:29873472,29872071:papier:4230:29873555,29872072:papier:4230:29873328,29872074:papier:4230:29873434,29872076:papier:4230:29873171,29872078:papier:4230:29873146,29873351:papier:4230:29873568,29874583:papier:4230:29874623,29910018:papier:4230:29915773,29910021:papier:4230:29916008,29910023:papier:4230:29917730,29910026:papier:4230:29916415,29910030:papier:4230:29916085,29910034:papier:4230:29916136,29910038:papier:4230:29915930,29910041:papier:4230:29915548,29910045:papier:4230:29915692,29910050:papier:4230:29915366,2991'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0028902969187158114, 'nb_photo': 1581, 'list_port_cont': '29873137,29873178,29873322,29873440,29873552,29873565,29873840,29873940,29874009,29874081,29874174,29874234,29874345,29874360,29874412,29874628,29913281,29913588,29913911,29914083,29914124,29914493,29914583,29914747,29914922,29915117,29915196,29915231,29915367,29915553,29915693,29915774,29915927,29935054,29936105,29936146,29936170,29936219,29936291,29936326,29936364,29936435,29936474,29936694,29936803,29936829,29936900,29937060,29937087,29937281,29937353,29937453,29941413,29941518,29941758,29941809,29941917,29942057,29942078,29942263,29942421,29942840,29976494,29977877,29977918,29977968,29978032,29978080,29978144,29978212,29978292,29978339,29978382,29978471,29978485,29978539,29978579,29978663,29978747,29979420,29979467,29993630,29993957,29994148,29994582,29995122,29995677,29995960,29996431,29996662,29996992,29997412,29997527,29997853,29998052,30000486,30032130,30032582,30032887,30034890,30035135,30035374,30035680,30035898,30036109,30036239,30036362,30036595,30036881,30036989,30037176,30037363,30039551,3003961', 'assoc_port': '29872026:29874345,29872030:29874412,29872034:29874360,29872036:29874174,29872037:29874081,29872043:29873940,29872045:29874234,29872051:29874009,29872060:29873840,29872071:29873552,29872072:29873322,29872074:29873440,29872076:29873178,29872078:29873137,29873351:29873565,29874583:29874628,29910018:29915774,29910038:29915927,29910041:29915553,29910045:29915693,29910050:29915367,29910054:29915231,29910068:29915117,29910075:29914922,29910077:29915196,29910080:29914747,29910083:29914583,29910085:29914493,29910090:29914083,29910106:29914124,29910120:29913911,29910122:29913588,29912892:29913281,29934942:29937353,29934946:29937453,29934949:29937281,29934960:29937060,29934963:29936900,29934965:29936829,29934967:29936803,29934971:29936694,29934973:29936364,29934975:29936435,29934977:29936474,29934979:29936219,29934981:29936326,29934984:29936291,29934986:29936146,29934989:29936105,29934993:29936170,29934995:29935054,29936860:29937087,29941172:29942421,29941175:29942078,29941176:29942263,29941178:29942057,29941193:2994191', 'assoc_mat': '29872026:pehd:4230:29874345,29872030:pehd:4230:29874412,29872034:pehd:4230:29874360,29872036:pehd:4230:29874174,29872037:pehd:4230:29874081,29872043:pehd:4230:29873940,29872045:pehd:4230:29874234,29872051:pehd:4230:29874009,29872060:pehd:4230:29873840,29872071:pehd:4230:29873552,29872072:pehd:4230:29873322,29872074:pehd:4230:29873440,29872076:pehd:4230:29873178,29872078:pehd:4230:29873137,29873351:pehd:4230:29873565,29874583:pehd:4230:29874628,29910018:pehd:4230:29915774,29910038:pehd:4230:29915927,29910041:pehd:4230:29915553,29910045:pehd:4230:29915693,29910050:pehd:4230:29915367,29910054:pehd:4230:29915231,29910068:pehd:4230:29915117,29910075:pehd:4230:29914922,29910077:pehd:4230:29915196,29910080:pehd:4230:29914747,29910083:pehd:4230:29914583,29910085:pehd:4230:29914493,29910090:pehd:4230:29914083,29910106:pehd:4230:29914124,29910120:pehd:4230:29913911,29910122:pehd:4230:29913588,29912892:pehd:4230:29913281,29934942:pehd:4230:29937353,29934946:pehd:4230:29937453,29934949:pehd:4230:29937281,29934960:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.023127454673713348, 'nb_photo': 33253, 'list_port_cont': '29873145,29873175,29873324,29873438,29873467,29873550,29873569,29873728,29873773,29873803,29873841,29873901,29873938,29874015,29874083,29874150,29874168,29874229,29874258,29874341,29874362,29874417,29874451,29874627,29913275,29913580,29913904,29914001,29914084,29914122,29914415,29914490,29914573,29914750,29914923,29915115,29915197,29915235,29915369,29915551,29915688,29915771,29915919,29916005,29916091,29916134,29916406,29917731,29935055,29936110,29936140,29936180,29936212,29936285,29936328,29936357,29936440,29936465,29936500,29936681,29936794,29936837,29936906,29936985,29937049,29937091,29937242,29937276,29937346,29937389,29937457,29937498,29941302,29941336,29941368,29941409,29941450,29941487,29941520,29941556,29941575,29941666,29941702,29941737,29941764,29941806,29941841,29941881,29941913,29941959,29942069,29942088,29942265,29942419,29942837,29942974,29976495,29977876,29977920,29977964,29978027,29978074,29978146,29978215,29978295,29978338,29978379,29978461,29978499,29978546,29978575,29978656,29978750,2997878', 'assoc_port': '29872026:29874341,29872028:29874451,29872030:29874417,29872032:29874258,29872034:29874362,29872036:29874168,29872037:29874083,29872041:29874150,29872043:29873938,29872045:29874229,29872048:29873901,29872051:29874015,29872056:29873773,29872059:29873728,29872060:29873841,29872063:29873803,29872066:29873467,29872071:29873550,29872072:29873324,29872074:29873438,29872076:29873175,29872078:29873145,29873351:29873569,29874583:29874627,29910018:29915771,29910021:29916005,29910023:29917731,29910026:29916406,29910030:29916091,29910034:29916134,29910038:29915919,29910041:29915551,29910045:29915688,29910050:29915369,29910054:29915235,29910068:29915115,29910075:29914923,29910077:29915197,29910080:29914750,29910083:29914573,29910085:29914490,29910088:29914415,29910090:29914084,29910092:29914001,29910106:29914122,29910120:29913904,29910122:29913580,29912892:29913275,29934942:29937346,29934944:29937498,29934946:29937457,29934949:29937276,29934952:29937389,29934955:29937242,29934957:29936985,29934960:29937049,29934963:2993690', 'assoc_mat': '29872026:pet_clair:4230:29874341,29872028:pet_clair:4230:29874451,29872030:pet_clair:4230:29874417,29872032:pet_clair:4230:29874258,29872034:pet_clair:4230:29874362,29872036:pet_clair:4230:29874168,29872037:pet_clair:4230:29874083,29872041:pet_clair:4230:29874150,29872043:pet_clair:4230:29873938,29872045:pet_clair:4230:29874229,29872048:pet_clair:4230:29873901,29872051:pet_clair:4230:29874015,29872056:pet_clair:4230:29873773,29872059:pet_clair:4230:29873728,29872060:pet_clair:4230:29873841,29872063:pet_clair:4230:29873803,29872066:pet_clair:4230:29873467,29872071:pet_clair:4230:29873550,29872072:pet_clair:4230:29873324,29872074:pet_clair:4230:29873438,29872076:pet_clair:4230:29873175,29872078:pet_clair:4230:29873145,29873351:pet_clair:4230:29873569,29874583:pet_clair:4230:29874627,29910018:pet_clair:4230:29915771,29910021:pet_clair:4230:29916005,29910023:pet_clair:4230:29917731,29910026:pet_clair:4230:29916406,29910030:pet_clair:4230:29916091,29910034:pet_clair:4230:29916134,29910038:pet_clair:4230:29915919,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024872076517107565, 'nb_photo': 787, 'list_port_cont': '29873180,29873318,29873477,29873554,29873733,29873804,29873900,29874086,29874175,29874332,29874361,29874414,29874453,29874626,29913585,29913906,29914085,29914127,29914413,29914483,29914582,29914759,29914932,29915114,29915203,29915550,29915685,29915778,29915920,29916004,29916087,29916132,29916412,29917733,29936143,29936181,29936213,29936280,29936325,29936362,29936437,29936476,29936513,29936690,29936800,29936828,29936908,29937083,29937279,29937351,29937388,29937449,29937487,29941412,29941439,29941557,29941574,29941760,29941844,29941914,29941954,29942082,29942826,29942976,29977865,29977923,29977957,29978296,29978336,29978381,29978489,29978545,29978666,29979070,29979413,29979465,29993963,29994585,29995035,29995964,29996428,29996667,29996995,29997530,29997841,29997903,30032136,30034412,30034555,30034886,30035677,30035902,30036108,30036243,30036361,30036880,30036975,30037359,30060936,30061011,30061058,30061096,30061193,30061265,30061329,30061375,30061405,30061452,30061517,30061550,30061596,30061621,30061820,3006188', 'assoc_port': '29872026:29874332,29872028:29874453,29872030:29874414,29872034:29874361,29872036:29874175,29872037:29874086,29872048:29873900,29872059:29873733,29872063:29873804,29872066:29873477,29872071:29873554,29872072:29873318,29872076:29873180,29874583:29874626,29910018:29915778,29910021:29916004,29910023:29917733,29910026:29916412,29910030:29916087,29910034:29916132,29910038:29915920,29910041:29915550,29910045:29915685,29910068:29915114,29910075:29914932,29910077:29915203,29910080:29914759,29910083:29914582,29910085:29914483,29910088:29914413,29910090:29914085,29910106:29914127,29910120:29913906,29910122:29913585,29934942:29937351,29934944:29937487,29934946:29937449,29934949:29937279,29934952:29937388,29934963:29936908,29934965:29936828,29934967:29936800,29934969:29936513,29934971:29936690,29934973:29936362,29934975:29936437,29934977:29936476,29934979:29936213,29934981:29936325,29934984:29936280,29934986:29936143,29934993:29936181,29936860:29937083,29941175:29942082,29941180:29941954,29941182:29941844,29941193:2994191', 'assoc_mat': '29872026:pet_fonce:4230:29874332,29872028:pet_fonce:4230:29874453,29872030:pet_fonce:4230:29874414,29872034:pet_fonce:4230:29874361,29872036:pet_fonce:4230:29874175,29872037:pet_fonce:4230:29874086,29872048:pet_fonce:4230:29873900,29872059:pet_fonce:4230:29873733,29872063:pet_fonce:4230:29873804,29872066:pet_fonce:4230:29873477,29872071:pet_fonce:4230:29873554,29872072:pet_fonce:4230:29873318,29872076:pet_fonce:4230:29873180,29874583:pet_fonce:4230:29874626,29910018:pet_fonce:4230:29915778,29910021:pet_fonce:4230:29916004,29910023:pet_fonce:4230:29917733,29910026:pet_fonce:4230:29916412,29910030:pet_fonce:4230:29916087,29910034:pet_fonce:4230:29916132,29910038:pet_fonce:4230:29915920,29910041:pet_fonce:4230:29915550,29910045:pet_fonce:4230:29915685,29910068:pet_fonce:4230:29915114,29910075:pet_fonce:4230:29914932,29910077:pet_fonce:4230:29915203,29910080:pet_fonce:4230:29914759,29910083:pet_fonce:4230:29914582,29910085:pet_fonce:4230:29914483,29910088:pet_fonce:4230:29914413,29910090:pet_fonce:4230:29914085,2'}), 'main_stat': {'nb_photos': 2013}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30124540,30124541,30124542,30124543,30124544,30124545,30124546?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-01', 0.7693621927394285),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_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', '1.4%', 17372], 'carton': ['carton', '4.07%', 87213], 'metal': ['metal', '0.15%', 1977], 'papier': ['papier', '16.22%', 299916], 'pehd': ['pehd', '0.29%', 1581], 'pet_clair': ['pet_clair', '2.31%', 33253], 'pet_fonce': ['pet_fonce', '0.25%', 787]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_01_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.48user 2.56system 0:10.01elapsed 50%CPU (0avgtext+0avgdata 182256maxresident)k 8inputs+304outputs (0major+48703minor)pagefaults 0swaps