python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-09 _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 : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 09 mtr_id : dashboard_places : SCCU_cam8 date : 2025-09 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-09%') and created_at like '%2025-09%'))); nb_day : (0, 30) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 09 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 09 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%092025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-09-01 : dt_date_just_month_year : 2025-09-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-09-01" AND ded.date <= "2025-09-30" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} 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 (2220223,2227973,2235225,2312089,2312077,2312053,2312049,2312033,2312027,2311947,2312013,2311999,2311977,2311969,2315885,2323447,2331221,2335109,2335745) 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.01265614880699692, 'nb_photo': 10748, 'list_port_cont': '26389452,26390424,26391798,26394165,26395985,26397227,26399939,26402756,26405372,26407545,26409796,26412524,26414845,26417368,26417520,26417728,26417892,26418404,26418573,26418621,26418801,26419033,26419523,26419603,26420917,26421002,26421426,26421941,26422205,26423603,26425545,26428013,26429145,26431360,26436209,26438102,26438261,26439393,26442401,26443947,26445816,26448883,26451458,26453751,26456376,26458399,26461524,26464174,26484894,26486993,26488739,26498414,26501262,26501610,26505593,26505908,26506125,26506245,26506585,26506867,26507043,26507378,26507634,26507886,26508115,26508811,26511182,26511303,26511572,26511737,26616062,26616087,26616164,26616219,26616392,26616489,26616570,26616711,26616757,26616850,26617033,26617129,26617165,26617247,26617492,26617718,26617981,26618212,26620421,26620514,26620671,26620755,26620898,26621067,26621275,26621325,26621410,26621535,26622042,26622972,26623065,26623204,26623404,26623506,26623540,26623657,26623673,26623766,26623965,26776146,26776188,26776566,26776696,2677710', 'assoc_port': '26389113:26389452,26390335:26390424,26391604:26391798,26393807:26394165,26395705:26395985,26396894:26397227,26399738:26399939,26402608:26402756,26405244:26405372,26407311:26407545,26409666:26409796,26412120:26412524,26414629:26414845,26415980:26417368,26415983:26417520,26415986:26417728,26415989:26417892,26415992:26419523,26415996:26418404,26415998:26418621,26416001:26418801,26416004:26419033,26418179:26418573,26419550:26419603,26420873:26421002,26420876:26420917,26421382:26421426,26421878:26421941,26422165:26422205,26423462:26423603,26425265:26425545,26427890:26428013,26429044:26429145,26431300:26431360,26434089:26438102,26436099:26436209,26437930:26438261,26439058:26439393,26441208:26442401,26443654:26443947,26445592:26445816,26448569:26448883,26451136:26451458,26453314:26453751,26456055:26456376,26458279:26458399,26461208:26461524,26463698:26464174,26484792:26484894,26486923:26486993,26488637:26488739,26492756:26501610,26496949:26501262,26498270:26498414,26500782:26511303,26502793:26511572,26505116:2650559', 'assoc_mat': '26389113:autre:4230:26389452,26390335:autre:4230:26390424,26391604:autre:4230:26391798,26393807:autre:4230:26394165,26395705:autre:4230:26395985,26396894:autre:4230:26397227,26399738:autre:4230:26399939,26402608:autre:4230:26402756,26405244:autre:4230:26405372,26407311:autre:4230:26407545,26409666:autre:4230:26409796,26412120:autre:4230:26412524,26414629:autre:4230:26414845,26415980:autre:4230:26417368,26415983:autre:4230:26417520,26415986:autre:4230:26417728,26415989:autre:4230:26417892,26415992:autre:4230:26419523,26415996:autre:4230:26418404,26415998:autre:4230:26418621,26416001:autre:4230:26418801,26416004:autre:4230:26419033,26418179:autre:4230:26418573,26419550:autre:4230:26419603,26420873:autre:4230:26421002,26420876:autre:4230:26420917,26421382:autre:4230:26421426,26421878:autre:4230:26421941,26422165:autre:4230:26422205,26423462:autre:4230:26423603,26425265:autre:4230:26425545,26427890:autre:4230:26428013,26429044:autre:4230:26429145,26431300:autre:4230:26431360,26434089:autre:4230:26438102,26436099:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07063396962939078, 'nb_photo': 76753, 'list_port_cont': '26389460,26390426,26391788,26394174,26395991,26397232,26399940,26402761,26405379,26407557,26409791,26412528,26414844,26417361,26417514,26417735,26417905,26418409,26418575,26418620,26418794,26419042,26419525,26419616,26420908,26421005,26421422,26421943,26422206,26423608,26425548,26428019,26429144,26431374,26436210,26438107,26438267,26439391,26442399,26443956,26445829,26448896,26451461,26453758,26456374,26458398,26461541,26464182,26484889,26486996,26488733,26498410,26501261,26501619,26505597,26505914,26506141,26506252,26506595,26506878,26507039,26507367,26507647,26507885,26508121,26508807,26511184,26511306,26511584,26511741,26616056,26616100,26616168,26616225,26616403,26616485,26616571,26616725,26616769,26616856,26617030,26617133,26617170,26617250,26617490,26617727,26617997,26618214,26620423,26620508,26620681,26620768,26620899,26621071,26621278,26621316,26621415,26621536,26622043,26622962,26623080,26623202,26623393,26623504,26623547,26623645,26623668,26623770,26623959,26776155,26776193,26776577,26776693,2677710', 'assoc_port': '26389113:26389460,26390335:26390426,26391604:26391788,26393807:26394174,26395705:26395991,26396894:26397232,26399738:26399940,26402608:26402761,26405244:26405379,26407311:26407557,26409666:26409791,26412120:26412528,26414629:26414844,26415980:26417361,26415983:26417514,26415986:26417735,26415989:26417905,26415992:26419525,26415996:26418409,26415998:26418620,26416001:26418794,26416004:26419042,26418179:26418575,26419550:26419616,26420873:26421005,26420876:26420908,26421382:26421422,26421878:26421943,26422165:26422206,26423462:26423608,26425265:26425548,26427890:26428019,26429044:26429144,26431300:26431374,26434089:26438107,26436099:26436210,26437930:26438267,26439058:26439391,26441208:26442399,26443654:26443956,26445592:26445829,26448569:26448896,26451136:26451461,26453314:26453758,26456055:26456374,26458279:26458398,26461208:26461541,26463698:26464182,26484792:26484889,26486923:26486996,26488637:26488733,26492756:26501619,26496949:26501261,26498270:26498410,26500782:26511306,26502793:26511584,26505116:2650559', 'assoc_mat': '26389113:carton:4230:26389460,26390335:carton:4230:26390426,26391604:carton:4230:26391788,26393807:carton:4230:26394174,26395705:carton:4230:26395991,26396894:carton:4230:26397232,26399738:carton:4230:26399940,26402608:carton:4230:26402761,26405244:carton:4230:26405379,26407311:carton:4230:26407557,26409666:carton:4230:26409791,26412120:carton:4230:26412528,26414629:carton:4230:26414844,26415980:carton:4230:26417361,26415983:carton:4230:26417514,26415986:carton:4230:26417735,26415989:carton:4230:26417905,26415992:carton:4230:26419525,26415996:carton:4230:26418409,26415998:carton:4230:26418620,26416001:carton:4230:26418794,26416004:carton:4230:26419042,26418179:carton:4230:26418575,26419550:carton:4230:26419616,26420873:carton:4230:26421005,26420876:carton:4230:26420908,26421382:carton:4230:26421422,26421878:carton:4230:26421943,26422165:carton:4230:26422206,26423462:carton:4230:26423608,26425265:carton:4230:26425548,26427890:carton:4230:26428019,26429044:carton:4230:26429144,26431300:carton:4230:26431374,2643'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027974907033268014, 'nb_photo': 1417, 'list_port_cont': '26390425,26391791,26394170,26395992,26397226,26414831,26417355,26417523,26417730,26417908,26418401,26418626,26418803,26419032,26419517,26421000,26421418,26422199,26428012,26429135,26436206,26438264,26439379,26442386,26443951,26445828,26456371,26458394,26461529,26464184,26501254,26505586,26505916,26506131,26506243,26506873,26507042,26507374,26507640,26507888,26508810,26511186,26511579,26616051,26616093,26616391,26616487,26616574,26616719,26616761,26616845,26617031,26617135,26617181,26617259,26617475,26617715,26617973,26618215,26620518,26620769,26620903,26621063,26621282,26621315,26621409,26621545,26622047,26622959,26623069,26623501,26623536,26623640,26623663,26623767,26776151,26776201,26776572,26776684,26777097,26777606,26777695,26778520,26779648,26780715,26781267,26782886,26786646,26790997,26791018,26791511,26791665,26915879,26916054,26916531,26916790,26917058,26917361,26917519,26917644,26917902,26918600,26921506,26921798,26923305,26923799,26923972,26925904,26927845,26930202,26933327,26935851,26939679,2694114', 'assoc_port': '26390335:26390425,26391604:26391791,26393807:26394170,26395705:26395992,26396894:26397226,26414629:26414831,26415980:26417355,26415983:26417523,26415986:26417730,26415989:26417908,26415992:26419517,26415996:26418401,26415998:26418626,26416001:26418803,26416004:26419032,26420873:26421000,26421382:26421418,26422165:26422199,26427890:26428012,26429044:26429135,26436099:26436206,26437930:26438264,26439058:26439379,26441208:26442386,26443654:26443951,26445592:26445828,26456055:26456371,26458279:26458394,26461208:26461529,26463698:26464184,26496949:26501254,26502793:26511579,26505116:26505586,26505119:26505916,26505123:26506131,26505126:26506243,26505133:26506873,26505138:26507042,26505140:26507374,26505144:26507640,26505156:26507888,26508174:26508810,26510963:26511186,26615964:26617715,26615966:26617475,26615968:26617181,26615970:26617259,26615972:26617135,26615974:26617031,26615976:26616845,26615979:26616761,26615981:26616719,26615984:26616574,26615986:26616391,26615989:26616487,26615996:26616093,26615998:2661605', 'assoc_mat': '26390335:metal:4230:26390425,26391604:metal:4230:26391791,26393807:metal:4230:26394170,26395705:metal:4230:26395992,26396894:metal:4230:26397226,26414629:metal:4230:26414831,26415980:metal:4230:26417355,26415983:metal:4230:26417523,26415986:metal:4230:26417730,26415989:metal:4230:26417908,26415992:metal:4230:26419517,26415996:metal:4230:26418401,26415998:metal:4230:26418626,26416001:metal:4230:26418803,26416004:metal:4230:26419032,26420873:metal:4230:26421000,26421382:metal:4230:26421418,26422165:metal:4230:26422199,26427890:metal:4230:26428012,26429044:metal:4230:26429135,26436099:metal:4230:26436206,26437930:metal:4230:26438264,26439058:metal:4230:26439379,26441208:metal:4230:26442386,26443654:metal:4230:26443951,26445592:metal:4230:26445828,26456055:metal:4230:26456371,26458279:metal:4230:26458394,26461208:metal:4230:26461529,26463698:metal:4230:26464184,26496949:metal:4230:26501254,26502793:metal:4230:26511579,26505116:metal:4230:26505586,26505119:metal:4230:26505916,26505123:metal:4230:26506131,26505126:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.23973955388909218, 'nb_photo': 310264, 'list_port_cont': '26389458,26390421,26391785,26394175,26395993,26397239,26399949,26402766,26405377,26407555,26409801,26412534,26414847,26417366,26417517,26417733,26417903,26418412,26418580,26418627,26418789,26419031,26419524,26419620,26420918,26421006,26421428,26421947,26422208,26423598,26425554,26428017,26429146,26431371,26436207,26438101,26438262,26439388,26442393,26443957,26445825,26448893,26451460,26453761,26456372,26458400,26461536,26464180,26484891,26486984,26488723,26498421,26501252,26501624,26505588,26505917,26506133,26506257,26506589,26506874,26507036,26507383,26507636,26507879,26508122,26508805,26511187,26511309,26511582,26511745,26616064,26616092,26616161,26616224,26616399,26616492,26616581,26616726,26616759,26616855,26617029,26617138,26617171,26617249,26617491,26617721,26617991,26618209,26620420,26620520,26620676,26620770,26620906,26621068,26621281,26621323,26621414,26621534,26622037,26622967,26623075,26623201,26623392,26623510,26623544,26623651,26623675,26623771,26623956,26776156,26776202,26776564,26776698,2677710', 'assoc_port': '26389113:26389458,26390335:26390421,26391604:26391785,26393807:26394175,26395705:26395993,26396894:26397239,26399738:26399949,26402608:26402766,26405244:26405377,26407311:26407555,26409666:26409801,26412120:26412534,26414629:26414847,26415980:26417366,26415983:26417517,26415986:26417733,26415989:26417903,26415992:26419524,26415996:26418412,26415998:26418627,26416001:26418789,26416004:26419031,26418179:26418580,26419550:26419620,26420873:26421006,26420876:26420918,26421382:26421428,26421878:26421947,26422165:26422208,26423462:26423598,26425265:26425554,26427890:26428017,26429044:26429146,26431300:26431371,26434089:26438101,26436099:26436207,26437930:26438262,26439058:26439388,26441208:26442393,26443654:26443957,26445592:26445825,26448569:26448893,26451136:26451460,26453314:26453761,26456055:26456372,26458279:26458400,26461208:26461536,26463698:26464180,26484792:26484891,26486923:26486984,26488637:26488723,26492756:26501624,26496949:26501252,26498270:26498421,26500782:26511309,26502793:26511582,26505116:2650558', 'assoc_mat': '26389113:papier:4230:26389458,26390335:papier:4230:26390421,26391604:papier:4230:26391785,26393807:papier:4230:26394175,26395705:papier:4230:26395993,26396894:papier:4230:26397239,26399738:papier:4230:26399949,26402608:papier:4230:26402766,26405244:papier:4230:26405377,26407311:papier:4230:26407555,26409666:papier:4230:26409801,26412120:papier:4230:26412534,26414629:papier:4230:26414847,26415980:papier:4230:26417366,26415983:papier:4230:26417517,26415986:papier:4230:26417733,26415989:papier:4230:26417903,26415992:papier:4230:26419524,26415996:papier:4230:26418412,26415998:papier:4230:26418627,26416001:papier:4230:26418789,26416004:papier:4230:26419031,26418179:papier:4230:26418580,26419550:papier:4230:26419620,26420873:papier:4230:26421006,26420876:papier:4230:26420918,26421382:papier:4230:26421428,26421878:papier:4230:26421947,26422165:papier:4230:26422208,26423462:papier:4230:26423598,26425265:papier:4230:26425554,26427890:papier:4230:26428017,26429044:papier:4230:26429146,26431300:papier:4230:26431371,2643'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006494809546941282, 'nb_photo': 2905, 'list_port_cont': '26394180,26397242,26417367,26418632,26421419,26438265,26439392,26442394,26443950,26445830,26506251,26507380,26508120,26508808,26511312,26616063,26616094,26616170,26616215,26616405,26616482,26616580,26616723,26616768,26616846,26617027,26617134,26617179,26617254,26617484,26617722,26617983,26618217,26620414,26620516,26620679,26620762,26620902,26621066,26621289,26621321,26621416,26621544,26622041,26622961,26623068,26623198,26623405,26623507,26623538,26623655,26623662,26623759,26623962,26776159,26776197,26776578,26776699,26777108,26777615,26777692,26778525,26779645,26780209,26780727,26781268,26782897,26786649,26790995,26791028,26791514,26791670,26915903,26916064,26916529,26916788,26917065,26917356,26917528,26917645,26917904,26918603,26921517,26921805,26923302,26923791,26923971,26925919,26927844,26930215,26933329,26935859,26939680,26941145,26941796,26942160,26942819,26942854,26942891,26943003,26943580,26943678,26944080,26944165,26944205,26944474,26944639,26945763,26946334,26946507,26946674,26947338,26947758,2694816', 'assoc_port': '26393807:26394180,26396894:26397242,26415980:26417367,26415998:26418632,26421382:26421419,26437930:26438265,26439058:26439392,26441208:26442394,26443654:26443950,26445592:26445830,26500782:26511312,26505126:26506251,26505140:26507380,26505164:26508120,26508174:26508808,26615964:26617722,26615966:26617484,26615968:26617179,26615970:26617254,26615972:26617134,26615974:26617027,26615976:26616846,26615979:26616768,26615981:26616723,26615984:26616580,26615986:26616405,26615989:26616482,26615991:26616215,26615993:26616170,26615996:26616094,26615998:26616063,26617533:26617983,26618195:26618217,26620370:26620414,26620497:26620516,26620623:26620679,26620750:26620762,26620849:26620902,26621015:26621066,26621138:26621289,26621232:26621321,26621394:26621416,26621522:26621544,26621650:26622041,26621749:26622961,26621752:26623068,26621755:26623538,26621758:26623198,26621761:26623662,26621764:26623655,26621767:26623405,26621770:26623507,26623751:26623759,26623912:26623962,26766459:26791670,26766464:26791514,26766467:2679099', 'assoc_mat': '26393807:pehd:4230:26394180,26396894:pehd:4230:26397242,26415980:pehd:4230:26417367,26415998:pehd:4230:26418632,26421382:pehd:4230:26421419,26437930:pehd:4230:26438265,26439058:pehd:4230:26439392,26441208:pehd:4230:26442394,26443654:pehd:4230:26443950,26445592:pehd:4230:26445830,26500782:pehd:4230:26511312,26505126:pehd:4230:26506251,26505140:pehd:4230:26507380,26505164:pehd:4230:26508120,26508174:pehd:4230:26508808,26615964:pehd:4230:26617722,26615966:pehd:4230:26617484,26615968:pehd:4230:26617179,26615970:pehd:4230:26617254,26615972:pehd:4230:26617134,26615974:pehd:4230:26617027,26615976:pehd:4230:26616846,26615979:pehd:4230:26616768,26615981:pehd:4230:26616723,26615984:pehd:4230:26616580,26615986:pehd:4230:26616405,26615989:pehd:4230:26616482,26615991:pehd:4230:26616215,26615993:pehd:4230:26616170,26615996:pehd:4230:26616094,26615998:pehd:4230:26616063,26617533:pehd:4230:26617983,26618195:pehd:4230:26618217,26620370:pehd:4230:26620414,26620497:pehd:4230:26620516,26620623:pehd:4230:26620679,26620750:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011292446768284628, 'nb_photo': 16046, 'list_port_cont': '26389450,26390427,26391793,26394181,26395984,26397236,26399948,26402765,26405381,26407558,26409788,26412529,26414846,26417369,26417521,26417727,26417901,26418414,26418571,26418631,26418797,26419029,26419520,26419611,26420912,26420998,26421429,26421942,26422198,26423613,26425549,26428018,26429148,26431372,26436203,26438110,26438263,26439383,26442397,26443952,26445826,26448894,26451463,26453763,26456362,26458403,26461533,26464183,26484893,26486991,26488744,26498424,26501258,26501622,26505602,26505921,26506136,26506255,26506600,26506879,26507040,26507382,26507649,26507876,26508111,26508796,26511180,26511316,26511581,26511744,26616059,26616102,26616160,26616222,26616404,26616493,26616569,26616727,26616765,26616840,26617028,26617128,26617177,26617253,26617483,26617729,26617999,26618218,26620428,26620517,26620680,26620764,26620901,26621055,26621280,26621324,26621404,26621532,26622045,26622968,26623072,26623194,26623403,26623513,26623546,26623656,26623660,26623773,26623961,26776145,26776192,26776574,26776695,2677709', 'assoc_port': '26389113:26389450,26390335:26390427,26391604:26391793,26393807:26394181,26395705:26395984,26396894:26397236,26399738:26399948,26402608:26402765,26405244:26405381,26407311:26407558,26409666:26409788,26412120:26412529,26414629:26414846,26415980:26417369,26415983:26417521,26415986:26417727,26415989:26417901,26415992:26419520,26415996:26418414,26415998:26418631,26416001:26418797,26416004:26419029,26418179:26418571,26419550:26419611,26420873:26420998,26420876:26420912,26421382:26421429,26421878:26421942,26422165:26422198,26423462:26423613,26425265:26425549,26427890:26428018,26429044:26429148,26431300:26431372,26434089:26438110,26436099:26436203,26437930:26438263,26439058:26439383,26441208:26442397,26443654:26443952,26445592:26445826,26448569:26448894,26451136:26451463,26453314:26453763,26456055:26456362,26458279:26458403,26461208:26461533,26463698:26464183,26484792:26484893,26486923:26486991,26488637:26488744,26492756:26501622,26496949:26501258,26498270:26498424,26500782:26511316,26502793:26511581,26505116:2650560', 'assoc_mat': '26389113:pet_clair:4230:26389450,26390335:pet_clair:4230:26390427,26391604:pet_clair:4230:26391793,26393807:pet_clair:4230:26394181,26395705:pet_clair:4230:26395984,26396894:pet_clair:4230:26397236,26399738:pet_clair:4230:26399948,26402608:pet_clair:4230:26402765,26405244:pet_clair:4230:26405381,26407311:pet_clair:4230:26407558,26409666:pet_clair:4230:26409788,26412120:pet_clair:4230:26412529,26414629:pet_clair:4230:26414846,26415980:pet_clair:4230:26417369,26415983:pet_clair:4230:26417521,26415986:pet_clair:4230:26417727,26415989:pet_clair:4230:26417901,26415992:pet_clair:4230:26419520,26415996:pet_clair:4230:26418414,26415998:pet_clair:4230:26418631,26416001:pet_clair:4230:26418797,26416004:pet_clair:4230:26419029,26418179:pet_clair:4230:26418571,26419550:pet_clair:4230:26419611,26420873:pet_clair:4230:26420998,26420876:pet_clair:4230:26420912,26421382:pet_clair:4230:26421429,26421878:pet_clair:4230:26421942,26422165:pet_clair:4230:26422198,26423462:pet_clair:4230:26423613,26425265:pet_clair:4230:26425549,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003972917532420193, 'nb_photo': 1058, 'list_port_cont': '26389454,26390422,26391799,26394176,26395989,26397238,26399944,26402760,26407548,26409800,26412522,26414848,26417370,26417522,26417738,26417906,26418411,26418576,26418625,26418796,26419041,26419527,26419619,26420910,26421007,26421423,26421948,26422192,26423610,26425551,26428016,26429153,26431375,26436211,26438104,26438257,26439387,26442398,26443954,26498422,26505594,26505913,26506253,26506875,26511583,26616579,26616722,26617032,26617139,26617257,26617493,26617995,26620904,26621288,26623548,26776160,26776199,26776573,26776691,26777099,26777617,26778529,26780214,26780726,26781276,26782885,26786658,26790990,26791517,26791667,26915905,26916068,26916528,26916785,26917070,26917365,26917525,26917643,26917898,26918601,26921507,26921813,26923307,26923802,26923974,26925920,26927853,26930216,26933321,26935853,26939667,26941790,26942820,26942889,26943001,26943583,26944074,26944167,26944208,26944477,26945771,26946331,26946508,26946669,26947342,26947753,26948152,26950517,26951095,26951224,26951329,26951501,26951691,2695254', 'assoc_port': '26389113:26389454,26390335:26390422,26391604:26391799,26393807:26394176,26395705:26395989,26396894:26397238,26399738:26399944,26402608:26402760,26407311:26407548,26409666:26409800,26412120:26412522,26414629:26414848,26415980:26417370,26415983:26417522,26415986:26417738,26415989:26417906,26415992:26419527,26415996:26418411,26415998:26418625,26416001:26418796,26416004:26419041,26418179:26418576,26419550:26419619,26420873:26421007,26420876:26420910,26421382:26421423,26421878:26421948,26422165:26422192,26423462:26423610,26425265:26425551,26427890:26428016,26429044:26429153,26431300:26431375,26434089:26438104,26436099:26436211,26437930:26438257,26439058:26439387,26441208:26442398,26443654:26443954,26498270:26498422,26502793:26511583,26505116:26505594,26505119:26505913,26505126:26506253,26505133:26506875,26615966:26617493,26615970:26617257,26615972:26617139,26615974:26617032,26615981:26616722,26615984:26616579,26617533:26617995,26620849:26620904,26621138:26621288,26621755:26623548,26766459:26791667,26766464:2679151', 'assoc_mat': '26389113:pet_fonce:4230:26389454,26390335:pet_fonce:4230:26390422,26391604:pet_fonce:4230:26391799,26393807:pet_fonce:4230:26394176,26395705:pet_fonce:4230:26395989,26396894:pet_fonce:4230:26397238,26399738:pet_fonce:4230:26399944,26402608:pet_fonce:4230:26402760,26407311:pet_fonce:4230:26407548,26409666:pet_fonce:4230:26409800,26412120:pet_fonce:4230:26412522,26414629:pet_fonce:4230:26414848,26415980:pet_fonce:4230:26417370,26415983:pet_fonce:4230:26417522,26415986:pet_fonce:4230:26417738,26415989:pet_fonce:4230:26417906,26415992:pet_fonce:4230:26419527,26415996:pet_fonce:4230:26418411,26415998:pet_fonce:4230:26418625,26416001:pet_fonce:4230:26418796,26416004:pet_fonce:4230:26419041,26418179:pet_fonce:4230:26418576,26419550:pet_fonce:4230:26419619,26420873:pet_fonce:4230:26421007,26420876:pet_fonce:4230:26420910,26421382:pet_fonce:4230:26421423,26421878:pet_fonce:4230:26421948,26422165:pet_fonce:4230:26422192,26423462:pet_fonce:4230:26423610,26425265:pet_fonce:4230:26425551,26427890:pet_fonce:4230:26428016,2'}) select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(2220223,2227973,2235225,2312089,2312077,2312053,2312049,2312033,2312027,2311947,2312013,2311999,2311977,2311969,2315885,2323447,2331221,2335109,2335745)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-09-01' and date <= '2025-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1433,),), 'unwanted_material_monthly_percentage': ((0.6893879360264091,),), 'material_repartition': (('incineration', 1429),), 'material_dict': {'incineration': 1429}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 9, 1), 0.8461157657572106, 4), (datetime.date(2025, 9, 2), 0.8147925284799782, 3), (datetime.date(2025, 9, 3), 0.7877958768613892, 4), (datetime.date(2025, 9, 4), 0.7167395417230009, 4), (datetime.date(2025, 9, 5), 0.6459526440855707, 3), (datetime.date(2025, 9, 6), 0.6499066235790266, 4), (datetime.date(2025, 9, 7), 0.6900303554315137, 3), (datetime.date(2025, 9, 8), 0.730401838755084, 2), (datetime.date(2025, 9, 9), 0.7138638892367993, 3), (datetime.date(2025, 9, 10), 0.6255468820936227, 3), (datetime.date(2025, 9, 11), 0.5882018704733608, 4), (datetime.date(2025, 9, 12), 0.6327928563053071, 4), (datetime.date(2025, 9, 15), 0.6999643115444075, 4), (datetime.date(2025, 9, 16), 0.7190605426018996, 4), (datetime.date(2025, 9, 17), 0.6531154872478879, 3), (datetime.date(2025, 9, 18), 0.6097219782121298, 4), (datetime.date(2025, 9, 19), 0.6368380636005456, 4), (datetime.date(2025, 9, 20), 0.6514585397267042, 4), (datetime.date(2025, 9, 21), 0.6570400638176179, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 9, 1), 0.8461157657572106, 4), (datetime.date(2025, 9, 2), 0.8147925284799782, 3), (datetime.date(2025, 9, 3), 0.7877958768613892, 4), (datetime.date(2025, 9, 4), 0.7167395417230009, 4), (datetime.date(2025, 9, 5), 0.6459526440855707, 3), (datetime.date(2025, 9, 6), 0.6499066235790266, 4), (datetime.date(2025, 9, 7), 0.6900303554315137, 3), (datetime.date(2025, 9, 8), 0.730401838755084, 2), (datetime.date(2025, 9, 9), 0.7138638892367993, 3), (datetime.date(2025, 9, 10), 0.6255468820936227, 3), (datetime.date(2025, 9, 11), 0.5882018704733608, 4), (datetime.date(2025, 9, 12), 0.6327928563053071, 4), (datetime.date(2025, 9, 15), 0.6999643115444075, 4), (datetime.date(2025, 9, 16), 0.7190605426018996, 4), (datetime.date(2025, 9, 17), 0.6531154872478879, 3), (datetime.date(2025, 9, 18), 0.6097219782121298, 4), (datetime.date(2025, 9, 19), 0.6368380636005456, 4), (datetime.date(2025, 9, 20), 0.6514585397267042, 4), (datetime.date(2025, 9, 21), 0.6570400638176179, 3))}, 'quality_array': [['-8.2317527381147', '01092025'], ['-8.253020917801473', '02092025'], ['-8.405326209411264', '03092025'], ['-8.358905927714945', '04092025'], ['-8.501342095413037', '05092025'], ['-8.427569095428396', '06092025'], ['-8.460266152163483', '07092025'], ['-8.439066012510299', '08092025'], ['-8.523332610060638', '09092025'], ['-8.666732862898236', '10092025'], ['-8.808273618921609', '11092025'], ['-9.225244595871215', '12092025'], ['-9.071347958681692', '15092025'], ['-9.01338177508668', '16092025'], ['-9.009596377307533', '17092025'], ['-9.161432819466864', '18092025'], ['-9.196148852308953', '19092025'], ['-9.024246047503903', '20092025'], ['-8.984907297926341', '21092025']], 'number_of_batch': ((422,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01265614880699692, 'nb_photo': 10748, 'list_port_cont': '26389452,26390424,26391798,26394165,26395985,26397227,26399939,26402756,26405372,26407545,26409796,26412524,26414845,26417368,26417520,26417728,26417892,26418404,26418573,26418621,26418801,26419033,26419523,26419603,26420917,26421002,26421426,26421941,26422205,26423603,26425545,26428013,26429145,26431360,26436209,26438102,26438261,26439393,26442401,26443947,26445816,26448883,26451458,26453751,26456376,26458399,26461524,26464174,26484894,26486993,26488739,26498414,26501262,26501610,26505593,26505908,26506125,26506245,26506585,26506867,26507043,26507378,26507634,26507886,26508115,26508811,26511182,26511303,26511572,26511737,26616062,26616087,26616164,26616219,26616392,26616489,26616570,26616711,26616757,26616850,26617033,26617129,26617165,26617247,26617492,26617718,26617981,26618212,26620421,26620514,26620671,26620755,26620898,26621067,26621275,26621325,26621410,26621535,26622042,26622972,26623065,26623204,26623404,26623506,26623540,26623657,26623673,26623766,26623965,26776146,26776188,26776566,26776696,2677710', 'assoc_port': '26389113:26389452,26390335:26390424,26391604:26391798,26393807:26394165,26395705:26395985,26396894:26397227,26399738:26399939,26402608:26402756,26405244:26405372,26407311:26407545,26409666:26409796,26412120:26412524,26414629:26414845,26415980:26417368,26415983:26417520,26415986:26417728,26415989:26417892,26415992:26419523,26415996:26418404,26415998:26418621,26416001:26418801,26416004:26419033,26418179:26418573,26419550:26419603,26420873:26421002,26420876:26420917,26421382:26421426,26421878:26421941,26422165:26422205,26423462:26423603,26425265:26425545,26427890:26428013,26429044:26429145,26431300:26431360,26434089:26438102,26436099:26436209,26437930:26438261,26439058:26439393,26441208:26442401,26443654:26443947,26445592:26445816,26448569:26448883,26451136:26451458,26453314:26453751,26456055:26456376,26458279:26458399,26461208:26461524,26463698:26464174,26484792:26484894,26486923:26486993,26488637:26488739,26492756:26501610,26496949:26501262,26498270:26498414,26500782:26511303,26502793:26511572,26505116:2650559', 'assoc_mat': '26389113:autre:4230:26389452,26390335:autre:4230:26390424,26391604:autre:4230:26391798,26393807:autre:4230:26394165,26395705:autre:4230:26395985,26396894:autre:4230:26397227,26399738:autre:4230:26399939,26402608:autre:4230:26402756,26405244:autre:4230:26405372,26407311:autre:4230:26407545,26409666:autre:4230:26409796,26412120:autre:4230:26412524,26414629:autre:4230:26414845,26415980:autre:4230:26417368,26415983:autre:4230:26417520,26415986:autre:4230:26417728,26415989:autre:4230:26417892,26415992:autre:4230:26419523,26415996:autre:4230:26418404,26415998:autre:4230:26418621,26416001:autre:4230:26418801,26416004:autre:4230:26419033,26418179:autre:4230:26418573,26419550:autre:4230:26419603,26420873:autre:4230:26421002,26420876:autre:4230:26420917,26421382:autre:4230:26421426,26421878:autre:4230:26421941,26422165:autre:4230:26422205,26423462:autre:4230:26423603,26425265:autre:4230:26425545,26427890:autre:4230:26428013,26429044:autre:4230:26429145,26431300:autre:4230:26431360,26434089:autre:4230:26438102,26436099:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07063396962939078, 'nb_photo': 76753, 'list_port_cont': '26389460,26390426,26391788,26394174,26395991,26397232,26399940,26402761,26405379,26407557,26409791,26412528,26414844,26417361,26417514,26417735,26417905,26418409,26418575,26418620,26418794,26419042,26419525,26419616,26420908,26421005,26421422,26421943,26422206,26423608,26425548,26428019,26429144,26431374,26436210,26438107,26438267,26439391,26442399,26443956,26445829,26448896,26451461,26453758,26456374,26458398,26461541,26464182,26484889,26486996,26488733,26498410,26501261,26501619,26505597,26505914,26506141,26506252,26506595,26506878,26507039,26507367,26507647,26507885,26508121,26508807,26511184,26511306,26511584,26511741,26616056,26616100,26616168,26616225,26616403,26616485,26616571,26616725,26616769,26616856,26617030,26617133,26617170,26617250,26617490,26617727,26617997,26618214,26620423,26620508,26620681,26620768,26620899,26621071,26621278,26621316,26621415,26621536,26622043,26622962,26623080,26623202,26623393,26623504,26623547,26623645,26623668,26623770,26623959,26776155,26776193,26776577,26776693,2677710', 'assoc_port': '26389113:26389460,26390335:26390426,26391604:26391788,26393807:26394174,26395705:26395991,26396894:26397232,26399738:26399940,26402608:26402761,26405244:26405379,26407311:26407557,26409666:26409791,26412120:26412528,26414629:26414844,26415980:26417361,26415983:26417514,26415986:26417735,26415989:26417905,26415992:26419525,26415996:26418409,26415998:26418620,26416001:26418794,26416004:26419042,26418179:26418575,26419550:26419616,26420873:26421005,26420876:26420908,26421382:26421422,26421878:26421943,26422165:26422206,26423462:26423608,26425265:26425548,26427890:26428019,26429044:26429144,26431300:26431374,26434089:26438107,26436099:26436210,26437930:26438267,26439058:26439391,26441208:26442399,26443654:26443956,26445592:26445829,26448569:26448896,26451136:26451461,26453314:26453758,26456055:26456374,26458279:26458398,26461208:26461541,26463698:26464182,26484792:26484889,26486923:26486996,26488637:26488733,26492756:26501619,26496949:26501261,26498270:26498410,26500782:26511306,26502793:26511584,26505116:2650559', 'assoc_mat': '26389113:carton:4230:26389460,26390335:carton:4230:26390426,26391604:carton:4230:26391788,26393807:carton:4230:26394174,26395705:carton:4230:26395991,26396894:carton:4230:26397232,26399738:carton:4230:26399940,26402608:carton:4230:26402761,26405244:carton:4230:26405379,26407311:carton:4230:26407557,26409666:carton:4230:26409791,26412120:carton:4230:26412528,26414629:carton:4230:26414844,26415980:carton:4230:26417361,26415983:carton:4230:26417514,26415986:carton:4230:26417735,26415989:carton:4230:26417905,26415992:carton:4230:26419525,26415996:carton:4230:26418409,26415998:carton:4230:26418620,26416001:carton:4230:26418794,26416004:carton:4230:26419042,26418179:carton:4230:26418575,26419550:carton:4230:26419616,26420873:carton:4230:26421005,26420876:carton:4230:26420908,26421382:carton:4230:26421422,26421878:carton:4230:26421943,26422165:carton:4230:26422206,26423462:carton:4230:26423608,26425265:carton:4230:26425548,26427890:carton:4230:26428019,26429044:carton:4230:26429144,26431300:carton:4230:26431374,2643'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027974907033268014, 'nb_photo': 1417, 'list_port_cont': '26390425,26391791,26394170,26395992,26397226,26414831,26417355,26417523,26417730,26417908,26418401,26418626,26418803,26419032,26419517,26421000,26421418,26422199,26428012,26429135,26436206,26438264,26439379,26442386,26443951,26445828,26456371,26458394,26461529,26464184,26501254,26505586,26505916,26506131,26506243,26506873,26507042,26507374,26507640,26507888,26508810,26511186,26511579,26616051,26616093,26616391,26616487,26616574,26616719,26616761,26616845,26617031,26617135,26617181,26617259,26617475,26617715,26617973,26618215,26620518,26620769,26620903,26621063,26621282,26621315,26621409,26621545,26622047,26622959,26623069,26623501,26623536,26623640,26623663,26623767,26776151,26776201,26776572,26776684,26777097,26777606,26777695,26778520,26779648,26780715,26781267,26782886,26786646,26790997,26791018,26791511,26791665,26915879,26916054,26916531,26916790,26917058,26917361,26917519,26917644,26917902,26918600,26921506,26921798,26923305,26923799,26923972,26925904,26927845,26930202,26933327,26935851,26939679,2694114', 'assoc_port': '26390335:26390425,26391604:26391791,26393807:26394170,26395705:26395992,26396894:26397226,26414629:26414831,26415980:26417355,26415983:26417523,26415986:26417730,26415989:26417908,26415992:26419517,26415996:26418401,26415998:26418626,26416001:26418803,26416004:26419032,26420873:26421000,26421382:26421418,26422165:26422199,26427890:26428012,26429044:26429135,26436099:26436206,26437930:26438264,26439058:26439379,26441208:26442386,26443654:26443951,26445592:26445828,26456055:26456371,26458279:26458394,26461208:26461529,26463698:26464184,26496949:26501254,26502793:26511579,26505116:26505586,26505119:26505916,26505123:26506131,26505126:26506243,26505133:26506873,26505138:26507042,26505140:26507374,26505144:26507640,26505156:26507888,26508174:26508810,26510963:26511186,26615964:26617715,26615966:26617475,26615968:26617181,26615970:26617259,26615972:26617135,26615974:26617031,26615976:26616845,26615979:26616761,26615981:26616719,26615984:26616574,26615986:26616391,26615989:26616487,26615996:26616093,26615998:2661605', 'assoc_mat': '26390335:metal:4230:26390425,26391604:metal:4230:26391791,26393807:metal:4230:26394170,26395705:metal:4230:26395992,26396894:metal:4230:26397226,26414629:metal:4230:26414831,26415980:metal:4230:26417355,26415983:metal:4230:26417523,26415986:metal:4230:26417730,26415989:metal:4230:26417908,26415992:metal:4230:26419517,26415996:metal:4230:26418401,26415998:metal:4230:26418626,26416001:metal:4230:26418803,26416004:metal:4230:26419032,26420873:metal:4230:26421000,26421382:metal:4230:26421418,26422165:metal:4230:26422199,26427890:metal:4230:26428012,26429044:metal:4230:26429135,26436099:metal:4230:26436206,26437930:metal:4230:26438264,26439058:metal:4230:26439379,26441208:metal:4230:26442386,26443654:metal:4230:26443951,26445592:metal:4230:26445828,26456055:metal:4230:26456371,26458279:metal:4230:26458394,26461208:metal:4230:26461529,26463698:metal:4230:26464184,26496949:metal:4230:26501254,26502793:metal:4230:26511579,26505116:metal:4230:26505586,26505119:metal:4230:26505916,26505123:metal:4230:26506131,26505126:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.23973955388909218, 'nb_photo': 310264, 'list_port_cont': '26389458,26390421,26391785,26394175,26395993,26397239,26399949,26402766,26405377,26407555,26409801,26412534,26414847,26417366,26417517,26417733,26417903,26418412,26418580,26418627,26418789,26419031,26419524,26419620,26420918,26421006,26421428,26421947,26422208,26423598,26425554,26428017,26429146,26431371,26436207,26438101,26438262,26439388,26442393,26443957,26445825,26448893,26451460,26453761,26456372,26458400,26461536,26464180,26484891,26486984,26488723,26498421,26501252,26501624,26505588,26505917,26506133,26506257,26506589,26506874,26507036,26507383,26507636,26507879,26508122,26508805,26511187,26511309,26511582,26511745,26616064,26616092,26616161,26616224,26616399,26616492,26616581,26616726,26616759,26616855,26617029,26617138,26617171,26617249,26617491,26617721,26617991,26618209,26620420,26620520,26620676,26620770,26620906,26621068,26621281,26621323,26621414,26621534,26622037,26622967,26623075,26623201,26623392,26623510,26623544,26623651,26623675,26623771,26623956,26776156,26776202,26776564,26776698,2677710', 'assoc_port': '26389113:26389458,26390335:26390421,26391604:26391785,26393807:26394175,26395705:26395993,26396894:26397239,26399738:26399949,26402608:26402766,26405244:26405377,26407311:26407555,26409666:26409801,26412120:26412534,26414629:26414847,26415980:26417366,26415983:26417517,26415986:26417733,26415989:26417903,26415992:26419524,26415996:26418412,26415998:26418627,26416001:26418789,26416004:26419031,26418179:26418580,26419550:26419620,26420873:26421006,26420876:26420918,26421382:26421428,26421878:26421947,26422165:26422208,26423462:26423598,26425265:26425554,26427890:26428017,26429044:26429146,26431300:26431371,26434089:26438101,26436099:26436207,26437930:26438262,26439058:26439388,26441208:26442393,26443654:26443957,26445592:26445825,26448569:26448893,26451136:26451460,26453314:26453761,26456055:26456372,26458279:26458400,26461208:26461536,26463698:26464180,26484792:26484891,26486923:26486984,26488637:26488723,26492756:26501624,26496949:26501252,26498270:26498421,26500782:26511309,26502793:26511582,26505116:2650558', 'assoc_mat': '26389113:papier:4230:26389458,26390335:papier:4230:26390421,26391604:papier:4230:26391785,26393807:papier:4230:26394175,26395705:papier:4230:26395993,26396894:papier:4230:26397239,26399738:papier:4230:26399949,26402608:papier:4230:26402766,26405244:papier:4230:26405377,26407311:papier:4230:26407555,26409666:papier:4230:26409801,26412120:papier:4230:26412534,26414629:papier:4230:26414847,26415980:papier:4230:26417366,26415983:papier:4230:26417517,26415986:papier:4230:26417733,26415989:papier:4230:26417903,26415992:papier:4230:26419524,26415996:papier:4230:26418412,26415998:papier:4230:26418627,26416001:papier:4230:26418789,26416004:papier:4230:26419031,26418179:papier:4230:26418580,26419550:papier:4230:26419620,26420873:papier:4230:26421006,26420876:papier:4230:26420918,26421382:papier:4230:26421428,26421878:papier:4230:26421947,26422165:papier:4230:26422208,26423462:papier:4230:26423598,26425265:papier:4230:26425554,26427890:papier:4230:26428017,26429044:papier:4230:26429146,26431300:papier:4230:26431371,2643'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006494809546941282, 'nb_photo': 2905, 'list_port_cont': '26394180,26397242,26417367,26418632,26421419,26438265,26439392,26442394,26443950,26445830,26506251,26507380,26508120,26508808,26511312,26616063,26616094,26616170,26616215,26616405,26616482,26616580,26616723,26616768,26616846,26617027,26617134,26617179,26617254,26617484,26617722,26617983,26618217,26620414,26620516,26620679,26620762,26620902,26621066,26621289,26621321,26621416,26621544,26622041,26622961,26623068,26623198,26623405,26623507,26623538,26623655,26623662,26623759,26623962,26776159,26776197,26776578,26776699,26777108,26777615,26777692,26778525,26779645,26780209,26780727,26781268,26782897,26786649,26790995,26791028,26791514,26791670,26915903,26916064,26916529,26916788,26917065,26917356,26917528,26917645,26917904,26918603,26921517,26921805,26923302,26923791,26923971,26925919,26927844,26930215,26933329,26935859,26939680,26941145,26941796,26942160,26942819,26942854,26942891,26943003,26943580,26943678,26944080,26944165,26944205,26944474,26944639,26945763,26946334,26946507,26946674,26947338,26947758,2694816', 'assoc_port': '26393807:26394180,26396894:26397242,26415980:26417367,26415998:26418632,26421382:26421419,26437930:26438265,26439058:26439392,26441208:26442394,26443654:26443950,26445592:26445830,26500782:26511312,26505126:26506251,26505140:26507380,26505164:26508120,26508174:26508808,26615964:26617722,26615966:26617484,26615968:26617179,26615970:26617254,26615972:26617134,26615974:26617027,26615976:26616846,26615979:26616768,26615981:26616723,26615984:26616580,26615986:26616405,26615989:26616482,26615991:26616215,26615993:26616170,26615996:26616094,26615998:26616063,26617533:26617983,26618195:26618217,26620370:26620414,26620497:26620516,26620623:26620679,26620750:26620762,26620849:26620902,26621015:26621066,26621138:26621289,26621232:26621321,26621394:26621416,26621522:26621544,26621650:26622041,26621749:26622961,26621752:26623068,26621755:26623538,26621758:26623198,26621761:26623662,26621764:26623655,26621767:26623405,26621770:26623507,26623751:26623759,26623912:26623962,26766459:26791670,26766464:26791514,26766467:2679099', 'assoc_mat': '26393807:pehd:4230:26394180,26396894:pehd:4230:26397242,26415980:pehd:4230:26417367,26415998:pehd:4230:26418632,26421382:pehd:4230:26421419,26437930:pehd:4230:26438265,26439058:pehd:4230:26439392,26441208:pehd:4230:26442394,26443654:pehd:4230:26443950,26445592:pehd:4230:26445830,26500782:pehd:4230:26511312,26505126:pehd:4230:26506251,26505140:pehd:4230:26507380,26505164:pehd:4230:26508120,26508174:pehd:4230:26508808,26615964:pehd:4230:26617722,26615966:pehd:4230:26617484,26615968:pehd:4230:26617179,26615970:pehd:4230:26617254,26615972:pehd:4230:26617134,26615974:pehd:4230:26617027,26615976:pehd:4230:26616846,26615979:pehd:4230:26616768,26615981:pehd:4230:26616723,26615984:pehd:4230:26616580,26615986:pehd:4230:26616405,26615989:pehd:4230:26616482,26615991:pehd:4230:26616215,26615993:pehd:4230:26616170,26615996:pehd:4230:26616094,26615998:pehd:4230:26616063,26617533:pehd:4230:26617983,26618195:pehd:4230:26618217,26620370:pehd:4230:26620414,26620497:pehd:4230:26620516,26620623:pehd:4230:26620679,26620750:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011292446768284628, 'nb_photo': 16046, 'list_port_cont': '26389450,26390427,26391793,26394181,26395984,26397236,26399948,26402765,26405381,26407558,26409788,26412529,26414846,26417369,26417521,26417727,26417901,26418414,26418571,26418631,26418797,26419029,26419520,26419611,26420912,26420998,26421429,26421942,26422198,26423613,26425549,26428018,26429148,26431372,26436203,26438110,26438263,26439383,26442397,26443952,26445826,26448894,26451463,26453763,26456362,26458403,26461533,26464183,26484893,26486991,26488744,26498424,26501258,26501622,26505602,26505921,26506136,26506255,26506600,26506879,26507040,26507382,26507649,26507876,26508111,26508796,26511180,26511316,26511581,26511744,26616059,26616102,26616160,26616222,26616404,26616493,26616569,26616727,26616765,26616840,26617028,26617128,26617177,26617253,26617483,26617729,26617999,26618218,26620428,26620517,26620680,26620764,26620901,26621055,26621280,26621324,26621404,26621532,26622045,26622968,26623072,26623194,26623403,26623513,26623546,26623656,26623660,26623773,26623961,26776145,26776192,26776574,26776695,2677709', 'assoc_port': '26389113:26389450,26390335:26390427,26391604:26391793,26393807:26394181,26395705:26395984,26396894:26397236,26399738:26399948,26402608:26402765,26405244:26405381,26407311:26407558,26409666:26409788,26412120:26412529,26414629:26414846,26415980:26417369,26415983:26417521,26415986:26417727,26415989:26417901,26415992:26419520,26415996:26418414,26415998:26418631,26416001:26418797,26416004:26419029,26418179:26418571,26419550:26419611,26420873:26420998,26420876:26420912,26421382:26421429,26421878:26421942,26422165:26422198,26423462:26423613,26425265:26425549,26427890:26428018,26429044:26429148,26431300:26431372,26434089:26438110,26436099:26436203,26437930:26438263,26439058:26439383,26441208:26442397,26443654:26443952,26445592:26445826,26448569:26448894,26451136:26451463,26453314:26453763,26456055:26456362,26458279:26458403,26461208:26461533,26463698:26464183,26484792:26484893,26486923:26486991,26488637:26488744,26492756:26501622,26496949:26501258,26498270:26498424,26500782:26511316,26502793:26511581,26505116:2650560', 'assoc_mat': '26389113:pet_clair:4230:26389450,26390335:pet_clair:4230:26390427,26391604:pet_clair:4230:26391793,26393807:pet_clair:4230:26394181,26395705:pet_clair:4230:26395984,26396894:pet_clair:4230:26397236,26399738:pet_clair:4230:26399948,26402608:pet_clair:4230:26402765,26405244:pet_clair:4230:26405381,26407311:pet_clair:4230:26407558,26409666:pet_clair:4230:26409788,26412120:pet_clair:4230:26412529,26414629:pet_clair:4230:26414846,26415980:pet_clair:4230:26417369,26415983:pet_clair:4230:26417521,26415986:pet_clair:4230:26417727,26415989:pet_clair:4230:26417901,26415992:pet_clair:4230:26419520,26415996:pet_clair:4230:26418414,26415998:pet_clair:4230:26418631,26416001:pet_clair:4230:26418797,26416004:pet_clair:4230:26419029,26418179:pet_clair:4230:26418571,26419550:pet_clair:4230:26419611,26420873:pet_clair:4230:26420998,26420876:pet_clair:4230:26420912,26421382:pet_clair:4230:26421429,26421878:pet_clair:4230:26421942,26422165:pet_clair:4230:26422198,26423462:pet_clair:4230:26423613,26425265:pet_clair:4230:26425549,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003972917532420193, 'nb_photo': 1058, 'list_port_cont': '26389454,26390422,26391799,26394176,26395989,26397238,26399944,26402760,26407548,26409800,26412522,26414848,26417370,26417522,26417738,26417906,26418411,26418576,26418625,26418796,26419041,26419527,26419619,26420910,26421007,26421423,26421948,26422192,26423610,26425551,26428016,26429153,26431375,26436211,26438104,26438257,26439387,26442398,26443954,26498422,26505594,26505913,26506253,26506875,26511583,26616579,26616722,26617032,26617139,26617257,26617493,26617995,26620904,26621288,26623548,26776160,26776199,26776573,26776691,26777099,26777617,26778529,26780214,26780726,26781276,26782885,26786658,26790990,26791517,26791667,26915905,26916068,26916528,26916785,26917070,26917365,26917525,26917643,26917898,26918601,26921507,26921813,26923307,26923802,26923974,26925920,26927853,26930216,26933321,26935853,26939667,26941790,26942820,26942889,26943001,26943583,26944074,26944167,26944208,26944477,26945771,26946331,26946508,26946669,26947342,26947753,26948152,26950517,26951095,26951224,26951329,26951501,26951691,2695254', 'assoc_port': '26389113:26389454,26390335:26390422,26391604:26391799,26393807:26394176,26395705:26395989,26396894:26397238,26399738:26399944,26402608:26402760,26407311:26407548,26409666:26409800,26412120:26412522,26414629:26414848,26415980:26417370,26415983:26417522,26415986:26417738,26415989:26417906,26415992:26419527,26415996:26418411,26415998:26418625,26416001:26418796,26416004:26419041,26418179:26418576,26419550:26419619,26420873:26421007,26420876:26420910,26421382:26421423,26421878:26421948,26422165:26422192,26423462:26423610,26425265:26425551,26427890:26428016,26429044:26429153,26431300:26431375,26434089:26438104,26436099:26436211,26437930:26438257,26439058:26439387,26441208:26442398,26443654:26443954,26498270:26498422,26502793:26511583,26505116:26505594,26505119:26505913,26505126:26506253,26505133:26506875,26615966:26617493,26615970:26617257,26615972:26617139,26615974:26617032,26615981:26616722,26615984:26616579,26617533:26617995,26620849:26620904,26621138:26621288,26621755:26623548,26766459:26791667,26766464:2679151', 'assoc_mat': '26389113:pet_fonce:4230:26389454,26390335:pet_fonce:4230:26390422,26391604:pet_fonce:4230:26391799,26393807:pet_fonce:4230:26394176,26395705:pet_fonce:4230:26395989,26396894:pet_fonce:4230:26397238,26399738:pet_fonce:4230:26399944,26402608:pet_fonce:4230:26402760,26407311:pet_fonce:4230:26407548,26409666:pet_fonce:4230:26409800,26412120:pet_fonce:4230:26412522,26414629:pet_fonce:4230:26414848,26415980:pet_fonce:4230:26417370,26415983:pet_fonce:4230:26417522,26415986:pet_fonce:4230:26417738,26415989:pet_fonce:4230:26417906,26415992:pet_fonce:4230:26419527,26415996:pet_fonce:4230:26418411,26415998:pet_fonce:4230:26418625,26416001:pet_fonce:4230:26418796,26416004:pet_fonce:4230:26419041,26418179:pet_fonce:4230:26418576,26419550:pet_fonce:4230:26419619,26420873:pet_fonce:4230:26421007,26420876:pet_fonce:4230:26420910,26421382:pet_fonce:4230:26421423,26421878:pet_fonce:4230:26421948,26422165:pet_fonce:4230:26422192,26423462:pet_fonce:4230:26423610,26425265:pet_fonce:4230:26425551,26427890:pet_fonce:4230:26428016,2'}), 'main_stat': {'nb_photos': 1433}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-09', 0.6893879360264091),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1433,),), 'unwanted_material_monthly_percentage': ((0.6893879360264091,),), 'material_repartition': (('incineration', 1429),), 'material_dict': {'incineration': 1429}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 9, 1), 0.8461157657572106, 4), (datetime.date(2025, 9, 2), 0.8147925284799782, 3), (datetime.date(2025, 9, 3), 0.7877958768613892, 4), (datetime.date(2025, 9, 4), 0.7167395417230009, 4), (datetime.date(2025, 9, 5), 0.6459526440855707, 3), (datetime.date(2025, 9, 6), 0.6499066235790266, 4), (datetime.date(2025, 9, 7), 0.6900303554315137, 3), (datetime.date(2025, 9, 8), 0.730401838755084, 2), (datetime.date(2025, 9, 9), 0.7138638892367993, 3), (datetime.date(2025, 9, 10), 0.6255468820936227, 3), (datetime.date(2025, 9, 11), 0.5882018704733608, 4), (datetime.date(2025, 9, 12), 0.6327928563053071, 4), (datetime.date(2025, 9, 15), 0.6999643115444075, 4), (datetime.date(2025, 9, 16), 0.7190605426018996, 4), (datetime.date(2025, 9, 17), 0.6531154872478879, 3), (datetime.date(2025, 9, 18), 0.6097219782121298, 4), (datetime.date(2025, 9, 19), 0.6368380636005456, 4), (datetime.date(2025, 9, 20), 0.6514585397267042, 4), (datetime.date(2025, 9, 21), 0.6570400638176179, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 9, 1), 0.8461157657572106, 4), (datetime.date(2025, 9, 2), 0.8147925284799782, 3), (datetime.date(2025, 9, 3), 0.7877958768613892, 4), (datetime.date(2025, 9, 4), 0.7167395417230009, 4), (datetime.date(2025, 9, 5), 0.6459526440855707, 3), (datetime.date(2025, 9, 6), 0.6499066235790266, 4), (datetime.date(2025, 9, 7), 0.6900303554315137, 3), (datetime.date(2025, 9, 8), 0.730401838755084, 2), (datetime.date(2025, 9, 9), 0.7138638892367993, 3), (datetime.date(2025, 9, 10), 0.6255468820936227, 3), (datetime.date(2025, 9, 11), 0.5882018704733608, 4), (datetime.date(2025, 9, 12), 0.6327928563053071, 4), (datetime.date(2025, 9, 15), 0.6999643115444075, 4), (datetime.date(2025, 9, 16), 0.7190605426018996, 4), (datetime.date(2025, 9, 17), 0.6531154872478879, 3), (datetime.date(2025, 9, 18), 0.6097219782121298, 4), (datetime.date(2025, 9, 19), 0.6368380636005456, 4), (datetime.date(2025, 9, 20), 0.6514585397267042, 4), (datetime.date(2025, 9, 21), 0.6570400638176179, 3))}, 'quality_array': [['-8.2317527381147', '01092025'], ['-8.253020917801473', '02092025'], ['-8.405326209411264', '03092025'], ['-8.358905927714945', '04092025'], ['-8.501342095413037', '05092025'], ['-8.427569095428396', '06092025'], ['-8.460266152163483', '07092025'], ['-8.439066012510299', '08092025'], ['-8.523332610060638', '09092025'], ['-8.666732862898236', '10092025'], ['-8.808273618921609', '11092025'], ['-9.225244595871215', '12092025'], ['-9.071347958681692', '15092025'], ['-9.01338177508668', '16092025'], ['-9.009596377307533', '17092025'], ['-9.161432819466864', '18092025'], ['-9.196148852308953', '19092025'], ['-9.024246047503903', '20092025'], ['-8.984907297926341', '21092025']], 'number_of_batch': ((422,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.01265614880699692, 'nb_photo': 10748, 'list_port_cont': '26389452,26390424,26391798,26394165,26395985,26397227,26399939,26402756,26405372,26407545,26409796,26412524,26414845,26417368,26417520,26417728,26417892,26418404,26418573,26418621,26418801,26419033,26419523,26419603,26420917,26421002,26421426,26421941,26422205,26423603,26425545,26428013,26429145,26431360,26436209,26438102,26438261,26439393,26442401,26443947,26445816,26448883,26451458,26453751,26456376,26458399,26461524,26464174,26484894,26486993,26488739,26498414,26501262,26501610,26505593,26505908,26506125,26506245,26506585,26506867,26507043,26507378,26507634,26507886,26508115,26508811,26511182,26511303,26511572,26511737,26616062,26616087,26616164,26616219,26616392,26616489,26616570,26616711,26616757,26616850,26617033,26617129,26617165,26617247,26617492,26617718,26617981,26618212,26620421,26620514,26620671,26620755,26620898,26621067,26621275,26621325,26621410,26621535,26622042,26622972,26623065,26623204,26623404,26623506,26623540,26623657,26623673,26623766,26623965,26776146,26776188,26776566,26776696,2677710', 'assoc_port': '26389113:26389452,26390335:26390424,26391604:26391798,26393807:26394165,26395705:26395985,26396894:26397227,26399738:26399939,26402608:26402756,26405244:26405372,26407311:26407545,26409666:26409796,26412120:26412524,26414629:26414845,26415980:26417368,26415983:26417520,26415986:26417728,26415989:26417892,26415992:26419523,26415996:26418404,26415998:26418621,26416001:26418801,26416004:26419033,26418179:26418573,26419550:26419603,26420873:26421002,26420876:26420917,26421382:26421426,26421878:26421941,26422165:26422205,26423462:26423603,26425265:26425545,26427890:26428013,26429044:26429145,26431300:26431360,26434089:26438102,26436099:26436209,26437930:26438261,26439058:26439393,26441208:26442401,26443654:26443947,26445592:26445816,26448569:26448883,26451136:26451458,26453314:26453751,26456055:26456376,26458279:26458399,26461208:26461524,26463698:26464174,26484792:26484894,26486923:26486993,26488637:26488739,26492756:26501610,26496949:26501262,26498270:26498414,26500782:26511303,26502793:26511572,26505116:2650559', 'assoc_mat': '26389113:autre:4230:26389452,26390335:autre:4230:26390424,26391604:autre:4230:26391798,26393807:autre:4230:26394165,26395705:autre:4230:26395985,26396894:autre:4230:26397227,26399738:autre:4230:26399939,26402608:autre:4230:26402756,26405244:autre:4230:26405372,26407311:autre:4230:26407545,26409666:autre:4230:26409796,26412120:autre:4230:26412524,26414629:autre:4230:26414845,26415980:autre:4230:26417368,26415983:autre:4230:26417520,26415986:autre:4230:26417728,26415989:autre:4230:26417892,26415992:autre:4230:26419523,26415996:autre:4230:26418404,26415998:autre:4230:26418621,26416001:autre:4230:26418801,26416004:autre:4230:26419033,26418179:autre:4230:26418573,26419550:autre:4230:26419603,26420873:autre:4230:26421002,26420876:autre:4230:26420917,26421382:autre:4230:26421426,26421878:autre:4230:26421941,26422165:autre:4230:26422205,26423462:autre:4230:26423603,26425265:autre:4230:26425545,26427890:autre:4230:26428013,26429044:autre:4230:26429145,26431300:autre:4230:26431360,26434089:autre:4230:26438102,26436099:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.07063396962939078, 'nb_photo': 76753, 'list_port_cont': '26389460,26390426,26391788,26394174,26395991,26397232,26399940,26402761,26405379,26407557,26409791,26412528,26414844,26417361,26417514,26417735,26417905,26418409,26418575,26418620,26418794,26419042,26419525,26419616,26420908,26421005,26421422,26421943,26422206,26423608,26425548,26428019,26429144,26431374,26436210,26438107,26438267,26439391,26442399,26443956,26445829,26448896,26451461,26453758,26456374,26458398,26461541,26464182,26484889,26486996,26488733,26498410,26501261,26501619,26505597,26505914,26506141,26506252,26506595,26506878,26507039,26507367,26507647,26507885,26508121,26508807,26511184,26511306,26511584,26511741,26616056,26616100,26616168,26616225,26616403,26616485,26616571,26616725,26616769,26616856,26617030,26617133,26617170,26617250,26617490,26617727,26617997,26618214,26620423,26620508,26620681,26620768,26620899,26621071,26621278,26621316,26621415,26621536,26622043,26622962,26623080,26623202,26623393,26623504,26623547,26623645,26623668,26623770,26623959,26776155,26776193,26776577,26776693,2677710', 'assoc_port': '26389113:26389460,26390335:26390426,26391604:26391788,26393807:26394174,26395705:26395991,26396894:26397232,26399738:26399940,26402608:26402761,26405244:26405379,26407311:26407557,26409666:26409791,26412120:26412528,26414629:26414844,26415980:26417361,26415983:26417514,26415986:26417735,26415989:26417905,26415992:26419525,26415996:26418409,26415998:26418620,26416001:26418794,26416004:26419042,26418179:26418575,26419550:26419616,26420873:26421005,26420876:26420908,26421382:26421422,26421878:26421943,26422165:26422206,26423462:26423608,26425265:26425548,26427890:26428019,26429044:26429144,26431300:26431374,26434089:26438107,26436099:26436210,26437930:26438267,26439058:26439391,26441208:26442399,26443654:26443956,26445592:26445829,26448569:26448896,26451136:26451461,26453314:26453758,26456055:26456374,26458279:26458398,26461208:26461541,26463698:26464182,26484792:26484889,26486923:26486996,26488637:26488733,26492756:26501619,26496949:26501261,26498270:26498410,26500782:26511306,26502793:26511584,26505116:2650559', 'assoc_mat': '26389113:carton:4230:26389460,26390335:carton:4230:26390426,26391604:carton:4230:26391788,26393807:carton:4230:26394174,26395705:carton:4230:26395991,26396894:carton:4230:26397232,26399738:carton:4230:26399940,26402608:carton:4230:26402761,26405244:carton:4230:26405379,26407311:carton:4230:26407557,26409666:carton:4230:26409791,26412120:carton:4230:26412528,26414629:carton:4230:26414844,26415980:carton:4230:26417361,26415983:carton:4230:26417514,26415986:carton:4230:26417735,26415989:carton:4230:26417905,26415992:carton:4230:26419525,26415996:carton:4230:26418409,26415998:carton:4230:26418620,26416001:carton:4230:26418794,26416004:carton:4230:26419042,26418179:carton:4230:26418575,26419550:carton:4230:26419616,26420873:carton:4230:26421005,26420876:carton:4230:26420908,26421382:carton:4230:26421422,26421878:carton:4230:26421943,26422165:carton:4230:26422206,26423462:carton:4230:26423608,26425265:carton:4230:26425548,26427890:carton:4230:26428019,26429044:carton:4230:26429144,26431300:carton:4230:26431374,2643'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0027974907033268014, 'nb_photo': 1417, 'list_port_cont': '26390425,26391791,26394170,26395992,26397226,26414831,26417355,26417523,26417730,26417908,26418401,26418626,26418803,26419032,26419517,26421000,26421418,26422199,26428012,26429135,26436206,26438264,26439379,26442386,26443951,26445828,26456371,26458394,26461529,26464184,26501254,26505586,26505916,26506131,26506243,26506873,26507042,26507374,26507640,26507888,26508810,26511186,26511579,26616051,26616093,26616391,26616487,26616574,26616719,26616761,26616845,26617031,26617135,26617181,26617259,26617475,26617715,26617973,26618215,26620518,26620769,26620903,26621063,26621282,26621315,26621409,26621545,26622047,26622959,26623069,26623501,26623536,26623640,26623663,26623767,26776151,26776201,26776572,26776684,26777097,26777606,26777695,26778520,26779648,26780715,26781267,26782886,26786646,26790997,26791018,26791511,26791665,26915879,26916054,26916531,26916790,26917058,26917361,26917519,26917644,26917902,26918600,26921506,26921798,26923305,26923799,26923972,26925904,26927845,26930202,26933327,26935851,26939679,2694114', 'assoc_port': '26390335:26390425,26391604:26391791,26393807:26394170,26395705:26395992,26396894:26397226,26414629:26414831,26415980:26417355,26415983:26417523,26415986:26417730,26415989:26417908,26415992:26419517,26415996:26418401,26415998:26418626,26416001:26418803,26416004:26419032,26420873:26421000,26421382:26421418,26422165:26422199,26427890:26428012,26429044:26429135,26436099:26436206,26437930:26438264,26439058:26439379,26441208:26442386,26443654:26443951,26445592:26445828,26456055:26456371,26458279:26458394,26461208:26461529,26463698:26464184,26496949:26501254,26502793:26511579,26505116:26505586,26505119:26505916,26505123:26506131,26505126:26506243,26505133:26506873,26505138:26507042,26505140:26507374,26505144:26507640,26505156:26507888,26508174:26508810,26510963:26511186,26615964:26617715,26615966:26617475,26615968:26617181,26615970:26617259,26615972:26617135,26615974:26617031,26615976:26616845,26615979:26616761,26615981:26616719,26615984:26616574,26615986:26616391,26615989:26616487,26615996:26616093,26615998:2661605', 'assoc_mat': '26390335:metal:4230:26390425,26391604:metal:4230:26391791,26393807:metal:4230:26394170,26395705:metal:4230:26395992,26396894:metal:4230:26397226,26414629:metal:4230:26414831,26415980:metal:4230:26417355,26415983:metal:4230:26417523,26415986:metal:4230:26417730,26415989:metal:4230:26417908,26415992:metal:4230:26419517,26415996:metal:4230:26418401,26415998:metal:4230:26418626,26416001:metal:4230:26418803,26416004:metal:4230:26419032,26420873:metal:4230:26421000,26421382:metal:4230:26421418,26422165:metal:4230:26422199,26427890:metal:4230:26428012,26429044:metal:4230:26429135,26436099:metal:4230:26436206,26437930:metal:4230:26438264,26439058:metal:4230:26439379,26441208:metal:4230:26442386,26443654:metal:4230:26443951,26445592:metal:4230:26445828,26456055:metal:4230:26456371,26458279:metal:4230:26458394,26461208:metal:4230:26461529,26463698:metal:4230:26464184,26496949:metal:4230:26501254,26502793:metal:4230:26511579,26505116:metal:4230:26505586,26505119:metal:4230:26505916,26505123:metal:4230:26506131,26505126:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.23973955388909218, 'nb_photo': 310264, 'list_port_cont': '26389458,26390421,26391785,26394175,26395993,26397239,26399949,26402766,26405377,26407555,26409801,26412534,26414847,26417366,26417517,26417733,26417903,26418412,26418580,26418627,26418789,26419031,26419524,26419620,26420918,26421006,26421428,26421947,26422208,26423598,26425554,26428017,26429146,26431371,26436207,26438101,26438262,26439388,26442393,26443957,26445825,26448893,26451460,26453761,26456372,26458400,26461536,26464180,26484891,26486984,26488723,26498421,26501252,26501624,26505588,26505917,26506133,26506257,26506589,26506874,26507036,26507383,26507636,26507879,26508122,26508805,26511187,26511309,26511582,26511745,26616064,26616092,26616161,26616224,26616399,26616492,26616581,26616726,26616759,26616855,26617029,26617138,26617171,26617249,26617491,26617721,26617991,26618209,26620420,26620520,26620676,26620770,26620906,26621068,26621281,26621323,26621414,26621534,26622037,26622967,26623075,26623201,26623392,26623510,26623544,26623651,26623675,26623771,26623956,26776156,26776202,26776564,26776698,2677710', 'assoc_port': '26389113:26389458,26390335:26390421,26391604:26391785,26393807:26394175,26395705:26395993,26396894:26397239,26399738:26399949,26402608:26402766,26405244:26405377,26407311:26407555,26409666:26409801,26412120:26412534,26414629:26414847,26415980:26417366,26415983:26417517,26415986:26417733,26415989:26417903,26415992:26419524,26415996:26418412,26415998:26418627,26416001:26418789,26416004:26419031,26418179:26418580,26419550:26419620,26420873:26421006,26420876:26420918,26421382:26421428,26421878:26421947,26422165:26422208,26423462:26423598,26425265:26425554,26427890:26428017,26429044:26429146,26431300:26431371,26434089:26438101,26436099:26436207,26437930:26438262,26439058:26439388,26441208:26442393,26443654:26443957,26445592:26445825,26448569:26448893,26451136:26451460,26453314:26453761,26456055:26456372,26458279:26458400,26461208:26461536,26463698:26464180,26484792:26484891,26486923:26486984,26488637:26488723,26492756:26501624,26496949:26501252,26498270:26498421,26500782:26511309,26502793:26511582,26505116:2650558', 'assoc_mat': '26389113:papier:4230:26389458,26390335:papier:4230:26390421,26391604:papier:4230:26391785,26393807:papier:4230:26394175,26395705:papier:4230:26395993,26396894:papier:4230:26397239,26399738:papier:4230:26399949,26402608:papier:4230:26402766,26405244:papier:4230:26405377,26407311:papier:4230:26407555,26409666:papier:4230:26409801,26412120:papier:4230:26412534,26414629:papier:4230:26414847,26415980:papier:4230:26417366,26415983:papier:4230:26417517,26415986:papier:4230:26417733,26415989:papier:4230:26417903,26415992:papier:4230:26419524,26415996:papier:4230:26418412,26415998:papier:4230:26418627,26416001:papier:4230:26418789,26416004:papier:4230:26419031,26418179:papier:4230:26418580,26419550:papier:4230:26419620,26420873:papier:4230:26421006,26420876:papier:4230:26420918,26421382:papier:4230:26421428,26421878:papier:4230:26421947,26422165:papier:4230:26422208,26423462:papier:4230:26423598,26425265:papier:4230:26425554,26427890:papier:4230:26428017,26429044:papier:4230:26429146,26431300:papier:4230:26431371,2643'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006494809546941282, 'nb_photo': 2905, 'list_port_cont': '26394180,26397242,26417367,26418632,26421419,26438265,26439392,26442394,26443950,26445830,26506251,26507380,26508120,26508808,26511312,26616063,26616094,26616170,26616215,26616405,26616482,26616580,26616723,26616768,26616846,26617027,26617134,26617179,26617254,26617484,26617722,26617983,26618217,26620414,26620516,26620679,26620762,26620902,26621066,26621289,26621321,26621416,26621544,26622041,26622961,26623068,26623198,26623405,26623507,26623538,26623655,26623662,26623759,26623962,26776159,26776197,26776578,26776699,26777108,26777615,26777692,26778525,26779645,26780209,26780727,26781268,26782897,26786649,26790995,26791028,26791514,26791670,26915903,26916064,26916529,26916788,26917065,26917356,26917528,26917645,26917904,26918603,26921517,26921805,26923302,26923791,26923971,26925919,26927844,26930215,26933329,26935859,26939680,26941145,26941796,26942160,26942819,26942854,26942891,26943003,26943580,26943678,26944080,26944165,26944205,26944474,26944639,26945763,26946334,26946507,26946674,26947338,26947758,2694816', 'assoc_port': '26393807:26394180,26396894:26397242,26415980:26417367,26415998:26418632,26421382:26421419,26437930:26438265,26439058:26439392,26441208:26442394,26443654:26443950,26445592:26445830,26500782:26511312,26505126:26506251,26505140:26507380,26505164:26508120,26508174:26508808,26615964:26617722,26615966:26617484,26615968:26617179,26615970:26617254,26615972:26617134,26615974:26617027,26615976:26616846,26615979:26616768,26615981:26616723,26615984:26616580,26615986:26616405,26615989:26616482,26615991:26616215,26615993:26616170,26615996:26616094,26615998:26616063,26617533:26617983,26618195:26618217,26620370:26620414,26620497:26620516,26620623:26620679,26620750:26620762,26620849:26620902,26621015:26621066,26621138:26621289,26621232:26621321,26621394:26621416,26621522:26621544,26621650:26622041,26621749:26622961,26621752:26623068,26621755:26623538,26621758:26623198,26621761:26623662,26621764:26623655,26621767:26623405,26621770:26623507,26623751:26623759,26623912:26623962,26766459:26791670,26766464:26791514,26766467:2679099', 'assoc_mat': '26393807:pehd:4230:26394180,26396894:pehd:4230:26397242,26415980:pehd:4230:26417367,26415998:pehd:4230:26418632,26421382:pehd:4230:26421419,26437930:pehd:4230:26438265,26439058:pehd:4230:26439392,26441208:pehd:4230:26442394,26443654:pehd:4230:26443950,26445592:pehd:4230:26445830,26500782:pehd:4230:26511312,26505126:pehd:4230:26506251,26505140:pehd:4230:26507380,26505164:pehd:4230:26508120,26508174:pehd:4230:26508808,26615964:pehd:4230:26617722,26615966:pehd:4230:26617484,26615968:pehd:4230:26617179,26615970:pehd:4230:26617254,26615972:pehd:4230:26617134,26615974:pehd:4230:26617027,26615976:pehd:4230:26616846,26615979:pehd:4230:26616768,26615981:pehd:4230:26616723,26615984:pehd:4230:26616580,26615986:pehd:4230:26616405,26615989:pehd:4230:26616482,26615991:pehd:4230:26616215,26615993:pehd:4230:26616170,26615996:pehd:4230:26616094,26615998:pehd:4230:26616063,26617533:pehd:4230:26617983,26618195:pehd:4230:26618217,26620370:pehd:4230:26620414,26620497:pehd:4230:26620516,26620623:pehd:4230:26620679,26620750:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.011292446768284628, 'nb_photo': 16046, 'list_port_cont': '26389450,26390427,26391793,26394181,26395984,26397236,26399948,26402765,26405381,26407558,26409788,26412529,26414846,26417369,26417521,26417727,26417901,26418414,26418571,26418631,26418797,26419029,26419520,26419611,26420912,26420998,26421429,26421942,26422198,26423613,26425549,26428018,26429148,26431372,26436203,26438110,26438263,26439383,26442397,26443952,26445826,26448894,26451463,26453763,26456362,26458403,26461533,26464183,26484893,26486991,26488744,26498424,26501258,26501622,26505602,26505921,26506136,26506255,26506600,26506879,26507040,26507382,26507649,26507876,26508111,26508796,26511180,26511316,26511581,26511744,26616059,26616102,26616160,26616222,26616404,26616493,26616569,26616727,26616765,26616840,26617028,26617128,26617177,26617253,26617483,26617729,26617999,26618218,26620428,26620517,26620680,26620764,26620901,26621055,26621280,26621324,26621404,26621532,26622045,26622968,26623072,26623194,26623403,26623513,26623546,26623656,26623660,26623773,26623961,26776145,26776192,26776574,26776695,2677709', 'assoc_port': '26389113:26389450,26390335:26390427,26391604:26391793,26393807:26394181,26395705:26395984,26396894:26397236,26399738:26399948,26402608:26402765,26405244:26405381,26407311:26407558,26409666:26409788,26412120:26412529,26414629:26414846,26415980:26417369,26415983:26417521,26415986:26417727,26415989:26417901,26415992:26419520,26415996:26418414,26415998:26418631,26416001:26418797,26416004:26419029,26418179:26418571,26419550:26419611,26420873:26420998,26420876:26420912,26421382:26421429,26421878:26421942,26422165:26422198,26423462:26423613,26425265:26425549,26427890:26428018,26429044:26429148,26431300:26431372,26434089:26438110,26436099:26436203,26437930:26438263,26439058:26439383,26441208:26442397,26443654:26443952,26445592:26445826,26448569:26448894,26451136:26451463,26453314:26453763,26456055:26456362,26458279:26458403,26461208:26461533,26463698:26464183,26484792:26484893,26486923:26486991,26488637:26488744,26492756:26501622,26496949:26501258,26498270:26498424,26500782:26511316,26502793:26511581,26505116:2650560', 'assoc_mat': '26389113:pet_clair:4230:26389450,26390335:pet_clair:4230:26390427,26391604:pet_clair:4230:26391793,26393807:pet_clair:4230:26394181,26395705:pet_clair:4230:26395984,26396894:pet_clair:4230:26397236,26399738:pet_clair:4230:26399948,26402608:pet_clair:4230:26402765,26405244:pet_clair:4230:26405381,26407311:pet_clair:4230:26407558,26409666:pet_clair:4230:26409788,26412120:pet_clair:4230:26412529,26414629:pet_clair:4230:26414846,26415980:pet_clair:4230:26417369,26415983:pet_clair:4230:26417521,26415986:pet_clair:4230:26417727,26415989:pet_clair:4230:26417901,26415992:pet_clair:4230:26419520,26415996:pet_clair:4230:26418414,26415998:pet_clair:4230:26418631,26416001:pet_clair:4230:26418797,26416004:pet_clair:4230:26419029,26418179:pet_clair:4230:26418571,26419550:pet_clair:4230:26419611,26420873:pet_clair:4230:26420998,26420876:pet_clair:4230:26420912,26421382:pet_clair:4230:26421429,26421878:pet_clair:4230:26421942,26422165:pet_clair:4230:26422198,26423462:pet_clair:4230:26423613,26425265:pet_clair:4230:26425549,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.003972917532420193, 'nb_photo': 1058, 'list_port_cont': '26389454,26390422,26391799,26394176,26395989,26397238,26399944,26402760,26407548,26409800,26412522,26414848,26417370,26417522,26417738,26417906,26418411,26418576,26418625,26418796,26419041,26419527,26419619,26420910,26421007,26421423,26421948,26422192,26423610,26425551,26428016,26429153,26431375,26436211,26438104,26438257,26439387,26442398,26443954,26498422,26505594,26505913,26506253,26506875,26511583,26616579,26616722,26617032,26617139,26617257,26617493,26617995,26620904,26621288,26623548,26776160,26776199,26776573,26776691,26777099,26777617,26778529,26780214,26780726,26781276,26782885,26786658,26790990,26791517,26791667,26915905,26916068,26916528,26916785,26917070,26917365,26917525,26917643,26917898,26918601,26921507,26921813,26923307,26923802,26923974,26925920,26927853,26930216,26933321,26935853,26939667,26941790,26942820,26942889,26943001,26943583,26944074,26944167,26944208,26944477,26945771,26946331,26946508,26946669,26947342,26947753,26948152,26950517,26951095,26951224,26951329,26951501,26951691,2695254', 'assoc_port': '26389113:26389454,26390335:26390422,26391604:26391799,26393807:26394176,26395705:26395989,26396894:26397238,26399738:26399944,26402608:26402760,26407311:26407548,26409666:26409800,26412120:26412522,26414629:26414848,26415980:26417370,26415983:26417522,26415986:26417738,26415989:26417906,26415992:26419527,26415996:26418411,26415998:26418625,26416001:26418796,26416004:26419041,26418179:26418576,26419550:26419619,26420873:26421007,26420876:26420910,26421382:26421423,26421878:26421948,26422165:26422192,26423462:26423610,26425265:26425551,26427890:26428016,26429044:26429153,26431300:26431375,26434089:26438104,26436099:26436211,26437930:26438257,26439058:26439387,26441208:26442398,26443654:26443954,26498270:26498422,26502793:26511583,26505116:26505594,26505119:26505913,26505126:26506253,26505133:26506875,26615966:26617493,26615970:26617257,26615972:26617139,26615974:26617032,26615981:26616722,26615984:26616579,26617533:26617995,26620849:26620904,26621138:26621288,26621755:26623548,26766459:26791667,26766464:2679151', 'assoc_mat': '26389113:pet_fonce:4230:26389454,26390335:pet_fonce:4230:26390422,26391604:pet_fonce:4230:26391799,26393807:pet_fonce:4230:26394176,26395705:pet_fonce:4230:26395989,26396894:pet_fonce:4230:26397238,26399738:pet_fonce:4230:26399944,26402608:pet_fonce:4230:26402760,26407311:pet_fonce:4230:26407548,26409666:pet_fonce:4230:26409800,26412120:pet_fonce:4230:26412522,26414629:pet_fonce:4230:26414848,26415980:pet_fonce:4230:26417370,26415983:pet_fonce:4230:26417522,26415986:pet_fonce:4230:26417738,26415989:pet_fonce:4230:26417906,26415992:pet_fonce:4230:26419527,26415996:pet_fonce:4230:26418411,26415998:pet_fonce:4230:26418625,26416001:pet_fonce:4230:26418796,26416004:pet_fonce:4230:26419041,26418179:pet_fonce:4230:26418576,26419550:pet_fonce:4230:26419619,26420873:pet_fonce:4230:26421007,26420876:pet_fonce:4230:26420910,26421382:pet_fonce:4230:26421423,26421878:pet_fonce:4230:26421948,26422165:pet_fonce:4230:26422192,26423462:pet_fonce:4230:26423610,26425265:pet_fonce:4230:26425551,26427890:pet_fonce:4230:26428016,2'}), 'main_stat': {'nb_photos': 1433}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-09', 0.6893879360264091),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_09_annee_2025.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.27%', 10748], 'carton': ['carton', '7.06%', 76753], 'metal': ['metal', '0.28%', 1417], 'papier': ['papier', '23.97%', 310264], 'pehd': ['pehd', '0.65%', 2905], 'pet_clair': ['pet_clair', '1.13%', 16046], 'pet_fonce': ['pet_fonce', '0.4%', 1058]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_09_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.21user 2.49system 0:07.05elapsed 66%CPU (0avgtext+0avgdata 175304maxresident)k 10664inputs+280outputs (105major+43368minor)pagefaults 0swaps