python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-05 _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 : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 05 mtr_id : dashboard_places : SCCU_cam7 date : 2026-05 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam7' and date like '%2026-05%') and created_at like '%2026-05%'))); nb_day : (4, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 204 and month(ded.date) = 05 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 204 and month(ded.date) = 05 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 204 and mp.name like '%052026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-05-01 : dt_date_just_month_year : 2026-05-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-05-01" AND ded.date <= "2026-05-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 (2986792,2986990,2987468,2988034,2988556,2988978,2989496,2989942,2990354,2990810,2991162,2991380,2991816,2992270,2992672,2993068,2993466,2993974,2994202,2994552,2995040,2995484,2995636) 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.011681143704624064, 'nb_photo': 10215, 'list_port_cont': '31045612,31045649,31045683,31045722,31045762,31045801,31045830,31045851,31046162,31046197,31046396,31046447,31046930,31046968,31047046,31048453,31048479,31048513,31048560,31048588,31048624,31048667,31048697,31048751,31048786,31048821,31048890,31048927,31048972,31048993,31049038,31049584,31049631,31049653,31049706,31049959,31050190,31050268,31050471,31050739,31051060,31051142,31051358,31051886,31051929,31051960,31052009,31052051,31052080,31052132,31052168,31052209,31053206,31053254,31053291,31053329,31053829,31053881,31053907,31054387,31054718,31054749,31054842,31055041,31055187,31055230,31055264,31055536,31055772,31055818,31056152,31056395,31056656,31056895,31056939,31057035,31057315,31057558,31057582,31057901,31058181,31058361,31058869,31059003,31059186,31059246,31059557,31059720,31059756,31059783,31060104,31060317,31060531,31060730,31060936,31061181,31061388,31061435,31061635,31061826,31062330,31062485,31062648,31062679,31062879,31063197,31063390,31063731,31063940,31063981,31064027,31064061,31064548,3106491', 'assoc_port': '31044719:31045612,31044720:31045649,31044721:31045683,31044722:31045722,31044723:31045762,31044724:31045801,31044725:31045851,31044726:31045830,31044727:31046162,31044728:31046197,31044729:31051886,31044730:31051929,31045929:31052009,31045931:31052051,31045932:31051960,31045933:31052080,31045934:31046396,31045935:31052132,31045936:31046447,31045937:31052168,31046288:31052209,31046301:31046930,31046302:31046968,31046303:31047046,31047165:31048453,31047166:31048513,31047167:31048479,31047168:31048560,31047169:31048588,31047170:31048624,31047285:31048667,31047286:31048697,31047287:31048751,31047340:31048786,31047341:31048821,31047343:31048890,31047697:31048927,31047698:31048972,31047699:31048993,31047700:31049038,31049371:31049584,31049372:31049631,31049373:31049653,31049374:31049706,31049424:31049959,31050033:31050190,31050034:31050268,31050377:31050471,31050633:31050739,31050885:31051060,31050886:31051142,31051246:31051358,31052869:31053206,31052870:31053254,31052871:31053291,31052872:31053329,31053556:3105382', 'assoc_mat': '31044719:autre:4230:31045612,31044720:autre:4230:31045649,31044721:autre:4230:31045683,31044722:autre:4230:31045722,31044723:autre:4230:31045762,31044724:autre:4230:31045801,31044725:autre:4230:31045851,31044726:autre:4230:31045830,31044727:autre:4230:31046162,31044728:autre:4230:31046197,31044729:autre:4230:31051886,31044730:autre:4230:31051929,31045929:autre:4230:31052009,31045931:autre:4230:31052051,31045932:autre:4230:31051960,31045933:autre:4230:31052080,31045934:autre:4230:31046396,31045935:autre:4230:31052132,31045936:autre:4230:31046447,31045937:autre:4230:31052168,31046288:autre:4230:31052209,31046301:autre:4230:31046930,31046302:autre:4230:31046968,31046303:autre:4230:31047046,31047165:autre:4230:31048453,31047166:autre:4230:31048513,31047167:autre:4230:31048479,31047168:autre:4230:31048560,31047169:autre:4230:31048588,31047170:autre:4230:31048624,31047285:autre:4230:31048667,31047286:autre:4230:31048697,31047287:autre:4230:31048751,31047340:autre:4230:31048786,31047341:autre:4230:31048821,31047343:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06582599400107365, 'nb_photo': 74500, 'list_port_cont': '31045606,31045650,31045685,31045731,31045760,31045807,31045837,31045856,31046156,31046192,31046408,31046445,31046936,31046974,31047040,31048443,31048485,31048526,31048563,31048599,31048626,31048674,31048710,31048750,31048787,31048818,31048856,31048900,31048930,31048963,31049008,31049044,31049593,31049626,31049670,31049703,31049958,31050206,31050273,31050469,31050742,31051059,31051140,31051355,31051900,31051936,31051967,31052006,31052042,31052088,31052130,31052174,31052208,31053217,31053258,31053298,31053332,31053835,31053875,31053911,31054393,31054716,31054751,31054847,31055033,31055200,31055238,31055281,31055550,31055776,31055813,31056160,31056409,31056662,31056907,31056945,31057032,31057310,31057561,31057595,31057904,31058197,31058369,31058865,31059000,31059180,31059257,31059561,31059712,31059744,31059785,31060107,31060322,31060539,31060737,31060942,31061186,31061397,31061429,31061640,31061834,31062328,31062500,31062655,31062686,31062880,31063195,31063394,31063734,31063941,31063991,31064034,31064068,3106455', 'assoc_port': '31044719:31045606,31044720:31045650,31044721:31045685,31044722:31045731,31044723:31045760,31044724:31045807,31044725:31045856,31044726:31045837,31044727:31046156,31044728:31046192,31044729:31051900,31044730:31051936,31045929:31052006,31045931:31052042,31045932:31051967,31045933:31052088,31045934:31046408,31045935:31052130,31045936:31046445,31045937:31052174,31046288:31052208,31046301:31046936,31046302:31046974,31046303:31047040,31047165:31048443,31047166:31048526,31047167:31048485,31047168:31048563,31047169:31048599,31047170:31048626,31047285:31048674,31047286:31048710,31047287:31048750,31047340:31048787,31047341:31048818,31047342:31048856,31047343:31048900,31047697:31048930,31047698:31048963,31047699:31049008,31047700:31049044,31049371:31049593,31049372:31049626,31049373:31049670,31049374:31049703,31049424:31049958,31050033:31050206,31050034:31050273,31050377:31050469,31050633:31050742,31050885:31051059,31050886:31051140,31051246:31051355,31052869:31053217,31052870:31053258,31052871:31053298,31052872:3105333', 'assoc_mat': '31044719:carton:4230:31045606,31044720:carton:4230:31045650,31044721:carton:4230:31045685,31044722:carton:4230:31045731,31044723:carton:4230:31045760,31044724:carton:4230:31045807,31044725:carton:4230:31045856,31044726:carton:4230:31045837,31044727:carton:4230:31046156,31044728:carton:4230:31046192,31044729:carton:4230:31051900,31044730:carton:4230:31051936,31045929:carton:4230:31052006,31045931:carton:4230:31052042,31045932:carton:4230:31051967,31045933:carton:4230:31052088,31045934:carton:4230:31046408,31045935:carton:4230:31052130,31045936:carton:4230:31046445,31045937:carton:4230:31052174,31046288:carton:4230:31052208,31046301:carton:4230:31046936,31046302:carton:4230:31046974,31046303:carton:4230:31047040,31047165:carton:4230:31048443,31047166:carton:4230:31048526,31047167:carton:4230:31048485,31047168:carton:4230:31048563,31047169:carton:4230:31048599,31047170:carton:4230:31048626,31047285:carton:4230:31048674,31047286:carton:4230:31048710,31047287:carton:4230:31048750,31047340:carton:4230:31048787,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013579021555111235, 'nb_photo': 1306, 'list_port_cont': '31045619,31045645,31045690,31045765,31045798,31045842,31045864,31046149,31046201,31046406,31046444,31046934,31046976,31047042,31048442,31048518,31048548,31048637,31048670,31048712,31048738,31048774,31048810,31048886,31048919,31048957,31049005,31049033,31049582,31049621,31049654,31049695,31049955,31050207,31050277,31050458,31050734,31051065,31051141,31051346,31051901,31051931,31051999,31052047,31052129,31052170,31052212,31053257,31053285,31053324,31053834,31053880,31053913,31054758,31054851,31055034,31055190,31055239,31056151,31056404,31056652,31056937,31057308,31057562,31057590,31057912,31058180,31058357,31058853,31058994,31059182,31059248,31059560,31059704,31059753,31060097,31060321,31060532,31060740,31060929,31061180,31061633,31061833,31062333,31062494,31062650,31062866,31063192,31063736,31063954,31063985,31064024,31064057,31064544,31065036,31065064,31065397,31065434,31065986,31066099,31066610,31066653,31066693,31066731,31067244,31067283,31067535,31067890,31067999,31068076,31068261,31068494,31068657,3106893', 'assoc_port': '31044719:31045619,31044720:31045645,31044721:31045690,31044723:31045765,31044724:31045798,31044725:31045864,31044726:31045842,31044727:31046149,31044728:31046201,31044729:31051901,31044730:31051931,31045929:31051999,31045931:31052047,31045934:31046406,31045935:31052129,31045936:31046444,31045937:31052170,31046288:31052212,31046301:31046934,31046302:31046976,31046303:31047042,31047165:31048442,31047166:31048518,31047168:31048548,31047170:31048637,31047285:31048670,31047286:31048712,31047287:31048738,31047340:31048774,31047341:31048810,31047343:31048886,31047697:31048919,31047698:31048957,31047699:31049005,31047700:31049033,31049371:31049582,31049372:31049621,31049373:31049654,31049374:31049695,31049424:31049955,31050033:31050207,31050034:31050277,31050377:31050458,31050633:31050734,31050885:31051065,31050886:31051141,31051246:31051346,31052870:31053257,31052871:31053285,31052872:31053324,31053556:31053834,31053558:31053913,31053560:31053880,31053988:31055034,31054427:31054758,31054428:31054851,31054988:3105519', 'assoc_mat': '31044719:metal:4230:31045619,31044720:metal:4230:31045645,31044721:metal:4230:31045690,31044723:metal:4230:31045765,31044724:metal:4230:31045798,31044725:metal:4230:31045864,31044726:metal:4230:31045842,31044727:metal:4230:31046149,31044728:metal:4230:31046201,31044729:metal:4230:31051901,31044730:metal:4230:31051931,31045929:metal:4230:31051999,31045931:metal:4230:31052047,31045934:metal:4230:31046406,31045935:metal:4230:31052129,31045936:metal:4230:31046444,31045937:metal:4230:31052170,31046288:metal:4230:31052212,31046301:metal:4230:31046934,31046302:metal:4230:31046976,31046303:metal:4230:31047042,31047165:metal:4230:31048442,31047166:metal:4230:31048518,31047168:metal:4230:31048548,31047170:metal:4230:31048637,31047285:metal:4230:31048670,31047286:metal:4230:31048712,31047287:metal:4230:31048738,31047340:metal:4230:31048774,31047341:metal:4230:31048810,31047343:metal:4230:31048886,31047697:metal:4230:31048919,31047698:metal:4230:31048957,31047699:metal:4230:31049005,31047700:metal:4230:31049033,31049371:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18492700844561905, 'nb_photo': 260555, 'list_port_cont': '31045617,31045660,31045695,31045721,31045757,31045810,31045841,31045861,31046164,31046200,31046413,31046448,31046937,31046971,31047043,31048448,31048489,31048519,31048561,31048596,31048636,31048671,31048707,31048752,31048777,31048826,31048853,31048899,31048935,31048974,31049000,31049039,31049591,31049634,31049664,31049698,31049965,31050197,31050280,31050473,31050729,31051067,31051135,31051352,31051896,31051937,31051966,31052011,31052049,31052090,31052139,31052169,31052210,31053218,31053248,31053299,31053334,31053839,31053877,31053922,31054388,31054712,31054755,31054849,31055037,31055199,31055240,31055276,31055548,31055779,31055823,31056153,31056412,31056657,31056910,31056947,31057023,31057314,31057554,31057586,31057908,31058196,31058371,31058868,31058995,31059181,31059252,31059556,31059717,31059754,31059788,31060102,31060326,31060541,31060745,31060945,31061188,31061391,31061433,31061632,31061830,31062339,31062502,31062657,31062693,31062873,31063188,31063386,31063727,31063953,31063984,31064030,31064069,3106454', 'assoc_port': '31044719:31045617,31044720:31045660,31044721:31045695,31044722:31045721,31044723:31045757,31044724:31045810,31044725:31045861,31044726:31045841,31044727:31046164,31044728:31046200,31044729:31051896,31044730:31051937,31045929:31052011,31045931:31052049,31045932:31051966,31045933:31052090,31045934:31046413,31045935:31052139,31045936:31046448,31045937:31052169,31046288:31052210,31046301:31046937,31046302:31046971,31046303:31047043,31047165:31048448,31047166:31048519,31047167:31048489,31047168:31048561,31047169:31048596,31047170:31048636,31047285:31048671,31047286:31048707,31047287:31048752,31047340:31048777,31047341:31048826,31047342:31048853,31047343:31048899,31047697:31048935,31047698:31048974,31047699:31049000,31047700:31049039,31049371:31049591,31049372:31049634,31049373:31049664,31049374:31049698,31049424:31049965,31050033:31050197,31050034:31050280,31050377:31050473,31050633:31050729,31050885:31051067,31050886:31051135,31051246:31051352,31052869:31053218,31052870:31053248,31052871:31053299,31052872:3105333', 'assoc_mat': '31044719:papier:4230:31045617,31044720:papier:4230:31045660,31044721:papier:4230:31045695,31044722:papier:4230:31045721,31044723:papier:4230:31045757,31044724:papier:4230:31045810,31044725:papier:4230:31045861,31044726:papier:4230:31045841,31044727:papier:4230:31046164,31044728:papier:4230:31046200,31044729:papier:4230:31051896,31044730:papier:4230:31051937,31045929:papier:4230:31052011,31045931:papier:4230:31052049,31045932:papier:4230:31051966,31045933:papier:4230:31052090,31045934:papier:4230:31046413,31045935:papier:4230:31052139,31045936:papier:4230:31046448,31045937:papier:4230:31052169,31046288:papier:4230:31052210,31046301:papier:4230:31046937,31046302:papier:4230:31046971,31046303:papier:4230:31047043,31047165:papier:4230:31048448,31047166:papier:4230:31048519,31047167:papier:4230:31048489,31047168:papier:4230:31048561,31047169:papier:4230:31048596,31047170:papier:4230:31048636,31047285:papier:4230:31048671,31047286:papier:4230:31048707,31047287:papier:4230:31048752,31047340:papier:4230:31048777,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004139796065696791, 'nb_photo': 1381, 'list_port_cont': '31045616,31045655,31045692,31045719,31045759,31045809,31045835,31045860,31046159,31046202,31046412,31046449,31046979,31047050,31048555,31048668,31048704,31048788,31048819,31048970,31050279,31050732,31051138,31051347,31051894,31051934,31052008,31052048,31052136,31052167,31052207,31053209,31053253,31053289,31053335,31053878,31053921,31054708,31054759,31056162,31056908,31056940,31057306,31057592,31057909,31058183,31058363,31058864,31058997,31059183,31059555,31060540,31060744,31060934,31061634,31061825,31062337,31062493,31062654,31062681,31062874,31063198,31063395,31063738,31063955,31063994,31064023,31064064,31065431,31066620,31066695,31066725,31067245,31067276,31067550,31067885,31068002,31068073,31068503,31068926,31070662,31070931,31071057,31071424,31071732,31071767,31072093,31072351,31072553,31072592,31073036,31073076,31073202,31073389,31073581,31073801,31074320,31074354,31074660,31074821,31075093,31075292,31075324,31075755,31075948,31076014,31076408,31076686,31076759,31076973,31077254,31077377,31077719,3107801', 'assoc_port': '31044719:31045616,31044720:31045655,31044721:31045692,31044722:31045719,31044723:31045759,31044724:31045809,31044725:31045860,31044726:31045835,31044727:31046159,31044728:31046202,31044729:31051894,31044730:31051934,31045929:31052008,31045931:31052048,31045934:31046412,31045935:31052136,31045936:31046449,31045937:31052167,31046288:31052207,31046302:31046979,31046303:31047050,31047168:31048555,31047285:31048668,31047286:31048704,31047340:31048788,31047341:31048819,31047698:31048970,31050034:31050279,31050633:31050732,31050886:31051138,31051246:31051347,31052869:31053209,31052870:31053253,31052871:31053289,31052872:31053335,31053558:31053921,31053560:31053878,31054425:31054708,31054427:31054759,31056024:31056162,31056725:31056908,31056726:31056940,31057174:31057306,31057405:31057592,31057739:31057909,31058085:31058183,31058223:31058363,31058403:31058997,31058626:31058864,31058969:31059183,31059280:31059555,31060437:31060540,31060644:31060744,31060807:31060934,31061536:31061634,31061733:31061825,31061982:3106249', 'assoc_mat': '31044719:pehd:4230:31045616,31044720:pehd:4230:31045655,31044721:pehd:4230:31045692,31044722:pehd:4230:31045719,31044723:pehd:4230:31045759,31044724:pehd:4230:31045809,31044725:pehd:4230:31045860,31044726:pehd:4230:31045835,31044727:pehd:4230:31046159,31044728:pehd:4230:31046202,31044729:pehd:4230:31051894,31044730:pehd:4230:31051934,31045929:pehd:4230:31052008,31045931:pehd:4230:31052048,31045934:pehd:4230:31046412,31045935:pehd:4230:31052136,31045936:pehd:4230:31046449,31045937:pehd:4230:31052167,31046288:pehd:4230:31052207,31046302:pehd:4230:31046979,31046303:pehd:4230:31047050,31047168:pehd:4230:31048555,31047285:pehd:4230:31048668,31047286:pehd:4230:31048704,31047340:pehd:4230:31048788,31047341:pehd:4230:31048819,31047698:pehd:4230:31048970,31050034:pehd:4230:31050279,31050633:pehd:4230:31050732,31050886:pehd:4230:31051138,31051246:pehd:4230:31051347,31052869:pehd:4230:31053209,31052870:pehd:4230:31053253,31052871:pehd:4230:31053289,31052872:pehd:4230:31053335,31053558:pehd:4230:31053921,31053560:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013466177482616495, 'nb_photo': 11078, 'list_port_cont': '31045613,31045654,31045689,31045732,31045761,31045800,31045846,31045849,31046161,31046198,31046405,31046452,31046939,31046978,31047045,31048449,31048484,31048527,31048558,31048597,31048633,31048659,31048709,31048743,31048790,31048824,31048861,31048894,31048934,31048973,31048997,31049036,31049585,31049619,31049666,31049692,31049967,31050202,31050272,31050475,31050745,31051066,31051130,31051356,31051898,31051930,31051975,31052013,31052043,31052085,31052140,31052176,31052216,31053207,31053256,31053295,31053336,31053838,31053885,31053923,31054397,31054709,31054753,31054846,31055039,31055197,31055236,31055278,31055546,31055786,31055822,31056161,31056400,31056663,31056899,31056949,31057025,31057316,31057549,31057598,31057913,31058191,31058368,31058855,31059001,31059175,31059258,31059562,31059719,31059757,31059787,31060110,31060325,31060529,31060743,31060943,31061187,31061386,31061431,31061628,31061836,31062336,31062501,31062653,31062691,31062869,31063201,31063400,31063737,31063948,31063993,31064029,31064070,3106454', 'assoc_port': '31044719:31045613,31044720:31045654,31044721:31045689,31044722:31045732,31044723:31045761,31044724:31045800,31044725:31045849,31044726:31045846,31044727:31046161,31044728:31046198,31044729:31051898,31044730:31051930,31045929:31052013,31045931:31052043,31045932:31051975,31045933:31052085,31045934:31046405,31045935:31052140,31045936:31046452,31045937:31052176,31046288:31052216,31046301:31046939,31046302:31046978,31046303:31047045,31047165:31048449,31047166:31048527,31047167:31048484,31047168:31048558,31047169:31048597,31047170:31048633,31047285:31048659,31047286:31048709,31047287:31048743,31047340:31048790,31047341:31048824,31047342:31048861,31047343:31048894,31047697:31048934,31047698:31048973,31047699:31048997,31047700:31049036,31049371:31049585,31049372:31049619,31049373:31049666,31049374:31049692,31049424:31049967,31050033:31050202,31050034:31050272,31050377:31050475,31050633:31050745,31050885:31051066,31050886:31051130,31051246:31051356,31052869:31053207,31052870:31053256,31052871:31053295,31052872:3105333', 'assoc_mat': '31044719:pet_clair:4230:31045613,31044720:pet_clair:4230:31045654,31044721:pet_clair:4230:31045689,31044722:pet_clair:4230:31045732,31044723:pet_clair:4230:31045761,31044724:pet_clair:4230:31045800,31044725:pet_clair:4230:31045849,31044726:pet_clair:4230:31045846,31044727:pet_clair:4230:31046161,31044728:pet_clair:4230:31046198,31044729:pet_clair:4230:31051898,31044730:pet_clair:4230:31051930,31045929:pet_clair:4230:31052013,31045931:pet_clair:4230:31052043,31045932:pet_clair:4230:31051975,31045933:pet_clair:4230:31052085,31045934:pet_clair:4230:31046405,31045935:pet_clair:4230:31052140,31045936:pet_clair:4230:31046452,31045937:pet_clair:4230:31052176,31046288:pet_clair:4230:31052216,31046301:pet_clair:4230:31046939,31046302:pet_clair:4230:31046978,31046303:pet_clair:4230:31047045,31047165:pet_clair:4230:31048449,31047166:pet_clair:4230:31048527,31047167:pet_clair:4230:31048484,31047168:pet_clair:4230:31048558,31047169:pet_clair:4230:31048597,31047170:pet_clair:4230:31048633,31047285:pet_clair:4230:31048659,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0025192353321460727, 'nb_photo': 395, 'list_port_cont': '31045608,31045697,31045806,31045859,31046155,31046404,31046450,31047053,31048517,31048673,31048713,31048964,31049968,31050199,31050736,31051139,31051348,31051899,31051926,31051974,31052010,31052137,31053259,31053840,31053883,31053919,31054757,31055547,31056906,31056942,31057034,31057302,31057594,31058195,31058862,31058996,31059750,31061828,31062327,31062499,31062652,31062690,31062878,31063739,31063944,31064067,31065998,31066029,31066114,31067246,31067882,31068665,31068966,31069461,31070667,31070936,31071052,31071423,31071733,31071766,31072096,31072350,31073189,31073589,31074656,31074814,31075097,31075294,31075332,31075745,31075944,31076024,31076683,31076762,31076960,31077253,31077384,31077721,31078028,31078067,31078451,31078714,31078906,31078946,31079338,31079811,31079968,31080212,31080464,31080532,31080810,31081223,31081708,31082413,31082654,31082877,31083103,31083182,31083650,31085887,31086071,31086846,31087413,31087794,31088214,31089479,31090405,31090737,31091477,31091516,31091557,31091632,31091677,3109172', 'assoc_port': '31044719:31045608,31044721:31045697,31044724:31045806,31044725:31045859,31044727:31046155,31044729:31051899,31044730:31051926,31045929:31052010,31045932:31051974,31045934:31046404,31045935:31052137,31045936:31046450,31046303:31047053,31047166:31048517,31047285:31048673,31047286:31048713,31047698:31048964,31049424:31049968,31050033:31050199,31050633:31050736,31050886:31051139,31051246:31051348,31052870:31053259,31053556:31053840,31053558:31053919,31053560:31053883,31054427:31054757,31055396:31055547,31056477:31057034,31056725:31056906,31056726:31056942,31057174:31057302,31057405:31057594,31058085:31058195,31058403:31058996,31058626:31058862,31059582:31059750,31061733:31061828,31061982:31062499,31062182:31062327,31062448:31062652,31062449:31062690,31062799:31062878,31063557:31063739,31063801:31063944,31063804:31064067,31065712:31065998,31065777:31066114,31065778:31066029,31066969:31067246,31067613:31067882,31068571:31068665,31068799:31068966,31069363:31069461,31070243:31071052,31070564:31070667,31070795:3107093', 'assoc_mat': '31044719:pet_fonce:4230:31045608,31044721:pet_fonce:4230:31045697,31044724:pet_fonce:4230:31045806,31044725:pet_fonce:4230:31045859,31044727:pet_fonce:4230:31046155,31044729:pet_fonce:4230:31051899,31044730:pet_fonce:4230:31051926,31045929:pet_fonce:4230:31052010,31045932:pet_fonce:4230:31051974,31045934:pet_fonce:4230:31046404,31045935:pet_fonce:4230:31052137,31045936:pet_fonce:4230:31046450,31046303:pet_fonce:4230:31047053,31047166:pet_fonce:4230:31048517,31047285:pet_fonce:4230:31048673,31047286:pet_fonce:4230:31048713,31047698:pet_fonce:4230:31048964,31049424:pet_fonce:4230:31049968,31050033:pet_fonce:4230:31050199,31050633:pet_fonce:4230:31050736,31050886:pet_fonce:4230:31051139,31051246:pet_fonce:4230:31051348,31052870:pet_fonce:4230:31053259,31053556:pet_fonce:4230:31053840,31053558:pet_fonce:4230:31053919,31053560:pet_fonce:4230:31053883,31054427:pet_fonce:4230:31054757,31055396:pet_fonce:4230:31055547,31056477:pet_fonce:4230:31057034,31056725:pet_fonce:4230:31056906,31056726:pet_fonce:4230:31056942,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(2986792,2986990,2987468,2988034,2988556,2988978,2989496,2989942,2990354,2990810,2991162,2991380,2991816,2992270,2992672,2993068,2993466,2993974,2994202,2994552,2995040,2995484,2995636)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081562, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045612,31045649,31045683,31045722,31045762,31045801,31045830,31045851,31046162,31046197,31046396,31046447,31046930,31046968,31047046,31048453,31048479,31048513,31048560,31048588,31048624,31048667,31048697,31048751,31048786,31048821,31048890,31048927,31048972,31048993,31049038,31049584,31049631,31049653,31049706,31049959,31050190,31050268,31050471,31050739,31051060,31051142,31051358,31051886,31051929,31051960,31052009,31052051,31052080,31052132,31052168,31052209,31053206,31053254,31053291,31053329,31053829,31053881,31053907,31054387,31054718,31054749,31054842,31055041,31055187,31055230,31055264,31055536,31055772,31055818,31056152,31056395,31056656,31056895,31056939,31057035,31057315,31057558,31057582,31057901,31058181,31058361,31058869,31059003,31059186,31059246,31059557,31059720,31059756,31059783,31060104,31060317,31060531,31060730,31060936,31061181,31061388,31061435,31061635,31061826,31062330,31062485,31062648,31062679,31062879,31063197,31063390,31063731,31063940,31063981,31064027,31064061,31064548,3106491 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081563, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045606,31045650,31045685,31045731,31045760,31045807,31045837,31045856,31046156,31046192,31046408,31046445,31046936,31046974,31047040,31048443,31048485,31048526,31048563,31048599,31048626,31048674,31048710,31048750,31048787,31048818,31048856,31048900,31048930,31048963,31049008,31049044,31049593,31049626,31049670,31049703,31049958,31050206,31050273,31050469,31050742,31051059,31051140,31051355,31051900,31051936,31051967,31052006,31052042,31052088,31052130,31052174,31052208,31053217,31053258,31053298,31053332,31053835,31053875,31053911,31054393,31054716,31054751,31054847,31055033,31055200,31055238,31055281,31055550,31055776,31055813,31056160,31056409,31056662,31056907,31056945,31057032,31057310,31057561,31057595,31057904,31058197,31058369,31058865,31059000,31059180,31059257,31059561,31059712,31059744,31059785,31060107,31060322,31060539,31060737,31060942,31061186,31061397,31061429,31061640,31061834,31062328,31062500,31062655,31062686,31062880,31063195,31063394,31063734,31063941,31063991,31064034,31064068,3106455 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081564, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045619,31045645,31045690,31045765,31045798,31045842,31045864,31046149,31046201,31046406,31046444,31046934,31046976,31047042,31048442,31048518,31048548,31048637,31048670,31048712,31048738,31048774,31048810,31048886,31048919,31048957,31049005,31049033,31049582,31049621,31049654,31049695,31049955,31050207,31050277,31050458,31050734,31051065,31051141,31051346,31051901,31051931,31051999,31052047,31052129,31052170,31052212,31053257,31053285,31053324,31053834,31053880,31053913,31054758,31054851,31055034,31055190,31055239,31056151,31056404,31056652,31056937,31057308,31057562,31057590,31057912,31058180,31058357,31058853,31058994,31059182,31059248,31059560,31059704,31059753,31060097,31060321,31060532,31060740,31060929,31061180,31061633,31061833,31062333,31062494,31062650,31062866,31063192,31063736,31063954,31063985,31064024,31064057,31064544,31065036,31065064,31065397,31065434,31065986,31066099,31066610,31066653,31066693,31066731,31067244,31067283,31067535,31067890,31067999,31068076,31068261,31068494,31068657,3106893 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081565, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045617,31045660,31045695,31045721,31045757,31045810,31045841,31045861,31046164,31046200,31046413,31046448,31046937,31046971,31047043,31048448,31048489,31048519,31048561,31048596,31048636,31048671,31048707,31048752,31048777,31048826,31048853,31048899,31048935,31048974,31049000,31049039,31049591,31049634,31049664,31049698,31049965,31050197,31050280,31050473,31050729,31051067,31051135,31051352,31051896,31051937,31051966,31052011,31052049,31052090,31052139,31052169,31052210,31053218,31053248,31053299,31053334,31053839,31053877,31053922,31054388,31054712,31054755,31054849,31055037,31055199,31055240,31055276,31055548,31055779,31055823,31056153,31056412,31056657,31056910,31056947,31057023,31057314,31057554,31057586,31057908,31058196,31058371,31058868,31058995,31059181,31059252,31059556,31059717,31059754,31059788,31060102,31060326,31060541,31060745,31060945,31061188,31061391,31061433,31061632,31061830,31062339,31062502,31062657,31062693,31062873,31063188,31063386,31063727,31063953,31063984,31064030,31064069,3106454 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081566, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045616,31045655,31045692,31045719,31045759,31045809,31045835,31045860,31046159,31046202,31046412,31046449,31046979,31047050,31048555,31048668,31048704,31048788,31048819,31048970,31050279,31050732,31051138,31051347,31051894,31051934,31052008,31052048,31052136,31052167,31052207,31053209,31053253,31053289,31053335,31053878,31053921,31054708,31054759,31056162,31056908,31056940,31057306,31057592,31057909,31058183,31058363,31058864,31058997,31059183,31059555,31060540,31060744,31060934,31061634,31061825,31062337,31062493,31062654,31062681,31062874,31063198,31063395,31063738,31063955,31063994,31064023,31064064,31065431,31066620,31066695,31066725,31067245,31067276,31067550,31067885,31068002,31068073,31068503,31068926,31070662,31070931,31071057,31071424,31071732,31071767,31072093,31072351,31072553,31072592,31073036,31073076,31073202,31073389,31073581,31073801,31074320,31074354,31074660,31074821,31075093,31075292,31075324,31075755,31075948,31076014,31076408,31076686,31076759,31076973,31077254,31077377,31077719,3107801 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081567, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045613,31045654,31045689,31045732,31045761,31045800,31045846,31045849,31046161,31046198,31046405,31046452,31046939,31046978,31047045,31048449,31048484,31048527,31048558,31048597,31048633,31048659,31048709,31048743,31048790,31048824,31048861,31048894,31048934,31048973,31048997,31049036,31049585,31049619,31049666,31049692,31049967,31050202,31050272,31050475,31050745,31051066,31051130,31051356,31051898,31051930,31051975,31052013,31052043,31052085,31052140,31052176,31052216,31053207,31053256,31053295,31053336,31053838,31053885,31053923,31054397,31054709,31054753,31054846,31055039,31055197,31055236,31055278,31055546,31055786,31055822,31056161,31056400,31056663,31056899,31056949,31057025,31057316,31057549,31057598,31057913,31058191,31058368,31058855,31059001,31059175,31059258,31059562,31059719,31059757,31059787,31060110,31060325,31060529,31060743,31060943,31061187,31061386,31061431,31061628,31061836,31062336,31062501,31062653,31062691,31062869,31063201,31063400,31063737,31063948,31063993,31064029,31064070,3106454 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 31081568, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (31045608,31045697,31045806,31045859,31046155,31046404,31046450,31047053,31048517,31048673,31048713,31048964,31049968,31050199,31050736,31051139,31051348,31051899,31051926,31051974,31052010,31052137,31053259,31053840,31053883,31053919,31054757,31055547,31056906,31056942,31057034,31057302,31057594,31058195,31058862,31058996,31059750,31061828,31062327,31062499,31062652,31062690,31062878,31063739,31063944,31064067,31065998,31066029,31066114,31067246,31067882,31068665,31068966,31069461,31070667,31070936,31071052,31071423,31071733,31071766,31072096,31072350,31073189,31073589,31074656,31074814,31075097,31075294,31075332,31075745,31075944,31076024,31076683,31076762,31076960,31077253,31077384,31077721,31078028,31078067,31078451,31078714,31078906,31078946,31079338,31079811,31079968,31080212,31080464,31080532,31080810,31081223,31081708,31082413,31082654,31082877,31083103,31083182,31083650,31085887,31086071,31086846,31087413,31087794,31088214,31089479,31090405,31090737,31091477,31091516,31091557,31091632,31091677,3109172 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/31081562,31081563,31081564,31081565,31081566,31081567,31081568?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2026-05-01' and date <= '2026-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1175,),), 'unwanted_material_monthly_percentage': ((0.7439077625039429,),), 'material_repartition': (('incineration', 1175),), 'material_dict': {'incineration': 1175}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 5, 9), 0.6740148956740266, 2), (datetime.date(2026, 5, 10), 0.783726236639823, 3), (datetime.date(2026, 5, 11), 0.7861519125425128, 1), (datetime.date(2026, 5, 12), 0.8117012943806187, 3), (datetime.date(2026, 5, 13), 0.7474963984077593, 2), (datetime.date(2026, 5, 14), 0.7980905359846056, 3), (datetime.date(2026, 5, 15), 0.7820250061738308, 1), (datetime.date(2026, 5, 16), 0.637449068368433, 3), (datetime.date(2026, 5, 17), 0.7277177651028889, 2), (datetime.date(2026, 5, 18), 0.7698474390552236, 3), (datetime.date(2026, 5, 19), 0.7790814254018098, 2), (datetime.date(2026, 5, 20), 0.7031881235379123, 1), (datetime.date(2026, 5, 21), 0.7149174785752541, 2), (datetime.date(2026, 5, 22), 0.7076551277059353, 3), (datetime.date(2026, 5, 23), 0.708215681964119, 4), (datetime.date(2026, 5, 24), 0.7702685245464985, 3), (datetime.date(2026, 5, 25), 0.8006390789351988, 3), (datetime.date(2026, 5, 26), 0.801488383399772, 4), (datetime.date(2026, 5, 27), 0.7258315883950449, 3), (datetime.date(2026, 5, 28), 0.7100456378417138, 2), (datetime.date(2026, 5, 29), 0.7190221855657818, 1), (datetime.date(2026, 5, 30), 0.5790792661438733, 1), (datetime.date(2026, 5, 31), 0.6700617419196083, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 5, 9), 0.6740148956740266, 2), (datetime.date(2026, 5, 10), 0.783726236639823, 3), (datetime.date(2026, 5, 11), 0.7861519125425128, 1), (datetime.date(2026, 5, 12), 0.8117012943806187, 3), (datetime.date(2026, 5, 13), 0.7474963984077593, 2), (datetime.date(2026, 5, 14), 0.7980905359846056, 3), (datetime.date(2026, 5, 15), 0.7820250061738308, 1), (datetime.date(2026, 5, 16), 0.637449068368433, 3), (datetime.date(2026, 5, 17), 0.7277177651028889, 2), (datetime.date(2026, 5, 18), 0.7698474390552236, 3), (datetime.date(2026, 5, 19), 0.7790814254018098, 2), (datetime.date(2026, 5, 20), 0.7031881235379123, 1), (datetime.date(2026, 5, 21), 0.7149174785752541, 2), (datetime.date(2026, 5, 22), 0.7076551277059353, 3), (datetime.date(2026, 5, 23), 0.708215681964119, 4), (datetime.date(2026, 5, 24), 0.7702685245464985, 3), (datetime.date(2026, 5, 25), 0.8006390789351988, 3), (datetime.date(2026, 5, 26), 0.801488383399772, 4), (datetime.date(2026, 5, 27), 0.7258315883950449, 3), (datetime.date(2026, 5, 28), 0.7100456378417138, 2), (datetime.date(2026, 5, 29), 0.7190221855657818, 1), (datetime.date(2026, 5, 30), 0.5790792661438733, 1), (datetime.date(2026, 5, 31), 0.6700617419196083, 1))}, 'quality_array': [['-8.721543508153164', '09052026'], ['-8.422188174516307', '10052026'], ['-8.505798499921237', '11052026'], ['-8.258699792999803', '12052026'], ['-8.452437626061792', '13052026'], ['-8.52187281431393', '14052026'], ['-8.51605702184647', '15052026'], ['-8.527623407815106', '16052026'], ['-8.76696511474829', '17052026'], ['-8.494349837979174', '18052026'], ['-8.506493976394486', '19052026'], ['-8.729794590780148', '20052026'], ['-8.533354160170292', '21052026'], ['-9.012114718355267', '22052026'], ['-8.799860441254259', '23052026'], ['-9.009263322060876', '24052026'], ['-8.857971970334587', '25052026'], ['-8.765898845833348', '26052026'], ['-8.983278169246205', '27052026'], ['-9.160987611586831', '28052026'], ['-9.102673343955104', '29052026'], ['-9.07120763149097', '30052026'], ['-9.235887082532788', '31052026']], 'number_of_batch': ((491,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011681143704624064, 'nb_photo': 10215, 'list_port_cont': '31045612,31045649,31045683,31045722,31045762,31045801,31045830,31045851,31046162,31046197,31046396,31046447,31046930,31046968,31047046,31048453,31048479,31048513,31048560,31048588,31048624,31048667,31048697,31048751,31048786,31048821,31048890,31048927,31048972,31048993,31049038,31049584,31049631,31049653,31049706,31049959,31050190,31050268,31050471,31050739,31051060,31051142,31051358,31051886,31051929,31051960,31052009,31052051,31052080,31052132,31052168,31052209,31053206,31053254,31053291,31053329,31053829,31053881,31053907,31054387,31054718,31054749,31054842,31055041,31055187,31055230,31055264,31055536,31055772,31055818,31056152,31056395,31056656,31056895,31056939,31057035,31057315,31057558,31057582,31057901,31058181,31058361,31058869,31059003,31059186,31059246,31059557,31059720,31059756,31059783,31060104,31060317,31060531,31060730,31060936,31061181,31061388,31061435,31061635,31061826,31062330,31062485,31062648,31062679,31062879,31063197,31063390,31063731,31063940,31063981,31064027,31064061,31064548,3106491', 'assoc_port': '31044719:31045612,31044720:31045649,31044721:31045683,31044722:31045722,31044723:31045762,31044724:31045801,31044725:31045851,31044726:31045830,31044727:31046162,31044728:31046197,31044729:31051886,31044730:31051929,31045929:31052009,31045931:31052051,31045932:31051960,31045933:31052080,31045934:31046396,31045935:31052132,31045936:31046447,31045937:31052168,31046288:31052209,31046301:31046930,31046302:31046968,31046303:31047046,31047165:31048453,31047166:31048513,31047167:31048479,31047168:31048560,31047169:31048588,31047170:31048624,31047285:31048667,31047286:31048697,31047287:31048751,31047340:31048786,31047341:31048821,31047343:31048890,31047697:31048927,31047698:31048972,31047699:31048993,31047700:31049038,31049371:31049584,31049372:31049631,31049373:31049653,31049374:31049706,31049424:31049959,31050033:31050190,31050034:31050268,31050377:31050471,31050633:31050739,31050885:31051060,31050886:31051142,31051246:31051358,31052869:31053206,31052870:31053254,31052871:31053291,31052872:31053329,31053556:3105382', 'assoc_mat': '31044719:autre:4230:31045612,31044720:autre:4230:31045649,31044721:autre:4230:31045683,31044722:autre:4230:31045722,31044723:autre:4230:31045762,31044724:autre:4230:31045801,31044725:autre:4230:31045851,31044726:autre:4230:31045830,31044727:autre:4230:31046162,31044728:autre:4230:31046197,31044729:autre:4230:31051886,31044730:autre:4230:31051929,31045929:autre:4230:31052009,31045931:autre:4230:31052051,31045932:autre:4230:31051960,31045933:autre:4230:31052080,31045934:autre:4230:31046396,31045935:autre:4230:31052132,31045936:autre:4230:31046447,31045937:autre:4230:31052168,31046288:autre:4230:31052209,31046301:autre:4230:31046930,31046302:autre:4230:31046968,31046303:autre:4230:31047046,31047165:autre:4230:31048453,31047166:autre:4230:31048513,31047167:autre:4230:31048479,31047168:autre:4230:31048560,31047169:autre:4230:31048588,31047170:autre:4230:31048624,31047285:autre:4230:31048667,31047286:autre:4230:31048697,31047287:autre:4230:31048751,31047340:autre:4230:31048786,31047341:autre:4230:31048821,31047343:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06582599400107365, 'nb_photo': 74500, 'list_port_cont': '31045606,31045650,31045685,31045731,31045760,31045807,31045837,31045856,31046156,31046192,31046408,31046445,31046936,31046974,31047040,31048443,31048485,31048526,31048563,31048599,31048626,31048674,31048710,31048750,31048787,31048818,31048856,31048900,31048930,31048963,31049008,31049044,31049593,31049626,31049670,31049703,31049958,31050206,31050273,31050469,31050742,31051059,31051140,31051355,31051900,31051936,31051967,31052006,31052042,31052088,31052130,31052174,31052208,31053217,31053258,31053298,31053332,31053835,31053875,31053911,31054393,31054716,31054751,31054847,31055033,31055200,31055238,31055281,31055550,31055776,31055813,31056160,31056409,31056662,31056907,31056945,31057032,31057310,31057561,31057595,31057904,31058197,31058369,31058865,31059000,31059180,31059257,31059561,31059712,31059744,31059785,31060107,31060322,31060539,31060737,31060942,31061186,31061397,31061429,31061640,31061834,31062328,31062500,31062655,31062686,31062880,31063195,31063394,31063734,31063941,31063991,31064034,31064068,3106455', 'assoc_port': '31044719:31045606,31044720:31045650,31044721:31045685,31044722:31045731,31044723:31045760,31044724:31045807,31044725:31045856,31044726:31045837,31044727:31046156,31044728:31046192,31044729:31051900,31044730:31051936,31045929:31052006,31045931:31052042,31045932:31051967,31045933:31052088,31045934:31046408,31045935:31052130,31045936:31046445,31045937:31052174,31046288:31052208,31046301:31046936,31046302:31046974,31046303:31047040,31047165:31048443,31047166:31048526,31047167:31048485,31047168:31048563,31047169:31048599,31047170:31048626,31047285:31048674,31047286:31048710,31047287:31048750,31047340:31048787,31047341:31048818,31047342:31048856,31047343:31048900,31047697:31048930,31047698:31048963,31047699:31049008,31047700:31049044,31049371:31049593,31049372:31049626,31049373:31049670,31049374:31049703,31049424:31049958,31050033:31050206,31050034:31050273,31050377:31050469,31050633:31050742,31050885:31051059,31050886:31051140,31051246:31051355,31052869:31053217,31052870:31053258,31052871:31053298,31052872:3105333', 'assoc_mat': '31044719:carton:4230:31045606,31044720:carton:4230:31045650,31044721:carton:4230:31045685,31044722:carton:4230:31045731,31044723:carton:4230:31045760,31044724:carton:4230:31045807,31044725:carton:4230:31045856,31044726:carton:4230:31045837,31044727:carton:4230:31046156,31044728:carton:4230:31046192,31044729:carton:4230:31051900,31044730:carton:4230:31051936,31045929:carton:4230:31052006,31045931:carton:4230:31052042,31045932:carton:4230:31051967,31045933:carton:4230:31052088,31045934:carton:4230:31046408,31045935:carton:4230:31052130,31045936:carton:4230:31046445,31045937:carton:4230:31052174,31046288:carton:4230:31052208,31046301:carton:4230:31046936,31046302:carton:4230:31046974,31046303:carton:4230:31047040,31047165:carton:4230:31048443,31047166:carton:4230:31048526,31047167:carton:4230:31048485,31047168:carton:4230:31048563,31047169:carton:4230:31048599,31047170:carton:4230:31048626,31047285:carton:4230:31048674,31047286:carton:4230:31048710,31047287:carton:4230:31048750,31047340:carton:4230:31048787,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013579021555111235, 'nb_photo': 1306, 'list_port_cont': '31045619,31045645,31045690,31045765,31045798,31045842,31045864,31046149,31046201,31046406,31046444,31046934,31046976,31047042,31048442,31048518,31048548,31048637,31048670,31048712,31048738,31048774,31048810,31048886,31048919,31048957,31049005,31049033,31049582,31049621,31049654,31049695,31049955,31050207,31050277,31050458,31050734,31051065,31051141,31051346,31051901,31051931,31051999,31052047,31052129,31052170,31052212,31053257,31053285,31053324,31053834,31053880,31053913,31054758,31054851,31055034,31055190,31055239,31056151,31056404,31056652,31056937,31057308,31057562,31057590,31057912,31058180,31058357,31058853,31058994,31059182,31059248,31059560,31059704,31059753,31060097,31060321,31060532,31060740,31060929,31061180,31061633,31061833,31062333,31062494,31062650,31062866,31063192,31063736,31063954,31063985,31064024,31064057,31064544,31065036,31065064,31065397,31065434,31065986,31066099,31066610,31066653,31066693,31066731,31067244,31067283,31067535,31067890,31067999,31068076,31068261,31068494,31068657,3106893', 'assoc_port': '31044719:31045619,31044720:31045645,31044721:31045690,31044723:31045765,31044724:31045798,31044725:31045864,31044726:31045842,31044727:31046149,31044728:31046201,31044729:31051901,31044730:31051931,31045929:31051999,31045931:31052047,31045934:31046406,31045935:31052129,31045936:31046444,31045937:31052170,31046288:31052212,31046301:31046934,31046302:31046976,31046303:31047042,31047165:31048442,31047166:31048518,31047168:31048548,31047170:31048637,31047285:31048670,31047286:31048712,31047287:31048738,31047340:31048774,31047341:31048810,31047343:31048886,31047697:31048919,31047698:31048957,31047699:31049005,31047700:31049033,31049371:31049582,31049372:31049621,31049373:31049654,31049374:31049695,31049424:31049955,31050033:31050207,31050034:31050277,31050377:31050458,31050633:31050734,31050885:31051065,31050886:31051141,31051246:31051346,31052870:31053257,31052871:31053285,31052872:31053324,31053556:31053834,31053558:31053913,31053560:31053880,31053988:31055034,31054427:31054758,31054428:31054851,31054988:3105519', 'assoc_mat': '31044719:metal:4230:31045619,31044720:metal:4230:31045645,31044721:metal:4230:31045690,31044723:metal:4230:31045765,31044724:metal:4230:31045798,31044725:metal:4230:31045864,31044726:metal:4230:31045842,31044727:metal:4230:31046149,31044728:metal:4230:31046201,31044729:metal:4230:31051901,31044730:metal:4230:31051931,31045929:metal:4230:31051999,31045931:metal:4230:31052047,31045934:metal:4230:31046406,31045935:metal:4230:31052129,31045936:metal:4230:31046444,31045937:metal:4230:31052170,31046288:metal:4230:31052212,31046301:metal:4230:31046934,31046302:metal:4230:31046976,31046303:metal:4230:31047042,31047165:metal:4230:31048442,31047166:metal:4230:31048518,31047168:metal:4230:31048548,31047170:metal:4230:31048637,31047285:metal:4230:31048670,31047286:metal:4230:31048712,31047287:metal:4230:31048738,31047340:metal:4230:31048774,31047341:metal:4230:31048810,31047343:metal:4230:31048886,31047697:metal:4230:31048919,31047698:metal:4230:31048957,31047699:metal:4230:31049005,31047700:metal:4230:31049033,31049371:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18492700844561905, 'nb_photo': 260555, 'list_port_cont': '31045617,31045660,31045695,31045721,31045757,31045810,31045841,31045861,31046164,31046200,31046413,31046448,31046937,31046971,31047043,31048448,31048489,31048519,31048561,31048596,31048636,31048671,31048707,31048752,31048777,31048826,31048853,31048899,31048935,31048974,31049000,31049039,31049591,31049634,31049664,31049698,31049965,31050197,31050280,31050473,31050729,31051067,31051135,31051352,31051896,31051937,31051966,31052011,31052049,31052090,31052139,31052169,31052210,31053218,31053248,31053299,31053334,31053839,31053877,31053922,31054388,31054712,31054755,31054849,31055037,31055199,31055240,31055276,31055548,31055779,31055823,31056153,31056412,31056657,31056910,31056947,31057023,31057314,31057554,31057586,31057908,31058196,31058371,31058868,31058995,31059181,31059252,31059556,31059717,31059754,31059788,31060102,31060326,31060541,31060745,31060945,31061188,31061391,31061433,31061632,31061830,31062339,31062502,31062657,31062693,31062873,31063188,31063386,31063727,31063953,31063984,31064030,31064069,3106454', 'assoc_port': '31044719:31045617,31044720:31045660,31044721:31045695,31044722:31045721,31044723:31045757,31044724:31045810,31044725:31045861,31044726:31045841,31044727:31046164,31044728:31046200,31044729:31051896,31044730:31051937,31045929:31052011,31045931:31052049,31045932:31051966,31045933:31052090,31045934:31046413,31045935:31052139,31045936:31046448,31045937:31052169,31046288:31052210,31046301:31046937,31046302:31046971,31046303:31047043,31047165:31048448,31047166:31048519,31047167:31048489,31047168:31048561,31047169:31048596,31047170:31048636,31047285:31048671,31047286:31048707,31047287:31048752,31047340:31048777,31047341:31048826,31047342:31048853,31047343:31048899,31047697:31048935,31047698:31048974,31047699:31049000,31047700:31049039,31049371:31049591,31049372:31049634,31049373:31049664,31049374:31049698,31049424:31049965,31050033:31050197,31050034:31050280,31050377:31050473,31050633:31050729,31050885:31051067,31050886:31051135,31051246:31051352,31052869:31053218,31052870:31053248,31052871:31053299,31052872:3105333', 'assoc_mat': '31044719:papier:4230:31045617,31044720:papier:4230:31045660,31044721:papier:4230:31045695,31044722:papier:4230:31045721,31044723:papier:4230:31045757,31044724:papier:4230:31045810,31044725:papier:4230:31045861,31044726:papier:4230:31045841,31044727:papier:4230:31046164,31044728:papier:4230:31046200,31044729:papier:4230:31051896,31044730:papier:4230:31051937,31045929:papier:4230:31052011,31045931:papier:4230:31052049,31045932:papier:4230:31051966,31045933:papier:4230:31052090,31045934:papier:4230:31046413,31045935:papier:4230:31052139,31045936:papier:4230:31046448,31045937:papier:4230:31052169,31046288:papier:4230:31052210,31046301:papier:4230:31046937,31046302:papier:4230:31046971,31046303:papier:4230:31047043,31047165:papier:4230:31048448,31047166:papier:4230:31048519,31047167:papier:4230:31048489,31047168:papier:4230:31048561,31047169:papier:4230:31048596,31047170:papier:4230:31048636,31047285:papier:4230:31048671,31047286:papier:4230:31048707,31047287:papier:4230:31048752,31047340:papier:4230:31048777,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004139796065696791, 'nb_photo': 1381, 'list_port_cont': '31045616,31045655,31045692,31045719,31045759,31045809,31045835,31045860,31046159,31046202,31046412,31046449,31046979,31047050,31048555,31048668,31048704,31048788,31048819,31048970,31050279,31050732,31051138,31051347,31051894,31051934,31052008,31052048,31052136,31052167,31052207,31053209,31053253,31053289,31053335,31053878,31053921,31054708,31054759,31056162,31056908,31056940,31057306,31057592,31057909,31058183,31058363,31058864,31058997,31059183,31059555,31060540,31060744,31060934,31061634,31061825,31062337,31062493,31062654,31062681,31062874,31063198,31063395,31063738,31063955,31063994,31064023,31064064,31065431,31066620,31066695,31066725,31067245,31067276,31067550,31067885,31068002,31068073,31068503,31068926,31070662,31070931,31071057,31071424,31071732,31071767,31072093,31072351,31072553,31072592,31073036,31073076,31073202,31073389,31073581,31073801,31074320,31074354,31074660,31074821,31075093,31075292,31075324,31075755,31075948,31076014,31076408,31076686,31076759,31076973,31077254,31077377,31077719,3107801', 'assoc_port': '31044719:31045616,31044720:31045655,31044721:31045692,31044722:31045719,31044723:31045759,31044724:31045809,31044725:31045860,31044726:31045835,31044727:31046159,31044728:31046202,31044729:31051894,31044730:31051934,31045929:31052008,31045931:31052048,31045934:31046412,31045935:31052136,31045936:31046449,31045937:31052167,31046288:31052207,31046302:31046979,31046303:31047050,31047168:31048555,31047285:31048668,31047286:31048704,31047340:31048788,31047341:31048819,31047698:31048970,31050034:31050279,31050633:31050732,31050886:31051138,31051246:31051347,31052869:31053209,31052870:31053253,31052871:31053289,31052872:31053335,31053558:31053921,31053560:31053878,31054425:31054708,31054427:31054759,31056024:31056162,31056725:31056908,31056726:31056940,31057174:31057306,31057405:31057592,31057739:31057909,31058085:31058183,31058223:31058363,31058403:31058997,31058626:31058864,31058969:31059183,31059280:31059555,31060437:31060540,31060644:31060744,31060807:31060934,31061536:31061634,31061733:31061825,31061982:3106249', 'assoc_mat': '31044719:pehd:4230:31045616,31044720:pehd:4230:31045655,31044721:pehd:4230:31045692,31044722:pehd:4230:31045719,31044723:pehd:4230:31045759,31044724:pehd:4230:31045809,31044725:pehd:4230:31045860,31044726:pehd:4230:31045835,31044727:pehd:4230:31046159,31044728:pehd:4230:31046202,31044729:pehd:4230:31051894,31044730:pehd:4230:31051934,31045929:pehd:4230:31052008,31045931:pehd:4230:31052048,31045934:pehd:4230:31046412,31045935:pehd:4230:31052136,31045936:pehd:4230:31046449,31045937:pehd:4230:31052167,31046288:pehd:4230:31052207,31046302:pehd:4230:31046979,31046303:pehd:4230:31047050,31047168:pehd:4230:31048555,31047285:pehd:4230:31048668,31047286:pehd:4230:31048704,31047340:pehd:4230:31048788,31047341:pehd:4230:31048819,31047698:pehd:4230:31048970,31050034:pehd:4230:31050279,31050633:pehd:4230:31050732,31050886:pehd:4230:31051138,31051246:pehd:4230:31051347,31052869:pehd:4230:31053209,31052870:pehd:4230:31053253,31052871:pehd:4230:31053289,31052872:pehd:4230:31053335,31053558:pehd:4230:31053921,31053560:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013466177482616495, 'nb_photo': 11078, 'list_port_cont': '31045613,31045654,31045689,31045732,31045761,31045800,31045846,31045849,31046161,31046198,31046405,31046452,31046939,31046978,31047045,31048449,31048484,31048527,31048558,31048597,31048633,31048659,31048709,31048743,31048790,31048824,31048861,31048894,31048934,31048973,31048997,31049036,31049585,31049619,31049666,31049692,31049967,31050202,31050272,31050475,31050745,31051066,31051130,31051356,31051898,31051930,31051975,31052013,31052043,31052085,31052140,31052176,31052216,31053207,31053256,31053295,31053336,31053838,31053885,31053923,31054397,31054709,31054753,31054846,31055039,31055197,31055236,31055278,31055546,31055786,31055822,31056161,31056400,31056663,31056899,31056949,31057025,31057316,31057549,31057598,31057913,31058191,31058368,31058855,31059001,31059175,31059258,31059562,31059719,31059757,31059787,31060110,31060325,31060529,31060743,31060943,31061187,31061386,31061431,31061628,31061836,31062336,31062501,31062653,31062691,31062869,31063201,31063400,31063737,31063948,31063993,31064029,31064070,3106454', 'assoc_port': '31044719:31045613,31044720:31045654,31044721:31045689,31044722:31045732,31044723:31045761,31044724:31045800,31044725:31045849,31044726:31045846,31044727:31046161,31044728:31046198,31044729:31051898,31044730:31051930,31045929:31052013,31045931:31052043,31045932:31051975,31045933:31052085,31045934:31046405,31045935:31052140,31045936:31046452,31045937:31052176,31046288:31052216,31046301:31046939,31046302:31046978,31046303:31047045,31047165:31048449,31047166:31048527,31047167:31048484,31047168:31048558,31047169:31048597,31047170:31048633,31047285:31048659,31047286:31048709,31047287:31048743,31047340:31048790,31047341:31048824,31047342:31048861,31047343:31048894,31047697:31048934,31047698:31048973,31047699:31048997,31047700:31049036,31049371:31049585,31049372:31049619,31049373:31049666,31049374:31049692,31049424:31049967,31050033:31050202,31050034:31050272,31050377:31050475,31050633:31050745,31050885:31051066,31050886:31051130,31051246:31051356,31052869:31053207,31052870:31053256,31052871:31053295,31052872:3105333', 'assoc_mat': '31044719:pet_clair:4230:31045613,31044720:pet_clair:4230:31045654,31044721:pet_clair:4230:31045689,31044722:pet_clair:4230:31045732,31044723:pet_clair:4230:31045761,31044724:pet_clair:4230:31045800,31044725:pet_clair:4230:31045849,31044726:pet_clair:4230:31045846,31044727:pet_clair:4230:31046161,31044728:pet_clair:4230:31046198,31044729:pet_clair:4230:31051898,31044730:pet_clair:4230:31051930,31045929:pet_clair:4230:31052013,31045931:pet_clair:4230:31052043,31045932:pet_clair:4230:31051975,31045933:pet_clair:4230:31052085,31045934:pet_clair:4230:31046405,31045935:pet_clair:4230:31052140,31045936:pet_clair:4230:31046452,31045937:pet_clair:4230:31052176,31046288:pet_clair:4230:31052216,31046301:pet_clair:4230:31046939,31046302:pet_clair:4230:31046978,31046303:pet_clair:4230:31047045,31047165:pet_clair:4230:31048449,31047166:pet_clair:4230:31048527,31047167:pet_clair:4230:31048484,31047168:pet_clair:4230:31048558,31047169:pet_clair:4230:31048597,31047170:pet_clair:4230:31048633,31047285:pet_clair:4230:31048659,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0025192353321460727, 'nb_photo': 395, 'list_port_cont': '31045608,31045697,31045806,31045859,31046155,31046404,31046450,31047053,31048517,31048673,31048713,31048964,31049968,31050199,31050736,31051139,31051348,31051899,31051926,31051974,31052010,31052137,31053259,31053840,31053883,31053919,31054757,31055547,31056906,31056942,31057034,31057302,31057594,31058195,31058862,31058996,31059750,31061828,31062327,31062499,31062652,31062690,31062878,31063739,31063944,31064067,31065998,31066029,31066114,31067246,31067882,31068665,31068966,31069461,31070667,31070936,31071052,31071423,31071733,31071766,31072096,31072350,31073189,31073589,31074656,31074814,31075097,31075294,31075332,31075745,31075944,31076024,31076683,31076762,31076960,31077253,31077384,31077721,31078028,31078067,31078451,31078714,31078906,31078946,31079338,31079811,31079968,31080212,31080464,31080532,31080810,31081223,31081708,31082413,31082654,31082877,31083103,31083182,31083650,31085887,31086071,31086846,31087413,31087794,31088214,31089479,31090405,31090737,31091477,31091516,31091557,31091632,31091677,3109172', 'assoc_port': '31044719:31045608,31044721:31045697,31044724:31045806,31044725:31045859,31044727:31046155,31044729:31051899,31044730:31051926,31045929:31052010,31045932:31051974,31045934:31046404,31045935:31052137,31045936:31046450,31046303:31047053,31047166:31048517,31047285:31048673,31047286:31048713,31047698:31048964,31049424:31049968,31050033:31050199,31050633:31050736,31050886:31051139,31051246:31051348,31052870:31053259,31053556:31053840,31053558:31053919,31053560:31053883,31054427:31054757,31055396:31055547,31056477:31057034,31056725:31056906,31056726:31056942,31057174:31057302,31057405:31057594,31058085:31058195,31058403:31058996,31058626:31058862,31059582:31059750,31061733:31061828,31061982:31062499,31062182:31062327,31062448:31062652,31062449:31062690,31062799:31062878,31063557:31063739,31063801:31063944,31063804:31064067,31065712:31065998,31065777:31066114,31065778:31066029,31066969:31067246,31067613:31067882,31068571:31068665,31068799:31068966,31069363:31069461,31070243:31071052,31070564:31070667,31070795:3107093', 'assoc_mat': '31044719:pet_fonce:4230:31045608,31044721:pet_fonce:4230:31045697,31044724:pet_fonce:4230:31045806,31044725:pet_fonce:4230:31045859,31044727:pet_fonce:4230:31046155,31044729:pet_fonce:4230:31051899,31044730:pet_fonce:4230:31051926,31045929:pet_fonce:4230:31052010,31045932:pet_fonce:4230:31051974,31045934:pet_fonce:4230:31046404,31045935:pet_fonce:4230:31052137,31045936:pet_fonce:4230:31046450,31046303:pet_fonce:4230:31047053,31047166:pet_fonce:4230:31048517,31047285:pet_fonce:4230:31048673,31047286:pet_fonce:4230:31048713,31047698:pet_fonce:4230:31048964,31049424:pet_fonce:4230:31049968,31050033:pet_fonce:4230:31050199,31050633:pet_fonce:4230:31050736,31050886:pet_fonce:4230:31051139,31051246:pet_fonce:4230:31051348,31052870:pet_fonce:4230:31053259,31053556:pet_fonce:4230:31053840,31053558:pet_fonce:4230:31053919,31053560:pet_fonce:4230:31053883,31054427:pet_fonce:4230:31054757,31055396:pet_fonce:4230:31055547,31056477:pet_fonce:4230:31057034,31056725:pet_fonce:4230:31056906,31056726:pet_fonce:4230:31056942,3'}), 'main_stat': {'nb_photos': 1175}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31081562,31081563,31081564,31081565,31081566,31081567,31081568?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-05', 0.7439077625039429),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1175,),), 'unwanted_material_monthly_percentage': ((0.7439077625039429,),), 'material_repartition': (('incineration', 1175),), 'material_dict': {'incineration': 1175}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 5, 9), 0.6740148956740266, 2), (datetime.date(2026, 5, 10), 0.783726236639823, 3), (datetime.date(2026, 5, 11), 0.7861519125425128, 1), (datetime.date(2026, 5, 12), 0.8117012943806187, 3), (datetime.date(2026, 5, 13), 0.7474963984077593, 2), (datetime.date(2026, 5, 14), 0.7980905359846056, 3), (datetime.date(2026, 5, 15), 0.7820250061738308, 1), (datetime.date(2026, 5, 16), 0.637449068368433, 3), (datetime.date(2026, 5, 17), 0.7277177651028889, 2), (datetime.date(2026, 5, 18), 0.7698474390552236, 3), (datetime.date(2026, 5, 19), 0.7790814254018098, 2), (datetime.date(2026, 5, 20), 0.7031881235379123, 1), (datetime.date(2026, 5, 21), 0.7149174785752541, 2), (datetime.date(2026, 5, 22), 0.7076551277059353, 3), (datetime.date(2026, 5, 23), 0.708215681964119, 4), (datetime.date(2026, 5, 24), 0.7702685245464985, 3), (datetime.date(2026, 5, 25), 0.8006390789351988, 3), (datetime.date(2026, 5, 26), 0.801488383399772, 4), (datetime.date(2026, 5, 27), 0.7258315883950449, 3), (datetime.date(2026, 5, 28), 0.7100456378417138, 2), (datetime.date(2026, 5, 29), 0.7190221855657818, 1), (datetime.date(2026, 5, 30), 0.5790792661438733, 1), (datetime.date(2026, 5, 31), 0.6700617419196083, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 5, 9), 0.6740148956740266, 2), (datetime.date(2026, 5, 10), 0.783726236639823, 3), (datetime.date(2026, 5, 11), 0.7861519125425128, 1), (datetime.date(2026, 5, 12), 0.8117012943806187, 3), (datetime.date(2026, 5, 13), 0.7474963984077593, 2), (datetime.date(2026, 5, 14), 0.7980905359846056, 3), (datetime.date(2026, 5, 15), 0.7820250061738308, 1), (datetime.date(2026, 5, 16), 0.637449068368433, 3), (datetime.date(2026, 5, 17), 0.7277177651028889, 2), (datetime.date(2026, 5, 18), 0.7698474390552236, 3), (datetime.date(2026, 5, 19), 0.7790814254018098, 2), (datetime.date(2026, 5, 20), 0.7031881235379123, 1), (datetime.date(2026, 5, 21), 0.7149174785752541, 2), (datetime.date(2026, 5, 22), 0.7076551277059353, 3), (datetime.date(2026, 5, 23), 0.708215681964119, 4), (datetime.date(2026, 5, 24), 0.7702685245464985, 3), (datetime.date(2026, 5, 25), 0.8006390789351988, 3), (datetime.date(2026, 5, 26), 0.801488383399772, 4), (datetime.date(2026, 5, 27), 0.7258315883950449, 3), (datetime.date(2026, 5, 28), 0.7100456378417138, 2), (datetime.date(2026, 5, 29), 0.7190221855657818, 1), (datetime.date(2026, 5, 30), 0.5790792661438733, 1), (datetime.date(2026, 5, 31), 0.6700617419196083, 1))}, 'quality_array': [['-8.721543508153164', '09052026'], ['-8.422188174516307', '10052026'], ['-8.505798499921237', '11052026'], ['-8.258699792999803', '12052026'], ['-8.452437626061792', '13052026'], ['-8.52187281431393', '14052026'], ['-8.51605702184647', '15052026'], ['-8.527623407815106', '16052026'], ['-8.76696511474829', '17052026'], ['-8.494349837979174', '18052026'], ['-8.506493976394486', '19052026'], ['-8.729794590780148', '20052026'], ['-8.533354160170292', '21052026'], ['-9.012114718355267', '22052026'], ['-8.799860441254259', '23052026'], ['-9.009263322060876', '24052026'], ['-8.857971970334587', '25052026'], ['-8.765898845833348', '26052026'], ['-8.983278169246205', '27052026'], ['-9.160987611586831', '28052026'], ['-9.102673343955104', '29052026'], ['-9.07120763149097', '30052026'], ['-9.235887082532788', '31052026']], 'number_of_batch': ((491,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011681143704624064, 'nb_photo': 10215, 'list_port_cont': '31045612,31045649,31045683,31045722,31045762,31045801,31045830,31045851,31046162,31046197,31046396,31046447,31046930,31046968,31047046,31048453,31048479,31048513,31048560,31048588,31048624,31048667,31048697,31048751,31048786,31048821,31048890,31048927,31048972,31048993,31049038,31049584,31049631,31049653,31049706,31049959,31050190,31050268,31050471,31050739,31051060,31051142,31051358,31051886,31051929,31051960,31052009,31052051,31052080,31052132,31052168,31052209,31053206,31053254,31053291,31053329,31053829,31053881,31053907,31054387,31054718,31054749,31054842,31055041,31055187,31055230,31055264,31055536,31055772,31055818,31056152,31056395,31056656,31056895,31056939,31057035,31057315,31057558,31057582,31057901,31058181,31058361,31058869,31059003,31059186,31059246,31059557,31059720,31059756,31059783,31060104,31060317,31060531,31060730,31060936,31061181,31061388,31061435,31061635,31061826,31062330,31062485,31062648,31062679,31062879,31063197,31063390,31063731,31063940,31063981,31064027,31064061,31064548,3106491', 'assoc_port': '31044719:31045612,31044720:31045649,31044721:31045683,31044722:31045722,31044723:31045762,31044724:31045801,31044725:31045851,31044726:31045830,31044727:31046162,31044728:31046197,31044729:31051886,31044730:31051929,31045929:31052009,31045931:31052051,31045932:31051960,31045933:31052080,31045934:31046396,31045935:31052132,31045936:31046447,31045937:31052168,31046288:31052209,31046301:31046930,31046302:31046968,31046303:31047046,31047165:31048453,31047166:31048513,31047167:31048479,31047168:31048560,31047169:31048588,31047170:31048624,31047285:31048667,31047286:31048697,31047287:31048751,31047340:31048786,31047341:31048821,31047343:31048890,31047697:31048927,31047698:31048972,31047699:31048993,31047700:31049038,31049371:31049584,31049372:31049631,31049373:31049653,31049374:31049706,31049424:31049959,31050033:31050190,31050034:31050268,31050377:31050471,31050633:31050739,31050885:31051060,31050886:31051142,31051246:31051358,31052869:31053206,31052870:31053254,31052871:31053291,31052872:31053329,31053556:3105382', 'assoc_mat': '31044719:autre:4230:31045612,31044720:autre:4230:31045649,31044721:autre:4230:31045683,31044722:autre:4230:31045722,31044723:autre:4230:31045762,31044724:autre:4230:31045801,31044725:autre:4230:31045851,31044726:autre:4230:31045830,31044727:autre:4230:31046162,31044728:autre:4230:31046197,31044729:autre:4230:31051886,31044730:autre:4230:31051929,31045929:autre:4230:31052009,31045931:autre:4230:31052051,31045932:autre:4230:31051960,31045933:autre:4230:31052080,31045934:autre:4230:31046396,31045935:autre:4230:31052132,31045936:autre:4230:31046447,31045937:autre:4230:31052168,31046288:autre:4230:31052209,31046301:autre:4230:31046930,31046302:autre:4230:31046968,31046303:autre:4230:31047046,31047165:autre:4230:31048453,31047166:autre:4230:31048513,31047167:autre:4230:31048479,31047168:autre:4230:31048560,31047169:autre:4230:31048588,31047170:autre:4230:31048624,31047285:autre:4230:31048667,31047286:autre:4230:31048697,31047287:autre:4230:31048751,31047340:autre:4230:31048786,31047341:autre:4230:31048821,31047343:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.06582599400107365, 'nb_photo': 74500, 'list_port_cont': '31045606,31045650,31045685,31045731,31045760,31045807,31045837,31045856,31046156,31046192,31046408,31046445,31046936,31046974,31047040,31048443,31048485,31048526,31048563,31048599,31048626,31048674,31048710,31048750,31048787,31048818,31048856,31048900,31048930,31048963,31049008,31049044,31049593,31049626,31049670,31049703,31049958,31050206,31050273,31050469,31050742,31051059,31051140,31051355,31051900,31051936,31051967,31052006,31052042,31052088,31052130,31052174,31052208,31053217,31053258,31053298,31053332,31053835,31053875,31053911,31054393,31054716,31054751,31054847,31055033,31055200,31055238,31055281,31055550,31055776,31055813,31056160,31056409,31056662,31056907,31056945,31057032,31057310,31057561,31057595,31057904,31058197,31058369,31058865,31059000,31059180,31059257,31059561,31059712,31059744,31059785,31060107,31060322,31060539,31060737,31060942,31061186,31061397,31061429,31061640,31061834,31062328,31062500,31062655,31062686,31062880,31063195,31063394,31063734,31063941,31063991,31064034,31064068,3106455', 'assoc_port': '31044719:31045606,31044720:31045650,31044721:31045685,31044722:31045731,31044723:31045760,31044724:31045807,31044725:31045856,31044726:31045837,31044727:31046156,31044728:31046192,31044729:31051900,31044730:31051936,31045929:31052006,31045931:31052042,31045932:31051967,31045933:31052088,31045934:31046408,31045935:31052130,31045936:31046445,31045937:31052174,31046288:31052208,31046301:31046936,31046302:31046974,31046303:31047040,31047165:31048443,31047166:31048526,31047167:31048485,31047168:31048563,31047169:31048599,31047170:31048626,31047285:31048674,31047286:31048710,31047287:31048750,31047340:31048787,31047341:31048818,31047342:31048856,31047343:31048900,31047697:31048930,31047698:31048963,31047699:31049008,31047700:31049044,31049371:31049593,31049372:31049626,31049373:31049670,31049374:31049703,31049424:31049958,31050033:31050206,31050034:31050273,31050377:31050469,31050633:31050742,31050885:31051059,31050886:31051140,31051246:31051355,31052869:31053217,31052870:31053258,31052871:31053298,31052872:3105333', 'assoc_mat': '31044719:carton:4230:31045606,31044720:carton:4230:31045650,31044721:carton:4230:31045685,31044722:carton:4230:31045731,31044723:carton:4230:31045760,31044724:carton:4230:31045807,31044725:carton:4230:31045856,31044726:carton:4230:31045837,31044727:carton:4230:31046156,31044728:carton:4230:31046192,31044729:carton:4230:31051900,31044730:carton:4230:31051936,31045929:carton:4230:31052006,31045931:carton:4230:31052042,31045932:carton:4230:31051967,31045933:carton:4230:31052088,31045934:carton:4230:31046408,31045935:carton:4230:31052130,31045936:carton:4230:31046445,31045937:carton:4230:31052174,31046288:carton:4230:31052208,31046301:carton:4230:31046936,31046302:carton:4230:31046974,31046303:carton:4230:31047040,31047165:carton:4230:31048443,31047166:carton:4230:31048526,31047167:carton:4230:31048485,31047168:carton:4230:31048563,31047169:carton:4230:31048599,31047170:carton:4230:31048626,31047285:carton:4230:31048674,31047286:carton:4230:31048710,31047287:carton:4230:31048750,31047340:carton:4230:31048787,3104'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013579021555111235, 'nb_photo': 1306, 'list_port_cont': '31045619,31045645,31045690,31045765,31045798,31045842,31045864,31046149,31046201,31046406,31046444,31046934,31046976,31047042,31048442,31048518,31048548,31048637,31048670,31048712,31048738,31048774,31048810,31048886,31048919,31048957,31049005,31049033,31049582,31049621,31049654,31049695,31049955,31050207,31050277,31050458,31050734,31051065,31051141,31051346,31051901,31051931,31051999,31052047,31052129,31052170,31052212,31053257,31053285,31053324,31053834,31053880,31053913,31054758,31054851,31055034,31055190,31055239,31056151,31056404,31056652,31056937,31057308,31057562,31057590,31057912,31058180,31058357,31058853,31058994,31059182,31059248,31059560,31059704,31059753,31060097,31060321,31060532,31060740,31060929,31061180,31061633,31061833,31062333,31062494,31062650,31062866,31063192,31063736,31063954,31063985,31064024,31064057,31064544,31065036,31065064,31065397,31065434,31065986,31066099,31066610,31066653,31066693,31066731,31067244,31067283,31067535,31067890,31067999,31068076,31068261,31068494,31068657,3106893', 'assoc_port': '31044719:31045619,31044720:31045645,31044721:31045690,31044723:31045765,31044724:31045798,31044725:31045864,31044726:31045842,31044727:31046149,31044728:31046201,31044729:31051901,31044730:31051931,31045929:31051999,31045931:31052047,31045934:31046406,31045935:31052129,31045936:31046444,31045937:31052170,31046288:31052212,31046301:31046934,31046302:31046976,31046303:31047042,31047165:31048442,31047166:31048518,31047168:31048548,31047170:31048637,31047285:31048670,31047286:31048712,31047287:31048738,31047340:31048774,31047341:31048810,31047343:31048886,31047697:31048919,31047698:31048957,31047699:31049005,31047700:31049033,31049371:31049582,31049372:31049621,31049373:31049654,31049374:31049695,31049424:31049955,31050033:31050207,31050034:31050277,31050377:31050458,31050633:31050734,31050885:31051065,31050886:31051141,31051246:31051346,31052870:31053257,31052871:31053285,31052872:31053324,31053556:31053834,31053558:31053913,31053560:31053880,31053988:31055034,31054427:31054758,31054428:31054851,31054988:3105519', 'assoc_mat': '31044719:metal:4230:31045619,31044720:metal:4230:31045645,31044721:metal:4230:31045690,31044723:metal:4230:31045765,31044724:metal:4230:31045798,31044725:metal:4230:31045864,31044726:metal:4230:31045842,31044727:metal:4230:31046149,31044728:metal:4230:31046201,31044729:metal:4230:31051901,31044730:metal:4230:31051931,31045929:metal:4230:31051999,31045931:metal:4230:31052047,31045934:metal:4230:31046406,31045935:metal:4230:31052129,31045936:metal:4230:31046444,31045937:metal:4230:31052170,31046288:metal:4230:31052212,31046301:metal:4230:31046934,31046302:metal:4230:31046976,31046303:metal:4230:31047042,31047165:metal:4230:31048442,31047166:metal:4230:31048518,31047168:metal:4230:31048548,31047170:metal:4230:31048637,31047285:metal:4230:31048670,31047286:metal:4230:31048712,31047287:metal:4230:31048738,31047340:metal:4230:31048774,31047341:metal:4230:31048810,31047343:metal:4230:31048886,31047697:metal:4230:31048919,31047698:metal:4230:31048957,31047699:metal:4230:31049005,31047700:metal:4230:31049033,31049371:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18492700844561905, 'nb_photo': 260555, 'list_port_cont': '31045617,31045660,31045695,31045721,31045757,31045810,31045841,31045861,31046164,31046200,31046413,31046448,31046937,31046971,31047043,31048448,31048489,31048519,31048561,31048596,31048636,31048671,31048707,31048752,31048777,31048826,31048853,31048899,31048935,31048974,31049000,31049039,31049591,31049634,31049664,31049698,31049965,31050197,31050280,31050473,31050729,31051067,31051135,31051352,31051896,31051937,31051966,31052011,31052049,31052090,31052139,31052169,31052210,31053218,31053248,31053299,31053334,31053839,31053877,31053922,31054388,31054712,31054755,31054849,31055037,31055199,31055240,31055276,31055548,31055779,31055823,31056153,31056412,31056657,31056910,31056947,31057023,31057314,31057554,31057586,31057908,31058196,31058371,31058868,31058995,31059181,31059252,31059556,31059717,31059754,31059788,31060102,31060326,31060541,31060745,31060945,31061188,31061391,31061433,31061632,31061830,31062339,31062502,31062657,31062693,31062873,31063188,31063386,31063727,31063953,31063984,31064030,31064069,3106454', 'assoc_port': '31044719:31045617,31044720:31045660,31044721:31045695,31044722:31045721,31044723:31045757,31044724:31045810,31044725:31045861,31044726:31045841,31044727:31046164,31044728:31046200,31044729:31051896,31044730:31051937,31045929:31052011,31045931:31052049,31045932:31051966,31045933:31052090,31045934:31046413,31045935:31052139,31045936:31046448,31045937:31052169,31046288:31052210,31046301:31046937,31046302:31046971,31046303:31047043,31047165:31048448,31047166:31048519,31047167:31048489,31047168:31048561,31047169:31048596,31047170:31048636,31047285:31048671,31047286:31048707,31047287:31048752,31047340:31048777,31047341:31048826,31047342:31048853,31047343:31048899,31047697:31048935,31047698:31048974,31047699:31049000,31047700:31049039,31049371:31049591,31049372:31049634,31049373:31049664,31049374:31049698,31049424:31049965,31050033:31050197,31050034:31050280,31050377:31050473,31050633:31050729,31050885:31051067,31050886:31051135,31051246:31051352,31052869:31053218,31052870:31053248,31052871:31053299,31052872:3105333', 'assoc_mat': '31044719:papier:4230:31045617,31044720:papier:4230:31045660,31044721:papier:4230:31045695,31044722:papier:4230:31045721,31044723:papier:4230:31045757,31044724:papier:4230:31045810,31044725:papier:4230:31045861,31044726:papier:4230:31045841,31044727:papier:4230:31046164,31044728:papier:4230:31046200,31044729:papier:4230:31051896,31044730:papier:4230:31051937,31045929:papier:4230:31052011,31045931:papier:4230:31052049,31045932:papier:4230:31051966,31045933:papier:4230:31052090,31045934:papier:4230:31046413,31045935:papier:4230:31052139,31045936:papier:4230:31046448,31045937:papier:4230:31052169,31046288:papier:4230:31052210,31046301:papier:4230:31046937,31046302:papier:4230:31046971,31046303:papier:4230:31047043,31047165:papier:4230:31048448,31047166:papier:4230:31048519,31047167:papier:4230:31048489,31047168:papier:4230:31048561,31047169:papier:4230:31048596,31047170:papier:4230:31048636,31047285:papier:4230:31048671,31047286:papier:4230:31048707,31047287:papier:4230:31048752,31047340:papier:4230:31048777,3104'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004139796065696791, 'nb_photo': 1381, 'list_port_cont': '31045616,31045655,31045692,31045719,31045759,31045809,31045835,31045860,31046159,31046202,31046412,31046449,31046979,31047050,31048555,31048668,31048704,31048788,31048819,31048970,31050279,31050732,31051138,31051347,31051894,31051934,31052008,31052048,31052136,31052167,31052207,31053209,31053253,31053289,31053335,31053878,31053921,31054708,31054759,31056162,31056908,31056940,31057306,31057592,31057909,31058183,31058363,31058864,31058997,31059183,31059555,31060540,31060744,31060934,31061634,31061825,31062337,31062493,31062654,31062681,31062874,31063198,31063395,31063738,31063955,31063994,31064023,31064064,31065431,31066620,31066695,31066725,31067245,31067276,31067550,31067885,31068002,31068073,31068503,31068926,31070662,31070931,31071057,31071424,31071732,31071767,31072093,31072351,31072553,31072592,31073036,31073076,31073202,31073389,31073581,31073801,31074320,31074354,31074660,31074821,31075093,31075292,31075324,31075755,31075948,31076014,31076408,31076686,31076759,31076973,31077254,31077377,31077719,3107801', 'assoc_port': '31044719:31045616,31044720:31045655,31044721:31045692,31044722:31045719,31044723:31045759,31044724:31045809,31044725:31045860,31044726:31045835,31044727:31046159,31044728:31046202,31044729:31051894,31044730:31051934,31045929:31052008,31045931:31052048,31045934:31046412,31045935:31052136,31045936:31046449,31045937:31052167,31046288:31052207,31046302:31046979,31046303:31047050,31047168:31048555,31047285:31048668,31047286:31048704,31047340:31048788,31047341:31048819,31047698:31048970,31050034:31050279,31050633:31050732,31050886:31051138,31051246:31051347,31052869:31053209,31052870:31053253,31052871:31053289,31052872:31053335,31053558:31053921,31053560:31053878,31054425:31054708,31054427:31054759,31056024:31056162,31056725:31056908,31056726:31056940,31057174:31057306,31057405:31057592,31057739:31057909,31058085:31058183,31058223:31058363,31058403:31058997,31058626:31058864,31058969:31059183,31059280:31059555,31060437:31060540,31060644:31060744,31060807:31060934,31061536:31061634,31061733:31061825,31061982:3106249', 'assoc_mat': '31044719:pehd:4230:31045616,31044720:pehd:4230:31045655,31044721:pehd:4230:31045692,31044722:pehd:4230:31045719,31044723:pehd:4230:31045759,31044724:pehd:4230:31045809,31044725:pehd:4230:31045860,31044726:pehd:4230:31045835,31044727:pehd:4230:31046159,31044728:pehd:4230:31046202,31044729:pehd:4230:31051894,31044730:pehd:4230:31051934,31045929:pehd:4230:31052008,31045931:pehd:4230:31052048,31045934:pehd:4230:31046412,31045935:pehd:4230:31052136,31045936:pehd:4230:31046449,31045937:pehd:4230:31052167,31046288:pehd:4230:31052207,31046302:pehd:4230:31046979,31046303:pehd:4230:31047050,31047168:pehd:4230:31048555,31047285:pehd:4230:31048668,31047286:pehd:4230:31048704,31047340:pehd:4230:31048788,31047341:pehd:4230:31048819,31047698:pehd:4230:31048970,31050034:pehd:4230:31050279,31050633:pehd:4230:31050732,31050886:pehd:4230:31051138,31051246:pehd:4230:31051347,31052869:pehd:4230:31053209,31052870:pehd:4230:31053253,31052871:pehd:4230:31053289,31052872:pehd:4230:31053335,31053558:pehd:4230:31053921,31053560:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013466177482616495, 'nb_photo': 11078, 'list_port_cont': '31045613,31045654,31045689,31045732,31045761,31045800,31045846,31045849,31046161,31046198,31046405,31046452,31046939,31046978,31047045,31048449,31048484,31048527,31048558,31048597,31048633,31048659,31048709,31048743,31048790,31048824,31048861,31048894,31048934,31048973,31048997,31049036,31049585,31049619,31049666,31049692,31049967,31050202,31050272,31050475,31050745,31051066,31051130,31051356,31051898,31051930,31051975,31052013,31052043,31052085,31052140,31052176,31052216,31053207,31053256,31053295,31053336,31053838,31053885,31053923,31054397,31054709,31054753,31054846,31055039,31055197,31055236,31055278,31055546,31055786,31055822,31056161,31056400,31056663,31056899,31056949,31057025,31057316,31057549,31057598,31057913,31058191,31058368,31058855,31059001,31059175,31059258,31059562,31059719,31059757,31059787,31060110,31060325,31060529,31060743,31060943,31061187,31061386,31061431,31061628,31061836,31062336,31062501,31062653,31062691,31062869,31063201,31063400,31063737,31063948,31063993,31064029,31064070,3106454', 'assoc_port': '31044719:31045613,31044720:31045654,31044721:31045689,31044722:31045732,31044723:31045761,31044724:31045800,31044725:31045849,31044726:31045846,31044727:31046161,31044728:31046198,31044729:31051898,31044730:31051930,31045929:31052013,31045931:31052043,31045932:31051975,31045933:31052085,31045934:31046405,31045935:31052140,31045936:31046452,31045937:31052176,31046288:31052216,31046301:31046939,31046302:31046978,31046303:31047045,31047165:31048449,31047166:31048527,31047167:31048484,31047168:31048558,31047169:31048597,31047170:31048633,31047285:31048659,31047286:31048709,31047287:31048743,31047340:31048790,31047341:31048824,31047342:31048861,31047343:31048894,31047697:31048934,31047698:31048973,31047699:31048997,31047700:31049036,31049371:31049585,31049372:31049619,31049373:31049666,31049374:31049692,31049424:31049967,31050033:31050202,31050034:31050272,31050377:31050475,31050633:31050745,31050885:31051066,31050886:31051130,31051246:31051356,31052869:31053207,31052870:31053256,31052871:31053295,31052872:3105333', 'assoc_mat': '31044719:pet_clair:4230:31045613,31044720:pet_clair:4230:31045654,31044721:pet_clair:4230:31045689,31044722:pet_clair:4230:31045732,31044723:pet_clair:4230:31045761,31044724:pet_clair:4230:31045800,31044725:pet_clair:4230:31045849,31044726:pet_clair:4230:31045846,31044727:pet_clair:4230:31046161,31044728:pet_clair:4230:31046198,31044729:pet_clair:4230:31051898,31044730:pet_clair:4230:31051930,31045929:pet_clair:4230:31052013,31045931:pet_clair:4230:31052043,31045932:pet_clair:4230:31051975,31045933:pet_clair:4230:31052085,31045934:pet_clair:4230:31046405,31045935:pet_clair:4230:31052140,31045936:pet_clair:4230:31046452,31045937:pet_clair:4230:31052176,31046288:pet_clair:4230:31052216,31046301:pet_clair:4230:31046939,31046302:pet_clair:4230:31046978,31046303:pet_clair:4230:31047045,31047165:pet_clair:4230:31048449,31047166:pet_clair:4230:31048527,31047167:pet_clair:4230:31048484,31047168:pet_clair:4230:31048558,31047169:pet_clair:4230:31048597,31047170:pet_clair:4230:31048633,31047285:pet_clair:4230:31048659,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0025192353321460727, 'nb_photo': 395, 'list_port_cont': '31045608,31045697,31045806,31045859,31046155,31046404,31046450,31047053,31048517,31048673,31048713,31048964,31049968,31050199,31050736,31051139,31051348,31051899,31051926,31051974,31052010,31052137,31053259,31053840,31053883,31053919,31054757,31055547,31056906,31056942,31057034,31057302,31057594,31058195,31058862,31058996,31059750,31061828,31062327,31062499,31062652,31062690,31062878,31063739,31063944,31064067,31065998,31066029,31066114,31067246,31067882,31068665,31068966,31069461,31070667,31070936,31071052,31071423,31071733,31071766,31072096,31072350,31073189,31073589,31074656,31074814,31075097,31075294,31075332,31075745,31075944,31076024,31076683,31076762,31076960,31077253,31077384,31077721,31078028,31078067,31078451,31078714,31078906,31078946,31079338,31079811,31079968,31080212,31080464,31080532,31080810,31081223,31081708,31082413,31082654,31082877,31083103,31083182,31083650,31085887,31086071,31086846,31087413,31087794,31088214,31089479,31090405,31090737,31091477,31091516,31091557,31091632,31091677,3109172', 'assoc_port': '31044719:31045608,31044721:31045697,31044724:31045806,31044725:31045859,31044727:31046155,31044729:31051899,31044730:31051926,31045929:31052010,31045932:31051974,31045934:31046404,31045935:31052137,31045936:31046450,31046303:31047053,31047166:31048517,31047285:31048673,31047286:31048713,31047698:31048964,31049424:31049968,31050033:31050199,31050633:31050736,31050886:31051139,31051246:31051348,31052870:31053259,31053556:31053840,31053558:31053919,31053560:31053883,31054427:31054757,31055396:31055547,31056477:31057034,31056725:31056906,31056726:31056942,31057174:31057302,31057405:31057594,31058085:31058195,31058403:31058996,31058626:31058862,31059582:31059750,31061733:31061828,31061982:31062499,31062182:31062327,31062448:31062652,31062449:31062690,31062799:31062878,31063557:31063739,31063801:31063944,31063804:31064067,31065712:31065998,31065777:31066114,31065778:31066029,31066969:31067246,31067613:31067882,31068571:31068665,31068799:31068966,31069363:31069461,31070243:31071052,31070564:31070667,31070795:3107093', 'assoc_mat': '31044719:pet_fonce:4230:31045608,31044721:pet_fonce:4230:31045697,31044724:pet_fonce:4230:31045806,31044725:pet_fonce:4230:31045859,31044727:pet_fonce:4230:31046155,31044729:pet_fonce:4230:31051899,31044730:pet_fonce:4230:31051926,31045929:pet_fonce:4230:31052010,31045932:pet_fonce:4230:31051974,31045934:pet_fonce:4230:31046404,31045935:pet_fonce:4230:31052137,31045936:pet_fonce:4230:31046450,31046303:pet_fonce:4230:31047053,31047166:pet_fonce:4230:31048517,31047285:pet_fonce:4230:31048673,31047286:pet_fonce:4230:31048713,31047698:pet_fonce:4230:31048964,31049424:pet_fonce:4230:31049968,31050033:pet_fonce:4230:31050199,31050633:pet_fonce:4230:31050736,31050886:pet_fonce:4230:31051139,31051246:pet_fonce:4230:31051348,31052870:pet_fonce:4230:31053259,31053556:pet_fonce:4230:31053840,31053558:pet_fonce:4230:31053919,31053560:pet_fonce:4230:31053883,31054427:pet_fonce:4230:31054757,31055396:pet_fonce:4230:31055547,31056477:pet_fonce:4230:31057034,31056725:pet_fonce:4230:31056906,31056726:pet_fonce:4230:31056942,3'}), 'main_stat': {'nb_photos': 1175}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/31081562,31081563,31081564,31081565,31081566,31081567,31081568?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-05', 0.7439077625039429),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_05_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.17%', 10215], 'carton': ['carton', '6.58%', 74500], 'metal': ['metal', '0.14%', 1306], 'papier': ['papier', '18.49%', 260555], 'pehd': ['pehd', '0.41%', 1381], 'pet_clair': ['pet_clair', '1.35%', 11078], 'pet_fonce': ['pet_fonce', '0.25%', 395]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_05_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.54user 3.04system 0:08.20elapsed 68%CPU (0avgtext+0avgdata 188764maxresident)k 8inputs+296outputs (0major+49080minor)pagefaults 0swaps