python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/memo/memo.py --dashboard_places=SCCU_cam8 -j sla_mensuel -v --date=`date -d"$nowdate 15 day ago" +%Y-%m` --rootfolder_sla=/data_2/data_log/job/memo/SCCU_cam8 ' -s sla_mensuel -M 0 -S 0 -U 90,80,95 import MySQLdb succeeded Import error (python version) Need env var : LOGRASPI Raspi : , Date : 2025-05 _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 : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier Fonction SLA_MENSUEL nb_day : (3, 31) TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier place_id : 203 month : 05 mtr_id : dashboard_places : SCCU_cam8 date : 2025-05 year : 2025 raspi : 0 select count(distinct mtr_photo_id) from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (select id from MTRUser.mtr_portfolios where id in (select mtr_portfolio_id from MTRPhoto.dashboard_results where dashboard_run_id in(select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id in (select id from MTRPhoto.dashboard_places where name = 'SCCU_cam8' and date like '%2025-05%') and created_at like '%2025-05%'))); nb_day : (3, 31) after unwanted_material_data We return tuple() but get_coverage_data_from_list_of_date return unexpectedly data from stuff in error with raspi=0 so we force here ! after coverage_data SELECT DATE(date_debut) as date, sum(qualite*nombre_balle)/sum(nombre_balle), 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 = 203 and month(ded.date) = 05 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 = 203 and month(ded.date) = 05 and year(ded.date) = 2025 and dr.dashboard_run_id=ded.last_run_id and dr.qualite>=0 GROUP BY ded.date order by dr.date_debut; select avg(cps.score) as score, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'__', -1), '_', 1) as sbstr, SUBSTRING_INDEX(SUBSTRING_INDEX(mp.name,'_', -2), '_', 1) as sbstr2, SUBSTRING_INDEX(mp.name,'_', -1) as sbstr3 FROM MTRUser.mtr_portfolio_photos mpp, MTRUser.mtr_portfolios mp,MTRPhoto.class_photo_score cps,MTRBack.hashtags h,MTRPhoto.dashboard_results dr,MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE mp.id=mpp.mtr_portfolio_id and cps.photo_id=mpp.mtr_photo_id and h.hashtag_id=cps.hashtag_id and dr.mtr_portfolio_id = mpp.mtr_portfolio_id and dr.dashboard_run_id = ded.last_run_id and ded.dashboard_place_id = dp.id and h.hashtag in ('blur', 'mean_blur', 'clear') and dp.id = 203 and mp.name like '%052025%' and cps.thcl = 1533 GROUP BY sbstr ; after number_of_batch date_start : 2025-05-01 : dt_date_just_month_year : 2025-05-01 00:00:00 : VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! VR TODO TOCHECK : due to this bug it shouldn't have being able to work, or maybe it was due to a change directory not done ! Error parsing crontab ! [Errno 2] No such file or directory: '' You better check your LOGRASPI env !!! after pl.get_datou_sts_from_crontab : verbose : True no sts found, try to find from database SELECT dri.id FROM MTRPhoto.dashboard_run_ids dri, MTRPhoto.dashboard_entry_day ded, MTRPhoto.dashboard_places dp WHERE dp.name= "SCCU_cam8" AND ded.dashboard_place_id=dp.id AND dri.dashboard_entry_day=ded.id AND dri.id=ded.last_run_id AND ded.date >= "2025-05-01" AND ded.date <= "2025-05-31" apple3 {'incineration': {'mat': 'incineration', 'pht': 4230, 'datou_carac_id': 4234, 'unwanted_material': [], 'hashtag_majoritaire_from_carac': 'refus'}} SELECT h.hashtag as unwanted_material, substr(dr.hashtag,8) as main_material, ptp.type as pht_type, sum(pcr.value*dr.nombre_balle)/sum(dr.nombre_balle) as ratio, count(distinct mpp.mtr_photo_id) as nb_photo, group_concat(distinct ptp.mtr_portfolio_id_2) as list_port_cont, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_port, group_concat(distinct concat(cast(ptp.mtr_portfolio_id_1 as char), ":", h.hashtag, ":", cast(ptp.type as char), ":", cast(ptp.mtr_portfolio_id_2 as char))) as assoc_mat FROM MTRPhoto.dashboard_results dr, MTRPhoto.mtr_port_to_port_ids ptp, MTRUser.mtr_portfolio_photos mpp, MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h WHERE dr.dashboard_run_id IN (1772807,1777128,1780226,1780583,1784619,1787887,1792958,1796273,1801060,1810366,1810317,1810419,1814882,1818776,1822890,1824121) 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.030516662769155083, 'nb_photo': 17229, 'list_port_cont': '22586426,22586453,22586535,22586562,22586610,22586643,22586743,22586928,22587009,22587040,22587064,22587103,22587179,22587268,22587288,22587402,22587426,22587474,22587539,22587799,22588056,22588154,22588204,22620669,22620805,22620967,22622815,22623218,22623358,22623470,22623487,22623623,22623717,22623887,22623928,22624126,22624245,22624298,22624335,22624484,22624772,22624969,22624992,22625183,22625349,22628624,22628879,22637000,22637726,22637804,22640183,22640306,22642407,22642631,22643477,22644128,22644682,22645856,22645903,22646380,22646940,22646993,22647348,22649145,22649251,22649280,22649321,22649368,22649428,22649462,22649631,22650472,22650740,22650842,22650971,22651108,22651345,22651459,22651588,22651810,22651867,22652145,22652186,22652326,22652555,22652584,22652828,22653294,22653779,22653800,22653858,22653895,22654739,22654821,22654866,22658413,22658528,22662241,22662402,22665371,22669171,22669403,22671906,22673897,22675670,22681719,22681873,22685101,22687353,22689878,22693139,22695876,22699247,2269945', 'assoc_port': '22586330:22588154,22586332:22588056,22586334:22587539,22586336:22587799,22586338:22587288,22586340:22587179,22586342:22587426,22586344:22587402,22586346:22587474,22586348:22587103,22586350:22587268,22586352:22587009,22586354:22587040,22586356:22587064,22586358:22586743,22586360:22586453,22586362:22586426,22586364:22586928,22586366:22586562,22586368:22586535,22586369:22586643,22586370:22586610,22587967:22588204,22620307:22620967,22620308:22620805,22620309:22620669,22622202:22625349,22622203:22625183,22622204:22624969,22622205:22624992,22622206:22624772,22622207:22624335,22622208:22624126,22622209:22624298,22622210:22624484,22622211:22623623,22622212:22623887,22622214:22623717,22622215:22624245,22622217:22623358,22622218:22623928,22622220:22623470,22622221:22623487,22622223:22622815,22622225:22623218,22628074:22628879,22628075:22628624,22636854:22637000,22637612:22637726,22637613:22637804,22639893:22640306,22639894:22640183,22641644:22642631,22641645:22642407,22643295:22643477,22643944:22644128,22644453:2264468', 'assoc_mat': '22586330:autre:4230:22588154,22586332:autre:4230:22588056,22586334:autre:4230:22587539,22586336:autre:4230:22587799,22586338:autre:4230:22587288,22586340:autre:4230:22587179,22586342:autre:4230:22587426,22586344:autre:4230:22587402,22586346:autre:4230:22587474,22586348:autre:4230:22587103,22586350:autre:4230:22587268,22586352:autre:4230:22587009,22586354:autre:4230:22587040,22586356:autre:4230:22587064,22586358:autre:4230:22586743,22586360:autre:4230:22586453,22586362:autre:4230:22586426,22586364:autre:4230:22586928,22586366:autre:4230:22586562,22586368:autre:4230:22586535,22586369:autre:4230:22586643,22586370:autre:4230:22586610,22587967:autre:4230:22588204,22620307:autre:4230:22620967,22620308:autre:4230:22620805,22620309:autre:4230:22620669,22622202:autre:4230:22625349,22622203:autre:4230:22625183,22622204:autre:4230:22624969,22622205:autre:4230:22624992,22622206:autre:4230:22624772,22622207:autre:4230:22624335,22622208:autre:4230:22624126,22622209:autre:4230:22624298,22622210:autre:4230:22624484,22622211:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.12494456444603051, 'nb_photo': 74128, 'list_port_cont': '22586428,22586456,22586539,22586571,22586612,22586647,22586749,22586930,22587004,22587037,22587069,22587118,22587194,22587255,22587290,22587413,22587432,22587485,22587555,22587789,22588057,22588167,22588212,22620673,22620804,22620956,22622826,22623226,22623360,22623475,22623494,22623614,22623712,22623884,22623924,22624125,22624260,22624315,22624342,22624488,22624769,22624963,22625007,22625177,22625364,22628622,22628884,22636996,22637734,22637800,22640179,22640304,22642416,22642636,22643482,22644124,22644681,22645870,22645905,22646377,22646946,22646994,22647354,22649154,22649254,22649272,22649324,22649373,22649429,22649471,22649643,22650478,22650742,22650835,22650982,22651114,22651346,22651458,22651592,22651812,22651880,22652138,22652189,22652328,22652556,22652582,22652839,22653289,22653780,22653805,22653856,22653897,22654728,22654828,22654859,22658410,22658526,22662228,22662403,22665366,22669174,22669415,22671887,22673901,22675678,22681726,22681880,22685091,22687369,22689888,22693131,22695875,22699260,2269946', 'assoc_port': '22586330:22588167,22586332:22588057,22586334:22587555,22586336:22587789,22586338:22587290,22586340:22587194,22586342:22587432,22586344:22587413,22586346:22587485,22586348:22587118,22586350:22587255,22586352:22587004,22586354:22587037,22586356:22587069,22586358:22586749,22586360:22586456,22586362:22586428,22586364:22586930,22586366:22586571,22586368:22586539,22586369:22586647,22586370:22586612,22587967:22588212,22620307:22620956,22620308:22620804,22620309:22620673,22622202:22625364,22622203:22625177,22622204:22624963,22622205:22625007,22622206:22624769,22622207:22624342,22622208:22624125,22622209:22624315,22622210:22624488,22622211:22623614,22622212:22623884,22622214:22623712,22622215:22624260,22622217:22623360,22622218:22623924,22622220:22623475,22622221:22623494,22622223:22622826,22622225:22623226,22628074:22628884,22628075:22628622,22636854:22636996,22637612:22637734,22637613:22637800,22639893:22640304,22639894:22640179,22641644:22642636,22641645:22642416,22643295:22643482,22643944:22644124,22644453:2264468', 'assoc_mat': '22586330:carton:4230:22588167,22586332:carton:4230:22588057,22586334:carton:4230:22587555,22586336:carton:4230:22587789,22586338:carton:4230:22587290,22586340:carton:4230:22587194,22586342:carton:4230:22587432,22586344:carton:4230:22587413,22586346:carton:4230:22587485,22586348:carton:4230:22587118,22586350:carton:4230:22587255,22586352:carton:4230:22587004,22586354:carton:4230:22587037,22586356:carton:4230:22587069,22586358:carton:4230:22586749,22586360:carton:4230:22586456,22586362:carton:4230:22586428,22586364:carton:4230:22586930,22586366:carton:4230:22586571,22586368:carton:4230:22586539,22586369:carton:4230:22586647,22586370:carton:4230:22586612,22587967:carton:4230:22588212,22620307:carton:4230:22620956,22620308:carton:4230:22620804,22620309:carton:4230:22620673,22622202:carton:4230:22625364,22622203:carton:4230:22625177,22622204:carton:4230:22624963,22622205:carton:4230:22625007,22622206:carton:4230:22624769,22622207:carton:4230:22624342,22622208:carton:4230:22624125,22622209:carton:4230:22624315,2262'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018091632459269922, 'nb_photo': 1356, 'list_port_cont': '22586417,22586458,22586534,22586572,22586600,22586638,22586742,22586931,22586998,22587041,22587070,22587112,22587185,22587256,22587300,22587411,22587425,22587477,22587552,22587786,22588043,22588159,22588196,22620676,22620790,22620961,22622824,22623219,22623350,22623471,22623479,22623619,22623715,22623890,22623923,22624141,22624241,22624313,22624352,22624491,22624775,22624958,22624998,22625174,22625352,22628626,22628876,22636998,22637725,22637796,22640186,22640309,22642401,22642620,22643500,22644116,22644689,22645868,22645891,22646389,22646952,22646995,22647345,22649142,22649263,22649279,22649336,22649372,22649427,22649470,22649636,22650469,22650738,22650844,22650975,22651111,22651353,22651452,22651595,22651813,22651879,22652146,22652181,22652327,22652546,22652595,22652829,22653282,22653786,22653796,22653863,22653885,22654732,22654826,22654865,22658402,22658517,22662224,22662401,22665368,22669180,22669407,22671909,22673904,22675677,22681720,22681882,22685095,22687352,22693135,22695840,22699470,22699750,2269977', 'assoc_port': '22586330:22588159,22586332:22588043,22586334:22587552,22586336:22587786,22586338:22587300,22586340:22587185,22586342:22587425,22586344:22587411,22586346:22587477,22586348:22587112,22586350:22587256,22586352:22586998,22586354:22587041,22586356:22587070,22586358:22586742,22586360:22586458,22586362:22586417,22586364:22586931,22586366:22586572,22586368:22586534,22586369:22586638,22586370:22586600,22587967:22588196,22620307:22620961,22620308:22620790,22620309:22620676,22622202:22625352,22622203:22625174,22622204:22624958,22622205:22624998,22622206:22624775,22622207:22624352,22622208:22624141,22622209:22624313,22622210:22624491,22622211:22623619,22622212:22623890,22622214:22623715,22622215:22624241,22622217:22623350,22622218:22623923,22622220:22623471,22622221:22623479,22622223:22622824,22622225:22623219,22628074:22628876,22628075:22628626,22636854:22636998,22637612:22637725,22637613:22637796,22639893:22640309,22639894:22640186,22641644:22642620,22641645:22642401,22643295:22643500,22643944:22644116,22644453:2264468', 'assoc_mat': '22586330:metal:4230:22588159,22586332:metal:4230:22588043,22586334:metal:4230:22587552,22586336:metal:4230:22587786,22586338:metal:4230:22587300,22586340:metal:4230:22587185,22586342:metal:4230:22587425,22586344:metal:4230:22587411,22586346:metal:4230:22587477,22586348:metal:4230:22587112,22586350:metal:4230:22587256,22586352:metal:4230:22586998,22586354:metal:4230:22587041,22586356:metal:4230:22587070,22586358:metal:4230:22586742,22586360:metal:4230:22586458,22586362:metal:4230:22586417,22586364:metal:4230:22586931,22586366:metal:4230:22586572,22586368:metal:4230:22586534,22586369:metal:4230:22586638,22586370:metal:4230:22586600,22587967:metal:4230:22588196,22620307:metal:4230:22620961,22620308:metal:4230:22620790,22620309:metal:4230:22620676,22622202:metal:4230:22625352,22622203:metal:4230:22625174,22622204:metal:4230:22624958,22622205:metal:4230:22624998,22622206:metal:4230:22624775,22622207:metal:4230:22624352,22622208:metal:4230:22624141,22622209:metal:4230:22624313,22622210:metal:4230:22624491,22622211:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.30089648417696474, 'nb_photo': 220834, 'list_port_cont': '22586424,22586463,22586527,22586573,22586608,22586648,22586752,22586929,22587008,22587044,22587081,22587106,22587195,22587263,22587304,22587410,22587435,22587478,22587545,22587795,22588054,22588165,22588208,22620682,22620797,22620959,22622829,22623220,22623365,22623474,22623489,22623625,22623710,22623889,22623933,22624135,22624247,22624309,22624344,22624495,22624773,22624960,22624997,22625179,22625363,22628623,22628877,22637007,22637729,22637797,22640182,22640300,22642415,22642633,22643504,22644129,22644680,22645869,22645904,22646382,22646951,22646985,22647339,22649148,22649253,22649273,22649331,22649375,22649436,22649464,22649646,22650471,22650744,22650846,22650978,22651104,22651352,22651462,22651583,22651809,22651882,22652140,22652191,22652333,22652560,22652592,22652844,22653297,22653777,22653808,22653861,22653888,22654733,22654832,22654867,22658416,22658522,22662233,22662398,22665375,22669184,22669419,22671904,22673894,22675673,22681727,22681870,22685100,22687368,22689890,22693129,22695858,22699257,2269947', 'assoc_port': '22586330:22588165,22586332:22588054,22586334:22587545,22586336:22587795,22586338:22587304,22586340:22587195,22586342:22587435,22586344:22587410,22586346:22587478,22586348:22587106,22586350:22587263,22586352:22587008,22586354:22587044,22586356:22587081,22586358:22586752,22586360:22586463,22586362:22586424,22586364:22586929,22586366:22586573,22586368:22586527,22586369:22586648,22586370:22586608,22587967:22588208,22620307:22620959,22620308:22620797,22620309:22620682,22622202:22625363,22622203:22625179,22622204:22624960,22622205:22624997,22622206:22624773,22622207:22624344,22622208:22624135,22622209:22624309,22622210:22624495,22622211:22623625,22622212:22623889,22622214:22623710,22622215:22624247,22622217:22623365,22622218:22623933,22622220:22623474,22622221:22623489,22622223:22622829,22622225:22623220,22628074:22628877,22628075:22628623,22636854:22637007,22637612:22637729,22637613:22637797,22639893:22640300,22639894:22640182,22641644:22642633,22641645:22642415,22643295:22643504,22643944:22644129,22644453:2264468', 'assoc_mat': '22586330:papier:4230:22588165,22586332:papier:4230:22588054,22586334:papier:4230:22587545,22586336:papier:4230:22587795,22586338:papier:4230:22587304,22586340:papier:4230:22587195,22586342:papier:4230:22587435,22586344:papier:4230:22587410,22586346:papier:4230:22587478,22586348:papier:4230:22587106,22586350:papier:4230:22587263,22586352:papier:4230:22587008,22586354:papier:4230:22587044,22586356:papier:4230:22587081,22586358:papier:4230:22586752,22586360:papier:4230:22586463,22586362:papier:4230:22586424,22586364:papier:4230:22586929,22586366:papier:4230:22586573,22586368:papier:4230:22586527,22586369:papier:4230:22586648,22586370:papier:4230:22586608,22587967:papier:4230:22588208,22620307:papier:4230:22620959,22620308:papier:4230:22620797,22620309:papier:4230:22620682,22622202:papier:4230:22625363,22622203:papier:4230:22625179,22622204:papier:4230:22624960,22622205:papier:4230:22624997,22622206:papier:4230:22624773,22622207:papier:4230:22624344,22622208:papier:4230:22624135,22622209:papier:4230:22624309,2262'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012284915034297201, 'nb_photo': 4551, 'list_port_cont': '22586429,22586465,22586540,22586568,22586602,22586652,22586747,22586933,22587001,22587038,22587074,22587114,22587190,22587266,22587293,22587407,22587438,22587481,22587551,22587798,22588051,22588158,22588201,22620677,22620803,22620968,22622830,22623230,22623366,22623476,22623498,22623615,22623714,22623881,22623932,22624130,22624258,22624311,22624351,22624498,22624778,22624959,22625005,22625181,22625351,22628627,22628889,22637008,22637735,22637798,22640184,22640299,22642418,22642626,22643505,22644118,22644690,22645863,22645908,22646379,22646955,22646983,22647353,22649149,22649257,22649277,22649334,22649376,22649430,22649472,22649639,22650476,22650743,22650836,22650981,22651115,22651354,22651460,22651591,22651815,22651866,22652137,22652190,22652322,22652557,22652593,22652838,22653292,22653785,22653806,22653860,22653898,22654735,22654831,22654871,22658414,22658530,22662234,22662405,22665373,22669172,22669412,22671910,22673908,22675679,22681721,22681894,22685105,22687363,22689889,22693140,22695872,22699255,2269946', 'assoc_port': '22586330:22588158,22586332:22588051,22586334:22587551,22586336:22587798,22586338:22587293,22586340:22587190,22586342:22587438,22586344:22587407,22586346:22587481,22586348:22587114,22586350:22587266,22586352:22587001,22586354:22587038,22586356:22587074,22586358:22586747,22586360:22586465,22586362:22586429,22586364:22586933,22586366:22586568,22586368:22586540,22586369:22586652,22586370:22586602,22587967:22588201,22620307:22620968,22620308:22620803,22620309:22620677,22622202:22625351,22622203:22625181,22622204:22624959,22622205:22625005,22622206:22624778,22622207:22624351,22622208:22624130,22622209:22624311,22622210:22624498,22622211:22623615,22622212:22623881,22622214:22623714,22622215:22624258,22622217:22623366,22622218:22623932,22622220:22623476,22622221:22623498,22622223:22622830,22622225:22623230,22628074:22628889,22628075:22628627,22636854:22637008,22637612:22637735,22637613:22637798,22639893:22640299,22639894:22640184,22641644:22642626,22641645:22642418,22643295:22643505,22643944:22644118,22644453:2264469', 'assoc_mat': '22586330:pehd:4230:22588158,22586332:pehd:4230:22588051,22586334:pehd:4230:22587551,22586336:pehd:4230:22587798,22586338:pehd:4230:22587293,22586340:pehd:4230:22587190,22586342:pehd:4230:22587438,22586344:pehd:4230:22587407,22586346:pehd:4230:22587481,22586348:pehd:4230:22587114,22586350:pehd:4230:22587266,22586352:pehd:4230:22587001,22586354:pehd:4230:22587038,22586356:pehd:4230:22587074,22586358:pehd:4230:22586747,22586360:pehd:4230:22586465,22586362:pehd:4230:22586429,22586364:pehd:4230:22586933,22586366:pehd:4230:22586568,22586368:pehd:4230:22586540,22586369:pehd:4230:22586652,22586370:pehd:4230:22586602,22587967:pehd:4230:22588201,22620307:pehd:4230:22620968,22620308:pehd:4230:22620803,22620309:pehd:4230:22620677,22622202:pehd:4230:22625351,22622203:pehd:4230:22625181,22622204:pehd:4230:22624959,22622205:pehd:4230:22625005,22622206:pehd:4230:22624778,22622207:pehd:4230:22624351,22622208:pehd:4230:22624130,22622209:pehd:4230:22624311,22622210:pehd:4230:22624498,22622211:pehd:4230:22623615,22622212:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012383607118755463, 'nb_photo': 13460, 'list_port_cont': '22586421,22586462,22586528,22586574,22586613,22586651,22586748,22586934,22587007,22587031,22587078,22587111,22587191,22587267,22587299,22587408,22587424,22587486,22587544,22587796,22588052,22588170,22588207,22620683,22620789,22620966,22622832,22623228,22623364,22623466,22623496,22623613,22623719,22623879,22623936,22624138,22624256,22624305,22624348,22624497,22624779,22624965,22625000,22625187,22625355,22628632,22628888,22636994,22637733,22637795,22640172,22640308,22642409,22642634,22643503,22644126,22644693,22645864,22645907,22646388,22646953,22646991,22647346,22649150,22649256,22649281,22649335,22649370,22649425,22649473,22649644,22650470,22650746,22650847,22650985,22651113,22651348,22651461,22651587,22651814,22651881,22652147,22652188,22652329,22652559,22652596,22652842,22653296,22653792,22653799,22653864,22653900,22654725,22654833,22654864,22658411,22658520,22662238,22662404,22665364,22669178,22669408,22671903,22673905,22675683,22681732,22681876,22685094,22687366,22689880,22693138,22695861,22699258,2269946', 'assoc_port': '22586330:22588170,22586332:22588052,22586334:22587544,22586336:22587796,22586338:22587299,22586340:22587191,22586342:22587424,22586344:22587408,22586346:22587486,22586348:22587111,22586350:22587267,22586352:22587007,22586354:22587031,22586356:22587078,22586358:22586748,22586360:22586462,22586362:22586421,22586364:22586934,22586366:22586574,22586368:22586528,22586369:22586651,22586370:22586613,22587967:22588207,22620307:22620966,22620308:22620789,22620309:22620683,22622202:22625355,22622203:22625187,22622204:22624965,22622205:22625000,22622206:22624779,22622207:22624348,22622208:22624138,22622209:22624305,22622210:22624497,22622211:22623613,22622212:22623879,22622214:22623719,22622215:22624256,22622217:22623364,22622218:22623936,22622220:22623466,22622221:22623496,22622223:22622832,22622225:22623228,22628074:22628888,22628075:22628632,22636854:22636994,22637612:22637733,22637613:22637795,22639893:22640308,22639894:22640172,22641644:22642634,22641645:22642409,22643295:22643503,22643944:22644126,22644453:2264469', 'assoc_mat': '22586330:pet_clair:4230:22588170,22586332:pet_clair:4230:22588052,22586334:pet_clair:4230:22587544,22586336:pet_clair:4230:22587796,22586338:pet_clair:4230:22587299,22586340:pet_clair:4230:22587191,22586342:pet_clair:4230:22587424,22586344:pet_clair:4230:22587408,22586346:pet_clair:4230:22587486,22586348:pet_clair:4230:22587111,22586350:pet_clair:4230:22587267,22586352:pet_clair:4230:22587007,22586354:pet_clair:4230:22587031,22586356:pet_clair:4230:22587078,22586358:pet_clair:4230:22586748,22586360:pet_clair:4230:22586462,22586362:pet_clair:4230:22586421,22586364:pet_clair:4230:22586934,22586366:pet_clair:4230:22586574,22586368:pet_clair:4230:22586528,22586369:pet_clair:4230:22586651,22586370:pet_clair:4230:22586613,22587967:pet_clair:4230:22588207,22620307:pet_clair:4230:22620966,22620308:pet_clair:4230:22620789,22620309:pet_clair:4230:22620683,22622202:pet_clair:4230:22625355,22622203:pet_clair:4230:22625187,22622204:pet_clair:4230:22624965,22622205:pet_clair:4230:22625000,22622206:pet_clair:4230:22624779,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006243708956658974, 'nb_photo': 1307, 'list_port_cont': '22586425,22586467,22586532,22586575,22586604,22586649,22586744,22586922,22587006,22587045,22587079,22587115,22587196,22587262,22587303,22587403,22587423,22587484,22587556,22587788,22588048,22588169,22588203,22620684,22620801,22620965,22622825,22623232,22623359,22623473,22623490,22623620,22623721,22623891,22623935,22624253,22624308,22624346,22624483,22624776,22624967,22625004,22625182,22625359,22628630,22628885,22637731,22637805,22640185,22640302,22642414,22642629,22643501,22644123,22644683,22645872,22645906,22646378,22646943,22646992,22647349,22649155,22649259,22649270,22649333,22649369,22649426,22649461,22649647,22650468,22650735,22650841,22650984,22651110,22651344,22651455,22651590,22651806,22651878,22652143,22652185,22652334,22652558,22652594,22652833,22653295,22653784,22653807,22653850,22653887,22654736,22654834,22654856,22658415,22658531,22662239,22662395,22665376,22669186,22671905,22673909,22675676,22681724,22681890,22685098,22687360,22689886,22693141,22695844,22699246,22699468,22699757,22699796,2269984', 'assoc_port': '22586330:22588169,22586332:22588048,22586334:22587556,22586336:22587788,22586338:22587303,22586340:22587196,22586342:22587423,22586344:22587403,22586346:22587484,22586348:22587115,22586350:22587262,22586352:22587006,22586354:22587045,22586356:22587079,22586358:22586744,22586360:22586467,22586362:22586425,22586364:22586922,22586366:22586575,22586368:22586532,22586369:22586649,22586370:22586604,22587967:22588203,22620307:22620965,22620308:22620801,22620309:22620684,22622202:22625359,22622203:22625182,22622204:22624967,22622205:22625004,22622206:22624776,22622207:22624346,22622209:22624308,22622210:22624483,22622211:22623620,22622212:22623891,22622214:22623721,22622215:22624253,22622217:22623359,22622218:22623935,22622220:22623473,22622221:22623490,22622223:22622825,22622225:22623232,22628074:22628885,22628075:22628630,22637612:22637731,22637613:22637805,22639893:22640302,22639894:22640185,22641644:22642629,22641645:22642414,22643295:22643501,22643944:22644123,22644453:22644683,22645697:22645872,22645698:2264590', 'assoc_mat': '22586330:pet_fonce:4230:22588169,22586332:pet_fonce:4230:22588048,22586334:pet_fonce:4230:22587556,22586336:pet_fonce:4230:22587788,22586338:pet_fonce:4230:22587303,22586340:pet_fonce:4230:22587196,22586342:pet_fonce:4230:22587423,22586344:pet_fonce:4230:22587403,22586346:pet_fonce:4230:22587484,22586348:pet_fonce:4230:22587115,22586350:pet_fonce:4230:22587262,22586352:pet_fonce:4230:22587006,22586354:pet_fonce:4230:22587045,22586356:pet_fonce:4230:22587079,22586358:pet_fonce:4230:22586744,22586360:pet_fonce:4230:22586467,22586362:pet_fonce:4230:22586425,22586364:pet_fonce:4230:22586922,22586366:pet_fonce:4230:22586575,22586368:pet_fonce:4230:22586532,22586369:pet_fonce:4230:22586649,22586370:pet_fonce:4230:22586604,22587967:pet_fonce:4230:22588203,22620307:pet_fonce:4230:22620965,22620308:pet_fonce:4230:22620801,22620309:pet_fonce:4230:22620684,22622202:pet_fonce:4230:22625359,22622203:pet_fonce:4230:22625182,22622204:pet_fonce:4230:22624967,22622205:pet_fonce:4230:22625004,22622206:pet_fonce:4230:22624776,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(1772807,1777128,1780226,1780583,1784619,1787887,1792958,1796273,1801060,1810366,1810317,1810419,1814882,1818776,1822890,1824121)); after get_hostname_from_raspi hasthag : incineration hasthag that could be used but not yet : _______refus SELECT substr(hashtag,8), substr(date_debut,1,7) as month, (sum(qualite*nombre_balle)/sum(nombre_balle)) FROM MTRPhoto.dashboard_results WHERE hashtag = '_______incineration' and qualite >=0 and dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day where dashboard_place_id=203 and date >='2025-05-01' and date <= '2025-05-31') GROUP BY month order by month; after impurety_average_per_hashtag {'number_of_analysed_photos': ((1019,),), 'unwanted_material_monthly_percentage': ((0.5606945689739883,),), 'material_repartition': (('incineration', 898),), 'material_dict': {'incineration': 898}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.4600686102431891, 64), (datetime.date(2025, 5, 2), 0.48147077353459716, 71), (datetime.date(2025, 5, 3), 0.4334374681864656, 70), (datetime.date(2025, 5, 4), 0.41992738152439074, 68), (datetime.date(2025, 5, 5), 0.5354142577003967, 72), (datetime.date(2025, 5, 6), 0.6210827368152888, 51), (datetime.date(2025, 5, 7), 0.6375769238272787, 70), (datetime.date(2025, 5, 8), 0.6471055045569485, 60), (datetime.date(2025, 5, 9), 0.5393521224330179, 71), (datetime.date(2025, 5, 10), 0.4351398998784888, 62), (datetime.date(2025, 5, 11), 0.58448509984718, 68), (datetime.date(2025, 5, 12), 0.7780630718310749, 63), (datetime.date(2025, 5, 14), 0.7238214920457108, 49), (datetime.date(2025, 5, 15), 0.6408394096568087, 59)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 5, 1), 0.4600686102431891, 64), (datetime.date(2025, 5, 2), 0.48147077353459716, 71), (datetime.date(2025, 5, 3), 0.4334374681864656, 70), (datetime.date(2025, 5, 4), 0.41992738152439074, 68), (datetime.date(2025, 5, 5), 0.5354142577003967, 72), (datetime.date(2025, 5, 6), 0.6210827368152888, 51), (datetime.date(2025, 5, 7), 0.6375769238272787, 70), (datetime.date(2025, 5, 8), 0.6471055045569485, 60), (datetime.date(2025, 5, 9), 0.5393521224330179, 71), (datetime.date(2025, 5, 10), 0.4351398998784888, 62), (datetime.date(2025, 5, 11), 0.58448509984718, 68), (datetime.date(2025, 5, 12), 0.7780630718310749, 63), (datetime.date(2025, 5, 14), 0.7238214920457108, 49), (datetime.date(2025, 5, 15), 0.6408394096568087, 59))}, 'quality_array': [['-8.941387920996165', '01052025'], ['-8.734698677379738', '02052025'], ['-8.86484148977508', '03052025'], ['-8.79773977374589', '04052025'], ['-8.375772617263571', '05052025'], ['-7.94932243727518', '06052025'], ['-7.752828508458052', '07052025'], ['-7.775421388886414', '08052025'], ['-7.944682066491986', '09052025'], ['-8.17143762230197', '10052025'], ['-8.388343370623673', '11052025'], ['-8.35745085384706', '12052025'], ['-7.941518879236943', '14052025'], ['-8.473194676484589', '15052025'], ['-8.632281054175467', '16052025']], 'number_of_batch': ((366,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.030516662769155083, 'nb_photo': 17229, 'list_port_cont': '22586426,22586453,22586535,22586562,22586610,22586643,22586743,22586928,22587009,22587040,22587064,22587103,22587179,22587268,22587288,22587402,22587426,22587474,22587539,22587799,22588056,22588154,22588204,22620669,22620805,22620967,22622815,22623218,22623358,22623470,22623487,22623623,22623717,22623887,22623928,22624126,22624245,22624298,22624335,22624484,22624772,22624969,22624992,22625183,22625349,22628624,22628879,22637000,22637726,22637804,22640183,22640306,22642407,22642631,22643477,22644128,22644682,22645856,22645903,22646380,22646940,22646993,22647348,22649145,22649251,22649280,22649321,22649368,22649428,22649462,22649631,22650472,22650740,22650842,22650971,22651108,22651345,22651459,22651588,22651810,22651867,22652145,22652186,22652326,22652555,22652584,22652828,22653294,22653779,22653800,22653858,22653895,22654739,22654821,22654866,22658413,22658528,22662241,22662402,22665371,22669171,22669403,22671906,22673897,22675670,22681719,22681873,22685101,22687353,22689878,22693139,22695876,22699247,2269945', 'assoc_port': '22586330:22588154,22586332:22588056,22586334:22587539,22586336:22587799,22586338:22587288,22586340:22587179,22586342:22587426,22586344:22587402,22586346:22587474,22586348:22587103,22586350:22587268,22586352:22587009,22586354:22587040,22586356:22587064,22586358:22586743,22586360:22586453,22586362:22586426,22586364:22586928,22586366:22586562,22586368:22586535,22586369:22586643,22586370:22586610,22587967:22588204,22620307:22620967,22620308:22620805,22620309:22620669,22622202:22625349,22622203:22625183,22622204:22624969,22622205:22624992,22622206:22624772,22622207:22624335,22622208:22624126,22622209:22624298,22622210:22624484,22622211:22623623,22622212:22623887,22622214:22623717,22622215:22624245,22622217:22623358,22622218:22623928,22622220:22623470,22622221:22623487,22622223:22622815,22622225:22623218,22628074:22628879,22628075:22628624,22636854:22637000,22637612:22637726,22637613:22637804,22639893:22640306,22639894:22640183,22641644:22642631,22641645:22642407,22643295:22643477,22643944:22644128,22644453:2264468', 'assoc_mat': '22586330:autre:4230:22588154,22586332:autre:4230:22588056,22586334:autre:4230:22587539,22586336:autre:4230:22587799,22586338:autre:4230:22587288,22586340:autre:4230:22587179,22586342:autre:4230:22587426,22586344:autre:4230:22587402,22586346:autre:4230:22587474,22586348:autre:4230:22587103,22586350:autre:4230:22587268,22586352:autre:4230:22587009,22586354:autre:4230:22587040,22586356:autre:4230:22587064,22586358:autre:4230:22586743,22586360:autre:4230:22586453,22586362:autre:4230:22586426,22586364:autre:4230:22586928,22586366:autre:4230:22586562,22586368:autre:4230:22586535,22586369:autre:4230:22586643,22586370:autre:4230:22586610,22587967:autre:4230:22588204,22620307:autre:4230:22620967,22620308:autre:4230:22620805,22620309:autre:4230:22620669,22622202:autre:4230:22625349,22622203:autre:4230:22625183,22622204:autre:4230:22624969,22622205:autre:4230:22624992,22622206:autre:4230:22624772,22622207:autre:4230:22624335,22622208:autre:4230:22624126,22622209:autre:4230:22624298,22622210:autre:4230:22624484,22622211:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.12494456444603051, 'nb_photo': 74128, 'list_port_cont': '22586428,22586456,22586539,22586571,22586612,22586647,22586749,22586930,22587004,22587037,22587069,22587118,22587194,22587255,22587290,22587413,22587432,22587485,22587555,22587789,22588057,22588167,22588212,22620673,22620804,22620956,22622826,22623226,22623360,22623475,22623494,22623614,22623712,22623884,22623924,22624125,22624260,22624315,22624342,22624488,22624769,22624963,22625007,22625177,22625364,22628622,22628884,22636996,22637734,22637800,22640179,22640304,22642416,22642636,22643482,22644124,22644681,22645870,22645905,22646377,22646946,22646994,22647354,22649154,22649254,22649272,22649324,22649373,22649429,22649471,22649643,22650478,22650742,22650835,22650982,22651114,22651346,22651458,22651592,22651812,22651880,22652138,22652189,22652328,22652556,22652582,22652839,22653289,22653780,22653805,22653856,22653897,22654728,22654828,22654859,22658410,22658526,22662228,22662403,22665366,22669174,22669415,22671887,22673901,22675678,22681726,22681880,22685091,22687369,22689888,22693131,22695875,22699260,2269946', 'assoc_port': '22586330:22588167,22586332:22588057,22586334:22587555,22586336:22587789,22586338:22587290,22586340:22587194,22586342:22587432,22586344:22587413,22586346:22587485,22586348:22587118,22586350:22587255,22586352:22587004,22586354:22587037,22586356:22587069,22586358:22586749,22586360:22586456,22586362:22586428,22586364:22586930,22586366:22586571,22586368:22586539,22586369:22586647,22586370:22586612,22587967:22588212,22620307:22620956,22620308:22620804,22620309:22620673,22622202:22625364,22622203:22625177,22622204:22624963,22622205:22625007,22622206:22624769,22622207:22624342,22622208:22624125,22622209:22624315,22622210:22624488,22622211:22623614,22622212:22623884,22622214:22623712,22622215:22624260,22622217:22623360,22622218:22623924,22622220:22623475,22622221:22623494,22622223:22622826,22622225:22623226,22628074:22628884,22628075:22628622,22636854:22636996,22637612:22637734,22637613:22637800,22639893:22640304,22639894:22640179,22641644:22642636,22641645:22642416,22643295:22643482,22643944:22644124,22644453:2264468', 'assoc_mat': '22586330:carton:4230:22588167,22586332:carton:4230:22588057,22586334:carton:4230:22587555,22586336:carton:4230:22587789,22586338:carton:4230:22587290,22586340:carton:4230:22587194,22586342:carton:4230:22587432,22586344:carton:4230:22587413,22586346:carton:4230:22587485,22586348:carton:4230:22587118,22586350:carton:4230:22587255,22586352:carton:4230:22587004,22586354:carton:4230:22587037,22586356:carton:4230:22587069,22586358:carton:4230:22586749,22586360:carton:4230:22586456,22586362:carton:4230:22586428,22586364:carton:4230:22586930,22586366:carton:4230:22586571,22586368:carton:4230:22586539,22586369:carton:4230:22586647,22586370:carton:4230:22586612,22587967:carton:4230:22588212,22620307:carton:4230:22620956,22620308:carton:4230:22620804,22620309:carton:4230:22620673,22622202:carton:4230:22625364,22622203:carton:4230:22625177,22622204:carton:4230:22624963,22622205:carton:4230:22625007,22622206:carton:4230:22624769,22622207:carton:4230:22624342,22622208:carton:4230:22624125,22622209:carton:4230:22624315,2262'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018091632459269922, 'nb_photo': 1356, 'list_port_cont': '22586417,22586458,22586534,22586572,22586600,22586638,22586742,22586931,22586998,22587041,22587070,22587112,22587185,22587256,22587300,22587411,22587425,22587477,22587552,22587786,22588043,22588159,22588196,22620676,22620790,22620961,22622824,22623219,22623350,22623471,22623479,22623619,22623715,22623890,22623923,22624141,22624241,22624313,22624352,22624491,22624775,22624958,22624998,22625174,22625352,22628626,22628876,22636998,22637725,22637796,22640186,22640309,22642401,22642620,22643500,22644116,22644689,22645868,22645891,22646389,22646952,22646995,22647345,22649142,22649263,22649279,22649336,22649372,22649427,22649470,22649636,22650469,22650738,22650844,22650975,22651111,22651353,22651452,22651595,22651813,22651879,22652146,22652181,22652327,22652546,22652595,22652829,22653282,22653786,22653796,22653863,22653885,22654732,22654826,22654865,22658402,22658517,22662224,22662401,22665368,22669180,22669407,22671909,22673904,22675677,22681720,22681882,22685095,22687352,22693135,22695840,22699470,22699750,2269977', 'assoc_port': '22586330:22588159,22586332:22588043,22586334:22587552,22586336:22587786,22586338:22587300,22586340:22587185,22586342:22587425,22586344:22587411,22586346:22587477,22586348:22587112,22586350:22587256,22586352:22586998,22586354:22587041,22586356:22587070,22586358:22586742,22586360:22586458,22586362:22586417,22586364:22586931,22586366:22586572,22586368:22586534,22586369:22586638,22586370:22586600,22587967:22588196,22620307:22620961,22620308:22620790,22620309:22620676,22622202:22625352,22622203:22625174,22622204:22624958,22622205:22624998,22622206:22624775,22622207:22624352,22622208:22624141,22622209:22624313,22622210:22624491,22622211:22623619,22622212:22623890,22622214:22623715,22622215:22624241,22622217:22623350,22622218:22623923,22622220:22623471,22622221:22623479,22622223:22622824,22622225:22623219,22628074:22628876,22628075:22628626,22636854:22636998,22637612:22637725,22637613:22637796,22639893:22640309,22639894:22640186,22641644:22642620,22641645:22642401,22643295:22643500,22643944:22644116,22644453:2264468', 'assoc_mat': '22586330:metal:4230:22588159,22586332:metal:4230:22588043,22586334:metal:4230:22587552,22586336:metal:4230:22587786,22586338:metal:4230:22587300,22586340:metal:4230:22587185,22586342:metal:4230:22587425,22586344:metal:4230:22587411,22586346:metal:4230:22587477,22586348:metal:4230:22587112,22586350:metal:4230:22587256,22586352:metal:4230:22586998,22586354:metal:4230:22587041,22586356:metal:4230:22587070,22586358:metal:4230:22586742,22586360:metal:4230:22586458,22586362:metal:4230:22586417,22586364:metal:4230:22586931,22586366:metal:4230:22586572,22586368:metal:4230:22586534,22586369:metal:4230:22586638,22586370:metal:4230:22586600,22587967:metal:4230:22588196,22620307:metal:4230:22620961,22620308:metal:4230:22620790,22620309:metal:4230:22620676,22622202:metal:4230:22625352,22622203:metal:4230:22625174,22622204:metal:4230:22624958,22622205:metal:4230:22624998,22622206:metal:4230:22624775,22622207:metal:4230:22624352,22622208:metal:4230:22624141,22622209:metal:4230:22624313,22622210:metal:4230:22624491,22622211:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.30089648417696474, 'nb_photo': 220834, 'list_port_cont': '22586424,22586463,22586527,22586573,22586608,22586648,22586752,22586929,22587008,22587044,22587081,22587106,22587195,22587263,22587304,22587410,22587435,22587478,22587545,22587795,22588054,22588165,22588208,22620682,22620797,22620959,22622829,22623220,22623365,22623474,22623489,22623625,22623710,22623889,22623933,22624135,22624247,22624309,22624344,22624495,22624773,22624960,22624997,22625179,22625363,22628623,22628877,22637007,22637729,22637797,22640182,22640300,22642415,22642633,22643504,22644129,22644680,22645869,22645904,22646382,22646951,22646985,22647339,22649148,22649253,22649273,22649331,22649375,22649436,22649464,22649646,22650471,22650744,22650846,22650978,22651104,22651352,22651462,22651583,22651809,22651882,22652140,22652191,22652333,22652560,22652592,22652844,22653297,22653777,22653808,22653861,22653888,22654733,22654832,22654867,22658416,22658522,22662233,22662398,22665375,22669184,22669419,22671904,22673894,22675673,22681727,22681870,22685100,22687368,22689890,22693129,22695858,22699257,2269947', 'assoc_port': '22586330:22588165,22586332:22588054,22586334:22587545,22586336:22587795,22586338:22587304,22586340:22587195,22586342:22587435,22586344:22587410,22586346:22587478,22586348:22587106,22586350:22587263,22586352:22587008,22586354:22587044,22586356:22587081,22586358:22586752,22586360:22586463,22586362:22586424,22586364:22586929,22586366:22586573,22586368:22586527,22586369:22586648,22586370:22586608,22587967:22588208,22620307:22620959,22620308:22620797,22620309:22620682,22622202:22625363,22622203:22625179,22622204:22624960,22622205:22624997,22622206:22624773,22622207:22624344,22622208:22624135,22622209:22624309,22622210:22624495,22622211:22623625,22622212:22623889,22622214:22623710,22622215:22624247,22622217:22623365,22622218:22623933,22622220:22623474,22622221:22623489,22622223:22622829,22622225:22623220,22628074:22628877,22628075:22628623,22636854:22637007,22637612:22637729,22637613:22637797,22639893:22640300,22639894:22640182,22641644:22642633,22641645:22642415,22643295:22643504,22643944:22644129,22644453:2264468', 'assoc_mat': '22586330:papier:4230:22588165,22586332:papier:4230:22588054,22586334:papier:4230:22587545,22586336:papier:4230:22587795,22586338:papier:4230:22587304,22586340:papier:4230:22587195,22586342:papier:4230:22587435,22586344:papier:4230:22587410,22586346:papier:4230:22587478,22586348:papier:4230:22587106,22586350:papier:4230:22587263,22586352:papier:4230:22587008,22586354:papier:4230:22587044,22586356:papier:4230:22587081,22586358:papier:4230:22586752,22586360:papier:4230:22586463,22586362:papier:4230:22586424,22586364:papier:4230:22586929,22586366:papier:4230:22586573,22586368:papier:4230:22586527,22586369:papier:4230:22586648,22586370:papier:4230:22586608,22587967:papier:4230:22588208,22620307:papier:4230:22620959,22620308:papier:4230:22620797,22620309:papier:4230:22620682,22622202:papier:4230:22625363,22622203:papier:4230:22625179,22622204:papier:4230:22624960,22622205:papier:4230:22624997,22622206:papier:4230:22624773,22622207:papier:4230:22624344,22622208:papier:4230:22624135,22622209:papier:4230:22624309,2262'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012284915034297201, 'nb_photo': 4551, 'list_port_cont': '22586429,22586465,22586540,22586568,22586602,22586652,22586747,22586933,22587001,22587038,22587074,22587114,22587190,22587266,22587293,22587407,22587438,22587481,22587551,22587798,22588051,22588158,22588201,22620677,22620803,22620968,22622830,22623230,22623366,22623476,22623498,22623615,22623714,22623881,22623932,22624130,22624258,22624311,22624351,22624498,22624778,22624959,22625005,22625181,22625351,22628627,22628889,22637008,22637735,22637798,22640184,22640299,22642418,22642626,22643505,22644118,22644690,22645863,22645908,22646379,22646955,22646983,22647353,22649149,22649257,22649277,22649334,22649376,22649430,22649472,22649639,22650476,22650743,22650836,22650981,22651115,22651354,22651460,22651591,22651815,22651866,22652137,22652190,22652322,22652557,22652593,22652838,22653292,22653785,22653806,22653860,22653898,22654735,22654831,22654871,22658414,22658530,22662234,22662405,22665373,22669172,22669412,22671910,22673908,22675679,22681721,22681894,22685105,22687363,22689889,22693140,22695872,22699255,2269946', 'assoc_port': '22586330:22588158,22586332:22588051,22586334:22587551,22586336:22587798,22586338:22587293,22586340:22587190,22586342:22587438,22586344:22587407,22586346:22587481,22586348:22587114,22586350:22587266,22586352:22587001,22586354:22587038,22586356:22587074,22586358:22586747,22586360:22586465,22586362:22586429,22586364:22586933,22586366:22586568,22586368:22586540,22586369:22586652,22586370:22586602,22587967:22588201,22620307:22620968,22620308:22620803,22620309:22620677,22622202:22625351,22622203:22625181,22622204:22624959,22622205:22625005,22622206:22624778,22622207:22624351,22622208:22624130,22622209:22624311,22622210:22624498,22622211:22623615,22622212:22623881,22622214:22623714,22622215:22624258,22622217:22623366,22622218:22623932,22622220:22623476,22622221:22623498,22622223:22622830,22622225:22623230,22628074:22628889,22628075:22628627,22636854:22637008,22637612:22637735,22637613:22637798,22639893:22640299,22639894:22640184,22641644:22642626,22641645:22642418,22643295:22643505,22643944:22644118,22644453:2264469', 'assoc_mat': '22586330:pehd:4230:22588158,22586332:pehd:4230:22588051,22586334:pehd:4230:22587551,22586336:pehd:4230:22587798,22586338:pehd:4230:22587293,22586340:pehd:4230:22587190,22586342:pehd:4230:22587438,22586344:pehd:4230:22587407,22586346:pehd:4230:22587481,22586348:pehd:4230:22587114,22586350:pehd:4230:22587266,22586352:pehd:4230:22587001,22586354:pehd:4230:22587038,22586356:pehd:4230:22587074,22586358:pehd:4230:22586747,22586360:pehd:4230:22586465,22586362:pehd:4230:22586429,22586364:pehd:4230:22586933,22586366:pehd:4230:22586568,22586368:pehd:4230:22586540,22586369:pehd:4230:22586652,22586370:pehd:4230:22586602,22587967:pehd:4230:22588201,22620307:pehd:4230:22620968,22620308:pehd:4230:22620803,22620309:pehd:4230:22620677,22622202:pehd:4230:22625351,22622203:pehd:4230:22625181,22622204:pehd:4230:22624959,22622205:pehd:4230:22625005,22622206:pehd:4230:22624778,22622207:pehd:4230:22624351,22622208:pehd:4230:22624130,22622209:pehd:4230:22624311,22622210:pehd:4230:22624498,22622211:pehd:4230:22623615,22622212:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012383607118755463, 'nb_photo': 13460, 'list_port_cont': '22586421,22586462,22586528,22586574,22586613,22586651,22586748,22586934,22587007,22587031,22587078,22587111,22587191,22587267,22587299,22587408,22587424,22587486,22587544,22587796,22588052,22588170,22588207,22620683,22620789,22620966,22622832,22623228,22623364,22623466,22623496,22623613,22623719,22623879,22623936,22624138,22624256,22624305,22624348,22624497,22624779,22624965,22625000,22625187,22625355,22628632,22628888,22636994,22637733,22637795,22640172,22640308,22642409,22642634,22643503,22644126,22644693,22645864,22645907,22646388,22646953,22646991,22647346,22649150,22649256,22649281,22649335,22649370,22649425,22649473,22649644,22650470,22650746,22650847,22650985,22651113,22651348,22651461,22651587,22651814,22651881,22652147,22652188,22652329,22652559,22652596,22652842,22653296,22653792,22653799,22653864,22653900,22654725,22654833,22654864,22658411,22658520,22662238,22662404,22665364,22669178,22669408,22671903,22673905,22675683,22681732,22681876,22685094,22687366,22689880,22693138,22695861,22699258,2269946', 'assoc_port': '22586330:22588170,22586332:22588052,22586334:22587544,22586336:22587796,22586338:22587299,22586340:22587191,22586342:22587424,22586344:22587408,22586346:22587486,22586348:22587111,22586350:22587267,22586352:22587007,22586354:22587031,22586356:22587078,22586358:22586748,22586360:22586462,22586362:22586421,22586364:22586934,22586366:22586574,22586368:22586528,22586369:22586651,22586370:22586613,22587967:22588207,22620307:22620966,22620308:22620789,22620309:22620683,22622202:22625355,22622203:22625187,22622204:22624965,22622205:22625000,22622206:22624779,22622207:22624348,22622208:22624138,22622209:22624305,22622210:22624497,22622211:22623613,22622212:22623879,22622214:22623719,22622215:22624256,22622217:22623364,22622218:22623936,22622220:22623466,22622221:22623496,22622223:22622832,22622225:22623228,22628074:22628888,22628075:22628632,22636854:22636994,22637612:22637733,22637613:22637795,22639893:22640308,22639894:22640172,22641644:22642634,22641645:22642409,22643295:22643503,22643944:22644126,22644453:2264469', 'assoc_mat': '22586330:pet_clair:4230:22588170,22586332:pet_clair:4230:22588052,22586334:pet_clair:4230:22587544,22586336:pet_clair:4230:22587796,22586338:pet_clair:4230:22587299,22586340:pet_clair:4230:22587191,22586342:pet_clair:4230:22587424,22586344:pet_clair:4230:22587408,22586346:pet_clair:4230:22587486,22586348:pet_clair:4230:22587111,22586350:pet_clair:4230:22587267,22586352:pet_clair:4230:22587007,22586354:pet_clair:4230:22587031,22586356:pet_clair:4230:22587078,22586358:pet_clair:4230:22586748,22586360:pet_clair:4230:22586462,22586362:pet_clair:4230:22586421,22586364:pet_clair:4230:22586934,22586366:pet_clair:4230:22586574,22586368:pet_clair:4230:22586528,22586369:pet_clair:4230:22586651,22586370:pet_clair:4230:22586613,22587967:pet_clair:4230:22588207,22620307:pet_clair:4230:22620966,22620308:pet_clair:4230:22620789,22620309:pet_clair:4230:22620683,22622202:pet_clair:4230:22625355,22622203:pet_clair:4230:22625187,22622204:pet_clair:4230:22624965,22622205:pet_clair:4230:22625000,22622206:pet_clair:4230:22624779,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006243708956658974, 'nb_photo': 1307, 'list_port_cont': '22586425,22586467,22586532,22586575,22586604,22586649,22586744,22586922,22587006,22587045,22587079,22587115,22587196,22587262,22587303,22587403,22587423,22587484,22587556,22587788,22588048,22588169,22588203,22620684,22620801,22620965,22622825,22623232,22623359,22623473,22623490,22623620,22623721,22623891,22623935,22624253,22624308,22624346,22624483,22624776,22624967,22625004,22625182,22625359,22628630,22628885,22637731,22637805,22640185,22640302,22642414,22642629,22643501,22644123,22644683,22645872,22645906,22646378,22646943,22646992,22647349,22649155,22649259,22649270,22649333,22649369,22649426,22649461,22649647,22650468,22650735,22650841,22650984,22651110,22651344,22651455,22651590,22651806,22651878,22652143,22652185,22652334,22652558,22652594,22652833,22653295,22653784,22653807,22653850,22653887,22654736,22654834,22654856,22658415,22658531,22662239,22662395,22665376,22669186,22671905,22673909,22675676,22681724,22681890,22685098,22687360,22689886,22693141,22695844,22699246,22699468,22699757,22699796,2269984', 'assoc_port': '22586330:22588169,22586332:22588048,22586334:22587556,22586336:22587788,22586338:22587303,22586340:22587196,22586342:22587423,22586344:22587403,22586346:22587484,22586348:22587115,22586350:22587262,22586352:22587006,22586354:22587045,22586356:22587079,22586358:22586744,22586360:22586467,22586362:22586425,22586364:22586922,22586366:22586575,22586368:22586532,22586369:22586649,22586370:22586604,22587967:22588203,22620307:22620965,22620308:22620801,22620309:22620684,22622202:22625359,22622203:22625182,22622204:22624967,22622205:22625004,22622206:22624776,22622207:22624346,22622209:22624308,22622210:22624483,22622211:22623620,22622212:22623891,22622214:22623721,22622215:22624253,22622217:22623359,22622218:22623935,22622220:22623473,22622221:22623490,22622223:22622825,22622225:22623232,22628074:22628885,22628075:22628630,22637612:22637731,22637613:22637805,22639893:22640302,22639894:22640185,22641644:22642629,22641645:22642414,22643295:22643501,22643944:22644123,22644453:22644683,22645697:22645872,22645698:2264590', 'assoc_mat': '22586330:pet_fonce:4230:22588169,22586332:pet_fonce:4230:22588048,22586334:pet_fonce:4230:22587556,22586336:pet_fonce:4230:22587788,22586338:pet_fonce:4230:22587303,22586340:pet_fonce:4230:22587196,22586342:pet_fonce:4230:22587423,22586344:pet_fonce:4230:22587403,22586346:pet_fonce:4230:22587484,22586348:pet_fonce:4230:22587115,22586350:pet_fonce:4230:22587262,22586352:pet_fonce:4230:22587006,22586354:pet_fonce:4230:22587045,22586356:pet_fonce:4230:22587079,22586358:pet_fonce:4230:22586744,22586360:pet_fonce:4230:22586467,22586362:pet_fonce:4230:22586425,22586364:pet_fonce:4230:22586922,22586366:pet_fonce:4230:22586575,22586368:pet_fonce:4230:22586532,22586369:pet_fonce:4230:22586649,22586370:pet_fonce:4230:22586604,22587967:pet_fonce:4230:22588203,22620307:pet_fonce:4230:22620965,22620308:pet_fonce:4230:22620801,22620309:pet_fonce:4230:22620684,22622202:pet_fonce:4230:22625359,22622203:pet_fonce:4230:22625182,22622204:pet_fonce:4230:22624967,22622205:pet_fonce:4230:22625004,22622206:pet_fonce:4230:22624776,2'}), 'main_stat': {'nb_photos': 1019}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-05', 0.5606945689739883),)]} TODO : Insert select and so on SELECT id, name, misc_info, datou_id_for_right FROM MTRPhoto.dashboard_places WHERE name="SCCU_cam8"; SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4851 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4851 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4851 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4851 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! {"input_values":[]} SELECT name, created_at,limit_max FROM MTRDatou.mtr_datou WHERE id=4234 SELECT mtd.id, mtdt.`type`, mtd.`param`, mtd.param_json, mtdt.nb_input, mtdt.nb_output, mtdt.prod, mtdt.is_local, mtdt.is_datou_depend, mtdt.is_photo_id_local FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_step_types mtdt WHERE mtdt.`id`=mtd.`type` AND mtd.mtd_id=4234 SELECT mtd.id, mtd.mtd_id, mdsdt.id, mdsdt.name, mdsdt.description, msid.output_or_input, msid.data_order_id, mdsdt.type FROM MTRDatou.mtr_datou_step mtd, MTRDatou.mtr_datou_steptype_io_datatypes msid, MTRDatou.mtr_datou_step_data_types mdsdt WHERE mtd.`type`=msid.`mtr_datou_step_type` AND mtd.mtd_id= 4234 AND msid.data_type=mdsdt.id SELECT mts_id_output, id_output, mts_id_input, id_input FROM MTRDatou.mtr_datou_step_by_step WHERE mtd_id=4234 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! {"input_values":[]} Unexpected error treated as WARNING for now expected given param in final step {'name_pipeline': 'aggregate_carac_ratio', 'hashtag_type': 4230, 'hashtag_proportion': 'papier,carton,metal,pet_clair,autre,pehd,pet_fonce', 'hashtag_parmi': 'refus', 'hashtag_weights': {'autre': 3.0, 'barquette_avec_film': 3.0, 'carton': 3.0, 'metal': 3.0, 'papier': 3.0, 'pehd': 3.0, 'pet_fonce': 3.0, 'pet_clair': 1.0, 'flou': 1.0, 'mal_croppe': 1.0}, 'option_sccu': 1} Found hashtag_parmi in final step, will be used and useful if different from matiere_majoritaire in classifier {'number_of_analysed_photos': ((1019,),), 'unwanted_material_monthly_percentage': ((0.5606945689739883,),), 'material_repartition': (('incineration', 898),), 'material_dict': {'incineration': 898}, 'coverage_data': (), 'impurety_average_data': ((datetime.date(2025, 5, 1), 0.4600686102431891, 64), (datetime.date(2025, 5, 2), 0.48147077353459716, 71), (datetime.date(2025, 5, 3), 0.4334374681864656, 70), (datetime.date(2025, 5, 4), 0.41992738152439074, 68), (datetime.date(2025, 5, 5), 0.5354142577003967, 72), (datetime.date(2025, 5, 6), 0.6210827368152888, 51), (datetime.date(2025, 5, 7), 0.6375769238272787, 70), (datetime.date(2025, 5, 8), 0.6471055045569485, 60), (datetime.date(2025, 5, 9), 0.5393521224330179, 71), (datetime.date(2025, 5, 10), 0.4351398998784888, 62), (datetime.date(2025, 5, 11), 0.58448509984718, 68), (datetime.date(2025, 5, 12), 0.7780630718310749, 63), (datetime.date(2025, 5, 14), 0.7238214920457108, 49), (datetime.date(2025, 5, 15), 0.6408394096568087, 59)), 'impurety_average_data_per_hashtag': {'incineration': ((datetime.date(2025, 5, 1), 0.4600686102431891, 64), (datetime.date(2025, 5, 2), 0.48147077353459716, 71), (datetime.date(2025, 5, 3), 0.4334374681864656, 70), (datetime.date(2025, 5, 4), 0.41992738152439074, 68), (datetime.date(2025, 5, 5), 0.5354142577003967, 72), (datetime.date(2025, 5, 6), 0.6210827368152888, 51), (datetime.date(2025, 5, 7), 0.6375769238272787, 70), (datetime.date(2025, 5, 8), 0.6471055045569485, 60), (datetime.date(2025, 5, 9), 0.5393521224330179, 71), (datetime.date(2025, 5, 10), 0.4351398998784888, 62), (datetime.date(2025, 5, 11), 0.58448509984718, 68), (datetime.date(2025, 5, 12), 0.7780630718310749, 63), (datetime.date(2025, 5, 14), 0.7238214920457108, 49), (datetime.date(2025, 5, 15), 0.6408394096568087, 59))}, 'quality_array': [['-8.941387920996165', '01052025'], ['-8.734698677379738', '02052025'], ['-8.86484148977508', '03052025'], ['-8.79773977374589', '04052025'], ['-8.375772617263571', '05052025'], ['-7.94932243727518', '06052025'], ['-7.752828508458052', '07052025'], ['-7.775421388886414', '08052025'], ['-7.944682066491986', '09052025'], ['-8.17143762230197', '10052025'], ['-8.388343370623673', '11052025'], ['-8.35745085384706', '12052025'], ['-7.941518879236943', '14052025'], ['-8.473194676484589', '15052025'], ['-8.632281054175467', '16052025']], 'number_of_batch': ((366,),), 'datou_id_sts': 4851, 'map_hashtag_number_mat': {'hash_to_mat_nb': ({'unwanted_material': 'autre', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.030516662769155083, 'nb_photo': 17229, 'list_port_cont': '22586426,22586453,22586535,22586562,22586610,22586643,22586743,22586928,22587009,22587040,22587064,22587103,22587179,22587268,22587288,22587402,22587426,22587474,22587539,22587799,22588056,22588154,22588204,22620669,22620805,22620967,22622815,22623218,22623358,22623470,22623487,22623623,22623717,22623887,22623928,22624126,22624245,22624298,22624335,22624484,22624772,22624969,22624992,22625183,22625349,22628624,22628879,22637000,22637726,22637804,22640183,22640306,22642407,22642631,22643477,22644128,22644682,22645856,22645903,22646380,22646940,22646993,22647348,22649145,22649251,22649280,22649321,22649368,22649428,22649462,22649631,22650472,22650740,22650842,22650971,22651108,22651345,22651459,22651588,22651810,22651867,22652145,22652186,22652326,22652555,22652584,22652828,22653294,22653779,22653800,22653858,22653895,22654739,22654821,22654866,22658413,22658528,22662241,22662402,22665371,22669171,22669403,22671906,22673897,22675670,22681719,22681873,22685101,22687353,22689878,22693139,22695876,22699247,2269945', 'assoc_port': '22586330:22588154,22586332:22588056,22586334:22587539,22586336:22587799,22586338:22587288,22586340:22587179,22586342:22587426,22586344:22587402,22586346:22587474,22586348:22587103,22586350:22587268,22586352:22587009,22586354:22587040,22586356:22587064,22586358:22586743,22586360:22586453,22586362:22586426,22586364:22586928,22586366:22586562,22586368:22586535,22586369:22586643,22586370:22586610,22587967:22588204,22620307:22620967,22620308:22620805,22620309:22620669,22622202:22625349,22622203:22625183,22622204:22624969,22622205:22624992,22622206:22624772,22622207:22624335,22622208:22624126,22622209:22624298,22622210:22624484,22622211:22623623,22622212:22623887,22622214:22623717,22622215:22624245,22622217:22623358,22622218:22623928,22622220:22623470,22622221:22623487,22622223:22622815,22622225:22623218,22628074:22628879,22628075:22628624,22636854:22637000,22637612:22637726,22637613:22637804,22639893:22640306,22639894:22640183,22641644:22642631,22641645:22642407,22643295:22643477,22643944:22644128,22644453:2264468', 'assoc_mat': '22586330:autre:4230:22588154,22586332:autre:4230:22588056,22586334:autre:4230:22587539,22586336:autre:4230:22587799,22586338:autre:4230:22587288,22586340:autre:4230:22587179,22586342:autre:4230:22587426,22586344:autre:4230:22587402,22586346:autre:4230:22587474,22586348:autre:4230:22587103,22586350:autre:4230:22587268,22586352:autre:4230:22587009,22586354:autre:4230:22587040,22586356:autre:4230:22587064,22586358:autre:4230:22586743,22586360:autre:4230:22586453,22586362:autre:4230:22586426,22586364:autre:4230:22586928,22586366:autre:4230:22586562,22586368:autre:4230:22586535,22586369:autre:4230:22586643,22586370:autre:4230:22586610,22587967:autre:4230:22588204,22620307:autre:4230:22620967,22620308:autre:4230:22620805,22620309:autre:4230:22620669,22622202:autre:4230:22625349,22622203:autre:4230:22625183,22622204:autre:4230:22624969,22622205:autre:4230:22624992,22622206:autre:4230:22624772,22622207:autre:4230:22624335,22622208:autre:4230:22624126,22622209:autre:4230:22624298,22622210:autre:4230:22624484,22622211:'}, {'unwanted_material': 'carton', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.12494456444603051, 'nb_photo': 74128, 'list_port_cont': '22586428,22586456,22586539,22586571,22586612,22586647,22586749,22586930,22587004,22587037,22587069,22587118,22587194,22587255,22587290,22587413,22587432,22587485,22587555,22587789,22588057,22588167,22588212,22620673,22620804,22620956,22622826,22623226,22623360,22623475,22623494,22623614,22623712,22623884,22623924,22624125,22624260,22624315,22624342,22624488,22624769,22624963,22625007,22625177,22625364,22628622,22628884,22636996,22637734,22637800,22640179,22640304,22642416,22642636,22643482,22644124,22644681,22645870,22645905,22646377,22646946,22646994,22647354,22649154,22649254,22649272,22649324,22649373,22649429,22649471,22649643,22650478,22650742,22650835,22650982,22651114,22651346,22651458,22651592,22651812,22651880,22652138,22652189,22652328,22652556,22652582,22652839,22653289,22653780,22653805,22653856,22653897,22654728,22654828,22654859,22658410,22658526,22662228,22662403,22665366,22669174,22669415,22671887,22673901,22675678,22681726,22681880,22685091,22687369,22689888,22693131,22695875,22699260,2269946', 'assoc_port': '22586330:22588167,22586332:22588057,22586334:22587555,22586336:22587789,22586338:22587290,22586340:22587194,22586342:22587432,22586344:22587413,22586346:22587485,22586348:22587118,22586350:22587255,22586352:22587004,22586354:22587037,22586356:22587069,22586358:22586749,22586360:22586456,22586362:22586428,22586364:22586930,22586366:22586571,22586368:22586539,22586369:22586647,22586370:22586612,22587967:22588212,22620307:22620956,22620308:22620804,22620309:22620673,22622202:22625364,22622203:22625177,22622204:22624963,22622205:22625007,22622206:22624769,22622207:22624342,22622208:22624125,22622209:22624315,22622210:22624488,22622211:22623614,22622212:22623884,22622214:22623712,22622215:22624260,22622217:22623360,22622218:22623924,22622220:22623475,22622221:22623494,22622223:22622826,22622225:22623226,22628074:22628884,22628075:22628622,22636854:22636996,22637612:22637734,22637613:22637800,22639893:22640304,22639894:22640179,22641644:22642636,22641645:22642416,22643295:22643482,22643944:22644124,22644453:2264468', 'assoc_mat': '22586330:carton:4230:22588167,22586332:carton:4230:22588057,22586334:carton:4230:22587555,22586336:carton:4230:22587789,22586338:carton:4230:22587290,22586340:carton:4230:22587194,22586342:carton:4230:22587432,22586344:carton:4230:22587413,22586346:carton:4230:22587485,22586348:carton:4230:22587118,22586350:carton:4230:22587255,22586352:carton:4230:22587004,22586354:carton:4230:22587037,22586356:carton:4230:22587069,22586358:carton:4230:22586749,22586360:carton:4230:22586456,22586362:carton:4230:22586428,22586364:carton:4230:22586930,22586366:carton:4230:22586571,22586368:carton:4230:22586539,22586369:carton:4230:22586647,22586370:carton:4230:22586612,22587967:carton:4230:22588212,22620307:carton:4230:22620956,22620308:carton:4230:22620804,22620309:carton:4230:22620673,22622202:carton:4230:22625364,22622203:carton:4230:22625177,22622204:carton:4230:22624963,22622205:carton:4230:22625007,22622206:carton:4230:22624769,22622207:carton:4230:22624342,22622208:carton:4230:22624125,22622209:carton:4230:22624315,2262'}, {'unwanted_material': 'metal', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.0018091632459269922, 'nb_photo': 1356, 'list_port_cont': '22586417,22586458,22586534,22586572,22586600,22586638,22586742,22586931,22586998,22587041,22587070,22587112,22587185,22587256,22587300,22587411,22587425,22587477,22587552,22587786,22588043,22588159,22588196,22620676,22620790,22620961,22622824,22623219,22623350,22623471,22623479,22623619,22623715,22623890,22623923,22624141,22624241,22624313,22624352,22624491,22624775,22624958,22624998,22625174,22625352,22628626,22628876,22636998,22637725,22637796,22640186,22640309,22642401,22642620,22643500,22644116,22644689,22645868,22645891,22646389,22646952,22646995,22647345,22649142,22649263,22649279,22649336,22649372,22649427,22649470,22649636,22650469,22650738,22650844,22650975,22651111,22651353,22651452,22651595,22651813,22651879,22652146,22652181,22652327,22652546,22652595,22652829,22653282,22653786,22653796,22653863,22653885,22654732,22654826,22654865,22658402,22658517,22662224,22662401,22665368,22669180,22669407,22671909,22673904,22675677,22681720,22681882,22685095,22687352,22693135,22695840,22699470,22699750,2269977', 'assoc_port': '22586330:22588159,22586332:22588043,22586334:22587552,22586336:22587786,22586338:22587300,22586340:22587185,22586342:22587425,22586344:22587411,22586346:22587477,22586348:22587112,22586350:22587256,22586352:22586998,22586354:22587041,22586356:22587070,22586358:22586742,22586360:22586458,22586362:22586417,22586364:22586931,22586366:22586572,22586368:22586534,22586369:22586638,22586370:22586600,22587967:22588196,22620307:22620961,22620308:22620790,22620309:22620676,22622202:22625352,22622203:22625174,22622204:22624958,22622205:22624998,22622206:22624775,22622207:22624352,22622208:22624141,22622209:22624313,22622210:22624491,22622211:22623619,22622212:22623890,22622214:22623715,22622215:22624241,22622217:22623350,22622218:22623923,22622220:22623471,22622221:22623479,22622223:22622824,22622225:22623219,22628074:22628876,22628075:22628626,22636854:22636998,22637612:22637725,22637613:22637796,22639893:22640309,22639894:22640186,22641644:22642620,22641645:22642401,22643295:22643500,22643944:22644116,22644453:2264468', 'assoc_mat': '22586330:metal:4230:22588159,22586332:metal:4230:22588043,22586334:metal:4230:22587552,22586336:metal:4230:22587786,22586338:metal:4230:22587300,22586340:metal:4230:22587185,22586342:metal:4230:22587425,22586344:metal:4230:22587411,22586346:metal:4230:22587477,22586348:metal:4230:22587112,22586350:metal:4230:22587256,22586352:metal:4230:22586998,22586354:metal:4230:22587041,22586356:metal:4230:22587070,22586358:metal:4230:22586742,22586360:metal:4230:22586458,22586362:metal:4230:22586417,22586364:metal:4230:22586931,22586366:metal:4230:22586572,22586368:metal:4230:22586534,22586369:metal:4230:22586638,22586370:metal:4230:22586600,22587967:metal:4230:22588196,22620307:metal:4230:22620961,22620308:metal:4230:22620790,22620309:metal:4230:22620676,22622202:metal:4230:22625352,22622203:metal:4230:22625174,22622204:metal:4230:22624958,22622205:metal:4230:22624998,22622206:metal:4230:22624775,22622207:metal:4230:22624352,22622208:metal:4230:22624141,22622209:metal:4230:22624313,22622210:metal:4230:22624491,22622211:'}, {'unwanted_material': 'papier', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.30089648417696474, 'nb_photo': 220834, 'list_port_cont': '22586424,22586463,22586527,22586573,22586608,22586648,22586752,22586929,22587008,22587044,22587081,22587106,22587195,22587263,22587304,22587410,22587435,22587478,22587545,22587795,22588054,22588165,22588208,22620682,22620797,22620959,22622829,22623220,22623365,22623474,22623489,22623625,22623710,22623889,22623933,22624135,22624247,22624309,22624344,22624495,22624773,22624960,22624997,22625179,22625363,22628623,22628877,22637007,22637729,22637797,22640182,22640300,22642415,22642633,22643504,22644129,22644680,22645869,22645904,22646382,22646951,22646985,22647339,22649148,22649253,22649273,22649331,22649375,22649436,22649464,22649646,22650471,22650744,22650846,22650978,22651104,22651352,22651462,22651583,22651809,22651882,22652140,22652191,22652333,22652560,22652592,22652844,22653297,22653777,22653808,22653861,22653888,22654733,22654832,22654867,22658416,22658522,22662233,22662398,22665375,22669184,22669419,22671904,22673894,22675673,22681727,22681870,22685100,22687368,22689890,22693129,22695858,22699257,2269947', 'assoc_port': '22586330:22588165,22586332:22588054,22586334:22587545,22586336:22587795,22586338:22587304,22586340:22587195,22586342:22587435,22586344:22587410,22586346:22587478,22586348:22587106,22586350:22587263,22586352:22587008,22586354:22587044,22586356:22587081,22586358:22586752,22586360:22586463,22586362:22586424,22586364:22586929,22586366:22586573,22586368:22586527,22586369:22586648,22586370:22586608,22587967:22588208,22620307:22620959,22620308:22620797,22620309:22620682,22622202:22625363,22622203:22625179,22622204:22624960,22622205:22624997,22622206:22624773,22622207:22624344,22622208:22624135,22622209:22624309,22622210:22624495,22622211:22623625,22622212:22623889,22622214:22623710,22622215:22624247,22622217:22623365,22622218:22623933,22622220:22623474,22622221:22623489,22622223:22622829,22622225:22623220,22628074:22628877,22628075:22628623,22636854:22637007,22637612:22637729,22637613:22637797,22639893:22640300,22639894:22640182,22641644:22642633,22641645:22642415,22643295:22643504,22643944:22644129,22644453:2264468', 'assoc_mat': '22586330:papier:4230:22588165,22586332:papier:4230:22588054,22586334:papier:4230:22587545,22586336:papier:4230:22587795,22586338:papier:4230:22587304,22586340:papier:4230:22587195,22586342:papier:4230:22587435,22586344:papier:4230:22587410,22586346:papier:4230:22587478,22586348:papier:4230:22587106,22586350:papier:4230:22587263,22586352:papier:4230:22587008,22586354:papier:4230:22587044,22586356:papier:4230:22587081,22586358:papier:4230:22586752,22586360:papier:4230:22586463,22586362:papier:4230:22586424,22586364:papier:4230:22586929,22586366:papier:4230:22586573,22586368:papier:4230:22586527,22586369:papier:4230:22586648,22586370:papier:4230:22586608,22587967:papier:4230:22588208,22620307:papier:4230:22620959,22620308:papier:4230:22620797,22620309:papier:4230:22620682,22622202:papier:4230:22625363,22622203:papier:4230:22625179,22622204:papier:4230:22624960,22622205:papier:4230:22624997,22622206:papier:4230:22624773,22622207:papier:4230:22624344,22622208:papier:4230:22624135,22622209:papier:4230:22624309,2262'}, {'unwanted_material': 'pehd', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012284915034297201, 'nb_photo': 4551, 'list_port_cont': '22586429,22586465,22586540,22586568,22586602,22586652,22586747,22586933,22587001,22587038,22587074,22587114,22587190,22587266,22587293,22587407,22587438,22587481,22587551,22587798,22588051,22588158,22588201,22620677,22620803,22620968,22622830,22623230,22623366,22623476,22623498,22623615,22623714,22623881,22623932,22624130,22624258,22624311,22624351,22624498,22624778,22624959,22625005,22625181,22625351,22628627,22628889,22637008,22637735,22637798,22640184,22640299,22642418,22642626,22643505,22644118,22644690,22645863,22645908,22646379,22646955,22646983,22647353,22649149,22649257,22649277,22649334,22649376,22649430,22649472,22649639,22650476,22650743,22650836,22650981,22651115,22651354,22651460,22651591,22651815,22651866,22652137,22652190,22652322,22652557,22652593,22652838,22653292,22653785,22653806,22653860,22653898,22654735,22654831,22654871,22658414,22658530,22662234,22662405,22665373,22669172,22669412,22671910,22673908,22675679,22681721,22681894,22685105,22687363,22689889,22693140,22695872,22699255,2269946', 'assoc_port': '22586330:22588158,22586332:22588051,22586334:22587551,22586336:22587798,22586338:22587293,22586340:22587190,22586342:22587438,22586344:22587407,22586346:22587481,22586348:22587114,22586350:22587266,22586352:22587001,22586354:22587038,22586356:22587074,22586358:22586747,22586360:22586465,22586362:22586429,22586364:22586933,22586366:22586568,22586368:22586540,22586369:22586652,22586370:22586602,22587967:22588201,22620307:22620968,22620308:22620803,22620309:22620677,22622202:22625351,22622203:22625181,22622204:22624959,22622205:22625005,22622206:22624778,22622207:22624351,22622208:22624130,22622209:22624311,22622210:22624498,22622211:22623615,22622212:22623881,22622214:22623714,22622215:22624258,22622217:22623366,22622218:22623932,22622220:22623476,22622221:22623498,22622223:22622830,22622225:22623230,22628074:22628889,22628075:22628627,22636854:22637008,22637612:22637735,22637613:22637798,22639893:22640299,22639894:22640184,22641644:22642626,22641645:22642418,22643295:22643505,22643944:22644118,22644453:2264469', 'assoc_mat': '22586330:pehd:4230:22588158,22586332:pehd:4230:22588051,22586334:pehd:4230:22587551,22586336:pehd:4230:22587798,22586338:pehd:4230:22587293,22586340:pehd:4230:22587190,22586342:pehd:4230:22587438,22586344:pehd:4230:22587407,22586346:pehd:4230:22587481,22586348:pehd:4230:22587114,22586350:pehd:4230:22587266,22586352:pehd:4230:22587001,22586354:pehd:4230:22587038,22586356:pehd:4230:22587074,22586358:pehd:4230:22586747,22586360:pehd:4230:22586465,22586362:pehd:4230:22586429,22586364:pehd:4230:22586933,22586366:pehd:4230:22586568,22586368:pehd:4230:22586540,22586369:pehd:4230:22586652,22586370:pehd:4230:22586602,22587967:pehd:4230:22588201,22620307:pehd:4230:22620968,22620308:pehd:4230:22620803,22620309:pehd:4230:22620677,22622202:pehd:4230:22625351,22622203:pehd:4230:22625181,22622204:pehd:4230:22624959,22622205:pehd:4230:22625005,22622206:pehd:4230:22624778,22622207:pehd:4230:22624351,22622208:pehd:4230:22624130,22622209:pehd:4230:22624311,22622210:pehd:4230:22624498,22622211:pehd:4230:22623615,22622212:pehd:42'}, {'unwanted_material': 'pet_clair', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.012383607118755463, 'nb_photo': 13460, 'list_port_cont': '22586421,22586462,22586528,22586574,22586613,22586651,22586748,22586934,22587007,22587031,22587078,22587111,22587191,22587267,22587299,22587408,22587424,22587486,22587544,22587796,22588052,22588170,22588207,22620683,22620789,22620966,22622832,22623228,22623364,22623466,22623496,22623613,22623719,22623879,22623936,22624138,22624256,22624305,22624348,22624497,22624779,22624965,22625000,22625187,22625355,22628632,22628888,22636994,22637733,22637795,22640172,22640308,22642409,22642634,22643503,22644126,22644693,22645864,22645907,22646388,22646953,22646991,22647346,22649150,22649256,22649281,22649335,22649370,22649425,22649473,22649644,22650470,22650746,22650847,22650985,22651113,22651348,22651461,22651587,22651814,22651881,22652147,22652188,22652329,22652559,22652596,22652842,22653296,22653792,22653799,22653864,22653900,22654725,22654833,22654864,22658411,22658520,22662238,22662404,22665364,22669178,22669408,22671903,22673905,22675683,22681732,22681876,22685094,22687366,22689880,22693138,22695861,22699258,2269946', 'assoc_port': '22586330:22588170,22586332:22588052,22586334:22587544,22586336:22587796,22586338:22587299,22586340:22587191,22586342:22587424,22586344:22587408,22586346:22587486,22586348:22587111,22586350:22587267,22586352:22587007,22586354:22587031,22586356:22587078,22586358:22586748,22586360:22586462,22586362:22586421,22586364:22586934,22586366:22586574,22586368:22586528,22586369:22586651,22586370:22586613,22587967:22588207,22620307:22620966,22620308:22620789,22620309:22620683,22622202:22625355,22622203:22625187,22622204:22624965,22622205:22625000,22622206:22624779,22622207:22624348,22622208:22624138,22622209:22624305,22622210:22624497,22622211:22623613,22622212:22623879,22622214:22623719,22622215:22624256,22622217:22623364,22622218:22623936,22622220:22623466,22622221:22623496,22622223:22622832,22622225:22623228,22628074:22628888,22628075:22628632,22636854:22636994,22637612:22637733,22637613:22637795,22639893:22640308,22639894:22640172,22641644:22642634,22641645:22642409,22643295:22643503,22643944:22644126,22644453:2264469', 'assoc_mat': '22586330:pet_clair:4230:22588170,22586332:pet_clair:4230:22588052,22586334:pet_clair:4230:22587544,22586336:pet_clair:4230:22587796,22586338:pet_clair:4230:22587299,22586340:pet_clair:4230:22587191,22586342:pet_clair:4230:22587424,22586344:pet_clair:4230:22587408,22586346:pet_clair:4230:22587486,22586348:pet_clair:4230:22587111,22586350:pet_clair:4230:22587267,22586352:pet_clair:4230:22587007,22586354:pet_clair:4230:22587031,22586356:pet_clair:4230:22587078,22586358:pet_clair:4230:22586748,22586360:pet_clair:4230:22586462,22586362:pet_clair:4230:22586421,22586364:pet_clair:4230:22586934,22586366:pet_clair:4230:22586574,22586368:pet_clair:4230:22586528,22586369:pet_clair:4230:22586651,22586370:pet_clair:4230:22586613,22587967:pet_clair:4230:22588207,22620307:pet_clair:4230:22620966,22620308:pet_clair:4230:22620789,22620309:pet_clair:4230:22620683,22622202:pet_clair:4230:22625355,22622203:pet_clair:4230:22625187,22622204:pet_clair:4230:22624965,22622205:pet_clair:4230:22625000,22622206:pet_clair:4230:22624779,2'}, {'unwanted_material': 'pet_fonce', 'main_material': 'incineration', 'pht_type': 4230, 'ratio': 0.006243708956658974, 'nb_photo': 1307, 'list_port_cont': '22586425,22586467,22586532,22586575,22586604,22586649,22586744,22586922,22587006,22587045,22587079,22587115,22587196,22587262,22587303,22587403,22587423,22587484,22587556,22587788,22588048,22588169,22588203,22620684,22620801,22620965,22622825,22623232,22623359,22623473,22623490,22623620,22623721,22623891,22623935,22624253,22624308,22624346,22624483,22624776,22624967,22625004,22625182,22625359,22628630,22628885,22637731,22637805,22640185,22640302,22642414,22642629,22643501,22644123,22644683,22645872,22645906,22646378,22646943,22646992,22647349,22649155,22649259,22649270,22649333,22649369,22649426,22649461,22649647,22650468,22650735,22650841,22650984,22651110,22651344,22651455,22651590,22651806,22651878,22652143,22652185,22652334,22652558,22652594,22652833,22653295,22653784,22653807,22653850,22653887,22654736,22654834,22654856,22658415,22658531,22662239,22662395,22665376,22669186,22671905,22673909,22675676,22681724,22681890,22685098,22687360,22689886,22693141,22695844,22699246,22699468,22699757,22699796,2269984', 'assoc_port': '22586330:22588169,22586332:22588048,22586334:22587556,22586336:22587788,22586338:22587303,22586340:22587196,22586342:22587423,22586344:22587403,22586346:22587484,22586348:22587115,22586350:22587262,22586352:22587006,22586354:22587045,22586356:22587079,22586358:22586744,22586360:22586467,22586362:22586425,22586364:22586922,22586366:22586575,22586368:22586532,22586369:22586649,22586370:22586604,22587967:22588203,22620307:22620965,22620308:22620801,22620309:22620684,22622202:22625359,22622203:22625182,22622204:22624967,22622205:22625004,22622206:22624776,22622207:22624346,22622209:22624308,22622210:22624483,22622211:22623620,22622212:22623891,22622214:22623721,22622215:22624253,22622217:22623359,22622218:22623935,22622220:22623473,22622221:22623490,22622223:22622825,22622225:22623232,22628074:22628885,22628075:22628630,22637612:22637731,22637613:22637805,22639893:22640302,22639894:22640185,22641644:22642629,22641645:22642414,22643295:22643501,22643944:22644123,22644453:22644683,22645697:22645872,22645698:2264590', 'assoc_mat': '22586330:pet_fonce:4230:22588169,22586332:pet_fonce:4230:22588048,22586334:pet_fonce:4230:22587556,22586336:pet_fonce:4230:22587788,22586338:pet_fonce:4230:22587303,22586340:pet_fonce:4230:22587196,22586342:pet_fonce:4230:22587423,22586344:pet_fonce:4230:22587403,22586346:pet_fonce:4230:22587484,22586348:pet_fonce:4230:22587115,22586350:pet_fonce:4230:22587262,22586352:pet_fonce:4230:22587006,22586354:pet_fonce:4230:22587045,22586356:pet_fonce:4230:22587079,22586358:pet_fonce:4230:22586744,22586360:pet_fonce:4230:22586467,22586362:pet_fonce:4230:22586425,22586364:pet_fonce:4230:22586922,22586366:pet_fonce:4230:22586575,22586368:pet_fonce:4230:22586532,22586369:pet_fonce:4230:22586649,22586370:pet_fonce:4230:22586604,22587967:pet_fonce:4230:22588203,22620307:pet_fonce:4230:22620965,22620308:pet_fonce:4230:22620801,22620309:pet_fonce:4230:22620684,22622202:pet_fonce:4230:22625359,22622203:pet_fonce:4230:22625182,22622204:pet_fonce:4230:22624967,22622205:pet_fonce:4230:22625004,22622206:pet_fonce:4230:22624776,2'}), 'main_stat': {'nb_photos': 1019}}, 'hostname': (), 'impurety_average_per_hashtag': [(('incineration', '2025-05', 0.5606945689739883),)]} filepath : /data_2/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_05_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', '3.05%', 17229], 'carton': ['carton', '12.49%', 74128], 'metal': ['metal', '0.18%', 1356], 'papier': ['papier', '30.09%', 220834], 'pehd': ['pehd', '1.23%', 4551], 'pet_clair': ['pet_clair', '1.24%', 13460], 'pet_fonce': ['pet_fonce', '0.62%', 1307]}} before organize_and_plot_impurety_average_data before organize_and_plot_quality_photo_data finish generating filepath : /data_2/data_log/job/memo/SCCU_cam8/sla_mensuel_SCCU_cam8_mois_05_annee_2025.pdf le fichier se trouve ici : /data_2/data_log/job/memo/SCCU_cam8 2.65user 2.73system 0:07.23elapsed 74%CPU (0avgtext+0avgdata 191608maxresident)k 25232inputs+280outputs (118major+67960minor)pagefaults 0swaps