python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-07 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (2, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (2, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 07 mtr_id : dashboard_places : SCCU_cam6 date : 2026-07 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_cam6' and date like '%2026-07%') and created_at like '%2026-07%'))); nb_day : (2, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 07 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 = 202 and month(ded.date) = 07 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 = 202 and mp.name like '%072026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-07-01 : dt_date_just_month_year : 2026-07-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-07-01" AND ded.date <= "2026-07-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 (3006640,3006766,3007536,3008136,3008416,3009168,3009764,3010304,3010780,3011400,3011970,3012306,3012848,3013522,3014188,3014844,3015400,3015952,3016188) 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.0128043338788159, 'nb_photo': 9884, 'list_port_cont': '31204673,31204703,31204755,31204792,31204838,31204885,31204919,31204959,31204997,31205055,31205086,31205132,31205168,31205253,31205305,31205334,31205373,31205404,31205457,31205515,31205543,31205577,31205615,31209885,31209916,31209977,31210043,31210089,31210138,31210195,31210239,31210312,31210345,31210399,31210448,31210543,31211567,31211605,31211649,31211693,31211741,31211784,31213066,31213135,31213184,31213269,31213511,31213545,31213590,31213628,31213676,31213713,31213755,31213805,31213858,31213903,31213944,31214905,31214933,31214992,31215033,31215528,31215560,31215647,31216031,31216198,31216234,31216621,31216773,31217024,31217281,31217461,31217739,31217957,31218256,31218492,31218767,31219081,31219435,31219632,31219837,31220165,31220440,31220703,31220939,31221231,31221416,31221696,31221963,31222228,31222458,31222492,31222919,31223122,31223403,31223636,31223939,31224195,31224386,31224618,31224841,31225060,31225381,31225971,31226049,31226483,31226859,31226905,31227183,31227438,31227813,31228135,31228343,3122858', 'assoc_port': '31202979:31204673,31202980:31204703,31202981:31204755,31202982:31204792,31202983:31204838,31202984:31204885,31202985:31204919,31202986:31204959,31202987:31204997,31202988:31205055,31202989:31205086,31202990:31205132,31202991:31205168,31202993:31205253,31202994:31205305,31202995:31205334,31202996:31205373,31202997:31205404,31202998:31205457,31202999:31205515,31203000:31205577,31203001:31205543,31203002:31205615,31203197:31209885,31203198:31209916,31203199:31213269,31203200:31209977,31203201:31210043,31203202:31210089,31203203:31210138,31203204:31210195,31203205:31210239,31203206:31213066,31203207:31210312,31203208:31213135,31203209:31210345,31203211:31210399,31203212:31210448,31203213:31213184,31203214:31210543,31203489:31211567,31203989:31211605,31204429:31211649,31204539:31211693,31205033:31211741,31205034:31211784,31211809:31213545,31211810:31213511,31211811:31213590,31211812:31213628,31211813:31213676,31211815:31213713,31211816:31213755,31211817:31213805,31211818:31213858,31211819:31213903,31211821:3121394', 'assoc_mat': '31202979:autre:4230:31204673,31202980:autre:4230:31204703,31202981:autre:4230:31204755,31202982:autre:4230:31204792,31202983:autre:4230:31204838,31202984:autre:4230:31204885,31202985:autre:4230:31204919,31202986:autre:4230:31204959,31202987:autre:4230:31204997,31202988:autre:4230:31205055,31202989:autre:4230:31205086,31202990:autre:4230:31205132,31202991:autre:4230:31205168,31202993:autre:4230:31205253,31202994:autre:4230:31205305,31202995:autre:4230:31205334,31202996:autre:4230:31205373,31202997:autre:4230:31205404,31202998:autre:4230:31205457,31202999:autre:4230:31205515,31203000:autre:4230:31205577,31203001:autre:4230:31205543,31203002:autre:4230:31205615,31203197:autre:4230:31209885,31203198:autre:4230:31209916,31203199:autre:4230:31213269,31203200:autre:4230:31209977,31203201:autre:4230:31210043,31203202:autre:4230:31210089,31203203:autre:4230:31210138,31203204:autre:4230:31210195,31203205:autre:4230:31210239,31203206:autre:4230:31213066,31203207:autre:4230:31210312,31203208:autre:4230:31213135,31203209:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03167964940775468, 'nb_photo': 38942, 'list_port_cont': '31204674,31204708,31204763,31204808,31204850,31204889,31204924,31204972,31205002,31205054,31205088,31205134,31205176,31205243,31205302,31205342,31205379,31205417,31205465,31205514,31205553,31205592,31205619,31209884,31209922,31209986,31210050,31210096,31210135,31210190,31210238,31210313,31210349,31210405,31210441,31210548,31211561,31211617,31211657,31211698,31211730,31211781,31213058,31213145,31213192,31213277,31213502,31213542,31213588,31213632,31213681,31213715,31213766,31213812,31213859,31213912,31213946,31214912,31214946,31215001,31215036,31215529,31215566,31215644,31216041,31216199,31216247,31216618,31216788,31217023,31217280,31217462,31217727,31217966,31218252,31218503,31218755,31219092,31219436,31219636,31219839,31220160,31220427,31220712,31220949,31221238,31221428,31221701,31221966,31222236,31222457,31222504,31222907,31223135,31223404,31223638,31223948,31224201,31224392,31224628,31224845,31225067,31225393,31225964,31226043,31226497,31226869,31226902,31227196,31227447,31227814,31228134,31228347,3122858', 'assoc_port': '31202979:31204674,31202980:31204708,31202981:31204763,31202982:31204808,31202983:31204850,31202984:31204889,31202985:31204924,31202986:31204972,31202987:31205002,31202988:31205054,31202989:31205088,31202990:31205134,31202991:31205176,31202993:31205243,31202994:31205302,31202995:31205342,31202996:31205379,31202997:31205417,31202998:31205465,31202999:31205514,31203000:31205592,31203001:31205553,31203002:31205619,31203197:31209884,31203198:31209922,31203199:31213277,31203200:31209986,31203201:31210050,31203202:31210096,31203203:31210135,31203204:31210190,31203205:31210238,31203206:31213058,31203207:31210313,31203208:31213145,31203209:31210349,31203211:31210405,31203212:31210441,31203213:31213192,31203214:31210548,31203489:31211561,31203989:31211617,31204429:31211657,31204539:31211698,31205033:31211730,31205034:31211781,31211809:31213542,31211810:31213502,31211811:31213588,31211812:31213632,31211813:31213681,31211815:31213715,31211816:31213766,31211817:31213812,31211818:31213859,31211819:31213912,31211821:3121394', 'assoc_mat': '31202979:carton:4230:31204674,31202980:carton:4230:31204708,31202981:carton:4230:31204763,31202982:carton:4230:31204808,31202983:carton:4230:31204850,31202984:carton:4230:31204889,31202985:carton:4230:31204924,31202986:carton:4230:31204972,31202987:carton:4230:31205002,31202988:carton:4230:31205054,31202989:carton:4230:31205088,31202990:carton:4230:31205134,31202991:carton:4230:31205176,31202993:carton:4230:31205243,31202994:carton:4230:31205302,31202995:carton:4230:31205342,31202996:carton:4230:31205379,31202997:carton:4230:31205417,31202998:carton:4230:31205465,31202999:carton:4230:31205514,31203000:carton:4230:31205592,31203001:carton:4230:31205553,31203002:carton:4230:31205619,31203197:carton:4230:31209884,31203198:carton:4230:31209922,31203199:carton:4230:31213277,31203200:carton:4230:31209986,31203201:carton:4230:31210050,31203202:carton:4230:31210096,31203203:carton:4230:31210135,31203204:carton:4230:31210190,31203205:carton:4230:31210238,31203206:carton:4230:31213058,31203207:carton:4230:31210313,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011764421498006929, 'nb_photo': 761, 'list_port_cont': '31204793,31204844,31204879,31204973,31204999,31205043,31205089,31205124,31205298,31205325,31205382,31205415,31205450,31205503,31205579,31205626,31209924,31209982,31210044,31210084,31210235,31210305,31210391,31210455,31210541,31211568,31211656,31211691,31211727,31211777,31213069,31213185,31213271,31213546,31213578,31213670,31213710,31213807,31213843,31213909,31213934,31214898,31214949,31215000,31215027,31215512,31215569,31215639,31216042,31216200,31216235,31217031,31217267,31217463,31217738,31217961,31218491,31218764,31219095,31219431,31219622,31219832,31220158,31220438,31220705,31220947,31221240,31221417,31221699,31221973,31222235,31222500,31222909,31224194,31224387,31224630,31224840,31225070,31225389,31225957,31226493,31226855,31226909,31227195,31227443,31227805,31228133,31228349,31228587,31228915,31229545,31229829,31230111,31230382,31230910,31231403,31231913,31232096,31232398,31232846,31233167,31233870,31234196,31234766,31235660,31236051,31236317,31236552,31237002,31237112,31237417,31237705,31238038,3123833', 'assoc_port': '31202982:31204793,31202983:31204844,31202984:31204879,31202986:31204973,31202987:31204999,31202988:31205043,31202989:31205089,31202990:31205124,31202994:31205298,31202995:31205325,31202996:31205382,31202997:31205415,31202998:31205450,31202999:31205503,31203000:31205579,31203002:31205626,31203198:31209924,31203199:31213271,31203200:31209982,31203201:31210044,31203202:31210084,31203205:31210235,31203206:31213069,31203207:31210305,31203211:31210391,31203212:31210455,31203213:31213185,31203214:31210541,31203489:31211568,31204429:31211656,31204539:31211691,31205033:31211727,31205034:31211777,31211809:31213546,31211811:31213578,31211813:31213670,31211815:31213710,31211817:31213807,31211818:31213843,31211819:31213909,31211821:31213934,31214509:31214898,31214510:31216042,31214511:31214949,31214512:31215000,31214513:31215027,31215317:31215512,31215318:31215569,31215319:31215639,31215807:31216200,31215809:31216235,31216867:31217031,31217189:31217267,31217419:31217463,31217685:31217738,31217918:31217961,31218466:3121849', 'assoc_mat': '31202982:metal:4230:31204793,31202983:metal:4230:31204844,31202984:metal:4230:31204879,31202986:metal:4230:31204973,31202987:metal:4230:31204999,31202988:metal:4230:31205043,31202989:metal:4230:31205089,31202990:metal:4230:31205124,31202994:metal:4230:31205298,31202995:metal:4230:31205325,31202996:metal:4230:31205382,31202997:metal:4230:31205415,31202998:metal:4230:31205450,31202999:metal:4230:31205503,31203000:metal:4230:31205579,31203002:metal:4230:31205626,31203198:metal:4230:31209924,31203199:metal:4230:31213271,31203200:metal:4230:31209982,31203201:metal:4230:31210044,31203202:metal:4230:31210084,31203205:metal:4230:31210235,31203206:metal:4230:31213069,31203207:metal:4230:31210305,31203211:metal:4230:31210391,31203212:metal:4230:31210455,31203213:metal:4230:31213185,31203214:metal:4230:31210541,31203489:metal:4230:31211568,31204429:metal:4230:31211656,31204539:metal:4230:31211691,31205033:metal:4230:31211727,31205034:metal:4230:31211777,31211809:metal:4230:31213546,31211811:metal:4230:31213578,31211813:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19162503622535962, 'nb_photo': 198148, 'list_port_cont': '31204678,31204712,31204761,31204806,31204843,31204888,31204915,31204971,31205005,31205056,31205096,31205141,31205170,31205216,31205250,31205299,31205336,31205377,31205410,31205461,31205505,31205556,31205589,31205625,31209881,31209911,31209979,31210052,31210090,31210133,31210192,31210245,31210311,31210358,31210398,31210452,31210551,31211565,31211616,31211651,31211703,31211743,31211786,31213071,31213143,31213190,31213270,31213515,31213551,31213582,31213627,31213683,31213714,31213752,31213817,31213854,31213907,31213942,31214903,31214935,31214999,31215029,31215525,31215567,31215654,31216035,31216206,31216237,31216610,31216784,31217022,31217279,31217460,31217734,31217965,31218251,31218488,31218760,31219093,31219439,31219634,31219840,31220163,31220432,31220704,31220952,31221234,31221431,31221702,31221974,31222230,31222456,31222502,31222920,31223139,31223402,31223633,31223949,31224209,31224395,31224619,31224846,31225073,31225386,31225968,31226047,31226496,31226866,31226915,31227181,31227442,31227808,31228131,3122835', 'assoc_port': '31202979:31204678,31202980:31204712,31202981:31204761,31202982:31204806,31202983:31204843,31202984:31204888,31202985:31204915,31202986:31204971,31202987:31205005,31202988:31205056,31202989:31205096,31202990:31205141,31202991:31205170,31202992:31205216,31202993:31205250,31202994:31205299,31202995:31205336,31202996:31205377,31202997:31205410,31202998:31205461,31202999:31205505,31203000:31205589,31203001:31205556,31203002:31205625,31203197:31209881,31203198:31209911,31203199:31213270,31203200:31209979,31203201:31210052,31203202:31210090,31203203:31210133,31203204:31210192,31203205:31210245,31203206:31213071,31203207:31210311,31203208:31213143,31203209:31210358,31203211:31210398,31203212:31210452,31203213:31213190,31203214:31210551,31203489:31211565,31203989:31211616,31204429:31211651,31204539:31211703,31205033:31211743,31205034:31211786,31211809:31213551,31211810:31213515,31211811:31213582,31211812:31213627,31211813:31213683,31211815:31213714,31211816:31213752,31211817:31213817,31211818:31213854,31211819:3121390', 'assoc_mat': '31202979:papier:4230:31204678,31202980:papier:4230:31204712,31202981:papier:4230:31204761,31202982:papier:4230:31204806,31202983:papier:4230:31204843,31202984:papier:4230:31204888,31202985:papier:4230:31204915,31202986:papier:4230:31204971,31202987:papier:4230:31205005,31202988:papier:4230:31205056,31202989:papier:4230:31205096,31202990:papier:4230:31205141,31202991:papier:4230:31205170,31202992:papier:4230:31205216,31202993:papier:4230:31205250,31202994:papier:4230:31205299,31202995:papier:4230:31205336,31202996:papier:4230:31205377,31202997:papier:4230:31205410,31202998:papier:4230:31205461,31202999:papier:4230:31205505,31203000:papier:4230:31205589,31203001:papier:4230:31205556,31203002:papier:4230:31205625,31203197:papier:4230:31209881,31203198:papier:4230:31209911,31203199:papier:4230:31213270,31203200:papier:4230:31209979,31203201:papier:4230:31210052,31203202:papier:4230:31210090,31203203:papier:4230:31210133,31203204:papier:4230:31210192,31203205:papier:4230:31210245,31203206:papier:4230:31213071,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002648143950968219, 'nb_photo': 986, 'list_port_cont': '31204679,31204809,31204883,31204914,31204974,31205001,31205050,31205098,31205138,31205329,31205419,31205458,31205508,31205547,31210189,31210241,31210315,31210359,31210538,31211563,31211604,31213064,31213268,31213536,31213585,31213718,31213816,31213851,31213913,31213945,31214901,31214943,31214996,31215037,31215527,31215568,31215649,31216040,31216209,31216615,31216782,31217030,31217278,31217465,31217728,31217967,31218250,31218499,31218761,31219086,31219437,31219626,31219836,31220164,31220434,31220713,31220946,31221236,31221425,31221700,31221971,31222234,31222496,31222904,31223401,31223945,31224393,31224626,31224851,31225068,31225382,31226907,31227188,31227455,31228911,31229173,31229559,31229845,31230113,31230371,31230627,31230906,31231397,31231915,31232097,31232414,31232859,31233178,31233577,31233874,31234777,31235030,31235665,31236043,31236310,31237011,31237118,31237409,31237714,31238040,31238331,31238601,31238830,31238880,31239535,31239783,31240072,31240317,31240636,31240954,31241252,31242145,31242519,3124264', 'assoc_port': '31202979:31204679,31202982:31204809,31202984:31204883,31202985:31204914,31202986:31204974,31202987:31205001,31202988:31205050,31202989:31205098,31202990:31205138,31202995:31205329,31202997:31205419,31202998:31205458,31202999:31205508,31203001:31205547,31203199:31213268,31203204:31210189,31203205:31210241,31203206:31213064,31203207:31210315,31203209:31210359,31203214:31210538,31203489:31211563,31203989:31211604,31211809:31213536,31211811:31213585,31211815:31213718,31211817:31213816,31211818:31213851,31211819:31213913,31211821:31213945,31214509:31214901,31214510:31216040,31214511:31214943,31214512:31214996,31214513:31215037,31215317:31215527,31215318:31215568,31215319:31215649,31215807:31216209,31216329:31216615,31216595:31216782,31216867:31217030,31217189:31217278,31217419:31217465,31217685:31217728,31217918:31217967,31218171:31218250,31218466:31218499,31218730:31218761,31219003:31219086,31219303:31219437,31219548:31219626,31219762:31219836,31220076:31220164,31220357:31220434,31220625:31220713,31220862:3122094', 'assoc_mat': '31202979:pehd:4230:31204679,31202982:pehd:4230:31204809,31202984:pehd:4230:31204883,31202985:pehd:4230:31204914,31202986:pehd:4230:31204974,31202987:pehd:4230:31205001,31202988:pehd:4230:31205050,31202989:pehd:4230:31205098,31202990:pehd:4230:31205138,31202995:pehd:4230:31205329,31202997:pehd:4230:31205419,31202998:pehd:4230:31205458,31202999:pehd:4230:31205508,31203001:pehd:4230:31205547,31203199:pehd:4230:31213268,31203204:pehd:4230:31210189,31203205:pehd:4230:31210241,31203206:pehd:4230:31213064,31203207:pehd:4230:31210315,31203209:pehd:4230:31210359,31203214:pehd:4230:31210538,31203489:pehd:4230:31211563,31203989:pehd:4230:31211604,31211809:pehd:4230:31213536,31211811:pehd:4230:31213585,31211815:pehd:4230:31213718,31211817:pehd:4230:31213816,31211818:pehd:4230:31213851,31211819:pehd:4230:31213913,31211821:pehd:4230:31213945,31214509:pehd:4230:31214901,31214510:pehd:4230:31216040,31214511:pehd:4230:31214943,31214512:pehd:4230:31214996,31214513:pehd:4230:31215037,31215317:pehd:4230:31215527,31215318:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018890234607935704, 'nb_photo': 13529, 'list_port_cont': '31204671,31204717,31204757,31204807,31204847,31204881,31204928,31204964,31205009,31205053,31205095,31205139,31205174,31205214,31205248,31205297,31205337,31205383,31205420,31205459,31205512,31205550,31205588,31205624,31209869,31209923,31209990,31210054,31210091,31210137,31210194,31210243,31210316,31210353,31210402,31210444,31210546,31211562,31211609,31211650,31211697,31211733,31211780,31213074,31213137,31213191,31213275,31213507,31213544,31213586,31213630,31213682,31213725,31213765,31213815,31213860,31213911,31213948,31214906,31214941,31214987,31215025,31215523,31215565,31215656,31216039,31216208,31216248,31216616,31216785,31217029,31217276,31217454,31217729,31217959,31218257,31218497,31218763,31219091,31219434,31219635,31219841,31220167,31220435,31220709,31220948,31221239,31221429,31221694,31221975,31222232,31222464,31222499,31222914,31223133,31223406,31223628,31223938,31224199,31224382,31224623,31224850,31225071,31225394,31225972,31226046,31226499,31226872,31226910,31227191,31227451,31227816,31228138,3122835', 'assoc_port': '31202979:31204671,31202980:31204717,31202981:31204757,31202982:31204807,31202983:31204847,31202984:31204881,31202985:31204928,31202986:31204964,31202987:31205009,31202988:31205053,31202989:31205095,31202990:31205139,31202991:31205174,31202992:31205214,31202993:31205248,31202994:31205297,31202995:31205337,31202996:31205383,31202997:31205420,31202998:31205459,31202999:31205512,31203000:31205588,31203001:31205550,31203002:31205624,31203197:31209869,31203198:31209923,31203199:31213275,31203200:31209990,31203201:31210054,31203202:31210091,31203203:31210137,31203204:31210194,31203205:31210243,31203206:31213074,31203207:31210316,31203208:31213137,31203209:31210353,31203211:31210402,31203212:31210444,31203213:31213191,31203214:31210546,31203489:31211562,31203989:31211609,31204429:31211650,31204539:31211697,31205033:31211733,31205034:31211780,31211809:31213544,31211810:31213507,31211811:31213586,31211812:31213630,31211813:31213682,31211815:31213725,31211816:31213765,31211817:31213815,31211818:31213860,31211819:3121391', 'assoc_mat': '31202979:pet_clair:4230:31204671,31202980:pet_clair:4230:31204717,31202981:pet_clair:4230:31204757,31202982:pet_clair:4230:31204807,31202983:pet_clair:4230:31204847,31202984:pet_clair:4230:31204881,31202985:pet_clair:4230:31204928,31202986:pet_clair:4230:31204964,31202987:pet_clair:4230:31205009,31202988:pet_clair:4230:31205053,31202989:pet_clair:4230:31205095,31202990:pet_clair:4230:31205139,31202991:pet_clair:4230:31205174,31202992:pet_clair:4230:31205214,31202993:pet_clair:4230:31205248,31202994:pet_clair:4230:31205297,31202995:pet_clair:4230:31205337,31202996:pet_clair:4230:31205383,31202997:pet_clair:4230:31205420,31202998:pet_clair:4230:31205459,31202999:pet_clair:4230:31205512,31203000:pet_clair:4230:31205588,31203001:pet_clair:4230:31205550,31203002:pet_clair:4230:31205624,31203197:pet_clair:4230:31209869,31203198:pet_clair:4230:31209923,31203199:pet_clair:4230:31213275,31203200:pet_clair:4230:31209990,31203201:pet_clair:4230:31210054,31203202:pet_clair:4230:31210091,31203203:pet_clair:4230:31210137,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023441415582911326, 'nb_photo': 497, 'list_port_cont': '31205049,31205099,31205129,31205304,31210098,31210141,31210236,31210309,31210447,31210545,31211566,31211694,31213073,31213134,31213274,31213512,31213549,31213584,31213631,31213673,31213850,31213904,31213940,31214909,31214997,31215034,31215524,31216037,31216203,31216608,31216783,31217025,31217466,31217963,31218258,31218768,31219085,31219443,31219628,31219843,31220162,31220441,31220700,31220955,31221232,31221423,31221697,31221965,31222239,31222505,31222916,31223134,31223397,31223631,31223947,31224207,31224391,31224629,31224852,31225973,31226914,31227819,31228139,31228906,31229557,31229834,31230118,31230369,31233878,31234188,31234490,31234773,31235029,31235677,31236053,31236313,31236564,31236847,31237108,31237423,31237707,31238031,31238339,31238604,31240071,31240949,31241241,31242138,31242526,31242657,31244155,31244563,31244685,31245414,31245449,31245506,31245550,31245642,31245692,31246039,31246175,31246215,31246246,31246289,31246368,31246425,31247445,31247491,31247568,31247625,31248182,31248226,31248297,3124852', 'assoc_port': '31202988:31205049,31202989:31205099,31202990:31205129,31202994:31205304,31203199:31213274,31203202:31210098,31203203:31210141,31203205:31210236,31203206:31213073,31203207:31210309,31203208:31213134,31203212:31210447,31203214:31210545,31203489:31211566,31204539:31211694,31211809:31213549,31211810:31213512,31211811:31213584,31211812:31213631,31211813:31213673,31211818:31213850,31211819:31213904,31211821:31213940,31214509:31214909,31214510:31216037,31214512:31214997,31214513:31215034,31215317:31215524,31215807:31216203,31216329:31216608,31216595:31216783,31216867:31217025,31217419:31217466,31217918:31217963,31218171:31218258,31218730:31218768,31219003:31219085,31219303:31219443,31219548:31219628,31219762:31219843,31220076:31220162,31220357:31220441,31220625:31220700,31220862:31220955,31221117:31221232,31221392:31221423,31221628:31221697,31221899:31221965,31222162:31222239,31222427:31222505,31222841:31222916,31223104:31223134,31223368:31223397,31223600:31223631,31223862:31223947,31224138:31224207,31224357:3122439', 'assoc_mat': '31202988:pet_fonce:4230:31205049,31202989:pet_fonce:4230:31205099,31202990:pet_fonce:4230:31205129,31202994:pet_fonce:4230:31205304,31203199:pet_fonce:4230:31213274,31203202:pet_fonce:4230:31210098,31203203:pet_fonce:4230:31210141,31203205:pet_fonce:4230:31210236,31203206:pet_fonce:4230:31213073,31203207:pet_fonce:4230:31210309,31203208:pet_fonce:4230:31213134,31203212:pet_fonce:4230:31210447,31203214:pet_fonce:4230:31210545,31203489:pet_fonce:4230:31211566,31204539:pet_fonce:4230:31211694,31211809:pet_fonce:4230:31213549,31211810:pet_fonce:4230:31213512,31211811:pet_fonce:4230:31213584,31211812:pet_fonce:4230:31213631,31211813:pet_fonce:4230:31213673,31211818:pet_fonce:4230:31213850,31211819:pet_fonce:4230:31213904,31211821:pet_fonce:4230:31213940,31214509:pet_fonce:4230:31214909,31214510:pet_fonce:4230:31216037,31214512:pet_fonce:4230:31214997,31214513:pet_fonce:4230:31215034,31215317:pet_fonce:4230:31215524,31215807:pet_fonce:4230:31216203,31216329:pet_fonce:4230:31216608,31216595:pet_fonce:4230:31216783,3'}) 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(3006640,3006766,3007536,3008136,3008416,3009168,3009764,3010304,3010780,3011400,3011970,3012306,3012848,3013522,3014188,3014844,3015400,3015952,3016188)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302772, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31204673,31204703,31204755,31204792,31204838,31204885,31204919,31204959,31204997,31205055,31205086,31205132,31205168,31205253,31205305,31205334,31205373,31205404,31205457,31205515,31205543,31205577,31205615,31209885,31209916,31209977,31210043,31210089,31210138,31210195,31210239,31210312,31210345,31210399,31210448,31210543,31211567,31211605,31211649,31211693,31211741,31211784,31213066,31213135,31213184,31213269,31213511,31213545,31213590,31213628,31213676,31213713,31213755,31213805,31213858,31213903,31213944,31214905,31214933,31214992,31215033,31215528,31215560,31215647,31216031,31216198,31216234,31216621,31216773,31217024,31217281,31217461,31217739,31217957,31218256,31218492,31218767,31219081,31219435,31219632,31219837,31220165,31220440,31220703,31220939,31221231,31221416,31221696,31221963,31222228,31222458,31222492,31222919,31223122,31223403,31223636,31223939,31224195,31224386,31224618,31224841,31225060,31225381,31225971,31226049,31226483,31226859,31226905,31227183,31227438,31227813,31228135,31228343,3122858 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302773, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31204674,31204708,31204763,31204808,31204850,31204889,31204924,31204972,31205002,31205054,31205088,31205134,31205176,31205243,31205302,31205342,31205379,31205417,31205465,31205514,31205553,31205592,31205619,31209884,31209922,31209986,31210050,31210096,31210135,31210190,31210238,31210313,31210349,31210405,31210441,31210548,31211561,31211617,31211657,31211698,31211730,31211781,31213058,31213145,31213192,31213277,31213502,31213542,31213588,31213632,31213681,31213715,31213766,31213812,31213859,31213912,31213946,31214912,31214946,31215001,31215036,31215529,31215566,31215644,31216041,31216199,31216247,31216618,31216788,31217023,31217280,31217462,31217727,31217966,31218252,31218503,31218755,31219092,31219436,31219636,31219839,31220160,31220427,31220712,31220949,31221238,31221428,31221701,31221966,31222236,31222457,31222504,31222907,31223135,31223404,31223638,31223948,31224201,31224392,31224628,31224845,31225067,31225393,31225964,31226043,31226497,31226869,31226902,31227196,31227447,31227814,31228134,31228347,3122858 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302774, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31204793,31204844,31204879,31204973,31204999,31205043,31205089,31205124,31205298,31205325,31205382,31205415,31205450,31205503,31205579,31205626,31209924,31209982,31210044,31210084,31210235,31210305,31210391,31210455,31210541,31211568,31211656,31211691,31211727,31211777,31213069,31213185,31213271,31213546,31213578,31213670,31213710,31213807,31213843,31213909,31213934,31214898,31214949,31215000,31215027,31215512,31215569,31215639,31216042,31216200,31216235,31217031,31217267,31217463,31217738,31217961,31218491,31218764,31219095,31219431,31219622,31219832,31220158,31220438,31220705,31220947,31221240,31221417,31221699,31221973,31222235,31222500,31222909,31224194,31224387,31224630,31224840,31225070,31225389,31225957,31226493,31226855,31226909,31227195,31227443,31227805,31228133,31228349,31228587,31228915,31229545,31229829,31230111,31230382,31230910,31231403,31231913,31232096,31232398,31232846,31233167,31233870,31234196,31234766,31235660,31236051,31236317,31236552,31237002,31237112,31237417,31237705,31238038,3123833 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302775, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31204678,31204712,31204761,31204806,31204843,31204888,31204915,31204971,31205005,31205056,31205096,31205141,31205170,31205216,31205250,31205299,31205336,31205377,31205410,31205461,31205505,31205556,31205589,31205625,31209881,31209911,31209979,31210052,31210090,31210133,31210192,31210245,31210311,31210358,31210398,31210452,31210551,31211565,31211616,31211651,31211703,31211743,31211786,31213071,31213143,31213190,31213270,31213515,31213551,31213582,31213627,31213683,31213714,31213752,31213817,31213854,31213907,31213942,31214903,31214935,31214999,31215029,31215525,31215567,31215654,31216035,31216206,31216237,31216610,31216784,31217022,31217279,31217460,31217734,31217965,31218251,31218488,31218760,31219093,31219439,31219634,31219840,31220163,31220432,31220704,31220952,31221234,31221431,31221702,31221974,31222230,31222456,31222502,31222920,31223139,31223402,31223633,31223949,31224209,31224395,31224619,31224846,31225073,31225386,31225968,31226047,31226496,31226866,31226915,31227181,31227442,31227808,31228131,3122835 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302776, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31204679,31204809,31204883,31204914,31204974,31205001,31205050,31205098,31205138,31205329,31205419,31205458,31205508,31205547,31210189,31210241,31210315,31210359,31210538,31211563,31211604,31213064,31213268,31213536,31213585,31213718,31213816,31213851,31213913,31213945,31214901,31214943,31214996,31215037,31215527,31215568,31215649,31216040,31216209,31216615,31216782,31217030,31217278,31217465,31217728,31217967,31218250,31218499,31218761,31219086,31219437,31219626,31219836,31220164,31220434,31220713,31220946,31221236,31221425,31221700,31221971,31222234,31222496,31222904,31223401,31223945,31224393,31224626,31224851,31225068,31225382,31226907,31227188,31227455,31228911,31229173,31229559,31229845,31230113,31230371,31230627,31230906,31231397,31231915,31232097,31232414,31232859,31233178,31233577,31233874,31234777,31235030,31235665,31236043,31236310,31237011,31237118,31237409,31237714,31238040,31238331,31238601,31238830,31238880,31239535,31239783,31240072,31240317,31240636,31240954,31241252,31242145,31242519,3124264 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302777, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31204671,31204717,31204757,31204807,31204847,31204881,31204928,31204964,31205009,31205053,31205095,31205139,31205174,31205214,31205248,31205297,31205337,31205383,31205420,31205459,31205512,31205550,31205588,31205624,31209869,31209923,31209990,31210054,31210091,31210137,31210194,31210243,31210316,31210353,31210402,31210444,31210546,31211562,31211609,31211650,31211697,31211733,31211780,31213074,31213137,31213191,31213275,31213507,31213544,31213586,31213630,31213682,31213725,31213765,31213815,31213860,31213911,31213948,31214906,31214941,31214987,31215025,31215523,31215565,31215656,31216039,31216208,31216248,31216616,31216785,31217029,31217276,31217454,31217729,31217959,31218257,31218497,31218763,31219091,31219434,31219635,31219841,31220167,31220435,31220709,31220948,31221239,31221429,31221694,31221975,31222232,31222464,31222499,31222914,31223133,31223406,31223628,31223938,31224199,31224382,31224623,31224850,31225071,31225394,31225972,31226046,31226499,31226872,31226910,31227191,31227451,31227816,31228138,3122835 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31302778, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31205049,31205099,31205129,31205304,31210098,31210141,31210236,31210309,31210447,31210545,31211566,31211694,31213073,31213134,31213274,31213512,31213549,31213584,31213631,31213673,31213850,31213904,31213940,31214909,31214997,31215034,31215524,31216037,31216203,31216608,31216783,31217025,31217466,31217963,31218258,31218768,31219085,31219443,31219628,31219843,31220162,31220441,31220700,31220955,31221232,31221423,31221697,31221965,31222239,31222505,31222916,31223134,31223397,31223631,31223947,31224207,31224391,31224629,31224852,31225973,31226914,31227819,31228139,31228906,31229557,31229834,31230118,31230369,31233878,31234188,31234490,31234773,31235029,31235677,31236053,31236313,31236564,31236847,31237108,31237423,31237707,31238031,31238339,31238604,31240071,31240949,31241241,31242138,31242526,31242657,31244155,31244563,31244685,31245414,31245449,31245506,31245550,31245642,31245692,31246039,31246175,31246215,31246246,31246289,31246368,31246425,31247445,31247491,31247568,31247625,31248182,31248226,31248297,3124852 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31302772,31302773,31302774,31302775,31302776,31302777,31302778?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=202 and date >='2026-07-01' and date <= '2026-07-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1154,),), 'unwanted_material_monthly_percentage': ((0.7617754061813018,),), 'material_repartition': (('incineration', 1154),), 'material_dict': {'incineration': 1154}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 7, 1), 0.750302844235267, 2), (datetime.date(2026, 7, 2), 0.7579212471205131, 2), (datetime.date(2026, 7, 3), 0.7591879975664534, 4), (datetime.date(2026, 7, 4), 0.6742718979274239, 3), (datetime.date(2026, 7, 5), 0.7074323112628529, 4), (datetime.date(2026, 7, 6), 0.7520340185087112, 2), (datetime.date(2026, 7, 7), 0.7495470021951726, 1), (datetime.date(2026, 7, 8), 0.7120088738402267, 2), (datetime.date(2026, 7, 9), 0.736496275636616, 1), (datetime.date(2026, 7, 10), 0.7237830825554673, 3), (datetime.date(2026, 7, 11), 0.7032180579458779, 1), (datetime.date(2026, 7, 12), 0.7802594905687175, 2), (datetime.date(2026, 7, 13), 0.7997616856071804, 2), (datetime.date(2026, 7, 14), 0.8594209054917376, 2), (datetime.date(2026, 7, 15), 0.8412554281787846, 4), (datetime.date(2026, 7, 16), 0.8114997395319046, 3), (datetime.date(2026, 7, 17), 0.7818006218503701, 4), (datetime.date(2026, 7, 18), 0.7484945509031339, 1), (datetime.date(2026, 7, 19), 0.8053838636412111, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 7, 1), 0.750302844235267, 2), (datetime.date(2026, 7, 2), 0.7579212471205131, 2), (datetime.date(2026, 7, 3), 0.7591879975664534, 4), (datetime.date(2026, 7, 4), 0.6742718979274239, 3), (datetime.date(2026, 7, 5), 0.7074323112628529, 4), (datetime.date(2026, 7, 6), 0.7520340185087112, 2), (datetime.date(2026, 7, 7), 0.7495470021951726, 1), (datetime.date(2026, 7, 8), 0.7120088738402267, 2), (datetime.date(2026, 7, 9), 0.736496275636616, 1), (datetime.date(2026, 7, 10), 0.7237830825554673, 3), (datetime.date(2026, 7, 11), 0.7032180579458779, 1), (datetime.date(2026, 7, 12), 0.7802594905687175, 2), (datetime.date(2026, 7, 13), 0.7997616856071804, 2), (datetime.date(2026, 7, 14), 0.8594209054917376, 2), (datetime.date(2026, 7, 15), 0.8412554281787846, 4), (datetime.date(2026, 7, 16), 0.8114997395319046, 3), (datetime.date(2026, 7, 17), 0.7818006218503701, 4), (datetime.date(2026, 7, 18), 0.7484945509031339, 1), (datetime.date(2026, 7, 19), 0.8053838636412111, 3))}, 'quality_array': [['-7.418129807868215', '01072026'], ['-7.793101467571608', '02072026'], ['-8.007468170446929', '03072026'], ['-7.747666160296839', '04072026'], ['-7.676451074234139', '05072026'], ['-7.55564308050372', '06072026'], ['-7.636771558183379', '07072026'], ['-7.722888804262609', '08072026'], ['-7.643178065000939', '09072026'], ['-7.46841398696999', '10072026'], ['-7.384989902874297', '11072026'], ['-7.825424467799379', '12072026'], ['-7.051262770007768', '13072026'], ['-7.3163656092954215', '14072026'], ['-6.555274225144065', '15072026'], ['-6.978914737134811', '16072026'], ['-7.289689561365646', '17072026'], ['-7.437041255343968', '18072026'], ['-7.5835354631674186', '19072026']], 'number_of_batch': ((411,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0128043338788159, 'nb_photo': 9884, 'list_port_cont': '31204673,31204703,31204755,31204792,31204838,31204885,31204919,31204959,31204997,31205055,31205086,31205132,31205168,31205253,31205305,31205334,31205373,31205404,31205457,31205515,31205543,31205577,31205615,31209885,31209916,31209977,31210043,31210089,31210138,31210195,31210239,31210312,31210345,31210399,31210448,31210543,31211567,31211605,31211649,31211693,31211741,31211784,31213066,31213135,31213184,31213269,31213511,31213545,31213590,31213628,31213676,31213713,31213755,31213805,31213858,31213903,31213944,31214905,31214933,31214992,31215033,31215528,31215560,31215647,31216031,31216198,31216234,31216621,31216773,31217024,31217281,31217461,31217739,31217957,31218256,31218492,31218767,31219081,31219435,31219632,31219837,31220165,31220440,31220703,31220939,31221231,31221416,31221696,31221963,31222228,31222458,31222492,31222919,31223122,31223403,31223636,31223939,31224195,31224386,31224618,31224841,31225060,31225381,31225971,31226049,31226483,31226859,31226905,31227183,31227438,31227813,31228135,31228343,3122858', 'assoc_port': '31202979:31204673,31202980:31204703,31202981:31204755,31202982:31204792,31202983:31204838,31202984:31204885,31202985:31204919,31202986:31204959,31202987:31204997,31202988:31205055,31202989:31205086,31202990:31205132,31202991:31205168,31202993:31205253,31202994:31205305,31202995:31205334,31202996:31205373,31202997:31205404,31202998:31205457,31202999:31205515,31203000:31205577,31203001:31205543,31203002:31205615,31203197:31209885,31203198:31209916,31203199:31213269,31203200:31209977,31203201:31210043,31203202:31210089,31203203:31210138,31203204:31210195,31203205:31210239,31203206:31213066,31203207:31210312,31203208:31213135,31203209:31210345,31203211:31210399,31203212:31210448,31203213:31213184,31203214:31210543,31203489:31211567,31203989:31211605,31204429:31211649,31204539:31211693,31205033:31211741,31205034:31211784,31211809:31213545,31211810:31213511,31211811:31213590,31211812:31213628,31211813:31213676,31211815:31213713,31211816:31213755,31211817:31213805,31211818:31213858,31211819:31213903,31211821:3121394', 'assoc_mat': '31202979:autre:4230:31204673,31202980:autre:4230:31204703,31202981:autre:4230:31204755,31202982:autre:4230:31204792,31202983:autre:4230:31204838,31202984:autre:4230:31204885,31202985:autre:4230:31204919,31202986:autre:4230:31204959,31202987:autre:4230:31204997,31202988:autre:4230:31205055,31202989:autre:4230:31205086,31202990:autre:4230:31205132,31202991:autre:4230:31205168,31202993:autre:4230:31205253,31202994:autre:4230:31205305,31202995:autre:4230:31205334,31202996:autre:4230:31205373,31202997:autre:4230:31205404,31202998:autre:4230:31205457,31202999:autre:4230:31205515,31203000:autre:4230:31205577,31203001:autre:4230:31205543,31203002:autre:4230:31205615,31203197:autre:4230:31209885,31203198:autre:4230:31209916,31203199:autre:4230:31213269,31203200:autre:4230:31209977,31203201:autre:4230:31210043,31203202:autre:4230:31210089,31203203:autre:4230:31210138,31203204:autre:4230:31210195,31203205:autre:4230:31210239,31203206:autre:4230:31213066,31203207:autre:4230:31210312,31203208:autre:4230:31213135,31203209:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03167964940775468, 'nb_photo': 38942, 'list_port_cont': '31204674,31204708,31204763,31204808,31204850,31204889,31204924,31204972,31205002,31205054,31205088,31205134,31205176,31205243,31205302,31205342,31205379,31205417,31205465,31205514,31205553,31205592,31205619,31209884,31209922,31209986,31210050,31210096,31210135,31210190,31210238,31210313,31210349,31210405,31210441,31210548,31211561,31211617,31211657,31211698,31211730,31211781,31213058,31213145,31213192,31213277,31213502,31213542,31213588,31213632,31213681,31213715,31213766,31213812,31213859,31213912,31213946,31214912,31214946,31215001,31215036,31215529,31215566,31215644,31216041,31216199,31216247,31216618,31216788,31217023,31217280,31217462,31217727,31217966,31218252,31218503,31218755,31219092,31219436,31219636,31219839,31220160,31220427,31220712,31220949,31221238,31221428,31221701,31221966,31222236,31222457,31222504,31222907,31223135,31223404,31223638,31223948,31224201,31224392,31224628,31224845,31225067,31225393,31225964,31226043,31226497,31226869,31226902,31227196,31227447,31227814,31228134,31228347,3122858', 'assoc_port': '31202979:31204674,31202980:31204708,31202981:31204763,31202982:31204808,31202983:31204850,31202984:31204889,31202985:31204924,31202986:31204972,31202987:31205002,31202988:31205054,31202989:31205088,31202990:31205134,31202991:31205176,31202993:31205243,31202994:31205302,31202995:31205342,31202996:31205379,31202997:31205417,31202998:31205465,31202999:31205514,31203000:31205592,31203001:31205553,31203002:31205619,31203197:31209884,31203198:31209922,31203199:31213277,31203200:31209986,31203201:31210050,31203202:31210096,31203203:31210135,31203204:31210190,31203205:31210238,31203206:31213058,31203207:31210313,31203208:31213145,31203209:31210349,31203211:31210405,31203212:31210441,31203213:31213192,31203214:31210548,31203489:31211561,31203989:31211617,31204429:31211657,31204539:31211698,31205033:31211730,31205034:31211781,31211809:31213542,31211810:31213502,31211811:31213588,31211812:31213632,31211813:31213681,31211815:31213715,31211816:31213766,31211817:31213812,31211818:31213859,31211819:31213912,31211821:3121394', 'assoc_mat': '31202979:carton:4230:31204674,31202980:carton:4230:31204708,31202981:carton:4230:31204763,31202982:carton:4230:31204808,31202983:carton:4230:31204850,31202984:carton:4230:31204889,31202985:carton:4230:31204924,31202986:carton:4230:31204972,31202987:carton:4230:31205002,31202988:carton:4230:31205054,31202989:carton:4230:31205088,31202990:carton:4230:31205134,31202991:carton:4230:31205176,31202993:carton:4230:31205243,31202994:carton:4230:31205302,31202995:carton:4230:31205342,31202996:carton:4230:31205379,31202997:carton:4230:31205417,31202998:carton:4230:31205465,31202999:carton:4230:31205514,31203000:carton:4230:31205592,31203001:carton:4230:31205553,31203002:carton:4230:31205619,31203197:carton:4230:31209884,31203198:carton:4230:31209922,31203199:carton:4230:31213277,31203200:carton:4230:31209986,31203201:carton:4230:31210050,31203202:carton:4230:31210096,31203203:carton:4230:31210135,31203204:carton:4230:31210190,31203205:carton:4230:31210238,31203206:carton:4230:31213058,31203207:carton:4230:31210313,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011764421498006929, 'nb_photo': 761, 'list_port_cont': '31204793,31204844,31204879,31204973,31204999,31205043,31205089,31205124,31205298,31205325,31205382,31205415,31205450,31205503,31205579,31205626,31209924,31209982,31210044,31210084,31210235,31210305,31210391,31210455,31210541,31211568,31211656,31211691,31211727,31211777,31213069,31213185,31213271,31213546,31213578,31213670,31213710,31213807,31213843,31213909,31213934,31214898,31214949,31215000,31215027,31215512,31215569,31215639,31216042,31216200,31216235,31217031,31217267,31217463,31217738,31217961,31218491,31218764,31219095,31219431,31219622,31219832,31220158,31220438,31220705,31220947,31221240,31221417,31221699,31221973,31222235,31222500,31222909,31224194,31224387,31224630,31224840,31225070,31225389,31225957,31226493,31226855,31226909,31227195,31227443,31227805,31228133,31228349,31228587,31228915,31229545,31229829,31230111,31230382,31230910,31231403,31231913,31232096,31232398,31232846,31233167,31233870,31234196,31234766,31235660,31236051,31236317,31236552,31237002,31237112,31237417,31237705,31238038,3123833', 'assoc_port': '31202982:31204793,31202983:31204844,31202984:31204879,31202986:31204973,31202987:31204999,31202988:31205043,31202989:31205089,31202990:31205124,31202994:31205298,31202995:31205325,31202996:31205382,31202997:31205415,31202998:31205450,31202999:31205503,31203000:31205579,31203002:31205626,31203198:31209924,31203199:31213271,31203200:31209982,31203201:31210044,31203202:31210084,31203205:31210235,31203206:31213069,31203207:31210305,31203211:31210391,31203212:31210455,31203213:31213185,31203214:31210541,31203489:31211568,31204429:31211656,31204539:31211691,31205033:31211727,31205034:31211777,31211809:31213546,31211811:31213578,31211813:31213670,31211815:31213710,31211817:31213807,31211818:31213843,31211819:31213909,31211821:31213934,31214509:31214898,31214510:31216042,31214511:31214949,31214512:31215000,31214513:31215027,31215317:31215512,31215318:31215569,31215319:31215639,31215807:31216200,31215809:31216235,31216867:31217031,31217189:31217267,31217419:31217463,31217685:31217738,31217918:31217961,31218466:3121849', 'assoc_mat': '31202982:metal:4230:31204793,31202983:metal:4230:31204844,31202984:metal:4230:31204879,31202986:metal:4230:31204973,31202987:metal:4230:31204999,31202988:metal:4230:31205043,31202989:metal:4230:31205089,31202990:metal:4230:31205124,31202994:metal:4230:31205298,31202995:metal:4230:31205325,31202996:metal:4230:31205382,31202997:metal:4230:31205415,31202998:metal:4230:31205450,31202999:metal:4230:31205503,31203000:metal:4230:31205579,31203002:metal:4230:31205626,31203198:metal:4230:31209924,31203199:metal:4230:31213271,31203200:metal:4230:31209982,31203201:metal:4230:31210044,31203202:metal:4230:31210084,31203205:metal:4230:31210235,31203206:metal:4230:31213069,31203207:metal:4230:31210305,31203211:metal:4230:31210391,31203212:metal:4230:31210455,31203213:metal:4230:31213185,31203214:metal:4230:31210541,31203489:metal:4230:31211568,31204429:metal:4230:31211656,31204539:metal:4230:31211691,31205033:metal:4230:31211727,31205034:metal:4230:31211777,31211809:metal:4230:31213546,31211811:metal:4230:31213578,31211813:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19162503622535962, 'nb_photo': 198148, 'list_port_cont': '31204678,31204712,31204761,31204806,31204843,31204888,31204915,31204971,31205005,31205056,31205096,31205141,31205170,31205216,31205250,31205299,31205336,31205377,31205410,31205461,31205505,31205556,31205589,31205625,31209881,31209911,31209979,31210052,31210090,31210133,31210192,31210245,31210311,31210358,31210398,31210452,31210551,31211565,31211616,31211651,31211703,31211743,31211786,31213071,31213143,31213190,31213270,31213515,31213551,31213582,31213627,31213683,31213714,31213752,31213817,31213854,31213907,31213942,31214903,31214935,31214999,31215029,31215525,31215567,31215654,31216035,31216206,31216237,31216610,31216784,31217022,31217279,31217460,31217734,31217965,31218251,31218488,31218760,31219093,31219439,31219634,31219840,31220163,31220432,31220704,31220952,31221234,31221431,31221702,31221974,31222230,31222456,31222502,31222920,31223139,31223402,31223633,31223949,31224209,31224395,31224619,31224846,31225073,31225386,31225968,31226047,31226496,31226866,31226915,31227181,31227442,31227808,31228131,3122835', 'assoc_port': '31202979:31204678,31202980:31204712,31202981:31204761,31202982:31204806,31202983:31204843,31202984:31204888,31202985:31204915,31202986:31204971,31202987:31205005,31202988:31205056,31202989:31205096,31202990:31205141,31202991:31205170,31202992:31205216,31202993:31205250,31202994:31205299,31202995:31205336,31202996:31205377,31202997:31205410,31202998:31205461,31202999:31205505,31203000:31205589,31203001:31205556,31203002:31205625,31203197:31209881,31203198:31209911,31203199:31213270,31203200:31209979,31203201:31210052,31203202:31210090,31203203:31210133,31203204:31210192,31203205:31210245,31203206:31213071,31203207:31210311,31203208:31213143,31203209:31210358,31203211:31210398,31203212:31210452,31203213:31213190,31203214:31210551,31203489:31211565,31203989:31211616,31204429:31211651,31204539:31211703,31205033:31211743,31205034:31211786,31211809:31213551,31211810:31213515,31211811:31213582,31211812:31213627,31211813:31213683,31211815:31213714,31211816:31213752,31211817:31213817,31211818:31213854,31211819:3121390', 'assoc_mat': '31202979:papier:4230:31204678,31202980:papier:4230:31204712,31202981:papier:4230:31204761,31202982:papier:4230:31204806,31202983:papier:4230:31204843,31202984:papier:4230:31204888,31202985:papier:4230:31204915,31202986:papier:4230:31204971,31202987:papier:4230:31205005,31202988:papier:4230:31205056,31202989:papier:4230:31205096,31202990:papier:4230:31205141,31202991:papier:4230:31205170,31202992:papier:4230:31205216,31202993:papier:4230:31205250,31202994:papier:4230:31205299,31202995:papier:4230:31205336,31202996:papier:4230:31205377,31202997:papier:4230:31205410,31202998:papier:4230:31205461,31202999:papier:4230:31205505,31203000:papier:4230:31205589,31203001:papier:4230:31205556,31203002:papier:4230:31205625,31203197:papier:4230:31209881,31203198:papier:4230:31209911,31203199:papier:4230:31213270,31203200:papier:4230:31209979,31203201:papier:4230:31210052,31203202:papier:4230:31210090,31203203:papier:4230:31210133,31203204:papier:4230:31210192,31203205:papier:4230:31210245,31203206:papier:4230:31213071,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002648143950968219, 'nb_photo': 986, 'list_port_cont': '31204679,31204809,31204883,31204914,31204974,31205001,31205050,31205098,31205138,31205329,31205419,31205458,31205508,31205547,31210189,31210241,31210315,31210359,31210538,31211563,31211604,31213064,31213268,31213536,31213585,31213718,31213816,31213851,31213913,31213945,31214901,31214943,31214996,31215037,31215527,31215568,31215649,31216040,31216209,31216615,31216782,31217030,31217278,31217465,31217728,31217967,31218250,31218499,31218761,31219086,31219437,31219626,31219836,31220164,31220434,31220713,31220946,31221236,31221425,31221700,31221971,31222234,31222496,31222904,31223401,31223945,31224393,31224626,31224851,31225068,31225382,31226907,31227188,31227455,31228911,31229173,31229559,31229845,31230113,31230371,31230627,31230906,31231397,31231915,31232097,31232414,31232859,31233178,31233577,31233874,31234777,31235030,31235665,31236043,31236310,31237011,31237118,31237409,31237714,31238040,31238331,31238601,31238830,31238880,31239535,31239783,31240072,31240317,31240636,31240954,31241252,31242145,31242519,3124264', 'assoc_port': '31202979:31204679,31202982:31204809,31202984:31204883,31202985:31204914,31202986:31204974,31202987:31205001,31202988:31205050,31202989:31205098,31202990:31205138,31202995:31205329,31202997:31205419,31202998:31205458,31202999:31205508,31203001:31205547,31203199:31213268,31203204:31210189,31203205:31210241,31203206:31213064,31203207:31210315,31203209:31210359,31203214:31210538,31203489:31211563,31203989:31211604,31211809:31213536,31211811:31213585,31211815:31213718,31211817:31213816,31211818:31213851,31211819:31213913,31211821:31213945,31214509:31214901,31214510:31216040,31214511:31214943,31214512:31214996,31214513:31215037,31215317:31215527,31215318:31215568,31215319:31215649,31215807:31216209,31216329:31216615,31216595:31216782,31216867:31217030,31217189:31217278,31217419:31217465,31217685:31217728,31217918:31217967,31218171:31218250,31218466:31218499,31218730:31218761,31219003:31219086,31219303:31219437,31219548:31219626,31219762:31219836,31220076:31220164,31220357:31220434,31220625:31220713,31220862:3122094', 'assoc_mat': '31202979:pehd:4230:31204679,31202982:pehd:4230:31204809,31202984:pehd:4230:31204883,31202985:pehd:4230:31204914,31202986:pehd:4230:31204974,31202987:pehd:4230:31205001,31202988:pehd:4230:31205050,31202989:pehd:4230:31205098,31202990:pehd:4230:31205138,31202995:pehd:4230:31205329,31202997:pehd:4230:31205419,31202998:pehd:4230:31205458,31202999:pehd:4230:31205508,31203001:pehd:4230:31205547,31203199:pehd:4230:31213268,31203204:pehd:4230:31210189,31203205:pehd:4230:31210241,31203206:pehd:4230:31213064,31203207:pehd:4230:31210315,31203209:pehd:4230:31210359,31203214:pehd:4230:31210538,31203489:pehd:4230:31211563,31203989:pehd:4230:31211604,31211809:pehd:4230:31213536,31211811:pehd:4230:31213585,31211815:pehd:4230:31213718,31211817:pehd:4230:31213816,31211818:pehd:4230:31213851,31211819:pehd:4230:31213913,31211821:pehd:4230:31213945,31214509:pehd:4230:31214901,31214510:pehd:4230:31216040,31214511:pehd:4230:31214943,31214512:pehd:4230:31214996,31214513:pehd:4230:31215037,31215317:pehd:4230:31215527,31215318:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018890234607935704, 'nb_photo': 13529, 'list_port_cont': '31204671,31204717,31204757,31204807,31204847,31204881,31204928,31204964,31205009,31205053,31205095,31205139,31205174,31205214,31205248,31205297,31205337,31205383,31205420,31205459,31205512,31205550,31205588,31205624,31209869,31209923,31209990,31210054,31210091,31210137,31210194,31210243,31210316,31210353,31210402,31210444,31210546,31211562,31211609,31211650,31211697,31211733,31211780,31213074,31213137,31213191,31213275,31213507,31213544,31213586,31213630,31213682,31213725,31213765,31213815,31213860,31213911,31213948,31214906,31214941,31214987,31215025,31215523,31215565,31215656,31216039,31216208,31216248,31216616,31216785,31217029,31217276,31217454,31217729,31217959,31218257,31218497,31218763,31219091,31219434,31219635,31219841,31220167,31220435,31220709,31220948,31221239,31221429,31221694,31221975,31222232,31222464,31222499,31222914,31223133,31223406,31223628,31223938,31224199,31224382,31224623,31224850,31225071,31225394,31225972,31226046,31226499,31226872,31226910,31227191,31227451,31227816,31228138,3122835', 'assoc_port': '31202979:31204671,31202980:31204717,31202981:31204757,31202982:31204807,31202983:31204847,31202984:31204881,31202985:31204928,31202986:31204964,31202987:31205009,31202988:31205053,31202989:31205095,31202990:31205139,31202991:31205174,31202992:31205214,31202993:31205248,31202994:31205297,31202995:31205337,31202996:31205383,31202997:31205420,31202998:31205459,31202999:31205512,31203000:31205588,31203001:31205550,31203002:31205624,31203197:31209869,31203198:31209923,31203199:31213275,31203200:31209990,31203201:31210054,31203202:31210091,31203203:31210137,31203204:31210194,31203205:31210243,31203206:31213074,31203207:31210316,31203208:31213137,31203209:31210353,31203211:31210402,31203212:31210444,31203213:31213191,31203214:31210546,31203489:31211562,31203989:31211609,31204429:31211650,31204539:31211697,31205033:31211733,31205034:31211780,31211809:31213544,31211810:31213507,31211811:31213586,31211812:31213630,31211813:31213682,31211815:31213725,31211816:31213765,31211817:31213815,31211818:31213860,31211819:3121391', 'assoc_mat': '31202979:pet_clair:4230:31204671,31202980:pet_clair:4230:31204717,31202981:pet_clair:4230:31204757,31202982:pet_clair:4230:31204807,31202983:pet_clair:4230:31204847,31202984:pet_clair:4230:31204881,31202985:pet_clair:4230:31204928,31202986:pet_clair:4230:31204964,31202987:pet_clair:4230:31205009,31202988:pet_clair:4230:31205053,31202989:pet_clair:4230:31205095,31202990:pet_clair:4230:31205139,31202991:pet_clair:4230:31205174,31202992:pet_clair:4230:31205214,31202993:pet_clair:4230:31205248,31202994:pet_clair:4230:31205297,31202995:pet_clair:4230:31205337,31202996:pet_clair:4230:31205383,31202997:pet_clair:4230:31205420,31202998:pet_clair:4230:31205459,31202999:pet_clair:4230:31205512,31203000:pet_clair:4230:31205588,31203001:pet_clair:4230:31205550,31203002:pet_clair:4230:31205624,31203197:pet_clair:4230:31209869,31203198:pet_clair:4230:31209923,31203199:pet_clair:4230:31213275,31203200:pet_clair:4230:31209990,31203201:pet_clair:4230:31210054,31203202:pet_clair:4230:31210091,31203203:pet_clair:4230:31210137,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023441415582911326, 'nb_photo': 497, 'list_port_cont': '31205049,31205099,31205129,31205304,31210098,31210141,31210236,31210309,31210447,31210545,31211566,31211694,31213073,31213134,31213274,31213512,31213549,31213584,31213631,31213673,31213850,31213904,31213940,31214909,31214997,31215034,31215524,31216037,31216203,31216608,31216783,31217025,31217466,31217963,31218258,31218768,31219085,31219443,31219628,31219843,31220162,31220441,31220700,31220955,31221232,31221423,31221697,31221965,31222239,31222505,31222916,31223134,31223397,31223631,31223947,31224207,31224391,31224629,31224852,31225973,31226914,31227819,31228139,31228906,31229557,31229834,31230118,31230369,31233878,31234188,31234490,31234773,31235029,31235677,31236053,31236313,31236564,31236847,31237108,31237423,31237707,31238031,31238339,31238604,31240071,31240949,31241241,31242138,31242526,31242657,31244155,31244563,31244685,31245414,31245449,31245506,31245550,31245642,31245692,31246039,31246175,31246215,31246246,31246289,31246368,31246425,31247445,31247491,31247568,31247625,31248182,31248226,31248297,3124852', 'assoc_port': '31202988:31205049,31202989:31205099,31202990:31205129,31202994:31205304,31203199:31213274,31203202:31210098,31203203:31210141,31203205:31210236,31203206:31213073,31203207:31210309,31203208:31213134,31203212:31210447,31203214:31210545,31203489:31211566,31204539:31211694,31211809:31213549,31211810:31213512,31211811:31213584,31211812:31213631,31211813:31213673,31211818:31213850,31211819:31213904,31211821:31213940,31214509:31214909,31214510:31216037,31214512:31214997,31214513:31215034,31215317:31215524,31215807:31216203,31216329:31216608,31216595:31216783,31216867:31217025,31217419:31217466,31217918:31217963,31218171:31218258,31218730:31218768,31219003:31219085,31219303:31219443,31219548:31219628,31219762:31219843,31220076:31220162,31220357:31220441,31220625:31220700,31220862:31220955,31221117:31221232,31221392:31221423,31221628:31221697,31221899:31221965,31222162:31222239,31222427:31222505,31222841:31222916,31223104:31223134,31223368:31223397,31223600:31223631,31223862:31223947,31224138:31224207,31224357:3122439', 'assoc_mat': '31202988:pet_fonce:4230:31205049,31202989:pet_fonce:4230:31205099,31202990:pet_fonce:4230:31205129,31202994:pet_fonce:4230:31205304,31203199:pet_fonce:4230:31213274,31203202:pet_fonce:4230:31210098,31203203:pet_fonce:4230:31210141,31203205:pet_fonce:4230:31210236,31203206:pet_fonce:4230:31213073,31203207:pet_fonce:4230:31210309,31203208:pet_fonce:4230:31213134,31203212:pet_fonce:4230:31210447,31203214:pet_fonce:4230:31210545,31203489:pet_fonce:4230:31211566,31204539:pet_fonce:4230:31211694,31211809:pet_fonce:4230:31213549,31211810:pet_fonce:4230:31213512,31211811:pet_fonce:4230:31213584,31211812:pet_fonce:4230:31213631,31211813:pet_fonce:4230:31213673,31211818:pet_fonce:4230:31213850,31211819:pet_fonce:4230:31213904,31211821:pet_fonce:4230:31213940,31214509:pet_fonce:4230:31214909,31214510:pet_fonce:4230:31216037,31214512:pet_fonce:4230:31214997,31214513:pet_fonce:4230:31215034,31215317:pet_fonce:4230:31215524,31215807:pet_fonce:4230:31216203,31216329:pet_fonce:4230:31216608,31216595:pet_fonce:4230:31216783,3'}), 'main_stat': {'nb_photos': 1154}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31302772,31302773,31302774,31302775,31302776,31302777,31302778?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-07', 0.7617754061813018),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1154,),), 'unwanted_material_monthly_percentage': ((0.7617754061813018,),), 'material_repartition': (('incineration', 1154),), 'material_dict': {'incineration': 1154}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 7, 1), 0.750302844235267, 2), (datetime.date(2026, 7, 2), 0.7579212471205131, 2), (datetime.date(2026, 7, 3), 0.7591879975664534, 4), (datetime.date(2026, 7, 4), 0.6742718979274239, 3), (datetime.date(2026, 7, 5), 0.7074323112628529, 4), (datetime.date(2026, 7, 6), 0.7520340185087112, 2), (datetime.date(2026, 7, 7), 0.7495470021951726, 1), (datetime.date(2026, 7, 8), 0.7120088738402267, 2), (datetime.date(2026, 7, 9), 0.736496275636616, 1), (datetime.date(2026, 7, 10), 0.7237830825554673, 3), (datetime.date(2026, 7, 11), 0.7032180579458779, 1), (datetime.date(2026, 7, 12), 0.7802594905687175, 2), (datetime.date(2026, 7, 13), 0.7997616856071804, 2), (datetime.date(2026, 7, 14), 0.8594209054917376, 2), (datetime.date(2026, 7, 15), 0.8412554281787846, 4), (datetime.date(2026, 7, 16), 0.8114997395319046, 3), (datetime.date(2026, 7, 17), 0.7818006218503701, 4), (datetime.date(2026, 7, 18), 0.7484945509031339, 1), (datetime.date(2026, 7, 19), 0.8053838636412111, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 7, 1), 0.750302844235267, 2), (datetime.date(2026, 7, 2), 0.7579212471205131, 2), (datetime.date(2026, 7, 3), 0.7591879975664534, 4), (datetime.date(2026, 7, 4), 0.6742718979274239, 3), (datetime.date(2026, 7, 5), 0.7074323112628529, 4), (datetime.date(2026, 7, 6), 0.7520340185087112, 2), (datetime.date(2026, 7, 7), 0.7495470021951726, 1), (datetime.date(2026, 7, 8), 0.7120088738402267, 2), (datetime.date(2026, 7, 9), 0.736496275636616, 1), (datetime.date(2026, 7, 10), 0.7237830825554673, 3), (datetime.date(2026, 7, 11), 0.7032180579458779, 1), (datetime.date(2026, 7, 12), 0.7802594905687175, 2), (datetime.date(2026, 7, 13), 0.7997616856071804, 2), (datetime.date(2026, 7, 14), 0.8594209054917376, 2), (datetime.date(2026, 7, 15), 0.8412554281787846, 4), (datetime.date(2026, 7, 16), 0.8114997395319046, 3), (datetime.date(2026, 7, 17), 0.7818006218503701, 4), (datetime.date(2026, 7, 18), 0.7484945509031339, 1), (datetime.date(2026, 7, 19), 0.8053838636412111, 3))}, 'quality_array': [['-7.418129807868215', '01072026'], ['-7.793101467571608', '02072026'], ['-8.007468170446929', '03072026'], ['-7.747666160296839', '04072026'], ['-7.676451074234139', '05072026'], ['-7.55564308050372', '06072026'], ['-7.636771558183379', '07072026'], ['-7.722888804262609', '08072026'], ['-7.643178065000939', '09072026'], ['-7.46841398696999', '10072026'], ['-7.384989902874297', '11072026'], ['-7.825424467799379', '12072026'], ['-7.051262770007768', '13072026'], ['-7.3163656092954215', '14072026'], ['-6.555274225144065', '15072026'], ['-6.978914737134811', '16072026'], ['-7.289689561365646', '17072026'], ['-7.437041255343968', '18072026'], ['-7.5835354631674186', '19072026']], 'number_of_batch': ((411,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0128043338788159, 'nb_photo': 9884, 'list_port_cont': '31204673,31204703,31204755,31204792,31204838,31204885,31204919,31204959,31204997,31205055,31205086,31205132,31205168,31205253,31205305,31205334,31205373,31205404,31205457,31205515,31205543,31205577,31205615,31209885,31209916,31209977,31210043,31210089,31210138,31210195,31210239,31210312,31210345,31210399,31210448,31210543,31211567,31211605,31211649,31211693,31211741,31211784,31213066,31213135,31213184,31213269,31213511,31213545,31213590,31213628,31213676,31213713,31213755,31213805,31213858,31213903,31213944,31214905,31214933,31214992,31215033,31215528,31215560,31215647,31216031,31216198,31216234,31216621,31216773,31217024,31217281,31217461,31217739,31217957,31218256,31218492,31218767,31219081,31219435,31219632,31219837,31220165,31220440,31220703,31220939,31221231,31221416,31221696,31221963,31222228,31222458,31222492,31222919,31223122,31223403,31223636,31223939,31224195,31224386,31224618,31224841,31225060,31225381,31225971,31226049,31226483,31226859,31226905,31227183,31227438,31227813,31228135,31228343,3122858', 'assoc_port': '31202979:31204673,31202980:31204703,31202981:31204755,31202982:31204792,31202983:31204838,31202984:31204885,31202985:31204919,31202986:31204959,31202987:31204997,31202988:31205055,31202989:31205086,31202990:31205132,31202991:31205168,31202993:31205253,31202994:31205305,31202995:31205334,31202996:31205373,31202997:31205404,31202998:31205457,31202999:31205515,31203000:31205577,31203001:31205543,31203002:31205615,31203197:31209885,31203198:31209916,31203199:31213269,31203200:31209977,31203201:31210043,31203202:31210089,31203203:31210138,31203204:31210195,31203205:31210239,31203206:31213066,31203207:31210312,31203208:31213135,31203209:31210345,31203211:31210399,31203212:31210448,31203213:31213184,31203214:31210543,31203489:31211567,31203989:31211605,31204429:31211649,31204539:31211693,31205033:31211741,31205034:31211784,31211809:31213545,31211810:31213511,31211811:31213590,31211812:31213628,31211813:31213676,31211815:31213713,31211816:31213755,31211817:31213805,31211818:31213858,31211819:31213903,31211821:3121394', 'assoc_mat': '31202979:autre:4230:31204673,31202980:autre:4230:31204703,31202981:autre:4230:31204755,31202982:autre:4230:31204792,31202983:autre:4230:31204838,31202984:autre:4230:31204885,31202985:autre:4230:31204919,31202986:autre:4230:31204959,31202987:autre:4230:31204997,31202988:autre:4230:31205055,31202989:autre:4230:31205086,31202990:autre:4230:31205132,31202991:autre:4230:31205168,31202993:autre:4230:31205253,31202994:autre:4230:31205305,31202995:autre:4230:31205334,31202996:autre:4230:31205373,31202997:autre:4230:31205404,31202998:autre:4230:31205457,31202999:autre:4230:31205515,31203000:autre:4230:31205577,31203001:autre:4230:31205543,31203002:autre:4230:31205615,31203197:autre:4230:31209885,31203198:autre:4230:31209916,31203199:autre:4230:31213269,31203200:autre:4230:31209977,31203201:autre:4230:31210043,31203202:autre:4230:31210089,31203203:autre:4230:31210138,31203204:autre:4230:31210195,31203205:autre:4230:31210239,31203206:autre:4230:31213066,31203207:autre:4230:31210312,31203208:autre:4230:31213135,31203209:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.03167964940775468, 'nb_photo': 38942, 'list_port_cont': '31204674,31204708,31204763,31204808,31204850,31204889,31204924,31204972,31205002,31205054,31205088,31205134,31205176,31205243,31205302,31205342,31205379,31205417,31205465,31205514,31205553,31205592,31205619,31209884,31209922,31209986,31210050,31210096,31210135,31210190,31210238,31210313,31210349,31210405,31210441,31210548,31211561,31211617,31211657,31211698,31211730,31211781,31213058,31213145,31213192,31213277,31213502,31213542,31213588,31213632,31213681,31213715,31213766,31213812,31213859,31213912,31213946,31214912,31214946,31215001,31215036,31215529,31215566,31215644,31216041,31216199,31216247,31216618,31216788,31217023,31217280,31217462,31217727,31217966,31218252,31218503,31218755,31219092,31219436,31219636,31219839,31220160,31220427,31220712,31220949,31221238,31221428,31221701,31221966,31222236,31222457,31222504,31222907,31223135,31223404,31223638,31223948,31224201,31224392,31224628,31224845,31225067,31225393,31225964,31226043,31226497,31226869,31226902,31227196,31227447,31227814,31228134,31228347,3122858', 'assoc_port': '31202979:31204674,31202980:31204708,31202981:31204763,31202982:31204808,31202983:31204850,31202984:31204889,31202985:31204924,31202986:31204972,31202987:31205002,31202988:31205054,31202989:31205088,31202990:31205134,31202991:31205176,31202993:31205243,31202994:31205302,31202995:31205342,31202996:31205379,31202997:31205417,31202998:31205465,31202999:31205514,31203000:31205592,31203001:31205553,31203002:31205619,31203197:31209884,31203198:31209922,31203199:31213277,31203200:31209986,31203201:31210050,31203202:31210096,31203203:31210135,31203204:31210190,31203205:31210238,31203206:31213058,31203207:31210313,31203208:31213145,31203209:31210349,31203211:31210405,31203212:31210441,31203213:31213192,31203214:31210548,31203489:31211561,31203989:31211617,31204429:31211657,31204539:31211698,31205033:31211730,31205034:31211781,31211809:31213542,31211810:31213502,31211811:31213588,31211812:31213632,31211813:31213681,31211815:31213715,31211816:31213766,31211817:31213812,31211818:31213859,31211819:31213912,31211821:3121394', 'assoc_mat': '31202979:carton:4230:31204674,31202980:carton:4230:31204708,31202981:carton:4230:31204763,31202982:carton:4230:31204808,31202983:carton:4230:31204850,31202984:carton:4230:31204889,31202985:carton:4230:31204924,31202986:carton:4230:31204972,31202987:carton:4230:31205002,31202988:carton:4230:31205054,31202989:carton:4230:31205088,31202990:carton:4230:31205134,31202991:carton:4230:31205176,31202993:carton:4230:31205243,31202994:carton:4230:31205302,31202995:carton:4230:31205342,31202996:carton:4230:31205379,31202997:carton:4230:31205417,31202998:carton:4230:31205465,31202999:carton:4230:31205514,31203000:carton:4230:31205592,31203001:carton:4230:31205553,31203002:carton:4230:31205619,31203197:carton:4230:31209884,31203198:carton:4230:31209922,31203199:carton:4230:31213277,31203200:carton:4230:31209986,31203201:carton:4230:31210050,31203202:carton:4230:31210096,31203203:carton:4230:31210135,31203204:carton:4230:31210190,31203205:carton:4230:31210238,31203206:carton:4230:31213058,31203207:carton:4230:31210313,3120'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011764421498006929, 'nb_photo': 761, 'list_port_cont': '31204793,31204844,31204879,31204973,31204999,31205043,31205089,31205124,31205298,31205325,31205382,31205415,31205450,31205503,31205579,31205626,31209924,31209982,31210044,31210084,31210235,31210305,31210391,31210455,31210541,31211568,31211656,31211691,31211727,31211777,31213069,31213185,31213271,31213546,31213578,31213670,31213710,31213807,31213843,31213909,31213934,31214898,31214949,31215000,31215027,31215512,31215569,31215639,31216042,31216200,31216235,31217031,31217267,31217463,31217738,31217961,31218491,31218764,31219095,31219431,31219622,31219832,31220158,31220438,31220705,31220947,31221240,31221417,31221699,31221973,31222235,31222500,31222909,31224194,31224387,31224630,31224840,31225070,31225389,31225957,31226493,31226855,31226909,31227195,31227443,31227805,31228133,31228349,31228587,31228915,31229545,31229829,31230111,31230382,31230910,31231403,31231913,31232096,31232398,31232846,31233167,31233870,31234196,31234766,31235660,31236051,31236317,31236552,31237002,31237112,31237417,31237705,31238038,3123833', 'assoc_port': '31202982:31204793,31202983:31204844,31202984:31204879,31202986:31204973,31202987:31204999,31202988:31205043,31202989:31205089,31202990:31205124,31202994:31205298,31202995:31205325,31202996:31205382,31202997:31205415,31202998:31205450,31202999:31205503,31203000:31205579,31203002:31205626,31203198:31209924,31203199:31213271,31203200:31209982,31203201:31210044,31203202:31210084,31203205:31210235,31203206:31213069,31203207:31210305,31203211:31210391,31203212:31210455,31203213:31213185,31203214:31210541,31203489:31211568,31204429:31211656,31204539:31211691,31205033:31211727,31205034:31211777,31211809:31213546,31211811:31213578,31211813:31213670,31211815:31213710,31211817:31213807,31211818:31213843,31211819:31213909,31211821:31213934,31214509:31214898,31214510:31216042,31214511:31214949,31214512:31215000,31214513:31215027,31215317:31215512,31215318:31215569,31215319:31215639,31215807:31216200,31215809:31216235,31216867:31217031,31217189:31217267,31217419:31217463,31217685:31217738,31217918:31217961,31218466:3121849', 'assoc_mat': '31202982:metal:4230:31204793,31202983:metal:4230:31204844,31202984:metal:4230:31204879,31202986:metal:4230:31204973,31202987:metal:4230:31204999,31202988:metal:4230:31205043,31202989:metal:4230:31205089,31202990:metal:4230:31205124,31202994:metal:4230:31205298,31202995:metal:4230:31205325,31202996:metal:4230:31205382,31202997:metal:4230:31205415,31202998:metal:4230:31205450,31202999:metal:4230:31205503,31203000:metal:4230:31205579,31203002:metal:4230:31205626,31203198:metal:4230:31209924,31203199:metal:4230:31213271,31203200:metal:4230:31209982,31203201:metal:4230:31210044,31203202:metal:4230:31210084,31203205:metal:4230:31210235,31203206:metal:4230:31213069,31203207:metal:4230:31210305,31203211:metal:4230:31210391,31203212:metal:4230:31210455,31203213:metal:4230:31213185,31203214:metal:4230:31210541,31203489:metal:4230:31211568,31204429:metal:4230:31211656,31204539:metal:4230:31211691,31205033:metal:4230:31211727,31205034:metal:4230:31211777,31211809:metal:4230:31213546,31211811:metal:4230:31213578,31211813:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19162503622535962, 'nb_photo': 198148, 'list_port_cont': '31204678,31204712,31204761,31204806,31204843,31204888,31204915,31204971,31205005,31205056,31205096,31205141,31205170,31205216,31205250,31205299,31205336,31205377,31205410,31205461,31205505,31205556,31205589,31205625,31209881,31209911,31209979,31210052,31210090,31210133,31210192,31210245,31210311,31210358,31210398,31210452,31210551,31211565,31211616,31211651,31211703,31211743,31211786,31213071,31213143,31213190,31213270,31213515,31213551,31213582,31213627,31213683,31213714,31213752,31213817,31213854,31213907,31213942,31214903,31214935,31214999,31215029,31215525,31215567,31215654,31216035,31216206,31216237,31216610,31216784,31217022,31217279,31217460,31217734,31217965,31218251,31218488,31218760,31219093,31219439,31219634,31219840,31220163,31220432,31220704,31220952,31221234,31221431,31221702,31221974,31222230,31222456,31222502,31222920,31223139,31223402,31223633,31223949,31224209,31224395,31224619,31224846,31225073,31225386,31225968,31226047,31226496,31226866,31226915,31227181,31227442,31227808,31228131,3122835', 'assoc_port': '31202979:31204678,31202980:31204712,31202981:31204761,31202982:31204806,31202983:31204843,31202984:31204888,31202985:31204915,31202986:31204971,31202987:31205005,31202988:31205056,31202989:31205096,31202990:31205141,31202991:31205170,31202992:31205216,31202993:31205250,31202994:31205299,31202995:31205336,31202996:31205377,31202997:31205410,31202998:31205461,31202999:31205505,31203000:31205589,31203001:31205556,31203002:31205625,31203197:31209881,31203198:31209911,31203199:31213270,31203200:31209979,31203201:31210052,31203202:31210090,31203203:31210133,31203204:31210192,31203205:31210245,31203206:31213071,31203207:31210311,31203208:31213143,31203209:31210358,31203211:31210398,31203212:31210452,31203213:31213190,31203214:31210551,31203489:31211565,31203989:31211616,31204429:31211651,31204539:31211703,31205033:31211743,31205034:31211786,31211809:31213551,31211810:31213515,31211811:31213582,31211812:31213627,31211813:31213683,31211815:31213714,31211816:31213752,31211817:31213817,31211818:31213854,31211819:3121390', 'assoc_mat': '31202979:papier:4230:31204678,31202980:papier:4230:31204712,31202981:papier:4230:31204761,31202982:papier:4230:31204806,31202983:papier:4230:31204843,31202984:papier:4230:31204888,31202985:papier:4230:31204915,31202986:papier:4230:31204971,31202987:papier:4230:31205005,31202988:papier:4230:31205056,31202989:papier:4230:31205096,31202990:papier:4230:31205141,31202991:papier:4230:31205170,31202992:papier:4230:31205216,31202993:papier:4230:31205250,31202994:papier:4230:31205299,31202995:papier:4230:31205336,31202996:papier:4230:31205377,31202997:papier:4230:31205410,31202998:papier:4230:31205461,31202999:papier:4230:31205505,31203000:papier:4230:31205589,31203001:papier:4230:31205556,31203002:papier:4230:31205625,31203197:papier:4230:31209881,31203198:papier:4230:31209911,31203199:papier:4230:31213270,31203200:papier:4230:31209979,31203201:papier:4230:31210052,31203202:papier:4230:31210090,31203203:papier:4230:31210133,31203204:papier:4230:31210192,31203205:papier:4230:31210245,31203206:papier:4230:31213071,3120'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002648143950968219, 'nb_photo': 986, 'list_port_cont': '31204679,31204809,31204883,31204914,31204974,31205001,31205050,31205098,31205138,31205329,31205419,31205458,31205508,31205547,31210189,31210241,31210315,31210359,31210538,31211563,31211604,31213064,31213268,31213536,31213585,31213718,31213816,31213851,31213913,31213945,31214901,31214943,31214996,31215037,31215527,31215568,31215649,31216040,31216209,31216615,31216782,31217030,31217278,31217465,31217728,31217967,31218250,31218499,31218761,31219086,31219437,31219626,31219836,31220164,31220434,31220713,31220946,31221236,31221425,31221700,31221971,31222234,31222496,31222904,31223401,31223945,31224393,31224626,31224851,31225068,31225382,31226907,31227188,31227455,31228911,31229173,31229559,31229845,31230113,31230371,31230627,31230906,31231397,31231915,31232097,31232414,31232859,31233178,31233577,31233874,31234777,31235030,31235665,31236043,31236310,31237011,31237118,31237409,31237714,31238040,31238331,31238601,31238830,31238880,31239535,31239783,31240072,31240317,31240636,31240954,31241252,31242145,31242519,3124264', 'assoc_port': '31202979:31204679,31202982:31204809,31202984:31204883,31202985:31204914,31202986:31204974,31202987:31205001,31202988:31205050,31202989:31205098,31202990:31205138,31202995:31205329,31202997:31205419,31202998:31205458,31202999:31205508,31203001:31205547,31203199:31213268,31203204:31210189,31203205:31210241,31203206:31213064,31203207:31210315,31203209:31210359,31203214:31210538,31203489:31211563,31203989:31211604,31211809:31213536,31211811:31213585,31211815:31213718,31211817:31213816,31211818:31213851,31211819:31213913,31211821:31213945,31214509:31214901,31214510:31216040,31214511:31214943,31214512:31214996,31214513:31215037,31215317:31215527,31215318:31215568,31215319:31215649,31215807:31216209,31216329:31216615,31216595:31216782,31216867:31217030,31217189:31217278,31217419:31217465,31217685:31217728,31217918:31217967,31218171:31218250,31218466:31218499,31218730:31218761,31219003:31219086,31219303:31219437,31219548:31219626,31219762:31219836,31220076:31220164,31220357:31220434,31220625:31220713,31220862:3122094', 'assoc_mat': '31202979:pehd:4230:31204679,31202982:pehd:4230:31204809,31202984:pehd:4230:31204883,31202985:pehd:4230:31204914,31202986:pehd:4230:31204974,31202987:pehd:4230:31205001,31202988:pehd:4230:31205050,31202989:pehd:4230:31205098,31202990:pehd:4230:31205138,31202995:pehd:4230:31205329,31202997:pehd:4230:31205419,31202998:pehd:4230:31205458,31202999:pehd:4230:31205508,31203001:pehd:4230:31205547,31203199:pehd:4230:31213268,31203204:pehd:4230:31210189,31203205:pehd:4230:31210241,31203206:pehd:4230:31213064,31203207:pehd:4230:31210315,31203209:pehd:4230:31210359,31203214:pehd:4230:31210538,31203489:pehd:4230:31211563,31203989:pehd:4230:31211604,31211809:pehd:4230:31213536,31211811:pehd:4230:31213585,31211815:pehd:4230:31213718,31211817:pehd:4230:31213816,31211818:pehd:4230:31213851,31211819:pehd:4230:31213913,31211821:pehd:4230:31213945,31214509:pehd:4230:31214901,31214510:pehd:4230:31216040,31214511:pehd:4230:31214943,31214512:pehd:4230:31214996,31214513:pehd:4230:31215037,31215317:pehd:4230:31215527,31215318:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018890234607935704, 'nb_photo': 13529, 'list_port_cont': '31204671,31204717,31204757,31204807,31204847,31204881,31204928,31204964,31205009,31205053,31205095,31205139,31205174,31205214,31205248,31205297,31205337,31205383,31205420,31205459,31205512,31205550,31205588,31205624,31209869,31209923,31209990,31210054,31210091,31210137,31210194,31210243,31210316,31210353,31210402,31210444,31210546,31211562,31211609,31211650,31211697,31211733,31211780,31213074,31213137,31213191,31213275,31213507,31213544,31213586,31213630,31213682,31213725,31213765,31213815,31213860,31213911,31213948,31214906,31214941,31214987,31215025,31215523,31215565,31215656,31216039,31216208,31216248,31216616,31216785,31217029,31217276,31217454,31217729,31217959,31218257,31218497,31218763,31219091,31219434,31219635,31219841,31220167,31220435,31220709,31220948,31221239,31221429,31221694,31221975,31222232,31222464,31222499,31222914,31223133,31223406,31223628,31223938,31224199,31224382,31224623,31224850,31225071,31225394,31225972,31226046,31226499,31226872,31226910,31227191,31227451,31227816,31228138,3122835', 'assoc_port': '31202979:31204671,31202980:31204717,31202981:31204757,31202982:31204807,31202983:31204847,31202984:31204881,31202985:31204928,31202986:31204964,31202987:31205009,31202988:31205053,31202989:31205095,31202990:31205139,31202991:31205174,31202992:31205214,31202993:31205248,31202994:31205297,31202995:31205337,31202996:31205383,31202997:31205420,31202998:31205459,31202999:31205512,31203000:31205588,31203001:31205550,31203002:31205624,31203197:31209869,31203198:31209923,31203199:31213275,31203200:31209990,31203201:31210054,31203202:31210091,31203203:31210137,31203204:31210194,31203205:31210243,31203206:31213074,31203207:31210316,31203208:31213137,31203209:31210353,31203211:31210402,31203212:31210444,31203213:31213191,31203214:31210546,31203489:31211562,31203989:31211609,31204429:31211650,31204539:31211697,31205033:31211733,31205034:31211780,31211809:31213544,31211810:31213507,31211811:31213586,31211812:31213630,31211813:31213682,31211815:31213725,31211816:31213765,31211817:31213815,31211818:31213860,31211819:3121391', 'assoc_mat': '31202979:pet_clair:4230:31204671,31202980:pet_clair:4230:31204717,31202981:pet_clair:4230:31204757,31202982:pet_clair:4230:31204807,31202983:pet_clair:4230:31204847,31202984:pet_clair:4230:31204881,31202985:pet_clair:4230:31204928,31202986:pet_clair:4230:31204964,31202987:pet_clair:4230:31205009,31202988:pet_clair:4230:31205053,31202989:pet_clair:4230:31205095,31202990:pet_clair:4230:31205139,31202991:pet_clair:4230:31205174,31202992:pet_clair:4230:31205214,31202993:pet_clair:4230:31205248,31202994:pet_clair:4230:31205297,31202995:pet_clair:4230:31205337,31202996:pet_clair:4230:31205383,31202997:pet_clair:4230:31205420,31202998:pet_clair:4230:31205459,31202999:pet_clair:4230:31205512,31203000:pet_clair:4230:31205588,31203001:pet_clair:4230:31205550,31203002:pet_clair:4230:31205624,31203197:pet_clair:4230:31209869,31203198:pet_clair:4230:31209923,31203199:pet_clair:4230:31213275,31203200:pet_clair:4230:31209990,31203201:pet_clair:4230:31210054,31203202:pet_clair:4230:31210091,31203203:pet_clair:4230:31210137,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023441415582911326, 'nb_photo': 497, 'list_port_cont': '31205049,31205099,31205129,31205304,31210098,31210141,31210236,31210309,31210447,31210545,31211566,31211694,31213073,31213134,31213274,31213512,31213549,31213584,31213631,31213673,31213850,31213904,31213940,31214909,31214997,31215034,31215524,31216037,31216203,31216608,31216783,31217025,31217466,31217963,31218258,31218768,31219085,31219443,31219628,31219843,31220162,31220441,31220700,31220955,31221232,31221423,31221697,31221965,31222239,31222505,31222916,31223134,31223397,31223631,31223947,31224207,31224391,31224629,31224852,31225973,31226914,31227819,31228139,31228906,31229557,31229834,31230118,31230369,31233878,31234188,31234490,31234773,31235029,31235677,31236053,31236313,31236564,31236847,31237108,31237423,31237707,31238031,31238339,31238604,31240071,31240949,31241241,31242138,31242526,31242657,31244155,31244563,31244685,31245414,31245449,31245506,31245550,31245642,31245692,31246039,31246175,31246215,31246246,31246289,31246368,31246425,31247445,31247491,31247568,31247625,31248182,31248226,31248297,3124852', 'assoc_port': '31202988:31205049,31202989:31205099,31202990:31205129,31202994:31205304,31203199:31213274,31203202:31210098,31203203:31210141,31203205:31210236,31203206:31213073,31203207:31210309,31203208:31213134,31203212:31210447,31203214:31210545,31203489:31211566,31204539:31211694,31211809:31213549,31211810:31213512,31211811:31213584,31211812:31213631,31211813:31213673,31211818:31213850,31211819:31213904,31211821:31213940,31214509:31214909,31214510:31216037,31214512:31214997,31214513:31215034,31215317:31215524,31215807:31216203,31216329:31216608,31216595:31216783,31216867:31217025,31217419:31217466,31217918:31217963,31218171:31218258,31218730:31218768,31219003:31219085,31219303:31219443,31219548:31219628,31219762:31219843,31220076:31220162,31220357:31220441,31220625:31220700,31220862:31220955,31221117:31221232,31221392:31221423,31221628:31221697,31221899:31221965,31222162:31222239,31222427:31222505,31222841:31222916,31223104:31223134,31223368:31223397,31223600:31223631,31223862:31223947,31224138:31224207,31224357:3122439', 'assoc_mat': '31202988:pet_fonce:4230:31205049,31202989:pet_fonce:4230:31205099,31202990:pet_fonce:4230:31205129,31202994:pet_fonce:4230:31205304,31203199:pet_fonce:4230:31213274,31203202:pet_fonce:4230:31210098,31203203:pet_fonce:4230:31210141,31203205:pet_fonce:4230:31210236,31203206:pet_fonce:4230:31213073,31203207:pet_fonce:4230:31210309,31203208:pet_fonce:4230:31213134,31203212:pet_fonce:4230:31210447,31203214:pet_fonce:4230:31210545,31203489:pet_fonce:4230:31211566,31204539:pet_fonce:4230:31211694,31211809:pet_fonce:4230:31213549,31211810:pet_fonce:4230:31213512,31211811:pet_fonce:4230:31213584,31211812:pet_fonce:4230:31213631,31211813:pet_fonce:4230:31213673,31211818:pet_fonce:4230:31213850,31211819:pet_fonce:4230:31213904,31211821:pet_fonce:4230:31213940,31214509:pet_fonce:4230:31214909,31214510:pet_fonce:4230:31216037,31214512:pet_fonce:4230:31214997,31214513:pet_fonce:4230:31215034,31215317:pet_fonce:4230:31215524,31215807:pet_fonce:4230:31216203,31216329:pet_fonce:4230:31216608,31216595:pet_fonce:4230:31216783,3'}), 'main_stat': {'nb_photos': 1154}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31302772,31302773,31302774,31302775,31302776,31302777,31302778?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-07', 0.7617754061813018),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_07_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.28%', 9884], 'carton': ['carton', '3.17%', 38942], 'metal': ['metal', '0.12%', 761], 'papier': ['papier', '19.16%', 198148], 'pehd': ['pehd', '0.26%', 986], 'pet_clair': ['pet_clair', '1.89%', 13529], 'pet_fonce': ['pet_fonce', '0.23%', 497]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_07_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.53user 3.13system 0:10.11elapsed 55%CPU (0avgtext+0avgdata 189252maxresident)k 20848inputs+296outputs (109major+52990minor)pagefaults 0swaps