python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2026-02 _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 : (6, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (6, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 02 mtr_id : dashboard_places : SCCU_cam6 date : 2026-02 year : 2026 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2026-02%') and created_at like '%2026-02%'))); nb_day : (6, 28) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 202 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 02 and year(ded.date) = 2026 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%022026%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2026-02-01 : dt_date_just_month_year : 2026-02-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2026-02-01" AND ded.date <= "2026-02-28" 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 (2897173,2898369,2899411,2900187,2901460,2902236,2903174,2903641,2904623,2905402,2906425,2907541,2908595,2909391,2909946,2911147,2912403,2913613,2919456,2922891,2923659,2924345,2925276,2926590,2927210,2928085,2929333,2933502) 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.018024219435296838, 'nb_photo': 21747, 'list_port_cont': '30284522,30284586,30285186,30285731,30285814,30285997,30286063,30286103,30286138,30286171,30286200,30286247,30286286,30286310,30286329,30286394,30286425,30286455,30286501,30286570,30286716,30288112,30288143,30296612,30296755,30296808,30296844,30296899,30296939,30296987,30297022,30297048,30297096,30297122,30297157,30297164,30297237,30297270,30297298,30297354,30297400,30297437,30297503,30297533,30297709,30297840,30298059,30298199,30298325,30298610,30298631,30298997,30299033,30299689,30300359,30300428,30300766,30300996,30301444,30301633,30301913,30302012,30302583,30303188,30303231,30303782,30304134,30304532,30305477,30306239,30312313,30312359,30313123,30313186,30313205,30313263,30313301,30313343,30313381,30313395,30313451,30313477,30313510,30313539,30313591,30313627,30313674,30313689,30313732,30313772,30313860,30313995,30314066,30314100,30323236,30323392,30323538,30324120,30324399,30324474,30324658,30324718,30324768,30324857,30325110,30325127,30325178,30325221,30325246,30325286,30325458,30325501,30325546,3032564', 'assoc_port': '30284291:30284586,30284292:30284522,30284293:30285186,30284294:30288143,30284296:30285731,30284298:30288112,30284300:30286286,30284302:30286501,30284304:30286329,30284305:30286455,30284307:30286310,30284309:30286247,30284311:30286138,30284313:30286171,30284317:30286394,30284319:30285997,30284322:30286200,30284325:30286425,30284328:30286063,30284331:30286103,30284334:30285814,30286525:30286570,30286649:30286716,30295932:30296612,30295933:30297840,30295934:30296987,30295935:30297237,30295937:30297096,30295939:30297298,30295941:30297122,30295943:30297437,30295945:30297400,30295947:30297022,30295949:30297048,30295951:30297354,30295953:30297157,30295955:30297164,30295957:30297270,30295959:30296899,30295961:30296808,30295964:30296844,30295966:30296939,30295968:30296755,30295970:30297503,30297482:30297533,30297610:30297709,30298011:30298199,30298012:30298059,30298267:30298325,30298532:30298631,30298533:30298610,30298794:30298997,30298795:30299033,30299538:30299689,30300196:30300359,30300197:30300428,30300478:3030076', 'assoc_mat': '30284291:autre:4230:30284586,30284292:autre:4230:30284522,30284293:autre:4230:30285186,30284294:autre:4230:30288143,30284296:autre:4230:30285731,30284298:autre:4230:30288112,30284300:autre:4230:30286286,30284302:autre:4230:30286501,30284304:autre:4230:30286329,30284305:autre:4230:30286455,30284307:autre:4230:30286310,30284309:autre:4230:30286247,30284311:autre:4230:30286138,30284313:autre:4230:30286171,30284317:autre:4230:30286394,30284319:autre:4230:30285997,30284322:autre:4230:30286200,30284325:autre:4230:30286425,30284328:autre:4230:30286063,30284331:autre:4230:30286103,30284334:autre:4230:30285814,30286525:autre:4230:30286570,30286649:autre:4230:30286716,30295932:autre:4230:30296612,30295933:autre:4230:30297840,30295934:autre:4230:30296987,30295935:autre:4230:30297237,30295937:autre:4230:30297096,30295939:autre:4230:30297298,30295941:autre:4230:30297122,30295943:autre:4230:30297437,30295945:autre:4230:30297400,30295947:autre:4230:30297022,30295949:autre:4230:30297048,30295951:autre:4230:30297354,30295953:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04890912189024747, 'nb_photo': 90286, 'list_port_cont': '30284535,30284588,30285183,30285743,30285812,30285986,30286062,30286108,30286137,30286181,30286213,30286250,30286288,30286325,30286351,30286389,30286429,30286463,30286506,30286583,30286721,30288101,30288146,30296624,30296772,30296804,30296834,30296907,30296937,30296982,30297012,30297060,30297093,30297125,30297178,30297179,30297243,30297277,30297311,30297356,30297394,30297442,30297490,30297536,30297719,30297844,30298063,30298191,30298326,30298606,30298647,30299005,30299031,30299693,30300349,30300434,30300779,30300998,30301434,30301628,30301910,30302020,30302591,30303198,30303227,30303781,30304126,30304528,30305480,30306252,30312321,30312362,30313118,30313202,30313214,30313269,30313311,30313339,30313375,30313400,30313450,30313489,30313524,30313535,30313597,30313628,30313672,30313691,30313737,30313776,30313866,30313989,30314070,30314102,30323231,30323378,30323532,30324124,30324404,30324477,30324649,30324707,30324774,30324850,30325112,30325125,30325182,30325220,30325256,30325293,30325473,30325510,30325548,3032564', 'assoc_port': '30284291:30284588,30284292:30284535,30284293:30285183,30284294:30288146,30284296:30285743,30284298:30288101,30284300:30286288,30284302:30286506,30284304:30286351,30284305:30286463,30284307:30286325,30284309:30286250,30284311:30286137,30284313:30286181,30284317:30286389,30284319:30285986,30284322:30286213,30284325:30286429,30284328:30286062,30284331:30286108,30284334:30285812,30286525:30286583,30286649:30286721,30295932:30296624,30295933:30297844,30295934:30296982,30295935:30297243,30295937:30297093,30295939:30297311,30295941:30297125,30295943:30297442,30295945:30297394,30295947:30297012,30295949:30297060,30295951:30297356,30295953:30297179,30295955:30297178,30295957:30297277,30295959:30296907,30295961:30296804,30295964:30296834,30295966:30296937,30295968:30296772,30295970:30297490,30297482:30297536,30297610:30297719,30298011:30298191,30298012:30298063,30298267:30298326,30298532:30298647,30298533:30298606,30298794:30299005,30298795:30299031,30299538:30299693,30300196:30300349,30300197:30300434,30300478:3030077', 'assoc_mat': '30284291:carton:4230:30284588,30284292:carton:4230:30284535,30284293:carton:4230:30285183,30284294:carton:4230:30288146,30284296:carton:4230:30285743,30284298:carton:4230:30288101,30284300:carton:4230:30286288,30284302:carton:4230:30286506,30284304:carton:4230:30286351,30284305:carton:4230:30286463,30284307:carton:4230:30286325,30284309:carton:4230:30286250,30284311:carton:4230:30286137,30284313:carton:4230:30286181,30284317:carton:4230:30286389,30284319:carton:4230:30285986,30284322:carton:4230:30286213,30284325:carton:4230:30286429,30284328:carton:4230:30286062,30284331:carton:4230:30286108,30284334:carton:4230:30285812,30286525:carton:4230:30286583,30286649:carton:4230:30286721,30295932:carton:4230:30296624,30295933:carton:4230:30297844,30295934:carton:4230:30296982,30295935:carton:4230:30297243,30295937:carton:4230:30297093,30295939:carton:4230:30297311,30295941:carton:4230:30297125,30295943:carton:4230:30297442,30295945:carton:4230:30297394,30295947:carton:4230:30297012,30295949:carton:4230:30297060,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013649976755066412, 'nb_photo': 1821, 'list_port_cont': '30284530,30284572,30285171,30285737,30285994,30286058,30286097,30286134,30286178,30286202,30286281,30286315,30286330,30286428,30286462,30286495,30296910,30296935,30296978,30297024,30297051,30297081,30297133,30297155,30297230,30297269,30297308,30297352,30297403,30297440,30297492,30297530,30297724,30297839,30298188,30298602,30298630,30299008,30299040,30299682,30300350,30300429,30300774,30300988,30301437,30301637,30301912,30302005,30302586,30303180,30303224,30303769,30304133,30312328,30312357,30313122,30313216,30313273,30313304,30313338,30313368,30313388,30313452,30313527,30313543,30313588,30313624,30313673,30313675,30313743,30313768,30313857,30313985,30314074,30314112,30323230,30323388,30323527,30324121,30324387,30324654,30324714,30324761,30324856,30325096,30325119,30325184,30325204,30325241,30325291,30325472,30325502,30325632,30325741,30325864,30331240,30331271,30331348,30331386,30331417,30331466,30331487,30331540,30331556,30331607,30331628,30331671,30331718,30331758,30331783,30331827,30331860,30332114,3033224', 'assoc_port': '30284291:30284572,30284292:30284530,30284293:30285171,30284296:30285737,30284300:30286281,30284302:30286495,30284304:30286330,30284305:30286462,30284307:30286315,30284311:30286134,30284313:30286178,30284319:30285994,30284322:30286202,30284325:30286428,30284328:30286058,30284331:30286097,30295933:30297839,30295934:30296978,30295935:30297230,30295937:30297081,30295939:30297308,30295941:30297133,30295943:30297440,30295945:30297403,30295947:30297024,30295949:30297051,30295951:30297352,30295955:30297155,30295957:30297269,30295959:30296910,30295966:30296935,30295970:30297492,30297482:30297530,30297610:30297724,30298011:30298188,30298532:30298630,30298533:30298602,30298794:30299008,30298795:30299040,30299538:30299682,30300196:30300350,30300197:30300429,30300478:30300774,30300898:30300988,30301349:30301437,30301350:30301637,30301766:30301912,30301951:30302005,30302447:30302586,30303081:30303224,30303084:30303180,30303709:30303769,30303875:30304133,30312229:30314112,30312230:30314074,30312231:30313543,30312232:3031367', 'assoc_mat': '30284291:metal:4230:30284572,30284292:metal:4230:30284530,30284293:metal:4230:30285171,30284296:metal:4230:30285737,30284300:metal:4230:30286281,30284302:metal:4230:30286495,30284304:metal:4230:30286330,30284305:metal:4230:30286462,30284307:metal:4230:30286315,30284311:metal:4230:30286134,30284313:metal:4230:30286178,30284319:metal:4230:30285994,30284322:metal:4230:30286202,30284325:metal:4230:30286428,30284328:metal:4230:30286058,30284331:metal:4230:30286097,30295933:metal:4230:30297839,30295934:metal:4230:30296978,30295935:metal:4230:30297230,30295937:metal:4230:30297081,30295939:metal:4230:30297308,30295941:metal:4230:30297133,30295943:metal:4230:30297440,30295945:metal:4230:30297403,30295947:metal:4230:30297024,30295949:metal:4230:30297051,30295951:metal:4230:30297352,30295955:metal:4230:30297155,30295957:metal:4230:30297269,30295959:metal:4230:30296910,30295966:metal:4230:30296935,30295970:metal:4230:30297492,30297482:metal:4230:30297530,30297610:metal:4230:30297724,30298011:metal:4230:30298188,30298532:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19097639573851732, 'nb_photo': 408128, 'list_port_cont': '30284528,30284583,30285185,30285736,30285810,30286000,30286065,30286100,30286143,30286180,30286211,30286246,30286282,30286321,30286343,30286393,30286424,30286466,30286500,30286580,30286722,30288107,30288148,30296615,30296761,30296799,30296840,30296915,30296947,30296977,30297017,30297053,30297084,30297121,30297174,30297185,30297229,30297266,30297312,30297347,30297399,30297431,30297497,30297535,30297714,30297841,30298068,30298198,30298333,30298598,30298640,30299002,30299039,30299694,30300356,30300426,30300770,30301003,30301442,30301640,30301899,30302014,30302589,30303190,30303238,30303779,30304140,30304529,30305478,30306249,30312329,30312363,30313124,30313197,30313212,30313264,30313305,30313347,30313380,30313396,30313443,30313481,30313525,30313542,30313584,30313629,30313667,30313692,30313741,30313780,30313855,30313998,30314067,30314115,30323235,30323391,30323537,30324131,30324402,30324470,30324652,30324713,30324764,30324855,30325108,30325124,30325177,30325219,30325254,30325284,30325469,30325506,30325533,3032562', 'assoc_port': '30284291:30284583,30284292:30284528,30284293:30285185,30284294:30288148,30284296:30285736,30284298:30288107,30284300:30286282,30284302:30286500,30284304:30286343,30284305:30286466,30284307:30286321,30284309:30286246,30284311:30286143,30284313:30286180,30284317:30286393,30284319:30286000,30284322:30286211,30284325:30286424,30284328:30286065,30284331:30286100,30284334:30285810,30286525:30286580,30286649:30286722,30295932:30296615,30295933:30297841,30295934:30296977,30295935:30297229,30295937:30297084,30295939:30297312,30295941:30297121,30295943:30297431,30295945:30297399,30295947:30297017,30295949:30297053,30295951:30297347,30295953:30297185,30295955:30297174,30295957:30297266,30295959:30296915,30295961:30296799,30295964:30296840,30295966:30296947,30295968:30296761,30295970:30297497,30297482:30297535,30297610:30297714,30298011:30298198,30298012:30298068,30298267:30298333,30298532:30298640,30298533:30298598,30298794:30299002,30298795:30299039,30299538:30299694,30300196:30300356,30300197:30300426,30300478:3030077', 'assoc_mat': '30284291:papier:4230:30284583,30284292:papier:4230:30284528,30284293:papier:4230:30285185,30284294:papier:4230:30288148,30284296:papier:4230:30285736,30284298:papier:4230:30288107,30284300:papier:4230:30286282,30284302:papier:4230:30286500,30284304:papier:4230:30286343,30284305:papier:4230:30286466,30284307:papier:4230:30286321,30284309:papier:4230:30286246,30284311:papier:4230:30286143,30284313:papier:4230:30286180,30284317:papier:4230:30286393,30284319:papier:4230:30286000,30284322:papier:4230:30286211,30284325:papier:4230:30286424,30284328:papier:4230:30286065,30284331:papier:4230:30286100,30284334:papier:4230:30285810,30286525:papier:4230:30286580,30286649:papier:4230:30286722,30295932:papier:4230:30296615,30295933:papier:4230:30297841,30295934:papier:4230:30296977,30295935:papier:4230:30297229,30295937:papier:4230:30297084,30295939:papier:4230:30297312,30295941:papier:4230:30297121,30295943:papier:4230:30297431,30295945:papier:4230:30297399,30295947:papier:4230:30297017,30295949:papier:4230:30297053,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004272826668510093, 'nb_photo': 2764, 'list_port_cont': '30284585,30285738,30286001,30286069,30286109,30286177,30286217,30286386,30286503,30286725,30288105,30288147,30296620,30296771,30296794,30296839,30296913,30296950,30297019,30297059,30297131,30297160,30297169,30297276,30297353,30297389,30297443,30297531,30298197,30298332,30298603,30298998,30299690,30300361,30300435,30300776,30301002,30301638,30301905,30302018,30303195,30303783,30304136,30305484,30306251,30312327,30312355,30313129,30313219,30313272,30313310,30313345,30313378,30313397,30313447,30313484,30313522,30313536,30313592,30313626,30313668,30313686,30313745,30313777,30313865,30313988,30314108,30323232,30323385,30324132,30324403,30324476,30324660,30324715,30324777,30324854,30325107,30325130,30325172,30325218,30325253,30325287,30325461,30325499,30325542,30325629,30325749,30325865,30331244,30331278,30331317,30331350,30331388,30331424,30331462,30331497,30331541,30331559,30331606,30331629,30331678,30331716,30331757,30331788,30331830,30331859,30332122,30332193,30332239,30332275,30332956,30338594,30338635,3033871', 'assoc_port': '30284291:30284585,30284294:30288147,30284296:30285738,30284298:30288105,30284302:30286503,30284313:30286177,30284317:30286386,30284319:30286001,30284322:30286217,30284328:30286069,30284331:30286109,30286649:30286725,30295932:30296620,30295941:30297131,30295943:30297443,30295945:30297389,30295947:30297019,30295949:30297059,30295951:30297353,30295953:30297169,30295955:30297160,30295957:30297276,30295959:30296913,30295961:30296794,30295964:30296839,30295966:30296950,30295968:30296771,30297482:30297531,30298011:30298197,30298267:30298332,30298533:30298603,30298794:30298998,30299538:30299690,30300196:30300361,30300197:30300435,30300478:30300776,30300898:30301002,30301350:30301638,30301766:30301905,30301951:30302018,30303084:30303195,30303709:30303783,30303875:30304136,30305353:30305484,30306197:30306251,30312229:30314108,30312231:30313536,30312232:30313668,30312233:30313484,30312234:30313522,30312235:30313686,30312237:30313310,30312238:30313447,30312239:30312355,30312241:30313777,30312244:30313626,30312247:3031359', 'assoc_mat': '30284291:pehd:4230:30284585,30284294:pehd:4230:30288147,30284296:pehd:4230:30285738,30284298:pehd:4230:30288105,30284302:pehd:4230:30286503,30284313:pehd:4230:30286177,30284317:pehd:4230:30286386,30284319:pehd:4230:30286001,30284322:pehd:4230:30286217,30284328:pehd:4230:30286069,30284331:pehd:4230:30286109,30286649:pehd:4230:30286725,30295932:pehd:4230:30296620,30295941:pehd:4230:30297131,30295943:pehd:4230:30297443,30295945:pehd:4230:30297389,30295947:pehd:4230:30297019,30295949:pehd:4230:30297059,30295951:pehd:4230:30297353,30295953:pehd:4230:30297169,30295955:pehd:4230:30297160,30295957:pehd:4230:30297276,30295959:pehd:4230:30296913,30295961:pehd:4230:30296794,30295964:pehd:4230:30296839,30295966:pehd:4230:30296950,30295968:pehd:4230:30296771,30297482:pehd:4230:30297531,30298011:pehd:4230:30298197,30298267:pehd:4230:30298332,30298533:pehd:4230:30298603,30298794:pehd:4230:30298998,30299538:pehd:4230:30299690,30300196:pehd:4230:30300361,30300197:pehd:4230:30300435,30300478:pehd:4230:30300776,30300898:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014357230055985624, 'nb_photo': 25104, 'list_port_cont': '30284532,30284580,30285179,30285744,30285783,30285999,30286073,30286105,30286145,30286173,30286214,30286241,30286280,30286324,30286349,30286392,30286423,30286464,30286499,30286582,30286723,30288109,30288138,30296623,30296765,30296801,30296843,30296905,30296944,30296983,30297023,30297056,30297092,30297130,30297156,30297187,30297239,30297275,30297313,30297357,30297397,30297441,30297494,30297539,30297722,30297842,30298061,30298194,30298321,30298605,30298645,30299007,30299036,30299680,30300360,30300424,30300783,30300997,30301440,30301643,30301908,30302015,30302593,30303193,30303236,30303775,30304127,30304521,30305481,30306247,30312326,30312366,30313126,30313200,30313215,30313270,30313307,30313340,30313379,30313399,30313455,30313486,30313521,30313545,30313600,30313633,30313664,30313684,30313746,30313779,30313856,30313996,30314080,30314114,30323233,30323390,30323536,30324123,30324397,30324469,30324651,30324709,30324767,30324852,30325111,30325123,30325179,30325215,30325257,30325294,30325468,30325508,30325541,3032563', 'assoc_port': '30284291:30284580,30284292:30284532,30284293:30285179,30284294:30288138,30284296:30285744,30284298:30288109,30284300:30286280,30284302:30286499,30284304:30286349,30284305:30286464,30284307:30286324,30284309:30286241,30284311:30286145,30284313:30286173,30284317:30286392,30284319:30285999,30284322:30286214,30284325:30286423,30284328:30286073,30284331:30286105,30284334:30285783,30286525:30286582,30286649:30286723,30295932:30296623,30295933:30297842,30295934:30296983,30295935:30297239,30295937:30297092,30295939:30297313,30295941:30297130,30295943:30297441,30295945:30297397,30295947:30297023,30295949:30297056,30295951:30297357,30295953:30297187,30295955:30297156,30295957:30297275,30295959:30296905,30295961:30296801,30295964:30296843,30295966:30296944,30295968:30296765,30295970:30297494,30297482:30297539,30297610:30297722,30298011:30298194,30298012:30298061,30298267:30298321,30298532:30298645,30298533:30298605,30298794:30299007,30298795:30299036,30299538:30299680,30300196:30300360,30300197:30300424,30300478:3030078', 'assoc_mat': '30284291:pet_clair:4230:30284580,30284292:pet_clair:4230:30284532,30284293:pet_clair:4230:30285179,30284294:pet_clair:4230:30288138,30284296:pet_clair:4230:30285744,30284298:pet_clair:4230:30288109,30284300:pet_clair:4230:30286280,30284302:pet_clair:4230:30286499,30284304:pet_clair:4230:30286349,30284305:pet_clair:4230:30286464,30284307:pet_clair:4230:30286324,30284309:pet_clair:4230:30286241,30284311:pet_clair:4230:30286145,30284313:pet_clair:4230:30286173,30284317:pet_clair:4230:30286392,30284319:pet_clair:4230:30285999,30284322:pet_clair:4230:30286214,30284325:pet_clair:4230:30286423,30284328:pet_clair:4230:30286073,30284331:pet_clair:4230:30286105,30284334:pet_clair:4230:30285783,30286525:pet_clair:4230:30286582,30286649:pet_clair:4230:30286723,30295932:pet_clair:4230:30296623,30295933:pet_clair:4230:30297842,30295934:pet_clair:4230:30296983,30295935:pet_clair:4230:30297239,30295937:pet_clair:4230:30297092,30295939:pet_clair:4230:30297313,30295941:pet_clair:4230:30297130,30295943:pet_clair:4230:30297441,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003017221730703456, 'nb_photo': 1242, 'list_port_cont': '30284589,30285740,30286141,30286239,30286284,30286319,30286339,30286469,30286502,30286713,30288103,30288145,30296842,30296911,30296952,30297020,30297057,30297090,30297171,30297180,30297240,30297268,30297351,30297528,30298644,30298999,30299041,30299695,30300358,30300432,30300782,30301004,30301903,30302019,30303197,30303776,30304137,30304530,30306254,30312319,30312350,30313344,30313371,30313390,30313448,30313491,30313526,30313589,30313637,30313659,30313690,30313738,30313782,30313863,30313984,30314077,30323237,30323533,30324391,30324472,30324653,30324711,30324778,30324851,30325103,30325181,30325209,30325467,30325504,30325547,30325643,30325755,30325854,30331238,30331281,30331321,30331356,30331382,30331413,30331467,30331498,30331551,30331613,30331627,30331683,30331720,30331753,30331794,30331829,30331864,30332124,30332235,30332273,30332968,30338596,30338642,30338710,30338743,30338774,30338820,30338840,30338887,30338930,30338966,30338982,30339038,30339069,30339102,30339146,30339186,30339219,30339259,30339291,3033932', 'assoc_port': '30284291:30284589,30284294:30288145,30284296:30285740,30284298:30288103,30284300:30286284,30284302:30286502,30284304:30286339,30284305:30286469,30284307:30286319,30284309:30286239,30284311:30286141,30286649:30286713,30295935:30297240,30295937:30297090,30295947:30297020,30295949:30297057,30295951:30297351,30295953:30297171,30295955:30297180,30295957:30297268,30295959:30296911,30295964:30296842,30295966:30296952,30297482:30297528,30298532:30298644,30298794:30298999,30298795:30299041,30299538:30299695,30300196:30300358,30300197:30300432,30300478:30300782,30300898:30301004,30301766:30301903,30301951:30302019,30303084:30303197,30303709:30303776,30303875:30304137,30304496:30304530,30306197:30306254,30312230:30314077,30312232:30313659,30312233:30313491,30312234:30313526,30312235:30313690,30312238:30313448,30312239:30312350,30312241:30313782,30312244:30313637,30312247:30313589,30312249:30313738,30312253:30313344,30312255:30313371,30312259:30313390,30312263:30312319,30313809:30313863,30313938:30313984,30323084:3032323', 'assoc_mat': '30284291:pet_fonce:4230:30284589,30284294:pet_fonce:4230:30288145,30284296:pet_fonce:4230:30285740,30284298:pet_fonce:4230:30288103,30284300:pet_fonce:4230:30286284,30284302:pet_fonce:4230:30286502,30284304:pet_fonce:4230:30286339,30284305:pet_fonce:4230:30286469,30284307:pet_fonce:4230:30286319,30284309:pet_fonce:4230:30286239,30284311:pet_fonce:4230:30286141,30286649:pet_fonce:4230:30286713,30295935:pet_fonce:4230:30297240,30295937:pet_fonce:4230:30297090,30295947:pet_fonce:4230:30297020,30295949:pet_fonce:4230:30297057,30295951:pet_fonce:4230:30297351,30295953:pet_fonce:4230:30297171,30295955:pet_fonce:4230:30297180,30295957:pet_fonce:4230:30297268,30295959:pet_fonce:4230:30296911,30295964:pet_fonce:4230:30296842,30295966:pet_fonce:4230:30296952,30297482:pet_fonce:4230:30297528,30298532:pet_fonce:4230:30298644,30298794:pet_fonce:4230:30298999,30298795:pet_fonce:4230:30299041,30299538:pet_fonce:4230:30299695,30300196:pet_fonce:4230:30300358,30300197:pet_fonce:4230:30300432,30300478:pet_fonce:4230:30300782,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(2897173,2898369,2899411,2900187,2901460,2902236,2903174,2903641,2904623,2905402,2906425,2907541,2908595,2909391,2909946,2911147,2912403,2913613,2919456,2922891,2923659,2924345,2925276,2926590,2927210,2928085,2929333,2933502)); INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496529, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284522,30284586,30285186,30285731,30285814,30285997,30286063,30286103,30286138,30286171,30286200,30286247,30286286,30286310,30286329,30286394,30286425,30286455,30286501,30286570,30286716,30288112,30288143,30296612,30296755,30296808,30296844,30296899,30296939,30296987,30297022,30297048,30297096,30297122,30297157,30297164,30297237,30297270,30297298,30297354,30297400,30297437,30297503,30297533,30297709,30297840,30298059,30298199,30298325,30298610,30298631,30298997,30299033,30299689,30300359,30300428,30300766,30300996,30301444,30301633,30301913,30302012,30302583,30303188,30303231,30303782,30304134,30304532,30305477,30306239,30312313,30312359,30313123,30313186,30313205,30313263,30313301,30313343,30313381,30313395,30313451,30313477,30313510,30313539,30313591,30313627,30313674,30313689,30313732,30313772,30313860,30313995,30314066,30314100,30323236,30323392,30323538,30324120,30324399,30324474,30324658,30324718,30324768,30324857,30325110,30325127,30325178,30325221,30325246,30325286,30325458,30325501,30325546,3032564 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496530, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284535,30284588,30285183,30285743,30285812,30285986,30286062,30286108,30286137,30286181,30286213,30286250,30286288,30286325,30286351,30286389,30286429,30286463,30286506,30286583,30286721,30288101,30288146,30296624,30296772,30296804,30296834,30296907,30296937,30296982,30297012,30297060,30297093,30297125,30297178,30297179,30297243,30297277,30297311,30297356,30297394,30297442,30297490,30297536,30297719,30297844,30298063,30298191,30298326,30298606,30298647,30299005,30299031,30299693,30300349,30300434,30300779,30300998,30301434,30301628,30301910,30302020,30302591,30303198,30303227,30303781,30304126,30304528,30305480,30306252,30312321,30312362,30313118,30313202,30313214,30313269,30313311,30313339,30313375,30313400,30313450,30313489,30313524,30313535,30313597,30313628,30313672,30313691,30313737,30313776,30313866,30313989,30314070,30314102,30323231,30323378,30323532,30324124,30324404,30324477,30324649,30324707,30324774,30324850,30325112,30325125,30325182,30325220,30325256,30325293,30325473,30325510,30325548,3032564 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496531, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284530,30284572,30285171,30285737,30285994,30286058,30286097,30286134,30286178,30286202,30286281,30286315,30286330,30286428,30286462,30286495,30296910,30296935,30296978,30297024,30297051,30297081,30297133,30297155,30297230,30297269,30297308,30297352,30297403,30297440,30297492,30297530,30297724,30297839,30298188,30298602,30298630,30299008,30299040,30299682,30300350,30300429,30300774,30300988,30301437,30301637,30301912,30302005,30302586,30303180,30303224,30303769,30304133,30312328,30312357,30313122,30313216,30313273,30313304,30313338,30313368,30313388,30313452,30313527,30313543,30313588,30313624,30313673,30313675,30313743,30313768,30313857,30313985,30314074,30314112,30323230,30323388,30323527,30324121,30324387,30324654,30324714,30324761,30324856,30325096,30325119,30325184,30325204,30325241,30325291,30325472,30325502,30325632,30325741,30325864,30331240,30331271,30331348,30331386,30331417,30331466,30331487,30331540,30331556,30331607,30331628,30331671,30331718,30331758,30331783,30331827,30331860,30332114,3033224 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496532, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284528,30284583,30285185,30285736,30285810,30286000,30286065,30286100,30286143,30286180,30286211,30286246,30286282,30286321,30286343,30286393,30286424,30286466,30286500,30286580,30286722,30288107,30288148,30296615,30296761,30296799,30296840,30296915,30296947,30296977,30297017,30297053,30297084,30297121,30297174,30297185,30297229,30297266,30297312,30297347,30297399,30297431,30297497,30297535,30297714,30297841,30298068,30298198,30298333,30298598,30298640,30299002,30299039,30299694,30300356,30300426,30300770,30301003,30301442,30301640,30301899,30302014,30302589,30303190,30303238,30303779,30304140,30304529,30305478,30306249,30312329,30312363,30313124,30313197,30313212,30313264,30313305,30313347,30313380,30313396,30313443,30313481,30313525,30313542,30313584,30313629,30313667,30313692,30313741,30313780,30313855,30313998,30314067,30314115,30323235,30323391,30323537,30324131,30324402,30324470,30324652,30324713,30324764,30324855,30325108,30325124,30325177,30325219,30325254,30325284,30325469,30325506,30325533,3032562 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496533, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284585,30285738,30286001,30286069,30286109,30286177,30286217,30286386,30286503,30286725,30288105,30288147,30296620,30296771,30296794,30296839,30296913,30296950,30297019,30297059,30297131,30297160,30297169,30297276,30297353,30297389,30297443,30297531,30298197,30298332,30298603,30298998,30299690,30300361,30300435,30300776,30301002,30301638,30301905,30302018,30303195,30303783,30304136,30305484,30306251,30312327,30312355,30313129,30313219,30313272,30313310,30313345,30313378,30313397,30313447,30313484,30313522,30313536,30313592,30313626,30313668,30313686,30313745,30313777,30313865,30313988,30314108,30323232,30323385,30324132,30324403,30324476,30324660,30324715,30324777,30324854,30325107,30325130,30325172,30325218,30325253,30325287,30325461,30325499,30325542,30325629,30325749,30325865,30331244,30331278,30331317,30331350,30331388,30331424,30331462,30331497,30331541,30331559,30331606,30331629,30331678,30331716,30331757,30331788,30331830,30331859,30332122,30332193,30332239,30332275,30332956,30338594,30338635,3033871 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496534, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284532,30284580,30285179,30285744,30285783,30285999,30286073,30286105,30286145,30286173,30286214,30286241,30286280,30286324,30286349,30286392,30286423,30286464,30286499,30286582,30286723,30288109,30288138,30296623,30296765,30296801,30296843,30296905,30296944,30296983,30297023,30297056,30297092,30297130,30297156,30297187,30297239,30297275,30297313,30297357,30297397,30297441,30297494,30297539,30297722,30297842,30298061,30298194,30298321,30298605,30298645,30299007,30299036,30299680,30300360,30300424,30300783,30300997,30301440,30301643,30301908,30302015,30302593,30303193,30303236,30303775,30304127,30304521,30305481,30306247,30312326,30312366,30313126,30313200,30313215,30313270,30313307,30313340,30313379,30313399,30313455,30313486,30313521,30313545,30313600,30313633,30313664,30313684,30313746,30313779,30313856,30313996,30314080,30314114,30323233,30323390,30323536,30324123,30324397,30324469,30324651,30324709,30324767,30324852,30325111,30325123,30325179,30325215,30325257,30325294,30325468,30325508,30325541,3032563 ) and hide_status = 0 ORDER BY mtr_photo_id INSERT ignore into MTRUser.mtr_portfolio_photos (`mtr_portfolio_id`, `mtr_photo_id`) SELECT 30496535, mtr_photo_id FROM MTRUser.mtr_portfolio_photos WHERE mtr_portfolio_id in (30284589,30285740,30286141,30286239,30286284,30286319,30286339,30286469,30286502,30286713,30288103,30288145,30296842,30296911,30296952,30297020,30297057,30297090,30297171,30297180,30297240,30297268,30297351,30297528,30298644,30298999,30299041,30299695,30300358,30300432,30300782,30301004,30301903,30302019,30303197,30303776,30304137,30304530,30306254,30312319,30312350,30313344,30313371,30313390,30313448,30313491,30313526,30313589,30313637,30313659,30313690,30313738,30313782,30313863,30313984,30314077,30323237,30323533,30324391,30324472,30324653,30324711,30324778,30324851,30325103,30325181,30325209,30325467,30325504,30325547,30325643,30325755,30325854,30331238,30331281,30331321,30331356,30331382,30331413,30331467,30331498,30331551,30331613,30331627,30331683,30331720,30331753,30331794,30331829,30331864,30332124,30332235,30332273,30332968,30338596,30338642,30338710,30338743,30338774,30338820,30338840,30338887,30338930,30338966,30338982,30339038,30339069,30339102,30339146,30339186,30339219,30339259,30339291,3033932 ) and hide_status = 0 ORDER BY mtr_photo_id Voici le lien velours for incineration : https://www.fotonower.com/velours/30496529,30496530,30496531,30496532,30496533,30496534,30496535?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2026-02-01' and date <= '2026-02-28') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1868,),), 'unwanted_material_monthly_percentage': ((0.7448433745234064,),), 'material_repartition': (('incineration', 1842),), 'material_dict': {'incineration': 1842}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 1), 0.820896807506365, 3), (datetime.date(2026, 2, 2), 0.7919911396737338, 1), (datetime.date(2026, 2, 3), 0.7669830149879394, 3), (datetime.date(2026, 2, 4), 0.72148130324224, 3), (datetime.date(2026, 2, 5), 0.6760849216044916, 2), (datetime.date(2026, 2, 6), 0.66012374245399, 2), (datetime.date(2026, 2, 7), 0.6749287533236649, 2), (datetime.date(2026, 2, 8), 0.797892244630382, 2), (datetime.date(2026, 2, 9), 0.7685056972357455, 3), (datetime.date(2026, 2, 10), 0.7701272413535374, 3), (datetime.date(2026, 2, 11), 0.7078305900710249, 3), (datetime.date(2026, 2, 12), 0.6892172054546571, 2), (datetime.date(2026, 2, 13), 0.6811879023107683, 2), (datetime.date(2026, 2, 14), 0.7310736773657674, 3), (datetime.date(2026, 2, 15), 0.7648213252433053, 4), (datetime.date(2026, 2, 16), 0.7937180191626504, 4), (datetime.date(2026, 2, 17), 0.7435147698083808, 4), (datetime.date(2026, 2, 18), 0.7316778438489536, 4), (datetime.date(2026, 2, 19), 0.727512707061028, 3), (datetime.date(2026, 2, 20), 0.6901205314207042, 2), (datetime.date(2026, 2, 21), 0.7478553637884494, 3), (datetime.date(2026, 2, 22), 0.860136047353649, 2), (datetime.date(2026, 2, 23), 0.7890567627612781, 2), (datetime.date(2026, 2, 24), 0.7806351433101089, 1), (datetime.date(2026, 2, 25), 0.7700824159675639, 2), (datetime.date(2026, 2, 26), 0.7400846141805941, 2), (datetime.date(2026, 2, 27), 0.7089302625673601, 3), (datetime.date(2026, 2, 28), 0.7089739621299249, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 2, 1), 0.820896807506365, 3), (datetime.date(2026, 2, 2), 0.7919911396737338, 1), (datetime.date(2026, 2, 3), 0.7669830149879394, 3), (datetime.date(2026, 2, 4), 0.72148130324224, 3), (datetime.date(2026, 2, 5), 0.6760849216044916, 2), (datetime.date(2026, 2, 6), 0.66012374245399, 2), (datetime.date(2026, 2, 7), 0.6749287533236649, 2), (datetime.date(2026, 2, 8), 0.797892244630382, 2), (datetime.date(2026, 2, 9), 0.7685056972357455, 3), (datetime.date(2026, 2, 10), 0.7701272413535374, 3), (datetime.date(2026, 2, 11), 0.7078305900710249, 3), (datetime.date(2026, 2, 12), 0.6892172054546571, 2), (datetime.date(2026, 2, 13), 0.6811879023107683, 2), (datetime.date(2026, 2, 14), 0.7310736773657674, 3), (datetime.date(2026, 2, 15), 0.7648213252433053, 4), (datetime.date(2026, 2, 16), 0.7937180191626504, 4), (datetime.date(2026, 2, 17), 0.7435147698083808, 4), (datetime.date(2026, 2, 18), 0.7316778438489536, 4), (datetime.date(2026, 2, 19), 0.727512707061028, 3), (datetime.date(2026, 2, 20), 0.6901205314207042, 2), (datetime.date(2026, 2, 21), 0.7478553637884494, 3), (datetime.date(2026, 2, 22), 0.860136047353649, 2), (datetime.date(2026, 2, 23), 0.7890567627612781, 2), (datetime.date(2026, 2, 24), 0.7806351433101089, 1), (datetime.date(2026, 2, 25), 0.7700824159675639, 2), (datetime.date(2026, 2, 26), 0.7400846141805941, 2), (datetime.date(2026, 2, 27), 0.7089302625673601, 3), (datetime.date(2026, 2, 28), 0.7089739621299249, 3))}, 'quality_array': [['-7.959627930258787', '01022026'], ['-7.685264142047652', '02022026'], ['-7.908637035079997', '03022026'], ['-8.181365422198107', '04022026'], ['-8.201260764578098', '05022026'], ['-8.301339020877803', '06022026'], ['-8.33153751904309', '07022026'], ['-8.146116051288466', '08022026'], ['-7.790577195335818', '09022026'], ['-7.360781034156939', '10022026'], ['-8.027722792208735', '11022026'], ['-8.189942085340121', '12022026'], ['-8.391175738866727', '13022026'], ['-8.410311653196581', '14022026'], ['-8.147287611106725', '15022026'], ['-7.782494749553707', '16022026'], ['-7.866669741646915', '17022026'], ['-7.956927352280359', '18022026'], ['-8.061111966957197', '19022026'], ['-8.067936990325519', '20022026'], ['-7.88290361452058', '21022026'], ['-7.750333184943034', '22022026'], ['-7.483863837606115', '23022026'], ['-7.52005165367697', '24022026'], ['-7.57311935313761', '25022026'], ['-7.810235102394644', '26022026'], ['-8.20480652012568', '27022026'], ['-8.111478891148531', '28022026']], 'number_of_batch': ((656,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018024219435296838, 'nb_photo': 21747, 'list_port_cont': '30284522,30284586,30285186,30285731,30285814,30285997,30286063,30286103,30286138,30286171,30286200,30286247,30286286,30286310,30286329,30286394,30286425,30286455,30286501,30286570,30286716,30288112,30288143,30296612,30296755,30296808,30296844,30296899,30296939,30296987,30297022,30297048,30297096,30297122,30297157,30297164,30297237,30297270,30297298,30297354,30297400,30297437,30297503,30297533,30297709,30297840,30298059,30298199,30298325,30298610,30298631,30298997,30299033,30299689,30300359,30300428,30300766,30300996,30301444,30301633,30301913,30302012,30302583,30303188,30303231,30303782,30304134,30304532,30305477,30306239,30312313,30312359,30313123,30313186,30313205,30313263,30313301,30313343,30313381,30313395,30313451,30313477,30313510,30313539,30313591,30313627,30313674,30313689,30313732,30313772,30313860,30313995,30314066,30314100,30323236,30323392,30323538,30324120,30324399,30324474,30324658,30324718,30324768,30324857,30325110,30325127,30325178,30325221,30325246,30325286,30325458,30325501,30325546,3032564', 'assoc_port': '30284291:30284586,30284292:30284522,30284293:30285186,30284294:30288143,30284296:30285731,30284298:30288112,30284300:30286286,30284302:30286501,30284304:30286329,30284305:30286455,30284307:30286310,30284309:30286247,30284311:30286138,30284313:30286171,30284317:30286394,30284319:30285997,30284322:30286200,30284325:30286425,30284328:30286063,30284331:30286103,30284334:30285814,30286525:30286570,30286649:30286716,30295932:30296612,30295933:30297840,30295934:30296987,30295935:30297237,30295937:30297096,30295939:30297298,30295941:30297122,30295943:30297437,30295945:30297400,30295947:30297022,30295949:30297048,30295951:30297354,30295953:30297157,30295955:30297164,30295957:30297270,30295959:30296899,30295961:30296808,30295964:30296844,30295966:30296939,30295968:30296755,30295970:30297503,30297482:30297533,30297610:30297709,30298011:30298199,30298012:30298059,30298267:30298325,30298532:30298631,30298533:30298610,30298794:30298997,30298795:30299033,30299538:30299689,30300196:30300359,30300197:30300428,30300478:3030076', 'assoc_mat': '30284291:autre:4230:30284586,30284292:autre:4230:30284522,30284293:autre:4230:30285186,30284294:autre:4230:30288143,30284296:autre:4230:30285731,30284298:autre:4230:30288112,30284300:autre:4230:30286286,30284302:autre:4230:30286501,30284304:autre:4230:30286329,30284305:autre:4230:30286455,30284307:autre:4230:30286310,30284309:autre:4230:30286247,30284311:autre:4230:30286138,30284313:autre:4230:30286171,30284317:autre:4230:30286394,30284319:autre:4230:30285997,30284322:autre:4230:30286200,30284325:autre:4230:30286425,30284328:autre:4230:30286063,30284331:autre:4230:30286103,30284334:autre:4230:30285814,30286525:autre:4230:30286570,30286649:autre:4230:30286716,30295932:autre:4230:30296612,30295933:autre:4230:30297840,30295934:autre:4230:30296987,30295935:autre:4230:30297237,30295937:autre:4230:30297096,30295939:autre:4230:30297298,30295941:autre:4230:30297122,30295943:autre:4230:30297437,30295945:autre:4230:30297400,30295947:autre:4230:30297022,30295949:autre:4230:30297048,30295951:autre:4230:30297354,30295953:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04890912189024747, 'nb_photo': 90286, 'list_port_cont': '30284535,30284588,30285183,30285743,30285812,30285986,30286062,30286108,30286137,30286181,30286213,30286250,30286288,30286325,30286351,30286389,30286429,30286463,30286506,30286583,30286721,30288101,30288146,30296624,30296772,30296804,30296834,30296907,30296937,30296982,30297012,30297060,30297093,30297125,30297178,30297179,30297243,30297277,30297311,30297356,30297394,30297442,30297490,30297536,30297719,30297844,30298063,30298191,30298326,30298606,30298647,30299005,30299031,30299693,30300349,30300434,30300779,30300998,30301434,30301628,30301910,30302020,30302591,30303198,30303227,30303781,30304126,30304528,30305480,30306252,30312321,30312362,30313118,30313202,30313214,30313269,30313311,30313339,30313375,30313400,30313450,30313489,30313524,30313535,30313597,30313628,30313672,30313691,30313737,30313776,30313866,30313989,30314070,30314102,30323231,30323378,30323532,30324124,30324404,30324477,30324649,30324707,30324774,30324850,30325112,30325125,30325182,30325220,30325256,30325293,30325473,30325510,30325548,3032564', 'assoc_port': '30284291:30284588,30284292:30284535,30284293:30285183,30284294:30288146,30284296:30285743,30284298:30288101,30284300:30286288,30284302:30286506,30284304:30286351,30284305:30286463,30284307:30286325,30284309:30286250,30284311:30286137,30284313:30286181,30284317:30286389,30284319:30285986,30284322:30286213,30284325:30286429,30284328:30286062,30284331:30286108,30284334:30285812,30286525:30286583,30286649:30286721,30295932:30296624,30295933:30297844,30295934:30296982,30295935:30297243,30295937:30297093,30295939:30297311,30295941:30297125,30295943:30297442,30295945:30297394,30295947:30297012,30295949:30297060,30295951:30297356,30295953:30297179,30295955:30297178,30295957:30297277,30295959:30296907,30295961:30296804,30295964:30296834,30295966:30296937,30295968:30296772,30295970:30297490,30297482:30297536,30297610:30297719,30298011:30298191,30298012:30298063,30298267:30298326,30298532:30298647,30298533:30298606,30298794:30299005,30298795:30299031,30299538:30299693,30300196:30300349,30300197:30300434,30300478:3030077', 'assoc_mat': '30284291:carton:4230:30284588,30284292:carton:4230:30284535,30284293:carton:4230:30285183,30284294:carton:4230:30288146,30284296:carton:4230:30285743,30284298:carton:4230:30288101,30284300:carton:4230:30286288,30284302:carton:4230:30286506,30284304:carton:4230:30286351,30284305:carton:4230:30286463,30284307:carton:4230:30286325,30284309:carton:4230:30286250,30284311:carton:4230:30286137,30284313:carton:4230:30286181,30284317:carton:4230:30286389,30284319:carton:4230:30285986,30284322:carton:4230:30286213,30284325:carton:4230:30286429,30284328:carton:4230:30286062,30284331:carton:4230:30286108,30284334:carton:4230:30285812,30286525:carton:4230:30286583,30286649:carton:4230:30286721,30295932:carton:4230:30296624,30295933:carton:4230:30297844,30295934:carton:4230:30296982,30295935:carton:4230:30297243,30295937:carton:4230:30297093,30295939:carton:4230:30297311,30295941:carton:4230:30297125,30295943:carton:4230:30297442,30295945:carton:4230:30297394,30295947:carton:4230:30297012,30295949:carton:4230:30297060,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013649976755066412, 'nb_photo': 1821, 'list_port_cont': '30284530,30284572,30285171,30285737,30285994,30286058,30286097,30286134,30286178,30286202,30286281,30286315,30286330,30286428,30286462,30286495,30296910,30296935,30296978,30297024,30297051,30297081,30297133,30297155,30297230,30297269,30297308,30297352,30297403,30297440,30297492,30297530,30297724,30297839,30298188,30298602,30298630,30299008,30299040,30299682,30300350,30300429,30300774,30300988,30301437,30301637,30301912,30302005,30302586,30303180,30303224,30303769,30304133,30312328,30312357,30313122,30313216,30313273,30313304,30313338,30313368,30313388,30313452,30313527,30313543,30313588,30313624,30313673,30313675,30313743,30313768,30313857,30313985,30314074,30314112,30323230,30323388,30323527,30324121,30324387,30324654,30324714,30324761,30324856,30325096,30325119,30325184,30325204,30325241,30325291,30325472,30325502,30325632,30325741,30325864,30331240,30331271,30331348,30331386,30331417,30331466,30331487,30331540,30331556,30331607,30331628,30331671,30331718,30331758,30331783,30331827,30331860,30332114,3033224', 'assoc_port': '30284291:30284572,30284292:30284530,30284293:30285171,30284296:30285737,30284300:30286281,30284302:30286495,30284304:30286330,30284305:30286462,30284307:30286315,30284311:30286134,30284313:30286178,30284319:30285994,30284322:30286202,30284325:30286428,30284328:30286058,30284331:30286097,30295933:30297839,30295934:30296978,30295935:30297230,30295937:30297081,30295939:30297308,30295941:30297133,30295943:30297440,30295945:30297403,30295947:30297024,30295949:30297051,30295951:30297352,30295955:30297155,30295957:30297269,30295959:30296910,30295966:30296935,30295970:30297492,30297482:30297530,30297610:30297724,30298011:30298188,30298532:30298630,30298533:30298602,30298794:30299008,30298795:30299040,30299538:30299682,30300196:30300350,30300197:30300429,30300478:30300774,30300898:30300988,30301349:30301437,30301350:30301637,30301766:30301912,30301951:30302005,30302447:30302586,30303081:30303224,30303084:30303180,30303709:30303769,30303875:30304133,30312229:30314112,30312230:30314074,30312231:30313543,30312232:3031367', 'assoc_mat': '30284291:metal:4230:30284572,30284292:metal:4230:30284530,30284293:metal:4230:30285171,30284296:metal:4230:30285737,30284300:metal:4230:30286281,30284302:metal:4230:30286495,30284304:metal:4230:30286330,30284305:metal:4230:30286462,30284307:metal:4230:30286315,30284311:metal:4230:30286134,30284313:metal:4230:30286178,30284319:metal:4230:30285994,30284322:metal:4230:30286202,30284325:metal:4230:30286428,30284328:metal:4230:30286058,30284331:metal:4230:30286097,30295933:metal:4230:30297839,30295934:metal:4230:30296978,30295935:metal:4230:30297230,30295937:metal:4230:30297081,30295939:metal:4230:30297308,30295941:metal:4230:30297133,30295943:metal:4230:30297440,30295945:metal:4230:30297403,30295947:metal:4230:30297024,30295949:metal:4230:30297051,30295951:metal:4230:30297352,30295955:metal:4230:30297155,30295957:metal:4230:30297269,30295959:metal:4230:30296910,30295966:metal:4230:30296935,30295970:metal:4230:30297492,30297482:metal:4230:30297530,30297610:metal:4230:30297724,30298011:metal:4230:30298188,30298532:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19097639573851732, 'nb_photo': 408128, 'list_port_cont': '30284528,30284583,30285185,30285736,30285810,30286000,30286065,30286100,30286143,30286180,30286211,30286246,30286282,30286321,30286343,30286393,30286424,30286466,30286500,30286580,30286722,30288107,30288148,30296615,30296761,30296799,30296840,30296915,30296947,30296977,30297017,30297053,30297084,30297121,30297174,30297185,30297229,30297266,30297312,30297347,30297399,30297431,30297497,30297535,30297714,30297841,30298068,30298198,30298333,30298598,30298640,30299002,30299039,30299694,30300356,30300426,30300770,30301003,30301442,30301640,30301899,30302014,30302589,30303190,30303238,30303779,30304140,30304529,30305478,30306249,30312329,30312363,30313124,30313197,30313212,30313264,30313305,30313347,30313380,30313396,30313443,30313481,30313525,30313542,30313584,30313629,30313667,30313692,30313741,30313780,30313855,30313998,30314067,30314115,30323235,30323391,30323537,30324131,30324402,30324470,30324652,30324713,30324764,30324855,30325108,30325124,30325177,30325219,30325254,30325284,30325469,30325506,30325533,3032562', 'assoc_port': '30284291:30284583,30284292:30284528,30284293:30285185,30284294:30288148,30284296:30285736,30284298:30288107,30284300:30286282,30284302:30286500,30284304:30286343,30284305:30286466,30284307:30286321,30284309:30286246,30284311:30286143,30284313:30286180,30284317:30286393,30284319:30286000,30284322:30286211,30284325:30286424,30284328:30286065,30284331:30286100,30284334:30285810,30286525:30286580,30286649:30286722,30295932:30296615,30295933:30297841,30295934:30296977,30295935:30297229,30295937:30297084,30295939:30297312,30295941:30297121,30295943:30297431,30295945:30297399,30295947:30297017,30295949:30297053,30295951:30297347,30295953:30297185,30295955:30297174,30295957:30297266,30295959:30296915,30295961:30296799,30295964:30296840,30295966:30296947,30295968:30296761,30295970:30297497,30297482:30297535,30297610:30297714,30298011:30298198,30298012:30298068,30298267:30298333,30298532:30298640,30298533:30298598,30298794:30299002,30298795:30299039,30299538:30299694,30300196:30300356,30300197:30300426,30300478:3030077', 'assoc_mat': '30284291:papier:4230:30284583,30284292:papier:4230:30284528,30284293:papier:4230:30285185,30284294:papier:4230:30288148,30284296:papier:4230:30285736,30284298:papier:4230:30288107,30284300:papier:4230:30286282,30284302:papier:4230:30286500,30284304:papier:4230:30286343,30284305:papier:4230:30286466,30284307:papier:4230:30286321,30284309:papier:4230:30286246,30284311:papier:4230:30286143,30284313:papier:4230:30286180,30284317:papier:4230:30286393,30284319:papier:4230:30286000,30284322:papier:4230:30286211,30284325:papier:4230:30286424,30284328:papier:4230:30286065,30284331:papier:4230:30286100,30284334:papier:4230:30285810,30286525:papier:4230:30286580,30286649:papier:4230:30286722,30295932:papier:4230:30296615,30295933:papier:4230:30297841,30295934:papier:4230:30296977,30295935:papier:4230:30297229,30295937:papier:4230:30297084,30295939:papier:4230:30297312,30295941:papier:4230:30297121,30295943:papier:4230:30297431,30295945:papier:4230:30297399,30295947:papier:4230:30297017,30295949:papier:4230:30297053,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004272826668510093, 'nb_photo': 2764, 'list_port_cont': '30284585,30285738,30286001,30286069,30286109,30286177,30286217,30286386,30286503,30286725,30288105,30288147,30296620,30296771,30296794,30296839,30296913,30296950,30297019,30297059,30297131,30297160,30297169,30297276,30297353,30297389,30297443,30297531,30298197,30298332,30298603,30298998,30299690,30300361,30300435,30300776,30301002,30301638,30301905,30302018,30303195,30303783,30304136,30305484,30306251,30312327,30312355,30313129,30313219,30313272,30313310,30313345,30313378,30313397,30313447,30313484,30313522,30313536,30313592,30313626,30313668,30313686,30313745,30313777,30313865,30313988,30314108,30323232,30323385,30324132,30324403,30324476,30324660,30324715,30324777,30324854,30325107,30325130,30325172,30325218,30325253,30325287,30325461,30325499,30325542,30325629,30325749,30325865,30331244,30331278,30331317,30331350,30331388,30331424,30331462,30331497,30331541,30331559,30331606,30331629,30331678,30331716,30331757,30331788,30331830,30331859,30332122,30332193,30332239,30332275,30332956,30338594,30338635,3033871', 'assoc_port': '30284291:30284585,30284294:30288147,30284296:30285738,30284298:30288105,30284302:30286503,30284313:30286177,30284317:30286386,30284319:30286001,30284322:30286217,30284328:30286069,30284331:30286109,30286649:30286725,30295932:30296620,30295941:30297131,30295943:30297443,30295945:30297389,30295947:30297019,30295949:30297059,30295951:30297353,30295953:30297169,30295955:30297160,30295957:30297276,30295959:30296913,30295961:30296794,30295964:30296839,30295966:30296950,30295968:30296771,30297482:30297531,30298011:30298197,30298267:30298332,30298533:30298603,30298794:30298998,30299538:30299690,30300196:30300361,30300197:30300435,30300478:30300776,30300898:30301002,30301350:30301638,30301766:30301905,30301951:30302018,30303084:30303195,30303709:30303783,30303875:30304136,30305353:30305484,30306197:30306251,30312229:30314108,30312231:30313536,30312232:30313668,30312233:30313484,30312234:30313522,30312235:30313686,30312237:30313310,30312238:30313447,30312239:30312355,30312241:30313777,30312244:30313626,30312247:3031359', 'assoc_mat': '30284291:pehd:4230:30284585,30284294:pehd:4230:30288147,30284296:pehd:4230:30285738,30284298:pehd:4230:30288105,30284302:pehd:4230:30286503,30284313:pehd:4230:30286177,30284317:pehd:4230:30286386,30284319:pehd:4230:30286001,30284322:pehd:4230:30286217,30284328:pehd:4230:30286069,30284331:pehd:4230:30286109,30286649:pehd:4230:30286725,30295932:pehd:4230:30296620,30295941:pehd:4230:30297131,30295943:pehd:4230:30297443,30295945:pehd:4230:30297389,30295947:pehd:4230:30297019,30295949:pehd:4230:30297059,30295951:pehd:4230:30297353,30295953:pehd:4230:30297169,30295955:pehd:4230:30297160,30295957:pehd:4230:30297276,30295959:pehd:4230:30296913,30295961:pehd:4230:30296794,30295964:pehd:4230:30296839,30295966:pehd:4230:30296950,30295968:pehd:4230:30296771,30297482:pehd:4230:30297531,30298011:pehd:4230:30298197,30298267:pehd:4230:30298332,30298533:pehd:4230:30298603,30298794:pehd:4230:30298998,30299538:pehd:4230:30299690,30300196:pehd:4230:30300361,30300197:pehd:4230:30300435,30300478:pehd:4230:30300776,30300898:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014357230055985624, 'nb_photo': 25104, 'list_port_cont': '30284532,30284580,30285179,30285744,30285783,30285999,30286073,30286105,30286145,30286173,30286214,30286241,30286280,30286324,30286349,30286392,30286423,30286464,30286499,30286582,30286723,30288109,30288138,30296623,30296765,30296801,30296843,30296905,30296944,30296983,30297023,30297056,30297092,30297130,30297156,30297187,30297239,30297275,30297313,30297357,30297397,30297441,30297494,30297539,30297722,30297842,30298061,30298194,30298321,30298605,30298645,30299007,30299036,30299680,30300360,30300424,30300783,30300997,30301440,30301643,30301908,30302015,30302593,30303193,30303236,30303775,30304127,30304521,30305481,30306247,30312326,30312366,30313126,30313200,30313215,30313270,30313307,30313340,30313379,30313399,30313455,30313486,30313521,30313545,30313600,30313633,30313664,30313684,30313746,30313779,30313856,30313996,30314080,30314114,30323233,30323390,30323536,30324123,30324397,30324469,30324651,30324709,30324767,30324852,30325111,30325123,30325179,30325215,30325257,30325294,30325468,30325508,30325541,3032563', 'assoc_port': '30284291:30284580,30284292:30284532,30284293:30285179,30284294:30288138,30284296:30285744,30284298:30288109,30284300:30286280,30284302:30286499,30284304:30286349,30284305:30286464,30284307:30286324,30284309:30286241,30284311:30286145,30284313:30286173,30284317:30286392,30284319:30285999,30284322:30286214,30284325:30286423,30284328:30286073,30284331:30286105,30284334:30285783,30286525:30286582,30286649:30286723,30295932:30296623,30295933:30297842,30295934:30296983,30295935:30297239,30295937:30297092,30295939:30297313,30295941:30297130,30295943:30297441,30295945:30297397,30295947:30297023,30295949:30297056,30295951:30297357,30295953:30297187,30295955:30297156,30295957:30297275,30295959:30296905,30295961:30296801,30295964:30296843,30295966:30296944,30295968:30296765,30295970:30297494,30297482:30297539,30297610:30297722,30298011:30298194,30298012:30298061,30298267:30298321,30298532:30298645,30298533:30298605,30298794:30299007,30298795:30299036,30299538:30299680,30300196:30300360,30300197:30300424,30300478:3030078', 'assoc_mat': '30284291:pet_clair:4230:30284580,30284292:pet_clair:4230:30284532,30284293:pet_clair:4230:30285179,30284294:pet_clair:4230:30288138,30284296:pet_clair:4230:30285744,30284298:pet_clair:4230:30288109,30284300:pet_clair:4230:30286280,30284302:pet_clair:4230:30286499,30284304:pet_clair:4230:30286349,30284305:pet_clair:4230:30286464,30284307:pet_clair:4230:30286324,30284309:pet_clair:4230:30286241,30284311:pet_clair:4230:30286145,30284313:pet_clair:4230:30286173,30284317:pet_clair:4230:30286392,30284319:pet_clair:4230:30285999,30284322:pet_clair:4230:30286214,30284325:pet_clair:4230:30286423,30284328:pet_clair:4230:30286073,30284331:pet_clair:4230:30286105,30284334:pet_clair:4230:30285783,30286525:pet_clair:4230:30286582,30286649:pet_clair:4230:30286723,30295932:pet_clair:4230:30296623,30295933:pet_clair:4230:30297842,30295934:pet_clair:4230:30296983,30295935:pet_clair:4230:30297239,30295937:pet_clair:4230:30297092,30295939:pet_clair:4230:30297313,30295941:pet_clair:4230:30297130,30295943:pet_clair:4230:30297441,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003017221730703456, 'nb_photo': 1242, 'list_port_cont': '30284589,30285740,30286141,30286239,30286284,30286319,30286339,30286469,30286502,30286713,30288103,30288145,30296842,30296911,30296952,30297020,30297057,30297090,30297171,30297180,30297240,30297268,30297351,30297528,30298644,30298999,30299041,30299695,30300358,30300432,30300782,30301004,30301903,30302019,30303197,30303776,30304137,30304530,30306254,30312319,30312350,30313344,30313371,30313390,30313448,30313491,30313526,30313589,30313637,30313659,30313690,30313738,30313782,30313863,30313984,30314077,30323237,30323533,30324391,30324472,30324653,30324711,30324778,30324851,30325103,30325181,30325209,30325467,30325504,30325547,30325643,30325755,30325854,30331238,30331281,30331321,30331356,30331382,30331413,30331467,30331498,30331551,30331613,30331627,30331683,30331720,30331753,30331794,30331829,30331864,30332124,30332235,30332273,30332968,30338596,30338642,30338710,30338743,30338774,30338820,30338840,30338887,30338930,30338966,30338982,30339038,30339069,30339102,30339146,30339186,30339219,30339259,30339291,3033932', 'assoc_port': '30284291:30284589,30284294:30288145,30284296:30285740,30284298:30288103,30284300:30286284,30284302:30286502,30284304:30286339,30284305:30286469,30284307:30286319,30284309:30286239,30284311:30286141,30286649:30286713,30295935:30297240,30295937:30297090,30295947:30297020,30295949:30297057,30295951:30297351,30295953:30297171,30295955:30297180,30295957:30297268,30295959:30296911,30295964:30296842,30295966:30296952,30297482:30297528,30298532:30298644,30298794:30298999,30298795:30299041,30299538:30299695,30300196:30300358,30300197:30300432,30300478:30300782,30300898:30301004,30301766:30301903,30301951:30302019,30303084:30303197,30303709:30303776,30303875:30304137,30304496:30304530,30306197:30306254,30312230:30314077,30312232:30313659,30312233:30313491,30312234:30313526,30312235:30313690,30312238:30313448,30312239:30312350,30312241:30313782,30312244:30313637,30312247:30313589,30312249:30313738,30312253:30313344,30312255:30313371,30312259:30313390,30312263:30312319,30313809:30313863,30313938:30313984,30323084:3032323', 'assoc_mat': '30284291:pet_fonce:4230:30284589,30284294:pet_fonce:4230:30288145,30284296:pet_fonce:4230:30285740,30284298:pet_fonce:4230:30288103,30284300:pet_fonce:4230:30286284,30284302:pet_fonce:4230:30286502,30284304:pet_fonce:4230:30286339,30284305:pet_fonce:4230:30286469,30284307:pet_fonce:4230:30286319,30284309:pet_fonce:4230:30286239,30284311:pet_fonce:4230:30286141,30286649:pet_fonce:4230:30286713,30295935:pet_fonce:4230:30297240,30295937:pet_fonce:4230:30297090,30295947:pet_fonce:4230:30297020,30295949:pet_fonce:4230:30297057,30295951:pet_fonce:4230:30297351,30295953:pet_fonce:4230:30297171,30295955:pet_fonce:4230:30297180,30295957:pet_fonce:4230:30297268,30295959:pet_fonce:4230:30296911,30295964:pet_fonce:4230:30296842,30295966:pet_fonce:4230:30296952,30297482:pet_fonce:4230:30297528,30298532:pet_fonce:4230:30298644,30298794:pet_fonce:4230:30298999,30298795:pet_fonce:4230:30299041,30299538:pet_fonce:4230:30299695,30300196:pet_fonce:4230:30300358,30300197:pet_fonce:4230:30300432,30300478:pet_fonce:4230:30300782,3'}), 'main_stat': {'nb_photos': 1868}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30496529,30496530,30496531,30496532,30496533,30496534,30496535?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-02', 0.7448433745234064),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1868,),), 'unwanted_material_monthly_percentage': ((0.7448433745234064,),), 'material_repartition': (('incineration', 1842),), 'material_dict': {'incineration': 1842}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2026, 2, 1), 0.820896807506365, 3), (datetime.date(2026, 2, 2), 0.7919911396737338, 1), (datetime.date(2026, 2, 3), 0.7669830149879394, 3), (datetime.date(2026, 2, 4), 0.72148130324224, 3), (datetime.date(2026, 2, 5), 0.6760849216044916, 2), (datetime.date(2026, 2, 6), 0.66012374245399, 2), (datetime.date(2026, 2, 7), 0.6749287533236649, 2), (datetime.date(2026, 2, 8), 0.797892244630382, 2), (datetime.date(2026, 2, 9), 0.7685056972357455, 3), (datetime.date(2026, 2, 10), 0.7701272413535374, 3), (datetime.date(2026, 2, 11), 0.7078305900710249, 3), (datetime.date(2026, 2, 12), 0.6892172054546571, 2), (datetime.date(2026, 2, 13), 0.6811879023107683, 2), (datetime.date(2026, 2, 14), 0.7310736773657674, 3), (datetime.date(2026, 2, 15), 0.7648213252433053, 4), (datetime.date(2026, 2, 16), 0.7937180191626504, 4), (datetime.date(2026, 2, 17), 0.7435147698083808, 4), (datetime.date(2026, 2, 18), 0.7316778438489536, 4), (datetime.date(2026, 2, 19), 0.727512707061028, 3), (datetime.date(2026, 2, 20), 0.6901205314207042, 2), (datetime.date(2026, 2, 21), 0.7478553637884494, 3), (datetime.date(2026, 2, 22), 0.860136047353649, 2), (datetime.date(2026, 2, 23), 0.7890567627612781, 2), (datetime.date(2026, 2, 24), 0.7806351433101089, 1), (datetime.date(2026, 2, 25), 0.7700824159675639, 2), (datetime.date(2026, 2, 26), 0.7400846141805941, 2), (datetime.date(2026, 2, 27), 0.7089302625673601, 3), (datetime.date(2026, 2, 28), 0.7089739621299249, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2026, 2, 1), 0.820896807506365, 3), (datetime.date(2026, 2, 2), 0.7919911396737338, 1), (datetime.date(2026, 2, 3), 0.7669830149879394, 3), (datetime.date(2026, 2, 4), 0.72148130324224, 3), (datetime.date(2026, 2, 5), 0.6760849216044916, 2), (datetime.date(2026, 2, 6), 0.66012374245399, 2), (datetime.date(2026, 2, 7), 0.6749287533236649, 2), (datetime.date(2026, 2, 8), 0.797892244630382, 2), (datetime.date(2026, 2, 9), 0.7685056972357455, 3), (datetime.date(2026, 2, 10), 0.7701272413535374, 3), (datetime.date(2026, 2, 11), 0.7078305900710249, 3), (datetime.date(2026, 2, 12), 0.6892172054546571, 2), (datetime.date(2026, 2, 13), 0.6811879023107683, 2), (datetime.date(2026, 2, 14), 0.7310736773657674, 3), (datetime.date(2026, 2, 15), 0.7648213252433053, 4), (datetime.date(2026, 2, 16), 0.7937180191626504, 4), (datetime.date(2026, 2, 17), 0.7435147698083808, 4), (datetime.date(2026, 2, 18), 0.7316778438489536, 4), (datetime.date(2026, 2, 19), 0.727512707061028, 3), (datetime.date(2026, 2, 20), 0.6901205314207042, 2), (datetime.date(2026, 2, 21), 0.7478553637884494, 3), (datetime.date(2026, 2, 22), 0.860136047353649, 2), (datetime.date(2026, 2, 23), 0.7890567627612781, 2), (datetime.date(2026, 2, 24), 0.7806351433101089, 1), (datetime.date(2026, 2, 25), 0.7700824159675639, 2), (datetime.date(2026, 2, 26), 0.7400846141805941, 2), (datetime.date(2026, 2, 27), 0.7089302625673601, 3), (datetime.date(2026, 2, 28), 0.7089739621299249, 3))}, 'quality_array': [['-7.959627930258787', '01022026'], ['-7.685264142047652', '02022026'], ['-7.908637035079997', '03022026'], ['-8.181365422198107', '04022026'], ['-8.201260764578098', '05022026'], ['-8.301339020877803', '06022026'], ['-8.33153751904309', '07022026'], ['-8.146116051288466', '08022026'], ['-7.790577195335818', '09022026'], ['-7.360781034156939', '10022026'], ['-8.027722792208735', '11022026'], ['-8.189942085340121', '12022026'], ['-8.391175738866727', '13022026'], ['-8.410311653196581', '14022026'], ['-8.147287611106725', '15022026'], ['-7.782494749553707', '16022026'], ['-7.866669741646915', '17022026'], ['-7.956927352280359', '18022026'], ['-8.061111966957197', '19022026'], ['-8.067936990325519', '20022026'], ['-7.88290361452058', '21022026'], ['-7.750333184943034', '22022026'], ['-7.483863837606115', '23022026'], ['-7.52005165367697', '24022026'], ['-7.57311935313761', '25022026'], ['-7.810235102394644', '26022026'], ['-8.20480652012568', '27022026'], ['-8.111478891148531', '28022026']], 'number_of_batch': ((656,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.018024219435296838, 'nb_photo': 21747, 'list_port_cont': '30284522,30284586,30285186,30285731,30285814,30285997,30286063,30286103,30286138,30286171,30286200,30286247,30286286,30286310,30286329,30286394,30286425,30286455,30286501,30286570,30286716,30288112,30288143,30296612,30296755,30296808,30296844,30296899,30296939,30296987,30297022,30297048,30297096,30297122,30297157,30297164,30297237,30297270,30297298,30297354,30297400,30297437,30297503,30297533,30297709,30297840,30298059,30298199,30298325,30298610,30298631,30298997,30299033,30299689,30300359,30300428,30300766,30300996,30301444,30301633,30301913,30302012,30302583,30303188,30303231,30303782,30304134,30304532,30305477,30306239,30312313,30312359,30313123,30313186,30313205,30313263,30313301,30313343,30313381,30313395,30313451,30313477,30313510,30313539,30313591,30313627,30313674,30313689,30313732,30313772,30313860,30313995,30314066,30314100,30323236,30323392,30323538,30324120,30324399,30324474,30324658,30324718,30324768,30324857,30325110,30325127,30325178,30325221,30325246,30325286,30325458,30325501,30325546,3032564', 'assoc_port': '30284291:30284586,30284292:30284522,30284293:30285186,30284294:30288143,30284296:30285731,30284298:30288112,30284300:30286286,30284302:30286501,30284304:30286329,30284305:30286455,30284307:30286310,30284309:30286247,30284311:30286138,30284313:30286171,30284317:30286394,30284319:30285997,30284322:30286200,30284325:30286425,30284328:30286063,30284331:30286103,30284334:30285814,30286525:30286570,30286649:30286716,30295932:30296612,30295933:30297840,30295934:30296987,30295935:30297237,30295937:30297096,30295939:30297298,30295941:30297122,30295943:30297437,30295945:30297400,30295947:30297022,30295949:30297048,30295951:30297354,30295953:30297157,30295955:30297164,30295957:30297270,30295959:30296899,30295961:30296808,30295964:30296844,30295966:30296939,30295968:30296755,30295970:30297503,30297482:30297533,30297610:30297709,30298011:30298199,30298012:30298059,30298267:30298325,30298532:30298631,30298533:30298610,30298794:30298997,30298795:30299033,30299538:30299689,30300196:30300359,30300197:30300428,30300478:3030076', 'assoc_mat': '30284291:autre:4230:30284586,30284292:autre:4230:30284522,30284293:autre:4230:30285186,30284294:autre:4230:30288143,30284296:autre:4230:30285731,30284298:autre:4230:30288112,30284300:autre:4230:30286286,30284302:autre:4230:30286501,30284304:autre:4230:30286329,30284305:autre:4230:30286455,30284307:autre:4230:30286310,30284309:autre:4230:30286247,30284311:autre:4230:30286138,30284313:autre:4230:30286171,30284317:autre:4230:30286394,30284319:autre:4230:30285997,30284322:autre:4230:30286200,30284325:autre:4230:30286425,30284328:autre:4230:30286063,30284331:autre:4230:30286103,30284334:autre:4230:30285814,30286525:autre:4230:30286570,30286649:autre:4230:30286716,30295932:autre:4230:30296612,30295933:autre:4230:30297840,30295934:autre:4230:30296987,30295935:autre:4230:30297237,30295937:autre:4230:30297096,30295939:autre:4230:30297298,30295941:autre:4230:30297122,30295943:autre:4230:30297437,30295945:autre:4230:30297400,30295947:autre:4230:30297022,30295949:autre:4230:30297048,30295951:autre:4230:30297354,30295953:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04890912189024747, 'nb_photo': 90286, 'list_port_cont': '30284535,30284588,30285183,30285743,30285812,30285986,30286062,30286108,30286137,30286181,30286213,30286250,30286288,30286325,30286351,30286389,30286429,30286463,30286506,30286583,30286721,30288101,30288146,30296624,30296772,30296804,30296834,30296907,30296937,30296982,30297012,30297060,30297093,30297125,30297178,30297179,30297243,30297277,30297311,30297356,30297394,30297442,30297490,30297536,30297719,30297844,30298063,30298191,30298326,30298606,30298647,30299005,30299031,30299693,30300349,30300434,30300779,30300998,30301434,30301628,30301910,30302020,30302591,30303198,30303227,30303781,30304126,30304528,30305480,30306252,30312321,30312362,30313118,30313202,30313214,30313269,30313311,30313339,30313375,30313400,30313450,30313489,30313524,30313535,30313597,30313628,30313672,30313691,30313737,30313776,30313866,30313989,30314070,30314102,30323231,30323378,30323532,30324124,30324404,30324477,30324649,30324707,30324774,30324850,30325112,30325125,30325182,30325220,30325256,30325293,30325473,30325510,30325548,3032564', 'assoc_port': '30284291:30284588,30284292:30284535,30284293:30285183,30284294:30288146,30284296:30285743,30284298:30288101,30284300:30286288,30284302:30286506,30284304:30286351,30284305:30286463,30284307:30286325,30284309:30286250,30284311:30286137,30284313:30286181,30284317:30286389,30284319:30285986,30284322:30286213,30284325:30286429,30284328:30286062,30284331:30286108,30284334:30285812,30286525:30286583,30286649:30286721,30295932:30296624,30295933:30297844,30295934:30296982,30295935:30297243,30295937:30297093,30295939:30297311,30295941:30297125,30295943:30297442,30295945:30297394,30295947:30297012,30295949:30297060,30295951:30297356,30295953:30297179,30295955:30297178,30295957:30297277,30295959:30296907,30295961:30296804,30295964:30296834,30295966:30296937,30295968:30296772,30295970:30297490,30297482:30297536,30297610:30297719,30298011:30298191,30298012:30298063,30298267:30298326,30298532:30298647,30298533:30298606,30298794:30299005,30298795:30299031,30299538:30299693,30300196:30300349,30300197:30300434,30300478:3030077', 'assoc_mat': '30284291:carton:4230:30284588,30284292:carton:4230:30284535,30284293:carton:4230:30285183,30284294:carton:4230:30288146,30284296:carton:4230:30285743,30284298:carton:4230:30288101,30284300:carton:4230:30286288,30284302:carton:4230:30286506,30284304:carton:4230:30286351,30284305:carton:4230:30286463,30284307:carton:4230:30286325,30284309:carton:4230:30286250,30284311:carton:4230:30286137,30284313:carton:4230:30286181,30284317:carton:4230:30286389,30284319:carton:4230:30285986,30284322:carton:4230:30286213,30284325:carton:4230:30286429,30284328:carton:4230:30286062,30284331:carton:4230:30286108,30284334:carton:4230:30285812,30286525:carton:4230:30286583,30286649:carton:4230:30286721,30295932:carton:4230:30296624,30295933:carton:4230:30297844,30295934:carton:4230:30296982,30295935:carton:4230:30297243,30295937:carton:4230:30297093,30295939:carton:4230:30297311,30295941:carton:4230:30297125,30295943:carton:4230:30297442,30295945:carton:4230:30297394,30295947:carton:4230:30297012,30295949:carton:4230:30297060,3029'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0013649976755066412, 'nb_photo': 1821, 'list_port_cont': '30284530,30284572,30285171,30285737,30285994,30286058,30286097,30286134,30286178,30286202,30286281,30286315,30286330,30286428,30286462,30286495,30296910,30296935,30296978,30297024,30297051,30297081,30297133,30297155,30297230,30297269,30297308,30297352,30297403,30297440,30297492,30297530,30297724,30297839,30298188,30298602,30298630,30299008,30299040,30299682,30300350,30300429,30300774,30300988,30301437,30301637,30301912,30302005,30302586,30303180,30303224,30303769,30304133,30312328,30312357,30313122,30313216,30313273,30313304,30313338,30313368,30313388,30313452,30313527,30313543,30313588,30313624,30313673,30313675,30313743,30313768,30313857,30313985,30314074,30314112,30323230,30323388,30323527,30324121,30324387,30324654,30324714,30324761,30324856,30325096,30325119,30325184,30325204,30325241,30325291,30325472,30325502,30325632,30325741,30325864,30331240,30331271,30331348,30331386,30331417,30331466,30331487,30331540,30331556,30331607,30331628,30331671,30331718,30331758,30331783,30331827,30331860,30332114,3033224', 'assoc_port': '30284291:30284572,30284292:30284530,30284293:30285171,30284296:30285737,30284300:30286281,30284302:30286495,30284304:30286330,30284305:30286462,30284307:30286315,30284311:30286134,30284313:30286178,30284319:30285994,30284322:30286202,30284325:30286428,30284328:30286058,30284331:30286097,30295933:30297839,30295934:30296978,30295935:30297230,30295937:30297081,30295939:30297308,30295941:30297133,30295943:30297440,30295945:30297403,30295947:30297024,30295949:30297051,30295951:30297352,30295955:30297155,30295957:30297269,30295959:30296910,30295966:30296935,30295970:30297492,30297482:30297530,30297610:30297724,30298011:30298188,30298532:30298630,30298533:30298602,30298794:30299008,30298795:30299040,30299538:30299682,30300196:30300350,30300197:30300429,30300478:30300774,30300898:30300988,30301349:30301437,30301350:30301637,30301766:30301912,30301951:30302005,30302447:30302586,30303081:30303224,30303084:30303180,30303709:30303769,30303875:30304133,30312229:30314112,30312230:30314074,30312231:30313543,30312232:3031367', 'assoc_mat': '30284291:metal:4230:30284572,30284292:metal:4230:30284530,30284293:metal:4230:30285171,30284296:metal:4230:30285737,30284300:metal:4230:30286281,30284302:metal:4230:30286495,30284304:metal:4230:30286330,30284305:metal:4230:30286462,30284307:metal:4230:30286315,30284311:metal:4230:30286134,30284313:metal:4230:30286178,30284319:metal:4230:30285994,30284322:metal:4230:30286202,30284325:metal:4230:30286428,30284328:metal:4230:30286058,30284331:metal:4230:30286097,30295933:metal:4230:30297839,30295934:metal:4230:30296978,30295935:metal:4230:30297230,30295937:metal:4230:30297081,30295939:metal:4230:30297308,30295941:metal:4230:30297133,30295943:metal:4230:30297440,30295945:metal:4230:30297403,30295947:metal:4230:30297024,30295949:metal:4230:30297051,30295951:metal:4230:30297352,30295955:metal:4230:30297155,30295957:metal:4230:30297269,30295959:metal:4230:30296910,30295966:metal:4230:30296935,30295970:metal:4230:30297492,30297482:metal:4230:30297530,30297610:metal:4230:30297724,30298011:metal:4230:30298188,30298532:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.19097639573851732, 'nb_photo': 408128, 'list_port_cont': '30284528,30284583,30285185,30285736,30285810,30286000,30286065,30286100,30286143,30286180,30286211,30286246,30286282,30286321,30286343,30286393,30286424,30286466,30286500,30286580,30286722,30288107,30288148,30296615,30296761,30296799,30296840,30296915,30296947,30296977,30297017,30297053,30297084,30297121,30297174,30297185,30297229,30297266,30297312,30297347,30297399,30297431,30297497,30297535,30297714,30297841,30298068,30298198,30298333,30298598,30298640,30299002,30299039,30299694,30300356,30300426,30300770,30301003,30301442,30301640,30301899,30302014,30302589,30303190,30303238,30303779,30304140,30304529,30305478,30306249,30312329,30312363,30313124,30313197,30313212,30313264,30313305,30313347,30313380,30313396,30313443,30313481,30313525,30313542,30313584,30313629,30313667,30313692,30313741,30313780,30313855,30313998,30314067,30314115,30323235,30323391,30323537,30324131,30324402,30324470,30324652,30324713,30324764,30324855,30325108,30325124,30325177,30325219,30325254,30325284,30325469,30325506,30325533,3032562', 'assoc_port': '30284291:30284583,30284292:30284528,30284293:30285185,30284294:30288148,30284296:30285736,30284298:30288107,30284300:30286282,30284302:30286500,30284304:30286343,30284305:30286466,30284307:30286321,30284309:30286246,30284311:30286143,30284313:30286180,30284317:30286393,30284319:30286000,30284322:30286211,30284325:30286424,30284328:30286065,30284331:30286100,30284334:30285810,30286525:30286580,30286649:30286722,30295932:30296615,30295933:30297841,30295934:30296977,30295935:30297229,30295937:30297084,30295939:30297312,30295941:30297121,30295943:30297431,30295945:30297399,30295947:30297017,30295949:30297053,30295951:30297347,30295953:30297185,30295955:30297174,30295957:30297266,30295959:30296915,30295961:30296799,30295964:30296840,30295966:30296947,30295968:30296761,30295970:30297497,30297482:30297535,30297610:30297714,30298011:30298198,30298012:30298068,30298267:30298333,30298532:30298640,30298533:30298598,30298794:30299002,30298795:30299039,30299538:30299694,30300196:30300356,30300197:30300426,30300478:3030077', 'assoc_mat': '30284291:papier:4230:30284583,30284292:papier:4230:30284528,30284293:papier:4230:30285185,30284294:papier:4230:30288148,30284296:papier:4230:30285736,30284298:papier:4230:30288107,30284300:papier:4230:30286282,30284302:papier:4230:30286500,30284304:papier:4230:30286343,30284305:papier:4230:30286466,30284307:papier:4230:30286321,30284309:papier:4230:30286246,30284311:papier:4230:30286143,30284313:papier:4230:30286180,30284317:papier:4230:30286393,30284319:papier:4230:30286000,30284322:papier:4230:30286211,30284325:papier:4230:30286424,30284328:papier:4230:30286065,30284331:papier:4230:30286100,30284334:papier:4230:30285810,30286525:papier:4230:30286580,30286649:papier:4230:30286722,30295932:papier:4230:30296615,30295933:papier:4230:30297841,30295934:papier:4230:30296977,30295935:papier:4230:30297229,30295937:papier:4230:30297084,30295939:papier:4230:30297312,30295941:papier:4230:30297121,30295943:papier:4230:30297431,30295945:papier:4230:30297399,30295947:papier:4230:30297017,30295949:papier:4230:30297053,3029'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004272826668510093, 'nb_photo': 2764, 'list_port_cont': '30284585,30285738,30286001,30286069,30286109,30286177,30286217,30286386,30286503,30286725,30288105,30288147,30296620,30296771,30296794,30296839,30296913,30296950,30297019,30297059,30297131,30297160,30297169,30297276,30297353,30297389,30297443,30297531,30298197,30298332,30298603,30298998,30299690,30300361,30300435,30300776,30301002,30301638,30301905,30302018,30303195,30303783,30304136,30305484,30306251,30312327,30312355,30313129,30313219,30313272,30313310,30313345,30313378,30313397,30313447,30313484,30313522,30313536,30313592,30313626,30313668,30313686,30313745,30313777,30313865,30313988,30314108,30323232,30323385,30324132,30324403,30324476,30324660,30324715,30324777,30324854,30325107,30325130,30325172,30325218,30325253,30325287,30325461,30325499,30325542,30325629,30325749,30325865,30331244,30331278,30331317,30331350,30331388,30331424,30331462,30331497,30331541,30331559,30331606,30331629,30331678,30331716,30331757,30331788,30331830,30331859,30332122,30332193,30332239,30332275,30332956,30338594,30338635,3033871', 'assoc_port': '30284291:30284585,30284294:30288147,30284296:30285738,30284298:30288105,30284302:30286503,30284313:30286177,30284317:30286386,30284319:30286001,30284322:30286217,30284328:30286069,30284331:30286109,30286649:30286725,30295932:30296620,30295941:30297131,30295943:30297443,30295945:30297389,30295947:30297019,30295949:30297059,30295951:30297353,30295953:30297169,30295955:30297160,30295957:30297276,30295959:30296913,30295961:30296794,30295964:30296839,30295966:30296950,30295968:30296771,30297482:30297531,30298011:30298197,30298267:30298332,30298533:30298603,30298794:30298998,30299538:30299690,30300196:30300361,30300197:30300435,30300478:30300776,30300898:30301002,30301350:30301638,30301766:30301905,30301951:30302018,30303084:30303195,30303709:30303783,30303875:30304136,30305353:30305484,30306197:30306251,30312229:30314108,30312231:30313536,30312232:30313668,30312233:30313484,30312234:30313522,30312235:30313686,30312237:30313310,30312238:30313447,30312239:30312355,30312241:30313777,30312244:30313626,30312247:3031359', 'assoc_mat': '30284291:pehd:4230:30284585,30284294:pehd:4230:30288147,30284296:pehd:4230:30285738,30284298:pehd:4230:30288105,30284302:pehd:4230:30286503,30284313:pehd:4230:30286177,30284317:pehd:4230:30286386,30284319:pehd:4230:30286001,30284322:pehd:4230:30286217,30284328:pehd:4230:30286069,30284331:pehd:4230:30286109,30286649:pehd:4230:30286725,30295932:pehd:4230:30296620,30295941:pehd:4230:30297131,30295943:pehd:4230:30297443,30295945:pehd:4230:30297389,30295947:pehd:4230:30297019,30295949:pehd:4230:30297059,30295951:pehd:4230:30297353,30295953:pehd:4230:30297169,30295955:pehd:4230:30297160,30295957:pehd:4230:30297276,30295959:pehd:4230:30296913,30295961:pehd:4230:30296794,30295964:pehd:4230:30296839,30295966:pehd:4230:30296950,30295968:pehd:4230:30296771,30297482:pehd:4230:30297531,30298011:pehd:4230:30298197,30298267:pehd:4230:30298332,30298533:pehd:4230:30298603,30298794:pehd:4230:30298998,30299538:pehd:4230:30299690,30300196:pehd:4230:30300361,30300197:pehd:4230:30300435,30300478:pehd:4230:30300776,30300898:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.014357230055985624, 'nb_photo': 25104, 'list_port_cont': '30284532,30284580,30285179,30285744,30285783,30285999,30286073,30286105,30286145,30286173,30286214,30286241,30286280,30286324,30286349,30286392,30286423,30286464,30286499,30286582,30286723,30288109,30288138,30296623,30296765,30296801,30296843,30296905,30296944,30296983,30297023,30297056,30297092,30297130,30297156,30297187,30297239,30297275,30297313,30297357,30297397,30297441,30297494,30297539,30297722,30297842,30298061,30298194,30298321,30298605,30298645,30299007,30299036,30299680,30300360,30300424,30300783,30300997,30301440,30301643,30301908,30302015,30302593,30303193,30303236,30303775,30304127,30304521,30305481,30306247,30312326,30312366,30313126,30313200,30313215,30313270,30313307,30313340,30313379,30313399,30313455,30313486,30313521,30313545,30313600,30313633,30313664,30313684,30313746,30313779,30313856,30313996,30314080,30314114,30323233,30323390,30323536,30324123,30324397,30324469,30324651,30324709,30324767,30324852,30325111,30325123,30325179,30325215,30325257,30325294,30325468,30325508,30325541,3032563', 'assoc_port': '30284291:30284580,30284292:30284532,30284293:30285179,30284294:30288138,30284296:30285744,30284298:30288109,30284300:30286280,30284302:30286499,30284304:30286349,30284305:30286464,30284307:30286324,30284309:30286241,30284311:30286145,30284313:30286173,30284317:30286392,30284319:30285999,30284322:30286214,30284325:30286423,30284328:30286073,30284331:30286105,30284334:30285783,30286525:30286582,30286649:30286723,30295932:30296623,30295933:30297842,30295934:30296983,30295935:30297239,30295937:30297092,30295939:30297313,30295941:30297130,30295943:30297441,30295945:30297397,30295947:30297023,30295949:30297056,30295951:30297357,30295953:30297187,30295955:30297156,30295957:30297275,30295959:30296905,30295961:30296801,30295964:30296843,30295966:30296944,30295968:30296765,30295970:30297494,30297482:30297539,30297610:30297722,30298011:30298194,30298012:30298061,30298267:30298321,30298532:30298645,30298533:30298605,30298794:30299007,30298795:30299036,30299538:30299680,30300196:30300360,30300197:30300424,30300478:3030078', 'assoc_mat': '30284291:pet_clair:4230:30284580,30284292:pet_clair:4230:30284532,30284293:pet_clair:4230:30285179,30284294:pet_clair:4230:30288138,30284296:pet_clair:4230:30285744,30284298:pet_clair:4230:30288109,30284300:pet_clair:4230:30286280,30284302:pet_clair:4230:30286499,30284304:pet_clair:4230:30286349,30284305:pet_clair:4230:30286464,30284307:pet_clair:4230:30286324,30284309:pet_clair:4230:30286241,30284311:pet_clair:4230:30286145,30284313:pet_clair:4230:30286173,30284317:pet_clair:4230:30286392,30284319:pet_clair:4230:30285999,30284322:pet_clair:4230:30286214,30284325:pet_clair:4230:30286423,30284328:pet_clair:4230:30286073,30284331:pet_clair:4230:30286105,30284334:pet_clair:4230:30285783,30286525:pet_clair:4230:30286582,30286649:pet_clair:4230:30286723,30295932:pet_clair:4230:30296623,30295933:pet_clair:4230:30297842,30295934:pet_clair:4230:30296983,30295935:pet_clair:4230:30297239,30295937:pet_clair:4230:30297092,30295939:pet_clair:4230:30297313,30295941:pet_clair:4230:30297130,30295943:pet_clair:4230:30297441,3'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003017221730703456, 'nb_photo': 1242, 'list_port_cont': '30284589,30285740,30286141,30286239,30286284,30286319,30286339,30286469,30286502,30286713,30288103,30288145,30296842,30296911,30296952,30297020,30297057,30297090,30297171,30297180,30297240,30297268,30297351,30297528,30298644,30298999,30299041,30299695,30300358,30300432,30300782,30301004,30301903,30302019,30303197,30303776,30304137,30304530,30306254,30312319,30312350,30313344,30313371,30313390,30313448,30313491,30313526,30313589,30313637,30313659,30313690,30313738,30313782,30313863,30313984,30314077,30323237,30323533,30324391,30324472,30324653,30324711,30324778,30324851,30325103,30325181,30325209,30325467,30325504,30325547,30325643,30325755,30325854,30331238,30331281,30331321,30331356,30331382,30331413,30331467,30331498,30331551,30331613,30331627,30331683,30331720,30331753,30331794,30331829,30331864,30332124,30332235,30332273,30332968,30338596,30338642,30338710,30338743,30338774,30338820,30338840,30338887,30338930,30338966,30338982,30339038,30339069,30339102,30339146,30339186,30339219,30339259,30339291,3033932', 'assoc_port': '30284291:30284589,30284294:30288145,30284296:30285740,30284298:30288103,30284300:30286284,30284302:30286502,30284304:30286339,30284305:30286469,30284307:30286319,30284309:30286239,30284311:30286141,30286649:30286713,30295935:30297240,30295937:30297090,30295947:30297020,30295949:30297057,30295951:30297351,30295953:30297171,30295955:30297180,30295957:30297268,30295959:30296911,30295964:30296842,30295966:30296952,30297482:30297528,30298532:30298644,30298794:30298999,30298795:30299041,30299538:30299695,30300196:30300358,30300197:30300432,30300478:30300782,30300898:30301004,30301766:30301903,30301951:30302019,30303084:30303197,30303709:30303776,30303875:30304137,30304496:30304530,30306197:30306254,30312230:30314077,30312232:30313659,30312233:30313491,30312234:30313526,30312235:30313690,30312238:30313448,30312239:30312350,30312241:30313782,30312244:30313637,30312247:30313589,30312249:30313738,30312253:30313344,30312255:30313371,30312259:30313390,30312263:30312319,30313809:30313863,30313938:30313984,30323084:3032323', 'assoc_mat': '30284291:pet_fonce:4230:30284589,30284294:pet_fonce:4230:30288145,30284296:pet_fonce:4230:30285740,30284298:pet_fonce:4230:30288103,30284300:pet_fonce:4230:30286284,30284302:pet_fonce:4230:30286502,30284304:pet_fonce:4230:30286339,30284305:pet_fonce:4230:30286469,30284307:pet_fonce:4230:30286319,30284309:pet_fonce:4230:30286239,30284311:pet_fonce:4230:30286141,30286649:pet_fonce:4230:30286713,30295935:pet_fonce:4230:30297240,30295937:pet_fonce:4230:30297090,30295947:pet_fonce:4230:30297020,30295949:pet_fonce:4230:30297057,30295951:pet_fonce:4230:30297351,30295953:pet_fonce:4230:30297171,30295955:pet_fonce:4230:30297180,30295957:pet_fonce:4230:30297268,30295959:pet_fonce:4230:30296911,30295964:pet_fonce:4230:30296842,30295966:pet_fonce:4230:30296952,30297482:pet_fonce:4230:30297528,30298532:pet_fonce:4230:30298644,30298794:pet_fonce:4230:30298999,30298795:pet_fonce:4230:30299041,30299538:pet_fonce:4230:30299695,30300196:pet_fonce:4230:30300358,30300197:pet_fonce:4230:30300432,30300478:pet_fonce:4230:30300782,3'}), 'main_stat': {'nb_photos': 1868}, 'velours_link': {'incineration': 'https://www.fotonower.com/velours/30496529,30496530,30496531,30496532,30496533,30496534,30496535?tags=autre,carton,metal,papier,pehd,pet_clair,pet_fonce'}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2026-02', 0.7448433745234064),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_02_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.8%', 21747], 'carton': ['carton', '4.89%', 90286], 'metal': ['metal', '0.14%', 1821], 'papier': ['papier', '19.1%', 408128], 'pehd': ['pehd', '0.43%', 2764], 'pet_clair': ['pet_clair', '1.44%', 25104], 'pet_fonce': ['pet_fonce', '0.3%', 1242]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_02_annee_2026.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.26user 2.61system 0:10.62elapsed 46%CPU (0avgtext+0avgdata 182612maxresident)k 304inputs+312outputs (2major+44394minor)pagefaults 0swaps