python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_4/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-08 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (4, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 08 mtr_id : dashboard_places : SCCU_cam8 date : 2025-08 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-08%') and created_at like '%2025-08%'))); nb_day : (4, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where ded.dashboard_place_id = 203 and month(ded.date) = 08 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), nombre_balle FROM MTRPhoto.dashboard_results dr, MTRPhoto.dashboard_entry_day ded where dr.hashtag = '_______incineration' and ded.dashboard_place_id = 203 and month(ded.date) = 08 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%082025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-08-01 : dt_date_just_month_year : 2025-08-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-08-01" AND ded.date <= "2025-08-31" 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 (2056921,2061673,2062293,2069405,2077255,2084727,2092447,2099715,2103943,2104511,2111947,2118525,2121853,2129595,2136739,2140389,2147853,2154193,2161061,2166123,2170033,2174073,2174715,2180793,2187781,2194893,2201507,2208129,2212787,2213807) 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.013559052185383483, 'nb_photo': 17447, 'list_port_cont': '25576292,25576479,25577337,25578756,25580423,25581773,25582554,25583476,25584231,25584843,25585498,25586084,25586756,25589932,25591530,25593162,25593311,25593539,25593673,25593863,25594079,25594583,25601698,25601959,25614675,25614729,25614773,25614872,25614984,25615040,25615097,25615176,25615222,25615309,25615319,25615391,25615431,25615487,25615523,25615572,25615598,25615694,25615704,25615754,25615812,25615940,25616841,25617229,25622174,25622487,25622607,25623134,25623419,25623463,25623609,25623709,25623764,25623796,25623836,25623857,25623931,25623977,25624002,25624082,25624098,25624161,25624194,25624233,25624259,25624308,25624424,25624526,25651863,25651987,25652117,25652167,25652257,25652408,25652545,25652731,25652877,25652984,25653042,25653081,25653282,25653345,25653470,25653687,25653742,25653893,25654092,25654229,25654515,25656913,25657226,25658864,25705304,25705343,25705400,25705486,25705559,25705618,25705653,25705676,25705725,25705776,25705815,25705843,25705880,25705981,25706056,25706144,25706197,2570624', 'assoc_port': '25576161:25576292,25576368:25576479,25577110:25577337,25578309:25578756,25580270:25580423,25581466:25581773,25582370:25582554,25583280:25583476,25584040:25584231,25584706:25584843,25585392:25585498,25585950:25586084,25586641:25586756,25588023:25601698,25589708:25589932,25591337:25591530,25592806:25593162,25592810:25593311,25592813:25593673,25592818:25593539,25592821:25593863,25592826:25594079,25594537:25594583,25595246:25601959,25614550:25615812,25614553:25615940,25614555:25615694,25614558:25615754,25614561:25615704,25614565:25615523,25614568:25615598,25614572:25615487,25614576:25615572,25614581:25615431,25614583:25615391,25614586:25615309,25614588:25615319,25614591:25615176,25614593:25615097,25614596:25615222,25614598:25615040,25614600:25614984,25614601:25614872,25614603:25614675,25614605:25614729,25614606:25614773,25616544:25616841,25617204:25617229,25621893:25622174,25621894:25622487,25621895:25622607,25621896:25623134,25621897:25623419,25621899:25623709,25621902:25623796,25621904:25624098,25621906:2562425', 'assoc_mat': '25576161:autre:4230:25576292,25576368:autre:4230:25576479,25577110:autre:4230:25577337,25578309:autre:4230:25578756,25580270:autre:4230:25580423,25581466:autre:4230:25581773,25582370:autre:4230:25582554,25583280:autre:4230:25583476,25584040:autre:4230:25584231,25584706:autre:4230:25584843,25585392:autre:4230:25585498,25585950:autre:4230:25586084,25586641:autre:4230:25586756,25588023:autre:4230:25601698,25589708:autre:4230:25589932,25591337:autre:4230:25591530,25592806:autre:4230:25593162,25592810:autre:4230:25593311,25592813:autre:4230:25593673,25592818:autre:4230:25593539,25592821:autre:4230:25593863,25592826:autre:4230:25594079,25594537:autre:4230:25594583,25595246:autre:4230:25601959,25614550:autre:4230:25615812,25614553:autre:4230:25615940,25614555:autre:4230:25615694,25614558:autre:4230:25615754,25614561:autre:4230:25615704,25614565:autre:4230:25615523,25614568:autre:4230:25615598,25614572:autre:4230:25615487,25614576:autre:4230:25615572,25614581:autre:4230:25615431,25614583:autre:4230:25615391,25614586:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05793916929198872, 'nb_photo': 96720, 'list_port_cont': '25576303,25576485,25577346,25578760,25580425,25581786,25582566,25583484,25584232,25584856,25585507,25586076,25586764,25589943,25591531,25593165,25593317,25593542,25593689,25593872,25594096,25594573,25601719,25601957,25614677,25614717,25614777,25614874,25614990,25615044,25615106,25615172,25615214,25615311,25615332,25615392,25615445,25615494,25615528,25615564,25615608,25615685,25615714,25615771,25615816,25615941,25616854,25617220,25622177,25622482,25622618,25623136,25623426,25623464,25623619,25623698,25623760,25623793,25623837,25623858,25623945,25623971,25624014,25624083,25624109,25624148,25624196,25624236,25624268,25624303,25624422,25624536,25651868,25651985,25652128,25652160,25652268,25652411,25652550,25652736,25652882,25652993,25653049,25653090,25653289,25653343,25653472,25653690,25653751,25653903,25654093,25654240,25654524,25656922,25657227,25658874,25705314,25705344,25705410,25705483,25705564,25705617,25705646,25705693,25705727,25705781,25705808,25705853,25705888,25705977,25706047,25706139,25706196,2570625', 'assoc_port': '25576161:25576303,25576368:25576485,25577110:25577346,25578309:25578760,25580270:25580425,25581466:25581786,25582370:25582566,25583280:25583484,25584040:25584232,25584706:25584856,25585392:25585507,25585950:25586076,25586641:25586764,25588023:25601719,25589708:25589943,25591337:25591531,25592806:25593165,25592810:25593317,25592813:25593689,25592818:25593542,25592821:25593872,25592826:25594096,25594537:25594573,25595246:25601957,25614550:25615816,25614553:25615941,25614555:25615685,25614558:25615771,25614561:25615714,25614565:25615528,25614568:25615608,25614572:25615494,25614576:25615564,25614581:25615445,25614583:25615392,25614586:25615311,25614588:25615332,25614591:25615172,25614593:25615106,25614596:25615214,25614598:25615044,25614600:25614990,25614601:25614874,25614603:25614677,25614605:25614717,25614606:25614777,25616544:25616854,25617204:25617220,25621893:25622177,25621894:25622482,25621895:25622618,25621896:25623136,25621897:25623426,25621899:25623698,25621902:25623793,25621904:25624109,25621906:2562426', 'assoc_mat': '25576161:carton:4230:25576303,25576368:carton:4230:25576485,25577110:carton:4230:25577346,25578309:carton:4230:25578760,25580270:carton:4230:25580425,25581466:carton:4230:25581786,25582370:carton:4230:25582566,25583280:carton:4230:25583484,25584040:carton:4230:25584232,25584706:carton:4230:25584856,25585392:carton:4230:25585507,25585950:carton:4230:25586076,25586641:carton:4230:25586764,25588023:carton:4230:25601719,25589708:carton:4230:25589943,25591337:carton:4230:25591531,25592806:carton:4230:25593165,25592810:carton:4230:25593317,25592813:carton:4230:25593689,25592818:carton:4230:25593542,25592821:carton:4230:25593872,25592826:carton:4230:25594096,25594537:carton:4230:25594573,25595246:carton:4230:25601957,25614550:carton:4230:25615816,25614553:carton:4230:25615941,25614555:carton:4230:25615685,25614558:carton:4230:25615771,25614561:carton:4230:25615714,25614565:carton:4230:25615528,25614568:carton:4230:25615608,25614572:carton:4230:25615494,25614576:carton:4230:25615564,25614581:carton:4230:25615445,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010623059784067128, 'nb_photo': 1615, 'list_port_cont': '25576299,25576488,25577338,25578755,25580416,25581775,25582565,25583478,25584217,25586070,25586766,25593154,25593319,25593529,25593688,25593862,25594078,25601718,25614665,25614733,25614873,25614983,25615033,25615098,25615174,25615217,25615315,25615334,25615385,25615440,25615531,25615555,25615709,25615764,25615802,25615936,25616857,25623424,25623608,25623695,25623785,25623833,25623873,25623937,25623975,25624017,25624087,25624094,25624149,25624220,25624265,25651860,25651986,25652123,25652172,25652258,25652412,25652548,25652735,25652884,25652997,25653074,25653473,25656924,25657222,25658859,25705302,25705347,25705409,25705561,25705613,25705657,25705689,25705721,25705769,25705854,25705883,25705980,25706059,25706132,25706201,25706253,25706291,25706373,25706411,25706648,25707001,25709245,25709576,25711254,25712996,25715449,25718142,25720627,25723325,25725500,25728886,25733627,25735614,25736500,25741984,25744250,25749013,25749235,25751601,25797194,25797469,25797592,25797909,25797947,25798025,25798106,25798181,2579833', 'assoc_port': '25576161:25576299,25576368:25576488,25577110:25577338,25578309:25578755,25580270:25580416,25581466:25581775,25582370:25582565,25583280:25583478,25584040:25584217,25585950:25586070,25586641:25586766,25588023:25601718,25592806:25593154,25592810:25593319,25592813:25593688,25592818:25593529,25592821:25593862,25592826:25594078,25614550:25615802,25614553:25615936,25614558:25615764,25614561:25615709,25614565:25615531,25614576:25615555,25614581:25615440,25614583:25615385,25614586:25615315,25614588:25615334,25614591:25615174,25614593:25615098,25614596:25615217,25614598:25615033,25614600:25614983,25614601:25614873,25614603:25614665,25614605:25614733,25616544:25616857,25621897:25623424,25621899:25623695,25621902:25623785,25621904:25624094,25621906:25624265,25621912:25624220,25621914:25624087,25621916:25624017,25621918:25623975,25621922:25623937,25621925:25624149,25621929:25623873,25621932:25623833,25621942:25623608,25651370:25653473,25651377:25653074,25651378:25652997,25651379:25652548,25651382:25652884,25651383:2565273', 'assoc_mat': '25576161:metal:4230:25576299,25576368:metal:4230:25576488,25577110:metal:4230:25577338,25578309:metal:4230:25578755,25580270:metal:4230:25580416,25581466:metal:4230:25581775,25582370:metal:4230:25582565,25583280:metal:4230:25583478,25584040:metal:4230:25584217,25585950:metal:4230:25586070,25586641:metal:4230:25586766,25588023:metal:4230:25601718,25592806:metal:4230:25593154,25592810:metal:4230:25593319,25592813:metal:4230:25593688,25592818:metal:4230:25593529,25592821:metal:4230:25593862,25592826:metal:4230:25594078,25614550:metal:4230:25615802,25614553:metal:4230:25615936,25614558:metal:4230:25615764,25614561:metal:4230:25615709,25614565:metal:4230:25615531,25614576:metal:4230:25615555,25614581:metal:4230:25615440,25614583:metal:4230:25615385,25614586:metal:4230:25615315,25614588:metal:4230:25615334,25614591:metal:4230:25615174,25614593:metal:4230:25615098,25614596:metal:4230:25615217,25614598:metal:4230:25615033,25614600:metal:4230:25614983,25614601:metal:4230:25614873,25614603:metal:4230:25614665,25614605:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18663974866012537, 'nb_photo': 386200, 'list_port_cont': '25576307,25576483,25577341,25578757,25580421,25581784,25582570,25583491,25584233,25584851,25585512,25586082,25586762,25589949,25591556,25593164,25593315,25593540,25593687,25593874,25594092,25594581,25601708,25601949,25614682,25614724,25614768,25614870,25614991,25615039,25615107,25615179,25615216,25615308,25615331,25615397,25615441,25615492,25615535,25615567,25615606,25615684,25615701,25615769,25615811,25615944,25616852,25617230,25622171,25622485,25622615,25623142,25623434,25623469,25623613,25623699,25623761,25623792,25623823,25623870,25623940,25623976,25624013,25624088,25624096,25624156,25624186,25624228,25624272,25624301,25624419,25624524,25651864,25651992,25652131,25652168,25652267,25652417,25652549,25652728,25652883,25652992,25653050,25653088,25653296,25653342,25653478,25653699,25653752,25653899,25654099,25654250,25654513,25656925,25657228,25658875,25705315,25705352,25705404,25705473,25705572,25705619,25705654,25705688,25705728,25705773,25705814,25705851,25705894,25705983,25706055,25706140,25706202,2570625', 'assoc_port': '25576161:25576307,25576368:25576483,25577110:25577341,25578309:25578757,25580270:25580421,25581466:25581784,25582370:25582570,25583280:25583491,25584040:25584233,25584706:25584851,25585392:25585512,25585950:25586082,25586641:25586762,25588023:25601708,25589708:25589949,25591337:25591556,25592806:25593164,25592810:25593315,25592813:25593687,25592818:25593540,25592821:25593874,25592826:25594092,25594537:25594581,25595246:25601949,25614550:25615811,25614553:25615944,25614555:25615684,25614558:25615769,25614561:25615701,25614565:25615535,25614568:25615606,25614572:25615492,25614576:25615567,25614581:25615441,25614583:25615397,25614586:25615308,25614588:25615331,25614591:25615179,25614593:25615107,25614596:25615216,25614598:25615039,25614600:25614991,25614601:25614870,25614603:25614682,25614605:25614724,25614606:25614768,25616544:25616852,25617204:25617230,25621893:25622171,25621894:25622485,25621895:25622615,25621896:25623142,25621897:25623434,25621899:25623699,25621902:25623792,25621904:25624096,25621906:2562427', 'assoc_mat': '25576161:papier:4230:25576307,25576368:papier:4230:25576483,25577110:papier:4230:25577341,25578309:papier:4230:25578757,25580270:papier:4230:25580421,25581466:papier:4230:25581784,25582370:papier:4230:25582570,25583280:papier:4230:25583491,25584040:papier:4230:25584233,25584706:papier:4230:25584851,25585392:papier:4230:25585512,25585950:papier:4230:25586082,25586641:papier:4230:25586762,25588023:papier:4230:25601708,25589708:papier:4230:25589949,25591337:papier:4230:25591556,25592806:papier:4230:25593164,25592810:papier:4230:25593315,25592813:papier:4230:25593687,25592818:papier:4230:25593540,25592821:papier:4230:25593874,25592826:papier:4230:25594092,25594537:papier:4230:25594581,25595246:papier:4230:25601949,25614550:papier:4230:25615811,25614553:papier:4230:25615944,25614555:papier:4230:25615684,25614558:papier:4230:25615769,25614561:papier:4230:25615701,25614565:papier:4230:25615535,25614568:papier:4230:25615606,25614572:papier:4230:25615492,25614576:papier:4230:25615567,25614581:papier:4230:25615441,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002711428233918777, 'nb_photo': 1817, 'list_port_cont': '25576308,25576481,25577345,25578751,25580417,25581782,25582567,25583490,25584222,25584855,25585504,25586086,25586767,25589945,25591546,25593159,25593321,25593544,25593683,25594094,25594585,25601720,25601953,25614670,25614731,25614774,25614866,25614988,25615043,25615104,25615173,25615225,25615306,25615330,25615400,25615432,25615496,25615533,25615566,25615607,25615696,25615711,25615765,25615818,25615947,25617223,25622180,25622491,25622617,25623140,25623421,25623708,25624009,25624106,25651873,25651982,25652125,25652165,25652261,25652415,25652552,25652739,25652888,25653002,25653338,25653466,25654095,25656916,25657225,25658870,25705318,25705412,25705484,25705576,25705620,25705650,25705680,25705726,25705772,25705850,25705897,25705979,25706054,25706137,25706204,25706258,25706299,25706372,25706412,25706645,25707009,25709577,25711262,25713016,25715447,25718143,25720636,25723328,25725502,25727143,25728890,25733621,25736499,25739742,25741990,25744253,25749028,25749228,25753669,25797848,25798026,25798104,25798143,2579818', 'assoc_port': '25576161:25576308,25576368:25576481,25577110:25577345,25578309:25578751,25580270:25580417,25581466:25581782,25582370:25582567,25583280:25583490,25584040:25584222,25584706:25584855,25585392:25585504,25585950:25586086,25586641:25586767,25588023:25601720,25589708:25589945,25591337:25591546,25592806:25593159,25592810:25593321,25592813:25593683,25592818:25593544,25592826:25594094,25594537:25594585,25595246:25601953,25614550:25615818,25614553:25615947,25614555:25615696,25614558:25615765,25614561:25615711,25614565:25615533,25614568:25615607,25614572:25615496,25614576:25615566,25614581:25615432,25614583:25615400,25614586:25615306,25614588:25615330,25614591:25615173,25614593:25615104,25614596:25615225,25614598:25615043,25614600:25614988,25614601:25614866,25614603:25614670,25614605:25614731,25614606:25614774,25617204:25617223,25621893:25622180,25621894:25622491,25621895:25622617,25621896:25623140,25621897:25623421,25621899:25623708,25621904:25624106,25621916:25624009,25651365:25654095,25651370:25653466,25651374:2565333', 'assoc_mat': '25576161:pehd:4230:25576308,25576368:pehd:4230:25576481,25577110:pehd:4230:25577345,25578309:pehd:4230:25578751,25580270:pehd:4230:25580417,25581466:pehd:4230:25581782,25582370:pehd:4230:25582567,25583280:pehd:4230:25583490,25584040:pehd:4230:25584222,25584706:pehd:4230:25584855,25585392:pehd:4230:25585504,25585950:pehd:4230:25586086,25586641:pehd:4230:25586767,25588023:pehd:4230:25601720,25589708:pehd:4230:25589945,25591337:pehd:4230:25591546,25592806:pehd:4230:25593159,25592810:pehd:4230:25593321,25592813:pehd:4230:25593683,25592818:pehd:4230:25593544,25592826:pehd:4230:25594094,25594537:pehd:4230:25594585,25595246:pehd:4230:25601953,25614550:pehd:4230:25615818,25614553:pehd:4230:25615947,25614555:pehd:4230:25615696,25614558:pehd:4230:25615765,25614561:pehd:4230:25615711,25614565:pehd:4230:25615533,25614568:pehd:4230:25615607,25614572:pehd:4230:25615496,25614576:pehd:4230:25615566,25614581:pehd:4230:25615432,25614583:pehd:4230:25615400,25614586:pehd:4230:25615306,25614588:pehd:4230:25615330,25614591:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0125693767112534, 'nb_photo': 21543, 'list_port_cont': '25576306,25576482,25577347,25578759,25580424,25581777,25582562,25583488,25584230,25584848,25585509,25586083,25586759,25589948,25591550,25593155,25593322,25593545,25593682,25593875,25594084,25594582,25601694,25601954,25614681,25614725,25614775,25614878,25614981,25615037,25615105,25615175,25615220,25615317,25615325,25615398,25615444,25615491,25615530,25615571,25615604,25615690,25615710,25615767,25615817,25615939,25616858,25617225,25622173,25622477,25622616,25623141,25623427,25623471,25623618,25623705,25623763,25623790,25623826,25623872,25623946,25623978,25624018,25624080,25624105,25624162,25624185,25624234,25624269,25624307,25624421,25624534,25651867,25651981,25652120,25652166,25652259,25652409,25652547,25652741,25652887,25652990,25653043,25653086,25653293,25653325,25653476,25653700,25653747,25653896,25654094,25654238,25654520,25656915,25657231,25658866,25705312,25705354,25705405,25705487,25705569,25705612,25705648,25705685,25705717,25705780,25705811,25705841,25705892,25705982,25706048,25706145,25706205,2570625', 'assoc_port': '25576161:25576306,25576368:25576482,25577110:25577347,25578309:25578759,25580270:25580424,25581466:25581777,25582370:25582562,25583280:25583488,25584040:25584230,25584706:25584848,25585392:25585509,25585950:25586083,25586641:25586759,25588023:25601694,25589708:25589948,25591337:25591550,25592806:25593155,25592810:25593322,25592813:25593682,25592818:25593545,25592821:25593875,25592826:25594084,25594537:25594582,25595246:25601954,25614550:25615817,25614553:25615939,25614555:25615690,25614558:25615767,25614561:25615710,25614565:25615530,25614568:25615604,25614572:25615491,25614576:25615571,25614581:25615444,25614583:25615398,25614586:25615317,25614588:25615325,25614591:25615175,25614593:25615105,25614596:25615220,25614598:25615037,25614600:25614981,25614601:25614878,25614603:25614681,25614605:25614725,25614606:25614775,25616544:25616858,25617204:25617225,25621893:25622173,25621894:25622477,25621895:25622616,25621896:25623141,25621897:25623427,25621899:25623705,25621902:25623790,25621904:25624105,25621906:2562426', 'assoc_mat': '25576161:pet_clair:4230:25576306,25576368:pet_clair:4230:25576482,25577110:pet_clair:4230:25577347,25578309:pet_clair:4230:25578759,25580270:pet_clair:4230:25580424,25581466:pet_clair:4230:25581777,25582370:pet_clair:4230:25582562,25583280:pet_clair:4230:25583488,25584040:pet_clair:4230:25584230,25584706:pet_clair:4230:25584848,25585392:pet_clair:4230:25585509,25585950:pet_clair:4230:25586083,25586641:pet_clair:4230:25586759,25588023:pet_clair:4230:25601694,25589708:pet_clair:4230:25589948,25591337:pet_clair:4230:25591550,25592806:pet_clair:4230:25593155,25592810:pet_clair:4230:25593322,25592813:pet_clair:4230:25593682,25592818:pet_clair:4230:25593545,25592821:pet_clair:4230:25593875,25592826:pet_clair:4230:25594084,25594537:pet_clair:4230:25594582,25595246:pet_clair:4230:25601954,25614550:pet_clair:4230:25615817,25614553:pet_clair:4230:25615939,25614555:pet_clair:4230:25615690,25614558:pet_clair:4230:25615767,25614561:pet_clair:4230:25615710,25614565:pet_clair:4230:25615530,25614568:pet_clair:4230:25615604,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021857661120444484, 'nb_photo': 1170, 'list_port_cont': '25576296,25576491,25577344,25578763,25580419,25581785,25582569,25583485,25584224,25584852,25585515,25586085,25586761,25589940,25591548,25593166,25593316,25593538,25593686,25593869,25594091,25594580,25601721,25601960,25614680,25614722,25614772,25614877,25614986,25615038,25615095,25615180,25615212,25615305,25615335,25615395,25615446,25615497,25615526,25615563,25615605,25615687,25615705,25615768,25615810,25615931,25622176,25623145,25623433,25623938,25624306,25651875,25651994,25652126,25652159,25652262,25652413,25652541,25652733,25652890,25653346,25656919,25657230,25658867,25705311,25705355,25705413,25705687,25705729,25705778,25705819,25705842,25705893,25705973,25706045,25706143,25706206,25706256,25706301,25706375,25706403,25706649,25707469,25708680,25709586,25711255,25713004,25715445,25718151,25720631,25723323,25725490,25727153,25728899,25733622,25735619,25736497,25749025,25749156,25749238,25797332,25797596,25797629,25797851,25798113,25798149,25798250,25798374,25798596,25799669,25824537,25828548,25828619,2582877', 'assoc_port': '25576161:25576296,25576368:25576491,25577110:25577344,25578309:25578763,25580270:25580419,25581466:25581785,25582370:25582569,25583280:25583485,25584040:25584224,25584706:25584852,25585392:25585515,25585950:25586085,25586641:25586761,25588023:25601721,25589708:25589940,25591337:25591548,25592806:25593166,25592810:25593316,25592813:25593686,25592818:25593538,25592821:25593869,25592826:25594091,25594537:25594580,25595246:25601960,25614550:25615810,25614553:25615931,25614555:25615687,25614558:25615768,25614561:25615705,25614565:25615526,25614568:25615605,25614572:25615497,25614576:25615563,25614581:25615446,25614583:25615395,25614586:25615305,25614588:25615335,25614591:25615180,25614593:25615095,25614596:25615212,25614598:25615038,25614600:25614986,25614601:25614877,25614603:25614680,25614605:25614722,25614606:25614772,25621893:25622176,25621896:25623145,25621897:25623433,25621908:25624306,25621922:25623938,25651374:25653346,25651379:25652541,25651382:25652890,25651383:25652733,25651384:25652413,25651387:2565226', 'assoc_mat': '25576161:pet_fonce:4230:25576296,25576368:pet_fonce:4230:25576491,25577110:pet_fonce:4230:25577344,25578309:pet_fonce:4230:25578763,25580270:pet_fonce:4230:25580419,25581466:pet_fonce:4230:25581785,25582370:pet_fonce:4230:25582569,25583280:pet_fonce:4230:25583485,25584040:pet_fonce:4230:25584224,25584706:pet_fonce:4230:25584852,25585392:pet_fonce:4230:25585515,25585950:pet_fonce:4230:25586085,25586641:pet_fonce:4230:25586761,25588023:pet_fonce:4230:25601721,25589708:pet_fonce:4230:25589940,25591337:pet_fonce:4230:25591548,25592806:pet_fonce:4230:25593166,25592810:pet_fonce:4230:25593316,25592813:pet_fonce:4230:25593686,25592818:pet_fonce:4230:25593538,25592821:pet_fonce:4230:25593869,25592826:pet_fonce:4230:25594091,25594537:pet_fonce:4230:25594580,25595246:pet_fonce:4230:25601960,25614550:pet_fonce:4230:25615810,25614553:pet_fonce:4230:25615931,25614555:pet_fonce:4230:25615687,25614558:pet_fonce:4230:25615768,25614561:pet_fonce:4230:25615705,25614565:pet_fonce:4230:25615526,25614568:pet_fonce:4230:25615605,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(2056921,2061673,2062293,2069405,2077255,2084727,2092447,2099715,2103943,2104511,2111947,2118525,2121853,2129595,2136739,2140389,2147853,2154193,2161061,2166123,2170033,2174073,2174715,2180793,2187781,2194893,2201507,2208129,2212787,2213807)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-08-01' and date <= '2025-08-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((2283,),), 'unwanted_material_monthly_percentage': ((0.7575274542453474,),), 'material_repartition': (('incineration', 2283),), 'material_dict': {'incineration': 2283}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 8, 1), 0.7955175040959359, 3), (datetime.date(2025, 8, 2), 0.7883316995707443, 2), (datetime.date(2025, 8, 3), 0.8196706310444642, 2), (datetime.date(2025, 8, 4), 0.7596946180284598, 3), (datetime.date(2025, 8, 5), 0.7288057347501394, 4), (datetime.date(2025, 8, 6), 0.777438622445894, 4), (datetime.date(2025, 8, 7), 0.7943887034037365, 4), (datetime.date(2025, 8, 8), 0.6849042977768496, 3), (datetime.date(2025, 8, 9), 0.6978542930695759, 4), (datetime.date(2025, 8, 10), 0.7144705962310097, 2), (datetime.date(2025, 8, 11), 0.7672377563581254, 3), (datetime.date(2025, 8, 12), 0.7233899491536318, 4), (datetime.date(2025, 8, 13), 0.6976721496741447, 3), (datetime.date(2025, 8, 14), 0.6620917358815678, 4), (datetime.date(2025, 8, 15), 0.6797122189274732, 4), (datetime.date(2025, 8, 16), 0.7125835319195789, 3), (datetime.date(2025, 8, 17), 0.7983181557088513, 1), (datetime.date(2025, 8, 19), 0.7413217390199269, 1), (datetime.date(2025, 8, 20), 0.7444171894601427, 4), (datetime.date(2025, 8, 21), 0.6826408414728259, 3), (datetime.date(2025, 8, 22), 0.7041205418362099, 3), (datetime.date(2025, 8, 23), 0.7296715259179459, 4), (datetime.date(2025, 8, 24), 0.7324597262445349, 3), (datetime.date(2025, 8, 25), 0.7711368134110115, 4), (datetime.date(2025, 8, 26), 0.8056837280925357, 4), (datetime.date(2025, 8, 27), 0.8502142202107199, 4), (datetime.date(2025, 8, 28), 0.8451095347615931, 4), (datetime.date(2025, 8, 29), 0.8385143768129871, 4), (datetime.date(2025, 8, 30), 0.8070047989266639, 4), (datetime.date(2025, 8, 31), 0.8361690049007974, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 8, 1), 0.7955175040959359, 3), (datetime.date(2025, 8, 2), 0.7883316995707443, 2), (datetime.date(2025, 8, 3), 0.8196706310444642, 2), (datetime.date(2025, 8, 4), 0.7596946180284598, 3), (datetime.date(2025, 8, 5), 0.7288057347501394, 4), (datetime.date(2025, 8, 6), 0.777438622445894, 4), (datetime.date(2025, 8, 7), 0.7943887034037365, 4), (datetime.date(2025, 8, 8), 0.6849042977768496, 3), (datetime.date(2025, 8, 9), 0.6978542930695759, 4), (datetime.date(2025, 8, 10), 0.7144705962310097, 2), (datetime.date(2025, 8, 11), 0.7672377563581254, 3), (datetime.date(2025, 8, 12), 0.7233899491536318, 4), (datetime.date(2025, 8, 13), 0.6976721496741447, 3), (datetime.date(2025, 8, 14), 0.6620917358815678, 4), (datetime.date(2025, 8, 15), 0.6797122189274732, 4), (datetime.date(2025, 8, 16), 0.7125835319195789, 3), (datetime.date(2025, 8, 17), 0.7983181557088513, 1), (datetime.date(2025, 8, 19), 0.7413217390199269, 1), (datetime.date(2025, 8, 20), 0.7444171894601427, 4), (datetime.date(2025, 8, 21), 0.6826408414728259, 3), (datetime.date(2025, 8, 22), 0.7041205418362099, 3), (datetime.date(2025, 8, 23), 0.7296715259179459, 4), (datetime.date(2025, 8, 24), 0.7324597262445349, 3), (datetime.date(2025, 8, 25), 0.7711368134110115, 4), (datetime.date(2025, 8, 26), 0.8056837280925357, 4), (datetime.date(2025, 8, 27), 0.8502142202107199, 4), (datetime.date(2025, 8, 28), 0.8451095347615931, 4), (datetime.date(2025, 8, 29), 0.8385143768129871, 4), (datetime.date(2025, 8, 30), 0.8070047989266639, 4), (datetime.date(2025, 8, 31), 0.8361690049007974, 3))}, 'quality_array': [['-7.745166169266512', '01082025'], ['-7.738599174483366', '02082025'], ['-8.103617160391176', '03082025'], ['-7.654400382744834', '04082025'], ['-7.4877617049310174', '05082025'], ['-7.273659969330628', '06082025'], ['-7.665308809771767', '07082025'], ['-8.57490089163302', '08082025'], ['-8.813929563795218', '09082025'], ['-9.019461359197546', '10082025'], ['-8.486316601310435', '11082025'], ['-8.466447481455344', '12082025'], ['-8.635070068485327', '13082025'], ['-9.012725630131364', '14082025'], ['-9.354519061787585', '15082025'], ['-9.008368398618243', '16082025'], ['-8.943258943248333', '17082025'], ['-8.380975239910681', '19082025'], ['-8.378144593400926', '20082025'], ['-8.844836031550416', '21082025'], ['-9.202924377252089', '22082025'], ['-9.14884331306252', '23082025'], ['-9.188112957835935', '24082025'], ['-8.704534857660276', '25082025'], ['-8.280743622990675', '26082025'], ['-8.322746402757438', '27082025'], ['-8.287045401448383', '28082025'], ['-7.737462096867243', '29082025'], ['-8.289838294481665', '30082025'], ['-8.559320949569125', '31082025']], 'number_of_batch': ((682,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013559052185383483, 'nb_photo': 17447, 'list_port_cont': '25576292,25576479,25577337,25578756,25580423,25581773,25582554,25583476,25584231,25584843,25585498,25586084,25586756,25589932,25591530,25593162,25593311,25593539,25593673,25593863,25594079,25594583,25601698,25601959,25614675,25614729,25614773,25614872,25614984,25615040,25615097,25615176,25615222,25615309,25615319,25615391,25615431,25615487,25615523,25615572,25615598,25615694,25615704,25615754,25615812,25615940,25616841,25617229,25622174,25622487,25622607,25623134,25623419,25623463,25623609,25623709,25623764,25623796,25623836,25623857,25623931,25623977,25624002,25624082,25624098,25624161,25624194,25624233,25624259,25624308,25624424,25624526,25651863,25651987,25652117,25652167,25652257,25652408,25652545,25652731,25652877,25652984,25653042,25653081,25653282,25653345,25653470,25653687,25653742,25653893,25654092,25654229,25654515,25656913,25657226,25658864,25705304,25705343,25705400,25705486,25705559,25705618,25705653,25705676,25705725,25705776,25705815,25705843,25705880,25705981,25706056,25706144,25706197,2570624', 'assoc_port': '25576161:25576292,25576368:25576479,25577110:25577337,25578309:25578756,25580270:25580423,25581466:25581773,25582370:25582554,25583280:25583476,25584040:25584231,25584706:25584843,25585392:25585498,25585950:25586084,25586641:25586756,25588023:25601698,25589708:25589932,25591337:25591530,25592806:25593162,25592810:25593311,25592813:25593673,25592818:25593539,25592821:25593863,25592826:25594079,25594537:25594583,25595246:25601959,25614550:25615812,25614553:25615940,25614555:25615694,25614558:25615754,25614561:25615704,25614565:25615523,25614568:25615598,25614572:25615487,25614576:25615572,25614581:25615431,25614583:25615391,25614586:25615309,25614588:25615319,25614591:25615176,25614593:25615097,25614596:25615222,25614598:25615040,25614600:25614984,25614601:25614872,25614603:25614675,25614605:25614729,25614606:25614773,25616544:25616841,25617204:25617229,25621893:25622174,25621894:25622487,25621895:25622607,25621896:25623134,25621897:25623419,25621899:25623709,25621902:25623796,25621904:25624098,25621906:2562425', 'assoc_mat': '25576161:autre:4230:25576292,25576368:autre:4230:25576479,25577110:autre:4230:25577337,25578309:autre:4230:25578756,25580270:autre:4230:25580423,25581466:autre:4230:25581773,25582370:autre:4230:25582554,25583280:autre:4230:25583476,25584040:autre:4230:25584231,25584706:autre:4230:25584843,25585392:autre:4230:25585498,25585950:autre:4230:25586084,25586641:autre:4230:25586756,25588023:autre:4230:25601698,25589708:autre:4230:25589932,25591337:autre:4230:25591530,25592806:autre:4230:25593162,25592810:autre:4230:25593311,25592813:autre:4230:25593673,25592818:autre:4230:25593539,25592821:autre:4230:25593863,25592826:autre:4230:25594079,25594537:autre:4230:25594583,25595246:autre:4230:25601959,25614550:autre:4230:25615812,25614553:autre:4230:25615940,25614555:autre:4230:25615694,25614558:autre:4230:25615754,25614561:autre:4230:25615704,25614565:autre:4230:25615523,25614568:autre:4230:25615598,25614572:autre:4230:25615487,25614576:autre:4230:25615572,25614581:autre:4230:25615431,25614583:autre:4230:25615391,25614586:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05793916929198872, 'nb_photo': 96720, 'list_port_cont': '25576303,25576485,25577346,25578760,25580425,25581786,25582566,25583484,25584232,25584856,25585507,25586076,25586764,25589943,25591531,25593165,25593317,25593542,25593689,25593872,25594096,25594573,25601719,25601957,25614677,25614717,25614777,25614874,25614990,25615044,25615106,25615172,25615214,25615311,25615332,25615392,25615445,25615494,25615528,25615564,25615608,25615685,25615714,25615771,25615816,25615941,25616854,25617220,25622177,25622482,25622618,25623136,25623426,25623464,25623619,25623698,25623760,25623793,25623837,25623858,25623945,25623971,25624014,25624083,25624109,25624148,25624196,25624236,25624268,25624303,25624422,25624536,25651868,25651985,25652128,25652160,25652268,25652411,25652550,25652736,25652882,25652993,25653049,25653090,25653289,25653343,25653472,25653690,25653751,25653903,25654093,25654240,25654524,25656922,25657227,25658874,25705314,25705344,25705410,25705483,25705564,25705617,25705646,25705693,25705727,25705781,25705808,25705853,25705888,25705977,25706047,25706139,25706196,2570625', 'assoc_port': '25576161:25576303,25576368:25576485,25577110:25577346,25578309:25578760,25580270:25580425,25581466:25581786,25582370:25582566,25583280:25583484,25584040:25584232,25584706:25584856,25585392:25585507,25585950:25586076,25586641:25586764,25588023:25601719,25589708:25589943,25591337:25591531,25592806:25593165,25592810:25593317,25592813:25593689,25592818:25593542,25592821:25593872,25592826:25594096,25594537:25594573,25595246:25601957,25614550:25615816,25614553:25615941,25614555:25615685,25614558:25615771,25614561:25615714,25614565:25615528,25614568:25615608,25614572:25615494,25614576:25615564,25614581:25615445,25614583:25615392,25614586:25615311,25614588:25615332,25614591:25615172,25614593:25615106,25614596:25615214,25614598:25615044,25614600:25614990,25614601:25614874,25614603:25614677,25614605:25614717,25614606:25614777,25616544:25616854,25617204:25617220,25621893:25622177,25621894:25622482,25621895:25622618,25621896:25623136,25621897:25623426,25621899:25623698,25621902:25623793,25621904:25624109,25621906:2562426', 'assoc_mat': '25576161:carton:4230:25576303,25576368:carton:4230:25576485,25577110:carton:4230:25577346,25578309:carton:4230:25578760,25580270:carton:4230:25580425,25581466:carton:4230:25581786,25582370:carton:4230:25582566,25583280:carton:4230:25583484,25584040:carton:4230:25584232,25584706:carton:4230:25584856,25585392:carton:4230:25585507,25585950:carton:4230:25586076,25586641:carton:4230:25586764,25588023:carton:4230:25601719,25589708:carton:4230:25589943,25591337:carton:4230:25591531,25592806:carton:4230:25593165,25592810:carton:4230:25593317,25592813:carton:4230:25593689,25592818:carton:4230:25593542,25592821:carton:4230:25593872,25592826:carton:4230:25594096,25594537:carton:4230:25594573,25595246:carton:4230:25601957,25614550:carton:4230:25615816,25614553:carton:4230:25615941,25614555:carton:4230:25615685,25614558:carton:4230:25615771,25614561:carton:4230:25615714,25614565:carton:4230:25615528,25614568:carton:4230:25615608,25614572:carton:4230:25615494,25614576:carton:4230:25615564,25614581:carton:4230:25615445,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010623059784067128, 'nb_photo': 1615, 'list_port_cont': '25576299,25576488,25577338,25578755,25580416,25581775,25582565,25583478,25584217,25586070,25586766,25593154,25593319,25593529,25593688,25593862,25594078,25601718,25614665,25614733,25614873,25614983,25615033,25615098,25615174,25615217,25615315,25615334,25615385,25615440,25615531,25615555,25615709,25615764,25615802,25615936,25616857,25623424,25623608,25623695,25623785,25623833,25623873,25623937,25623975,25624017,25624087,25624094,25624149,25624220,25624265,25651860,25651986,25652123,25652172,25652258,25652412,25652548,25652735,25652884,25652997,25653074,25653473,25656924,25657222,25658859,25705302,25705347,25705409,25705561,25705613,25705657,25705689,25705721,25705769,25705854,25705883,25705980,25706059,25706132,25706201,25706253,25706291,25706373,25706411,25706648,25707001,25709245,25709576,25711254,25712996,25715449,25718142,25720627,25723325,25725500,25728886,25733627,25735614,25736500,25741984,25744250,25749013,25749235,25751601,25797194,25797469,25797592,25797909,25797947,25798025,25798106,25798181,2579833', 'assoc_port': '25576161:25576299,25576368:25576488,25577110:25577338,25578309:25578755,25580270:25580416,25581466:25581775,25582370:25582565,25583280:25583478,25584040:25584217,25585950:25586070,25586641:25586766,25588023:25601718,25592806:25593154,25592810:25593319,25592813:25593688,25592818:25593529,25592821:25593862,25592826:25594078,25614550:25615802,25614553:25615936,25614558:25615764,25614561:25615709,25614565:25615531,25614576:25615555,25614581:25615440,25614583:25615385,25614586:25615315,25614588:25615334,25614591:25615174,25614593:25615098,25614596:25615217,25614598:25615033,25614600:25614983,25614601:25614873,25614603:25614665,25614605:25614733,25616544:25616857,25621897:25623424,25621899:25623695,25621902:25623785,25621904:25624094,25621906:25624265,25621912:25624220,25621914:25624087,25621916:25624017,25621918:25623975,25621922:25623937,25621925:25624149,25621929:25623873,25621932:25623833,25621942:25623608,25651370:25653473,25651377:25653074,25651378:25652997,25651379:25652548,25651382:25652884,25651383:2565273', 'assoc_mat': '25576161:metal:4230:25576299,25576368:metal:4230:25576488,25577110:metal:4230:25577338,25578309:metal:4230:25578755,25580270:metal:4230:25580416,25581466:metal:4230:25581775,25582370:metal:4230:25582565,25583280:metal:4230:25583478,25584040:metal:4230:25584217,25585950:metal:4230:25586070,25586641:metal:4230:25586766,25588023:metal:4230:25601718,25592806:metal:4230:25593154,25592810:metal:4230:25593319,25592813:metal:4230:25593688,25592818:metal:4230:25593529,25592821:metal:4230:25593862,25592826:metal:4230:25594078,25614550:metal:4230:25615802,25614553:metal:4230:25615936,25614558:metal:4230:25615764,25614561:metal:4230:25615709,25614565:metal:4230:25615531,25614576:metal:4230:25615555,25614581:metal:4230:25615440,25614583:metal:4230:25615385,25614586:metal:4230:25615315,25614588:metal:4230:25615334,25614591:metal:4230:25615174,25614593:metal:4230:25615098,25614596:metal:4230:25615217,25614598:metal:4230:25615033,25614600:metal:4230:25614983,25614601:metal:4230:25614873,25614603:metal:4230:25614665,25614605:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18663974866012537, 'nb_photo': 386200, 'list_port_cont': '25576307,25576483,25577341,25578757,25580421,25581784,25582570,25583491,25584233,25584851,25585512,25586082,25586762,25589949,25591556,25593164,25593315,25593540,25593687,25593874,25594092,25594581,25601708,25601949,25614682,25614724,25614768,25614870,25614991,25615039,25615107,25615179,25615216,25615308,25615331,25615397,25615441,25615492,25615535,25615567,25615606,25615684,25615701,25615769,25615811,25615944,25616852,25617230,25622171,25622485,25622615,25623142,25623434,25623469,25623613,25623699,25623761,25623792,25623823,25623870,25623940,25623976,25624013,25624088,25624096,25624156,25624186,25624228,25624272,25624301,25624419,25624524,25651864,25651992,25652131,25652168,25652267,25652417,25652549,25652728,25652883,25652992,25653050,25653088,25653296,25653342,25653478,25653699,25653752,25653899,25654099,25654250,25654513,25656925,25657228,25658875,25705315,25705352,25705404,25705473,25705572,25705619,25705654,25705688,25705728,25705773,25705814,25705851,25705894,25705983,25706055,25706140,25706202,2570625', 'assoc_port': '25576161:25576307,25576368:25576483,25577110:25577341,25578309:25578757,25580270:25580421,25581466:25581784,25582370:25582570,25583280:25583491,25584040:25584233,25584706:25584851,25585392:25585512,25585950:25586082,25586641:25586762,25588023:25601708,25589708:25589949,25591337:25591556,25592806:25593164,25592810:25593315,25592813:25593687,25592818:25593540,25592821:25593874,25592826:25594092,25594537:25594581,25595246:25601949,25614550:25615811,25614553:25615944,25614555:25615684,25614558:25615769,25614561:25615701,25614565:25615535,25614568:25615606,25614572:25615492,25614576:25615567,25614581:25615441,25614583:25615397,25614586:25615308,25614588:25615331,25614591:25615179,25614593:25615107,25614596:25615216,25614598:25615039,25614600:25614991,25614601:25614870,25614603:25614682,25614605:25614724,25614606:25614768,25616544:25616852,25617204:25617230,25621893:25622171,25621894:25622485,25621895:25622615,25621896:25623142,25621897:25623434,25621899:25623699,25621902:25623792,25621904:25624096,25621906:2562427', 'assoc_mat': '25576161:papier:4230:25576307,25576368:papier:4230:25576483,25577110:papier:4230:25577341,25578309:papier:4230:25578757,25580270:papier:4230:25580421,25581466:papier:4230:25581784,25582370:papier:4230:25582570,25583280:papier:4230:25583491,25584040:papier:4230:25584233,25584706:papier:4230:25584851,25585392:papier:4230:25585512,25585950:papier:4230:25586082,25586641:papier:4230:25586762,25588023:papier:4230:25601708,25589708:papier:4230:25589949,25591337:papier:4230:25591556,25592806:papier:4230:25593164,25592810:papier:4230:25593315,25592813:papier:4230:25593687,25592818:papier:4230:25593540,25592821:papier:4230:25593874,25592826:papier:4230:25594092,25594537:papier:4230:25594581,25595246:papier:4230:25601949,25614550:papier:4230:25615811,25614553:papier:4230:25615944,25614555:papier:4230:25615684,25614558:papier:4230:25615769,25614561:papier:4230:25615701,25614565:papier:4230:25615535,25614568:papier:4230:25615606,25614572:papier:4230:25615492,25614576:papier:4230:25615567,25614581:papier:4230:25615441,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002711428233918777, 'nb_photo': 1817, 'list_port_cont': '25576308,25576481,25577345,25578751,25580417,25581782,25582567,25583490,25584222,25584855,25585504,25586086,25586767,25589945,25591546,25593159,25593321,25593544,25593683,25594094,25594585,25601720,25601953,25614670,25614731,25614774,25614866,25614988,25615043,25615104,25615173,25615225,25615306,25615330,25615400,25615432,25615496,25615533,25615566,25615607,25615696,25615711,25615765,25615818,25615947,25617223,25622180,25622491,25622617,25623140,25623421,25623708,25624009,25624106,25651873,25651982,25652125,25652165,25652261,25652415,25652552,25652739,25652888,25653002,25653338,25653466,25654095,25656916,25657225,25658870,25705318,25705412,25705484,25705576,25705620,25705650,25705680,25705726,25705772,25705850,25705897,25705979,25706054,25706137,25706204,25706258,25706299,25706372,25706412,25706645,25707009,25709577,25711262,25713016,25715447,25718143,25720636,25723328,25725502,25727143,25728890,25733621,25736499,25739742,25741990,25744253,25749028,25749228,25753669,25797848,25798026,25798104,25798143,2579818', 'assoc_port': '25576161:25576308,25576368:25576481,25577110:25577345,25578309:25578751,25580270:25580417,25581466:25581782,25582370:25582567,25583280:25583490,25584040:25584222,25584706:25584855,25585392:25585504,25585950:25586086,25586641:25586767,25588023:25601720,25589708:25589945,25591337:25591546,25592806:25593159,25592810:25593321,25592813:25593683,25592818:25593544,25592826:25594094,25594537:25594585,25595246:25601953,25614550:25615818,25614553:25615947,25614555:25615696,25614558:25615765,25614561:25615711,25614565:25615533,25614568:25615607,25614572:25615496,25614576:25615566,25614581:25615432,25614583:25615400,25614586:25615306,25614588:25615330,25614591:25615173,25614593:25615104,25614596:25615225,25614598:25615043,25614600:25614988,25614601:25614866,25614603:25614670,25614605:25614731,25614606:25614774,25617204:25617223,25621893:25622180,25621894:25622491,25621895:25622617,25621896:25623140,25621897:25623421,25621899:25623708,25621904:25624106,25621916:25624009,25651365:25654095,25651370:25653466,25651374:2565333', 'assoc_mat': '25576161:pehd:4230:25576308,25576368:pehd:4230:25576481,25577110:pehd:4230:25577345,25578309:pehd:4230:25578751,25580270:pehd:4230:25580417,25581466:pehd:4230:25581782,25582370:pehd:4230:25582567,25583280:pehd:4230:25583490,25584040:pehd:4230:25584222,25584706:pehd:4230:25584855,25585392:pehd:4230:25585504,25585950:pehd:4230:25586086,25586641:pehd:4230:25586767,25588023:pehd:4230:25601720,25589708:pehd:4230:25589945,25591337:pehd:4230:25591546,25592806:pehd:4230:25593159,25592810:pehd:4230:25593321,25592813:pehd:4230:25593683,25592818:pehd:4230:25593544,25592826:pehd:4230:25594094,25594537:pehd:4230:25594585,25595246:pehd:4230:25601953,25614550:pehd:4230:25615818,25614553:pehd:4230:25615947,25614555:pehd:4230:25615696,25614558:pehd:4230:25615765,25614561:pehd:4230:25615711,25614565:pehd:4230:25615533,25614568:pehd:4230:25615607,25614572:pehd:4230:25615496,25614576:pehd:4230:25615566,25614581:pehd:4230:25615432,25614583:pehd:4230:25615400,25614586:pehd:4230:25615306,25614588:pehd:4230:25615330,25614591:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0125693767112534, 'nb_photo': 21543, 'list_port_cont': '25576306,25576482,25577347,25578759,25580424,25581777,25582562,25583488,25584230,25584848,25585509,25586083,25586759,25589948,25591550,25593155,25593322,25593545,25593682,25593875,25594084,25594582,25601694,25601954,25614681,25614725,25614775,25614878,25614981,25615037,25615105,25615175,25615220,25615317,25615325,25615398,25615444,25615491,25615530,25615571,25615604,25615690,25615710,25615767,25615817,25615939,25616858,25617225,25622173,25622477,25622616,25623141,25623427,25623471,25623618,25623705,25623763,25623790,25623826,25623872,25623946,25623978,25624018,25624080,25624105,25624162,25624185,25624234,25624269,25624307,25624421,25624534,25651867,25651981,25652120,25652166,25652259,25652409,25652547,25652741,25652887,25652990,25653043,25653086,25653293,25653325,25653476,25653700,25653747,25653896,25654094,25654238,25654520,25656915,25657231,25658866,25705312,25705354,25705405,25705487,25705569,25705612,25705648,25705685,25705717,25705780,25705811,25705841,25705892,25705982,25706048,25706145,25706205,2570625', 'assoc_port': '25576161:25576306,25576368:25576482,25577110:25577347,25578309:25578759,25580270:25580424,25581466:25581777,25582370:25582562,25583280:25583488,25584040:25584230,25584706:25584848,25585392:25585509,25585950:25586083,25586641:25586759,25588023:25601694,25589708:25589948,25591337:25591550,25592806:25593155,25592810:25593322,25592813:25593682,25592818:25593545,25592821:25593875,25592826:25594084,25594537:25594582,25595246:25601954,25614550:25615817,25614553:25615939,25614555:25615690,25614558:25615767,25614561:25615710,25614565:25615530,25614568:25615604,25614572:25615491,25614576:25615571,25614581:25615444,25614583:25615398,25614586:25615317,25614588:25615325,25614591:25615175,25614593:25615105,25614596:25615220,25614598:25615037,25614600:25614981,25614601:25614878,25614603:25614681,25614605:25614725,25614606:25614775,25616544:25616858,25617204:25617225,25621893:25622173,25621894:25622477,25621895:25622616,25621896:25623141,25621897:25623427,25621899:25623705,25621902:25623790,25621904:25624105,25621906:2562426', 'assoc_mat': '25576161:pet_clair:4230:25576306,25576368:pet_clair:4230:25576482,25577110:pet_clair:4230:25577347,25578309:pet_clair:4230:25578759,25580270:pet_clair:4230:25580424,25581466:pet_clair:4230:25581777,25582370:pet_clair:4230:25582562,25583280:pet_clair:4230:25583488,25584040:pet_clair:4230:25584230,25584706:pet_clair:4230:25584848,25585392:pet_clair:4230:25585509,25585950:pet_clair:4230:25586083,25586641:pet_clair:4230:25586759,25588023:pet_clair:4230:25601694,25589708:pet_clair:4230:25589948,25591337:pet_clair:4230:25591550,25592806:pet_clair:4230:25593155,25592810:pet_clair:4230:25593322,25592813:pet_clair:4230:25593682,25592818:pet_clair:4230:25593545,25592821:pet_clair:4230:25593875,25592826:pet_clair:4230:25594084,25594537:pet_clair:4230:25594582,25595246:pet_clair:4230:25601954,25614550:pet_clair:4230:25615817,25614553:pet_clair:4230:25615939,25614555:pet_clair:4230:25615690,25614558:pet_clair:4230:25615767,25614561:pet_clair:4230:25615710,25614565:pet_clair:4230:25615530,25614568:pet_clair:4230:25615604,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021857661120444484, 'nb_photo': 1170, 'list_port_cont': '25576296,25576491,25577344,25578763,25580419,25581785,25582569,25583485,25584224,25584852,25585515,25586085,25586761,25589940,25591548,25593166,25593316,25593538,25593686,25593869,25594091,25594580,25601721,25601960,25614680,25614722,25614772,25614877,25614986,25615038,25615095,25615180,25615212,25615305,25615335,25615395,25615446,25615497,25615526,25615563,25615605,25615687,25615705,25615768,25615810,25615931,25622176,25623145,25623433,25623938,25624306,25651875,25651994,25652126,25652159,25652262,25652413,25652541,25652733,25652890,25653346,25656919,25657230,25658867,25705311,25705355,25705413,25705687,25705729,25705778,25705819,25705842,25705893,25705973,25706045,25706143,25706206,25706256,25706301,25706375,25706403,25706649,25707469,25708680,25709586,25711255,25713004,25715445,25718151,25720631,25723323,25725490,25727153,25728899,25733622,25735619,25736497,25749025,25749156,25749238,25797332,25797596,25797629,25797851,25798113,25798149,25798250,25798374,25798596,25799669,25824537,25828548,25828619,2582877', 'assoc_port': '25576161:25576296,25576368:25576491,25577110:25577344,25578309:25578763,25580270:25580419,25581466:25581785,25582370:25582569,25583280:25583485,25584040:25584224,25584706:25584852,25585392:25585515,25585950:25586085,25586641:25586761,25588023:25601721,25589708:25589940,25591337:25591548,25592806:25593166,25592810:25593316,25592813:25593686,25592818:25593538,25592821:25593869,25592826:25594091,25594537:25594580,25595246:25601960,25614550:25615810,25614553:25615931,25614555:25615687,25614558:25615768,25614561:25615705,25614565:25615526,25614568:25615605,25614572:25615497,25614576:25615563,25614581:25615446,25614583:25615395,25614586:25615305,25614588:25615335,25614591:25615180,25614593:25615095,25614596:25615212,25614598:25615038,25614600:25614986,25614601:25614877,25614603:25614680,25614605:25614722,25614606:25614772,25621893:25622176,25621896:25623145,25621897:25623433,25621908:25624306,25621922:25623938,25651374:25653346,25651379:25652541,25651382:25652890,25651383:25652733,25651384:25652413,25651387:2565226', 'assoc_mat': '25576161:pet_fonce:4230:25576296,25576368:pet_fonce:4230:25576491,25577110:pet_fonce:4230:25577344,25578309:pet_fonce:4230:25578763,25580270:pet_fonce:4230:25580419,25581466:pet_fonce:4230:25581785,25582370:pet_fonce:4230:25582569,25583280:pet_fonce:4230:25583485,25584040:pet_fonce:4230:25584224,25584706:pet_fonce:4230:25584852,25585392:pet_fonce:4230:25585515,25585950:pet_fonce:4230:25586085,25586641:pet_fonce:4230:25586761,25588023:pet_fonce:4230:25601721,25589708:pet_fonce:4230:25589940,25591337:pet_fonce:4230:25591548,25592806:pet_fonce:4230:25593166,25592810:pet_fonce:4230:25593316,25592813:pet_fonce:4230:25593686,25592818:pet_fonce:4230:25593538,25592821:pet_fonce:4230:25593869,25592826:pet_fonce:4230:25594091,25594537:pet_fonce:4230:25594580,25595246:pet_fonce:4230:25601960,25614550:pet_fonce:4230:25615810,25614553:pet_fonce:4230:25615931,25614555:pet_fonce:4230:25615687,25614558:pet_fonce:4230:25615768,25614561:pet_fonce:4230:25615705,25614565:pet_fonce:4230:25615526,25614568:pet_fonce:4230:25615605,2'}), 'main_stat': {'nb_photos': 2283}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-08', 0.7575274542453474),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((2283,),), 'unwanted_material_monthly_percentage': ((0.7575274542453474,),), 'material_repartition': (('incineration', 2283),), 'material_dict': {'incineration': 2283}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 8, 1), 0.7955175040959359, 3), (datetime.date(2025, 8, 2), 0.7883316995707443, 2), (datetime.date(2025, 8, 3), 0.8196706310444642, 2), (datetime.date(2025, 8, 4), 0.7596946180284598, 3), (datetime.date(2025, 8, 5), 0.7288057347501394, 4), (datetime.date(2025, 8, 6), 0.777438622445894, 4), (datetime.date(2025, 8, 7), 0.7943887034037365, 4), (datetime.date(2025, 8, 8), 0.6849042977768496, 3), (datetime.date(2025, 8, 9), 0.6978542930695759, 4), (datetime.date(2025, 8, 10), 0.7144705962310097, 2), (datetime.date(2025, 8, 11), 0.7672377563581254, 3), (datetime.date(2025, 8, 12), 0.7233899491536318, 4), (datetime.date(2025, 8, 13), 0.6976721496741447, 3), (datetime.date(2025, 8, 14), 0.6620917358815678, 4), (datetime.date(2025, 8, 15), 0.6797122189274732, 4), (datetime.date(2025, 8, 16), 0.7125835319195789, 3), (datetime.date(2025, 8, 17), 0.7983181557088513, 1), (datetime.date(2025, 8, 19), 0.7413217390199269, 1), (datetime.date(2025, 8, 20), 0.7444171894601427, 4), (datetime.date(2025, 8, 21), 0.6826408414728259, 3), (datetime.date(2025, 8, 22), 0.7041205418362099, 3), (datetime.date(2025, 8, 23), 0.7296715259179459, 4), (datetime.date(2025, 8, 24), 0.7324597262445349, 3), (datetime.date(2025, 8, 25), 0.7711368134110115, 4), (datetime.date(2025, 8, 26), 0.8056837280925357, 4), (datetime.date(2025, 8, 27), 0.8502142202107199, 4), (datetime.date(2025, 8, 28), 0.8451095347615931, 4), (datetime.date(2025, 8, 29), 0.8385143768129871, 4), (datetime.date(2025, 8, 30), 0.8070047989266639, 4), (datetime.date(2025, 8, 31), 0.8361690049007974, 3)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 8, 1), 0.7955175040959359, 3), (datetime.date(2025, 8, 2), 0.7883316995707443, 2), (datetime.date(2025, 8, 3), 0.8196706310444642, 2), (datetime.date(2025, 8, 4), 0.7596946180284598, 3), (datetime.date(2025, 8, 5), 0.7288057347501394, 4), (datetime.date(2025, 8, 6), 0.777438622445894, 4), (datetime.date(2025, 8, 7), 0.7943887034037365, 4), (datetime.date(2025, 8, 8), 0.6849042977768496, 3), (datetime.date(2025, 8, 9), 0.6978542930695759, 4), (datetime.date(2025, 8, 10), 0.7144705962310097, 2), (datetime.date(2025, 8, 11), 0.7672377563581254, 3), (datetime.date(2025, 8, 12), 0.7233899491536318, 4), (datetime.date(2025, 8, 13), 0.6976721496741447, 3), (datetime.date(2025, 8, 14), 0.6620917358815678, 4), (datetime.date(2025, 8, 15), 0.6797122189274732, 4), (datetime.date(2025, 8, 16), 0.7125835319195789, 3), (datetime.date(2025, 8, 17), 0.7983181557088513, 1), (datetime.date(2025, 8, 19), 0.7413217390199269, 1), (datetime.date(2025, 8, 20), 0.7444171894601427, 4), (datetime.date(2025, 8, 21), 0.6826408414728259, 3), (datetime.date(2025, 8, 22), 0.7041205418362099, 3), (datetime.date(2025, 8, 23), 0.7296715259179459, 4), (datetime.date(2025, 8, 24), 0.7324597262445349, 3), (datetime.date(2025, 8, 25), 0.7711368134110115, 4), (datetime.date(2025, 8, 26), 0.8056837280925357, 4), (datetime.date(2025, 8, 27), 0.8502142202107199, 4), (datetime.date(2025, 8, 28), 0.8451095347615931, 4), (datetime.date(2025, 8, 29), 0.8385143768129871, 4), (datetime.date(2025, 8, 30), 0.8070047989266639, 4), (datetime.date(2025, 8, 31), 0.8361690049007974, 3))}, 'quality_array': [['-7.745166169266512', '01082025'], ['-7.738599174483366', '02082025'], ['-8.103617160391176', '03082025'], ['-7.654400382744834', '04082025'], ['-7.4877617049310174', '05082025'], ['-7.273659969330628', '06082025'], ['-7.665308809771767', '07082025'], ['-8.57490089163302', '08082025'], ['-8.813929563795218', '09082025'], ['-9.019461359197546', '10082025'], ['-8.486316601310435', '11082025'], ['-8.466447481455344', '12082025'], ['-8.635070068485327', '13082025'], ['-9.012725630131364', '14082025'], ['-9.354519061787585', '15082025'], ['-9.008368398618243', '16082025'], ['-8.943258943248333', '17082025'], ['-8.380975239910681', '19082025'], ['-8.378144593400926', '20082025'], ['-8.844836031550416', '21082025'], ['-9.202924377252089', '22082025'], ['-9.14884331306252', '23082025'], ['-9.188112957835935', '24082025'], ['-8.704534857660276', '25082025'], ['-8.280743622990675', '26082025'], ['-8.322746402757438', '27082025'], ['-8.287045401448383', '28082025'], ['-7.737462096867243', '29082025'], ['-8.289838294481665', '30082025'], ['-8.559320949569125', '31082025']], 'number_of_batch': ((682,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.013559052185383483, 'nb_photo': 17447, 'list_port_cont': '25576292,25576479,25577337,25578756,25580423,25581773,25582554,25583476,25584231,25584843,25585498,25586084,25586756,25589932,25591530,25593162,25593311,25593539,25593673,25593863,25594079,25594583,25601698,25601959,25614675,25614729,25614773,25614872,25614984,25615040,25615097,25615176,25615222,25615309,25615319,25615391,25615431,25615487,25615523,25615572,25615598,25615694,25615704,25615754,25615812,25615940,25616841,25617229,25622174,25622487,25622607,25623134,25623419,25623463,25623609,25623709,25623764,25623796,25623836,25623857,25623931,25623977,25624002,25624082,25624098,25624161,25624194,25624233,25624259,25624308,25624424,25624526,25651863,25651987,25652117,25652167,25652257,25652408,25652545,25652731,25652877,25652984,25653042,25653081,25653282,25653345,25653470,25653687,25653742,25653893,25654092,25654229,25654515,25656913,25657226,25658864,25705304,25705343,25705400,25705486,25705559,25705618,25705653,25705676,25705725,25705776,25705815,25705843,25705880,25705981,25706056,25706144,25706197,2570624', 'assoc_port': '25576161:25576292,25576368:25576479,25577110:25577337,25578309:25578756,25580270:25580423,25581466:25581773,25582370:25582554,25583280:25583476,25584040:25584231,25584706:25584843,25585392:25585498,25585950:25586084,25586641:25586756,25588023:25601698,25589708:25589932,25591337:25591530,25592806:25593162,25592810:25593311,25592813:25593673,25592818:25593539,25592821:25593863,25592826:25594079,25594537:25594583,25595246:25601959,25614550:25615812,25614553:25615940,25614555:25615694,25614558:25615754,25614561:25615704,25614565:25615523,25614568:25615598,25614572:25615487,25614576:25615572,25614581:25615431,25614583:25615391,25614586:25615309,25614588:25615319,25614591:25615176,25614593:25615097,25614596:25615222,25614598:25615040,25614600:25614984,25614601:25614872,25614603:25614675,25614605:25614729,25614606:25614773,25616544:25616841,25617204:25617229,25621893:25622174,25621894:25622487,25621895:25622607,25621896:25623134,25621897:25623419,25621899:25623709,25621902:25623796,25621904:25624098,25621906:2562425', 'assoc_mat': '25576161:autre:4230:25576292,25576368:autre:4230:25576479,25577110:autre:4230:25577337,25578309:autre:4230:25578756,25580270:autre:4230:25580423,25581466:autre:4230:25581773,25582370:autre:4230:25582554,25583280:autre:4230:25583476,25584040:autre:4230:25584231,25584706:autre:4230:25584843,25585392:autre:4230:25585498,25585950:autre:4230:25586084,25586641:autre:4230:25586756,25588023:autre:4230:25601698,25589708:autre:4230:25589932,25591337:autre:4230:25591530,25592806:autre:4230:25593162,25592810:autre:4230:25593311,25592813:autre:4230:25593673,25592818:autre:4230:25593539,25592821:autre:4230:25593863,25592826:autre:4230:25594079,25594537:autre:4230:25594583,25595246:autre:4230:25601959,25614550:autre:4230:25615812,25614553:autre:4230:25615940,25614555:autre:4230:25615694,25614558:autre:4230:25615754,25614561:autre:4230:25615704,25614565:autre:4230:25615523,25614568:autre:4230:25615598,25614572:autre:4230:25615487,25614576:autre:4230:25615572,25614581:autre:4230:25615431,25614583:autre:4230:25615391,25614586:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05793916929198872, 'nb_photo': 96720, 'list_port_cont': '25576303,25576485,25577346,25578760,25580425,25581786,25582566,25583484,25584232,25584856,25585507,25586076,25586764,25589943,25591531,25593165,25593317,25593542,25593689,25593872,25594096,25594573,25601719,25601957,25614677,25614717,25614777,25614874,25614990,25615044,25615106,25615172,25615214,25615311,25615332,25615392,25615445,25615494,25615528,25615564,25615608,25615685,25615714,25615771,25615816,25615941,25616854,25617220,25622177,25622482,25622618,25623136,25623426,25623464,25623619,25623698,25623760,25623793,25623837,25623858,25623945,25623971,25624014,25624083,25624109,25624148,25624196,25624236,25624268,25624303,25624422,25624536,25651868,25651985,25652128,25652160,25652268,25652411,25652550,25652736,25652882,25652993,25653049,25653090,25653289,25653343,25653472,25653690,25653751,25653903,25654093,25654240,25654524,25656922,25657227,25658874,25705314,25705344,25705410,25705483,25705564,25705617,25705646,25705693,25705727,25705781,25705808,25705853,25705888,25705977,25706047,25706139,25706196,2570625', 'assoc_port': '25576161:25576303,25576368:25576485,25577110:25577346,25578309:25578760,25580270:25580425,25581466:25581786,25582370:25582566,25583280:25583484,25584040:25584232,25584706:25584856,25585392:25585507,25585950:25586076,25586641:25586764,25588023:25601719,25589708:25589943,25591337:25591531,25592806:25593165,25592810:25593317,25592813:25593689,25592818:25593542,25592821:25593872,25592826:25594096,25594537:25594573,25595246:25601957,25614550:25615816,25614553:25615941,25614555:25615685,25614558:25615771,25614561:25615714,25614565:25615528,25614568:25615608,25614572:25615494,25614576:25615564,25614581:25615445,25614583:25615392,25614586:25615311,25614588:25615332,25614591:25615172,25614593:25615106,25614596:25615214,25614598:25615044,25614600:25614990,25614601:25614874,25614603:25614677,25614605:25614717,25614606:25614777,25616544:25616854,25617204:25617220,25621893:25622177,25621894:25622482,25621895:25622618,25621896:25623136,25621897:25623426,25621899:25623698,25621902:25623793,25621904:25624109,25621906:2562426', 'assoc_mat': '25576161:carton:4230:25576303,25576368:carton:4230:25576485,25577110:carton:4230:25577346,25578309:carton:4230:25578760,25580270:carton:4230:25580425,25581466:carton:4230:25581786,25582370:carton:4230:25582566,25583280:carton:4230:25583484,25584040:carton:4230:25584232,25584706:carton:4230:25584856,25585392:carton:4230:25585507,25585950:carton:4230:25586076,25586641:carton:4230:25586764,25588023:carton:4230:25601719,25589708:carton:4230:25589943,25591337:carton:4230:25591531,25592806:carton:4230:25593165,25592810:carton:4230:25593317,25592813:carton:4230:25593689,25592818:carton:4230:25593542,25592821:carton:4230:25593872,25592826:carton:4230:25594096,25594537:carton:4230:25594573,25595246:carton:4230:25601957,25614550:carton:4230:25615816,25614553:carton:4230:25615941,25614555:carton:4230:25615685,25614558:carton:4230:25615771,25614561:carton:4230:25615714,25614565:carton:4230:25615528,25614568:carton:4230:25615608,25614572:carton:4230:25615494,25614576:carton:4230:25615564,25614581:carton:4230:25615445,2561'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0010623059784067128, 'nb_photo': 1615, 'list_port_cont': '25576299,25576488,25577338,25578755,25580416,25581775,25582565,25583478,25584217,25586070,25586766,25593154,25593319,25593529,25593688,25593862,25594078,25601718,25614665,25614733,25614873,25614983,25615033,25615098,25615174,25615217,25615315,25615334,25615385,25615440,25615531,25615555,25615709,25615764,25615802,25615936,25616857,25623424,25623608,25623695,25623785,25623833,25623873,25623937,25623975,25624017,25624087,25624094,25624149,25624220,25624265,25651860,25651986,25652123,25652172,25652258,25652412,25652548,25652735,25652884,25652997,25653074,25653473,25656924,25657222,25658859,25705302,25705347,25705409,25705561,25705613,25705657,25705689,25705721,25705769,25705854,25705883,25705980,25706059,25706132,25706201,25706253,25706291,25706373,25706411,25706648,25707001,25709245,25709576,25711254,25712996,25715449,25718142,25720627,25723325,25725500,25728886,25733627,25735614,25736500,25741984,25744250,25749013,25749235,25751601,25797194,25797469,25797592,25797909,25797947,25798025,25798106,25798181,2579833', 'assoc_port': '25576161:25576299,25576368:25576488,25577110:25577338,25578309:25578755,25580270:25580416,25581466:25581775,25582370:25582565,25583280:25583478,25584040:25584217,25585950:25586070,25586641:25586766,25588023:25601718,25592806:25593154,25592810:25593319,25592813:25593688,25592818:25593529,25592821:25593862,25592826:25594078,25614550:25615802,25614553:25615936,25614558:25615764,25614561:25615709,25614565:25615531,25614576:25615555,25614581:25615440,25614583:25615385,25614586:25615315,25614588:25615334,25614591:25615174,25614593:25615098,25614596:25615217,25614598:25615033,25614600:25614983,25614601:25614873,25614603:25614665,25614605:25614733,25616544:25616857,25621897:25623424,25621899:25623695,25621902:25623785,25621904:25624094,25621906:25624265,25621912:25624220,25621914:25624087,25621916:25624017,25621918:25623975,25621922:25623937,25621925:25624149,25621929:25623873,25621932:25623833,25621942:25623608,25651370:25653473,25651377:25653074,25651378:25652997,25651379:25652548,25651382:25652884,25651383:2565273', 'assoc_mat': '25576161:metal:4230:25576299,25576368:metal:4230:25576488,25577110:metal:4230:25577338,25578309:metal:4230:25578755,25580270:metal:4230:25580416,25581466:metal:4230:25581775,25582370:metal:4230:25582565,25583280:metal:4230:25583478,25584040:metal:4230:25584217,25585950:metal:4230:25586070,25586641:metal:4230:25586766,25588023:metal:4230:25601718,25592806:metal:4230:25593154,25592810:metal:4230:25593319,25592813:metal:4230:25593688,25592818:metal:4230:25593529,25592821:metal:4230:25593862,25592826:metal:4230:25594078,25614550:metal:4230:25615802,25614553:metal:4230:25615936,25614558:metal:4230:25615764,25614561:metal:4230:25615709,25614565:metal:4230:25615531,25614576:metal:4230:25615555,25614581:metal:4230:25615440,25614583:metal:4230:25615385,25614586:metal:4230:25615315,25614588:metal:4230:25615334,25614591:metal:4230:25615174,25614593:metal:4230:25615098,25614596:metal:4230:25615217,25614598:metal:4230:25615033,25614600:metal:4230:25614983,25614601:metal:4230:25614873,25614603:metal:4230:25614665,25614605:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.18663974866012537, 'nb_photo': 386200, 'list_port_cont': '25576307,25576483,25577341,25578757,25580421,25581784,25582570,25583491,25584233,25584851,25585512,25586082,25586762,25589949,25591556,25593164,25593315,25593540,25593687,25593874,25594092,25594581,25601708,25601949,25614682,25614724,25614768,25614870,25614991,25615039,25615107,25615179,25615216,25615308,25615331,25615397,25615441,25615492,25615535,25615567,25615606,25615684,25615701,25615769,25615811,25615944,25616852,25617230,25622171,25622485,25622615,25623142,25623434,25623469,25623613,25623699,25623761,25623792,25623823,25623870,25623940,25623976,25624013,25624088,25624096,25624156,25624186,25624228,25624272,25624301,25624419,25624524,25651864,25651992,25652131,25652168,25652267,25652417,25652549,25652728,25652883,25652992,25653050,25653088,25653296,25653342,25653478,25653699,25653752,25653899,25654099,25654250,25654513,25656925,25657228,25658875,25705315,25705352,25705404,25705473,25705572,25705619,25705654,25705688,25705728,25705773,25705814,25705851,25705894,25705983,25706055,25706140,25706202,2570625', 'assoc_port': '25576161:25576307,25576368:25576483,25577110:25577341,25578309:25578757,25580270:25580421,25581466:25581784,25582370:25582570,25583280:25583491,25584040:25584233,25584706:25584851,25585392:25585512,25585950:25586082,25586641:25586762,25588023:25601708,25589708:25589949,25591337:25591556,25592806:25593164,25592810:25593315,25592813:25593687,25592818:25593540,25592821:25593874,25592826:25594092,25594537:25594581,25595246:25601949,25614550:25615811,25614553:25615944,25614555:25615684,25614558:25615769,25614561:25615701,25614565:25615535,25614568:25615606,25614572:25615492,25614576:25615567,25614581:25615441,25614583:25615397,25614586:25615308,25614588:25615331,25614591:25615179,25614593:25615107,25614596:25615216,25614598:25615039,25614600:25614991,25614601:25614870,25614603:25614682,25614605:25614724,25614606:25614768,25616544:25616852,25617204:25617230,25621893:25622171,25621894:25622485,25621895:25622615,25621896:25623142,25621897:25623434,25621899:25623699,25621902:25623792,25621904:25624096,25621906:2562427', 'assoc_mat': '25576161:papier:4230:25576307,25576368:papier:4230:25576483,25577110:papier:4230:25577341,25578309:papier:4230:25578757,25580270:papier:4230:25580421,25581466:papier:4230:25581784,25582370:papier:4230:25582570,25583280:papier:4230:25583491,25584040:papier:4230:25584233,25584706:papier:4230:25584851,25585392:papier:4230:25585512,25585950:papier:4230:25586082,25586641:papier:4230:25586762,25588023:papier:4230:25601708,25589708:papier:4230:25589949,25591337:papier:4230:25591556,25592806:papier:4230:25593164,25592810:papier:4230:25593315,25592813:papier:4230:25593687,25592818:papier:4230:25593540,25592821:papier:4230:25593874,25592826:papier:4230:25594092,25594537:papier:4230:25594581,25595246:papier:4230:25601949,25614550:papier:4230:25615811,25614553:papier:4230:25615944,25614555:papier:4230:25615684,25614558:papier:4230:25615769,25614561:papier:4230:25615701,25614565:papier:4230:25615535,25614568:papier:4230:25615606,25614572:papier:4230:25615492,25614576:papier:4230:25615567,25614581:papier:4230:25615441,2561'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.002711428233918777, 'nb_photo': 1817, 'list_port_cont': '25576308,25576481,25577345,25578751,25580417,25581782,25582567,25583490,25584222,25584855,25585504,25586086,25586767,25589945,25591546,25593159,25593321,25593544,25593683,25594094,25594585,25601720,25601953,25614670,25614731,25614774,25614866,25614988,25615043,25615104,25615173,25615225,25615306,25615330,25615400,25615432,25615496,25615533,25615566,25615607,25615696,25615711,25615765,25615818,25615947,25617223,25622180,25622491,25622617,25623140,25623421,25623708,25624009,25624106,25651873,25651982,25652125,25652165,25652261,25652415,25652552,25652739,25652888,25653002,25653338,25653466,25654095,25656916,25657225,25658870,25705318,25705412,25705484,25705576,25705620,25705650,25705680,25705726,25705772,25705850,25705897,25705979,25706054,25706137,25706204,25706258,25706299,25706372,25706412,25706645,25707009,25709577,25711262,25713016,25715447,25718143,25720636,25723328,25725502,25727143,25728890,25733621,25736499,25739742,25741990,25744253,25749028,25749228,25753669,25797848,25798026,25798104,25798143,2579818', 'assoc_port': '25576161:25576308,25576368:25576481,25577110:25577345,25578309:25578751,25580270:25580417,25581466:25581782,25582370:25582567,25583280:25583490,25584040:25584222,25584706:25584855,25585392:25585504,25585950:25586086,25586641:25586767,25588023:25601720,25589708:25589945,25591337:25591546,25592806:25593159,25592810:25593321,25592813:25593683,25592818:25593544,25592826:25594094,25594537:25594585,25595246:25601953,25614550:25615818,25614553:25615947,25614555:25615696,25614558:25615765,25614561:25615711,25614565:25615533,25614568:25615607,25614572:25615496,25614576:25615566,25614581:25615432,25614583:25615400,25614586:25615306,25614588:25615330,25614591:25615173,25614593:25615104,25614596:25615225,25614598:25615043,25614600:25614988,25614601:25614866,25614603:25614670,25614605:25614731,25614606:25614774,25617204:25617223,25621893:25622180,25621894:25622491,25621895:25622617,25621896:25623140,25621897:25623421,25621899:25623708,25621904:25624106,25621916:25624009,25651365:25654095,25651370:25653466,25651374:2565333', 'assoc_mat': '25576161:pehd:4230:25576308,25576368:pehd:4230:25576481,25577110:pehd:4230:25577345,25578309:pehd:4230:25578751,25580270:pehd:4230:25580417,25581466:pehd:4230:25581782,25582370:pehd:4230:25582567,25583280:pehd:4230:25583490,25584040:pehd:4230:25584222,25584706:pehd:4230:25584855,25585392:pehd:4230:25585504,25585950:pehd:4230:25586086,25586641:pehd:4230:25586767,25588023:pehd:4230:25601720,25589708:pehd:4230:25589945,25591337:pehd:4230:25591546,25592806:pehd:4230:25593159,25592810:pehd:4230:25593321,25592813:pehd:4230:25593683,25592818:pehd:4230:25593544,25592826:pehd:4230:25594094,25594537:pehd:4230:25594585,25595246:pehd:4230:25601953,25614550:pehd:4230:25615818,25614553:pehd:4230:25615947,25614555:pehd:4230:25615696,25614558:pehd:4230:25615765,25614561:pehd:4230:25615711,25614565:pehd:4230:25615533,25614568:pehd:4230:25615607,25614572:pehd:4230:25615496,25614576:pehd:4230:25615566,25614581:pehd:4230:25615432,25614583:pehd:4230:25615400,25614586:pehd:4230:25615306,25614588:pehd:4230:25615330,25614591:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0125693767112534, 'nb_photo': 21543, 'list_port_cont': '25576306,25576482,25577347,25578759,25580424,25581777,25582562,25583488,25584230,25584848,25585509,25586083,25586759,25589948,25591550,25593155,25593322,25593545,25593682,25593875,25594084,25594582,25601694,25601954,25614681,25614725,25614775,25614878,25614981,25615037,25615105,25615175,25615220,25615317,25615325,25615398,25615444,25615491,25615530,25615571,25615604,25615690,25615710,25615767,25615817,25615939,25616858,25617225,25622173,25622477,25622616,25623141,25623427,25623471,25623618,25623705,25623763,25623790,25623826,25623872,25623946,25623978,25624018,25624080,25624105,25624162,25624185,25624234,25624269,25624307,25624421,25624534,25651867,25651981,25652120,25652166,25652259,25652409,25652547,25652741,25652887,25652990,25653043,25653086,25653293,25653325,25653476,25653700,25653747,25653896,25654094,25654238,25654520,25656915,25657231,25658866,25705312,25705354,25705405,25705487,25705569,25705612,25705648,25705685,25705717,25705780,25705811,25705841,25705892,25705982,25706048,25706145,25706205,2570625', 'assoc_port': '25576161:25576306,25576368:25576482,25577110:25577347,25578309:25578759,25580270:25580424,25581466:25581777,25582370:25582562,25583280:25583488,25584040:25584230,25584706:25584848,25585392:25585509,25585950:25586083,25586641:25586759,25588023:25601694,25589708:25589948,25591337:25591550,25592806:25593155,25592810:25593322,25592813:25593682,25592818:25593545,25592821:25593875,25592826:25594084,25594537:25594582,25595246:25601954,25614550:25615817,25614553:25615939,25614555:25615690,25614558:25615767,25614561:25615710,25614565:25615530,25614568:25615604,25614572:25615491,25614576:25615571,25614581:25615444,25614583:25615398,25614586:25615317,25614588:25615325,25614591:25615175,25614593:25615105,25614596:25615220,25614598:25615037,25614600:25614981,25614601:25614878,25614603:25614681,25614605:25614725,25614606:25614775,25616544:25616858,25617204:25617225,25621893:25622173,25621894:25622477,25621895:25622616,25621896:25623141,25621897:25623427,25621899:25623705,25621902:25623790,25621904:25624105,25621906:2562426', 'assoc_mat': '25576161:pet_clair:4230:25576306,25576368:pet_clair:4230:25576482,25577110:pet_clair:4230:25577347,25578309:pet_clair:4230:25578759,25580270:pet_clair:4230:25580424,25581466:pet_clair:4230:25581777,25582370:pet_clair:4230:25582562,25583280:pet_clair:4230:25583488,25584040:pet_clair:4230:25584230,25584706:pet_clair:4230:25584848,25585392:pet_clair:4230:25585509,25585950:pet_clair:4230:25586083,25586641:pet_clair:4230:25586759,25588023:pet_clair:4230:25601694,25589708:pet_clair:4230:25589948,25591337:pet_clair:4230:25591550,25592806:pet_clair:4230:25593155,25592810:pet_clair:4230:25593322,25592813:pet_clair:4230:25593682,25592818:pet_clair:4230:25593545,25592821:pet_clair:4230:25593875,25592826:pet_clair:4230:25594084,25594537:pet_clair:4230:25594582,25595246:pet_clair:4230:25601954,25614550:pet_clair:4230:25615817,25614553:pet_clair:4230:25615939,25614555:pet_clair:4230:25615690,25614558:pet_clair:4230:25615767,25614561:pet_clair:4230:25615710,25614565:pet_clair:4230:25615530,25614568:pet_clair:4230:25615604,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0021857661120444484, 'nb_photo': 1170, 'list_port_cont': '25576296,25576491,25577344,25578763,25580419,25581785,25582569,25583485,25584224,25584852,25585515,25586085,25586761,25589940,25591548,25593166,25593316,25593538,25593686,25593869,25594091,25594580,25601721,25601960,25614680,25614722,25614772,25614877,25614986,25615038,25615095,25615180,25615212,25615305,25615335,25615395,25615446,25615497,25615526,25615563,25615605,25615687,25615705,25615768,25615810,25615931,25622176,25623145,25623433,25623938,25624306,25651875,25651994,25652126,25652159,25652262,25652413,25652541,25652733,25652890,25653346,25656919,25657230,25658867,25705311,25705355,25705413,25705687,25705729,25705778,25705819,25705842,25705893,25705973,25706045,25706143,25706206,25706256,25706301,25706375,25706403,25706649,25707469,25708680,25709586,25711255,25713004,25715445,25718151,25720631,25723323,25725490,25727153,25728899,25733622,25735619,25736497,25749025,25749156,25749238,25797332,25797596,25797629,25797851,25798113,25798149,25798250,25798374,25798596,25799669,25824537,25828548,25828619,2582877', 'assoc_port': '25576161:25576296,25576368:25576491,25577110:25577344,25578309:25578763,25580270:25580419,25581466:25581785,25582370:25582569,25583280:25583485,25584040:25584224,25584706:25584852,25585392:25585515,25585950:25586085,25586641:25586761,25588023:25601721,25589708:25589940,25591337:25591548,25592806:25593166,25592810:25593316,25592813:25593686,25592818:25593538,25592821:25593869,25592826:25594091,25594537:25594580,25595246:25601960,25614550:25615810,25614553:25615931,25614555:25615687,25614558:25615768,25614561:25615705,25614565:25615526,25614568:25615605,25614572:25615497,25614576:25615563,25614581:25615446,25614583:25615395,25614586:25615305,25614588:25615335,25614591:25615180,25614593:25615095,25614596:25615212,25614598:25615038,25614600:25614986,25614601:25614877,25614603:25614680,25614605:25614722,25614606:25614772,25621893:25622176,25621896:25623145,25621897:25623433,25621908:25624306,25621922:25623938,25651374:25653346,25651379:25652541,25651382:25652890,25651383:25652733,25651384:25652413,25651387:2565226', 'assoc_mat': '25576161:pet_fonce:4230:25576296,25576368:pet_fonce:4230:25576491,25577110:pet_fonce:4230:25577344,25578309:pet_fonce:4230:25578763,25580270:pet_fonce:4230:25580419,25581466:pet_fonce:4230:25581785,25582370:pet_fonce:4230:25582569,25583280:pet_fonce:4230:25583485,25584040:pet_fonce:4230:25584224,25584706:pet_fonce:4230:25584852,25585392:pet_fonce:4230:25585515,25585950:pet_fonce:4230:25586085,25586641:pet_fonce:4230:25586761,25588023:pet_fonce:4230:25601721,25589708:pet_fonce:4230:25589940,25591337:pet_fonce:4230:25591548,25592806:pet_fonce:4230:25593166,25592810:pet_fonce:4230:25593316,25592813:pet_fonce:4230:25593686,25592818:pet_fonce:4230:25593538,25592821:pet_fonce:4230:25593869,25592826:pet_fonce:4230:25594091,25594537:pet_fonce:4230:25594580,25595246:pet_fonce:4230:25601960,25614550:pet_fonce:4230:25615810,25614553:pet_fonce:4230:25615931,25614555:pet_fonce:4230:25615687,25614558:pet_fonce:4230:25615768,25614561:pet_fonce:4230:25615705,25614565:pet_fonce:4230:25615526,25614568:pet_fonce:4230:25615605,2'}), 'main_stat': {'nb_photos': 2283}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-08', 0.7575274542453474),)]} filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_08_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.36%', 17447], 'carton': ['carton', '5.79%', 96720], 'metal': ['metal', '0.11%', 1615], 'papier': ['papier', '18.66%', 386200], 'pehd': ['pehd', '0.27%', 1817], 'pet_clair': ['pet_clair', '1.26%', 21543], 'pet_fonce': ['pet_fonce', '0.22%', 1170]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_4/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_08_annee_2025.pdf le fichier se trouve ici : /data_4/data_log/job/memo/SCCU_cam8 2.35user 2.50system 0:07.78elapsed 62%CPU (0avgtext+0avgdata 174116maxresident)k 88inputs+280outputs (1major+45073minor)pagefaults 0swaps