python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam7 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam7 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 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_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (0, 30) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 204 month : 09 mtr_id : dashboard_places : SCCU_cam7 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_cam7' 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 = 204 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 = 204 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 = 204 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_cam7" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "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 (2220225,2311945,2235227,2312087,2312079,2312055,2312045,2312035,2312023,2312003,2280353,2311983,2311975,2311971,2315889,2323449,2331219,2335113,2335747) 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.012452110676084486, 'nb_photo': 11364, 'list_port_cont': '26416199,26416239,26416431,26416480,26416609,26416663,26417091,26417152,26417432,26417621,26417846,26417935,26417964,26418038,26418143,26418374,26418517,26418694,26418718,26418871,26418946,26419159,26419716,26420352,26505523,26505711,26505772,26505872,26506047,26506444,26506482,26506979,26507488,26507797,26508726,26508766,26508831,26509147,26509413,26509866,26510016,26510242,26511602,26512435,26512488,26512549,26512811,26518181,26529053,26530069,26531057,26531966,26533246,26534850,26537636,26540833,26541790,26542269,26543557,26549898,26552001,26552142,26595551,26595608,26595705,26595734,26595787,26595846,26595890,26595934,26595955,26596063,26596092,26596136,26596184,26596228,26596320,26596375,26596472,26596506,26596565,26596638,26596694,26596721,26597147,26598760,26600588,26600797,26600967,26602135,26603461,26604577,26606053,26607205,26608164,26608936,26609928,26611071,26612170,26613011,26613852,26614759,26615530,26616260,26617988,26618257,26621814,26621871,26621907,26621948,26622152,26623792,26624035,2669927', 'assoc_port': '26415981:26419159,26415984:26418946,26415987:26418374,26415990:26418718,26415993:26418871,26415995:26418143,26415999:26418517,26416002:26418038,26416005:26417935,26416007:26417846,26416009:26417964,26416011:26417621,26416013:26417432,26416015:26420352,26416017:26417152,26416019:26417091,26416021:26416431,26416023:26416663,26416025:26416609,26416027:26416480,26416029:26416239,26416031:26416199,26418180:26418694,26419551:26419716,26505117:26512811,26505120:26510016,26505124:26510242,26505127:26509866,26505131:26509147,26505134:26509413,26505137:26508726,26505141:26508766,26505145:26507797,26505155:26518181,26505163:26507488,26505168:26506979,26505182:26506482,26505184:26506444,26505187:26505872,26505188:26506047,26505190:26505523,26505193:26512435,26505195:26512549,26505209:26512488,26505212:26505711,26505215:26505772,26508172:26508831,26510964:26511602,26528478:26529053,26529907:26530069,26530876:26531057,26531852:26531966,26533059:26533246,26534733:26542269,26534738:26534850,26534741:26541790,26537061:2653763', 'assoc_mat': '26415981:autre:4230:26419159,26415984:autre:4230:26418946,26415987:autre:4230:26418374,26415990:autre:4230:26418718,26415993:autre:4230:26418871,26415995:autre:4230:26418143,26415999:autre:4230:26418517,26416002:autre:4230:26418038,26416005:autre:4230:26417935,26416007:autre:4230:26417846,26416009:autre:4230:26417964,26416011:autre:4230:26417621,26416013:autre:4230:26417432,26416015:autre:4230:26420352,26416017:autre:4230:26417152,26416019:autre:4230:26417091,26416021:autre:4230:26416431,26416023:autre:4230:26416663,26416025:autre:4230:26416609,26416027:autre:4230:26416480,26416029:autre:4230:26416239,26416031:autre:4230:26416199,26418180:autre:4230:26418694,26419551:autre:4230:26419716,26505117:autre:4230:26512811,26505120:autre:4230:26510016,26505124:autre:4230:26510242,26505127:autre:4230:26509866,26505131:autre:4230:26509147,26505134:autre:4230:26509413,26505137:autre:4230:26508726,26505141:autre:4230:26508766,26505145:autre:4230:26507797,26505155:autre:4230:26518181,26505163:autre:4230:26507488,26505168:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.059979366683202515, 'nb_photo': 94585, 'list_port_cont': '26416206,26416250,26416438,26416478,26416611,26416668,26417099,26417151,26417434,26417617,26417835,26417945,26417966,26418043,26418154,26418370,26418519,26418683,26418719,26418863,26418952,26419173,26419718,26420366,26505532,26505704,26505784,26505874,26506052,26506442,26506486,26506988,26507496,26507792,26508733,26508768,26508845,26509148,26509407,26509874,26510030,26510234,26511603,26512449,26512493,26512529,26512813,26518191,26529057,26530077,26531061,26531976,26533254,26534842,26537632,26540834,26541792,26542284,26543559,26549908,26551998,26552146,26595568,26595599,26595706,26595744,26595795,26595857,26595893,26595932,26595964,26596065,26596099,26596131,26596196,26596235,26596322,26596376,26596474,26596507,26596572,26596631,26596695,26596733,26597144,26598768,26600593,26600798,26600966,26602152,26603468,26604579,26606062,26607217,26608167,26608944,26609921,26611078,26612176,26613005,26613848,26614765,26615529,26616254,26618002,26618243,26621798,26621877,26621918,26621953,26622156,26623806,26624043,2669926', 'assoc_port': '26415981:26419173,26415984:26418952,26415987:26418370,26415990:26418719,26415993:26418863,26415995:26418154,26415999:26418519,26416002:26418043,26416005:26417945,26416007:26417835,26416009:26417966,26416011:26417617,26416013:26417434,26416015:26420366,26416017:26417151,26416019:26417099,26416021:26416438,26416023:26416668,26416025:26416611,26416027:26416478,26416029:26416250,26416031:26416206,26418180:26418683,26419551:26419718,26505117:26512813,26505120:26510030,26505124:26510234,26505127:26509874,26505131:26509148,26505134:26509407,26505137:26508733,26505141:26508768,26505145:26507792,26505155:26518191,26505163:26507496,26505168:26506988,26505182:26506486,26505184:26506442,26505187:26505874,26505188:26506052,26505190:26505532,26505193:26512449,26505195:26512529,26505209:26512493,26505212:26505704,26505215:26505784,26508172:26508845,26510964:26511603,26528478:26529057,26529907:26530077,26530876:26531061,26531852:26531976,26533059:26533254,26534733:26542284,26534738:26534842,26534741:26541792,26537061:2653763', 'assoc_mat': '26415981:carton:4230:26419173,26415984:carton:4230:26418952,26415987:carton:4230:26418370,26415990:carton:4230:26418719,26415993:carton:4230:26418863,26415995:carton:4230:26418154,26415999:carton:4230:26418519,26416002:carton:4230:26418043,26416005:carton:4230:26417945,26416007:carton:4230:26417835,26416009:carton:4230:26417966,26416011:carton:4230:26417617,26416013:carton:4230:26417434,26416015:carton:4230:26420366,26416017:carton:4230:26417151,26416019:carton:4230:26417099,26416021:carton:4230:26416438,26416023:carton:4230:26416668,26416025:carton:4230:26416611,26416027:carton:4230:26416478,26416029:carton:4230:26416250,26416031:carton:4230:26416206,26418180:carton:4230:26418683,26419551:carton:4230:26419718,26505117:carton:4230:26512813,26505120:carton:4230:26510030,26505124:carton:4230:26510234,26505127:carton:4230:26509874,26505131:carton:4230:26509148,26505134:carton:4230:26509407,26505137:carton:4230:26508733,26505141:carton:4230:26508768,26505145:carton:4230:26507792,26505155:carton:4230:26518191,2650'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001543649524638241, 'nb_photo': 1431, 'list_port_cont': '26416209,26416238,26416446,26416602,26416680,26417101,26417155,26417436,26417605,26417833,26417951,26417961,26418046,26418153,26418516,26418690,26418725,26418876,26418949,26419172,26420362,26505519,26505705,26505774,26505857,26506041,26506439,26506494,26506994,26507498,26507801,26508735,26508770,26508844,26509141,26509398,26509860,26510035,26510246,26511590,26512451,26512478,26512527,26512806,26518179,26529052,26530081,26531045,26531965,26533250,26534847,26537629,26540818,26541794,26542276,26543564,26549901,26552000,26552137,26595554,26595704,26595728,26595783,26595858,26595882,26595929,26595960,26596064,26596095,26596132,26596181,26596239,26596324,26596377,26596469,26596514,26596575,26596630,26596686,26596720,26597148,26598755,26602139,26603455,26604573,26606061,26607201,26608161,26608941,26609914,26611081,26612178,26612999,26613843,26614754,26615527,26616259,26617994,26618247,26621801,26621875,26621908,26621942,26622153,26623809,26624028,26699277,26699509,26699659,26699851,26699927,26700367,26700561,2670060', 'assoc_port': '26415981:26419172,26415984:26418949,26415990:26418725,26415993:26418876,26415995:26418153,26415999:26418516,26416002:26418046,26416005:26417951,26416007:26417833,26416009:26417961,26416011:26417605,26416013:26417436,26416015:26420362,26416017:26417155,26416019:26417101,26416021:26416446,26416023:26416680,26416025:26416602,26416029:26416238,26416031:26416209,26418180:26418690,26505117:26512806,26505120:26510035,26505124:26510246,26505127:26509860,26505131:26509141,26505134:26509398,26505137:26508735,26505141:26508770,26505145:26507801,26505155:26518179,26505163:26507498,26505168:26506994,26505182:26506494,26505184:26506439,26505187:26505857,26505188:26506041,26505190:26505519,26505193:26512451,26505195:26512527,26505209:26512478,26505212:26505705,26505215:26505774,26508172:26508844,26510964:26511590,26528478:26529052,26529907:26530081,26530876:26531045,26531852:26531965,26533059:26533250,26534733:26542276,26534738:26534847,26534741:26541794,26537061:26537629,26540397:26540818,26543381:26543564,26546193:2655200', 'assoc_mat': '26415981:metal:4230:26419172,26415984:metal:4230:26418949,26415990:metal:4230:26418725,26415993:metal:4230:26418876,26415995:metal:4230:26418153,26415999:metal:4230:26418516,26416002:metal:4230:26418046,26416005:metal:4230:26417951,26416007:metal:4230:26417833,26416009:metal:4230:26417961,26416011:metal:4230:26417605,26416013:metal:4230:26417436,26416015:metal:4230:26420362,26416017:metal:4230:26417155,26416019:metal:4230:26417101,26416021:metal:4230:26416446,26416023:metal:4230:26416680,26416025:metal:4230:26416602,26416029:metal:4230:26416238,26416031:metal:4230:26416209,26418180:metal:4230:26418690,26505117:metal:4230:26512806,26505120:metal:4230:26510035,26505124:metal:4230:26510246,26505127:metal:4230:26509860,26505131:metal:4230:26509141,26505134:metal:4230:26509398,26505137:metal:4230:26508735,26505141:metal:4230:26508770,26505145:metal:4230:26507801,26505155:metal:4230:26518179,26505163:metal:4230:26507498,26505168:metal:4230:26506994,26505182:metal:4230:26506494,26505184:metal:4230:26506439,26505187:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.17587675656710924, 'nb_photo': 265357, 'list_port_cont': '26416202,26416247,26416443,26416474,26416615,26416677,26417116,26417159,26417442,26417620,26417845,26417942,26417969,26418040,26418159,26418368,26418522,26418695,26418729,26418878,26418941,26419165,26419712,26420363,26505528,26505706,26505783,26505864,26506054,26506445,26506489,26506990,26507491,26507800,26508736,26508769,26508847,26509153,26509412,26509867,26510022,26510236,26511600,26512447,26512495,26512539,26512814,26518189,26529049,26530078,26531054,26531977,26533242,26534851,26537635,26540827,26541781,26542282,26543563,26549910,26552003,26552147,26595562,26595611,26595703,26595745,26595792,26595853,26595896,26595930,26595970,26596058,26596098,26596141,26596189,26596243,26596325,26596370,26596463,26596505,26596561,26596625,26596693,26596731,26597134,26598770,26600595,26600788,26600977,26602147,26603457,26604586,26606059,26607207,26608163,26608942,26609929,26611076,26612175,26613004,26613842,26614763,26615518,26616252,26617980,26618253,26621812,26621885,26621920,26621956,26622155,26623802,26624039,2669927', 'assoc_port': '26415981:26419165,26415984:26418941,26415987:26418368,26415990:26418729,26415993:26418878,26415995:26418159,26415999:26418522,26416002:26418040,26416005:26417942,26416007:26417845,26416009:26417969,26416011:26417620,26416013:26417442,26416015:26420363,26416017:26417159,26416019:26417116,26416021:26416443,26416023:26416677,26416025:26416615,26416027:26416474,26416029:26416247,26416031:26416202,26418180:26418695,26419551:26419712,26505117:26512814,26505120:26510022,26505124:26510236,26505127:26509867,26505131:26509153,26505134:26509412,26505137:26508736,26505141:26508769,26505145:26507800,26505155:26518189,26505163:26507491,26505168:26506990,26505182:26506489,26505184:26506445,26505187:26505864,26505188:26506054,26505190:26505528,26505193:26512447,26505195:26512539,26505209:26512495,26505212:26505706,26505215:26505783,26508172:26508847,26510964:26511600,26528478:26529049,26529907:26530078,26530876:26531054,26531852:26531977,26533059:26533242,26534733:26542282,26534738:26534851,26534741:26541781,26537061:2653763', 'assoc_mat': '26415981:papier:4230:26419165,26415984:papier:4230:26418941,26415987:papier:4230:26418368,26415990:papier:4230:26418729,26415993:papier:4230:26418878,26415995:papier:4230:26418159,26415999:papier:4230:26418522,26416002:papier:4230:26418040,26416005:papier:4230:26417942,26416007:papier:4230:26417845,26416009:papier:4230:26417969,26416011:papier:4230:26417620,26416013:papier:4230:26417442,26416015:papier:4230:26420363,26416017:papier:4230:26417159,26416019:papier:4230:26417116,26416021:papier:4230:26416443,26416023:papier:4230:26416677,26416025:papier:4230:26416615,26416027:papier:4230:26416474,26416029:papier:4230:26416247,26416031:papier:4230:26416202,26418180:papier:4230:26418695,26419551:papier:4230:26419712,26505117:papier:4230:26512814,26505120:papier:4230:26510022,26505124:papier:4230:26510236,26505127:papier:4230:26509867,26505131:papier:4230:26509153,26505134:papier:4230:26509412,26505137:papier:4230:26508736,26505141:papier:4230:26508769,26505145:papier:4230:26507800,26505155:papier:4230:26518189,2650'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031918308530088663, 'nb_photo': 1203, 'list_port_cont': '26416200,26416616,26417446,26417613,26417950,26417965,26418042,26418151,26418373,26418514,26418722,26418867,26418950,26420365,26505699,26505778,26506050,26506433,26506485,26506987,26507492,26507804,26508738,26508762,26508837,26509409,26510032,26510235,26511592,26512450,26512535,26512807,26518187,26529050,26530076,26531047,26531981,26533251,26534849,26537637,26540832,26541791,26542277,26543562,26549903,26552004,26595567,26595607,26595707,26595788,26595852,26595892,26595931,26595966,26596070,26596104,26596140,26596195,26596233,26596317,26596378,26596465,26596503,26596568,26596632,26596725,26597143,26598765,26600587,26600793,26600970,26603464,26604587,26606064,26607216,26608166,26608948,26609927,26611077,26612173,26613008,26613850,26614760,26615515,26616258,26617986,26618255,26621813,26621921,26621955,26622151,26623807,26624041,26699844,26699937,26700375,26700568,26700624,26700871,26701559,26701648,26701879,26702116,26702404,26703535,26703880,26704068,26704775,26738324,26742208,26749890,26752573,26754310,2675718', 'assoc_port': '26415984:26418950,26415987:26418373,26415990:26418722,26415993:26418867,26415995:26418151,26415999:26418514,26416002:26418042,26416005:26417950,26416009:26417965,26416011:26417613,26416013:26417446,26416015:26420365,26416025:26416616,26416031:26416200,26505117:26512807,26505120:26510032,26505124:26510235,26505134:26509409,26505137:26508738,26505141:26508762,26505145:26507804,26505155:26518187,26505163:26507492,26505168:26506987,26505182:26506485,26505184:26506433,26505188:26506050,26505193:26512450,26505195:26512535,26505212:26505699,26505215:26505778,26508172:26508837,26510964:26511592,26528478:26529050,26529907:26530076,26530876:26531047,26531852:26531981,26533059:26533251,26534733:26542277,26534738:26534849,26534741:26541791,26537061:26537637,26540397:26540832,26543381:26543562,26546193:26552004,26549407:26549903,26595441:26595788,26595444:26596725,26595446:26596568,26595448:26596632,26595450:26596378,26595453:26596503,26595455:26596317,26595457:26596195,26595459:26596465,26595461:26596233,26595463:2659596', 'assoc_mat': '26415984:pehd:4230:26418950,26415987:pehd:4230:26418373,26415990:pehd:4230:26418722,26415993:pehd:4230:26418867,26415995:pehd:4230:26418151,26415999:pehd:4230:26418514,26416002:pehd:4230:26418042,26416005:pehd:4230:26417950,26416009:pehd:4230:26417965,26416011:pehd:4230:26417613,26416013:pehd:4230:26417446,26416015:pehd:4230:26420365,26416025:pehd:4230:26416616,26416031:pehd:4230:26416200,26505117:pehd:4230:26512807,26505120:pehd:4230:26510032,26505124:pehd:4230:26510235,26505134:pehd:4230:26509409,26505137:pehd:4230:26508738,26505141:pehd:4230:26508762,26505145:pehd:4230:26507804,26505155:pehd:4230:26518187,26505163:pehd:4230:26507492,26505168:pehd:4230:26506987,26505182:pehd:4230:26506485,26505184:pehd:4230:26506433,26505188:pehd:4230:26506050,26505193:pehd:4230:26512450,26505195:pehd:4230:26512535,26505212:pehd:4230:26505699,26505215:pehd:4230:26505778,26508172:pehd:4230:26508837,26510964:pehd:4230:26511592,26528478:pehd:4230:26529050,26529907:pehd:4230:26530076,26530876:pehd:4230:26531047,26531852:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00917162072499243, 'nb_photo': 14562, 'list_port_cont': '26416208,26416249,26416448,26416484,26416613,26416681,26417120,26417148,26417438,26417604,26417836,26417943,26417967,26418037,26418160,26418371,26418520,26418691,26418731,26418877,26418951,26419174,26419715,26420351,26505535,26505707,26505782,26505867,26506051,26506438,26506493,26506992,26507497,26507799,26508729,26508774,26508841,26509151,26509406,26509868,26510018,26510247,26511597,26512442,26512477,26512547,26512817,26518185,26529054,26530075,26531052,26531972,26533257,26534848,26537639,26540831,26541782,26542283,26543568,26549904,26552002,26552148,26595569,26595602,26595709,26595742,26595794,26595856,26595897,26595925,26595958,26596071,26596107,26596143,26596193,26596242,26596321,26596373,26596475,26596508,26596577,26596628,26596687,26596724,26597146,26598766,26600594,26600800,26600973,26602146,26603462,26604581,26606060,26607210,26608153,26608947,26609923,26611075,26612168,26613007,26613839,26614761,26615528,26616255,26618001,26618252,26621806,26621883,26621917,26621947,26622150,26623796,26624037,2669926', 'assoc_port': '26415981:26419174,26415984:26418951,26415987:26418371,26415990:26418731,26415993:26418877,26415995:26418160,26415999:26418520,26416002:26418037,26416005:26417943,26416007:26417836,26416009:26417967,26416011:26417604,26416013:26417438,26416015:26420351,26416017:26417148,26416019:26417120,26416021:26416448,26416023:26416681,26416025:26416613,26416027:26416484,26416029:26416249,26416031:26416208,26418180:26418691,26419551:26419715,26505117:26512817,26505120:26510018,26505124:26510247,26505127:26509868,26505131:26509151,26505134:26509406,26505137:26508729,26505141:26508774,26505145:26507799,26505155:26518185,26505163:26507497,26505168:26506992,26505182:26506493,26505184:26506438,26505187:26505867,26505188:26506051,26505190:26505535,26505193:26512442,26505195:26512547,26505209:26512477,26505212:26505707,26505215:26505782,26508172:26508841,26510964:26511597,26528478:26529054,26529907:26530075,26530876:26531052,26531852:26531972,26533059:26533257,26534733:26542283,26534738:26534848,26534741:26541782,26537061:2653763', 'assoc_mat': '26415981:pet_clair:4230:26419174,26415984:pet_clair:4230:26418951,26415987:pet_clair:4230:26418371,26415990:pet_clair:4230:26418731,26415993:pet_clair:4230:26418877,26415995:pet_clair:4230:26418160,26415999:pet_clair:4230:26418520,26416002:pet_clair:4230:26418037,26416005:pet_clair:4230:26417943,26416007:pet_clair:4230:26417836,26416009:pet_clair:4230:26417967,26416011:pet_clair:4230:26417604,26416013:pet_clair:4230:26417438,26416015:pet_clair:4230:26420351,26416017:pet_clair:4230:26417148,26416019:pet_clair:4230:26417120,26416021:pet_clair:4230:26416448,26416023:pet_clair:4230:26416681,26416025:pet_clair:4230:26416613,26416027:pet_clair:4230:26416484,26416029:pet_clair:4230:26416249,26416031:pet_clair:4230:26416208,26418180:pet_clair:4230:26418691,26419551:pet_clair:4230:26419715,26505117:pet_clair:4230:26512817,26505120:pet_clair:4230:26510018,26505124:pet_clair:4230:26510247,26505127:pet_clair:4230:26509868,26505131:pet_clair:4230:26509151,26505134:pet_clair:4230:26509406,26505137:pet_clair:4230:26508729,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024808840707588285, 'nb_photo': 570, 'list_port_cont': '26416255,26417107,26417443,26417963,26418156,26418366,26418693,26419171,26505531,26505710,26505873,26506437,26506981,26507499,26507803,26508730,26508775,26508842,26509140,26511598,26512446,26512484,26512541,26518190,26529060,26531060,26533255,26540828,26541785,26542278,26543565,26549906,26551994,26552151,26595558,26595605,26595731,26595790,26595895,26595927,26595968,26596067,26596100,26596187,26596240,26596470,26596512,26596573,26596732,26597145,26600591,26600795,26600975,26603465,26604585,26606066,26607213,26608168,26609924,26611070,26612169,26613003,26613854,26614768,26615525,26616262,26617992,26618251,26621808,26621915,26622158,26699274,26699505,26699664,26699839,26699935,26700381,26700570,26700613,26700879,26701429,26701563,26701643,26701875,26701924,26702755,26702874,26703512,26704500,26738323,26740103,26742201,26744980,26749880,26752571,26754317,26759853,26768293,26769273,26782317,26913990,26914086,26914224,26914415,26914457,26914623,26914852,26914927,26915697,26918484,26921769,26923872,26930739,2693349', 'assoc_port': '26415981:26419171,26415987:26418366,26415995:26418156,26416009:26417963,26416013:26417443,26416019:26417107,26416029:26416255,26418180:26418693,26505131:26509140,26505137:26508730,26505141:26508775,26505145:26507803,26505155:26518190,26505163:26507499,26505168:26506981,26505184:26506437,26505187:26505873,26505190:26505531,26505193:26512446,26505195:26512541,26505209:26512484,26505212:26505710,26508172:26508842,26510964:26511598,26528478:26529060,26530876:26531060,26533059:26533255,26534733:26542278,26534741:26541785,26540397:26540828,26543381:26543565,26546193:26551994,26549407:26549906,26551985:26552151,26595441:26595790,26595444:26596732,26595446:26596573,26595453:26596512,26595457:26596187,26595459:26596470,26595461:26596240,26595463:26595968,26595465:26596067,26595469:26595895,26595470:26596100,26595471:26595927,26595472:26595731,26595475:26595558,26595476:26595605,26596754:26597145,26600516:26600591,26600684:26600795,26600855:26600975,26602822:26603465,26604427:26604585,26605718:26606066,26606867:2660721', 'assoc_mat': '26415981:pet_fonce:4230:26419171,26415987:pet_fonce:4230:26418366,26415995:pet_fonce:4230:26418156,26416009:pet_fonce:4230:26417963,26416013:pet_fonce:4230:26417443,26416019:pet_fonce:4230:26417107,26416029:pet_fonce:4230:26416255,26418180:pet_fonce:4230:26418693,26505131:pet_fonce:4230:26509140,26505137:pet_fonce:4230:26508730,26505141:pet_fonce:4230:26508775,26505145:pet_fonce:4230:26507803,26505155:pet_fonce:4230:26518190,26505163:pet_fonce:4230:26507499,26505168:pet_fonce:4230:26506981,26505184:pet_fonce:4230:26506437,26505187:pet_fonce:4230:26505873,26505190:pet_fonce:4230:26505531,26505193:pet_fonce:4230:26512446,26505195:pet_fonce:4230:26512541,26505209:pet_fonce:4230:26512484,26505212:pet_fonce:4230:26505710,26508172:pet_fonce:4230:26508842,26510964:pet_fonce:4230:26511598,26528478:pet_fonce:4230:26529060,26530876:pet_fonce:4230:26531060,26533059:pet_fonce:4230:26533255,26534733:pet_fonce:4230:26542278,26534741:pet_fonce:4230:26541785,26540397:pet_fonce:4230:26540828,26543381:pet_fonce:4230:26543565,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(2220225,2311945,2235227,2312087,2312079,2312055,2312045,2312035,2312023,2312003,2280353,2311983,2311975,2311971,2315889,2323449,2331219,2335113,2335747)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=204 and date >='2025-09-01' and date <= '2025-09-30') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1293,),), 'unwanted_material_monthly_percentage': ((0.7474800883164087,),), 'material_repartition': (('incineration', 1293),), 'material_dict': {'incineration': 1293}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 9, 1), 0.7750631736847354, 4), (datetime.date(2025, 9, 2), 0.7782930195247328, 1), (datetime.date(2025, 9, 3), 0.7342963797862647, 4), (datetime.date(2025, 9, 4), 0.7101623778631369, 3), (datetime.date(2025, 9, 5), 0.6961114195274157, 2), (datetime.date(2025, 9, 6), 0.6657042020406888, 4), (datetime.date(2025, 9, 7), 0.7533869142482872, 3), (datetime.date(2025, 9, 8), 0.7679531067667473, 4), (datetime.date(2025, 9, 9), 0.7766842331883617, 4), (datetime.date(2025, 9, 10), 0.7819153388524994, 3), (datetime.date(2025, 9, 11), 0.7887044449047698, 4), (datetime.date(2025, 9, 12), 0.7404588274591003, 1), (datetime.date(2025, 9, 15), 0.7622483473059163, 4), (datetime.date(2025, 9, 16), 0.7532708300996109, 4), (datetime.date(2025, 9, 17), 0.7552488009561981, 4), (datetime.date(2025, 9, 18), 0.7306394663821413, 4), (datetime.date(2025, 9, 19), 0.7655427231927696, 4), (datetime.date(2025, 9, 20), 0.7418627835377728, 1), (datetime.date(2025, 9, 21), 0.7864895050559099, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 9, 1), 0.7750631736847354, 4), (datetime.date(2025, 9, 2), 0.7782930195247328, 1), (datetime.date(2025, 9, 3), 0.7342963797862647, 4), (datetime.date(2025, 9, 4), 0.7101623778631369, 3), (datetime.date(2025, 9, 5), 0.6961114195274157, 2), (datetime.date(2025, 9, 6), 0.6657042020406888, 4), (datetime.date(2025, 9, 7), 0.7533869142482872, 3), (datetime.date(2025, 9, 8), 0.7679531067667473, 4), (datetime.date(2025, 9, 9), 0.7766842331883617, 4), (datetime.date(2025, 9, 10), 0.7819153388524994, 3), (datetime.date(2025, 9, 11), 0.7887044449047698, 4), (datetime.date(2025, 9, 12), 0.7404588274591003, 1), (datetime.date(2025, 9, 15), 0.7622483473059163, 4), (datetime.date(2025, 9, 16), 0.7532708300996109, 4), (datetime.date(2025, 9, 17), 0.7552488009561981, 4), (datetime.date(2025, 9, 18), 0.7306394663821413, 4), (datetime.date(2025, 9, 19), 0.7655427231927696, 4), (datetime.date(2025, 9, 20), 0.7418627835377728, 1), (datetime.date(2025, 9, 21), 0.7864895050559099, 1))}, 'quality_array': [['-8.44726479195059', '01092025'], ['-8.73497660857683', '02092025'], ['-8.259760294298994', '11092025'], ['-8.651860603632318', '03092025'], ['-8.625078841933787', '04092025'], ['-8.680705669020943', '05092025'], ['-8.580130639238535', '06092025'], ['-8.781827037350743', '07092025'], ['-8.740639057396933', '08092025'], ['-8.626169082768863', '09092025'], ['-8.477232768562832', '10092025'], ['-8.52064172227146', '12092025'], ['-8.642135333188097', '15092025'], ['-8.559526562844862', '16092025'], ['-8.634262477021087', '17092025'], ['-8.45771786284149', '18092025'], ['-8.570222480801284', '19092025'], ['-8.520446769399513', '20092025'], ['-8.559989011950256', '21092025']], 'number_of_batch': ((408,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012452110676084486, 'nb_photo': 11364, 'list_port_cont': '26416199,26416239,26416431,26416480,26416609,26416663,26417091,26417152,26417432,26417621,26417846,26417935,26417964,26418038,26418143,26418374,26418517,26418694,26418718,26418871,26418946,26419159,26419716,26420352,26505523,26505711,26505772,26505872,26506047,26506444,26506482,26506979,26507488,26507797,26508726,26508766,26508831,26509147,26509413,26509866,26510016,26510242,26511602,26512435,26512488,26512549,26512811,26518181,26529053,26530069,26531057,26531966,26533246,26534850,26537636,26540833,26541790,26542269,26543557,26549898,26552001,26552142,26595551,26595608,26595705,26595734,26595787,26595846,26595890,26595934,26595955,26596063,26596092,26596136,26596184,26596228,26596320,26596375,26596472,26596506,26596565,26596638,26596694,26596721,26597147,26598760,26600588,26600797,26600967,26602135,26603461,26604577,26606053,26607205,26608164,26608936,26609928,26611071,26612170,26613011,26613852,26614759,26615530,26616260,26617988,26618257,26621814,26621871,26621907,26621948,26622152,26623792,26624035,2669927', 'assoc_port': '26415981:26419159,26415984:26418946,26415987:26418374,26415990:26418718,26415993:26418871,26415995:26418143,26415999:26418517,26416002:26418038,26416005:26417935,26416007:26417846,26416009:26417964,26416011:26417621,26416013:26417432,26416015:26420352,26416017:26417152,26416019:26417091,26416021:26416431,26416023:26416663,26416025:26416609,26416027:26416480,26416029:26416239,26416031:26416199,26418180:26418694,26419551:26419716,26505117:26512811,26505120:26510016,26505124:26510242,26505127:26509866,26505131:26509147,26505134:26509413,26505137:26508726,26505141:26508766,26505145:26507797,26505155:26518181,26505163:26507488,26505168:26506979,26505182:26506482,26505184:26506444,26505187:26505872,26505188:26506047,26505190:26505523,26505193:26512435,26505195:26512549,26505209:26512488,26505212:26505711,26505215:26505772,26508172:26508831,26510964:26511602,26528478:26529053,26529907:26530069,26530876:26531057,26531852:26531966,26533059:26533246,26534733:26542269,26534738:26534850,26534741:26541790,26537061:2653763', 'assoc_mat': '26415981:autre:4230:26419159,26415984:autre:4230:26418946,26415987:autre:4230:26418374,26415990:autre:4230:26418718,26415993:autre:4230:26418871,26415995:autre:4230:26418143,26415999:autre:4230:26418517,26416002:autre:4230:26418038,26416005:autre:4230:26417935,26416007:autre:4230:26417846,26416009:autre:4230:26417964,26416011:autre:4230:26417621,26416013:autre:4230:26417432,26416015:autre:4230:26420352,26416017:autre:4230:26417152,26416019:autre:4230:26417091,26416021:autre:4230:26416431,26416023:autre:4230:26416663,26416025:autre:4230:26416609,26416027:autre:4230:26416480,26416029:autre:4230:26416239,26416031:autre:4230:26416199,26418180:autre:4230:26418694,26419551:autre:4230:26419716,26505117:autre:4230:26512811,26505120:autre:4230:26510016,26505124:autre:4230:26510242,26505127:autre:4230:26509866,26505131:autre:4230:26509147,26505134:autre:4230:26509413,26505137:autre:4230:26508726,26505141:autre:4230:26508766,26505145:autre:4230:26507797,26505155:autre:4230:26518181,26505163:autre:4230:26507488,26505168:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.059979366683202515, 'nb_photo': 94585, 'list_port_cont': '26416206,26416250,26416438,26416478,26416611,26416668,26417099,26417151,26417434,26417617,26417835,26417945,26417966,26418043,26418154,26418370,26418519,26418683,26418719,26418863,26418952,26419173,26419718,26420366,26505532,26505704,26505784,26505874,26506052,26506442,26506486,26506988,26507496,26507792,26508733,26508768,26508845,26509148,26509407,26509874,26510030,26510234,26511603,26512449,26512493,26512529,26512813,26518191,26529057,26530077,26531061,26531976,26533254,26534842,26537632,26540834,26541792,26542284,26543559,26549908,26551998,26552146,26595568,26595599,26595706,26595744,26595795,26595857,26595893,26595932,26595964,26596065,26596099,26596131,26596196,26596235,26596322,26596376,26596474,26596507,26596572,26596631,26596695,26596733,26597144,26598768,26600593,26600798,26600966,26602152,26603468,26604579,26606062,26607217,26608167,26608944,26609921,26611078,26612176,26613005,26613848,26614765,26615529,26616254,26618002,26618243,26621798,26621877,26621918,26621953,26622156,26623806,26624043,2669926', 'assoc_port': '26415981:26419173,26415984:26418952,26415987:26418370,26415990:26418719,26415993:26418863,26415995:26418154,26415999:26418519,26416002:26418043,26416005:26417945,26416007:26417835,26416009:26417966,26416011:26417617,26416013:26417434,26416015:26420366,26416017:26417151,26416019:26417099,26416021:26416438,26416023:26416668,26416025:26416611,26416027:26416478,26416029:26416250,26416031:26416206,26418180:26418683,26419551:26419718,26505117:26512813,26505120:26510030,26505124:26510234,26505127:26509874,26505131:26509148,26505134:26509407,26505137:26508733,26505141:26508768,26505145:26507792,26505155:26518191,26505163:26507496,26505168:26506988,26505182:26506486,26505184:26506442,26505187:26505874,26505188:26506052,26505190:26505532,26505193:26512449,26505195:26512529,26505209:26512493,26505212:26505704,26505215:26505784,26508172:26508845,26510964:26511603,26528478:26529057,26529907:26530077,26530876:26531061,26531852:26531976,26533059:26533254,26534733:26542284,26534738:26534842,26534741:26541792,26537061:2653763', 'assoc_mat': '26415981:carton:4230:26419173,26415984:carton:4230:26418952,26415987:carton:4230:26418370,26415990:carton:4230:26418719,26415993:carton:4230:26418863,26415995:carton:4230:26418154,26415999:carton:4230:26418519,26416002:carton:4230:26418043,26416005:carton:4230:26417945,26416007:carton:4230:26417835,26416009:carton:4230:26417966,26416011:carton:4230:26417617,26416013:carton:4230:26417434,26416015:carton:4230:26420366,26416017:carton:4230:26417151,26416019:carton:4230:26417099,26416021:carton:4230:26416438,26416023:carton:4230:26416668,26416025:carton:4230:26416611,26416027:carton:4230:26416478,26416029:carton:4230:26416250,26416031:carton:4230:26416206,26418180:carton:4230:26418683,26419551:carton:4230:26419718,26505117:carton:4230:26512813,26505120:carton:4230:26510030,26505124:carton:4230:26510234,26505127:carton:4230:26509874,26505131:carton:4230:26509148,26505134:carton:4230:26509407,26505137:carton:4230:26508733,26505141:carton:4230:26508768,26505145:carton:4230:26507792,26505155:carton:4230:26518191,2650'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001543649524638241, 'nb_photo': 1431, 'list_port_cont': '26416209,26416238,26416446,26416602,26416680,26417101,26417155,26417436,26417605,26417833,26417951,26417961,26418046,26418153,26418516,26418690,26418725,26418876,26418949,26419172,26420362,26505519,26505705,26505774,26505857,26506041,26506439,26506494,26506994,26507498,26507801,26508735,26508770,26508844,26509141,26509398,26509860,26510035,26510246,26511590,26512451,26512478,26512527,26512806,26518179,26529052,26530081,26531045,26531965,26533250,26534847,26537629,26540818,26541794,26542276,26543564,26549901,26552000,26552137,26595554,26595704,26595728,26595783,26595858,26595882,26595929,26595960,26596064,26596095,26596132,26596181,26596239,26596324,26596377,26596469,26596514,26596575,26596630,26596686,26596720,26597148,26598755,26602139,26603455,26604573,26606061,26607201,26608161,26608941,26609914,26611081,26612178,26612999,26613843,26614754,26615527,26616259,26617994,26618247,26621801,26621875,26621908,26621942,26622153,26623809,26624028,26699277,26699509,26699659,26699851,26699927,26700367,26700561,2670060', 'assoc_port': '26415981:26419172,26415984:26418949,26415990:26418725,26415993:26418876,26415995:26418153,26415999:26418516,26416002:26418046,26416005:26417951,26416007:26417833,26416009:26417961,26416011:26417605,26416013:26417436,26416015:26420362,26416017:26417155,26416019:26417101,26416021:26416446,26416023:26416680,26416025:26416602,26416029:26416238,26416031:26416209,26418180:26418690,26505117:26512806,26505120:26510035,26505124:26510246,26505127:26509860,26505131:26509141,26505134:26509398,26505137:26508735,26505141:26508770,26505145:26507801,26505155:26518179,26505163:26507498,26505168:26506994,26505182:26506494,26505184:26506439,26505187:26505857,26505188:26506041,26505190:26505519,26505193:26512451,26505195:26512527,26505209:26512478,26505212:26505705,26505215:26505774,26508172:26508844,26510964:26511590,26528478:26529052,26529907:26530081,26530876:26531045,26531852:26531965,26533059:26533250,26534733:26542276,26534738:26534847,26534741:26541794,26537061:26537629,26540397:26540818,26543381:26543564,26546193:2655200', 'assoc_mat': '26415981:metal:4230:26419172,26415984:metal:4230:26418949,26415990:metal:4230:26418725,26415993:metal:4230:26418876,26415995:metal:4230:26418153,26415999:metal:4230:26418516,26416002:metal:4230:26418046,26416005:metal:4230:26417951,26416007:metal:4230:26417833,26416009:metal:4230:26417961,26416011:metal:4230:26417605,26416013:metal:4230:26417436,26416015:metal:4230:26420362,26416017:metal:4230:26417155,26416019:metal:4230:26417101,26416021:metal:4230:26416446,26416023:metal:4230:26416680,26416025:metal:4230:26416602,26416029:metal:4230:26416238,26416031:metal:4230:26416209,26418180:metal:4230:26418690,26505117:metal:4230:26512806,26505120:metal:4230:26510035,26505124:metal:4230:26510246,26505127:metal:4230:26509860,26505131:metal:4230:26509141,26505134:metal:4230:26509398,26505137:metal:4230:26508735,26505141:metal:4230:26508770,26505145:metal:4230:26507801,26505155:metal:4230:26518179,26505163:metal:4230:26507498,26505168:metal:4230:26506994,26505182:metal:4230:26506494,26505184:metal:4230:26506439,26505187:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.17587675656710924, 'nb_photo': 265357, 'list_port_cont': '26416202,26416247,26416443,26416474,26416615,26416677,26417116,26417159,26417442,26417620,26417845,26417942,26417969,26418040,26418159,26418368,26418522,26418695,26418729,26418878,26418941,26419165,26419712,26420363,26505528,26505706,26505783,26505864,26506054,26506445,26506489,26506990,26507491,26507800,26508736,26508769,26508847,26509153,26509412,26509867,26510022,26510236,26511600,26512447,26512495,26512539,26512814,26518189,26529049,26530078,26531054,26531977,26533242,26534851,26537635,26540827,26541781,26542282,26543563,26549910,26552003,26552147,26595562,26595611,26595703,26595745,26595792,26595853,26595896,26595930,26595970,26596058,26596098,26596141,26596189,26596243,26596325,26596370,26596463,26596505,26596561,26596625,26596693,26596731,26597134,26598770,26600595,26600788,26600977,26602147,26603457,26604586,26606059,26607207,26608163,26608942,26609929,26611076,26612175,26613004,26613842,26614763,26615518,26616252,26617980,26618253,26621812,26621885,26621920,26621956,26622155,26623802,26624039,2669927', 'assoc_port': '26415981:26419165,26415984:26418941,26415987:26418368,26415990:26418729,26415993:26418878,26415995:26418159,26415999:26418522,26416002:26418040,26416005:26417942,26416007:26417845,26416009:26417969,26416011:26417620,26416013:26417442,26416015:26420363,26416017:26417159,26416019:26417116,26416021:26416443,26416023:26416677,26416025:26416615,26416027:26416474,26416029:26416247,26416031:26416202,26418180:26418695,26419551:26419712,26505117:26512814,26505120:26510022,26505124:26510236,26505127:26509867,26505131:26509153,26505134:26509412,26505137:26508736,26505141:26508769,26505145:26507800,26505155:26518189,26505163:26507491,26505168:26506990,26505182:26506489,26505184:26506445,26505187:26505864,26505188:26506054,26505190:26505528,26505193:26512447,26505195:26512539,26505209:26512495,26505212:26505706,26505215:26505783,26508172:26508847,26510964:26511600,26528478:26529049,26529907:26530078,26530876:26531054,26531852:26531977,26533059:26533242,26534733:26542282,26534738:26534851,26534741:26541781,26537061:2653763', 'assoc_mat': '26415981:papier:4230:26419165,26415984:papier:4230:26418941,26415987:papier:4230:26418368,26415990:papier:4230:26418729,26415993:papier:4230:26418878,26415995:papier:4230:26418159,26415999:papier:4230:26418522,26416002:papier:4230:26418040,26416005:papier:4230:26417942,26416007:papier:4230:26417845,26416009:papier:4230:26417969,26416011:papier:4230:26417620,26416013:papier:4230:26417442,26416015:papier:4230:26420363,26416017:papier:4230:26417159,26416019:papier:4230:26417116,26416021:papier:4230:26416443,26416023:papier:4230:26416677,26416025:papier:4230:26416615,26416027:papier:4230:26416474,26416029:papier:4230:26416247,26416031:papier:4230:26416202,26418180:papier:4230:26418695,26419551:papier:4230:26419712,26505117:papier:4230:26512814,26505120:papier:4230:26510022,26505124:papier:4230:26510236,26505127:papier:4230:26509867,26505131:papier:4230:26509153,26505134:papier:4230:26509412,26505137:papier:4230:26508736,26505141:papier:4230:26508769,26505145:papier:4230:26507800,26505155:papier:4230:26518189,2650'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031918308530088663, 'nb_photo': 1203, 'list_port_cont': '26416200,26416616,26417446,26417613,26417950,26417965,26418042,26418151,26418373,26418514,26418722,26418867,26418950,26420365,26505699,26505778,26506050,26506433,26506485,26506987,26507492,26507804,26508738,26508762,26508837,26509409,26510032,26510235,26511592,26512450,26512535,26512807,26518187,26529050,26530076,26531047,26531981,26533251,26534849,26537637,26540832,26541791,26542277,26543562,26549903,26552004,26595567,26595607,26595707,26595788,26595852,26595892,26595931,26595966,26596070,26596104,26596140,26596195,26596233,26596317,26596378,26596465,26596503,26596568,26596632,26596725,26597143,26598765,26600587,26600793,26600970,26603464,26604587,26606064,26607216,26608166,26608948,26609927,26611077,26612173,26613008,26613850,26614760,26615515,26616258,26617986,26618255,26621813,26621921,26621955,26622151,26623807,26624041,26699844,26699937,26700375,26700568,26700624,26700871,26701559,26701648,26701879,26702116,26702404,26703535,26703880,26704068,26704775,26738324,26742208,26749890,26752573,26754310,2675718', 'assoc_port': '26415984:26418950,26415987:26418373,26415990:26418722,26415993:26418867,26415995:26418151,26415999:26418514,26416002:26418042,26416005:26417950,26416009:26417965,26416011:26417613,26416013:26417446,26416015:26420365,26416025:26416616,26416031:26416200,26505117:26512807,26505120:26510032,26505124:26510235,26505134:26509409,26505137:26508738,26505141:26508762,26505145:26507804,26505155:26518187,26505163:26507492,26505168:26506987,26505182:26506485,26505184:26506433,26505188:26506050,26505193:26512450,26505195:26512535,26505212:26505699,26505215:26505778,26508172:26508837,26510964:26511592,26528478:26529050,26529907:26530076,26530876:26531047,26531852:26531981,26533059:26533251,26534733:26542277,26534738:26534849,26534741:26541791,26537061:26537637,26540397:26540832,26543381:26543562,26546193:26552004,26549407:26549903,26595441:26595788,26595444:26596725,26595446:26596568,26595448:26596632,26595450:26596378,26595453:26596503,26595455:26596317,26595457:26596195,26595459:26596465,26595461:26596233,26595463:2659596', 'assoc_mat': '26415984:pehd:4230:26418950,26415987:pehd:4230:26418373,26415990:pehd:4230:26418722,26415993:pehd:4230:26418867,26415995:pehd:4230:26418151,26415999:pehd:4230:26418514,26416002:pehd:4230:26418042,26416005:pehd:4230:26417950,26416009:pehd:4230:26417965,26416011:pehd:4230:26417613,26416013:pehd:4230:26417446,26416015:pehd:4230:26420365,26416025:pehd:4230:26416616,26416031:pehd:4230:26416200,26505117:pehd:4230:26512807,26505120:pehd:4230:26510032,26505124:pehd:4230:26510235,26505134:pehd:4230:26509409,26505137:pehd:4230:26508738,26505141:pehd:4230:26508762,26505145:pehd:4230:26507804,26505155:pehd:4230:26518187,26505163:pehd:4230:26507492,26505168:pehd:4230:26506987,26505182:pehd:4230:26506485,26505184:pehd:4230:26506433,26505188:pehd:4230:26506050,26505193:pehd:4230:26512450,26505195:pehd:4230:26512535,26505212:pehd:4230:26505699,26505215:pehd:4230:26505778,26508172:pehd:4230:26508837,26510964:pehd:4230:26511592,26528478:pehd:4230:26529050,26529907:pehd:4230:26530076,26530876:pehd:4230:26531047,26531852:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00917162072499243, 'nb_photo': 14562, 'list_port_cont': '26416208,26416249,26416448,26416484,26416613,26416681,26417120,26417148,26417438,26417604,26417836,26417943,26417967,26418037,26418160,26418371,26418520,26418691,26418731,26418877,26418951,26419174,26419715,26420351,26505535,26505707,26505782,26505867,26506051,26506438,26506493,26506992,26507497,26507799,26508729,26508774,26508841,26509151,26509406,26509868,26510018,26510247,26511597,26512442,26512477,26512547,26512817,26518185,26529054,26530075,26531052,26531972,26533257,26534848,26537639,26540831,26541782,26542283,26543568,26549904,26552002,26552148,26595569,26595602,26595709,26595742,26595794,26595856,26595897,26595925,26595958,26596071,26596107,26596143,26596193,26596242,26596321,26596373,26596475,26596508,26596577,26596628,26596687,26596724,26597146,26598766,26600594,26600800,26600973,26602146,26603462,26604581,26606060,26607210,26608153,26608947,26609923,26611075,26612168,26613007,26613839,26614761,26615528,26616255,26618001,26618252,26621806,26621883,26621917,26621947,26622150,26623796,26624037,2669926', 'assoc_port': '26415981:26419174,26415984:26418951,26415987:26418371,26415990:26418731,26415993:26418877,26415995:26418160,26415999:26418520,26416002:26418037,26416005:26417943,26416007:26417836,26416009:26417967,26416011:26417604,26416013:26417438,26416015:26420351,26416017:26417148,26416019:26417120,26416021:26416448,26416023:26416681,26416025:26416613,26416027:26416484,26416029:26416249,26416031:26416208,26418180:26418691,26419551:26419715,26505117:26512817,26505120:26510018,26505124:26510247,26505127:26509868,26505131:26509151,26505134:26509406,26505137:26508729,26505141:26508774,26505145:26507799,26505155:26518185,26505163:26507497,26505168:26506992,26505182:26506493,26505184:26506438,26505187:26505867,26505188:26506051,26505190:26505535,26505193:26512442,26505195:26512547,26505209:26512477,26505212:26505707,26505215:26505782,26508172:26508841,26510964:26511597,26528478:26529054,26529907:26530075,26530876:26531052,26531852:26531972,26533059:26533257,26534733:26542283,26534738:26534848,26534741:26541782,26537061:2653763', 'assoc_mat': '26415981:pet_clair:4230:26419174,26415984:pet_clair:4230:26418951,26415987:pet_clair:4230:26418371,26415990:pet_clair:4230:26418731,26415993:pet_clair:4230:26418877,26415995:pet_clair:4230:26418160,26415999:pet_clair:4230:26418520,26416002:pet_clair:4230:26418037,26416005:pet_clair:4230:26417943,26416007:pet_clair:4230:26417836,26416009:pet_clair:4230:26417967,26416011:pet_clair:4230:26417604,26416013:pet_clair:4230:26417438,26416015:pet_clair:4230:26420351,26416017:pet_clair:4230:26417148,26416019:pet_clair:4230:26417120,26416021:pet_clair:4230:26416448,26416023:pet_clair:4230:26416681,26416025:pet_clair:4230:26416613,26416027:pet_clair:4230:26416484,26416029:pet_clair:4230:26416249,26416031:pet_clair:4230:26416208,26418180:pet_clair:4230:26418691,26419551:pet_clair:4230:26419715,26505117:pet_clair:4230:26512817,26505120:pet_clair:4230:26510018,26505124:pet_clair:4230:26510247,26505127:pet_clair:4230:26509868,26505131:pet_clair:4230:26509151,26505134:pet_clair:4230:26509406,26505137:pet_clair:4230:26508729,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024808840707588285, 'nb_photo': 570, 'list_port_cont': '26416255,26417107,26417443,26417963,26418156,26418366,26418693,26419171,26505531,26505710,26505873,26506437,26506981,26507499,26507803,26508730,26508775,26508842,26509140,26511598,26512446,26512484,26512541,26518190,26529060,26531060,26533255,26540828,26541785,26542278,26543565,26549906,26551994,26552151,26595558,26595605,26595731,26595790,26595895,26595927,26595968,26596067,26596100,26596187,26596240,26596470,26596512,26596573,26596732,26597145,26600591,26600795,26600975,26603465,26604585,26606066,26607213,26608168,26609924,26611070,26612169,26613003,26613854,26614768,26615525,26616262,26617992,26618251,26621808,26621915,26622158,26699274,26699505,26699664,26699839,26699935,26700381,26700570,26700613,26700879,26701429,26701563,26701643,26701875,26701924,26702755,26702874,26703512,26704500,26738323,26740103,26742201,26744980,26749880,26752571,26754317,26759853,26768293,26769273,26782317,26913990,26914086,26914224,26914415,26914457,26914623,26914852,26914927,26915697,26918484,26921769,26923872,26930739,2693349', 'assoc_port': '26415981:26419171,26415987:26418366,26415995:26418156,26416009:26417963,26416013:26417443,26416019:26417107,26416029:26416255,26418180:26418693,26505131:26509140,26505137:26508730,26505141:26508775,26505145:26507803,26505155:26518190,26505163:26507499,26505168:26506981,26505184:26506437,26505187:26505873,26505190:26505531,26505193:26512446,26505195:26512541,26505209:26512484,26505212:26505710,26508172:26508842,26510964:26511598,26528478:26529060,26530876:26531060,26533059:26533255,26534733:26542278,26534741:26541785,26540397:26540828,26543381:26543565,26546193:26551994,26549407:26549906,26551985:26552151,26595441:26595790,26595444:26596732,26595446:26596573,26595453:26596512,26595457:26596187,26595459:26596470,26595461:26596240,26595463:26595968,26595465:26596067,26595469:26595895,26595470:26596100,26595471:26595927,26595472:26595731,26595475:26595558,26595476:26595605,26596754:26597145,26600516:26600591,26600684:26600795,26600855:26600975,26602822:26603465,26604427:26604585,26605718:26606066,26606867:2660721', 'assoc_mat': '26415981:pet_fonce:4230:26419171,26415987:pet_fonce:4230:26418366,26415995:pet_fonce:4230:26418156,26416009:pet_fonce:4230:26417963,26416013:pet_fonce:4230:26417443,26416019:pet_fonce:4230:26417107,26416029:pet_fonce:4230:26416255,26418180:pet_fonce:4230:26418693,26505131:pet_fonce:4230:26509140,26505137:pet_fonce:4230:26508730,26505141:pet_fonce:4230:26508775,26505145:pet_fonce:4230:26507803,26505155:pet_fonce:4230:26518190,26505163:pet_fonce:4230:26507499,26505168:pet_fonce:4230:26506981,26505184:pet_fonce:4230:26506437,26505187:pet_fonce:4230:26505873,26505190:pet_fonce:4230:26505531,26505193:pet_fonce:4230:26512446,26505195:pet_fonce:4230:26512541,26505209:pet_fonce:4230:26512484,26505212:pet_fonce:4230:26505710,26508172:pet_fonce:4230:26508842,26510964:pet_fonce:4230:26511598,26528478:pet_fonce:4230:26529060,26530876:pet_fonce:4230:26531060,26533059:pet_fonce:4230:26533255,26534733:pet_fonce:4230:26542278,26534741:pet_fonce:4230:26541785,26540397:pet_fonce:4230:26540828,26543381:pet_fonce:4230:26543565,2'}), 'main_stat': {'nb_photos': 1293}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-09', 0.7474800883164087),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam7"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4850 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4850 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4850 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4850 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1293,),), 'unwanted_material_monthly_percentage': ((0.7474800883164087,),), 'material_repartition': (('incineration', 1293),), 'material_dict': {'incineration': 1293}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 9, 1), 0.7750631736847354, 4), (datetime.date(2025, 9, 2), 0.7782930195247328, 1), (datetime.date(2025, 9, 3), 0.7342963797862647, 4), (datetime.date(2025, 9, 4), 0.7101623778631369, 3), (datetime.date(2025, 9, 5), 0.6961114195274157, 2), (datetime.date(2025, 9, 6), 0.6657042020406888, 4), (datetime.date(2025, 9, 7), 0.7533869142482872, 3), (datetime.date(2025, 9, 8), 0.7679531067667473, 4), (datetime.date(2025, 9, 9), 0.7766842331883617, 4), (datetime.date(2025, 9, 10), 0.7819153388524994, 3), (datetime.date(2025, 9, 11), 0.7887044449047698, 4), (datetime.date(2025, 9, 12), 0.7404588274591003, 1), (datetime.date(2025, 9, 15), 0.7622483473059163, 4), (datetime.date(2025, 9, 16), 0.7532708300996109, 4), (datetime.date(2025, 9, 17), 0.7552488009561981, 4), (datetime.date(2025, 9, 18), 0.7306394663821413, 4), (datetime.date(2025, 9, 19), 0.7655427231927696, 4), (datetime.date(2025, 9, 20), 0.7418627835377728, 1), (datetime.date(2025, 9, 21), 0.7864895050559099, 1)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 9, 1), 0.7750631736847354, 4), (datetime.date(2025, 9, 2), 0.7782930195247328, 1), (datetime.date(2025, 9, 3), 0.7342963797862647, 4), (datetime.date(2025, 9, 4), 0.7101623778631369, 3), (datetime.date(2025, 9, 5), 0.6961114195274157, 2), (datetime.date(2025, 9, 6), 0.6657042020406888, 4), (datetime.date(2025, 9, 7), 0.7533869142482872, 3), (datetime.date(2025, 9, 8), 0.7679531067667473, 4), (datetime.date(2025, 9, 9), 0.7766842331883617, 4), (datetime.date(2025, 9, 10), 0.7819153388524994, 3), (datetime.date(2025, 9, 11), 0.7887044449047698, 4), (datetime.date(2025, 9, 12), 0.7404588274591003, 1), (datetime.date(2025, 9, 15), 0.7622483473059163, 4), (datetime.date(2025, 9, 16), 0.7532708300996109, 4), (datetime.date(2025, 9, 17), 0.7552488009561981, 4), (datetime.date(2025, 9, 18), 0.7306394663821413, 4), (datetime.date(2025, 9, 19), 0.7655427231927696, 4), (datetime.date(2025, 9, 20), 0.7418627835377728, 1), (datetime.date(2025, 9, 21), 0.7864895050559099, 1))}, 'quality_array': [['-8.44726479195059', '01092025'], ['-8.73497660857683', '02092025'], ['-8.259760294298994', '11092025'], ['-8.651860603632318', '03092025'], ['-8.625078841933787', '04092025'], ['-8.680705669020943', '05092025'], ['-8.580130639238535', '06092025'], ['-8.781827037350743', '07092025'], ['-8.740639057396933', '08092025'], ['-8.626169082768863', '09092025'], ['-8.477232768562832', '10092025'], ['-8.52064172227146', '12092025'], ['-8.642135333188097', '15092025'], ['-8.559526562844862', '16092025'], ['-8.634262477021087', '17092025'], ['-8.45771786284149', '18092025'], ['-8.570222480801284', '19092025'], ['-8.520446769399513', '20092025'], ['-8.559989011950256', '21092025']], 'number_of_batch': ((408,),), 'datou_id_sts': 4850, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012452110676084486, 'nb_photo': 11364, 'list_port_cont': '26416199,26416239,26416431,26416480,26416609,26416663,26417091,26417152,26417432,26417621,26417846,26417935,26417964,26418038,26418143,26418374,26418517,26418694,26418718,26418871,26418946,26419159,26419716,26420352,26505523,26505711,26505772,26505872,26506047,26506444,26506482,26506979,26507488,26507797,26508726,26508766,26508831,26509147,26509413,26509866,26510016,26510242,26511602,26512435,26512488,26512549,26512811,26518181,26529053,26530069,26531057,26531966,26533246,26534850,26537636,26540833,26541790,26542269,26543557,26549898,26552001,26552142,26595551,26595608,26595705,26595734,26595787,26595846,26595890,26595934,26595955,26596063,26596092,26596136,26596184,26596228,26596320,26596375,26596472,26596506,26596565,26596638,26596694,26596721,26597147,26598760,26600588,26600797,26600967,26602135,26603461,26604577,26606053,26607205,26608164,26608936,26609928,26611071,26612170,26613011,26613852,26614759,26615530,26616260,26617988,26618257,26621814,26621871,26621907,26621948,26622152,26623792,26624035,2669927', 'assoc_port': '26415981:26419159,26415984:26418946,26415987:26418374,26415990:26418718,26415993:26418871,26415995:26418143,26415999:26418517,26416002:26418038,26416005:26417935,26416007:26417846,26416009:26417964,26416011:26417621,26416013:26417432,26416015:26420352,26416017:26417152,26416019:26417091,26416021:26416431,26416023:26416663,26416025:26416609,26416027:26416480,26416029:26416239,26416031:26416199,26418180:26418694,26419551:26419716,26505117:26512811,26505120:26510016,26505124:26510242,26505127:26509866,26505131:26509147,26505134:26509413,26505137:26508726,26505141:26508766,26505145:26507797,26505155:26518181,26505163:26507488,26505168:26506979,26505182:26506482,26505184:26506444,26505187:26505872,26505188:26506047,26505190:26505523,26505193:26512435,26505195:26512549,26505209:26512488,26505212:26505711,26505215:26505772,26508172:26508831,26510964:26511602,26528478:26529053,26529907:26530069,26530876:26531057,26531852:26531966,26533059:26533246,26534733:26542269,26534738:26534850,26534741:26541790,26537061:2653763', 'assoc_mat': '26415981:autre:4230:26419159,26415984:autre:4230:26418946,26415987:autre:4230:26418374,26415990:autre:4230:26418718,26415993:autre:4230:26418871,26415995:autre:4230:26418143,26415999:autre:4230:26418517,26416002:autre:4230:26418038,26416005:autre:4230:26417935,26416007:autre:4230:26417846,26416009:autre:4230:26417964,26416011:autre:4230:26417621,26416013:autre:4230:26417432,26416015:autre:4230:26420352,26416017:autre:4230:26417152,26416019:autre:4230:26417091,26416021:autre:4230:26416431,26416023:autre:4230:26416663,26416025:autre:4230:26416609,26416027:autre:4230:26416480,26416029:autre:4230:26416239,26416031:autre:4230:26416199,26418180:autre:4230:26418694,26419551:autre:4230:26419716,26505117:autre:4230:26512811,26505120:autre:4230:26510016,26505124:autre:4230:26510242,26505127:autre:4230:26509866,26505131:autre:4230:26509147,26505134:autre:4230:26509413,26505137:autre:4230:26508726,26505141:autre:4230:26508766,26505145:autre:4230:26507797,26505155:autre:4230:26518181,26505163:autre:4230:26507488,26505168:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.059979366683202515, 'nb_photo': 94585, 'list_port_cont': '26416206,26416250,26416438,26416478,26416611,26416668,26417099,26417151,26417434,26417617,26417835,26417945,26417966,26418043,26418154,26418370,26418519,26418683,26418719,26418863,26418952,26419173,26419718,26420366,26505532,26505704,26505784,26505874,26506052,26506442,26506486,26506988,26507496,26507792,26508733,26508768,26508845,26509148,26509407,26509874,26510030,26510234,26511603,26512449,26512493,26512529,26512813,26518191,26529057,26530077,26531061,26531976,26533254,26534842,26537632,26540834,26541792,26542284,26543559,26549908,26551998,26552146,26595568,26595599,26595706,26595744,26595795,26595857,26595893,26595932,26595964,26596065,26596099,26596131,26596196,26596235,26596322,26596376,26596474,26596507,26596572,26596631,26596695,26596733,26597144,26598768,26600593,26600798,26600966,26602152,26603468,26604579,26606062,26607217,26608167,26608944,26609921,26611078,26612176,26613005,26613848,26614765,26615529,26616254,26618002,26618243,26621798,26621877,26621918,26621953,26622156,26623806,26624043,2669926', 'assoc_port': '26415981:26419173,26415984:26418952,26415987:26418370,26415990:26418719,26415993:26418863,26415995:26418154,26415999:26418519,26416002:26418043,26416005:26417945,26416007:26417835,26416009:26417966,26416011:26417617,26416013:26417434,26416015:26420366,26416017:26417151,26416019:26417099,26416021:26416438,26416023:26416668,26416025:26416611,26416027:26416478,26416029:26416250,26416031:26416206,26418180:26418683,26419551:26419718,26505117:26512813,26505120:26510030,26505124:26510234,26505127:26509874,26505131:26509148,26505134:26509407,26505137:26508733,26505141:26508768,26505145:26507792,26505155:26518191,26505163:26507496,26505168:26506988,26505182:26506486,26505184:26506442,26505187:26505874,26505188:26506052,26505190:26505532,26505193:26512449,26505195:26512529,26505209:26512493,26505212:26505704,26505215:26505784,26508172:26508845,26510964:26511603,26528478:26529057,26529907:26530077,26530876:26531061,26531852:26531976,26533059:26533254,26534733:26542284,26534738:26534842,26534741:26541792,26537061:2653763', 'assoc_mat': '26415981:carton:4230:26419173,26415984:carton:4230:26418952,26415987:carton:4230:26418370,26415990:carton:4230:26418719,26415993:carton:4230:26418863,26415995:carton:4230:26418154,26415999:carton:4230:26418519,26416002:carton:4230:26418043,26416005:carton:4230:26417945,26416007:carton:4230:26417835,26416009:carton:4230:26417966,26416011:carton:4230:26417617,26416013:carton:4230:26417434,26416015:carton:4230:26420366,26416017:carton:4230:26417151,26416019:carton:4230:26417099,26416021:carton:4230:26416438,26416023:carton:4230:26416668,26416025:carton:4230:26416611,26416027:carton:4230:26416478,26416029:carton:4230:26416250,26416031:carton:4230:26416206,26418180:carton:4230:26418683,26419551:carton:4230:26419718,26505117:carton:4230:26512813,26505120:carton:4230:26510030,26505124:carton:4230:26510234,26505127:carton:4230:26509874,26505131:carton:4230:26509148,26505134:carton:4230:26509407,26505137:carton:4230:26508733,26505141:carton:4230:26508768,26505145:carton:4230:26507792,26505155:carton:4230:26518191,2650'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.001543649524638241, 'nb_photo': 1431, 'list_port_cont': '26416209,26416238,26416446,26416602,26416680,26417101,26417155,26417436,26417605,26417833,26417951,26417961,26418046,26418153,26418516,26418690,26418725,26418876,26418949,26419172,26420362,26505519,26505705,26505774,26505857,26506041,26506439,26506494,26506994,26507498,26507801,26508735,26508770,26508844,26509141,26509398,26509860,26510035,26510246,26511590,26512451,26512478,26512527,26512806,26518179,26529052,26530081,26531045,26531965,26533250,26534847,26537629,26540818,26541794,26542276,26543564,26549901,26552000,26552137,26595554,26595704,26595728,26595783,26595858,26595882,26595929,26595960,26596064,26596095,26596132,26596181,26596239,26596324,26596377,26596469,26596514,26596575,26596630,26596686,26596720,26597148,26598755,26602139,26603455,26604573,26606061,26607201,26608161,26608941,26609914,26611081,26612178,26612999,26613843,26614754,26615527,26616259,26617994,26618247,26621801,26621875,26621908,26621942,26622153,26623809,26624028,26699277,26699509,26699659,26699851,26699927,26700367,26700561,2670060', 'assoc_port': '26415981:26419172,26415984:26418949,26415990:26418725,26415993:26418876,26415995:26418153,26415999:26418516,26416002:26418046,26416005:26417951,26416007:26417833,26416009:26417961,26416011:26417605,26416013:26417436,26416015:26420362,26416017:26417155,26416019:26417101,26416021:26416446,26416023:26416680,26416025:26416602,26416029:26416238,26416031:26416209,26418180:26418690,26505117:26512806,26505120:26510035,26505124:26510246,26505127:26509860,26505131:26509141,26505134:26509398,26505137:26508735,26505141:26508770,26505145:26507801,26505155:26518179,26505163:26507498,26505168:26506994,26505182:26506494,26505184:26506439,26505187:26505857,26505188:26506041,26505190:26505519,26505193:26512451,26505195:26512527,26505209:26512478,26505212:26505705,26505215:26505774,26508172:26508844,26510964:26511590,26528478:26529052,26529907:26530081,26530876:26531045,26531852:26531965,26533059:26533250,26534733:26542276,26534738:26534847,26534741:26541794,26537061:26537629,26540397:26540818,26543381:26543564,26546193:2655200', 'assoc_mat': '26415981:metal:4230:26419172,26415984:metal:4230:26418949,26415990:metal:4230:26418725,26415993:metal:4230:26418876,26415995:metal:4230:26418153,26415999:metal:4230:26418516,26416002:metal:4230:26418046,26416005:metal:4230:26417951,26416007:metal:4230:26417833,26416009:metal:4230:26417961,26416011:metal:4230:26417605,26416013:metal:4230:26417436,26416015:metal:4230:26420362,26416017:metal:4230:26417155,26416019:metal:4230:26417101,26416021:metal:4230:26416446,26416023:metal:4230:26416680,26416025:metal:4230:26416602,26416029:metal:4230:26416238,26416031:metal:4230:26416209,26418180:metal:4230:26418690,26505117:metal:4230:26512806,26505120:metal:4230:26510035,26505124:metal:4230:26510246,26505127:metal:4230:26509860,26505131:metal:4230:26509141,26505134:metal:4230:26509398,26505137:metal:4230:26508735,26505141:metal:4230:26508770,26505145:metal:4230:26507801,26505155:metal:4230:26518179,26505163:metal:4230:26507498,26505168:metal:4230:26506994,26505182:metal:4230:26506494,26505184:metal:4230:26506439,26505187:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.17587675656710924, 'nb_photo': 265357, 'list_port_cont': '26416202,26416247,26416443,26416474,26416615,26416677,26417116,26417159,26417442,26417620,26417845,26417942,26417969,26418040,26418159,26418368,26418522,26418695,26418729,26418878,26418941,26419165,26419712,26420363,26505528,26505706,26505783,26505864,26506054,26506445,26506489,26506990,26507491,26507800,26508736,26508769,26508847,26509153,26509412,26509867,26510022,26510236,26511600,26512447,26512495,26512539,26512814,26518189,26529049,26530078,26531054,26531977,26533242,26534851,26537635,26540827,26541781,26542282,26543563,26549910,26552003,26552147,26595562,26595611,26595703,26595745,26595792,26595853,26595896,26595930,26595970,26596058,26596098,26596141,26596189,26596243,26596325,26596370,26596463,26596505,26596561,26596625,26596693,26596731,26597134,26598770,26600595,26600788,26600977,26602147,26603457,26604586,26606059,26607207,26608163,26608942,26609929,26611076,26612175,26613004,26613842,26614763,26615518,26616252,26617980,26618253,26621812,26621885,26621920,26621956,26622155,26623802,26624039,2669927', 'assoc_port': '26415981:26419165,26415984:26418941,26415987:26418368,26415990:26418729,26415993:26418878,26415995:26418159,26415999:26418522,26416002:26418040,26416005:26417942,26416007:26417845,26416009:26417969,26416011:26417620,26416013:26417442,26416015:26420363,26416017:26417159,26416019:26417116,26416021:26416443,26416023:26416677,26416025:26416615,26416027:26416474,26416029:26416247,26416031:26416202,26418180:26418695,26419551:26419712,26505117:26512814,26505120:26510022,26505124:26510236,26505127:26509867,26505131:26509153,26505134:26509412,26505137:26508736,26505141:26508769,26505145:26507800,26505155:26518189,26505163:26507491,26505168:26506990,26505182:26506489,26505184:26506445,26505187:26505864,26505188:26506054,26505190:26505528,26505193:26512447,26505195:26512539,26505209:26512495,26505212:26505706,26505215:26505783,26508172:26508847,26510964:26511600,26528478:26529049,26529907:26530078,26530876:26531054,26531852:26531977,26533059:26533242,26534733:26542282,26534738:26534851,26534741:26541781,26537061:2653763', 'assoc_mat': '26415981:papier:4230:26419165,26415984:papier:4230:26418941,26415987:papier:4230:26418368,26415990:papier:4230:26418729,26415993:papier:4230:26418878,26415995:papier:4230:26418159,26415999:papier:4230:26418522,26416002:papier:4230:26418040,26416005:papier:4230:26417942,26416007:papier:4230:26417845,26416009:papier:4230:26417969,26416011:papier:4230:26417620,26416013:papier:4230:26417442,26416015:papier:4230:26420363,26416017:papier:4230:26417159,26416019:papier:4230:26417116,26416021:papier:4230:26416443,26416023:papier:4230:26416677,26416025:papier:4230:26416615,26416027:papier:4230:26416474,26416029:papier:4230:26416247,26416031:papier:4230:26416202,26418180:papier:4230:26418695,26419551:papier:4230:26419712,26505117:papier:4230:26512814,26505120:papier:4230:26510022,26505124:papier:4230:26510236,26505127:papier:4230:26509867,26505131:papier:4230:26509153,26505134:papier:4230:26509412,26505137:papier:4230:26508736,26505141:papier:4230:26508769,26505145:papier:4230:26507800,26505155:papier:4230:26518189,2650'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0031918308530088663, 'nb_photo': 1203, 'list_port_cont': '26416200,26416616,26417446,26417613,26417950,26417965,26418042,26418151,26418373,26418514,26418722,26418867,26418950,26420365,26505699,26505778,26506050,26506433,26506485,26506987,26507492,26507804,26508738,26508762,26508837,26509409,26510032,26510235,26511592,26512450,26512535,26512807,26518187,26529050,26530076,26531047,26531981,26533251,26534849,26537637,26540832,26541791,26542277,26543562,26549903,26552004,26595567,26595607,26595707,26595788,26595852,26595892,26595931,26595966,26596070,26596104,26596140,26596195,26596233,26596317,26596378,26596465,26596503,26596568,26596632,26596725,26597143,26598765,26600587,26600793,26600970,26603464,26604587,26606064,26607216,26608166,26608948,26609927,26611077,26612173,26613008,26613850,26614760,26615515,26616258,26617986,26618255,26621813,26621921,26621955,26622151,26623807,26624041,26699844,26699937,26700375,26700568,26700624,26700871,26701559,26701648,26701879,26702116,26702404,26703535,26703880,26704068,26704775,26738324,26742208,26749890,26752573,26754310,2675718', 'assoc_port': '26415984:26418950,26415987:26418373,26415990:26418722,26415993:26418867,26415995:26418151,26415999:26418514,26416002:26418042,26416005:26417950,26416009:26417965,26416011:26417613,26416013:26417446,26416015:26420365,26416025:26416616,26416031:26416200,26505117:26512807,26505120:26510032,26505124:26510235,26505134:26509409,26505137:26508738,26505141:26508762,26505145:26507804,26505155:26518187,26505163:26507492,26505168:26506987,26505182:26506485,26505184:26506433,26505188:26506050,26505193:26512450,26505195:26512535,26505212:26505699,26505215:26505778,26508172:26508837,26510964:26511592,26528478:26529050,26529907:26530076,26530876:26531047,26531852:26531981,26533059:26533251,26534733:26542277,26534738:26534849,26534741:26541791,26537061:26537637,26540397:26540832,26543381:26543562,26546193:26552004,26549407:26549903,26595441:26595788,26595444:26596725,26595446:26596568,26595448:26596632,26595450:26596378,26595453:26596503,26595455:26596317,26595457:26596195,26595459:26596465,26595461:26596233,26595463:2659596', 'assoc_mat': '26415984:pehd:4230:26418950,26415987:pehd:4230:26418373,26415990:pehd:4230:26418722,26415993:pehd:4230:26418867,26415995:pehd:4230:26418151,26415999:pehd:4230:26418514,26416002:pehd:4230:26418042,26416005:pehd:4230:26417950,26416009:pehd:4230:26417965,26416011:pehd:4230:26417613,26416013:pehd:4230:26417446,26416015:pehd:4230:26420365,26416025:pehd:4230:26416616,26416031:pehd:4230:26416200,26505117:pehd:4230:26512807,26505120:pehd:4230:26510032,26505124:pehd:4230:26510235,26505134:pehd:4230:26509409,26505137:pehd:4230:26508738,26505141:pehd:4230:26508762,26505145:pehd:4230:26507804,26505155:pehd:4230:26518187,26505163:pehd:4230:26507492,26505168:pehd:4230:26506987,26505182:pehd:4230:26506485,26505184:pehd:4230:26506433,26505188:pehd:4230:26506050,26505193:pehd:4230:26512450,26505195:pehd:4230:26512535,26505212:pehd:4230:26505699,26505215:pehd:4230:26505778,26508172:pehd:4230:26508837,26510964:pehd:4230:26511592,26528478:pehd:4230:26529050,26529907:pehd:4230:26530076,26530876:pehd:4230:26531047,26531852:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.00917162072499243, 'nb_photo': 14562, 'list_port_cont': '26416208,26416249,26416448,26416484,26416613,26416681,26417120,26417148,26417438,26417604,26417836,26417943,26417967,26418037,26418160,26418371,26418520,26418691,26418731,26418877,26418951,26419174,26419715,26420351,26505535,26505707,26505782,26505867,26506051,26506438,26506493,26506992,26507497,26507799,26508729,26508774,26508841,26509151,26509406,26509868,26510018,26510247,26511597,26512442,26512477,26512547,26512817,26518185,26529054,26530075,26531052,26531972,26533257,26534848,26537639,26540831,26541782,26542283,26543568,26549904,26552002,26552148,26595569,26595602,26595709,26595742,26595794,26595856,26595897,26595925,26595958,26596071,26596107,26596143,26596193,26596242,26596321,26596373,26596475,26596508,26596577,26596628,26596687,26596724,26597146,26598766,26600594,26600800,26600973,26602146,26603462,26604581,26606060,26607210,26608153,26608947,26609923,26611075,26612168,26613007,26613839,26614761,26615528,26616255,26618001,26618252,26621806,26621883,26621917,26621947,26622150,26623796,26624037,2669926', 'assoc_port': '26415981:26419174,26415984:26418951,26415987:26418371,26415990:26418731,26415993:26418877,26415995:26418160,26415999:26418520,26416002:26418037,26416005:26417943,26416007:26417836,26416009:26417967,26416011:26417604,26416013:26417438,26416015:26420351,26416017:26417148,26416019:26417120,26416021:26416448,26416023:26416681,26416025:26416613,26416027:26416484,26416029:26416249,26416031:26416208,26418180:26418691,26419551:26419715,26505117:26512817,26505120:26510018,26505124:26510247,26505127:26509868,26505131:26509151,26505134:26509406,26505137:26508729,26505141:26508774,26505145:26507799,26505155:26518185,26505163:26507497,26505168:26506992,26505182:26506493,26505184:26506438,26505187:26505867,26505188:26506051,26505190:26505535,26505193:26512442,26505195:26512547,26505209:26512477,26505212:26505707,26505215:26505782,26508172:26508841,26510964:26511597,26528478:26529054,26529907:26530075,26530876:26531052,26531852:26531972,26533059:26533257,26534733:26542283,26534738:26534848,26534741:26541782,26537061:2653763', 'assoc_mat': '26415981:pet_clair:4230:26419174,26415984:pet_clair:4230:26418951,26415987:pet_clair:4230:26418371,26415990:pet_clair:4230:26418731,26415993:pet_clair:4230:26418877,26415995:pet_clair:4230:26418160,26415999:pet_clair:4230:26418520,26416002:pet_clair:4230:26418037,26416005:pet_clair:4230:26417943,26416007:pet_clair:4230:26417836,26416009:pet_clair:4230:26417967,26416011:pet_clair:4230:26417604,26416013:pet_clair:4230:26417438,26416015:pet_clair:4230:26420351,26416017:pet_clair:4230:26417148,26416019:pet_clair:4230:26417120,26416021:pet_clair:4230:26416448,26416023:pet_clair:4230:26416681,26416025:pet_clair:4230:26416613,26416027:pet_clair:4230:26416484,26416029:pet_clair:4230:26416249,26416031:pet_clair:4230:26416208,26418180:pet_clair:4230:26418691,26419551:pet_clair:4230:26419715,26505117:pet_clair:4230:26512817,26505120:pet_clair:4230:26510018,26505124:pet_clair:4230:26510247,26505127:pet_clair:4230:26509868,26505131:pet_clair:4230:26509151,26505134:pet_clair:4230:26509406,26505137:pet_clair:4230:26508729,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0024808840707588285, 'nb_photo': 570, 'list_port_cont': '26416255,26417107,26417443,26417963,26418156,26418366,26418693,26419171,26505531,26505710,26505873,26506437,26506981,26507499,26507803,26508730,26508775,26508842,26509140,26511598,26512446,26512484,26512541,26518190,26529060,26531060,26533255,26540828,26541785,26542278,26543565,26549906,26551994,26552151,26595558,26595605,26595731,26595790,26595895,26595927,26595968,26596067,26596100,26596187,26596240,26596470,26596512,26596573,26596732,26597145,26600591,26600795,26600975,26603465,26604585,26606066,26607213,26608168,26609924,26611070,26612169,26613003,26613854,26614768,26615525,26616262,26617992,26618251,26621808,26621915,26622158,26699274,26699505,26699664,26699839,26699935,26700381,26700570,26700613,26700879,26701429,26701563,26701643,26701875,26701924,26702755,26702874,26703512,26704500,26738323,26740103,26742201,26744980,26749880,26752571,26754317,26759853,26768293,26769273,26782317,26913990,26914086,26914224,26914415,26914457,26914623,26914852,26914927,26915697,26918484,26921769,26923872,26930739,2693349', 'assoc_port': '26415981:26419171,26415987:26418366,26415995:26418156,26416009:26417963,26416013:26417443,26416019:26417107,26416029:26416255,26418180:26418693,26505131:26509140,26505137:26508730,26505141:26508775,26505145:26507803,26505155:26518190,26505163:26507499,26505168:26506981,26505184:26506437,26505187:26505873,26505190:26505531,26505193:26512446,26505195:26512541,26505209:26512484,26505212:26505710,26508172:26508842,26510964:26511598,26528478:26529060,26530876:26531060,26533059:26533255,26534733:26542278,26534741:26541785,26540397:26540828,26543381:26543565,26546193:26551994,26549407:26549906,26551985:26552151,26595441:26595790,26595444:26596732,26595446:26596573,26595453:26596512,26595457:26596187,26595459:26596470,26595461:26596240,26595463:26595968,26595465:26596067,26595469:26595895,26595470:26596100,26595471:26595927,26595472:26595731,26595475:26595558,26595476:26595605,26596754:26597145,26600516:26600591,26600684:26600795,26600855:26600975,26602822:26603465,26604427:26604585,26605718:26606066,26606867:2660721', 'assoc_mat': '26415981:pet_fonce:4230:26419171,26415987:pet_fonce:4230:26418366,26415995:pet_fonce:4230:26418156,26416009:pet_fonce:4230:26417963,26416013:pet_fonce:4230:26417443,26416019:pet_fonce:4230:26417107,26416029:pet_fonce:4230:26416255,26418180:pet_fonce:4230:26418693,26505131:pet_fonce:4230:26509140,26505137:pet_fonce:4230:26508730,26505141:pet_fonce:4230:26508775,26505145:pet_fonce:4230:26507803,26505155:pet_fonce:4230:26518190,26505163:pet_fonce:4230:26507499,26505168:pet_fonce:4230:26506981,26505184:pet_fonce:4230:26506437,26505187:pet_fonce:4230:26505873,26505190:pet_fonce:4230:26505531,26505193:pet_fonce:4230:26512446,26505195:pet_fonce:4230:26512541,26505209:pet_fonce:4230:26512484,26505212:pet_fonce:4230:26505710,26508172:pet_fonce:4230:26508842,26510964:pet_fonce:4230:26511598,26528478:pet_fonce:4230:26529060,26530876:pet_fonce:4230:26531060,26533059:pet_fonce:4230:26533255,26534733:pet_fonce:4230:26542278,26534741:pet_fonce:4230:26541785,26540397:pet_fonce:4230:26540828,26543381:pet_fonce:4230:26543565,2'}), 'main_stat': {'nb_photos': 1293}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-09', 0.7474800883164087),)]} filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_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.25%', 11364], 'carton': ['carton', '6.0%', 94585], 'metal': ['metal', '0.15%', 1431], 'papier': ['papier', '17.59%', 265357], 'pehd': ['pehd', '0.32%', 1203], 'pet_clair': ['pet_clair', '0.92%', 14562], 'pet_fonce': ['pet_fonce', '0.25%', 570]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam7/sla_mensuel_SCCU_cam7_mois_09_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam7 2.36user 2.09system 0:08.24elapsed 54%CPU (0avgtext+0avgdata 176140maxresident)k 60712inputs+280outputs (284major+44348minor)pagefaults 0swaps