python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 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_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 09 mtr_id : dashboard_places : SCCU_cam6 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_cam6' 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 = 202 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 = 202 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 = 202 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_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "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 (2220221,2227971,2235229,2311925,2312086,2312075,2312059,2312047,2312031,2312025,2311949,2312001,2311973,2311967,2315887,2323451,2331217,2335111,2336087,2341847,2349549,2355495,2359853,2364397,2368055,2369491,2371997,2376555) 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.013236589271647477, 'nb_photo': 18982, 'list_port_cont': '26416317,26416349,26416559,26416751,26416772,26417047,26417188,26417275,26417406,26417558,26417696,26418087,26418105,26418191,26418248,26418318,26418475,26418753,26418841,26418986,26419022,26419235,26419263,26419767,26458894,26461701,26462068,26462186,26462289,26462326,26462428,26462531,26462726,26462766,26462955,26463037,26463298,26463321,26463454,26463556,26463729,26463780,26463858,26463908,26464371,26465102,26467550,26468323,26504261,26506320,26506705,26506761,26507141,26507729,26507826,26507988,26508364,26508498,26508605,26509220,26509363,26509604,26509672,26509736,26509798,26510107,26510414,26510637,26511371,26511421,26511704,26514261,26544231,26544532,26547161,26549858,26550064,26550113,26550440,26550536,26550905,26551152,26552675,26615606,26616514,26616671,26616882,26616930,26617082,26617338,26617373,26617439,26617691,26617844,26618121,26618319,26660314,26663220,26666074,26914531,26915210,26915339,26915631,26916211,26916718,26917124,26917571,26918560,26920448,26921580,26921614,26923385,26923842,2692414', 'assoc_port': '26415979:26419263,26415982:26418841,26415985:26419022,26415988:26419235,26415991:26418753,26415994:26418986,26415997:26418105,26416000:26418318,26416003:26418087,26416006:26418248,26416008:26418191,26416010:26417696,26416012:26417558,26416014:26417188,26416016:26417406,26416018:26417047,26416020:26417275,26416022:26416772,26416024:26416559,26416026:26416751,26416028:26416349,26416030:26416317,26418181:26418475,26419549:26419767,26458278:26462289,26458281:26462531,26458282:26465102,26458284:26463037,26458285:26463298,26458286:26463454,26458288:26463858,26458289:26463908,26458303:26463729,26458304:26468323,26458309:26463780,26458319:26463556,26458321:26467550,26458322:26463321,26458323:26462955,26458324:26462766,26458325:26462726,26458327:26462326,26458328:26462428,26458329:26462068,26458330:26458894,26458331:26462186,26461167:26461701,26463697:26464371,26495026:26504261,26505114:26511704,26505118:26511421,26505122:26509220,26505125:26514261,26505130:26509604,26505132:26510107,26505136:26510637,26505139:2651041', 'assoc_mat': '26415979:autre:4230:26419263,26415982:autre:4230:26418841,26415985:autre:4230:26419022,26415988:autre:4230:26419235,26415991:autre:4230:26418753,26415994:autre:4230:26418986,26415997:autre:4230:26418105,26416000:autre:4230:26418318,26416003:autre:4230:26418087,26416006:autre:4230:26418248,26416008:autre:4230:26418191,26416010:autre:4230:26417696,26416012:autre:4230:26417558,26416014:autre:4230:26417188,26416016:autre:4230:26417406,26416018:autre:4230:26417047,26416020:autre:4230:26417275,26416022:autre:4230:26416772,26416024:autre:4230:26416559,26416026:autre:4230:26416751,26416028:autre:4230:26416349,26416030:autre:4230:26416317,26418181:autre:4230:26418475,26419549:autre:4230:26419767,26458278:autre:4230:26462289,26458281:autre:4230:26462531,26458282:autre:4230:26465102,26458284:autre:4230:26463037,26458285:autre:4230:26463298,26458286:autre:4230:26463454,26458288:autre:4230:26463858,26458289:autre:4230:26463908,26458303:autre:4230:26463729,26458304:autre:4230:26468323,26458309:autre:4230:26463780,26458319:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04430504606939476, 'nb_photo': 89845, 'list_port_cont': '26416327,26416365,26416570,26416756,26416771,26417053,26417192,26417277,26417396,26417560,26417701,26418082,26418091,26418205,26418256,26418320,26418486,26418768,26418839,26418988,26419018,26419226,26419267,26419758,26458904,26461695,26462063,26462182,26462285,26462338,26462437,26462534,26462719,26462776,26462952,26463038,26463300,26463337,26463458,26463555,26463738,26463784,26463857,26463925,26464379,26465093,26467560,26468316,26504257,26506316,26506708,26506764,26507148,26507741,26507832,26507987,26508376,26508503,26508616,26509219,26509361,26509619,26509685,26509748,26509813,26510110,26510421,26510645,26511368,26511426,26511702,26514269,26544245,26544548,26547168,26549870,26550063,26550118,26550448,26550550,26550893,26551162,26552676,26615616,26616530,26616665,26616893,26616923,26617089,26617349,26617380,26617436,26617693,26617857,26618124,26618328,26660319,26663247,26666077,26914525,26915208,26915335,26915644,26916221,26916722,26917127,26917565,26918553,26920451,26921571,26921622,26923392,26923839,2692414', 'assoc_port': '26415979:26419267,26415982:26418839,26415985:26419018,26415988:26419226,26415991:26418768,26415994:26418988,26415997:26418082,26416000:26418320,26416003:26418091,26416006:26418256,26416008:26418205,26416010:26417701,26416012:26417560,26416014:26417192,26416016:26417396,26416018:26417053,26416020:26417277,26416022:26416771,26416024:26416570,26416026:26416756,26416028:26416365,26416030:26416327,26418181:26418486,26419549:26419758,26458278:26462285,26458281:26462534,26458282:26465093,26458284:26463038,26458285:26463300,26458286:26463458,26458288:26463857,26458289:26463925,26458303:26463738,26458304:26468316,26458309:26463784,26458319:26463555,26458321:26467560,26458322:26463337,26458323:26462952,26458324:26462776,26458325:26462719,26458327:26462338,26458328:26462437,26458329:26462063,26458330:26458904,26458331:26462182,26461167:26461695,26463697:26464379,26495026:26504257,26505114:26511702,26505118:26511426,26505122:26509219,26505125:26514269,26505130:26509619,26505132:26510110,26505136:26510645,26505139:2651042', 'assoc_mat': '26415979:carton:4230:26419267,26415982:carton:4230:26418839,26415985:carton:4230:26419018,26415988:carton:4230:26419226,26415991:carton:4230:26418768,26415994:carton:4230:26418988,26415997:carton:4230:26418082,26416000:carton:4230:26418320,26416003:carton:4230:26418091,26416006:carton:4230:26418256,26416008:carton:4230:26418205,26416010:carton:4230:26417701,26416012:carton:4230:26417560,26416014:carton:4230:26417192,26416016:carton:4230:26417396,26416018:carton:4230:26417053,26416020:carton:4230:26417277,26416022:carton:4230:26416771,26416024:carton:4230:26416570,26416026:carton:4230:26416756,26416028:carton:4230:26416365,26416030:carton:4230:26416327,26418181:carton:4230:26418486,26419549:carton:4230:26419758,26458278:carton:4230:26462285,26458281:carton:4230:26462534,26458282:carton:4230:26465093,26458284:carton:4230:26463038,26458285:carton:4230:26463300,26458286:carton:4230:26463458,26458288:carton:4230:26463857,26458289:carton:4230:26463925,26458303:carton:4230:26463738,26458304:carton:4230:26468316,2645'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011785902860642317, 'nb_photo': 1620, 'list_port_cont': '26416357,26416777,26417045,26417198,26417268,26417394,26417544,26417692,26418079,26418088,26418201,26418245,26418325,26418764,26418978,26419015,26419768,26458902,26461692,26462175,26462334,26462438,26462720,26462778,26462946,26463030,26463551,26463741,26463781,26463843,26463914,26467552,26468320,26504256,26506304,26506715,26506772,26507133,26507816,26507986,26508378,26508601,26509210,26509362,26509609,26509678,26509738,26509801,26510100,26510417,26510636,26511379,26511430,26511694,26544239,26544542,26547167,26550059,26550438,26550549,26550882,26551149,26615605,26616529,26616666,26616881,26616926,26617334,26617376,26617425,26617679,26617856,26618120,26618327,26914530,26915199,26915327,26915633,26916220,26916735,26917562,26918559,26920438,26921573,26921606,26923829,26925815,26927577,26930675,26933668,26936552,26939787,26942276,26942319,26942576,26942620,26942716,26944025,26944248,26945848,26946715,26946859,26947257,26947923,26950595,26951015,26951668,26952001,26952092,26952242,26952338,26952604,26954423,2695452', 'assoc_port': '26415985:26419015,26415991:26418764,26415994:26418978,26415997:26418088,26416000:26418325,26416003:26418079,26416006:26418245,26416008:26418201,26416010:26417692,26416012:26417544,26416014:26417198,26416016:26417394,26416018:26417045,26416020:26417268,26416022:26416777,26416028:26416357,26419549:26419768,26458284:26463030,26458288:26463843,26458289:26463914,26458303:26463741,26458304:26468320,26458309:26463781,26458319:26463551,26458321:26467552,26458323:26462946,26458324:26462778,26458325:26462720,26458327:26462334,26458328:26462438,26458330:26458902,26458331:26462175,26461167:26461692,26495026:26504256,26505114:26511694,26505118:26511430,26505122:26509210,26505130:26509609,26505132:26510100,26505136:26510636,26505139:26510417,26505143:26509678,26505153:26509738,26505162:26509362,26505165:26509801,26505181:26508378,26505189:26507986,26505191:26506772,26505194:26507816,26505196:26507133,26505211:26506715,26505213:26506304,26508175:26508601,26510965:26511379,26537063:26544542,26543356:26544239,26546215:2655088', 'assoc_mat': '26415985:metal:4230:26419015,26415991:metal:4230:26418764,26415994:metal:4230:26418978,26415997:metal:4230:26418088,26416000:metal:4230:26418325,26416003:metal:4230:26418079,26416006:metal:4230:26418245,26416008:metal:4230:26418201,26416010:metal:4230:26417692,26416012:metal:4230:26417544,26416014:metal:4230:26417198,26416016:metal:4230:26417394,26416018:metal:4230:26417045,26416020:metal:4230:26417268,26416022:metal:4230:26416777,26416028:metal:4230:26416357,26419549:metal:4230:26419768,26458284:metal:4230:26463030,26458288:metal:4230:26463843,26458289:metal:4230:26463914,26458303:metal:4230:26463741,26458304:metal:4230:26468320,26458309:metal:4230:26463781,26458319:metal:4230:26463551,26458321:metal:4230:26467552,26458323:metal:4230:26462946,26458324:metal:4230:26462778,26458325:metal:4230:26462720,26458327:metal:4230:26462334,26458328:metal:4230:26462438,26458330:metal:4230:26458902,26458331:metal:4230:26462175,26461167:metal:4230:26461692,26495026:metal:4230:26504256,26505114:metal:4230:26511694,26505118:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20031969187736914, 'nb_photo': 512319, 'list_port_cont': '26416321,26416361,26416573,26416762,26416773,26417036,26417196,26417279,26417399,26417559,26417700,26418093,26418103,26418202,26418252,26418331,26418482,26418761,26418836,26418984,26419021,26419232,26419264,26419761,26458903,26461696,26462059,26462187,26462288,26462335,26462439,26462530,26462729,26462773,26462949,26463040,26463299,26463334,26463451,26463541,26463744,26463779,26463851,26463917,26464367,26465101,26467563,26468329,26504258,26506317,26506716,26506775,26507140,26507740,26507818,26507985,26508377,26508496,26508610,26509209,26509355,26509610,26509689,26509747,26509804,26510115,26510426,26510650,26511377,26511428,26511708,26514266,26544243,26544547,26547174,26549869,26550065,26550124,26550447,26550548,26550909,26551158,26552672,26615617,26616527,26616657,26616894,26616929,26617095,26617347,26617389,26617442,26617692,26617851,26618123,26618313,26660308,26663230,26666079,26914529,26915209,26915337,26915645,26916222,26916726,26917117,26917577,26918566,26920446,26921582,26921619,26923383,26923835,2692414', 'assoc_port': '26415979:26419264,26415982:26418836,26415985:26419021,26415988:26419232,26415991:26418761,26415994:26418984,26415997:26418103,26416000:26418331,26416003:26418093,26416006:26418252,26416008:26418202,26416010:26417700,26416012:26417559,26416014:26417196,26416016:26417399,26416018:26417036,26416020:26417279,26416022:26416773,26416024:26416573,26416026:26416762,26416028:26416361,26416030:26416321,26418181:26418482,26419549:26419761,26458278:26462288,26458281:26462530,26458282:26465101,26458284:26463040,26458285:26463299,26458286:26463451,26458288:26463851,26458289:26463917,26458303:26463744,26458304:26468329,26458309:26463779,26458319:26463541,26458321:26467563,26458322:26463334,26458323:26462949,26458324:26462773,26458325:26462729,26458327:26462335,26458328:26462439,26458329:26462059,26458330:26458903,26458331:26462187,26461167:26461696,26463697:26464367,26495026:26504258,26505114:26511708,26505118:26511428,26505122:26509209,26505125:26514266,26505130:26509610,26505132:26510115,26505136:26510650,26505139:2651042', 'assoc_mat': '26415979:papier:4230:26419264,26415982:papier:4230:26418836,26415985:papier:4230:26419021,26415988:papier:4230:26419232,26415991:papier:4230:26418761,26415994:papier:4230:26418984,26415997:papier:4230:26418103,26416000:papier:4230:26418331,26416003:papier:4230:26418093,26416006:papier:4230:26418252,26416008:papier:4230:26418202,26416010:papier:4230:26417700,26416012:papier:4230:26417559,26416014:papier:4230:26417196,26416016:papier:4230:26417399,26416018:papier:4230:26417036,26416020:papier:4230:26417279,26416022:papier:4230:26416773,26416024:papier:4230:26416573,26416026:papier:4230:26416762,26416028:papier:4230:26416361,26416030:papier:4230:26416321,26418181:papier:4230:26418482,26419549:papier:4230:26419761,26458278:papier:4230:26462288,26458281:papier:4230:26462530,26458282:papier:4230:26465101,26458284:papier:4230:26463040,26458285:papier:4230:26463299,26458286:papier:4230:26463451,26458288:papier:4230:26463851,26458289:papier:4230:26463917,26458303:papier:4230:26463744,26458304:papier:4230:26468329,2645'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0033031419070453033, 'nb_photo': 3198, 'list_port_cont': '26416760,26417039,26417189,26417555,26417697,26418077,26418097,26418203,26418257,26418326,26418484,26418766,26418833,26418987,26419016,26419229,26419259,26458899,26461693,26462056,26462177,26462290,26462333,26462435,26462525,26462712,26462956,26463289,26463336,26463557,26463737,26463785,26463859,26463922,26464378,26467565,26468324,26504254,26506310,26506712,26506774,26507150,26507745,26507820,26507992,26508367,26508502,26508615,26509366,26509683,26509751,26509811,26510106,26510427,26510651,26511378,26511418,26511707,26514267,26544242,26544537,26547175,26549872,26550060,26550120,26550435,26550545,26550901,26551160,26552670,26615618,26616528,26616670,26616889,26616932,26617086,26617344,26617386,26617441,26617694,26617855,26618127,26618326,26660317,26663236,26666080,26915207,26915334,26915643,26916215,26916730,26917126,26917576,26918567,26920447,26921584,26921610,26923384,26924145,26925811,26927584,26930665,26933670,26936556,26939792,26940695,26941284,26941958,26942311,26942408,26942578,26942615,26942717,2694386', 'assoc_port': '26415979:26419259,26415982:26418833,26415985:26419016,26415988:26419229,26415991:26418766,26415994:26418987,26415997:26418097,26416000:26418326,26416003:26418077,26416006:26418257,26416008:26418203,26416010:26417697,26416012:26417555,26416014:26417189,26416018:26417039,26416026:26416760,26418181:26418484,26458278:26462290,26458281:26462525,26458285:26463289,26458288:26463859,26458289:26463922,26458303:26463737,26458304:26468324,26458309:26463785,26458319:26463557,26458321:26467565,26458322:26463336,26458323:26462956,26458325:26462712,26458327:26462333,26458328:26462435,26458329:26462056,26458330:26458899,26458331:26462177,26461167:26461693,26463697:26464378,26495026:26504254,26505114:26511707,26505118:26511418,26505125:26514267,26505132:26510106,26505136:26510651,26505139:26510427,26505143:26509683,26505153:26509751,26505162:26509366,26505165:26509811,26505181:26508367,26505183:26508502,26505185:26507745,26505189:26507992,26505191:26506774,26505194:26507820,26505196:26507150,26505211:26506712,26505213:2650631', 'assoc_mat': '26415979:pehd:4230:26419259,26415982:pehd:4230:26418833,26415985:pehd:4230:26419016,26415988:pehd:4230:26419229,26415991:pehd:4230:26418766,26415994:pehd:4230:26418987,26415997:pehd:4230:26418097,26416000:pehd:4230:26418326,26416003:pehd:4230:26418077,26416006:pehd:4230:26418257,26416008:pehd:4230:26418203,26416010:pehd:4230:26417697,26416012:pehd:4230:26417555,26416014:pehd:4230:26417189,26416018:pehd:4230:26417039,26416026:pehd:4230:26416760,26418181:pehd:4230:26418484,26458278:pehd:4230:26462290,26458281:pehd:4230:26462525,26458285:pehd:4230:26463289,26458288:pehd:4230:26463859,26458289:pehd:4230:26463922,26458303:pehd:4230:26463737,26458304:pehd:4230:26468324,26458309:pehd:4230:26463785,26458319:pehd:4230:26463557,26458321:pehd:4230:26467565,26458322:pehd:4230:26463336,26458323:pehd:4230:26462956,26458325:pehd:4230:26462712,26458327:pehd:4230:26462333,26458328:pehd:4230:26462435,26458329:pehd:4230:26462056,26458330:pehd:4230:26458899,26458331:pehd:4230:26462177,26461167:pehd:4230:26461693,26463697:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013248421750777704, 'nb_photo': 19724, 'list_port_cont': '26416323,26416364,26416571,26416763,26416780,26417051,26417194,26417269,26417403,26417549,26417698,26418085,26418099,26418192,26418242,26418332,26418481,26418757,26418831,26418985,26419019,26419230,26419271,26419764,26458905,26461688,26462064,26462179,26462295,26462337,26462430,26462528,26462725,26462777,26462958,26463043,26463301,26463330,26463457,26463550,26463740,26463777,26463860,26463921,26464377,26465097,26467559,26468325,26504260,26506322,26506713,26506773,26507144,26507744,26507830,26507989,26508369,26508500,26508606,26509215,26509359,26509615,26509682,26509743,26509810,26510101,26510418,26510652,26511375,26511424,26511701,26514256,26544244,26544543,26547164,26549864,26550058,26550116,26550445,26550552,26550903,26551156,26552678,26615622,26616522,26616664,26616879,26616934,26617090,26617341,26617378,26617440,26617695,26617858,26618129,26618321,26660315,26663243,26666072,26914524,26915202,26915324,26915641,26916223,26916734,26917129,26917575,26918564,26920444,26921585,26921611,26923395,26923843,2692413', 'assoc_port': '26415979:26419271,26415982:26418831,26415985:26419019,26415988:26419230,26415991:26418757,26415994:26418985,26415997:26418099,26416000:26418332,26416003:26418085,26416006:26418242,26416008:26418192,26416010:26417698,26416012:26417549,26416014:26417194,26416016:26417403,26416018:26417051,26416020:26417269,26416022:26416780,26416024:26416571,26416026:26416763,26416028:26416364,26416030:26416323,26418181:26418481,26419549:26419764,26458278:26462295,26458281:26462528,26458282:26465097,26458284:26463043,26458285:26463301,26458286:26463457,26458288:26463860,26458289:26463921,26458303:26463740,26458304:26468325,26458309:26463777,26458319:26463550,26458321:26467559,26458322:26463330,26458323:26462958,26458324:26462777,26458325:26462725,26458327:26462337,26458328:26462430,26458329:26462064,26458330:26458905,26458331:26462179,26461167:26461688,26463697:26464377,26495026:26504260,26505114:26511701,26505118:26511424,26505122:26509215,26505125:26514256,26505130:26509615,26505132:26510101,26505136:26510652,26505139:2651041', 'assoc_mat': '26415979:pet_clair:4230:26419271,26415982:pet_clair:4230:26418831,26415985:pet_clair:4230:26419019,26415988:pet_clair:4230:26419230,26415991:pet_clair:4230:26418757,26415994:pet_clair:4230:26418985,26415997:pet_clair:4230:26418099,26416000:pet_clair:4230:26418332,26416003:pet_clair:4230:26418085,26416006:pet_clair:4230:26418242,26416008:pet_clair:4230:26418192,26416010:pet_clair:4230:26417698,26416012:pet_clair:4230:26417549,26416014:pet_clair:4230:26417194,26416016:pet_clair:4230:26417403,26416018:pet_clair:4230:26417051,26416020:pet_clair:4230:26417269,26416022:pet_clair:4230:26416780,26416024:pet_clair:4230:26416571,26416026:pet_clair:4230:26416763,26416028:pet_clair:4230:26416364,26416030:pet_clair:4230:26416323,26418181:pet_clair:4230:26418481,26419549:pet_clair:4230:26419764,26458278:pet_clair:4230:26462295,26458281:pet_clair:4230:26462528,26458282:pet_clair:4230:26465097,26458284:pet_clair:4230:26463043,26458285:pet_clair:4230:26463301,26458286:pet_clair:4230:26463457,26458288:pet_clair:4230:26463860,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023696051994389713, 'nb_photo': 1257, 'list_port_cont': '26417041,26417547,26417691,26418095,26418204,26418255,26418983,26419020,26419234,26458895,26461694,26462066,26462188,26462951,26463324,26463554,26463745,26463782,26463848,26464368,26467567,26468328,26504252,26506314,26506707,26507139,26507736,26507812,26508372,26509221,26509365,26509618,26509808,26510428,26511376,26511429,26511709,26514265,26544246,26544541,26547187,26549874,26550055,26550121,26550551,26550890,26551155,26552679,26615615,26616521,26616668,26616891,26616927,26617085,26617350,26617387,26617433,26617686,26617854,26618128,26618323,26660316,26666082,26915198,26915338,26915640,26916225,26916728,26917113,26917572,26920445,26921578,26921621,26923393,26923828,26924140,26925822,26927578,26930669,26933671,26936548,26939803,26940680,26941280,26942273,26942317,26942565,26942623,26942704,26943868,26944031,26944257,26944293,26945860,26946181,26946712,26947720,26947934,26950939,26951670,26952009,26952090,26952244,26952344,26952593,26954424,26954522,26954883,26955157,26955882,26956059,26956178,26957233,2695862', 'assoc_port': '26415985:26419020,26415988:26419234,26415994:26418983,26416003:26418095,26416006:26418255,26416008:26418204,26416010:26417691,26416012:26417547,26416018:26417041,26458288:26463848,26458303:26463745,26458304:26468328,26458309:26463782,26458319:26463554,26458321:26467567,26458322:26463324,26458323:26462951,26458329:26462066,26458330:26458895,26458331:26462188,26461167:26461694,26463697:26464368,26495026:26504252,26505114:26511709,26505118:26511429,26505122:26509221,26505125:26514265,26505130:26509618,26505139:26510428,26505162:26509365,26505165:26509808,26505181:26508372,26505185:26507736,26505194:26507812,26505196:26507139,26505211:26506707,26505213:26506314,26510965:26511376,26537063:26544541,26543356:26544246,26546215:26550890,26546218:26551155,26546220:26550551,26546223:26550121,26546237:26549874,26546242:26547187,26549409:26550055,26551983:26552679,26615403:26615615,26615975:26617854,26615977:26617686,26615980:26617433,26615982:26617350,26615985:26617085,26615987:26617387,26615990:26616927,26615992:2661689', 'assoc_mat': '26415985:pet_fonce:4230:26419020,26415988:pet_fonce:4230:26419234,26415994:pet_fonce:4230:26418983,26416003:pet_fonce:4230:26418095,26416006:pet_fonce:4230:26418255,26416008:pet_fonce:4230:26418204,26416010:pet_fonce:4230:26417691,26416012:pet_fonce:4230:26417547,26416018:pet_fonce:4230:26417041,26458288:pet_fonce:4230:26463848,26458303:pet_fonce:4230:26463745,26458304:pet_fonce:4230:26468328,26458309:pet_fonce:4230:26463782,26458319:pet_fonce:4230:26463554,26458321:pet_fonce:4230:26467567,26458322:pet_fonce:4230:26463324,26458323:pet_fonce:4230:26462951,26458329:pet_fonce:4230:26462066,26458330:pet_fonce:4230:26458895,26458331:pet_fonce:4230:26462188,26461167:pet_fonce:4230:26461694,26463697:pet_fonce:4230:26464368,26495026:pet_fonce:4230:26504252,26505114:pet_fonce:4230:26511709,26505118:pet_fonce:4230:26511429,26505122:pet_fonce:4230:26509221,26505125:pet_fonce:4230:26514265,26505130:pet_fonce:4230:26509618,26505139:pet_fonce:4230:26510428,26505162:pet_fonce:4230:26509365,26505165:pet_fonce:4230:26509808,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(2220221,2227971,2235229,2311925,2312086,2312075,2312059,2312047,2312031,2312025,2311949,2312001,2311973,2311967,2315887,2323451,2331217,2335111,2336087,2341847,2349549,2355495,2359853,2364397,2368055,2369491,2371997,2376555)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-09-01' and date <= '2025-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1999,),), 'unwanted_material_monthly_percentage': ((0.7361914632655978,),), 'material_repartition': (('incineration', 1999),), 'material_dict': {'incineration': 1999}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 9, 1), 0.8011543739050232, 4), (datetime.date(2025, 9, 2), 0.7627509501344351, 4), (datetime.date(2025, 9, 3), 0.7342988097871931, 4), (datetime.date(2025, 9, 4), 0.7122769821400514, 4), (datetime.date(2025, 9, 5), 0.7082009732340379, 4), (datetime.date(2025, 9, 6), 0.667441490369834, 4), (datetime.date(2025, 9, 7), 0.7363282247804429, 4), (datetime.date(2025, 9, 8), 0.7566882254933288, 4), (datetime.date(2025, 9, 9), 0.7588587437703574, 3), (datetime.date(2025, 9, 10), 0.7383355611073947, 3), (datetime.date(2025, 9, 11), 0.7513735999138669, 2), (datetime.date(2025, 9, 12), 0.7289164595870451, 3), (datetime.date(2025, 9, 15), 0.7839672757263989, 4), (datetime.date(2025, 9, 16), 0.7552223372701388, 3), (datetime.date(2025, 9, 17), 0.7128435985976017, 4), (datetime.date(2025, 9, 18), 0.7104241202031673, 4), (datetime.date(2025, 9, 19), 0.7447609878594884, 4), (datetime.date(2025, 9, 20), 0.7310029720904508, 4), (datetime.date(2025, 9, 21), 0.77813218506254, 4), (datetime.date(2025, 9, 22), 0.7427996564259507, 4), (datetime.date(2025, 9, 23), 0.7377019211564426, 2), (datetime.date(2025, 9, 24), 0.7045242021639202, 2), (datetime.date(2025, 9, 25), 0.6964141201834844, 3), (datetime.date(2025, 9, 26), 0.6907212917645248, 3), (datetime.date(2025, 9, 27), 0.7158117103047923, 1), (datetime.date(2025, 9, 28), 0.8154757337042492, 4), (datetime.date(2025, 9, 29), 0.737117733095536, 2), (datetime.date(2025, 9, 30), 0.7178742513555374, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 9, 1), 0.8011543739050232, 4), (datetime.date(2025, 9, 2), 0.7627509501344351, 4), (datetime.date(2025, 9, 3), 0.7342988097871931, 4), (datetime.date(2025, 9, 4), 0.7122769821400514, 4), (datetime.date(2025, 9, 5), 0.7082009732340379, 4), (datetime.date(2025, 9, 6), 0.667441490369834, 4), (datetime.date(2025, 9, 7), 0.7363282247804429, 4), (datetime.date(2025, 9, 8), 0.7566882254933288, 4), (datetime.date(2025, 9, 9), 0.7588587437703574, 3), (datetime.date(2025, 9, 10), 0.7383355611073947, 3), (datetime.date(2025, 9, 11), 0.7513735999138669, 2), (datetime.date(2025, 9, 12), 0.7289164595870451, 3), (datetime.date(2025, 9, 15), 0.7839672757263989, 4), (datetime.date(2025, 9, 16), 0.7552223372701388, 3), (datetime.date(2025, 9, 17), 0.7128435985976017, 4), (datetime.date(2025, 9, 18), 0.7104241202031673, 4), (datetime.date(2025, 9, 19), 0.7447609878594884, 4), (datetime.date(2025, 9, 20), 0.7310029720904508, 4), (datetime.date(2025, 9, 21), 0.77813218506254, 4), (datetime.date(2025, 9, 22), 0.7427996564259507, 4), (datetime.date(2025, 9, 23), 0.7377019211564426, 2), (datetime.date(2025, 9, 24), 0.7045242021639202, 2), (datetime.date(2025, 9, 25), 0.6964141201834844, 3), (datetime.date(2025, 9, 26), 0.6907212917645248, 3), (datetime.date(2025, 9, 27), 0.7158117103047923, 1), (datetime.date(2025, 9, 28), 0.8154757337042492, 4), (datetime.date(2025, 9, 29), 0.737117733095536, 2), (datetime.date(2025, 9, 30), 0.7178742513555374, 1))}, 'quality_array': [['-8.019005432730776', '01092025'], ['-8.099621419673623', '02092025'], ['-8.190598668540646', '03092025'], ['-8.223616148470331', '04092025'], ['-8.511386338946952', '05092025'], ['-8.474652570149265', '06092025'], ['-8.4027831044465', '07092025'], ['-8.21640405849506', '08092025'], ['-8.015188074337155', '09092025'], ['-8.100860677389237', '10092025'], ['-8.11044860588533', '11092025'], ['-8.330115282313296', '12092025'], ['-8.066554847718894', '15092025'], ['-8.095630153033415', '16092025'], ['-8.251715494632451', '17092025'], ['-8.232428009911736', '18092025'], ['-8.568997771746025', '19092025'], ['-8.430140251367023', '20092025'], ['-8.278487104298346', '21092025'], ['-8.179498764003636', '22092025'], ['-8.15304639224327', '23092025'], ['-8.425952392769728', '24092025'], ['-8.524101286813371', '25092025'], ['-8.579179127539973', '26092025'], ['-8.380663772876144', '27092025'], ['-8.332023329019675', '28092025'], ['-8.163845718527712', '29092025'], ['-8.187986449623201', '30092025']], 'number_of_batch': ((622,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013236589271647477, 'nb_photo': 18982, 'list_port_cont': '26416317,26416349,26416559,26416751,26416772,26417047,26417188,26417275,26417406,26417558,26417696,26418087,26418105,26418191,26418248,26418318,26418475,26418753,26418841,26418986,26419022,26419235,26419263,26419767,26458894,26461701,26462068,26462186,26462289,26462326,26462428,26462531,26462726,26462766,26462955,26463037,26463298,26463321,26463454,26463556,26463729,26463780,26463858,26463908,26464371,26465102,26467550,26468323,26504261,26506320,26506705,26506761,26507141,26507729,26507826,26507988,26508364,26508498,26508605,26509220,26509363,26509604,26509672,26509736,26509798,26510107,26510414,26510637,26511371,26511421,26511704,26514261,26544231,26544532,26547161,26549858,26550064,26550113,26550440,26550536,26550905,26551152,26552675,26615606,26616514,26616671,26616882,26616930,26617082,26617338,26617373,26617439,26617691,26617844,26618121,26618319,26660314,26663220,26666074,26914531,26915210,26915339,26915631,26916211,26916718,26917124,26917571,26918560,26920448,26921580,26921614,26923385,26923842,2692414', 'assoc_port': '26415979:26419263,26415982:26418841,26415985:26419022,26415988:26419235,26415991:26418753,26415994:26418986,26415997:26418105,26416000:26418318,26416003:26418087,26416006:26418248,26416008:26418191,26416010:26417696,26416012:26417558,26416014:26417188,26416016:26417406,26416018:26417047,26416020:26417275,26416022:26416772,26416024:26416559,26416026:26416751,26416028:26416349,26416030:26416317,26418181:26418475,26419549:26419767,26458278:26462289,26458281:26462531,26458282:26465102,26458284:26463037,26458285:26463298,26458286:26463454,26458288:26463858,26458289:26463908,26458303:26463729,26458304:26468323,26458309:26463780,26458319:26463556,26458321:26467550,26458322:26463321,26458323:26462955,26458324:26462766,26458325:26462726,26458327:26462326,26458328:26462428,26458329:26462068,26458330:26458894,26458331:26462186,26461167:26461701,26463697:26464371,26495026:26504261,26505114:26511704,26505118:26511421,26505122:26509220,26505125:26514261,26505130:26509604,26505132:26510107,26505136:26510637,26505139:2651041', 'assoc_mat': '26415979:autre:4230:26419263,26415982:autre:4230:26418841,26415985:autre:4230:26419022,26415988:autre:4230:26419235,26415991:autre:4230:26418753,26415994:autre:4230:26418986,26415997:autre:4230:26418105,26416000:autre:4230:26418318,26416003:autre:4230:26418087,26416006:autre:4230:26418248,26416008:autre:4230:26418191,26416010:autre:4230:26417696,26416012:autre:4230:26417558,26416014:autre:4230:26417188,26416016:autre:4230:26417406,26416018:autre:4230:26417047,26416020:autre:4230:26417275,26416022:autre:4230:26416772,26416024:autre:4230:26416559,26416026:autre:4230:26416751,26416028:autre:4230:26416349,26416030:autre:4230:26416317,26418181:autre:4230:26418475,26419549:autre:4230:26419767,26458278:autre:4230:26462289,26458281:autre:4230:26462531,26458282:autre:4230:26465102,26458284:autre:4230:26463037,26458285:autre:4230:26463298,26458286:autre:4230:26463454,26458288:autre:4230:26463858,26458289:autre:4230:26463908,26458303:autre:4230:26463729,26458304:autre:4230:26468323,26458309:autre:4230:26463780,26458319:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04430504606939476, 'nb_photo': 89845, 'list_port_cont': '26416327,26416365,26416570,26416756,26416771,26417053,26417192,26417277,26417396,26417560,26417701,26418082,26418091,26418205,26418256,26418320,26418486,26418768,26418839,26418988,26419018,26419226,26419267,26419758,26458904,26461695,26462063,26462182,26462285,26462338,26462437,26462534,26462719,26462776,26462952,26463038,26463300,26463337,26463458,26463555,26463738,26463784,26463857,26463925,26464379,26465093,26467560,26468316,26504257,26506316,26506708,26506764,26507148,26507741,26507832,26507987,26508376,26508503,26508616,26509219,26509361,26509619,26509685,26509748,26509813,26510110,26510421,26510645,26511368,26511426,26511702,26514269,26544245,26544548,26547168,26549870,26550063,26550118,26550448,26550550,26550893,26551162,26552676,26615616,26616530,26616665,26616893,26616923,26617089,26617349,26617380,26617436,26617693,26617857,26618124,26618328,26660319,26663247,26666077,26914525,26915208,26915335,26915644,26916221,26916722,26917127,26917565,26918553,26920451,26921571,26921622,26923392,26923839,2692414', 'assoc_port': '26415979:26419267,26415982:26418839,26415985:26419018,26415988:26419226,26415991:26418768,26415994:26418988,26415997:26418082,26416000:26418320,26416003:26418091,26416006:26418256,26416008:26418205,26416010:26417701,26416012:26417560,26416014:26417192,26416016:26417396,26416018:26417053,26416020:26417277,26416022:26416771,26416024:26416570,26416026:26416756,26416028:26416365,26416030:26416327,26418181:26418486,26419549:26419758,26458278:26462285,26458281:26462534,26458282:26465093,26458284:26463038,26458285:26463300,26458286:26463458,26458288:26463857,26458289:26463925,26458303:26463738,26458304:26468316,26458309:26463784,26458319:26463555,26458321:26467560,26458322:26463337,26458323:26462952,26458324:26462776,26458325:26462719,26458327:26462338,26458328:26462437,26458329:26462063,26458330:26458904,26458331:26462182,26461167:26461695,26463697:26464379,26495026:26504257,26505114:26511702,26505118:26511426,26505122:26509219,26505125:26514269,26505130:26509619,26505132:26510110,26505136:26510645,26505139:2651042', 'assoc_mat': '26415979:carton:4230:26419267,26415982:carton:4230:26418839,26415985:carton:4230:26419018,26415988:carton:4230:26419226,26415991:carton:4230:26418768,26415994:carton:4230:26418988,26415997:carton:4230:26418082,26416000:carton:4230:26418320,26416003:carton:4230:26418091,26416006:carton:4230:26418256,26416008:carton:4230:26418205,26416010:carton:4230:26417701,26416012:carton:4230:26417560,26416014:carton:4230:26417192,26416016:carton:4230:26417396,26416018:carton:4230:26417053,26416020:carton:4230:26417277,26416022:carton:4230:26416771,26416024:carton:4230:26416570,26416026:carton:4230:26416756,26416028:carton:4230:26416365,26416030:carton:4230:26416327,26418181:carton:4230:26418486,26419549:carton:4230:26419758,26458278:carton:4230:26462285,26458281:carton:4230:26462534,26458282:carton:4230:26465093,26458284:carton:4230:26463038,26458285:carton:4230:26463300,26458286:carton:4230:26463458,26458288:carton:4230:26463857,26458289:carton:4230:26463925,26458303:carton:4230:26463738,26458304:carton:4230:26468316,2645'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011785902860642317, 'nb_photo': 1620, 'list_port_cont': '26416357,26416777,26417045,26417198,26417268,26417394,26417544,26417692,26418079,26418088,26418201,26418245,26418325,26418764,26418978,26419015,26419768,26458902,26461692,26462175,26462334,26462438,26462720,26462778,26462946,26463030,26463551,26463741,26463781,26463843,26463914,26467552,26468320,26504256,26506304,26506715,26506772,26507133,26507816,26507986,26508378,26508601,26509210,26509362,26509609,26509678,26509738,26509801,26510100,26510417,26510636,26511379,26511430,26511694,26544239,26544542,26547167,26550059,26550438,26550549,26550882,26551149,26615605,26616529,26616666,26616881,26616926,26617334,26617376,26617425,26617679,26617856,26618120,26618327,26914530,26915199,26915327,26915633,26916220,26916735,26917562,26918559,26920438,26921573,26921606,26923829,26925815,26927577,26930675,26933668,26936552,26939787,26942276,26942319,26942576,26942620,26942716,26944025,26944248,26945848,26946715,26946859,26947257,26947923,26950595,26951015,26951668,26952001,26952092,26952242,26952338,26952604,26954423,2695452', 'assoc_port': '26415985:26419015,26415991:26418764,26415994:26418978,26415997:26418088,26416000:26418325,26416003:26418079,26416006:26418245,26416008:26418201,26416010:26417692,26416012:26417544,26416014:26417198,26416016:26417394,26416018:26417045,26416020:26417268,26416022:26416777,26416028:26416357,26419549:26419768,26458284:26463030,26458288:26463843,26458289:26463914,26458303:26463741,26458304:26468320,26458309:26463781,26458319:26463551,26458321:26467552,26458323:26462946,26458324:26462778,26458325:26462720,26458327:26462334,26458328:26462438,26458330:26458902,26458331:26462175,26461167:26461692,26495026:26504256,26505114:26511694,26505118:26511430,26505122:26509210,26505130:26509609,26505132:26510100,26505136:26510636,26505139:26510417,26505143:26509678,26505153:26509738,26505162:26509362,26505165:26509801,26505181:26508378,26505189:26507986,26505191:26506772,26505194:26507816,26505196:26507133,26505211:26506715,26505213:26506304,26508175:26508601,26510965:26511379,26537063:26544542,26543356:26544239,26546215:2655088', 'assoc_mat': '26415985:metal:4230:26419015,26415991:metal:4230:26418764,26415994:metal:4230:26418978,26415997:metal:4230:26418088,26416000:metal:4230:26418325,26416003:metal:4230:26418079,26416006:metal:4230:26418245,26416008:metal:4230:26418201,26416010:metal:4230:26417692,26416012:metal:4230:26417544,26416014:metal:4230:26417198,26416016:metal:4230:26417394,26416018:metal:4230:26417045,26416020:metal:4230:26417268,26416022:metal:4230:26416777,26416028:metal:4230:26416357,26419549:metal:4230:26419768,26458284:metal:4230:26463030,26458288:metal:4230:26463843,26458289:metal:4230:26463914,26458303:metal:4230:26463741,26458304:metal:4230:26468320,26458309:metal:4230:26463781,26458319:metal:4230:26463551,26458321:metal:4230:26467552,26458323:metal:4230:26462946,26458324:metal:4230:26462778,26458325:metal:4230:26462720,26458327:metal:4230:26462334,26458328:metal:4230:26462438,26458330:metal:4230:26458902,26458331:metal:4230:26462175,26461167:metal:4230:26461692,26495026:metal:4230:26504256,26505114:metal:4230:26511694,26505118:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20031969187736914, 'nb_photo': 512319, 'list_port_cont': '26416321,26416361,26416573,26416762,26416773,26417036,26417196,26417279,26417399,26417559,26417700,26418093,26418103,26418202,26418252,26418331,26418482,26418761,26418836,26418984,26419021,26419232,26419264,26419761,26458903,26461696,26462059,26462187,26462288,26462335,26462439,26462530,26462729,26462773,26462949,26463040,26463299,26463334,26463451,26463541,26463744,26463779,26463851,26463917,26464367,26465101,26467563,26468329,26504258,26506317,26506716,26506775,26507140,26507740,26507818,26507985,26508377,26508496,26508610,26509209,26509355,26509610,26509689,26509747,26509804,26510115,26510426,26510650,26511377,26511428,26511708,26514266,26544243,26544547,26547174,26549869,26550065,26550124,26550447,26550548,26550909,26551158,26552672,26615617,26616527,26616657,26616894,26616929,26617095,26617347,26617389,26617442,26617692,26617851,26618123,26618313,26660308,26663230,26666079,26914529,26915209,26915337,26915645,26916222,26916726,26917117,26917577,26918566,26920446,26921582,26921619,26923383,26923835,2692414', 'assoc_port': '26415979:26419264,26415982:26418836,26415985:26419021,26415988:26419232,26415991:26418761,26415994:26418984,26415997:26418103,26416000:26418331,26416003:26418093,26416006:26418252,26416008:26418202,26416010:26417700,26416012:26417559,26416014:26417196,26416016:26417399,26416018:26417036,26416020:26417279,26416022:26416773,26416024:26416573,26416026:26416762,26416028:26416361,26416030:26416321,26418181:26418482,26419549:26419761,26458278:26462288,26458281:26462530,26458282:26465101,26458284:26463040,26458285:26463299,26458286:26463451,26458288:26463851,26458289:26463917,26458303:26463744,26458304:26468329,26458309:26463779,26458319:26463541,26458321:26467563,26458322:26463334,26458323:26462949,26458324:26462773,26458325:26462729,26458327:26462335,26458328:26462439,26458329:26462059,26458330:26458903,26458331:26462187,26461167:26461696,26463697:26464367,26495026:26504258,26505114:26511708,26505118:26511428,26505122:26509209,26505125:26514266,26505130:26509610,26505132:26510115,26505136:26510650,26505139:2651042', 'assoc_mat': '26415979:papier:4230:26419264,26415982:papier:4230:26418836,26415985:papier:4230:26419021,26415988:papier:4230:26419232,26415991:papier:4230:26418761,26415994:papier:4230:26418984,26415997:papier:4230:26418103,26416000:papier:4230:26418331,26416003:papier:4230:26418093,26416006:papier:4230:26418252,26416008:papier:4230:26418202,26416010:papier:4230:26417700,26416012:papier:4230:26417559,26416014:papier:4230:26417196,26416016:papier:4230:26417399,26416018:papier:4230:26417036,26416020:papier:4230:26417279,26416022:papier:4230:26416773,26416024:papier:4230:26416573,26416026:papier:4230:26416762,26416028:papier:4230:26416361,26416030:papier:4230:26416321,26418181:papier:4230:26418482,26419549:papier:4230:26419761,26458278:papier:4230:26462288,26458281:papier:4230:26462530,26458282:papier:4230:26465101,26458284:papier:4230:26463040,26458285:papier:4230:26463299,26458286:papier:4230:26463451,26458288:papier:4230:26463851,26458289:papier:4230:26463917,26458303:papier:4230:26463744,26458304:papier:4230:26468329,2645'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0033031419070453033, 'nb_photo': 3198, 'list_port_cont': '26416760,26417039,26417189,26417555,26417697,26418077,26418097,26418203,26418257,26418326,26418484,26418766,26418833,26418987,26419016,26419229,26419259,26458899,26461693,26462056,26462177,26462290,26462333,26462435,26462525,26462712,26462956,26463289,26463336,26463557,26463737,26463785,26463859,26463922,26464378,26467565,26468324,26504254,26506310,26506712,26506774,26507150,26507745,26507820,26507992,26508367,26508502,26508615,26509366,26509683,26509751,26509811,26510106,26510427,26510651,26511378,26511418,26511707,26514267,26544242,26544537,26547175,26549872,26550060,26550120,26550435,26550545,26550901,26551160,26552670,26615618,26616528,26616670,26616889,26616932,26617086,26617344,26617386,26617441,26617694,26617855,26618127,26618326,26660317,26663236,26666080,26915207,26915334,26915643,26916215,26916730,26917126,26917576,26918567,26920447,26921584,26921610,26923384,26924145,26925811,26927584,26930665,26933670,26936556,26939792,26940695,26941284,26941958,26942311,26942408,26942578,26942615,26942717,2694386', 'assoc_port': '26415979:26419259,26415982:26418833,26415985:26419016,26415988:26419229,26415991:26418766,26415994:26418987,26415997:26418097,26416000:26418326,26416003:26418077,26416006:26418257,26416008:26418203,26416010:26417697,26416012:26417555,26416014:26417189,26416018:26417039,26416026:26416760,26418181:26418484,26458278:26462290,26458281:26462525,26458285:26463289,26458288:26463859,26458289:26463922,26458303:26463737,26458304:26468324,26458309:26463785,26458319:26463557,26458321:26467565,26458322:26463336,26458323:26462956,26458325:26462712,26458327:26462333,26458328:26462435,26458329:26462056,26458330:26458899,26458331:26462177,26461167:26461693,26463697:26464378,26495026:26504254,26505114:26511707,26505118:26511418,26505125:26514267,26505132:26510106,26505136:26510651,26505139:26510427,26505143:26509683,26505153:26509751,26505162:26509366,26505165:26509811,26505181:26508367,26505183:26508502,26505185:26507745,26505189:26507992,26505191:26506774,26505194:26507820,26505196:26507150,26505211:26506712,26505213:2650631', 'assoc_mat': '26415979:pehd:4230:26419259,26415982:pehd:4230:26418833,26415985:pehd:4230:26419016,26415988:pehd:4230:26419229,26415991:pehd:4230:26418766,26415994:pehd:4230:26418987,26415997:pehd:4230:26418097,26416000:pehd:4230:26418326,26416003:pehd:4230:26418077,26416006:pehd:4230:26418257,26416008:pehd:4230:26418203,26416010:pehd:4230:26417697,26416012:pehd:4230:26417555,26416014:pehd:4230:26417189,26416018:pehd:4230:26417039,26416026:pehd:4230:26416760,26418181:pehd:4230:26418484,26458278:pehd:4230:26462290,26458281:pehd:4230:26462525,26458285:pehd:4230:26463289,26458288:pehd:4230:26463859,26458289:pehd:4230:26463922,26458303:pehd:4230:26463737,26458304:pehd:4230:26468324,26458309:pehd:4230:26463785,26458319:pehd:4230:26463557,26458321:pehd:4230:26467565,26458322:pehd:4230:26463336,26458323:pehd:4230:26462956,26458325:pehd:4230:26462712,26458327:pehd:4230:26462333,26458328:pehd:4230:26462435,26458329:pehd:4230:26462056,26458330:pehd:4230:26458899,26458331:pehd:4230:26462177,26461167:pehd:4230:26461693,26463697:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013248421750777704, 'nb_photo': 19724, 'list_port_cont': '26416323,26416364,26416571,26416763,26416780,26417051,26417194,26417269,26417403,26417549,26417698,26418085,26418099,26418192,26418242,26418332,26418481,26418757,26418831,26418985,26419019,26419230,26419271,26419764,26458905,26461688,26462064,26462179,26462295,26462337,26462430,26462528,26462725,26462777,26462958,26463043,26463301,26463330,26463457,26463550,26463740,26463777,26463860,26463921,26464377,26465097,26467559,26468325,26504260,26506322,26506713,26506773,26507144,26507744,26507830,26507989,26508369,26508500,26508606,26509215,26509359,26509615,26509682,26509743,26509810,26510101,26510418,26510652,26511375,26511424,26511701,26514256,26544244,26544543,26547164,26549864,26550058,26550116,26550445,26550552,26550903,26551156,26552678,26615622,26616522,26616664,26616879,26616934,26617090,26617341,26617378,26617440,26617695,26617858,26618129,26618321,26660315,26663243,26666072,26914524,26915202,26915324,26915641,26916223,26916734,26917129,26917575,26918564,26920444,26921585,26921611,26923395,26923843,2692413', 'assoc_port': '26415979:26419271,26415982:26418831,26415985:26419019,26415988:26419230,26415991:26418757,26415994:26418985,26415997:26418099,26416000:26418332,26416003:26418085,26416006:26418242,26416008:26418192,26416010:26417698,26416012:26417549,26416014:26417194,26416016:26417403,26416018:26417051,26416020:26417269,26416022:26416780,26416024:26416571,26416026:26416763,26416028:26416364,26416030:26416323,26418181:26418481,26419549:26419764,26458278:26462295,26458281:26462528,26458282:26465097,26458284:26463043,26458285:26463301,26458286:26463457,26458288:26463860,26458289:26463921,26458303:26463740,26458304:26468325,26458309:26463777,26458319:26463550,26458321:26467559,26458322:26463330,26458323:26462958,26458324:26462777,26458325:26462725,26458327:26462337,26458328:26462430,26458329:26462064,26458330:26458905,26458331:26462179,26461167:26461688,26463697:26464377,26495026:26504260,26505114:26511701,26505118:26511424,26505122:26509215,26505125:26514256,26505130:26509615,26505132:26510101,26505136:26510652,26505139:2651041', 'assoc_mat': '26415979:pet_clair:4230:26419271,26415982:pet_clair:4230:26418831,26415985:pet_clair:4230:26419019,26415988:pet_clair:4230:26419230,26415991:pet_clair:4230:26418757,26415994:pet_clair:4230:26418985,26415997:pet_clair:4230:26418099,26416000:pet_clair:4230:26418332,26416003:pet_clair:4230:26418085,26416006:pet_clair:4230:26418242,26416008:pet_clair:4230:26418192,26416010:pet_clair:4230:26417698,26416012:pet_clair:4230:26417549,26416014:pet_clair:4230:26417194,26416016:pet_clair:4230:26417403,26416018:pet_clair:4230:26417051,26416020:pet_clair:4230:26417269,26416022:pet_clair:4230:26416780,26416024:pet_clair:4230:26416571,26416026:pet_clair:4230:26416763,26416028:pet_clair:4230:26416364,26416030:pet_clair:4230:26416323,26418181:pet_clair:4230:26418481,26419549:pet_clair:4230:26419764,26458278:pet_clair:4230:26462295,26458281:pet_clair:4230:26462528,26458282:pet_clair:4230:26465097,26458284:pet_clair:4230:26463043,26458285:pet_clair:4230:26463301,26458286:pet_clair:4230:26463457,26458288:pet_clair:4230:26463860,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023696051994389713, 'nb_photo': 1257, 'list_port_cont': '26417041,26417547,26417691,26418095,26418204,26418255,26418983,26419020,26419234,26458895,26461694,26462066,26462188,26462951,26463324,26463554,26463745,26463782,26463848,26464368,26467567,26468328,26504252,26506314,26506707,26507139,26507736,26507812,26508372,26509221,26509365,26509618,26509808,26510428,26511376,26511429,26511709,26514265,26544246,26544541,26547187,26549874,26550055,26550121,26550551,26550890,26551155,26552679,26615615,26616521,26616668,26616891,26616927,26617085,26617350,26617387,26617433,26617686,26617854,26618128,26618323,26660316,26666082,26915198,26915338,26915640,26916225,26916728,26917113,26917572,26920445,26921578,26921621,26923393,26923828,26924140,26925822,26927578,26930669,26933671,26936548,26939803,26940680,26941280,26942273,26942317,26942565,26942623,26942704,26943868,26944031,26944257,26944293,26945860,26946181,26946712,26947720,26947934,26950939,26951670,26952009,26952090,26952244,26952344,26952593,26954424,26954522,26954883,26955157,26955882,26956059,26956178,26957233,2695862', 'assoc_port': '26415985:26419020,26415988:26419234,26415994:26418983,26416003:26418095,26416006:26418255,26416008:26418204,26416010:26417691,26416012:26417547,26416018:26417041,26458288:26463848,26458303:26463745,26458304:26468328,26458309:26463782,26458319:26463554,26458321:26467567,26458322:26463324,26458323:26462951,26458329:26462066,26458330:26458895,26458331:26462188,26461167:26461694,26463697:26464368,26495026:26504252,26505114:26511709,26505118:26511429,26505122:26509221,26505125:26514265,26505130:26509618,26505139:26510428,26505162:26509365,26505165:26509808,26505181:26508372,26505185:26507736,26505194:26507812,26505196:26507139,26505211:26506707,26505213:26506314,26510965:26511376,26537063:26544541,26543356:26544246,26546215:26550890,26546218:26551155,26546220:26550551,26546223:26550121,26546237:26549874,26546242:26547187,26549409:26550055,26551983:26552679,26615403:26615615,26615975:26617854,26615977:26617686,26615980:26617433,26615982:26617350,26615985:26617085,26615987:26617387,26615990:26616927,26615992:2661689', 'assoc_mat': '26415985:pet_fonce:4230:26419020,26415988:pet_fonce:4230:26419234,26415994:pet_fonce:4230:26418983,26416003:pet_fonce:4230:26418095,26416006:pet_fonce:4230:26418255,26416008:pet_fonce:4230:26418204,26416010:pet_fonce:4230:26417691,26416012:pet_fonce:4230:26417547,26416018:pet_fonce:4230:26417041,26458288:pet_fonce:4230:26463848,26458303:pet_fonce:4230:26463745,26458304:pet_fonce:4230:26468328,26458309:pet_fonce:4230:26463782,26458319:pet_fonce:4230:26463554,26458321:pet_fonce:4230:26467567,26458322:pet_fonce:4230:26463324,26458323:pet_fonce:4230:26462951,26458329:pet_fonce:4230:26462066,26458330:pet_fonce:4230:26458895,26458331:pet_fonce:4230:26462188,26461167:pet_fonce:4230:26461694,26463697:pet_fonce:4230:26464368,26495026:pet_fonce:4230:26504252,26505114:pet_fonce:4230:26511709,26505118:pet_fonce:4230:26511429,26505122:pet_fonce:4230:26509221,26505125:pet_fonce:4230:26514265,26505130:pet_fonce:4230:26509618,26505139:pet_fonce:4230:26510428,26505162:pet_fonce:4230:26509365,26505165:pet_fonce:4230:26509808,2'}), 'main_stat': {'nb_photos': 1999}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-09', 0.7361914632655978),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1999,),), 'unwanted_material_monthly_percentage': ((0.7361914632655978,),), 'material_repartition': (('incineration', 1999),), 'material_dict': {'incineration': 1999}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 9, 1), 0.8011543739050232, 4), (datetime.date(2025, 9, 2), 0.7627509501344351, 4), (datetime.date(2025, 9, 3), 0.7342988097871931, 4), (datetime.date(2025, 9, 4), 0.7122769821400514, 4), (datetime.date(2025, 9, 5), 0.7082009732340379, 4), (datetime.date(2025, 9, 6), 0.667441490369834, 4), (datetime.date(2025, 9, 7), 0.7363282247804429, 4), (datetime.date(2025, 9, 8), 0.7566882254933288, 4), (datetime.date(2025, 9, 9), 0.7588587437703574, 3), (datetime.date(2025, 9, 10), 0.7383355611073947, 3), (datetime.date(2025, 9, 11), 0.7513735999138669, 2), (datetime.date(2025, 9, 12), 0.7289164595870451, 3), (datetime.date(2025, 9, 15), 0.7839672757263989, 4), (datetime.date(2025, 9, 16), 0.7552223372701388, 3), (datetime.date(2025, 9, 17), 0.7128435985976017, 4), (datetime.date(2025, 9, 18), 0.7104241202031673, 4), (datetime.date(2025, 9, 19), 0.7447609878594884, 4), (datetime.date(2025, 9, 20), 0.7310029720904508, 4), (datetime.date(2025, 9, 21), 0.77813218506254, 4), (datetime.date(2025, 9, 22), 0.7427996564259507, 4), (datetime.date(2025, 9, 23), 0.7377019211564426, 2), (datetime.date(2025, 9, 24), 0.7045242021639202, 2), (datetime.date(2025, 9, 25), 0.6964141201834844, 3), (datetime.date(2025, 9, 26), 0.6907212917645248, 3), (datetime.date(2025, 9, 27), 0.7158117103047923, 1), (datetime.date(2025, 9, 28), 0.8154757337042492, 4), (datetime.date(2025, 9, 29), 0.737117733095536, 2), (datetime.date(2025, 9, 30), 0.7178742513555374, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 9, 1), 0.8011543739050232, 4), (datetime.date(2025, 9, 2), 0.7627509501344351, 4), (datetime.date(2025, 9, 3), 0.7342988097871931, 4), (datetime.date(2025, 9, 4), 0.7122769821400514, 4), (datetime.date(2025, 9, 5), 0.7082009732340379, 4), (datetime.date(2025, 9, 6), 0.667441490369834, 4), (datetime.date(2025, 9, 7), 0.7363282247804429, 4), (datetime.date(2025, 9, 8), 0.7566882254933288, 4), (datetime.date(2025, 9, 9), 0.7588587437703574, 3), (datetime.date(2025, 9, 10), 0.7383355611073947, 3), (datetime.date(2025, 9, 11), 0.7513735999138669, 2), (datetime.date(2025, 9, 12), 0.7289164595870451, 3), (datetime.date(2025, 9, 15), 0.7839672757263989, 4), (datetime.date(2025, 9, 16), 0.7552223372701388, 3), (datetime.date(2025, 9, 17), 0.7128435985976017, 4), (datetime.date(2025, 9, 18), 0.7104241202031673, 4), (datetime.date(2025, 9, 19), 0.7447609878594884, 4), (datetime.date(2025, 9, 20), 0.7310029720904508, 4), (datetime.date(2025, 9, 21), 0.77813218506254, 4), (datetime.date(2025, 9, 22), 0.7427996564259507, 4), (datetime.date(2025, 9, 23), 0.7377019211564426, 2), (datetime.date(2025, 9, 24), 0.7045242021639202, 2), (datetime.date(2025, 9, 25), 0.6964141201834844, 3), (datetime.date(2025, 9, 26), 0.6907212917645248, 3), (datetime.date(2025, 9, 27), 0.7158117103047923, 1), (datetime.date(2025, 9, 28), 0.8154757337042492, 4), (datetime.date(2025, 9, 29), 0.737117733095536, 2), (datetime.date(2025, 9, 30), 0.7178742513555374, 1))}, 'quality_array': [['-8.019005432730776', '01092025'], ['-8.099621419673623', '02092025'], ['-8.190598668540646', '03092025'], ['-8.223616148470331', '04092025'], ['-8.511386338946952', '05092025'], ['-8.474652570149265', '06092025'], ['-8.4027831044465', '07092025'], ['-8.21640405849506', '08092025'], ['-8.015188074337155', '09092025'], ['-8.100860677389237', '10092025'], ['-8.11044860588533', '11092025'], ['-8.330115282313296', '12092025'], ['-8.066554847718894', '15092025'], ['-8.095630153033415', '16092025'], ['-8.251715494632451', '17092025'], ['-8.232428009911736', '18092025'], ['-8.568997771746025', '19092025'], ['-8.430140251367023', '20092025'], ['-8.278487104298346', '21092025'], ['-8.179498764003636', '22092025'], ['-8.15304639224327', '23092025'], ['-8.425952392769728', '24092025'], ['-8.524101286813371', '25092025'], ['-8.579179127539973', '26092025'], ['-8.380663772876144', '27092025'], ['-8.332023329019675', '28092025'], ['-8.163845718527712', '29092025'], ['-8.187986449623201', '30092025']], 'number_of_batch': ((622,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013236589271647477, 'nb_photo': 18982, 'list_port_cont': '26416317,26416349,26416559,26416751,26416772,26417047,26417188,26417275,26417406,26417558,26417696,26418087,26418105,26418191,26418248,26418318,26418475,26418753,26418841,26418986,26419022,26419235,26419263,26419767,26458894,26461701,26462068,26462186,26462289,26462326,26462428,26462531,26462726,26462766,26462955,26463037,26463298,26463321,26463454,26463556,26463729,26463780,26463858,26463908,26464371,26465102,26467550,26468323,26504261,26506320,26506705,26506761,26507141,26507729,26507826,26507988,26508364,26508498,26508605,26509220,26509363,26509604,26509672,26509736,26509798,26510107,26510414,26510637,26511371,26511421,26511704,26514261,26544231,26544532,26547161,26549858,26550064,26550113,26550440,26550536,26550905,26551152,26552675,26615606,26616514,26616671,26616882,26616930,26617082,26617338,26617373,26617439,26617691,26617844,26618121,26618319,26660314,26663220,26666074,26914531,26915210,26915339,26915631,26916211,26916718,26917124,26917571,26918560,26920448,26921580,26921614,26923385,26923842,2692414', 'assoc_port': '26415979:26419263,26415982:26418841,26415985:26419022,26415988:26419235,26415991:26418753,26415994:26418986,26415997:26418105,26416000:26418318,26416003:26418087,26416006:26418248,26416008:26418191,26416010:26417696,26416012:26417558,26416014:26417188,26416016:26417406,26416018:26417047,26416020:26417275,26416022:26416772,26416024:26416559,26416026:26416751,26416028:26416349,26416030:26416317,26418181:26418475,26419549:26419767,26458278:26462289,26458281:26462531,26458282:26465102,26458284:26463037,26458285:26463298,26458286:26463454,26458288:26463858,26458289:26463908,26458303:26463729,26458304:26468323,26458309:26463780,26458319:26463556,26458321:26467550,26458322:26463321,26458323:26462955,26458324:26462766,26458325:26462726,26458327:26462326,26458328:26462428,26458329:26462068,26458330:26458894,26458331:26462186,26461167:26461701,26463697:26464371,26495026:26504261,26505114:26511704,26505118:26511421,26505122:26509220,26505125:26514261,26505130:26509604,26505132:26510107,26505136:26510637,26505139:2651041', 'assoc_mat': '26415979:autre:4230:26419263,26415982:autre:4230:26418841,26415985:autre:4230:26419022,26415988:autre:4230:26419235,26415991:autre:4230:26418753,26415994:autre:4230:26418986,26415997:autre:4230:26418105,26416000:autre:4230:26418318,26416003:autre:4230:26418087,26416006:autre:4230:26418248,26416008:autre:4230:26418191,26416010:autre:4230:26417696,26416012:autre:4230:26417558,26416014:autre:4230:26417188,26416016:autre:4230:26417406,26416018:autre:4230:26417047,26416020:autre:4230:26417275,26416022:autre:4230:26416772,26416024:autre:4230:26416559,26416026:autre:4230:26416751,26416028:autre:4230:26416349,26416030:autre:4230:26416317,26418181:autre:4230:26418475,26419549:autre:4230:26419767,26458278:autre:4230:26462289,26458281:autre:4230:26462531,26458282:autre:4230:26465102,26458284:autre:4230:26463037,26458285:autre:4230:26463298,26458286:autre:4230:26463454,26458288:autre:4230:26463858,26458289:autre:4230:26463908,26458303:autre:4230:26463729,26458304:autre:4230:26468323,26458309:autre:4230:26463780,26458319:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.04430504606939476, 'nb_photo': 89845, 'list_port_cont': '26416327,26416365,26416570,26416756,26416771,26417053,26417192,26417277,26417396,26417560,26417701,26418082,26418091,26418205,26418256,26418320,26418486,26418768,26418839,26418988,26419018,26419226,26419267,26419758,26458904,26461695,26462063,26462182,26462285,26462338,26462437,26462534,26462719,26462776,26462952,26463038,26463300,26463337,26463458,26463555,26463738,26463784,26463857,26463925,26464379,26465093,26467560,26468316,26504257,26506316,26506708,26506764,26507148,26507741,26507832,26507987,26508376,26508503,26508616,26509219,26509361,26509619,26509685,26509748,26509813,26510110,26510421,26510645,26511368,26511426,26511702,26514269,26544245,26544548,26547168,26549870,26550063,26550118,26550448,26550550,26550893,26551162,26552676,26615616,26616530,26616665,26616893,26616923,26617089,26617349,26617380,26617436,26617693,26617857,26618124,26618328,26660319,26663247,26666077,26914525,26915208,26915335,26915644,26916221,26916722,26917127,26917565,26918553,26920451,26921571,26921622,26923392,26923839,2692414', 'assoc_port': '26415979:26419267,26415982:26418839,26415985:26419018,26415988:26419226,26415991:26418768,26415994:26418988,26415997:26418082,26416000:26418320,26416003:26418091,26416006:26418256,26416008:26418205,26416010:26417701,26416012:26417560,26416014:26417192,26416016:26417396,26416018:26417053,26416020:26417277,26416022:26416771,26416024:26416570,26416026:26416756,26416028:26416365,26416030:26416327,26418181:26418486,26419549:26419758,26458278:26462285,26458281:26462534,26458282:26465093,26458284:26463038,26458285:26463300,26458286:26463458,26458288:26463857,26458289:26463925,26458303:26463738,26458304:26468316,26458309:26463784,26458319:26463555,26458321:26467560,26458322:26463337,26458323:26462952,26458324:26462776,26458325:26462719,26458327:26462338,26458328:26462437,26458329:26462063,26458330:26458904,26458331:26462182,26461167:26461695,26463697:26464379,26495026:26504257,26505114:26511702,26505118:26511426,26505122:26509219,26505125:26514269,26505130:26509619,26505132:26510110,26505136:26510645,26505139:2651042', 'assoc_mat': '26415979:carton:4230:26419267,26415982:carton:4230:26418839,26415985:carton:4230:26419018,26415988:carton:4230:26419226,26415991:carton:4230:26418768,26415994:carton:4230:26418988,26415997:carton:4230:26418082,26416000:carton:4230:26418320,26416003:carton:4230:26418091,26416006:carton:4230:26418256,26416008:carton:4230:26418205,26416010:carton:4230:26417701,26416012:carton:4230:26417560,26416014:carton:4230:26417192,26416016:carton:4230:26417396,26416018:carton:4230:26417053,26416020:carton:4230:26417277,26416022:carton:4230:26416771,26416024:carton:4230:26416570,26416026:carton:4230:26416756,26416028:carton:4230:26416365,26416030:carton:4230:26416327,26418181:carton:4230:26418486,26419549:carton:4230:26419758,26458278:carton:4230:26462285,26458281:carton:4230:26462534,26458282:carton:4230:26465093,26458284:carton:4230:26463038,26458285:carton:4230:26463300,26458286:carton:4230:26463458,26458288:carton:4230:26463857,26458289:carton:4230:26463925,26458303:carton:4230:26463738,26458304:carton:4230:26468316,2645'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011785902860642317, 'nb_photo': 1620, 'list_port_cont': '26416357,26416777,26417045,26417198,26417268,26417394,26417544,26417692,26418079,26418088,26418201,26418245,26418325,26418764,26418978,26419015,26419768,26458902,26461692,26462175,26462334,26462438,26462720,26462778,26462946,26463030,26463551,26463741,26463781,26463843,26463914,26467552,26468320,26504256,26506304,26506715,26506772,26507133,26507816,26507986,26508378,26508601,26509210,26509362,26509609,26509678,26509738,26509801,26510100,26510417,26510636,26511379,26511430,26511694,26544239,26544542,26547167,26550059,26550438,26550549,26550882,26551149,26615605,26616529,26616666,26616881,26616926,26617334,26617376,26617425,26617679,26617856,26618120,26618327,26914530,26915199,26915327,26915633,26916220,26916735,26917562,26918559,26920438,26921573,26921606,26923829,26925815,26927577,26930675,26933668,26936552,26939787,26942276,26942319,26942576,26942620,26942716,26944025,26944248,26945848,26946715,26946859,26947257,26947923,26950595,26951015,26951668,26952001,26952092,26952242,26952338,26952604,26954423,2695452', 'assoc_port': '26415985:26419015,26415991:26418764,26415994:26418978,26415997:26418088,26416000:26418325,26416003:26418079,26416006:26418245,26416008:26418201,26416010:26417692,26416012:26417544,26416014:26417198,26416016:26417394,26416018:26417045,26416020:26417268,26416022:26416777,26416028:26416357,26419549:26419768,26458284:26463030,26458288:26463843,26458289:26463914,26458303:26463741,26458304:26468320,26458309:26463781,26458319:26463551,26458321:26467552,26458323:26462946,26458324:26462778,26458325:26462720,26458327:26462334,26458328:26462438,26458330:26458902,26458331:26462175,26461167:26461692,26495026:26504256,26505114:26511694,26505118:26511430,26505122:26509210,26505130:26509609,26505132:26510100,26505136:26510636,26505139:26510417,26505143:26509678,26505153:26509738,26505162:26509362,26505165:26509801,26505181:26508378,26505189:26507986,26505191:26506772,26505194:26507816,26505196:26507133,26505211:26506715,26505213:26506304,26508175:26508601,26510965:26511379,26537063:26544542,26543356:26544239,26546215:2655088', 'assoc_mat': '26415985:metal:4230:26419015,26415991:metal:4230:26418764,26415994:metal:4230:26418978,26415997:metal:4230:26418088,26416000:metal:4230:26418325,26416003:metal:4230:26418079,26416006:metal:4230:26418245,26416008:metal:4230:26418201,26416010:metal:4230:26417692,26416012:metal:4230:26417544,26416014:metal:4230:26417198,26416016:metal:4230:26417394,26416018:metal:4230:26417045,26416020:metal:4230:26417268,26416022:metal:4230:26416777,26416028:metal:4230:26416357,26419549:metal:4230:26419768,26458284:metal:4230:26463030,26458288:metal:4230:26463843,26458289:metal:4230:26463914,26458303:metal:4230:26463741,26458304:metal:4230:26468320,26458309:metal:4230:26463781,26458319:metal:4230:26463551,26458321:metal:4230:26467552,26458323:metal:4230:26462946,26458324:metal:4230:26462778,26458325:metal:4230:26462720,26458327:metal:4230:26462334,26458328:metal:4230:26462438,26458330:metal:4230:26458902,26458331:metal:4230:26462175,26461167:metal:4230:26461692,26495026:metal:4230:26504256,26505114:metal:4230:26511694,26505118:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20031969187736914, 'nb_photo': 512319, 'list_port_cont': '26416321,26416361,26416573,26416762,26416773,26417036,26417196,26417279,26417399,26417559,26417700,26418093,26418103,26418202,26418252,26418331,26418482,26418761,26418836,26418984,26419021,26419232,26419264,26419761,26458903,26461696,26462059,26462187,26462288,26462335,26462439,26462530,26462729,26462773,26462949,26463040,26463299,26463334,26463451,26463541,26463744,26463779,26463851,26463917,26464367,26465101,26467563,26468329,26504258,26506317,26506716,26506775,26507140,26507740,26507818,26507985,26508377,26508496,26508610,26509209,26509355,26509610,26509689,26509747,26509804,26510115,26510426,26510650,26511377,26511428,26511708,26514266,26544243,26544547,26547174,26549869,26550065,26550124,26550447,26550548,26550909,26551158,26552672,26615617,26616527,26616657,26616894,26616929,26617095,26617347,26617389,26617442,26617692,26617851,26618123,26618313,26660308,26663230,26666079,26914529,26915209,26915337,26915645,26916222,26916726,26917117,26917577,26918566,26920446,26921582,26921619,26923383,26923835,2692414', 'assoc_port': '26415979:26419264,26415982:26418836,26415985:26419021,26415988:26419232,26415991:26418761,26415994:26418984,26415997:26418103,26416000:26418331,26416003:26418093,26416006:26418252,26416008:26418202,26416010:26417700,26416012:26417559,26416014:26417196,26416016:26417399,26416018:26417036,26416020:26417279,26416022:26416773,26416024:26416573,26416026:26416762,26416028:26416361,26416030:26416321,26418181:26418482,26419549:26419761,26458278:26462288,26458281:26462530,26458282:26465101,26458284:26463040,26458285:26463299,26458286:26463451,26458288:26463851,26458289:26463917,26458303:26463744,26458304:26468329,26458309:26463779,26458319:26463541,26458321:26467563,26458322:26463334,26458323:26462949,26458324:26462773,26458325:26462729,26458327:26462335,26458328:26462439,26458329:26462059,26458330:26458903,26458331:26462187,26461167:26461696,26463697:26464367,26495026:26504258,26505114:26511708,26505118:26511428,26505122:26509209,26505125:26514266,26505130:26509610,26505132:26510115,26505136:26510650,26505139:2651042', 'assoc_mat': '26415979:papier:4230:26419264,26415982:papier:4230:26418836,26415985:papier:4230:26419021,26415988:papier:4230:26419232,26415991:papier:4230:26418761,26415994:papier:4230:26418984,26415997:papier:4230:26418103,26416000:papier:4230:26418331,26416003:papier:4230:26418093,26416006:papier:4230:26418252,26416008:papier:4230:26418202,26416010:papier:4230:26417700,26416012:papier:4230:26417559,26416014:papier:4230:26417196,26416016:papier:4230:26417399,26416018:papier:4230:26417036,26416020:papier:4230:26417279,26416022:papier:4230:26416773,26416024:papier:4230:26416573,26416026:papier:4230:26416762,26416028:papier:4230:26416361,26416030:papier:4230:26416321,26418181:papier:4230:26418482,26419549:papier:4230:26419761,26458278:papier:4230:26462288,26458281:papier:4230:26462530,26458282:papier:4230:26465101,26458284:papier:4230:26463040,26458285:papier:4230:26463299,26458286:papier:4230:26463451,26458288:papier:4230:26463851,26458289:papier:4230:26463917,26458303:papier:4230:26463744,26458304:papier:4230:26468329,2645'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0033031419070453033, 'nb_photo': 3198, 'list_port_cont': '26416760,26417039,26417189,26417555,26417697,26418077,26418097,26418203,26418257,26418326,26418484,26418766,26418833,26418987,26419016,26419229,26419259,26458899,26461693,26462056,26462177,26462290,26462333,26462435,26462525,26462712,26462956,26463289,26463336,26463557,26463737,26463785,26463859,26463922,26464378,26467565,26468324,26504254,26506310,26506712,26506774,26507150,26507745,26507820,26507992,26508367,26508502,26508615,26509366,26509683,26509751,26509811,26510106,26510427,26510651,26511378,26511418,26511707,26514267,26544242,26544537,26547175,26549872,26550060,26550120,26550435,26550545,26550901,26551160,26552670,26615618,26616528,26616670,26616889,26616932,26617086,26617344,26617386,26617441,26617694,26617855,26618127,26618326,26660317,26663236,26666080,26915207,26915334,26915643,26916215,26916730,26917126,26917576,26918567,26920447,26921584,26921610,26923384,26924145,26925811,26927584,26930665,26933670,26936556,26939792,26940695,26941284,26941958,26942311,26942408,26942578,26942615,26942717,2694386', 'assoc_port': '26415979:26419259,26415982:26418833,26415985:26419016,26415988:26419229,26415991:26418766,26415994:26418987,26415997:26418097,26416000:26418326,26416003:26418077,26416006:26418257,26416008:26418203,26416010:26417697,26416012:26417555,26416014:26417189,26416018:26417039,26416026:26416760,26418181:26418484,26458278:26462290,26458281:26462525,26458285:26463289,26458288:26463859,26458289:26463922,26458303:26463737,26458304:26468324,26458309:26463785,26458319:26463557,26458321:26467565,26458322:26463336,26458323:26462956,26458325:26462712,26458327:26462333,26458328:26462435,26458329:26462056,26458330:26458899,26458331:26462177,26461167:26461693,26463697:26464378,26495026:26504254,26505114:26511707,26505118:26511418,26505125:26514267,26505132:26510106,26505136:26510651,26505139:26510427,26505143:26509683,26505153:26509751,26505162:26509366,26505165:26509811,26505181:26508367,26505183:26508502,26505185:26507745,26505189:26507992,26505191:26506774,26505194:26507820,26505196:26507150,26505211:26506712,26505213:2650631', 'assoc_mat': '26415979:pehd:4230:26419259,26415982:pehd:4230:26418833,26415985:pehd:4230:26419016,26415988:pehd:4230:26419229,26415991:pehd:4230:26418766,26415994:pehd:4230:26418987,26415997:pehd:4230:26418097,26416000:pehd:4230:26418326,26416003:pehd:4230:26418077,26416006:pehd:4230:26418257,26416008:pehd:4230:26418203,26416010:pehd:4230:26417697,26416012:pehd:4230:26417555,26416014:pehd:4230:26417189,26416018:pehd:4230:26417039,26416026:pehd:4230:26416760,26418181:pehd:4230:26418484,26458278:pehd:4230:26462290,26458281:pehd:4230:26462525,26458285:pehd:4230:26463289,26458288:pehd:4230:26463859,26458289:pehd:4230:26463922,26458303:pehd:4230:26463737,26458304:pehd:4230:26468324,26458309:pehd:4230:26463785,26458319:pehd:4230:26463557,26458321:pehd:4230:26467565,26458322:pehd:4230:26463336,26458323:pehd:4230:26462956,26458325:pehd:4230:26462712,26458327:pehd:4230:26462333,26458328:pehd:4230:26462435,26458329:pehd:4230:26462056,26458330:pehd:4230:26458899,26458331:pehd:4230:26462177,26461167:pehd:4230:26461693,26463697:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013248421750777704, 'nb_photo': 19724, 'list_port_cont': '26416323,26416364,26416571,26416763,26416780,26417051,26417194,26417269,26417403,26417549,26417698,26418085,26418099,26418192,26418242,26418332,26418481,26418757,26418831,26418985,26419019,26419230,26419271,26419764,26458905,26461688,26462064,26462179,26462295,26462337,26462430,26462528,26462725,26462777,26462958,26463043,26463301,26463330,26463457,26463550,26463740,26463777,26463860,26463921,26464377,26465097,26467559,26468325,26504260,26506322,26506713,26506773,26507144,26507744,26507830,26507989,26508369,26508500,26508606,26509215,26509359,26509615,26509682,26509743,26509810,26510101,26510418,26510652,26511375,26511424,26511701,26514256,26544244,26544543,26547164,26549864,26550058,26550116,26550445,26550552,26550903,26551156,26552678,26615622,26616522,26616664,26616879,26616934,26617090,26617341,26617378,26617440,26617695,26617858,26618129,26618321,26660315,26663243,26666072,26914524,26915202,26915324,26915641,26916223,26916734,26917129,26917575,26918564,26920444,26921585,26921611,26923395,26923843,2692413', 'assoc_port': '26415979:26419271,26415982:26418831,26415985:26419019,26415988:26419230,26415991:26418757,26415994:26418985,26415997:26418099,26416000:26418332,26416003:26418085,26416006:26418242,26416008:26418192,26416010:26417698,26416012:26417549,26416014:26417194,26416016:26417403,26416018:26417051,26416020:26417269,26416022:26416780,26416024:26416571,26416026:26416763,26416028:26416364,26416030:26416323,26418181:26418481,26419549:26419764,26458278:26462295,26458281:26462528,26458282:26465097,26458284:26463043,26458285:26463301,26458286:26463457,26458288:26463860,26458289:26463921,26458303:26463740,26458304:26468325,26458309:26463777,26458319:26463550,26458321:26467559,26458322:26463330,26458323:26462958,26458324:26462777,26458325:26462725,26458327:26462337,26458328:26462430,26458329:26462064,26458330:26458905,26458331:26462179,26461167:26461688,26463697:26464377,26495026:26504260,26505114:26511701,26505118:26511424,26505122:26509215,26505125:26514256,26505130:26509615,26505132:26510101,26505136:26510652,26505139:2651041', 'assoc_mat': '26415979:pet_clair:4230:26419271,26415982:pet_clair:4230:26418831,26415985:pet_clair:4230:26419019,26415988:pet_clair:4230:26419230,26415991:pet_clair:4230:26418757,26415994:pet_clair:4230:26418985,26415997:pet_clair:4230:26418099,26416000:pet_clair:4230:26418332,26416003:pet_clair:4230:26418085,26416006:pet_clair:4230:26418242,26416008:pet_clair:4230:26418192,26416010:pet_clair:4230:26417698,26416012:pet_clair:4230:26417549,26416014:pet_clair:4230:26417194,26416016:pet_clair:4230:26417403,26416018:pet_clair:4230:26417051,26416020:pet_clair:4230:26417269,26416022:pet_clair:4230:26416780,26416024:pet_clair:4230:26416571,26416026:pet_clair:4230:26416763,26416028:pet_clair:4230:26416364,26416030:pet_clair:4230:26416323,26418181:pet_clair:4230:26418481,26419549:pet_clair:4230:26419764,26458278:pet_clair:4230:26462295,26458281:pet_clair:4230:26462528,26458282:pet_clair:4230:26465097,26458284:pet_clair:4230:26463043,26458285:pet_clair:4230:26463301,26458286:pet_clair:4230:26463457,26458288:pet_clair:4230:26463860,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0023696051994389713, 'nb_photo': 1257, 'list_port_cont': '26417041,26417547,26417691,26418095,26418204,26418255,26418983,26419020,26419234,26458895,26461694,26462066,26462188,26462951,26463324,26463554,26463745,26463782,26463848,26464368,26467567,26468328,26504252,26506314,26506707,26507139,26507736,26507812,26508372,26509221,26509365,26509618,26509808,26510428,26511376,26511429,26511709,26514265,26544246,26544541,26547187,26549874,26550055,26550121,26550551,26550890,26551155,26552679,26615615,26616521,26616668,26616891,26616927,26617085,26617350,26617387,26617433,26617686,26617854,26618128,26618323,26660316,26666082,26915198,26915338,26915640,26916225,26916728,26917113,26917572,26920445,26921578,26921621,26923393,26923828,26924140,26925822,26927578,26930669,26933671,26936548,26939803,26940680,26941280,26942273,26942317,26942565,26942623,26942704,26943868,26944031,26944257,26944293,26945860,26946181,26946712,26947720,26947934,26950939,26951670,26952009,26952090,26952244,26952344,26952593,26954424,26954522,26954883,26955157,26955882,26956059,26956178,26957233,2695862', 'assoc_port': '26415985:26419020,26415988:26419234,26415994:26418983,26416003:26418095,26416006:26418255,26416008:26418204,26416010:26417691,26416012:26417547,26416018:26417041,26458288:26463848,26458303:26463745,26458304:26468328,26458309:26463782,26458319:26463554,26458321:26467567,26458322:26463324,26458323:26462951,26458329:26462066,26458330:26458895,26458331:26462188,26461167:26461694,26463697:26464368,26495026:26504252,26505114:26511709,26505118:26511429,26505122:26509221,26505125:26514265,26505130:26509618,26505139:26510428,26505162:26509365,26505165:26509808,26505181:26508372,26505185:26507736,26505194:26507812,26505196:26507139,26505211:26506707,26505213:26506314,26510965:26511376,26537063:26544541,26543356:26544246,26546215:26550890,26546218:26551155,26546220:26550551,26546223:26550121,26546237:26549874,26546242:26547187,26549409:26550055,26551983:26552679,26615403:26615615,26615975:26617854,26615977:26617686,26615980:26617433,26615982:26617350,26615985:26617085,26615987:26617387,26615990:26616927,26615992:2661689', 'assoc_mat': '26415985:pet_fonce:4230:26419020,26415988:pet_fonce:4230:26419234,26415994:pet_fonce:4230:26418983,26416003:pet_fonce:4230:26418095,26416006:pet_fonce:4230:26418255,26416008:pet_fonce:4230:26418204,26416010:pet_fonce:4230:26417691,26416012:pet_fonce:4230:26417547,26416018:pet_fonce:4230:26417041,26458288:pet_fonce:4230:26463848,26458303:pet_fonce:4230:26463745,26458304:pet_fonce:4230:26468328,26458309:pet_fonce:4230:26463782,26458319:pet_fonce:4230:26463554,26458321:pet_fonce:4230:26467567,26458322:pet_fonce:4230:26463324,26458323:pet_fonce:4230:26462951,26458329:pet_fonce:4230:26462066,26458330:pet_fonce:4230:26458895,26458331:pet_fonce:4230:26462188,26461167:pet_fonce:4230:26461694,26463697:pet_fonce:4230:26464368,26495026:pet_fonce:4230:26504252,26505114:pet_fonce:4230:26511709,26505118:pet_fonce:4230:26511429,26505122:pet_fonce:4230:26509221,26505125:pet_fonce:4230:26514265,26505130:pet_fonce:4230:26509618,26505139:pet_fonce:4230:26510428,26505162:pet_fonce:4230:26509365,26505165:pet_fonce:4230:26509808,2'}), 'main_stat': {'nb_photos': 1999}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-09', 0.7361914632655978),)]} filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_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.32%', 18982], 'carton': ['carton', '4.43%', 89845], 'metal': ['metal', '0.12%', 1620], 'papier': ['papier', '20.03%', 512319], 'pehd': ['pehd', '0.33%', 3198], 'pet_clair': ['pet_clair', '1.32%', 19724], 'pet_fonce': ['pet_fonce', '0.24%', 1257]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_09_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam6 2.35user 3.07system 0:08.32elapsed 65%CPU (0avgtext+0avgdata 177700maxresident)k 90624inputs+280outputs (444major+45403minor)pagefaults 0swaps