python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam6 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam6 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-02 _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py _cr_cnf_ : /home/admin/mtr/.credentials/credentials.py warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data nb_day : (5, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (5, 28) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 202 month : 02 mtr_id : dashboard_places : SCCU_cam6 date : 2025-02 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam6' and date like '%2025-02%') and created_at like '%2025-02%'))); nb_day : (5, 28) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and ded.dashboard_place_id = 202 and month(ded.date) = 02 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), count(distinct mtr_photo_id) FROM MTRPhoto.dashboard_results dr, MTRUser.mtr_portfolio_photos mpp, MTRPhoto.dashboard_entry_day ded where mpp.mtr_portfolio_id=dr.mtr_portfolio_id and dr.hashtag = '_______incineration' and ded.dashboard_place_id = 202 and month(ded.date) = 02 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 202 and mp.name like '%022025%' and cps.thcl = 1533 GROUP BY sbstr ; Erreur dans le nom de portfolio du batch invalid literal for int() with base 10: 'SCCU' after number_of_batch date_start : 2025-02-01 : dt_date_just_month_year : 2025-02-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam6" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-02-01" AND ded.date <= "2025-02-28" 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 (1579377,1582577,1585756,1589018,1592054,1595264,1597079,1597816,1600965,1604003,1606869,1609739,1612862,1614265,1614514,1616884,1619380,1621049,1622568,1625880,1627600,1627890,1629320,1631849,1634488,1636898,1639902) 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.015993588253880645, 'nb_photo': 16683, 'list_port_cont': '20128105,20192759,20193932,20194601,20230455,20232095,20232457,20232982,20233808,20233929,20273472,20276678,20276998,20282157,20284651,20286304,20288054,20291248,20295423,20296043,20296614,20297134,20297775,20303325,20305727,20308660,20313269,20313976,20323657,20324111,20324496,20324912,20325318,20326066,20326490,20327354,20328391,20329560,20329800,20330517,20331002,20331316,20351031,20352973,20353186,20353505,20353801,20354656,20355879,20356017,20356099,20356265,20356473,20356554,20356666,20356846,20356882,20357049,20357105,20357288,20357645,20358148,20358317,20358527,20358574,20359886,20360424,20361604,20361697,20365789,20367260,20368009,20371699,20372278,20372856,20372942,20373184,20373391,20373474,20373653,20374004,20374034,20374191,20374325,20374371,20374400,20374440,20374476,20374526,20374556,20374606,20374705,20374743,20374830,20374906,20374935,20375017,20375105,20375183,20375260,20375352,20375440,20375482,20375545,20375698,20375737,20375780,20375808,20375899,20376020,20376054,20376128,20376200,2037631', 'assoc_port': '20127879:20128105,20192481:20192759,20193045:20323657,20193047:20324111,20193049:20324496,20193051:20324912,20193053:20325318,20193055:20410458,20193057:20326066,20193059:20326490,20193061:20466847,20193063:20327354,20193067:20412951,20193069:20328391,20193071:20413048,20193073:20329560,20193075:20329800,20193077:20465062,20193079:20330517,20193081:20331002,20193083:20467289,20193085:20331316,20193775:20193932,20194486:20194601,20228800:20355879,20228803:20356017,20228806:20356099,20228809:20356265,20228812:20356473,20228815:20356666,20228818:20356846,20228821:20357105,20228824:20357288,20228827:20427525,20228830:20357645,20228833:20427214,20228836:20428969,20228839:20429419,20228842:20358148,20228845:20358317,20228848:20233929,20228851:20358527,20228854:20233808,20228857:20230455,20228859:20232457,20231320:20232095,20232597:20232982,20271402:20273472,20273922:20374400,20273924:20374476,20273927:20374440,20273931:20374556,20273934:20374606,20273936:20374743,20273940:20374830,20273942:20374935,20273944:2037501', 'assoc_mat': '20127879:autre:4230:20128105,20192481:autre:4230:20192759,20193045:autre:4230:20323657,20193047:autre:4230:20324111,20193049:autre:4230:20324496,20193051:autre:4230:20324912,20193053:autre:4230:20325318,20193055:autre:4230:20410458,20193057:autre:4230:20326066,20193059:autre:4230:20326490,20193061:autre:4230:20466847,20193063:autre:4230:20327354,20193067:autre:4230:20412951,20193069:autre:4230:20328391,20193071:autre:4230:20413048,20193073:autre:4230:20329560,20193075:autre:4230:20329800,20193077:autre:4230:20465062,20193079:autre:4230:20330517,20193081:autre:4230:20331002,20193083:autre:4230:20467289,20193085:autre:4230:20331316,20193775:autre:4230:20193932,20194486:autre:4230:20194601,20228800:autre:4230:20355879,20228803:autre:4230:20356017,20228806:autre:4230:20356099,20228809:autre:4230:20356265,20228812:autre:4230:20356473,20228815:autre:4230:20356666,20228818:autre:4230:20356846,20228821:autre:4230:20357105,20228824:autre:4230:20357288,20228827:autre:4230:20427525,20228830:autre:4230:20357645,20228833:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05283384822941771, 'nb_photo': 79127, 'list_port_cont': '20128101,20192768,20193943,20194607,20230469,20232110,20232451,20232985,20233818,20233938,20273479,20276673,20277004,20277062,20282155,20284647,20286315,20288050,20291244,20295430,20296046,20296613,20297125,20297762,20303341,20305721,20308658,20313266,20313983,20323662,20324122,20324490,20324923,20325317,20326070,20326498,20327349,20328390,20329558,20329787,20330514,20331014,20331323,20351043,20352961,20353202,20353515,20353802,20354657,20355891,20356032,20356105,20356260,20356480,20356543,20356660,20356854,20356889,20357060,20357109,20357289,20357653,20358155,20358318,20358536,20358567,20359895,20360438,20361615,20361710,20365787,20367271,20368006,20371690,20372285,20372859,20372947,20373189,20373401,20373476,20373668,20374010,20374042,20374199,20374330,20374366,20374410,20374456,20374479,20374524,20374565,20374592,20374713,20374744,20374824,20374900,20374943,20375023,20375104,20375178,20375261,20375345,20375445,20375483,20375550,20375701,20375743,20375781,20375813,20375895,20376017,20376060,20376127,2037621', 'assoc_port': '20127879:20128101,20192481:20192768,20193045:20323662,20193047:20324122,20193049:20324490,20193051:20324923,20193053:20325317,20193055:20410460,20193057:20326070,20193059:20326498,20193061:20466855,20193063:20327349,20193067:20412945,20193069:20328390,20193071:20413051,20193073:20329558,20193075:20329787,20193077:20465056,20193079:20330514,20193081:20331014,20193083:20467301,20193085:20331323,20193775:20193943,20194486:20194607,20228800:20355891,20228803:20356032,20228806:20356105,20228809:20356260,20228812:20356480,20228815:20356660,20228818:20356854,20228821:20357109,20228824:20357289,20228827:20427532,20228830:20357653,20228833:20427221,20228836:20428974,20228839:20429423,20228842:20358155,20228845:20358318,20228848:20233938,20228851:20358536,20228854:20233818,20228857:20230469,20228859:20232451,20231320:20232110,20232597:20232985,20271402:20273479,20273173:20277062,20273922:20374410,20273924:20374479,20273927:20374456,20273931:20374565,20273934:20374592,20273936:20374744,20273940:20374824,20273942:2037494', 'assoc_mat': '20127879:carton:4230:20128101,20192481:carton:4230:20192768,20193045:carton:4230:20323662,20193047:carton:4230:20324122,20193049:carton:4230:20324490,20193051:carton:4230:20324923,20193053:carton:4230:20325317,20193055:carton:4230:20410460,20193057:carton:4230:20326070,20193059:carton:4230:20326498,20193061:carton:4230:20466855,20193063:carton:4230:20327349,20193067:carton:4230:20412945,20193069:carton:4230:20328390,20193071:carton:4230:20413051,20193073:carton:4230:20329558,20193075:carton:4230:20329787,20193077:carton:4230:20465056,20193079:carton:4230:20330514,20193081:carton:4230:20331014,20193083:carton:4230:20467301,20193085:carton:4230:20331323,20193775:carton:4230:20193943,20194486:carton:4230:20194607,20228800:carton:4230:20355891,20228803:carton:4230:20356032,20228806:carton:4230:20356105,20228809:carton:4230:20356260,20228812:carton:4230:20356480,20228815:carton:4230:20356660,20228818:carton:4230:20356854,20228821:carton:4230:20357109,20228824:carton:4230:20357289,20228827:carton:4230:20427532,2022'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011324049272418975, 'nb_photo': 1392, 'list_port_cont': '20128104,20192756,20194610,20230472,20232093,20232459,20232976,20233820,20233942,20273481,20277008,20282156,20284639,20286300,20288043,20291235,20295416,20296033,20296600,20297133,20297764,20303339,20308659,20313273,20313985,20324127,20324927,20326503,20327358,20329555,20329788,20330508,20331004,20351026,20352959,20353193,20353517,20353797,20354662,20356019,20356096,20356474,20356556,20356669,20356852,20356881,20357051,20357106,20357277,20357647,20358163,20358325,20358537,20358563,20359885,20360437,20361605,20361707,20367266,20367998,20372869,20372936,20373181,20373473,20373996,20374201,20374354,20374414,20374453,20374483,20374522,20374595,20374707,20374753,20374818,20374908,20374940,20375025,20375108,20375340,20375435,20375467,20375551,20375708,20375730,20375764,20375811,20375886,20376003,20376058,20376204,20376330,20376362,20376430,20376467,20376559,20376792,20376852,20376906,20378414,20378440,20378668,20379777,20380281,20381810,20381832,20383618,20383895,20383927,20384065,20384110,20384679,20385669,2038628', 'assoc_port': '20127879:20128104,20192481:20192756,20193047:20324127,20193051:20324927,20193059:20326503,20193061:20466853,20193063:20327358,20193067:20412946,20193071:20413045,20193073:20329555,20193075:20329788,20193077:20465057,20193079:20330508,20193081:20331004,20193083:20467293,20194486:20194610,20228803:20356019,20228806:20356096,20228812:20356474,20228815:20356669,20228818:20356852,20228821:20357106,20228824:20357277,20228827:20427507,20228830:20357647,20228833:20427218,20228836:20428966,20228839:20429425,20228842:20358163,20228845:20358325,20228848:20233942,20228851:20358537,20228854:20233820,20228857:20230472,20228859:20232459,20231320:20232093,20232597:20232976,20271402:20273481,20273922:20374414,20273924:20374483,20273927:20374453,20273934:20374595,20273936:20374753,20273940:20374818,20273942:20374940,20273944:20375025,20273949:20403906,20273951:20375551,20273953:20375708,20273955:20375764,20273958:20376003,20273960:20376058,20273962:20376204,20273965:20376330,20273967:20376430,20273970:20376559,20276893:2027700', 'assoc_mat': '20127879:metal:4230:20128104,20192481:metal:4230:20192756,20193047:metal:4230:20324127,20193051:metal:4230:20324927,20193059:metal:4230:20326503,20193061:metal:4230:20466853,20193063:metal:4230:20327358,20193067:metal:4230:20412946,20193071:metal:4230:20413045,20193073:metal:4230:20329555,20193075:metal:4230:20329788,20193077:metal:4230:20465057,20193079:metal:4230:20330508,20193081:metal:4230:20331004,20193083:metal:4230:20467293,20194486:metal:4230:20194610,20228803:metal:4230:20356019,20228806:metal:4230:20356096,20228812:metal:4230:20356474,20228815:metal:4230:20356669,20228818:metal:4230:20356852,20228821:metal:4230:20357106,20228824:metal:4230:20357277,20228827:metal:4230:20427507,20228830:metal:4230:20357647,20228833:metal:4230:20427218,20228836:metal:4230:20428966,20228839:metal:4230:20429425,20228842:metal:4230:20358163,20228845:metal:4230:20358325,20228848:metal:4230:20233942,20228851:metal:4230:20358537,20228854:metal:4230:20233820,20228857:metal:4230:20230472,20228859:metal:4230:20232459,20231320:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20757355730597613, 'nb_photo': 364780, 'list_port_cont': '20128098,20192766,20193948,20194602,20230462,20232108,20232466,20232975,20233823,20233933,20273484,20276676,20277003,20277054,20282146,20284648,20286314,20288052,20291237,20295433,20296041,20296608,20297122,20297770,20303335,20305723,20308653,20313276,20313990,20323652,20324123,20324498,20324926,20325319,20326073,20326502,20327361,20328388,20329557,20329799,20330519,20331009,20331315,20351030,20352968,20353192,20353510,20353800,20354663,20355892,20356024,20356108,20356257,20356481,20356550,20356670,20356858,20356892,20357055,20357103,20357286,20357651,20358160,20358322,20358535,20358569,20359898,20360428,20361616,20361703,20365795,20367265,20368008,20371700,20372286,20372868,20372941,20373186,20373393,20373467,20373663,20374007,20374044,20374202,20374319,20374368,20374415,20374454,20374492,20374530,20374550,20374603,20374710,20374750,20374828,20374910,20374947,20375024,20375095,20375176,20375256,20375356,20375446,20375481,20375557,20375705,20375741,20375774,20375820,20375898,20376019,20376056,20376140,2037620', 'assoc_port': '20127879:20128098,20192481:20192766,20193045:20323652,20193047:20324123,20193049:20324498,20193051:20324926,20193053:20325319,20193055:20410461,20193057:20326073,20193059:20326502,20193061:20466860,20193063:20327361,20193067:20412950,20193069:20328388,20193071:20413049,20193073:20329557,20193075:20329799,20193077:20465064,20193079:20330519,20193081:20331009,20193083:20467292,20193085:20331315,20193775:20193948,20194486:20194602,20228800:20355892,20228803:20356024,20228806:20356108,20228809:20356257,20228812:20356481,20228815:20356670,20228818:20356858,20228821:20357103,20228824:20357286,20228827:20427529,20228830:20357651,20228833:20427213,20228836:20428975,20228839:20429427,20228842:20358160,20228845:20358322,20228848:20233933,20228851:20358535,20228854:20233823,20228857:20230462,20228859:20232466,20231320:20232108,20232597:20232975,20271402:20273484,20273173:20277054,20273922:20374415,20273924:20374492,20273927:20374454,20273931:20374550,20273934:20374603,20273936:20374750,20273940:20374828,20273942:2037494', 'assoc_mat': '20127879:papier:4230:20128098,20192481:papier:4230:20192766,20193045:papier:4230:20323652,20193047:papier:4230:20324123,20193049:papier:4230:20324498,20193051:papier:4230:20324926,20193053:papier:4230:20325319,20193055:papier:4230:20410461,20193057:papier:4230:20326073,20193059:papier:4230:20326502,20193061:papier:4230:20466860,20193063:papier:4230:20327361,20193067:papier:4230:20412950,20193069:papier:4230:20328388,20193071:papier:4230:20413049,20193073:papier:4230:20329557,20193075:papier:4230:20329799,20193077:papier:4230:20465064,20193079:papier:4230:20330519,20193081:papier:4230:20331009,20193083:papier:4230:20467292,20193085:papier:4230:20331315,20193775:papier:4230:20193948,20194486:papier:4230:20194602,20228800:papier:4230:20355892,20228803:papier:4230:20356024,20228806:papier:4230:20356108,20228809:papier:4230:20356257,20228812:papier:4230:20356481,20228815:papier:4230:20356670,20228818:papier:4230:20356858,20228821:papier:4230:20357103,20228824:papier:4230:20357286,20228827:papier:4230:20427529,2022'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004609362310036943, 'nb_photo': 2337, 'list_port_cont': '20128102,20192770,20194609,20232096,20232461,20232987,20233824,20233939,20273474,20276675,20277005,20282145,20284645,20286313,20288053,20291247,20295421,20296044,20296607,20297130,20297776,20303336,20308665,20313267,20313986,20324117,20324495,20325325,20326493,20327363,20328384,20329549,20329794,20330516,20331005,20331317,20351040,20352974,20353199,20353507,20354653,20355882,20356025,20356107,20356256,20356482,20356667,20356842,20356880,20357047,20357097,20357293,20357649,20358161,20358330,20358529,20358571,20359892,20360431,20361618,20361706,20365786,20367268,20368012,20371697,20372283,20372860,20373187,20373475,20373669,20374008,20374045,20374200,20374332,20374363,20374408,20374448,20374489,20374525,20374561,20374605,20374747,20374820,20374905,20374952,20375034,20375171,20375259,20375354,20375447,20375473,20375554,20375700,20375776,20375806,20375900,20376015,20376064,20376213,20376329,20376441,20376555,20376791,20376869,20376910,20377378,20378179,20378417,20378456,20378677,20379313,20381809,20381848,2038242', 'assoc_port': '20127879:20128102,20192481:20192770,20193047:20324117,20193049:20324495,20193053:20325325,20193055:20410457,20193059:20326493,20193061:20466863,20193063:20327363,20193067:20412942,20193069:20328384,20193071:20413050,20193073:20329549,20193075:20329794,20193077:20465060,20193079:20330516,20193081:20331005,20193083:20467302,20193085:20331317,20194486:20194609,20228800:20355882,20228803:20356025,20228806:20356107,20228809:20356256,20228812:20356482,20228815:20356667,20228818:20356842,20228821:20357097,20228824:20357293,20228827:20427511,20228830:20357649,20228833:20427219,20228836:20428978,20228839:20429422,20228842:20358161,20228845:20358330,20228848:20233939,20228851:20358529,20228854:20233824,20228859:20232461,20231320:20232096,20232597:20232987,20271402:20273474,20273922:20374408,20273924:20374489,20273927:20374448,20273931:20374561,20273934:20374605,20273936:20374747,20273940:20374820,20273942:20374952,20273944:20375034,20273947:20375171,20273949:20403911,20273951:20375554,20273953:20375700,20273955:2037577', 'assoc_mat': '20127879:pehd:4230:20128102,20192481:pehd:4230:20192770,20193047:pehd:4230:20324117,20193049:pehd:4230:20324495,20193053:pehd:4230:20325325,20193055:pehd:4230:20410457,20193059:pehd:4230:20326493,20193061:pehd:4230:20466863,20193063:pehd:4230:20327363,20193067:pehd:4230:20412942,20193069:pehd:4230:20328384,20193071:pehd:4230:20413050,20193073:pehd:4230:20329549,20193075:pehd:4230:20329794,20193077:pehd:4230:20465060,20193079:pehd:4230:20330516,20193081:pehd:4230:20331005,20193083:pehd:4230:20467302,20193085:pehd:4230:20331317,20194486:pehd:4230:20194609,20228800:pehd:4230:20355882,20228803:pehd:4230:20356025,20228806:pehd:4230:20356107,20228809:pehd:4230:20356256,20228812:pehd:4230:20356482,20228815:pehd:4230:20356667,20228818:pehd:4230:20356842,20228821:pehd:4230:20357097,20228824:pehd:4230:20357293,20228827:pehd:4230:20427511,20228830:pehd:4230:20357649,20228833:pehd:4230:20427219,20228836:pehd:4230:20428978,20228839:pehd:4230:20429422,20228842:pehd:4230:20358161,20228845:pehd:4230:20358330,20228848:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012508284153111568, 'nb_photo': 19842, 'list_port_cont': '20128099,20192760,20193947,20194599,20230464,20232106,20232453,20232980,20233825,20233943,20273483,20276665,20277007,20282152,20284641,20286310,20288046,20291243,20295432,20296047,20296611,20297129,20297768,20303340,20305713,20308663,20313275,20313981,20323663,20324125,20324491,20324925,20325324,20326077,20326505,20327362,20328392,20329551,20329798,20330510,20331015,20331312,20351038,20352971,20353191,20353516,20353794,20354652,20355884,20356031,20356098,20356266,20356469,20356553,20356662,20356855,20356886,20357050,20357112,20357291,20357646,20358164,20358326,20358530,20358575,20359900,20360429,20361617,20361708,20365790,20367270,20368003,20371701,20372290,20372864,20372945,20373190,20373398,20373470,20373670,20374005,20374040,20374198,20374324,20374364,20374412,20374444,20374490,20374523,20374558,20374607,20374712,20374748,20374829,20374898,20374951,20375027,20375107,20375180,20375257,20375346,20375443,20375478,20375556,20375702,20375745,20375777,20375816,20375892,20376018,20376065,20376137,20376207,2037633', 'assoc_port': '20127879:20128099,20192481:20192760,20193045:20323663,20193047:20324125,20193049:20324491,20193051:20324925,20193053:20325324,20193055:20410459,20193057:20326077,20193059:20326505,20193061:20466858,20193063:20327362,20193067:20412952,20193069:20328392,20193071:20413039,20193073:20329551,20193075:20329798,20193077:20465061,20193079:20330510,20193081:20331015,20193083:20467298,20193085:20331312,20193775:20193947,20194486:20194599,20228800:20355884,20228803:20356031,20228806:20356098,20228809:20356266,20228812:20356469,20228815:20356662,20228818:20356855,20228821:20357112,20228824:20357291,20228827:20427530,20228830:20357646,20228833:20427212,20228836:20428972,20228839:20429418,20228842:20358164,20228845:20358326,20228848:20233943,20228851:20358530,20228854:20233825,20228857:20230464,20228859:20232453,20231320:20232106,20232597:20232980,20271402:20273483,20273922:20374412,20273924:20374490,20273927:20374444,20273931:20374558,20273934:20374607,20273936:20374748,20273940:20374829,20273942:20374951,20273944:2037502', 'assoc_mat': '20127879:pet_clair:4230:20128099,20192481:pet_clair:4230:20192760,20193045:pet_clair:4230:20323663,20193047:pet_clair:4230:20324125,20193049:pet_clair:4230:20324491,20193051:pet_clair:4230:20324925,20193053:pet_clair:4230:20325324,20193055:pet_clair:4230:20410459,20193057:pet_clair:4230:20326077,20193059:pet_clair:4230:20326505,20193061:pet_clair:4230:20466858,20193063:pet_clair:4230:20327362,20193067:pet_clair:4230:20412952,20193069:pet_clair:4230:20328392,20193071:pet_clair:4230:20413039,20193073:pet_clair:4230:20329551,20193075:pet_clair:4230:20329798,20193077:pet_clair:4230:20465061,20193079:pet_clair:4230:20330510,20193081:pet_clair:4230:20331015,20193083:pet_clair:4230:20467298,20193085:pet_clair:4230:20331312,20193775:pet_clair:4230:20193947,20194486:pet_clair:4230:20194599,20228800:pet_clair:4230:20355884,20228803:pet_clair:4230:20356031,20228806:pet_clair:4230:20356098,20228809:pet_clair:4230:20356266,20228812:pet_clair:4230:20356469,20228815:pet_clair:4230:20356662,20228818:pet_clair:4230:20356855,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0030209009771813107, 'nb_photo': 1036, 'list_port_cont': '20232107,20232458,20232984,20233940,20273476,20276674,20282151,20286311,20291241,20295427,20296040,20296606,20297121,20297771,20305728,20313274,20313987,20324494,20324930,20326075,20327351,20329561,20329791,20330513,20331007,20331318,20351042,20353514,20355895,20356021,20356101,20356478,20356671,20356856,20356891,20357054,20357107,20357294,20357650,20358159,20358328,20358538,20359899,20360432,20361610,20361712,20365791,20367262,20373195,20373661,20374011,20374038,20374192,20374317,20374367,20374409,20374487,20374517,20374601,20374708,20374740,20374826,20374907,20374941,20375032,20375100,20375182,20375355,20375480,20375549,20375706,20375735,20375778,20375897,20376007,20376062,20376133,20376215,20376317,20376366,20376446,20376473,20376789,20376862,20376902,20377371,20378180,20379322,20379765,20380298,20381804,20381845,20382418,20383632,20384068,20384115,20384752,20385672,20386279,20386785,20387460,20389154,20392108,20393942,20403919,20410451,20412943,20413043,20423381,20427215,20427528,20428973,20429429,2043608', 'assoc_port': '20193049:20324494,20193051:20324930,20193055:20410451,20193057:20326075,20193061:20466857,20193063:20327351,20193067:20412943,20193071:20413043,20193073:20329561,20193075:20329791,20193077:20465063,20193079:20330513,20193081:20331007,20193083:20467299,20193085:20331318,20228800:20355895,20228803:20356021,20228806:20356101,20228812:20356478,20228815:20356671,20228818:20356856,20228821:20357107,20228824:20357294,20228827:20427528,20228830:20357650,20228833:20427215,20228836:20428973,20228839:20429429,20228842:20358159,20228845:20358328,20228848:20233940,20228851:20358538,20228859:20232458,20231320:20232107,20232597:20232984,20271402:20273476,20273922:20374409,20273924:20374487,20273934:20374601,20273936:20374740,20273940:20374826,20273942:20374941,20273944:20375032,20273947:20375182,20273949:20403919,20273951:20375549,20273953:20375706,20273955:20375778,20273958:20376007,20273960:20376062,20273962:20376215,20273965:20376317,20273967:20376446,20275732:20276674,20280538:20282151,20285862:20286311,20290078:2029124', 'assoc_mat': '20193049:pet_fonce:4230:20324494,20193051:pet_fonce:4230:20324930,20193055:pet_fonce:4230:20410451,20193057:pet_fonce:4230:20326075,20193061:pet_fonce:4230:20466857,20193063:pet_fonce:4230:20327351,20193067:pet_fonce:4230:20412943,20193071:pet_fonce:4230:20413043,20193073:pet_fonce:4230:20329561,20193075:pet_fonce:4230:20329791,20193077:pet_fonce:4230:20465063,20193079:pet_fonce:4230:20330513,20193081:pet_fonce:4230:20331007,20193083:pet_fonce:4230:20467299,20193085:pet_fonce:4230:20331318,20228800:pet_fonce:4230:20355895,20228803:pet_fonce:4230:20356021,20228806:pet_fonce:4230:20356101,20228812:pet_fonce:4230:20356478,20228815:pet_fonce:4230:20356671,20228818:pet_fonce:4230:20356856,20228821:pet_fonce:4230:20357107,20228824:pet_fonce:4230:20357294,20228827:pet_fonce:4230:20427528,20228830:pet_fonce:4230:20357650,20228833:pet_fonce:4230:20427215,20228836:pet_fonce:4230:20428973,20228839:pet_fonce:4230:20429429,20228842:pet_fonce:4230:20358159,20228845:pet_fonce:4230:20358328,20228848:pet_fonce:4230:20233940,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(1579377,1582577,1585756,1589018,1592054,1595264,1597079,1597816,1600965,1604003,1606869,1609739,1612862,1614265,1614514,1616884,1619380,1621049,1622568,1625880,1627600,1627890,1629320,1631849,1634488,1636898,1639902)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=202 and date >='2025-02-01' and date <= '2025-02-28') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1572,),), 'unwanted_material_monthly_percentage': ((0.7320993535199398,),), 'material_repartition': (('incineration', 1568),), 'material_dict': {'incineration': 1568}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 2, 1), 0.639796489695635, 2), (datetime.date(2025, 2, 3), 0.7179800713363391, 64), (datetime.date(2025, 2, 4), 0.6791098195155767, 61), (datetime.date(2025, 2, 5), 0.611956752372915, 59), (datetime.date(2025, 2, 6), 0.634549933382178, 50), (datetime.date(2025, 2, 7), 0.645287307741859, 62), (datetime.date(2025, 2, 8), 0.6361338406076353, 58), (datetime.date(2025, 2, 9), 0.7886356893350345, 57), (datetime.date(2025, 2, 10), 0.7579797538999417, 62), (datetime.date(2025, 2, 11), 0.725960754775183, 53), (datetime.date(2025, 2, 12), 0.733377504693801, 59), (datetime.date(2025, 2, 13), 0.712661446219421, 41), (datetime.date(2025, 2, 14), 0.7087412725808143, 59), (datetime.date(2025, 2, 15), 0.7262658024680494, 56), (datetime.date(2025, 2, 16), 0.8257493102222028, 68), (datetime.date(2025, 2, 17), 0.7997304447561294, 75), (datetime.date(2025, 2, 18), 0.7602080606377686, 83), (datetime.date(2025, 2, 19), 0.7290590660540694, 60), (datetime.date(2025, 2, 20), 0.7251857936927993, 33), (datetime.date(2025, 2, 21), 0.6664993273247276, 67), (datetime.date(2025, 2, 22), 0.7603367660554508, 59), (datetime.date(2025, 2, 23), 0.8302368969842344, 64), (datetime.date(2025, 2, 24), 0.7911464901722244, 60), (datetime.date(2025, 2, 25), 0.7788749219787405, 60), (datetime.date(2025, 2, 26), 0.7634818040892617, 70), (datetime.date(2025, 2, 27), 0.7352419258287971, 60), (datetime.date(2025, 2, 28), 0.6930278774280286, 66)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 2, 1), 0.639796489695635, 2), (datetime.date(2025, 2, 3), 0.7179800713363391, 64), (datetime.date(2025, 2, 4), 0.6791098195155767, 61), (datetime.date(2025, 2, 5), 0.611956752372915, 59), (datetime.date(2025, 2, 6), 0.634549933382178, 50), (datetime.date(2025, 2, 7), 0.645287307741859, 62), (datetime.date(2025, 2, 8), 0.6361338406076353, 58), (datetime.date(2025, 2, 9), 0.7886356893350345, 57), (datetime.date(2025, 2, 10), 0.7579797538999417, 62), (datetime.date(2025, 2, 11), 0.725960754775183, 53), (datetime.date(2025, 2, 12), 0.733377504693801, 59), (datetime.date(2025, 2, 13), 0.712661446219421, 41), (datetime.date(2025, 2, 14), 0.7087412725808143, 59), (datetime.date(2025, 2, 15), 0.7262658024680494, 56), (datetime.date(2025, 2, 16), 0.8257493102222028, 68), (datetime.date(2025, 2, 17), 0.7997304447561294, 75), (datetime.date(2025, 2, 18), 0.7602080606377686, 83), (datetime.date(2025, 2, 19), 0.7290590660540694, 60), (datetime.date(2025, 2, 20), 0.7251857936927993, 33), (datetime.date(2025, 2, 21), 0.6664993273247276, 67), (datetime.date(2025, 2, 22), 0.7603367660554508, 59), (datetime.date(2025, 2, 23), 0.8302368969842344, 64), (datetime.date(2025, 2, 24), 0.7911464901722244, 60), (datetime.date(2025, 2, 25), 0.7788749219787405, 60), (datetime.date(2025, 2, 26), 0.7634818040892617, 70), (datetime.date(2025, 2, 27), 0.7352419258287971, 60), (datetime.date(2025, 2, 28), 0.6930278774280286, 66))}, 'quality_array': [['-9.006186806949506', '01022025'], ['-8.159863910001178', '03022025'], ['-8.42902320122383', '04022025'], ['-8.787364948271424', '05022025'], ['-8.729590049449945', '06022025'], ['-8.838209647096626', '07022025'], ['-8.500721166917314', '08022025'], ['-8.419879460728701', '09022025'], ['-7.9407277315734195', '10022025'], ['-8.18382414255681', '11022025'], ['-8.148720776646137', '12022025'], ['-8.210083352016323', '13022025'], ['-8.526722698423592', '14022025'], ['-8.464280515345745', '15022025'], ['-8.107807541105583', '16022025'], ['-7.855559022737543', '17022025'], ['-7.777536721526704', '18022025'], ['-7.800002490996505', '19022025'], ['-8.197627807177149', '20022025'], ['-8.036578190060652', '21022025'], ['-8.122816762222927', '22022025'], ['-7.943081879679887', '23022025'], ['-7.398649394571681', '24022025'], ['-7.678291660098507', '25022025'], ['-8.133913624196616', '26022025'], ['-8.120935577619385', '27022025'], ['-8.268214235893623', '28022025']], 'number_of_batch': ((584,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015993588253880645, 'nb_photo': 16683, 'list_port_cont': '20128105,20192759,20193932,20194601,20230455,20232095,20232457,20232982,20233808,20233929,20273472,20276678,20276998,20282157,20284651,20286304,20288054,20291248,20295423,20296043,20296614,20297134,20297775,20303325,20305727,20308660,20313269,20313976,20323657,20324111,20324496,20324912,20325318,20326066,20326490,20327354,20328391,20329560,20329800,20330517,20331002,20331316,20351031,20352973,20353186,20353505,20353801,20354656,20355879,20356017,20356099,20356265,20356473,20356554,20356666,20356846,20356882,20357049,20357105,20357288,20357645,20358148,20358317,20358527,20358574,20359886,20360424,20361604,20361697,20365789,20367260,20368009,20371699,20372278,20372856,20372942,20373184,20373391,20373474,20373653,20374004,20374034,20374191,20374325,20374371,20374400,20374440,20374476,20374526,20374556,20374606,20374705,20374743,20374830,20374906,20374935,20375017,20375105,20375183,20375260,20375352,20375440,20375482,20375545,20375698,20375737,20375780,20375808,20375899,20376020,20376054,20376128,20376200,2037631', 'assoc_port': '20127879:20128105,20192481:20192759,20193045:20323657,20193047:20324111,20193049:20324496,20193051:20324912,20193053:20325318,20193055:20410458,20193057:20326066,20193059:20326490,20193061:20466847,20193063:20327354,20193067:20412951,20193069:20328391,20193071:20413048,20193073:20329560,20193075:20329800,20193077:20465062,20193079:20330517,20193081:20331002,20193083:20467289,20193085:20331316,20193775:20193932,20194486:20194601,20228800:20355879,20228803:20356017,20228806:20356099,20228809:20356265,20228812:20356473,20228815:20356666,20228818:20356846,20228821:20357105,20228824:20357288,20228827:20427525,20228830:20357645,20228833:20427214,20228836:20428969,20228839:20429419,20228842:20358148,20228845:20358317,20228848:20233929,20228851:20358527,20228854:20233808,20228857:20230455,20228859:20232457,20231320:20232095,20232597:20232982,20271402:20273472,20273922:20374400,20273924:20374476,20273927:20374440,20273931:20374556,20273934:20374606,20273936:20374743,20273940:20374830,20273942:20374935,20273944:2037501', 'assoc_mat': '20127879:autre:4230:20128105,20192481:autre:4230:20192759,20193045:autre:4230:20323657,20193047:autre:4230:20324111,20193049:autre:4230:20324496,20193051:autre:4230:20324912,20193053:autre:4230:20325318,20193055:autre:4230:20410458,20193057:autre:4230:20326066,20193059:autre:4230:20326490,20193061:autre:4230:20466847,20193063:autre:4230:20327354,20193067:autre:4230:20412951,20193069:autre:4230:20328391,20193071:autre:4230:20413048,20193073:autre:4230:20329560,20193075:autre:4230:20329800,20193077:autre:4230:20465062,20193079:autre:4230:20330517,20193081:autre:4230:20331002,20193083:autre:4230:20467289,20193085:autre:4230:20331316,20193775:autre:4230:20193932,20194486:autre:4230:20194601,20228800:autre:4230:20355879,20228803:autre:4230:20356017,20228806:autre:4230:20356099,20228809:autre:4230:20356265,20228812:autre:4230:20356473,20228815:autre:4230:20356666,20228818:autre:4230:20356846,20228821:autre:4230:20357105,20228824:autre:4230:20357288,20228827:autre:4230:20427525,20228830:autre:4230:20357645,20228833:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05283384822941771, 'nb_photo': 79127, 'list_port_cont': '20128101,20192768,20193943,20194607,20230469,20232110,20232451,20232985,20233818,20233938,20273479,20276673,20277004,20277062,20282155,20284647,20286315,20288050,20291244,20295430,20296046,20296613,20297125,20297762,20303341,20305721,20308658,20313266,20313983,20323662,20324122,20324490,20324923,20325317,20326070,20326498,20327349,20328390,20329558,20329787,20330514,20331014,20331323,20351043,20352961,20353202,20353515,20353802,20354657,20355891,20356032,20356105,20356260,20356480,20356543,20356660,20356854,20356889,20357060,20357109,20357289,20357653,20358155,20358318,20358536,20358567,20359895,20360438,20361615,20361710,20365787,20367271,20368006,20371690,20372285,20372859,20372947,20373189,20373401,20373476,20373668,20374010,20374042,20374199,20374330,20374366,20374410,20374456,20374479,20374524,20374565,20374592,20374713,20374744,20374824,20374900,20374943,20375023,20375104,20375178,20375261,20375345,20375445,20375483,20375550,20375701,20375743,20375781,20375813,20375895,20376017,20376060,20376127,2037621', 'assoc_port': '20127879:20128101,20192481:20192768,20193045:20323662,20193047:20324122,20193049:20324490,20193051:20324923,20193053:20325317,20193055:20410460,20193057:20326070,20193059:20326498,20193061:20466855,20193063:20327349,20193067:20412945,20193069:20328390,20193071:20413051,20193073:20329558,20193075:20329787,20193077:20465056,20193079:20330514,20193081:20331014,20193083:20467301,20193085:20331323,20193775:20193943,20194486:20194607,20228800:20355891,20228803:20356032,20228806:20356105,20228809:20356260,20228812:20356480,20228815:20356660,20228818:20356854,20228821:20357109,20228824:20357289,20228827:20427532,20228830:20357653,20228833:20427221,20228836:20428974,20228839:20429423,20228842:20358155,20228845:20358318,20228848:20233938,20228851:20358536,20228854:20233818,20228857:20230469,20228859:20232451,20231320:20232110,20232597:20232985,20271402:20273479,20273173:20277062,20273922:20374410,20273924:20374479,20273927:20374456,20273931:20374565,20273934:20374592,20273936:20374744,20273940:20374824,20273942:2037494', 'assoc_mat': '20127879:carton:4230:20128101,20192481:carton:4230:20192768,20193045:carton:4230:20323662,20193047:carton:4230:20324122,20193049:carton:4230:20324490,20193051:carton:4230:20324923,20193053:carton:4230:20325317,20193055:carton:4230:20410460,20193057:carton:4230:20326070,20193059:carton:4230:20326498,20193061:carton:4230:20466855,20193063:carton:4230:20327349,20193067:carton:4230:20412945,20193069:carton:4230:20328390,20193071:carton:4230:20413051,20193073:carton:4230:20329558,20193075:carton:4230:20329787,20193077:carton:4230:20465056,20193079:carton:4230:20330514,20193081:carton:4230:20331014,20193083:carton:4230:20467301,20193085:carton:4230:20331323,20193775:carton:4230:20193943,20194486:carton:4230:20194607,20228800:carton:4230:20355891,20228803:carton:4230:20356032,20228806:carton:4230:20356105,20228809:carton:4230:20356260,20228812:carton:4230:20356480,20228815:carton:4230:20356660,20228818:carton:4230:20356854,20228821:carton:4230:20357109,20228824:carton:4230:20357289,20228827:carton:4230:20427532,2022'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011324049272418975, 'nb_photo': 1392, 'list_port_cont': '20128104,20192756,20194610,20230472,20232093,20232459,20232976,20233820,20233942,20273481,20277008,20282156,20284639,20286300,20288043,20291235,20295416,20296033,20296600,20297133,20297764,20303339,20308659,20313273,20313985,20324127,20324927,20326503,20327358,20329555,20329788,20330508,20331004,20351026,20352959,20353193,20353517,20353797,20354662,20356019,20356096,20356474,20356556,20356669,20356852,20356881,20357051,20357106,20357277,20357647,20358163,20358325,20358537,20358563,20359885,20360437,20361605,20361707,20367266,20367998,20372869,20372936,20373181,20373473,20373996,20374201,20374354,20374414,20374453,20374483,20374522,20374595,20374707,20374753,20374818,20374908,20374940,20375025,20375108,20375340,20375435,20375467,20375551,20375708,20375730,20375764,20375811,20375886,20376003,20376058,20376204,20376330,20376362,20376430,20376467,20376559,20376792,20376852,20376906,20378414,20378440,20378668,20379777,20380281,20381810,20381832,20383618,20383895,20383927,20384065,20384110,20384679,20385669,2038628', 'assoc_port': '20127879:20128104,20192481:20192756,20193047:20324127,20193051:20324927,20193059:20326503,20193061:20466853,20193063:20327358,20193067:20412946,20193071:20413045,20193073:20329555,20193075:20329788,20193077:20465057,20193079:20330508,20193081:20331004,20193083:20467293,20194486:20194610,20228803:20356019,20228806:20356096,20228812:20356474,20228815:20356669,20228818:20356852,20228821:20357106,20228824:20357277,20228827:20427507,20228830:20357647,20228833:20427218,20228836:20428966,20228839:20429425,20228842:20358163,20228845:20358325,20228848:20233942,20228851:20358537,20228854:20233820,20228857:20230472,20228859:20232459,20231320:20232093,20232597:20232976,20271402:20273481,20273922:20374414,20273924:20374483,20273927:20374453,20273934:20374595,20273936:20374753,20273940:20374818,20273942:20374940,20273944:20375025,20273949:20403906,20273951:20375551,20273953:20375708,20273955:20375764,20273958:20376003,20273960:20376058,20273962:20376204,20273965:20376330,20273967:20376430,20273970:20376559,20276893:2027700', 'assoc_mat': '20127879:metal:4230:20128104,20192481:metal:4230:20192756,20193047:metal:4230:20324127,20193051:metal:4230:20324927,20193059:metal:4230:20326503,20193061:metal:4230:20466853,20193063:metal:4230:20327358,20193067:metal:4230:20412946,20193071:metal:4230:20413045,20193073:metal:4230:20329555,20193075:metal:4230:20329788,20193077:metal:4230:20465057,20193079:metal:4230:20330508,20193081:metal:4230:20331004,20193083:metal:4230:20467293,20194486:metal:4230:20194610,20228803:metal:4230:20356019,20228806:metal:4230:20356096,20228812:metal:4230:20356474,20228815:metal:4230:20356669,20228818:metal:4230:20356852,20228821:metal:4230:20357106,20228824:metal:4230:20357277,20228827:metal:4230:20427507,20228830:metal:4230:20357647,20228833:metal:4230:20427218,20228836:metal:4230:20428966,20228839:metal:4230:20429425,20228842:metal:4230:20358163,20228845:metal:4230:20358325,20228848:metal:4230:20233942,20228851:metal:4230:20358537,20228854:metal:4230:20233820,20228857:metal:4230:20230472,20228859:metal:4230:20232459,20231320:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20757355730597613, 'nb_photo': 364780, 'list_port_cont': '20128098,20192766,20193948,20194602,20230462,20232108,20232466,20232975,20233823,20233933,20273484,20276676,20277003,20277054,20282146,20284648,20286314,20288052,20291237,20295433,20296041,20296608,20297122,20297770,20303335,20305723,20308653,20313276,20313990,20323652,20324123,20324498,20324926,20325319,20326073,20326502,20327361,20328388,20329557,20329799,20330519,20331009,20331315,20351030,20352968,20353192,20353510,20353800,20354663,20355892,20356024,20356108,20356257,20356481,20356550,20356670,20356858,20356892,20357055,20357103,20357286,20357651,20358160,20358322,20358535,20358569,20359898,20360428,20361616,20361703,20365795,20367265,20368008,20371700,20372286,20372868,20372941,20373186,20373393,20373467,20373663,20374007,20374044,20374202,20374319,20374368,20374415,20374454,20374492,20374530,20374550,20374603,20374710,20374750,20374828,20374910,20374947,20375024,20375095,20375176,20375256,20375356,20375446,20375481,20375557,20375705,20375741,20375774,20375820,20375898,20376019,20376056,20376140,2037620', 'assoc_port': '20127879:20128098,20192481:20192766,20193045:20323652,20193047:20324123,20193049:20324498,20193051:20324926,20193053:20325319,20193055:20410461,20193057:20326073,20193059:20326502,20193061:20466860,20193063:20327361,20193067:20412950,20193069:20328388,20193071:20413049,20193073:20329557,20193075:20329799,20193077:20465064,20193079:20330519,20193081:20331009,20193083:20467292,20193085:20331315,20193775:20193948,20194486:20194602,20228800:20355892,20228803:20356024,20228806:20356108,20228809:20356257,20228812:20356481,20228815:20356670,20228818:20356858,20228821:20357103,20228824:20357286,20228827:20427529,20228830:20357651,20228833:20427213,20228836:20428975,20228839:20429427,20228842:20358160,20228845:20358322,20228848:20233933,20228851:20358535,20228854:20233823,20228857:20230462,20228859:20232466,20231320:20232108,20232597:20232975,20271402:20273484,20273173:20277054,20273922:20374415,20273924:20374492,20273927:20374454,20273931:20374550,20273934:20374603,20273936:20374750,20273940:20374828,20273942:2037494', 'assoc_mat': '20127879:papier:4230:20128098,20192481:papier:4230:20192766,20193045:papier:4230:20323652,20193047:papier:4230:20324123,20193049:papier:4230:20324498,20193051:papier:4230:20324926,20193053:papier:4230:20325319,20193055:papier:4230:20410461,20193057:papier:4230:20326073,20193059:papier:4230:20326502,20193061:papier:4230:20466860,20193063:papier:4230:20327361,20193067:papier:4230:20412950,20193069:papier:4230:20328388,20193071:papier:4230:20413049,20193073:papier:4230:20329557,20193075:papier:4230:20329799,20193077:papier:4230:20465064,20193079:papier:4230:20330519,20193081:papier:4230:20331009,20193083:papier:4230:20467292,20193085:papier:4230:20331315,20193775:papier:4230:20193948,20194486:papier:4230:20194602,20228800:papier:4230:20355892,20228803:papier:4230:20356024,20228806:papier:4230:20356108,20228809:papier:4230:20356257,20228812:papier:4230:20356481,20228815:papier:4230:20356670,20228818:papier:4230:20356858,20228821:papier:4230:20357103,20228824:papier:4230:20357286,20228827:papier:4230:20427529,2022'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004609362310036943, 'nb_photo': 2337, 'list_port_cont': '20128102,20192770,20194609,20232096,20232461,20232987,20233824,20233939,20273474,20276675,20277005,20282145,20284645,20286313,20288053,20291247,20295421,20296044,20296607,20297130,20297776,20303336,20308665,20313267,20313986,20324117,20324495,20325325,20326493,20327363,20328384,20329549,20329794,20330516,20331005,20331317,20351040,20352974,20353199,20353507,20354653,20355882,20356025,20356107,20356256,20356482,20356667,20356842,20356880,20357047,20357097,20357293,20357649,20358161,20358330,20358529,20358571,20359892,20360431,20361618,20361706,20365786,20367268,20368012,20371697,20372283,20372860,20373187,20373475,20373669,20374008,20374045,20374200,20374332,20374363,20374408,20374448,20374489,20374525,20374561,20374605,20374747,20374820,20374905,20374952,20375034,20375171,20375259,20375354,20375447,20375473,20375554,20375700,20375776,20375806,20375900,20376015,20376064,20376213,20376329,20376441,20376555,20376791,20376869,20376910,20377378,20378179,20378417,20378456,20378677,20379313,20381809,20381848,2038242', 'assoc_port': '20127879:20128102,20192481:20192770,20193047:20324117,20193049:20324495,20193053:20325325,20193055:20410457,20193059:20326493,20193061:20466863,20193063:20327363,20193067:20412942,20193069:20328384,20193071:20413050,20193073:20329549,20193075:20329794,20193077:20465060,20193079:20330516,20193081:20331005,20193083:20467302,20193085:20331317,20194486:20194609,20228800:20355882,20228803:20356025,20228806:20356107,20228809:20356256,20228812:20356482,20228815:20356667,20228818:20356842,20228821:20357097,20228824:20357293,20228827:20427511,20228830:20357649,20228833:20427219,20228836:20428978,20228839:20429422,20228842:20358161,20228845:20358330,20228848:20233939,20228851:20358529,20228854:20233824,20228859:20232461,20231320:20232096,20232597:20232987,20271402:20273474,20273922:20374408,20273924:20374489,20273927:20374448,20273931:20374561,20273934:20374605,20273936:20374747,20273940:20374820,20273942:20374952,20273944:20375034,20273947:20375171,20273949:20403911,20273951:20375554,20273953:20375700,20273955:2037577', 'assoc_mat': '20127879:pehd:4230:20128102,20192481:pehd:4230:20192770,20193047:pehd:4230:20324117,20193049:pehd:4230:20324495,20193053:pehd:4230:20325325,20193055:pehd:4230:20410457,20193059:pehd:4230:20326493,20193061:pehd:4230:20466863,20193063:pehd:4230:20327363,20193067:pehd:4230:20412942,20193069:pehd:4230:20328384,20193071:pehd:4230:20413050,20193073:pehd:4230:20329549,20193075:pehd:4230:20329794,20193077:pehd:4230:20465060,20193079:pehd:4230:20330516,20193081:pehd:4230:20331005,20193083:pehd:4230:20467302,20193085:pehd:4230:20331317,20194486:pehd:4230:20194609,20228800:pehd:4230:20355882,20228803:pehd:4230:20356025,20228806:pehd:4230:20356107,20228809:pehd:4230:20356256,20228812:pehd:4230:20356482,20228815:pehd:4230:20356667,20228818:pehd:4230:20356842,20228821:pehd:4230:20357097,20228824:pehd:4230:20357293,20228827:pehd:4230:20427511,20228830:pehd:4230:20357649,20228833:pehd:4230:20427219,20228836:pehd:4230:20428978,20228839:pehd:4230:20429422,20228842:pehd:4230:20358161,20228845:pehd:4230:20358330,20228848:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012508284153111568, 'nb_photo': 19842, 'list_port_cont': '20128099,20192760,20193947,20194599,20230464,20232106,20232453,20232980,20233825,20233943,20273483,20276665,20277007,20282152,20284641,20286310,20288046,20291243,20295432,20296047,20296611,20297129,20297768,20303340,20305713,20308663,20313275,20313981,20323663,20324125,20324491,20324925,20325324,20326077,20326505,20327362,20328392,20329551,20329798,20330510,20331015,20331312,20351038,20352971,20353191,20353516,20353794,20354652,20355884,20356031,20356098,20356266,20356469,20356553,20356662,20356855,20356886,20357050,20357112,20357291,20357646,20358164,20358326,20358530,20358575,20359900,20360429,20361617,20361708,20365790,20367270,20368003,20371701,20372290,20372864,20372945,20373190,20373398,20373470,20373670,20374005,20374040,20374198,20374324,20374364,20374412,20374444,20374490,20374523,20374558,20374607,20374712,20374748,20374829,20374898,20374951,20375027,20375107,20375180,20375257,20375346,20375443,20375478,20375556,20375702,20375745,20375777,20375816,20375892,20376018,20376065,20376137,20376207,2037633', 'assoc_port': '20127879:20128099,20192481:20192760,20193045:20323663,20193047:20324125,20193049:20324491,20193051:20324925,20193053:20325324,20193055:20410459,20193057:20326077,20193059:20326505,20193061:20466858,20193063:20327362,20193067:20412952,20193069:20328392,20193071:20413039,20193073:20329551,20193075:20329798,20193077:20465061,20193079:20330510,20193081:20331015,20193083:20467298,20193085:20331312,20193775:20193947,20194486:20194599,20228800:20355884,20228803:20356031,20228806:20356098,20228809:20356266,20228812:20356469,20228815:20356662,20228818:20356855,20228821:20357112,20228824:20357291,20228827:20427530,20228830:20357646,20228833:20427212,20228836:20428972,20228839:20429418,20228842:20358164,20228845:20358326,20228848:20233943,20228851:20358530,20228854:20233825,20228857:20230464,20228859:20232453,20231320:20232106,20232597:20232980,20271402:20273483,20273922:20374412,20273924:20374490,20273927:20374444,20273931:20374558,20273934:20374607,20273936:20374748,20273940:20374829,20273942:20374951,20273944:2037502', 'assoc_mat': '20127879:pet_clair:4230:20128099,20192481:pet_clair:4230:20192760,20193045:pet_clair:4230:20323663,20193047:pet_clair:4230:20324125,20193049:pet_clair:4230:20324491,20193051:pet_clair:4230:20324925,20193053:pet_clair:4230:20325324,20193055:pet_clair:4230:20410459,20193057:pet_clair:4230:20326077,20193059:pet_clair:4230:20326505,20193061:pet_clair:4230:20466858,20193063:pet_clair:4230:20327362,20193067:pet_clair:4230:20412952,20193069:pet_clair:4230:20328392,20193071:pet_clair:4230:20413039,20193073:pet_clair:4230:20329551,20193075:pet_clair:4230:20329798,20193077:pet_clair:4230:20465061,20193079:pet_clair:4230:20330510,20193081:pet_clair:4230:20331015,20193083:pet_clair:4230:20467298,20193085:pet_clair:4230:20331312,20193775:pet_clair:4230:20193947,20194486:pet_clair:4230:20194599,20228800:pet_clair:4230:20355884,20228803:pet_clair:4230:20356031,20228806:pet_clair:4230:20356098,20228809:pet_clair:4230:20356266,20228812:pet_clair:4230:20356469,20228815:pet_clair:4230:20356662,20228818:pet_clair:4230:20356855,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0030209009771813107, 'nb_photo': 1036, 'list_port_cont': '20232107,20232458,20232984,20233940,20273476,20276674,20282151,20286311,20291241,20295427,20296040,20296606,20297121,20297771,20305728,20313274,20313987,20324494,20324930,20326075,20327351,20329561,20329791,20330513,20331007,20331318,20351042,20353514,20355895,20356021,20356101,20356478,20356671,20356856,20356891,20357054,20357107,20357294,20357650,20358159,20358328,20358538,20359899,20360432,20361610,20361712,20365791,20367262,20373195,20373661,20374011,20374038,20374192,20374317,20374367,20374409,20374487,20374517,20374601,20374708,20374740,20374826,20374907,20374941,20375032,20375100,20375182,20375355,20375480,20375549,20375706,20375735,20375778,20375897,20376007,20376062,20376133,20376215,20376317,20376366,20376446,20376473,20376789,20376862,20376902,20377371,20378180,20379322,20379765,20380298,20381804,20381845,20382418,20383632,20384068,20384115,20384752,20385672,20386279,20386785,20387460,20389154,20392108,20393942,20403919,20410451,20412943,20413043,20423381,20427215,20427528,20428973,20429429,2043608', 'assoc_port': '20193049:20324494,20193051:20324930,20193055:20410451,20193057:20326075,20193061:20466857,20193063:20327351,20193067:20412943,20193071:20413043,20193073:20329561,20193075:20329791,20193077:20465063,20193079:20330513,20193081:20331007,20193083:20467299,20193085:20331318,20228800:20355895,20228803:20356021,20228806:20356101,20228812:20356478,20228815:20356671,20228818:20356856,20228821:20357107,20228824:20357294,20228827:20427528,20228830:20357650,20228833:20427215,20228836:20428973,20228839:20429429,20228842:20358159,20228845:20358328,20228848:20233940,20228851:20358538,20228859:20232458,20231320:20232107,20232597:20232984,20271402:20273476,20273922:20374409,20273924:20374487,20273934:20374601,20273936:20374740,20273940:20374826,20273942:20374941,20273944:20375032,20273947:20375182,20273949:20403919,20273951:20375549,20273953:20375706,20273955:20375778,20273958:20376007,20273960:20376062,20273962:20376215,20273965:20376317,20273967:20376446,20275732:20276674,20280538:20282151,20285862:20286311,20290078:2029124', 'assoc_mat': '20193049:pet_fonce:4230:20324494,20193051:pet_fonce:4230:20324930,20193055:pet_fonce:4230:20410451,20193057:pet_fonce:4230:20326075,20193061:pet_fonce:4230:20466857,20193063:pet_fonce:4230:20327351,20193067:pet_fonce:4230:20412943,20193071:pet_fonce:4230:20413043,20193073:pet_fonce:4230:20329561,20193075:pet_fonce:4230:20329791,20193077:pet_fonce:4230:20465063,20193079:pet_fonce:4230:20330513,20193081:pet_fonce:4230:20331007,20193083:pet_fonce:4230:20467299,20193085:pet_fonce:4230:20331318,20228800:pet_fonce:4230:20355895,20228803:pet_fonce:4230:20356021,20228806:pet_fonce:4230:20356101,20228812:pet_fonce:4230:20356478,20228815:pet_fonce:4230:20356671,20228818:pet_fonce:4230:20356856,20228821:pet_fonce:4230:20357107,20228824:pet_fonce:4230:20357294,20228827:pet_fonce:4230:20427528,20228830:pet_fonce:4230:20357650,20228833:pet_fonce:4230:20427215,20228836:pet_fonce:4230:20428973,20228839:pet_fonce:4230:20429429,20228842:pet_fonce:4230:20358159,20228845:pet_fonce:4230:20358328,20228848:pet_fonce:4230:20233940,2'}), 'main_stat': {'nb_photos': 1572}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-02', 0.7320993535199398),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam6"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4849 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4849 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4849 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4849 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1572,),), 'unwanted_material_monthly_percentage': ((0.7320993535199398,),), 'material_repartition': (('incineration', 1568),), 'material_dict': {'incineration': 1568}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 2, 1), 0.639796489695635, 2), (datetime.date(2025, 2, 3), 0.7179800713363391, 64), (datetime.date(2025, 2, 4), 0.6791098195155767, 61), (datetime.date(2025, 2, 5), 0.611956752372915, 59), (datetime.date(2025, 2, 6), 0.634549933382178, 50), (datetime.date(2025, 2, 7), 0.645287307741859, 62), (datetime.date(2025, 2, 8), 0.6361338406076353, 58), (datetime.date(2025, 2, 9), 0.7886356893350345, 57), (datetime.date(2025, 2, 10), 0.7579797538999417, 62), (datetime.date(2025, 2, 11), 0.725960754775183, 53), (datetime.date(2025, 2, 12), 0.733377504693801, 59), (datetime.date(2025, 2, 13), 0.712661446219421, 41), (datetime.date(2025, 2, 14), 0.7087412725808143, 59), (datetime.date(2025, 2, 15), 0.7262658024680494, 56), (datetime.date(2025, 2, 16), 0.8257493102222028, 68), (datetime.date(2025, 2, 17), 0.7997304447561294, 75), (datetime.date(2025, 2, 18), 0.7602080606377686, 83), (datetime.date(2025, 2, 19), 0.7290590660540694, 60), (datetime.date(2025, 2, 20), 0.7251857936927993, 33), (datetime.date(2025, 2, 21), 0.6664993273247276, 67), (datetime.date(2025, 2, 22), 0.7603367660554508, 59), (datetime.date(2025, 2, 23), 0.8302368969842344, 64), (datetime.date(2025, 2, 24), 0.7911464901722244, 60), (datetime.date(2025, 2, 25), 0.7788749219787405, 60), (datetime.date(2025, 2, 26), 0.7634818040892617, 70), (datetime.date(2025, 2, 27), 0.7352419258287971, 60), (datetime.date(2025, 2, 28), 0.6930278774280286, 66)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 2, 1), 0.639796489695635, 2), (datetime.date(2025, 2, 3), 0.7179800713363391, 64), (datetime.date(2025, 2, 4), 0.6791098195155767, 61), (datetime.date(2025, 2, 5), 0.611956752372915, 59), (datetime.date(2025, 2, 6), 0.634549933382178, 50), (datetime.date(2025, 2, 7), 0.645287307741859, 62), (datetime.date(2025, 2, 8), 0.6361338406076353, 58), (datetime.date(2025, 2, 9), 0.7886356893350345, 57), (datetime.date(2025, 2, 10), 0.7579797538999417, 62), (datetime.date(2025, 2, 11), 0.725960754775183, 53), (datetime.date(2025, 2, 12), 0.733377504693801, 59), (datetime.date(2025, 2, 13), 0.712661446219421, 41), (datetime.date(2025, 2, 14), 0.7087412725808143, 59), (datetime.date(2025, 2, 15), 0.7262658024680494, 56), (datetime.date(2025, 2, 16), 0.8257493102222028, 68), (datetime.date(2025, 2, 17), 0.7997304447561294, 75), (datetime.date(2025, 2, 18), 0.7602080606377686, 83), (datetime.date(2025, 2, 19), 0.7290590660540694, 60), (datetime.date(2025, 2, 20), 0.7251857936927993, 33), (datetime.date(2025, 2, 21), 0.6664993273247276, 67), (datetime.date(2025, 2, 22), 0.7603367660554508, 59), (datetime.date(2025, 2, 23), 0.8302368969842344, 64), (datetime.date(2025, 2, 24), 0.7911464901722244, 60), (datetime.date(2025, 2, 25), 0.7788749219787405, 60), (datetime.date(2025, 2, 26), 0.7634818040892617, 70), (datetime.date(2025, 2, 27), 0.7352419258287971, 60), (datetime.date(2025, 2, 28), 0.6930278774280286, 66))}, 'quality_array': [['-9.006186806949506', '01022025'], ['-8.159863910001178', '03022025'], ['-8.42902320122383', '04022025'], ['-8.787364948271424', '05022025'], ['-8.729590049449945', '06022025'], ['-8.838209647096626', '07022025'], ['-8.500721166917314', '08022025'], ['-8.419879460728701', '09022025'], ['-7.9407277315734195', '10022025'], ['-8.18382414255681', '11022025'], ['-8.148720776646137', '12022025'], ['-8.210083352016323', '13022025'], ['-8.526722698423592', '14022025'], ['-8.464280515345745', '15022025'], ['-8.107807541105583', '16022025'], ['-7.855559022737543', '17022025'], ['-7.777536721526704', '18022025'], ['-7.800002490996505', '19022025'], ['-8.197627807177149', '20022025'], ['-8.036578190060652', '21022025'], ['-8.122816762222927', '22022025'], ['-7.943081879679887', '23022025'], ['-7.398649394571681', '24022025'], ['-7.678291660098507', '25022025'], ['-8.133913624196616', '26022025'], ['-8.120935577619385', '27022025'], ['-8.268214235893623', '28022025']], 'number_of_batch': ((584,),), 'datou_id_sts': 4849, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.015993588253880645, 'nb_photo': 16683, 'list_port_cont': '20128105,20192759,20193932,20194601,20230455,20232095,20232457,20232982,20233808,20233929,20273472,20276678,20276998,20282157,20284651,20286304,20288054,20291248,20295423,20296043,20296614,20297134,20297775,20303325,20305727,20308660,20313269,20313976,20323657,20324111,20324496,20324912,20325318,20326066,20326490,20327354,20328391,20329560,20329800,20330517,20331002,20331316,20351031,20352973,20353186,20353505,20353801,20354656,20355879,20356017,20356099,20356265,20356473,20356554,20356666,20356846,20356882,20357049,20357105,20357288,20357645,20358148,20358317,20358527,20358574,20359886,20360424,20361604,20361697,20365789,20367260,20368009,20371699,20372278,20372856,20372942,20373184,20373391,20373474,20373653,20374004,20374034,20374191,20374325,20374371,20374400,20374440,20374476,20374526,20374556,20374606,20374705,20374743,20374830,20374906,20374935,20375017,20375105,20375183,20375260,20375352,20375440,20375482,20375545,20375698,20375737,20375780,20375808,20375899,20376020,20376054,20376128,20376200,2037631', 'assoc_port': '20127879:20128105,20192481:20192759,20193045:20323657,20193047:20324111,20193049:20324496,20193051:20324912,20193053:20325318,20193055:20410458,20193057:20326066,20193059:20326490,20193061:20466847,20193063:20327354,20193067:20412951,20193069:20328391,20193071:20413048,20193073:20329560,20193075:20329800,20193077:20465062,20193079:20330517,20193081:20331002,20193083:20467289,20193085:20331316,20193775:20193932,20194486:20194601,20228800:20355879,20228803:20356017,20228806:20356099,20228809:20356265,20228812:20356473,20228815:20356666,20228818:20356846,20228821:20357105,20228824:20357288,20228827:20427525,20228830:20357645,20228833:20427214,20228836:20428969,20228839:20429419,20228842:20358148,20228845:20358317,20228848:20233929,20228851:20358527,20228854:20233808,20228857:20230455,20228859:20232457,20231320:20232095,20232597:20232982,20271402:20273472,20273922:20374400,20273924:20374476,20273927:20374440,20273931:20374556,20273934:20374606,20273936:20374743,20273940:20374830,20273942:20374935,20273944:2037501', 'assoc_mat': '20127879:autre:4230:20128105,20192481:autre:4230:20192759,20193045:autre:4230:20323657,20193047:autre:4230:20324111,20193049:autre:4230:20324496,20193051:autre:4230:20324912,20193053:autre:4230:20325318,20193055:autre:4230:20410458,20193057:autre:4230:20326066,20193059:autre:4230:20326490,20193061:autre:4230:20466847,20193063:autre:4230:20327354,20193067:autre:4230:20412951,20193069:autre:4230:20328391,20193071:autre:4230:20413048,20193073:autre:4230:20329560,20193075:autre:4230:20329800,20193077:autre:4230:20465062,20193079:autre:4230:20330517,20193081:autre:4230:20331002,20193083:autre:4230:20467289,20193085:autre:4230:20331316,20193775:autre:4230:20193932,20194486:autre:4230:20194601,20228800:autre:4230:20355879,20228803:autre:4230:20356017,20228806:autre:4230:20356099,20228809:autre:4230:20356265,20228812:autre:4230:20356473,20228815:autre:4230:20356666,20228818:autre:4230:20356846,20228821:autre:4230:20357105,20228824:autre:4230:20357288,20228827:autre:4230:20427525,20228830:autre:4230:20357645,20228833:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.05283384822941771, 'nb_photo': 79127, 'list_port_cont': '20128101,20192768,20193943,20194607,20230469,20232110,20232451,20232985,20233818,20233938,20273479,20276673,20277004,20277062,20282155,20284647,20286315,20288050,20291244,20295430,20296046,20296613,20297125,20297762,20303341,20305721,20308658,20313266,20313983,20323662,20324122,20324490,20324923,20325317,20326070,20326498,20327349,20328390,20329558,20329787,20330514,20331014,20331323,20351043,20352961,20353202,20353515,20353802,20354657,20355891,20356032,20356105,20356260,20356480,20356543,20356660,20356854,20356889,20357060,20357109,20357289,20357653,20358155,20358318,20358536,20358567,20359895,20360438,20361615,20361710,20365787,20367271,20368006,20371690,20372285,20372859,20372947,20373189,20373401,20373476,20373668,20374010,20374042,20374199,20374330,20374366,20374410,20374456,20374479,20374524,20374565,20374592,20374713,20374744,20374824,20374900,20374943,20375023,20375104,20375178,20375261,20375345,20375445,20375483,20375550,20375701,20375743,20375781,20375813,20375895,20376017,20376060,20376127,2037621', 'assoc_port': '20127879:20128101,20192481:20192768,20193045:20323662,20193047:20324122,20193049:20324490,20193051:20324923,20193053:20325317,20193055:20410460,20193057:20326070,20193059:20326498,20193061:20466855,20193063:20327349,20193067:20412945,20193069:20328390,20193071:20413051,20193073:20329558,20193075:20329787,20193077:20465056,20193079:20330514,20193081:20331014,20193083:20467301,20193085:20331323,20193775:20193943,20194486:20194607,20228800:20355891,20228803:20356032,20228806:20356105,20228809:20356260,20228812:20356480,20228815:20356660,20228818:20356854,20228821:20357109,20228824:20357289,20228827:20427532,20228830:20357653,20228833:20427221,20228836:20428974,20228839:20429423,20228842:20358155,20228845:20358318,20228848:20233938,20228851:20358536,20228854:20233818,20228857:20230469,20228859:20232451,20231320:20232110,20232597:20232985,20271402:20273479,20273173:20277062,20273922:20374410,20273924:20374479,20273927:20374456,20273931:20374565,20273934:20374592,20273936:20374744,20273940:20374824,20273942:2037494', 'assoc_mat': '20127879:carton:4230:20128101,20192481:carton:4230:20192768,20193045:carton:4230:20323662,20193047:carton:4230:20324122,20193049:carton:4230:20324490,20193051:carton:4230:20324923,20193053:carton:4230:20325317,20193055:carton:4230:20410460,20193057:carton:4230:20326070,20193059:carton:4230:20326498,20193061:carton:4230:20466855,20193063:carton:4230:20327349,20193067:carton:4230:20412945,20193069:carton:4230:20328390,20193071:carton:4230:20413051,20193073:carton:4230:20329558,20193075:carton:4230:20329787,20193077:carton:4230:20465056,20193079:carton:4230:20330514,20193081:carton:4230:20331014,20193083:carton:4230:20467301,20193085:carton:4230:20331323,20193775:carton:4230:20193943,20194486:carton:4230:20194607,20228800:carton:4230:20355891,20228803:carton:4230:20356032,20228806:carton:4230:20356105,20228809:carton:4230:20356260,20228812:carton:4230:20356480,20228815:carton:4230:20356660,20228818:carton:4230:20356854,20228821:carton:4230:20357109,20228824:carton:4230:20357289,20228827:carton:4230:20427532,2022'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0011324049272418975, 'nb_photo': 1392, 'list_port_cont': '20128104,20192756,20194610,20230472,20232093,20232459,20232976,20233820,20233942,20273481,20277008,20282156,20284639,20286300,20288043,20291235,20295416,20296033,20296600,20297133,20297764,20303339,20308659,20313273,20313985,20324127,20324927,20326503,20327358,20329555,20329788,20330508,20331004,20351026,20352959,20353193,20353517,20353797,20354662,20356019,20356096,20356474,20356556,20356669,20356852,20356881,20357051,20357106,20357277,20357647,20358163,20358325,20358537,20358563,20359885,20360437,20361605,20361707,20367266,20367998,20372869,20372936,20373181,20373473,20373996,20374201,20374354,20374414,20374453,20374483,20374522,20374595,20374707,20374753,20374818,20374908,20374940,20375025,20375108,20375340,20375435,20375467,20375551,20375708,20375730,20375764,20375811,20375886,20376003,20376058,20376204,20376330,20376362,20376430,20376467,20376559,20376792,20376852,20376906,20378414,20378440,20378668,20379777,20380281,20381810,20381832,20383618,20383895,20383927,20384065,20384110,20384679,20385669,2038628', 'assoc_port': '20127879:20128104,20192481:20192756,20193047:20324127,20193051:20324927,20193059:20326503,20193061:20466853,20193063:20327358,20193067:20412946,20193071:20413045,20193073:20329555,20193075:20329788,20193077:20465057,20193079:20330508,20193081:20331004,20193083:20467293,20194486:20194610,20228803:20356019,20228806:20356096,20228812:20356474,20228815:20356669,20228818:20356852,20228821:20357106,20228824:20357277,20228827:20427507,20228830:20357647,20228833:20427218,20228836:20428966,20228839:20429425,20228842:20358163,20228845:20358325,20228848:20233942,20228851:20358537,20228854:20233820,20228857:20230472,20228859:20232459,20231320:20232093,20232597:20232976,20271402:20273481,20273922:20374414,20273924:20374483,20273927:20374453,20273934:20374595,20273936:20374753,20273940:20374818,20273942:20374940,20273944:20375025,20273949:20403906,20273951:20375551,20273953:20375708,20273955:20375764,20273958:20376003,20273960:20376058,20273962:20376204,20273965:20376330,20273967:20376430,20273970:20376559,20276893:2027700', 'assoc_mat': '20127879:metal:4230:20128104,20192481:metal:4230:20192756,20193047:metal:4230:20324127,20193051:metal:4230:20324927,20193059:metal:4230:20326503,20193061:metal:4230:20466853,20193063:metal:4230:20327358,20193067:metal:4230:20412946,20193071:metal:4230:20413045,20193073:metal:4230:20329555,20193075:metal:4230:20329788,20193077:metal:4230:20465057,20193079:metal:4230:20330508,20193081:metal:4230:20331004,20193083:metal:4230:20467293,20194486:metal:4230:20194610,20228803:metal:4230:20356019,20228806:metal:4230:20356096,20228812:metal:4230:20356474,20228815:metal:4230:20356669,20228818:metal:4230:20356852,20228821:metal:4230:20357106,20228824:metal:4230:20357277,20228827:metal:4230:20427507,20228830:metal:4230:20357647,20228833:metal:4230:20427218,20228836:metal:4230:20428966,20228839:metal:4230:20429425,20228842:metal:4230:20358163,20228845:metal:4230:20358325,20228848:metal:4230:20233942,20228851:metal:4230:20358537,20228854:metal:4230:20233820,20228857:metal:4230:20230472,20228859:metal:4230:20232459,20231320:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.20757355730597613, 'nb_photo': 364780, 'list_port_cont': '20128098,20192766,20193948,20194602,20230462,20232108,20232466,20232975,20233823,20233933,20273484,20276676,20277003,20277054,20282146,20284648,20286314,20288052,20291237,20295433,20296041,20296608,20297122,20297770,20303335,20305723,20308653,20313276,20313990,20323652,20324123,20324498,20324926,20325319,20326073,20326502,20327361,20328388,20329557,20329799,20330519,20331009,20331315,20351030,20352968,20353192,20353510,20353800,20354663,20355892,20356024,20356108,20356257,20356481,20356550,20356670,20356858,20356892,20357055,20357103,20357286,20357651,20358160,20358322,20358535,20358569,20359898,20360428,20361616,20361703,20365795,20367265,20368008,20371700,20372286,20372868,20372941,20373186,20373393,20373467,20373663,20374007,20374044,20374202,20374319,20374368,20374415,20374454,20374492,20374530,20374550,20374603,20374710,20374750,20374828,20374910,20374947,20375024,20375095,20375176,20375256,20375356,20375446,20375481,20375557,20375705,20375741,20375774,20375820,20375898,20376019,20376056,20376140,2037620', 'assoc_port': '20127879:20128098,20192481:20192766,20193045:20323652,20193047:20324123,20193049:20324498,20193051:20324926,20193053:20325319,20193055:20410461,20193057:20326073,20193059:20326502,20193061:20466860,20193063:20327361,20193067:20412950,20193069:20328388,20193071:20413049,20193073:20329557,20193075:20329799,20193077:20465064,20193079:20330519,20193081:20331009,20193083:20467292,20193085:20331315,20193775:20193948,20194486:20194602,20228800:20355892,20228803:20356024,20228806:20356108,20228809:20356257,20228812:20356481,20228815:20356670,20228818:20356858,20228821:20357103,20228824:20357286,20228827:20427529,20228830:20357651,20228833:20427213,20228836:20428975,20228839:20429427,20228842:20358160,20228845:20358322,20228848:20233933,20228851:20358535,20228854:20233823,20228857:20230462,20228859:20232466,20231320:20232108,20232597:20232975,20271402:20273484,20273173:20277054,20273922:20374415,20273924:20374492,20273927:20374454,20273931:20374550,20273934:20374603,20273936:20374750,20273940:20374828,20273942:2037494', 'assoc_mat': '20127879:papier:4230:20128098,20192481:papier:4230:20192766,20193045:papier:4230:20323652,20193047:papier:4230:20324123,20193049:papier:4230:20324498,20193051:papier:4230:20324926,20193053:papier:4230:20325319,20193055:papier:4230:20410461,20193057:papier:4230:20326073,20193059:papier:4230:20326502,20193061:papier:4230:20466860,20193063:papier:4230:20327361,20193067:papier:4230:20412950,20193069:papier:4230:20328388,20193071:papier:4230:20413049,20193073:papier:4230:20329557,20193075:papier:4230:20329799,20193077:papier:4230:20465064,20193079:papier:4230:20330519,20193081:papier:4230:20331009,20193083:papier:4230:20467292,20193085:papier:4230:20331315,20193775:papier:4230:20193948,20194486:papier:4230:20194602,20228800:papier:4230:20355892,20228803:papier:4230:20356024,20228806:papier:4230:20356108,20228809:papier:4230:20356257,20228812:papier:4230:20356481,20228815:papier:4230:20356670,20228818:papier:4230:20356858,20228821:papier:4230:20357103,20228824:papier:4230:20357286,20228827:papier:4230:20427529,2022'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.004609362310036943, 'nb_photo': 2337, 'list_port_cont': '20128102,20192770,20194609,20232096,20232461,20232987,20233824,20233939,20273474,20276675,20277005,20282145,20284645,20286313,20288053,20291247,20295421,20296044,20296607,20297130,20297776,20303336,20308665,20313267,20313986,20324117,20324495,20325325,20326493,20327363,20328384,20329549,20329794,20330516,20331005,20331317,20351040,20352974,20353199,20353507,20354653,20355882,20356025,20356107,20356256,20356482,20356667,20356842,20356880,20357047,20357097,20357293,20357649,20358161,20358330,20358529,20358571,20359892,20360431,20361618,20361706,20365786,20367268,20368012,20371697,20372283,20372860,20373187,20373475,20373669,20374008,20374045,20374200,20374332,20374363,20374408,20374448,20374489,20374525,20374561,20374605,20374747,20374820,20374905,20374952,20375034,20375171,20375259,20375354,20375447,20375473,20375554,20375700,20375776,20375806,20375900,20376015,20376064,20376213,20376329,20376441,20376555,20376791,20376869,20376910,20377378,20378179,20378417,20378456,20378677,20379313,20381809,20381848,2038242', 'assoc_port': '20127879:20128102,20192481:20192770,20193047:20324117,20193049:20324495,20193053:20325325,20193055:20410457,20193059:20326493,20193061:20466863,20193063:20327363,20193067:20412942,20193069:20328384,20193071:20413050,20193073:20329549,20193075:20329794,20193077:20465060,20193079:20330516,20193081:20331005,20193083:20467302,20193085:20331317,20194486:20194609,20228800:20355882,20228803:20356025,20228806:20356107,20228809:20356256,20228812:20356482,20228815:20356667,20228818:20356842,20228821:20357097,20228824:20357293,20228827:20427511,20228830:20357649,20228833:20427219,20228836:20428978,20228839:20429422,20228842:20358161,20228845:20358330,20228848:20233939,20228851:20358529,20228854:20233824,20228859:20232461,20231320:20232096,20232597:20232987,20271402:20273474,20273922:20374408,20273924:20374489,20273927:20374448,20273931:20374561,20273934:20374605,20273936:20374747,20273940:20374820,20273942:20374952,20273944:20375034,20273947:20375171,20273949:20403911,20273951:20375554,20273953:20375700,20273955:2037577', 'assoc_mat': '20127879:pehd:4230:20128102,20192481:pehd:4230:20192770,20193047:pehd:4230:20324117,20193049:pehd:4230:20324495,20193053:pehd:4230:20325325,20193055:pehd:4230:20410457,20193059:pehd:4230:20326493,20193061:pehd:4230:20466863,20193063:pehd:4230:20327363,20193067:pehd:4230:20412942,20193069:pehd:4230:20328384,20193071:pehd:4230:20413050,20193073:pehd:4230:20329549,20193075:pehd:4230:20329794,20193077:pehd:4230:20465060,20193079:pehd:4230:20330516,20193081:pehd:4230:20331005,20193083:pehd:4230:20467302,20193085:pehd:4230:20331317,20194486:pehd:4230:20194609,20228800:pehd:4230:20355882,20228803:pehd:4230:20356025,20228806:pehd:4230:20356107,20228809:pehd:4230:20356256,20228812:pehd:4230:20356482,20228815:pehd:4230:20356667,20228818:pehd:4230:20356842,20228821:pehd:4230:20357097,20228824:pehd:4230:20357293,20228827:pehd:4230:20427511,20228830:pehd:4230:20357649,20228833:pehd:4230:20427219,20228836:pehd:4230:20428978,20228839:pehd:4230:20429422,20228842:pehd:4230:20358161,20228845:pehd:4230:20358330,20228848:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012508284153111568, 'nb_photo': 19842, 'list_port_cont': '20128099,20192760,20193947,20194599,20230464,20232106,20232453,20232980,20233825,20233943,20273483,20276665,20277007,20282152,20284641,20286310,20288046,20291243,20295432,20296047,20296611,20297129,20297768,20303340,20305713,20308663,20313275,20313981,20323663,20324125,20324491,20324925,20325324,20326077,20326505,20327362,20328392,20329551,20329798,20330510,20331015,20331312,20351038,20352971,20353191,20353516,20353794,20354652,20355884,20356031,20356098,20356266,20356469,20356553,20356662,20356855,20356886,20357050,20357112,20357291,20357646,20358164,20358326,20358530,20358575,20359900,20360429,20361617,20361708,20365790,20367270,20368003,20371701,20372290,20372864,20372945,20373190,20373398,20373470,20373670,20374005,20374040,20374198,20374324,20374364,20374412,20374444,20374490,20374523,20374558,20374607,20374712,20374748,20374829,20374898,20374951,20375027,20375107,20375180,20375257,20375346,20375443,20375478,20375556,20375702,20375745,20375777,20375816,20375892,20376018,20376065,20376137,20376207,2037633', 'assoc_port': '20127879:20128099,20192481:20192760,20193045:20323663,20193047:20324125,20193049:20324491,20193051:20324925,20193053:20325324,20193055:20410459,20193057:20326077,20193059:20326505,20193061:20466858,20193063:20327362,20193067:20412952,20193069:20328392,20193071:20413039,20193073:20329551,20193075:20329798,20193077:20465061,20193079:20330510,20193081:20331015,20193083:20467298,20193085:20331312,20193775:20193947,20194486:20194599,20228800:20355884,20228803:20356031,20228806:20356098,20228809:20356266,20228812:20356469,20228815:20356662,20228818:20356855,20228821:20357112,20228824:20357291,20228827:20427530,20228830:20357646,20228833:20427212,20228836:20428972,20228839:20429418,20228842:20358164,20228845:20358326,20228848:20233943,20228851:20358530,20228854:20233825,20228857:20230464,20228859:20232453,20231320:20232106,20232597:20232980,20271402:20273483,20273922:20374412,20273924:20374490,20273927:20374444,20273931:20374558,20273934:20374607,20273936:20374748,20273940:20374829,20273942:20374951,20273944:2037502', 'assoc_mat': '20127879:pet_clair:4230:20128099,20192481:pet_clair:4230:20192760,20193045:pet_clair:4230:20323663,20193047:pet_clair:4230:20324125,20193049:pet_clair:4230:20324491,20193051:pet_clair:4230:20324925,20193053:pet_clair:4230:20325324,20193055:pet_clair:4230:20410459,20193057:pet_clair:4230:20326077,20193059:pet_clair:4230:20326505,20193061:pet_clair:4230:20466858,20193063:pet_clair:4230:20327362,20193067:pet_clair:4230:20412952,20193069:pet_clair:4230:20328392,20193071:pet_clair:4230:20413039,20193073:pet_clair:4230:20329551,20193075:pet_clair:4230:20329798,20193077:pet_clair:4230:20465061,20193079:pet_clair:4230:20330510,20193081:pet_clair:4230:20331015,20193083:pet_clair:4230:20467298,20193085:pet_clair:4230:20331312,20193775:pet_clair:4230:20193947,20194486:pet_clair:4230:20194599,20228800:pet_clair:4230:20355884,20228803:pet_clair:4230:20356031,20228806:pet_clair:4230:20356098,20228809:pet_clair:4230:20356266,20228812:pet_clair:4230:20356469,20228815:pet_clair:4230:20356662,20228818:pet_clair:4230:20356855,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0030209009771813107, 'nb_photo': 1036, 'list_port_cont': '20232107,20232458,20232984,20233940,20273476,20276674,20282151,20286311,20291241,20295427,20296040,20296606,20297121,20297771,20305728,20313274,20313987,20324494,20324930,20326075,20327351,20329561,20329791,20330513,20331007,20331318,20351042,20353514,20355895,20356021,20356101,20356478,20356671,20356856,20356891,20357054,20357107,20357294,20357650,20358159,20358328,20358538,20359899,20360432,20361610,20361712,20365791,20367262,20373195,20373661,20374011,20374038,20374192,20374317,20374367,20374409,20374487,20374517,20374601,20374708,20374740,20374826,20374907,20374941,20375032,20375100,20375182,20375355,20375480,20375549,20375706,20375735,20375778,20375897,20376007,20376062,20376133,20376215,20376317,20376366,20376446,20376473,20376789,20376862,20376902,20377371,20378180,20379322,20379765,20380298,20381804,20381845,20382418,20383632,20384068,20384115,20384752,20385672,20386279,20386785,20387460,20389154,20392108,20393942,20403919,20410451,20412943,20413043,20423381,20427215,20427528,20428973,20429429,2043608', 'assoc_port': '20193049:20324494,20193051:20324930,20193055:20410451,20193057:20326075,20193061:20466857,20193063:20327351,20193067:20412943,20193071:20413043,20193073:20329561,20193075:20329791,20193077:20465063,20193079:20330513,20193081:20331007,20193083:20467299,20193085:20331318,20228800:20355895,20228803:20356021,20228806:20356101,20228812:20356478,20228815:20356671,20228818:20356856,20228821:20357107,20228824:20357294,20228827:20427528,20228830:20357650,20228833:20427215,20228836:20428973,20228839:20429429,20228842:20358159,20228845:20358328,20228848:20233940,20228851:20358538,20228859:20232458,20231320:20232107,20232597:20232984,20271402:20273476,20273922:20374409,20273924:20374487,20273934:20374601,20273936:20374740,20273940:20374826,20273942:20374941,20273944:20375032,20273947:20375182,20273949:20403919,20273951:20375549,20273953:20375706,20273955:20375778,20273958:20376007,20273960:20376062,20273962:20376215,20273965:20376317,20273967:20376446,20275732:20276674,20280538:20282151,20285862:20286311,20290078:2029124', 'assoc_mat': '20193049:pet_fonce:4230:20324494,20193051:pet_fonce:4230:20324930,20193055:pet_fonce:4230:20410451,20193057:pet_fonce:4230:20326075,20193061:pet_fonce:4230:20466857,20193063:pet_fonce:4230:20327351,20193067:pet_fonce:4230:20412943,20193071:pet_fonce:4230:20413043,20193073:pet_fonce:4230:20329561,20193075:pet_fonce:4230:20329791,20193077:pet_fonce:4230:20465063,20193079:pet_fonce:4230:20330513,20193081:pet_fonce:4230:20331007,20193083:pet_fonce:4230:20467299,20193085:pet_fonce:4230:20331318,20228800:pet_fonce:4230:20355895,20228803:pet_fonce:4230:20356021,20228806:pet_fonce:4230:20356101,20228812:pet_fonce:4230:20356478,20228815:pet_fonce:4230:20356671,20228818:pet_fonce:4230:20356856,20228821:pet_fonce:4230:20357107,20228824:pet_fonce:4230:20357294,20228827:pet_fonce:4230:20427528,20228830:pet_fonce:4230:20357650,20228833:pet_fonce:4230:20427215,20228836:pet_fonce:4230:20428973,20228839:pet_fonce:4230:20429429,20228842:pet_fonce:4230:20358159,20228845:pet_fonce:4230:20358328,20228848:pet_fonce:4230:20233940,2'}), 'main_stat': {'nb_photos': 1572}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-02', 0.7320993535199398),)]} filepath : /data_2/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_02_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.6%', 16683], 'carton': ['carton', '5.28%', 79127], 'metal': ['metal', '0.11%', 1392], 'papier': ['papier', '20.76%', 364780], 'pehd': ['pehd', '0.46%', 2337], 'pet_clair': ['pet_clair', '1.25%', 19842], 'pet_fonce': ['pet_fonce', '0.3%', 1036]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam6/sla_mensuel_SCCU_cam6_mois_02_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam6 2.83user 2.77system 0:25.37elapsed 22%CPU (0avgtext+0avgdata 194960maxresident)k 120096inputs+288outputs (501major+67063minor)pagefaults 0swaps